NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/lib/myFuncMS.inc 424 mssql_query() [function.mssql-query]: message: Incorrect syntax near '만원'. (severity 15) [query] #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/lib/myFuncMS.inc 424 mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [query] #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/lib/myFuncMS.inc 424 mssql_query() [function.mssql-query]: Query failed [query] #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/lib/myFuncMS.inc 425 mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query] #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: message: Incorrect syntax near '만원'. (severity 15) [query]select top 40 PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 0 PMInc from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc ) and DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [query]select top 40 PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 0 PMInc from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc ) and DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: Query failed [query]select top 40 PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 0 PMInc from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc ) and DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 497 mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]select top 40 PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 0 PMInc from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc ) and DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 498 mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]select top 40 PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 0 PMInc from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc ) and DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 order by PMInc desc #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: message: Incorrect syntax near '만원'. (severity 15) [query] select count(1) as count , Ccode1 from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 group by Ccode1 #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [query] select count(1) as count , Ccode1 from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 group by Ccode1 #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 456 mssql_query() [function.mssql-query]: Query failed [query] select count(1) as count , Ccode1 from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 group by Ccode1 #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 497 mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query] select count(1) as count , Ccode1 from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 group by Ccode1 #PansyErrorContents# NoID b44464446066c26e697497183075977e 20120730171433 2 /home/labellusso/data/ProdMain.inc 498 mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query] select count(1) as count , Ccode1 from psProdMain where DeleteYes=0 and BrandID='GUCCI' and Srprice >= 10만원 and Srprice <= 이십만원 and ( ( 1=1 and replace(Pname,' ','') like '%구찌%' ) or ( replace(BrandID,' ','') like '%구찌%' or replace(BrandKor,' ','') like '%구찌%' ) or ProdKind+convert(varchar,ProdInc)='구찌' or convert(varchar,ProdInc)='구찌' ) and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) ) and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' ) and JoinOnlyYes = 0 and GongGuYes=0 group by Ccode1 #PansyErrorContents#