Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 19038 invoked from network); 10 May 2004 07:56:30 -0000 Received: from unknown (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 10 May 2004 07:56:30 -0000 Received: (qmail 93586 invoked by uid 500); 10 May 2004 07:56:21 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 93328 invoked by uid 500); 10 May 2004 07:56:18 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 93166 invoked by uid 98); 10 May 2004 07:56:16 -0000 Received: from Fischer@seitenbau.net by hermes.apache.org by uid 82 with qmail-scanner-1.20 (clamuko: 0.70. Clear:RC:0(194.175.229.106):. Processed in 0.071525 secs); 10 May 2004 07:56:16 -0000 X-Qmail-Scanner-Mail-From: Fischer@seitenbau.net via hermes.apache.org X-Qmail-Scanner: 1.20 (Clear:RC:0(194.175.229.106):. Processed in 0.071525 secs) Received: from unknown (HELO mail.seitenbau.net) (194.175.229.106) by hermes.apache.org with SMTP; 10 May 2004 07:56:15 -0000 Received: from [195.127.188.18] (helo=www.seitenbau.net) by mail.seitenbau.net with esmtp (Exim 4.22) id 1BN4Y8-0004Gr-Bi for torque-user@db.apache.org; Mon, 10 May 2004 08:46:04 +0200 In-Reply-To: Subject: RE: missing comma error during sql insert To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: From: Thomas Fischer Date: Mon, 10 May 2004 08:46:03 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.0.3|September 18, 2003) at 10.05.2004 08:46:03 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Scan-Signature: 615bbb4f4baf834837bb1879b92e595c X-Spam-Rating: hermes.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi dir, I tried to reproduce your error by inserting a single quote in a varchar-field on an Oracle-Database and it worked. The fact that Torque tried to escape the single quote with a backslash rather than with a second single quote could be explained if torque doesn't know you are using an oracle database. Did you specify the property torque.database.nameofdatabase.adapter=oracle in your torque.properties? (of course replacing nameofdatabase with your database name) Cheers, Thomas schrieb am 07.05.2004 15:27:21: > > > > > Hi > > Iam new to torque > when evere if u try to insert string data containing single quote > > Say ' don't' it gives missing comma as expected > > How to avoid this > > Error i got during insert > > [torque-sql-exec] Failed to execute: INSERT INTO Node > (id,isform,parentid,descri > ption,haschildren,ownerid,createddate,modifieddate,delstatus, > workflowstatus,node > typeid,lltypeid,wfdefid) VALUES (165,1,112,'Trying to edit a downloaded > pts-file > I get a message, that my macro execution security settings don\'t allow > that. W > hat do I do?',0,13,to_date('2001-02-12','yyyy-mm-dd > hh:mi:ss'),to_date('2002-04- > 24','yyyy-mm-dd hh:mi:ss'),0,30,3,1,1) > [torque-sql-exec] java.sql.SQLException: ORA-00917: missing comma > > > please help me > > Thanks > Jayaprakash > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org