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
 Number of query values...?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

gigterry
Starting Member

8 Posts
Posted - 15 April 2002 :  22:31:10  Show Profile
I got this message when trying to test the registration:

Microsoft JET Database Engine error '80040e14'

Number of query values and destination fields are not the same.

/gigterry/forum2/register.asp, line 301

WHat do you think?

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 15 April 2002 :  22:43:02  Show Profile
more than likely, still related to adding the Active User's MOD. There were 2 sections where you needed to add code to register.asp, double check it and make sure you added both sections in the correct place.
Go to Top of Page

gigterry
Starting Member

8 Posts
Posted - 16 April 2002 :  01:39:22  Show Profile
do you have any other suggestions?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 16 April 2002 :  01:50:22  Show Profile
you can rename the file to register.txt and then post the full link to it here. That way we can take a look at it.
Go to Top of Page

gigterry
Starting Member

8 Posts
Posted - 16 April 2002 :  14:54:29  Show Profile
Here's a link.

http://www10.brinkster.com/gigterry/forum2/register.txt

I think that maybe something's wrong with the DB
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts
Posted - 16 April 2002 :  19:55:40  Show Profile  Visit Nathan's Homepage 
	        strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
		else 
		if strAUAnon = "1" then
			strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
		else 
			strSql = strSql & ", '1'" 
		end if
			strSql = strSql & ", ''" 
		end if


Should be: 
	        strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
		else 
			strSql = strSql & ", ''" 
		end if
		if strAUAnon = "1" then
			strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
		else 
			strSql = strSql & ", '1'" 
		end if


That error was caused because you only copied the viewable text in the textarea instead of selecting all the text.
Easy mistake to make.

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 16 April 2002 :  20:30:23  Show Profile
Nathan,

Maybe add a "Highlight All" button for each textarea like this:

< link removed >

If you want to see what I used, the file is here:

< link removed >
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts
Posted - 16 April 2002 :  22:12:08  Show Profile  Visit Nathan's Homepage
Thanks for the tip Richard. I have implemented select all buttons in the readme. Will be included next time I upload new language packs.

Nathan Bales
Snitz Exchange | Do's and Dont's
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.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07