re: Coldfusion and lucene
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 @%*((% From: vishnu prasad [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:56 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Coldfusion and lucene Hi All Does anyone know how to implement search using lucene in coldfusion what are the stesp that i need to follwo like ? what are the files that need to be downlaoed from apache where and how to set the classpath for lucen in Coldfusion Thanks in Regards Vishnu Prasad ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion and lucene
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: Tuesday, 31 May 2005 1:56 To: CF-Talk Subject: Coldfusion and lucene Hi All Does anyone know how to implement search using lucene in coldfusion what are the stesp that i need to follwo like ? what are the files that need to be downlaoed from apache where and how to set the classpath for lucen in Coldfusion ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208006 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
CF Precompilation filenames
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 compiles any CF page (no more stuffing around deleting the whole cfclasses folder when CF incorrectly caches a deleted source file even though trusted cache is off). If anyone is interested in the resulting code I can post it. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion and lucene
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 exception was that: . The error occurred in C:\cwhb\Myriad\RecordSheets\indexing_database.cfm: line 4 2 : cfset analyzer.init() 3 : cfset writer = CreateObject(java, org.apache.lucene.index.IndexWriter) 4 : cfset writer.init(C:\cwhb\Myriad\RecordSheets\, analyzer, true) 5 : 6 : cfquery name=contentIndex datasource=IDB 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: Tuesday, 31 May 2005 1:56 To: CF-Talk Subject: Coldfusion and lucene Hi All Does anyone know how to implement search using lucene in coldfusion what are the stesp that i need to follwo like ? what are the files that need to be downlaoed from apache where and how to set the classpath for lucen in Coldfusion ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208008 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
(SOT) Joins aren't always better than subqueries (longish post)
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 Oracle at least) where joins hobbled my query so badly that a query that should have taken milliseconds took minutes; using an aggregate function in a query that needed to return joined info. I'll simplify my situation: say I have the following table for scores in a unit of study: tblscore - scoreid, score, personid, unitid and it is joined to a tblperson table and a tblunit table in the obvious way. Now I want to sum the scores across all people in the given unit, so I do this: SELECT SUM(score) AS totalscore FROM tblscore GROUP BY unitid No problems so far. Great, but I now need to return the unit name in the above query, so using a join I do this: SELECT SUM(tblscore.score) AS totalscore, tblunit.unitname FROM tblscore, tblunit WHERE tblscore.unitid = tblunit.unitid GROUP BY tblunit.unitname (yeah yeah, I know, use ANSI join syntax - I'm an Oracle user, so sue me). This is necessary because you must either group or aggregate on anything returned by the query. The end result performs like a dog in a situation where there are in fact three more joins to other tables. I presume this is because to figure out the grouping for the sum the join result has to be returned and it messes up the aggregate's performance. Oracle's subqueries to the rescue: SELECT SUM(score) AS totalscore, (SELECT unitname FROM tblunit WHERE tblunit.unitid = s.unitid) AS unitname FROM tblscore s GROUP BY unitid This performs many times better than the group on the join, when there are actually four joins to perform. Anyone more intimate with the inner dark secrets of SQL is welcome to comment. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208009 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
DatePart problem
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 (where possible). An example: from 12/02/2005 (12th February 2005) DatePart will select the 12 as the month. From 25/02/2005, it obviously works correctly, due to a lack of alternatives. Actually, my situation is slightly more complicated in that this is actually used to submit events to a calendar table in the database. Start_date is currently in the above mentioned dd/m/ format and that is the way I wish to keep things (to save confusion for those submitting). So my question - can this be achieved, and if so, how...any ideas? A worst case scenario means I will just have to alter the form thats entered, but this (DatePart) is something I might like to use in the future, so I figured I would ask. All help appreciated. TIA Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208010 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: (SOT) Joins aren't always better than subqueries (longish post)
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 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 Oracle at least) where joins hobbled my query so badly that a query that should have taken milliseconds took minutes; using an aggregate function in a query that needed to return joined info. I'll simplify my situation: say I have the following table for scores in a unit of study: tblscore - scoreid, score, personid, unitid and it is joined to a tblperson table and a tblunit table in the obvious way. Now I want to sum the scores across all people in the given unit, so I do this: SELECT SUM(score) AS totalscore FROM tblscore GROUP BY unitid No problems so far. Great, but I now need to return the unit name in the above query, so using a join I do this: SELECT SUM(tblscore.score) AS totalscore, tblunit.unitname FROM tblscore, tblunit WHERE tblscore.unitid = tblunit.unitid GROUP BY tblunit.unitname (yeah yeah, I know, use ANSI join syntax - I'm an Oracle user, so sue me). This is necessary because you must either group or aggregate on anything returned by the query. The end result performs like a dog in a situation where there are in fact three more joins to other tables. I presume this is because to figure out the grouping for the sum the join result has to be returned and it messes up the aggregate's performance. Oracle's subqueries to the rescue: SELECT SUM(score) AS totalscore, (SELECT unitname FROM tblunit WHERE tblunit.unitid = s.unitid) AS unitname FROM tblscore s GROUP BY unitid This performs many times better than the group on the join, when there are actually four joins to perform. Anyone more intimate with the inner dark secrets of SQL is welcome to comment. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208011 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: DatePart problem
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 May 2005 11:07 To: CF-Talk Subject: DatePart problem 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 (where possible). An example: from 12/02/2005 (12th February 2005) DatePart will select the 12 as the month. From 25/02/2005, it obviously works correctly, due to a lack of alternatives. Actually, my situation is slightly more complicated in that this is actually used to submit events to a calendar table in the database. Start_date is currently in the above mentioned dd/m/ format and that is the way I wish to keep things (to save confusion for those submitting). So my question - can this be achieved, and if so, how...any ideas? A worst case scenario means I will just have to alter the form thats entered, but this (DatePart) is something I might like to use in the future, so I figured I would ask. All help appreciated. TIA Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208012 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: DatePart problem
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 [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 May 2005 6:07 To: CF-Talk Subject: DatePart problem 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 (where possible). An example: from 12/02/2005 (12th February 2005) DatePart will select the 12 as the month. From 25/02/2005, it obviously works correctly, due to a lack of alternatives. [snip] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208013 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: anyone bored?
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 www.icandfashion.com, if you are up to it lemme know and I will send u link off list Thanks ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208014 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: (SOT) Joins aren't always better than subqueries (longish post)
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 getting less important as optimizers get better. Anyone more intimate with the inner dark secrets of SQL is welcome to comment. If you are looking for an explanation, show use the real SQL and the EXPLAIN output of the queries. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208015 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: (SOT) Joins aren't always better than subqueries (longish post)
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 Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: dinsdag 31 mei 2005 10:59 To: CF-Talk Subject: (SOT) Joins aren't always better than subqueries (longish post) 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 Oracle at least) where joins hobbled my query so badly that a query that should have taken milliseconds took minutes; using an aggregate function in a query that needed to return joined info. I'll simplify my situation: say I have the following table for scores in a unit of study: tblscore - scoreid, score, personid, unitid and it is joined to a tblperson table and a tblunit table in the obvious way. Now I want to sum the scores across all people in the given unit, so I do this: SELECT SUM(score) AS totalscore FROM tblscore GROUP BY unitid No problems so far. Great, but I now need to return the unit name in the above query, so using a join I do this: SELECT SUM(tblscore.score) AS totalscore, tblunit.unitname FROM tblscore, tblunit WHERE tblscore.unitid = tblunit.unitid GROUP BY tblunit.unitname (yeah yeah, I know, use ANSI join syntax - I'm an Oracle user, so sue me). This is necessary because you must either group or aggregate on anything returned by the query. The end result performs like a dog in a situation where there are in fact three more joins to other tables. I presume this is because to figure out the grouping for the sum the join result has to be returned and it messes up the aggregate's performance. Oracle's subqueries to the rescue: SELECT SUM(score) AS totalscore, (SELECT unitname FROM tblunit WHERE tblunit.unitid = s.unitid) AS unitname FROM tblscore s GROUP BY unitid This performs many times better than the group on the join, when there are actually four joins to perform. Anyone more intimate with the inner dark secrets of SQL is welcome to comment. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208016 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: anyone bored?
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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208017 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: PHP Query in Results
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 die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db (my_database);
// select the table
$result = mysql_query(select * from Rentals, pics WHERE featured = 1
AND ORDER BY RAND() LIMIT 1);
// format results by row
while ($row = mysql_fetch_array($result)) {
$id = $row[ID];
$pic = mysql_query(select img_name from pics WHERE rntID = 31);
echo $pic br;
echo a
href=http://www.regina4rent.com/reg/userlisting.php?fulllisting=$idimg
src=../images/$pic alt=Feature width=156 height=117 border=0
class=imgborder //a;
echo brbra
href=http://www.regina4rent.com/reg/userlisting.php?fulllisting=$id
class=purple_bgclick here to view this listing/a;
}
?
--
Jillian Koskie
Senior Systems Analyst
306-229-1312
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208018
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
Logic requried
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 goback and change it. Now here I am having a problem. Once user upload the file(s), he will see the preview of those images which he uploaded. I have put the file names in the session and preview them after uploading. Now how this thing works, that if user need to change the images? should I give the hyperlink to the user on image where he can click on the preview page, go to the next page and change the picture? should it be form radio button to select the image and click change? I mean what is the best logic that I can use here. Thanks, -- Regards, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208019 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: Logic requried
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 confirm at this stage or goback and change it. Now here I am having a problem. Once user upload the file(s), he will see the preview of those images which he uploaded. I have put the file names in the session and preview them after uploading. Now how this thing works, that if user need to change the images? Preview the images before you upload them :) Use Javascript to grab the locations on the harddisk of the user from the formfields and show the images in an iframe while they are still on the users harddisk. Only submit the form when they confirm the preview in the iframe. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208020 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: OT: PHP Query in Results
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 (localhost, database, password) or die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db (my_database);
// select the table
$result = mysql_query(select * from Rentals, pics WHERE featured = 1
AND ORDER BY RAND() LIMIT 1);
This is a Cartesian product that is subsequently LIMITed. Is that
intentional?
// format results by row
while ($row = mysql_fetch_array($result)) {
$id = $row[ID];
$pic = mysql_query(select img_name from pics WHERE rntID = 31);
I don't fully understand the logic, but can't you just grab the
exact data you need in one query?
SELECT rnt.ID, pics.img_name
FROM Rentals rnt INNER JOIN pics ON rnt.ID = pics.rntID
WHERE featured = 1
ORDER BY RAND()
LIMIT 1
Jochem
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208021
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: (SOT) Joins aren't always better than subqueries (longish post)
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 straightforward. If it was representative the optimizer should have been able to figure that out. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208022 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
CF Precompilation filenames
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 now parse, complile and generate Java bytecode directly from CFML for additional comple-time performance and super-efficient Java bytecode, resulting in improved runtime performance. Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208023 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: PHP Query in Results
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 die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db (my_database);
// select the table
$result = mysql_query(select * from Rentals, pics WHERE featured = 1
AND ORDER BY RAND() LIMIT 1);
// format results by row
while ($row = mysql_fetch_array($result)) {
$id = $row[ID];
$pic = mysql_query(select img_name from pics WHERE rntID = 31);
echo $pic br;
echo a
href=http://www.domain.com/reg/userlisting.php?fulllisting=$idimg
src=../images/$pic alt=Feature width=156 height=117 border=0
class=imgborder //a;
echo brbra
href=http://www.domaint.com/reg/userlisting.php?fulllisting=$id
class=purple_bgclick here to view this listing/a;
}
?
--
Jillian
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208024
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: Logic requried
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 the preview to the user that these are the files that he uploaded. He can confirm at this stage or goback and change it. Now here I am having a problem. Once user upload the file(s), he will see the preview of those images which he uploaded. I have put the file names in the session and preview them after uploading. Now how this thing works, that if user need to change the images? should I give the hyperlink to the user on image where he can click on the preview page, go to the next page and change the picture? should it be form radio button to select the image and click change? I mean what is the best logic that I can use here. Thanks, -- Regards, -- Regards, Asim Manzur http://www.LogikZone.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208025 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: OT: PHP Query in Results
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 img src=\../images/$pic\ /;
You must either use mysql_fetch_array() or mysql_fetch_object() first (there
are other ways, but I prefer the latter) because $pic contains the result of
your query-- not the data contained in the fields of the current row.
Therefore, the correct way to print the contents of img_name is:
$data = mysql_fetch_object($pic)
echo $pic-img_name br /;
echo img src=\../images/$pic-img_name\ /;
or, using mysql_fetch_array():
$data = mysql_fetch_array($pic)
echo $pic[img_name] . br /;
echo img src=\../images/{$pic['img_name']}\ /;
Regards,
[ simon.cpu ]
This is a Cartesian product that is subsequently LIMITed. Is that
intentional?
// format results by row
while ($row = mysql_fetch_array($result)) {
$id = $row[ID];
$pic = mysql_query(select img_name from pics WHERE rntID = 31);
I don't fully understand the logic, but can't you just grab the
exact data you need in one query?
SELECT rnt.ID, pics.img_name
FROM Rentals rnt INNER JOIN pics ON rnt.ID = pics.rntID
WHERE featured = 1
ORDER BY RAND()
LIMIT 1
Jochem
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208026
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: anyone bored?
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 issues and just general feedback. It's for www.icandfashion.com, if you are up to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208027 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: (SOT) Joins aren't always better than subqueries (longish post)
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 to your result set as usually you need to use the GROUP attribute of cfoutput. I'd imagine it might perform better then a sub query too on more complex examples. DK On 5/31/05, James Holmes [EMAIL PROTECTED] 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. However I just discovered a situation (in Oracle at least) where joins hobbled my query so badly that a query that should have taken milliseconds took minutes; using an aggregate function in a query that needed to return joined info. I'll simplify my situation: say I have the following table for scores in a unit of study: tblscore - scoreid, score, personid, unitid and it is joined to a tblperson table and a tblunit table in the obvious way. Now I want to sum the scores across all people in the given unit, so I do this: SELECT SUM(score) AS totalscore FROM tblscore GROUP BY unitid No problems so far. Great, but I now need to return the unit name in the above query, so using a join I do this: SELECT SUM(tblscore.score) AS totalscore, tblunit.unitname FROM tblscore, tblunit WHERE tblscore.unitid = tblunit.unitid GROUP BY tblunit.unitname (yeah yeah, I know, use ANSI join syntax - I'm an Oracle user, so sue me). This is necessary because you must either group or aggregate on anything returned by the query. The end result performs like a dog in a situation where there are in fact three more joins to other tables. I presume this is because to figure out the grouping for the sum the join result has to be returned and it messes up the aggregate's performance. Oracle's subqueries to the rescue: SELECT SUM(score) AS totalscore, (SELECT unitname FROM tblunit WHERE tblunit.unitid = s.unitid) AS unitname FROM tblscore s GROUP BY unitid This performs many times better than the group on the join, when there are actually four joins to perform. Anyone more intimate with the inner dark secrets of SQL is welcome to comment. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208028 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: (SOT) Joins aren't always better than subqueries (longish post)
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 FROM wrklocations, escunits, wrkcalcs, wrkperiods, wrkenrolments WHERE ((wrklocations.locationid = wrkcalcs.locationid) AND (wrkperiods.periodid = wrkcalcs.periodid) AND (escunits.unitid = wrkcalcs.unitid) AND (escunits.unitid = wrkenrolments.unitid) AND (wrkperiods.periodid = wrkenrolments.periodid) AND (wrklocations.locationid = 1) AND (wrkcalcs.periodid IN (4, 6)) ) GROUP BY wrkperiods.periodname, escunits.unitname, wrklocations.LOCATION, wrkenrolments.eftsu 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. Here is the statement that runs in 800 ms or less: SELECT (SELECT UNITNAME FROM ESCUNITS WHERE ESCUNITS.UNITID = WC.UNITID) AS UNITNAME, SUM (wc.score) as WDMSCORE, (SELECT EFTSU FROM WRKENROLMENTS WHERE WRKENROLMENTS.UNITID = WC.UNITID AND WRKENROLMENTS.PERIODID = WC.PERIODID) AS EFTSU, (SELECT PERIODNAME FROM WRKPERIODS WHERE WRKPERIODS.PERIODID = WC.PERIODID) AS PERIOD, (SELECT LOCATION FROM WRKLOCATIONS WHERE WRKLOCATIONS.LOCATIONID = WC.LOCATIONID) AS LOCATION FROM wrkcalcs WC WHERE PERIODID IN (4,6) AND LOCATIONID = 1 GROUP BY wc.periodid, wc.unitid, wc.locationid The end result is the same dataset. I did notice that the subquery version allows for one less group by expression, which may or not make the difference. I can elaborate on the contents of the tables if necessary. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 May 2005 8:27 To: CF-Talk Subject: Re: (SOT) Joins aren't always better than subqueries (longish post) 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 straightforward. If it was representative the optimizer should have been able to figure that out. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208029 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: DatePart problem
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 a string then they will helpfully try to process them with unexpected results, as you've found out with DatePart(). DateFormat() is another: this is for converting data objects into strings of the specified format, not the other way round. HTH Bert ps Also, you mention you're storing your dates in the database in format dd/m/. You'd be well advised to start storing dates in columns of datatype date, and use dateFormat() when displaying them to users. On 5/31/05, Mark Henderson [EMAIL PROTECTED] wrote: 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 (where possible). An example: from 12/02/2005 (12th February 2005) DatePart will select the 12 as the month. From 25/02/2005, it obviously works correctly, due to a lack of alternatives. Actually, my situation is slightly more complicated in that this is actually used to submit events to a calendar table in the database. Start_date is currently in the above mentioned dd/m/ format and that is the way I wish to keep things (to save confusion for those submitting). So my question - can this be achieved, and if so, how...any ideas? A worst case scenario means I will just have to alter the form thats entered, but this (DatePart) is something I might like to use in the future, so I figured I would ask. All help appreciated. TIA Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208030 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: Little CMS thing
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 settings) don't like that, despite the fact I am using cfcontent with the proper application type settings. You can try another browser, I think. I've had some people tell me they could come back later and it works. The Lite version isn't current code. Its maybe two years out of date. Plus since I didn't have a license to use the drop-down menu that I do in the admin area for a freebie so I had to redo it in what I think is kludgy fashion, but should be acceptable for a working freebie :-). But that element has kept me from updating that code. You'd have more work to put on a front end to it but you'll get the idea with the lite code. Generate new ones - it would be a bit like sub sites of a larger system but all accessible on their own domain name. It does that exactly. One admin area. You permission it such that users can see the admin area and their own site. Each site has its own 'section', which translates to a dedicated content tree. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208031 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: (SOT) Joins aren't always better than subqueries (longish post)
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 wrklocations table and the subquery version is driven by the wrkcalcs table. The end result is the same dataset. I did notice that the subquery version allows for one less group by expression, which may or not make the difference. I don't think that explains the difference. How fast is this query? And what does the explain output show? SELECT escunits.unitname, SUM (wrkcalcs.score)as WDMSCORE, wrkenrolments.eftsu, wrkperiods.periodname, wrklocations.LOCATION FROM wrklocations, escunits, wrkcalcs, wrkperiods, wrkenrolments WHERE (wrklocations.locationid = wrkcalcs.locationid) AND (wrkperiods.periodid = wrkcalcs.periodid) AND (escunits.unitid = wrkcalcs.unitid) AND (escunits.unitid = wrkenrolments.unitid) AND (wrkperiods.periodid = wrkenrolments.periodid) AND (wrkcalcs.locationid = 1) AND (wrkcalcs.periodid IN (4, 6)) GROUP BY wrkperiods.periodname, escunits.unitname, wrklocations.LOCATION, wrkenrolments.eftsu Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208032 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: Logic requried
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
/form
img src=spacer.gif id=img1
img src=spacer.gif id=img2
img src=spacer.gif id=img3
script
function confirm()
{
document.getElementById(img1).src =
document.getElementById(file1).value;
document.getElementById(img2).src =
document.getElementById(file2).value;
document.getElementById(img3).src =
document.getElementById(file3).value;
sleep(3000);
return confirm(Does this look right?);
}
/script
Jochem
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208033
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
Sandboxing Multiple CF7 Instances?
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 jvm.config for the second instance I've changed the references to the cfusion instance to my instance name (cfusion7_1) but whenever i try and restart the service I get; Exception in thread main java.lang.ExceptionInInitializerError Caused by: java.security.AccessControlException: access denied (java.util.PropertyPermission jrun.home read) at java.security.AccessControlContext.checkPermission(Unknown Source) at java.security.AccessController.checkPermission(Unknown Source) at java.lang.SecurityManager.checkPermission(Unknown Source) at java.lang.SecurityManager.checkPropertyAccess(Unknown Source) at java.lang.System.getProperty(Unknown Source) at jrunx.kernel.JRun.clinit(JRun.java:52) Exception in thread main I've been talking the problem through with another CF guy and he can reproduce exactly the same error message so it must be something we're doing fundamentally wrong, thanks, john. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208034 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: (SOT) Joins aren't always better than subqueries (longish post)
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 ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS SORT JOIN TABLE ACCESS FULL DIVWEB.WRKCALCS TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS My slower query (4.3 secs): SELECT STATEMENT Optimizer Mode=CHOOSE SORT GROUP BY MERGE JOIN SORT JOIN NESTED LOOPS NESTED LOOPS MERGE JOIN TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS FILTER TABLE ACCESS FULL DIVWEB.WRKCALCS TABLE ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS SORT JOIN TABLE ACCESS FULL DIVWEB.WRKENROLMENTS My quick query (800ms): SELECT STATEMENT Optimizer Mode=CHOOSE TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS TABLE ACCESS FULL DIVWEB.WRKENROLMENTS TABLE ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS SORT GROUP BY TABLE ACCESS FULL DIVWEB.WRKCALCS ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208035 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
OT: PHP Query Problem
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 die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db (my_database);
// select the table
$result = mysql_query(select * from Rentals, pics WHERE featured = 1
AND ORDER BY RAND() LIMIT 1);
// format results by row
while ($row = mysql_fetch_array($result)) {
$id = $row[ID];
$pic = mysql_query(select img_name from pics WHERE rntID = 31);
echo$pic br;
echoa
href=http://www.domain.com/reg/userlisting.php?fulllisting=$idimg
src=../images/$pic alt=Feature width=156 height=117 border=0
class=imgborder //a;
echobrbra
href=http://www.domain.com/reg/userlisting.php?fulllisting=$id
class=purple_bgclick here to view this listing/a;
}
?
--
Jillian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208036
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
CFFORM validation issue in CFMX 7
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
SCRIPT LANGUAGE=JavaScript TYPE=text/javascript
!--
function _CF_checkCFForm_1(_CF_this)
{
if (!_CF_checkinteger(_CF_this.menuid.value))
{
if (!_CF_onError(_CF_this, _CF_this.menuid,
_CF_this.menuid.value, menu ID must be an integer value))
{
return false;
}
}
document.forms[0].cmdNext.disabled = true; return CheckDefaults();
return true;
}
//--
/SCRIPT
GENERATED FORM TAG IN CFMX 6 (see onSubmit())
FORM NAME=CFForm_1 ACTION=../common/taskStepUpd.cfm METHOD=POST
onSubmit=return _CF_checkCFForm_1(this) TARGET=
---
GENERATED FORM TAG IN CFMX 7 (see onSubmit())
CF7 generates the javascript code (although it's different), but doesn't place
the call to _CF_checkCFForm_1() in the onsubmit event text:
form name=CFForm_1 action=../common/taskStepUpd.cfm method=POST
onsubmit=document.forms[0].cmdNext.disabled = true; return CheckDefaults();
Any ideas?
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208037
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: OT: PHP Query in Results
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 = mysql_fetch_array($pic);
echo $pic[img_name] . br /;
echo img src=\../images/{$pic['img_name']}\ /;
CORRECTION: $pic[img_name] should be $data[img_name];
Sow...
[ simon.cpu ]
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208038
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: OT: PHP Query in Results
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 = mysql_fetch_array($pic)
echo $pic[img_name] . br /;
echo img src=\../images/{$pic['img_name']}\ /;
CORRECTION: $pic[img_name] should be $data[img_name];
Sow...
[ simon.cpu ]
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208039
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: OT: PHP Query in Results
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 = mysql_fetch_array($pic);
echo $pic[img_name] . br /;
echo img src=\../images/{$pic['img_name']}\ /;
CORRECTION: $pic[img_name] should be $data[img_name];
Sow...
[ simon.cpu ]
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208040
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: Hey CF_World
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208041 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: PHP Query Problem
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 actual high-res images. You can use the GD library to resize them before sending them to the client. Cheers, [ simon.cpu ] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208042 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: Rich Internet Applications for Mobile Devices
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 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Rich Internet Applications for Mobile Devices The idea of being offline or online is something MM Central takes care of. I don't think Central applications run on most mobile devices. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208043 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
Is this possible?
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208044 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: Is this possible?
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. | Web Developer -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:25 AM To: CF-Talk Subject: Is this possible? 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208045 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: Is this possible?
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 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. | Web Developer -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:25 AM To: CF-Talk Subject: Is this possible? 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208046 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: Is this possible?
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: Is this possible? 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 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. | Web Developer -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:25 AM To: CF-Talk Subject: Is this possible? 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208047 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: anyone bored?
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, May 31, 2005 9:09 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: anyone bored? sure... why not. tw On 5/31/05, Michael T. Tangorre 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 issues and just general feedback. It's for www.icandfashion.com, if you are up to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208048 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: anyone bored?
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 PROTECTED] Sent: Tuesday, May 31, 2005 9:09 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: anyone bored? sure... why not. tw On 5/31/05, Michael T. Tangorre 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 issues and just general feedback. It's for www.icandfashion.com, if you are up to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208049 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: anyone bored?
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 [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208050 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: Is this possible?
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 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: Is this possible? 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 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. | Web Developer -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:25 AM To: CF-Talk Subject: Is this possible? 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208051 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: String to SHA1 to Base 64 Encryption Help!
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 following
method.
CFOBJECT TYPE=COM ACTION=CREATE CLASS=System.Security.Cryptography
NAME=shd
cfdump var=#shd#
string ComputeHash(string Key)
{
SHA1CryptoServiceProvider objSHA1 = new SHA1CryptoServiceProvider;
objSHA1.ComputeHash(System.Text.Encoding.UTF8.GetBytes(Key.ToCharArray));
byte[] buffer = objSHA1.Hash;
string HashValue = System.Convert.ToBase64String(buffer);
return HashValue;
}
How do I convert this code to cfscript?
Aldon
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 11:46 AM
To: CF-Talk
Subject: Re: String to SHA1 to Base 64 Encryption Help!
Aldon wrote:
Original=12345678910111213141516171819202122
Converted=iR2kmtngiYH/aVQdkkid5O4/mn0=
I presume that is the converted output as generated by .NET? In
that case, download http://www.cflib.org/udf.cfm?ID=1016 and try:
CFSET message=This is a test
CFOUTPUT
Given message=#message#
The Base64 encoded SHA-1 message digest is:
#ToBase64(hexToString(sha1(message)))#
/CFOUTPUT
Jochem
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208052
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
Using XForms with CFFORM in CF7
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 (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208053 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: anyone bored?
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 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 [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208054 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: anyone bored?
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 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 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 [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208055 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: Using XForms with CFFORM in CF7
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 Subject: Using XForms with CFFORM in CF7 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 (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208057 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: String to SHA1 to Base 64 Encryption Help!
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 .NET version at this point looks like it is using a different digest size or it is plain wrong... The digest size used for the UDF version of the hash is 160-bit. Do you know what the digest size is for the .NET version? Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208056 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
CF vs LAMP
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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208058 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 vs LAMP
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 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208059 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 vs LAMP
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 versed in perl 8. CF is easy to read, write and maintain even if your not very well versed in CF The cost for MS SQL/CF is more in the short run, but when you get into programming time, new features, maintance and all MS SQL/CF wins hands down and is less than what would be paid over time with LAMP. 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208060 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
CLOB vs Long Text Buffer (chr)
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 up the Long Text Buffer several times. Its at 96000 now, and I was wondering what ramifications this has on performance and whether I should just enable CLOB instead. Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208061 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
Clustering CFMX 6.1 (J2EE Session Sharing)
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, since it is already running on the remote machine. When I try to start it remotely (from the JMC), the start (green arrow) button spawns a JS popup: To start or stop a remote server, another running server on the remote host must already be registered with the JMC. It *is* already running on the remote machine. Can anyone help me get past this one step? If I can get get a remote JRun instance registered properly, I think I'll be well on my way to J2EE session sharing in CFMX. Thanks, Jamie ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 vs LAMP. Scalability is a big one. CF is (can be) run on top of J2EE and you can plug most any database in (if you decide to upgrade). Queues - lot of businesses are moving to message queues now for system integration. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. Depending on who you are talking to, they may not care about that. They may just be looking at the cost and if it'll work - after all they are hiring you to write the code who cares how hard it is. I'd play up the fact that they will make more money because they'll be able to integrate with more products and services, communicate with other companies easier, and in the long run save money on development / re-writing / integration costs. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. That's a big advantage, and it can be a blinding one too. Why would you choose CF/mssql over LAMP if you were a CIO of a business? -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208063 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208064 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 vs LAMP
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 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 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 indicated, the initial cost for your CF/MS SQL solution may be higher but ongoing maintenance should be cheaper. FWIW, I use SmarterLinux as my ISP (part of HostMySite) and they offer LAMP with CFMX for a very reasonable $15 / month (less if you go through a reseller I believe). If a shared host solution is an option, that might be a way for you to compete head on with the other LAMP company... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208066 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 1:32 PM To: CF-Talk Subject: Re: CF vs LAMP 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 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208067 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208069 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 more enticing, so what can I use to sway them toward CF? I know enterprise boasts being able to send over 1 million emails per hour. What other features does ColdFusion have that might make it seem better then LAMP? (Scalability, security, ease of maintenance, etc). Russ -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:52 PM To: CF-Talk Subject: Re: CF vs LAMP 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 indicated, the initial cost for your CF/MS SQL solution may be higher but ongoing maintenance should be cheaper. FWIW, I use SmarterLinux as my ISP (part of HostMySite) and they offer LAMP with CFMX for a very reasonable $15 / month (less if you go through a reseller I believe). If a shared host solution is an option, that might be a way for you to compete head on with the other LAMP company... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208068 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: anyone bored?
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. I'm also concidering going through and re-writing it as it seems like it was written quite awhile ago and would like to have it use cfc's instead, fix some of the java in it and get rid of a good chunk of the current code. thanks for input ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Joe Rinehart [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:00 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: anyone bored? 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 wrote: 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 wrote: 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 Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 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. Dave Merrill ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208071 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 + MySql is certainly an option - if you do MS SQL, changing to MySql is no big deal. It's very easy to maintain with the new MySql admin and query analyzer tools. -Joe On 5/31/05, Michael Dinowitz [EMAIL PROTECTED] wrote: 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 versed in perl 8. CF is easy to read, write and maintain even if your not very well versed in CF The cost for MS SQL/CF is more in the short run, but when you get into programming time, new features, maintance and all MS SQL/CF wins hands down and is less than what would be paid over time with LAMP. 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208072 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: anyone bored?
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 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. I'm also concidering going through and re-writing it as it seems like it was written quite awhile ago and would like to have it use cfc's instead, fix some of the java in it and get rid of a good chunk of the current code. thanks for input ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Joe Rinehart [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:00 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: anyone bored? 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 wrote: 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 wrote: 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 Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 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 + MySql is certainly an option - if you do MS SQL, changing to MySql is no big deal. It's very easy to maintain with the new MySql admin and query analyzer tools. -Joe On 5/31/05, Michael Dinowitz [EMAIL PROTECTED] wrote: 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 versed in perl 8. CF is easy to read, write and maintain even if your not very well versed in CF The cost for MS SQL/CF is more in the short run, but when you get into programming time, new features, maintance and all MS SQL/CF wins hands down and is less than what would be paid over time with LAMP. 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208074 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 dumb scam of we don't charge any closing fees when you bought your new home? Nothin is really free... ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Russ [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 2:00 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: CF vs LAMP 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 more enticing, so what can I use to sway them toward CF? I know enterprise boasts being able to send over 1 million emails per hour. What other features does ColdFusion have that might make it seem better then LAMP? (Scalability, security, ease of maintenance, etc). Russ -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 1:52 PM To: CF-Talk Subject: Re: CF vs LAMP On 5/31/05, Russ 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 indicated, the initial cost for your CF/MS SQL solution may be higher but ongoing maintenance should be cheaper. FWIW, I use SmarterLinux as my ISP (part of HostMySite) and they offer LAMP with CFMX for a very reasonable $15 / month (less if you go through a reseller I believe). If a shared host solution is an option, that might be a way for you to compete head on with the other LAMP company... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208075 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 vs LAMP
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 short list includes things like: + technical merits + licensing + support I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. Both not completely true. Bad Perl is a *little* harder to read than bad CF code, but a competent Perl programmer has no more trouble reading and maintaining a *well-built* perl program than a ColdFusion programmer does a well-built CF app. And considering the availablity of top-notch frameworks like Mason and tools like the Template-Toolkit, one could argue it's actually *easier* to read Perl -- or at least comparable to an application built on one of the more common CF frameworks like Fusebox, MachII, Tartan, or Model-Glue. As far as performance goes, running mod_perl on Apache can be blazingly fast. So can CF for that matter -- but its going to depend on the details of the application and the load for both alternatives. Comparisons for speed between platforms is a *very* difficult thing to measure for non-trivial measurements, so as a blanket statement I don't think that argument (CF is faster than Perl) will get very far, especially when presented to a knowledgeable tech decision-maker. As an aside, are they a pure Perl shop? Because LAMP also can imply PHP and Python... I know MS SQL has more features (such as stored procs) that MySQL lacks. MySQL has stored procs in the 5.0 branch, which is in widespread beta. And it also has transactions (since late 3.23 in InnoDB tables). And foreign key support (ditto). And views (implicit views in 4.0 branch, explicit in 5.0 branch). MS-SQL (2005 in specific) has better XML and a much richer (though vendor-specific) SQL programming language (T-SQL) as well as better management tools. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. There are many advantages for the LAMP stack. For example, if price-sensitivity in scaleout is a large issue. A CF/MS-SQL solution requires software costs that are at a minimum W*(1295+795)+D*(5000+795)] at the low end, where W is the number of web servers (CF standard plus Win license) and D is the number of database servers (unlimited MS-SQL standard plus Windows license). Plus hardware. And support. For a LAMP solution, the cost is simply the hardware, the OS license (which could be free since there's no Windows dependency), and support. Compare the costs of 4 dual-proc web servers with a pair of clustered quad-proc database servers running CF/MS-SQL vs LAMP for fun :) There's also the strong argument of avoiding vendor lockin, which could resonate strongly as the Macromedia and Adobe merger worries folks (I think that worry is misguided personally, but it's a hard argument to counter). Not to mention as MS lurches the Longhorn schedule all over the place *and* considering there's a new (and more expensive) MS-SQL 2005 server to contend with. That said, I haven't used Perl for a significant application that I can recall (PHP, now that's a different matter). CF imho, provides significant advantages in development speed. I feel that difference whenever I switch over to PHP for a project (which I also find is faster than Perl for me). CF is also much more naturally amenably to Java shops (at least until Zend gets the PHP to Java compilation working as well as native compilation -- sound familiar to you old CF hands?) which can be an enormous benefit compared to LAMP. I'd suggest thinking about considering a ColdFusion/MySQL stack. CF runs on many platforms and can run on a number of web and J2EE servers -- and so can MySQL. Then the pitch becomes the expense of ColdFusion licenses is offset by the productivity improvements. The user can then run Windows or Linux/etc, Apache or IIS/etc, and only worry about one commercial vendor (Macromedia). Open source has many compelling argument beyond simply cheap -- commercial products more and more need a much more compelling argument about why they are better than OSS, in other words -- what am I getting for the money? If there isn't a slam-dunk answer to that question, the decision starts tipping towards OSS. CF has a number of useful extras that can justify the corresponding expense (Flash and Java integration, event gateway, reporting engine, Verity, FlashPaper, some of the new deployment options, session clustering, etc) if the application requires them. As the database world is finding out, MS-SQL (and Oracle and DB2) don't necssarily make financial or technical sense for many new (especially web-based) products.
Re: anyone bored?
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 figures @%*((% From: Joe Rinehart [EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 2:06 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: anyone bored? 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 wrote: 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. I'm also concidering going through and re-writing it as it seems like it was written quite awhile ago and would like to have it use cfc's instead, fix some of the java in it and get rid of a good chunk of the current code. thanks for input ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((% From: Joe Rinehart Sent: Tuesday, May 31, 2005 1:00 PM To: CF-Talk Subject: Re: anyone bored? 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 wrote: 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 wrote: 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 Sent: Tuesday, May 31, 2005 7:48 AM To: CF-Talk Subject: RE: anyone bored? 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 to it lemme know and I will send u link off list Yikes, I would ditch the sound on the homepage at the link above. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208077 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: DatePart problem
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 you all for the replies. adieu Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208078 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 vs LAMP
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 it's all too common on the CF lists to see free and open source used interchangably. No one's giving you the BD source code -- same as CF. BD is more like MSDE (or the new MS-SQL 2005 Express) in that it's a somewhat constrained version of a commercial product. Definitely not open source :) shameless_plug I'll be talking about open source, especially Java, at CF-United. If you're attending, you might think about coming. /shameless_plug And while I'm a fan of Blue Dragon, there are significant differences in details of implementation -- especially if you heavily use CFCs (see Barney Bosivert's blog for some ongoing love/hate discussions). Unlike J2EE servers, where there is a specification and compatibility tests for each J2EE server, BD is a reengineered (and potentially enhanced) server that is nearly 100% backwards compatible with ColdFusion. That's a real and significant difference. CFDJ, April 2005 issue, page 24. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208079 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 vs LAMP
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 value for your development dollar. That's probably not the best way to get the gig. If you can't clearly articulate why your toolset is better than a competing toolset for a given project (or even internally articulate why you'd choose one language you know over another for a project) then you're already at a significant disadvantage, especially when the other side can say Plus my toolset costs next to nothing. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 that leveraging the RAD aspect of the CF language is your primary advantage. If you convince the client that his long run costs for maintenance will save him significant $$$, that the code will be less error-prone due to it's simplicity, and that you can produce the same product for less money upfront due to its RAD nature, then you'll win the contract. Assuming that all of this is true. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 2:28 PM To: CF-Talk Subject: Re: CF vs LAMP 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 value for your development dollar. That's probably not the best way to get the gig. If you can't clearly articulate why your toolset is better than a competing toolset for a given project (or even internally articulate why you'd choose one language you know over another for a project) then you're already at a significant disadvantage, especially when the other side can say Plus my toolset costs next to nothing. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208081 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 vs LAMP
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. 2. MS SQL has Stored Procedures and other features missing from MySQL MySQL supports stored procedures, foreign keys and transactions at this point (some of these features are still in beta). 3. MS SQL easier to maintain There are a number of GUIs for managing MySQL databases these days, among them phpmyadmin. It's a stripped down web client that I find easier to use than Enterprise Manager. 4. IIS sucks Yep. 5. IIS is easier to maintain and work with than Apache Not necessarily true, especially over time. Once you nail down what it is you are trying to do with Apache, it pretty much just works no matter what else you do to your system. With IIS, the latest service packs always seem to mess something up... 6. CF costs, Perl is free 7. Perl is a pain to read, write, and maintain unless your very well versed in perl That really depends on how the Perl code was written and what conventions were used within the code. I have run into some extraordinarily bad CF apps over the years that had me yearning for Perl's tight syntax. 8. CF is easy to read, write and maintain even if your not very well versed in CF See above. The cost for MS SQL/CF is more in the short run, but when you get into programming time, new features, maintance and all MS SQL/CF wins hands down and is less than what would be paid over time with LAMP. That's speculative unless you are talking about the unique features CF possesses (things like Flashpaper). One thing LAMP has going for it over CF in terms of support over time is the huge number of content management systems that are currently out there and can be used as frameworks for new applications. Whereas with CF I spend a fair amount of time on each project working out the structural details of the project up front, with LAMP I typically spend a short amount of time considering relative benefits to going with one CMS platform over another. In terms of long term support, I would argue LAMP actually has the upper hand because most of the widely available CMS platforms out there are peer-reviewed and widely available. Finding a good CF programmer is a challenge, but finding a good Mambo, PHP-Nuke, Drupal, Wordpress or Scoop developer is not that difficult. M 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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. 2. MS SQL has Stored Procedures and other features missing from MySQL MySQL supports stored procedures, foreign keys and transactions at this point (some of these features are still in beta). 3. MS SQL easier to maintain There are a number of GUIs for managing MySQL databases these days, among them phpmyadmin. It's a stripped down web client that I find easier to use than Enterprise Manager. 4. IIS sucks Yep. 5. IIS is easier to maintain and work with than Apache Not necessarily true, especially over time. Once you nail down what it is you are trying to do with Apache, it pretty much just works no matter what else you do to your system. With IIS, the latest service packs always seem to mess something up... 6. CF costs, Perl is free 7. Perl is a pain to read, write, and maintain unless your very well versed in perl That really depends on how the Perl code was written and what conventions were used within the code. I have run into some extraordinarily bad CF apps over the years that had me yearning for Perl's tight syntax. 8. CF is easy to read, write and maintain even if your not very well versed in CF See above. The cost for MS SQL/CF is more in the short run, but when you get into programming time, new features, maintance and all MS SQL/CF wins hands down and is less than what would be paid over time with LAMP. That's speculative unless you are talking about the unique features CF possesses (things like Flashpaper). One thing LAMP has going for it over CF in terms of support over time is the huge number of content management systems that are currently out there and can be used as frameworks for new applications. Whereas with CF I spend a fair amount of time on each project working out the structural details of the project up front, with LAMP I typically spend a short amount of time considering relative benefits to going with one CMS platform over another. In terms of long term support, I would argue LAMP actually has the upper hand because most of the widely available CMS platforms out there are peer-reviewed and widely available. Finding a good CF programmer is a challenge, but finding a good Mambo, PHP-Nuke, Drupal, Wordpress or Scoop developer is not that difficult. M ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208083 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 wrong. I've been a MS-SQL DBA responsible for 28 processors of MS-SQL and I've built dozens of web apps on MS-SQL *and* MySQL so I'm definitely familiar with both. Though in all fairness, I do some work for MySQL and speak about it frequently :) MySQL has been missing views and storedprocs for years. And it's managment tools have been more akin to MS's osql and isql commandline utilities. Both fair points. But pretty inferior? No way. 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. There are certainly some criticisms that can be level at this test, but it's still the only completely transparent (in the sense of code is available, tests were specified, etc) and somewhat independent that's publically availble that I've seen. There are plenty of other real-world examples, especially in the data warehousing world. MySQL scales to dozens of processors on big iron (SGI Irix for example, AS/400, etc). The network storage engine brings 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. A few other useful features that trump MS-SQL for many applications -- per-table table handlers (don't need transactions on a table? use MyISAM). Brain-dead simple to run the memory cache. Full and early support of 64-bit processors (makes it easier to throw memory at the memory cache -- run your whole DB in memory if you want). Very high-performance JDBC drivers (one *glaring* deficiency of MS, though the open source jTS driver seems pretty good) which is especially important to CF (though the Merant drivers seem ok). That's just for starters. Interestingly now that views and stored procs are in MySQL (5.0 branch, beta as of now) they actually are doing a better job of meeting the ANSI SQL 2003 standard since they don't have to worry about backwards compatibility (ironic, huh)? Stored procs still have performance problems since they're basically 1.0 as you suggest, same with views to a lesser extent. And if you happen to get a knowledgable DBA, MySQL has *far* more ways to improve performance than MS-SQL (2000 at least) which can boost performance even more. So pretty inferior option just doesn't hold water. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208084 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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 - most pro-MySQL benchmarks use the basic MyISAM tables which don't support newer features like transactions, etc. Once you move to INNO DB to add those features you start loosing speed. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208085 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: Using XForms with CFFORM in CF7
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 PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 31, 2005 12:44 PM Subject: Using XForms with CFFORM in CF7 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 slide to on by. mysql *just* got unicode. having a plethora of encodings is not a good thing for real i18n work. you always want unicode to simplify things mysql was, until the latest version, kind of joke for that kind of complex i18n work. sql server has been able to do unicode has been able to use any collation it knows about since 7 (you can cast to a collation via the COLLATE clause). ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208087 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 5/31/05, Russ [EMAIL PROTECTED] 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208088 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
Connection closed due to session kill
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 session kill. I've searched Google, HOF and Macromedia livedocs and forums without much luck. The only thing even remotely useful I could find suggests that the error message is coming from the SequeLink driver ( http://media.datadirect.com/download/docs/slnk/errmsgs/codes.html -- do a search for session kill). Has anyone seen this before? Any idea what could be causing it and what can be done to fix it? The site is running on CFMX/SQL Server 2000 on Windows. The DB connection was going through the JDBC-ODBC bridge but was recently switched over to ODBC Sockets. These errors began around the same time as that switch but, for various reasons, the host is not willing to switch back. The files and line numbers indicated in the error messages suggest that this problem happens whether the code uses CFQUERY or CFSTOREDPROC. Any help would be greatly appreciated. TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208089 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 vs LAMP
-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 everything else, with MS-SQL coming in at the bottom. One thing - most pro-MySQL benchmarks use the basic MyISAM tables which don't support newer features like transactions, etc. Once you move to INNO DB to add those features you start loosing speed. This one didn't, however it does play to the fact that you can specify the table handler to use. The tables in the test that needed fine-grained locks (row level) used InnoDB, whereas those where table locks were appropriate or where no locking was needed, used MyISAM. K. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCnLxVmSWF0pzlQ04RAqntAJ94SSau4fEhMHl8W+JruHRMLo7P0gCeJZK9 2ajtWOlVW/l0pxxUaEKwniI= =XnwK -END PGP SIGNATURE- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208090 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 vs LAMP
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 Fusion frequently puzzles and frustrates me (of course, as has been pointed out here before, it's very easy to write bad code in just about any language; good code in PHP is a LOT easier to read than bad code in Cold Fusion, no matter how well versed you are in either language). 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. The GUI for IIS really turns me off, since I feel like I have far less control over the server and its capacities than when I can go in and edit httpd.conf directly. But then, I'm a CLI guy instead of a GUI guy, so I'm less likely to use an MS product is something more flexible exists. Running CFMX + MySql is certainly an option - if you do MS SQL, changing to MySql is no big deal. It's very easy to maintain with the new MySql admin and query analyzer tools. 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. Ultimately, I believe, the choice between LAMP and proprietary technologies falls down to a choice between flexibility and power (LAMP) vs. simplicity and ease of use (MS/CF)*. With flexibility and power comes complexity, and you do frequently have to pay more for expert knowledge; on the other hand, with simplicity and ease of use comes lack of security, so you'll end up paying more for that. Six of one, half dozen of the other, IMO. Personally, though, I am philosophically in favor of F/OS software and opposed to vendor lock-in and proprietary standards (probably because my parents were hippies and I have a background in library science), so I almost always recommend LAMP and F/OSS whenever possible. * Do not trust any studies you might encounter which recommends one approach over the other based on TCO; invariably, these studies are biased and paid for either by MS (or some other major software vendor) or by organizations such as OSDL. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208091 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 vs LAMP
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. Isn't that what SQL Query Analyzer is? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208092 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
Regular Expression help
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) {
// are regular expressions supported?
var supported = 0;
if (window.RegExp) {
var tempStr = a;
var tempReg = new RegExp(tempStr);
if (tempReg.test(tempStr)) supported = 1;
}
if (!supported)
return (str.indexOf(.) 2) (str.indexOf(@) 0);
var r1 = new RegExp((@.*@)|(\\.\\.)|(@\\.)|(^\\.));
var r2 = new
RegExp(^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$);
return (!r1.test(str) r2.test(str));
}
Rey...
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208093
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 vs LAMP
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 least maim -- to have in MS-SQL Server. Isn't that what SQL Query Analyzer is? Not quite, no. 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 issues) or the Query Analyzer (not compatible with my computer). I would love to be able to shell in via ssh to the server and execute SQL straight from a command prompt (but then, as I've mentioned, I usually prefer a CLI interface), but I can't do that with SQL Server. If I have SQL Qery Analyzer on my desktop then yes, it's more or less adequate. So what I'd like is the ability to shell in to the remote server and execute commands there, rather than on my desktop. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208094 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: Regular Expression help
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 following script to
accept domain suffixes other than .com, .net .org?
function isEmail(str) {
// are regular expressions supported?
var supported = 0;
if (window.RegExp) {
var tempStr = a;
var tempReg = new RegExp(tempStr);
if (tempReg.test(tempStr)) supported = 1;
}
if (!supported)
return (str.indexOf(.) 2) (str.indexOf(@) 0);
var r1 = new RegExp((@.*@)|(\\.\\.)|(@\\.)|(^\\.));
var r2 = new
RegExp(^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$);
return (!r1.test(str) r2.test(str));
}
Rey...
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208095
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 vs LAMP
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 wrote: Not quite, no. 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 issues) or the Query Analyzer (not compatible with my computer). I would love to be able to shell in via ssh to the server and execute SQL straight from a command prompt (but then, as I've mentioned, I usually prefer a CLI interface), but I can't do that with SQL Server. If I have SQL Qery Analyzer on my desktop then yes, it's more or less adequate. So what I'd like is the ability to shell in to the remote server and execute commands there, rather than on my desktop. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208096 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs LAMP
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. 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 $1.2M. MySQL's per server commercial license was $600 -- the same as it is for a 1 CPU Dell 750 server. /anecdote Obviously Informix would have to bring about 1.2 million dollars of extra value to the project to displace MySQL. This is obviously a bit of an edge case as far as comparisons go Not at all. Oracle is $4K per CPU for standard edition. Only when you have more then 4 CPUs in your organisation, you are not allowed to run standard edition and you have to get Enterprise Edition. That is $40K per CPU. Add some extra GIS, OLAP or clustering features at $10-20K per CPU and you easily spend $60K per CPU. Redundant production servers at 2 CPUs, staging environment, all processors double core (double pay) and you are out $700K. And that is basically for 3 dual CPU systems. At a 3-year write-off, how many DBAs can you hire for that money? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208099 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 vs LAMP
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 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 vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. Thanks, Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208100 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: DatePart problem
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 functions as mm/dd/yy if the day portion is less than or equal to 12. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208101 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 approach look more enticing, so what can I use to sway them toward CF? If they are shopping for a website, don't sell them CF, sell them a website. I know enterprise boasts being able to send over 1 million emails per hour. What other features does ColdFusion have that might make it seem better then LAMP? (Scalability, security, ease of maintenance, etc). CF doesn't have your client anything to offer over LAMP. LAMP doesn't have your client anything to offer over CF. The question is: do you have a better website and a better deal for your client then the competitor? If you offer a turn-key website including the servers and management with a one-time bill, just put the license fees in that and don't specify the lump-sum. After that, allow yourself to forget about these fees and start focussing on the business needs of your client. Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208102 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 issues) or the Query Analyzer (not compatible with my computer). I would love to be able to shell in via ssh to the server and execute SQL straight from a command prompt (but then, as I've mentioned, I usually prefer a CLI interface), but I can't do that with SQL Server. If I have SQL Qery Analyzer on my desktop then yes, it's more or less adequate. So what I'd like is the ability to shell in to the remote server and execute commands there, rather than on my desktop. That is what Remote Desktop is for. Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
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 commercial license was $600 -- the same as it is for a 1 CPU Dell 750 server. /anecdote Of course MySQL allows NULLs in NOT NULL fields among other features ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com/tiny.cfm/54 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208104 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
