Jay, You are absolutely right and I thank you profusely! I screwed up on the table name. At any rate, this worked fine for me (once I realized the err in my ways) using OLEDB drivers on CF 5, haven't tested with ODBC.
Thanks so much to all who helped. John Venable On Wednesday, February 5, 2003, at 06:27 PM, Jay Freeman wrote: > Hmm, I do this all the time and just verified it works from both CF > 4.01 > using ODBC and CFMX using the native SQL driver. > > Does the user/pass used in your "inforequests" DSN have sufficient > rights > to the "content" db? > > Jay > > At 02:20 PM 2/5/2003, you 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 >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
