Search results for query: *

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

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

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

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

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

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&quot; I forgot to...

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

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

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