Search results for query: *

Hello, I'm trying to populate 3 drop down exactly the same from each other but select name and option value. I found a simple javascript works fine for my demand; however, unable to make it work once I combo the select list. Below is what I have changed and no longer work correctly when changed...

Thank you B.Borissov, you rock!!!

Nevermind, this works, SELECT idCPBPS, idCustomer FROM tblCPBPS WHERE idCustomer IN (SELECT idCustomer FROM tblCPBPS WHERE quoteStatus='Sale Order' GROUP BY idCustomer HAVING COUNT(*) > 3) ORDER BY idCustomer DESC However, it doesn't return the most recent 3 records of each customer. My...

Hello, My goal is: search for all customers custID with MORE THAN 3 orders. AND then in the same tblOrderRecords, I'd like query to return the more recently 3 records of each of the customers from the first outputs. I'm running this query but it returns all records: SELECT orderID, dteDate...

You are totally right. I actually do want to ask about mysql but can't locate the forum in here so I thought this MS SQL is closed enough, am I way off? I'm writing the script within ASP environment, but I doubt that the people in that forum would appreciate the question any better. Please...

hi all, I'm looking for a way to catch MySQL db connection error before Godaddy throws me a error page that return no helpful error info at all. What the error particular is that I'd like to check whether a database is currently available on the server of not and return a error message or move...

Hi, I'm looking for a way to NEVER expired logon user(s) until they log out or close the page themselves. In my header, I have Session.Timeout=1440 and also, in my global.asa, I included Sub Session_OnStart Session.Timeout = 1440 Session("Start") = Now Application.Lock ... End Sub But...

The SELECT is against the db itself, no problem there. I understand there are many different ways to select from db and utilizing an array. From what I have had, can you tell me the faster or optimum way to run 9000+ records. I understand this is ASP forum so let just focus into the SELECT...

Hi all, I'm working on a autocomplete/autosuggest box to search for a member in my mssql database ( >9000 records ) and succeed doing so. My only problem is load time get up to almost 10 sec every time the page loads. Basically, - I opened db and saved the table to GetRows(). - Run the array...

Please help me verify the query as you mentioned because I, now, cannot test it because Godaddy server is down somehow. update tblCustomerThreads SET UserID = tblContacts.idSalePerson, idCustomer = tblContacts.idCustomer FROM tblCustomerThreads LEFT JOIN tblContacts ON...

Hello, I'm trying to update a table with this query but doesn't seem to work at all update tblCustomerThreads SET UserID = tblContacts.idSalePerson, idCustomer = tblContacts.idCustomer from tblCustomerThreads, tblContacts WHERE tblCustomerThreads.idGoldMine LIKE %tblContacts.idGoldMine% The...

Thank you Steve, In my case, the website is not hosted locally, so how can I attach directly to the Outlook libraries? do you (or anyone else) suppose Godaddy has that option included? Or maybe I should check with them directly. After so much thought, I start to believe that maybe this is...

Hi all, I'm looking for a stored procedure to automatically check for expiration date and send STMP email when the date matched. I am working with MS Access 2007 and ASP. So far, my obstacle is how to send the email if the requirement meet. Thank you for any input.

I found a fix for the query on the above (similar to Duane mentioned). In case anyone interested, here is the fix: UPDATE RMA " _ & " SET UserID = " _ & " IIF(UserID=1, 9, " _ & " IIF(UserID=6, 12, " _ & " IIF(UserID=7, 19, " _ & " IIF(UserID=8, 16, " _ & " IIF(UserID=9, 14, " _ & "...

Hi all, I have a need to link my database to another database's USERS table where ID#s are totally different from the current one. The goal now is that I will need to update a couple of tables which linked to the USERS.USERID with the new IDs from the new USERS table. Here is what I got...

Thank you markros for your reply. The error has gone way, but result is not as I expected (due to my fault of setting up the query). I will need to have another query to get the right result, and will come back here later if anymore help is acquired. Thanks again.

Hello, I had this query works for MS SQL, but getting error running it for Access DB. "SELECT pgRMAprods.prodSerialNo, " _ & " SUM(CASE WHEN pgProducts.prodType='DVR' THEN pgRMAprods.itemQty END) AS countDVR, " _ & " pgProducts.prodDesc " _ & "FROM pgRMAprods " _ & "INNER JOIN pgProducts " _...

Nevermind, I could just kick myself for this stupid mistake. Basically, I called to display the shipping State instead of the billing State. The change was made but I didn't notice until now. Sorry all for this waste of space. :-)

hello, I nned help to find out what wrong with this code of mine. Basically, I need to dropdown box of USA states to match and selected a given state I entered. So far, I'd be able to match and get the right selectedIndex.value to alert, but cannot make the select box to change to the given...

Hello, I found this tutorial and would like to change it to my requirements <script> /* This script is identical to the above JavaScript function. */ var ct = 1; function new_link() { ct++; var div1 = document.createElement('div'); div1.id = ct; // link...