Snitz Forums 2000 - please explain to me.......

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

please explain to me.......

New Topic

Topic Locked

Printer Friendly

Author

Topic

rabufo
Junior Member

Italy
328 Posts

Posted - 29 March 2002 : 11:38:28

....the meaning of "Number of query values and destination fields are not the same" and what could be the cause of that error....

LINK REMOVED AND OTHER TOPIC DELETED

I'll be infinitely grateful to anyone helping me

Edited by - rabufo on 29 March 2002 11:39:14

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 30 March 2002 : 04:56:33

Number of query values and destination fields are not the same explanation:

Below is an example of how it works:

		'## SQL
		strSql = "INSERT INTO " 
		strSql = strSql & "TABLENAME "
		strSql = strSql & "(FIELD_1"
		strSql = strSql & ", FIELD_2"
		strSql = strSql & ", FIELD_3"
		strSql = strSql & ") "
		strSql = strSql & " VALUES ("
		strSql = strSql & ", " & "'" & value_1 & "'"
		strSql = strSql & ", " & "'" & value_2 & "'"
		strSql = strSql & ", " & "'" & value_3 & "'"
		strSql = strSql & ")"

The error you get appears if a value or field is missing (maybe you've added a field when installing a MOD but did not add the value (or otherwise)). Also be sure that the order of fields and values is the same.

Hope that helps.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs