> As for cf_csv2query, I found it. After testing it, I found that it is > putting 0.00 in all my numeric fields, even if there is a value in the > csv. > See attached custom tag
Ah yes that is the one I was talking about and not that $50.00 one. Look at the source for that tag. On Lines 167 and 169 the code, the way it is written, forces CF_SQL_VARCHAR for all field types. This is the bug the author told me didn't exist. His cfsqltype parameter is ignored thanks to this code. What its supposed to do is default to cf_sql_varchar and, if the sqltype parameter is present, implement the specified parameter instead, but he hard-coded cf_sql_varchar on both lines. He also didn't account for null values, as you point out. Thats something else I fixed, by adding null="#YesNoFormat(not Len(cfqueryparamvalue))#" to the cfqueryparam statements. I wrote this file up at least a year ago. Maybe two, but it was based on the csv2data tag. I concentrated on cleaning it up and making it work right more than I did making sure I had removed everything I extraneous (pretty sure there are some vars in there that do nothing). Try it and let me know if the reworked version solves your problems. It did for me. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:212263 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
