[에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Invalid object name 'psProdMain'. (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410
select
e.EIInc,e.CustKind,e.CustID,e.ServiceID,e.VenID,e.EMInc,e.EGInc,p.PMInc,e.ProdKind,e.ProdInc,e.ColorTxt,e.Score,e.SellCnt,e.ClickCnt,
e.DeleteYes,e.CreateDate,e.CreateOper,e.ModifyDate,e.ModifyDate8,e.ModifyOper ,p.Pimg,p.Pname,p.BrandID,p.BrandKor,p.Lrprice,p.Srprice,p.MagicViewYes,p.Stock,
CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,
FPMInc,OptColorTxt,StockCnt,StockCntOptYes,
p.CreateDate8,VideoYes,p.ProdCouponDcYes,p.ProdCouponDcKind,p.ProdCouponDcValue,
Bimg=(select top 1 Bimg=convert(text,Bimg) from cgColorMain where DeleteYes=0 and ProdInc=e.ProdInc and ColorTxt=e.ColorTxt )
from
(
select EIInc,CustKind,CustID,ServiceID,VenID,EMInc,EGInc,PMInc,ProdKind,ProdInc,ColorTxt,Score,SellCnt,ClickCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psEventItem where DeleteYes=0
and EMInc=19
and EGInc =177
) e,
(
select ProdKind,PMInc, FPMInc,Pimg=convert(text,Pimg), Pname, BrandID,BrandKor, Lrprice ,Srprice ,Sprice, DeleteYes, Stock, ViewYes,MagicViewYes,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,StockCnt,StockCntOptYes,CreateDate8,VideoYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue from psProdMain
) p
where
e.PMInc = p.PMInc
and p.DeleteYes=0 and p.Stock =1 and p.ViewYes=1 and p.Srprice > 0 and (p.ProdKind<>'PROD' or (p.ProdKind='PROD' and p.Sprice > 0) )
order by
e.Score desc ,
e.EIInc Desc
[에러코드] 2 [에러내용] mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 427 [에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 428 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Invalid object name 'psProdMain'. (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410
select
e.EIInc,e.CustKind,e.CustID,e.ServiceID,e.VenID,e.EMInc,e.EGInc,p.PMInc,e.ProdKind,e.ProdInc,e.ColorTxt,e.Score,e.SellCnt,e.ClickCnt,
e.DeleteYes,e.CreateDate,e.CreateOper,e.ModifyDate,e.ModifyDate8,e.ModifyOper ,p.Pimg,p.Pname,p.BrandID,p.BrandKor,p.Lrprice,p.Srprice,p.MagicViewYes,p.Stock,
CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,
FPMInc,OptColorTxt,StockCnt,StockCntOptYes,
p.CreateDate8,VideoYes,p.ProdCouponDcYes,p.ProdCouponDcKind,p.ProdCouponDcValue,
Bimg=(select top 1 Bimg=convert(text,Bimg) from cgColorMain where DeleteYes=0 and ProdInc=e.ProdInc and ColorTxt=e.ColorTxt )
from
(
select EIInc,CustKind,CustID,ServiceID,VenID,EMInc,EGInc,PMInc,ProdKind,ProdInc,ColorTxt,Score,SellCnt,ClickCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psEventItem where DeleteYes=0
and EMInc=19
and EGInc =178
) e,
(
select ProdKind,PMInc, FPMInc,Pimg=convert(text,Pimg), Pname, BrandID,BrandKor, Lrprice ,Srprice ,Sprice, DeleteYes, Stock, ViewYes,MagicViewYes,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,StockCnt,StockCntOptYes,CreateDate8,VideoYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue from psProdMain
) p
where
e.PMInc = p.PMInc
and p.DeleteYes=0 and p.Stock =1 and p.ViewYes=1 and p.Srprice > 0 and (p.ProdKind<>'PROD' or (p.ProdKind='PROD' and p.Sprice > 0) )
order by
e.Score desc ,
e.EIInc Desc
[에러코드] 2 [에러내용] mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 427 [에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 428 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Invalid object name 'psProdMain'. (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410
select
e.EIInc,e.CustKind,e.CustID,e.ServiceID,e.VenID,e.EMInc,e.EGInc,p.PMInc,e.ProdKind,e.ProdInc,e.ColorTxt,e.Score,e.SellCnt,e.ClickCnt,
e.DeleteYes,e.CreateDate,e.CreateOper,e.ModifyDate,e.ModifyDate8,e.ModifyOper ,p.Pimg,p.Pname,p.BrandID,p.BrandKor,p.Lrprice,p.Srprice,p.MagicViewYes,p.Stock,
CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,
FPMInc,OptColorTxt,StockCnt,StockCntOptYes,
p.CreateDate8,VideoYes,p.ProdCouponDcYes,p.ProdCouponDcKind,p.ProdCouponDcValue,
Bimg=(select top 1 Bimg=convert(text,Bimg) from cgColorMain where DeleteYes=0 and ProdInc=e.ProdInc and ColorTxt=e.ColorTxt )
from
(
select EIInc,CustKind,CustID,ServiceID,VenID,EMInc,EGInc,PMInc,ProdKind,ProdInc,ColorTxt,Score,SellCnt,ClickCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psEventItem where DeleteYes=0
and EMInc=19
and EGInc =179
) e,
(
select ProdKind,PMInc, FPMInc,Pimg=convert(text,Pimg), Pname, BrandID,BrandKor, Lrprice ,Srprice ,Sprice, DeleteYes, Stock, ViewYes,MagicViewYes,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,StockCnt,StockCntOptYes,CreateDate8,VideoYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue from psProdMain
) p
where
e.PMInc = p.PMInc
and p.DeleteYes=0 and p.Stock =1 and p.ViewYes=1 and p.Srprice > 0 and (p.ProdKind<>'PROD' or (p.ProdKind='PROD' and p.Sprice > 0) )
order by
e.Score desc ,
e.EIInc Desc
[에러코드] 2 [에러내용] mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 427 [에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 428 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: message: Invalid object name 'psProdMain'. (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 16) [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410 [에러코드] 2 [에러내용] mssql_query() [function.mssql-query]: Query failed [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 410
select
e.EIInc,e.CustKind,e.CustID,e.ServiceID,e.VenID,e.EMInc,e.EGInc,p.PMInc,e.ProdKind,e.ProdInc,e.ColorTxt,e.Score,e.SellCnt,e.ClickCnt,
e.DeleteYes,e.CreateDate,e.CreateOper,e.ModifyDate,e.ModifyDate8,e.ModifyOper ,p.Pimg,p.Pname,p.BrandID,p.BrandKor,p.Lrprice,p.Srprice,p.MagicViewYes,p.Stock,
CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,
FPMInc,OptColorTxt,StockCnt,StockCntOptYes,
p.CreateDate8,VideoYes,p.ProdCouponDcYes,p.ProdCouponDcKind,p.ProdCouponDcValue,
Bimg=(select top 1 Bimg=convert(text,Bimg) from cgColorMain where DeleteYes=0 and ProdInc=e.ProdInc and ColorTxt=e.ColorTxt )
from
(
select EIInc,CustKind,CustID,ServiceID,VenID,EMInc,EGInc,PMInc,ProdKind,ProdInc,ColorTxt,Score,SellCnt,ClickCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psEventItem where DeleteYes=0
and EMInc=19
and EGInc =181
) e,
(
select ProdKind,PMInc, FPMInc,Pimg=convert(text,Pimg), Pname, BrandID,BrandKor, Lrprice ,Srprice ,Sprice, DeleteYes, Stock, ViewYes,MagicViewYes,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,OptColorTxt,StockCnt,StockCntOptYes,CreateDate8,VideoYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue from psProdMain
) p
where
e.PMInc = p.PMInc
and p.DeleteYes=0 and p.Stock =1 and p.ViewYes=1 and p.Srprice > 0 and (p.ProdKind<>'PROD' or (p.ProdKind='PROD' and p.Sprice > 0) )
order by
e.Score desc ,
e.EIInc Desc
[에러코드] 2 [에러내용] mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 427 [에러코드] 2 [에러내용] mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [파일] /home/taegg2/public_html/data/EventItem.inc [라인] 428