Şimdi Ara

Hata Tipi: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

Daha Fazla
Bu Konudaki Kullanıcılar: Daha Az
1 Misafir - 1 Masaüstü
5 sn
5
Cevap
0
Favori
536
Tıklama
Daha Fazla
İstatistik
  • Konu İstatistikleri Yükleniyor
0 oy
Öne Çıkar
Sayfa: 1
Giriş
Mesaj
  • <%



    if request.form("R1")="V1" then Canswer11=1
    if request.form("R1")="V2" then Canswer12=1
    if request.form("R1")="V3" then Canswer13=1
    if request.form("R1")="V4" then Canswer14=1

    if request.form("R2")="V1" then Canswer21=1
    if request.form("R2")="V2" then Canswer22=1
    if request.form("R2")="V3" then Canswer23=1
    if request.form("R2")="V4" then Canswer24=1

    if request.form("R3")="V1" then Canswer31=1
    if request.form("R3")="V2" then Canswer32=1
    if request.form("R3")="V3" then Canswer33=1
    if request.form("R3")="V4" then Canswer34=1

    if request.form("R4")="V1" then Canswer41=1
    if request.form("R4")="V2" then Canswer42=1
    if request.form("R4")="V3" then Canswer43=1
    if request.form("R4")="V4" then Canswer44=1

    if request.form("R5")="V1" then Canswer51=1
    if request.form("R5")="V2" then Canswer52=1
    if request.form("R5")="V3" then Canswer53=1
    if request.form("R5")="V4" then Canswer54=1

    if request.form("R6")="V1" then Canswer61=1
    if request.form("R6")="V2" then Canswer62=1
    if request.form("R6")="V3" then Canswer63=1
    if request.form("R6")="V4" then Canswer64=1

    if request.form("R7")="V1" then Canswer71=1
    if request.form("R7")="V2" then Canswer72=1
    if request.form("R7")="V3" then Canswer73=1
    if request.form("R7")="V4" then Canswer74=1

    if request.form("R8")="V1" then Canswer81=1
    if request.form("R8")="V2" then Canswer82=1
    if request.form("R8")="V3" then Canswer83=1
    if request.form("R8")="V4" then Canswer84=1

    if request.form("R9")="V1" then Canswer91=1
    if request.form("R9")="V2" then Canswer92=1
    if request.form("R9")="V3" then Canswer93=1
    if request.form("R9")="V4" then Canswer94=1
    if request.form("R9")="V5" then Canswer95=1

    if request.form("ch1")="chc1" then Canswer96=1
    if request.form("ch2")="chc2" then Canswer97=1
    if request.form("ch3")="chc3" then Canswer98=1
    if request.form("ch4")="chc4" then Canswer99=1
    if request.form("ch5")="chc5" then Canswer100=1
    if request.form("ch6")="chc6" then Canswer101=1
    if request.form("ch7")="chc7" then Canswer102=1
    if request.form("ch8")="chc8" then Canswer103=1
    if request.form("ch9")="chc9" then Canswer104=1
    if request.form("ch10")="chc10" then Canswer105=1
    if request.form("ch11")="chc11" then Canswer106=1
    if request.form("ch12")="chc12" then Canswer107=1
    if request.form("ch13")="chc13" then Canswer108=1
    if request.form("ch14")="chc14" then Canswer109=1
    if request.form("ch15")="chc15" then Canswer110=1
    if request.form("ch16")="chc16" then Canswer111=1
    if request.form("ch17")="chc17" then Canswer112=1
    if request.form("ch18")="chc18" then Canswer113=1
    if request.form("ch19")="chc19" then Canswer114=1
    if request.form("ch20")="chc20" then Canswer115=1
    if request.form("ch21")="chc21" then Canswer116=1

    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\an1\db\db.mdb")

    ' veritabanýna baglandik.þimdi sýra tablo'da

    set rs = server.createobject("ADODB.Recordset")
    SQL = "Select * from survey"

    rs.open SQL,objConn,1,3


    set Qexec=objConn.execute("SELECT * FROM SURVEY where userid=" & Session("UserID") & "") ------> line 518 HATA BURADA OLUŞUYOR

    users=Qexec("userid")

    Q11=Qexec("s1_bu") + Canswer11
    Q12=Qexec("s1_bd") + Canswer12
    Q13=Qexec("s1_ba") + Canswer13 '

    Q21=Qexec("s2_bu")+ Canswer21
    Q22=Qexec("s2_bd")+ Canswer22
    Q23=Qexec("s2_ba")+ Canswer23

    Q31=Qexec("s3_15")+ Canswer31
    Q32=Qexec("s3_ay")+ Canswer32
    Q33=Qexec("s3_2ay")+ Canswer33
    Q34=Qexec("s3_3ayf")+ Canswer34

    Q41=Qexec("s4_ih_za_tes_bu")+ Canswer41
    Q42=Qexec("s4_ih_za_tes_bd")+ Canswer42
    Q43=Qexec("s4_ih_za_tes_ba")+ Canswer43
    Q44=Qexec("s4_prb_coz_bu")+ Canswer44
    Q45=Qexec("s4_prb_coz_bd")+ Canswer45
    Q46=Qexec("s4_prb_coz_ba")+ Canswer46
    Q47=Qexec("s4_il_be_bu")+ Canswer47
    Q48=Qexec("s4_il_be_bd")+ Canswer48
    Q49=Qexec("s4_il_be_ba")+ Canswer49
    Q50=Qexec("s4_ul_bu")+ Canswer50
    Q51=Qexec("s4_ul_bd")+ Canswer51
    Q52=Qexec("s4_ul_ba")+ Canswer52
    Q53=Qexec("s4_coz_hz_bu")+ Canswer53
    Q54=Qexec("s4_coz_hz_bd")+ Canswer54
    Q55=Qexec("s4_coz_hz_ba")+ Canswer55
    Q56=Qexec("s4_ur_bil_bu")+ Canswer56
    Q57=Qexec("s4_ur_bil_bd")+ Canswer57
    Q58=Qexec("s4_ur_bil_ba")+ Canswer58
    Q59=Qexec("s4_prj_hed_bu")+ Canswer59
    Q60=Qexec("s4_prj_hed_bd")+ Canswer60
    Q61=Qexec("s4_prj_hed_ba")+ Canswer61

    Q62=Qexec("s5_Mt_bu")+ Canswer62
    Q63=Qexec("s5_Mt_bd")+ Canswer63
    Q64=Qexec("s5_Mt_ba")+ Canswer64
    Q65=Qexec("s5_Tl_Bu")+ Canswer65
    Q66=Qexec("s5_Tl_Bd")+ Canswer66
    Q67=Qexec("s5_Tl_Ba")+ Canswer67
    Q68=Qexec("s5_Py_Bu")+ Canswer68
    Q69=Qexec("s5_Py_Bd")+ Canswer69
    Q70=Qexec("s5_Py_Ba")+ Canswer70
    Q71=Qexec("s5_Om_Bu")+ Canswer71
    Q72=Qexec("s5_Om_Bd")+ Canswer72
    Q73=Qexec("s5_Om_Ba")+ Canswer73


    Q74=Qexec("s6_bu")+ Canswer74
    Q75=Qexec("s6_bd")+ Canswer75
    Q76=Qexec("s6_ba")+ Canswer76


    Q77=Qexec("s7_bu")+ Canswer77
    Q78=Qexec("s7_bd")+ Canswer78
    Q79=Qexec("s7_ba")+ Canswer79

    Q80=Qexec("s8_bu")+ Canswer80
    Q81=Qexec("s8_bd")+ Canswer81
    Q82=Qexec("s8_ba")+ Canswer82

    Q83=Qexec("s9_bu")+ Canswer83
    Q84=Qexec("s9_bd")+ Canswer84
    Q85=Qexec("s9_ba")+ Canswer85

    Q86=Qexec("s10_bu")+ Canswer86
    Q87=Qexec("s10_bd")+ Canswer87
    Q88=Qexec("s10_ba")+ Canswer88
    Q89=Qexec("s11_bu")+ Canswer89
    Q90=Qexec("s11_bd")+ Canswer90
    Q91=Qexec("s11_ba")+ Canswer91
    Q92=Qexec("yorum11")+ Canswer92
    Q93=Qexec("yorum1")+ Canswer93
    Q94=Qexec("yorum2")+ Canswer94
    Q95=Qexec("yorum3")+ Canswer95
    Q96=Qexec("yorum4")+ Canswer96
    Q97=Qexec("yorum5")+ Canswer97
    Q98=Qexec("yorum6")+ Canswer98
    Q99=Qexec("yorum7")+ Canswer99
    Q100=Qexec("yorum8")+ Canswer100
    Q101=Qexec("yorum9")+ Canswer101
    Q102=Qexec("yorum10")+ Canswer102
    Q103=Qexec("genelyorum")+ Canswer103

    Objconn.execute("UPDATE survey SET s1_bu=" & Q11 & ", s1_bd=" & Q12 & ",s1_ba=" & Q13 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s2_bu=" & Q21 & ", s2_bd=" & Q22 & ",s2_ba=" & Q23 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s3_15=" & Q31 & ", s3_ay=" & Q32 & ",s3_2ay=" & Q33 & ",s3_3ayf=" & Q34 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s4_ih_za_tes_bu=" & Q41 & ", s4_ih_za_tes_bd=" & Q42 & ", s4_ih_za_tes_ba=" & Q43 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s4_prb_coz_bu=" & Q44 & ",s4_prb_coz_bd=" & Q45 & ",s4_prb_coz_ba=" & Q46 & ",s4_il_be_bu=" & Q47 & ",s4_il_be_bd=" & Q48 & ",s4_il_be_ba=" & Q49 & ",s4_ul_bu=" & Q50 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s4_ul_bd=" & Q51 & ", s4_ul_ba=" & Q52 & ",s4_coz_hz_bu=" & Q53 & ",s4_coz_hz_bd=" & Q54 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s4_coz_hz_ba=" & Q55 & ", s4_ur_bil_bu=" & Q56 & ",s4_ur_bil_bd=" & Q57 & ",s4_ur_bil_ba=" & Q58 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s4_prj_hed_bu=" & Q59 & ", s4_prj_hed_bd=" & Q60 & ",s4_prj_hed_ba=" & Q61 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s5_Mt_bu=" & Q62 & ", s5_Mt_bd=" & Q63 & ",s5_Mt_ba=" & Q64 & ",s5_Tl_Bu=" & Q65 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s5_Tl_Bd=" & Q66 & ", s5_Tl_Ba=" & Q67 & ", s5_Py_Bu=" & Q68 & ", s5_Py_Bd=" & Q69 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s5_Py_Ba=" & Q70 & ", s5_Om_Bu=" & Q71 & ",s5_Om_Bd=" & Q72 & ",s5_Om_Ba=" & Q73 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s5_Py_Ba=" & Q74 & ", s5_Om_Bu=" & Q75 & ",s5_Om_Bd=" & Q76 & ",s5_Om_Ba=" & Q77 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s6_bu=" & Q78 & ", s6_bd=" & Q79 & ",s6_ba=" & Q80 & ",s7_bu=" & Q81 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s7_bd=" & Q79 & ", s7_ba=" & Q80 & ",s8_bu=" & Q81 & ",s8_bd=" & Q82 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s8_ba=" & Q83 & ", s9_bu=" & Q84 & ",s9_bd=" & Q85 & ",s9_ba=" & Q86 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s10_bu=" & Q87 & ", s10_bd=" & Q88 & ",s10_ba=" & Q89 & ",s11_bu=" & Q90 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET s11_bd=" & Q91 & ", s11_ba=" & Q92 & ",yorum11=" & Q93 & ",yorum1=" & Q94 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET yorum2=" & Q95 & ", yorum3=" & Q96 & ",yorum4=" & Q97 & ",yorum5=" & Q98 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("UPDATE survey SET yorum6=" & Q99 & ", yorum7=" & Q100 & ",yorum8=" & Q101 & ",yorum9=" & Q102 & ",yorum10=" & Q103 & " WHERE userid=" & Session("UserID") & "")

    Objconn.execute("INSERT INTO survey SET genelyorum= " & request.form("genelyorum") & " WHERE userid=" & Session("UserID") & "")



    Qexec.Close
    Set Qexec=Nothing
    ObjConn.Close
    Set ObjConn=Nothing


    %>



    Hata Tipi:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
    [Microsoft][ODBC Microsoft Access Sürücüsü] Çok az parametre. 1 bekleniyor.
    /an1/survey.asp, line 518



    Bu hatayı alıyorum alan adı da mevcut ama hatayı çözemedim arama yaptım yapılanlarıda denedim fakat çözüm getiremedim teşekkür.



    < Bu mesaj bu kişi tarafından değiştirildi Larethian -- 21 Ocak 2007; 1:34:46 >







  • 518. satır hangisi oluyor bunlardan? O satırı koyulaştırabilir misin?
    Orada birşey eksik yazılmış olmalı...
  • değiştirdim hata şimdi koyu teşekkür ederim



    < Bu mesaj bu kişi tarafından değiştirildi Larethian -- 21 Ocak 2007; 1:35:27 >
  • quote:

    set Qexec=objConn.execute("SELECT * FROM SURVEY where userid=" & Session("UserID") & "")

    En son eklediğin tırnak işaretlerine gerek yok sanırım. Gerçi hata ondan kaynaklanmıyordur herhalde...
    Bilmiyorum ben bir yanlış göremedim doğrusu... Session("UserID") değer döndürüyor değil mi?
    Sen yine sondaki tırnakları kaldırıp bir dene istersen.
    set Qexec=objConn.execute("SELECT * FROM SURVEY WHERE userid=" & Session("UserID"))



    < Bu mesaj bu kişi tarafından değiştirildi un.real -- 21 Ocak 2007; 1:52:22 >
  • probleme çözüm olmadı farklı hatalara yol açıyor id den gelen değer rakamsal içerikli
  • Yapay Zeka’dan İlgili Konular
    Daha Fazla Göster
    
Sayfa: 1
- x
Bildirim
mesajınız kopyalandı (ctrl+v) yapıştırmak istediğiniz yere yapıştırabilirsiniz.