On Wed, Aug 11, 2010 at 10:41 PM, adv <[email protected]> wrote: > > Yeah I tried that, ticked both boxes, cycled CF and tried again. >
And ... ? It's still not working? Exact same error whether or not the boxes are checked? >From what you're saying this seems to be on the database/driver side of things and doesn't really have anything to do with Mach-II from what I can tell. Doesn't mean I won't try to help, just making sure we don't get sidetracked worrying about Mach-II versions, etc. because Mach-II wouldn't have anything to do with a query erroring out like this. Can you try creating a simple CFML page that runs that same query outside the context of Mach-II so we can focus in on the query itself? And are you *positive* it's the text fields causing the errors? Does it break when you *run* the query or when you're outputting the query? Are you doing any formatting, etc. on specific query columns that might be throwing things off? Is there any chance the error is related to specific data being returned by the query? In other words, if you limited the query to a specific record using an ID in the WHERE clause, does it still break, or is there perhaps some data in some particular row that's throwing things off? Have you tried a different JDBC driver to see if you get the same results? I see you mention CF 9--is this a regular query or are you using ORM? Can you post your query code? -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- You received this message because you are subscribed to Mach-II for CFML list. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mach-ii-for-coldfusion?hl=en ***New URLs as of April 29th, 2010*** SVN: http://svn.mach-ii.com/machii/ Wiki / Documentation / Tickets: http://trac.mach-ii.com/machii/
