Delphi For PHP Forums    


Go Back   Delphi-PHP Forums > Programming > PHP - Code
Forum Jump Register FAQ Members List Downloads Search Today's Posts Mark Forums Read

PHP - Code PHP programming - Ask questions and help people with PHP code. If you are stuck and need help, this is where you ask for help.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11th November 2008, 14:46
D4PHP User
 
Join Date: May 2008
Posts: 96
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 11th November 2008, 16:58
D4PHP Enthusiast
 
Join Date: Apr 2007
Location: Barrie, Ontario, Canada
Posts: 185
jomitech is a glorious beacon of lightjomitech is a glorious beacon of lightjomitech is a glorious beacon of lightjomitech is a glorious beacon of lightjomitech is a glorious beacon of light
Default

You can't really.

What sort of problem did you have?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 04:58.




Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 ©2009, Crawlability, Inc.
Copyright © 2004 - 2009, G&J Solutions Ltd. All Rights Reserved. terms of use