Hmmm, that doesn't seem right. What version of CF are you on?
CFMX 6
Is it save to assume the insert and select you showed are inside of a
cfquery tag?
Yes, the two query tags were there.
Are you by change building this SQL in a cfsavecontent and then passing
it to the database?
No,
Claude Schneegans wrote:
Try this :
CFSET temp = getRecord_qry.memo
INSERT INTO TableName_tb
(memo)
VALUES
('#temp#')
Thank you for the suggestion. I tried setting a variable before the query as
you suggest, and then referencing the variable, but the error persisted.
Roberto
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
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:
What about using br?
Message herebr#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
Faircloth
[EMAIL PROTECTED] wrote:
What about using br?
Message herebr#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
Yeah, looking back over the context, it is rather strange
to store the text and html in a db, especially if it's used often.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 2:02 PM
To: CF-Talk
Subject: Re: String format issue
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
Well, the message here text would only be included for the transfered
records, i.e., those processed
Charlie Griefer wrote
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?
Oh, the message is just a generic
Rick Faircloth wrote:
What about using br?
Message herebr#getRecord_qry.memo#
Yeah, if I include the message as part of the output, the br tag would do it.
I was trying to have it all together (message, carriage return, original memo)
in one DB field (without any HTML), but I may have to
cfquery automatically escapes single ticks
It does, but only if a single variable is passed in the query, not if it
is a more complex expression,
and apparently not even if it is a column in a query.
Try this :
CFSET temp = getRecord_qry.memo
INSERT INTO TableName_tb
(memo)
VALUES
('#temp#')
Hmmm, that doesn't seem right. What version of CF are you on?
Is it save to assume the insert and select you showed are inside of a
cfquery tag? If so, cfquery automatically escapes single ticks (which
is a very handy anti-SQL inject feature).
Are you by change building this SQL in a
(cfqueryparam value=#getRecord_qry.memo# cfsqltype=cf_sql_varchar /)
On Fri, Jun 27, 2008 at 1:59 PM, Roberto Perez [EMAIL PROTECTED] wrote:
Hi all,
I do not know what keywords I could use to investigate this in the archives,
so I'll describe the issue and hopefully you'll be able to tell be
13 matches
Mail list logo