> 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')
You need to escape the single quotes in your 2nd value:
insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K WINXP'')=0')
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:234974
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
