Follow Ben's advice and use the PreserveSingleQuotes() around your variable as you have some single quotes in your text and its breaking your query.
HTH Clint -----Original Message----- From: jason kufner [mailto:jasonkufner@;rio.com] Sent: Friday, November 02, 2001 10:24 PM To: CF-Talk Subject: HELP!! sql wierdness ERROR message Thank you so much for the fast response: Mr. Forta it's always gratifying to see your name in this news group, the Cf community is alive and thriving!! Here is the code in question: <cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES (#session.authorPkey#, '#bookArray[43]#') </cfquery> And Are you ready? Here is the error message: <!--- begin error code----> ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''R.H. Charles was born August 6, 1855 in Cookstown, Co. Tyrone. He was educated at Belfast Academy, Queen's College Belfast (Classics, 1874-80)'. SQL = "INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES (41, 'R.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). ')" <!--- end error code---> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
