From: Warren Young
Date: December 15 2006 8:44pm
Subject: Re: sql_create_x and Type issues
List-Archive: http://lists.mysql.com/plusplus/6185
Message-Id: <45830946.8090506@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dan Wez wrote:
> #include
> <mysql++.h>#include <custom.h> sql_create_3(user,
> 1, 0,                   mysqlpp::sql_int, id,
> mysqlpp::sql_varchar, username,
> mysqlpp::sql_varchar, pin) 

As you can see, your code didn't come through very well.  You might try 
attaching it instead of pasting it inline into the email message.  Also, 
a complete compilable example would have been more helpful.

> I receive this error: g++
> -I/usr/local/mysql-current/include/mysql -I/usr/local/include/mysql++
> mysql++example.cpp -o mysqlex -lmysqlppIn file included from
> mysql++example.cpp:9:util.cpp: In function `void
> print_stock_row(const mysqlpp::Row&, int)':util.cpp:178: error:
> conversion from `const mysqlpp::ColData' to non-scalar type
> `mysqlpp::sql_varchar' requestedutil.cpp:180: error: invalid

It seems that you're trying to mix custom code with existing example 
code and running into type conversion issues.  Unless you changed 
print_stock_row() to accept your new SSQLS type, you're going to run 
into problems.