RE: SQL Query Help (I'm stuck again)
this should work SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) -Oorspronkelijk bericht- Van: Michael C.Grove [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 7:26 Aan: CF-Talk CC: Onderwerp: SQL Query Help (I'm stuck again) SAMPLE 2 UPDATE Auction_Items SET Status = 'CLOSED' WHERE EXISTS(SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID AND ai.Reserve_Price ab.Bid_Amount GROUP BY ai.Product_ID, ai.Status); ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: MAC Linux laptops (was about blue dragon.)
The powerbooks get you don't they :) I'm using a 15inch powerbook 1ghz with a gig of ram, and I couldn¹t go back to a pc. My workflow has shot up since I switched. I can do everything I could before (with the exception of access - which I have since buried in the dirt) so much faster and easier. On 10/9/03 2:24, Dan O'Keefe [EMAIL PROTECTED] wrote: Not to sound like a MAC virgin, but x11 apps? What is that? One of my Sony laptops is off to be repaired once again and I was thinking about getting either a MAC or a laptop with Linux on it. Maybe one of those MAC laptops with the huge wide screen. Dan === Previous Message Below === -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 7:38 PM To: CF-Talk Subject: RE: about blue dragon. They don't crash. Excepting to install some updates last night, I've had it on with DW and various other programs open for weeks. My win2k office workstation, on the other hand, requires me to restart dreamweaver at least once a day, and reboot once a week. Also, my production servers are all *nix, so I don't have to deal with any of the potential problems moving code from windows dev machines to *nix production. Finally, you can run all the X11 apps you know and love right on the desktop intermixed with your other OSX apps. And if you're still hooked to windows, you can run emulation software or a terminal services client and easily get your MS fix. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 4:22 PM To: CF-Talk Subject: RE: about blue dragon. PowerBooks are awesome development machines! Sean A Corfield -- http://www.corfield.org/blog/ What advantages do you think they have over WIN based. What about homesite and the other MX product line? Dan ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Ports with Multiple Instances on SunONE AS 7
On Wednesday 10 Sep 2003 02:16 am, Cathy Taylor wrote: Run apache as your front end host, and use mod_proxy/mod_rewrite to draw all the app server together. That's not an option. My options are the built-in web server (in SunONE AS7) That's not really Apache is it ? I haven't been paying much attention to Sun recently, but I thought they used to make use of Apache rather than using their own... -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
queries or structs for fast looping?
Hi, I'm going to cache a bunch of data from a DB table in the Application scope for regular use through the application. Some of the processing based on this data might be quite intensive, and I was just wondering, does anyone know offhand if there are performance differences between looping through query recordsets and looping through structures (or arrays)? Should I just cache the recordset and work on that, or is it worth converting to something else (bearing in mind the conversion only has to be done each time the app times out or is reset, so that can be discounted as taking up time). cheers, Gyrus [EMAIL PROTECTED] http://norlonto.net/gyrus/dev/ PGP key available ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Requesting help - CFMX6.1 development questions
On Wednesday 10 Sep 2003 06:29 am, Rajiv Bhatia wrote: I am a new ColdFusion user. I came across your discussion group on CF_ADVISOR. I'll try to answer what I know :-) 3. FuseBox methodology along with ColdFusion Studio /or MX2004 Professional, are there any tools that I can use to accelerate development? Look into FLiP (Fuxbox Lifecycle) - basicly good prototyping practive. I think the fusbox web site has more info on this. 5. Should CFMX6.1 be considered an application server? CFMX6.1 is a J2EE application, that you deploy to a J2EE application server. It happens to come bundeled with MacroMedia's app server, JRun, if you don't already have one. We use, for instance, CFMX deployed on WebLogic. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Cracking the RDS protocol?
For the same reasons asp developers like the ability to edit data in addition to browsing, as well as stored proc editing and debugging straight from their ide. I just can't imagine, for the life of me, how you could find RDS lacking in any regard In my case, I simply don't interact with an RDBMS through JDBC, so I never SQL or stored procedures anyway. I'm always tying into backends through a Java API. Further, the last time I did work on a project with a RDBMS that was meant to be access from CFML, we kept strict separation of the CFML developers from the SQL developers. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Ports with Multiple Instances on SunONE AS 7
That's not really Apache is it ? No, it's the old Netscape iPlanet (upgraded a bit). ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Cracking the RDS protocol?
Why not just run the server on your local machine for development? Matt - this is what we're contemplating doing here. But, it brings up other issues - like how to handle directories that would be LDAP protected on the live (in our case development) server, where we rely on the cgi.remote_user variable to determine who someone is. Do you use LDAP to protect directories? Does this mean all your developers run LDAP on their desktops so they can mimic what happens on the server? Or, do you spoof code on the local machines - something like: cfif NOT LEN(cgi.remote_user) cfset loggedinuser = somehardcodedvalue cfelse cfset loggedinuser = cgi.remote_user /cfif (I have no idea if it's even possible to run LDAP locally - let alone being able to replicate the data on the live server.) (I was trying to get at this and some other ideas with my development environment thread, but it never got there) -Deanna ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: Devnet Subscription Value
Hi, Here I go off-topic again...50 lashings for me. Anyway, I want some input/advice on the Macromedia Devnet subscription. I am a self-employed consultant with a ligit copy of Studio MX. I use DWMX, CF, Fireworks and JRun daily. I dabble with Flash and really hope to expand on that. I am now faced with upgrading to MX 2004. I attended the webcast and am impressed with some of the new features. As you likely know, purchasing a DevNet subscription is more cost-effective that just upgrading studio. So my question is: Is DevNet really that great? It appears to have some cool canned code and tips. As I am paying from my own pocket, and with Canadian $ on top of that, I will be out just over $800 and would really appreciate any advice or comments from those of you already subscribed. Thanks in advance, James ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Cracking the RDS protocol?
I long ago stopped using the traditional web site security model based on directory structure. I make use of request dispatchers that handle all requests and then dispatch the request to the correct handler. This allows among other things an easy way to handle security. Further, to speak directly to your question about LDAP; I do use it. Only my applications make use of JAAS for security, so they are decoupled from the actual implementation. Thus, one of my applications can run locally using a password database of my creation and use LDAP in production with only a simple configuration change at deployment; read no code changes. -Matt On Wednesday, September 10, 2003, at 08:42 AM, Deanna Schneider wrote: Why not just run the server on your local machine for development? Matt - this is what we're contemplating doing here. But, it brings up other issues - like how to handle directories that would be LDAP protected on the live (in our case development) server, where we rely on the cgi.remote_user variable to determine who someone is. Do you use LDAP to protect directories? Does this mean all your developers run LDAP on their desktops so they can mimic what happens on the server? Or, do you spoof code on the local machines - something like: cfif NOT LEN(cgi.remote_user) cfset loggedinuser = somehardcodedvalue cfelse cfset loggedinuser = cgi.remote_user /cfif (I have no idea if it's even possible to run LDAP locally - let alone being able to replicate the data on the live server.) (I was trying to get at this and some other ideas with my development environment thread, but it never got there) -Deanna ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Devnet Subscription Value
We just subscribed to devnet pro to get Studio 2004, we were essentials subscribers for a while. It's a pretty good value although I'm a bit disappointed with the site itself (typically runs pretty slow for me, and is even slower now that everyone is hitting it) but it is sure better than waiting for CD's to come in the mail. Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:46 AM To: CF-Talk Subject: OT: Devnet Subscription Value Hi, Here I go off-topic again...50 lashings for me. Anyway, I want some input/advice on the Macromedia Devnet subscription. I am a self-employed consultant with a ligit copy of Studio MX. I use DWMX, CF, Fireworks and JRun daily. I dabble with Flash and really hope to expand on that. I am now faced with upgrading to MX 2004. I attended the webcast and am impressed with some of the new features. As you likely know, purchasing a DevNet subscription is more cost-effective that just upgrading studio. So my question is: Is DevNet really that great? It appears to have some cool canned code and tips. As I am paying from my own pocket, and with Canadian $ on top of that, I will be out just over $800 and would really appreciate any advice or comments from those of you already subscribed. Thanks in advance, James ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Cracking the RDS protocol?
We're so not there yet. Thanks, though. - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 7:54 AM Subject: Re: Cracking the RDS protocol? I long ago stopped using the traditional web site security model based on directory structure. I make use of request dispatchers that handle all requests and then dispatch the request to the correct handler. This allows among other things an easy way to handle security. Further, to speak directly to your question about LDAP; I do use it. Only my applications make use of JAAS for security, so they are decoupled from the actual implementation. Thus, one of my applications can run locally using a password database of my creation and use LDAP in production with only a simple configuration change at deployment; read no code changes. -Matt On Wednesday, September 10, 2003, at 08:42 AM, Deanna Schneider wrote: Why not just run the server on your local machine for development? Matt - this is what we're contemplating doing here. But, it brings up other issues - like how to handle directories that would be LDAP protected on the live (in our case development) server, where we rely on the cgi.remote_user variable to determine who someone is. Do you use LDAP to protect directories? Does this mean all your developers run LDAP on their desktops so they can mimic what happens on the server? Or, do you spoof code on the local machines - something like: cfif NOT LEN(cgi.remote_user) cfset loggedinuser = somehardcodedvalue cfelse cfset loggedinuser = cgi.remote_user /cfif (I have no idea if it's even possible to run LDAP locally - let alone being able to replicate the data on the live server.) (I was trying to get at this and some other ideas with my development environment thread, but it never got there) -Deanna ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Paging Principals
Hi, I have an app that queries a table and displays a subset of the query results in a paged format, showing only 10 results per page. Some queries will return upwards of 1,000 rows. This query joins quite a few tables - say 8 or so, however the query itself only requires one table to obtain the basis of the dataset(the rest of the tables in the join are used for display info or 'cosmetic' type information). Generally speaking, which of the following would be more efficient: Option 1: - Query database, joining 8 tables, get entire dataset (1000 rows) - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) Option 2: - Query database only based on the results of one table (1000 rows) - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) - within output loop, perform second query joining the 8 tables, based on a single primary key returned from the initial dataset. (returns single row) In essence, the question revolves around whether it is more expensive to pull an entire 1,000 record joined dataset in one shot, or to make the initial query lean, and then do ten consecutive queries performing the join. The former likely incurs more database load, while the latter would incur more interaction with odbc. Whew. Interested in your answers! Thanks, Geoffrey Brown Online Operations Manager Deerfield.com 989.732.8856 ext. 227 (Gaylord) 231.935.4640 ext. 123 (Traverse City) [EMAIL PROTECTED] http://www.deerfield.com Personal Service with a :-) VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Cracking the RDS protocol?
Well in our case, we can't (or haven't figured out how to) run a development server on the local machine because the dev/production servers are where we have the filesystem/ldap security. I don't know of any way to replicate that on the local development machine. It also looks like we don't have the schema permissions to set up the appropriate datasource connection to our Oracle server on the local machine. We don't have RDS either though. We've managed to work directly on server shares on trusted IPs and ftp for others, but even that is getting complicated now with other Dreamweaver and Contribute users on the same system. -Kevin - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:28 PM Subject: Re: Cracking the RDS protocol? RDS is great 'cause it provides real in-place editing. With all other technologies, you have download/change/upload concept (although it can be hidden by the IDE). With RDS, it's pretty much always in-place editing so changes are immediately seen by others and via the CF server. Why not just run the server on your local machine for development? For DB access RDS is nice 'cause you have access to all the same datasources that the CF server has. You don't need connection information and you don't need to open the database port up on the firewall. It also goes through whatever security restrictions are set on the datasource. Again, wouldn't it be easy to access the BD on your local machine. That said, we recently dropped support for RDS on our system setup, switching to CVS and SQL+. I still use it almost daily to access my home servers and blog server though. Editing stuff on live servers sounds scary! Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
FB4 Downloads
Does anyone have the FB4 files they can either send to us or put up a link please? pretty please? with cf_sugar on top?? Steph Does anyone know where FB4 can be downloaded? It seems the FB beta site is down and I really need to get these files. Thanks, Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Macromedia Folks - Upgrades to MX2004?
We have the two year subscription for Studio MX. I assume this includes the upgrades to StudioMX2004 but is there an additional fee to upgrade to FlashMX2004 professional? Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Paging Principals
Do you plan to cache the query? If you run the big query once, and then cache it, I'd reckon that option 1 is going to be your faster option. - Original Message - From: Geoffrey V. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:17 AM Subject: Paging Principals Hi, I have an app that queries a table and displays a subset of the query results in a paged format, showing only 10 results per page. Some queries will return upwards of 1,000 rows. This query joins quite a few tables - say 8 or so, however the query itself only requires one table to obtain the basis of the dataset(the rest of the tables in the join are used for display info or 'cosmetic' type information). Generally speaking, which of the following would be more efficient: Option 1: - Query database, joining 8 tables, get entire dataset (1000 rows) - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) Option 2: - Query database only based on the results of one table (1000 rows) - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) - within output loop, perform second query joining the 8 tables, based on a single primary key returned from the initial dataset. (returns single row) In essence, the question revolves around whether it is more expensive to pull an entire 1,000 record joined dataset in one shot, or to make the initial query lean, and then do ten consecutive queries performing the join. The former likely incurs more database load, while the latter would incur more interaction with odbc. Whew. Interested in your answers! Thanks, Geoffrey Brown Online Operations Manager Deerfield.com 989.732.8856 ext. 227 (Gaylord) 231.935.4640 ext. 123 (Traverse City) [EMAIL PROTECTED] http://www.deerfield.com Personal Service with a :-) VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Cracking the RDS protocol?
-Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 12:05 AM To: CF-Talk Subject: Re: Cracking the RDS protocol? Why not just run the server on your local machine for development? Absolutely. I don't see any advantage working on files on the server. One would not work on the files on the production server (I hope!). So you need to work on a miror of the application, and still have to update the production server when everything is debugged, so why not your own desk top? This is not always possible. We have some boxes behind firewalls within our intranet for dta security reasons. Only certain IPs have access. We wouldn't want 100 developers having access via there desktop PCs. Obviously RDS should be disabled for production boxes. Doug Again, wouldn't it be easy to access the BD on your local machine. Actually, the only advantage I see to use RDS is to be able to view the database structure from your CF editor, and generate intelligent SQL code adapted to CF. But again, the SQL builder does not really take advantage of this and the facility to build queries in DW clearly has been designed by some one you never really used CF. - when you want to create an INSERT or UPDATE query, you need to create a record set (SELECT) first... why? - it not only generates the update query, but also the form to get values from user... in the SAME template, this is just ridiculous. What if I don't want the form? - it generates inefficient and stupid code for any VALUE like CFIF NOT isDefined (form.columnName) OR form.columnName EQ #form.columnName# CFELSE null /CFIF A much more efficient thing to do would be to omit the column name and let the database take care of the null. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: FB4 Downloads
Here they are. -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:21 AM To: CF-Talk Subject: FB4 Downloads Does anyone have the FB4 files they can either send to us or put up a link please? pretty please? with cf_sugar on top?? Steph Does anyone know where FB4 can be downloaded? It seems the FB beta site is down and I really need to get these files. Thanks, Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: FB4 Downloads
Here they are -Original Message- From: Clint [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 9:50 PM To: CF-Talk Subject: Re: FB4 Downloads Ihave done the same thing and no files have been sent. I really need these for a contract that I am about to start. Thanks, Clint - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Subject: FB4 Downloads the site has been coming and going, however, i have hit the request page about 6 times with 2 email addresses and no files have shown up. steph Beta site seems to be up. If not let me know and I will email them to you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Paging Principals
When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager : Deerfield.com : 989.732.8856 ext. 227 (Gaylord) : 231.935.4640 ext. 123 (Traverse City) : [EMAIL PROTECTED] : : http://www.deerfield.com : Personal Service with a :-) : : VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: FB4 Downloads
Sorry thought I was replying directly. For those who need the core files email me directly and I'll send them to you. Sandy [EMAIL PROTECTED] -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:21 AM To: CF-Talk Subject: FB4 Downloads Does anyone have the FB4 files they can either send to us or put up a link please? pretty please? with cf_sugar on top?? Steph Does anyone know where FB4 can be downloaded? It seems the FB beta site is down and I really need to get these files. Thanks, Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Farcry and CFMX6.1
http://farcry.daemon.com.au/index.cfm Anyone get this up and running against an Oracle DB? I'm having the darndest time with it. Lots of errors in the install scripts. Many invlove ; in SQL in cfquery, bombs out an SQL statement. Also, seems you can't execute multiple SQL stements in one cfquery block now in CFMX. I thought you could inCF5.0 and belowme might've missed that white paper... dugOUT ô¿ô When I was kidnapped, my parents snapped into action. They rented out my room. -- Woody Allen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Paging Principals
Hi, Good idea. A cached query wouldn't work for us, unfortunately, as the data changes almost by the minute. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: RE: Paging Principals When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager : Deerfield.com : 989.732.8856 ext. 227 (Gaylord) : 231.935.4640 ext. 123 (Traverse City) : [EMAIL PROTECTED] : : http://www.deerfield.com : Personal Service with a :-) : : VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Macromedia Folks - Upgrades to MX2004?
I'm in the same boat. In addition, we bought firefly and DevNet Essentials. The boss isn't happy about a fee for Flash MX 2004 Pro. I'd love to get an answer to this as well :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/10/2003 9:21:18 AM We have the two year subscription for Studio MX. I assume this includes the upgrades to StudioMX2004 but is there an additional fee to upgrade to FlashMX2004 professional? Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Farcry and CFMX6.1
Doug, I don't know if it's something you can configure or not, but we're running 5.0 and you can't do more than one sql statement in a cfquery block against Oracle. -Deanna - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:45 AM Subject: Farcry and CFMX6.1 http://farcry.daemon.com.au/index.cfm Anyone get this up and running against an Oracle DB? I'm having the darndest time with it. Lots of errors in the install scripts. Many invlove ; in SQL in cfquery, bombs out an SQL statement. Also, seems you can't execute multiple SQL stements in one cfquery block now in CFMX. I thought you could inCF5.0 and belowme might've missed that white paper... dugOUT ô¿ô When I was kidnapped, my parents snapped into action. They rented out my room. -- Woody Allen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
tax and shipping
Hello, Anyone out there know and/or have CF modules to calculate sales tax and shipping according to states or zones( including Canada)? What vendors offer these scripts or programs. We're working on a shopping cart that will need these calculations. Thanks. Robert O. HWW ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Farcry and CFMX6.1
Yeah I have that same problem, I do not know what the issue is Tyler Clendenin GSL Solutions -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:03 AM To: CF-Talk Subject: Re: Farcry and CFMX6.1 Doug, I don't know if it's something you can configure or not, but we're running 5.0 and you can't do more than one sql statement in a cfquery block against Oracle. -Deanna - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:45 AM Subject: Farcry and CFMX6.1 http://farcry.daemon.com.au/index.cfm Anyone get this up and running against an Oracle DB? I'm having the darndest time with it. Lots of errors in the install scripts. Many invlove ; in SQL in cfquery, bombs out an SQL statement. Also, seems you can't execute multiple SQL stements in one cfquery block now in CFMX. I thought you could inCF5.0 and belowme might've missed that white paper... dugOUT ô¿ô When I was kidnapped, my parents snapped into action. They rented out my room. -- Woody Allen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Farcry and CFMX6.1
right. kewl. Having to go through the install scripts and change all the cfquery calls that have multiple sql statements in them. woohoo! Doug -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:03 AM To: CF-Talk Subject: Re: Farcry and CFMX6.1 Doug, I don't know if it's something you can configure or not, but we're running 5.0 and you can't do more than one sql statement in a cfquery block against Oracle. -Deanna - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:45 AM Subject: Farcry and CFMX6.1 http://farcry.daemon.com.au/index.cfm Anyone get this up and running against an Oracle DB? I'm having the darndest time with it. Lots of errors in the install scripts. Many invlove ; in SQL in cfquery, bombs out an SQL statement. Also, seems you can't execute multiple SQL stements in one cfquery block now in CFMX. I thought you could inCF5.0 and belowme might've missed that white paper... dugOUT ô¿ô When I was kidnapped, my parents snapped into action. They rented out my room. -- Woody Allen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Farcry and CFMX6.1
looks like I got to go through and mangle the install scripts then. Was hoping someone else had done that already and they were feeling generous. :) Well, if I get it all working, I'll post here. Its a very low priority for me at the moment though... Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:20 AM To: CF-Talk Subject: RE: Farcry and CFMX6.1 Yeah I have that same problem, I do not know what the issue is Tyler Clendenin GSL Solutions -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:03 AM To: CF-Talk Subject: Re: Farcry and CFMX6.1 Doug, I don't know if it's something you can configure or not, but we're running 5.0 and you can't do more than one sql statement in a cfquery block against Oracle. -Deanna - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:45 AM Subject: Farcry and CFMX6.1 http://farcry.daemon.com.au/index.cfm Anyone get this up and running against an Oracle DB? I'm having the darndest time with it. Lots of errors in the install scripts. Many invlove ; in SQL in cfquery, bombs out an SQL statement. Also, seems you can't execute multiple SQL stements in one cfquery block now in CFMX. I thought you could inCF5.0 and belowme might've missed that white paper... dugOUT ô¿ô When I was kidnapped, my parents snapped into action. They rented out my room. -- Woody Allen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
is date within dst
is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? thanks tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
What's the matter here? RSS feed error
Can anyone see what's the matter with this code? I'm consuming a RSS feed, using the following code ... [quote] cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) [/quote] But a CFDUMP of objRSS on the next line gives me the following error: [quote] End of entity not allowed; an end tag is missing. [/quote] The guy generating the feed says he's validated his xml page, and says there's nothing wrong with it. So Before I tell him he's wrong, is there anything wrong with my code? Can anyone else get this RSS code satisfactorily? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Paging Principals
Geoff we do something like this with a large record-set. We run the full query at the outset and put it into a Session based Structure then page through that. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 6:47 AM To: CF-Talk Subject: RE: Paging Principals Hi, Good idea. A cached query wouldn't work for us, unfortunately, as the data changes almost by the minute. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: RE: Paging Principals When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager : Deerfield.com : 989.732.8856 ext. 227 (Gaylord) : 231.935.4640 ext. 123 (Traverse City) : [EMAIL PROTECTED] : : http://www.deerfield.com : Personal Service with a :-) : : VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Query Help (I'm stuck again)
Using the following code, I get cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery pNon-Sale Report/p cfoutput query=Auction_GetAuctions #Product_ID# #status#br /cfoutput ERROR --- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'ai.Reserve_PriceMAX(ab.Bid_Amount)' as part of an aggregate function. I think we are close, but still having problems. Original Message: From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 08:36:33 +0200 this should work SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) -Oorspronkelijk bericht- Van: Michael C.Grove [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 7:26 Aan: CF-Talk CC: Onderwerp: SQL Query Help (I'm stuck again) SAMPLE 2 UPDATE Auction_Items SET Status = 'CLOSED' WHERE EXISTS(SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID AND ai.Reserve_Price ab.Bid_Amount GROUP BY ai.Product_ID, ai.Status); ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Cracking the RDS protocol?
No, it's also used to edit files. Its big advantage is that it easily allows remote access, when you haven't set up any other alternative for remote access, without worrying about firewall configuration or software installation. I don't know whether a lot of people use it when they have LAN access to their web server's filesystem. But isn't the general recommendation to disable RDS on production servers? Well, sure, that's the general recommendation. I'm sure that plenty of people don't follow that general recommendation, though. Most web application security best practices are more honored in the breach than the observance, aren't they? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Running Batch Script
I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat/cfexecute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin Any suggetions.. Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL Query Help (I'm stuck again)
You still need the 'MAX(ab.Bid_Amount)' in the SELECT part of the query. The HAVING clause does a secondary filter on this Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: grovem [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:16 To: CF-Talk Subject: RE: SQL Query Help (I'm stuck again) Using the following code, I get cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery pNon-Sale Report/p cfoutput query=Auction_GetAuctions #Product_ID# #status#br /cfoutput ERROR --- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'ai.Reserve_PriceMAX(ab.Bid_Amount)' as part of an aggregate function. I think we are close, but still having problems. Original Message: From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 08:36:33 +0200 this should work SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) -Oorspronkelijk bericht- Van: Michael C.Grove [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 7:26 Aan: CF-Talk CC: Onderwerp: SQL Query Help (I'm stuck again) SAMPLE 2 UPDATE Auction_Items SET Status = 'CLOSED' WHERE EXISTS(SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID AND ai.Reserve_Price ab.Bid_Amount GROUP BY ai.Product_ID, ai.Status); ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat /cfexecute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin It's probably a permissions problem. Is the CF service running as a user with rights to stop services on SERVERA? By default, the CF services runs as SYSTEM, which has no rights to network resources at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Query Help (I'm stuck again)
If I ad the Max(ab.Bid_Amount) to the select statment and remove the HAVING line, I do not get any errors, but I also return all records that have had a bid. When I ad the HAVING line [below] I receve the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'MAX(ab.Bid_Amount)ai.Reserve_Price' as part of an aggregate function. cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status, MAX(ab.Bid_Amount) AS HighBid FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery basically this needs to pull all of the records that did not receive a bid meeting or exceeding the reserve price. Thanks Again Original Message: From: Michael Traher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 15:28:19 +0100 You still need the 'MAX(ab.Bid_Amount)' in the SELECT part of the query. The HAVING clause does a secondary filter on this Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: grovem [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:16 To: CF-Talk Subject: RE: SQL Query Help (I'm stuck again) Using the following code, I get cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery pNon-Sale Report/p cfoutput query=Auction_GetAuctions #Product_ID# #status#br /cfoutput ERROR --- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'ai.Reserve_PriceMAX(ab.Bid_Amount)' as part of an aggregate function. I think we are close, but still having problems. Original Message: From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 08:36:33 +0200 this should work SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) -Oorspronkelijk bericht- Van: Michael C.Grove [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 7:26 Aan: CF-Talk CC: Onderwerp: SQL Query Help (I'm stuck again) SAMPLE 2 UPDATE Auction_Items SET Status = 'CLOSED' WHERE EXISTS(SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID AND ai.Reserve_Price ab.Bid_Amount GROUP BY ai.Product_ID, ai.Status); ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: is date within dst
well... I found this vbscript...that does it... but now to convert...ill let you all know. maybe a good candidate for udf :) later. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:20 AM To: CF-Talk Subject: is date within dst is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? thanks tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Cracking the RDS protocol?
We wouldn't want 100 developers having access via there desktop PCs. I was meaning doing everything on PCs, including database replicas, etc. Even with Oracle, you can have a Personal Oracle installed on you PC. Of course, this is not always possible on very large installations. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
Coldfusion runs under domain account and that user has got Administrative Access. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:43 To: CF-Talk Subject: RE: Running Batch Script I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat /cfexecute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin It's probably a permissions problem. Is the CF service running as a user with rights to stop services on SERVERA? By default, the CF services runs as SYSTEM, which has no rights to network resources at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Query Help (I'm stuck again)
You need ai.Reserve_Price in the select (NOT the aggregate function) AND the HAVING clause. Because of the inner join, you will NOT get the records that did not receive a bid. -Oorspronkelijk bericht- Van: grovem [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 16:43 Aan: CF-Talk CC: Onderwerp: RE: SQL Query Help (I'm stuck again) If I ad the Max(ab.Bid_Amount) to the select statment and remove the HAVING line, I do not get any errors, but I also return all records that have had a bid. When I ad the HAVING line [below] I receve the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'MAX(ab.Bid_Amount)ai.Reserve_Price' as part of an aggregate function. cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status, MAX(ab.Bid_Amount) AS HighBid FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery basically this needs to pull all of the records that did not receive a bid meeting or exceeding the reserve price. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Running Batch Script
Coldfusion runs under domain account and that user has got Administrative Access. Does the account have a persistent drive mapping to the X drive, where the batch file is located? I'm guessing it does, but it doesn't hurt to ask. And, while you've confirmed that account, you might want to login with that account and run the batch file from an interactive console session to see if it works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Paging Principals
Not necessarily a bad idea even if the content changes. Think about it, if you pull the entire recordset and page through it, if the content changes while you're browsing you're still looking at old content. We do this with large recordsets (as many as 100,000 rows) and what we do is cache the query for 15 minutes, plenty of time to browse the recordset. If a user makes a modification then we release the query cache and the next person to hit the Next-N scenario creates a new query cache based on the new data. The speed gain for the end-user was tremendous compared with going back to the database each time and pulling the next however many records. We tried your scenario number 2 and things were considerably slower for us than just running the whole query outright and caching it. Granted you need a lot more RAM, but it's cheap. I'd rather buy more RAM and have the application run quicker for the end-user. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:47 AM To: CF-Talk Subject: RE: Paging Principals Hi, Good idea. A cached query wouldn't work for us, unfortunately, as the data changes almost by the minute. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: RE: Paging Principals When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager : Deerfield.com : 989.732.8856 ext. 227 (Gaylord) : 231.935.4640 ext. 123 (Traverse City) : [EMAIL PROTECTED] : : http://www.deerfield.com : Personal Service with a :-) : : VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the
RE: SQL Query Help (I'm stuck again)
that worked, thank you very much. So far out of all the resources I have used in the past, this one is by far the best. Original Message: From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 16:51:14 +0200 You need ai.Reserve_Price in the select (NOT the aggregate function) AND the HAVING clause. Because of the inner join, you will NOT get the records that did not receive a bid. -Oorspronkelijk bericht- Van: grovem [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 16:43 Aan: CF-Talk CC: Onderwerp: RE: SQL Query Help (I'm stuck again) If I ad the Max(ab.Bid_Amount) to the select statment and remove the HAVING line, I do not get any errors, but I also return all records that have had a bid. When I ad the HAVING line [below] I receve the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'MAX(ab.Bid_Amount)ai.Reserve_Price' as part of an aggregate function. cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status, MAX(ab.Bid_Amount) AS HighBid FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery basically this needs to pull all of the records that did not receive a bid meeting or exceeding the reserve price. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Paging Principals
You could download the whole thing and stick it in a wddx or javascript array. Then when the user clicks next, you just use the info from the javascript array. Also, if youre on ie, you can do this with tdc. Very slick. Then you can incorporate sorting. TDC sorts 5 records (yes our users are insane) in the blink of an eye. Of course its ie specific. DRE -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:08 AM To: CF-Talk Subject: RE: Paging Principals Not necessarily a bad idea even if the content changes. Think about it, if you pull the entire recordset and page through it, if the content changes while you're browsing you're still looking at old content. We do this with large recordsets (as many as 100,000 rows) and what we do is cache the query for 15 minutes, plenty of time to browse the recordset. If a user makes a modification then we release the query cache and the next person to hit the Next-N scenario creates a new query cache based on the new data. The speed gain for the end-user was tremendous compared with going back to the database each time and pulling the next however many records. We tried your scenario number 2 and things were considerably slower for us than just running the whole query outright and caching it. Granted you need a lot more RAM, but it's cheap. I'd rather buy more RAM and have the application run quicker for the end-user. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:47 AM To: CF-Talk Subject: RE: Paging Principals Hi, Good idea. A cached query wouldn't work for us, unfortunately, as the data changes almost by the minute. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: RE: Paging Principals When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager :
RE: Running Batch Script
This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? Shaz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:57 To: CF-Talk Subject: RE: Running Batch Script Coldfusion runs under domain account and that user has got Administrative Access. Does the account have a persistent drive mapping to the X drive, where the batch file is located? I'm guessing it does, but it doesn't hurt to ask. And, while you've confirmed that account, you might want to login with that account and run the batch file from an interactive console session to see if it works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: What's the matter here? RSS feed error
Can anyone see what's the matter with this code? I'm consuming a RSS feed, using the following code ... [quote] cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) [/quote] But a CFDUMP of objRSS on the next line gives me the following error: [quote] End of entity not allowed; an end tag is missing. [/quote] The guy generating the feed says he's validated his xml page, and says there's nothing wrong with it. So Before I tell him he's wrong, is there anything wrong with my code? Can anyone else get this RSS code satisfactorily? I was able to fetch his RSS file successfully, and it appears to be valid XML to me, as rendered by Internet Explorer. You might use CFDUMP on CFHTTP.FileContent, to see what you're getting back. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? I'm out of obvious ideas. I'd recommend that you try to break the problem down into smaller components. For example, can you run any other things through CFEXECUTE? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: is date within dst
if you don't mind some java might look at: java.util.TimeZone and inDaylightTime() method is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFHTTP with CFMX
I'm simply trying to grab a stock page from yahoo but it never returns anything. If I paste the url into my browser I get back the expected results. Is there something I'm missing in my code? CFHTTP METHOD=GET URL=http://quote.yahoo.com/download/quotes.csv?Symbols=MACR+MSFTformat=sl1 d1t1c1ohgvext=.csv NAME=Quotes COLUMNS=Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Change,O pening_Price,Days_High,Days_Low,Volume DELIMITER=, TEXTQUALIFIER= CFDUMP var=#Quotes# Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: is date within dst
severely mind java :) since I really don't know it at all. how would one do such a task, with that function? java.util.TimeZone and inDaylightTime() method matt :) help, maybe? thanks. tony ps. I got it done in cf, just now have to work on handling a year like 2007 where april 1 is the 1st Sunday in april (the beginning of DST) and the cflib.org function getDayLightSavingTimeStart() returns the 2nd of april, but that's wrong. the rule is 1 Sunday in april, and that is, april 1 that year. any ideas? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:47 AM To: CF-Talk Subject: Re: is date within dst if you don't mind some java might look at: java.util.TimeZone and inDaylightTime() method is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
getting image info with CF
Hi, Is there any way to get the width and height information of an image file with Coldfusion? thanks Chris __ Christian BOUDOT Intrasoft International 89-91 route de Thionville L-2611 Luxembourg Tel: +352 44 10 12 21 05 Fax: +352 44 10 12 23 59 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Paging Principals
It just doesn't make sense to me for a query to go after 100,000 records just to end up on a web page. I would prefer to run much smaller (page size) individual queries as this will return much faster than all that unneeded server processing. Then re-query for the next in the series when the visitor clicks next Each time you click next fresh data is delivered. If the information is changing that often, then I add a refresh button on the page. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:08 AM Subject: RE: Paging Principals | Not necessarily a bad idea even if the content changes. Think about it, | if you pull the entire recordset and page through it, if the content | changes while you're browsing you're still looking at old content. We do | this with large recordsets (as many as 100,000 rows) and what we do is | cache the query for 15 minutes, plenty of time to browse the recordset. | If a user makes a modification then we release the query cache and the | next person to hit the Next-N scenario creates a new query cache based | on the new data. The speed gain for the end-user was tremendous compared | with going back to the database each time and pulling the next however | many records. | | We tried your scenario number 2 and things were considerably slower for | us than just running the whole query outright and caching it. Granted | you need a lot more RAM, but it's cheap. I'd rather buy more RAM and | have the application run quicker for the end-user. | | Joshua Miller | Head Programmer / IT Manager | Garrison Enterprises Inc. | www.garrisonenterprises.net | [EMAIL PROTECTED] | (704) 569-0801 ext. 254 | | | * | Any views expressed in this message are those of the individual sender, | except where the sender states them to be the views of | Garrison Enterprises Inc. | | This e-mail is intended only for the individual or entity to which it is | addressed and contains information that is private and confidential. If | you are not the intended recipient you are hereby notified that any | dissemination, distribution or copying is strictly prohibited. If you | have received this e-mail in error please delete it immediately and | advise us by return e-mail to [EMAIL PROTECTED] | | * | | | -Original Message- | From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] | Sent: Wednesday, September 10, 2003 9:47 AM | To: CF-Talk | Subject: RE: Paging Principals | | | Hi, | Good idea. | A cached query wouldn't work for us, unfortunately, as the data changes | almost by the minute. | | Geoff B | | -Original Message- | From: Ben Doom [mailto:[EMAIL PROTECTED] | Sent: Wednesday, September 10, 2003 9:43 AM | To: CF-Talk | Subject: RE: Paging Principals | | | When I had something like this, I used the full query but only | retrieved the | top n, where n is the highest index to display. So, if you are | displaying | 10 per page... | | page 1, n=10 | page 2, n=20 | | and so on. Maybe not a perfect solution, but dropped average | processing | time a lot, since people would generally either narrow the search or | only | look at the first page or two. | | If you think people might be flipping through a large number of | pages, look | at query caching. | | | -- Ben Doom | Programmer General Lackey | Moonbow Software, Inc | | : -Original Message- | : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] | : Sent: Wednesday, September 10, 2003 9:18 AM | : To: CF-Talk | : Subject: Paging Principals | : | : | : Hi, | : I have an app that queries a table and displays a subset of the | query | : results in a paged format, showing only 10 results per page. | Some queries | : will return upwards of 1,000 rows. | : | : This query joins quite a few tables - say 8 or so, however the | : query itself | : only requires one table to obtain the basis of the dataset(the | rest of the | : tables in the join are used for display info or 'cosmetic' type | : information). | : | : Generally speaking, which of the following would be more efficient: | : | : Option 1: | : - Query database, joining 8 tables, get entire dataset (1000 rows) | : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows | (10) | : | : Option 2: | : - Query database only based on the results of
RE: getting image info with CF
cfx_imgsize is a custom tag that returns those properties. I think you can get it from the dev exchange on macromedia.com somewhere. later tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: BOUDOT Christian [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:42 AM To: CF-Talk Subject: getting image info with CF Hi, Is there any way to get the width and height information of an image file with Coldfusion? thanks Chris __ Christian BOUDOT Intrasoft International 89-91 route de Thionville L-2611 Luxembourg Tel: +352 44 10 12 21 05 Fax: +352 44 10 12 23 59 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: What's the matter here? RSS feed error
Thanks for your suggestion, Dave. I ran the following: cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfdump var=#cfhttp.filecontent# And the file doesn't end properly. The last few characters of the CFDUMP look like this: [quote] name=Newsamp;file=articleamp;sid=59/link descriptionToday is the 11th birthday for Cybergrass [/quote] The dump is nowhere near long enough. Yet, when I put the same code in a bare-bones .cfm page, with no formatting, tables, other content, just the minimum required for a properly formatted html page, I get a properly formatted struct with the xml content properly arrayed there. What can be truncating the feed? There's nothing special about the page, (which is at http://bluegrass.org.au/Magazine/USANews/index2.cfm ) that I can see that might be truncating the XML. Is this a known problem of some kind? There is no content except a CF/LF between getting the XML file, and CFDUMPing it. I'd have thought any other content wouldn't interfere, even if it had something in it that the XML parser didn't like. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 September 2003 1:26 AM To: CF-Talk Subject: RE: What's the matter here? RSS feed error Can anyone see what's the matter with this code? I'm consuming a RSS feed, using the following code ... [quote] cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) [/quote] But a CFDUMP of objRSS on the next line gives me the following error: [quote] End of entity not allowed; an end tag is missing. [/quote] The guy generating the feed says he's validated his xml page, and says there's nothing wrong with it. So Before I tell him he's wrong, is there anything wrong with my code? Can anyone else get this RSS code satisfactorily? I was able to fetch his RSS file successfully, and it appears to be valid XML to me, as rendered by Internet Explorer. You might use CFDUMP on CFHTTP.FileContent, to see what you're getting back. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
cflib.org and dependent functions
Ive got a silly question. why would there be a udf on cflib, that requires another udf to function? kinda weird maybe? maybe not? getDayLightSavingTimeStart() requires GetNthOccOfDayInMonth() to work. just wondering. thanks. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:47 AM To: CF-Talk Subject: Re: is date within dst if you don't mind some java might look at: java.util.TimeZone and inDaylightTime() method is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: getting image info with CF
If you are using MX then this code should work...
function getImageDimensions(sFile)
{
var strRtn = StructNew();
var oImage =
createObject(java,javax.swing.ImageIcon).init(sFile);
strRtn.Width = oImage.getIconWidth();
strRtn.Height = oImage.getIconHeight();
strRtn.FileName = GetFileFromPath(sFile);
return strRtn
}
HTH
-Original Message-
From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 16:42
To: CF-Talk
Subject: getting image info with CF
Hi,
Is there any way to get the width and height information of an image file
with Coldfusion?
thanks
Chris
__
Christian BOUDOT
Intrasoft International
89-91 route de Thionville
L-2611 Luxembourg
Tel: +352 44 10 12 21 05
Fax: +352 44 10 12 23 59
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
RE: cflib.org and dependent functions
nevermind, from udf browser it doesn't tell you of the dependency, but I see from the cflib.org page, that it tells you :) thanks tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:43 AM To: CF-Talk Subject: cflib.org and dependent functions Ive got a silly question. why would there be a udf on cflib, that requires another udf to function? kinda weird maybe? maybe not? getDayLightSavingTimeStart() requires GetNthOccOfDayInMonth() to work. just wondering. thanks. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:47 AM To: CF-Talk Subject: Re: is date within dst if you don't mind some java might look at: java.util.TimeZone and inDaylightTime() method is there a cfx or udf or some other snippet of code out therrre that anyone knows about that would determine if said date was within or out of a dst period? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Macromedia Folks - Upgrades to MX2004?
Dave, You need to contact your sales rep. The fact that you own a subscription to Studio means you are a part of the MVLP program, and that you have a dedicated sales rep. He or she will be able to give you specific pricing information. Christian On Wednesday, September 10, 2003, at 09:21 AM, Bosky, Dave wrote: We have the two year subscription for Studio MX. I assume this includes the upgrades to StudioMX2004 but is there an additional fee to upgrade to FlashMX2004 professional? Thanks, Dave ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: getting image info with CF
Is there any way to get the width and height information of an image file with Coldfusion? If you use CF 6.1 you can try this: http://www.cfmentor.com/code/index.cfm?action=zippedid=50 Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFHTTP with CFMX
CFDUMP var=#Quotes# Try cfdump var=#CFHTTP.FileContent# instead? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:40 AM To: CF-Talk Subject: CFHTTP with CFMX I'm simply trying to grab a stock page from yahoo but it never returns anything. If I paste the url into my browser I get back the expected results. Is there something I'm missing in my code? CFHTTP METHOD=GET URL=http://quote.yahoo.com/download/quotes.csv?Symbols=MACR+MSFTformat=sl1 d1t1c1ohgvext=.csv NAME=Quotes COLUMNS=Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Change,O pening_Price,Days_High,Days_Low,Volume DELIMITER=, TEXTQUALIFIER= CFDUMP var=#Quotes# Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: cflib.org and dependent functions
Tony, thanks for catching that. I'll see if I can get a fix for that some day. As it stands, I'm hoping to switch to a nice Flash browser instead. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:48 AM To: CF-Talk Subject: RE: cflib.org and dependent functions nevermind, from udf browser it doesn't tell you of the dependency, but I see from the cflib.org page, that it tells you :) thanks tony ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: cflib.org and dependent functions
In general, we tend to shy away from UDFs that rely on others. Every now and then we make exceptions though. Not that it's bad for UDF a to depend on UDF b, but for the site itself, we prefer things to be more self-contained. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: cflib.org and dependent functions Ive got a silly question. why would there be a udf on cflib, that requires another udf to function? kinda weird maybe? maybe not? getDayLightSavingTimeStart() requires GetNthOccOfDayInMonth() to work. just wondering. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
Fixed Thanks dave D: CD\ cd ABCD cd EFGH psexec \\ WLBS stop Should be in batch script and cfexecute name=D:\WWWRoot\JJCServices\StopLoadBalancing.bat/cfexecute should be withing CFExecute It works Thanks Shaz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 16:38 To: CF-Talk Subject: RE: Running Batch Script This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? I'm out of obvious ideas. I'd recommend that you try to break the problem down into smaller components. For example, can you run any other things through CFEXECUTE? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Gzipping cold fusion pages on IIS 5.0
Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: cflib.org and dependent functions
cool. np.
btw, using this code below
2007 gives wrong info. need to fix that I think.
people may use and think its right, when really its wrong...just another
fyi on a fgw!!!
later
-clip---
cfscript
/**
* Returns the day of the month(1-31) of an Nth Occurrence of a day
(1-sunday,2-monday etc.)in a given month.
*
* @param NthOccurrence A number representing the nth
occurrence.1-5.
* @param TheDayOfWeek A number representing the day of the week
(1=Sunday, 2=Monday, etc.).
* @param TheMonth A number representing the Month (1=January,
2=February, etc.).
* @param TheYearThe year.
* @return Returns a numeric value.
* @author Ken McCafferty ([EMAIL PROTECTED])
* @version 1, August 28, 2001
*/
function
GetNthOccOfDayInMonth(NthOccurrence,TheDayOfWeek,TheMonth,TheYear)
{
Var TheDayInMonth=0;
if(TheDayOfWeek lt DayOfWeek(CreateDate(TheYear,TheMonth,1))){
TheDayInMonth= 1 + NthOccurrence*7 + (TheDayOfWeek -
DayOfWeek(CreateDate(TheYear,TheMonth,1))) MOD 7;
}
else{
TheDayInMonth= 1 + (NthOccurrence-1)*7 + (TheDayOfWeek -
DayOfWeek(CreateDate(TheYear,TheMonth,1))) MOD 7;
}
//If the result is greater than days in month or less than 1, return
-1
if(TheDayInMonth gt DaysInMonth(CreateDate(TheYear,TheMonth,1)) OR
TheDayInMonth lt 1){
return -1;
}
else{
return TheDayInMonth;
}
}
/cfscript
cfscript
//DaylightSavingTimeStart:first sunday in April
function GetDaylightSavingTimeStart() {
Var TheYear=Year(2007);
if(ArrayLen(Arguments))
TheYear = Arguments[1];
return
CreateDate(TheYear,4,GetNthOccOfDayInMonth(1,1,4,TheYear));
}
/cfscript
CFOUTPUT
This year, Daylight Saving Time ends on
#DateFormat(GetDaylightSavingTimeStart(), ', mmm dd, ')#.
/CFOUTPUT
-end clip-
are you still reading this??? if so, get clipping, and try running the
code urself...i cannot be losing it...the voices told me I wasn't!
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 11:54 AM
To: CF-Talk
Subject: RE: cflib.org and dependent functions
Tony, thanks for catching that. I'll see if I can get a fix for that
some day. As it stands, I'm hoping to switch to a nice Flash browser
instead.
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 9:48 AM
To: CF-Talk
Subject: RE: cflib.org and dependent functions
nevermind, from udf browser it doesn't tell you of the
dependency, but I see from the cflib.org page, that it tells
you :) thanks
tony
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
RE: SQL Query Help (I'm stuck again)
Ok, hopefully this is my last question regarding this After doing some testing, the query seems to pull the data I am looking for. The next thing I want to do is, make this query change the status of its results from ACTIVE to CLOSED. Using the statement below, it is closing all of the records that are ACTIVE and have an expired end date. It does not seem to even care about the bid amounts. UPDATE auction_items SET Status = 'CLOSED' WHERE EXISTS( SELECT ai.Product_ID, ai.Status, ai.Reserve_Price FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status, ai.Reserve_Price HAVING ai.Reserve_Price MAX(ab.Bid_Amount) ); This statment does seem to pull the correct data. Original Message: From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Help (I'm stuck again) Date: Wed, 10 Sep 2003 16:51:14 +0200 You need ai.Reserve_Price in the select (NOT the aggregate function) AND the HAVING clause. Because of the inner join, you will NOT get the records that did not receive a bid. -Oorspronkelijk bericht- Van: grovem [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 16:43 Aan: CF-Talk CC: Onderwerp: RE: SQL Query Help (I'm stuck again) If I ad the Max(ab.Bid_Amount) to the select statment and remove the HAVING line, I do not get any errors, but I also return all records that have had a bid. When I ad the HAVING line [below] I receve the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'MAX(ab.Bid_Amount)ai.Reserve_Price' as part of an aggregate function. cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status, MAX(ab.Bid_Amount) AS HighBid FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY ai.Product_ID, ai.Status HAVING ai.Reserve_Price MAX(ab.Bid_Amount) /cfquery basically this needs to pull all of the records that did not receive a bid meeting or exceeding the reserve price. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Running Batch Script
Hi Shahzad, I'm sorry that I didn't see your post sooner -- we use PSEXEC in this manner frequently. The only thing I would add that might be helpful to you is that you might be able to elliminate the batch script altogether: cfexecute name=psexec.exe arguments=\\#Server# WLBS stop timeout=30 /cfexecute This example presumes that psexec.exe and WLBS (WLBS.exe?) are in C:\WINNT\system32 or otherwise in the respective servers' PATH System variables. If not, you can simply clarify the full path to either or both: cfexecute name=D:\ABCD\EFGH\psexec.exe arguments=\\#Server# C:\Utilities\WLBS.exe stop timeout=30 /cfexecute Just a thought. I hope it is helpful. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Shahzad.Butt wrote: Fixed Thanks dave D: CD\ cd ABCD cd EFGH psexec \\ WLBS stop Should be in batch script and cfexecute name=D:\WWWRoot\JJCServices\StopLoadBalancing.bat/cfexecute should be withing CFExecute It works Thanks Shaz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 16:38 To: CF-Talk Subject: RE: Running Batch Script This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? I'm out of obvious ideas. I'd recommend that you try to break the problem down into smaller components. For example, can you run any other things through CFEXECUTE? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Paging Principals
Since most people are not going to browse through all 100 pages of records, pulling a 1000 records for everyone, has some obvious inefficiencies. I'd go for individual queries on each page, but take the 8 join query out of CF, and make it a view. The view will help lessen the impact of that query, and make your code less complex at the same time. -- jon mailto:[EMAIL PROTECTED] Wednesday, September 10, 2003, 9:17:43 AM, you wrote: GVB Hi, GVB I have an app that queries a table and displays a subset of the query GVB results in a paged format, showing only 10 results per page. Some queries GVB will return upwards of 1,000 rows. GVB This query joins quite a few tables - say 8 or so, however the query itself GVB only requires one table to obtain the basis of the dataset(the rest of the GVB tables in the join are used for display info or 'cosmetic' type GVB information). GVB Generally speaking, which of the following would be more efficient: GVB Option 1: GVB - Query database, joining 8 tables, get entire dataset (1000 rows) GVB - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) GVB Option 2: GVB - Query database only based on the results of one table (1000 rows) GVB - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) GVB - within output loop, perform second query joining the 8 tables, based on a GVB single primary key returned from the initial dataset. (returns single row) GVB In essence, the question revolves around whether it is more expensive to GVB pull an entire 1,000 record joined dataset in one shot, or to make the GVB initial query lean, and then do ten consecutive queries performing the join. GVB The former likely incurs more database load, while the latter would incur GVB more interaction with odbc. GVB Whew. Interested in your answers! GVB Thanks, GVB Geoffrey Brown GVB GVB Online Operations Manager GVB Deerfield.com GVB 989.732.8856 ext. 227 (Gaylord) GVB 231.935.4640 ext. 123 (Traverse City) GVB [EMAIL PROTECTED] GVB http://www.deerfield.com GVB Personal Service with a :-) GVB VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com GVB ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
DWMX 2004 Impressions
I have to be honest, I'm using the trial here and I just don't see a whole lot for coding developers. Not to mention the buggy panel/screen refreshing . My only motivation to buying this would be the hope of less crashes than the original MX version...and maybe the fact u get an updated homesite+...which I think I'm going to switch back to. Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Devnet Subscription Value
When I ran a small consultancy, I used to be in the partner program which let me get a copy of ColdFusion, JRun, etc for development/demo purposes for something like $800. The preimer version of the partner program also threw in the licenses for the studio tools for like $2500. I used the partner program for the office and it was a good deal. Of course none of those programs are quite the way they were with Allaire (not bad, just different). With the advent of DevNet, it's now $1500/developer seat. So for 1 developer, the DevNet is a much better deal than the Partner program (from a software perspective only) and much more expensive for 3+ partners. Of course I really, really like the downloads online. Considering the Microsoft equivalent of DevNet is $3300, MM DevNet seems a little pricey to me, especially since I'm far more server-side (CFMX, JRun) than client-side (Flash, Fireworks, Freehand) and I think it's a real ripoff that there's no academic pricing for university use (MSDN academic license is $800 vs the $3300 for retail) since I work with a number of university clients that buy these tools, but it certainly contributes to the bottom line at MM and MS has *completely* different reasons to flood the academic market with cheap MS software :) And all that said, $1500 for the tools, conveinience of online *and* CD delivery, the DRKs are not a bad deal. If you're a solo developer, I'd go DevNet -- but factor in that it's a *recurring* cost of $1299 for renewals vs whatever you'd spend on the individual upgrades during that year of subscription time. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 8:46 AM Subject: OT: Devnet Subscription Value Hi, Here I go off-topic again...50 lashings for me. Anyway, I want some input/advice on the Macromedia Devnet subscription. I am a self-employed consultant with a ligit copy of Studio MX. I use DWMX, CF, Fireworks and JRun daily. I dabble with Flash and really hope to expand on that. I am now faced with upgrading to MX 2004. I attended the webcast and am impressed with some of the new features. As you likely know, purchasing a DevNet subscription is more cost-effective that just upgrading studio. So my question is: Is DevNet really that great? It appears to have some cool canned code and tips. As I am paying from my own pocket, and with Canadian $ on top of that, I will be out just over $800 and would really appreciate any advice or comments from those of you already subscribed. Thanks in advance, James ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Gzipping cold fusion pages on IIS 5.0
I believe that gzip uses the standard zip archetecture, so you ought to be able to use a standard zip package like cfx_zip. Of course, I may be totally off base with this one. :-\ -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Scott Ashman [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 12:07 PM : To: CF-Talk : Subject: Gzipping cold fusion pages on IIS 5.0 : : : Anyone know of a good product / method that can incorporate the : gzipping of : files with cold fusion output? IIS 5.0 has compression ability : but it seems : to really only be useful with static pages. I've seen a couple of $1k+ : solutions, but would rather have a cheaper solution. : : Thanks. : : : --- : : Checked by AVG anti-virus system (http://www.grisoft.com). : Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MAC Linux laptops (was about blue dragon.)
Matt's answer was dead on, but probably not what you were looking for. X11 is the underlying system that drives the GUI of pretty much all *nix applications that use a windowing environment, including the various desktop environments (like KDE and GNOME). With X11 support on the Mac, combined with it's *nix underpinnings, you basically have the ability to run any major *nix product. Without X, you'd be limited to console apps (emacs, pine, lynx) and/or daemons (apache, tomcat, mysql). barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:24 PM To: CF-Talk Subject: RE: MAC Linux laptops (was about blue dragon.) Not to sound like a MAC virgin, but x11 apps? What is that? One of my Sony laptops is off to be repaired once again and I was thinking about getting either a MAC or a laptop with Linux on it. Maybe one of those MAC laptops with the huge wide screen. Dan === Previous Message Below === -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 7:38 PM To: CF-Talk Subject: RE: about blue dragon. They don't crash. Excepting to install some updates last night, I've had it on with DW and various other programs open for weeks. My win2k office workstation, on the other hand, requires me to restart dreamweaver at least once a day, and reboot once a week. Also, my production servers are all *nix, so I don't have to deal with any of the potential problems moving code from windows dev machines to *nix production. Finally, you can run all the X11 apps you know and love right on the desktop intermixed with your other OSX apps. And if you're still hooked to windows, you can run emulation software or a terminal services client and easily get your MS fix. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 4:22 PM To: CF-Talk Subject: RE: about blue dragon. PowerBooks are awesome development machines! Sean A Corfield -- http://www.corfield.org/blog/ What advantages do you think they have over WIN based. What about homesite and the other MX product line? Dan ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
jessionid is undefined?
I'm trying to the jsessionid as a client variable. I noticed that even though I see the jsessionid in the url... I get a Variable JSESSIONID is undefined. error when I set the client variable. Any ideas? (This only happens on certain computers) Thanks, Tim ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Gzipping cold fusion pages on IIS 5.0
How does free sound? You want the tag cf_gzippage and cfx_gzip. You will have to search for each term in the devex to find them both. I've used them for quite awhile. They work great. -Original Message- From: Scott Ashman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:07 AM To: CF-Talk Subject: Gzipping cold fusion pages on IIS 5.0 Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Gzipping cold fusion pages on IIS 5.0
This may be a stupid question, but what is gzipping good for? I'm not being rude, I just don't know. :) -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:22 PM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 How does free sound? You want the tag cf_gzippage and cfx_gzip. You will have to search for each term in the devex to find them both. I've used them for quite awhile. They work great. -Original Message- From: Scott Ashman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:07 AM To: CF-Talk Subject: Gzipping cold fusion pages on IIS 5.0 Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: jessionid is undefined?
jsessionid is passed around with the client, but you access it via 'session.sessionid' from within your CF code. CF hides the fact that it's using the underlying J2EE session mechanism from you. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:17 AM To: CF-Talk Subject: jessionid is undefined? I'm trying to the jsessionid as a client variable. I noticed that even though I see the jsessionid in the url... I get a Variable JSESSIONID is undefined. error when I set the client variable. Any ideas? (This only happens on certain computers) Thanks, Tim ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Gzipping cold fusion pages on IIS 5.0
Certain browsers (ie 5+) can automatically ungzip documents retreived from a server and display them as they would an HTML document or image. By gzipping documents before they served you can save substantial bandwidth. I run a rather text heavy site 1.8 m/sec that's chewing up a t1+. I'm pretty sure I can cut the bandwidth in half with a good gzip solution. - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:23 PM Subject: RE: Gzipping cold fusion pages on IIS 5.0 This may be a stupid question, but what is gzipping good for? I'm not being rude, I just don't know. :) -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:22 PM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 How does free sound? You want the tag cf_gzippage and cfx_gzip. You will have to search for each term in the devex to find them both. I've used them for quite awhile. They work great. -Original Message- From: Scott Ashman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:07 AM To: CF-Talk Subject: Gzipping cold fusion pages on IIS 5.0 Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Command Line From CF?
After searching the web and CF archives ad nauseum, here's my simple but unanswered question: Can I run a .cmd file using CF? I have a file that will run a sql DTS in a file called hrmd.cmd and I want a CF page to invoke it. Thanks, Keith Hawkes Database Administrator/Naval Hospital Roosevelt Roads ATTENTION!!! *** This email is privileged and/or confidential information that is intended solely for the person or person(s) to whom it is addressed. If you are receiving this email in error, please delete it immediately and contact the sender by return email. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Gzipping cold fusion pages on IIS 5.0
Cool, thanks. -Original Message- From: Scott Ashman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:42 PM To: CF-Talk Subject: Re: Gzipping cold fusion pages on IIS 5.0 Certain browsers (ie 5+) can automatically ungzip documents retreived from a server and display them as they would an HTML document or image. By gzipping documents before they served you can save substantial bandwidth. I run a rather text heavy site 1.8 m/sec that's chewing up a t1+. I'm pretty sure I can cut the bandwidth in half with a good gzip solution. - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:23 PM Subject: RE: Gzipping cold fusion pages on IIS 5.0 This may be a stupid question, but what is gzipping good for? I'm not being rude, I just don't know. :) -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:22 PM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 How does free sound? You want the tag cf_gzippage and cfx_gzip. You will have to search for each term in the devex to find them both. I've used them for quite awhile. They work great. -Original Message- From: Scott Ashman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:07 AM To: CF-Talk Subject: Gzipping cold fusion pages on IIS 5.0 Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Command Line From CF?
After searching the web and CF archives ad nauseum, here's my simple but unanswered question: Can I run a .cmd file using CF? Yes, you can, using the CFEXECUTE tag, although it may seem to be more difficult than it should. I have a file that will run a sql DTS in a file called hrmd.cmd and I want a CF page to invoke it. If your DTS package is on your database server, you might consider executing it through a stored procedure such as xp_cmdshell. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Gzipping cold fusion pages on IIS 5.0
Bryan wrote: what is gzipping good for? Bandwidth savings. On your server, before X kilobytes of html is shot down the pipe to the client, it is gzip-compressed. Browsers received this 'zipped' file and natively know how to decompress it. 100k of html becomes as little as 15-20k during transmission, then is unzipped on the client transparently to its full size. If you have lots of html the differences can be significant. I have a gigantic 'store map' page that displays for a client. Over 100k of html. It displays in an instant even over a dialup connection. The cost is to your CPU and to memory usage. However I have been very, very pleased with my results over maybe 2 years of use. I have it running on maybe 2 dozen sites on one server. My cms supports it out of the box. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Running Batch Script
I used to run VB programs which ran batch files. I used NT scheduler but it wasnt too reliable. This was 2 years ago so I did run a cf execute custom tag. Not the one you are using. Their are alternatives. If you want to schedule it CF's scheduler wasnt very helpful either. L Marcus Original message Date: Wed, 10 Sep 2003 15:26:04 +0100 From: Shahzad.Butt [EMAIL PROTECTED] Subject: Running Batch Script To: CF-Talk [EMAIL PROTECTED] I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat/cfexe cute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin Any suggetions.. Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm? user=1720.1640.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Running Batch Script
WHat I wonder is that the name fo the program is not in the name? am I missing something here? L Marcus Original message Date: Wed, 10 Sep 2003 15:26:04 +0100 From: Shahzad.Butt [EMAIL PROTECTED] Subject: Running Batch Script To: CF-Talk [EMAIL PROTECTED] I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat/cfexe cute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin Any suggetions.. Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm? user=1720.1640.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Paging Principals
You need to be careful with this scenario because it may not be more efficient, it depends upon your database schema. I tried this on an application we were doing and our situation was that it was possible to bring back 200 - 300k records (not likely, but possible). Our database was created in such a way that even though we tried bringing back the top n records, the query still had to touch every record in all the joined tables. The result was minimal to no performance increase. The moral of the story would be, it largely depends on your indexing and schema whether a particular technique will work or not. A view, as Jon mentioned, would be a very good idea since you wouldn't have all the joins involved. The only thing you need to worry about with a view is the inserting and updating on the underlying tables and what the performance hit will be on back-end processing updating the view, especially if you're relying on CF to do the inserting and updating. Mark -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 12:57 PM To: CF-Talk Subject: Re: Paging Principals Since most people are not going to browse through all 100 pages of records, pulling a 1000 records for everyone, has some obvious inefficiencies. I'd go for individual queries on each page, but take the 8 join query out of CF, and make it a view. The view will help lessen the impact of that query, and make your code less complex at the same time. -- jon mailto:[EMAIL PROTECTED] Wednesday, September 10, 2003, 9:17:43 AM, you wrote: GVB Hi, GVB I have an app that queries a table and displays a subset of the query GVB results in a paged format, showing only 10 results per page. Some queries GVB will return upwards of 1,000 rows. GVB This query joins quite a few tables - say 8 or so, however the query itself GVB only requires one table to obtain the basis of the dataset(the rest of the GVB tables in the join are used for display info or 'cosmetic' type GVB information). GVB Generally speaking, which of the following would be more efficient: GVB Option 1: GVB - Query database, joining 8 tables, get entire dataset (1000 rows) GVB - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) GVB Option 2: GVB - Query database only based on the results of one table (1000 rows) GVB - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) GVB - within output loop, perform second query joining the 8 tables, based on a GVB single primary key returned from the initial dataset. (returns single row) GVB In essence, the question revolves around whether it is more expensive to GVB pull an entire 1,000 record joined dataset in one shot, or to make the GVB initial query lean, and then do ten consecutive queries performing the join. GVB The former likely incurs more database load, while the latter would incur GVB more interaction with odbc. GVB Whew. Interested in your answers! GVB Thanks, GVB Geoffrey Brown GVB GVB Online Operations Manager GVB Deerfield.com GVB 989.732.8856 ext. 227 (Gaylord) GVB 231.935.4640 ext. 123 (Traverse City) GVB [EMAIL PROTECTED] GVB http://www.deerfield.com GVB Personal Service with a :-) GVB VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com GVB ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: What's the matter here? RSS feed error
Thanks for your suggestion, Dave. I ran the following: cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfdump var=#cfhttp.filecontent# And the file doesn't end properly. The last few characters of the CFDUMP look like this: [quote] name=Newsamp;file=articleamp;sid=59/link descriptionToday is the 11th birthday for Cybergrass [/quote] The dump is nowhere near long enough. Yet, when I put the same code in a bare-bones .cfm page, with no formatting, tables, other content, just the minimum required for a properly formatted html page, I get a properly formatted struct with the xml content properly arrayed there. What can be truncating the feed? ... Are you running CFMX 6.0? I've encountered things like this several times, that may or may not have been fixed by Updaters 1-3. They have supposedly been fixed in CFMX 6.1. Honestly, it's been so long since I've trusted the CFHTTP tag with anything important that I don't have a more specific answer than that. There are lots of HTTP client alternatives, and I've generally used one of those instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Gzipping cold fusion pages on IIS 5.0
How about shtml files? Will it compress those the same as it would HTML files? Even if the shtml files use ssi includes? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:48 PM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 Bryan wrote: what is gzipping good for? Bandwidth savings. On your server, before X kilobytes of html is shot down the pipe to the client, it is gzip-compressed. Browsers received this 'zipped' file and natively know how to decompress it. 100k of html becomes as little as 15-20k during transmission, then is unzipped on the client transparently to its full size. If you have lots of html the differences can be significant. I have a gigantic 'store map' page that displays for a client. Over 100k of html. It displays in an instant even over a dialup connection. The cost is to your CPU and to memory usage. However I have been very, very pleased with my results over maybe 2 years of use. I have it running on maybe 2 dozen sites on one server. My cms supports it out of the box. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Command Line From CF?
Use cfexecute to run command.com /c hrmc.cmd. -- jon mailto:[EMAIL PROTECTED] Wednesday, September 10, 2003, 2:39:40 PM, you wrote: HKAC After searching the web and CF archives ad nauseum, here's my simple but HKAC unanswered question: Can I run a .cmd file using CF? I have a file that HKAC will run a sql DTS in a file called hrmd.cmd and I want a CF page to invoke HKAC it. HKAC Thanks, HKAC Keith Hawkes HKAC Database Administrator/Naval Hospital Roosevelt Roads HKAC ATTENTION!!! HKAC *** HKAC This email is privileged and/or confidential information that is intended HKAC solely for the person or person(s) to whom it is addressed. If you are HKAC receiving this email in error, please delete it immediately and contact the HKAC sender by return email. HKAC ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Gzipping cold fusion pages on IIS 5.0
Bryan: Whatever html is fed to the client browser is what gets compressed. .shtml files won't work with the CF-based solution unless you do some tinkering under the server's hood, but I'm sure something will. Scott: if you decide to you'll save a lot more than 50%. I just tested that 109k (html) sitemap and it gets gzipped to 12k (104979 to 12279). I set cf_GZipPage to 9 on that one; the max. You can easily test this by commenting out the gzip file delete line in the tag and then just viewing the file in a zip program. Cheers, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:53 AM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 How about shtml files? Will it compress those the same as it would HTML files? Even if the shtml files use ssi includes? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:48 PM To: CF-Talk Subject: RE: Gzipping cold fusion pages on IIS 5.0 Bryan wrote: what is gzipping good for? Bandwidth savings. On your server, before X kilobytes of html is shot down the pipe to the client, it is gzip-compressed. Browsers received this 'zipped' file and natively know how to decompress it. 100k of html becomes as little as 15-20k during transmission, then is unzipped on the client transparently to its full size. If you have lots of html the differences can be significant. I have a gigantic 'store map' page that displays for a client. Over 100k of html. It displays in an instant even over a dialup connection. The cost is to your CPU and to memory usage. However I have been very, very pleased with my results over maybe 2 years of use. I have it running on maybe 2 dozen sites on one server. My cms supports it out of the box. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Paging Principals
My understanding of a view is that it is recreated when you run your query. At least in Oracle it does the joins under the hood at the time you request your data. Thus, there should be no performance gains there. DRE -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:53 AM To: CF-Talk Subject: RE: Paging Principals You need to be careful with this scenario because it may not be more efficient, it depends upon your database schema. I tried this on an application we were doing and our situation was that it was possible to bring back 200 - 300k records (not likely, but possible). Our database was created in such a way that even though we tried bringing back the top n records, the query still had to touch every record in all the joined tables. The result was minimal to no performance increase. The moral of the story would be, it largely depends on your indexing and schema whether a particular technique will work or not. A view, as Jon mentioned, would be a very good idea since you wouldn't have all the joins involved. The only thing you need to worry about with a view is the inserting and updating on the underlying tables and what the performance hit will be on back-end processing updating the view, especially if you're relying on CF to do the inserting and updating. Mark -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 12:57 PM To: CF-Talk Subject: Re: Paging Principals Since most people are not going to browse through all 100 pages of records, pulling a 1000 records for everyone, has some obvious inefficiencies. I'd go for individual queries on each page, but take the 8 join query out of CF, and make it a view. The view will help lessen the impact of that query, and make your code less complex at the same time. -- jon mailto:[EMAIL PROTECTED] Wednesday, September 10, 2003, 9:17:43 AM, you wrote: GVB Hi, GVB I have an app that queries a table and displays a subset of the query GVB results in a paged format, showing only 10 results per page. Some queries GVB will return upwards of 1,000 rows. GVB This query joins quite a few tables - say 8 or so, however the query itself GVB only requires one table to obtain the basis of the dataset(the rest of the GVB tables in the join are used for display info or 'cosmetic' type GVB information). GVB Generally speaking, which of the following would be more efficient: GVB Option 1: GVB - Query database, joining 8 tables, get entire dataset (1000 rows) GVB - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) GVB Option 2: GVB - Query database only based on the results of one table (1000 rows) GVB - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) GVB - within output loop, perform second query joining the 8 tables, based on a GVB single primary key returned from the initial dataset. (returns single row) GVB In essence, the question revolves around whether it is more expensive to GVB pull an entire 1,000 record joined dataset in one shot, or to make the GVB initial query lean, and then do ten consecutive queries performing the join. GVB The former likely incurs more database load, while the latter would incur GVB more interaction with odbc. GVB Whew. Interested in your answers! GVB Thanks, GVB Geoffrey Brown GVB GVB Online Operations Manager GVB Deerfield.com GVB 989.732.8856 ext. 227 (Gaylord) GVB 231.935.4640 ext. 123 (Traverse City) GVB [EMAIL PROTECTED] GVB http://www.deerfield.com GVB Personal Service with a :-) GVB VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com GVB ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Change NT password
Does anyone have a means of allowing an NT4 (or Win2k AD) domain user to change his password from a ColdFusion (CF5 on IIS5) app? The following explains how to do it using ASP, but we don't want to run ASP on the server: http://support.microsoft.com/?id=331834 Thanks, Jim ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: What's the matter here? RSS feed error
AH!!! So it could be a CFMX6.0 bug! We're upgrading to 6.1 in the next couple of weeks, so I might just put that page in the under construction bin till then and see if the problem goes away all by itself. Thanks Dave. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 September 2003 3:59 AM To: CF-Talk Subject: RE: What's the matter here? RSS feed error Thanks for your suggestion, Dave. I ran the following: cfhttp url=http://cybergrass.com/newsrss10.php; method=get/cfhttp cfdump var=#cfhttp.filecontent# And the file doesn't end properly. The last few characters of the CFDUMP look like this: [quote] name=Newsamp;file=articleamp;sid=59/link descriptionToday is the 11th birthday for Cybergrass [/quote] The dump is nowhere near long enough. Yet, when I put the same code in a bare-bones .cfm page, with no formatting, tables, other content, just the minimum required for a properly formatted html page, I get a properly formatted struct with the xml content properly arrayed there. What can be truncating the feed? ... Are you running CFMX 6.0? I've encountered things like this several times, that may or may not have been fixed by Updaters 1-3. They have supposedly been fixed in CFMX 6.1. Honestly, it's been so long since I've trusted the CFHTTP tag with anything important that I don't have a more specific answer than that. There are lots of HTTP client alternatives, and I've generally used one of those instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
js question
Hi, I You can dynamically create tr and td elements on the fly, like, var newRow=cell_root_table.insertRow(0) then add attributes like, newRow.vAlign='top' then to add a cell, var newCell=newRow.insertCell(0) but I can't seem to add event handlers on the fly, like newCell.onMouseMove='doThis()', Is there a way to do this? J ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Devnet Subscription Value
John Paul wrote: If you're a solo developer, I'd go DevNet -- but factor in that it's a *recurring* cost of $1299 for renewals vs whatever you'd spend on the individual upgrades during that year of subscription time. *** So to be clear, this time it will be $599 US for my *one-time* upgrade, but next year (and any subsequent years) it's the full pop, correct? James ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Here is a weird one: Timed out trying to establish connection
Timed out trying to establish connection is occurring _only_ on MS Access databases. These are internal sites, so I know that only 1 person is trying to access them, so it can't be a crash, could it? Any ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
OT: recommendation of web site(s) for selling/auctioning apps/scripts etc.
Hi, Sorry this is an OT but I guess some of you could probably provide some lead/pointer to the question in the subject line. Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: js question
try this
newCell.onMouseMove= new function('doThis()')
HTH
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 11:10 AM
To: CF-Talk
Subject: js question
Hi,
I You can dynamically create tr and td elements on the fly,
like,
var newRow=cell_root_table.insertRow(0)
then add attributes like,
newRow.vAlign='top'
then to add a cell,
var newCell=newRow.insertCell(0)
but I can't seem to add event handlers on the fly,
like newCell.onMouseMove='doThis()',
Is there a way to do this?
J
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
RE: js question
to add new functions on the fly use this format
obj.event = function() {foo(goo)};
for example:
v.onblur=function() {checkBool(this)};
and in your case
newCell.onMouseMove=function() {doThis()};
should work.
Note that 'function()' above is not a specific function, this is the command syntax.
HTH
Doug
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 2:10 PM
To: CF-Talk
Subject: js question
Hi,
I You can dynamically create tr and td elements on the fly,
like,
var newRow=cell_root_table.insertRow(0)
then add attributes like,
newRow.vAlign='top'
then to add a cell,
var newCell=newRow.insertCell(0)
but I can't seem to add event handlers on the fly,
like newCell.onMouseMove='doThis()',
Is there a way to do this?
J
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
