Tried wrapping it in a toString? Or perhaps xmlformat? Dunno what would do that off hand...
On 4/25/06, rhymes with 'loud' Doug Boude <[EMAIL PROTECTED]> wrote: > > 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:238722 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
