you probably need url encoding, MetaHTML has to do with replacing carriage returns with HTML <br> tags
>url is the name of the column I am trying to update, should I put <@column >name='url'> instead? > >The only thing constant in the columns' rows that I am trying to update is >"&R=on&h=username&o=password1" and everything else before that can be >different. The number of records needed to be updated is in the thousands. > >I have tried it with <@REPLACE STR="<@column name 'url' >encoding='METAHTML'>" FINDSTR="<@VAR vopassword>" REPLACESTR="<@VAR >vnpassword>" >, ><@REPLACE STR="<@column name 'url' encoding='none'>" FINDSTR="<@VAR >vopassword>" REPLACESTR="<@VAR vnpassword>" > and <@REPLACE STR="<@column >name 'url' encoding='url'>" FINDSTR="<@VAR vopassword>" REPLACESTR="<@VAR >vnpassword>" >in the update action without any luck. > >In debug mode, the query results says I am setting the column to NULL. > >I have done this with Rbase. > >Ted > >-----Original Message----- >From: Robert Garcia [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 16, 2003 3:25 PM >To: [EMAIL PROTECTED] >Subject: Re: Witango-Talk: Update action with <@replace> > > > >What is 'url'? > > ><@REPLACE STR=url FINDSTR="<@VAR vopassword>" REPLACESTR="<@VAR >vnpassword>"> > > >According to the above, the string is a constant 'url'. This should work >(check encoding though): > > ><@assign local$url >"http://website/results2.asp?u=244&R=on&h=username&o=password1";> > ><@REPLACE STR="@@local$url" FINDSTR="<@VAR vopassword>" REPLACESTR="<@VAR >vnpassword>"> > > >Robert. > > >On Wednesday, July 16, 2003, at 12:12 PM, Ted Wolfley wrote: > > >Hi, > > > >I am trying to do an update on a column called url in a table. Each row in >the column url is different and has data that looks like this: > >http://website/results2.asp?u=244&R=on&h=username&o=password1 > > > >I would like to do an update that will only change "password1" to >"password2" and everything else stay the same for that row like: > >http://website/results2.asp?u=244&R=on&h=username&o=password2 > > > >I have tried using the update action with <@REPLACE STR=url FINDSTR="<@VAR >vopassword>" REPLACESTR="<@VAR vnpassword>"> in the value colum of the >acton. The variables"<@VAR vopassword>" is the orginal password and "<@VAR >vnpassword>" is the new password. > > > > I have also tried this with direct DMBS using: > > UPDATE masterdetail SET url='<@REPLACE STR=url FINDSTR="<@VAR vopassword>" >REPLACESTR="<@VAR vnpassword>">' > > > >The problem seems to be that witango is not seeing the data in the column. >Is there way to do an update this way? > > > >Thanks > > > > > > > >Ted Wolfley > >Database/Internet Programmer > >The Ogden Group of Rochester > >phone: (585) 321 1060 x23 > >fax: (585) 321 0043 > >[EMAIL PROTECTED] > > > > > >-- > > >Robert Garcia > >President - BigHead Technology > >CTO - eventpix.com > >2781 N Carlmont Pl > >Simi Valley, Ca 93065 > >ph: 805.522.8577 - cell: 805.501.1390 > >[EMAIL PROTECTED] - [EMAIL PROTECTED] > >http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/ > > >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
