Is this possible from Cold Fusion? If I could do this it would be the best
although I tested it and it didn't work.
this query:
<cfquery name="qGetRequestsByAffiliate" datasource="inforequests">
SELECT contacts.date, contacts.firstname, contacts.mi,
contacts.lastname, contacts.address1, contacts.address2, contacts.city,
contacts.state, contacts.zip, contacts.country, contacts.email,
contacts.homephone, contacts.workphone, contacts.age, names.company,
contacts.usersmessage
FROM dbo.contacts, content.dbo.I_aff_names AS names,
content.dbo.I_zipcodes AS zips
WHERE contacts.ZIP = zips.zip AND zips.chapter = names.id AND
contacts.date > (getDate() - 7)
ORDER BY company, lastname, firstname
</cfquery>
throws this error:
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'content.dbo.I_aff_names'.
BTW, I appreciate everyone's help!
John
>Perhaps I missed it in your earlier post, but if you're using SQL Server
>(and I'm sure other DB servers can do the same), why not simply reference
>the foreign db/table in your queries?
>
>For example, say you have db/table WebApp/customers and db/table
>Utility/zipcodes - in your CFQUERY, use the DSN for WebApp and then
>reference the zip code table as Utility.dbo.zipcodes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
