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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
Hi! I sometimes (perhaps 2 out of 10 times) get the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1. However, if I refresh the webpage the error disapears. I use the following SQL...- Rally2002
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Download multiple files
Hi! I am using a free web hosting service (Brinkster) for my webpage. The service provides a web based file manager in order to upload and download files. Unfortunately, the file manager only allows you to download one file at a time. I started to write some ASP and JS code to allow multiple...- Rally2002
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Get 'Too few parameters' errors sometimes
Hi! Sometimes I get an "Too few parameters" error when trying to access an database. I have read in this forum that other users have experienced this too. However, I only get this error about 1 out of 10 times. When the error occurs, it sufficient to reload the page and the error goes...- Rally2002
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
XMLHTTP timeout
Hi! THE PROBLEM I'm using ms.xmlhttp on my website to retrieve some information from another webpage on the Internet. If the other webpage isn't available (or is very slow), my webpage will suffer. SOLUTION 1. Setup the xmlhttp request 2. Send the request 3. Wait for response OR continue... -
XMLHTTP timeout
Hi! THE PROBLEM I'm using ms.xmlhttp on my website to retrieve some information from another webpage on the Internet. If the other webpage isn't available (or is very slow), my webpage will suffer. SOLUTION 1. Setup the xmlhttp request 2. Send the request 3. Wait for response OR continue...- Rally2002
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
Combine results from the same table
I was a bit hasty sending my previous posting. Here is the correct SQL-statement: SELECT t1.id, t1.date, t1.ip, t1.user, IIf(t1.user<>'','',(SELECT top 1 t2.user FROM counter t2 WHERE t2.ip = t1.ip AND t2.user<>'' ORDER BY id DESC)) AS lookup FROM counter t1 ORDER BY id DESC" I forgot to... -
Combine results from the same table
I did some more tests and came up with a working syntax in MS Access: SELECT t1.id, t1.ip, t1.user, IIf(t1.user<>'','',(select top 1 user from counter sq where sq.ip = t1.ip ORDER BY id DESC)) FROM counter t1 ORDER BY id DESC -
Combine results from the same table
Thanks for healping me out! I'm rather a beginner when it comes to SQL so it was nice to learn something new. I didn't know it was possible to use such things as CASE. I tried to test your solution using MS Access 2000 but got a syntax error (missing operator) in the following part: (CASE when... -
Combine results from the same table
Hi! BACKGROUND I have a table containing user information on my web server. This is an example: ID IP DATE USER --------------------------------------------- 1 123.123.123.123 2002/04/24 10:05 Peter 2 234.234.234.234 2002/04/23 09:15 3 321.321.321.321...
