Re: Why must I quote fields now?

2002-10-14 Thread Arthur Fuller
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

re: Why must I quote fields now?

2002-10-14 Thread Victoria Reznichenko
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

Why must I quote fields now?

2002-10-14 Thread olinux
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