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
