I am trying to pull data from 2 tables 1) seach by order number the ORDERS table, and Query ORDER_ID 2) search the SHIPMENTS table for the above resultant ORDER_ID's I have built this code so far. <cfparam name="Form.OrderNumber" default="1"> <cfquery name="order" datasource="carbs"> SELECT * FROM carbs.orders, carbs.shipments WHERE OrderNumber = <cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.OrderNumber#" maxlength="40" /> </cfquery>
Im a bit gray on how to show the result of the second search in my cfquery. Should the results be in one cfquery, or two of them? Whould there be an or in the WHERE Statement? I also am trying to use a cfdump to output the results of this query but am a bit lost as to where to have it build that. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 <http://www.motorcyclecarbs.com/> www.motorcyclecarbs.com
