[thelist] ASP using SQL but anoing me like $%&#
aardvark
roselli at earthlink.net
Sun Jan 28 17:54:31 CST 2001
> From: "Elfur Logadottir" <elfur at lists.evolt.org>
[...]
> But that still throws an error, and when using access,
> creating a query containing only the SQL statement, it stops
> on the 'order' part in the first parenthesis, claiming
> 'syntax error'
>
> when I leave out the fourth column (order; '1'), access
> agrees and accepts the addition <sigh>
> So now I'm closer to the truth, but still having problems.
'order' is a reserved word... if possible, rename your column... if you
can't, i can't remember off the top of my head how to delineate a
word to allow you to use a reserved word... might be quotes,
dunno...
but you can't use 'order'...
More information about the thelist
mailing list