| Author |
 Topic  |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 30 October 2001 : 12:58:16
|
Ok, ALL the form fields exist, ALL the variables ARE defined, and populated... this is the string (using response.write)
UPDATE ADMIN SET ADMINID=1, ADMINLEVEL='admin', ADMINNAME='admin', ADMINPASSWORD='admin', SHOWBANNERS=1, APPROVESITES='yes', SITESTOSHOW=100, BANNER1='&nsbp;', BANNER2='&nsbp;', BANNER3='&nsbp;', BANNER4='&nsbp;', BANNER5='&nsbp;', CONTACTNAME='Eric J', CONATACTEMAIL='da_stimulator@hotmail.com', TOPSITENAME='StimList Development TopSites', HOMEPAGE='http://stormwhispers.com/ss/', TYPEOFLINK='button', BUTTONURL='http://stormwhispers.com/ss/images/logo_right.gif' WHERE ADMINID=1
This is the Code...
strsql = "SELECT ADMINLEVEL, ADMINNAME, ADMINPASSWORD, BANNER1, BANNER2, BANNER3, BANNER4, BANNER5 FROM ADMIN WHERE ADMINID=1"
set rs = t_conn.execute(strsql)
adminlevel = rs("ADMINLEVEL")
adminname = rs("ADMINNAME")
adminpass = rs("ADMINPASSWORD")
banner1 = rs("BANNER1")
banner2 = rs("BANNER2")
banner3 = rs("BANNER3")
banner4 = rs("BANNER4")
banner5 = rs("BANNER5")
set rs = nothing
strsql = "UPDATE ADMIN SET " & _
"ADMINID=1, " & _
"ADMINLEVEL='" & adminlevel & "', " & _
"ADMINNAME='" & adminname & "', " & _
"ADMINPASSWORD='" & adminpass & "', " & _
"SHOWBANNERS=" & showbanners & ", " & _
"APPROVESITES='" & approvesites & "', " & _
"SITESTOSHOW=" & sitestoshow & ", " & _
"BANNER1='" & banner1 & "', " & _
"BANNER2='" & banner2 & "', " & _
"BANNER3='" & banner3 & "', " & _
"BANNER4='" & banner4 & "', " & _
"BANNER5='" & banner5 & "', " & _
"CONTACTNAME='" & contactname & "', " & _
"CONATACTEMAIL='" & contactemail & "', " & _
"TOPSITENAME='" & topsitename & "', " & _
"HOMEPAGE='" & homepageurl & "', " & _
"TYPEOFLINK='" & typeoflink & "', " & _
"BUTTONURL='" & buttonurl & "' " & _
" WHERE ADMINID=1"
response.write(strsql)
t_conn.execute(strsql)
That covers EVERY field in the table, EVERY single one... and they are ALL populated - yet I still recieve this error...
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/ss/toplist/admin_admin.asp, line 85
line 85 is the t_conn.execute(strsql) - and the strsql is clearly pointed out above.
---------------
Da_Stimulator has spoken |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 30 October 2001 : 19:24:55
|
If you open your rs using con.execute, you get a read-only cursor.
Try changing the way you open the rs using the rs methods for active connection, cursortype, text, etc. then use rs.open
======
Doug G
====== |
 |
|
| |
Topic |
|
|
|
Topic Locked
