Re: Is the Netscape browser still a consideration?

2002-02-20 Thread DDB Lists

Last time I set up an html mail (2 weeks ago), I had to redo it because
people couldn't read it using their NS 4.5 mail client. Go figure.

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 5:24 AM
Subject: RE: Is the Netscape browser still a consideration?


 It's an assumption on my part, looks like everyone else thinks
 differently.

 I guess there could be a few people out there running NS 4.7 on a 75mhz
 computer, not worrying about upgrading anything because it does what
 they need.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread list peters

hi, i dont like the argument used my some people that if netscape has 5% of
the market, and your site doesnt work for them you will have a 5% drop in
sales.  That assumes that 100% of people that go to your site are buying -
so you would be getting 95% sale rate which is pretty great!

i hear this all the time - and it drives me nuts.

my 2 cents - i make the site viewable in netscape - accepting some weirdo
table problems etc - as long as it can be viewed.

c

 Even if the percentage of users for all wacko browsers is just ... say
 .. 5%.  Are you willing to take a 5% drop in sales for an unknown
 duration?  Like others I not only still see NN3 users... I'm still
 seeing AOL 3 on a site where about 10% of users are on AO-Hell - the
 typical site demographic is an affluent, college-educated, married male
 in his mid-forties.  5-8% is about right for *all* NN users on that site
 right now.

 Bah.

 --Matt Robertson--
 MSB Designs, Inc.
 http://mysecretbase.com
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Jim McAtee

CSS is by far the simplest obstacle to overcome.  Detect the browser and use
the appropriate sub/superset of CSS that makes the site palatable.
JavaScript and simple HTML, on the other hand can be a freaking nightmare.
I balance it on development costs vs. the cost of telling N% of visitors
that I could care less if the site looks good to them.  Usually, I opt for
the least expensive solution.  Take a wild guess which one that usually
is...

Jim


- Original Message -
From: Rey Bango [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 10:40 PM
Subject: Re: SOT: Is the Netscape browser still a consideration?


 Hi Howard.

 The CSS issue was one of the main reasons that I started this post. I was
 working on a site and implemented some design elements using styles that
 really enhanced the appearance of the site. I actually did test it out in
 Netscape 6.2 as well as IE 5.5 and both rendered the site beautifully. The
 pain came in when I loaded up Netscape 4.7x. The site was just
 non-functional and it really irritated me. So it prompted me to do some
 homework to determine what other developers were doing.

 Based on the feedback so far, its seems prudent to continue to support
 Netscape. I just wish that a baseline of Netscape 6.0 could be established
 but such a meaningful percentage of NS 4.7 users still out there, it
appears
 that some workarounds will still be needed. Sigh...

 Thanks for your input.

 Rey///

 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 20, 2002 12:17 AM
 Subject: RE: SOT: Is the Netscape browser still a consideration?


  The site I mentioned in my previous e-mail is also an RV site. About the
  same traffic. Average age of registered users is 56.
 
  My biggest problem isn't NS users, it's WebTV users.  Currently, we only
 get
  about 1.5 percent WebTV, but I get complaints from them all of the time.
  Not so much design, but a lot of functionality (javascripts, form
  submissions, picture uploads) don't work or don't work as well or work
  inconsistently with WebTV (thought I haven't received a complaint in
 several
  months, so maybe WebTV has improved).
 
  The redesign I'm working on right now looked great in IE. It totally
falls
  apart in NS 4.7.  It's totally useless in 4.7.  And my code is W3
 validated.
  But CSS is a huge problem.  My solution will probably be to do a browser
  redirect and send NS users to a totally stripped down version of the
site.
  It will pretty much be just black text, white background and links and
  forms.  No design. I want to have a site that useable for those 7
percent,
  but with such a small audience, I'm not going to waste a lot of time on
 it.
 
  As far as I'm concerned (and this is just a personal opinion and how I
  approach site building), IE's won.
 
  H.
 
 
 
  -Original Message-
  From: Tom Nunamaker [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, February 19, 2002 8:09 PM
  To: CF-Talk
  Subject: RE: SOT: Is the Netscape browser still a consideration?
 
 
  We run an RV Classified site with about 40,000 visitors per month.  The
  average age of Rver's is in their early 60's.  Believe it or not, about
  1.5% of our visitors use Netscape 3.0.
 
  We've had to code in FONT tags with the CSS classes so it didn't look
  horrible in NS 3.0
 
  Tom Nunamaker
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, February 19, 2002 10:04 PM
  To: CF-Talk
  Subject: Re: SOT: Is the Netscape browser still a consideration?
 
 
  Here's my .02 cents
 
   I'm leaning towards giving more consideration to the Netscape 6.0 above
  but
  I'm not ready to declare Netscape 4.75 dead. I think there's still about
  10
  percent of the internet users that are using Netscape 4.75. Netscape 6.0
  is
  coming along real nicely and I've seen some users jumping over from IE
  to
  Netscape 6.0.
 
   It would make sense if someone would overlook some of the small design
  differences between Netscape 4.75 and 6.0 +. However, I wouldn't go too
  far
  in ignoring some of the glaring layout differences. The clients we work
  with
  generally have no understanding why there's a browser war, why netscape
  4.75
  doesn't support some of the HTML tags as well as IE does and etc. It
  would
  hurt the contractors' reputation if they were to ignore 4.75 as of now.
 
   If anyone wants to work with IE 5.5 and Netscape 6.0+ exclusively then
  there
  are almost zero differences between those versions. It'll make your job
  much
  easier.
 
I have a small site tracking system on my site and every one user in
  about
  10 or 15 users are showing up with a 4.75 version. So I have no choice
  but to
  design sites for 3 different versions. Thus, I'd recommend you do the
  same
  thing.
 
 
 
   For the longest time, I've coded my sites to take into account
   Netscape users but with the ever-dwindling numbers 

Re: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Jim McAtee

A site for which we develop wanted all kinds of whiz-bang neato DHMTL and
all kinds of extraneous crap and enhancements extraordinaire.  We gave it to
them, only supporting IE 5+.  In the last 4 months their traffic is up 40%
to 50%.  Did the Opera and Netscape and AOL 2 users fall away as a result?
Who cares.  Everybody is happy.  Life is good.  Life is simple again.

Jim

- Original Message -
From: Rey Bango [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 9:22 PM
Subject: Re: SOT: Is the Netscape browser still a consideration?


 Nick,

 Great points bud. The main reason that I'm asking the development
community
 is because I wanted to gauge what everyone else was doing. This list has
 such a diverse talent pool that it really gives you a good indication as
to
 new trends in ecommerce development. Notice that we've had varying replies
 that go from one extreme to the next. That's why it was so important to me
 to pose the question here.

 Thanks again for your feedback. Keep it coming.

 Rey...

 - Original Message -
 From: Nick Texidor [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, February 19, 2002 11:06 PM
 Subject: Re: SOT: Is the Netscape browser still a consideration?


  I'm not sure what the general consensus is, but in my opinion, I would
  continue to code for Netscape, and also consider Opera too.  If everyone
  gives up coding for the other browsers, then it's game over,  MS will
  not only own your personal machines, but the internet too!The other
  option of course is those people who don't run IE will simply not return
  to your sites, and from where I sit, I see a few more people looking at
  the alternatives to windows than there were just a few months ago.
 
  I think you need to put the question to your clients, not the
  developers.  Most of the CF list probably wouldn't care a jot if they
  only had to develop for IE.  But their clients may be a little more
  caring!  The last thing you want to do is go to a client and say 'we'll
  code it for IE', only to receive a call a week after it goes live saying
  'my mate said he can't view the site'...  the client isn't going to be
  too happy.  IMHO, code for the biggest market, because people will
  simply not return to your site if the only way they can see it is to
  have to download another browser.
 
  All our sites are tested under different browsers on several platforms.
  We still have clients that use Netscape as their main browser.  We all
  use different browsers internally too, I prefer to use Opera, and
  occasionally Netscape, on Linux, and for the one site that forces me to
  use IE (Internet Banking), I switch on my NT box (although I'm looking
  at switching banks because of this very reason).  Our designers either
  use Netscape or IE, but both on the Mac platform.
 
  Just my thoughts.
 
  N
 
 
 
  Rey Bango wrote:
  
   For the longest time, I've coded my sites to take into account
Netscape
   users but with the ever-dwindling numbers of Navigator afficianados
and
 IE's
   continued growth, I've been wondering if I should even bother worrying
 about
   whether my sites work with Netscape.
  
   Since this has been one of my best resources for info and some of the
 most
   talented and savvy people that I've met post to CF-Talk, I was hoping
 that I
   could get some good feedback.
  
   So, if we consider that the apps that I'm developing will be geared
 towards
   the Internet consumer at large and I won't have the luxury of
developing
 for
   a controlled environment like a corporate intranet, I beg the
question:
  
   Should I continue to worry about Netscape? If so, which version should
 serve
   as a baseline?
  
   Looking forward to your responses.
  
   C-ya,
  
   Rey...
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is the Netscape browser still a consideration?

2002-02-20 Thread Jochem van Dieten

DDB Lists wrote:
 Last time I set up an html mail (2 weeks ago), I had to redo it because
 people couldn't read it using their NS 4.5 mail client. Go figure.

I usually store HTML mail in /dev/null. Go figure ;)

Jochem
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Date Range Query by Month/Year

2002-02-20 Thread Kevan . Windle

yep you can use CVDate() or Cdate depending on the access version to turn a
string into a date. e.g 

where CVDate( Month  '01/'  '/'  Year) between #Oct/01/2001# and
#Feb/01/2002#


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 21:34
To: CF-Talk
Subject: Date Range Query by Month/Year


I've been handed an Access table which has columns for Month and Year, but
no actual date or date/time columns.  Is there any way that I can construct
a query that pulls records for a range of months?  For example, from
10/2001 to 02/2002?

Could it be done somehow by using a database function to synthesize date
columns, that is, by turning Month and Year into a 'real' date of
Month-01-Year?

Thanks,
Jim

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfftp action=CHANGEDIR

2002-02-20 Thread phumes1

Hi,

Does the CHANGEDIR action change the directory on the local or remote pc?

This directory does exist on the server.

I get this error...

Error Diagnostic Information
550 c:\test\fonts\pfb: The filename, directory name, or volume label syntax 
is incorrect.

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is the Netscape browser still a consideration?

2002-02-20 Thread Pete Ruckelshaus

Ugh.  I am fighting this battle right now at work.

I hate the fact that instead of being able to code a standards-compliant web
site (which would allow me to focus most of my attention on actually
building the application), I have to employ hacks and workarounds just so I
can support the 8% of our site users that are using a browser whose lineage
dates back 4.5+ years (Netscape 4.0 came out in June 1997).  CSS standards?
Nope.  Predictable HTML output?  Nope.  Yet the situation at my current
employer demands nothing less -- too few people to do too much work.  By
being able to focus on standards rather than workarounds, we can get much
more work done in less time.  Don't like the way the site looks in Netscape
4.08?  Upgrade your browser, plain and simple...much better ones exist.

I am pushing towards only supporting browsers based upon what their
standards support is.  HTML 4.01 and CSS1 full (OK, 95%) compliance is what
I would like, which pretty much includes MSIE 4+, Mozilla, NS 6+, and Opera.

Personally, I think all browsers should time bomb after 2 years, so that
users are forced to upgrade from time to time.

Pete

- Original Message -
From: Rey Bango [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 10:42 PM
Subject: SOT: Is the Netscape browser still a consideration?


 For the longest time, I've coded my sites to take into account Netscape
 users but with the ever-dwindling numbers of Navigator afficianados and
IE's
 continued growth, I've been wondering if I should even bother worrying
about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the most
 talented and savvy people that I've met post to CF-Talk, I was hoping that
I
 could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
towards
 the Internet consumer at large and I won't have the luxury of developing
for
 a controlled environment like a corporate intranet, I beg the question:

 Should I continue to worry about Netscape? If so, which version should
serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...

 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: I am searching for a fast and stable xml parser

2002-02-20 Thread Craig Dudley

I've use cf_xmlparser myself quite a bit, it's very, very fast under 
load
when compared to cf_soxml and is also easier to use imho.

-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 02:24
To: CF-Talk
Subject: RE: I am searching for a fast and stable xml parser


Try cf_xmlparser from cfdev.com

Written in Java, fast and works great in the small apps I have done 
with it.

http://www.cfdev.com/xml/xmlparser/



Sandra Clark
Macromedia Certified Advanced Coldfusion 5.0 Developer
Shayna Productions
http://www.shayna.com
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]



-Original Message-
From: Thorsteinn_E._Jónsson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 6:53 PM
To: CF-Talk
Subject: Re: I am searching for a fast and stable xml parser


Me too

Cheers


Steini
- Original Message -
From: Martin Orth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 4:39 PM
Subject: I am searching for a fast and stable xml parser


 Hi,

 currently I am using cf_soxml with microsoft xml parsing 
technology.
 With high server load this is not stable with cf 5.0.

 Any recomendations for a better solution?

 Thanks

 Martin

 --
 cfsolutions - Martin Orth
 Hornstrasse 127  - 51465 Bergisch Gladbach - Germany
 Tel. +49 (0)2202 86 25 12  - Fax +49 (0)2202 86 25 13



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Accessing FoxPro database

2002-02-20 Thread Bill Grover

Unless your CF Service is running as the interactive user then CF will 
not
see any drive letters, you will need to use UNC coding.  Also, you need 
to
make sure that whatever user CF is running as has rights to the file.  
In
our case we ended up creating a special user that CF runs as that we 
can
then give rights to specific information on other servers.

So to summarize what we did was:

1)  Created a CF user for the service to run as.
2)  Granted rights to the CF User to the data that CF needed to access.
3)  Created an ODBC connection to the directory where the FoxPro tables 
are
using UNC coding.  I.E. the path would be 
\\ServerB\TheShare\pro50\ARDATA
4)  Do the following:

cfquery datasource=foxprodsn name=getsodata debug
SELECT custno FROM arcust10
/cfquery

That should do it.
__ 

Bill Grover 
Supervisor MIS  Phone:  301.424.3300 x3324  
EU Services, Inc.   FAX:301.424.3696
649 North Horners Lane  E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__ 



 -Original Message-
 From: Andres [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 19, 2002 12:15 PM
 To: CF-Talk
 Subject: Accessing FoxPro database
 
 
 Hello All,
 I am trying to access a foxpro database. This database is stored in 
 server A, while  the Cold Fusion and web server is located in 
 server B. 
 Server B has all the odbc connections set to read and access 
 the foxpro 
 files in server A.
 
 When i try to run the following query i get an error:
 
 cfquery datasource=foxprodsn name=getsodata debug
 SELECT custno FROM S:\pro50\ARDATA\arcust10.dbf
 /cfquery
 
 This is the error i get:
 
 ODBC Error Code = S0002 (Base table not found)
 [Microsoft][ODBC Visual FoxPro Driver]File 'arcust10.dbf' does not 
 exist.
 
 The error occurred while processing an element with a general 
 identifier 
 of (CFQUERY), occupying document position (9:1) to (9:56).
 
 I've also tried these other ways:
 SELECT custno FROM 'S:\pro50\ARDATA\arcust10.dbf'
 and...
 SELECT custno FROM arcust10.dbf
 and...
 SELECT custno FROM 'arcust10.dbf'
 and...
 SELECT custno FROM arcust10
 and...
 SELECT custno FROM 'arcust10'
 
 I've also made sure the table DOES EXIST... and that i have access to 

 this mapped drive (s drive). I have also ensured that the 
 odbc settings 
 point to the right location.
 
 Any ideas will be most appreciated.
 
 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Mike Alberts

I just had to get in on this one ...

While there really isn't much debating that the browser war is over (which
is as much Netscape's fault for releasing junk as it is Microsoft's for
predatory practices), IMHO anyone that doesn't account for some 4.x version
of Netscape when developing sites (intranets aside of course) is just being
lazy and not doing their job. Those of us that have been developing for a
fair amount of time have been fighting with this since day one. It's called
site usability.

We as developers I think tend to get tunnel vision. Just because we are
technically adept we think that the average person is as well. The reality
is that the average joe on the web just wants to read his email, find a good
deal on Ebay, do a little research on products, and keep up with his/her
favorite hobbies, and read the latest news. And he/she is doing it on a 56k
modem. They don't care if they have the latest and greatest browser. What
they have is working (as far as they know), and they don't want to wait for
4 hours to download the latest piece of bloatware.

I for one am all for standards. It would be great if we didn't have this
mess to deal with. But then there's reality. The reality is we have had to
deal with this for years, and it isn't going away for awhile. While it is
part of our job description to keep up with technology, the average person
just doesn't want to deal with the headaches. There are millions of people
still using older browsers at 800x600 (and even 640x480) resolution. If
developers spent a little more time making their sites usable for the
average person, instead of incorporating all this Flash and fancy imagery
and DHTML and all this other stuff that people don't want to wait 5 minutes
to download, the web would be a better place for everyone. Granted, these
things have their place, and their time will come, but not until the average
user is using something a little better than a simple dialup connection. And
I don't see that happening anytime too soon. People just want to find their
information, they don't want to wait all day for it to download, and they
want it to be viewable with the browser they are using. not the one the
developer tells them they need.

The internet worked fine when it was a bunch of geeks writing basic HTML,
and just because the world of print and multimedia designers on their
Macintosh computers decided that we could do all this fancy design and Flash
and all this other wiz bang stuff doesn't mean that it's necessarily the
right thing to do.

My .02, and sorry for ranting

Mike Alberts

 Tue, 19 Feb 2002 22:42:59 -0500
 From: Rey Bango [EMAIL PROTECTED]
 Subject: SOT: Is the Netscape browser still a consideration?
 Message-ID: 019b01c1b9c0$b18928a0$[EMAIL PROTECTED]

 For the longest time, I've coded my sites to take into account Netscape
 users but with the ever-dwindling numbers of Navigator afficianados and
IE's
 continued growth, I've been wondering if I should even bother worrying
about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the most
 talented and savvy people that I've met post to CF-Talk, I was hoping that
I
 could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
towards
 the Internet consumer at large and I won't have the luxury of developing
for
 a controlled environment like a corporate intranet, I beg the question:

 Should I continue to worry about Netscape? If so, which version should
serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Request Scope.

2002-02-20 Thread Martin Sutton

Hi all,

Can any of you explain to me why the request scope is useful, if indeed, it
is?  It is one of the few scopes I am unfamiliar with.  Can it be used to
enhance my code?

Regards,

Martin.
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Matt Robertson

Yes, I understand the argument is flawed, but the root idea is sound.
You can't place barriers to usability without paying some sort of
penalty.  Mike Alberts post is right on with this, imho.

--Matt--

From: list peters [mailto:[EMAIL PROTECTED]] 
hi, i dont like the argument used my some people that if netscape has 5%
of the market, and your site doesnt work for them you will have a 5%
drop in sales.  That assumes that 100% of people that go to your site
are buying - so you would be getting 95% sale rate which is pretty
great!
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Request Scope.

2002-02-20 Thread Pete Ruckelshaus

I use the request scope because those variables are (as I understand it)
available globally -- in templates, app.cfm, and custom tag files.

Pete

- Original Message -
From: Martin Sutton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 8:08 AM
Subject: Request Scope.


 Hi all,

 Can any of you explain to me why the request scope is useful, if indeed,
it
 is?  It is one of the few scopes I am unfamiliar with.  Can it be used to
 enhance my code?

 Regards,

 Martin.
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Datatypes

2002-02-20 Thread Dave Watts

  text = varchar or nvarchar
  number = integer (but can be split into float, smallint, 
  decimal, tinyint depending on the actual data you're storing)

 None of those number datatypes let me specify the length.  
 Any recommendations on what datatype to use that will let me 
 specify the length (for numbers)?

I'm not sure what you mean by length for numbers. Numeric fields aren't
used in the same way that character fields are. When you create a character
field, you can specify how many characters can be placed in the field. With
numeric fields, you can choose the exact numeric field type that allows you
to store the largest number in the range of numbers that you might want to
store. For example, in SQL Server, an integer field lets you store numbers
between -2,147,483,648 and 2,147,483,647; a bigint field can store numbers
between -2^63 (-9,223,372,036,854,775,808) and 2^63-1
(9,223,372,036,854,775,807); a smallint field can store numbers between
-32,768 and 32,767; a tinyint field can store numbers between 0 and 255.
Note that for any of these fields, the actual length of the field within
the record is going to be some specified number of bytes: 1, 2, 4 or 8 for
tinyint, smallint, integer, and bigint respectively.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Request Scope.

2002-02-20 Thread Rosenbaum, Daniel

Think of the Request scope like Session scope for a single HTTP 
request.
Variables set in the Request scope are available to all templates 
accessed
during that single request.  For example you could read a Request scope
variable in that was set in a custom tag.  Unlike Session variables 
Request
scope variables are single threaded and therefore do not have to be 
locked
when you read and write them.  

I hope that helps you see how they can be very useful in developing
applications.

Regards,

 Dan Rosenbaum
 Wachovia Securities
 Corporate  Investment Banking
 [EMAIL PROTECTED]
 
 -Original Message-
 From: Martin Sutton [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 8:08 AM
 To:   CF-Talk
 Subject:  Request Scope.
 
 Hi all,
 
 Can any of you explain to me why the request scope is useful, if 
indeed,
 it
 is?  It is one of the few scopes I am unfamiliar with.  Can it be 
used to
 enhance my code?
 
 Regards,
 
 Martin.
 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Flash Graphing

2002-02-20 Thread Haggerty, Michael A.

Yeah, it is actually pretty easy to make graphs in Flash. I have some 
good
libraries I can show you, contact me off list for details. 

You may wish to consider the value of building this yourself over 
purchasing
a commercial package (or upgrading to CF 5). I've found the cost of
building, testing, debuging, and deploying a good Flash graphing 
solution
(*especially if you want it to have drill down capability) generally 
exceeds
the price of buying one of the good ones that are already out there. 

My personal fave is the one from Corda, which just beats CF_Graph in so 
many
ways it is not funny. 

http://www.corda.com

For the record, I am not employed by Corda, just a happy user. 

Mike

-Original Message-
From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 4:04 PM
To: CF-Talk
Subject: CF  Flash Graphing


Does any one know of a way to make graphs with Flash? I can get the
values into Flash but how do I make the graphs? They need to be
something like what you get in Excel. Any ideas?

Thanks

Phillip Broussard
Tracker Marine Group
417-873-5957



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread jon

We get the same thing from our WebTV users... also a small, but vocal
percentage.

I've also noticed a drop in complaints, though. My impression is that the
latest version of WebTV can support Java and whatnot pretty well, but I'm
not sure if it's even being sold anymore. The price of regular PC's has come
down so low that one wonders why anyone would buy a clumsy device like a
webtv.

-- jon

-
jon roig
online community services manager
epilepsy foundation
tel:   215.850.0710
site:  http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 12:17 AM
To: CF-Talk
Subject: RE: SOT: Is the Netscape browser still a consideration?


The site I mentioned in my previous e-mail is also an RV site. About the
same traffic. Average age of registered users is 56.

My biggest problem isn't NS users, it's WebTV users.  Currently, we only get
about 1.5 percent WebTV, but I get complaints from them all of the time.
Not so much design, but a lot of functionality (javascripts, form
submissions, picture uploads) don't work or don't work as well or work
inconsistently with WebTV (thought I haven't received a complaint in several
months, so maybe WebTV has improved).

The redesign I'm working on right now looked great in IE. It totally falls
apart in NS 4.7.  It's totally useless in 4.7.  And my code is W3 validated.
But CSS is a huge problem.  My solution will probably be to do a browser
redirect and send NS users to a totally stripped down version of the site.
It will pretty much be just black text, white background and links and
forms.  No design. I want to have a site that useable for those 7 percent,
but with such a small audience, I'm not going to waste a lot of time on it.

As far as I'm concerned (and this is just a personal opinion and how I
approach site building), IE's won.

H.



-Original Message-
From: Tom Nunamaker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:09 PM
To: CF-Talk
Subject: RE: SOT: Is the Netscape browser still a consideration?


We run an RV Classified site with about 40,000 visitors per month.  The
average age of Rver's is in their early 60's.  Believe it or not, about
1.5% of our visitors use Netscape 3.0.

We've had to code in FONT tags with the CSS classes so it didn't look
horrible in NS 3.0

Tom Nunamaker

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 10:04 PM
To: CF-Talk
Subject: Re: SOT: Is the Netscape browser still a consideration?


Here's my .02 cents

 I'm leaning towards giving more consideration to the Netscape 6.0 above
but
I'm not ready to declare Netscape 4.75 dead. I think there's still about
10
percent of the internet users that are using Netscape 4.75. Netscape 6.0
is
coming along real nicely and I've seen some users jumping over from IE
to
Netscape 6.0.

 It would make sense if someone would overlook some of the small design
differences between Netscape 4.75 and 6.0 +. However, I wouldn't go too
far
in ignoring some of the glaring layout differences. The clients we work
with
generally have no understanding why there's a browser war, why netscape
4.75
doesn't support some of the HTML tags as well as IE does and etc. It
would
hurt the contractors' reputation if they were to ignore 4.75 as of now.

 If anyone wants to work with IE 5.5 and Netscape 6.0+ exclusively then
there
are almost zero differences between those versions. It'll make your job
much
easier.

  I have a small site tracking system on my site and every one user in
about
10 or 15 users are showing up with a 4.75 version. So I have no choice
but to
design sites for 3 different versions. Thus, I'd recommend you do the
same
thing.



 For the longest time, I've coded my sites to take into account
 Netscape users but with the ever-dwindling numbers of Navigator
 afficianados and IE's continued growth, I've been wondering if I
 should even bother worrying about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the
 most talented and savvy people that I've met post to CF-Talk, I was
 hoping that I could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
 towards the Internet consumer at large and I won't have the luxury of
 developing for a controlled environment like a corporate intranet, I
 beg the question:

 Should I continue to worry about Netscape? If so, which version should
 serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...


Nathaniel Horwitz
mailto:[EMAIL PROTECTED]
AIM: NRHorwitz
Fax: 510-573-2298
Web Site: http://www.nathanielhorwitz.com

 What separates winning from losing is the head. The brain sometimes
doesn't
believe in the power of the body






__
Why Share?
  Dedicated Win 2000 Server 

RE: only one MD5 hash?

2002-02-20 Thread Rob Brooks-Bilson


For all you interested in various hash algorithms with CF, check out the
security library at www.cflib.org.  I have UDF versions of MD5, SHA-1,
SHA-256, and Rimemd-160.  All of the source code is available for free.

-Rob

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Matthew R. Small

One more opinion about browsers -
Somebody needs to raise the bar.  If we all coded using present
W3C standards and 5-10% of the population can't view it properly, then
that's their fault, not the coder's.  Not everybody can always use the
latest and greatest features, but they should be forced to at some
point, shouldn't they?  The way I see it, those viewers using netscape
4.x and lower should be forced to deal with crappy pages, unusable
javascript, and non-functioning CSS.  It might persuade them to upgrade
to a browser which works, AND is free as well.  Progress waits for
nobody.

- Matt Small



-Original Message-
From: jon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 9:23 AM
To: CF-Talk
Subject: RE: SOT: Is the Netscape browser still a consideration?

We get the same thing from our WebTV users... also a small, but vocal
percentage.

I've also noticed a drop in complaints, though. My impression is that
the
latest version of WebTV can support Java and whatnot pretty well, but
I'm
not sure if it's even being sold anymore. The price of regular PC's has
come
down so low that one wonders why anyone would buy a clumsy device like a
webtv.

-- jon

-
jon roig
online community services manager
epilepsy foundation
tel:   215.850.0710
site:  http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 12:17 AM
To: CF-Talk
Subject: RE: SOT: Is the Netscape browser still a consideration?


The site I mentioned in my previous e-mail is also an RV site. About the
same traffic. Average age of registered users is 56.

My biggest problem isn't NS users, it's WebTV users.  Currently, we only
get
about 1.5 percent WebTV, but I get complaints from them all of the time.
Not so much design, but a lot of functionality (javascripts, form
submissions, picture uploads) don't work or don't work as well or work
inconsistently with WebTV (thought I haven't received a complaint in
several
months, so maybe WebTV has improved).

The redesign I'm working on right now looked great in IE. It totally
falls
apart in NS 4.7.  It's totally useless in 4.7.  And my code is W3
validated.
But CSS is a huge problem.  My solution will probably be to do a browser
redirect and send NS users to a totally stripped down version of the
site.
It will pretty much be just black text, white background and links and
forms.  No design. I want to have a site that useable for those 7
percent,
but with such a small audience, I'm not going to waste a lot of time on
it.

As far as I'm concerned (and this is just a personal opinion and how I
approach site building), IE's won.

H.



-Original Message-
From: Tom Nunamaker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:09 PM
To: CF-Talk
Subject: RE: SOT: Is the Netscape browser still a consideration?


We run an RV Classified site with about 40,000 visitors per month.  The
average age of Rver's is in their early 60's.  Believe it or not, about
1.5% of our visitors use Netscape 3.0.

We've had to code in FONT tags with the CSS classes so it didn't look
horrible in NS 3.0

Tom Nunamaker

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 10:04 PM
To: CF-Talk
Subject: Re: SOT: Is the Netscape browser still a consideration?


Here's my .02 cents

 I'm leaning towards giving more consideration to the Netscape 6.0 above
but
I'm not ready to declare Netscape 4.75 dead. I think there's still about
10
percent of the internet users that are using Netscape 4.75. Netscape 6.0
is
coming along real nicely and I've seen some users jumping over from IE
to
Netscape 6.0.

 It would make sense if someone would overlook some of the small design
differences between Netscape 4.75 and 6.0 +. However, I wouldn't go too
far
in ignoring some of the glaring layout differences. The clients we work
with
generally have no understanding why there's a browser war, why netscape
4.75
doesn't support some of the HTML tags as well as IE does and etc. It
would
hurt the contractors' reputation if they were to ignore 4.75 as of now.

 If anyone wants to work with IE 5.5 and Netscape 6.0+ exclusively then
there
are almost zero differences between those versions. It'll make your job
much
easier.

  I have a small site tracking system on my site and every one user in
about
10 or 15 users are showing up with a 4.75 version. So I have no choice
but to
design sites for 3 different versions. Thus, I'd recommend you do the
same
thing.



 For the longest time, I've coded my sites to take into account
 Netscape users but with the ever-dwindling numbers of Navigator
 afficianados and IE's continued growth, I've been wondering if I
 should even bother worrying about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the
 most talented and savvy people that 

RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Haggerty, Michael A.

Does anyone remember the CF_FIX_NETSCAPE tag that was in the developer's
gallery a few years ago? Reported to fix all problems with Netscape, it
would check to see what browser you were using and, if it was netscape, it
could issue a CF_ABORT tag. 

I have written Allaire and now Macromedia many times asking for this to
become a native feature of the product.

Seriously, a Web site should be compliant with various browsers as dictated
by their user community. I am responsible for eight sites in three
government agencies right now; five of those sites are IE preferred (meaning
we design exclusively for IE), because less than 1% of the hits each month
come from browsers other than IE. On the other hand, at another unnamed govt
agency, the standard Web browser is NS 3. 95% of users have it and use it
daily. 

Mike

-Original Message-
From: Mike Alberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:46 AM
To: CF-Talk
Subject: Re: SOT: Is the Netscape browser still a consideration?


I just had to get in on this one ...

While there really isn't much debating that the browser war is over (which
is as much Netscape's fault for releasing junk as it is Microsoft's for
predatory practices), IMHO anyone that doesn't account for some 4.x version
of Netscape when developing sites (intranets aside of course) is just being
lazy and not doing their job. Those of us that have been developing for a
fair amount of time have been fighting with this since day one. It's called
site usability.

We as developers I think tend to get tunnel vision. Just because we are
technically adept we think that the average person is as well. The reality
is that the average joe on the web just wants to read his email, find a good
deal on Ebay, do a little research on products, and keep up with his/her
favorite hobbies, and read the latest news. And he/she is doing it on a 56k
modem. They don't care if they have the latest and greatest browser. What
they have is working (as far as they know), and they don't want to wait for
4 hours to download the latest piece of bloatware.

I for one am all for standards. It would be great if we didn't have this
mess to deal with. But then there's reality. The reality is we have had to
deal with this for years, and it isn't going away for awhile. While it is
part of our job description to keep up with technology, the average person
just doesn't want to deal with the headaches. There are millions of people
still using older browsers at 800x600 (and even 640x480) resolution. If
developers spent a little more time making their sites usable for the
average person, instead of incorporating all this Flash and fancy imagery
and DHTML and all this other stuff that people don't want to wait 5 minutes
to download, the web would be a better place for everyone. Granted, these
things have their place, and their time will come, but not until the average
user is using something a little better than a simple dialup connection. And
I don't see that happening anytime too soon. People just want to find their
information, they don't want to wait all day for it to download, and they
want it to be viewable with the browser they are using. not the one the
developer tells them they need.

The internet worked fine when it was a bunch of geeks writing basic HTML,
and just because the world of print and multimedia designers on their
Macintosh computers decided that we could do all this fancy design and Flash
and all this other wiz bang stuff doesn't mean that it's necessarily the
right thing to do.

My .02, and sorry for ranting

Mike Alberts

 Tue, 19 Feb 2002 22:42:59 -0500
 From: Rey Bango [EMAIL PROTECTED]
 Subject: SOT: Is the Netscape browser still a consideration?
 Message-ID: 019b01c1b9c0$b18928a0$[EMAIL PROTECTED]

 For the longest time, I've coded my sites to take into account Netscape
 users but with the ever-dwindling numbers of Navigator afficianados and
IE's
 continued growth, I've been wondering if I should even bother worrying
about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the most
 talented and savvy people that I've met post to CF-Talk, I was hoping that
I
 could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
towards
 the Internet consumer at large and I won't have the luxury of developing
for
 a controlled environment like a corporate intranet, I beg the question:

 Should I continue to worry about Netscape? If so, which version should
serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona

RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Steve Oliver

People just want to find their 
information, they don't want to wait all day for it to download, and
they
want it to be viewable with the browser they are using. not the one the
developer tells them they need.

Most of the time it's not up to the developer anyways.  We go by what
the client wants on their site.

If they say they want a flash intro, so be it.

Anyways, I couldn't imagine a web without pictures and flash and dhtml,
it would be like a magazine with nothing but text inside.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mike Alberts [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 7:46 AM
To: CF-Talk
Subject: Re: SOT: Is the Netscape browser still a consideration?


I just had to get in on this one ...

While there really isn't much debating that the browser war is over
(which
is as much Netscape's fault for releasing junk as it is Microsoft's for
predatory practices), IMHO anyone that doesn't account for some 4.x
version
of Netscape when developing sites (intranets aside of course) is just
being
lazy and not doing their job. Those of us that have been developing for
a
fair amount of time have been fighting with this since day one. It's
called
site usability.

We as developers I think tend to get tunnel vision. Just because we are
technically adept we think that the average person is as well. The
reality
is that the average joe on the web just wants to read his email, find a
good
deal on Ebay, do a little research on products, and keep up with his/her
favorite hobbies, and read the latest news. And he/she is doing it on a
56k
modem. They don't care if they have the latest and greatest browser.
What
they have is working (as far as they know), and they don't want to wait
for
4 hours to download the latest piece of bloatware.

I for one am all for standards. It would be great if we didn't have this
mess to deal with. But then there's reality. The reality is we have had
to
deal with this for years, and it isn't going away for awhile. While it
is
part of our job description to keep up with technology, the average
person
just doesn't want to deal with the headaches. There are millions of
people
still using older browsers at 800x600 (and even 640x480) resolution. If
developers spent a little more time making their sites usable for the
average person, instead of incorporating all this Flash and fancy
imagery
and DHTML and all this other stuff that people don't want to wait 5
minutes
to download, the web would be a better place for everyone. Granted,
these
things have their place, and their time will come, but not until the
average
user is using something a little better than a simple dialup connection.
And
I don't see that happening anytime too soon. People just want to find
their
information, they don't want to wait all day for it to download, and
they
want it to be viewable with the browser they are using. not the one the
developer tells them they need.

The internet worked fine when it was a bunch of geeks writing basic
HTML,
and just because the world of print and multimedia designers on their
Macintosh computers decided that we could do all this fancy design and
Flash
and all this other wiz bang stuff doesn't mean that it's necessarily the
right thing to do.

My .02, and sorry for ranting

Mike Alberts

 Tue, 19 Feb 2002 22:42:59 -0500
 From: Rey Bango [EMAIL PROTECTED]
 Subject: SOT: Is the Netscape browser still a consideration?
 Message-ID: 019b01c1b9c0$b18928a0$[EMAIL PROTECTED]

 For the longest time, I've coded my sites to take into account
Netscape
 users but with the ever-dwindling numbers of Navigator afficianados
and
IE's
 continued growth, I've been wondering if I should even bother worrying
about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the
most
 talented and savvy people that I've met post to CF-Talk, I was hoping
that
I
 could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
towards
 the Internet consumer at large and I won't have the luxury of
developing
for
 a controlled environment like a corporate intranet, I beg the
question:

 Should I continue to worry about Netscape? If so, which version should
serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: 

RE: Request Scope.

2002-02-20 Thread Dave Watts

 Can any of you explain to me why the request scope is useful, 
 if indeed, it is? It is one of the few scopes I am unfamiliar 
 with. Can it be used to enhance my code?

The Request scope is like the local Variables scope, with one major
difference - any variables within it are available not only to your page,
but to any custom tags called by your page (and any custom tags called by
those tags, and so on). There's also one minor difference - you have to
explicitly specify the Request scope to create variables within it.

The primary use of this is to allow easier data sharing among all parts of a
page generating a response to a single request. For example, Spectra uses
quite a few custom tags, which themselves use custom tags, and so on. Rather
than passing data up and down the chain of tags (into tags via attributes,
out of tags via the Caller scope), the Spectra tags use the Request scope.

As for whether it can be used to enhance your code, who knows? It's just
another option when you're using custom tags. You may choose not to use it -
personally, I think that custom tags should be decoupled as much as
possible from the calling page, and generally shy away from using the
Request scope to share data between these tags and their calling page, but
others may certainly differ (and I might change my mind also, if I were
building something like Spectra). I tend to use the Request scope for what I
think of as constants - variables that I set with essentially static
values in Application.cfm - but I could certainly use the local Variables
scope just the same.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is the Netscape browser still a consideration?

2002-02-20 Thread Jon Hall

Here are some stats from a very large site, that appeals to a the general
population for this month so far. Took forever to genereate this report in
LiveStats... The numbers should speak for themselves. These are Livestat
session numbers, not hits or page views.
Analysis for the Month of Feb, 2002.

 Total sessions served during period : 801025

Most active browsers by type and version:
  MSIE 5.x   with   296141   sessions   (37.11% of all sessions)
  Netscape 4.x   with   290926   sessions   (36.45% of all sessions)
  AOL 4.x   with   98844   sessions   (12.39% of all sessions)
  Netscape 3.x   with   35885   sessions   (4.50% of all sessions)
  AOL 5.x   with   20564   sessions   (2.58% of all sessions)
  Netscape 5.x   with   16109   sessions   (2.02% of all sessions)
  Unknown   with   11594   sessions   (1.45% of all sessions)
  MSProxy 2.x   with   9699   sessions   (1.22% of all sessions)
  Opera 3.x   with   8388   sessions   (1.05% of all sessions)
  MSIE 4.x   with   7699   sessions   (0.96% of all sessions)
  WebTV 2.x   with   1321   sessions   (0.17% of all sessions)
  Netscape 2.x   with   326   sessions   (0.04% of all sessions)
  WebTV 1.x   with   242   sessions   (0.03% of all sessions)
  AOL 3.x   with   145   sessions   (0.02% of all sessions)
  MSIE 3.x   with   142   sessions   (0.02% of all sessions)
  Lotus-Notes   with   18   sessions   (0.00% of all sessions)
  MSIE 2.x   with   13   sessions   (0.00% of all sessions)
  Netscape 1.x   with   12   sessions   (0.00% of all sessions)
  MSProxy 1.x   with   8   sessions   (0.00% of all sessions)
  Opera 4.x   with   3   sessions   (0.00% of all sessions)
  MSIE 1.x   with   1   sessions   (0.00% of all sessions)

View Browsers by Agent Type Report
Most browsers by brand preference:
  MSIE   with   537034   sessions   (67.21% of all sessions)
  AOL   with   119672   sessions   (14.98% of all sessions)
  Netscape   with   46   sessions   (13.91% of all sessions)
  Other   with   11524   sessions   (1.44% of all sessions)
  MSProxy   with   9716   sessions   (1.22% of all sessions)
  Opera   with   8410   sessions   (1.05% of all sessions)
  WebTV   with   1563   sessions   (0.20% of all sessions)
  Lotus-Notes   with   18   sessions   (0.00% of all sessions)

Notice Netscape 6 (listed as 5) is more popular than WebTV, Opera, or IE4...

jon

- Original Message -
From: Rey Bango [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 10:42 PM
Subject: SOT: Is the Netscape browser still a consideration?


 For the longest time, I've coded my sites to take into account Netscape
 users but with the ever-dwindling numbers of Navigator afficianados and
IE's
 continued growth, I've been wondering if I should even bother worrying
about
 whether my sites work with Netscape.

 Since this has been one of my best resources for info and some of the most
 talented and savvy people that I've met post to CF-Talk, I was hoping that
I
 could get some good feedback.

 So, if we consider that the apps that I'm developing will be geared
towards
 the Internet consumer at large and I won't have the luxury of developing
for
 a controlled environment like a corporate intranet, I beg the question:

 Should I continue to worry about Netscape? If so, which version should
serve
 as a baseline?

 Looking forward to your responses.

 C-ya,

 Rey...

 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFFTP

2002-02-20 Thread phumes1

I have the following code but it FTP's the file from the server to another 
directory on the server. I want the file to be FTP'd to the client (my PC). 
into c:\fonts. Whats wrong with the below code?

cfftp action=OPEN
  username=test
  password=test
  server=IP address
  passive=Yes
  stoponerror=No
  connection=FontFTP

  cfftp action=CHANGEDIR
stoponerror=Yes
directory=/cdrive/test/fontload/pfb
connection=FontFTP

cfftp action=PUTFILE
connection=FontFTP
stoponerror=Yes
localfile=c:\fonts\test.pfb
remotefile=/cdrive/test/fontload/pfb/bp01272_.pfb
transfermode=AUTO


cfftp action=CLOSE
  connection=FontFTP
  stoponerror=Yes
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Request Scope.

2002-02-20 Thread Martin Sutton

Thanks to everyone who replied to that request (no pun intended).  I will
look into it further based on the information you provided.

Martin.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 15:06
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Request Scope.


 Can any of you explain to me why the request scope is useful,
 if indeed, it is? It is one of the few scopes I am unfamiliar
 with. Can it be used to enhance my code?

The Request scope is like the local Variables scope, with one major
difference - any variables within it are available not only to your page,
but to any custom tags called by your page (and any custom tags called by
those tags, and so on). There's also one minor difference - you have to
explicitly specify the Request scope to create variables within it.

The primary use of this is to allow easier data sharing among all parts of a
page generating a response to a single request. For example, Spectra uses
quite a few custom tags, which themselves use custom tags, and so on. Rather
than passing data up and down the chain of tags (into tags via attributes,
out of tags via the Caller scope), the Spectra tags use the Request scope.

As for whether it can be used to enhance your code, who knows? It's just
another option when you're using custom tags. You may choose not to use it -
personally, I think that custom tags should be decoupled as much as
possible from the calling page, and generally shy away from using the
Request scope to share data between these tags and their calling page, but
others may certainly differ (and I might change my mind also, if I were
building something like Spectra). I tend to use the Request scope for what I
think of as constants - variables that I set with essentially static
values in Application.cfm - but I could certainly use the local Variables
scope just the same.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Yager, Brian T Contractor/NCCIM

I would like to chime in on this topic...I have several sites that I have to
maintain (I do government work) that I did not write.  They were written using
layers and HEAVY on javascript.  When Netscape 6 was loaded on many of the new
machines, the sites stopped working.  I visited many javascript sites asking
about Netscape 6 and they all told me that NS 6 is awfull.  Based on what all of
you are saying, you love it.  I am part of a team that sets standards for web
development (for my organization).  We are looking at NS6 and what we should do
about it.  I value this lists opinion and would like to hear from you.  Do any
of you have problems using NS6 and javascript?  

Thanks,


Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Output to a phrase

2002-02-20 Thread Mark Leder

I have a database with a number of citations. Each record
 contains 
one citation.  The citations can vary in word length from maybe
 20 
words to well over 100 words.  In each citation is a word phrase
 
named keywords: (note the colon).  The phrase keywords:
 occurs at 
a different point within each citation (however only occurring
 once 
per citation).

What I want to do is something similar to the following:

cfoutput#Left(query.field, 20)# /cfoutput.  

However, instead of displaying just the first 20 characters in
 this 
example, I want to display all words up to just before the phrase
 
keywords: - even though each citation will have a different 
quantity of words prior to the phrase keywords:

Is there any way to do this?

Thanks in advance for your help.
-- 
Mark Leder, [EMAIL PROTECTED] on 2/20/2002

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Output to a phrase

2002-02-20 Thread Howie Hamlin

something like:

left(query.field,findnocase(keywords:,query.field)-1)

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
 Find out how iMS Stacks up to the competition: 
http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: Mark Leder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 10:19 AM
Subject: Output to a phrase


 I have a database with a number of citations. Each record
  contains
 one citation.  The citations can vary in word length from maybe
  20
 words to well over 100 words.  In each citation is a word phrase

 named keywords: (note the colon).  The phrase keywords:
  occurs at
 a different point within each citation (however only occurring
  once
 per citation).

 What I want to do is something similar to the following:

 cfoutput#Left(query.field, 20)# /cfoutput.

 However, instead of displaying just the first 20 characters in
  this
 example, I want to display all words up to just before the phrase

 keywords: - even though each citation will have a different
 quantity of words prior to the phrase keywords:

 Is there any way to do this?

 Thanks in advance for your help.
 --
 Mark Leder, [EMAIL PROTECTED] on 2/20/2002

 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Jon Hall

You are opening a can of worms here I believe, but Netscape has no problem
with Javascript. Especially since Netscape invented Javascript, I imagine
they can do whatever they want with it. It's web site authors that write
code for proprietary DOM's (read: IE) that are the reason some sites do not
work.

I view Netscape 6 compatibility as forwards compatibility, as do many
others. We are finally moving towards standards and Netscape 6.x is on the
forefront of the standards movement. I'd also just like to mention that
Netscape 6.0 or 6.2 are really not representative of what Netscape 6.x will
be by April. Whatever the next version will be numbered, it's going to knock
the socks off of a lot of people...

jon
- Original Message -
From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 10:10 AM
Subject: RE: SOT: Is the Netscape browser still a consideration?


 I would like to chime in on this topic...I have several sites that I have
to
 maintain (I do government work) that I did not write.  They were written
using
 layers and HEAVY on javascript.  When Netscape 6 was loaded on many of the
new
 machines, the sites stopped working.  I visited many javascript sites
asking
 about Netscape 6 and they all told me that NS 6 is awfull.  Based on what
all of
 you are saying, you love it.  I am part of a team that sets standards for
web
 development (for my organization).  We are looking at NS6 and what we
should do
 about it.  I value this lists opinion and would like to hear from you.  Do
any
 of you have problems using NS6 and javascript?

 Thanks,

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



bit mask info

2002-02-20 Thread Kelly Tetterton

I'm looking for presentations/information/examples regarding bit masks. I've
looked through the archives, and two presentations are mentioned, but
neither seem available any longer. Can anyone point me in the right
direction? thanks --

Kelly Tetterton
Technical Lead, Macromedia Certified ColdFusion Developer
duoDesign, eBusiness Architects
Internet design, technology and online marketing

847-491-3000 main   | [EMAIL PROTECTED]
847-491-3100 fax| www.duoDesign.com
847-491-7125 direct| www.Nexiv.com
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Flash Graphing

2002-02-20 Thread Justin Waldrip

I have created a simple flash graph tag which is in the developer
exchange as CF_FlashGraphTag. You can see examples of this tag at
www.studio896.com, the links on the site don't work for downloading. I
took the look of a Corda bar graph and made it into a tag. My goal was
to create new more advanced versions of the tag but just haven't had
time. If you would like the source flash file I would be happy to open
this open to the community. This way maybe we can get some decent
looking flash graphs without the cost of a server solution.

Justin Waldrip
[EMAIL PROTECTED]

-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 8:15 AM
To: CF-Talk
Subject: RE: CF  Flash Graphing

Yeah, it is actually pretty easy to make graphs in Flash. I have some 
good
libraries I can show you, contact me off list for details. 

You may wish to consider the value of building this yourself over 
purchasing
a commercial package (or upgrading to CF 5). I've found the cost of
building, testing, debuging, and deploying a good Flash graphing 
solution
(*especially if you want it to have drill down capability) generally 
exceeds
the price of buying one of the good ones that are already out there. 

My personal fave is the one from Corda, which just beats CF_Graph in so 
many
ways it is not funny. 

http://www.corda.com

For the record, I am not employed by Corda, just a happy user. 

Mike

-Original Message-
From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 4:04 PM
To: CF-Talk
Subject: CF  Flash Graphing


Does any one know of a way to make graphs with Flash? I can get the
values into Flash but how do I make the graphs? They need to be
something like what you get in Excel. Any ideas?

Thanks

Phillip Broussard
Tracker Marine Group
417-873-5957




__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Output to a phrase

2002-02-20 Thread BEN MORRIS

cfwset x = find(keywords:, query.field)
cfoutput#Left(query.field, x)#/cfoutput.

 Mark Leder [EMAIL PROTECTED] 02/20/02 10:19AM 
I have a database with a number of citations. Each record
 contains 
one citation.  The citations can vary in word length from maybe
 20 
words to well over 100 words.  In each citation is a word phrase
 
named keywords: (note the colon).  The phrase keywords:
 occurs at 
a different point within each citation (however only occurring
 once 
per citation).

What I want to do is something similar to the following:

cfoutput#Left(query.field, 20)# /cfoutput.  

However, instead of displaying just the first 20 characters in
 this 
example, I want to display all words up to just before the phrase
 
keywords: - even though each citation will have a different 
quantity of words prior to the phrase keywords:

Is there any way to do this?

Thanks in advance for your help.
-- 
Mark Leder, [EMAIL PROTECTED] on 2/20/2002


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Robert Everland

This gets discussed every couple of months. Everyone will decide to do what
they want to do. My little tidbit I mention every couple months is this. Aol
bought Netscape for a reason. It's not becuase it had a cool name. They plan
on doing something with it one day, and if the Microsoft AOL battle keeps up
the way you do and us developers are not ready, the people who plan to be
cross browser compatible will be the ones with the leg up. It can't hurt to
fix your code now, and it will give you more experience. Some jobs say hey
screw netscape users, others say we need to keep it up. No one will win
until it's too late. If all of a sudden 30 million internet users who once
used IE5 with thier packaged software started using Netscape 6, how would
your site work?

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 10:27 AM
To: CF-Talk
Subject: Re: SOT: Is the Netscape browser still a consideration?


You are opening a can of worms here I believe, but Netscape has no problem
with Javascript. Especially since Netscape invented Javascript, I imagine
they can do whatever they want with it. It's web site authors that write
code for proprietary DOM's (read: IE) that are the reason some sites do not
work.

I view Netscape 6 compatibility as forwards compatibility, as do many
others. We are finally moving towards standards and Netscape 6.x is on the
forefront of the standards movement. I'd also just like to mention that
Netscape 6.0 or 6.2 are really not representative of what Netscape 6.x will
be by April. Whatever the next version will be numbered, it's going to knock
the socks off of a lot of people...

jon
- Original Message -
From: Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 10:10 AM
Subject: RE: SOT: Is the Netscape browser still a consideration?


 I would like to chime in on this topic...I have several sites that I have
to
 maintain (I do government work) that I did not write.  They were written
using
 layers and HEAVY on javascript.  When Netscape 6 was loaded on many of the
new
 machines, the sites stopped working.  I visited many javascript sites
asking
 about Netscape 6 and they all told me that NS 6 is awfull.  Based on what
all of
 you are saying, you love it.  I am part of a team that sets standards for
web
 development (for my organization).  We are looking at NS6 and what we
should do
 about it.  I value this lists opinion and would like to hear from you.  Do
any
 of you have problems using NS6 and javascript?

 Thanks,


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF Access - Select Distinct vs Memo Fields

2002-02-20 Thread David Schmidt

Hi All,

I have a bit of code that works from one server but not another.  The SQL
says Select Distinct description from SomeTable.  The database is
Microsoft Access on both servers (I mean one is a copy of the other, no
import/export of data was performed).  On one server, CF5 says that I can't
use a memo field (description) with a unique select (distinct).  Yet on the
other server (also CF5), I don't get the error.

Any Ideas?  I'm thinking that it may have to do with the MDAC that is
running, but also don't remember how to check that version.  BTW, both are
on NT boxes.


David

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Forum Solutions

2002-02-20 Thread Watson, Nicholas

I'm looking for a forum solution that is ColdFusion and has similar
functionality to ChatSpace's WebBoard. These features would include public
and private conferences, public and private threads, and the ability to
participate in a conference/thread via email. I would like to migrate to a
ColdFusion application so that I can customize the functionality. Does
anyone know where I can find such a system?

Thanks,

Nicholas W. Watson
Software Engineer
Concurrent Technologies Corporation
Email: [EMAIL PROTECTED]
Phone: (814) 269-2653
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Output to a phrase

2002-02-20 Thread Dave Hannum

Something like: (untested)

Replace(ListFirst(citation, :), keywords, ALL)

Dave


- Original Message -
From: Mark Leder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 10:19 AM
Subject: Output to a phrase


I have a database with a number of citations. Each record
 contains
one citation.  The citations can vary in word length from maybe
 20
words to well over 100 words.  In each citation is a word phrase

named keywords: (note the colon).  The phrase keywords:
 occurs at
a different point within each citation (however only occurring
 once
per citation).

What I want to do is something similar to the following:

cfoutput#Left(query.field, 20)# /cfoutput.

However, instead of displaying just the first 20 characters in
 this
example, I want to display all words up to just before the phrase

keywords: - even though each citation will have a different
quantity of words prior to the phrase keywords:

Is there any way to do this?

Thanks in advance for your help.
--
Mark Leder, [EMAIL PROTECTED] on 2/20/2002


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOT: Is the Netscape browser still a consideration?

2002-02-20 Thread Jeffry Houser


Most of the time it's not up to the developer anyways.  We go by what
the client wants on their site.

If they say they want a flash intro, so be it.

Anyways, I couldn't imagine a web without pictures and flash and dhtml,
it would be like a magazine with nothing but text inside.

  It sounds like heaven..

  I surfed on a VMS Vax system using the lynx browser in my college 
years.  It didn't support in-line images.  It was wicked fast.
  I used to surf in Navigator 3 with images off.  Then people started using 
things like graphical navigation ( with no alt tags ) and...  well, it 
makes sites impossible to navigate.



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: bit mask info

2002-02-20 Thread Cameron Childress

 I'm looking for presentations/information/examples regarding bit
 masks.

Not a presentation, but if you slap this into a template and run it, you'll
have a quick guide to all the bit functions and what they do.  I print it
out and keep it by my computer in case I forget what one of the functions
does.


FONT SIZE=+2
!--- create the initial integers. Doing it this way helps you visualize
what your int looks like in binary form  ---
CFSET x = InputBaseN('00110001', 2)
CFSET y = InputBaseN('00111000', 2)
CFSET y = 2 
!--- position guide ---
   10987654321098765432109876543210BR

CFOUTPUT
!--- Read the bit values back out one by one to display the int in
binary ---
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(x, i, 1)#/CFLOOP
= x = (#x#)BR
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(y, i, 1)#/CFLOOP
= y = (#y#)BR
BR
!--- Do different bit operations BitAnd(), BitOr, etc, and see what they do
to the values of the integers and bit positions. ---
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitAnd(x, y), i,
1)#/CFLOOP = BitAnd(x, y) = #BitAnd(x, y)#BR
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitOr(x, y), i,
1)#/CFLOOP = BitOr(x, y) = #BitOr(x, y)#BR
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitXOr(x, y), i,
1)#/CFLOOP = BitXOr(x, y) = #BitXOr(x, y)#BR
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitNot(x), i,
1)#/CFLOOP = BitNot(x) = #BitNot(x)#BR
CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitNot(y), i,
1)#/CFLOOP = BitNot(y) = #BitNot(y)#BR
/CFOUTPUT



Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software





 -Original Message-
 From: Kelly Tetterton [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 10:27 AM
 To: CF-Talk
 Subject: bit mask info


 I'm looking for presentations/information/examples regarding bit
 masks. I've
 looked through the archives, and two presentations are mentioned, but
 neither seem available any longer. Can anyone point me in the right
 direction? thanks --

 Kelly Tetterton
 Technical Lead, Macromedia Certified ColdFusion Developer
 duoDesign, eBusiness Architects
 Internet design, technology and online marketing

 847-491-3000 main | [EMAIL PROTECTED]
 847-491-3100 fax  | www.duoDesign.com
 847-491-7125 direct| www.Nexiv.com
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: bit mask info

2002-02-20 Thread Cameron Childress

Oh, remove the CFSET y = 2  on line 6, I had that in there when debugging
something...

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software





 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 10:40 AM
 To: CF-Talk
 Subject: RE: bit mask info


  I'm looking for presentations/information/examples regarding bit
  masks.

 Not a presentation, but if you slap this into a template and run
 it, you'll
 have a quick guide to all the bit functions and what they do.  I print it
 out and keep it by my computer in case I forget what one of the functions
 does.


 FONT SIZE=+2
 !--- create the initial integers. Doing it this way helps you visualize
 what your int looks like in binary form  ---
 CFSET x = InputBaseN('00110001', 2)
 CFSET y = InputBaseN('00111000', 2)
 CFSET y = 2 
   !--- position guide ---
10987654321098765432109876543210BR

 CFOUTPUT
 !--- Read the bit values back out one by one to display the int in
 binary ---
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(x, i,
 1)#/CFLOOP
 = x = (#x#)BR
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(y, i,
 1)#/CFLOOP
 = y = (#y#)BR
 BR
 !--- Do different bit operations BitAnd(), BitOr, etc, and see
 what they do
 to the values of the integers and bit positions. ---
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitAnd(x, y), i,
 1)#/CFLOOP = BitAnd(x, y) = #BitAnd(x, y)#BR
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitOr(x, y), i,
 1)#/CFLOOP = BitOr(x, y) = #BitOr(x, y)#BR
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitXOr(x, y), i,
 1)#/CFLOOP = BitXOr(x, y) = #BitXOr(x, y)#BR
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitNot(x), i,
 1)#/CFLOOP = BitNot(x) = #BitNot(x)#BR
 CFLOOP INDEX=i FROM=31 TO=0 STEP=-1#BitMaskRead(BitNot(y), i,
 1)#/CFLOOP = BitNot(y) = #BitNot(y)#BR
 /CFOUTPUT


 
 Cameron Childress
 elliptIQ Inc.
 p.770.460.1035.232
 f.770.460.0963
 --
 http://www.neighborware.com
 America's Leading Community Network Software





  -Original Message-
  From: Kelly Tetterton [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, February 20, 2002 10:27 AM
  To: CF-Talk
  Subject: bit mask info
 
 
  I'm looking for presentations/information/examples regarding bit
  masks. I've
  looked through the archives, and two presentations are mentioned, but
  neither seem available any longer. Can anyone point me in the right
  direction? thanks --
 
  Kelly Tetterton
  Technical Lead, Macromedia Certified ColdFusion Developer
  duoDesign, eBusiness Architects
  Internet design, technology and online marketing
 
  847-491-3000 main   | [EMAIL PROTECTED]
  847-491-3100 fax| www.duoDesign.com
  847-491-7125 direct| www.Nexiv.com
 
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Forum Solutions

2002-02-20 Thread David Schmidt

At 10:33 AM 2/20/2002 -0500, Watson, Nicholas wrote:
I'm looking for a forum solution that is ColdFusion and has similar
functionality to ChatSpace's WebBoard. These features would include public
and private conferences, public and private threads, and the ability to
participate in a conference/thread via email. I would like to migrate to a
ColdFusion application so that I can customize the functionality. Does
anyone know where I can find such a system?
We have been happy with e-Zone Media's FuseTalk product. See:

 http://www.e-zonemedia.com/fusetalk

It's a good app, SYS-CON Media and Macromedia use it. It was actually 
selected to replace Allaire Forums and powers the MM Support Forums for CF.

Disclaimer -- I do not work for e-Zone Media, but am a happy customer.

Cheers,

..David

---
Kill a spammer for Jesus! (...slowly, with a nail-gun.)
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFGRID - Broswer problem - CFAS problem?

2002-02-20 Thread Matthew R. Small

Hi everybody -
With all of this browser talk, I am having a problem with my
boss's computer right now.
I have a CFGRID setup that he uses to input data.  It refuses to
come up on his machine using IE6, Opera, or anything else.  It comes up
fine on my machine.  The kicker:  I changed servers the other day.  The
old server's CFGRID page works just fine on his machine in all browsers.
The grid comes up great and works.  IN opera, the message that I got was
:Applet not loaded.  In IE it's a blank area.  Any ideas???

Thank you,
Matthew Small
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFGRID - Broswer problem - CFAS problem?

2002-02-20 Thread Craig Dudley

Re-install the java plugin on his machine.

http://java.sun.com/getjava/download.html

Should fix it.

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 15:57
To: CF-Talk
Subject: CFGRID - Broswer problem - CFAS problem?


Hi everybody -
With all of this browser talk, I am having a problem with my
boss's computer right now.
I have a CFGRID setup that he uses to input data.  It refuses to
come up on his machine using IE6, Opera, or anything else.  It comes up
fine on my machine.  The kicker:  I changed servers the other day.  The
old server's CFGRID page works just fine on his machine in all 
browsers.
The grid comes up great and works.  IN opera, the message that I got 
was
:Applet not loaded.  In IE it's a blank area.  Any ideas???

Thank you,
Matthew Small

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF Server / IIS / SQL Server

2002-02-20 Thread Tangorre, Michael T.

Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works. 

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFGRID - Broswer problem - CFAS problem?

2002-02-20 Thread Matthew R. Small

Thanks for that link, but it still did not work. I think that the CFAS
server is not sending the applet somehow... I'm not sure of how this
works, but the message that I get in the java window is:

java.lang.ClassNotFoundException: allaire.controls.cfGridFormApplet

I'm using win2Kserver and CF4.5.1 service pack 2

-Thank you
Matt Small





-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 10:45 AM
To: CF-Talk
Subject: RE: CFGRID - Broswer problem - CFAS problem?

Re-install the java plugin on his machine.

http://java.sun.com/getjava/download.html

Should fix it.

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 15:57
To: CF-Talk
Subject: CFGRID - Broswer problem - CFAS problem?


Hi everybody -
With all of this browser talk, I am having a problem with my
boss's computer right now.
I have a CFGRID setup that he uses to input data.  It refuses to
come up on his machine using IE6, Opera, or anything else.  It comes up
fine on my machine.  The kicker:  I changed servers the other day.  The
old server's CFGRID page works just fine on his machine in all 
browsers.
The grid comes up great and works.  IN opera, the message that I got 
was
:Applet not loaded.  In IE it's a blank area.  Any ideas???

Thank you,
Matthew Small


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: bit mask info

2002-02-20 Thread Jim Priest

Check out Hal Helms site:

http://halhelms.com/writings/ProposedSecurityModel.pdf

http://www.halhelms.com/index.cfm?fuseaction=newsletters.jul2000

Both of these cover using the bitmask functions in a security
context...

jim

On Wednesday, February 20, 2002, 10:26:33 AM, Kelly wrote:

KT I'm looking for presentations/information/examples regarding bit masks. I've
KT looked through the archives, and two presentations are mentioned, but
KT neither seem available any longer. Can anyone point me in the right
KT direction? thanks --
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFGRID - Broswer problem - CFAS problem?

2002-02-20 Thread Matthew R. Small

OK, I've solved the problem... CFIDE needs to be in the same directory
as your webserver root - which I didn't have.

The answer was in the knowledgebase - article 11904
http://www.macromedia.com/v1/Handlers/index.cfm?ID=11904Method=Full

Thanks for your help.

- Matt Small

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 11:10 AM
To: CF-Talk
Subject: RE: CFGRID - Broswer problem - CFAS problem?

Thanks for that link, but it still did not work. I think that the CFAS
server is not sending the applet somehow... I'm not sure of how this
works, but the message that I get in the java window is:

java.lang.ClassNotFoundException: allaire.controls.cfGridFormApplet

I'm using win2Kserver and CF4.5.1 service pack 2

-Thank you
Matt Small





-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 10:45 AM
To: CF-Talk
Subject: RE: CFGRID - Broswer problem - CFAS problem?

Re-install the java plugin on his machine.

http://java.sun.com/getjava/download.html

Should fix it.

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 15:57
To: CF-Talk
Subject: CFGRID - Broswer problem - CFAS problem?


Hi everybody -
With all of this browser talk, I am having a problem with my
boss's computer right now.
I have a CFGRID setup that he uses to input data.  It refuses to
come up on his machine using IE6, Opera, or anything else.  It comes up
fine on my machine.  The kicker:  I changed servers the other day.  The
old server's CFGRID page works just fine on his machine in all 
browsers.
The grid comes up great and works.  IN opera, the message that I got 
was
:Applet not loaded.  In IE it's a blank area.  Any ideas???

Thank you,
Matthew Small



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFGRID - Broswer problem - CFAS problem?

2002-02-20 Thread Craig Dudley

Try copying the dir structure where the applets are stored in cf server 
over
to your site,

something like /cfide/..

And copy the .jar files into that dir, that's a bit of a drity hack but 
it's
worked for me once or twice.

Craig.

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 16:10
To: CF-Talk
Subject: RE: CFGRID - Broswer problem - CFAS problem?


Thanks for that link, but it still did not work. I think that the CFAS
server is not sending the applet somehow... I'm not sure of how this
works, but the message that I get in the java window is:

java.lang.ClassNotFoundException: allaire.controls.cfGridFormApplet

I'm using win2Kserver and CF4.5.1 service pack 2

-Thank you
Matt Small





-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 10:45 AM
To: CF-Talk
Subject: RE: CFGRID - Broswer problem - CFAS problem?

Re-install the java plugin on his machine.

http://java.sun.com/getjava/download.html

Should fix it.

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 15:57
To: CF-Talk
Subject: CFGRID - Broswer problem - CFAS problem?


Hi everybody -
With all of this browser talk, I am having a problem with my
boss's computer right now.
I have a CFGRID setup that he uses to input data.  It refuses to
come up on his machine using IE6, Opera, or anything else.  It comes up
fine on my machine.  The kicker:  I changed servers the other day.  The
old server's CFGRID page works just fine on his machine in all 
browsers.
The grid comes up great and works.  IN opera, the message that I got 
was
:Applet not loaded.  In IE it's a blank area.  Any ideas???

Thank you,
Matthew Small



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Server / IIS / SQL Server

2002-02-20 Thread Mark A. Kruger - CFG

A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Server / IIS / SQL Server

2002-02-20 Thread Tangorre, Michael T.

When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)




__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



R: Strip from string

2002-02-20 Thread phumes1

Hi,

I have the following text which I'm passed as a URL.filename

d:\dir1\dir2\dir3\test.txt

How can I strip the test.txt from the above line?

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Server / IIS / SQL Server

2002-02-20 Thread Mark A. Kruger - CFG

There is no such thing as the server domain - even though the login screen
leads you to believe there is - there is only a domain and a local
account (not the same as the local system account).  If you use a local
account, you will need to share permissions from one stand alone server to
another - which is adding rather than removing complexity.  The idea behind
a domain acount is to simplify the process.  Create an account and carefully
assign the resources you want it to have - then use it where you need to.
If you end up with too many users, you can create groups instead - also
useful.  But it appears a single user would suffice for what you have in
mind.

Mark

P.S. - I suggest the book Mastering Windows 2000 Server - Mark Minasi -
it's readable and may help you sort this out.



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:21 AM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)





__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF-Talk-list V1 #141

2002-02-20 Thread Rick Walters

No no, thanks for the clarification.  I didn't set up the sequences when I
was working with Oracle.  I'm always happy to know more.  

Good Fortune,
Rick Walters
Webmaster, Davita Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848

-Original Message-
From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 11:26 AM
To: CF-Talk
Subject: Re: CF-Talk-list V1 #141

 --
 Date: Fri, 15 Feb 2002 10:47:47 -0500
 From: Rick Walters [EMAIL PROTECTED]

[snip]

 Oracle has a nifty little table called DUAL.  It's a system table that
will
 always have only one row.  So, if you Select nextval from Dual you will
 have a unique id you can then store in a variable and use for inserts.  If
 you use this for all your tables, then your ID values will be different in
 all of your tables, an interesting thing to play with in joins or table
 merges.  No record will ever have the same ID.  Beware, I have heard of
 resetting the Dual Table.  Never had it happen to me.

This is completely off-base.  Instead of using the Identity feature which
SQL Server has (which is a counter attached to a particular column on a
table in the DB), Oracle has separate objects called Sequences.  These are
basically counter objects with extreme flexibility. Someone (usually a DBA,
but it's trivial to do so) must set up a sequence for you to use before you
can actually do something like: SELECT thisSq.NEXTVAL FROM SYS.DUAL.
These sequences do not magically appear.

Having the new row-ids selected explicitly from a separate table avoids the
potential ID contention issue which SQL Server has due to the fact the IDs
are implicit, and a long data insert sometimes causes SQL Server to give two
requests the same ID. (One way to avoid that is insert a NULL row first, get
the ID, and then do an update on that row).

There is nothing special about the so-called DUAL table. It's simply a dummy
table.  You could just as easily select the next value in a sequence from
any table (or the sysdate for that matter, as in SELECT sysdate FROM
SYS.DUAL).  Doing it from DUAL makes more sense since it is ever-present
(and locks you into using Oracle, hahaha :).

No offense Rick.  I just wanted to ensure people knew what exactly the deal
was with Sequences in Oracle.

Cheers,

Kreig


FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Strip from string

2002-02-20 Thread Pascal Peters

getdirectoryfrompath(d:\dir1\dir2\dir3\test.txt)

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 februari 2002 17:51
To: CF-Talk
Subject: R: Strip from string


Hi,

I have the following text which I'm passed as a URL.filename

d:\dir1\dir2\dir3\test.txt

How can I strip the test.txt from the above line?


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Refresh Window

2002-02-20 Thread Jones, Becky

Is there a way to Automatically refresh a window?  
I have a page that has a pop-up window.  When you make changes on that fo
rm (in the pop-up windown) when i click submit...i want the window undern
eath to reflect the changes.  the only way it does right now is if i hit 
the refresh button.  is there a way to do this without hitting the refres
h button?
thanks for your help.
bec.
* 
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information. If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Refresh Window

2002-02-20 Thread Clint Tredway

I use this alot:
opener.location = opener.location;

-- Original Message --
from: Jones, Becky [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 20 Feb 2002 11:58:24 -0500

Is there a way to Automatically refresh a window?  
I have a page that has a pop-up window.  When you make changes on that fo
rm (in the pop-up windown) when i click submit...i want the window undern
eath to reflect the changes.  the only way it does right now is if i hit 
the refresh button.  is there a way to do this without hitting the refres
h button?
thanks for your help.
bec.
* 
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information. If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Refresh Window

2002-02-20 Thread kelly

Try this:
script
 !-- Hide script from old browsers
 function closewindow(newUrl)
 { window.opener.document.location = newUrl
 window.close();
 }
 // End hiding script from old browsers--
/script

a href=someurl.htm target=content
onClick=javascript:closewindow('someurl.htm')Image/A



- Original Message -
From: Jones, Becky [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 9:58 AM
Subject: Refresh Window


 Is there a way to Automatically refresh a window?
 I have a page that has a pop-up window.  When you make changes on that fo
 rm (in the pop-up windown) when i click submit...i want the window undern
 eath to reflect the changes.  the only way it does right now is if i hit
 the refresh button.  is there a way to do this without hitting the refres
 h button?
 thanks for your help.
 bec.
 *
 This e-mail, including any attachments, is intended for the
 receipt and use by the intended addressee(s), and may contain
 confidential and privileged information. If you are not an intended
 recipient of this e-mail, you are hereby notified that any unauthorized
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Refresh Window

2002-02-20 Thread Critz

oi Becky!!

window.opener.location.reload(true)


-- 
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion


-
Wednesday, February 20, 2002, 11:58:24 AM, you wrote:

JB Is there a way to Automatically refresh a window?  
JB I have a page that has a pop-up window.  When you make changes on that fo
JB rm (in the pop-up windown) when i click submit...i want the window undern
JB eath to reflect the changes.  the only way it does right now is if i hit 
JB the refresh button.  is there a way to do this without hitting the refres
JB h button?
JB thanks for your help.
JB bec.
JB * 
JB This e-mail, including any attachments, is intended for the 
JB receipt and use by the intended addressee(s), and may contain 
JB confidential and privileged information. If you are not an intended 
JB recipient of this e-mail, you are hereby notified that any unauthorized 
JB 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF Studio settings in win2k

2002-02-20 Thread Brendan Avery

my friend had to delete his win2k user profile from his system and now his
font and other customization settings (like tag completion) have reset to
normal.  does anyone know how these settings are stored?  i'm guessing
they're in the registry.  just wanted to check if anyone here knew.  thx.
-brendan avery 2.0 - [EMAIL PROTECTED]
310.779.2211 - santa monica, california
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Server / IIS / SQL Server

2002-02-20 Thread Tangorre, Michael T.

Thanks Mark.

I am looking into getting some books to help me btter understand this
administration stuff.
Should make for some good reading over spring break. Do you recommend any
other books?

Thanks,

Mike


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:52 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


There is no such thing as the server domain - even though the login screen
leads you to believe there is - there is only a domain and a local
account (not the same as the local system account).  If you use a local
account, you will need to share permissions from one stand alone server to
another - which is adding rather than removing complexity.  The idea behind
a domain acount is to simplify the process.  Create an account and carefully
assign the resources you want it to have - then use it where you need to.
If you end up with too many users, you can create groups instead - also
useful.  But it appears a single user would suffice for what you have in
mind.

Mark

P.S. - I suggest the book Mastering Windows 2000 Server - Mark Minasi -
it's readable and may help you sort this out.



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:21 AM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)






__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: 

OT:Looking for Jobs in Orange Co California

2002-02-20 Thread Douglas Brown

Does anyone know of any CF Jobs in Orange County California? I would 
even settle for web designer etc.







There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Strip from string

2002-02-20 Thread Mike Townend

You could use...

URL.filename = ListDeleteAt(URL.filename, ListLen(URL.filename, \),
\)

HTH



-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]] 
Sent: 20 February 2002 16:51
To: CF-Talk
Subject: R: Strip from string


Hi,

I have the following text which I'm passed as a URL.filename

d:\dir1\dir2\dir3\test.txt

How can I strip the test.txt from the above line?


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Server / IIS / SQL Server

2002-02-20 Thread Mark A. Kruger - CFG

Mike

Well - there are a host of books out there on Win2k or NT administration.
Most of them are pretty good.  Unless you want to be an expert on the topic
(an MCSE for example) you really just need a reference - minasi's book is a
great comprehensive text and he knows a lot about the Nuances MS products -
so he may be all you need.  And at 1500 pages I'm guessing it will be quite
enough to get through in one spring break - in between bears and broa...
uh women ha.

-mk

Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
..no more brochures!



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 9:01 AM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


Thanks Mark.

I am looking into getting some books to help me btter understand this
administration stuff.
Should make for some good reading over spring break. Do you recommend any
other books?

Thanks,

Mike


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:52 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


There is no such thing as the server domain - even though the login screen
leads you to believe there is - there is only a domain and a local
account (not the same as the local system account).  If you use a local
account, you will need to share permissions from one stand alone server to
another - which is adding rather than removing complexity.  The idea behind
a domain acount is to simplify the process.  Create an account and carefully
assign the resources you want it to have - then use it where you need to.
If you end up with too many users, you can create groups instead - also
useful.  But it appears a single user would suffice for what you have in
mind.

Mark

P.S. - I suggest the book Mastering Windows 2000 Server - Mark Minasi -
it's readable and may help you sort this out.



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:21 AM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people 

RE: CF Studio settings in win2k

2002-02-20 Thread Dave Watts

 my friend had to delete his win2k user profile from his 
 system and now his font and other customization settings 
 (like tag completion) have reset to normal. does anyone 
 know how these settings are stored? i'm guessing they're 
 in the registry.

You are correct, sir. They're stored in the HKEY_USERS hive, on a per-user
basis. You can use the HKEY_CURRENT_USER shortcut if you're logged in as the
appropriate user. For CF Studio 4.x, they're under HKCU\Software\Allaire.
For CF Studio 5, they're under HKCU\Software\Macromedia\.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



FTP vs HTTP

2002-02-20 Thread Rick Walters

Hi Everyone,
 
I'm searching for opinions and perhaps metrics that might suggest when it is
better to channel downloads using FTP vs HTTP from a single web server
environment.  Essentially, we have a large file (35M) that a significant
number of people must download monthly.  The question is: What advantage
could we gain by using an FTP link vs a HTTP link?  Opening an anonymous
FTP channel is potentially more risky from a security standpoint.  But, we
are wondering if channeling this traffic on another port would possibly free
up port 40 and result in a performance gain for the steady flow of *.cfm
requests.  
 
Anyone out there with an opinion please chime in.  Or, if you know where I
could find more information on this topic, send me a note.  Thanks.
 
Good Fortune,
Rick Walters
Webmaster, Davita Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848
 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Dave Carabetta

I am working in a CF 4.5 SP2 on Solaris environment.

I have a query which I run via TOAD and SQL Plus which comes back in 700 ms 
at most. But when I run it through a CF template, it takes over 50 seconds 
on average. I have tried connecting to my database via both ODBC and the 
Merant Oracle driver, and nothing has improved. I ran a detailed Explain 
Plan analysis on the query and tuned the proper indexes with my DBA. But 
that hasn't helped either. I also use cfqueryparam religiously, and while 
it works wonders on my other queries, this one is still agonizingly slow.

Can anybody point me in a direction to try and track this down?

Thanks,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Kwang Suh

Do you have a large recordset coming back?  If so, try playing around
 with
the blockfactor attribute.  Also, try moving the query to a stored pr
oc, and
see if that makes a difference.

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 10:44 AM
To: CF-Talk
Subject: Query Execution Time: CF vs. SQL Plus


I am working in a CF 4.5 SP2 on Solaris environment.

I have a query which I run via TOAD and SQL Plus which comes back in 
700 ms
at most. But when I run it through a CF template, it takes over 50 se
conds
on average. I have tried connecting to my database via both ODBC and 
the
Merant Oracle driver, and nothing has improved. I ran a detailed Expl
ain
Plan analysis on the query and tuned the proper indexes with my DBA. 
But
that hasn't helped either. I also use cfqueryparam religiously, and
 while
it works wonders on my other queries, this one is still agonizingly s
low.

Can anybody point me in a direction to try and track this down?

Thanks,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
_
_
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: FTP vs HTTP

2002-02-20 Thread Howie Hamlin

For a file like that I would definitely use FTP - that is what FTP is for.  Most 
modern ftp servers and clients support resume for
one thing (only http/1.1 supports resume and I'm not sure how many web clients support 
it).  And, although there may or may not be a
risk using anonymous access to the ftp server it is no more or less of a security risk 
when providing anonymous http access IMHO.

Regards,

Howie

- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 12:37 PM
Subject: FTP vs HTTP


 Hi Everyone,

 I'm searching for opinions and perhaps metrics that might suggest when it is
 better to channel downloads using FTP vs HTTP from a single web server
 environment.  Essentially, we have a large file (35M) that a significant
 number of people must download monthly.  The question is: What advantage
 could we gain by using an FTP link vs a HTTP link?  Opening an anonymous
 FTP channel is potentially more risky from a security standpoint.  But, we
 are wondering if channeling this traffic on another port would possibly free
 up port 40 and result in a performance gain for the steady flow of *.cfm
 requests.

 Anyone out there with an opinion please chime in.  Or, if you know where I
 could find more information on this topic, send me a note.  Thanks.

 Good Fortune,
 Rick Walters
 Webmaster, Davita Laboratory Services
 Office: (800) 604-5227
 Cell: (407) 491-9848


 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Mark A. Kruger - CFG

Ditto to howie - http servers and processes are also usually configured to
timeout long running request in order to enhance server performance and
overall user experience.  FTP is a better choice.

Mark

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 9:55 AM
To: CF-Talk
Subject: Re: FTP vs HTTP


For a file like that I would definitely use FTP - that is what FTP is for.
Most modern ftp servers and clients support resume for
one thing (only http/1.1 supports resume and I'm not sure how many web
clients support it).  And, although there may or may not be a
risk using anonymous access to the ftp server it is no more or less of a
security risk when providing anonymous http access IMHO.

Regards,

Howie

- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 12:37 PM
Subject: FTP vs HTTP


 Hi Everyone,

 I'm searching for opinions and perhaps metrics that might suggest when it
is
 better to channel downloads using FTP vs HTTP from a single web server
 environment.  Essentially, we have a large file (35M) that a significant
 number of people must download monthly.  The question is: What advantage
 could we gain by using an FTP link vs a HTTP link?  Opening an anonymous
 FTP channel is potentially more risky from a security standpoint.  But, we
 are wondering if channeling this traffic on another port would possibly
free
 up port 40 and result in a performance gain for the steady flow of *.cfm
 requests.

 Anyone out there with an opinion please chime in.  Or, if you know where I
 could find more information on this topic, send me a note.  Thanks.

 Good Fortune,
 Rick Walters
 Webmaster, Davita Laboratory Services
 Office: (800) 604-5227
 Cell: (407) 491-9848




__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Alex

Does it take 50 seconds to run the query or 50 seconds to load the page?
Are you connecting to the DB using the same driver? How about your
network?

On Wed, 20 Feb 2002, Dave Carabetta wrote:

 I am working in a CF 4.5 SP2 on Solaris environment.
 
 I have a query which I run via TOAD and SQL Plus which comes back in 700 
ms 
 at most. But when I run it through a CF template, it takes over 50 second
s 
 on average. I have tried connecting to my database via both ODBC and the
 
 Merant Oracle driver, and nothing has improved. I ran a detailed Explain
 
 Plan analysis on the query and tuned the proper indexes with my DBA. But
 
 that hasn't helped either. I also use cfqueryparam religiously, and whi
le 
 it works wonders on my other queries, this one is still agonizingly slow.
 
 Can anybody point me in a direction to try and track this down?
 
 Thanks,
 Dave.
 
 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Rick Walters

Good Suggestions, I agree that FTP is a better way to push large files.
Problem is, I need to justify opening an anonymous access.  The idea 
that it
might boost performance would be a plus, but I'm having trouble finding
comparisons.  

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 3:39 PM
To: CF-Talk
Subject: RE: FTP vs HTTP

Ditto to howie - http servers and processes are also usually configured 
to
timeout long running request in order to enhance server performance 
and
overall user experience.  FTP is a better choice.

Mark

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 9:55 AM
To: CF-Talk
Subject: Re: FTP vs HTTP


For a file like that I would definitely use FTP - that is what FTP is 
for.
Most modern ftp servers and clients support resume for
one thing (only http/1.1 supports resume and I'm not sure how many web
clients support it).  And, although there may or may not be a
risk using anonymous access to the ftp server it is no more or less of 
a
security risk when providing anonymous http access IMHO.

Regards,

Howie

- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 12:37 PM
Subject: FTP vs HTTP


 Hi Everyone,

 I'm searching for opinions and perhaps metrics that might suggest 
when it
is
 better to channel downloads using FTP vs HTTP from a single web 
server
 environment.  Essentially, we have a large file (35M) that a 
significant
 number of people must download monthly.  The question is: What 
advantage
 could we gain by using an FTP link vs a HTTP link?  Opening an 
anonymous
 FTP channel is potentially more risky from a security standpoint.  
But, we
 are wondering if channeling this traffic on another port would 
possibly
free
 up port 40 and result in a performance gain for the steady flow of 
*.cfm
 requests.

 Anyone out there with an opinion please chime in.  Or, if you know 
where I
 could find more information on this topic, send me a note.  Thanks.

 Good Fortune,
 Rick Walters
 Webmaster, Davita Laboratory Services
 Office: (800) 604-5227
 Cell: (407) 491-9848





__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Dave Carabetta

Does it take 50 seconds to run the query or 50 seconds to load the page?
Are you connecting to the DB using the same driver? How about your
network?


50 seconds to run the query only. I've even extracted the query into its own 
template and get the same results. And yes, I am using the same driver.

What really baffles me is that it works well in SQL Plus but then chokes in 
CF. My speculation is that it may have to do with how CF is retrieving and 
returning the record set. But I wouldn't even know where to look under the 
hood to analyze that -- I'm not a Unix guy.

Also, if this were happening with all my queries, then I'd have something to 
go on. But it's literally just this one query that is choking, and is 
actually a lot less complex than some other queries on the page. It's a 
simple select that calls a User-Defined Oracle function in the SQL along 
with two other columns from the table. I targeted the UDF as a potential 
culprit, but even removing that doesn't help.

Any other thoughts?

Thanks for the reply,
Dave.

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Justin Waldrip

Why not write a routine that will copy the file into the anonymous area
of the ftp server when a user initiates a download? That way you don't
always have the files available for anonymous access. I have a routine
that once a user initiates the download of a file, it copies the file
from our database server up the one of the load balanced web servers for
download. Then once the user is done downloading the file it is deleted
from the web server. Just a suggestion not sure if it fits your
application.

Justin Waldrip
[EMAIL PROTECTED]


-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 12:58 PM
To: CF-Talk
Subject: RE: FTP vs HTTP

Good Suggestions, I agree that FTP is a better way to push large files.
Problem is, I need to justify opening an anonymous access.  The idea 
that it
might boost performance would be a plus, but I'm having trouble finding
comparisons.  

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 3:39 PM
To: CF-Talk
Subject: RE: FTP vs HTTP

Ditto to howie - http servers and processes are also usually configured 
to
timeout long running request in order to enhance server performance 
and
overall user experience.  FTP is a better choice.

Mark

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 9:55 AM
To: CF-Talk
Subject: Re: FTP vs HTTP


For a file like that I would definitely use FTP - that is what FTP is 
for.
Most modern ftp servers and clients support resume for
one thing (only http/1.1 supports resume and I'm not sure how many web
clients support it).  And, although there may or may not be a
risk using anonymous access to the ftp server it is no more or less of 
a
security risk when providing anonymous http access IMHO.

Regards,

Howie

- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 12:37 PM
Subject: FTP vs HTTP


 Hi Everyone,

 I'm searching for opinions and perhaps metrics that might suggest 
when it
is
 better to channel downloads using FTP vs HTTP from a single web 
server
 environment.  Essentially, we have a large file (35M) that a 
significant
 number of people must download monthly.  The question is: What 
advantage
 could we gain by using an FTP link vs a HTTP link?  Opening an 
anonymous
 FTP channel is potentially more risky from a security standpoint.  
But, we
 are wondering if channeling this traffic on another port would 
possibly
free
 up port 40 and result in a performance gain for the steady flow of 
*.cfm
 requests.

 Anyone out there with an opinion please chime in.  Or, if you know 
where I
 could find more information on this topic, send me a note.  Thanks.

 Good Fortune,
 Rick Walters
 Webmaster, Davita Laboratory Services
 Office: (800) 604-5227
 Cell: (407) 491-9848






__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re[2]: FTP vs HTTP

2002-02-20 Thread Jim Priest

Couldn't you still set your FTP to 'read only' which would prevent
someone from uploading something (which would be the big fear I
imagine)

I've done this in the past to allow clients to grab large files. Check
out:  http://www.warftp.org/   Very robust FTP server for Win platform.

jim

RW Good Suggestions, I agree that FTP is a better way to push large files.
RW Problem is, I need to justify opening an anonymous access.  The idea 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Replace string,House of Fusion

2002-02-20 Thread phumes1

Hi,

My URL.filename = d:\dir1\dir2\dir3\test.txt

The below line strips out the filename which I want.

cfset URL.filename = ListDeleteAt(URL.filename, ListLen(URL.filename, 
\),\)

URL.filename = d:\dir1\dir2\dir3

How can I make the above line read:

/dir1/dir2/dir3
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Replace string,House of Fusion

2002-02-20 Thread Christopher Olive

ListChangeDelims(ListRest(URL.filename, \), /, \)

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:38 PM
To: CF-Talk
Subject: Re: Replace string,House of Fusion


Hi,

My URL.filename = d:\dir1\dir2\dir3\test.txt

The below line strips out the filename which I want.

cfset URL.filename = ListDeleteAt(URL.filename, ListLen(URL.filename, 

\),\)

URL.filename = d:\dir1\dir2\dir3

How can I make the above line read:

/dir1/dir2/dir3

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Refresh Window

2002-02-20 Thread Christian Abad

Becky:

Try this-

Assuming that the window underneath (parent) created the pop-up (child)
window, you can add this line of code to your input type=submit ...
button:

onClick=JavaScript: opener.location.reload();

Works like a gem!

Cheers,
Christian N. Abad
ColdFusion Web Developer

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:58 AM
To: CF-Talk
Subject: Refresh Window


Is there a way to Automatically refresh a window?
I have a page that has a pop-up window.  When you make changes on that fo
rm (in the pop-up windown) when i click submit...i want the window undern
eath to reflect the changes.  the only way it does right now is if i hit
the refresh button.  is there a way to do this without hitting the refres
h button?
thanks for your help.
bec.
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Need Suggestions

2002-02-20 Thread Dave Clay

I inherited 1300 static pages that are found by a lookup table.   

Is the best way to revamp this application to build some templates, put 
everything in a database and build the page that way?

I love suggestions how to set this as a true dynamic application. Any 
help would be greatful.  You can see the current application at 
www.trusjoist.com/datachunk if that would help.

Thank you
Dave Clay
www.trusjoist.com

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Alex

did you read the size...file (35M)

On Wed, 20 Feb 2002, Justin Waldrip wrote:

 Why not write a routine that will copy the file into the anonymous area
 of the ftp server when a user initiates a download? That way you don't
 always have the files available for anonymous access. I have a routine
 that once a user initiates the download of a file, it copies the file
 from our database server up the one of the load balanced web servers for
 download. Then once the user is done downloading the file it is deleted
 from the web server. Just a suggestion not sure if it fits your
 application.
 
 Justin Waldrip
 [EMAIL PROTECTED]
 
 
 -Original Message-
 From: Rick Walters [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, February 20, 2002 12:58 PM
 To: CF-Talk
 Subject: RE: FTP vs HTTP
 
 Good Suggestions, I agree that FTP is a better way to push large files.
 Problem is, I need to justify opening an anonymous access.  The idea 
 that it
 might boost performance would be a plus, but I'm having trouble finding
 comparisons.  
 
 -Original Message-
 From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 3:39 PM
 To: CF-Talk
 Subject: RE: FTP vs HTTP
 
 Ditto to howie - http servers and processes are also usually configured
 
 to
 timeout long running request in order to enhance server performance 
 and
 overall user experience.  FTP is a better choice.
 
 Mark
 
 -Original Message-
 From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 9:55 AM
 To: CF-Talk
 Subject: Re: FTP vs HTTP
 
 
 For a file like that I would definitely use FTP - that is what FTP is 
 for.
 Most modern ftp servers and clients support resume for
 one thing (only http/1.1 supports resume and I'm not sure how many web
 clients support it).  And, although there may or may not be a
 risk using anonymous access to the ftp server it is no more or less of 
 a
 security risk when providing anonymous http access IMHO.
 
 Regards,
 
 Howie
 
 - Original Message -
 From: Rick Walters [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 20, 2002 12:37 PM
 Subject: FTP vs HTTP
 
 
  Hi Everyone,
 
  I'm searching for opinions and perhaps metrics that might suggest 
 when it
 is
  better to channel downloads using FTP vs HTTP from a single web 
 server
  environment.  Essentially, we have a large file (35M) that a 
 significant
  number of people must download monthly.  The question is: What 
 advantage
  could we gain by using an FTP link vs a HTTP link?  Opening an 
 anonymous
  FTP channel is potentially more risky from a security standpoint.  
 But, we
  are wondering if channeling this traffic on another port would 
 possibly
 free
  up port 40 and result in a performance gain for the steady flow of 
 *.cfm
  requests.
 
  Anyone out there with an opinion please chime in.  Or, if you know 
 where I
  could find more information on this topic, send me a note.  Thanks.
 
  Good Fortune,
  Rick Walters
  Webmaster, Davita Laboratory Services
  Office: (800) 604-5227
  Cell: (407) 491-9848
 
 
 
 
 
 
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Alex

Not sure if this makes a difference but
try writing your query with full names like
database.schema.table.field



On Wed, 20 Feb 2002, Dave Carabetta wrote:

 Does it take 50 seconds to run the query or 50 seconds to load the page?
 Are you connecting to the DB using the same driver? How about your
 network?
 
 
 50 seconds to run the query only. I've even extracted the query into its 
own 
 template and get the same results. And yes, I am using the same driver.
 
 What really baffles me is that it works well in SQL Plus but then chokes 
in 
 CF. My speculation is that it may have to do with how CF is retrieving an
d 
 returning the record set. But I wouldn't even know where to look under t
he 
 hood to analyze that -- I'm not a Unix guy.
 
 Also, if this were happening with all my queries, then I'd have something
 to 
 go on. But it's literally just this one query that is choking, and is 
 actually a lot less complex than some other queries on the page. It's a
 
 simple select that calls a User-Defined Oracle function in the SQL along
 
 with two other columns from the table. I targeted the UDF as a potential
 
 culprit, but even removing that doesn't help.
 
 Any other thoughts?
 
 Thanks for the reply,
 Dave.
 
 _
 Join the world’s largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Alex

search google.com

On Wed, 20 Feb 2002, Rick Walters wrote:

 Good Suggestions, I agree that FTP is a better way to push large files.
 Problem is, I need to justify opening an anonymous access.  The idea 
 that it
 might boost performance would be a plus, but I'm having trouble finding
 comparisons.  
 
 -Original Message-
 From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 3:39 PM
 To: CF-Talk
 Subject: RE: FTP vs HTTP
 
 Ditto to howie - http servers and processes are also usually configured
 
 to
 timeout long running request in order to enhance server performance 
 and
 overall user experience.  FTP is a better choice.
 
 Mark
 
 -Original Message-
 From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 9:55 AM
 To: CF-Talk
 Subject: Re: FTP vs HTTP
 
 
 For a file like that I would definitely use FTP - that is what FTP is 
 for.
 Most modern ftp servers and clients support resume for
 one thing (only http/1.1 supports resume and I'm not sure how many web
 clients support it).  And, although there may or may not be a
 risk using anonymous access to the ftp server it is no more or less of 
 a
 security risk when providing anonymous http access IMHO.
 
 Regards,
 
 Howie
 
 - Original Message -
 From: Rick Walters [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 20, 2002 12:37 PM
 Subject: FTP vs HTTP
 
 
  Hi Everyone,
 
  I'm searching for opinions and perhaps metrics that might suggest 
 when it
 is
  better to channel downloads using FTP vs HTTP from a single web 
 server
  environment.  Essentially, we have a large file (35M) that a 
 significant
  number of people must download monthly.  The question is: What 
 advantage
  could we gain by using an FTP link vs a HTTP link?  Opening an 
 anonymous
  FTP channel is potentially more risky from a security standpoint.  
 But, we
  are wondering if channeling this traffic on another port would 
 possibly
 free
  up port 40 and result in a performance gain for the steady flow of 
 *.cfm
  requests.
 
  Anyone out there with an opinion please chime in.  Or, if you know 
 where I
  could find more information on this topic, send me a note.  Thanks.
 
  Good Fortune,
  Rick Walters
  Webmaster, Davita Laboratory Services
  Office: (800) 604-5227
  Cell: (407) 491-9848
 
 
 
 
 
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Montana CFUG Meeting

2002-02-20 Thread Jason Larson

The Brand New Montana Cold Fusion User Group will be meeting this
Thursday for those who are interested:

Montana CFUG February Meeting
February 21st
7:00 PM
University of Montana 
University Center Room 224
Missoula, MT

Agenda:

- Using SQL: The In's and Out's of writing SQL Statements
- CF Security: Keeping your CF Applications secure, CF Server Secure,
and how to prevent URL Hacking
- General CF Discussion

Montana CFUG Website: http://montanacfug.site-o-matic.com

Thanks,
Jason Larson
[EMAIL PROTECTED]
www.larzz.com
P. 406.728.4422
F. 406.543.4266
 
You think the Cubs have sore arms? What about the fans in left field?

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FTP vs HTTP

2002-02-20 Thread Justin Waldrip

Well if your copying the file on the same local disk this isnt' a
problem. I have copied files larger than that across the network and had
no problems. Not to mention this is a process that was said to be run on
a monthly basis.

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 1:34 PM
To: CF-Talk
Subject: RE: FTP vs HTTP

did you read the size...file (35M)

On Wed, 20 Feb 2002, Justin Waldrip wrote:

 Why not write a routine that will copy the file into the anonymous
area
 of the ftp server when a user initiates a download? That way you don't
 always have the files available for anonymous access. I have a routine
 that once a user initiates the download of a file, it copies the file
 from our database server up the one of the load balanced web servers
for
 download. Then once the user is done downloading the file it is
deleted
 from the web server. Just a suggestion not sure if it fits your
 application.
 
 Justin Waldrip
 [EMAIL PROTECTED]
 
 
 -Original Message-
 From: Rick Walters [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, February 20, 2002 12:58 PM
 To: CF-Talk
 Subject: RE: FTP vs HTTP
 
 Good Suggestions, I agree that FTP is a better way to push large
files.
 Problem is, I need to justify opening an anonymous access.  The idea 
 that it
 might boost performance would be a plus, but I'm having trouble
finding
 comparisons.  
 
 -Original Message-
 From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 3:39 PM
 To: CF-Talk
 Subject: RE: FTP vs HTTP
 
 Ditto to howie - http servers and processes are also usually
configured
 
 to
 timeout long running request in order to enhance server performance 
 and
 overall user experience.  FTP is a better choice.
 
 Mark
 
 -Original Message-
 From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 20, 2002 9:55 AM
 To: CF-Talk
 Subject: Re: FTP vs HTTP
 
 
 For a file like that I would definitely use FTP - that is what FTP is 
 for.
 Most modern ftp servers and clients support resume for
 one thing (only http/1.1 supports resume and I'm not sure how many web
 clients support it).  And, although there may or may not be a
 risk using anonymous access to the ftp server it is no more or less of

 a
 security risk when providing anonymous http access IMHO.
 
 Regards,
 
 Howie
 
 - Original Message -
 From: Rick Walters [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 20, 2002 12:37 PM
 Subject: FTP vs HTTP
 
 
  Hi Everyone,
 
  I'm searching for opinions and perhaps metrics that might suggest 
 when it
 is
  better to channel downloads using FTP vs HTTP from a single web 
 server
  environment.  Essentially, we have a large file (35M) that a 
 significant
  number of people must download monthly.  The question is: What 
 advantage
  could we gain by using an FTP link vs a HTTP link?  Opening an 
 anonymous
  FTP channel is potentially more risky from a security standpoint.  
 But, we
  are wondering if channeling this traffic on another port would 
 possibly
 free
  up port 40 and result in a performance gain for the steady flow of 
 *.cfm
  requests.
 
  Anyone out there with an opinion please chime in.  Or, if you know 
 where I
  could find more information on this topic, send me a note.  Thanks.
 
  Good Fortune,
  Rick Walters
  Webmaster, Davita Laboratory Services
  Office: (800) 604-5227
  Cell: (407) 491-9848
 
 
 
 
 
 
 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



NHCFUG

2002-02-20 Thread Duane Boudreau

Hey all,

Does anyone here know if the NHCFUG is still in operation?

TIA,
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Query a query by months

2002-02-20 Thread Tim

I am trying to query a query and process the records
by month.  My code is:

cfloop index=cnt to=12 from=1
cfset QAvg = 0cfset QAvgFinal = 0cfset AvgCnt =
0cfset tcnt = 0
cfquery name=qGetRecords dbtype=query
SELECT  *
FROM qGetResults
WHERE (Month(qGetResults.Rundate) = #cnt#) 
/cfquery 
cfloop query=qGetRecords
cfinclude template=GetClassPlacement.cfm
/cfloop

My problems are with the WHERE statement.  If I do
WHERE #Month(qGetResults.RunDate)# = #cnt#, it
interprets the data as a variable (1 = 1, 1 = 2, etc)
and retirns all records when true (1 = 1).  If I leave
the pound signs off, I get errors.

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Dave Carabetta

Not sure if this makes a difference but
try writing your query with full names like
database.schema.table.field


Well, I just ran a test in CF. I substituted the cfqueryparam tags with 
static values and the page worked perfectly. I then used all CF variables 
instead, and the page worked perfectly. Then I started putting back in the 
cfqueryparam tags one at a time. The page was returning perfectly until 
one line in my WHERE clause.

So the quick response is to say well there's your answer, but it's not. 
See, the cfqueryparam that gets used in the line that chokes is also being 
used in a previous condition in the WHERE clause, where it works perfectly. 
It's using this same cfqueryparam again that's choking CF.

Any ideas on why that might happen? I know you can re-use cfqueryparams in 
the same query, so that theory is out. Anything else I'm missing?

Baffled,
Dave.

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: bit mask info

2002-02-20 Thread Kelly Tetterton

Just wanted to thank all the folks who replied both on- and off-list; the
info was exactly what I needed!

KT I'm looking for presentations/information/examples regarding bit masks.
I've
KT looked through the archives, and two presentations are mentioned, but
KT neither seem available any longer. Can anyone point me in the right
KT direction? thanks --

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Need Suggestions

2002-02-20 Thread Alex

On Wed, 20 Feb 2002, Dave Clay wrote:

 I inherited 1300 static pages that are found by a lookup table.   
 
 Is the best way to revamp this application to build some templates, put
 
 everything in a database and build the page that way?

That's what I would do unless you like maintenance.

 
 I love suggestions how to set this as a true dynamic application. Any 
 help would be greatful.  You can see the current application at 
 www.trusjoist.com/datachunk if that would help.
 
 Thank you
 Dave Clay
 www.trusjoist.com
 
 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query a query by months

2002-02-20 Thread Macarie Neculai

Hi!

I think that ColdFusion server does not have the Month function
implemented in it's SQL processor (because the query get's processed by CF
and never goes to your database server). When you put the pound signs around
Month then CF treats it like a function and evaluates it's result once
before he sends the resulted text to the SQL processing part.

One solution will be that you go throught the query by hand (with
query_name.query_field[Row]) and construct the result query.

Mack.

- Original Message -
From: Tim [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Wednesday, February 20, 2002 11:48 AM
Subject: Query a query by months


 I am trying to query a query and process the records
 by month.  My code is:

 cfloop index=cnt to=12 from=1
 cfset QAvg = 0cfset QAvgFinal = 0cfset AvgCnt =
 0cfset tcnt = 0
 cfquery name=qGetRecords dbtype=query
 SELECT *
 FROM qGetResults
 WHERE (Month(qGetResults.Rundate) = #cnt#)
 /cfquery
 cfloop query=qGetRecords
 cfinclude template=GetClassPlacement.cfm
 /cfloop

 My problems are with the WHERE statement.  If I do
 WHERE #Month(qGetResults.RunDate)# = #cnt#, it
 interprets the data as a variable (1 = 1, 1 = 2, etc)
 and retirns all records when true (1 = 1).  If I leave
 the pound signs off, I get errors.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Jeffry Houser

Also, if this were happening with all my queries, then I'd have something to
go on. But it's literally just this one query that is choking, and is
actually a lot less complex than some other queries on the page. It's a
simple select that calls a User-Defined Oracle function in the SQL along
with two other columns from the table. I targeted the UDF as a potential
culprit, but even removing that doesn't help.

  Just a thought...
  Try removing the UDF and putting the query in a new template (one that 
hasn't run yet) and see if that has an effect.

  ColdFusion does use some form of template caching.  I don't know any of 
the specific details of that, but is it possible you execute the template, 
make a change, and re-run it again without the changes taking effect.

  I believe the above synopsis to be  a shot in the dark, however...



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cftree problems

2002-02-20 Thread Attley, Simon (CMG-SF)

Hi Guys,
I am trying to make use of cftree for an internal web project, and when I
try to run my code (currently am just running an example of cftree from
Macromedia's CF 5 Web App. Construction Kit book) the Applet begins to load
and then  I get the following error: 

java.lang.ClassNotFoundException: allaire.controls2.CFTreeApplet.class

I have noticed the following:

at our webroot the following directory structure exists:
cfide/classes/allaire/controls

within the controls folder there is a CFTree.class, cftreeform.class, and a
CFTreeItem.class

we have no controls2 folder which the ClassNotFound error references and I
cannot see a CFTreeApplet.class file on our server

Any suggestions would be greatly appreciated,

Simon Attley
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT: Just wanna bitch

2002-02-20 Thread Brook Davies

At 08:49 AM 13/02/02 -0800, you wrote:
My 2 cents.

It can also be a useful marketing tool.  You give it away.don't have 
to support it because it's
freeplaster powered by Your Company all over it.

There is a company up North here that created a whack load of webtools 
which are things like:
-add a poll to your site
-add a subscription mailing list
-add a calendar
-etc

They gave them a way for free and targeted webmasters and ISPs.  There was
 
enough traffic they could
sell advertising on their site.  Then the big company came in and bought 
their 2 person operation
for $2,000,000 CDN!!

Sounds like it worked out for them ;-)

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Query a query by months

2002-02-20 Thread Jeff Beer

I think you need # signs around qGetResults.Rundate in the WHERE clause.  CF
thinks it's a SQL table.field designator, and of course, SQL freaks when it
can't find it..  CF needs to evaluate the result to a vavlue first.

-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 2:49 PM
To: CF-Talk
Subject: Query a query by months


I am trying to query a query and process the records
by month.  My code is:

cfloop index=cnt to=12 from=1
cfset QAvg = 0cfset QAvgFinal = 0cfset AvgCnt =
0cfset tcnt = 0
cfquery name=qGetRecords dbtype=query
SELECT  *
FROM qGetResults
WHERE (Month(qGetResults.Rundate) = #cnt#)
/cfquery
cfloop query=qGetRecords
cfinclude template=GetClassPlacement.cfm
/cfloop

My problems are with the WHERE statement.  If I do
WHERE #Month(qGetResults.RunDate)# = #cnt#, it
interprets the data as a variable (1 = 1, 1 = 2, etc)
and retirns all records when true (1 = 1).  If I leave
the pound signs off, I get errors.

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Execution Time: CF vs. SQL Plus

2002-02-20 Thread Jochem van Dieten

Dave Carabetta wrote:
 
 Well, I just ran a test in CF. I substituted the cfqueryparam tags with 
 static values and the page worked perfectly. I then used all CF variables 
 instead, and the page worked perfectly. Then I started putting back in the 
 cfqueryparam tags one at a time. The page was returning perfectly until 
 one line in my WHERE clause.
 
 So the quick response is to say well there's your answer, but it's not. 
 See, the cfqueryparam that gets used in the line that chokes is also being 
 used in a previous condition in the WHERE clause, where it works perfectly. 
 It's using this same cfqueryparam again that's choking CF.
 
 Any ideas on why that might happen? I know you can re-use cfqueryparams in 
 the same query, so that theory is out. Anything else I'm missing?

Could you show the code? Just the where clause?

Jochem


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



ActiveEdit hyperlinks

2002-02-20 Thread Cantrell, Adam

Hey list, I'm attempting to add some custom functionality to ActiveEdit, but
didn't want to reinvent the wheel. I'd like to allow the user to add
Hyperlinks to a dynamic URL within our site. Basically, when they click the
cutom-hyperlink menu-item, I am going to pop up a window that queries our
content table and allows them to navigate to the content they would like to
link to. It will build the dynamic URL for them, and insert it into the
activeEdit text-box wherever their cursor was. Does anyone have any
javascript they've already written or suggestions on where to look? I hate
writing javascript, especially from scratch. I have a feeling I'm going to
have my head in an Oreily book tonight - blech.

Adam.



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



quick regular expression question

2002-02-20 Thread Mark W. Breneman

I seem to be having a problem with this regular expression.  Can anyone tell
me why?  It must be something simple.

div align=center[[:space:]a-z0-9A-Z[:punct:][:space:]]+/div

All I am trying to do is select everything between some pesky div tags.

Thanks

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: using a javascript variable while in ASP

2002-02-20 Thread Yager, Brian T Contractor/NCCIM

Firt off, I apologize for posting this to the CF list.  This is the only list
that I am a part of (this and the managers list).  What I need to know is while
I am in a Script tag doing javascript, I need to have some ASP code.  BUT, I
need to use a variable from the javascript in my ASP if statement.  Has anyone
done this before that could help me out?  Just contact me off list.


Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



activePDF configuration

2002-02-20 Thread Sean McCarthy

We have multiple CF webservers and one activePDF server.  How do you give
the webservers access to the activePDF COM object?

Thanks 

Sean
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: activePDF configuration

2002-02-20 Thread Ian Lurie

Given that they sell it on a server-by-server lisence, I'm not sure I'd t
ry.
Sure wouldn't ask about it on this list...
 :)

Ian

-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:12 PM
To: CF-Talk
Subject: activePDF configuration


We have multiple CF webservers and one activePDF server.  How do you give
the webservers access to the activePDF COM object?

Thanks

Sean

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Cold Fusion code to decode binary base64 attachment

2002-02-20 Thread Steven Salter

Greetings,

I am running CF4.5 on Redhat 6.x. I have subscribed to the USPS Electronic
Return service. When I shoot them an xml string I get back a response that
is supposed to be the return mailing label in pdf format. The response comes
back as binary that I will need to decode as base64 in order to view the
label.

Anyone have code or a custom tag that will decode the base64 binary?
Preferably, I want to just display it on the web page (cfcontent?), and not
write it to disk but anything that works would be wonderful.

Thanks,
Steve

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   >