hi
my code is,
a=session("projectnamebrowse")
set cn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordset")
set rs1=server.createobject("ADODB.recordset")
set rs2=server.createobject("ADODB.recordset")
cn="DRIVER={Microsoft Access Driver (*.mdb)}; "
cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb")
rs.open "select * from projectsubmit",cn,1,2
while not rs.eof
if(rs("ProjectName")=a) then
hit=rs("hits")+1
else
hit=0
end if
rs.movenext
wend
response.write hit
response.write a
sql="update postpro set bids="&hit&" where projectname='"&a&"' "
cn.Execute sql
i got the following error,
Microsoft VBScript runtime error '800a01a8'
Object required: 'DRIVER={Microsoft Ac'
/wecommerce/submit2.asp, line 44
always fighting with update code, can anyone help me with the proper code?
thanks in adv
regards,
Jegatha
---------------------------------
Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots
more.
http://in.promos.yahoo.com/rakhi/index.html
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
