Quick Script

[eMark]

Need some help with a small script.

I have a table with about 3000 entries in it. What I need to do is change the value of a field by adding a url to the front of it.

field name: images

example:

before: 235621.jpg
after: http://domain_name/images/235621.jpg

Help on writting a quick script to change the value would be apprecitated.

Thanks!

[putts]

dim conx
dim rs
dim strQuery

set conx = server.createObject("ADODB.CONNECTION")
set rs = server.createObject("ADODB.RECORDSET")

strQuery = "SELECT Images from TABLE1"

rs.Open(strquery, connDBase)
while not(rs.eof)
rs("Images") = "http://domain_name/images/" & rs("Images')
rs.update
rs.moveNext
wend
[/code]

Don't use the ADODB.Recordset very often, but that's probably your best option here.

[afterburn]

or just do an update statement..

update table1 set field1 = 'http://www.domain.com/images/' + field1

[putts]

I was thinking about that same statement, but doubted myself on it for some reason.

ah well - yeah, go with Afterburn's (unless you have to do different web addresses for certain cases - which it doesn't sound like you do)