A note to anyone trying to bind a DATETIME (which is apparently unsupported): Just use the SQLVARCHAR type to pass your DATETIME values.
This worked for me with formats such as 01/01/1900 and 01-01-1900.
mssql_bind(PHP 4 >= 4.1.0, PHP 5) mssql_bind -- Adds a parameter to a stored procedure or a remote stored procedureDescriptionbool mssql_bind ( resource stmt, string param_name, mixed &var, int type [, int is_output [, int is_null [, int maxlen]]] )
See also mssql_execute(), mssql_free_statement(), and mssql_init().
add a note
User Contributed Notes
dietcheese
03-Oct-2006 05:41
A note to anyone trying to bind a DATETIME (which is apparently unsupported): Just use the SQLVARCHAR type to pass your DATETIME values.
tim at howarth dot uk dot com
18-Apr-2005 06:47
The behavior appears to be different on windows (using
Anonymous
14-Jan-2005 11:57
You do not have to use mssql_query to pass parameters longer than 255 characters to a stored proc. All you have to do is define the "type" of the field to be SQLTEXT.
matt at austincc dot edu
09-Apr-2003 08:27
two things to keep in mind if you are having trouble binding output parameters:
fjortizATcomunetDOTes
26-Dec-2001 09:18
After creating a statement resource with
| ||||