Re: [cfaussie] Re: Really strange WebService issue.
cfset wsURL = http:// mywebservicepath/jira/rpc/soap/jirasoapservice-v2?wsdl cfset CreateObject( java, coldfusion.server.ServiceFactory ).XmlRpcService.RefreshWebService(wsURL) / Something like this will refresh the webservice if cached dont think this is supported but can be used to help debug. hth Rod. On Fri, Oct 8, 2010 at 2:50 PM, Matthew matthewbchamb...@gmail.com wrote: Hi Gavin I've only skim read the thread but you shouldn't need to restart CF. You just need to refresh the WSDL reference in CFADMIN. CF caches or reads the WSDL and stores it somehow. I'm sure of it because I've had similar issues. My code only picks up the modified WSDL once I refresh it in CFADMIN. It makes sense because request and response definitions can be complex so if CF had to work this out each time you make a call it would be a big overhead. Hope that helps. Cheers Matthew On Oct 8, 1:21 pm, MrBuzzy mrbu...@gmail.com wrote: Gav, it depends on your code, but generally the wsdl is not hit on every request. Wsdl = web service description language. When you invoke a method your calling code is passing XML to the web service endpoint that is described in the wsdl. Look for soap:address ... / in the wsdl that's the actual URL that does all the work. As discussed earlier there are ways and means or re-reading the wsdl programmatically and interactively. But depending on how you write your cf application it may appear that the calling code is not seeing the new wsdl when it changes (hence your need to restart) It's actually possible to publish a web service without wsdl, in other development environments ie traditional java the wsdl is only useful during development to generate java objects. The wsdl need not exist at run time. I hope this helps in some way. I guess you will come back to your original question - why did you need to restart? Hard to say but there are a few reasons this can occur. Sent from my iPhone On 08/10/2010, at 12:42, Gavin Beau Baumanis b...@palcare.com.au wrote: Hi Again everyone, I just had a chat with Chris Velevitch and he asked me something that neither of us knew the answer to - but actually made clear to me what he was writing in his original reply. Lets just assume that the service is on a completely different box / perhaps even written in some other language. I have a CFML application consuming that service. Does my CFML application (or perhaps the underlying CFML engine) cache the WSDL at all? or is it completely re-read by the consumer every request? And neither of us know the answer - but if there is any consumer caching - could that be the cause of things not behaving? Could the underlying JVM (JRun?) be doing anything - Afterall I restarted the CF service but not the JRun service during my testing? if it mis-behaves again - I'll try restarting the JVM service too - and see if that makes any differences and write back here with any further news... But for the time being seems like I have more questions and still no answers... Thanks again to everyone for their help Gavin. On 08/10/2010, at 11:50 AM, Gavin Beau Baumanis wrote: Hi Chris, I must be wearing my fogged up glasses because I'm not sure I'm understanding you correctly / or perhaps its the way I have written it? We have multiple clients who currently have their own URL and their own source code. They are all physically on the same server using the same instance of Coldfusion. The staging server and the production server are all set up the same. Clients log into both - using the staging server for UAT and staff training. The Login service lives at a URL that resides on the staging server / staging cf instance. And basically returns a true / false for a username / password match. And also returns a struct of relevant user information (username / surname / fullname / phone / etc. Restarting Apache / CF Service / manually refreshing the WSDL / clearing the CFC and template caches (via CFAdmin) effects the service and the calling code. Thus my confusion with why that process didn't work - but completely restarting the Staging server did work. So, I suppose my confusion is - how will programatically refreshing the WSDL be any different to using the CF Admin and furthermore - why would restarting the box wholly be any different? 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 08/10/2010, at 11:15 AM, Chris Velevitch wrote: The service is indeed called by CFML code and is also on the same box as the code that is calling it. It is being used as a webservice, not a CFC call from another server. Are the production systems the same as
[cfaussie] Farcry Implementation - Ongoing Work
Hi, I am overloaded with work atm and have a Sydney based large client we have implemented a farcry site for. They require 3 more phases - an intranet, a sales tracking system and a simple read only extranet all based on farcry. I would imagine the work to be about 20K or so but that would be up to new firm / sole trader taking on the work to quote directly to the client - timelines would also need to be discussed with the client. I can no longer afford the time for support / project management / development so they would take on all of this work as well - they already have a wish list for version 2 of their website. If any one is interested in taking on the client please contact me off list for further details. Cheers, Rod. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@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 -~--~~~~--~~--~--~---
[cfaussie] Re: MYOB as a datasource - has anyone done it?
Mike, Setup a blank access db - link tables to myob using a ODBC connection. Check the case sensitivity on the tables within myob after linking. Run queries using the access db then port them into CF once successful. Worked this way for me. Hth Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Tuesday, 4 March 2008 5:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MYOB as a datasource - has anyone done it? yes i have a ODBC DSN set up in the WinXPPro administration tools MYOB provide a connection test app, (click and it says DSN OK or DSN Failed). So i set up the ODBC DSN in WIndows, and checked it worked with the tool. Yes it did. So i went to the CF8 administrator and set up a DSN there, linking using the ODBC Connector to the DSN mentioned in the previous paragraph. Worked ok, Clicked the ok button and got OK result. Beauty! I thought - this is going great guns. Next step - go to the site and make a test page with a simple query in it, and CFDUMP of the result - to check it all works that far. BUMMER! Back to the CFAdministrator - is the DSN still working? Click the OK button - get OK.So it looks to me like Coldfusion is connecting to the MYOB database, but running a query on it, even a simple select query not an insert or update breaks something, or alternatively it's not set up properly, somehow. I've called the MYOB support area and they dont know anything about Coldfusion (surprise surprise) but they verified that I have the datasource configured correctly, at least as far as it gets to ColdFusion. Once i got to talkilng about anything to do with ColdFusion they just went blank, 'sorry can't help you'.. So that's why i'd really like to hear from anyone who has actually managed to make a CFQUERY work on a MYOB datacource. I havent been able to confirm that if i set it up correctly it will indeed work. I dont want to spend ages working on this if it's goign to end up that there's some imcompatibility between CF and MYOB or something and it's never going to work. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Mar 4, 2008 at 5:22 PM, Steve Onnis [EMAIL PROTECTED] wrote: Have you tried using an ODBC Socket connection and connecting to that in CF? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] BMUG Meeting Postponed to 22/11/2007
Hi, Not sure what is happening this month but we have had very little interest in this month's meeting for BMUG, as such we will postpone to next Thursday the 22nd of November to see if more coders crawl out into the daylight. Please if your are interested in coming along let us know. We generally have about 10 or so turnout each month but everyone must be busy atm? If you can come along next Thursday send through an email to [EMAIL PROTECTED] Hope to see a flood of spam sent through. Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] BMUG November Meeting
BMUG November Meeting Details Just a reminder the BMUG meeting is this Thursday, 12th of November, at the usual place for a 6.30pm start. Details can be found on the www.bmug.org.au site for more info including a location map. This month there will be a tshirt giveaway and also tickets for the next software raflle will be available to all attendees. cfimportant Beer, wine, sandwiches and nibbles are free - we will even drink the leftover supplies and restock for this month's meeting! /cfimportant This month there will be a presentation on java integration and also one on some hidden new features of CF8 including looking under the hood at PDF generation. Please indicate your attendance by email to [EMAIL PROTECTED], so we can guage numbers for catering. Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: BMUG November Meeting
My apologies the date is actually the 15th of November, this coming Thursday. I will make a mental to actually look at the calendar next time before sending out an email! Thanks Greg. On Nov 12, 2007 3:33 PM, Greg Misdom [EMAIL PROTECTED] wrote: Hi Rod, did you mean monday 12th or thursday 15th? regards Mizdog! On Nov 12, 2007 2:36 PM, rod higgins [EMAIL PROTECTED] wrote: BMUG November Meeting Details Just a reminder the BMUG meeting is this Thursday, 12th of November, at the usual place for a 6.30pm start. Details can be found on the www.bmug.org.au site for more info including a location map. This month there will be a tshirt giveaway and also tickets for the next software raflle will be available to all attendees. cfimportant Beer, wine, sandwiches and nibbles are free - we will even drink the leftover supplies and restock for this month's meeting! /cfimportant This month there will be a presentation on java integration and also one on some hidden new features of CF8 including looking under the hood at PDF generation. Please indicate your attendance by email to [EMAIL PROTECTED], so we can guage numbers for catering. Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: VBA crosstab query --- coldfusion query
Hi Maureen, From the ms developer forums -: Two options, case or pivot (for sql 2005) Here is CASE solution: SELECT sDate, AVG(CASE WHEN res ='res1' THEN sCount END) as res1, AVG(CASE WHEN res ='res2' THEN sCount END) as res2, AVG(CASE WHEN res ='res3' THEN sCount END) as res3 FROM (SELECT sDate, res, sCount FROM myDATA) p WHERE res IN ('res1', 'res2', 'res3') GROUP BY sDate ORDER By Convert(DATETIME,'01'+sDate,13) PIVOT solution:(SQL Server 2005) SELECT sDate, res1, res2, res3 FROM (SELECT sDate, res, sCount FROM myDATA) p PIVOT (AVG(sCount) FOR res IN ([res1], [res2], [res3])) AS pvt ORDER By Convert(DATETIME,'01'+sDate,13) If you can provide the tables and columns in your access db then someone of the list may be able to write the sql code. Hth Rod Higgins WebDaemon www.webdaemon.com.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Greavesy Sent: Wednesday, 26 September 2007 12:06 PM To: cfaussie Subject: [cfaussie] VBA crosstab query --- coldfusion query Hello everyone! My name is Maureen and I have just recently joined this group and am developing coldfusion pages for our work intranet reporting site. A large majority of work will be developing pages connected to SQL server database. Currently the bulk of our datasources are MSAccess databases and we will be analysing these systems and developing cf online services. My very first question for you all is I am attempting to write a coldfusion query based on a vba crosstab query:- here it is in SQL view TRANSFORM Last(premium) AS LastOfpremium SELECT startCoverDate FROM TcalR_premiumPrivate GROUP BY startCoverDate PIVOT class Is there any easy and quick way to write coldfusion crosstab queries? Any help would be much appreciated. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: VBA crosstab query --- coldfusion query
No Maureen is moving from MS access to SQL, thus the question. It is hard to write the correct code though without knowing what the tables, columns and data types are. Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 26 September 2007 12:19 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: VBA crosstab query --- coldfusion query Rod He is using ACCESS I would have though that as long as the SQL drivers know what to do with the statement, he can pass in what ever he was doing in VBA Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Wednesday, 26 September 2007 12:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: VBA crosstab query --- coldfusion query Hi Maureen, From the ms developer forums -: Two options, case or pivot (for sql 2005) Here is CASE solution: SELECT sDate, AVG(CASE WHEN res ='res1' THEN sCount END) as res1, AVG(CASE WHEN res ='res2' THEN sCount END) as res2, AVG(CASE WHEN res ='res3' THEN sCount END) as res3 FROM (SELECT sDate, res, sCount FROM myDATA) p WHERE res IN ('res1', 'res2', 'res3') GROUP BY sDate ORDER By Convert(DATETIME,'01'+sDate,13) PIVOT solution:(SQL Server 2005) SELECT sDate, res1, res2, res3 FROM (SELECT sDate, res, sCount FROM myDATA) p PIVOT (AVG(sCount) FOR res IN ([res1], [res2], [res3])) AS pvt ORDER By Convert(DATETIME,'01'+sDate,13) If you can provide the tables and columns in your access db then someone of the list may be able to write the sql code. Hth Rod Higgins WebDaemon www.webdaemon.com.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Greavesy Sent: Wednesday, 26 September 2007 12:06 PM To: cfaussie Subject: [cfaussie] VBA crosstab query --- coldfusion query Hello everyone! My name is Maureen and I have just recently joined this group and am developing coldfusion pages for our work intranet reporting site. A large majority of work will be developing pages connected to SQL server database. Currently the bulk of our datasources are MSAccess databases and we will be analysing these systems and developing cf online services. My very first question for you all is I am attempting to write a coldfusion query based on a vba crosstab query:- here it is in SQL view TRANSFORM Last(premium) AS LastOfpremium SELECT startCoverDate FROM TcalR_premiumPrivate GROUP BY startCoverDate PIVOT class Is there any easy and quick way to write coldfusion crosstab queries? Any help would be much appreciated. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] BMUG Sept Meeting
Hi CFUGers, Tonight's BMUG meeting was well attended with 10 attendess in total. The meeting consisted of a an AIR presentation, a quick review of three of the AIR applications from the samples on the Adobe Labs site and then a brief demostration and code review of three ways to extend CF 7, - iText java pdf library; pdfStamper, pdfReader classes using the overContent, underContent functions to 'under' write and 'over' write content directly into pdf's - POI java library, writing excel directly and reading directly from different sheets within the excel file using cfc wrapper functions compared to using a proxyDB type ms access datasource - Using PS printers to convert Word documents to PDF on the fly. The meeting was well attended with two new members coming along. It has been decided to change the evening for the October meeting to Thursday the 4th of October. The first ever BMUG software raffle was won tonight by Greg Misdom who is currently working with Blacktown City Council. Well done Greg! The code snippets from tonight's meeting will be available for download from the bmug.org.au site within the next couple of days. There is an opening for a presentation for the October meeting. Anyone wishing to present please send through their expression of interest to [EMAIL PROTECTED] Hope to see more ppl come along for next month's meeting. The next scheduled software raflle is set for Mar 08 with raflle tickets available to all members from next month's meeting onwards. Cheers Rod Higgins BMUG Organiser. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] BMUG August Meeting
The second ever BMUG meeting will occur this Wednesday evening, so those of you living out West or in the Blue Mountains come along and spend some time networrking and discussing the new release of CF. Finger food and refreshments will be provided and maybe a lucky door prize or two. The meeting this month will be all things CF8 and we will be hooking up via the Sydney Group and others to the ANZ CF8 launch party. Please respond with your intention to attend so numbers can be gauged for catering. Hope to see all Western Sydney based ppl there - we need to beat last month's number of 12 rollups. http://maps.google.com.au/maps?ie=UTF8z=5ll=-25.335448,135.745076spn=31.154942,45.834961om=1 Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Reactor using oracle
I'm going through the joys or converting an MS SQL app onto an Oracle platform. The app uses MG, Reactor with Coldspring and I'm having a few issues setting up the config file for reactor to behave with oracle tables. Do I have to prefix tables in oracle using oracleuser.mytable, etc.? With the current config file reactor can not see the oracle tables. If so I can't seem to see where this is configured in the coldspring.xml file. tia. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Reactor using oracle
Hi Andrew, Running the app in development on 9i. Cheers. On 7/24/07, Andrew Scott [EMAIL PROTECTED] wrote: Rod, What version of Oracle? Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On Behalf Of *Rod Higgins *Sent:* Tuesday, 24 July 2007 5:56 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Reactor using oracle I'm going through the joys or converting an MS SQL app onto an Oracle platform. The app uses MG, Reactor with Coldspring and I'm having a few issues setting up the config file for reactor to behave with oracle tables. Do I have to prefix tables in oracle using oracleuser.mytable, etc.? With the current config file reactor can not see the oracle tables. If so I can't seem to see where this is configured in the coldspring.xml file. tia. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: open source time tracking app
cf_bmugplug wouldn't it be nice to run an air desktop app that talks back to a modified lighthouse pro application that records time on projects in seconds ... come to the BMUG meeting in either August or September (depending on what is happening on the August 8/8 cfug meeting .. interesting date) to see a prototype in action. /cf_bmugplug On 7/19/07, Mike Kear [EMAIL PROTECTED] wrote: Yes it's a Ray Camden app. And like all Ray Camden apps, it installs automaticaly, works first go, and does what it's advertised to do. And the price is right too. As you say, doesnt the guy ever sleep? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/19/07, Barry Beattie [EMAIL PROTECTED] wrote: Hey Mike... getting back to Lighthouse Pro... isn't that a Ray Camden (CF) app? does that guy ever get any sleep? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: open source time tracking app
Hi Andrew, We will look into it. The next bmug meeting is scheduled for 8/8 and there seems to be a *alot* of commotion around this date so the app demo may have to wait to Sept. depending on what unfolds ... but the good news is the prototype code will be completely open source. Cheers. On 7/25/07, Andrew Scott [EMAIL PROTECTED] wrote: Rod, You couldn't breeze or screencast it could you, and post a link here [EMAIL PROTECTED] Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On Behalf Of *Rod Higgins *Sent:* Tuesday, 24 July 2007 6:25 PM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Re: open source time tracking app cf_bmugplug wouldn't it be nice to run an air desktop app that talks back to a modified lighthouse pro application that records time on projects in seconds ... come to the BMUG meeting in either August or September (depending on what is happening on the August 8/8 cfug meeting .. interesting date) to see a prototype in action. /cf_bmugplug --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Reminder: Western Sydney CFUG meeting tonight
Your a bit late Mike ... Not sure why this is posted so late but please ignore it. The next meeting is scheduled for early August. On 7/9/07, Mike Kear [EMAIL PROTECTED] wrote: The first meeting of the CF User Group in Western Sydney is going to be held in Penrith tonight, starting at 6pm. I hope all of you who expressed interest in being in such a group will be able to make it. Also anyone who lives and/or works in the Western Sydney area who hasn't expresed interest so far, we'd love to see you. We're making it at 6pm so people who live out west but work in the CBD can make it too. Stop off in Penrith on your way home up the mountains. It's being held at the boardroom of Webdaemon - very nice comfortable offices - plenty of free parking behind the building - about 50 metres from the Penrith RSL Club. The address is: Level 1 374 High Street Penrith NSW, 2750 http://maps.google.com/maps?near=374+High+St,+Penrith,+NSW+2750,+Australia I hope we can get to see you there! -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Struct notation - whats wrong with this?
Hi Charlie, I must say your Hidden Gems in CF8 is a great way to wet ones appetite on CF8. I would also like to thank you on your work with the UGTV site - it really is a wonderful resource and I would recommend all having a look. Sorry all for the cross post, I'm having issues creating new posts - I must be banned .. :) Rgds Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Tuesday, 10 July 2007 1:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Struct notation - whats wrong with this? Mike, to your point about using square bracket notation not being in the docs, are you looking only at the Reference manual? Not everything is documented there, or it can be hard to find, with its primary focus on tags and functions. But I'd be surprised if it wasn't at least covered in the Developer's Guide (the 1100+ page guide that is often missed). It's nearly 11pm here in the US, so I'll leave it to others to find where it is documented, if interested. But I really doubt it's not documented at all. /charlie Member, Adobe Community Experts program www.carehart.org My latest blog entry: Still more CFEclipse Resources --Blogsigs.com, Link your own blog posts. http://www.blogsigs.com http://carehart.org/blog/client/index.cfm/2007/7/8/still_more_cfeclipse _res ources -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Monday, July 09, 2007 10:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Struct notation - whats wrong with this? Yes! thanks Paul, that did work indeed. Barry you shouldn't be at work without your CF head on. So the lesson to learn is: 1.You CAN have a struct element name that is only a numeral. 2.The square-bracket notation requires a dot after it if what follows is to be another element name 3. there is nothing in the docs about using square bracket notation in naming struct elements. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month Change this to: segment[#counter#].thispage = counter; segment[#counter#].nextpage = (counter + 1); segment[#counter#].content = #contentelement#; and it should work. Paul Haddon Technical Services Manager Formstar Print Technologies --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] First CFUG for Western Sydney
This email is a call for presenters for the first CFUG meeting in Western Sydney / Blue Mountains. We have set a date of Monday the 9th of July with a 6.00pm start, location details below. At this stage we have 9 confirmed developers attending with hopefully a few more roll ups. If you wish to attend please reply offline or email Mike Kear. The venue is our boardroom here in our offices which will hold about 25 ppl. Anyone out there keen on being the very first presenter for this new coldfusion user group? When -: Monday 9th July 2007, 6.00pm start Where -: Level 1 374 High St Penrith NSW What is provided -: Beer !! nibbles and maybe a lucky door prize or two. Again please email your intention to attend to make sure we provide enough beer and nibbles. Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Formal Testing (was: Hack ColdFusion Application)
Hi Chris, We employ a staff member to test every application before it is released. Most larger applications we develop run through a pilot program with a UAT document. The UAT usually incorporates functionality and usability and checks for the odd bug that escaped the developer But really it depends on the client and their budget. A lot of smaller ones are happy to test their own applications. Hth Rod Higgins T +61 2 8207 8916 M +61 2 410 684 609 E [EMAIL PROTECTED] W http://www.webdaemon.com.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Friday, 4 May 2007 1:38 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Formal Testing (was: Hack ColdFusion Application) On 5/2/07, Mike Kear [EMAIL PROTECTED] wrote: Isn't testing work worth the hire? Shouldnt they get paid regardless? Mike comments brings up an interesting thought: who is doing formal testing and employs testers (either full time or on a contract basis)? What I mean by formal testing is once the requirements and specifications are in place whilst the developers are coding, the testers are creating test cases/scenarios in readiness for the testing phase of the project. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Western Sydney User Group - anyone interested?
Yup we are interested. Count us in (x3 developers), that makes 4. I was interested last time this was raised about 3 years ago and can provide the venue if required. The conference room can hold about 20 ppl comfortably, wireless internet available. If enough interest is around we might spring for drinks and nibbles. Cheers Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Friday, 27 April 2007 3:45 PM To: cfaussie Subject: [cfaussie] Western Sydney User Group - anyone interested? Some time ago, I raised the thought of setting up a Western Sydney CF User Group, because i felt sure there were quite a few coldfusion developers west of Auburn who felt travelling in to what they mistakently call the Central Business District was a real hassle. There were several people at the time who indicated they would be interested in being involved in such a group. Well it's suddenly taken on a life of its own and I think I can be assured of a regular venue in Penrith, a hop and a skip from the railway station in the main High Street. If there's anyone who would like to be involved in a UserGroup can you please let me know by posting to this list or sending me a private email.It looks like it just might happen now. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: validating an ABN
Why bother making a comment like that when it adds no value whatsoever to the discussion? There are a multitude of reasons why a webservice may not either be allowed, be possible or even be preferred to be used. Thanks for the input Simon I've always wondered how an ABN was generated. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stanton Sent: Monday, 9 April 2007 8:16 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: validating an ABN How about using a webservice instead: http://www.abn.business.gov.au/ABRXMLSearch/ Why bother using an authoritative source when you can spend hours trying to reverse engineer the business rules and invent your own method of validation instead? On 4/9/07, Andrew Muller [EMAIL PROTECTED] wrote: On 09/04/07, Stephen M [EMAIL PROTECTED] wrote: So, has anyone got a Cold Fusion ABN validator they can throw me? I've found a PHP one, but no luck so far searching for one in CF. So far, what I've come up with is Len(ABN) eq 11 which is a bit like Blackadder and Baldrick's s rewrite of Dr. Johnson's dictionary, stuck on Aardvark --- Andrew Muller http://www.webqem.com linkedin: http://www.linkedin.com/pub/1/151/905 -- Mark Stanton Gruden Pty Ltd http://www.gruden.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF calling MS Fax COM
Hi Mike, Is it a cost per service arrangment? Our client wouldn't be interested if that is the case. They have a dedicated fax line in place and wish to use it for this internal app server. Also the information is confidential in nature (I know, I know, so why fax u ask??) so there want nothing sent across cyber space. They already have a dedicated fax server in place for their internal network but it has a very flawed COM API so I went down the MS fax server path to see if it was easier to talk to. I'm in the process of writing some java cfx tags that use the java rFax api. I'm testing some sample code now that faxes pdf's with better results. I'll try and rewrite the cfx tags as cfc's that call the api directly - eventually - for easier code maintenance. Cheers. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 4 April 2007 5:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF calling MS Fax COM I use an external service and have absolutely no problems at all - its as simple as sending an email. Why do you need to use MSFax? You can send coversheets as well as word docs or PDFs as faxes if you want. it's a piece of cake, and fast. And totally scalable up to thousands of pages a minute. If you're interested in that approach let me know. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/4/07, Nathan Drury [EMAIL PROTECTED] wrote: Rod What error message do you get back? I'm having difficulties with COM at the moment too and will post about them here. On Apr 3, 5:19 pm, rod higgins [EMAIL PROTECTED] wrote: Hi, I'm having a problem talking to the MS Fax service object. My code below fails on the last line while trying to send the faxdocument. Anyone used thisCOM objectbefore? ! script to test faxing a pdf document via Microsoft fax -- cfset path = GetDirectoryFromPath(GetBaseTemplatePath()) cfset faxDocumentObjRef = cfset objFaxServer = createobject(COM, FaxServer.FaxServer) cfset objFaxDocument = objFaxServer.CreateDocument(#path#sample.pdf) cfset objFaxDocument.FaxNumber(mynumber) cfset objFaxDocument.RecipientName(Tom Jones) cfset objFaxDocument.FileName(#path#sample.pdf) cfdump var=#objFaxServer# cfdump var=#objFaxDocument# cfset objFaxDocumentRtnVal = objFaxDocument.Send() Thanks in advance. -- --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Date format
Trying to create a date of 0001/01/01 is alot of fun in CF - I cant seem to create one using createdate(). I imagine Tom you will have to use something like the code below to generate a reference date to compare the integers against. cfset mydate = createdate(1962,2,2) cfset refdate = dateadd(d, -716640, mydate) cfoutput #dateformat(refdate, '/mm/dd')# /cfoutput hth Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: WDDX2CFML
What SQL db are you using? On Apr 3, 7:04 pm, Rei [EMAIL PROTECTED] wrote: Evening all, I am trying to retrieve WDDX packet stored in an ntext field of table x in my trusty SQL db. The charLength of said WDDX packet is approx 7. CFWDDX ACTION=WDDX2CFML INPUT=#bigPacket# OUTPUT=xStruct But...alas! When I return this data, I only get 32000 characters, and the missing 38000 characters includes the closing tag of the WDDX packet (amongst other valuable information) so I get a parse error. So I have two questions for knowledgeable folks. At what point are the characters discarded? Any suggestions for a suitable workaround? Many thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Date format
I can't see a bug at all. The dateformat function simply diplays the last two digits of the year of the date as it should. It the date is stored as 9.4.3866 you would expect a display of 9.4.66 wouldn't you? What I want to know is why #dateformat(1,d.m.)# is 31/12/1899 and not 1/1/900 ?? On Apr 4, 11:07 am, Chris Velevitch [EMAIL PROTECTED] wrote: On 4/4/07, Tom MacKean [EMAIL PROTECTED] wrote: My confusion initially was that #dateformat(718167,d.m.)# gives 9.4.3866 which didn't look right at all so I thought is wasn't working. The Looks like a bug in the dateformat function. Perhaps you could raise an issue with Adobe about it. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Date format
My point exactly excel parses the date from 1/1/1900, so should CF. The date stored in excel is the same as CF, for Tom's example it would be stored internally as 9/4/3866 regardless of how you display it. Half way down the article; In most modern programming environments, dates are stored as real numbers. The integer part of the number is the number of days since some agreed-upon date in the past, called the epoch. In Excel, today's date, June 16, 2006, is stored as 38884, counting days where January 1st, 1900 is 1. So why does CF regard the integer 1 as 31/12/1899? Do others experience this or is it just a dodgy version of CF running on my localhost? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 4 April 2007 12:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Date format suggest you refer back to Karen's previous entry and then follow up the joelonsoftware link, about halfway donn the joelonsoftware post. it might help On 4/4/07, rod higgins [EMAIL PROTECTED] wrote: I can't see a bug at all. The dateformat function simply diplays the last two digits of the year of the date as it should. It the date is stored as 9.4.3866 you would expect a display of 9.4.66 wouldn't you? What I want to know is why #dateformat(1,d.m.)# is 31/12/1899 and not 1/1/900 ?? On Apr 4, 11:07 am, Chris Velevitch [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: On 4/4/07, Tom MacKean [EMAIL PROTECTED] wrote: My confusion initially was that #dateformat(718167,d.m.)# gives 9.4.3866 which didn't look right at all so I thought is wasn't working. The Looks like a bug in the dateformat function. Perhaps you could raise an issue with Adobe about it. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Affordable Flex Training
I disagree I think certification is looked upon quite well by employers and is well worth the effort. My2c. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 4 April 2007 2:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training Well the training is not worthless, very high quality and beneficial. But the certificate is worthless in the sense that employers seem to hold no value to it, I'm sure most here with CF certifications might agree. Regards Dale Fraser http://dale.fraser.id.au/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Muller Sent: Wednesday, 4 April 2007 2:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training Dale I'm curious as to how the certified training is almost worthless. Andrew On 04/04/07, Dale Fraser [EMAIL PROTECTED] wrote: Considering the certificate training will cost you 5 times as much and is almost worthless I think it's a good deal. PS: How many do you need to make a trip cost effective. Regards Dale Fraser --- Andrew Muller http://www.webqem.com linkedin: http://www.linkedin.com/pub/1/151/905 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Affordable Flex Training
Actually most recently an employer and yes if I had to choose between a certified candidate and one that wasn't I would definitely go with a certified candidate. Some of our clients prefer developers that are certified and it adds value to any firm to say projects are developed by certified professionals. There are ad's on seek that list certification as a desirable or even an essential requirement for CF developers. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 4 April 2007 3:42 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training Are you an employer who looks upon it favourably or an employee who has had it looked upon favourable? No one has ever asked to see my certificates and I've never asked to see any. Regards Dale Fraser http://dale.fraser.id.au/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Wednesday, 4 April 2007 3:37 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training I disagree I think certification is looked upon quite well by employers and is well worth the effort. My2c. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 4 April 2007 2:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training Well the training is not worthless, very high quality and beneficial. But the certificate is worthless in the sense that employers seem to hold no value to it, I'm sure most here with CF certifications might agree. Regards Dale Fraser http://dale.fraser.id.au/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Muller Sent: Wednesday, 4 April 2007 2:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Affordable Flex Training Dale I'm curious as to how the certified training is almost worthless. Andrew On 04/04/07, Dale Fraser [EMAIL PROTECTED] wrote: Considering the certificate training will cost you 5 times as much and is almost worthless I think it's a good deal. PS: How many do you need to make a trip cost effective. Regards Dale Fraser --- Andrew Muller http://www.webqem.com linkedin: http://www.linkedin.com/pub/1/151/905 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to send out undelivered cfmails?
It simply might mean the CF server can not connect to the mail server, the email address might be completely valid. If CF runs through the list of configured mail servers and can't connect to any of them it will shift the mail to the undelivered directory. my 2c. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 27 March 2007 5:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? It doesn't matter what you do these emails are not deliverable, that means the email address is incorrect in someway. On 3/27/07, George Lu [EMAIL PROTECTED] wrote: I've done that. Here is one of the errors: Moved undelivered mail: Mail37806.cfmail to C:\CFusionMX7/Mail/Undelivr directory. Steve, how do I do the auto schedule task? Sorry I'm quite dump about this. On 27/03/07, Joel [EMAIL PROTECTED] wrote: check the CF error logs (mailsent.log i think) - Original Message - From: George Lu mailto:[EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, March 27, 2007 4:46 PM Subject: [cfaussie] Re: How to send out undelivered cfmails? I've dragged those mails to the spool directory but they've gone back to undelivered directory again. On 27/03/07, Andrew Scott mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: If they are sitting in there, they are not deliverable at all, you can try dragging them to the spool directory if you want to try sending them again. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. http://www.aegeon.com.au/ www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Tuesday, 27 March 2007 4:28 PM To: CFAussie Mailing List Subject: [cfaussie] How to send out undelivered cfmails? Our mail server was down and now it's up again. There are 5 emails sitting at C:\CFusionMX7\Mail\Undelivr folder. Is there any way to send out these emails? Thanks, George Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to send out undelivered cfmails?
Sorry forgot the URL http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 27 March 2007 5:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? It doesn't matter what you do these emails are not deliverable, that means the email address is incorrect in someway. On 3/27/07, George Lu [EMAIL PROTECTED] wrote: I've done that. Here is one of the errors: Moved undelivered mail: Mail37806.cfmail to C:\CFusionMX7/Mail/Undelivr directory. Steve, how do I do the auto schedule task? Sorry I'm quite dump about this. On 27/03/07, Joel [EMAIL PROTECTED] wrote: check the CF error logs (mailsent.log i think) - Original Message - From: George Lu mailto:[EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, March 27, 2007 4:46 PM Subject: [cfaussie] Re: How to send out undelivered cfmails? I've dragged those mails to the spool directory but they've gone back to undelivered directory again. On 27/03/07, Andrew Scott mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: If they are sitting in there, they are not deliverable at all, you can try dragging them to the spool directory if you want to try sending them again. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. http://www.aegeon.com.au/ www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Tuesday, 27 March 2007 4:28 PM To: CFAussie Mailing List Subject: [cfaussie] How to send out undelivered cfmails? Our mail server was down and now it's up again. There are 5 emails sitting at C:\CFusionMX7\Mail\Undelivr folder. Is there any way to send out these emails? Thanks, George Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to send out undelivered cfmails?
A simple script like this should do it George. You will need to set the path for your spool directory and undelivered driectory on your mail server. cfset undevpath=C:\CFusionMX7\Mail\Undelivr cfset spoolpath=E:\CFusionMX7\Mail\Spool cfdirectory action=LIST directory=#undevpath# name=file_list filter=*.cfmail sort=dateLastModified cfoutput query=file_list cffile action=COPY source=#undevpath#\#name# destination=#spoolpath#\#name# /cfoutput Is this what you were looking for? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Wednesday, 28 March 2007 10:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? Thanks for the explanation. My problem is how to deliver these undelivered mails to the mail server again. On 27/03/07, Rod Higgins mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Sorry forgot the URL http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html -Original Message- From: cfaussie@googlegroups.com [mailto: mailto:cfaussie@googlegroups.com [EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 27 March 2007 5:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? It doesn't matter what you do these emails are not deliverable, that means the email address is incorrect in someway. On 3/27/07, George Lu [EMAIL PROTECTED] wrote: I've done that. Here is one of the errors: Moved undelivered mail: Mail37806.cfmail to C:\CFusionMX7/Mail/Undelivr directory. Steve, how do I do the auto schedule task? Sorry I'm quite dump about this. On 27/03/07, Joel [EMAIL PROTECTED] wrote: check the CF error logs (mailsent.log i think) - Original Message - From: George Lu mailto:[EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, March 27, 2007 4:46 PM Subject: [cfaussie] Re: How to send out undelivered cfmails? I've dragged those mails to the spool directory but they've gone back to undelivered directory again. On 27/03/07, Andrew Scott mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: If they are sitting in there, they are not deliverable at all, you can try dragging them to the spool directory if you want to try sending them again. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. http://www.aegeon.com.au/ www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Tuesday, 27 March 2007 4:28 PM To: CFAussie Mailing List Subject: [cfaussie] How to send out undelivered cfmails? Our mail server was down and now it's up again. There are 5 emails sitting at C:\CFusionMX7\Mail\Undelivr folder. Is there any way to send out these emails? Thanks, George Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to send out undelivered cfmails?
yeah I should of added in the code to delete the file as well or used copy I had not tested the code it was written in the email client on the fly. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 28 March 2007 10:57 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? i wouldnt use COPY, rather use MOVE. you dont want duplicates going back into the undelivered folder _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Wednesday, 28 March 2007 10:25 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? A simple script like this should do it George. You will need to set the path for your spool directory and undelivered driectory on your mail server. cfset undevpath=C:\CFusionMX7\Mail\Undelivr cfset spoolpath=E:\CFusionMX7\Mail\Spool cfdirectory action=LIST directory=#undevpath# name=file_list filter=*.cfmail sort=dateLastModified cfoutput query=file_list cffile action=COPY source=#undevpath#\#name# destination=#spoolpath#\#name# /cfoutput Is this what you were looking for? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Wednesday, 28 March 2007 10:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? Thanks for the explanation. My problem is how to deliver these undelivered mails to the mail server again. On 27/03/07, Rod Higgins mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Sorry forgot the URL http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html -Original Message- From: cfaussie@googlegroups.com [mailto: mailto:cfaussie@googlegroups.com [EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 27 March 2007 5:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: How to send out undelivered cfmails? It doesn't matter what you do these emails are not deliverable, that means the email address is incorrect in someway. On 3/27/07, George Lu [EMAIL PROTECTED] wrote: I've done that. Here is one of the errors: Moved undelivered mail: Mail37806.cfmail to C:\CFusionMX7/Mail/Undelivr directory. Steve, how do I do the auto schedule task? Sorry I'm quite dump about this. On 27/03/07, Joel [EMAIL PROTECTED] wrote: check the CF error logs (mailsent.log i think) - Original Message - From: George Lu mailto:[EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, March 27, 2007 4:46 PM Subject: [cfaussie] Re: How to send out undelivered cfmails? I've dragged those mails to the spool directory but they've gone back to undelivered directory again. On 27/03/07, Andrew Scott mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: If they are sitting in there, they are not deliverable at all, you can try dragging them to the spool directory if you want to try sending them again. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. http://www.aegeon.com.au/ www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Tuesday, 27 March 2007 4:28 PM To: CFAussie Mailing List Subject: [cfaussie] How to send out undelivered cfmails? Our mail server was down and now it's up again. There are 5 emails sitting at C:\CFusionMX7\Mail\Undelivr folder. Is there any way to send out these emails? Thanks, George Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to send out undelivered cfmails?
What was recorded in the mail logs? Can you verify the connection to the mail server from within cf admin? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: SOT: Local domain names
This has to do with coldfusion how? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of mrEscher Sent: Tuesday, 20 March 2007 1:50 PM To: cfaussie Subject: [cfaussie] Re: SOT: Local domain names Heh, I'm back on cfaussie after a couple of years hiatus - last I read it was back it was on the demon server - came back to search for some flex advice. Andrew, you gotta read what you've been sent - I don't think that Tom was originally replying to you at all, nor did you clarify when he asked before flaming him. On the other hand, your Im SMRTer than yoo random acronym-laden rant based on terms or homonyms you haven't understood is the funniest thing I've read since I left - I missed that! Keep it up. WYSIWYG! While we're (VASTLY) off topic, Scott Barnes is working for Microsoft now! wow, kudos dude. - McE --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT: SQL Server Schema
SELECT T.TABLE_NAME AS [Table], C.COLUMN_NAME AS [Column], C.IS_NULLABLE AS [Nulls], C.DATA_TYPE AS [Type] FROM INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C ON T.TABLE_NAME = C.TABLE_NAME WHERE T.TABLE_NAME NOT LIKE 'sys%' AND T.TABLE_NAME 'dtproperties' AND T.TABLE_SCHEMA 'INFORMATION_SCHEMA' ORDER BY T.TABLE_NAME, C.ORDINAL_POSITION FOR XML AUTO hth Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Monday, 19 March 2007 3:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT: SQL Server Schema Just a quick one from all you Microsoft Guru's. Can I get the database schema out of a SQL Server 2000 database via XML. What I want to do is build a data dictionary of an existing data and if I could suck the schema out and the manipulate it in CF I could get an almost automated data dictionary. Brian Knott --- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT: SQL Server Schema
You can enhance the SQL as needed, I grabbed the snippet below of a google search and added the FOR XML clause. You using XSLT to transform the XML into XHTML? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Monday, 19 March 2007 3:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: OT: SQL Server Schema Thanks Rod. Thats a great start. Brian _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Monday, 19 March 2007 2:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: OT: SQL Server Schema SELECT T.TABLE_NAME AS [Table], C.COLUMN_NAME AS [Column], C.IS_NULLABLE AS [Nulls], C.DATA_TYPE AS [Type] FROM INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C ON T.TABLE_NAME = C.TABLE_NAME WHERE T.TABLE_NAME NOT LIKE 'sys%' AND T.TABLE_NAME 'dtproperties' AND T.TABLE_SCHEMA 'INFORMATION_SCHEMA' ORDER BY T.TABLE_NAME, C.ORDINAL_POSITION FOR XML AUTO hth Rod -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Monday, 19 March 2007 3:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT: SQL Server Schema Just a quick one from all you Microsoft Guru's. Can I get the database schema out of a SQL Server 2000 database via XML. What I want to do is build a data dictionary of an existing data and if I could suck the schema out and the manipulate it in CF I could get an almost automated data dictionary. Brian Knott --- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Java Output streams into CF vars
Can you post your full code that you have put together to now? On Mar 7, 3:55 pm, Duncan [EMAIL PROTECTED] wrote: Thanks Andrew, I can see what this does, but I dont understand it all enough (and the differences between your code and mine) to mash it into what I need. So I have managed to get to this point: pageOut = getPageContext().getResponse().getOutputStream(); out = pageOut.write(f.Content[1], 0, len(f.Content[1])); however this prints the content of the field at the point where this line lives in the page. It doesnt assign it to the variable out. At least now its not resetting the output and its carrying through to include the header and footer. How is it that this is not putting the stream into the out variable? On 3/7/07, Andrew Scott [EMAIL PROTECTED] wrote: Duncan, Visitwww.andyscott.id.auan have a look at my proof of concept, it does what you're asking for with the variable. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:+613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Wednesday, 7 March 2007 12:07 PM To: cfaussie Subject: [cfaussie] Java Output streams into CF vars I am working with cfdiff, and specifcally the svnbrowser element. When viewing a specific revision of a file the code pushes the file contents directly from a Java out put stream into the browser. http://cfdiff.googlecode.com/svn/trunk/svn.cfmcheck out lines 101 - 121. I have tried with no degree of luck to get the output into a cf variable. My end goal here is to be able to put it in a text area and have code colouring on it (see riaforge for an example http://ajaxcfc.riaforge.org/index.cfm?event=page.svnviewpath=%2Ftrun... efile=ajax%2Ecfc ), this would then leave the user the choice to download the file (currently this is what happens) or view it and have other options. The best I have so far is a cfdump of the structure - it contains the following: Author: duncan Content: binary: 1043210310610410632103104321061041310131010010210310010210351505050131013101 0010210310010210351515113101310100102103100102103525252131013101001021033910 810710010210310610732100102103 date : {ts '2007-03-02 05:10:44'}, kind: file, message: NULL, path: / trunk/scribble.cfm, revision: 5, size: 71, url: /trunk/scribble.cfm FYI the content of scribble.cfm is: [code] h gjhj gh jh dfgdfg3222 dfgdfg333 dfgdfg444 dfg'lkdfgjk dfg [/code] Now I have tried binaryDecode() and binaryEncode() but this seems to not do the trick, its a completely different form of binary! Can anyone point me in the direction of getting this binary java stuff into a CF var after being converted? -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] cf_combo
Anyone know of a reliable cross browser combo box ui component? No flash or ajax just simple js will be fine (ajax renders too slowly for large lists). Needs to be the same as a VB type combobox, single input box with autocomplete and a simple drop down list filtered by the characters typed in. TIA --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Strange calculation behavior on CF 7.02
If you use the java class and methods that handle these types of numbers I don't see the problem?? cfloop from=1 to=1000 index=i cfset diff = CreateObject(Java, java.math.BigDecimal).init(0.1) cfset a = CreateObject(Java, java.math.BigDecimal).init(RandRange(100,1)) cfset b = CreateObject(Java, java.math.BigDecimal).init(a*2) cfset c = CreateObject(Java, java.math.BigDecimal).init(val(a)) cfset c = c.add(diff) cfset d = a.subtract(b).add(c) cfoutput#a#-#b#+#c# = #d#br //cfoutput /cfloop It seems CF is using some sort of toString() value during the calculation at some stage?? hth Rod On Feb 20, 12:04 pm, Gareth Edwards [EMAIL PROTECTED] wrote: If you are running coldfusion 7.02, or maybe 7.01 or 7.0? (don't know) Run this script below, and tell me if you get the same results for each line. The way I see it, d should equal 0.1 on every row. But this isn't the case. Is this a bug introduced by Coldfusion 7.02? cfset a = 0 cfset b = 0 cfset c = 0 cfloop from=1 to=1000 index=i cfset a = RandRange(1,2) cfset b = a*2 cfset c = #ListFirst(Trim(a),.)#.00 cfset c = c + 0.1 cfset d = a - val(b) + val(c) cfoutput#d#br //cfoutput /cfloop Cheers Gareth. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: [OT] Calculate distance with long/lat
Wouldn't the lat and long be the same for both? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 15 November 2006 12:31 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: [OT] Calculate distance with long/lat Taco how are you taking account of the fact that some places can have two postcodes? For instance, in NSW, St Leonards is postcode 2065 but PO Boxes in St Leonards are postcode 1590 Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: SQL question: conditional updating tables across databases
Insert into dbTwo.Users Select * From dbOne.Users Where firstname + lastname not in (select firstname + lastname from dbTwo.Users) Or something like it. Hth. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Tuesday, 7 November 2006 11:43 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL question: conditional updating tables across databases It'll take me a few minutes to set up test data but I just want to check first: AFAIK, you can't insert into a table you're querying within the same SQLstatement. IIRC, the table gets locked for either read or write - not both. I'll have to fess up. the only time I use SELECT INTO is for temp tables or fresh (empty) tables transferring data from others (ie: not for exiting tables). Otherwise, I use INSERT INTO SELECT FROM but with the above locking limitations. but yeah Ryan, that's the kind of idea I was aiming for: get rid of the loop and let the database to do more of the work. thanx barry.b On 11/7/06, Ryan Sabir [EMAIL PROTECTED] wrote: Would something like this work? SELECT * INTO dbTwo.users FROM dbOne.users WHERE dbOne.users.PK NOT IN (SELECT PK FROM dbTwo.users) AND (where clause) -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Tuesday, 7 November 2006 11:24 AM To: cfaussie@googlegroups.com Subject: [cfaussie] SQL question: conditional updating tables across databases Hi all I've got some existing logic I have to adapt to make it work in a bigger outer loop. the current logic works fine for single request but just won't scale when pushed. pseudocode qCurrentUser = query for CurrentUsers in dbOne.users (where clause) for each user if not CurrentUser exists in dbTwo.users (query) add CurrentUser to dbTwo.users (insert) end if next /pseudocode NOTE 1: dbOne.users and dbTwo.users can have many tens of thousands of records. NOTE 2: it doesn't have to be a CF solution. I can move the logic to a Sproc on the second database (T-SQL: SQLServer2000) NOTE 3: qCurrentUser will change on the bigger outer loop (not shown) I've thought about: 1) getting rid of looping over the query by putting all the latest dbTwo.users into a temp table and then using a INSERT INTO .. SELECT FROM.. with the SELECT's where being the query for CurrentUsers with a AND NOT IN with the temp table. the temp table is because you can't query and insert on the same table at the same time/same piece of SQL. 2) dumping the current contents of dbTwo.users into memory as cached data and keep the loop and current logic, just finding if they exist by querying memory, not the database. saves a database connection 3) like (2) except converting the data in memory into a struct of structs and do a not structKeyExists() before insert. but I can't help thinking the best way is avoiding loops in code althogether and rely on the database to do the work. and I'm wondering if the bigger outer loop (not shown) can help here when it comes to caching dbTwo.users data: treat the whole thing as a job lot for caching BUT the dbOne.users query would still need to change. Update Cached data and the underlying table. any other ideas? any opinions? thanx barry.b cfloop query=qCurrentUser cfquery name=qCheckInQuiz datasource=#application.QuiztoolDSN# Select User_ID from tbl_People where User_ID = '#qCurrentUser.USERNAME#' /cfquery cfif qCheckStudInQuiz.RecordCount eq 0 !--- There is no record for this person so we need to add them --- cfquery name=iAddUser datasource=#application.QuiztoolDSN# Insert into tbl_People (User_ID,FirstName,LastName,Email) values ( '#qCurrentUser.USERNAME#' ,'#qCurrentUser.PREF_NAME#' ,'#qCurrentUser.SURNAME#' ,'#qCurrentUser.EMAIL#' ) /cfquery /cfif /cfloop NOTE: qCurrentUser comes from a different database. While joining the two databases is common for queries and INSERT INTO .. SELECT FROM.., I'm not sure how far I can push it for a solution. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How to create a popup window after some Cf processing
Froman image / button onclick=window.open('mylocation.cfm'); ?? Or on a new page body onload=window.open('mylocation.cfm'); is that the sort of thing your looking for? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Monday, 23 October 2006 9:04 AM To: cfaussie@googlegroups.com Subject: [cfaussie] How to create a popup window after some Cf processing I know how to create a popup window from a button or a link, but i want to create a preview window for my CMS - when the user clicks Preview, there has to be some processing done on the form data, and only after it's successfully processed, does the popup window appear, incorporating the processed data. What i'm kind of looking for is a CFLOCATION kind of action, with a popup instead of taking the current window to the new location. that way the CFLOCATION will popup the preview page, while still keeping the existing page with the form intact. Anyone know how to do that? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Image Manipulation
Title: Message What are ppl using to generation images on the fly? I have an old app using the batik api to create images from SVG content using the org.apache.batik.apps.rasterizer.SVGConverter class. What are ppl currently using and what are the pros and cons with each approach? tia Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Image Manipulation
Im almost sure Adobe will end up using some of the common components from FOP and Batik aka the XMLGraphics components for CF 8 imaging. Looking at Alagad I'm stunned to see a licensing cost of $75 USD per server for some wrappers around the java Graphics2D api ... I must be in the wrong business. http://xmlgraphics.apache.org/commons/ Mark do you have some generic imaging code you want to share or colaborate on? Maybe a java process to generate images from html content via an open source html renderer? How far away is CF8 ... ? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 12 October 2006 2:16 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Image Manipulation Hi Rod, I use ImageCR http://efflare.com/products/cfx_imagecr/ I gave alagad a try but imageCR is about 8 times faster.. Though I do like alagad Being written in java.. (and is free) Im gagging to see what adobe do with image manilpulation functionality in CF8.. Cheers, Adam From: Rod Higgins [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 October 2006 12:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Image Manipulation What are ppl using to generation images on the fly? I have an old app using the batik api to create images from SVG content using the org.apache.batik.apps.rasterizer.SVGConverter class. What are ppl currently using and what are the pros and cons with each approach? tia Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Image Manipulation
Yeah no, not image resizing, manipulating as such butcreating completely new images from text, shapes, background colours etc. I was thinking ofcreating a component that converted html content into an image which would be nice and simple to use and I might find other uses for it in the future thus the term generic. I'm currently converting svg into jpg's using batik but wanted something more multi purpose, more 'generic'. A direct html to image convertor using java is what I would like to get going wrapped up in a simple easy to use cfc.The hard part is finding a java html renderer that can do more then java's basicHTML. Jazilla is buggy, I can't find the source code / api documentationfor HotJava, etc. but I'm still looking. Have you done something similiar before? On 10/12/06, Mark Mandel [EMAIL PROTECTED] wrote: In all honestly, I'm quite comfortable with Java that I can buildpretty much anything I need out of it... it's 'Generic' for me as it is.Here are some examples of doing resizing of jpegs -http://www.compoundtheory.com/?action="">Although nowadays I would probably do this via javax.imageio(http://java.sun.com/j2se/1.4.2/docs/api/javax/imageio/package-summary.html)rather than go directly to the jpeg encoder / decoder. I suppose its a question of what you need?I'm sure there are some Javalibs out there that already do what youmay want, no?MarkOn 10/12/06, Rod Higgins [EMAIL PROTECTED] wrote: Im almost sure Adobe will end up using some of the common components from FOP and Batik aka the XMLGraphics components for CF 8 imaging. Looking at Alagad I'm stunned to see a licensing cost of $75 USD per server for some wrappers around the java Graphics2D api ... I must be in the wrong business. http://xmlgraphics.apache.org/commons/ Mark do you have some generic imaging code you want to share or colaborate on? Maybe a java process to generate images from html content via an open source html renderer? How far away is CF8 ... ?--E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Mass mailing with coldfusion
Maybe separate the processes into two different scripts? One to generate the PDF and write to disk the other to email and remove from disk? Maybe set up a batch process - ie group the emails into batches of 500 or so? Creating a lot of pdf's does chew up memory. The only other thing is maybe send a link on the email instead of the pdf file itself to reduce the bandwidth hit when emailing? hth Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: equivalent to 'does not contain' in SQL
select * from dbTable where CustomerID not like '%bn%' --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: equivalent to 'does not contain' in SQL
sorry missed the first two characters bit ... select * from dbTable where CustomerID not like 'bn%' or select * from dbTable where left(CustomerID, 2) 'bn' --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: equivalent to 'does not contain' in SQL
Firstly if the SQL platform is pre 2005 the service is hardly built in. Secondly if the column is indexed and the like statement starts with a character not a wildcard the index will be used. Why will this lead to a meltdown? If a wildcard (underscore etc) is the first character a full table scan occurs and can cause performance issues, but this is not the case in the example above - a like statement is perfectly acceptable. If the platform is SQL 2000 or earlier there is a significant overhead when implementing the Search Service as the article states plus the issues if you need to port the database and need to reconfigure the full text catalog. Besides if the application sits on a shared hosting service you will have little chance of setting up or maintaining catalogs. As with every development problem the solution needs to based on the tools / environment available. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Cf knowledgeTree
Title: Message Hi, Is there anything in open source written in coldfusion that can compare to KnowledgeTree which is written mostly in php? Basically looking for a document management system other then farcry that is open source which can be built upon. TIA Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] cf knowledgetree = ??
Hi, Is there anything in open source written in coldfusion that can compare to KnowledgeTree which is written mostly in php? Basically looking for a document management system other then farcry that is open source which can be built upon. Anyone? TIA Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: decimal places
Title: Message numberformat(mynumber, '9.999') hth Rod -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKeanSent: Monday, 18 September 2006 11:43 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] decimal places Hi List, How do I round a number to a certain number of decimal places (in this case three). e.g. . should become .667 and .1 should become .100 I can't seem to find a function that does it. Thanks, Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Multiple calls of the same page
CFQUERY datasource=#DSN# name=SESSION.SECTOR SELECT SB_SECTOR_ID, SB_SECTOR_DESC FROM SB_SECTOR ORDER BY SB_SECTOR_ID /CFQUERY cfoutput query=SESSION.SECTOR cfset FORM.EXTRACT_DATE_TO = '01-jan-1990' cfset FORM.SB_SECTOR_ID = SB_SECTOR_ID !--- Run program for each sector --- Startting #SB_SECTOR_DESC# br cfflush cfinclude template=sbmt215_act.cfm Completed #SB_SECTOR_DESC# br cfflush /cfoutput Doesn't work ?? I know cfflush likes to cause problems with cookie's, cflocation, etc but I didn't think there was a problem with cfoutput ...?? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, August 31, 2006 4:08 PM Subject: [cfaussie] Multiple calls of the same page Nope, that does not work. The value of the attribute query, which is currently SESSION.SECTOR, is invalid. [EMAIL PROTECTED] 31/08/2006 3:52:02 pm CFQUERY datasource=#DSN# name=SESSION.SECTOR ?? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, August 31, 2006 3:44 PM Subject: [cfaussie] Multiple calls of the same page Hi, I want to call a certain page (in a cf schedule) from within a cfoutput query= so it runs a number of times. This page is an action page that has form info posted to it and runs for quite a long while. Essentially I would want to set some form variables based on the query and include (or by some other method run ) the page. The problem is that once the included page has executed once, the original query no longer exists. (or so it seems) eg CFQUERY datasource=#DSN# name=SECTOR SELECT SB_SECTOR_ID, SB_SECTOR_DESC FROM SB_SECTOR ORDER BY SB_SECTOR_ID /CFQUERY cfoutput query=SECTOR cfset FORM.EXTRACT_DATE_TO = '01-jan-1990' cfset FORM.SB_SECTOR_ID = sector.SB_SECTOR_ID !--- Run program for each sector --- Startting #SECTOR.SB_SECTOR_DESC# br cfflush cfinclude template=sbmt215_act.cfm Completed #SECTOR.SB_SECTOR_DESC# br cfflush /cfoutput The error is Element SB_SECTOR_ID is undefined in SECTOR. There are only 6 records in the sector query, so I could, hard code it all, but I would prefer not to. Any advice? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Multiple calls of the same page
CFQUERY datasource=#DSN# name=SESSION.SECTOR ?? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, August 31, 2006 3:44 PM Subject: [cfaussie] Multiple calls of the same page Hi, I want to call a certain page (in a cf schedule) from within a cfoutput query= so it runs a number of times. This page is an action page that has form info posted to it and runs for quite a long while. Essentially I would want to set some form variables based on the query and include (or by some other method run ) the page. The problem is that once the included page has executed once, the original query no longer exists. (or so it seems) eg CFQUERY datasource=#DSN# name=SECTOR SELECT SB_SECTOR_ID, SB_SECTOR_DESC FROM SB_SECTOR ORDER BY SB_SECTOR_ID /CFQUERY cfoutput query=SECTOR cfset FORM.EXTRACT_DATE_TO = '01-jan-1990' cfset FORM.SB_SECTOR_ID = sector.SB_SECTOR_ID !--- Run program for each sector --- Startting #SECTOR.SB_SECTOR_DESC# br cfflush cfinclude template=sbmt215_act.cfm Completed #SECTOR.SB_SECTOR_DESC# br cfflush /cfoutput The error is Element SB_SECTOR_ID is undefined in SECTOR. There are only 6 records in the sector query, so I could, hard code it all, but I would prefer not to. Any advice? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
No sorry, my point was Java is a little different to .Net and CF as is php. Java code is open you can do what ever you like with it even rewrite the core code in each release if you wish. CF and .Net are not open at all so it's strange that you included Java in with CF and .Net. my .02 Name the company behind PHP. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Wednesday, 30 August 2006 11:01 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Why buy into CF? No php? Hmm ... - Original Message - From: Dale Fraser [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Wednesday, August 30, 2006 10:46 AM Subject: [cfaussie] Re: Why buy into CF? There are lots of reasons. It doesn't just give you web stuff it gives you a lot more, like PDF, report writing, Flash / Flex hooks It leverages the power of Java without the complexity. Compared to pulling in lots of different OS / Free solutions to achieve the same result, you are better off with CF. Are these OS options going to be supported long term. Can you find developers who now all these little technologies and can work for you. Were is the support / training for these products. Most likely some of these OS options will grow up and be contenders, but personally I wouldn't be jumping on any platform that wasn't provided by a main stream player. Which in my opinion leaves only three options. 1. Adobe - Coldfusion / Flex 2. Microsoft - .NET 3. Sun - Java Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Schultheiss Sent: Wednesday, 30 August 2006 10:36 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Why buy into CF? Personally I havent got down with the RoR yet, so I'm not familiar with the ruby language. In terms of a Flex/CF setup there are a lot of benefits. Basically you got the weight of Adobe pushing this combination to enable quick deployment of apps. That includes documentation, examples, engineer feedback, new updates. That being said you must pay. I think I'll have to build a Flex/RoR app first before making an assessment. Regards, Bjorn Schultheiss Senior Flash Developer QDC Technologies -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 30 August 2006 10:10 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Why buy into CF? please forgive me if this comes across as trolling but I'm running out of ammo here in trying to keep the CF flag flying here's the question: Why Buy into CF? because of rapid development? - NOPE!: not compared against RubyOnRails, it seems. It's true against Java/JSP development or ASP.NET/C# but CF seems to be no longer the fastest pocket-rocket. because of built-in flash remoting, making it the most cost-effective way of supporting AMF3 for Flex2? - NOPE!: How much does WebORB for Rails cost?.. WebORB for Rails is an open source project. It is available free of charge under the GNU General Public License http://www.themidnightcoders.com/weborb/rubyonrails/faq.htm#howmuch (FYI: WebOrb is a company picking up where PHPAMF left off...) it has features like CFDOCUMENT? Verity? - NOPE!: some ppl (G'day Gareth!) found limitations with CFDocument real fast and switched to using the latest iText libraries natively. Ditto with Verity, replaced with Lucerne. CFREPORT? ... dunno, could never fly that as a solution. too limiting, no interest. FlashForms? ... no call for them really, especially now that Flex2 is out Gateways? ... could never float this as something meaningful. Either the systems were standard, not enterprise - or - the enterprise boxes were stuck on CF6.1 and it's not enough reason to upgrade. it's got a large, active, supportive community? ... I'd say yes compared to Java and .NET... but not against the evangellical RonR world, who seems to gain the strength of 10 because their platform is opensource. ... and everything they touch seems to turn to opensource So, keeping in mind CF8 in development... ... what could possibly entice ppl to buy into CF, either from scratch - or - upgrading from CF6.1? this is a serious ask of, not why CF people are where they are now, but how they can justify traveling down the CF road in the future. (maybe I'm gowing weary of the luddites here that won't upgrade the dwindling number of servers to CF7, the undermining pro-RubyOnRails camp here ... and that opensource WebOrb AMF3 news.. that's the last [EMAIL PROTECTED]@ straw...) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group
[cfaussie] Re: XML close tag
If it is valid and well formed and meets the dtd requirements why is it your problem? If you have to, you can run the xml through a xslt and produce any particular output format. my half a cent Rod - Original Message - From: Andrew Mercer To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 4:32 PM Subject: [cfaussie] Re: XML close tag I am waiting for clarification, but I am producing the XML file for a third party product that will use the generated XML file to import data. I am not sure it will be using a real XML parser. On 8/21/06, Barry Beattie [EMAIL PROTECTED] wrote: please forgive me for saying, but does it matter, esp if you're usingthe inbuiltfunctionality to access the data?we used to write XML as strings and then do a final xmlParse. itcontinously changed our close tagsbut it never worried it... On 8/21/06, Andrew Mercer [EMAIL PROTECTED] wrote: is it possible using CFMX7 xml functions to specify how you want an tag with a blank value to be closed? myTag/myTag verses myTag / - this is what I am getting --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Access Lock File
Hi Charlie, When I create the datasource I turn off the maintain datasource connection option. Before I delete the datasource I had tried to turn on the disable db connections option as well. I have stuck with the old cf 6 cfc for the moment. I'll wait till cf 8 then try to use the cf admin api again. the driver I'm using the follwoing code to create the datasource -: cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Create a DSN. myObj.setMSAccessUnicode(name=#Attributes.datasource#, databasefile = #Attributes.path##Attributes.datasource#.mdb, maintainconnect = 0, enablemaxconnections = 1, maxconnections = 1); /cfscript Then I insert some data into the datasource and then run this code to remove the datasource. cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Remove a DSN. myObj.deletedatasource(dsnname=#Attributes.datasource#); /cfscript As mentioned I had played around with trying to disable the datasource connection option as well with the following code -: cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Modify the dsn. myObj.setMSAccessUnicode(name=#Attributes.datasource#, databasefile = #Attributes.path##Attributes.datasource#.mdb, maintainconnect = 0, enablemaxconnections = 1, maxconnections = 1, disable = 1, timeout = 1); /cfscript So I have looked into those options but still the lock file persists ?? It may be that there is an issue with the OS itself or maybe with the admin api?? Rod - Original Message - From: Charlie Arehart [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, August 22, 2006 1:30 AM Subject: [cfaussie] Re: Access Lock File Rod, no one has mentioned this: have you gone into the show advanced settings button of the datasource definition (in the CF Admin) to tell it turn off the maintain connections option? That's what's really causing the lock (as would any app that opened and kept open the .mdb file). Of course, as others have proposed, getting off of Access should be the next step (I realize that may be out of your hands). One other thought, if this doesn't work, is to ask whether your datasource is defined in the CFMX admin as being an ODBC socket or a Microsoft Access type. The former means you point at an existing ODBC DSN, where the latter uses a built-in connection CFMX offers using DataDirect. Whichever you have, try the other. Shouldn't have any negative impact on how the code works (but of course you should thoroughly test before relying on the change in production). Let us know how it goes. /charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Sunday, August 20, 2006 9:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Access Lock File The problem is releasing the lock file so users can download the access db. Currently cf retains the lock file no matter what I try to do, while this lock file is present the OS can not delete, rename or remove either the lock file or the access db, so this stops any user gaining access to it. Kinda frustrating. At first I thought there was some sort of error in the insert code but I broke that down to a single query and still I have the same problems. I did a google search but can't dig up any issues with the cf admin api so I can only assume it's either my code or some issue with the OS? - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 11:03 AM Subject: [cfaussie] Re: Access Lock File So where is the problem? Is it in dumping to the Access DB or in the download? If it is in dumping to the Access DB, can you not just run a delete and insert query to update with the latest data? How many users? Another solution may be to dump to a comma delimited file which the user downloads and run an automated import using Access on the client side. Chad On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote: Hi Chad, Im using access to dump very small sections of data from a much larger SQL database so users can download the access db and run ad hoc reports from it. I am not using access as a primary datasource. And no DTS is not an option - mostly due to security / access concerns to the primary datasource and complexity of the parameters passed into the extraction process. Rgds Rod - Original Message - From: Chad Renando
[cfaussie] Re: Access Lock File
Update to this if any one is interested. The setMSAccessUnicode() function requires a pooling argument instead of a maintainconnect argument. As soon as I added pooling = 0 instead of maintainconnect = 0 the problem was solved. Of cource this is not listed on the documentation anywhere that I could see thanks for all the help guys. - Original Message - From: Rod Higgins [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, August 22, 2006 10:07 AM Subject: [cfaussie] Re: Access Lock File Hi Charlie, When I create the datasource I turn off the maintain datasource connection option. Before I delete the datasource I had tried to turn on the disable db connections option as well. I have stuck with the old cf 6 cfc for the moment. I'll wait till cf 8 then try to use the cf admin api again. the driver I'm using the follwoing code to create the datasource -: cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Create a DSN. myObj.setMSAccessUnicode(name=#Attributes.datasource#, databasefile = #Attributes.path##Attributes.datasource#.mdb, maintainconnect = 0, enablemaxconnections = 1, maxconnections = 1); /cfscript Then I insert some data into the datasource and then run this code to remove the datasource. cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Remove a DSN. myObj.deletedatasource(dsnname=#Attributes.datasource#); /cfscript As mentioned I had played around with trying to disable the datasource connection option as well with the following code -: cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(mypassword); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.datasource); // Modify the dsn. myObj.setMSAccessUnicode(name=#Attributes.datasource#, databasefile = #Attributes.path##Attributes.datasource#.mdb, maintainconnect = 0, enablemaxconnections = 1, maxconnections = 1, disable = 1, timeout = 1); /cfscript So I have looked into those options but still the lock file persists ?? It may be that there is an issue with the OS itself or maybe with the admin api?? Rod - Original Message - From: Charlie Arehart [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, August 22, 2006 1:30 AM Subject: [cfaussie] Re: Access Lock File Rod, no one has mentioned this: have you gone into the show advanced settings button of the datasource definition (in the CF Admin) to tell it turn off the maintain connections option? That's what's really causing the lock (as would any app that opened and kept open the .mdb file). Of course, as others have proposed, getting off of Access should be the next step (I realize that may be out of your hands). One other thought, if this doesn't work, is to ask whether your datasource is defined in the CFMX admin as being an ODBC socket or a Microsoft Access type. The former means you point at an existing ODBC DSN, where the latter uses a built-in connection CFMX offers using DataDirect. Whichever you have, try the other. Shouldn't have any negative impact on how the code works (but of course you should thoroughly test before relying on the change in production). Let us know how it goes. /charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Sunday, August 20, 2006 9:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Access Lock File The problem is releasing the lock file so users can download the access db. Currently cf retains the lock file no matter what I try to do, while this lock file is present the OS can not delete, rename or remove either the lock file or the access db, so this stops any user gaining access to it. Kinda frustrating. At first I thought there was some sort of error in the insert code but I broke that down to a single query and still I have the same problems. I did a google search but can't dig up any issues with the cf admin api so I can only assume it's either my code or some issue with the OS? - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 11:03 AM Subject: [cfaussie] Re: Access Lock File So where is the problem? Is it in dumping to the Access DB or in the download? If it is in dumping to the Access DB, can you not just run a delete and insert query to update with the latest data? How many users? Another solution may be to dump to a comma delimited file which the user downloads and run an automated
[cfaussie] Re: Access Lock File
Hi Chad, Im using access to dump very small sections of data from a much larger SQL database so users can download the access db and run ad hoc reports from it. I am not using access as a primary datasource. And no DTS is not an option - mostly due to security / access concerns to the primary datasource and complexity of the parameters passed into the extraction process. Rgds Rod - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 10:47 AM Subject: [cfaussie] Re: Access Lock File I ran into it, but had to design my app in a manner that didn't require DB creation stuff in an Access file. Main reason I move to SQL. Chad On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote: Hi, Currently I am having major issues with creating an MS Access with Unicode datasource via the CF admin api. The datasource is created I pump some data into the access db but then it seems to create a lock file that will not release even after I remove the datasource via the same api. The usual malformed query workaround doesn't seem to release the lock file nor any other workaround I have tried. Has anyone come across this and have a solution that works to release the lock? CF7 Ent on Windows 2003. TIA Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Access Lock File
That would be nice .. :) !! The users for this app are a little more demanding. I used to use the old cfmx cfc code to create the access db, populate and then remove the datasource connection and before that the pre-mx hacks to create dsn's - I never really had a problem. I recently started using the cf 7 admin api and that's when the fun began. I might revert back to the cfmx 6 code. I have attached the cfc I used to use - you can see why I wanted to move to the cleaner cf7 admin api calls. - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 11:29 AM Subject: [cfaussie] Re: Access Lock File No, it's an issue w/ Access. Search around for ldb, Access, 'delete locking file' and maybe cold fusion and you may find something. -- The problem is releasing the lock file so users can download the access db I only used Access to upload and update my online SQL DB, not the other way around. To go the other way, I ended up exporting to a text file, having the user download the text file, replace the file on their PC, that was a linked table in the client-side mdb. Chad On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote: The problem is releasing the lock file so users can download the access db. Currently cf retains the lock file no matter what I try to do, while this lock file is present the OS can not delete, rename or remove either the lock file or the access db, so this stops any user gaining access to it. Kinda frustrating. At first I thought there was some sort of error in the insert code but I broke that down to a single query and still I have the same problems. I did a google search but can't dig up any issues with the cf admin api so I can only assume it's either my code or some issue with the OS? - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 11:03 AM Subject: [cfaussie] Re: Access Lock File So where is the problem? Is it in dumping to the Access DB or in the download? If it is in dumping to the Access DB, can you not just run a delete and insert query to update with the latest data? How many users? Another solution may be to dump to a comma delimited file which the user downloads and run an automated import using Access on the client side. Chad On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote: Hi Chad, Im using access to dump very small sections of data from a much larger SQL database so users can download the access db and run ad hoc reports from it. I am not using access as a primary datasource. And no DTS is not an option - mostly due to security / access concerns to the primary datasource and complexity of the parameters passed into the extraction process. Rgds Rod - Original Message - From: Chad Renando [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, August 21, 2006 10:47 AM Subject: [cfaussie] Re: Access Lock File I ran into it, but had to design my app in a manner that didn't require DB creation stuff in an Access file. Main reason I move to SQL. Chad On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote: Hi, Currently I am having major issues with creating an MS Access with Unicode datasource via the CF admin api. The datasource is created I pump some data into the access db but then it seems to create a lock file that will not release even after I remove the datasource via the same api. The usual malformed query workaround doesn't seem to release the lock file nor any other workaround I have tried. Has anyone come across this and have a solution that works to release the lock? CF7 Ent on Windows 2003. TIA Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~--- editdss.cfc Description: Binary data
[cfaussie] Re: Java and gzip
Off the top of my head ... cfset myfile="c:\outfile.gzip"cfset myString="This is a sample string." cfscript// Create the GZIP output stream fileOut = createobject("java", "java.io.FileOutputStream").init(myfile); out = createobject("java", "java.util.zip.GZIPOutputStream").init(fileOut);// Transfer bytes from the input string to the GZIP output stream out.write(myString.getBytes(), 0, len(myString.getBytes())); // Complete the GZIP file out.finish(); out.close();/cfscript Or something like it. Not tested. hth rod - Original Message - From: Andrew Scott To: cfaussie@googlegroups.com Sent: Thursday, August 17, 2006 11:30 AM Subject: [cfaussie] Java and gzip I am looking at a proof of concept and was wondering if anyone here who is better a java than me, would be able to tell me if a string (passed from CF) could be gziped? Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:+613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Chart Library
http://www.intersuite.com/client/index.cfm/2005/11/15/ColdFusion-Tip-Using-the-included-webcharts3d-engine-in-CFMX-7 and then http://www.webcharts3d.com/website/WebCharts50/products/developer.pdf looks cheap to me?? On 8/8/06, Dale Fraser [EMAIL PROTECTED] wrote: It's webcharts3d bit pricy for me.It's not once off it will be used to generate graphs that go into analysis reports of which we generate about 200-2000 per day.RegardsDale Fraserhttp://dale.fraser.id.au-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Chris VelevitchSent: Tuesday, 8 August 2006 17:47 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Chart LibraryIf this is a once off, would screen capture do the job?Chris--Chris VelevitchManager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Chart Library
Yup. The developer api is very extensive as well, I have found it to be a very good charting engine for the price. - Original Message - From: Dale Fraser [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Tuesday, August 08, 2006 6:20 PM Subject: [cfaussie] Re: Chart Library I've just been reading all the guf. So in summary CF7 gives you the full WebCharts3D including the designer. So you can roll your own. You can put a chart into CFDOCUMENT by making the chart produce an image then put the image in CFDOCUMENT. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Tuesday, 8 August 2006 18:12 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Chart Library According to the manual (http://livedocs.macromedia.com/coldfusion/7/htmldocs/1442.htm), you can't use cfchart in cfdocument. On 8/8/06, Chris Velevitch [EMAIL PROTECTED] wrote: On 8/8/06, Rod Higgins [EMAIL PROTECTED] wrote: WebCharts 5.0 executable jar file is called from a bat file here ... cfmx-install\CFusionMX7\charting\webcharts.bat Is this for the cfchart tag? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: (No Items) under ms sql server
Connecting to SQL 2005 with EM is not supported. http://msdn2.microsoft.com/en-us/library/ms174190.aspx http://msdn2.microsoft.com/en-us/library/ms173738.aspx I would suggest installing the SQL Server Management Studio that ships with SQL server 2005. It can administer SQL 2000 as well and is a muchcleaner interface and it's also less buggy then EM. hth Rod - Original Message - From: Dale Fraser To: cfaussie@googlegroups.com Sent: Friday, July 28, 2006 12:48 PM Subject: [cfaussie] Re: (No Items) under ms sql server Ohh, That doesn’t make sense then. Have you tried removing the server in enterprise manager and reconnecting it. RegardsDale Fraser http://dale.fraser.id.au From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Carl VanderpalSent: Friday, 28 July 2006 12:39 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: (No Items) under ms sql server Even though the server and my EM is 2K.. On 7/28/06, Dale Fraser [EMAIL PROTECTED] wrote: If you have upgraded the DB to 2005 schema then 2000 has no idea how to read them. RegardsDale Fraser http://dale.fraser.id.au From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of Carl VanderpalSent: Friday, 28 July 2006 12:28 PMTo: CF Aussie - GoogleSubject: [cfaussie] (No Items) under ms sql server Hello all,Just wondering why on Enterprise Manager MS SQL (2K) there shows ...(No Items) under the databases but when I was there a few days before there were datbases there? (this is on one of my webhosts), but when I log in under using MSSQL 2005 they are all there? Is this something from my end or theirs?ThanksPostal: Po Box 3462 Dural, NSW 2158Email: mailto: [EMAIL PROTECTED] Skype: skype:carlos-amigos?call -- Postal: Po Box 3462 Dural, NSW 2158Email: mailto:[EMAIL PROTECTED] Skype: skype:carlos-amigos?call --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CF to ASP programmer wanted
One thing I have always wondered on this list is why developers limit themselves to only cfml? Sure cfml is a great language that is easy to learn but vbscript, php, .Net, jsp, svg, even vrml all have their place in the development realm - well maybe not vrml anymore. Why not just learn as much as you can so you can develop in what ever language your clients require? Doesn't it enable you to improve your skillset, enable you to find work more easily and also give your clients a range of choices? With visual studio 2005 (and the features it ships with such as ui components) using a framework like atlas, .Net programming *can* be as quick as cfml coding. I personally don't mind working in any language, but I prefer cfml. Don't think so... What I think we can conclude is that this is the wrong list if you are looking for someone who *wants* to work in ASP! ;) B) Steve Onnis wrote: Have we concluded if its ASP or ASP.Net he needs? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 26 July 2006 9:02 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF to ASP programmer wanted sigh! pleze don't start another pissing contest on who's used what language the longest. it's such a bore! I suggest if yiu're *really* interested go look it up on wikipedia. I think CF is a touch older than asp but since there was a really good interview with Jeremy Allaire covering this, I invite ppl to track it down and have a read ... it's not helping Graham find someone On 7/26/06, M@ Bourke [EMAIL PROTECTED] wrote: 11 years ago I chose CFML over ASP for the most productive language. does that mean ASP is older then CFML ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CF to ASP programmer wanted
Hi Dmitry, So your trying to say there is no point in learning a new language unless your a guru at it? How does one become at guru at any language (or surgery for that matter) unless they start learning and using it at the beginner's level? I'm not quite sure what your trying to say here? My point was simply ppl should remain open minded and look at all options, cfml is great but for some cases / projects other languages are better. What is your point? rgds Rod Hi Rod, Why not to learn something in addition? If you are driving a car with automatic transmission, it might be good to learn how to drive a manual transmission car, while could be useful to learn how to drive a bus, or even a train, not talking about tank or jet. Anyway its pretty the same damn things with purpose to transport you from point A to point B, why not to gain something in addition? Do you want to be in surgery with dude, who mostly learnt something in addition or with the one, who has a real clue in his business? Best regards, Dmitry Yakhnov Web Developer http://www.yakhnov.info/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 27, 2006 11:21 AM To: cfaussie@googlegroups.com Cc: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF to ASP programmer wanted One thing I have always wondered on this list is why developers limit themselves to only cfml? Sure cfml is a great language that is easy to learn but vbscript, php, .Net, jsp, svg, even vrml all have their place in the development realm - well maybe not vrml anymore. Why not just learn as much as you can so you can develop in what ever language your clients require? Doesn't it enable you to improve your skillset, enable you to find work more easily and also give your clients a range of choices? With visual studio 2005 (and the features it ships with such as ui components) using a framework like atlas, .Net programming *can* be as quick as cfml coding. I personally don't mind working in any language, but I prefer cfml. Don't think so... What I think we can conclude is that this is the wrong list if you are looking for someone who *wants* to work in ASP! ;) B) Steve Onnis wrote: Have we concluded if its ASP or ASP.Net he needs? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 26 July 2006 9:02 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF to ASP programmer wanted sigh! pleze don't start another pissing contest on who's used what language the longest. it's such a bore! I suggest if yiu're *really* interested go look it up on wikipedia. I think CF is a touch older than asp but since there was a really good interview with Jeremy Allaire covering this, I invite ppl to track it down and have a read ... it's not helping Graham find someone On 7/26/06, M@ Bourke [EMAIL PROTECTED] wrote: 11 years ago I chose CFML over ASP for the most productive language. does that mean ASP is older then CFML ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: creating .doc files in Coldfusion
I've used POI successfully before. The other option is too create the word document save it as html then use CF to create the same html and save as a .doc file. If the application's users have Office 2003, xml might be an option as well. All options work it just depends on your needs. - Original Message - From: cfgroupie [EMAIL PROTECTED] To: cfaussie cfaussie@googlegroups.com Sent: Tuesday, July 04, 2006 3:56 PM Subject: [cfaussie] creating .doc files in Coldfusion Hey guys, I have a need to create word documents on the file based on data. Has anyone done this and if so can they point me in the right direction. I had a look at lots of examples on the web using COM objects but they all seem to be having issues. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] QofQ
When running a page that uses excessive QofQ from a single query the CPU goes bezerk. I was under the impression that QofQ was simply accessing a recordset from memory.I have a couple of questions if anyone has some ideas,workarounds for this. Why does the cfstat utility record QofQ's as DB hits/sec? Also what methods have ppl used to improve performance on pages that use a lot of QofQ -where talking about 50 odd QofQcalls to a single recordset. TIA --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: QofQ
Hi Joel, The reason Im using QofQ firstly is because Im lazy and secondly because Im using a lot of date/time matching from the source recordset. The source recordset has about 160 odd records so it's not that large. What I am finding though is QofQ is not really that efficient. I was wondering what other ppl's thoughts are on this approach. I was under the impression this approach would be faster then hitting the db 50 odd times pulling out recordsets containing one or two records each. Maybe I will have to convert the orginial recordset into arrays, and then pull out the data that way instead. Any thoughts? - Original Message - From: Joel Cass To: cfaussie@googlegroups.com Sent: Wednesday, June 28, 2006 10:27 AM Subject: [cfaussie] Re: QofQ As someone who does not use QoQ that often, here are some other ways you can do this: - If you want to look up a certain value, create a referential structbased on the column you wish to lookup, containing the vital information - If you want to create little queries, you could try query functions (querynew, queryAddColumn etc) - You could try converting the query into an array, CFC, functionorother structurethat retrieves data in a morerelevant way - Use query caching and the startrow / endrow features of cfloop - Do lots of little queries with the database instead of continually messing around with one big query stored in memory CPU and memory are different things. Someone with a CS degree should clear that up for you. Storing data in memory doesn't mean that you avoid processing the data when you start using it in QoQ. I don't know why people use QoQ anyway. It seems limited compared to other ways ofprocessing data. That's just a personal opinion. I know it's probably extremely useful in very specific cases. Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Rod HigginsSent: Wednesday, 28 June 2006 9:50 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] QofQ When running a page that uses excessive QofQ from a single query the CPU goes bezerk. I was under the impression that QofQ was simply accessing a recordset from memory.I have a couple of questions if anyone has some ideas,workarounds for this. Why does the cfstat utility record QofQ's as DB hits/sec? Also what methods have ppl used to improve performance on pages that use a lot of QofQ -where talking about 50 odd QofQcalls to a single recordset. TIA --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: QofQ
Im checking 30 minute increments (datetime)on a date column so Im using the QofQ to determine whether a record exists within a certain start and end time. I will more then likely create an arrayfrom the date column and then test against this. I had thought QofQ would be the more elegant approach. I was more wondering if anyone had a better simpler way. It's a pity QofQ seems so inefficient. Thanks - Original Message - From: Joel Cass To: cfaussie@googlegroups.com Sent: Wednesday, June 28, 2006 10:57 AM Subject: [cfaussie] Re: QofQ Hi Rod, If it's just one field and you are matching dates (ie. date1 = date2), a referential struct may help, ie cfset struct[date]=arrayNew(1) ... cfset arrayAppend(struct[date],structOfcolumns) Or you may be able to use looping or cfoutput grouping, ie. cfoutput query="myquery"group="datefield" #datefield#hr / cfoutput #recordDetails#br /cfoutput hr / /cfoutput or cfloop query="myquery" cfif datefield IS thisDate ... /cfif cfif dateField IS thatDate ... /cfif /cfloop Not really sure about the purpose you need but there would be a solution without QoQ, just not sure how difficult it would be to implement. QoQ is pretty inefficient - I'm not saying you shouldn't use it, I just don't like QoQ all that much. It's a personal thing, really. Perhaps someone with more experience in QoQ may be able tohelp.. Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Rod HigginsSent: Wednesday, 28 June 2006 10:39 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: QofQ Hi Joel, The reason Im using QofQ firstly is because Im lazy and secondly because Im using a lot of date/time matching from the source recordset. The source recordset has about 160 odd records so it's not that large. What I am finding though is QofQ is not really that efficient. I was wondering what other ppl's thoughts are on this approach. I was under the impression this approach would be faster then hitting the db 50 odd times pulling out recordsets containing one or two records each. Maybe I will have to convert the orginial recordset into arrays, and then pull out the data that way instead. Any thoughts? - Original Message - From: Joel Cass To: cfaussie@googlegroups.com Sent: Wednesday, June 28, 2006 10:27 AM Subject: [cfaussie] Re: QofQ As someone who does not use QoQ that often, here are some other ways you can do this: - If you want to look up a certain value, create a referential structbased on the column you wish to lookup, containing the vital information - If you want to create little queries, you could try query functions (querynew, queryAddColumn etc) - You could try converting the query into an array, CFC, functionorother structurethat retrieves data in a morerelevant way - Use query caching and the startrow / endrow features of cfloop - Do lots of little queries with the database instead of continually messing around with one big query stored in memory CPU and memory are different things. Someone with a CS degree should clear that up for you. Storing data in memory doesn't mean that you avoid processing the data when you start using it in QoQ. I don't know why people use QoQ anyway. It seems limited compared to other ways ofprocessing data. That's just a personal opinion. I know it's probably extremely useful in very specific cases. Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Rod HigginsSent: Wednesday, 28 June 2006 9:50 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] QofQ When running a page that uses excessive QofQ from a single query the CPU goes bezerk. I was under the impression that QofQ was simply accessing a recordset from memory.I have a couple of questions if anyone has some ideas,workarounds for this. Why does the cfstat utility record QofQ's as DB hits/sec? Also what methods have ppl used to improve performance on pages that use a lot of QofQ -where talking about 50 odd QofQcalls to a single recordset. TIA --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at
[cfaussie] Re: Path to the site root directory
cfset thisPath=ExpandPath(/) cfset rootDirectory=GetDirectoryFromPath(thisPath) or am I missing something? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, June 22, 2006 12:17 PM Subject: [cfaussie] Path to the site root directory Hello, Is there a programmatical way of returning the root directory of the website, regardless of the current page's location within the site? eg The site http://mysite/somepage.cfm = c:\mysites\application\ the site http://mysite/admin/somepage.cfm = c:\mysites\application\ Currently this location is stored in the database... but I don't think this is the best method Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: in praise of ColdFusion (and an OT Java question)
http://www.activsoftware.com/mx/undocumentation/query.cfm Found this on google, interesting reading. I dont know where they got that java code from?? hth Rod - Original Message - From: Barry Beattie [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, June 15, 2006 11:55 PM Subject: [cfaussie] Re: in praise of ColdFusion (and an OT Java question) thankyou for your response, Charlie. sadly, the JSTL seems to satisfy only one criteria. easy iteration to access the data. From my understanding and research, the JSTL query object can *only* be populated by throwing it against a database, not dynamically filled like an arrayList, linkList or a CF query using QueryAddRow() / QuerySetCell() / QueryAddColumn(). then there's the ability to filter and return rows based on simple SQL syntax, which ADO.NET just manages to do** but CF's QueryOfQueries does in style. unless I can find otherwise, the humble CFQUERY seems to be unique in the way it looks like a collection/structure/datatype but has it's own properties and methods to work with the data it holds. Thanks to a simple API, it's much more than just the hashMap that's used under the covers. as a side note re JSTL connecting to a database and returning results: maybe it's just me but that idea (tight coupling between model and view) just seems to be so 1998 thanx anyhoo, Charlie. **internal storage of ADO.NET's datasets and datatables is (IIRC) XML and all the methods do is query (XPath?) the xml or append nodes, etc. While this is a possible solution, it's the sort of thing that you'd wish someone else had written! (PS: Dale: Amen to that - but I am only a small voice in the crowd) On 6/15/06, Charlie Arehart [EMAIL PROTECTED] wrote: Barry, if I'm understanding your question correctly, have you looked at the JSTL (JSP Standard Tag Library)? It makes JSP look a lot more like CFML, particularly a query: sql:query var=deejays SELECT * FROM mytable /sql:query %-- Get the column names for the header of the table --% c:forEach var=columnName items=${deejays.columnNames} thc:out value=${columnName}//th /c:forEach %-- Get the value of each column while iterating over rows --% c:forEach var=row items=${deejays.rows} tr c:forEach var=column items=${row} tdc:out value=${column.value}//td /c:forEach /tr /c:forEach The JSTL has been included in JSP 2.0, which has been out for a couple years now (and I think it grew out of work that the Jrun team did, being familiar as they were with CFML). It's now available on all the J2EE and Servlet Engine implementations For more, see: http://www.devx.com/webdev/Article/16973/1763/page/3 http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsps/jstl sql.html And many other resources. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Thursday, June 15, 2006 1:41 AM To: cfaussie@googlegroups.com Subject: [cfaussie] in praise of ColdFusion (and an OT Java question) snip anyhoo, I'm looking for a java replacement of the humble CFQUERY - but not the database connectivity side of it. perhaps a class than can - be an object masquarading as a 2D data structure that can be dynamically resized (ie: no db required) and has a simple API to do so (as easy as QueryAddRow, QuerySetCell, QueryAddColumn) - be accessed/iterated over with obj[keyname][row] or obj[i][j] - have simple SQL thrown against it. Microsoft's ADO.NET can (mostly) do this (albeit with 10 times more code than CF) http://msdn2.microsoft.com/en-us/system.data.datatable.aspx but is there a java version of the same? Surely someone has already done this (apart from Alaire/Macromedia/Adobe) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Currency conversion webservice
Hi, Anyone know of an Australian based currency conversion webservice, preferably free. Thanks in advanced. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Kill them all!!!! --- ALL sessions
cfscript sessionTracker = createObject(java, coldfusion.runtime.SessionTracker); // once created maybe something like the cleanUp() function // but it depends on how your ending thesessions sessionTracker.cleanUp();/cfscript cfdump var=#sessionTracker# This might send you on the right path hth Rod On 6/7/06, cfgroupie [EMAIL PROTECTED] wrote: Thanks guys,Didn't work, although I think I had tried that once before. Thanks foryour help nevertheless. jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: javaCast string array
cfset myArray = listtoarray("server1,server2,server3") cfdump var="#myArray#" cfscriptarrList = createobject("Java","java.util.ArrayList");for (i = 1; i LTE arrayLen(myArray); i = i + 1)temp = arrList.add(myArray[i]);strArray = arrList.toArray();/cfscript cfdump var="#strArray#" Looks the same to me. I wouldnt be surprised if CF creates all coldfusion arrays as javaString[]. hth Rod - Original Message - From: Taco Fleur To: cfaussie@googlegroups.com Sent: Tuesday, June 06, 2006 9:38 AM Subject: [cfaussie] javaCast string array Ihave a method on a java class that expects a string array public void setServers(java.lang.String[] servers)I don't think I can create an array in CF and then run javacast( "string", myArray ) over it can I? -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: javaCast string array
You need to take out the toArray() call from within the loop. Add all of the items into the arrayList then convert to a String[] try {myServerArray = listToArray( getServer() );ArrayList = createobject( "java", "java.util.ArrayList" );for ( i = 1; i lte arrayLen( myServerArray ); i = i + 1 ) { ArrayList.add( myServerArray[ i ] );} stringServerArray = ArrayList.toArray();myObject.setServers( stringServerArray );} hth Rod - Original Message - From: Taco Fleur To: cfaussie@googlegroups.com Sent: Tuesday, June 06, 2006 11:13 AM Subject: [cfaussie] Re: javaCast string array Thanks, I gave that a go, but no luck, its expecting java.lang.String[] The ArrayList must not be the right data type as it can't find the method, the method is there! Following is what I have; try {myServerArray = listToArray( getServer() );ArrayList = createobject( "java", "java.util.ArrayList" );for ( i = 1; i lte arrayLen( myServerArray ); i = i + 1 ) { ArrayList.add( myServerArray[ i ] ); stringServerArray = ArrayList.toArray();}myObject.setServers( stringServerArray );} --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: javaCast string array
Depending on what is returned from getServer() you might want to also change this line also... ArrayList.add( myServerArray[ i ] ); to ArrayList.add( myServerArray[ i ].toString() ); - Original Message - From: Taco Fleur To: cfaussie@googlegroups.com Sent: Tuesday, June 06, 2006 11:19 AM Subject: [cfaussie] Re: javaCast string array This seemed to work... stringServerArray = arrayNew( 1 );stringServerArray[ 1 ] = javaCast( "string", "www.serverone.com" ); On 6/6/06, Taco Fleur [EMAIL PROTECTED] wrote: Thanks, I gave that a go, but no luck, its expecting java.lang.String[] The ArrayList must not be the right data type as it can't find the method, the method is there! Following is what I have; try {myServerArray = listToArray( getServer() );ArrayList = createobject( "java", "java.util.ArrayList" );for ( i = 1; i lte arrayLen( myServerArray ); i = i + 1 ) { ArrayList.add( myServerArray[ i ] ); stringServerArray = ArrayList.toArray();}myObject.setServers( stringServerArray );}-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CF aptitude test
The certification exam tests a lot more then just CF syntax, if it did it would be of little value. From my experience only about 60% of the exam focused on cf syntax type questions. The rest was on evaluating code and general web 'assumed knowledge' type questions. I think the certification exam is a very good indicator as to a person's cf ability. No question you can ask is ever going to give you the full picture of the coding quality of the candidate, but if they at least know the basics then it is more a question of coding standards isnt it? Maybe an open ended question like what is your preferred cf framework and why? - Original Message - From: Ryan Sabir [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Monday, May 15, 2006 12:17 PM Subject: [cfaussie] Re: CF aptitude test CF is just a syntax - I'd be more interested in application design sort of questions - That's what I'm thinking as well, which is why I think the CF certification exams might not be the best place to start. Maybe not so much a CF aptitude test, but a general technical evaluation, focusing on CF development. I was thinking questions like: Describe how you would build a system that does X. Outline a testing methodology for this system. What performance considerations would need to be addresed in this system. And then maybe a few CF specific questions: Write some code that would generate this output What could go wrong when using CFMAIL. Talk me through this code and tell me what it does. I'm not too interested in testing their knowledge of specific CF tags, that's what the reference books are for. Thanks... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Safari for Windows
Anyone know of a port of Safari for windows? Or even something that will emulate it? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
I wish. But the client I'm working for has a general manager that just loves mac's and of course loves safari. kind of a showstopper if the code doesnt work on a mac. Here's an idea. Don't support safari. Catering to such a small minority is a waste of time. Get the mac users to use a different browser. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 19 April 2006 11:54 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Safari for Windows Thanks Scott, but the problem Im having is trying to debug some javascript code that's not behaving on safari. Works fine on mozilla, netscape, ie but not safari. Don't you just love javascript. I'll end up trying to run an osx vm or something like it. I looked and looked for ways to emulate safari on a pc with no success. thanks for all the help guys. try this: http://www.danvine.com/icapture/ this guy has a mac running and will screen capture on safari for you site. but very slow. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Installer 4 ColdFusion
I'd also be interested to know what people generally use for installing web apps as well. - Original Message - From: cfgroupie [EMAIL PROTECTED] To: cfaussie cfaussie@googlegroups.com Sent: Wednesday, March 08, 2006 12:11 PM Subject: [cfaussie] Installer 4 ColdFusion Hi Guys, I'm on the look out again for a good installer for web applications. I'm S tired of the same ol copy and paste thing. AND don't say .Car. I'll smack ya! I work with alot of programmers from different environments. i.e. PowerBuilder which uses an installer. I found that when they install their applications its much quicker. However when you do a web application, there is alot more cockin around. As anyone found something half way decent? Anything at all. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---