Weird parsing of templated query

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	mysql openssl Question
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	Update one field with more fields from another table
•	Getting Identity after INSERT
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	mysql test 4 1 fails with the gis test
•	MySQL Cluster Software
•	Downgrade Mysql from 4 to 3 23
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Can 't access mysql after kernel upgrade
•	Executing MySQL Commands From Within C Program
•	Comparing and writing out BLOBS
•	Preventing Duplicate Entries
•	FULLTEXT query format question
•	Strange behavior, Table Level Permission
•	Does the binary log enabling affect the MySQL performances?
•	mysql:it 's a db not a dbms how it 's possible?!
•	mysql have same function mthod as Oracle decode()

Weird parsing of templated query

Weird parsing of templated query

2007-07-14 - By Steven Van Ingelgem

Back

Reply: 1 2 3 4 5 6 7 8 9 10 >>

Hi,

I am trying to figure out why the following is happening:

query << "SELECT COUNT(*) FROM Category WHERE name=%0q;";
query.parse();
query.def[ 0 ] = "testing";
query.store();

=> The MySQL server now receives:

SELECT COUNT(*) FROM Category WHERE name='SELECT COUNT(*) FROM Category
WHERE name=\'test\'';

How could this be? Am I doing something wrong here? It's also ONLY if I have
1 templated parameter...

Greetz,
Steven