I prefer <cfif len(query.column)> or just <cfif query.column> > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 18 February 2004 16:00 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL Server NOT EQUAL TO <NULL> > > > Why didn't I think of that :) > > Cheers Ade, that worked. > > James > > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 February 2004 15:55 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL Server NOT EQUAL TO <NULL> > > Try '' instead of '<null>'. CF converts DB nulls to empty strings > on output. > > Ade > > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 18 February 2004 15:52 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] SQL Server NOT EQUAL TO <NULL> > > > Afternoon guys, > > Quick question: > > I'm trying to insert an image into a page using a references kept > in an SQL > Server DB. Here's the code: > > <CFIF #getSuppliers.logo# neq '<NULL>'> > <td valign="top" align="right"><CFOUTPUT query="getSuppliers"><img > src="logos/#logo#.jpg"></CFOUTPUT></td> > </CFIF> > > This works fine when there is actually a value in a record but > I'm getting a > red cross when it doesn't (indicating it's ignoring my CFIF statement). > > Basically, how do you tell it to ignore the table row if the value is > <NULL>? > > Cheers in advance, > James > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human > help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > >
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
