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]
