I haven't tried this myself but I think you need a native driver for this rather than an odbc driver. Can someone else confirm or deny this?
In any case, you can test this sql by connecting to your database directly (using sqlplus or other appropriate tool) and running it. --- "Venable, John" <[EMAIL PROTECTED]> wrote: > 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. > ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
