Re: Create an Excel Spreadsheet

2007-03-17 Thread Robertson-Ravo, Neil (RX)
Have a look at using Apache POI, which is in CF7 already. This will create
Excel sheets using Java which is far more efficient than using HTML to mimic
a sheet.

You could also look at using DTS if you are on SQL Server to export the
results to Excel.






"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Pete
To: CF-Talk
Sent: Sun Mar 18 03:36:28 2007
Subject: Create an Excel Spreadsheet

Hi there

 

I have got a CF program which is working fine.  I'd just like to try and
improve the program.

 

Basically it has been developed to export the results of a query to an excel
spreadsheet (which it is doing).

 

I'm just wondering if there is a way so as to create the first row in the
spreadsheet which contains column names.

 

Here is the code which I have got:

 



 



 



 



SELECT  *

FROM tbl_meddelregos



 







 



 



 



 



 



 







#ID##TabChar##Title##TabChar##FirstName##TabChar##LastName##TabChar##PrefNam
e##TabChar##BusName##TabChar##Address##TabChar##Suburb##TabChar##StateID##Ta
bChar##Postcode##TabChar##CountryCode##TabChar##Phone##TabChar##Fax##TabChar
##Mobile##TabChar##Email##NewLine#





 

Thanks in advance

 

P






~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272925
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Create an Excel Spreadsheet

2007-03-17 Thread Dinner
On 3/17/07, Pete wrote:


Right before the loop, do this:

> 
>
> ID#TabChar#Title#TabChar#FirstName#TabChar#LastName#TabChar#PrefNam
> e#TabChar#BusName#TabChar#Address#TabChar#Suburb#TabChar#StateID#Ta
> bChar#Postcode#TabChar#CountryCode#TabChar#Phone#TabChar#Fax#TabChar
> #Mobile#TabChar#Email#NewLine#
>
> 

Which should work.

If you can use createObject, there's also some stuff over on google code

http://code.google.com/p/cfjexcel/

basically just a couple of cfcs that use jExcelApi for import/export of xls.

There's a very basic "row level" formula embedder in query2xls.cfc.

Not sure if the zip has the latest source, so might wanna download the
two cfcs from here:

http://cfjexcel.googlecode.com/svn/trunk/

You could loop through the column names too, somelhing tike:



  


Then whack off the last tabChar, add a newLine, and viola!
One more loop using the query values, something like


   

   


Again, whack off the last tabChar, and that would
do it (assuming tabChar would work as a list delim).

Someone had a nifty solution to the whole "how do I get rid of the
last list thingie", but I don't remember it off hand.  :-/

Have Fun!

> 
>
> 
>
>
#ID##TabChar##Title##TabChar##FirstName##TabChar##LastName##TabChar##PrefNam
>
e##TabChar##BusName##TabChar##Address##TabChar##Suburb##TabChar##StateID##Ta
>
bChar##Postcode##TabChar##CountryCode##TabChar##Phone##TabChar##Fax##TabChar
> ##Mobile##TabChar##Email##NewLine#
>
> 
>
> 
>
>
>
> Thanks in advance


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272924
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Object Instantiation Error

2007-03-17 Thread Janet MacKay
There shouldn't be a (space) in between the double quote and the start of the 
class name. Remove the space and it should work.


exifReader = createObject("java", 
"(space)com.drew.imaging.coldfusion.CFreadExif");



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272923
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Create an Excel Spreadsheet

2007-03-17 Thread Pete
Hi there

 

I have got a CF program which is working fine.  I'd just like to try and
improve the program.

 

Basically it has been developed to export the results of a query to an excel
spreadsheet (which it is doing).

 

I'm just wondering if there is a way so as to create the first row in the
spreadsheet which contains column names.

 

Here is the code which I have got:

 



 



 



 



SELECT  *

FROM tbl_meddelregos



 







 



 



 



 



 



 







#ID##TabChar##Title##TabChar##FirstName##TabChar##LastName##TabChar##PrefNam
e##TabChar##BusName##TabChar##Address##TabChar##Suburb##TabChar##StateID##Ta
bChar##Postcode##TabChar##CountryCode##TabChar##Phone##TabChar##Fax##TabChar
##Mobile##TabChar##Email##NewLine#





 

Thanks in advance

 

P




~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272922
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


downloading large files via cfhttp

2007-03-17 Thread Dov Katz
If I need to cfschedule a 10-40 mb download, is cfhttp going to buffer the 
entire input to memory if I specify a file to write it to? Also concerned about 
losing an available thread. I'm trying to basically do a "wget" in coldfusion 
and don't want to lose an available thread while I do it.

Here's my planned.  Is something like this available somewhere?  What do you 
think?

Cfx_wget url= destinationFile=. Callbackurl=localhost/callback.cfm

Calling this gets a uuid 


Then I write a java class to kick off a thread (thread name is the uuid the cfx 
returned) to write a url input stream to the specified file and then hit the 
"callback" url when done, with all the params of the tag call and the http 
status code of the get operation.  

I can also ask this thread what its status is and/or cancel it by looking for 
the thread by its uuid name. 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272921
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can I do this without evaluate?

2007-03-17 Thread James Holmes
Try the cfinvoke tag?

On 3/17/07, Paul Vernon <[EMAIL PROTECTED]> wrote:
> I'm working on an event listener for our application framework and I've got
> a piece of code that I'd rather have work another way if possible.
>
> The code is:
>
>  evaluate("#registeredEventHandlers[counter]#(argumentCollection=arguments.ev
> entArguments)")>
>
> currentEventHandlers[counter] evaulates to a cfc name eg
> "application.blogcfc" at this point in time it is a string and not a pointer
> to an object in memory...
>
> Right now, because the string could be pretty much anything, I can't see any
> other way of doing this to force CF to run an arbitrary function with
> arbitrary arguments when I fire off an event in the framework.
>
> Any ideas would be appreciated!
>
> Paul
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272920
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Verity help with @ symbol

2007-03-17 Thread Dinner
Yup, simple was the kind of search I was thinking of.

Escaping it should've done it...  ( \@ )

Sorry, I hardly ever use verity  :-/

I'd think that someone would have noticed if it was a bug
by now...  are you sure of the content you're searching for?

No way there could be some hidden char or some such,
so it's like testEmail@s^hsomeDomain
or whatever?

On 3/16/07, Matt W

> If I search on "[EMAIL PROTECTED]", I get no results. But searching
> on just "testEmail" gets results, showing the email in there. I've
> tried it with the @ symbol escaped (using @@, \@, [EMAIL PROTECTED]).
>
> Any insight, or possibly someone being able to replicate would be much
> appreciated.
>
> Thanks,
> Matt

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272919
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can I do this without evaluate?

2007-03-17 Thread Mark Mandel
Paul -

Why are listeners being registered by a string? Why not just pass trough the
objects reference?

If you have an object reference, you can do a dynamic method invocation
through cfinvoke, and you wouldn't have an issue.

Regards,

Mark

On 3/18/07, Paul Vernon <[EMAIL PROTECTED]> wrote:
>
> I'm working on an event listener for our application framework and I've
> got
> a piece of code that I'd rather have work another way if possible.
>
> The code is:
>
>  evaluate("#registeredEventHandlers[counter]#(argumentCollection=
> arguments.ev
> entArguments)")>
>
> currentEventHandlers[counter] evaulates to a cfc name eg
> "application.blogcfc" at this point in time it is a string and not a
> pointer
> to an object in memory...
>
> Right now, because the string could be pretty much anything, I can't see
> any
> other way of doing this to force CF to run an arbitrary function with
> arbitrary arguments when I fire off an event in the framework.
>
> Any ideas would be appreciated!
>
> Paul
>
>
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272918
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Visual Foxpro Drivers?

2007-03-17 Thread Dinner
+1

I have an old version from when it was free.  Use it for old dbase clipper
sync stuff.  Works like a charm.

On 3/16/07, Christopher J wrote:
> Greg,
>
> I'm running CF with FoxPro (unfortunately FoxPro 1.0 tables), and I was
> searching for Type 4 JDBC drivers about a year or so ago. You're in
> luck. I've found *one* single place that writes a type 4JDBC driver.
>
> http://www.hxtt.com (look at the DBFv3.1 link on the top left of the
> homepage)


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272917
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Dave Watts
> Hmm... looks like it's $129 per user, so not really open 
> source.  Does it have svn integration?

It's not open-source at all. That has nothing directly to do with price,
however. Some commercial products are open-source, and some freeware is
closed-source. FogBugz does integrate nicely with SVN.

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!

This email has been processed by SmoothZap - www.smoothwall.net


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272916
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfhttp/xml help

2007-03-17 Thread Randy Johnson
Hi Bob,

I had this happen with a couple rss feeds.   I tried trimming the feed in 
case of any white space. That did not help it so I finally gave up.  The 
weird thing is, the feeds worked fine if I put them in the RSS Reader.   I 
currently use GreatNews for My RSS reader.

I did some testing with online rss validators on the url in your example, it 
was to big for the online validators to check but It did pass the xml 
validator test (Well Formed), so I assume it is a valid rss feed too.

Not really much help I know :-)

-Randy



- Original Message -
From: "Bob Imperial" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Saturday, March 17, 2007 4:13 PM
Subject: cfhttp/xml help

> Hi Folks,
>
> I'm just getting started with learning the basics on pulling xml feeds 
> with
> cfhttp and am in need of some help with an error I get with some feeds I'm
> playing with. Here's the code block I'm working with and I get the 
> following
> error on this feed and a couple of others...
>
> Content is not allowed in prolog.
>
> The error occurred in C:\Inetpub\wwwroot\testing\rss.cfm: line 10
>
>
> 8 : 
>
> 9 : http://www.nranews.com/rss/rss.xml"; method="GET"
> resolveurl="No" >
>
> 10 :  this
>
> http://www.nranews.com/rss/rss.xml"; method="GET"
> resolveurl="No" >
> 
>
> 
> 
> 
> 
>
> Title: #MyXML.rss.channel.item[x].title.xmlText#   href="#MyXML.rss.channel.item[x].link.xmlText#">click here
> #MyXML.rss.channel.item[x].description.xmlText#
>
> 
> 
>
> While this same block of code works fine using the feed from
> http://www.tfc.edu/radio/podcasting/music.xml
>
> I'm confused here, any help in understanding this is appreciated!
>
> Bob
>
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272915
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Jim Wright
Andrew Peterson wrote:
> Can someone recommend a good help desk/trouble ticket system? The ideal 
> application would be cf based and open source. Thanks.
> 

While not CF based, I know quite a few people who swear by RT...
http://bestpractical.com/rt

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272914
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Can I do this without evaluate?

2007-03-17 Thread Paul Vernon
I'm working on an event listener for our application framework and I've got
a piece of code that I'd rather have work another way if possible.

The code is:



currentEventHandlers[counter] evaulates to a cfc name eg
"application.blogcfc" at this point in time it is a string and not a pointer
to an object in memory...

Right now, because the string could be pretty much anything, I can't see any
other way of doing this to force CF to run an arbitrary function with
arbitrary arguments when I fire off an event in the framework.

Any ideas would be appreciated!

Paul



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272913
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfhttp/xml help

2007-03-17 Thread Bob Imperial
Hi Folks,
 
I'm just getting started with learning the basics on pulling xml feeds with
cfhttp and am in need of some help with an error I get with some feeds I'm
playing with. Here's the code block I'm working with and I get the following
error on this feed and a couple of others...
 
 Content is not allowed in prolog.  
 
The error occurred in C:\Inetpub\wwwroot\testing\rss.cfm: line 10


8 : 

9 : http://www.nranews.com/rss/rss.xml"; method="GET"
resolveurl="No" >

10 : http://www.nranews.com/rss/rss.xml"; method="GET"
resolveurl="No" >

 





Title: #MyXML.rss.channel.item[x].title.xmlText#  click here
#MyXML.rss.channel.item[x].description.xmlText#



 
While this same block of code works fine using the feed from
http://www.tfc.edu/radio/podcasting/music.xml 
 
I'm confused here, any help in understanding this is appreciated!
 
Bob


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272912
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Robertson-Ravo, Neil (RX)
SVN integration :-)



"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Raymond Camden
To: CF-Talk
Sent: Sat Mar 17 13:56:00 2007
Subject: Re: Help Desk / Trouble Ticket recommendation?

LighthousePro is it (lighthousepro.riaforge.org). I just added support
for being able to create issues via email. Outside of that - I'm
always looking for more ideas for it.

On 3/17/07, Andrew Peterson <[EMAIL PROTECTED]> wrote:
> >Why would it have to be ColdFusion based? Do you want to extend it etc?
Ray
> >Camden has one, I can't remember the name though... Lighthouse I think.
>
> Yeah, Ray's Lighthouse Pro is great, but when I looked at it last (>1 year
ago) it didn't have what we needed unless I missed it. We need to track
email back and forth from customers, and I need to be able to protect the
identity of some of those responding.  I work in the part of the government
that sometimes has to deal with check withholdings, child support, etc. And
sometimes people wanna make it personal :-(. Right now our solution is to
have the webmaster (i.e. ME) forward the message on  on their behalf, so
*my* info is exposed! What is up with that? :-) Uh, don't blame the
messenger? And so I want it cf based and open source so I can learn from the
code and possibly modify it.
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272911
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Application.cfc and Client Variables

2007-03-17 Thread Randy Johnson
Hello,

Here is the code I have at the top of my Application.cfc file:






In my Queue.cfc file I am getting this error when trying to use a client 
variable:
The requested CLIENT scope is not enabled.
The Application.cfc file and the Queue.cfc file are in the same directory.

In my ViewVariables.cfm page I can do a   and it will show client variables
I am not sure what is going on here, It looks pretty straight forward.  Any 
ideas?
Thanks!

Randy 


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272910
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Coldfusion / Open Source CRM

2007-03-17 Thread Jake Pilgrim
Does anyone know of a coldfusion CRM out there? Ideally I would like a open 
source, Coldfusion CRM. It doesn't have to be all that fancy (I'm not looking 
for a SalesForce replacement) - even if it was just a contacts database it 
would be better than what I have now :). 

Thanks for your feedback in advance!

Jake

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272909
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Cedric Villat
Andrew,


We make CFTicket, which is written in ColdFusion and is open source (not free, 
but affordable). You can see it at www.cornfeed.com. It sounds like it does 
what you want, but you can check it out as there is an online demo you can play 
with.


Cedric

> >Why would it have to be ColdFusion based? Do you want to extend it 
> etc? Ray
> >Camden has one, I can't remember the name though... Lighthouse I 
> think.
> 
> Yeah, Ray's Lighthouse Pro is great, but when I looked at it last (>1 
> year ago) it didn't have what we needed unless I missed it. We need to 
> track email back and forth from customers, and I need to be able to 
> protect the identity of some of those responding.  I work in the part 
> of the government that sometimes has to deal with check withholdings, 
> child support, etc. And sometimes people wanna make it personal :-(. 
> Right now our solution is to have the webmaster (i.e. ME) forward the 
> message on  on their behalf, so *my* info is exposed! What is up with 
> that? :-) Uh, don't blame the messenger? And so I want it cf based and 
> open source so I can learn from the code and possibly modify it.

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272908
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFGrid data not showing

2007-03-17 Thread Les Schmidt
> >> Technically you don't you have to.  If you specify just the query 
> attribute
> >> in the cfgrid tag, and no cfgridcolumns it defaults to creating a 
> column for
> >> column in the result set of the query.
> >
> >Hmm, didn't know that.  Still stabbing in the dark...maybe you need 
> to
> >select real columns in your query, instead of 'select * from'?  If
> >that still doesn't work, you should look in your CF logs to see if 
> you
> >find any errors.  I can't remember which log, but I've found flash
> >form errors in one log one day, and then in another one another day.
> >
> >Kind of off topic, there are a lot of really cool examples and
> >articles on flash forms at this site:
> >http://www.asfusion.com/
> >
> >-- 
> >My Sites:
> 
> 
> Finally figured it out the help of our admin. The problem was the 
> mapping to CFIDE folder.  The mapping was wrong and therefore could 
> not find all of the proper files.  Hence not working correctly but 
> also not creating an error. 
Michael,
I've been experiencing the exact same problem that you encountered: cfquery 
produces data, but the flash grid produced by cfform contains no data.  I 
checked the mapping of the CFIDE in the CF administrator and indeed it is 
pointing to the CFusionMX7\wwwroot\CFIDE directory whereas I need it to report 
to the ...Apache2\htdocs\CFIDE directory.  
How does one change the mapping in CFAdministrator?  Can't seem to find a way 
to do that.  Any help at all greatly appreciated.

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272907
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Raymond Camden
LighthousePro is it (lighthousepro.riaforge.org). I just added support
for being able to create issues via email. Outside of that - I'm
always looking for more ideas for it.

On 3/17/07, Andrew Peterson <[EMAIL PROTECTED]> wrote:
> >Why would it have to be ColdFusion based? Do you want to extend it etc? Ray
> >Camden has one, I can't remember the name though... Lighthouse I think.
>
> Yeah, Ray's Lighthouse Pro is great, but when I looked at it last (>1 year 
> ago) it didn't have what we needed unless I missed it. We need to track email 
> back and forth from customers, and I need to be able to protect the identity 
> of some of those responding.  I work in the part of the government that 
> sometimes has to deal with check withholdings, child support, etc. And 
> sometimes people wanna make it personal :-(. Right now our solution is to 
> have the webmaster (i.e. ME) forward the message on  on their behalf, so *my* 
> info is exposed! What is up with that? :-) Uh, don't blame the messenger? And 
> so I want it cf based and open source so I can learn from the code and 
> possibly modify it.
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272906
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Andrew Peterson
>Why would it have to be ColdFusion based? Do you want to extend it etc? Ray
>Camden has one, I can't remember the name though... Lighthouse I think.

Yeah, Ray's Lighthouse Pro is great, but when I looked at it last (>1 year ago) 
it didn't have what we needed unless I missed it. We need to track email back 
and forth from customers, and I need to be able to protect the identity of some 
of those responding.  I work in the part of the government that sometimes has 
to deal with check withholdings, child support, etc. And sometimes people wanna 
make it personal :-(. Right now our solution is to have the webmaster (i.e. ME) 
forward the message on  on their behalf, so *my* info is exposed! What is up 
with that? :-) Uh, don't blame the messenger? And so I want it cf based and 
open source so I can learn from the code and possibly modify it.

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272905
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4