Hello,
I made the switch to 3.1 and I also now have the problem with <jrun:sql>
and update statements. They used to work fine and now
anytime an update is called it fails and returns:
DatabaseQueryException
allaire.taglib.DatabaseQueryException: nested exception is:
java.sql.SQLException
java.sql.SQLException: Method can be called only once.
Code Example:
<hapb:sql id="result" datasrc="informix321">
UPDATE carrierpref
SET paramrequire = '<%=request.getParameter("paramSelect") %>'
WHERE paramname = '<%=request.getParameter("theName") %>'
</hapb:sql>
This is not good since I used these JRun tags all over the place and I
can't
seem to get them to work now. The docs say that the 3.1 tags are almost
completely backward compatible.
Please help,
Vic
----- Original Message -----
> From: "Ben Groeneveld" <[EMAIL PROTECTED]>
> To: "JRun-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, June 15, 2001 6:33 PM
> Subject: jrun 3.1 sql tag issues
>
>
> > Has anyone else seen these issues when upgrading to 3.1?
> >
> > (1) 'update' statements fail to be parsed and run in the jsp:sql tag
> > resulting in an out of memory message
> > (2) the sql tag scripting method .resetCursor() vanished and must be
> > replaced with .beforeFirst(), a java.sql.rowSet interface
> > (3) the parser is much more sensitive to requiring scripting parameters
> > be enclosed in double quotes, but that's probably a good thing.
> > however, the line numbering info it returns is useless
> >
> > I haven't found a workaround to (1) so if anyone has please let me
> > know. Thanks, BenG.
> >
> > --
> > Ben Groeneveld
> > Information Concepts, Inc., 115 N.W. Oregon, Suite 30, Bend, OR 97701
> > Mailto:[EMAIL PROTECTED], phone:541.388.3611, cell:208.520.6488
> >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
