$strSQL = "SELECT * FROM view_stocklist WHERE UID = '".$strUID."' ";
ผมเปลี่ยนเป็น
$strSQL = "SELECT * FROM view_stocklist WHERE 1 AND UID = '".$strUID."' ";
มันจะขึ้น error แบบนี้อะครับ
Warning: mssql_query() [function.mssql-query]: message: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'. (severity 15) in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 17
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 18
{"StatusID":"0","UID":"0","Error":"No barcode "}
Warning: mssql_query() [function.mssql-query]: message: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'. (severity 15) in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\joyMssql.php on line 16
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 17
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 18
{"StatusID":"0","MemberID":"0","Error":"No barcode "}