[thelist] ASP using SQL but anoing me like $%&#

[aardvark]

> 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'...