| Author |
 Topic  |
|
|
Kal Corp
Average Member
USA
878 Posts |
 Posted - 20 August 2002 : 15:53:10
|
3.4 and NT mode? working?
Anyone test 3.4 and NT mode?
Im getting issues with auto registration.
Error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/dev1/register.asp, line 585
the sqlstring failing is
INSERT INTO FORUM_MEMBERS (M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256) VALUES ('XXXXX', 'XXXXX', 'XXXXXXX', ' ', '20020820154212', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20020820154212',1, ' ', '132.228.132.193', '132.228.132.193', ' ', , , ' ', ' ', '', '', '', ' ', ' ', '', '', '', '', '', '', '', '', '', 1)
Can you see the problem? to many dam 's 
|
{VAS}-Kal Corp
VAS Development NetWork - Forums for old Snitz Mods!
Creator of all things {VAS}
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 20 August 2002 : 16:30:37
|
INSERT INTO FORUM_MEMBERS (M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256) VALUES ('XXXXX', 'XXXXX', 'XXXXXXX', ' ', '20020820154212', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20020820154212',1, ' ', '132.228.132.193', '132.228.132.193', ' ', , ,' ', ' ', '', '', '', ' ', ' ', '', '', '', '', '', '', '', '', '', 1)
Sig code!
if strSignatures = "1" then
strSql = strSql & ", " & Request.Form("fSigDefault")
else
strsql = strsql & ", " & 1
end if
looks like Request.Form("fSigDefault") is set to nothing in autoregister. ! |
{VAS}-Kal Corp
VAS Development NetWork - Forums for old Snitz Mods!
Creator of all things {VAS}
|
 |
|
|
pweighill
Junior Member
United Kingdom
453 Posts |
Posted - 20 August 2002 : 16:56:54
|
| Change to clng("0" & Request.Form("fSigDefault")) |
|
|
| |
Topic |
|
|
|
Topic Locked
