You are conditionally running the inner join, but you are always
pulling the states variables.
They both need to be conditional, I think
On 3/1/06, Tim Laureska [EMAIL PROTECTED] wrote:
When I run this query I get sl_applicant is UNDEFINED. could someone
enlighten me :-)
cfquery
You are doing a cfif on the table sl_applicant...which is not a
variable defined in the ColdFusion context...that is part of your
queryif you want to pull back all records, whether or not
sl_applicant.state_hm is NULL, do a left join...
SELECT sl_applicant.*, states.*
FROM sl_applicant LEFT
Thanks Jim... that was the ticket. I always forget about the
left/right joins !
Tim
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 10:41 AM
To: CF-Talk
Subject: Re: null query prob
You are doing a cfif on the table sl_applicant
It also looks like you're trying to access a SQL value in your CF code with
cfif sl_applicant.state_hm IS NOT NULL. You can't mix things like this.
Adrian
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 01 March 2006 15:27
To: CF-Talk
Subject: Re: null query prob
4 matches
Mail list logo