Re: Apache config
Re: IIS multiple domain tools, I am unsure how they are ugly workarounds? I mean, what is ugly about a one click change and a change to your host file (the latter being done by IIS and Apache users anyway). The fact is, you can run both IIS and Apache on XP locally in the same multi domain way, Not sure what you mean by a single dev server? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Tue Jan 23 01:40:38 2007 Subject: RE: Apache config In any case, I think you're missing my point entirely, or are simply unwilling to acknowledge it. I'll go ahead and restate it here, and then I'm done. For the purposes of most CF developers, who aren't server administrators, there is no substantive difference between IIS and Apache - neither beats the pants off the other - and time spent learning one after you know enough about the other to write and test applications is time that could be spent on something else. The fact that this isn't self-evident to you, that we're even having this discussion, boggles my mind. I think the reason this thread was started in the first place, is because IIS is basically unusable on XP, as you can't have multiple domains set up that don't all point to the same site. (Ok, there are some tools out there, but seriously, they're ugly workarounds). This is the reason I started using Apache in the first place. I currently have about 6 domains on my work workstation, and I can't imagine running IIS on there. I also can't imagine working off a single dev server, as that was the environment we tried very hard to get away from. I also don't intend to run win2k3 server on every workstation, so the only option is to use apache instead of IIS. Once I figured out how powerful apache_rewrite is, I never looked back. IIS might be a good solution for large enterprises and intranets, but I can't see why CF developers would use it, or why it would be used in hosted environments. I consider IIS not supporting multiple sites on XP, while apache behaving exactly the same as it would on win2k3 - a substantial difference. And if you're going to use Apache on your development boxes, you might as well use the same on production. Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache config
As Dave noted, as a matter of course you should have at least a Dev and Testing environment. Ideally an R D, Dev, Test, UAT, and Pre-Production before you even think of moving to a Production environment. You should *never* have a system (painly RD and dev) which is not in sync, configs and all with production. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Jan 22 21:08:25 2007 Subject: RE: Apache config You're probably right, and I should be more proactive in only applying patches that apply to my configuration. I should also probably be testing the patches on a development server first. However, I would rather spend the time doing real work than worrying about patches. Why can't Windows patches be more pain free like Linux patches? In my experience, they are, but I believe many of you have been burned by bad MS patches in the past, which is why you feel the need to test the patch before applying it. Testing the patches should be the MS's job, not ours. If it's my job to keep the server running, it's my job to make sure that patches work. I haven't seen any MS folks coming by my office to test for me, on my specific servers, with my specific mix of applications and settings. If you administer servers, this is REAL WORK, regardless of platform. If I told my friendly local Solaris administrator that he should just install patches on his production servers without testing them first, I'd get laughed out of his office. For what it's worth to you, I think your emphasis on patching and uptime are seriously misplaced. You should be more concerned about configuration management and unscheduled downtime. I am concerned with configuration management, and I love the fact that I can edit Apache's config file, test it, commit it to subversion and deploy to production. I have never had unscheduled downtime due to patches. Now, I might've been lucky, or maybe it's the fact that I don' run any more MS crap on my servers that I have to. This includes not running IIS in favor of apache. I don't know about Solaris, but on Linux, patches get installed nightly through up2date or yum on Redhat, and I've never had anything break because of it (nor do I know of anyone else who has). The process also NEVER needs a reboot. I'm not very clear of what you do to test patches anyway. Obviously, unless you have a huge budget, you can't have a duplicate of every server just so you can test patches on it. And if you test it on a development server with one configuration, there is no guarantee that it won't break on a production server with a slightly different configuration. If you're a developer, you'd much rather be writing code, which brings me back to my original point - if you're a developer, and you don't want to be a server administrator, learning Apache or Linux or whatever can be a distraction from your REAL WORK. That's really what caused me to react in the first place. I like Apache. I like Linux. I don't think there's anything wrong with using either one. I think in many ways, they're superior to their Microsoft counterparts. But the evangelism that accompanies them is often misguided, I think. It might be a distraction for some people, but I enjoy doing both coding and server management, and I am in a position where I have to be doing both. I would rather not spend time maintaining servers, but spend time adding more functionality. I hate the fact that in windows things tend to break every so often and sometimes require a lot of attention. On linux, although it might be a little more difficult to set things up, at first, once you've set it up, it will pretty much keep working unless you mess with it. You're right and rewriting using CF for dynamic content probably doesn't make much of a difference, although you should agree that it is slower, even by a few milliseconds. My point was about static content. Lets say you want to set up a sort of proxy server where: http://www.example.com actually pulls content from http://www2.example.com. In Apache, you would just put in something like: RewriteCond %{HTTP_HOST}^www.example.com
Coldfusion RSS Aggregator
Dear All, I've built a basic RSS aggregator, using Ray's RSS.cfc (basically, all I've done is write a function which loops URLs into RSS .cfc and saves the output as one big Query) But am now running into problems (mainly to do with Date types in RSS 1.0): Has anyone else done this? Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Surely other people have this problem? Displaying multiple RSS feeds as one mega feed? Ta T ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Better way to send nulls to a Stored Proc?
Just thinking out of the box here, and not sure if this is exactly what you're after but wouldn't you be better letting SQL decide what to insert. By using the NULLIF() SQL Function you can still pass your date as 01/01/00 if no date is specified and use the NULLIF() function to evaluate what to insert...either the date or NULL. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help Needed for fine-tuning CF code
Hi All, I am working on a web page which is built in ColdFusion. The problem is it's performance.The page takes lot of time for appearing on the screen.I have fine-tuned my code to follow the best practices of CF but somehow could not find any improvement in the performance.I have found-out that the query does not take much time but while rendering the data on the screen it takes most of the time.I am using the cfoutput tag to loop over the query data. Can someone please help me out with the possible solution. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Do I use a view for this?
I'll try to keep this short. I'm creating a digital version of a paper system in our consignment business. Using SQL Server. 1. We fill out a form showing the customer what we're sending them (startQTY), and productprice 2. They sell whatever, then send back the form filled in the with the endQTY, totalsold, totals, etc. I've gotten a good bit done but running into an issue now. I'm using CF to calculate some of this stuff and I know I probably should let the db handle it but it's just too easy. On the extended prices for each item in a row, I'm currently calculating as it displays out on the page, but I need this to be logged in the db. It'd be a little cumbersome using that same tblConsignOrderItems to hold this data because we don't know what the extended prices even ARE until they ship back what they didn't sell and we fill out the form. So should I create a view of some kind to count up the extended price for a particular item, after we've filled out the form? And if so, can someone gimme a simple example. I'm gonna do some googlin' and lookin thru my books. Just wanted to make sure I'm even on the right path here. You can see a screen cap of my display page. The db schema is just like a regularproduct db. You have a consignment order that drops a FK into the consignment order items table. Then everything is grouped into categories, since multiple products can be in a given category. http://wtomlinson.com/consigncap.jpg Thanks, Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help Needed for fine-tuning CF code
Can you post some code examples? Chris -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 6:26 AM To: CF-Talk Subject: Help Needed for fine-tuning CF code Hi All, I am working on a web page which is built in ColdFusion. The problem is it's performance.The page takes lot of time for appearing on the screen.I have fine-tuned my code to follow the best practices of CF but somehow could not find any improvement in the performance.I have found-out that the query does not take much time but while rendering the data on the screen it takes most of the time.I am using the cfoutput tag to loop over the query data. Can someone please help me out with the possible solution. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Is debugging enabled? On 1/23/07, hussain shaikh [EMAIL PROTECTED] wrote: Hi All, I am working on a web page which is built in ColdFusion. The problem is it's performance.The page takes lot of time for appearing on the screen.I have fine-tuned my code to follow the best practices of CF but somehow could not find any improvement in the performance.I have found-out that the query does not take much time but while rendering the data on the screen it takes most of the time.I am using the cfoutput tag to loop over the query data. Can someone please help me out with the possible solution. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Can you post some code examples? Chris Following is some of code of one of my web page:- cfoutput query=inventory2csvlist startrow=#start# maxrows=#start+step-1# tr bgcolor=#CfgRet.Color2# td align=left #inventory2csvlist.ROUTER# /td td #inventory2csvlist.IP# /td td #inventory2csvlist.VPN# /td td #inventory2csvlist.CEIP# /td td #inventory2csvlist.INTERFACE# /td td #inventory2csvlist.DESCRIPTION# /td td #inventory2csvlist.FUNCTION# /td td #inventory2csvlist.ENCAPSULATION# /td td a href=listInventory2csv_details_spring.cfm?router1=#inventory2csvlist.ROUTER#interface1=#inventory2csvlist.INTERFACE#start=#start#sort=#URL.sort#router_r=#router_r#vpn_v=#vpn_v#interface_i=#interface_i#View Details/a /td /tr /cfoutput Note:-start=1 and step=100 Also Debugging is disabled. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Needed for fine-tuning CF code
That doesn't look bad to me, is your server under heavy load, or is your disk source for this template having issues? -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 6:54 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code Can you post some code examples? Chris Following is some of code of one of my web page:- cfoutput query=inventory2csvlist startrow=#start# maxrows=#start+step-1# tr bgcolor=#CfgRet.Color2# td align=left #inventory2csvlist.ROUTER# /td td #inventory2csvlist.IP# /td td #inventory2csvlist.VPN# /td td #inventory2csvlist.CEIP# /td td #inventory2csvlist.INTERFACE# /td td #inventory2csvlist.DESCRIPTION# /td td #inventory2csvlist.FUNCTION# /td td #inventory2csvlist.ENCAPSULATION# /td td a href=listInventory2csv_details_spring.cfm?router1=#inventory2csvlist.RO UTER#interface1=#inventory2csvlist.INTERFACE#start=#start#sort=#URL.s ort#router_r=#router_r#vpn_v=#vpn_v#interface_i=#interface_i#View Details/a /td /tr /cfoutput Note:-start=1 and step=100 Also Debugging is disabled. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Do I use a view for this?
I'm confused. A view is nothing more than a saved query, really. A view isn't going to store unique data. (Well, you can use a view with triggers to update underlying tables, but I don't think that's what you're trying to do.) If it were me, I'd be storing the non-calculated data in the database. I'm not quite sure what extended price is - but if it's simply the total (amount sold X price), then you shouldn't need to store that. You should store the amount sold and the price in the DB. You can write a view then that simply calculates that for you, so you don't have to write the query over and over, but it's really nothing more than writing the query once and running it with: create or replace myview AS ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion RSS Aggregator
Hi, Tom, I recently built an RSS/ATOM aggregator as a portlet for a portal system we're releasing this month. I loop through each feed URL as well, but the output is stored in an array of structures (each feed has its own structure and the last component of each structure is an array of the news items in the feed). I display a list of the feeds to the user, and use JavaScript to show or hide the news items in the feed whenever the user clicks on the feed title. It handles RSS 1.0, RSS 2.0, and ATOM feeds. I don't really do anything with the dates that come with the feeds (other than display them) and I've never looked at Ray's code: what are you trying to do with the dates? --Brian ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Do I use a view for this?
Remember a view can contain data which is in the underlying tables in a different form (even new data not in them), It could contain computed fields, sums across many fields, new columns so in that way a view can contain unique data. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Deanna Schneider To: CF-Talk Sent: Tue Jan 23 13:05:37 2007 Subject: Re: Do I use a view for this? I'm confused. A view is nothing more than a saved query, really. A view isn't going to store unique data. (Well, you can use a view with triggers to update underlying tables, but I don't think that's what you're trying to do.) If it were me, I'd be storing the non-calculated data in the database. I'm not quite sure what extended price is - but if it's simply the total (amount sold X price), then you shouldn't need to store that. You should store the amount sold and the price in the DB. You can write a view then that simply calculates that for you, so you don't have to write the query over and over, but it's really nothing more than writing the query once and running it with: create or replace myview AS ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Hi Hussain, just for the info. If you check the size of the response HTML (properties in firefox). How large is it? Does the page render a lot of unnecessary empty code? Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: Hi All, I am working on a web page which is built in ColdFusion. The problem is it's performance.The page takes lot of time for appearing on the screen.I have fine-tuned my code to follow the best practices of CF but somehow could not find any improvement in the performance.I have found-out that the query does not take much time but while rendering the data on the screen it takes most of the time.I am using the cfoutput tag to loop over the query data. Can someone please help me out with the possible solution. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
How do I find whether my server is under heavy load or not? Actually the query used is returning around 8 records. So it has loop over this recordset to display only 100 records on the page. Is this the reason why it is taking time?? That doesn't look bad to me, is your server under heavy load, or is your disk source for this template having issues? -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 6:54 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code Can you post some code examples? Chris Following is some of code of one of my web page:- cfoutput query=inventory2csvlist startrow=#start# maxrows=#start+step-1# tr bgcolor=#CfgRet.Color2# td align=left #inventory2csvlist.ROUTER# /td td #inventory2csvlist.IP# /td td #inventory2csvlist.VPN# /td td #inventory2csvlist.CEIP# /td td #inventory2csvlist.INTERFACE# /td td #inventory2csvlist.DESCRIPTION# /td td #inventory2csvlist.FUNCTION# /td td #inventory2csvlist.ENCAPSULATION# /td td a href=listInventory2csv_details_spring.cfm?router1=#inventory2csvlist.RO UTER#interface1=#inventory2csvlist.INTERFACE#start=#start#sort=#URL.s ort#router_r=#router_r#vpn_v=#vpn_v#interface_i=#interface_i#View Details/a /td /tr /cfoutput Note:-start=1 and step=100 Also Debugging is disabled. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
It could just be that the page is taking a while to render. Table need to fully load before there displayed. You may have something else in the table that is causing it to take ages to display in your browser See how long cf takes to process the page, !--- Start of page --- CFSET start1=GetTickCount() !--- The rest of you code goes here --- !--- End of page --- CFSET end1=GetTickCount() Exec: strongcfoutput#end1-start1#/cfoutput/strong Then you can see if its a probelm with the processing or displaying of the page ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Do I use a view for this?
Yes, it can contain all that, but it's not storing it in the sense of a table. It does the computations on the fly. If that's what he needs, then yes a view will work. But, I'm not sure if that's what he's shooting for or not. On 1/23/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Remember a view can contain data which is in the underlying tables in a different form (even new data not in them), It could contain computed fields, sums across many fields, new columns so in that way a view can contain unique data. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Ya Franz, U r right. I just checked the source code rendered by the web page and there are lot of empty code. What could be the reason for that?? Hi Hussain, just for the info. If you check the size of the response HTML (properties in firefox). How large is it? Does the page render a lot of unnecessary empty code? Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Well it surely is something that you should not do. Since 8 records are somethin that has to be skipped through even when you only skip through 100 records. Try only to query 100 the records you need... You can easily check this by using GetTickCount() before and after the QueryOutput... Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: How do I find whether my server is under heavy load or not? Actually the query used is returning around 8 records. So it has loop over this recordset to display only 100 records on the page. Is this the reason why it is taking time?? That doesn't look bad to me, is your server under heavy load, or is your disk source for this template having issues? -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 6:54 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code Can you post some code examples? Chris Following is some of code of one of my web page:- cfoutput query=inventory2csvlist startrow=#start# maxrows=#start+step-1# tr bgcolor=#CfgRet.Color2# td align=left #inventory2csvlist.ROUTER# /td td #inventory2csvlist.IP# /td td #inventory2csvlist.VPN# /td td #inventory2csvlist.CEIP# /td td #inventory2csvlist.INTERFACE# /td td #inventory2csvlist.DESCRIPTION# /td td #inventory2csvlist.FUNCTION# /td td #inventory2csvlist.ENCAPSULATION# /td td a href=listInventory2csv_details_spring.cfm?router1=#inventory2csvlist.RO UTER#interface1=#inventory2csvlist.INTERFACE#start=#start#sort=#URL.s ort#router_r=#router_r#vpn_v=#vpn_v#interface_i=#interface_i#View Details/a /td /tr /cfoutput Note:-start=1 and step=100 Also Debugging is disabled. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Do I use a view for this?
Ok I'm getting a handle on things here. Using some T-SQL to do what I was having CF do. My only problem right now is I'm trying to calculate multiple products in a given category. This expression is producing an amount that's way too high for the category. SUM((tblConsignmentOrderItems.consignprodstartQTY - tblConsignmentOrderItems.consignprodendQTY) * tblConsignmentOrderItems.consignprodprice) AS catTotal This produces 1984.50, and it SHOULD be 283.50. Can't quite figure out how it's tallying up so much. Any ideas? Thanks for all the view info guys! Here's the whole SQL statement. Neil, don't say anything bout the non cfqueryparam'd statement. I'm just testing! lol! Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Hi Hussain, take a look at my recent blog entry: http://www.railo.ch/blog/index.cfm/2007/1/19/Performance-Tuning-Part-II You can place Comments between the tags. But I guess my previous mail is more important... Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: Ya Franz, U r right. I just checked the source code rendered by the web page and there are lot of empty code. What could be the reason for that?? Hi Hussain, just for the info. If you check the size of the response HTML (properties in firefox). How large is it? Does the page render a lot of unnecessary empty code? Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others)
The quote that I got about it was due to an unrelated SSL vulnerability they needed to upgrade to 1.5.0_09 /_10. The 1.4.2 family exception equivalent to that was noted to be 1.4.2_13 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 3:43 PM To: CF-Talk Subject: Re: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others) What is the problem? If there is a problem with _11 but has a fundamental flaw then it is up to Adobe to certify _13 pronto. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Mon Jan 22 20:32:48 2007 Subject: RE: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others) How about 1.4.2_13? We have been told a work that _11 has a security problem and isn't allowed. The latest version listed on the Adobe site is 11, but you can certainly try 13 and see if it works with your applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Hi Richard, I have tried that also(GetTickCount) and found that the time vries everytime I access the page.On an average it takes around 100 ms. It could just be that the page is taking a while to render. Table need to fully load before there displayed. You may have something else in the table that is causing it to take ages to display in your browser See how long cf takes to process the page, !--- Start of page --- CFSET start1=GetTickCount() !--- The rest of you code goes here --- !--- End of page --- CFSET end1=GetTickCount() Exec: strongcfoutput#end1-start1#/cfoutput/strong Then you can see if its a probelm with the processing or displaying of the page ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Hi Franz, I have to fetch the entire 8 records since I have implemented sorting on the columns of the table, so i have to query the table with the order by clause so that the entire records are sorted and then displayed. Well it surely is something that you should not do. Since 8 records are somethin that has to be skipped through even when you only skip through 100 records. Try only to query 100 the records you need... You can easily check this by using GetTickCount() before and after the QueryOutput... Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Yes of course, but are you sure your customers will browse through all of the 8 records? You can do something like this: Select Top 500 From ... WHERE ... ORDER BY ... Or LIMIT for MySQL But you should consider, that only in some cases a user will browse until page 800!!! There are other tricks on how you can obtain Rows between pages for eg: 351 and 352 But only if this is necessary since it's a little sophisticated... Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: Hi Franz, I have to fetch the entire 8 records since I have implemented sorting on the columns of the table, so i have to query the table with the order by clause so that the entire records are sorted and then displayed. Well it surely is something that you should not do. Since 8 records are somethin that has to be skipped through even when you only skip through 100 records. Try only to query 100 the records you need... You can easily check this by using GetTickCount() before and after the QueryOutput... Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
database JOIN question
I have a table (notes_to_the_record) of meeting notes (fields:n_r_id,id,meeting_name,date_added,follow_up). A new feature is that the meeting note is shared to a set of users. So since multiple users can be selected, I made a new table called notes_to_the_record_shared (n_r_shared_id,n_r_id,id). In both those, id references a People table, so it's the person's ID Here are the two tables: http://hhp.umd.edu/home/db_display.cfm (table of notes) http://hhp.umd.edu/home/db_display_shared.cfm (shared table) When I do the search, I make sure that the person can only see their own notes, so ID = #session.user.id#. Now with the notes ability to be shared, I'm not sure how to expand the search to be any notes with my id in this table and any notes with my id in this second table and join correctly to have all the information. I have it set up so that there is a record (n_r_id = 441) that is shared to a person with id 3 I was told in a DB forum Use outer join. table1.id = table2.id(+). So I'm doing that and it doesn't seem to be working. Here's the SQL: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n,notes_to_the_record_shared s WHERE n.ID = #session.user.id# AND n.id = s.id(+) ORDER BY UPPER(n.meeting_name) ASC Please help - I'm really at a stand-still here. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Ya Franz, I have tried using that sophisticated query also but in that case the query was taking lot of time.I donnow why but? I have implemented sorting,paging and search for a particular field (using text boxes) on that screen.And whenever you click to see the next set of records the same page is again reloaded with some checks performed. I don't know whether this way of implementation is correct or not? Yes of course, but are you sure your customers will browse through all of the 8 records? You can do something like this: Select Top 500 From ... WHERE ... ORDER BY ... Or LIMIT for MySQL But you should consider, that only in some cases a user will browse until page 800!!! There are other tricks on how you can obtain Rows between pages for eg: 351 and 352 But only if this is necessary since it's a little sophisticated... Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Do I use a view for this?
You forgot the rest of the query. :) On 1/23/07, Will Tomlinson [EMAIL PROTECTED] wrote: Here's the whole SQL statement. Neil, don't say anything bout the non cfqueryparam'd statement. I'm just testing! lol! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Do you have a link where I can look at it? Gert hussain shaikh schrieb: Ya Franz, I have tried using that sophisticated query also but in that case the query was taking lot of time.I donnow why but? I have implemented sorting,paging and search for a particular field (using text boxes) on that screen.And whenever you click to see the next set of records the same page is again reloaded with some checks performed. I don't know whether this way of implementation is correct or not? Yes of course, but are you sure your customers will browse through all of the 8 records? You can do something like this: Select Top 500 From ... WHERE ... ORDER BY ... Or LIMIT for MySQL But you should consider, that only in some cases a user will browse until page 800!!! There are other tricks on how you can obtain Rows between pages for eg: 351 and 352 But only if this is necessary since it's a little sophisticated... Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: database JOIN question
What database are you using? I've never see that + notation before... One thing I can suggest (without actually helping you) is to use ANSI-style joins, which are done in the FROM clause, and not in the WHERE clause. I find these to be much more expressive and sometimes they are the only way to do something tricky, and you're getting close to that now. The idea is that instead of using FROM a, b WHERE a.id = b.id you instead do FROM a JOIN b ON (a.id = b.id), and you leave the WHERE clause to be only for non-joining constraints. It can really clear up ambiguity (for the person reading the code, including the person who wrote it), and it does away with special notations for OUTER joins, which is what I suspect that + is for. (Outer joins look like FROM a LEFT OUTER JOIN b ON (a.id = b.id), etc.) As to your specific problem, how are the notes_to_the_record and notes_to_the_record_shared tables related to each other and to the user? I can't tell if your id field is the user id or the note id. Mark -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:00 AM To: CF-Talk Subject: database JOIN question I have a table (notes_to_the_record) of meeting notes (fields:n_r_id,id,meeting_name,date_added,follow_up). A new feature is that the meeting note is shared to a set of users. So since multiple users can be selected, I made a new table called notes_to_the_record_shared (n_r_shared_id,n_r_id,id). In both those, id references a People table, so it's the person's ID Here are the two tables: http://hhp.umd.edu/home/db_display.cfm (table of notes) http://hhp.umd.edu/home/db_display_shared.cfm (shared table) When I do the search, I make sure that the person can only see their own notes, so ID = #session.user.id#. Now with the notes ability to be shared, I'm not sure how to expand the search to be any notes with my id in this table and any notes with my id in this second table and join correctly to have all the information. I have it set up so that there is a record (n_r_id = 441) that is shared to a person with id 3 I was told in a DB forum Use outer join. table1.id = table2.id(+). So I'm doing that and it doesn't seem to be working. Here's the SQL: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n,notes_to_the_record_shared s WHERE n.ID = #session.user.id# AND n.id = s.id(+) ORDER BY UPPER(n.meeting_name) ASC Please help - I'm really at a stand-still here. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Do I use a view for this?
Lol ;-p -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 23 January 2007 12:26 To: CF-Talk Subject: Re: Do I use a view for this? Ok I'm getting a handle on things here. Using some T-SQL to do what I was having CF do. My only problem right now is I'm trying to calculate multiple products in a given category. This expression is producing an amount that's way too high for the category. SUM((tblConsignmentOrderItems.consignprodstartQTY - tblConsignmentOrderItems.consignprodendQTY) * tblConsignmentOrderItems.consignprodprice) AS catTotal This produces 1984.50, and it SHOULD be 283.50. Can't quite figure out how it's tallying up so much. Any ideas? Thanks for all the view info guys! Here's the whole SQL statement. Neil, don't say anything bout the non cfqueryparam'd statement. I'm just testing! lol! Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: database JOIN question
Daniel, Not sure, cause I can't test it, but maybe something like this: SELECT n.meeting_name, n.type, n.note_date, n.notes, n.type_describe FROM notes_to_the_record n LEFT OUTER JOIN notes_to_the_record_shared s ON ( n.n_r_id = s.n_r_id AND s.id = #session.user.id# ) WHERE n.ID = #session.user.id# OR s.id = #session.user.id# ORDER BY UPPER(n.meeting_name) ASC This will create a left outer join on the notes table on the notes id. Then, you are selecting all notes where the user id of the note is the session id OR the user id of the share is the session id. The ON statement of the join should exclude and shares that don't involve the session user. However, the left outer nature of the join should at least keep the notes portion of the join (and NULL the share values). I could be way of though :) .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:00 AM To: CF-Talk Subject: database JOIN question I have a table (notes_to_the_record) of meeting notes (fields:n_r_id,id,meeting_name,date_added,follow_up). A new feature is that the meeting note is shared to a set of users. So since multiple users can be selected, I made a new table called notes_to_the_record_shared (n_r_shared_id,n_r_id,id). In both those, id references a People table, so it's the person's ID Here are the two tables: http://hhp.umd.edu/home/db_display.cfm (table of notes) http://hhp.umd.edu/home/db_display_shared.cfm (shared table) When I do the search, I make sure that the person can only see their own notes, so ID = #session.user.id#. Now with the notes ability to be shared, I'm not sure how to expand the search to be any notes with my id in this table and any notes with my id in this second table and join correctly to have all the information. I have it set up so that there is a record (n_r_id = 441) that is shared to a person with id 3 I was told in a DB forum Use outer join. table1.id = table2.id(+). So I'm doing that and it doesn't seem to be working. Here's the SQL: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n,notes_to_the_record_shared s WHERE n.ID = #session.user.id# AND n.id = s.id(+) ORDER BY UPPER(n.meeting_name) ASC Please help - I'm really at a stand-still here. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: database JOIN question
I think what you really want is something like this: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n LEFT JOIN notes_to_the_record_shared s on n.n_r_id = s.n_r_id WHERE n.ID = #session.user.id# OR s.id = #session.user.id# ORDER BY UPPER(n.meeting_name) ASC On 1/23/07, Daniel Kessler [EMAIL PROTECTED] wrote: I have a table (notes_to_the_record) of meeting notes (fields:n_r_id,id,meeting_name,date_added,follow_up). A new feature is that the meeting note is shared to a set of users. So since multiple users can be selected, I made a new table called notes_to_the_record_shared (n_r_shared_id,n_r_id,id). In both those, id references a People table, so it's the person's ID ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Thanks Franz for the keen interest that you have shown to resolve the issue,but it's not possible for me to give you the link.But I can give you the entire .cfm page which is about 14338 bytes. :-) Do you have a link where I can look at it? Gert hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Quick change, this will make sure you don't end up with a completely empty table if the last result is divisble by 50 cfif currentrow mod 50 EQ 0 and currentrow neq recordcount /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
That's ok by me... just send it by mail offline... Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: Thanks Franz for the keen interest that you have shown to resolve the issue,but it's not possible for me to give you the link.But I can give you the entire .cfm page which is about 14338 bytes. :-) Do you have a link where I can look at it? Gert hussain shaikh schrieb: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
As far as I can tell looking at the various suggestion, the most probable bottle neck is in your SQL code and not the CFM. Some stupid questions? 1. DO you have indexes on the table? 2. Which DB are you using? Different DB vendor will let you select only a subset of data i.e. SQL Server (Top 50) or mySQL (Limit 50) etc. Thanks Qasim On 1/23/07, hussain shaikh [EMAIL PROTECTED] wrote: I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Tables are meant for display data as complete sheet. I think this is so the data isn't misinterpretted. You could use CSS instead of tables but creating grids is quite tricky like this. I reckon the problem may lie with the layout of the rest of the page. Have you tried the page without this info. Does it take a noticable amount of time to display? Also, try that section of code in its own page see how quickly it displays. Do you have a link to the page? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Needed for fine-tuning CF code
Hussain, Internet Explorer will not display the table until the entire thing is downloaded, while Firefox or Opera will render the table as it gets each row. It wont matter to IE if you flush it, it waits for the closing /table tag to display =( Also, you have to remember that each time you query that 8000 records, its loading into memory on the Coldfusion server, and it needs to transfer those records from your SQL / Database server over to Coldfusion. I think you would be best served to find a way to limit any query you do to only the records you are going to display on that page immediately. So, provide next and prior page links, or even a page listing, but don't pull them all at once. There are many cf tags out there that will do pagination. If you absolutely must query 8000 records at once, you may consider caching that into a shared scope (probably application scope) so that it only has to come from your database once. Chris Peterson -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:18 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion RSS Aggregator
Just display them, but for some reason I'm getting an invalid data type from a valid 1.0 XML doc.. I think it's just a matter of going through Ray's code and see if I can put some extra validation in.. T On 23 Jan 2007, at 12:00, Brian Swartzfager wrote: Hi, Tom, I recently built an RSS/ATOM aggregator as a portlet for a portal system we're releasing this month. I loop through each feed URL as well, but the output is stored in an array of structures (each feed has its own structure and the last component of each structure is an array of the news items in the feed). I display a list of the feeds to the user, and use JavaScript to show or hide the news items in the feed whenever the user clicks on the feed title. It handles RSS 1.0, RSS 2.0, and ATOM feeds. I don't really do anything with the dates that come with the feeds (other than display them) and I've never looked at Ray's code: what are you trying to do with the dates? --Brian ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
Thanks Richard, but I can't provide you the link since it's not meant to be disclosed.Sorry abt that :-( I'll try all the suggestions and will then see where the actual problem is. Thanks once again. Hussain. Tables are meant for display data as complete sheet. I think this is so the data isn't misinterpretted. You could use CSS instead of tables but creating grids is quite tricky like this. I reckon the problem may lie with the layout of the rest of the page. Have you tried the page without this info. Does it take a noticable amount of time to display? Also, try that section of code in its own page see how quickly it displays. Do you have a link to the page? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Needed for fine-tuning CF code
Thanks Chris, You mentioned abt some tags for Pagination.What r those? Where on net I can get pagination stuff? Hussain, Internet Explorer will not display the table until the entire thing is downloaded, while Firefox or Opera will render the table as it gets each row. It wont matter to IE if you flush it, it waits for the closing /table tag to display =( Also, you have to remember that each time you query that 8000 records, its loading into memory on the Coldfusion server, and it needs to transfer those records from your SQL / Database server over to Coldfusion. I think you would be best served to find a way to limit any query you do to only the records you are going to display on that page immediately. So, provide next and prior page links, or even a page listing, but don't pull them all at once. There are many cf tags out there that will do pagination. If you absolutely must query 8000 records at once, you may consider caching that into a shared scope (probably application scope) so that it only has to come from your database once. Chris Peterson -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:18 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database JOIN question
Yes - that worked fine and is largely the same as Ben's - except that his states OUTER. Is the OUTER assumed when it's not stated? Just so that I understand - the relationship is made on the ON, which designates a subset. Then that is queried with the WHERE. and thank you very much. It helps me alot. I think what you really want is something like this: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n LEFT JOIN notes_to_the_record_shared s on n.n_r_id = s.n_r_id WHERE n.ID = #session.user.id# OR s.id = #session.user.id# ORDER BY UPPER(n.meeting_name) ASC ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Site Monitoring
Is anyone familiar with a piece of software called Radar Site Monitor? http://www.apicalsoft.com/ We're investigating some site monitoring tools.. and my boss came up with that one.. I've put forth www.siteuptime.com too. Rick -- I'm not certified, but I have been told that I'm certifiable... Visit http://www.opensourcecf.com today! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help Needed for fine-tuning CF code
Here are a few blog posts found on google showing how to handle pagination well http://www.bennadel.com/blog/281-Oh-Baby-It-s-So-Hot-When-You-Paginate-a ka-Paginating-Results-In-ColdFusion-.htm http://ray.camdenfamily.com/index.cfm/2006/4/24/ColdFusion-and-Paginatio n Like many are saying though, pagination in the database request will be much faster when properly implemented. =) Chris -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:47 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code Thanks Chris, You mentioned abt some tags for Pagination.What r those? Where on net I can get pagination stuff? Hussain, Internet Explorer will not display the table until the entire thing is downloaded, while Firefox or Opera will render the table as it gets each row. It wont matter to IE if you flush it, it waits for the closing /table tag to display =( Also, you have to remember that each time you query that 8000 records, its loading into memory on the Coldfusion server, and it needs to transfer those records from your SQL / Database server over to Coldfusion. I think you would be best served to find a way to limit any query you do to only the records you are going to display on that page immediately. So, provide next and prior page links, or even a page listing, but don't pull them all at once. There are many cf tags out there that will do pagination. If you absolutely must query 8000 records at once, you may consider caching that into a shared scope (probably application scope) so that it only has to come from your database once. Chris Peterson -Original Message- From: hussain shaikh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:18 AM To: CF-Talk Subject: Re: Help Needed for fine-tuning CF code I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion RSS Aggregator
On 1/23/07, Tom King [EMAIL PROTECTED] wrote: Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Hi Tom, We have a commercial feed parser for sale here: http://foundeo.com/feed-parser/ it seams to do a pretty good job (I have used it on numberous sites), and has built in caching. You can download a free trial to test it out... -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://spendfish.com/ - Fish for Deals ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database JOIN question
What database are you using? I've never see that + notation before... Sorry - I reminded myself twice while writing the email to state the DB and dang it. It's Oracle and yes the + stands for Outer Join - which I just learned yesterday. I read and re-read your point twice and I believe that I have it. I do Joins so infrequently that I hope I remember it cause it looks like good advice. The idea is that instead of using FROM a, b WHERE a.id = b.id you instead do FROM a JOIN b ON (a.id = b.id), and you leave the WHERE clause to be only for non-joining constraints. It can really clear up ambiguity (for the person reading the code, including the person who wrote it), and it does away with special notations for OUTER joins, which is what I suspect that + is for. (Outer joins look like FROM a LEFT OUTER JOIN b ON (a.id = b.id), etc.) As to your specific problem, how are the notes_to_the_record and notes_to_the_record_shared tables related to each other and to the user? I can't tell if your id field is the user id or the note id. I seem to have the problem solved. But the id is the id of the person. The note has it's own ID which is n_r_id and the shared items have their own id which is n_r_shared_id. Each of them contain the id field and they're related through that and the notes themselves are related to my central People table. I really appreciate the help everyone. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFEclipse / Eclipse question
What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: database JOIN question
If you're using left join, yes, outer is assumed. You can put it in there - it's more explicit. Also, the other guy was right that you can also put the where n.id = #session.user.id# in the ON clause, which will filter your records at the level of the join. You should get the same results, and they might be slightly faster by doing it that way. You'd have to do an explain plan and compare to see if it makes any noticable difference in your case. You're using Oracle man - you should be doing joins all the time. Joins are your friend. :) On 1/23/07, daniel kessler [EMAIL PROTECTED] wrote: Yes - that worked fine and is largely the same as Ben's - except that his states OUTER. Is the OUTER assumed when it's not stated? Just so that I understand - the relationship is made on the ON, which designates a subset. Then that is queried with the WHERE. and thank you very much. It helps me alot. I think what you really want is something like this: SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe FROM notes_to_the_record n LEFT JOIN notes_to_the_record_shared s on n.n_r_id = s.n_r_id WHERE n.ID = #session.user.id# OR s.id = #session.user.id# ORDER BY UPPER(n.meeting_name) ASC ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse / Eclipse question
I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database JOIN question
I was working from this information: http://www.1keydata.com/sql/sqlouterjoin.html What database are you using? I've never see that + notation before... One thing I can suggest (without actually helping you) is to use ANSI-style joins, which are done in the FROM clause, and not in the WHERE clause. I find these to be much more expressive and sometimes they are the only way to do something tricky, and you're getting close to that now. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse / Eclipse question
The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:CSS need help
I know this is off topic, but I'm sure someone here can answer my question. The following works in FF but not in IE: The.css (included) style type=text/css div.AdminWrapper{ width: 850px; border: 1px solid #AA; background-color: #F9F9F9; text-align: left; margin: auto; overflow: auto; } div.SiteHeader{ border: 1px solid #AA; background-color: #CDD9E5; padding-left: 5px; padding-right: 5px; } p.SiteHeaderText{ font-size: 20px; font-weight: bold; color: #466686; /*#698DB0 (light), #5880A7 (darker), #4F7396 (darker still), #466686 (darkest yet)*/ } div.Spacer { height: 5px; } div.SideBar{ display: block; float: right; width: 210px; border: 1px dashed; } div.SideBarItem{ margin: 3px; padding: 3px; border: 1px solid #AA; background-color: #F1F1F1; } div.SideBar .Title{ background-color:#466686;/*#BAB9BC*/ margin: 0px; padding: 5px 3px; } div.SideBar .Title .Text{ font-weight: bold; font-size: 1.0em; color: #E9E9E9; cursor: default; } /style The Markup !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd; html head titleSome Title/title style type=text/css@import url(CSS/The.css);/style script type=text/javascript src=Include/js/jquery.js/script script type=text/javascript src=Include/js/jquery-odbcdates.js/script /head body div class=AdminWrapper div class=SiteHeader p class=SiteHeaderTextMy Web Site/p /div div class=SideBar div class=SideBarItem div class=Title span class=TextMy Title/span /div span style=font-family: verdana; font-size: 11px; line-height:1.5; a href=#Item 1/abr a href=#Item 2/abr a href=#Item 3/abr a href=#Item 4/abr /span /div /div div class=Spacer/div div class=ApplicationStuff Goes Here/div /div /body /html This code is supposed to produce a column on the right-hand side of the page (as seen in many blog pages) where I can have different sections. I'm calling this a SideBar and each section is a SideBarItem. The section is supposed to be 210px wide. In FF this is working, in IE it's not. I've stripped out unnecessary script and ColdFusion to make the sample smaller. Can someone tell me what I'm doing wrong? Thanks, Chris -- http://www.cjordan.info ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion RSS Aggregator
Ha, that looks great. But I'm broke :) T On 23 Jan 2007, at 15:06, Pete Freitag wrote: On 1/23/07, Tom King [EMAIL PROTECTED] wrote: Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Hi Tom, We have a commercial feed parser for sale here: http://foundeo.com/feed-parser/ it seams to do a pretty good job (I have used it on numberous sites), and has built in caching. You can download a free trial to test it out... -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://spendfish.com/ - Fish for Deals ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regular Expression Help....
Hi, RegExp's are not my forte and I need to create a function that will extract URL's from a body of text and return it in a list. I have a function that extracts the anchor tags from a document, but I need to acurately extract the URL from that anchor tag. I can do a find for 'href' and so on, but the RIGHT regular expression would make sure all possibilities are covered like href=, href=' or href= or href = and so on. Can anyone help please? Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: database JOIN question
The (+) notation was what Oracle used up until 9i, when they adopted the ANSI standard. There were a lot of things I liked about the (+) notation. Since I learned it first, I preferred it for a long time. Now, I think I prefer ANSI joins, finally. On 1/23/07, daniel kessler [EMAIL PROTECTED] wrote: I was working from this information: http://www.1keydata.com/sql/sqlouterjoin.html ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFEclipse / Eclipse question
Andrew... Can you explain FusionDebug? How does it allow you to step through your code if you have queries on the page? Andy matthews -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:33 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regular Expression Help....
This page might get you pointed in the right direction. http://foad.org/~abigail/Perl/url2.html -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:36 AM To: CF-Talk Subject: Regular Expression Help Hi, RegExp's are not my forte and I need to create a function that will extract URL's from a body of text and return it in a list. I have a function that extracts the anchor tags from a document, but I need to acurately extract the URL from that anchor tag. I can do a find for 'href' and so on, but the RIGHT regular expression would make sure all possibilities are covered like href=, href=' or href= or href = and so on. Can anyone help please? Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Regular Expression Help....
This one might be better: http://www.manamplified.org/archives/000318.html -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:50 AM To: CF-Talk Subject: RE: Regular Expression Help This page might get you pointed in the right direction. http://foad.org/~abigail/Perl/url2.html -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:36 AM To: CF-Talk Subject: Regular Expression Help Hi, RegExp's are not my forte and I need to create a function that will extract URL's from a body of text and return it in a list. I have a function that extracts the anchor tags from a document, but I need to acurately extract the URL from that anchor tag. I can do a find for 'href' and so on, but the RIGHT regular expression would make sure all possibilities are covered like href=, href=' or href= or href = and so on. Can anyone help please? Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse / Eclipse question
Ok, Dont think html, think your source code and with FusionDebug you are stepping through your coldfusion code. Simple as that On 1/24/07, Andy Matthews [EMAIL PROTECTED] wrote: Andrew... Can you explain FusionDebug? How does it allow you to step through your code if you have queries on the page? Andy matthews -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:33 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need a good JavaScript Forum
Does anyone know a good, heavy traffic JavaScript forum? Thanks. D ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFEclipse / Eclipse question
It actually ties into the ColdFusion server at pauses it's processing. On 1/23/07, Andy Matthews [EMAIL PROTECTED] wrote: Andrew... Can you explain FusionDebug? How does it allow you to step through your code if you have queries on the page? Andy matthews -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:33 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFEclipse / Eclipse question
Just FYI, the recent Flex Builder update (2.0.1) contains updated plugins which better support 3.2. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression Help....
Thanks, I'm working on something with that now, but does anyone know if there is a function or tag out there someone has already written that does this? It seems that I should not be the first person who needs to feed a function a body of text and get back a list of the URL's in that text. Thanks, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need a good JavaScript Forum
I'd say that Sitepoint's js forum is pretty high-traffic. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:57 AM To: CF-Talk Subject: Need a good JavaScript Forum Does anyone know a good, heavy traffic JavaScript forum? Thanks. D ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFEclipse / Eclipse question
That's what I mean...is there docs on how to get this working from within CFEclipse? I have a specific page that I'd love to use this on. -Original Message- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:57 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question It actually ties into the ColdFusion server at pauses it's processing. On 1/23/07, Andy Matthews [EMAIL PROTECTED] wrote: Andrew... Can you explain FusionDebug? How does it allow you to step through your code if you have queries on the page? Andy matthews -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:33 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse / Eclipse question
Sure on the FusionDebug website On 1/24/07, Andy Matthews [EMAIL PROTECTED] wrote: That's what I mean...is there docs on how to get this working from within CFEclipse? I have a specific page that I'd love to use this on. -Original Message- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:57 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question It actually ties into the ColdFusion server at pauses it's processing. On 1/23/07, Andy Matthews [EMAIL PROTECTED] wrote: Andrew... Can you explain FusionDebug? How does it allow you to step through your code if you have queries on the page? Andy matthews -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:33 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question The plugins available are going to depend on what you need. I use the following: * subclipse - a svn client that interfaces to a svn repositoy for source control * Jira - jira plugin that allows me to connect to our ticketing and help desk software * SQLDB (not sure the eaxact name) - a jdbc driver interface that allows me to connect to any data base type as long as there is a jdbc driver, I ca nrun queries, look at schemas, view detailed information about the relationships without leaving eclipse * FusionDebug - A great debugging tool for coldfusion and eclipse that allows one to step through code and debug code. * Aptana - as mentioned earlier it has great javascript, css and other support. But the latest also offers javascript debugging when using firefox so you can step through the code and debug the javascript, with breakpoints etc. * RDS plugin - This is from macromedia, but allows me to connect to a remote site and do the normal RDS stuff for coldfusion although this has bugs when using eclipse 3.2 They are the main ones that I use on a daily basis, I have others but as I dont use them often enough I can't recall them at this time. On 1/24/07, Jacob Munson [EMAIL PROTECTED] wrote: I use Aptana which gives you code insight for JavaScript, CSS, and a bunch of other stuff. I hear it has an excellent FTP interface too, but I don't use that. On 1/23/07, John Sterrett [EMAIL PROTECTED] wrote: What plug-ins are the Eclipse users on the board using with CFEclipse? Are there any recommendations for source control with VSS? Also, is there any plug-in that will add code hints for JavaScript within CFElipse? For example, in dreamweaver when you type style= a dropdown is populated with options. Are there any other plug-ins new users utilize? Regards, John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better way to send nulls to a Stored Proc?
If you do not pass in a value to the stored procedure and put a default value inside the stored procedure, the parameter becomes not required and thus you can set it equal to NULL in the stored procedure. You do not need to YesNoFormat the data. You can pass an empty string to the stored procedure with a cfparam just in case you have valid data. Let TSQL manage NULLs unless you run BlueDragon which has a NULL data type. Teddy On 1/23/07, Niall O'Doherty [EMAIL PROTECTED] wrote: Just thinking out of the box here, and not sure if this is exactly what you're after but wouldn't you be better letting SQL decide what to insert. By using the NULLIF() SQL Function you can still pass your date as 01/01/00 if no date is specified and use the NULLIF() function to evaluate what to insert...either the date or NULL. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Do I use a view for this?
Neil made me forget it! It's his fault! heehehee... Nahh.. I got it worked out I think. Thanks for the help. Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need a good JavaScript Forum
I've been on the following list even longer than I've been on HOF (and that's a while) Javascript mailing list [EMAIL PROTECTED] https://lists.LaTech.edu/mailman/listinfo/javascript [EMAIL PROTECTED] wrote: Does anyone know a good, heavy traffic JavaScript forum? Thanks. D ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Do I use a view for this?
If you are performing more thn your average calculations upon columns, I would recommend using table variables. It creates the ability to store data into a temporary variable that acts just like a table. It does not store the table variable in the tempDB and keeps it active in RAM until it is garbage collected at the end of the execution. It is extremely fast and it allows you to create a loop structure. Here is a link to show you how: http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=529 Table variables are valid as of SQL Server 2000 and 2005. Teddy On 1/23/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Lol ;-p -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 23 January 2007 12:26 To: CF-Talk Subject: Re: Do I use a view for this? Ok I'm getting a handle on things here. Using some T-SQL to do what I was having CF do. My only problem right now is I'm trying to calculate multiple products in a given category. This expression is producing an amount that's way too high for the category. SUM((tblConsignmentOrderItems.consignprodstartQTY - tblConsignmentOrderItems.consignprodendQTY) * tblConsignmentOrderItems.consignprodprice) AS catTotal This produces 1984.50, and it SHOULD be 283.50. Can't quite figure out how it's tallying up so much. Any ideas? Thanks for all the view info guys! Here's the whole SQL statement. Neil, don't say anything bout the non cfqueryparam'd statement. I'm just testing! lol! Will ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion RSS Aggregator
Tom, be sure to ping me with any fixes you make. I don't read cf-talk every day, so email me directly. On 1/23/07, Tom King [EMAIL PROTECTED] wrote: Ha, that looks great. But I'm broke :) T On 23 Jan 2007, at 15:06, Pete Freitag wrote: On 1/23/07, Tom King [EMAIL PROTECTED] wrote: Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Hi Tom, We have a commercial feed parser for sale here: http://foundeo.com/feed-parser/ it seams to do a pretty good job (I have used it on numberous sites), and has built in caching. You can download a free trial to test it out... -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://spendfish.com/ - Fish for Deals ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression Help.... (Solution?)
I think I have a solution, but if a few of you could review and see if it can be any faster or more efficient (or if I'm missing something) I'd appreciate it. To find the end of the URL I'm looking for a single quote, double quote or space. function extractURLs(inputString) { var nPos=0; var lsURLs = ; var sDelimiter = chr(9); var nEndPos = ; var sLink = ; var sRegExp = ([A-Za-z][A-Za-z0-9+.-]{1,120}:[A-Za-z0-9/](([A-Za-z0-9$_.+!*,;/?:@~=-])|%[A-Fa-f0-9]{2}){1,333}(##([a-zA-Z0-9][a-zA-Z0-9$_.+!*,;/?:@~=%-]{0,1000}))?); if(arrayLen(arguments) eq 2) { sDelimiter = arguments[2]; } nPos = reFindNoCase(sRegExp,inputString); while(nPos) { inputString = mid(inputString,nPos,len(inputString)); nEndPos = reFind(['#chr(34)# ],inputString); sLink = left(inputString,nEndPos-1); if(NOT listFindNoCase(lsURLs,sLink,sDelimiter)) { lsURLs = listAppend(lsURLs, sLink, sDelimiter); } inputString = mid(inputString,nEndPos,len(inputString)); nPos = reFindNoCase(sRegExp,inputString); } return lsURLs; } Thanks! Dave Hi, RegExp's are not my forte and I need to create a function that will extract URL's from a body of text and return it in a list. I have a function that extracts the anchor tags from a document, but I need to acurately extract the URL from that anchor tag. I can do a find for 'href' and so on, but the RIGHT regular expression would make sure all possibilities are covered like href=, href=' or href= or href = and so on. Can anyone help please? Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Apache config
-Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 3:53 AM To: CF-Talk Subject: Re: Apache config As Dave noted, as a matter of course you should have at least a Dev and Testing environment. Ideally an R D, Dev, Test, UAT, and Pre- Production before you even think of moving to a Production environment. You should *never* have a system (painly RD and dev) which is not in sync, configs and all with production. Unfortunately, this is not always possible. For example, in our environment, every developer has their own work environment (CFEclipse, Apache, multi instance CF) on their workstations, we have a single staging server, and a multi-server n-tier production environment. I don't see how it's possible to have an identical configuration with production, unless we want to spend a lot of money for servers that will just be sitting there (even with virtualization, we would have to buy a pretty powerful server, and Windows licenses for every virtual machine as well as the host). This is just not practical for our shop and I suspect for most other small shops out there. Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Issue
Rich, Can you post your CFINDEX code? Also, have you tried deleting and re-creating yoru collections? Dave Has anyone else seen this error when trying to index a collection. We are on CFMX 7.0.2. General failure. (-2) The specific sequence of files included or processed is: \mx7verity.cfm, line: 5. The only thing on line 5 is the url path. I can't find any help on Adobe's site for this. Rich Sloan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
error emails firing for no reason
I have a page that is acting extremely strange. It's a simple form processing page that runs validation against some of the passed form fields. If it fails any of the checks, it displays a basic error message and asks the user to go back to the form to fix the changes (this was not my work, it's legacy code). In order to do the checks, obviously the form fields have to exist. When I run the page and it finds a validation issue, the warning messages are put into an array as the checks are done, and if that array is found to have anything in it, the contents of the array are displayed. If nothing is found, the database is updated. This processes completely normally, nothing out of the ordinary. But for some weird reason, when the warning messages are displayed, the error emails that my onError function in Application.cfc creates are also triggering, claiming the form field being checked in the very first validation check cannot be found. To make matters weirder, the HTML page that the onError code creates (in addition to the email that is sent) is NOT displayed. I have debugging turned on, and it shows all the form fields passed to the page. Sure enough the field the error email claims is not there, is in fact there. I have tried wrapping the block the error email references in a CFTRY/CFCATCH to try and muzzle it. The email still is being sent. So I am really lost as to what is triggering these emails. I have Ray Camden's code regarding the CFABORT/CFLOCATION issues with onError already in. Any ideas at all? thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Apache config
-Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 3:47 AM To: CF-Talk Subject: Re: Apache config Re: IIS multiple domain tools, I am unsure how they are ugly workarounds? I mean, what is ugly about a one click change and a change to your host file (the latter being done by IIS and Apache users anyway). The fact is, you can run both IIS and Apache on XP locally in the same multi domain way, Not sure what you mean by a single dev server? I haven't used the tool in question, so I might be wrong about this, but it just wouldn't work in our environment. For a single site that we're building, I have 3 domains that are used at the same time (2 of which are just rewrites for the 3rd in certain sections of the site). It would not be possible for me to use the multi domain tool, as I require 2 sites to be up at the same time. Apache handles this, IIS doesn't. I have nothing against IIS, but MS should get with the program and stop enforcing the single site limit for XP's IIS, but then again, they don't have any incentive in doing so. IIS is free with the OS anyway, and if they uncrippled XP's version they would sell less server licenses, as XP is more then enough to run as a server for most shops. Come to think of it, why am I using Win2k3 servers on our staging environment? Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFEclipse / Eclipse question
On 1/23/07, Andy Matthews [EMAIL PROTECTED] wrote: That's what I mean...is there docs on how to get this working from within CFEclipse? I have a specific page that I'd love to use this on. Andy: Charlie Arehart did a slew of articles and blog entries (and presentations) on Fusion Debug. Check out his blog: http://carehart.org/blog/client/index.cfm/fusiondebug -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFEclipse / Eclipse question
Thanks Charlie! -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 10:48 AM To: CF-Talk Subject: Re: CFEclipse / Eclipse question On 1/23/07, Andy Matthews [EMAIL PROTECTED] wrote: That's what I mean...is there docs on how to get this working from within CFEclipse? I have a specific page that I'd love to use this on. Andy: Charlie Arehart did a slew of articles and blog entries (and presentations) on Fusion Debug. Check out his blog: http://carehart.org/blog/client/index.cfm/fusiondebug -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Apache config
-Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 1:25 AM To: CF-Talk Subject: RE: Apache config I don't have anything against learning new things, but I don't care at all for the evangelism. If someone says Apache beats the pants off IIS, but it has a learning curve, they should be prepared to accept the obvious response that ease of use has value. All of the arguments that you've made against IIS are the same sort of arguments people generally make against CF, and if CF has proven anything, it's the value of ease of use. I agree that CF's value is ease of use, but I also think it's power. Power to be extended through Java and to a lesser degree C++. Powerful features that are not available with ASP.NET or PHP. Powerful enterprise features such as session replication. I will give you that IIS has easy management. I think we've agreed that it's the only place where IIS outshines apache. Apache is more configurable and has more features then IIS. Have you seen the load balancing features in the 2.x versions? You can actually use Apache to do load balancing, instead of having a hardware load balancer. Recently, I set up a cluster of CF servers. We used a hardware load balancer and in order to make health checks work properly while having session replication enabled I had to make changes to the Apache jrun connector. It's a good thing that Adobe decided to provide the source for it. Even though it took me a while, I was able to make the necessary changes, and compile the apache module and make it work as it should. This would not have been an option for IIS, as Adobe doesn't provide the source for the connector. I think the bottom line is this. If you are coming into an MS heavy environment that already uses IIS, switching to apache is likely not an option. If you are just starting out in managing web servers, apache will prove more hassle then its worth. If you are, however, a seasoned web developer/server administrator and you have a chance to set up a new environment (as I did some time ago), then Apache is probably the best choice for you. It's also likely the best choice if you are running a development environment on an XP machine. We are, after all, programmers. We should not be afraid of doing a little coding to configure our web server. If we preferred nice pretty GUI's, we'd probably be all coding Visual Basic. Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better way to send nulls to a Stored Proc?
Yep, I used... nullif(@DateIn,'') and it worked just fine. I suspected that T-SQL could do it cleanly, but my skills at T-SQL null-handling are very weak. Thanks Niall, and Teddy On 1/23/07, Niall O'Doherty [EMAIL PROTECTED] wrote: Just thinking out of the box here, and not sure if this is exactly what you're after but wouldn't you be better letting SQL decide what to insert. By using the NULLIF() SQL Function you can still pass your date as 01/01/00 if no date is specified and use the NULLIF() function to evaluate what to insert...either the date or NULL. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Issue
Hi dave the code is listed below. This is the only thing in the template. I have tried deleting and recreating the collection and I get the same error. cfindex action=Refresh collection=all_products key=F:\wwwroot\cxdev\ type=PATH urlpath=http://cxdev2.trizetto.com; extensions=.txt, .html, .doc, .xls, .pdf, .ppt recurse=Yes Rich, Can you post your CFINDEX code? Also, have you tried deleting and re-creating yoru collections? Dave Has anyone else seen this error when trying to index a collection. We are on CFMX 7.0.2. General failure. (-2) The specific sequence of files included or processed is: \mx7verity.cfm, line: 5. The only thing on line 5 is the url path. I can't find any help on Adobe's site for this. Rich Sloan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Regular Expression Help....
Dave, This snippet takes your regular expression and returns all matches in an array: http://www.bennadel.com/index.cfm?dax=snippets:11.view You can then take that and convert it to a list (but I would guess keeping it in an array is the way to go). After that, all you need is a good RegExp, which it looks like other people have already provided. Keep in mind, this snippet is for use with JAVA regular expression, which are slightly different but same idea. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 9:55 AM To: CF-Talk Subject: Re: Regular Expression Help Thanks, I'm working on something with that now, but does anyone know if there is a function or tag out there someone has already written that does this? It seems that I should not be the first person who needs to feed a function a body of text and get back a list of the URL's in that text. Thanks, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Regular Expression Help.... (Solution?)
Oh sorry, I didn't see the Solution email before I posted my last snippet. What you are doing below is fine. I cannot attest to the RegEx. You might want to try grabbing something of of RegExLib.com if you are unsure. I do know you should probably check for period . to end a URL, but do not confuse with file extension. URLs are a tricky beast. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 10:25 AM To: CF-Talk Subject: Re: Regular Expression Help (Solution?) I think I have a solution, but if a few of you could review and see if it can be any faster or more efficient (or if I'm missing something) I'd appreciate it. To find the end of the URL I'm looking for a single quote, double quote or space. function extractURLs(inputString) { var nPos=0; var lsURLs = ; var sDelimiter = chr(9); var nEndPos = ; var sLink = ; var sRegExp = ([A-Za-z][A-Za-z0-9+.-]{1,120}:[A-Za-z0-9/](([A-Za-z0-9$_.+!*,;/?:@~=- ])|%[A-Fa-f0-9]{2}){1,333}(##([a-zA-Z0-9][a-zA-Z0-9$_.+!*,;/?:@~=%-]{0, 1000}))?); if(arrayLen(arguments) eq 2) { sDelimiter = arguments[2]; } nPos = reFindNoCase(sRegExp,inputString); while(nPos) { inputString = mid(inputString,nPos,len(inputString)); nEndPos = reFind(['#chr(34)# ],inputString); sLink = left(inputString,nEndPos-1); if(NOT listFindNoCase(lsURLs,sLink,sDelimiter)) { lsURLs = listAppend(lsURLs, sLink, sDelimiter); } inputString = mid(inputString,nEndPos,len(inputString)); nPos = reFindNoCase(sRegExp,inputString); } return lsURLs; } Thanks! Dave Hi, RegExp's are not my forte and I need to create a function that will extract URL's from a body of text and return it in a list. I have a function that extracts the anchor tags from a document, but I need to acurately extract the URL from that anchor tag. I can do a find for 'href' and so on, but the RIGHT regular expression would make sure all possibilities are covered like href=, href=' or href= or href = and so on. Can anyone help please? Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache config
Dave Watts wrote: However, for the 5-10 person development shop (which most development companies are) this is not a practical solution. It would cost more to set up the infrastructure for this then it would to simply deal with the extremely rare patch problems when they arise. Most development shops may be that small, but they don't account for the majority of developers, I suspect. Most companies that I've worked with do, in fact, have this sort of environment, and it's integral to their development process. Hmm... I think we're just going to have to agree to disagree on which one has the majority. Unless one of us (or a reader) has some hard facts for us. At the moment, we simply appear to be commenting off our own experiences. ;) How else do you test the software you write? For me personally, I use virtualization when I can, but when doing development work for another company, we usually create a dev environment on the same server. When you're doing development work for folks who have nothing more then a shared hosting environment (or if you're lucky, a VPS) you don't have the luxury of a completely separate development environment. As a developer, I realize that this is not the ideal situation, but it is the most practical in many situations. If I were to refuse to do development work for a client because they did not have a development environment, how long would that client remain my customer? Not long. If I were to set up a development environment of my own that was identical to my clients - only to test things that will probably not be a problem for me - how long would I be able to stay in business by investing all that additional (and usually unnecessary) time and money? Not long. All business must do what's practical - and berating someone for not doing so is incorrect unless you know where that person is coming form. You seem to work with (and thus discuss) development solutions for larger companies who have already made a significant investment in a certain kind of technology. But for the majority of folks that *I* work with, this is not the case, and thus recommending not-so-costly solutions is piratical for me and my clients. It seems to me to be more of a norm on this list as well. And, except for hardware-specific stuff, you can do this pretty cheaply and easily through virtualization. Agreed. =) However, don't forget the time investment that's involved with this. The time investment can also add up pretty quickly - particularly for those of us with simple 5-10 person shops. Maybe he did miss your point, but it looks to me like you are also missing his. Why pay for something that you have to learn - when you could just learn it without having to pay for it before-hand? The syntax is nearly identical, and it's available for free. But, that's irrelevant. If someone asked me to recommend web server software, and the most important thing they were looking for is the ability to rewrite URLs, I'd unhesitatingly recommend Apache. On the other hand, if someone was already using IIS and needed to rewrite URLs all of a sudden, I probably wouldn't recommend they switch web servers just for that ability. Agreed. =) It totally depends on the situation. I personally see nothing wrong with taking time to learn something that could potentially save my company time and money - and how will I know for sure unless I explore those options? I think that is all most people are trying to do when they post things to this list regarding non-MS software. Quite frankly, I don't understand why you are so against learning about your alternatives. I don't know about you, but I like learning new things even if it's just for the sake of learning. It's part of why I enjoy the technology industry so much. So why not put that effort somewhere that would be beneficial to me and my company? If every time someone posted a problem they were having with Apache, would the appropriate response be to say that IIS beats the pants off Apache, and they should switch? If someone has a problem with doing something in CF, should I suggest ASP.NET or PHP instead? Or is evangelism only appropriate when suggesting a replacement for MS products? I did not see evangelism as much as I saw someone making a practical suggestion for a problem. There was probably some evangelism involved, but we all do that with things we like. It's human nature - and beneficial really. If something has helped you, I'd like to know about it because it may be helpful to me as well. Not all suggestions to evaluate Apache (or any alternative technology for that matter) should be considered evangelism. I don't have anything against learning new things, but I don't care at all for the evangelism. If someone says Apache beats the pants off IIS, but it has a learning curve, they should be prepared to accept the obvious response that ease of use has value. That is a pretty broad statement - and in some
Image size
I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image size
Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image size
Efflare.com has ImageCR that can do what you want. I use them all the time and they are rock solid applications. Chad -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 12:26 PM To: CF-Talk Subject: Image size I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash forms and charset question
Hey there, These settings in the Application.cfm file seemed to be the problem. cfcontent type=text/html; charset=ISO-8859-1 cfset setEncoding(Form, ISO-8859-1) After taking that out, it works. When this site was first coded, it ran on Linux+Apache+BlueDragon+MySQL4.1 Now it's on Windows 2003 + IIS6 + CF7 + MS SQL 2000 Total change from old server to new. Works now. Thanks, Yves On 1/22/07, Paul Hastings [EMAIL PROTECTED] wrote: Yves Arsenault wrote: by weirdness, I just mean the characters (special characters such as those frequently used in french) aren't submitted properly. Example: � = �(c) first check that it's coming thru on the other end ok (ie it's not a db issue). can you simply dump out the form vars as plain text (making sure to keep your encoding the same as the form's)? can you make the test page public? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash Forms timeout issue
I am having a problem with Flash Forms timing out. I have a form that allows the user to enter a coupon code. If they enter the wrong code then I give them a link back to the previous page that the textbox control reloads. However, if the user clicks the backspace button like I usually do in these instances, or perhaps they click on the Back button on their browser, the form times out and you have to refresh the browser. I am using the timeout attribute and setting it for 10 minutes, but still it times out. Am I not understanding the timeout attribute? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image size
Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 11:18 AM To: CF-Talk Subject: Re: Image size Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFML IDE's
Which Mark? Not sure which sandwich it was, but I am assuming that you mean the wouldn't touch it with a barge pole is a saying which means: its so disgusting I wouldn't even poke it with a stick, a stick that belongs to someone else, and has already been thrown away. Make sense? MD On 23 Jan 2007, at 00:58, Eric Roberts wrote: Mark's just biased ;-) Eric -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, 22 January 2007 08:04 To: CF-Talk Subject: RE: CFML IDE's What in the ham sandwidch is he talking about? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Thursday, January 18, 2007 11:18 AM To: CF-Talk Subject: Re: CFML IDE's you mean IDE's or just text editors? Homesite is a great text editor, so I am told. Wouldn't touch it with a barge pole myself. I hear CFEclipse is quite a good IDE. MD On 18 Jan 2007, at 15:57, John Sterrett wrote: Does anyone have any recommendations for Coldfusion IDE's on Windows platform other than Dreamweaver? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image size
I believe that CF 5 and up supports CFX tags. -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! On 1/23/07, Dave Francis [EMAIL PROTECTED] wrote: Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image size
Dave, If you have access to your CF Administrator you should be able to add CFX's in CF 5. I remember doing that years ago. Check out your administrator pages. There should be a place where you can specify your CFX tags. Dave Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 11:18 AM To: CF-Talk Subject: Re: Image size Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image size
It depends on the CFX. You can load CFXs in 4.5 but it does not mean that all CFXs will run on 4.5. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 1:14 PM To: CF-Talk Subject: RE: Image size Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 11:18 AM To: CF-Talk Subject: Re: Image size Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Image size
CFX tags go back quite a ways. In the pre-MX days (when CF was written on C++), they were generally compiled C++ code. On 1/23/07, Chad Gray [EMAIL PROTECTED] wrote: It depends on the CFX. You can load CFXs in 4.5 but it does not mean that all CFXs will run on 4.5. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 1:14 PM To: CF-Talk Subject: RE: Image size Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 11:18 AM To: CF-Talk Subject: Re: Image size Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image size
Has anyone else read this and suddenly felt very old?! I started on 4 and you're all talking like it was 6 odd years ago... oh, it was! :Oo Ade -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 23 January 2007 18:28 To: CF-Talk Subject: Re: Image size CFX tags go back quite a ways. In the pre-MX days (when CF was written on C++), they were generally compiled C++ code. On 1/23/07, Chad Gray [EMAIL PROTECTED] wrote: It depends on the CFX. You can load CFXs in 4.5 but it does not mean that all CFXs will run on 4.5. -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 1:14 PM To: CF-Talk Subject: RE: Image size Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 11:18 AM To: CF-Talk Subject: Re: Image size Dave, I seem to remember there being a CFX_Image or CFX_ImageInfo. Google that. Dave I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image size
Could someone pls clear this up for me. I thought that CFX_'s require CF6 or greater? No, they were introduced in CF 1.5, if I recall correctly. They had to be written in C++ until either 4 or 5, I think. CFML custom tags were introduced in CF 3. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4