Nah, I was leaving it off to see if he was paying attention to my
description of the fix and not just copy n pasting my solution.
Ok, you are right, I missed that one.
On 3/9/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
>
> > You need to double up that single quote within your string
> > that you are
> > inserting. Are you just doing this directly in the DB or
> > through CF? If in
> > CF, using a cfqueryparam should take care of this for you.
> > If directly in
> > the DB then change it to:
>
> > insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> > values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K
> > WINXP')=0')
>
> You missed the 2nd single-quote after WINXP ... doh!
>
>
> s. isaac dealey 434.293.6201
> new epoch : isn't it time for a change?
>
> add features without fixtures with
> the onTap open source framework
>
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
