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!

  • Congratulations Mike Lewis 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: *

  1. skypanther

    Unexpected reboot during hardware detection

    Thanks for the response. I cannot find a detlog.txt file on my system. My system log was corrupted. I had to disable the service, delete the file, restart it, then try connecting the camera. Here's the sequence of events: 1. Plug the USB cable into the camera, turn it on 2. New Hardware Found...
  2. skypanther

    Unexpected reboot during hardware detection

    I'm having problems with my Win2K SP4 system rebooting on me during hardware detection. It first happened when I installed a new 160 GB hard drive. Applying Maxtor's large hard drive OS patch seemed to fix the problem. Well, yesterday I tried installing the software for my Nikon digital camera...
  3. skypanther

    TimeStamp issue in SQL

    Try simply dividing mins/30 For mins less than 30, you get a a fraction less than 1. For mins equal 30, you get 1. For mins greater than 30, you get a fraction greater than 1. So, build your logic with: if(mins/30 <= 1) // first half of hour else if(mins/30 > 1) // second half of hour...
  4. skypanther

    Append query with static and SELECT-generated values

    Hi Greg, Thanks for offering the suggestion. I tried that and it didn't work. But, I did just come up with a solution to my own problem. I found I can use a subquery to accomplish what I need INSERT INTO orderItems (itemID, quantity, size, logoID, color, orderNum) SELECT itemID, quantity...
  5. skypanther

    SELECT statement in SELECT statement?

    Are these different problem states being stored in separate tables or all in one? Why can't you just do this? SELECT problemID, state1timestamp, state2timestamp, state3timestamp FROM problemsTable WHERE problemID = someID If this won't work, please post a description of your table(s) and the...
  6. skypanther

    Append query with static and SELECT-generated values

    I'm building custom shopping cart application and I'm stuck on a piece of SQL. I gather the various items people want to buy into a cart table in my database. Once they've gone through the checkout process and are ready to pay, I need to move their cart items to an order items table (for later...

Part and Inventory Search

Back
Top