Search results for query: *

Thank you!

Can someone help me get this right? I'm trying to count the number of records in a SELECT but I'm doing something wrong - the result is just "". TIA! - David Cook If Rally = "Russia" Then SQLStmtC = "SELECT Count(*) As Cnt FROM stimes2 WHERE Name = '" & Name &...

I've got a website that allows drivers of a new racing title called Rally Trophy the ability to post their record stage times and compare with others at http://www.rtrank.com The site and even the domain were donated so everything is free. We currently have about 150 drivers from 25+ countries...

Thanks! That worked like a charm :)

...So with the 2nd option you describe above I could use just one form to add or update a record, correct? If the recordset returns empty I could use code to add and if it's already got a record I could use code that updates(?) Heading over to ASPFAQ's right now! David Cook

When a user attempts to add a record to my database via asp if there is already a record they get the following message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because...

Perfect! Thanks - I will put a link to your site on the bottom of mine as a token of my appreciation. -David Cook

Ooh, just noticed one thing. Do you know how I can avoid the dreaded EOF if someone chooses a country that doesn't have any records? Head over to www.ftmyers.com/scripts/rtrank_test.asp and choose Albania and you'll see. -David Cook

It WORKS!!! Thank you SO much :D Send me an address where you hang and I'll order you a pizza from your local Pizza Hut! Serious - I did this for Andrew Tridgell and the Canberra Linux User Group in Australia for the work they did on Samba. Thanks again! -David Cook

...Just to let you know - Paging works - Just not when I use the data from the form. If you look at http://www.ftmyers.com/scripts/rtrank.asp you can see that the code works fine if I'm not trying to pull results from a POST. Thanks for your help. I look forward to getting this working...

Todd - I removed the code that attempted to pass the data beyond page one because I couldn't get it to work. Below is the page with the form dropdown for Countries (use Finland for this test). I may have the syntax wrong for Finland as well, but I'm not sure. When a user selects a Country...

I have a form that lists countries. The user selects his country and the post action calls an asp page that displays the first 25 records of the recordset. When I click the hyperlink to take me to the next page the form data is gone and I get an EOF. I've read the article on Microsoft Q175167...