nahh never mind that wouldnt do it either i dont think...my mistake. sorry. tw
-----Original Message----- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Sunday, November 03, 2002 12:02 AM To: CF-Talk Subject: RE: Return of the sql wierdness ERROR message '#preserveSingleQuotes('#bookArray[43]#')#' try it like this..... tw -----Original Message----- From: jason kufner [mailto:jasonkufner@;rio.com] Sent: Friday, November 02, 2001 11:59 PM To: CF-Talk Subject: Return of the sql wierdness ERROR message This is a two for one problem. I get this error message if I wrap the array statement with the preserveSingleQuotes: Code: <!--- insert authors BIO---> <cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES (#session.authorPkey#, '#preserveSingleQuotes(bookArray[43])#' ) </cfquery> Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 48 at position 45. ColdFusion was looking at the following text: [ Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (47:38) to (48:13). Thank you all for the help but its still throwing the error message!! And because of the weird error above I turned the array into a vaiable and then ran that. So far its only this record that chokes... <!-new code--> <!-- below is teh 'work around' for the wierdness above...---> <cfset AuthorBio = bookArray[43]> <!--- insert authors BIO---> <cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES (#session.authorPkey#, '#preserveSingleQuotes(AuthorBio)#' ) </cfquery> See bellow: Error Diagnostic Information 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). ' )" Data Source = "FILTER1" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:6) to (45:65) in the template file C:\INETPUB\WWWROOT\WIPFFILTER\INSERTAUTHORINFO.CFM. Date/Time: 11/02/02 20:44:29 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 127.0.0.1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
