Re: Country/City/Province List for DB import

2008-05-01 Thread [STS] Ravi Gehlot
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

2008-05-01 Thread [STS] Ravi Gehlot
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

2008-05-01 Thread [STS] Ravi Gehlot
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

2008-04-30 Thread [STS] Ravi Gehlot
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

2008-04-19 Thread [STS] Ravi Gehlot
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

2008-04-17 Thread [STS] Ravi Gehlot
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

2008-04-17 Thread [STS] Ravi Gehlot
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

2008-04-16 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
 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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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

2008-04-14 Thread [STS] Ravi Gehlot
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?

2008-04-13 Thread [STS] Ravi Gehlot
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?

2008-04-13 Thread [STS] Ravi Gehlot
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

2008-04-13 Thread [STS] Ravi Gehlot
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

2008-03-27 Thread [STS] Ravi Gehlot
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