Posted by cemal on 06/07/06 16:25

Hi

I have this sql lines but somehow they are not working.
Now I am not sure if it is correct. Could you please read the line and
tell me if it is correct?
pid is primary key in the table
visited is a numeric field.

I am trying to increase one number everytime this page is viewed.

sqlup="update products set visited=visited+1 where pid="&intValue
set rs=cn.execute(sqlup)

thanks
Cemenc@gmail.com

• Next in forum: Re: Question about returning a smalldatetime from a Function
• Prev in forum: Re: Tough SQL problem, need expert advice!!!
• Thread view: update

[Reply to this message]