• 상품문의

[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Ambiguous column name 'Srprice'. (severity 16) [파일] /home/taegg2/public_html/lib/myFuncMS.inc [라인] 473
[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/lib/myFuncMS.inc [라인] 473
[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/lib/myFuncMS.inc [라인] 473
SELECT count(*) FROM ( SELECT B.DeleteYes, L.* FROM psProdList as L INNER JOIN psProdMain as B ON L.PMInc = B.PMInc WHERE B.DeleteYes = 0 and B.ViewYes = 1 and B.Stock = 1 and L.Lrprice >= Srprice and (B.MallKind = 'US') and B.MallID != 'toryburch' ) A WHERE 1=1
[에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/lib/myFuncMS.inc [라인] 478
[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Ambiguous column name 'Srprice'. (severity 16) [파일] /home/taegg2/public_html/data/ProdList.inc [라인] 122
[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/data/ProdList.inc [라인] 122
[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/data/ProdList.inc [라인] 122
select * from ( SELECT ROW_NUMBER() OVER ( order by PMInc desc ) as RNUM, * FROM ( SELECT B.DeleteYes, L.* FROM psProdList as L INNER JOIN psProdMain as B ON L.PMInc = B.PMInc WHERE B.DeleteYes = 0 and B.ViewYes = 1 and B.Stock = 1 and L.Lrprice >= Srprice and (B.MallKind = 'US') and B.MallID != 'toryburch' ) A WHERE 1=1 ) AA WHERE RNUM BETWEEN ((1-1) * 50) + 1 AND 1*50
[에러코드] 2 [에러내용] mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/ProdList.inc [라인] 138
[에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/ProdList.inc [라인] 139