RE: Witango-Talk: Update action with <@replace>

Ted Wolfley Wed, 16 Jul 2003 12:48:31 -0700

Title: Message

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=''

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

RE: Witango-Talk: Update action with <@replace>

Reply via email to