List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:April 23 2007 1:29pm
Subject:Re: NULL in templatized queries
View as plain text  
Michael Hanselmann wrote:
> Index: lib/sql_string.h

Thanks for the patch!  It's applied now.

> Index: examples/tquery.cpp
> ===================================================================
> --- examples/tquery.cpp	(revision 1526)
> +++ examples/tquery.cpp	(working copy)
> @@ -44,9 +44,15 @@
>  		// Build a template query to retrieve a stock item given by
>  		// item name.
>  		mysqlpp::Query query = con.query();
> -		query << "select * from stock where item = %0q";
> +		query << "select * from stock where item = %0q:item";
>  		query.parse();
>  
> +		query.def["item"] = mysqlpp::null;
> +		std::cout << query.str() << std::endl;
> +
> +		query.def["item"] = mysqlpp::SQLString("foo");
> +		std::cout << query.str() << std::endl;
> +
>  		// Retrieve an item added by resetdb; it won't be there if
>  		// tquery or custom3 is run since resetdb.
>  		mysqlpp::Result res1 = query.store("Nürnberger Brats");

Errr...I'm surprised you think I'd accept this, given my previous 
comments on this.  Thanks for trying to update the examples anyway, but 
I won't exhibit unsupported "features" in the examples.
Thread
NULL in templatized queriesMichael Hanselmann16 Apr
  • Re: NULL in templatized queriesMichael Hanselmann16 Apr
  • Re: NULL in templatized queriesWarren Young17 Apr
    • Re: NULL in templatized queriesMichael Hanselmann22 Apr
      • Re: NULL in templatized queriesWarren Young23 Apr