Profil: Larethian | DonanımHaber Forum

Şimdi Ara

@Larethian

Takip Et 0 takipçi

Özel Mesaj

19 Kasım 2006
Tarihinde Katıldı

Takip Ettikleri
0 üye

Görüntülenme
Toplam: 3 (Bu ay: 0)

Fırsat Ekle

Gönderileri

Tümü (1)

Sadece Konular (1)

Sadece Bağlantılar (0)

Larethian · Asp / Asp.NET altına konu açtı. 19 yıl

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

<%

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.

4 Yanıt

Yanıtla

Favorilere Ekle

Hakkında

Konum: İstanbul,Şişli

Forum İmzası:

Tr-Game : Everything about games

Http://www.tr-game.com

Temel Bilgiler ve İstatistikler

Aktiflik: Şu anda DH'de değil
Son Giriş: 17 yıl önce
Son Mesaj Zamanı: 18 yıl
Mesaj Sayısı: 10
Gerçek Toplam Mesaj Sayısı: 12
İkinci El Bölümü Mesajları: 0
Konularının görüntülenme sayısı: 134 (Bu ay: 3)
Toplam aldığı artı oy sayısı: 0 (Bu hafta: 0)
En çok mesaj yazdığı forum bölümü: Web Tasarım - Programlama

Mesajları

İkinci El Referansları