[cfaussie] Companies Using ColdFusion
Hi Just wondering how popular CF is across business and if there are still any large companies using CF as opposed to other solutions ??? I am looking for Remote CF work and it would be handy to have an understanding of the current CF level of use Any thoughts / suggestions or knowledge of anyone needing some Remote CF development / maintenance work please do let me know -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] CF and Windows 10 and IIS
Hi Charlie Thanks for your suggestion and reference material Regrettably despite trying them I am still no further along Is there a way I can simply re backup the original database making sure I select the correct options so that when I restore it on the new server the new server credentials are automatically applied ??? Claude From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Wednesday, 12 August 2015 5:10 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF and Windows 10 and IIS OK, here finally is what you can do, Mike (or anyone interested) to get things running. I mentioned below that the “fusionator” blog post had talked about the process, and the key is that he suggests you extract the ColdFusion installer exe (yep, it is basically a zip, as an exe), and then he mentions “replacing the JRE” that comes with that with a more updated one (which does support Windows 8 or 10, such as Java 8 or perhaps later editions of Java 7). He doesn’t say anything more than that (about that process), so I assume he really meant “copy/paste” the JRE folder from an updated JVM to that folder in the extraction of the exe. (He also doesn’t give details about “what” JVM should be used. I will, below.) While you can do that, you don’t really have to. That same extracted folder (mine was C:\Users\charlie\Downloads\ColdFusion_9_WWEJ_win64\) will also have a \Windows folder, and in there will be a adobe_cf.lax, which is somewhat like CF’s jvm.config, as it’s a property file of JVM args for the installer. In that file, there will be a line: lax.nl.current.vm=resource\\jre\\bin\\java.exe This is what points the installer to the JVM that’s included with the installer itself (and it’s that JVM which doesn’t work on Windows 10 or 8.1). But my point is that you can just change that to point to an “updated” JRE\JVM path that you can obtain. But here’s a catch: as I review that lax file, it seems clear that it expects a 32-bit JVM (even if the CF you are installing is 64-bit). Again, this is just about the JVM for the *INSTALLER*, and so it must bundle (inside that exe) a 32-bit jvm. So if we are going to point it at another, then we need that to be a 32-bit JVM. I did it by pointing at a 32-bit Java 8 JDK that I got (at http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html). I could have gotten a JRE instead, but I tend to just always get JDKs. I really don’t think it matters in this case. But it HAS TO BE 32-bit, or the next steps will not work. When I installed that JDK, it installed to C:\Program Files (x86)\Java\jdk1.8.0_51, and THAT is where I needed to point the lax file (coming up). The “program files (x86) tells you that it was a 32-bit JVM. (Something that one may miss: when you’re running the installer for Java, there is a screen with various options you can choose, one of which is whether to install it as a “public jre”. There are good reasons to tend to favor NOT doing that, which is what I always do, and if you do that, then this path I point to is where it will be installed, by default. So with that in place, I changed the line in the lax file to: lax.nl.current.vm=C:\\Program Files (x86)\\Java\\jdk1.8.0_51\\bin\\java.exe Note the use of double-slashes. This is just a necessary hassle with Java on Windows. (And while it could point to the jre\bin, within the JDK folder, it was not necessary.) Finally, as “the fusionator” goes on to say in his post, you then do also want to right-click the installer exe (in that extracted folder), adobe_cf.exe, and enable windows 7 compatibility. (Otherwise, the installer will start but then complain that “installer user interface mode not supported”.) Then you run that adobe_cf.exe (not needing it to be run “as admin”, in my testing). Once I did all this, the CF9 installer now did launch. So no, my approach (of editing the lax file) is not necessarily fewer steps than “the fusionator”’s approach of “just copying/replacing the JRE folders”, but it seems a bit safer in case something goes amiss. It’s easier to undo and try again, which I needed to do for various reasons in getting this all working. So Mike, there you go. With either what the fusionator shared (and my additional info about the “right” JVM to get), and copy/pasting over the JRE that comes with the installer, or with my tweak here to just edit the lax file to point to it elsewhere, you should be able to get the CF9 installer running on Windows 10. Let us know how you get on, if you try it. (And again, let’s not lament, “why does Adobe make it so difficult?” Again, this CF9 installer was created in 2012, before Windows 10 came out. And they DID add support for Windows 8 in an update of CF10 and in CF11 out of the box. I’m sure we’ll see an update for CF11 to support Windows 10, and maybe CF10, and certainly CF12 will support it out of
RE: [cfaussie] Help With Dynamic Naming A CfScript Function
I am calculating distance between 2 sets of lon / lat and the information is dynamic so I need to capture the values of the dynamic data and compare them to the values stored in a database table of which there may been to be several records tested against the values in the dynamic data Eg 1 set of co ordinate received from a device in the field data is received by the listener and needs to be tested against co ordinates recorded in the database table of which there may be several records needing to be tested against hence the need for the loop NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Paul Kukiel Sent: Thursday, 26 March 2015 1:02 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Help With Dynamic Naming A CfScript Function Why are you declaring functions inside a loop? On Thu, Mar 26, 2015 at 1:59 PM, rai...@ozemail.com.au mailto:rai...@ozemail.com.au wrote: Hi I have a cfscript where it is inside a loop function getDistance(loclat, loclon, fencelat, fencelon, units = 'kilometers') as its in a loop it throws an error as the function of same name is being declared multiple times when the loop as more than one record so how do I name the name dynamic I have tried function getDistance#id#(loclat, loclon, fencelat, fencelon, units = 'kilometers') but it throws errors any advice would be grateful NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- Paul Kukiel -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] Help With Dynamic Naming A CfScript Function
This is the code I am using /** * Calculates distance between Latitude/Longitude points using haversine formula. * * @param lat1latitude of first point (Required) * @param lon1longitude of first point (Required) * @param lat2latitude of second point (Required) * @param lon2longitude of second point (Required) * @param units Units for return value. Default is miles. (Optional) * @return Returns numeric distance between the two points. Units varies, default is miles. * @author Henry Ho (henryho...@gmail.com) * @version 0, January 8, 2013 */ function getDistance(lat1, lon1, lat2, lon2, units = 'miles') { // earth's radius. Default is miles. var radius = 3959; if (arguments.units EQ 'kilometers' ) radius = 6371; else if (arguments.units EQ 'feet') radius = 20903520; var toRad = pi() / 180; var dLat = (lat2-lat1) * toRad; var dLon = (lon2-lon1) * toRad; var a = sin(dLat/2)^2 + cos(lat1 * toRad) * cos(lat2 * toRad) * sin(dLon/2)^2; var c = 2 * createObject(java,java.lang.Math).atan2(sqr(a), sqr(1-a)); return radius * c; } Its wrapped inside a cfloop as I need to validate code received into our portal from mobile devices against data stored in the database hence the need to look around the data records from the query as often there will be more than 1 records to test against NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Thursday, 26 March 2015 1:26 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Help With Dynamic Naming A CfScript Function Right, but why do you need the name of the function to be dynamic? Why isn’t it enough that you pass in args within the loop (and declare the function outside of it)? /charlie From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au mailto:rai...@ozemail.com.au Sent: Wednesday, March 25, 2015 11:14 PM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: RE: [cfaussie] Help With Dynamic Naming A CfScript Function I am calculating distance between 2 sets of lon / lat and the information is dynamic so I need to capture the values of the dynamic data and compare them to the values stored in a database table of which there may been to be several records tested against the values in the dynamic data Eg 1 set of co ordinate received from a device in the field data is received by the listener and needs to be tested against co ordinates recorded in the database table of which there may be several records needing to be tested against hence the need for the loop Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] receiving large amounts of data via http post possibly simultaneously at times
Hi Charlie The potential of different servers who are independent of each other each sending http requests to my server potentially minutes, seconds or even simultaneously So basically my question revolves around cf load capacity during times of such heavy traffic Oh at present one thing to consider my cf server is operating in a Virtual Server shared CF hosted environment, naturally in time as the demand for the application grows it will be possible to move to a dedicated cf hosted environment Hope the above sheds some light NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Thursday, 5 March 2015 12:30 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] receiving large amounts of data via http post possibly simultaneously at times Claude, I’d be curious what you mean by “different sources” posting to a single request? Even within an ajax-based page, each separate call to a CF page is a separate request. So I’m not aware of a way that a given CF page (or even any web technology) can receive multiple concurrent posts from “different sources”. But maybe if you elaborate it could help me or others to better understand what you mean. Or perhaps someone else will already understand what you mean and offer a thought. /charlie From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au mailto:rai...@ozemail.com.au Sent: Wednesday, March 04, 2015 7:38 AM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: [cfaussie] receiving large amounts of data via http post possibly simultaneously at times Hi I am developing a app that will be receiving string data via http post its possible that there will be times where there is simultaneous posts being received from different sources, just wondering if anyone can advise the capacity of CF to be able to handle multiple packets of data as a http post Is there better more robust way in cf to be able to code the handler page to be able to reliably manage larger amounts of data received via http post possibly at times simultaneously Each packet of data receive would consist of around 30 parameters each time Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] receiving large amounts of data via http post possibly simultaneously at times
Hi Charlie, Thanks for your very detailed reply NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Thursday, 5 March 2015 5:38 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] receiving large amounts of data via http post possibly simultaneously at times OK, Claude, but to be clear, you had said “Is there better more robust way in cf to be able to code the handler page to be able to reliably manage larger amounts of data received via http post possibly at times simultaneously”. So are you saying it’s NOT “the handler page” handling “large amounts of data received…simultaneously”? That’s just a very different question than what you’re asking now, “cf load capacity during times of such heavy traffic”. CF can of course handle multiple simultaneous requests. You may know there’s a “max simultaneous requests” setting in the CF Admin, which defaults to 10, 25, or 50 depending on some factors (versions, editions), and of course you may have raised yours yourself. That setting, though, is not really “the answer” to the question or a solution if you hit a problem. That’s just the theoretical max is. It doesn’t mean CF *can* run that many, or that it ever would: - I’ve seen people raise that to 750, but with the right diagnostic tools I showed that they never had more than several truly “simultaneous” requests (running at the exact same millisecond), so they didn’t really need it to be higher than the defaults after all. - I’ve also seen people with CF set to 10 Max Simult Requests, and tools showed that they never got more than a couple to run at once and things bogged down, because of some other problem (so more was NOT the answer). - Or I’ve seen people have CF bog down only WHEN that limit was limit, and raising it helped more to run (that’s a relatively rare case, believe it or not) So the question is always, “if it bogs down, why?” It could be about configuration of CF, or of things CF talks to. It could be about your coding. It could be your traffic. It could be UNEXPECTED traffic that’s killing you (and maybe blocking or otherwise handling that is a solution). Sadly, this means (to your question) that no one (no one) will be able to tell you from the outside whether your server will be able to handle the traffic you are planning to send it. We don’t know your code, your config (of CF or the box, or things CF talks to), your traffic, and so much more. I realize people WANT that answer. I’d say simply that CF generally can handle FAR more traffic than most realize, if things are configured/coded well (and config is often far more important than coding, but the reverse CAN be true). And no, adding new instances is not always the answer (if they both rely on a shared resource which is itself the problem, then new instances won’t help with that). It just really depends on what the problem is, as to what the right solution would be. And I’ll say I’ve helped many people avoid upgrades to bigger or newer machines (and instances) by finding and resolving what was the real problem that made CF seem to bog down (and often, it was not CF after all but something else, and it was the victim, but without the right tools, folks can be left FEELING that CF is “down” and GUESSING at what might be the problem, and they may flail about trying different things they find on the web from folks who say “this worked for us”). All that said, really the only way to know if your app will work at some load in some config will be to do load testing (and even that can be tricky, if you’re not careful). Of course, someone could help you with that, or with troubleshooting when things go amiss. I keep a list of folks who do that sort of work, as a category of my CF411.com site, specifically cf411.com/cfconsult. Hope that’s helpful. /charlie PS Sorry for the long answer. I wonder how many will even get to this PS. :-) I hope at least you will, Claude. Sadly, while many prefer (and will offer) only twitter-length answers, I fear that’s what gets a lot of people in trouble or misled. There are just a lot of moving parts in such systems, and there’s rarely ever one right answer. With the right tools, processes, and experience (hired, if not available on your team) one can find a good answer for your own situation. From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au mailto:rai...@ozemail.com.au Sent: Wednesday, March 04, 2015 2:11 PM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: RE: [cfaussie] receiving large amounts of data via
[cfaussie] receiving large amounts of data via http post possibly simultaneously at times
Hi I am developing a app that will be receiving string data via http post its possible that there will be times where there is simultaneous posts being received from different sources, just wondering if anyone can advise the capacity of CF to be able to handle multiple packets of data as a http post Is there better more robust way in cf to be able to code the handler page to be able to reliably manage larger amounts of data received via http post possibly at times simultaneously Each packet of data receive would consist of around 30 parameters each time NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] Creating A String With ## values in coldfusion
cfset delim = chr(35) / cfset mycommand= delim + 'reboot' + delim + delim + url.imei + delim + '1212' Generates the error The value # cannot be converted to a number. The error occurred in C:/home/svr.trackingcentral.com.au/wwwroot/mobile_apps/test.cfm: line 11 9 : body 10 : cfset delim = chr(35) / 11 : cfset mycommand= delim + 'reboot' + delim + delim + url.imei + delim + '1212' 12 : 13 : cfoutput#mycommand#/cfoutput NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Barry Beattie Sent: Monday, 2 March 2015 10:11 AM To: cfaussie Subject: Re: [cfaussie] Creating A String With ## values in coldfusion personally, I'd much prefer setting the # as a variable from the chr(x) function over replacing one string with another. Easily missed and there are ~ popping up unexpectedly... my 2c (from memory, YMMV) cfset delim = chr(35) / /** # as delim **/ cfset mycommand= delim + reboot + delim + delim + url.id http://url.id + delim + 1212 On Mon, Mar 2, 2015 at 9:53 AM, Blair McKenzie shi...@gmail.com mailto:shi...@gmail.com wrote: Another alternative - create the output with a substitute delimiter, like ~, and then use replace to change them to hashes. Blair On Mon, Mar 2, 2015 at 10:41 AM, Dale Fraser d...@fraser.id.au mailto:d...@fraser.id.au wrote: I would break it apart cfset mycommand=”##reboot###url.id###1212## http://url.id#%23%231212%23%23 ” To cfset mycommand = “##reboot##” url.id http://url.id “##1212##” / Regards Dale Fraser From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com ] On Behalf Of Jack Traynor Sent: Monday, 2 March 2015 8:54 AM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: Re: [cfaussie] Creating A String With ## values in coldfusion I copy + pasted the code from your email into a CF10 test page and added /?id=100 to the URL and it worked as you expected it to. Do you have an example of an ID? What error are you getting? Regards, Jack On Mon, Mar 2, 2015 at 2:22 AM, M@ Bourke m.electronic.at.sym...@gmail.com mailto:m.electronic.at.sym...@gmail.com wrote: how about something like cfset mycommand=”##reboot##+ http://url.id/#%23%231212%23%23 url.id +##1212##” On Sun, Mar 1, 2015 at 3:16 PM, rai...@ozemail.com.au mailto:rai...@ozemail.com.au wrote: Hi This has been causing me grief so some assistance would be appreciated I need to be able to create a ColdFusion variable that contains the following text “#reboot#45454#1212#” The values of “#reboot#” and “#1212#” are constant however the value of 45454 is dynamically generated from the url parameter passed to the page So the actual CF code should look something like: cfset mycommand=”##reboot###url.id###1212## http://url.id#%23%231212%23%23 ” So that the ## output a single # No matter what I try I cannot get it to work, even tried using a evaluate(url.id http://url.id ) but that gave no joy either NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email
RE: [cfaussie] Creating A String With ## values in coldfusion
Hi Barry When I try cfset delim = chr(35) / cfset tempData[command]= delim + 'reboot' + delim + delim + url.imei + delim + '1212' Without the “ at start and end I get an error message cannot sum # With “ at start and end all that is passed is delim Some background the code is in a cfc that my iphone app calls to generate a dynamic value that is passed back to the iphone code and then the iphone code outputs the value in the body of an sms Now the process works perfectly and the sms is created as required for all other command its just now that I am needing to include the # which conflicts with cf that a problem has risen NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Barry Beattie Sent: Monday, 2 March 2015 10:11 AM To: cfaussie Subject: Re: [cfaussie] Creating A String With ## values in coldfusion personally, I'd much prefer setting the # as a variable from the chr(x) function over replacing one string with another. Easily missed and there are ~ popping up unexpectedly... my 2c (from memory, YMMV) cfset delim = chr(35) / /** # as delim **/ cfset mycommand= delim + reboot + delim + delim + url.id http://url.id + delim + 1212 On Mon, Mar 2, 2015 at 9:53 AM, Blair McKenzie shi...@gmail.com mailto:shi...@gmail.com wrote: Another alternative - create the output with a substitute delimiter, like ~, and then use replace to change them to hashes. Blair On Mon, Mar 2, 2015 at 10:41 AM, Dale Fraser d...@fraser.id.au mailto:d...@fraser.id.au wrote: I would break it apart cfset mycommand=”##reboot###url.id###1212## http://url.id#%23%231212%23%23 ” To cfset mycommand = “##reboot##” url.id http://url.id “##1212##” / Regards Dale Fraser From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com ] On Behalf Of Jack Traynor Sent: Monday, 2 March 2015 8:54 AM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: Re: [cfaussie] Creating A String With ## values in coldfusion I copy + pasted the code from your email into a CF10 test page and added /?id=100 to the URL and it worked as you expected it to. Do you have an example of an ID? What error are you getting? Regards, Jack On Mon, Mar 2, 2015 at 2:22 AM, M@ Bourke m.electronic.at.sym...@gmail.com mailto:m.electronic.at.sym...@gmail.com wrote: how about something like cfset mycommand=”##reboot##+ http://url.id/#%23%231212%23%23 url.id +##1212##” On Sun, Mar 1, 2015 at 3:16 PM, rai...@ozemail.com.au wrote: Hi This has been causing me grief so some assistance would be appreciated I need to be able to create a ColdFusion variable that contains the following text “#reboot#45454#1212#” The values of “#reboot#” and “#1212#” are constant however the value of 45454 is dynamically generated from the url parameter passed to the page So the actual CF code should look something like: cfset mycommand=”##reboot###url.id###1212## http://url.id#%23%231212%23%23 ” So that the ## output a single # No matter what I try I cannot get it to work, even tried using a evaluate(url.id http://url.id ) but that gave no joy either NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie
RE: [cfaussie] Creating A String With ## values in coldfusion
Thanks Charlie As Always a clear and detailed reply NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Monday, 2 March 2015 11:40 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Creating A String With ## values in coldfusion And Claude, besides confirming Cassie’s observation that you needed to use and not +, I had wondered if Dale’s first answer might have done the trick even more simply. You never seemed to reply to that: cfset mycommand = “##reboot##” url.id “##1212##” / That covers the escaping of the hashes, and the concatenation of the variable (which as many have noted, requires in CFML, not +). And indeed, I just ran the code that way: cfparam name=url.id default=45454 cfset mycommand = ##reboot## url.id ##1212## / (the cfparam simply allows the page to be run even if no querystring is passed initially), and it output: #reboot#45454#1212# And to prove that it worked as a true URL variable, I ran it as this: http://localhost/test.cfm?id=45455 and it output: #reboot#45455#1212# That seems what you want, right? (Of course, you say you want that in the variable, and this gives you that. What you may do with the value next, and how that may go, is another question.) And FWIW, Dale’s second answer also would have worked, though it rather than 2 chr’s only one is needed, to produce that same output as above: cfparam name=url.id default=45454 cfset delim = chr(35) / cfset mycommand= delim reboot delim url.id delim 1212 delim / cfoutput#mycommand#/cfoutput Hope that’s helpful. /charlie From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Cassie Woolley Sent: Sunday, March 01, 2015 7:51 PM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: RE: SPAM-LOW: RE: [cfaussie] Creating A String With ## values in coldfusion I think it should be and not +. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] Creating A String With ## values in coldfusion
Hi Charlie Yes solved from a CF perspective however as the issue appears to be the user of the # appended to a url within I-Phone App development environment NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Monday, 2 March 2015 1:33 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Creating A String With ## values in coldfusion Happy to help, and thanks for the kind regards. And we’ll assume you’re all set then. :-) /charlie From: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au mailto:rai...@ozemail.com.au Sent: Sunday, March 01, 2015 9:17 PM To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com Subject: RE: [cfaussie] Creating A String With ## values in coldfusion Thanks Charlie As Always a clear and detailed reply Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie] Creating A String With ## values in coldfusion
Hi This has been causing me grief so some assistance would be appreciated I need to be able to create a ColdFusion variable that contains the following text #reboot#45454#1212# The values of #reboot# and #1212# are constant however the value of 45454 is dynamically generated from the url parameter passed to the page So the actual CF code should look something like: cfset mycommand=##reboot###url.id###1212## So that the ## output a single # No matter what I try I cannot get it to work, even tried using a evaluate(url.id) but that gave no joy either NB: TrackingCentral is now a registered product services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie] Using CF Report Builder
Hi I am using CF report builder to build invoices The challenge I have is that some of the items in the invoice may have supporting comments to be displayed under each invoice items Sometimes there will be no comments other times there will be comments that could be 1 line long or potentially 20 lines long The challenge I find is that if I create the text box that is big enough to display the let's say 20 line comment then that space exists under every other item regardless of whether it's a 20 line comment or 0 or 1 or 2 line comment What I am trying to achieve is to have the items flow on the page so when there is comments the necessary space is provided under invoice line item and when there is no comments then the next invoice item appear directly under the previous item without any additional blank lines Any advice re the above would be appreciated Regards Claude Raiola SAMARIS Software -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie]
Yes I know this is not directly related to CF however I am wondering if any of you know of a experienced and reliable java developer that would be interested in a very small project to add some java code to an existing java application that has been developed and working NB: TrackingCentral is now a registered product and services provider for the National Disability Insurance Scheme, under the category of Assisted Technology. Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie] cfmap Bing / Google Maps
Hi Just wondering if CFmap works with Bing Maps accounts as well as Google Maps and if not is there any noise about Bing Maps being useable in the future NB: TrackingCentral is now a registered product and services provider for the National Disability Insurance Scheme, under the category of Assisted Technology. Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
RE: [cfaussie] cfmap Bing / Google Maps
Thanks let's hope others will contribute to advise if Bing is able to be used at the moment and if not is there any plan for it in the future Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Barry Beattie Sent: Friday, 16 May 2014 9:48 AM To: cfaussie Subject: Re: [cfaussie] cfmap Bing / Google Maps great question: I'm seeing more and more Bing maps being incorporated into services (eg: Facebook events). As a member of the public, I'm biased towards Google Maps but I'm conscious of the trend. On Fri, May 16, 2014 at 9:42 AM, rai...@ozemail.com.au wrote: Hi Just wondering if CFmap works with Bing Maps accounts as well as Google Maps and if not is there any noise about Bing Maps being useable in the future NB: TrackingCentral is now a registered product and services provider for the National Disability Insurance Scheme, under the category of Assisted Technology. Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie] CFSocket Event Gateway Task Needed
Hi I need someone to create a cfsocket event gateway for me that does the following: 1. listens for the TCP incoming packets on a pre defined port (port number referenced in config file to allow me flexibility to change port number if need be) 2. reads the value in the packet that's is located as item 3 in the csv string 3. take the value of the item in step 2 and queries the database table for a matching record 4. if matching record is found in step 3 it adds the content of the packet into a database table 5. if matching record is not found in step 3 the packet receive is ignored For someone with advanced cf skills I am sure the above would not take long, I just do not have the time to research and learn how to setup the cfsocket gateway to achieve the above Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
[cfaussie] CFSocket Reading / Storing Reusing SocketID
Hi All I have built a GPS Tracking Server using CF and it has a Java Listener written to listen for incoming packets being sent to the server. The packets are received and stored into a specific sql table and then I have a cold fusion page that runs after each packet it received to further process the data received and all that works perfectly I also have socket script that sends tcp packets to an external server ever 60 seconds where the server then sends a response back to the packet received in order to acknowledge that the packet has been successfully received by the external server, that too works like a charm Here is my challenge My gprs devices can send heartbeat tcp packets to the server at set intervals eg every 5 minutes, The heartbeat packet sends a unique identifier to the server that identifies the specific device the packet has been sent from I need to be able to keep the socket connection open for that 5 minutes and store the socket id along with the unique identifier (IMEI number)in a database table. Each time a new heartbeat is received from a specific device the table is updated with the latest socket id associated with that imei number. Example being Device sends the heartbeat packet periodically, the user of the device wants to send an update command to the device via GPRS therefore they log onto the portal and send the command via the portal interface. The portal then knows the imei number of users device, looks up the table to fund the imei and its corresponding (current open socketid and then sends the packet data to the device using said socket id Can anyone shed some light on how to achieve the above and or know of any sample code that may already perform the above function of being able to read the socketid used to received an incoming packet and then be able to reuse that same open socket to send other data back to the device I welcome your assistance re the above Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. image001.gif
[cfaussie] CFSocket Reading / Storing Reusing SocketID
Hi All I have built a GPS Tracking Server using CF and it has a Java Listener written to listen for incoming packets being sent to the server. The packets are received and stored into a specific sql table and then I have a cold fusion page that runs after each packet it received to further process the data received and all that works perfectly I also have socket script that sends tcp packets to an external server ever 60 seconds where the server then sends a response back to the packet received in order to acknowledge that the packet has been successfully received by the external server, that too works like a charm Here is my challenge My gprs devices can send heartbeat tcp packets to the server at set intervals eg every 5 minutes, The heartbeat packet sends a unique identifier to the server that identifies the specific device the packet has been sent from I need to be able to keep the socket connection open for that 5 minutes and store the socket id along with the unique identifier (IMEI number)in a database table. Each time a new heartbeat is received from a specific device the table is updated with the latest socket id associated with that imei number. Example being Device sends the heartbeat packet periodically, the user of the device wants to send an update command to the device via GPRS therefore they log onto the portal and send the command via the portal interface. The portal then knows the imei number of users device, looks up the table to fund the imei and its corresponding (current open socketid and then sends the packet data to the device using said socket id Can anyone shed some light on how to achieve the above and or know of any sample code that may already perform the above function of being able to read the socketid used to received an incoming packet and then be able to reuse that same open socket to send other data back to the device I welcome your assistance re the above Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. image001.gif
[cfaussie] CFSocket: Outgoing TCP Packet Needs To be sent on specific Port
Hi I have a CF application that has a listener written in Java to listen for inbound TCP packets on a specific port I am also using a CF Socket script to send out TCP packets to a third party server sending the packets to a static IP and port where the third party server's listener is monitoring The third party server receives the TCP Packet and opens the connection, their system then sends back an acknowledge TCP packet back to my server, it uses the ip address and port my server used to the initial packet to it to then send the ack packet back to my server. The problem is that each time my app sends a TCP packet to the third party sever its uses a random port selected by my server, and not the port that I have my listener operating on, hence my server never detects the incoming ack packet response from the third party server as its not sent to my listener port The question is how do I set the port (the port my listener is set on) in my CF page uses so that it always sends using that port so that when their server sends the ACK my server receives it on my listener port. Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] Concerting ASPX to CF
Hi Does anyone know where I can find info on taking ASP code and converting to CFM Has anyone had any experience in doing so and if so is it a relatively simple process or would it be easier to simply re code the pages in cf from scratch Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] CFAussie Posts Are Very Occasional
Hi Wondering if this user group is still active as I seem to only receive the occasional post every now and then often nothing for over a week, in the past its been far more regular activity ?? Is there a more active user group that I am not aware of ??? Kind Regards Claude Raiola SAMARIS Software -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] Seeking Cold Fusion Programming Projects Working Remote Based In Brisbane
Hi All I am currently seeking further Cold Fusion programming projects to work, as I am based in Brisbane I would be looking to work remotely on said projects If any of you have a need for a CF programmer please let me know i...@samaris.net You can also read about my experience and testimonials from my website www.SAMARIS.net Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] dateformat with cfinput type=datefield
Hi I am using cfinput type=datedfield value=today I am using the datefield to it provides the date picker however I want the current date displayed as default, however its displaying in the us format with mm/dd/yy, how can I make the format display dd/mm/yy When I use cfinput type=date value=today it only displays the values dd/mm/ in the date field by default even if I place the current date value in the value= so that's why I have reverted to use the above but the format of the date needs to be dd mm Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] CF Report Builder
Hi I am using the following in CF report builder display dynamic data in the report itself 1 ' - 'item_description' IMEI No: 'imei the above outputs without error However if I add an if statement 2cfif imei 0imei/cfif The above generates an error advising variable imei is not defined Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] CF Hosting With Direct Server Port Access For incoming UDP Data Packets
Hi Yes I am currently using Hostek as well Had some outages with them for over 12 hours when the website was down which was a great concern hence me looking at other possible options Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Daniel Punton Sent: Monday, 15 July 2013 11:29 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Digest for cfaussie@googlegroups.com - 1 Message in 1 Topic Try hostek in the states. They're cheap, responsive and cf knowledgeable. http://hostek.com/hosting/coldfusion/coldfusion-hosting.asp d On 15 July 2013 11:15, cfaussie@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/cfaussie/topics http://groups.google.com/group/cfaussie/topics § CF Hosting With Direct Server Port Access For incoming UDP Data Packets [1 Update] http://groups.google.com/group/cfaussie/t/38b7e66b090fc713 CF Hosting With Direct Server Port Access For incoming UDP Data Packets rai...@ozemail.com.au Jul 15 09:12AM +1000 Hi I am searching for a reliable and non overly expensive CF Hosting Solution for my Personal Safety Monitoring portal I am developing. The server needs to have a 90%+ uptime SLA as the users of the system have their mobile devices send event data to the server which then issues alerts where appropriate Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] CF Hosting With Direct Server Port Access For incoming UDP Data Packets
Hi I am searching for a reliable and non overly expensive CF Hosting Solution for my Personal Safety Monitoring portal I am developing. The server needs to have a 90%+ uptime SLA as the users of the system have their mobile devices send event data to the server which then issues alerts where appropriate Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] converting date string into sql date format in cf
Hi I have date in the following format stored in a sql database table what's the most efficient way to convert it into proper date time format with cf example: 20130713061044 Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] String Manipulation
Hi I am trying to figure our the best way to manipulate the value using CF so I insert : after ever 2 characters as in converting 1Z0617756740260660 to 1Z:06:17:75:67:40:26:06:60 Any suggestions would be appreciated Kind Regards Claude Raiola Director logo_new TrackingCentral Pty Ltd (A.C.N. 150 409 180) Web: www.TrackingCentral.com.au http://www.trackingcentral.com.au/ Email: i...@trackingcentral.com.au Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. image001.gif
RE: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax
Hi Charlie I trust the following will clear up any confusion I have data from mobile devices being sent to my server The listener captures the packet as a record in database table and the content of the packet is stored in a column the database table. This table become my raw data / log table of all incoming data I then need to run a process to determine the value of the imei number that is included in each packet of data (the packet data is csv string format), the imei number tells me which device the data has been sent from. The issue is that different packets received from different devices have their imei number located in different positions within the packet data being sent Given each imei number is of a set length ( 15 characters ) and only contains numeric characters of 0-9 I am trying to determine the best way to find the value of the imei number in each packet received given the position in the string will not always be at the same location within the string Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Friday, 5 July 2013 8:44 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax Claude, you don't mention how you are reading the csv in, in the first place. Are you using CFFILE or another function to read the entire file in, and then trying to loop over it? Have you instead tried using CFHTTP? Many don't know it but that has long had the ability to read in a CSV and convert it to a query (created using the NAME attribute). Once done, you can easily access the rows and columns, including using SQL to do a query of queries, to do filtering or other manipulation. (If you already know of this use of CFHTTP, had you had any luck in using Q of Q to do the manipulation you seek?) The only challenge with using CFHTTP for this is that the CSV file in question does need to be in a web-accessible directory, as you still have to use a URL to point to the CSV. But if that's not an issue or can be resolved, you may be surprised the power if you've never seen/used it. The tag has a few attributes to control things like whether the first line has a header row, what delimiter and qualifier to use (if other than a comma and double-quotes), and more. The feature is documented in Developer's guide: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec1529c-7fff.html While it's mentioned in the CFML Reference page for CFHTTP, curiously the key attributes for this capability are not mentioned in the initial table of attributes (as seems more typical). Instead, they are listed in a separate table down the page (search for the text, convert the HTTP response body into a ColdFusion query object, as there is no section header for it): http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08 11cbec22c24-7ffc.html Finally, here's an example that shows both reading a CSV and processing it with Q of Q (it's listed oddly in a section on using the Cast function for Q of Q): http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec0e4fd-7ff0.html#WSc3ff6d0ea77859461172e0811cbec22c24-7b7b Hope that helps someone, even if not you, Claude. But if it does not, what aspect still fails to be resolved? It wasn't quite clear from your note (or your subsequent replies to others here). /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Thursday, July 04, 2013 9:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax Hi I have a csv data set with each record contains a set of comma separated values I am trying to write cf code to interrogate each record to find the value in the set of comma seated values that meets a specific character set In the examples below you can see the value 868487001009190 is located in position 3 of the first record and position 2 in the second record Record 1: '+RESP:GTSTT,070106,868487001009190,GT500,41,0,0.0,0,14.7,153.035960,-27.471 336,20130704121354,0505,0002,1B8D,A281,00,006064939682,-66,20130704122355,07 58$' record 2: '+RESP:GTTRI, 868487001009190,1,0,0,0,0.2,148,6.4,3,153.034551,-27.471390,20130610110953,0 505,0002,1B6B,A281,00,0012,0103090402' Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http
RE: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax
Thank Paul I have it sorted Its possibly not the cleanest way but it works cfset imei_pos = reFindNoCase([0-9]{15}, raw) cfset before_imei =left(raw,imei_pos) cfset comma_count = listlen(before_imei) cfset imei = ListGetAt(raw,comma_count,,) Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: Paul Kukiel [mailto:kuki...@gmail.com] Sent: Sunday, 7 July 2013 6:35 PM To: rai...@ozemail.com.au Subject: Re: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax If you send me a few samples perhaps I can help? Paul Kukiel | CTO IMG Sports Technology Group 600 Victoria Street Richmond 3121 Victoria Australia P +61 3 9426 2600 M +61 (0) 403 218 804 pkuk...@imgstg.com http://www.imgstg.com On 07/07/2013, at 4:09 PM, rai...@ozemail.com.au wrote: Hi Charlie I trust the following will clear up any confusion I have data from mobile devices being sent to my server The listener captures the packet as a record in database table and the content of the packet is stored in a column the database table. This table become my raw data / log table of all incoming data I then need to run a process to determine the value of the imei number that is included in each packet of data (the packet data is csv string format), the imei number tells me which device the data has been sent from. The issue is that different packets received from different devices have their imei number located in different positions within the packet data being sent Given each imei number is of a set length ( 15 characters ) and only contains numeric characters of 0-9 I am trying to determine the best way to find the value of the imei number in each packet received given the position in the string will not always be at the same location within the string Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Friday, 5 July 2013 8:44 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax Claude, you don’t mention how you are reading the csv in, in the first place. Are you using CFFILE or another function to read the entire file in, and then trying to loop over it? Have you instead tried using CFHTTP? Many don’t know it but that has long had the ability to read in a CSV and convert it to a query (created using the NAME attribute). Once done, you can easily access the rows and columns, including using SQL to do a query of queries, to do filtering or other manipulation. (If you already know of this use of CFHTTP, had you had any luck in using Q of Q to do the manipulation you seek?) The only challenge with using CFHTTP for this is that the CSV file in question does need to be in a web-accessible directory, as you still have to use a URL to point to the CSV. But if that’s not an issue or can be resolved, you may be surprised the power if you’ve never seen/used it. The tag has a few attributes to control things like whether the first line has a header row, what delimiter and qualifier to use (if other than a comma and double-quotes), and more. The feature is documented in Developer’s guide: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec1529c-7fff.html While it’s mentioned in the CFML Reference page for CFHTTP, curiously the key attributes for this capability are not mentioned in the initial table of attributes (as seems more typical). Instead, they are listed in a separate table down the page (search for the text, “convert the HTTP response body into a ColdFusion query object”, as there is no section header for it): http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ffc.html Finally, here’s an example that shows both reading a CSV and processing it with Q of Q (it’s listed oddly in a section on using the Cast function for Q of Q): http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html#WSc3ff6d0ea77859461172e0811cbec22c24-7b7b Hope that helps someone, even if not you, Claude. But if it does not, what aspect still fails to be resolved? It wasn’t quite clear from your note (or your subsequent replies to others here). /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Thursday, July 04, 2013 9:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax Hi I have a csv data set with each record contains a set of comma separated values I am trying to write cf code to interrogate each record to find the value in the set of comma
[cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax
Hi I have a csv data set with each record contains a set of comma separated values I am trying to write cf code to interrogate each record to find the value in the set of comma seated values that meets a specific character set In the examples below you can see the value 868487001009190 is located in position 3 of the first record and position 2 in the second record Record 1: '+RESP:GTSTT,070106,868487001009190,GT500,41,0,0.0,0,14.7,153.035960,-27.471 336,20130704121354,0505,0002,1B8D,A281,00,006064939682,-66,20130704122355,07 58$' record 2: '+RESP:GTTRI, 868487001009190,1,0,0,0,0.2,148,6.4,3,153.034551,-27.471390,20130610110953,0 505,0002,1B6B,A281,00,0012,0103090402' Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
RE: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax
Hi I think you misunderstand I will not know what the values of the 15 character numbers are, that's the objective finding the 15 character numbers to the ne able to determine what the actual number value is which will be different for each record Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of M@ Bourke Sent: Friday, 5 July 2013 12:03 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax ListFindNoCase() ?? On Thu, Jul 4, 2013 at 2:35 PM, rai...@ozemail.com.au wrote: Hi I have a csv data set with each record contains a set of comma separated values I am trying to write cf code to interrogate each record to find the value in the set of comma seated values that meets a specific character set In the examples below you can see the value 868487001009190 is located in position 3 of the first record and position 2 in the second record Record 1: '+RESP:GTSTT,070106,868487001009190,GT500,41,0,0.0,0,14.7,153.035960,-27.471 336,20130704121354,0505,0002,1B8D,A281,00,006064939682,-66,20130704122355,07 58$' record 2: '+RESP:GTTRI, 868487001009190,1,0,0,0,0.2,148,6.4,3,153.034551,-27.471390,20130610110953,0 505,0002,1B6B,A281,00,0012,0103090402' Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
RE: SPAM-HIGH: [cfaussie] Getting CF to read XML data
Worked like a charm thanks Much appreciated Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Sunday, 16 June 2013 12:49 AM To: cfaussie@googlegroups.com Subject: RE: SPAM-HIGH: [cfaussie] Getting CF to read XML data Hey Claude, while the xmlsearch could and should work, I'd propose that there are other ways to access XML data which may help, especially array/struct notation and/or functions. Since you don't mention them, I'd like to propose you consider those. For instance, how about: cfset AddressNodes = MyXMLDoc.Response.ResourceSets.ResourceSet.Resources.Location.Address cfdump var=#AddressNodes# If that doesn't work, just keep removing elements from the right until the works, and sort out from the dump what you need to use. If that's not enough info, I'll note that there are more resources to help with processing XML in CFML, not least of which is the Developer's Guide (which many miss, if they know only of the CFML Reference), as well as a great PDF on XML processing in CF which Nate Weiss did over 10 years ago, but which still mostly applies and in my mind is the best first place to start. I did a blog entry a couple of years ago pointing to these resources: http://www.carehart.org/blog/client/index.cfm/2011/5/10/where_to_learn_CFMLs _XML_capabilities Let us know if any of the above helps. /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Saturday, June 15, 2013 1:47 AM To: cfaussie@googlegroups.com Subject: RE: SPAM-HIGH: [cfaussie] Getting CF to read XML data Hi Cassie and Kai, Yes bloody typo's so I have change the code so reflect the structure however still there is no output cfset MyXMLDoc = xmlParse(cfhttp.FileContent) cfset AddressNodes = xmlSearch(MyXMLDoc,'/Response/ResourceSets/ResourceSet/Resources/Location/Ad dress') cfdump var=#AddressNodes# Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] Getting CF to read XML data
xml document [short version] Response XmlText XmlAttributes struct xmlns http://schemas.microsoft.com/search/local/ws/rest/v1 xmlns:xsd http://www.w3.org/2001/XMLSchema xmlns:xsi http://www.w3.org/2001/XMLSchema-instance Copyright XmlText Copyright C 2013 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation. BrandLogoUri XmlText http://dev.virtualearth.net/Branding/logo_powered_by.png StatusCode XmlText 200 StatusDescription XmlText OK AuthenticationResultCode XmlText ValidCredentials TraceId XmlText 8ef773a25de8461586e09dc455336674|SN1M99|02.00.150.1300|SN1MSNVM001335, SN1MSNVM001334 ResourceSets XmlText ResourceSet XmlText EstimatedTotal XmlText 1 Resources XmlText Location XmlText Name XmlText 23 Pixley St, Kangaroo Point, QLD 4169 Point XmlText Latitude XmlText -27.471384555101395 Longitude XmlText 153.03484484553337 BoundingBox XmlText SouthLatitude XmlText -27.475247272672071 WestLongitude XmlText 153.02904021337523 NorthLatitude XmlText -27.467521837530718 EastLongitude XmlText 153.04064947769152 EntityType XmlText Address Address XmlText AddressLine XmlText 23 Pixley St AdminDistrict XmlText QLD CountryRegion XmlText Australia FormattedAddress XmlText 23 Pixley St, Kangaroo Point, QLD 4169 Locality XmlText Kangaroo Point PostalCode XmlText 4169 Confidence XmlText Medium MatchCode XmlText Good GeocodePoint XmlText Latitude XmlText -27.471384555101395 Longitude XmlText 153.03484484553337 CalculationMethod XmlText Interpolation UsageType XmlText Display UsageType XmlText Route array [empty] I am trying to capture the address details in the above xml file I have tried the following code however it returns no data # cfset MyXMLDoc = xmlParse(cfhttp.FileContent) !--- Get AdressNodes --- cfset AddressNodes = xmlSearch(MyXMLDoc,'Response/ResourceSets/ResourceSets/Resources/Address') cfdump var=#AddressNodes# # Any advise on what I am doing wrong would be appreciated Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
RE: SPAM-HIGH: [cfaussie] Getting CF to read XML data
Hi Cassie and Kai, Yes bloody typo's so I have change the code so reflect the structure however still there is no output cfset MyXMLDoc = xmlParse(cfhttp.FileContent) cfset AddressNodes = xmlSearch(MyXMLDoc,'/Response/ResourceSets/ResourceSet/Resources/Location/Ad dress') cfdump var=#AddressNodes# Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Cassie Woolley Sent: Saturday, 15 June 2013 2:49 PM To: cfaussie@googlegroups.com Subject: RE: SPAM-HIGH: [cfaussie] Getting CF to read XML data At first glance, you have ResourceSets twice. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Saturday, 15 June 2013 2:41 PM To: cfaussie@googlegroups.com Subject: SPAM-HIGH: [cfaussie] Getting CF to read XML data xml document [short version] Response XmlText XmlAttributes struct xmlns http://schemas.microsoft.com/search/local/ws/rest/v1 xmlns:xsd http://www.w3.org/2001/XMLSchema xmlns:xsi http://www.w3.org/2001/XMLSchema-instance Copyright XmlText Copyright C 2013 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation. BrandLogoUri XmlText http://dev.virtualearth.net/Branding/logo_powered_by.png StatusCode XmlText 200 StatusDescription XmlText OK AuthenticationResultCode XmlText ValidCredentials TraceId XmlText 8ef773a25de8461586e09dc455336674|SN1M99|02.00.150.1300|SN1MSNVM001335, SN1MSNVM001334 ResourceSets XmlText ResourceSet XmlText EstimatedTotal XmlText 1 Resources XmlText Location XmlText Name XmlText 23 Pixley St, Kangaroo Point, QLD 4169 Point XmlText Latitude XmlText -27.471384555101395 Longitude XmlText 153.03484484553337 BoundingBox XmlText SouthLatitude XmlText -27.475247272672071 WestLongitude XmlText 153.02904021337523 NorthLatitude XmlText -27.467521837530718 EastLongitude XmlText 153.04064947769152 EntityType XmlText Address Address XmlText AddressLine XmlText 23 Pixley St AdminDistrict XmlText QLD CountryRegion XmlText Australia FormattedAddress XmlText 23 Pixley St, Kangaroo Point, QLD 4169 Locality XmlText Kangaroo Point PostalCode XmlText 4169 Confidence XmlText Medium MatchCode XmlText Good GeocodePoint XmlText Latitude XmlText -27.471384555101395 Longitude XmlText 153.03484484553337 CalculationMethod XmlText Interpolation UsageType XmlText Display UsageType XmlText Route array [empty] I am trying to capture the address details in the above xml file I have tried the following code however it returns no data # cfset MyXMLDoc = xmlParse(cfhttp.FileContent) !--- Get AdressNodes --- cfset AddressNodes = xmlSearch(MyXMLDoc,'Response/ResourceSets/ResourceSets/Resources/Address') cfdump var=#AddressNodes# # Any advise on what I am doing wrong would be appreciated Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality
Hi Zac Thanks for your reply If you have any suggestions on the best way to record geo fence zones with z radius so that the system can then detect whenever a given reported location is inside / outside of a given zone I would appreciate it I am using the Bing mapping api and I am developing the tracking portal app in CF Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 June 2013 3:07 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality SQL Server 2008 also supports proper spatial? On Wed, Jun 5, 2013 at 2:19 PM, Robin Hilliard ro...@rocketboots.com.au wrote: Hi Claude, Funny, happened to have some CF code to check for polygon containment open when I saw your post: function polyContains(poly, lon, lat) { var j = 1; var oddNodes = false; var lenPoly = arrayLen(poly); for (var i = 1; i lenPoly; i += 2) { j = i + 2; if (j lenPoly - 2) j = 1; if (((poly[i + 1] lat) != (poly[j + 1] lat)) // the polygon edge passes through the lattitude lat and lat - poly[i + 1]) * (poly[j] - poly[i])) / (poly[j + 1] - poly[i + 1])) lon)) // at lattitude lat, polygon edge is west of lon oddNodes = !oddNodes; } return oddNodes; }; I'm using this because MySQL spatial polygon containment only compares bounding boxes (on the version supported by Redhat). MySQL whittles the list down to a few polygons and I use this to do the rest, based on the odd/even polygon containment test. Note that poly is a flat array containing lon lat pairs. I'm currently running some tests on a database of about 5,000 polygons covering SE Australia, sampling every one km grid. There are a few anomalies I'm investigating, hopefully it's the data and not an algorithm glitch but you have been warned. Robin ROBIN HILLIARD Chief Technology Officer ro...@rocketboots.com.au RocketBoots Pty Ltd Level 11 189 Kent Street Sydney NSW 2001 Australia Phone +61 2 9323 2507 Facsimile +61 2 9323 2501 Mobile +61 418 414 341 www.rocketboots.com.au http://www.rocketboots.com.au/ On 04/06/2013, at 7:58 PM, rai...@ozemail.com.au wrote: I have the Tracking Server with listener set up so the listener captures the data (long / lat) sent from the mobile tracking devices to the server, which is then stored into an sql table I have the Bing Maps API set up so the locations stored in the above database table correctly display on the bing map The challenge is trying to figure out how to create Geo Fence functionality combining SQL 2008, using Bing Maps API and using CF application to manage and display the Geo Fences I am wanting to be able to create circular zones so the co ordinates are saved in the geo fence table assigned to a specific device id, Once the geo fences are created and stored in the geo fence table each new location sent to the tracking server then needs to be validated against existing geo fences to determine if the new location is inside or outside of geo fences listed in the geo fence table If anyone can assist to direct me to a resource or example code that deal with the above I would appreciate the advise Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to mailto:cfaussie+unsubscr...@googlegroups.com cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to mailto:cfaussie@googlegroups.com cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received
RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality
Are your concerns re vendors api's only to give you the flexibility of changing backend at some later date with less hassle Also the STContains is that something I can use within my CF query, only every written very standard cf queries in the past so excuse me for asking the question if it appear a little novice Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 June 2013 5:22 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality you just need to create a table with the polygons, then you can use a built in function like STContains http://technet.microsoft.com/en-us/library/bb933904.aspx also, I would recommend considering avoiding using propriety vendor apis like google maps or bing, stick with something like flexible like openlayers or leafletJS so that you can easily swap backends On Wed, Jun 5, 2013 at 5:11 PM, rai...@ozemail.com.au wrote: Hi Zac Thanks for your reply If you have any suggestions on the best way to record geo fence zones with z radius so that the system can then detect whenever a given reported location is inside / outside of a given zone I would appreciate it I am using the Bing mapping api and I am developing the tracking portal app in CF Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 June 2013 3:07 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality SQL Server 2008 also supports proper spatial? On Wed, Jun 5, 2013 at 2:19 PM, Robin Hilliard ro...@rocketboots.com.au wrote: Hi Claude, Funny, happened to have some CF code to check for polygon containment open when I saw your post: function polyContains(poly, lon, lat) { var j = 1; var oddNodes = false; var lenPoly = arrayLen(poly); for (var i = 1; i lenPoly; i += 2) { j = i + 2; if (j lenPoly - 2) j = 1; if (((poly[i + 1] lat) != (poly[j + 1] lat)) // the polygon edge passes through the lattitude lat and lat - poly[i + 1]) * (poly[j] - poly[i])) / (poly[j + 1] - poly[i + 1])) lon)) // at lattitude lat, polygon edge is west of lon oddNodes = !oddNodes; } return oddNodes; }; I'm using this because MySQL spatial polygon containment only compares bounding boxes (on the version supported by Redhat). MySQL whittles the list down to a few polygons and I use this to do the rest, based on the odd/even polygon containment test. Note that poly is a flat array containing lon lat pairs. I'm currently running some tests on a database of about 5,000 polygons covering SE Australia, sampling every one km grid. There are a few anomalies I'm investigating, hopefully it's the data and not an algorithm glitch but you have been warned. Robin ROBIN HILLIARD Chief Technology Officer ro...@rocketboots.com.au RocketBoots Pty Ltd Level 11 189 Kent Street Sydney NSW 2001 Australia Phone +61 2 9323 2507 Facsimile +61 2 9323 2501 Mobile +61 418 414 341 www.rocketboots.com.au http://www.rocketboots.com.au/ On 04/06/2013, at 7:58 PM, rai...@ozemail.com.au wrote: I have the Tracking Server with listener set up so the listener captures the data (long / lat) sent from the mobile tracking devices to the server, which is then stored into an sql table I have the Bing Maps API set up so the locations stored in the above database table correctly display on the bing map The challenge is trying to figure out how to create Geo Fence functionality combining SQL 2008, using Bing Maps API and using CF application to manage and display the Geo Fences I am wanting to be able to create circular zones so the co ordinates are saved in the geo fence table assigned to a specific device id, Once the geo fences are created and stored in the geo fence table each new location sent to the tracking server then needs to be validated against existing geo fences to determine if the new location is inside or outside of geo fences listed in the geo fence table If anyone can assist to direct me to a resource or example code that deal with the above I would appreciate the advise Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to mailto:cfaussie+unsubscr...@googlegroups.com cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to mailto:cfaussie@googlegroups.com cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en http://groups.google.com/group/cfaussie?hl=en. For more options, visit https
[cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality
I have the Tracking Server with listener set up so the listener captures the data (long / lat) sent from the mobile tracking devices to the server, which is then stored into an sql table I have the Bing Maps API set up so the locations stored in the above database table correctly display on the bing map The challenge is trying to figure out how to create Geo Fence functionality combining SQL 2008, using Bing Maps API and using CF application to manage and display the Geo Fences I am wanting to be able to create circular zones so the co ordinates are saved in the geo fence table assigned to a specific device id, Once the geo fences are created and stored in the geo fence table each new location sent to the tracking server then needs to be validated against existing geo fences to determine if the new location is inside or outside of geo fences listed in the geo fence table If anyone can assist to direct me to a resource or example code that deal with the above I would appreciate the advise Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality
Hi Simon A GeoFence Table is a table that list all the GeoFences that have been created each record represents a different geo fence each with its own set of co ordinates that make up the GeoFence area Thanks for your response I will look into the reference you have provided Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 4 June 2013 10:25 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality I am not sure what the Geo Fence table actually is but either way to find if a location is inside or outside your fence it is simple if you have a closed polygon. You are looking to performa point-in-polygon test where an even result means the location is outside and an odd result means it is inside. Have a look at http://en.wikipedia.org/wiki/Point_in_polygon and in particular the ray-casting method. I have used this before and it is fast. Cheers, Simon On 4 June 2013 19:58, rai...@ozemail.com.au wrote: I have the Tracking Server with listener set up so the listener captures the data (long / lat) sent from the mobile tracking devices to the server, which is then stored into an sql table I have the Bing Maps API set up so the locations stored in the above database table correctly display on the bing map The challenge is trying to figure out how to create Geo Fence functionality combining SQL 2008, using Bing Maps API and using CF application to manage and display the Geo Fences I am wanting to be able to create circular zones so the co ordinates are saved in the geo fence table assigned to a specific device id, Once the geo fences are created and stored in the geo fence table each new location sent to the tracking server then needs to be validated against existing geo fences to determine if the new location is inside or outside of geo fences listed in the geo fence table If anyone can assist to direct me to a resource or example code that deal with the above I would appreciate the advise Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] ColdFusion Hosting With dedicated Port access for incoming UPD Packet Data
Hi, I am looking for an affordable CF hosting provider that will allow me to be assigned a dedicated port to receive incoming UDP packet data sent from portable devices used within the community. Naturally I need the service to be reliable with solid 98%+ uptime given the heavy reliance by the users of the portable devices on the data being received by the server in a reliable and timely manner. Potentially the server could be receiving UPD packets from 100's of devices at 10-15 minute intervals 24/7 I have looked at Web Central and the like however their solutions are well over $1,000 per month which is a little steep at this stage of the game. Any suggestions on suitable, hosting solutions given the above would be appreciated. Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] AutoSuggest Text Box
Hi am using the following code to benefit from the autosuggest feature cfinput type=textname=organisation_au autosuggest=#ValueList(aust_listorganisations.organisation)# size=50 however its currently passing the organisation name in the form when I need it to pass the orgid, however do I reference the matching orgid so the form passes the orgid rather than the orgname whilst displaying the org name in the autosuggest text box Regards Claude -- 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.
RE: [cfaussie] AutoSuggest Text Box
Hi Paul The current AutoSelect works fine however I just need to figure out how to tweek it so it can pass the orgid for the selected entry and not the displayed org name that is displayed in the text box as a result of the auto complete search Claude Raiola (B.Econ Acc; B.Hot. Mngt) SAMARIS Software Email: i...@samaris.net Website: www.SAMARIS.net FREE CALL: 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Paul Kukiel Sent: Thursday, 20 December 2012 3:29 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] AutoSuggest Text Box I would do this with jQuery here is a great example: http://jacktraynor.blogspot.com.au/2012/02/jquery-autocomplete-using-coldfus ion.html Regards, On 20/12/2012 4:06 PM, rai...@ozemail.com.au wrote: Hi am using the following code to benefit from the autosuggest feature cfinput type=textname=organisation_au autosuggest=#ValueList(aust_listorganisations.organisation)# size=50 however its currently passing the organisation name in the form when I need it to pass the orgid, however do I reference the matching orgid so the form passes the orgid rather than the orgname whilst displaying the org name in the autosuggest text box Regards Claude -- 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. -- 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. -- 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] Displaying Form Submit Button inside CFMail Content
Hi I have placed a cfform inside my cfmail tag When I open the email sent in outlook it displays the form button as [Click To Track] as shown below, and the [Click To Track] is pure text. Yes I am sending the cfmail type as html To track the progress of the package [Click To Track] When I open the same email using by iphone it shows the actual button which when I click on it processes the form any advise how I can get the form submit button to be functional when viewed with outlook from a normal PC rather than off a smart phone Regards Claude -- 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] CF Hosting Account
Hi All Can anyone recommend an economical CF Hosting Account preferably shared hosting (or if virtual dedicated) that will allow me to set up a CFSocket listener on a fixed port to capture incoming mobile location data from multiple mobile devices. The intent will be to place a Tracking software on the server account which with the aid of the listener capture and record the gps location data sent to the server from the mobile devices and then record said data into the sql database Claude Raiola (B.Econ Acc; B.Hot. Mngt) Director logo_new Tracking Central Pty. Ltd. ( A.C.N. 150 409 180 ) Email: mailto:i...@trackingcentral.om.au i...@trackingcentral.com.au Website: http://www.trackingcentral.com.au/ www.TrackingCentral.com.au FREE CALL: 1300 255 990 -- 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. image001.gif
RE: [cfaussie] CF Socket / Listener
Hi Zac You lost me with the comment re how dense the spatial boundaries are ??? The devices send to the server a text string containing all the relevant data, each piece of data comma separated an example being +RESP:GTSOS,01,861785008785465,TCSOSV,,,1,10,0.0,0,0,153.035933,-27.4716 69,2012080626,505,003,0FB9,B339,00,27,505,003,0FB9,B33A,20120806203133,0 003$ The above being an example of the data sent from the device to the server representing one location event. Naturally the manufacture provides a scheme in order to be able to defined what each value in the string represents My underlying concern is how the socket will handle lets same 100 packets of data received from 100 different devices simultaneously or within seconds of each other Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net Website: www.SAMARIS.net Mobile: 0414 228 948 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 September 2012 12:49 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Socket / Listener there's nothing really different about load when using cfsocket or using a normal webpage you just need to setup your app with processing and then load test, by using cfsocket, it's going to be a bit harder than using good old http, as I'm not sure if something like JMeter supports sockets as far as it goes for spatial processing, the biggest issue problem will be how dense your spatial boundaries are, if they are simple and coarse, they will be fast, but if they are denser, each request they will slow down - PostGIS is the fastest it's probably best to have two processes, one which receives and records them and another which processes in batches that data having no indexes on the incoming table will make receiving a lot faster On Thu, Aug 30, 2012 at 6:57 PM, Claude Raiola rai...@ozemail.com.au wrote: Hi Zac, The data needs to be processed as it is received as the information relates the locations of people, the data being transmitted from mobile gps personal location devices, which report their location at set intervals The information often needs to be validated against specific sets of gps co ordinates to allow for the portal to test whether the personal location device is within pre determined zones or else outside of the zones and depending on the answer processes and alerts may been to be triggered as a result So in short it needs to be in real time with a slight allowance for processing time, this allowance needs to be less than 120 seconds Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net Website: www.SAMARIS.net Mobile: 0414 228 948 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Thursday, 30 August 2012 4:28 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Socket / Listener do you need to process them in realtime, or can you simply receive and put them into a queue to be processed? On Thu, Aug 30, 2012 at 4:23 PM, Claude Raiola rai...@ozemail.com.au wrote: Hi, Just wondering how I would go about creating a Listener with my cf application using CFSocket however it needs to be robust enough to ensure that it could handle potentially 100's off different data sets send to it every minute at times of peak load without any data sets being lost, broken or causing the function to lock up. The data will be sent by remote devices over gprs and the packets will be in either tcp or UDP format Regards Claude -- 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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- 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. -- 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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- You received this message because you are subscribed to the Google Groups cfaussie group
[cfaussie] CF Socket / Listener
Hi, Just wondering how I would go about creating a Listener with my cf application using CFSocket however it needs to be robust enough to ensure that it could handle potentially 100's off different data sets send to it every minute at times of peak load without any data sets being lost, broken or causing the function to lock up. The data will be sent by remote devices over gprs and the packets will be in either tcp or UDP format Regards Claude -- 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.
RE: [cfaussie] CF Socket / Listener
Hi Zac, The data needs to be processed as it is received as the information relates the locations of people, the data being transmitted from mobile gps personal location devices, which report their location at set intervals The information often needs to be validated against specific sets of gps co ordinates to allow for the portal to test whether the personal location device is within pre determined zones or else outside of the zones and depending on the answer processes and alerts may been to be triggered as a result So in short it needs to be in real time with a slight allowance for processing time, this allowance needs to be less than 120 seconds Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net Website: www.SAMARIS.net Mobile: 0414 228 948 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Thursday, 30 August 2012 4:28 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Socket / Listener do you need to process them in realtime, or can you simply receive and put them into a queue to be processed? On Thu, Aug 30, 2012 at 4:23 PM, Claude Raiola rai...@ozemail.com.au wrote: Hi, Just wondering how I would go about creating a Listener with my cf application using CFSocket however it needs to be robust enough to ensure that it could handle potentially 100's off different data sets send to it every minute at times of peak load without any data sets being lost, broken or causing the function to lock up. The data will be sent by remote devices over gprs and the packets will be in either tcp or UDP format Regards Claude -- 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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- 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. -- 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] CF Page Redirect Based on Website Visitors Geographical region / IP address
Hi Wondering if there is a reliable way in CF to have my website visitors be automatically re directed to a specific subdirectory or url based on the geographical region of the website visitor. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.samaris.net/ Mobile: 0414 228 948 -- 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] swsoc error
Hi Every time I try and print regardless of the application I am using eg word / excel etc my system generates an error popup window swsoc.exe needing permission that is located in the coldfusion sub directory and then it continue to pop up every 10 minutes until I reboot once I have rebooted the error message will not start appearing until the next time I print can anyone shed some light on this Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.samaris.net/ www.SAMARIS.net Mobile: 0414 228 948 -- 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] CF Excel Spread Data Analysis
Hi, I have several 1000 electricity bills that have been scanned from the original printed document into PDF I am using OCR software to convert each bill via a batch process into individual excel spreadsheets as I am wanting to capture the reference number of each bill, which is different on each bill and then be able to import the reference number into an sql table The problem is that given the OCR is reading scanned documents often the reference number appears on different cell / rows on each spreadsheet so I cannot consistently reference the same sell across multiple spreadsheets to source the value I am seeking from each spreadsheet spreadsheet 1 example cell d45 contains the title reference number and d46 contains the actual number spreadsheet 2 example cell f120 contains the title reference number and f121 contains the actual number I am wondering if there is some way once I have created the Datasource to the spreadsheet to be able to search the word reference number in each spreadsheet to determine then cell which contains the title reference number to then know that the value on the same row one column across will contain the actual reference value.and then read the value of that cell in CF to record into the database Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.samaris.net/ www.SAMARIS.net Mobile: 0414 228 948 -- 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] BarCode Generator with CF Report Builder
Hi, I am building customer invoice templates using ColdFusion Report Builder and I am needing to have a bar code generated each time the invoice is generated from each customers unique reference number If anyone can shed some light on the best way to achieve the above I would appreciate your suggestions Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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.
RE: [cfaussie] BarCode Generator with CF Report Builder
Hi Dale Thanks for that Not sure what the format is it seems to be pretty standard to those used on Telstra bills etc The barcode needs to be generated at the time of creating the invoice given each is unique any suggestions the best way to achieve this would be appreciated I also note your comments re charts as it turns out I need graphs on the invoice as well which I was initially creating outside cfreport and the inserting as an image however I note that the graphs can be generated within report builder itself, wondering why you opt to generate them first and then insert the image rather than using the graph creation feature inside cf report builder Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser Sent: Wednesday, 21 March 2012 7:43 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] BarCode Generator with CF Report Builder The best way to do barcodes is an image. Generate the barcode as an image then reference the image in the CF Report, we do charts in reports the same way. There are lots of image libraries for generating barcodes, or you could try to write your own using the CF image tags Finding a java library and calling it would probably be a lot easier What barcode format are you using? I've mostly dealt with EAN-13 with is a product barcode, probably not what your using for invoicing. Regards Dale Fraser http://dale.fraser.id.au http://cfmldocs.com http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Wednesday, 21 March 2012 1:34 AM To: cfaussie@googlegroups.com Subject: [cfaussie] BarCode Generator with CF Report Builder Hi, I am building customer invoice templates using ColdFusion Report Builder and I am needing to have a bar code generated each time the invoice is generated from each customers unique reference number If anyone can shed some light on the best way to achieve the above I would appreciate your suggestions Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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. -- 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. -- 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] MYOB ODBC Read Integration using Cold Fusion
Hi, I am trying to connect to the myob database using the myob odbc driver The drive is installed and I am able to read the myob database using MS excel without an issue However when I try and create the DataSource connection to the same odbc Myob Driver so that I can have CF read the database I receive the following error which I cannot solve Anyone with any experience or advise using MYOB ODBC with a CF environment I would love to hear your pearls of wisdom Oh the MYOB OBDC Driver is only available in 32 BIT Connection verification failed for data source: myob java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified Regards Claude Raiola -- 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.
RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion
Hi Steve Yes I know about the developers license however the read only version without the write facility is free to use and its this read only one that I am currently able to read the data from the myob tables using excel connecting via the odbc connection I have created When I try and make the same odbc connection in cfadministrator it generates the error Connection verification failed for data source: myob java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.samaris.net/ Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 2 March 2012 12:15 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion You need a specific MYOB license to be able to connect to it via ODBC From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Friday, 2 March 2012 1:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] MYOB ODBC Read Integration using Cold Fusion Hi, I am trying to connect to the myob database using the myob odbc driver The drive is installed and I am able to read the myob database using MS excel without an issue However when I try and create the DataSource connection to the same odbc Myob Driver so that I can have CF read the database I receive the following error which I cannot solve Anyone with any experience or advise using MYOB ODBC with a CF environment I would love to hear your pearls of wisdom Oh the MYOB OBDC Driver is only available in 32 BIT Connection verification failed for data source: myob java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified Regards Claude Raiola -- 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. -- 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. -- 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] FCK-Editor with a difference
Hi All I have a need to create award certificates within a cf application however I need to let the end user use a FCK Editor type interface to allow user insert images and text and be able to easily move the images and text objects around the page allowing the end user to easily design the look and feel of the certificates they are creating without any reliance on the user needing to deal with computer syntax. In addition to images and text there will also be a number of data fields objects on each certificate who's data is drawn from a cf query eg the name of the recipient as one example The output would then need to be displayed in the browser and then converted to a pdf file Does anyone know of any FCK Editor type modules or similar that would be able to readily achieve the above within a CF application environment. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: www.SAMARIS.net Mobile: 0414 228 948 -- 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] Recruiting Agencies with CF Clients
Hi, Can anyone advise of any recruiting agencies they know of who work with in placing Cold Fusion programmers I am based in Brisbane and seeking Cold Fusion programming work full time or contract, working onsite or remote The CFJobs user group is currently very quiet as are seek advertisements Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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] Seeking CF Programming Work Full Time / Part Time / Contract / Remote
Hi All Not sure if there is a user group list that focuses on CF Jobs in Australia so I thought I would post my message here and will no doubt be directed to the correct group should it exist. I am seeking CF programming work, with over 6 years experience CF development experience ranging from developing my own applications for clients, to working as the CF programmer for a company in the mortgage management industry. I am based in Brisbane and seeking Full Time, part time, contract or even remote. Regards Claude SAMARIS Software i...@samaris.net -- 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] CFSocket
Hi, I am looking to develop an app that received data from mobile devices, said data is sent to the server and I am looking to use CFsocket to listen / capture data to then have data recorded into the sql table Never having worked with CFSocket before I am wondering if anyone can advise on the capacity of the listener, in that if the server is sent data from several hundred mobile devices at the same time, given there may be up to 5,000 devices out in the field (each set of data is simple a string of up to 100 characters) will the cfsocket be able to handle such volumes. The capturing of the data is essential as the application will then process said data and send alerts where appropriate to third parties Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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] Using CF Socket Gateway capturing Mobile Data Received
Hi all Does anyone have a good resource / reference to teach me the steps to use the cf socket gateway in order to receiving incoming data sent via gprs from mobile devices to the server. The device is able to be coded with the specific ip address and port and there are set schema that the device sends to the server The part I am finding challenging is setting up the cf socket gateway to then have it capture the incoming data received. Once captured recording it into the sql table is the easy bit Regards Claude Raiola -- 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] CF Socket capturing Mobile Data Received
Does anyone have a good resource / reference to teach me the steps to use the cf socket gateway in order to receiving incoming data sent via gprs from mobile devices to the server. The device is able to be coded with the specific ip address and port and there are set schema that the device sends to the server The part I am finding challenging is setting up the cf socket gateway to then have it capture the incoming data received. Once captured recording it into the sql table is the easy bit Regards Claude Raiola -- 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] CF9 Event Gateway
Hi, I am wanting to be able to build a CF application that will accept incoming data sent over gprs from multiple devices in the field to have said data be captured and then stored into sql database Does the CF gateway work as the listener on the server to the assigned port ?? Can this be achieve with CF code alone or do I need to be able to program in a language other than CF to be able to achieve what I am wanting. Also will the CF gateway be able to handle simultaneous data inputs from a large number of reporting devices. Any tips / thoughts assistance with the above would be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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] cfaussie] CF9 Event Gateway
Hi Steve, No the mobile devices are already programmed with the firmware to send out the relevant data using a pre defined schema for each different piece of data, the firmware on the mobile devices is able to be configured to specify the back end server IP and port that it needs to send the data to as well as the format of the data eg UDP or TCP etc In short the generation of the data, its syntax / scheme and its transmitting over gprs is all done and dusted thanks to the manufacturer of the devices I simply have the challenge of building the app to listen for the incoming data, and then capturing of said data, which I can then store in appropriate sql database tables Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Steve Onnis Sent: Wednesday, 20 July 2011 11:46 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF9 Event Gateway Are you going to be writing your own application on the mobile device to connect to the CF server? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 20 July 2011 11:42 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CF9 Event Gateway Hi, I am wanting to be able to build a CF application that will accept incoming data sent over gprs from multiple devices in the field to have said data be captured and then stored into sql database Does the CF gateway work as the listener on the server to the assigned port ?? Can this be achieve with CF code alone or do I need to be able to program in a language other than CF to be able to achieve what I am wanting. Also will the CF gateway be able to handle simultaneous data inputs from a large number of reporting devices. Any tips / thoughts assistance with the above would be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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. -- 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. -- 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] Creating A Fast Dropdown List Lookup
Hi, I have a form page drop down list that consists of several hundred membership numbers which the user needs to select an apartment number each time they submit the form currently I am using the following code cfinput type=text name=apartment_number autosuggest=#ValueList(apartments.unit_number)# id=a size=5 typeahead=yes tooltip=Start Typing The Unit Number For The List Of Available Similar Unit Numbers To Display the users are commenting that the list is not as fast as their keying resulting in it slowing them down considerably each time they have to select an apartment number from the list and then submit the form. Does anyone know an alternative or more efficient way to code this to ensure the selecting of the number from the list is fast especially given the list is often several 100 apartment numbers on the odd occasion upto 500 apartment numbers Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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] cfloop inside a cfif tag
Hi I am building an online application form and the last page testes for which fields across the multi pages of the application form As the application form allows for multiple applicants some of the mandatory fields only need to be checked dependant on whether there are more than one applicant entered into the form Each page of the application form captures the data entered and saves the data into session variables to allow for the values entered across the application form to remain present as the applicant moves through the various pages of the application form . If there is a second applicant loaded then session variables relating to the seconds applicants data are defined eg session.applicant2_firstname, session.applicant2_familyname One the last page I test form mandatory fields with code similar to cfif cfloop index=-i from 1 to #total_applicants# session.applicant#i#_firstname eq '' or session.applicant#i#_familyname eq ''/cfloop or #loan_amount# eq '' mandatory fields are missing /cfif I need to be abel to perform a cfloop within the cfif statement so that the mandatory fields relating to the 2nd. 3rd or 4th applicants are only tested for when the value for total_applicants is 2,3 or 4 I trust the above makes sense I look forward to your suggestion to achieve the above -- 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] Cfaussie] cfloop inside a cfif tag
Hi, I need to have the cfloop inside the cfif not the other way so that all session variables that are mandatory are tested to have a value. cfif cfloop index=-i from 1 to #total_applicants# session.applicant#i#_firstname eq '' or session.applicant#i#_familyname eq '' /cfloop or #loan_amount# eq '' mandatory fields are missing cfloop index=-i from 1 to #total_applicants# cfif session.applicant#i#_firstname eq ''a href=page1.cfm?fielsdname= applicant#i#_firstname Applicant #i# First Name Missing/a /cfif cfif session.applicant#i#_firstllastname eq ''a href=page1.cfm?fielsdname= applicant#i#_firstname Applicant #i# First Name Missing/a /cfif /cfloop cfelse All Mandatory fields are present SUBMIT APPLICATION /cfif Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Kai Koenig Sent: Friday, 10 June 2011 10:22 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] cfloop inside a cfif tag You could certainly achieve this with the naming convention you went for, but it's messy. I'd rather rework the data structure with your session session.applicants = ArrayNew(1); session.applicants[1] = StructNew(); session.applicants[1][firstName] = Kai; session.applicants[1][lastName] = Koenig; ... session.applicants[2] = StructNew(); session.applicants[2][firstName] = Mark; session.applicants[2][lastName] = Mandel; ... Depending on how you create the structure and what exactly you do to populate fields in your data structure, you could for instance check cfloop array=#session.applicants# index=applicant cfif Len(applicant[firstName]) or ... /cfif /cfloop Multiple benefits: - Much better datastructure in your session scope instead of gazillion individual variables - Less string manipulation and # signs in your loops Cheers Kai -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de twitter: http://www.twitter.com/agentK -- Hi I am building an online application form and the last page testes for which fields across the multi pages of the application form As the application form allows for multiple applicants some of the mandatory fields only need to be checked dependant on whether there are more than one applicant entered into the form Each page of the application form captures the data entered and saves the data into session variables to allow for the values entered across the application form to remain present as the applicant moves through the various pages of the application form . If there is a second applicant loaded then session variables relating to the seconds applicants data are defined eg session.applicant2_firstname, session.applicant2_familyname One the last page I test form mandatory fields with code similar to cfif cfloop index=-i from 1 to #total_applicants# session.applicant#i#_firstname eq '' or session.applicant#i#_familyname eq ''/cfloop or #loan_amount# eq '' mandatory fields are missing /cfif I need to be abel to perform a cfloop within the cfif statement so that the mandatory fields relating to the 2nd. 3rd or 4th applicants are only tested for when the value for total_applicants is 2,3 or 4 I trust the above makes sense I look forward to your suggestion to achieve the above -- 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. -- 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] Checking that column names in csv / excel file being uploaded match those required by my CF script
I have a feature where users are able to upload data as a csv or excel spreadsheet however I need to be able to check that the column names they are using are spelt correctly in order for the cf code to read the data files without causing an error to be thrown Can anyone advise on the best way to achieve this Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Director -- 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] Dreamweaver Cold Fusion Server (Dev) CF Report Writer
Hi I am looking to purchase a IPad II and I am wondering if Dreamweaver, Cold Fusion Server (Dev Version), CF Report Writer etc work on a MAC platform, I have never used a MAC before so I thought it best I ask before buying one. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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] Using CFPPDF Merging 2 PDF pages into one page
Hi, Just wondering whether its possible using cf pdf related tags to merge 2 pdf documents the first document being 1 page only 1/4 page in length and the second document being 1 page 3/4 page in length into 1 single 1 page document Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) -- 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] Using CFHTTP
Hi, I am trying to dynamically submit data to an external website that required me to log into the admin of the site to manually submit data I am able to successfully create a form page and submit the form to the path of the external site and the form data submits successfully with the form data being submitted being added to the external sites database as required When I try and e cfhttp so the posting of the form data occurs in the background without the screen loading the external sites page does not work however the cfhttp code passes successfully naturally I am using the same url in the form page as I am in the cfhttp tag. Any suggests why this would not work would be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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] CFChart X axis value formatting
Hi I have creating line graphs using cf charge and the dates are on the x axis the date values in the sql tables being drawn on in the chart are datetime format and as a result I am having the date and time appearing on the x axis for each point on the chart as their a way I can alter the display format of the values similar what is done using the DateFromat() do that my dates along the x axis only show in a month-year eg jan-11 rather than 01/01/11 10:55.00AM Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) logo_new Email: mailto:i...@trackingcentral.om.au i...@trackingcentral.com.au Website: http://www.trackingcentral.com.au/ www.TrackingCentral.com.au FREE CALL: 1300 255 990 -- 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. image001.gif
[cfaussie] hiding form fields dependant on value entered in previous field
Hi, I have a form with a select box allowing the user indicating number of years a person has lived at their current address cfselect name=years_at_curent_adress I have another section on the form relating to Previous address however I only want the table rows containing fields relating to previous address to display when the value in select box years_at_curent_adress is less than 2 when the value of years_at_curent_adress is 2 or above then the previous address section of the form is hidden. any assistance would be appreciated regards Claude -- 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] Life Cycle CF9
Hi, I have a PDF document that I have imported into lifecycle I need to be able to have the header on each page to be dynamic so the document is customised per business that subscribes to the website so each time they click on the document link once they are logged into the website the members logo appears on the top of each page. Each member's logo is already uploaded into the website with the members id as their filename for easy retrieval. In addition to the logo the text data of the members contact details also needs to be displayed next to the logo, once again the member's contact details are contained in the database table In short I need to be able to click a link eg document.cfm?id=20 so that this generates the pdf document built in lifecycle displaying the logo and contact details specific to memberid 20 as header on the top of each page. As the id value changes the members logo and contact details displayed dynamically change Assistance with the above would be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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.
FW: [cfaussie] Life Cycle CF9
Hi Kai Thanks for youre reply I am using thr standard Lifecycle designer ES and the document is a static pdf Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Kai Koenig Sent: Tuesday, 1 February 2011 9:27 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Life Cycle CF9 Not quite sure what exactly you mean when you refer to Life Cycle? LC Designer? LC ES - if yes, which modules? Is your document and interactive or static PDF? A form? Cheers Kai Hi, I have a PDF document that I have imported into lifecycle I need to be able to have the header on each page to be dynamic so the document is customised per business that subscribes to the website so each time they click on the document link once they are logged into the website the members logo appears on the top of each page. Each member's logo is already uploaded into the website with the members id as their filename for easy retrieval. In addition to the logo the text data of the members contact details also needs to be displayed next to the logo, once again the member's contact details are contained in the database table In short I need to be able to click a link eg document.cfm?id=20 so that this generates the pdf document built in lifecycle displaying the logo and contact details specific to memberid 20 as header on the top of each page. As the id value changes the members logo and contact details displayed dynamically change Assistance with the above would be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- 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. -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 263 414 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de twitter: http://www.twitter.com/agentK -- -- 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. -- 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] CF9 Administrator Schedule Tasks
Hi I am starting to use the schedule task feature in cf9 however I find it is still a little limited in functionality The frequency options are limited to daily, weekly, monthly There is no provision for activities to be scheduled . fortnightly, . bi weekly . bi monthly, . first, second, third, last (specific day of each month) . quarterly . 1/2 yearly The windows based schedule task functionality has far more flexibility Comments suggestions would be appreciated -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF9 Administrator Page Showing Error
Hi, When I try and access the cf9 admin page the following error occurs. I am at a loss as what has caused it or how to remedy I have already rebooted the CF services and then the server itself and still the problem exists. I welcome any assistance on this topic 500 java.lang.NullPointerException at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:285) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] importing datasource into CF9
Hi, I am having a mental block I know there is somewhere in cf9 admin allowing me to import data source settings that I have backed up however I cannot seem to find where it is located on the cf9 admin page Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
FW: [coldfusion-howto] [cfaussie] CFExchange and CF9
Hi, I am resending this post in the hope of receiving some assistance / advise on a dilemma that I am still yet to find a solution. I have started working with the Microsoft exchange integration with CF9 however I receive the following error message Exchange service is not available on 192.168.0.1. cfexchangeConnection action=open username=myusername password=mypassword/ server=192.168.0.1 connection=testconn1 MS exchange is running on 192.168.0.1 and works as I am able to send emails from within cf successfully with 192.168.0.1 setup in cf admin as the ip address for the exchange server. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:info%40SAMARIS.net mailto:i...@trackingcentral.om.au mailto:info%40TrackingCentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- 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 mailto:cfaussie%40googlegroups.com . To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2Bunsubscribe%40googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. [Non-text portions of this message have been removed] __._,_.___ Reply mailto:rai...@ozemail.com.au?subject=[cfaussie]%20cfexchange%20and%20cf9 to sender | Reply mailto:coldfusion-ho...@yahoogroups.com?subject=[cfaussie]%20cfexchange%20a nd%20CF9 to group | Reply http://groups.yahoo.com/group/coldfusion-howto/post;_ylc=X3oDMTJxM2kzcHJmBF 9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBG1zZ0lkAzQ0ODQzBH NlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTI4NzQ1NTMwNg--?act=replymessageNum=44843 via web post | http://groups.yahoo.com/group/coldfusion-howto/post;_ylc=X3oDMTJldWpxMHRiBF 9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA2 50cGMEc3RpbWUDMTI4NzQ1NTMwNg-- Start a New Topic Messages http://groups.yahoo.com/group/coldfusion-howto/message/44843;_ylc=X3oDMTM2Z GxmN29sBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBG1zZ0lkA zQ0ODQzBHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTI4NzQ1NTMwNgR0cGNJZAM0NDg0Mw-- in this topic (1) Recent Activity: http://groups.yahoo.com/group/coldfusion-howto;_ylc=X3oDMTJlMHA4amlzBF9TAzk 3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwN2dGwEc2xrA3ZnaHA Ec3RpbWUDMTI4NzQ1NTMwNQ-- Visit Your Group ~ *** Yahoo's No. 1 and the biggest group of ColdFusion Developers ColdFusion MX Hosting - 250 MB Space/5 GB monthly Bandwidth for just $19.99/year. Free Setup, ASP.NET, HELM Control Panel. http://www.hostingatoz.com. We also offer ColdFusion Reseller Hosting Plans. Post message: coldfusion-ho...@yahoogroups.com Subscribe: coldfusion-howto-subscr...@yahoogroups.com Un-Subscribe: coldfusion-howto-unsubscr...@yahoogroups.com ... http://groups.yahoo.com/;_ylc=X3oDMTJkY2oybG1nBF9TAzk3MzU5NzE0BGdycElkAzE0M DAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMjg3NDU1MzA2 Yahoo! Groups Switch to: mailto:coldfusion-howto-traditio...@yahoogroups.com?subject=change%20delive ry%20Format:%20Traditional Text-Only, mailto:coldfusion-howto-dig...@yahoogroups.com?subject=email%20delivery:%20 Digest Daily Digest . mailto:coldfusion-howto-unsubscr...@yahoogroups.com?subject=unsubscribe Unsubscribe . http://docs.yahoo.com/info/terms/ Terms of Use . http://geo.yahoo.com/serv?s=97359714/grpId=1400138/grpspId=1705115361/msgId =44843/stime=1287455306/nc1=1/nc2=2/nc3=3 __,_._,___ -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CFExchange and CF9
Hi, I have started working with the Microsoft exchange integration with CF9 however I receive the following error message Exchange service is not available on 192.168.0.1. cfexchangeConnection action=open username=myusername password=mypassword/ server=192.168.0.1 connection=testconn1 MS exchange is running on 192.168.0.1 and works as I am able to send emails from within cf successfully with 192. 168.0.1 setup in cf admin as the ip address for the exchange server. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CFExchange and CF9
Hi, I have started working with the Microsoft exchange integration with CF9 however I receive the following error message Exchange service is not available on 192.168.0.1. cfexchangeConnection action=open username=myusername password=mypassword/ server=192.168.0.1 connection=testconn1 MS exchange is running on 192.168.0.1 and works as I am able to send emails from within cf successfully with 192. 168.0.1 setup in cf admin as the ip address for the exchange server. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF 9 Microsoft Exchange
Thanks for the reply However I was hoping to have specific email boxes for each loan created so that then the loan platform could then read all emails from the email box for the loan details being displayed on the screen. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 12 October 2010 2:04 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF 9 Microsoft Exchange I had a similar problem to this and decided that it made more sense to have 1 email and forward all emails that met a certain criteria to the real email account. When an email was sent it was sent using the i...@domain name . email received as i...@domain would get forwarded/aliased to realem...@domain. Hope that helps a bit as another option. Cheers, Simon On 12 October 2010 09:39, rai...@ozemail.com.au wrote: I am working on a mortgage loan platform where by we are wanting to auto create an exchange email mailbox each time a loan application is created To illustrate, the mortgage broker logs on to the loan application platform (which is written in CF) and completes the online application form. Each loan application completed auto generates its own unique loan id which is used throughout the loan platform for data related to the loan. I am looking to have the application dynamically create a email account in exchange once the application has been completed using the unique loan application number as the email address eg: 54...@mortgages.com.au The rationale being that once the email account ha been created all correspondence sent / received relating to the loan will use the unique email address relating to the loan number I am in the process of upgrading to CF 9 and I am aware there are some new features in cf9 that allow for live interaction with Exchange. I look forward to any comments / suggestions and thank you in advance Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF 9 Microsoft Exchange
Hi Steve, the idea being to allow all email sent and received relating to a loan will have the loanid as the email address sending out emails to the brokers or funders or solicitors etc will have the [loan...@mortgages.com.au as the email address and also the reply to address to ensure all reply emails sent back will be sent to that unique email address so that all email correspondence relating to a specific loan can be found in specific mail box Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Tuesday, 12 October 2010 4:44 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Why do you need email accounts? Why wouldn't you just put all the info into a database? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Tuesday, 12 October 2010 4:24 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Thanks for the reply However I was hoping to have specific email boxes for each loan created so that then the loan platform could then read all emails from the email box for the loan details being displayed on the screen. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 12 October 2010 2:04 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF 9 Microsoft Exchange I had a similar problem to this and decided that it made more sense to have 1 email and forward all emails that met a certain criteria to the real email account. When an email was sent it was sent using the i...@domain name . email received as i...@domain would get forwarded/aliased to realem...@domain. Hope that helps a bit as another option. Cheers, Simon On 12 October 2010 09:39, rai...@ozemail.com.au wrote: I am working on a mortgage loan platform where by we are wanting to auto create an exchange email mailbox each time a loan application is created To illustrate, the mortgage broker logs on to the loan application platform (which is written in CF) and completes the online application form. Each loan application completed auto generates its own unique loan id which is used throughout the loan platform for data related to the loan. I am looking to have the application dynamically create a email account in exchange once the application has been completed using the unique loan application number as the email address eg: 54...@mortgages.com.au The rationale being that once the email account ha been created all correspondence sent / received relating to the loan will use the unique email address relating to the loan number I am in the process of upgrading to CF 9 and I am aware there are some new features in cf9 that allow for live interaction with Exchange. I look forward to any comments / suggestions and thank you in advance Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16050) http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51 === === Email scanned by PC Tools - No viruses or spyware found. (Email Guard
RE: [cfaussie] CF 9 Microsoft Exchange
Hi Steve, Sorry Steve I think I did not explain myself The concept is to have the loanid email used as the from / reply to email address when the broker receives emails from the platform, the brokers own email address is registered in the database and has no bearing on the functionality I am seeking to develop Example: John Broker submits a loan into the loan platform. The loan platform dynamically assigns a loanid eg 54745 to the new loan. The loan platform then needs to automatically create a new mail box in exchange 2003 with email address 54...@mortgages.com.au Any emails sent from the application relating to loan number 54745 will send the email to the email address of the person needing to be emailed eg the solicitor / broker / bank etc etc (the third party email address are already stored in the loan platform database). The from email address and the replyto email address on those emails sent out by the loan platform will be 54...@mortgages.com.au so that any reply email sent back from the solicitor / broker / bank etc etc. will be sent to the email address 54...@mortgages.com.au The above will result in all incoming emails relating to the given loan will automatically be received by the mailbox created specifically for that loan number. I trust the above clarifies what I am trying to achieve for those of you interested in following this topic and I look forward to feedback. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 10:50 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange If you do it like that then you will need to ensure that the broker either adds the email account into their outlook so they can retrieve the emails (which they wouldn't even what the user account is because they are being randomly generated) or dynamically add forwards for those new email accounts so that the emails are redirected to the appropriate broker which then asks the question how do you know which brokers will be looking after which applications? Or are you going to forward the application to all brokers? In that case is the exchange server set up in a way that you can query the active directory and get all of the email accounts that are for brokers? Because as brokers leave and new brokers are employed you will need a way of easily working out what broker email addresses to use. And then there is existing applicationswhat if a broker leaves and another broker takes over an application? Then you will need a way of getting all the emails from the previous broker regarding any applications and then making them available for the new broker. All this would be much easier being manages within its own application away from exchange From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Friday, 15 October 2010 11:37 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CF 9 Microsoft Exchange Hi Steve, the idea being to allow all email sent and received relating to a loan will have the loanid as the email address sending out emails to the brokers or funders or solicitors etc will have the [loan...@mortgages.com.au as the email address and also the reply to address to ensure all reply emails sent back will be sent to that unique email address so that all email correspondence relating to a specific loan can be found in specific mail box Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Tuesday, 12 October 2010 4:44 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Why do you need email accounts? Why wouldn't you just put all the info into a database? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Tuesday, 12 October 2010 4:24 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Thanks for the reply However I was hoping to have specific email boxes for each loan created so that then the loan platform could then read all emails from the email box for the loan details being displayed on the screen. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 12 October 2010 2:04 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF 9
RE: [cfaussie] CF 9 Microsoft Exchange
Hi Steve, Sorry I still need to further clarify The mortgage manager is the intermediary between all third parties relating to the mortgage process so there would never be a situation of an incomming email sent from a solicitor / bank or other third party relating to a specific loan being automatically on forwarded to the broker. The loan specific email is for email content management of the mortgage broker. There is no forwarding needed incomming emails sent to 54...@mortgages.com.au from third parties either from the broker / the solicitor / the bank etc to the mortgage manager. Emails sent to 54...@mortgages.com.au are actioned by the mortgage manager admin staff never automatically on forwarded to the broker The concept for the email accounts to be dynamically created when a new loan is loaded is so that the mortgage manager recieves all incomming emails from third parties relating to sent to the laon specific email account. I am stil at the space of trying to determine how I can have the cf application automatically interact with exchange 2003 and create a new email account that represents the new loan id each time a new application is completed ??? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 12:06 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Right but what tells the incoming email to go to the broker? You will need to set up either a forward for each new email account so that incoming emails for the loan application are sent to the actual brokers inbox or set up another system so the broker receives the incoming emails...make sense? Outlook allows only a single exchange account to be set up per profile From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Friday, 15 October 2010 12:52 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Hi Steve, Sorry Steve I think I did not explain myself The concept is to have the loanid email used as the from / reply to email address when the broker receives emails from the platform, the brokers own email address is registered in the database and has no bearing on the functionality I am seeking to develop Example: John Broker submits a loan into the loan platform. The loan platform dynamically assigns a loanid eg 54745 to the new loan. The loan platform then needs to automatically create a new mail box in exchange 2003 with email address 54...@mortgages.com.au Any emails sent from the application relating to loan number 54745 will send the email to the email address of the person needing to be emailed eg the solicitor / broker / bank etc etc (the third party email address are already stored in the loan platform database). The from email address and the replyto email address on those emails sent out by the loan platform will be 54...@mortgages.com.au so that any reply email sent back from the solicitor / broker / bank etc etc. will be sent to the email address 54...@mortgages.com..au mailto:54...@mortgages.com.au The above will result in all incoming emails relating to the given loan will automatically be received by the mailbox created specifically for that loan number. I trust the above clarifies what I am trying to achieve for those of you interested in following this topic and I look forward to feedback. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 10:50 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange If you do it like that then you will need to ensure that the broker either adds the email account into their outlook so they can retrieve the emails (which they wouldn't even what the user account is because they are being randomly generated) or dynamically add forwards for those new email accounts so that the emails are redirected to the appropriate broker which then asks the question how do you know which brokers will be looking after which applications? Or are you going to forward the application to all brokers? In that case is the exchange server set up in a way that you can query the active directory and get all of the email accounts that are for brokers? Because as brokers leave and new brokers are employed you will need a way of easily working out what broker email addresses to use. And then there is existing applicationswhat if a broker leaves and another broker takes over an application? Then you will need a way of getting
[cfaussie] Problem Sending Mail in CF9
Hi All, I have just installed cf9 and one of the templates allows for sending out emails from within CF basic stuff !!! However when I run the template it does not error however the emails are not sent and when I log into cf admin and look at undelivered emails there they are sitting in the undelivered table however if I click on each and then click the respool button cf9 then successfully sends them as expected any ideas as why this would be so and how to remedy. As always thanks in advance for your advise Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CF 9 Microsoft Exchange
Hi Steve, the idea being to allow all email sent and received relating to a loan will have the loanid as the email address sending out emails to the brokers or funders or solicitors etc will have the [loan...@mortgages.com.au as the email address and also the reply to address to ensure all reply emails sent back will be sent to that unique email address so that all email correspondence relating to a specific loan can be found in specific mail box Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Tuesday, 12 October 2010 4:44 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Why do you need email accounts? Why wouldn't you just put all the info into a database? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Tuesday, 12 October 2010 4:24 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF 9 Microsoft Exchange Thanks for the reply However I was hoping to have specific email boxes for each loan created so that then the loan platform could then read all emails from the email box for the loan details being displayed on the screen. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 12 October 2010 2:04 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF 9 Microsoft Exchange I had a similar problem to this and decided that it made more sense to have 1 email and forward all emails that met a certain criteria to the real email account. When an email was sent it was sent using the i...@domain name . email received as i...@domain would get forwarded/aliased to realem...@domain. Hope that helps a bit as another option. Cheers, Simon On 12 October 2010 09:39, rai...@ozemail.com.au wrote: I am working on a mortgage loan platform where by we are wanting to auto create an exchange email mailbox each time a loan application is created To illustrate, the mortgage broker logs on to the loan application platform (which is written in CF) and completes the online application form. Each loan application completed auto generates its own unique loan id which is used throughout the loan platform for data related to the loan. I am looking to have the application dynamically create a email account in exchange once the application has been completed using the unique loan application number as the email address eg: 54...@mortgages.com.au The rationale being that once the email account ha been created all correspondence sent / received relating to the loan will use the unique email address relating to the loan number I am in the process of upgrading to CF 9 and I am aware there are some new features in cf9 that allow for live interaction with Exchange. I look forward to any comments / suggestions and thank you in advance Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16050) http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51 === === Email scanned by PC Tools - No viruses or spyware found. (Email Guard
[cfaussie] CF 9 Microsoft Exchange
I am working on a mortgage loan platform where by we are wanting to auto create an exchange email mailbox each time a loan application is created To illustrate, the mortgage broker logs on to the loan application platform (which is written in CF) and completes the online application form. Each loan application completed auto generates its own unique loan id which is used throughout the loan platform for data related to the loan. I am looking to have the application dynamically create a email account in exchange once the application has been completed using the unique loan application number as the email address eg: 54...@mortgages.com.au The rationale being that once the email account ha been created all correspondence sent / received relating to the loan will use the unique email address relating to the loan number I am in the process of upgrading to CF 9 and I am aware there are some new features in cf9 that allow for live interaction with Exchange. I look forward to any comments / suggestions and thank you in advance Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CF 9 Microsoft Exchange
Thanks for the reply However I was hoping to have specific email boxes for each loan created so that then the loan platform could then read all emails from the email box for the loan details being displayed on the screen. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Tuesday, 12 October 2010 2:04 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF 9 Microsoft Exchange I had a similar problem to this and decided that it made more sense to have 1 email and forward all emails that met a certain criteria to the real email account. When an email was sent it was sent using the i...@domain name . email received as i...@domain would get forwarded/aliased to realem...@domain. Hope that helps a bit as another option. Cheers, Simon On 12 October 2010 09:39, rai...@ozemail.com.au wrote: I am working on a mortgage loan platform where by we are wanting to auto create an exchange email mailbox each time a loan application is created To illustrate, the mortgage broker logs on to the loan application platform (which is written in CF) and completes the online application form. Each loan application completed auto generates its own unique loan id which is used throughout the loan platform for data related to the loan. I am looking to have the application dynamically create a email account in exchange once the application has been completed using the unique loan application number as the email address eg: 54...@mortgages.com.au The rationale being that once the email account ha been created all correspondence sent / received relating to the loan will use the unique email address relating to the loan number I am in the process of upgrading to CF 9 and I am aware there are some new features in cf9 that allow for live interaction with Exchange. I look forward to any comments / suggestions and thank you in advance Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Optimising SQL Tables Searches
Hi Andrew no the id is alpha numeric as in 'bel1234 its strange I have found an sql query analyser and connected to the sql dbase and it searches for and finds the records in under 2 seconds however when I perform the same query using the sql manager studio, script window, it takes up to 9 seconds to perform the identical query ??? and yes both queries are displaying the same columns in both Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 4:34 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Is the ID a numeric value? If so where club_id like 'session.club_id' should be where club_id = 'session.club_id' Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 1:12 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Hi Simon You may have misinterpreted how I wrote the sample code select * from members where club_id like 'session.club_id' the reference to session.club_id was referring to a session variable called club id which is assigned at the time the member logs into the site in reality the query is select * from members where club_id like '#session.club_id#' Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Saturday, 25 September 2010 8:45 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Optimising SQL Tables Searches I would probably change the query to read select {whatever the real columns that you want to select} from members where club_id in (select club_id from session) Then add indexes to the club_id in both tables and see how that goes Cheers, Simon On 25 September 2010 18:43, rai...@ozemail.com.au wrote: The SQL tables I am working with were not created with indexes given the small number of expected records in each table at the time Now however some of the tables have 5,000+ records and some have well over 30,000 records contained with them and as a result the applications are starting to slow down when they the pages load. One example is a members table that now has over 5,000 records. The columns within the table include id member name member phone date joined club_id Each time the membership page loads the members table runs the following query in order to display all the members select * from members where club_id like 'session.club_id' This allows the membership page to then list all the members details who are in the same club as the person who is logged in. Generally the search results of any given club range from 100-500 members, in other words. When I run the query in sql manager studio it takes around 9 seconds to display the search results of a given club. When I create an index based on club_id and then re run the query in sql manager studio it still takes 9 seconds Any comments assistance on how to improve the performance of my sql queries given the scenario outlined above would be greatly appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr
RE: [cfaussie] Optimising SQL Tables Searches
Yes that was an oversight I made those changes to use = instead of like however doing so made no improvement in the speed, whilst not disputing your comments re using = rather than like Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 9:35 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Even still, You have Where something like 'value' but you made no %% wrapped around your value, so my question is was this a mistake? Because I am sure that like is even slower than a direct equals as well. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 9:32 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Hi Andrew no the id is alpha numeric as in 'bel1234 its strange I have found an sql query analyser and connected to the sql dbase and it searches for and finds the records in under 2 seconds however when I perform the same query using the sql manager studio, script window, it takes up to 9 seconds to perform the identical query ??? and yes both queries are displaying the same columns in both Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Optimising SQL Tables Searches
Hi Andrew The table has 5965 records when I use this query in the sql analyser tool select club_id from members_table the sql analyser tool displays all 5965 records in under 2 seconds using the same query using the script screen in sql Manager Studio the results query took over 35 seconds Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 9:58 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches I wasn't sure it would as you didn't have the % wrapping it anyway, so it might be the same as doing an equals. But the select * is known performance issue, and so is indexing the right columns as well to help speed things up. But I was surprised to see that the MS SQL Studio was slower in the tests you did, I know it converts select * to all columns but I doubt that would have brought on that much of a difference in running the queries. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 9:59 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Yes that was an oversight I made those changes to use = instead of like however doing so made no improvement in the speed, whilst not disputing your comments re using = rather than like Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Optimising SQL Tables Searches
Hi I do not seem to be able to find the query analyser in manager studio 2008 is it installed as default or would it have been an optional install that I may have chosen not to include at the time of the install ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 10:33 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Yeah, one has to remember though that the SQL Manager Studio will have events on each row read. For example if you have to window open to view records it will also take time to populate this as well. I know that the MS SQL MS is not the best designed or even optimised tool, and I would certainly not be using it as a benchmark to how fast the query should run, the Query Analyser in the Studio is designed to do this. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 10:22 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Hi Andrew The table has 5965 records when I use this query in the sql analyser tool select club_id from members_table the sql analyser tool displays all 5965 records in under 2 seconds using the same query using the script screen in sql Manager Studio the results query took over 35 seconds Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 9:58 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches I wasn't sure it would as you didn't have the % wrapping it anyway, so it might be the same as doing an equals. But the select * is known performance issue, and so is indexing the right columns as well to help speed things up. But I was surprised to see that the MS SQL Studio was slower in the tests you did, I know it converts select * to all columns but I doubt that would have brought on that much of a difference in running the queries. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 9:59 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Yes that was an oversight I made those changes to use = instead of like however doing so made no improvement in the speed, whilst not disputing your comments re using = rather than like Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Optimising SQL Tables Searches
The SQL tables I am working with were not created with indexes given the small number of expected records in each table at the time Now however some of the tables have 5,000+ records and some have well over 30,000 records contained with them and as a result the applications are starting to slow down when they the pages load. One example is a members table that now has over 5,000 records. The columns within the table include id member name member phone date joined club_id Each time the membership page loads the members table runs the following query in order to display all the members select * from members where club_id like 'session.club_id' This allows the membership page to then list all the members details who are in the same club as the person who is logged in. Generally the search results of any given club range from 100-500 members, in other words. When I run the query in sql manager studio it takes around 9 seconds to display the search results of a given club. When I create an index based on club_id and then re run the query in sql manager studio it still takes 9 seconds Any comments assistance on how to improve the performance of my sql queries given the scenario outlined above would be greatly appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Optimising SQL Tables Searches
Hi Simon You may have misinterpreted how I wrote the sample code select * from members where club_id like 'session.club_id' the reference to session.club_id was referring to a session variable called club id which is assigned at the time the member logs into the site in reality the query is select * from members where club_id like '#session.club_id#' Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Simon Haddon Sent: Saturday, 25 September 2010 8:45 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Optimising SQL Tables Searches I would probably change the query to read select {whatever the real columns that you want to select} from members where club_id in (select club_id from session) Then add indexes to the club_id in both tables and see how that goes Cheers, Simon On 25 September 2010 18:43, rai...@ozemail.com.au wrote: The SQL tables I am working with were not created with indexes given the small number of expected records in each table at the time Now however some of the tables have 5,000+ records and some have well over 30,000 records contained with them and as a result the applications are starting to slow down when they the pages load. One example is a members table that now has over 5,000 records. The columns within the table include id member name member phone date joined club_id Each time the membership page loads the members table runs the following query in order to display all the members select * from members where club_id like 'session.club_id' This allows the membership page to then list all the members details who are in the same club as the person who is logged in. Generally the search results of any given club range from 100-500 members, in other words. When I run the query in sql manager studio it takes around 9 seconds to display the search results of a given club. When I create an index based on club_id and then re run the query in sql manager studio it still takes 9 seconds Any comments assistance on how to improve the performance of my sql queries given the scenario outlined above would be greatly appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Migrate CF from CF 5 to CF9
When I did so on the test server none of the odbc connections transferred across from cf5 to cf9 non of the only some of the cftags came across and those that did they did not work as cf9 appears to place the cf tags related files in a totally different directory path to cf5. Hence my thought of taking smaller migratory steps Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Dale Fraser Sent: Monday, 13 September 2010 4:39 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Migrate CF from CF 5 to CF9 I'd jump straight to CF9 I don't see any issues that can't be solved. If something doesn't work there will be a simple or better solution in CF9 Regards Dale Fraser http://dale.fraser.id.au http://cfmldocs.com http://cfmldocs.com/ http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Monday, 13 September 2010 3:54 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] Migrate CF from CF 5 to CF9 Hi, I am needing to migrate from CF5 server to CF9 I am aware that the jump from cf5 to cf9 is considerable given the structural changes between cf5 and cf9. I am wondering if the safest option for the smoothest migration be to migrate the server from cf5 to cf6 then to cf7 and then migrate from cf7 to cf9 The only issue I have is finding install files for cf6 and cf7 if anyone is able to point me in the right direction where I am able to download the dev version of cf6 and cf7 I would appreciate your assistance. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF9 ODBC Driver fir Excel Files
Hi, I have a series of excel files with datasouce connection running in cf5 Cf9 does not seem to list a Microsoft xls driver to create an odbc datasource connection Any assistance to remedy this issue will be appreciated Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Migrate CF from CF 5 to CF9
Hi, I am needing to migrate from CF5 server to CF9 I am aware that the jump from cf5 to cf9 is considerable given the structural changes between cf5 and cf9. I am wondering if the safest option for the smoothest migration be to migrate the server from cf5 to cf6 then to cf7 and then migrate from cf7 to cf9 The only issue I have is finding install files for cf6 and cf7 if anyone is able to point me in the right direction where I am able to download the dev version of cf6 and cf7 I would appreciate your assistance. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF Session Clock / Timer
Hi, Just wondering if its possible to have a session clock / timer so that my users know the remaining time left before the session expires and or when there is only x minutes left before the session times out that a popup window appears telling them their remaining time before the session closes ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Trying To Create A Basic Shopping Cart
Hi I am trying my hand at a basic shopping cart I have found an example online that uses the following code cfparam name=session.cart default=arrayNew() cfset session.cart = arrayAppend( session.cart, structNew() ) cfset thisCartItem = arraylen( session.cart ) cfset session.cart[thisCartItem].itemID = form.itemID cfset session.cart[thisCartItem].quantity = form.quantity cfset session.cart[thisCartItem].itemName = form.itemName However the code generates the following error message: Object of type class java.lang.String cannot be used as an array If someone would like to advise where the above code is causing the error message I would be grateful Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Cold Fusion Microsoft Sql Server Web Edition
Hi, I am considering hosting a cf application on a server that runs Microsoft Sql Server Web Edition (MSSWE) Not having come across this before I am wondering if CF is able to operate using (MSSWE) just as it does when using the traditional SQL server Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.