RE: Dynamic connection for dbase in CFMX7

hi, I'm having problem connecting to a Dbase file. I followed the instructions at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18656 where i created a datasource that points to a empty Access db. Tested it with the following code with MS-Access and it works. cfquery

Using CF to list out a Dbase table structure

Hi, I wonder if it's possible for CF to return a list of column names that users uploaded a Dbase file to the server. Perhaps this is more of a SQL problem rather than CF. However i can't seem to find any syntax doing this. Regards Nyon

Re: Using built-in zip Windows 2003/XP

Hi, I need to unzip and zip some files that is submitted by users. Got Winzip command line working using CF. However, i was wondering if i can utilitize the zip functions built-into Windows ZP/ Server 2003. That would save some licensing costs. Thank you. Nyon

RE: Cfhttp, Cfschedule stop working in CF4.5

Hi, For some reason, my CFschedule and CFhttp stop working in CF4.5 (Windows 2000Advanced Server). Other than asking me to re-install or upgrade, is there any solutions. Tried to reduce the log sizes by deleting some entries but problem still persists. Nyon

Consuming RSS in CF 4.5

Hi, Can't seem to find an example on consuming a RSS feed in CF 4.5. A lot of the examples are for CF MX which uses XMLParse function. Anyone with some code snippet...? Nyon ~| Discover CFTicket - The leading ColdFusion Help

Nested CFLoop problem

I can't seem to make the 1st loop to move to the next record. Am I missing something? Below is the code snippet. cfloop query=GetExample startrow=1endrow=#GetExample.recordcount# cfloop query=translation_liststartrow=1 endrow=#translation_list.recordcount# cfif GetExample.kod_gt eq

RE: Need to delay script execution

My application lets users to upload a zip file into the server. Once done, i will use cfexecute to run a command line to unzip the uploaded file (dbase) into a sub-directory. However, I need to delay the 2nd part of the script so that the unzipping process can be done as I need to read the dbase

RE: Adding a dbase column via CF/ODBC

Hi, I'm having problem to use ALTER TABLE on a dbase file using DSN-less connection. It' an online conversion application where users submit their dbase files and the app will add some columns before posting it back to the user via email. The code only works if there is no data in the table. My

RE: Is Cold Fusion 4.5 able to do this?

I need to do the following 1. a user uploads a *.dbf (dbase) file. 2. a new column is added to the dbase file 3. insert values into a new column based on a pre-defined column 4. send the file back to the users via email. I know how to do most of the task listed above. I'm not sure about 1. how to

RE: Filter file type upload

I want to set a file filter and file size upload contraint. got the file size working. CFIF VAL(CGI.CONTENT_LENGTH) GT 200 span class=textfont face=verdana, arial size=2 color=black Upload file size exceeds the 2MB limit.br a href=Javascript:history.go(-1)Try again/a?/span/font

RE: Keep track of number of downloads

I'm want to keep track of the number of downloads for a particular zip files. For example, A123.zip (downloaded 130 times) A123b.zip (downloaded 240 times) how do i do that in CF? Nyon --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com).

Verity problem

I have Verity do a collection on my cfm documents. Works well except that it also return my sql statements embedded between the CFQuery tags. For example, a keyword search using Select from would return SideBar select * from sidebar where id = '1' select * from sidebar where id = '10' select *

Verity problem

I have Verity do a collection on my cfm documents. Works well except that it also return my sql statements embedded between the CFQuery tags. For example, a keyword search using Select from would return SideBar select * from sidebar where id = '1' select * from sidebar where id = '10' select *

CF-Postgresql experiences

I'm wondering if anyone mind sharing their experiences in connecting CF and Postgresql(cygwin) on Windows platform. Stability, speed and connectivity issues are the focus. TIA Nyon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Generating GPX (some kind of XML) in CF.

I kinda of new to the XML things. I need to publish some files based on this XML schema www.topografix.com/gpx Generating the code is no problem but how to use push it as some_filename.gpx instead of *.cfm I know it got something to do with CFheader and CFContent. Got it running to generate

RE: Office Server Extensions

I am generating Excel files using CF. works in the development server as it got Excel installed. I need to get office server extensions to install in the my production server. How do i hold of it? Regards Nyon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Limit file size for uploads

How do I limit a file size that is being upload to my server. If it was a 1MB limit, can I stop the process when it goes beyond the limit or must i wait till the process is done and delete it off using the CFFile tag. TIA Nyon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: Monitoring web services application

on them manually everyday. The uptime will also be logged into a database to let the clients to check the uptime. right now, i don't have much ideas on writing the scripts. My idea is to 'hit' the urls every hour using the scheduler functions in CF. Be grateful for any pointers. YC Nyon FAQ

RE: CF Application for monitoring webpages/services

everyday. right now, i don't have much ideas on writing the scripts. My idea is to 'hit' the urls every hour using the scheduler functions in CF. Be grateful for any pointers. YC Nyon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com

RE: Error in url redirect either in CF or IIS

i am using CF4.5 and trying to make the error/missing template redirection work in Administrator console. so far it hasn't work. Question is whether i should specify a url address or a local file path (c:\web\error.cfm). Also should i specify in IIS custom 404 document to redirect the error

Html to PDF, Excel, Word formats

Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

kill session aka Logout page

hi, anyone mind to share the code to do a logout page where the session is terminated. thanks Nyon __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

Connecting to Sybase database on Sun

Hi, I need to extract data from a Sybase database residing in a Sun server to a CF application on Windows. Not sure how to do this especially on the Sun side? Nyon __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40

Connecting to Sybase database on Sun

Hi, I need to extract data from a Sybase database residing in a Sun server to a CF application on Windows. Not sure how to do this especially on the Sun side? Nyon __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB