Robert.
On Wednesday, July 16, 2003, at 12:54 PM, Ted Wolfley wrote:
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/
--
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/
