What's wrong with my query?

ch2s
09-03-2005, 12:49 PM
I keep getting error "Too few parameters. Exptected 1" when I run this:
"UPDATE Users SET TrialExpired = True WHERE Trial = True And DateRegistered < #" & (Date - 5) & "#"

What's wrong with my query?

Thanks

McF
09-03-2005, 12:59 PM
I keep getting error "Too few parameters. Exptected 1" when I run this:
"UPDATE Users SET TrialExpired = True WHERE Trial = True And DateRegistered < #" & (Date - 5) & "#"

What's wrong with my query?

Thanks
One of your fields are blank or invalid. Look at your WHERE clause. Look at the DateRegistered in your query.

ch2s
09-03-2005, 01:03 PM
Nevermind, I had forgotten to add one of the feilds to the DB.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum