Posted by Charles Keepax on 08/10/05 17:03

Thanks for your replies, sorted my problem.

Charles

"Michael Phipps" <gravityspike_spamfree_@optusnet.com.au> wrote in message
news:42f9ed0f$0$29041$afc38c87@news.optusnet.com.au...
>> "CREATE TABLE enquiries (id int(6) NOT NULL auto_increment,name
>> varchar(80) NOT NULL,email varchar(80) NOT NULL,company varchar(80) NOT
>> NULL,telephone varchar(80) NOT NULL,country varchar(80) NOT NULL,city
>> varchar(80) NOT NULL,organisation varchar(80) NOT NULL,problem
>> varchar(120) NOT NULL,sector varchar(80) NOT NULL,technology varchar(80)
>> NOT NULL,desc blob NOT NULL,files blob NOT NULL,PRIMARY KEY (id),UNIQUE
>> id (id),KEY id_2 (id))"
>> and I get the response,
>> " Invalid query: You have an error in your SQL syntax near 'desc blob NOT
>> NULL,files blob NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 ' at
>> line 1 ".
>>
>> Does anyone have any idea what I could be doing wrong? If I remove the
>> blob entries it works.
>
> SQL isn't my forte - but I'll take a guess:
>
> Can you use "desc" as a field name? isn't it a reserved word? As in
> ...order by xxx desc;
>
>
>
>
>
>

[Back to original message]