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')
On 3/9/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I'm trying to insert a value in to a column in oracle and I'm getting
> a missing comma error.
>
> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what to do to fix
> it.
>
> Thanks,
> - charles
>
> Here is my sql code...
> insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),' WIN2K WINXP')=0')
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234971
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
