Webmaster Forum / ColdFusion / Advanced Techniques / February 2005

For some reason I'm keep getting an error on my script .  The error states that
the variable i'm using(UserID) is undefined.   I have declared this
variable(UserID) in my database has a PK(primary key)  here is the script
<cfquery name=state datasource=contact> Select * from ...

Hello How are you : this is the codes I used in one of my cfm page: <cfquery
name='re' datasource='real_state'>     SET NOCOUNT ON DECLARE @RequestID INT  
INSERT dbo.Request(PropertyID,requestTypeID)
VALUES(#Session.PropertyID#,'#requestCode.requestTypeID#') SELECT

Hello gurus,
I have a form which collects text and one file field for file upload. The
contents of the text fields, as well as the filename in the file field get
written to a database after upload.

When a user logs in they are taken to station_managers.cfm on this page they
can access training records for:
Cashier Checklist
Console Operator

We are getting an error while trying to export html to Excel. What could be the
problem and what is the solution. This is part of the code where error occurs:
--------------------------------------------------------- <CFOBJECT            
            ACTION='CONNECT'             ...

I have a problem. I use a url link to pass sort order and it works fine. I also
use a form as a search results filter that works fine.  The problem that I have
is once I have used the form to limit my results, I cannot figure out how to
get my URL header sort to refresh the page ...

i'm haveing a problem. i made a little blog. all data is saved in a ms access
DB (temporary. gonna move it to MySQL)
when i output the text, no matter how many times i pressed enter in the
textarea, its always on the same line(except i use the <br> tag. but that cant

Hi all, I have put together two <cfselect> dropdown fields that query a
database to be populated.  That works fine.  After the user fields out the form
and make a choice from the dropdown fields and click submit, I am trying to
pull the name from the dropdown box an pull the ...

I am starting to learn the new form system that came in to cfmx7. I have it
down farily well, except for one probelm. I am working on a update record page.
And I have a check box that I would like to be dynamic, so that if 1 is in the
field in the database, it would be checked, ...

Hi all,  I have a rounding problem and am wondering if anyone has seen a UDF or
has code that can do this.  I have a number with two decimal places. ie 4.78.  
I need to round the second decimal place up to either .05 or to the next
number. For instance 4.78 would round up to 4.80 ...

How can I get a value using a dynamic variable name?
it should do something like:
variable = application.#url.id#.name (which is of course false syntax)
I know Flash does it with soemthing like:

I have used the code from the 'Advanced Coldfusion Development Book by Ben
Forta' to build the regex tester, as iam building an app that will use a great
deal of regex. The tester uses a UDF called REFindMatches, but every time I run
the regex tester i get an error saying: ...

I have an interesting situation here that I hope people can help with.  I am
currently porting a very old application from a CF4.5 and a CF5.0 install to a
brand new server that will have CF5.0 installed.  (So we have 1 old machine
with 4.5 installed, and another old machine ...

I was having problems seeing (IsDefined) my client vars in application.cfm....are client vars not seen in applications.cfm or is there some reason this does this?

I'm currently running CFMX 6.1 on Red Hat 8 / Apache 1.3, and I'm looking to
upgrade my Apache to 2.0... Is there an easy way to just switch over the
connector? All these instructions about compiling things are confusing me!
Thanks,