NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
242
mssql_query() [function.mssql-query]: Unable to set query [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
247
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
256
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
242
mssql_query() [function.mssql-query]: Unable to set query [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
247
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/OptionMain.inc
256
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]select OMInc,CustKind,CustID,ServiceID,VenID,PMInc,ProdKind,ProdInc,Opt1,Opt2,OptLrprice,OptSrprice,OptPoint,OptLrpriceB,OptSrpriceB,OptPointB,Stock,StockCnt,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psOptionMain where PMInc=22560 and ViewYes=1 order by Opt1 , OMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/CateMain.inc
605
mssql_query() [function.mssql-query]: Unable to set query [query]
select
CMInc,CustKind,CustID,ServiceID,Ccode1,Ccode2,Ccode3,Ccode4,Cname,Depth,Cname1,Cname2,Cname3,Cname4,Pos1,Pos2,Pos3,Pos4,ProdCnt,ProdCntB,ImgMainTitle,ImgLeftMenu,ViewYes,DomesticDeliYes,DesignHtml,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper ,
Pos1_c= case Ccode1 when 0 then 32767 else pos1 end,
Pos2_c= case Ccode2 when 0 then 32767 else pos2 end,
Pos3_c= case Ccode3 when 0 then 32767 else pos3 end,
Pos4_c= case Ccode4 when 0 then 32767 else pos4 end,
ImgButtonMenu
from
psCateMain
where
DeleteYes=0 and ViewYes=1
order by
Pos1_c desc,
Pos2_c desc,
Pos3_c desc,
Pos4_c desc,
CMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/CateMain.inc
611
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]
select
CMInc,CustKind,CustID,ServiceID,Ccode1,Ccode2,Ccode3,Ccode4,Cname,Depth,Cname1,Cname2,Cname3,Cname4,Pos1,Pos2,Pos3,Pos4,ProdCnt,ProdCntB,ImgMainTitle,ImgLeftMenu,ViewYes,DomesticDeliYes,DesignHtml,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper ,
Pos1_c= case Ccode1 when 0 then 32767 else pos1 end,
Pos2_c= case Ccode2 when 0 then 32767 else pos2 end,
Pos3_c= case Ccode3 when 0 then 32767 else pos3 end,
Pos4_c= case Ccode4 when 0 then 32767 else pos4 end,
ImgButtonMenu
from
psCateMain
where
DeleteYes=0 and ViewYes=1
order by
Pos1_c desc,
Pos2_c desc,
Pos3_c desc,
Pos4_c desc,
CMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/CateMain.inc
644
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
select
CMInc,CustKind,CustID,ServiceID,Ccode1,Ccode2,Ccode3,Ccode4,Cname,Depth,Cname1,Cname2,Cname3,Cname4,Pos1,Pos2,Pos3,Pos4,ProdCnt,ProdCntB,ImgMainTitle,ImgLeftMenu,ViewYes,DomesticDeliYes,DesignHtml,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper ,
Pos1_c= case Ccode1 when 0 then 32767 else pos1 end,
Pos2_c= case Ccode2 when 0 then 32767 else pos2 end,
Pos3_c= case Ccode3 when 0 then 32767 else pos3 end,
Pos4_c= case Ccode4 when 0 then 32767 else pos4 end,
ImgButtonMenu
from
psCateMain
where
DeleteYes=0 and ViewYes=1
order by
Pos1_c desc,
Pos2_c desc,
Pos3_c desc,
Pos4_c desc,
CMInc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ProdMain.inc
1030
mssql_query() [function.mssql-query]: Unable to set query [query]
select top 5
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,DeliveryFee,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,Score,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,
PnameCompare= case Pname when '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718' then 1 else 0 end,
PnameCompare2= case Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) when 0 then 1000 else Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='3'
and Ccode3='2'
and Ccode4='0'
and BrandID='Ferragamo'
and PMInc <> 22560
and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) )
order by
PnameCompare desc ,
PnameCompare2 asc ,
newid()
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ProdMain.inc
1037
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]
select top 5
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,DeliveryFee,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,Score,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,
PnameCompare= case Pname when '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718' then 1 else 0 end,
PnameCompare2= case Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) when 0 then 1000 else Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='3'
and Ccode3='2'
and Ccode4='0'
and BrandID='Ferragamo'
and PMInc <> 22560
and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) )
order by
PnameCompare desc ,
PnameCompare2 asc ,
newid()
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ProdMain.inc
1038
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
select top 5
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,DeliveryFee,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,Score,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,
PnameCompare= case Pname when '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718' then 1 else 0 end,
PnameCompare2= case Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) when 0 then 1000 else Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¹Ù¶óÀå½Ä(GINNY) ¹Ì´ÏÅ©·Î½º]21 D855 DEEP TAUPE 0548324/3120718', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='3'
and Ccode3='2'
and Ccode4='0'
and BrandID='Ferragamo'
and PMInc <> 22560
and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) )
order by
PnameCompare desc ,
PnameCompare2 asc ,
newid()
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/function_cust.inc
64
mssql_query() [function.mssql-query]: Unable to set query [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/function_cust.inc
69
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: Unable to set query [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
425
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: Unable to set query [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
425
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ReviewMain.inc
550
mssql_query() [function.mssql-query]: Unable to set query [query]
select top 10
RMInc,CustKind,CustID,ServiceID,VenID,MallID,BrandID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,Pname,Purl,convert(text,Pimg) as Pimg,Lrprice,Srprice,Stock,ColorTxt,SizeTxt,SecretYes,SizeViewYes,Height,Weight,FootSize,Chest,Waist,Img1,Img2,Img3,Img4,Img5,Img6,Img7,Img8,Img9,Img10,MemID,MemYes,OMInc,OrderCode,OIInc,Grade,Score,Title,ReviewTxt=convert(text,ReviewTxt),GongjiYes,ViewYes,ClickCnt,AnswerYes,AnswerTitle,AnswerTitle,Answer=convert(text,Answer),AnswerDate8,DeleteYes,CreateDate,CreateDate8,ModifyDate,ModifyDate8,ModifyOper
from
psReviewMain
where
RMInc not in (select top 0 RMInc from psReviewMain where DeleteYes=0 and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0 order by RMInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0
order by
RMInc desc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ReviewMain.inc
557
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]
select top 10
RMInc,CustKind,CustID,ServiceID,VenID,MallID,BrandID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,Pname,Purl,convert(text,Pimg) as Pimg,Lrprice,Srprice,Stock,ColorTxt,SizeTxt,SecretYes,SizeViewYes,Height,Weight,FootSize,Chest,Waist,Img1,Img2,Img3,Img4,Img5,Img6,Img7,Img8,Img9,Img10,MemID,MemYes,OMInc,OrderCode,OIInc,Grade,Score,Title,ReviewTxt=convert(text,ReviewTxt),GongjiYes,ViewYes,ClickCnt,AnswerYes,AnswerTitle,AnswerTitle,Answer=convert(text,Answer),AnswerDate8,DeleteYes,CreateDate,CreateDate8,ModifyDate,ModifyDate8,ModifyOper
from
psReviewMain
where
RMInc not in (select top 0 RMInc from psReviewMain where DeleteYes=0 and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0 order by RMInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0
order by
RMInc desc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/ReviewMain.inc
558
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
select top 10
RMInc,CustKind,CustID,ServiceID,VenID,MallID,BrandID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,Pname,Purl,convert(text,Pimg) as Pimg,Lrprice,Srprice,Stock,ColorTxt,SizeTxt,SecretYes,SizeViewYes,Height,Weight,FootSize,Chest,Waist,Img1,Img2,Img3,Img4,Img5,Img6,Img7,Img8,Img9,Img10,MemID,MemYes,OMInc,OrderCode,OIInc,Grade,Score,Title,ReviewTxt=convert(text,ReviewTxt),GongjiYes,ViewYes,ClickCnt,AnswerYes,AnswerTitle,AnswerTitle,Answer=convert(text,Answer),AnswerDate8,DeleteYes,CreateDate,CreateDate8,ModifyDate,ModifyDate8,ModifyOper
from
psReviewMain
where
RMInc not in (select top 0 RMInc from psReviewMain where DeleteYes=0 and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0 order by RMInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc=5739 and ViewYes=1 and GongjiYes=0
order by
RMInc desc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/SetMain.inc
172
mssql_query() [function.mssql-query]: Unable to set query [query]select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NoLoginQnaAble'
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/SetMain.inc
179
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NoLoginQnaAble'
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/SetMain.inc
180
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NoLoginQnaAble'
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: Unable to set query [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/lib/myFuncMS.inc
425
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/QnAProd.inc
345
mssql_query() [function.mssql-query]: Unable to set query [query]
select top 10
QPInc,CustKind,CustID,ServiceID,VenID,MemID,Kname,MallID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,BrandID,Pname,Pimg=convert(text,Pimg),Lrprice,Srprice,Qkind,Title,Question=convert(text,Question),Answer=convert(text,Answer),ClickCnt,SMSYes,SecretYes,Stock,AnswerYes,AnswerDate,AnswerDate8,File1,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psQnAProd
where
QPInc not in (select top 0 QPInc from psQnAProd where DeleteYes=0 and ProdKind='MAN' and ProdInc='5739' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='5739'
order by
QPInc Desc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/QnAProd.inc
352
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]
select top 10
QPInc,CustKind,CustID,ServiceID,VenID,MemID,Kname,MallID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,BrandID,Pname,Pimg=convert(text,Pimg),Lrprice,Srprice,Qkind,Title,Question=convert(text,Question),Answer=convert(text,Answer),ClickCnt,SMSYes,SecretYes,Stock,AnswerYes,AnswerDate,AnswerDate8,File1,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psQnAProd
where
QPInc not in (select top 0 QPInc from psQnAProd where DeleteYes=0 and ProdKind='MAN' and ProdInc='5739' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='5739'
order by
QPInc Desc
#PansyErrorContents#
NoID
f767cfa0c7417ff7e7b4748da3dc1964
20130907211714
2
/home/labellusso/data/QnAProd.inc
353
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
select top 10
QPInc,CustKind,CustID,ServiceID,VenID,MemID,Kname,MallID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,BrandID,Pname,Pimg=convert(text,Pimg),Lrprice,Srprice,Qkind,Title,Question=convert(text,Question),Answer=convert(text,Answer),ClickCnt,SMSYes,SecretYes,Stock,AnswerYes,AnswerDate,AnswerDate8,File1,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psQnAProd
where
QPInc not in (select top 0 QPInc from psQnAProd where DeleteYes=0 and ProdKind='MAN' and ProdInc='5739' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='5739'
order by
QPInc Desc
#PansyErrorContents#