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... tw -----Original Message----- From: jason kufner [mailto:jasonkufner@;rio.com] Sent: Saturday, November 03, 2001 12:25 AM To: CF-Talk Subject: Re: Return of the sql wierdness ERROR message Thank you again every one here is the answers to your questions: -This is representative some of the data being inserted. This was a NASTY 550 page file maker pro data base that I'm converting. Some fields are empty some are huge like this one. -It is being dumped into a Memo field. -this machine is version 5. the client is upgrading within the next 2 weeks... -the actual value is bookArray is: H. Charles was born August 6, 1855 in Cookstown, Co. Tyrone. He was educated at Belfast Academy, Queen's College Belfast (Classics, 1874-80), and Trinity College Dublin (Classics and Theology). Charles was ordained a deacon in 1883 and priest in 1884. He married Mary Lilias, 1886; they had no children. He served several curacies in England from 1883-89 before turning to academia in 1890. His studies focused on the religious developments within Judaism in the period between the Testaments, concentrating particularly on the exposition of the Apocalyptic literature, both Christian and Jewish. Charles's work attracted a great deal of attention during his lifetime, becoming a leading authority on his chosen specialties. He became Professor of Biblical Greek at Trinity College Dublin (1898-1906), the Grinfield Lecturer on the Septuagint (1905-11), Speaker's Lecturer in Biblical Studies at Oxford (1910-14), Warburton Lecturer in Lincoln's Inn Chapel from 1919, and Schweich Lecturer of the British Academy (1919-20). He was also elected a fellow of the British Academy in 1906 and of Merton College, Oxford in 1910. In 1925 he was the first recipient of the British Academy Medal for Biblical Studies. Charles also received honorary degrees from the universities of Belfast in 1923 and Oxford in 1928 in recognition for his work. In 1913 he was appointed a canon of Westminister, becoming archdeacon later in 1919. He died at his home in Little Cloisters on January 30, 1931. His publications include: Book of Enoch (1893, 2nd ed. 1912); Apocalypse of St John ( 2 vols., 1920); Critical and Exegetical Commentary on the Book of Daniel (1929); Book of Jubilees (1895); Enoch (1906); The Testaments of the Twelve Patriarchs (1908); The Apocrypha and Pseudepigrapha of the Old Testament in English (2 vols., 1913); A Critical History of the Doctrine of a Future Life in Israel in Judaism and in ChristianityÓ (1899, 2nd revised and enlarged ed., 1913); ÒReligious Development between the Old and the New TestamentsÓ (1914); ÒChronicle of John, Bishop of NikiuÓ (1916). ----- Original Message ----- From: "Jim Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, November 02, 2002 9:17 PM Subject: RE: Return of the sql wierdness ERROR message > Another thought: are you using MX? > > I've recently had a problem with Access on MX: by default the DB Driver > does not accept "long text". There's a check box in the CF Admin Data > Sources area - if you ARE using MX and the box isn't checked CF > (actually the DB driver) may be truncating your insert value. > > In my case the problem was showing up in a select - any "memo" fields > were being returned as having no values to CF even if there were values > in the DB. > > Jim Davis > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
