Error going into S4 forum
Thread Starter
Super Moderator
Joined: Mar 2000
Posts: 10,467
Likes: 0
Error going into S4 forum
Error with SQL Query
select mid, tid, pid, state, date, subject, flags, name, email, DATE_FORMAT(date, "%Y%m%d%H%i%s") as tstamp from messages-1 where tid = '36621' and ( state = 'Active' or state = 'Moderated' ) order by mid desc
Error #1064: You have an error in your SQL syntax near '-1 where tid = '36621' and ( state = 'Active' or state = 'Moderated' ) order by ' at line 1
Tried again and it worked.
select mid, tid, pid, state, date, subject, flags, name, email, DATE_FORMAT(date, "%Y%m%d%H%i%s") as tstamp from messages-1 where tid = '36621' and ( state = 'Active' or state = 'Moderated' ) order by mid desc
Error #1064: You have an error in your SQL syntax near '-1 where tid = '36621' and ( state = 'Active' or state = 'Moderated' ) order by ' at line 1
Tried again and it worked.
Thread
Thread Starter
Forum
Replies
Last Post
sparks555
A6 / S6 (C6 Platform) Discussion
6
Oct 20, 2015 12:34 PM
