Author |
Topic  |
|
rabufo
Junior Member
 
Italy
328 Posts |
Posted - 28 March 2002 : 20:38:11
|
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
|
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??
|
 |
|
OneWayMule
Dev. Team Member & Support Moderator
    
Austria
4969 Posts |
Posted - 28 March 2002 : 21:30:49
|
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 |
 |
|
rabufo
Junior Member
 
Italy
328 Posts |
Posted - 29 March 2002 : 01:39:03
|
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.......
|
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 30 March 2002 : 00:40:50
|
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 |
 |
|
rabufo
Junior Member
 
Italy
328 Posts |
Posted - 30 March 2002 : 02:39:37
|
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
|
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 30 March 2002 : 23:22:26
|
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 addedstrsql = 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 |
 |
|
|
Topic  |
|