Re: ColdFusion and Linux
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 what you want (almost certainly). Change the owner (or group) of the folder to match what the ColdFusion service is running as e.g. 'chown nobody /path/to/folder'. -- Helping to augmentatively cultivate network eye-catching attention-grabbing deliverables as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| 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:329002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
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 http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm Thanks, Steve Hello, 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. Thanks, tom ~| 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:329003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Writing query to a csv file
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 appended. I've tried to skip the file create and header insertion but the data doesn't write to the csv correctly. Any advice? cfquery name=get_all datasource=#datasource# maxrows=55 select * from Employee_main /cfquery !--- Create the file with column header's. It is crucial that you have all the outputed text on one line with no spaces between the comma and the next column header.--- cffile action=write file=D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv output=ed_first_name, ed_last_name, ed_fi_last_name, ed_title, ed_email, ed_reports_to, ed_department, ed_division, ed_location, ed_phone_number, ed_extension, ed_submitted, ed_state, ed_country, ed_zip_code addnewline=yes !--- Output the contents of the export_contacts query --- cfoutput cfloop query=get_all #TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# BR / !--- Append (Insert) the contents of the query into the already created CSV file. Make sure that you keep all the output on one line exactly like the column header--- cffile action=WRITE file=D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv output=#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# addnewline=yes /cfloop /cfoutput ~| 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:329004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Writing query to a csv file
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 http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0246.htmwrite will create the file append will add to it 2009/12/9 coldfusion.develo...@att.net 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 appended. I've tried to skip the file create and header insertion but the data doesn't write to the csv correctly. Any advice? cfquery name=get_all datasource=#datasource# maxrows=55 select * from Employee_main /cfquery !--- Create the file with column header's. It is crucial that you have all the outputed text on one line with no spaces between the comma and the next column header.--- cffile action=write file=D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv output=ed_first_name, ed_last_name, ed_fi_last_name, ed_title, ed_email, ed_reports_to, ed_department, ed_division, ed_location, ed_phone_number, ed_extension, ed_submitted, ed_state, ed_country, ed_zip_code addnewline=yes !--- Output the contents of the export_contacts query --- cfoutput cfloop query=get_all #TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# BR / !--- Append (Insert) the contents of the query into the already created CSV file. Make sure that you keep all the output on one line exactly like the column header--- cffile action=WRITE file=D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv output=#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# addnewline=yes /cfloop /cfoutput ~| 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:329005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Writing query to a csv file
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 _title)#,#TRIM(ed_email)#, And so on /cfsavecontent Cffile write=c:\blah.csv output=#trim(csv)#/ You can't use html (like br) in a csv.. Instead you use actual line breaks (chr(10) or chr(10)chr(13) for windows). But the code above will add those because they are created when you code and hit enter :) Good luck. You will get this - it's not too tough. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: coldfusion.develo...@att.net [mailto:coldfusion.develo...@att.net] Sent: Wednesday, December 09, 2009 8:34 AM To: cf-talk Subject: Writing query to a csv file 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 appended. I've tried to skip the file create and header insertion but the data doesn't write to the csv correctly. Any advice? cfquery name=get_all datasource=#datasource# maxrows=55 select * from Employee_main /cfquery !--- Create the file with column header's. It is crucial that you have all the outputed text on one line with no spaces between the comma and the next column header.--- cffile action=write file=D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv output=ed_first_name, ed_last_name, ed_fi_last_name, ed_title, ed_email, ed_reports_to, ed_department, ed_division, ed_location, ed_phone_number, ed_extension, ed_submitted, ed_state, ed_country, ed_zip_code addnewline=yes !--- Output the contents of the export_contacts query --- cfoutput cfloop query=get_all #TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_ title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(e d_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension) #,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code )# BR / !--- Append (Insert) the contents of the query into the already created CSV file. Make sure that you keep all the output on one line exactly like the column header--- cffile action=WRITE file=D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv output=#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,# TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)# ,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_ex tension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(e d_country)#,#TRIM(ed_zip_code)# addnewline=yes /cfloop /cfoutput ~| 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:329006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading Microsoft smart quotes with CFFILE
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 CFFILE to read them properly? Thanks. -- Mosh Teitelbaum evoch, LLC http://www.evoch.com/ Robert Harrison wrote: Replace them in a var before trying to do anything with them: #ReplaceList(trim(YOURCONTENT), ',.,, ,'',...,, )# Mosh Teitelbaum wrote: I'm trying to read content from an XML file stored on disk ~| 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:329007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Writing query to a csv file
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 http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0246.htm http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0246.htm write will create the file append will add to it 2009/12/9 coldfusion.develo...@att.net 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 appended. I've tried to skip the file create and header insertion but the data doesn't write to the csv correctly. Any advice? cfquery name=get_all datasource=#datasource# maxrows=55 select * from Employee_main /cfquery !--- Create the file with column header's. It is crucial that you have all the outputed text on one line with no spaces between the comma and the next column header.--- cffile action=write file=D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv output=ed_first_name, ed_last_name, ed_fi_last_name, ed_title, ed_email, ed_reports_to, ed_department, ed_division, ed_location, ed_phone_number, ed_extension, ed_submitted, ed_state, ed_country, ed_zip_code addnewline=yes !--- Output the contents of the export_contacts query --- cfoutput cfloop query=get_all #TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# BR / !--- Append (Insert) the contents of the query into the already created CSV file. Make sure that you keep all the output on one line exactly like the column header--- cffile action=WRITE file=D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv output=#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code)# addnewline=yes /cfloop /cfoutput ~| 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:329008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sending a Fax
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 do I do this using coldfusion? Thanks ~| 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:329009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending a Fax
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 : 631.434.7022 http://www.austin-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 -Original Message- From: Damo Drumm [mailto:damien.dr...@quinn-group.com] Sent: Wednesday, December 09, 2009 10:40 AM To: cf-talk Subject: Sending a Fax 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 do I do this using coldfusion? Thanks ~| 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:329010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
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 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 do I do this using coldfusion? Thanks ~| 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:329011 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
odbc to excel or text files
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 Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| 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:329012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
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 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 : 631.434.7022 http://www.austin-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 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 do I do this using coldfusion? Thanks ~| 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:329014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
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 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 : 631.434.7022 http://www.austin-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 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 do I do this using coldfusion? Thanks ~| 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:329013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
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 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 do I do this using coldfusion? Thanks ~| 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:329015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfselect and selected option
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 display=division_abbrev selected=#someOtherQuery.divID# / many thanks, larry ~| 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:329017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending a Fax
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 . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Damo Drumm [mailto:damien.dr...@quinn-group.com] Sent: Wednesday, December 09, 2009 11:53 AM To: cf-talk Subject: Re: Sending a Fax 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 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 : 631.434.7022 http://www.austin-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 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 do I do this using coldfusion? Thanks ~| 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:329016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
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 functionality in CF 9 will create database tables on the fly based on value object CFCs you've defined. And it's just as easy, I think, to write those as to write XML data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:329020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
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 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 http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:329019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: odbc to excel or text files
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 they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sending a Fax
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 Sine there's no code samples I can really tell what you are doing, but in print world the output is likely SGML. You should be able to output some line breaks or page feeds to the printer controls prior to the text string - in CF - that's #chr(10)# and #chr(13)#. Geez - tried to include some links but Adobe CF docs is all coming up broken links right now. When they come back look up carriage return and line feed. Should be straight forward. 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 . Plug in to our 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 ~| 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:329018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Printer list?
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? and how does that list get populated? CF is running Solaris environment, so most Windows related advice doesn't apply. please help ~| 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:329022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Printer list?
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? and how does that list get populated? CF is running Solaris environment, so most Windows related advice doesn't apply. please help ~| 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:329023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Printer list?
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? and how does that list get populated? CF is running Solaris environment, so most Windows related advice doesn't apply. please help ~| 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:329024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
adding ip address to email body
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 ~| 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:329025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
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 about DataFaucet): http://www.bryantwebconsulting. com/docs/datamgr/synchronize-database-structure-activeschema.cfm http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm Thanks, Steve Hello, 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. Thanks, tom ~| 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:329026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: adding ip address to email body
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? In which cfmail parameter would you want to include the users IP address, or do you want to include a variable in the mail body that has the submitters IP? 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 . 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 ~| 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:329027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfselect and selected option
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 10/12/2009 01:11, Larry Lyons wrote: 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 display=division_abbrev selected=#someOtherQuery.divID# / many thanks, larry ~| 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:329028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: adding ip address to email body
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 Message- From: Alex DeMarco alex.dema...@suny.edu Sent: Wednesday, December 09, 2009 11:00 AM To: cf-talk cf-talk@houseoffusion.com Subject: adding ip address to email body 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 ~| 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:329029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: adding ip address to email body
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? Oh, - if you do want to include a variable in the mail body. The var is #CGI.REMOTE_ADDR#. 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 . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Wednesday, December 09, 2009 3:24 PM To: cf-talk Subject: RE: adding ip address to email body 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? In which cfmail parameter would you want to include the users IP address, or do you want to include a variable in the mail body that has the submitters IP? 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 . 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 ~| 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:329030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Printer list?
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 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using XML to Create schema/database
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 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:329032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfselect and selected option
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 /8/7/Selecting-Multiple-Default-Items-With-ColdFusion-8-Ajax-Controls Azadi Saryev On 10/12/2009 01:11, Larry Lyons wrote: 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 display=division_abbrev selected=#someOtherQuery.divID# / many thanks, larry ~| 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:329033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4