Using UPDATE in SQL

[bellmd]

There is a problem with this SQL statement. The problem is with the set command, with only one value to change it will work fine, but with more than one it returns an error.

UPDATE blank_date
SET name='Matthew' and telephone='678' and e-mail='matthew@sexycooking.co.uk'
WHERE (date = #3-Jan-2001#) or (date = #4-Jan-2001#) or (date = #5-Jan-2001#)

Please, please somebody help

 

[link9]

UPDATE blank_date
SET name='Matthew' and telephone='678' and e-mail='matthew@sexycooking.co.uk'

should be:

UPDATE blank_date
SET
(name='Matthew', telephone='678', e-mail='matthew@sexycooking.co.uk')

good luck!
Paul Prewett

 

[bellmd]

I've tried that but it still won't work.

 

[link9]

What's the error message along with the complete SQL statement that's throwing it?

 

[bellmd]

The SQL statement at the top of the list gives the error message;

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

 

[link9]

Well, you should definitely be using commas instead of 'and' to put the different values together, and the parens I suggested couldn't hurt, either.

Does it give the same message if you use what I suggested, or does the error message change?

You might also try enclosing the e-mail column name in brackets

[e-mail] <-- it might be trying to evaluate that as an arithmetic operator. FYI -- you might want to change the name of that field to email rather than 'e-mail' to eliminate the confusion.

lemme know -
paul

 

[bellmd]

Having now tried all possible combinations of the above, I have got it to work using the statement below;

update blank_date 
set name='Matthew', telephone='678', email='matthew@sexycooking.co.uk' 
where (date = #7-Jan-2001#) or (date = #8-Jan-2001#)

Changing e-mail to email was a good tip, I think if it had not been for that it would have been an easily solved problem, because I tried the above statement but with e-mail rather than email and it gave an error. Cheers