I am working on a ColdFusion 5.0 DB2-ODBC application and have the need to count the characters inserted into a text area and action different SQL dependant on the number of characters. The text area input has to be broken into "chunks" of 250 characters unknowns to the application user (they go on merrily typing). The first 250 characters go into the "prime" table and the following chunks of 250 characters need to be inserted as separate records in a second datasource each chunk have an incremented sequential ID. The chunks are reassembled into a contiguous blocks at SQL Select-Run time using the incremented sequential ID. All this complexity is because the DB2 datasource cannot accept more that 250 character blocks.
Has anyone done anything like this or can give me any pointers to where to look. Mike Brunt Sempra Energy 213.244.5226 "Artificial Intelligence usually beats natural stupidity." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
