Quotes in database query cut string

[NoWizod]

I am pulling information from a database which includes measurements and to show inches quotes are used. So, when I create the query and list, those Descriptions with measurements are being truncated where there are quotes. I haven't been able to find a solution. Without getting too crazy is there a way around this?
Thanks!!

 

[r937]

can't help you without seeing code

start by showing us the CFQUERY and CFOUTPUT tags involved

r937.com | rudy.ca

 

[NoWizod]

Yes...that might be helpful! Sorry about that... To further clarify, I am able to print from the <cfoutput> tags, however it's being passed via the form to the form handler. I'm thinking that may be where the issue lies.

<cfquery datasource="HardwareStore" name="products">
SELECT * FROM Products
</cfquery>

<cfoutput>#Description#</cfoutput>

<input type="hidden" value="#Description#" name="Description">

Form Handler:

<cfset itemDesc = ListGetAt(#FORM.Description#,#value#)>
       <td><cfoutput>#itemDesc#</cfoutput></td>

Thanks for checking it out!

 

[r937]

yup, that's your problem, any embedded " in the description will prematurely terminate the INPUT VALUE

you could do this --

<input type="hidden" value='#Description#' name="Description">

but then you'd have the same problem with any embedded '

however, since we are talking about product descriptions, what's the harm in entity-encoding the quotes?

i.e. replace " with &#8221; and ' with &#8217;




r937.com | rudy.ca

 

[NoWizod]

So, would the best way to accomplish that be to REReplace on the query strings?
Thanks!!

 

[r937]

Replace will do it, no need to use REReplace

r937.com | rudy.ca

 

[NoWizod]

Thanks!!
Is my syntax incorrect here? It looks correct to me but is throwing me an error.

<cfset FORM.Description = Replace(#FORM.Description#,'"',&#8221,all)>

 

[r937]

= Replace(FORM.Description,'"','”','all')

r937.com | rudy.ca

 

[NoWizod]

Thanks for your efforts. Unfortunately the strings are still being truncated. I may have to set it up differently.
Thanks again!

 

[FALCONSEYE]

ok, i just did a small test:

http://www.jetansolutions.com/test7.cfm

when you enter stuff like 2"2' to the textfield and hit submit, the page displays the same entry. so, will it be possible that your field gets truncated because somebody enters information more than they are supposed to? i.e. the field is defined as varchar(10) and i enter 12 characters. it will truncate the last 2 chars.

hope it helps...

http://www.jetansolutions.com

 

[cfStarlight]

Use the HTMLEditFormat() function

<cfoutput>...
<input type="text" value="#HTMLEditFormat(Description)#" name="Description" />
</cfoutput>

 

[forumposters]

What would be the difference in using &quot; instead of &#8221;?

 

[r937]

i believe there might be wider support among obscure browsers for the numeric entity

essentially no difference in all major browsers

r937.com | rudy.ca