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...

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...

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...

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...

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...

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.

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...

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 " _...

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...

Hello, I'm having this script to activate Window virtual keyboard Dim oShell Set oShell = CreateObject("WScript.Shell") oShell.Run("C:\WINDOWS\SYSTEM32\osk.exe") Set oShell = Nothing No error, but keyboard activate at all. I know the execute file works because I can go directly to the file...

Hello, I just cannot get this error out of the way: Operation is not allowed when the object is closed. And here is my code: ConnStr = "Driver={Microsoft Excel Driver (*.xls)};" & _ "DriverId=790;" & _ "Dbq="&Server.MapPath("/excel/Book1.xlsx") & _...

Hello, I'm having this problem query searching for date range SELECT * FROM myTable WHERE DatePurchased = '8/8/2010' ORDER BY ID Desc and here is the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria...

Hi, Is there a way to make this query shorter or more importantly, make it more efficiency sql = "SELECT TOP 1 SUM(a.numTotalPt) AS tMonthlyPt " _ & "FROM tblCPBPS a " _ & "INNER JOIN tblUsers b " _ & " ON a.idUser = b.UserID " _ & "WHERE a.dtAddDate LIKE '" & gMonth & "%" & gYear & "%' " _...

Hi all, Can this query be any shorter or better, please help sql = "SELECT " _ & " (SELECT SUM(moneySaleTotal) FROM tblCPBPS " _ & " WHERE idCPBPScat = 1 " _ & " AND idUser <> 4 " _ & " AND dtAddDate LIKE '" & gMonth & "%" & gYear & "%' " _ & " AND custType = 'Reseller') AS...

Hi all, here's my test nowTime = FormatDateTime(Now,3) response.write "NOW: " & nowTime & "<BR>" response.End() my localhost return for ex: 9:00 AM, while testing with website host by Godaddy returns 10:00 AM (1 hour different). Why? and how can I sync this. thanks!

Could someone help me convert this into a function that I can use/call, my knowledge of js is very limited. <script language="javascript" for="PlaybackCtrl" event="ErrorReceived(errorCode, param)"> // program additional ------------------------------------------------- var PB_ERR_CONNECT_FAIL...

hi all, I'm having this added code to have a little more controlled files download environment; however, error "File Not Found" window displayed when I try to download ZIP files while PDF files are a OK. Here's the code Response.Buffer = True Response.Clear ''set the directory that...

Hello all, I'm not a dotnet user and I'm having a problem changing a root file location to MapPath type from this code I found <%@ Import Namespace="System.IO"%> <html> <head> <title>File Download</title> <script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs)...