 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Ingres Topics / August 2004[Info-Ingres] Update SQL stmt
Hello, Does the presence of any of these characters $ {} / . _ in an update set string require special handling? I'm getting an end quote missing error when I try something like: update t set r='${xxx}' where r='/_drive_f/6.0/';\g Cheers! Mike ========================================= This GroupWise e-mail message was scanned using Beginfinite's Guinevere Antivirus program and F-Prot Antivirus software. The virus definitions used by F-Prot to block e-mail viruses are updated on a regular basis, thus insuring that no e-mail is infected. Should you have any questions about the content of this e-mail, or are not the intended recipient, please contact the Rodem e-mail Administrator at this address: admin@rodem.com. ========================================= Hi, I just tried it: $ sql sdmsdb INGRES TERMINAL MONITOR Copyright 2003 Computer Associates Intl, Inc. Ingres Linux Version II 2.6/0305 (int.lnx/00) login Fri Aug 20 06:09:04 2004 continue * create table t ( r varchar(30) not null);\g Executing . . . continue * update t set r='${xxx}' where r='/_drive_f/6.0/';\g Executing . . . (0 rows) continue didn't have a problem. Maybe you can be more specific about your problem? Ronald > Hello, > [quoted text clipped - 23 lines] > address: admin@rodem.com. > ========================================>  SignatureindependIT Integrative Technologies GmbH Sitz der Gesellschaft: Schrobenhausen HRB Neuburg B 1.521 Geschäftsführer: Dieter Stubler, Dipl. Inform. (FH) Ronald Jeninga, Diplom Mathematiker If you are running this in a shell script, then yes some of those chars need special handling, preceed with a \ > Does the presence of any of these characters $ {} / . _ in an update > set string require special handling? > > I'm getting an end quote missing error when I try something like: > > update t set r='${xxx}' where r='/_drive_f/6.0/';\g SignatureNick -----We Solve your Computer Problems--- Founder & Listowner of the Prolifics User Group Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly I'm running this at the * prompt. I modified the set stmt to read set r='${xxx}/application6.0' which works for my purposes and did the trick. Mike >>> Nick Upson <news1@upsonuk.com> 08/20/04 02:48AM >>> If you are running this in a shell script, then yes some of those chars need special handling, preceed with a \ In article <mailman.77.1092951234.645.info-ingres@ams.org>, Mike Ossing wrote: > Does the presence of any of these characters $ {} / . _ in an update > set string require special handling? > > I'm getting an end quote missing error when I try something like: > > update t set r='${xxx}' where r='/_drive_f/6.0/';\g SignatureNick -----We Solve your Computer Problems--- Founder & Listowner of the Prolifics User Group Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly _______________________________________________ Info-ingres mailing list ========================================= This GroupWise e-mail message was scanned using Beginfinite's Guinevere Antivirus program and F-Prot Antivirus software. The virus definitions used by F-Prot to block e-mail viruses are updated on a regular basis, thus insuring that no e-mail is infected. Should you have any questions about the content of this e-mail, or are not the intended recipient, please contact the Rodem e-mail Administrator at this address: admin@rodem.com. ========================================= |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.