Re: fusebox stats

2000-09-08 Thread Graham Lewis

I had a similar problemwith an application I built last year.  It wasn't 
entirely fusebox but it did always call the same index.cfm.  What I 
did was log the variables in a table ie I recorded the state whenever 
index.cfm was called.  So if we go 
index.cfm?action=redframes=yes and SESSION.people is "fred"
I just log all those variables.

Bit of a quick fix but it works

Graham

On 7 Sep 00, at 14:28, Jason Egan wrote:

 I think fusebox is cool, but I've gotten myself in some hot water here... I
 created a nice application for a customer using fusebox.  Now, they would
 like to get stat reports on it... well... because you're always going to the
 same page and including the others all of the stats come back as hits
 against the main index.cfm page, not the actual page that was hit.
 
 How on earth do I track these pages individually?  How can I tell how many
 people looked at the contact page, or the support page or whatever??
 
 Thanks for any ideas...
 
 je
 
 --
 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.



Escaping commas in a query

2000-09-08 Thread Colin Robinson

Could someone please tell me how to esape a comma in SQL


Thankyou

 
Colin Robinson
In-tuition.co.uk
Tel: +44 (0) 1825 746400
ICQ: 74207528

--
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: Escaping commas in a query

2000-09-08 Thread JustinMacCarthy

look at the PerserveSingleQuotes function...

- Original Message -
From: "Colin Robinson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 3:24 PM
Subject: Escaping commas in a query


 Could someone please tell me how to esape a comma in SQL


 Thankyou


 Colin Robinson
 In-tuition.co.uk
 Tel: +44 (0) 1825 746400
 ICQ: 74207528

 --

 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: Operation must use an updateable query

2000-09-08 Thread DeVoil, Nick

 I have a very simple CF app that is using an MS Access 2000 file as the
 datasource. The app works fine on my system, but when it is uploaded to
 the hosting provider, I get an "Operation must use an updateable query"
 error on a page that inserts information from a form.


Rob,

You wouldn't guess it from the message but I think this is a permissions
problem. The app needs "change" permission on the mdb file and the
folder it's in.

Nick
 


**
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: Simple query question

2000-09-08 Thread DeVoil, Nick


 I don't know how to select records between 100 to 200 records.

Try this

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


**
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: fusebox stats

2000-09-08 Thread Chris Hayes

Never touched Fusebox yet but I believe the
idea is to use variables appended to the URL like so:

mypage.cfm/var_name1,value/var_name2,value/var_name3,value

Then strip these variables from the server variable SCRIPT_NAME and plug
then into your fusebox.

Search engines and stats packages like Webtrends are happy to index these
URLs, allegedly.

HTH
--

Chris Hayes

London Web Communications
69 Ballards Lane
London
N3 1LW

Email: [EMAIL PROTECTED]
Web: http://corp.londonweb.net/
Tel: +44 (0)20 8349 4500
Fax: +44 (0)20 8349 4488

- Original Message -
From: Jason Egan [EMAIL PROTECTED]
To: Cf-Talk [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 9:28 PM
Subject: fusebox stats


 I think fusebox is cool, but I've gotten myself in some hot water here...
I
 created a nice application for a customer using fusebox.  Now, they would
 like to get stat reports on it... well... because you're always going to
the
 same page and including the others all of the stats come back as hits
 against the main index.cfm page, not the actual page that was hit.

 How on earth do I track these pages individually?  How can I tell how many
 people looked at the contact page, or the support page or whatever??

 Thanks for any ideas...

 je

 --

 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: fusebox stats

2000-09-08 Thread Ben Lowndes

I'd take it a step further and say it isn't efficent to a DB insert for
every page hit. It would be better to load the fuseaction, CFID, CFToken 
whatever else you want into an application scoped structure. Then on a daily
basis insert this structure into a DB and empty it..

Infact, I believe some people on the Fusebox mailing list are working on a
project that does precisely this.

Ben.

-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: 07 September 2000 23:59
To: '[EMAIL PROTECTED]'
Subject: RE: fusebox stats


The easiest thing to do is have a db with a table called logs, with the page
name as the ID and increment this each time this page is called before the
cflocation/cfinclude its that simple:-)


regards

Andrew Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]


-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: 08 September 2000 07:29
To: Cf-Talk; [EMAIL PROTECTED]
Subject: fusebox stats


I think fusebox is cool, but I've gotten myself in some hot water here... I
created a nice application for a customer using fusebox.  Now, they would
like to get stat reports on it... well... because you're always going to the
same page and including the others all of the stats come back as hits
against the main index.cfm page, not the actual page that was hit.

How on earth do I track these pages individually?  How can I tell how many
people looked at the contact page, or the support page or whatever??

Thanks for any ideas...

je


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



Javascript question!...sorry

2000-09-08 Thread Andy Ewings

Again... I know I shouldn't ask this here but

does anybody know if it is possible to have a mouseover on a form submit
button (INPUT Type="image").  

I have got my mouseovers working for hyperlinks ok but can't get ot to work
for images acting as submit buttons on forms.

My java script is very average at the best of timesyour help is
apprecited!!

Andy
--
Andrew Ewings
Project Manager
Thoughtbubble 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: OT: Java Script Question

2000-09-08 Thread JustinMacCarthy

 your database beforehand and (using WDDX) make it available to your JS so
 that you can do the check right there on the client, without having to
hit

the problem with that is anyone can get a list of your usernames  just
by looking at the source

~Justin MacCarthy

--
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: Javascript question!...sorry

2000-09-08 Thread JustinMacCarthy

not possible , but you can do


a href="javascript:document.forms[0].submit();"img src=""
onmouseover="changeImage();"/a

to the same affect, or something like that



~Justin MacCarthy

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 1:07 PM
Subject: Javascript question!...sorry


 Again... I know I shouldn't ask this here but

 does anybody know if it is possible to have a mouseover on a form submit
 button (INPUT Type="image").

 I have got my mouseovers working for hyperlinks ok but can't get ot to
work
 for images acting as submit buttons on forms.

 My java script is very average at the best of timesyour help is
 apprecited!!

 Andy
 --
 Andrew Ewings
 Project Manager
 Thoughtbubble 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.



--
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: OT: Java Script Question

2000-09-08 Thread Courtney Payne

This is true.  However, I wouldn't think usernames would be considered
sensitive info.

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


-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:09 AM
To: [EMAIL PROTECTED]
Subject: Re: OT: Java Script Question


 your database beforehand and (using WDDX) make it available to your JS so
 that you can do the check right there on the client, without having to
hit

the problem with that is anyone can get a list of your usernames  just
by looking at the source

~Justin MacCarthy


--
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: fusebox stats

2000-09-08 Thread Fred T. Sanders

What stat's program are you using?

- Original Message -
From: "Jason Egan" [EMAIL PROTECTED]
To: "Cf-Talk" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 4:28 PM
Subject: fusebox stats


 I think fusebox is cool, but I've gotten myself in some hot water here...
I
 created a nice application for a customer using fusebox.  Now, they would
 like to get stat reports on it... well... because you're always going to
the
 same page and including the others all of the stats come back as hits
 against the main index.cfm page, not the actual page that was hit.

 How on earth do I track these pages individually?  How can I tell how many
 people looked at the contact page, or the support page or whatever??

 Thanks for any ideas...

 je

 --

 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: Javascript question!...sorry

2000-09-08 Thread Courtney Payne

Hey Andy,

It just worked on my end.  Can you post your code?

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


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:26 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript question!...sorry


Yeh this works with hyperlinks but doesn't seem to work with images as
submit buttons unless I'm doing something wring.  Have you got it to work?

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Courtney Payne [mailto:[EMAIL PROTECTED]]
Sent: 08 September 2000 13:23
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript question!...sorry


Something like this should work:

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
!--
function change(that) {
that.src = 'image2.jpg';
}

function changeback(that) {
that.src = 'image1.jpg';
}
//--
/SCRIPT


.
.
.

form
input type="image" onmouseout="changeback(this)"
onmouseover="change(this)" name="theButton" src="image1.jpg"
/form


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


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:07 AM
To: CFTalk (E-mail)
Subject: Javascript question!...sorry


Again... I know I shouldn't ask this here but

does anybody know if it is possible to have a mouseover on a form submit
button (INPUT Type="image").  

I have got my mouseovers working for hyperlinks ok but can't get ot to work
for images acting as submit buttons on forms.

My java script is very average at the best of timesyour help is
apprecited!!

Andy
--
Andrew Ewings
Project Manager
Thoughtbubble 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.

--
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: Javascript question!...sorry

2000-09-08 Thread DeVoil, Nick

 Yeh this works with hyperlinks but doesn't seem to work with images as
 submit buttons unless I'm doing something wring.  Have you got it to work?

Hi Andy,

I think, as Justin implied, the secret is to have the image just be an
IMG not an INPUT and get the submit behaviour by calling submit()
explicitly

Nick


**
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: OT: Java Script Question

2000-09-08 Thread Fred T. Sanders

Courtney,

I hope your not suggesting they run a query of usernames and passwords, or
even just the user names for that matter.  They would be viewable in source.
You might say "well its just usernames big deal".  Okay I've now got a list
of user names I know are on the system, I fire up my Shadow HackNCrack
program, give it my nifty new list of usernames and point it to one of the
many dictionairy files I have for passwords and use the http crack module
and brute force the website.  NOT only do I have a high degree of certainty
that I'll eventually get in,  I'm now generating 10s of 1000s of hits on the
server draining resources from use by others gaining the added benefit of
hacking your site AND performing a very mild DOS attack as after effect
there by slowing down the rest of the site for others, even if only by a
small degree.

Disclaimer:  I uhh don't have any of the above mentioned dictionary files
and would never dream of doing the above mentioned techniques to anything
but my own boxes.  The names of software mentioned above was not changed, he
lives in a foreign company and could probably use the business, although I'm
not going to give a link to their site, even though the software is only $25
American for the "Shadow Advanced Network Tools", the "Shadow Advanced Local
Tools" and the "Shadow HackandCrack" software suite.  I also won't mention
their Shadow Security Scanner either, which just went up to $100.


The point is security is ALWAYS and issue, because as much as we'd all like
to believe there really is no such thing as security, no matter how much
we'd like to believe there is, but that's not an excuse to make it easy for
them.

Fred
- Original Message -
From: "Courtney Payne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 8:05 AM
Subject: RE: OT: Java Script Question


 DD,

 Just as a side note, you'll *have* to go back to the server (ie. your
action
 page) to query and check login names unless, on your form page, you query
 your database beforehand and (using WDDX) make it available to your JS so
 that you can do the check right there on the client, without having to hit
 the server first.  For what you're trying to do, though, the code provided
 will solve your issue just fine (would be placed on your action page).

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


 -Original Message-
 From: Peter Theobald [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 07, 2000 11:07 PM
 To: [EMAIL PROTECTED]; House Of Fusion
 Subject: Re: OT: Java Script Question



script
 !--
 alert("Username taken, please try another")
 history.back(1)
 // --
 /script

 At 01:25 PM 9/7/00 -0700, Double Down wrote:
 I would like to flash a java script alert box saying that a login name is
 already in use. This will happen on the submit and it will go to the
action
 page to check the db. My question is can I have the alert box pop up on
the
 form page so the person does not have to go back and re-enter all of
their
 information. How do I do this?
 
 
 
 TIA
 DDINC
 
 

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

 --
--
 --
 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: REGEX for a space

2000-09-08 Thread Olive, Christopher M Mr NMR

why don't you treat each line as a space delimited list?  loop over it and
stick the appropriate variables in.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Andrea Wasik(CancerSource) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 3:46 PM
To: [EMAIL PROTECTED]
Subject: REGEX for a space


I am looping over a list that contains the names of mailing lists. The
delimiter in the loop is the carriage return. I am trying to identify the
position of the first space in the index. I thought the regex for a space
was /s, but that is not working here as the REFind always returns a zero.
This is what one line of the list looks like:

BREASTCANCER 1999-12-30 0 0 0 0 0 0 0 0

and here is my code:

cfloop list="#logfile#" delimiters="#Chr(13)##Chr(10)#" index="line" 
cfset linelength = Len(line)
cfset CurrentlistwordSTART = REFind('([A-Za-z]+)', line, "TRUE") 
cfset SpacePositionAfterFirstWord = REFind('\s+', line)   
SpacePositionAfterFirstWord:
cfoutput#SpacePositionAfterFirstWord#/cfoutputbr
cfset daypositionstart = SpacePositionAfterFirstWord + 1
cfset daypositionend  = daypositionstart + 10
cfset CurrentListList = Left(line, linelength)
cfset CurrentList = Left(line, SpacePositionAfterFirstWord -1)
cfset currentday = Mid(line, daypositionstart, daypositionend)
CurrentDay: cfoutput#currentday#/cfoutputbr
/cfloop

I don't really need the currentlistwordStart variable since the word is
always the first thing on each new line. My problem is the 2nd REFind:
REFind('\s+', line), which always gives me a zero.

The files I am parsing are the ListServ log files, in case anyone is
curious. They don't have any type of log analysis available so I am trying
to create my own.

Thanks

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

2000-09-08 Thread Olive, Christopher M Mr NMR

um...you do understand that client and session variables rely on cookies,
right?  specifically, CFID and CFTOKEN.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 4:43 PM
To: '[EMAIL PROTECTED]'
Subject: RE: 


Well I am gonna say this before everyone else does. DON'T USE
COOKIES. They are unreliable and they don't have a good rep. Either use
session variables or client variables. 

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Powers, Bonnie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 2:45 PM
To: '[EMAIL PROTECTED]'
Subject: 


I have a question about Cookies and SSL on Netscape.

I have almost finished my shopping cart, but when my users were testing,
there was a problem. It seems that Netscape won't allow pages on the SSL
part of the server to use the Cookies generated by the non-SSL section of
the server. Everything works OK in IE.

Directory structure

webroot
 racbp(beginning of shopping cart)
  1.cfm 
  2.cfm
  3.cfm
  ...
  application.cfm(writes two cookies Customer_ID and Order_ID)

 secure
  racbp(secure section of shoppingcart)
  4.cfm
  5.cfm
  6.cfm

1. I thouhgt that I could just move the application.cfm to the webroot
directory, but then what do i do when I need to write another application
that would have the same problem

2. I could put the entire shopping cart app in the SSL folder

3. I could pass the Cookies as variables from page 3.cfm to page 4.cfm anf
have page 4 write cookies from the SSl server. Then I will have to identical
sets of cookie and I will have to delete them twice.

4. Every CF developer must have the same problem and there must be an
industry standard fix... but I don't know what it is which is why I am
contacting you.


Any help would be much appreciated,
Bonnie 

--
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: Javascript question!...sorry

2000-09-08 Thread Courtney Payne

Again, creating a mouseover on a form submit button (of type image) is very
much doable.  All you're doing is changing the object's (the submit button)
.src attribute.

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


-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:35 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript question!...sorry


 Yeh this works with hyperlinks but doesn't seem to work with images as
 submit buttons unless I'm doing something wring.  Have you got it to work?

Hi Andy,

I think, as Justin implied, the secret is to have the image just be an
IMG not an INPUT and get the submit behaviour by calling submit()
explicitly

Nick


**
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.
--
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: OT: Java Script Question

2000-09-08 Thread JustinMacCarthy

Really, ask any email spammer!! If a have the memberlist of foo.com , I
probably have the email address ie [EMAIL PROTECTED] etc..

Also having a username is half the battle of finding a username/password
pair

consider this

cfloop list="#usernamelist#" index=i

cfhttp url=loginform.cfm
cfparam name=username value="#i#"
cfparam name=username value="password"
/cfhttp

/cfloop

or similar..

See what I mean 

~Justin MacCarthy

 This is true.  However, I wouldn't think usernames would be considered
 sensitive info.

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


 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 8:09 AM
 To: [EMAIL PROTECTED]
 Subject: Re: OT: Java Script Question


  your database beforehand and (using WDDX) make it available to your JS
so
  that you can do the check right there on the client, without having to
 hit

 the problem with that is anyone can get a list of your usernames  just


--
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: OT: Java Script Question

2000-09-08 Thread Courtney Payne

Fred, we weren't given any background info on the app.  The implications
would be different if you're logging in to your web-based email acct than it
would be if you're logging in to your eTrade trading account, of course.

All good points Fred.  Anything is possible.  (Sidenote, if I had the
persistance to go through the process you described, I'd get in anyway --
with or without the usernames.)   ;-)

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


-Original Message-
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:43 AM
To: [EMAIL PROTECTED]
Subject: Re: OT: Java Script Question


Courtney,

I hope your not suggesting they run a query of usernames and passwords, or
even just the user names for that matter.  They would be viewable in source.
You might say "well its just usernames big deal".  Okay I've now got a list
of user names I know are on the system, I fire up my Shadow HackNCrack
program, give it my nifty new list of usernames and point it to one of the
many dictionairy files I have for passwords and use the http crack module
and brute force the website.  NOT only do I have a high degree of certainty
that I'll eventually get in,  I'm now generating 10s of 1000s of hits on the
server draining resources from use by others gaining the added benefit of
hacking your site AND performing a very mild DOS attack as after effect
there by slowing down the rest of the site for others, even if only by a
small degree.

Disclaimer:  I uhh don't have any of the above mentioned dictionary files
and would never dream of doing the above mentioned techniques to anything
but my own boxes.  The names of software mentioned above was not changed, he
lives in a foreign company and could probably use the business, although I'm
not going to give a link to their site, even though the software is only $25
American for the "Shadow Advanced Network Tools", the "Shadow Advanced Local
Tools" and the "Shadow HackandCrack" software suite.  I also won't mention
their Shadow Security Scanner either, which just went up to $100.


The point is security is ALWAYS and issue, because as much as we'd all like
to believe there really is no such thing as security, no matter how much
we'd like to believe there is, but that's not an excuse to make it easy for
them.

Fred
- Original Message -
From: "Courtney Payne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 8:05 AM
Subject: RE: OT: Java Script Question


 DD,

 Just as a side note, you'll *have* to go back to the server (ie. your
action
 page) to query and check login names unless, on your form page, you query
 your database beforehand and (using WDDX) make it available to your JS so
 that you can do the check right there on the client, without having to hit
 the server first.  For what you're trying to do, though, the code provided
 will solve your issue just fine (would be placed on your action page).

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


 -Original Message-
 From: Peter Theobald [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 07, 2000 11:07 PM
 To: [EMAIL PROTECTED]; House Of Fusion
 Subject: Re: OT: Java Script Question



script
 !--
 alert("Username taken, please try another")
 history.back(1)
 // --
 /script

 At 01:25 PM 9/7/00 -0700, Double Down wrote:
 I would like to flash a java script alert box saying that a login name is
 already in use. This will happen on the submit and it will go to the
action
 page to check the db. My question is can I have the alert box pop up on
the
 form page so the person does not have to go back and re-enter all of
their
 information. How do I do this?
 
 
 
 TIA
 DDINC
 
 

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

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

Re: RE:

2000-09-08 Thread Howie Hamlin

But the session vars (CFID and CFToken) can be in the URL as well...thus
avoiding cookies.

Regards,

Howie

- Original Message -
From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 8:50 AM
Subject: RE:


 um...you do understand that client and session variables rely on cookies,
 right?  specifically, CFID and CFTOKEN.

 Chris Olive,
 DOEHRS Website Administrator



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



ISP Recs

2000-09-08 Thread John Allred

I know this pops up all the time, but I wonder if I couldn't get some recommendations 
on a good Cold Fusion ISP. The time has come for me to move on, and I'd like to hear 
from any of you who feel positive enough about your ISP to recommend them. Please 
respond off list, thanks.

Criteria:
Relatively inexpensive
Full CF support and expertise
Courteous in handling problems
Little or no server down time
Two pluses would be  a) a host that caters to fusebox sites without charging for 
custom tag installation (or which allows user to install his/her own), and b) little 
or no charge for ODBC dsn setup, or facility to allow user to do it.

Thanks,
--John Allred
--
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: PROBLEM with ALLAIRE CUSTOMER SERVICE ?

2000-09-08 Thread Yanik Lupien

I don't want free support, I just want to know when the Custom tag I
submited to the "Developers Exchange" will be online ?
It's suppose to take 48 Hours to be online and now it's been 10 days (80
Hours of working Day (8 Hours by day))
I never received any answer! And I sent 2 messages to the
([EMAIL PROTECTED]) mail box !

Yanik Lupien



- Original Message -
From: "Steve Pierce" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 3:11 PM
Subject: RE: PROBLEM with ALLAIRE CUSTOMER SERVICE ?


 If you are trying to get free support then I agree, your expectation level
 is too high. Microsoft doesn't offer free support, neither does Oracle,
IBM,
 Sun or most other database integration companies. Allaire shouldn't be
 expected to behave any differently. If you can't solve the problem with
 Allaire Forums or CF_Talk, then pay for the support call and move on. How
 much lost time and money did you lose waiting nine days? $100 to $200 for
a
 support call is a very good value. Pay it, and move on soldier. g

  - Steve

 Steve Pierce, HDL
 "Co-Location starting $99 per month, no setup fee"
 (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com





 -Original Message-
 From: Marcus [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 07, 2000 1:03 PM
 To: [EMAIL PROTECTED]
 Subject: RE: PROBLEM with ALLAIRE CUSTOMER SERVICE ?


  Does anyone have tried to contact Allaire Customer support ?
 
  I tryed many times, for the past 9 days and I never received any
  answer form
  Allaire Company!
 
  Am I the only one facing this problem?

 I have been... When I finally was contacted by someone at Allaire, it
wasn't
 a tech support person trying to fix the problem. It was instead a salesman
 trying to sell me a $28,000 support package from Allaire. And when I
 commented that I didn't appreciate someone trying to sell me support when
I
 was still trying to resolve an issue, I was told that Allaire needed to
make
 money.

 Marcus


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

2000-09-08 Thread Marla Jenkins

I'm hoping someone can help me...I am using CF 4.5.1 and need to find a way
to have CF encrypt and decrypt files using PGP 6.5.8.  I tried using
CFEXECUTE to run pgp.bat and pgp.exe but it reacts in one of two ways - 1)
kicks me out of the browser window or 2) error message that says it cannot
execute the exe or bat file.  Even if I got it to run one of the files, I
don't think I can pass the pgp decrypt statement through the arguments
attribute to a DOS prompt.  Does anyone have any suggestions on how I can
get CF and PGP to work together?  I need to use this version of PGP because
it's the only one I can find that works on both NT and HPUX.

Thanks in advance for any help!

Marla Jenkins
Web Developer
Hurd IT Communications
http://www.hurdit.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: Javascript question!...sorry

2000-09-08 Thread Andy Ewings

Ok got it to work now - I have changed it to an Image tag rather than an
Input tag and used the onclick event to submit the form.  Thanks for all
your help guys!

One more question though - what if I've got two images like this that both
submit the form?how do I test to see which one was clicked?

Andy

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Andy Ewings 
Sent: 08 September 2000 13:26
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript question!...sorry


Yeh this works with hyperlinks but doesn't seem to work with images as
submit buttons unless I'm doing something wring.  Have you got it to work?

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Courtney Payne [mailto:[EMAIL PROTECTED]]
Sent: 08 September 2000 13:23
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript question!...sorry


Something like this should work:

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
!--
function change(that) {
that.src = 'image2.jpg';
}

function changeback(that) {
that.src = 'image1.jpg';
}
//--
/SCRIPT


.
.
.

form
input type="image" onmouseout="changeback(this)"
onmouseover="change(this)" name="theButton" src="image1.jpg"
/form


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


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:07 AM
To: CFTalk (E-mail)
Subject: Javascript question!...sorry


Again... I know I shouldn't ask this here but

does anybody know if it is possible to have a mouseover on a form submit
button (INPUT Type="image").  

I have got my mouseovers working for hyperlinks ok but can't get ot to work
for images acting as submit buttons on forms.

My java script is very average at the best of timesyour help is
apprecited!!

Andy
--
Andrew Ewings
Project Manager
Thoughtbubble 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.

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

2000-09-08 Thread Howie Hamlin

Cookies are no more secure than URL params if you're worried about
"sniffing".  Both are sent to the web server as plain text.  The URL
parameters are in the GET or POST clause while the cookies are in a COOKIE
header.  In both cases, though, you can create a server side var which
includes the browser IP address if you want to make things more secure (so
that another browser would not be able to use hijack the session).

Regards,

Howie

- Original Message -
From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 9:35 AM
Subject: RE:


 right.

 i'll wrap my reply to you and mr hanlin into one response.

 the USUALLY rely on cookies.  as in, this is the default behaviour.  one
has
 to add code to get them to be passed in the URL.

 perhaps i'm paranoid, but i prefer the cookie method from a security
 standpoint.  it's too easy to sniff a URL and snatch someone's ID that
way.
 spoofing a session becomes as easy as writing to a text file.

 Chris Olive,
 DOEHRS Website Administrator

 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 9:14 AM
 To: [EMAIL PROTECTED]
 Subject: Re:


 Eh... no they don't , you can use CFID , CFTOKEN (UrlToken) in the URL
 instead..

 They CAN use cookies , but that is something different...

 ~Justin MacCarthy

 From: "Olive, Christopher M Mr NMR"

  um...you do understand that client and session variables rely on
cookies,
  right?  specifically, CFID and CFTOKEN.


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



Introduction + logging question...

2000-09-08 Thread Jaquet Digital Design

Hi there,

My name is Erik-Jan Jaquet and I am a Dutch web developer. I recently
started programming in ColdFusion and joined this list. This is my first
posting.

I am building a website with ColdFusion that requires people to log in
before they can search a database with (links to) PDF files. When they found
a file, they can then download it to their computer. It is a Extranet, so
only clients of the company have access to the database.

The company would like to know who logs in, how often and which files they
download, for marketing purposes.

How can I register which users have logged in, how many times and the file
download info? Or do programs like Webtrends also have the possibility to
give that information.

Thanks in advance,

Erik-Jan Jaquet
Jaquet Digital Design

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

2000-09-08 Thread JustinMacCarthy

Except when your users turns them off.

 misused them.  He also said using cookies was as good as using session
 variables. 


~Justin 

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

2000-09-08 Thread JustinMacCarthy

There is a cfx_pgp tag on allaires site in the tag gallery

~Justin


- Original Message -
From: "Marla Jenkins" [EMAIL PROTECTED]
To: "'Cf-Talk" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 10:00 AM
Subject: CF and PGP


 I'm hoping someone can help me...I am using CF 4.5.1 and need to find a
way
 to have CF encrypt and decrypt files using PGP 6.5.8.  I tried using
 CFEXECUTE to run pgp.bat and pgp.exe but it reacts in one of two ways - 1)
 kicks me out of the browser window or 2) error message that says it cannot
 execute the exe or bat file.  Even if I got it to run one of the files, I
 don't think I can pass the pgp decrypt statement through the arguments
 attribute to a DOS prompt.  Does anyone have any suggestions on how I can
 get CF and PGP to work together?  I need to use this version of PGP
because
 it's the only one I can find that works on both NT and HPUX.

 Thanks in advance for any help!

 Marla Jenkins
 Web Developer
 Hurd IT Communications
 http://www.hurdit.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: Web servers

2000-09-08 Thread Benjamin S. Rogers

We switched servers as well, but they were comparable. We had about 250 Web
sites on a box running WebSite Pro. All the Web sites were running
ColdFusion in some form or another; most had static content as well. 10 to
20 had SSL certs. We switched to a box running IIS and saw "tremendous"
performance gains. The switch was an interim solution: we've since
redistribute the sites to many servers as they are too highly trafficked to
all be on a single server.

Like I said before, I can't back that up with stats. We were not expecting a
performance gain. This was about a year and a half ago. I can't even tell
you what the server config was. But I can tell you that quickly became a
believer in IIS. If you need some stats, here's the ZDNet tests someone else
mentioned:

http://www.zdnet.com/pcmag/stories/firstlooks/0,6763,305867,00.html

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


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 8:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Web servers


On 9/7/00, Steve Pierce penned:
IIS is a great product and you can't beat the price. But if you need
carrier
class reliability and scalability and can use CF instead of ASP 3, Website
is a pretty good solution.

OK, thanks. Everything you said is about what I've heard. Of course,
I heard most of it from you. LOL

I was just concerned that Benjamin said he saw a "tremendous
performance gain" switching from WS to IIS. I'm still wondering why.
I do know that I've got a lowly 512 K connection with about 70 static
sites and about 20 CF sites and the CF sites are "at least" twice as
fast under WS on mine as they were under IIS on Intermedia. Of
course, that would probably change if I put hundreds of CF sites on
the server, which I won't do.

The static sites aren't noticeably slower either.
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

--
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: ISP Recs

2000-09-08 Thread Randy Adkins

www.Shanje.com

-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject: ISP Recs


I know this pops up all the time, but I wonder if I couldn't get some
recommendations on a good Cold Fusion ISP. The time has come for me to move
on, and I'd like to hear from any of you who feel positive enough about your
ISP to recommend them. Please respond off list, thanks.

Criteria:
Relatively inexpensive
Full CF support and expertise
Courteous in handling problems
Little or no server down time
Two pluses would be  a) a host that caters to fusebox sites without charging
for custom tag installation (or which allows user to install his/her own),
and b) little or no charge for ODBC dsn setup, or facility to allow user to
do it.

Thanks,
--John Allred

--
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: Introduction + logging question...

2000-09-08 Thread JustinMacCarthy

You could parse this out of the weblogs but I think you would be better
writing you own logging tags.

I use a custom, something like

cf_userlog action="successfullogin" userid="#session.userID#"
details="username:#form.username#" logdns="mydns"

or

cf_userlog action="fileDownload" userid="#session.userID#"
details="DocID:#Url.docID#" logdns="mydns"

Hope that helps

~Justin

- Original Message -
From: "Jaquet Digital Design" [EMAIL PROTECTED]
To: "ColdFusion Mailinglist" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 3:08 PM
Subject: Introduction + logging question...


 Hi there,

 My name is Erik-Jan Jaquet and I am a Dutch web developer. I recently
 started programming in ColdFusion and joined this list. This is my first
 posting.

 I am building a website with ColdFusion that requires people to log in
 before they can search a database with (links to) PDF files. When they
found
 a file, they can then download it to their computer. It is a Extranet, so
 only clients of the company have access to the database.

 The company would like to know who logs in, how often and which files they
 download, for marketing purposes.

 How can I register which users have logged in, how many times and the file
 download info? Or do programs like Webtrends also have the possibility to
 give that information.

 Thanks in advance,

 Erik-Jan Jaquet
 Jaquet Digital Design

 --

 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 with Microsoft Cluster

2000-09-08 Thread Christian Labrecque

Hi,

I have already some answers about this topic,
but anybody on the list got experience or thoughts on this

Thanks



--
FILAMENT COMMUNICATIONS
Bright ideas for a new economy
 
Christian Labrecque
Web Developer
 
http://www.filamentinc.com
 
126 York St., Suite 500, Ottawa, Ontario K1N 5T5
(t) 613-241-7200   (f) 613-241-7157



--
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: CFLDAP and SSL connections to LDAP server?

2000-09-08 Thread Michael Ross

You are very correct the documentation on how to use LDAP with CF is not there.  ITs a 
joke.  I am curious though, how did you get people to authenticate using the cfldap 
tag and not having set up a user directory, security context then us cfauthenticate??? 
I am working on doing this for my site.  I keep hitting the damm wall.  I have a 
ticket opened with allaire and they don't know anything about this.  What directory 
are you using.  Novell, Microsoft, Netscape???  I am using Novell's Directory Service 
but they(allaire) said to do things you need Netscapes (which I doubt, but oh well).  
Sorry going back to your question I know that if you use the advanced security and set 
up your directory and context you have the ability to tell CF to use a SSL connection 
(I don't know what it does).

It seems there are very few people who are working or have worked with this.  Its 
almost like we need to set up a group email list just for the people for ldap related 
crap  

There are a few KB articles about setting up the user directory and Security context 
and what to do.

Thats about that.

mike

 [EMAIL PROTECTED] 09/06/00 03:28PM 
Hello everyone - do we have any CFLDAP gurus out there today?  I've been
using CFLDAP to do authentication of users on my website, but changes have
been made in the corporate LDAP servers that are causing me problems and
driving me nuts.  Here's the situation:

In the past, I used the LDAP server at two points in time.  The first was to
register a new user for accessing my site.  I would feed the LDAP server the
person's internal telephone number, and it would return to me a
Distinguished Name (DN) field, along with lots of other data about the user.
I would then store that information, and add the user to the list of site
users.  Later, when the user came to the site, he'd pick his name off of a
SELECT list, enter his NT password, and hit a LOGON button.  At that point
I'd grab the DN from the database (that I stored during registration), and
use it as the CFLDAP username.  I'd take the password the user typed in, and
use that as the CFLDAP password.  Then I'd do the CFLDAP call.  If it came
back, the user was authenticated.  If CF threw an error (trapped via
CFERROR), then it failed.

Well, things changed on the LDAP servers.  The above worked only because of
a bug in NT, which allowed a non-secure connection to bind to the server and
do the authentication. So, they moved all of the LDAP servers to LINUX.  Now
I need to use a different port (636 instead of 389) for authentication, and
more importantly, I need to do the LDAP connection via an SSL connection.
Currently, everything is timing out.  The log on the LDAP server shows the
CF server doing a bind, and then nothing at all after that, so it times out,
and then the CF server times out to the browser with the "high
traffic/server load, come back later" error.

How do I get CFLDAP to use an SSL connection? There is so little
documentation on CFLDAP it's pathetic.  If someone can solve this dilemma
for me, I'll buy the beer in DC!

thanks everyone,
Reed

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



CFStudio RegEx Question

2000-09-08 Thread jeff tapper

Hey all -

I'm looking for a quick RegEx to check some of my developers code.  I'm 
trying to find any instances of CFIF inside of a CFQUERY tag.

I'm running cfquery .*.*CFIF .*/cfquery as a REGEX search, although, 
its not doing what i want, as it is returning records which look like
cfquery 
yadda yadda
/cfquery
cfif yadda
/cfif
cfquery
yadda yadda
/cfquery

I only want it to return CFIFs between the opening and closing CFQUERY tags.

Can anyone lend a hand?

thanks
==
Jeff Tapper
[EMAIL PROTECTED]
Team Manager / Lead Applications Architect
http://www.gtriad.com
G. Triad
==

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

2000-09-08 Thread Marla Jenkins

Thanks for the quick response!  I'll take a look at it although I should
have mentionned that I've been told that I'm not allowed to use any custom
tags on the servers :-(  Know any way to do it without the cfx_pgp tag?

-Marla
-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 3:29 PM
To: [EMAIL PROTECTED]
Subject: Re: CF and PGP


There is a cfx_pgp tag on allaires site in the tag gallery

~Justin


- Original Message -
From: "Marla Jenkins" [EMAIL PROTECTED]
To: "'Cf-Talk" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 10:00 AM
Subject: CF and PGP


 I'm hoping someone can help me...I am using CF 4.5.1 and need to find a
way
 to have CF encrypt and decrypt files using PGP 6.5.8.  I tried using
 CFEXECUTE to run pgp.bat and pgp.exe but it reacts in one of two ways - 1)
 kicks me out of the browser window or 2) error message that says it cannot
 execute the exe or bat file.  Even if I got it to run one of the files, I
 don't think I can pass the pgp decrypt statement through the arguments
 attribute to a DOS prompt.  Does anyone have any suggestions on how I can
 get CF and PGP to work together?  I need to use this version of PGP
because
 it's the only one I can find that works on both NT and HPUX.

 Thanks in advance for any help!

 Marla Jenkins
 Web Developer
 Hurd IT Communications
 http://www.hurdit.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: CF with Microsoft Cluster

2000-09-08 Thread Aaron Johnson

We're using CF behind Coyotepoint  MSCS to cluster the database servers.
MSCS is an expensive webserver clustering solution.  You're better off
getting a hardware solution (ie: Coyotepoint, F5, Cisco..)

Aaron

-Original Message-
From: Christian Labrecque [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 7:59 AM
To: [EMAIL PROTECTED]
Subject: CF with Microsoft Cluster


Hi,

I have already some answers about this topic,
but anybody on the list got experience or thoughts on this

Thanks



--
FILAMENT COMMUNICATIONS
Bright ideas for a new economy

Christian Labrecque
Web Developer

http://www.filamentinc.com

126 York St., Suite 500, Ottawa, Ontario K1N 5T5
(t) 613-241-7200   (f) 613-241-7157




--
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 Field Names with Blanks in them

2000-09-08 Thread Mary_Baotic



I am re-writing a scheduling program that was written in ASP/VB to work in Cold
Fusion.  The scheduling program uses an Access Database as its backend.

This is just a small program and we are trying to keep the backend the same and
just re-write the front end.  However, the person that wrote this access
database made the field names contain spaces.   For example, one field name is 6
AM

I didn't think you could have spaces in a field name.  But even so, how do you
tell Cold Fusion the field name?  I didn't think you could use #6 AM#.

I have just started re-writing it and I am going to try referencing the field
name as  #6 AM#, but  I wanted to get feedback.

Is this the right way to do it?  I would like not to have to re-write the back
end just yet.

Mary


--
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: CFStudio RegEx Question

2000-09-08 Thread Caulfield, Michael

CF regex will return the longest matching string that meets your conditions
(or, more precisely, the first longest string). You may need to write some
ridiculous looking code that uses the not operator (^) instead of .*, or
more probably write a short routine that makes a double pass through the
code.

Here's hoping Allaire beefs up regex in the next release.

Michael Caulfield
Web Developer
Cognitive Arts

-Original Message-
From: jeff tapper [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 9:59 AM
To: [EMAIL PROTECTED]
Subject: CFStudio RegEx Question


Hey all -

I'm looking for a quick RegEx to check some of my developers code.  I'm 
trying to find any instances of CFIF inside of a CFQUERY tag.

I'm running cfquery .*.*CFIF .*/cfquery as a REGEX search, although, 
its not doing what i want, as it is returning records which look like
cfquery 
yadda yadda
/cfquery
cfif yadda
/cfif
cfquery
yadda yadda
/cfquery

I only want it to return CFIFs between the opening and closing CFQUERY tags.

Can anyone lend a hand?

thanks
==
Jeff Tapper
[EMAIL PROTECTED]
Team Manager / Lead Applications Architect
http://www.gtriad.com
G. Triad
==


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



Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Daslweb - Greg

This is a multi-part message in MIME format.

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I do not have time to read 200 messages  a day anymore, because I have =
started school and work part time. How would I get off the list for the =
time being.

Gregory Pekofsky

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/html;
charset="Windows-1252"
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=3Dwindows-1252"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I do not have time to read 200 =
messagesnbsp; a day=20
anymore, because I have started school and work part time. How would I =
get off=20
the list for the time being./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Gregory =
Pekofsky/FONT/DIV/BODY/HTML

--=_NextPart_000_00C1_01C0198C.1BCCDB20--

--
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/Solaris on Intel

2000-09-08 Thread Larry W. Virden


From: Dave Watts [EMAIL PROTECTED]

 Your best bet is to bite the bullet, and go get a Sparc box. Fortunately,
 you don't have to get a good Sparc box. You can get one of the Ultra 5
 workstations, which run about $4,000 or so.


And that price is including a monitor.  If you just want to use one of
your existing monitors, the price is around $2200 - see
URL: 
http://store.sun.com/webconfig/BuildConfig.jhtml;$sessionid$PRZINPQAABB55AMTA1ESQCT5CJ1K
 
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
--
--
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 Field Names with Blanks in them

2000-09-08 Thread JustinMacCarthy

Use "[ ]" around the table names

~JustinMacCarthy

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 4:46 PM
Subject: Access Field Names with Blanks in them




 I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
 Fusion.  The scheduling program uses an Access Database as its backend.

 This is just a small program and we are trying to keep the backend the
same and
 just re-write the front end.  However, the person that wrote this access
 database made the field names contain spaces.   For example, one field
name is 6
 AM

 I didn't think you could have spaces in a field name.  But even so, how do
you
 tell Cold Fusion the field name?  I didn't think you could use #6 AM#.

 I have just started re-writing it and I am going to try referencing the
field
 name as  #6 AM#, but  I wanted to get feedback.

 Is this the right way to do it?  I would like not to have to re-write the
back
 end just yet.

 Mary


 --

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

2000-09-08 Thread JustinMacCarthy

It is very odd that you are allow to run cfexecute (you chould do format c:\
, or use | dev/null etc...) but not use a custom tag

You chould pipe the file to pgp under *nix but
I think the cfexecute tag is a little dodgy... and I haven't tried it under
*nix...

I would argue the case for using a custom tag... java or c , What are
the objections ?

~Justin  MacCarthy



- Original Message -
From: "Marla Jenkins" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 11:19 AM
Subject: RE: CF and PGP


 Thanks for the quick response!  I'll take a look at it although I should
 have mentionned that I've been told that I'm not allowed to use any custom
 tags on the servers :-(  Know any way to do it without the cfx_pgp tag?

 -Marla
 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 3:29 PM
 To: [EMAIL PROTECTED]
 Subject: Re: CF and PGP


 There is a cfx_pgp tag on allaires site in the tag gallery

 ~Justin


 - Original Message -
 From: "Marla Jenkins" [EMAIL PROTECTED]
 To: "'Cf-Talk" [EMAIL PROTECTED]
 Sent: Friday, September 08, 2000 10:00 AM
 Subject: CF and PGP


  I'm hoping someone can help me...I am using CF 4.5.1 and need to find a
 way
  to have CF encrypt and decrypt files using PGP 6.5.8.  I tried using
  CFEXECUTE to run pgp.bat and pgp.exe but it reacts in one of two ways -
1)
  kicks me out of the browser window or 2) error message that says it
cannot
  execute the exe or bat file.  Even if I got it to run one of the files,
I
  don't think I can pass the pgp decrypt statement through the arguments
  attribute to a DOS prompt.  Does anyone have any suggestions on how I
can
  get CF and PGP to work together?  I need to use this version of PGP
 because
  it's the only one I can find that works on both NT and HPUX.
 
  Thanks in advance for any help!
 
  Marla Jenkins
  Web Developer
  Hurd IT Communications
  http://www.hurdit.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.



--
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 Field Names with Blanks in them

2000-09-08 Thread Janty.com Administration

Since you are redoing the front end, what would it hurt to go into access
and just rename the database field to something without spaces?  I'm not
that familiar with Access, so I don't know if it will let you do it, but
I've done this on more than one occasion with Sybase with no problems.

Todd Ashworth
CEO, Janty Corporation
www.janty.com - We put the 'u' in music!

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 11:46 AM
Subject: Access Field Names with Blanks in them


|
|
| I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
| Fusion.  The scheduling program uses an Access Database as its backend.
|
| This is just a small program and we are trying to keep the backend the
same and
| just re-write the front end.  However, the person that wrote this access
| database made the field names contain spaces.   For example, one field
name is 6
| AM
|
| I didn't think you could have spaces in a field name.  But even so, how do
you
| tell Cold Fusion the field name?  I didn't think you could use #6 AM#.
|
| I have just started re-writing it and I am going to try referencing the
field
| name as  #6 AM#, but  I wanted to get feedback.
|
| Is this the right way to do it?  I would like not to have to re-write the
back
| end just yet.
|
| Mary


--
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/Solaris on Intel

2000-09-08 Thread Steve Ray

This is a multi-part message in MIME format.
--99CC7CE2EBD545C6DABCF674
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Larry -

Thanks, and I love the star trek tag line. Goes right along with your comments.

Does Sun (or someone else) make a converter for the monitor connection? All of the Sun 
monitors that
I've ever worked with have a very different port connection than the standard pc 
monitor cables. For
that matter, what about sync rates and that sort of thing? Any compatibility issues 
there?

Thanks again for your comments.


Steve


"Larry W. Virden" wrote:

 From: Dave Watts [EMAIL PROTECTED]

  Your best bet is to bite the bullet, and go get a Sparc box. Fortunately,
  you don't have to get a good Sparc box. You can get one of the Ultra 5
  workstations, which run about $4,000 or so.

 And that price is including a monitor.  If you just want to use one of
 your existing monitors, the price is around $2200 - see
 URL: 
http://store.sun.com/webconfig/BuildConfig.jhtml;$sessionid$PRZINPQAABB55AMTA1ESQCT5CJ1K
 
 --
 Never apply a Star Trek solution to a Babylon 5 problem.
 Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/
 Even if explicitly stated to the contrary, nothing in this posting should
 be construed as representing my employer's opinions.
 --

--99CC7CE2EBD545C6DABCF674
Content-Type: text/x-vcard; charset=us-ascii;
 name="sray.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steve Ray
Content-Disposition: attachment;
 filename="sray.vcf"

begin:vcard 
n:;
tel;fax:703.838.9799
tel;work:703.838.9777
x-mozilla-html:TRUE
url:www.matrixgroup.net
org:Matrix Group International
version:2.1
email;internet:[EMAIL PROTECTED]
title:Developer/Hipster
adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314;
fn:Steve Ray
end:vcard

--99CC7CE2EBD545C6DABCF674--

--
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 Field Names with Blanks in them

2000-09-08 Thread Hoffman, Joe (CIT)

In your SQL Select statement reference by using the back ticks and 
give it a new name with the AS.

SELECT `6 AM` AS 6AM, 


As for variables CFOUTPUT#6AM#/CFOUTPUT ... if I remember 
correctly is invalid ... CF vars can't begin with a numeric value.

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

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 11:47 AM
To: [EMAIL PROTECTED]
Subject: Access Field Names with Blanks in them




I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
Fusion.  The scheduling program uses an Access Database as its backend.

This is just a small program and we are trying to keep the backend the same
and
just re-write the front end.  However, the person that wrote this access
database made the field names contain spaces.   For example, one field name
is 6
AM

I didn't think you could have spaces in a field name.  But even so, how do
you
tell Cold Fusion the field name?  I didn't think you could use #6 AM#.

I have just started re-writing it and I am going to try referencing the
field
name as  #6 AM#, but  I wanted to get feedback.

Is this the right way to do it?  I would like not to have to re-write the
back
end just yet.

Mary



--
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: Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Hoffman, Joe (CIT)

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.

If that does not work ... ask for Mike Dinowitz's email address 
so you could ask him directly.

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

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 2:59 PM
To: [EMAIL PROTECTED]
Subject: Daslweb - How do I get off of the mailing list?


This is a multi-part message in MIME format.

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I do not have time to read 200 messages  a day anymore, because I have =
started school and work part time. How would I get off the list for the =
time being.

Gregory Pekofsky

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/html;
charset="Windows-1252"
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=3Dwindows-1252"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I do not have time to read 200 =
messagesnbsp; a day=20
anymore, because I have started school and work part time. How would I =
get off=20
the list for the time being./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Gregory =
Pekofsky/FONT/DIV/BODY/HTML

--=_NextPart_000_00C1_01C0198C.1BCCDB20--


--
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: Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Janty.com Administration

Just like it says at the bottom of all 200 of those E-mails ;)


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

Todd Ashworth
CEO, Janty Corporation
www.janty.com - We put the 'u' in music!

- Original Message -
From: "Daslweb - Greg" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 2:58 PM
Subject: Daslweb - How do I get off of the mailing list?


| This is a multi-part message in MIME format.
|
| --=_NextPart_000_00C1_01C0198C.1BCCDB20
| Content-Type: text/plain;
| charset="Windows-1252"
| Content-Transfer-Encoding: quoted-printable
|
| I do not have time to read 200 messages  a day anymore, because I have =
| started school and work part time. How would I get off the list for the =
| time being.
|
| Gregory Pekofsky
|
| --=_NextPart_000_00C1_01C0198C.1BCCDB20
| Content-Type: text/html;
| charset="Windows-1252"
| 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=3Dwindows-1252"
| META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
| STYLE/STYLE
| /HEAD
| BODY bgColor=3D#ff
| DIVFONT face=3DArial size=3D2I do not have time to read 200 =
| messagesnbsp; a day=20
| anymore, because I have started school and work part time. How would I =
| get off=20
| the list for the time being./FONT/DIV
| DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
| DIVFONT face=3DArial size=3D2Gregory =
| Pekofsky/FONT/DIV/BODY/HTML
|
| --=_NextPart_000_00C1_01C0198C.1BCCDB20--
|
| --

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



Trouble with CFLOOP output

2000-09-08 Thread Jon Tillman

Anyone care to help figure out why the a href line just after the start of
the cfloop isnot getting parsed?

 cfquery name="categories" datasource="#application.dsn#"
SELECT  *
FROMtblCategory
WHERE   categoryTopcategoryID=2
/cfquery
cfloop query="categories"
a href="aroma_prod_all.cfm?categoryId=#categoryID#"#categoryCategory#/a
cfquery name="products" datasource="#application.dsn#"
SELECT *
FROM   tblProduct
WHERE  productCategoryID = #categoryID#
/cfquery
ul
cfoutput query="products"
liba 
href="aroma_prod.cfm?productId=#productId#"#productName#/a/b/li
/cfoutput
/ul
/cfloop

-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
***
Help Jon build a network!
Looking for giveaway computers  parts
Current Need: Tape Drive  PI/PII processors
Email me to find out how you can help
***

--
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 E rror??

2000-09-08 Thread Jon Bell

Sebastian

Are you using a personal web server?  If so this function does not work on
that platform.  You would need to upgrade to IIS or a different server.

J

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 9:59 PM
To: [EMAIL PROTECTED]
Subject: CFfile E rror??



I don't how to resolve this error with moving a file with cffile. Anyone
can help?

Sebastian

-


Error processing CFFILE

Unable to move file 'c:\inetpub\wwwroot\cfscripts\hangman\testing.txt' to
path 'c:\inetpub\wwwroot\cfscripts\hangman\adams\testing.txt'. This function
is only valid in Win32 mode. (error 120)

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (23:1) to (25:37).


Date/Time: 08/31/00 20:53:48
Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
Remote Address: 127.0.0.1
Template: C:\Inetpub\wwwroot\CFscripts\HangMan\CFfile.cfm


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

2000-09-08 Thread Jon Bell

If the version of CF is enterprise the answer is yes,  You would have to
make sure the OS' are compatible.

j

-Original Message-
From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 4:23 PM
To: [EMAIL PROTECTED]
Subject: Architecture


Does CF 4.5.1 have to run on the same box hosting the web server? 
Can I run CF on a WNT box, and use it with, say, Apache running on a 
different box (perhaps with UNIX OS)?

Thanks in advance.
___
  Joseph J. Sanger, M.D.| Phone: (212) 263-7410
  Associate Professor of Clinical Radiology | Fax:   (212) 263-2039
  Director, Division of Radiology Informatics   |
  Co-Director, Division of Nuclear Medicine |
  Co-Director, Nuclear Cardiology   |
  New York University School of Medicine| [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.
--
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: Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Jon Tillman

On Fri, 08 Sep 2000, Daslweb - Greg spake thusly:
 This is a multi-part message in MIME format.
 
 --=_NextPart_000_00C1_01C0198C.1BCCDB20
 Content-Type: text/plain;
   charset="Windows-1252"
 Content-Transfer-Encoding: quoted-printable
 
 I do not have time to read 200 messages  a day anymore, because I have =
 started school and work part time. How would I get off the list for the =
 time being.

You could always read the footer attched to every one of those two hundred
messages :)

 
 Gregory Pekofsky
 
 --=_NextPart_000_00C1_01C0198C.1BCCDB20
 Content-Type: text/html;
   charset="Windows-1252"
 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=3Dwindows-1252"
 META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2I do not have time to read 200 =
 messagesnbsp; a day=20
 anymore, because I have started school and work part time. How would I =
 get off=20
 the list for the time being./FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Gregory =
 Pekofsky/FONT/DIV/BODY/HTML
 
 --=_NextPart_000_00C1_01C0198C.1BCCDB20--
 
 --
 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]
***
Help Jon build a network!
Looking for giveaway computers  parts
Current Need: Tape Drive  PI/PII processors
Email me to find out how you can help
***

--
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 Field Names with Blanks in them

2000-09-08 Thread Olive, Christopher M Mr NMR

you also need to alias the table name to use with CF

SELECT
[6 AM] as toodamnearly
...


and you would ref it in CFOUTPUT as #toodamnearly#



-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:03 PM
To: [EMAIL PROTECTED]
Subject: Re: Access Field Names with Blanks in them


Use "[ ]" around the table names

~JustinMacCarthy

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 4:46 PM
Subject: Access Field Names with Blanks in them




 I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
 Fusion.  The scheduling program uses an Access Database as its backend.

 This is just a small program and we are trying to keep the backend the
same and
 just re-write the front end.  However, the person that wrote this access
 database made the field names contain spaces.   For example, one field
name is 6
 AM

 I didn't think you could have spaces in a field name.  But even so, how do
you
 tell Cold Fusion the field name?  I didn't think you could use #6 AM#.

 I have just started re-writing it and I am going to try referencing the
field
 name as  #6 AM#, but  I wanted to get feedback.

 Is this the right way to do it?  I would like not to have to re-write the
back
 end just yet.

 Mary


 --

 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: fusebox stats (talking aloud)

2000-09-08 Thread Eric Dawson

Well the good thing, and the bad thing is, it makes sense to do your own 
logging.

Good thing is ... you can more definitely specify what you want to track. 
Bad news (the same as the good news). A classic double edged sword.

I get a little excited when I think about what you can do. I think about 
scorecarding, revenue projections, demographic slice and dice. woo hoo. fun 
stuff.

I am planning on doing this sort of logging. Operative word. planning. yeah 
that planning IS done on a crowded Winnipeg patio drinking a cool one in the 
sun, but nevertheless, planning.

UserID.
Page, Application, Method. whatever.
Client Information.
Browser Information.

Keep the logging as simple as possible, but use extended databases to 
perform the analysis and reporting. ie use the userid to key into the user 
profile database. Use postal/zip code (in the absense of demographic 
profiles) to approximate demographic profiles.

Use business intelligence tools (cognos, seagate analysis) to organize the 
data for analysis. automate and publish distribution.

Revenue projections based on projected log statistics. Comparing performance 
to projections. and how the log stats are used to project business 
statistics like revenue, new customers etc. market share.

Just yapping. Please don't filter my emails just yet. I am done.

Eric

- Original Message -
From: "Jason Egan" [EMAIL PROTECTED]
Subject: fusebox stats
I think fusebox is cool
created a nice application for a customer using fusebox.
Now, they would like to get stat reports on it...

_
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: Access Field Names with Blanks in them

2000-09-08 Thread Dick Applebaum

SELECT `BAD Name` AS Good_Name

  the ` is a backtick character

HTH

Dick

At 11:46 AM -0400 9/8/00, [EMAIL PROTECTED] wrote:
I am re-writing a scheduling program that was written in ASP/VB to 
work in Cold
Fusion.  The scheduling program uses an Access Database as its backend.

This is just a small program and we are trying to keep the backend 
the same and
just re-write the front end.  However, the person that wrote this access
database made the field names contain spaces.   For example, one 
field name is 6
AM

I didn't think you could have spaces in a field name.  But even so, how do you
tell Cold Fusion the field name?  I didn't think you could use #6 AM#.

I have just started re-writing it and I am going to try referencing the field
name as  #6 AM#, but  I wanted to get feedback.

Is this the right way to do it?  I would like not to have to re-write the back
end just yet.

Mary

--
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/Solaris on Intel

2000-09-08 Thread Dave Watts

 Does Sun (or someone else) make a converter for the monitor 
 connection?

Yes they do, and in fact the monitor that Sun ships with the Ultra 5 has a
PC-standard 15-pin connection.

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/
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: Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Eric Dawson

filter everyone on the list except: dave watt. and stay subscribed.


From: [EMAIL PROTECTED] (Daslweb - Greg)
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Daslweb - How do I get off of the mailing list?
Date: Fri, 8 Sep 2000 11:58:31 -0700

This is a multi-part message in MIME format.

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I do not have time to read 200 messages  a day anymore, because I have =
started school and work part time. How would I get off the list for the =
time being.

Gregory Pekofsky

--=_NextPart_000_00C1_01C0198C.1BCCDB20
Content-Type: text/html;
charset="Windows-1252"
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=3Dwindows-1252"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I do not have time to read 200 =
messagesnbsp; a day=20
anymore, because I have started school and work part time. How would I =
get off=20
the list for the time being./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Gregory =
Pekofsky/FONT/DIV/BODY/HTML

--=_NextPart_000_00C1_01C0198C.1BCCDB20--

--
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: CF and PGP

2000-09-08 Thread Marla Jenkins

Because I'm pretty much a newbie at ColdFusion I'm not sure I totally
understood their reasoning but part of what I was told is that they don't
want to touch or load any additional COM objects.

I don't think the client never actually told my boss that cfexecute was ok
to use...I just told my boss that as far as I knew that was my only option
for a regular tag.  It's very possible that the client has cfexecute
disabled.  I think I'm going to have to give up and start looking at options
outside of CF like scheduling batch files to run.

-Marla

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 5:08 PM
To: [EMAIL PROTECTED]
Subject: Re: CF and PGP


It is very odd that you are allow to run cfexecute (you chould do format c:\
, or use | dev/null etc...) but not use a custom tag

You chould pipe the file to pgp under *nix but
I think the cfexecute tag is a little dodgy... and I haven't tried it under
*nix...

I would argue the case for using a custom tag... java or c , What are
the objections ?

~Justin  MacCarthy



- Original Message -
From: "Marla Jenkins" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 11:19 AM
Subject: RE: CF and PGP


 Thanks for the quick response!  I'll take a look at it although I should
 have mentionned that I've been told that I'm not allowed to use any custom
 tags on the servers :-(  Know any way to do it without the cfx_pgp tag?

 -Marla
 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 3:29 PM
 To: [EMAIL PROTECTED]
 Subject: Re: CF and PGP


 There is a cfx_pgp tag on allaires site in the tag gallery

 ~Justin


 - Original Message -
 From: "Marla Jenkins" [EMAIL PROTECTED]
 To: "'Cf-Talk" [EMAIL PROTECTED]
 Sent: Friday, September 08, 2000 10:00 AM
 Subject: CF and PGP


  I'm hoping someone can help me...I am using CF 4.5.1 and need to find a
 way
  to have CF encrypt and decrypt files using PGP 6.5.8.  I tried using
  CFEXECUTE to run pgp.bat and pgp.exe but it reacts in one of two ways -
1)
  kicks me out of the browser window or 2) error message that says it
cannot
  execute the exe or bat file.  Even if I got it to run one of the files,
I
  don't think I can pass the pgp decrypt statement through the arguments
  attribute to a DOS prompt.  Does anyone have any suggestions on how I
can
  get CF and PGP to work together?  I need to use this version of PGP
 because
  it's the only one I can find that works on both NT and HPUX.
 
  Thanks in advance for any help!
 
  Marla Jenkins
  Web Developer
  Hurd IT Communications
  http://www.hurdit.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.



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



Deleting Duplicate Records in MS access 200

2000-09-08 Thread AustralianAccommodation.com Pty. Ltd.

I have 5500 records in my suburbs table and many of those suburbs have
identical names therefore I am wanting to delete all duplicates of suburb
names so that I only have one occurrence of each name in the suburb list I
am not sure how to go about this in access 2000

can anyone please assist me please


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [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: Trouble with CFLOOP output

2000-09-08 Thread Dana Larose

 cfloop query="categories"
 a
 href="aroma_prod_all.cfm?categoryId=#categoryID#"#categoryCategory#/a

You need a cfoutput/cfoutput around your href.  Stuff inside a cfloop
won't automatically be parsed as though they were ColdFusion.

Dana Larose
ColdFusion Monkey
Canadian Web Design  Consulting Inc.

A: 701-281 McDermot Avenue (McDermot  King)
P: 204.946.5155
C: 204.228.0477
F: 204.946.5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.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: Access Field Names with Blanks in them

2000-09-08 Thread Mary_Baotic



I was just trying to avoid having to explain why I had to rename them when "it
was working just fine using ASP."

Thanks
Mary


|+---
||  "Janty.com   |
||  Administratio|
||  n"   |
||  admin@janty.|
||  com |
||   |
||  09/08/2000   |
||  12:19 PM |
||  Please   |
||  respond to   |
||  cf-talk  |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED]|
  |   cc: (bcc: Mary Baotic/na/Hyperion)   |
  |   Subject: Re: Access Field Names with Blanks in them  |
  |





Since you are redoing the front end, what would it hurt to go into access
and just rename the database field to something without spaces?  I'm not
that familiar with Access, so I don't know if it will let you do it, but
I've done this on more than one occasion with Sybase with no problems.

Todd Ashworth
CEO, Janty Corporation
www.janty.com - We put the 'u' in music!

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 11:46 AM
Subject: Access Field Names with Blanks in them


|
|
| I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
| Fusion.  The scheduling program uses an Access Database as its backend.
|
| This is just a small program and we are trying to keep the backend the
same and
| just re-write the front end.  However, the person that wrote this access
| database made the field names contain spaces.   For example, one field
name is 6
| AM
|
| I didn't think you could have spaces in a field name.  But even so, how do
you
| tell Cold Fusion the field name?  I didn't think you could use #6 AM#.
|
| I have just started re-writing it and I am going to try referencing the
field
| name as  #6 AM#, but  I wanted to get feedback.
|
| Is this the right way to do it?  I would like not to have to re-write the
back
| end just yet.
|
| Mary


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



OT: SQL7 DB to DB

2000-09-08 Thread Adrian Cesana

I have a need to only keep 3 mos of data in a production DB (SQL7) but all
the previous data needs to go into a separate "history" DB.  Every month I
will need to push the oldest month of data from the production DB to the
history DB.  Initially I guess I could just duplicate the DB and purge data
in the production DB.

Im looking for recommendations on how to push one months data efficiently
from DB to DB...?  Can an UPDATE work cross DB?

Also, when I do a purge (DELETE) how do I keep the transaction log from
growing out of control...?

-Adrian

--
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: Trouble with CFLOOP output

2000-09-08 Thread Dana Larose

 cfloop query="categories"
 a
 href="aroma_prod_all.cfm?categoryId=#categoryID#"#categoryCategory#/a

You need a cfoutput/cfoutput around your href.  Stuff inside a cfloop
won't automatically be parsed as though they were ColdFusion.

Dana Larose
ColdFusion Monkey
Canadian Web Design  Consulting Inc.

A: 701-281 McDermot Avenue (McDermot  King)
P: 204.946.5155
C: 204.228.0477
F: 204.946.5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.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.



cf 4.0 Win2K

2000-09-08 Thread Tim Bahlke

I am guessing that CF4.0 Enterprise cannot run on Win2K.

Is this correct?

Thanks,
Tim Bahlke
_
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.



An extremely need (semi-OT)

2000-09-08 Thread Alex Puritche

cf-talk,

I have a need to run a stored procedure which will insert multiple
rows in the database. Biggest problem that I don't know from the
begging how much inserts I need to do. I need to pass in the stored
procedure an array of variables and loop over it.
How I can pass complex datasets like arrays,lists, etc.
in the stored procedure?
How I can loop over that datasets in the stored procedure?

-- 
 Regards,
 Alex  mailto:[EMAIL PROTECTED]

 Certified
 http://www.brainbench.com/transcript.jsp?pid=145368

 FAQ Project
 http://faq.worldrecovery.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: Trouble with CFLOOP output

2000-09-08 Thread Zachary Bedell

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Maybe because it's not in CFOUTPUT's?

 -Original Message-
 From: Jon Tillman [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 12:20 PM
 To: [EMAIL PROTECTED]
 Subject: Trouble with CFLOOP output
 
 
 Anyone care to help figure out why the a href line just 
 after the start of
 the cfloop isnot getting parsed?
 
  cfquery name="categories" datasource="#application.dsn#"
 SELECT  *
 FROMtblCategory
 WHERE   categoryTopcategoryID=2
 /cfquery
 cfloop query="categories"
 a 
 href="aroma_prod_all.cfm?categoryId=#categoryID#"#categoryCat
 egory#/a
 cfquery name="products" datasource="#application.dsn#"
 SELECT *
 FROM   tblProduct
 WHERE  productCategoryID = #categoryID#
 /cfquery
 ul
 cfoutput query="products"
 liba 
 href="aroma_prod.cfm?productId=#productId#"#productName#/a/b/l
 i 
 /cfoutput
 /ul
 /cfloop
 
 -- 
 ***
  Jon Tillman
  LINUX USER: #141163
  ICQ: 4015362
  http://www.eruditum.org
  [EMAIL PROTECTED]
 ***
 Help Jon build a network!
 Looking for giveaway computers  parts
 Current Need: Tape Drive  PI/PII processors
 Email me to find out how you can help
 ***
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com

iQA/AwUBObke/AraVoMWBwRBEQLZMgCeNSPuoXffYQZ+emUkszgcDJQVdjEAoJGG
NTZo+RsqRhMLy2tT/2NmrcoM
=CkFN
-END PGP SIGNATURE-
--
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: Architecture

2000-09-08 Thread JustinMacCarthy

Look into cfdist.exe

~Justin

- Original Message -
From: "Jon Bell" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 5:19 PM
Subject: RE: Architecture


 If the version of CF is enterprise the answer is yes,  You would have to
 make sure the OS' are compatible.

 j

 -Original Message-
 From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 05, 2000 4:23 PM
 To: [EMAIL PROTECTED]
 Subject: Architecture


 Does CF 4.5.1 have to run on the same box hosting the web server?
 Can I run CF on a WNT box, and use it with, say, Apache running on a
 different box (perhaps with UNIX OS)?

 Thanks in advance.

___
   Joseph J. Sanger, M.D.| Phone: (212) 263-7410
   Associate Professor of Clinical Radiology | Fax:   (212) 263-2039
   Director, Division of Radiology Informatics   |
   Co-Director, Division of Nuclear Medicine |
   Co-Director, Nuclear Cardiology   |
   New York University School of Medicine|
[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.
 --

 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.



MS SQL Eval

2000-09-08 Thread Stas Newdel

Hello,

Does anybody have a link to the SQL 7 Evaluation? The link on MS doesn't
work :(

Thanks!

--
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: VBScript and WSH

2000-09-08 Thread Robert Everland

Alright I know this is off topic, though it could be a little on
topic showing how verbose VBScript can be. I want to make a VBS up so that
it will check to see what version of virus scanner software I have an
execute the appropiate updates once it has it. Does anyone know how to
access the registry with VBS or already has a working example of this?

Robert Everland III
Web Developer
Dixon Ticonderoga
--
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.



Numeric Field

2000-09-08 Thread Jeremy Toevs

Is there a way to write a query that will add 1 to a numberic field in a database? 
Meaning everytime the query is ran, it adds 1 to the current number that is in the 
database. (example: if the database says 3 and I run the query it will then say 4).

This may be a dumb question but it doesn't hurt to ask.

Thanks
Jeremy

--
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: Daslweb - How do I get off of the mailing list?

2000-09-08 Thread Ken Wilson



 filter everyone on the list except: dave watt. and stay subscribed.



If the old message stats I once saw still hold true, that'll net him only a
slight reduction in volume.  :)

Of course, the volume/quality ratio will improve somewhat.

Ken


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

2000-09-08 Thread Dave Watts

 I am guessing that CF4.0 Enterprise cannot run on Win2K.

It may run (I had 4.0.1 working on Win2K RC2), but it will break MDAC, and
is not supported by Allaire.

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/
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: fusebox stats

2000-09-08 Thread Scott Cavanaugh

I would look at writing a custom tag that keeps track of statistical data
(ie hits on a page).
Include that custom tag in the pages you wish statistical data to be
gathered on and save those results in a database.
You could even use the data you collect to produce your own reports.

Just of the top of my head.

Scott

-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 1:29 PM
To: Cf-Talk; [EMAIL PROTECTED]
Subject: fusebox stats


I think fusebox is cool, but I've gotten myself in some hot water here... I
created a nice application for a customer using fusebox.  Now, they would
like to get stat reports on it... well... because you're always going to the
same page and including the others all of the stats come back as hits
against the main index.cfm page, not the actual page that was hit.

How on earth do I track these pages individually?  How can I tell how many
people looked at the contact page, or the support page or whatever??

Thanks for any ideas...

je


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

2000-09-08 Thread Gregory Gooden (Annex)


It sure does for us. :)

Gregory
 

--- 
annex.com, Inc. - http://www.annex.com/ 
--- 
- If you EcoBuild it, they will come. - 
- http://www.ecobuilder.com/ - 
--- 


 -Original Message-
 From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 08, 2000 10:08 AM
 To: [EMAIL PROTECTED]
 Subject: cf 4.0  Win2K
 
 
 I am guessing that CF4.0 Enterprise cannot run on Win2K.
 
 Is this correct?
 
 Thanks,
 Tim Bahlke
--
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 Field Names with Blanks in them

2000-09-08 Thread Zachary Bedell

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

At least with the example you gave, you've got two issues to deal
with -- the embedded space  the leading digit in the field name. 
Neither of those are kosher in CF.

Try something like:

Cfquery ...
SELECT '6 AM' as SixAm 
FROM 
/cfquery

If you use the SQL query to alias all of your 'bad' field names to
something CF can deal with, then you should be okay.

Although...  In all honesty, you *should* rename the fields

Hope that helps!

Best regards,
Zac Bedell


 I was just trying to avoid having to explain why I had to 
 rename them when "it
 was working just fine using ASP."
 
 Since you are redoing the front end, what would it hurt to go 
 into access
 and just rename the database field to something without 
 spaces?  I'm not
 that familiar with Access, so I don't know if it will let you 
 do it, but
 I've done this on more than one occasion with Sybase with no
 problems.  
 
 Todd Ashworth
 CEO, Janty Corporation
 www.janty.com - We put the 'u' in music!
 
 |
 |
 | I am re-writing a scheduling program that was written in 
 ASP/VB to work in
 Cold
 | Fusion.  The scheduling program uses an Access Database as 
 its backend.
 |
 | This is just a small program and we are trying to keep the 
 backend the
 same and
 | just re-write the front end.  However, the person that 
 wrote this access
 | database made the field names contain spaces.   For 
 example, one field
 name is 6
 | AM
 |
 | I didn't think you could have spaces in a field name.  But 
 even so, how do
 you
 | tell Cold Fusion the field name?  I didn't think you could 
 use #6 AM#.
 |
 | I have just started re-writing it and I am going to try 
 referencing the
 field
 | name as  #6 AM#, but  I wanted to get feedback.
 |
 | Is this the right way to do it?  I would like not to have 
 to re-write the
 back
 | end just yet.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com

iQA/AwUBObkzHwraVoMWBwRBEQJ3BwCg8s6ZzROYyxzpxXDYPOYKhlP3/k8AoMRb
PnOTmryOLQxehBs5zpYcwJgm
=ZnQj
-END PGP SIGNATURE-
--
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: fusebox stats

2000-09-08 Thread Zachary Bedell

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Umm  Inserts shouldn't cause DB locking issues unless there were
updates or selects going on at the same time.  If the table is just
used for logging, then locks should only be an issue when someone's
actually generating a report from the tables.  And even then inserts
shouldn't clash with selects.

I don't think adding another layer would help matters any -- what's
the difference between calling OLEDB to do an insert vs. calling a
COM object to call OLEDB to do the insert?  All that does is add
another layer that every page request has to wait on.  It eats more
server RAM (*especially* the EJB), and just adds to the confusion.

Not that writing to the DB on every single page access is such a
*great* thing, but it shouldn't be *that* bad.  If you are indeed
logging all request to the DB, you might try disabling the
webserver's logging capabilities to gain back some of what you're
losing to the DB.

Best regards,
Zac Bedell 

 
 It sounds simple, but under tremendous load, your insert 
 operations will
 probably cause locking issues and could drown the server.
 
 An EJB or COM object in the middle tier to receive this would 
 probably be
 safer.
 

 The easiest thing to do is have a db with a table called 
 logs, with the page
 name as the ID and increment this each time this page is 
 called before the
 cflocation/cfinclude its that simple:-)
 
 
 I think fusebox is cool, but I've gotten myself in some hot 
 water here... I
 created a nice application for a customer using fusebox.  
 Now, they would
 like to get stat reports on it... well... because you're 
 always going to the
 same page and including the others all of the stats come back as
 hits against the main index.cfm page, not the actual page that was
 hit.  
 
 How on earth do I track these pages individually?  How can I 
 tell how many
 people looked at the contact page, or the support page or
 whatever??  
 
 Thanks for any ideas...

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com

iQA/AwUBObk0lQraVoMWBwRBEQLD+QCgn5CvxldbYvfAmCAhIUm3HD6EzKoAnR4X
BnnTBWXCbfKbBeM9soA+9r2r
=HQTG
-END PGP SIGNATURE-
--
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 4.0 Win2K

2000-09-08 Thread Pete Freitag

I believe it will run, but it is not supported by Allaire (I think CF 4.5.1
is the first version which they support for Win2k).  Back when Win2k was
still in beta I installed CF 4.0.x on it, and the CF installer didn't
install CF as a service.  I manually installed the services, and it seamed
to work fine.

__
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM / NETDesign Inc.
ColdFusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 1:08 PM
To: [EMAIL PROTECTED]
Subject: cf 4.0  Win2K


I am guessing that CF4.0 Enterprise cannot run on Win2K.

Is this correct?

Thanks,
Tim Bahlke
_
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: An extremely need (semi-OT)

2000-09-08 Thread J.Milks

Quite sure you can't pass arrays. What about passing a delimited CHAR field
and looping on that? I have done that on several occasions. I.E: 2,5,7,23

JM


- Original Message -
From: "Alex Puritche" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 1:16 PM
Subject: An extremely need (semi-OT)


 cf-talk,

 I have a need to run a stored procedure which will insert multiple
 rows in the database. Biggest problem that I don't know from the
 begging how much inserts I need to do. I need to pass in the stored
 procedure an array of variables and loop over it.
 How I can pass complex datasets like arrays,lists, etc.
 in the stored procedure?
 How I can loop over that datasets in the stored procedure?

 --
  Regards,
  Alex  mailto:[EMAIL PROTECTED]

  Certified
  http://www.brainbench.com/transcript.jsp?pid=145368

  FAQ Project
  http://faq.worldrecovery.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: Numeric Field

2000-09-08 Thread Robert Hinojosa

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_01C019CC.8AAEC54A
Content-Type: text/plain;
charset="iso-8859-1"

Try This

UPDATE Products 
SET ProdCount = (ProdCount+1)

HTH,

Robert

-Original Message-
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:58 PM
To: [EMAIL PROTECTED]
Subject: Numeric Field


Is there a way to write a query that will add 1 to a numberic field in a
database? Meaning everytime the query is ran, it adds 1 to the current
number that is in the database. (example: if the database says 3 and I run
the query it will then say 4).

This may be a dumb question but it doesn't hurt to ask.

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

--_=_NextPart_001_01C019CC.8AAEC54A
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"
TITLERE: Numeric Field/TITLE
/HEAD
BODY

PFONT SIZE=3D2Try This/FONT
/P

PFONT SIZE=3D2UPDATE Products =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; /FONT
BRFONT SIZE=3D2SET ProdCount =3D (ProdCount+1)/FONT
/P

PFONT SIZE=3D2HTH,/FONT
/P

PFONT SIZE=3D2Robert/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Jeremy Toevs [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT
BRFONT SIZE=3D2Sent: Friday, September 08, 2000 12:58 PM/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Numeric Field/FONT
/P
BR

PFONT SIZE=3D2Is there a way to write a query that will add 1 to a =
numberic field in a database? Meaning everytime the query is ran, it =
adds 1 to the current number that is in the database. (example: if the =
database says 3 and I run the query it will then say 4)./FONT/P

PFONT SIZE=3D2This may be a dumb question but it doesn't hurt to =
ask./FONT
/P

PFONT SIZE=3D2Thanks/FONT
BRFONT SIZE=3D2Jeremy/FONT
/P

PFONT =
SIZE=3D2---=
---/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/=
/A/FONT
BRFONT SIZE=3D2To Unsubscribe visit A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
sts/cf_talk" =
TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
body=3Dlists/cf_talk/A or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body./FONT/P

/BODY
/HTML
--_=_NextPart_001_01C019CC.8AAEC54A--
--
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: Help with NT authentication

2000-09-08 Thread Howie Hamlin

Have a look at the Intranet Hosting Toolkit.

http://www.intrafoundation.com/intranethostingtoolkit.html

This package includes a freeware CFX (CFX_GetUserGroups) that allows you to:

1) list all users in the NT security database  all local/global groups that
exist in a domain/workstation  current users

2) list the groups/localgroups a single user belongs to as well as basic
user info

3) verify a user by username/password.

HTH,

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


- Original Message -
From: "Dana Larose" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 2:17 PM
Subject: Help with NT authentication


 Hello everyone,

 Here is my scenario/dilema...

 Our company has been developing a Store app which will live on our
client's
 intranet.

 Each user will have different levels of access (for billing and shipping
 purposes) to the store and they will use each employees' NT login for
 authentication.  Ideally, they don't log into the Store, but I could have
 them enter their NT username/password.  What the client doesn't want is to
 have a seperate database of users (they play to have several apps
 eventually, which will need similar logins).

 I will need, if possible, to determine which NT groups the users belong
to.

 The client does not have an LDAP server, they use a primary domain
 controller to handle NT authentication.

 I have read through the security chapters in Advanced ColdFusion, but they
 are a little sparse.

 Has anyone done something similar and can offer advice?

 Dana Larose
 ColdFusion Monkey
 Canadian Web Design  Consulting Inc.

 A: 701-281 McDermot Avenue (McDermot  King)
 P: 204.946.5155
 C: 204.228.0477
 F: 204.946.5156
 E: [EMAIL PROTECTED]
 W: http://www.cdnwebdesign.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: Help with NT authentication

2000-09-08 Thread Dave Watts

 Each user will have different levels of access (for billing 
 and shipping purposes) to the store and they will use each 
 employees' NT login for authentication. Ideally, they don't 
 log into the Store, but I could have them enter their NT 
 username/password. What the client doesn't want is to have 
 a seperate database of users (they play to have several apps
 eventually, which will need similar logins).
 
 I will need, if possible, to determine which NT groups the 
 users belong to.

You can use Advanced Security for authenticating NT users, or you can use
third-party components, which might be easier. There are two that I can
think of.

1. Lewis Sellers' CFX interfaces:
http://www.intrafoundation.com/intranethostingtoolkit.html

2. Software Artisans' SA-Admin COM interfaces:
http://www.softwareartisans.com/softartisans/saadmin.html

I've heard good things generally about the first choice, and have used the
second one successfully from CF for a long time.

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/
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: Bids Needed

2000-09-08 Thread Jeffrey A. Zubeck

Our firm is in need of bids on an upcoming project.

The project will be for a travel agency to book flights through their
website. The application will interact with a large third party database via
an SDS scenario, be manipulated appropriately and passed back to the
database to actually make the reservation.

This will require strong knowledge of SQL database structuring (particularly
date/time functions) and Cold Fusion Programming.

If interested, contact me off list and I will get you a detailed outline of
the project to help you prepare your bid.

Thanks,

Jeff Zubeck
[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: cf 4.0 Win2K

2000-09-08 Thread Adrian Cooper


- Original Message -
From: "Tim Bahlke" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 6:08 PM

on Win2K.

 Is this correct?

From my own experience I can say that CF 4.00 does not run - it appears to
install OK  - but in my case did not register the CF services.  CF 4.01 does run
but trashes elements of MDAC (at least with SQL Server) and is not supported,
4.51 appears to run fine and is supported.

Adrian Cooper.


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



Replacing a value in the list form.fieldnames

2000-09-08 Thread Ian

I have a list of variables sent by a form. I need to make sure that none of
the variable values are incompatible with each other. This isn't the problem.
The problem is changing the Form.whatever = value to a compatible value
(Form.field2 = 2. Form.field3 = 3 but 3 is not compatible with 2 so I need to
change Form.field3 to = 4). Using CFSET I can't use a function on the left
side of the = CFSET (Listgetat(Form.fieldnames, count) = 4. I can't hard
code it because the fieldnames are drawn from a database and change depending
on what itemthe form is built for. 

Any suggestions?

Ian


Get your own FREE, personal Netscape WebMail account today at 
http://home.netscape.com/webmail
--
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: Importing a text file

2000-09-08 Thread Robert Hinojosa

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_01C019D6.3AD9C07E
Content-Type: text/plain;
charset="iso-8859-1"

use single quotes.

#Replace('#f1_element#','"','','ALL')#

HTH

Robert

-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 2:05 PM
To: [EMAIL PROTECTED]
Subject: Importing a text file


I have a file that I need to import that looks something like this.

"A3","BOOSTER_TANK_ASSY","1B89037","Serial
Number",#2000-09-09#,100,75,"Visual Good","No"  

Now, I know how to import the, what I am having problems is that the data is
surrounded by "'s. This is my Replace statement

#Replace("#f1_element#"," "," ","ALL")#

The question is, how do I stip out the "'s when "'s are part of the
statement?

Thank you for your help

Jim Ray



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

--_=_NextPart_001_01C019D6.3AD9C07E
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"
TITLERE: Importing a text file/TITLE
/HEAD
BODY

PFONT SIZE=3D2use single quotes./FONT
/P

PFONT =
SIZE=3D2#Replace('#f1_element#','quot;','','ALL')#gt;/FONT
/P

PFONT SIZE=3D2HTH/FONT
/P

PFONT SIZE=3D2Robert/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Ray, James A [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/=
A]/FONT
BRFONT SIZE=3D2Sent: Friday, September 08, 2000 2:05 PM/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Importing a text file/FONT
/P
BR

PFONT SIZE=3D2I have a file that I need to import that looks =
something like this./FONT
/P

Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT =
SIZE=3D2quot;A3quot;,quot;BOOSTER_TANK_ASSYquot;,quot;1B89037quot=
;,quot;Serial/FONT
BRFONT SIZE=3D2Numberquot;,#2000-09-09#,100,75,quot;Visual =
Goodquot;,quot;Noquot;nbsp; /FONT
/P

PFONT SIZE=3D2Now, I know how to import the, what I am having =
problems is that the data is/FONT
BRFONT SIZE=3D2surrounded by quot;'s. This is my Replace =
statement/FONT
/P

PFONT SIZE=3D2#Replace(quot;#f1_element#quot;,quot; =
quot;,quot; quot;,quot;ALLquot;)#gt;/FONT
/P

PFONT SIZE=3D2The question is, how do I stip out the quot;'s when =
quot;'s are part of the/FONT
BRFONT SIZE=3D2statement?/FONT
/P

PFONT SIZE=3D2Thank you for your help/FONT
/P

PFONT SIZE=3D2Jim Ray/FONT
/P
BR

PFONT =
SIZE=3D2---=
---/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/=
/A/FONT
BRFONT SIZE=3D2To Unsubscribe visit A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
sts/cf_talk" =
TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
body=3Dlists/cf_talk/A or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body./FONT/P

/BODY
/HTML
--_=_NextPart_001_01C019D6.3AD9C07E--
--
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[2]: An extremely need (semi-OT)

2000-09-08 Thread Alex Puritche

J.Milks,
Yes. You are right. Only this way.

Related URL
http://www.sqlteam.com/item.asp?ItemID=256


Friday, September 08, 2000, 10:13:23 PM, you wrote:

J.Milks Quite sure you can't pass arrays. What about passing a delimited CHAR field
J.Milks and looping on that? I have done that on several occasions. I.E: 2,5,7,23

J.Milks JM


J.Milks - Original Message -
J.Milks From: "Alex Puritche" [EMAIL PROTECTED]
J.Milks To: [EMAIL PROTECTED]
J.Milks Sent: Friday, September 08, 2000 1:16 PM
J.Milks Subject: An extremely need (semi-OT)


 cf-talk,

 I have a need to run a stored procedure which will insert multiple
 rows in the database. Biggest problem that I don't know from the
 begging how much inserts I need to do. I need to pass in the stored
 procedure an array of variables and loop over it.
 How I can pass complex datasets like arrays,lists, etc.
 in the stored procedure?
 How I can loop over that datasets in the stored procedure?

 --
  Regards,
  Alex  mailto:[EMAIL PROTECTED]

  Certified
  http://www.brainbench.com/transcript.jsp?pid=145368

  FAQ Project
  http://faq.worldrecovery.com/


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

J.Milks --
J.Milks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
J.Milks 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.


-- 
 Regards,
 Alexmailto:[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: Cfusers

2000-09-08 Thread Jim Taylor

http://www.mydollarmachine.com/cfusers

new look and feel

I thinks it would help if we have a place to go for a fully udated site to
send our ckients to see some of the sites that use coldfusion. so if you
will add your site. the More the Better.

- Original Message -
From: "Jim Taylor" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 05, 2000 4:19 PM
Subject: Cfusers


 This is a multi-part message in MIME format.

 --=_NextPart_000_0063_01C01755.11DE1540
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 can you guys and ladies add any sites that use coldfusion at =
 http://www.mydollarmachine.com/cfusers/index.cfm

 Thanks in advance
 Jim

 /Cfusers

 --=_NextPart_000_0063_01C01755.11DE1540
 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 content=3D"text/html; charset=3Diso-8859-1" =
 http-equiv=3DContent-Type
 META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2can you guys and ladies add any sites =
 that use=20
 coldfusion at A=20
 href=3D"http://www.mydollarmachine.com/cfusers/index.cfm"http://www.mydo=
 llarmachine.com/cfusers/index.cfm/A/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Thanks in advance/FONT/DIV
 DIVFONT face=3DArial size=3D2Jim/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial =
 size=3D2lt;/Cfusersgt;/FONT/DIV/BODY/HTML

 --=_NextPart_000_0063_01C01755.11DE1540--

 --

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

2000-09-08 Thread Jesse Noller

CF 4.0 is not supported on win2k, only CF 4.5.1

-Jesse

-Original Message-
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 4:32 PM
To: [EMAIL PROTECTED]
Subject: Re: cf 4.0  Win2K



- Original Message -
From: "Tim Bahlke" [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 6:08 PM

on Win2K.

 Is this correct?

From my own experience I can say that CF 4.00 does not run - it appears to
install OK  - but in my case did not register the CF services.  CF 4.01 does
run
but trashes elements of MDAC (at least with SQL Server) and is not
supported,
4.51 appears to run fine and is supported.

Adrian Cooper.



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



Setting structure values

2000-09-08 Thread Jon Tillman

Hey, I have a new problem.
I have need to change a value in a structure based on the following:

cfif StructFindNoCase(session.basket, #FORM.productID#)

How do I go about changing the returned value and updating the structure?

-- 
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
***
Help Jon build a network!
Looking for giveaway computers  parts
Current Need: Tape Drive  PI/PII processors
Email me to find out how you can help
***

--
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: Importing a text file

2000-09-08 Thread Chapman, Katrina

Like this

#Replace("#f1_element#","Chr(34)"," ","ALL")#


--K


-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:05 PM
To: [EMAIL PROTECTED]
Subject: Importing a text file


I have a file that I need to import that looks something like this.

"A3","BOOSTER_TANK_ASSY","1B89037","Serial
Number",#2000-09-09#,100,75,"Visual Good","No"  

Now, I know how to import the, what I am having problems is that the data is
surrounded by "'s. This is my Replace statement

#Replace("#f1_element#"," "," ","ALL")#

The question is, how do I stip out the "'s when "'s are part of the
statement?

Thank you for your help

Jim Ray



--
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: VBScript and WSH

2000-09-08 Thread Dave Watts

 Alright I know this is off topic, though it could be a little 
 on topic showing how verbose VBScript can be. I want to make a 
 VBS up so that it will check to see what version of virus scanner 
 software I have an execute the appropiate updates once it has it. 
 Does anyone know how to access the registry with VBS or already 
 has a working example of this?

It's very easy to do this, so I threw together an example:

' regreaddemo.vbs
Option Explicit

Dim oShell
Dim strKey
Dim strCurrentVersion

Set oShell = CreateObject("WScript.Shell")
strKey = "HKLM\Software\Allaire\Spectra\CurrentVersion"
strCurrentVersion = oShell.RegRead(strKey  "\Version")

MsgBox "Spectra Version: "  strCurrentVersion
' end regreaddemo.vbs

To run this example, you'll need to have Spectra installed, and type
"cscript regreaddemo.vbs" at the command line.

You'd have to know the appropriate registry key and value, of course, and
you'd want to add code to actually get the update and install it as well,
probably. Some virus scanner applications provide this functionality
automatically, as well.

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/
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: Replacing a value in the list form.fieldnames

2000-09-08 Thread Robert Hinojosa

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_01C019DD.E44CBCB8
Content-Type: text/plain;
charset="iso-8859-1"

cfset formField = Listgetat(Form.fieldnames, count)
CFSET "#formField#" = 4

HTH,

Robert

-Original Message-
From: Ian [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 3:47 PM
To: [EMAIL PROTECTED]
Subject: Replacing a value in the list form.fieldnames


I have a list of variables sent by a form. I need to make sure that none of
the variable values are incompatible with each other. This isn't the
problem.
The problem is changing the Form.whatever = value to a compatible value
(Form.field2 = 2. Form.field3 = 3 but 3 is not compatible with 2 so I need
to
change Form.field3 to = 4). Using CFSET I can't use a function on the left
side of the = CFSET (Listgetat(Form.fieldnames, count) = 4. I can't hard
code it because the fieldnames are drawn from a database and change
depending
on what itemthe form is built for. 

Any suggestions?

Ian


Get your own FREE, personal Netscape WebMail account today at
http://home.netscape.com/webmail

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

--_=_NextPart_001_01C019DD.E44CBCB8
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"
TITLERE: Replacing a value in the list form.fieldnames/TITLE
/HEAD
BODY

PFONT SIZE=3D2lt;cfset formField =3D Listgetat(Form.fieldnames, =
count)gt;/FONT
BRFONT SIZE=3D2lt;CFSET quot;#formField#quot; =3D 4gt;/FONT
/P

PFONT SIZE=3D2HTH,/FONT
/P

PFONT SIZE=3D2Robert/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Ian [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]=
et/A]/FONT
BRFONT SIZE=3D2Sent: Friday, September 08, 2000 3:47 PM/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Replacing a value in the list =
form.fieldnames/FONT
/P
BR

PFONT SIZE=3D2I have a list of variables sent by a form. I need to =
make sure that none of/FONT
BRFONT SIZE=3D2the variable values are incompatible with each =
other. This isn't the problem./FONT
BRFONT SIZE=3D2The problem is changing the Form.whatever =3D value =
to a compatible value/FONT
BRFONT SIZE=3D2(Form.field2 =3D 2. Form.field3 =3D 3 but 3 is not =
compatible with 2 so I need to/FONT
BRFONT SIZE=3D2change Form.field3 to =3D 4). Using CFSET I can't =
use a function on the left/FONT
BRFONT SIZE=3D2side of the =3D lt;CFSET =
(Listgetat(Form.fieldnames, count) =3D 4gt;. I can't hard/FONT
BRFONT SIZE=3D2code it because the fieldnames are drawn from a =
database and change depending/FONT
BRFONT SIZE=3D2on what itemthe form is built for. /FONT
/P

PFONT SIZE=3D2Any suggestions?/FONT
/P

PFONT SIZE=3D2Ian/FONT
/P

PFONT =
SIZE=3D2___=
_/FONT
BRFONT SIZE=3D2Get your own FREE, personal Netscape WebMail account =
today at A HREF=3D"http://home.netscape.com/webmail" =
TARGET=3D"_blank"http://home.netscape.com/webmail/A/FONT
BRFONT =
SIZE=3D2---=
---/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/=
/A/FONT
BRFONT SIZE=3D2To Unsubscribe visit A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
sts/cf_talk" =
TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
body=3Dlists/cf_talk/A or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body./FONT/P

/BODY
/HTML
--_=_NextPart_001_01C019DD.E44CBCB8--
--
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: Setting structure values

2000-09-08 Thread Chris Cortes

cfif StructFindNoCase(session.basket, FORM.productID)

cfset myStructure.key = "#MyNewValue#"

/cfif

All you need to do is set the structure key to the new value.

Chris Cortes
Consultant
[EMAIL PROTECTED]
Direct 713-985-6244
Cell 832-723-6485

Stonebridge Technologies
...The Fast Track to e-Business.
visit us at www.sbti.com


- Original Message -
From: "Jon Tillman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 4:33 PM
Subject: Setting structure values


 Hey, I have a new problem.
 I have need to change a value in a structure based on the following:

 cfif StructFindNoCase(session.basket, #FORM.productID#)

 How do I go about changing the returned value and updating the structure?

 --
 ***
  Jon Tillman
  LINUX USER: #141163
  ICQ: 4015362
  http://www.eruditum.org
  [EMAIL PROTECTED]
 ***
 Help Jon build a network!
 Looking for giveaway computers  parts
 Current Need: Tape Drive  PI/PII processors
 Email me to find out how you can help
 ***

 --

 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.



Regular expressions . . . a good tutorial somewhere?

2000-09-08 Thread Dan Haley

Anyone have a link to a decent tutorial for regex?  Can I look at Perl
tutorials for this and not be too far off on what to expect from CF?

Thanks,
Dan
--
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.



Novell User Management

2000-09-08 Thread Norman Elton

Previous Message:
Have a look at the Intranet Hosting Toolkit UserManager.

http://www.intrafoundation.com/intranethostingtoolkit.html


Has anybody a user management package like this for Novell NDS?

Norman Elton
Information Technology
College of William  Mary
--
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: Regular expressions . . . a good tutorial somewhere?

2000-09-08 Thread Jeremy Allen

Yes there are just a few pitfalls you have to watch out for some
parts of regular expressions do not work in CF.

-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 6:38 PM
To: '[EMAIL PROTECTED]'
Subject: Regular expressions . . . a good tutorial somewhere?


Anyone have a link to a decent tutorial for regex?  Can I look at Perl
tutorials for this and not be too far off on what to expect from CF?

Thanks,
Dan

--
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: Regular expressions . . . a good tutorial somewhere?

2000-09-08 Thread Marc Garrett

Danny Goodman's Javascript Bible has a chapter on regular expressions. Also,
the October issue of Web Techniques has a three page article.

I haven't played with regular expression and CF, so I can't answer your
second question.

Regards,

Marc Garrett

- Original Message -
From: "Dan Haley" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 08, 2000 6:37 PM
Subject: Regular expressions . . . a good tutorial somewhere?


 Anyone have a link to a decent tutorial for regex?  Can I look at Perl
 tutorials for this and not be too far off on what to expect from CF?


--
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: Uploading and emailing a file

2000-09-08 Thread Dave Watts

 The file is being saved on the server with the ORIGINAL 
 filename..not a different name.
 
 So, from my understanding of how this works comes a different
 questionwhat if two different users on the site happen to 
 hit the "SUBMIT" button on the form at the same time? Is it 
 possible for the attachments to get confused as to which email 
 they're supposed to be with? What if the remote possibility of 
 two users at the same time with the same file name? What the 
 heck happens then? If this is a possibility, what's the
 best way to prevent this before it CAN happen?

Yes, it's certainly possible that there may be problems if people upload
files with the same name at the same time. The first person may email the
second person's file, for example, or the second person's operation might
fail because of a locked file.

To avoid this, you could set the NAMECONFLICT attribute to "unique" instead
of "overwrite", then attach the uniquely named file (referencing
File.ServerFile to get that name). Alternatively, you could have your script
create a uniquely-named directory for each user, and upload the file or
files into that directory, then delete the directory and its contents when
you're done.

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



CFAdmin mapping works for INCLUDE but not for CFFILE

2000-09-08 Thread Peter Theobald

html
font size=3I set up a mapping in the CF Administrator so I can INCLUDE
files in the project and not worry about what the actual directory is.
ie: lt;cfinclude template=quot;/lib/myfile.cfmquot;gt;br
br
I want to do the same thing with CFFILE, but it seems to ignore CF
Mappings... Is there a specific definition anywhere of what CF
Administrator mappings actually affect? Is it ONLY CFINCLUDE?br
br
br
/fontbr

br
-font 
size=3--br
Peter Theobald, Chief Technology Officerbr
LiquidStreaming
a href="http://www.liquidstreaming.com/" 
eudora="autourl"http://www.liquidstreaming.com/abr
[EMAIL PROTECTED]br
Phone 1.212.545.1232 Fax 1.212.679.8032br
/font/html

--
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: CFAdmin mapping works for INCLUDE but not for CFFILE

2000-09-08 Thread Justin Kidman

CFFILE uses absolute paths on the server.  CFINCLUDE uses relative paths.
You can only use the mappings for relative paths.

Justin Kidman

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 5:06 PM
To: [EMAIL PROTECTED]
Subject: CFAdmin mapping works for INCLUDE but not for CFFILE


html
font size=3I set up a mapping in the CF Administrator so I can INCLUDE
files in the project and not worry about what the actual directory is.
ie: lt;cfinclude template=quot;/lib/myfile.cfmquot;gt;br
br
I want to do the same thing with CFFILE, but it seems to ignore CF
Mappings... Is there a specific definition anywhere of what CF
Administrator mappings actually affect? Is it ONLY CFINCLUDE?br
br
br
/fontbr

br
-font
size=3-
-br
Peter Theobald, Chief Technology Officerbr
LiquidStreaming
a href="http://www.liquidstreaming.com/"
eudora="autourl"http://www.liquidstreaming.com/abr
[EMAIL PROTECTED]br
Phone 1.212.545.1232 Fax 1.212.679.8032br
/font/html


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



  1   2   >