SQL Statement Problem 1

[iisman]

This is probably an obvious one, but i can not get this stmt to work...

SQL = "UPDATE outsidelinks SET outsidelinkurl = 'test.com', outsidelinkcount = '266', lastClickThru = '9/99/2999 8:00:00 PM' WHERE ID ="& linkid

The variable 'linkid' carries a numeric value, and I have tested it with response.writes to make sure that it has brought the correct value to this page.

Eventually, the values to be updated will be variables, but i just want to get this statement working correctly...

Thanks for any help you can provide

 

[r937]

access uses octothorps as its date string delimiters

lastClickThru = #9/99/2999 8:00:00 PM#

of course, that's not going to work because it's an invalid date, eh

r937.com | rudy.ca

 

[iisman]

Thanks for the quick response. I made that change, but still getting error "No value given for one or more required parameters."

SQL = "UPDATE outsidelinks SET outsidelinkurl = 'test.com', outsidelinkcount = '266', lastClickThru = #7/02/2005 8:00:00 PM# WHERE ID ="& linkid

I have tried the date with the ' ' around it as well, and same thing. does it need those? or just the #'s?

As I mentioned, I know that the linkId variable has a value, from testing with a response.write statement.

Any other ideas?

 

[r937]

try testing your query directly in access

r937.com | rudy.ca

 

[iisman]

Thanks for the help, got 'er all working. turned out that one of the col names was mixed up