Hi there
I have 2 queries that both work.
The first I was using to get information from a table in the database:
Select *
From
tbl_procedures p
Where procedurecategoryid = #url.procedurecategoryid#
This query returned all the procedures which had a procedurecategoryid = the
url procedurecategoryid.
Now for each procedure there is a possibility of a matching record that
exists in another table the procedure_asset table.
Now I have a query
Select *
From
tbl_procedures p,
procedure_asset pa
Where (
p.procedureid = pa.procedureid and
procedurecategoryid = #url.procedurecategoryid#
)
The trouble I am having is that if there is no matching record in the
procedure_asset table the query is not returning any records.
I guess what I really want is for all the records to be returned
irrespective of whether there is a matching record - and if there does
happen to be a matching record then I get the information from the procedure
asset table.
Thanks in advance for feedback.
Regards
Pete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
