Oops, I was confused. This CHR(27) being part of the string that goes to the database, should do no harm > -----Original Message----- > From: Mathew, Aby [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 24, 1999 5:16 PM > To: '[EMAIL PROTECTED]'; > [EMAIL PROTECTED] > Subject: Re: [ND] Full override update fails when num of rows over > one > > Dave, > > I get suspicious about CHR(27). > > I can't imagine what all can go wrong if the escape character is embedded > in > the SQL string, neither its purpose. > > Aby > > > -----Original Message----- > > From: Dave Schorsch [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, June 24, 1999 4:55 PM > > To: [EMAIL PROTECTED]; > > [EMAIL PROTECTED] > > Subject: [ND] Full override update fails when num of rows over one > > > > Hi, > > > > I am having a problem with an older 3.x project. I wrote some code where > a > > data > > object is set for full override, i.e. > > > > DataObject2.setSqlTextOverride(FULL_TEXT_OVERRIDE); > > DataObject2.setSqlTextFull(sqlTable+sqlSet+sqlWhere); > > command = DataObject2.execute(); > > > > The dataobject is called from within a CSpRepeated. When the num of rows > > in the > > repeated is set to 1 (one), the sql statement is executed fine. When the > > number > > of rows is more than one, I take the appropriate vector components and > > construct > > the same sql statement and execute it but nd just hangs until ds > timeout. > > Below > > is the netdyn.log but shows no clues to why it is hanging. Do updates in > a > > repeated need to be handled differently?? > > > > Thanks, > > > > Dave > > [EMAIL PROTECTED] > > > > > > 06/24/99 15:45.37 (82 b9000000 930260737456) [javaCP] (M) > > spider.control.CSpDSProcessor.run: Got them. > > 06/24/99 15:45.37 (82 b9000000 930260737466) [javaCP] (M) > > spider.control.CSpTimedThread.run: 'CSpDSProcessor' interruptable > > Thread is DONE. > > 06/24/99 15:45.37 (82 b9000000 930260737476) [javaCP] (H) > > spider.visual.CSpRepeated.executeOneRecord: Processing record #1 > > 06/24/99 15:45.37 (82 b9000000 930260737496) [javaCP] (H) > > spider.database.CSpTransaction.execute(CSpDataObject,CSpDBRequest): > > Going to execute DataObject 'CIDS.DataObject1' for DataSource > > 'CIDS.dsFids' 06/24/99 15:45.37 (82 b9000000 930260737496) [javaCP] > > (M) spider.control.CSpDSProcessor.establishConnection(..): Called to > > > establish a connection to an already opened socket > > 06/24/99 15:45.37 (82 b9000000 930260737516) [javaCP] (E) > > CIDS.DataObject1.@@@ARPT_CD(0)ORD > > 06/24/99 15:45.37 (82 b9000000 930260737516) [javaCP] (E) > > CIDS.DataObject1.@@@@@@@@@@@@@@esc2Value ? > > 06/24/99 15:45.37 (82 b9000000 930260737526) [javaCP] (E) > > CIDS.DataObject1.@@@@@@@@@@@@@@SUBBBBB=BAG > > 06/24/99 15:45.37 (82 b9000000 930260737526) [javaCP] (E) > > CIDS.DataObject1.onBeforeExecuteEvent@@@sqlTable? UPDATE > > SIGN_CANNED_MSG_DATA > > 06/24/99 15:45.37 (82 b9000000 930260737536) [javaCP] (E) > > CIDS.DataObject1.onBeforeExecuteEvent@@@sqlSet? SET FRAME_TXT='BAG > > CLAIM AREA ' || CHR(27) || '$BCP03 DAVE', LN_ATTR='', JUST='C' > > 06/24/99 15:45.37 (82 b9000000 930260737536) [javaCP] (E) > > CIDS.DataObject1.onBeforeExecuteEvent@@@sqlWhere? WHERE > > ARPT_CD='ORD' AND SIGN_TYPE='BC' AND SIGN_MSG_CD='AUTO001' AND > > LN_NBR='0' AND FRAME_NBR='1' > > 06/24/99 15:45.37 (82 b9000000 930260737546) [javaCP] (E) > > CIDS.DataObject1.onBeforeExecuteEvent@@@sqlText? UPDATE > > SIGN_CANNED_MSG_DATA SET FRAME_TXT='BAG CLAIM AREA ' || CHR(27) || > > '$BCP03 DAVE', LN_ATTR='', JUST='C' WHERE ARPT_CD='ORD' AND > > SIGN_TYPE='BC' AND SIGN_MSG_CD='AUTO001' AND LN_NBR='0' AND > > FRAME_NBR='1' > > 06/24/99 15:45.37 (82 b9000000 930260737556) [javaCP] (H) > > CIDS.DataObject2.execute: executing 'DataObject2' (first row=0, max > > rows=1, from the BEGINNING). SQL query=|UPDATE SIGN_CANNED_MSG_DATA > > SET FRAME_TXT='BAG CLAIM AREA ' || CHR(27) || '$BCP03 DAVE', > > LN_ATTR='', JUST='C' WHERE ARPT_CD='ORD' AND SIGN_TYPE='BC' AND > > SIGN_MSG_CD='AUTO001' AND LN_NBR='0' AND FRAME_NBR='1' | > > 06/24/99 15:45.37 (82 b9000000 930260737566) [javaCP] (M) > > spider.control.CSpDSProcessor.establishConnection(): Called to > > establish a connection for the first time > > 06/24/99 15:45.37 (82 b9000000 930260737566) [javaCP] (M) Inserting slot > > > 1000 -- length = 102, timeout = 300000 > > 06/24/99 15:47.37 (82 b9000000 930260857148) [javaCP] (M) > > spider.control.CSpTimedThread.run: 'CSpWebEventProcessor' > > interruptable Thread is DONE. > > 06/24/99 15:47.37 (82 b9000000 930260857148) [javaCP] (E) > > spider.control.CSpTimedThread.run: InterruptableThread > > CSpWebEventProcessor has not been done in 120000 miliseconds OR an > > unrecoverable exception occured > > 06/24/99 15:47.37 (82 b9000000 930260857158) [javaCP] (E) > > spider.control.CSpTimedThread.Trying to stop it... > > 06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (E) cannot read > > > input request > > 06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (H) Socket > > closed > > 06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (M) Looking up > > slot 1000, with time in = (120) > > 06/24/99 15:47.37 (304 b9000000 930260857168) [ndServer] (M) Removing > > slot 1000 > > 06/24/99 15:47.37 (304 b9000000 930260857168) [ndServer] (M) reading > > input request > > > _________________________________________________________________________ > > > > For help in using, subscribing, and unsubscribing to the discussion > > forums, please go to: > http://www.netdynamics.com/support/visitdevfor.html > > > > For dire need help, email: [EMAIL PROTECTED] > _________________________________________________________________________ > > For help in using, subscribing, and unsubscribing to the discussion > forums, please go to: http://www.netdynamics.com/support/visitdevfor.html > > For dire need help, email: [EMAIL PROTECTED] _________________________________________________________________________ For help in using, subscribing, and unsubscribing to the discussion forums, please go to: http://www.netdynamics.com/support/visitdevfor.html For dire need help, email: [EMAIL PROTECTED]
