Webmaster Forum / ColdFusion / Advanced Techniques / November 2004

I've got a list with items 3, 5, 8, 12.  If I run a loop through numbers 1-20,
those 4 numbers are always identified, but so are 1 and 2 because 1 next to 2
is 12.  Can anyone tell me how to use the listcontains function and have it
only recognize whole numbers?  Thanks,  Oak

Is it possible in ColdFusion to extract data from an MDB file?  I have a form
that users upload these access files to but I haven't been able to find a way
to parse the data out of them.  Any help on this topic would be greatly
appreciated.

when using the cfftp tag to transfer a file to the ColdFusion Server, the file
appears to have transferred to the destination FTP server, but is zero bytes in
size. I am positive the local file exists.  Any ideas?
<cfftp connection = "myconnection"

I am planning an application that would allow multiple users to edit a
document.  When someone makes an edit, I would like that edit to appear in the
document in a color assigned to that user, so that it's possible for people to
readily see who's making what edits.  Is something ...

I have a form where it request the user to input a date.  Date input looks like
this:  11/19/2004, but when I make the update to a MYSQL DB no matter what date
type I try, (date, datetime, timestamp ) I still get the same result in the DB,
'1/1/0001'  Can anyone tell what I'm ...

Hi,  I have a field in a database which contains lots of text.  I would like to
display only a summary of this text by just displaying the first 2 lines only.
So what modifications I have to do to this:
<cfoutput>#Products.Description#</cfoutput>  in order to produce a limited ...

I've been looking for a way to dynamically populate a select box from another
select box's criteria.  For example:  Select box A has three values (A, B, C).  
Based on which value the user selects, a database query will need to be ran to
determine which value the user selected.  ...

For our reporting system we've been looking for an entry-level pdf writer
for CFMX until Blackstone comes out. So far CFXPDF is a prime candidate but
on two occassions they have failed to reply to our emails on questions about
pricing for wide-distribution or general questions about ...

I've run this code on a server running MX, and another running CF 5.0.  I'm
seeing a really strange result.  Here's the script:
<CFSCRIPT>
temp=QueryNew("x,y");

Still consider myself somewhat new with CF, so am asking for both info and
assistance. Am trying to make a connection to a data table in access that is on
a different server and not really certain how to go about this. Would need to
be able to show what is in the table from the ...

I have a report that can run as HTML, EXCEL or PDF from the same codebase.
When HTML, I insert page novigation controls and utilize the
startrow/maxrows to control output ranges. However, I'd like the PDF and
Excel reports to run unlimited.

What is the best methods you guys have found for protecting your application
from data people put in large text fields?
For example, a resume app can accept 2000 chars for a resume input...what if
they have '#' or other wierd chars in their text that yoiu need to exscape or

Hi,  In the shopping carts I have done so far, the shipping rates were all
based on the total dollar amount of the products.  See code below.    My
problem is that I have someone that wants to have the shipping rate correspond
to each product.  In other words, Product A has a $2 ...

Hello,  I have always assumed that when you put a value in Administrator for
'Timeout Requests after (seconds)', the queries would time out after said value
also.  However, this seems not to be true.  For example, I have the value set
for pages to timeout after 30 seconds, but ...

I need some help with an automatic logon application.  My boss wants the
company employees to be able to automatically login to our web-based Intranet
when they are in the office.  I was wondering if I could use the VB function,
CurrentUser(), in my CF page?  Any thoughts or ...