look at the ENCODING attribute. >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 ><http://website/results2.asp?u=244&R=on&h=username&o=password1> >&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 ><http://website/results2.asp?u=244&R=on&h=username&o=password2> >&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] > > >________________________________________________________________________ >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