Delphi For PHP Forums    

Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish By Hybr!d

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: 71
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
  #2 (permalink)  
Old 11th November 2008, 16:58
D4PHP Enthusiast
 
Join Date: Apr 2007
Location: Barrie, Ontario, Canada
Posts: 180
jomitech is just really nicejomitech is just really nicejomitech is just really nicejomitech is just really nicejomitech is just really nice
Default

You can't really.

What sort of problem did you have?
__________________
Jon

Components For PHP - The complete component suite for Delphi For PHP.
PlatinumGrid - Powerful and flexible PHP grid control.
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 02:36.




Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, 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