From: jul...@versusdsp.f9.co.uk To: mysq...@lists.mysql.com Subject: mysql++ examples do not work.

Description: I am currently evaluating mysql with a view to using it for a C++ development initially under Windows 2000 but which might also support Solaris. I downloaded version 1.7.1 of mysql++ from the mysqlAB website. I would prefer version 1.7.9 but that does not seem to be available. I then started to compile and work through the examples using VC++6. the resetdb and simple1 examples work fine. custom1.cpp does not compile. It gives an error: xlocnum(268) : error C2587: '_U' : illegal use of local variable as default parameter

custom2.cpp and custom3.cpp do not work correctly because they do not put quotes round strings and dates when used in queries. The problem seems to be in the mysql++ code itself instead rather that the example code. custom2 continually inserts a date of 0000-00-00 instead of 1996-09-25 and custom3 throws an exception:

Query : UPDATE stock SET item = 'Hotdog Buns',num = 65,weight = 1.1,price = 1.1, sdate = 1998-04-23 WHERE item = Hotdogs' Buns Error: You have an error in your SQL syntax near '' Buns' at line 1

I have the same problem using the libmysql.dll supplied with mysql++ and the one supplied with mysql. This makes me wonder what the current status is mysql++. Is it officially supported by mySQL AB ?. Would I be better off using the C API as opposed to the C++ API. I would like a quick response as I only have a few days to evaluate Mysql.

How-To-Repeat: Compile and run the custom2 and custom3 examples supplied with mysql++.

Fix:

Executable: mysqld-nt-max Environment: Pentium 4 PC 256meg ram System: Win2000 5.00.2195 Compiler: VC++ 6.0 SP 4 Architecture: i