jason kufner wrote: > <cfquery name="newAuthorBio" datasource="#application.dsn#"> > INSERT into authorBio (authorBio_authorId, authorBioDetail) > VALUES (#session.authorPkey#, '#bookArray[43]#') > </cfquery>
<cfquery name="newAuthorBio" datasource="#application.dsn#"> INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES ( <cfqueryparam cfsqltype="cf_sql_integer" value="#session.authorPkey#">, <cfqueryparam cfsqltype="cf_sql_varchar" value="#bookArray[43]#"> ) </cfquery> I don't know what datatype a memo field is in SQL terms, so you could also try longvarchar and clob instead of varchar. > 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, This is where it breaks. The single quote is not escaped for some reason. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
