Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Active User Vs. Email validation?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rabufo
Junior Member

Italy
328 Posts

Posted - 28 March 2002 :  20:38:11  Show Profile
Now I'm experience a problem like the one stated at
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=24957 , but between Email validator and Active User.
Have I to make the same steps, regarding MEMBERS_PENDING, also for the Active User DB, and in the same way?


Thank you for any suggestion......

rabufo
Junior Member

Italy
328 Posts

Posted - 28 March 2002 :  21:13:03  Show Profile
correction......

I've reinstalled all without the Active User, but when I try to register, after the clicking on Submit my data I receive
this msg:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.

/angelfish/register.asp, line 501


what's happening??

Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 28 March 2002 :  21:30:49  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Post a link to a .txt version of your register.asp.

And let me know what MODs you've installed.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

rabufo
Junior Member

Italy
328 Posts

Posted - 29 March 2002 :  01:39:03  Show Profile
http://www.awforum.net/register.txt

I've installed first email validation, then the avatar (including the MEMBERS_PENDING step)


thank you for your help, it seems I really need it.......

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 March 2002 :  00:40:50  Show Profile
Line 450 of your file, you need to either remove it or add the database field to the upper half sql statement:
strsql = strsql & ", '" & ChkString(Request.Form("Avatar_URL"),"") & "'" 


«------------------------------------------------------»
Read the Do's and Don'ts before you post for help
Go to Top of Page

rabufo
Junior Member

Italy
328 Posts

Posted - 30 March 2002 :  02:39:37  Show Profile
thank you very much, now it works!!
I've removed the line, can this cause any problem? I've removed it because it's not clear to me how "add the database field to the upper
half sql statement"...please be patience , I'm new to asp, but with a great desire to learn it.

I've simply added that line in the place as indicated in the avatar reame.txt, just below the code:

if strPicture = "1" then
strsql = strsql & ", '" & ChkString(Request.Form("Photo_URL"),"") & "'"
else
strsql = strsql & ", ''"
end if


thank you very much for your very precious help

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 March 2002 :  23:22:26  Show Profile
Juts follow the instructions to add the avatar mod to your register.asp page. There should be 2 parts of the sql query that you need to add. The first part of the SQL query:
strsql = strsql & ", M_AVATAR_URL"
and the line you said you added
strsql = strsql & ", '" & ChkString(Request.Form("Avatar_URL"),"") & "'"
The first part is telling the database the name of the field that you are inserting data into. The second part is getting the data to insert it into that field in the first part. So you will see the list of database fields first in the sql statement then some mumbo jumbo code which gets the value to put into those list of fields.

Refering to the error you got in the second post. For example, you have 10 database fields listed and you wanted to insert the data into them. In your file you have the 10 fields listed but had 11 values being inserted. So it was telling you, you can't insert 11 values into 10 database fields.

Hopes that makes it a bit easier to understand.

«------------------------------------------------------»
Read the Do's and Don'ts before you post for help


Edited by - Davio on 30 March 2002 23:25:37
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07