or not storing it in the database in multiple records? :) let's say you want to change that particular text. what's easier... jumping into a .cfm file and changing it once or running an update statement to update all records that have it?
just sayin' :P On Mon, Jun 30, 2008 at 10:58 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > 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:308323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4