List:MySQL++« Previous MessageNext Message »
From:Rick Gutleber Date:October 16 2008 11:31pm
Subject:Re: Modifying rows
View as plain text  
Well, you call it "stock" in the SSQLS declaration and "parkingscylar" 
in the query.

Demetris wrote:
> What do you mean?
>
> Which one is different? Please explain.
>
> -----Original Message-----
> From: Rick Gutleber [mailto:rgutleber@stripped] 
> Sent: Thursday, October 16, 2008 10:49 PM
> To: Demetris Zavorotnichenko
> Subject: Re: Modifying rows
>
> Demetris:
>
> I can't help but notice that the table name in the SSQLS macro and the 
> SQL you use are different.  Are you mixing up tables?
>
> Rick
>
> Demetris Zavorotnichenko wrote:
>   
>> Hi everyone.
>>
>>  
>>
>> I have a problem modifying the Rows.
>>
>>  
>>
>> My code is pretty simple:
>>
>>  
>>
>> sql_create_14(stock,
>>
>>       1, 14,
>>
>>       mysqlpp::sql_int, id,
>>
>>       mysqlpp::sql_int, area,
>>
>>       mysqlpp::sql_double, latitude,
>>
>>       mysqlpp::sql_double, longtitude,
>>
>>       mysqlpp::sql_int, charge_num,
>>
>>       mysqlpp::sql_int, duration_int,
>>
>>       mysqlpp::sql_time, duration,
>>
>>       mysqlpp::sql_int, user_num,
>>
>>       mysqlpp::sql_datetime, start_time,
>>
>>       mysqlpp::sql_datetime, end_time,
>>
>>       mysqlpp::sql_varchar, vehicle_num,
>>
>>       mysqlpp::sql_tinyint, replied,
>>
>>       mysqlpp::sql_tinyint, used,
>>
>>       mysqlpp::sql_tinyint, active);
>>
>>  
>>
>>  
>>
>> query << "select * from parkingscylar where id = " <<
> msg_in.park_num;
>>
>>                         mysqlpp::StoreQueryResult res = query.store();
>>
>>  
>>
>> ===>stock row = res[0]; Error from here "mysqlpp::BadConversion at memory
>> location"
>>
>>  
>>
>> stock orig_row = row;
>>
>>  
>>
>> row.user_num = msg_in.user_num; (it's an int number "45")
>>
>>  
>>
>> query.update(orig_row,row);
>>
>>  
>>
>> query.execute();
>>
>>  
>>
>> what is wrong here?
>>
>>  
>>
>> My table is as follows:
>>
>>  
>>
>> +--------------+--------------+------+-----+---------+-------+
>>
>> | Field        | Type         | Null | Key | Default | Extra |
>>
>> +--------------+--------------+------+-----+---------+-------+
>>
>> | id           | int(11)      | YES  |     | NULL    |       |
>>
>> | area         | int(11)      | YES  |     | NULL    |       |
>>
>> | latitude     | double(10,7) | YES  |     | NULL    |       |
>>
>> | longtitude   | double(10,7) | YES  |     | NULL    |       |
>>
>> | charge_num   | int(11)      | YES  |     | NULL    |       |
>>
>> | duration_int | int(11)      | YES  |     | NULL    |       |
>>
>> | duration     | time         | YES  |     | NULL    |       |
>>
>> | user_num     | int(20)      | YES  |     | NULL    |       |
>>
>> | start_time   | datetime     | YES  |     | NULL    |       |
>>
>> | end_time     | datetime     | YES  |     | NULL    |       |
>>
>> | vehicle_num  | varchar(20)  | YES  |     | NULL    |       |
>>
>> | replied      | tinyint(1)   | YES  |     | NULL    |       |
>>
>> | used         | tinyint(1)   | YES  |     | NULL    |       |
>>
>> | active       | tinyint(1)   | YES  |     | NULL    |       |
>>
>> +--------------+--------------+------+-----+---------+-------+
>>
>>  
>>
>>  
>>
>> Please help out here.
>>
>>
>>   
>>     
>
>   


Thread
Modifying rowsDemetris Zavorotnichenko16 Oct
  • Re: Modifying rowsWarren Young16 Oct
    • RE: Modifying rowsDemetris17 Oct
Re: Modifying rowsRick Gutleber17 Oct