Re: any ideas
Something like this maybe? dataObject[1][1] = "myField"; // field name dataObject[1][2] = "myValue"; // value dataObject[1][3] = "myDataType" // data type and #dataObject[i][1]# = Thats off the dome so it could be wrong some. Mary Jo Sminkey wrote: >> Anyone have a good way of doing this and keep safe from SQL injection? > > Do you have any information at all about the field types/columns being > included? There are certainly ways to handle this if you just have something > like a string of words you want to search on or known phrases, such that you > can split them out into cfqueryparams. If it's just a random where clause, > that would be a lot more challenging, if not impossible, to make hacker-safe. > > --- Mary Jo > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any ideas
>Anyone have a good way of doing this and keep safe from SQL injection? Do you have any information at all about the field types/columns being included? There are certainly ways to handle this if you just have something like a string of words you want to search on or known phrases, such that you can split them out into cfqueryparams. If it's just a random where clause, that would be a lot more challenging, if not impossible, to make hacker-safe. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: any ideas
I have done this with a function for type that keeps my cfqueryparams intact... Instead of building the where clause as a string (usually a kind of a tricky proposition and not a great idea) put your logic inside the cfquery and do something like this. SELECT WHERE 1 = 1 AND colname = AND colname = This keeps my vars bound and prevents attack while allowing for a dynamic query... You could just as easily loop through a list of stuff using the same approach. Of course you might need to handle nulls, handle decimals etc... It can get dicey :) Another approach is to scrub out key words that might be used in an attack. There are some Regex functions out there and a function at cflib.org to remove malicious SQL - although I think it is somewhat incomplete. Of the 2 approaches I always fall back to . -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 4:15 PM To: CF-Talk Subject: Re: any ideas You are effectively throwing open the door to any hacker, then asking how to stop them from coming in and stealing your stereo. :) Why do you want to do this? Perhaps there is a better way? On Wed, May 14, 2008 at 1:44 PM, Chad Gray <[EMAIL PROTECTED]> wrote: > I would like to leave my Query open to take in any number of where statements. > > IE: > > > SELECT * FROM > Jobs WHERE 1=1 >AND #arguments.clause# > > > Of course the problem with doing this is SQL injection. > > Anyone have a good way of doing this and keep safe from SQL injection? > > Thanks! > Chad > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any ideas
You are effectively throwing open the door to any hacker, then asking how to stop them from coming in and stealing your stereo. :) Why do you want to do this? Perhaps there is a better way? On Wed, May 14, 2008 at 1:44 PM, Chad Gray <[EMAIL PROTECTED]> wrote: > I would like to leave my Query open to take in any number of where statements. > > IE: > > > > SELECT * > FROM Jobs > WHERE 1=1 >AND #arguments.clause# > > > Of course the problem with doing this is SQL injection. > > Anyone have a good way of doing this and keep safe from SQL injection? > > Thanks! > Chad > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: any ideas
> (Technically, you should never delete a record. Just mark it > "no show" or something of that nature.) That's not true. There are cases where you want to "soft delete" records, and (many other) cases where you want to actually delete the record. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas
Also.. if you are using SQL server... Create a user in SQL server with the least amount of rights. NEVER USE THE SA ACCOUNT! Allow only select. Deny delete, insert, update if it is not needed. (Technically, you should never delete a record. Just mark it "no show" or something of that nature.) Use the created SQL server username for the datasource in ColdFusion Administrator. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 1:45 PM To: CF-Talk Subject: any ideas I would like to leave my Query open to take in any number of where statements. IE: SELECT * FROM Jobs WHERE 1=1 AND #arguments.clause# Of course the problem with doing this is SQL injection. Anyone have a good way of doing this and keep safe from SQL injection? Thanks! Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas
the variables in the where statement ??? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 1:45 PM To: CF-Talk Subject: any ideas I would like to leave my Query open to take in any number of where statements. IE: SELECT * FROM Jobs WHERE 1=1 AND #arguments.clause# Of course the problem with doing this is SQL injection. Anyone have a good way of doing this and keep safe from SQL injection? Thanks! Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any ideas
And also suggest they update their text. If it didn't sell, it might be the ad, not the item. On 8/17/06, Kevin Aebig <[EMAIL PROTECTED]> wrote: > If you're really set on having it automated, just do a mail-out at the end > of the month reminding the sellers to either re-subscribe their ads or > cancel them if it's no longer needed. > > Toss in a url to make it easy for them to do... easy to build... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any ideas
Solution 1 would be to stop the ad after 1 month and notify the seller that the ad has ran its initial course and that if they have not sold the item to log in and re-list it for free for 1 more month. (people like being given free stuff after the fact... more so than they do up front) Solution 2 would be to just double your initial 1 month to 2 months and call it a 'perk'. Tell your customers it's twice the ad time for half the price blah blah These both seem like good solutions to me (I'd prefer solution1 personally) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 4:04 PM To: CF-Talk Subject: Re: Any ideas As I posted earlier, I want to offer another month free if their item "does not sale". Not only does this cause people to want to use the service, but it gives the site more product for people to look at when they browse. Any ideas other than mine? Regards, Doug - Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, August 17, 2006 7:49 AM Subject: RE: Any ideas > > -Original Message- > > From: Doug Brown [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 16, 2006 11:37 PM > > To: CF-Talk > > Subject: Any ideas > > > > In my classifieds, I want to give the customer the ability to re-post > > their ad for free for another month if they do not sale the item. Can > > anyone think of a way to check if the item is sold? I was thinking that I > > could have the customer log-in to be able to "agree" to buy the item from > > the seller and then have the seller "agree" to sell the item to the > > customer. At this point the database would be updated showing item was > > sold. Any thoughts? > > It seems more complicated than you'd need. Why would anybody want an ad for > another month if their item sold? > > You'll lose a lot less money by adopting the honor system than you would > spend trying to code for this. ;^) > > Jim Davis > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any ideas
As I posted earlier, I want to offer another month free if their item "does not sale". Not only does this cause people to want to use the service, but it gives the site more product for people to look at when they browse. Any ideas other than mine? I think that was the point. Don't worry about when an Item is sold; once that is done most people would take an ad down to stop being contacted by potential buyers. So just send out a notice at the end of the month asking if the users would like to extend their advertisement. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any ideas
If you're really set on having it automated, just do a mail-out at the end of the month reminding the sellers to either re-subscribe their ads or cancel them if it's no longer needed. Toss in a url to make it easy for them to do... easy to build... !k -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 2:57 PM To: CF-Talk Subject: RE: Any ideas As I posted earlier, I want to offer another month free if their item "does not sale". Not only does this cause people to want to use the service, but it gives the site more product for people to look at when they browse. Any ideas other than mine? I think that was the point. Don't worry about when an Item is sold; once that is done most people would take an ad down to stop being contacted by potential buyers. So just send out a notice at the end of the month asking if the users would like to extend their advertisement. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any ideas
As I posted earlier, I want to offer another month free if their item "does not sale". Not only does this cause people to want to use the service, but it gives the site more product for people to look at when they browse. Any ideas other than mine? Regards, Doug - Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, August 17, 2006 7:49 AM Subject: RE: Any ideas > > -Original Message- > > From: Doug Brown [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 16, 2006 11:37 PM > > To: CF-Talk > > Subject: Any ideas > > > > In my classifieds, I want to give the customer the ability to re-post > > their ad for free for another month if they do not sale the item. Can > > anyone think of a way to check if the item is sold? I was thinking that I > > could have the customer log-in to be able to "agree" to buy the item from > > the seller and then have the seller "agree" to sell the item to the > > customer. At this point the database would be updated showing item was > > sold. Any thoughts? > > It seems more complicated than you'd need. Why would anybody want an ad for > another month if their item sold? > > You'll lose a lot less money by adopting the honor system than you would > spend trying to code for this. ;^) > > Jim Davis > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any ideas
> -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 16, 2006 11:37 PM > To: CF-Talk > Subject: Any ideas > > In my classifieds, I want to give the customer the ability to re-post > their ad for free for another month if they do not sale the item. Can > anyone think of a way to check if the item is sold? I was thinking that I > could have the customer log-in to be able to "agree" to buy the item from > the seller and then have the seller "agree" to sell the item to the > customer. At this point the database would be updated showing item was > sold. Any thoughts? It seems more complicated than you'd need. Why would anybody want an ad for another month if their item sold? You'll lose a lot less money by adopting the honor system than you would spend trying to code for this. ;^) Jim Davis ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any ideas
Couldn't you default the time for postings to 2 months and if the user indicates the item has sold, take it off? Jake Churchill CF Web Tools [EMAIL PROTECTED] 402-408-3733 x103 -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 8:50 AM To: CF-Talk Subject: RE: Any ideas > -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 16, 2006 11:37 PM > To: CF-Talk > Subject: Any ideas > > In my classifieds, I want to give the customer the ability to re-post > their ad for free for another month if they do not sale the item. Can > anyone think of a way to check if the item is sold? I was thinking > that I could have the customer log-in to be able to "agree" to buy the > item from the seller and then have the seller "agree" to sell the item > to the customer. At this point the database would be updated showing > item was sold. Any thoughts? It seems more complicated than you'd need. Why would anybody want an ad for another month if their item sold? You'll lose a lot less money by adopting the honor system than you would spend trying to code for this. ;^) Jim Davis ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any ideas
Thanks for your thoughts Paul. I think you are right as far as the database. I am still adding columns to that list and hopefully all will end well. thanks again, - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, August 16, 2006 9:42 PM Subject: Re: Any ideas > I would leave it up to the ad "owner" to turn the ad off by manually setting > it to sold. There is really no other way to do this, they will be > encouraged to do so as they do not want to keep getting emails and contacts > from people when they do not have the stuff anymore. > > my .02 > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > - Original Message - > From: "Doug Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Wednesday, August 16, 2006 10:37 PM > Subject: Any ideas > > > > In my classifieds, I want to give the customer the ability to re-post > > their ad for free for another month if they do not sale the item. Can > > anyone think of a way to check if the item is sold? I was thinking that I > > could have the customer log-in to be able to "agree" to buy the item from > > the seller and then have the seller "agree" to sell the item to the > > customer. At this point the database would be updated showing item was > > sold. Any thoughts? > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any ideas
I would leave it up to the ad "owner" to turn the ad off by manually setting it to sold. There is really no other way to do this, they will be encouraged to do so as they do not want to keep getting emails and contacts from people when they do not have the stuff anymore. my .02 Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, August 16, 2006 10:37 PM Subject: Any ideas > In my classifieds, I want to give the customer the ability to re-post > their ad for free for another month if they do not sale the item. Can > anyone think of a way to check if the item is sold? I was thinking that I > could have the customer log-in to be able to "agree" to buy the item from > the seller and then have the seller "agree" to sell the item to the > customer. At this point the database would be updated showing item was > sold. Any thoughts? > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Any ideas??
Are you using ColdFusion's own CreateUUID() functions? These are not valid MSSQL UUID's. You need something like the MSSQLCreateUUID() UDF at http://www.cflib.org/udf.cfm?ID=512. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 "[EMAIL PROTECTED] com" cc: 02/02/2004 22:36 Subject: Any ideas?? Please respond to cf-talk | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Any ideas??
Well - that's a GUID value - are you calling it as a number anyplace? Trying to do math on it or use an aggregate mathematical function? Posting some code would be the best way to help. Jim Davis _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 6:37 AM To: CF-Talk Subject: Any ideas?? I keep getting the error: "8170f80c-8436-483b-84b5-ee351daffc0f" must be interprettable as a valid number in the current locale. Without getting into too much detail ,all I am doing in the code is a QoQ on a query containing a few int and varchar columns, along with a SQL GUID column. We are using CFMX on SQL Server 2K on Win2K Anyone have any ideas? Neil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: any ideas on this error?
it ended up being a few things Dave - Original Message - From: "Jann VanOver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 1:23 AM Subject: Re: any ideas on this error? > On 2/13/03 1:26 PM, "Dave Lyons" <[EMAIL PROTECTED]> wrote: > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently "CreateDateTime(Now())", > > must be a class java.util.Date value. > > > > Did you mean createOdbcDateTime(Now()) ??? > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
On 2/13/03 1:26 PM, "Dave Lyons" <[EMAIL PROTECTED]> wrote: > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently "CreateDateTime(Now())", > must be a class java.util.Date value. > Did you mean createOdbcDateTime(Now()) ??? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
FYI~ in case anyone is following this and needs it
Added this & all is good in my world!
Ends
today!
#daystogo# days left
Dave
- Original Message -
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 11:43 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> great that finally seems to work!
> thank you:)
> the only flaw is that on the last day, the days left should read 0 but it
> still says 1 day left.
>
> I'm sure a quick cfif should fix that
>
> once again, thanks to everyone!
>
> Dave
>
> - Original Message -
> From: "Jeff Garza" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 6:05 PM
> Subject: Re: OK, lets start overRe: any ideas on this error?
>
>
> > Ooops. Error in calculation. My original script used minutes and I
> goofed
> > on the conversion to seconds.
> >
> >
> > timeleft = DateDiff("s", Now(), deadline);
> > daystogo = Int(timeleft /86400);
> > leftover1 = timeleft - (daystogo * 86400);
> > hourstogo = Int(leftover1/3600);
> > leftover2 = leftover1 - (hourstogo * 3600);
> > minutestogo= Int(leftover2/60);
> > leftover3 = leftover2 - (minutestogo * 60);
> > secondstogo = leftover3;
> >
> >
> >
> > #daystogo# days
> > #NumberFormat(hourstogo, '00')# Hours
> > #NumberFormat(minutestogo, '00')# minutes
> > #NumberFormat(secondstogo, '00')# seconds
> >
> >
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
great that finally seems to work!
thank you:)
the only flaw is that on the last day, the days left should read 0 but it
still says 1 day left.
I'm sure a quick cfif should fix that
once again, thanks to everyone!
Dave
- Original Message -
From: "Jeff Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:05 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> Ooops. Error in calculation. My original script used minutes and I
goofed
> on the conversion to seconds.
>
>
> timeleft = DateDiff("s", Now(), deadline);
> daystogo = Int(timeleft /86400);
> leftover1 = timeleft - (daystogo * 86400);
> hourstogo = Int(leftover1/3600);
> leftover2 = leftover1 - (hourstogo * 3600);
> minutestogo= Int(leftover2/60);
> leftover3 = leftover2 - (minutestogo * 60);
> secondstogo = leftover3;
>
>
>
> #daystogo# days
> #NumberFormat(hourstogo, '00')# Hours
> #NumberFormat(minutestogo, '00')# minutes
> #NumberFormat(secondstogo, '00')# seconds
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
thanks everyone!
I'm sure i can get the rest
Dave
- Original Message -
From: "Jeff Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:05 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> Ooops. Error in calculation. My original script used minutes and I
goofed
> on the conversion to seconds.
>
>
> timeleft = DateDiff("s", Now(), deadline);
> daystogo = Int(timeleft /86400);
> leftover1 = timeleft - (daystogo * 86400);
> hourstogo = Int(leftover1/3600);
> leftover2 = leftover1 - (hourstogo * 3600);
> minutestogo= Int(leftover2/60);
> leftover3 = leftover2 - (minutestogo * 60);
> secondstogo = leftover3;
>
>
>
> #daystogo# days
> #NumberFormat(hourstogo, '00')# Hours
> #NumberFormat(minutestogo, '00')# minutes
> #NumberFormat(secondstogo, '00')# seconds
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
Ooops. Error in calculation. My original script used minutes and I goofed
on the conversion to seconds.
timeleft = DateDiff("s", Now(), deadline);
daystogo = Int(timeleft /86400);
leftover1 = timeleft - (daystogo * 86400);
hourstogo = Int(leftover1/3600);
leftover2 = leftover1 - (hourstogo * 3600);
minutestogo= Int(leftover2/60);
leftover3 = leftover2 - (minutestogo * 60);
secondstogo = leftover3;
#daystogo# days
#NumberFormat(hourstogo, '00')# Hours
#NumberFormat(minutestogo, '00')# minutes
#NumberFormat(secondstogo, '00')# seconds
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OK, lets start over........Re: any ideas on this error?
Try this function. It takes as attributes, days, hours, minutes, seconds
in that order. But you can call it in the following ways. (The last one
is the one you want):
timespanformat(days, hours, minutes, seconds)
timespanformat(hours, minutes, seconds)
timespanformat minutes, seconds)
timespanformat(seconds)
function timespanFormat() {
var days = 0;
var hours = 0;
var minutes = 0;
var seconds = 0;
var timespan = 0;
var result = "";
if ( arrayLen(arguments) gt 0 ) {
seconds = arguments[arrayLen(arguments)];
if ( arrayLen(arguments) gt 1 ) {
minutes = arguments[arrayLen(arguments)
- 1];
if ( arrayLen(arguments) gt 2 ) {
hours =
arguments[arrayLen(arguments) - 2];
if ( arrayLen(arguments) gt 3 )
days =
arguments[arrayLen(arguments) - 3];
}
}
}
timespan = ((days * 24 + hours) * 60 + minutes) * 60 +
seconds;
seconds = timespan mod 60;
timespan = timespan \ 60;
minutes = timespan mod 60;
timespan = timespan \ 60;
hours = timespan mod 24;
timespan = timespan \ 24;
days = timespan;
if ( days )
if ( days eq 1 )
result = "1 day";
else
result = days & " days";
if ( hours )
if ( hours eq 1 )
result = listAppend(result, "1 hour");
else
result = listAppend(result, hours & "
hours");
if ( minutes )
if ( minutes eq 1 )
result = listAppend(result, "1 minute");
else
result = listAppend(result, minutes & "
minutes");
if ( seconds )
if ( seconds eq 1 )
result = listAppend(result, "1 second");
else
result = listAppend(result, seconds & "
seconds");
return listChangeDelims(result, ", ");
}
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 14 February 2003 11:23 a.m.
> To: CF-Talk
> Subject: Re: OK, lets start overRe: any ideas on this error?
>
>
> ok, that may work
> solves the error and returns this: 159679
> so should i just format that? to show the time left?
>
>
> Dave
>
> - Original Message -----
> From: <"Everett>; >
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 5:17 PM
> Subject: RE: OK, lets start overRe: any ideas on this error?
>
>
> > Try this:
> >
> > > -Original Message-
> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 13, 2003 5:00 PM
> > > To: CF-Talk
> > > Subject: OK, lets start overRe: any ideas on this error?
> > >
> > >
> > > heres what i need
> > >
> > > i have to make this small auction page for my competitors client.
> > > what i need right now is to be able to show on the details
> > > page how much
> > > time is left before the end of the auction.
> > > see:
> http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
> > >
> > > ok, so in my application.cfm template i have this variable set:
> > >
> > >
> > > the reason for this is that i need this to manually set the
> > > end time of the
> > > auction on all of the pages.
> > > they arent paying enough to make it dynamic and they want
> > > each auction to
> > > start and end all at the same time, just a 1 shot deal.
> > > but I figure i should use this for what i need now.
> > >
> > > so on the details page i need to basically show how much time
> > > is left, just
> > > like Ebay:)
> > >
> > > thats where dateDiff comes in, correct?
> > >
> > > which should be like such
> > >
> > >
> > > so i was thinking that Now() should go where &
RE: OK, lets start over........Re: any ideas on this error?
That's the number of seconds different between the two date/time objects. You'll want to break that down into days, hours, etc. Integer division (\) and MOD will be your friend here. > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 5:23 PM > To: CF-Talk > Subject: Re: OK, lets start overRe: any ideas on this error? > > > ok, that may work > solves the error and returns this: 159679 > so should i just format that? to show the time left? > > > Dave > > - Original Message - > From: <"Everett>; > > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 5:17 PM > Subject: RE: OK, lets start overRe: any ideas on this error? > > > > Try this: > > > > > -Original Message- > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, February 13, 2003 5:00 PM > > > To: CF-Talk > > > Subject: OK, lets start overRe: any ideas on this error? > > > > > > > > > heres what i need > > > > > > i have to make this small auction page for my competitors client. > > > what i need right now is to be able to show on the details > > > page how much > > > time is left before the end of the auction. > > > see: > http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > > > > > ok, so in my application.cfm template i have this variable set: > > > > > > > > > the reason for this is that i need this to manually set the > > > end time of the > > > auction on all of the pages. > > > they arent paying enough to make it dynamic and they want > > > each auction to > > > start and end all at the same time, just a 1 shot deal. > > > but I figure i should use this for what i need now. > > > > > > so on the details page i need to basically show how much time > > > is left, just > > > like Ebay:) > > > > > > thats where dateDiff comes in, correct? > > > > > > which should be like such > > > > > > > > > so i was thinking that Now() should go where "date1" is > > > And "deadline" from the application.cfm should go where "date2" is > > > tony i think you may be right in putting 's' in where > "datePart" is > > > > > > which now looks like > > > > > > > > > > > > and that produces this error > > > > > > Parameter validation error for function DATEDIFF. > > > The value of the parameter 2, which is currently > > > "Now()", must be a > > > class java.util.Date value. > > > > > > The error occurred in > > > C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > > > 14 > > > > > > 12 : > > > 13 : > > > 14 : > > > 15 : > > > 16 : > > > > > > > > > > > > > > > > > > > > > > > > > > > Dave > > > > > > - Original Message - > > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Thursday, February 13, 2003 4:40 PM > > > Subject: RE: any ideas on this error? > > > > > > > > > > send the code ur using > > > > > > > > ...tony > > > > > > > > Tony Weeg > > > > Senior Web Developer > > > > UnCertified Advanced ColdFusion Developer > > > > Information System Design > > > > Navtrak, Inc. > > > > Mobile workforce monitoring, mapping & reporting > > > > www.navtrak.net > > > > 410.548.2337 > > > > > > > > -Original Message- > > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, February 13, 2003 4:36 PM > > > > To: CF-Talk > > > > Subject: Re: any ideas on this error? > > > > > > > > > > > > using just Now() throws the same error > > > > > > > > > > > > Dave > > > > > > > > - Original Message - > > > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Thursday, February 13, 2003 4:30 PM > > > > Subject: RE:
Re: OK, lets start over........Re: any ideas on this error?
That gives you the number of seconds between now and then... based on your
script. You can then parse the seconds value and figure out how many Days,
hours and minutes are left...
The following snippet might not be the most efficient... but it works... ;-)
You could probably make this a custom function or custom tag as well.
timeleft = DateDiff("s", Now(), deadline);
daystogo = Int(timeleft /86400);
leftover1 = timeleft - (daystogo * 86400);
hourstogo = Int(leftover1/1440);
leftover2 = leftover1 - (hourstogo * 1440);
minutestogo= Int(leftover2/60);
leftover3 = leftover2 - (minutestogo * 60);
secondstogo = leftover3;
#daystogo# days
#NumberFormat(hourstogo, '00')# Hours
#NumberFormat(minutestogo, '00')# minutes
#NumberFormat(secondstogo, '00')# seconds
HTH,
Jeff
- Original Message -
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 3:22 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
ok, that may work
solves the error and returns this: 159679
so should i just format that? to show the time left?
Dave
- Original Message -
From: <"Everett>; >
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:17 PM
Subject: RE: OK, lets start overRe: any ideas on this error?
> Try this:
>
> > -Original Message-
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 5:00 PM
> > To: CF-Talk
> > Subject: OK, lets start overRe: any ideas on this error?
> >
> >
> > heres what i need
> >
> > i have to make this small auction page for my competitors client.
> > what i need right now is to be able to show on the details
> > page how much
> > time is left before the end of the auction.
> > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
> >
> > ok, so in my application.cfm template i have this variable set:
> >
> >
> > the reason for this is that i need this to manually set the
> > end time of the
> > auction on all of the pages.
> > they arent paying enough to make it dynamic and they want
> > each auction to
> > start and end all at the same time, just a 1 shot deal.
> > but I figure i should use this for what i need now.
> >
> > so on the details page i need to basically show how much time
> > is left, just
> > like Ebay:)
> >
> > thats where dateDiff comes in, correct?
> >
> > which should be like such
> >
> >
> > so i was thinking that Now() should go where "date1" is
> > And "deadline" from the application.cfm should go where "date2" is
> > tony i think you may be right in putting 's' in where "datePart" is
> >
> > which now looks like
> >
> >
> >
> > and that produces this error
> >
> > Parameter validation error for function DATEDIFF.
> > The value of the parameter 2, which is currently
> > "Now()", must be a
> > class java.util.Date value.
> >
> > The error occurred in
> > C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line
> > 14
> >
> > 12 :
> > 13 :
> > 14 :
> > 15 :
> > 16 :
> >
> >
> >
> >
> >
> >
> >
> >
> > Dave
> >
> > - Original Message -
> > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 13, 2003 4:40 PM
> > Subject: RE: any ideas on this error?
> >
> >
> > > send the code ur using
> > >
> > > ...tony
> > >
> > > Tony Weeg
> > > Senior Web Developer
> > > UnCertified Advanced ColdFusion Developer
> > > Information System Design
> > > Navtrak, Inc.
> > > Mobile workforce monitoring, mapping & reporting
> > > www.navtrak.net
> > > 410.548.2337
> > >
> > > -Original Message-
> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 13, 2003 4:36 PM
> > > To: CF-Talk
> > > Subject: Re: any ideas on this error?
> > >
> > >
> > > using just Now() throws the same error
> > >
> > >
> > > Dave
> > >
> > > - Original Message -
> > > From: "Tony Weeg" <[EMAIL PROTECTED]&
Re: OK, lets start over........Re: any ideas on this error?
-- Original Message -- From: "Dave Lyons" <[EMAIL PROTECTED]> >maybe i have a corrupt file When in doubt . .. restart the server :) Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OK, lets start over........Re: any ideas on this error?
You're editing the correct file, right? Maybe try inserting a date instead of now() in quotes and see what happens. > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Friday, 14 February 2003 11:18 a.m. > To: CF-Talk > Subject: Re: OK, lets start over....Re: any ideas on this error? > > > :( > been trying them all and the same error > maybe i have a corrupt file > > any other suggestions on how to do it? > > im off to make an ass outta myself at my 1st cf meeting > > Dave > > - Original Message - > From: "Scott Brady" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 5:10 PM > Subject: Re: OK, lets start overRe: any ideas on this error? > > > > -- Original Message -- > > From: "charlie griefer" <[EMAIL PROTECTED]> > > >no quotes around now() > > > > > > > Not sure if this affects the error or not, but you also > don't need the > single quotes around "s", and if deadline is a datetime > object, get rid of > those quotes, as well: > > > > > > > > Scott > > > > Scott Brady > > http://www.scottbrady.net/ > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
There are three parameters to pass to the BIF DateDiff()
datePart
Date1
Date2
Date1 and date2 need to be dates.
When you passed in "Now()" and "deadline", it was passing the literal string "Now()"
and the literal string "deadline".
If you want to pass the values of now() and deadline, you need to pass them without
quotes, or by outputing the value using coldFusion #
So
dateDiff("s",now(),deadline)
or
dateDiff("s","#now()#","#deadline#")
This assumes the variable deadline is defined and evaluates to a date.
Jerry Johnson
>>> [EMAIL PROTECTED] 02/13/03 05:08PM >>>
sorry charlie but i get the same error:(
- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:07 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> no quotes around now()
>
>
>
> Dave Lyons writes:
>
> > heres what i need
> >
> > i have to make this small auction page for my competitors client.
> > what i need right now is to be able to show on the details page how much
> > time is left before the end of the auction.
> > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
> >
> > ok, so in my application.cfm template i have this variable set:
> >
> >
> > the reason for this is that i need this to manually set the end time of
the
> > auction on all of the pages.
> > they arent paying enough to make it dynamic and they want each auction
to
> > start and end all at the same time, just a 1 shot deal.
> > but I figure i should use this for what i need now.
> >
> > so on the details page i need to basically show how much time is left,
just
> > like Ebay:)
> >
> > thats where dateDiff comes in, correct?
> >
> > which should be like such
> >
> >
> > so i was thinking that Now() should go where "date1" is
> > And "deadline" from the application.cfm should go where "date2" is
> > tony i think you may be right in putting 's' in where "datePart" is
> >
> > which now looks like
> >
> >
> >
> > and that produces this error
> >
> > Parameter validation error for function DATEDIFF.
> > The value of the parameter 2, which is currently "Now()", must be
a
> > class java.util.Date value.
> >
> > The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm:
line
> > 14
> >
> > 12 :
> > 13 :
> > 14 :
> > 15 :
> > 16 :
> >
> >
> >
> >
> >
> >
> >
> >
> > Dave
> >
> > - Original Message -
> > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 13, 2003 4:40 PM
> > Subject: RE: any ideas on this error?
> >
> >
> >> send the code ur using
> >>
> >> ...tony
> >>
> >> Tony Weeg
> >> Senior Web Developer
> >> UnCertified Advanced ColdFusion Developer
> >> Information System Design
> >> Navtrak, Inc.
> >> Mobile workforce monitoring, mapping & reporting
> >> www.navtrak.net
> >> 410.548.2337
> >>
> >> -Original Message-
> >> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> >> Sent: Thursday, February 13, 2003 4:36 PM
> >> To: CF-Talk
> >> Subject: Re: any ideas on this error?
> >>
> >>
> >> using just Now() throws the same error
> >>
> >>
> >> Dave
> >>
> >> - Original Message -
> >> From: "Tony Weeg" <[EMAIL PROTECTED]>
> >> To: "CF-Talk" <[EMAIL PROTECTED]>
> >> Sent: Thursday, February 13, 2003 4:30 PM
> >> Subject: RE: any ideas on this error?
> >>
> >>
> >> > why use all thatcan u just use
> >> >
> >> > Now()
> >> >
> >> > ...tony
> >> >
> >> > Tony Weeg
> >> > Senior Web Developer
> >> > UnCertified Advanced ColdFusion Developer
> >> > Information System Design
> >> > Navtrak, Inc.
> >> > Mobile workforce monitoring, mapping & reporting
> >> > www.navtrak.net
> >> > 410.548.2337
> >> >
> >> > -Original Message-
> >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> >> > Sent: Thursday, February 13, 2003 4:26 PM
> >> > To: CF-Talk
> >> > Subject: any ideas on this error?
> >> >
> >> >
> >> > Parameter validation error for function DATEDIFF.
> >> > The value of the parameter 2, which is currently
> >> > "CreateDateTime(Now())", must be a class java.util.Date value.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
ok, that may work solves the error and returns this: 159679 so should i just format that? to show the time left? Dave - Original Message - From: <"Everett>; > To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 5:17 PM Subject: RE: OK, lets start overRe: any ideas on this error? > Try this: > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 5:00 PM > > To: CF-Talk > > Subject: OK, lets start overRe: any ideas on this error? > > > > > > heres what i need > > > > i have to make this small auction page for my competitors client. > > what i need right now is to be able to show on the details > > page how much > > time is left before the end of the auction. > > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > > > ok, so in my application.cfm template i have this variable set: > > > > > > the reason for this is that i need this to manually set the > > end time of the > > auction on all of the pages. > > they arent paying enough to make it dynamic and they want > > each auction to > > start and end all at the same time, just a 1 shot deal. > > but I figure i should use this for what i need now. > > > > so on the details page i need to basically show how much time > > is left, just > > like Ebay:) > > > > thats where dateDiff comes in, correct? > > > > which should be like such > > > > > > so i was thinking that Now() should go where "date1" is > > And "deadline" from the application.cfm should go where "date2" is > > tony i think you may be right in putting 's' in where "datePart" is > > > > which now looks like > > > > > > > > and that produces this error > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "Now()", must be a > > class java.util.Date value. > > > > The error occurred in > > C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > > 14 > > > > 12 : > > 13 : > > 14 : > > 15 : > > 16 : > > > > > > > > > > > > > > > > > > Dave > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 13, 2003 4:40 PM > > Subject: RE: any ideas on this error? > > > > > > > send the code ur using > > > > > > ...tony > > > > > > Tony Weeg > > > Senior Web Developer > > > UnCertified Advanced ColdFusion Developer > > > Information System Design > > > Navtrak, Inc. > > > Mobile workforce monitoring, mapping & reporting > > > www.navtrak.net > > > 410.548.2337 > > > > > > -Original Message- > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, February 13, 2003 4:36 PM > > > To: CF-Talk > > > Subject: Re: any ideas on this error? > > > > > > > > > using just Now() throws the same error > > > > > > > > > Dave > > > > > > - Original Message - > > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Thursday, February 13, 2003 4:30 PM > > > Subject: RE: any ideas on this error? > > > > > > > > > > why use all thatcan u just use > > > > > > > > Now() > > > > > > > > ...tony > > > > > > > > Tony Weeg > > > > Senior Web Developer > > > > UnCertified Advanced ColdFusion Developer > > > > Information System Design > > > > Navtrak, Inc. > > > > Mobile workforce monitoring, mapping & reporting > > > > www.navtrak.net > > > > 410.548.2337 > > > > > > > > -Original Message- > > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, February 13, 2003 4:26 PM > > > > To: CF-Talk > > > > Subject: any ideas on this error? > > > > > > > > > > > > Parameter validation error for function DATEDIFF. > > > > The value of the parameter 2, which is currently > > > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
:( been trying them all and the same error maybe i have a corrupt file any other suggestions on how to do it? im off to make an ass outta myself at my 1st cf meeting Dave - Original Message - From: "Scott Brady" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 5:10 PM Subject: Re: OK, lets start overRe: any ideas on this error? > -- Original Message -- > From: "charlie griefer" <[EMAIL PROTECTED]> > >no quotes around now() > > > > Not sure if this affects the error or not, but you also don't need the single quotes around "s", and if deadline is a datetime object, get rid of those quotes, as well: > > > > Scott > > Scott Brady > http://www.scottbrady.net/ > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OK, lets start over........Re: any ideas on this error?
Try this: > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 5:00 PM > To: CF-Talk > Subject: OK, lets start over....Re: any ideas on this error? > > > heres what i need > > i have to make this small auction page for my competitors client. > what i need right now is to be able to show on the details > page how much > time is left before the end of the auction. > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > ok, so in my application.cfm template i have this variable set: > > > the reason for this is that i need this to manually set the > end time of the > auction on all of the pages. > they arent paying enough to make it dynamic and they want > each auction to > start and end all at the same time, just a 1 shot deal. > but I figure i should use this for what i need now. > > so on the details page i need to basically show how much time > is left, just > like Ebay:) > > thats where dateDiff comes in, correct? > > which should be like such > > > so i was thinking that Now() should go where "date1" is > And "deadline" from the application.cfm should go where "date2" is > tony i think you may be right in putting 's' in where "datePart" is > > which now looks like > > > > and that produces this error > > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently > "Now()", must be a > class java.util.Date value. > > The error occurred in > C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > 14 > > 12 : > 13 : > 14 : > 15 : > 16 : > > > > > > > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:40 PM > Subject: RE: any ideas on this error? > > > > send the code ur using > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message----- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:36 PM > > To: CF-Talk > > Subject: Re: any ideas on this error? > > > > > > using just Now() throws the same error > > > > > > Dave > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 13, 2003 4:30 PM > > Subject: RE: any ideas on this error? > > > > > > > why use all thatcan u just use > > > > > > Now() > > > > > > ...tony > > > > > > Tony Weeg > > > Senior Web Developer > > > UnCertified Advanced ColdFusion Developer > > > Information System Design > > > Navtrak, Inc. > > > Mobile workforce monitoring, mapping & reporting > > > www.navtrak.net > > > 410.548.2337 > > > > > > -Original Message- > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, February 13, 2003 4:26 PM > > > To: CF-Talk > > > Subject: any ideas on this error? > > > > > > > > > Parameter validation error for function DATEDIFF. > > > The value of the parameter 2, which is currently > > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
d'oH! i missed the deadline var in my response :| Jeff Garza writes: > If you are enclosing now() in quotes, as in "now()" CF will evaluate that as > a string... which isn't a valid date time format, ditto for your deadline > variable. > > Try this... > > > > > HTH, > > Jeff Garza > > - Original Message - > From: "Dave Lyons" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 2:59 PM > Subject: OK, lets start overRe: any ideas on this error? > > > heres what i need > > i have to make this small auction page for my competitors client. > what i need right now is to be able to show on the details page how much > time is left before the end of the auction. > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > ok, so in my application.cfm template i have this variable set: > > > the reason for this is that i need this to manually set the end time of the > auction on all of the pages. > they arent paying enough to make it dynamic and they want each auction to > start and end all at the same time, just a 1 shot deal. > but I figure i should use this for what i need now. > > so on the details page i need to basically show how much time is left, just > like Ebay:) > > thats where dateDiff comes in, correct? > > which should be like such > > > so i was thinking that Now() should go where "date1" is > And "deadline" from the application.cfm should go where "date2" is > tony i think you may be right in putting 's' in where "datePart" is > > which now looks like > > > > and that produces this error > > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently "Now()", must be a > class java.util.Date value. > > The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > 14 > > 12 : > 13 : > 14 : > 15 : > 16 : > > > > > > > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:40 PM > Subject: RE: any ideas on this error? > > >> send the code ur using.... >> >> ...tony >> >> Tony Weeg >> Senior Web Developer >> UnCertified Advanced ColdFusion Developer >> Information System Design >> Navtrak, Inc. >> Mobile workforce monitoring, mapping & reporting >> www.navtrak.net >> 410.548.2337 >> >> -Original Message- >> From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, February 13, 2003 4:36 PM >> To: CF-Talk >> Subject: Re: any ideas on this error? >> >> >> using just Now() throws the same error >> >> >> Dave >> >> - Original Message - >> From: "Tony Weeg" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Thursday, February 13, 2003 4:30 PM >> Subject: RE: any ideas on this error? >> >> >> > why use all thatcan u just use >> > >> > Now() >> > >> > ...tony >> > >> > Tony Weeg >> > Senior Web Developer >> > UnCertified Advanced ColdFusion Developer >> > Information System Design >> > Navtrak, Inc. >> > Mobile workforce monitoring, mapping & reporting >> > www.navtrak.net >> > 410.548.2337 >> > >> > -Original Message- >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> > Sent: Thursday, February 13, 2003 4:26 PM >> > To: CF-Talk >> > Subject: any ideas on this error? >> > >> > >> > Parameter validation error for function DATEDIFF. >> > The value of the parameter 2, which is currently >> > "CreateDateTime(Now())", must be a class java.util.Date value. >> > >> > >> > >> > >> > >> > >> >> > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
-- Original Message -- From: "charlie griefer" <[EMAIL PROTECTED]> >no quotes around now() > Not sure if this affects the error or not, but you also don't need the single quotes around "s", and if deadline is a datetime object, get rid of those quotes, as well: Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
sorry charlie but i get the same error:( - Original Message - From: "charlie griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 5:07 PM Subject: Re: OK, lets start overRe: any ideas on this error? > no quotes around now() > > > > Dave Lyons writes: > > > heres what i need > > > > i have to make this small auction page for my competitors client. > > what i need right now is to be able to show on the details page how much > > time is left before the end of the auction. > > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > > > ok, so in my application.cfm template i have this variable set: > > > > > > the reason for this is that i need this to manually set the end time of the > > auction on all of the pages. > > they arent paying enough to make it dynamic and they want each auction to > > start and end all at the same time, just a 1 shot deal. > > but I figure i should use this for what i need now. > > > > so on the details page i need to basically show how much time is left, just > > like Ebay:) > > > > thats where dateDiff comes in, correct? > > > > which should be like such > > > > > > so i was thinking that Now() should go where "date1" is > > And "deadline" from the application.cfm should go where "date2" is > > tony i think you may be right in putting 's' in where "datePart" is > > > > which now looks like > > > > > > > > and that produces this error > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently "Now()", must be a > > class java.util.Date value. > > > > The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > > 14 > > > > 12 : > > 13 : > > 14 : > > 15 : > > 16 : > > > > > > > > > > > > > > > > > > Dave > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 13, 2003 4:40 PM > > Subject: RE: any ideas on this error? > > > > > >> send the code ur using > >> > >> ...tony > >> > >> Tony Weeg > >> Senior Web Developer > >> UnCertified Advanced ColdFusion Developer > >> Information System Design > >> Navtrak, Inc. > >> Mobile workforce monitoring, mapping & reporting > >> www.navtrak.net > >> 410.548.2337 > >> > >> -Original Message- > >> From: Dave Lyons [mailto:[EMAIL PROTECTED]] > >> Sent: Thursday, February 13, 2003 4:36 PM > >> To: CF-Talk > >> Subject: Re: any ideas on this error? > >> > >> > >> using just Now() throws the same error > >> > >> > >> Dave > >> > >> - Original Message - > >> From: "Tony Weeg" <[EMAIL PROTECTED]> > >> To: "CF-Talk" <[EMAIL PROTECTED]> > >> Sent: Thursday, February 13, 2003 4:30 PM > >> Subject: RE: any ideas on this error? > >> > >> > >> > why use all thatcan u just use > >> > > >> > Now() > >> > > >> > ...tony > >> > > >> > Tony Weeg > >> > Senior Web Developer > >> > UnCertified Advanced ColdFusion Developer > >> > Information System Design > >> > Navtrak, Inc. > >> > Mobile workforce monitoring, mapping & reporting > >> > www.navtrak.net > >> > 410.548.2337 > >> > > >> > -Original Message- > >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > >> > Sent: Thursday, February 13, 2003 4:26 PM > >> > To: CF-Talk > >> > Subject: any ideas on this error? > >> > > >> > > >> > Parameter validation error for function DATEDIFF. > >> > The value of the parameter 2, which is currently > >> > "CreateDateTime(Now())", must be a class java.util.Date value. > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
If you are enclosing now() in quotes, as in "now()" CF will evaluate that as a string... which isn't a valid date time format, ditto for your deadline variable. Try this... HTH, Jeff Garza - Original Message - From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 2:59 PM Subject: OK, lets start overRe: any ideas on this error? heres what i need i have to make this small auction page for my competitors client. what i need right now is to be able to show on the details page how much time is left before the end of the auction. see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 ok, so in my application.cfm template i have this variable set: the reason for this is that i need this to manually set the end time of the auction on all of the pages. they arent paying enough to make it dynamic and they want each auction to start and end all at the same time, just a 1 shot deal. but I figure i should use this for what i need now. so on the details page i need to basically show how much time is left, just like Ebay:) thats where dateDiff comes in, correct? which should be like such so i was thinking that Now() should go where "date1" is And "deadline" from the application.cfm should go where "date2" is tony i think you may be right in putting 's' in where "datePart" is which now looks like and that produces this error Parameter validation error for function DATEDIFF. The value of the parameter 2, which is currently "Now()", must be a class java.util.Date value. The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line 14 12 : 13 : 14 : 15 : 16 : Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:40 PM Subject: RE: any ideas on this error? > send the code ur using > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:36 PM > To: CF-Talk > Subject: Re: any ideas on this error? > > > using just Now() throws the same error > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:30 PM > Subject: RE: any ideas on this error? > > > > why use all thatcan u just use > > > > Now() > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:26 PM > > To: CF-Talk > > Subject: any ideas on this error? > > > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OK, lets start over........Re: any ideas on this error?
"Now()" should be replaced with Now() - no quotes. Then you should be set. Jerry Johnson >>> [EMAIL PROTECTED] 02/13/03 04:59PM >>> heres what i need i have to make this small auction page for my competitors client. what i need right now is to be able to show on the details page how much time is left before the end of the auction. see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 ok, so in my application.cfm template i have this variable set: the reason for this is that i need this to manually set the end time of the auction on all of the pages. they arent paying enough to make it dynamic and they want each auction to start and end all at the same time, just a 1 shot deal. but I figure i should use this for what i need now. so on the details page i need to basically show how much time is left, just like Ebay:) thats where dateDiff comes in, correct? which should be like such so i was thinking that Now() should go where "date1" is And "deadline" from the application.cfm should go where "date2" is tony i think you may be right in putting 's' in where "datePart" is which now looks like and that produces this error Parameter validation error for function DATEDIFF. The value of the parameter 2, which is currently "Now()", must be a class java.util.Date value. The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line 14 12 : 13 : 14 : 15 : 16 : Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:40 PM Subject: RE: any ideas on this error? > send the code ur using > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:36 PM > To: CF-Talk > Subject: Re: any ideas on this error? > > > using just Now() throws the same error > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:30 PM > Subject: RE: any ideas on this error? > > > > why use all thatcan u just use > > > > Now() > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:26 PM > > To: CF-Talk > > Subject: any ideas on this error? > > > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
Dave Lyons wrote:
>heres what i need
>
>i have to make this small auction page for my competitors client.
>what i need right now is to be able to show on the details page how much
>time is left before the end of the auction.
>see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
>
>ok, so in my application.cfm template i have this variable set:
>
>
>the reason for this is that i need this to manually set the end time of the
>auction on all of the pages.
>they arent paying enough to make it dynamic and they want each auction to
>start and end all at the same time, just a 1 shot deal.
>but I figure i should use this for what i need now.
>
>so on the details page i need to basically show how much time is left, just
>like Ebay:)
>
>thats where dateDiff comes in, correct?
>
>which should be like such
>
>
>so i was thinking that Now() should go where "date1" is
>And "deadline" from the application.cfm should go where "date2" is
>tony i think you may be right in putting 's' in where "datePart" is
>
>which now looks like
>
>
>
Make that
DateDiff("'s'", "#Now()#", "deadline")
or
DateDiff("'s'", Now(), "deadline")
Jesse
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
right on! thanks Dave - Original Message - From: "Jesse Houwing" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 5:04 PM Subject: Re: any ideas on this error? > Dave Lyons wrote: > > >right, but see i have no idea because look at all the other crap they throw > >in there. > >thats 1 big complaint i would have on the live docs, is that they add all > >those forms crap and its hard to tell how to really use it. > >I wish they wouldnt put everything into a form because that screws up how it > >needs to be written. > > > >i love MM but its confusing to a dumbass like me! > > > >but at least I eat good pie:) > > > > > >dave > > > > > > > If you're using DW MX, have a look at: > > http://mythic.com/code/coldfusion/index.html > > Jesse > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OK, lets start over........Re: any ideas on this error?
no quotes around now() Dave Lyons writes: > heres what i need > > i have to make this small auction page for my competitors client. > what i need right now is to be able to show on the details page how much > time is left before the end of the auction. > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 > > ok, so in my application.cfm template i have this variable set: > > > the reason for this is that i need this to manually set the end time of the > auction on all of the pages. > they arent paying enough to make it dynamic and they want each auction to > start and end all at the same time, just a 1 shot deal. > but I figure i should use this for what i need now. > > so on the details page i need to basically show how much time is left, just > like Ebay:) > > thats where dateDiff comes in, correct? > > which should be like such > > > so i was thinking that Now() should go where "date1" is > And "deadline" from the application.cfm should go where "date2" is > tony i think you may be right in putting 's' in where "datePart" is > > which now looks like > > > > and that produces this error > > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently "Now()", must be a > class java.util.Date value. > > The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line > 14 > > 12 : > 13 : > 14 : > 15 : > 16 : > > > > > > > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:40 PM > Subject: RE: any ideas on this error? > > >> send the code ur using >> >> ...tony >> >> Tony Weeg >> Senior Web Developer >> UnCertified Advanced ColdFusion Developer >> Information System Design >> Navtrak, Inc. >> Mobile workforce monitoring, mapping & reporting >> www.navtrak.net >> 410.548.2337 >> >> -Original Message- >> From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, February 13, 2003 4:36 PM >> To: CF-Talk >> Subject: Re: any ideas on this error? >> >> >> using just Now() throws the same error >> >> >> Dave >> >> - Original Message - >> From: "Tony Weeg" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Thursday, February 13, 2003 4:30 PM >> Subject: RE: any ideas on this error? >> >> >> > why use all thatcan u just use >> > >> > Now() >> > >> > ...tony >> > >> > Tony Weeg >> > Senior Web Developer >> > UnCertified Advanced ColdFusion Developer >> > Information System Design >> > Navtrak, Inc. >> > Mobile workforce monitoring, mapping & reporting >> > www.navtrak.net >> > 410.548.2337 >> > >> > -Original Message- >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> > Sent: Thursday, February 13, 2003 4:26 PM >> > To: CF-Talk >> > Subject: any ideas on this error? >> > >> > >> > Parameter validation error for function DATEDIFF. >> > The value of the parameter 2, which is currently >> > "CreateDateTime(Now())", must be a class java.util.Date value. >> > >> > >> > >> > >> > >> > >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
lol true, true todays funnies brought to u by: ~charlie "smokes to much reefer" griefer~ LOL jk! I kid cause im a kid (at heart) - Original Message - From: "charlie griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:52 PM Subject: Re: any ideas on this error? > Dave Lyons writes: > > > funny, i usually only hear that from the ladies! hahahaha > > ...and then your response is, 'but i am already?' > > :P > > charlie > (kids because he loves) > > > > > jk > > > > > > - Original Message - > > From: "Matthew Walker" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 13, 2003 4:39 PM > > Subject: RE: any ideas on this error? > > > > > >> Maybe you could show us the whole thing > >> > >> > -Original Message- > >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > >> > Sent: Friday, 14 February 2003 10:36 a.m. > >> > To: CF-Talk > >> > Subject: Re: any ideas on this error? > >> > > >> > > >> > using just Now() throws the same error > >> > > >> > > >> > Dave > >> > > >> > - Original Message - > >> > From: "Tony Weeg" <[EMAIL PROTECTED]> > >> > To: "CF-Talk" <[EMAIL PROTECTED]> > >> > Sent: Thursday, February 13, 2003 4:30 PM > >> > Subject: RE: any ideas on this error? > >> > > >> > > >> > > why use all thatcan u just use > >> > > > >> > > Now() > >> > > > >> > > ...tony > >> > > > >> > > Tony Weeg > >> > > Senior Web Developer > >> > > UnCertified Advanced ColdFusion Developer > >> > > Information System Design > >> > > Navtrak, Inc. > >> > > Mobile workforce monitoring, mapping & reporting > >> > > www.navtrak.net > >> > > 410.548.2337 > >> > > > >> > > -Original Message- > >> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > >> > > Sent: Thursday, February 13, 2003 4:26 PM > >> > > To: CF-Talk > >> > > Subject: any ideas on this error? > >> > > > >> > > > >> > > Parameter validation error for function DATEDIFF. > >> > > The value of the parameter 2, which is currently > >> > > "CreateDateTime(Now())", must be a class java.util.Date value. > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > >> > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
Dave Lyons wrote: >right, but see i have no idea because look at all the other crap they throw >in there. >thats 1 big complaint i would have on the live docs, is that they add all >those forms crap and its hard to tell how to really use it. >I wish they wouldnt put everything into a form because that screws up how it >needs to be written. > >i love MM but its confusing to a dumbass like me! > >but at least I eat good pie:) > > >dave > > > If you're using DW MX, have a look at: http://mythic.com/code/coldfusion/index.html Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OK, lets start over........Re: any ideas on this error?
heres what i need i have to make this small auction page for my competitors client. what i need right now is to be able to show on the details page how much time is left before the end of the auction. see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25 ok, so in my application.cfm template i have this variable set: the reason for this is that i need this to manually set the end time of the auction on all of the pages. they arent paying enough to make it dynamic and they want each auction to start and end all at the same time, just a 1 shot deal. but I figure i should use this for what i need now. so on the details page i need to basically show how much time is left, just like Ebay:) thats where dateDiff comes in, correct? which should be like such so i was thinking that Now() should go where "date1" is And "deadline" from the application.cfm should go where "date2" is tony i think you may be right in putting 's' in where "datePart" is which now looks like and that produces this error Parameter validation error for function DATEDIFF. The value of the parameter 2, which is currently "Now()", must be a class java.util.Date value. The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line 14 12 : 13 : 14 : 15 : 16 : Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:40 PM Subject: RE: any ideas on this error? > send the code ur using > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:36 PM > To: CF-Talk > Subject: Re: any ideas on this error? > > > using just Now() throws the same error > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:30 PM > Subject: RE: any ideas on this error? > > > > why use all thatcan u just use > > > > Now() > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:26 PM > > To: CF-Talk > > Subject: any ideas on this error? > > > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
Dave Lyons writes: > funny, i usually only hear that from the ladies! hahahaha ...and then your response is, 'but i am already?' :P charlie (kids because he loves) > > jk > > > - Original Message - > From: "Matthew Walker" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:39 PM > Subject: RE: any ideas on this error? > > >> Maybe you could show us the whole thing >> >> > -Original Message- >> > From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> > Sent: Friday, 14 February 2003 10:36 a.m. >> > To: CF-Talk >> > Subject: Re: any ideas on this error? >> > >> > >> > using just Now() throws the same error >> > >> > >> > Dave >> > >> > - Original Message - >> > From: "Tony Weeg" <[EMAIL PROTECTED]> >> > To: "CF-Talk" <[EMAIL PROTECTED]> >> > Sent: Thursday, February 13, 2003 4:30 PM >> > Subject: RE: any ideas on this error? >> > >> > >> > > why use all thatcan u just use >> > > >> > > Now() >> > > >> > > ...tony >> > > >> > > Tony Weeg >> > > Senior Web Developer >> > > UnCertified Advanced ColdFusion Developer >> > > Information System Design >> > > Navtrak, Inc. >> > > Mobile workforce monitoring, mapping & reporting >> > > www.navtrak.net >> > > 410.548.2337 >> > > >> > > -Original Message- >> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] >> > > Sent: Thursday, February 13, 2003 4:26 PM >> > > To: CF-Talk >> > > Subject: any ideas on this error? >> > > >> > > >> > > Parameter validation error for function DATEDIFF. >> > > The value of the parameter 2, which is currently >> > > "CreateDateTime(Now())", must be a class java.util.Date value. >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas on this error?
What are you trying to do?
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 4:44 PM
> To: CF-Talk
> Subject: Re: any ideas on this error?
>
>
> yeah that works tony but you know what im trying to do
> and that doesnt work
>
>
>
> - Original Message -
> From: "Tony Weeg" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 4:32 PM
> Subject: RE: any ideas on this error?
>
>
> > cfmx
> >
> > #DateDiff('m',Now(),'01/01/1970')#
> >
> > gives me -397
> >
> > it works fine.
> >
> > ...tony
> >
> > Tony Weeg
> > Senior Web Developer
> > UnCertified Advanced ColdFusion Developer
> > Information System Design
> > Navtrak, Inc.
> > Mobile workforce monitoring, mapping & reporting
> > www.navtrak.net
> > 410.548.2337
> >
> > -Original Message-
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 4:26 PM
> > To: CF-Talk
> > Subject: any ideas on this error?
> >
> >
> > Parameter validation error for function DATEDIFF.
> > The value of the parameter 2, which is currently
> > "CreateDateTime(Now())", must be a class java.util.Date value.
> >
> >
> >
> >
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
u already have the code tony Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:40 PM Subject: RE: any ideas on this error? > send the code ur using > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:36 PM > To: CF-Talk > Subject: Re: any ideas on this error? > > > using just Now() throws the same error > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:30 PM > Subject: RE: any ideas on this error? > > > > why use all thatcan u just use > > > > Now() > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:26 PM > > To: CF-Talk > > Subject: any ideas on this error? > > > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
funny, i usually only hear that from the ladies! hahahaha jk - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:39 PM Subject: RE: any ideas on this error? > Maybe you could show us the whole thing > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 14 February 2003 10:36 a.m. > > To: CF-Talk > > Subject: Re: any ideas on this error? > > > > > > using just Now() throws the same error > > > > > > Dave > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 13, 2003 4:30 PM > > Subject: RE: any ideas on this error? > > > > > > > why use all thatcan u just use > > > > > > Now() > > > > > > ...tony > > > > > > Tony Weeg > > > Senior Web Developer > > > UnCertified Advanced ColdFusion Developer > > > Information System Design > > > Navtrak, Inc. > > > Mobile workforce monitoring, mapping & reporting > > > www.navtrak.net > > > 410.548.2337 > > > > > > -Original Message- > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, February 13, 2003 4:26 PM > > > To: CF-Talk > > > Subject: any ideas on this error? > > > > > > > > > Parameter validation error for function DATEDIFF. > > > The value of the parameter 2, which is currently > > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
yeah that works tony but you know what im trying to do
and that doesnt work
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:32 PM
Subject: RE: any ideas on this error?
> cfmx
>
> #DateDiff('m',Now(),'01/01/1970')#
>
> gives me -397
>
> it works fine.
>
> ...tony
>
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337
>
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 4:26 PM
> To: CF-Talk
> Subject: any ideas on this error?
>
>
> Parameter validation error for function DATEDIFF.
> The value of the parameter 2, which is currently
> "CreateDateTime(Now())", must be a class java.util.Date value.
>
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas on this error?
send the code ur using ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 4:36 PM To: CF-Talk Subject: Re: any ideas on this error? using just Now() throws the same error Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:30 PM Subject: RE: any ideas on this error? > why use all thatcan u just use > > Now() > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:26 PM > To: CF-Talk > Subject: any ideas on this error? > > > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
right, but see i have no idea because look at all the other crap they throw in there. thats 1 big complaint i would have on the live docs, is that they add all those forms crap and its hard to tell how to really use it. I wish they wouldnt put everything into a form because that screws up how it needs to be written. i love MM but its confusing to a dumbass like me! but at least I eat good pie:) dave - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:31 PM Subject: Re: any ideas on this error? > Dave Lyons wrote: > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently "CreateDateTime(Now())", must be a class java.util.Date value. > > You are using CreateDateTime() incorrectly. First, the syntax is different: > http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt142.jsp#1 224498 > > Second, it is not needed at all ;-) > > Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas on this error?
Maybe you could show us the whole thing > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Friday, 14 February 2003 10:36 a.m. > To: CF-Talk > Subject: Re: any ideas on this error? > > > using just Now() throws the same error > > > Dave > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 4:30 PM > Subject: RE: any ideas on this error? > > > > why use all thatcan u just use > > > > Now() > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -Original Message- > > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 13, 2003 4:26 PM > > To: CF-Talk > > Subject: any ideas on this error? > > > > > > Parameter validation error for function DATEDIFF. > > The value of the parameter 2, which is currently > > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
using just Now() throws the same error Dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:30 PM Subject: RE: any ideas on this error? > why use all thatcan u just use > > Now() > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:26 PM > To: CF-Talk > Subject: any ideas on this error? > > > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently > "CreateDateTime(Now())", must be a class java.util.Date value. > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas on this error?
cfmx
#DateDiff('m',Now(),'01/01/1970')#
gives me -397
it works fine.
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 4:26 PM
To: CF-Talk
Subject: any ideas on this error?
Parameter validation error for function DATEDIFF.
The value of the parameter 2, which is currently
"CreateDateTime(Now())", must be a class java.util.Date value.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any ideas on this error?
Dave Lyons wrote: > Parameter validation error for function DATEDIFF. > The value of the parameter 2, which is currently "CreateDateTime(Now())", must >be a class java.util.Date value. You are using CreateDateTime() incorrectly. First, the syntax is different: http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt142.jsp#1224498 Second, it is not needed at all ;-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any ideas on this error?
why use all thatcan u just use Now() ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 4:26 PM To: CF-Talk Subject: any ideas on this error? Parameter validation error for function DATEDIFF. The value of the parameter 2, which is currently "CreateDateTime(Now())", must be a class java.util.Date value. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Ideas on How to Start the Testing Of Content Management S yste m - written in ColdFusion & FuseBox 3.0.
Sudheer, I used to do this sort of work as an Allaire/Macromedia consultant and can give you an insight on how we handled this at that time. Before I start I should mention we used a fairly high-end application stress tool called Segue Silk_Performer. This enabled us to create an increasing load on the ColdFusion/Web Server and also to build scripts for VirtualUsers calling outside lists into those scripts to simulate multiple different users and scenarios. The Segue tool is superb for these sorts of functions but was fairly expensive. Others may know of other tools out there we have our own. So here was our Modus-Operandi for testing a new application prior to launch:- First "LIVE IN THE LOGS!", by that I mean use the ColdFusion and to a lesser extent the Web Server logs religiously at all times during your testing. They are truly your fountain of information and will tell you many things, (Btw there is a FB3 web logging tool at www.secretagents.com for the cost it may be a good idea to get a copy beforehand although the web logs are secondary to the ColdFusion logs.) 1/ Go into the site as an actual user and create a "script" of a fairly intensive user session. Again depending on the stress testing tool you are using you may be able to create several of these scripts and use them simultaneously. 2/ After creating the script's) clear out the logs and begin testing using your stress tool. Keep watching the logs, also use any ColdFusion and OS performance measuring indicators at the same time as running the tests. Keep reading the logs. 3/ Build up the number of simultaneous users until the site breaks (if you are very lucky it won't but experience tells me it will). Again watch the logs and all indicators as you go through this. Look at the error messages in the logs to determine what caused the site to break. 4/ Fix the problems step down your number of users and start again with your stress tool test. Repeat this process until the site performs well to a level of at least 100 users. If you need physical help with this process please let me know. Webapper consists of 3 ex Allaire/Macromedia consultants and we may be able to help you. Otherwise I hope this will be of assistance to you and any others who may be interested. Mike Brunt Webapper Lab1 http://www.webapper.com "Webapper Making the NET_Work" -Original Message- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:57 PM To: CF-Talk Subject: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0. Hi, We have a Content Management system which is completely coded and tested by the Coders during development. The system is written in ColdFusion and methodology is: FuseBox3.0 . Does any one have any idea how do I do this Testing so that it catches the maximum errors from the system. Does any one have any articles written on this. If so, Can you share the link with me. Thanks in advance. Sudheer Chakka. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0.
get no more than 5 people non-technical or juniors and start using it. On Mon, 15 Apr 2002, Chakka, Sudheer wrote: > Hi, > > We have a Content Management system which is completely coded and > tested by the Coders during development. > > The system is written in ColdFusion and methodology is: FuseBox3.0 . > > Does any one have any idea how do I do this Testing so that it catches the > maximum errors from the system. > > Does any one have any articles written on this. If so, Can you share the > link with me. > > > Thanks in advance. > Sudheer Chakka. > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0.
I have always found the best way is to get non-developers to go through the site, use the system and write down things as they happen. People who have never seen the site before. Don't give them any more direction than you would the client, and let them go. At 03:57 PM 4/15/2002 -0500, you wrote: >Hi, > > We have a Content Management system which is completely coded and >tested by the Coders during development. > >The system is written in ColdFusion and methodology is: FuseBox3.0 . > >Does any one have any idea how do I do this Testing so that it catches the >maximum errors from the system. > >Does any one have any articles written on this. If so, Can you share the >link with me. > > >Thanks in advance. >Sudheer Chakka. > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Any ideas on how to do this please?
Yes please as well I'd really like to look at your code and see if if it will help get this system going. Thanks Mike Peters NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz Need I say .. Yes please! Aidan Whitehall generously and thoughtfully sent me a calendar app, and t hat does part of what I need, and will be perfect for another project on this same site that's a bit further down on my "to do" list, but Sandy, what you're doing sounds like what I'm trying to do. I'd really like to look at your code. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 1:28 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? I wrote a program to batch schedule prize giveaways on a specific basis. Took the outlook re-curring calendar program and modeled it on that. Basically what I did, was once the user chose how they wanted to repeat t he occurance, I then generated the dates and inserted a record for each specific date in the database. I'll have to dig up the code on how I did it, if anyone is interested. You can see a demo of the item at www.prizetrack.com Click on the Demo login button, Go into administrati ve, prizes. Choose a prize from a list, scroll down and choose Batch under Schedules. Ignore the window that keeps popping up, (this is a demo afte r all). I'll try to dig up the code and post it for those who are interested. -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 1:45 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Hi folks The New Zealand Ecological Restoration Network Website at www.bush.org.nz is currently being moved over to ColdFusion. ColdFusion is a great tool! We have the same need with events having patterns. Our solution so far is to have a one form for one off events and another for regular events with a pattern. The data goes back into one table. There is a second table for the specific occurance. A volunteer manually enters all the repeat occurances of a regular event. Its a real hassle. Would be nice to be able to automate this too Mike Peters Volunteer Developer NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where th
Re: Any ideas on how to do this please?
And now we go WAY OT... Just saw the Victoria referencewelll I'm in the other Victoria...Victoria, British Columbia, Canada (near Seattle for those in the US) ;-) Hello Down Under and now back to your regular scheduled CFing ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 01, 2002 6:47 PM Subject: RE: Any ideas on how to do this please? > To you too Mike, I am in Victoria so I am not affected but I feel for > those that do live in those areas. > > I actually did something similar for Siemens Corporation about 2 years > ago, for their intranet. Mike I would use three filed one to decide the > date it was created, then the type (which could be a list) to determine > the period the event needs to be displayed and maybe one so that it > can't be displayed past this date. > > The other thing to keep in mind that each event can be located in one > table, then use a unique user ID that would then identify who the event > belongs to as well. Sorry seeing words on a screen really doesn't help, > but hopefully we can help you out more. > > > > -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 2 January 2002 1:22 AM > To: CF-Talk > Subject: RE: Any ideas on how to do this please? > > Andrew, Kym, thanks for your interest in my problem. Happy New Year to > y > ou. > I'm not sure where in Oz you are Andrew, but I hope neither of you are > be > ing > barbecued right now in Sydney. It's a worry for me out here in Windsor, > > but > thankfully we haven't been directly threatened by the fire yet, although > some of our friends have had to evacuate their homes up in Kurrajong. > > > The site in question is www.bluegrass.org.au .. it's a directory of > bluegrass music and events in Australia. At the moment I'm keeping it > up > to > date by editing all the pages myself, using simple html for the most > part. > (there are some dynamic aspects to the site but the events listings are > a > ll > manually created). > > Single events, like a concert, I have set up ok. I enter the location > an > d > other details and the date in my SQL database and the listing appears in > > the > relevant state pages and disappears after the event is over. > > Now I want to do a similar thing with regular events, such as monthly > association meetings, or regular jam sessions (which could be on the > seco > nd > Tuesday of the month say) and I want to allow people around the country > t > hat > I authorise to be able to update listings in their areas. So this > mean > s I > cant have it with all these people (with greater or lesser > understandings > of > html) tinkering with the pages directly. I have to do it by giving them > > a > form and the database to get the dynamic updates happening. > > So I'd like to give them a form where they can enter the location and > tim > es > and other details of the event, and for the date, let them choose either > specific dates, or a pattern, such as "monthly on the first Friday" or > "fortnightly on Saturday" IT's this aspect I'm not sure how to do. > > In my processing of the form, should I insert these "monthly on the > first > Friday" details into the database or convert them to specific dates at > th > at > time. > > Or should I pull these events out every time the page is called, and > work > out what events are coming up in the next month, based on the specific > da > te > listings, and the periodic listings? > > Does that make it clearer? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Kym Kovan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 31, 2001 1:04 PM > To: CF-Talk > Subject: Re: Any ideas on how to do this please? > > Hi Mike, > > >I am embarking on a sub-project to allow suitably authorised users to > in > put > >events to my web site, to be displayed a month before the event > happens, > and > >automatically deleted after the event is over. I want the users to be > a > ble > >to put in an event as being held on a specific date, weekly, every two > >weeks, every month, on the third Friday of the month etc. > > I am a bit like Andrew, I would like to know more abou
RE: Any ideas on how to do this please?
Need I say .. Yes please! Aidan Whitehall generously and thoughtfully sent me a calendar app, and t hat does part of what I need, and will be perfect for another project on this same site that's a bit further down on my "to do" list, but Sandy, what you're doing sounds like what I'm trying to do. I'd really like to look at your code. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 1:28 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? I wrote a program to batch schedule prize giveaways on a specific basis. Took the outlook re-curring calendar program and modeled it on that. Basically what I did, was once the user chose how they wanted to repeat t he occurance, I then generated the dates and inserted a record for each specific date in the database. I'll have to dig up the code on how I did it, if anyone is interested. You can see a demo of the item at www.prizetrack.com Click on the Demo login button, Go into administrati ve, prizes. Choose a prize from a list, scroll down and choose Batch under Schedules. Ignore the window that keeps popping up, (this is a demo afte r all). I'll try to dig up the code and post it for those who are interested. -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 1:45 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Hi folks The New Zealand Ecological Restoration Network Website at www.bush.org.nz is currently being moved over to ColdFusion. ColdFusion is a great tool! We have the same need with events having patterns. Our solution so far is to have a one form for one off events and another for regular events with a pattern. The data goes back into one table. There is a second table for the specific occurance. A volunteer manually enters all the repeat occurances of a regular event. Its a real hassle. Would be nice to be able to automate this too Mike Peters Volunteer Developer NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "m
RE: Any ideas on how to do this please?
I wrote a program to batch schedule prize giveaways on a specific basis. Took the outlook re-curring calendar program and modeled it on that. Basically what I did, was once the user chose how they wanted to repeat the occurance, I then generated the dates and inserted a record for each specific date in the database. I'll have to dig up the code on how I did it, if anyone is interested. You can see a demo of the item at www.prizetrack.com Click on the Demo login button, Go into administrative, prizes. Choose a prize from a list, scroll down and choose Batch under Schedules. Ignore the window that keeps popping up, (this is a demo after all). I'll try to dig up the code and post it for those who are interested. -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 1:45 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Hi folks The New Zealand Ecological Restoration Network Website at www.bush.org.nz is currently being moved over to ColdFusion. ColdFusion is a great tool! We have the same need with events having patterns. Our solution so far is to have a one form for one off events and another for regular events with a pattern. The data goes back into one table. There is a second table for the specific occurance. A volunteer manually enters all the repeat occurances of a regular event. Its a real hassle. Would be nice to be able to automate this too Mike Peters Volunteer Developer NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "monthly on the first Friday" details into the database or convert them to specific dates at th at time. Or should I pull these events out every time the page is called, and work out what events are coming up in the next month, based on the specific da te listings, and the periodic listings? Does that make it clearer? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:04 PM To: CF-Talk Subject: Re: Any ideas on how to do this please? Hi Mike, >I am embarking on a sub-project to all
RE: Any ideas on how to do this please?
Hi folks The New Zealand Ecological Restoration Network Website at www.bush.org.nz is currently being moved over to ColdFusion. ColdFusion is a great tool! We have the same need with events having patterns. Our solution so far is to have a one form for one off events and another for regular events with a pattern. The data goes back into one table. There is a second table for the specific occurance. A volunteer manually enters all the repeat occurances of a regular event. Its a real hassle. Would be nice to be able to automate this too Mike Peters Volunteer Developer NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "monthly on the first Friday" details into the database or convert them to specific dates at th at time. Or should I pull these events out every time the page is called, and work out what events are coming up in the next month, based on the specific da te listings, and the periodic listings? Does that make it clearer? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:04 PM To: CF-Talk Subject: Re: Any ideas on how to do this please? Hi Mike, >I am embarking on a sub-project to allow suitably authorised users to in put >events to my web site, to be displayed a month before the event happens, and >automatically deleted after the event is over. I want the users to be a ble >to put in an event as being held on a specific date, weekly, every two >weeks, every month, on the third Friday of the month etc. I am a bit like Andrew, I would like to know more about the thing in term s of size, business of the servers, etc. You can do more work in CF and put a set of events in the DB but it will be bigger as a result but the queries a lot simpler compared with calculating it on the fly every time. BTW if you are showing the event for a month before, then clearing it, ho w are you going to handle a weekly event :^) -- Yours, Kym __ Get Your Own Dedicated Windows 2000 Server PIII 8
RE: Any ideas on how to do this please?
To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "monthly on the first Friday" details into the database or convert them to specific dates at th at time. Or should I pull these events out every time the page is called, and work out what events are coming up in the next month, based on the specific da te listings, and the periodic listings? Does that make it clearer? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:04 PM To: CF-Talk Subject: Re: Any ideas on how to do this please? Hi Mike, >I am embarking on a sub-project to allow suitably authorised users to in put >events to my web site, to be displayed a month before the event happens, and >automatically deleted after the event is over. I want the users to be a ble >to put in an event as being held on a specific date, weekly, every two >weeks, every month, on the third Friday of the month etc. I am a bit like Andrew, I would like to know more about the thing in term s of size, business of the servers, etc. You can do more work in CF and put a set of events in the DB but it will be bigger as a result but the queries a lot simpler compared with calculating it on the fly every time. BTW if you are showing the event for a month before, then clearing it, ho w are you going to handle a weekly event :^) -- Yours, Kym __ 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: Any ideas on how to do this please?
If I were doing this, I would allow them to choose the dates and not do t he first friday thing. This will save much aggrevation on your part as far a s date manipulation goes. You could give them the option of start date and end date and maybe use a JS calendar for them to choose dates from. There is several in allaires tag gallery which have username/passowrd ability etc. There are two major products that come out of Berkeley: LSD and [Unix] BS D. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 01, 2002 6:22 AM Subject: RE: Any ideas on how to do this please? > Andrew, Kym, thanks for your interest in my problem. Happy New Year to y > ou. > I'm not sure where in Oz you are Andrew, but I hope neither of you are be > ing > barbecued right now in Sydney. It's a worry for me out here in Windsor , > but > thankfully we haven't been directly threatened by the fire yet, althoug h > some of our friends have had to evacuate their homes up in Kurrajong. > > > The site in question is www.bluegrass.org.au .. it's a directory of > bluegrass music and events in Australia. At the moment I'm keeping it up > to > date by editing all the pages myself, using simple html for the most pa rt. > (there are some dynamic aspects to the site but the events listings are a > ll > manually created). > > Single events, like a concert, I have set up ok. I enter the location an > d > other details and the date in my SQL database and the listing appears i n > the > relevant state pages and disappears after the event is over. > > Now I want to do a similar thing with regular events, such as monthly > association meetings, or regular jam sessions (which could be on the se co > nd > Tuesday of the month say) and I want to allow people around the country t > hat > I authorise to be able to update listings in their areas. So this me an > s I > cant have it with all these people (with greater or lesser understandin gs > of > html) tinkering with the pages directly. I have to do it by giving the m > a > form and the database to get the dynamic updates happening. > > So I'd like to give them a form where they can enter the location and t im > es > and other details of the event, and for the date, let them choose eithe r > specific dates, or a pattern, such as "monthly on the first Friday" or > "fortnightly on Saturday" IT's this aspect I'm not sure how to do. > > In my processing of the form, should I insert these "monthly on the fir st > Friday" details into the database or convert them to specific dates at th > at > time. > > Or should I pull these events out every time the page is called, and wo rk > out what events are coming up in the next month, based on the specific da > te > listings, and the periodic listings? > > Does that make it clearer? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Kym Kovan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 31, 2001 1:04 PM > To: CF-Talk > Subject: Re: Any ideas on how to do this please? > > Hi Mike, > > >I am embarking on a sub-project to allow suitably authorised users to in > put > >events to my web site, to be displayed a month before the event happen s, > and > >automatically deleted after the event is over. I want the users to be a > ble > >to put in an event as being held on a specific date, weekly, every tw o > >weeks, every month, on the third Friday of the month etc. > > I am a bit like Andrew, I would like to know more about the thing in te rm > s > of size, business of the servers, etc. You can do more work in CF and p ut > a > set of events in the DB but it will be bigger as a result but the queri es > a > lot simpler compared with calculating it on the fly every time. > > BTW if you are showing the event for a month before, then clearing it, ho > w > are you going to handle a weekly event :^) > > > -- > > Yours, > > Kym > > __ 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: Any ideas on how to do this please?
Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "monthly on the first Friday" details into the database or convert them to specific dates at th at time. Or should I pull these events out every time the page is called, and work out what events are coming up in the next month, based on the specific da te listings, and the periodic listings? Does that make it clearer? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:04 PM To: CF-Talk Subject: Re: Any ideas on how to do this please? Hi Mike, >I am embarking on a sub-project to allow suitably authorised users to in put >events to my web site, to be displayed a month before the event happens, and >automatically deleted after the event is over. I want the users to be a ble >to put in an event as being held on a specific date, weekly, every two >weeks, every month, on the third Friday of the month etc. I am a bit like Andrew, I would like to know more about the thing in term s of size, business of the servers, etc. You can do more work in CF and put a set of events in the DB but it will be bigger as a result but the queries a lot simpler compared with calculating it on the fly every time. BTW if you are showing the event for a month before, then clearing it, ho w are you going to handle a weekly event :^) -- Yours, Kym __ 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: Any ideas on how to do this please?
Hi Mike, >I am embarking on a sub-project to allow suitably authorised users to input >events to my web site, to be displayed a month before the event happens, and >automatically deleted after the event is over. I want the users to be able >to put in an event as being held on a specific date, weekly, every two >weeks, every month, on the third Friday of the month etc. I am a bit like Andrew, I would like to know more about the thing in terms of size, business of the servers, etc. You can do more work in CF and put a set of events in the DB but it will be bigger as a result but the queries a lot simpler compared with calculating it on the fly every time. BTW if you are showing the event for a month before, then clearing it, how are you going to handle a weekly event :^) -- Yours, Kym __ 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: Any ideas on how to do this please?
Mike I am not sure I understand it, but wouldn't it be easier to store the creation date, then the type of event (weekly, monthly etc) then do a routine check on the DB to see if the date has passed and not pull it out. CF has many date functions that will allow the ability to get the day of the week or even the week number etc. So for instance if the event is to be held on a Wednesday then store this and do a check for this week day number! I would need to know more about the project, but from the information provided this is what I would do. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 12:31 PM To: CF-Talk Subject: Any ideas on how to do this please? I am embarking on a sub-project to allow suitably authorised users to input events to my web site, to be displayed a month before the event happens, and automatically deleted after the event is over. I want the users to be able to put in an event as being held on a specific date, weekly, every two weeks, every month, on the third Friday of the month etc. How would I handle these options? I know about how to do the specific date one, but for say the monthly events, do you think I should take their input and process it to enter 12 event records for the year, or do that processing at the time of displaying the event? How would I process "the second Wednesday of the month" into a specific date? Since this is a pro bono site for a small hobby club, I'm not able to buy a calendar app, but is there a freeware tag that can handle this kind of thing? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks 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 __ 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: any ideas?
That's a very, very nice idea. For a bit more added speed though, use array assignment (given longer list or number of rows). ... ... Your solution is quite elegant Scott, I just added it to my bag of tricks :) Thanks. As a side note, you can also do alternating rows by CSS as defined by W3C. In praticallity though no browser I'm aware of supports it properly. -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: January 19, 2001 13:14 To: CF-Talk Subject: Re: any ideas? Or... (up higher in the file) Then --Scott - Original Message - From: "Russel Madere" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 7:53 AM Subject: RE: any ideas? > Use: > > > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: Jay Patton [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 17, 2001 14:52 > > To: CF-Talk > > Subject: any ideas? > > > > > > does anyone know how i can make this tag output 3 colors instead of 2? > > > > > > > > thanks, > > > > Jay Patton > > Web Pro USA > > 406.549.3337 ext. 203 > > 1.888.5WEBPRO > > 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: any ideas?
Or... (up higher in the file) Then --Scott - Original Message - From: "Russel Madere" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 7:53 AM Subject: RE: any ideas? > Use: > > > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: Jay Patton [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 17, 2001 14:52 > > To: CF-Talk > > Subject: any ideas? > > > > > > does anyone know how i can make this tag output 3 colors instead of 2? > > > > > > > > thanks, > > > > Jay Patton > > Web Pro USA > > 406.549.3337 ext. 203 > > 1.888.5WEBPRO > > 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: any ideas?
Use: Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 17, 2001 14:52 > To: CF-Talk > Subject: any ideas? > > > does anyone know how i can make this tag output 3 colors instead of 2? > > > > thanks, > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > 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: any ideas?
Jay, How about the following nested Iif statement? I don't exactly understand what your conditions/results are, but I use this sort of 3-way If statement all the time in Excel. An example: MyVal LT 5, return "< 5" MyVal GTE 5, AND LTE 10 return "5-10" MyVal GT 10, return "> 10" And you can, of course, keep nesting as deep as you want. Great in Excel, where you must put all the processing in a single formula (unless you write a VBA macro). Maybe it gets a little confusing here, though, where the visually clearer CFIF statements are an option. Hope this helps, Matthieu > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 17, 2001 3:52 PM > To: CF-Talk > Subject: any ideas? > > > does anyone know how i can make this tag output 3 colors instead of 2? > > > > thanks, > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > 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: any ideas?
No b/c IIF() is a true/false evaluation. Mod 3 would simply be the two colours in a false, true, true arrangement. -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: January 17, 2001 23:24 To: CF-Talk Subject: RE: any ideas? Wouldn't changing the mod 2 to mod 3 do the trick:-) regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 07:52 To: CF-Talk Subject: any ideas? does anyone know how i can make this tag output 3 colors instead of 2? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO 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: any ideas?
Wouldn't changing the mod 2 to mod 3 do the trick:-) regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 07:52 To: CF-Talk Subject: any ideas? does anyone know how i can make this tag output 3 colors instead of 2? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO 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: any ideas?
IIF in an Inline IF statement, so only has boolean TRUE and FALSE (ie.
two states). If you want to vary between more use a switch/case setup again
dependent on the mod and rowcount. The nicest thing about the iif() is it's
inline and clean looking in your code; any type of if/elseif or switch
statments are either going to be slightly removed from the line or not look
as nice... but they work.
// determine row colour based on mod of current query row
switch (DirList.CurrentRow mod 3) {
case 0:
colour = "e7" ;
break;
case 1:
colour = "fafafa" ;
break;
case 2:
colour = "a1a1a1" ;
break;
}
If you want gradients of a single colour you could also use mod to
generate it mathmatically, instead of a sub type operation.
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: January 17, 2001 15:52
To: CF-Talk
Subject: any ideas?
does anyone know how i can make this tag output 3 colors instead of 2?
thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
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
