RE: loop problems

2002-10-04 Thread Bryan Love
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

2002-10-04 Thread Michael Conger
...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