Re: Complex String for Insert.

torontodss_at_hotmail.com (Digiital) wrote in message news:<c874dd0a.0201080633.39dda880_at_posting.google.com>...
> I'm trying to insert the following 'complex' string into a table:
>
> datawindow.detail.height=679 #nxtmd# text_triggers_list.text=''
> #nxtmd# text_actions_list.text='' #nxtmd#
>
> With the following.
>
> INSERT INTO obj_syntax VALUES (34453,
> 1,
> 'datawindow.detail.height=679 #nxtmd# text_triggers_list.text=''
> #nxtmd# text_actions_list.text='' #nxtmd#',
> 'oper');
>
> Of course this produces a few errors. I CAN get it to work with the
> following.
>
> INSERT INTO obj_syntax VALUES (34453,
> 1,
> 'datawindow.detail.height=679 #nxtmd# text_triggers_list.text=''''
> #nxtmd# text_actions_list.text='''' #nxtmd#',
> 'oper');
>
>
> But that needs some manual changes.
> One of the other inserts I have to deal with is as followings, and
> again I have to manually add the extra quote.
>
> 13 nofparallel_t.height='68' nofparallel_t.text=''Number of Parallel
> processes:'' nofparallel_t.width='699' nofparallel_t.x='41'
> nofparallel_t.y='556'
>
> How would I go about inserting the whole string into ONE field.
>
> Thanks Folks.

O man, just wrote to you and now all is gone, however...so try this - you dont't have to do anything manually.

insert into a values (REPLACE('datawindow.detail.height=679 #nxtmd# text_triggers_list.text='' #nxtmd# text_actions_list.text='' #nxtmd#','''',''''''))

The result should be (i tried it):

datawindow.detail.height=679 #nxtmd# text_triggers_list.text='' #nxtmd# text_actions_list.text='' #nxtmd#

Greetings Received on Wed Jan 09 2002 - 15:21:30 CET