Webmaster Forum / ColdFusion / Advanced Techniques / April 2007

I cannot get this to work.  Any ideas?
___________________________________________________________
<cfquery name="obtain" datasource="esp">
SELECT #form.querystructure#  

Gday,
just wondering if there is a way of inserting the body of an email into a
database table.
i will have up to 1000 emails coming in at one time, all with the same fields

I get the following problem when trying to use the refactored iText 1.4.6.
Class coldfusion.runtime.java.JavaProxy can not access a member of class
com.lowagie.textNew.pdf.PdfWriter with modifiers "protected"
Im trying to call the following function.

ID    upperID    Name                     isFolder
1    0    Folder 1                        1
2    1    Folder 1- Sub Folder    1
3    2    Folder1-Item1-A    0

I am working on a project where the XML file doesn't always have the same stuff
in it. So I need to be able to read the node names but I can't remember how in
CF.  argh.  Tried searching on it and came up blank.
So if you are quick you may help me here before it hits me in the ...

Hi all, I am trying to get our site back up and running after a reformat and
can't get WDDX packet deserialization to work anymore.  Here is my code:
<CFHTTP method="GET"
url="http://www.fubr.info/api/getCommunity.cfm?COMM=#URL.COMM#">

Hey, I have information in my database 50 something and counting and I want to
display this information 10 at a time on my web page, I want to set up a Next
and Previous link so users and sort through the information. So for example
when the page loads I want information 1-10 to ...

I am creating a secure page that uses variables for the url from the page
before it.  My coldfusion MX book tells me to use the #CGI.SCRIPt_NAME#
variable so that when the user logs into the page it will continue to where
they wanted to go but this does not work for me.  I get an ...

Hi i have a scheduled task which runs the code below, i am having problems with
it.
what i need to do is
1. get all records from appoint_table where the servertime is lessthan time

Good morning all.
I have a dropdown select box populated with departments name. So when one
select one of the department, the system should query the employees info in the
oracle db based on the selected department, and then should display on a div

I've just migrated to a new server and now I'm getting a
java.lang.OutOfMemoryError every day or two. The new server has two dual core
processors and 16 GB of RAM. It's running j2sdk1.4.2_11 and W2K Server
Enterprise edition. The site serves in excess of 60,000 visitors per day. ...

I have some code that I have been developing on a server running CF version
5.0.  I realized that we have migrated our production servers to MX and moved
my code to the MX dev box.  Once I did, the code I have written to create an
excel file is not working the same way. With CFF ...

please help me this code to use a loop instead of cfif series. thank you!
<cfquery name="getqry1">
     select test from testtable where tabshow = 149
</cfquery>

Does anyone know how you can effectively work with exchange server using
coldfusion? I have only found one article that discusses this specific issue:
http://www.numtopia.com/terry/code_exchange_item_creator.cfm

I have code in my application that is working via different directories. The
page with the code is in a directory called cf and there are pages in a
different directory that need to use the same code. right now it is set up like
this: