Click here to Skip to main content
15,893,668 members
Home / Discussions / Web Development
   

Web Development

 
GeneralCDONTS not supported need to change to CDO or CDOSYS Pin
amorlatina3-Oct-04 13:41
amorlatina3-Oct-04 13:41 
Questionhow can i start in creating an ASP.Net forum using c# Pin
Eng Nashwa2-Oct-04 23:19
Eng Nashwa2-Oct-04 23:19 
AnswerRe: how can i start in creating an ASP.Net forum using c# Pin
sefaen3-Oct-04 14:49
sefaen3-Oct-04 14:49 
AnswerRe: how can i start in creating an ASP.Net forum using c# Pin
V.4-Oct-04 0:13
professionalV.4-Oct-04 0:13 
Generalpopulating grid from xml - a new logic needed. Pin
manivannan.p2-Oct-04 2:07
manivannan.p2-Oct-04 2:07 
GeneralCSS Pin
sessie1-Oct-04 5:22
sessie1-Oct-04 5:22 
GeneralPictures on web services Pin
Anonymous1-Oct-04 0:59
Anonymous1-Oct-04 0:59 
GeneralError MySQL Error: 1064 - subqueries Pin
Ovidiu Caba1-Oct-04 0:21
Ovidiu Caba1-Oct-04 0:21 
I have a problem. I receive this error:

Database error: Invalid SQL: select b.id as category, a.id as link, a.*, 1*(a.showt-a.showc)+ #total search 1*(a.showc) + #total in category 3*(a.hit) as criteria2 from links a right join link_categories b where (category,link,criteria2) in ( select b.id as category, a.id as link, 1*(a.showt-a.showc)+ #total search 1*(a.showc) + #total in category 3*(a.hit) as criteria from links a right join link_categories b on b.id=a.category_id where To_Days(Now()) - TO_Days(a.ldate) > 7 order by criteria asc limit 0, 5) order by criteria2 desc;
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (category,link,criteria2) in ( select b.id as categ)

The SQL statement is:

select b.id as category, a.id as link, a.*,
1*(a.showt-a.showc)+ #total search
1*(a.showc) + #total in category
3*(a.hit)
as criteria2
from links a right join link_categories b
where (category,link,criteria2) in (
select b.id as category, a.id as link,
1*(a.showt-a.showc)+ #total search
1*(a.showc) + #total in category
3*(a.hit)
as criteria
from links a right join link_categories b
on b.id=a.category_id
where To_Days(Now()) - TO_Days(a.ldate) > 7
order by criteria asc
limit 0, 5)
order by criteria2 desc;

Where might be the problem?

You might be a killer and you even don`t know it.
Questionhow to saves images Pin
Anonymous30-Sep-04 22:07
Anonymous30-Sep-04 22:07 
AnswerRe: how to saves images Pin
Pradeep Shamarao28-Oct-04 19:22
Pradeep Shamarao28-Oct-04 19:22 
GeneralXHTML 1.1 Pin
Jacob Hammack30-Sep-04 21:26
Jacob Hammack30-Sep-04 21:26 
GeneralRe: XHTML 1.1 Pin
Tomas Petricek7-Oct-04 13:03
Tomas Petricek7-Oct-04 13:03 
GeneralRe: XHTML 1.1 Pin
Jacob Hammack7-Oct-04 16:25
Jacob Hammack7-Oct-04 16:25 
GeneralJavaScript Picture Viewer Pin
sefaen30-Sep-04 16:54
sefaen30-Sep-04 16:54 
GeneralRe: JavaScript Picture Viewer Pin
Tomas Petricek7-Oct-04 13:13
Tomas Petricek7-Oct-04 13:13 
QuestionASPX/Perl stepping on each other? Pin
webjunkie30-Sep-04 16:23
webjunkie30-Sep-04 16:23 
Generalpadding style problem... Pin
theJazzyBrain30-Sep-04 9:06
theJazzyBrain30-Sep-04 9:06 
GeneralRe: padding style problem... Pin
benjymous1-Oct-04 0:10
benjymous1-Oct-04 0:10 
GeneralRe: padding style problem... Pin
theJazzyBrain1-Oct-04 1:03
theJazzyBrain1-Oct-04 1:03 
GeneralRe: padding style problem... Pin
benjymous1-Oct-04 1:16
benjymous1-Oct-04 1:16 
GeneralRe: padding style problem... Pin
sefaen3-Oct-04 9:58
sefaen3-Oct-04 9:58 
GeneralRe: padding style problem... Pin
benjymous3-Oct-04 21:37
benjymous3-Oct-04 21:37 
GeneralRe: padding style problem... Pin
sefaen5-Oct-04 11:20
sefaen5-Oct-04 11:20 
General!!PERL!! "Can't locate object method 'connect' via package DBI ....(perhaps you forgot to load "DBI" ?)" Pin
bilas30-Sep-04 7:52
bilas30-Sep-04 7:52 
QuestionHow do I create a single or double ALL black splitter??? Pin
alex.barylski29-Sep-04 8:25
alex.barylski29-Sep-04 8:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.