Ahhhh...hadn't thought about that. I'll see about finding and replacing that.
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 3:17 PM To: CF-Talk Subject: RE: Coldfusion creating an excel file, problems.... I'll take a wild guess and suggest that the problem is not the &, but the <. Your ColdFusion will happily spit that account number out, but the web browser will try to do something with anything that starts with <. > -----Original Message----- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Friday, December 02, 2005 2:06 PM > To: CF-Talk > Subject: Coldfusion creating an excel file, problems.... > > I'm using CF to create an Excel file for me on the fly. There > are currently > 2500 records in the db, but when I create the Excel file I > only get 1850, > and the content gets cut off right in mid record. I'm > wondering if there's > some crazy character in one of the fields that's doing it. > Does anyone have > any ideas? Here's some samples of the Account NUmber field > (from the client, > not from me): > > A4062834023)_<D,NRan > A4042737277%2NV(ITim > A5021563429#` %4PAmy > A5021563429%L*)<PHec > A4052758846!E#CPOBri > A4042744086&Y+H?NJen > > Here's the column where the output stops: > A0072037096&<%Y6OMit > > I get nothing after this snippet: A0072037096&, but there are > other fields > that have & in them and no problem. > > > And here's the code I'm using: > > <cfheader name="content-disposition" > value="attachment;filename=Fortna_Mailing_List.xls"> > <cfcontent type="application/msexcel"> > > <html> > <head> > <title> new document </title> > </head> > <body> > > <cfquery name="outputList" dataSource="#Application.DSN#" > dbType="#Application.DBType#" username="#Application.username#" > password="#Application.password#"> > SELECT * > FROM mailinglist > </cfquery> > > <table id="excel_tbl"> > <tr> > <td>Subscribe Date</td> > <td>Account Number</td> > <td>Name</td> > <td>Organization</td> > <td>Email Address</td> > <td>Phone</td> > <td>Send Email?</td> > <td>Subscribe Status</td> > </tr> > <cfoutput query="outputList"> > <tr> > <td>#DateFormat(info_dateadded,"mm-dd-yyyy")#</td> > <td>#info_accountno#</td> > <td>#info_name#</td> > <td>#info_org#</td> > <td>#info_email#</td> > <td>#info_phone#</td> > <td>#info_sendemail#</td> > <td>#info_status#</td> > </tr> > </cfoutput> > </table> > > </body> > </html> > > <!----------------//------ > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225976 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54