EXECUTE PROBLEM

[Savas Ates]

iam using codes which only execute first query. in loop other queries i can
write screen them but only first query making executed.. why?

for bul=0 to sayac-1

set rssil=server.CreateObject("adodb.recordset")
sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='"&session.SessionID&"' and urunadi='"&delitema(bul)&"'"
baglantimiz.execute(sil)
set rssil= nothing
next

[Ray at]

What is the value of sayac?

Ray at work

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:eQ**************@TK2MSFTNGP09.phx.gbl...

iam using codes which only execute first query. in loop other queries i can write screen them but only first query making executed.. why?

for bul=0 to sayac-1

set rssil=server.CreateObject("adodb.recordset")
sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi=' ' where sesid='"&session.SessionID&"' and urunadi='"&delitema(bul)&"'"
baglantimiz.execute(sil)
set rssil= nothing
next

[Savas Ates]

value of sayac more than 1

now value of sayac=3

[Bob Barrows]

Time for some debugging. See below:
Savas Ates wrote:

iam using codes which only execute first query. in loop other queries
i can write screen them but only first query making executed.. why?
Response.Write sayac & "<BR>" for bul=0 to sayac-1
Response.Write bul & "<BR>" The following line is not needed set rssil=server.CreateObject("adodb.recordset") sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi=' ' where sesid='"&session.SessionID&"' and
urunadi='"&delitema(bul)&"'"
Response.Write sil & "<BR>"

This: baglantimiz.execute(sil) should be this:
baglantimiz.execute(sil,,129) 'adCmdText + adExecuteNoRecords

The following line is not needed set rssil= nothing next

Run the page and look at the results of the response.write statements. If
they don't show you what is wrong, show them to us.

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Savas Ates]

code is
Response.Write sayac & "<BR>"
for bul=0 to sayac-1
Response.Write bul & "<BR>"

sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='"&session.SessionID&"' and urunadi='"&delitema(bul)&"'"
response.write sil&"<br>"
baglantimiz.execute(sil,,129) 'adCmdText + adExecuteNoRecords
next
cant use , call a sub
error line baglantimiz.execute(sil,,129) 'adCmdText + adExecuteNoRecords

[Savas Ates]

output result is

4
0
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi='LSZAW002W0'
1
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi=' L300C-01AC'
2
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi=' PRS-201'
3
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi=' STR-400-1V'

code is

Response.Write sayac & "<BR>"
for bul=0 to sayac-1
Response.Write bul & "<BR>"

sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi='
' where sesid='"&session.SessionID&"' and urunadi='"&delitema(bul)&"'"
response.write sil&"<br>"
baglantimiz.execute(sil)

next

still only first query executed. what is the problem...

[Ray at]

It says that you cannot use parentheses when calling a Sub.

baglantimiz.Execute sil,, 129

Ray at work

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:es****************@TK2MSFTNGP10.phx.gbl...

code is
Response.Write sayac & "<BR>"
for bul=0 to sayac-1
Response.Write bul & "<BR>"

sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiy at='',tlfiyat='',urunadi=' ' where sesid='"&session.SessionID&"' and urunadi='"&delitema(bul)&"'"
response.write sil&"<br>"
baglantimiz.execute(sil,,129) 'adCmdText + adExecuteNoRecords
next
cant use , call a sub
error line baglantimiz.execute(sil,,129) 'adCmdText + adExecuteNoRecords