RE: QueryNew - order by

2002-02-11 Thread Herbener, Martin - School Information Technology

A couple on Macromedia's dev ex:

http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA3470F8-283
0-11D4
-AA9700508B94F380&method=Full

http://devex.macromedia.com/developer/gallery/info.cfm?ID=44C48F77-35E
9-11D4
-83D700508B94F85A&method=Full

http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347619-283
0-11D4
-AA9700508B94F380&method=Full

The first is Nate Weiss', the second is mine based on his (some 
additional
features and a CFX instead of CFML); they both work for me.  I haven't 
tried
the third one.

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 10:38 PM
> To: CF-Talk
> Subject: RE: QueryNew - order by
> 
> 
> > Quick question, I am creating a query with QueryNew ... is 
> > there anyway to do an order by type action to a CF created 
> > query? (I do not want to use a Query of Queries... I need 
> > something supported for v4.5 +
> 
> Not directly, but there's nothing to stop you from reordering 
> it yourself
> (you could do this with any query, not just ones created with 
> QueryNew,
> though). You'd have to build your own sort routine, which 
> would loop through
> the query object and "reorder" rows. You'd probably want to have your
> routine build a new query object.
> 
> I wouldn't be surprised if there was a custom tag available for this
> already, but if there isn't, it shouldn't take more than a 
> few minutes to
> write, I'd guess.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Oracle Error

2002-02-07 Thread Herbener, Martin - School Information Technology

See if you can get the networking people to configure the firewall to log
all traffic, both allowed and disallowed, from the CF server to the Oracle
db, for a period of time that includes success and CF errors; that is likely
to show something interesting.  Without specific configuration, the Oracle
client on the CF server may try to use different ports on the server side,
which could confuse the firewall or be rejected.

> -Original Message-
> From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 10:58 AM
> To: CF-Talk
> Subject: Oracle Error
> 
> 
> Hi everyone,
> I keep getting these weird errors with Oracle 8i that of 
> course are being
> blamed on ColdFusion. Here goes.
> Our webserver sits in the DMZ and our database server is  inside the
> firewall. All traffic going from the webserver goes through 
> the firewall to
> talk to the database.
> I seem to be able to access the database through coldfusion 
> 90% of the time,
> but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to
> connect to destination error, both of which result in massive 
> errors in the
> application and the eventual rebooting of the machine.
> I am thinking it may be a network issue, but because 
> coldfusion is new to
> this company they want to blame it. If I log in with sql+ (an 
> oracle client)
> I can access the datasource w/o trouble, although cf can't 
> even verify the
> datasource. This usually happens after several moderate hits to the
> datasource.
> We are running CF 4.5.2 with all the appropriate patches 
> applied on a Compaq
> Windows 2000 machine with all the appropriate service packs applied to
> Win2K. Our database is Oracle 8i - anyone have some suggestions? 
> Greatly appreciated! 
> Debbie M.
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFSERVER and security

2002-02-07 Thread Herbener, Martin - School Information Technology

I currently run CF with a non-system account.

a) breaking current applications is certainly an issue.  I have figured 
out
how to set permissions that work for me (documented at
http://www.defusion.com/articles/index.cfm?ArticleID=89) but, 
depending on
what databases and other components you use you may have to experiment.

b) new security holes: I regard using a non-system account as an 
overall
security improvement, because someone who gets control of CF doesn't
necessarily get control of the box.  However, someone who gets control 
of CF
may, in a non-system account situation, get some sort of access to 
other
machines.  Exactly what access they obtain depends on how you set up 
the
account.

> -Original Message-
> From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 11:47 AM
> To: CF-Talk
> Subject: CFSERVER and security
> 
> 
> At 12:48 PM 5/8/2001 -0400, you wrote:
> 
> >Is this "T:" drive physically on your server, or is it on 
> another server? If
> >it is on another server, the CF Service must be run in the 
> context of a user
> >that would have access to that other server. Just because 
> you can see the
> >drive share doesn't mean CF can.
> 
> This response was originally part of a discussion on 
> accessing files using 
> cffile, and the need to run cfserver under a user account as 
> opposed to the 
> system account.
> 
> I'm concerned with the ramifications of running cfserver as a 
> user account 
> as opposed to the system account.  Are there security issues 
> that don't 
> exist when it's run under the system account ?  We've got a 
> pretty heavily 
> used existing live box that has been running cfserver under 
> the system 
> account.  I'm concerned about A:breaking existing applications and 
> B:creating security holes that didn't exist before.
> 
> Any advice would be appreciated.
> 
> 
> Brian L. Wolfsohnhttp://www.cus.com
> CUS Business Systems Ft.Lauderdale,FL
> Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED]
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Session Swapping" incident

2002-01-28 Thread Herbener, Martin - School Information Technology

While locking is a good thing, I don't think the fact that your locks are
clean (or not) necessarily has anything to do with session swapping, and I
doubt that single-threading sessions would help.  I would expect session
swapping to happen if a browser started submitting requests with the wrong
CFID/CFTOKEN combo; obviously it is possible the CF loses track of which
data goes with which session, but that seems unlikely (I'd think we'd have a
deafening chorus of complaints). These are some of the things I would
pursue:

1) is the user starting their session with the 'right' info and then
suddenly getting 'wrong' info?  Perhaps the initial retrieval of user
profile data is doing something wrong.

2) Do you have, or can you start to collect, logs that track 
form fields
url vars
cookies
for every page request (perhaps just for the network that the user is in)?
(I have some code to do this at the CF level if needed)

3) Can you get the user to report exactly where he was in the application
when the problem appeared such that you can correlate it with your logs?
Then, can you see what's happening to the CFID/CFTOKEN values sent to your
server at that point?

If this happens to users on one particular network, but not other people, I
would wonder about proxies/firewalls at that site.

> -Original Message-
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 28, 2002 10:26 AM
> To: CF-Talk
> Subject: RE: Session Swapping" incident
> 
> 
> This is interesting.  I had a nightmare with Session 
> variables where I 
> was
> adamant that I had locked properly but was still getting session 
> variables
> expiring or swapping of sessions...for this reason I always use client
> variables
> 
> -Original Message-
> From: Chris Bohill [mailto:[EMAIL PROTECTED]]
> Sent: 28 January 2002 15:04
> To: CF-Talk
> Subject: Session Swapping" incident
> 
> 
> We are developing an web based application, and have recently been 
> experiencing a number of "Session swapping" incidents. On two 
> occasions 
> 
> a user has been navigating the system, only to "Swap" sessions with 
> another user, who (we are not 100% sure) may also be viewing the site 
> at 
> the same time. 
> 
> Because a lot of the site is user-profile based, the user can tell 
> straight away that they have "Swapped". The user in question returned 
> to 
> the welcome page, but another users name and details were there. This 
> other user was in the same building but different floors, so they may 
> have been on the same network.
> 
> For this to happen is pretty awkward, as much of the data is of a 
> sensitive nature, but we feel we have done as much as we can 
> to reduce 
> the chance of this happening.
> 
> We have locked all session variables and only refer to them as local 
> variables on pages that need them. see below:
> 
> 
> 
> 
> 
> 
> When writing to a Session Variable we again use cflock, with type set 
> to 
> "Exclusive".
> 
> All Session variables are locked when created on the 
> Application page, 
> and are set to "Exclusive".
> 
> When the user logs out of the system we use the following 
> code to kill 
> all the session variables:
> 
>  scope="SESSION">
>   
>   
> 
> 
> StructDelete(Session, "VarOne");
> StructDelete(Session, "VarTwo");
> StructClear(Session);
> 
> 
> 
> Are there known issues with session variables or is there something 
> vital that we are missing? 
> Is there something we should be doing on the Administrator to protect 
> "session swapping"? 
> 
> For this to happen, even once is not acceptable to our 
> client, so it is 
> 
> essential that we resolve this issue. Speed is an important 
> issue with 
> this application so using single thread sessions would not be a 
> straightforward solution for us.
> 
> Any responses would be greatly appreciated.
> 
> Thanks,
> 
> 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFContent and mapped drives?

2002-01-25 Thread Herbener, Martin - School Information Technology

You're correct that it's not the CV user; instead you need to replace 
the
default iis anonymous account with one that has access to the remote
machine.  There's some info here:
http://www.defusion.com/articles/index.cfm?ArticleID=89 on what's 
involved.

> -Original Message-
> From: DDB Lists [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 25, 2002 2:27 PM
> To: CF-Talk
> Subject: Re: CFContent and mapped drives?
> 
> 
> Even though you can get the cold fusion server to access 
> files on a shared
> drive, by running cold fusion in an administrator account or 
> some other
> user, this does not help for cfcontent because cfcontent runs 
> in the context
> of the stub, in other words, it runs as the iis user and it 
> is a lot more
> difficult to get it to access files on a share.
> 
> - Original Message -
> From: "Andrew Peterson" <[EMAIL PROTECTED]>
> > Because CFContent is billed as having the ability to serve up files
> located
> > in non-web-accessible folders, I took that to mean that I 
> could map to
> > another server from my web server and serve files located there.
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



changing CFID/CFTOKEN

2002-01-24 Thread Herbener, Martin - School Information Technology

I'm using ColdFusion client variables and would like to have the
CFID/CFTOKEN values change periodically during a user "session" in order to
reduce the chances that, if they were intercepted, they could be used to
impersonate a user.  Has anyone figured out a way to do that?

thanks


Martin Herbener
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Multiple sites...

2002-01-16 Thread Herbener, Martin - School Information Technology

I can't agree that it does a great job.  It's adequate, but it would it
would be better if there could be multiple instances of the CF engine 
so,
for instance, one application's badly-locked code didn't hurt another
application.  It would also permit tuning the server settings for the 
needs
of each application.  For instance, Les might like his development site 
to
do full checking for shared-scope locks while his production site does 
none.


> -Original Message-
> From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 16, 2002 2:11 PM
> To: CF-Talk
> Subject: RE: Multiple sites...
> 
> 
> Les,
> 
> I can say that CF does a great job of running multiple sites. 
>  The key,
> that has already been mentioned is to use relative paths for your
> CFINCLUDEs.  We have a dozen IIS sites and essentially 50 others 
sites
> in subdirectories under one of those and they all work absolutely 
fine
> without using CF mappings, though it is there if you wanted it.
> 
> I don't think using relative paths is the lesser of an evil.  It's
> simply how CF does it's thing when you need to run more than one 
site.
> 
> As far as future support, I haven't seen anything added or planned 
for
> adding in future releases, I guess because most people seem to get it
> working with the methods already available.
> 
> Just my $0.02
> 
> t
> 
> Tyler M. Fitch
> Certified Advanced ColdFusion 5 Developer
> 
> http://isitedesign.com
> 
> 
> 
> -Original Message-
> From: Les Buchanan [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, January 16, 2002 10:52 AM
> To: CF-Talk
> Subject: RE: Multiple sites...
> 
> 
> Hmmm...  Thanks for all the help everyone...
> 
> I guess I'll just have to decide the lesser of the two "evils".  =)
> 
> I'm surprised that ColdFusion server doesn't have a way to handle
> multiple sites.  Does anyone know if there is going to be any support
> for this in future editions?
> 
> Thanks again everyone!
> 
> ---Les Buchanan
> 
> 
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How do I handle Large Record Sets from the DB? (o8i)

2001-12-26 Thread Herbener, Martin - School Information Technology

Caching the query with CF's built-in caching may be more reasonable 
than you
think; with 4.5.1 SP2 the limit of queries is not 100 and apparently is
limited only by available memory.  I think it's the easiest method to
implement though, of course, you don't have as much control.

> -Original Message-
> From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 23, 2001 4:57 AM
> To: CF-Talk
> Subject: Re: How do I handle Large Record Sets from the DB? (o8i)
> 
> 
> At 07:34 PM 12/21/01 -0500, you wrote:
> >All,
> >
> >This is what our environment looks like:
> >Microsoft IIS5 on Windows2000
> >ColdFusion (4.5.1 SP2) Enterprise Edition
> >Oracle8i (8.1.7)
> >Utilizing the Oracle Native Driver.
> >
> >The Task at hand:
> >Users will be quering the database and in some cases receiving back
> >large recordsets.
> >These large recordsets could be from 0 to 3,000 maybe 4,000.
> >If the recordset exceeds 20 records, it will be broken up 
> into pages of
> >20 (20 results per page)
> >
> >Does anyone have any thoughts about the best way to go about this?
> >
> >Here are some possible solutions that I have thought of:
> >
> >Solution 1:  I could use  to query the database and 
> cache the
> >query in server memory.
> >
> >Possible problems with this solution:  The CF Server can 
> only cache 100
> >resultsets at one time.  After that, the oldest ones get 
> bumped out of
> >the CF Server's memory.  If the result set gets bumped out of 
memory,
> >then the database has to be queried again and the data has 
> to go across
> >the network wire again.
> >
> >Solution 2:  Use  to call an Oracle Procedure.  The
> >Procedure would return 20 records at a time.  Have the 
> procedure store
> >the queried result set into a temp table for a period of 
> time.  Send 20
> >records to the CF Server.  Provide the CF Server a unique ID 
> to identify
> >the result set when the CF Server request the next 20 records.  The
> >Primary key of the result set table would be the combination of a
> >ResultSetID and RowNumber (rownum column from the original 
> result set in
> >Oracle8i).
> >
> >Possible problems to this solution:  During the initial 
> query, I have to
> >wait on the database to write the results to the temp table before
> >sending the first 20 results to the CF Server.  The first 20 
> record talk
> >longer to get.  The temp table grows unless we periodically 
> remove the
> >old record sets.
> 
> Solution 3: Store the query in the session scope. Whether or 
> not you can do 
> this will depend on how many users will be on the system and how much 

> memory the system has, but it does solve some of the problems you've 
> mentioned. It requires only one trip to the database, it will 
> be easy to 
> manage the record display, and it times out according to 
> usage instead of 
> on a time-limit or when there are too many recordsets. If 
> memory is going 
> to be an issue, you might want to store the search query but 
> not the data 
> for the details page.
> 
> 
> Now available in a San Francisco Bay Area near you!
> http://www.blivit.org/mr_urc/index.cfm
> http://www.blivit.org/mr_urc/resume.cfm
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfx Spell Check Tags

2001-12-21 Thread Herbener, Martin - School Information Technology

The other downside of CFX_Spell is that it stores the dictionary in 
files on
the local server, so in a cluster environment you'd have to work to 
keep the
dictionaries in sync (assuming you allow user additions).  But I agree 
that
(as long as you exclusive-lock access to it) it's reliable.

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 21, 2001 9:00 AM
> To: CF-Talk
> Subject: RE: cfx Spell Check Tags
> 
> 
> > Has anyone had experience with either ActivSpellCheck from 
> > CFDev.com or Ben Forta's cfx_spell? I wanted any available 
> > feedback on either of the products: stability, dictionary 
> > quality/size, UI issues.
> 
> We've used CFX_Spell in the past, and it works well enough, 
> except that it
> requires single-threaded access. There isn't much of a UI 
> with any of these
> things, because they're server-side, so you get to build your 
> own UI. We
> built a popup-window interface for CFX_Spell, which I'd guess 
> is available
> from the Fig Leaf site in the CFUG Meeting Notes section.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Session variables on clustered servers?

2001-12-20 Thread Herbener, Martin - School Information Technology

Session variables CANNOT span servers.  CF 4.5 clustercats can do 
"sticky"
sessions, which means that the first server the user hits is the one 
they
use for the duration of their visit (I'm not sure if this is done via 
cookie
or URL), and therefore you can use session variables since the user 
will be
sticking with one server.  This, of course, doesn't work if the server 
goes
away.

Client, form and cookie variables seem to be the accepted means for 
state
maintenance in clustercats clusters.  I have used client variables and 
am
pretty happy with them.

> -Original Message-
> From: Shawn Grover [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 11:52 AM
> To: CF-Talk
> Subject: Session variables on clustered servers?
> 
> 
> I know Sessions variables can span a cluster, but am not sure of the
> details/gotchas.
> 
> My experience with clusters is non-existent, but it looks 
> like I'm going to
> be getting a crash course soon.  So, I need to know some details for
> ensuring my sites work well over a cluster.  I'm assuming the 
> cluster will
> be using CF5's clustering capabilities. (well, I know CF4.5 
> did it, and
> assume CF5 does as well).
> 
> Are session variables a reasonable option on a cluster? or 
> should I be using
> Client variables with a DSN for storage?  Are there any 
> gotcha's I need to
> be aware of with regards to the Session varibles?  
> 
> Thanks for any tips/suggestions.
> 
> 

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF and Time

2001-12-19 Thread Herbener, Martin - School Information Technology

And the timestamp field does not contain a date/time value, it's more like a
auto-incrementing number.

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 4:46 PM
> To: CF-Talk
> Subject: RE: CF and Time
> 
> 
> right.  that's what we're saying.  use datetime as the data 
> type on the
> fields.  timestamp CAN only be used in one place.  datetime as many as
> you like.
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 4:36 PM
> To: CF-Talk
> Subject: RE: CF and Time
> 
> 
> Yeah I get an error when tyring to save the tale, it says 
> timestamp can
> only
> be used in one column. :-(
> 
> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, December 19, 2001 4:28 PM
> To: CF-Talk
> Subject: RE: CF and Time
> 
> 
> that's strange.  do you get an error when you try to assign more than
> one?
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 4:21 PM
> To: CF-Talk
> Subject: RE: CF and Time
> 
> 
> H,
> But what if I want to send in 4 different times that are all being
> stored in
> the DB.. I am unable to use the datetime data type for all of the
> columns?
> 
> 
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, December 19, 2001 4:22 PM
> To: CF-Talk
> Subject: Re: CF and Time
> 
> 
> The timestamp datatype is an automatic timestamp for the record. That
> doesn't  mean you cant have more than one timestamp though. You just
> have to
> do it manually.
> 
> Create a column with a datetime datatype and set the default value to:
> getDate()
> Now when the record is created the default value will be a date/time
> stamp.
> When you want to update the time stamp just set the value to getDate()
> again.
> 
> jon
> - Original Message -
> From: "Tangorre, Michael T." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 19, 2001 4:00 PM
> Subject: RE: CF and Time
> 
> 
> > Why can a SQL server Db table only contain one field of type
> > timestamp? I am not al that familiar with DBs yet. :-(
> >
> > Mike
> >
> >
> > -Original Message-
> > From: Bryan Love [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 19, 2001 3:45 PM
> > To: CF-Talk
> > Subject: RE: CF and Time
> >
> >
> > use timestamps.  Timestamps are more versatile that 
> varchars since you
> 
> > can do math calculations with them.  Depending on your gui 
> layout you
> > may also
> > be better off storing a start time and a duration rather 
> than a start
> > and
> > end time.
> >
> > Definitely use Timestamps - you'll thank yourself later 
> when you write
> 
> > the queries!
> >
> > +---+
> > Bryan Love
> >   Macromedia Certified Professional
> >   Internet Application Developer
> >   Database Analyst
> > Telecomunication Systems
> > [EMAIL PROTECTED]
> > +---+
> >
> > "...'If there must be trouble, let it be in my day, that my 
> child may
> > have peace'..."
> > - Thomas Paine, The American Crisis
> >
> >
> >
> > -Original Message-
> > From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 19, 2001 12:35 PM
> > To: CF-Talk
> > Subject: CF and Time
> >
> >
> > Hi everyone.
> >
> > I am looking for the best way and data type (SQL) to store 
> a employees
> 
> > schedule. I have a form in which they enter a start time and an end
> > time. Should I
> > store these as Timestamps in SQL Server or use varchar...
> > And what about AM and PM?  Any ideas would be much appreciated.
> >
> > Mike
> >
> >
> > Michael T. Tangorre
> > 
> 
> > Resident Assistant - Brick
> > Web Applications Developer
> > A.U. Webteam Slave  :-)
> > AIM: CrazyFlash4==
> >
> >
> >
> > 
> 
> 
> 
> 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists