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 dencom 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: kkffjjman
  • Content: Threads
  • Order by date
  1. kkffjjman

    drop, and rebuild table, or delete all rows?

    I have an application that tracks a weekly SLA for something, and resets at the end of the week. the table used is ONLY used for that, and so, we need to essentially empty the table at the end of the week. (Sunday midnight) Question - which is better (for size and performance) a) - just...
  2. kkffjjman

    Select Disticnt - Help Me Optimize this Query

    I'm wondering if this is set up in the best way. Basically I need contact_email, contact_name, contact_id, but no duplicates for contact_email ONLY. IE - I WANT the record if it has the same NAME as another, but has a different email...and so on... msql = "SELECT distinct contact_email...
  3. kkffjjman

    Get Value from txt Input onBlur

    I have an input box where the user enters a sku. When this has been entered, and the cursor leaves the input box, I need to pop up a window with a new url that includes the sku Any ideas?
  4. kkffjjman

    count(*) using WHERE argument from separate tables?

    Hello Everyone, I need to build a query and I'm having a terrible time getting my head around it. Here are the details of the tables: Table1: MESSAGES Table2: FOLDERS Each message, in the messages table is assigned a folder by FOLDER_ID. I want to count messages in the MESSAGES table that...
  5. kkffjjman

    count(*) using WHERE criteria from separate tables?

    Hello Everyone, I need to build a query and I'm having a terrible time getting my head around it. Here are the details of the tables: Table1: MESSAGES Table2: FOLDERS Each message, in the messages table is assigned a folder by FOLDER_ID. I want to count messages in the MESSAGES table that...

Part and Inventory Search

Back
Top