RE: DELPHI - where does it fit in the scheme of things?

[lsellers]

> What is Delphi?  Is it a peer to ASP and ColdFusion or is it more a peer
> to VisualBasic and used for making COM Objects?
>
> Is it any good?
>
> Would you other webmasters live with ASP, ColdFusion AND Delphi in your
> sites?

Never used it, but I keep bumping into Delphi shops that also use CF.
There's at least a couple of those folks on the mailing list somewhere.

Delphi is basically the child of Pascal, like C++ was to C. Think of it as
Pascal++. Somewhere between Java and C++ in power/complexity. You can make
COM's with it. You can also make CFX's with it. Yes, it's roughly in the
same league as VisualBasic, Java and C++.

--min



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CPU 100% (again, sorry)

[Michel Vuijlsteke]

Sorry, that's not it.

Configuration is:

PIII 384 MB RAM pleanty of hard disk space
Win NT 4 SP6a
CF 4.5.1sp2
latest MDAC etc. etc.

DSN on dual PII 768 MB RAM
Win NT 4 SP6a
MS SQL Server 7

Both these machines are ridiculously overpowered for what I'm doing: the web
site I'm talking about has about 1.5 visitors a days (it's in development,
and it's mainly a static site with a database-based menu, an alumni
database, a calendar and a news database).

I have other sites with tens of thousands of vitors a dayand 50-100 Gb
transfer a month that don't give any problems whatsoever.

The point is that there is no structural difference between files that hang
CF and files that don't. And that the problem often goes away when I simply
rename a file, or create a new file!

And no, I'm not using any reserved words, it's filenames like
"vademecum.cfm" or "lager_reglem_lln.cfm" that give problems, and that
miraculously work when I rename them to "vadem.cfm" of
"lager_reglem_kennis.cfm".

Michel Vuijlsteke
Netpoint NV

-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 3:26 AM
To: [EMAIL PROTECTED]
Subject: RE: CPU 100% (again, sorry)


Michael, I have had this problem myself. My situation was due to too many
concurrent connections to an access database. We upgraded to SQL Server 7.0
and migrated the database - solved it for us.

Tony Gruen
Senior Technical Developer
Carlson Marketing Group SF

-Original Message-
From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:03 PM
To: CF-Talk
Subject: CPU 100% (again, sorry)


Sorry to post about this again, but I went through the archives and did not
see any definitive resolution of the problem.

We've had some problems on one particular server and always put it down to
bad code, but it turns out the dreaded 100% CPU utilization bug is spreading
to our other servers too.

Was the problem ever solved satisfactorily? Or pinpointed to a particular
release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)?

Michel Vuijlsteke
Netpoint NV
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CPU 100% (again, sorry)

[Michel Vuijlsteke]

Nope.

I have a bunch of "static" CFM pages that I construct a menu around (simply
by adding a header in application.cfm and a footer in onrequestend.cfm).

A page named "information.cfm" will give no problems, but a page named
"vademecum.cfm" will hang the server, whether I follow a link to it or enter
the URL directly.

When I rename that file to "vadem.cfm" it will work without any problems.

A few hours later, the same will happen to another file. Another perfectly
unremarkable file, with no special instructions in it whatsoever. And the
problem will go away when I rename the file, from say "whowhat.cfm" to
"whatwho.cfm".

Lather. Rinse. Repeat. 

Aaargh!

Michel Vuijlsteke

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 3:05 AM
To: CF-Talk
Subject: RE: CPU 100% (again, sorry)


Does your memory utilization go up when this happens? I have found when
quering a huge database if the memory goes up while the cpu is at 100% it's
because of database if cpu is just at 100% there is bad code somewhere. If
all the drivers are updated (mdac that is) and you're running a normal
webserver, be it SQL, Access (orcale maybe could be a problem there) there
shouldn't be a problem. Double check and recheck that code especially if
it's spreading where it wasn't before.


Bob Everland

-Original Message-
From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 6:03 PM
To: CF-Talk
Subject: CPU 100% (again, sorry)


Sorry to post about this again, but I went through the archives and did not
see any definitive resolution of the problem.

We've had some problems on one particular server and always put it down to
bad code, but it turns out the dreaded 100% CPU utilization bug is spreading
to our other servers too.

Was the problem ever solved satisfactorily? Or pinpointed to a particular
release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)?

Michel Vuijlsteke
Netpoint NV
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Javascript in Netscape

[han peng]

yeah!! thank you!!
solve that silly mistake finally!!!...
thanx a million ppl.. :Þ

cheers
han
- Original Message -
From: Christoph Schmitz <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, January 09, 2001 4:31 AM
Subject: AW: Javascript in Netscape


> Hi Han,
>
> you need to use "resizable" instead of "resizeable"... just drop the "e".
>
> HTH,
>
> Chris
>
>
> > -Ursprüngliche Nachricht-
> > Von: han peng [mailto:[EMAIL PROTECTED]]
> > Gesendet: Montag, 8. Januar 2001 09:19
> > An: CF-Talk
> > Betreff: Javascript in Netscape
> >
> >
> > hey i had a prob
> > i'm opening a new window with size 500,370.
> > but for the link in there.. i wan the next page to be shown as
> > full screen or at least can be resized...
> > tried the codes below..
> >  can work for IE.. but cant for netscape..
> >
> > any solution?
> >
> > cheers
> > han
> >
> >
> > File A:
> > function openwin(location, x, y)
> >   {
> >
para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y;
> > msgWindow=window.open(location, "displaywindow", para);
> >   }
> >
> > User ID
> >
> >
> >
> > userid.html :
> > function openwin(location, x, y)
> >   {
> >
para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y;
> > msgWindow=window.open(location, "displaywindow", para);
> >   }
> >
> > forgotten
> >
> > also tried this:
> > forgotten
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: And the award goes to ......

[Hal Helms]

Snow?

Hal Helms
== See www.ColdFusionTraining.com for info on "Best Practices with
ColdFusion & Fusebox" training, Jan 22-25 ==


-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 4:26 PM
To: CF-Talk
Subject: Re: And the award goes to ..


And in Canada it takes only 4 hours to count 15 million votes. So what
do they have that Florida doesn't.

regards,
larry

--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--

"Stephen R. Cassady" wrote:
>
> >Handcount the votes ??? only in florida ??
>
> And in Canada. All votes are hand counted. And we mark them with these
itsy
> bitsy pencils.
>
> :)
>
> Stephen Cassady
> http://www.tallylist.com < FOR ADVANCED LIST ARCHIVING
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Storing images in SQL

[Benjamin S. Rogers]

It's probably pretty clear to most people what is going on when just a
reference to the image (/directory/name.img) is stored in the database so
I'll just discuss what additional overhead is incurred when the entire image
is stored in the database.

When you store the actual image in the database, the request from the client
for the image that would normally get handled relatively speedily and
efficiently by the Web server and file system (after all that is what they
are designed for) is actually passed off to ColdFusion. This ties up one
additional thread on the ColdFusion server for each image being processed.
You only get so many threads: usually 5 times the number of processors. If
you had a single CPU server, you could tie up all the available threads with
one page that had five images on it.

ColdFusion then makes a query to the database which is usually on a
different server. This takes network resources, from the NICs to the
bandwidth utilized to transfer the query and return the image data. If the
database is not on a separate server (which is not generally a good idea
because, among other things, you are tying up CPU cycles on your Web server)
then you still incur the overhead of processing the request, finding the
data in the database and passing this back the ColdFusion application server
all via ODBC, OLE etc.

On the database's end of things, RDBMSs usually store BLOB (Binary Large
Object) data relatively poorly since most RDBMSs store information in 2k
extents and 8k pages. What in effect happens is the RDBMS stores the image
elsewhere in the database and places a pointer where you would logically
expect the image data. This is also true for the TEXT datatype. When the
RDBMS goes to return the data, it has to "hunt" the image in a separate
spot.

In any case, you've added quite a bit more overhead to the Web server, the
database server, and the network. You've also increase the amount of time it
takes to process the request, making you site appear slower to outside
users. Some users may have special requirements that necessitate storing the
images in the database, but, in most situations, the gain is little to
nothing.

There are a lot of other smaller issues, such as the way ColdFusion handles
binary data and how that data is transferred between the database server and
the ColdFusion application server, but hopefully the above description will
give you a general idea of why developers always caution against storing
image data directly in the database.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057


-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 5:40 PM
To: CF-Talk
Subject: RE: Storing images in SQL


Larry,

I've asked this question before also. And got similar responses as yours
which is appreciated. But is there any way you could tell us (a number of
people have asked this question) why it's slower and messier. I'm sure for
somebody that knows the details on what it takes to do this can logically
agree with you (and others who have said the same) and I too would like to
be one of those well informed people that come to the same conclusion for
the same reasons. Could you or anyone else familiar with the techniques
required for this please elaborate on this so I can say something other than
"it's a bad idea because that's what somebody said."

Thanks,

Rick

-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:28 PM
To: CF-Talk
Subject: Re: Storing images in SQL


Michael,

In a nutshell don't. Its far faster, easier and a lot less messy to
store the images's name and then dynamically construct the path
information.

regards,
larry

--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--


Michael Buffington wrote:
>
> Does anyone have any experience storing images in SQL 7.0, and retrieving
> them in CF?
>
> Any tips would help!
>
> Michael Buffington
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: using template in html?

[Jon Hall]

Macromedia's Ultradev is Dreamweaver that understands Cold Fusion.
In an ideal world (yeah right) though, all the html design should be done
and have the customers seal of approval before your coders start
integrating.

jon
- Original Message -
From: "han peng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 11:07 PM
Subject: using template in html?


> hi all...
>
> is there a way in html that works like CFINCLUDE??
> coz the designers normally use dreamweaver to do prototype.. and that
software seem unable to read cfm files...
>
> or is there a better way for the designers to do templates so that the
programmers
> can easily integrate the codes...??
>
>
> cheers
> han
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

DELPHI - where does it fit in the scheme of things?

[Michael Kear]

At one of my sites, an employee who has some influence over my client
decision maker has started saying they need to use Delphi in our site,
presumably to give himself a role in the web site.

We already have too many technologies in my opinion - ASP, ColdFusion,
static HTML pages, and my immediate reaction is to pour cold water on the
notion of using DELPHI anywhere.

But I confess, I don't know a lot about Delphi, and before I react, I
wanted to find out from some of you knowledgeable people whether I'm about
to knock a great idea on the head.

What is Delphi?  Is it a peer to ASP and ColdFusion or is it more a peer
to VisualBasic and used for making COM Objects?

Is it any good?

Would you other webmasters live with ASP, ColdFusion AND Delphi in your
sites?   

Aside from the politics involved, what are the issues I face having Delphi
added to my mix of technologies?


Cheers,
Mike Kear
AFP WebWorks
Windsor, NSW, Australia


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple Servers - Cluster Cats

[Lee Fuller]

Agreed

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 5:11 PM
> To: CF-Talk
> Subject: Re: Multiple Servers - Cluster Cats
> 
> 
> Win2k Advanced Server's built in clustering and failover software is very
> slick and easy to use.
> 
> jon
> - Original Message -
> From: "Kirk Boecker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 08, 2001 2:10 PM
> Subject: Multiple Servers - Cluster Cats
> 
> 
> > Sorry for the slightly OT post,
> >
> > We have a server pair running our main CF application, both are DELL
> > enterprise servers,
> > (1 running win2k, IIS and CF 4.5 and the other running SQL server 7).
> >
> > We are not maxing out the server at all but we need some type 
> of failover
> > security
> > (last week we had a motherboard in the DB server take a dump on us).
> >
> > We are thinking of setting up some type of cluster (cluster 
> cats?) or some
> > type of
> > mirrored set of servers to take over if something goes wrong.
> >
> > Does anyone have any experience setting up Cluster Cats or any 
> other solid
> > backup/failover server system?
> >
> > Kirk Boecker
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: AvantGo channels w/CF?

[Matthew Fusfield]

Yep, already tried caching. Even if I setup the channel to consist of two
pages with little functionality, it still eats up RAM. Strangly, this does
not happen when I create a channel that is based on our Win 2k development
server.

Matt

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 6:06 PM
To: CF-Talk
Subject: RE: AvantGo channels w/CF?


Yes.  Autobytel.com has an AvantGo channel and I've created two other
channels for other projects.

Are you using the AvantGo caching?  Realize that what is happening is
AvantGo is acting as a spider and downloading ALL the pages linked off the
home page and subsequent pages all at once.  As a result your traffic to
your web server can be very intense.  If you use their caching, however, all
that content is cached at AvantGo and the requests don't hit your network
until the cache expires (based upon a time span you set).  That way if you
have 1000 users downloading 20 pages each time, it is just 20 hits to your
server.  Without caching it would be 20,000.

--Doug

-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 12:03 PM
To: CF-Talk
Subject: AvantGo channels w/CF?


Has anyone done any work with creating an AvantGo channel on a CF-based web
site? (AvantGo is an offline web browser for Palms and WinCE devices)

I've created a test for a client demo. It basically pulls press releases
from a database, removes any HTML formatting, and outputs it as very
simplified HTML for the Palm. It works fine if I load the page up in
Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
the RAM usage on my CF server skyrockets. I've already tried playing with
caching, changing page sizes, etc and even if it is just one or two simple
pages, CF begins using memory like crazy.

We're running CF 4.5 sp1 on a Windows NT 4.0 server.

Thanks,

Matthew I. Fusfield
Senior Web Systems Developer
InterActive Network Systems, Inc.
[EMAIL PROTECTED] - 856-227-4428 ext 15
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: AvantGo channels w/CF?

[Matthew Fusfield]

Ed,
I tried this, and it did work (as it should). This might be the route I end
up taking, although not as streamlined as I'd like.

Thanks much,

Matt

-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 5:06 PM
To: CF-Talk
Subject: RE: AvantGo channels w/CF?


Just an out of blue suggestion, but why don't you call a page that activates
a  tag, then uses  to actually return the contents of
your page... That way the AvantGo server only accesses an html page and your
server does the work of rendering the page I've been playing with
different aspects of AvantGo channels myself and that's the easiest way I
could think of doing what you want to do.

It's a faff if you've got a lot of pages Then again cfschedule is pretty
flexible...

Just some late night thoughts after a long day, please forgive me if it
doesn't make any sense...

-= Ed

> -Original Message-
> From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
> Sent: 8 January 2001 8:03 PM
> To: CF-Talk
> Subject: AvantGo channels w/CF?
>
>
> Has anyone done any work with creating an AvantGo channel on a
> CF-based web
> site? (AvantGo is an offline web browser for Palms and WinCE devices)
>
> I've created a test for a client demo. It basically pulls press releases
> from a database, removes any HTML formatting, and outputs it as very
> simplified HTML for the Palm. It works fine if I load the page up in
> Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
> the RAM usage on my CF server skyrockets. I've already tried playing with
> caching, changing page sizes, etc and even if it is just one or two simple
> pages, CF begins using memory like crazy.
>
> We're running CF 4.5 sp1 on a Windows NT 4.0 server.
>
> Thanks,
>
> Matthew I. Fusfield
> Senior Web Systems Developer
> InterActive Network Systems, Inc.
> [EMAIL PROTECTED] - 856-227-4428 ext 15
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Frames in NS solved - Thanks

[Paige Chandler]

Hello All,

Thanks to all who responed. FYI Duane and Christoph hit it - I mispelled  
Give me an 'E' - please.

I would never have believed it. Oh! I'd believe I could mispell it, I just wouldn't 
have believed that IE didn't care and NS wouldn't even acknowledege or give me an 
error. I hate NS. Yeh! I know it's my own fault.
I guess spelling it correctly 50% of the time is not enough. 

I did have / in my original, and following the suggestions, reinserted it 
in this test. It works well with or without it.  BIG help. Thanks again.

Regards,

Paige


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

using template in html?

[han peng]

hi all...

is there a way in html that works like CFINCLUDE??
coz the designers normally use dreamweaver to do prototype.. and that software seem 
unable to read cfm files...

or is there a better way for the designers to do templates so that the programmers
can easily integrate the codes...??


cheers
han


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF-Talk Archive Down?

[James Taavon]

Hey, is the mail archive down and if so how long before it is back up
and running?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF Based app like LivePerson.com

[Stephen M Aylor]

Anyone seen a cf based app like this co's deal ... www.liveperson.com.

Basically .. chat thru a browser.  Aymeric Grassart had a cool chat app a
while back, but I dont know if it ever turned into a "product" per se.

Tips, links et al appreciated.

All the best,

Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple file uploads

[Matt Wisdom]

It's actually very simple to accomplish. CFFile looks for the name of the
form field, so you have to make sure to match these up. In general, the way
you do it is to set up a global variable with the number of the form fields
that you want. Then you dynamically name and reference the upload form
fields with a numbered suffix, and use CFLoop to handle them all. I've found
that sometimes the form fields exist even if there is no file, so you should
verify both that a given form field exists as well as it has length GT 0
before you run CFFile on it.

Matt


> -Original Message-
> From: Kevin Willyerd [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 4:37 PM
> To: CF-Talk
> Subject: Multiple file uploads
>
>
> Is it possible to upload 5 different files from the same form?  The
> only way I can get it to work is to use a seperate template for each
> file.
>
> Kevin
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: And the award goes to ......

[Stephen M Aylor]

Must be all that Govt sponsored health care up there ... helping fund a
master race or something.

Triple Digit IQ's?  From the land of Beer , Hockey players, and grumpy
French tourists? :-)

I digress further  Its what Canada "doesnt" have thats the difference.
A boatload of Blue Hairs who vote 2x in NYC and Florida

- Original Message -
From: "Marcus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 2:47 PM
Subject: RE: And the award goes to ..


> > And in Canada it takes only 4 hours to count 15 million votes. So what
> > do they have that Florida doesn't.
>
> Triple digit IQ's?
>
> Marcus
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Virus protection for upload/download files?

[Matt Wisdom]

One technique is to use a virus scanner in your backup software. I don't
know of any tags -- I just did a search for "virus" on the Allaire
DevExchange and found none.

Matt

> -Original Message-
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 2:13 PM
> To: CF-Talk
> Subject: Virus protection for upload/download files?
>
>
> Our CF app allows users to upload files to the server, and offers
> those files for download to certain other users.
>
> Does anyone have any recommendations for a virus scan program
> that will scan files on a Linux system for PC, Mac, and Unix
> viruses?
>
>
>
>
> --
> -
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>
> To put this contact information into your Palm device, click here:
> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF vs. Lotus Domino App Server

[Dave Watts]

> I believe my biggest complaint is that I have never seen
> anyone try to implement security on more than one of those 
> levels.

We've been implementing user- and group-level security within our
applications for years.

> > Their is no reason that the problem you described below 
> > (avoiding security by knowing a documents URL) can't easily 
> > be eliminated. Using a path above the wwwRoot and other 
> > security precautions OR storing the files in a BLOB in
> > the Database server will take care of the problem.
> 
> BLOB?   That's a new acronym for me.

"Binary Large OBject", if I recall correctly. Most databases will allow you
to store binary data within BLOB datatypes. In any case, the point that Eric
is making is that you can implement the same level of security within CF
applications that you can within Notes/Domino applications. If you store
files in BLOB fields, you can use user rights within the database to manage
access to resources.

Alternatively, you can use a single login to the database, and use a
user/group access scheme within application code. For web applications, this
has some advantages over using database logins for individuals. Typically,
this requires the use of some authentication resource, such as an LDAP
server, NT domain SAM, or simply database tables to store users, groups, and
security contexts (which essentially boil down to intersections of users and
groups with other objects).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CPU 100% (again, sorry)

[Robert Everland III]

Does your memory utilization go up when this happens? I have found when
quering a huge database if the memory goes up while the cpu is at 100% it's
because of database if cpu is just at 100% there is bad code somewhere. If
all the drivers are updated (mdac that is) and you're running a normal
webserver, be it SQL, Access (orcale maybe could be a problem there) there
shouldn't be a problem. Double check and recheck that code especially if
it's spreading where it wasn't before.


Bob Everland

-Original Message-
From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 6:03 PM
To: CF-Talk
Subject: CPU 100% (again, sorry)


Sorry to post about this again, but I went through the archives and did not
see any definitive resolution of the problem.

We've had some problems on one particular server and always put it down to
bad code, but it turns out the dreaded 100% CPU utilization bug is spreading
to our other servers too.

Was the problem ever solved satisfactorily? Or pinpointed to a particular
release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)?

Michel Vuijlsteke
Netpoint NV
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF-Studio 4.52

[Kay Smoljak]

On Fri, 05 Jan 2001 09:58:59 -0500, "Sean Daniels"
<[EMAIL PROTECTED]> wrote:

>OK, so I really want to update to 4.5.2, particularly for the "remembering
>that your in an RDS session". However, I have customized the crap out 4.5.1
>and I am scared off by these mails that say the 4.5.2 installer kills your
>snippet and hotkey settings.
>
>Is there any way to back these up? Or have they fixed this prob in the
>newest installer?
>
>- Sean

I've had to reinstall Studio a number of times - new PC, then new OS, both
at work and at home - and all I do to save my studio settings (esp colors -
I have a highly customised color set up that takes AGES to redo) is find and
save the Studio registry keys. You can do the same with the RDS/FTP key. And
I always save the userdata dir and copy the contents over to the new
install. The only thing to watch for is that the installed dir is the same
on both the old and new installs otherwise you'll have to do some registry
hacking to get it to work.

HTH,
K.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF vs. Lotus Domino App Server

[Benjamin S. Rogers]

> BLOB?   That's a new acronym for me.

http://whatis.techtarget.com/WhatIs_Search_Results_Exact/1,282033,,00.html?q
uery=blob

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Multiple Servers - Cluster Cats

[Jon Hall]

Win2k Advanced Server's built in clustering and failover software is very
slick and easy to use.

jon
- Original Message -
From: "Kirk Boecker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 2:10 PM
Subject: Multiple Servers - Cluster Cats


> Sorry for the slightly OT post,
>
> We have a server pair running our main CF application, both are DELL
> enterprise servers,
> (1 running win2k, IIS and CF 4.5 and the other running SQL server 7).
>
> We are not maxing out the server at all but we need some type of failover
> security
> (last week we had a motherboard in the DB server take a dump on us).
>
> We are thinking of setting up some type of cluster (cluster cats?) or some
> type of
> mirrored set of servers to take over if something goes wrong.
>
> Does anyone have any experience setting up Cluster Cats or any other solid
> backup/failover server system?
>
> Kirk Boecker
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: AvantGo channels w/CF?

[dougn]

I'd say the easier route is just to use the AvantGo caching code at the
beginning of the page and keep the page static.  That way if your page
updates hourly, it will only get hit once an hour by the AvantGo proxy and
all their customers will get pages from them during that hour, at which time
it expires and they get the updated page.  No CFSchedule to worry about and
it keeps the load on your server extremely light.

--Doug

-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 2:06 PM
To: CF-Talk
Subject: RE: AvantGo channels w/CF?


Just an out of blue suggestion, but why don't you call a page that activates
a  tag, then uses  to actually return the contents of
your page... That way the AvantGo server only accesses an html page and your
server does the work of rendering the page I've been playing with
different aspects of AvantGo channels myself and that's the easiest way I
could think of doing what you want to do.

It's a faff if you've got a lot of pages Then again cfschedule is pretty
flexible...

Just some late night thoughts after a long day, please forgive me if it
doesn't make any sense...

-= Ed

> -Original Message-
> From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
> Sent: 8 January 2001 8:03 PM
> To: CF-Talk
> Subject: AvantGo channels w/CF?
>
>
> Has anyone done any work with creating an AvantGo channel on a
> CF-based web
> site? (AvantGo is an offline web browser for Palms and WinCE devices)
>
> I've created a test for a client demo. It basically pulls press releases
> from a database, removes any HTML formatting, and outputs it as very
> simplified HTML for the Palm. It works fine if I load the page up in
> Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
> the RAM usage on my CF server skyrockets. I've already tried playing with
> caching, changing page sizes, etc and even if it is just one or two simple
> pages, CF begins using memory like crazy.
>
> We're running CF 4.5 sp1 on a Windows NT 4.0 server.
>
> Thanks,
>
> Matthew I. Fusfield
> Senior Web Systems Developer
> InterActive Network Systems, Inc.
> [EMAIL PROTECTED] - 856-227-4428 ext 15
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: The mysterious CFSCRIPT...... Help

[Robert Everland III]

cfscript is like a dumbed down version of JavaScript, very limited cf in it,
it is good for where you would normally do a lot of cfsets or where there is
huge conditional logic because I have found cfscript throws no whitespace.
An example of cfscript would be something  like this


hey

hola

if (this is that)
{
writeoutput("hey");
}
else
{
writeoutput("hola");
}


There is a lot of documentation on cfscript under the loaded documentation,
it's chapter 20 under Developing Web Applications with ColdFusion


Bob Everland

-Original Message-
From: Jeff W [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:58 PM
To: CF-Talk
Subject: The mysterious CFSCRIPT.. Help


I am interesting in learning cfsript

Has anyone seen any tutorials on the web? Is there any books written on it??
To me it seems there is not alot information in even the current cold fusion
books about it. I know its supposed to be simmilar to javascript and
somewhat asp. I've seen SOME cfscript examples. I've seen some conversions
from ASP to CFSCRIPT...

Ideas and Suggestions are GREATLY appreciated.

Jeff
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL High Volume

[Gordon Burns]

If you want a really fast post engine that you can configure I
would certainly try Howie's IMs.  
http://www.coolfusion.com

Gordon








At 15:24 23/01/01 -0500 William J Wheatley said
>we use ListServ HPO version
>www.lsoft.com
>
>touted as the best there is currently. We enjoy it.
>
>
>Bill Wheatley
>Director of Development
>AEPS INC
>Allaire ColdFusion Consulting Partner
>Allaire Certified ColdFusion Developer
>http://www.aeps.com
>ICQ: 417645
>http://www.aeps2000.com
>954-472-6684 X303
>
>IMPORTANT NOTICE:
>This e-mail and any attachment to it is intended only to be read or used by
>the named addressee.  It is confidential and may contain legally privileged
>information.  No confidentiality or privilege is waived or lost by any
>mistaken transmission to you.  If you receive this e-mail in error, please
>immediately delete it from your system and notify the sender.  You must not
>disclose, copy or use any part of this e-mail if you are not the intended
>recipient.  The RTA is not responsible for any unauthorized alterations to
>this e-mail or attachment to it
>
>
>-Original Message-
>From: Michael Goodwin [mailto:[EMAIL PROTECTED]]
>Sent: Monday, January 08, 2001 3:15 PM
>To: CF-Talk
>Subject: CFMAIL High Volume
>
>
>Hi list,
>
>I would appreciate some comments regarding using an application server like
>CFAS to generate emails from a list or database.  I have heard many "rumors"
>that for high volume email generation CFMAIL is not a very good choice.  If
>CF is not the best choice what other solutions have you been using?  Any
>comments would be appreciated.
>
>Thanks,
>
>Mike
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Multiple Servers - Cluster Cats

[Cary Gordon]

We have moved to ServerIron switches from Foundry Networks for load 
balancing and failover.  They are flexible and very fast.

Cary

At 11:10 AM 1/8/2001 -0800, you wrote:
>Sorry for the slightly OT post,
>
>We have a server pair running our main CF application, both are DELL
>enterprise servers,
>(1 running win2k, IIS and CF 4.5 and the other running SQL server 7).
>
>We are not maxing out the server at all but we need some type of failover
>security
>(last week we had a motherboard in the DB server take a dump on us).
>
>We are thinking of setting up some type of cluster (cluster cats?) or some
>type of
>mirrored set of servers to take over if something goes wrong.
>
>Does anyone have any experience setting up Cluster Cats or any other solid
>backup/failover server system?
>
>Kirk Boecker


Cary Gordon
The Cherry Hill Company


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Multiple Servers - Cluster Cats

[Kirk Boecker]

thanks for all the info

what is the cost of the BIGIP controller? which model are you using?

kirk


- Original Message -
From: "Kurt Ward" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 2:01 PM
Subject: RE: Multiple Servers - Cluster Cats


> I'm not sure what to expensive amounts to, but we use a hardware based
> load balancing system (Big IP www.bigip.com) that works very well for the
> web servers (a farm of three, with central data storage).  For our SQL
> Servers, we also use a central data server for the DB's with the load
> between 2 servers.  For failover of both systems, we have backup file
> servers for the data.
>
> Kurt
>
> -Original Message-
> From: Kirk Boecker [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 3:14 PM
> To: CF-Talk
> Subject: Re: Multiple Servers - Cluster Cats
>
>
> oops,, i guess i should have mentioned that we are/will purchase
> hardware/software
> as needed - just looking for suggestions on which systems actualy work.
>
> looking into cluster cats, MSCS, NSI and anything else that may do the
trick
> hopefully easy and not to expensive
>
> kirk
>
>
>
> - Original Message -
> From: "Sean Daniels" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 08, 2001 11:42 AM
> Subject: RE: Multiple Servers - Cluster Cats
>
>
> >
> > > Does anyone have any experience setting up Cluster Cats or any other
> solid
> > > backup/failover server system?
> >
> > ClusterCats is a software based web server load balancing service. It
will
> > do you absolutely no good if your DB server dumps it's motherboard
again.
> > For true fault tolerance you would need at least two web servers load
> > balanced with ClusterCats (or any other software or hardware based load
> > balancer) AND at least two DB servers running in a Active/Passive or
> > Active/Active cluster configuration.
> >
> > The latter is very tricky and expensive to achieve, unfortunately.
> >
> > By the way, I have very little experience in actually doing this, only
> > researching it for my own servers.
> >
> > - Sean
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Storing images in SQL

[Rick Lamb]

Larry,

I've asked this question before also. And got similar responses as yours
which is appreciated. But is there any way you could tell us (a number of
people have asked this question) why it's slower and messier. I'm sure for
somebody that knows the details on what it takes to do this can logically
agree with you (and others who have said the same) and I too would like to
be one of those well informed people that come to the same conclusion for
the same reasons. Could you or anyone else familiar with the techniques
required for this please elaborate on this so I can say something other than
"it's a bad idea because that's what somebody said."

Thanks,

Rick

-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:28 PM
To: CF-Talk
Subject: Re: Storing images in SQL


Michael,

In a nutshell don't. Its far faster, easier and a lot less messy to
store the images's name and then dynamically construct the path
information.

regards,
larry

--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--


Michael Buffington wrote:
>
> Does anyone have any experience storing images in SQL 7.0, and retrieving
> them in CF?
>
> Any tips would help!
>
> Michael Buffington
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Differences between OLE DB and ODBC

[Bernd VanSkiver]

ODBC requires translation between the source and destination...OLE DB does
not which makes OLE DB faster

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324


-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:14 PM
To: CF-Talk
Subject: Differences between OLE DB and ODBC


Hope someone can help in any way...

I posted this message early this morning, and have received no responses. If
any one has any clue, no matter how insignificant, or if you have any ideas
as to where i can find out more details about the differences between OLE DB
and ODBC, please post them.

Thank you.


***
Good morning all,

I Created a page that accesses the same database table but with two
different datasources as shown below:

 
SELECT *
FROM TeaserUsers


 
SELECT *
FROM TeaserUsers


I outputted the total record count for each query in the following way:

 
 #FindUsers.recordcount# users found under OLE
 #FindUsers_odbc.recordcount# users found under ODBC
 


Here are my results:
5 users found under OLE
76 users found under ODBC


Queries

FindUsers (Records=5, Time=250ms)
SQL =
SELECT *
FROM TeaserUsers

FindUsers_odbc (Records=76, Time=31ms)
SQL =
SELECT *
FROM TeaserUsers


Why is it that OLE DB is reporting only 5 records, while ODBC is reporting
ALL of them as it should be, based on the query?

Any help will be greatly appreciated!

Andres
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Storing images in SQL Imaging database?

[Jon Hall]

This topic came up a long time ago on the list. Someone gave out a url for a
very nice image database that was done in java with a cf frontend. Anyone
know the url?

jon
- Original Message -
From: "Larry C. Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 4:27 PM
Subject: Re: Storing images in SQL


> Michael,
>
> In a nutshell don't. Its far faster, easier and a lot less messy to
> store the images's name and then dynamically construct the path
> information.
>
> regards,
> larry
>
> --
> Larry C. Lyons
> ColdFusion/Web Developer
> EBStor.com
> 8870 Rixlew Lane, Suite 201
> Manassas, Virginia 20109-3795
> tel: (703) 393-7930 x253
> fax: (703) 393-2659
> http://www.ebstor.com
> http://www.pacel.com
> email: [EMAIL PROTECTED]
>
> Chaos, panic, and disorder - my work here is done.
> --
>
>
> Michael Buffington wrote:
> >
> > Does anyone have any experience storing images in SQL 7.0, and
retrieving
> > them in CF?
> >
> > Any tips would help!
> >
> > Michael Buffington
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: AvantGo channels w/CF?

[dougn]

Yes.  Autobytel.com has an AvantGo channel and I've created two other
channels for other projects.

Are you using the AvantGo caching?  Realize that what is happening is
AvantGo is acting as a spider and downloading ALL the pages linked off the
home page and subsequent pages all at once.  As a result your traffic to
your web server can be very intense.  If you use their caching, however, all
that content is cached at AvantGo and the requests don't hit your network
until the cache expires (based upon a time span you set).  That way if you
have 1000 users downloading 20 pages each time, it is just 20 hits to your
server.  Without caching it would be 20,000.

--Doug

-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 12:03 PM
To: CF-Talk
Subject: AvantGo channels w/CF?


Has anyone done any work with creating an AvantGo channel on a CF-based web
site? (AvantGo is an offline web browser for Palms and WinCE devices)

I've created a test for a client demo. It basically pulls press releases
from a database, removes any HTML formatting, and outputs it as very
simplified HTML for the Palm. It works fine if I load the page up in
Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
the RAM usage on my CF server skyrockets. I've already tried playing with
caching, changing page sizes, etc and even if it is just one or two simple
pages, CF begins using memory like crazy.

We're running CF 4.5 sp1 on a Windows NT 4.0 server.

Thanks,

Matthew I. Fusfield
Senior Web Systems Developer
InterActive Network Systems, Inc.
[EMAIL PROTECTED] - 856-227-4428 ext 15
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query confusion - CF not recognising query name

[Jann VanOver]

Are you talking to SQL Server?  I don't think it likes the table name
"Users"  Try putting square brackets around the table name, eg. "[Users]"
and see if that helps.

AND run it with debugging on to show the SQL and the result.  This will let
you know whether the SQL is actually being executed and how many rows it
returns.

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:49 AM
To: CF-Talk
Subject: Query confusion - CF not recognising query name


I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me

Here's the code;

select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by #form.OrderBy#



Here's the error;
An error occurred while evaluating the expression:

 variables.IDCount=getPeopleInfo.RecordCount

Error near line 527, column 8.

Error resolving parameter GETPEOPLEINFO.RECORDCOUNT

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.


I've tried putting a CFLoop straight after the query and it comes back that
the query doesn't exist - but I know it does (obviously)

It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CPU 100% (again, sorry)

[Michel Vuijlsteke]

Sorry to post about this again, but I went through the archives and did not
see any definitive resolution of the problem.

We've had some problems on one particular server and always put it down to
bad code, but it turns out the dreaded 100% CPU utilization bug is spreading
to our other servers too.

Was the problem ever solved satisfactorily? Or pinpointed to a particular
release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)?

Michel Vuijlsteke
Netpoint NV

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF vs. Lotus Domino App Server

[Jeffry Houser]

Eric Barr wrote:

> What you are describing is just development that was done poorly.
> Implementing a fairly robust security system on the web really takes some
> for though and planning.  Not only are you in an uncontrolled environment
> you also now have 3 (or possibly more) layers of security to deal with.

  Yes, agreed.  I believe my biggest complaint is that I have never seen
anyone try to implement security on more than one of those levels.



> Their is no reason that the problem you described below (avoiding security
> by knowing a documents URL) can't easily be eliminated. Using a path above
> the wwwRoot and other security precautions OR storing the files in a BLOB in
> the Database server will take care of the problem.

   BLOB?   That's a new acronym for me.


> To your point about the user level security: Major RDBMS all have the user
> level security that you are talking about in Notes and usernames and
> passwords could be implemented for each user and CF could pass the users
> credentials with every query.  Although, I suspect that you wouldn't really
> want to.

I can't speak beyond SQL Server, however every site I've dealt with
has had one user on it, with 'God Level' access.  I implemented a slightly
more complicated form of security, with two levels.  (I.E. The company
had god level access, registered users had slightly less, anonymous users
had slightly less than that) but was told by the hosting company that they
would only set us up with one user.

--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 4.5  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF users in Montana

[Russel Madere]

No, those were the members of the Coral Reefers that quit in Jimmy Buffett's
dream.

"We want a raise, or we're gonna quit!"

;)

Sorry to the list, I couldn't resist.


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



> -Original Message-
> From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 14:06
> To: CF-Talk
> Subject: Re: CF users in Montana
>
>
> I hear there are a coupla cows over in Missoula who wrote the  tag
> :)
>
>
>
> > Yup!
> >
> > Jay Patton
> > Web Pro USA
> > 406.549.3337 ext. 203
> > 1.888.5WEBPRO
> > www.webpro-usa.com
> > - Original Message -
> > From: "Jason Larson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, January 08, 2001 12:37 PM
> > Subject: CF users in Montana
> >
> >
> > >
> > > I was wondering if there is any cf developers here in Montana?
> > >
> > > Jason Larson
> > > [EMAIL PROTECTED]
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL High Volume

[Kym Kovan]

Hi Mike,

>I would appreciate some comments regarding using an application server like
>CFAS to generate emails from a list or database.  I have heard many "rumors"
>that for high volume email generation CFMAIL is not a very good choice.

Indeed so, or for ultra-reliable mail delivery..

>If
>CF is not the best choice what other solutions have you been using?

We use the Special Edition iMS POST server from Coolfusion.com (or us ), 
with its accompanying CFX_IMSMail tag as a replacement for cfmail on all 
our production servers that use mail seriously. It is extremely reliable 
and its bad-mail handling, logging, etc. is excellent.

POST SE is just the POST portion of the full iMS mail server so it is cheap 
and does not load the machine down with unnecessary stuff.




--

Yours,

Kym


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: And the award goes to ......

[Marcus]

> And in Canada it takes only 4 hours to count 15 million votes. So what
> do they have that Florida doesn't.

Triple digit IQ's?

Marcus

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHEADER

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Just a guess...  Try replacing attachment with inline in the CFHEADER
value.  That might convince the browser to display the PDF instead of
saving it, but it would still allow the proper filename to come
through if the user did decide to save it by hand.

Hope that helps,
Zac Bedell

> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 1:34 PM
> To: CF-Talk
> Subject: CFHEADER
> 
> 
> It seems the following won't work, well in at least IE5.5.  
> 
>  VALUE="attachment;filename=#attributes.fname#">
> 
> 
> It instead opens the page up for download instead of the 
> file.  So lets say
> I have peter.pdf as my attributes.fname and download.cfm is 
> the page the
> above code is on.  And lets say that it's called from index.cfm. 
> Well index.htm appears in the download file box, not peter.pdf.  
> It seems to work
> ok in Netscape, so I can't believe I'm the only one having 
> this problem.
> I've seen similar looking code on the Allaire site, but it's still
> not working.  Can anyone help with this?
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: The mysterious CFSCRIPT...... Help

[Park, Simon]

If you get Ben Forta's Advanced ColdFusion Development book, he has a whole
chapter on CFSCRIPT.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park  Computer Systems Management, Inc.
Ph: 703-823-4300 x119   205 South Whiting Street #201
fax: 703-823-4301   Alexandria, VA  22304
 http://www.csmi.com  

> -Original Message-
> From: Jeff W [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 3:58 PM
> To: CF-Talk
> Subject: The mysterious CFSCRIPT.. Help
> 
> 
> I am interesting in learning cfsript
> 
> Has anyone seen any tutorials on the web? Is there any books 
> written on it??
> To me it seems there is not alot information in even the 
> current cold fusion
> books about it. I know its supposed to be simmilar to javascript and
> somewhat asp. I've seen SOME cfscript examples. I've seen 
> some conversions
> from ASP to CFSCRIPT...
> 
> Ideas and Suggestions are GREATLY appreciated.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Does Studio have Built-in Scripting?

[Clint Tredway]

I use Note Tab because of it's internal scripting language or I use my
DevAssistant. The DevAssistant is CF based and can build forms,stored
procedures, and more.


-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:15 PM
To: CF-Talk
Subject: Re: Does Studio have Built-in Scripting?


> I just wish that Studio had an "on the fly" MACROS capability to capture
> and replay keystrokes or mouse clicks -- man would that save a big bunch
of
> time (and brain cells) when doing detailed, redundant, repetitive work.

I ususally end up writing small vb aps that use the windows api functions to
create macros.  Sure, it takes a little bit more time than if there were
macros, but you have more flexibility and much more power that way.  Visual
Basic isn't a difficult language to learn either.  Go down to your local
software store and pick up Microsoft's Learn Visual Basic 6 for about $80.00
and you'll be set.

--Greg
- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 3:21 PM
Subject: Re: Does Studio have Built-in Scripting?


> I just wish that Studio had an "on the fly" MACROS capability to capture
> and replay keystrokes or mouse clicks -- man would that save a big bunch
of
> time (and brain cells) when doing detailed, redundant, repetitive work.
>
> Dru
> 303 666-7665
>
> At 14:00 1/8/2001 -0600, you wrote:
> >
> >Is there a way to set up scripts to run and do something within studio.
> >Something like writing the Last Modified Date to a comment field when the
> >file is saved?  I know other programs have some of their own built-in
> >scripting.  Does Studio, and if so, where do I find it?
> >
> >Thanks.
> >
> >Vance Duke
> >Cold Fusion Application Developer
> >i2 Technologies
> >(469) 357-4729
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Multiple file uploads

[Kevin Willyerd]

Is it possible to upload 5 different files from the same form?  The
only way I can get it to work is to use a seperate template for each
file. 

Kevin

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Does Studio have Built-in Scripting?

[Matt Rodosky]

read up on and use snippets...

-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 1:22 PM
To: CF-Talk
Subject: Re: Does Studio have Built-in Scripting?


I just wish that Studio had an "on the fly" MACROS capability to capture
and replay keystrokes or mouse clicks -- man would that save a big bunch of
time (and brain cells) when doing detailed, redundant, repetitive work.

Dru
303 666-7665

At 14:00 1/8/2001 -0600, you wrote:
>
>Is there a way to set up scripts to run and do something within studio.
>Something like writing the Last Modified Date to a comment field when the
>file is saved?  I know other programs have some of their own built-in
>scripting.  Does Studio, and if so, where do I find it?
>
>Thanks.
>
>Vance Duke
>Cold Fusion Application Developer
>i2 Technologies
>(469) 357-4729
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: AvantGo channels w/CF?

[Edward Chanter]

Just an out of blue suggestion, but why don't you call a page that activates
a  tag, then uses  to actually return the contents of
your page... That way the AvantGo server only accesses an html page and your
server does the work of rendering the page I've been playing with
different aspects of AvantGo channels myself and that's the easiest way I
could think of doing what you want to do.

It's a faff if you've got a lot of pages Then again cfschedule is pretty
flexible...

Just some late night thoughts after a long day, please forgive me if it
doesn't make any sense...

-= Ed

> -Original Message-
> From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
> Sent: 8 January 2001 8:03 PM
> To: CF-Talk
> Subject: AvantGo channels w/CF?
>
>
> Has anyone done any work with creating an AvantGo channel on a
> CF-based web
> site? (AvantGo is an offline web browser for Palms and WinCE devices)
>
> I've created a test for a client demo. It basically pulls press releases
> from a database, removes any HTML formatting, and outputs it as very
> simplified HTML for the Palm. It works fine if I load the page up in
> Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
> the RAM usage on my CF server skyrockets. I've already tried playing with
> caching, changing page sizes, etc and even if it is just one or two simple
> pages, CF begins using memory like crazy.
>
> We're running CF 4.5 sp1 on a Windows NT 4.0 server.
>
> Thanks,
>
> Matthew I. Fusfield
> Senior Web Systems Developer
> InterActive Network Systems, Inc.
> [EMAIL PROTECTED] - 856-227-4428 ext 15
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple Servers - Cluster Cats

[Kurt Ward]

I'm not sure what to expensive amounts to, but we use a hardware based
load balancing system (Big IP www.bigip.com) that works very well for the
web servers (a farm of three, with central data storage).  For our SQL
Servers, we also use a central data server for the DB's with the load
between 2 servers.  For failover of both systems, we have backup file
servers for the data.

Kurt

-Original Message-
From: Kirk Boecker [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:14 PM
To: CF-Talk
Subject: Re: Multiple Servers - Cluster Cats


oops,, i guess i should have mentioned that we are/will purchase
hardware/software
as needed - just looking for suggestions on which systems actualy work.

looking into cluster cats, MSCS, NSI and anything else that may do the trick
hopefully easy and not to expensive

kirk



- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 11:42 AM
Subject: RE: Multiple Servers - Cluster Cats


>
> > Does anyone have any experience setting up Cluster Cats or any other
solid
> > backup/failover server system?
>
> ClusterCats is a software based web server load balancing service. It will
> do you absolutely no good if your DB server dumps it's motherboard again.
> For true fault tolerance you would need at least two web servers load
> balanced with ClusterCats (or any other software or hardware based load
> balancer) AND at least two DB servers running in a Active/Passive or
> Active/Active cluster configuration.
>
> The latter is very tricky and expensive to achieve, unfortunately.
>
> By the way, I have very little experience in actually doing this, only
> researching it for my own servers.
>
> - Sean
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: The mysterious CFSCRIPT...... Help

[Michael Dinowitz]

www.houseoffusion.com/script.ppt

Michael Dinowitz
Publisher: Fusion Authority weekly news alert
(www.fusionauthority.com/alert)
Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
(www.houseoffusion.com)



> I am interesting in learning cfsript
>
> Has anyone seen any tutorials on the web? Is there any books written on
it??
> To me it seems there is not alot information in even the current cold
fusion
> books about it. I know its supposed to be simmilar to javascript and
> somewhat asp. I've seen SOME cfscript examples. I've seen some conversions
> from ASP to CFSCRIPT...
>
> Ideas and Suggestions are GREATLY appreciated.
>
> Jeff
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple Resultsets from a Stored Procedure

[LKHaas]

I have all the variables in the correct order - the procedure will run fine
- the errors come into play when I add the cfprocresult tag for resultset
one and two.  There are three main select statements in the procedure (the
third being the simplest and the one which returns the data).  They are not
separated in the stored procedure (no begin/end or anything) - could this
possibly be the problem?  I have never managed to have a stored procedure
with multiple resultsets work (with this particular sp writer) with the
exception of the last returned resultset.  Any ideas are greatly
appreciated.

Lisa Haas

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 4:21 PM
To: [EMAIL PROTECTED]
Subject: RE: Multiple Resultsets from a Stored Procedure



Yeah, that confuses me too. That's one for the list at large - although not
necessarily relevant to the current problem. My guess is the Microsoft
makes the odbc drivers, and that they're SQL Server compatible; Sybase and
SQL Server have an intertwined history after all. Are there other pages you
have where multiple resultsets work?

Mark


Also - I'm not sure why it says [INTERSOLV][ODBC SQL Server driver] since I
am using a Sybase System 11 driver...

Lisa

-Original Message-
From: Haas, Lisa
Sent: Monday, January 08, 2001 3:55 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Multiple Resultsets from a Stored Procedure


Yes - see below:  What I'm now finding is that the third resultset has no
problem.  The first two give me the error ODBC Error Code = S1002 (Invalid
column number) Number of bound columns exceeds the number of result
columns.















-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Resultsets from a Stored Procedure



Lisa,

Are you refering to your resultsets by number? I do this all the time with
SQL Server, and I doubt it's too different... of course I don't understand
how the [Intersolv] figures in, so I may be missing something in your
posts.

Mark

Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD  20708-4038
Ph: 301-497-5596   Email: [EMAIL PROTECTED]



I have always had trouble in handling output from stored procedures with
more than one result set.  I am using the resultset attribute of
cfprocresult with a Sybase stored procedure.  Has anyone else run into this
or come up with some reasons why this is such a problem?  Thanks.

Lisa Haas
The Kennedy Center








~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Multiple Servers - Cluster Cats

[net_man]

On of the best hardware tools to Load Balance with is F5's Big IP.  They are
easily scalable and can load balance as many servers as you have switch
space for.  It far surpasses Alteon in the way it load balances...

If you are interested in a demo email Janeen at [EMAIL PROTECTED] and she
will set it up...

Thanks,
Robert

- Original Message -
From: "Kirk Boecker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 3:14 PM
Subject: Re: Multiple Servers - Cluster Cats


> oops,, i guess i should have mentioned that we are/will purchase
> hardware/software
> as needed - just looking for suggestions on which systems actualy work.
>
> looking into cluster cats, MSCS, NSI and anything else that may do the
trick
> hopefully easy and not to expensive
>
> kirk
>
>
>
> - Original Message -
> From: "Sean Daniels" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 08, 2001 11:42 AM
> Subject: RE: Multiple Servers - Cluster Cats
>
>
> >
> > > Does anyone have any experience setting up Cluster Cats or any other
> solid
> > > backup/failover server system?
> >
> > ClusterCats is a software based web server load balancing service. It
will
> > do you absolutely no good if your DB server dumps it's motherboard
again.
> > For true fault tolerance you would need at least two web servers load
> > balanced with ClusterCats (or any other software or hardware based load
> > balancer) AND at least two DB servers running in a Active/Passive or
> > Active/Active cluster configuration.
> >
> > The latter is very tricky and expensive to achieve, unfortunately.
> >
> > By the way, I have very little experience in actually doing this, only
> > researching it for my own servers.
> >
> > - Sean
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Differences between OLE DB and ODBC

[Andres]

Hope someone can help in any way...

I posted this message early this morning, and have received no responses. If
any one has any clue, no matter how insignificant, or if you have any ideas
as to where i can find out more details about the differences between OLE DB
and ODBC, please post them.

Thank you.


***
Good morning all,

I Created a page that accesses the same database table but with two
different datasources as shown below:

 
SELECT *
FROM TeaserUsers

 
 
SELECT *
FROM TeaserUsers


I outputted the total record count for each query in the following way: 
 
 
 #FindUsers.recordcount# users found under OLE
 #FindUsers_odbc.recordcount# users found under ODBC
 


Here are my results:
5 users found under OLE
76 users found under ODBC


Queries

FindUsers (Records=5, Time=250ms)
SQL = 
SELECT *
FROM TeaserUsers

FindUsers_odbc (Records=76, Time=31ms)
SQL = 
SELECT *
FROM TeaserUsers


Why is it that OLE DB is reporting only 5 records, while ODBC is reporting
ALL of them as it should be, based on the query?

Any help will be greatly appreciated!

Andres
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF vs. Lotus Domino App Server

[Eric Barr]

What you are describing is just development that was done poorly.
Implementing a fairly robust security system on the web really takes some
for though and planning.  Not only are you in an uncontrolled environment
you also now have 3 (or possibly more) layers of security to deal with.

Their is no reason that the problem you described below (avoiding security
by knowing a documents URL) can't easily be eliminated. Using a path above
the wwwRoot and other security precautions OR storing the files in a BLOB in
the Database server will take care of the problem.

To your point about the user level security: Major RDBMS all have the user
level security that you are talking about in Notes and usernames and
passwords could be implemented for each user and CF could pass the users
credentials with every query.  Although, I suspect that you wouldn't really
want to.  In a given web application the Database server is usually the
bottleneck.  Adding a pile of users and security layering to it would slow
processing. But, if the need is great enough the means are available.
However, I suspect that a good deal of rewriting the application might be
necessary to support the security structure you might want.  You're time and
effort might be better spent devising a complete security model and
application flow.

Regards,
-eric

If to please people we offer what we ourselves disapprove, how can we
afterwards defend our work.
-George Washington

Eric Barr
Zeff Design
(p)  212.714.6390
(f)   212.580.7181


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 07, 2001 9:50 AM
To: CF-Talk
Subject: Re: CF vs. Lotus Domino App Server




Dave Watts wrote:

> > I just wanna say here, that I think Domino is a great
> > application and a great development environment. If you want
> > to create something on the web, though, it may not be the
> > best choice. I think the real benefit with Domino is security.
> > It has easily implementable page-level security, and Domino
> > won't let you in w/o authenticating you (depending on access
> > levels).
> >
> > All non domino web sites I've seen (ColdFusion, or otherwise)
> > use the 'if' statement method of security.
> >
> >   
> >   Display data
> >   
> >  Don't display data
> >   
> >
> > I know that this is functional, but I've never been comfortable
> > calling a site that uses this method 'secure.' If memory serves
> > me, CF does have some more advanced authentication functions
> > available (isAuthenticated, for instance) but I've never seen
> > them used.
>
> I'm not sure what you think is different about any of these security
> "methods". They all use the same conditional logic structure. I haven't
> worked with Notes or Domino, but authentication generally works the same
way
> for all systems:
>
> If the user is authenticated
> Then allow access
> Else
> Do something else (redirect the user, show an error message, show
> different data, whatever)
>
> This is true for operating systems, web applications, and anything else I
> can think of.
>
> Now, it may be true that Domino provides an interface which hides the
> details of authentication (which is all that CF's Advanced Security really
> does - and for complex applications this may not be a trivial thing), but
in
> the end, it all boils down to a simple conditional check.
>

  I guess what I attempting to get at was most implementations of security
(that I've seen) in ColdFusion are flawed.  It's not necessarily a CF
problem as
it is a
development problem.  ColdFusion is a form of middleware, so to speak.
The back end, being a database/file structure and the front end being HTML
(or flash or whatever).  Most all sites I've seen implement security on the
middle
tear (ColdFusion) without implementing anything on the back-end tear
(database/file
structure).

  One of the first CF sites I worked on showed users a page with a list of
PDFs.  However, if you knew the link directly to one of the PDFs, nothing
was stopping you from
getting to it.  In this case, a security implementation was implemented in
the middle tear
(CF) but not in the backend (I.E. file level).  Obviously a flawed
implementation of
security.

Coming from a Domino background, where every user has a unique sign in, and
that sign in determines database access, I've never been comfortable with
having a
single username / password on the database level.

--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 4.5  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~~
Structure your ColdFusio

Re: Does Studio have Built-in Scripting?

[Greg Wolfinger]

> I just wish that Studio had an "on the fly" MACROS capability to capture
> and replay keystrokes or mouse clicks -- man would that save a big bunch
of
> time (and brain cells) when doing detailed, redundant, repetitive work.

I ususally end up writing small vb aps that use the windows api functions to
create macros.  Sure, it takes a little bit more time than if there were
macros, but you have more flexibility and much more power that way.  Visual
Basic isn't a difficult language to learn either.  Go down to your local
software store and pick up Microsoft's Learn Visual Basic 6 for about $80.00
and you'll be set.

--Greg
- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 3:21 PM
Subject: Re: Does Studio have Built-in Scripting?


> I just wish that Studio had an "on the fly" MACROS capability to capture
> and replay keystrokes or mouse clicks -- man would that save a big bunch
of
> time (and brain cells) when doing detailed, redundant, repetitive work.
>
> Dru
> 303 666-7665
>
> At 14:00 1/8/2001 -0600, you wrote:
> >
> >Is there a way to set up scripts to run and do something within studio.
> >Something like writing the Last Modified Date to a comment field when the
> >file is saved?  I know other programs have some of their own built-in
> >scripting.  Does Studio, and if so, where do I find it?
> >
> >Thanks.
> >
> >Vance Duke
> >Cold Fusion Application Developer
> >i2 Technologies
> >(469) 357-4729
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Storing images in SQL

[Larry C. Lyons]

Michael,

In a nutshell don't. Its far faster, easier and a lot less messy to
store the images's name and then dynamically construct the path
information.

regards,
larry

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--


Michael Buffington wrote:
> 
> Does anyone have any experience storing images in SQL 7.0, and retrieving
> them in CF?
> 
> Any tips would help!
> 
> Michael Buffington

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Replacing Special Characters in Database

[Josh R]

OK, here's the problem.

We had to import our old databse into MS Access 97 and found that all the 
special characters in a memo field for product descriptions have gone crazy. 
ô and ö replaced ",  ù replaced —, Æ replaced ', etc.

So I need to go into the 2000+ fields we have and replace all these 
characters back to their proper settings without destroying the 
descriptions. (I tried using a query and looping over the replace feature, 
but it pasted the first description into all the other 2000 fields. NOT 
GOOD.)

What's the safest way to do this on a live databse?
Thanks for your help.

Josh Rubak
[EMAIL PROTECTED]
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: And the award goes to ......

[Larry C. Lyons]

And in Canada it takes only 4 hours to count 15 million votes. So what
do they have that Florida doesn't.

regards,
larry

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--

"Stephen R. Cassady" wrote:
> 
> >Handcount the votes ??? only in florida ??
> 
> And in Canada. All votes are hand counted. And we mark them with these itsy
> bitsy pencils.
> 
> :)
> 
> Stephen Cassady
> http://www.tallylist.com < FOR ADVANCED LIST ARCHIVING
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: HTTPS setup

[Sean Daniels]

> The key's all set up properly, but it just finds nothing if you
> browse to it...
> we've set the SSL port to be 443 in IIS, so it should know it
> exists. We've also
> set the IP and headers with that port.
>
> We're definitely using the URL the key was registered for.
>
> Any ideas?

You aren't sharing the IP address amongst sites are you? SSL doesn't support
host headers, so each site needs it's own IP address.

- Sean
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF users in Montana

[John Quarto-vonTivadar]

I hear there are a coupla cows over in Missoula who wrote the  tag
:)



> Yup!
>
> Jay Patton
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> www.webpro-usa.com
> - Original Message -
> From: "Jason Larson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 08, 2001 12:37 PM
> Subject: CF users in Montana
>
>
> >
> > I was wondering if there is any cf developers here in Montana?
> >
> > Jason Larson
> > [EMAIL PROTECTED]
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

AW: Javascript in Netscape

[Christoph Schmitz]

Hi Han,

you need to use "resizable" instead of "resizeable"... just drop the "e".

HTH,

Chris


> -Ursprüngliche Nachricht-
> Von: han peng [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 8. Januar 2001 09:19
> An: CF-Talk
> Betreff: Javascript in Netscape
>
>
> hey i had a prob
> i'm opening a new window with size 500,370.
> but for the link in there.. i wan the next page to be shown as
> full screen or at least can be resized...
> tried the codes below..
>  can work for IE.. but cant for netscape..
>
> any solution?
>
> cheers
> han
>
>
> File A:
> function openwin(location, x, y)
>   {
> para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y;
> msgWindow=window.open(location, "displaywindow", para);
>   }
>
> User ID
>
>
>
> userid.html :
> function openwin(location, x, y)
>   {
> para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y;
> msgWindow=window.open(location, "displaywindow", para);
>   }
>
> forgotten
>
> also tried this:
> forgotten
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query confusion - CF not recognising query name

[John McKown]

What about removing the "variables." scope?

John McKown, VP Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 Dover, DE 19901
email: [EMAIL PROTECTED] 
phone: 302-736-5515
fax: 302-736-5945
icq: 1495432



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 3:02 PM
> To: CF-Talk
> Subject: Re: Query confusion - CF not recognising query name
> 
> 
> I just took out the  and 
> #PreserveSingleQuotes(variables.whereList)# ---
> set some variables and it worked fine for me. What's in the wherelist??
> It ran fine for me. cf 4.01 on Windows 2000 server.
> 
> Jeff Craig
> 
> 
> 
> 
> 
> 
> select ID
> from #variables.peopleTable# (nolock)
> where ID in (#variables.IDList#)
> order by #form.OrderBy#
> 
> 
> #variables.idcount#
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Learning Javascript Books,

[Heather Haindel]

The best book we've got here at work for JavaScript is
"Professional JavaScript" (ISBN: 1-861002-70-X).

There's also IRT's JavaScript FAQ which has excellent
specific examples at
http://developer.irt.org/script/script.htm.

Heather
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

AW: Problem w/Frames & Netscape

[Christoph Schmitz]

Hi,

Netscape is not recognizing the end of the frameset, because you are missing
the "e" in ".

HTH,

Chris

> -Ursprüngliche Nachricht-
> Von: Paige Chandler [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 8. Januar 2001 04:01
> An: CF-Talk
> Betreff: Problem w/Frames & Netscape
>
>
> Hello All and Happy New Year,
>
> I have been working with a some new Frames architecture which
> displays fine in IE 5.5. I can't get NS 4.7 to display anything.
> I've even creatred a test page with the very basics below. IE
> displays "Can't find the page etc." When I insert the appropriate
> pages sources it displays them OK. But NS still displays nothing.
> Can you see what I'm doing wrong.  TIA.
>
> Regards,
>
> Paige
>
>
> 
>
> 
> 
>  Untitled
> 
>
>
>   
>   
>  
> 
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SOT: Re: Does Studio have Built-in Scripting?

[Todd Ashworth]

You could always try a third party macro tool like MacroMagic

http://www.iolo.com/macromagic/default1.htm

Todd Ashworth

- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 3:21 PM
Subject: Re: Does Studio have Built-in Scripting?


| I just wish that Studio had an "on the fly" MACROS capability to capture
| and replay keystrokes or mouse clicks -- man would that save a big bunch
of
| time (and brain cells) when doing detailed, redundant, repetitive work.
|
| Dru
| 303 666-7665



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

The mysterious CFSCRIPT...... Help

[Jeff W]

I am interesting in learning cfsript

Has anyone seen any tutorials on the web? Is there any books written on it??
To me it seems there is not alot information in even the current cold fusion
books about it. I know its supposed to be simmilar to javascript and
somewhat asp. I've seen SOME cfscript examples. I've seen some conversions
from ASP to CFSCRIPT...

Ideas and Suggestions are GREATLY appreciated.

Jeff




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHEADER

[Peter Benoit]

Naw, still not working... attempting to do it that way just locks up my
browser.  I've tried it on 3 machines here at work all with the same
results.  I have the latest service pack with IE, and apparently there was
some issue with this at some point, but it's still not working.

Anyone have a clue how they do it on the Allaire dev exchange?

-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:05 PM
To: CF-Talk
Subject: RE: CFHEADER


What about using CFCONTENT?

Try: 

This will prevent the user fron seeing the actual location of the PDF file.
Just the Address of the CFM template that includes this tag.

Russel


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: HTTPS setup

[Bob Silverberg]

I encountered a problem setting up multiple secure sites on the same server
using host headers.  If your sites currently all share the same IP address,
you can't set them all up on port 443.  The two solutions that I found were:
1. Set up each site on a separate port.
2. Give each site it's own IP address.

I'm not sure if that addresses your problem, but it's something I
encountered so I thought it would be worth sharing.

Bob


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: January 8, 2001 3:06 PM
To: CF-Talk
Subject: OT: HTTPS setup


Has anyone set up up HTTPS on an IIS server with multiple sites on it?

The key's all set up properly, but it just finds nothing if you browse to
it...
we've set the SSL port to be 443 in IIS, so it should know it exists. We've
also
set the IP and headers with that port.

We're definitely using the URL the key was registered for.

Any ideas?

David Cummins
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Phoeun Pha]

BAH, you don't need to specify a date it was entered in the first place
(unless u need it for some other reason).  just make sure you have some kind
of AUTO ID or increment for each record (u should anyways).  and in your
query, let it select the record with the highest Auto number (which is
always the record most recently entered, i hope).




-Original Message-
From: John Cowie [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 2:00 PM
To: CF-Talk
Subject: 


Hello everyone.  I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a hand with this.
Basically I am querying a database that has a series of records.  But
when I output the information from the database I only want to select
the newest record that was entered.  I have a field in the database that
keeps track of the time and date of the information entered.  

Here is the query statement that I am using.  I am able to sort the
content depending on the date but it still spits out all of the records
instead of just the "newest" one.


Select *
from UnitPages
where ArticleUnit = '#form.units#' 
order by ArticleDate DESC 



If anyone has an idea how to do this I would really appreciate your
help.

Thanks in advance

John
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL High Volume

[William J Wheatley]

we use ListServ HPO version
www.lsoft.com

touted as the best there is currently. We enjoy it.


Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303

IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it


-Original Message-
From: Michael Goodwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:15 PM
To: CF-Talk
Subject: CFMAIL High Volume


Hi list,

I would appreciate some comments regarding using an application server like
CFAS to generate emails from a list or database.  I have heard many "rumors"
that for high volume email generation CFMAIL is not a very good choice.  If
CF is not the best choice what other solutions have you been using?  Any
comments would be appreciated.

Thanks,

Mike


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Does Studio have Built-in Scripting?

[Dru Whitledge]

I just wish that Studio had an "on the fly" MACROS capability to capture
and replay keystrokes or mouse clicks -- man would that save a big bunch of
time (and brain cells) when doing detailed, redundant, repetitive work.

Dru
303 666-7665

At 14:00 1/8/2001 -0600, you wrote:
>
>Is there a way to set up scripts to run and do something within studio.
>Something like writing the Last Modified Date to a comment field when the
>file is saved?  I know other programs have some of their own built-in
>scripting.  Does Studio, and if so, where do I find it?
>
>Thanks.
>
>Vance Duke
>Cold Fusion Application Developer
>i2 Technologies
>(469) 357-4729
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple Resultsets from a Stored Procedure

[LKHaas]

To be more specific -- I get the error:

ODBC Error Code = S1002 (Invalid column number)
[INTERSOLV][ODBC SQL Server driver]Number of bound columns exceeds the
number of result columns.

I have just discovered that there are no problems with the 3rd resultset,
but the first two give me problems.  Could this be within the stored
procedure then?  It runs fine through DBArtisan, but does Cold Fusion have
preferences here?

Thanks again.

Lisa Haas


-Original Message-
From: Haas, Lisa 
Sent: Monday, January 08, 2001 2:19 PM
To: '[EMAIL PROTECTED]'
Subject: Multiple Resultsets from a Stored Procedure


I have always had trouble in handling output from stored procedures with
more than one result set.  I am using the resultset attribute of
cfprocresult with a Sybase stored procedure.  Has anyone else run into this
or come up with some reasons why this is such a problem?  Thanks.

Lisa Haas
The Kennedy Center

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Virus protection for upload/download files?

[Peter Theobald]

Our CF app allows users to upload files to the server, and offers those files for 
download to certain other users.

Does anyone have any recommendations for a virus scan program that will scan files on 
a Linux system for PC, Mac, and Unix 
viruses?




---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[Kevin Schmidt]

Set maxrows to 1
- Original Message -
From: "John Cowie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 1:59 PM
Subject: 


> Hello everyone.  I am running into a problem with my cfquery tag and I
> was wondering if anyone out there could give me a hand with this.
> Basically I am querying a database that has a series of records.  But
> when I output the information from the database I only want to select
> the newest record that was entered.  I have a field in the database that
> keeps track of the time and date of the information entered.
>
> Here is the query statement that I am using.  I am able to sort the
> content depending on the date but it still spits out all of the records
> instead of just the "newest" one.
>
> 
> Select *
> from UnitPages
> where ArticleUnit = '#form.units#'
> order by ArticleDate DESC
> 
>
>
> If anyone has an idea how to do this I would really appreciate your
> help.
>
> Thanks in advance
>
> John
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Multiple Servers - Cluster Cats

[Kirk Boecker]

oops,, i guess i should have mentioned that we are/will purchase
hardware/software
as needed - just looking for suggestions on which systems actualy work.

looking into cluster cats, MSCS, NSI and anything else that may do the trick
hopefully easy and not to expensive

kirk



- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 11:42 AM
Subject: RE: Multiple Servers - Cluster Cats


>
> > Does anyone have any experience setting up Cluster Cats or any other
solid
> > backup/failover server system?
>
> ClusterCats is a software based web server load balancing service. It will
> do you absolutely no good if your DB server dumps it's motherboard again.
> For true fault tolerance you would need at least two web servers load
> balanced with ClusterCats (or any other software or hardware based load
> balancer) AND at least two DB servers running in a Active/Passive or
> Active/Active cluster configuration.
>
> The latter is very tricky and expensive to achieve, unfortunately.
>
> By the way, I have very little experience in actually doing this, only
> researching it for my own servers.
>
> - Sean
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMAIL High Volume

[Michael Goodwin]

Hi list,

I would appreciate some comments regarding using an application server like
CFAS to generate emails from a list or database.  I have heard many "rumors"
that for high volume email generation CFMAIL is not a very good choice.  If
CF is not the best choice what other solutions have you been using?  Any
comments would be appreciated.

Thanks,

Mike


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[LKHaas]

In the cfoutput tag you can specify the maximum number of rows to show --
also if you use cfoufput without a query attribute, it will only output the
first row.

Lisa Haas
The Kennedy Center

-Original Message-
From: John Cowie [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:00 PM
To: CF-Talk
Subject: 


Hello everyone.  I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a hand with this.
Basically I am querying a database that has a series of records.  But
when I output the information from the database I only want to select
the newest record that was entered.  I have a field in the database that
keeps track of the time and date of the information entered.  

Here is the query statement that I am using.  I am able to sort the
content depending on the date but it still spits out all of the records
instead of just the "newest" one.


Select *
from UnitPages
where ArticleUnit = '#form.units#' 
order by ArticleDate DESC 



If anyone has an idea how to do this I would really appreciate your
help.

Thanks in advance

John
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Better than digest for list

[Stephen R. Cassady]

I stopped getting the non-digest format of this list because there were too
many posts/day, but scrolling through one digest email was cumbersome and
didn't give me a good feel to the events on the list.

I've increased www.tallylist.com 's list archiving functions to offer a 24
hour view of the posts, which I utilize daily now, reading CF discussions
(they used to just sit in an email folder).

Feedback is always appreciated.

Stephen Cassady
President, Ububik new media
[EMAIL PROTECTED]
403.271.0468

http://www.ububik.com http://www.tallylist.com http://www.spankmag.com




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

AvantGo channels w/CF?

[Matthew Fusfield]

Has anyone done any work with creating an AvantGo channel on a CF-based web
site? (AvantGo is an offline web browser for Palms and WinCE devices)

I've created a test for a client demo. It basically pulls press releases
from a database, removes any HTML formatting, and outputs it as very
simplified HTML for the Palm. It works fine if I load the page up in
Netscape or IE, but if I add the channel to AvantGo, every time I HotSync,
the RAM usage on my CF server skyrockets. I've already tried playing with
caching, changing page sizes, etc and even if it is just one or two simple
pages, CF begins using memory like crazy.

We're running CF 4.5 sp1 on a Windows NT 4.0 server.

Thanks,

Matthew I. Fusfield
Senior Web Systems Developer
InterActive Network Systems, Inc.
[EMAIL PROTECTED] - 856-227-4428 ext 15

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Simon Horwith]

Select *
from UnitPages
where ArticleUnit = '#form.units#' 
order by ArticleDate DESC 


~Simon

> Simon Horwith
> Allaire Certified ColdFusion Instructor
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: John Cowie [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:00 PM
To: CF-Talk
Subject: 


Hello everyone.  I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a hand with this.
Basically I am querying a database that has a series of records.  But
when I output the information from the database I only want to select
the newest record that was entered.  I have a field in the database that
keeps track of the time and date of the information entered.  

Here is the query statement that I am using.  I am able to sort the
content depending on the date but it still spits out all of the records
instead of just the "newest" one.


Select *
from UnitPages
where ArticleUnit = '#form.units#' 
order by ArticleDate DESC 



If anyone has an idea how to do this I would really appreciate your
help.

Thanks in advance

John
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query confusion - CF not recognising query name

[jeffc]

I just took out the  and #PreserveSingleQuotes(variables.whereList)# ---
set some variables and it worked fine for me. What's in the wherelist??
It ran fine for me. cf 4.01 on Windows 2000 server.

Jeff Craig






select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
order by #form.OrderBy#


#variables.idcount#


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF users in Montana

[Todd McFarlin]

Find me a nice log cabin on a 100 acre chunk of land near Yellowstone, with
a telecommute to work and then you can add another!

Todd

-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 11:38 AM
To: CF-Talk
Subject: CF users in Montana



I was wondering if there is any cf developers here in Montana?

Jason Larson
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query confusion - CF not recognising query name

[Benjamin S. Rogers]

It looks like your code has been greatly excerpted. There is no chance that
you are setting the variable getPeopleInfo equal to some simple value and
overwriting the query somewhere between the query and the loop? Is the name
of the query dynamic?

Sorry for the questions, but it seems very unlikely that ColdFusion would
behave this way. Any additional information would be useful.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 1:49 PM
To: CF-Talk
Subject: Query confusion - CF not recognising query name


I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me

Here's the code;

select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by #form.OrderBy#



Here's the error;
An error occurred while evaluating the expression:

 variables.IDCount=getPeopleInfo.RecordCount

Error near line 527, column 8.

Error resolving parameter GETPEOPLEINFO.RECORDCOUNT

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.


I've tried putting a CFLoop straight after the query and it comes back that
the query doesn't exist - but I know it does (obviously)

It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Does Studio have Built-in Scripting?

[Vance_Duke]

Is there a way to set up scripts to run and do something within studio.
Something like writing the Last Modified Date to a comment field when the
file is saved?  I know other programs have some of their own built-in
scripting.  Does Studio, and if so, where do I find it?

Thanks.

Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: HTTPS setup

[David Cummins]

Has anyone set up up HTTPS on an IIS server with multiple sites on it?

The key's all set up properly, but it just finds nothing if you browse to it...
we've set the SSL port to be 443 in IIS, so it should know it exists. We've also
set the IP and headers with that port.

We're definitely using the URL the key was registered for.

Any ideas?

David Cummins

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf-talk@houseoffusion.com

[John Cowie]

Hello everyone.  I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a hand with this.
Basically I am querying a database that has a series of records.  But
when I output the information from the database I only want to select
the newest record that was entered.  I have a field in the database that
keeps track of the time and date of the information entered.  

Here is the query statement that I am using.  I am able to sort the
content depending on the date but it still spits out all of the records
instead of just the "newest" one.


Select *
from UnitPages
where ArticleUnit = '#form.units#' 
order by ArticleDate DESC 



If anyone has an idea how to do this I would really appreciate your
help.

Thanks in advance

John



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHEADER

[Russel Madere]

What about using CFCONTENT?

Try: 

This will prevent the user fron seeing the actual location of the PDF file.
Just the Address of the CFM template that includes this tag.

Russel


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 13:46
> To: CF-Talk
> Subject: RE: CFHEADER
>
>
> No, would rather they could download it... and I don't wish the
> customer to
> know the location of the file
>
> -Original Message-
> From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 1:54 PM
> To: CF-Talk
> Subject: RE: CFHEADER
>
>
> Perhaps I'm missing something here (which is likely), but if you want to
> display a PDF file, why don't you just CFLOCATION to the PDF file, which
> will cause it to open in the user's browser (if they have the plug-in)?
>
> Bob
>
> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: January 8, 2001 1:34 PM
> To: CF-Talk
> Subject: CFHEADER
>
>
> It seems the following won't work, well in at least IE5.5.
>
>  VALUE="attachment;filename=#attributes.fname#">
> 
>
> It instead opens the page up for download instead of the file.
> So lets say
> I have peter.pdf as my attributes.fname and download.cfm is the page the
> above code is on.  And lets say that it's called from index.cfm.  Well
> index.htm appears in the download file box, not peter.pdf.  It
> seems to work
> ok in Netscape, so I can't believe I'm the only one having this problem.
> I've seen similar looking code on the Allaire site, but it's still not
> working.  Can anyone help with this?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF users in Montana

[Jay Patton]

Yup!

Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Jason Larson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 12:37 PM
Subject: CF users in Montana


>
> I was wondering if there is any cf developers here in Montana?
>
> Jason Larson
> [EMAIL PROTECTED]
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHEADER

[Peter Benoit]

No, would rather they could download it... and I don't wish the customer to
know the location of the file

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 1:54 PM
To: CF-Talk
Subject: RE: CFHEADER


Perhaps I'm missing something here (which is likely), but if you want to
display a PDF file, why don't you just CFLOCATION to the PDF file, which
will cause it to open in the user's browser (if they have the plug-in)?

Bob

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: January 8, 2001 1:34 PM
To: CF-Talk
Subject: CFHEADER


It seems the following won't work, well in at least IE5.5.




It instead opens the page up for download instead of the file.  So lets say
I have peter.pdf as my attributes.fname and download.cfm is the page the
above code is on.  And lets say that it's called from index.cfm.  Well
index.htm appears in the download file box, not peter.pdf.  It seems to work
ok in Netscape, so I can't believe I'm the only one having this problem.
I've seen similar looking code on the Allaire site, but it's still not
working.  Can anyone help with this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

anyone used the structsort() function?

[Aaron Johnson]

hey all,

I'm trying to sort a structure of structure by a key that's a datefield.. is
this possible using the structsort tag? and if so, what is the syntax for
this?  From the SP2 documentation I see this:

StructSort(Base [, SortType, SortOrder, PathToSubElement])

what are my choices for sorttype, sortorder and what is pathtoSubElement?

AJ


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple Servers - Cluster Cats

[Sean Daniels]

> Does anyone have any experience setting up Cluster Cats or any other solid
> backup/failover server system?

ClusterCats is a software based web server load balancing service. It will
do you absolutely no good if your DB server dumps it's motherboard again.
For true fault tolerance you would need at least two web servers load
balanced with ClusterCats (or any other software or hardware based load
balancer) AND at least two DB servers running in a Active/Passive or
Active/Active cluster configuration.

The latter is very tricky and expensive to achieve, unfortunately.

By the way, I have very little experience in actually doing this, only
researching it for my own servers.

- Sean
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF users in Montana

[Jason Larson]

I was wondering if there is any cf developers here in Montana?

Jason Larson
[EMAIL PROTECTED]

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query confusion - CF not recognising query name

[Russel Madere]

Actually, that's not right.  Either one will work.

I prefer  myself.

Have you run the query in a query analyzer?  If so, does it return results?

Also, are you catching a database error and not returning anything to the
client?


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



> -Original Message-
> From: t nelson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 13:17
> To: CF-Talk
> Subject: Re: Query confusion - CF not recognising query name
>
>
> here's a real silly question but is
>
>  written exactly like
>
> this or is it written like
>
>  leaving the # off
> could be your problem.
>
> cheers,
>
> nelson
>
>
> Original Message Follows
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Query confusion - CF not recognising query name
> Date: Mon, 08 Jan 2001 18:49:07 -
> Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
> MHotMailBC235737002ED82197E8CF1F7A8C1FA567; Mon Jan 08 11:06:20 2001
> Received: from houseoffusion.com ([207.31.122.140])  by
> www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID#
> 0-54969U100L100S0V35) with ESMTP id com  for
> <[EMAIL PROTECTED]>;  Mon, 8 Jan 2001 14:04:13 -0500
> From [EMAIL PROTECTED] Mon Jan 08 11:07:45 2001
> Message-id: <[EMAIL PROTECTED]>
>
> I've got some code running which SHOULD work, but isn't, and is confusing
> the hell out of me
>
> Here's the code;
> 
>   select ID
>   from #variables.peopleTable# (nolock)
>   where ID in (#variables.IDList#)
>   and #PreserveSingleQuotes(variables.whereList)#
>   order by #form.OrderBy#
> 
> 
>
> Here's the error;
> An error occurred while evaluating the expression:
>
>   variables.IDCount=getPeopleInfo.RecordCount
>
> Error near line 527, column 8.
>
> Error resolving parameter GETPEOPLEINFO.RECORDCOUNT
>
> ColdFusion was unable to determine the value of the parameter.
> This problem
> is very likely due to the fact that either:
>
> You have misspelled the parameter name, or
> You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL,
> or CFTABLE
> tag.
>
>
> I've tried putting a CFLoop straight after the query and it comes
> back that
> the query doesn't exist - but I know it does (obviously)
>
> It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Multiple Resultsets from a Stored Procedure

[LKHaas]

I have always had trouble in handling output from stored procedures with
more than one result set.  I am using the resultset attribute of
cfprocresult with a Sybase stored procedure.  Has anyone else run into this
or come up with some reasons why this is such a problem?  Thanks.

Lisa Haas
The Kennedy Center

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Visual Source Safe

[Russel Madere]

Ditto!

We have 8 developers, with 2 remote, on about 15 different "projects" in
VSS.

What's up?


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 12:46
> To: CF-Talk
> Subject: Re: Visual Source Safe
>
>
> Yes.
>
> Todd Ashworth
>
> - Original Message -
> From: "Nathan Stanford" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 08, 2001 1:35 PM
> Subject: Visual Source Safe
>
>
> | Has anyone used Visual Source Safe with ColdFusion and multiple
> programmers?
> |
> | Nathan Stanford
> | www.cfitpsplus.com
> | Free CF e-zine
> |
> |
> |
> |
> | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> |
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Visual Source Safe

[Nathan Stanford]

We are setting up Visual Source Safe at work.  We tried setting it up in the
past and I remember we had problems getting it working correctly with
projects and each developer.  What are the pitfalls and suggestions to get
around the problems.


Thanks,

Nathan Stanford
www.cftipsplus.com
Free e-zine

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Multiple Servers - Cluster Cats

[Kirk Boecker]

Sorry for the slightly OT post,

We have a server pair running our main CF application, both are DELL
enterprise servers,
(1 running win2k, IIS and CF 4.5 and the other running SQL server 7).

We are not maxing out the server at all but we need some type of failover
security
(last week we had a motherboard in the DB server take a dump on us).

We are thinking of setting up some type of cluster (cluster cats?) or some
type of
mirrored set of servers to take over if something goes wrong.

Does anyone have any experience setting up Cluster Cats or any other solid
backup/failover server system?

Kirk Boecker


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query confusion - CF not recognising query name

[t nelson]

here's a real silly question but is

 written exactly like

this or is it written like

 leaving the # off 
could be your problem.

cheers,

nelson


Original Message Follows
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Query confusion - CF not recognising query name
Date: Mon, 08 Jan 2001 18:49:07 -
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBC235737002ED82197E8CF1F7A8C1FA567; Mon Jan 08 11:06:20 2001
Received: from houseoffusion.com ([207.31.122.140])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
<[EMAIL PROTECTED]>;  Mon, 8 Jan 2001 14:04:13 -0500
>From [EMAIL PROTECTED] Mon Jan 08 11:07:45 2001
Message-id: <[EMAIL PROTECTED]>

I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me

Here's the code;

select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by #form.OrderBy#



Here's the error;
An error occurred while evaluating the expression:

  variables.IDCount=getPeopleInfo.RecordCount

Error near line 527, column 8.

Error resolving parameter GETPEOPLEINFO.RECORDCOUNT

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.


I've tried putting a CFLoop straight after the query and it comes back that
the query doesn't exist - but I know it does (obviously)

It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Hierarchial Display

[Michael Rosario]

This is a tree control I built for a school project.   It can contain
information that is as deep as you want to go..

http://www.eng.usf.edu/~mrosario/tree/xmlTree.xml

The XML looks like this



   
  http://www.yahoo.com')"/> 
  http://www.google.com')"/>
  http://www.metacrawler.com')"/>   
 


  http://www.cnn.com')"/>
  http://www.slashdot.org')"/>
  
 


  http://www.freshmeat.com')"/>
  http://www.w3c.org')"/>
  http://www.redhat.com')"/>
  http://www.mozilla.org')"/>
 



Enjoy!! :)   

-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 1:36 PM
To: CF-Talk
Subject: RE: Hierarchial Display


Wat do you mean by a tree structure?

At 05:51 PM 1/8/01 +, you wrote:
>Why not get the custom tag to populate a tree structure instead of a
>query? Then you can write another recursive custom tag to display the
>data much more easily.
>
>-Original Message-
>From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
>Sent: Monday, January 08, 2001 5:41 PM
>To: CF-Talk
>Subject: Hierarchial Display
>
>
>I am able to retrieve hierarchial data just fine using a nested custom tag,
>and this tag populates a query for me with the data.  However, I'm having a
>real problem with trying to figure out how to display it.  Here's an
>example of the data:
>
>0325 - Thomas - Graf -
>0645 - Robert - Nudo - 0325
>1392 - Joseph - Sheble - 0325
>0937 - Kimberly - Walters - 1392
>0674 - Lisa - Perez - 0937
>1450 - Jerome - Horowitz - 0325
>
>
>And I'd like it displayed thus:
>
>0325 - Thomas - Graf -
>- 0645 - Robert - Nudo - 0325
>- 1392 - Joseph - Sheble - 0325
> 0937 - Kimberly - Walters - 1392
> 0674 - Lisa - Perez - 0937
>- 1450 - Jerome - Horowitz - 0325
>
>However, there's no limit to the hierachy depth...  any ideas?
>
>
>Joseph E. Sheble
>[EMAIL PROTECTED]
>
>Wizaerd's Realm
>http://www.wizaerd.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Hierarchial Display

[Philip Arnold - ASP]

> Wat do you mean by a tree structure?

Think of it like a Family Tree (but with only females)

You start with one item which has children, each of these has children etc.
etc.

A bit like a directory structure in Windows Explorer (on the left hand side)

I wrote one for pages a few years back which I still use - it recurses on a
custom tag - a working example is;
http://www.ife.co.uk/page.cfm/Action=SiteMap

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Visual Source Safe

[Dave Hannum]

I have.  What do you want to know?

Dave



- Original Message -
From: "Nathan Stanford" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 1:35 PM
Subject: Visual Source Safe


Has anyone used Visual Source Safe with ColdFusion and multiple programmers?

Nathan Stanford
www.cfitpsplus.com
Free CF e-zine




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Query confusion - CF not recognising query name

[Philip Arnold - ASP]

I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me

Here's the code;

select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by #form.OrderBy#



Here's the error;
An error occurred while evaluating the expression:

 variables.IDCount=getPeopleInfo.RecordCount

Error near line 527, column 8.

Error resolving parameter GETPEOPLEINFO.RECORDCOUNT

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.


I've tried putting a CFLoop straight after the query and it comes back that
the query doesn't exist - but I know it does (obviously)

It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHEADER

[Bob Silverberg]

Perhaps I'm missing something here (which is likely), but if you want to
display a PDF file, why don't you just CFLOCATION to the PDF file, which
will cause it to open in the user's browser (if they have the plug-in)?

Bob

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: January 8, 2001 1:34 PM
To: CF-Talk
Subject: CFHEADER


It seems the following won't work, well in at least IE5.5.




It instead opens the page up for download instead of the file.  So lets say
I have peter.pdf as my attributes.fname and download.cfm is the page the
above code is on.  And lets say that it's called from index.cfm.  Well
index.htm appears in the download file box, not peter.pdf.  It seems to work
ok in Netscape, so I can't believe I'm the only one having this problem.
I've seen similar looking code on the Allaire site, but it's still not
working.  Can anyone help with this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Visual Source Safe

[Kiran Samudrala]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

YesDo ya have any question??


- -Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:35 AM
To: CF-Talk
Subject: Visual Source Safe


Has anyone used Visual Source Safe with ColdFusion and multiple
programmers?

Nathan Stanford
www.cfitpsplus.com
Free CF e-zine




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use 

iQA/AwUBOlp8voTYOkJ4PSr0EQI0qACg2gqK7BYl0jKmsu1RjZKN2NKsLkwAoL46
7cwEYNct04HSjlumsoArxu6r
=NzKk
-END PGP SIGNATURE-

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists