Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -----Original Message----- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 10:14 AM To: Cold Fusion Talk List Subject: Excel Spreadsheet Trouble Good Morning list; I am using Excel as a Datasource with the following. I get strange results pulling from a GENERAL Formatted column. <cfset AutoType="SHEET1"> <CFQUERY NAME="FindAuto" DATASOURCE="fdfordautolist"> SELECT Rebates_cars, Rebates_Trucks FROM `#AutoType#$` </cfquery> <CFOUTPUT> #FindAuto.ColumnList#<BR> </cfoutput> <TABLE> <TR> <TD>Rebates Cars</td><TD>Rebates Trucks</td> </tr> <CFOUTPUT QUERY="FindAuto"> <TR> <TD>#FindAuto.Rebates_Cars#</TD><TD>#FindAuto.REBATES_Trucks#</td> </tr> </cfoutput> </table> Currently the worksheet is as follows: Rebates_Cars Rebates_Trucks N/A 500 N/A N/A 750 1000 The code above will display all N/A for the cars and all dollars for the trucks. If there are more N/A in a column than there is dollars, I do not get any of my rebates but all of the N/A's and vice versa. If there are more rebates then N/A's I get the rebates and none of the N/As You can see this if you go to http://209.234.85.58/QueryTest.cfm I need HELP on this issue as quickly as possible. Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. ~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
