U++ forum: Welcome to the forum

Fri, 19 May 2006 01:28

Justin
Messages: 57
Registered: March 2006
Location: Orange County California

Member

Mirek,

I am trying to get this code to work based on what you sent me earlier in my last post. But as you can see in the .LOG file, the values are appending a certain number of 'Free' strings after the values. What is this about?

The first piece of code is my code in the program and the second is the error from the log file.

sql.Execute("UPDATE nc_support SET name = ? WHERE ticket = ?",~supportmodify.edtName,AsString(ticket));

select substring_index(USER(),'@',1)
select substring_index(USER(),'@',1)
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reeF WHERE ticket = "640641877"eFreeFreeF' at line 1: UPDATE nc_support SET name = "45w"reeF WHERE ticket = "640641877"eFreeFreeF
UPDATE nc_support SET name = ? WHERE ticket = ?
## ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reeF WHERE ticket = "640641877"eFreeFreeF' at line 1

Justin

[Updated on: Mon, 22 May 2006 19:12]

Report message to a moderator