Re: null query prob

2006-03-01 Thread Jerry Johnson
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

Re: null query prob

2006-03-01 Thread Jim Wright
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

RE: null query prob

2006-03-01 Thread Tim Laureska
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

RE: null query prob

2006-03-01 Thread Adrian Lynch
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