joinAdd

Hello everyone I’m working with db_dataObjects - I’m trying to get a resultset of products, from the database, that are on special offer that correspond to a specific code in the ‘product’ table. The code is ‘nikrs’ and I want to find out any products that have this code in ‘product’ and then to check the specialoffer table containing product_id for these products. So to clarify – if anyone missed it – ‘product’ contains ‘catcode’ and I want to search for products with the catcode and then look in ‘specialoffer’ for ‘product_id’ for any products with the catcode. My question is, do I use joinAdd() and does anybody have any good examples of similar situations in their own code I could have? If not – what method should I use? Cheers Steve Steve Fisk Web Application Developer KOA Solutions Ltd Tel : 01925 758229 FAX : 01925 758023 This message is confidential. Unless you are the named addressee or their delegated representative you may not use, disclose, or copy the contents of the e-mail. If you are not the named addressee please notify the sender immediately and delete the material from your computer. Any views or opinions contained in this e-mail are solely those of the author unless expressly stated otherwise --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.458 / Virus Database: 257 - Release Date: 24/02/2003 ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________