RE: loop problems
use IN instead of = CFQUERY NAME=fullcheckquery DATASOURCE=brinventory SELECT Steel.width, Steel.weight, Steel.length, Steel.quantity, Steel.price, location.location,
Re: loop problems
...use... AND lookup.type_id IN (Select type_id from lookup where lookup.type = '#form.steeltype#') ...instead of... AND lookup.type_id = (Select type_id from lookup where lookup.type = '#form.steeltype#') -Michael Conger [EMAIL PROTECTED] - Original Message - From: Webmaster [EMAIL