
August 10th, 2005, 02:54 PM
|
|
Contributing User
|
|
Join Date: Aug 2004
Location: NYC
Posts: 81
Time spent in forums: 20 h 19 sec
Reputation Power: 5
|
|
|
CF_EXCEL Query Problem
I have the following code below using the CF_EXCEL tag. This code works fine if only selecting from one table, but just goes on forever when I select from two tables as shown below. The datafields are exactly the same for both tables, and I have even tried referencing which table field is which (ex. table1.LastName,table1.FirstName, etc)
I get an error after a while from ColdFusion stating that an error has occured and nothing else. I am guessing it is a timeout error.
Anyone have any idea how can I make this work with multiple tables? Thanks.
<CF_EXCEL
Datasource = "datasource"
TableHeadings = "Last Name,First Name,Mailing Address,Mailing Address 2,Mailing City,Mailing State,Mailing Zip"
DataFields = "LastName,FirstName,MailingAddress,MailingAddress2,MailingCity,MailingState,MailingZip"
SQLCommand = "SELECT * FROM table1, table2">
|