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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
