Best affordable source control solution

[Marc Schipperheyn]

This is a multi-part message in MIME format.

--=_NextPart_000_0009_01C059E5.41174200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all,

I'm interested in acquiring a source control solution for Cold Fusion
Studio. Unfortunately, the obvious candidate: VSS is unbelievably expensive
if you buy it a s a seperate application ($499 per workstation or something
like that). Is there any other viable solution out there?

Kind regards,

Marc Schipperheyn



_  .e>  ___
mr M.Schipperheyn MBA
Technical Director___[EMAIL PROTECTED]
_  .e>  ___
Friesestraatweg 215a
P.o. Box 2010__ tel: +31 (0)50 5757888
9704 CA Groningen__fax: +31 (0)50 5757889
The Netherlands http://www.thefactore.com
_  .e>  ___

 Premium Partner for Allaire. Multimedia development
_   with Macromedia Director, Authorware & Flash.

< The future is technological, but it will not be a world of gray steel.
>




--=_NextPart_000_0009_01C059E5.41174200
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hi=20
all,
 
I'm =
interested in=20
acquiring a source control solution for Cold Fusion Studio. =
Unfortunately, the=20
obvious candidate: VSS is unbelievably expensive if you buy it a s a =
seperate=20
application ($499 per workstation or something like that). Is there any =
other=20
viable solution out there?
 
Kind=20
regards,
 
Marc=20
Schipperheyn
_____  .e>  ___mr M.Schipperheyn MBATechnical =
Director___ =
   [EMAIL PROTECTED]_  .e>  ___  Friesestraatweg 215a P.o. Box 2010__ tel: +31 (0)50 57578889704 CA=20
Groningen__fax: +31 (0)50 =
5757889The=20
Netherlands http://www.thefactore.com_  .e>  ___    =20
Premium=20
Partner for Allaire. Multimedia development _  =20
&=
nbsp;   with=20
Macromedia Director, Authorware & Flash.< The =
future is=20
technological, but it will not be a world of gray steel. >=20
 
 

--=_NextPart_000_0009_01C059E5.41174200--

~~
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

Error occurred while attempting to start service

[Seamus Campbell]

Anyone help?
I've just got this error below
I can't see any services that are not running
And certainly Apache, CF application server, CF RDS, and CF Executive are 
all running
Any clues anyone?


Error Occurred While Processing Request
Error Diagnostic Information Error occurred while attempting to start 
service. Windows NT error number 1056 occurred.
HTTP/1.1 200 OK Date: Wed, 29 Nov 2000 08:09:52 GMT Server: Apache/1.3.6 
(Win32) Expires: 0 Pragma: no-cache Cache-control: no-cache, no-store, 
must-revalidate Keep-Alive: timeout=15, max=99 Connection: Keep-Alive, 
Keep-Alive Transfer-Encoding: chunked, chunked Content-Type: text/html

Error Occurred While Processing Request
Error Diagnostic Information An error occurred while attempting to 
establish a connection to the service. The most likely cause of this 
problem is that the service is not currently running. You can use the 
'Services' Control Panel to verify that the service is running and to 
restart it if necessary. Windows NT error number 2 occurred.

seamus

~~
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: HELP HELP HELP!!!

[Bud]

On 11/28/00, Chris Straight penned:
>'#required1#',  
>
>   
>   '#author2#',
>   
>
>   
>   '#title_price2#',
>   

Take a peek at this. If author2 is not defined, and anything after it 
is, required1 and the next field will not have a comma separating 
them.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: uploading tabular data...

[Bud]

On 11/29/00, [EMAIL PROTECTED] penned:
>Hello,
>  In my application, the user has to upload tabular data to the server
>I tried the CFFILE tag but then I get all the data only in 1 variable. How
>do I split the data so that I can read data from fields.
>Also, how do I read 1 row at a time ?

You can nest a loop inside a loop, using line breaks and tabs as the 
delimiters.







#datafield#




-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: SELECT .. WHERE "date condition"

[Bud]

On 11/29/00, Michael She penned:
>  >This is what happens when non programmers pick up programming .. we miss
>>some of the basics along the way. I'm try to run a conditional select
>>based on the age of the time the entry was made into the dB (posting_time)
>>.. specifically I plan to offer the user a form to select all entries made
>>after a chosen date (cut_off_time)
>>
>>something to the affect of
>>~~~
>>  
>>
>>  
>>  SELECT *
>>  FROM table
>  > WHERE posting_time > #cut_off_time#
>  > 

Try using #createodbcdate(cut_off_time)#
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: Auto-deleting old events from CF events calendar

[Bud]

On 11/28/00, Chris Geanious penned:
>I have a CF based events calendar I am modifying and need to delete events
>older than 30 days from the Access database.  What would be the simplest
>way to set this up. Should be relatively simple but my brain is dim at the
>moment.




DELETE FROM events
WHERE eventdate < #createodbcdate(deletedate)#


As far as auto deleting it, you'll need to set up a cfschedule or 
have it load every time someone accesses some page.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: HELP HELP HELP!!!

[Rob Keniger]

on 11/29/00 6:28 PM, Bud at [EMAIL PROTECTED] wrote:

>> '#required1#',  
>> 
>> 
>> '#author2#',
>> 
>> 
>> 
>> '#title_price2#',
>> 
> 
> Take a peek at this. If author2 is not defined, and anything after it
> is, required1 and the next field will not have a comma separating
> them.

Try something like:

'#required1#'

,'#author2#'



,'#title_price2#'


By putting the commas in front of the optional column names you can avoid
problems like this.

-- 

Rob Keniger

big bang solutions




~~
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

No Subject

[Seamus Campbell]

I just sent a help message below.
I think I've done a really stupid, stupid thing.
I increased the template cache size to 30720 and ticked the trusted cache 
checkbox.
I now realize that I only have 64 MB ram on the server the holds CF Server, 
so I'm presuming it just doesn't have enough memory to have this size cache.
But I can't get into administrator to undo my cache changes.

Does anyone know of a way to change cache size without going thru 
administrator

Help an idiot please
Seamus


Anyone help?
I've just got this error below
I can't see any services that are not running
And certainly Apache, CF application server, CF RDS, and CF Executive are
all running
Any clues anyone?

Error Occurred While Processing Request
Error Diagnostic Information Error occurred while attempting to start
service. Windows NT error number 1056 occurred.
HTTP/1.1 200 OK Date: Wed, 29 Nov 2000 08:09:52 GMT Server: Apache/1.3.6
(Win32) Expires: 0 Pragma: no-cache Cache-control: no-cache, no-store,
must-revalidate Keep-Alive: timeout=15, max=99 Connection: Keep-Alive,
Keep-Alive Transfer-Encoding: chunked, chunked Content-Type: text/html
Error Occurred While Processing Request
Error Diagnostic Information An error occurred while attempting to
establish a connection to the service. The most likely cause of this
problem is that the service is not currently running. You can use the
'Services' Control Panel to verify that the service is running and to
restart it if necessary. Windows NT error number 2 occurred.
seamus

~~
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

Approved: news@news.gradwell.net

[Seamus Campbell]

I just sent a help message below.
I think I've done a really stupid, stupid thing.
I increased the template cache size to 30720 and ticked the trusted cache 
checkbox.
I now realize that I only have 64 MB ram on the server the holds CF Server, 
so I'm presuming it just doesn't have enough memory to have this size cache.
But I can't get into administrator to undo my cache changes.

Does anyone know of a way to change cache size without going thru 
administrator

Help an idiot please
Seamus


Anyone help?
I've just got this error below
I can't see any services that are not running
And certainly Apache, CF application server, CF RDS, and CF Executive are
all running
Any clues anyone?

Error Occurred While Processing Request
Error Diagnostic Information Error occurred while attempting to start
service. Windows NT error number 1056 occurred.
HTTP/1.1 200 OK Date: Wed, 29 Nov 2000 08:09:52 GMT Server: Apache/1.3.6
(Win32) Expires: 0 Pragma: no-cache Cache-control: no-cache, no-store,
must-revalidate Keep-Alive: timeout=15, max=99 Connection: Keep-Alive,
Keep-Alive Transfer-Encoding: chunked, chunked Content-Type: text/html
Error Occurred While Processing Request
Error Diagnostic Information An error occurred while attempting to
establish a connection to the service. The most likely cause of this
problem is that the service is not currently running. You can use the
'Services' Control Panel to verify that the service is running and to
restart it if necessary. Windows NT error number 2 occurred.
seamus

~~
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
~~
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

CFFILE copy and NAMECONFLICT

[Kay Smoljak]

Hi all,

I have an interesting problem. We're developing a windows-based program that
will be creating a html file, uploading it with any images to a temp
directory on a web site, then calling a CF template with a set of url
parameters. That template will move the uploaded files to a directory
(ensuring they have unique filenames) then write the new filenames and the
passed parameters to a db table.

Sounds fairly straightforward... my problem is, the NAMECONFLICT attribute
of CFFILE appears to be available only for ACTION="UPLOAD" - not COPY. This
seems quite bizarre to me. I have the same set of name conflict issues when
copying or moving files from directory to directory as I do when uploading.
So why would they leave this out?

What I need to decide is, what will take the least amount of time/effort:
1. Getting the windows program to fake a multipart form submission instead
of uploading the files and calling a template. I don't know if this is
possible. The program is being written in Delphi.
2. Use a replacement for CFFILE. I don't know yet if there is one available.
3. Use CF code to figure out if a given filename exists before moving it.

Does anyone have any comments or suggestions? It sucks because I thought I
had it all mapped out already...

Thanks,
K.
__
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au

~~
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: CFFILE copy and NAMECONFLICT

[Jim McAtee]

> I have an interesting problem. We're developing a windows-based program
that
> will be creating a html file, uploading it with any images to a temp
> directory on a web site, then calling a CF template with a set of url
> parameters. That template will move the uploaded files to a directory
> (ensuring they have unique filenames) then write the new filenames and the
> passed parameters to a db table.
>
> Sounds fairly straightforward... my problem is, the NAMECONFLICT attribute
> of CFFILE appears to be available only for ACTION="UPLOAD" - not COPY.
This
> seems quite bizarre to me. I have the same set of name conflict issues
when
> copying or moving files from directory to directory as I do when
uploading.
> So why would they leave this out?

Just use FileExists() and see if a file with the desired name already
exists.  If so, _you_ the programmer decide how to handle the conflict.
Copy to a unique file name, delete the old one first, don't do the copy,
whatever.

Jim

~~
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

CFFILE locking?

[Len Conrad]

With , does CF have implicit file locking or 
serialization of access to one file (such as a logging file common 
used by all a site's pages) or do we have implement our own locking scheme?

In either case, what happens when there is a collision?

Does CF do its own retry/timeout thing or do we have to do that also?

Len

~~
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: Error occurred while attempting to start service

[Seamus Campbell]

Thanks but that's not the problem
Seamus

At 07:37 PM 29/11/00 , you wrote:
>Check your date on your server.
>
>I had a problem recently when the date re-set itself to 2045!
>
>Completely screwed everything.
>
>Just a thought.
>Gordon
>
>
>
>At 19:19 29/11/00 +1100 Seamus Campbell said
> >Anyone help?
> >I've just got this error below
> >I can't see any services that are not running
> >And certainly Apache, CF application server, CF RDS, and CF Executive are
> >all running
> >Any clues anyone?
> >
> >
> >Error Occurred While Processing Request
> >Error Diagnostic Information Error occurred while attempting to start
> >service. Windows NT error number 1056 occurred.
> >HTTP/1.1 200 OK Date: Wed, 29 Nov 2000 08:09:52 GMT Server: Apache/1.3.6
> >(Win32) Expires: 0 Pragma: no-cache Cache-control: no-cache, no-store,
> >must-revalidate Keep-Alive: timeout=15, max=99 Connection: Keep-Alive,
> >Keep-Alive Transfer-Encoding: chunked, chunked Content-Type: text/html
> >
> >Error Occurred While Processing Request
> >Error Diagnostic Information An error occurred while attempting to
> >establish a connection to the service. The most likely cause of this
> >problem is that the service is not currently running. You can use the
> >'Services' Control Panel to verify that the service is running and to
> >restart it if necessary. Windows NT error number 2 occurred.
> >
> >seamus
> >
> >~~
> >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
> >

~~
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: NT SP6a ok?

[Anthony Geoghegan]

Hi Dave,
Excellent hack.  Could such a trick be used to allow users to bookmark
pages, using special trick links, on a fusebox site?
As you probably know bookmarking pages with fusebox is a pain.
If it could be used maybe you could outline the CFCONTENT tag one might use.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2000 18:07
To: CF-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: NT SP6a ok?


> Are there still issues with CF and NT Service Pack 6a?

The problem with SP6 is that it changed how URLs are processed by IIS, which
will affect your use of the CFCONTENT tag if you're using "fake" URLs to
prompt the user to save a file with a specific name other than the name of
the script which was executed by that user.

This problem remains, and won't be going away any time soon - the "fake" URL
trick shouldn't have ever worked. I'd recommend using it, if it's been
accepted as OK by your internal IS staff.

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

CF-TALK Problem?

[Guy J. McDowell]

I haven't received a CF-Talk digest e-mail in about 3 days. Is
something wrong with the listserve?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S.
www.OFAH.org -  The flagship site for the O.F.A.H. with NEW
Election2000 Section
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.



~~
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: Seamus' Stupid Stupid Thing

[Bud]

On 11/29/00, Seamus Campbell penned:
>I just sent a help message below.
>I think I've done a really stupid, stupid thing.
>I increased the template cache size to 30720 and ticked the trusted cache
>checkbox.
>I now realize that I only have 64 MB ram on the server the holds CF Server,
>so I'm presuming it just doesn't have enough memory to have this size cache.
>But I can't get into administrator to undo my cache changes.
>
>Does anyone know of a way to change cache size without going thru
>administrator
>
>Help an idiot please
>Seamus

:)

Make sure CF is not running.
Open a dos prompt, type in regedit.
When the registry editor opens, Open:

HKEY_LOCAL_MACHINE
Software
Allaire
ColdFusion
CurrentVersion

Then click directly on the Server Folder.

Look for 2 parameters:

AssumeTemplateCacheIsNotDirty

Set the value to "0" to uncheck Trusted Cache

TemplateCacheSize

I think "2048" is the default.

Exit and save changes.

Good luck.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: Clustering for Linux

[mherbene]

I haven't tried clustering the eval.  However, in purchased versions of CF
when you configure ClusterCats and it asks for a license key you simply type
in GOCOLDFUSION, and that may work for the eval too.

You do not have to purchase ClusterCats licenses separately (in fact, I
don't think you can), but you need one Enterprise edition of CF for each
machine in your cluster.

-Original Message-
From: Gena [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 4:35 PM
To: CF-Talk
Subject: Re: Clustering for Linux


Hi!

I downloaded evaluation copy of CF enterprise and tried to do a clustering,
but ClusterCAT asked me about some licence. Doesn't mean that I cannot play
with clustering on evaluation version? What does it mean "licence" for
ClusterCAT. It looks like we have to buy a licence for every new cluster
connection. Am I right?

Cheers,
Gennadi

~~
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
~~
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_PowerPoint

[Andy Lambert]

This is a multi-part message in MIME format.

--=_NextPart_000_0041_01C059E4.B901EAA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Has anyone worked with this custom tag? I need some assistance in =
formatting content in the PowerPoint objects... for example, how to =
change fonts, add new lines without bullets to textareas, etc.=20
Please email me directly at [EMAIL PROTECTED], as I only get the =
digest version CFTalk.
Thanks.
Andy Lambert
L2Crossing Interactive

--=_NextPart_000_0041_01C059E4.B901EAA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









Has anyone worked with this custom tag? =
I need some=20
assistance in formatting content in the PowerPoint objects... for =
example, how=20
to change fonts, add new lines without bullets to textareas, etc. =

Please email me directly at mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED], as I only =
get the=20
digest version CFTalk.
Thanks.
Andy Lambert
L2Crossing=20
Interactive

--=_NextPart_000_0041_01C059E4.B901EAA0--

~~
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-TALK Problem?

[Michael Dinowitz]

Yep, there was a problem with the digests and it should be fixed. I'm hoping
that I've preserved the ones from the last few days. If not, there's always
the archive. :)



> I haven't received a CF-Talk digest e-mail in about 3 days. Is
> something wrong with the listserve?
>
> Yours In Conservation,
>
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
>
> P.S.
> www.OFAH.org -  The flagship site for the O.F.A.H. with NEW
> Election2000 Section
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> Education Program.
>
>
>
> ~~
> 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
>

~~
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: [Best affordable source control solution]

[Alex]

CVS is free and IMHO the best

"Marc Schipperheyn" <[EMAIL PROTECTED]> wrote:
This is a multi-part message in MIME format.

--=_NextPart_000_0009_01C059E5.41174200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all,

I'm interested in acquiring a source control solution for Cold Fusion
Studio. Unfortunately, the obvious candidate: VSS is unbelievably expensive
if you buy it a s a seperate application ($499 per workstation or something
like that). Is there any other viable solution out there?

Kind regards,

Marc Schipperheyn



_  .e>  ___
mr M.Schipperheyn MBA
Technical Director___[EMAIL PROTECTED]
_  .e>  ___
Friesestraatweg 215a
P.o. Box 2010__ tel: +31 (0)50 5757888
9704 CA Groningen__fax: +31 (0)50 5757889
The Netherlands http://www.thefactore.com
_  .e>  ___

 Premium Partner for Allaire. Multimedia development
_   with Macromedia Director, Authorware & Flash.

< The future is technological, but it will not be a world of gray steel.
>




--=_NextPart_000_0009_01C059E5.41174200
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hi=20
all,
 
I'm =
interested in=20
acquiring a source control solution for Cold Fusion Studio. =
Unfortunately, the=20
obvious candidate: VSS is unbelievably expensive if you buy it a s a =
seperate=20
application ($499 per workstation or something like that). Is there any =
other=20
viable solution out there?
 
Kind=20
regards,
 
Marc=20
Schipperheyn
_____  .e>  ___mr M.Schipperheyn MBATechnical =
Director___ =
   [EMAIL PROTECTED]_  .e>  ___  Friesestraatweg 215a P.o. Box 2010__ tel: +31 (0)50 57578889704 CA=20
Groningen__fax: +31 (0)50 =
5757889The=20
Netherlands http://www.thefactore.com_  .e>  ___    =20
Premium=20
Partner for Allaire. Multimedia development _  =20
&=
nbsp;   with=20
Macromedia Director, Authorware & Flash.< The =
future is=20
technological, but it will not be a world of gray steel. >=20
 
 

--=_NextPart_000_0009_01C059E5.41174200--

~~
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



Get free email and a permanent address at http://www.netaddress.com/?N=1
~~
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?sidebarRsts

Re: Auto-deleting old events from CF events calendar

[Chris Geanious]

Thanx Bud,
Yeah, I was going to include the snippet in the template which generates 
each month's page.  This should do the trick.
thanx again,

Chris

At 03:48 AM 11/29/00 -0500, you wrote:
>On 11/28/00, Chris Geanious penned:
> >I have a CF based events calendar I am modifying and need to delete events
> >older than 30 days from the Access database.  What would be the simplest
> >way to set this up. Should be relatively simple but my brain is dim at the
> >moment.
>
>
>
>
>DELETE FROM events
>WHERE eventdate < #createodbcdate(deletedate)#
>
>
>As far as auto deleting it, you'll need to set up a cfschedule or
>have it load every time someone accesses some page.
>--
>
>Bud Schneehagen - Tropical Web Creations
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>ColdFusion Solutions / eCommerce Development
>[EMAIL PROTECTED]
>http://www.twcreations.com/
>954.721.3452
>~~
>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

~~
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

new struct func (4.5.1.sp2)

[pan]

has anyone gained sufficient insight from the 
extremely sparse release notes to understand 
how to use the new struct funcs?

fertile ground for a new tutorial/examples

release notes:

StructAppend
StructAppend adds all the fields and values of Struct2 to Struct1.
Struct1 is changed in the process. Struct2 is not changed. 

StructAppend(Struct1, Struct2 [, OverwriteFlag])


StructFindKey
StructFindKey searches recursively through an arbitrarily complex
sub-structure of nested arrays, structures, and other elements and
returns an array containing any structures with values that match the
key specified in the Key parameter.

StructFindKey(Top, Key [, Scope])


StructFindValue
StructFindValue searches recursively through an arbitrarily complex
sub-structure of nested arrays, structures, and other elements and
returns an array containing any structures with values that match the
key specified in the Key parameter.

StructFindValue(Top, Key [, Scope])


StructGet
StructGet returns a valid ColdFusion array of structures from the
specified path. 

StructGet(PathDesired)


StructSort
StructSort returns an array of structures containing top-level key
names (strings) sorted according to the value of the specified sub-element.
The value of the keys may be simple values or complex elements. 

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



~~
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: new struct func (4.5.1.sp2)

[Raymond K. Camden]

I'll tackle one of these - StructGet()

Think of StructGet as a mega cfparam tag. You can do this:



and it will create the structure. If you did this with cfparam, it would
actually create a key called foo.lower.reallow.blah. StructGet actually
creates a Foo struct, then a lower struct, reallow, blah, etc. You can also
do:

 and it will create Arr as an
array.

===
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -Original Message-
> From: pan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 10:12 AM
> To: CF-Talk
> Subject: new struct func (4.5.1.sp2)
>
>
> has anyone gained sufficient insight from the
> extremely sparse release notes to understand
> how to use the new struct funcs?
>
> fertile ground for a new tutorial/examples
>
> release notes:
>

~~
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: new struct func (4.5.1.sp2)

[Michael Dinowitz]

I looked them over and added them to my functions list but haven't played
yet. I do plan to devote some time to digging into each one and then writing
it up as a FA article. (yes, we're getting FA back on track).
The StructAppend looks really useful for Fusebox in place of the loop used
on the form/url vars. It also looks useful in moving entire structures onto
the request variable. I think most if not all of these new functions were
written for just that thing.


> has anyone gained sufficient insight from the
> extremely sparse release notes to understand
> how to use the new struct funcs?
>
> fertile ground for a new tutorial/examples
>
> release notes:
>
> StructAppend
> StructAppend adds all the fields and values of Struct2 to Struct1.
> Struct1 is changed in the process. Struct2 is not changed.
>
> StructAppend(Struct1, Struct2 [, OverwriteFlag])
>
>
> StructFindKey
> StructFindKey searches recursively through an arbitrarily complex
> sub-structure of nested arrays, structures, and other elements and
> returns an array containing any structures with values that match the
> key specified in the Key parameter.
>
> StructFindKey(Top, Key [, Scope])
>
>
> StructFindValue
> StructFindValue searches recursively through an arbitrarily complex
> sub-structure of nested arrays, structures, and other elements and
> returns an array containing any structures with values that match the
> key specified in the Key parameter.
>
> StructFindValue(Top, Key [, Scope])
>
>
> StructGet
> StructGet returns a valid ColdFusion array of structures from the
> specified path.
>
> StructGet(PathDesired)
>
>
> StructSort
> StructSort returns an array of structures containing top-level key
> names (strings) sorted according to the value of the specified
sub-element.
> The value of the keys may be simple values or complex elements.
>
> StructSort(Base [, SortType, SortOrder, PathToSubElement])
>
>
>
> ~~
> 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
>

~~
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

Getting info from IIS

[Tom Espen Pedersen]

I was wondering if there's a way to interact with IIS ?
Like reading the "current users" to display the number of active users on a
site... etc.

Tom Espen Pedersen
[EMAIL PROTECTED]

UF+

~~
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: Cookie and Javascript detect

[Benjamin Fitts]

http://www.browserhawk.com

I believe they even have a cfx tag listed in the allaire developers
exchange.

Regards,
Benjamin Fitts
Web Developer
uClick
[EMAIL PROTECTED]


-Original Message-
From: Park, Simon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 6:19 PM
To: CF-Talk
Subject: Cookie and Javascript detect


Does anyone know of an elegant way to detect if the client browser's
javascript and cookies are enabled? Preferably in one file...

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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
~~
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

~~
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: Getting info from IIS

[Dylan Bromby]

You can use ADSI to interact pretty deeply with IIS. I don't know about the
current user thread. But there are tons of objects you can access with ADSI.

- Original Message -
From: "Tom Espen Pedersen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 7:23 AM
Subject: Getting info from IIS


> I was wondering if there's a way to interact with IIS ?
> Like reading the "current users" to display the number of active users on
a
> site... etc.
>
> Tom Espen Pedersen
> [EMAIL PROTECTED]
>
> UF+
>
> ~~
> 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
>

~~
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: Cookie and Javascript detect

[Park, Simon]

Benjamin Fitts [mailto:[EMAIL PROTECTED]] wrote:
> http://www.browserhawk.com
> 
> I believe they even have a cfx tag listed in the allaire developers
> exchange.

I checked Browserhawk out and there are some limitations with CF which they
don't tell you about until you install the program. For example, in order to
check for a cookie, they recommend that you create an ASP page that uses
Browserhawk to check for the cookie and then does a re-direct to the proper
CF page (I guess this stems from the CFCOOKIE-CFLOCATION situation that gets
mentioned pretty regularly on this list). The site we are developing will
eventually be on a Unix OS and I really don't want to mess with Chilisoft
ASP.

Any other thoughts?

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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  
~~
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 and IIS

[Gieseman, Athelene]

I tried this just recently.  Unfortunately, the user name it returned was
the one that we use to log into the CF services.  In other words, I logged
into the web as user ABC and when I use the cgi.auth_user variable, it
returns user XYZ.  Can anyone shed any light on what I may be doing wrong?
Also, I've searched for a place that would document those cgi variables.
(I'm respectful of the comments on this list about using other resources
first.)  But I've had no luck.  Any suggestions on where I could learn more?
Several trips to the bookstore have gotten me no where.  Of course, I love
the bookstore and their thousands of technical guides.  So it hasn't exactly
been torture.  :-)

Athelene
[EMAIL PROTECTED]

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 11:40 PM
To: CF-Talk
Subject: Re: CF and IIS


Refer to the cgi variable cgi.auth_user.  It will contain both the domain
name and the username as in: MYNTDOMAIN\bob

Jim


- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 5:43 PM
Subject: CF and IIS


> Hi,
>
> Does anyone know how to have CF query IIS in order to grab the login name
of
> someone who has logged into a website, via IIS? The alternative for me
would
> be to set up a webpage based log in screen that coldfusion controls and
grab
> the info that way, but I am exploring the IIS option first.
>
> Thank you
>
> SR

~~
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
~~
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: Command line arguments for CFStudio

[Hoffman, Joe (CIT)]

C:\Program Files\Allaire\ColdFusion Studio 4.5>cfstudio45.exe
c:\website\htdocs\index.cfm

or

C:\>"C:\Program Files\Allaire\ColdFusion Studio 4.5\cfstudio45.exe"
c:\website\htdocs\index.cfm



Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 8:58 PM
To: CF-Talk
Subject: Command line arguments for CFStudio


Does anyone know what the command line parameters to open a file in CFStudio
through a command line? Im thinking it's something like this at the command
prompt...

C:\Path to Studio\>cfstudio45.exe /f C:\path to file\file.cfm

Mainly I am looking for the the flag that is used to pass a file, I'm
assuming it's /f... can someone comfirm this or set me straight?

Thanks,
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
~~
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

405 Error

[Todd Ashworth]

I have a search form.  When I chose an option in a certain select box and
then submit the form, I get this error:

HTTP Error 405
405 Method Not Allowed

The method specified in the Request Line is not allowed for the resource
identified by the request. Please ensure that you have the proper MIME type
set up for the resource you are requesting.

Please contact the server's administrator if this problem persists.



If I don't select anything in that particular list box, the search works
fine.

Here is the code for the select box:


   (Choose One:)
   Staff
   Instructor


And here is the code on the action page that I think is causing the problem:



And here is the code in the cf_cbAppendCriteria custom tag:


 
 
 
  
  
 

 
 
  '#Value#' ">
   '#Value#' ">
  
  
  
   
 
  

 
 
  #CreateODBCDateTime(Value)# ">
   #CreateODBCDateTime(Value)# ">
  
  

 
 
  #Val(Value)# ">
   #Val(Value)# ">
  
  
 

  0">
   
 
   
 

  0">
   
 


Anyone know what this error means and how to make it go away?

Todd Ashworth


~~
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

Help With SQL Query

[Gary Groomer]

I have two tables from which I want the sum of the columns based on a common
key.  From the below tables, the desired output is 3,5,1,2.  Instead I get
6,10,6,3.  I am sure the solution is simple, but I haven't run into this one
before and any help would be appreacited.

Gary

Table1
---
TableIDUserCol1Col2
1Karl10
2Karl02
3Karl23

Table2
---
TableIDUserCol1Col2
1Karl10
2Karl02

SQL Query
-
SELECT Sum(a.Col1), Sum(a.Col2), Sum(b.Col1), Sum(b.Col2)
FROM Table1 a, Table2 b
WHERE a.User = b.User
AND a.User = 'Karl'

~~
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: 405 Error

[Dave Watts]

> I have a search form.  When I chose an option in a certain 
> select box and then submit the form, I get this error:
> 
> HTTP Error 405
> 405 Method Not Allowed
> 
> The method specified in the Request Line is not allowed for 
> the resource identified by the request. Please ensure that 
> you have the proper MIME type set up for the resource you 
> are requesting.
...
> If I don't select anything in that particular list box, the 
> search works fine.
> 
> Here is the code for the select box:
> 
> 
>(Choose One:)
>Staff
>Instructor
> 
> 
> And here is the code on the action page that I think is 
> causing the problem...

This problem shouldn't have anything to do with code in your action page.
The error indicates that what you're doing in the form is the problem, not
within the action page itself - which is never actually being executed,
since your web server is returning a 405 error.

Typically, you get an error like this when you misspell a value within the
FORM's ACTION or METHOD parameter.

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: HELP!!! Forums Question - index.cfm file not found

[Chris Montgomery]

Issac,

Are you using the open source Forums from forumspot.org?  If so, the
path to the security template directory is set in the application.cfm
file and is then later referenced in a CFINCLUDE in application.cfm.

For example, lines 45-47 (in the unedited application.cfm):





Further down in application.cfm, lines 150-152 you have:




I don't know if this is true for previous versions of Allaire Forums
(i.e., the non-open source versions), but I would suspect it might be
similar.

Hope that helps.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692


>-Original Message-
>From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, November 28, 2000 11:25 PM
>To: CF-Talk
>Subject: HELP!!! Forums Question - index.cfm file not found
>
>
>I'm trying to access an Allaire Forums application and receiving the
>HTTP/1.0 404 Object Not Found Error.  It indicates that it
>can't find the
>template in an include statement in the application.cfm file.
>When looking
>at that file, here is the code that it is choking on:
>
>
>
>
>
>Is there suppose to be a DefaultSecurity folder somewhere? Has
>anyone ever
>had this problem with Forums?  Any help or suggestions would be greatly
>appreciated.
>
>
>If you have any questions or concerns, please feel free to call me at
>407-514-5021.
>
>Thank you,
>
>> Issac Rosa

~~
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: 405 Error

[Rob Sherman]

Anytime I've seen the 405 error it's because the Method="post/or/get"
attribute was not placed in the original  tag.


Sincerely,

Rob Sherman
Allaire Certified Developer & Instructor
CFDude, Inc.  http://www.cfdude.com
 (310) 543-1622  (310) 543-0512


~~
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: Getting info from IIS

[Billy Cravens]

Can you post some basic code?  I know how to interact with IIS in ASP,
but I've yet to figure out how to do it in ColdFusion.  Where I'm mostly
interested is configuring and setting up web sites, ftp sites, virtual
directories, etc.  If you could just show a simple example of hooking
into the metabase, that would probably get me past that first hump.  

TIA.

-- 
Billy Cravens
[EMAIL PROTECTED]



Dylan Bromby wrote:
> 
> You can use ADSI to interact pretty deeply with IIS. I don't know about the
> current user thread. But there are tons of objects you can access with ADSI.
> 
> - Original Message -
> From: "Tom Espen Pedersen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 29, 2000 7:23 AM
> Subject: Getting info from IIS
> 
> > I was wondering if there's a way to interact with IIS ?
> > Like reading the "current users" to display the number of active users on
> a
> > site... etc.
> >
> > Tom Espen Pedersen
> > [EMAIL PROTECTED]
> >
> > UF+
> >
> > ~~
> > 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
> >
> 
> ~~
> 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
~~
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: Help With SQL Query

[Hayes, David]

Well, the problem is with your join - each row in table 1 is being joined
with EVERY row in table 2, so that your result set is 6 rows rather than 3.
What happens if you take out the where a.user=b.user condition and just have
WHERE a.user = 'karl' and b.user = 'karl'?

If you give us a little more information, we might be able to recommend some
alternatives.

Some options:

1) Use a UNION

2) Use 2 queries




-Original Message-
From: Gary Groomer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 10:08 AM
To: CF-Talk
Subject: Help With SQL Query


I have two tables from which I want the sum of the columns based on a common
key.  From the below tables, the desired output is 3,5,1,2.  Instead I get
6,10,6,3.  I am sure the solution is simple, but I haven't run into this one
before and any help would be appreacited.

Gary

Table1
---
TableIDUserCol1Col2
1Karl10
2Karl02
3Karl23

Table2
---
TableIDUserCol1Col2
1Karl10
2Karl02

SQL Query
-
SELECT Sum(a.Col1), Sum(a.Col2), Sum(b.Col1), Sum(b.Col2)
FROM Table1 a, Table2 b
WHERE a.User = b.User
AND a.User = 'Karl'

~~
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
~~
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-TALK Problem?

[Steve Reich]

Where is the archive located?

"Michael Dinowitz" <[EMAIL PROTECTED]> wrote in message
016a01c05a12$848bf5d0$[EMAIL PROTECTED]">news:016a01c05a12$848bf5d0$[EMAIL PROTECTED]...
> Yep, there was a problem with the digests and it should be fixed. I'm
hoping
> that I've preserved the ones from the last few days. If not, there's
always
> the archive. :)
>
>
>
> > I haven't received a CF-Talk digest e-mail in about 3 days. Is
> > something wrong with the listserve?
> >
> > Yours In Conservation,
> >
> > Guy J. McDowell,
> > Webmaster
> > The Ontario Federation of Anglers & Hunters
> > E-mail: [EMAIL PROTECTED]
> > Phone: (705) 748-6324 ext. 262
> >
> > P.S.
> > www.OFAH.org -  The flagship site for the O.F.A.H. with NEW
> > Election2000 Section
> > www.AuctionForWildlife.com - Your chance to make your bid for
> > conservation.
> > www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> > www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> > www.AHTV.com - Your online companion to the Angler and Hunter
> > Television show.
> > www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> > Education Program.
> >
> >
> >
> > ~~
> > 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
> >
>
> ~~
> 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


~~
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: Command line arguments for CFStudio

[Steve Reich]

> C:\Program Files\Allaire\ColdFusion Studio 4.5>cfstudio45.exe
> c:\website\htdocs\index.cfm

Thanks, Joe... that works too. It also works with the /f flag. I'm wondering
which one is most acceptable by Studio's program code. I'm guessing there
isn't any documentation of this anywhere? I'm trying to write a plugin for
Studio...

Thanks,
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: 405 Error

[Billy Cravens]

Make sure the folder has the correct settings.  I've run into this when
you forget to mark a folder as executable.

-- 
Billy Cravens
[EMAIL PROTECTED]


Todd Ashworth wrote:
> 
> I have a search form.  When I chose an option in a certain select box and
> then submit the form, I get this error:
> 
> HTTP Error 405
> 405 Method Not Allowed
> 
> The method specified in the Request Line is not allowed for the resource
> identified by the request. Please ensure that you have the proper MIME type
> set up for the resource you are requesting.
> 
> Please contact the server's administrator if this problem persists.
> 
> If I don't select anything in that particular list box, the search works
> fine.
> 
> Here is the code for the select box:
> 
> 
>(Choose One:)
>Staff
>Instructor
> 
> 
> And here is the code on the action page that I think is causing the problem:
> 
>  Operator="#contact_typeOperator#" Value="#contact_typeCriteria#">
> 
> And here is the code in the cf_cbAppendCriteria custom tag:
> 
> 
>  
>  
>  
>   
>   
>  
> 
>  
>   = '#Value#' ">
>   & " <> '#Value#' ">
>& " > '#Value#' ">
>" < '#Value#' ">
>Criteria & " LIKE '%#Value#%' ">
>Criteria = Criteria & " LIKE '%#Value#%' ">
> & " LIKE '#Value#%' ">
>   & " LIKE '%#Value#' ">
>   
> 
>  
>   = #CreateODBCDateTime(Value)# ">
>   & " <> #CreateODBCDateTime(Value)# ">
>& " > #CreateODBCDateTime(Value)# ">
>" < #CreateODBCDateTime(Value)# ">
>   
> 
>  
>   = #Val(Value)# ">
>   & " <> #Val(Value)# ">
>& " > #Val(Value)# ">
>" < #Val(Value)# ">
>   
>  
> 
>   0">
>
>  
>
>  
> 
>   0">
>
>  
> 
> 
> Anyone know what this error means and how to make it go away?
> 
> Todd Ashworth
> 
> ~~
> 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
~~
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: 405 Error

[Todd Ashworth]

You are right as always.  My action in my form was set to

index?go=staff/contactListinstead of index.cfm?go=staff/contactList

Just out of curiosity though, why did the form work at all?

Todd Ashworth

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 11:16 AM
Subject: RE: 405 Error


| This problem shouldn't have anything to do with code in your action page.
| The error indicates that what you're doing in the form is the problem, not
| within the action page itself - which is never actually being executed,
| since your web server is returning a 405 error.
|
| Typically, you get an error like this when you misspell a value within the
| FORM's ACTION or METHOD parameter.
|
| 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: CF-TALK Problem?

[Michael Dinowitz]

There's a link at the bottom of each email that goes out. :)
http://www.mail-archive.com/cf-talk@houseoffusion.com/

> Where is the archive located?
> 
> "Michael Dinowitz" <[EMAIL PROTECTED]> wrote in message
> 016a01c05a12$848bf5d0$[EMAIL PROTECTED]">news:016a01c05a12$848bf5d0$[EMAIL PROTECTED]...
> > Yep, there was a problem with the digests and it should be fixed. I'm
> hoping
> > that I've preserved the ones from the last few days. If not, there's
> always
> > the archive. :)


~~
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: Getting info from IIS

[Jake Hileman - Patmos]

I seem to see a lot of requests for those kind of utilities.

I've got some utilities here that let me set up new WWW accounts from the
web for me I'm willing to "liquidate". :-)

jake.
- Original Message -
From: "Billy Cravens" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 11:19 AM
Subject: Re: Getting info from IIS


> Can you post some basic code?  I know how to interact with IIS in ASP,
> but I've yet to figure out how to do it in ColdFusion.  Where I'm mostly
> interested is configuring and setting up web sites, ftp sites, virtual
> directories, etc.  If you could just show a simple example of hooking
> into the metabase, that would probably get me past that first hump.
>
> TIA.
>
> --
> Billy Cravens
> [EMAIL PROTECTED]
>
>
>
> Dylan Bromby wrote:
> >
> > You can use ADSI to interact pretty deeply with IIS. I don't know about
the
> > current user thread. But there are tons of objects you can access with
ADSI.
> >
> > - Original Message -
> > From: "Tom Espen Pedersen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, November 29, 2000 7:23 AM
> > Subject: Getting info from IIS
> >
> > > I was wondering if there's a way to interact with IIS ?
> > > Like reading the "current users" to display the number of active users
on
> > a
> > > site... etc.
> > >
> > > Tom Espen Pedersen
> > > [EMAIL PROTECTED]
> > >
> > > UF+
> > >
> > > ~~
> > > 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
> > >
> >
> > ~~
> > 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
> ~~
> 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

~~
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 as a structure

[Manam Suresh]

Is query a structure  in CF 4.01?
How can I convert a query to a structure in CF 4.01?

Thanks
Kumar

~~
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 and IIS

[Ken Wilson]

If your users are logging into the domain you might take a look at
CGI.REMOTE_USER. I parse that value to grab the user info.

Ken


~~
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: 405 Error

[Jeremy Ridout]

Hi, Todd,

Assuming your permissions and IIS are set up properly, in your form action,
are you referring to the directory only or the directory and the filename?
I've always had problems when setting my action to be the directory only,
but not specifying a filename (expecting it to go to the default). Try
specifying the filename also.



Good luck,
Jeremy

> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 10:09 AM
> To: CF-Talk
> Subject: 405 Error
> 
> 
> I have a search form.  When I chose an option in a certain 
> select box and
> then submit the form, I get this error:
> 
> HTTP Error 405
> 405 Method Not Allowed
> 
> The method specified in the Request Line is not allowed for 
> the resource
> identified by the request. Please ensure that you have the 
> proper MIME type
> set up for the resource you are requesting.
> 
> Please contact the server's administrator if this problem persists.
> 
> 
> 
> If I don't select anything in that particular list box, the 
> search works
> fine.
> 
> Here is the code for the select box:
> 
> 
>(Choose One:)
>Staff
>Instructor
> 
> 
> And here is the code on the action page that I think is 
> causing the problem:
> 
>  Operator="#contact_typeOperator#" Value="#contact_typeCriteria#">
> 
> And here is the code in the cf_cbAppendCriteria custom tag:
> 
> 
>  
>  
>  
>   
>   
>  
> 
>  
>   = Criteria & "
> = '#Value#' ">
>   Criteria = Criteria
> & " <> '#Value#' ">
>Criteria = Criteria
> & " > '#Value#' ">
>Criteria = Criteria &
> " < '#Value#' ">
>Criteria =
> Criteria & " LIKE '%#Value#%' ">
>Criteria = Criteria & " LIKE '%#Value#%' ">
> Criteria = Criteria
> & " LIKE '#Value#%' ">
>   Criteria = Criteria
> & " LIKE '%#Value#' ">
>   
> 
>  
>   = Criteria & "
> = #CreateODBCDateTime(Value)# ">
>   Criteria = Criteria
> & " <> #CreateODBCDateTime(Value)# ">
>Criteria = Criteria
> & " > #CreateODBCDateTime(Value)# ">
>Criteria = Criteria &
> " < #CreateODBCDateTime(Value)# ">
>   
> 
>  
>   = Criteria & "
> = #Val(Value)# ">
>   Criteria = Criteria
> & " <> #Val(Value)# ">
>Criteria = Criteria
> & " > #Val(Value)# ">
>Criteria = Criteria &
> " < #Val(Value)# ">
>   
>  
> 
>   EQ "1 > 0">
>
>  
>
>  
> 
>   EQ "1 > 0">
>
>  
> 
> 
> Anyone know what this error means and how to make it go away?
> 
> Todd Ashworth
> 
> 
> ~~
> 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
> 
~~
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 CRs

[Jay Jennings]

This sounds like a stupid newbie question (is the newbie stupid or is it the
question?) but I'm bonking my head against my monitor right now...

Take a look at the code down below. Two CFMAIL things. The first sends an
email with no carriage returns -- everything's on one line (that wraps). The
second CFMAIL sends the email as it's formatted. What's the difference?

The code:



#first_name#
#last_name#
#addr_1#
#addr_2#
#city#
#state#
#zip#
#day_phone#
#evening_phone#
#email#
#work#
#weeklyhours#
#startinggoal#
#annualgoal#
#previousnm#

#first_name# #last_name#
#addr_1#
#addr_2#
#city#, #state# #zip#





#first_name# #last_name#,

Thank you for requesting info on the broker plan
from http://www.DentalPlanInfo.com

I'll be mailing you information on starting your own Dental Plan
business, but if you have any immediate questions, feel free to
call me at 1-888-328-1660 (9AM to 9PM Pacific).

Jay Jennings
Broker
DentalPlanInfo.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: HELP HELP HELP!!!

[Chris Straight]

well I fixed the comma problem for future reference. But the same problem is
persisting with the updatable query error. What I failed to mention was that
I was using Visual Source Safe and I couldn't get it to release all of the
files on the server. Now being dumb and late at night I decided to uninstall
Visual Source Safe thinking it would alleviate the problem well it didn't
and now I am stuck with all my files still checked in and now way of
releasing them... I know I could reinstall Visual Source Safe but I wouldn't
know how to release the files... has anyone had this problem before, or can
anyone point me in the right direction?

Chris Straight

-Original Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 12:48 AM
To: CF-Talk
Subject: Re: HELP HELP HELP!!!


on 11/29/00 6:28 PM, Bud at [EMAIL PROTECTED] wrote:

>> '#required1#',  
>>
>> 
>> '#author2#',
>> 
>>
>> 
>> '#title_price2#',
>> 
>
> Take a peek at this. If author2 is not defined, and anything after it
> is, required1 and the next field will not have a comma separating
> them.

Try something like:

'#required1#'

,'#author2#'



,'#title_price2#'


By putting the commas in front of the optional column names you can avoid
problems like this.

--

Rob Keniger

big bang solutions




~~
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

~~
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: Getting info from IIS

[Dylan Bromby]

We used ADSI to manage over 3000 domains in IIS. It was great. Honestly, CF
wasn't up to it. Accessing ADSI was very slow even embedding the controls as
COM objects. We ended up creating VB apps using ADSI.

- Original Message -
From: "Billy Cravens" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 8:19 AM
Subject: Re: Getting info from IIS


> Can you post some basic code?  I know how to interact with IIS in ASP,
> but I've yet to figure out how to do it in ColdFusion.  Where I'm mostly
> interested is configuring and setting up web sites, ftp sites, virtual
> directories, etc.  If you could just show a simple example of hooking
> into the metabase, that would probably get me past that first hump.
>
> TIA.
>
> --
> Billy Cravens
> [EMAIL PROTECTED]
>
>
>
> Dylan Bromby wrote:
> >
> > You can use ADSI to interact pretty deeply with IIS. I don't know about
the
> > current user thread. But there are tons of objects you can access with
ADSI.
> >
> > - Original Message -
> > From: "Tom Espen Pedersen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, November 29, 2000 7:23 AM
> > Subject: Getting info from IIS
> >
> > > I was wondering if there's a way to interact with IIS ?
> > > Like reading the "current users" to display the number of active users
on
> > a
> > > site... etc.
> > >
> > > Tom Espen Pedersen
> > > [EMAIL PROTECTED]
> > >
> > > UF+
> > >
> > > ~~
> > > 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
> > >
> >
> > ~~
> > 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
> ~~
> 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
>

~~
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: 405 Error

[Patricia Lee]

My educated guess is because you're most likely using IE (just a wild guess)
and it decided that it would post the form back to itself.  I've seen this
happen when one leaves out the action attribute all together.  Once you
added the url parameters, ie gave up and gave you the 405 error.  

I'd guess futher that if you'd been using netscape you wouldn't have even
gottem past the first submission (the one without url parameters).

> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 11:26 AM
> To: CF-Talk
> Subject: Re: 405 Error
> 
> 
> You are right as always.  My action in my form was set to
> 
> index?go=staff/contactListinstead of 
> index.cfm?go=staff/contactList
> 
> Just out of curiosity though, why did the form work at all?
> 
> Todd Ashworth
> 
> 
~~
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 as a structure

[Eric Bradburn]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C05A24.5CDF7126
Content-Type: text/plain;
charset="iso-8859-1"

A Query is an Array.

-Original Message-
From: Manam Suresh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 11:38 AM
To: CF-Talk
Subject: Query as a structure


Is query a structure  in CF 4.01?
How can I convert a query to a structure in CF 4.01?

Thanks
Kumar

~~
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

--_=_NextPart_001_01C05A24.5CDF7126
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Query as a structure



A Query is an Array.


-Original Message-
From: Manam Suresh [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 11:38 AM
To: CF-Talk
Subject: Query as a structure



Is query a structure  in CF 4.01?
How can I convert a query to a structure in CF =
4.01?


Thanks
Kumar


~~
Structure your ColdFusion code with Fusebox. Get the =
official book at http://www.fusionauthority.com/bkinfo.cfm" =
TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=





--_=_NextPart_001_01C05A24.5CDF7126--
~~
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: Getting info from IIS

[Dave Watts]

> Can you post some basic code?  I know how to interact with IIS 
> in ASP, but I've yet to figure out how to do it in ColdFusion.  
> Where I'm mostly interested is configuring and setting up web 
> sites, ftp sites, virtual directories, etc. If you could just 
> show a simple example of hooking into the metabase, that would 
> probably get me past that first hump. 

Using ADSI from CF is a bit of a pain. You can do it, but not as easily as
you can from ASP.

As an alternative, you might consider a third-party component to do this
stuff for you. There's a CFX available, the Intranet Hosting Toolkit, from
Lewis Sellers:

http://www.intrafoundation.com/

There are also quite a few COM objects, such as SA-Admin, which work very
well from CF:

http://www.softwareartisans.com/

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

cfmail in cferror templates

[W Luke]

Hi,

I thought it would be useful to have any Request errors emailed to me, so I
added the necessary  code to my Request Error template, but it
failed to work.

Does anyone have a workaround for this?

Will

~~
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 as a structure

[Dave Watts]

> Is query a structure  in CF 4.01?

No, queries are not structures in any version of CF. They're fundamentally
different - a query is essentially an array of structures.

> How can I convert a query to a structure in CF 4.01?

If you only have two fields within your query, you can loop over that query
and append the values of the fields as key-value pairs within your
structure:


SELECT ID, Name
FROM   MyTable








Although, to be perfectly honest, there's little reason to do this -
queries, like structures, are complex data objects which can be stored in
memory and manipulated as needed.

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: Cookie and Javascript detect

[Courtney Payne]

For javascript detect, look up the  tag.  For a cookie check,
attempt to set a cookie on one page with  and check for it's
existence on a subsequent one.  If it's there then... well, you know.  :-)

Courtney E. Payne, Developer
Fig Leaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com 


-Original Message-
From: Park, Simon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 10:54 AM
To: CF-Talk
Subject: RE: Cookie and Javascript detect


Benjamin Fitts [mailto:[EMAIL PROTECTED]] wrote:
> http://www.browserhawk.com
> 
> I believe they even have a cfx tag listed in the allaire developers
> exchange.

I checked Browserhawk out and there are some limitations with CF which they
don't tell you about until you install the program. For example, in order to
check for a cookie, they recommend that you create an ASP page that uses
Browserhawk to check for the cookie and then does a re-direct to the proper
CF page (I guess this stems from the CFCOOKIE-CFLOCATION situation that gets
mentioned pretty regularly on this list). The site we are developing will
eventually be on a Unix OS and I really don't want to mess with Chilisoft
ASP.

Any other thoughts?

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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  
~~
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
~~
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 CRs

[Simon Horwith]

I believe CFMAIL handles the formatting of whatever text is placed inside
it, much the way HTML  tags do.

~Simon

> Simon Horwith
> 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: Jay Jennings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 11:44 AM
To: CF-Talk
Subject: CFMail CRs


This sounds like a stupid newbie question (is the newbie stupid or is it the
question?) but I'm bonking my head against my monitor right now...

Take a look at the code down below. Two CFMAIL things. The first sends an
email with no carriage returns -- everything's on one line (that wraps). The
second CFMAIL sends the email as it's formatted. What's the difference?

The code:



#first_name#
#last_name#
#addr_1#
#addr_2#
#city#
#state#
#zip#
#day_phone#
#evening_phone#
#email#
#work#
#weeklyhours#
#startinggoal#
#annualgoal#
#previousnm#

#first_name# #last_name#
#addr_1#
#addr_2#
#city#, #state# #zip#





#first_name# #last_name#,

Thank you for requesting info on the broker plan
from http://www.DentalPlanInfo.com

I'll be mailing you information on starting your own Dental Plan
business, but if you have any immediate questions, feel free to
call me at 1-888-328-1660 (9AM to 9PM Pacific).

Jay Jennings
Broker
DentalPlanInfo.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
~~
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

Database Design for ColdFusion Developers Seminar in South Florida..

[Kevin Langevin]

Hello, all...

Sorry for this shameless plug, but Adam Churvis and I thought we should put
a message out to this list, despite the very short notice.

This Friday and Saturday, December 1st and 2nd, Adam Churvis, manager of the
Atlanta ColdFusion User Group, will be offering his one-day Database Design
for ColdFusion Developers seminar for my CFUG here in South Florida.  We'd
like to invite anyone who whould like to attend the seminar to visit
http://www.coldfusionseminar.com and register for one of the days.  Or both
of the days, if you like...The seminar will cover a plethora of important
topics:

Welcome and Agenda

DATABASE DESIGN ESSENTIALS
Database terminology
Design and modeling basics
Normalization and denormalization
Building processes and workflow into the database
Null values
Referential integrity
Constraints and rules
Views
Index design and tuning
SQL (Structured Query Language)
DML (Data Manipulation Language)
DDL (Data Description Language)
Query optimization
Triggers
Stored procedures
Cursors
Locking granularity
Transaction processing
Structured error handling
Database concerns (memory page congestion, lock escalation, hot spots, bad
transactions, zombies, etc.)
Minimizing conversations
Maximizing throughput
Partitioning your logic across the entire system architecture

BREAK FOR LUNCH *** Lunch is on us***

DATABASE DESIGN ESSENTIALS, continued
Extended stored procedures
OLTP and OLAP
Debugging
Designing for scalability
Deciding on the right database platform
Appropriate hardware
Putting everything together
The use of CASE (Computer Assisted Software Engineering) tools
Setting up database security
Securing a database table through read-only views
Securing a database table through stored procedures

DATA WAREHOUSING AND DATA MINING
What is data warehousing?
What is data mining?

DATABASE LEGAL CONSIDERATIONS
Protecting yourself
Protecting the merchant
Common sense methods for not getting into hot water

RESOURCES
Software tools
Hardware vendors
Books and publications
Ethical database hacking
Legal counsel

SCENARIOS
During this portion of the seminar, we will take questions regarding
attendees' database design problems and show the "best practice" approaches
to solving them. We will work the problems out using a database CASE tool,
so you will not only see a diagram of the proper solution, but the resulting
database's DDL as well.

CONCLUSION

A lot of info, yes?  And the entire one-day seminar is only $129.  I've made
an arrangement with Adam to offer this seminar at a price that basically
means no profit whatsoever to my CFUG.  I'm covering costs of food and
beverages for attendees only, plus Adam's traveling expenses.  I do this
because my aim is to offer the opportunity for my members and CF developers
everywhere to learn about this all-important topic, Database Design.  Come
join us in Sunny South Florida for a day of turbo-charged Database Design
instruction for just $129.  For $129, you can't afford to NOT be here for
this event.  Plus...lunch is on us!  What could be better?

Expedia (http://www.expedia.com) still has good rates on airfares if you're
out of state, hotels in the area aren't expensive, and it's 80 degrees here
today.  How cold is it where you are?

Time's running out!  Register now!

http://www.coldfusionseminar.com


-Kev


~~
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 CRs

[Simon Horwith]

if the CR (hidden character) is not inside the mail tags, the text is
formatted appropriately.  Different readers (mail clients) also handle mail
formatting a little differently, too.  You may want to use a variable set to
Chr(10) & Chr(13) as your line delimeter, if you want to be certain of line
breaks.

~Simon

> Simon Horwith
> 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: Jay Jennings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 11:44 AM
To: CF-Talk
Subject: CFMail CRs


This sounds like a stupid newbie question (is the newbie stupid or is it the
question?) but I'm bonking my head against my monitor right now...

Take a look at the code down below. Two CFMAIL things. The first sends an
email with no carriage returns -- everything's on one line (that wraps). The
second CFMAIL sends the email as it's formatted. What's the difference?

The code:



#first_name#
#last_name#
#addr_1#
#addr_2#
#city#
#state#
#zip#
#day_phone#
#evening_phone#
#email#
#work#
#weeklyhours#
#startinggoal#
#annualgoal#
#previousnm#

#first_name# #last_name#
#addr_1#
#addr_2#
#city#, #state# #zip#





#first_name# #last_name#,

Thank you for requesting info on the broker plan
from http://www.DentalPlanInfo.com

I'll be mailing you information on starting your own Dental Plan
business, but if you have any immediate questions, feel free to
call me at 1-888-328-1660 (9AM to 9PM Pacific).

Jay Jennings
Broker
DentalPlanInfo.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
~~
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

CFEXPRESS

[Kelly Olson]

Does anyone have a copy of CFEXPRESS that could mail me off line.  It was mentioned 
that it was available at allaire, but it seems to be really difficult to find or taken 
of of the site.

Kelly Olson
[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?sidebarRsts

Re: cfmail in cferror templates

[Dylan Bromby]

I use CFTRY and CFCATCH and embed CFMAIL within the catch.

- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 8:57 AM
Subject: cfmail in cferror templates


> Hi,
>
> I thought it would be useful to have any Request errors emailed to me, so
I
> added the necessary  code to my Request Error template, but it
> failed to work.
>
> Does anyone have a workaround for this?
>
> Will
>
> ~~
> 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
>

~~
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 as a structure

[Chris Terrebonne]

Actually a query is an array of structures.

Chris
--
Original Message
From: "Eric Bradburn"<[EMAIL PROTECTED]>
Subject: RE: Query as a structure
Date: Wed, 29 Nov 2000 11:49:38 -0500

>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>
>--_=_NextPart_001_01C05A24.5CDF7126
>Content-Type: text/plain;
>   charset="iso-8859-1"
>
>A Query is an Array.
>
>-Original Message-
>From: Manam Suresh [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, November 29, 2000 11:38 AM
>To: CF-Talk
>Subject: Query as a structure
>
>
>Is query a structure  in CF 4.01?
>How can I convert a query to a structure in CF 4.01?
>
>Thanks
>Kumar
>
>~~
>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
>
>--_=_NextPart_001_01C05A24.5CDF7126
>Content-Type: text/html;
>   charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>
>
>charset=3Diso-8859-1">
>5.5.2650.12">
>RE: Query as a structure
>
>
>
>A Query is an Array.
>
>
>-Original Message-
>From: Manam Suresh [HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]ONT>
>Sent: Wednesday, November 29, 2000 11:38 AM
>To: CF-Talk
>Subject: Query as a structure
>
>
>
>Is query a structure  in CF 4.01?
>How can I convert a query to a structure in CF =
>4.01?
>
>
>Thanks
>Kumar
>
>
>SIZE=3D2>~~
>Structure your ColdFusion code with Fusebox. Get the =
>official book at http://www.fusionauthority.com/bkinfo.cfm" =
>TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm
>
>
>Archives: HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
>TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=
>
>Unsubscribe: HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
>TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
>
>
>
>
>
>--_=_NextPart_001_01C05A24.5CDF7126--
>~~
>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
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.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: CFEXPRESS

[Ben Forta]

It is at www.allaire.com/cfexpress



-Original Message-
From: Kelly Olson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 12:15 PM
To: CF-Talk
Subject: CFEXPRESS


Does anyone have a copy of CFEXPRESS that could mail me off line.  It was
mentioned that it was available at allaire, but it seems to be really
difficult to find or taken of of the site.

Kelly Olson
[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

~~
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

application timeout

[Won Lee]

What is the advantages of having your application timeout?

Won
~~
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

? -> /

[Michel Vuijlsteke]

Hi,

I abhorr pages that have that blatant "generated" feel.

When at all possible, I have URLs like 

http://www.zog.org/beat/disc.cfm/lovemedo
instead of something like .../disc.cfm/disc_id=218

We're about to move to Fusebox, but the one thing that's holding me back is
those ugly index.cfm/fuseaction=this¶m=that¶m2=the_other URLs. The
fact that I personally dislike them, *and* the fact that they don't get
indexed properly (being branded as "dynamic pages liable to change a lot and
thus not worth indexing").

Does anyone here have a standardized way of dealing with this? 
I do not feel like reinventing the wheel; if there's a custom tag or a CF
snippet out there that'll convert this:

http://site.domain/shownews/display/long/items/5/59206/46728610

into the equivalent of this:

address = http://site.domain/index.cfm
fuseaction = shownews 
display = long
items = 5
CFID = 59206
CFTOKEN = 46728610

To clarify: the last two parameters are always CFID and CFTOKEN.
The first parameter is always FUSEACTION.
Anything between the first and the one but last parameter is a list of
paired parameters & values.

I suppose I could live with a URL like this 

http://site.domain/index.cfm/shownews/display/long/items/5/59206/46728610
or even like this (leaving CFID & CFTOKEN in cookies)
http://site.domain/index.cfm/shownews/display:long/items:5
or
http://site.domain/index.cfm/shownews/display=long/items=5
...but I don't really think it makes that much of a difference.

Looking forward to you replies,

Michel Vuijlsteke
Managing Director
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: CFEXPRESS

[Garza, Jeff]

Try doing a search of the allaire site.  I found it quite easily. 

http://www.allaire.com/Handlers/index.cfm?ID=1&Method=Full&Cache=Off

Jeff Garza
Web Developer
Spectrum Astro, Inc.
480-892-8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Kelly Olson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 10:15 AM
To: CF-Talk
Subject: CFEXPRESS


Does anyone have a copy of CFEXPRESS that could mail me off line.  It was
mentioned that it was available at allaire, but it seems to be really
difficult to find or taken of of the site.

Kelly Olson
[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
~~
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 in cferror templates

[Michael Dinowitz]

I covered this in a presentation a while back. Basically, you can add a
CFERROR type=monitor which can be used to run CF code when an error occurs.
http://www.fusionauthority.com/alert/index.cfm?alertid=34#tech1

> Hi,
>
> I thought it would be useful to have any Request errors emailed to me, so
I
> added the necessary  code to my Request Error template, but it
> failed to work.
>
> Does anyone have a workaround for this?
>
> Will
>
> ~~
> 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

~~
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: ? -> /

[Cameron Childress]

Check out the fusebox site.  The formurl2attrubuites custom tag supports
this type of URL syntax.

-Cameron


Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 12:34 PM
> To: CF-Talk
> Subject: ? -> /
>
>
> Hi,
>
> I abhorr pages that have that blatant "generated" feel.
>
> When at all possible, I have URLs like
>
> http://www.zog.org/beat/disc.cfm/lovemedo
> instead of something like .../disc.cfm/disc_id=218
>
> We're about to move to Fusebox, but the one thing that's holding
> me back is
> those ugly index.cfm/fuseaction=this¶m=that¶m2=the_other URLs. The
> fact that I personally dislike them, *and* the fact that they don't get
> indexed properly (being branded as "dynamic pages liable to
> change a lot and
> thus not worth indexing").
>
> Does anyone here have a standardized way of dealing with this?
> I do not feel like reinventing the wheel; if there's a custom tag or a CF
> snippet out there that'll convert this:
>
> http://site.domain/shownews/display/long/items/5/59206/46728610
>
> into the equivalent of this:
>
> address = http://site.domain/index.cfm
> fuseaction = shownews
> display = long
> items = 5
> CFID = 59206
> CFTOKEN = 46728610
>
> To clarify: the last two parameters are always CFID and CFTOKEN.
> The first parameter is always FUSEACTION.
> Anything between the first and the one but last parameter is a list of
> paired parameters & values.
>
> I suppose I could live with a URL like this
>
> http://site.domain/index.cfm/shownews/display/long/items/5/59206/46728610
> or even like this (leaving CFID & CFTOKEN in cookies)
> http://site.domain/index.cfm/shownews/display:long/items:5
> or
> http://site.domain/index.cfm/shownews/display=long/items=5
> ...but I don't really think it makes that much of a difference.
>
> Looking forward to you replies,
>
> Michel Vuijlsteke
> Managing Director
> 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

~~
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: ? -> /

[Bill Killillay]

Michel

Take a good long look at Fusebox.  We have some tags that we
use with fusebox that just EXACTLY what you want, and in my
opinion Fusebox is a great way to develop as well.  IT does
allow good reuse of code if done correctly.  It is not the
holy grail, but it's gaining speed every day and it's a good
way to developed.  www.fusebox.org.  Check it out.  I am
sure you will get a few emails saying this, but what the
heck, what's one more.

Bill


~~
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: application timeout

[Todd Ashworth]

Application timeout is how long your Application variables exist before
being cleared from memory.

If that's what you are refering to, the advantage is that your memory
variables are cleared from memory on a regular basis instead of existing
forever causing all of your memory to be used up and your machine to crash.

Todd Ashworth

- Original Message -
From: "Won Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 12:26 PM
Subject: application timeout


| What is the advantages of having your application timeout?
|
| Won


~~
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: application timeout

[Jeffry Houser]

   Well, I think you are referring to the application timeout attribute 
of the CFAPPLICATION tag, correct?  

  This is meant for application variables.  Application variables are 
stored in RAM.  If no one is using the application, there is no need to 
continue to hold the the memory hostage.  

   Someone else can feel free to elaborate.  


Won Lee wrote:
> 
> What is the advantages of having your application timeout?
> 
> Won
> ~~
> 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

-- 
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 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 Acoustic 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: ? -> /

[Jeremy Ridout]

Have a look at the fusebox tags on www.fusebox.org. There is one called
FormURL2Attributes.cfm. It primarily rescopes all URL and Form variables to
Attributes. But it can also convert ? and = to / like you want. I used it at
my site, works great.

here is the direct link to the file
http://www.fusebox.org/files/tags/formurl2attributes.zip

Jeremy



> -Original Message-
> From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 11:34 AM
> To: CF-Talk
> Subject: ? -> /
> 
> 
> Hi,
> 
> I abhorr pages that have that blatant "generated" feel.
> 
> When at all possible, I have URLs like 
> 
> http://www.zog.org/beat/disc.cfm/lovemedo
> instead of something like .../disc.cfm/disc_id=218
> 
> We're about to move to Fusebox, but the one thing that's 
> holding me back is
> those ugly 
> index.cfm/fuseaction=this¶m=that¶m2=the_other URLs. The
> fact that I personally dislike them, *and* the fact that they 
> don't get
> indexed properly (being branded as "dynamic pages liable to 
> change a lot and
> thus not worth indexing").
> 
> Does anyone here have a standardized way of dealing with this? 
> I do not feel like reinventing the wheel; if there's a custom 
> tag or a CF
> snippet out there that'll convert this:
> 
> http://site.domain/shownews/display/long/items/5/59206/46728610
> 
> into the equivalent of this:
> 
> address = http://site.domain/index.cfm
> fuseaction = shownews 
> display = long
> items = 5
> CFID = 59206
> CFTOKEN = 46728610
> 
> To clarify: the last two parameters are always CFID and CFTOKEN.
> The first parameter is always FUSEACTION.
> Anything between the first and the one but last parameter is a list of
> paired parameters & values.
> 
> I suppose I could live with a URL like this 
> 
> http://site.domain/index.cfm/shownews/display/long/items/5/592
06/46728610
or even like this (leaving CFID & CFTOKEN in cookies)
http://site.domain/index.cfm/shownews/display:long/items:5
or
http://site.domain/index.cfm/shownews/display=long/items=5
...but I don't really think it makes that much of a difference.

Looking forward to you replies,

Michel Vuijlsteke
Managing Director
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
~~
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: MS SQL Shortcut?

[Jonathan McGuire]

Try
SELECT ISNULL(SUM(paymentamt),0) as total

Remember, SQL Server returns true nulls.  CF in its infinite wisdom does not
support NULL.  When Null is returned, CF converts it to an empty string.

Jonathan McGuire
VP of Engineering
Impact Solutions, Inc.
704-568-0122
[EMAIL PROTECTED]
Smart Automotive Business Solutions

-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 22, 2000 5:26 PM
To: CF-Talk
Subject: Re:MS SQL Shortcut?


I havn't tested this, but you should be able to do either of the following:
SELECT (Sum(paymentamt) + 0) AS total
or
SELECT CAST(Sum(paymentamt) AS int) AS total

Chris

--
Original Message
From: "Jim McAtee"<[EMAIL PROTECTED]>
Subject: MS SQL Shortcut?
Date: Wed, 22 Nov 2000 15:14:34 -0700

>I've got a table that contains payment detail records and I've found that
>something like the following workaround is necessary when adding up a
column
>contains the dollar amount.  This query always returns a single record, but
>when there are zero payment records found, the 'total' field returns a
>zero-length string rather than returning 0.  Of course, if I later attempt
>to user that value in a CF arithmetic expression, CF chokes and gives an
>'unable to convert' to numeric error.  I've got a lot of these summing
>queries and was wondering if there's a way within the SQL statement (MS
>SQL7) to return 0 if there are no records found.
>
>
>
>SELECT Sum(paymentamt) AS total
>FROM payments
>WHERE userid = #form.userid#
>
>
>
>
>  
>
>
>
>Thanks,
>Jim
>
>~~
>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
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.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


~~
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: ? -> /

[Sean Daniels]

The custom tag  does almost exactly that. You can get
it at www.fusebox.org.


- Sean

~~
  Sean Daniels
  Manager, Engineering
  Marketplace Technologies
  (T): 207.363.7374
  (C): 207.332.6340
~~
  http://www.dealforce.com
  http://www.mergernetwork.com


> -Original Message-
> From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 12:34 PM
> To: CF-Talk
> Subject: ? -> /
>
>
> Hi,
>
> I abhorr pages that have that blatant "generated" feel.
>
> When at all possible, I have URLs like
>
> http://www.zog.org/beat/disc.cfm/lovemedo
> instead of something like .../disc.cfm/disc_id=218
>
> We're about to move to Fusebox, but the one thing that's holding
> me back is
> those ugly index.cfm/fuseaction=this¶m=that¶m2=the_other URLs. The
> fact that I personally dislike them, *and* the fact that they don't get
> indexed properly (being branded as "dynamic pages liable to
> change a lot and
> thus not worth indexing").
>
> Does anyone here have a standardized way of dealing with this?
> I do not feel like reinventing the wheel; if there's a custom tag or a CF
> snippet out there that'll convert this:
>
> http://site.domain/shownews/display/long/items/5/59206/46728610
>
> into the equivalent of this:
>
> address = http://site.domain/index.cfm
> fuseaction = shownews
> display = long
> items = 5
> CFID = 59206
> CFTOKEN = 46728610
>
> To clarify: the last two parameters are always CFID and CFTOKEN.
> The first parameter is always FUSEACTION.
> Anything between the first and the one but last parameter is a list of
> paired parameters & values.
>
> I suppose I could live with a URL like this
>
> http://site.domain/index.cfm/shownews/display/long/items/5/59206/46728610
> or even like this (leaving CFID & CFTOKEN in cookies)
> http://site.domain/index.cfm/shownews/display:long/items:5
> or
> http://site.domain/index.cfm/shownews/display=long/items=5
> ...but I don't really think it makes that much of a difference.
>
> Looking forward to you replies,
>
> Michel Vuijlsteke
> Managing Director
> 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

~~
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: application timeout

[pan]

From: "Won Lee" <[EMAIL PROTECTED]>



> What is the advantages of having your application timeout?
> 

Among other things, it would be nice to have a way to change the
value of the timeout without having to stop/start the server.


~~
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

Single Thread

[Jim Gurfein]

Is there any performance hit by setting CF to Single Thread?

~~
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: application timeout

[Todd Ashworth]

You just change the value in your cfapplication tag in your Application.cfm
file ... ?

Todd Ashworth

- Original Message -
From: "pan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 1:26 PM
Subject: Re: application timeout


|
| From: "Won Lee" <[EMAIL PROTECTED]>
|
|
|
| > What is the advantages of having your application timeout?
| >
|
| Among other things, it would be nice to have a way to change the
| value of the timeout without having to stop/start the server.


~~
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: Getting info from IIS

[lsellers]

> As an alternative, you might consider a third-party component to do this
> stuff for you. There's a CFX available, the Intranet Hosting Toolkit, from
> Lewis Sellers:
>
> http://www.intrafoundation.com/
>
> There are also quite a few COM objects, such as SA-Admin, which work very
> well from CF:

I've been doing some COM work lately. I'm half-way tempted to convert the
entire ihtk to COM now. Fortunately I'm not completely insane so that
probably won't happen anytime soon. :)

But it is tempting.

--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

Pre Selecting CFTREE Nodes

[Jonathan]

Hey...


I have a CFTree control in a left frame.  When a user clicks on a leaf, it
presents a form in the right frame.  The form basically allows them to add
new nodes / leafs to the tree.

When the form is submitted, it updates the database with the new tree info,
and then refreshes the tree control in the left frame so that the user can
see the change.

My only problem is that I cannot keep track of what's expanded, and so i
cannot pre-expand anything when the tree is refreshed.

Does anyone know how to do this?

Thanks!

- Jonathan



~~
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 CRs

[Jay Jennings]

> I believe CFMAIL handles the formatting of whatever text is placed inside
> it, much the way HTML  tags do.

That's what I thought, too. So I'm wondering why my emails show up all on
one line?

Like I said, one page generates two emails. The first comes all on one line,
the second shows up formatted correctly. Arrrggghhh!

 jay

~~
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: Single Thread

[Howie Hamlin]

By doing this you create a single-user system in effect.  Only one request
will be handled at any one time.  I would follow Allaire's recommendation of
4-5 threads per CPU.

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server

- Original Message -
From: "Jim Gurfein" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 1:35 PM
Subject: Single Thread


> Is there any performance hit by setting CF to Single Thread?
>


~~
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: application timeout

[Philip Arnold - ASP]

> What is the advantages of having your application timeout?

In it's simplest terms... say you have 5 sites on your server, but one is
used very rarely, it would be a waste to take up server memory with
application data that is used once a month, so if you time it out after a
day, then you know that the information will be there if you wish to use it
for a brief period, but if the site isn't used for that period, then the
information will be removed from memory...

Hope I explained it well enough...

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: ? -> /

[paul smith]

Using a modified Fusebox style, and without using any of the Fusebox tags, 
it's pretty easy to code your own app_global.cfm and have URLs like 
http://www.zog.org/beat/index.cfm/lovemedo.htm where "beat" is the folder 
name AND the fuseaction name, index.cfm CFINCLUDES the templates you need 
for the fuseaction "beat", and "lovemedo" is a parameter value needed by 
the fuseaction "beat" (and the ".htm" is simply stripped off before you 
recover the value "lovemedo").

I've gone even further in a developing app and use URLs like:

http://www.MyApp.com/HL/LL/OA/OO/index.cfm/IN.845/CD.50022/CN.37115146/HD.475000/AL.B/LL.E/OR.5260.HTM

where I parse the "/" delimited list to obtain the value of several passed 
parameters (the value of OR is 5260, for example).  I use the folder 
sequence "/HL/LL/OA/OO/" to define a "Breadcrumb Trail" that allows users 
to "one-click" to ANY earlier page in the user's current path.

best,  paul

At 06:33 PM 11/29/00 +0100, you wrote:
>I abhorr pages that have that blatant "generated" feel.
>
>When at all possible, I have URLs like
>
>http://www.zog.org/beat/disc.cfm/lovemedo
>instead of something like .../disc.cfm/disc_id=218

~~
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: MS SQL Shortcut?

[Jim McAtee]

Jonathan,

Thanks.  Is that considered the "correct" way to do this?  I assume the
IsNull() function is interpreted as "if the first argument is null return
the second argument"?

Using Chris' suggestion worked quite well.

Sum(paymentamt) + 0 AS total

Thanks,
Jim


- Original Message -
From: "Jonathan McGuire" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 11:28 AM
Subject: RE: MS SQL Shortcut?


> Try
> SELECT ISNULL(SUM(paymentamt),0) as total
>
> Remember, SQL Server returns true nulls.  CF in its infinite wisdom does
not
> support NULL.  When Null is returned, CF converts it to an empty string.
>
> Jonathan McGuire
> VP of Engineering
> Impact Solutions, Inc.
> 704-568-0122
> [EMAIL PROTECTED]
> Smart Automotive Business Solutions
>
> -Original Message-
> From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 22, 2000 5:26 PM
> To: CF-Talk
> Subject: Re:MS SQL Shortcut?
>
>
> I havn't tested this, but you should be able to do either of the
following:
> SELECT (Sum(paymentamt) + 0) AS total
> or
> SELECT CAST(Sum(paymentamt) AS int) AS total
>
> Chris

~~
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

CUS Xmas Party!!

[Brian L. Wolfsohn]

All cf'ers are invited.  This is not a recruitment ad.  We have NO 
COLDFUSION JOB OPENINGS.  There is no hidden agenda.. There will be no 
recruiting at the party.  We are NOT a recruiting firm.. If someone tries 
any recruiting, that's what we have the pool for... So, throw all 
recruiters in the pool... The rest of you can enjoy the party and talk 
amongst yourselves...

 You're Invited
 To the 16th Annual C-U-S
 Not-So-Traditional Xmas Party & Awards Presentation

   Saturday, December 16th, 2000 (12/22/2001)
   7:30 P.M. to Whenever

From All of us - to All of You - A wish for Happiness in a world at peace

Please come share the spirit of this joyous season with us
(It can be this way always)

C-U-S Business Systems

20210 S.W. 48th Place

Fort Lauderdale, FL 2-1096


Expected Weather:
Temperature usually around 70, could be cooler,  so bring a sweater just in 
case. By official edict:  NO RAIN;  NO HURRICANES !!



Directions to Brian's

20210 SW 48th Place

1. Wear clean underwear.. (Don't ask...)

2. Get off plane in Fort  Lauderdale.  (Separate directions are available 
for those flying into Miami.)

3. Take I-595 West to I-75 South.

4. Go South on I-75 to Griffin Road West.

5. Griffin Road West 4.2 miles to 202nd Ave,  immediately after the stand 
of pine trees in the center island.

6. Left (South) on 202nd. Go 2 blocks to S.W. 48th Place.

7. Right on S.W. 48th Place.  We're the second house on the left.  Park 
wherever you can find a spot  in the surrounding 4 blocks.

8. If you see any alligators, you went about 1 mile too far  (as long 
as you went too far, please check for the remains of my  great aunt Alice 
who got lost on her way to the party 4 years ago.)

PS You don't have to arrive by plane. Trains, boats, horseback & cars are 
all allowed.  There will be camping on-site again this year as but the 
rooms are full-up at the Wolfsohn Inn.  So, if you have camping gear, feel 
free to bring it.  If you're not the camping type,  there are hotels in the 
area. Just call the office for specifics. (Dave Cambest, two young ladies 
who say they met you at something called “treasure island” were asking 
about your "campground tours".. Would  you like to fill in the host on what 
you have planned here.. )

PPS  The driveway is reserved for Miatas (& John McCracken )

PPPS There will be a secure room for the folk club to store their 
instruments and extra band members.

Attire Dress Optional. (Pants also optional)

Ozzie,  Requests are pouring in from all over the folkincountry for your 
Tina Turner outfit.

Heather, Your halloween outfit won't work for the xmas party.

Sandy, On the other hand, YOUR halloween outfit might..

Clayton, Jeans, not those pajama things you parade around in..SFSF

Donna, No, you can't wear the postman.

Jack Hardy, An orange shirt would be nice..

Steve G., No, you can't wear Robby's clothes. (but, I hear Susan M. has an 
outfit you can wear).

Kid: Even those white pants won't get you in the door.

Billy M. No, you can't just wear your mandolin !!

Birthday Boys and Birthdays Girls:  You are NOT required to wear your 
birthday suits.. (this includes you, Donna)

(Everyone else... You're on your own… Good luck)


Age Requirements   18 or Over; 100 or under

Food   More than you could eat in two days..  So, arrive hungry..  And take 
food home...

Drink   Of course, but don't drink & drive.  Designated drunks must 
identify themselves at check-in.

Party   Officially begins at 7:30 p.m.  Slave labor, oops early arrivals 
are welcome.

Awards Ceremony   Approximately 10:00 p.m.  I promise; this year, the 
awards ceremony will be finished by the time the garbage is picked up 
Monday morning..

Musical Entertainment   Immediately after the awards, there will be a very 
special musical guest.  Don't miss this very, very special talent.


RSVP by December 8th

RSVP: This means you take 5 seconds out of your busy schedule, turn down 
that Milli Vanilli album, Sean Williams,  & tell us whether  or not you're 
coming to the party.  (Even if you are just reading this and don't know us, 
tell us you read it and aren't coming!!) We need to know whether  to get 3 
or 4 suckling  pigs for the roast. (Not to worry,  we use only kosher 
pigs)  We also need to know whether to order  3 or 4 virgins (mixed sexes) 
for sacrifice to the party gods.

Please contact us at (954)  680-6545 to rsvp  or to volunteer for the 
sacrifices, or e-mail to  [EMAIL PROTECTED]


Entertainment

1. Nicole will be demonstrating what she learned this year in knife 
throwing at the circus - 101.  It's not too late to volunteer to be her 

RE: Single Thread

[Philip Arnold - ASP]

> Is there any performance hit by setting CF to Single Thread?

If it's a real-world site, then hell yeah!

Think about this - if you're reading from a database and your queries and
calculations take 2-3 seconds, then nobody else can get a result from your
server until that process has finished!

Allaire has guidelines on how many threads you should set your server to (I
think it's something like 3-4 per processor), but I still think that's a
little low (especially if your machine only server CF and the website)

HTH

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: ? -> /

[Philip Arnold - ASP]

> I abhorr pages that have that blatant "generated" feel.
>
> When at all possible, I have URLs like
>
> http://www.zog.org/beat/disc.cfm/lovemedo
> instead of something like .../disc.cfm/disc_id=218
>
> We're about to move to Fusebox, but the one thing that's holding
> me back is
> those ugly index.cfm/fuseaction=this¶m=that¶m2=the_other URLs. The
> fact that I personally dislike them, *and* the fact that they don't get
> indexed properly (being branded as "dynamic pages liable to
> change a lot and
> thus not worth indexing").
>
> Does anyone here have a standardized way of dealing with this?
> I do not feel like reinventing the wheel; if there's a custom tag or a CF
> snippet out there that'll convert this:
>
> http://site.domain/shownews/display/long/items/5/59206/46728610
>
> into the equivalent of this:
>
> address = http://site.domain/index.cfm
> fuseaction = shownews
> display = long
> items = 5
> CFID = 59206
> CFTOKEN = 46728610
>
> To clarify: the last two parameters are always CFID and CFTOKEN.
> The first parameter is always FUSEACTION.
> Anything between the first and the one but last parameter is a list of
> paired parameters & values.
>
> I suppose I could live with a URL like this
>
> http://site.domain/index.cfm/shownews/display/long/items/5/59206/46728610
> or even like this (leaving CFID & CFTOKEN in cookies)
> http://site.domain/index.cfm/shownews/display:long/items:5
> or
> http://site.domain/index.cfm/shownews/display=long/items=5
> ...but I don't really think it makes that much of a difference.

I actually wrote my own interpreter for the last version of this as I really
like this method... it's a lot easier to read than just slashes in the URL

The other advantage to slash based sites is that most search engines can
actually get into your information (as they think it's a directory
structure) when they can't get into one that uses ? and &

You've still got to use things like CFQueryParam to stop nasty people
putting ; and more SQL onto your parameters, but that's a problem no matter
what you do.

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: CFMail CRs

[Philip Arnold - ASP]

> This sounds like a stupid newbie question (is the newbie stupid
> or is it the
> question?) but I'm bonking my head against my monitor right now...
>
> Take a look at the code down below. Two CFMAIL things. The first sends an
> email with no carriage returns -- everything's on one line (that
> wraps). The
> second CFMAIL sends the email as it's formatted. What's the difference?
>
> The code:
>  subject="Broker Info Requested" server="#mailserver#">

> 
>
> 
> #first_name# #last_name#,
> Thank you for requesting info on the broker plan
> from http://www.DentalPlanInfo.com
> I'll be mailing you information on starting your own Dental Plan
> business, but if you have any immediate questions, feel free to
> call me at 1-888-328-1660 (9AM to 9PM Pacific).
>
> Jay Jennings
> Broker
> DentalPlanInfo.com
> 

OK, because you have a CR at the end of your CFIF, then it'll appear as a
blank line if the if  doesn't fire...

What I do is to build the mail into a string and send that string, but as
Simon has pointed out, use Chr(13) & Chr(10) for you end of line, that way
you can build the message as you want it, without any gaps or blanks

HTH

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: CFMail CRs

[paul smith]

 ?

At 10:53 AM 11/29/00 -0800, you wrote:
>That's what I thought, too. So I'm wondering why my emails show up all on
>one line?

~~
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: Single Thread

[Dave Watts]

> Is there any performance hit by setting CF to Single Thread?

If you're referring to the "single threaded sessions" option within the
Locking section, there is a potential performance hit. If, for example,
you're using frames within an application, and you're using CF to generate
the content within more than one of those frames, those CF scripts can't run
concurrently. I imagine that handling the request queue in this case might
get a bit complicated.

On the other hand, using single-threaded sessions means that you won't have
to worry about using CFLOCK with session variables, so if you have an
existing CF app which uses session variables without CFLOCK, it'll probably
run better under load with the single-threaded session option selected.

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: CUS Xmas Party!!

[paul smith]

Are you sure you won't be still counting ballots? (running and ducking ;-)

At 02:06 PM 11/29/00 -0500, you wrote:
>All cf'ers are invited.  This is not a recruitment ad.  We have NO
>COLDFUSION JOB OPENINGS.  There is no hidden agenda.. There will be no
>recruiting at the party.  We are NOT a recruiting firm.. If someone tries
>any recruiting, that's what we have the pool for... So, throw all
>recruiters in the pool... The rest of you can enjoy the party and talk
>amongst yourselves...
>
>  You're Invited
>  To the 16th Annual C-U-S
>  Not-So-Traditional Xmas Party & Awards Presentation
>
>Saturday, December 16th, 2000 (12/22/2001)
>7:30 P.M. to Whenever
>
> From All of us - to All of You - A wish for Happiness in a world 
> at peace
>
> Please come share the spirit of this joyous season with us
> (It can be this way always)
>
>C-U-S Business Systems
>
>20210 S.W. 48th Place
>
>Fort Lauderdale, FL 2-1096

~~
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: Single Thread

[paul smith]

At the Conference I heard 3 for ColdFusion-intensive apps and 5 for 
ColdFusion apps that use a lot of Database.  Then I also heard the Allaire 
test team say at the Conference they do onsite testing with values like 20, 
etc! to determine, for THAT app, what value to use.

best,  paul

At 07:07 PM 11/29/00 +, you wrote:
>Allaire has guidelines on how many threads you should set your server to (I
>think it's something like 3-4 per processor), but I still think that's a
>little low (especially if your machine only server CF and the website)

~~
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

Printing Help

[Kim Ahlbrandt]

I need to know if there is a way to make a report print nicely using the
browser.  I have a nicely formatted report written in coldfusion...it looks
great on the screen but when it prints, I need to include page breaks so
that the column titles will be on every page.

Any Suggestions??

Thanks,

Kim Ahlbrandt

~~
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: Single Thread

[Jim Gurfein]

We've been having a terrible time with CF crashing since installing 
4.51sp2. Here's what we've done:

1) Locked all session variables
2) Changed all CFX_http to CFHTTP
3) Changed all CFX_UUID to #createuuid()#
4) Reset CF to use "single threaded sessions"

We put out about 200,000 pages per day on our server. Before the upgrade to 
4.51 (4.01) the system was fairly stable, but since then we've experienced 
horrible crashes every 6 hours. Finally, we set "single threaded sessions" 
and seem to be more stable (running about 150mg of memory climbing slowly)

If anyone has any Ideas, we'd love to hear them!!!




> > Is there any performance hit by setting CF to Single Thread?
>
>If you're referring to the "single threaded sessions" option within the
>Locking section, there is a potential performance hit. If, for example,
>you're using frames within an application, and you're using CF to generate
>the content within more than one of those frames, those CF scripts can't run
>concurrently. I imagine that handling the request queue in this case might
>get a bit complicated.
>
>On the other hand, using single-threaded sessions means that you won't have
>to worry about using CFLOCK with session variables, so if you have an
>existing CF app which uses session variables without CFLOCK, it'll probably
>run better under load with the single-threaded session option selected.
>
>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

Sincerely yours,

Jim Gurfein
President, CEO
RestaurantRow.com, Inc.
http://www.restaurantrow.com
914.921.3200 ext 101
914.921.9190 fax

~~
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: application timeout

[pan]

[Won]
> | > What is the advantages of having your application timeout?
> | >
[Pan]
> | Among other things, it would be nice to have a way to change the
> | value of the timeout without having to stop/start the server.

[Todd]
> You just change the value in your cfapplication tag in your Application.cfm
> file ... ?

I could be wrong, but 

if not timeout in cfapplication tag
 then admin defaults apply
 and persist until start/stop

if timeout in cfapplication tag
 then app timeout over rides admin defaults
 and appVar persist until timeout expires
 unless stop/start

I think that if you want to change cfapp timeout you
have to wait until previously set cfapp timeout expires

That doesn't make sense, does it?
When I have wanted to change cfapp timeout it's
just been easier to start/stop - it seems (anecdotally)
that cfapp timeout can't be changed just by rewriting the
value in the application.cfm script. 

Is cfapplication.timeout an addressable value in memory?

It seems like I was just playing with this yesterday - maybe it
was sessiontimeout, which does respond quickly to script
changes - which makes sense as it is not a value read or
useful until a session starts. application timeout seems to
persist regardless of whether a new session has started.
Will have to experiment more when time permits.

Pan


~~
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: Printing Help

[Adrian Cesana]

Ive used this for breaks and seems to work well.

 

Hope it helps,Adrian




-Original Message-
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]

I need to know if there is a way to make a report print nicely using the
browser.  I have a nicely formatted report written in coldfusion...it looks
great on the screen but when it prints, I need to include page breaks so
that the column titles will be on every page.

~~
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: CUS Xmas Party!!

[Brian L. Wolfsohn]

At 02:29 PM 11/29/00 , you wrote:
>Are you sure you won't be still counting ballots? (running and ducking ;-)

Actually, while there won't be any recruiting going on, we will have a 
ballot counting hour around 1AM..

>At 02:06 PM 11/29/00 -0500, you wrote:
> >All cf'ers are invited.  This is not a recruitment ad.  We have NO
> >COLDFUSION JOB OPENINGS.  There is no hidden agenda.. There will be no
> >recruiting at the party.  We are NOT a recruiting firm.. If someone tries
> >any recruiting, that's what we have the pool for... So, throw all
> >recruiters in the pool... The rest of you can enjoy the party and talk
> >amongst yourselves...
> >
> >  You're Invited
> >  To the 16th Annual C-U-S
> >  Not-So-Traditional Xmas Party & Awards Presentation
> >
> >Saturday, December 16th, 2000 (12/22/2001)
> >7:30 P.M. to Whenever
> >
> > From All of us - to All of You - A wish for Happiness in a world
> > at peace
> >
> > Please come share the spirit of this joyous season with us
> > (It can be this way always)
> >
> >C-U-S Business Systems
> >
> >20210 S.W. 48th Place
> >
> >Fort Lauderdale, FL 2-1096

~~
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 Fails to Send

[Drechsler, Jennifer]

It seems that I am having the same problem with space in the From field of a
form that people are filling out.  How can I remove those spaces before the
mail is sent?

Jen D.
SFPUC, ITS

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 12:15 PM
To: CF-Talk
Subject: RE: CFMAIL Fails to Send


Are there spaces in your From address?  I've known of a but where the mail
would fail to send in such cases.  I do not know if this is supposed to have
been fixed yet... but you can put it on your list of possible culprits.

> -Original Message-
> From: Sean Daniels [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 2:32 PM
> To: CF-Talk
> Subject: CFMAIL Fails to Send
> 
> 
> I am using an SMTP service running on the local machine to 
> send outgoing
> mails. In the CFAdmin the server verifies fine. But when I 
> send an email it
> gets stuffed into Undeliverable folder and the mail.log says 
> it was unable
> to connect to the SMTP server.
> 
> Anyone have any suggestions? According to the IT guy at the 
> company the SMTP
> service is working.
> 
> - 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
~~
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-TALK Problem?

[Steve Reich]

> There's a link at the bottom of each email that goes out. :)
> http://www.mail-archive.com/cf-talk@houseoffusion.com/

uhh... I knew that.. I just wanted to see if you knew where they were. ;-)

Thanks,
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: Help With SQL Query

[Gary Groomer]

Using a UNION did the trick.  Thanks for the tip.

Gary

- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 8:21 AM
Subject: RE: Help With SQL Query


> Well, the problem is with your join - each row in table 1 is being joined
> with EVERY row in table 2, so that your result set is 6 rows rather than
3.
> What happens if you take out the where a.user=b.user condition and just
have
> WHERE a.user = 'karl' and b.user = 'karl'?
>
> If you give us a little more information, we might be able to recommend
some
> alternatives.
>
> Some options:
>
> 1) Use a UNION
>
> 2) Use 2 queries
>
>
>
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 10:08 AM
> To: CF-Talk
> Subject: Help With SQL Query
>
>
> I have two tables from which I want the sum of the columns based on a
common
> key.  From the below tables, the desired output is 3,5,1,2.  Instead I get
> 6,10,6,3.  I am sure the solution is simple, but I haven't run into this
one
> before and any help would be appreacited.
>
> Gary
>
> Table1
> ---
> TableIDUserCol1Col2
> 1Karl10
> 2Karl02
> 3Karl23
>
> Table2
> ---
> TableIDUserCol1Col2
> 1Karl10
> 2Karl02
>
> SQL Query
> -
> SELECT Sum(a.Col1), Sum(a.Col2), Sum(b.Col1), Sum(b.Col2)
> FROM Table1 a, Table2 b
> WHERE a.User = b.User
> AND a.User = 'Karl'
>
> ~~
> 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
> ~~
> 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
>
>

~~
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 Fails to Send

[Simon Horwith]

use the trim() function if the spaces are leading or trailling.  Try
Replace(fromvarname,Chr(32),"",ALL)
to kill spaces in the middle of a value

~Simon

> Simon Horwith
> 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: Drechsler, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 29, 2000 2:44 PM
To: CF-Talk
Subject: RE: CFMAIL Fails to Send


It seems that I am having the same problem with space in the From field of a
form that people are filling out.  How can I remove those spaces before the
mail is sent?

Jen D.
SFPUC, ITS

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 12:15 PM
To: CF-Talk
Subject: RE: CFMAIL Fails to Send


Are there spaces in your From address?  I've known of a but where the mail
would fail to send in such cases.  I do not know if this is supposed to have
been fixed yet... but you can put it on your list of possible culprits.

> -Original Message-
> From: Sean Daniels [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 2:32 PM
> To: CF-Talk
> Subject: CFMAIL Fails to Send
> 
> 
> I am using an SMTP service running on the local machine to 
> send outgoing
> mails. In the CFAdmin the server verifies fine. But when I 
> send an email it
> gets stuffed into Undeliverable folder and the mail.log says 
> it was unable
> to connect to the SMTP server.
> 
> Anyone have any suggestions? According to the IT guy at the 
> company the SMTP
> service is working.
> 
> - 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
~~
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
~~
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