Totally Stumped

[illdill]

Using FP2003 against ACCESS

UPDATE registration
SET regName='::regName::', regType='::regType::', specEvent='::specEvent::', friDinner='::friDinner::', satDinner='::satDinner::', vegetarianCouples='::vegetarianCouples::', vegetarian='::vegetarian::', specialReq='::specialReq::'
WHERE ID='::ID::'

Will not work

Here is a screenshot of the table to show that the spelling is correct. I must have done this a hundred times, but for some reason this query just doesn't want to work...

http://illdill.org/Atheists/Convention/query.htm

Thanks!

 

[illdill]

Nevermind

I turned on DEBUG and it was an s-columns error. I havn't had that since upgrading to 2003 until now. Weird...

I was able to get it to take by changing the :: to %% even though it changes it back.