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]
