>- see footer for list info -< Hi Paul Here would be an example from my previous email
<!--- access text content workbook---> <cfquery name="TEXT_CONTENT" datasource="#importDNS#"> SELECT * FROM [TEXT CONTENT$] IN 'c:\excel\upload.xls' 'EXCEL 5.0;' WHERE content_body like '%UK%' </cfquery> Where TEXT_CONTENT is the name of the worksheet (i.e. the default is sheet1, sheet2 etc) content_body is the column name within the worksheet hth mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood Sent: 26 October 2005 14:03 To: [email protected] Subject: Re: [Spam] [CF-Dev] Excel Datasource >- see footer for list info -< Do you have a typical query that I can look at that brings the rows back dynamically ...? Regards - Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
