2 svar · 263 visningar · startad av lillebror
Får följande felkod i min SQL-sats...
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/forumdisplay.asp, line 32
"SELECT iif(maxDate is null,ThreadPosted,maxDate), author,subject from ((SELECT (select max(ThreadPosted from t_threads where answerid = t.threadid) as maxDate, ThreadPosted, author, subject from t_threads t) dt order by 1 desc"
Någon idé om vad som är fel?
Chansar på det här:
SELECT
iif(maxDate is null,ThreadPosted,maxDate) AS col1,
author,
subject
FROM
(
SELECT
(
select
max(ThreadPosted)
from
t_threads
where
answerid = t.threadid
) as maxDate,
ThreadPosted,
author,
subject
from
t_threads t
) dt
order by
col1 desc
Får upp föjande felkod nu när jag kör SQL-satsen...
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forumdisplay.asp, line 35