the problem though. My ISP is using MySQL 3.23 and Union isn't supported
until MySQL 4.0. I'm having a bad day right now.
Cutter
Philip Arnold wrote:
> > From: Cutter (CF-Talk)
> >
> > 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]
