Re: Country/City/Province List for DB import
Thanks Richard. On Wed, Apr 30, 2008 at 12:52 PM, Richard Dillman [EMAIL PROTECTED] wrote: theirs an sql script at http://forums.asp.net/t/1045550.aspx appears to have all countries and provinces/states for Canada, US, and UK On 4/30/08, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question has already been asked and I unfortunately I lost my bookmarks and now I am here asking it again. What's that website with the list of country/cities to import to the database? Someone had passed through a FREE site with a complete list of countries/cities with link to download it. I had used that to add it to one of my databases. Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Business Venture
I am interested in starting my own business once again doing hosting but the main goal here is to have a server in which we have total access and own it. Also, the goal is to focus on web development rather than hosting. The person(s) interested in the venture should be able to come up with money as well. The server cost, the monthly cost and also a license for ColdFusion. We could stick with Linux for the time being using Webmin as the web panel. Is anyone interested in the venture? You can email me at [EMAIL PROTECTED] Ravi -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Business Venture
Sorry...you are right. My bad! Ravi. On Thu, May 1, 2008 at 11:01 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Wow is this the wrong place to post that message!! - 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: [EMAIL PROTECTED] 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. On Thu, 2008-05-01 at 10:53 -0400, [STS] Ravi Gehlot wrote: I am interested in starting my own business once again doing hosting but the main goal here is to have a server in which we have total access and own it. Also, the goal is to focus on web development rather than hosting. The person(s) interested in the venture should be able to come up with money as well. The server cost, the monthly cost and also a license for ColdFusion. We could stick with Linux for the time being using Webmin as the web panel. Is anyone interested in the venture? You can email me at [EMAIL PROTECTED] Ravi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Country/City/Province List for DB import
I know this question has already been asked and I unfortunately I lost my bookmarks and now I am here asking it again. What's that website with the list of country/cities to import to the database? Someone had passed through a FREE site with a complete list of countries/cities with link to download it. I had used that to add it to one of my databases. Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: getex replace
Thanks Bobby! Ravi. On Fri, Apr 18, 2008 at 9:31 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: #replace(str, '#char(13)##chr(10)#memberUserName', '|memberUserName', 'all')# -Or- #replace(str, '#char(13)##chr(10)##char(13)##chr(10)#', '|', 'all')# With 18,000 blocks... you are bound to run into some data discrepancies so look it over well. And for the love of god... if you are feeding that list back to CF... use an array of structures or something instead of a list :-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Thursday, April 17, 2008 8:22 PM To: CF-Talk Subject: getex replace I have a list I obtained from export ldap members out of a ldap directory in LDIF format that looks like this: memberUserName: John Doe memberAge: 34 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Mary Doe memberAge: 44 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Jack Doe memberAge: 86 memberLocation: US memberEmail: [EMAIL PROTECTED] I need to import this list of almost 18,000 members onto an SQL database. So what I want to do is to convert this LDIF file into one big list pipe delimited, then loop through it and add it to the database. So I got: 1) File is read cffile action=read variable=cffileRead file=#expandPath(/imports/testList.ldif)# / 2) Replace all new lines for commas cfset newLine = chr(13) chr(10) / cfset commaList = replace(cffileRead, newLine, ',', 'All' / Question here: How do I replace all EMPTY (BLANK LINES) like the ones between memberUserName for pipes? Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getex replace
I have a list I obtained from export ldap members out of a ldap directory in LDIF format that looks like this: memberUserName: John Doe memberAge: 34 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Mary Doe memberAge: 44 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Jack Doe memberAge: 86 memberLocation: US memberEmail: [EMAIL PROTECTED] I need to import this list of almost 18,000 members onto an SQL database. So what I want to do is to convert this LDIF file into one big list pipe delimited, then loop through it and add it to the database. So I got: 1) File is read cffile action=read variable=cffileRead file=#expandPath(/imports/testList.ldif)# / 2) Replace all new lines for commas cfset newLine = chr(13) chr(10) / cfset commaList = replace(cffileRead, newLine, ',', 'All' / Question here: How do I replace all EMPTY (BLANK LINES) like the ones between memberUserName for pipes? Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhttp stopped working, anyone experienced this
Cool. On Thu, Apr 17, 2008 at 5:39 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Trapping it just showed me it was a connection timeout. Oddly (or not) a reboot seems to have fixed this. -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 8:05 PM To: CF-Talk Subject: Re: cfhttp stopped working, anyone experienced this are you happy with the URL being used, if it is being generated dynamically it may be malformed or incorrect. Is it in a cf try? Also, try dumping CFHTTP after the call - it will have a status code and other info that my help On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Yes on the browse, yes on the ping, I have an inquiry in on the firewall settings. -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 3:18 AM To: CF-Talk Subject: Re: cfhttp stopped working, anyone experienced this if you log onto the server, can you browse to the URL? Can you ping the domain? Have firewall settings changed? On Wed, Apr 16, 2008 at 7:05 AM, Scott Mulholland [EMAIL PROTECTED] wrote: I have a piece of code that has always worked that does a cfhttp to create a static file. The file it calls is on the same server/domain. Today the cfhttp just keeps timing out. cfhttp calls to other urls not on the server work without issue though. Anyone else experience anything like this? Thanks, Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhttp stopped working, anyone experienced this
Try using cfsetting timeout=3600 Ravi. On Wed, Apr 16, 2008 at 9:26 PM, Cutter (CFRelated) [EMAIL PROTECTED] wrote: If you can browse and ping then I doubt your firewall is at fault, unless your calling in a file whose MIME type isn't registered with the firewall. CFHTTP uses port 80 by default. If you can browse it from the server then the port isn't the issue (or the MIME type for that matter). Definitely use a try/catch. Or better, if on CF8, use the step debugger (if not in production and that's an option). Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com AJ Mercer wrote: are you happy with the URL being used, if it is being generated dynamically it may be malformed or incorrect. Is it in a cf try? Also, try dumping CFHTTP after the call - it will have a status code and other info that my help On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Yes on the browse, yes on the ping, I have an inquiry in on the firewall settings. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using tags with CFSCRIPT
I found a way to cheat HostMySite's 1 domain per account set up. What this does is it checks the URL for the domain typed and it redirects it to a directory specific for that domain. That way I am able to host all my sites with the CF+ Builder package. My question is...I was about to achieve this with cfswitchcfcase but when I switched it over to a cfscript block I started getting errors. Can anyone tell me where I made a mistake? Before anyone asks...yes...I am sticking with CFSCRIPT. CODE: cfoutput cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'www.sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'www.sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolutions.com/'); break; case 'sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolutions.com/'); break; case 'www.ravigehlot.com':cflocation(theURL:'ravigehlot.com/'); break; case 'ravigehlot.com':cflocation(theURL:'ravigehlot.com/'); break; case 'www.ravigehlot.net':cflocation(theURL:'ravigehlot.net/'); break; case 'ravigehlot.net':cflocation(theURL:'ravigehlot.net/'); break; case 'www.lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'www.falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'www.amadosgest.com':cflocation(theURL:'amadosgest.com'); break; case 'amadosgest.com':cflocation(theURL:'amadosgest.com'); break; default:cflocation(theURL:'76.12.205.99'); } /cfscript /cfoutput Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. On Mon, Apr 14, 2008 at 9:09 AM, Scott Stewart [EMAIL PROTECTED] wrote: Ravi, I know you don't have to surround CFScript tags with CFOutput tags. What errors are you getting. I've used a similar script with HMS hosting. Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 8:57 AM To: CF-Talk Subject: Using tags with CFSCRIPT I found a way to cheat HostMySite's 1 domain per account set up. What this does is it checks the URL for the domain typed and it redirects it to a directory specific for that domain. That way I am able to host all my sites with the CF+ Builder package. My question is...I was about to achieve this with cfswitchcfcase but when I switched it over to a cfscript block I started getting errors. Can anyone tell me where I made a mistake? Before anyone asks...yes...I am sticking with CFSCRIPT. CODE: cfoutput cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'www.sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com /'); break; case 'sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'www.sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologyS olutions.com/' http://olutions.com/%27); break; case 'sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolut ions.com/' http://ions.com/%27); break; case 'www.ravigehlot.com':cflocation(theURL:'ravigehlot.com/'http://ravigehlot.com/%27); break; case 'ravigehlot.com':cflocation(theURL:'ravigehlot.com/'http://ravigehlot.com/%27); break; case 'www.ravigehlot.net':cflocation(theURL:'ravigehlot.net/'http://ravigehlot.net/%27); break; case 'ravigehlot.net':cflocation(theURL:'ravigehlot.net/'http://ravigehlot.net/%27); break; case 'www.lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'www.falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'www.amadosgest.com':cflocation(theURL:'amadosgest.com'); break; case 'amadosgest.com':cflocation(theURL:'amadosgest.com'); break; default:cflocation(theURL:'76.12.205.99'); } /cfscript /cfoutput Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Variable CFLOCATION is undefined. The error occurred in C:\Websites\156945dm2\index.cfm: line 4 2 : cfscript 3 : switch(cgi.http_host) { 4 : case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; 5 : 6 : } On Mon, Apr 14, 2008 at 9:13 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Scott, The getPageContext() is more a java function. I didn't want to go that far in. It should work with cflocation though. Ravi. On Mon, Apr 14, 2008 at 9:39 AM, Scott Stewart [EMAIL PROTECTED] wrote: Ravi, I did a quick google search and came up with this getPageContext().forward(/path/page.cfm); or GetPageContext().getResponse().sendRedirect('PageName.cfm') -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 9:29 AM To: CF-Talk Subject: Re: Using tags with CFSCRIPT Variable CFLOCATION is undefined. The error occurred in C:\Websites\156945dm2\index.cfm: line 4 2 : cfscript 3 : switch(cgi.http_host) { 4 : case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; 5 : 6 : } On Mon, Apr 14, 2008 at 9:13 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Hi Dominic, Thank you for clarifying this whole thing. I had done a couple of searches on Google and I didn't read anything about creating an UDF. Obviously creating an UDF for this matter is not necessary when you can use cfswitch and cfcase but for the sake of learning lets say I were to create these UDFs; Where would I place these UDFs so that whenever I needed them I could just call the function? Ravi. On Mon, Apr 14, 2008 at 9:42 AM, Dominic Watson [EMAIL PROTECTED] wrote: Yes, this is the problem: cflocation(theURL:'brightWebWorks.com/') cflocation is a tag, not a function. To do the cflocation from within a cfscript block you will need to create a UDF. I.e. cffunction name=scriptLocation cfargument name=location cfargument name=addToken required=false default=false cflocation url=#arguments.location# addtoken=#arguments.addtoken# /cffunction Then, in your script block: switch(cgi.http_host) { case 'www.brightWebWorks.com': scriptLocation('brightWebWorks.com/'); break; } HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Gotcha, would it be better to put these UDFs in CFCs and then instantiate them on Application.CFC? Ravi. On Mon, Apr 14, 2008 at 10:22 AM, Dominic Watson [EMAIL PROTECTED] wrote: Where would I place these UDFs so that whenever I needed them I could just call the function? Yeh, I often use UDFs for this kind of thing where I want to use cfscript but there is the odd tag I need to use but I doubt you'd ever get a google result for this kind of thing. For UDFs, I usually create a folder in my project called '_udfs' and have a single cfm file for each udf. Then, in the page that needs to use the udf, just include the file. So: cfinclude template=/_udfs/scriptLocation.cfm cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com http://www.brightwebworks.com/': scriptLocation('brightWebWorks.com/'); break; } /cfscript Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Thanks. This issue is now resolved. Ravi. On Mon, Apr 14, 2008 at 10:35 AM, Dominic Watson [EMAIL PROTECTED] wrote: Gotcha, would it be better to put these UDFs in CFCs and then instantiate them on Application.CFC? I don't think so because then you would have to call them with: myUDFsObject.udfName() As opposed to just: udfName() You could just include all your udfs in application.cfc in OnRequestStart() using a regular cfinclude. Putting the functions in a cfc is perfectly valid though and will work (I just don't like to use cfcs in this way). Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Hi Raymond, I am just being cheap. But the workaround with cfswitch/case works for now with HMS and it lets me have multiple domains in a shared hosting account. I don't have any hard feelings towards HMS; They have been good to me. But I would imagine that the cheat would only work with IIS validating hostnames. In my case, it doesn't validade letting me use different domains. Weird. Any insights? Ravi. On Mon, Apr 14, 2008 at 12:59 PM, Scott Stewart [EMAIL PROTECTED] wrote: Use cfscript Instead of Three or More cfsets The reason is this: When you use cfscript, the entire block gets sent to the engine at once. So, ColdFusion has to make only one read. When you send three or more cfset statements, ColdFusion gets to interpret them once each, or three times. Therefore, it's faster and cleaner. From: http://www.informit.com/articles/article.aspx?p=24131seqNum=3 Always use cfscript for blocks of variable assignments for values greater than one. It is significantly faster than cfset. Example: cfscript a=1; b=2; c=3; /cfscript Not: cfset a=1 cfset b=2 cfset c=3 http://www.adobe.com/devnet/server_archive/articles/coding_for_performance.h tmlhttp://www.adobe.com/devnet/server_archive/articles/coding_for_performance.html pre-MX6.1 there was a performance gain. Now, if I understand correctly, it all compiles down to the same java bytecode, so there's no performance gain to speak of. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43908 While it may not be true for CFMX 7 8 it was a documented best practice for CF 5 and back. I've continued to use this method, especially when declaring multiple variables. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 12:11 PM To: CF-Talk Subject: RE: Using tags with CFSCRIPT Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. I strongly doubt this, and have seen no evidence (load tests) that it's true now, even if it may have been true in the past (which I also doubt). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Hey Scott, I spoke to a couple of my senior developer friends and they told me that back in the days of CF5 cfscript was faster than tags but that doesn't hold true with CF7 and 8 so it doesn't really matter. I prefer to code in cfscript/cfscript blocks when I do imports...just my way of doing things. Ravi. On Mon, Apr 14, 2008 at 12:59 PM, Scott Stewart [EMAIL PROTECTED] wrote: Use cfscript Instead of Three or More cfsets The reason is this: When you use cfscript, the entire block gets sent to the engine at once. So, ColdFusion has to make only one read. When you send three or more cfset statements, ColdFusion gets to interpret them once each, or three times. Therefore, it's faster and cleaner. From: http://www.informit.com/articles/article.aspx?p=24131seqNum=3 Always use cfscript for blocks of variable assignments for values greater than one. It is significantly faster than cfset. Example: cfscript a=1; b=2; c=3; /cfscript Not: cfset a=1 cfset b=2 cfset c=3 http://www.adobe.com/devnet/server_archive/articles/coding_for_performance.h tmlhttp://www.adobe.com/devnet/server_archive/articles/coding_for_performance.html pre-MX6.1 there was a performance gain. Now, if I understand correctly, it all compiles down to the same java bytecode, so there's no performance gain to speak of. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43908 While it may not be true for CFMX 7 8 it was a documented best practice for CF 5 and back. I've continued to use this method, especially when declaring multiple variables. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 12:11 PM To: CF-Talk Subject: RE: Using tags with CFSCRIPT Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. I strongly doubt this, and have seen no evidence (load tests) that it's true now, even if it may have been true in the past (which I also doubt). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:30 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this query?
Rick, You can use FROM and immediately use ON. That's why you have a syntax error. ON is used with joins. Ravi. On Sun, Apr 13, 2008 at 7:23 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the reply, Azadi. However, your solution has the same problem I encountered with a regular JOIN statement: the limit 1 part of the interior select statement limited my results to only 1 property with 1 photo, instead of all properties, but only 1 photo each. I tried: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price from smlc_acr sa inner join select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap on sa.mls_number = sap.photo_mls_number order by list_price but that gives me this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap ' at line 4 I can't see the error in my syntax. But then, again, I'm not the most experienced join writer, having avoided them when I could. Thanks, again. Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 1:45 AM To: CF-Talk Subject: Re: How to write this query? something like the following (note: mysql syntax): SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price, SAP_SQ.photo_filename FROM smlc_acr sa INNER JOIN (SELECT photo_filename, photo_mls_number FROM smlc_acr_photos sap WHERE photo_filename '' LIMIT 1) SAP_SQ ON sa.mls_number = SAP_SQ.photo_mls_number ORDER BY sa.list_price Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this query?
I meant to say can not Ravi. On Sun, Apr 13, 2008 at 7:30 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Rick, You can use FROM and immediately use ON. That's why you have a syntax error. ON is used with joins. Ravi. On Sun, Apr 13, 2008 at 7:23 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the reply, Azadi. However, your solution has the same problem I encountered with a regular JOIN statement: the limit 1 part of the interior select statement limited my results to only 1 property with 1 photo, instead of all properties, but only 1 photo each. I tried: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price from smlc_acr sa inner join select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap on sa.mls_number = sap.photo_mls_number order by list_price but that gives me this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap ' at line 4 I can't see the error in my syntax. But then, again, I'm not the most experienced join writer, having avoided them when I could. Thanks, again. Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 1:45 AM To: CF-Talk Subject: Re: How to write this query? something like the following (note: mysql syntax): SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price, SAP_SQ.photo_filename FROM smlc_acr sa INNER JOIN (SELECT photo_filename, photo_mls_number FROM smlc_acr_photos sap WHERE photo_filename '' LIMIT 1) SAP_SQ ON sa.mls_number = SAP_SQ.photo_mls_number ORDER BY sa.list_price Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird issue in browser with cf8 and long execution times
It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLDAP question
Hey Nate, Thanks for your interest in trying to solve this problem. How do I ping the LDAP with Coldfusion? LDAP Browser and LDAP Administrator can access the LDAP Directory without a problem. Ravi. On Thu, Mar 27, 2008 at 9:59 AM, Nathan Smith [EMAIL PROTECTED] wrote: Can the ColdFusion Server ping the LDAP server/directory machine? Can you access the LDAP information from another machine on the network or the CF server through other tools such as the softerra LDAP browser? -Nate -Original Message- From: Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2008 12:11 PM To: CF-Talk Subject: CFLDAP question I want to express my frustration here by telling all of you that read this post that I have tried this for 3 days without any success. I have an LDAP Directory which is in a remote computer that I have remove desktop access to. This LDAP Directory is in a Windows 2000 operating system that does NOT use domain controllers OR Active Directory. The only information I have is that the LDAP Directory can be accessed by using the Windows 2000 Console Root under Membership Directory Manager. Also. THERE IS NO USERNAME or PASSWORD. IT connects ANONYMOUSLY. Yes. NO LOGIN/PASSWORD. I am trying to retrieve all data from the directory with the following coldfusion code executed on LOCALHOST: cfldap server=127.0.0.1 port=1003 action=query name=results start=ou=Members, o=CompuSport scope=onelevel attributes=cn sort=ou maxrows=100 timeout=2 cfoutput#results.recordCount#/cfoutput Problem IS...it doesn't DO anything. It HANGs forever and it retrieve no Information. The Log files only tell me: The request has exceeded the allowable time limit Tag: cfoutput The specific sequence of files included or processed is: C:\ColdFusion8\wwwroot\scripts\ldap.cfm, line: 23 I am clueless...please help... Ravi. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4