View Single Post
  #1 (permalink)  
Old 11th November 2008, 14:46
ducky ducky is offline
D4PHP User
 
Join Date: May 2008
Posts: 87
ducky is on a distinguished road
Default Query parameters data type

Hi,
I have a SQL query with parameters:

Code:
$strSQL = "INSERT INTO myTab VALUES(:par1,:par2)";
$params = array('par1'=>$this->par1->text,
                'par2'=>$this->par2->text);
$Dm->MyQuery->ParamByNames = $params;
How can I specify the parameters data type?!?
For example, if I tried to insert a value in a date column, PHP would treat the parameter as string by default, and this gives me some problem.

Thank you
Reply With Quote
Sponsored Links