RE: Extra records in CSV file generation

2000-10-17 Thread Rich Wild

 Well, have you checked there are no empty records in the db at all?
 
 Paul
 
 PS I assume you have, but it's only polite to ask!


Thanks Paul, but yeah - I have :D

---
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: Paul Johnston [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 6:17 PM
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation
 
 
 Well, have you checked there are no empty records in the db at all?
 
 Paul
 
 PS I assume you have, but it's only polite to ask!
 
  -Original Message-
  From: Rich Wild [mailto:[EMAIL PROTECTED]]
  Sent: 16 October 2000 17:11
  To: CF-Talk
  Subject: RE: Extra records in CSV file generation
 
 
   Why not wrap it in a tag (see tag gallery) like
  
   cf_stripwhitespace or cf_lesswhitespace (see below)
 
  Unfortunately that didn't help either..  :(
 
  I think the problem may lie elsewhere...
 
  thanks for the help though.
 
 
  ---
  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: Paul Johnston [mailto:[EMAIL PROTECTED]]
   Sent: Monday, October 16, 2000 5:05 PM
   To: CF-Talk
   Subject: RE: Extra records in CSV file generation
  
  
   Why not wrap it in a tag (see tag gallery) like
  
   cf_stripwhitespace or cf_lesswhitespace (see below)
  
   They take out all whitespace from a cf document after it's
   been processed.
   It may sort it out, it may not.
  
   Paul
  
   PS cf_lesswhitepace from
   http://www.bjork.net/taggallery/index.htm is my
   personal favourite.
  
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2000 16:43
To: CF-Talk
Subject: RE: Extra records in CSV file generation
   
   
 Maybe wrap the entire thing in cfsetting
 enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic]
   
Hi Aaron,
   
Unfortunately that didn't work either. h
   
I even tried putting the whole code on one line. Difficult
   to read in
studio, and didn't work either!
   
---
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 

Re: CF-Talk V1 #63

2000-10-17 Thread Peter Theobald

Ask Michael Dinowitz permission to create a searchable archive of the list and make it 
available to the members.

At 09:53 PM 10/16/00 -0700, Joseph Thompson wrote:
A good idea, but isn't this list data "protected"?



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFOBJECT Sessions

2000-10-17 Thread DeVoil, Nick

Thanks for the advice Dave.

In the end I did get it to work using the code that I posted -
not sure what it was I did that stopped it working before.

Fortunately I don't have to worry too much about scalability
here as this is not a web site but effectively a single-user
application :o)

Thanks

Nick

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 2:15 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: CFOBJECT  Sessions


 I'm using a COM object to parse an XML doc:
 
   cfobject action="CREATE" class="Microsoft.XMLDom" type="COM"
 name="xmlDoc"
 
 That works fine as long as I only have one page.
 
 But once I've loaded the document, I want to keep it in memory
 across pages. I put it in a session variable:
 
   Session.xmlDoc = xmlDoc;
 
 and in the next page, when I do
 
   cfif isDefined("Session.xmlDoc") EQ "true"
 
 I get the right answer. BUT, I can't access any of the 
 object's properties.
 
   Error resolving parameter XMLDOC.SAVE 
   The object SAVE is not present in the scope named XMLDOC
 
 Is there any way round this?

I haven't tried using that object in a persistent memory scope, but I've
done that with other objects, just for testing. I've been able to do it by
creating the object in the memory scope at the beginning:

cfobject name="Session.xmlDoc" ...

I should warn you, however, that it's not a good idea to do this, from a
scalability perspective. You want to release COM objects as quickly as
possible, generally, and might run into some wacky problems if you try to
persist them.

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


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Paul Johnston

How about sending us the code again with a sample output?

Paul

 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 17 October 2000 08:28
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation


  Well, have you checked there are no empty records in the db at all?
 
  Paul
 
  PS I assume you have, but it's only polite to ask!


 Thanks Paul, but yeah - I have :D

 ---
 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: Paul Johnston [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 16, 2000 6:17 PM
  To: CF-Talk
  Subject: RE: Extra records in CSV file generation
 
 
  Well, have you checked there are no empty records in the db at all?
 
  Paul
 
  PS I assume you have, but it's only polite to ask!
 
   -Original Message-
   From: Rich Wild [mailto:[EMAIL PROTECTED]]
   Sent: 16 October 2000 17:11
   To: CF-Talk
   Subject: RE: Extra records in CSV file generation
  
  
Why not wrap it in a tag (see tag gallery) like
   
cf_stripwhitespace or cf_lesswhitespace (see below)
  
   Unfortunately that didn't help either..  :(
  
   I think the problem may lie elsewhere...
  
   thanks for the help though.
  
  
   ---
   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: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 5:05 PM
To: CF-Talk
Subject: RE: Extra records in CSV file generation
   
   
Why not wrap it in a tag (see tag gallery) like
   
cf_stripwhitespace or cf_lesswhitespace (see below)
   
They take out all whitespace from a cf document after it's
been processed.
It may sort it out, it may not.
   
Paul
   
PS cf_lesswhitepace from
http://www.bjork.net/taggallery/index.htm is my
personal favourite.
   
 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 16 October 2000 16:43
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation


  Maybe wrap the entire thing in cfsetting
  enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic]

 Hi Aaron,

 Unfortunately that didn't work either. h

 I even tried putting the whole code on one line. Difficult
to read in
 studio, and didn't work either!

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

Client Storage

2000-10-17 Thread Bill Killillay

If the default client storage is set to registry and in the application.cfm
or application tag you enable client management and then enable
setclientcookies to yes, will client info be stored in the cookies, or will
it go with the setting in CFAS and store that info in the registry?

Bill

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Rich Wild

Paul,

I tried repositioning the cfsetting tag as you said - but am still getting
the extra fields...

Here is the code - all on one line.

CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=mangobase_#dateformat(now(), "mmdd")#_#timeformat(now(),
"HHmm")#.csv"CFCONTENT TYPE="application/unknown"cfoutput"CONTACT
ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputcfsetting
enablecfoutputonly="yes"CFOUTPUT
QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_data#"#chr
(13)#/CFOUTPUTcfsetting enablecfoutputonly="no"

Again, it doesn't matter what records are pulled out of the db, it could be
none, one or 27000 + etc - always 7 blank records at the end

This says to me that its not data in the db - I've looked for that anyway.

The fact that I've tried Cfsetting and cf_lesswhitespace and putting the
code all on one line says to me that its not spurious carrige returns or
code formatting

I've tried it using OLEDB and ODBC - same result...

I've tried putting the whole SQL statement on 1 line - same result... (I'm
getting desperate now you can tell!)

ay ay ay...

I mean, its only a cosmetic problem, right? Or is it? Perhaps those 7
records could kill the customer's queries on that data or affect his/her
insertion into their accounting etc...

must...findanswer *gasp*

---
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: Paul Johnston [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 12:00 PM
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation
 
 
 Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place 
 I've put it:
 
 Your code:
 
  CFHEADER NAME="Content-Disposition" VALUE="inline;
  filename=#dateformat(now(), "mmdd")#_#timeformat(now(), 
 "HHmm")#.csv"
  CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET
  NAME","SET
  LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT
  QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
  data#"#chr
  (13)#/CFOUTPUT
 
 
 My code (put it all into one line):
 
 CFHEADER NAME="Content-Disposition"
 VALUE="inline;filename=#dateformat(now(), 
 "mmdd")#_#timeformat(now(),
 "HHmm")#.csv"
 CFCONTENT TYPE="application/unknown"cfoutput"CONTACT 
 ID","SET NAME","SET
 LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES"
 CFOUTPUT 
 QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
 data#"#chr(13)#/CFOUTPUT
 
 I ran this with some of my data, and it worked fine without 
 any extra spaces
 (also check there are no extra lines at all by putting it all 
 into one line!
 
 I hope this works!
 
 Paul
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Paul Johnston

Well I'm stuck!  Anyone else care to try?

Paul

PS Maybe you could create a variable and write that out to a file and strip
out any blank lines?  Then you could locate the user to a page that
downloads the file as a csv...  Dunno!  It's a solution, but a bit scrappy,
but it should work!

 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 17 October 2000 12:27
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation


 Paul,

 I tried repositioning the cfsetting tag as you said - but am still getting
 the extra fields...

 Here is the code - all on one line.

 CFHEADER NAME="Content-Disposition" VALUE="inline;
 filename=mangobase_#dateformat(now(), "mmdd")#_#timeformat(now(),
 "HHmm")#.csv"CFCONTENT TYPE="application/unknown"cfoutput"CONTACT
 ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputcfsetting
 enablecfoutputonly="yes"CFOUTPUT
 QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
 data#"#chr
 (13)#/CFOUTPUTcfsetting enablecfoutputonly="no"

 Again, it doesn't matter what records are pulled out of the db,
 it could be
 none, one or 27000 + etc - always 7 blank records at the end

 This says to me that its not data in the db - I've looked for that anyway.

 The fact that I've tried Cfsetting and cf_lesswhitespace and putting the
 code all on one line says to me that its not spurious carrige returns or
 code formatting

 I've tried it using OLEDB and ODBC - same result...

 I've tried putting the whole SQL statement on 1 line - same result... (I'm
 getting desperate now you can tell!)

 ay ay ay...

 I mean, its only a cosmetic problem, right? Or is it? Perhaps those 7
 records could kill the customer's queries on that data or affect his/her
 insertion into their accounting etc...

 must...findanswer *gasp*

 ---
 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: Paul Johnston [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, October 17, 2000 12:00 PM
  To: CF-Talk
  Subject: RE: Extra records in CSV file generation
 
 
  Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place
  I've put it:
 
  Your code:
 
   CFHEADER NAME="Content-Disposition" VALUE="inline;
   filename=#dateformat(now(), "mmdd")#_#timeformat(now(),
  "HHmm")#.csv"
   CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET
   NAME","SET
   LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT
   QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
   data#"#chr
   (13)#/CFOUTPUT
  
 
  My code (put it all into one line):
 
  CFHEADER NAME="Content-Disposition"
  VALUE="inline;filename=#dateformat(now(),
  "mmdd")#_#timeformat(now(),
  "HHmm")#.csv"
  CFCONTENT TYPE="application/unknown"cfoutput"CONTACT
  ID","SET NAME","SET
  LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES"
  CFOUTPUT
  QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
  data#"#chr(13)#/CFOUTPUT
 
  I ran this with some of my data, and it worked fine without
  any extra spaces
  (also check there are no extra lines at all by putting it all
  into one line!
 
  I hope this works!
 
  Paul
 
 
  --
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

RE: Jsstringformat

2000-10-17 Thread Courtney Payne

cfset safeString = Replace(evilString, "'", "\'", "All")

(escape single quotes by replacing them with \')

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


-Original Message-
From: Sean Daniels [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 7:46 PM
To: CF-Talk
Subject: Jsstringformat


I've gotten in the habit of using jsstringformat in several of my apps. Now
I've got one that I have to deploy in a CF 4.01 environment. Anyone out
there have a custom tag or regex expression that will accomplish the same
thing?

TIA


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Rich Wild

Hmmm, yeah Cheers Paul, I thought about doing that.

Spose I could write the file, serve the hard copy file, delete the file

see if that would make any difference than just serving up a file. Speed
isn't an issue here, as its an action that'll only be performed a few times
a week.

---
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: Paul Johnston [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 12:44 PM
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation
 
 
 Well I'm stuck!  Anyone else care to try?
 
 Paul
 
 PS Maybe you could create a variable and write that out to a 
 file and strip
 out any blank lines?  Then you could locate the user to a page that
 downloads the file as a csv...  Dunno!  It's a solution, but 
 a bit scrappy,
 but it should work!
 
  -Original Message-
  From: Rich Wild [mailto:[EMAIL PROTECTED]]
  Sent: 17 October 2000 12:27
  To: CF-Talk
  Subject: RE: Extra records in CSV file generation
 
 
  Paul,
 
  I tried repositioning the cfsetting tag as you said - but 
 am still getting
  the extra fields...
 
  Here is the code - all on one line.
 
  CFHEADER NAME="Content-Disposition" VALUE="inline;
  filename=mangobase_#dateformat(now(), 
 "mmdd")#_#timeformat(now(),
  "HHmm")#.csv"CFCONTENT 
 TYPE="application/unknown"cfoutput"CONTACT
  ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputcfsetting
  enablecfoutputonly="yes"CFOUTPUT
  QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
  data#"#chr
  (13)#/CFOUTPUTcfsetting enablecfoutputonly="no"
 
  Again, it doesn't matter what records are pulled out of the db,
  it could be
  none, one or 27000 + etc - always 7 blank records at the end
 
  This says to me that its not data in the db - I've looked 
 for that anyway.
 
  The fact that I've tried Cfsetting and cf_lesswhitespace 
 and putting the
  code all on one line says to me that its not spurious 
 carrige returns or
  code formatting
 
  I've tried it using OLEDB and ODBC - same result...
 
  I've tried putting the whole SQL statement on 1 line - same 
 result... (I'm
  getting desperate now you can tell!)
 
  ay ay ay...
 
  I mean, its only a cosmetic problem, right? Or is it? 
 Perhaps those 7
  records could kill the customer's queries on that data or 
 affect his/her
  insertion into their accounting etc...
 
  must...findanswer *gasp*
 
  ---
  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: Paul Johnston [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, October 17, 2000 12:00 PM
   To: CF-Talk
   Subject: RE: Extra records in CSV file generation
  
  
   Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place
   I've put it:
  
   Your code:
  
CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=#dateformat(now(), "mmdd")#_#timeformat(now(),
   "HHmm")#.csv"
CFCONTENT 
 TYPE="application/unknown"cfoutput"CONTACT ID","SET
NAME","SET

RE: validating an empty field in enctype=multipart/form-data

2000-10-17 Thread Courtney Payne

Won't work in MacIE 4.5- browsers.  I found out the hard way a few months
ago with a client that insisted on using MacIE to upload images.

Due to "bug" in MacIE 4.5-, the length of the file field is always  0 --
whether you select a file or not.  Getting your users to use MacIE 5.0 will
solve the problem.

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


-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 8:28 PM
To: CF-Talk
Subject: Re: validating an empty field in enctype="multipart/form-data"



yep.  That worked. Thanks

on 10/16/00 5:09 PM, Owens, Howard at [EMAIL PROTECTED] wrote:

 On my response page, I validate with:
 
 cfif NOT Len(form.field)
 ERROR: Your file doesn't exist
 cfabort
 
 cfelse
 
 cffile  
 
 /cfif


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Client Storage

2000-10-17 Thread Akbar

i guess in all the 3 cases(registry, DB, cookies) there were would be 2
client cookies set (CFID, CFTOKEN) once we set "setclientcookies=yes" in our
application.cfm.

akbar

-Original Message-
From: Bill Killillay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 7:16 PM
To: CF-Talk
Subject: Client Storage


If the default client storage is set to registry and in the application.cfm
or application tag you enable client management and then enable
setclientcookies to yes, will client info be stored in the cookies, or will
it go with the setting in CFAS and store that info in the registry?

Bill


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



news driven site

2000-10-17 Thread Juan Andres Alvarez Valenzuela

hi guys,

I'm looking for open source CF software to set a news driven site but I
can't found nothing. Actually, I found a PHP software: http://phpnuke.org/.
it seems a pretty good.

is there any work in CF to make something like that ? CF Nuke ?


~Juandres



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Send data to Excel

2000-10-17 Thread Chris Norloff

-- Original Message --
From: "Neil Robinson" [EMAIL PROTECTED]
I'm developing a graphing system using CF and CFXGraphicsServer.  I'd like
to give the user the option to export the graph source data into Excel if
possible.  Does anyone know of a way I can do this?


Here an Allaire answer, from _Developing Web Applications with Cold Fusion_ ver 4.0. 
(Chapter 12, Selecting and Presenting Data - Returning MIME Content Types (CFCONTENT), 
pg 182).

" 
  Example: Populating an Excel spreadsheet
  The following example demonstrates a way to use ColdFusion to dynamically generate a 
spreadsheet that can load directly into Microsoft Excel. In order to do this 
seamlessly, you must associate the text/tabdelimited content type with your local 
Microsoft Excel application: 

CFCONTENT TYPE="text/tabdelimited"
CFQUERY NAME="GetFinancialData"
DATASOURCE="MutualFunds"
SELECT *
FROM Funds
WHERE Fund_ID=#Fund_ID#
/CFQUERY
PMonth Value Percentage Gain Estimate/P
CFOUTPUT QUERY="GetFinancialData"
#Month# #Value# #PercentageGain# #Estimate#
/CFOUTPUT
The spaces between fields and headers are actually tab characters. Tab characters are 
required in order for Excel to correctly parse the columns in the table. 
   
  
  Tip
  If you just need to quickly add a range of cells from a spreadsheet to a page, you 
can copy the range and paste it into ColdFusion Studio's Design window. The data is 
automatically converted to an HTML table. 
"


Chris Norloff
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Rich Wild

I'll stick the last few lines of a sample file up at
http://www.funjunkie.co.uk/csv/b0rked.csv (personal site) so that you can
see whats happening...

not quite sure where its getting this stuff from...


---
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: Paul Johnston [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 12:00 PM
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation
 
 
 Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place 
 I've put it:
 
 Your code:
 
  CFHEADER NAME="Content-Disposition" VALUE="inline;
  filename=#dateformat(now(), "mmdd")#_#timeformat(now(), 
 "HHmm")#.csv"
  CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET
  NAME","SET
  LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT
  QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
  data#"#chr
  (13)#/CFOUTPUT
 
 
 My code (put it all into one line):
 
 CFHEADER NAME="Content-Disposition"
 VALUE="inline;filename=#dateformat(now(), 
 "mmdd")#_#timeformat(now(),
 "HHmm")#.csv"
 CFCONTENT TYPE="application/unknown"cfoutput"CONTACT 
 ID","SET NAME","SET
 LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES"
 CFOUTPUT 
 QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
 data#"#chr(13)#/CFOUTPUT
 
 I ran this with some of my data, and it worked fine without 
 any extra spaces
 (also check there are no extra lines at all by putting it all 
 into one line!
 
 I hope this works!
 
 Paul
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: cfinclude + cfform..answer...

2000-10-17 Thread Ethan Rosch


Actually guys...It seems to have something to do with the form tag in a
div tag!!!  When I pulled my form tags out of my div and put them
around the entire page (bodydiv .../div/body  with the include in
the middle; the page parsed, howeverI did not get my actually text
fields to parse to the screen.  Just another heads up about mac/netscape.

ethan



- Original Message -
From: "Warrick, Mark" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 16, 2000 6:59 PM
Subject: RE: cfinclude + cfform


 You can also run each file through ColdFusion Studio's validator to check
your HTML.  It appears that HTML is the problem here.

 --
 Mark Warrick
 Phone: (714) 547-5386
 Efax.com Fax: (801) 730-7289
 Personal Email: [EMAIL PROTECTED]
 Personal URL: http://www.warrick.net
 Business Email: [EMAIL PROTECTED]
 Business URL: http://www.fusioneers.com
 ICQ: 346566
 --


  -Original Message-
  From: Mark Johnson [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 16, 2000 6:47 AM
  To: CF-Talk
  Subject: RE: cfinclude + cfform
 
 
  After the page has run (ie CF has turned it into html) do view
  source on the
  page and then search through the HTML for missing or incomplete tags,
  specifically missing /TABLE.
 
  Mark
 
  -Original Message-
  From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 16, 2000 10:37 PM
  To: CF-Talk
  Subject: Re: cfinclude + cfform
 
 
  cfform cfinclude are in a div tag, will this effect me?
 
  sorry to give this info piecemeal, but I am just scouring my brain and
  spitting out possibilites...
 
  Thank you,
 
  Ethan Rosch
 
 
 
  - Original Message -
  From: "Ethan Rosch" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Monday, October 16, 2000 5:20 PM
  Subject: Re: cfinclude + cfform
 
 
  
   One bit I forgot to mention was that the form.cfm works by
  itself and the
   Survey.cfm (with the include) works without the include.  It is
  only when
  I
   put the two of them together that it ceases to work
  
   Perhaps this is the point where my html error occurs?
  
   I shall continue!!!
  
   ethan
  
  
   - Original Message -
   From: "Ethan Rosch" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Monday, October 16, 2000 5:00 PM
   Subject: cfinclude + cfform
  
  
This is a multi-part message in MIME format.
   
--=_NextPart_000_0092_01C03792.99A898D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
   
   
I am trying to cfinclude a cffform, however it works great in =
everything except Mac/Netscape (go figure!) where it either
  crashes out
  =
the whole browser or doesn't parse anything to the screen!!??
  But I can
  =
see my whole page in source view??!!!
   
Any ideas?
   
I've had my cfform in the include and in the main page
I've tried using form and cfform...
   
I'm at a loss...I finish this and I am done!!!
   
Please help...
   
Thanks,
   
ethan
   
   
   
--=_NextPart_000_0092_01C03792.99A898D0
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.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I am trying to lt;cfincludegt; a
=
lt;cffformgt;,=20
however it works great in everything except Mac/Netscape (go
  figure!) =
where it=20
either crashes out the whole browser or doesn't parse
  anything to the =
screen!!??=20
But I can see my whole page in source view??!!!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Any ideas?/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I've had my lt;cfformgt; in the =
include and in=20
the main page/FONT/DIV
DIVFONT face=3DArial size=3D2I've tried using lt;formgt;
and=20
lt;cfformgt;.../FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I'm at a loss...I finish this and I
  am=20
done!!!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Please help.../FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2ethan/DIV
DIVBR/DIV/FONT/BODY/HTML
   
--=_NextPart_000_0092_01C03792.99A898D0--
   
  
  

 --
   

RE: Dynamic Form value

2000-10-17 Thread stas

I do it this way, easier to read ( I am assuming you're doing this to
"remember" form field values):

cfparam name = "session.particulars.name" default = "#somevar#"

cfinput type="Text" name="name" value="#session.particulars.name#"

-Original Message-
From: David [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 11:33 PM
To: CF-Talk
Subject: Dynamic Form value


Hi all,


I have tried the following and it works.

input type="Text" name="name"
cfif isdefined("session.particulars")
 cfoutputvalue="#session.particulars.name#"/cfoutput
/cfif
  

but when I can it to cfinput, I got an error.

cfinput type="Text" name="name"
cfif isdefined("session.particulars")
 value="#session.particulars.name#"
/cfif
  

Is there a workaround?

Thank you and regards
David



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Jsstringformat

2000-10-17 Thread Sean Daniels

 cfset safeString = Replace(evilString, "'", "\'", "All")

 (escape single quotes by replacing them with \')

But are single quotes the only evil things I need to watch out for? If so,
woo hoo! But I kind of doubt it?


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Jsstringformat

2000-10-17 Thread Courtney Payne

Depends on what's in your string and what you're trying to do.

Ex.  If you have an HTML string ("Hello there.brbrHow are you?"), you'll
want to replace occurances of br with \r (or \n).

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


-Original Message-
From: Sean Daniels [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:18 AM
To: CF-Talk
Subject: RE: Jsstringformat


 cfset safeString = Replace(evilString, "'", "\'", "All")

 (escape single quotes by replacing them with \')

But are single quotes the only evil things I need to watch out for? If so,
woo hoo! But I kind of doubt it?


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com





--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Paul Johnston

I am guessing that there are some line breaks or something in your fields.

Either that or that the fields contain whitespace and nothing else and are
still coming out.

Maybe check for that when pulling the data out?

It doesn't seem to be outputting anything it shouldn't (or that it doesn't
think it should).

Other than that, I'm confused.

Paul

 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 17 October 2000 13:37
 To: CF-Talk
 Subject: RE: Extra records in CSV file generation


 I'll stick the last few lines of a sample file up at
 http://www.funjunkie.co.uk/csv/b0rked.csv (personal site) so that you can
 see whats happening...

 not quite sure where its getting this stuff from...


 ---
 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: Paul Johnston [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, October 17, 2000 12:00 PM
  To: CF-Talk
  Subject: RE: Extra records in CSV file generation
 
 
  Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place
  I've put it:
 
  Your code:
 
   CFHEADER NAME="Content-Disposition" VALUE="inline;
   filename=#dateformat(now(), "mmdd")#_#timeformat(now(),
  "HHmm")#.csv"
   CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET
   NAME","SET
   LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT
   QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
   data#"#chr
   (13)#/CFOUTPUT
  
 
  My code (put it all into one line):
 
  CFHEADER NAME="Content-Disposition"
  VALUE="inline;filename=#dateformat(now(),
  "mmdd")#_#timeformat(now(),
  "HHmm")#.csv"
  CFCONTENT TYPE="application/unknown"cfoutput"CONTACT
  ID","SET NAME","SET
  LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES"
  CFOUTPUT
  QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_
  data#"#chr(13)#/CFOUTPUT
 
  I ran this with some of my data, and it worked fine without
  any extra spaces
  (also check there are no extra lines at all by putting it all
  into one line!
 
  I hope this works!
 
  Paul
 
 
  --
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CF Resources

2000-10-17 Thread Stephan Tual (CFTutorials.com)

At 10:13 AM 10/16/00 -0400, you wrote:
Boy what a hard time I had this weekend trying to find some resources on
Cold Fusion.  Basically I was trying to write a few scripts, but I couldn't
find any decent examples online.  Much different from the PHP community out
there.  The examples I could find were done as CFX, which I can't use on my
current host.

Peter-

give a try to

www.defusion.com
www.fusebox.org
www.black-box.org/

And of course www.cfvault.com   ;-)

Regards,


Stephan Tual
Editor  Webmaster

CFVault.com
http://www.cfvault.com
Daily News Updates, Jobs and in-depth Tutorials from the Allaire World.

Direct Line: CFTutorials.com Ltd. +(1) 415 637 5591

Team Allaire Member
Allaire Certified Trainer
Allaire Certified CF Developer

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Dynamic Form value

2000-10-17 Thread Stewart, Mark

David,

The last two posts answer your question so all I'll add to this is be sure
to remember your cflocks when you reference a session variable.

~Mark

-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:07 AM
To: CF-Talk
Subject: RE: Dynamic Form value


I do it this way, easier to read ( I am assuming you're doing this to
"remember" form field values):

cfparam name = "session.particulars.name" default = "#somevar#"

cfinput type="Text" name="name" value="#session.particulars.name#"

-Original Message-
From: David [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 11:33 PM
To: CF-Talk
Subject: Dynamic Form value


Hi all,


I have tried the following and it works.

input type="Text" name="name"
cfif isdefined("session.particulars")
 cfoutputvalue="#session.particulars.name#"/cfoutput
/cfif
  

but when I can it to cfinput, I got an error.

cfinput type="Text" name="name"
cfif isdefined("session.particulars")
 value="#session.particulars.name#"
/cfif
  

Is there a workaround?

Thank you and regards
David



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Extra records in CSV file generation

2000-10-17 Thread Rich Wild

 Other than that, I'm confused.

Yeah, me too! :D

There are no fields which are blank

There *are* fields which contain line breaks..but, even when an entire
query containing no line breaks (eg selecting 1 record from sql specifically
without line breaks) are pulled out, those end records are still there and
number the same.



---
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.
---
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: outputting data in a matrix

2000-10-17 Thread Stewart, Mark

Richard,

If you're comfortable with using Crystal Reports, give that a try. 

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4 
  

where the data table looks like:

category, item, etc. 

there will be an unequal number of items per category.
   
ideas for an approach appreciated. Thank you.

Richard Colman


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Jsstringformat

2000-10-17 Thread Sean Daniels

 Depends on what's in your string and what you're trying to do.

 Ex.  If you have an HTML string ("Hello there.brbrHow are
 you?"), you'll
 want to replace occurances of br with \r (or \n).

Well, mainly I'm just trying to avoid Javascript errors. The js code is just
a real simple alert that pops up when the user clicks the delete button to
delete a record. Problem is, I want the alert to say "Confirm: Delete
#recordname#?" and #recordname# can have any number of bizarre characters in
it, including single quotes, double quotes, etc etc all of which would cause
a javascript error when calling the function in this way:

javascript:confirmkill('#id#','#recordname#')

The JsStringFormat function accomplished this beautifully, But since it's
not available in 4.01, I need another way.

javascript:confirmkill('#id#','#jsstringformat(recordname)#')

Thanks for the help, Courtney.


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: news driven site

2000-10-17 Thread Dave Hannum

This was a duplicate to a message from last week.
Smells like someone doing a promo for phpnuke . . .

Dave




- Original Message -
From: "Stewart, Mark" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 9:54 AM
Subject: RE: news driven site


Juandres,

It's early and I haven't had my cf_coffee yet. Are you looking to get news
and syndicate it on your site? It looks like that's what you're trying to
do. If you are, moreover.com is a great place to get news. It has a section
for ColdFusion and WDDX. Very simple to set up. If I'm misunderstanding what
you're looking for, I apologize.

~Mark

-Original Message-
From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 8:10 AM
To: CF-Talk
Subject: news driven site


hi guys,

I'm looking for open source CF software to set a news driven site but I
can't found nothing. Actually, I found a PHP software: http://phpnuke.org/.
it seems a pretty good.

is there any work in CF to make something like that ? CF Nuke ?


~Juandres




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CF Calendar (Popup?)

2000-10-17 Thread J.Milks

This is a multi-part message in MIME format.

--=_NextPart_000_00AC_01C03823.0B51E0A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,
Hope everyone is doing well...

I have a need for a popup type calendar so that users can select a date. =
I saw a CF one somewhere, but the site in question has done under =
(redgorilla.com). Does anyone have such a thing?

Thanks in advance,

Jim


--=_NextPart_000_00AC_01C03823.0B51E0A0
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.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV
DIVFONT face=3DArial size=3D2Hope everyone is doing =
well.../FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I have a need for a popup type calendar =
so that=20
users can select a date. I saw a CF one somewhere, but the site in =
question has=20
done under (redgorilla.com). Does anyone have such a thing?/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks in advance,/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Jim/FONT/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_000_00AC_01C03823.0B51E0A0--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: NASDAQ.com... ERRRRR! - Fixed it -

2000-10-17 Thread Gavin Myers

Nevermind, Had my stuff inside the cfcatch... shoulda been like this:

cftry#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"][1].
value#
cfcatch/cfcatch
/cftry
cftry#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"].val
ue#
cfcatch/cfcatch
/cftry

-Original Message-
From: Gavin Myers 
Sent: Tuesday, October 17, 2000 9:29 AM
To: '[EMAIL PROTECTED]'
Subject: NASDAQ.com... ER!


okay, i'm pulling xml info off of nasdaq.com. You can find the xml stuff
they have at:
http://quotes.nasdaq.com/quote.dll?page=xmlmode=stocksymbol=ALLR

every %*@ minute they change the way they handle best-bid-price, and
best-ask-price
they do this:

from 
best-bid-price
to
best-bid-price variable = "variable"


so, needless to say, this throws an error every time they change it around.

I was thinking of doing a cftry, but I was unsure on how to do this, is this
correct?

cf_xmlparse type="file"
xmldoc="http://quotes.nasdaq.com/quote.dll?page=xmlmode=stocksymbol=ALLR"
r_struct="sALLR"
!--- this is a great tag from fuseobjects btw! ---

cftry
cfcatch#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"][1
].value#/cfcatch
/cftry
cftry
cfcatch#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"].v
alue#/cfcatch
/cftry

when i do that, it just doesnt show up with a bid price at all...

any suggestions?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF browser detection??? - warning against BrowserHawk

2000-10-17 Thread Mike Amburn

we used to use BrowserHawk from cyScape. it's a great component and
provides some really cool information like whether the user has disabled
java, javascript, or cookies. the problem is that they require that you
license every machine that it runs on.

$489 x 25 developers ($12225)
+ $489 x 10 servers ($4890)
= too much $$$ for one little COM object only executed once

we've since written our own components that don't do as much, but save
us $18k

-mike

 -Original Message-
 From: Doyle, Mike [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 3:54 PM
 To: CF-Talk
 Subject: RE: CF browser detection???
 
 
 Or...there is always the handy-dandy custom tag, CF_BrowserCheck!
 
 Here:
 http://devex.allaire.com/developer/gallery/SearchResults.cfm?k
 eywords=BROWSE
 RCHECKsearch=search
 
 Mike
 
 
 -Original Message-
 From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 3:38 PM
 To: CF-Talk
 Subject: CF browser detection???
 
 
 
 
 CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="3" 
 if Netscape
 stupid browser,MAXROWS="6" if IE
 
 Obviously the above won't work, but is there something like 
 this that will??
 
 CFIF??
 
 I don't want to use a javascript detection and redirect to a 
 whole new page.
 
 Jeff
 
 --
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: NASDAQ.com... ERRRRR!

2000-10-17 Thread Gavin Myers

fuseobjects... hah, i mean siteobjects

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:29 AM
To: CF-Talk
Subject: NASDAQ.com... ER!


okay, i'm pulling xml info off of nasdaq.com. You can find the xml stuff
they have at:
http://quotes.nasdaq.com/quote.dll?page=xmlmode=stocksymbol=ALLR

every %*@ minute they change the way they handle best-bid-price, and
best-ask-price
they do this:

from 
best-bid-price
to
best-bid-price variable = "variable"


so, needless to say, this throws an error every time they change it around.

I was thinking of doing a cftry, but I was unsure on how to do this, is this
correct?

cf_xmlparse type="file"
xmldoc="http://quotes.nasdaq.com/quote.dll?page=xmlmode=stocksymbol=ALLR"
r_struct="sALLR"
!--- this is a great tag from fuseobjects btw! ---

cftry
cfcatch#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"][1
].value#/cfcatch
/cftry
cftry
cfcatch#sALLR["NASDAQAMEX-DOT-COM"][2]["EQUITY-QUOTE"]["best-bid-price"].v
alue#/cfcatch
/cftry

when i do that, it just doesnt show up with a bid price at all...

any suggestions?

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Excel query

2000-10-17 Thread Joseph Vincent

I am running a query on an Excel spreadsheet using the MS Excel ODBC driver. 
I have the columns named in the top row of the spreadsheet. My problem 
occurs in one of the columns where there is a text header on row 5 then rows 
7-11 have numeric data.  When I run the query it is only bringing back the 
text, not the numbers.  When I change the numbers to text they are selected. 
  Does anyone know what might cause this?
_
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.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: NASDAQ.com... ERRRRR!

2000-10-17 Thread Dan O'Keefe

What is a siteobject?

 fuseobjects... hah, i mean siteobjects

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Beep, Beep?

2000-10-17 Thread JustinMacCarthy

Not unless you want to use a ActiveX com or Java Applet

Justin MacCarthy

- Original Message -
From: "Michael Rosario" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 4:00 PM
Subject: Beep, Beep?


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

 --_=_NextPart_001_01C0384B.0EA54D90
 Content-Type: text/plain;
 charset="iso-8859-1"

 Hello there!

 Is there an easy way to make a beep from Internet Explorer
 javascript?   I've already tried using an embed to put a wav file
 into the page and play it.  That works, but I've found this causes
 javaScript errors in some unknown cases.   (It may be caused by difference
 media player
 active X object)In addition, this doesn't cause a beep for people who
 don't have sound cards.   Any suggestions?   Thanks!

 /\/\ichael

 --_=_NextPart_001_01C0384B.0EA54D90
 Content-Type: text/html;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
 HTML
 HEAD
 META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
 charset=3Diso-8859-1"
 META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
 5.5.2650.12"
 TITLEBeep, Beep?/TITLE
 /HEAD
 BODY

 PFONT SIZE=3D2Hello there!/FONT
 BRFONT SIZE=3D2nbsp;nbsp; /FONT
 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT SIZE=3D2Is there =
 an easy way to make a beep from Internet Explorer =
 javascript?nbsp;nbsp; I've already tried using an lt;embedgt; to =
 put a wav file /FONT/P

 PFONT SIZE=3D2into the page and play it.nbsp; That works, but I've =
 found this causes javaScript errors in some unknown cases.nbsp;nbsp; =
 (It may be caused by difference media player/FONT/P

 PFONT SIZE=3D2active X object)nbsp;nbsp;nbsp; In addition, this =
 doesn't cause a beep for people who don't have sound cards.nbsp;nbsp; =
 Any suggestions?nbsp;nbsp; Thanks!/FONT/P

 PFONT SIZE=3D2/\/\ichael/FONT
 /P

 /BODY
 /HTML
 --_=_NextPart_001_01C0384B.0EA54D90--
 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF Calendar (Popup?)

2000-10-17 Thread Juan Andres Alvarez Valenzuela

http://devex.allaire.com/developer/gallery/SearchResults.cfm?Sortby=Download
skeywords=calendarstartRow=1MaxRows=10Author=Title=Hammer2ID=SearchTy
pe=Simple


~Juandres

- Original Message -
From: J.Milks [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 4:14 PM
Subject: CF Calendar (Popup?)


 This is a multi-part message in MIME format.

 --=_NextPart_000_00AC_01C03823.0B51E0A0
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 Hi all,
 Hope everyone is doing well...

 I have a need for a popup type calendar so that users can select a date. =
 I saw a CF one somewhere, but the site in question has done under =
 (redgorilla.com). Does anyone have such a thing?

 Thanks in advance,

 Jim


 --=_NextPart_000_00AC_01C03823.0B51E0A0
 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.4134.600" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV
 DIVFONT face=3DArial size=3D2Hope everyone is doing =
 well.../FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2I have a need for a popup type calendar =
 so that=20
 users can select a date. I saw a CF one somewhere, but the site in =
 question has=20
 done under (redgorilla.com). Does anyone have such a thing?/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Thanks in advance,/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Jim/FONT/DIV
 DIVnbsp;/DIV/BODY/HTML

 --=_NextPart_000_00AC_01C03823.0B51E0A0--

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Passwords in O'Reilly WebSite

2000-10-17 Thread Michael Dinowitz

http://www.houseoffusion.com/cfapi/cfx_wsauth.zip
Does the crypto for you and I got the code for that section directly from
Denny.


 Hello,

 The Users' passwords in the Registry of O'Reilly WebSite are all
encrpyted.
 Fine.

 I'm creating an App in CF to automate WebSite - but I don't know how to
 encrypt the passwords. If I enter in a plain-text password, it doesn't
like
 it.

 Can anyone advise as to what I should do?

 Thanks

 Will

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CF Calendar (Popup?)

2000-10-17 Thread Joseph Thompson

http://www.webtricks.com/SourceCode/

There are a few calendar items here including the one that populates the
input box (I think that is the one you want)

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Browser Detection

2000-10-17 Thread Doug Powell

You can use this script

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
!--
if(navigator.appName.substring(0,9) == 'Microsoft' 
navigator.appVersion.indexOf('5.') !=-1) {
   window.alert('Running MSIE 5 or better')
}
//--
/SCRIPT

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 11:48 AM
To: CF-Talk
Subject: Browser Detection


Now i feel dumb for recently deleating all of that past browser detection
talk

this is all i want to do:
verify that whomever is using IE 5.0 or greater

so if I use

CGI.http_user_agent Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)

How can I just look for the MSIE 5.0, or is there something else I should be
looking for?

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Browser Detection

2000-10-17 Thread Paul Johnston

see cf_browser in the allaire tag gallery.

Paul

 -Original Message-
 From: Gavin Myers [mailto:[EMAIL PROTECTED]]
 Sent: 17 October 2000 16:48
 To: CF-Talk
 Subject: Browser Detection


 Now i feel dumb for recently deleating all of that past browser detection
 talk

 this is all i want to do:
 verify that whomever is using IE 5.0 or greater

 so if I use

 CGI.http_user_agent Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)

 How can I just look for the MSIE 5.0, or is there something else
 I should be
 looking for?
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFContent Weirdness

2000-10-17 Thread Warrick, Mark

I have a report which works fine as HTML output.

As soon as I add in the following CFCONTENT tag, the report somehow looses all the 
variables from the form previous to it which passes information into it.

Here's the tag I'm using:
cfcontent type="application/msword"

Now, If I change the tag to:
cfcontent type="application/rtf"

It works fine and I can download the generated report, name it as a doc file, and then 
open it up in Word.

What's the problem here?  First of all, I'd really like my browser to launch Word 
(we're all using MSIE 5.0) and secondly, if I'm forced to download the file instead, 
I'd like to pass a doc name through to the download prompt of the browser.  (It 
currently names it as the name of the CFML template by default.)

I've tried this trick:
http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc

But it doesn't work on my server.  Gives me a 405 error.

What am I doing wrong?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFFile Copy action

2000-10-17 Thread Joseph Vincent

I am trying to use the CFFile Copy action to copy a file from one of our 
network drives over to our Web Server every morning.  I tried to do this and 
got an error stating that the network file could not be found.  Does anyone 
know if this should be able to be done?
_
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.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [pop-up window upon login]

2000-10-17 Thread double-down

javascript ... use window.open()
the rest is just a query to diplay the popup info.
call the javascript function either from onload or onsubmit

"Kim Ahlbrandt" [EMAIL PROTECTED] wrote:
I would like to have a window pop-up with the login information, time of 
login, etc. as my users are Authenticated.  Does anyone have any hints on 
how to do this or any commands I might start looking for in the helpor, 
any good articles on-line you can point me to.

thanks,

Kim Ahlbrandt

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CF on Win2K adv server

2000-10-17 Thread Michael J. Sammut -- Four Eyes Productions -- think | plan | create

I have been running CF Enterprise 4.5 on Windows 2000 professional.  I
upgraded the system to Windows 2000 Advanced Server and reinstalled CF.
However, none of the CF services will start  (Well actually executive will
start, but not application or RDS)-- automatically or manually.  Has anyone
have any idea on why this would be happening?



Thank you,
Michael J. Sammut

F O U R  E Y E S  P R O D U C T I O N S

think | plan | create :: web site design  development

http://www.foureyesproductions.com
http://www.thinkplancreate.com

T: 718.254.9557  ext. 101
F: 718.254.0399




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: outputting data in a matrix

2000-10-17 Thread Chapman, Katrina

No offence to anyone but your all making this much more difficult than it
is.

With a little creative HTML you can do this.

CFQUERY name="get_stuff" datasource="katrinachapman"
SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name
/CFQUERY
TABLE
TR
CFOUTPUT query="get_stuff" group="name"
td valign="top"
TABLE
TR
TDb#name#/b
/TD
/TR
CFOUTPUT
TR
TD#title#
/TD
/TR
/CFOUTPUT
/TABLE
/td
/CFOUTPUT
/TR
/TABLE

This is just an example but you don't need to make it more difficult than it
is.  Of course you can modify this so that you only go three across or pull
a certain number of records at a time.  If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.

--K


-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


Richard,

If you're comfortable with using Crystal Reports, give that a try. 

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4 
  

where the data table looks like:

category, item, etc. 

there will be an unequal number of items per category.
   
ideas for an approach appreciated. Thank you.

Richard Colman
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFMAIL problems

2000-10-17 Thread Bruce Srawley

Hi,

we have a bit of a problem mailing through ColdFusion. Our servers are all
set to GMT with daylight saving time. This is fine, unfortunately it seems
that CFMAIL does not take this into account so when a recipient gets a mail
from coldfusion it looks as though they receive the mail before it has
actually been sent. Ha sanyone got any recommendations on how to resolve
this??

Bruce Srawley

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Divide field in query and output resluts.

2000-10-17 Thread Hong

SELECT ROUND( ( TOTAL / HIT ), 1 ) AS output_result


-- 
Hong Wu
Senior Web Developer
DoubleSpace


Jeremy Toevs wrote:
 
 Is there a way to make it round to the nearest tenth?
 
  Hong [EMAIL PROTECTED] 10/16/00 03:20PM 
 use SQL math divide operator,
 
 SELECT ( TOTAL / HIT ) AS output_result
 ...
 
 --
 Hong Wu
 Senior Web Developer
 DoubleSpace
 
 Jeremy Toevs wrote:
 
  Can you divide field in a query an output the results. Bacially, I have a TOTAL 
field that I want to divid by a HIT field. How would I do that if you can?
 
  Thanks for the help.
 
  Jeremy
 
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFFile Copy action

2000-10-17 Thread Simon Horwith

I don't believe CFFILE will do that (I tried to do the same thing once upon
a time).  You could use a com object (via cfobject), stored procedure or DTS
Package on SQL Srvr, CFX tag, CFFTP (if you have an ftp server on the remote
machine), etc. but I do not believe you can just CFFILE manipulate files
on network drives.  Somebody enlighten us both, if I'm wrong about this.

~Simon

-Original Message-
From: Joseph Vincent [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 12:19 PM
To: CF-Talk
Subject: CFFile Copy action


I am trying to use the CFFile Copy action to copy a file from one of our 
network drives over to our Web Server every morning.  I tried to do this and

got an error stating that the network file could not be found.  Does anyone 
know if this should be able to be done?
_
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.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



What's with all the space?

2000-10-17 Thread Peter Benoit

Viewing the source code of my CF apps, I see lots of white space.  Space
that isn't there in other server side programming languages.  

Why is this, and is there something I can do about it?


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: pop-up window upon login

2000-10-17 Thread Scott Weikert

In your page that's actually doing the authentication... at the point (or
after) the authentication is confirmed... put in a bit of Javascript with a
window.open function, calling whatever CF page plus variables (userid, or
whatever you're using) as the URL. It's something that won't execute until
CF is done with the page and renders out the resulting HTML, though.

--Scott

- Original Message -
From: "Kim Ahlbrandt" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 9:02 AM
Subject: pop-up window upon login


 I would like to have a window pop-up with the login information, time of
 login, etc. as my users are Authenticated.  Does anyone have any hints on
 how to do this or any commands I might start looking for in the
helpor,
 any good articles on-line you can point me to.

 thanks,

 Kim Ahlbrandt

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

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Comprehensive Scope Listing

2000-10-17 Thread David Shadovitz

In CF Studio's help, check out Developing Web Applications With
ColdFuison | Creating and Manipulating Variables | Using Application and
Session Variables.

Also see Teratech's http://www.cfug-md.org/articles/scope_worksheet.PDF
and http://www.cfug-md.org/articles/scope_STORAGE_analysis.PDF (watch the
word wrap)

-David

On Tue, 17 Oct 2000 10:58:42 -0500 Ryan Springer [EMAIL PROTECTED] writes:
 I know and have worked with several variable scopes in cold fusion, 
 but I
 have never found a COMPLETE listing of all the scopes with their 
 differences
 explained.  Every listing I find seems to omit or ignore at least 
 one of the
 scopes.  Can anyone point me to a comprehensive scope listing?
 
 Thanks
 
 Ryan
 

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

 or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Anyone know of any fusebox-built forum solutions?

2000-10-17 Thread Scott Weikert

Hey all,

Working on a contract at a place that's useing the Fusebox development
methodology. The site is going to have a forum. Right now they're looking at
using Allaire's Forums - bleah. I'm looking around for better solutions (not
difficult), but specifically, one built using Fusebox. Anyone know of such a
beast?

TIA,
--Scott

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Fw: Re: Comprehensive Scope Listing

2000-10-17 Thread David Shadovitz

Oops, make that Developing Web Applications With ColdFuison | Creating
and Manipulating Variables | Naming and Scoping Variables.  (I had the
last item wrong.)
-David

- Forwarded message --
From: David Shadovitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Tue, 17 Oct 2000 10:23:31 -0700
Subject: Re: Comprehensive Scope Listing
Message-ID: [EMAIL PROTECTED]

In CF Studio's help, check out Developing Web Applications With
ColdFuison | Creating and Manipulating Variables | Using Application and
Session Variables.

Also see Teratech's http://www.cfug-md.org/articles/scope_worksheet.PDF
and http://www.cfug-md.org/articles/scope_STORAGE_analysis.PDF (watch the
word wrap)

-David

On Tue, 17 Oct 2000 10:58:42 -0500 Ryan Springer [EMAIL PROTECTED] writes:
 I know and have worked with several variable scopes in cold fusion, 
 but I
 have never found a COMPLETE listing of all the scopes with their 
 differences
 explained.  Every listing I find seems to omit or ignore at least 
 one of the
 scopes.  Can anyone point me to a comprehensive scope listing?
 
 Thanks
 
 Ryan
 

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

 or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Expand Select Box (JS Question)

2000-10-17 Thread j p


Is It possible through JS to expand a select box, I need to expand a select 
box when someone clicks on something (not the little arrow if the select 
box)

JP
_
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.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFContent Weirdness

2000-10-17 Thread Chapman, Katrina

What we do here is a cfhttp call to the template that creates the HTML for
the report passing through the file attribute. Then cfcontent the file that
was created in the cfhttp.  That way you don't lose anything.

Let me know if you need anymore help with this.

--K

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:20 AM
To: CF-Talk
Subject: CFContent Weirdness


I have a report which works fine as HTML output.

As soon as I add in the following CFCONTENT tag, the report somehow looses
all the variables from the form previous to it which passes information into
it.

Here's the tag I'm using:
cfcontent type="application/msword"

Now, If I change the tag to:
cfcontent type="application/rtf"

It works fine and I can download the generated report, name it as a doc
file, and then open it up in Word.

What's the problem here?  First of all, I'd really like my browser to launch
Word (we're all using MSIE 5.0) and secondly, if I'm forced to download the
file instead, I'd like to pass a doc name through to the download prompt of
the browser.  (It currently names it as the name of the CFML template by
default.)

I've tried this trick:
http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc

But it doesn't work on my server.  Gives me a 405 error.

What am I doing wrong?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Storing passwords in database as one way hash

2000-10-17 Thread Jon Tillman

anybody know of anything that does such?
I am looking for pretty much the same functionality as a standard *NIX login

-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: outputting data in a matrix

2000-10-17 Thread Richard Colman

This worked just great. Thank you.

Richard Colman

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


No offence to anyone but your all making this much more difficult than it
is.

With a little creative HTML you can do this.

CFQUERY name="get_stuff" datasource="katrinachapman"
SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name
/CFQUERY
TABLE
TR
CFOUTPUT query="get_stuff" group="name"
td valign="top"
TABLE
TR
TDb#name#/b
/TD
/TR
CFOUTPUT
TR
TD#title#
/TD
/TR
/CFOUTPUT
/TABLE
/td
/CFOUTPUT
/TR
/TABLE

This is just an example but you don't need to make it more difficult than it
is.  Of course you can modify this so that you only go three across or pull
a certain number of records at a time.  If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.

--K


-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


Richard,

If you're comfortable with using Crystal Reports, give that a try.

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4


where the data table looks like:

category, item, etc.

there will be an unequal number of items per category.

ideas for an approach appreciated. Thank you.

Richard Colman

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



access color selection box with CF?

2000-10-17 Thread Mark Adams

Has anyone accessed the windows color select box using CF?

-Mark

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFFILE ACTION=UPLOAD probs

2000-10-17 Thread Adrian Cesana

I am using the below code to upload some text files, if the file has an .csv
extension is will fail the test and get the error, if I just rename the same
file with no extension it works ok.  I though the accept="text/plain" looks
at the file contents not the extension.  Any recommendations on how to get
around this?

Thanks,Adrian


cftry
CFFILE ACTION="UPLOAD" filefield="filename" destination="G:\blah\"
nameconflict="ERROR" accept="text/plain"
CFFILE ACTION="RENAME" source="G:\blah\#File.ServerFile#"
destination="G:\blah\blah.#currentdate#.#currenttime#"
cfcatch type="Any"
cfset success = false
The File Cold NOT Be Uploaded.
Make Sure The File You Are Uploading Is In A Plain Text Format.
/cfcatch
/cftry

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: File replication packages

2000-10-17 Thread Mark Johnson

Those of you using server farms and or loadbalancing.  How do you publish
your CF files to all your servers?  What software are you using to acomplish
this?  What should we aviod in implementing a file replication package.

Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: returning top 10

2000-10-17 Thread Hong

SELECT TOP 10
..

-- 
Hong Wu
Senior Web Developer
DoubleSpace


Jim Watkins wrote:
 
 What I mean is I do not want to hard code the top ten in.  I want Cold
 Fusion/Oracle to determine what the top ten are from say a list of 60.
 
 -Original Message-
 From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 9:15 PM
 To: CF-Talk
 Subject: RE: returning top 10
 
 Select top 10 * (or your fields)
 FROM table
 WHERE blah blah blah and student_pop
 in('Towns','Union','White','Fannin','Habersham','Stephens','Rabun','Franklin
 ','Bibb','Jones')
 
 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 9:09 PM
 To: CF-Talk
 Subject: returning top 10
 
 How do you write a SQL statement that will return the top 10 of something
 (eg. top 10 salaries, top ten students by GPA, top ten populated counties,
 etc.)?
 
 Currently I have:
 and student_pop
 in('Towns','Union','White','Fannin','Habersham','Stephens','Rabun','Franklin
 ','Bibb','Jones')
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Thanks was RE: returning top 10

2000-10-17 Thread Hong

sounds familiar? are you doing your database class homework or
something??

maybe you can use:
SELECT blah...
FROM   blah...
WHERE  ... NOT IN ( query_select_top_10_countries )

Hong

Jim Watkins wrote:
 
 So far so good.  Now I have written another script that selects everyone NOT
 in the top ten counties (rows).  How can I do that without naming the
 counties?
 
 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 9:09 PM
 To: CF-Talk
 Subject: returning top 10
 
 How do you write a SQL statement that will return the top 10 of something
 (eg. top 10 salaries, top ten students by GPA, top ten populated counties,
 etc.)?
 
 Currently I have:
 and student_pop
 in('Towns','Union','White','Fannin','Habersham','Stephens','Rabun','Franklin
 ','Bibb','Jones')
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



writing files from oracle

2000-10-17 Thread Chris Hamer

Is there a way to get oracle to write a csv file from a coldfusion request.
Does oracle have a 'bcp' type program like sql server that writes files out
quickly?
I need to write a file with about 10 - 15,000 records without over-taxing
the cfserver.

Chris Hamer
Web Development
ImageServe, Inc.
http://www.imageserve.com
[EMAIL PROTECTED]


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [Storing passwords in database as one way hash]

2000-10-17 Thread double-down

what database? MySQL has a password() function that encrypts

Jon Tillman [EMAIL PROTECTED] wrote:
anybody know of anything that does such?
I am looking for pretty much the same functionality as a standard *NIX login

-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [What's with all the space?]

2000-10-17 Thread double-down

use 
cfsetting enable cfoutput only
and
the custom tag cf_ripwhitespaces from the allaire exchange

Peter Benoit [EMAIL PROTECTED] wrote:
Viewing the source code of my CF apps, I see lots of white space.  Space
that isn't there in other server side programming languages.  

Why is this, and is there something I can do about it?


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: What's with all the space?

2000-10-17 Thread Warrick, Mark

There are several ways to do this.  Here's one:

You can surround all of your code with the following tag:

CFSETTING ENABLECFOUTPUTONLY="YES"

Then make sure that anything you want returned to the screen is surrounded by 
CFOUTPUT tags.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Peter Benoit [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 10:04 AM
 To: CF-Talk
 Subject: What's with all the space?
 
 
 Viewing the source code of my CF apps, I see lots of white space.  Space
 that isn't there in other server side programming languages.  
 
 Why is this, and is there something I can do about it?
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with 
 'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: What's with all the space?

2000-10-17 Thread Chapman, Katrina

Look at the cfsetting tag.  The white space is caused by the cf tags taking
up space but not appearing in the source code.

--K

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 10:04 AM
To: CF-Talk
Subject: What's with all the space?


Viewing the source code of my CF apps, I see lots of white space.  Space
that isn't there in other server side programming languages.  

Why is this, and is there something I can do about it?



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Comprehensive Scope Listing

2000-10-17 Thread Ryan Springer

Thanks, exactly what I wanted. =)

Ryan Springer


-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 12:24 PM
To: CF-Talk
Subject: Re: Comprehensive Scope Listing


In CF Studio's help, check out Developing Web Applications With
ColdFuison | Creating and Manipulating Variables | Using Application and
Session Variables.

Also see Teratech's http://www.cfug-md.org/articles/scope_worksheet.PDF
and http://www.cfug-md.org/articles/scope_STORAGE_analysis.PDF (watch the
word wrap)

-David

On Tue, 17 Oct 2000 10:58:42 -0500 Ryan Springer [EMAIL PROTECTED] writes:
 I know and have worked with several variable scopes in cold fusion,
 but I
 have never found a COMPLETE listing of all the scopes with their
 differences
 explained.  Every listing I find seems to omit or ignore at least
 one of the
 scopes.  Can anyone point me to a comprehensive scope listing?

 Thanks

 Ryan


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

 or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Storing passwords in database as one way hash

2000-10-17 Thread Cameron Childress

 anybody know of anything that does such?
 I am looking for pretty much the same functionality as a standard
 *NIX login

Look up the function Hash().  I think it was introduced in CF 4.5.
Actually, I just looks at the online cfdocs and don't see it in there, but
it is... maybe introduced in 4.5.1?

There's also a CFX_HASH in the tag gallery that give many more options of
hash types.

-Cameron


Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: What's with all the space?

2000-10-17 Thread Bill Killillay

Take a look at CFENABLEOUTPUTONLY, and there are a bunch of Custom tags on
Allaires web site for stripping out the white space also.

 -Original Message-
 From: Peter Benoit [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 1:04 PM
 To: CF-Talk
 Subject: What's with all the space?


 Viewing the source code of my CF apps, I see lots of white space.  Space
 that isn't there in other server side programming languages.

 Why is this, and is there something I can do about it?

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: outputting data in a matrix

2000-10-17 Thread Chapman, Katrina

No Prob.

--K

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 10:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


This worked just great. Thank you.

Richard Colman

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


No offence to anyone but your all making this much more difficult than it
is.

With a little creative HTML you can do this.

CFQUERY name="get_stuff" datasource="katrinachapman"
SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name
/CFQUERY
TABLE
TR
CFOUTPUT query="get_stuff" group="name"
td valign="top"
TABLE
TR
TDb#name#/b
/TD
/TR
CFOUTPUT
TR
TD#title#
/TD
/TR
/CFOUTPUT
/TABLE
/td
/CFOUTPUT
/TR
/TABLE

This is just an example but you don't need to make it more difficult than it
is.  Of course you can modify this so that you only go three across or pull
a certain number of records at a time.  If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.

--K


-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


Richard,

If you're comfortable with using Crystal Reports, give that a try.

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4


where the data table looks like:

category, item, etc.

there will be an unequal number of items per category.

ideas for an approach appreciated. Thank you.

Richard Colman

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Allaire gov't rep?

2000-10-17 Thread David Fauth


Kevin Davis
703 313-4947



-- Original Message --
From: "Park, Simon" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 17 Oct 2000 11:50:04 -0400

I remember from an old CFUG meeting that Allaire has a person who
specifically deals with using ColdFusion for government contracts, answering
questions and allaying fears about security, scalability and such. Does
anyone have the contact info for this person?

Thanks

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park  Computer Systems Management, Inc.
Ph: 703-823-4300 x119   205 South Whiting Street #201
fax: 703-823-4301   Alexandria, VA  22304
 http://www.csmi.com  
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CFFILE ACTION=UPLOAD probs

2000-10-17 Thread Alex Sherwood

At 11:06 AM 10/17/2000 -0700, you wrote:
I am using the below code to upload some text files, if the file has an .csv
extension is will fail the test and get the error, if I just rename the same
file with no extension it works ok.  I though the accept="text/plain" looks
at the file contents not the extension.  Any recommendations on how to get
around this?

Thanks,Adrian


cftry
CFFILE ACTION="UPLOAD" filefield="filename" destination="G:\blah\"
nameconflict="ERROR" accept="text/plain"
CFFILE ACTION="RENAME" source="G:\blah\#File.ServerFile#"
destination="G:\blah\blah.#currentdate#.#currenttime#"
cfcatch type="Any"
cfset success = false
The File Cold NOT Be Uploaded.
Make Sure The File You Are Uploading Is In A Plain Text Format.
/cfcatch
/cftry


MIME types are based on file extesions. I wonder what would happen if you 
tried to setup a MIME type with no extension?

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: access color selection box with CF?

2000-10-17 Thread Doug Powell

?
If your trying to make a select box have color you can use this

cfselect name="whatever" size="1"
  cfoutput query="something"
option value="##" cfif queryname.CurrentRow MOD
2STYLE="background-color:blue;"/cfif
#what you want#
/option
  /cfoutput
/cfselect

-Original Message-
From: Mark Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 1:54 PM
To: CF-Talk
Subject: access color selection box with CF?


Has anyone accessed the windows color select box using CF?

-Mark


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Storing passwords in database as one way hash

2000-10-17 Thread Robert Everland

Why even bother storing a password in a one way hash if it's only gonna be
used one time? 

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 2:32 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


 anybody know of anything that does such?
 I am looking for pretty much the same functionality as a standard
 *NIX login

Look up the function Hash().  I think it was introduced in CF 4.5.
Actually, I just looks at the online cfdocs and don't see it in there, but
it is... maybe introduced in 4.5.1?

There's also a CFX_HASH in the tag gallery that give many more options of
hash types.

-Cameron


Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [Storing passwords in database as one way hash]

2000-10-17 Thread Jon Tillman

Access

On Sat, 22 Nov 2036, [EMAIL PROTECTED] spake thusly:
 what database? MySQL has a password() function that encrypts
 
 Jon Tillman [EMAIL PROTECTED] wrote:
 anybody know of anything that does such?
 I am looking for pretty much the same functionality as a standard *NIX login

-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



win 2000/sql with cf 4.5 PROBLEMS

2000-10-17 Thread andrew kopelman

After upgrading to Windows 2000, I get this interesting situation with SQL 
Server (or ODBC): any table that i create, isn't 'seen'. I get the error: 
Invalid object name 'onetable'. ('Onetable' being the single table I 
created.) If I query one of this same sqlserver database system tables, like 
sysusers, it runs the query without complaint.  Therefore, my 'application' 
is connecting with the database, the databases native tables are seen, any 
new tables are not.

Any ideas? Anybody else having other troubles with SQL on Windows 2000?

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Expand Select Box -- Take Two

2000-10-17 Thread j p

I need to actually 'drop down' the selection options NOT expand the width of 
the select box.

In other words, Click Here, and the select box drops down to display options 
somewhere else on the page.

Jp




From: "Doug Powell" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Expand Select Box (JS Question)
Date: Tue, 17 Oct 2000 14:51:24 -0400

select multiple name=whatever size=10
option value=spacer-/option
/select

to get the size you want and then call a function to get rid
of the lines such as

function clearBlanks() {
  document.something.whatever.options[0] = null;
  document.something.whatever.options[0] = null;
  return true;
}

In the body tag call the function onLoad="clearBlanks()
-Original Message-
From: j p [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 1:37 PM
To: CF-Talk
Subject: Expand Select Box (JS Question)



Is It possible through JS to expand a select box, I need to expand a select
box when someone clicks on something (not the little arrow if the select
box)

JP
_
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.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or 
send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
the body.

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: File replication packages

2000-10-17 Thread Dirk De Bock

WebAgain seems to behave quite nicely at a few sites I manage. It can
replicate both through netbios shares and ftp which gives it the flexibility
to also replicate to remote sites.

- Original Message -
From: "Mark Johnson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 12:15 PM
Subject: OT: File replication packages


 Those of you using server farms and or loadbalancing.  How do you publish
 your CF files to all your servers?  What software are you using to
acomplish
 this?  What should we aviod in implementing a file replication package.

 Mark Johnson
 ---
 Senior Cold Fusion Developer
 Cardinal Communications

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: access color selection box with CF?

2000-10-17 Thread Mark Adams

Actually, I am trying to access the windows color palette via browser. But,
I'm not sure how to call it up.


- Original Message -
From: Doug Powell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 12:03 PM
Subject: RE: access color selection box with CF?


 ?
 If your trying to make a select box have color you can use this

 cfselect name="whatever" size="1"
   cfoutput query="something"
 option value="##" cfif queryname.CurrentRow MOD
 2STYLE="background-color:blue;"/cfif
 #what you want#
 /option
   /cfoutput
 /cfselect

 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 1:54 PM
 To: CF-Talk
 Subject: access color selection box with CF?


 Has anyone accessed the windows color select box using CF?

 -Mark

 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.


 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Multiple row form data submission to database?

2000-10-17 Thread Dharmesh Goel

Hello Everyone,

I am trying to make a small data entry screen in ColdFusion. There are five
columns in the table. Number of rows is dynamically generated with the first
column automatically filled in. Others have to be filled in by a user. When
the user submits the form, each row is inserted in a database as a new row.

I have not done a form submission until now that updates multiple rows. I
hope you can help me with the basic logic involved in this. My guess would
be to insert the data from the form into a 2 dimensional Array and then loop
over the array while inserting into the database. How do I insert it into an
array and proceed from there?

CH1 CH2 CH3 CH4 CH5

-
Field1  Field2  Field3  Field4  Field5
Field1  Field2  Field3  Field4  Field5
Field1  Field2  Field3  Field4  Field5
Field1  Field2  Field3  Field4  Field5
"   "   "   "   "
"   "   "   "   "

Field1 is auto populated with a query result.

Thank you,

Dharmesh Goel
Programmer Analyst
IT Dept. - Discount Car  Truck Rentals
416-744-0123 x290

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



What sort of RegEx does Cold Fusion Support?

2000-10-17 Thread Christopher S Martin

Just a quick question as I prepare to write a tempalte that will (hopefully)
save me days of mindnumbing work:
How well does ColdFuison support Regular Expressions?  Does it use a perl or
perl-ish model, strict POSIX standards, or some weird, homegrown  flavor?
Basically I want to kow if I use a regular expression that works with, say .
. . grep, will it provide the desired functionality?

Thanks,

Chris Martin.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



file upload permissions on a solaris/cf

2000-10-17 Thread Aaron Johnson

Anyone have any pointers or articles on what permissions would be for CF to
handle file uploads on Solaris?

Thanks!

AJ

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Storing passwords in database as one way hash

2000-10-17 Thread Jon Tillman

Who ever said it is going to be used one time?
I need to securely store the passwords for several dozen competing users

On Tue, 17 Oct 2000, Robert Everland spake thusly:
 Why even bother storing a password in a one way hash if it's only gonna be
 used one time? 
 
 Robert Everland III
 Web Developer
 Dixon Ticonderoga
 
 
 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 2:32 PM
 To: CF-Talk
 Subject: RE: Storing passwords in database as one way hash
 
 
  anybody know of anything that does such?
  I am looking for pretty much the same functionality as a standard
  *NIX login
 
 Look up the function Hash().  I think it was introduced in CF 4.5.
 Actually, I just looks at the online cfdocs and don't see it in there, but
 it is... maybe introduced in 4.5.1?
 
 There's also a CFX_HASH in the tag gallery that give many more options of
 hash types.
 
 -Cameron
 
 
 Cameron Childress
 ElliptIQ Inc.
 p.770.460.7277.232
 f.770.460.0963
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: access color selection box with CF?

2000-10-17 Thread Walker, Matthew

 Has anyone accessed the windows color select box using CF?

Yes, I have. I use it for the admin pages in a shopping cart (select product
colour). It's the standard windows colour picker. However, I've only managed
to make it work for Win98 so far. Found virtually no info anywhere -- only
info I found was for using it in VB and the like. Nevertheless, it does work
beautifully for me. 

Send me a note offlist if you want to see it going. 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Verity Command Line Help

2000-10-17 Thread Bryan Martin

Has anyone successfully updated a Verity collection using the MKVDK.exe utility?  I 
have been trying to get it to work without success.  Any help would be greatly 
appreciated.

Bryan Martin
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Include Perl script?

2000-10-17 Thread Ethan Rosch

I am trying to include a poll.cgi perl script into my .cfm page, but I am
having trouble getting the .cgi to parse, read the templates, and spit the
page back to me as an include...

any ideas?

thanks,

ethan

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IP Sort

2000-10-17 Thread Michael Ross

store them in a seperate fieldsuse a list to seperate them

 [EMAIL PROTECTED] 10/13/00 12:52PM 
Look into CAST() or CONVERT() I think you can do this using the CAST()
function.

-Adrian

-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]] 

I have a bunch of IP numbers stored in a VarChar field in SQL7. When I sort
them, it sorts like text, as it should, with not great results. Is there a
quick and easy way to get the IP numbers to sort like a number?


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



No Subject

2000-10-17 Thread Ethan Rosch

This is a multi-part message in MIME format.

--=_NextPart_000_0101_01C0385D.7BE01190
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am trying to include a poll.cgi perl script into my .cfm page, but I =
am
having trouble getting the .cgi to parse, read the templates, and spit =
the
page back to me as an include...

any ideas?

thanks,

ethan





--=_NextPart_000_0101_01C0385D.7BE01190
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.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff background=3D""
DIVFONT face=3DArial size=3D2I am trying to include a poll.cgi perl =
script into=20
my .cfm page, but I amBRhaving trouble getting the .cgi to parse, read =
the=20
templates, and spit theBRpage back to me as an include...BRBRany=20
ideas?BRBRthanks,BRBRethan/FONT/DIV
DIVFONT face=3DArialBRFONT size=3D2/FONT/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML

--=_NextPart_000_0101_01C0385D.7BE01190--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Include Perl script?

2000-10-17 Thread Owens, Howard


Two thoughts ... 

One, instead of using .cfm pages ... try using .shtml and a regular server
side include ... call any CF templates into the .shtml page that you might
need via the same include style.  I call .cfm pages into .shtml quite
regularly.

Two, if you can't get your CGI working, there are a couple of nice custom
tag polls in the custom tag gallary on the Allaire site.

H.

=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=

 -Original Message-
 From: Ethan Rosch [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 2:03 PM
 To:   CF-Talk
 Subject:  Include Perl script?
 
 I am trying to include a poll.cgi perl script into my .cfm page, but I am
 having trouble getting the .cgi to parse, read the templates, and spit the
 page back to me as an include...
 
 any ideas?
 
 thanks,
 
 ethan
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



locking with IsDefined

2000-10-17 Thread sebastian palmigiani

When testing for the existence of a session variable such as:

IsDefined("Session.Login")

do you need to use a lock around it?

-
Sebastian

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



HNC Software opinions?

2000-10-17 Thread Nat Papovich

All voiced opinions appreciated, preferably off-list, from both a client and
employee perspective.

TIA

Nat Papovich
ICQ 32676414
"If it was hard to write," 
says the Real Programmer,
"it should be hard to understand."

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



(Admin) Ads

2000-10-17 Thread Michael Dinowitz

I plan to start adding a three line ad at the bottom of the CF-Talk posts
(above the unsubscribe/archive info). The money for this will go to support
of the various lists, expanding the abilities of them (much better
archives), and more. Any feedback, suggestions, or complaints should be sent
to me off list.
Just as a side note, the ads will be limited to tech and CF using companies
only and your user information (email, etc.) will never be given out.

Michael Dinowitz
Publisher - The Fusion Authority (www.fusionauthority.com/alert)
ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc.
(www.houseoffusion.com)


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: File replication packages

2000-10-17 Thread Dirk De Bock

did you try http://www.webagain.com/

also google gives 8 valid links in the first 10 links it returns :-)

the company website is at www.lockstep.com

but sorry for not providing a direct link in the first mail

- Original Message - 
From: "Paul's Mail" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 11:33 PM
Subject: RE: File replication packages


 Where can I find the WebAgain web site? My search turned up nothing.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: win 2000/sql with cf 4.5 PROBLEMS

2000-10-17 Thread Marius Milosav

Check to see if your ODBC connection is setup to connect to your database.
By default when you create a new ODBC datasource it connects the master
database. Probably that is the reason you are seeing the system tables.

Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: "andrew kopelman" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 3:57 PM
Subject: win 2000/sql with cf 4.5 PROBLEMS


 After upgrading to Windows 2000, I get this interesting situation with SQL
 Server (or ODBC): any table that i create, isn't 'seen'. I get the error:
 Invalid object name 'onetable'. ('Onetable' being the single table I
 created.) If I query one of this same sqlserver database system tables,
like
 sysusers, it runs the query without complaint.  Therefore, my
'application'
 is connecting with the database, the databases native tables are seen, any
 new tables are not.

 Any ideas? Anybody else having other troubles with SQL on Windows 2000?

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

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: locking with IsDefined

2000-10-17 Thread Dave Watts

 When testing for the existence of a session variable such as:
 
 IsDefined("Session.Login")
 
 do you need to use a lock around it?

Yes. It's a read. It needs to be locked.

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Preventing Simultaneous Logins

2000-10-17 Thread Peter Alexandrou

Hi guys,

I'm new to the mailing list and have a quick question for y'all.

What is the best way to prevent a userID being logged in twice i.e. someone
logs in with "login1" and then another user logs in with the same ID.

Thanks,

Peter Alexandrou
Technical Leader

tapestry communications : www.tapestry.net.au
phone : 0411 445 111
e-mail : [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Storing passwords in database as one way hash

2000-10-17 Thread Dave Watts

 But if it's a one way hash, why do you need to store it, you 
 can't decrypt it. What is the purpose?

The purpose of using a one-way hash is to allow password comparisons without
actually sending the password itself over the network. Whenever you hash a
specific password, you get the same hash result. So, if I hash my password,
then send you the hash, and you store it, you can later compare it to
another hash of the same password. If they match, the password is obviously
the same.

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: locking with IsDefined

2000-10-17 Thread John McKown

I may be wrong, but my understanding is that reads do not need a lock,
only writes.

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



 -Original Message-
 From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 5:45 PM
 To: CF-Talk
 Subject: locking with IsDefined


 When testing for the existence of a session variable such as:

 IsDefined("Session.Login")

 do you need to use a lock around it?

 -
 Sebastian

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



CF_MENSCH Awards

2000-10-17 Thread Adam Phillip Churvis

FusionFolks,

I would like to propose an annual award for the most helpful people in the
CF community.  The name I picked for this award is CF_MENSCH, because a
"Mensch" is a really caring person who treats others with respect, who
performs acts of kindness, and who tries to make the community a better place.

The people I would like to nominate are:

Michael Dinowitz
Dave Watts
Cameron Childress

I see some really outstanding advice and help coming from these folks (any
many others, to be sure), so I think we ought to "brand" them accordingly!

There are so many who help, and my list contains only those who stick out
in my mind most prominently, so I hope others will add their nominations, too.

What do you think, folks?

Respectfully,

Adam Phillip Churvis
President
Productivity Enhancement, Inc.


*  PRODUCTIVITY ENHANCEMENT, INC.  *
*  *
*Publishers of the CommerceBlocks line of modular development tools*
*  for ColdFusion  *
*  *
* Website: http://www.commerceblocks.com   E-mail: [EMAIL PROTECTED] *
* Phone:   770-446-8866Fax:770-242-0410*
*  *



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Storing passwords in database as one way hash

2000-10-17 Thread Norman Elton

Bob-

You store the password hashed. You're right, you can't decrypt it. When
someone attempts to login to the system, you hash their attempted password.
If that matches the hashed password in the database, then they're in. If
not, whatever they typed doesn't match the "dehashed" value in the database.

This allows you to authenticate users, but guarantee that nobody can "read"
their password.

Norman Elton
Information Technology
College of William  Mary

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 5:55 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


But if it's a one way hash, why do you need to store it, you can't decrypt
it. What is the purpose?


Bob Everland

-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 4:39 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


Who ever said it is going to be used one time?
I need to securely store the passwords for several dozen competing users

On Tue, 17 Oct 2000, Robert Everland spake thusly:
 Why even bother storing a password in a one way hash if it's only gonna be
 used one time?

 Robert Everland III
 Web Developer
 Dixon Ticonderoga


 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 2:32 PM
 To: CF-Talk
 Subject: RE: Storing passwords in database as one way hash


  anybody know of anything that does such?
  I am looking for pretty much the same functionality as a standard
  *NIX login

 Look up the function Hash().  I think it was introduced in CF 4.5.
 Actually, I just looks at the online cfdocs and don't see it in there, but
 it is... maybe introduced in 4.5.1?

 There's also a CFX_HASH in the tag gallery that give many more options of
 hash types.

 -Cameron

 
 Cameron Childress
 ElliptIQ Inc.
 p.770.460.7277.232
 f.770.460.0963

 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: locking with IsDefined

2000-10-17 Thread Patricia Lee

Yes.  Because in order to check to see if said session variable isdefined,
CF must attempt a read of the variable.  Hence, a READONLY lock is required.

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 5:45 PM
To: CF-Talk
Subject: locking with IsDefined


When testing for the existence of a session variable such as:

IsDefined("Session.Login")

do you need to use a lock around it?

-
Sebastian


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Storing passwords in database as one way hash

2000-10-17 Thread Chapman, Katrina

The purpose is to keep people from peeking in the db and getting pw's they
shouldn't have.  

Hash() works great.  We used it on a project that I worked on before.
Unfortunately you have to have CF Server 4.5.1 to use it the way that I
believe it was intended.

--K

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 2:55 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


But if it's a one way hash, why do you need to store it, you can't decrypt
it. What is the purpose?


Bob Everland

-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 4:39 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


Who ever said it is going to be used one time?
I need to securely store the passwords for several dozen competing users

On Tue, 17 Oct 2000, Robert Everland spake thusly:
 Why even bother storing a password in a one way hash if it's only gonna be
 used one time?

 Robert Everland III
 Web Developer
 Dixon Ticonderoga


 -Original Message-
 From: Cameron Childress [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 2:32 PM
 To: CF-Talk
 Subject: RE: Storing passwords in database as one way hash


  anybody know of anything that does such?
  I am looking for pretty much the same functionality as a standard
  *NIX login

 Look up the function Hash().  I think it was introduced in CF 4.5.
 Actually, I just looks at the online cfdocs and don't see it in there, but
 it is... maybe introduced in 4.5.1?

 There's also a CFX_HASH in the tag gallery that give many more options of
 hash types.

 -Cameron

 
 Cameron Childress
 ElliptIQ Inc.
 p.770.460.7277.232
 f.770.460.0963

 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



  1   2   >