[에러코드] 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 L.Ccode1='63' and L.Ccode2='2' and L.Ccode3='9' 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 L.Ccode1='63' and L.Ccode2='2' and L.Ccode3='9' 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