prepared statements

[ShaolinF]

Hi Guys

When executing prepared statements, will one need to also bind parameters for datetime columns in the DB or will the system do it automatically?

[Mchl]

If you want to do anything with these columns you generally need to bind parameters to them...

Could you give an example of what you're trying to do?

[ShaolinF]

table below:

id auto_increment PRIMARY KEY,

product_name varchar(233),

product_type varchar(100),

product_weight varchar(10),

date_posted datetime

 

In the preparedstatment I insert the values for product_*, I dont need to bind a param for ID since its auto. Is the same applicable for the date_posted col (i.e. i dont need to bind a param to it since its automatic)?

 

[Mchl]

DATETIME is not automatic. TIMESTAMP with DEFAULT CURRENT_TIMESTAMP is. (at least in MySQL, you might be using something else though) In such case, you can ommit it in insert statement.

 

And BTW: wouldn't product_weight be better represented by numeric type, such as DECIMAL?