Sometimes I have found you can get this sort of error if the value in the query is not immediately apparent as a simple value - I know it shouldn't matter, but easy to try: (I had this exact problem the other day; Access - memo)
instead of <cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId,authorBioDetail) VALUES (#session.authorPkey#, '#bookArray[43]#') </cfquery> try: <CFSET st = bookArray[43]> <cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId,authorBioDetail) VALUES (#session.authorPkey#, '#st#') </cfquery> for the sake of tidyness I usually put a trim in too so: <CFSET st = trim(bookArray[43])> jason kufner wrote: > > you're mostly right--- but all the client gave me was a GAINT text file, so > using regular expression I pulled out a book at a time and then using more > regular expressions I dumped the results into an array, which I am sorting > through and inserting into an access database into their respective tables. > So far 55 books worked fine until this one record... The client doesn't want > ANY characters changed, it's their catalog... > > Please- any more ideas are GREAT!! > > Argh. > > > so, i gleen from this... > > > > you are moving data from a filemaker pro database, to an access > > database, both > > databases have dsn's setup in the administrator, you can query each, and > > both work, but the problem is that dumping data into this memo field is > > bombing > > at this point. > > > > have you tried putting this string, or portions of this string manually > > into > > a cfquery...run it, to a test db, with the field type the same, size > > etc. and see what > > characters you can take out, to make it work? > > > > just running through my usual debug process... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
