Re: ColdFusion and Linux

2009-12-09 Thread Tom Chiverton
On Friday 04 Dec 2009, Raul Riera wrote: Does anyone know the solution of this? Also, what would be the recommended chmod to use? seems like 777 is the only one that will allow me to write to the folder Don't do that. Or '666'. This allows anyone on the server to alter the file. This isn't

Re: Using XML to Create schema/database

2009-12-09 Thread Steve Bryant
Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet): http://www.bryantwebconsulting.com/docs/datamgr/synchronize-database-structure-activeschema.cfm

Writing query to a csv file

2009-12-09 Thread coldfusion . developer
I have a need to write the output from aquery to a csv file without headers. I've seen many examples where you can write the output from a query to a CSV file. However most of the examples I've seen require that the file be created first with headers and then then ourput from the query is

Re: Writing query to a csv file

2009-12-09 Thread AJ Mercer
you will want to use cffile action=append http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0246.htm

RE: Writing query to a csv file

2009-12-09 Thread Mark Kruger
Well.. The code below would uh... Create the same file over and over with only the last row... Unless I'm reading it wrong ;) What you needs is something like Cfsavecontent variable =csvcfoutput query=get_all ##TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed

RE: Reading Microsoft smart quotes with CFFILE

2009-12-09 Thread Mosh Teitelbaum
Robert: Thanks for the reply. I already have code to do exactly that. The problem, though, is that the offending characters are being converted during the CFFILE read, *before* they get placed into a variable (i.e., before I have an opportunity to replace them properly). Any ideas on getting

Re: Writing query to a csv file

2009-12-09 Thread Phillip Duba
I just did this and used one of the functions on cflib.org, one of the Query2CSV ones. I did modify it to remove extra line breaks, trim, etc. from the cell data, Phil On Wed, Dec 9, 2009 at 10:14 AM, AJ Mercer ajmer...@gmail.com wrote: you will want to use cffile action=append

Sending a Fax

2009-12-09 Thread Damo Drumm
Ive a text box on a fom and when I fill it in, and enter the Fax Number The Info is sent to the fax machine, The Text which I entered on the form appears on the 1st page of the Fax then the info follows, Im trying to move this text about half way down the page and put a brder around it, How

RE: Sending a Fax

2009-12-09 Thread Robert Harrison
I think you could output it to HTML before you send it to the fax and use the @media: print CSS to style the print format. That should work. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F :

Re: Sending a Fax

2009-12-09 Thread Rob Parkhill
How are you making the document to send the fax? What format is it in? A little code might help. Cheers, Rob On Wed, Dec 9, 2009 at 10:40 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Ive a text box on a fom and when I fill it in, and enter the Fax Number The Info is sent to the fax

odbc to excel or text files

2009-12-09 Thread Ben Conner
Hi, I've noticed there are native ODBC drivers in Windows for both Excel and text files. They seem to work, but when I get to the point of defining a SELECT statement, what is the name of the 'table'? Is there any documentation anywhere that covers this in depth? Thanks! --Ben -- Ben

Re: Sending a Fax

2009-12-09 Thread Damo Drumm
Is there a way I can just simply move it down the page slightly, at the minute its at the very top with no margins even if i could increase the margin, it would move down the page I think you could output it to HTML before you send it to the fax and use the @media: print CSS to style the print

Re: Sending a Fax

2009-12-09 Thread Damo Drumm
Is there a way I can just simply move it down the page slightly, at the minute its at the very top with no margins even if i could increase the margin, it would move down the page I think you could output it to HTML before you send it to the fax and use the @media: print CSS to style the print

Re: Sending a Fax

2009-12-09 Thread Eric Cobb
br /br /br /br /br /br /br /br /br /br /br /br /br /br / There, that should do it. ;) (sorry, I couldn't resist!) Thanks, Eric Cobb http://www.cfgears.com Damo Drumm wrote: Ive a text box on a fom and when I fill it in, and enter the Fax Number The Info is sent to the fax machine, The

cfselect and selected option

2009-12-09 Thread Larry Lyons
Greetings all, A quick question, can you use the selected option in a cfselect when you're using a bind, as in: !--- OfficeID is coming from another drop down select --- cfselect name=office id=office bind=cfc:cfcs.myCFC.getDivsionsByOffice({officeId}) size=1 value=divID

RE: Sending a Fax

2009-12-09 Thread Robert Harrison
You can't just add some whitespace in your output? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or.  It must be 

Re: Using XML to Create schema/database

2009-12-09 Thread Dave Watts
I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. This isn't exactly what you asked for, but the bundled Hibernate

Re: Using XML to Create schema/database

2009-12-09 Thread s. isaac dealey
Ahh cool. I hadn't seen that before. DataFaucet doesn't currently have any seed-data feature in the XML, so you'd have to write your own code for doing that part of it with the current version of DF. As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and

Re: odbc to excel or text files

2009-12-09 Thread Leigh
I have not used odbc in a long time. But IIRC it was the sheet name plus a $, enclosed in back tics. Not tested, but something like: SELECT * FROM `Sheet1$` ~| Want to reach the ColdFusion community with something

RE: Sending a Fax

2009-12-09 Thread Robert Harrison
blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4673 (20091209) __ The message was checked by ESET Smart Security. http://www.eset.com

CF Printer list?

2009-12-09 Thread Yuliang Ruan
We've had production server doing cfprint's for almost a year now. It works just dandy. Earlier this month, it just stopped printing completely and shows error Printer not available. Available Printers are ''. in CFIDE, the printer list is definitely blank...but how did it get that way?

CF Printer list?

2009-12-09 Thread Yuliang Ruan
We've had production server doing cfprint's for almost a year now. It works just dandy. Earlier this month, it just stopped printing completely and shows error Printer not available. Available Printers are ''. in CFIDE, the printer list is definitely blank...but how did it get that way?

CF Printer list?

2009-12-09 Thread Yuliang Ruan
We've had production server doing cfprint's for almost a year now. It works just dandy. Earlier this month, it just stopped printing completely and shows error Printer not available. Available Printers are ''. in CFIDE, the printer list is definitely blank...but how did it get that way?

adding ip address to email body

2009-12-09 Thread Alex DeMarco
Is there any way to get the cfmail tag to automatically include the submittors IP address? I realize if can be done programaticaly within the cfmail tag, but was looking for server based solution. Can the tag be hacked to include the ipaddress? This would be for CFMX 8 and 9. - Alex

Re: Using XML to Create schema/database

2009-12-09 Thread Tom Jones
Wow, the DataMgr project is very cool. I can use it right away for other parts of my application. thanks, tom Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure

RE: adding ip address to email body

2009-12-09 Thread Robert Harrison
-williams.com Great advertising can't be either/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4674 (20091209) __ The message was checked by ESET Smart Security

Re: cfselect and selected option

2009-12-09 Thread Azadi Saryev
nope, you can't. but there's a work-around: http://www.coldfusionjedi.com/index.cfm/2007/8/7/Selecting-default-items-using-ColdFusion-8s-AJAX-Controls http://cfsilence.com/blog/client/index.cfm/2007/8/7/Selecting-Multiple-Default-Items-With-ColdFusion-8-Ajax-Controls Azadi Saryev On

RE: adding ip address to email body

2009-12-09 Thread William Seiter
Alex, to make your code modular, you can create a custom function that wraps around the cfmail tag and adds all of your intended updates. Then you would call the new function instead of cfmail, directly. This will allow easy server migrations withot 'hacking' cf settings. -Original

RE: adding ip address to email body

2009-12-09 Thread Robert Harrison
/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4674 (20091209) __ The message was checked by ESET Smart Security. http://www.eset.com

Re: CF Printer list?

2009-12-09 Thread Yuliang Ruan
holy duplicate post ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329031

Re: Using XML to Create schema/database

2009-12-09 Thread Tom Jones
I do have one question on the loadXml function. I'm getting a error that says LoadXML Failed(verify datasource MySQLDS is correct). The DSN is valid, where/ how can I trouble shoot this? Thanks, tom ~| Want to reach the

Re: cfselect and selected option

2009-12-09 Thread Larry Lyons
thanks Azadi, I'll give that a try. larry nope, you can't. but there's a work-around: http://www.coldfusionjedi.com/index. c fm/2007/8/7/Selecting-default-items-using-ColdFusion-8s-AJAX-Controls http://cfsilence.com/blog/client/index. cfm/2007