I have the following two sql statements:
1)
<CFQUERY DATASOURCE="usreps" Name="rep">
SELECT low, high, name, phone, ext
>From rep_salesreps
WHERE ('#FORM.zip#'#chr(62)#=low) and ('#form.zip#'#chr(60)#=high)
</CFQUERY>
This one works fine as is.
However, I need to get this second one to do the same thing, just against two
tables:
2)
<cfquery name="rep" datasource="usreps_new">
SELECT RepFinder_Basic.*,RepFinder_Ext.*
FROM RepFinder_Basic,RepFinder_Ext
WHERE ('#FORM.zip#'#chr(62)#=BegZip) and ('#form.zip#'#chr(60)#=EndZip)
</cfquery>
Any suggestions?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2578
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
