Here is my 2nd issue I'm not sure how to fix today (short of re-writing
the procedure, and since I am billing the customer, I am hesitant to do
that)
I have a site that uses some of the MX Collection of code to perform SQL
inserts, CSV imports, etc. This code imports a CSV file, but any ' or "
characters the customer has in their fields are getting stuck into the
database as question marks ? Is there a way to escape those out so they
are inserted properly? Follows is some of the code.
<cfinclude template="includes/common/KT_common.cfm">
<cfinclude template="includes/tng/tNG.inc.cfm">
<cfscript>
// Make a transaction dispatcher instance
tNGs = Request.tNG_CreateObject("tNG_dispatcher");
tNGs.init("");
</cfscript>
<cfscript>
// Start trigger
formValidation =
Request.tNG_CreateObject("triggers.tNG_FormValidation");
formValidation.init();
formValidation.addField("csvfile1", true, "", "", "", "", "");
tNGs.prepareValidation(formValidation);
// End trigger
</cfscript>
<cfscript>
// Make a CVS Import transaction instance
csv_items = Request.tNG_CreateObject("tNG_CSVImport");
csv_items.init("1800lastbid");
tNGs.addTransaction(csv_items);
// Register triggers
csv_items.registerTrigger("STARTER", "Trigger_Default_Starter", 1,
"POST", "KT_Insert1");
csv_items.registerTrigger("BEFORE", "Trigger_Default_FormValidation",
10, formValidation);
csv_items.registerTrigger("END", "Trigger_Default_Redirect", 99,
"auctionimportdone.cfm");
// Add columns
csv_items.setTable("items");
csv_items.addColumn("itemnum", "NUMERIC_TYPE", "CSV", "Itemnum");
csv_items.addColumn("status", "NUMERIC_TYPE", "CSV", "Status");
csv_items.addColumn("title", "STRING_TYPE", "CSV", "Title");
csv_items.addColumn("description", "STRING_TYPE", "CSV", "Description");
...... Lots more in here.......
csv_items.setPrimaryKey("ID", "NUMERIC_TYPE");
csv_items.setSource("FILES", "csvfile1");
csv_items.setHeader(true);
csv_items.setDelimiter(",");
csv_items.setEnclosure("""");
csv_items.setHandleDuplicates("");
csv_items.setCSVUniqueKey("");
</cfscript>
<cfscript>
// Execute all the registered transactions
tNGs.executeTransactions();
</cfscript>
Thanks in advance,
Chris Peterson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275964
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
