SQL Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J-P-W - 01 Oct 2007 21:59 GMT

Hi,

My ASP page is accessed from a form, the aim is to update a record.

The SQL generated is:

UPDATE tblSales SET ItemDescription='Seven',
ItemBriefDescription='Sev', ItemCost=0, ItemPhotoURL='', Current='No'
WHERE ItemID=7;

On the web server I get an error "Syntax error in UPDATE statement."

I've used the same sql string in access - no error.
I've used Jeff Key's Access Query Analyzer and get an error.....

But I can't spot the error - can you? [please]

Thanks

Jon

Reply to this Message

Bob Barrows [MVP] - 01 Oct 2007 22:12 GMT

> Hi,
>
[quoted text clipped - 10 lines]
> I've used the same sql string in access - no error.
> I've used Jeff Key's Access Query Analyzer and get an error.....

Perhaps a reserved keyword? My guess would be Current. Try surrounding
it with brackets []

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

J-P-W - 02 Oct 2007 09:41 GMT

> > Hi,
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Thanks Bob, as my head hit the pillow (sad!!!) I wondered the same
thing - you're right.

Regards

Jon

Reply to this Message

Webmaster Forum / ASP / Database Access / October 2007

SQL Error