seems to me that if you're inserting "Message Here" with *every* insert... might not want to insert it at all. Just display it on the output page :)
Message Here: <cfoutput>#myQuery.memo#</cfoutput> On Mon, Jun 30, 2008 at 9:22 AM, Roberto Perez <[EMAIL PROTECTED]> wrote: > 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:308319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4