Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Westond
  • Order by date
  1. Westond

    Select number of occurrences from join table

    1 more question. This query will work but the Status I am looking for is contained in a lookup table called User_Status. Is there a way I can use the values in the Lookup Table and not have to hard code them in to the query like this? Select t1.*, (select count(Training_ID)from...
  2. Westond

    Select number of occurrences from join table

    Thanks guys I see how it works now : ). I have only used Correlated Subqueries in where clause mainly using IN. Didn't know it works in the Select like that. thanks
  3. Westond

    Select number of occurrences from join table

    haha no this is not homework. I know how to join tables that is no problem, I dont want all the info from the second table and I dont want to have to use 2 queries to get the info. Select info from table1 where.. select count(StudentID) From table2 where StudientID = 1 I want all the data...
  4. Westond

    Select number of occurrences from join table

    Here is my table structure: StudentID First Last 1 John Doe 2 Jane Doe ClassID StudentID Instructor Time 1 1 fsd 11:00 2 1 asf 12:00 3 2 jkl 12:00 I...
  5. Westond

    get records from 2 databases

    I have 2 databases "A" and "b" they are both on the same server. They are seperate applications except I would like for database b to be able to access the user record in database a. Database b has some userid values that match the database a users table which has all the names and user info...
  6. Westond

    TreeView

    thanks for your help vbkris. I have 1 last problem, I see how it works in the code you displayed. My problem is I have an unknown lvl in the tree. The user is able to add more lvls so I wouldn't be able to dim parent, child, lvl because it could be parent, child, lvl, lvl2, lvl3.... There...
  7. Westond

    What do I need to use Crystal Reports?

    What do I need in order to use crystal reports in my web apps? Do i have to have a server version of crystal? When I compile my we app does a link to the report work without asking the user to download the report? I have not been able to link to a report on my local using the debugger why...
  8. Westond

    TreeView

    I am tring to get all the information into a treeview so it is not actually displayed as I put it above with the "-".
  9. Westond

    TreeView

    I have a page that needs to have a treeview that is populated from a database. Below is a little bit of code that i have been playing with. I would like the data in the hashtables to look like this if it were to work correctly. Parent1 - Child 1 - Lvl 1 Parent2 - Child 2 - Lvl 2...
  10. Westond

    Windows will not load?..

    When I start windows it comes to the page that says windows xp pro and has a bar that keeps going accross. It never gets past that point, the hard drive light stops blinking also. Safemode will load just fine adn I have tried to do a rollback there but it did not work. I have also tried to...
  11. Westond

    Site search without database?

    Is it possible to have a search box on my site without having to use a database? Where can I find some information on this? THANKS!
    • Westond
    • Thread
    • Replies: 3
    • Forum: PHP
  12. Westond

    Object reference not set to an instance of an object.

    What causes this error? Here is an example that will cuase it. I have a listbox and when someone clicks on a entry in the listbox I tried to do: string x; x = listbox1.SelectedValue.ToString(); I am tring to understand the general rule on this because I come across it alot. Thanks for any...
  13. Westond

    Dev Environment question

    In VB you can select a dropdown the top left then the one on the right will display all the available event handlers for that object. I really like C# syntax but those dropdowns at the top are almost useless in c#?.. Is there a way to get the same functionality there as you get in vb? How do...
  14. Westond

    SP Pass Values into another query

    SELECT AVG(field1 + field2) as theAverage FROM table WHERE .... UPDATE Table SET Field = theAverage where .... Why doesn't this work?
  15. Westond

    Read a datatable

    Hey guys, I have a dt in c# and all I am tring to do is read the records out of it.?? label1 = dt.Rows[0].Table.Column["field"]; something like that .. How do I get the value of "field" to display in the label? Thanks Wes
  16. Westond

    Assign query result to variable

    Here is basically what I have: @in_1 @in_2 if exists(Select x as value from table) BEGIN Here I want to be able to say @in_1 = value but it doesn't work? says invalid column name? I also tried using the variable in place of value in the select but that didnt work either. END...
  17. Westond

    Debugger does not show styles or images

    Here is my structure: wwwroot/site - in this folder I have .CSS files, an Images folder ect. wwwroot/site/paSystem - in this folder I have a .NET module I am working on. If I run the debugger for wwwroot/site/newSystem it browses to http://localhost:4829/paSystem/file.aspx so the debugger...
  18. Westond

    Stored Procedure check for recordcount

    Thanks guys that will work perfectly : D
  19. Westond

    Stored Procedure check for recordcount

    I have a stored proc and what I would like to do is run a select query then based on the recordcount insert or edit. SELECT * FROM Table if recordcount = 1 UPDATE Table set x = 1 WHERE... else INSERT INTO Table ()VALUES() THANKS Wes
  20. Westond

    Need Basic Tutorial Site

    Have you tried www.codeproject.com

Part and Inventory Search

Back
Top