Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 34726 invoked from network); 8 May 2004 16:36:30 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 8 May 2004 16:36:30 -0000 Received: (qmail 75071 invoked by uid 500); 8 May 2004 16:36:20 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 75063 invoked by uid 500); 8 May 2004 16:36:20 -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 91119 invoked from network); 7 May 2004 19:33:01 -0000 From: Date: Fri, 07 May 2004 18:57:21 +0530 Subject: missing comma error during sql insert To: "torque-user@db.apache.org" Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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