Help on SQL SYNTAX

Posted in 2004

naga raj — Thu, 08 Apr 2004 13:55:05 — source: IIUG Forums & Mailing Lists

Hi All, Iam running this sql on a informix SQL editor. Select * from ps_employees where emplid='110111' and empl_rcd#=0; Its says illigal charecter "#" used in the sql query. empl_rcd# is a numeric field name in the table. I don't know why this error is coming. Can anyone let me know the right syntax. Thanks in advance -Nagas. _________________________________________________________________ BharatMatrimony.com. http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?72 The No 1 Indian matrimony.

↪ replying to naga raj

SANTIAGO PERALES — Mon, 12 Apr 2004 20:58:47 — source: IIUG Forums & Mailing Lists

Try with this... Select * from ps_employees where emplid='110111' and 'empl_rcd#'=0; I hope this work..

↪ replying to SANTIAGO PERALES

Jonathan Leffler — Tue, 13 Apr 2004 00:50:26 — source: IIUG Forums & Mailing Lists

I'm sorry - that won't work for reasons I detailed last week. The "empl_rcd#" would have to be enclosed in double quotes - and DELIMIDENT set in the environment. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 04/12/2004 01:58:47 PM: > Try with this... > > Select * from ps_employees where emplid='110111' and 'empl_rcd#'=0;> > I hope this work.. >