Im in mysql-front and I'm running that query in the sql-editor and substituting #flash.param1# for 11
And I aint getting any results back, in products.MENU_SUBCAT_ID both entries have 11 in that field -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Payne-Rhodes Sent: Saturday, 16 April 2005 9:54 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Query Hi Bjorn, If all you want is BrandName and ProductName then SELECT products.NAME as ProdName, brands.NAME as BrandName FROM products, brands WHERE products.MENU_SUBCAT_ID = #Flash.Param1# AND brands.BRAND_ID = products.BRAND_ID Should do what you want. Regards, Brett B) Bjorn Schultheiss wrote: > I know I already gave you guys praise, but that sql statement didn't work > for me > > Heres want I want to achieve > Below are the tables, I stripped out most of the fields > > CREATE TABLE products ( > PRODUCT_ID int(6), > MENU_SUBCAT_ID tinyint(4), > BRAND_ID int(4), > NAME varchar(50), > PRIMARY KEY (PRODUCT_ID) > ) > CREATE TABLE brands ( > BRAND_ID int(4), > NAME varchar(50), > PRIMARY KEY (BRAND_ID) > ) > > My param I'm passing from Flash relates to products.MENU_SUBCAT_ID > > SELECT products.NAME as ProdName, products.BRAND_ID, brands.NAME as > BrandName > FROM products, brands > WHERE products.BRAND_ID = brands.BRAND_ID > AND products.MENU_SUBCAT_ID = #Flash.Param1# > > I need a result like > BrandName, ProdName; > I-mate , smartphone; > > Guys this is killing me > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
