Start a new topic

SQL generated by DbVis contains non SQL (garbage) code??

[This topic is migrated from our old forums. The original author name has been removed]

1st off I'll say I'm not a sql whiz but I have access to one and he says there is a string in here that is not SQL. I tried upgrading from 8.0.11 to 9.0 and no change. Here's the code and the second line is the part of the string my SQL expert says isn't supposed to be there. Do I have an option selected that shouldn't be? This is causing the DB to reject changes. INSERT INTO `qless`.`Message` (`id`, `name`, `bundle`, `locale`, `text`, `merchant_id`, `location_id`, `queue_id`) VALUES (null, 'pushed_please_return_status_update', 'defaultScript', 'es', 'TX DPS: Su espera est. es de ${wait}. Por favor regrese a la zona B y espere a ser llamado. Necesita mas tiempo? Responda "M". No escriba mientras conduce.', ${merchant_id||(null)||Long||nullable ds=20 dt=BIGINT}$, null, 7882); ${merchant_id||(null)||Long||nullable ds=20 dt=BIGINT}$ FYI in case needed Product: DbVisualizer Pro 9.0 Build: #1902 (2012/11/30 15:08) Java VM: Java HotSpot(TM) 64-Bit Server VM Java Version: 1.6.0_35 Java Vendor: Sun Microsystems Inc. OS Name: Windows 7 OS Arch: amd64 OS Version: 6.1 Current profile: mysql Current facade: mysql MySQL 5.1.63-0ubuntu0.10.04.1-log MySQL-AB JDBC Driver mysql-connector-java-5.1.21 ( Revision: ${bzr.revision-id} )
1 Comment

[This reply is migrated from our old forums.]

Re: SQL generated by DbVis contains non SQL (garbage) code??
Ray, Which feature in DbVisualizer are you using that generate this INSERT statement? Regards Roger