EXECUTE PROMLEM

Discussion in 'ASP General' started by Savas Ates, Jan 15, 2004.

  1. Savas Ates

    Savas Ates Guest

    only first query executed..

    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



    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'


    still only first query executed. what is the problem...
     
    Savas Ates, Jan 15, 2004
    #1
    1. Advertising

  2. Savas Ates

    Ray at Guest

    Please stick to the original thread. Response in there.

    Ray at work

    "Savas Ates" <> wrote in message
    news:...
    > only first query executed..
    >
    > 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
    >
    >
    >
    > 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'
    >
    >
    > still only first query executed. what is the problem...
    >
    >
    >
     
    Ray at, Jan 15, 2004
    #2
    1. Advertising

  3. Savas Ates

    Savas Ates Guest

    okey sorry.. it was a mistake made inadvertently. I didnt find any answer to
    solve problem.. still im waiting...
     
    Savas Ates, Jan 15, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Lewis
    Replies:
    1
    Views:
    4,092
    Lewis
    Aug 20, 2003
  2. Tom Vande Stouwe MCSD.net

    Re: asp Page events execute twice after PostBack again

    Tom Vande Stouwe MCSD.net, Aug 27, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    2,467
    Daisy
    Sep 3, 2003
  3. Eric Wood

    create and execute bat file in vb.net

    Eric Wood, Nov 5, 2003, in forum: ASP .Net
    Replies:
    2
    Views:
    20,073
    shamirza
    Jul 10, 2007
  4. =?Utf-8?B?QW1paGFp?=

    viewstate promlem on server2003/iis6

    =?Utf-8?B?QW1paGFp?=, Mar 24, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    654
    =?Utf-8?B?QW1paGFp?=
    Mar 27, 2005
  5. Savas Ates
    Replies:
    1
    Views:
    299
    Patrice
    Aug 17, 2004
Loading...

Share This Page