Charlie Griefer wrote: >(<cfqueryparam value="#getRecord_qry.memo#" cfsqltype="cf_sql_varchar" />) >
Thank you for the suggestion. This solution worked with a slight variation: since I'm using Access as my Db (sorry, I forgot to mention that), I used "cf_sql_longvarchar" instead. Using the original "cf_sql_varchar" with Access generates an "Invalid Precision Value" error message. Also, using quotes around the cfqueryparam expression (as I erroneously did initially) enters a question mark into the database. So the expression I have now is: INSERT into DB (memo) VALUES (<cfqueryparam value="Message here #getRecord_qry.memo#" cfsqltype="cf_sql_longvarchar" />) Now if I could only figure out how to insert a carriage return between the word "here" and the variable. I tried #Chr(13)# and \r to no avail. Any suggestions are welcome. Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
