Webmaster Forum / ColdFusion / Advanced Techniques / September 2004

I have the following:
     <cfset formatted = ReReplaceNoCase(formatted,'<FONT
size=1>([^<]*)</font>','\1','ALL')>
This code only works for the first instance of the case. Any suggestions as to

My SELECT lists show duplicate record data. I would like them to show unique
data only ONCE...
I know about the DISTINCT keyword in SQL. I know about the 'group by attribute
in a CFOUTPUT query tag.

If I have an .xml file on the server, say "file.xml" and I want to erase the
contents of "file.xml" and then write new contents to "file.xml" (essentially
overwrite the file), what do I do?  
I'm looking at <cffile>, and it seems that if I am working with an existing

I'm using the CFCONTENT tag to present a secured PDF-file (695Kb) to my
visitors.
The reasons for using this tag instead of CFLOCATION are:
* adding additional cache-control header-tag

I'm getting an error when displaying fields with names that start with a
number.  For example, #1bd_num_units# produces the following error. In the
attached code #buf_num_units# works fine but #1bd_num_units#  or
#2bd_num_units# produces an error. What causes this and how can I ...

If I use session variables with the UserID as the name for the structure, under
another structure called Auth (<cfparam name=?session.Auth?
default=?StructNew()? type=?structure?> in Application.cfm, then in my
login.cfm custom tag, when establishing a user?s LDAP authenticated ...

Here is the situation...
1) A User specifies search criteria through a form in Application A
2) Application A then sends Application B the search criteria through a URL.
3) Application B sends back the results in XML format in an HTML window

I use a cfhttp POST to get data from one server to be displayed on my webpage.  
The data we get is a query object that we pass with wddx and then convert back
to a query on the webserver with cfwddx.  Since we upgraded to MX this process
has become significantly slower.  Would ...

I'm want to create a recordset of all the records from a table, then display
one record at a time.  Then have nav buttons (start, previous, next, and end),
to step through the recordset one record at a time.  This I can do, but here
come the challenge...

Say a user clicks a certain link on my site, I then create a directory, if it
doesn't already exist, on the user's computer and write a file to that
directory, which the user will know about and have access to.  How can this be
done?

I want to make sure that e-mail addresses submitted on a site have an
actual server available to catch the e-mail address. I thought of using
CFHTTP but I realized that not everserver accepting and sending e-mail
has a site up. Is there another way?

I would like to display my query results in separate table cells within the
same row so that instead of creating a new row for each result, a new cell is
created.
I have this part working fine but I'm having a problem with the hyperlinks.

When trying to perform a TO_CHAR function on a clob in a query to our Oracle
database, our CF MX 6.1 server hangs and never returns a result set. The same
query on our CF 5.0 returns the result set fine. Any ideas? The query in
question...

We recently upgraded to CFMX from CF5.  
I have a simple online form which requests information from our web users.  
The output of the form is sent to one of my content owners directly via email.  
In CF5 the output of this form that was sent to my content owner was nicely

I've experienced some strange behavior of cflocation in my application.  I
wanted to set the "addtoken" to be "no", but then I got a standard "The page
cannot be displayed" error page.  For obvious security reason, I don't want to
set it to "yes" to show the CFID and CFTOKEN ...