Mary,
If I understand correctly, your code looks roughly like this:
<CFQUERY NAME="MyQuery" blah blah blah>
SELECT VarCharField FROM blah blah blah
</CFQUERY>
<FORM blah blah blah>
<CFOUTPUT>
<INPUT TYPE="text" NAME="MyInput" VALUE="#MyQuery.VarCharField#"
blah blah blah>
</CFOUTPUT>
blah
blah
blah
</FORM>
So, your field value:
this is a "quoted title" to view
is plugged in, so that the VALUE parameter reads:
VALUE="this is a "quoted title" to view"
If you use single quotes, it works, since the single quotes inside the
double quotes get translated into double quotes in the final. What you
might do is use the Replace function to replace double quotes with single
quotes as you put the value in the parameter statement. Your statement
would look like this:
<INPUT blah blah VALUE="#Replace(MyQuery.VarCharField,"""","'","ALL")#" blah
blah>
I am not sure that this is what you are looking for, but hopefully it will
get you started in the right direction.
Matthieu
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 7:42 AM
> To: CF-Talk
> Subject: Weird Problem - Additional Info
>
>
> In addition, if I put single quotes in, it works just fine.
>
> Any info would be appreciated.
> Mary
> ----- Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -----
>
> I am having the strangest problem...
>
> I have a varchar field in a SQL database. It contains the
> following text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or
> input) everything
> after the first quote is cut off in the text box. But if I
> display the
> code before the text box , the field contains all the proper
> information.
>
> So the field is coming back fine, but when the form is
> displaying, it cuts
> it off.
>
> I am using <CFFORM>.
>
> Does anyone have any ideas?
>
> TIA
> Mary
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
