It's always a bad idea to name your columns using keywords.
- Original Message -
From: "olinux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 5:42 AM
Subject: Why must I quote fields now?
> Hi all,
>
> I have just a
olinux,
Monday, October 14, 2002, 12:42:21 PM, you wrote:
o> I have just added a field (order) to a table with
o> about 12,000 records.
o> Now I cannot select or insert unless I quote the field
o> names in the query
o> i.e. This returns - you have an error near 'order ...'
o> SELECT
o>
id,pu
Hi all,
I have just added a field (order) to a table with
about 12,000 records.
Now I cannot select or insert unless I quote the field
names in the query
i.e. This returns - you have an error near 'order ...'
SELECT
id,pub_date,last_update,type,region,author,title,summary,content,keywords,fil