I'm using an Excel spreadsheet as a (readonly) datasource for a low-volume application where the user puts some choices in a page, then the action page presents them a range of selections based on the answers to their earlier questions.
However one of the fields in the spreadsheet has many more than the 255 characters expected by a varchar field. Is there a way I can ensure that the spreadsheet driver in CF will see the additional characters in this field? To consider it as an equivalent to SQLServer's TEXT field type? If not, I'm going to have to import that spreadsheet in to my SQLServer database every time they change the spreadsheet - not a happy thought since the app is low-importance and the client wont want to pay for this several times a year. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
