[cfaussie] Re: CFCAMP Australia Is GO
If either of you guys know where we can hold it, and/or anyone who wishes to sponsor to pay for hall hire, please let me know. Regards, Mark On 8/14/07, Stephen M [EMAIL PROTECTED] wrote: On Aug 14, 3:24 pm, Paul Kukiel [EMAIL PROTECTED] wrote: I'd also definatly go if it was in Melbourne. define definite definitely http://www.d-e-f-i-n-i-t-e-l-y.com/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Monday, 13 August 2007 8:59 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCAMP Australia Is GO Geoff, That Sounds Really Good, What's the deal with Melbourne being skipped in these things. First Mark Blair the other night at the UG hook up said Adobe will tour, but no Melbourne. Now this. Surely Melbourne would have more or just as much interest as Canberra. PS: The wiki does say to petition you. So anyone else who thinks Melbourne should get a stop, say so. Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Bowers Sent: Monday, 13 August 2007 8:39 PM To: cfaussie Subject: [cfaussie] CFCAMP Australia Is GO Quick heads up for CFAUSSIE... more official marketing to follow. CFCAMP Australia is a free, mini-conference for coldfusion developers by coldfusion developers. We're celebrating the release of Coldfusion 8 -- and there is a lot to celebrate. Help us build the agenda for your city: http://cfcamp.pbwiki.com/ Suggest your own sessions, petition existing sessions, help organise! Brisbane on the 11th of September at the Rydges Canberra on the 12th of September at the UCU Conference Centre Sydney on the 13th of September at the Wesley Centre Enjoy! -- geoffhttp://www.daemon.com.au/ -- 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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Caught exception in JSONDataSet.loadDataIntoDataSet: [object Error]
Hi all, has anyone encountered the following error with Lighthouse Pro? Caught exception in JSONDataSet.loadDataIntoDataSet: [object Error] -- *** http://www.clickfind.com.au The new Australian search engine for businesses, products and services *** http://brisbane-web-design.pacificfox.com.au blog *** Virtual and Dedicated Servers with MS SQL from $250 a month *** Virtual and Dedicated Servers with registered version of ColdFusion from $350 a month *** ColdFusion licenses at the lowest price --~--~-~--~~~---~--~~ 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] ColdFusion website design business for sale
I am offering a successful and well known website design business based in Brisbane for sale. This is a serious proposal, I however do not want to make the name of the business known until I am sure of your intentions. We have; - $40,000 project in the pipeline, down payment already received. - Approx. $5,000+ per month maintenance work of high profile project. Launched recently and has done major TV advertising, already has a member base of more than 2,000 - $45,000+ in upgrades waiting to be completed on the above project - $5,000 upgrade for another customer - Approx. $1,000 per month in hosting - Hosting is outsourced and ready to be taken over, i.e. no move is needed - Catchy business name - Trademark - Website - Business name - Domain name - 1800 number - Client base Last years turn-over was $100,000+ grown by 50% from previous year, this year is expected another growth of 50%. Our client base is in Brisbane, Gold Coast, Melbourne, VIC, SA etc. All websites are of high quality, CSS only, excellent designs. Technologies worked with are: ColdFusion, JavaScript, MS SQL and MySQL. Please make an offer. Any questions are answered via email to start with. Looking to close the deal within 1 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: CFCAMP Australia Is GO
On Aug 13, 8:58 pm, Dale Fraser [EMAIL PROTECTED] wrote: PS: The wiki does say to petition you. So anyone else who thinks Melbourne should get a stop, say so. The petition is supposed to mean, add your name and/or view to the WIKI. Letting me know is great, but letting the community and its sponsors have a feel for how many people are happy to sign up their name is another :) -- geoff http://www.daemon.com.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: ColdFusion website design business for sale
Glenn, I am forwarding this to you, if this is a serious offer is there any way that Aegeon could take on this business? I think the extra income would be a benefit to us, I know that it is not mainstream Enterprise solutions but could be worth a look. Could we discuss this further at some point? 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 Web Design Sent: Tuesday, 14 August 2007 6:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] ColdFusion website design business for sale I am offering a successful and well known website design business based in Brisbane for sale. This is a serious proposal, I however do not want to make the name of the business known until I am sure of your intentions. We have; - $40,000 project in the pipeline, down payment already received. - Approx. $5,000+ per month maintenance work of high profile project. Launched recently and has done major TV advertising, already has a member base of more than 2,000 - $45,000+ in upgrades waiting to be completed on the above project - $5,000 upgrade for another customer - Approx. $1,000 per month in hosting - Hosting is outsourced and ready to be taken over, i.e. no move is needed - Catchy business name - Trademark - Website - Business name - Domain name - 1800 number - Client base Last years turn-over was $100,000+ grown by 50% from previous year, this year is expected another growth of 50%. Our client base is in Brisbane, Gold Coast, Melbourne, VIC, SA etc. All websites are of high quality, CSS only, excellent designs. Technologies worked with are: ColdFusion, JavaScript, MS SQL and MySQL. Please make an offer. Any questions are answered via email to start with. Looking to close the deal within 1 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: CFCAMP Australia Is GO
Be there or be a .NET developer.. Damn, and here I was going to contribute.. oh well, *takes his bar tab + CF integration with .NET Session and stomps back to his white tower of MSFT evil* :) On 8/13/07, Geoff Bowers [EMAIL PROTECTED] wrote: Quick heads up for CFAUSSIE... more official marketing to follow. CFCAMP Australia is a free, mini-conference for coldfusion developers by coldfusion developers. We're celebrating the release of Coldfusion 8 -- and there is a lot to celebrate. Help us build the agenda for your city: http://cfcamp.pbwiki.com/ Suggest your own sessions, petition existing sessions, help organise! Brisbane on the 11th of September at the Rydges Canberra on the 12th of September at the UCU Conference Centre Sydney on the 13th of September at the Wesley Centre Enjoy! -- geoff http://www.daemon.com.au/ -- Regards, Scott Barnes http://www.mossyblog.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] CFCAMP Needs Your Help!
Folks, We've only got a short time to put together sessions, judge demand and so on for these experimental CFCAMPs next month. What we need is input from the community on what sessions you would like to see. Please take a moment to: - logon to the WIKI - add the sessions you think might be interesting - put in a vote of confidence for those sessions you'd like to attend - put up your hand if you want to speak - suggest somewhere we might all get a drink afterwards Adobe are currently sponsoring three city venues. There is no reason other sponsors can't be found for other locations. If the demand for other cities is great, it might just be enough to convince Adobe to sponsor more. Input is what we need :) If you are a potential sponsor let me know -- we need your help. It's important to remember this is *not* a daemon thing -- some of us are just helping out. It's not even an Adobe thing -- though they are very generously offering their support. It's a CF community thing. All the best, -- geoff http://www.daemon.com.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: CFCAMP Needs Your Help!
Geoff, I was under the impression that this was an Adobe initiative? Are you saying that it actually isn't? Just out of interest then - where did the cfcamp come from then? Mark On 8/15/07, Geoff Bowers [EMAIL PROTECTED] wrote: Folks, We've only got a short time to put together sessions, judge demand and so on for these experimental CFCAMPs next month. What we need is input from the community on what sessions you would like to see. Please take a moment to: - logon to the WIKI - add the sessions you think might be interesting - put in a vote of confidence for those sessions you'd like to attend - put up your hand if you want to speak - suggest somewhere we might all get a drink afterwards Adobe are currently sponsoring three city venues. There is no reason other sponsors can't be found for other locations. If the demand for other cities is great, it might just be enough to convince Adobe to sponsor more. Input is what we need :) If you are a potential sponsor let me know -- we need your help. It's important to remember this is *not* a daemon thing -- some of us are just helping out. It's not even an Adobe thing -- though they are very generously offering their support. It's a CF community thing. All the best, -- geoff http://www.daemon.com.au/ -- 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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFCAMP Needs Your Help!
On Aug 15, 12:21 pm, Mark Mandel [EMAIL PROTECTED] wrote: I was under the impression that this was an Adobe initiative? Are you saying that it actually isn't? Just out of interest then - where did the cfcamp come from then? Adobe are sponsoring this initiative. They are a driving force behind making it happen. They are providing venues and a core of speakers. The very nature of a CAMP is the fact that it is organised by its community. This is our chance to show Adobe that we are passionate about CF and that they should match our emotional investment. So please, participate. If you are a company or manager, let your staff attend. If you have something interesting to say, put your hand up to present. Its deliberate that at this time no agenda is specified -- it's there for the community to decide. If necessary, these slots will be filled with specific sessions nominated by the organisers, but heh it would be much more fun to actually hear what people are interested in seeing. Help set the agenda you want, that's what CAMPs are all about. If we can make a success of these three CAMPs maybe we can convince the powers that be to help run these things up and down the country. All the best, -- geoff http://www.daemon.com.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: CFCAMP Needs Your Help!
Hi Geoff, How much content will be provided for the local host? 20% 50% 100% Will Adobe themselves be presenting anything? Regards Andrew On 8/15/07, Geoff Bowers [EMAIL PROTECTED] wrote: Folks, We've only got a short time to put together sessions, judge demand and so on for these experimental CFCAMPs next month. What we need is input from the community on what sessions you would like to see. Please take a moment to: - logon to the WIKI - add the sessions you think might be interesting - put in a vote of confidence for those sessions you'd like to attend - put up your hand if you want to speak - suggest somewhere we might all get a drink afterwards Adobe are currently sponsoring three city venues. There is no reason other sponsors can't be found for other locations. If the demand for other cities is great, it might just be enough to convince Adobe to sponsor more. Input is what we need :) If you are a potential sponsor let me know -- we need your help. It's important to remember this is *not* a daemon thing -- some of us are just helping out. It's not even an Adobe thing -- though they are very generously offering their support. It's a CF community thing. All the best, -- geoff http://www.daemon.com.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] CFCAMP Melbourne :: Expressions of Interest
All, If you are interested in attending a Melbourne CFCAMP, please your name down in the comments of this blog post: http://www.compoundtheory.com/?action=displayPostID=247 That way we can get a good idea on how many people are liable to attend if we can get this project off the ground. Thanks, Mark -- 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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Can QofQ do updates?
not that I know of. my guess is that it's just a wrapper for a hashtable that has getters only and an API for searching via SQL calls. in fact I've had to do deletes by doing a not in or !=, getting everything but the ones I want deleted back and then re-assigning the new query back to the old. and IIRC, updates were deletes first and querySetCells On 8/15/07, Mike Kear [EMAIL PROTECTED] wrote: Thanks Steve, that was my second choice. So you are confirming that QofQ doesnt have update? Cheers Mike Kear On 8/15/07, Steve Onnis [EMAIL PROTECTED] wrote: cfset querySetCell(oldquery , thiscolumn, sidequery.thisvalue, sidequery.thisIndex) / Just do that -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 15 August 2007 1:21 PM To: cfaussie Subject: [cfaussie] Can QofQ do updates? I'm having a problem with a Query of a Query, and it suddenly hit me - maybe QofQ can't actually DO an update, and that's why I'm getting the error! Can anyone please confirm that it IS indeed a supported function in Qof Q?? (we're talking CF7 here) If not, how would you go about running this code if you can't use query of queries: cfloop query=sidequery cfquery name=newquery dbtype=query UPDATE oldquery set thiscolumn = '#sidequery.thisvalue#' WHERE index = '#sidequery.thisIndex#' /cfquery /cfloop (I've already decided that using the original SQLQuery to do all this in one step is too hard for a whole host of reasons) 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 -- 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: Can QofQ do updates?
I am no QoQ expert, however the QoQ is done against a dataset held in memory and not against the Database, so the answer would be NO. Your best bet for complex queries would be a View, that way you can update what you want to do into the database. But even with a QoQ, you have certain info that you could use to update against the Database anyway. I am not sure why you would have tried to update the QoQ, as it is a memory held object (Dataset) anwyay. 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 Mike Kear Sent: Wednesday, 15 August 2007 1:21 PM To: cfaussie Subject: [cfaussie] Can QofQ do updates? I'm having a problem with a Query of a Query, and it suddenly hit me - maybe QofQ can't actually DO an update, and that's why I'm getting the error! Can anyone please confirm that it IS indeed a supported function in Qof Q?? (we're talking CF7 here) If not, how would you go about running this code if you can't use query of queries: cfloop query=sidequery cfquery name=newquery dbtype=query UPDATE oldquery set thiscolumn = '#sidequery.thisvalue#' WHERE index = '#sidequery.thisIndex#' /cfquery /cfloop (I've already decided that using the original SQLQuery to do all this in one step is too hard for a whole host of reasons) 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: Can QofQ do updates?
well, ADO.NET has datasets in memory that you can update and they can still be in memory only. you then call the underlying database to update when you're ready but you don't have to. as I said, I've done updates by deleting first then queryAddRow(), querySetCell()'s the values. cumblesome but it worked. Damn! I should have suggested this for the CF8 wish list since I spent so long doing this hacky QofQ stuff. Maybe a feature for CF9? On 8/15/07, Andrew Scott [EMAIL PROTECTED] wrote: I am no QoQ expert, however the QoQ is done against a dataset held in memory and not against the Database, so the answer would be NO. Your best bet for complex queries would be a View, that way you can update what you want to do into the database. But even with a QoQ, you have certain info that you could use to update against the Database anyway. I am not sure why you would have tried to update the QoQ, as it is a memory held object (Dataset) anwyay. 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 Mike Kear Sent: Wednesday, 15 August 2007 1:21 PM To: cfaussie Subject: [cfaussie] Can QofQ do updates? I'm having a problem with a Query of a Query, and it suddenly hit me - maybe QofQ can't actually DO an update, and that's why I'm getting the error! Can anyone please confirm that it IS indeed a supported function in Qof Q?? (we're talking CF7 here) If not, how would you go about running this code if you can't use query of queries: cfloop query=sidequery cfquery name=newquery dbtype=query UPDATE oldquery set thiscolumn = '#sidequery.thisvalue#' WHERE index = '#sidequery.thisIndex#' /cfquery /cfloop (I've already decided that using the original SQLQuery to do all this in one step is too hard for a whole host of reasons) 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: CFCAMP Needs Your Help!
Hi folks, Just to clarify a few things. This is a community event strongly supported by Adobe. Both myself and Andrew Spaulding (and possibly others from Adobe) will be at the events and presenting. We will be doing an opening keynote together and putting ourselves forward for other sessions throughout the day. The history of the CFCAMP event is that Adobe wanted to do something due to the launch of ColdFusion 8, given my long association with the product and community over the years I got pulled into the process and the idea of a CAMP style event surfaced. Geoff was asked if he could provide some support and here we are ... Additionally later in the year Adobe are planning initiating some more CAMP style events focused on other web enabling technologies including Flex, AIR and CS3 ... I'm hoping the community will step up and present sessions, help us promote the event and make it a success! Best Mark Mark Blair Technical Director, Pacific Adobe Systems From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of AJ Mercer Sent: Wednesday, 15 August 2007 1:02 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFCAMP Needs Your Help! Hi Geoff, How much content will be provided for the local host? 20% 50% 100% Will Adobe themselves be presenting anything? Regards Andrew On 8/15/07, Geoff Bowers [EMAIL PROTECTED] wrote: Folks, We've only got a short time to put together sessions, judge demand and so on for these experimental CFCAMPs next month. What we need is input from the community on what sessions you would like to see. Please take a moment to: - logon to the WIKI - add the sessions you think might be interesting - put in a vote of confidence for those sessions you'd like to attend - put up your hand if you want to speak - suggest somewhere we might all get a drink afterwards Adobe are currently sponsoring three city venues. There is no reason other sponsors can't be found for other locations. If the demand for other cities is great, it might just be enough to convince Adobe to sponsor more. Input is what we need :) If you are a potential sponsor let me know -- we need your help. It's important to remember this is *not* a daemon thing -- some of us are just helping out. It's not even an Adobe thing -- though they are very generously offering their support. It's a CF community thing. All the best, -- geoff http://www.daemon.com.au/ br --~--~-~--~~~---~--~~ 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: Can QofQ do updates?
Well like I said I am no expert, and yes ADO.Net has a dataset that can update the Database. But Coldfusion is not ADO.Net, and if those hacks work then maybe a suggestion for CF9 or even maybe report it as a bug and see if that can be included in the next hotfix, I know a lot of Ajax/UI stuff needs to be fixed ASAP before it can truly used. 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 Barry Beattie Sent: Wednesday, 15 August 2007 1:59 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Can QofQ do updates? well, ADO.NET has datasets in memory that you can update and they can still be in memory only. you then call the underlying database to update when you're ready but you don't have to. as I said, I've done updates by deleting first then queryAddRow(), querySetCell()'s the values. cumblesome but it worked. Damn! I should have suggested this for the CF8 wish list since I spent so long doing this hacky QofQ stuff. Maybe a feature for CF9? On 8/15/07, Andrew Scott [EMAIL PROTECTED] wrote: I am no QoQ expert, however the QoQ is done against a dataset held in memory and not against the Database, so the answer would be NO. Your best bet for complex queries would be a View, that way you can update what you want to do into the database. But even with a QoQ, you have certain info that you could use to update against the Database anyway. I am not sure why you would have tried to update the QoQ, as it is a memory held object (Dataset) anwyay. 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 Mike Kear Sent: Wednesday, 15 August 2007 1:21 PM To: cfaussie Subject: [cfaussie] Can QofQ do updates? I'm having a problem with a Query of a Query, and it suddenly hit me - maybe QofQ can't actually DO an update, and that's why I'm getting the error! Can anyone please confirm that it IS indeed a supported function in Qof Q?? (we're talking CF7 here) If not, how would you go about running this code if you can't use query of queries: cfloop query=sidequery cfquery name=newquery dbtype=query UPDATE oldquery set thiscolumn = '#sidequery.thisvalue#' WHERE index = '#sidequery.thisIndex#' /cfquery /cfloop (I've already decided that using the original SQLQuery to do all this in one step is too hard for a whole host of reasons) 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: Storing PDF files as blobs in a database
Any one got any other ideas on this? All I want to do is read a PDF file, insert the data into the database and then be able to query the database and output the pdf again either to the browser for download or to write it to the file system again. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 14 August 2007 8:23 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Storing PDF files as blobs in a database Hi, I wonder if CFX_PUTIMAGE could be of assistance? or maybe cffile action = readbinary file = c:\xxx\\scan005659.jpg variable=image_var_blob I know they are image type manipulation... but it may help. Steve Onnis [EMAIL PROTECTED] 13/08/2007 11:04 pm I am trying to generate PDF files and store them in a database for future reference instead of writing them to the file system Can anyone point me in the right direction on doing this? I have tried a few things but I cant seem to get it to work, http://www.inevative.com.au/images/email-stationary/inevativeLogo_small.jpg Steve Onnis Director / Head Developer http://www.inevative.com.au/images/email-stationary/email.jpg [EMAIL PROTECTED] http://www.inevative.com.au/images/email-stationary/phone.jpg +61 3 9001 2258 http://www.inevative.com.au/images/email-stationary/mobile.jpg 0401 667 996 http://www.inevative.com.au/images/email-stationary/web.jpg www.inevative.com.au http://www.novahost.com.au http://www.threesquares.com.au http://www.smsonline.com.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] Memory issues
Hi all, I have developed code that builds structure from two database tables. I have a component that features the function to build the struct and also a function to validate the struct. Now, I have noticed an inconsistent issue with the values at each of the struct keys. The main struct consists of the below : key [numeric] -- nestedStructA - with several keys eg nestedStructA .value1,nestedStructA .value2, etc etc -- nestedStructB - with several keys eg nestedStructB.value1,nestedStructB .value2, etc etc The entire struct consists of about 600 keys. I wrote a script to loop 100 times and build the struct then validate it, with some interesting observations. There are occasions where nestedStructA does NOT even exist, and sometimes the value nestedStructA ( supposed to be a struct of keys ) is NOT of type struct but rather a timestamp or empty. This also occurs with nestedStructB. The validate function ensures EACH key nested nodes (nestedStructA,nestedStructB) are BOTH structs and are not empty. The validation functions returns the key that failed, and this is NEVER the same key. Its always different. I have ensure all my variables are VAR'd and my locks are correctly set up. I use the structNew() to build each struct in order to avoid any issues. I personally believe that it may be related to a memory issue rather than my code - and its been frustrating having to debug this problem. I have read several articles about similar issues to no avail. Can anyone offer some input or any assistance to this problem. I am willing to email the code if anyone would be interested in assisting. 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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Storing PDF files as blobs in a database
Any one got any other ideas on this? Other ideas? How about: don't do that? All I want to do is read a PDF file, insert the data into the database and then be able to query the database and output the pdf again either to the browser for download or to write it to the file system again. Why not keep the files in the filesystem in the first place? Filesystems are specifically designed to handle files; relational databases, not so much. You'll have the overhead of getting the file into the DB in the first place, then if your database isn't the latest greatest you'll have to do special maintenance when you delete the record. Can your DB handle unlimited size blobs, btw? If it's just a matter of not having the file in the location they were created you could always cffile action='move'.. them around on the drive. But if you really need to, and blobbing doesn't work, check out binary to hex encoders/decoders such as CFX_HEX, and stuff the data into a long character field. 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 -~--~~~~--~~--~--~---
