What about using "<br>"? Message here<br>#getRecord_qry.memo#
Rick > -----Original Message----- > From: Roberto Perez [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2008 12:22 PM > To: CF-Talk > Subject: Re: String format issue > > 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:308322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4