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='',fiyat='',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]

value of sayac more than 1

now value of sayac=3

 

[Bob Barrows]

Time for some debugging. See below:

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

The following line is not needed

set rssil=server.CreateObject("adodb.recordset")

sil="update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiyat='',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

 

[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='',fiyat='',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='',fiyat='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi='LSZAW002W0'
1
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiyat='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi=' L300C-01AC'
2
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiyat='',tlfiyat='',urunadi='
' where sesid='891158220' and urunadi=' PRS-201'
3
update [sheet3$] set
urunid='',sesid='',num='',marka='',modeladi='',fiyat='',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='',fiyat='',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