Yeah, I think that if the field is numeric, then the quotes might
present a problem. Try removing the quotes for numerics, but keep them
for all text-ish fields. However, best practice is to use the sql
query param tag, if you're dealing with user-input data in your sql.
Thanks,
Jamie
On Wed, 4 Feb 2004 16:11:54 -0000, in cf-talk you wrote:
>Jamie
>
>Is the syntax wrong ? search_p_staffnumber is numeric ?
>
> -----Original Message-----
> From: Jamie Jackson [mailto:[EMAIL PROTECTED]
> Sent: 04 February 2004 16:09
> To: CF-Talk
> Subject: Re: What could be wrong with this code ? Any expertise
>on this please??
>
>
> On Wed, 4 Feb 2004 15:49:48 -0000, in cf-talk you wrote:
>
> >14 : where a.EmployeeNumber = '#Search__P_STAFFNUMBER#'
> >
> >15 : and ((a.AA_Section = '#SESSION.SECTION#')
>
> These are both text fields, and not numerics?
>
> Jamie
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
