Re: Ignoring Rows with Empty Fields?

["Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>]

[q][i]Originally posted by: [b][b]Kronin555[/b][/b][/i]
 Why not just do:
 <cfquery name="getsimilar" datasource="#datasource#" maxrows="5">
 SELECT catshortname, soshortname, retailer_name
 FROM merchants
 WHERE soshortname is not null and soshortname != ''
 AND catshortname='#getmerchant.catshortname#'
 ORDER BY retailer_name ASC
 </cfquery>

 The reason there's 2 checks is I'm not sure if you're storing empty values as 
nulls or empty strings.[/q]
 Just so you know, this:
 and soshortname != ''
 makes this
 WHERE soshortname is not null
 unnecessary.