Re: cfselect and selected option

[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> /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:
> >
> > 
> >
> >  >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

Re: Using XML to Create schema/database

[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 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: CF Printer list?

[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
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

[Robert Harrison]

> 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: A&W 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: A&W 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: adding ip address to email body

[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 Message-
From: Alex DeMarco 
Sent: Wednesday, December 09, 2009 11:00 AM
To: cf-talk 
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: cfselect and selected option

[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 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:
>
> 
>
> 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

[Robert Harrison]

> 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: A&W 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: Using XML to Create schema/database

[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 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

adding ip address to email body

[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 

~|
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

CF Printer list?

[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?  
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

CF Printer list?

[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?  
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?

[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?  
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

RE: Sending a Fax

[Robert Harrison]

> 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: A&W 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

Re: odbc to excel or text files

[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 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: Using XML to Create schema/database

[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 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: Using XML to Create schema/database

[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
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: Sending a Fax

[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 &.

Plug in to our blog: A&W 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: A&W 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

cfselect and selected option

[Larry Lyons]

Greetings all,

A quick question, can you use the selected option in a cfselect when you're 
using a bind, as in:





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

[Eric Cobb]

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

Re: Sending a Fax

[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 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: A&W 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

[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 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: A&W 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

odbc to excel or text files

[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 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

[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 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:329011
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

[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 : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W 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

Sending a Fax

[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 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: Writing query to a csv file

[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  wrote:

>
> you will want to use cffile action="append"
>
>
> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0246.htm
>
> <
> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0246.htm
> >write
> will create the file
> append will add to it
>
> 2009/12/9 
>
> >
> > 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?
> >
> > 
> > select *
> > from Employee_main
> > 
> >
> > 
> > > 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">
> >
> >  
> >
> >
> >
> #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)#
> >
> >
> >   >
>  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">
> >
> >
> >
> >
> >
>
> 

~|
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

RE: Reading Microsoft "smart" quotes with CFFILE

[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 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

[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


##TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed
_title)#,#TRIM(ed_email)#,  And so on




You can't use html (like ) 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?

 select *
from Employee_main 


 

 


#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
)#

  






~|
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: Writing query to a csv file

[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_Documentation&file=0246.htm

write
will create the file
append will add to it

2009/12/9 

>
> 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?
>
> 
> select *
> from Employee_main
> 
>
> 
> 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">
>
>  
>
>
> #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)#
>
>
>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">
>
>
>
>
> 

~|
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

Writing query to a csv file

[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 appended. I've tried to skip the file create and 
header insertion but the
data doesn't write to the csv correctly.  

Any advice?


select *
from Employee_main



 

 


#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)#


  




~|
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: Using XML to Create schema/database

[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
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

Re: ColdFusion and Linux

[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 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