| Author | Messages | |
goodvibes
Member
Posts:2
 | | 05/21/2007 11:18 PM |
 Alert | I'm trying to run this query on the default portal...
SELECT Title, StartDate, Description
FROM EVENTS
WHERE (Description LIKE '%keydate%') AND (StartDate > GETDATE() AND (StartDate < GETDATE() + 14))
ORDER BY FinishDate
but get this error on the page...
A critical error has occurred.
Invalid column name 'Title'. Invalid column name 'StartDate'. Invalid column name 'Description'. Invalid column name 'FinishDate'. Invalid column name 'Description'. Invalid column name 'StartDate'. Invalid column name 'StartDate'. | | | |
| dnnstuffadmin
DNNStuff Founder
Site Member
Posts:1264
| | 05/22/2007 5:45 AM |
Alert | Those fields aren't valid names for the Events table. Just do a SELECT * FROM EVENTS to see what the fieldnames are. It looks like you want EventDateBegin, EventDateEnd, EventName and EventDesc.
| |
Richard Edwards
DNNStuff Founder | |
|
|