Ask a Question related to Coldfusion Database Access, Design and Development.
-
Farmy #1
PreserveSingleQuotes() problem
Hi, I have a database in which some of the text in it has a single quote,
mainly to show posession, such as " cat's ".
Anyway, I can't get this function to work properly to display the aposthrophe
and I keep getting boxes instead. Heres my code, can someone tell me where I
should impletment the function?
~~~~~~~~~~~~~
<cfquery Name="Projects" datasource="chamber">
SELECT project, scope, members, year, status
FROM main ORDER BY year
</cfquery>
<html>
<head>
<title>List of All</title>
</head>
<body>
ALL THE PROJECTS
<br>
<table width="800" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="100"> Project</td>
<td width="400"> Project Scope</td>
<td width="100"> Members</td>
<td width="100"> Years</td>
<td width="100"> Status</td>
</tr>
<cfoutput query="Projects">
<tr>
<td width="100"> #project#</td>
<td width="400"> #scope#</td>
<td width="100"> #members# </td>
<td width="100"> #year# </td>
<td width="100"> #status# </td>
</tr>
</cfoutput>
</table>
<p> </p>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~`
Farmy Guest
-
PreserveSingleQuotes Not Working in CFQUERY
Just a heads up to those for those using CFSCRIPT within a CFQUERY to compose a Dynamic SQL statement. When you try to use... -
PreserveSingleQuotes and Evaluate
Hi all. I've run into a bit of a problem with part of an application. I have users inputting , what can be, multiple animal (Species) names and... -
Problem playing Quicktime thru .DCR embedded in HTML - pathreferencing problem?
Greetings earthlings and Director heads. Here's the problem: created an HTML file containing shockwave (dcr) movie that calls quicktime movies in... -
Uploading problem = weird warning (was: access denied problem.....)
Hi, I had a problem where my upload form was not working on our production server but was working on two other servers, after checking the... -
Problem with Apache Web Server config file and PHP (please give advice on what problem may be me)
HI: Can anyone refer me to someone that can help with the problem below. I installed Apache Web Server on my laptop which has Windows XP. I... -
jdeline #2 Re: PreserveSingleQuotes() problem
> and I keep getting boxes ...
Are you copy-and-pasting from a Word document? Microsoft''s smart quotes will
do this to you. The single quote you see isn't really an ASCII 39. I'd run
the (untested) debugging code below to see what the character really is.
<CFOUTPUT>
<CFLOOP i="1" TO="#Len(offendingString)#>
<CFSET temp = Mid(offendingString, i, 1)>
#temp# (#Asc(temp)#)
</CFLOOP>
</CFOUTPUT>
jdeline Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
