re: Coldfusion and lucene

2005-05-31 Thread dave
dont know about using with cfm but this was up today http://today.java.net/pub/a/today/2003/07/30/LuceneIntro.html ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((%

RE: Coldfusion and lucene

2005-05-31 Thread James Holmes
5 seconds googling turned up: http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_ coldfusion.html He wrote a CFDJ article that covers the same topic too: http://cfdj.sys-con.com/read/42053.htm -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent:

CF Precompilation filenames

2005-05-31 Thread James Holmes
I just wanted to publicly thank Charlie Arehart for this: http://cfdj.sys-con.com/read/41684.htm and this: http://cfmxplus.blogspot.com/2002_09_29_cfmxplus_archive.html Using that I was able to write a simple form that takes a file path and spits out the correct class filename to which CF

RE: Coldfusion and lucene

2005-05-31 Thread vishnu prasad
Hi i followe the steps mentioned in that site only already (http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_ coldfusion.html) But i got the following error Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this

(SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread James Holmes
It is common for best practices docs to advise that we should use a join in preference to a subquery wherever possible, since the subquery prevents the DB from creating the execution plan it could with a join. This is probably quite true most of the time. However I just discovered a situation (in

DatePart problem

2005-05-31 Thread Mark Henderson
I want to extract the month from a date that is in the format dd/m/, so I've tried using DatePart (access is the database format). The problem I have is that, by default, DatePart always seems to presume the entry is in the m/dd/ format and thus, it's setting the month from the day

RE: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Mark Smyth
Just a comment, there's often a similar time deficit with using SQL joins on Ingres. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 10:59 To: CF-Talk Subject: (SOT) Joins aren't always better than subqueries (longish post) It is common for best

RE: DatePart problem

2005-05-31 Thread Mark Smyth
Hi Try this, create a new date using dateformat, based on your existing date. cfset tmpdate = dayformat(varName, dd/mm/) Then run datepart on tmpDate I haven't tested it, but it should provide a workaround -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: 31

RE: DatePart problem

2005-05-31 Thread James Holmes
DatePart() expects a CF datetime object, so I'm surprised it works at all with a text date. Parse the date with LSParseDateTime() (assuming you have used setLocale() and then datePart() will work properly: DatePart(LSParseDateTime(12/02/2005)) -Original Message- From: Mark Henderson

Re: anyone bored?

2005-05-31 Thread Joe Rinehart
sure, send me a link On 5/31/05, dave [EMAIL PROTECTED] wrote: and wanna help go thru a site and find bugs? There isn't a lot there but mostly concerned with the shopping cart (its in test mode cc wont be charged) and cross browser issues and just general feedback. It's for

Re: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Jochem van Dieten
James Holmes wrote: It is common for best practices docs to advise that we should use a join in preference to a subquery wherever possible, since the subquery prevents the DB from creating the execution plan it could with a join. This is probably quite true most of the time. It is. But it is

RE: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Micha Schopman
This also depends in the order you join. If your first join returns a large dataset, and the second a smaller dataset it might be interesting to look at rearranging specific statements so you limit the data you work with as fast as possible. Is this something that is happening in you case? Micha

RE: anyone bored?

2005-05-31 Thread Michael T. Tangorre
From: dave [mailto:[EMAIL PROTECTED] and wanna help go thru a site and find bugs? There isn't a lot there but mostly concerned with the shopping cart (its in test mode cc wont be charged) and cross browser issues and just general feedback. It's for www.icandfashion.com, if you are up

OT: PHP Query in Results

2005-05-31 Thread Jillian Koskie
Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: ?php $dbh=mysql_connect (localhost, database, password)

Logic requried

2005-05-31 Thread Asim Manzur
I have a secnerio where user is allowed to upload upto 3 files (images). If he upload 1 file and come back later, he will not allowed to upload again, its one time process. I also need to show the preview to the user that these are the files that he uploaded. He can confirm at this stage or

Re: Logic requried

2005-05-31 Thread Jochem van Dieten
Asim Manzur wrote: I have a secnerio where user is allowed to upload upto 3 files (images). If he upload 1 file and come back later, he will not allowed to upload again, its one time process. I also need to show the preview to the user that these are the files that he uploaded. He can

Re: OT: PHP Query in Results

2005-05-31 Thread Jochem van Dieten
Jillian Koskie wrote: Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: ?php $dbh=mysql_connect

Re: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Jochem van Dieten
Micha Schopman wrote: This also depends in the order you join. If your first join returns a large dataset, and the second a smaller dataset it might be interesting to look at rearranging specific statements so you limit the data you work with as fast as possible. The provided example was very

CF Precompilation filenames

2005-05-31 Thread dcooper
FYI, with CFMX7, code can be precompiled from command prompt or via a checkbox option in the Administrator when building and deploying standalone J2EE WAR/EAR files. Also note that (as of CFMX 6.1) we no longer compile to an intermediate Java source step before generating Java bytecode. We

OT: PHP Query in Results

2005-05-31 Thread Jillian Koskie
Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: ?php $dbh=mysql_connect (localhost, database, password) or

Re: Logic requried

2005-05-31 Thread Asim Manzur
Any sample code will be really appriciated. On 5/31/05, Asim Manzur [EMAIL PROTECTED] wrote: I have a secnerio where user is allowed to upload upto 3 files (images). If he upload 1 file and come back later, he will not allowed to upload again, its one time process. I also need to show

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
I agree with Jochem that you can grab the exact data in one query. However, after seeing the problem from another perspective, your problem lies at the fact that you directly used $pic to print the image name: $pic = mysql_query(select img_name from pics WHERE rntID = 31); echo $pic br; echo

Re: anyone bored?

2005-05-31 Thread Tony Weeg
sure... why not. tw On 5/31/05, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: dave [mailto:[EMAIL PROTECTED] and wanna help go thru a site and find bugs? There isn't a lot there but mostly concerned with the shopping cart (its in test mode cc wont be charged) and cross browser

Re: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Douglas Knudsen
you can also use the aggregates as analytics in Oracle, eh? IIRC, something like SELECT tblunit.unitname, SUM(tblscore.score) OVER (PARTITION BY tblscore.unitid) AS totalscore, FROM tblscore, tblunit WHERE tblscore.unitid = tblunit.unitid this avoids the need for groupby, but does add a twist

RE: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread James Holmes
The difference isn't as large as I first thought, but it is still significant. Here is the real statement (apologies if the formatting gets mangled a bit): SELECT escunits.unitname, SUM (wrkcalcs.score)as WDMSCORE, wrkenrolments.eftsu, wrkperiods.periodname, wrklocations.LOCATION

Re: DatePart problem

2005-05-31 Thread Bert Dawson
Use list functions and CreateDate() to convert you string into a date object, then use DatePart() or Month(): myDateObj = CreateDate(ListGetAt(str, 3, '/'), ListGetAt(str, 2, '/'), ListGetAt(str, 1, '/')); foo = DatePart(myDateObj); Lots of CF functions expect a date object, but if you pass them

Re: Little CMS thing

2005-05-31 Thread Matt Robertson
Lite version won't download from macromedia.com Matt ? Every once in a while someone has that problem. Macromedia.com does a cfcontent push to the download, which in my case is a .cfm file which also does a cfcontent push. Some people's browsers (I'm thinking XP and its latest firewall

Re: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Jochem van Dieten
James Holmes wrote: The joins are all straightforward and the tables contain what they sound like they contain. It takes 4.3 seconds (or so) to run. I'll send the explain output later on if necessary. Please do so. I expect that it will show that the joined version is driven by the

Re: Logic requried

2005-05-31 Thread Jochem van Dieten
Asim Manzur wrote: Any sample code will be really appriciated. What I have is under NDA. But an outline of the idea is pretty much: form onsubmit=confirm() input type=file name=file1 id=file1 input type=file name=file2 id=file2 input type=file name=file3 id=file3 input type=submit

Sandboxing Multiple CF7 Instances?

2005-05-31 Thread John Beynon
Has anyone got sandboxing with multiple CF instances to work? I'm using multiserver config and can get the default cfusion instance to obey sandbox rules (after making appropriate changes to jvm.config) but I can't for the life of me get a second instance to obey it's sandbox rules. In my

RE: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread James Holmes
Your query ran in 2.6 seconds. The explain plan for that is: SELECT STATEMENT Optimizer Mode=CHOOSE SORT GROUP BY NESTED LOOPS MERGE JOIN SORT JOIN NESTED LOOPS NESTED LOOPS TABLE ACCESS FULL DIVWEB.WRKENROLMENTS TABLE

OT: PHP Query Problem

2005-05-31 Thread Jillian Koskie
Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: ?php $dbh=mysql_connect (localhost, database, password) or

CFFORM validation issue in CFMX 7

2005-05-31 Thread Bryan Stevenson
Hey All, I'm posting this for a friend. It seems that in CF 7, instead of the validation function being called in the onSubmit() of CFFORM, there is a direct referenece to a form element's properties referenced i the onSubmit(). Here's some code: FUNCTION FROM CF MX 6 GENERATED BY CFFORM

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: $data = mysql_fetch_object($pic); echo $pic-img_name br /; echo img src=\../images/$pic-img_name\ /; CORRECTION: $pic-img_name should be $data-img_name or, using mysql_fetch_array(): $data =

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: $data = mysql_fetch_object($pic) echo $pic-img_name br /; echo img src=\../images/$pic-img_name\ /; CORRECTION: $pic-img_name should be $data-img_name or, using mysql_fetch_array(): $data =

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: $data = mysql_fetch_object($pic); echo $pic-img_name br /; echo img src=\../images/$pic-img_name\ /; CORRECTION: $pic-img_name should be $data-img_name or, using mysql_fetch_array(): $data =

OT: Hey CF_World

2005-05-31 Thread loathe
Longtime, no see. Back from Afghanistan. How's things? Wanted to touch base with some of my old friends, and they are not all on Community, please email me off list if you want to say hey, don't want to tie up talk. L8rs Tim

OT: PHP Query Problem

2005-05-31 Thread Simon Cornelius P . Umacob
Hi Jillian, Your userlisting at http://regina4rent.com/reg/userlisting.php seems to be working properly. If I may suggest however, I think it would be nice if you'd only display the thumbnail image of your houses. IMHO, I think it would be convenient for the end-user if you won't use the

RE: Rich Internet Applications for Mobile Devices

2005-05-31 Thread Michael Greenberg
You could almost say the same thing for Flash at this point in time...yes it is getting better, but th number of units that have flash installed is still quite low.at least from the numbers Ive seen. MG -Original Message- From: Dave Watts [EMAIL PROTECTED] Sent: May 30, 2005 10:23

Is this possible?

2005-05-31 Thread Che Vilnonis
Is this possible? I have an image that when I mouseover, I want a floating DHTML window to appear and the contents of the window to be the cfdumping of a structure's values? Any thoughts on how to do this? Thanks, Che ~|

RE: Is this possible?

2005-05-31 Thread Burns, John D
You'd probably have to write your own tag to simulate the cfdump. The original cfdump does a bunch of tag closing and stuff to make sure it's not in any sort of unfinished table or whatever. The rest should be easy. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc.

RE: Is this possible?

2005-05-31 Thread Che Vilnonis
ugh, that sounds like fun. :( -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:49 AM To: CF-Talk Subject: RE: Is this possible? You'd probably have to write your own tag to simulate the cfdump. The original cfdump does a bunch of tag

RE: Is this possible?

2005-05-31 Thread Dave Francis
This works (in IE - didn't test any others) div id=A style=display:none cfdump var=#URL# /div img src=xyz.gif width=30 height=30 onMouseover=A.style.display=''; -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:59 AM To: CF-Talk Subject: RE:

Re: anyone bored?

2005-05-31 Thread dave
http://www.icandfashion.com/candstore/Results.cfm?category=0 ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Tony Weeg [EMAIL PROTECTED] Sent: Tuesday,

Re: anyone bored?

2005-05-31 Thread dave
oops, was supposed to be off-list lol well if anyone can find stuff lemme know :) ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Tony Weeg [EMAIL

RE: anyone bored?

2005-05-31 Thread dave
like that has a chance in hell but the real page has video controls and mute button ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Michael T. Tangorre

RE: Is this possible?

2005-05-31 Thread Che Vilnonis
Dave, that places it 'inline'. How about a floating DHTML/Javascript window? -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 12:25 PM To: CF-Talk Subject: RE: Is this possible? This works (in IE - didn't test any others) div id=A

RE: String to SHA1 to Base 64 Encryption Help!

2005-05-31 Thread Aldon
Hello Jochem, i used the suggested method and the result still differs. Original= 12345678910111213141516171819202122 Generated By .Net = iR2kmtngiYH/aVQdkkid5O4/mn0= Generated by UDf's = w4ZFwrgMw7gBw7UeAnIlR2YICcKaw5dQTQ== However I have managed to connect to the .net sha1.class using the

Using XForms with CFFORM in CF7

2005-05-31 Thread Michel Deloux
Hi all I'm looking for examples, advantages, disadvantages, requirements about using XForms with CFFORM in CF7. CF Documentation is so small about that subject. Any topic will be very helpful. Thanx MD ~| Logware

Re: anyone bored?

2005-05-31 Thread Joe Rinehart
I'd go through your whole app and implement CFQueryparam, shut off robust exception information, and implement a sitewide error handler. I've found places that expose SQL that shows where injection is possible. -Joe On 5/31/05, dave [EMAIL PROTECTED] wrote: like that has a chance in hell but

Re: anyone bored?

2005-05-31 Thread Joe Rinehart
Hi Dave, I'd also surround _all_ of the places where you display user input with htmlEditFormat(), as it's kind of open for HTML monkeying (leading to XSS attacks). -Joe On 5/31/05, Joe Rinehart [EMAIL PROTECTED] wrote: I'd go through your whole app and implement CFQueryparam, shut off robust

Re: Using XForms with CFFORM in CF7

2005-05-31 Thread Michael Dinowitz
This article was published recently in Fusion Authority XForms: The 'Other' New Forms in CFMX 7 http://www.fusionauthority.com/Article.cfm/ArticleID:4430 - Original Message - From: Michel Deloux [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 31, 2005 12:44 PM

RE: String to SHA1 to Base 64 Encryption Help!

2005-05-31 Thread Paul Vernon
Original= 12345678910111213141516171819202122 Generated By .Net = iR2kmtngiYH/aVQdkkid5O4/mn0= Generated by UDf's = w4ZFwrgMw7gBw7UeAnIlR2YICcKaw5dQTQ== Just to add to the mix, using a set of hashing components within Delphi, my SHA1 hash produces a match for the UDF generated version. The

CF vs LAMP

2005-05-31 Thread Russ
We have a client that is trying to decide whether to go with my company or another company. We are a CF/MS SQL shop, and the other company does LAMP development (Linux, Apache, MySQL, Perl). I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL

Re: CF vs LAMP

2005-05-31 Thread Ray Champagne
You should read the latest CFDJ - there is an article on Linux, Apache, MySQL, BlueDragon (LAMBDA). All free sources, sounds like you could compete with the other shop by offering this approach if price is a concern. CFDJ, April 2005 issue, page 24. Ray Russ wrote: We have a client that is

CF vs LAMP

2005-05-31 Thread Michael Dinowitz
1. MS SQL costs, MySQL does not 2. MS SQL has Stored Procedures and other features missing from MySQL 3. MS SQL easier to maintain 4. IIS sucks 5. IIS is easier to maintain and work with than Apache 6. CF costs, Perl is free 7. Perl is a pain to read, write, and maintain unless your very well

CLOB vs Long Text Buffer (chr)

2005-05-31 Thread Russ
We have a database that uses MS SQL text fields. Is this what the CLOB in CF is for? What is the difference between CLOB and Long Text Buffer in the datasource settings page? The problem is we've had clients complain that the amount of text retrieved is not big enough, and I've had to bump

Clustering CFMX 6.1 (J2EE Session Sharing)

2005-05-31 Thread Jamie Jackson
I'm trying to cluster CFMX 6.1 on JRun 4, but I'm getting stuck early in the process. I'm trying to register a remote server, but after I input the parameters (remote JNDI port, host name, and server name), my server appears, as I would expect. However, I would expect the server to be running,

Re: CF vs LAMP

2005-05-31 Thread Rob
We have a client that is trying to decide whether to go with my company or another company. We are a CF/MS SQL shop, and the other company does LAMP development (Linux, Apache, MySQL, Perl). I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL

Re: CF vs LAMP

2005-05-31 Thread Claude Schneegans
I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL vs LAMP. Tell them that Perl is to Web development what the bulb is to computers. -- ___ REUSE CODE! Use custom tags; See

RE: CF vs LAMP

2005-05-31 Thread Russ
I can't seem to find it on the CFDJ site... is it up there yet, or does it appear in print first? Does anyone have a link? Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:32 PM To: CF-Talk Subject: Re: CF vs LAMP You should read the

Re: CF vs LAMP

2005-05-31 Thread Sean Corfield
On 5/31/05, Russ [EMAIL PROTECTED] wrote: We have a client that is trying to decide whether to go with my company or another company. We are a CF/MS SQL shop, and the other company does LAMP development (Linux, Apache, MySQL, Perl). The P in LAMP normally means PHP, not Perl. As others have

Re: CF vs LAMP

2005-05-31 Thread Ray Champagne
http://coldfusion.sys-con.com/read/49181.htm Russ wrote: I can't seem to find it on the CFDJ site... is it up there yet, or does it appear in print first? Does anyone have a link? Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005

RE: CF vs LAMP

2005-05-31 Thread Damien McKenna
5. IIS is easier to maintain and work with than Apache I disagree with this. Once you play a little with the Apache config files it is a lot quicker making changes to it than IIS. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ -

RE: CF vs LAMP

2005-05-31 Thread Russ
This will be a huge site with multiple web servers and at least 1 db server. Price only becomes an issue when you talk about cf licensing. We'll have to get a CF license for each new CF web server we put up, and 1 MS SQL license for each DB server. This definitely makes the LAMP approach look

Re: anyone bored?

2005-05-31 Thread dave
site wide error handler is there just turned off at the momement. I haven't gone through the cw code yet to do the trimming and cfqueryparams yet, after final version I will. Cw tends to break whenever you touch anything in it and after just getting it compliant I decided to wait on the rest.

RE: CF vs LAMP

2005-05-31 Thread Dave Merrill
LAMP typically involves PHP, not Perl. Not that I'm an authority on it, but PHP has become at least pretty much object oriented, and there's a lot of code out there for reuse. It's not an obviously stupid choice IMO. MySQL is free, but otherwise it's a pretty inferior option to MSSQL IMO, in

Re: CF vs LAMP

2005-05-31 Thread Joe Rinehart
Hi guys, The 'P' in LAMP usually refers to PHP - which is a pain to read, write, and maintain unless you're very well versed in PHP ;) I think the IIS vs. Apache for maintanence is a toss-up - IIS's GUI is nice at times, but sometimes I'd kill to just be able to edit httpd.conf. Running CFMX +

Re: anyone bored?

2005-05-31 Thread Joe Rinehart
Cool...this may be really ignorant, but what's 'cw'? I'd be shifty of anything that didn't let me develop proper data-layer code from the start. -Joe On 5/31/05, dave [EMAIL PROTECTED] wrote: site wide error handler is there just turned off at the momement. I haven't gone through the cw

RE: CF vs LAMP

2005-05-31 Thread Mark A Kruger
Joe, ditto - I like your take on this. -mark -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:03 PM To: CF-Talk Subject: Re: CF vs LAMP Hi guys, The 'P' in LAMP usually refers to PHP - which is a pain to read, write, and maintain unless

RE: CF vs LAMP

2005-05-31 Thread dave
there is always bluedragon and postgre, I would rather use that than php, mysql. If you have a site that big would you want it running on all free stuff? Would you take your bmw to some cheap mechanic that only used free tools or the new state of the art repair center? Did you fall for the

Re: CF vs LAMP

2005-05-31 Thread John Paul Ashenfelter
On 5/31/05, Russ [EMAIL PROTECTED] wrote: I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL vs LAMP. Assuming completely equal competencies at both companies, the pros/cons are the same as any open source vs. commercial software solution. The

Re: anyone bored?

2005-05-31 Thread dave
cw = cartweaver I has been pretty good but for the price I would like to see it more currently coded. I had the great idea of trying to make it tabless... ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice

Re: DatePart problem

2005-05-31 Thread Mark Henderson
Mark and James, both your methods worked for me, so I'm going with LSParseDateTime. Bert, the dates are already in a date/time format in the database so I do use dateformat frequently. Also, thanks for the tip on data objects versus strings, which explains why it was screwing things up. Thank

Re: CF vs LAMP

2005-05-31 Thread John Paul Ashenfelter
On 5/31/05, Ray Champagne [EMAIL PROTECTED] wrote: You should read the latest CFDJ - there is an article on Linux, Apache, MySQL, BlueDragon (LAMBDA). All free sources, This is wrong. Blue Dragon is *free* (as in beer) but is definitely *not* open source. Doesn't make it a bad choice -- but

Re: CF vs LAMP

2005-05-31 Thread John Paul Ashenfelter
On 5/31/05, Claude Schneegans [EMAIL PROTECTED] wrote: I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL vs LAMP. Tell them that Perl is to Web development what the bulb is to computers. Or just tell them I'm clueless about bringing you

RE: CF vs LAMP

2005-05-31 Thread Matthew Small
I don't see what the cost of the toolset has to do with anything from a client perspective. If anything, the fact that it costs something makes me think that it's probably a better tool - you get what you pay for. Competing against PHP or Perl, both languages that I know nothing about, it seems

Re: CF vs LAMP

2005-05-31 Thread Michael Haggerty
Comments inline. --- Michael Dinowitz [EMAIL PROTECTED] wrote: 1. MS SQL costs, MySQL does not Well, that's not exactly true. These days you can purchase a MySQL Network subscription that includes 'certified' software that has several performance enhancements over the regular distributable.

Re: CF vs LAMP

2005-05-31 Thread Michael Haggerty
Comments inline. --- Michael Dinowitz [EMAIL PROTECTED] wrote: 1. MS SQL costs, MySQL does not Well, that's not exactly true. These days you can purchase a MySQL Network subscription that includes 'certified' software that has several performance enhancements over the regular distributable.

Re: CF vs LAMP

2005-05-31 Thread John Paul Ashenfelter
On 5/31/05, Dave Merrill [EMAIL PROTECTED] wrote: MySQL is free, but otherwise it's a pretty inferior option to MSSQL IMO, in features, scalability, ease of admin etc. Many of the MySQL features that bring it anywhere near the same level of functionality are brand new, FWIW. This is just

RE: CF vs LAMP

2005-05-31 Thread Damien McKenna
The standard demonstration of MySQL's competitiveness with MS-SQL is the well-know eWeek article (http://www.pcmag.com/article2/0,1759,103972,00.asp) shows that MySQL (4.0 in the tests) paced Oracle and simply kicked the butt of everything else, with MS-SQL coming in at the bottom. One thing

Re: Using XForms with CFFORM in CF7

2005-05-31 Thread Michel Deloux
Thanx Michael... great!!! MD 2005/5/31, Michael Dinowitz [EMAIL PROTECTED]: This article was published recently in Fusion Authority XForms: The 'Other' New Forms in CFMX 7 http://www.fusionauthority.com/Article.cfm/ArticleID:4430 - Original Message - From: Michel Deloux [EMAIL

Re: CF vs LAMP

2005-05-31 Thread Paul Hastings
John Paul Ashenfelter wrote: distributed, in-memory redundant databases to the table. And if you need to internationalize your application, there is simply no competition with MySQL as far as support of mutliple character sets and collations at the *column* level. sorry, no, that's not going

Re: CF vs LAMP

2005-05-31 Thread Rick Mason
Russ, Here's a link to the official CF Everywhere page. There's a link to part one of the article in CFDJ as well as a link to their forum where you can ask questions. http://beta.philcruz.com/cfeverywhere/ Note that part three of the article has yet to be published. Rick Mason On

Connection closed due to session kill

2005-05-31 Thread Mosh Teitelbaum
All: I was recently called in to troubleshoot a site that has been showing all kinds of problems. One problem that just recently began showing up includes the following error message: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver] Connection closed due to

Re: CF vs LAMP

2005-05-31 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Damien McKenna wrote: The standard demonstration of MySQL's competitiveness with MS-SQL is the well-know eWeek article (http://www.pcmag.com/article2/0,1759,103972,00.asp) shows that MySQL (4.0 in the tests) paced Oracle and simply kicked the butt of

Re: CF vs LAMP

2005-05-31 Thread Richard Crawford
On Tuesday 31 May 2005 11:03, Joe Rinehart wrote: The 'P' in LAMP usually refers to PHP - which is a pain to read, write, and maintain unless you're very well versed in PHP ;);) Wow. My experience has been very different. I find PHP very easy to work with and quite intuitive, while Cold

RE: CF vs LAMP

2005-05-31 Thread Russ
In addition to phpmyadmin (which I've grown to love) there is also the mysql control center and a couple of other GUI tools which have been developed. And for the hardcore, there's always the MySQL command line, which I would frequently kill -- or at least maim -- to have in MS-SQL Server.

Regular Expression help

2005-05-31 Thread Rey Bango
Guys, I have the following email check but it won't accept a .info email address. I'm not a regular expression expert and was hoping someone could help me out with this. How could I update the following script to accept domain suffixes other than .com, .net .org? function isEmail(str) {

Re: CF vs LAMP

2005-05-31 Thread Richard Crawford
On Tuesday 31 May 2005 12:42, Russ wrote: In addition to phpmyadmin (which I've grown to love) there is also the mysql control center and a couple of other GUI tools which have been developed. And for the hardcore, there's always the MySQL command line, which I would frequently kill -- or at

Re: Regular Expression help

2005-05-31 Thread Rey Bango
I found the fix guys!!! Amazing what a little Googling will do. :P Rey... Rey Bango wrote: Guys, I have the following email check but it won't accept a .info email address. I'm not a regular expression expert and was hoping someone could help me out with this. How could I update the

Re: CF vs LAMP

2005-05-31 Thread Aaron Rouse
I always thought you could have Ent Manager at no cost, what type of licensing issues prevent you from having it on your home computer? I am not much of a MSSQL person so do not keep up with all that. On 5/31/05, Richard Crawford [EMAIL PROTECTED] wrote: On Tuesday 31 May 2005 12:42, Russ

RE: CF vs LAMP

2005-05-31 Thread Calvin Ward
Why not just replace the P, everything else should be fine. - Calvin -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:26 PM To: CF-Talk Subject: CF vs LAMP We have a client that is trying to decide whether to go with my company or another company.

Re: CF vs LAMP

2005-05-31 Thread Bryan Stevenson
I always thought you could have Ent Manager at no cost, what type of licensing issues prevent you from having it on your home computer? Yeah..I'm pretty sure you're right Aaron...and nowadays there is MS SQL Express/Lite...and I think that is free as well (or use MSDE) Cheers Bryan Stevenson

Re: CF vs LAMP

2005-05-31 Thread Jochem van Dieten
John Paul Ashenfelter wrote: anecdote True story. MySQL and Informix recently were competing for a contract at a large enterprise (which I can't name). The *software license* ONLY for Informix for their 96 (!) processor SGI Origin (maybe it was 48 -- doesn't really matter all that much) was

Re: CF vs LAMP

2005-05-31 Thread Ray Champagne
Essentially, that was what I was going for in my answer. :) Calvin Ward wrote: Why not just replace the P, everything else should be fine. - Calvin -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:26 PM To: CF-Talk Subject: CF vs LAMP

Re: DatePart problem

2005-05-31 Thread Larry White
dd/mm/yy is a string so, to get the month, there's really no reason to change it back to a date. Just use: cfset theMonth = Val(ListgetAt(DateString,2,/)) One thing to remember is that, unless you set the locale correctly and use the LS functions, dd/mm/yy will always be interpreted by CF date

Re: CF vs LAMP

2005-05-31 Thread Jochem van Dieten
Russ wrote: This will be a huge site with multiple web servers and at least 1 db server. Price only becomes an issue when you talk about cf licensing. We'll have to get a CF license for each new CF web server we put up, and 1 MS SQL license for each DB server. This definitely makes the LAMP

Re: CF vs LAMP

2005-05-31 Thread Jochem van Dieten
Richard Crawford wrote: To elaborate, here is a situation which came up for me last week. I was working at home due to illness, and I needed to debug some problems we were having with our SQL Server database. At home, I do not have a copy of either the Enterprise Manager (licensing

Re: CF vs LAMP

2005-05-31 Thread Bryan Stevenson
anecdote True story. MySQL and Informix recently were competing for a contract at a large enterprise (which I can't name). The *software license* ONLY for Informix for their 96 (!) processor SGI Origin (maybe it was 48 -- doesn't really matter all that much) was $1.2M. MySQL's per server

  1   2   >