Re: CRUD Generator

2005-11-09 Thread John C. Bland II
lol. Great reply. :-)

Thx Barney!

On 11/9/05, Barney Boisvert [EMAIL PROTECTED] wrote:

 Based on my experience building custom, app-specific generators, what
 I've liked, disliked, and considered...

 A generator should be able to be rerun at arbitrary times and update
 the CRUD part without affecting anything else. It should create beans
 that have getters/setters for properties. It should allow custom
 mappings between table names and entity names (i.e. I can say a table
 called 'mytable' maps to an entity called 'TableDeMoi').

 There should be some automated translation for underscore_separated
 names to camelCase names, both for entities and fields. Surrogate
 primary keys should always be translated to 'id' properties on
 entities (i.e. person.person_id maps to Person.getId()). Both of
 these should be optional/customizable if you're distributing.

 Methods should be smart enough to only do something when needed. So
 if I load an entity and then immediately call save(), nothing should
 happen, since the entity's properties haven't been changed. There
 should be a 'save' method, which will intelligently insert or update,
 ideally only the modified fields on updates.

 Beans should have a constructor that accepts full instance data as
 args. Beans should automatically have basic validation coded by the
 generator. I.e. INT fields can automatically check for integer-ness,
 varchar fields can be checked for length restrictions, etc. That
 should be easily extensible by the app developer, of course, without
 affecting the ability to regenerate if the DB schema changes.

 Beans should have getMemento and setMemento methods that allow for
 serializing the object state. According to the DP, the memento should
 be opaque (usually an inner class), but CF doesn't afford that very
 easily, so non-opaque is fine with me. Whatever that memento is, it
 should be trivially serialized/deserialized, or some other means of
 serializing/deserializing should be exposed.

 Some entity relationship support would be ideal, based on DB foreign
 keys. I.e. if the 'car' table has an 'ownerId' field that references
 person.id http://person.id, there should be getOwner:Person and
 setOwner(Person):void
 methods, and probably getOwnerId:int and setOwnerId(int):void methods
 as well. Ideally the Person object would have getCarList, addCar, and
 removeCar methods as well, but that's harder to autogenerate, unless
 you're doing the whole schema at once, rather than a single
 entity/table.

 And then the holy grail: many-to-many relationship support. I'd be
 happy with forcing the 'link' table to be it's own implicit entity, as
 long as the two 'real' entities are smart enough to have direct access
 to the other 'real' entity. I.e. the link table entity is an exposed
 implementation detail. For example, people own cars, cars are owned
 by people. Person, Car, and CarOwnership entities with
 Person.getCarList, Car.getOwnerList, and CarOwnership.getPerson
 methods, along with their supporting methods.

 Updates to relationships need to be clearly documented, as does the
 effect of calling save on an entity with modified related objects.
 Propogation is good, but should be disable-able at some level or
 another.

 I'd hope to see factory/managers for the beans so they're easy to use.
 Aside from getPersonById, and getNewPerson, also have
 createPerson(name, dob, ...), deletePerson(id), and updatePerson(id,
 name, dob...) for calling from your UI(s). This would also be the
 place for doing caching and lazy loading in an encapsulated way. If
 you cache, hooks should be exposed that can be used for syncing across
 a cluster (the sync stuff would be built by the app developer and
 utilize the hooks).

 Some recognition of concurrency issues should be made, even if it's
 just to explicitly say you're on your own. Smart updates (i.e. only
 updating modified fields) goes a long way to mitigating this issue,
 but doesn't address it completely. For example UPDATE table SET f = f
 + 1 WHERE id = 3; is atomic, but t=getTById(3);t.setF(t.getF() +
 1);t.save(); is not atomic. Concurrency issues don't exist with the
 former, but do with the latter, unless the whole thing is in a
 transaction. That's a restriction this type of code can't enforce,
 but a well designed application will likely exhibit that behaviour so
 if clearly documented, I'd say it's reasonable to assume.

 Of course, there are sound arguments against this sort of thing at
 all. It's a delecate balance between using a tool to help you do your
 job, and relying on a tool because you can't really do your job. I'm
 all for using them until you've got a sound reason not to, though.

 cheers,
 barneyb

 On 11/8/05, John C. Bland II [EMAIL PROTECTED] wrote:
  What is it everyone looks for in a CRUD generator? I see some folks
 saying
  they'd like to see best practices, some want getters/setters, and others
  just want a function you pass everything too.
 
  Just a little reserach...
 

RE: Having a mulit-instance service run under a specific service.

2005-11-09 Thread Andrew Stevens
You can definitely run the services using any user.

I'd check the user has 'full access' to all files and folders from
X:\JRun4\Servername\ and down. That's overkill on the permissions but you
get the drift.

Also have a look in the log files, or start the server instance in console
mode to see what's happening. (Create a .bat with 'jrun -start servername'
etc. Then 'Run As...' on the .bat with your desired user name.)

Cheers.

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 2:00 PM
To: CF-Talk
Subject: RE: Having a mulit-instance service run under a specific service.

I can only say that I was able to run multiple instances, of the CF
Developer version, with a Windows domain account.  I didn't have any
problems with restarting the service.

Are there any log entries that show the actual cause?

Does your account have the logon as a service permission?

If you make your account an administrator of your server, does it work?

If you set it back to system, does it work again?

M!ke

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 08, 2005 5:30 PM
To: CF-Talk
Subject: Having a mulit-instance service run under a specific service.

Is there something different to having a multi-instance service run
under a specific user besides local?

I've tried setting this to a different user and I get an error that the
service can not be restarted, it is not responding.  

This is windows 2000 server and CFMX7.01 running in multi-instance
configuration.  I only want one instance to use a specific user at this
time.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any attachments is for
the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender and
delete any copies of this message. 







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223654
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CRUD Generator

2005-11-09 Thread John C. Bland II
lol. Great reply. :-)

--
John C. Bland II
I do what I can do when I can do it. - Chris Tucker, Money Talks

http://www.gotoandstop.org - Home of FMUG.az


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223655
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


capture rendered HTML to an image

2005-11-09 Thread Nando
Hi all,
 I'm looking for an approach that's not too complex to implement to capture
rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for
templates in an automated fashion.
 Using cfdocument and outputting to a jpeg would be perfect, but cfdocument
only outputs to PDF and FlashPaper :-(
 Any suggestions would be welcome!
 thanks
Nando


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223656
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CRUD Generator

2005-11-09 Thread Nando
Barney,
 Sounds like it's almost ready!

 On 11/9/05, Barney Boisvert [EMAIL PROTECTED] wrote:

 Based on my experience building custom, app-specific generators, what
 I've liked, disliked, and considered...

 A generator should be able to be rerun at arbitrary times and update
 the CRUD part without affecting anything else. It should create beans
 that have getters/setters for properties. It should allow custom
 mappings between table names and entity names (i.e. I can say a table
 called 'mytable' maps to an entity called 'TableDeMoi').

 There should be some automated translation for underscore_separated
 names to camelCase names, both for entities and fields. Surrogate
 primary keys should always be translated to 'id' properties on
 entities (i.e. person.person_id maps to Person.getId()). Both of
 these should be optional/customizable if you're distributing.

 Methods should be smart enough to only do something when needed. So
 if I load an entity and then immediately call save(), nothing should
 happen, since the entity's properties haven't been changed. There
 should be a 'save' method, which will intelligently insert or update,
 ideally only the modified fields on updates.

 Beans should have a constructor that accepts full instance data as
 args. Beans should automatically have basic validation coded by the
 generator. I.e. INT fields can automatically check for integer-ness,
 varchar fields can be checked for length restrictions, etc. That
 should be easily extensible by the app developer, of course, without
 affecting the ability to regenerate if the DB schema changes.

 Beans should have getMemento and setMemento methods that allow for
 serializing the object state. According to the DP, the memento should
 be opaque (usually an inner class), but CF doesn't afford that very
 easily, so non-opaque is fine with me. Whatever that memento is, it
 should be trivially serialized/deserialized, or some other means of
 serializing/deserializing should be exposed.

 Some entity relationship support would be ideal, based on DB foreign
 keys. I.e. if the 'car' table has an 'ownerId' field that references
 person.id http://person.id, there should be getOwner:Person and
 setOwner(Person):void
 methods, and probably getOwnerId:int and setOwnerId(int):void methods
 as well. Ideally the Person object would have getCarList, addCar, and
 removeCar methods as well, but that's harder to autogenerate, unless
 you're doing the whole schema at once, rather than a single
 entity/table.

 And then the holy grail: many-to-many relationship support. I'd be
 happy with forcing the 'link' table to be it's own implicit entity, as
 long as the two 'real' entities are smart enough to have direct access
 to the other 'real' entity. I.e. the link table entity is an exposed
 implementation detail. For example, people own cars, cars are owned
 by people. Person, Car, and CarOwnership entities with
 Person.getCarList, Car.getOwnerList, and CarOwnership.getPerson
 methods, along with their supporting methods.

 Updates to relationships need to be clearly documented, as does the
 effect of calling save on an entity with modified related objects.
 Propogation is good, but should be disable-able at some level or
 another.

 I'd hope to see factory/managers for the beans so they're easy to use.
 Aside from getPersonById, and getNewPerson, also have
 createPerson(name, dob, ...), deletePerson(id), and updatePerson(id,
 name, dob...) for calling from your UI(s). This would also be the
 place for doing caching and lazy loading in an encapsulated way. If
 you cache, hooks should be exposed that can be used for syncing across
 a cluster (the sync stuff would be built by the app developer and
 utilize the hooks).

 Some recognition of concurrency issues should be made, even if it's
 just to explicitly say you're on your own. Smart updates (i.e. only
 updating modified fields) goes a long way to mitigating this issue,
 but doesn't address it completely. For example UPDATE table SET f = f
 + 1 WHERE id = 3; is atomic, but t=getTById(3);t.setF(t.getF() +
 1);t.save(); is not atomic. Concurrency issues don't exist with the
 former, but do with the latter, unless the whole thing is in a
 transaction. That's a restriction this type of code can't enforce,
 but a well designed application will likely exhibit that behaviour so
 if clearly documented, I'd say it's reasonable to assume.

 Of course, there are sound arguments against this sort of thing at
 all. It's a delecate balance between using a tool to help you do your
 job, and relying on a tool because you can't really do your job. I'm
 all for using them until you've got a sound reason not to, though.

 cheers,
 barneyb

 On 11/8/05, John C. Bland II [EMAIL PROTECTED] wrote:
  What is it everyone looks for in a CRUD generator? I see some folks
 saying
  they'd like to see best practices, some want getters/setters, and others
  just want a function you pass everything too.
 
  Just a little 

Re: CRUD Generator

2005-11-09 Thread Thomas Chiverton
On Wednesday 09 November 2005 07:02, Barney Boisvert wrote:
 Based on my experience building custom, app-specific generators, what

So you're gonna have this rolled out by, say, Friday ?
:-)

-- 

Tom Chiverton 
Advanced ColdFusion Programmer

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223658
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CRUD Generator

2005-11-09 Thread John C. Bland II
2007...no specific day...just '07.

j/k

On 11/9/05, Thomas Chiverton [EMAIL PROTECTED] wrote:

 On Wednesday 09 November 2005 07:02, Barney Boisvert wrote:
  Based on my experience building custom, app-specific generators, what

 So you're gonna have this rolled out by, say, Friday ?
 :-)

 --

 Tom Chiverton
 Advanced ColdFusion Programmer

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cf shopping cart

2005-11-09 Thread dave
So whatever happened to our open source cfm shopping cart?
Has it already been ditched?

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time. 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223660
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfinclude from a template, or onRequestStart?

2005-11-09 Thread dave
He's not saying to but the actual html in the app.cfc file he's saying put the 
include. And I don't see why you couldn't or wouldn't. I'm doing it on a 
current site and other than a few hair pulls it works great. The main problem 
is that if you have a page you don't want it on then you got a problem. I have 
heard a few ppl say it's not a good idea but they dont explain why not?

here's a quote out of one of the 2 tuts I have read on application.cfc

 onRequestEnd 

This function is called at the end of a page request after all other ColdFusion 
code has executed. If you have application specific logic that should only be 
run at the end of your page, this is the place to put it. The following example 
simply outputs a footer by including the footer.cfm file:  cffunction 
name=onRequestEnd output=Yes returntype=void
   cfargument name=targetPage type=String required=Yes /
   cfinclude template=footer.cfm /
 /cffunction 

So when when ppl say its bad then WHY is it bad, it seems to run just as good 
as any other method.

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time. 


From: Matthew Walker [EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 9:12 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: cfinclude from a template, or onRequestStart? 

Personally, I wouldn't put any display elements in application.cfc but
rather use it for app setup purposes (defining global variables,
initialising shopping carts, etc). If you wanted to have a different
page template on a page it might be a big hassle -- or one day you may
want a page that delivers RSS or CSV or something else. Depending on the
way your site is structured, you may find custom tag pairs are a nice
way of wrapping templates around your pages

 ...
 ...
 ...

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 2:46 p.m.
To: CF-Talk
Subject: cfinclude from a template, or onRequestStart?

I usually assemble my pages with a cfinclude header, menu, footer, etc. 
But I figured it might be better to include the header.cfm in
onRequestStart, and footer.cfm in onRequestEnd to keep from spreading
includes all over the place. 

This way they'd all be in one spot. Am I thinking right??

Thanks,
Will



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223661
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cf shopping cart

2005-11-09 Thread Snake
Well I did offer some space on CFDeveloper for it, but no-one was
interested.
Just another good idea that never happens I guess.

--
Snake 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 09 November 2005 10:21
To: CF-Talk
Subject: cf shopping cart

So whatever happened to our open source cfm shopping cart?
Has it already been ditched?

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time. 





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: ColdFusion Reseller Accounts

2005-11-09 Thread Snake
Anne,

Resellers can set their own currency symbol, so you can charge your
customers in $, YEN, or whatever you like.

Russ 

-Original Message-
From: Anne Girardeau [mailto:[EMAIL PROTECTED] 
Sent: 08 November 2005 23:48
To: CF-Talk
Subject: Re: ColdFusion Reseller Accounts

Russ, that is pretty cool.  However, since I'm in the states, I think some
of my clients may prefer to pay for their hosting in $ rather than £.  But,
if you have the option to pay for accounts with $ that would be absolutely
awesome.  Let me know.

Thanks,
--Anne


John C. Bland II wrote:

Oh now that's sweet.

On 11/7/05, Snake [EMAIL PROTECTED] wrote:
  

Our control panel allows resellers to use it's billing system or turn 
it off and use their own system.
They can create their own plans, charge what they want when they want, 
set tax, set discounts, etc.

Russ









~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223663
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFFTP and CFDIRECTORY

2005-11-09 Thread Dave Ashworth
once I have made a connection using CFFTP, how would I then use that to run
a CFDirectory operation so that I can then run a CFFile operation, read the
contents of the files and then delete said files?

so far I have tried with no luck:

cfftp
connection=this_bounceback_list
action=open
username=LCBounceback
password=password
server=whatever
port=2121
name=this_connection
stopOnError=yes

cfftp
connection=this_bounceback_list
action=GetCurrentDir
stopOnError=Yes

cfdirectory directory=#cfftp.returnvalue#
name=bounceback_folder
filter=*.msg

Thanks in advance
Dave


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223664
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Difficult Sort - Theory

2005-11-09 Thread Les Mizzell
 MySQL doens't have view support until 5.0, and that's only been out
 for a few weeks, 

Once I saw the data I had to work with, and the 3857 different ways the 
client wanted to search/sort, I was aching to be able to use views! 
Certainly would have simplified the process!

-- 
---
Les Mizzell

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223666
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFFTP and CFDIRECTORY

2005-11-09 Thread ColdFusion Developer
You can not use the CFDirectory base don the connection. 
You have to use the CFFTP ACTION=LISTDIR and then use
that information. 

To read a File from the FTP, you will have to download
The file to the local server then read it. Such as:

CFFTP ACTION=GETFILE

Then use 
CFFILE ACTION=READ



-Original Message-
From: Dave Ashworth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 7:24 AM
To: CF-Talk
Subject: CFFTP and CFDIRECTORY

once I have made a connection using CFFTP, how would I then use that to run
a CFDirectory operation so that I can then run a CFFile operation, read the
contents of the files and then delete said files?

so far I have tried with no luck:

cfftp
connection=this_bounceback_list
action=open
username=LCBounceback
password=password
server=whatever
port=2121
name=this_connection
stopOnError=yes

cfftp
connection=this_bounceback_list
action=GetCurrentDir
stopOnError=Yes

cfdirectory directory=#cfftp.returnvalue#
name=bounceback_folder
filter=*.msg

Thanks in advance
Dave




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223667
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: PERL form email with attachment?

2005-11-09 Thread Thomas Chiverton
On Monday 07 November 2005 19:25, Burns, John D wrote:
 Anyone have a simple script laying around to do this or could some write
 one out real quick? If not, no biggy. Just trying to prove how much

http://jenda.krynicky.cz/perl/Sender.pm.html#sending%20a%20file%20that%20was%20just%20uploaded%20from%20a%20html%20form

-- 

Tom Chiverton 
Advanced ColdFusion Programmer

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223668
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SESSION or not to SESSION

2005-11-09 Thread Morgan Leecy
I am developing a dataing site for a friend, and it looks pretty good, and 
working really well..
I expected to be able to have time to upgrade as time went on and members went 
up, but my 'friend' has just bought the member list from a another dating site 
which is closing down, so all of a sudden I am gonna find my site has 2000 
active users, and 27000 casual
Whoppee
Now the site has SQL2000 in the background so I am not concerned about database 
access, and I am even going to split the database to two independant sections, 
but my problem is THIS
When users login, a whole host of SESSION variables are created, I also use 
SESSION variables for quite a few functions as I like to use ARRAYS to kweep 
things neat, and I cant create arrays with CLIENT variables, and I dont like to 
use COOKIES as they can be blocked.
But lets imagine when we go live, all 29000 sign on, all these SESSION 
variables will exist in the servers memory, and what happens if loads more sign 
up?
Am I worrying unduly? or is there a better way (can session variables be stored 
in the database itself?
Any suggestions welcome
Morgan


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223669
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SESSION or not to SESSION

2005-11-09 Thread Charlie Griefer
unless you're explicitly passing CFID and CFTOKEN variables from page
to page...session variables rely on cookies.

(i know that's not answering the question you posed...but something to
take into consideration if you're truly that concerned about using
cookies.

FWIW, if your site requires a login, I think it's perfectly valid to
state, your browser must have cookies enabled to properly use this
site.

Might you lose a few users that won't use cookies?  Possibly (but I'd
argue it would be very few).  But the users that do continue on...you
at least know that they're aware of the requirements and will have
cookies enabled.


On 11/9/05, Morgan Leecy [EMAIL PROTECTED] wrote:
 I am developing a dataing site for a friend, and it looks pretty good, and 
 working really well..
 I expected to be able to have time to upgrade as time went on and members 
 went up, but my 'friend' has just bought the member list from a another 
 dating site which is closing down, so all of a sudden I am gonna find my site 
 has 2000 active users, and 27000 casual
 Whoppee
 Now the site has SQL2000 in the background so I am not concerned about 
 database access, and I am even going to split the database to two independant 
 sections, but my problem is THIS
 When users login, a whole host of SESSION variables are created, I also use 
 SESSION variables for quite a few functions as I like to use ARRAYS to kweep 
 things neat, and I cant create arrays with CLIENT variables, and I dont like 
 to use COOKIES as they can be blocked.
 But lets imagine when we go live, all 29000 sign on, all these SESSION 
 variables will exist in the servers memory, and what happens if loads more 
 sign up?
 Am I worrying unduly? or is there a better way (can session variables be 
 stored in the database itself?
 Any suggestions welcome
 Morgan


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223670
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Generate PPT slides from CF

2005-11-09 Thread Burns, John D
I'm trying to generate PPT slides from CF and I'm running into some
difficulty. I've got some reports that users can run whenever they're
like and the display in HTML by default. On one report, we put a
Powerpoint button that spits out the same HTML and just specifies the
filename as .ppt and returns the header for that. This works fine for a
simple tabled report as PPT converts the HTML to a slide. The issue that
I'm running into is when there is an image on the report. If I put it in
as an img src... it works fine, but if you don't have access to the
internet, it won't work. I'd like to somehow embed an image in there so
that users can take it on the road for presentations. Anybody done
something like this or have any ideas? I've looked in the exchange for
tags but haven't had much luck.
 
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 
 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223671
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SESSION or not to SESSION

2005-11-09 Thread Robert Everland III
I would reevaluate the session variables you have and see what variables never 
change between users. I would then take those variables and move them to the 
application scope. Any functions you are using I would move to the application 
scope. I would NOT use client variables. The biggest bottleneck for your 
application will be from the database to your application enviroment. Every 
time you would need to read or write a variable would be a write to the 
database.



Bob Everland

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223672
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SESSION or not to SESSION

2005-11-09 Thread Burns, John D
It may help if someone can answer this question:
How much memory does it really take to store a single session. How much
can you store in the single session to know you're safe with this sort
of issue? Anyone have any numbers for this sort of thing? Obviously,
each application is different, but how much memory space would it take
to store a session with 50 variables in it and 20 arrays/structs with
say another 50 variables in each. Assume each value is 200 characters or
less. Also, what's the overhead on storing objects in sessions? Is
everything simple calculated by figuring how many bytes the text is and
assume each session takes that much memory or is there some sort of
compression or overhead happening to affect the numbers?


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Morgan Leecy [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 9:21 AM
To: CF-Talk
Subject: SESSION or not to SESSION

I am developing a dataing site for a friend, and it looks pretty good,
and working really well..
I expected to be able to have time to upgrade as time went on and
members went up, but my 'friend' has just bought the member list from a
another dating site which is closing down, so all of a sudden I am gonna
find my site has 2000 active users, and 27000 casual Whoppee Now the
site has SQL2000 in the background so I am not concerned about database
access, and I am even going to split the database to two independant
sections, but my problem is THIS When users login, a whole host of
SESSION variables are created, I also use SESSION variables for quite a
few functions as I like to use ARRAYS to kweep things neat, and I cant
create arrays with CLIENT variables, and I dont like to use COOKIES as
they can be blocked.
But lets imagine when we go live, all 29000 sign on, all these SESSION
variables will exist in the servers memory, and what happens if loads
more sign up?
Am I worrying unduly? or is there a better way (can session variables be
stored in the database itself?
Any suggestions welcome
Morgan




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223673
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SESSION or not to SESSION

2005-11-09 Thread Ken Ferguson
I'll go along with this sentiment. Use session variables when you need 
them, but put what you can into the applicaiton and request scopes. RAM 
is cheap.

--Ferg


Robert Everland III wrote:

I would reevaluate the session variables you have and see what variables never 
change between users. I would then take those variables and move them to the 
application scope. Any functions you are using I would move to the application 
scope. I would NOT use client variables. The biggest bottleneck for your 
application will be from the database to your application enviroment. Every 
time you would need to read or write a variable would be a write to the 
database.



Bob Everland



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223674
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Spaces in cfexecute on Windows machine

2005-11-09 Thread Adrian Showater
Thanks for the help.  The escaped double-quotes did the trick.

Adrian Showalter
Software Developer
Holmes BizNet
www.HolmesBizNet.com http://www.HolmesBizNet.com 
330.893.3901 ext 102


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223675
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


reload Java classes

2005-11-09 Thread George Abraham
All,
Before I give up on this (since I have searched the Interweb and have not
got any solutions), I wanted to ask the people on the list about this. I
have a Java program that is currently under development and I call Java
class using the cfobject tag. I am having to restart the CFMX 7 server every
single time that I have to make a change to the class. Is there absolutely
no way the class can reload itself without this constant restarting? I can
already hear the sighs out there!

No, I am not deploying CF in a J2EE environment , so I can't modify
jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K.

Thanks,
George


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223676
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Generate PPT slides from CF

2005-11-09 Thread John Paul Ashenfelter
On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
 I'm trying to generate PPT slides from CF and I'm running into some
 difficulty. I've got some reports that users can run whenever they're
 like and the display in HTML by default. On one report, we put a
 Powerpoint button that spits out the same HTML and just specifies the
 filename as .ppt and returns the header for that. This works fine for a
 simple tabled report as PPT converts the HTML to a slide. The issue that
 I'm running into is when there is an image on the report. If I put it in
 as an img src... it works fine, but if you don't have access to the
 internet, it won't work. I'd like to somehow embed an image in there so
 that users can take it on the road for presentations. Anybody done
 something like this or have any ideas? I've looked in the exchange for
 tags but haven't had much luck.

This doesn't *exactly* meet the requirements, but there's a web-based
presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that
feels a lot like PowerPoint (unless you use really fancy transistions)
but is all (x)HTML under the hood. It *might* be easier just to use it
since you can use the HTML you are already building directly in a
slide, embed images, etc -- and then package it all up to take on the
road. It's a single HTML file, a theme, a JS file, and any media you
include.
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223677
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: calling java class from CFMX

2005-11-09 Thread George Abraham
Robert,
Sorry for dropping off. I just read this email. I did find out that I was
thinking badly about it. I did do this by actually instantiating the Java
class using cfobject.

Thanks,
George

On 11/7/05, Robert Munn [EMAIL PROTECTED] wrote:

 WHy not just call your Java class using CFOBJECT to instantiate the native
 Java object? In order to do that, you'll need to reference your additional
 classes in the CFMX classpath arguments. If you need this class to have some
 special security permissions, you might also want to consider writing a
 wrapper class that calls the other class by impersonating another user
 account.

 All,
 CFMX 7 on Win 2000 (a test server). I wrote a Java program and compiled
 it
 on the server under another user account (not the one running the CFMX
 service). The program compiled correctly and I was able to run it using
 the
 command line. Now it imports some specific java libraries that are not in
 the JRE. I want to be able to run this Java class peridocally so I
 thought I
 could simply add a CF task that cfexecutes the class using the
 cmd.exeprogram. I know that this might be a security issue. I have two
 questions:
 1. Is it a security issue? If so, how else can I run the Java class? It
 is a
 normal java program with a main() method that directs various methods.
 2. If not a security issue, does the account that runs CFMX (currently a
 local system account) have to be one that is not a system account? I am
 currently running the cfexecute by calling the complete classpath that is
 required for the java program to execute. However I am just getting a
 blank
 page and nothing else.
 
 Regards,
 George

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223678
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SESSION or not to SESSION

2005-11-09 Thread John Paul Ashenfelter
On 11/9/05, Ken Ferguson [EMAIL PROTECTED] wrote:
 I'll go along with this sentiment. Use session variables when you need
 them, but put what you can into the applicaiton and request scopes. RAM
 is cheap.

 --Ferg

Agreed. Actually, it's a lot easier to turn the calculation around.
You have a maximal peak of a little less than 30,000 users (2000
active 27000 casual), so 1MB of RAM gives each of those 30k users
33bytes. Assuming Unicode to give a lot of overhead, that's 16 usable
bytes per MB. Cut that in half to factor in a lot of overhead and
you've got 8 usable bytes left. So 1 GB of RAM for session use would
give you 8000 bytes per person with plenty of room left over
that's assuming your box can *handle* all 30k at once, which is pretty
unlikely :)

Using a more realistic scenario like 1000 users with active sessions
1MB - 1000 bytes - 500 unicode characters -50%overhead- 250 usable bytes/user
So 1GB yields 250,000 usable bytes of storage for that user. That's
a lot of storage

sidebarI'm using characters to equate to usable bytes since
ColdFusion isn't really typed -- under the hood, it's converted in
many cases, but using characters should be on average equal or greater
than the underlying data strucuture. This is really an order of
magnitude calculation so the specifics are not a big deal -- and if
anything, these should be pretty conservative numbers./sidebar

So the point is, you really have to put a *lot* in session scope
and/or have a *lot* of users to approach any real worries about
session memory.

--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223679
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SESSION or not to SESSION

2005-11-09 Thread Kerry
question:
Do you have to modify the JVM settings so that CF can actually use our
theoretical 1GB of RAM?


-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 16:02
To: CF-Talk
Subject: Re: SESSION or not to SESSION


On 11/9/05, Ken Ferguson [EMAIL PROTECTED] wrote:
 I'll go along with this sentiment. Use session variables when you need
 them, but put what you can into the applicaiton and request scopes. RAM
 is cheap.

 --Ferg

Agreed. Actually, it's a lot easier to turn the calculation around.
You have a maximal peak of a little less than 30,000 users (2000
active 27000 casual), so 1MB of RAM gives each of those 30k users
33bytes. Assuming Unicode to give a lot of overhead, that's 16 usable
bytes per MB. Cut that in half to factor in a lot of overhead and
you've got 8 usable bytes left. So 1 GB of RAM for session use would
give you 8000 bytes per person with plenty of room left over
that's assuming your box can *handle* all 30k at once, which is pretty
unlikely :)

Using a more realistic scenario like 1000 users with active sessions
1MB - 1000 bytes - 500 unicode characters -50%overhead- 250 usable
bytes/user
So 1GB yields 250,000 usable bytes of storage for that user. That's
a lot of storage

sidebarI'm using characters to equate to usable bytes since
ColdFusion isn't really typed -- under the hood, it's converted in
many cases, but using characters should be on average equal or greater
than the underlying data strucuture. This is really an order of
magnitude calculation so the specifics are not a big deal -- and if
anything, these should be pretty conservative numbers./sidebar

So the point is, you really have to put a *lot* in session scope
and/or have a *lot* of users to approach any real worries about
session memory.

--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223680
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


test

2005-11-09 Thread Shy Boy
test

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223681
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SESSION or not to SESSION

2005-11-09 Thread John Paul Ashenfelter
On 11/9/05, Kerry [EMAIL PROTECTED] wrote:
 question:
 Do you have to modify the JVM settings so that CF can actually use our
 theoretical 1GB of RAM?

My understanding is yes -- but that assumes your app is really going
to use all that memory -- the calculation was basically an
order-of-magnitude to see where assumptions break down. Load testing
of course is the only real way to tune for performance under load.

As an aside, it may be that moving some of the session data that's
db-related back to the db and requerying (and relying on the db cache
to keep things speedy) may be a performance boost compared to storing
in session.

--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223682
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Export Matrix to Excel

2005-11-09 Thread Richard Colman
(If this is a dupe, I apologize)

 

I am trying to export a data table to an Excel spreadsheet.

 

The data table looks like

 

IdA, 1, x

IdA, 2, y

IdA, 3, z

.. etc.

IdB, 1, q

IdB, 2, r

IdB, 3, s

... etc.

 

I want the spreadsheet to look like:

 

ID 123   ..

 A xyz   ...

 B qrs   ...

 

Etc.

 

 

Can anyone suggest an approach to arrange the data for export to a
spreadsheet.

 

TNX if you can help.

 

Rick.





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


qForm issue

2005-11-09 Thread Shy Boy
I am having issue with qForms.

In IE the error is could not get the display property. Invalid argument.


In Firefox it does works and giving me the required result, but with error.
Exception... Permission denied to get property XULElement.selectedIndex when 
calling method


The only modification I've done is with the qform.js file under 
function _f_throwError(error)

I have added these two lines in that function just to display inline error msgs 
in the form.

document.getElementById(id).style.visibility = visible;
document.getElementById(id).style.display = table-row;

if there is any other solution to display the inline error msgs on forms that 
would be greate too..
thanks

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223684
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cf shopping cart

2005-11-09 Thread Aldon
I think this is a excellent idea!  Lets try this again.




-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 7:21 AM
To: CF-Talk
Subject: RE: cf shopping cart


Well I did offer some space on CFDeveloper for it, but no-one was
interested.
Just another good idea that never happens I guess.

--
Snake

-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 10:21
To: CF-Talk
Subject: cf shopping cart

So whatever happened to our open source cfm shopping cart?
Has it already been ditched?

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time.







~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223685
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: User Defined Functions in ColdFusion

2005-11-09 Thread Thomas Chiverton
On Wednesday 09 November 2005 03:11, simmyana a wrote:
 Hi,
   I have created an UDF in MS sql and I want to use it in coldfusion while
 writing the query. could you please tell me as how to use UDF of MS Sql in
 Coldfusion?

If you can type it into whatever database tool you use, you can use it in 
cfquery...

Typicaly, the contents of cfquery will look like:

select myFunction() as result from dual

or

select myFunctionForThisColumn(columnName)  as result from tableName

if it acts on a table/column.

-- 

Tom Chiverton 
Advanced ColdFusion Programmer

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223686
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Dan G. Switzer, II
Sorry for the slightly off-topic post, but I've got a client who's trying to
convert a bunch of old Ami Pro v3 documents to Word (or at least some other
modern day format.) 

Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer
runs under the new operating systems. 

While Word does have an Ami Pro filter, it seems to only work with documents
that contain only text. Most of these documents contained graphics and
layouts drawn with the Ami Pro toolset. All of these documents come up
blank.

Does anyone know of a tool that will accurately convert Ami Pro documents? 

Worst case scenario is I try to get the software running on old PC and try
to get a version of Acrobat running on the box. I batch conversion tool
would make life much, much easier.

rant
Archived files are a bit of a dirty little secret in the computer industry
that really tends to affect small business owners. I've seen some business
owners archive data as their supposed to, but then not be able to get to the
archived data years later because the software needed to read/write the data
doesn't work anymore. 

You also have to be very careful in the media you choose to backup to. Many
people think that any CD-R/CD-RW will last virtually forever, but I've seen
cheap CD-R media go bad within 2 years--to the point were the disc is
unreadable. You have to be very careful w/archived data if it's information
that crucial to your business.
/rant

-Dan



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223687
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cf shopping cart

2005-11-09 Thread Russell Patterson
I am excited about it and will be able to help out next week.  I am not the 
strongest developer, but will be more then willing to put in my two cents 
worth.

Russell

- Original Message - 
From: Aldon [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, November 09, 2005 10:44 AM
Subject: RE: cf shopping cart


I think this is a excellent idea!  Lets try this again.




 -Original Message-
 From: Snake [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 09, 2005 7:21 AM
 To: CF-Talk
 Subject: RE: cf shopping cart


 Well I did offer some space on CFDeveloper for it, but no-one was
 interested.
 Just another good idea that never happens I guess.

 --
 Snake

 -Original Message-
 From: dave [mailto:[EMAIL PROTECTED]
 Sent: 09 November 2005 10:21
 To: CF-Talk
 Subject: cf shopping cart

 So whatever happened to our open source cfm shopping cart?
 Has it already been ditched?

 ~Dave the disruptor~
 Some people just don't appreciate how difficult it is to dispense wisdom
 and abuse at the same time.







 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223688
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cf shopping cart

2005-11-09 Thread Jordan Michaels
dave wrote:

So whatever happened to our open source cfm shopping cart?
Has it already been ditched?

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time. 


  

Someone needs to grab that project by the horns and lead it.

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED] 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223689
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Generate PPT slides from CF

2005-11-09 Thread Burns, John D
John Paul -

So this is really a separate file type and presentation system? We are
supporting corporate customers who are really tied to PPT already so we
really need something that can generate a PPT slide completely.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 10:43 AM
To: CF-Talk
Subject: Re: Generate PPT slides from CF

On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
 I'm trying to generate PPT slides from CF and I'm running into some 
 difficulty. I've got some reports that users can run whenever they're 
 like and the display in HTML by default. On one report, we put a 
 Powerpoint button that spits out the same HTML and just specifies the 
 filename as .ppt and returns the header for that. This works fine for 
 a simple tabled report as PPT converts the HTML to a slide. The issue 
 that I'm running into is when there is an image on the report. If I 
 put it in as an img src... it works fine, but if you don't have 
 access to the internet, it won't work. I'd like to somehow embed an 
 image in there so that users can take it on the road for 
 presentations. Anybody done something like this or have any ideas? 
 I've looked in the exchange for tags but haven't had much luck.

This doesn't *exactly* meet the requirements, but there's a web-based
presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that
feels a lot like PowerPoint (unless you use really fancy transistions)
but is all (x)HTML under the hood. It *might* be easier just to use it
since you can use the HTML you are already building directly in a slide,
embed images, etc -- and then package it all up to take on the road.
It's a single HTML file, a theme, a JS file, and any media you include.
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223690
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: formatting a date in cfgrid

2005-11-09 Thread Anthony Prato
Just figured this problem out last night. I lost your original email,
but from your screen shot it looks the same. It's not in the docs but
put a type=date on the cfgridcolumn

On 11/4/05, Alexander Hinkley [EMAIL PROTECTED] wrote:
 i did the update this morning.. i still get the same results..

 http://single-dads.us/grid.jpg

 the petid field shows the format of the date as it comes from the
 db... via remoting..

 On 10/28/05, Mike Nimer [EMAIL PROTECTED] wrote:
  Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think
  this was fixed as well.
  ---nimer
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223691
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


(Admin) Report help

2005-11-09 Thread Michael Dinowitz
While looking over some stuff on House of Fusion yesterday I noticed that I've 
been logging information since around march and I've had over 16.5 million page 
views in that time (about 2 million a month). The logging has records of what's 
a bot and what's a human. The problem? No reporting interface to the data. 
I was wondering if anyone here with experience with reporting has a few moments 
to devote to writing a report interface to the data. I'll be giving out the CFC 
and database structure I use to the community so whoever helps with the 
reporting will have their name associated with the full project. 

You can contact me off list, by yahoo chat or phone for more info or ideas.

Thanks

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223692
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: reload Java classes

2005-11-09 Thread Douglas Knudsen
keep on restarting that server  :)

http://livedocs.macromedia.com/jrun/4/Getting_Started_with_JRun/intro5.htm

hot deploy works wehn a jsp or servlet is called.  So, CreateObject()
will not effect this.

DK

On 11/9/05, George Abraham [EMAIL PROTECTED] wrote:
 All,
 Before I give up on this (since I have searched the Interweb and have not
 got any solutions), I wanted to ask the people on the list about this. I
 have a Java program that is currently under development and I call Java
 class using the cfobject tag. I am having to restart the CFMX 7 server every
 single time that I have to make a change to the class. Is there absolutely
 no way the class can reload itself without this constant restarting? I can
 already hear the sighs out there!

 No, I am not deploying CF in a J2EE environment , so I can't modify
 jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K.

 Thanks,
 George


 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223693
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: (Admin) Report help

2005-11-09 Thread Burns, John D
Are you just talking about something like a log analyzer? Wouldn't it be
better to use something other than CF for that? There are lots of other
software pieces out there to do that. I looked into doing it before but
to read the file line by line and do database operations just seems
extremely inefficient with Cf. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 12:20 PM
To: CF-Talk
Subject: (Admin) Report help

While looking over some stuff on House of Fusion yesterday I noticed
that I've been logging information since around march and I've had over
16.5 million page views in that time (about 2 million a month). The
logging has records of what's a bot and what's a human. The problem? No
reporting interface to the data. 
I was wondering if anyone here with experience with reporting has a few
moments to devote to writing a report interface to the data. I'll be
giving out the CFC and database structure I use to the community so
whoever helps with the reporting will have their name associated with
the full project. 

You can contact me off list, by yahoo chat or phone for more info or
ideas.

Thanks



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223694
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Generate PPT slides from CF

2005-11-09 Thread John Paul Ashenfelter
On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
 John Paul -

 So this is really a separate file type and presentation system? We are
 supporting corporate customers who are really tied to PPT already so we
 really need something that can generate a PPT slide completely.

Yep -- alternative system. Tough challenge! The only thing I can think
of is really complicated -- using VBA to write the slide directly.
Something like using cfobject and the underlying com object as shown
in this VBA example http://skp.mvps.org/ppt00046.htm#2

Argh! :)


 John Burns
 Certified Advanced ColdFusion MX Developer
 Wyle Laboratories, Inc. | Web Developer


 -Original Message-
 From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 09, 2005 10:43 AM
 To: CF-Talk
 Subject: Re: Generate PPT slides from CF

 On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
  I'm trying to generate PPT slides from CF and I'm running into some
  difficulty. I've got some reports that users can run whenever they're
  like and the display in HTML by default. On one report, we put a
  Powerpoint button that spits out the same HTML and just specifies the
  filename as .ppt and returns the header for that. This works fine for
  a simple tabled report as PPT converts the HTML to a slide. The issue
  that I'm running into is when there is an image on the report. If I
  put it in as an img src... it works fine, but if you don't have
  access to the internet, it won't work. I'd like to somehow embed an
  image in there so that users can take it on the road for
  presentations. Anybody done something like this or have any ideas?
  I've looked in the exchange for tags but haven't had much luck.

 This doesn't *exactly* meet the requirements, but there's a web-based
 presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that
 feels a lot like PowerPoint (unless you use really fancy transistions)
 but is all (x)HTML under the hood. It *might* be easier just to use it
 since you can use the HTML you are already building directly in a slide,
 embed images, etc -- and then package it all up to take on the road.
 It's a single HTML file, a theme, a JS file, and any media you include.
 --
 John Paul Ashenfelter
 CTO/Transitionpoint
 (blog) http://www.ashenfelter.com
 (email) [EMAIL PROTECTED]



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223695
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: (Admin) Report help

2005-11-09 Thread Michael Dinowitz
All of the information is already in a DB with a very efficient structure. 
For example, the user agents are all ids rather than strings linked to a 
lookup table. I'm looking to create different forms of daily, weekly and 
monthly stats into separate tables for ease and speed but the issue has 
always been displaying the data. Showing off that browser X has 80% vs. 
browser Y and bot Z is taking up 15% of all hits.
The data is probably useful just to show how many hits the site gets per 
day, week, etc.

 Are you just talking about something like a log analyzer? Wouldn't it be
 better to use something other than CF for that? There are lots of other
 software pieces out there to do that. I looked into doing it before but
 to read the file line by line and do database operations just seems
 extremely inefficient with Cf.


 John Burns
 Certified Advanced ColdFusion MX Developer
 Wyle Laboratories, Inc. | Web Developer


 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 09, 2005 12:20 PM
 To: CF-Talk
 Subject: (Admin) Report help

 While looking over some stuff on House of Fusion yesterday I noticed
 that I've been logging information since around march and I've had over
 16.5 million page views in that time (about 2 million a month). The
 logging has records of what's a bot and what's a human. The problem? No
 reporting interface to the data.
 I was wondering if anyone here with experience with reporting has a few
 moments to devote to writing a report interface to the data. I'll be
 giving out the CFC and database structure I use to the community so
 whoever helps with the reporting will have their name associated with
 the full project.

 You can contact me off list, by yahoo chat or phone for more info or
 ideas.

 Thanks



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223696
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Howie Hamlin
Did you try this one:

http://support.microsoft.com/Default.aspx?kbid=208863

Regards,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion and BlueDragon applications
Find out how iMS Stacks up to the competition: 
http://www.coolfusion.com/imssecomparison.cfm

iMS-Lite - the completely free mail server solution for applications and 
application servers
http://www.coolfusion.com/iMSLite

--- On Wednesday, November 09, 2005 11:37 AM, Dan G. Switzer, II scribed: ---

 Sorry for the slightly off-topic post, but I've got a client who's
 trying to 
 convert a bunch of old Ami Pro v3 documents to Word (or at least some
 other 
 modern day format.)
 
 Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no
 longer 
 runs under the new operating systems.
 
 While Word does have an Ami Pro filter, it seems to only work with
 documents 
 that contain only text. Most of these documents contained graphics and
 layouts drawn with the Ami Pro toolset. All of these documents come up
 blank.
 
 Does anyone know of a tool that will accurately convert Ami Pro
 documents? 
 
 Worst case scenario is I try to get the software running on old PC
 and try 
 to get a version of Acrobat running on the box. I batch conversion
 tool 
 would make life much, much easier.
 
 rant
 Archived files are a bit of a dirty little secret in the computer
 industry 
 that really tends to affect small business owners. I've seen some
 business 
 owners archive data as their supposed to, but then not be able to get
 to the 
 archived data years later because the software needed to read/write
 the data 
 doesn't work anymore.
 
 You also have to be very careful in the media you choose to backup
 to. Many 
 people think that any CD-R/CD-RW will last virtually forever, but
 I've seen 
 cheap CD-R media go bad within 2 years--to the point were the disc is
 unreadable. You have to be very careful w/archived data if it's
 information 
 that crucial to your business.
 /rant
 
 -Dan
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223697
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Ron Williams
If none of the conversion filters work for you and you have to hand-step it
through several processes, you might try one of the macro packages like
Automate (www.unisyn.com)

Best regards, Ron

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 8:38 AM
To: CF-Talk
Subject: OT: Tools to convert old Ami Pro v3 documents?

Sorry for the slightly off-topic post, but I've got a client who's trying to
convert a bunch of old Ami Pro v3 documents to Word (or at least some other
modern day format.) 

Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer
runs under the new operating systems. 

While Word does have an Ami Pro filter, it seems to only work with documents
that contain only text. Most of these documents contained graphics and
layouts drawn with the Ami Pro toolset. All of these documents come up
blank.

Does anyone know of a tool that will accurately convert Ami Pro documents? 

Worst case scenario is I try to get the software running on old PC and try
to get a version of Acrobat running on the box. I batch conversion tool
would make life much, much easier.

rant
Archived files are a bit of a dirty little secret in the computer industry
that really tends to affect small business owners. I've seen some business
owners archive data as their supposed to, but then not be able to get to the
archived data years later because the software needed to read/write the data
doesn't work anymore. 

You also have to be very careful in the media you choose to backup to. Many
people think that any CD-R/CD-RW will last virtually forever, but I've seen
cheap CD-R media go bad within 2 years--to the point were the disc is
unreadable. You have to be very careful w/archived data if it's information
that crucial to your business.
/rant

-Dan





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223698
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: capture rendered HTML to an image

2005-11-09 Thread Emmet McGovern
Efflares ImageCR does website screenshots as well as some of the more
incredible image manipulation function available.  Check em out at
http://www.efflare.com  

Emmet

-Original Message-
From: Nando [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 4:08 AM
To: CF-Talk
Subject: capture rendered HTML to an image

Hi all,
 I'm looking for an approach that's not too complex to implement to capture
rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for
templates in an automated fashion.
 Using cfdocument and outputting to a jpeg would be perfect, but cfdocument
only outputs to PDF and FlashPaper :-(
 Any suggestions would be welcome!
 thanks
Nando




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223699
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cf shopping cart

2005-11-09 Thread Snake
OK, I have setup a forum for the project.
You will need to register at www.cfdeveloper.co.uk to get access
Then goto forums -- projects -- cf_shoppingcart 

The forum password is: tangerine

If we get the discussion going here and plan out all the features, then I
can setup the development web space and decide who will manage it.

--
Russ

-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
Sent: 09 November 2005 17:05
To: CF-Talk
Subject: Re: cf shopping cart

dave wrote:

So whatever happened to our open source cfm shopping cart?
Has it already been ditched?

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time. 


  

Someone needs to grab that project by the horns and lead it.

--
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED] 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223700
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Dan G. Switzer, II
Howie,

Did you try this one:

http://support.microsoft.com/Default.aspx?kbid=208863

Yes, but as stated in my e-mail, it does not correctly open Ami Pro files
that have images/drawings in them.

-Dan




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223701
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: qForm issue

2005-11-09 Thread Dan G. Switzer, II
The only modification I've done is with the qform.js file under
function _f_throwError(error)

I have added these two lines in that function just to display inline error
msgs in the form.

document.getElementById(id).style.visibility = visible;
document.getElementById(id).style.display = table-row;

What are you expecting those lines to do? Unless you've modified the
_f_throwError function in some other manor, the variable id would have no
value.

-Dan



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223702
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Howie Hamlin
Yes, I read your mail but wasn't sure that this was the converter you were 
using.

Howie

--- On Wednesday, November 09, 2005 1:29 PM, Dan G. Switzer, II scribed: ---

 Howie,
 
 Did you try this one:
 
 http://support.microsoft.com/Default.aspx?kbid=208863
 
 Yes, but as stated in my e-mail, it does not correctly open Ami Pro
 files 
 that have images/drawings in them.
 
 -Dan
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223703
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


removing trailing comma in CSV row

2005-11-09 Thread Richard Colman
I am trying to build lines of CSV data. However, I don't know exactly how to
get rid of the LAST comma in the line.

 

Here is the result:

 

42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
(note trailing comma)

 

Here is the code (ugly as it may be):

 

cfquery .

select spdinput_id, location,score from spdout  

group by spdinput_id, location, score

order by spdinput_id, location

/cfquery

 

 cfloop from=1 to=#get_result.recordcount# index=i step=1

 

 cfoutput query=get_result group=spdinput_id

  #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput

 

 /cfloop

 

Any ideas appreciated.

 

Rick.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223704
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


removing trailing comma in CSV row

2005-11-09 Thread Richard Colman
I am trying to build lines of CSV data. However, I don't know exactly how to
get rid of the LAST comma in the line.

 

Here is the result:

 

42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
(note trailing comma)

 

Here is the code (ugly as it may be):

 

cfquery .

select spdinput_id, location,score from spdout  

group by spdinput_id, location, score

order by spdinput_id, location

/cfquery

 

 cfloop from=1 to=#get_result.recordcount# index=i step=1

 

 cfoutput query=get_result group=spdinput_id

  #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput

 

 /cfloop

 

Any ideas appreciated.

 

Rick.





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: reload Java classes

2005-11-09 Thread George Abraham
Gah! And a thousand coises!

Thanks,
George

On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote:

 keep on restarting that server :)

 http://livedocs.macromedia.com/jrun/4/Getting_Started_with_JRun/intro5.htm

 hot deploy works wehn a jsp or servlet is called. So, CreateObject()
 will not effect this.

 DK

 On 11/9/05, George Abraham [EMAIL PROTECTED] wrote:
  All,
  Before I give up on this (since I have searched the Interweb and have
 not
  got any solutions), I wanted to ask the people on the list about this. I
  have a Java program that is currently under development and I call Java
  class using the cfobject tag. I am having to restart the CFMX 7 server
 every
  single time that I have to make a change to the class. Is there
 absolutely
  no way the class can reload itself without this constant restarting? I
 can
  already hear the sighs out there!
 
  No, I am not deploying CF in a J2EE environment , so I can't modify
  jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K.
 
  Thanks,
  George
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223706
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


encrypt + file append + decrypt

2005-11-09 Thread Kerry
okay, been looking at this for a while now, cant see why its not working,
suggestions appreciated!

!---
environment:
cfmx 6.1, win2K

code objective:
encrypt string + linebreak, append to file (repeat), read file, decrypt,
display in textarea

expected output:
1
2
3
4
5
6
7
8
9
10

actual output:
1
---

cfset logdir = getdirectoryfrompath(getcurrenttemplatepath())
cfset logfil = encrypted.txt
cfset logpath = logdirlogfil
cfif fileexists(logdirlogfil)
cffile action=delete file=#logpath#
/cfif
cfloop from=1 to=10 index=i
cfset message =
encrypt(URLEncodedFormat(ichr(13)chr(10)),hash(logfil))
cfif not fileexists(logdirlogfil)
cffile action=write file=#logpath# 
output=#message#
addnewline=no
cfelse
cffile action=append file=#logpath# 
output=#message#
addnewline=no
/cfif
/cfloop
cffile action=read file=#logpath# variable=filcontents
cfoutput
textarea
#URLDecode(decrypt(filcontents,hash(logfil)))#
/textarea
/cfoutput


thx all.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223707
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: removing trailing comma in CSV row

2005-11-09 Thread Marty Johll
do a left(string, len(string) - 1)



On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote:

 I am trying to build lines of CSV data. However, I don't know exactly how
 to
 get rid of the LAST comma in the line.



 Here is the result:



 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
 (note trailing comma)



 Here is the code (ugly as it may be):



 cfquery .

 select spdinput_id, location,score from spdout

 group by spdinput_id, location, score

 order by spdinput_id, location

 /cfquery



 cfloop from=1 to=#get_result.recordcount# index=i step=1



 cfoutput query=get_result group=spdinput_id

 #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput



 /cfloop



 Any ideas appreciated.



 Rick.



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223708
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: removing trailing comma in CSV row

2005-11-09 Thread Charlie Griefer
use listAppend()

cfset scoreList =  /
cfset scoreList = listAppend(scoreList, score) /

cfoutput#score#/cfoutput


if you don't want to change your logic, you can still set it to a
variable and use the left() function.

#left(score, len(score)-1)#

On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote:
 I am trying to build lines of CSV data. However, I don't know exactly how to
 get rid of the LAST comma in the line.



 Here is the result:



 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
 (note trailing comma)



 Here is the code (ugly as it may be):



 cfquery .

 select spdinput_id, location,score from spdout

 group by spdinput_id, location, score

 order by spdinput_id, location

 /cfquery



  cfloop from=1 to=#get_result.recordcount# index=i step=1



  cfoutput query=get_result group=spdinput_id

   #spdinput_id#,

  cfoutput#score#,/cfoutput

  p

  /cfoutput



  /cfloop



 Any ideas appreciated.



 Rick.



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223709
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Generate PPT slides from CF

2005-11-09 Thread George Abraham
If you are ready to risk Automation of Office components on your server
using CF, then I do have some code that might help you. Email me offline and
I can send it to you. Or you could look at the code at CFcomet:
http://cfregex.com/cfcomet/.

Regards,
George

On 11/9/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote:

 On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
  John Paul -
 
  So this is really a separate file type and presentation system? We are
  supporting corporate customers who are really tied to PPT already so we
  really need something that can generate a PPT slide completely.

 Yep -- alternative system. Tough challenge! The only thing I can think
 of is really complicated -- using VBA to write the slide directly.
 Something like using cfobject and the underlying com object as shown
 in this VBA example http://skp.mvps.org/ppt00046.htm#2

 Argh! :)

 
  John Burns
  Certified Advanced ColdFusion MX Developer
  Wyle Laboratories, Inc. | Web Developer
 
 
  -Original Message-
  From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, November 09, 2005 10:43 AM
  To: CF-Talk
  Subject: Re: Generate PPT slides from CF
 
  On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote:
   I'm trying to generate PPT slides from CF and I'm running into some
   difficulty. I've got some reports that users can run whenever they're
   like and the display in HTML by default. On one report, we put a
   Powerpoint button that spits out the same HTML and just specifies the
   filename as .ppt and returns the header for that. This works fine for
   a simple tabled report as PPT converts the HTML to a slide. The issue
   that I'm running into is when there is an image on the report. If I
   put it in as an img src... it works fine, but if you don't have
   access to the internet, it won't work. I'd like to somehow embed an
   image in there so that users can take it on the road for
   presentations. Anybody done something like this or have any ideas?
   I've looked in the exchange for tags but haven't had much luck.
 
  This doesn't *exactly* meet the requirements, but there's a web-based
  presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that
  feels a lot like PowerPoint (unless you use really fancy transistions)
  but is all (x)HTML under the hood. It *might* be easier just to use it
  since you can use the HTML you are already building directly in a slide,
  embed images, etc -- and then package it all up to take on the road.
  It's a single HTML file, a theme, a JS file, and any media you include.
  --
  John Paul Ashenfelter
  CTO/Transitionpoint
  (blog) http://www.ashenfelter.com
  (email) [EMAIL PROTECTED]
 
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223710
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: qForm issue

2005-11-09 Thread Asim Manzur
Actually I've added these three lines.

var id = this.obj.name + 1;
document.getElementById(id).style.visibility = visible;
document.getElementById(id).style.display = table-row;

I've added the td id=formfieldname1 right under the row where the
form field is and put the visibility=hidden.

so, what I was trying to do is once those qforms gonna make those
fields background red, just display that tr too.

and in IE its giving me an error, and in firefox it gives me an error
as well as it displays correctly too.

Please advise.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223711
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: capture rendered HTML to an image

2005-11-09 Thread cftalk
The last example on this page shows how to use ImageCR with
our free cfx_url2bmp tag to create website screenshots.

http://efflare.com/docs/CFX_ImageCR3/reference/examples/index.html#Website%20Screenshot

We will be expanding on this in the future.

-- 
 CrystalM

 Efflares ImageCR does website screenshots as well as some of the more
 incredible image manipulation function available.  Check em out at
 http://www.efflare.com  
 
 Emmet
 
 -Original Message-
 From: Nando [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, November 09, 2005 4:08 AM
 To: CF-Talk
 Subject: capture rendered HTML to an image
 
 Hi all,
  I'm looking for an approach that's not too complex to implement to capture
 rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for
 templates in an automated fashion.
  Using cfdocument and outputting to a jpeg would be perfect, but cfdocument
 only outputs to PDF and FlashPaper :-(
  Any suggestions would be welcome!
  thanks
 Nando
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223712
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Tools to convert old Ami Pro v3 documents?

2005-11-09 Thread Jim Davis
 -Original Message-
 From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 09, 2005 11:38 AM
 To: CF-Talk
 Subject: OT: Tools to convert old Ami Pro v3 documents?
 
 Sorry for the slightly off-topic post, but I've got a client who's trying
 to
 convert a bunch of old Ami Pro v3 documents to Word (or at least some
 other
 modern day format.)
 
 Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer
 runs under the new operating systems.
 
 While Word does have an Ami Pro filter, it seems to only work with
 documents
 that contain only text. Most of these documents contained graphics and
 layouts drawn with the Ami Pro toolset. All of these documents come up
 blank.
 
 Does anyone know of a tool that will accurately convert Ami Pro documents?

There's a tool called Conversions Plus that did this kind of thing... not
sure if it's any better than the one you're using but it might help.

http://www.dataviz.com/products/conversionsplus/

Jim Davis




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223713
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: what do you use instead of cfx_openimage?

2005-11-09 Thread cftalk
I got the price wrong in this message last Friday.

The personal version is $49 not $75.

-- 
 CrystalM

 Many people use our tag, cfx_imagecr3.
 Some hosts install it on all their servers.
 
   Efflare ImageCR 3
   http://efflare.com/products/cfx_imagecr
 
   $75 personal license
   http://efflare.com/purchase?personal
 
 -- 
  CrystalM
 
  is nobody using cfx_openimage? is there another similar good tool (for
  easy setupuse in shared hosting environment)
  
  I wanna resize images and read image dimensions..
  
  what are you using?
  
  --
  Sebastian Mork
  [EMAIL PROTECTED]
  --
  
  On Thu, 03 Nov 2005 17:32:55 +0100
  Sebastian Mork [EMAIL PROTECTED] wrote:
  
   Hi,
   
   in my app I use cfx_openimage  (in a shared hosting environment running
   win(nt?), cfmx7.0).
   I used the tag for months for reading images to get infos about the
   dimension without poblems.
   suddenly, two days ago a user told me he gets an error viewing some
   other user profiles.
   hmm, thats strange, from one day to another the cfx_tag produces an
   error, the html-title says 'jrun servlet error' and '500 null' is shown.
   
   the hosting-comp. said thay didn't change anything. and I did not change
   anything in the code, too.
   they restarted cfmx and the whole server without success.
   and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't
   delete that dir and the installation of that tag is made in the
   default-directory..
   so what??
   I've created a test-page with the following code, its just an example,
   that code worked fine in my app:
   
   #filename# is: 
   D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg
   code: 
   CFX_OPENIMAGE 
 ACTION=IML 
 FILE=#filename# 
 COMMANDS=getsize
   heres the test-page: http://friendcom.de/sc/views/test.cfm
   
   any ideas?
   
   thx
   
   -- 
   Sebastian Mork [EMAIL PROTECTED]
   
   
   
  
  
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223714
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: removing trailing comma in CSV row

2005-11-09 Thread ColdFusion Developer
What you can do rather than trying to delete the
Last comma is simple:

In your CFLOOP, change your #score#, line to:

cfoutput#score#CFIF I NEQ get_result.recordcount,/CFIF/cfoutput 

This way when you loop over the items and reached the
Last one, it will NOT put the comma into the CSV file.



-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 1:43 PM
To: CF-Talk
Subject: removing trailing comma in CSV row

I am trying to build lines of CSV data. However, I don't know exactly how to
get rid of the LAST comma in the line.

 

Here is the result:

 

42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
(note trailing comma)

 

Here is the code (ugly as it may be):

 

cfquery .

select spdinput_id, location,score from spdout  

group by spdinput_id, location, score

order by spdinput_id, location

/cfquery

 

 cfloop from=1 to=#get_result.recordcount# index=i step=1

 

 cfoutput query=get_result group=spdinput_id

  #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput

 

 /cfloop

 

Any ideas appreciated.

 

Rick.





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223715
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: removing trailing comma in CSV row

2005-11-09 Thread Charlie Griefer
i'd still vote for listAppend(), since that's effectively what you're doing.

set an empty variable, and then rather than outputting it with a
literal comma following it, call a listAppend() function.


On 11/9/05, ColdFusion Developer [EMAIL PROTECTED] wrote:
 What you can do rather than trying to delete the
 Last comma is simple:

 In your CFLOOP, change your #score#, line to:

 cfoutput#score#CFIF I NEQ get_result.recordcount,/CFIF/cfoutput

 This way when you loop over the items and reached the
 Last one, it will NOT put the comma into the CSV file.



 -Original Message-
 From: Richard Colman [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 09, 2005 1:43 PM
 To: CF-Talk
 Subject: removing trailing comma in CSV row

 I am trying to build lines of CSV data. However, I don't know exactly how to
 get rid of the LAST comma in the line.



 Here is the result:



 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
 (note trailing comma)



 Here is the code (ugly as it may be):



 cfquery .

 select spdinput_id, location,score from spdout

 group by spdinput_id, location, score

 order by spdinput_id, location

 /cfquery



  cfloop from=1 to=#get_result.recordcount# index=i step=1



  cfoutput query=get_result group=spdinput_id

   #spdinput_id#,

  cfoutput#score#,/cfoutput

  p

  /cfoutput



  /cfloop



 Any ideas appreciated.



 Rick.





 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223716
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfinclude from a template, or onRequestStart?

2005-11-09 Thread Matthew Walker
 I don't see why you couldn't or wouldn't

Well you certainly could, although I wouldn't. It is the kind of thing
that may not be a problem now but could be a hassle later. As you
describe in your first paragraph below, it's a hassle when suddenly you
*don't* want that template wrapped around your content for a new page. I
would generally only put things I *always* wanted in
application.cfc/cfm. I couldn't guarantee that anything I was displaying
would be *always* wanted, as I may want a different template for a popup
page, or I may be delivering a different type of content such as XML. 


-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 11:47 p.m.
To: CF-Talk
Subject: RE: cfinclude from a template, or onRequestStart?

He's not saying to but the actual html in the app.cfc file he's saying
put the include. And I don't see why you couldn't or wouldn't. I'm doing
it on a current site and other than a few hair pulls it works great. The
main problem is that if you have a page you don't want it on then you
got a problem. I have heard a few ppl say it's not a good idea but they
dont explain why not?

here's a quote out of one of the 2 tuts I have read on application.cfc

 onRequestEnd 

This function is called at the end of a page request after all other
ColdFusion code has executed. If you have application specific logic
that should only be run at the end of your page, this is the place to
put it. The following example simply outputs a footer by including the
footer.cfm file:  cffunction name=onRequestEnd output=Yes
returntype=void
   cfargument name=targetPage type=String required=Yes /
   cfinclude template=footer.cfm /
 /cffunction 

So when when ppl say its bad then WHY is it bad, it seems to run just as
good as any other method.

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense
wisdom and abuse at the same time. 


From: Matthew Walker [EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 9:12 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: cfinclude from a template, or onRequestStart? 

Personally, I wouldn't put any display elements in application.cfc but
rather use it for app setup purposes (defining global variables,
initialising shopping carts, etc). If you wanted to have a different
page template on a page it might be a big hassle -- or one day you may
want a page that delivers RSS or CSV or something else. Depending on the
way your site is structured, you may find custom tag pairs are a nice
way of wrapping templates around your pages


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223717
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: removing trailing comma in CSV row

2005-11-09 Thread Andy Matthews
cfoutput query=get_result group=spdinput_id
#spdinput_id#,
cfoutput#score#cfif currentrow LT recordcount,/cfoutput
p
/cfoutput

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 12:42 PM
To: CF-Talk
Subject: removing trailing comma in CSV row


I am trying to build lines of CSV data. However, I don't know exactly how to
get rid of the LAST comma in the line.



Here is the result:



42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
(note trailing comma)



Here is the code (ugly as it may be):



cfquery .

select spdinput_id, location,score from spdout

group by spdinput_id, location, score

order by spdinput_id, location

/cfquery



 cfloop from=1 to=#get_result.recordcount# index=i step=1



 cfoutput query=get_result group=spdinput_id

  #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput



 /cfloop



Any ideas appreciated.



Rick.







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223718
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: removing trailing comma in CSV row

2005-11-09 Thread John Paul Ashenfelter
How about just using one of the queryToCSV functions from CFlib

http://www.cflib.org/udf.cfm?ID=556
http://www.cflib.org/udf.cfm?ID=1197

so you don't have to reinvent the wheel :)

On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote:
 I am trying to build lines of CSV data. However, I don't know exactly how to
 get rid of the LAST comma in the line.



 Here is the result:


 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
 (note trailing comma)

 Here is the code (ugly as it may be):

 cfquery .
 select spdinput_id, location,score from spdout
 group by spdinput_id, location, score
 order by spdinput_id, location
 /cfquery


 Any ideas appreciated.



 Rick.



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223719
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: removing trailing comma in CSV row

2005-11-09 Thread Andy Matthews
Ooops...

Forgot my closing /cfif. Change this line:
cfoutput#score#cfif currentrow LT recordcount,/cfoutput

to this line:
cfoutput#score#cfif currentrow LT recordcount,/cfif/cfoutput

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 1:48 PM
To: CF-Talk
Subject: RE: removing trailing comma in CSV row


cfoutput query=get_result group=spdinput_id
#spdinput_id#,
cfoutput#score#cfif currentrow LT recordcount,/cfoutput
p
/cfoutput

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 12:42 PM
To: CF-Talk
Subject: removing trailing comma in CSV row


I am trying to build lines of CSV data. However, I don't know exactly how to
get rid of the LAST comma in the line.



Here is the result:



42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6,
(note trailing comma)



Here is the code (ugly as it may be):



cfquery .

select spdinput_id, location,score from spdout

group by spdinput_id, location, score

order by spdinput_id, location

/cfquery



 cfloop from=1 to=#get_result.recordcount# index=i step=1



 cfoutput query=get_result group=spdinput_id

  #spdinput_id#,

 cfoutput#score#,/cfoutput

 p

 /cfoutput



 /cfloop



Any ideas appreciated.



Rick.









~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223720
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: removing trailing comma in CSV row

2005-11-09 Thread Sean Corfield
On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote:
 I am trying to build lines of CSV data. However, I don't know exactly how to
 get rid of the LAST comma in the line.

There's an easy solution that involves thinking differently about the
list you're outputting:

Instead of worrying about removing the *last* comma, consider a list
with the *first* comma removed.

In other words, think about ,a,b,c with the leading comma removed
instead of a,b,c, with the trailing comma removed.

That's easy to do:

cfloop from=1 to=#get_result.recordcount# index=i step=1
cfoutput query=get_result group=spdinput_id
#spdinput_id#
cfoutput,#score#/cfoutput
p
/cfoutput
/cfloop

(same as your code but no comma after spdinput_id - it's before score instead)
--
Sean A Corfield -- http://corfield.org/
Got frameworks?

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223721
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Fist try at an async gateway

2005-11-09 Thread Ian Skinner
I've created an async gateway that is supposed to do some processing that may 
take a few seconds and send out an e-mail with the results.  My hope of using 
an async gateway was that I could fire off several requests that each would 
process there data and return a result.  The problem I'm having is that the 
gateway is being processed in serial rather then parallel.  

Is this the correct behavior?  I don't get async gateways working at the same 
time, as much as a windows 2000 server can multi-task.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223722
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Server Processes

2005-11-09 Thread Aldon Moore
I have a site thats eating up server processes! Any idea on what coul be
causing this???



Aldon


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223723
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


ColdFusion MX CFLDAP NullPointerException bug

2005-11-09 Thread wolf2k5
Hi all,

I hit the CLDAP NullPointerException bug with ColdFusion MX 6.1 (with Updater):

http://www.sargeway.com/blog/index.cfm?mode=entryentry=36
http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:10/threadid:1283

I am running ColdFusion for J2EE with JVM 1.4.2_09 and I cannot revert
to an older JVM, since I am not the one in charge for the system.

Apparently Macromedia never released an hotfix for the bug.
Do you have any info about it?

Is there any workaround for the issue?

Thanks a lot.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223724
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fist try at an async gateway

2005-11-09 Thread Michael Dinowitz
I'd look at the code to see if there's something in it causing it to operate 
in serial. I've got a number of parallel processes going and they have no 
contact with each other at all. If you have a lock, a cftransaction or 
anything else which can stop the parallel processing of your code, you'll 
get a serial like result.


 I've created an async gateway that is supposed to do some processing that 
 may take a few seconds and send out an e-mail with the results.  My hope 
 of using an async gateway was that I could fire off several requests that 
 each would process there data and return a result.  The problem I'm having 
 is that the gateway is being processed in serial rather then parallel.

 Is this the correct behavior?  I don't get async gateways working at the 
 same time, as much as a windows 2000 server can multi-task.

 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223725
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ColdFusion MX CFLDAP NullPointerException bug

2005-11-09 Thread Douglas Knudsen
there were issues with CFLDAP and JVM versions.  For certain, CFLDAP
does not work with 1.4.2_07.look like not _09 either.

workaround?  write your LDAP call in Java...a bit of work but not too
terribly difficult.

DK

On 11/9/05, wolf2k5 [EMAIL PROTECTED] wrote:
 Hi all,

 I hit the CLDAP NullPointerException bug with ColdFusion MX 6.1 (with 
 Updater):

 http://www.sargeway.com/blog/index.cfm?mode=entryentry=36
 http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:10/threadid:1283

 I am running ColdFusion for J2EE with JVM 1.4.2_09 and I cannot revert
 to an older JVM, since I am not the one in charge for the system.

 Apparently Macromedia never released an hotfix for the bug.
 Do you have any info about it?

 Is there any workaround for the issue?

 Thanks a lot.

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223726
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Email a pdf as attachment at regular interval

2005-11-09 Thread Claremont, Timothy
I have a cfr report (pdf is the result) that I would like to
automatically generate and email once per month to two people. How do I
attach the pdf as an attachment? Do I need to generate the pdf and save
it as a file and then attach it as an email, or can I generate and email
at the same time?

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223727
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


project progression holding up other projects

2005-11-09 Thread Duncan
I have a bit of a problem with a team of developers. Its a new company and
somewhat of a new problem. We use VSS to do the basic functions of checking
out files, and developers keep them checked out until the file and changes
in question are in production.

This has obvious problems - if another project comes along and has to also
change that particular template then it cant progress any faster through the
SDLC than the project that got there first.

Anyone have any answers to this problem?

--
Duncan I Loxton
www.sixfive.co.uk http://www.sixfive.co.uk
[EMAIL PROTECTED]

I can only please one person per day. Today is not looking good. Tomorrow
isn't looking much better. Dilbert


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223728
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ColdFusion MX CFLDAP NullPointerException bug

2005-11-09 Thread Aaron Rouse
I would not mind seeing an example of that. We have certainy had our fair
share of LDAP issues since upgrading to 6.1 from 5.0

On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote:

 workaround? write your LDAP call in Java...a bit of work but not too
 terribly difficult.

 DK




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223729
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Embedding Password question...

2005-11-09 Thread Charles E. Heizer
Hello,
I have a concern about embedding a password in my site. I have a site  
which uses two LDAP accounts for displying and editing the site  
contents which are stored in LDAP.

So my issue is that I'm storing a password in one of my cfc files  
which is using an account(Service Type Account) and I'm affraid if  
someone gets a hold of this cfc file they now have the account name  
and password to my LDAP directory.

Can someone please suggest a better way to store the password for the  
site.

Thanks,
- Charles

PS: This a is a short term need, I'm going to do a re-write to  
leverage the LDAP directory and the assigned privileges in the  
directory to control this but for the next few months I have to live  
with this.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223730
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Email a pdf as attachment at regular interval

2005-11-09 Thread Bryan Stevenson
1) scheduled task to run the file that send the mail every hour

2) yes generate and save the PDF before mailing

3) attach using the family of cfmail tags (it's all in the help files)

HTH

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223731
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Email a pdf as attachment at regular interval

2005-11-09 Thread Tim Claremont
Do I have to manually run the CFR page and do a file/save as from the resultant 
PDF, or can I automate that part of the process as well so there is no user 
intervention required in the process?

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223732
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Difficult Sort - Theory

2005-11-09 Thread John C. Bland II
I forgot this is MySQL. My bad...

On 11/9/05, Les Mizzell [EMAIL PROTECTED] wrote:

  MySQL doens't have view support until 5.0, and that's only been out
  for a few weeks,

 Once I saw the data I had to work with, and the 3857 different ways the
 client wanted to search/sort, I was aching to be able to use views!
 Certainly would have simplified the process!

 --
 ---
 Les Mizzell

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223733
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: project progression holding up other projects

2005-11-09 Thread Robert Munn
Multiple checkout. Different systems deal with it different ways. VSS sipmly 
allows multiple checkout, which means that if I have a file checked out you can 
come along and check it out as well, and any conflicts have to be resolved 
before check-in.

I'm at a new job where we use Perforce, and it deals with this concept in a 
more robust way. It supports the notion of branching, so for each project, you 
build a new branch, then you re-integrate your changes from the project branch 
back into the main branch when you finish your work. You can have multiple 
concurrent branches from the mainline, but you still have to resolve any 
conflicts that come up during re-integration (check-in, in VSS speak).

I have a bit of a problem with a team of developers. Its a new company and
somewhat of a new problem. We use VSS to do the basic functions of checking
out files, and developers keep them checked out until the file and changes
in question are in production.

This has obvious problems - if another project comes along and has to also
change that particular template then it cant progress any faster through the
SDLC than the project that got there first.

Anyone have any answers to this problem?

--
Duncan I Loxton
www.sixfive.co.uk http://www.sixfive.co.uk
[EMAIL PROTECTED]

I can only please one person per day. Today is not looking good. Tomorrow
isn't looking much better. Dilbert

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223734
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: qForm issue

2005-11-09 Thread Claude Schneegans
 document.getElementById(id).style.display = table-row;

Hmmm, the display argument in a style should be one of  inline block 
or none I think.
I get the same error message with wrong values for display.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223735
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Fist try at an async gateway

2005-11-09 Thread Ian Skinner
I'd look at the code to see if there's something in it causing it to operate 
in serial. I've got a number of parallel processes going and they have no 
contact with each other at all. If you have a lock, a cftransaction or 
anything else which can stop the parallel processing of your code, you'll 
get a serial like result.


That was a thought, I am calling a cfx tag that I'm told is multi-threadable, 
but I didn't actually write it so who knows.  To test this, I simplified my 
async function so that it just counts ticks for 5 seconds and then finishes.  
This still seems to be serially processing.  Does it matter how I call the 
async function?

I'm using this example code to test my concepts.  Does it matter that I'm 
calling the same async gateway from the same cfm template over and over that 
would case the cfc to be serially run?

cfloop query=allSTEmails
pSending an event to the CFML event gateway that is registered in the 
   ColdFusion MX Administrator as BSMailBlaster.p
cfscript
   status = false;
 
   props = structNew();
   props.email = allSTEmails.email;   
 props.ID = allSTEmails.N_PER_ID;
 
   status = SendGatewayMessage(BSMailBlaster, props);
 
   if (status IS True) WriteOutput('p#currentRow#: Event Message 
#props.email# has been sent./p');
 else WriteOutput('p#currentRow#: Event Message #props.email# has 
NOT been sent./p');
/cfscript
/cfloop

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223736
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: reload Java classes

2005-11-09 Thread Jeff S
Gah! And a thousand coises!

Thanks,
George

On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote:


This topic seems to come up often with no solution that I've seen.  I have the 
same situation and spent quite a bit of time reading articles written by people 
that claim it's possible in MX, as well as reading the JRun and CF 
documentation with none of the proposed solutions working for me.

Finally after sending emails to several article authors (with no responses) I 
read this 
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1561.htm
 
and moved on without hope of finding an answer unless one of the authors 
responds to me.

To get around the problem for now, I just create a main method that runs the 
class files and run them on a command line.  This has gotten be through 90% of 
the development process of all the stuff I've created.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223737
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Embedding Password question...

2005-11-09 Thread Alan Rother
We had a similar concern sometime back, we solved it by placing the user
name and password in an ini file that required high level permissions to
access. We then read the ini file on the applicationStart and store the
value in application memory. You can further complicate this by encrypting
the user name and password.
 HTH

--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223738
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fist try at an async gateway

2005-11-09 Thread Michael Dinowitz
Have you tried it without waiting for a status result? Also, the question 
has to do with the code within the async process, not the code calling it. 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223739
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server Processes

2005-11-09 Thread Michael Dinowitz
long running code? Have you turned on logging for long templates and checked 
the logs for timeouts, errors or excessive wait times?


I have a site thats eating up server processes! Any idea on what coul be
 causing this???



 Aldon


 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223740
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Query of Queries Subquery

2005-11-09 Thread Lee
I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.

cfquery name=OOrder datasource=database dbtype=ODBC 

SELECTZip
FROM UPS
/cfquery


cfquery name=Minneapolis  dbtype=Query 
SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)
/cfquery

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223741
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Open source shopping cart

2005-11-09 Thread Snake
OK a change to my last post.

I have now created a new Open Projects category in the forums, and the
shopping cart forum is now in here.
For those that want to be involved, please come and register at
www.cfdeveloper.co.uk and post in the main cf_shoppingcart, and we will get
things moving.


--
Russ



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223742
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query of Queries Subquery

2005-11-09 Thread Barney Boisvert
QofQ doesn't support subqueries.

cheers,
barneyb

On 11/9/05, Lee [EMAIL PROTECTED] wrote:
 I'm having trouble doing a subquery using a query of
 queries. Is this even possible or am I doing something
 wrong. I have the simplified code below. Thanks.

 cfquery name=OOrder datasource=database dbtype=ODBC
 
 SELECTZip
 FROM UPS
 /cfquery


 cfquery name=Minneapolis  dbtype=Query 
 SELECT*
 FROM  OOrder
 Where zip IN (Select Zip from cstSpecialZip)
 /cfquery


--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223743
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: preventing multiple form submissions

2005-11-09 Thread Bobby Hartsfield
Store the cgi.remoate_addr and the current date/time in a database. It
should be easy to go from there. If you don’t want to do that... you can try
something like this...
 
http://acoderslife.com/downloads/bhcaptcha/

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Ron Gowen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 08, 2005 12:47 PM
To: CF-Talk
Subject: Re: preventing multiple form submissions

captcha may be an option, though probably not the best for a search feature:
 http://www.alagad.com/

 On 11/8/05, Protoculture [EMAIL PROTECTED] wrote:

 we would like to limit the amount of times a user may search/ie use our
 search facility as we think that we may be under some kind of script
attack
 at the moment.

 What would be some solutions to prevent a certain number of form
 submissions from taking place in a given period of time?

 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/164 - Release Date: 11/9/2005
 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223744
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query of Queries Subquery

2005-11-09 Thread Adrian Lynch
You can't do sub queries in Q of Q.

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery


I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.

cfquery name=OOrder datasource=database dbtype=ODBC 

SELECTZip
FROM UPS
/cfquery


cfquery name=Minneapolis  dbtype=Query 
SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)
/cfquery

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223745
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query of Queries Subquery

2005-11-09 Thread Bobby Hartsfield
Sad but true... You'll have to run a third QoQ to filter it.
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 5:23 PM
To: CF-Talk
Subject: RE: Query of Queries Subquery

You can't do sub queries in Q of Q.

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery


I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.

cfquery name=OOrder datasource=database dbtype=ODBC 

SELECTZip
FROM UPS
/cfquery


cfquery name=Minneapolis  dbtype=Query 
SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)
/cfquery



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223746
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query of Queries Subquery

2005-11-09 Thread Adrian Lynch
Or, just had a thought, make the the sub query dynamic

cfquery name=OOrder datasource=database
SELECT Zip
FROM UPS
/cfquery

cfquery name=Minneapolis dbtype=Query
SELECT*
FROM  OOrder
Where zip IN (#ValueList(OOrder.Zip)#)
/cfquery

You might want to allow for no records though.

Ade

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:28
To: CF-Talk
Subject: RE: Query of Queries Subquery


Sad but true... You'll have to run a third QoQ to filter it.
 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 5:23 PM
To: CF-Talk
Subject: RE: Query of Queries Subquery

You can't do sub queries in Q of Q.

Ade

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery


I'm having trouble doing a subquery using a query of 
queries. Is this even possible or am I doing something 
wrong. I have the simplified code below. Thanks.

cfquery name=OOrder datasource=database dbtype=ODBC 

SELECTZip
FROM UPS
/cfquery


cfquery name=Minneapolis  dbtype=Query 
SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip)
/cfquery

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223747
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query of Queries Subquery

2005-11-09 Thread Matthew Walker
Is cstSpecialZip another query record set? How about...

cfquery name=Minneapolis  dbtype=Query 
  SELECT*
  FROM  OOrder
  Where zip IN (cfqueryparam
value=0#valueList(cstSpecialZip.zip)# cfsqltype=CF_SQL_INTEGER
list=Yes)
/cfquery

In case you're wondering, the 0 will catch empty record set cases (I'm
assuming zip is an integer field). 

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 10 November 2005 11:31 a.m.
To: CF-Talk
Subject: Query of Queries Subquery

I'm having trouble doing a subquery using a query of queries. Is this
even possible or am I doing something wrong. I have the simplified code
below. Thanks.

cfquery name=OOrder datasource=database dbtype=ODBC 

SELECTZip
FROM UPS
/cfquery


cfquery name=Minneapolis  dbtype=Query 
SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip) /cfquery



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223748
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fist try at an async gateway

2005-11-09 Thread Sean Corfield
Is this on CF Enterprise or on CF Developer?

The async g/w on Developer only processes one request at a time hence
it would appear to be serial execution.

On 11/9/05, Ian Skinner [EMAIL PROTECTED] wrote:
 I've created an async gateway that is supposed to do some processing that may 
 take a few seconds and send out an e-mail with the results.  My hope of using 
 an async gateway was that I could fire off several requests that each would 
 process there data and return a result.  The problem I'm having is that the 
 gateway is being processed in serial rather then parallel.

 Is this the correct behavior?  I don't get async gateways working at the same 
 time, as much as a windows 2000 server can multi-task.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223749
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Embedding Password question...

2005-11-09 Thread Charles E. Heizer
Thanks! I was afraid that was what I was going to need to do.

- Charles

On Nov 9, 2005, at 1:55 PM, Alan Rother wrote:

 We had a similar concern sometime back, we solved it by placing the  
 user
 name and password in an ini file that required high level  
 permissions to
 access. We then read the ini file on the applicationStart and store  
 the
 value in application memory. You can further complicate this by  
 encrypting
 the user name and password.
  HTH

 --
 Alan Rother
 Macromedia Certified Advanced ColdFusion MX 7 Developer


 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223750
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Embedding Password question...

2005-11-09 Thread Dawson, Michael
I just entered a feature enhancement for this.  (I have been sitting on
this task for too long and, when I saw your thread, I thought it was
finally time.)

Similar to storing CFQUERY datasource connections in the ColdFusion
Administrator, I would like the ability to store usernames/passwords for
CFLDAP and CFFTP, etc in the CF Administrator.

The main purpose is to keep usernames and passwords away from
developers.  Sometimes, when using CFLDAP, you must specify a domain
administrator account to perform certain functions.

I would prefer these passwords to now always appear, in plain text, in
any pages that use CFLDAP/CFFTP.

You might add your own to increase the importance of this feature.

M!ke 

-Original Message-
From: Charles E. Heizer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 2:57 PM
To: CF-Talk
Subject: Embedding Password question...

Hello,
I have a concern about embedding a password in my site. I have a site
which uses two LDAP accounts for displying and editing the site contents
which are stored in LDAP.

So my issue is that I'm storing a password in one of my cfc files which
is using an account(Service Type Account) and I'm affraid if someone
gets a hold of this cfc file they now have the account name and password
to my LDAP directory.

Can someone please suggest a better way to store the password for the
site.

Thanks,
- Charles

PS: This a is a short term need, I'm going to do a re-write to leverage
the LDAP directory and the assigned privileges in the directory to
control this but for the next few months I have to live with this.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223751
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Embedding Password question...

2005-11-09 Thread James Holmes
When sharing hosting on a less-than-secure server, I enhanced the
security of the passwords in my source code by writing simple java
classes that return the password hardcoded within. The classes were
written so that they would only run in code calling them from the
correct directory on the server (i.e. if someone else tried to run the
class it returned nothing) and this was independent of CF sandboxing.
I loaded the classes dynamically, so they were never in the CF
classpath.

It isn't perfect, since decompiling the class would get the password,
but if someone is in a position to do that then they can also
decompile CF and get the encryption/decryption keys for datasource
passwords (and compromise the enhancement that has been talked about
in this thread too).

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223752
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


re: Open source shopping cart

2005-11-09 Thread dave
I'm on board and hopefully some of these ppl will get off their collective 
butts and chip in this time.
Shouldn't take long if everyone takes a task and just gets it done.
Would be cool if we did a new project every month and would help out the 
community a lot.
Now if we can only get ppl to follow through with their words.
I guess we'll find out who the true cfm lovers are ;)~
And being too busy isnt an excuse, im as busy as anyone and if i can find 
time so can y'all!
So let's GET 'R' DONE this time!
I have web space too if needed.

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time. 


From: Snake [EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 5:20 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Open source shopping cart 

OK a change to my last post.

I have now created a new Open Projects category in the forums, and the
shopping cart forum is now in here.
For those that want to be involved, please come and register at
www.cfdeveloper.co.uk and post in the main cf_shoppingcart, and we will get
things moving.

--
Russ



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223753
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >