Re: CFincludes and SQL Queries -SIMPLE QUESTION! (update to last q)

2000-11-18 Thread Michael Thomas

Sorry as I havent been reading into this topic of the list, With that in 
mind why cant you just put the entire query inside the cfinclude file???


From: Michael She [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: CFincludes and SQL Queries -SIMPLE QUESTION! (update to last  q)
Date: Fri, 17 Nov 2000 08:30:03 -0500

If I embed a SQL query inside a CFQUERY my variables don't get processed:

cfquery name="UserDupeCheck" datasource="#Application.Datasource#"
dbtype="ODBC"
  cfinclude 
template="/Includes/SQL/Registration/SelectUserDupeCheck.cfm"
/cfquery


The query is:

Select Username
  From Users
Where Username = '#form.username#'


The variable #form.username# is not being processed.  Is this normal, or am
I doing something wrong?

If I put the whole query inside the CFQuery tag (no include) it works fine.
--
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

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

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

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.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



Dumb Q - Encrypting CFM files

2000-11-18 Thread Michael She

Hello,

I saw some tags in Allaire's Developer Exchange which are encrypted.  How 
do you do that?

Also, are there any other advantages to using an encypted file aside from 
security (ie faster loads?)
-- 
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: file extensions

2000-11-18 Thread Dylan Bromby

i've still got my CF 2.0 floppies :)

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 7:59 PM
To: CF-Talk
Subject: Re: file extensions


This is left over from the ancient past, when what we know and love as CFML
was called DBML, in CF 1.0-1.5.  Thus .dbm extensions, as well as DBQUERY,
DBIF, DBOUTPUT, etc, which may or may not work in more modern versions
of CF, but were the core of the good old days.

DC

- Original Message -
From: "Anuj Gakhar" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 17:09
Subject: file extensions


 can we use .dbm as extension in cold fusion...
 i tested it and it worked.
 why so?
 what is dbm for?
 pl. answer these questions

 jimmy


 __
 Do You Yahoo!?
 Talk to your friends online with Yahoo! Messenger.
 http://im.yahoo.com
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

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


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

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Real Life Math Computations....

2000-11-18 Thread Daniel Kemp

 You were right when you said entertaining, Ive always been
 a fan of game programming  have wanted one day perhaps
 code a small game or something like that. Do you have a
 working example of this online that I can play
 with!?!?!? Please Please Please!!! lmao

Ok, remember it's work in progress, and you'll need a WAP browser, I
suggest http://www.yospace.com for that.

The link is: http://wap.phink.net/minisphere

At the moment the "turns engine" is turned off.  All the creatures
have been getting quite randy over the last week, and my breeding code
isn't working!  They've been chasing potential mates to the edge of
the map, where they seem to be getting stuck in a horrid unconsummated
orgy.

The things you have to sort out as a coder.

When I get the code sorted I'll maybe post a heads up to anyone who's
interested, so people can drop their own creatures in.  Although
there's a hell of a lot of optimisation to do yet.

R'grds
Dan.



This message is intended only for the use of the person(s) ("the intended 
recipient(s)") to whom it is addressed.

It may contain information which is privileged and confidential within the meaning of 
the applicable law. 
If you are not the intended recipient, please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views held by 
Live Information Systems Limited.


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

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



HTTP Referrer

2000-11-18 Thread W Luke

Hi,

How can I get the HTTP referrer URL in CF?  I'd like to do a cflocation
and make the URL the referrer, to take users back to where they were trying
to go once logged in.

Cheers,

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: HTTP Referrer

2000-11-18 Thread John Foulds

CGI.HTTP_REFERER

Note the single "r" in referer.

I find the referer variable flakey and different OS's and Web Servers all a
little different in the way the expose it.

If you run into problems, try javascript instead, ie: stick this at the
bottom of your template after your CF processing:

BODY onLoad="window.location='javascript:history.go(-1)'"

John



- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 8:10 AM
Subject: HTTP Referrer


 Hi,

 How can I get the HTTP referrer URL in CF?  I'd like to do a cflocation
 and make the URL the referrer, to take users back to where they were
trying
 to go once logged in.

 Cheers,

 Will

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

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


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

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



RE: HTTP Referrer

2000-11-18 Thread Rich Wild

Will,

Use the variable CGI.http_referer (ie
cfoutput#cgi.http_referer#/cfoutput )

Remember this won't work if the user typed the address in the URL bar rather
than clicking a link...

Ed Zahurack believes this to a security hole - depends what you are using it
for IMO, go see:

http://forums.allaire.com/devconf/Thread.cfm?Message_ID=186738_#Message186
738

Its also not wise to rely on it - some proxy servers (and webservers?) strip
it out as an option.
Make sure you have error handling in place and you should be fine :)


---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




 -Original Message-
 From: W Luke [mailto:[EMAIL PROTECTED]]
 Sent: 18 November 2000 12:11
 To: CF-Talk
 Subject: HTTP Referrer
 
 
 Hi,
 
 How can I get the HTTP referrer URL in CF?  I'd like to do a 
 cflocation
 and make the URL the referrer, to take users back to where 
 they were trying
 to go once logged in.
 
 Cheers,
 
 Will
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official 
 book at http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: MYOB === DB

2000-11-18 Thread John Foulds

  a client has asked me to do a web version of MYOB

I would advise you to stay very far away from this unless you are very, very
familiar with what you are getting into.

From my perspective, if a things not worth doing well, it's not worth doing.
And doing that well is a job in the neighbourhood of hundreds of thousands
of dollars.

Small accounting packages like Peachtree and SimplyAccounting often provide
ways to export and expose their data to ODBC, but it is a one-way process.
They never handle data coming back into the database, because all of their
logic is written into the application itself, and not into the database.

This means that if you are pushing data into the database, without knowing
exactly what their application logic is, one mistake and everything stops
working.  And not only that, your chances of figuring it out are basically
nil.

John




- Original Message -
From: "Rob Keniger" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 5:06 AM
Subject: Re: MYOB === DB


 on 17/11/00 4:48 PM, avex at [EMAIL PROTECTED] wrote:

  a client has asked me to do a web version of MYOB
 
  to take the data, export it to a database (access or MS SQL) and then
  recreate the functions in cold fusion?
 
  THis seems easy to do?

 I would say that it would *not* be easy to do. Recreating a full-blown,
 extremely mature accounting package is not something to take on lightly.
If
 you press on I would ensure that you get an extremely detailed brief from
 the client and quote the job at what it's worth.

 On the other hand if you just wanted to have a few basic queries available
 then it shouldn't be too difficult.

 --

 Rob Keniger

 big bang solutions

 mailto:[EMAIL PROTECTED]
 http://www.bigbang.net.au


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

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 Referrer

2000-11-18 Thread John Foulds

re: the thread

There are a number of ways around the hack the guy is screaming about (ie.
cookies, checking to see the request was http, and from within it's domain,
etc).

John


- Original Message -
From: "Rich Wild" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 8:30 AM
Subject: RE: HTTP Referrer


 Will,

 Use the variable CGI.http_referer (ie
 cfoutput#cgi.http_referer#/cfoutput )

 Remember this won't work if the user typed the address in the URL bar
rather
 than clicking a link...

 Ed Zahurack believes this to a security hole - depends what you are using
it
 for IMO, go see:


http://forums.allaire.com/devconf/Thread.cfm?Message_ID=186738_#Message186
 738

 Its also not wise to rely on it - some proxy servers (and webservers?)
strip
 it out as an option.
 Make sure you have error handling in place and you should be fine :)


 ---
 Rich Wild
 Senior Web Designer

 ---
 e-mango.com ltd  Tel: 01202 587 400
 Lansdowne Place  Fax: 01202 587 401
 17 Holdenhurst Road
 Bournemouth   Mailto:[EMAIL PROTECTED]
 BH8 8EW, UK  http://www.e-mango.com
 ---
 This message may contain information which is legally
 privileged and/or confidential.  If you are not the
 intended recipient, you are hereby notified that any
 unauthorised disclosure, copying, distribution or use
 of this information is strictly prohibited. Such
 notification notwithstanding, any comments, opinions,
 information or conclusions expressed in this message
 are those of the originator, not of e-mango.com ltd,
 unless otherwise explicitly and independently indicated
 by an authorised representative of e-mango.com ltd.
 ---




  -Original Message-
  From: W Luke [mailto:[EMAIL PROTECTED]]
  Sent: 18 November 2000 12:11
  To: CF-Talk
  Subject: HTTP Referrer
 
 
  Hi,
 
  How can I get the HTTP referrer URL in CF?  I'd like to do a
  cflocation
  and make the URL the referrer, to take users back to where
  they were trying
  to go once logged in.
 
  Cheers,
 
  Will
 
  ~~
  Structure your ColdFusion code with Fusebox. Get the official
  book at http://www.fusionauthority.com/bkinfo.cfm
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

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


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: file extensions

2000-11-18 Thread John Foulds

My 2.0's a CD.

- Original Message -
From: "Dylan Bromby" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 1:19 AM
Subject: RE: file extensions


 i've still got my CF 2.0 floppies :)

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 17, 2000 7:59 PM
 To: CF-Talk
 Subject: Re: file extensions


 This is left over from the ancient past, when what we know and love as
CFML
 was called DBML, in CF 1.0-1.5.  Thus .dbm extensions, as well as
DBQUERY,
 DBIF, DBOUTPUT, etc, which may or may not work in more modern versions
 of CF, but were the core of the good old days.

 DC

 - Original Message -
 From: "Anuj Gakhar" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, November 17, 2000 17:09
 Subject: file extensions


  can we use .dbm as extension in cold fusion...
  i tested it and it worked.
  why so?
  what is dbm for?
  pl. answer these questions
 
  jimmy
 
 
  __
  Do You Yahoo!?
  Talk to your friends online with Yahoo! Messenger.
  http://im.yahoo.com
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 

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

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

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

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

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

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



Re: HTTP Referrer

2000-11-18 Thread W Luke



 Will,

 Use the variable CGI.http_referer (ie
 cfoutput#cgi.http_referer#/cfoutput )

 Remember this won't work if the user typed the address in the URL bar
rather
 than clicking a link...

 Ed Zahurack believes this to a security hole - depends what you are using
it
 for IMO, go see:


http://forums.allaire.com/devconf/Thread.cfm?Message_ID=186738_#Message186
 738

Thanks Rich I'll take a look.  I note that Cflocation also appends the
CFID and CFTOKEN  to the URL once the new location has been loaded, which I
didn't realise it did - unfortunately there doesn't seem a way round it.

 Its also not wise to rely on it - some proxy servers (and webservers?)
strip
 it out as an option.
 Make sure you have error handling in place and you should be fine :)

Will do, cheers for the tip.  It seems to work really well - I had
previously tried the normal Javascript "Onload" function, but ran into
problems.  Fingers crossed this time.

Cheers,

Will
--
Coming soon: http://www.LocalBounty.com
Local Classified Advertising for the UK

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Dumb Q - Encrypting CFM files

2000-11-18 Thread John Foulds

The good news:
cfencrypt.exe is a command line utility in the CFUSION directory.

The bad news:
cfdecrypt.exe is a publicly available decryption utility.


- Original Message -
From: "Michael She" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 4:21 AM
Subject: Dumb Q - Encrypting CFM files


 Hello,

 I saw some tags in Allaire's Developer Exchange which are encrypted.  How
 do you do that?

 Also, are there any other advantages to using an encypted file aside from
 security (ie faster loads?)
 --
 Michael She
 I m a g i n e   C o m m u n i c a t i o n s
 Company E-mail: [EMAIL PROTECTED]
 Personal E-mail: [EMAIL PROTECTED]
 ICQ UIN: #243466
 Personal Homepage: http://www.michaelshe.com (Under Construction)
 Imagine Communications: http://www.imagineer.net
 PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

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

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

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

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



Re: append variable to a variable??

2000-11-18 Thread John Foulds

Doing a simple 500,000 loop, it's actually slower on my NT.  You always pay
for abstraction.

(value+1) = 20 seconds
incrementvalue() = 25 seconds

John


- Original Message -
From: "Michael Thomas" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 5:17 AM
Subject: Re: append variable to a variable??


 Excellent question that I wouldnt mind knowing an answer to myself.
Anyone?


 From: Rob Keniger [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Re: append variable to a variable??
 Date: Fri, 17 Nov 2000 14:31:52 +1000
 
 on 17/11/00 10:19 AM, BORKMAN Lee at [EMAIL PROTECTED] wrote:
 
  
   As with most languages, you only need to use 50% (or even less) of a
 CF's
   functions to do 99% of the stuff that you would ever want to do.
   Coincidentally, using just that 50% makes your code easier to work
with
 for
   other average mortals.
  
   Everybody wins when you stick to basics!!
 
 I myself have wondered about why many seemingly redundant functions
exist.
 An example of this is incrementvalue(). Why not just value + 1? Is it
 faster
 because it just uses a single register increment instead of having to
work
 out a proper addition?
 
 Are the other functions like this there because they increase
performance?
 
 --
 
 Rob Keniger
 
 big bang solutions
 
 mailto:[EMAIL PROTECTED]
 http://www.bigbang.net.au
 
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at
 https://secure.houseoffusion.com
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 Share information about yourself, create your own public profile at
 http://profiles.msn.com.

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

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

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

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



PDF File Creation.

2000-11-18 Thread Arden Weiss


I am entering stage left on a project that, for archive purposes, needs to:

1. Create PDF files from CFM forms displayed onscreen and put them on the 
Web Server,

2. Convert Word DOC files (with imbedded scanned JPG images, spreadsheets, 
etc.) located on the user's local drives, then copy them to the Web Server.

I am looking for advice on what 3rd party apps will to provide all or 
pieces of that functionality with minimal user hassle. Cost is also a 
factor, but not the primary factor.]

I have been using Adobe Acrobat Exchange and Distiller on a local PCs for 
some time in the non-web world.

The tools I looking for now I would want to be web-server resident so each 
user doesn't have to have Exchange or Distiller on his/her PC.

I am aware of:

1. activePDF which is kinda pricey, but should do the job and then some.
2. HTMLDOC which converts true HTM (not cfm) files to PDF files, as I 
understand.
3. ActiveScan that creates scanned images on the Web Server from a scanner 
attached to a local PC.
4. PDF Creator, PDF Express, and PDF Filer that converts Word, Excel, Text 
and RTF files to PDF.
5. PDF Printer Driver that generates PDF files from Windows app w/o using 
Acrobat Exchange.

I have no experience with any of the above, but have or plan to download 
each and play with them.
So, any upfront advice and counsel would be greatly appreciated -- you know 
-- measure twice, cut once.

Am willing to share resultant code with the community when complete. 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: HTTP Referrer

2000-11-18 Thread Judith Taylor

Will,

Relying on the referer to take a user back after loggin in is Not A Good 
Idea(tm). Microsoft's IIS does not send the http_referer when not in a 
secure section of a site (e.g. https://) Here is the microsoft article that 
tells of their reasoning...

http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP

One /excellent/ way around this is to use the Fusebox custom 
tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use any 
other part of Fusebox. It works like a charm in both IE and Netscape. You 
can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's Dev 
Exchange 
(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-AA9700508B94F380method=Full
 
) --watch the word-wrapping

At 12:10 PM 2000-11-18, W Luke wrote:
Hi,

How can I get the HTTP referrer URL in CF?  I'd like to do a cflocation
and make the URL the referrer, to take users back to where they were trying
to go once logged in.

Judith Taylor
Webmaster - http://www.busybobbins.com
ICQ: 67460562

Freelance ColdFusion Developer

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

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



JSP Listserve

2000-11-18 Thread eisensmi

Does anyone know of a JSP ListServe which is similar to this
one for Cold Fusion? 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



Lost installation CD

2000-11-18 Thread Michael Gagnon

This is a multi-part message in MIME format.

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

HELP!!!

Our server crashed and need to reinstall CF
on our server, but I can't find the installation CD.
I still have a copy of our serial number.

Does anyone know where I could download
the Cold Fusion Server 4.0 Professional NT?

Thanks!!!

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2HELP!!!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Our server crashed and need to =
reinstall=20
CF/FONT/DIV
DIVFONT face=3DArial size=3D2on our server, but I can't find the =
installation=20
CD./FONT/DIV
DIVFONT face=3DArial size=3D2I still have a copy of our serial=20
number./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Does anyone know where I could=20
download/FONT/DIV
DIVFONT face=3DArial size=3D2the Cold Fusion Server 4.0 Professional =

NT?/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks!!!/FONT/DIV/BODY/HTML

--=_NextPart_000_0016_01C05155.CC385DD0--

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: PDF File Creation.

2000-11-18 Thread Stephen M Aylor

www.digapp.com

robust server side PDF Forms tools, pdf creation and concatenation as well -
just to throw another into yor potential quiver.   There are many more as
well.

- Original Message -
From: "Arden Weiss" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 5:59 AM
Subject: PDF File Creation.



 I am entering stage left on a project that, for archive purposes, needs
to:

 1. Create PDF files from CFM forms displayed onscreen and put them on the
 Web Server,

 2. Convert Word DOC files (with imbedded scanned JPG images, spreadsheets,
 etc.) located on the user's local drives, then copy them to the Web
Server.

 I am looking for advice on what 3rd party apps will to provide all or
 pieces of that functionality with minimal user hassle. Cost is also a
 factor, but not the primary factor.]

 I have been using Adobe Acrobat Exchange and Distiller on a local PCs for
 some time in the non-web world.

 The tools I looking for now I would want to be web-server resident so each
 user doesn't have to have Exchange or Distiller on his/her PC.

 I am aware of:

 1. activePDF which is kinda pricey, but should do the job and then some.
 2. HTMLDOC which converts true HTM (not cfm) files to PDF files, as I
 understand.
 3. ActiveScan that creates scanned images on the Web Server from a scanner
 attached to a local PC.
 4. PDF Creator, PDF Express, and PDF Filer that converts Word, Excel, Text
 and RTF files to PDF.
 5. PDF Printer Driver that generates PDF files from Windows app w/o using
 Acrobat Exchange.

 I have no experience with any of the above, but have or plan to download
 each and play with them.
 So, any upfront advice and counsel would be greatly appreciated -- you
know
 -- measure twice, cut once.

 Am willing to share resultant code with the community when complete.
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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Unformatted Post?

2000-11-18 Thread lsellers



 Unfortunately, you can't do this with CFHTTP. There are third-party
 components available which will let you specify the exact contents of the
 request header and body. I think you can use CFX_HTTP for this, although I
 haven't tried it:

 http://www.fsc.follett.com/cf/cfx_http/

For the brave, there's also cfx_tcpclient. There are examples of raw http
interactions with the tag.

It doesn't do https though. Hrmm. Aren't the algs for https now public
domain? Anyone? If so then it's about time to add secure sockets to
cfx_tcpclient. :)

--min

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

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



Re: CF Encode - (Howie Hamlin??)

2000-11-18 Thread Howie Hamlin

It was Tom Langer...

He made a shell that wrapped around the cf encoder.

HTH,

Howie

- Original Message -
From: "j p" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 4:28 PM
Subject: CF Encode - (Howie Hamlin??)


 Hey a while back someone had a cfencoder application that helped with
 encoding files...I thought it was Howie.

 Does any one remember this - or have it??

 I want to encrypt cfm files only...
 it is going through and doing all the files.

 I've tried *.cfm but it comes back as "can't find *.cfm"


 Help
 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 Share information about yourself, create your own public profile at
 http://profiles.msn.com.

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

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

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

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



RE: Lost installation CD

2000-11-18 Thread Denise Rolen



Have you tried here? http://commerce.allaire.com/download/index.cfm  the
evals are thereif you enter your s/n it might work. good luck.

 -Original Message-
From:   Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent:   Saturday, November 18, 2000 7:51 AM
To: CF-Talk
Subject:Lost installation CD

This is a multi-part message in MIME format.

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

HELP!!!

Our server crashed and need to reinstall CF
on our server, but I can't find the installation CD.
I still have a copy of our serial number.

Does anyone know where I could download
the Cold Fusion Server 4.0 Professional NT?

Thanks!!!

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2HELP!!!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Our server crashed and need to =
reinstall=20
CF/FONT/DIV
DIVFONT face=3DArial size=3D2on our server, but I can't find the =
installation=20
CD./FONT/DIV
DIVFONT face=3DArial size=3D2I still have a copy of our serial=20
number./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Does anyone know where I could=20
download/FONT/DIV
DIVFONT face=3DArial size=3D2the Cold Fusion Server 4.0 Professional =

NT?/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks!!!/FONT/DIV/BODY/HTML

--=_NextPart_000_0016_01C05155.CC385DD0--

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

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

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

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



RE: file extensions

2000-11-18 Thread Steve Bernard

For some unknown reason I still have my (3) floppies for 1.5, AND backups ;)
Must have been a Y2k thing.

Steve

-Original Message-
From: John Foulds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 8:04 AM
To: CF-Talk
Subject: Re: file extensions


My 2.0's a CD.

- Original Message -
From: "Dylan Bromby" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 1:19 AM
Subject: RE: file extensions


 i've still got my CF 2.0 floppies :)

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 Referrer

2000-11-18 Thread W Luke


 Relying on the referer to take a user back after loggin in is Not A Good
 Idea(tm). Microsoft's IIS does not send the http_referer when not in a
 secure section of a site (e.g. https://) Here is the microsoft article
that
 tells of their reasoning...

 http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP


Thanks for the link.  I'm running O'Reilly WebSite Pro, and have been
testing this for the past few hours with IE, and it does seem to work very
well.

 One /excellent/ way around this is to use the Fusebox custom
 tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use any
 other part of Fusebox. It works like a charm in both IE and Netscape. You
 can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's Dev
 Exchange

(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-A
A9700508B94F380method=Full
 ) --watch the word-wrapping

Fusebox - that name continues to crop up!  I'll take a look.

Thanks,

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: HTTP Referrer

2000-11-18 Thread Jim McAtee

Rather than trying to use http_referer in your login page, try the following.
Depends a little on how you have your security system setup.  If you're
including at the top of every secured page a template/code snippet to detect if
someone is currently logged in, have that bit of code note 'cgi.script_name',
which is the requested template.  When that code redirects to the login page,
pass the template name to the login page and then pass it along as a hidden
field.  If your security scheme has different levels of access be sure to have
it also verify that the user is permitted to access the page in question at the
same time as you verify the username and password.

Jim


-Original Message-
From: W Luke [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, November 18, 2000 10:59 AM
Subject: Re: HTTP Referrer



 Relying on the referer to take a user back after loggin in is Not A Good
 Idea(tm). Microsoft's IIS does not send the http_referer when not in a
 secure section of a site (e.g. https://) Here is the microsoft article
that
 tells of their reasoning...

 http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP


Thanks for the link.  I'm running O'Reilly WebSite Pro, and have been
testing this for the past few hours with IE, and it does seem to work very
well.

 One /excellent/ way around this is to use the Fusebox custom
 tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use any
 other part of Fusebox. It works like a charm in both IE and Netscape. You
 can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's Dev
 Exchange

(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-A
A9700508B94F380method=Full
 ) --watch the word-wrapping

Fusebox - that name continues to crop up!  I'll take a look.

Thanks,

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



Security

2000-11-18 Thread Scott M. Berry

Hello,

One of my friends and coworker posted here about how to secure a web app. He
suggested storing part of the tickcount in a database and as a cookie, and
then verify that the cookie exists and that the numbers are the same.

I was wondering if there was a way to store a cookie that is some sort of
session ID that CF assigns to each session, so all that would have to be
done is a compare between the cookie and the session id.

Any ideas?

Scott M. Berry :-: [Staff Developer]
annex.com, Inc. - http://www.annex.com/


- Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 11:13 AM
Subject: Re: HTTP Referrer


 Rather than trying to use http_referer in your login page, try the
following.
 Depends a little on how you have your security system setup.  If you're
 including at the top of every secured page a template/code snippet to
detect if
 someone is currently logged in, have that bit of code note
'cgi.script_name',
 which is the requested template.  When that code redirects to the login
page,
 pass the template name to the login page and then pass it along as a
hidden
 field.  If your security scheme has different levels of access be sure to
have
 it also verify that the user is permitted to access the page in question
at the
 same time as you verify the username and password.

 Jim


 -Original Message-
 From: W Luke [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Saturday, November 18, 2000 10:59 AM
 Subject: Re: HTTP Referrer


 
  Relying on the referer to take a user back after loggin in is Not A
Good
  Idea(tm). Microsoft's IIS does not send the http_referer when not in a
  secure section of a site (e.g. https://) Here is the microsoft article
 that
  tells of their reasoning...
 
  http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP
 
 
 Thanks for the link.  I'm running O'Reilly WebSite Pro, and have been
 testing this for the past few hours with IE, and it does seem to work
very
 well.
 
  One /excellent/ way around this is to use the Fusebox custom
  tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use
any
  other part of Fusebox. It works like a charm in both IE and Netscape.
You
  can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's
Dev
  Exchange
 

(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-
A
 A9700508B94F380method=Full
  ) --watch the word-wrapping
 
 Fusebox - that name continues to crop up!  I'll take a look.
 
 Thanks,
 
 Will


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

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



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

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



IE: javascript not secure(?!)

2000-11-18 Thread Chris Norloff

I just turned on encryption for our website, and now the Secure Lock indicator 
(padlock) in Internet Explorer goes off sometimes.

According to Microsoft knowledge base article Q179592 this is a feature not a bug, 
though it incorrectly indicates a loss of security -- the page is called with 
javascript, which IE doesn't recognize as being in the secure area of the website.

We use javascript location.href and history.go a lot due to frames on our site.  It 
seems there must be a way to tell IE that a javascript-directed address is secure ...

any ideas?

thanks,
Chris Norloff


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: IE: javascript not secure(?!)

2000-11-18 Thread Jeffry Houser


  Just a shot in the dark, but are you re-directing to absolute
URL's w/ the https on it?  

  It sure would suck to have to change that from relative redirects,
though.  

Chris Norloff wrote:
 
 I just turned on encryption for our website, and now the Secure Lock indicator 
(padlock) in Internet Explorer goes off sometimes.
 
 According to Microsoft knowledge base article Q179592 this is a feature not a bug, 
though it incorrectly indicates a loss of security -- the page is called with 
javascript, which IE doesn't recognize as being in the secure area of the website.
 
 We use javascript location.href and history.go a lot due to frames on our site.  It 
seems there must be a way to tell IE that a javascript-directed address is secure ...
 
 any ideas?
 
 thanks,
 Chris Norloff
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

-- 
Jeff Houser
mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Author of Instant Cold Fusion 4.5 
ISBN: 0-07-213238-8   
Due out 3rd Quarter 2001
--
DotComIt, LLC
Computer Consultant specializing in database driven web data
ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
http://www.farcryfly.com
http://www.mp3.com/FarCryFly
--
Does Everyone Think I'm a Cynical?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: IE: javascript not secure(?!)

2000-11-18 Thread Chris Norloff

No, everything is done with relative URL's  (of course!  :-)

The problem appears to be specific to IE (versions 4, 5  5.5) and using javascript to 
get secure pages.

Beings how this is an acknowledged IR feature/bug, I'm trying to figure out how to do 
things without a complete redesign (removing frames so we don't need javascript to 
call specific pages in the frames).

thanks,
Chris Norloff


-- Original Message --
From: Jeffry Houser [EMAIL PROTECTED]
Date: Sat, 18 Nov 2000 14:47:26 -0500


  Just a shot in the dark, but are you re-directing to absolute
URL's w/ the https on it?  

  It sure would suck to have to change that from relative redirects,
though.  

Chris Norloff wrote:
 
 I just turned on encryption for our website, and now the Secure Lock indicator 
(padlock) in Internet Explorer goes off sometimes.
 
 According to Microsoft knowledge base article Q179592 this is a feature not a bug, 
though it incorrectly indicates a loss of security -- the page is called with 
javascript, which IE doesn't recognize as being in the secure area of the website.
 
 We use javascript location.href and history.go a lot due to frames on our site.  It 
seems there must be a way to tell IE that a javascript-directed address is secure ...
 
 any ideas?
 
 thanks,
 Chris Norloff
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

-- 
Jeff Houser
mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Author of Instant Cold Fusion 4.5 
ISBN: 0-07-213238-8   
Due out 3rd Quarter 2001
--
DotComIt, LLC
Computer Consultant specializing in database driven web data
ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
http://www.farcryfly.com
http://www.mp3.com/FarCryFly
--
Does Everyone Think I'm a Cynical?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Any good update/navigate/archive apps for large CF site?

2000-11-18 Thread Christopher Olive, CIO

i do something similar with this with the "news" of our site. (or at least,
will be.  it's in development.)  just put a "display until" type date field
in the article table.  on your main news page, only list things that have an
display until date greater than today.  have a link to an archive page that
lists them all.

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



-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 10:11 PM
To: CF-Talk
Subject: Any good update/navigate/archive apps for large CF site?


I'm putting together a fairly large CF site for an industry association.
There are currently several thousand pages within an existing site. These
will be moved to the new site. There will also be daily updates with
"breaking news" type stories as well as articles. The site needs to be
managed via a database so that "breaking news" stories are moved off the
site after predetermined times, with articles of longer durational interest
being maintained for longer periods and then moved to archive status.

I'm wondering if anyone has some type of database layout that can be used
for this type site that will allow for easy updating of the site as well as
for easy navigation throughout all. I haven't found any good tools in the
custom tag gallery but before I get too far into development I'd be
interested in anything that anyone else may have done in this type site.

Any suggestions will be appreciated.

Paul Sinclair

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

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

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

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



RE: HTTP Referrer

2000-11-18 Thread Christopher Olive, CIO

actually, use the ADDTOKEN="NO" attribute of CFLOCATION.

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



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 18, 2000 8:03 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Re: HTTP Referrer




 Will,

 Use the variable CGI.http_referer (ie
 cfoutput#cgi.http_referer#/cfoutput )

 Remember this won't work if the user typed the address in the URL bar
rather
 than clicking a link...

 Ed Zahurack believes this to a security hole - depends what you are using
it
 for IMO, go see:


http://forums.allaire.com/devconf/Thread.cfm?Message_ID=186738_#Message186
 738

Thanks Rich I'll take a look.  I note that Cflocation also appends the
CFID and CFTOKEN  to the URL once the new location has been loaded, which I
didn't realise it did - unfortunately there doesn't seem a way round it.

 Its also not wise to rely on it - some proxy servers (and webservers?)
strip
 it out as an option.
 Make sure you have error handling in place and you should be fine :)

Will do, cheers for the tip.  It seems to work really well - I had
previously tried the normal Javascript "Onload" function, but ran into
problems.  Fingers crossed this time.

Cheers,

Will
--
Coming soon: http://www.LocalBounty.com
Local Classified Advertising for the UK

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

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

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

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



clientVar storage/multiple CFAS/single storage db

2000-11-18 Thread pan

In a non-clustered network of machines, each machine
having CFAS running, that uses a single dsn for client var
storage - are CFIDs uniquely assigned for the storage db,
or is each CFAS assigning CFIDs independently of each
other?

In both CDATA and CGLOBAL the field cfid actually
stores the cfid-cftoken values as xx-.

Is there any guarantee, in the above described
network, that each cfid in CDATA and CGLOBAL
actually points back to the originating server?

Is it possible for serverA to have created the same
cfid-cftoken pair as serverB and thus any entries
in the shared clientVar storage db might not uniquely
refer to different clients on the serveral servers?

CDATA is indexed on multiple columns (cfid,app), but
CGLOBALS has two indices ((cfid),(lvist)).

If clientP is using App_1 on ServerA and 
clientQ is using App_1 on ServerB,
how likely is it, if at all, that the entries
in CDATA/CGLOBAL are conflated?

I'm thinking they could be commingled. 
The CFID element seems to be a simply incremented
value each CFAS generates as need. The CFTOKEN
is not a simply incremented value - don't know how they
are generated - this may resolve the potential problem,
but I don't see how the different CFASs could inform
each other which CFTOKENs have been assigned.

???

Pan


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

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



RE: Any good update/navigate/archive apps for large CF site?

2000-11-18 Thread Dick Applebaum

Also add include/active switch in each record... that way you can 
enter articles over time  continue to refine them before they become 
visible to the public.


At 3:25 PM -0500 11/18/00, Christopher Olive, CIO wrote:
i do something similar with this with the "news" of our site. (or at least,
will be.  it's in development.)  just put a "display until" type date field
in the article table.  on your main news page, only list things that have an
display until date greater than today.  have a link to an archive page that
lists them all.

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



-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 10:11 PM
To: CF-Talk
Subject: Any good update/navigate/archive apps for large CF site?


I'm putting together a fairly large CF site for an industry association.
There are currently several thousand pages within an existing site. These
will be moved to the new site. There will also be daily updates with
"breaking news" type stories as well as articles. The site needs to be
managed via a database so that "breaking news" stories are moved off the
site after predetermined times, with articles of longer durational interest
being maintained for longer periods and then moved to archive status.

I'm wondering if anyone has some type of database layout that can be used
for this type site that will allow for easy updating of the site as well as
for easy navigation throughout all. I haven't found any good tools in the
custom tag gallery but before I get too far into development I'd be
interested in anything that anyone else may have done in this type site.

Any suggestions will be appreciated.

Paul Sinclair

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

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

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

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

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

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



RE: ANOTHER CF_GRID question

2000-11-18 Thread Luis

The problem begins when I write more characters in the CFGrid 
and then update the information, could I control the update 
statment on my CFGRID?, Another thing, I want to convert to 
UPPERCASE the information typed on the grid before it was 
updated, that is I want to save UCASE information only, is that 
possible?


On 17 Nov 2000, at 7:31, McCollough, Alan wrote:

 Since you are using MS SQL 7, set up a view for your datasource, and trim
 the view's output to 10 chars.
 
 Alan McCollough
 Web Programmer
 Allaire Certified ColdFusion Developer
 Alaska Native Medical Center
 
  -Original Message-
  From:   Luis [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, November 17, 2000 7:02 AM
  To: CF-Talk
  Subject:ANOTHER  CF_GRID question
  
  How can I truncate the information typed on the grid if my filed has 
  a length of 10 (example)? Now I receive an error, I'm using SQL 7 
  and ColdFusion 4.5 on WinNT 4
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
  http://www.fusionauthority.com/bkinfo.cfm
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
 


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

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



RE: Security

2000-11-18 Thread Steve Bernard

That's CF's, and most products, method of tracking sessions, i.e. tokens as
cookies. It's all in the docs.

Steve

-Original Message-
From: Scott M. Berry [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 18, 2000 2:34 PM
To: CF-Talk
Subject: Security


Hello,

One of my friends and coworker posted here about how to secure a web app. He
suggested storing part of the tickcount in a database and as a cookie, and
then verify that the cookie exists and that the numbers are the same.

I was wondering if there was a way to store a cookie that is some sort of
session ID that CF assigns to each session, so all that would have to be
done is a compare between the cookie and the session id.

Any ideas?

Scott M. Berry :-: [Staff Developer]
annex.com, Inc. - http://www.annex.com/


- Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 11:13 AM
Subject: Re: HTTP Referrer


 Rather than trying to use http_referer in your login page, try the
following.
 Depends a little on how you have your security system setup.  If you're
 including at the top of every secured page a template/code snippet to
detect if
 someone is currently logged in, have that bit of code note
'cgi.script_name',
 which is the requested template.  When that code redirects to the login
page,
 pass the template name to the login page and then pass it along as a
hidden
 field.  If your security scheme has different levels of access be sure to
have
 it also verify that the user is permitted to access the page in question
at the
 same time as you verify the username and password.

 Jim


 -Original Message-
 From: W Luke [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Saturday, November 18, 2000 10:59 AM
 Subject: Re: HTTP Referrer


 
  Relying on the referer to take a user back after loggin in is Not A
Good
  Idea(tm). Microsoft's IIS does not send the http_referer when not in a
  secure section of a site (e.g. https://) Here is the microsoft article
 that
  tells of their reasoning...
 
  http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP
 
 
 Thanks for the link.  I'm running O'Reilly WebSite Pro, and have been
 testing this for the past few hours with IE, and it does seem to work
very
 well.
 
  One /excellent/ way around this is to use the Fusebox custom
  tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use
any
  other part of Fusebox. It works like a charm in both IE and Netscape.
You
  can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's
Dev
  Exchange
 

(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-
A
 A9700508B94F380method=Full
  ) --watch the word-wrapping
 
 Fusebox - that name continues to crop up!  I'll take a look.
 
 Thanks,
 
 Will


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

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



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

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: file extensions

2000-11-18 Thread Adrian Cesana

They seem to work but a few quirks , I also copied CFML.EXE to DBML.EXE so I
didnt have to change any code long ago when converting to 2.0.  I still have
a couple of templates laying around that function this way, although they
are not accessible by the outside world anymore

Feeling older now.

-Adrian


-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]

This is left over from the ancient past, when what we know and love as CFML
was called DBML, in CF 1.0-1.5.  Thus .dbm extensions, as well as DBQUERY,
DBIF, DBOUTPUT, etc, which may or may not work in more modern versions
of CF, but were the core of the good old days.

DC

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

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



Rotate Tasks

2000-11-18 Thread Gordon Burns

I have a table of users which varies between 5 and 10 individuals.

I have to allocate events on a rotational basis (not random). 

What is the best way to tackle this.

Thanks

Gordon
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Security

2000-11-18 Thread Scott M. Berry

Have you ever read the docs? Not very descriptive.

So, one could set a session cookie with a value of the cftoken and cfid and
that would be individual throughout the server and application? And it
wouldn't be easily obtainable by anyone else?

Scott M. Berry :-: [Staff Developer]
annex.com, Inc. - http://www.annex.com/

- Original Message -
From: "Steve Bernard" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 3:13 PM
Subject: RE: Security


 That's CF's, and most products, method of tracking sessions, i.e. tokens
as
 cookies. It's all in the docs.

 Steve

 -Original Message-
 From: Scott M. Berry [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, November 18, 2000 2:34 PM
 To: CF-Talk
 Subject: Security


 Hello,

 One of my friends and coworker posted here about how to secure a web app.
He
 suggested storing part of the tickcount in a database and as a cookie, and
 then verify that the cookie exists and that the numbers are the same.

 I was wondering if there was a way to store a cookie that is some sort of
 session ID that CF assigns to each session, so all that would have to be
 done is a compare between the cookie and the session id.

 Any ideas?

 Scott M. Berry :-: [Staff Developer]
 annex.com, Inc. - http://www.annex.com/


 - Original Message -
 From: "Jim McAtee" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Saturday, November 18, 2000 11:13 AM
 Subject: Re: HTTP Referrer


  Rather than trying to use http_referer in your login page, try the
 following.
  Depends a little on how you have your security system setup.  If you're
  including at the top of every secured page a template/code snippet to
 detect if
  someone is currently logged in, have that bit of code note
 'cgi.script_name',
  which is the requested template.  When that code redirects to the login
 page,
  pass the template name to the login page and then pass it along as a
 hidden
  field.  If your security scheme has different levels of access be sure
to
 have
  it also verify that the user is permitted to access the page in question
 at the
  same time as you verify the username and password.
 
  Jim
 
 
  -Original Message-
  From: W Luke [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
  Date: Saturday, November 18, 2000 10:59 AM
  Subject: Re: HTTP Referrer
 
 
  
   Relying on the referer to take a user back after loggin in is Not A
 Good
   Idea(tm). Microsoft's IIS does not send the http_referer when not in
a
   secure section of a site (e.g. https://) Here is the microsoft
article
  that
   tells of their reasoning...
  
   http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP
  
  
  Thanks for the link.  I'm running O'Reilly WebSite Pro, and have been
  testing this for the past few hours with IE, and it does seem to work
 very
  well.
  
   One /excellent/ way around this is to use the Fusebox custom
   tag  CF_ReturnFuseAction by Steve Nelson. You don't even need to use
 any
   other part of Fusebox. It works like a charm in both IE and Netscape.
 You
   can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's
 Dev
   Exchange
  
 

(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4-
 A
  A9700508B94F380method=Full
   ) --watch the word-wrapping
  
  Fusebox - that name continues to crop up!  I'll take a look.
  
  Thanks,
  
  Will
 
 
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 


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

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

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

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



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

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



Re: scaleability of cfoutput maxrows=x

2000-11-18 Thread Peter Theobald

Unfortunately both of you completely missed his point.

He has a very large recordset of 125,000 records. They are all valid items in his 
inventory. He wants to provide a page for people to browse page by page through this 
inventory 25 items at a time.

He knows how to use:
CFOUTPUT  maxrows=25 startrow=#x#

but this standard way of paging results will cause the server to execute a large query 
and send the entire 125,000 records across the network from the database server to the 
CF server, use 25 records and throw away the rest.

The inventory is in constant flux, so he doesn't want to cache the query to make it 
more efficient.

So his question is: Is there a way in SQL or CF to request ONLY a certain section of 
rows from the result set just by referring to their position in the result set (ie: 
there are no distinguishing characteristics like "category" that will split his 
results into 25 item groups)?

Unfortunately I don't have the answer, but you may find it someone in "SQL cursor 
processing". Depending on your database type you should be able to write an SQL 
statement or a stored procedure that uses a "cursor" pointing into a recordset to have 
a fine level of control over which records to return.

Anyone out there have some experience with this?

At 09:52 PM 11/17/00 -0500, Jon Hall wrote:
Seems to me that if this small subset of records has a unique identifier
that you could just limit the query using a standard WHERE statement. Just
adding a field to the db would be the easiest solution to only pulling the
set of records you need.

I think Shawn answered your question though and you didn't see it.
Use the Startrow statement in your cfquery, then pass a variable called
'page' that is incremented by 1 each time you view the next page or
subtracted by 1 when you go back a page.
This formula might get you on the right track.

page x maxrecordsperpage + 1 will always give you the Startrow variable for
your cfquery statement.

If your recordset is a static one that does not change much and you expect
high enough traffic to justify a little memory usage.You might want to think
about caching the entire query until something is changed.

jon

- Original Message -
From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
Newsgroups: cf-talk
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 6:10 PM
Subject: Re: scaleability of cfoutput maxrows=x


 This is what I'm trying to get away from. This is just outputting a subset
 of my entire recordset.

 If I've got a query that returns 125,000 records and only display 25 of
 them, it's a waste of the servers resources.

 Michael

 "Shawn McGehee" [EMAIL PROTECTED] wrote in message
 015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
  cfoutput query="myquery" startrow="26" maxrows="25"
  blah blah blah
  ...
  /cfoutput
 
  --Shawn McGehee
 
  - Original Message -
  From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Friday, November 17, 2000 2:16 PM
  Subject: scaleability of cfoutput maxrows=x
 
 
   I'm working on an inventory management system for a small subset of
out
   product database (only about 3k records compared to about 125k
records).
   When returning the recordset, I want to break it up into bite sized
  chunks.
   Only problem is, using cfoutput query="myQuery" maxrows=25, the
query
 is
   still returning about 3k records and only displaying 25. If this thing
  ever
   gets to the point where I need to keep track of the entire product
list
   (125k records), this is going to bog down things.
  
   Is there a way in SQL to set a start row for a query? I know I can use
  'set
   rowcount 25' to only get 25 records, but I then need to start again at
 row
   26.
  
   Am I looking in the wrong place? Is there a different way of getting x
   records and then next x records on the SQL side?
  
   Oh, and I can't persist the data in a array of structures or wddx
packet
   because it is inventory that changes quickly and needs to be accurate
on
  the
   execution of the query.
  
   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
 
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 

What's running on my machine

2000-11-18 Thread Brian L. Wolfsohn

IS it possible to have a .cfm template return the names of all applications 
created with cfapplication currently running on a given machine ??





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: JSP Listserve

2000-11-18 Thread Michael Dinowitz

You mean something like [EMAIL PROTECTED]? or
[EMAIL PROTECTED]? Both are in the mailing list section on the
site.

 Does anyone know of a JSP ListServe which is similar to this
 one for Cold Fusion? 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: scaleability of cfoutput maxrows=x

2000-11-18 Thread Peter Theobald

In re-reading what I wrote, I am thinking that the requirements here may be 
unrealistic. 
How dynamic can the inventory be for a user reading through 125,000 items by 25 at a 
time?
I think in practical use nobody is going to read through all 125,000 items by browsing 
through 5,000 pages of 25 items each page by page. They will read a few pages and go 
back to make a more selective search.
You can easily solve the problem, then, by using one cached query for an unfiltered 
search that caches for 5 - 20 minutes.
When a user issues a search with criteria don't cache the results for the most up to 
date inventory.

Some systems would even report back a message "This query returned too many results 
(125,000) please make your selection more specific and try again."

At 06:34 PM 11/18/00 -0500, Peter Theobald wrote:
Unfortunately both of you completely missed his point.

He has a very large recordset of 125,000 records. They are all valid items in his 
inventory. He wants to provide a page for people to browse page by page through this 
inventory 25 items at a time.

He knows how to use:
CFOUTPUT  maxrows=25 startrow=#x#

but this standard way of paging results will cause the server to execute a large 
query and send the entire 125,000 records across the network from the database server 
to the CF server, use 25 records and throw away the rest.

The inventory is in constant flux, so he doesn't want to cache the query to make it 
more efficient.

So his question is: Is there a way in SQL or CF to request ONLY a certain section of 
rows from the result set just by referring to their position in the result set (ie: 
there are no distinguishing characteristics like "category" that will split his 
results into 25 item groups)?

Unfortunately I don't have the answer, but you may find it someone in "SQL cursor 
processing". Depending on your database type you should be able to write an SQL 
statement or a stored procedure that uses a "cursor" pointing into a recordset to 
have a fine level of control over which records to return.

Anyone out there have some experience with this?

At 09:52 PM 11/17/00 -0500, Jon Hall wrote:
Seems to me that if this small subset of records has a unique identifier
that you could just limit the query using a standard WHERE statement. Just
adding a field to the db would be the easiest solution to only pulling the
set of records you need.

I think Shawn answered your question though and you didn't see it.
Use the Startrow statement in your cfquery, then pass a variable called
'page' that is incremented by 1 each time you view the next page or
subtracted by 1 when you go back a page.
This formula might get you on the right track.

page x maxrecordsperpage + 1 will always give you the Startrow variable for
your cfquery statement.

If your recordset is a static one that does not change much and you expect
high enough traffic to justify a little memory usage.You might want to think
about caching the entire query until something is changed.

jon

- Original Message -
From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
Newsgroups: cf-talk
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 6:10 PM
Subject: Re: scaleability of cfoutput maxrows=x


 This is what I'm trying to get away from. This is just outputting a subset
 of my entire recordset.

 If I've got a query that returns 125,000 records and only display 25 of
 them, it's a waste of the servers resources.

 Michael

 "Shawn McGehee" [EMAIL PROTECTED] wrote in message
 015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
  cfoutput query="myquery" startrow="26" maxrows="25"
  blah blah blah
  ...
  /cfoutput
 
  --Shawn McGehee
 
  - Original Message -
  From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Friday, November 17, 2000 2:16 PM
  Subject: scaleability of cfoutput maxrows=x
 
 
   I'm working on an inventory management system for a small subset of
out
   product database (only about 3k records compared to about 125k
records).
   When returning the recordset, I want to break it up into bite sized
  chunks.
   Only problem is, using cfoutput query="myQuery" maxrows=25, the
query
 is
   still returning about 3k records and only displaying 25. If this thing
  ever
   gets to the point where I need to keep track of the entire product
list
   (125k records), this is going to bog down things.
  
   Is there a way in SQL to set a start row for a query? I know I can use
  'set
   rowcount 25' to only get 25 records, but I then need to start again at
 row
   26.
  
   Am I looking in the wrong place? Is there a different way of getting x
   records and then next x records on the SQL side?
  
   Oh, and I can't persist the data in a array of structures or wddx
packet
   because it is inventory that changes quickly and needs to be accurate
on
  the
   execution of the query.
  
   Michael
  
  
   

CF HOST for XXX content

2000-11-18 Thread Martin S

Anybody know of CF HOSTING SITES that allow XXX content?  If so a list of a 
them would be great so I can compare them...also any personal 
recommendations would be great.

More the meria!!



From: "Brian L. Wolfsohn" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: What's running on my machine
Date: Sat, 18 Nov 2000 18:44:27 -0500

IS it possible to have a .cfm template return the names of all applications
created with cfapplication currently running on a given machine ??





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

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

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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



Re: CF HOST for XXX content

2000-11-18 Thread Michael Dinowitz

I know people who've worked security on adult sites but don't know where
they host. I may know of one, but I'd better ask them first.


 Anybody know of CF HOSTING SITES that allow XXX content?  If so a list of
a
 them would be great so I can compare them...also any personal
 recommendations would be great.

 More the meria!!



 From: "Brian L. Wolfsohn" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: What's running on my machine
 Date: Sat, 18 Nov 2000 18:44:27 -0500
 
 IS it possible to have a .cfm template return the names of all
applications
 created with cfapplication currently running on a given machine ??
 
 
 
 
 
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 Share information about yourself, create your own public profile at
 http://profiles.msn.com.

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

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


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

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



Re: CF HOST for XXX content

2000-11-18 Thread Angel Stewart

Do you need a few people to test the site before it goes live?
^_^

-Gel

- Original Message -
From: Martin S [EMAIL PROTECTED]


 Anybody know of CF HOSTING SITES that allow XXX content?  If so a list of
a
 them would be great so I can compare them...also any personal
 recommendations would be great.

 More the meria!!


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

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



Re: CF HOST for XXX content

2000-11-18 Thread netman

You can send them my way.  We are new to the scene, but veterans in Cold
Fusion and web hosting.  We offer, no space restrictions or data transfer
restrictions.  We also have Real Server access available as well as SQL
server.  The renovations to our site (www.atswebnet.com) should be done by
tomorrow if you would like to check us out and send some business if you
want.  Any way to whole purpose of this message was to let you know we have
no content restrictions.

Let me know if I can answer any questions,
Robert Filipovich
ATSWebNet

- Original Message -
From: "Michael Dinowitz" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, November 18, 2000 9:15 PM
Subject: Re: CF HOST for XXX content


 I know people who've worked security on adult sites but don't know where
 they host. I may know of one, but I'd better ask them first.


  Anybody know of CF HOSTING SITES that allow XXX content?  If so a list
of
 a
  them would be great so I can compare them...also any personal
  recommendations would be great.
 
  More the meria!!
 
 
 
  From: "Brian L. Wolfsohn" [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Subject: What's running on my machine
  Date: Sat, 18 Nov 2000 18:44:27 -0500
  
  IS it possible to have a .cfm template return the names of all
 applications
  created with cfapplication currently running on a given machine ??
  
  
  
  
  
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
  http://www.fusionauthority.com/bkinfo.cfm
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
 
_
  Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
 
  Share information about yourself, create your own public profile at
  http://profiles.msn.com.
 
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 

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

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Allaire Forums and Frames

2000-11-18 Thread David Shadovitz

I'm guessing that the topFrame frame doesn't know about the other frame,
so you'd have to traverse the object model:
   target="top.Contents"?
-David

On Fri, 17 Nov 2000 13:58:27 -0500 "Rosa, Issac" [EMAIL PROTECTED]
writes:
 I have a page that is loading Forums in a frameset (topFrame and 
 Contents).
 When I click a link on the topnav.htm which is the top frame, 
 instead of
 populating the contents frame, it spawns a new page.  Anyone have 
 any
 solutions or suggestions?
 
 In topnav.htm, I have the links as follows:
 a href="http://www.currentanalysis.com/partners/att/eventsmain.cfm"
 onMouseOut="MM_swapImgRestore()"
 onMouseOver="MM_swapImage('Image12','','images/navbars/n_it_1.gif',1)"
 target="contents"

GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: CF HOST for XXX content

2000-11-18 Thread John Bowering

Interland allows anything that's not illegal, only problem is, their servers
aren't secure.  Anyone can view/take your files, get your DSN info,
etc.. but only if they have an account on the same server as you.

I'm with Gel...need testers?




-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 18, 2000 9:34 PM
To: CF-Talk
Subject: Re: CF HOST for XXX content


Do you need a few people to test the site before it goes live?
^_^

-Gel

- Original Message -
From: Martin S [EMAIL PROTECTED]


 Anybody know of CF HOSTING SITES that allow XXX content?  If so a list of
a
 them would be great so I can compare them...also any personal
 recommendations would be great.

 More the meria!!


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

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

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

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



Re: clientVar storage/multiple CFAS/single storage db

2000-11-18 Thread paul smith

Looks like they're assigning CFIDs independently.
I believe CFAS keeps track of the last CFID in the
registry.

best,  paul


At 01:19 PM 11/18/00 -0800, you wrote:
In a non-clustered network of machines, each machine
having CFAS running, that uses a single dsn for client var
storage - are CFIDs uniquely assigned for the storage db,
or is each CFAS assigning CFIDs independently of each
other?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: scaleability of cfoutput maxrows=x

2000-11-18 Thread Paul Mone

Maybe you could do this?

SELECT TOP 25 *
FROM TABLE
WHERE IDField NOT IN (#List_Of_IDs_Viewed_Already#)
ORDER BY SomeField

You could keep track of all the ids you've viewed already and store them in
a hidden form field?

Hmmm.  At the end you'd have a list with 124,975 IDs in it.  I guess that
sucks.




-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 18, 2000 3:35 PM
To: CF-Talk
Subject: Re: scaleability of cfoutput maxrows=x


Unfortunately both of you completely missed his point.

He has a very large recordset of 125,000 records. They are all valid items
in his inventory. He wants to provide a page for people to browse page by
page through this inventory 25 items at a time.

He knows how to use:
CFOUTPUT  maxrows=25 startrow=#x#

but this standard way of paging results will cause the server to execute a
large query and send the entire 125,000 records across the network from the
database server to the CF server, use 25 records and throw away the rest.

The inventory is in constant flux, so he doesn't want to cache the query to
make it more efficient.

So his question is: Is there a way in SQL or CF to request ONLY a certain
section of rows from the result set just by referring to their position in
the result set (ie: there are no distinguishing characteristics like
"category" that will split his results into 25 item groups)?

Unfortunately I don't have the answer, but you may find it someone in "SQL
cursor processing". Depending on your database type you should be able to
write an SQL statement or a stored procedure that uses a "cursor" pointing
into a recordset to have a fine level of control over which records to
return.

Anyone out there have some experience with this?

At 09:52 PM 11/17/00 -0500, Jon Hall wrote:
Seems to me that if this small subset of records has a unique identifier
that you could just limit the query using a standard WHERE statement. Just
adding a field to the db would be the easiest solution to only pulling the
set of records you need.

I think Shawn answered your question though and you didn't see it.
Use the Startrow statement in your cfquery, then pass a variable called
'page' that is incremented by 1 each time you view the next page or
subtracted by 1 when you go back a page.
This formula might get you on the right track.

page x maxrecordsperpage + 1 will always give you the Startrow variable for
your cfquery statement.

If your recordset is a static one that does not change much and you expect
high enough traffic to justify a little memory usage.You might want to
think
about caching the entire query until something is changed.

jon

- Original Message -
From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
Newsgroups: cf-talk
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 17, 2000 6:10 PM
Subject: Re: scaleability of cfoutput maxrows=x


 This is what I'm trying to get away from. This is just outputting a
subset
 of my entire recordset.

 If I've got a query that returns 125,000 records and only display 25 of
 them, it's a waste of the servers resources.

 Michael

 "Shawn McGehee" [EMAIL PROTECTED] wrote in message
 015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
  cfoutput query="myquery" startrow="26" maxrows="25"
  blah blah blah
  ...
  /cfoutput
 
  --Shawn McGehee
 
  - Original Message -
  From: "[BOXoFUSES] Michael Slatoff" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Friday, November 17, 2000 2:16 PM
  Subject: scaleability of cfoutput maxrows=x
 
 
   I'm working on an inventory management system for a small subset of
out
   product database (only about 3k records compared to about 125k
records).
   When returning the recordset, I want to break it up into bite sized
  chunks.
   Only problem is, using cfoutput query="myQuery" maxrows=25, the
query
 is
   still returning about 3k records and only displaying 25. If this
thing
  ever
   gets to the point where I need to keep track of the entire product
list
   (125k records), this is going to bog down things.
  
   Is there a way in SQL to set a start row for a query? I know I can
use
  'set
   rowcount 25' to only get 25 records, but I then need to start again
at
 row
   26.
  
   Am I looking in the wrong place? Is there a different way of getting
x
   records and then next x records on the SQL side?
  
   Oh, and I can't persist the data in a array of structures or wddx
packet
   because it is inventory that changes quickly and needs to be accurate
on
  the
   execution of the query.
  
   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
 
  ~~
  Structure your 

RE: What's running on my machine

2000-11-18 Thread Paul Mone

You could make a Server scoped List that held the names.  You'd have to add
code to each application.cfm that held the cfapplication tag to add the
application's name to the list if it didn't already exist in the list.

-Original Message-
From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 18, 2000 3:44 PM
To: CF-Talk
Subject: What's running on my machine


IS it possible to have a .cfm template return the names of all applications
created with cfapplication currently running on a given machine ??





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

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

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

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



Aolserver and scripting language anyone used?

2000-11-18 Thread Robert Everland III

I was playing around on the web and came upon AOLserver, anyone use it.
It's obviously very scalable considering what it's running, I was curious as
to how the language is if it's any good. Could be a nice alternative to
having to code in ASP for a free site. Plus would have plenty of high
traffic sites to show them it's stable, just a thought though I am an aol
hater don't get me wrong. But between AOL and Microsoft is there really a
winner.


Bob Everland

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

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