About mssql,

Source: Internet
Author: User
About mssql, I am in a hurry to use the database mssql instead of mysql. I have defined an SQL statement $ SQL and the connection is successful. but why cannot I use mssql_query or mssql_nums_rows? Warning: mssql_query () [function. mssql-query]: Query about mssql, urgent
The database I use is mssql rather than mysql.
I have defined an SQL statement $ SQL
Then the connection is successful.
But why can't mssql_query and mssql_nums_rows be used?

Warning: mssql_query () [function. mssql-query]: Query failed in/opt/coolstack/apache2/htdocs/invoicelog/dealmssql. php on line 113

Warning: mssql_num_rows (): supplied argument is not a valid ms SQL-result resource in/opt/coolstack/apache2/htdocs/invoicelog/dealmssql. php on line 114


------ Solution --------------------
The first error indicates that your query failed.
The second error is associated. if the query fails, the value cannot be set.

Check your SQL commands
------ Solution --------------------
Invalid column name 'bu'
Invalid column name BU does your table have BU fields?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.