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
