Using MID in SQL server
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)
sql2="UPDATE ARTICLeS SET CN_ARTICLE='"&cn_final&"' WHERE COMPANYNAME='MS'"
rs2.open sql2, conn
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?