sorry to be so hasty
-joshua o'connor-rose
-all is good
--- Joshua OConnor-Rose <[EMAIL PROTECTED]> wrote:
> I'm back to this now
>
> Anybody seen this before?
>
> [Macromedia][SequeLink JDBC Driver][ODBC
> Socket][Microsoft][ODBC Microsoft Access Driver]
> Syntax error (missing operator) in query _expression_
> 'active = 1 and adcompany = 4 where office_num in
> (Pa_RaM000,Pa_RaM001,Pa_RaM002)'.
>
> it says my sql looks different too:
>
> select
>
office.office_id,office.office_num,office.office_name,office.city,state.state
>
> from office
> inner join state on office.state=state.state_id
> where active = 1
> and adcompany = 4
> where office_num in ( (param 1) , (param 2) , (param
> 3) ) order by office.office_num
>
> -Joshua O'Connor-Rose
> -All is Good
>
> --- Pascal Peters <[EMAIL PROTECTED]> wrote:
>
> > I forgot to delete "#request.filter#" in the query
> > below
> >
> > > -----Original Message-----
> > > From: Pascal Peters [mailto:[EMAIL PROTECTED]
> > > Sent: 29 July 2004 17:23
> > > To: CF-Talk
> > > Subject: RE: Question about cfqueryparam
> > >
> > > You can't use cfqueryparam like this, it won't
> get
> > evaluated. It has
> > to
> > > be in the cfquery.
> > >
> > > <cfquery datasource="media" name="get_office">
> > > select office_id
> > > from office
> > > #request.filter#
> > > where 0=0
> > > <cfif len(attributes.office_num)>
> > > and office_num in (<cfqueryparam list='Yes'
> > > value='#attributes.office_num#'
> > > cfsqltype='CF_SQL_VARCHAR'>)
> > > </cfif>
> > > </cfquery>
> > >
> >
> >
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
