Webmaster Forum / ColdFusion / Advanced Techniques / March 2007

I have a column in a SQL database which contains data (numbers separated by a
pipe sign ex: 23|2|5) and I want to write something that will update the second
number which in this case, 23|2|5, it would be 2.  Can someone help me out on
this?

sorry for my very bad english
i use httpxmlrequest to answer a database and show resultin a div
the string means utf-8 encoded by my javascript fonction and, of course,
no result are found in the database.

I am trying to pass a bunch of dynamically generated URL variables on to the
next page and there I want to make a list of them so I can perform a database
operation for each.  How can I build a list or array or whatever kind of
structure is best suited to then be able to do this?

I have a few cfm pages/scripts that process a lot on the server side and take
a while to process. Is it possible to stream the page content rather than show
the whole page once the script has processed? This way people can see progress
while they wait.

I have a search screen. I would like to hide the form elements after the information from the database is displayed.
How could I accomplish this?

I am trying to insert a UUID into 2 different tables at the same time ie to let
this be created in the form and then insert this ID into 2 linked tables in a
database using Access.
Does anybody have any suggestions on how to accomplish this?

I have a simple Stored Procedure in SQL that deletes a row from a table based
on a variable that comes fom a CF app.  I would like to be able to copy this
row to another table to use as a Delete Log.  The destination table has
different field names since more than one table will ...

When I run the attached code the e-mail sends but when I open the e-mail in
GMAIL it's blank.  When I send the same e-mail and open through POP3 or iMail
the contents of the e-mail are shown just fine.
Any ideas?

I've 'register your details' cf form on website that's hijacked by spammers to
send spam email. Whats best practice, general idea or code if you have, to
prevent this spamming, ie prevent it occurring in the first place and/or stop
the spam now occurring through  registration ...

I want to hide a bit of data unless outside the USA, what would be the best method of doing this?

I have a form with a text field. The name of the field is a reference to a
structure held in
memory (session scope)
this is the example of the form field

I am working on an online test. (Users read the question and submit their
answers via drop down list). It all works very nicely if I put all the
questions on one page (in one cfform). But...
What I'd like to do is display only one question per page. When a user selects

Hello, the letter that needs to be generated has a "TO" section and a person's
last name should be started with "uppercase" and rest of them is printed
"lowercase", but some cases are treated differently. (Users need to input the
last name before they generate the letter).

I created a discussion board. Each entry displays the preferences of the user
who posted the entry, such as 'Allow Private Messages', 'Allow Emails' etc.
When looping through the entries, I have to query the database to get the
preferences for each individual 'poster'. Because I ...

Hi all -
I've been scratching my head over this one. Any help would be appreciated...
Every 1 to 6 days I receive an error like the following: "Element is undefined
in a Java object of type class coldfusion.runtime.CookieScope referenced as The