Chr(9)
---
Billy Cravens
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 11:56 AM
To: CF-Talk
Subject: Quick question...
Anyone remember the CHR code for a tab? I'm having a senior moment and
I'm
not event 35 yet...
Portent Interactive
Helpi
oi Ian!!
9
--
Critz
Certified Adv. ColdFusion Developer
Crit[s2k] -
Wednesday, May 1, 2002, 12:56:16 PM, you wrote:
IL> Anyone remember the CHR code for a tab? I'm having a senior moment and I'm
IL> not event 35 yet...
IL> Portent Interactive
IL> Helpin
char 9
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
"...'If there must be trouble, let it be in my
I believe it's 9 (chr(9))
- Original Message -
From: "Ian Lurie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 11:56 AM
Subject: Quick question...
> Anyone remember the CHR code for a tab? I'm having a senior moment and I'm
> not event 35 yet...
>
>
9
On Wednesday, May 1, 2002, at 09:56 AM, Ian Lurie wrote:
> Anyone remember the CHR code for a tab? I'm having a senior moment and
> I'm
> not event 35 yet...
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measur
Hi Simon,
I am currently working on a similar project...
ick question
>What is the information in CGI.HTTP_USER_AGENT?
>For Netscape I get:
>Mozilla/4.08 [en] (Win98; U ;Nav)
>and for IE I get:
>Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
These values are provided by the browser and as s
800 x 600
-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:44 PM
To: CF-Talk
Subject: Quick Question
I hope that you'll permit me to ask a non cf question here. It is the only
list that I subscribe to and I know that all of the top web dev
no problem I'm still using 800 x 600 for my dimensions cause most
users(viewers) don't set it any higher then this.
Troy Montour
Vampires Inc
[EMAIL PROTECTED]
612.867.6831
763.586.0552
http://www.vampiresinc.com
- Original Message -
From: "ehoma" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAI
We design for 800x600.
Some people I know still set the computers to 640x480 - but only one or
two more a limitation of their hardware than anything. But, the
accepted norm is 800x600.
-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 2:4
ehoma wrote:
> I hope that you'll permit me to ask a non cf question here. It is the only
> list that I subscribe to and I know that all of the top web developers are
> here.
>
> I'm having a debate with my boss. He likes to spend money and always has
> the latest gadgets. On his desk is a tw
have you checked that you can using the YALLA datasource you can see the
PeopleDirectory table? Just a simple select will confirm. It may be that
the table was created by a different user to the one used by the
datasource. If this is the case, you may need to refer to the table as
something li
Chris, I imagine you would have to specify the full filename - including the
extension. Be wary of using CFFILE, particularly if people can upload non
image files like documents or executables. Test your code to ensure that you
are not opening up a major vulnerability to your server. I have notice
no
but you could check the File.ClientFileExt variable if you think you are
having trouble
- Original Message -
From: "Chris Badouin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 3:39 PM
Subject: quick question
> All-
>
> Sorry, I have not used
actually it is best to unsubscribe then resubscribe
therefore no one will get your vacation message
when they POST to the list.
This would be for the consideration of all members
on the list.
To find out what is missed while you were unsubscribed,
simply look at the archives.
-Original M
Cheers !
Hope you have a good week whilst I am
away relaxing and drinking beer !
-Daz
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 14:46
To: CF-Talk
Subject: RE: Quick Question
actually it is best to unsubscribe then resubscribe
therefore no
800 x 600. Your boss is just too hip. Find a buncha ways to complimen
t him
on this and remind him regularly.
T
-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 1:44 PM
To: CF-Talk
Subject: Quick Question
I hope that you'll permit me to ask a
: Quick Question
800 x 600. Your boss is just too hip. Find a buncha ways to complimen
t him
on this and remind him regularly.
T
-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 1:44 PM
To: CF-Talk
Subject: Quick Question
I hope that you
Let him learn the hard way. Ask him if he wants sites designed to hi
s spec.
Then design all the sites with fixed-width tables with regards to his
monitor resolution, which is probably 1280x1024 or, if you need binoc
ulars,
1600x1200 +. Then when people complain, blame it on your boss and te
ll
r 19, 2001 3:12 PM
To: CF-Talk
Subject: RE: Quick Question
Keep in mind too that out of the box, most computers are set to 800x600 and
the average user does not know, or care about how to change his resolution.
Dan
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Wedn
Yup. 800x600
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
"...'If there must be trouble, let it b
ED]>
Sent: Wednesday, December 19, 2001 5:12 PM
Subject: RE: Quick Question
> Keep in mind too that out of the box, most computers are set to 800x600
and
> the average user does not know, or care about how to change his
resolution.
>
> Dan
>
> -Original Message-
>
How did you grab that info?
-Original Message-
From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:46 PM
To: CF-Talk
Subject: Re: Quick Question
Yesterday's log from a commercial site I've done:
Resolution Page views
Hitometer
- Original Message -
From: "Tangorre, Michael T." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 5:45 PM
Subject: RE: Quick Question
> How did you grab that info?
>
>
> -Original Messag
; -Original Message-
> From: Tony Gruen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 5:10 PM
> To: CF-Talk
> Subject: RE: Quick Question
>
>
> 800 x 600. Your boss is just too hip. Find a buncha ways to complimen
> t him
> on this and rem
> From: Tony Gruen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 5:10 PM
> To: CF-Talk
> Subject: RE: Quick Question
>
>
> 800 x 600. Your boss is just too hip. Find a buncha ways to complimen
> t him
> on this and remind him regularly.
>
> T
&
800 x 600 still.
-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2001 21:44
To: CF-Talk
Subject: Quick Question
I hope that you'll permit me to ask a non cf question here. It is the only
list that I subscribe to and I know that all of the top web developers
g and
use percents instead to make things resize... looks great on his monitor
when you get a paragraph in 2 lines of text :)
-paris
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 04:38
To: CF-Talk
Subject: RE: Quick Question
800 x 600
It's part of the encrytion. Consider - if we just stored your username
in a cookie - you could become someone else by changing your cookie. If
we just encrypted the username, it wouldn't be as secure.
I didn't design loginuser - but I'm pretty sure that is the reason why.
===
depends how they are stored:
Memory: Memory dependand
Database: Hard Drive Space
Registry: Memory
Did I forget anything!
-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 5:34 PM
To: CF-Talk
Subject: Quick Question - Size Limit?
is there a
HAHAHAH
HAI RUDY
SIZE LIMIT IS 255 CHARS FOR CLIENT V
THANX
RAMESH
-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 2:34 PM
To: CF-Talk
Subject: Quick Question - Size Limit?
is there a size limit for client, application and session?
if
Whoops! :-)
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 6:37 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?
HAHAHAH
HAI RUDY
SIZE LIMIT IS 255 CHARS FOR CLIENT V
THANX
RAMESH
-Original Message-
From: Rudy Rustam
:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 7:34 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?
Whoops! :-)
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 6:37 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?
HAHAHAH
sage never goes down
from 100% (at the end, i have to restart).
come on guys, give it a try!
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 4:40 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?
Actually no whoops!
I read it again.
length of the variable has no such limit as 255 chars
It works with even 1 million char.
(even though u would never need this kind in most of the situvations)
Archives: http://www.mail-archive.com/cf-
space!
regards
Andrew Scott
Senior Cold Fusion Application Developer
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 30 October 2000 20:40
To: CF-Talk
Subject: RE: Quick Question - Size Limit?
I'm re
> Is MM UltraDev Studio, just CF studio with a new name?
Not exactly. It's a bundle containing CF Studio and Macromedia Ultradev,
which is a visual editor.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
hi
mm ultradev studio is a box containing cf studio 4.5 + mm ultradev 4.
ultradev is 'the original macromedia' app for creating cf/asp/jsp
applications in a visual environment, not having to do any hand coding.
or as i prefer to put it: ultradev is dreamweaver on steroids, since it
really is a com
Hope that helps!
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Brian Eckerman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 10:05 AM
Subject: Quick question on custom tags
> Is it possible to call a custom tag that resides in a folde
Unless it's in the global custom tags directory, no.
The only other way is to call it via tag.
On Thu, 30 May 2002, Brian Eckerman wrote:
> Is it possible to call a custom tag that resides in a folder other than
> the current folder.
>
> I am using but I would like to have one copy
> residi
- Original Message -
From: Brian Eckerman
To: CF-Talk
Sent: Thursday, May 30, 2002 11:05 AM
Subject: Quick question on custom tags
Is it possible to call a custom tag that resides in a folder other than
the current folder.
I am using but I would like to have one copy
Put it in your custom tags directory on your server or use cfmodule.
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:05 AM
To: CF-Talk
Subject: Quick question on custom tags
Is it possible to call a custom tag that resides in a folder o
> Is it possible to call a custom tag that resides in a folder
> other than
> the current folder.
>
> I am using but I would like to
> have one copy
> residing in a "commonfiles" folder at root.
> This would take something like <../cf_cf_formurl2attributes>
> right? It doesn't seem to work.
You
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:05 AM
To: CF-Talk
Subject: Quick question on custom tags
Is it possible to call a custom tag that reside
Use to call it.Regards,
Eric J. Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 10:05 AM
To: CF-Talk
Subject: Quick question on custom tags
I
02 11:12 AM
To: CF-Talk
Subject: RE: Quick question on custom tags
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:05 AM
To: CF-Talk
Subject: Quick questi
Brian,
>
> I am using but I would like to have one copy
> residing in a "commonfiles" folder at root.
> This would take something like <../cf_cf_formurl2attributes> right? It
> doesn't seem to work.
>
If you've only got one copy of the tag in your custom tags directory,
regardless of what sub
ssage-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:14 AM
To: CF-Talk
Subject: RE: Quick question on custom tags
Use to call it.Regards,
Eric J. Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)
-Original Me
>
> If you have more than one copy then name="commonfiles.formurl2attributes"> will do the trick...
>
Whoops... meant to say...
where commonfiles is the directory under CustomTags where the file
formurl2attributes.cfm lives.
You can have multiple levels of directories by adding them with dot
2 639 68 70
Fax: +32 2 639 68 99
Email: [EMAIL PROTECTED]
Web: www.lrt.be
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: donderdag 30 mei 2002 17:47
To: CF-Talk
Subject: RE: Quick question on custom tags
One problem with cfmodule is that you cannot take advantage
o: CF-Talk
Subject: RE: Quick question on custom tags
This is not true. You can perfectly use the ThisTag scope with cfmodule.
In fact, I do it all the time. You have to be carefull with nesting
s.
Pascal Peters
Certified ColdFusion Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av.
ng
> for a file called MyCustomTag.cfm.
> If you have 2 tags with the same name it will use the first one it finds
> (you will see warnings about this in one of the server logs).
>
>
>
> -Original Message-
> From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
> Sent: T
> you're right, I just poorly phrased my answer. What I meant
> was that you lose the ability to take action between the start
> and end execution modes. Because I don't think when you call
> cfmodule there is an end execution mode.
That's not correct either, though. You have an end execution
ECTED]]
Sent: Thursday, May 30, 2002 12:27 PM
To: CF-Talk
Subject: Re: Quick question on custom tags
Rob,
You are incorrect, you can use the start stop ... Blah Blah works just fine with the
execution modes.
Paul Giesenhagen
QuillDesign
> One problem with cfmodule is that you cannot take a
> What happens if in my custom tag I call another
> ? Will the parser barf?
The only situation where you might have a problem is when you convert
something like this to CFMODULE:
Of course, if you do this:
then CF will think that the closing CFMODULE goes with the second openi
> Ah, thanks guys. I wasn't aware you could have
> tag. Good to know.
>
> One question, and maybe this is what Pascal meant in his
> original reply.
> What happens if in my custom tag I call another
> ?
> Will the parser barf?
Nah, it works happily - in fact, http://www.fusionauthority.com
u have 2 tags with the same name it will use the first one it finds
> (you will see warnings about this in one of the server logs).
>
>
>
> -Original Message-
> From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 11:14 AM
> To: CF-Ta
tionality when using
> cfmodule.
>
>
>
>
>
>
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 11:57 AM
> To: CF-Talk
> Subject: RE: Quick question on custom tags
>
>
> This is not true. Y
12:54 PM
To: CF-Talk
Subject: RE: Quick question on custom tags
Nah, it works happily - in fact, http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/in
EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 12:54 PM
> To: CF-Talk
> Subject: RE: Quick question on custom tags
>
>
> Nah, it works happily - in fact, should work better for you
>
> Philip Arnold
> Technical Director
> Certified ColdFusion Developer
> ASP
I Just gotta say you guys are amazing, I just now checked back to see if
there were any replies and was overwhelmed.
Needless to say you answered my question and then-some. If any of you
were in Archbold I'd buy you a Beer.
p.s. Sorry about getting sappy, but free-flow of information brings a
te
> Are there any internal implemenation details which make
> cfmodule faster than the cf_ syntax, or was this what you
> were refering to? Just curious...
CFMODULE naturally runs faster than CF_, it's to do with the way it's
calling the custom tag
There are general issues with using CF_ and the s
t; Sent: Thursday, May 30, 2002 1:17 PM
> To: CF-Talk
> Subject: RE: Quick question on custom tags
>
>
> Actually, you can..
>
>
> blah blah
>
>
> Works well.
>
>
> On Thu, 30 May 2002, Rob Baxter wrote:
>
> > One problem with cfmodule is th
> From: Jeff Small
>
> In Dreamweaver, using the Insertion Wizard, if I want to
> insert a hidden "datesubmitted" field and use #Now()# and the
> database is SQLServer, which option do I want to select in
> the "Submit As" dropdown? "Date" or "Date MS Access"?
>
> It's just a nagging question
> If you're using SQL Server, don't pass the date from CF, get SQL Server
> to insert the data itself
>
> INSERT INTO table (dateField)
> VALUES (getDate())
Well, that's pretty cool...I've just been using #Now()#...I always forget to
let SQL do all the work...sigh...
But still, what's the differe
22 AM
To: CF-Talk
Subject: Re: Quick Question about inserting dates...
> If you're using SQL Server, don't pass the date from CF, get SQL
> Server to insert the data itself
>
> INSERT INTO table (dateField)
> VALUES (getDate())
Well, that's pretty cool...I've j
You need to use _javascript_ in order for this to work. I think it is
something like or
place it inside href="">
document.yourFormName.yourTextAreaName.focus();" I am not an expert in JS
but that should do the trick.
TK
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
newstring = left( string,( len( string ) - 2 ) )
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 11:24 AM
To: CF-Talk
Subject: Quick question- get rid of 1st 2 characters
I know I know this, yet the answer isn't coming immediately...
I just nee
Sorry, brain fart, it's:
newstring = right( string,( len( string ) - 2 ) )
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 11:24 AM
To: CF-Talk
Subject: Quick question- get rid of 1st 2 characters
I know I know this, yet the answer isn't comin
Thanks
-Original Message-
From: Bill Henderson [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 2:53 PM
To: CF-Talk
Subject: RE: Quick question- get rid of 1st 2 characters
Sorry, brain fart, it's:
newstring = right( string,( len( string ) - 2 ) )
-Original Message-
Treat the string as a list with "\" as a delimiter and you can manipulate it
how you want.
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 17, 2003 4:04 PM
> To: CF-Talk
> Subject: Quick Question...stripping out part of the Template Path
>
>
> How do mos
on 3/17/03 4:35 PM, Everett, Al at [EMAIL PROTECTED] wrote:
> Treat the string as a list with "\" as a delimiter and you can manipulate it
> how you want.
>
Nice, that's kinda sweet. Worked like a charm.
~|
Archives: http://www
I'd say not. Microsoft have an army of software developers, and an even
larger army of beta testers and usability testers. They test everything
going out within an inch of its life, with probably the biggest testing and
debugging budget in history.
Yet my WinXPPro is updated about every second
m: "Mike Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 10, 2003 9:43 AM
Subject: RE: Quick question on the Technote: Known ColdFusion MX issues
> I'd say not. Microsoft have an army of software developers, and an even
> large
> On the page
> http://www.macromedia.com/support/coldfusion/ts/documents/tn18325.htm
> Is this a list of all errors being considered to be fixed
> w/the Red Sky update since the release CFMX Updater 3 or is a
> list of all errors since CFMX's initial release a year ago?
>
> CFMX seems pretty buggy
inds of systems, and trust me, CFMX is better than
the vast majority of systems I've seen released by far.
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11 June 2003 3:01 AM
To: CF-Ta
These are current issues not fixed in updater 3. There was a known database issue that
was fixed in updater 3 that prevented the installer for my cms from functioning on
cfmx until updater 3 was released. ( Some queries which didn't produce a recordset,
such as create or alter table statements w
> Use datetime datatypes with datediff/dateadd functions.
Will date time allow me to "insert" dates/times that are larger than 24
hours? I mean, no harm in trying, of course...
I was actually planning on taking advantage of datediff/dateadd, that's why
I was hoping a datetime datatype would suffi
@ this to make sense of what im trying to
explain
let me know...
tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:27 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> Use datetime datatypes
#x27;}
and you can dress that up with...
dateFormat() as you know im sure.
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:30 PM
To: CF-Talk
Subject: RE: Quick Question, RE: Datatype and future date/time calculation
use seconds
Jeff Small wrote:
> Let's say a table was going to contain "AllocatedTime" which would be the
> total time allocation for a task, say...an hour, possibly 8, maybe 16, maybe
> even a half hour or 45 minutes...you get it, a range of hours and minutes,
> and another table was going to contain separat
> so lets say start time was today, now().
>
>
>
> that will give you a value something like this
>
> 1080131574
>
> throw that into an integer column called beginTime
>
> and you can translate that back to a "human readable" date time like this
>
>
>
> which will return
>
> {ts '2004-03-24 1
no problem...let me know.
tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:19 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> so lets say start time was today, now().
>
>
>
> use seconds in an integer field...
> they are easier to work with
>
> using epoch time (01/01/1970 00:00:00.000)
>
> you can use that as a base, and do dateDiff's and dateAdd's using (now())
> or a date in the futureto get seconds in between two events...
>
> if you need more code to look
ack to the question whats the original goal/layout you are looking for?
you may have posted already, but a quick run-down of the final
application...
tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:24 PM
To: CF-Talk
Subject: Re: Quick Qu
> you may have posted already, but a quick run-down of the final
> application...
Oh, I'm just looking for what would be considered the "best" datatype to use
to calculate time spent doing a task. A Task, which is stored in a task
table, has a certain amount of "time" attached to it (TimeAllocated
e top of my
head.
hth
tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:42 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> you may have posted already, but a quick run-down of t
]
Sent: Wednesday, March 24, 2004 1:42 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> you may have posted already, but a quick run-down of the final
> application...
Oh, I'm just looking for what would be considered the "best&
, 2004 1:49 PM
To: CF-Talk
Subject: RE: Quick Question, RE: Datatype and future date/time calculation
ok...
I would have these tables.
tasks
--
id
allottedTime (int) [keep as seconds]
status (int) (complete/not complete) (1 or 0) actualTimeSpent (int)
[seconds] (you could write total seconds
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 24, 2004 1:48 PM
Subject: RE: Quick Question, RE: Datatype and future date/time calculation
> ok...
>
> I would have
and then match that up
against actualTime
make sense?
tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 2:16 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
- Original Message -
From: &quo
> that's fine...so don't have beginTime and endTime just have timeOnTask,
and
> let them enter what they want, and translate that into seconds in the cf
> code...
>
> I use beginTime and endTime, in a web application because, I capture them
> logging in, and logging out, therefore I can interpret t
> Totally, you've been a terrific help. I hope this helped others as much as
> it helped me.
Oh yeah, one more thing, regarding how *they've* decided *they* want the
interface, which is sort of dictating my database design...I have no problem
with it, I just want to make sure it's "do-able"...
Le
well...yeah...
1
1
2
then just add up
:) tony
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 2:30 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> Totally, you've been a
> well...yeah...
>
>
> 1
>
>
Okay, see, that was my question, how do I set the "values" of the hours and
minutes. Easy enough, just pass the number of seconds...gotcha...
>
> 1
> 2
>
>
> then just add up
>
>
>
> :) tony
Once again, it was harder in my head than you've made it here on "pape
s'all good man, good luck, and if you need that cfc secondsToTime I can
forward that on to ya!
later.
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 2:41 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date
Use datetime datatypes with datediff/dateadd functions.
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 11:58 AM
To: CF-Talk
Subject: Quick Question, RE: Datatype and future date/time calculations
Let's say a table was going to contain "Allo
96 matches
Mail list logo