MAIL PROTECTED]>To: "CF-Talk" <[EMAIL PROTECTED]>Sent: Thursday, September 25, 2003 9:41 AMSubject: Re: Help with Transact SQL> you can use the following to update all rows at once:>> update tablename> set uri_column = 'http://etc.com/etc' + uri_column>>> -
you can use the following to update all rows at once:
update tablename
set uri_column = 'http://etc.com/etc' + uri_column
- Original Message -
From: "Frank Mamone" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 1:38 AM
Subject: Help with Transac
Perhaps I'm missing something here but shouldn't a simple update
statement suffice e.g.
Update sometable
Set pathField = '/path1/path2/rest_of_path'
Where pathField = 'http://an_absolute_path/new_path_1/path2/rest_of_path
'
Or is there more to it?
Kola
>> -Original Message-
>> From: Fra
3 matches
Mail list logo