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
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: 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
Subject: Re: 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()
 
Subject: Re: Using a template query does not work

Subject: Re: Using a template query does not work

2007-10-02       - By Maarten Schrijvers

 Back
>
> You must pass parameters to preview() when using template queries.  In
> this case, pass the same parameters you passed to execute().  It doesn't
> keep the assembled query in memory, it rebuilds it each time at need.
> preview() without arguments only works with fixed queries.
>
Thanks! That was it :)

After removing some silly errors, my execute-query still does not actually
insert the data into the database. When I copy-paste the query-string to
Toad, it works without further hickups. I also check it from within the
program:
if (qInsRel.success())
MessageBox::Show("Gegevens opgeslagen", "Succes!"); //data inserted
else
MessageBox::Show("Er ging iets niet helemaal goed...", "Ahhh"); //failure

Is there another step I have to take before a template-query actually
performs an action on the database?