Re: Embedding Flash Files in CF Page

2009-09-04 Thread Chris Montgomery

Well, after trying everything I can think of, this isn't working. Could 
there possibly be some mime type issues with the .flv files? I'm testing 
this on my local development box, WinXP Pro, CF8, using the built-in web 
server with CF.

Jason Fisher said the following on 9/4/2009 6:14 PM:
> Get a copy of swfobject.js from Google Code 
> (http://code.google.com/p/swfobject/) and then get a copy of 
> mediaplayer.swf (can be free, depending: 
> http://www.longtailvideo.com/players/jw-flv-player/).
> 
> Put this in the :
> 
> 
> Then put this on your page:
> 
> 
> 
> 
> 
> That should get you started ...

-- 
Best regards,

Chris Montgomery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326031
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: getting min value based on inputs

2009-09-04 Thread brad

Well, there's always the brute force method.

I believe it would take #plans x #lines tries to complete, but the good
news multiplication and addition are very fast operations even when done
millions of times. :)

I don't think there is any algorithm or equation you can use since there
is no real pattern or method to the different plans.  

~Brad

 Original Message 

 Subject: getting min value based on inputs
 From: Greg Morphis 
 Date: Fri, September 04, 2009 2:37 pm
 To: cf-talk 
 
 
 I was wondering if this is even possible.
 given a list of plans...



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326030
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Gerald Guido

>
> Out of the companies you listed, I've only ever used Facebook, Flickr,
> Google, eBay, iStockPhoto, Ticketmaster, and Yahoo.
>
> I'm not saying this is a litmus test, but with the exception of maybe Yahoo
> ( but I haven't really used Yahoo THAT much ), I have always consciously
> THOUGHT as I used every single one of those other sites that their
> performance was pretty lackluster.



Searching for the letter "a" on google.

"Results *1* - *100* of about *17,790,000,000* for *a*. (*0.16* seconds) "

But yeah That isn't a MySLQ query. Gmail can be sluggish but I think it
is more of a JS engine issue more than anything else.


Better IDE and tools ( the MySQL enterprise tools, at least the ones I've
> used, are all but a joke ).
>
>
The MySQL software bundle is pretty crappy. I stopped using them years ago.
I was never able to get the migration tools to work right.

However, SQLyog, Toad for MySQL and the EMS tools rock IMHO.

>> a genetic allergy to Microsoft.

Now that is funny.

But yeah, I moved to MySQL cuz it was free and I was a freelancer at the
time. $5k is a lot of beer and donuts.

But at the same time, I have been able to do things with DTS and SSIS that
are pretty stunning. Like import a 25 meg MLS XML file in what I can only
describe as being a blip. That was in 2003 though. I haven't looked at
MySQL's tool set in that respect since then.

G!


-- 
Gerald Guido
http://www.myinternetisbroken.com

"To invent, you need a good imagination and a pile of junk."
-- Thomas A. Edison


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326029
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Stung by HostMySite price increase?

2009-09-04 Thread brad

 curious as to why anyone would want to switch from MySQL to MSSQL..
 a quick look at mysql.com/customers showed the following:
 facebook
 feedster
 flickr
 fotolog


Let's be very clear about the different versions of MySQL.  Chances are
when someone says they are using MySQL, they probably have the free
version.  I guarantee you facebook and company are paying the healthy 5
grand per server for the Enterprise version of MySQL which comes with
unlimited tech support, GUI Admins and monitors, etc.  The free version
of MySQL comes with pretty much a set of online docs and a "good luck". 
(Mind you I use MySQL-- the free version-- for my sites and like it very
well).

I'm guessing a lot of people who say they switched from MySQL to MSSQL
probably went from the free version of MySQL to MSSQL.  And if you're a
.NET shop eyeing SQL Server Reporting Services, SQL Server Integration
Services, and the rest of the MS koolaid, there could be a lot of very
good reasons to switch.  I really like MySQL (hey, it's FREE!), but if
money were no object I would be using MSSQL for my personal sites in a
heartbeat.  Well, if my server wasn't Linux that is...  :)

~Brad




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326028
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread David McGuigan

There are about 1,000 reasons I can think of, but I only have limited
experience with SQL Server ( just enough to observe these differences ):
Less administration and maintenance.
Less tuning necessary for pureformance.
Exponentially superior performance out of the box.
A single, superhero storage engine ( which itself has about 1,000 other
benefits IMO ).
Way more stable.
Better IDE and tools ( the MySQL enterprise tools, at least the ones I've
used, are all but a joke ).
Significantly lower total cost of ownership for teams and companies without
expert MySQL in-house knowledge that know how to solve all of MySQL's
shortcomings without investing a lot of time in research and scavenger
hunting ).

Companies use open source ( and free ) software for a variety of reasons.
Usually out of either stubbornness or a genetic allergy to Microsoft.

Out of the companies you listed, I've only ever used Facebook, Flickr,
Google, eBay, iStockPhoto, Ticketmaster, and Yahoo.

I'm not saying this is a litmus test, but with the exception of maybe Yahoo
( but I haven't really used Yahoo THAT much ), I have always consciously
THOUGHT as I used every single one of those other sites that their
performance was pretty lackluster. Obviously we can only speculate as to
what their bottlenecks are/were, how much a factor their scale actually is,
etc, but I have felt, and noticed myself feeling, very disappointed with
their software performance. Clearly MySQL is to blame ( kidding ).




On Fri, Sep 4, 2009 at 7:48 PM, Andrew Grosset  wrote:

>
> >Yes the proc license is really the only way to go... The difficulty in
> >switching depends greatly on your code. IT could be quite easy - or
> require
> >rewriting every query.
> >
> >I recently helped a customer go from MySQL to MSSQL and I wrote a couple
> of
> >posts on it. It will give you an idea of the type of difficulty you might
> >encounter.
> >
> >http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL
> >
> >
> http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
> >ssql
> >
> >I recently helped a customer go from MySQL to MSSQL and I wrote a couple
> of
> >posts on it. It will give you an idea of the type of difficulty you might
> >encounter.
> >
>
> curious as to why anyone would want to switch from MySQL to MSSQL..
>
> a quick look at mysql.com/customers showed the following:
>
> facebook
> feedster
> flickr
> fotolog
>
> and that was just in "f"
>
> also found craigslist, ebay, Google, istockphoto, ticketmaster, webtrends,
> yahoo and the list goes on and on...
>
> I found the switch fairly easy, definitely worth a look as its free to
> download.
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326027
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Dave Watts

> curious as to why anyone would want to switch from MySQL to
> MSSQL..

Because it has a much richer set of features, perhaps? Because it can
do a lot of things that MySQL can't?

> a quick look at mysql.com/customers showed the following:
>
> facebook
> feedster
> flickr
> fotolog
>
> and that was just in "f"
>
> also found craigslist, ebay, Google, istockphoto, ticketmaster,
> webtrends, yahoo and the list goes on and on...

That's nice, but irrelevant. You can find a list of companies using
whatever product you can think of.

There are lots of good reasons to use either product. "Because company
X uses it" is not generally one of those reasons, unless your business
needs are identical to company X.

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

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

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326026
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Embedding Flash Files in CF Page

2009-09-04 Thread Chris Montgomery

Jason Fisher said the following on 9/4/2009 9:00 PM:
> Yeah, just give each DIV a unique ID, each video gets its own script 
> block, and then make sure that each so.write() method references its 
> matching DIV's ID, and you'll be good to go.

Great, thanks for the help!

-- 
Best regards,

Chris Montgomery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326025
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFILE UPLOAD

2009-09-04 Thread Dave l

what's the file name?

Seems like I had this one time and the issue was the user was uploading images 
named like: bill's big day.jpg
And the ' was terminated it and giving that error.




>I'm using cffile to upload .mp3 files (among others).
>
>An error is thrown:
>String index out of range: -1
>
>All other file formats I have tried work fine, does anyone know why mp3
>would fail?
>
>Thanks,
>Jenny 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326024
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Embedding Flash Files in CF Page

2009-09-04 Thread Jason Fisher

Yeah, just give each DIV a unique ID, each video gets its own script 
block, and then make sure that each so.write() method references its 
matching DIV's ID, and you'll be good to go.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326023
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Andrew Grosset

>Yes the proc license is really the only way to go... The difficulty in
>switching depends greatly on your code. IT could be quite easy - or require
>rewriting every query.
>
>I recently helped a customer go from MySQL to MSSQL and I wrote a couple of
>posts on it. It will give you an idea of the type of difficulty you might
>encounter.
>
>http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL
>
>http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
>ssql
>
>I recently helped a customer go from MySQL to MSSQL and I wrote a couple of
>posts on it. It will give you an idea of the type of difficulty you might
>encounter.
>

curious as to why anyone would want to switch from MySQL to MSSQL..

a quick look at mysql.com/customers showed the following:

facebook
feedster
flickr
fotolog

and that was just in "f"

also found craigslist, ebay, Google, istockphoto, ticketmaster, webtrends, 
yahoo and the list goes on and on...

I found the switch fairly easy, definitely worth a look as its free to download.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326022
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Embedding Flash Files in CF Page

2009-09-04 Thread Chris Montgomery

Jason Fisher said the following on 9/4/2009 6:14 PM:
> That should get you started ...

Thanks, Jason, I'll give it a whirl. I'll need to tinker with it to have 
it render all six videos (just like the page I cited previously).

-- 
Best regards,

Chris Montgomery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326021
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: url-write and global error handling

2009-09-04 Thread Dave l

He did ask this on the railo list, and then got his ass handed to him 
again

Einstein's ? isn't about url rewriting at all which I told him before but since 
we all know how well he listens, I guess when you get stomped on so many times 
this happens.

His ? is how to change/hide the railo admin url location so the public can't 
get to it. The only part of this that's url re-wrting is that's what people 
suggest to do to hide the admin. 

If I was him I would probably want to hide the admin as well since his password 
is probably either "duck duck" or "goose".

1) disable url-write across board for Resin web server
Why on frickin gods green earth would this be a good idea?
Again what you are asking for REQUIRES URL RE-WRITING you twit

2) global error handling
Well it works for the rest of us, maybe you just don't know wtf you are doing.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326020
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Getting an email address from an email body

2009-09-04 Thread Pete Ruckelshaus

I need to automate the process of removing bounced emails from an email
list.  I have a "failto" email address set when I send mail, and I'm using
cfpop to check that account for bounced messages.  I'm getting the messages
as expected, but I'm trying to figure out how to parse the failed email
address out of the bounced message body, which (usually) looks like this:
This is an automatically generated Delivery Status Notification. Delivery to
the following recipients failed. xxxyyy...@msn.com

Where the message body isn't exactly like that, the bounced email address is
usually the first email address in the message body.

How might I go about extracting the first email address that occurs in a
string?

Thanks!

Pete


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326019
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: url-write and global error handling

2009-09-04 Thread Gerald Guido

>> If you're using railo, why not ask on the railo list?

Given the three strike rule on the Railo mailing list, I would imagine that
he was banninated.

G!


-- 
Gerald Guido
http://www.myinternetisbroken.com

"To invent, you need a good imagination and a pile of junk."
-- Thomas A. Edison


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326018
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT Simple URL Rewrite

2009-09-04 Thread Dominic Watson

Or indeed:

^/test/www/(\d+)$ /test/www/index.cfm?id=$1

They way we are using *ionic* ISAPI rewrite means that it will always start
from the root of the domain. Perhaps lookup editing your hosts file so that
you can have like:

http://localhost.mysite1/
http://localhost.mysite2/

etc.

Then an IIS instance for each site and so a rewrite ruleset for each site.

Dominic

2009/9/4 Matthew Allen 

>
> >Seems to me that you want:
> >
> >^/(\d+)$ index.cfm?id=$1 [NC,L]
> >
> >No?
> >
> >Dominic
> >
> >2009/9/4 Matthew Allen 
> >
> >>
>
> Will try posting again...
>
> Just tried your example but didn't work...
>
> RewriteBase /
> RewriteRule ^/(\d+)$ index.cfm?id=$1 [NC,L]
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326017
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Embedding Flash Files in CF Page

2009-09-04 Thread Jason Fisher

Get a copy of swfobject.js from Google Code 
(http://code.google.com/p/swfobject/) and then get a copy of 
mediaplayer.swf (can be free, depending: 
http://www.longtailvideo.com/players/jw-flv-player/).

Put this in the :


Then put this on your page:





That should get you started ...

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326016
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Embedding Flash Files in CF Page

2009-09-04 Thread Chris Montgomery

Howdy,

I've never worked with Flash files before and now have a need to embed 
some in a CF page. The files are in .FLV format, not .swf. Is there a 
quick tutorial on how to do this in CF? I'm on a CF8 server. FWIW, I 
want to do something like what is on this page: 
http://www.phantomscreens.com/content/video.php.

I need to do this pretty quick so I would greatly appreciate any tips. 
Thanks!

-- 
Best regards,

Chris Montgomery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326015
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT Simple URL Rewrite

2009-09-04 Thread Matthew Allen

>Seems to me that you want:
>
>^/(\d+)$ index.cfm?id=$1 [NC,L]
>
>No?
>
>Dominic
>
>2009/9/4 Matthew Allen 
>
>>

Will try posting again...

Just tried your example but didn't work...

RewriteBase /
RewriteRule ^/(\d+)$ index.cfm?id=$1 [NC,L] 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326014
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT Simple URL Rewrite

2009-09-04 Thread Dominic Watson

Seems to me that you want:

^/(\d+)$ index.cfm?id=$1 [NC,L]

No?

Dominic

2009/9/4 Matthew Allen 

>
> I've just been dabbling in URL rewriter using ISAPI rewrite version 3, I'm
> not really sure what I'm doing wrong.
>
> All I'm trying to do is rewrite http://127.0.0.1/test/www/index.cfm?id=450to
> http://127.0.0.1/test/www/450, so getting rid of index.cfm, ? and id
>
> Looking from past experience I came up with the syntax below but no luck,
> can some please point me to the direction of what I'm doing wrong?
>
> RewriteBase /
> RewriteRule ^index.cfm/(\d+)$ index.cfm?id=$1 [NC,L]
>
> Many thanks,
>
> Matt.
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326013
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: getting min value based on inputs

2009-09-04 Thread Dave Watts

> I was wondering if this is even possible.
> given a list of plans...
>
> ...
>
> And given the user's input of say 10 lines and 9500 minutes. Is it
> possible to come up with the least costly set up that meets the
> requirements? For example. 10 lines 9,500 minutes would be
> 1 @ PLANI = 210.00 (6000 minutes)
> 7 @ PLANC = 294.00 (3500 minutes)
> 2 @ PLANA = 50.00 (0 minutes)
> total = 554.00
>
> You'd think it'd be
> 1 @ PLANI = 210.00 (6000 minutes)
> 1 @ PLANG = 105.00 (2100 minutes)
> 1 @ PLANF = 84.00 (1400 minutes)
> so that satisfies the 9500 minute requirement
> so the other lines would have to go to PLANA
> 7 @ PLANA = 175.00 (0 minutes)
> total = 574.00
>
> Any ideas would be most helpful!

This sounds like a variation of the traveling salesman problem:
http://en.wikipedia.org/wiki/Travelling_salesman_problem

My comp sci knowledge and math skills aren't really good enough to
help you come up with the best solution to your problem, but you might
take a look at the various approximation algorithms out there to find
a solution.

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

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

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326012
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Defaulting 2nd select related select

2009-09-04 Thread Paul Ihrig

got it.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326011
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT Simple URL Rewrite

2009-09-04 Thread Matthew Allen

I've just been dabbling in URL rewriter using ISAPI rewrite version 3, I'm not 
really sure what I'm doing wrong.

All I'm trying to do is rewrite http://127.0.0.1/test/www/index.cfm?id=450 to 
http://127.0.0.1/test/www/450, so getting rid of index.cfm, ? and id

Looking from past experience I came up with the syntax below but no luck, can 
some please point me to the direction of what I'm doing wrong?

RewriteBase /
RewriteRule ^index.cfm/(\d+)$ index.cfm?id=$1 [NC,L]

Many thanks,

Matt. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326010
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


getting min value based on inputs

2009-09-04 Thread Greg Morphis

I was wondering if this is even possible.
given a list of plans...
CodePrice   Minutes
PLANA   $25.00  0
PLANB   $32.00  200
PLANC   $42.00  500
PLAND   $52.00  750
PLANE   $63.00  900
PLANF   $84.00  1,400
PLANG   $105.00 2,100
PLANH   $155.00 4,000
PLANI   $210.00 6,000

And given the user's input of say 10 lines and 9500 minutes. Is it
possible to come up with the least costly set up that meets the
requirements? For example. 10 lines 9,500 minutes would be
1 @ PLANI = 210.00 (6000 minutes)
7 @ PLANC = 294.00 (3500 minutes)
2 @ PLANA = 50.00 (0 minutes)
total = 554.00

You'd think it'd be
1 @ PLANI = 210.00 (6000 minutes)
1 @ PLANG = 105.00 (2100 minutes)
1 @ PLANF = 84.00 (1400 minutes)
so that satisfies the 9500 minute requirement
so the other lines would have to go to PLANA
7 @ PLANA = 175.00 (0 minutes)
total = 574.00

Any ideas would be most helpful!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326009
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: url-write and global error handling

2009-09-04 Thread Will Tomlinson

> A couple of things that I'd like to do with local deployment of my web 
> app using an open source cfml engine.  FYI, I ran some quick search, 
> unsatisfactory.


If you're using railo, why not ask on the railo list?

Will 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326008
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Defaulting 2nd select related select

2009-09-04 Thread Paul Ihrig

i can default the first select just fine.
but the 2nd one is driving me nuts...
http://63.144.103.199/selectbox_binds/region_territory.cfm

the 2 slects part works just fine.
as dowes defaulting the first cfselect




 
 

 


 
  
 


var selectregiondone = false;
var selectterritorydone = false;


function selectregion(x,val) {
if(!selectregiondone) {
var dd = 
document.getElementById('FORMregion_info_id');
for(var i = 0; i < 
dd.length; i++){

if(dd.options[i].value == val){

dd.selectedIndex = i;

}
}
selectregiondone = true;
}
}


function selectterritory(x,val) {

if(!selectterritorydone) {
var dd = 
document.getElementById('FORMterritory_id');
for(var i = 0; i < 
dd.length; i++){

if(dd.options[i].value == val){

dd.selectedIndex = i;

}
}
selectterritorydone = 
true;
}
}


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326007
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Defaulting 2nd select related select

2009-09-04 Thread Paul Ihrig

and the function



 
 
 
 
  
   SELECT territory_id, region_info_id, territory_id AS Tidx
   FROM region_territory_lookup
   WHERE (region_territory_lookup.region_info_id = )
   ORDER BY territory_id
  
 
 
  
   
   
   
  
 
 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326006
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Defaulting 2nd select related select

2009-09-04 Thread Paul Ihrig

 
   Territory: (id:#attributes.territory_id#)
   




  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326005
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: url-write and global error handling

2009-09-04 Thread Don L

Typo correction: url-write should have been url-rewrite

> A couple of things that I'd like to do with local deployment of my web 
> app using an open source cfml engine.  FYI, I ran some quick search, 
> unsatisfactory.
> 
> 1) disable url-write across board for Resin web server
> Know exactly how, not looking for something/block on a similar web 
> server
> 
> The following code seems to touch on security, a quesion is when then 
> how exactly to use this guy to disable admin access other than 127.0.0.
> 1 across board?
> And a related question, why this option?  vs at web root level, set 
> something like if !(#CGI.script# contain "127.0.0.1") cfabort ?  for 
> an application file (cfc or cfm)
> // pls ignore my spelling and exact syntax 
> 
> 
  
> xmlns:resin="urn:java:com.caucho.resin">
   
> 
 
> * 8 * * *
 
> * 16 * * *
   
> 
 
> 
> 
> 
> 2) global error handling
> in the Adobe coldfusion world, a global error handling template,
> called at application level would capture any/all errors if they occur.  
> adobe cf handles three types (request, exception and ? forgot one)
> However, it has not been my experience with open source cfml engine, 
> that is, identical error handling mechanism(only one type, exception 
> if memory serves), the app would randomly or sometimes complained
> about "bla bla file not found" despite correct configuration of 
> everything I think, directory mapping, customtags mapping etc. this 
> sort of problem is real bad for new users, I'm sorry if I'm wrong, 
> loose code, yes, but I would think only spotty not across board, and 
> an app shouldn't pay such penality.
> 
> Thanks for your time. 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Billy Cox

SQL Server Express isn't an option due to size limitations, although we 
may scale back from Standard edition to Workgroup. We chose Standard 
initially in order to take advantage of SSIS, but we haven't had the 
time to become proficient with SSIS and have moved our old DTS scheduled 
jobs to CF scheduled tasks.


Judah McAuley wrote:
> Like most things, the answer to all your questions is "it depends".
>
> If you have an app that doesn't have a big load, SQL Server Express
> might do fine for you. It is free but will only use 1 processor core,
> 1 GB of RAM and has a 4 GB database size limitation.
>
> Porting over to MySql can be very easy or pretty difficult. A lot
> depends on how you write your code. Do you use an ORM like Transfer or
> Reactor? If so, then you don't have to worry about the back end db as
> it is abstracted and the ORM will take care of the db-specific details
> for you. Do you use a lot of TSQL in your queries? If you have
> MSSQL-specific code strewn all over, like using SCOPE_IDENTITY() to
> get back a newly inserted autoincrement id, then you'll have more work
> to do to translate that over to MySQL-specific equivalents.
>
> I'd try setting your app up with MySql. See what breaks. Then try it
> with SQL Server Express and do some load testing. See what happens.
> That should give you some guidance.
>
> Cheers,
> Judah
>
> On Fri, Sep 4, 2009 at 8:18 AM, Billy Cox wrote:
>   
>> We recently got a note from HostMySite (now Hosting.com) telling us
>> about a big price increase in SQL Server licensing. We've had a
>> dedicated server with HMS for about a year and the mere thought of
>> shopping for a new hosting provider makes me feel tired.
>>
>> Has anyone else encountered this?
>>
>> We have considered purchasing our own SQL Server licensing and I am
>> wondering (predictably) whether a processor license is the only way to
>> go for a web app database.
>>
>> How hard is it to switch from SQL Server to MySQL?
>>
>> --
>> *Billy Cox*
>> IT Manager
>> *Old World Spices*
>> bi...@oldworldspices.com
>> 816.861.0400 x138
>>
>>
>>
>>
>> 
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326003
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


url-write and global error handling

2009-09-04 Thread Don L

A couple of things that I'd like to do with local deployment of my web app 
using an open source cfml engine.  FYI, I ran some quick search, unsatisfactory.

1) disable url-write across board for Resin web server
Know exactly how, not looking for something/block on a similar web server

The following code seems to touch on security, a quesion is when then how 
exactly to use this guy to disable admin access other than 127.0.0.1 across 
board?
And a related question, why this option?  vs at web root level, set something 
like if !(#CGI.script# contain "127.0.0.1") cfabort ?  for an application file 
(cfc or cfm)
// pls ignore my spelling and exact syntax 


  xmlns:resin="urn:java:com.caucho.resin">
   
 * 8 * * *
 * 16 * * *
   
 


2) global error handling
in the Adobe coldfusion world, a global error handling template,
called at application level would capture any/all errors if they occur.  adobe 
cf handles three types (request, exception and ? forgot one)
However, it has not been my experience with open source cfml engine, that is, 
identical error handling mechanism(only one type, exception if memory serves), 
the app would randomly or sometimes complained
about "bla bla file not found" despite correct configuration of everything I 
think, directory mapping, customtags mapping etc. this sort of problem is real 
bad for new users, I'm sorry if I'm wrong, loose code, yes, but I would think 
only spotty not across board, and an app shouldn't pay such penality.

Thanks for your time. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326002
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread David McGuigan

This link: http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
Mentions a Web
edition for $15 per month ( per processor, not core I believe ),
specifically targeted at web apps deployment.

If you end up exploring that and find out that the licensing is just as
simple as that please let us know. I've been repeatedly disappointed with
MySQL and would love to migrate. Thanks.



On Fri, Sep 4, 2009 at 10:06 AM, Mark Kruger  wrote:

>
> Yes the proc license is really the only way to go... The difficulty in
> switching depends greatly on your code. IT could be quite easy - or require
> rewriting every query.
>
> I recently helped a customer go from MySQL to MSSQL and I wrote a couple of
> posts on it. It will give you an idea of the type of difficulty you might
> encounter.
>
> http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL
>
>
> http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
> ssql
>
> Hope this helps (a little)
>
>
> Mark A. Kruger, CFG, MCSE
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
> -Original Message-
> From: Billy Cox [mailto:bi...@oldworldspices.com]
> Sent: Friday, September 04, 2009 10:18 AM
> To: cf-talk
> Subject: Stung by HostMySite price increase?
>
>
> We recently got a note from HostMySite (now Hosting.com) telling us about a
> big price increase in SQL Server licensing. We've had a dedicated server
> with HMS for about a year and the mere thought of shopping for a new
> hosting
> provider makes me feel tired.
>
> Has anyone else encountered this?
>
> We have considered purchasing our own SQL Server licensing and I am
> wondering (predictably) whether a processor license is the only way to go
> for a web app database.
>
> How hard is it to switch from SQL Server to MySQL?
>
> --
> *Billy Cox*
> IT Manager
> *Old World Spices*
> bi...@oldworldspices.com
> 816.861.0400 x138
>
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326001
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Stung by HostMySite price increase?

2009-09-04 Thread Mark Kruger

Yes the proc license is really the only way to go... The difficulty in
switching depends greatly on your code. IT could be quite easy - or require
rewriting every query.

I recently helped a customer go from MySQL to MSSQL and I wrote a couple of
posts on it. It will give you an idea of the type of difficulty you might
encounter.

http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL

http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
ssql

Hope this helps (a little) 


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Billy Cox [mailto:bi...@oldworldspices.com] 
Sent: Friday, September 04, 2009 10:18 AM
To: cf-talk
Subject: Stung by HostMySite price increase?


We recently got a note from HostMySite (now Hosting.com) telling us about a
big price increase in SQL Server licensing. We've had a dedicated server
with HMS for about a year and the mere thought of shopping for a new hosting
provider makes me feel tired.

Has anyone else encountered this?

We have considered purchasing our own SQL Server licensing and I am
wondering (predictably) whether a processor license is the only way to go
for a web app database.

How hard is it to switch from SQL Server to MySQL?

--
*Billy Cox*
IT Manager
*Old World Spices*
bi...@oldworldspices.com
816.861.0400 x138





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326000
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Gerald Guido

Strike the red gate reference IIRC they are pretty much SQL Server centric.
Sorry about that...

G!

On Fri, Sep 4, 2009 at 11:43 AM, Gerald Guido wrote:

> >>
> How hard is it to switch from SQL Server to MySQL?
>
> That is a very open ended question. The answer to which could run the gamut
> from "Not that hard at all" to "A freakin' nightmare".
>
> It all depends on how you are using SQL Sever. Do you use SSIS? Do you use
> any SQL or T-SQL that is particular to SQL Server's dialect?
>
> I moved a bunch of apps to MySQL a few years ago and it was fairly
> painless. But then again they were very Plain Jane SQL wise.
>
> There are plenty of tools out there to ease that sort of migration. EMS
> comes to mind as does Red Gate.
>
> http://sqlmanager.net/
> http://www.red-gate.com
>
> HTH
> G!
>
> --
> Gerald Guido
> http://www.myinternetisbroken.com
>
> "To invent, you need a good imagination and a pile of junk."
> -- Thomas A. Edison
>



-- 
Gerald Guido
http://www.myinternetisbroken.com

"To invent, you need a good imagination and a pile of junk."
-- Thomas A. Edison


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325999
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Gerald Guido

>>
How hard is it to switch from SQL Server to MySQL?

That is a very open ended question. The answer to which could run the gamut
from "Not that hard at all" to "A freakin' nightmare".

It all depends on how you are using SQL Sever. Do you use SSIS? Do you use
any SQL or T-SQL that is particular to SQL Server's dialect?

I moved a bunch of apps to MySQL a few years ago and it was fairly painless.
But then again they were very Plain Jane SQL wise.

There are plenty of tools out there to ease that sort of migration. EMS
comes to mind as does Red Gate.

http://sqlmanager.net/
http://www.red-gate.com

HTH
G!

-- 
Gerald Guido
http://www.myinternetisbroken.com

"To invent, you need a good imagination and a pile of junk."
-- Thomas A. Edison


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325998
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread Judah McAuley

Like most things, the answer to all your questions is "it depends".

If you have an app that doesn't have a big load, SQL Server Express
might do fine for you. It is free but will only use 1 processor core,
1 GB of RAM and has a 4 GB database size limitation.

Porting over to MySql can be very easy or pretty difficult. A lot
depends on how you write your code. Do you use an ORM like Transfer or
Reactor? If so, then you don't have to worry about the back end db as
it is abstracted and the ORM will take care of the db-specific details
for you. Do you use a lot of TSQL in your queries? If you have
MSSQL-specific code strewn all over, like using SCOPE_IDENTITY() to
get back a newly inserted autoincrement id, then you'll have more work
to do to translate that over to MySQL-specific equivalents.

I'd try setting your app up with MySql. See what breaks. Then try it
with SQL Server Express and do some load testing. See what happens.
That should give you some guidance.

Cheers,
Judah

On Fri, Sep 4, 2009 at 8:18 AM, Billy Cox wrote:
>
> We recently got a note from HostMySite (now Hosting.com) telling us
> about a big price increase in SQL Server licensing. We've had a
> dedicated server with HMS for about a year and the mere thought of
> shopping for a new hosting provider makes me feel tired.
>
> Has anyone else encountered this?
>
> We have considered purchasing our own SQL Server licensing and I am
> wondering (predictably) whether a processor license is the only way to
> go for a web app database.
>
> How hard is it to switch from SQL Server to MySQL?
>
> --
> *Billy Cox*
> IT Manager
> *Old World Spices*
> bi...@oldworldspices.com
> 816.861.0400 x138
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325997
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Stung by HostMySite price increase?

2009-09-04 Thread Billy Cox

We recently got a note from HostMySite (now Hosting.com) telling us 
about a big price increase in SQL Server licensing. We've had a 
dedicated server with HMS for about a year and the mere thought of 
shopping for a new hosting provider makes me feel tired.

Has anyone else encountered this?

We have considered purchasing our own SQL Server licensing and I am 
wondering (predictably) whether a processor license is the only way to 
go for a web app database.

How hard is it to switch from SQL Server to MySQL?

-- 
*Billy Cox*
IT Manager
*Old World Spices*
bi...@oldworldspices.com
816.861.0400 x138



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325996
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4