[vBScript+ADO(MySQL)] What is wrong with my syntax - Overclock.net

LyokoHaCk · 09-04-07

vBScript is not used for web coding
It is a side script from a program.
GetNameByPosition(3) is an array variable (41).

Code:

Conn.execute ("UPDATE data SET name='" & GetNameByPosition(3) & "' WHERE id='2' ")

Error:

Code:

 [4:59:39 PM] UserJoins Call Error On File> C:\Program Files\StealthBot\plugins\sql.txt
 [4:59:39 PM] Error Number: 13   Description: Type mismatch

mjoc13 · 09-07-07

the syntax is incorrect for the variable in the table

example:
update table set name = 'Joe' where id = 2

your id field is probably an integer not a varchar

09-04-07	#1 (permalink)
LyokoHaCk Programmer Join Date: Aug 2006 Location: United States Inc. Posts: 2,066 Rep: 76 Unique Rep: 71 FAQs Submitted: 1 Folding Team Rank: 2138 Trader Rating: 3	[vBScript+ADO(MySQL)] What is wrong with my syntax vBScript is not used for web coding It is a side script from a program. GetNameByPosition(3) is an array variable (41). Code: Conn.execute ("UPDATE data SET name='" & GetNameByPosition(3) & "' WHERE id='2' ") Error: Code: [4:59:39 PM] UserJoins Call Error On File> C:\Program Files\StealthBot\plugins\sql.txt [4:59:39 PM] Error Number: 13 Description: Type mismatch

		Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Application Programming
[vBScript+ADO(MySQL)] What is wrong with my syntax

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)