WAR File Deployment

2006-04-11 Thread Jonathon Parker
I am running CFusionMX 6.1 and need to deploy a WAR file.  I can find no
option for that under CFIDE.  I tried to manually deploy it by creating a
webapps directory and putting the WAR file there, but that didn't work
either.  I would greatly appreciate some advice.
 
Jonathon


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237407
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


maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
I'm creating a database for a store. It will probably have several
thousand items (but will probably never come close to 10,000).
 
The pictures of the items will be stored in a file directory (not as a
blob in a database). What is the maximum amount of files that can be
stored in a directory and still have an efficient response time. 
 
Each item will have at least two graphics if not three or four
 
#itemID#-th
#itemID#
 
It is quite possible that there could be 15-20,000 images in this
directory. Is that too many?
 
The alternative is to store the graphics according to designer
 
/graphics/items/#designerName# / #itemID#.jpg
 
or maybe categories (dresses, denim, jewelry) (the advantage of this
would be fewer directories than designers)
 
/graphics/items/#categories# / #itemID#.jpg
 
It would be so much simpler to have all the graphics in one directory.
Will I be causing problems later on by doing that?
 
 
Gilbert Midonnet
718.928.4524
www.glmdesigns.com
 
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237408
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: maximum number of files in directory

2006-04-11 Thread Thomas Chiverton
On Tuesday 11 April 2006 13:42, Gilbert Midonnet wrote:
 It is quite possible that there could be 15-20,000 images in this
 directory. Is that too many?

I would say so.

You may want to break it down into subdirs by initial character, 2nd 
character, and then the file or something.
That is how high performance applications like Squid work anyway.

You other schemes should work too.

 simpler to have all the graphics in one directory

Only from the point of view of the single well-defined CFC encapsulating the 
getFilePathForItem() function, so not too much bother :-)

-- 

Tom Chiverton 
Advanced ColdFusion Programmer

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237409
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: VHS and Betamax

2006-04-11 Thread Denny Valliant
 The comment I forgot to make in that post was that really I think the
 trick is to find handfull of technologies you like that are on the
 up-swing (since they all rise and fall) and stick with them as long as
 you can. This should make it easier to add other complementary skills
 as the demand for them increases and mitigate the risks involved in
 devaluation of any individual skill as a result of increased supply or
 waning demand. As an individual I'm personally probably more invested
 in ColdFusion than anything else, potentially over-invested actually.


Ok. But your heavy involvement in CF perpetuates it as well.

 I guess we shouldn't be to reliant on computers,
  neh? (-:

 My opinions on that subject tend to be pretty unpopular. :)


Swinging  to what side? More so or less?

 I still put forth that generated code is generated code,
  why shy away from generated code? So long as it's well
  formatted (don't look at me, you saw my regex ;) you
  should be ok, I recon.

 It's a question of who's generating it and why. :)

 To me the fact that my coldfusion templates or CFC's are generated
 Java is transparent. I know it's there, but I don't have to care too
 much about what's being generated, beyond knowing that it is generated
 and having some understanding of the problems that can be caused by
 that.


Well, maybe if the optimization is as swell as it's said to be.  I can't
help but feel that even as smart as computers are, there are areas
that a human could see a pattern before the computer could. Or
whatever. Guess the argument about optimization has some validity,
yet I can't help see history repeat itself. Every few years there's this
idea that it doesn't matter, we're getting bigger, faster processors,
more RAM, etc.. Yet the real idea is to conserve energy. Sorta.
I guess make less go further.  That's never going to change, no matter
how much power there is. It's the nature of power - corruption and
responsibility aside.

You may have seen this, but I liked it alot:
http://www.joelonsoftware.com/articles/fog000319.html

well be. Thus a sweeping change would need to occur in each bean or
 require a change to the generator and a re-build of its generated
 code. I personally find it easier to simply create objects which are
 flexible enough to not require generation and use composition or
 inheritance to allow me to make sweeping changes. The sweeping change
 then is a line or two of code, instead of a larger modification to the
 generator and a rebuild.


So what, you use the root java object? ;-) Seriously, you have to store
the information somewhere -  I don't know of any ESP generated code.

I get what you're saying tho (as much as I'm able. Concepts!=use).
I really dig the ideas encapsulated in The Pragmatic Programmer.

Good stuff, doesn't matter what language. All old-hat for most I'm sure,
but I'd sorta been through the bad that knowledge helps avoid, and
I liked the analogies/stories.  Nice having it all in that format.

 But that's coming from someone who, using line breaks and
  MS Word, smashed several hundred pages of mish-mash into
  a C^HSV. They weren't commas, so I deleted the C, see?
  :P  It would be a dream to get a bunch of pragmatically
  generated documents compared to that.  Programs you can
  reverse engineer, whatnot. People are so random, sorta.
  [...]

 Ya lost me. :)


Sorta saying it's all data, but some data is much easier to parse
than other data is. By much I mean astronomically.

 Or it is, but that whole butterfly in Tibet or
  whatever, ya know? The right thing at the right
  time, and bang, you're father of some type of
  legacy. And conversely, some other legacy never
  occurs.

 I'm familar with the concept of the butterfly effect, although I'm
 not certain what connection you were trying to make.


I guess...  that there is an element of randomness in evolution.
Yet at the same time I'm saying we have a stake in our destiny,
so... bleh. doesn't make sense 'cept generally. if then. :)

In practice the cf-community list mostly talks about politics.


This more fun. If it bugs anyone, I'll try to keep it more CF
centric.
:D


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237410
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: selling my private (multi-language) spare time-/event-community for german-language countries (cfmx7,mach-II,rich forms)

2006-04-11 Thread Sebastian Mork
Hi,

Sorry,I know its OT, but maybe someone may be interested.. although its
actually for users from germany, austria and switzerland :)

Im selling my private Online-Community, its a spare time/
event-community with contact-lists, contacts of contacts, events, a
postbox for communication, user-profiles...

It currently supports two languages, german and english, users from
germany, austria and switzerland can register and have to select their
state they come from. (So people can search for users/events in their
region..)

Here's the URL:
http://cgi.ebay.de/ws/eBayISAPI.dll?ViewItemitem=8794405726

The description of this auction is in german.. Well, I know this is an
english list, but I thought there a so many users who use this list, so
maybe there's somebody who may be interested.

I developed this project with cfmx7 (OO), used the mach-II-framework and
flash-forms insted of standard-forms (+mysql). There are several
service-layers (for remote-access to some functions), gateways, daos,
session-facades...

I try to sell it because I don't have the time and money to publish it
in a professional way :)

Regards
Sebastian Mork
-- 
Sebastian Mork [EMAIL PROTECTED]


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237411
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: WAR File Deployment

2006-04-11 Thread Denny Valliant
Use the JRun administrator.  There is a good how-to about clusters and
6.1that explains doing it for CF, but it's similar for other apps.

On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:

 I am running CFusionMX 6.1 and need to deploy a WAR file.  I can find no
 option for that under CFIDE.  I tried to manually deploy it by creating a
 webapps directory and putting the WAR file there, but that didn't work
 either.  I would greatly appreciate some advice.

 Jonathon


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237412
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: ANNOUNCE: CFMBB Forums resurrected

2006-04-11 Thread Rick Root
Andrew Grosset wrote:
 Rick, I tried to register (http://www.cfmbb.org/forums.cfm) and got this 
 error:

thanks andrew, I saw your bug report and just fixed it and released 0.81

I also added postgresql support and numerous other changes to 0.81 ... 
like I changed all the tinyint and bit datatypes to smallint for cross 
database compatibility... and I changed the column name group to 
groupName since group is a reserved word in pretty much every database.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237413
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: maximum number of files in directory

2006-04-11 Thread Claude Schneegans
 or maybe categories (dresses, denim, jewelry) (the advantage of this
would be fewer directories than designers)

You could also use some better balanced subdivision.
For instance, if you have some numerical Id nb, use the three last 
digits as the file name,
and the rest for the directory.
This way, when the directory has 1000 files, a new one is created, etc.

Use something that cannot be changed in your database, so that you do 
not have to move
the files when data is changed. Category would not be a good choice, 
since someone may
choose the wrong category first, then update the product.

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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237414
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: WAR File Deployment

2006-04-11 Thread Douglas Knudsen
try dropping the WAR under servers/cfusion-ear

DK

On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:
 I am running CFusionMX 6.1 and need to deploy a WAR file.  I can find no
 option for that under CFIDE.  I tried to manually deploy it by creating a
 webapps directory and putting the WAR file there, but that didn't work
 either.  I would greatly appreciate some advice.

 Jonathon


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237415
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: WAR File Deployment

2006-04-11 Thread Jonathon Parker
try dropping the WAR under servers/cfusion-ear

DK

On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:


Thanks for responding, but I don't have a JRun administrator and can't find a 
folder named servers/cfusion-ear.  I am running CFusion on IIS.  Is that 
significant?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237416
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: WAR File Deployment

2006-04-11 Thread Munson, Jacob
 Thanks for responding, but I don't have a JRun administrator 
 and can't find a folder named servers/cfusion-ear.  I am 
 running CFusion on IIS.  Is that significant?

You will see the servers/cfusion-ear directory only if you did the
multi-server j2ee install option (or something like that, can't remember
the exact wording).  On my computer it's here:
/jrun4/servers/cfusion-ear


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237417
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: maximum number of files in directory

2006-04-11 Thread Shepherd, Brandon
I have also seen that if clusters on the hard drive go bad that affect
the folder.  All images in that folder are now inaccessible.

-B

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 5:42 AM
To: CF-Talk
Subject: maximum number of files in directory

I'm creating a database for a store. It will probably have several
thousand items (but will probably never come close to 10,000).
 
The pictures of the items will be stored in a file directory (not as a
blob in a database). What is the maximum amount of files that can be
stored in a directory and still have an efficient response time. 
 
Each item will have at least two graphics if not three or four
 
#itemID#-th
#itemID#
 
It is quite possible that there could be 15-20,000 images in this
directory. Is that too many?
 
The alternative is to store the graphics according to designer
 
/graphics/items/#designerName# / #itemID#.jpg
 
or maybe categories (dresses, denim, jewelry) (the advantage of this
would be fewer directories than designers)
 
/graphics/items/#categories# / #itemID#.jpg
 
It would be so much simpler to have all the graphics in one directory.
Will I be causing problems later on by doing that?
 
 
Gilbert Midonnet
718.928.4524
www.glmdesigns.com
 
 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237418
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: maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
Thanks all,

I was pretty sure that 10-20,000 was way too much but not certain how
best to organize it. I'm still thinking it through. Thanks about the
point regarding category. (Category would not be a good choice, since
someone may
choose the wrong category first, then update the product.)

Since each item will have at least two accompanying photos I'll probably
do something along the line you suggest but probably bring it down to
100 or 250 instead of a thousand.

Thanks 

Gil



-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 9:58 AM
To: CF-Talk
Subject: Re: maximum number of files in directory

 or maybe categories (dresses, denim, jewelry) (the advantage of this
would be fewer directories than designers)

You could also use some better balanced subdivision.
For instance, if you have some numerical Id nb, use the three last 
digits as the file name,
and the rest for the directory.
This way, when the directory has 1000 files, a new one is created, etc.

Use something that cannot be changed in your database, so that you do 
not have to move
the files when data is changed. Category would not be a good choice, 
since someone may
choose the wrong category first, then update the product.

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




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237419
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: WAR File Deployment

2006-04-11 Thread Douglas Knudsen
if you dont' have a jrun4/servers/cfusion-ear folder, you probably do
not have the enterprise version.  IIRC, you can' deploy WARs on the
standard license...i could be wrong on that.

DK

On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:
 try dropping the WAR under servers/cfusion-ear
 
 DK
 
 On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:
 

 Thanks for responding, but I don't have a JRun administrator and can't find a 
 folder named servers/cfusion-ear.  I am running CFusion on IIS.  Is that 
 significant?

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237420
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


CFChart Format= Flash Veritical Value

2006-04-11 Thread David Brown
Hello everyone,

I have looked on several blogs and  tried using webcharts, but as of yet I 
can't find a way.  And there may not be a way.

I would like to show the value of a bar chart vertical inside of the bar.  
Right now I have the values inside of the bar, but they are horizontal.  For 2 
to 3 digit numbers is fine, but when you get into 5 to 6 digit numbers they 
need to run vertical.

Any ideas?

David

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237421
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: maximum number of files in directory

2006-04-11 Thread Mike Klostermeyer
I've served images from a Windows 2000 Server that was fine until it reached
20,000-30,000, at which point it became unstable.

Mike

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 10:19 AM
To: CF-Talk
Subject: RE: maximum number of files in directory


Thanks all,

I was pretty sure that 10-20,000 was way too much but not certain how
best to organize it. I'm still thinking it through. Thanks about the
point regarding category. (Category would not be a good choice, since
someone may
choose the wrong category first, then update the product.)

Since each item will have at least two accompanying photos I'll probably
do something along the line you suggest but probably bring it down to
100 or 250 instead of a thousand.

Thanks

Gil



-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 9:58 AM
To: CF-Talk
Subject: Re: maximum number of files in directory

 or maybe categories (dresses, denim, jewelry) (the advantage of this
would be fewer directories than designers)

You could also use some better balanced subdivision.
For instance, if you have some numerical Id nb, use the three last
digits as the file name,
and the rest for the directory.
This way, when the directory has 1000 files, a new one is created, etc.

Use something that cannot be changed in your database, so that you do
not have to move
the files when data is changed. Category would not be a good choice,
since someone may
choose the wrong category first, then update the product.

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






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237422
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: maximum number of files in directory

2006-04-11 Thread Dave Watts
 I'm creating a database for a store. It will probably have 
 several thousand items (but will probably never come close to 10,000).
  
 The pictures of the items will be stored in a file directory 
 (not as a blob in a database). What is the maximum amount of 
 files that can be stored in a directory and still have an 
 efficient response time. 
  
 Each item will have at least two graphics if not three or four
  
 #itemID#-th
 #itemID#
  
 It is quite possible that there could be 15-20,000 images in 
 this directory. Is that too many?

Yes, I would strongly recommend using some sort of storage hierarchy. You
are very likely to see performance degrade with that many files in a single
directory. The specific number of files that'll cause a problem will vary,
of course, depending on your hardware and OS, but I've run into this problem
several times, and would recommend that you plan for the worst.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237423
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: Dedicated Server

2006-04-11 Thread Gilbert Midonnet
I'm looking for dedicated server space as well. iWeb.ca doesn't look as
if it’s a CF shop.


Gil



-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 10, 2006 12:03 PM
To: CF-Talk
Subject: Re: Dedicated Server

I've been very satisfied with iWeb.ca

Rey...

Oðuz_Demirkapý wrote:
 Hi,
 
  
 
 I am looking for a reasonable (cheap) dedicated hosting for my private
 websites like my blog or our CFUG website etc. (~25 domains :-))
 
  
 
 I have my own server now at my company's data center but I want to
have a
 new solution that would be more independent from my company.
 
  
 
 Normally I would like to have a Linux server but I have a project that
has
 MSDE as database and just because of that unfortunately I need to find
a
 server Windows on it.
 
  
 
 Any suggestion?
 
  
 
  
 
 Sincerely,
 
  
 
 Oðuz Demirkapý
 
  
 
 
 
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237424
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: maximum number of files in directory

2006-04-11 Thread Jerry Johnson
I often use the itemID to break down the folders, since these seldom change.

Since it is the computer and not humans that do the sorting, the rules
can be simple for the computer, even though weird for people.

The last 3 digits of the zero padded id has worked well for me.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237425
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: maximum number of files in directory

2006-04-11 Thread Ken Ferguson
A customer of mine had a Windows 2K server on a cheesy little box. It 
had about 15,000 images in one folder and was still serving them up 
without much if any problem. However, I made the mistake of trying to 
open the folder in Explorer one day and the machine laughed maniacally 
then went unconscious. After the reboot, I used the command line to move 
some things about and reorganize, changed the code in the application 
and it's continued to work very well to this day with that load spread 
over about 20 directories arranged by product line and category. A 
couple of the categories still have folders with 600-700 images in them, 
but nothing more than that.

--Ferg

Mike Klostermeyer wrote:
 I've served images from a Windows 2000 Server that was fine until it reached
 20,000-30,000, at which point it became unstable.

 Mike

 -Original Message-
 From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 10:19 AM
 To: CF-Talk
 Subject: RE: maximum number of files in directory

   


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237426
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


Problem with Java object calls

2006-04-11 Thread Andrew Dixon
Hi.

I having a problem with a Java object call. It appears that the CF server
does not create the objects exclusively when more than one instance of the
same script is running. I have created a java class to do multi-threaded XML
post to a web service. The java class works fine and everything is great if
you only call the script once. If you call it more that once at the same
time it appears that a new instance is the same as the other instance. Here
is a code segment of how I'm creating the object.

cfscript
obj_PostXML = CreateObject('java', 'MultiThreadedXMLPost').init();
obj_PostXML.executePost(arr_Arguments);
while(obj_PostXML.completedCount LT 2) {}
str_output = obj_PostXML.theData;
/cfscript
cfdump var=#str_output#

Is there anyway to make it exclusive?

Kind regards,

Andrew.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237427
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: java.lang.OutOfMemoryError: unable to create new native thread

2006-04-11 Thread Russ
I have already played with those settings, but it still crashed yesterday.
Here are the settings I'm using:

java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms256m
-Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=512m
-XX:+UseParallelGC -XX:+AggressiveHeap

You would think 512mb is enough for the heap?   Am I giving it too much
possibly?  

This server has 1gb of ram. 

Russ

 -Original Message-
 From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
 Sent: Monday, April 10, 2006 7:48 PM
 To: CF-Talk
 Subject: RE: java.lang.OutOfMemoryError: unable to create new native
 thread
 
 Coldfusion 7 needs more heap space than your JVM allows it to use. You
 need to increase maximum heap size.
 
 The following is for JSP, but solution is the same.
 
 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17470
 
 --
 Oleg Gunkin
 Email: [EMAIL PROTECTED]
 Phone: (604) 666-9392
 Emerging Technologies / Pacific Web Services
 Information Technology Services
 Public Works and Government Services Canada (Pacific)
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237428
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


404 errors and old google data

2006-04-11 Thread Ben Nadel
A client site of mine is getting a bunch of 404 errors now when
Google/MSN/Yahoo bots are trying to find pages that were on their old site. 

Will this problem just fix itself over time? 

Should I set the header info (other than a 404 status)? Something like a
permanent redirect or a permanent not found or something? Just something to
let the bots know not to index the error page, but instead to realize that
they don't need to have that link anymore?

Thanks,
...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237429
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: maximum number of files in directory

2006-04-11 Thread John Paul Ashenfelter
On 4/11/06, Gilbert Midonnet [EMAIL PROTECTED] wrote:
 I'm creating a database for a store. It will probably have several
 thousand items (but will probably never come close to 10,000).

 The pictures of the items will be stored in a file directory (not as a
 blob in a database). What is the maximum amount of files that can be
 stored in a directory and still have an efficient response time.

Efficient response time is very much a nebulous concept -- hardware,
load, and user-dependent.

As far as maximum amounts go, that is *filesystem* dependent.

Some MS specifics are here (eg 4+ billion files for NTFS)
http://www.microsoft.com/technet/prodtechnol/winxppro/reskit/c13621675.mspx

Linux specifics vary all over the map, since there are so many
filesystems, some designed for closer to petabyte storage arrays.

 It would be so much simpler to have all the graphics in one directory.
 Will I be causing problems later on by doing that?

The smartest thing to do would be to abstract out the storage details
so you can change the implementation when you need to. You want a
function like PathToItem(itemId) that gives you back the location of
the file. But you want the implementation to be a black box to the
rest of the app. That way you can start with the simplest possible
approach and hard-code a path

function PathToItem(itemId)
  return '/path/to/my/file

pathToItem(8202) - c:/wwwroot/myapp/images

Then later decide that you need to partition out numerically by the
item id into groups of 1000 as someone suggested in this thread

function PathToItem(itemId)
  return '/rootpath/'  (itemId DIV 1000)  '/'  itemId

pathToItem(8202) - c:/wwwroot/myapp/images/8/8202

Then later you find that breaking the directories by month/year of
entry makes more sense

function PathToItem(itemId)
  return '/rootpath/'  Year(createddate)  '/'  Month(createddate)  itemId

pathToItem(8202) - c:/wwwroot/myapp/images/2006/04/8202

etc.

If you use this to create the path when you write the image and when
you read it, you're set.

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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237430
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: maximum number of files in directory

2006-04-11 Thread Burns, John D
This begs another question that I haven't run into a problem with yet
but makes me feel uneasy. What about folders within a folder? I have a
folder where I create a new folder for every user on the site and then
anything they upload goes into their folder. This is working well so far
as we only have around 1000 users. We're using a Windows 2003 Server. As
it grows am I going to hit the same kind of limitations or does windows
handle the folders well enough that it won't be a problem? Just curious
because I've never dealt with the issue before when it comes to folder.
Definitely had some headaches with the number of files (especially
images) in a folder. Anyone have experiences or thoughts?


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

-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 12:01 PM
To: CF-Talk
Subject: Re: maximum number of files in directory

A customer of mine had a Windows 2K server on a cheesy little box. It
had about 15,000 images in one folder and was still serving them up
without much if any problem. However, I made the mistake of trying to
open the folder in Explorer one day and the machine laughed maniacally
then went unconscious. After the reboot, I used the command line to move
some things about and reorganize, changed the code in the application
and it's continued to work very well to this day with that load spread
over about 20 directories arranged by product line and category. A
couple of the categories still have folders with 600-700 images in them,
but nothing more than that.

--Ferg

Mike Klostermeyer wrote:
 I've served images from a Windows 2000 Server that was fine until it 
 reached 20,000-30,000, at which point it became unstable.

 Mike

 -Original Message-
 From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 10:19 AM
 To: CF-Talk
 Subject: RE: maximum number of files in directory

   




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237431
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: 404 errors and old google data

2006-04-11 Thread Andy Matthews
I'm having the same problem. I just redesigned a site and I'm getting CF
errors from some pages and 404 errors from other pages.

I'd love to know what you did for a solution.

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

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 11:25 AM
To: CF-Talk
Subject: 404 errors and old google data


A client site of mine is getting a bunch of 404 errors now when
Google/MSN/Yahoo bots are trying to find pages that were on their old site.

Will this problem just fix itself over time?

Should I set the header info (other than a 404 status)? Something like a
permanent redirect or a permanent not found or something? Just something to
let the bots know not to index the error page, but instead to realize that
they don't need to have that link anymore?

Thanks,

Ben Nadel
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237432
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: 404 errors and old google data

2006-04-11 Thread Russ
If possible, set up an apache redirect that redirects the old url to the new
one.  (and make it a permanent redirect).  This way the search engines will
start indexing the new site. 

You can also just rewrite all the not found urls to the home page of the new
site, so this way the search engines will just start indexing that
instead... 

 -Original Message-
 From: Ben Nadel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 12:25 PM
 To: CF-Talk
 Subject: 404 errors and old google data
 
 A client site of mine is getting a bunch of 404 errors now when
 Google/MSN/Yahoo bots are trying to find pages that were on their old
 site.
 
 Will this problem just fix itself over time?
 
 Should I set the header info (other than a 404 status)? Something like a
 permanent redirect or a permanent not found or something? Just something
 to
 let the bots know not to index the error page, but instead to realize that
 they don't need to have that link anymore?
 
 Thanks,
 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Ave.
 Suite 1005
 New York, NY 10001
 212.691.1134 x 14
 212.691.3477 fax
 www.nylontechnology.com
 
 Sanders: Lightspeed too slow?
 Helmet: Yes we'll have to go right to ludacris speed.
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237433
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: 404 errors and old google data

2006-04-11 Thread Ben Nadel
Russ,

Good suggesitons, but I can't really do a permanent redirect as I don't know
what the old Urls are... I was not involved in the old site creation, nor
was my client-contact.

As far as the homepage redirect, I like having the error page to let people
know that they didn't make a mistake.. That the site did. 

Thanks,
...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 12:32 PM
To: CF-Talk
Subject: RE: 404 errors and old google data

If possible, set up an apache redirect that redirects the old url to the new
one.  (and make it a permanent redirect).  This way the search engines will
start indexing the new site. 

You can also just rewrite all the not found urls to the home page of the new
site, so this way the search engines will just start indexing that
instead... 

 -Original Message-
 From: Ben Nadel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 12:25 PM
 To: CF-Talk
 Subject: 404 errors and old google data
 
 A client site of mine is getting a bunch of 404 errors now when 
 Google/MSN/Yahoo bots are trying to find pages that were on their old 
 site.
 
 Will this problem just fix itself over time?
 
 Should I set the header info (other than a 404 status)? Something like 
 a permanent redirect or a permanent not found or something? Just 
 something to let the bots know not to index the error page, but 
 instead to realize that they don't need to have that link anymore?
 
 Thanks,
 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Ave.
 Suite 1005
 New York, NY 10001
 212.691.1134 x 14
 212.691.3477 fax
 www.nylontechnology.com
 
 Sanders: Lightspeed too slow?
 Helmet: Yes we'll have to go right to ludacris speed.
 
 
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237434
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


chr(10) in excel

2006-04-11 Thread Turetsky, Seth
Hi,
I have a page that pops up in excel, but I want line wraps within cells.  I 
tried chr(10) but it doesn't seem to respect it. 
Has anyone done this or can they try this(i'm using BD now), I vaguely remember 
this working in the past.
Thanks,
Seth

!---test code---
CFHEADER NAME=Expires VALUE=Mon, 06 Jan 1990 00:00:01 GMT
CFHEADER NAME=Pragma VALUE=no-cache
CFHEADER NAME=cache-control VALUE=no-cache

META HTTP-EQUIV=Expires CONTENT=Mon, 06 Jan 1990 00:00:01 GMT
META HTTP-EQUIV=Pragma CONTENT=no-cache
META HTTP-EQUIV=Cache-Control CONTENT=no-cache

cfheader name=Content-disposition 
value=attachment;filename=spreadsheet.xls
cfcontent type=application/vnd.ms-excel

cfoutputline1a#chr(10)#line1b
line2a#chr(10)#line2b/cfoutput

==
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237435
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: chr(10) in excel

2006-04-11 Thread Rob Wilkerson
Try #chr(13)##chr(10)#?

On 4/11/06, Turetsky, Seth [EMAIL PROTECTED] wrote:
 Hi,
 I have a page that pops up in excel, but I want line wraps within cells.  I 
 tried chr(10) but it doesn't seem to respect it.
 Has anyone done this or can they try this(i'm using BD now), I vaguely 
 remember this working in the past.
 Thanks,
 Seth

 !---test code---
 CFHEADER NAME=Expires VALUE=Mon, 06 Jan 1990 00:00:01 GMT
 CFHEADER NAME=Pragma VALUE=no-cache
 CFHEADER NAME=cache-control VALUE=no-cache

 META HTTP-EQUIV=Expires CONTENT=Mon, 06 Jan 1990 00:00:01 GMT
 META HTTP-EQUIV=Pragma CONTENT=no-cache
 META HTTP-EQUIV=Cache-Control CONTENT=no-cache

 cfheader name=Content-disposition 
 value=attachment;filename=spreadsheet.xls
 cfcontent type=application/vnd.ms-excel

 cfoutputline1a#chr(10)#line1b
 line2a#chr(10)#line2b/cfoutput

 ==
 Please access the attached hyperlink for an important electronic 
 communications disclaimer:

 http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
 ==


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237436
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: VHS and Betamax

2006-04-11 Thread S . Isaac Dealey
 The comment I forgot to make in that post was that really
 I think the trick is to find handfull of technologies you
 like that are on the up-swing (since they all rise and
 fall) and stick with them as long as you can. This should
 make it easier to add other complementary skills as the
 demand for them increases and mitigate the risks involved
 in devaluation of any individual skill as a result of
 increased supply or waning demand. As an individual I'm
 personally probably more invested in ColdFusion than
 anything else, potentially over-invested actually.

 Ok. But your heavy involvement in CF perpetuates it as
 well.

Yes. :)

 I guess we shouldn't be to reliant on computers,
  neh? (-:

 My opinions on that subject tend to be pretty unpopular.
 :)

 Swinging  to what side? More so or less?

Socially I think we allow computers to hand-cuff us.

 I still put forth that generated code is generated code,
  why shy away from generated code? So long as it's well
  formatted (don't look at me, you saw my regex ;) you
  should be ok, I recon.

 It's a question of who's generating it and why. :)

 To me the fact that my coldfusion templates or CFC's are
 generated Java is transparent. I know it's there, but I
 don't have to care too much about what's being generated,
 beyond knowing that it is generated and having some
 understanding of the problems that can be caused by that.

 Well, maybe if the optimization is as swell as it's said
 to be.  I can't help but feel that even as smart as
 computers are, there are areas that a human could see a
 pattern before the computer could. Or whatever.

Is this a response to my comment about why I'm not bothered by the
fact that the ColdFusion server generates java code? (another good
example of which is that the server used to generate C++ code (at
least I thought I remembered somebody saying such), and my knowledge
of C++ wasn't helpful when I worked with ColdFusion then either)

 Guess the argument about optimization has some validity,
 yet I can't help see history repeat itself. Every few
 years there's this idea that it doesn't matter, we're
 getting bigger, faster processors, more RAM, etc.. Yet
 the real idea is to conserve energy. Sorta. I guess make
 less go further.  That's never going to change, no
 matter how much power there is. It's the nature of
 power - corruption and responsibility aside.

No not entirely. The issue is that we're still in transition. The
hardware progress is not as fast as many of us would like and
sometimes we jump the gun with regard to wanting to be able to have
the Star Trek computer that we just tell what to do and it does it. So
if I build an application today and I fail to optimize it , then my
application is going to be slow in comparison to another application
which accomplishes the same task. (Incidentally I spend quite a bit of
my programming time thinking about the optimization of my software --
I may not always get it right, but I do have a reasonable handle on
the concepts.)

Skip forward 20 years.

Twenty years from now if you load up the same two applications, you
won't be able to tell the difference between them. Yes, one of them is
still inefficient / slow, but to the human person using them, there is
no tangible difference, because advances in hardware cause the slow
application to perform as quickly as the efficient one. So both
applications have the same value (including monetary value) in the
market.

When we optimize software, we're not doing that for the future, we're
doing that to compete in today's market, and because today's market
is always becoming tomorrow's market that means we're always
shooting at a moving target, so there becomes this balancing act
between how much time we spend optimizing an application and making it
blazingly fast today, and how much time we carve away from the
optimization game in favor of tasks that will be more important in the
market in years to come, such as usability, extensibility and new
features.

Extensibility in particular is one of those future value prospects.
Pretty much without fail, something which makes your application
extensible will cost you some efficiency. In some cases it may be
thoughtfull application of XML, which as Joel points out in the
article you posted is always going to be slow compared to a database
(in today's market, and for a good while yet - although if you store
the xml in a file and/or in memory you can get some of that back by
not needing a network trip through the database port), other times it
may be the division of logical functionality into separate objects
which then have to be instantiated. Don't get me wrong, I love
objects, but object instantiation is always slower than using
something that exists already in memory. Thus each time you find an
object doing too much and you separate it into two or more objects to
handle different tasks, you're increasing the load on the machine,
even though you haven't added much if any more code.

All 

Re: maximum number of files in directory

2006-04-11 Thread Claude Schneegans
 I'll probably
do something along the line you suggest but probably bring it down to
100 or 250 instead of a thousand.

Time to use the MOD operator then ;-)

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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237438
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: 404 errors and old google data

2006-04-11 Thread Dawson, Michael
Can't you get the 404 errors from the web server logs?  If they tried to
access your web site and received a 404, it will be in the logs.

M!ke 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 11:43 AM
To: CF-Talk
Subject: RE: 404 errors and old google data

Russ,

Good suggesitons, but I can't really do a permanent redirect as I don't
know what the old Urls are... I was not involved in the old site
creation, nor was my client-contact.

As far as the homepage redirect, I like having the error page to let
people know that they didn't make a mistake.. That the site did. 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237439
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: chr(10) in excel

2006-04-11 Thread Turetsky, Seth
I think that is to drop to the next cell, but I just want a break in the 
cell(alt-enter in excel)

-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 1:04 PM
To: CF-Talk
Subject: Re: chr(10) in excel


Try #chr(13)##chr(10)#?

On 4/11/06, Turetsky, Seth [EMAIL PROTECTED] wrote:
 Hi,
 I have a page that pops up in excel, but I want line wraps within cells.  I 
 tried chr(10) but it doesn't seem to respect it.
 Has anyone done this or can they try this(i'm using BD now), I vaguely 
 remember this working in the past.
 Thanks,
 Seth

 !---test code---
 CFHEADER NAME=Expires VALUE=Mon, 06 Jan 1990 00:00:01 GMT
 CFHEADER NAME=Pragma VALUE=no-cache
 CFHEADER NAME=cache-control VALUE=no-cache

 META HTTP-EQUIV=Expires CONTENT=Mon, 06 Jan 1990 00:00:01 GMT
 META HTTP-EQUIV=Pragma CONTENT=no-cache
 META HTTP-EQUIV=Cache-Control CONTENT=no-cache

 cfheader name=Content-disposition 
 value=attachment;filename=spreadsheet.xls
 cfcontent type=application/vnd.ms-excel

 cfoutputline1a#chr(10)#line1b
 line2a#chr(10)#line2b/cfoutput

 ==
 Please access the attached hyperlink for an important electronic 
 communications disclaimer:

 http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
 ==


 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237440
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: VHS and Betamax

2006-04-11 Thread Dave Francis
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 1:11 PM
To: CF-Talk
Subject: Re: VHS and Betamax


No not entirely. The issue is that we're still in transition. The
hardware progress is not as fast as many of us would like and
sometimes we jump the gun with regard to wanting to be able to have
the Star Trek computer that we just tell what to do and it does it. So
if I build an application today and I fail to optimize it , then my
application is going to be slow in comparison to another application
which accomplishes the same task. (Incidentally I spend quite a bit of
my programming time thinking about the optimization of my software --
I may not always get it right, but I do have a reasonable handle on
the concepts.)

With genuine respect:

I'm not sure that being in transition is relevant - we're always going to
be. More horsepower generally seems to engender more complex applications
rather than faster ones.

Isaac, I wish it were otherwise, but with multi-core, multi-threaded
processors/processes, I'm not sure that people CAN optimize software any
longer. At least, at the code level. It just isn't cost-effective to spend
days trying to tweak a block of code down to 200 cyles from 220 cycles.
(unless you're John Carmack!)

I can remember the days when it did matter (I wrote Assembler on a 360/40,
circa 1967), but I just don't believe that that's the case any longer.






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237441
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: chr(10) in excel

2006-04-11 Thread Brad Wood
OK, I opened Excel, typed 1 then hit alt-enter, and then typed a 2.
I then saved the document as html, and this was the table it produced:

table x:str border=0 cellpadding=0 cellspacing=0 width=64
style='border-collapse:
 collapse;table-layout:fixed;width:48pt'
 col width=64 style='width:48pt'
 tr height=34 style='height:25.5pt'
  td height=34 class=xl24 width=64
style='height:25.5pt;width:48pt'1br
2/td
 /tr
 ![if supportMisalignedColumns]
 tr height=0 style='display:none'
  td width=64 style='width:48pt'/td
 /tr
 ![endif]
/table

You can see that it entered a br to denote the new line.

Then I saved it as a CSV file, and this was the result:

1
2

As you can see, it wrapped the cell contents in double quotes, and
simply put in a line break and cartridge return. A double quote in your
value would be escaped as .

Now, I don't know if the HTML break will work for you, or if you are
doing more of a csv thing, but it is food for thought I guess.

~Brad

-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 12:27 PM
To: CF-Talk
Subject: RE: chr(10) in excel

I think that is to drop to the next cell, but I just want a break in the
cell(alt-enter in excel)


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237442
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: java.lang.OutOfMemoryError: unable to create new native thread

2006-04-11 Thread Douglas Knudsen
have you turned on metrics logging?  Maybe you need to up your max sim threads.

your error trace has quite abit about JDBC in it.  Are you limiting
your DSN connections?

DK

On 4/11/06, Russ [EMAIL PROTECTED] wrote:
 I have already played with those settings, but it still crashed yesterday.
 Here are the settings I'm using:

 java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms256m
 -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=512m
 -XX:+UseParallelGC -XX:+AggressiveHeap

 You would think 512mb is enough for the heap?   Am I giving it too much
 possibly?

 This server has 1gb of ram.

 Russ

  -Original Message-
  From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
  Sent: Monday, April 10, 2006 7:48 PM
  To: CF-Talk
  Subject: RE: java.lang.OutOfMemoryError: unable to create new native
  thread
 
  Coldfusion 7 needs more heap space than your JVM allows it to use. You
  need to increase maximum heap size.
 
  The following is for JSP, but solution is the same.
 
  http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17470
 
  --
  Oleg Gunkin
  Email: [EMAIL PROTECTED]
  Phone: (604) 666-9392
  Emerging Technologies / Pacific Web Services
  Information Technology Services
  Public Works and Government Services Canada (Pacific)
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237443
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: chr(10) in excel

2006-04-11 Thread Turetsky, Seth
Played with the br but it breaks the cell then.
And if I add in html tags, it ignored all chr()'s.  

hmm might not be possible

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 1:50 PM
To: CF-Talk
Subject: RE: chr(10) in excel


OK, I opened Excel, typed 1 then hit alt-enter, and then typed a 2.
I then saved the document as html, and this was the table it produced:

table x:str border=0 cellpadding=0 cellspacing=0 width=64
style='border-collapse:
 collapse;table-layout:fixed;width:48pt'
 col width=64 style='width:48pt'
 tr height=34 style='height:25.5pt'
  td height=34 class=xl24 width=64
style='height:25.5pt;width:48pt'1br
2/td
 /tr
 ![if supportMisalignedColumns]
 tr height=0 style='display:none'
  td width=64 style='width:48pt'/td
 /tr
 ![endif]
/table

You can see that it entered a br to denote the new line.

Then I saved it as a CSV file, and this was the result:

1
2

As you can see, it wrapped the cell contents in double quotes, and
simply put in a line break and cartridge return. A double quote in your
value would be escaped as .

Now, I don't know if the HTML break will work for you, or if you are
doing more of a csv thing, but it is food for thought I guess.

~Brad

-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 12:27 PM
To: CF-Talk
Subject: RE: chr(10) in excel

I think that is to drop to the next cell, but I just want a break in the
cell(alt-enter in excel)




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237444
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: maximum number of files in directory

2006-04-11 Thread Jochem van Dieten
Gilbert Midonnet wrote:
 I'm creating a database for a store. It will probably have several
 thousand items (but will probably never come close to 10,000).
  
 The pictures of the items will be stored in a file directory (not as a
 blob in a database). What is the maximum amount of files that can be
 stored in a directory and still have an efficient response time. 

Which filesystem?

Jochem

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237445
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


MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Damien McKenna
Evening folks.

We use MS SQL Server 2000 for a small amount of data on our site, mostly
smaller bits of content separate to our core business (which is in
Cobol), so a few hundred meg of real data I figure.

I'm working on building a new web server to replace the loaner we've had
for a while and was about to install SQL Server 2000 when I remembered
that the 2005 Express edition could also fit our requirements.  So has
anyone migrated from '2000 to '2005, and if so how well did it go?  We
don't use any fancy stuff in SQL Server like stored procedures, etc,
just basically as a collection of dumb tables, and like I said we've got
a few hundred meg of data and that's it.

So is it worth trying to convert?

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237446
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: MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Damien McKenna
OK, nevermind, SQL Server 2005 Express won't work on dual-processor
servers.  Ah well.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237447
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: VHS and Betamax

2006-04-11 Thread S . Isaac Dealey
 -Original Message-
 From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 1:11 PM
 To: CF-Talk
 Subject: Re: VHS and Betamax

No not entirely. The issue is that we're still in
transition. The hardware progress is not as fast
as many of us would like and sometimes we jump the
gun with regard to wanting to be able to have the
Star Trek computer that we just tell what to do and
it does it. So if I build an application today and
I fail to optimize it, then my application is going
to be slow in comparison to another application
which accomplishes the same task. (Incidentally I
spend quite a bit of my programming time thinking
about the optimization of my software -- I may not
always get it right, but I do have a reasonable
handle on the concepts.)

 With genuine respect:

Thanks, although I always assume respect is given. :)

Having said that I realize that's an opportunity for someone to poke
at me for being disrespectful. :)

 I'm not sure that being in transition is relevant
 - we're always going to be. More horsepower
 generally seems to engender more complex
 applications rather than faster ones.

While that's true, feature complexity doesn't inherently solve human
need. Particularly with software development (as compared to physical
product production) there's a sort of illusion of software being
cheaper than it is to make because the business people involved get
sort of swept away by the lack of material costs. They don't see the
development lifecycle and the planning costs the way we do down here
in the trenches. That same sort of lack of understanding at the top
frequently engenders a lack of research into the usefulness of the end
product. I.e. if it costs nothing to make, then why not just make
it? :) The end result is often a lot of guess-work rather than
spending the time and money up-front to research what people need.
Thus we end up with all those thousands of nifty little features in MS
Office products that less than 1% of the product's target market
actually use. :P

Now couple that with the evolution of hardware. As the hardware
becomes more efficient in todays market, software manufacturers
continue to add features because the efficiency of the hardware gives
them more room to add them. This is true, and I don't debate that it's
still important to add features, since I have plenty of examples of
applications currently that even at their most efficient are still
performing more slowly than we'd like, or that still lack certain
features because those features are simply too inefficient to be
practical for daily use with today's hardware.

Set up ColdFusion developer edition at home with a copy of any
anti-virus application with the auto-file scan enabled. Watch how long
it takes the CF Server service to start up. :) Webservices as another
example are only viable now because the hardware will support them --
we'd have never even tried webservices if we still had to serve
everything on the 14.4k modems we had in the early 90's.

So what I'm getting at here is that although we can't see it
currently, I believe (and I certainly could be wrong) that the demand
for features will eventually taper off (although I'm certain it will
never be completely abolished) as the hardware becomes more efficient
in the same way that the demand for efficiency in our existing feature
sets is tapering off.

There is only a certain amount of complexity that will be useful to
the average person (avoiding the word user here), beyond which any
given application begins to delve into a niche market with a much
smaller user base, but who as a result of being in that niche market
will then also want a certain specific sub-set of features which will
vary from the sub-set of features desired by another niche using a
similar application. Sure we could just cram both niches into a single
application, but it's better for the person using it if they can get
something that's not so cavalier about the needs of their niche.
There's a good example of this in The Inmates Are Running the Asylum
by Alan Cooper where he describes the car that's designed for everyone
-- a convertible mini-van with a big bed for hauling lumber. :)

I submit to you as a real-world example of that sort of tapering of
feature complexity, the common pocket-calculator. :) I know of three
essential versions of this thing currently, the basic calculator
(performs arithmetic) for people doing their grocery shopping, the
scientific calculator (includes a few extra features like the log
button) for people in mathematically complex professions such as
architects, and the programmable compu-calculator (for mathematicians,
trig and calculus students). Note that each of these devices fills a
specific niche, and with the possible exception of the most complex of
these three niches, the features of these calculators have long since
tapered to the point of zero growth. New features aren't added to the
basic or scientific calculator anymore 

Re: CFChart Format= Flash Veritical Value

2006-04-11 Thread Peter Farrell
 Hello everyone,
 
 I have looked on several blogs and  tried using webcharts, but as of 
 yet I can't find a way.  And there may not be a way.
 
 I would like to show the value of a bar chart vertical inside of the 
 bar.  Right now I have the values inside of the bar, but they are 
 horizontal.  For 2 to 3 digit numbers is fine, but when you get into 5 
 to 6 digit numbers they need to run vertical.
 
 Any ideas?
 
David

Hi David,

I rarely do I read the HoF list, but luckily your message caught my attention.  
Recently, I've been heavily envolved in charting - using WebCharts3D and the 
java classes that ship with CFMX7 (bypassing CFChart).

What you are referring to is the data label element.  I don't think you can 
rotate the data label 90 degrees to vertical.  However, you have two options.

1.  Create a horizontal bar chart.  Since the bars would then be horizontal, 
your problem would be solved.

2.  Use your current solution without the data label and use the table option 
in WebCharts3D.

Since, I only read the digest - I'll try and keep on this thread (hopefully).

Best,
...Peter
MaePub

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237449
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: maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
It's a shared server space. Will probably have to move to a dedicated
server -- at least for the client's sake I hope so.

Its on an NT 2003 server. 



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 2:18 PM
To: CF-Talk
Subject: Re: maximum number of files in directory

Gilbert Midonnet wrote:
 I'm creating a database for a store. It will probably have several
 thousand items (but will probably never come close to 10,000).
  
 The pictures of the items will be stored in a file directory (not as a
 blob in a database). What is the maximum amount of files that can be
 stored in a directory and still have an efficient response time. 

Which filesystem?

Jochem



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237450
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: 404 errors and old google data

2006-04-11 Thread Munson, Jacob
 From: Ben Nadel [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, April 11, 2006 10:25 AM
 
 A client site of mine is getting a bunch of 404 errors now when
 Google/MSN/Yahoo bots are trying to find pages that were on 
 their old site. 
 
 Will this problem just fix itself over time? 

Yes, it would, but it may not be the best option.
 
 Should I set the header info (other than a 404 status)? 
 Something like a
 permanent redirect or a permanent not found or something? 

I would try to do something like this.  I like to do redirects, CF has a
way to do that:

cfheader statuscode=301 statustext=Moved Permanently
cfheader name=Location value=#newURL#
cfabort





[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237451
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: 404 errors and old google data

2006-04-11 Thread Ray Champagne
 Should I set the header info (other than a 404 status)? 
 Something like a
 permanent redirect or a permanent not found or something? 
 
 I would try to do something like this.  I like to do redirects, CF has a
 way to do that:
 
 cfheader statuscode=301 statustext=Moved Permanently
 cfheader name=Location value=#newURL#
 cfabort
 
 

So, just so I'm clear on SE practices...

He said that he has no idea what pages were supposed to correspond to 
old pages.  If he just redirects them all to the root (index.cfm), they 
won't lose the ranking, and over time, the new site will not be 
blacklisted or anything.  Sorry to jump in the middle if this has 
already been answered, but I'm having a similar problem right now.

Ray

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237452
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


Group - but with no order specified

2006-04-11 Thread Les Mizzell
Is there a way to group output in a query and keep the groups together, 
but with no order specified anywhere?

cfquery
Select myGROUP, mySubGROUP from myTABLE
!---(NO ORDER BY)---
/cfquery

I need output like:

1. myGROUP
a. mySUBGOUP 1
b. mySUBGOUP 2

2. myGROUP 2
a. mySUBGOUP 1
b. mySUBGOUP 2

If you just do the below, it doesn't keep the groups together since 
they're not together in the database...

cfoutput group=myGROUP
1. myGROUP
a. mySUBGOUP 1
b. mySUBGOUP 2
/cfoutput

Outputs (depending on what's in the database)

1. myGROUP
a. mySUBGOUP 1

2. myGROUP 2
a. mySUBGOUP 1
b. mySUBGOUP 2

1. myGROUP
b. mySUBGOUP 2


If I add a ORDER to the query, it obviously works - but, the client 
doesn't WANT them in any order. He just wants the groups together.

I say you can't have it both ways. You have to have a sort order to keep 
the groups together.  Or is there a weird work around for this?


Yea - stupid I know, but clients want what they want...


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237453
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: MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Munson, Jacob
 So has anyone migrated from '2000 to '2005, and if so how well did it
go?  We
 don't use any fancy stuff in SQL Server like stored procedures, etc,
 just basically as a collection of dumb tables, and like I 
 said we've got
 a few hundred meg of data and that's it.

It's my understanding that the database part of 2005 is virtually
identical to 2000 (as far as compatibility).  There are some new
features that you could use, but your 2000 DB /should/ transfer
seamlessly.  We've done a couple of database ports, and not run into any
problems.  But we make heavy use of DTS and AS, so we haven't made the
jump yet (those are radically different in 2005).


--


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237454
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: Group - but with no order specified

2006-04-11 Thread Jerry Johnson
Only order the groups, not the subgroups?

On 4/11/06, Les Mizzell [EMAIL PROTECTED] wrote:
 Is there a way to group output in a query and keep the groups together,
 but with no order specified anywhere?

 cfquery
 Select myGROUP, mySubGROUP from myTABLE
 !---(NO ORDER BY)---
 /cfquery

 I need output like:

 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 If you just do the below, it doesn't keep the groups together since
 they're not together in the database...

 cfoutput group=myGROUP
 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 /cfoutput

 Outputs (depending on what's in the database)

 1. myGROUP
 a. mySUBGOUP 1

 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 1. myGROUP
 b. mySUBGOUP 2


 If I add a ORDER to the query, it obviously works - but, the client
 doesn't WANT them in any order. He just wants the groups together.

 I say you can't have it both ways. You have to have a sort order to keep
 the groups together.  Or is there a weird work around for this?


 Yea - stupid I know, but clients want what they want...


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237455
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: Group - but with no order specified

2006-04-11 Thread Matt Williams
This idea may seem complicated, but it should work. Put the ORDER BY in the
SQL. Create an empty array. Do your cfoutput with the 'group' attribute. Use
cfsavecontent to put each Group's output into a variable in the array. Then
you can use some kind of randomizer to grab the output from the array. This
would have to be a randomizer that doesn't allow repeating (forget the
technical term for that).

Good luck.

On 4/11/06, Les Mizzell [EMAIL PROTECTED] wrote:

 Is there a way to group output in a query and keep the groups together,
 but with no order specified anywhere?

 cfquery
 Select myGROUP, mySubGROUP from myTABLE
 !---(NO ORDER BY)---
 /cfquery

 I need output like:

 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 If you just do the below, it doesn't keep the groups together since
 they're not together in the database...

 cfoutput group=myGROUP
 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 /cfoutput

 Outputs (depending on what's in the database)

 1. myGROUP
 a. mySUBGOUP 1

 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2

 1. myGROUP
 b. mySUBGOUP 2


 If I add a ORDER to the query, it obviously works - but, the client
 doesn't WANT them in any order. He just wants the groups together.

 I say you can't have it both ways. You have to have a sort order to keep
 the groups together.  Or is there a weird work around for this?


 Yea - stupid I know, but clients want what they want...


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237456
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: Group - but with no order specified

2006-04-11 Thread Munson, Jacob
I don't know what DB you're using, but have you tried using 'group by'?
Something like this:
select fname, lname, address, city, state, zip
from contacts
group by state, city, zip

 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, April 11, 2006 1:00 PM
 To: CF-Talk
 Subject: Group - but with no order specified
 
 Is there a way to group output in a query and keep the groups 
 together, 
 but with no order specified anywhere?
 
 cfquery
 Select myGROUP, mySubGROUP from myTABLE
 !---(NO ORDER BY)---
 /cfquery
 
 I need output like:
 
 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 
 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 
 If you just do the below, it doesn't keep the groups together since 
 they're not together in the database...
 
 cfoutput group=myGROUP
 1. myGROUP
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 /cfoutput
 
 Outputs (depending on what's in the database)
 
 1. myGROUP
 a. mySUBGOUP 1
 
 2. myGROUP 2
 a. mySUBGOUP 1
 b. mySUBGOUP 2
 
 1. myGROUP
 b. mySUBGOUP 2
 
 
 If I add a ORDER to the query, it obviously works - but, the client 
 doesn't WANT them in any order. He just wants the groups together.
 
 I say you can't have it both ways. You have to have a sort 
 order to keep 
 the groups together.  Or is there a weird work around for this?
 
 
 Yea - stupid I know, but clients want what they want...
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237457
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: Group - but with no order specified

2006-04-11 Thread Everett, Al \(NIH/NIGMS\) [C]
CF doesn't care if the records are actually in order, it just processes
the outer loop when there's a change of value.

If myGROUP has a numeric primary key you could do your ORDER BY on that,
rather than on the name of it.

Failing that, you could sort in some strange way that might look random,
but isn't. Like on the 2nd through 5th character in the name.

Failing THAT, I'd suggest creating a SORT_ORDER (INTEGER) column for
each of the myGROUP records and ask your client what order he'd like
them in.



-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 3:00 PM
To: CF-Talk
Subject: Group - but with no order specified

Is there a way to group output in a query and keep the groups together,
but with no order specified anywhere?

cfquery
Select myGROUP, mySubGROUP from myTABLE
!---(NO ORDER BY)---
/cfquery

I need output like:

1. myGROUP
a. mySUBGOUP 1
b. mySUBGOUP 2

2. myGROUP 2
a. mySUBGOUP 1
b. mySUBGOUP 2

If you just do the below, it doesn't keep the groups together since
they're not together in the database...

cfoutput group=myGROUP
1. myGROUP
a. mySUBGOUP 1
b. mySUBGOUP 2
/cfoutput

Outputs (depending on what's in the database)

1. myGROUP
a. mySUBGOUP 1

2. myGROUP 2
a. mySUBGOUP 1
b. mySUBGOUP 2

1. myGROUP
b. mySUBGOUP 2


If I add a ORDER to the query, it obviously works - but, the client
doesn't WANT them in any order. He just wants the groups together.

I say you can't have it both ways. You have to have a sort order to keep
the groups together.  Or is there a weird work around for this?


Yea - stupid I know, but clients want what they want...




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237458
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


adobe certification site

2006-04-11 Thread John Beynon
I updated my Adobe certification profile the other week when the email
arrived from integral7.com, has anyone else been demoted from an
Advanced CF Developer to a CF Developer? It's there in the list but
for some reason I've been demoted..

anyone else?

john.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237459
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: Group - but with no order specified

2006-04-11 Thread Les Mizzell
 I'd suggest creating a SORT_ORDER (INTEGER) column for
 each of the myGROUP records and ask your client what order he'd like
 them in.

This is probably what's going to have to happen.

Otherwise, Yoda says, Solutions there are, but convoluted are they!.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237460
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: Group - but with no order specified

2006-04-11 Thread Joe Rinehart
 If I add a ORDER to the query, it obviously works - but, the client
 doesn't WANT them in any order. He just wants the groups together.

I'm not trying to sound like a wiseass, but just point out a
perspective:  if the client doesn't care what order they're in, what's
the harm in ordering them?

If that doesn't satisfy them, maybe try an ORDER BY on the primary key
of whatever's giving you myGroup.

-Joe

--
Get Glued!
The Model-Glue ColdFusion Framework
http://www.model-glue.com

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237461
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: Group - but with no order specified

2006-04-11 Thread Ken Ferguson
It may well be that they don't not care. They may be specifically 
asking that they not be in any sort of discernible order.

Why are you using the group in the cfoutput instead of in the query?

--Ferg


Joe Rinehart wrote:
 If I add a ORDER to the query, it obviously works - but, the client
 doesn't WANT them in any order. He just wants the groups together.
 

 I'm not trying to sound like a wiseass, but just point out a
 perspective:  if the client doesn't care what order they're in, what's
 the harm in ordering them?

 If that doesn't satisfy them, maybe try an ORDER BY on the primary key
 of whatever's giving you myGroup.

 -Joe

 --
 Get Glued!
 The Model-Glue ColdFusion Framework
 http://www.model-glue.com

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237462
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: Group - but with no order specified

2006-04-11 Thread Andy Matthews
If you've got access to mySQL then just ORDER BY RAND().

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

-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 3:01 PM
To: CF-Talk
Subject: Re: Group - but with no order specified


It may well be that they don't not care. They may be specifically
asking that they not be in any sort of discernible order.

Why are you using the group in the cfoutput instead of in the query?

--Ferg


Joe Rinehart wrote:
 If I add a ORDER to the query, it obviously works - but, the client
 doesn't WANT them in any order. He just wants the groups together.


 I'm not trying to sound like a wiseass, but just point out a
 perspective:  if the client doesn't care what order they're in, what's
 the harm in ordering them?

 If that doesn't satisfy them, maybe try an ORDER BY on the primary key
 of whatever's giving you myGroup.

 -Joe

 --
 Get Glued!
 The Model-Glue ColdFusion Framework
 http://www.model-glue.com





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237463
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: Group - but with no order specified

2006-04-11 Thread Les Mizzell
 I'm not trying to sound like a wiseass, but just point out a
 perspective:  if the client doesn't care what order they're in, what's
 the harm in ordering them?

Client wants it in the order he typed it in, not an alpha sort or 
anything. What the client don't get though is that he's not necessarily 
typing stuff in grouped together either.

So, I'll give them a sort by box and make it their problem to define 
the sort. If sort by ain't defined, they'll get alpha, like it or not. 
It's been alpha for the last year anyway

Just for reference, it's the list of contacts in the right panel here:
http://www.nmrs.com/news/nelson-mullins-newsletter_detail.cfm?id=2406090D-BCD2-35D3-D151001A53DF4C73

What's wrong with an alpha sort? I've *no* idea!

Either way, I'm happy to take more of their money!!!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237464
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: adobe certification site

2006-04-11 Thread Adrian Lynch
Nope, I'm still an Advanced whatsit...

http://www.macromedia.com/v1/handlers/index.cfm?ID=23543#L

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: 11 April 2006 20:34
To: CF-Talk
Subject: adobe certification site


I updated my Adobe certification profile the other week when the email
arrived from integral7.com, has anyone else been demoted from an
Advanced CF Developer to a CF Developer? It's there in the list but
for some reason I've been demoted..

anyone else?

john.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237465
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: Group - but with no order specified

2006-04-11 Thread Andy Matthews
If he's typing it in in order then why not just order it by the
autointeger field?

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

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 2:53 PM
To: CF-Talk
Subject: Re: Group - but with no order specified


 I'm not trying to sound like a wiseass, but just point out a
 perspective:  if the client doesn't care what order they're in, what's
 the harm in ordering them?

Client wants it in the order he typed it in, not an alpha sort or
anything. What the client don't get though is that he's not necessarily
typing stuff in grouped together either.

So, I'll give them a sort by box and make it their problem to define
the sort. If sort by ain't defined, they'll get alpha, like it or not.
It's been alpha for the last year anyway

Just for reference, it's the list of contacts in the right panel here:
http://www.nmrs.com/news/nelson-mullins-newsletter_detail.cfm?id=2406090D-BC
D2-35D3-D151001A53DF4C73

What's wrong with an alpha sort? I've *no* idea!

Either way, I'm happy to take more of their money!!!



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237466
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: Group - but with no order specified

2006-04-11 Thread Scott Stroz
Correct, but if a filed being 'GROUPED' in CF is not ORDERed in SQL, then
disinct items in the 'outer loop' may beoutput more than once.
For example:

cfset test = QueryNew('name,item') /

cfset queryAddRow(test,6) /

cfset querySetCell(test,'name','Bob',1) /
cfset querySetCell(test,'item','book',1) /
cfset querySetCell(test,'name','Bob',2) /
cfset querySetCell(test,'item','ball',2) /
cfset querySetCell(test,'name','Jane',3) /
cfset querySetCell(test,'item','book',3) /
cfset querySetCell(test,'name','Mary',4) /
cfset querySetCell(test,'item','dress',4) /
cfset querySetCell(test,'name','Jane',5) /
cfset querySetCell(test,'item','shoe',5) /
cfset querySetCell(test,'name','Bob',6) /
cfset querySetCell(test,'item','bat',6) /

cfoutput query=test group=name
#name#br/
cfoutput--#item#br//cfoutput
/cfoutput

Will give you:

Bob
--book
--ball
Jane
--book
Mary
--dress
Jane
--shoe
Bob
--bat

Also the GROUP BY clasue in SQL is a different beast than the group
attribute in cfquery

On 4/11/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote:

 CF doesn't care if the records are actually in order, it just processes
 the outer loop when there's a change of value.



--
Scott Stroz
Boyzoid.com
___
Some days you are the dog,
Some days you are the tree.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237467
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


hash question

2006-04-11 Thread jonese
I'm trying to reverse engineer a hash and i'm not sure what could
product something like this:

931c6ff8d9e365bfb412

the value returned by this system is always 20 chars in length and
only consists of letters and numbers.

no i have no idea what it is but i'm trying to reverse engineer it to
see if i can recreate it.

Anyone know what could create a 20 char hash? if it helps at all this
is coming from an Oracle 10G server.

jonese

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237468
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: hash question

2006-04-11 Thread Dave Watts
 I'm trying to reverse engineer a hash ...

The whole point of a hash algorithm is that it should not be susceptible to
reverse-engineering. That is, given a hash, you should never be able to
derive the original value from which the hash was created. If this is in
fact the case, the only way to determine the value from which a hash was
created is to hash a set of values using the same algorithm, and see if any
of those hashes match your hash.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237469
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: hash question

2006-04-11 Thread Ray Champagne
I don't think you're gonna be able to do that.  The whole idea is for it 
to be undecipherable and not be able to be reverse-engineered.


jonese wrote:
 I'm trying to reverse engineer a hash and i'm not sure what could
 product something like this:
 
 931c6ff8d9e365bfb412
 
 the value returned by this system is always 20 chars in length and
 only consists of letters and numbers.
 
 no i have no idea what it is but i'm trying to reverse engineer it to
 see if i can recreate it.
 
 Anyone know what could create a 20 char hash? if it helps at all this
 is coming from an Oracle 10G server.
 
 jonese
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237470
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: hash question

2006-04-11 Thread Oleg Gunkin
Did you forget your password, which was hashed?

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: jonese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 13:44
To: CF-Talk
Subject: hash question


I'm trying to reverse engineer a hash and i'm not sure what could
product something like this:

931c6ff8d9e365bfb412

the value returned by this system is always 20 chars in length and
only consists of letters and numbers.

no i have no idea what it is but i'm trying to reverse engineer it to
see if i can recreate it.

Anyone know what could create a 20 char hash? if it helps at all this
is coming from an Oracle 10G server.

jonese



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237471
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: hash question

2006-04-11 Thread jonese
right i know this and i have some ideas what data is being hashed but
i cannot figure out how to limit a hash to only 20 chars. most of the
hashing i've even done has been in md5 sha1 etc and this is obviously
not that.

I know this is a long shot but i was hoping that the 20 char limit
might ring a bell to someone.

jonese

On 4/11/06, Dave Watts [EMAIL PROTECTED] wrote:
  I'm trying to reverse engineer a hash ...

 The whole point of a hash algorithm is that it should not be susceptible to
 reverse-engineering. That is, given a hash, you should never be able to
 derive the original value from which the hash was created. If this is in
 fact the case, the only way to determine the value from which a hash was
 created is to hash a set of values using the same algorithm, and see if any
 of those hashes match your hash.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237472
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


CFC Root

2006-04-11 Thread O�uz_Demirkap
Hi,

I have a simple code to create a dynamic CFC root and it works for my local
system (WinMCE 2005).

cfset request.cfcroot =
#Replace(listDeleteAt(cgi.script_name,listlen(cgi.script_name,'/'),'/'),'/'
,'','ALL')#.  cfc

As an example 'E:/projects/abc.com/www/' is my webroot.

When I have a cfc file like 'E:/projects/abc.com/www/cfc/image.cfc', I can
reach this cfc from my 'E:/projects/abc.com/www/test.cfm' page with a syntax
such as 

cfset application.imageCFC =
createobject(component,#request.cfcroot#.image) / 



But there are problems on Win2003 Servers.

Do you have anything like that? What would you suggest as alternative?


Sincerely,

Oðuz Demirkapý






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237473
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: hash question

2006-04-11 Thread Munson, Jacob
I just googled '20 character hash' and found quite a few sites that talk
about such an animal.  Might be a good start. 

 -Original Message-
 From: jonese [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, April 11, 2006 2:56 PM
 To: CF-Talk
 Subject: Re: hash question
 
 right i know this and i have some ideas what data is being hashed but
 i cannot figure out how to limit a hash to only 20 chars. most of the
 hashing i've even done has been in md5 sha1 etc and this is obviously
 not that.
 
 I know this is a long shot but i was hoping that the 20 char limit
 might ring a bell to someone.
 
 jonese
 
 On 4/11/06, Dave Watts [EMAIL PROTECTED] wrote:
   I'm trying to reverse engineer a hash ...
 
  The whole point of a hash algorithm is that it should not 
 be susceptible to
  reverse-engineering. That is, given a hash, you should 
 never be able to
  derive the original value from which the hash was created. 
 If this is in
  fact the case, the only way to determine the value from 
 which a hash was
  created is to hash a set of values using the same 
 algorithm, and see if any
  of those hashes match your hash.

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237474
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: hash question

2006-04-11 Thread Andy Matthews
He forgot your password Oleg.

:)

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

-Original Message-
From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 3:54 PM
To: CF-Talk
Subject: RE: hash question


Did you forget your password, which was hashed?

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: jonese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 13:44
To: CF-Talk
Subject: hash question


I'm trying to reverse engineer a hash and i'm not sure what could
product something like this:

931c6ff8d9e365bfb412

the value returned by this system is always 20 chars in length and
only consists of letters and numbers.

no i have no idea what it is but i'm trying to reverse engineer it to
see if i can recreate it.

Anyone know what could create a 20 char hash? if it helps at all this
is coming from an Oracle 10G server.

jonese





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237475
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: hash question

2006-04-11 Thread Deanna Schneider
If it's 10g, it's very possible they're using dbms_crypto to encrypt some
piece of data. You seed it with your own random string of varying lengths.
You basically create a wrapper package for the built-in dbms_crypto package.
Depending on the length of your seed, you'll get different length results.
You'd have to guess their seed, though - for this info to do you any good.
And, unless you have access to the database server, I'm thinking that's
highly unlikely.

However, depending on how carefully they wrote their wrapper proc, you might
be able to guess the decrypt function to call. Not that I advocate that kind
of behavior or anything.



On 4/11/06, jonese [EMAIL PROTECTED] wrote:

 I'm trying to reverse engineer a hash and i'm not sure what could
 product something like this:

 931c6ff8d9e365bfb412

 the value returned by this system is always 20 chars in length and
 only consists of letters and numbers.

 no i have no idea what it is but i'm trying to reverse engineer it to
 see if i can recreate it.

 Anyone know what could create a 20 char hash? if it helps at all this
 is coming from an Oracle 10G server.

 jonese





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237476
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: hash question

2006-04-11 Thread Brad Wood
I think maybe we are a little confused about just what it is that you
are trying to accomplish here.  

Are you trying to write your OWN hashing algorithm?  
Are you trying to find out the original string which was used to produce
this hashed value?  
Are you trying to figure out WHAT hashing algorithm was used to create
this hashed value?

~Brad

-Original Message-
From: jonese [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 3:56 PM
To: CF-Talk
Subject: Re: hash question

right i know this and i have some ideas what data is being hashed but
i cannot figure out how to limit a hash to only 20 chars. most of the
hashing i've even done has been in md5 sha1 etc and this is obviously
not that.

I know this is a long shot but i was hoping that the 20 char limit
might ring a bell to someone.

jonese 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237477
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: hash question

2006-04-11 Thread Oleg Gunkin
It could be one of the following algorithms:
- RIPEMD-160
- SHA-0
- SHA-1
- Tiger-160



--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: jonese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 13:44
To: CF-Talk
Subject: hash question


I'm trying to reverse engineer a hash and i'm not sure what could
product something like this:

931c6ff8d9e365bfb412

the value returned by this system is always 20 chars in length and
only consists of letters and numbers.

no i have no idea what it is but i'm trying to reverse engineer it to
see if i can recreate it.

Anyone know what could create a 20 char hash? if it helps at all this
is coming from an Oracle 10G server.

jonese



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237478
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: hash question

2006-04-11 Thread jonese
I'm trying to figure out what hashing algorithm was used to create
this hashed value. then  I'll was 10 or 15 minutes trying to reproduce
the hash. if nothing comes of it then I'll move on with life.

background: this webservice thing I've been working on is in a BETA so
there is a lot of stuff you can't do, like pull product image paths
etc from it (which is important for a shopping cart). Well i found a
backdoor (yes it's a legal one) which uses a simple HTTP request and
that produces an image. The issue is that for some reason the service
provided have added this extra hash onto each url link and each
image has it's own hash (along with a client id, and a media id).

SO i just figured if i could find out what produced the 20 char hash /
string maybe i could reproduce it with by tossing in a couple of
items.

so far it seems like this won't happen so I'll have to hope they open
up image grabbing in the webservice sooner rather than later.

jonese

On 4/11/06, Brad Wood [EMAIL PROTECTED] wrote:
 I think maybe we are a little confused about just what it is that you
 are trying to accomplish here.

 Are you trying to write your OWN hashing algorithm?
 Are you trying to find out the original string which was used to produce
 this hashed value?
 Are you trying to figure out WHAT hashing algorithm was used to create
 this hashed value?

 ~Brad

 -Original Message-
 From: jonese [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 3:56 PM
 To: CF-Talk
 Subject: Re: hash question

 right i know this and i have some ideas what data is being hashed but
 i cannot figure out how to limit a hash to only 20 chars. most of the
 hashing i've even done has been in md5 sha1 etc and this is obviously
 not that.

 I know this is a long shot but i was hoping that the 20 char limit
 might ring a bell to someone.

 jonese


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237479
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 and 64 Bit Windows 2K3

2006-04-11 Thread Jim Curran
 Hey all,
 
 I am commissioning a new server and was going to get dual 64bit AMD
 processors and 64 bit Windows.  Some articles speak how this is good
 because the 1.8 GB mem limit is not longer a consideration.  I just read
 that CF does not work on 64 Bit windows at all:
 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=baec9c0c 
 
 I am not concerned about the performance gains of 64 bit processing at
 this time, but I don't want to build a new machine now when CF should be
 supporting 64 bit in the near future.
 
 Does anyone have any insight on what I should do?
 
 TIA!
 
 - j
 
 James Curran
 Nylon Technology
 350 Seventh Avenue
 10th Floor
 New York, NY 10001
 212.691.1134 x11 
 212.691.3477 fax
 [EMAIL PROTECTED]
 www.nylontechnology.com
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237480
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 and 64 Bit Windows 2K3

2006-04-11 Thread Damien McKenna
 -Original Message-
 From: Jim Curran [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, April 11, 2006 5:37 PM
 
 I am commissioning a new server and was going to get dual 64bit AMD
 processors and 64 bit Windows.  Some articles speak how this is good
 because the 1.8 GB mem limit is not longer a consideration.  I just
 read that CF does not work on 64 Bit windows at all:

How about running it on 64bit Linux or Solaris?

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237481
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 and 64 Bit Windows 2K3

2006-04-11 Thread Munson, Jacob
AMD's 64 bit processor supports 32 bit programs, so if you build your 64
bit machine now, when CF supports 64 bit later, you're all set.
Assuming it's not too much trouble to upgrade your OS and such, when the
time comes. 

 -Original Message-
 From: Jim Curran [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, April 11, 2006 3:37 PM
 To: CF-Talk
 Subject: CF and 64 Bit Windows 2K3
 
  Hey all,
  
  I am commissioning a new server and was going to get dual 64bit AMD
  processors and 64 bit Windows.  Some articles speak how this is good
  because the 1.8 GB mem limit is not longer a consideration. 
  I just read
  that CF does not work on 64 Bit windows at all:
  
 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=baec9c0c 
  
  I am not concerned about the performance gains of 64 bit 
 processing at
  this time, but I don't want to build a new machine now when 
 CF should be
  supporting 64 bit in the near future.
  
  Does anyone have any insight on what I should do?

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237482
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


Distinct value count (SQL)

2006-04-11 Thread Ben Nadel
So, I have to do queries occassionally where I have to get the count of
unique items in a query. I don't want to return the items, I just want to
count them. I end up doing something like:

-+
SELECT
COUNT(*) AS user_count
FROM
(
SELECT DISTINCT 
o.user_id
FROM
orders o
) AS t1 
-+

I always hate doing it this way as it seems like an extra step that there
must be a way to avoid. And, I know zero about how SQL works behind the
scenes, but this just seems like it would need to create some temp table,
which may or may not be the best way. 

I tried to do the following, but id returns the count of each group, not of
the record set.

-+
SELECT
COUNT(*) AS user_count
FROM
orders o
GROUP BY
o.user_id
-+

So, any suggestions? Or is this just a two part process??

Thanks,
...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237483
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: CFC Root

2006-04-11 Thread Stan Winchester
It would be better to create a CF mapping named /abc to a location outside of 
the webroot, such as E:/projects/abc.com/com/abc/ and then create cfc  
customtag directories under the new mapping. You would end up with:

  E:/projects/abc.com/com/abc/cfc/
  E:/projects/abc.com/com/abc/customtags/

You would then access your cfc's using the mapping abc.cfc.mycfc
For custom tags you could use cfmodule 
template=abc/customtags/mycustomtag.cfm...

Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
http://www.aftershockweb.com/

Hi,

I have a simple code to create a dynamic CFC root and it works for my local
system (WinMCE 2005).

cfset request.cfcroot =
#Replace(listDeleteAt(cgi.script_name,listlen(cgi.script_name,'/'),'/'),'/'
,'','ALL')#.  cfc

As an example 'E:/projects/abc.com/www/' is my webroot.

When I have a cfc file like 'www/cfc/image.cfc', I can
reach this cfc from my 'E:/projects/abc.com/www/test.cfm' page with a syntax
such as 

cfset application.imageCFC =
createobject(component,#request.cfcroot#.image) / 



But there are problems on Win2003 Servers.

Do you have anything like that? What would you suggest as alternative?


Sincerely,

Oðuz Demirkapý

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237484
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: Distinct value count (SQL)

2006-04-11 Thread Nick Han
Ben,

  Do this, assuming you're using sql server.
  

Select count(distinct user_id)
From orders


-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 2:51 PM
To: CF-Talk
Subject: Distinct value count (SQL)

So, I have to do queries occassionally where I have to get the count of
unique items in a query. I don't want to return the items, I just want
to
count them. I end up doing something like:

-+
SELECT
COUNT(*) AS user_count
FROM
(
SELECT DISTINCT 
o.user_id
FROM
orders o
) AS t1 
-+

I always hate doing it this way as it seems like an extra step that
there
must be a way to avoid. And, I know zero about how SQL works behind the
scenes, but this just seems like it would need to create some temp
table,
which may or may not be the best way. 

I tried to do the following, but id returns the count of each group, not
of
the record set.

-+
SELECT
COUNT(*) AS user_count
FROM
orders o
GROUP BY
o.user_id
-+

So, any suggestions? Or is this just a two part process??

Thanks,

Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237485
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: CFC Root

2006-04-11 Thread Oğuz_Demirkapı
I have a project now that I have 4 different servers to test it.

And I thought that if I would have a general solution such as relational files 
that would be nice. :)



-Original Message-
From: Stan Winchester [mailto:[EMAIL PROTECTED] 
Sent: Dienstag, 11. April 2006 23:58
To: CF-Talk
Subject: Re: CFC Root

It would be better to create a CF mapping named /abc to a location outside of 
the webroot, such as E:/projects/abc.com/com/abc/ and then create cfc  
customtag directories under the new mapping. You would end up with:

  E:/projects/abc.com/com/abc/cfc/
  E:/projects/abc.com/com/abc/customtags/

You would then access your cfc's using the mapping abc.cfc.mycfc
For custom tags you could use cfmodule 
template=abc/customtags/mycustomtag.cfm...

Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
http://www.aftershockweb.com/

Hi,

I have a simple code to create a dynamic CFC root and it works for my local
system (WinMCE 2005).

cfset request.cfcroot =
#Replace(listDeleteAt(cgi.script_name,listlen(cgi.script_name,'/'),'/'),'/'
,'','ALL')#.  cfc

As an example 'E:/projects/abc.com/www/' is my webroot.

When I have a cfc file like 'www/cfc/image.cfc', I can
reach this cfc from my 'E:/projects/abc.com/www/test.cfm' page with a syntax
such as 

cfset application.imageCFC =
createobject(component,#request.cfcroot#.image) / 



But there are problems on Win2003 Servers.

Do you have anything like that? What would you suggest as alternative?


Sincerely,

Oðuz Demirkapý



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237486
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: Distinct value count (SQL)

2006-04-11 Thread Ben Nadel
Oh, that's hot! 

Thanks!
...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.
-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 6:01 PM
To: CF-Talk
Subject: RE: Distinct value count (SQL)

Ben,

  Do this, assuming you're using sql server.
  

Select count(distinct user_id)
From orders


-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 2:51 PM
To: CF-Talk
Subject: Distinct value count (SQL)

So, I have to do queries occassionally where I have to get the count of
unique items in a query. I don't want to return the items, I just want to
count them. I end up doing something like:

-+
SELECT
COUNT(*) AS user_count
FROM
(
SELECT DISTINCT 
o.user_id
FROM
orders o
) AS t1 
-+

I always hate doing it this way as it seems like an extra step that there
must be a way to avoid. And, I know zero about how SQL works behind the
scenes, but this just seems like it would need to create some temp table,
which may or may not be the best way. 

I tried to do the following, but id returns the count of each group, not of
the record set.

-+
SELECT
COUNT(*) AS user_count
FROM
orders o
GROUP BY
o.user_id
-+

So, any suggestions? Or is this just a two part process??

Thanks,
.
Ben Nadel
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237487
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 and 64 Bit Windows 2K3

2006-04-11 Thread Jim Curran
So in this case, I need to stay with the 32 bit version of Windows?

Also, any idea when CF will work w/ 64bit processing?

- j 

-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 5:50 PM
To: CF-Talk
Subject: RE: CF and 64 Bit Windows 2K3

AMD's 64 bit processor supports 32 bit programs, so if you build your 64 bit
machine now, when CF supports 64 bit later, you're all set.
Assuming it's not too much trouble to upgrade your OS and such, when the
time comes. 

 -Original Message-
 From: Jim Curran [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 11, 2006 3:37 PM
 To: CF-Talk
 Subject: CF and 64 Bit Windows 2K3
 
  Hey all,
  
  I am commissioning a new server and was going to get dual 64bit AMD 
  processors and 64 bit Windows.  Some articles speak how this is good 
  because the 1.8 GB mem limit is not longer a consideration.
  I just read
  that CF does not work on 64 Bit windows at all:
  
 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=baec9c0c
  
  I am not concerned about the performance gains of 64 bit
 processing at
  this time, but I don't want to build a new machine now when
 CF should be
  supporting 64 bit in the near future.
  
  Does anyone have any insight on what I should do?

This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you. A1.





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237488
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


DailyRazor Hosting

2006-04-11 Thread Steve Durette
Anyone have any thoughts on DailyRazor Hosting?

I need a host that will allow multiple domains.  I'm going to be doing the 
websites for a couple of non-profit clubs so this is going to be all out of my 
pocket.  What I really need is to host 3 websites (mine plus the 2 clubs), and 
DailyRazor is the only one that I have seen that lets you host multiple 
domains.  Only problem is that their plans jump from 2 domains to 8 domains 
with a difference in price of 2 domains for $120 per year and 8 domains at $215 
per year.  The fact that they allow unlimited e-mail addresses is nice (30 
minimum required).

I know that there did used to be some places that hosted non-profits for free, 
but I can't find them anymore.

I have looked through the recent messages and did research on the hosting 
services that were listed, but so far DailyRazor has the most for the least 
amount of money.  

Thanks for the help.
Steve

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237489
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: DailyRazor Hosting

2006-04-11 Thread Rob Wilkerson
I used to have a dedicated server at...ValueWeb, I believe.  Dedicated
Linux server.  Installed a name server on it and hosted all the
domains I wanted.  Might want to take a look at what they offer.  Cost
me $60 a month, if memory serves.  Had it for a couple of years ago
and only let it go a few months ago due to lack of use.

I imagine their prices have gone up, but maybe not by much.

http://valueweb.com/

On 4/11/06, Steve Durette [EMAIL PROTECTED] wrote:
 Anyone have any thoughts on DailyRazor Hosting?

 I need a host that will allow multiple domains.  I'm going to be doing the 
 websites for a couple of non-profit clubs so this is going to be all out of 
 my pocket.  What I really need is to host 3 websites (mine plus the 2 clubs), 
 and DailyRazor is the only one that I have seen that lets you host multiple 
 domains.  Only problem is that their plans jump from 2 domains to 8 domains 
 with a difference in price of 2 domains for $120 per year and 8 domains at 
 $215 per year.  The fact that they allow unlimited e-mail addresses is nice 
 (30 minimum required).

 I know that there did used to be some places that hosted non-profits for 
 free, but I can't find them anymore.

 I have looked through the recent messages and did research on the hosting 
 services that were listed, but so far DailyRazor has the most for the least 
 amount of money.

 Thanks for the help.
 Steve

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237490
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: DailyRazor Hosting

2006-04-11 Thread Jordan Michaels
Steve Durette wrote:
 Anyone have any thoughts on DailyRazor Hosting?
 
 I need a host that will allow multiple domains.  I'm going to be doing the 
 websites for a couple of non-profit clubs so this is going to be all out of 
 my pocket.  What I really need is to host 3 websites (mine plus the 2 clubs), 
 and DailyRazor is the only one that I have seen that lets you host multiple 
 domains.  Only problem is that their plans jump from 2 domains to 8 domains 
 with a difference in price of 2 domains for $120 per year and 8 domains at 
 $215 per year.  The fact that they allow unlimited e-mail addresses is nice 
 (30 minimum required).
 
 I know that there did used to be some places that hosted non-profits for 
 free, but I can't find them anymore.
 
 I have looked through the recent messages and did research on the hosting 
 services that were listed, but so far DailyRazor has the most for the least 
 amount of money.  
 
 Thanks for the help.
 Steve

Hi Steve,

How would you feel about a VPS Account? You can host all the domains you
want off of it and it only costs 19.95 per month. We offer BlueDragon
Server JX as a free add-on to our VPS Accounts so you can host CFML
sites on it as well. BlueDragon Server JX won't always be a free add-on,
as we're currently just trying to help the BlueDragon community grow,
but we're offering it free at the moment. ;)

In addition, we also offer free, no-obligation 7-day trials. So if you
just want to give us a shot and see how a VPS feels, you can do it
without any financial risk.

Hopefully this helps you, and feel free to let us know if you have any
questions alright?

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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237491
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: WAR File Deployment

2006-04-11 Thread Denny Valliant
Doh! my bad, you'd definately need the multi-server install.  Or super
hacking skillz maybe.
:D

 If you re-install, pick the middle option. You want jrun (unless you're
gonna try jboss, but... that's a whole other ball of wax)

On 4/11/06, Douglas Knudsen [EMAIL PROTECTED] wrote:

 if you dont' have a jrun4/servers/cfusion-ear folder, you probably do
 not have the enterprise version.  IIRC, you can' deploy WARs on the
 standard license...i could be wrong on that.

 DK

 On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:
  try dropping the WAR under servers/cfusion-ear
  
  DK
  
  On 4/11/06, Jonathon Parker [EMAIL PROTECTED] wrote:
  
 
  Thanks for responding, but I don't have a JRun administrator and can't
 find a folder named servers/cfusion-ear.  I am running CFusion on IIS.  Is
 that significant?
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237492
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


Template Not Found Error

2006-04-11 Thread Les Mizzell
I've a site on a shared server. Admin has added my requested error 
document site-map.cfm as requested to the apache container file.

This works great for any .html pages, but ignores .cfm templates.

So, in my application.cfc file, shouldn't the below redirect to the 
defined template?

cffunction name=onRequestStart returnType=boolean output=true

cferror
type = exception
template = site-map.cfm
exception = template


It don't.

Do I have the total wrong idea here, or what do I have wrong?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237493
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: VHS and Betamax

2006-04-11 Thread Denny Valliant
 Socially I think we allow computers to hand-cuff us.


Socially? As in people don't get out enought and meet in
meat-space? Or our interactions, even on-line?

 Well, maybe if the optimization is as swell as it's said
  to be.  I can't help but feel that even as smart as
  computers are, there are areas that a human could see a
  pattern before the computer could. Or whatever.

 Is this a response to my comment about why I'm not bothered by the
 fact that the ColdFusion server generates java code? (another good
 example of which is that the server used to generate C++ code (at
 least I thought I remembered somebody saying such), and my knowledge
 of C++ wasn't helpful when I worked with ColdFusion then either)


More along the lines of over helpful generation.  The old mac OS always
kind of bugged me.  It was SO arcane to do underlying stuff, ya know? I
guess that was cool too.  But you ever feel so abstracted that you are no
longer in control? I guess that's bad design or interface or something more
than abstraction...

The computer still doesn't know the goal (yet), so it has to consider all
options, picking what it thinks you want. Your comment about hoping
the macromedia engeneers thought about this stuff... some dude some
where put some logic in there, there is no law of nature stating that it
doesn't matter once your at a higher level. Man, that made sense.

Maybe you're right, and it's a moot point, but I think understanding
something to it's core is worthy. Actually considering the difference of
running the same code on a 64 bit or a 32 bit.  It's nice to know it
should just work, but I really like that intuitive guess type stuff that
happens when you start understanding the nature of something.

How did you know to look there to fix that?
I dunno, it just made sense.

Sometimes stuff doesn't work, even tho we're told at the high level
it should.  Then what. :-P  Ya gotta dig in. If you dig that kind of
stuff. I guess you could also just say, hey person who's thing my
thing doesn't work with, why aren't you standard?. Or wait for
the person who's job it is to do that part figures it out.


  Guess the argument about optimization has some validity,
  yet I can't help see history repeat itself. Every few
  years there's this idea that it doesn't matter, we're
  getting bigger, faster processors, more RAM, etc.. Yet
  the real idea is to conserve energy. Sorta. I guess make
  less go further.  That's never going to change, no
  matter how much power there is. It's the nature of
  power - corruption and responsibility aside.

 No not entirely. The issue is that we're still in transition. The
 hardware progress is not as fast as many of us would like and
 sometimes we jump the gun with regard to wanting to be able to have
 the Star Trek computer that we just tell what to do and it does it. So
 if I build an application today and I fail to optimize it , then my
 application is going to be slow in comparison to another application
 which accomplishes the same task. (Incidentally I spend quite a bit of
 my programming time thinking about the optimization of my software --
 I may not always get it right, but I do have a reasonable handle on
 the concepts.)

 Skip forward 20 years.


I guess our ideas of optimization are different.

When I think of optimization, it's not necessarily speed.  There are
so many areas to optimize, many of which have nothing to do with
processors or memory.  And much optimization is usefull later on.

I would think.  At least it seems kind of evolving, or whatever.


All that being said of course, anyone can screw up a good thing and
 it's not very difficult to accomplish. There are lots of times that


Ha!! That kills me. Listen to this:
I had the bright idea to instead of having tables with different data-
types, I'd have tables all of one data-type, and use a key and another
table to keep track of what was where or whatever.

Long story short, it's death by a thousand queries.  I had to make
some cache tables in the end, just to keep it all together. Bleh.
I'd had some SQL generating stuff already tho so the cache wasn't
too hard to wrangle. And now everything is a lot faster, so long as
I can get my cache-keeper-up-to-dater working optimally.

 Sorta saying it's all data, but some data is much
  easier to parse than other data is. By much I
  mean astronomically.

 Oh. Okay... Yes, admittedly. :)
 Hence much of the reason behind XML.


Indeed. I thought that was all the reason. ;-)

An object on disk, an object in mem... um. let me try to think
of how to express what I'm thinking.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237494
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: 

Need Help Installing Plugins for Eclipse IDE

2006-04-11 Thread Aaron Roberson
I have downloaded several .zip files of various plugins for Eclipse
(such as Flex 2 SDK, JavaScript Editor, CSS Editor, etc. etc.) but I
can't figure out how to install them in Eclipse so that I can open up
a new perspective (JavaScript or CSS perspective for example).

Can anyone tell me how to use third party plugins with Eclipse?

Thanks,
Aaron

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237495
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