Re: SQL syntax

[Frank Caruso]

** You did not mention what database you are using but you might want to put either single or double quotes around your $ variables.

I'll assume since I see the ";" at the end that you are on Oracle. Try:

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

Keep in mind that your a re pointing  at the tables and the table number may not be the same from prod to dev to staging. You might try using the View names instead.

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

**

Hi,

 

 

I am trying to update a field (C535478792) with the values on the screen from the field $Secondary email$ and pushed directly via SQL into the Help Desk case record I am currently in.

 

Is this syntax correct?

 

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

__20060125_______________________This posting was submitted with HTML in it___

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