Re: Storing passwords in database as one way hash

[Dirk De Bock]

Show us the code! :-)

Or more politely, I'd love to have a look a that. Is this javascript code
publicly available?

Of course the effect is that the hash is sent across the wire instead of the
clear text password, so it could still be sniffed I guess.

- Original Message -
From: "BORKMAN Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 1:57 AM
Subject: RE: Storing passwords in database as one way hash


> Hi all,
>
> You can do better than hashing on the server side.  I use a JavaScript MD5
> hash on the client-side.  This prevents the password being sent over the
> network in clear, and alleviates the need for SSL in some circumstances.
>
> Works like a dream.
>
> Lee (Bjork) Borkman
> http://bjork.net ColdFusion Tags by Bjork
>
>
>
>
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used
by
> the named addressee.  It is confidential and may contain legally
privileged
> information.  No confidentiality or privilege is waived or lost by any
> mistaken transmission to you.  If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender.  You must
not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient.  The RTA is not responsible for any unauthorised alterations to
> this e-mail or attachment to it.
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Re: Storing passwords in database as one way hash

[Rob Keniger]

on 10/18/00 9:57 AM, BORKMAN Lee at [EMAIL PROTECTED] wrote:

> You can do better than hashing on the server side.  I use a JavaScript MD5
> hash on the client-side.  This prevents the password being sent over the
> network in clear, and alleviates the need for SSL in some circumstances.
> 
> Works like a dream.

Lee, all the MD5 hash Javascripts I've come across fail in Macintosh
browsers for some reason and return strings of zeroes. This makes them
useless for our purposes. Is this a script you've developed, or is it one of
the standard ones? Any idea if your script fails on Macs?

How do you handle surfers with JS turned off?

-- 

Rob Keniger

big bang solutions





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

Re: [Re: Preventing Simultaneous Logins]

[JL]

when a user is logging in with user name "Login1" and another user is trying
to log in with the same user name, what do u want to do?  kick out the first
user or stop the second user?

The first case is easy.  The second case is harder because you need to clean
up all the dead users in the table.  You don't need to create another table to
do this if you are storing the client variables in the database.

J

"Peter Alexandrou" <[EMAIL PROTECTED]> wrote:
> I can think of many similar solutions but they are all useless because most
> of the time users simply close their browsers or their sessions expire.
> 
> Surely someone out there has tackled this problem successfully?
> 
> - Original Message -
> From: "Pete Freitag" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 18, 2000 2:15 PM
> Subject: RE: Preventing Simultaneous Logins
> 
> 
> > Keep a log of when people login, and when they log out (could get very
> > large, but you could purge it daily).  Then when someone logs in do the
> > following...
> >
> > SELECT username FROM audit_table
> > WHERE
> > username = '#form.username#' AND
> > timestamp > #DateAdd("n", -30, Now())#
> > ORDER BY action
> >
> > That will see if  the user has been around in the last half hour
> >
> > Action could be a boolean field 1 being login 0 being logout
> > 
> > 
> > already logged in 
> > 
> > 
> > login...
> >
> > The problem with this entire process, is that there is no destructor
> called
> > when a session disappears, or times out.
> >
> > __
> > Pete Freitag ([EMAIL PROTECTED])
> > CFDEV.COM / NETDesign Inc.
> > ColdFusion Developer Resources
> > http://www.cfdev.com/
> >
> > -Original Message-
> > From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 17, 2000 7:37 PM
> > To: CF-Talk
> > Subject: Preventing Simultaneous Logins
> >
> >
> > Hi guys,
> >
> > I'm new to the mailing list and have a quick question for y'all.
> >
> > What is the best way to prevent a userID being logged in twice i.e.
> someone
> > logs in with "login1" and then another user logs in with the same ID.
> >
> > Thanks,
> >
> > Peter Alexandrou
> > Technical Leader
> >
> > tapestry communications : www.tapestry.net.au
> > phone : 0411 445 111
> > e-mail : [EMAIL PROTECTED]
> >
> >
--
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a
> > message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
> >
--
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> 
>

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



Get free email and a permanent address at http://www.netaddress.com/?N=1

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

RE: File replication packages

[Stewart McGowan]

We use various flavours of Veritas Replication, its expensive but it works
very nicely

http://www.veritas.com/us/products/replication/


Regards

Stew

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

RE: Html email??

[Neil Clark]

this should do the trick



Neil

http://www.mcbdigital.com
--->




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

RE: Storing passwords in database as one way hash -The Solution

[Neil Clark]

Okay, hash-ing the password seems to be an overkill - why not simply
generate a random key which you can use with encrypt(form.password, key)
this value can then be placed in the db along with the key...  when it comes
to it, simply decrypt the form.password with the given key and you're away.
If they don't match - see ya, if they do - cool. ;-)

People 'peeking' in your DB should never be a problem if it is set up
correctly with security et al.

Neil

http://www.mcbdigital.com
--->




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

RE:

[Dominic J. Doucet-Lorang]

I would nominate David Shadovitz.  David has given me very good advice on
how do do a few things in ColdFusion.

Dominic J. Doucet-Lorang
Telemark Medieutvikling AS
Norway

>- Original Message -
>From: "Adam Phillip Churvis"
><[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, October 17, 2000 6:44 PM
>Subject:  Awards
>
>
>> FusionFolks,
>>
>> I would like to propose an annual award for the most
>helpful people in the
>> CF community.  The name I picked for this award is
>, because a
>> "Mensch" is a really caring person who treats others
>with respect, who
>> performs acts of kindness, and who tries to make the
>community a better place.
>>
>> The people I would like to nominate are:
>>
>> Michael Dinowitz
>> Dave Watts
>> Cameron Childress
>>
>> I see some really outstanding advice and help coming
>from these folks (any
>> many others, to be sure), so I think we ought to
>"brand" them accordingly!
>>
>> There are so many who help, and my list contains
>only those who stick out
>> in my mind most prominently, so I hope others will
>add their nominations, too.
>>
>> What do you think, folks?
>>
>> Respectfully,
>>
>> Adam Phillip Churvis
>> President
>> Productivity Enhancement, Inc.
>>
>>
>***
*
>> *  PRODUCTIVITY ENHANCEMENT,
>INC.  *
>> *
>  *
>> *Publishers of the CommerceBlocks line of
>modular development tools*
>> *  for ColdFusion
>  *
>> *
>  *
>> * Website: http://www.commerceblocks.com   E-mail:
>[EMAIL PROTECTED] *
>> * Phone:   770-446-8866Fax:
>770-242-0410*
>> *
>  *
>>
>***
*
>>
>>
>---
-
>
>> Archives:
>http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe:
>http://www.houseoffusion.com/index.cfm?sidebar=lists
>or send a message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>>
>
>__
>Do You Yahoo!?
>Yahoo! Messenger - Talk while you surf!  It's FREE.
>http://im.yahoo.com/
>---
-
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

Publishers of the CommerceBlocks line of
modular ColdFusion development tools

Website: http://www.commerceblocks.com
E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866


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


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

Re: Awards

[Jon Hall]

I gotta nominate Pan...while he doesn't post much. He is da man.

jon
- Original Message -
From: "Adam Phillip Churvis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 17, 2000 6:44 PM
Subject:  Awards


> FusionFolks,
>
> I would like to propose an annual award for the most helpful people in the
> CF community.  The name I picked for this award is , because a
> "Mensch" is a really caring person who treats others with respect, who
> performs acts of kindness, and who tries to make the community a better
place.
>
> The people I would like to nominate are:
>
> Michael Dinowitz
> Dave Watts
> Cameron Childress
>
> I see some really outstanding advice and help coming from these folks (any
> many others, to be sure), so I think we ought to "brand" them accordingly!
>
> There are so many who help, and my list contains only those who stick out
> in my mind most prominently, so I hope others will add their nominations,
too.
>
> What do you think, folks?
>
> Respectfully,
>
> Adam Phillip Churvis
> President
> Productivity Enhancement, Inc.
>
>

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

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


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

Re: Storing passwords in database as one way hash -The Solution

[Rob Keniger]

on 10/18/00 6:43 PM, Neil Clark at [EMAIL PROTECTED] wrote:

> Okay, hash-ing the password seems to be an overkill - why not simply
> generate a random key which you can use with encrypt(form.password, key)
> this value can then be placed in the db along with the key...  when it comes
> to it, simply decrypt the form.password with the given key and you're away.
> If they don't match - see ya, if they do - cool. ;-)
> 
> People 'peeking' in your DB should never be a problem if it is set up
> correctly with security et al.

But because you are providing the key anyone with access to the database and
a copy of ColdFusion can instantly decrypt all the passwords. The hash
method is far better because even if the database security is broken the
passwords are still secure.

-- 

Rob Keniger

big bang solutions





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

SQL: Rename a column

[Aidan Whitehall]

How do you rename a column (or should that be field) using a SQL statement?

I've started playing around with ALTER TABLE and CONSTRAINTS, but can't find
the syntax for this.


Thanks in advance.


BTW, *completely* off topic, but does ICQ 2000b have Active Lists? I was on
2 CF Active Lists but there's no AL button on the latest version.

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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

RE: Rename a column

[Andy Ewings]

You're on the right track.  You can use alter table here is the syntax from
SQL help

ALTER TABLE table
{   [ALTER COLUMN column_name
{   new_data_type [ (precision[, scale] ) ]
[ NULL | NOT NULL ]
| {ADD | DROP} ROWGUIDCOL
}
]
| ADD
{   [  ]
|  column_name AS computed_column_expression
}[,...n]
| [WITH CHECK | WITH NOCHECK] ADD
{  }[,...n]
| DROP
{   [CONSTRAINT] constraint_name
| COLUMN column
}[,...n]
| {CHECK | NOCHECK} CONSTRAINT
{ALL | constraint_name[,...n]}
| {ENABLE | DISABLE} TRIGGER
{ALL | trigger_name[,...n]}
}

however I suggest you write an SP that creates a temporary table with the
old table structure, insert all of the data into it from the table, drop the
old table, re-create t with the new structure, and the re-insert the data
from the temporary table.  Wrap all of this in a Transaction to ensure it
works ok.


-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2000 10:47
To: CF-Talk
Subject: SQL: Rename a column


How do you rename a column (or should that be field) using a SQL statement?

I've started playing around with ALTER TABLE and CONSTRAINTS, but can't find
the syntax for this.


Thanks in advance.


BTW, *completely* off topic, but does ICQ 2000b have Active Lists? I was on
2 CF Active Lists but there's no AL button on the latest version.

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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651


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

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

RE: Storing passwords in database as one way hash -The Solution

[Neil Clark]

Not sure what you mean - there is a unique key for every user... Also how
are you giving *every user* access the DB?  are you talking about when the
user is at the machine or via the web?

N

http://www.mcbdigital.com
--->




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

Re: Passwords in O'Reilly WebSite

[W Luke]

Hi,

Once I've entered the code as follows, how do I get the output or Error
Level?



Cheers,

Will

- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Tuesday, October 17, 2000 4:54 PM
Subject: Re: Passwords in O'Reilly WebSite


> http://www.houseoffusion.com/cfapi/cfx_wsauth.zip
> Does the crypto for you and I got the code for that section directly from
> Denny.
>
>
> > Hello,
> >
> > The Users' passwords in the Registry of O'Reilly WebSite are all
> encrpyted.
> > Fine.
> >
> > I'm creating an App in CF to automate WebSite - but I don't know how to
> > encrypt the passwords. If I enter in a plain-text password, it doesn't
> like
> > it.
> >
> > Can anyone advise as to what I should do?
> >
> > Thanks
> >
> > Will
> >
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

RE: [OT] ICQ2000b Active Lists

[Paul Crick]

> BTW, *completely* off topic, but does ICQ 2000b have Active Lists?
> I was on CF Active Lists but there's no AL button on the latest version.

I think it's a plug in. Check the plug in area off the downloads page and
I'm pretty sure it's there.

Cheers
Paul


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

RE: Rename a column

[Aidan Whitehall]

Thanks for the reply, Andy.

> ALTER TABLE table
> { [ALTER COLUMN column_name
[snip]
> to ensure it works ok.

I appreciate what you say about SPs but this on an Access database and I've
never used SPs.

Unfortunately the machine the DB is on doesn't have Access installed (it's a
network admin thang  ;-), hence the need to do this via SQL statements.

Would the SQL statement be something like (guessing here):

ALTER TABLE TableName {ADD NewColumnName AS OldColumnName}???


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

Creating Excel Documents

[seth ward]

I am desperately trying to output the contents of a query into a new
Excel document; I have just about managed to open Excel on the client's
machine using cfobject and some cfscript but it seems that i just get
errors when trying to follow the Microsoft Visual Basic instructions in
Excel.
 
I can't seem to actually enter any data, save the worksheet or
anything...
 
The code I can use successfully is below. The problem I get is if I then
try to use 
newDoc.Range("A1").Value = 1;
 
to set the first cell in the worksheet to have a value of 1.
 
I get an invalid parser error, even though it is the exact syntax copied
from the example given on the range property.
 
HELP, Please! Is there an easier way???
 

code begins
---
 
 

   
  
  
   
 
  

 


/* This will open Excel if running locally */
objExcel.Visible = true;

/* This returns the 'Documents' collection the Excel Object */
objBook = objExcel.Workbooks;

/* Create a new document */
newDoc = objBook.add();

 

 
 
--
code ends
--

seth ward


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp


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

RE: Creating Excel Documents

[Stewart McGowan]

Seth

CFX_Excel works well and is available @

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34728E-2830-11D4-AA
9700508B94F380&method=Full

Regards


Stew

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

Extension to custom functions...

[Paul Johnston]

Can anyone think of a way of calling custom tags from within functions or
cfscript?

I think it's possible using a variation of Michael Dinowitz custom
functions.  Just set up a page full of custom tags, and set up a function
that you pass in various values to and it returns a value.  This value is
then used in a cfswitch to pull in certain cfcase statements.

It's just an idea at the moment, but I think it may work.

Anyone see any deliberate mistakes?  The only problem I can see (possibly)
is how to move from the cfscript/functions to the tag.

... at this point my mind is going a bit into overdrive ...

This could be got round by creating a temporary file and sticking cf code in
there. The function could then output a variable, which gets written to a
file, is cfincluded into the page and then it is cold fusion code ...

Maybe I'll try and write something...

Paul



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

RE: Rename a column

[Andy Ewings]

NopeI think you need:I've had a look at the syntax nd I'm not sure you
can alter column names with ALTER TABLE although I may be wrong.  I reckon
your best bet is to use ALTER TABLE to create a new column and insert all of
the data into it from the other column and then delete the existing column.
This can be done using a series of ALTER TABLE statements, one to create the
new column, then an insert statement to copy the data, then another ALTER
TABLE statement to drop the old field.

As I say I've never really used ALTER TABLE before so I'm not sure if it'll
work.  Bear in mind that I'm talking about Transact SQL so this may not be
ANSI standard so may need some fiddling in Access


-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2000 11:42
To: CF-Talk
Subject: RE: Rename a column


Thanks for the reply, Andy.

> ALTER TABLE table
> { [ALTER COLUMN column_name
[snip]
> to ensure it works ok.

I appreciate what you say about SPs but this on an Access database and I've
never used SPs.

Unfortunately the machine the DB is on doesn't have Access installed (it's a
network admin thang  ;-), hence the need to do this via SQL statements.

Would the SQL statement be something like (guessing here):

ALTER TABLE TableName {ADD NewColumnName AS OldColumnName}???


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651


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

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

Re: Creating Excel Documents

[Dave Hannum]

Have you tried using QueryNew, QuerySetCell and QueryAddRow in conjunction
with CFX_Excel?  I use it here with tremendous success on some very heavily
used applications.  You need to have Excel on the server to use this, but it
work great!  I creates the Excel file on the server, then using CFCONTENT
you can download the file and delete it off the server to keep things tidy!

Dave


=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: "seth ward" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 6:59 AM
Subject: Creating Excel Documents


I am desperately trying to output the contents of a query into a new
Excel document; I have just about managed to open Excel on the client's
machine using cfobject and some cfscript but it seems that i just get
errors when trying to follow the Microsoft Visual Basic instructions in
Excel.

I can't seem to actually enter any data, save the worksheet or
anything...

The code I can use successfully is below. The problem I get is if I then
try to use
newDoc.Range("A1").Value = 1;

to set the first cell in the worksheet to have a value of 1.

I get an invalid parser error, even though it is the exact syntax copied
from the example given on the range property.

HELP, Please! Is there an easier way???


code begins
---




  
  


  




/* This will open Excel if running locally */
objExcel.Visible = true;

/* This returns the 'Documents' collection the Excel Object */
objBook = objExcel.Workbooks;

/* Create a new document */
newDoc = objBook.add();





--
code ends
--

seth ward


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp



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


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

Re: Storing passwords in database as one way hash -The Solution

[Rob Keniger]

on 10/18/00 8:03 PM, Neil Clark at [EMAIL PROTECTED] wrote:

> Not sure what you mean - there is a unique key for every user... Also how
> are you giving *every user* access the DB?  are you talking about when the
> user is at the machine or via the web?

*IF* your site is hacked and someone gets full access to the database, if
you store the key as well as the encrypted password then all the user
passwords are there for the taking. If you encrypt then with a one-way hash
instead the passwords are still secure and cannot be decrypted even to a
user with full access.

Mind you, this probably doesn't matter because if someone gets access to the
database they probably wouldn't care about the user passwords anyway.

-- 

Rob Keniger

big bang solutions





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

RE: Storing passwords in database as one way hash -The Solution

[Neil Clark]

yep, understood, solution - keep your DB server secure, store the key
somewhere else on a cluster or even in a secure file.

N

http://www.mcbdigital.com
--->




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

RE: Extension to custom functions...

[Paul Johnston]

Sorry.  I was having a bit of a mare there!  The only thing that you would
need for this to happen is a variable that if it was changed within the page
could call a function at any point. This cannot happen, because all
variables are set at the time of execution (unless you can think of a
workaround).

Effectively, all you need is to put in a load of code if something changes
(maybe you could use error checking to include it with ).

Paul

> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 18 October 2000 12:15
> To: CF-Talk
> Subject: Extension to custom functions...
>
>
> Can anyone think of a way of calling custom tags from within functions or
> cfscript?
>
> I think it's possible using a variation of Michael Dinowitz custom
> functions.  Just set up a page full of custom tags, and set up a function
> that you pass in various values to and it returns a value.  This value is
> then used in a cfswitch to pull in certain cfcase statements.
>
> It's just an idea at the moment, but I think it may work.
>
> Anyone see any deliberate mistakes?  The only problem I can see (possibly)
> is how to move from the cfscript/functions to the tag.
>
> ... at this point my mind is going a bit into overdrive ...
>
> This could be got round by creating a temporary file and sticking
> cf code in
> there. The function could then output a variable, which gets written to a
> file, is cfincluded into the page and then it is cold fusion code ...
>
> Maybe I'll try and write something...
>
> Paul
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>



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

RE: Storing passwords in database as one way hash -The Solution

[Jon Tillman]

On Wed, 18 Oct 2000, Neil Clark spake thusly:
> Okay, hash-ing the password seems to be an overkill - why not simply
> generate a random key which you can use with encrypt(form.password, key)
> this value can then be placed in the db along with the key...  when it comes
> to it, simply decrypt the form.password with the given key and you're away.
> If they don't match - see ya, if they do - cool. ;-)

because i want them encrypted in the db.
It isn't overkill, there is nothing that is overkill, when it comes to
security. Remember, security isn't a product, it is a way of life :)

> 
> People 'peeking' in your DB should never be a problem if it is set up
> correctly with security et al.

'never' is not a word that exists in the security field...

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


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

Re: Storing passwords in database as one way hash -The Solution

[Jon Tillman]

On Wed, 18 Oct 2000, Rob Keniger spake thusly:
> on 10/18/00 8:03 PM, Neil Clark at [EMAIL PROTECTED] wrote:
> 
> > Not sure what you mean - there is a unique key for every user... Also how
> > are you giving *every user* access the DB?  are you talking about when the
> > user is at the machine or via the web?
> 
> *IF* your site is hacked and someone gets full access to the database, if
> you store the key as well as the encrypted password then all the user
> passwords are there for the taking. If you encrypt then with a one-way hash
> instead the passwords are still secure and cannot be decrypted even to a
> user with full access.
> 
> Mind you, this probably doesn't matter because if someone gets access to the
> database they probably wouldn't care about the user passwords anyway.

thats why we are setting up a 'password' server seperate from all our hosting
servers, that will only store hashed passwords.

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


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

RE: Storing passwords in database as one way hash -The Solution

[Neil Clark]

you will have them encypted in the DB.

by generating a random key (using a custom tag I wrote ;-) - say
'284un#'][fn7' you will actually have 3 values.

used in this way -

   (this will actually be generated at
run-time)


then store #tEncryptPWD# in the DB with tKey either in the DB as well or
somewhere else.

The value in the DB which would probably be something like '-06[45;65554'
etc...

at validation - get the encrypted pwd, decrypt it with corresponding key
(unique for each user) and hey presto ure away - no match?  go away,
match? - ure in!!!

N

http://www.mcbdigital.com
--->




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

RE: Storing passwords in database as one way hash -The Solution

[Neil Clark]

doesn't seem a point in doing that - why create even more ODBC load than u
need to?


http://www.mcbdigital.com
--->




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

Writing to Excel - answers

[Chris Norloff]

[Amazing how simple some problems are ... AFTER you find the solution.]

In answer to the question about writing to Excel spreadsheets, Allaire's Developers' 
Exchange has many possible solutions.

http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=excel

Chris Norloff



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

Crystal Reports

[Anita Kriz]

I was wondering if anyone has any experience with Crystal Reports. I am
interested in using this product with CF and Visual Basic and would like to
know whether or not anyone has found it useful or maybe has a better way to
go.

Thanks

Anita Kriz




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

Re: Awards

[Dick Applebaum]

I nominate Judith Dinowitz

she keeps us all focused with a a gentle nudge when needed

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

getting query results based on day

[Dominic J. Doucet-Lorang]

I am trying to pull information from a database table based upon the date
and a couple of other items.  I have tried to use a query wher I comparied
the date column in the table with  now() but it gets no results. the query
looks like this:

select distinct forsikring.*,kunde.*
from forsikring, kunde
where  forsikring.refnr = #refnr2# AND forsikring.id = kunde.id and dos =
Now()

It will get results if I remove the dos = Now()
It needs to just get the records if the date is today also.


Dominic


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

RE: Include Perl script?

[Raymond K. Camden]

It would be better to use CFEXECUTE to call the Perl script. This is
assuming you have CF 4.5+.

===
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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


> -Original Message-
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 7:52 PM
> To: CF-Talk
> Subject: RE: Include Perl script?
>
>
> Try CFHTTP and include the results into your CFM page.
>
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
>
>
> > -Original Message-
> > From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 17, 2000 2:03 PM
> > To: CF-Talk
> > Subject: Include Perl script?
> >
> >
> > I am trying to include a poll.cgi perl script into my .cfm
> page, but I am
> > having trouble getting the .cgi to parse, read the templates,
> and spit the
> > page back to me as an include...
> >
> > any ideas?
> >
> > thanks,
> >
> > ethan
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

Avoiding erros with CFRegistry

[W Luke]

Hi.

I'm looping through a Registry Entry, and inserting the String Names into a
Database.

However, one or 2 of the Entries generate an error because the Key doesn't
exist.  How can I avoid generating these errors?  I've listed my code below
if that's any help:

  



INSERT into Users (User,Realm)
VALUES ('#users.Entry#','#Windows.Entry#')



It's getting stuck when it tries to connect to a Registry Key that doesn't
have '\Users' appended to it.  Should I be looking at a customised Error
page for my App, or something else?

Thanks muchly :)

Will


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

Re: (Admin) Ads

[Larry W. Virden]

From: "Michael Dinowitz" <[EMAIL PROTECTED]>

> One of the things I'm going to add to this is a small CF program to trim out
> the ad and the admin info at bottom when its part of a reply. Should save a
> TON of space.

How about trimming out excess such as attachments, massive quoting of
previous msgs, etc.?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden  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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: getting query results based on day

[Stewart McGowan]

Dominic,

I'd check the datatypes are consistant and then check for your dB if you
need to cast or convert the now() function

Regards

Stew

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

Re: [Re: Preventing Simultaneous Logins]

[Peter Alexandrou]

The first case would suffice.  Could you let me know how you go about it?

Many thanks.

- Original Message -
From: "JL" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 5:47 PM
Subject: Re: [Re: Preventing Simultaneous Logins]


> when a user is logging in with user name "Login1" and another user is
trying
> to log in with the same user name, what do u want to do?  kick out the
first
> user or stop the second user?
>
> The first case is easy.  The second case is harder because you need to
clean
> up all the dead users in the table.  You don't need to create another
table to
> do this if you are storing the client variables in the database.
>
> J
>
> "Peter Alexandrou" <[EMAIL PROTECTED]> wrote:
> > I can think of many similar solutions but they are all useless because
most
> > of the time users simply close their browsers or their sessions expire.
> >
> > Surely someone out there has tackled this problem successfully?
> >
> > - Original Message -
> > From: "Pete Freitag" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 18, 2000 2:15 PM
> > Subject: RE: Preventing Simultaneous Logins
> >
> >
> > > Keep a log of when people login, and when they log out (could get very
> > > large, but you could purge it daily).  Then when someone logs in do
the
> > > following...
> > >
> > > SELECT username FROM audit_table
> > > WHERE
> > > username = '#form.username#' AND
> > > timestamp > #DateAdd("n", -30, Now())#
> > > ORDER BY action
> > >
> > > That will see if  the user has been around in the last half hour
> > >
> > > Action could be a boolean field 1 being login 0 being logout
> > > 
> > > 
> > > already logged in 
> > > 
> > > 
> > > login...
> > >
> > > The problem with this entire process, is that there is no destructor
> > called
> > > when a session disappears, or times out.
> > >
> > > __
> > > Pete Freitag ([EMAIL PROTECTED])
> > > CFDEV.COM / NETDesign Inc.
> > > ColdFusion Developer Resources
> > > http://www.cfdev.com/
> > >
> > > -Original Message-
> > > From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, October 17, 2000 7:37 PM
> > > To: CF-Talk
> > > Subject: Preventing Simultaneous Logins
> > >
> > >
> > > Hi guys,
> > >
> > > I'm new to the mailing list and have a quick question for y'all.
> > >
> > > What is the best way to prevent a userID being logged in twice i.e.
> > someone
> > > logs in with "login1" and then another user logs in with the same ID.
> > >
> > > Thanks,
> > >
> > > Peter Alexandrou
> > > Technical Leader
> > >
> > > tapestry communications : www.tapestry.net.au
> > > phone : 0411 445 111
> > > e-mail : [EMAIL PROTECTED]
> > >
> > >
> --
> > --
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> > a
> > > message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> > >
> > >
> --
> > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
> >
> --
--
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar


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

RE: Include Perl script?

[Richard Kuryk]

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

I know activestate has a Perl Dev Kit 2.0 (win only) which has a com object
which you could call from coldfusion and code perl inside of cold fusion.  I
don't have this dev kit and haven't tried it but would be curious if anyone
has done this.

Rich

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 5:03 PM
To: CF-Talk
Subject: Include Perl script?


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

any ideas?

thanks,

ethan


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

--_=_NextPart_001_01C038FE.9E2C000A
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Include Perl script?



I know activestate has a Perl Dev Kit 2.0 (win only) =
which has a com object which you could call from coldfusion and code =
perl inside of cold fusion.  I don't have this dev kit and haven't =
tried it but would be curious if anyone has done this.

Rich


-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]">mailto:ethan@foureyesprodu=
ctions.com]
Sent: Tuesday, October 17, 2000 5:03 PM
To: CF-Talk
Subject: Include Perl script?



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


any ideas?


thanks,


ethan


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

To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.



--_=_NextPart_001_01C038FE.9E2C000A--

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

RE: Rename a column

[Aidan Whitehall]

> NopeI think you need:I've had a look at the syntax nd I'm 
[snip]
> another ALTER TABLE statement to drop the old field.

Okie dokie... someone else here mentioned that might be the only way of
doing it.

Thanks for the advice.


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

Re: Avoiding erros with CFRegistry

[David Shadovitz]

You could use CFTRY / CFCATCH.  In the CFCATCH, either do nothing or
report the error.
-David

On Wed, 18 Oct 2000 13:18:32 +0100 "W Luke" <[EMAIL PROTECTED]>
writes:
> Hi.
> 
> I'm looping through a Registry Entry, and inserting the String Names 
> into a
> Database.
> 
> However, one or 2 of the Entries generate an error because the Key 
> doesn't
> exist.  How can I avoid generating these errors?  I've listed my 
> code below
> if that's any help:
> 
>   
> 
>  type="Any" name="users" sort="Type ASC, Entry ASC">
> 
> INSERT into Users (User,Realm)
> VALUES ('#users.Entry#','#Windows.Entry#')
> 
> 
> 
> It's getting stuck when it tries to connect to a Registry Key that 
> doesn't
> have '\Users' appended to it.  Should I be looking at a customised 
> Error
> page for my App, or something else?

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

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

Re: getting query results based on day

[David Shadovitz]

Dominic,

There are two issues here:

First, is "dos" a date, or a date/time?  Now() is a date/time, so it's
not likely you'll match any entries down to the current time.  If dos is
just a date, you'd need to manipulate Now() to get the date part of it. 
If dos includes the time, you'll need to test on the difference between
dos and Now().

Second, you need to work in ODBC dates/times.

Can you show us how you insert dos?

-David

On Wed, 18 Oct 2000 14:13:38 +0200 "Dominic J. Doucet-Lorang"
<[EMAIL PROTECTED]> writes:
> I am trying to pull information from a database table based upon the 
> date
> and a couple of other items.  I have tried to use a query wher I 
> comparied
> the date column in the table with  now() but it gets no results. the 
> query
> looks like this:
>debug>
>   select distinct forsikring.*,kunde.*
>   from forsikring, kunde
>   where  forsikring.refnr = #refnr2# AND forsikring.id = 
> kunde.id and dos =
> Now()
>   
> It will get results if I remove the dos = Now()
> It needs to just get the records if the date is today also.
> 
> 
> Dominic
> 
>
-
---
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or 
> send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


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

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

Fast seure communication

[Robert Everland]

I saw a product once that would allow you to put your secure
certificate to a box that would speed up encryption. I can't find it
anywhere now that I need one. I could have sworn Intel made something like
this but can't remember where i saw it at. Anyone know?

Robert Everland III
Web Developer
Dixon Ticonderoga


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

RE: getting query results based on day

[Dominic J. Doucet-Lorang]

this is the code I used to create the record.






Dominic J. Doucet-Lorang

-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 3:03 PM
To: CF-Talk
Subject: Re: getting query results based on day


Dominic,

There are two issues here:

First, is "dos" a date, or a date/time?  Now() is a date/time, so it's
not likely you'll match any entries down to the current time.  If dos is
just a date, you'd need to manipulate Now() to get the date part of it.
If dos includes the time, you'll need to test on the difference between
dos and Now().

Second, you need to work in ODBC dates/times.

Can you show us how you insert dos?

-David

On Wed, 18 Oct 2000 14:13:38 +0200 "Dominic J. Doucet-Lorang"
<[EMAIL PROTECTED]> writes:
> I am trying to pull information from a database table based upon the
> date
> and a couple of other items.  I have tried to use a query wher I
> comparied
> the date column in the table with  now() but it gets no results. the
> query
> looks like this:
>debug>
>   select distinct forsikring.*,kunde.*
>   from forsikring, kunde
>   where  forsikring.refnr = #refnr2# AND forsikring.id =
> kunde.id and dos =
> Now()
>   
> It will get results if I remove the dos = Now()
> It needs to just get the records if the date is today also.
>
>
> Dominic
>
>
-
---
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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


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


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

No Subject

[Stephanie Nordenhaug]

This is a multi-part message in MIME format.

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

Well, it may not be kosher, but I'd like to nominate Adam Churvis =
without whom I wouldn't be here today! ;-)

Adam has put in a lot of hard work to the Cold Fusion community around =
here and is most definitely a  in every sense of the word!

Thanks Adam for all you help!

Stephanie=20

Stephanie Nordenhaug
Web Developer
Station To Station, Inc.
[EMAIL PROTECTED]
(404) 609 7820 ext. 277

- Original Message -
From: "Adam Phillip Churvis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 17, 2000 6:44 PM
Subject:  Awards


> FusionFolks,
>
> I would like to propose an annual award for the most helpful people in =
the
> CF community.  The name I picked for this award is , =
because a
> "Mensch" is a really caring person who treats others with respect, who
> performs acts of kindness, and who tries to make the community a =
better
place.
>
> The people I would like to nominate are:
>
> Michael Dinowitz
> Dave Watts
> Cameron Childress
>
> I see some really outstanding advice and help coming from these folks =
(any
> many others, to be sure), so I think we ought to "brand" them =
accordingly!
>
> There are so many who help, and my list contains only those who stick =
out
> in my mind most prominently, so I hope others will add their =
nominations,
too.
>
> What do you think, folks?
>
> Respectfully,
>
> Adam Phillip Churvis
> President
> Productivity Enhancement, Inc.
>
>
*=
***
> *  PRODUCTIVITY ENHANCEMENT, INC.
*
> *
*
> *Publishers of the CommerceBlocks line of modular development =
tools
*
> *  for ColdFusion
*
> *
*
> * Website: http://www.commerceblocks.com   E-mail: =
[EMAIL PROTECTED]
*
> * Phone:   770-446-8866Fax:770-242-0410
*
> *
*
>
*=
***
>
> =
-=
-
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists or =
send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

--

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








Well, it may not be kosher, but I'd =
like to=20
nominate Adam Churvis without whom I wouldn't be here today! =
;-)
 
Adam has put in a lot of hard work to =
the Cold=20
Fusion community around here and is most definitely a  =
in every=20
sense of the word!
 
Thanks Adam for all you =
help!
 
Stephanie 
 

Stephanie NordenhaugWeb =
Developer
Station To Station, Inc.mailto:[EMAIL PROTECTED]">stephanie@stationtostation=
.com(404)=20
609 7820 ext. 277
 
- Original Message -From: "Adam Phillip Churvis" [EMAIL PROTECTED]&g=
t;To:=20
"CF-Talk" [EMAIL PROTECTED]&g=
t;Sent:=20
Tuesday, October 17, 2000 6:44 PMSubject: =20
Awards> FusionFolks,>> I would like to =
propose an=20
annual award for the most helpful people in the> CF =
community.  The=20
name I picked for this award is , because a> =
"Mensch" is=20
a really caring person who treats others with respect, who> =
performs acts=20
of kindness, and who tries to make the community a=20
betterplace.>> The people I would like to nominate=20
are:>> Michael Dinowitz> Dave Watts> Cameron =

Childress>> I see some really outstanding advice and help =
coming=20
from these folks (any> many others, to be sure), so I think we =
ought to=20
"brand" them accordingly!>> There are so many who help, =
and my=20
list contains only those who stick out> in my mind most =
prominently, so I=20
hope others will add their nominations,too.>> What do =
you=20
think, folks?>> Respectfully,>> Adam Phillip =

Churvis> President> Productivity Enhancement,=20
Inc.>>*=
***>=20
*=
 =20
PRODUCTIVITY ENHANCEMENT, INC.*> **> =
*   =20
Publishers of the CommerceBlocks line of modular development =
tools*>=20
*=
&=
nbsp;=20
for ColdFusion*> **> * Website: http://www.commerceblocks.com">http://www.commerceblocks.com&=
nbsp; =20
E-mail: mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]*<=
BR>> *=20
Phone:  =20
770-446-8866  &=
nbsp;=20
Fax:    770-242-0410*>=20
**>***=
*>>=20
-=
--->=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion

RE: getting query results based on day

[Dominic J. Doucet-Lorang]

dos is a date/time.  I only need to compare the date part.


-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 3:03 PM
To: CF-Talk
Subject: Re: getting query results based on day


Dominic,

There are two issues here:

First, is "dos" a date, or a date/time?  Now() is a date/time, so it's
not likely you'll match any entries down to the current time.  If dos is
just a date, you'd need to manipulate Now() to get the date part of it.
If dos includes the time, you'll need to test on the difference between
dos and Now().

Second, you need to work in ODBC dates/times.

Can you show us how you insert dos?

-David

On Wed, 18 Oct 2000 14:13:38 +0200 "Dominic J. Doucet-Lorang"
<[EMAIL PROTECTED]> writes:
> I am trying to pull information from a database table based upon the
> date
> and a couple of other items.  I have tried to use a query wher I
> comparied
> the date column in the table with  now() but it gets no results. the
> query
> looks like this:
>debug>
>   select distinct forsikring.*,kunde.*
>   from forsikring, kunde
>   where  forsikring.refnr = #refnr2# AND forsikring.id =
> kunde.id and dos =
> Now()
>   
> It will get results if I remove the dos = Now()
> It needs to just get the records if the date is today also.
>
>
> Dominic
>
>
-
---
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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


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


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

RE: Fast seure communication

[Aaron Johnson]

intel netstructure ecommerce line:

http://www.intel.com/netstructure/ecommerce_equipment.htm

AJ

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 9:11 AM
To: CF-Talk
Subject: Fast seure communication


I saw a product once that would allow you to put your secure
certificate to a box that would speed up encryption. I can't find it
anywhere now that I need one. I could have sworn Intel made something like
this but can't remember where i saw it at. Anyone know?

Robert Everland III
Web Developer
Dixon Ticonderoga



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


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

RE: [OT] ICQ2000b Active Lists

[Aidan Whitehall]

> I think it's a plug in. Check the plug in area off the 
> downloads page and
> I'm pretty sure it's there.

Great - thanks.


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

RE: (Admin) Ads

[Aidan Whitehall]

So long as they don't make it to the top of the ad, I (for one) wouldn't
mind.

CF-Tips (or whatever that thing with Dave Nor... Norv... Nor-something) has
them and they're a royal PITA.

Mind you, I think most of us are grateful for what you've done and
complaining about ads would seem a bit like biting the hand that feeds.



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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

RE: getting query results based on day (solution found)

[Dominic J. Doucet-Lorang]

I found a solution.  Instead of using CreateODBCDateTime (Now()) when I
create the record I use CreateODBCDate (Now().  Then use CreateODBCDate
(Now()) in my query page.

Thanks for the help everyone.

Dominic

-Original Message-
From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 2:14 PM
To: CF-Talk
Subject: getting query results based on day


I am trying to pull information from a database table based upon the date
and a couple of other items.  I have tried to use a query wher I comparied
the date column in the table with  now() but it gets no results. the query
looks like this:

select distinct forsikring.*,kunde.*
from forsikring, kunde
where  forsikring.refnr = #refnr2# AND forsikring.id = kunde.id and dos =
Now()

It will get results if I remove the dos = Now()
It needs to just get the records if the date is today also.


Dominic



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


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

RE: Preventing Simultaneous Logins

[Christopher Olive, CIO]

my suggestion would be an APPLICATION scope variable of those logged in at
the present time, along with their time of last activity.  this is updated
for each user on every page call to the secure area.  when someone tries to
log in, check the "currently logged in" structure (or data element of
choice.  i would use a struct with userid or username or something as the
key) for folks already logged in under that username.

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



-Original Message-
From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 7:37 PM
To: CF-Talk
Subject: Preventing Simultaneous Logins


Hi guys,

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

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

Thanks,

Peter Alexandrou
Technical Leader

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



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


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

usemap inside cfoutput

[Guy J. McDowell]

Hello CF_Folk

This is probably a simple one, but I am not seeing it

Problem:
Using code similar to that which follows, returns Invalid Parser
Construct error on " before #Map1












In order to solve that, I put the query tight around the query
dependent image tag, but that throws my table structures appearance
off, even with height and width defined, thus causing me to loose the
seamlessness of the image.

Help, if you please.

Guy J. McDowell
Webmaster, Ontario Federation of Anglers & Hunters
NEW DESIGN COMING NOVEMBER 1st at www.ofah.org



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

RE: usemap inside cfoutput

[Neil Clark]

you will need to escape the #  simply put another # before #map

thus 

##map

Neil

http://www.mcbdigital.com
--->




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

usemap and cfoutput

[Guy J. McDowell]

Hi,

Nevermind, I dropped all CF tags and the thing still isn't lining up

Yet it was fine yesterday.

Oh well.

Guy McDowell


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

CF mail and strange time problem (Sending into time warp)

[Mark W. Breneman]

Sorry to ask a question like this but,

I am having a problem with cfmail sending mail with a 10 hour error in the
header.  I am in the CST (-6 hours from GMT) zone and we are in daylight
savings time right now CDT (-5 hours from GMT).

If a cfmail tag sends a message at 3:19 PM the time stamp says 5:19AM.  If I
send a message with a mail client I have no problems.

Here is my mail header:
Received: from  (xxx)
by xxx (8.9.3/8.8.8) with ESMTP id IAA01105
for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:51:38 -0500 (CDT)
From: xxx
Received: from xxx (xxx)
by xxx (8.9.3+Sun/8.9.3/xxx) with ESMTP id IAA14454
for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:51:38 -0500 (CDT)
Received: from [xxx] by xxx (NTMail 5.00.0010/NY5114.00.7704f543) with ESMTP
id jogi for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:53:36 -0500
Date: Wed, 18 Oct 2000 08:49:33 +0500
Subject: 
To: [EMAIL PROTECTED]
Message-Id: 
Content-Type: text/plain
X-UIDL: @&)"!?H>"!EpE"!R@!#!

I would guess that it has something to do with the +5 on the tenth line.
(5hours + 5hours = 10hours)

Anyone know what is generating that line?  CFmail? Where does cfmail get its
time from?

I have checked my SMTP server all the time setting are correct in the
software and on the system clock.

Note: The cf server and the smtp server are the same box.


any guesses?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



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

Memory Leaks

[Robert Flesher]

I am running CF 4.5(not 4.5.1) with Oracle and am getting major memory leaks 
from Cold Fusion.  Does anyone have any ideas/suggestions on how to plug 
cold fusion's memory leakage?
Thanx,

Rob Flesher
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

querying olap cubes through cf with mdx

[Edward Peloke]

Hello,

Has anyone successfully used mdx to query an olap cube?  I am able to get to
the cube through coldfusion but can't get any output.  Any suggstions?

Thanks,
Eddie










 









The variable is  empty.






Results:



#cst#



Your mdx query is:


#smdx#











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

Re: CF mail and strange time problem (Sending into time warp)

[Vance_Duke]

I am having the same problem.  I too am CST, currently in CDT.

Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729



   

"Mark W.   

Breneman"To: CF-Talk <[EMAIL PROTECTED]>   

 Subject: CF mail and strange time problem 
(Sending into time warp)
   

10/18/00   

09:14 AM   

Please 

respond to 

cf-talk

   

   




Sorry to ask a question like this but,

I am having a problem with cfmail sending mail with a 10 hour error in the
header.  I am in the CST (-6 hours from GMT) zone and we are in daylight
savings time right now CDT (-5 hours from GMT).

If a cfmail tag sends a message at 3:19 PM the time stamp says 5:19AM.  If
I
send a message with a mail client I have no problems.

Here is my mail header:
Received: from  (xxx)
   by xxx (8.9.3/8.8.8) with ESMTP id IAA01105
   for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:51:38 -0500 (CDT)
From: xxx
Received: from xxx (xxx)
   by xxx (8.9.3+Sun/8.9.3/xxx) with ESMTP id IAA14454
   for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:51:38 -0500 (CDT)
Received: from [xxx] by xxx (NTMail 5.00.0010/NY5114.00.7704f543) with
ESMTP
id jogi for <[EMAIL PROTECTED]>; Wed, 18 Oct 2000 08:53:36 -0500
Date: Wed, 18 Oct 2000 08:49:33 +0500
Subject: 
To: [EMAIL PROTECTED]
Message-Id: 
Content-Type: text/plain
X-UIDL: @&)"!?H>"!EpE"!R@!#!

I would guess that it has something to do with the +5 on the tenth line.
(5hours + 5hours = 10hours)

Anyone know what is generating that line?  CFmail? Where does cfmail get
its
time from?

I have checked my SMTP server all the time setting are correct in the
software and on the system clock.

Note: The cf server and the smtp server are the same box.


any guesses?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770




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





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

RE: Memory Leaks

[Robert Everland]

Go up to 4.5.1 or try checking your queries. I get a memory leak if i call a
huge query in AS/400 and the data is just enormous.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Robert Flesher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:20 AM
To: CF-Talk
Subject: Memory Leaks


I am running CF 4.5(not 4.5.1) with Oracle and am getting major memory leaks

from Cold Fusion.  Does anyone have any ideas/suggestions on how to plug 
cold fusion's memory leakage?
Thanx,

Rob Flesher
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

Still can't download Studio beta

[Robert Everland]

I posted this a week ago that I couldn't download the beta for
studio. Is anyone having this problem still. I know people from Allaire
monitor the list, could someone email me off list as to why it won't
download.

Robert Everland III
Web Developer
Dixon Ticonderoga

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

RE: RE: Html email??

[joeug]

Thanks,
   I dont have a query in the CFMAIL but i build  multiple
database queries stored in varaibles that are included in the
body of the email and the groupcasesensitive shouldnt matter,
i have the type="html"
also set. I have cutomers using Outlook Express 5.0 and Messenger
4.7 and they still get junk. Is there anything else wrong?

Appretiate any help.

Thanks
Joe


--- Original Message ---
"Neil Clark" <[EMAIL PROTECTED]> Wrote on 
Wed, 18 Oct 2000 09:47:18 +0100
 -- 
this should do the trick



Neil

http://www.mcbdigital.com
--->




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



-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!


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

RE: Threading issue

[Hoffman, Joe (CIT)]

What version CF server, web server and OS?  Any add-ons?

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

-Original Message-
From: Dan Allison [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 3:19 PM
To: CF-Talk
Subject: Threading issue



I am having a problem with a thread being held open.  I have set performance
monitor so I can see all the threads.  Occasionally I have a thread that
goes to 100% and eventually eats up memory and causes slow performance.
Stopping and starting CF services seems to solve the problem. Looking
through the logs I see error messages "warning unresponsive thread count."
This goes from 1 to usually 10 and then our site locks up.  Anyone have any
thoughts on the cause?  It seems to be a coding error that we can't
track down or a memory leak.  Has anyone seen this before?

Thanks,
Dan

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

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

Spectra Question

[Deepak Agarwal]

I am currently using HTML Editor provided by Spectra. The problem I am
having is, when ever I create a link through the editor and view it's HTML
source, the link get's changed.

For example I have Hotmail(In the text body)  and linked it to
(http://www.hotmail.com) through the create Link Icon in the Editor. Now
when I view the HTML Source of this through the editor, the link gets
changed to http://mycurrentwebserver.www.hotmail.com

Does anyone have any ideas/suggestions how to fix the problem or is it a bug
in HTML Editor.

Thanx,

Deepak Agarwal
703.633.4257

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

Variables in Java and Javascript

[Gavin Myers]

Hey people,

New thing:
I need to check if a certing browser has java enabled, and javascript

can you set a variable in java or javascript and let it be read in cold
fusion?

this is what i'm thinking:




javacode
put 1 into java
/javacode

javascript code
put 1 into javascript
/javascript code


no javascript


no java


any ideas on how to do this? better then this one? And, if you can cross
variables through different peices of code, what is the syntax for writing
this in javascript, java? Can you have Java on a cfm page?

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

CF Installation questions with SP1

[Ryan]

Hello. We are going to setup some new CF servers in the next week
or two. Do I have to use our 4.5.1 CD, and then install the downloaded
SP1, or can I install a downloaded CF 4.5.1 that has SP1 in it, and
then somehow enter my CD key so its not an eval version?

RPS



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

novell user name

[Joseph Vincent]

This is a problem i have been trying to resolve for a while but have never 
posted to this list.  We are running an Intranet site in-house on an NT 
Server. All of our users are logged into Novell.  We want to increase our 
Intranet site security by figuring out some way for CF to capture the users 
Novell login name and then restricting certain page accesses based on that 
login name.  Has anyone done this before, or have any ideas about how I 
might go about 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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

ticker

[Joseph Vincent]

Does anyone have a recommendation for where I can get a javascript news 
ticker that either scrolls 3 separate lines at once horizontally or scrolls 
text vertically?
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: locking with IsDefined

[Zachary Bedell]

That's wrong alright...  Reads AND writes both need to be locked.  CF uses
advisory locking only, so unless you TELL CFAS that you're about to read a
particular scope, it has no way of knowing whether to allow or deny write
locks on said scope.  ALWAYS, ALWAYS, A-L-W-A-Y-S!!! lock all READS AND
WRITES to session, application, and server scopes.

The only exception to that is if you've set your 4.5.1+ server to do
automatic read locking.  ONLY THEN can you afford to NOT lock reads because
CFAS will do it automagically for you.

Best regards,
Zac Bedell

-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:47 PM
To: CF-Talk
Subject: RE: locking with IsDefined


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

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



> -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 5:45 PM
> To: CF-Talk
> Subject: locking with IsDefined
>
>
> When testing for the existence of a session variable such as:
>
> IsDefined("Session.Login")
>
> do you need to use a  around it?
>
> -
> Sebastian
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.



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

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

how to detect when the session variable is expire?

[Chen, Yung-Chih (CIT)]

Hi,
Does anyone know the way to detect when session variable is expire?

Some example code will be really helpful!

Thank you in advance!


YC



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

Re: Spectra Question

[Mary_Baotic]

There is a bug in the HTML editor in Spectra.

I am using eWebEditPro by Ektron as a replacement.

Mary


|+--->
||  "Deepak  |
||  Agarwal" |
|||
||   |
||  10/18/2000   |
||  10:54 AM |
||  Please   |
||  respond to   |
||  cf-talk  |
||   |
|+--->
  >|
  ||
  |   To: CF-Talk <[EMAIL PROTECTED]>  |
  |   cc: (bcc: Mary Baotic/na/Hyperion)   |
  |   Subject: Spectra Question|
  >|





I am currently using HTML Editor provided by Spectra. The problem I am
having is, when ever I create a link through the editor and view it's HTML
source, the link get's changed.

For example I have Hotmail(In the text body)  and linked it to
(http://www.hotmail.com) through the create Link Icon in the Editor. Now
when I view the HTML Source of this through the editor, the link gets
changed to http://mycurrentwebserver.www.hotmail.com

Does anyone have any ideas/suggestions how to fix the problem or is it a bug
in HTML Editor.

Thanx,

Deepak Agarwal
703.633.4257


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




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

SQL Query Question

[Tim Bahlke]

I have the following SP:

CREATE PROCEDURE [n_speaker_list] AS

SELECT DISTINCT s.f_name, s.l_name, s.pro_title, c.co_name, sm.subject, 
a.agenda_title, s.sp_file
FROM speakers s, company c, subject_matter sm, agenda a
WHERE a.time_slot = s.time_slot
AND s.subject_id = sm.subject_id
AND s.company_id = c.company_id
AND s.sp_file is not null
ORDER BY s.f_name, s.l_name

I want to pull all records where the s.f_name and s.l_name are distinct but not the 
rest of the string.

Can someone please enlighten me on how to do this?

Thanks,
Tim Bahlke



Tim Bahlke



Access your e-mail anywhere, at any time.
Get your FREE BellSouth Web Mail account today!
http://webmail.bellsouth.net


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

RE: Threading issue

[Dan Allison]

Joe,

I am using CF 4.5.1 SP1, NT 4.0 SP6a, and MDAC 2.6.

Thanks,
Dan

-Original Message-
From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:47 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Threading issue


What version CF server, web server and OS?  Any add-ons?

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

-Original Message-
From: Dan Allison [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 3:19 PM
To: CF-Talk
Subject: Threading issue



I am having a problem with a thread being held open.  I have set performance
monitor so I can see all the threads.  Occasionally I have a thread that
goes to 100% and eventually eats up memory and causes slow performance.
Stopping and starting CF services seems to solve the problem. Looking
through the logs I see error messages "warning unresponsive thread count."
This goes from 1 to usually 10 and then our site locks up.  Anyone have any
thoughts on the cause?  It seems to be a coding error that we can't
track down or a memory leak.  Has anyone seen this before?

Thanks,
Dan

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


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

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

RE: CF Installation questions with SP1

[Simon Horwith]

just put in your actual CD Key... should work.

~Simon

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:01 AM
To: CF-Talk
Subject: CF Installation questions with SP1


Hello. We are going to setup some new CF servers in the next week
or two. Do I have to use our 4.5.1 CD, and then install the downloaded
SP1, or can I install a downloaded CF 4.5.1 that has SP1 in it, and
then somehow enter my CD key so its not an eval version?

RPS




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

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

CFCase - Number in range of values

[Paul Sizemore]

Is there any way to do the following?  (I know case values must be
constants). Will I need to test for this possibility before it goes into the
CF switch? 


My Code


pbs


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

RE: CF mail and strange time problem (Sending into time warp)

[Mark W. Breneman]

Think I found the problem.  "Jim" mailed me off list.


"I found the post below from doing a search in the Allaire forums.

Jim"
 
Thanks Jim!



Date: September 25, 2000 02:33 PM
Author: Christine Lawson ([EMAIL PROTECTED])


Hi,
The incorrect time stamp is a known bug and has been resolved in 4.5.1 sp1,
you can get more information on this version here:

http://forums.allaire.com/devconf/Index.cfm?Message_ID=573752

Please respond by posting to the forum so everyone can benefit from the
discussion.

Thanks,
Christine Lawson
Technical Support Engineer
Knowledge Base: HTTP://Allaire.com/Support/KnowledgeBase
ColdFusion Support Forum: http://forums.allaire.com/devconf/



Mark W. Breneman
-Cold Fusion Developer 
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 

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

RE: Variables in Java and Javascript

[Patricia Lee]

The javascript would work, yes.

The java wouldn't work as you have it because you can only process one
server side language per application page.  Java and ColdFusion cannot be
called on the same page.

I do not know if or how you could tell that a broweser is java-enabled.  I'd
wait and see if Watts responds to this... one can always hope.

-Patti

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:07 AM
To: CF-Talk
Subject: Variables in Java and Javascript


Hey people,

New thing:
I need to check if a certing browser has java enabled, and javascript

can you set a variable in java or javascript and let it be read in cold
fusion?

this is what i'm thinking:




javacode
put 1 into java
/javacode

javascript code
put 1 into javascript
/javascript code


no javascript


no java


any ideas on how to do this? better then this one? And, if you can cross
variables through different peices of code, what is the syntax for writing
this in javascript, java? Can you have Java on a cfm page?


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

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

RE: CF Installation questions with SP1

[Dharmesh Goel]

You can directly install the SP1 and it will ask you for the serial number. 

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

 -Original Message-
From:   Ryan [mailto:[EMAIL PROTECTED]] 
Sent:   October 18, 2000 11:01 AM
To: CF-Talk
Subject:CF Installation questions with SP1

Hello. We are going to setup some new CF servers in the next week
or two. Do I have to use our 4.5.1 CD, and then install the downloaded
SP1, or can I install a downloaded CF 4.5.1 that has SP1 in it, and
then somehow enter my CD key so its not an eval version?

RPS




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

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

Allaire Documentation

[Won Lee]

If anyone from Allaire is on this list...

I suggest that you work on the content of your documentation included with
CF Studio 4.5.
The implementation is good and I like that it is highly serachable.  However
there are too many errors in your documentation.  This extends to all the
versions of Studio that I have used.  Even 1 should be too many errors.  

The documentation I'm specifically referring to is the code example in
CFTREE.



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

RE: Creating Excel Documents

[Nardi, Gaston]

Hi. Look into ColdFusion at  www.webtricks.com 
Selene uses a  to creates the Excel
file.

Good Luck.
Gastón



> -Mensaje original-
> De:   Dave Hannum [SMTP:[EMAIL PROTECTED]]
> Enviado el:   Miércoles 18 de Octubre de 2000 09:21
> Para: CF-Talk
> Asunto:   Re: Creating Excel Documents
> 
> Have you tried using QueryNew, QuerySetCell and QueryAddRow in conjunction
> with CFX_Excel?  I use it here with tremendous success on some very
> heavily
> used applications.  You need to have Excel on the server to use this, but
> it
> work great!  I creates the Excel file on the server, then using CFCONTENT
> you can download the file and delete it off the server to keep things
> tidy!
> 
> Dave
> 
> 
> =
> "What we need is a list of specific unknown problems we will encounter"
> 
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
> 
> 
> 
> - Original Message -
> From: "seth ward" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 18, 2000 6:59 AM
> Subject: Creating Excel Documents
> 
> 
> I am desperately trying to output the contents of a query into a new
> Excel document; I have just about managed to open Excel on the client's
> machine using cfobject and some cfscript but it seems that i just get
> errors when trying to follow the Microsoft Visual Basic instructions in
> Excel.
> 
> I can't seem to actually enter any data, save the worksheet or
> anything...
> 
> The code I can use successfully is below. The problem I get is if I then
> try to use
> newDoc.Range("A1").Value = 1;
> 
> to set the first cell in the worksheet to have a value of 1.
> 
> I get an invalid parser error, even though it is the exact syntax copied
> from the example given on the range property.
> 
> HELP, Please! Is there an easier way???
> 
> 
> code begins
> ---
> 
> 
> 
> 
>ACTION="CONNECT"
> CLASS="Excel.Application"
> NAME="objExcel"
> TYPE="COM">
>   
> 
>  ACTION="CREATE"
> CLASS="Excel.Application"
> NAME="objExcel"
> TYPE="COM">
>   
> 
> 
> 
> 
> /* This will open Excel if running locally */
> objExcel.Visible = true;
> 
> /* This returns the 'Documents' collection the Excel Object */
> objBook = objExcel.Workbooks;
> 
> /* Create a new document */
> newDoc = objBook.add();
> 
> 
> 
> 
> 
> --
> code ends
> --
> 
> seth ward
> 
> 
> This message has been checked for all known viruses, by Star Internet,
> delivered through the MessageLabs Virus Control Centre.
> For further information visit:
> http://www.star.net.uk/stats.asp
> 
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

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

RE: Threading issue

[Hoffman, Joe (CIT)]

CF 4.5.1 SP1 but with WSP 2.4.9 and Win2k Pro.  Do you have any 
SQL code like?

Employees.FirstName+' - '+Employees.LastName AS FULLNAME

This used to work for me ... now all it does is throttle the 
CPU and hangs CF Server till I stop & start the service.  I 
rewrote the page and problems went away.

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

-Original Message-
From: Dan Allison [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:16 AM
To: '[EMAIL PROTECTED]'
Cc: Hoffman, Joe (CIT)
Subject: RE: Threading issue


Joe,

I am using CF 4.5.1 SP1, NT 4.0 SP6a, and MDAC 2.6.

Thanks,
Dan

-Original Message-
From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:47 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Threading issue


What version CF server, web server and OS?  Any add-ons?

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

-Original Message-
From: Dan Allison [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 3:19 PM
To: CF-Talk
Subject: Threading issue



I am having a problem with a thread being held open.  I have set performance
monitor so I can see all the threads.  Occasionally I have a thread that
goes to 100% and eventually eats up memory and causes slow performance.
Stopping and starting CF services seems to solve the problem. Looking
through the logs I see error messages "warning unresponsive thread count."
This goes from 1 to usually 10 and then our site locks up.  Anyone have any
thoughts on the cause?  It seems to be a coding error that we can't
track down or a memory leak.  Has anyone seen this before?

Thanks,
Dan

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


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

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

RE: how to detect when the session variable is expire?

[Simon Horwith]

Go to www.figleaf.com and then click on the link to CFUGs.  Download the
examples and slides for July (I think).  Steve Drucker (our CEO) gave an
excellent presentation about how to pop up javascript windows warning users
they are about to be logged off (i.e. expire), and whether or not they want
to remain logged on.  Very cool stuff :)

~Simon

 

-Original Message-
From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:08 AM
To: CF-Talk
Subject: how to detect when the session variable is expire?


Hi,
Does anyone know the way to detect when session variable is expire?

Some example code will be really helpful!

Thank you in advance!


YC




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

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

RE: ticker

[Doyle, Mike]

Vincent,

Try: http://javascript.internet.com/scrolls/

Good to see the posting is working ;-)

Mike

-Original Message-
From: Joseph Vincent [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:04 AM
To: CF-Talk
Subject: ticker


Does anyone have a recommendation for where I can get a javascript news 
ticker that either scrolls 3 separate lines at once horizontally or scrolls 
text vertically?
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

Re: Awards

[Michael Dinowitz]

I second that nomination. Despite the obvious bias here, Judith does a LOT
in the background of the community. She connects a lot of people when
needed, edits Fusion Authority (we're behind due to the Fusebox book),
publishes CF books, helps keep me on track and we're just starting a CF
certification book. All this while being a mother of 2 children and 7 months
pregnant to boot. Luckily, we just got her an assistant.


> I nominate Judith Dinowitz
>
> she keeps us all focused with a a gentle nudge when needed
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Saving File and Directing to Display a Specific CF Template !

[Manasa Anand]

Hi,

I have a.cfm which is something like :



#SomeData#




My a_exp.cfm file is as follows:

DataHeader
#DisplayData#


My Question : When I click the "submit" button on my
form page, it brings up the excel spread sheet. When I
save it, I can get to a.cfm by browser "back" button.
Instead, how can I go to a different CF template; say
c.cfm.

Please Advise ASAP.

Thanks,
~Manasa.


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

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

Saving into Multiple Files !

[Manasa Anand]

Hi,

I have a Multiple Select for Reports in my x.cfm file.
(Note: Each Report when selected should have a
specific related query run, the results of which
should be saved into a file.)
When I select X number of reports and click on
'submit' button, it should perform two functions;
- One, it should save the results of X number of
queries in X number of files (i.e. each query results
saved into a separate file.)
- Also, it should accept some default filenames, and
should not prompt for the filenames while saving the
text/excel files.

Please let me know if the above two functionalities
are feasible. If so how?

Thanks,
~Manasa.

__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

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

RE: Variables in Java and Javascript

[Evan Lavidor]

Don't know about Java, but this can't be done with JavaScript.  CF is server
side, and JavaScript is client side.  By the time the JavaScript executes,
CF has completed all of its execution.  There are tags that check to see if
JavaScript is enabled, check out CF_aBrowserInfo.  Haven't used it yet, but
just saw it in the tag gallery yesterday.

http://devex.allaire.com/developer/gallery/info.cfm?ID=5FE4539E-504A-11D4-AA
A000508B94F380&method=Full

Evan

> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 18, 2000 11:07 AM
> To: CF-Talk
> Subject: Variables in Java and Javascript
>
>
> Hey people,
>
> New thing:
> I need to check if a certing browser has java enabled, and javascript
>
> can you set a variable in java or javascript and let it be read in cold
> fusion?
>
> this is what i'm thinking:
>
> 
> 
>
> javacode
> put 1 into java
> /javacode
>
> javascript code
> put 1 into javascript
> /javascript code
>
> 
> no javascript
> 
> 
> no java
> 
>
> any ideas on how to do this? better then this one? And, if you can cross
> variables through different peices of code, what is the syntax for writing
> this in javascript, java? Can you have Java on a cfm page?
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

RE: Preventing Simultaneous Logins

[nb]

why not keep a application.object to store current user names/id's and the
time for the last page request... write a short script in application.cfm
that will ignore/purge inactive users, say after 30 minutes.  Simultaneous
logins will be avoided, and if users forget to log out before closing the
browser window, they only have to wait a half hour to get back in... if you
wanted to get really fancy, put a javascript in your pages that monitors
window.close and opens a logout.cfm script in a new window that closes
itself...

credit is due on the application idea - it's not my own - several tutorial
scripts exist that will let you do this.  I can't throw you any URLs but
they shouldn't be too hard to find...

neil

-Original Message-
From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 1:56 AM
To: CF-Talk
Subject: Re: Preventing Simultaneous Logins


I can think of many similar solutions but they are all useless because most
of the time users simply close their browsers or their sessions expire.

Surely someone out there has tackled this problem successfully?

- Original Message -
From: "Pete Freitag" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 2:15 PM
Subject: RE: Preventing Simultaneous Logins


> Keep a log of when people login, and when they log out (could get very
> large, but you could purge it daily).  Then when someone logs in do the
> following...
>
> SELECT username FROM audit_table
> WHERE
> username = '#form.username#' AND
> timestamp > #DateAdd("n", -30, Now())#
> ORDER BY action
>
> That will see if  the user has been around in the last half hour
>
> Action could be a boolean field 1 being login 0 being logout
> 
> 
> already logged in 
> 
> 
> login...
>
> The problem with this entire process, is that there is no destructor
called
> when a session disappears, or times out.
>
> __
> Pete Freitag ([EMAIL PROTECTED])
> CFDEV.COM / NETDesign Inc.
> ColdFusion Developer Resources
> http://www.cfdev.com/
>
> -Original Message-
> From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 7:37 PM
> To: CF-Talk
> Subject: Preventing Simultaneous Logins
>
>
> Hi guys,
>
> I'm new to the mailing list and have a quick question for y'all.
>
> What is the best way to prevent a userID being logged in twice i.e.
someone
> logs in with "login1" and then another user logs in with the same ID.
>
> Thanks,
>
> Peter Alexandrou
> Technical Leader
>
> tapestry communications : www.tapestry.net.au
> phone : 0411 445 111
> e-mail : [EMAIL PROTECTED]
>
> --
--
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



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


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


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

RE: CFCase - Number in range of values

[Hayes, David]

You can use .

-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:10 AM
To: CF-Talk
Subject: CFCase - Number in range of values


Is there any way to do the following?  (I know case values must be
constants). Will I need to test for this possibility before it goes into the
CF switch? 


My Code


pbs



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

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

RE: CF Installation questions with SP1

[Ryan]

At 11:19 10/18/00 -0400, you wrote:
>just put in your actual CD Key... should work.
>
>~Simon

I couldn't even remember if it prompted me for a key, I thought
it might only be able to be used as an eval. Thanks,

Ryan


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

RE: Spectra Question

[Raymond K. Camden]

This is a known issue. I _believe_ Rich Ragan issued a patch for this in the
Developer's Exchange (essentially it 'scrubs' the input).

===
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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


> -Original Message-
> From: Deepak Agarwal [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 18, 2000 10:54 AM
> To: CF-Talk
> Subject: Spectra Question
>
>
> I am currently using HTML Editor provided by Spectra. The problem I am
> having is, when ever I create a link through the editor and view it's HTML
> source, the link get's changed.
>
> For example I have Hotmail(In the text body)  and linked it to
> (http://www.hotmail.com) through the create Link Icon in the Editor. Now
> when I view the HTML Source of this through the editor, the link gets
> changed to http://mycurrentwebserver.www.hotmail.com
>
> Does anyone have any ideas/suggestions how to fix the problem or
> is it a bug
> in HTML Editor.
>
> Thanx,
>
> Deepak Agarwal
> 703.633.4257
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

RE: Variables in Java and Javascript

[Aaron Johnson]

browserhawk can catch enabled/disabled Java.

http://www.browserhawk.com/products/bhawk/features.asp

AJ

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:33 AM
To: CF-Talk
Subject: RE: Variables in Java and Javascript


The javascript would work, yes.

The java wouldn't work as you have it because you can only process one
server side language per application page.  Java and ColdFusion cannot be
called on the same page.

I do not know if or how you could tell that a broweser is java-enabled.  I'd
wait and see if Watts responds to this... one can always hope.

-Patti

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:07 AM
To: CF-Talk
Subject: Variables in Java and Javascript


Hey people,

New thing:
I need to check if a certing browser has java enabled, and javascript

can you set a variable in java or javascript and let it be read in cold
fusion?

this is what i'm thinking:




javacode
put 1 into java
/javacode

javascript code
put 1 into javascript
/javascript code


no javascript


no java


any ideas on how to do this? better then this one? And, if you can cross
variables through different peices of code, what is the syntax for writing
this in javascript, java? Can you have Java on a cfm page?


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


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


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

RE: Variables in Java and Javascript

[Gavin Myers]

What i've been looking into is cfwddx, i think its my only hope:





  #javascript_final_verify#

 


#javascript_final_verify#

the problem is I cant carry this number from js back to cf. Any suggestions
on this? Or is it because js is a broswer lang, you cant go back to running
cf again?

By using cfwddx, can i then put java and asp on the same page?


-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:33 AM
To: CF-Talk
Subject: RE: Variables in Java and Javascript


The javascript would work, yes.

The java wouldn't work as you have it because you can only process one
server side language per application page.  Java and ColdFusion cannot be
called on the same page.

I do not know if or how you could tell that a broweser is java-enabled.  I'd
wait and see if Watts responds to this... one can always hope.

-Patti

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:07 AM
To: CF-Talk
Subject: Variables in Java and Javascript


Hey people,

New thing:
I need to check if a certing browser has java enabled, and javascript

can you set a variable in java or javascript and let it be read in cold
fusion?

this is what i'm thinking:




javacode
put 1 into java
/javacode

javascript code
put 1 into javascript
/javascript code


no javascript


no java


any ideas on how to do this? better then this one? And, if you can cross
variables through different peices of code, what is the syntax for writing
this in javascript, java? Can you have Java on a cfm page?


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


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

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

Re: [Re: Preventing Simultaneous Logins]

[Al Musella, DPM]

To kick out the first user:
When someone logs in successfully,  create a UUID that is stored in the 
database and pass along with the user ID. Then in application.cfm, I check 
the that the UUID and user ID match in the database. IF they don't they get 
kicked out to the login page.

IF someone else logs in with the same user ID, that would store a new UUID 
in the database, which will work for this second user, but when the first 
user goes to a new page, the UUID won't match what is in the database, and 
he will be kicked out.
Al Musella
Wolrd Wide Websites
a1webs.com


At 02:47 AM 10/18/2000 -0500, you wrote:

>when a user is logging in with user name "Login1" and another user is trying
>to log in with the same user name, what do u want to do?  kick out the first
>user or stop the second user?


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

RE: CF Installation questions with SP1

[Ryan]

At 11:29 10/18/00 -0400, you wrote:
>You can directly install the SP1 and it will ask you for the serial number. 

By 'directly install' you mean I can just install the service pack,
without having cold fusion installed? And then it will ask me for
my serial number, and when I'm done I will have CF4.5.1 SP1 installed?

RPS


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

RE: Storing passwords in database as one way hash -The Solution

[Steve Bernard]

Hehe, well, wouldn't it be nice if security tools were perfect, everyone was
completely ethical, and there weren't any unknown vulnerabilities. In that
case, why have passwords? Let me take your response and put it in the
context of credit card numbers. "Why strongly encrypt credit card numbers?
People 'peeking' in your DB should never be a problem if it is set up
correctly with security et al." It seems a little more important when
put into that context, huh? You wouldn't hash credit card numbers, you want
to be able to use the information again, but storing the encrypted string
and the key together isn't a great idea either.

Steve


-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 4:44 AM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash -The Solution


Okay, hash-ing the password seems to be an overkill - why not simply
generate a random key which you can use with encrypt(form.password, key)
this value can then be placed in the db along with the key...  when it comes
to it, simply decrypt the form.password with the given key and you're away.
If they don't match - see ya, if they do - cool. ;-)

People 'peeking' in your DB should never be a problem if it is set up
correctly with security et al.

Neil

http://www.mcbdigital.com
--->





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


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

I know we have gone over this a million times.

[Nick Call]

I am populating a list that will eventually be written to a text file.  I
want to put a carriage return after each entry.  I cannot remember the
syntax.  Can someone kindly email that to me.

Thanks in advance.

Nick



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

Re: Awards

[Judith Dinowitz]

Thank you for the nomination! I'm honored.  (Thanks, Michael, for the plug.
: ) )

I'd like to second the nomination for Michael Smith though (Eron, you beat
me to it) because I think he does do a heck of a lot for the community. And,
despite the obvious bias, I'm going to second the nomination for Michael
Dinowitz. He gives of his heart and soul dealing with House of Fusion and
the talk lists, and I see it day in and day out.

There are so many other folks I could nominate: Cameron Childress, Adam
Phillip Churvis, Raymond Camden ... Gosh, don't you guys ever sleep? : )

Judith
> I second that nomination. Despite the obvious bias here, Judith does a LOT
> in the background of the community. She connects a lot of people when
> needed, edits Fusion Authority (we're behind due to the Fusebox book),
> publishes CF books, helps keep me on track and we're just starting a CF
> certification book. All this while being a mother of 2 children and 7
months
> pregnant to boot. Luckily, we just got her an assistant.
>
>
> > I nominate Judith Dinowitz
> >
> > she keeps us all focused with a a gentle nudge when needed
>
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
>
>


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

Voting Online!

[Adam Phillip Churvis]

Dearest Fusion People,

I have implemented an online voting mechanism for the  vote on
http://www.commerceblocks.com.  Go there and cast your votes, and I will
announce the three top winners at DevCon and also on the CF_TALK list.

Cheers!

Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

Publishers of the CommerceBlocks line of 
modular ColdFusion development tools 

Website: http://www.commerceblocks.com   
E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866

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

(no subject)

[KJis18]

I am looking for a Cold Fusion hosting company that would offer me this :

http://www.myname.com
20 megs space
1 ODBC
CF of course
3 - 5 email boxes
SSL

Does  anyone know of a cheap place to do this???

thanks

kev

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

SOT: Allaire conference

[Jennifer]

I know this is a long shot, but I am trying to go to the dev conference in 
DC and I'm having a travelling budget issue. Is there anyone who is trying 
to unload airfare or hotel rooms that they can't use or are there and 
females with a room needing a roommate?

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

Data Missing from Post operation

[Judith Taylor]

We've all seen it, we pretty much know how and why we get this message...is 
there any way around it?

TIA,
Judi

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

Freelance ColdFusion Developer

This year will go down in history. For the first time, a civilized nation 
has full gun registration. Our streets will be safer, our police more 
efficient, and the world will follow our lead into the future.
--- Adolf Hitler, 1935


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

RE: Variables in Java and Javascript

[Jason Powers]

You can't put CF and ASP on the same page, unfortunately.  In CF, you can do
a detection for Java/JS as shown below, and redirect the user accordingly.
As long as the java is an applet loaded client side, you're fine, you can
just call it as you normally would.  In order to get information, though,
from the java applet or the wddx recordset to the CF Server, you'll need to
do an HTTP request, either appending it to the URL querystring(HTTP GET), or
using either a form on the page(in the case of javascript), or methods in
Java(HTTP POST).  With Javascript, you'll want to reserialize your recordset
and drop it in a hidden form field before submitting. 




















Point the browser to the scriptless site. 



Use java client side to tell the browser to call this same page
href='thispage.cfm?java=1';



location.href="thispage.cfm?js=1";


That way, you get 3 blinky reloads and you have all the info you need to
move the user to the correct portion/format of your site.  
-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 12:02 PM
To: CF-Talk
Subject: RE: Variables in Java and Javascript


Don't know about Java, but this can't be done with JavaScript.  CF is server
side, and JavaScript is client side.  By the time the JavaScript executes,
CF has completed all of its execution.  There are tags that check to see if
JavaScript is enabled, check out CF_aBrowserInfo.  Haven't used it yet, but
just saw it in the tag gallery yesterday.

http://devex.allaire.com/developer/gallery/info.cfm?ID=5FE4539E-504A-11D4-AA
A000508B94F380&method=Full

Evan

> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 18, 2000 11:07 AM
> To: CF-Talk
> Subject: Variables in Java and Javascript
>
>
> Hey people,
>
> New thing:
> I need to check if a certing browser has java enabled, and javascript
>
> can you set a variable in java or javascript and let it be read in cold
> fusion?
>
> this is what i'm thinking:
>
> 
> 
>
> javacode
> put 1 into java
> /javacode
>
> javascript code
> put 1 into javascript
> /javascript code
>
> 
> no javascript
> 
> 
> no java
> 
>
> any ideas on how to do this? better then this one? And, if you can cross
> variables through different peices of code, what is the syntax for writing
> this in javascript, java? Can you have Java on a cfm page?
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]



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

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