VIJI
|
Posted: 06/01/2004, 2:20 AM |
|
Hai
I am using SQL SERVER & PHP
1) $query = mssql_init("Generate_Recur", $s);
2) $V_Date = $GL_Search->GL_Date->Value;
3) mssql_bind($query, "@PDate", &$V_Date, SQLVARCHAR);
4) mssql_bind($query, "@R_Msg", &$R_Msg, SQLVARCHAR, TRUE, FALSE, 100);
5) $result = mssql_execute($query);
6) $GL_Search->Errors->AddError($R_Msg);
GL_Date is of type date
Line 3 gives an error when executed -- Error while converting data type varchar to datetime
What type of constant should we use to pass date types
Thanks
Viji
Kindly help me
|
|
|
|