Hi all. I have an RSS processor that works like a champ, at least it did until it ran into a string value that's causing it to barf. The heart of the challenge is an insert query, where I'm inserting a few fields into a headlines table. All field values are using cfqueryparam tags, but I have one incoming value that is giving me grief and I cannot figure out what cf doesn't like about it. The string length is 940 and the field holds 1000 characters. Any thoughts are greatly appreciated.
The Error: The cause of this output exception was that: coldfusion.tagext.sql.QueryParamTag$InvalidDataException: Invalid data The Query: <cfquery name="insertHeadline" datasource="#variables.dsn#"> INSERT INTO rssheadlines (rssID,headline,description,link,dateinserted) VALUES( <cfqueryparam value="#arguments.sourceID#" cfsqltype="CF_SQL_INTEGER">, <cfqueryparam value="#newInsertItems[j].title#" cfsqltype="CF_SQL_VARCHAR" maxlength="100">, <cfqueryparam value="#newInsertItems[j].description#" cfsqltype="CF_SQL_VARCHAR" maxlength="1000">, <cfqueryparam value="#newInsertItems[j].link#" cfsqltype="CF_SQL_VARCHAR" maxlength="1000">, <cfqueryparam value="#now()#" cfsqltype="CF_SQL_TIMESTAMP"> ) </cfquery> The offending string: When Steve Jobs jumped on stage at Macworld San Francisco 2006 and announced the new Intel-based Macs, the question wasn't if, but when someone would figure out a hack to get Windows XP running on these new 'Mactels.' Enter Boot Camp, a new system utility that helps you partition and install Windows XP on your Intel Mac. Boot Camp does all the heavy lifting for you. You won't need to open the Terminal and hack on system files or wave a chicken bone over your iMac to get XP running. This free program makes it easy for anyone to turn their Mac into a dual-boot Windows/OS X machine. Running Boot Camp guides you step-by-step through the entire installation process, including upgrading your Mac's Firmware, creating the Macintosh Drivers CD to make XP work properly with your Mac's hardware, and using the Boot Camp Assistant to partition your hard drive and install Windows XP. You'll also learn how to avoid common pitfalls (such a.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238620 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
