RE: Making 2D array

[Christopher Olive, CIO]

there are a coupld of ways to do this.  you have






already.  therefore, each element of filearray[] is a pipe delimited list
over which you can iterate with another list loop.

one of the problems with the acove code is that it will whack the value of
RC each time through.  maybe use a throwaway variable to hold the boolean
result of arrayappend.

therefore, you would have...






then, replacing the inner set with another loop to break up each row of the
file, the code becomes...










if you notice, i added an outer loop count to track where we were in the
file (WRT rows).

this should give you a two dimensional array.  the length of the first array
index is equal to the number of rows in the file.

as a side note, because of the nature of list loops, any empty element in
the file will fail this piece of code.  CF treats multiple delimiters (in
the inner loop's case, | symbols) as one delimiter (for some reason).

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 8:06 PM
To: CF-Talk
Subject: RE: Making 2D array


Thanks.  I already knew cfset filearray = arraynew(2).  It's the rest I
don't know how to do - how to break the text along the rows up into cells at
the pipe character. (the sample text I sent in my original message wrapped -
it was originally 4 lines only)

I need to do this so I can take this large text file, and break it up into 6
smaller files, delete some rows, delete some columns, reformat others, turn
them into tables, and save them as includes for a template to use based on a
form input.

SO thanks for your help Alex, but it doesn't tell me what I need to know.  I
have a large text file, I need to turn it into an array or structure or some
other format so I can manipulate the contents.   I figured using an Array
was the way to do it.

Isnt it?


So I still don't know how to do it.  (sigh)

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks




cfset filearray = arraynew(2)

but what are you going to do with the sencond dimension. why not just load
the data into a db table which is probably the easiest. Or put it in a
structure.

On Wed, 22 Aug 2001, Mike Kear wrote:

> I get  a large ASCII text file every month, and I want to read it into a
2D
> array so I can manipulate it then write it out to a HTML file in a series
of
> tables.   But I'm stumped with the second dimension of the array.  I can
> read it into one dimensional table like this:
>
>
> 
>   
> 
>   
>
> How do I make it into the two dimensional array instead?   Here's a sample
> of the text I get.  I want the elements in the second dimension to break
on
> the pipe character.
>
>
>
> [sample text]
> UBS Asset Management (Australia) Ltd|SBC0813AU|UBS Australian
Bond|339.30|7.77|5.31|8.02|0.42|~|8/55||
> Colonial First State Invest Aust Ltd|FSF0027AU|Col First State Wsale
AustBond|24.42|7.50|5.16|7.88|0.46||7/55||
> IOOF Funds Management|IOF0012AU|IOOF Flex Tr
FI|6.23|6.91|5.14|7.47|1.12|~|5/55||
> Commonwealth Financial Services|COM0011AU|C'Wealth Bond
Fund|146.70|6.68|4.91|6.46|1.11|Not Rated|0/55||
> [end sample]
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: counting of domain-acesses

[Christopher Olive, CIO]

or even more tersely...

HTTP_REFERER=http://www.helloworld.com/thepage/that_the/person.came?from


UserDomain=ListGetAt(HTTP_REFERER, 2, "/")

#UserDomain#

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Trishan Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 12:50 PM
To: CF-Talk
Subject: Re: counting of domain-acesses


HTTP_REFERER=http://www.helloworld.com/thepage/that_the/person.came?from



UserDomain=Replace(CGI.HTTP_REFERER,"http://","";);
DomainEnd=Find("/",UserDomain);
UserDomain=RemoveChars(UserDomain,DomainEnd,Len(UserDomain));

#UserDomain#



- Original Message -
From: "CF-Talk (SD Solutions)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 20, 2001 11:20 AM
Subject: counting of domain-acesses


> Hi list, I want to count accesses of one certain domain on a
customerdomain
> via bannerlinks.
>  ( e.g.: www.exampledomain.com )
> The cgi.http_referer variable gives me an exact url
> But the acesses do come from more than one http_referer
> I haven't found s.th. like: cgi.http_refererdomain
> which would have been helpful.
> Any ideas what I could do ?
>
> Uwe
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Using CFHTTP

[Christopher Olive, CIO]

perhaps you could create a user account on the target machine who's entire
job is to have access to that file/directory.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 10:19 AM
To: CF-Talk
Subject: Using CFHTTP


Hi all,

I'm trying to use the cfhttp tag to get a webpage in a directory on our
server which is not open to the general public.

I don't like the idea of having to hard code a username and password into
the attributes of the cfhttp tag. Is there a way round this?

I've tried to change the login account of the CF service on the server to
one which would allow access to the directory, but no luck there.

Hope someone can help,

Alex Little
Open University
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Subtract Null = Error

[Christopher Olive, CIO]

check out the NVL function.  i'm assuming this is SQL server.  if you
NVL(total, 0) in your sql query, it will substitute 0 for the NULL values.
i'm also assuming that negative #newtotal# is ok.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Gryphawk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 4:41 AM
To: CF-Talk
Subject: Subtract Null = Error


Hi there

I was hoping you could help me with a problem - I have a calculated value
from the following code:

#newTotal#


Which works just fine when the Recordset2.TOTAL and Recordset1.TOTAL are
populated by the SQL (as set by search parameters on a previous page).

However, on occasion Recordset2.Total is equal to nothing (null?) while
Recordset1.TOTAL has a value due to the search string, and when this
happens, CF throws an error which reads:

"An error occurred while evaluating the expression:

  newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)

 Error near line 316, column 17.

 Cannot convert to number."

Is there anyway to get around this such as an If Recordset.TOTAL = nothing,
Then [don't subtract]?

My apologies that I am only just starting to learn how to write coded stuff.

Many thanks,

Gryphawk
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL and MS SMTP

[Christopher Olive, CIO]

we use IIS's SMTP extensively with CFMAIL.

do you have IIS set to allow the CF machine to relay?  it's a common error,
and one that most security minded folks ignore, since they turn it off by
default.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 3:57 PM
To: CF-Talk
Subject: CFMAIL and MS SMTP


I'm attempting to send mail from CF to IIS4's SMTP service.  For some reason
it doesn't look like it's accepting the mail.  CF spools it fine, and the
cfusion/logs/mail.log file doesn't report any errors.
cfusion/logs/sentmail.log reports that the message was sent correctly.  The
message does not end up in cfusion/mail/undeliverd.

The SMTP service's logs report the following:

19:32:15 130.205.XXX.XXX MAIL FROM - 250
19:32:15 130.205.XXX.XXX RCPT TO - 250
19:32:15 130.205.XXX.XXX QUIT - 0

It looks like the data is being sent to the SMTP service, but then the
message just vanishes into thin air!  It's not in the queue directory or the
badmail directory or any other directory in the SMTP service's root.  It
also doesn't get received by the recipient, and a review of the mail server
it's addressed to reveals that MS SMTP didn't even try to open a connection
to it.

Has anyone else seen anything like this?  Anyone else use the MS SMTP
service for outgoing mail?

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Netscape / CF4.0 / Apache /

[Christopher Olive, CIO]

that's because CFLOCATION essentially sends a "302" header.  it instructs
the browser to go to that location because the "resource has been moved"...

sounds like your browser(s) don't know how to follow the link automatically.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Dasher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 2:55 PM
To: CF-Talk
Subject: Netscape / CF4.0 / Apache / 


Netscape 4.xx / IE for MAC

Cold Fusion 4.0

Apache on Unix

--

When we use 
we get this weird page that says:

HTTP/1.1 302 Found Date: .Apache/1.3.6(Unix)

The document has been moved here

where "here" is a link to the page we wanted to
 to in the first place.

Does anyone have a soultion for this?

Thanks,
-- Dasher
[EMAIL PROTECTED]
http://www.bentmedia.com/
Bent Media, Inc.
128 South Clark Street
New Orleans, LA 70119-6103
Phone - 504.488.2848 x19
Fax - 504.488.2979
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF trojen? BackdoorJY.sv

[Christopher Olive, CIO]

actually, microsoft has a good article on hardening IIS5.  don't have 
the
link right now, but go to microsoft.com and search for "securing 
IIS5".

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Surma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 9:31 AM
To: CF-Talk
Subject: Re: CF trojen? BackdoorJY.sv


>Rather than relying on Microsoft
> patches, you'll get better mileage out of properly configuring your
servers
> up front. Here's a little secret of mine. I don't bother installing
most
of
> the IIS patches when they come out. I don't have to, because they
patch
> things that I've already disabled or removed. I can wait until
everyone
else
> has regression-tested the patch on their production web servers.

Can you throw us bone, and point us to some information on how to
strip down
a CF, IIS Server?

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

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

RE: DTS from Store Procedure MSQL 7.0

[Christopher Olive, CIO]

actually, i started down that road.  tried "REMOTE".  didn't know i had to
use the CLSID instead of the name (how does one go about finding that?).
the fact that CF has to be logged on as admin instead of system is another
problem.  the whole reason i'm trying to do this is for security purposes,
anyway, so it seems like this might not be the way.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 2:48 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0


I saw this at CF Comet, at
http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=F05079C2-EAB3-4B25-
B9EEA9B47F3186F5.  Perhaps this covers your situation.

-David

If your object is external to the Web server, use the CONTEXT="Remote"
attribute of CFOBJECT as well as the CLSID (class ID) for the object in the
CLASS attribute, which looks like {----}
(your
object's CLSID won't be all zeroes, but it looks very similar). When using a
"Remote" context, the CLSID is used instead of the ProgID
(Object.Application)
and you must also specify a valid server that has the object loaded. The
server
can be an IP address of a UNC path. Keep in mind that the ColdFusion
services
must be logged in as Administrator, not LocalSystem (the default) for most
objects to work -- you change this in your services control panel.


On Monday, July 16, 2001 7:47 AM, Christopher Olive, CIO
[SMTP:[EMAIL PROTECTED]] wrote:
> reviving an old topic...
>
> i've been looking into doing this for a recent client.  i read simon
> horwith's (very clear) article on CFCOMET.   works beautifully...on a
> machine with both CF ands SQL server on it.  of course, this is the test
> box.  when i move it to our production servers (two bxes, one CF 4.52, the
> other SQL 7), i get a
>
> COM error 0x800401F3: Invalid class string
>
> on the object creation call of CFOBJECT.  is this method presented bty
simon
> predicated on the fact that CF and SQL are on the same box?
~~
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: DTS from Store Procedure MSQL 7.0

[Christopher Olive, CIO]

actually, i've tried that already.  however, the xp_cmdshell runs as
SQLServer Agent (or some account) and needs sa access.  i can't do that on a
production box with other folks on there, it's a HUGE security hole.

i was trying the CFcomet method written by mr horwith.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: David Sterling [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 11:04 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0


Here is the syntax you need to run the DTS packet, assumed it is saved on
the SQL server.

CREATE PROCEDURE [MyDTS]

AS

Exec MASTER..xp_CmdShell 'dtsrun /S (server_name) /U (username) /P
(password) /N (name_of_DTS)', no_return


-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 9:47 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0


reviving an old topic...

i've been looking into doing this for a recent client.  i read simon
horwith's (very clear) article on CFCOMET.   works beautifully...on a
machine with both CF ands SQL server on it.  of course, this is the test
box.  when i move it to our production servers (two bxes, one CF 4.52, the
other SQL 7), i get a

COM error 0x800401F3: Invalid class string

on the object creation call of CFOBJECT.  is this method presented bty simon
predicated on the fact that CF and SQL are on the same box?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Bruce [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 8:39 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0


Check out www.cfcoment.com there is a great article about this exact thing.
Mike

-Original Message-
From: Cruz, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 7:56 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Check out xp_cmdshell and the dtsrun command-line tool.

That might get you where you want to be.

:)

Joe
==
Joseph Cruz
Programmer/Analyst
Wharton Computing
3620 Locust Walk, Suite 400
Philadelphia, PA  19104-6302
(215) 898-1220 (w)
(215) 308-0657 (p)
(215) 768-2071 (m)
[EMAIL PROTECTED]


> -Original Message-
> From: Jim Gurfein [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:22 PM
> To: CF-Talk
> Subject: DTS from Store Procedure MSQL 7.0
>
>
> Is is possible to execute a DTS package from a stored procedure?
>
>
~~
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: DTS from Store Procedure MSQL 7.0

[Christopher Olive, CIO]

reviving an old topic...

i've been looking into doing this for a recent client.  i read simon
horwith's (very clear) article on CFCOMET.   works beautifully...on a
machine with both CF ands SQL server on it.  of course, this is the test
box.  when i move it to our production servers (two bxes, one CF 4.52, the
other SQL 7), i get a

COM error 0x800401F3: Invalid class string

on the object creation call of CFOBJECT.  is this method presented bty simon
predicated on the fact that CF and SQL are on the same box?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Bruce [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 8:39 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0


Check out www.cfcoment.com there is a great article about this exact thing.
Mike

-Original Message-
From: Cruz, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 7:56 AM
To: CF-Talk
Subject: RE: DTS from Store Procedure MSQL 7.0



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Check out xp_cmdshell and the dtsrun command-line tool.

That might get you where you want to be.

:)

Joe
==
Joseph Cruz
Programmer/Analyst
Wharton Computing
3620 Locust Walk, Suite 400
Philadelphia, PA  19104-6302
(215) 898-1220 (w)
(215) 308-0657 (p)
(215) 768-2071 (m)
[EMAIL PROTECTED]


> -Original Message-
> From: Jim Gurfein [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:22 PM
> To: CF-Talk
> Subject: DTS from Store Procedure MSQL 7.0
>
>
> Is is possible to execute a DTS package from a stored procedure?
>
>
~~
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: Print without bringing print dialogue?

[Christopher Olive, CIO]

actually, you can't.  it's a JS security feature.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 12:46 PM
To: CF-Talk
Subject: Print without bringing print dialogue?


Hi, All:

I posted this before the list went down a few weeks ago. I don't know if
it went though so I re-post it.

I need to know how to print a cfm page without bringing up the print
dialogue from the browser.  If I use window. print() method, the print
dialogue will popup. But what I need is to send the displayed
information to the printer directly without bringing this print dialogue
box.  Is this possible? Any hint or suggestion will be appreciated.

Nathan Chen
~~
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: maxrows and blockfactor

[Christopher Olive, CIO]

BLOCKFACTOR is how many rows are returned along the pipe at one time from
the query.  for example, if you have BLOCKFACTOR set to 50, and the query
would return 400 rows, the DB sends the rows along the network pipe in
blocks of 50.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 07, 2001 5:28 PM
To: CF-Talk
Subject: maxrows and blockfactor



What is the difference between maxrows and blockfactor?

Both are available with  but only blockfactor is available with
.

Can you use blockfactor with a  the same way that you would
use maxrows in ?


Sebastian Palmigiani

Cash Flow Club Charity
http://www.cashflowclubonline.com/?SEB007883
voice: 773.929.9256
~~
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: Get Last Item in DB

[Christopher Olive, CIO]

not technically correct.  in an RDBMS, there is no "last row".  the data
"exists" in a set, not a table.  therefore, the "last row" is only relevant
if you mean something like "the last row inserted", AND that you have a
timestamp on it.  therefore, this SQL would look like


SELECT TOP 1 column AS thenewcolum FROM table ORDER BY  DESC

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 07, 2001 6:13 PM
To: CF-Talk
Subject: Re: Get Last Item in DB


SELECT TOP 1 column AS thenewcolum FROM table

Hope this helps


--
Will
new media discussion for Berkshire -=- http://bnm.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED]  icq: 31099745

- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Saturday, July 07, 2001 10:21 PM
Subject: Get Last Item in DB


> Hi,
>
> I think this might be a pretty simple SQL question... but here goes:
>
> If I have a bunch of rows in an database, how do I write the CFQUERY to
> return the very last row (and only the last row)?
>
> Thanks in advance,
>
> --
> Mike
>
>
~~
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: Correct use of "distinct" in queries

[Christopher Olive, CIO]

it's because distinct is applied to the combination of columns in your
select clause.

if you look, you're selecting distinct email, comdate.  that will give you
every combination of distinct emails and comdates.

i would guess that [EMAIL PROTECTED] has 4 different comdate in your
current resultset.  simple answer would be to remove the comdate from your
select clause.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 10:43 AM
To: CF-Talk
Subject: Correct use of "distinct" in queries


Hi,

I'm having a nightmare today - it's like banging my head against a CF wall..

I'm trying to do the most basic of queries.  Select distinct email addresses
from a table, and email them using cfmail.  But for some reason it's not
pulling unique addresses - is this because I have a WHERE statement?

 
 SELECT distinct comEmail, comDate FROM comments
 WHERE comEmail <> '#form.email#'
 AND comAdID = #form.adID#
 

[EMAIL PROTECTED] has 4 entries with form.adID in the table comments - but
he should only receive one email.

Any suggestions appreciated

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: Email this page to a friend....

[Christopher Olive, CIO]

problem with that is that if they haven't configured their email client
correctly in their browser (at least have of the clusers i've talked to have
not), it won't work well.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 10:44 AM
To: CF-Talk
Subject: Re: Email this page to a friend


if you don't want to add special credits and/or details to this "tell a
friend" message
I would recommened using the mailto: method.
it's easy, reliable and will pop up the user's prefarble e-mail client
(where he can select
his contacts much easier!!)

in cf, you can create something like this: (I forgot the actual CGI
variables, check them out)

and then, provide a link like this:

mailto:#mailto#";>share with a friend

get a better example here:
http://www.imvamp.com/share/index.cfm

Thanks,

Michael


- Original Message -
From: "Dasher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 3:35 PM
Subject: Email this page to a friend


> What's the best way to set up an
> "Email This Page To A Friend"
> using Cold Fusion?
>
> I need to get input like "name_of_friend" and "your_name"
> and plug it in to the emailed page...
>
> Thanks,
> Dasher
>
>
>
>
~~
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: UI question

[Christopher Olive, CIO]

you could do a check server side on the action of the form.


whatever error processing you want...


chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jason Lotz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 2:29 PM
To: CF-Talk
Subject: UI question


I would like some input on how people handle the following situation:

A client wants a form with a "Job Title" select box with 5 options -

Developer
Programmer
Engineer
Electrician
Other

If the user selects "Other" then they have to enter the information in a
text box.  Otherwise, the selection in the Select box is sufficient.

Now, my problem isn't programming related.  Rather, I am interested in a
good way to handle the user interface for this mess.  For example, in VB
it's easy enough to make the text box only appear when "Other" is selected.
However, HTML is not that flexible.  It just seems that there might be a
good way to handle this that I'm missing.

Jason
~~
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: Referencing an array item

[Christopher Olive, CIO]

yup.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 4:04 AM
To: CF-Talk
Subject: RE: Referencing an array item


So, to access a element [2][1] in the 3rd array I would have:

Application.SM[3][2][1]

?



> -Original Message-
> From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 29, 2001 5:49 PM
> To: CF-Talk
> Subject: RE: Referencing an array item
>
>
> well, you collapse the three arrays into an "uber" array, called SM.  so
> your original statement might be..
>
> 
> 
> 
> 
>
> then use your number as an index into your outer array.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 29, 2001 2:21 AM
> To: CF-Talk
> Subject: RE: Referencing an array item
>
>
> But I have 3 arrays, so it will really need to look like:
>
> Application.SM1[n][element]
> Application.SM2[n][element]
> Application.SM3[n][element]
>
> I can't see how else to work around this.
>
>
>
> > -Original Message-
> > From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 28, 2001 8:31 PM
> > To: CF-Talk
> > Subject: RE: Referencing an array item
> >
> >
> > ray has an excellent point.  however, why not exploit the nature
> > of arrays?
> > if you make Application.Sm an array with three elements, each one
> > the arrays
> > sm1..3, then you can reference an element in SM(n) by
> > Application.SM[n][element].  you don't have to futz with string
> evaluation
> > at all.
> >
> > chris olive, cio
> > cresco technologies
> > [EMAIL PROTECTED]
> > http://www.crescotech.com
> >
> >
> >
> > -Original Message-
> > From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 28, 2001 8:41 AM
> > To: CF-Talk
> > Subject: Referencing an array item
> >
> >
> > I have 3 arrays, which are assigned to the application scope:
> >
> > 
> > 
> > 
> >
> > My custom tag receives a number (1,2 or 3), and with that I
> reference the
> > correct array. I need to dynamically use this number to reference the
> > correct array, e.g.
> >
> > #ArrayLen(application.SM & attributes.Num)#
> >
> > (The above code does not work.) Any help would be much
> > appreciated!! Thanks
> > in advance.
> >
> > Steve
> >
> >
> > Development Manager
> > Vardus Internet Solutions (SA)
> >
> > Tel: (+27) 21 670 9880
> > Fax: (+27) 21 674 4549
> >
> > Email: [EMAIL PROTECTED]
> > Website: www.vardus.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: Referencing an array item

[Christopher Olive, CIO]

well, you collapse the three arrays into an "uber" array, called SM.  so
your original statement might be..






then use your number as an index into your outer array.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 2:21 AM
To: CF-Talk
Subject: RE: Referencing an array item


But I have 3 arrays, so it will really need to look like:

Application.SM1[n][element]
Application.SM2[n][element]
Application.SM3[n][element]

I can't see how else to work around this.



> -Original Message-
> From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 28, 2001 8:31 PM
> To: CF-Talk
> Subject: RE: Referencing an array item
>
>
> ray has an excellent point.  however, why not exploit the nature
> of arrays?
> if you make Application.Sm an array with three elements, each one
> the arrays
> sm1..3, then you can reference an element in SM(n) by
> Application.SM[n][element].  you don't have to futz with string evaluation
> at all.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 28, 2001 8:41 AM
> To: CF-Talk
> Subject: Referencing an array item
>
>
> I have 3 arrays, which are assigned to the application scope:
>
> 
> 
> 
>
> My custom tag receives a number (1,2 or 3), and with that I reference the
> correct array. I need to dynamically use this number to reference the
> correct array, e.g.
>
> #ArrayLen(application.SM & attributes.Num)#
>
> (The above code does not work.) Any help would be much
> appreciated!! Thanks
> in advance.
>
> Steve
>
>
> Development Manager
> Vardus Internet Solutions (SA)
>
> Tel: (+27) 21 670 9880
> Fax: (+27) 21 674 4549
>
> Email: [EMAIL PROTECTED]
> Website: www.vardus.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: Referencing an array item

[Christopher Olive, CIO]

ray has an excellent point.  however, why not exploit the nature of arrays?
if you make Application.Sm an array with three elements, each one the arrays
sm1..3, then you can reference an element in SM(n) by
Application.SM[n][element].  you don't have to futz with string evaluation
at all.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 8:41 AM
To: CF-Talk
Subject: Referencing an array item


I have 3 arrays, which are assigned to the application scope:





My custom tag receives a number (1,2 or 3), and with that I reference the
correct array. I need to dynamically use this number to reference the
correct array, e.g.

#ArrayLen(application.SM & attributes.Num)#

(The above code does not work.) Any help would be much appreciated!! Thanks
in advance.

Steve


Development Manager
Vardus Internet Solutions (SA)

Tel: (+27) 21 670 9880
Fax: (+27) 21 674 4549

Email: [EMAIL PROTECTED]
Website: www.vardus.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: IIS4 Log file

[Christopher Olive, CIO]

did you select these items in the Logging configuration on both machines?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 3:12 PM
To: CF-Talk
Subject: OT: IIS4 Log file


I have two servers.  One server logs browser, and computer information like
this:
Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
This computer has CF 4.5, and Webtrends loaded on it.

The other server (IIS4 also, but without CF4.5, and Webtrends) does not log
this information.  Anyone know why?

TIA
~~
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: E-commerce Dilemma

[Christopher Olive, CIO]

CFWebstore is EXCELLENT.  Mary Jo has created an incredible product that
works right out of the box.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Christine Kelley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 3:03 PM
To: CF-Talk
Subject: E-commerce Dilemma



Hi!
I need to implement an e-commerce package for one of my
sites, but I haven't worked with e-commerce before.  What
they want is fairly simple, just the ability to buy items
on-line.  This in mind, I think AbleCommerce would be
over-kill.  The two I have researched are CFWebstore and
Cartease.  I'm torn between the two...does anyone have
reasons to go with one or the other?  What I need is a
solution that I can add on to an existing site or build a
complete store from scratch. Ease of implementation would be
nice too :)
 Thanks,  Christine
~~
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: Strange problem (or still asleep)

[Christopher Olive, CIO]

that OR should be an AND.  something can't be BOTH 5 and 9 at the same time.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: David Baskin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 2:20 PM
To: CF-Talk
Subject: Strange problem (or still asleep)


Hello, i'm running the code below and i'm not getting the expected results.
i'm passing in a variable with the length of 5 so i would expect that the
errorString would not be appended, but in fact it is. The same thing happens
when i pass in a variable with the length of 9. I can't seem to figure out
why this is happening. Can anyone help? Sorry if this is way basic.

david

code:

script
.
}else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){
errorString = ListAppend(errorString, "Please enter a valid
zipcode (too long/short)", "|");
errorFlags = ListAppend(errorFlags, "zp", "|");
.
/script
~~
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 Help!! Problems???

[Christopher Olive, CIO]

are shipfrom and shipto string?  if so, you'll get that error on the second
query, as you're comparing strings to numbers.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 8:16 PM
To: CF-Talk
Subject: RE: Query Help!! Problems???


OK when I use:

select shiprate from shipratesdollars
where '#total#' >=shipfrom
and '#total#' <= shipto


I get multiple records returned.

 When I get rid of the tick marks:

select shiprate from shipratesdollars
where #total# >=shipfrom
and #total# <= shipto


I get Data type mismatch in criteria expression.

WHAT AM I DOING WRONG??

HELP,
Rich



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 7:07 PM
To: CF-Talk
Subject: RE: Query Help!!


These queries give me:
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias
'shipRate' in query definition's SELECT list.

Rich



-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 5:35 PM
To: CF-Talk
Subject: RE: Query Help!!


it's impossible to know what's wrong without knowing the values of the
session variables at any given time

You'll notice that you don't need to do a comparison on both numbers:
= #val(session.total)#

Either of these will return the one value you need

Also if you're sure the columns in the DB will always be sorted in ascending
order then just do this:
= #val(session.total)#

This time the first record in the DB where shipTo is greater than your
session variable is the one you want and will be the only one returned.

You may have noticed by now that you only need to have shipFrom OR shipTo in
the DB table, you do not need both :)



Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 1:01 PM
To: CF-Talk
Subject: Query Help!!


Does anyone see any problems with the following query:


Select shiprate from shipratesdollars
WHERE '#session.total#' >= shipfrom
and '#session.total#' <= shipto



I can not figure out why I am getting incorrect results.  Sometimes it will
pull more than one record and sometimes it will pull the max record only.
Here is a copy of the table I am using named shipratedollars.

ID  shiprateshipfrom shipto
1   4.00 0.00 50.00
2   6.0050.01100.00
3   8.00   100.01200.00
4   12.00  200.01300.00
5   18.00  300.01500.00
6   25.00  500.01750.00
7   40.00  750.01   1000.00
8   50.00 1000.01   1500.00
9   70.00 1500.01   2000.00
10  100.00  2000.009.00


Thansk,
Rich
~~
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: Who's a good merchant these days?

[Christopher Olive, CIO]

my bad.  "their techS ARE way behind."  they don't know how to support CF.
most of the guys i talked to had *heard* of CF, not used it.  in fact, they
were techinically "not supposed to support customer software" according to
their techs.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 5:25 PM
To: CF-Talk
Subject: RE: Who's a good merchant these days?


well...I have no complaints.  My clients don't either.  :)

IMHO, their customer service is SOLID for the amount you pay per transcation
(which used to be around .20 per, BUT NOW TRANS are FREE up 1000
transacation per month) and Monthly SvcChg, which is much less than most
competitors.  Their chargeback rates are competitive as well.

you said "their tech is WAY behind", however, they are using ColdFusion.
H.

just my .02 of a dollar  :p

G

-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 3:17 PM
To: CF-Talk
Subject: RE: Who's a good merchant these days?


what?  boa is FUBAR!  i tried to use them, and their tech is WAY behind.
they're only now starting to let you use CFHTTP to do the processing (or
they will be...within the next 2 or 3 months...)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 3:06 PM
To: CF-Talk
Subject: RE: Who's a good merchant these days?


Erika


here are a few.

SkipJack - http://www.skipjack.com
GoRealtime - http://www.gorealtime.com
Itransact - http://www.itransact.com

but I highly recommend Bank of America services, if you have a b of a
account


http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_ov.
cfm


Greg

-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:28 AM
To: CF-Talk
Subject: OT: Who's a good merchant these days?


Hi all,

I have to recomend a couple of good credit card processing companies to a
new client.

Other than iBill, CyberCash and Authorize.net, are there any others worth
taking a look at, easy to integrate and have no problems?

Look for fellow programmer references.

Thank you.



ReplaceNoCase("Erica", "c", "k", "ALL")*

*A thanks to Dylan, for being the ever observant CF programmer!!

"Once in a while it really hits people that they don't have to experience
the world in the way they have been told to." - Alan Keightley
~~
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: SQL query help

[Christopher Olive, CIO]

SELECT
distinct(color) as color
WHERE
name = 'bar'

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 4:16 PM
To: CF-Talk
Subject: SQL query help


I have a database similar to this:

SKU NAMECOLOR   STYLE
1   bar blue12"
2   bar blue6"
3   bar blue5"
4   bar red 12"
5   bar red 6"
6   bar red 5"


I want to find all the colors that 'bar' comes in.

If i do a query on this to find all the colors for the NAME 'bar'.  I get:
blue
blue
blue
red
red
red

How do i get results like this?
blue
red

Thanks in advanced
Chad
~~
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: Who's a good merchant these days?

[Christopher Olive, CIO]

what?  boa is FUBAR!  i tried to use them, and their tech is WAY behind.
they're only now starting to let you use CFHTTP to do the processing (or
they will be...within the next 2 or 3 months...)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 3:06 PM
To: CF-Talk
Subject: RE: Who's a good merchant these days?


Erika


here are a few.

SkipJack - http://www.skipjack.com
GoRealtime - http://www.gorealtime.com
Itransact - http://www.itransact.com

but I highly recommend Bank of America services, if you have a b of a
account


http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_ov.
cfm


Greg

-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:28 AM
To: CF-Talk
Subject: OT: Who's a good merchant these days?


Hi all,

I have to recomend a couple of good credit card processing companies to a
new client.

Other than iBill, CyberCash and Authorize.net, are there any others worth
taking a look at, easy to integrate and have no problems?

Look for fellow programmer references.

Thank you.



ReplaceNoCase("Erica", "c", "k", "ALL")*

*A thanks to Dylan, for being the ever observant CF programmer!!

"Once in a while it really hits people that they don't have to experience
the world in the way they have been told to." - Alan Keightley
~~
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: Finding the last item in a loop

[Christopher Olive, CIO]

maybe


#EventSponserName#,



?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 11:13 AM
To: CF-Talk
Subject: Finding the last item in a loop


IS it possible to find the last item in a loop?

Right now I have this:


#EventSponserName#,


Is it possible to check if the #EventSponsorName#  is the last item in the
record set, and then not display the comma?  I.E.


#EventSponserName#,


Thanks in advance

Chris Martin
~~
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: How to Force https vs http

[Christopher Olive, CIO]

i used to override the custom error from IIS (403.5, i think).  write your
own redirect script.  so when they go to http:// something, they get
automatically redirected to https:// something.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 9:57 AM
To: CF-Talk
Subject: How to Force https vs http


Howdy all,

Quick questionis it possible to have a URL redirect to a secure URL? For
example, someone enters http://www.xxxblahxxx.com/secure/securepage.cfm
instead of  https://www.xxxblahxxx.com/secure/securepage.cfm. How do you
force a redirect to the secure URL? Is that a server function, or can it be
done programmatically?

TIA,

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Sales & Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
Instant Messaging:
AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Simple SQL SELECT

[Christopher Olive, CIO]

whenever you use an aggregate function (like count()), you have to use the
GROUP BY clause.  put the rest of your columns there.  ie:

SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos
WHERE phGROUP='#grid#' AND phCOL IS NOT NULL
GROUP BY phID, phCOL

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 6:11 AM
To: CF-Talk
Subject: Simple SQL SELECT


I'm trying to simply select a few colums from a table (phID,phCOL)
+ the count of that certain select each time into a variable (coPHOTOS)

SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos
WHERE phGROUP='#grid#' AND phCOL IS NOT NULL
GROUP BY phCOL

I keep on getting an error: Column 'photos.phID' is invalid in the select
list because it is not contained in either an aggregate function or the
GROUP
BY clause.

What is wrong? Thanks!
~~
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: Benefits of vs. with SWITCH

[Christopher Olive, CIO]

that's actually something they warn about in C courses.  you must have a
break in your case statements, or it will cascade down the cases after the
first match.  it's defined as "bad programming" in most cases, but all bad
things (infinite loops, etc) have applications in carefully controlled
circumstances.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 1:33 PM
To: CF-Talk
Subject: Re: Benefits of  vs.  with SWITCH


*** Team Allaire ***
> Miachael,
>
> Go ahead and "steal" the code.  But in what way is this a hack?
The part where you did a case with no content in it that 'slid' down to the
next case and used the same content. This isn't in any docs and probably
hasn't been thought of by many people.
switch ( foo ) {
case 1 :
case 2 : {
// code
break;
}

> I do find your numbers interesting.  I am a little disappointed at the
> apparent performance hit one takes when using a cfscript switch/case
> statement.
I know that MM people are on list and will probably look into it. I'll also
post it to the bug tracking for CF 5.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: using NT accounts for username/password login authentication

[Christopher Olive, CIO]

um...you did post to the list. :)

ldap is a different animal.  i've never really used it for authentication,
besides Win2K's ACLs being LDAP-compliant.

you're probably going to want to look into Advanced Security.  it can use an
LDAP database for suthentication.  of course, it's a BEAST to setup.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jerre Hale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 3:52 PM
To: CF-Talk
Subject: Re: using NT accounts for username/password login
authentication


Chris,

Sorry to respond to you this way.  I subscribed to this list only today.  I
am looking for help on authenticating
users against an ldap directory but have not quite gotten there yet and I
cannot see how to post to the list.  Any
pointers on how to post to the list would be appreciated.  Then I will be
more descriptive in my question.

Thanks,

Jerre

"Christopher Olive, CIO" wrote:

> if you're running IIS, just switch off anonymous access.  users will be
> prompted for their NT password, and the ACL on that directory/file will
take
> over.  if they're not authorized, they get a 403.1 error.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
> -Original Message-
> From: Philip Humeniuk [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 12:09 PM
> To: CF-Talk
> Subject: Re: using NT accounts for username/password login
> authentication
>
> How would you go about accessing the NT accounts and use those
> username/password for login
> authentication rather than accessing an MS Access database?
>
> Has anyone done this before?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: using NT accounts for username/password login authentication

[Christopher Olive, CIO]

if you're running IIS, just switch off anonymous access.  users will be
prompted for their NT password, and the ACL on that directory/file will take
over.  if they're not authorized, they get a 403.1 error.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Philip Humeniuk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 12:09 PM
To: CF-Talk
Subject: Re: using NT accounts for username/password login
authentication



How would you go about accessing the NT accounts and use those
username/password for login
authentication rather than accessing an MS Access database?

Has anyone done this before?
~~
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: ' in SQL 2000

[Christopher Olive, CIO]

perhaps you could post the code you're using.  we could take a look.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 9:42 AM
To: CF-Talk
Subject: ' in SQL 2000


I'm having a frustrating problem
I have several queries in which I'm composing the SQL statement and then
inserting it into the query through a variable (Necessary because I'm
looping through a list to get the fieldnames and values).

e.g.: 

then in the query:
insert into table1(#list1#)
values (#list2#)

When I output the generated SQL, it looks perfectbut SQL seems to be
having a problem with the  ' (single quotes) surrounding strings I've
tried preservesinglequotes(), using chr(39), etc...and I still get
syntax errors on insert or update.  When I take the output data and manually
insert it into the query, it works fine - eliminating the possibility of
data type errors.
I've tried this with 4 different queries, with the same results.

I've now run out of things to try..Ideas?

TIA!
D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long
~~
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: 100s of FTP Accounts

[Christopher Olive, CIO]

have i left you speechless? :)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Tobe Goldfinger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:20 PM
To: CF-Talk
Subject: RE: 100s of FTP Accounts


At 11:51 AM 4/24/2001 , you wrote:
>you could always write a WSH script to use ADSI to do that.
>
>chris olive, cio
>cresco technologies
>[EMAIL PROTECTED]
>http://www.crescotech.com
>
>
>
>-Original Message-
>From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 24, 2001 11:22 AM
>To: CF-Talk
>Subject: 100s of FTP Accounts
>
>
>We're about to offer all of our users and client complete ftp access to
10mb
>of storage.
>Every user will have his own directory on our NT machine and ftp account
>that will
>log him automaticlly to HIS special directory.
>
>What is the best way to seperate directories and accounts without the need
>to create
>1000s of FTP accounts under NT?
>
>I've heard somewhere that by logging onto FTP with a username that is the
>same
>as on of the directories, the user automaticlly logs inside it. but I don't
>want to assign
>NT account to every user... :( - is it somehow possible with Anonymous FTP?
>
>
>Thanks,
>
>Michael Lugassy
>Interactive Music Ltd.
>I don't live in fantasy; I just work there...
>http://www.imvamp.com
>[EMAIL PROTECTED]
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Character code for a TAB

[Christopher Olive, CIO]

that'd require a synchronous type of situation.  the beauty is that people
who may be able to answer the question don't have to be there when you are.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 12:48 PM
To: CF-Talk
Subject: Re: Character code for a TAB


What about a CHAT solution?
CHAT ROOM would be great!!!

- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 5:28 PM
Subject: RE: Character code for a TAB


> i still disagree with this. here's why:
>
> 1) sometimes answers are wrong
> 2) some people post really innovative solutions even after the problem
might
> have been "solved"
>
> some people might be frustrated when the SAME answer is posted over and
> over. well...delete the thread. i don't think the answer is asking people
> not to respond just because there's a response that looks like an answer.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 24, 2001 7:31 AM
> To: CF-Talk
> Subject: Re: Character code for a TAB
>
>
>
> Instead of quickly hitting reply and sending out the answer, one can
> quickly scan the inbox or the digest to see if its been answered and then
> not reply.
> Mary
>
>
> There must be a way to let us know the question has been answered!
> Let's think about it!
>
> - Original Message -
> From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 24, 2001 3:51 PM
> Subject: RE: Character code for a TAB
>
>
> > I think the problem is more due to the fact that the responses are more
> > "hey, I know the answer to this!!!" repetitions than meant to clog the
> list.
> > It's one of the downsides of using an e-mail list versus some other
> message
> > base format.  All of the replies probably got sent out at the same time
> and
> > the "delay" the list actually getting them is more due to email lag than
> > anything else.
> >
> > It's great to get a response and frustrating not to, and I think all of
> us
> > have experienced both sides of that coin.  So to make up for it, when we
> > know how to help someone we reflexively hit reply.  The cascade effect
is
> > what we all see.
> >
> > Hatton Humphrey
> >
> > "Barbara remains in the hospital and needs blood donors for more
> > transfusions. She is also having trouble sleeping and requests tapes of
> > Pastor Jack's sermons." - From "Real Church Bulletin Bloopers"
> >
> > > -Original Message-
> > > From: Erika L Walker [mailto:[EMAIL PROTECTED]]
> > >
> > > How about everyone bookmarks this page (http://www.asciitable.com/),
> > > now...then no-one should ever have to ask again. Except of course
> the
> > > newcomers. And those we'll beat into submission with a big ole CF book
> or
> > > something...?
> > >
> > > :)
> > >
> > > Erika
> > >
> > > -Original Message-
> > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > >
> > > I JUST LOVE IT WHEN 1203483409875 PEOPLE answer the same answer
> > > to a pretty easy question.
> > >
> > > I think we gotta sort this out somehow... :)
> > >
> > > Thanks,
> > >
> > > Michael Lugassy
> > > Interactive Music Ltd.
> >
> >
> >
>
~~
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: 100s of FTP Accounts

[Christopher Olive, CIO]

you could always write a WSH script to use ADSI to do that.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 11:22 AM
To: CF-Talk
Subject: 100s of FTP Accounts


We're about to offer all of our users and client complete ftp access to 10mb
of storage.
Every user will have his own directory on our NT machine and ftp account
that will
log him automaticlly to HIS special directory.

What is the best way to seperate directories and accounts without the need
to create
1000s of FTP accounts under NT?

I've heard somewhere that by logging onto FTP with a username that is the
same
as on of the directories, the user automaticlly logs inside it. but I don't
want to assign
NT account to every user... :( - is it somehow possible with Anonymous FTP?


Thanks,

Michael Lugassy
Interactive Music Ltd.
I don't live in fantasy; I just work there...
http://www.imvamp.com
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Character code for a TAB

[Christopher Olive, CIO]

problem with that is exactly what we're discussing.  the answer may not have
come into my inbox before i reply to a message.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:31 AM
To: CF-Talk
Subject: Re: Character code for a TAB



Instead of quickly hitting reply and sending out the answer, one can
quickly scan the inbox or the digest to see if its been answered and then
not reply.
Mary


There must be a way to let us know the question has been answered!
Let's think about it!

- Original Message -
From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 3:51 PM
Subject: RE: Character code for a TAB


> I think the problem is more due to the fact that the responses are more
> "hey, I know the answer to this!!!" repetitions than meant to clog the
list.
> It's one of the downsides of using an e-mail list versus some other
message
> base format.  All of the replies probably got sent out at the same time
and
> the "delay" the list actually getting them is more due to email lag than
> anything else.
>
> It's great to get a response and frustrating not to, and I think all of
us
> have experienced both sides of that coin.  So to make up for it, when we
> know how to help someone we reflexively hit reply.  The cascade effect is
> what we all see.
>
> Hatton Humphrey
>
> "Barbara remains in the hospital and needs blood donors for more
> transfusions. She is also having trouble sleeping and requests tapes of
> Pastor Jack's sermons." - From "Real Church Bulletin Bloopers"
>
> > -Original Message-
> > From: Erika L Walker [mailto:[EMAIL PROTECTED]]
> >
> > How about everyone bookmarks this page (http://www.asciitable.com/),
> > now...then no-one should ever have to ask again. Except of course
the
> > newcomers. And those we'll beat into submission with a big ole CF book
or
> > something...?
> >
> > :)
> >
> > Erika
> >
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> >
> > I JUST LOVE IT WHEN 1203483409875 PEOPLE answer the same answer
> > to a pretty easy question.
> >
> > I think we gotta sort this out somehow... :)
> >
> > Thanks,
> >
> > Michael Lugassy
> > Interactive Music Ltd.
>
>
>
~~
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: textarea

[Christopher Olive, CIO]

well, you can't techincally put "bullets" in there, but if you want to save
the carriage returns that people use in your textarea, use the WRAP="HARD"
attribute in the textarea.

when outputting, use ParagraphFormat() to do something about the CRs in the
output.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 5:52 AM
To: CF-Talk
Subject: textarea


Hi all,
I've got a form which has a text area for people to
fill in.  Then the next page displays the information
they entered.  What i want to do is save the
information the people entered but in the same format.
 So for example, if the information entered is in
bullet format, each on a separate line.  I want it to
display that way, each bullet on a separate line.  Is
that possible? and how?

=
Heidi Belal
ICQ# 32127109
http://m3.easyspace.com/hmbelal

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...
~~
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: CFTRY / CFCATCH questions

[Christopher Olive, CIO]

that's incorrect, actually.  it will catch them in the order defined.  so if
there is an "ALL" first, there will never be any other.  basically, it
starts at the first CATCH, compares exception types.  if it is a match, that
handler occurs, if not, it examines the next one in order, ad nauseum, until
the last catch (which should probably be an "ALL" JIC)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:00 PM
To: CF-Talk
Subject: Re: CFTRY / CFCATCH questions


There are no requirements on the order of cfcatch statements that I'm aware
of.

- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:45 PM
Subject: CFTRY / CFCATCH questions


>
>I know that at least one CFCATCH must be put inside a CFTRY block.  How
> picky is CF on the order of the tags, though?  for example:
>
> 
>Some code
>
>
>
>
>
>
>
>
>
> 
>
>
>  First off, can you use an 'all' catch with other specialized catches
> defined?  Would a database exception catch at 'all' or would it catch at
> 'database'?  If I changed the code around to look like this:
>
>
> 
>Some code
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
> Then, where would a database exception catch?  At 'all' or at 'database'?
>
>
> If I put the code after the CFCATCHs, would an error catch?  Like this:
>
> 
>
>
>
>
>
>
>
>
>
>
>Some code
> 
>
>
>Thoughts, comments?  Much thanks!
>
>
>
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> Due out June 2001
> --
> DotComIt, LLC
> database driven web data using ColdFusion, Lotus Notes/Domino
> --
> Half of the Alternative Folk Duo called Far Cry Fly
> http://www.farcryfly.com | http://www.mp3.com/FarCryFly
>
>
>
~~
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: statement help...

[Christopher Olive, CIO]

are you only outputting one?  as in, do you have QUERY specified in the
CFOUTPUT tag?  or does your debug show only one returned?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:17 PM
To: CF-Talk
Subject: Re: statement help...


i tried this also, and it still didnt work
since then i have switched everything to be id specific now however, it
still only returns the first record w/ that id, now. any ideas this is
my query now


SELECT *
FROM RodeoManager
WHERE CircuitID = #url.CircuitID#


thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:48 AM
Subject: Re: statement help...


> Try the following as your where clause:
>
> WHERE trim(Circuit) = '#trim(url.CircuitName)#'
>
> *** REPLY SEPARATOR  ***
> On 4/23/2001 at 9:31 AM Jay Patton wrote:
>
> |Why would this only select one record from the db?(there are about 12 it
> |should return but it only returns one (which is the first one)
> |
> | | datasource="#datasource#"
> | dbtype="ODBC"
> | username="#username#"
> | password="#password#">
> |SELECT *
> |FROM RodeoManager
> |WHERE Circuit = '#url.CircuitName#'
> |
> |
> |
> |Thanks,
> |
> |Jay Patton
> |Web Design / Application Design
> |Web Pro USA
> |p. 406.549.3337 ext. 203
> |p. 1.888.5WEBPRO ext. 203
> |e. [EMAIL PROTECTED]
> |url. www.webpro-usa.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: JS-question-> transferring text from one template to another

[Christopher Olive, CIO]

take a look at irt.org and thier JS faq.  there are TONS of code snippets
there.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:31 PM
To: CF-Talk
Subject: OT: JS-question-> transferring text from one template to
another


Hi, I want to do the following:

I have an Input-template with five text-fields.
On on text field (memory-field, text area) I want to call a small browser
window via
JS (wiht a hyperlink). So far so good. I know how I can do that. In the
called template I have another
Input-field which gets filled by the user. What I want to do is transferring
the text in this text-area back to the calling page and reloading, but the
text
already filled in the four ohter input-boxes shouldn't be touched/changed.
How can I do this.
Does s.o. has his code available ?

Thank you.

Uwe
~~
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: Bank of America and e-stores and CFHTTP

[Christopher Olive, CIO]

that was on my list.  tried it now while waiting for my client to get their
SSL setup so i can test my first suspicion.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:04 PM
To: CF-Talk
Subject: Re: Bank of America and e-stores and CFHTTP


Have you tried specifying your user agent in the cfhttp post ?. I have seen
certain web servers not play well with cfhttp unless that is specified.

 
- Original Message -
From: "JoshMEagle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 10:30 AM
Subject: RE: Bank of America and e-stores and CFHTTP


> could you show us the code? Are you using ? Are you closing
> your ? Are you certain you've included the POST command? It's
hard
> to diagnose without a snippet.
>
> Thanks,
>
> Joshua Miller
> Web Development
> Eagle Technologies Group
> Technology Solutions for the Next Generation
> www.eagletgi.com
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 10:16 AM
> To: CF-Talk
> Subject: Bank of America and e-stores and CFHTTP
>
>
> has anyone had any particular problems or success using CFHTTP to talk to
> BoA's estores solution?  i haven't been able to get it to work, and their
> techs tell me that people have *definately* used CF in the past to do
this.
>
> i can follow thei rinstructions and use a standard HTML form post to their
> processing URL.  this works successfully.  however, when i try to make it
a
> CFHTTP call, i get a "Failed form POST" error from their servers.
>
> anyone lend a hand?
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.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: Bank of America and e-stores and CFHTTP

[Christopher Olive, CIO]

my apologies.  i neglected to mention that the CF guys at BoA verified that
the code is correct.

in response to the other questions:

1) i'm going to try to use the USERAGENT part of CFHTTP to "spoof" IE if
nothing else works.
2) yes, i'm posting to a secure URL.  no, i haven't had any problems with
that in the past with CFHTTP.  the authorize.net stuff i use works perfectly
3) they suggested that i have to be coming *from* a secure URL as well.  i'm
working on trying that possibility next.

as i said, the BOA folks said that my CFHTTPparams are correct.  the CFHTTP
call is here:

https://cart.bamart.com/payment.mart" METHOD="POST" PORT="443">

i have a couple of options.  if anyone happens to know the secret trick for
this one, i'd be most grateful.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: JoshMEagle [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 11:30 AM
To: CF-Talk
Subject: RE: Bank of America and e-stores and CFHTTP


could you show us the code? Are you using ? Are you closing
your ? Are you certain you've included the POST command? It's hard
to diagnose without a snippet.

Thanks,

Joshua Miller
Web Development
Eagle Technologies Group
Technology Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]

-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 10:16 AM
To: CF-Talk
Subject: Bank of America and e-stores and CFHTTP


has anyone had any particular problems or success using CFHTTP to talk to
BoA's estores solution?  i haven't been able to get it to work, and their
techs tell me that people have *definately* used CF in the past to do this.

i can follow thei rinstructions and use a standard HTML form post to their
processing URL.  this works successfully.  however, when i try to make it a
CFHTTP call, i get a "Failed form POST" error from their servers.

anyone lend a hand?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.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

Bank of America and e-stores and CFHTTP

[Christopher Olive, CIO]

has anyone had any particular problems or success using CFHTTP to talk to
BoA's estores solution?  i haven't been able to get it to work, and their
techs tell me that people have *definately* used CF in the past to do this.

i can follow thei rinstructions and use a standard HTML form post to their
processing URL.  this works successfully.  however, when i try to make it a
CFHTTP call, i get a "Failed form POST" error from their servers.

anyone lend a hand?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.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: http 500 Internal Server Error and CF installation

[Christopher Olive, CIO]

roger.  for some reason i assumed that he had just installed all that mess.
rebuilding the engine is something i ALWAYS do the first time around. :)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 9:13 AM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


true, but i always try that first. no need to rebuild the engine if your
only out of gas 


--
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com



-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 5:43 PM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


that depends.  i've always had to (per instructions provided by Dave Watts)
reinstall CF.  however, the "500 error" is pretty generic.  your way will
fix 90% of the problems.  however, if he just did an install, he may also be
seeing these problems.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 4:19 PM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


no need to reinstall, go into IIS, application settings, remove and recreate
the app...should fix it fine

--
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com



-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 3:00 PM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


you need to reinstall Win2K.  it comes bundled with MDAC 2.5, and when
installing CF over it, it breaks.  just "upgrade" to Win2K FROM win2K and
it'll be fine.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 1:14 PM
To: CF-Talk
Subject: http 500 Internal Server Error and CF installation



I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the
html pages to display but not the cfm pages, when for example, going to the
cf administrator page. I get an http 500 Internal Server Error. I have
followed all the instructions in the knowledge base article 7671 and the
problem persists.

There has to be a simple fix for this but I can't figure it out.

Thanks,
Sebastian

--


There is a problem with the page you are trying
to reach and it cannot be displayed.




Please try the following:

Open the 127.0.0.1 home page, and then look for links to the information you
want.
Click the  Refresh button, or try again later.

Click  Search to look for information on the Internet.
You can also see a list of related sites.


HTTP 500 - Internal server error
Internet Explorer
~~
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: vs

[Christopher Olive, CIO]

that's .

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Bonnie Betts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 8:45 PM
To: CF-Talk
Subject: Re:  vs 


I thought  tested to see if it existed.. no?

Bonnie E. Betts
[EMAIL PROTECTED]
www.interacttechs.com


- Original Message -
From: "Bert" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:19 AM
Subject:  vs 


> There seems to be a difference in the outcome of  and
, when myvar is a number but neither 0 nor 1.
>
> Is this a feature to be used, or a bug, or have i missed something?
>
> Bert
>
> ps save the code below as trueorfalse.cfm to see what i mean:
>
> 
>
> 
>
> #myvar#:
> 
> myvar IS true
> 
> myvar IS false
> 
> cfelse (i.e. NOT "myvar IS true" OR "myvar IS false")
> 
> 
>
> #myvar#:
> 
> myvar
> 
> NOT myvar
> 
> cfelse (i.e. NOT "cfif myvar" OR "cfif NOT myvar")
> 
>
> 
>   
>   
> 
>
> 
>
>
>
~~
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: Problem browsing web pages in the CFStudio editor window

[Christopher Olive, CIO]

go to Debug->Development Mappings (Alt-M if you're a shortcut guy)

enter the path that studio "sees" as your studio path.  this will be the
same as the "server path" if you're running IIS/PWS locally.  then put
"http://localhost/" as your "Browser Path".  this is what you would enter if
you were browsing your local machine with IE/NS normally.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 5:21 PM
To: CF-Talk
Subject: Problem browsing web pages in the CFStudio editor window


hi,

i'd like to be able to browse web pages in the cfstudio editor window.
however, when i click on the browse button above the window i get the
following error message:

"The CF file you are trying to browse cannot be resolved into a URL.  Add a
server development mapping to enable URL resolution for this file."

What does 'server development mapping' mean, and how and to where should I
add it?

sincerely,
---
Hubert Earl

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

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

RE: The Best Clustering Solution

[Christopher Olive, CIO]

i seem to remember reading that cluster cats DID come with replication.
check the docs again.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Paul's Mail [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 6:19 PM
To: CF-Talk
Subject: The Best Clustering Solution


we have 2 Win2000 servers running CF applications and wish to cluster them
so that they both are duplicates of each other. The clustering solution must
include replication.
Cluster Cats supplied with CF Enterprise does not include replication and I
cannot find this software in its full version including replication
anywhere.
Which is the best solution for clustering just two servers?
Is the solotion supplied by Microsoft any good?
Any help would be appreciated as the subject is new to me.
Kind regards

Paul
~~
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: http 500 Internal Server Error and CF installation

[Christopher Olive, CIO]

that depends.  i've always had to (per instructions provided by Dave Watts)
reinstall CF.  however, the "500 error" is pretty generic.  your way will
fix 90% of the problems.  however, if he just did an install, he may also be
seeing these problems.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 4:19 PM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


no need to reinstall, go into IIS, application settings, remove and recreate
the app...should fix it fine

--
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com



-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 3:00 PM
To: CF-Talk
Subject: RE: http 500 Internal Server Error and CF installation


you need to reinstall Win2K.  it comes bundled with MDAC 2.5, and when
installing CF over it, it breaks.  just "upgrade" to Win2K FROM win2K and
it'll be fine.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 1:14 PM
To: CF-Talk
Subject: http 500 Internal Server Error and CF installation



I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the
html pages to display but not the cfm pages, when for example, going to the
cf administrator page. I get an http 500 Internal Server Error. I have
followed all the instructions in the knowledge base article 7671 and the
problem persists.

There has to be a simple fix for this but I can't figure it out.

Thanks,
Sebastian

--


There is a problem with the page you are trying
to reach and it cannot be displayed.




Please try the following:

Open the 127.0.0.1 home page, and then look for links to the information you
want.
Click the  Refresh button, or try again later.

Click  Search to look for information on the Internet.
You can also see a list of related sites.


HTTP 500 - Internal server error
Internet Explorer
~~
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: http 500 Internal Server Error and CF installation

[Christopher Olive, CIO]

you need to reinstall Win2K.  it comes bundled with MDAC 2.5, and when
installing CF over it, it breaks.  just "upgrade" to Win2K FROM win2K and
it'll be fine.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 1:14 PM
To: CF-Talk
Subject: http 500 Internal Server Error and CF installation



I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the
html pages to display but not the cfm pages, when for example, going to the
cf administrator page. I get an http 500 Internal Server Error. I have
followed all the instructions in the knowledge base article 7671 and the
problem persists.

There has to be a simple fix for this but I can't figure it out.

Thanks,
Sebastian

--


There is a problem with the page you are trying
to reach and it cannot be displayed.




Please try the following:

Open the 127.0.0.1 home page, and then look for links to the information you
want.
Click the  Refresh button, or try again later.

Click  Search to look for information on the Internet.
You can also see a list of related sites.


HTTP 500 - Internal server error
Internet Explorer
~~
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 string disappear

[Christopher Olive, CIO]

the only way to do that is with a javascript generated window.  js won't let
you touch the "chrome" on a non-js generated window.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 11:21 PM
To: CF-Talk
Subject: RE: Query string disappear


Alternativly you could possibly disable the location and status bars of the
browser. A bit drastic however and more likely to annoy users than anything
else.

-Original Message-
From: Javier Woodhouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 April 2001 13:02
To: CF-Talk
Subject: RE: Query string disappear


To hide 'ugly' URL's i usually put the page in a frame so the url will
always read http://someplace.com/ as the user clicks through the one
frame



> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 12:32 PM
> To: CF-Talk
> Subject: Re: Query string disappear
>
>
> Yes, but these can be easily seen and manipulated by viewing
> the source.
>
> Encrypt() is a much better option for URL passed data.
>
> Todd
>
> - Original Message -
> From: "Garza, Jeff" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 17, 2001 10:18 PM
> Subject: RE: Query string disappear
>
>
> > Really you can't.  You'll have to look into using an
> onClick event to fire
> > off some javascript that submits a form with hidden fields.
>  That's what I
> > do when I don't want clutter my urls with bunches of variables.
>
>
>
>
~~
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: Dynamically Displayed Content Weekly?

[Christopher Olive, CIO]

whoops.  didn't state it correctly.  i was hung up on the "date" idea.  of
course, you are correct.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 9:43 PM
To: CF-Talk
Subject: RE: Dynamically Displayed Content Weekly?


Actually, that's not right.  The cachedwithin attribute of cfquery will do
what you are saying.

cachedafter caches a query AFTER the date/time you specify, like so:



.SQL...



Would continue to retrieve the query data from the database until the query
was run after the date/time specified in the cachedafter attribute.

So to specify a time in the future when the query should be flushed and
reloaded from the database, use:



.SQL...





- Andy


> -Original Message-----
> From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 8:25 PM
> To: CF-Talk
> Subject: RE: Dynamically Displayed Content Weekly?
>
>
> you don't even really need to do that.  if you have queries to
> pull the data
> from your database on the "main page" (the one with the weekly data), use
> the CACHEDAFTER property of CFQUERY.  this will cache the results until a
> certain date.  set the date for one week from today, and voila!
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: dk [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 14, 2001 3:49 AM
> To: CF-Talk
> Subject: Re: Dynamically Displayed Content Weekly?
>
>
> Just create a .cfm page to get/ retrieve the content (maybe from
> a database
> or from some other site).
>
> Use the cfschedule tag to create a weekly schedule to run the above ..cfm
> file once a week. This will update the content weekly.
>
> hth,
>
> DK
>
> - Original Message -
> From: SHEETS, DAYV (PB) <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Saturday, April 14, 2001 1:31 AM
> Subject: Dynamically Displayed Content Weekly?
>
>
> > Can anyone tell me where I could find out more regarding dynamically
> > displaying text on a cfm page weekly?
> >
> > I know this can be done in ASP but wasn't sure if it was possible in cf.
> >
> > TIA,
> > Dayv
> >
> >
>
>
~~
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: Dynamically Displayed Content Weekly?

[Christopher Olive, CIO]

you don't even really need to do that.  if you have queries to pull the data
from your database on the "main page" (the one with the weekly data), use
the CACHEDAFTER property of CFQUERY.  this will cache the results until a
certain date.  set the date for one week from today, and voila!

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: dk [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 14, 2001 3:49 AM
To: CF-Talk
Subject: Re: Dynamically Displayed Content Weekly?


Just create a .cfm page to get/ retrieve the content (maybe from a database
or from some other site).

Use the cfschedule tag to create a weekly schedule to run the above .cfm
file once a week. This will update the content weekly.

hth,

DK

- Original Message -
From: SHEETS, DAYV (PB) <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 1:31 AM
Subject: Dynamically Displayed Content Weekly?


> Can anyone tell me where I could find out more regarding dynamically
> displaying text on a cfm page weekly?
>
> I know this can be done in ASP but wasn't sure if it was possible in cf.
>
> TIA,
> Dayv
>
>
~~
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: disabling back or second insert

[Christopher Olive, CIO]

only problem with that particular approach is that HTTP_Referer is not
always passed by the browser.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 9:48 PM
To: CF-Talk
Subject: Re: disabling back or second insert


This approach is interesting... it uses a session variable and the
HTTP_referer variable to check if the user is going "back" and simply won't
let them.

http://cfhub.com/contributions/backbutton/

> you really can't stop them from using the back button.  javascript won't
let
> you touch the "chrome" stuff on a non-js generated window.  even if you
> could stop the button itself, they could right-click in the window and
> select back, or do a few other things.
>
~~
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: disabling back or second insert

[Christopher Olive, CIO]

you really can't stop them from using the back button.  javascript won't let
you touch the "chrome" stuff on a non-js generated window.  even if you
could stop the button itself, they could right-click in the window and
select back, or do a few other things.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 12:07 AM
To: CF-Talk
Subject: RE: disabling back or second insert


Might as well chime in

What I do is set a hidden variable in the form, usually a time/date or
random number (depends on how I'm feeling!). That variable is created on the
first page of the form. It can be carried through countless form pages, but
the user hits the submit and an insert is to be performed, I query the db
for a record with that variable, if it already exists, it is presumed this a
duplicate entry attempt, and the insert is not performed. Sometimes I even
spit our a little message like "Yeah Yeah we got it the first time you hit
submit!" that sorta thing.

The only really drawback to this is if the user hit the back button to make
changes to his form entry, they will never be submitted.

I would prefer the abilty to kill the back. How are some of you doing this
with Javascript?

Brian

-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 3:52 PM
To: CF-Talk
Subject: RE: disabling back or second insert


why not move the check to the action form?  that way they can enter the data
all they want, and click submit all they want.  it won't insert the data if
someone by that name's already there.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Smith, Daron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 9:17 AM
To: CF-Talk
Subject: disabling back or second insert


I have a registration form, that queries initially to make sure that the
registrant is not already registered, so it eliminates people from
registering more than one time if they come back to the site, however if
they submit the form and do not think anything has happened, they can use
their back button, hit the submit button and the query does another insert
and I end up with multiple records in my DB.  What is the best way of
keeping them from doing this?  An expiring cookie? Or is there javascript to
eliminate the ability to go back?

Thanks

Daron J. Smith



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: disabling back or second insert

[Christopher Olive, CIO]

why not move the check to the action form?  that way they can enter the data
all they want, and click submit all they want.  it won't insert the data if
someone by that name's already there.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Smith, Daron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 9:17 AM
To: CF-Talk
Subject: disabling back or second insert


I have a registration form, that queries initially to make sure that the
registrant is not already registered, so it eliminates people from
registering more than one time if they come back to the site, however if
they submit the form and do not think anything has happened, they can use
their back button, hit the submit button and the query does another insert
and I end up with multiple records in my DB.  What is the best way of
keeping them from doing this?  An expiring cookie? Or is there javascript to
eliminate the ability to go back?

Thanks

Daron J. Smith



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: Reveral of a field

[Christopher Olive, CIO]

you could use the listfirst and listlast functions.  assuming that your
names are alwas Last, First:




#listlast(thename)# #listfirst(thename)#


make sense?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 7:48 AM
To: CF-Talk
Subject: Reveral of a field


Hi,
I have a field with Smith, John as the contents.

I want to display John Smith...

I'm think I get the total length(a), then the charlength of the comma(b).

Take contents b + 1 and subtract that from a equals (c)
Then display the difference of c to a (d)
and then output c after d to the total of the field

Any other ideas?
~~
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: adding records

[Christopher Olive, CIO]

i don't think it will directly do it.  i've worked with it, and she wants to
populate a textbox, not another drop down.  but i think you can abuse the
tag by writing your own handler for what it already does.  just replace the
bit that changes the second select box to populate the text box.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 6:50 PM
To: CF-Talk
Subject: RE: adding records


Check out the Allaire Developer's Exchange for CF_TwoSelectsRelated custom
tag.  This will do exactally what you want.
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA
9700508B94F380&method=Full
(carefull of the line wrapping...)

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

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



-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:43 PM
To: CF-Talk
Subject: adding records


hey again,
i have a form which allows a user to add a new application to my apps
database.
i want to have a drop down list of companies. (that i can do) but i want the
phone number field to automatically populate if when the user selects say
"microsoft" from the list. that phone number will show up in the phone
number field because "microsoft" has a phone number in my database.
otherwise, the person inputting the data will have to retype the phone
number in each time (and remember the number in order to input it!)
is this possible to do on the same form?
thanks for the info..
b


*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information.  If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
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: How to Allow a "Doesn't Matter" Variable in a Search?

[Christopher Olive, CIO]

if you use checkboxes for the selections, use isDefined() on your action
page.  if the checkbox for that selection is defined, include it in your
where clause

ex:

SELECT


WHERE


AND 


chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 1:31 PM
To: CF-Talk
Subject: How to Allow a "Doesn't Matter" Variable in a Search?


Friends:  Can anyone help with this problem I'm stuck on? Not sure if this
is a simple one or not, but in any case I'll sure be delighted to get it
working.

This set of pages allows the user to search a set of records using 9 search
objects. Four of those are for searching yes/no (1/0) fields in the
Access2000 database.

For the four search fields which search yes/no columns, I  want them to
choose either "This doesn't matter - don't include this in the search" OR
"Include only records with "yes" (1) in this column. They need to be able to
specify that they want to see only rental properties that have a hot tub, or
else that this doesn't matter to them.

Obviously this differs from offering the choice between "Include only
records with 'yes' in this column" and "Include only records with 'no' in
this column", which is *not* what I need to do here.

This could be done with checkboxes or a menu - but I can't figure out how to
allow that "This doesn't matter" search parameter.

Thanks very much in advance for your help!


P@tty Ayers
Macromedia Evangelist

Dreamweaver Resources, FAQs, and Tutorials:
http://www.thepattysite.com/dreamweaver/

P@tty's ColdFusion Site
http://carolina.cf-developer.net

Carolina Web Solutions
http://www.carolinawebsolutions.com

"Design in art, is a recognition of the relation between various things,
various elements in the creative flux. You can't invent a design. You
recognise it, in the fourth dimension. That is, with your blood and your
bones, as well as with your eyes."  - D. H. Lawrence

"Well-behaved women seldom make history."  - Anonymous
~~
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: Line Breaks

[Christopher Olive, CIO]

it's not.  i was thinking of making it on so i could use the  tags.
then i realized i HATE getting HTML formatted mail.  i have my reader set up
as plain text.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 6:54 PM
To: CF-Talk
Subject: RE: Line Breaks


I know this sounds basic, but...  It's not an HTML email,is it?  If it is,
carraige returns won't mean a thing, you'll need  and  tags.


Evan

> -Original Message-----
> From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 5:55 PM
> To: CF-Talk
> Subject: RE: Line Breaks
>
>
> that's odd.  would have been my answer before today, but i had a template
> that WOULD NOT put in CRs for me.  wierd.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Diana Nichols [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 5:22 PM
> To: CF-Talk
> Subject: RE: Line Breaks
>
>
> CFmail works just like .line breaks, tabs, etc will appear in the
> email as you type them
>
> *
> Diana Nichols
> Webmistress
> http://www.lavenderthreads.com
> 770.434.7374
>
> "One man's magic is another man's engineering." ---Lazarus Long
>
> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 5:18 PM
> To: CF-Talk
> Subject: Line Breaks
>
>
> How do you make line breaks within a ?  Everything seems
> to just run
> together.
>
> Rich
>
~~
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: Simple validation

[Christopher Olive, CIO]

isDate().  isNumeric().

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Steven A. del Sol [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 6:04 PM
To: CF-Talk
Subject: Simple validation


I am in desperate need of a simple validation of two types of form fields.

1.   Date field (not a cfform just a plain form) - must validate that data
entered is a date

2.  Number field (not a cfform just a plain form) - must validate that data
entered is a number


Thanks

Stephanie
~~
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: Line Breaks

[Christopher Olive, CIO]

that's odd.  would have been my answer before today, but i had a template
that WOULD NOT put in CRs for me.  wierd.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 5:22 PM
To: CF-Talk
Subject: RE: Line Breaks


CFmail works just like .line breaks, tabs, etc will appear in the
email as you type them

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 5:18 PM
To: CF-Talk
Subject: Line Breaks


How do you make line breaks within a ?  Everything seems to just run
together.

Rich
~~
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: [Oracle Auto-Increment]

[Christopher Olive, CIO]

just mark something as an identity in the design table form.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 9:58 AM
To: CF-Talk
Subject: RE: [Oracle Auto-Increment]


What about SQL Server -- how to auto-increment??

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Alex [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 02, 2001 9:45 AM
To: CF-Talk
Subject:Re: [Oracle Auto-Increment]

create a sequence then in your INSERT sql type sequencenqme.next_val.
not sure on specific syntax

Jamie Symonds <[EMAIL PROTECTED]> wrote:
Hi - I am inserting results of a form into an Oracle 8
database - in the past, while using Access, I would set the
first field of the table ("id") to "auto-number" for my
primary key.  Oracle does not have an auto-increment feature
- how do I go about this?  Thanks.
~~
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: Escaping apostrophes

[Christopher Olive, CIO]

PreserveSingleQuotes().

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: andrew kopelman [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 2:39 PM
To: CF-Talk
Subject: Escaping apostrophes


Hello,

This must be a basic question, but I found no real answer on the allaire
forums.

I want to allow users to enter apostrophes in text, which I then save to the
database.  However, the sql insert will fail as it interprets this
apostrophe within the text as one of the apostrophes surrounding the text.

Example:

INSERT INTO tblUserComments (userid, usercomment)
VALUES (12345, 'I don't know what to think')

This fails on the ' in don't

There must be a better solution than HTMLEditFormat.

Thanks in advance.
~~
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: Text area question

[Christopher Olive, CIO]

when you save it, make sure your form area WRAP attribute is set to HARD.
then use paragraphformat on the output side.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Javed Mushtaq [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 4:18 AM
To: CF-Talk
Subject: Text area question


Hi all,

I have a text area on a page and need to save to a database and then output
the information exactly as it appeared on the text area.

How do i do this, could anyone send me the code as got to get this up and
running by 10am today.

Thanks in advance.
~~
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: Import List into DB

[Christopher Olive, CIO]

just use Access' Import function and select "Text File" as a source.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jim Mixon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 6:55 PM
To: CF-Talk
Subject: Import List into DB



a question for the sages here . .  .

What would the CF function or tag be for importing a simple list, w/line
breaks ie. . .

[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]

which is in a plain ASCII .txt file
into an existing ACCESS table . . .  .

OR is there a way?

thanks in advance. . .
Jim Mixon - CEO
APT POINT NET, Inc. "A Premiere InterNET Gateway" . . .
[EMAIL PROTECTED]   http://www.apt.net/
PO Box 160217 Hialeah, FL 33016 305-821-8451
FAX (305) 821-8189 auto-switching FAX
powered by Cold Fusion 4.01 . . . . feel the force!
CF Hosting Now Available . . . . !
~~
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: session time out

[Christopher Olive, CIO]

you need to enclose your time units in " marks for createtimespan

eg:
createtimespan("0","1","0","0")

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 3:52 PM
To: CF-Talk
Subject: session time out


Hi all,

I tried to use:



for one hour time out, but it still keeps 20 mins time out.

any ideas and suggestions?

thanks in advance!
~~
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: newbie wants to access by rows and columns

[Christopher Olive, CIO]

technically, you can't do this.  some other people have suggested solutions
that will give you a close approximation of "the second row".  the problem
(there is no fault with the suggestions or code) is that the concept of "the
second row" is not a constant.  because of the way RDBMS systems work, there
is no way to *guarantee*, *every single time* that the "second row" will be
the "second row".

the data "lives" out in database land, and is returned in sets.  just
because something is the second row one time you query for * from the DB,
there is no hard and fast guarantee that it will be the second row the next
time.  this is especially true for SQL server and Oracle (IOW, the more
"powerful" DBMSs.)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:48 PM
To: CF-Talk
Subject: newbie wants to access by rows and columns


Yes, Lee I want to access fields by rows and columns. Exactly. If it is more
advanced which you state it is, what topic would I look under in a Cold
Fusion book. I've abused everyone's talents enough for one evening. I'm
willing to go out and study this on my own. I just need direction.

Thanks,
Greg

-Original Message-
From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:38 PM
To: CF-Talk
Subject: RE: Thanks everyone but one last question

Do you really want to see what's in row 2, column 2, or do you want to see
what ID(3)'s First Name is?  That seems much more useful.

To do that you just use


SELECT FirstName from TableName
WHERE ID = 3


#test.firstname#


If you really want to access fields by row and column number, there are a
number of ways, all of them slightly more advanced, but I doubt that's
actually what you want.

Let us know,

thanks Leeb.




-Original Message-
From: Roadrunner [mailto:[EMAIL PROTECTED]]

..

See the database setup below.

ID   PASSWORD FIRSTNAME LASTNAME
4  sdf  greg landry
3  gth  tom  jones

Lets say I wanted to see what is in the second record and see what's under
the column FIRSTNAME. What I am learning is that I have to print out the
entire database to see what is in it. I would just like to be able to know
how to access a particular element in a database. Like what's in row 2,
column 2?


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

[Christopher Olive, CIO]

i've never had the defaults/identity stuff transfer successfully, either.
even between SQL installs, selecting "Transfer Objects".  i've resorted to
scripting the tables, sticking the defaults in myself (scripting will
capture the identities) and running the scripts on the target system.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 9:02 PM
To: CF-Talk
Subject: RE: SQL Server...


> I used the SQL Server export function (Data Transformation
> Service) to move data (and table structure) from one SQL Server
> database to a blank SQL Server database. Everything looked fine
> initially, however I have realized that it did not copy over
> default value. Nor did it copy over seed information.
>
> Is this common? Is there a better way to do this (Other than
> detaching / attaching the database)? Although I haven't verified
> it yet, I do suspect that I exported the data from a SQL Server
> 2000 DB into a SQL Server 7 DB. Would I experience the same
> results if this occurred between to SQL Server 2000 DBs?

Typically, when transferring between two SQL 7 servers, you have an option
to transfer "objects and data". This gets not only the tables and their
data, but everything else as well.

In addition, you can do a backup to file from one, then restore from file on
the other. I've had better luck with that, with pre-SP versions of SQL 7.
This is better than detaching and attaching, since you don't have to stop
operation of the database on the source server, and you don't have problems
with "phantom logins" that might exist in one server but not the other.
(Although there is a way to address that, if necessary.)

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: SQL + time stamp

[Christopher Olive, CIO]

try GROUPing on the hour part of the time.

similar to:

SELECT
datepart("hh", dt) as myhour, sum(columnOne) as totalflow
FROM

WHERE

GROUP BY datepart("hh", dt)



chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 12:29 PM
To: CF-Talk
Subject: RE: SQL + time stamp


Eric one reading is coming in every 15 minutes of every hour.

Its a C compiled agent that is taking quartly flowrates from a reservoir and
emailing to our database.

I'm getting 4 readings, one every 15 minutes, 4:15 , 4:30 , 4:45 , and 5:00
and so on.

the only thing is they are not coming in quite as accurate like that, at
least not all the time.

More like 4:16 , 4:29 , :4:45 , 4:59.  So what I want to do is sum(all
Quaters for every hour).

Any ideas? (hope this is clearer!!)

-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 16:07
To: CF-Talk
Subject: RE: SQL + time stamp


John,

I'm not quite clear what your getting at  do you mean that a reading
is taken every 15 minutes and you want to know the sum of the readings
at 00, 15,30, and 45 ?  so that the readings from 2:15 are summed with
readings from 1:15 and 3:15  ?

Or are multiple readings being inserted every 15 minutes and you want
the sum of all the entries entered at 2:15 to be in one group and 2:30
in another and 3:15 into still another ?


-eric

Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

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


-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 8:11 AM
To: CF-Talk
Subject: SQL + time stamp


I know this is an SQL question.

I am getting readings inserting into a database every 15 minutes on the
hour.

They are time stamped like so,

(dt) (columOne)

2001-02-28 12:59:5938.7
2001-02-28 12:45:0138.77
2001-02-28 12:30:0138.7
2001-02-28 12:15:0137.22


My problem is how would I do a sum value for 'columOne' adding up each
quarter for each hour?
~~
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 users name

[Christopher Olive, CIO]

it's NT Challenge/Response. (not that that's important...:)

look at CGI.AUTH_USER for the login name.

(this question has been asked several times recently.  kind of interesting
how things seem to run in cycles)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 12:08 PM
To: CF-Talk
Subject: OT: getting users name


I have a web page that is secured so the user has to enter a name and
password to get into the site.  This is done with WinNT permissions on the
folder that the web page is in.  I think the official name is server side
validation.

Is there a way to grab the name the user inputs and use it in my cold
fusion pages?

Thanks In Advanced
Chad
~~
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: Building Cold Fusion Search - Dynamic SQL

[Christopher Olive, CIO]

great googlymoogly!  my bad.  thanks.

(i've been doing "customer relationship" stuff all day.  must have rotted my
brain!)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Maia, Eric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 2:22 PM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records looking for two values. You'll need to
do a self-join or subquery to look for one record in emp that has two or
more related records in empSkills that match the two skills you're looking
for.

Try this:

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId

mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:43 AM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


since a multiple select gives you nothing more than a list, try a list loop.

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com



-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:23 PM
To: CF-Talk
Subject: Building Cold Fusion Search - Dynamic SQL


I'm trying to build some sql statements based on selections from a list box:


 Skill1
 Skill2
 Skill3
 Skill4
(etcthis size will vary as it's dynamically populated)


A user can do a multiple select, so let's say the user picked option 1 and
option 3.

On my action page, I want to pick ONLY the employees that have the 2 skills
selected.

If I use an IN statement, I get employees with one skill or the other, but I
only want those with both:

   SELECT e.empId,es.skillId
from emp e,empSkills es
where skillId IN (#frmSkill#)
AND e.empId=es.empId

How can I write the SQL to select only the employees with both, or do I use
Cold Fusion to do that?

Kim Mayhall
The Garrigan Lyman Group
http://www.glg.com 
(206) 223-5548
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Using Authentication window

[Christopher Olive, CIO]

an authentication window?  you mean like the one IIS pops up when using
NTCR?

after authentication, check CGI.AUTH_USER (CGI.REMOTE_USER might work as
well.  i've seen them both used).

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:46 PM
To: CF-Talk
Subject: Using Authentication window


Does anyone know how to get a userid from a Authentication and pass that
variable to CF so that I can use it to query a DB and populate some fields?

I would appreicate it any help that you can offer.

Thanks in Advance.

Michael
~~
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: Building Cold Fusion Search - Dynamic SQL

[Christopher Olive, CIO]

since a multiple select gives you nothing more than a list, try a list loop.

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com



-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:23 PM
To: CF-Talk
Subject: Building Cold Fusion Search - Dynamic SQL


I'm trying to build some sql statements based on selections from a list box:


 Skill1
 Skill2
 Skill3
 Skill4
(etcthis size will vary as it's dynamically populated)


A user can do a multiple select, so let's say the user picked option 1 and
option 3.

On my action page, I want to pick ONLY the employees that have the 2 skills
selected.

If I use an IN statement, I get employees with one skill or the other, but I
only want those with both:

   SELECT e.empId,es.skillId
from emp e,empSkills es
where skillId IN (#frmSkill#)
AND e.empId=es.empId

How can I write the SQL to select only the employees with both, or do I use
Cold Fusion to do that?

Kim Mayhall
The Garrigan Lyman Group
http://www.glg.com 
(206) 223-5548
~~
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: Selecting a date range, access DB

[Christopher Olive, CIO]

where you will be promptly killed and eaten by the CFTALKers waiting for
your return.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Ramonda Ramos [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 11:59 AM
To: CF-Talk
Subject: Re: Selecting a date range, access DB


I will be out of the office today, Monday, February 26.  I will return
Tuesday, February 27.
~~
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: Selecting a date range, access DB

[Christopher Olive, CIO]

well, if you pick all the dates that have a date greater than today AND less
than today, you'll get nothing. :)

i think you need to rethink your date range. :)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 10:45 AM
To: CF-Talk
Subject: Selecting a date range, access DB


My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:

  SELECT * FROM Articles
  where approved
  and startdate > #Now()# and
  expirydate < #Now()#

Turning on debug on the server shows this ends up as
SQL = SELECT * FROM Articles where approved and startdate > {ts '2001-02-26
15:37:22'} and expirydate < {ts '2001-02-26 15:37:22'}

Unsuprisingly, this returns no results (there is at least one record in the
intended range). Is my SQL off, or do I need to use a particular type of
date in access ?

Regards,

Thomas Chiverton,
Intranet Webmaster and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
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: browser refresh/reload

[Christopher Olive, CIO]

that's not strictly correct.  the webserver and browser are the ones that
handle these variables (CGI and HTTP scoped ones.)  not all browsers support
them.

additionally, the HTTP_REFERER variable you talk about first is only
populated when following a link.  refreshing a page does not change the
referer.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:36 PM
To: CF-Talk
Subject: RE: browser refresh/reload


yes there is.  there coldfusion automatically creates a variable that
contains the url or address that u came from to get to the current page.  it
also gives u a variable which contains the url of the page u are on (I  am
95% sure hehe).  so u can do a CFIF to see if the page the person came from
matches the page he is at.  if it is true, then it must be a refresh

-Original Message-
From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 10:52 AM
To: CF-Talk
Subject: browser refresh/reload


Is there a way to determine in CF whether the page has been refreshed or
reloaded?  Or maybe a method in JavaScript?

thanks
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: A little help with aggregate query, please?

[Christopher Olive, CIO]

your sum is being GROUPed by each individual donor.  it might be more
advantageous to calculate it yourself while looping through the "individual
donors" query.

ex: query


SELECT
Donors.ID, Donors.Fname, Donors.MI, Donors.Lname, Donations.DateDonated,
Donations.AmountDonated,
FROM Donors, Donations
WHERE Donors.ID = Donations.DonorID AND Donations.DateDonated Between
#CreateODBCDate(StartDate)# and #CreateODBCDate(EndDate)#
ORDER BY Donors.ID, Donors.Fname, Donors.MI, Donors.Lname,
Donations.DateDonated


then in your output...













your totals will be in these two variables to display at your leisure.


chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 5:53 PM
To: CF-Talk
Subject: A little help with aggregate query, please?


Howdy,

I have an aggregate query that's kicking my butt. Its purpose is to retrieve
a simple report of donations by donors within a given date range. Most
everything works except for the Count and Sum functions. I'm not sure this
can be done in one query or not. Database is MS Access.

What I'm trying to do: display individual donations (name, amount and date
they donated) and then have a total for the number of people who donated
during this period and the total amount of their donations.

Here's what a simple report should look like:

Period: 1/1/2001 to 3/1/2001
Donor   Amount Donated Date Donated
James C Montgomery  $1.0002/21/01
Joe A Blow  $1.0002/21/01
John C Doe  $1.0002/21/01

  Total Donors This Period: 3
 Total Donated This Period: $3.00

But here's what I'm getting:

Period: 1/1/2001 to 3/1/2001
Donor   Amount Donated Date Donated
James C Montgomery  $1.0002/21/01
Joe A Blow  $1.0002/21/01
John C Doe  $1.0002/21/01

  Total Donors This Period: 1
 Total Donated This Period: $1.00

Notice the totals aren't computing properly.

Here's my code:





SELECT Donors.ID, Donors.Fname, Donors.MI, Donors.Lname,
Donations.DateDonated, Donations.AmountDonated, Count(Donors.ID) AS
DonorCount, Sum(Donations.AmountDonated) AS TotalAmount
FROM Donors, Donations
WHERE Donors.ID = Donations.DonorID AND Donations.DateDonated Between
#CreateODBCDate(StartDate)# and #CreateODBCDate(EndDate)#
GROUP BY Donors.ID, Donors.Fname, Donors.MI, Donors.Lname,
Donations.DateDonated, Donations.AmountDonated






Donation Report





Period: #startdate# to
#enddate#


Donor
Amount Donated
Date Donated



#fname# #mi# #lname#
#DollarFormat(amountdonated)#
#DateFormat(datedonated, "mm/dd/yy")#







Total Donors This Period:
#GetReportInfo.donorcount#
Total Donated This Period:
#DollarFormat(GetReportInfo.totalamount)#



There were no donations during this period.





If anyone can help me figure out how to fix the query I would greatly
appreciate it.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
~~
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: Delimiters...

[Christopher Olive, CIO]

look at the ListFirst, ListLast, and ListRest functions.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 4:20 PM
To: CF-Talk
Subject: Delimiters...


Hi all

Is there a command similar to Left(string, count) that is

DelemiterLeft(String,Delimeter)
DelemiterRight(String, Delimeter)

such that if I was to get a variable like

Name = Toohey,Elton

I could do

#LastName

would give me

Toohey

?

thanks...

ethan



- Original Message -
From: "Ethan Rosch" <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 3:20 PM
Subject: Re: modules, loops, and fun!


> Hi Douglas...thanks for the tip...
>
> I still think I need to pass my fields as I will be uploading/deleting
files
> and don't want to be running my actions on every field.  Perhaps I could
> just do a test for "://".
>
> the evaluate() was what I was looking for.
>
> e
>
> - Original Message -
> From: "Douglas Smith" <[EMAIL PROTECTED]>
> To: "Fusebox" <[EMAIL PROTECTED]>
> Sent: Friday, February 16, 2001 11:55 AM
> Subject: Re: modules, loops, and fun!
>
>
> > By the way, you don't need to pass in your list of form fields, since
they
> > are globally available to the CFMODULE you are running.
> >
> > I think you want to use the EVALUATE function like so:
> >
> > 
> >  
> > 
> >
> > However, if you do a list loop (which is slightly slower), then do this:
> >
> > 
> >  
> > 
> >
> >
> > At 10:22 AM 2/16/01, Ethan Rosch wrote:
> > >hi all...
> > >
> > >quick question as I delve into the world of modules and loops...
> > >
> > >
> > >I am trying to build a module that will in turn loop over the
attributes
> > >sent to it, which are form fields..this module will take whatever
> form
> > >fields are sent to it and then get there values and act via a loop.
> > >
> > >my problem is how to get the formfelds to parse to their values in the
> > >module loop and not their names.
> > >
> > >here's a sample code of the idea:
> > >
> > > > > mylist="firstformfieldname,secondformfieldname,">
> > >
> > >---
> > >
> > >for this example let's say that
> > >
> > >firstformfield's user inputed value = Red
> > >secondformfield's user inputed value = blue
> > >
> > >now the module
> > >
> > >---
> > >
> > >
> > >
> > > #Fieldname#
> > >
> > >
> > >
> > >
> > >
> > >what I want is :
> > >
> > >Red
> > >Blue
> > >
> > >what I get is:
> > >
> > >FirstFormField
> > >SecondFormField
> > >
> > >any idea's would be greatly appreciated...I'm beating myself up and now
I
> > >come to you.
> > >
> > >thanks,
> > >
> > >ethan
> > >
> > >
> > >
> >
>
~~
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: Passing a value

[Christopher Olive, CIO]

looks like you're not terminating the string on the last meta tag.

http://www.workcover.com/search/?ul=&ps=10&np=0&q=#URL.SemioQ
ueryString#">

notice the closing " on the content piece.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 7:03 PM
To: CF-Talk
Subject: Passing a value


Can anyone help me with this please and tell me why I am not getting the
output I want. I am passing a value on the URL. If my input is say "rise"
what I am getting from this template is "rise head body bgcolor text"
instead of just "rise". I have considered CFLOCATION but the problem is that
when I get this working I need to put some frame busting code in and I
understand that there is a problem mixing JavaScript and CFLOCATION.




SEMIO Redirect


http://www.workcover.com/search/?ul=&ps=10&np=0&q=#URL.SemioQ
ueryString#>







+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287

+




This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.

~~
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: can anyone help?

[Christopher Olive, CIO]

you need to put the lvalue in for both comparisons.

like this:



chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 12:40 PM
To: CF-Talk
Subject: can anyone help?


Hello all,

Im getting an error that i cant figure out here... everything looks fine to
me but maybe someone else can see something. here is the error..

Error Diagnostic Information
Just in time compilation error

Invalid parser construct found on line 98 at position 30. ColdFusion was
looking at the following text:

GTE
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was a CFIF tag occupying
document position (98:2) to (98:6).

AND HERE IS MY CODE:


  SELECT * FROM SubCats
  WHERE TopCatID = #URL.CategoryID#
  ORDER BY SubCat
  


  #prodpage.Category#



  


  
  
  

!! this is line 98!! 

  
  
  

  
  
  #ItemN
ame#

  
  
  

 

 

  
  
  

  
  
  #ItemN
ame#

  
  
  

 

  

  

  
  
  

Any help would be much appreciated.
Thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.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: IIS redirect URL

[Christopher Olive, CIO]

you don't really need a redirect.  just create a virtual site for
members.mydomain.com with its root at /userhomepages.  that should get you
started.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:08 PM
To: CF-Talk
Subject: OT: IIS redirect URL


I apologize for the off topic message but I am about to pull my hair out
trying to figure out how to redirect a URL in IIS v5.0...  I have a website
that has two domain names...

http://www.mydomain.com  and http://members.mydomain.com   they are both
DNS'd to the same IP address... the members.mydomain.com needs to redirect
to a members homepage... I have directory structure under my wwwroot that
holds all the members homepages...  /userhomepages/username   I need the
members to be able to type the url... http://www.mydomain.com/username and
have it redirect to the correct /userhomepages/username under the wwwroot.

I have played around using various combinations of the redirection variable
$S... but the IIS docs do not really give any examples... they simply state
to use $S to append what follows the redirected URL...

Any help would be greatly appreciated

thanks
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: Pre-made State and Country database tables?

[Christopher Olive, CIO]

there's country and state tags in the Developers's exchange at allaire.
very nice, i use them a lot.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Joby Bednar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 8:18 PM
To: CF-Talk
Subject: OT:Pre-made State and Country database tables?


Anyone have a pre-made Access database table with the State Name and State
Abbr. and/or Country Name and 2 digit Country Code?  Or really any other
information that might be of use...

I'm using Access 2000, but any format that can be imported would be helpful.
I need to use them for a client's site and I shutter at the thought of
researching the info and populating the fields myself.  Sorry for being
lazy, but I thought I'd try...

I've got SIC codes in a table if anyone wants to swap?  ;)
Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED]
Cell:  949-283-5138
Personal Fax:  208-485-1170


  Only $19.95!  Register your Domain Name with
  SAVE-A-NAME.COM
 www.  .  com net org
~~
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: Dateformat behaviour

[Christopher Olive, CIO]

actually, it looks like DateFormat is helping you out by assuming that the
second date you supply is the "european" style of mm/dd/.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:05 AM
To: CF-Talk
Subject: Dateformat behaviour


Have a strange behaviour of DateFormat() function. Look at the following
code and the results below. In my opinion CF could give me an error message
on the second line (invalid date) but certainly not invert the day and month
as it does!

Your comments?

Dominique





  
Dateformat("01/12/2000","mmdd")
#Dateformat("01/12/2000","mmdd")#
  
Dateformat("13/12/2000","mmdd")
#Dateformat("13/12/2000","mmdd")# 




Dateformat("01/12/2000","mmdd")
2112
Dateformat("13/12/2000","mmdd")
20001213
~~
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: Server Running Low on Virtual Memory

[Christopher Olive, CIO]

doing a properties on that file, i see it's description is (helpfully...)

"Generic Host Process for Win32 Services".

HTH.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Raley, Scott M (MIL) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 3:21 PM
To: CF-Talk
Subject: RE: Server Running Low on Virtual Memory


I've had a problem with CF 4.5.1 and Win2K AS ... there is a file called
svchost.exe that shows up in taskmanager. I don't recall what it is linked
to but every once in a while it goes crazy and eats up all the virtual
memory and I have to reboot the server. I've added SP1 and that hasn't
solved the problem either.  I've been shutting down service by service to
see if I can figure out what is causing it to trigger but nothing yet.

-Original Message-
From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 1:33 PM
To: CF-Talk
Subject: Server Running Low on Virtual Memory


Hi All,

For the past couple of months we have been getting a low virtual memory
error on our CF Server about every 10 days. The CF server software ran fine
until we moved it to Win2K and added .asp pages to the server as part of our
intranet (please don't ask why, but part of our intranet is written using CF
technology and the other part in written using  ASP technology, both running
session variables).

Here is the server's configuration:

Win2K (no service pack)
CF 4.5.1 SP1
Max 728 MB Paging File
PIII 800 with 256 MB Ram
Plenty of harddrive space
No Active Directory Service on Win2K


In addition to this, we access an Oracle database using native drivers for
the CF pages and ADO for the ASP pages. There is also an additional website
running on the server using an Access 97 database as the backend (the
shopping cart application we are using is AbleCommerce).

We haven't been able to pinpoint the source of the memory leak. We don't
know if it has to do with AbleCommerce and Access 97, the .asp or .cfm
connections to the Oracle database, or simply some other memory leak problem
between Win2K and CF.

If anyone has any experience or practical suggestions on how to fix the low
memory error, your knowledge would be greatly appreciated. As it stands
right now, we end up having to reboot our Web Server every Monday morning to
avoid the low memory error which eventually shuts down the server if it is
not caught in time.

Thanks,

Debbie McDaniel
Sr. Web Developer


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: Urgent - Forums 2.05 Anyone Got?

[Christopher Olive, CIO]

unfortunately, it's not so easy to find the "TODO" list for the forumspot
project.  i looked all over the site today, as i'm interested in
contributing, but could find no place that listed the TODO stuff (as is
traditional in open source projects).

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 6:27 PM
To: CF-Talk
Subject: Re: Urgent - Forums 2.05 Anyone Got?


Gel,

Since Forums is now open source, you have a great opportunity to contribute
to the project and make all of those features happen. When should we expect
your involvement in the effort and the completion of all of these great
additions?

Rey
Forumspot Core Team Member
www.forumspot.org

- Original Message -
From: "Angél Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 3:17 PM
Subject: RE: Urgent - Forums 2.05 Anyone Got?


> I don't understand..
>
> why doesn't the CF Forum software look like the accepted and most useful
> type of discussion board? The Threaded Discussion Board...
>
> and why doesn't it have cool features like small iconic representations of
> board members etc.??
> I mean look at UBB, Fuestalk,even Coolboards..they all have some really
cool
> features and appear...Exciting!
>
> That CF Forum stuff just looks so ..bland by today's standards.
> Why would someone choose this over say Fusetalk? Beside the fact that it's
> free..
>
> -Gel
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Multiple conditions in a single CFIF statement.

[Christopher Olive, CIO]

what you wrote was correct.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001 11:15 PM
To: CF-Talk
Subject: Multiple conditions in a single CFIF statement.


So far I've only used single 

without using nested 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: Session timeout question

[Christopher Olive, CIO]

i don't think that's strictly correct.  you can't "define the timeouts" of
session variables, you define them of the entire session.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 3:34 PM
To: CF-Talk
Subject: RE: Session timeout question


that's not exactly true. if you define the timeouts of session variables in
an application.cfm file, they can timeout at different times. if you set one
to timeout in 15 minutes and another at 30 minutes, then idled for 20
minutes, the first would timeout, the second would not.

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 2:49 PM
To: CF-Talk
Subject: Re: Session timeout question


On 2/7/01, Phoeun Pha penned:
>Oh, i know the question now!  Are individual session variable timeouts
>independent of other session variables, or are they all affected at the
same
>instance?

All session variables that exist are refreshed at the same time when
cfapplication loads and will time out simultaneously, or real close
to it.
--

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: Displaying the IP of a server

[Christopher Olive, CIO]

CGI.REMOTE_ADDR will give you the IP of the client computer, if their
browser supports it.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 3:09 PM
To: CF-Talk
Subject: RE: Displaying the IP of a server


CGI.REMOTE_ADDR

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 4:19 AM
To: CF-Talk
Subject: Displaying the IP of a server


Can't find the answer to this probably oh-so-easy question...

What variable holds the IP address of a server?

Turned debugging and there's no cgi variable that displays it... only server
name which is the URL part after http://.



Thanks

--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
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: trim a string variable

[Christopher Olive, CIO]

i was actually going to suggest this.  the only problem is if the file name
is something like filename.old.cfm or something like that.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 3:42 PM
To: CF-Talk
Subject: RE: trim a string variable


Look at the List functions within ColdFusion - they are extremely useful.
In your example, you could say



Note that you don't need the # signs inside the  tag.

Bob

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: February 7, 2001 1:56 PM
To: CF-Talk
Subject: trim a string variable


Is there a way to trim a string like : file.jpg
to  : file
(aka knock off the last 4 characters)

  Does not work because the
name of the file in the database could be longer then 4 characters

Is there a function that im missing to trim off the last 4 characters of a
variable?

Thanks
Chad
~~
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: ORDER BY?

[Christopher Olive, CIO]

order by the aggregate function.


SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (MoneyEarned) as
TOTALMONEY
FROM ResultsManager
GROUP BY ContestantID
ORDER BY SUM(AdjPoints)



chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 2:00 PM
To: CF-Talk
Subject: ORDER BY?


im having trouble getting this query to order the results the way that i
want it to...
OR am i going about this the wrong way? i want it to total the points for
each contestant
and then output them in a page listed first through whatever it outputs them
fine w/o the order by
but it orders them by ContestantID, i need it go order by the amount of
total points that the query
comes up with. it should be:

contestant 2  500
contestant 3  485
contestant 1  355
ect

but instead its

contestant 1  355
contestant 2  500
contestant 3  485
ect..

can anyone help me with this?
here is my query:



Thanks,

Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.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: CFLOCK question

[Christopher Olive, CIO]

AAMOF, the scope attribute was added in 4.5.  you have to use "NAME" in 4.0.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: JB Mentzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 10:25 AM
To: CF-Talk
Subject: CFLOCK question


Hi all

I'm attempting to execute this:



On CF Server 4.0.

This is the error I'm getting:

Just in time compilation error

 An unknown attribute 'scope' has been encountered at document position
(35:10) to (35:14) while processing tag CFLOCK. This tag can only take
the
 following attributes:

  NAME
  THROWONTIMEOUT
  TIMEOUT
  TYPE

I removed the attribute and the error goes away. Any chance that CF
Server 4.0 doesn't support the scope attribute?

Thanks!

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

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

RE: Syntax error....

[Christopher Olive, CIO]

you have your ids as text fields when inserting the values.  my first
thought would be to remove them.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:05 PM
To: CF-Talk
Subject: Syntax error


Can anyone tell me what is wrong with this insert statement?
Ive been looking at this for about an hour now and cant figure it out

I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.


SQL = "INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place,
Time, Points, AdjPoints, Money) VALUES ( '1', '2', '7', '1', '0', '50',
'125', '5000')"

Data Source = "??"




Thanks,

Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.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: why use 3rd dimensional array??? You dont understand!

[Christopher Olive, CIO]

take something like a body of information with multiple levels of
organization.  for example, when i was working for the DOD, i had an
installation.  this had major commands associated with it.  these macoms had
people assocated with them.  inefficiently, you might index the data so the
installation hashes into the first dimension, the macom the second, and the
person in the third.

i don't think that a nasty tone is necessary for clarification.  i imagine
if you asked your clarification question a bit more politely, you might have
gotten more answers.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 3:55 PM
To: CF-Talk
Subject: why use 3rd dimensional array??? You dont understand!


BAH!  This is what i mean.

What are the PRACTICAL real life uses for 3rd dimensional arrays?

ANALOGY if u still dont understand.

In trig, we learned how to figure out volume using the shell, disc, and i
forget the other one.  Ok, big deal.

however, the practical use of this is to measure the volume of a hill and
figure out how much of it you're gonna chop off so u can biuld a house on it
blah blah blah.

I understand how 3 dimensional arrays work programmatically. but i wanna
know the practical uses of it



-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 2:57 PM
To: CF-Talk
Subject: Re: why use 3rd dimensional array???


Since when was math stuff not a real situation
- Original Message -
From: "Phoeun Pha" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 1:36 PM
Subject: RE: why use 3rd dimensional array???


> well yeah i can see how it can be used for math stuff.  but i mean like a
> real situation
>
>
> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 1:17 PM
> To: CF-Talk
> Subject: Re: why use 3rd dimensional array???
>
>
> to hold 3 dimensional data. sorry.
>
> Simple example. some kind of cubic sample. like say air temperature in a
> room for each specific cubic foot. The index is h,w,l and the value
> corresponds to the appropriate cube in the room.
>
> I can get a better, more practival example if you like.
>
> E
>
> From: Phoeun Pha <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: why use 3rd dimensional array???
> Date: Mon, 05 Feb 2001 12:35:38 -0600
>
> how would one use a third dimensional array?  it's hard for me to
> conceptualize a practical use for it!
>
~~
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: Break in attempts?

[Christopher Olive, CIO]

actually, ran into that error message when i named one of my templated
MemberApplication.cfm.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jon Gage [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 1:37 PM
To: CF-Talk
Subject: Break in attempts?


We've noticed the following error in our logs recurring recently:

"Error","TID=618","02/02/01","22:04:23","24.114.162.188","","Invalid Request
of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM File You have requested a
template with the name APPLICATION.CFM or ONREQUESTEND.CFM. These file names
are reserved by the ColdFusion engine for the specification of application
level settings and therefore cannot be directly requested from a web
client.If you are creating a template which is intended for direct access by
end users you should use a name other than APPLICATION.CFM or
ONREQUESTEND.CFM."

I remember reading about the above applications allowing hackers to change
data sources and such.  Does anybody have any more information?  Or perhaps
some remedies?

Cheers,
Jon
~~
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: CFLocation on any page based on Domain Name

[Christopher Olive, CIO]

you;'d actually be better off handling this through your webserver.  IIS has
a built in redirect mechanism.  if you create your "newsite" as a virtual
server, then go to the properties of "oldsite", you can define "oldsite" as
a redirect to a new url.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Josh R [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 11:28 PM
To: CF-Talk
Subject: CFLocation on any page based on Domain Name


I have two domain names pointing to the same IP address. To make things
easier, I'd like to get everyone on the same domain name BUT much
advertising has been placed with the "old" URL AND they point to many
diferent pages. Is there a way move them over to the other URL no matter
what page they come in to?

For example: If they come to www.oldsite.com/price-quote.cfm I want to move
them over to www.newsite.com/price-quote.cfm

Such as the pseudo code below?

cfif FindNoCase("oldwebsite.com", CGI.Server_Name)>

cflocation url="http://www.newsite.com/#SCRIPT_NAME#?#QUERY_STRING#"
addtoken="YES">

/cfif>


What do I need to make this work? If I place this in our application.cfm, am
I on the right track?

Thanks.
~~
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 problem

[Christopher Olive, CIO]

actually, you WANT a cartesian product for this, since you want every row in
members compared to every row in details.  that means no join.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 3:24 PM
To: CF-Talk
Subject: Re: Query problem



> Will,
> Are you using access? ID is a reserved word, I think. So, number one would
> be to change the name of your field in the table. Also, is ID in members
the
> same as id in fields? If so, you can do something like this:
>
> SELECTm.email, m.id
> FROMmembers m, main_details d
> WHERE(d.body LIKE '%m.watch1%'
> ORd.body LIKE '%m.watch2%'
> ORd.body LIKE '%m.watch3%')
> ANDd.id = m.id
>
> Make sense?

Makes perfect sense, and thanks to Eric too - the only problem is d.id and
m.id are entirely seperate and can't be joined.  I see now that I need to
join the tables - what is the thing to do, however, when there aren't any
"joinable" fields?

Thanks for the help,

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: Question about CFFILE permissions

[Christopher Olive, CIO]

you could implement Advanced Security and create a "sandbox" for each user.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:17 PM
To: CF-Talk
Subject: Question about CFFILE permissions


Good morning people.  I was thinking about Self Serve hosting today when I
got to wondering, how to people who do run serve hosting businesses (aka
Virtualscape, Fusionfx, etc.) prohibit others from using, say CFFILE and
CFDIRECTORY on other User's directories?  That could get very messy when
people are hacking into other people's stuff on that same server, any ideas?


Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535
~~
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: are forms cf collections?

[Christopher Olive, CIO]

the FORM scope is a structure in 4.5.  is this what you're asking?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Duane Douglas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:05 PM
To: CF-Talk
Subject: are forms cf collections?


please let me know

tia
~~
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: RE: Request Scope

[Christopher Olive, CIO]

i tend to user REQUEST variables for things that are "constants" in an
application/page.  for example, DSNs, Title Text, and other things that tend
not to change value over the life of an application.  by making them request
variables, you can still have the "change them in one place" ability
(usually the application.cfm), but you do not have to worry about locking.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Carol Bluestein [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 10:25 AM
To: CF-Talk
Subject: Re:RE: Request Scope


Is any one out there using the request variables extensively?

I'd like to know more about the request scope and how to use it.  I've found
very little in my documentation (4.0.1) and have searched the allaire
knowledge
base with no obvious results (a lot comes up but the titles lead me to
believe
they were not pertinent).  I've heard that using request scope variables can
help limit the "need" for session and/or application variables so that the
necessity of locking is minimized and in some cases eliminated.  I also
admit
that I could have heard this out of context.

Any clarification and information would be appreciated.

Thanks, in advance,
Carol


Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:RE: Request Scope
Author: [EMAIL PROTECTED]
Date:   2/1/01 8:06 PM

> The "Request" scope was available in CF 4.0 wasn't it?

Yup, just tested on our 4.0.1 server and it worked perfectly

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