yes Dan ,I tried with that.
without update Query it was working
now i m getting the error as
Microsoft VBScript runtime error '800a01a8'
Object required: 'DRIVER={Microsoft Ac'
/wecommerce/3dmax2submit.asp, line 35
my code is
while not rs.eof
if(rs(1)=pro) then
sql="update 3dmax set Bids=2 where ProjectNumber="&project&" "
cn.execute sql ----------------------->35th line
end if
response.write "hai"
rs.movenext
wend
i can't find the problem,can any one find out? if plz pass it to me
Thanks,
regards
Jegatha
Dan Powderhill <[EMAIL PROTECTED]> wrote:
Does the code enter the if statement? Put a response.write in there to
make sure. If it does, then do what I suggested in my previous reply. If
it doesn't, response.write out rs(0) and the project variable and see
what values they hold - they probably don't match (remember that string
comparisons in VBScript are case-sensitive).
Dan
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Jegatha
Sent: 28 July 2005 09:25
To: Asp
Subject: [AspClassicAnyQuestionIsOk] update
the following code doesn't work and no error messages,y is it so?
while not rs.eof
if(rs(0)=project) then
sql="update 3dmax set Bids= "&bidno1&" where
ProjectName='"&projectname&"' "
cn.execute sql
end if
response.write hai
rs.movenext
wend
can anyone help in this
thankx in adv
Jegatha
---------------------------------
Too much spam in your inbox? Yahoo! Mail gives you the best spam
protection for FREE!
http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspClassicAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
How much free photo storage do you get? Store your friends n family photos for
FREE with Yahoo! Photos.
http://in.photos.yahoo.com
[Non-text portions of this message have been removed]
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/
