Re: Azure Storage
Sorry about the double post. The list was acting up yesterday. On 3/30/15, 9:49 AM, "Bobby" wrote: > >Anyone managed to get Azure blob storage working in CF? There are very few >examples out there and virtually none in CF. > >I©öm mostly just having issues with the authorization header >formatting/encoding and wondered if anyone had any working examples. > >Unfortunately, this is a CF8 project. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error calling a .net object
Javacast the 0 as short and the path as a string and see how that goes. example: opendesign(javacast('string',thisfile), javacast('short',0)) On 3/25/15, 9:45 AM, "Charles Sheehan-Miles" wrote: > >That was my first thought too. But the documentation is pretty clear >that it?s looking for the file path, and the dump shows this: > >OpenDesign(java.lang.String, short) > > > > >> On Mar 25, 2015, at 9:23 AM, Bobby wrote: >> >> >> I gave the benefit of the doubt but that is also my primary suspicion >> (file object vs path). >> >> On 3/25/15, 9:17 AM, "Byron Mann" wrote: >> >>> >>> I know I've done things like pass a file path (string) instead of file >>> object, so make sure the type the method wants is string or otherwise. >>> >>> So might look if the function is this: >>> >>> OpenDesign(File, Int) >>> >>> as opposed to: >>> >>> OpenDesign(String, Int) >>> >>> ~Byron >>> >>> >>> On Wed, Mar 25, 2015 at 9:08 AM, Bobby wrote: >>> >>>> >>>> example: opendesign(javacast('string',thisfile), javacast('int',0)) >>>> >>>> >>> >>> >>> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error calling a .net object
I gave the benefit of the doubt but that is also my primary suspicion (file object vs path). On 3/25/15, 9:17 AM, "Byron Mann" wrote: > >I know I've done things like pass a file path (string) instead of file >object, so make sure the type the method wants is string or otherwise. > >So might look if the function is this: > >OpenDesign(File, Int) > >as opposed to: > >OpenDesign(String, Int) > >~Byron > > >On Wed, Mar 25, 2015 at 9:08 AM, Bobby wrote: > >> >> example: opendesign(javacast('string',thisfile), javacast('int',0)) >> >> > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error calling a .net object
Its not necessarily saying the method doesn't exist, it is saying it doesn't exist with the arguments and/or argument TYPEs you are giving it. Look at the types in the dump of the method you mentioned and try to javacast() your values to match those types when passing them in. example: opendesign(javacast('string',thisfile), javacast('int',0)) ...assuming that it is actually expecting a simple string and int. If that doesn't work, try posting the method dump or (if you have it) a working.NET example of how it is used. On 3/25/15, 8:28 AM, "Charles Sheehan-Miles" wrote: > >I have a problem I wanted to run by the list. Iâm recently back in the >coldfusion world after a several year hiatus. Iâm in the process of >trying to access the methods of a .net component, at this point as a >proof of concept. Once I can do something with it Iâll actually start >building the app. > >I set up the object like this: > > >class="CADXLib.CadX" >type=".NET" >name="cadx" >assembly="#dll#â> > >Thatâs in my application.cfc, in the onRequestStart() method. Then in >my index.cfm I call: > > > > > >This works, and outputting âthistfileâ gives me the correct path >location. So now I call the actual method: > > > >Thatâs where I get stuck. I get this error: > >Either there are no methods with the specified method name and argument >types or the OpenDesign method is overloaded with argument types that >ColdFusion cannot decipher reliably. ColdFusion found 0 methods that >match the provided arguments. If this is a Java object and you verified >that the method exists, use the javacast function to reduce ambiguity. > >I javacast the arguments and get the same error. Method not found. But >based on the dump, the method is clearly there. > >Has anyone encountered this or something similar? > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can you use a CFTHREAD inside an Ajax routine?
When you say it doesn¹t generate any errors, do you mean that you¹ve looked through the exception logs? Unless you are trapping it with try/catch or a custom error handler, that¹s the only place you would discover that an error happened in a cfthread that you are spawning and forgetting. On 3/5/15, 3:47 PM, "John Pullam" wrote: > >It seems to me that the CFTHREAD I attempt to start from inside an Ajax >routine (triggered by a CFWINDOW) never runs and doesn't generate any >error message. Can anyone advise if this is a legitimate thing to do? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF11 Licensing - 2 servers behind load balancer
That¹s not what Adobe is telling us. They want a license per virtual machine, not per host. On 10/2/14, 3:22 PM, "Russ Michaels" wrote: > >as they are virtual, if you have enterprise license then you are covered >as >long as you are within the CPU/core requirements. > >On Thu, Oct 2, 2014 at 8:15 PM, Dan LeGate wrote: > >> >> Okay, if I have a single site, being run on two or more virtual (vmware) >> servers behind a load balancer, does each server need a license? Or >> does one license cover the "site"? >> >> Thanks! >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: code suddenly stops working for no apparent reason
It isn¹t being explicitly passed, it is being explicitly referenced. The template assumes it was passed in as part of the attributes collection/scope (as per argumentcollection="#attributes#²). The error is telling you that it is not in the attributes scope. The error is not wrong so, like Phillip suggested, step back until you find where you think it is being set and figure out why it isn¹t. Nothing you¹ve said or pasted will let anywhere here give you much more info than that. On 8/30/14, 3:44 PM, "Phillip Vector" wrote: > >Apparently, it isn't. Go back further. > > >On Sat, Aug 30, 2014 at 12:08 PM, Matthew Smith >wrote: > >> >> But it is being explicitly passed. That's where I'm lost. >> >> > On Aug 30, 2014, at 12:44, Phillip Vector >> wrote: >> > >> > >> > The reason is apparent. >> > >> > Element USERID is undefined in ATTRIBUTES. >> > >> > Trace the attribute back and figure out where it was set and see why >>it >> > isn't being set. >> > >> > >> > On Sat, Aug 30, 2014 at 11:31 AM, Matthew Smith >> >> > wrote: >> > >> >> >> >> >> >> > >> component="cfcs.qry-todatabase" >> >> method="qry_peopleCreateNewUser" >> >>argumentcollection="#attributes#" >> >> returnvariable="qry_peopleCreateNewUser"> >> >> >> >> >> >>> >> error="badPassword" >> >> emailaddress = "#attributes.emailAddress#" >> >> cfid="#cfid#" cftoken="#session.cftoken#" >> >> template="#fusebox.rootpath##modself#"> >> >> >> >>> >> fuseaction="#fusebox.thisCircuit#.startSession" >> >> userid="#qry_peopleCreateNewUser.returnKey#" >> >> template="#fusebox.rootpath##modself#" >> >> cfid="#cfid#" cftoken="#session.cftoken#"> >> >> >> >> >> >> >> >> > >> scope="SESSION" >> >> timeout="10" >> >> type="EXCLUSIVE"> >> >> >> >> >> >> >> >> >> >> >> >> > listFirst(evaluate("client.#fusebox.thiscircuit#returnFuseaction"), >> >> ".") eq "SECUREOrderApp"> >> >> >> >>> >> cfuserid="#session.CFID#0#session.CFTOKEN#") /> >> >>> >> cfuserid="#session.CFID#0#session.CFTOKEN#", app_user_id = >> >> "#CLIENT.USERID#") /> >> >> >> >> >> >> >> >> >> >> >> >> getting this error even though explicitly passed... >> >> >> >> Element USERID is undefined in ATTRIBUTES. The error occurred in >> >> >> >> >> >>*D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/authenticati >>on/fbx_Switch.cfm: >> >> line 91* >> >> *Called from* >> >> >> >>D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30 >>_CF50.cfm: >> >> line 273 >> >> *Called from* >> >> >> >>D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30 >>_CF50.cfm: >> >> line 33 >> >> *Called from* >> >> >> >>D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30 >>_CF50.cfm: >> >> line 1 >> >> *Called from* >> >> >>D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: >> >> line 9 >> >> *Called from* >> >> >> >>D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.c >>fc: >> >> line 62 >> >> >> >> 89 : >> >> 90 : *91 : * >> >> 92 : > "#fusebox.homeCircuit#.home"> >> >> 93 : > >> listFirst(evaluate("client.#fusebox.thiscircuit#returnFuseaction"), >> >> ".") eq "SECUREOrderApp"> >> > >> > >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion BBCode routines
Without specifics, I can just suggest trying to download the last version of CF4em (which is still pretty old) and check out the bbmlparser there. http://cf4em.com/downloads/ /cf4em/inc/parsebbml.cfm Unless CF4em is what you inherited... In which case, I¹d suggest NOT doing that that :-) On 8/10/14, 8:31 PM, "UXB" wrote: > >I was wondering if anyone has some battle tested BBCode routines to >convert >BBcode to html and one to covert the HTML created back to BBcode? I have >inherited a forum that has rolled its own BBcode <> Html routines and the >kiddies are finding ways to imbed scripts into the various BBCode >routines. >I would prefer not to have to re-create the wheel. I have tried Google but >can't seem to find much of anything coldfusion related on the subject. > >Any assistance is appreciated. > >Dennis Powers >UXB Internet - A website Design and Hosting Company >P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 >W: http://www.uxbinternet.com >W: http://www.ctbusinesslist.com > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? On 8/6/14, 12:21 PM, "Paul Hastings" wrote: > >On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote: >> *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data >>in >> some table columns. But when I try to fetch & display using CF even >>after >> adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic >>text >> appeared as . > >"??" means your text data is garbaged from the db. double check that it's >stored >in an "N" datatype (nchar, nvarchar, etc.). then double check if the data >is in >fact encoded as unicode. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Last time, my suggestion was to make sure the "Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² setting was enabled on your CF datasource but that was before I realized it was an oracle datasource. If you are using a SQL Server datasource this time, that setting should apply so make sure the setting is enabled and try it again. On 8/6/14, 9:17 AM, "Sathyanarayanan Ramanathan" wrote: > >Dear Friends, > >Few days before I was trying to insert Arabic text into my ColdFusion >application with oracle database. And finally it worked for me as I >mentioned in previous mail chain below. > >*Steps taken:* > >*Oracle side:* I created the new database with NLS_CHARACTERSET as >AL32UTF8 >and imported my old exported database having different characterset. > >*CF side:* >I added the below two lines at the top of the cfm template. > > > >*Current Issue:* >But now am facing similar issue with respect to insert Arabic text into my >ColdFusion application with SQL Server 2008 database. > >*Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in >some table columns. But when I try to fetch & display using CF even after >adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic >text >appeared as . > >But if I use charset as Windows-1256 static text in the cfm page such as >column headers are coming as Arabic. But the fetched data from sql db >still >appear as ??? > >Please help. > >Sathya.R > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
Your screenshots will not come through on the the list, you will have to put them online somewhere and send the links instead. As for the ¡°Enable High ascii¡± settings, my apologies, it doesn¡¯t appear to be available for oracle datasources. On 7/13/14, 9:47 AM, "Sathyanarayanan Ramanathan" wrote: > >Dear All, > >I have created a test oracle database with AR8MSWIN1256 as characterset. >Also I created a test table with NVARCHAR2 (1000) as the datatype. Please >see the screenshots below. > >[image: Inline image 1] >*Test table:* > >[image: Inline image 2] > >*Simple insert statement using Toad for Oracle:* > > >*[image: Inline image 3] * > >I am not able to find "Enable High ASCII characters and Unicode for data >sources configured for >non-Latin characters©÷" as suggested by Bobby. I am using CF9. > >Regards, >Sathya > > > >On Sun, Jul 13, 2014 at 3:52 PM, Bobby wrote: > >> >> In the CF Administrator datasource settings, under the advanced section, >> there is a checkbox for enabling high ascii/unicode chars. It is off by >> default. Be sure that is checked. >> >> "Enable High ASCII characters and Unicode for data sources configured >>for >> non-Latin characters©÷ >> >> >> On 7/13/14, 3:26 AM, "Sathyanarayanan Ramanathan" >> wrote: >> >> > >> >Dear All, >> > >> >I am trying to insert Arabic text into my ColdFusion application with >> >Oracle database. >> >I tried below 3 scenarios but didn't work for me. >> > >> >1. One of my ColdFusion application is already implemented to handle >> >Arabic >> >text using Oracle db. >> >I checked the NLS_characterset & is set to AR8MSWIN1256. There are few >> >Arabic text found in few tables. >> >But when I try to insert some sample rows with arabic text using toad >>it's >> >coming as ?. >> > >> >2. I created a new database and tried to set NLS_characterset to >> >AR8MSWIN1256. >> >I tried to create a table & insert some sample rows with Arabic text >>using >> >toad it's still coming as ?. >> > >> >3. I searched few sites & set NLS_characterset to AL32UTF8. But still >>the >> >results are same. >> > >> >Your time & help will be really appreciated. >> > >> >Sathya.R >> > >> > >> > >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. "Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3:26 AM, "Sathyanarayanan Ramanathan" wrote: > >Dear All, > >I am trying to insert Arabic text into my ColdFusion application with >Oracle database. >I tried below 3 scenarios but didn't work for me. > >1. One of my ColdFusion application is already implemented to handle >Arabic >text using Oracle db. >I checked the NLS_characterset & is set to AR8MSWIN1256. There are few >Arabic text found in few tables. >But when I try to insert some sample rows with arabic text using toad it's >coming as ?. > >2. I created a new database and tried to set NLS_characterset to >AR8MSWIN1256. >I tried to create a table & insert some sample rows with Arabic text using >toad it's still coming as ?. > >3. I searched few sites & set NLS_characterset to AL32UTF8. But still the >results are same. > >Your time & help will be really appreciated. > >Sathya.R > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic queries within a loop
errr Variables["getCourse" & I].CREDITDESIGNATIONTO One of those bad boys. On 4/18/14, 10:28 AM, "Bobby" wrote: > >Variables["getCourse" & i & ".CREDITDESIGNATIONTO©÷] > > >On 4/18/14, 9:42 AM, "Torrent Girl" wrote: > >> >>This actually worked for me: #evaluate("getCourse" & i & >>".CREDITDESIGNATIONTO")# >> >>but of course everyone will tell me not to use evaluate. >> >>How can I rewrite this properly? >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic queries within a loop
Variables["getCourse" & i & ".CREDITDESIGNATIONTO²] On 4/18/14, 9:42 AM, "Torrent Girl" wrote: > >This actually worked for me: #evaluate("getCourse" & i & >".CREDITDESIGNATIONTO")# > >but of course everyone will tell me not to use evaluate. > >How can I rewrite this properly? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: onApplicationStart and cfmail, when doess server start?
The next thing that comes to mind is to parse the CF server.log file for the instance you are targeting. There are log entries for stopping and starting in there. But I¹m guessing you are wanting this to be used as an alert not post-portem investigation. There are plenty of infrastructure monitoring applications and 3rd party services out there for monitoring your production servers (including the services). My company uses PRTG for performance/service monitoring (http://www.paessler.com/prtg) to cover all of our different servers. Im mostly responsible for the health of our CF servers though and FusionReactor works great for me. If you set it up correctly, it can notify you of service availability changes. None of the above actual means that a server was ³rebooted² though and a CF service stopping/starting also doesn¹t mean that someone manually triggered it. Also, keep in mind that something running ON the server that is supposed to send you this email is probably not going to work if its running on the service you are trying to monitor. On 4/1/14, 12:11 PM, "morchella" wrote: > >looks like onServerStart is turned off. i cant change that on our server. > > > >On Tue, Apr 1, 2014 at 11:49 AM, morchella >wrote: > >> thanks guys! i was unfamilar with onServerStart. looking now! >> Much appreciated! >> >> >> >> On Tue, Apr 1, 2014 at 11:44 AM, Bobby wrote: >> >>> >>> The behavior you explained is expected. onApplicationStart() isnšt >>> triggered until the first request to the application. >>> >>> Check out onServerStart and Server.cfc >>> >>> >>> >>>http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS7AC9408A-1AC6-4ab7- >>>9C8 >>> >>>E-CF1DA8FCA16D.html<http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/W >>>S7AC9408A-1AC6-4ab7-9C8E-CF1DA8FCA16D.html> >>> >>> >>> >>> >>> On 4/1/14, 11:31 AM, "morchella" wrote: >>> >>> > >>> >so i am trying some thing out on localhost befor i move to dev >>> >i want to know when my cf server was started or restarted. >>> >so after my onApplicationStart >>> >i put in a cfmail and fir up an instance of cf9 for my localhost. >>> > >>> >i dont get the email unless i actually goto 127.x.x.x to view a page. >>> >i thought i should get it imeditaly when the server starts? >>> > >>> >how would or should i be doing this. >>> >thanks a bunch. >>> >will help to know when offshore reboots some thing with out informing >>>us. >>> > >>> >-m >>> > >>> > >>> > >>> >>> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: onApplicationStart and cfmail, when doess server start?
The behavior you explained is expected. onApplicationStart() isn¹t triggered until the first request to the application. Check out onServerStart and Server.cfc http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS7AC9408A-1AC6-4ab7-9C8 E-CF1DA8FCA16D.html On 4/1/14, 11:31 AM, "morchella" wrote: > >so i am trying some thing out on localhost befor i move to dev >i want to know when my cf server was started or restarted. >so after my onApplicationStart >i put in a cfmail and fir up an instance of cf9 for my localhost. > >i dont get the email unless i actually goto 127.x.x.x to view a page. >i thought i should get it imeditaly when the server starts? > >how would or should i be doing this. >thanks a bunch. >will help to know when offshore reboots some thing with out informing us. > >-m > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how to check if a remote file exists
What is running on your w2k3 server? Is there a web server through which the source/txt file is accessible? If so, sure, cfhttp can go out and grab it over HTTP. Being a txt file, you wouldn't have to do anything fancy, just point CFHTTP to the txt URL and then read the resulting file content or even use the path and file attributes of CFHTTP to read and save the file at the same time. If there is no web server on the W2k3 server that holds the file, then your options change. If the two servers are on the same network, then you could run the CF service as an account that has access to reach the file over UNC then just use the UNC paths like you would normal paths in your cffile tag(s). If they are not on the same network (and you can¹t set them up that way), then there are many ways that you could have the w2k3 server ³send² the file to the other machine when it generates it. I believe you said there is a visual fox pro app on the w2k3 box. If you control that app and can change it, it is capable of POSTing a file to a URL (url being a page you setup on your CF server to accept a multipart/form-data post to upload the file). If you can¹t edit the VFP app, then you could install CURL on the W2k3 box and still do the same thing Have CURL post the file to a page you set up on your CF server. Your CURL command would be a one liner that you could either schedule with windows scheduler or you could set up a service on the w2k3 box to monitor changes to the txt file and trigger the POST automatically anytime it changes. On 4/1/14, 5:37 AM, "Russ Michaels" wrote: > >if you have direct access tot he server with the file then you would use >CFFILE to copy it. >If the file is only accessible over the web, then you can use CFHTTP to >grab the file content and save to your local server. You will of course >not >get the raw file, only what is displayed in a browser. > > > >On Tue, Apr 1, 2014 at 9:50 AM, safo 2000 wrote: > >> >> i am a bit confused, this is the first time I do this kind of request so >> bear with me. >> >> I am trying to do the following: >> >> i created a cf app on the source server (w2k3) >> >> >> SELECT proxloc from MainServer >> >> > >>fname="#param.proxloc#\@conv_#dateformat(dateadd("d",-1,now()),'dd-mm-yyy >>y')#.txt"> >> >> >> >> (the above will check for the file and find it) >> >> then i need to copy the file to the cf server and work with it, >> that's were you lost me. >> >> not found >> >> >> >> > >ok, so then how would I do the copy from w2k3 to cf9 server >> > >> > You would use CFHTTP to grab the content from the other server, and >> > then save it as a file on your CF9 server. >> > >> > Personally I would do a separate CF app, scheduled in the CF >> > administrator, that would periodically look for the file on the other >> > server, and if it is there, grab it and download it. >> > >> > Then when your aggregation app runs, it just has to worry about >> > content on your server. >> > >> > YMMV of course - I'm looking at it from the perspective of an >> > application I worked on where the other server wasn't that reliable, >> > and separating the "grab files from the other server" and "process >> > files" helped troubleshooting tremendously. >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: "The long tail of ColdFusion fail"
Yeah, Dave Haven¹t you ³learnt² anything? On 3/29/14, 8:38 AM, "Jenny Gavin-Wear" wrote: > >Dave, I am curious. Have you ever, even once, changed your mind because >of >what someone has told you? > > >-Original Message- >From: Dave Watts [mailto:dwa...@figleaf.com] >Sent: 28 March 2014 18:07 >To: cf-talk >Subject: Re: "The long tail of ColdFusion fail" > > >> if you think no-one uses Windows web servers then you are wrong, very >wrong. > >Uh, yeah, I know that. That was my point. > >> It would seem you also think that Windows is not locked down by >> default, that may have been true once upon a time, but is no longer >> the case and hasn't been for many years.Certainly since Windows Server >> 2008, you must specifically choose which roles to install, everything >> is not installed by default, the firewall is also installed and >> enabled by default with only the basic required services allowed through >and networking is also disabled. > >I guess you can interpret "many years" however you like, but the simple >fact >is, from the beginning and through the majority of the lifespan of Windows >servers, this was not the default. And I don't think Windows would have >been >nearly as popular for servers if it had started out that way. The fact >that >things worked by default gave Windows market share. > >Dave Watts, CTO, Fig Leaf Software >1-202-527-9569 >http://www.figleaf.com/ >http://training.figleaf.com/ > >Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA >Schedule, >and provides the highest caliber vendor-authorized instruction at our >training centers, online, or onsite. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: "The long tail of ColdFusion fail"
Re: The long tail of analogy hell. On 3/28/14, 4:42 PM, "Russ Michaels" wrote: > >A locked door is useless if you leave the windows open. > >Russ Michaels >www.michaels.me.uk >cfmldeveloper.com >cflive.net >cfsearch.com >On 28 Mar 2014 19:09, "Dave Watts" wrote: > >> >> > I also once had a client who did this, they were Linux heads who >>thought >> > that hiding the "sucky insecure windows/cf server" behind a linux >>server >> > and doing a reverse proxy would make it secure. >> >> There is no such thing as "make it secure", of course. But it is more >> secure. It solves one specific security problem - preventing >> executable code from being directly accessed from an untrusted >> network. >> >> > But of course it didn't as everything still works the same way, the >>SQL >> > injections still got through, the insecure file upload forms still >> allowed >> > files to be uploaded, which could then be executed as they had >>cfexecute >> > and cfregistry enabled. >> >> So what you're saying is that, despite the fact that the environment >> was (more) secure by default, developers accidentally wrote >> exploitable code? >> >> I have the feeling there's some lesson to be drawn from this. I wonder >> what it is? >> >> Dave Watts, CTO, Fig Leaf Software >> 1-202-527-9569 >> http://www.figleaf.com/ >> http://training.figleaf.com/ >> >> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >> GSA Schedule, and provides the highest caliber vendor-authorized >> instruction at our training centers, online, or onsite. >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Quick Survey
*Throws keyboard in the air and gives programming¹ the finger while walking away* On 3/26/14, 9:20 AM, "Phillip Vector" wrote: > >To show how things can be twisted... > >"poll does not count / quantify people who're choosing not to learn a new >language at this time." > >So it doesn't count people who are giving up programing altogether. :) > > >On Wed, Mar 26, 2014 at 5:55 AM, Robert Harrison >> wrote: > >> >> > @Robert Did you looked into Railo? If clients don't want to use Adobe >> Coldfusion due to the recent bad news, I've been recently able to sell >> Railo to them instead. >> >> It's not recent bad news that caused this. It's been a long slow >>decline >> that Adobe has failed to address with any marketing or rebranding >> initiatives. The perception of the technology, the limitations and >>costs >> of available hosts, the limited number of developers, and the facts >>that no >> IT departments (that I know of) teach ColdFusion as part of their >> curriculum is the issue. Adobe could has long since addressed all of >>these >> issues. >> >> >> Robert Harrison >> Director of Interactive Services >> >> Austin & Williams >> Advertising I Branding I Digital I Direct >> 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 >> T 631.231.6600 X 119 F 631.434.7022 >> http://www.austin-williams.com >> >> Blog: http://www.austin-williams.com/blog >> Twitter: http://www.twitter.com/austin_wi >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation mystery
Exception.log On 2/2/14, 12:18 PM, "Rob Voyle" wrote: > >Hi Timothy > >Which log would the error be in. I can't find the error in any of the >logs. >The site is public and only displays a generic error template rather than >the >specific error. > >Rob > >On 2 Feb 2014 at 11:58, Timothy Heald wrote: > >> >> What's the error message? >> On Feb 2, 2014 11:42 AM, "Rob Voyle" wrote: > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cumulative Hotfix 3 & 4
Right, cumalative would mean that 4 includes 3 (and previous). Russ is right, there are plenty of security patches that are NOT in the cumulative hotfix. I do believe the "unofficial updater" has many of them included though so you might consider that if you are looking for more than what is in the cumulative hotfix. On 10/4/13 4:01 AM, "Russ Michaels" wrote: > >yes each CHF includes all fixes from previous ones. >You should however be sure to check carefully on their site what is NOT >included, often security fixes are not included. > > >On Fri, Oct 4, 2013 at 8:06 AM, Nick Gleason >wrote: > >> >> Hi All, >> A quick question. I need to install Cumulative Hotfix 3 and 4 on a >>server. >> If I install 4, will that include 3 (as the word cumulative seems to >> imply)? Or do I need to install CH 3 first and then install CH 4? >> Thanks! >> Nick >> >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FusionReactor log archive stopped working
We have MANY servers all running the exact same setup All with fusion reactor installed. All of the FR logging and log archive settings are identical but one of them stopped archiving the logs for some reason. Instead of archiving, it just grows the active log file forever. Since it only purges archived logs, drive space is an issue. I tried to trigger the archival manually in FR Log Archive UI. It claimed success but showed 0mb for the archive sizes and the archive directory remains empty. I then set the log rotation to every 1 minute and watched the Log Archive UI do the same thing automatically every 1 minute Archives aren't created and "live" log files continue to grow. Anyone else seen this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: assess/
Since I'm on this list... I'm going to go with the name. On 7/2/13 11:06 AM, "Mark A Kruger" wrote: > >Is this a request for analysis or is he calling us a peculiar (and >misspelled) name? > >-Original Message- >From: Matthew Friedman [mailto:m...@hozgroup.com] >Sent: Tuesday, July 02, 2013 8:34 AM >To: cf-talk >Subject: assess/ > > >A >Sent from my iPhone > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Live
It throws an error on CF as well. createObject error no less. Security: The requested template has been denied access to createobject(java). On 5/29/13 3:06 PM, "Raymond Camden" wrote: > >FYI, using CFDUMP/Railo throws an error. > > >On Wed, May 29, 2013 at 1:31 PM, Russ Michaels >wrote: > >> >> Greetings, >> >> Just thought I would share this new CF App I have recently released >>last >> week, hopefully this will be useful to the community and might perhaps >> encourage a few more people to try out CFML, you cannot really get any >>less >> effort than this. >> >> www.cflive.net >> >> >> -- >> >> -- >> >> *Russ Michaels* >> Blog: www.michaels.me.uk >> *skype*: russmichaels >> >> *My other sites/projects* >> www.bluethunder.co : SME hosting solutions >> www.cfmldeveloper.com: ColdFusion/Railo developer hosting >> www.cfsearch.com : ColdFusion search engine >> www.cflive.net : Live CFML console/testing tool >> >> ** >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
Like Russ said, check the stack. If you can't seem to catch it, you can set up FusionReactor to send you notifications (that include the stack trace) when threads hit a certain time in their life span. You said you didn't think it was DB. How did you determine that? Does it mean you are using the FusionReactor JDBC wrapper on the datasource? If not, then I suggest doing that so you can get a full picture of what's going on with the DB actions in your request. On 5/24/13 8:39 PM, "Richard Steele" wrote: > >How can I determine what causes a coldfusion 8 page to be fast loading >sometimes and other times, extremely slow? The server seems to have >enough memory and the traffic is not high. The db query part of the page >is fast according to Fusion Reactor. I don't see any leads in the Fusion >Reactor Request Detail. What else should I check? Thanks in advance. >Rick > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT but worth it - Sabin Adams
I'd imagine most people on this list frequent cfobjective.com but, for those who do not, I hope you enjoy this as much as I did. http://www.cfobjective.com/news/cfobjective-invests-in-future-cfml-programme rs/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: NY Area Recruiters
But he who we do not speak of no longer DOES CF, Phil! lol On 4/29/13 7:08 PM, "Phillip Vector" wrote: > >Either that or it's a sign that they picked up that you misspelled >"Recruiters" or it could be that you don't specify what you know. CFC's? >Frameworks? Other Skillsets? > >It also could be that you only waited 1 hour from 3:30 EST to 4:30 EST. >You >also don't even give a name, so why would people want to even talk to >someone who is hiding behind an email? Sounds like a Michael Firth >situation. > >On Mon, Apr 29, 2013 at 4:02 PM, wrote: > >> >> Yes, I've been on this list since forever. I normally don't break >> protocal, but there have been no responses. If there are no recruiters >>in >> NY seeking incredible CF programmers it should be a concern to us all. >>That >> could indeed be a sign of the state of CF. >> > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Optimising SQL Statement
You could start by replacing SELECT * with SELECT column1, column2, column3, etc. On 4/26/13 6:56 AM, "Richard White" wrote: > >Hi, I am sure there must be a way to restructure this query to bring the >time down but i cannot see it. Any pointers at all would be greatly >appreciated. > >> Hi, >> >> We have a problem with one of our MySQL statements and wondering if >> you guys can help point us in the right direction. >> >> Basically the following statement is taking 5 seconds to run. We have >> diagnosed it is down to the join of two select statement. When the >> select statements are run individually they take only 0.2 seconds but >> when combined with the JOIN it takes 5 seconds. >> >> WE have been told then when MySQL performs a join it creates temporary >> tables in the background. Is this correct? >> >> Is there anything you can see that we are doing wrong or can you see a >> better way? >> >> code start -- >> >> SELECT temp_4.primaryid, temp_1.`subjectID` , temp_4.`testOccasionID` , >> `studyNumbers` ,`testDate` >> >> FROM ( > >> SELECT * FROM ( > >> SELECT primarys.primaryid , q_1 AS `subjectID` , q_2 AS `studyNumbers` >> FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = >> questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL GROUP BY >> primaryid) AS maintable_1 >> GROUP BY `subjectID` ) AS temp_1 >> >> JOIN >> >> (SELECT * FROM >> (SELECT primarys.primaryid , q_1 AS `subjectID` , q_4 AS >> `testOccasionID` , DATE_FORMAT(q_5, '%m/%d/%Y') AS `testDate` FROM >> primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = >> questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL AND q_4 IS >> NOT NULL GROUP BY primaryid) AS maintable_4 >> GROUP BY `subjectID` ,`testOccasionID` ) AS temp_4 >> >> ON temp_1.`subjectID` = temp_4.`subjectID` >> >> code end -- >> >> Many thanks >> Richard > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to learn to build mobile apps..
phonegap+ It was very easy to figure out. We used it recently to convert a responsive hack day project into a mobile app. It worked like a champ. On 4/19/13 6:27 AM, "Raymond Camden" wrote: > >I'd take a look at PhoneGap (phonegap.com). > > >On Fri, Apr 19, 2013 at 12:59 AM, Cameron Childress >wrote: > >> >> I like Titanium: >> >> Some decent but not awesome basic instruction: >> >> >>http://mobile.tutsplus.com/tutorials/appcelerator/appcelerator-developmen >>t/ >> >> -Cameron >> >> >> On Fri, Apr 19, 2013 at 1:45 AM, Jerry Milo Johnson > >wrote: >> >> > >> > Phonegap (html5/css/js skillz needed) >> > >> > Titanium (js skillz needed) >> > >> > Native development (2 different environments, one for iDevices, one >>for >> > Android) >> > >> > if at all possible, I prefer the first. >> > >> > >> > On Fri, Apr 19, 2013 at 1:41 AM, Mike K wrote: >> > >> > > >> > > I need to learn how to build mobile apps for iPad/iPhone and >>Android. >> > > >> > > I have been building responsive web sites for mobile devices and >>think >> I >> > > have a reasonable understanding of the issues involved with that, >>but I >> > > have a project coming up that will require a full-on app not just a >>web >> > > site. >> > > >> > > So here's my question to those of you who build mobile apps ... how >> > would I >> > > go about learning this? Is there a course i can take? On line >> course? >> > > Books?Where do i gather the skills? >> > > >> > > I dont have a tertiary qualification in programming - everything >>I've >> > > learned so far I've picked up along the way, so I have quite a steep >> > > learning curve for building mobile apps, I think. >> > > >> > > >> > > Cheers >> > > Mike Kear >> > > Windsor, NSW, Australia >> > > Adobe Certified Advanced ColdFusion Developer >> > > AFP Webworks >> > > http://afpwebworks.com >> > > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month >> > > >> > > >> > > >> > >> > >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone ever created their own email archive with CF?
I guess you could really only control the initial TO with that solution. On 4/16/13 1:25 PM, "Bobby" wrote: > >How about BCC to a designated box? > >On 4/15/13 9:04 PM, "Rick Faircloth" wrote: > >> >>I've been trying to find a good way to store email >>*from* AND *to* my clients. (you know, create that >>really handy paper trail you need sometimes...) >> >>I've tried all sorts of ways from The Brain to Evernote >>to One Note, but nothing works easily or automatically. >> >>Just wondering if anyone has tried this. I found nothing >>about it when searching the Internet. >> >>Rick >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone ever created their own email archive with CF?
How about BCC to a designated box? On 4/15/13 9:04 PM, "Rick Faircloth" wrote: > >I've been trying to find a good way to store email >*from* AND *to* my clients. (you know, create that >really handy paper trail you need sometimes...) > >I've tried all sorts of ways from The Brain to Evernote >to One Note, but nothing works easily or automatically. > >Just wondering if anyone has tried this. I found nothing >about it when searching the Internet. > >Rick > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
Your session is tied to the application. With a 10 second timeout, you are more than likely seeing the application timeout (which means all the sessions in it are gone too). You can prove this by changing the application name to something like #createUUID()# or #now()# and seeing if that is also changing when you experience your issue. My guess is that every time you see this issue, the application name will have changed. On 3/15/13 12:41 PM, "Bobby" wrote: > >They are different because the sessions aren't persisting. They are being >recreated on each request. > >Whats the session timeout? > >On 3/15/13 11:37 AM, "funand learning" wrote: > >> >>also cfid cftoken are same for me before and after form submission. When >>I >>asked my colleague to test, I see they are different before and after >>form >>submission. I thought this issue happens when we use cflocation, but I am >>not using this tag either >> >>On Fri, Mar 15, 2013 at 11:34 AM, funand learning >>wrote: >> >>> sorry, it is remote_host in my code. I will try to increase application >>> time out and try >>> >>> >>> On Fri, Mar 15, 2013 at 12:32 PM, Bobby wrote: >>> >>>> >>>> No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is >>>> cgi.remote_host. >>>> >>>> Cgi.remotehost will result in an empty string. >>>> >>>> On 3/15/13 11:24 AM, "Matt Quackenbush" wrote: >>>> >>>> > >>>> >Your application timeout is seriously set to 10 seconds?? I suspect >>>>that >>>> >would hose sessions pretty quickly, but not sure, since I've never >>>>set an >>>> >app timeout so short. :-) >>>> > >>>> >HTH >>>> > >>>> > >>>> >On Fri, Mar 15, 2013 at 11:18 AM, funand learning >>>> >wrote: >>>> > >>>> >> >>>> >> I did enable session management using cfapplication tag. Below is >>>>the >>>> >>piece >>>> >> of code >>>> >> >>>> >> >>> >> applicationtimeout="#createtimespan(0, 0, 0, 10)#" >>>> >> sessionmanagement="yes" >>>> >> clientmanagement="no"> >>>> >> >>>> >> >>>> >> On Fri, Mar 15, 2013 at 12:15 PM, Bobby >>>>wrote: >>>> >> >>>> >> > >>>> >> > Sounds like your sessions aren't persisting across requests. >>>>There >>>> >>could >>>> >> > be a couple of reasons but the most common, from what I've seen, >>>>is >>>> >>that >>>> >> > people forget to enable session management in their application. >>>> >> > >>>> >> > >>>> >> > On 3/15/13 10:43 AM, "fun and learning" >>>> >>wrote: >>>> >> > >>>> >> > > >>>> >> > >I am converting a hidden variable to session variable. I am >>>>setting >>>> a >>>> >> > >session variable when a page loads. The page consists of a form >>>> >> > > >>>> >> > > >>>> >> > > >>>> >> > >When the form is submitted, the session variable is saved to a >>>>file. >>>> >>The >>>> >> > >form submits to the same page except there is a condition, >>>> >> > > >>>> >> > > >>>> >> > > >>>> >> > > >>>> >> > > >>>> >> > >The problem is when I submit the form on my computer, the >>>>session >>>> >> > >variable exists and form submission works fine. But when I asked >>>> some >>>> >> > >other people at my office to test, they get 'Element host is >>>> >>undefined >>>> >> in >>>> >> > >session' on form's submission.Looks like it is failing in >>>> >> savetofile.cfm. >>>> >> > >Why could this be happening? >>>> >> > > >>>> >> > > >>>> >> > > >>>> >> > >>>> >> > >>>> >> >>>> >> >>>> > >>>> > >>>> >>>> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
They are different because the sessions aren't persisting. They are being recreated on each request. Whats the session timeout? On 3/15/13 11:37 AM, "funand learning" wrote: > >also cfid cftoken are same for me before and after form submission. When I >asked my colleague to test, I see they are different before and after form >submission. I thought this issue happens when we use cflocation, but I am >not using this tag either > >On Fri, Mar 15, 2013 at 11:34 AM, funand learning >wrote: > >> sorry, it is remote_host in my code. I will try to increase application >> time out and try >> >> >> On Fri, Mar 15, 2013 at 12:32 PM, Bobby wrote: >> >>> >>> No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is >>> cgi.remote_host. >>> >>> Cgi.remotehost will result in an empty string. >>> >>> On 3/15/13 11:24 AM, "Matt Quackenbush" wrote: >>> >>> > >>> >Your application timeout is seriously set to 10 seconds?? I suspect >>>that >>> >would hose sessions pretty quickly, but not sure, since I've never >>>set an >>> >app timeout so short. :-) >>> > >>> >HTH >>> > >>> > >>> >On Fri, Mar 15, 2013 at 11:18 AM, funand learning >>> >wrote: >>> > >>> >> >>> >> I did enable session management using cfapplication tag. Below is >>>the >>> >>piece >>> >> of code >>> >> >>> >> >> >> applicationtimeout="#createtimespan(0, 0, 0, 10)#" >>> >> sessionmanagement="yes" >>> >> clientmanagement="no"> >>> >> >>> >> >>> >> On Fri, Mar 15, 2013 at 12:15 PM, Bobby >>>wrote: >>> >> >>> >> > >>> >> > Sounds like your sessions aren't persisting across requests. There >>> >>could >>> >> > be a couple of reasons but the most common, from what I've seen, >>>is >>> >>that >>> >> > people forget to enable session management in their application. >>> >> > >>> >> > >>> >> > On 3/15/13 10:43 AM, "fun and learning" >>> >>wrote: >>> >> > >>> >> > > >>> >> > >I am converting a hidden variable to session variable. I am >>>setting >>> a >>> >> > >session variable when a page loads. The page consists of a form >>> >> > > >>> >> > > >>> >> > > >>> >> > >When the form is submitted, the session variable is saved to a >>>file. >>> >>The >>> >> > >form submits to the same page except there is a condition, >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> > >The problem is when I submit the form on my computer, the session >>> >> > >variable exists and form submission works fine. But when I asked >>> some >>> >> > >other people at my office to test, they get 'Element host is >>> >>undefined >>> >> in >>> >> > >session' on form's submission.Looks like it is failing in >>> >> savetofile.cfm. >>> >> > >Why could this be happening? >>> >> > > >>> >> > > >>> >> > > >>> >> > >>> >> > >>> >> >>> >> >>> > >>> > >>> >>> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is cgi.remote_host. Cgi.remotehost will result in an empty string. On 3/15/13 11:24 AM, "Matt Quackenbush" wrote: > >Your application timeout is seriously set to 10 seconds?? I suspect that >would hose sessions pretty quickly, but not sure, since I've never set an >app timeout so short. :-) > >HTH > > >On Fri, Mar 15, 2013 at 11:18 AM, funand learning >wrote: > >> >> I did enable session management using cfapplication tag. Below is the >>piece >> of code >> >> > applicationtimeout="#createtimespan(0, 0, 0, 10)#" >> sessionmanagement="yes" >> clientmanagement="no"> >> >> >> On Fri, Mar 15, 2013 at 12:15 PM, Bobby wrote: >> >> > >> > Sounds like your sessions aren't persisting across requests. There >>could >> > be a couple of reasons but the most common, from what I've seen, is >>that >> > people forget to enable session management in their application. >> > >> > >> > On 3/15/13 10:43 AM, "fun and learning" >>wrote: >> > >> > > >> > >I am converting a hidden variable to session variable. I am setting a >> > >session variable when a page loads. The page consists of a form >> > > >> > > >> > > >> > >When the form is submitted, the session variable is saved to a file. >>The >> > >form submits to the same page except there is a condition, >> > > >> > > >> > > >> > > >> > > >> > >The problem is when I submit the form on my computer, the session >> > >variable exists and form submission works fine. But when I asked some >> > >other people at my office to test, they get 'Element host is >>undefined >> in >> > >session' on form's submission.Looks like it is failing in >> savetofile.cfm. >> > >Why could this be happening? >> > > >> > > >> > > >> > >> > >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
Sounds like your sessions aren't persisting across requests. There could be a couple of reasons but the most common, from what I've seen, is that people forget to enable session management in their application. On 3/15/13 10:43 AM, "fun and learning" wrote: > >I am converting a hidden variable to session variable. I am setting a >session variable when a page loads. The page consists of a form > > > >When the form is submitted, the session variable is saved to a file. The >form submits to the same page except there is a condition, > > > > > >The problem is when I submit the form on my computer, the session >variable exists and form submission works fine. But when I asked some >other people at my office to test, they get 'Element host is undefined in >session' on form's submission.Looks like it is failing in savetofile.cfm. >Why could this be happening? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
I guess you had no luck finding an instance of jsStringFormat(). Does the value ever hit a scope covered by global script protection before it gets set to the app scope? You could easily rule it out by making sure it is off or turning it off long enough to test. On 3/14/13 12:25 AM, "Kym Kovan" wrote: > >Rick, > >how are you returning this structure? You haven't got some funny format >turning on as the return from the CFC function by accident have you? > >Kym > >On 14/03/2013 15:49, Rick Faircloth wrote: >> >> The application.temp_images_directory is being set in application.cfc: >> >> >> >> The last part of the example below, the >>#newImageFileName#.#originalImageExt# >> is being set in news.cfc, after an image has been uploaded. It's done >>this >> way to be able to manipulate the filename part before the extension, >>such as: >> >> #newImageFileName#_400.#originalImageExt# >> >> I'm checking it right now by setting struct variables >> in a cfc such as, >> >> > >>'#application.temp_images_directory#\#newImageFileName#_400.#originalImag >>eExt#' /> >> >> then, just returning the struct to the calling page: >> >> >> >> The saveNewsItemStruct.APPTEMP would end up looking like: >> >> e:\\temp_images\\duck_400.jpg >> >> And when I tried Dave's solution of using forward slashes, /, >> instead of back slashes, I'd end up with: >> >> e:\/temp_images\/duck_400.jpg >> >> I'm not sure what is inserting the backslashes. I don't believe >> I've ever run into this before. >> >> Rick >> >> >> >> -Original Message- >> From: Jerry Milo Johnson [mailto:jmi...@gmail.com] >> Sent: Wednesday, March 13, 2013 10:18 PM >> To: cf-talk >> Subject: Re: Why is this happening?? >> >> >> how are you displaying it when the \ are appearing doubled? (something >>like >> a js alert, or a cfoutput to an html page, or some other mechanism?) >> >> >> On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth >> wrote: >> >>> >>> If I use this on a test page: >>> >>> #application.temp_images_directory# >>> >>> it comes out fine: e:\inetpub\webroot\tempImages >>> >>> I just don't see why (or how) it could be happening. >>> >>> Thanks for the feedback! >>> >>> Rick >>> >>> -Original Message- >>> From: Jerry Milo Johnson [mailto:jmi...@gmail.com] >>> Sent: Wednesday, March 13, 2013 9:34 PM >>> To: cf-talk >>> Subject: Re: Why is this happening?? >>> >>> >>> what happens if you display the value INSIDE the cfc before you return >>>it? >>> what happens if you set the same variable OUTSIDE the cfc and display >>>it? >>> >>> >>> On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth >> wrote: >>> This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: >> 'e:\inetpub\webroot\tempImages' /> and use it in news.cfc like this: >>>'#application.temp_images_directory#' /> why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick >>> >>> >>> >>> >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
That is the equivalent of what you would see if you ran that variable through jsStringFormat() somewhere. I'd run a quick search for that. I'd start in the app.cfc with that search to make sure you don't have a routine somewhere that "cleans' your variables for you. On 3/13/13 8:23 PM, "Rick Faircloth" wrote: > >This has been driving me crazy for two days and I GIVE UP! AHH! > > >If I create this variable in application.cfc: > >'e:\inetpub\webroot\tempImages' /> > > >and use it in news.cfc like this: > > > > > > >why in the WORLD would I get this: > >e:\\inetpub\\webroot\\tempImages > > >when I return the struct and display saveNewsItemsStruct.ATID? > >Why are the path lines doubling? > > >I don't think I've seen this in 15 years of CF programming! > >(I'm getting too old for all this aggravation...) > >Thanks for any help! > >Rick > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions _m-r_07.html "Gets the current date and time of the computer running the ColdFusion server" It doesn't get its time form the VPN, it gets its time from the host machine running the CF service. Clock in the bottom right corner of windows has the time that the CF server would use. If, for some reason, you've hidden the clock, cmd.exe > echo %time% Your windows timezone could be off or you don't have the option set to adjust for daylight savings time. On 3/12/13 8:05 AM, "daniel kessler" wrote: > >It's a localhost CFServer (developer mode). That is on a VPN that I am >using. The VPN has the correct time. However the now() is incorrect. >It was correct until daylight savings time. > >At this point, I assume that it's getting the time from the machine that >is hosting the VPN, which means that the VPN can have a different time. >However since I don't know where now() gets it's time, I can't get any >traction on this from our support staff. > >> Check the date and time on the ColdFusion server. Also, make sure that >> your DB server and ColdFusion server are in the same time zone. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adding Salt and Password Hash to existing acocunts
In the example it was a hardcoded string for the salt. 'mySalt'. you'd just replace that with whatever you intend to use. I haven't used SHA512 this way. I only did it the way I did so there was an equivalent method in CF to generate the same hash. You'd have to play around with generating SHA512 hashes in TSQL and make sure you are also able to generate that same hash in CF (assuming you will be doing your hashing in CF at all before sending to the database). You can do as many iterations of the salt as you want I suppose. If I was going to hash multiple times, I'd salt them all. On 3/11/13 9:05 AM, "Torrent Girl" wrote: >SHA512 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE Issue
I'd probably start by trying one of these instead just to see if it made a difference: ./pdf/voucher#user_id#.pdf Or #expandPath('./pdf/')# & 'voucher#user_id#.pdf' On 3/7/13 3:41 PM, "Bruce Sorge" wrote: > >I am having something strange going on today with my dev machine. I have >an app that writes a PDF: > >nameconflict="make unique"> > >It has been working great, but today when I ran it I was given an java.io >error that a folder did not exist. Funny thing was that it was looking at >the following path: > >ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. >But as you can see in my cffile I am pointing to a local folder called >PDF that is in the same directory as the .CFM file calling it. Any ideas? > >Also, this is a duplicate of another app that I have that does the exact >same thing, and it works fine. That app is in another directory, and the >only difference is that this new one allows the site admin to generate a >PDF for one customer where the other app I have sends PDF's to all users >who bought something the day prior. > >Thanks, > >Bruce > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adding Salt and Password Hash to existing acocunts
Password expirations would definitely be the way I would have gone with this. If I didn't have that option id probably just hash them all with a single update statement in SQL Server rather than involving CF at all. update userTable set passwordColumn = right(master.dbo.fn_varbintohexstr(hashBytes('MD5', cast(passwordColumn + 'mySalt' as nvarchar(max,32) Then, to convert a submitted password to that in CF, lcase(hash(passwordString & 'mySalt', 'MD5', 'UTF-16LE')) On 3/7/13 3:00 PM, "Roger Austin" wrote: > > Torrent Girl wrote: > >> Did you have a problem with timeouts or out of memory errors? >> >> I have quite a bit of records > >This is why I suggested that you pre-expire everyone and have them update >their credentials on next log in. >It spreads out the load and you have to have the code anyway. You might >check for a blank password field >and then send them to change their password to the new salted hash >version. Then, blank out the password >field at the same time. >-- >LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 >Twitter: http://twitter.com/RogerTheGeek >Google+: https://plus.google.com/117357905892731200369 > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adding Salt and Password Hash to existing acocunts
I suggest adding a new bit flag column to the table and only update records that have that flag set to 0. The password update query could set that flag to 1 so if you accidentally run that template twice, you don't hash and salt salted hashes. Step 1, back up the database. On 3/7/13 11:02 AM, "Torrent Girl" wrote: > >>Here you go. >> >> >>select memberid, password from users >> >>#getUserPasswords.RecordCount# >> >> >> >> >> >>>user.salt,"SHA-256","us-ascii")/> >> >>UPdate users set password = '#user.password#', salt = '#user.salt#' >>where memberid = '#memberid[currentrow]#' >> >> >> >> >> >> and we changed #count# >> >>Again, you will want to change one account and test it to make sure that >>your login routine will validate the password and login the user. Then >>you >>can just run this on the whole table, no muss no fuss. You won't have to >>make the users change anything, their passwords will just be secure. You >>will also have to come up with a Forgot Password routine, since the >>passwords are irretrievable. >> >>Cheers, >> >>Rob >> >> > > >Thank you! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adding Salt and Password Hash to existing acocunts
The original poster never said they were adding salts to existing hashes. They laid out the same scenario of converting plaintext passwords to salted hashes. On 3/5/13 7:06 PM, "Justin Scott" wrote: > >> I guess I didn't make myself clear. I wrote a routine that salted and >> hashed all of the plain text passwords that were in the system. > >Ah, that is a good thing then. I took it that you were adding salts >to an existing hash like the original poster. > > >-Justin > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone see anything wrong with the syntax of the query?
Use cfqueryparam to rule out the value of the arguments variable causing syntax related issues. When an error tells you the line number and it is in a query, it rarely is that actual line; it just knows it is in the query somewhere. On 3/5/13 11:47 AM, "Rick Faircloth" wrote: > >datasource="#arguments.real_estate_dsn#"> > > select substring_index(p.mls_number, '_', 1) as p.mls_number, > p.street_number, p.street_name, p.city, p.state, > oh.mls_number, oh.date, oh.start_time, oh.end_time, >oh.host_name > > fromproperties p > > left join fortstewart.open_houses oh > on substring_index(p.mls_number, '_', 1) = oh.mls_number > > where p.listing_office_mls_id = >'#arguments.listing_office_mls_id#' > order byp.street_name, p.street_number > > > >I keep getting a CF error stating I have a syntax error on this line: > >where p.listing_office_mls_id = >'#arguments.listing_office_mls_id#' > > >Anything? > >Thanks! > >Rick > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Localization , French Accents...
Any time. Glad it's worked out. On 2/27/13 3:56 PM, "Brook Davies" wrote: > >Bobby, thanks for the notepad+ idea - it was the encoding on the source >file > >-Original Message- >From: Bobby [mailto:bo...@acoderslife.com] >Sent: February-27-13 12:05 PM >To: cf-talk >Subject: Re: Localization , French Accents... > > >UTF-8 should do it. > >On 2/27/13 3:00 PM, "Brook Davies" wrote: > >> >>Should I be saving it in Unicode or UTF-8? >> >>-Original Message- >>From: Bobby [mailto:bo...@acoderslife.com] >>Sent: February-27-13 11:01 AM >>To: cf-talk >>Subject: Re: Localization , French Accents... >> >> >>My first guess is that it is happening when the file is read in. Was it >>saved as unicode? I think notepad lets you do that. If not, notepad++ >>does. >> >> >>On 2/27/13 12:52 PM, "Brook Davies" wrote: >> >>> >>>I am trying to read in a number of text files that contain >>>translations (using French in this example) and store them in my >>>applications app scope. >>>The file I am reading in looks like this: >>>http://screencast.com/t/DZTv3iVrbyo >>> >>>When I dump the results from reading in the file, or try to use them >>>in output, the accents get munged: >>>http://screencast.com/t/aoRcLWWHn >>> >>>I have tried everything I can think of to get this to work and >>>everything has failed. I have tried manually setting the charset on >>>the CFFILE tag and that has not helped. I tried using UTF-8, and >>>WINDOWS-1255. >>> >>>Since I have numerous language files I have even tried implementing >>>this java class org.mozilla.universalchardet.UniversalDetector that >>>detects the encoding of a file, and then using the detected encoding >>>when reading in the translation files. But no matter what I do, the >>>encoding is not preserved. >>>Note, this library tells me my French files are "WINDOWS-1255"./ >>> >>>Does anyone have any suggestions on how I can handle this? >>> >>>Brook >>> >>> >>> >>> >> >> >> >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Localization , French Accents...
UTF-8 should do it. On 2/27/13 3:00 PM, "Brook Davies" wrote: > >Should I be saving it in Unicode or UTF-8? > >-Original Message- >From: Bobby [mailto:bo...@acoderslife.com] >Sent: February-27-13 11:01 AM >To: cf-talk >Subject: Re: Localization , French Accents... > > >My first guess is that it is happening when the file is read in. Was it >saved as unicode? I think notepad lets you do that. If not, notepad++ >does. > > >On 2/27/13 12:52 PM, "Brook Davies" wrote: > >> >>I am trying to read in a number of text files that contain translations >>(using French in this example) and store them in my applications app >>scope. >>The file I am reading in looks like this: >>http://screencast.com/t/DZTv3iVrbyo >> >>When I dump the results from reading in the file, or try to use them in >>output, the accents get munged: >>http://screencast.com/t/aoRcLWWHn >> >>I have tried everything I can think of to get this to work and >>everything has failed. I have tried manually setting the charset on the >>CFFILE tag and that has not helped. I tried using UTF-8, and >>WINDOWS-1255. >> >>Since I have numerous language files I have even tried implementing >>this java class org.mozilla.universalchardet.UniversalDetector that >>detects the encoding of a file, and then using the detected encoding >>when reading in the translation files. But no matter what I do, the >>encoding is not preserved. >>Note, this library tells me my French files are "WINDOWS-1255"./ >> >>Does anyone have any suggestions on how I can handle this? >> >>Brook >> >> >> >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Localization , French Accents...
My first guess is that it is happening when the file is read in. Was it saved as unicode? I think notepad lets you do that. If not, notepad++ does. On 2/27/13 12:52 PM, "Brook Davies" wrote: > >I am trying to read in a number of text files that contain translations >(using French in this example) and store them in my applications app >scope. >The file I am reading in looks like this: >http://screencast.com/t/DZTv3iVrbyo > >When I dump the results from reading in the file, or try to use them in >output, the accents get munged: >http://screencast.com/t/aoRcLWWHn > >I have tried everything I can think of to get this to work and everything >has failed. I have tried manually setting the charset on the CFFILE tag >and >that has not helped. I tried using UTF-8, and WINDOWS-1255. > >Since I have numerous language files I have even tried implementing this >java class org.mozilla.universalchardet.UniversalDetector that detects the >encoding of a file, and then using the detected encoding when reading in >the >translation files. But no matter what I do, the encoding is not preserved. >Note, this library tells me my French files are "WINDOWS-1255"./ > >Does anyone have any suggestions on how I can handle this? > >Brook > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Graphic Artist Software for HTML CSS
In the beginning, I actually sliced designs. When I did, I used Image Ready. It was much better suited for the slicing part than Photoshop. On 2/22/13 12:04 PM, "Gerald Guido" wrote: > >In the past I have used Photoshop's Slice tool. It does a fairly decent >job >but I have always had to go in and massage it by hand. It does not by any >means leave you with finished product out of the box but it takes care of >a >lions share of the grunt work. > >HTH >G! > >On Fri, Feb 22, 2013 at 11:38 AM, Chad Gray wrote: > >> >> I have not kept track of all the graphic artist software adobe has come >> out with to go from mockups to HTML/CSS. >> >> >> >> If I were to tell a graphic designer to design me some mockups for a web >> site, what is the best adobe software that will export out to _CLEAN_ >> (looks like hand written J) HTML/CSS that I can inject my CF code easily >> into? >> >> >> >> Muse? >> >> >> >> Thanks! >> >> >> >> >> >> >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would you optimize this SQL?
Will it even cache the plan without the 1 being a parameter? In either case, I'd still advocate the use of schema prefixes/aliases. On 2/20/13 1:15 PM, "Dave Watts" wrote: > >> You could also add schema prefixes to your tables and columns (or alias >> them) as well as make the 1 a parameter. >> >> That should help with execution plan caching. > >Actually, caching the execution plan with a parameter here is probably >a bad idea - at least half the time! > >When you have a bit value (on/off) as a parameter, the execution plan >will either be very very good, or very very bad. You're better off not >using a parameter (which will give you two execution plans ultimately >that are more specific and both very very good) or using WITH >RECOMPILE to avoid the use of any cached execution plans at all. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >http://training.figleaf.com/ > >Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >GSA Schedule, and provides the highest caliber vendor-authorized >instruction at our training centers, online, or onsite. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would you optimize this SQL?
You could also add schema prefixes to your tables and columns (or alias them) as well as make the 1 a parameter. That should help with execution plan caching. Declare @myBit int Set @myBit = 1 SELECT @intCourseCompletions = COUNT(m.intMemberStageID) FROM dbo.tblMemberStages m WHERE m.bitCompleted = @myBit; On 2/20/13 11:30 AM, "Torrent Girl" wrote: > >> Well, that code would be equivalent to: >> >> SELECT @intCourseCompletions = COUNT(intMemberStageID) FROM >> tblMemberStages WHERE bitCompleted = 1; >> >> However I believe to get any performance increase you will need an >> index on bitCompleted. >> >> CREATE INDEX myindexname ON tblMemberStages (bitCompleted); >> >> You could also try: SELECT @intCourseCompletions = >> sum(cast(bitCompleted as int)) FROM tblMemberStages; >> >> The conversion to INT may or may not take longer. The index is >> probably your best bet but try both ways to see which works best. >> >> Steve >> >> -Original Message- >> From: Torrent Girl [mailto:moniqueb...@gmail.com] >> Sent: Wednesday, February 20, 2013 11:07 AM >> To: cf-talk >> Subject: How would you optimize this SQL? >> >> >Thank you. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone using CFPDF/CFPDFFORM to deliver personalized PDFs?
It has been a very long time but a number of years ago, I did a college application in PDF format. The PDF was already defined by the college and the format couldn't change. What I did was go into the PDF and make all of the "answer" sections form fields. Then, obviously, created a web form to gather all the answers. Once the form was submitted, all of those answers were used to generate a PDF answer file. The two files together populated the PDF with all the answers. It was tedious work since all the answer fields needed to match the PDF field names exactly (it was a huge application) but once that was done, it worked like a champ. It was all native CF code in (if I recall) CF6. On 12/12/12 10:59 AM, "Stephen Hait" wrote: > >We have an app that takes a user's info and uses it to populate an >existing, blank Acrobat PDF form template that the user can then view, >save >or print. We had been using a commercial component, ActivePDFToolkit, for >this on a CF7 platform. > >Our process previously had been to populate the PDF form template from a >query, then to flatten and save the resulting PDF with a unique name. Now >we want to use CF10 to accomplish the same goal. > >I'd be interested in discussing the approaches you may have taken for >doing >this type of thing with CF10. If anyone has experience with this and would >be willing to discuss how you've approached it, please let me know, either >through the list or by e-mail. > >Regards, >Stephen Hait >sh...@mindspring.com > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
Ha! I was about to reply with the exact same link... On 11/1/12 4:06 PM, "Dave Watts" wrote: > >> I have found it effective to block troublesome emails for some length of >> time, usually 6 months does it. > >http://instantrimshot.com/ > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >http://training.figleaf.com/ > >Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >GSA Schedule, and provides the highest caliber vendor-authorized >instruction at our training centers, online, or onsite. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HomeSite
I believe it was in the CFWACK for version 4.5 or 5. Maybe you have that book or know someone who does? On 10/7/12 10:27 AM, "Richard Colman" wrote: > >Hate to bring this up again, but I have used Homesite for many years and >do like it. > >I need to transfer the application to a new computer, and the original >install disks are long gone. > >Does anyone know of a source to obtain or purchase? > >TNX, > >signed ... the dinosaur ... > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFHeader Problem
Sorry. I didn't realize it was solved. It would help to not change the subject of the thread ;-) On 6/26/12 10:26 PM, "Bobby" wrote: > >Which CF Version? What is the file size of myfile.zip? And how much memory >is allocated to CF? > > >On 6/26/12 11:08 AM, "Robert Harrison" wrote: > >> >>According to the documentation the default is "yes". >> >> >>Robert Harrison >>Director of Interactive Services >> >>Austin & Williams >>Advertising I Branding I Digital I Direct >>125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 >>T 631.231.6600 X 119 F 631.434.7022 >>http://www.austin-williams.com >> >>Blog: http://www.austin-williams.com/blog >>Twitter: http://www.twitter.com/austin_williams >> >> >>-Original Message- >>From: >>Sent: Tuesday, June 26, 2012 11:04 AM >>To: cf-talk >>Subject: Re: CFHeader Problem >> >> >> >>What's wrong with the below? >> >>Don't you need RESET="yes" inside the CFCONTENT tag? >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFHeader Problem
Which CF Version? What is the file size of myfile.zip? And how much memory is allocated to CF? On 6/26/12 11:08 AM, "Robert Harrison" wrote: > >According to the documentation the default is "yes". > > >Robert Harrison >Director of Interactive Services > >Austin & Williams >Advertising I Branding I Digital I Direct >125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 >T 631.231.6600 X 119 F 631.434.7022 >http://www.austin-williams.com > >Blog: http://www.austin-williams.com/blog >Twitter: http://www.twitter.com/austin_williams > > >-Original Message- >From: >Sent: Tuesday, June 26, 2012 11:04 AM >To: cf-talk >Subject: Re: CFHeader Problem > > > >>What's wrong with the below? > >Don't you need RESET="yes" inside the CFCONTENT tag? > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF8 AdminApi throws errors.
I set the CF Admin to no authentication (just to test) and it appears to work. There server will be public facing once it is setup so I sure can't leave it that way. it is interesting though... .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Monday, June 04, 2012 2:00 PM To: cf-talk Subject: CF8 AdminApi throws errors. I've been using the admin API for years to list and create datasources so I am pretty familiar with it (which isn't to say I'm not doing something dumb and just missing it). We recently created two new CF8.0.1 machines (clones of a existing machines that work fine). There are hundreds of datasources on the cloned machines and I needed to clean them out and create new ones. I decided to use the admin API to do both tasks. However, all requests of any methods within the datasource.cfc are throwing odd errors on the new servers. For instance, a simple list of datasources (which i know I can get with the service factory but this is happening with datasource delete and create attempts as well) This is the code (quite basic and known to work elsewhere) The error behind that one is: The error occurred in datasource.cfc: line 67 -1 : Unable to display error's location in a CFML template. No actual error message; just that info. The stack points to authentication issues (coldfusion.security.SecurityManager$UnauthenticatedCredentialsException) but the "isLogged" check is true and im positive the password in "cfadminpassword" is correct (further indicated by isLoggedIn being "true"). The Cf Admin is set to "Use a single password only (default)" Here is the top of the stack: coldfusion.security.SecurityManager$UnauthenticatedCredentialsException at coldfusion.security.SecurityManager.authenticateAdmin(SecurityManager.java:1 704) at coldfusion.sql.Executive.getDatasources(Executive.java:92) at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:597) at coldfusion.runtime.StructBean.resolveName(StructBean.java:188) at coldfusion.runtime.Scope.get(Scope.java:60) at coldfusion.runtime.ScopeSearchResult.searchForSubkeys(ScopeSearchResult.java :104) at coldfusion.runtime.LocalScope.search(LocalScope.java:441) at coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:662) at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1653) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1612) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1747) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1740) at cfdatasource2ecfc498810217$funcGETDATASOURCES.runFunction(E:\cf8_updates\cfu sion\wwwroot\CFIDE\adminapi\datasource.cfc:67) Has anyone ran into this one before or have any ideas on what to try next? Thanks. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 AdminApi throws errors.
I've been using the admin API for years to list and create datasources so I am pretty familiar with it (which isn't to say I'm not doing something dumb and just missing it). We recently created two new CF8.0.1 machines (clones of a existing machines that work fine). There are hundreds of datasources on the cloned machines and I needed to clean them out and create new ones. I decided to use the admin API to do both tasks. However, all requests of any methods within the datasource.cfc are throwing odd errors on the new servers. For instance, a simple list of datasources (which i know I can get with the service factory but this is happening with datasource delete and create attempts as well) This is the code (quite basic and known to work elsewhere) The error behind that one is: The error occurred in datasource.cfc: line 67 -1 : Unable to display error's location in a CFML template. No actual error message; just that info. The stack points to authentication issues (coldfusion.security.SecurityManager$UnauthenticatedCredentialsException) but the "isLogged" check is true and im positive the password in "cfadminpassword" is correct (further indicated by isLoggedIn being "true"). The Cf Admin is set to "Use a single password only (default)" Here is the top of the stack: coldfusion.security.SecurityManager$UnauthenticatedCredentialsException at coldfusion.security.SecurityManager.authenticateAdmin(SecurityManager.java:1 704) at coldfusion.sql.Executive.getDatasources(Executive.java:92) at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:597) at coldfusion.runtime.StructBean.resolveName(StructBean.java:188) at coldfusion.runtime.Scope.get(Scope.java:60) at coldfusion.runtime.ScopeSearchResult.searchForSubkeys(ScopeSearchResult.java :104) at coldfusion.runtime.LocalScope.search(LocalScope.java:441) at coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:662) at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1653) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1612) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1747) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1740) at cfdatasource2ecfc498810217$funcGETDATASOURCES.runFunction(E:\cf8_updates\cfu sion\wwwroot\CFIDE\adminapi\datasource.cfc:67) Has anyone ran into this one before or have any ideas on what to try next? Thanks. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF real time data updates possible?
If you are on CF10 (in which case, I'd be jealous), then look into the new WebSockets. If not, then I believe you will be stuck polling for changes on regular intervals to get the submissions of others. Here is an example of websockets in CF10. http://www.bennadel.com/blog/2351-ColdFusion-10-Using-WebSockets-To-Push-A- Message-To-A-Target-User.htm On 6/3/12 4:57 PM, "Akos Fortagh" wrote: > >Wondering if anyone has a good suggestion how I might be able to achieve >the following without using flash if possible. >I have a simple interface where logged in users fill out 10 multiple >choice questions and at the end they get a score like 5 out of 10 etc. >The odd thing is that they must be able to see other users' scores real >time so it all becomes like a live competition. >Is there a way of 'pushing' the other users' scores somehow to the logged >in user's screen as soon as the 'other' users score some points? >Hopefully this all makes sense... >Or am I thinking the impossible? >Any help or suggestions would be much appreciated. >Akos > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Movie To Watch
FYI, There is a cf-community list for these types of off topic threads. On 5/12/12 1:30 PM, "Brian Thornton" wrote: > >Bobcat Goldthwait and Darko Productions put our a GREAT movie that >challenges society, religion and stereotypes... > >To me, Robin WIlliams through this movie explains why Dave Chapelle >would move to Africa. > >Thought I would share.. > >http://movies.netflix.com/WiMovie/World_s_Greatest_Dad/70112475?trkid=4966 >24 > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: date and time from two different inputs query a single datetime field
#createOBDCDateTime(form.xdate_use & ' ' & form.xtime)# On 5/10/12 9:50 PM, "Les Mizzell" wrote: > > ex: 05/31/2012 > ex: 3:31 PM > >Given the values used as examples for the fields above, exactly how >would I go about querying a datetime stamp field (SQL Server) to find >all records dates on or after the date/time above? > >No problem doing it with just the date: > > responsedate >= cfsqltype="CF_SQL_DATE" /> > > > but for the life of me, I can't figure how to put both fields together >to do date AND time... > >I'm probably an idiot.. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFINVOKE - Component Location
Try component="gallerycomponents.functions" ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FusionReactor - Development server
I saw that but it doesn't mention development. Their license does talk about a development license but doesn't talk about cost in the license. You ever have one of those dreams that seems s real? Apparently I have :-) On 4/14/12 10:23 AM, "andy matthews" wrote: > >Looks like you might have been dreaming: > >http://www.fusion-reactor.com/fr/faq.cfm#licencing1 > >Each physical or virtual server requires one FusionReactor license - all >of >the instances which are installed on that server are covered by the one >FusionReactor license. So, if you have (say) 6 physical boxes, then you >need >6 licenses. Note, that on a single box you may have multiple instances >(ColdFusion, JRun, Tomcat, JBoss) installed on it, but you still only >need 1 >license for that (virtual or physical) server. Virtual Machines (VM's) are >also classed as separate physical servers and therefore require a license. > > >andy > >-Original Message- >From: Bobby [mailto:bo...@acoderslife.com] >Sent: Saturday, April 14, 2012 8:31 AM >To: cf-talk >Subject: FusionReactor - Development server > > >I figured if anyone knew the answer to this (outside of FR Support), it >would be someone on this list© > >I may have dreamed this because I can't find it again but I thought I read >that if you bought a FusionReactor enterprise license, you were also >allowed >to install a second copy on a development server at no extra cost. > >Does anyone know whether or not that is true? > >Thanks > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FusionReactor - Development server
I figured if anyone knew the answer to this (outside of FR Support), it would be someone on this list I may have dreamed this because I can't find it again but I thought I read that if you bought a FusionReactor enterprise license, you were also allowed to install a second copy on a development server at no extra cost. Does anyone know whether or not that is true? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: random records no duplicates
There are more efficient ways of getting a single random record from the database. You are grabbing them all every time when you only need 1. SQL Server: SElECT TOP 1 q.questionid, q.questiontext FROM questions q ORDER BY NEWID() MySQL SELECT q.questionid, q.questiontext FROM questions q ORDER BY RAND() LIMIT 0,1 As for not showing a user the same question twice, you could store the questionIDs that they have seen in their session (or the questionIds that they havent seen... your call) and then filter those from your possible results. 1: Get a random record they havent seen SELECT TOP 1 q.questionid, q.questiontext FROM questions q WHERE q.questionId NOT IN ) ORDER BY NEWID() 2: Add it to the list of questions they have seen listappend(session.listofusedquestions, thisQuestionQuery.questionId) 3: Display the question. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Akos Fortagh [mailto:akos.fort...@yahoo.com] Sent: Thursday, March 29, 2012 4:22 AM To: cf-talk Subject: random records no duplicates hi there, wondering if someone might be able to help with this please. I have a simple questions table and I'm displaying one randomly generated question from it at a time. User clicks a button and the page reloads to give the next question. So far I have this simple bit working fine: SELECT questions.questionid, questions.questiontext FROM questions #questiontext# What would be the easiest approach to make sure that one question cannot be delivered twice? Any help would be greatly appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Moving CF8 Std to IIS7 Now Get Blank Screen
I have seen blank white pages served up when CF would run out of memory. CF Exception logs would show outOfMemory errors in those cases. Just something else to check. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Wednesday, March 28, 2012 5:15 PM To: cf-talk Subject: RE: Moving CF8 Std to IIS7 Now Get Blank Screen Except the subject stats Moving CF8 to IIS7... -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, 29 March 2012 8:13 AM To: cf-talk Subject: Re: Moving CF8 Std to IIS7 Now Get Blank Screen this is not required with CF9.01 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Local Dev Environment Troubles w/ Virtual Host- CF Builder
Did you add a hosts file entry for "127.0.0.1 myproject.dev" so it knows how to resolve it? .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Dan Kraus [mailto:dskr...@gmail.com] Sent: Tuesday, March 20, 2012 8:04 PM To: cf-talk Subject: Local Dev Environment Troubles w/ Virtual Host- CF Builder Hi All, long time reader, first time poster! But I'm beating my head against the wall here... I've been developing locally in CFBuilder on Windows 7. When I installed CFBuilder I used the "Built-In Webserver" option rather than local IIS or Apache or something else. Things have been working fine - I could access my server at http://localhost:8300, set up databases, and do the typical things one would expect. I have a few different projects in the root server each in their own folder. However, this required browsing to http://localhost:8300/myProjectFolder but to simulate the production sites, this couldn't continue. I wanted to set it up so I could do http://myproject.dev or some variation but the problem is I can't quite figure out how, or at least how to do it correctly. In my local server aptly named LocalDev configuration from CFBuilder, I added a Virtual Host named myproject.dev, Host name, myproject.dev, Port 8300 (same as the server) over http and pointed at my document root which lives in the cf server root folder. I had a multi-instance install so the path is C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\myProject I then right clicked on my project >Properties>Coldfusion Server Settings and selected my server with the virtual host. "LocalDev-myproject.dev" and see a Sample Url of http://myproject.dev:8300/ Now it looks like all systems go but when I try to browse there to a basic txt file right in the root http://myproject.dev:8300/readme.txt Chrome says "Oops! Google Chrome could not connect to myproject.dev:8300" Firefox equivalent is "The connection has timed out The server at myproject.dev is taking too long to respond." What am I doing wrong!? I'm going nuts over here! Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Image Crop/Resize Tool
+2000 .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Friday, February 24, 2012 4:28 PM To: cf-talk Subject: Re: Image Crop/Resize Tool Like so? http://cfimagecropper.riaforge.org/ On Fri, Feb 24, 2012 at 3:19 PM, Robert Harrison wrote: > > Does anyone know of a decent utility or CF compatible code that could be used to help users resize/crop the images they've uploaded. I know I could use CFIMAGE to do it, but I'd like to add something to the CMS that let users see what they are doing before they do it. > > Any ideas on what may be available? > > Thanks > Robert > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Difference between cfcontent and cfheader in terms its usage?
as the names suggest, cfheader is for creating HTTP response headers and cfcontent is for sending mime encoded content (generally that of a file). cfcontent can set the mime content header but it's the only header it sets. http://cfdocs.org/cfheader http://cfdocs.org/cfcontent .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jay Pandya [mailto:jaypandy...@gmail.com] Sent: Thursday, February 16, 2012 2:01 AM To: cf-talk Subject: Difference between cfcontent and cfheader in terms its usage? Difference between cfcontent and cfheader in terms its usage? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Java Keystore... why is it needed for valid certs?
That is more or less what I suspected but wasn't sure. Thanks for the clarification, Dave. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, February 13, 2012 12:54 PM To: cf-talk Subject: Re: Java Keystore... why is it needed for valid certs? > My question is why do I have to add these certificates to the keystore at > all? They validate fine in a browser (in fact, that is where I always get > the x.50- certificate from... by exporting it through the browser). The reason they validate fine in a browser is because browsers come with a pretty large set of root certificates. The JVM does not. My guess is you could import all of the root certificates from your browser into your JVM if you really wanted to, and not have to worry about anything for quite a while. Now, the fact that browsers come with so many trusted certificates is actually kind of a problem - when someone misuses a CA cert, it can be hard to ensure that the cert they fraudulently create isn't trusted by browsers by default. There isn't really a good universal revocation process. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Java Keystore... why is it needed for valid certs?
At work, we have a number of 3rd party vendors that we post to with CFHTTP calls. Unless we add their certificate to the java keystore, the CFHTTP connections fail. It wasn't a big deal at first, but the more vendors we support, the more certificates I add... and the more often a certificate is expiring. It is to the point where I'm updating one certificate or another every month or two. My question is why do I have to add these certificates to the keystore at all? They validate fine in a browser (in fact, that is where I always get the x.50- certificate from... by exporting it through the browser). This is only an issue for vendors that we have to CFHTTP post to; I do not need to import certificates to support vendors with web services. Is there a better method that wouldn't require updating the keystore everytime a certificate is renewed? .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
Sounds like the same solution in both cases unless I'm missing something. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Hong Chen [mailto:ho...@cbmiweb.com] Sent: Tuesday, February 07, 2012 6:47 PM To: cf-talk Subject: RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet I also have a download function, in there I have formatted the column with spreadSheetFormatColumn. If I use the downloaded file to upload, it reads 4 digits year. But if I create a new spreadsheet to upload. It only reads the last 2 digits of year. -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Tuesday, February 07, 2012 5:59 PM To: cf-talk Subject: [5] RE: cfspreadsheet issue when reads dates from spreadsheet Not sure why I was thinking after. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, February 07, 2012 5:42 PM To: cf-talk Subject: Re: cfspreadsheet issue when reads dates from spreadsheet > something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfspreadsheet issue when reads dates from spreadsheet
Not sure why I was thinking after. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, February 07, 2012 5:42 PM To: cf-talk Subject: Re: cfspreadsheet issue when reads dates from spreadsheet > something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SEO Redirection
I think all of those lcase() and LEFT() calls are unnecessary as well. lists aren't known for their performance but in this case, I'd think this would perform a little better. You would have to compare to see. In either case, I think your use of lcase() is arbitrary. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, February 07, 2012 5:26 PM To: cf-talk Subject: Re: SEO Redirection > > http://#subDomain#.#appdatasource#.com#thePage#";> > You could replace these three lines with a single CFLOCATION tag. I'm not sure if that's what's causing your performance problems, but there's really no reason to do this the way you're doing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfspreadsheet issue when reads dates from spreadsheet
If you are on CF9, you can try using SpreadsheetFormatColumns() to format it like you want. something like this (I think) after your cfsrpeeadsheet tag. Im assuming DOB is the first column. If that isnt the case, change the last attribute to the right column number. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Hong Chen [mailto:ho...@cbmiweb.com] Sent: Tuesday, February 07, 2012 2:42 PM To: cf-talk Subject: cfspreadsheet issue when reads dates from spreadsheet We use to upload Excel spreadsheet into database, but having an issue with reading dates. only reads last 2 digits of the year, e.g. the date in the Excel file is 2/2/1999, the reads it as 2/2/99. Below is my code: The query dumped out like this: query DOB NAME 1 2/2/99 John Anyone can help? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Best Practice question about database access between Dev and Production Servers
Generally, it is pretty bad practice to copy production data to any other network. You would most definitely not pass a SaaS 70 audit if they found that you were doing it. You would also not pass the same audit if they found that all of your developers had direct access to that data without going through permission granting hoops. That said, you may not have a need to worry about it if your data isnt really that sensitive in the first place. In which case, I think domain authentication would be the better way to govern the access. When people leave or contracts expire, the removal of their domain accounts would cover removing the DB access. Otherwise, you may find yourself managing the accounts individually for everything or changing the password every time someone leaves. Another option, which Russ mentioned, is scrubbing the data before copying it down to the dev network. Of course, you'd want to do that on the production network BEFORE copying it down to the other network. I have seen people do the scrubbing AFTER the move... which is kind of pointless. Just some things to think about. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Saturday, January 28, 2012 4:02 PM To: cf-talk Subject: Best Practice question about database access between Dev and Production Servers Hello, I'm setting up a new environment and I would like to have the ability, through a web UI to copy objects from our production database (separate server) to a development/debugging database (separate server). My question is not about how to implement this but rather whether this is bad practice. It would involve exposing the production database on the dev server (via a datasource mapping in the cfadmin). This would mean that any developer that is using our dev server (my concern is contractors..) would be able to write a query against the production database and potentially download sensitive data. How to people handle this type of risk? One idea I had was to not hardcode the database username/password in the CFadmin and instead prompt for it when accessing this specific tool through the web UI. Does that sound like a reasonable means of protecting the data in the production database from developers working on the development server? Anybody have better ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(Job) ColdFusion Programmer
Where can I find some ColdFusion programmers open for a position in Kansas. I have a client who is in need of 5 ColdFusion people for full time positions offering a base salary of $80-105K base + bonus + full benefits. If you or anyone you know may be interested please contact me ASAP! Thank you. Bobby June / BeyondTek IT Tel: 714-572-1544 x 11 / Fax: 714-982-5094 Yahoo IM: bobbybeyondtekit bo...@beyondtekit.com / www.BeyondTekIT.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM Compositie Key Help
Noob mistake. I had this.ormsettings.flushAtRequestEnd set to flase in applicaiton.cfc and was not using ormFlush() after entitySave. I Must have changed it to false to try an example in John W's book or something. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 8:42 PM To: cf-talk Subject: RE: ORM Compositie Key Help So my issue may not be related to composite keys at all... If I use a generator of any type other than native, I get the issue of no records. I created this small example to prove it: The component: states.cfc component persistent="true" table="tblStates" { property name="StateId" ormtype="string" length="33" fieldtype="id" generator="assigned"; property name="stateCode" ormtype="string" length="2"; property name="stateName" ormtype="string" length="30"; } CFM Template to call states component: statesTest.cfm == stateCodes = "AL,HI,FL,NC,NY,NE,KS"; stateNames = "Alabama,Hawaii,Florida,North Carolina,New York,Nevada,Kansas"; for (i=1; i lte listlen(stateCodes); i=i+1) { obj = EntityNew("states"); obj.setStateCode(listgetat(stateCodes, i)); obj.setStateName(listgetat(stateNames, i)); obj.setStateID(obj.getStateCode() & "_" & replace(obj.getStateName(), '[^\w]', '_', 'all')); entitySave(obj); } If I call statesTest.cfm, It will create tblStates as expected, but it will not put anything in it. If I profile the database when I run statesTest.cfm, all queries are selects... no inserts. Now... If I change the stateID property in states.cfc to the following: property name="StateId" fieldtype="id" generator="native"; ...and remove the obj.setStateID() line from statesTest.cfm, it inserts the records fine. Any ideas while I still have hair left? Thanks! .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 3:09 PM To: cf-talk Subject: RE: ORM Compositie Key Help FYI, I did read people saying to set the generator of composite keys to "assigned" (even though I'm pretty sure that is the default) so I did try that but it did not make a difference. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 1:40 PM To: cf-talk Subject: ORM Compositie Key Help Hi All, I'm still playing around with ORM and am finally trying to use it in an actual project but am running into an issue with composite keys. Here is a basic compnent that works. component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" ormtype="string"length="2"; property name="stateName" ormtype="string"length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } I have an excel doc full of records that I read in and loop over. Using the above component, I can use the generated setters to set the values and then use "entitySave()" to write it to the database. The problem comes when I try to make stateCode (which is just the two letter state abbreviation) and stateNamepart of the PK. I change the above to: == component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" fieldtype="id" ormtype="string" length="2"; property name="stateName" fieldtype="id" ormtype="string" length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } == Then I use the same code to loop over the spreadsheet. Ther
RE: ORM Compositie Key Help
So my issue may not be related to composite keys at all... If I use a generator of any type other than native, I get the issue of no records. I created this small example to prove it: The component: states.cfc component persistent="true" table="tblStates" { property name="StateId" ormtype="string" length="33" fieldtype="id" generator="assigned"; property name="stateCode" ormtype="string" length="2"; property name="stateName" ormtype="string" length="30"; } CFM Template to call states component: statesTest.cfm == stateCodes = "AL,HI,FL,NC,NY,NE,KS"; stateNames = "Alabama,Hawaii,Florida,North Carolina,New York,Nevada,Kansas"; for (i=1; i lte listlen(stateCodes); i=i+1) { obj = EntityNew("states"); obj.setStateCode(listgetat(stateCodes, i)); obj.setStateName(listgetat(stateNames, i)); obj.setStateID(obj.getStateCode() & "_" & replace(obj.getStateName(), '[^\w]', '_', 'all')); entitySave(obj); } If I call statesTest.cfm, It will create tblStates as expected, but it will not put anything in it. If I profile the database when I run statesTest.cfm, all queries are selects... no inserts. Now... If I change the stateID property in states.cfc to the following: property name="StateId" fieldtype="id" generator="native"; ...and remove the obj.setStateID() line from statesTest.cfm, it inserts the records fine. Any ideas while I still have hair left? Thanks! .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 3:09 PM To: cf-talk Subject: RE: ORM Compositie Key Help FYI, I did read people saying to set the generator of composite keys to "assigned" (even though I'm pretty sure that is the default) so I did try that but it did not make a difference. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 1:40 PM To: cf-talk Subject: ORM Compositie Key Help Hi All, I'm still playing around with ORM and am finally trying to use it in an actual project but am running into an issue with composite keys. Here is a basic compnent that works. component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" ormtype="string"length="2"; property name="stateName" ormtype="string"length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } I have an excel doc full of records that I read in and loop over. Using the above component, I can use the generated setters to set the values and then use "entitySave()" to write it to the database. The problem comes when I try to make stateCode (which is just the two letter state abbreviation) and stateNamepart of the PK. I change the above to: == component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" fieldtype="id" ormtype="string" length="2"; property name="stateName" fieldtype="id" ormtype="string" length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } == Then I use the same code to loop over the spreadsheet. There is no error but it does not write anything to the database either. When I run profiler (this is SQL Server 2005 by the way), I see the inserts with the first entity but I only see a bunch of selects with the second. I drop the table each time I run it so I know its empty to begin with. Both components create the table as I would expect them to (correct columns, types and constraints). I'm sure I'm doing something wrong obviously but I can't seem to find what that is. Any ideas here? Thanks. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM Compositie Key Help
FYI, I did read people saying to set the generator of composite keys to "assigned" (even though I'm pretty sure that is the default) so I did try that but it did not make a difference. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message----- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Sunday, January 08, 2012 1:40 PM To: cf-talk Subject: ORM Compositie Key Help Hi All, I'm still playing around with ORM and am finally trying to use it in an actual project but am running into an issue with composite keys. Here is a basic compnent that works. component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" ormtype="string"length="2"; property name="stateName" ormtype="string"length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } I have an excel doc full of records that I read in and loop over. Using the above component, I can use the generated setters to set the values and then use "entitySave()" to write it to the database. The problem comes when I try to make stateCode (which is just the two letter state abbreviation) and stateNamepart of the PK. I change the above to: == component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" fieldtype="id" ormtype="string" length="2"; property name="stateName" fieldtype="id" ormtype="string" length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } == Then I use the same code to loop over the spreadsheet. There is no error but it does not write anything to the database either. When I run profiler (this is SQL Server 2005 by the way), I see the inserts with the first entity but I only see a bunch of selects with the second. I drop the table each time I run it so I know its empty to begin with. Both components create the table as I would expect them to (correct columns, types and constraints). I'm sure I'm doing something wrong obviously but I can't seem to find what that is. Any ideas here? Thanks. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ORM Compositie Key Help
Hi All, I'm still playing around with ORM and am finally trying to use it in an actual project but am running into an issue with composite keys. Here is a basic compnent that works. component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" ormtype="string"length="2"; property name="stateName" ormtype="string"length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } I have an excel doc full of records that I read in and loop over. Using the above component, I can use the generated setters to set the values and then use "entitySave()" to write it to the database. The problem comes when I try to make stateCode (which is just the two letter state abbreviation) and stateNamepart of the PK. I change the above to: == component persistent="true" table="tmp_utilities_import" { property name="stateID" fieldtype="id" generator="native"; property name="stateCode" fieldtype="id" ormtype="string" length="2"; property name="stateName" fieldtype="id" ormtype="string" length="30"; property name="RECORDTIMESTAMP" ormtype="timestamp" default=""; any function init() { variables.recordTimeStamp = now(); } } == Then I use the same code to loop over the spreadsheet. There is no error but it does not write anything to the database either. When I run profiler (this is SQL Server 2005 by the way), I see the inserts with the first entity but I only see a bunch of selects with the second. I drop the table each time I run it so I know its empty to begin with. Both components create the table as I would expect them to (correct columns, types and constraints). I'm sure I'm doing something wrong obviously but I can't seem to find what that is. Any ideas here? Thanks. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: StructDelete inside cfc
I'd imagine that it isn't the structDelete line but the CFSET line for recipient_id since the line just above it has an extra quote. Try making that: .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Shannon Rhodes [mailto:shan...@rhodesedge.com] Sent: Friday, January 06, 2012 3:51 PM To: cf-talk Subject: StructDelete inside cfc I'm trying to process dynamic form fields in a function. The first thing I need is to grab a value that I need for saving the data to the right user. If for some reason the value isn't there, I want to halt processing; else I want to remove the value from the structure so I can loop over the rest of the form scope and insert all numeric values. For some reason, it errors at the StructDelete line. This is CF8 if that matters. Error: Invalid CFML construct found on line 144 at column 68. ColdFusion was looking at the following text: recipient_id The CFML compiler was processing: A cfset tag beginning on line 140, column 10. Beginning of function: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: list of running cfthreads
Jconsole as well. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Thursday, December 29, 2011 8:07 PM To: cf-talk Subject: Re: list of running cfthreads Things like SeeFusion and other dashboards doand doesn't CF 9 have something like that bundled in CF Admin?? ...been a while since I was thread hunting ;-) On Thu, 2011-12-29 at 19:47 -0500, Michael Dinowitz wrote: > Is there a way to view the threads created with cfthread. How many are > in the queue, how long they've been waiting, etc. > > Thanks -- Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: fresh cf 9 install can't see administrator
Is /cfide/ in the root of your website? If not, setup a virtual directory to put it there. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mr. Chedder P. Slam [mailto:chedders...@gmail.com] Sent: Tuesday, December 13, 2011 12:14 PM To: cf-talk Subject: fresh cf 9 install can't see administrator http://192.168.1.10/CFIDE/administrator/index.cfm The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request File not found: /CFIDE/administrator/index.cfm apache running on VM to wwwroot in host machine cf service running as local system account, but wwwroot has everyone full access http://192.168.1.10/ serves index.html properly, but index.cfm gives the same error i'm thinking permissions, but not sure how... any help? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL
It really is easier than the docs make it seem... download the right files, flash it, done. I only use the smaller store bough routers for access points or for DMZs at home. My modem always plugs into a linux box of one type or another. I envy the fun you are about to have discovering firewall distros. Enjoy. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Sunday, December 11, 2011 5:09 PM To: cf-talk Subject: Re: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL >>Another option is to throw together a cheap linux box and install a firewall/router distro like ipcop, ipfire, brazilfw.. SWEET. Thanx Bobby! That was just what I was looking for. I would be *much* more inclined to set up a Linux box than start hacking my router. I am sure the DD-WRT/router method would work fine and I would soon be singing it's praises. However, I was looking at the *lengthy* install docs with a bunch of bright red "WARNING" messages scattered about and I was thinking: "Do I really want to get involved with this?" Thanx again, G! On Sun, Dec 11, 2011 at 4:01 PM, Bobby Hartsfield wrote: > > The chances of bricking the router are pretty low. You'd pretty much have > to > lose power in the middle of the actual flash (doesn't mean it has never > happened). I've installed DD-WRT on just about every linksys router I've > had > (including two WRT54GL routers). Currently, I'm running it on a WRT610N. > > Installing DD-WRT is the first thing I do to a new Cisco/Linksys home > router > when I take it out of the box. I think you'll much prefer the control it > gives you over your equipment. > > Another option is to throw together a cheap linux box and install a > firewall/router distro like ipcop, ipfire, brazilfw.. (and many others). > You > could also run a normal distro and use something like firewall builder to > make it a firewall/router. > > The benefit of moving up to a linux distro from DD-WRT is even more control > and the ability to install many different packages (like a proxy server) > > ipfire is an iptables based firewall distro (forked from ipcop and debian > based)... it has a TON of addons all tested and ready to be installed right > from the web interface. > > Add-ons list: http://wiki.ipfire.org/en/addons/start > > these distros are tiny and typically run on anything you have laying > around. > Some of them are small enough to fit on a single floppy disk and run > entirely from RAM. > > So that's my linux firewall spiel. > > Cheers > > .:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > > -Original Message- > From: Gerald Guido [mailto:gerald.gu...@gmail.com] > Sent: Sunday, December 11, 2011 3:07 PM > To: cf-talk > Subject: Re: TOT - Forwarding port 80 to two machines with a home Router -- > Linksys WRT54GL > > > Than you all for your response. I tried reverse proxy ala mod proxy and > that works. Sort of. If the site uses URLs that includes the host name. One > of the apps that I use a lot, Word press, uses the host name in the URL.. > and the whole reverse proxy thing goes down the shi... err drain. That and > Trac throws a fit when I try to authenticate while going through the proxy > > I am aware of the Linux firmware for the router, but I was hoping there was > another way to do this for fear of bricking it. > > Thanx > G! > > On Sun, Dec 11, 2011 at 11:29 AM, Eric Roberts < > ow...@threeravensconsulting.com> wrote: > > > > > Look into the DD-WRT firmware for that router...it basically turns in > into > > a > > linux box as Jochem was talking about... > > > > -Original Message- > > From: Jochem van Dieten [mailto:joch...@gmail.com] > > Sent: Sunday, December 11, 2011 5:26 AM > > To: cf-talk > > Subject: Re: TOT - Forwarding port 80 to two machines with a home Router > -- > > Linksys WRT54GL > > > > > > On Sat, Dec 10, 2011 at 4:06 AM, Gerald Guido wrote: > > > I have two servers @ home that I want to use for hosting hobby sites. > > > One runs Win 08 server and the other Linux (CentOS). My router ( > > > Linksys > > > WRT54GL) does port forwarding but I want to have port 80 point to both > > > machines based on the domain. > > > > Did you upgrade your router to run an open souce Linux or are you running > > the original Linksys firmware? > > > > Jochem > > > > > > -- > > Jochem van Dieten > > http://jochem.vandieten.net/ > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL
The chances of bricking the router are pretty low. You'd pretty much have to lose power in the middle of the actual flash (doesn't mean it has never happened). I've installed DD-WRT on just about every linksys router I've had (including two WRT54GL routers). Currently, I'm running it on a WRT610N. Installing DD-WRT is the first thing I do to a new Cisco/Linksys home router when I take it out of the box. I think you'll much prefer the control it gives you over your equipment. Another option is to throw together a cheap linux box and install a firewall/router distro like ipcop, ipfire, brazilfw.. (and many others). You could also run a normal distro and use something like firewall builder to make it a firewall/router. The benefit of moving up to a linux distro from DD-WRT is even more control and the ability to install many different packages (like a proxy server) ipfire is an iptables based firewall distro (forked from ipcop and debian based)... it has a TON of addons all tested and ready to be installed right from the web interface. Add-ons list: http://wiki.ipfire.org/en/addons/start these distros are tiny and typically run on anything you have laying around. Some of them are small enough to fit on a single floppy disk and run entirely from RAM. So that's my linux firewall spiel. Cheers .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Sunday, December 11, 2011 3:07 PM To: cf-talk Subject: Re: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL Than you all for your response. I tried reverse proxy ala mod proxy and that works. Sort of. If the site uses URLs that includes the host name. One of the apps that I use a lot, Word press, uses the host name in the URL.. and the whole reverse proxy thing goes down the shi... err drain. That and Trac throws a fit when I try to authenticate while going through the proxy I am aware of the Linux firmware for the router, but I was hoping there was another way to do this for fear of bricking it. Thanx G! On Sun, Dec 11, 2011 at 11:29 AM, Eric Roberts < ow...@threeravensconsulting.com> wrote: > > Look into the DD-WRT firmware for that router...it basically turns in into > a > linux box as Jochem was talking about... > > -Original Message- > From: Jochem van Dieten [mailto:joch...@gmail.com] > Sent: Sunday, December 11, 2011 5:26 AM > To: cf-talk > Subject: Re: TOT - Forwarding port 80 to two machines with a home Router -- > Linksys WRT54GL > > > On Sat, Dec 10, 2011 at 4:06 AM, Gerald Guido wrote: > > I have two servers @ home that I want to use for hosting hobby sites. > > One runs Win 08 server and the other Linux (CentOS). My router ( > > Linksys > > WRT54GL) does port forwarding but I want to have port 80 point to both > > machines based on the domain. > > Did you upgrade your router to run an open souce Linux or are you running > the original Linksys firmware? > > Jochem > > > -- > Jochem van Dieten > http://jochem.vandieten.net/ > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is CFMAIL reliable??
I can only say I've not ran into any issues with the spool needing to be kick started and we send ridiculous amounts of email all day from about 20 different CF 8.01 enterprise servers... all via cfmail. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Monday, December 05, 2011 9:06 PM To: cf-talk Subject: Is CFMAIL reliable?? Hi Guys (and girls), You may notice a trend in my postings! Moving away from infusion (long over due) and looking at Native CF functions instead. So now I am looking at CFMAIL and in the past know it has been a bit dodgy. There is a conversation here about restarting the spooling service: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg342750.html And Ben Nadel talks about monitoring the undeliverable folder and how the spooler just occasionally stops working. http://www.bennadel.com/blog/1893-Monitoring-The-ColdFusion-Mail-Server-With -GMail-And-A-Scheduled-Task.htm The comments attest to this being an issue for a lot of people. So I guess the question is, has this been resolved or is it necessary to implement all of these hacks to keep CFMAIL running well? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM/Hibernate generator issue
Thanks Matt. I swear I did try that earlier but I just tried it again to make sure I didn't typo it or something earlier and it got past the error. Today has been one long caching nightmare. Thanks! .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Saturday, December 03, 2011 10:15 PM To: cf-talk Subject: Re: ORM/Hibernate generator issue Try setting generator="native" instead. On Dec 3, 2011 9:10 PM, "Bobby Hartsfield" wrote: > > I've finally been playing around with ORM lately and I've hit an issue that > I'm having a hard time finding answers for on Google. Hopefully someone > here > knows what the deal. > > > > Below is a very basic "person" app with one component (outside of app.cfc) > and a small index.cfm > > > > The error I'm seeing is: > > this id generator generates long, integer, short > > Root cause :org.hibernate.id.IdentifierGenerationException: this id > generator generates long, integer, short > > > > Basically, I read a xls doc of first and last names and (attempt to) load > it > into a tblPeople table. > > > > The above error happens in inde.cfm when entitySave(obj) is triggered. I > can > comment out " entitySave(obj);" and not get any errors. > > > > There are only about 3000 records in people.xls and tblPeople doesn't exist > yet. > > > > It is a new, basic install of CF9 on server 2003. > > > > This worked earlier but I was using the old style tags in > person.cfc > > > > hopefully I'm just missing something obvious to someone else. > > > > Any help appreciated here. > > > > Thanks > > > > ---INDEX.CFM > > > > > > query="sheet" headerrow="1" /> > > > > > > > >obj = EntityNew("person"); > > > >obj.setPersonFname(sheet["personFname"][sheet.currentRow]); > >obj.setPersonLname(sheet["personLname"][sheet.currentRow]); > > > >entitySave(obj); > > > > > > > > > > > > > > ---PERSON.CFC > > component persistent="true" table="tblpeople" > > { > >property name="personId" fieldtype="id" > generator="increment"; > >property name="personFname"; > >property name="personLname"; > > } > > > > > > > > > > > > > > ---APPLICATION.CFC > > component > > { > >this.name = "personTest"; > > > >this.ormenabled = "true"; > >this.datasource = "peopleTest"; > >this.ormsettings={dbcreate="update", logsql="true"}; > >this.ormsettings.savemapping = false; > > > >this.clientmanagement="false"; > >this.sessionmanagement="true"; > >this.sessiontimeout="#createtimespan(0,0,1,0)#"; > >this.applicationtimeout="#createtimespan(0,0,1,0)#"; > > } > > > > > > .:.:.:.:.:.:.:.:.:.:.:. > > Bobby Hartsfield > > http://acoderslife.com > > http://cf4em.com > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ORM/Hibernate generator issue
I've finally been playing around with ORM lately and I've hit an issue that I'm having a hard time finding answers for on Google. Hopefully someone here knows what the deal. Below is a very basic "person" app with one component (outside of app.cfc) and a small index.cfm The error I'm seeing is: this id generator generates long, integer, short Root cause :org.hibernate.id.IdentifierGenerationException: this id generator generates long, integer, short Basically, I read a xls doc of first and last names and (attempt to) load it into a tblPeople table. The above error happens in inde.cfm when entitySave(obj) is triggered. I can comment out " entitySave(obj);" and not get any errors. There are only about 3000 records in people.xls and tblPeople doesn't exist yet. It is a new, basic install of CF9 on server 2003. This worked earlier but I was using the old style tags in person.cfc hopefully I'm just missing something obvious to someone else. Any help appreciated here. Thanks ---INDEX.CFM obj = EntityNew("person"); obj.setPersonFname(sheet["personFname"][sheet.currentRow]); obj.setPersonLname(sheet["personLname"][sheet.currentRow]); entitySave(obj); ---PERSON.CFC component persistent="true" table="tblpeople" { property name="personId" fieldtype="id" generator="increment"; property name="personFname"; property name="personLname"; } ---APPLICATION.CFC component { this.name = "personTest"; this.ormenabled = "true"; this.datasource = "peopleTest"; this.ormsettings={dbcreate="update", logsql="true"}; this.ormsettings.savemapping = false; this.clientmanagement="false"; this.sessionmanagement="true"; this.sessiontimeout="#createtimespan(0,0,1,0)#"; this.applicationtimeout="#createtimespan(0,0,1,0)#"; } .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Printing barcodes
Thanks for pointing out your own solution. I hope to play around with barcodes soon. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Keith McGee [mailto:kpmc...@frontiernet.net] Sent: Friday, November 11, 2011 2:15 PM To: cf-talk Subject: Re: Printing barcodes Found the solution http://kb2.adobe.com/cps/405/kb405588.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HouseOfFusion is down (was: CF8 cftextarea richtext is stealing form focus, and being referred to by the form
> Yes, but luckily the mailing list is handled by a different server > so anyone using regular email is still able to send/reply to the list. AKA... all the REAL users. :-p .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Wednesday, November 02, 2011 2:38 PM To: cf-talk Subject: HouseOfFusion is down (was: CF8 cftextarea richtext is stealing form focus, and being referred to by the form On Wed, Nov 2, 2011 at 11:21 AM, Monique Boea wrote: > is houseoffusion.com down? Yes, but luckily the mailing list is handled by a different server so anyone using regular email is still able to send/reply to the list. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ World Singles, LLC. -- http://worldsingles.com/ "Perfection is the enemy of the good." -- Gustave Flaubert, French realist novelist (1821-1880) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Shouldn't these statements work?
Now I owe Dave $1. He bet me that he could get you to admit "truthiness" was a word... crap! .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, October 13, 2011 6:59 PM To: cf-talk Subject: Re: Shouldn't these statements work? I can only imagine what a game of scrabble must be like at your house. In the interest of moving forward and freeing up my spare time I'll concede to you that truthiness is a word. (Even though the red squiggle under the word right now seems to be mocking me.) We'll have to agree to disagree as to whether or not using it in a presentation would make you look a fool. MG ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Shouldn't these statements work?
Say goodbye to your thread Rick. :-/ .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
The onclick sounds pretty cool. I never thought to do it like that. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Claude Schnéegans [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans >The bot doesn't realize the field is hidden and puts something in it. Check the field when the form is submitted for the presence of a value in the field. OK, I see. But there is no guaranty the bot will fill the field. I prefer the reverse : add a field in a onclick event and check for the presence of the field. This is 100% sure. I've also read about the Honey Pot project. IMO, its weakness is that it mostly rely on list of IP addresses. This is not sure enough, mainly because 1º IP addreses may be spoofed 2º many bots are actually ordinary user browsers hosting some worms therefore they can attack from any legitimate IP adresses. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
I've been doing that one for years (and offered it as potential solution here a few times). Hiding it by CSS or JS is the key. Typically, I put the normal text field and some text next to it like "dont fill in this field" in a single div then use CSS and/or JS to hide it from real people. It has worked well for me in the past. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Thursday, October 13, 2011 8:58 AM To: cf-talk Subject: RE: Hiding email address from spiders I can't find a reference on www.meetup.com/coldfusionmeetup to the archived presentation, but the basic idea is this: Add a hidden form field that a user can't see, and therefore, won't fill in, and use it to trap a bot/spider. The bot doesn't realize the field is hidden and puts something in it. Check the field when the form is submitted for the presence of a value in the field. If there's a value in the hidden field, don't process the form. I love the idea and hope it works well. I'm going to implement it and see how it goes. Anyone have any experience with this highly efficient, user-friendly method? -Original Message- From: Claude Schnéegans [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans >How about the "honeypot" method that was presented on CFMeetup a few months ago? Never heard of it. Any reference ? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
You're welcome. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, October 08, 2011 2:41 PM To: cf-talk Subject: RE: Hiding email address from spiders What a strange assumption to make. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ >>-Original Message- >>From: Michael Grant [mailto:mgr...@modus.bz] >>Sent: 08 October 2011 15:15 >>To: cf-talk >>Subject: Re: Hiding email address from spiders >> >> >> >>> >>> In all honesty though, if someone submits some text to their >>own site that >>> they know is going to be displayed and it has email addresses >>in it, they >>> probably don't care much about the subject. >>> >> >>Too right. >> >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: MXUnit - Fail a success
Yeah, A couple of us were quite sure what I had should work and were surprised when it didn't. Your example looks like a winner to get the test working like it needs to though! .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Saturday, October 08, 2011 10:54 AM To: cf-talk Subject: Re: MXUnit - Fail a success While I'm not sure why the test is not failing, I've done this before with: var failed = false; try { doSomething(); } catch( someError e ) { failed = true; } Assert(failed); Your method is more elegant I think, would be interesting to see why it isn't working. Dominic On 8 October 2011 00:27, Bobby Hartsfield wrote: > > Thanks Matt. I did see that list but figured people here were likely users > of MXUnit and gave it a shot. > > I'll resort to the google group if all else fails. > > Thanks again. > > .:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > > > > -Original Message- > From: Matt Quackenbush [mailto:quackfu...@gmail.com] > Sent: Friday, October 07, 2011 3:20 PM > To: cf-talk > Subject: Re: MXUnit - Fail a success > > > I'm not certain the answer to your question, but wanted to make sure you > know about the MXUnit list. I suspect you might have better luck getting an > answer over there. > > http://groups.google.com/group/mxunit > > (I would have also expected the test to fail, based upon what you've > posted.) > > > On Fri, Oct 7, 2011 at 2:13 PM, Bobby Hartsfield > wrote: > >> >> Sounds like an odd request right? lol >> >> So I have a method that I have written some unit tests for. What I want to >> add is a test that tests missing arguments. There are two arguments in my >> method and both are required so I wanted a test for passing no arguments. >> >> This is what I tried: >> >> >> >> try >> >> { >> >> local.result = >> instance.myService.meyMethod(); >> >> fail(); >> >> } >> >> catch(Application e) { } >> >> >> >> >> >> The above test passed. I THOUGHT the fail() was going to ensure that if >> anyone came along and made the arguments not required that the test would >> fail but the catch appears to be catching that as well... >> >> For instance, I tried this. >> >> >> >> >> >> try >> >> { >> >> local.result = 1; >> >> fail(); >> >> } >> >> catch(Application e) { } >> >> >> >> >> >> That test still passes... >> >> >> >> What I also thought was odd was that the exception type thrown by calling >> my >> method with no arguments was not the missingArgument type, it was >> application. I'm assuming that application type is simply catching > whatever >> fail () is doing as well as my missing argument error and there for > hitting >> the catch. >> >> >> >> Does anyone know a solution to make this work as expected? >> >> >> >> I am on CF 8.0.1 by the way and running mxUnit 2.0.3 >> >> >> >> Thanks. >> >> >> >> >> >> .:.:.:.:.:.:.:.:.:.:.:.:. >> >> Bobby Hartsfield >> >> http://acoderslife.com >> >> http://cf4em.com >> >> >> >> >> >> >> >> >> >> >> >> >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
In which case ascii encoding would make them feel better about themselves because they don't know any better. ;-) .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Claude Schnéegans [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans > if someone submits some text to their own site that they know is going to be displayed and it has email addresses in it, they probably don't care much about the subject. May be they do care, but they just don't know how to hide their address. And there are also all those who do care and do not put addresses because they cannot hide them. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
Yep. Definitely not 100% (nor are images .. especially if you want them linked). I'd imagine most bots aren't going to bother with either though. I'd have to agree that non-linked images of the email text is less likely to be deciphered by a bot than ascii equivalents. No doubt. In all honesty though, if someone submits some text to their own site that they know is going to be displayed and it has email addresses in it, they probably don't care much about the subject. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Saturday, October 08, 2011 8:34 AM To: cf-talk Subject: Re: Hiding email address from spiders This may be academic, but be aware that this method isn't actually hiding the address, simply ascii encoding it. It wouldn't surprise me in the least if spider don't already evaluate ascii. I stand by my statement that the most effective (though not elegant) is to replace addy's with images. The likelihood of a spider also doing character recognition is much less Carry on. On Sat, Oct 8, 2011 at 5:39 AM, Jenny Gavin-Wear < jenn...@fasttrackonline.co.uk> wrote: > > Thanks, Bobby, exactly along the lines I am thinking. > > The mail address for me has no mailto:, it's just contained in a string. > I'm wondering if I'll have to check the whole string for the existance of > an > email address by looping through each "word", or if there is an > easier/faster way? > > For example, this code would find the string. However, I don't know if I > can use a regular expression, for example, to rereplace the string with > ascii? (Never used regex before...) > > Or could I use a regular expression to search AND replace the email address > with ascii on the whole string, which would be a lot faster? > > > > > > > > #listgetat(mystring, I, " ")# > > > > > #mynewString# > > > > Jenny Gavin-Wear > Fast Track Online > Tel: 01262 602013 > http://www.fasttrackonline.co.uk/ > > > >>-Original Message- > >>From: Bobby Hartsfield [mailto:bo...@acoderslife.com] > >>Sent: 08 October 2011 04:09 > >>To: cf-talk > >>Subject: RE: Hiding email address from spiders > >> > >> > >> > >>Here is a page with an example of the source: > >> > >>http://cf4em.com/cf4em/index.cfm?mainaction=posts&forumid=2&threadid=63 > >> > >>The last post has my email address in the last sentence. This is what the > >>source of that mailto link looks like: > >> > >> >>href="mailto:bobby@& > >>#99f&# > >>52em.com">bobby@c > >>24e > >>m.com > >> > >> > >>.:.:.:.:.:.:.:.:.:.:.:.:. > >>Bobby Hartsfield > >>http://acoderslife.com > >>http://cf4em.com > >> > >> > > > -- > I am using the free version of SPAMfighter. > We are a community of 7 million users fighting spam. > SPAMfighter has removed 4302 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hiding email address from spiders
Here is a quick mod of the original. Just pass in the entire text block and it takes care of the rest. What it is doing is using rematch() to return an array of all email addresses that it finds in the given string. It then loops over that array of email addresses, replacing all occurrences in the given string, with the ascii encoded equivalent (the inner loop is what I sent last time). function disguiseEmails(str){ var emailArr = rematch("([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+(museum|travel|[[:alpha:]] {2,4}))", str); var thisEmailAddr = ""; var i = 1; var ii = 1; for (i=1; i <= arraylen(emailArr); i++) { for (ii=1; ii <= len(emailArr[i]); ii++) { thisEmailAddr = thisEmailAddr & "&##" & asc(mid(emailArr[i], ii, 1)); } str = replace(str, emailArr[i], thisEmailAddr, 'all'); } return str; } .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, October 08, 2011 5:40 AM To: cf-talk Subject: RE: Hiding email address from spiders Thanks, Bobby, exactly along the lines I am thinking. The mail address for me has no mailto:, it's just contained in a string. I'm wondering if I'll have to check the whole string for the existance of an email address by looping through each "word", or if there is an easier/faster way? For example, this code would find the string. However, I don't know if I can use a regular expression, for example, to rereplace the string with ascii? (Never used regex before...) Or could I use a regular expression to search AND replace the email address with ascii on the whole string, which would be a lot faster? #listgetat(mystring, I, " ")# #mynewString# Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ >>-Original Message- >>From: Bobby Hartsfield [mailto:bo...@acoderslife.com] >>Sent: 08 October 2011 04:09 >>To: cf-talk >>Subject: RE: Hiding email address from spiders >> >> >> >>Here is a page with an example of the source: >> >>http://cf4em.com/cf4em/index.cfm?mainaction=posts&forumid=2&threadid=63 >> >>The last post has my email address in the last sentence. This is what the >>source of that mailto link looks like: >> >>>href="mailto:bobby@& >>#99f&# >>52em.com">bobby@c >>24e >>m.com >> >> >>.:.:.:.:.:.:.:.:.:.:.:.:. >>Bobby Hartsfield >>http://acoderslife.com >>http://cf4em.com >> >> -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 4302 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm