[cfaussie] Flash Builder with ColdFusion Builder Projects
Is it possible to have ColdFusion Builder only display CF projects and for Flash Builder to only display FLEX projects? It is starting to get a bit annoying having them all display when i only want to see the projects associated with the perspective i have open. Steve === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16000) http://www.pctools.com/ === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query
You learn something new every day - awesome, Thanks Chris! As always, please contact me if I can be of any futher assistance. Gavin Beau Baumanis Senior Application Developer PalCare Pty. Ltd. P: +61 -3 9380 3513 M: +61 -438 545 586 E: b...@palcare.com.au W: http://palcare.com.au On 04/10/2010, at 4:22 PM, christophe albrech wrote: Hi Scott, If I may, your code could be improved performance-wise. It is a classic example of Rbar programming (pronounced reebar = Row by agonizing row) as the process is not written in a set-based way, which is exactly what DB servers are really good (and really fast) at. If you think about it, the code loops over each record in the first query (the cfif is useless by the way) , and then does an update for each one. if you have a thousand records, that's a thousand loops, a thousand queries sent through the wire, a thousand query the optimizer has to parse, and so on. What you really want to do is have a single update statement instead. The problem in your case is that using aggregation forces you to use a group by statement. On top of that you need the aggregated data to perform the set operation which complicates the matter. While writing one single statement is possible it's probably easier to read if you use a temp table to store the maxed date and then write a single update. like so: cfquery SELECT sb_invoice.sb_invoice_id, MAX(sb_claim_date) AS sb_claim_date INTO##tempTable FROMsb_invoice INNER JOIN sb_invoice_item ON sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id INNER JOIN sb_item_claim ON sb_invoice_item.sb_invoice_item_id = sb_item_claim.sb_invoice_item_id WHERE sb_invoice.sb_bill_mech_code IN ( 'M', 'F', 'AG', 'SC', 'MB', 'MO' ) AND sb_invoice_item.sb_item_status_code IN ( '21', '24', '31' ) GROUP BY sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date HAVING sb_invoice.sb_reminder_date DATEADD(d, 30, MAX(sb_claim_date)) UPDATE i SET sb_reminder_date = DATEADD(d, 31, t.sb_claim_date) FROMsb_invoice i INNER JOIN #tempTable t ON i.sb_invoice_id = t.sb_invoice_id /cfquery The more records the initial select returns, the more resources you save. I just tried a simple example on my local machine where I tried to update 10k rows with both methods. the rbar one took about 10 seconds while the set-based one took less than half a second. trying with 100k rows, I got 70 seconds against 2.5. Let's keep in mind that lots of updates wouldn't need the temp table in the first place. It's only there because because you were updating with an aggregated value. Normally you'd just do: UPDATE t set blah = 6 FROM myTable t JOIN otherTable o on o.id = t.fk ... ... Anyway, speaking of agonizing stuff, I'm off to see the dentist. Cheers, Tof On Fri, Oct 1, 2010 at 11:30 AM, Scott Thornton scott.thorn...@hnehealth.nsw.gov.au wrote: Hello, Thanks for all replies. An update of my local dev server to 9,0,1,274733 appears to have solved the problem. From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton Sent: Friday, 1 October 2010 10:29 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query HI All, 1. What happens if you try CFDUMP instead right after the query? using cfdump var=#fix_this#cfabort returns Variable FIX_THIS is undefined. 2. re recordcount gt 0. I didn't know that, thanks. 3. Why the cfoutput? The original code used cfloop, I tried using cfoutput as well. Typically cfloop would be used. 4. Update CF? Will try that now. 5. Does the query run (as is)? Yes it does, however it does not return any rows ( in SQl Query Analyzer 2000). The database is MS SQL 2005 5. Much simplier query? cfquery datasource=#DSN# name=fix_this select top 1 * from sb_invoice /cfquery cfdump var=#fix_this#cfabort works fine. Sooo, I will update my local server first, then put the orginal query back in and see how it goes. From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of m...@ampersand.net.au Sent: Friday, 1 October 2010 9:41 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query What happens if you try CFDUMP instead right after the query? On 1/10/2010 9:35 AM, Scott Thornton wrote: Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a long time. part of that process runs a query and then loops over the result set. Simple enough… however the query does not seem to exist after it has run. eg: The
[cfaussie] CFGRID Sort Issues
Using CF9 Trying to do a simple cfgrid with numeric data in some columns. It just wont work cfform name=dataForm cfgrid format=html name=dataGrid query=query height=400 cfgridcolumn name=name width=120 header=Name / cfgridcolumn name=salary width=60 header=Salary type=numeric / /cfgrid /cfform Even though I specify numeric when sorting, salary always sorts alpha. I cant find anything in google that suggests a bug or workaround, this should work. Regards Dale Fraser http://dale.fraser.id.au http://dale.fraser.id.au http://cfmldocs.com/ http://cfmldocs.com http://learncf.com http://learncf.com http://flexcf.com http://flexcf.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Flash Builder with ColdFusion Builder Projects
Define working sets. Eclipse always shows all projects - unless you define working sets. On Sun, Oct 3, 2010 at 11:23 PM, Steve Onnis st...@cfcentral.com.au wrote: Is it possible to have ColdFusion Builder only display CF projects and for Flash Builder to only display FLEX projects? It is starting to get a bit annoying having them all display when i only want to see the projects associated with the perspective i have open. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query
Hi Scott, If I may, your code could be improved performance-wise. It is a classic example of Rbar programming (pronounced reebar = Row by agonizing row) as the process is not written in a set-based way, which is exactly what DB servers are really good (and really fast) at. If you think about it, the code loops over each record in the first query (the cfif is useless by the way) , and then does an update for each one. if you have a thousand records, that's a thousand loops, a thousand queries sent through the wire, a thousand query the optimizer has to parse, and so on. What you really want to do is have a single update statement instead. The problem in your case is that using aggregation forces you to use a group by statement. On top of that you need the aggregated data to perform the set operation which complicates the matter. While writing one single statement is possible it's probably easier to read if you use a temp table to store the maxed date and then write a single update. like so: cfquery SELECT sb_invoice.sb_invoice_id, MAX(sb_claim_date) AS sb_claim_date INTO##tempTable FROMsb_invoice INNER JOIN sb_invoice_item ON sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id INNER JOIN sb_item_claim ON sb_invoice_item.sb_invoice_item_id = sb_item_claim.sb_invoice_item_id WHERE sb_invoice.sb_bill_mech_code IN ( 'M', 'F', 'AG', 'SC', 'MB', 'MO' ) AND sb_invoice_item.sb_item_status_code IN ( '21', '24', '31' ) GROUP BY sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date HAVING sb_invoice.sb_reminder_date DATEADD(d, 30, MAX(sb_claim_date)) UPDATE i SET sb_reminder_date = DATEADD(d, 31, t.sb_claim_date) FROMsb_invoice i INNER JOIN #tempTable t ON i.sb_invoice_id = t.sb_invoice_id /cfquery The more records the initial select returns, the more resources you save. I just tried a simple example on my local machine where I tried to update 10k rows with both methods. the rbar one took about 10 seconds while the set-based one took less than half a second. trying with 100k rows, I got 70 seconds against 2.5. Let's keep in mind that lots of updates wouldn't need the temp table in the first place. It's only there because because you were updating with an aggregated value. Normally you'd just do: UPDATE t set blah = 6 FROM myTable t JOIN otherTable o on o.id = t.fk ... ... Anyway, speaking of agonizing stuff, I'm off to see the dentist. Cheers, Tof On Fri, Oct 1, 2010 at 11:30 AM, Scott Thornton scott.thorn...@hnehealth.nsw.gov.au wrote: Hello, Thanks for all replies. An update of my local dev server to 9,0,1,274733 appears to have solved the problem. *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *Scott Thornton *Sent:* Friday, 1 October 2010 10:29 AM *To:* cfaussie@googlegroups.com *Subject:* RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query HI All, 1. What happens if you try CFDUMP instead right after the query? using *cfdump var=#fix_this#cfabort* * * *returns * Variable FIX_THIS is undefined. 2. re recordcount gt 0. I didn't know that, thanks. 3. Why the cfoutput? The original code used cfloop, I tried using cfoutput as well. Typically cfloop would be used. 4. Update CF? Will try that now. 5. Does the query run (as is)? Yes it does, however it does not return any rows ( in SQl Query Analyzer 2000). The database is MS SQL 2005 5. Much simplier query? cfquery datasource=#DSN# name=fix_this select top 1 * from sb_invoice /cfquery cfdump var=#fix_this#cfabort works fine. Sooo, I will update my local server first, then put the orginal query back in and see how it goes. *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *...@ampersand.net.au *Sent:* Friday, 1 October 2010 9:41 AM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query What happens if you try CFDUMP instead right after the query? On 1/10/2010 9:35 AM, Scott Thornton wrote: Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a long time. part of that process runs a query and then loops over the result set. Simple enough… however the query does not seem to exist after it has run. eg: The following code returns Element RECORDCOUNT is undefined in FIX_THIS. cfquery datasource=#DSN# name=fix_this select sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date, max(sb_claim_date) as sb_claim_date from sb_invoice inner join sb_invoice_item on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id inner join sb_item_claim on
[cfaussie] [ANN-BRIS] Next CFUG Meeting - 21/10/10
Tuning ColdFusion - The JVM, Garbage Collection and More. 21/10/10 05:30PM TASS - Bowen Hills, Brisbane Unit 1/31 Thompson St, Bowen Hills, 4006 Carl Meyer will show us how to get the most out of your ColdFusion instance for larger applications, with tuning your JVM, Garbage Collectors and more. AGENDA: 5:30 - 6:00 PM - Doors Open, Welcome, News, Food and Drink A welcome to CFUG / Discussions with Fellow Attendees. Food and Drink Available. Quick News about items in previous or coming months. 6:00 - 7:00 PM - Main Presentation Presented by Carl Meyer. 7:00 - 7:30 PM - Prize Draw Make sure you RSVP to enter the draw. 7:30 - 8:00 PM - Open QA We will open the floor to any general questions and discussions. If you would like to send any questions, concerns or topics beforehand, please feel free. SEEKING PRESENTERS: Anyone wishing to present to the group, or looking for additional info on presenting, please contact ghedwards (at) gmail.com If there is anything at all that you would like to see presented at future meetings, please let us know. RSVP: For more information, and to RSVP, please visit out site. http://qld.cfug.org.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Flash Builder with ColdFusion Builder Projects
As Sean has suggested: working sets are probably the best option. The other idea would be just to separate your CF and Flex projects in two different workspaces. The latter becomes a bit inconvenient though if you need to switch between projects often (as it involves restarting Eclipse). Cheers Kai On 4/10/2010, at 7:23 PM, Steve Onnis wrote: Is it possible to have ColdFusion Builder only display CF projects and for Flash Builder to only display FLEX projects? It is starting to get a bit annoying having them all display when i only want to see the projects associated with the perspective i have open. Steve -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
