On 14.Oct.2003 -- 10:15 AM, Geert Van Damme wrote: > > Hi all, > > The docs say a prepared statement is created whenever a <esql:parameter/> tag > appears in the query. If I use this tag in a nested query (not a subquery in sql but > a nested query in XSP), will the same prepared statement be used for every iteration > or will the esql:parameter tag create a new prepared statement every time (which > would kind of disable an important use of a prepared statement) ?
It will create the statement multiple times. However, in theory the driver should recognize the statement and reuse the previous one. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]