- see footer for list info -<
Youd have to do a select count(whaterver) as visitCount in there somewhere
Paul Swingewood wrote:
- see footer for list info -<
Returns an error ....
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name
'visitCount'.
The error occurred in
D:\inetpub\wwwroot\cfpages\calendar\reports_action.cfm: line 46
44 :
45 : WHERE (tblevent.StartDateTime BETWEEN CONVERT(DATETIME,
#StartDate#, 102)AND
46 : CONVERT(DATETIME,#EndDateTime#,102))
47 :
48 : GROUP BY visitCount
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go
to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
