| Author |
 Topic  |
|
|
Kent
Junior Member
United States
193 Posts |
 Posted - 20 September 2003 : 14:15:31
|
Found this mod here, and tried implementing it. Since the original topic was locked, I'm starting a new topic:
When I click on the activation key, I get this error:
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting the varchar value '4561q61n0g8hcuwu' to a column of data type smallint.
/club2/register.asp, line 218
Can anyone offer any insight? |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
Kent
Junior Member
United States
193 Posts |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 22 September 2003 : 09:41:11
|
Looks like the inserted code at line 212 has overwritten one line of the SQL statement. Add the line in green:
strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_SHA256"),"message") & "'"
'### friendly registration MOD
strSql = strSql & ", '" & chkString(rsKey("M_KEY"),"SQLString") & "'"
'### friendly registration MOD |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
 |
|
|
Kent
Junior Member
United States
193 Posts |
Posted - 22 September 2003 : 13:34:40
|
D3mon,
Thanks for looking at it... I made that change, and now get the following error when I try to activate a member's pending record, or when clicking the activation key in the email for a new member:
Microsoft OLE DB Provider for SQL Server error '80040e14'
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
/club34/register.asp, line 219
Is there another place I need to make a similar change....
|
Edited by - Kent on 22 September 2003 14:01:05 |
|
|
|
ErEf
New Member
Netherlands
74 Posts |
Posted - 22 September 2003 : 15:34:29
|
just one line of code is missing just above your second insertion, you must have deleted it while inserting the new code, just like what happened with the other error.
from m_quote line it must look like this
strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_AUHIDE"),"SQLString") & "'"
'### friendly registration MOD
strSql = strSql & ", '" & chkString(rsKey("M_KEY"),"SQLString") & "'"
'### friendly registration MOD
strSql = strSql & ", 1"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords |
If you think you can or you think you cannot, you are right. - Henry Ford |
|
|
|
Kent
Junior Member
United States
193 Posts |
Posted - 22 September 2003 : 21:02:42
|
ErEf,
Thanks for the help, but that doesn't solve the problem. Instead, it generates a different error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/club34/register.asp, line 212
I went back and looked at the original copy of the file, and there was no M_AUHIDE line there...
You can see the current state of the file at:
http://www.simpletractors.com/club34/register.txt
|
Edited by - Kent on 22 September 2003 21:26:07 |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
Kent
Junior Member
United States
193 Posts |
Posted - 23 September 2003 : 12:02:30
|
Thanks D3mon for your patience in helping sort out my error.
It helped me focus on and find the problem area. I had placed the code one line too high...
Rather than using your suggested line of:
strSql = strSql & ", '" & chkString(rsKey("M_SHA256"),"message") & "'"
I had to set a values for M_SHA256 like this:
strSql = strSql & ", 1"
It seems to be working fine now.
Thanks again! |
|
|
| |
Topic |
|
Topic Locked
