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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
