Home > Backend Development > PHP Tutorial > php 调用mssql 存储过程不能执行有关问题

php 调用mssql 存储过程不能执行有关问题

WBOY
Release: 2016-06-13 12:49:25
Original
830 people have browsed it

php 调用mssql 存储过程不能执行问题
存储过程不能执行还是什么情况,反正不能出现结果

require("../inc/hbmconn.php");<br />
<br />
//传入vip 姓名<br />
$name=iconv("utf-8","gb2312",$_REQUEST['name']);<br />
$startTime="2012-04-01";<br />
$endTime="2012-04-03";<br />
$procedure = mssql_init("procGetVIPConsumeDetail",$conn);<br />
mssql_bind($procedure,"@vipConsumerFilter",$name, SQLVARCHAR); <br />
mssql_bind($procedure,"@startDate",$startTime, SQLDATETIME); <br />
mssql_bind($procedure,"@endDate",$endTime, SQLDATETIME); <br />
$resource = mssql_execute($procedure);<br />
mssql_free_statement($procedure);
Copy after login


不能执行,不知啥情况,路过的帮忙看看

存储 php
------解决方案--------------------
本帖最后由 xuzuning 于 2013-04-03 14:52:51 编辑 常量 SQLDATETIME 没有定义
请确认你书写的是否正确
你还可以 print_r(get_defined_constants());
看一下是否有类似的常量

最后那条错误信息的含义不太清楚,可能是日期格式不对吧
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template