Re: How to initialize mysqlpp::sql_tinyblob?

Graham Reitz wrote:
> How would you initialize password in the following SSQLS?
>
> sql_create_2(clients, 1, 2,
> unsigned int, client_id,
> mysqlpp::sql_tinyblob, password)
>
> clients client;
> client.client_id = 1;
> client.password = ????;

I imagine you're using a BLOB type because you're keeping the password in some sort of binary representation, so a straight assignment won't work. Perhaps you're using a hashing scheme and want to use the raw binary form instead of a hexadecimal text representation.

If reconsidering the choice to use a binary representation isn't an option, you can get by with this:

	ColData cd(ptr_to_data, bytes_in_data_block);
	client.password = cd;

All of the BLOB types as of v2.3 are typedefs for ColData.

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=lists@pantek.com