Let's try this again. Asume the following table:
aftest.tperdet mac_id (varchar) parno (varchar) ident (char) How would I write a cursor to say, pull a single row, and just return that record? Again, this is just a proof of concept, never had to use them before, just trying to get a cursor that will execute from a query block, that I can also test using a native Java class I am writing. > -----Original Message----- > From: Loathe [mailto:[EMAIL PROTECTED] > Sent: Monday, October 23, 2006 9:38 PM > To: CF-Talk > Subject: DB2 Cursor question > > > Never really had to user cursors before now, thank god. > > Now I have to :( > > So we are comparing performance across several different drivers and such. > > Right now I'm stuck on getting something that will even run. > > I'm trying this: > > <cftry> > <cfquery name="tryCursor" datasource="mpestest"> > Declare CursorPas Cursor for > Select > par_pas_nr > From > pas_data_ref > Where > pas_nr = 'F3LQ' > > open CursorPas > fetch CursorPas into myField > close CursorPas > </cfquery> > <cfcatch type="any"> > <cfset myVar = cfcatch.rootCause.Sqlca.getMessage()> > <cftrace var="#myVar#" inline="true" /> > <cfdump var="#cfcatch#"> > <cftrace var="#cfcatch#" inline="true" /> > <cfabort> > </cfcatch> > > </cftry> > <cfdump var="#tryCursor#"> > > To see if we can execute cursors inline, becuase we cannot use stored > procedures. > > Is there something wrong with that? > > I don't even know, this is cobbeled together from a couple different > sources. > > Generated SQL: > > Declare CursorPas Cursor for Select par_pas_nr From aftest.pas_data_ref > Where pas_nr = 'F3LQ' open CursorPas fetch CursorPas into myField close > CursorPas > > SQL Code: -199 > SQL State: 42601 > > TIA > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
