Yes these features would definitely make working with JRUN taglib very
worthwhile. It will certainly make it easier and more appealing for CF
developers to transition to JSP.
-----Original Message-----
From: Clement Wong [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 11:56 AM
To: JRun-Talk
Subject: RE: <jrun: sql> tag and embedded single quotes
Yep. I like using single quotes when quoting tag attributes that way I
don't have to worry about using double quotes in java expressions.
BTW, if one suggest some enhancements to <sql> and <sqlparam>, would
the following help a lot in JSP scripting?
1. return multiple resultsets
2. return update counts
3. support BLOB and CLOB
4. support for setting NULL values
5. support stored procedures
6. support optional retrieval of resultsets from stored procedures
7. support javax.sql.RowSet as the returned query result object
8. provide column-based traversing in the returned query result object
--
Clement Wong
JRun Engineer
< a l l a i r e >
-----Original Message-----
From: Fred Moye [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 11:52 AM
To: JRun-Talk
Subject: Re: <jrun: sql> tag and embedded single quotes
Try using the jrun:sqlparam tag. Your code would look like:
lastname=<jrun:sqlparam value="<%= request.getParameter("lastname") %>" />
>>> [EMAIL PROTECTED] 12/19/00 >>>
I am trying to run an update query using the JRUN 3.0 taglib and SQL Server
2000. I am using the JDBC-ODBC bridge. Everything works great except when
I try to update a users name with an embedded single quote (ex.Mike
0'Brien). I have tried a couple of things to try an escape the single
quote. Is there an easy way to do this? Am I missing something simple? Or
do I actually have to write some parsing mechanism that examines each value,
change it, and then send it to the query?
Here is the sample sql I am using.
<jrun:sql datasrc="xxx" id="rsUpdate">
UPDATE users
SET firstname = '<%= request.getParameter("firstname") %>',
lastname = '<%= request.getParameter("lastname") %>',
email = '<%= request.getParameter("email") %>',
username = '<%= request.getParameter("username") %>',
userpassword = '<%= request.getParameter("userpassword") %>',
activeyn = '<%= request.getParameter("activeyn") %>',
userdescription = '<%= request.getParameter("userdescription") %>',
password_hint = '<%= request.getParameter("password_hint") %>'
WHERE userid = <%= request.getParameter("userid") %>
</jrun:sql>
Thanks for any light or comments that can be shed.
-- Mike
-----Original Message-----
From: jrun [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 4:11 PM
To: JRun-Talk
Subject: Re: Answer about JRun Studio
Is there a forum or something for JRun Studio? I'm not very familiar
with Studio or its particular bugs/gotchas. Anyone here?
The key thing about debugging with Studio is that you have to have a 1.3
JDK installed (or the jpda.jar, but that's less stable).
On 19 Nov 2000 16:28:41 -0500, Boris Arciniegas wrote:
> 6) I cant debug, when i try to debug, appear the error " Interface not
> Registered"
>
> I try with other web aplications, but is the same error.
>
> Can someone Help me.
--
Scott Stirling
West Newton, MA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
