RE: Note passing system?

[Javier Woodhouse]

I'd like to add to that... I also have no problem comming up with the code i
need, but code that is available publicaly is likely to have undergone
serveral bug fixes, performance enhancements and it might even be better
then what i could come up with. Code reuse has it's benefits 

Regards,
Javier

> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 4:37 PM
> To: CF-Talk
> Subject: Re: Note passing system?
> 
> 
> :o)
> 
> Hi Peter. I certainly understand where you're coming from. 
> After 3 years of
> doing some solid CF work, I'm very capable of building most 
> of the stuff
> that I need. I'm just an advocate of code reuse. If there's 
> something out
> there that helps me reduce my coding time, I'd like to take 
> advantage of it.
> I really hate reinventing the wheel.
> 
> Thanks for the feedback...
> 
> Rey...
> Certified Allaire Instructor
> Member of Team Allaire
> 
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> 
> 
> - Original Message -
> From: "Peter Tilbrook" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 17, 2001 1:59 AM
> Subject: RE: Note passing system?
> 
> 
> > As a side note - if you have an idea for your application - 
> do it! Do not
> > expect someone else to have already written the code for 
> you. CF makes
> > coding easy. If you are worried about the code have trusted 
> people try and
> > break it. Spend at least 3 weeks with beta testers on 
> trusted code. You
> > would be amazed at how the feedback either picks up 
> problems or points
> out,
> > even unobtrusively, better ways to accomplish a task.
> >
> > -Original Message-
> > From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 17 April 2001 15:33
> > To: CF-Talk
> > Subject: RE: Note passing system?
> >
> >
> > I implemented the same thing for the new Friends Plus site. 
> The beauty of
> > the system is that nobpdys email address is released.
> >
> > We could be draconian and introduce full auditing but it 
> has not been
> > necessary yet. The user remain anonymous and their email 
> address is never
> > released unless they give it out.
> >
> > -Original Message-
> > From: Rey Bango [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 17 April 2001 14:57
> > To: CF-Talk
> > Subject: Re: Note passing system?
> >
> >
> > Not really, Paul. Its more like an internal messaging 
> system. One where I
> > can write a message to another user or perhaps a group of 
> users and have
> > them correspnd back. Again, its not a true email system but 
> one that would
> > allow me to be able to communicate within the scope of my 
> own application.
> >
> > Rey...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> > - Original Message -
> > From: "Paul Begovich" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 16, 2001 7:35 PM
> > Subject: Re: Note passing system?
> >
> >
> > > Sounds like you want a project management tool.
> > >
> > > We have an internal system here we use to parse out work. 
>  Basically the
> > > client/project manager submits an item to a form and it 
> appears on the
> > > necessary persons desktop based on who they select.  They 
> see the item,
> do
> > > the work, mark their time, and reply via the form.  It's 
> a great project
> > > management tool and it keeps track of correspondence.
> > >
> > > Building a system like your describing isn't too 
> difficult, it's just
> time
> > > consuming.  We have looked into outside utilities to do 
> this, but we've
> > > found them lacking.  As a development shop we have found 
> that when we
> need
> > > some additional functionality we build it on.  The 
> current system we
> have
> > > now has grown out of several developers efforts in the 
> past two years to
> > > incompass project managment, billing, contacts, work 
> requests, logging,
> > and
> > > a host of other things.
> > >
> > > A third party too may save you time in the short run, but 
> in the long
> run,
> > > it'll probably lacks the additional functionality you 
> want.  I recommend
> > > buiding your own system, keeping in mind you want to be 
> able to add
> > > additionally functionality in the future.
> > >
> > > - Paul
> > >
> > >
> > > - Original Message -
> > > From: "Rey Bango" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Monday, April 16, 2001 1:07 PM
> > > Subject: Note passing system?
> > >
> > >
> > > > Anyone know of a good CF-based note/messaging system? 
> I'm not talking
> > > about
> > > > an email server but more of a db driven messaging 
> software that will
> > allow
> > > > me to post a message to a specific suer. When that user 
> comes in, they
> > can
> > > > check for their own messages and reply accordingly. 
> Again, its not an
> > > email
> > > > system per

Re: Note passing system?

[Rey Bango]

:o)

Hi Peter. I certainly understand where you're coming from. After 3 years of
doing some solid CF work, I'm very capable of building most of the stuff
that I need. I'm just an advocate of code reuse. If there's something out
there that helps me reduce my coding time, I'd like to take advantage of it.
I really hate reinventing the wheel.

Thanks for the feedback...

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 1:59 AM
Subject: RE: Note passing system?


> As a side note - if you have an idea for your application - do it! Do not
> expect someone else to have already written the code for you. CF makes
> coding easy. If you are worried about the code have trusted people try and
> break it. Spend at least 3 weeks with beta testers on trusted code. You
> would be amazed at how the feedback either picks up problems or points
out,
> even unobtrusively, better ways to accomplish a task.
>
> -Original Message-
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 17 April 2001 15:33
> To: CF-Talk
> Subject: RE: Note passing system?
>
>
> I implemented the same thing for the new Friends Plus site. The beauty of
> the system is that nobpdys email address is released.
>
> We could be draconian and introduce full auditing but it has not been
> necessary yet. The user remain anonymous and their email address is never
> released unless they give it out.
>
> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 17 April 2001 14:57
> To: CF-Talk
> Subject: Re: Note passing system?
>
>
> Not really, Paul. Its more like an internal messaging system. One where I
> can write a message to another user or perhaps a group of users and have
> them correspnd back. Again, its not a true email system but one that would
> allow me to be able to communicate within the scope of my own application.
>
> Rey...
> Certified Allaire Instructor
> Member of Team Allaire
>
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
>
> - Original Message -
> From: "Paul Begovich" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 7:35 PM
> Subject: Re: Note passing system?
>
>
> > Sounds like you want a project management tool.
> >
> > We have an internal system here we use to parse out work.  Basically the
> > client/project manager submits an item to a form and it appears on the
> > necessary persons desktop based on who they select.  They see the item,
do
> > the work, mark their time, and reply via the form.  It's a great project
> > management tool and it keeps track of correspondence.
> >
> > Building a system like your describing isn't too difficult, it's just
time
> > consuming.  We have looked into outside utilities to do this, but we've
> > found them lacking.  As a development shop we have found that when we
need
> > some additional functionality we build it on.  The current system we
have
> > now has grown out of several developers efforts in the past two years to
> > incompass project managment, billing, contacts, work requests, logging,
> and
> > a host of other things.
> >
> > A third party too may save you time in the short run, but in the long
run,
> > it'll probably lacks the additional functionality you want.  I recommend
> > buiding your own system, keeping in mind you want to be able to add
> > additionally functionality in the future.
> >
> > - Paul
> >
> >
> > - Original Message -
> > From: "Rey Bango" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 16, 2001 1:07 PM
> > Subject: Note passing system?
> >
> >
> > > Anyone know of a good CF-based note/messaging system? I'm not talking
> > about
> > > an email server but more of a db driven messaging software that will
> allow
> > > me to post a message to a specific suer. When that user comes in, they
> can
> > > check for their own messages and reply accordingly. Again, its not an
> > email
> > > system per se.
> > >
> > > Thanks,
> > >
> > > Rey Bango...
> > > Certified Allaire Instructor
> > > Member of Team Allaire
> > >
> > > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Note passing system?

[Peter Tilbrook]

Check out http://friendsplus.dns2go.com - I may need to set you up a "test
account" to see it in action as we are finalising testing. At the same time
I recommend using the DNS2GO service - or at least trying it!

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 April 2001 15:33
To: CF-Talk
Subject: RE: Note passing system?


I implemented the same thing for the new Friends Plus site. The beauty of
the system is that nobpdys email address is released.

We could be draconian and introduce full auditing but it has not been
necessary yet. The user remain anonymous and their email address is never
released unless they give it out.

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 April 2001 14:57
To: CF-Talk
Subject: Re: Note passing system?


Not really, Paul. Its more like an internal messaging system. One where I
can write a message to another user or perhaps a group of users and have
them correspnd back. Again, its not a true email system but one that would
allow me to be able to communicate within the scope of my own application.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."



- Original Message -
From: "Paul Begovich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:35 PM
Subject: Re: Note passing system?


> Sounds like you want a project management tool.
>
> We have an internal system here we use to parse out work.  Basically the
> client/project manager submits an item to a form and it appears on the
> necessary persons desktop based on who they select.  They see the item, do
> the work, mark their time, and reply via the form.  It's a great project
> management tool and it keeps track of correspondence.
>
> Building a system like your describing isn't too difficult, it's just time
> consuming.  We have looked into outside utilities to do this, but we've
> found them lacking.  As a development shop we have found that when we need
> some additional functionality we build it on.  The current system we have
> now has grown out of several developers efforts in the past two years to
> incompass project managment, billing, contacts, work requests, logging,
and
> a host of other things.
>
> A third party too may save you time in the short run, but in the long run,
> it'll probably lacks the additional functionality you want.  I recommend
> buiding your own system, keeping in mind you want to be able to add
> additionally functionality in the future.
>
> - Paul
>
>
> - Original Message -
> From: "Rey Bango" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 1:07 PM
> Subject: Note passing system?
>
>
> > Anyone know of a good CF-based note/messaging system? I'm not talking
> about
> > an email server but more of a db driven messaging software that will
allow
> > me to post a message to a specific suer. When that user comes in, they
can
> > check for their own messages and reply accordingly. Again, its not an
> email
> > system per se.
> >
> > Thanks,
> >
> > Rey Bango...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Dynamically Displayed Content Weekly?

[mahmad]

ok


   

"Christopher   

Olive, CIO"  To: CF-Talk <[EMAIL PROTECTED]>   

   Subject: RE: Dynamically Displayed 
Content Weekly?
   

04/17/01   

05:24 AM   

Please 

respond to 

cf-talk

   

   





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

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



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


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

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

hth,

DK

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


> Can anyone tell me where I could find out more regarding dynamically
> displaying text on a cfm page weekly?
>
> I know this can be done in ASP but wasn't sure if it was possible in cf.
>
> TIA,
> Dayv
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Note passing system?

[Peter Tilbrook]

As a side note - if you have an idea for your application - do it! Do not
expect someone else to have already written the code for you. CF makes
coding easy. If you are worried about the code have trusted people try and
break it. Spend at least 3 weeks with beta testers on trusted code. You
would be amazed at how the feedback either picks up problems or points out,
even unobtrusively, better ways to accomplish a task.

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 April 2001 15:33
To: CF-Talk
Subject: RE: Note passing system?


I implemented the same thing for the new Friends Plus site. The beauty of
the system is that nobpdys email address is released.

We could be draconian and introduce full auditing but it has not been
necessary yet. The user remain anonymous and their email address is never
released unless they give it out.

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 April 2001 14:57
To: CF-Talk
Subject: Re: Note passing system?


Not really, Paul. Its more like an internal messaging system. One where I
can write a message to another user or perhaps a group of users and have
them correspnd back. Again, its not a true email system but one that would
allow me to be able to communicate within the scope of my own application.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."



- Original Message -
From: "Paul Begovich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:35 PM
Subject: Re: Note passing system?


> Sounds like you want a project management tool.
>
> We have an internal system here we use to parse out work.  Basically the
> client/project manager submits an item to a form and it appears on the
> necessary persons desktop based on who they select.  They see the item, do
> the work, mark their time, and reply via the form.  It's a great project
> management tool and it keeps track of correspondence.
>
> Building a system like your describing isn't too difficult, it's just time
> consuming.  We have looked into outside utilities to do this, but we've
> found them lacking.  As a development shop we have found that when we need
> some additional functionality we build it on.  The current system we have
> now has grown out of several developers efforts in the past two years to
> incompass project managment, billing, contacts, work requests, logging,
and
> a host of other things.
>
> A third party too may save you time in the short run, but in the long run,
> it'll probably lacks the additional functionality you want.  I recommend
> buiding your own system, keeping in mind you want to be able to add
> additionally functionality in the future.
>
> - Paul
>
>
> - Original Message -
> From: "Rey Bango" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 1:07 PM
> Subject: Note passing system?
>
>
> > Anyone know of a good CF-based note/messaging system? I'm not talking
> about
> > an email server but more of a db driven messaging software that will
allow
> > me to post a message to a specific suer. When that user comes in, they
can
> > check for their own messages and reply accordingly. Again, its not an
> email
> > system per se.
> >
> > Thanks,
> >
> > Rey Bango...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Last row inserted

[Kevin Mansel]

SELECT MAX(Row) AS MaxRecord
WHERE MaxRecord = @@IDENTITY

i believe that is the correct syntax

beat me over the head if i'm wrong  :P

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

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

Re: Last row inserted

[Howie Hamlin]

Yep that's it.  However, you should do a transaction so that another record
isn't added while you're fetching the current highest ID.

Regards,

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


- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 1:34 AM
Subject: Last row inserted


> I know this has been asked a million times but what is the best way to
pull
> the id of the row last inserted.  Isnt select (column name)MAX as
> (whatever)?
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Note passing system?

[Peter Tilbrook]

I implemented the same thing for the new Friends Plus site. The beauty of
the system is that nobpdys email address is released.

We could be draconian and introduce full auditing but it has not been
necessary yet. The user remain anonymous and their email address is never
released unless they give it out.

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 April 2001 14:57
To: CF-Talk
Subject: Re: Note passing system?


Not really, Paul. Its more like an internal messaging system. One where I
can write a message to another user or perhaps a group of users and have
them correspnd back. Again, its not a true email system but one that would
allow me to be able to communicate within the scope of my own application.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."



- Original Message -
From: "Paul Begovich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:35 PM
Subject: Re: Note passing system?


> Sounds like you want a project management tool.
>
> We have an internal system here we use to parse out work.  Basically the
> client/project manager submits an item to a form and it appears on the
> necessary persons desktop based on who they select.  They see the item, do
> the work, mark their time, and reply via the form.  It's a great project
> management tool and it keeps track of correspondence.
>
> Building a system like your describing isn't too difficult, it's just time
> consuming.  We have looked into outside utilities to do this, but we've
> found them lacking.  As a development shop we have found that when we need
> some additional functionality we build it on.  The current system we have
> now has grown out of several developers efforts in the past two years to
> incompass project managment, billing, contacts, work requests, logging,
and
> a host of other things.
>
> A third party too may save you time in the short run, but in the long run,
> it'll probably lacks the additional functionality you want.  I recommend
> buiding your own system, keeping in mind you want to be able to add
> additionally functionality in the future.
>
> - Paul
>
>
> - Original Message -
> From: "Rey Bango" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 1:07 PM
> Subject: Note passing system?
>
>
> > Anyone know of a good CF-based note/messaging system? I'm not talking
> about
> > an email server but more of a db driven messaging software that will
allow
> > me to post a message to a specific suer. When that user comes in, they
can
> > check for their own messages and reply accordingly. Again, its not an
> email
> > system per se.
> >
> > Thanks,
> >
> > Rey Bango...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Last row inserted

[Joshua Tipton]

I know this has been asked a million times but what is the best way to pull
the id of the row last inserted.  Isnt select (column name)MAX as
(whatever)?


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

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

Re: Note passing system?

[Rey Bango]

What do you mean by a socket program?

Rey...

- Original Message -
From: "Steven A. del Sol" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:18 PM
Subject: Re: Note passing system?


> I have a socket I wrote for my organization.  Real crude but it works.
> Interested?
>
>
> Steve
>
>
> >Sounds like you want a project management tool.
> >
> >We have an internal system here we use to parse out work.  Basically the
> >client/project manager submits an item to a form and it appears on the
> >necessary persons desktop based on who they select.  They see the item,
do
> >the work, mark their time, and reply via the form.  It's a great project
> >management tool and it keeps track of correspondence.
> >
> >Building a system like your describing isn't too difficult, it's just
time
> >consuming.  We have looked into outside utilities to do this, but we've
> >found them lacking.  As a development shop we have found that when we
need
> >some additional functionality we build it on.  The current system we have
> >now has grown out of several developers efforts in the past two years to
> >incompass project managment, billing, contacts, work requests, logging,
and
> >a host of other things.
> >
> >A third party too may save you time in the short run, but in the long
run,
> >it'll probably lacks the additional functionality you want.  I recommend
> >buiding your own system, keeping in mind you want to be able to add
> >additionally functionality in the future.
> >
> >- Paul
> >
> >
> >- Original Message -
> >From: "Rey Bango" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Monday, April 16, 2001 1:07 PM
> >Subject: Note passing system?
> >
> >
> > > Anyone know of a good CF-based note/messaging system? I'm not talking
> >about
> > > an email server but more of a db driven messaging software that will
allow
> > > me to post a message to a specific suer. When that user comes in, they
can
> > > check for their own messages and reply accordingly. Again, its not an
> >email
> > > system per se.
> > >
> > > Thanks,
> > >
> > > Rey Bango...
> > > Certified Allaire Instructor
> > > Member of Team Allaire
> > >
> > > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> > >
> > >
> > >
> > >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Note passing system?

[Rey Bango]

Not really, Paul. Its more like an internal messaging system. One where I
can write a message to another user or perhaps a group of users and have
them correspnd back. Again, its not a true email system but one that would
allow me to be able to communicate within the scope of my own application.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."



- Original Message -
From: "Paul Begovich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:35 PM
Subject: Re: Note passing system?


> Sounds like you want a project management tool.
>
> We have an internal system here we use to parse out work.  Basically the
> client/project manager submits an item to a form and it appears on the
> necessary persons desktop based on who they select.  They see the item, do
> the work, mark their time, and reply via the form.  It's a great project
> management tool and it keeps track of correspondence.
>
> Building a system like your describing isn't too difficult, it's just time
> consuming.  We have looked into outside utilities to do this, but we've
> found them lacking.  As a development shop we have found that when we need
> some additional functionality we build it on.  The current system we have
> now has grown out of several developers efforts in the past two years to
> incompass project managment, billing, contacts, work requests, logging,
and
> a host of other things.
>
> A third party too may save you time in the short run, but in the long run,
> it'll probably lacks the additional functionality you want.  I recommend
> buiding your own system, keeping in mind you want to be able to add
> additionally functionality in the future.
>
> - Paul
>
>
> - Original Message -
> From: "Rey Bango" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 1:07 PM
> Subject: Note passing system?
>
>
> > Anyone know of a good CF-based note/messaging system? I'm not talking
> about
> > an email server but more of a db driven messaging software that will
allow
> > me to post a message to a specific suer. When that user comes in, they
can
> > check for their own messages and reply accordingly. Again, its not an
> email
> > system per se.
> >
> > Thanks,
> >
> > Rey Bango...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Creating Page Breaks to make page printable?

[Bryan LaPlante]

http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre
akAfter.asp

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 6:20 PM
Subject: Re: Creating Page Breaks to make page printable?


>
> > Does anyone know of a way to force printing breaks of a document?
>
> You can do this with style sheets.
>
>
>
> --
> This message sent compliments of db Technology
>http://www.dbtech.net/
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

input type='file'

[Chiraporn]

Anyone know how to force input type="file" ,show window dialog box display
only image file ?
I create cold fusion file with contain input type="file" and this page for
upload picture from client computer to server.
I would like  the window dialog box , display file only image files  (not
display other extension ..like .txt , .doc etc.)
Can we do that ?

Any suggestion are highly appreciated.
Phim.


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

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

Re: CF Using 90-100% of processor time (911!)

[Bonnie Betts]

Question on this thread:

Would any of the log files give you a hint as to which pages were accessed
when the server started using up resources?

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


- Original Message -
From: "Steven A. del Sol" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 1:35 PM
Subject: Re: CF Using 90-100% of processor time (911!)


> I believe your problem is that on one of your pages you are timing out.
> Check to see if you have a page where you are passing a Alpha into a
> numeric field.
>
> It will not necessarily crash if you have a number in the sequence
> somewhere but it can stall your
> cfserver for hours.  Also, set your timeout's lower and set server to
> restart on two timeouts.
>
> This error can happen with datefields too.  Hope you find your problem it
> took us three weeks
> going through thousands of line of code to fine one date field not
> validating, throwing errors and
> causing  the server to have cfserver at 95% to 100% of the memory usage.
>
>
>
> GOOD LUCK
>
>
>
>
> At 12:48 PM 4/16/2001 -0400, you wrote:
> >My server developed a problem today. CFServer.exe is using almost all of
the
> >available processing time. I've tried stopping and starting the services
and
> >the NT box, but as soon as I start CF again it almost immediately grabs
all
> >of the processor time.
> >
> >I'm running NT and CF 4.01. We've had this application up and running for
a
> >little over a year now and have only started having this problem today.
I'd
> >greatly appreciate any suggestions, since this has my Web site running at
a
> >crawl.
> >
> >TIA!
> >
> >Russell Conway
> >HallofSports.com, Inc.
> >351 West 22nd Street
> >New York, NY 10011
> >P (646) 638-2500
> >F (646) 638-3444
> >http://www.hallofsports.com
> >.. . . where the legends live on
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT: DNS

[Dylan Bromby]

i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this
particular migration? any recommendations? has anyone had any trouble with
DNS on Win2K?

tia.


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

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

Re: Showing the results of an add or edit operation

[Bonnie Betts]

Try this on your submit button:



I used this for a popup page that added a new user, so just take out the
self.close() if you aren't using a popup.

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


- Original Message -
From: "Hubert Earl" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 10:42 AM
Subject: Showing the results of an add or edit operation


> Hi,
>
> I've built four files. The first shows the contents of a table.  The
second is a form which the user to add to, edit or delete from the table,
after which the user is automatically returned to the file showing the table
contents.  The third is the action file for the add to and edit operation
and the fouth the action file for the delete operation.
>
> The problem is that when the user is automatically returned to the page
showing the table contents,  it doesn't show the results of the change for
the add to or the edit operations.  The user has to hit the refresh button
to see the changes made (for the delete operation, however, the change is
shown).
>
> What additional code should I use so that the results of the add to and
edit operations are immediately visible, and in which file should the code
be put?
>
> Sincerely,
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT: Screen Shot on Win 2K

[Joshua Tipton]

alt print screen then past into a word doc

-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:42 PM
To: CF-Talk
Subject: Re: OT: Screen Shot on Win 2K


I always just hit Print Screen, I have used Alt or Shift even back in Win95.

I just tried it and it still works.

At 11:29 PM 4/16/2001 -0400, you wrote:
>Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
>Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
>wants to put the display in High Contrast.
>
>Thanks,
>Rich
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT: Screen Shot on Win 2K

[Nick McClure]

I meant to say I have never used Alt or Shift.

At 11:41 PM 4/16/2001 -0400, you wrote:
>I always just hit Print Screen, I have used Alt or Shift even back in Win95.
>
>I just tried it and it still works.
>
>At 11:29 PM 4/16/2001 -0400, you wrote:
> >Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
> >Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
> >wants to put the display in High Contrast.
> >
> >Thanks,
> >Rich
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT: Screen Shot on Win 2K

[Dain Anderson]

Alt-Printscreen captures the active window, whereas Ctrl-printscreen
captures the entire window.

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/



- Original Message -
From: "Nick McClure" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 11:41 PM
Subject: Re: OT: Screen Shot on Win 2K


> I always just hit Print Screen, I have used Alt or Shift even back in
Win95.
>
> I just tried it and it still works.
>
> At 11:29 PM 4/16/2001 -0400, you wrote:
> >Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
> >Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
> >wants to put the display in High Contrast.
> >
> >Thanks,
> >Rich
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT: Screen Shot on Win 2K

[Nick McClure]

I always just hit Print Screen, I have used Alt or Shift even back in Win95.

I just tried it and it still works.

At 11:29 PM 4/16/2001 -0400, you wrote:
>Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
>Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
>wants to put the display in High Contrast.
>
>Thanks,
>Rich
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Dynamically Displayed Content Weekly?

[Christopher Olive, CIO]

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

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



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


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

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



.SQL...



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

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



.SQL...





- Andy


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

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

RE: Screen Shot on Win 2K

[Ken Wilson]

> Off Topic: How do you do a screen shot with Win 2000?


Alt + Print Screen does it for me on Win2K Pro and Server.




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

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

Re: Screen Shot on Win 2K

[Kevin Mansel]

i thought it was just  alt+print screen>?>?>?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT: Screen Shot on Win 2K

[ibtoad]

Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
wants to put the display in High Contrast.

Thanks,
Rich



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

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

RE: Dynamically Displayed Content Weekly?

[Andrew Tyrone]

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

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



SQL...



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

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



SQL...





- Andy


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

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

RE: Dynamically Displayed Content Weekly?

[Christopher Olive, CIO]

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

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



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


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

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

hth,

DK

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


> Can anyone tell me where I could find out more regarding dynamically
> displaying text on a cfm page weekly?
>
> I know this can be done in ASP but wasn't sure if it was possible in cf.
>
> TIA,
> Dayv
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Spectra

[Parker, Kevin]

Anyone in Australia using Spectra please contact me off list.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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






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


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

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

RE: Server Co-Location

[Erika L Walker]

Do you have a location preference? Is it a rack server or a tower?

Erika

"Twixt optimist and pessimist, The difference is droll; The optimist sees
the doughnut, The pessimist, the hole." - McLandburgh Wilson

-Original Message-
From: Kelly [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:08 PM
To: CF-Talk
Subject: Server Co-Location


Anyone know of any reasonable co lo places? We don't want a dedicated server
we want to co-locate a server we already have.  Anyway just figured I would
see if
anyone else was co-locating and if you could recommend any companies.
Kelly
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Creating Page Breaks to make page printable?

[jmedlin]

> Does anyone know of a way to force printing breaks of a document?

You can do this with style sheets.



--
This message sent compliments of db Technology
   http://www.dbtech.net/



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

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

Re: Note passing system?

[Steven A. del Sol]

I have a socket I wrote for my organization.  Real crude but it works.
Interested?


Steve


>Sounds like you want a project management tool.
>
>We have an internal system here we use to parse out work.  Basically the
>client/project manager submits an item to a form and it appears on the
>necessary persons desktop based on who they select.  They see the item, do
>the work, mark their time, and reply via the form.  It's a great project
>management tool and it keeps track of correspondence.
>
>Building a system like your describing isn't too difficult, it's just time
>consuming.  We have looked into outside utilities to do this, but we've
>found them lacking.  As a development shop we have found that when we need
>some additional functionality we build it on.  The current system we have
>now has grown out of several developers efforts in the past two years to
>incompass project managment, billing, contacts, work requests, logging, and
>a host of other things.
>
>A third party too may save you time in the short run, but in the long run,
>it'll probably lacks the additional functionality you want.  I recommend
>buiding your own system, keeping in mind you want to be able to add
>additionally functionality in the future.
>
>- Paul
>
>
>- Original Message -
>From: "Rey Bango" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, April 16, 2001 1:07 PM
>Subject: Note passing system?
>
>
> > Anyone know of a good CF-based note/messaging system? I'm not talking
>about
> > an email server but more of a db driven messaging software that will allow
> > me to post a message to a specific suer. When that user comes in, they can
> > check for their own messages and reply accordingly. Again, its not an
>email
> > system per se.
> >
> > Thanks,
> >
> > Rey Bango...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Note passing system?

[Rey Bango]

You'll have to ask Dave Watts on that one. It was a quote he made. It
sounded cool so I took! ;o)

Rey,,,

- Original Message -
From: "Jason Lotz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 2:42 PM
Subject: Re: Note passing system?


> >>>"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
> What in the world does the above quote mean?  It's boggling my mind!
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Creating Page Breaks to make page printable?

[Steven A. del Sol]

Does anyone know of a way to force printing breaks of a document?


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

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

RE: CFMail not escaping dots

[Kevin Langevin]

What platform is this happening on?  Sounds like a Unix/Solaris issue...


-Kev


> -Original Message-
> From: Victor Chou [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 6:47 PM
> To: CF-Talk
> Subject: CFMail not escaping dots
>
>
> I just had this interesting thing happening:
>
> While sending an html email, things look really funny, then found out that
> styles starting with a dot have the dot chopped off.
>
> eg.
> ..blah end up bing just blah
>
> Also, seems that if you have the dot on a single line
>
> as in . (standard way of terminating the data in
> SMTP) the email
> will end there
>
> All pointing to the inescapable (bad, bad pun) conclusion of CF
> not escaping
> the dot (symptom found in both 4.0 and 4.5). Is there a patch for this?
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Server Co-Location

[Christopher Cortes]

I have worked with DataReturn before. They seemed to have pretty good
service. I don't know anything about their fees and policies. I think they
are at www.datareturn.com

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Kelly [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:08 PM
To: CF-Talk
Subject: Server Co-Location


Anyone know of any reasonable co lo places? We don't want a dedicated server
we want to co-locate a server we already have.  Anyway just figured I would
see if
anyone else was co-locating and if you could recommend any companies.
Kelly
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: anyone else?!

[C. Hatton Humphrey]

You don't put quotes around the field names

INSERT INTO myWork (siteTypeID, siteUrl, siteName, siteDescription,
dateDone, sitePicture)
VALUES ( #siteTypeId#, '#siteUrl#', '#siteName#', '#siteDescription#',
'#dateDone#', '#sitePicture#')

HTH
Hatton
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 6:45 PM
To: CF-Talk
Subject: anyone else?!


does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription',
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an
access db)
This is the error:
ODBC Error Code = S0022 (Column not found)


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
the following unknown field name: ''siteTypeID''. Make sure you have typed
the name correctly, and try the operation again.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: anyone else?!

[John Wilker]

I'd say, ditch the single quotes around your column names.

J.



John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 3:45 PM
To: CF-Talk
Subject: anyone else?!


does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription',
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an
access db)
This is the error:
ODBC Error Code = S0022 (Column not found)


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
the following unknown field name: ''siteTypeID''. Make sure you have typed
the name correctly, and try the operation again.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: anyone else?!

[Howie Hamlin]

Take out the quotes from the first line.

HTH,

Howie

- Original Message -
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 6:44 PM
Subject: anyone else?!


> does anyone else see anything wrong with this insert statement?
>
> INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName',
'siteDescription', 'dateDone', 'sitePicture')
> VALUES (
> #siteTypeId#,
> '#siteUrl#',
> '#siteName#',
> '#siteDescription#',
> '#dateDone#',
> '#sitePicture#')
>
> all fields are text accept for the siteTypeId that is Number, (this is an
access db)
> This is the error:
> ODBC Error Code = S0022 (Column not found)
>
>
> [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
contains the following unknown field name: ''siteTypeID''. Make sure you
have typed the name correctly, and try the operation again.
>
>
>
> The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (12:1) to (14:23).
>
> and the column is in the myWork table so what gives?
>
>
> Thanks in advance
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: anyone else?!

[Simon Horwith]

try killing all those single quotes in the list of column names ;)

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 6:45 PM
To: CF-Talk
Subject: anyone else?!


does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription',
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an
access db)
This is the error:
ODBC Error Code = S0022 (Column not found) 


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
the following unknown field name: ''siteTypeID''. Make sure you have typed
the name correctly, and try the operation again. 



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: anyone else?!

[Garza, Jeff]

INSERT INTO myWork (siteTypeID, siteUrl, siteName, siteDescription,
dateDone, sitePicture)
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

To start with you don't need single quotes around your column names.  The
database is looking for a column named 'siteTypeID' (with quotes) that it
doesn't find.  Also, make sure that the dateDone field is not stored as a
date/time field.  Otherwise the above should work

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

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



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 16, 2001 3:45 PM
To: CF-Talk
Subject: anyone else?!


does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription',
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an
access db)
This is the error:
ODBC Error Code = S0022 (Column not found) 


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
the following unknown field name: ''siteTypeID''. Make sure you have typed
the name correctly, and try the operation again. 



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cfmal with attachments and cfserver memory usage

[Christopher Cortes]

Ian,

It seems to me that you might be using CFMAIL as a high volume mail server.
I don't think that it was intended to be used that way. Is there any way you
can use ColdFusion to dump your messages to disk and use a dedicated
(non-ColdFusion) mail server to do the rest of the work? Doing this would
likely increase ColdFusion performance and mail service response time.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Ian MacFadyen [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 8:55 AM
To: CF-Talk
Subject: cfmal with attachments and cfserver memory usage


While sending multiple cfmail messages with attachments I have realized
cfserver memory allocation problems. Has anybody else?

WinNT CF Application Server 4.5.1 SP 2 acquires large volumes of RAM each
time when sending large volumes of cfmails(near 1000 email messages per
time, using the query attribute - each having an attachment ranging in size
from 30K to 300K).

I understand that if CF needs more memory resources the service will claim
that what it needs. According to the heaping protocol, it will not release
the additionally acquired RAM, since the benefit of keeping the memory
in-hand far out weighs the costs of releasing and re-acquiring it; assuming
that more than likely it will be needed in the near future.

I suppose this is reasonable, but why once the cfmails are sent is the
memory not accounted for as available for use? Upon subsequent cfmailings
with attachments, more memory is heaped in addition to that previously
acquired. It seems inevitable that, with every batch of cfmails with
attachments, this will happen again, end-on-end until the server runs out of
available memory and crashes.

I hypothesize that something is wrong here. Any other encounters of this
kind out there? Is the cfmail spooler module flawed when it comes to
attachments? Can you offer any alternatives and/or sugestions?

Thanks,

Ian MacFadyen
Sr. Application Developer
Cardinal Communications
www.cardinalweb.com
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: anyone else?! GRRRRRRRRR

[Jay Patton]

its definitely Monday.
' around the column names would be my problem
Sorry for the interruption
Game on
:)


does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription', 
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an access db)
This is the error:
ODBC Error Code = S0022 (Column not found) 


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the 
following unknown field name: ''siteTypeID''. Make sure you have typed the name 
correctly, and try the operation again. 



The error occurred while processing an element with a general identifier of (CFQUERY), 
occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com



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

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

CFMail not escaping dots

[Victor Chou]

I just had this interesting thing happening:

While sending an html email, things look really funny, then found out that
styles starting with a dot have the dot chopped off.

eg.
..blah end up bing just blah

Also, seems that if you have the dot on a single line

as in . (standard way of terminating the data in SMTP) the email
will end there

All pointing to the inescapable (bad, bad pun) conclusion of CF not escaping
the dot (symptom found in both 4.0 and 4.5). Is there a patch for this?


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

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

Server Co-Location

[Kelly]

Anyone know of any reasonable co lo places? We don't want a dedicated server
we want to co-locate a server we already have.  Anyway just figured I would 
see if
anyone else was co-locating and if you could recommend any companies.
Kelly


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

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

anyone else?!

[Jay Patton]

does anyone else see anything wrong with this insert statement?

INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName', 'siteDescription', 
'dateDone', 'sitePicture')
VALUES (
#siteTypeId#,
'#siteUrl#',
'#siteName#',
'#siteDescription#',
'#dateDone#',
'#sitePicture#')

all fields are text accept for the siteTypeId that is Number, (this is an access db)
This is the error:
ODBC Error Code = S0022 (Column not found) 


[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the 
following unknown field name: ''siteTypeID''. Make sure you have typed the name 
correctly, and try the operation again. 



The error occurred while processing an element with a general identifier of (CFQUERY), 
occupying document position (12:1) to (14:23).

and the column is in the myWork table so what gives?


Thanks in advance

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com


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

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

Re: Note passing system?

[Paul Begovich]

Sounds like you want a project management tool.

We have an internal system here we use to parse out work.  Basically the
client/project manager submits an item to a form and it appears on the
necessary persons desktop based on who they select.  They see the item, do
the work, mark their time, and reply via the form.  It's a great project
management tool and it keeps track of correspondence.

Building a system like your describing isn't too difficult, it's just time
consuming.  We have looked into outside utilities to do this, but we've
found them lacking.  As a development shop we have found that when we need
some additional functionality we build it on.  The current system we have
now has grown out of several developers efforts in the past two years to
incompass project managment, billing, contacts, work requests, logging, and
a host of other things.

A third party too may save you time in the short run, but in the long run,
it'll probably lacks the additional functionality you want.  I recommend
buiding your own system, keeping in mind you want to be able to add
additionally functionality in the future.

- Paul


- Original Message -
From: "Rey Bango" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 1:07 PM
Subject: Note passing system?


> Anyone know of a good CF-based note/messaging system? I'm not talking
about
> an email server but more of a db driven messaging software that will allow
> me to post a message to a specific suer. When that user comes in, they can
> check for their own messages and reply accordingly. Again, its not an
email
> system per se.
>
> Thanks,
>
> Rey Bango...
> Certified Allaire Instructor
> Member of Team Allaire
>
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (Easy SQL) Case Sensitive?

[Erika L Walker]

>>dateformat(signup_datetime, "mm/dd/")

This post reminded me of something I needed to confirm

I'm about to start development on a Unix platform, and I've been told to
make sure my ColdFusion functions and Application.cfm were properly
formatted in regards to case sensitivity.

Is this correct?

Erika

"Twixt optimist and pessimist, The difference is droll; The optimist sees
the doughnut, The pessimist, the hole." - McLandburgh Wilson

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 4:26 PM
To: CF-Talk
Subject: RE: (Easy SQL)


dateformat(signup_datetime, "mm/dd/")

Or use any mask you choose for the mm/dd/ part. Just run your query and
grab the fields, then do the mask in CF when displaying the data.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:09 PM
To: CF-Talk
Subject: (Easy SQL)


I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re:CF4.5.1 SP2 is chewing up memory

[David Frentrup]

Read the thread on "smartheap", which is the memory management utility starting in 
4.5.  Memory is not returned to NT, but kept for cf to use later.  It apparently 
doesn't matter what task manager or performance monitor tells you about available 
memory. 
David Frentrup

I'm running CF Server Enterprise 4.5.1, SP2. It is just chewing up memory.
   When I stop/restart it starts out at about 40Megs and over the course of a
   day climbs to 170Megs.

   I don't want to have to stop/restart the service on a regular basis because
   of implications for sessions/applications etc. But I need to figure out why
   it memory use is creeping up so high.

   How can I determine where the memory sinkhole is occurring?

   Thanks,
   Paul Sinclair


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

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

cfmal with attachments and cfserver memory usage

[Ian MacFadyen]

While sending multiple cfmail messages with attachments I have realized
cfserver memory allocation problems. Has anybody else?

WinNT CF Application Server 4.5.1 SP 2 acquires large volumes of RAM each
time when sending large volumes of cfmails(near 1000 email messages per
time, using the query attribute - each having an attachment ranging in size
from 30K to 300K).

I understand that if CF needs more memory resources the service will claim
that what it needs. According to the heaping protocol, it will not release
the additionally acquired RAM, since the benefit of keeping the memory
in-hand far out weighs the costs of releasing and re-acquiring it; assuming
that more than likely it will be needed in the near future.

I suppose this is reasonable, but why once the cfmails are sent is the
memory not accounted for as available for use? Upon subsequent cfmailings
with attachments, more memory is heaped in addition to that previously
acquired. It seems inevitable that, with every batch of cfmails with
attachments, this will happen again, end-on-end until the server runs out of
available memory and crashes.

I hypothesize that something is wrong here. Any other encounters of this
kind out there? Is the cfmail spooler module flawed when it comes to
attachments? Can you offer any alternatives and/or sugestions?

Thanks,

Ian MacFadyen
Sr. Application Developer
Cardinal Communications
www.cardinalweb.com
[EMAIL PROTECTED]


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

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

RE: (Easy SQL)

[Matt Eschenbaum]

Here is a similar bit of code that I used to get records between certain
dates.










SELECT  dbo.AppointmentType.ShortDescription,
dbo.AppointmentType.AppointmentTypeID,
dbo.AppointmentType.Background, dbo.AppointmentType.Foreground,
dbo.Appointments.Client,dbo.Appointments.Date,
dbo.Appointments.EmployeeID, dbo.Appointments.AppointmentID
FROMdbo.Appointments, dbo.AppointmentType 
WHERE   dbo.Appointments.EmployeeID = #EmployeeID# AND
dbo.Appointments.AppointmentTypeID =
dbo.AppointmentType.AppointmentTypeID AND
(dbo.Appointments.Date >= #ODBCStartDate#) AND
(dbo.Appointments.Date <=
#ODBCEndDate#)
ORDER BYDATE


You will notice that I added my own start time and end time.  I have noticed
some issues with the datepart function and thus did a work around with the
above code.

Sincerely,

Matthew M. Eschenbaum, ACP
Systems Developer
[EMAIL PROTECTED]
ph: (206)956.0888 ext.24
fax:(206)956.4460
___
DevTech, Inc.: Web Application Training & Development
www.dev-tech.com
600 Stewart Street
15th Floor
Seattle, WA 98101


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:00 PM
To: CF-Talk
Subject: RE: (Easy SQL)


hmmm. I am getting a "'dateformat' not a recognized function" error. So I 
need the SQL statement similar to

select datepart(,signup_datetime) as year, datepart(mm,signup_datetime) 
as month, datepart(d,signup_datetime) as day, count(userID) as NewMembers
from membertable
group by datepart(,signup_datetime), datepart(mm,signup_datetime), 
datepart(d,signup_datetime)

I just can't believe this is the way you have to do it.

Also: how would I reconnect date(year,month,day) as datetime field in the 
returned query results.

Eric
Note I am trying to limit the amount of record that are returned by using 
SQL aggregate functions. It seems like there should be a way to easily group

by justthedatepartofadatetimefield but I can't find any syntax to do it.

Eric


From: "John Wilker" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: (Easy SQL)
Date: Mon, 16 Apr 2001 13:25:32 -0700

dateformat(signup_datetime, "mm/dd/")

Or use any mask you choose for the mm/dd/ part. Just run your query and
grab the fields, then do the mask in CF when displaying the data.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:09 PM
To: CF-Talk
Subject: (Easy SQL)


I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (Easy SQL)

[Eric Dawson]

hmmm. I am getting a "'dateformat' not a recognized function" error. So I 
need the SQL statement similar to

select datepart(,signup_datetime) as year, datepart(mm,signup_datetime) 
as month, datepart(d,signup_datetime) as day, count(userID) as NewMembers
from membertable
group by datepart(,signup_datetime), datepart(mm,signup_datetime), 
datepart(d,signup_datetime)

I just can't believe this is the way you have to do it.

Also: how would I reconnect date(year,month,day) as datetime field in the 
returned query results.

Eric
Note I am trying to limit the amount of record that are returned by using 
SQL aggregate functions. It seems like there should be a way to easily group 
by justthedatepartofadatetimefield but I can't find any syntax to do it.

Eric


From: "John Wilker" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: (Easy SQL)
Date: Mon, 16 Apr 2001 13:25:32 -0700

dateformat(signup_datetime, "mm/dd/")

Or use any mask you choose for the mm/dd/ part. Just run your query and
grab the fields, then do the mask in CF when displaying the data.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:09 PM
To: CF-Talk
Subject: (Easy SQL)


I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: validation

[Matt Eschenbaum]

Steven has a simple and effective approach to your problem.  You may also
want, depending on your spec, want to allow the user to change current user
information.  This can be done in the same manner by giving them the option
to update.  Just another way to decide what the user is trying to
accomplish.

Sincerely,

Matthew M. Eschenbaum, ACP
Systems Developer
[EMAIL PROTECTED]
ph: (206)956.0888 ext.24
fax:(206)956.4460
___
DevTech, Inc.: Web Application Training & Development
www.dev-tech.com
600 Stewart Street
15th Floor
Seattle, WA 98101


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:27 PM
To: CF-Talk
Subject: validation


i want to have a form where i can insert a new user into my database.  and i
have that form but i want to be able to validate it before it submits this
new user into my database.  i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have user
input errors if they dont search thru the drop down list before adding a new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.  
can anyone give me any ideas or some direction?  
thanks for all your help,
bec.


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Note passing system?

[Daniel H]

Tony:

Have you looked at the code in Chatster?

http://www.factorxsoftware.com/

This is basically a CFM version of AOLIM - ICQ etc..

dunno if this meets your needs

wish you well in your quest
Dan

-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:59 PM
To: CF-Talk
Subject: RE: Note passing system?


I am also scheduled to build such a system soon. Any input would be greatly
appreciated. Perhaps I can get a head start.

Tony Gruen


-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:07 AM
To: CF-Talk
Subject: Note passing system?


Anyone know of a good CF-based note/messaging system? I'm not talking about
an email server but more of a db driven messaging software that will allow
me to post a message to a specific suer. When that user comes in, they can
check for their own messages and reply accordingly. Again, its not an email
system per se.

Thanks,

Rey Bango...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: validation

[David Baskin]

Becky, this is what i do. the user submits their info and i do a check in
the database on the processing page for the info they have just submitted.
if it exists, i CFINCLUDE the previous page but display error messages as
needed and pre-populate the fields they have filled out. if they don't
exist, then i process the next query which adds them to the DB and then
displays a confirmation. all you need is an if/else block where you check
the record count of the select based on username/email/whatever. HTH.

david

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:27 PM
To: CF-Talk
Subject: validation


i want to have a form where i can insert a new user into my database.  and i
have that form but i want to be able to validate it before it submits this
new user into my database.  i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have user
input errors if they dont search thru the drop down list before adding a new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.
can anyone give me any ideas or some direction?
thanks for all your help,
bec.


*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information.  If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: validation

[Semrau, Steven L Mr SRA]

What you might want to do is this:

Create an action page that your form, that you have built already, is
submitted to.

On the action page first run a query that checks that database of users
against the form input, say on Last Name.

Then have a  that checks for the record count from the first query to
be 0 (zero) and if that condition is met, then do your insert.  
Send them back to the login screen with a notice that the information they
submitted already exists.


SELECT Last_name
FROM yourTable
WHERE Last_Name = '#form.last_name#'


INSERT INFORMATION QUERY






There are other ways of doing log in pages, but I think this will accomplish
what you are looking for.

Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 4:27 PM
To: CF-Talk
Subject: validation


i want to have a form where i can insert a new user into my database.  and i
have that form but i want to be able to validate it before it submits this
new user into my database.  i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have user
input errors if they dont search thru the drop down list before adding a new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.  
can anyone give me any ideas or some direction?  
thanks for all your help,
bec.


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (Easy SQL)

[John Wilker]

dateformat(signup_datetime, "mm/dd/")

Or use any mask you choose for the mm/dd/ part. Just run your query and
grab the fields, then do the mask in CF when displaying the data.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:09 PM
To: CF-Talk
Subject: (Easy SQL)


I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

validation

[Jones, Becky]

i want to have a form where i can insert a new user into my database.  and i
have that form but i want to be able to validate it before it submits this
new user into my database.  i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have user
input errors if they dont search thru the drop down list before adding a new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.  
can anyone give me any ideas or some direction?  
thanks for all your help,
bec.


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 



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

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

Search Facility/Indexing Service

[Christopher Cortes]

I am looking for a product similar to Netscape's IPlanet - Compass Server.
Has anyone worked with this product and know of similar tool that I can use
with IIS. Thanks.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


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

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

Rename DB

[Duane Boudreau]

Hi All,

I have a situation on my hands. I renamed a table that corrupt data,
regenerated it from SQL and repopulated it with "good" data. Unfortunately,
unbeknownst to me, the renaming of the original table caused all the
triggers and views associated with the table to be modified.

I am thinking of renaming the new table that was generated to tablename_temp
and renaming the original back to tablename, truncating the table and using
select into to repopulate it. How dangerous is this? Is there another way?

TIA,
Duane


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

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

RE: SQL help

[Hoffman, Joe (CIT)]

Jeff,

>Something like this
If you are actually using 'date', 'time' and 'where' as field 
names in your database ... they are SQL reserved word.

If they are not, perhaps:

SELECT  title, titledate, titlewhere, description, titletime
FROM my table
WHERE titledate >= #CreateODBCDate(NOW())#
ORDER BY titledate ASC

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

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 3:18 PM
To: CF-Talk
Subject: SQL help


Hello cf-talk,

  I'm stuck over how to do this.

  I have a table and each record has a date field (long date format).

  I need to display the records on a page where the record with the
  date closest to the current date when the page is viewed will
  display first, then the records whose dates are in the future in
  chronological order. Something like this:


   SELECT  title, date, where, description, time

   FROM my table

   WHERE date after today

  ORDER by chronological order


   I can't seem to get the WHERE part right.

   Any suggestions??


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL help

[Dave Livingston]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
This should do it in MS-SQL Server. I think Oracle has a different Date
convert function.

SELECT  title, date, where, description, time
FROM my table
WHERE (date > CONVERT(DATETIME, '2001-4-16 00:00:00', 102))
ORDER BY date DESC, time DESC

Dave Livingston
[EMAIL PROTECTED]


-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:18 PM
To: CF-Talk
Subject: SQL help


*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hello cf-talk,

  I'm stuck over how to do this.

  I have a table and each record has a date field (long date format).

  I need to display the records on a page where the record with the
  date closest to the current date when the page is viewed will
  display first, then the records whose dates are in the future in
  chronological order. Something like this:


   SELECT  title, date, where, description, time

   FROM my table

   WHERE date after today

  ORDER by chronological order


   I can't seem to get the WHERE part right.

   Any suggestions??


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]

Internet Guns For Hire
(603) 356-0768
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Excel and ColdFusion

[Jeffry Houser]

  Good reading, thank you!  I've never heard of the p2p.wrox.com 
before.  However it did not solve the problem.  I'm running Apache on 
Windows 98.

   Also, the  
command did not work, but thanks for that suggestion to.

   What did work, was moving the file into the root directory of the 
machine (and changing the DSN accordingly).  Does anyone know if what the 
limit on the number of characters in a directory name for this type of 
thing is?  It was somewhere between 120 and 130.  I removed all spaces from 
the path (by renaming directories so they had no spaces) and that had no 
effect, so I anticipate that was not the problem.


At 11:24 AM 04/16/2001 -0700, you wrote:
>This occurs in a could of cases:
>-When trying to import a file that has a invalid or not matching extension
>name. -Could be a bug with IIS 5. If you are running IIS 5 log in as
>administrator and view/modify privileges on the server.
>
>
>Check out:
>http://support.microsoft.com/support/kb/articles/Q245/4/07.asp
>http://p2p.wrox.com/archive/asp_databases/2001-02/98.asp
>http://www.p2p.wrox.com/archive/beginning_asp/2000-09/11.asp
>- Original Message -
>From: "Jeffry Houser" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, April 16, 2001 1:59 PM
>Subject: Excel and ColdFusion
>
>
> >
> >I searched the Microsoft Knowledge Base
> >I searched the Allaire Knowledge Base.
> >I looked at CFCOMET (great site)
> >I searched the mailing list archives.
> >I searched through the developer's exchange, and downloaded some of the
> > tags.
> >I checked the FAQ
> >
> >I still haven't found the answer I'm looking for, so I'm posting
> > here.  I'm trying to set up something to read from an excel sheet.  When I
> > run the template, I keep getting the error:
> >
> >  [Microsoft][ODBC Excel Driver] Cannot update. Database or object is
> > >
> >I downloaded a SQL connector program from the Allaire KB.  It connects
> > to the datasource just fine.  I checked the datasource, and I have
> > deselected the read-only option.  However, I have seen it reselect itself.
> >
> > I'm on a windows 98 unit.  This is the code in my test template:
> >
> > 
> >  select *
> >  from [test$]
> > 
> >
> > 
> >  #getsheet.recordcount#
> > 
> >
> >The code seems about as basic as you can get.
> >
> >Any suggestions would be welcome.
> >
> >
> > Jeffry Houser | mailto:[EMAIL PROTECTED]
> > AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> > --
> > Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> > Due out June 2001
> > --
> > DotComIt, LLC
> > database driven web data using ColdFusion, Lotus Notes/Domino
> > --
> > Half of the Alternative Folk Duo called Far Cry Fly
> > http://www.farcryfly.com | http://www.mp3.com/FarCryFly
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SQL help

[Jeff Fongemie]

Hello cf-talk,

  I'm stuck over how to do this.

  I have a table and each record has a date field (long date format).

  I need to display the records on a page where the record with the
  date closest to the current date when the page is viewed will
  display first, then the records whose dates are in the future in
  chronological order. Something like this:


   SELECT  title, date, where, description, time

   FROM my table

   WHERE date after today

  ORDER by chronological order


   I can't seem to get the WHERE part right.

   Any suggestions??


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768



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

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

(Easy SQL)

[Eric Dawson]

I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the 
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just 
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: HElp

[Erika L Walker]

H.did his computer eat him? Or her?

Erika

"Twixt optimist and pessimist, The difference is droll; The optimist sees
the doughnut, The pessimist, the hole." - McLandburgh Wilson

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:50 PM
To: CF-Talk
Subject: HElp
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: sql date times

[Hoffman, Joe (CIT)]

I have not seen a reply to this thread yet ... so 

>I know this is an SQL question but does anyone know how to break dates
apart
>using the (cast or convert functions, (I think)) IN SQL,,

>its just that when I mask my date from my query I never get the right
date..

Can you elaborate some more on this?  What exact format are you trying 
to convert from and what exact format are you trying to go to?  Is that 
just display? What is the format in the database?

Not sure if this is anything you could use ... check out scalar functions 
at http://www.houseoffusion.com/scalar/scalar.htm like

SELECT * FROM FOO
WHERE EMPLOYEEID = '#FORM.EMPLOYEEID#'
AND {fn Year(STARTDATE)} = #DatePart("", Now())# 

and DatePart



DatePart Example

Today's date is #todayDate#.

Using datepart, we can extract an integer representing
the various dateparts from that value


year: #DatePart("", todayDate)#
quarter: #DatePart("q", todayDate)#
month: #DatePart("m", todayDate)#
day of year: #DatePart("y", todayDate)#
day: #DatePart("d", todayDate)#
weekday: #DatePart("w", todayDate)#
week: #DatePart("ww", todayDate)#
hour: #DatePart("h", todayDate)#
minute: #DatePart("n", todayDate)#
second: #DatePart("s", todayDate)#




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

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 7:31 AM
To: CF-Talk
Subject: sql date times


Hi all,

our sql server is set up to american date Time format, so as you know once
thats done you must play by its rules,

I know this is an SQL question but does anyone know how to break dates apart
using the (cast or convert functions, (I think)) IN SQL,,

its just that when I mask my date from my query I never get the right date..

I've submitted this query before, but not regarding the above...

if anyone has any ideas' I'd be well gratefull

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

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

RE: text box output truncation

[Semrau, Steven L Mr SRA]

Well right off the bat I would have to say it's the fact that you are
setting  a maximum limit on the text of "50".

MAXLENGTH
Indicates the maximum number of characters that can be entered into a text
field. This can be greater than specified by the SIZE attribute, in which
case the field will scroll appropriately. The default number of characters
is unlimited. 


Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 10:19 AM
To: CF-Talk
Subject: text box output truncation


Hi Guys am experiencing a strange thing!
when I try to get the vakue from the dateabse into the text bos for further
editing .. the value for #meeting_name#gets truncated.. and am getting
results like"Brand" when i wanted that to be "Brand new day"
please suggest the code is Given down below
-thanks 
-paul
-
 
 
  Title  




Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Studio 4.52 crashes on every exit!!

[Jeff Fongemie]

Hello cf-talk,

  I went from 4.0 to 4.52 with a fresh install after format.

  Studio crashes everytime I exit the program and in viewing,
  datasourses in the resourse tab, it won't refresh properly to see
  the latest tables.

  Is Studio 4.52 this bad for everyone? I may go back to 4.0.


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768



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

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

CFFORM Validate and/or TextArea Validate

[Mcmeartya]

First I'm sorry if this has been covered in past ... which I'm sure it has. But I'd 
appreciate a little help or a push in the right direction.

I've got a CFForm with CFInputs and a Textarea object. I'm letting CF handle 
validation for CF objects and I need to validate the textarea ... client side.

Now, it appears that when I add an OnSubmit to the CFForm it gets dropped ... and 
overwritten with the validate call used for CF objects.

Is there a way to call a Validate function using CF if validation is active?

Or I can use the OnValidate function of one of the CFInput objects to validate ... 
which works fine except if the validation fails, the Message from the CFInput box is 
returned. Is there a way to turn this message off or at least a way to change what the 
Message text is?

Thanks in advance for any direction,
Allison

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

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

RE: cookies not being set

[Conrad Classen]

Another way that may work is to set-up the
cflocation tag as a string, and then evaluate it
at the correct moment. I will try this myself a
bit later.

With cflocation itself in the template, CF will
immediately process that line and ignore the rest.


Conrad


-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2001 07:26
To: CF-Talk
Subject: cookies not being set


I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike



  
  

  
  
  
  
  

  

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

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

RE: Note passing system?

[Tony Gruen]

I am also scheduled to build such a system soon. Any input would be greatly
appreciated. Perhaps I can get a head start.

Tony Gruen


-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:07 AM
To: CF-Talk
Subject: Note passing system?


Anyone know of a good CF-based note/messaging system? I'm not talking about
an email server but more of a db driven messaging software that will allow
me to post a message to a specific suer. When that user comes in, they can
check for their own messages and reply accordingly. Again, its not an email
system per se.

Thanks,

Rey Bango...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Excel and ColdFusion

[Dylan Bromby]

have you tried using:

 ?

i don't know if the Excel DSN is being locked, thereby preventing you from
accessing it, but that will force the DSN to be released. to re-enable the
DSN, use:



just replace {DSN} with your actual DSN with no {}.

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:00 PM
To: CF-Talk
Subject: Excel and ColdFusion



   I searched the Microsoft Knowledge Base
   I searched the Allaire Knowledge Base.
   I looked at CFCOMET (great site)
   I searched the mailing list archives.
   I searched through the developer's exchange, and downloaded some of the
tags.
   I checked the FAQ

   I still haven't found the answer I'm looking for, so I'm posting
here.  I'm trying to set up something to read from an excel sheet.  When I
run the template, I keep getting the error:

 [Microsoft][ODBC Excel Driver] Cannot update. Database or object is
read-only.

   I downloaded a SQL connector program from the Allaire KB.  It connects
to the datasource just fine.  I checked the datasource, and I have
deselected the read-only option.  However, I have seen it reselect itself.

I'm on a windows 98 unit.  This is the code in my test template:


 select *
 from [test$]



 #getsheet.recordcount#


   The code seems about as basic as you can get.

   Any suggestions would be welcome.


Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Unicode and CFTREE

[Marius Milosav]

Does anyone know if cftree supports unicode?
thanks

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD) 
www.scorpiosoft.com/vhd/login.cfm




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

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

HEl

[Mcmeartya]

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

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

HElp

[Mcmeartya]

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

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

Re: Note passing system?

[Jason Lotz]

>>>"A browser's beauty, at its heart, is its usefulness as a *TOOL*."

What in the world does the above quote mean?  It's boggling my mind!


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

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

RE: cookies not being set

[Nick McClure]

CFLocation works on an http error.

It is 302 Object Moved.

Cookies work on an http header also. You could get happy and create the 
http headers that will do this. It is all possible and I have done them 
separately. I do not know if this will actually set the cookie though. I am 
going to try this later today.

I will let you know how it works.

At 01:57 PM 4/16/2001 -0400, you wrote:
>Or write the redirect header manually:
>
>http://www.teamallaire.com/tutorials/index.cfm?fuseaction=display&topicid=01
>3
>
>Benjamin S. Rogers
>Web Developer, c4.net
>Voice: (508) 240-0051
>Fax: (508) 240-0057
>
>-Original Message-
>From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 16, 2001 1:41 PM
>To: CF-Talk
>Subject: RE: cookies not being set
>
>
>You cant use CFCOOKIE AND CFLOCATION on the same page, you may want to
>change your CFLOCATION's to a META redirect.
>
>-Adrian
>
>-Original Message-
>From: Mike Sprague [mailto:[EMAIL PROTECTED]]
>
>I have a login page that checks my db to validate user info and if valid
>uses cflocation to redirect to the appropriate page.  I need cookies to work
>because people with AOL have been having problems keeing the session
>variables alive.  My code is below, any help would be greatly appreciated.
>
>Mike
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Excel and ColdFusion

[Brian bouldernet]

This occurs in a could of cases:
-When trying to import a file that has a invalid or not matching extension
name. -Could be a bug with IIS 5. If you are running IIS 5 log in as
administrator and view/modify privileges on the server.


Check out:
http://support.microsoft.com/support/kb/articles/Q245/4/07.asp
http://p2p.wrox.com/archive/asp_databases/2001-02/98.asp
http://www.p2p.wrox.com/archive/beginning_asp/2000-09/11.asp
- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 1:59 PM
Subject: Excel and ColdFusion


>
>I searched the Microsoft Knowledge Base
>I searched the Allaire Knowledge Base.
>I looked at CFCOMET (great site)
>I searched the mailing list archives.
>I searched through the developer's exchange, and downloaded some of the
> tags.
>I checked the FAQ
>
>I still haven't found the answer I'm looking for, so I'm posting
> here.  I'm trying to set up something to read from an excel sheet.  When I
> run the template, I keep getting the error:
>
>  [Microsoft][ODBC Excel Driver] Cannot update. Database or object is
> >
>I downloaded a SQL connector program from the Allaire KB.  It connects
> to the datasource just fine.  I checked the datasource, and I have
> deselected the read-only option.  However, I have seen it reselect itself.
>
> I'm on a windows 98 unit.  This is the code in my test template:
>
> 
>  select *
>  from [test$]
> 
>
> 
>  #getsheet.recordcount#
> 
>
>The code seems about as basic as you can get.
>
>Any suggestions would be welcome.
>
>
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> Due out June 2001
> --
> DotComIt, LLC
> database driven web data using ColdFusion, Lotus Notes/Domino
> --
> Half of the Alternative Folk Duo called Far Cry Fly
> http://www.farcryfly.com | http://www.mp3.com/FarCryFly
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Note passing system?

[Rey Bango]

Anyone know of a good CF-based note/messaging system? I'm not talking about
an email server but more of a db driven messaging software that will allow
me to post a message to a specific suer. When that user comes in, they can
check for their own messages and reply accordingly. Again, its not an email
system per se.

Thanks,

Rey Bango...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."



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

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

Ben Forta in KC

[Bryan LaPlante]

Hello everyone,
I posted this the other day and I don't think I ever saw it come through, so
here it is again.

Ben Forta is coming to Kansas City to speak to our CFUG. go to
http://www.kcfusion.org/ for details and RSVP for the meeting so we will
know how many are coming.

This event is sponsored by:
Allaire/Macromedia
GreenSoft Solutions, Inc.
Network Web Applications, Inc.
Human Kind Systems, Inc.

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


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

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

Excel and ColdFusion

[Jeffry Houser]

   I searched the Microsoft Knowledge Base
   I searched the Allaire Knowledge Base.
   I looked at CFCOMET (great site)
   I searched the mailing list archives.
   I searched through the developer's exchange, and downloaded some of the 
tags.
   I checked the FAQ

   I still haven't found the answer I'm looking for, so I'm posting 
here.  I'm trying to set up something to read from an excel sheet.  When I 
run the template, I keep getting the error:

 [Microsoft][ODBC Excel Driver] Cannot update. Database or object is 
read-only.

   I downloaded a SQL connector program from the Allaire KB.  It connects 
to the datasource just fine.  I checked the datasource, and I have 
deselected the read-only option.  However, I have seen it reselect itself.

I'm on a windows 98 unit.  This is the code in my test template:


 select *
 from [test$]



 #getsheet.recordcount#


   The code seems about as basic as you can get.

   Any suggestions would be welcome.


Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly


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

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

RE: cookies not being set

[Benjamin S. Rogers]

Or write the redirect header manually:

http://www.teamallaire.com/tutorials/index.cfm?fuseaction=display&topicid=01
3

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

-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:41 PM
To: CF-Talk
Subject: RE: cookies not being set


You cant use CFCOOKIE AND CFLOCATION on the same page, you may want to
change your CFLOCATION's to a META redirect.

-Adrian

-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]]

I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike


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

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

RE: Dynamically Displayed Content Weekly?

[SHEETS, DAYV (PB)]

Thanks DK.

Can you provide me with an example?

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


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

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

hth,

DK

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


> Can anyone tell me where I could find out more regarding dynamically
> displaying text on a cfm page weekly?
>
> I know this can be done in ASP but wasn't sure if it was possible in cf.
>
> TIA,
> Dayv
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: cookies not being set

[Jason Lotz]

As I'm sure 100 people on this list will tell you due to the horrendous lag,
when cflocation is used on a page when cookies are being set, the cookies
will not be set correctly.

Instead, I use javascript to relocatewindow.location='whatever.cfm';
- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 10:25 AM
Subject: cookies not being set


> I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.
>
> Mike
>
>
> 
>   
>   
> 
>   
>   
>   
>   
>   
> 
>   
> 
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cookies not being set

[Jeff Britts]

You cant set cookies on a page with CFLOCATION.  The page is redirected
before it is rendered by the browser, therefore, before your cookies are
set.

-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:26 PM
To: CF-Talk
Subject: cookies not being set


I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike



  
  

  
  
  
  
  

  

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

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

RE: Verity Question....

[Belfiori, Ross]

If you have two seperate directories, you may want to make them two spereate
collections and just search them both at the same time.  

-Original Message-
From: Adam Sokolic [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:17 PM
To: CF-Talk
Subject: Verity Question


I have a verity search set up and working fine, the problem I'm having is I
have a group of files that reside outside the directory where the collection
is.  Is it possible (somehow) that when the results are pulled up to link
them outside the Collections directory.  The only thing I can think to do
would be to set the collection at a higher level and exclude everything but
the three directories that would be effected.   I also have search result
that I would like to link to an external web page...and I'm having no luck
with that either.  Any help would be appreciated.




Thanks
Adam
  

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

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

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

Re: cookies not being set

[Kevin Schmidt]

You can't use  and  on the same page.  
trashes the current HTTP headers where cookies are send and generates new
ones.  Since CF doesn't send the headers until the page is done processiong
your headers with the cookies in them never even get to the browser.

Kevin

- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 12:25 PM
Subject: cookies not being set


> I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.
>
> Mike
>
>
> 
>   
>   
> 
>   
>   
>   
>   
>   
> 
>   
> 
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cookies not being set

[Diana Nichols]

You cannot use cflocation on the same page where you set cookies.
Try this instead:




HTH

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

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

-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:26 PM
To: CF-Talk
Subject: cookies not being set


I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike



  
  

  
  
  
  
  

  

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

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

RE: cookies not being set

[Garza, Jeff]

You cannot use CFCOOKIE and CFLOCATION on the same page.

You'll have to code your redirects using Javascript and the onLoad Event.

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

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



-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 16, 2001 10:26 AM
To: CF-Talk
Subject: cookies not being set


I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike



  
  

  
  
  
  
  

  

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

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

RE: cookies not being set

[Adrian Cesana]

You cant use CFCOOKIE AND CFLOCATION on the same page, you may want to
change your CFLOCATION's to a META redirect.

-Adrian

-Original Message-
From: Mike Sprague [mailto:[EMAIL PROTECTED]]

I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.

Mike




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

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

Re: CF Using 90-100% of processor time (911!)

[Steven A. del Sol]

I believe your problem is that on one of your pages you are timing out.
Check to see if you have a page where you are passing a Alpha into a 
numeric field.

It will not necessarily crash if you have a number in the sequence 
somewhere but it can stall your
cfserver for hours.  Also, set your timeout's lower and set server to 
restart on two timeouts.

This error can happen with datefields too.  Hope you find your problem it 
took us three weeks
going through thousands of line of code to fine one date field not 
validating, throwing errors and
causing  the server to have cfserver at 95% to 100% of the memory usage.



GOOD LUCK




At 12:48 PM 4/16/2001 -0400, you wrote:
>My server developed a problem today. CFServer.exe is using almost all of the
>available processing time. I've tried stopping and starting the services and
>the NT box, but as soon as I start CF again it almost immediately grabs all
>of the processor time.
>
>I'm running NT and CF 4.01. We've had this application up and running for a
>little over a year now and have only started having this problem today. I'd
>greatly appreciate any suggestions, since this has my Web site running at a
>crawl.
>
>TIA!
>
>Russell Conway
>HallofSports.com, Inc.
>351 West 22nd Street
>New York, NY 10011
>P (646) 638-2500
>F (646) 638-3444
>http://www.hallofsports.com
>.. . . where the legends live on
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

cookies not being set

[Mike Sprague]

I have a login page that checks my db to validate user info and if valid uses 
cflocation to redirect to the appropriate page.  I need cookies to work because people 
with AOL have been having problems keeing the session variables alive.  My code is 
below, any help would be greatly appreciated.

Mike



  
  

  
  
  
  
  

  



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

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

RE: CF Using 90-100% of processor time (911!)

[mjohnson]

The question is what did you change!  90% of the time there is some bit of
code that was uploaded that was not tested thoroughly enough and causes this
type of problem.  Revert back to the version of the code that existed before
the problem occured and then walk through all the changes.  My guess is that
it is a bad loop that just runs and runs.

Mark

-Original Message-
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 10:07 AM
To: CF-Talk
Subject: Re: CF Using 90-100% of processor time (911!)


This sounds like a similar problem we had but on a Unix server.
The culprit was Client Variables.  We were not using them but had them
"enabled".  It filled up our registry file (8Mb).  So check your registry
file located in the coldfusion directory.  If it's big that's a clue.  To
clean it out, remove client variable entries in it.  Also disable client
variables in the Application.cfm file (CFAPPLICATION tag) unless you are
using them, then switch to writing the client variables into a database
instead of the registry file.

Hope this helps.  It did for us.  Do nothing and your site will get
gridlocked for sure.

Bruce

- Original Message -
From: "Russ Conway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 9:48 AM
Subject: CF Using 90-100% of processor time (911!)


> My server developed a problem today. CFServer.exe is using almost all of
the
> available processing time. I've tried stopping and starting the services
and
> the NT box, but as soon as I start CF again it almost immediately grabs
all
> of the processor time.
>
> I'm running NT and CF 4.01. We've had this application up and running for
a
> little over a year now and have only started having this problem today.
I'd
> greatly appreciate any suggestions, since this has my Web site running at
a
> crawl.
>
> TIA!
>
> Russell Conway
> HallofSports.com, Inc.
> 351 West 22nd Street
> New York, NY 10011
> P (646) 638-2500
> F (646) 638-3444
> http://www.hallofsports.com
> .. . . where the legends live on
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Verity Question....

[Adam Sokolic]

I have a verity search set up and working fine, the problem I'm having is I
have a group of files that reside outside the directory where the collection
is.  Is it possible (somehow) that when the results are pulled up to link
them outside the Collections directory.  The only thing I can think to do
would be to set the collection at a higher level and exclude everything but
the three directories that would be effected.   I also have search result
that I would like to link to an external web page...and I'm having no luck
with that either.  Any help would be appreciated.




Thanks
Adam
  

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

RE: CF Using 90-100% of processor time (911!)

[Cameron Childress]

Stop the service, look for a zero length file in cfusion/mail/spool.  If you
find one, delete it.  Start the service again and you shold be good.  This
may not be your problem, but it will cause that behavior.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: Russ Conway [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 12:48 PM
> To: CF-Talk
> Subject: CF Using 90-100% of processor time (911!)
>
>
> My server developed a problem today. CFServer.exe is using almost
> all of the
> available processing time. I've tried stopping and starting the
> services and
> the NT box, but as soon as I start CF again it almost immediately
> grabs all
> of the processor time.
>
> I'm running NT and CF 4.01. We've had this application up and
> running for a
> little over a year now and have only started having this problem
> today. I'd
> greatly appreciate any suggestions, since this has my Web site
> running at a
> crawl.
>
> TIA!
>
> Russell Conway
> HallofSports.com, Inc.
> 351 West 22nd Street
> New York, NY 10011
> P (646) 638-2500
> F (646) 638-3444
> http://www.hallofsports.com
> .. . . where the legends live on
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF Using 90-100% of processor time (911!)

[Mike Brunt]

Did you make any coding or ODBC-OLEDB-Native Driver changes just prior to
this problem.  Does CF take the resources before any  actio-hits on the
website/webserver?

Kind Regards - Mike Brunt
Macromedia Consulting
Tel 562.243.6255
Fax 401.696.4335
http://www.allaire.com/services/consulting/


-Original Message-
From: Russ Conway [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 9:48 AM
To: CF-Talk
Subject: CF Using 90-100% of processor time (911!)


My server developed a problem today. CFServer.exe is using almost all of the
available processing time. I've tried stopping and starting the services and
the NT box, but as soon as I start CF again it almost immediately grabs all
of the processor time.

I'm running NT and CF 4.01. We've had this application up and running for a
little over a year now and have only started having this problem today. I'd
greatly appreciate any suggestions, since this has my Web site running at a
crawl.

TIA!

Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www.hallofsports.com
... . . where the legends live on
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Order of Display/Page Rendering Question

[Ricq Pattay]

You can sidestep the "top down" issue by using JavaScript to cycle through a
series of images, creating the illusion of an animated image, instead of
using an animated GIF. GIF animation seems to start only once the page is
finished loading.

E-mail me if interested in some code (kinda lengthy to post to the list).


- Original Message -
From: "Les Mizzell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 10:37 AM
Subject: Order of Display/Page Rendering Question


> I have a page that was originally ASP that I've converted over to CF.
This
> was a "Find a Rep near you" type search that has a huge database behind it
> (eight different countries) - so the search could take up to 10 or 15
> seconds.
>
> On the ASP version, so the user wouldn't get too bored during the process,
> I placed a small "Progress Indicator" animated gif on the page that
> displayed until the search results came up.
>
> On the CF page, I've got my chuck of HTML code with the "Progress Gif"
FIRST
> on the page, before any of the CF code that searches the database and
> displays the results. However, the CF pages refuses to display the page at
> all until the search is complete, leaving you enough time to go refresh
your
> cup of coffee after you click "Submit" on the "Find Your Rep" form on the
> initial search page.
>
> So, Cold Fusion doesn't display a page "top down"? Any way to get the
search
> to run in the background so you can still stare at the "Progress Gif"
while
> you wait on the results to come up?
>
> Thanks!
>
> --
> Les Mizzell
> 
> Who Needs Intel?
> ATHLON INSIDE!
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF Using 90-100% of processor time (911!)

[Bruce Holm]

This sounds like a similar problem we had but on a Unix server.
The culprit was Client Variables.  We were not using them but had them
"enabled".  It filled up our registry file (8Mb).  So check your registry
file located in the coldfusion directory.  If it's big that's a clue.  To
clean it out, remove client variable entries in it.  Also disable client
variables in the Application.cfm file (CFAPPLICATION tag) unless you are
using them, then switch to writing the client variables into a database
instead of the registry file.

Hope this helps.  It did for us.  Do nothing and your site will get
gridlocked for sure.

Bruce

- Original Message -
From: "Russ Conway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 9:48 AM
Subject: CF Using 90-100% of processor time (911!)


> My server developed a problem today. CFServer.exe is using almost all of
the
> available processing time. I've tried stopping and starting the services
and
> the NT box, but as soon as I start CF again it almost immediately grabs
all
> of the processor time.
>
> I'm running NT and CF 4.01. We've had this application up and running for
a
> little over a year now and have only started having this problem today.
I'd
> greatly appreciate any suggestions, since this has my Web site running at
a
> crawl.
>
> TIA!
>
> Russell Conway
> HallofSports.com, Inc.
> 351 West 22nd Street
> New York, NY 10011
> P (646) 638-2500
> F (646) 638-3444
> http://www.hallofsports.com
> .. . . where the legends live on
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CF Using 90-100% of processor time (911!)

[Russ Conway]

My server developed a problem today. CFServer.exe is using almost all of the
available processing time. I've tried stopping and starting the services and
the NT box, but as soon as I start CF again it almost immediately grabs all
of the processor time.

I'm running NT and CF 4.01. We've had this application up and running for a
little over a year now and have only started having this problem today. I'd
greatly appreciate any suggestions, since this has my Web site running at a
crawl.

TIA!

Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www.hallofsports.com
.. . . where the legends live on


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

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

RE: Order of Display/Page Rendering Question

[Garza, Jeff]

Les,

CF, under the 4.5 engine, renders the entire page before sending it to the
client.  Currently there is no response.flush capability.  You'll have to
wait for CF 5.0 for this functionality.  The  tag will allow for
this.  Check out the CF Beta site at http://beta.allaire.com for more
details  (you'll have to register to access the info and the binaries).

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

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



-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 16, 2001 8:38 AM
To: CF-Talk
Subject: Order of Display/Page Rendering Question


I have a page that was originally ASP that I've converted over to CF.  This
was a "Find a Rep near you" type search that has a huge database behind it
(eight different countries) - so the search could take up to 10 or 15
seconds.

On the ASP version, so the user wouldn't get too bored during the process,
I placed a small "Progress Indicator" animated gif on the page that
displayed until the search results came up.

On the CF page, I've got my chuck of HTML code with the "Progress Gif" FIRST
on the page, before any of the CF code that searches the database and
displays the results. However, the CF pages refuses to display the page at
all until the search is complete, leaving you enough time to go refresh your
cup of coffee after you click "Submit" on the "Find Your Rep" form on the
initial search page.

So, Cold Fusion doesn't display a page "top down"? Any way to get the search
to run in the background so you can still stare at the "Progress Gif" while
you wait on the results to come up?

Thanks!

--
Les Mizzell

Who Needs Intel?
ATHLON INSIDE!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Order of Display/Page Rendering Question

[Terry Bader]

there will be a flush tag in CF5 that will allow you to do that... 
what you will have to do then is use JS to open a new window with the
indicator and then close it once the search is complete


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Les Mizzell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 11:38 AM
> To: CF-Talk
> Subject: Order of Display/Page Rendering Question
> 
> 
> I have a page that was originally ASP that I've converted 
> over to CF.  This
> was a "Find a Rep near you" type search that has a huge 
> database behind it
> (eight different countries) - so the search could take up to 10 or 15
> seconds.
> 
> On the ASP version, so the user wouldn't get too bored during 
> the process,
> I placed a small "Progress Indicator" animated gif on the page that
> displayed until the search results came up.
> 
> On the CF page, I've got my chuck of HTML code with the 
> "Progress Gif" FIRST
> on the page, before any of the CF code that searches the database and
> displays the results. However, the CF pages refuses to 
> display the page at
> all until the search is complete, leaving you enough time to 
> go refresh your
> cup of coffee after you click "Submit" on the "Find Your Rep" 
> form on the
> initial search page.
> 
> So, Cold Fusion doesn't display a page "top down"? Any way to 
> get the search
> to run in the background so you can still stare at the 
> "Progress Gif" while
> you wait on the results to come up?
> 
> Thanks!
> 
> --
> Les Mizzell
> 
> Who Needs Intel?
> ATHLON INSIDE!
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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