| Author |
 Topic  |
|
|
SalmanKhana
Average Member
USA
961 Posts |
 Posted - 18 July 2001 : 14:46:56
|
Hi,
I am getting this error after installing the ban ip mod. Kindly let know the fix for it please.. I would appreciate it
Thanks
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/portal/content/register.asp, line 310
This Error comes after I installed the ban Ip mod.
the line 310 has the following data
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
strSql = strSql & ")" <----- this is line 310
my_Conn.Execute (strSql)
docount
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 July 2001 : 14:50:48
|
| Did you add the necessary code to both the top and bottom parts of the INSERT statement? |
 |
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 18 July 2001 : 14:55:47
|
The problem is fine now. but i 'hope' ban ip works too.
i just removed one code from these similar lines.
strSql = strSql & ", " & "1"
strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
if strfullName = "1" then
what do u say ?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 July 2001 : 15:00:57
|
| I'm not sure. As long as what you have is what the instructions said to do. |
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 18 July 2001 : 15:09:16
|
alrighty . thanx anyways.
i have emailed the files to davio ( ban mod) and tshive ( portal ) to have a look n lemme know
thanx again 
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 July 2001 : 21:23:56
|
I don't see anything wrong with your files.
I have sent you back an email with some debugging code in the file.
Post the code here when you run into the error again.
- David |
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 19 July 2001 : 00:24:59
|
thanx davio.... remember you emailed me the files earlier ? I used one of the register.asp files from that email... It works fine now.
SHould i still use this file and see the error ?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 July 2001 : 00:39:48
|
I did??
ohh umm, ok.
Well, if you don't get the error no more, no need to do any debugging.
Don't trouble it if it's working, is one of my mottos. hehe
- David |
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 20 July 2001 : 04:29:11
|
thanx dude.. now theres one more problem with the slash mod..... i've told about it to richard.... lets hope its gets over soon .....
thanx again for ur help .. i appreciate it... like ur motto alot 
take it easy
sal.
|
|
|
| |
Topic |
|
Topic Locked
