Re: SQL Syntax

[Frank Caruso]

** Not sure where you ar running this from - Remedy, oracle, sqlplus... but it is complaining about the semi-colon. If you are in Remedy I think you can remove it.

On 9/7/06, Koyb P. Liabt <[EMAIL PROTECTED]> wrote:

Hi,

I am trying to pass a value into a field on HPD:Helpdesk, and make  sure it
only updates the current record open.  I met with the dba,  referenced database
guide, and I have this command below, however I am getting  failure during
SQL operation - invalid character.

Does anybody know what is wrong with the syntax below:

update T418 set C535478792 = '$Secondary email$' where  C1 = '$Case ID+$';
update T418 set C535478792 = "$Secondary email$" where C1 = "$Case  ID+$";

update T418 set C535478792 = $Secondary email$ where C1 = $Case ID+$;


ARERR [552] Failure during SQL operation to the database : ORA-00911:
invalid character

-----------------
Forwarded Message:

       Subj: Re: SQL syntax   Date: 9/6/2006 5:04:09 P.M. Eastern Standard
Time  From: [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])   Reply-to:

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___