>
> I am getting the following error and I can't understand why. Code of
> statement is below it. Any help is appreciated...
>
> Syntax error or access violation: You have an error in your
> SQL syntax
> near 'union select s.intSpEventsID as ID, s.txtSpEventsTitle
> as Title, '
> at line 8
>
> The error occurred in /home/httpd/seacrets/data.cfm: line 59
>
> 57 : <cfdump expand="yes" var="#qEvents#"><br /> <br />
> 58 :
> 59 : <cfquery name="qHoliday" datasource="#application.config.DSN#">
> 60 : select h.intHolidayPlusID as ID,
> 61 : h.txtHolidayPlusTitle as
Title,
Need more of the SQL as it looks to be a UNION problem rather than at
the top of the query
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
