I am getting a type mismatch error with this query. I am currently using
Access while waiting for SQL Server connection to be configured.I cant see
what ius causing the error?
<cfquery name="GetFunds" datasource="infotrac_test">
select tbl_accounts.account_id, tbl_accounts.account, tbl_fundsrc.fund_id,
tbl_fundsrc.type_fund, tbl_codes.code_id, tbl_codes.code
from tbl_accounts, tbl_fundsrc, tbl_codes
where tbl_accounts.account_id = tbl_fundsrc.fund_id and
tbl_fundsrc.fund_id = tbl_codes.code_id
order by tbl_accounts.account_id, tbl_fundsrc.fund_id
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
