Webmaster Forum / ColdFusion / Advanced Techniques / July 2007

I am working on textfield form that enable user to insert text and save in SQL
database as long text datatype. User able to retrieve the saved text and
display in the web page as article.
The problem I am facing at the moment is the article containing RETURN/ENTER

Using <cfif> within a <cfdocument> works ok unless it is within a variable. The
following code fragment:
  <cfset var = "<cfif 1 eq 1>True part<cfelse>False part</cfif>">
  <cfdocument format="pdf" filename="test.pdf">

doing a cfindex using type = custom, action = update and the appropriate
queryname:
the query.recordcount = 2631
the cfindex is executed immediately after the cfquery

I am trying to get data from genbid_assignmentinfo and genbid_bidresult where
this criteria matches ...The facname,facsch, factype must match in both table
along with this genbid_bidresult.isassigned = 'Y' and genbid_bidresult.istemp =
'N' ..I need you help ...

I am trying to dynamically grab all of my fields from my table and put them in
a list, how would I do this...
<cfquery name="getTables" datasource="#db#">
select *

I'm using a QofQ in order to find subcategories from my database.  The database
is made up as follows;
ID, categoryname, subcategoryof
Same sample data would be as follows;

As usual Adobe arent on the ball with this problem.  Anyone any idea how to do this.

I'm looking for a way to customize the URL syntax.
I have an entry, lets say it is a document about Coffee, and the title is
"Decaf Please".
The unique ID for this entry is "4" so the current URL is

Coldfusion when you use cfform etc puts a lot of javascript into my html page
(see example beliw.
Is there someway I can tell coldfusion to include this as an external file as
opposed to including it in the head section?

Hi i have a query, which is below, just pulls info and orders by Surname.
my page displays one record at a time, so what i need is a next and previous
button to go to the next surname in the table
but i am not sure how i would do this, can someone help.

Hi.....
This is my question.  I am using the coldfusion application to send email through and exchange server.  My question is, is it possible to encrypt the email?  thanks.

Error Executing Database Query.  
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 1.  
The Error Occurred in C:\CFusionMX\wwwroot\paidwealth\member\editpassword.cfm:

Ok not sure if this is the correct category to post this in but ill try.
I have a large bespoked program throughout our company allowing users to
manage 'works orders' and other items via web pages with cold fussion etc
(normal stuff)

I have a page that displays results of a search query.  I'd like to give users
an option to export  the results  that they see into  Excel format by clicking
on an icon.
How can I do that?

This one has me completely stumped, so any pointers much appreciated!
I have a simple text field within a form, which I have named as 'getsyou'.  
Upon form submission, the first action is to check whether the user used the ?
sign in the field, and if so, replace it with &pound;