Hi,

I first do a select in the database:

SQL="SELECT * FROM ARTICLES WHERE COMPANYNAME="MS""

Now I realize a DO WHILE and in the DO WHILE I do the next:

Do while NOT rs.EOF
 CN_temp=Right("000000" & rs("codearticle"), 6)
 cn_Final=((INT( MID(CN_TEMP,2,1))*3)
 sql2="UPDATE ARTICLeS SET CN_ARTICLE='"&cn_final&"' WHERE COMPANYNAME='MS'"
 rs2.open sql2, conn
rs.Movenext
LOOP

This works fine (if there are some spelling mistakes, don´t bother as the code works) althought it tell me after 30-40 seconds that there has been a timeout.
So I thought mixing the two SQL SYNTAXES in one, but after several tries I am still stuck.
I tried the next:

sql2="UPDATE ARTICLES SET CN_ARTICLE=((INT( MID(Right('000000' & codearticle, 6),2,1))*3)) WHERE companyname='MS'"

I thought this way, it ponly has to do ONE SQL, which 'supposely' wouldn´t give me a timeout (in my WEBSERVER, the timeout option is set at 600secs)


Anybody can give me a hint?

Thx,

David
:)