Could you please explain "prepared statements"? Thanks
-----Original Message-----
From: Eric Larson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 6:13 AM
To: JRun-Talk
Subject: Re: <jrun: sql> tag and embedded single quotes
Use prepared statements and you will get automatic quoting of quotes.
--On Tuesday, December 19, 2000 4:37 PM -0800 Michael Goodwin
<[EMAIL PROTECTED]> wrote:
> 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
