RE: Use a list in where clause?
Or better:
IN ()
-Oorspronkelijk bericht-
Van: Justin Scott [mailto:[EMAIL PROTECTED]]
Verzonden: vr 14/02/2003 8:12
Aan: CF-Talk
CC:
Onderwerp: Re: Use a list in where clause?
> WHERE SubscriberAddress.state IN ('#FORM.EmailState#')
IN (#listQualify(FORM.EmailState, "'")#)
-Justin Scott
~|
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: best way to enter currency format
> and might as well handle some of this on your input form > with either cfform or some js validation. Personally, I never rely on JavaScript for validating input unless I know that the application will only be used in a semi-controlled environment, such as an Intranet where browsers are standardized. IIRC 10% of users browse with JS disabled or unsupported, but I don't know how accurate that is. In my opinion, input validation should first be coded on the server-side, and then in JS if you have the time/ability to do so. Especially in cases like this where data is headed for a database and could cause an error to be thrown if not formatted properly. -Justin Scott ~| 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: best way to enter currency format
> This will strip out anything but numbers and periods. You will probably > want to also test for multiple periods before inserting, and possibly the > number of digits after the period as well to ensure valid data. and might as well handle some of this on your input form with either cfform or some js validation. ~| 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: Use a list in where clause?
> WHERE SubscriberAddress.state IN ('#FORM.EmailState#')
IN (#listQualify(FORM.EmailState, "'")#)
-Justin Scott
~|
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: best way to enter currency format
> not sure how to strip out the non numbers from the form field? > do u off hand know of any articles or tuts on it?? This will strip out anything but numbers and periods. You will probably want to also test for multiple periods before inserting, and possibly the number of digits after the period as well to ensure valid data. #field# Result: 1000.00 -Justin Scott ~| 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
Use a list in where clause?
Dear listmembers,
Help. Sorry for the possible OT (it's a CF site) but I'm really stuck. I
have an issue between SQL syntax and whether or not to use a list or
straight form value in the query. I have not been able to get it working
either way so far.
I have a form that submits to an action page. the form has a multiple
select for states. The value carried when multiple are selected is like
this CA,AR,AK etc. This field is named 'EmailState' on the form. On the
action page I want to select entries from tables where addresses are in
the states selected.
My membership (IN) filter is not returning the desired values...but I
was certain it was correct (below). Also, should I put this into a list
before using it in the query? I would greatly appreciate any fresh
thoughts or input. Here is my query, the database is SQL Server 2000 and
CF5.
SELECT Subscribers.SubscriberID, Subscribers.EMail
FROM (Subscribers INNER JOIN SubscriberAddress ON
(Subscribers.SubscriberID = SubscriberAddress.ASubscriberID))
WHERE SubscriberAddress.state IN ('#FORM.EmailState#')
Best Regards,
Tony Gruen
~|
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: best way to enter currency format
meaning use currency in the db? i have tried that but i get an error but will try again not sure how to strip out the non numbers from the form field? do u off hand know of any articles or tuts on it?? thanks! Dave - Original Message - From: <[EMAIL PROTECTED] (Paul Hastings)> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 1:17 AM Subject: Re: best way to enter currency format > > (say user is bidding $1,000.00) > > $1,000.00 > > $1,000 > > $1000 > > 1,000.00 > > 1,000 > > 1000 > > use currency datatype on the backend. strip out any "$" & "," from form > input. use dollarformat or whatever to display. > > ~| 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: best way to enter currency format
> (say user is bidding $1,000.00) > $1,000.00 > $1,000 > $1000 > 1,000.00 > 1,000 > 1000 use currency datatype on the backend. strip out any "$" & "," from form input. use dollarformat or whatever to display. ~| 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: Update Multiple Records With One Query
Jillian,
I looked over your code and notice you have your update query on the same
page as your form, yet your form's action page is set to
"grading.cfm?id=#courses.id#." If you move that chunk of code to
grading.cfm, all should work fine...and you shouldn't need to use url.action
or form.action variables.
BTW, just to be on the safe side, *all* of the form parameters used in your
update query should be wrapped with CFQUERYPARAM...but you already have a
good start on that.
~Dina
- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 10:32 PM
Subject: RE: Update Multiple Records With One Query
> Even better - thanks Dave!
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
>
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to [EMAIL PROTECTED]
>
> *
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 11:30 PM
> To: CF-Talk
> Subject: RE: Update Multiple Records With One Query
>
>
> > Try this for your UPDATE routine (adding your remaining
> > fields as needed):
> >
> >
> >
> >
> > UPDATE attendee SET
> > assigneddate ='#evaluate("form.assigneddate#Indx#")#',
> > attended = '#evaluate("form.attended#Indx#")#'
> > WHERE users_id = #evaluate("form.ID#Indx#")#
> >
> >
> >
>
> Just to nitpick, you don't need to use Evaluate here, and you don't need
> so many hashes:
>
> ... SET assigneddate = '#Form["assigneddate" & Indx]#', ...
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
>
~|
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: Developer Edition IP address
Dick Applebaum wrote >OK, just so I am clear on this. >With DevNet, for $1500/year I get: > ... ... If you have a copy of CF Studio 4.5 or 5, that price is $1199. How many of us on this list have one of those? :) I just bought a copy of Flash MX strictly to start learning the thing. Bah! Ah well, I don't have twelve hundred US to throw around right now, anyway. But that's a *killer* deal. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 7:38 PM To: CF-Talk Subject: Re: Developer Edition IP address On Thursday, February 13, 2003, at 07:28 AM, Christian Cantrell wrote: > > Supporting 5 or 10 IPs would mean the software could easily be used in > an internal production environment, like an intranet where access is > restricted and IPs don't change. Our response to this issue was the > DevNet subscription server license. The servers that come packaged > with DevNet Professional are not technically limited at all, and can be > used in any way that is consistent with the EULA, which includes > testing by multiple clients and demonstrations OK, just so I am clear on this. With DevNet, for $1500/year I get: --- CFMX J2EE Mac OS X (Unlimited IP, Development Only License) --- JRun Mac OS X (full featured, Development Only License) --- CFMX Standalone Enterprise Non Mac OS X (Unlimited IP, Development Only License) --- All the other good stuff. Am I reading this correctly? If so, that is reasonable! Dick ~| 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
best way to enter currency format
in this auction app i cant find a reasonable solution for the handling of the bids. I have been sitting here messing with a lot of the tags and it seems to me that they are very dependant on how the info was entered. With of course means that i need to format it going into the db and possibly coming out. will be using a ms access db. And yes I have tried to set the bid field to currency which just throws an error. And I cant format it coming out of the db unless the entries are in the same form going into the db. So is there a tag i have missed that would format it going in? understanding that some people might place bids in the following ways: (say user is bidding $1,000.00) $1,000.00 $1,000 $1000 1,000.00 1,000 1000 any thoughts? dave ~| 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?
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
MXDU (MX DownUnder conference) - 19-20 Feb 2003 - Sydney Australi a
Is anyone else in this list attending the MXDU conference? (http://mxdu.com). Cheers! == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| 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: Is this a good Idea? RE: Cflogin
> As an overall question, what is the general feeling > regarding the use of CFMX built-in security as opposed > to coding our own application security mechanism with > regard to flexibility - transparency etc? I can only speak for myself, but in general, I'm pretty happy with the CFLOGIN framework. It's especially nice to be able to tie it into functions within CFCs. My only real complaint with it is its forced dependency on cookies; I'd like to be able to use a URL parameter instead. Maybe you can, actually, but I haven't seen an obvious way to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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: Update Multiple Records With One Query
Even better - thanks Dave!
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 11:30 PM
To: CF-Talk
Subject: RE: Update Multiple Records With One Query
> Try this for your UPDATE routine (adding your remaining
> fields as needed):
>
>
>
>
> UPDATE attendee SET
> assigneddate ='#evaluate("form.assigneddate#Indx#")#',
> attended = '#evaluate("form.attended#Indx#")#'
> WHERE users_id = #evaluate("form.ID#Indx#")#
>
>
>
Just to nitpick, you don't need to use Evaluate here, and you don't need
so many hashes:
... SET assigneddate = '#Form["assigneddate" & Indx]#', ...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~|
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: Verity and Clustered Servers: more basic view
> Ok, maybe we can solve this a little bit at a time. Can > anyone think of a reason why cold fusion would not be > able to create a verity collection in a folder but it > is able to write a file or create a directory in the > same? Not really. What kind of error are you seeing? If it's a permissions issue, you might try running Sysinternal's FILEMON to see what's causing the problem. Is the directory on a local drive, or a network drive? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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: Verity collections of a database
First you write a to retrieve the data you want to index. You then use this query to pass to which indexes the records as though they were physical files. You must also tell Verity which column in the query should be a "filename", which should be a "title" and which column or columns should be the actual "body". Eg: SELECT UserID, UserName, UserPassword, UserEmailAddress, UserFirstName, UserLastName, UserDetails FROM Users Then: Indexing completed... That's pretty much it! You can then use like this: #SearchResults.RecordCount# users found for "#Form.SearchCriteria#". #NumberFormat(Round(Score * 100))#% #UserName# #Summary# You can also reference Key, Custom1 and Custom2 fields. Key for example could be used to link to another page: #NumberFormat(Round(Score * 100))#% #UserName# #Summary# Hope this helps. The excellent "The Complete Reference: ColdFusion MX", "Mastering ColdFusion MX" and "Macromedia ColdFusion MX Web Application Construction Kit" follow this in more detail. == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February 2003 8:58 AM To: CF-Talk Subject: Verity collections of a database Can someone explain to me how to create a verity collection of data that is stored in a database. I am very interested in this but have not been able to find anything except file verity. Thanks in advance Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| 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: Update Multiple Records With One Query
> Try this for your UPDATE routine (adding your remaining
> fields as needed):
>
>
>
>
> UPDATE attendee SET
> assigneddate ='#evaluate("form.assigneddate#Indx#")#',
> attended = '#evaluate("form.attended#Indx#")#'
> WHERE users_id = #evaluate("form.ID#Indx#")#
>
>
>
Just to nitpick, you don't need to use Evaluate here, and you don't need so
many hashes:
... SET assigneddate = '#Form["assigneddate" & Indx]#', ...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~|
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: another pair of eyes on this CFScript, please
Sorry, typo ... The first line of the script should look like:
function removeItem(myarray,rem){
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 11:08 PM
To: CF-Talk
Subject: RE: another pair of eyes on this CFScript, please
1. VAR your counter variable (i) - just for good measure.
2. To use variables inside a function you have to either pass them in or
create them in the function. So most likely CART and URL.REMOVE aren't
available to the function. You'll need to pass them both to the function
to use them.
3. After you change the array, you'll need to pass it back out to the
template as its been updated and its length has been changed by
ArrayDeleteAt()
Try this:
function removeItem(array,rem){
var i=1;
var removeprice = 0;
for(i=1; i lte arrayLen(myarray); i=i+1) {
if (myarray[i].ITEM_ID IS rem) {
removeprice=myarray[i].PRICE;
ArrayDeleteAt(myarray, i);
break;
}
}
return myarray;
}
Call it with something like:
cart=removeItem(cart,url.remove);
That should allow you to pass in your array and removal item, remove the
item if necessary and then pass back out the updated array.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net [EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: "Owens [mailto:"Owens]
Sent: Thursday, February 13, 2003 10:35 PM
To: CF-Talk
Subject: another pair of eyes on this CFScript, please
Here it is:
function removeItem(){
var removeprice = 0;
for(i=1; i lte arrayLen(cart); i=i+1) {
if (cart[i].ITEM_ID IS url.remove) {
removeprice=cart[i].PRICE;
ArrayDeleteAt(cart, i);
break;
}
}
}
As near as I can tell, nothing inside the "for" loop is executing.
I've tried replacing arrayLen with a hard variable, I've tried GTE ...
but if take everything out and do a writeout(), nothing appears. If I
do the writeoutput outside of the for loop, then it works. I've checked
the size of the arrayLen just prior to the loop, and it reads the
expected value.
It's the strangest thing ... this was working. I don't believe I
changed anything. Then it stopped working.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956 ~~
~|
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: Developer Edition IP address
Jeeze! There is a CF that I can (finally) buy for OS X -- guess you guys called my bluff :) Guess I need to save my pennies until it is available (March). Will you guys take an Estonian Diner's Card? Seriously, this seems to be the answer where everyone benefits: MM supports developers by offering a "Developer's Package" Developers supportort MM by subscribing I'll play! --- 'course if I could deploy on a Mac. Dick On Thursday, February 13, 2003, at 07:55 PM, Christian Cantrell wrote: > You are correct. I'm sure you have already seen this, but just in > case, you can see everything you get here: > > http://www.macromedia.com/desdev/subscriptions/levelsfeatures.html > > It's an extremely reasonable deal. Clearly it's not for everyone, but > if you use any number of these tools, the numbers start to make sense > pretty quickly. > > Christian > > On Thursday, February 13, 2003, at 10:38 PM, Dick Applebaum wrote: > >> On Thursday, February 13, 2003, at 07:28 AM, Christian Cantrell >> wrote: >> >>> >>> Supporting 5 or 10 IPs would mean the software could easily be used >>> in >>> an internal production environment, like an intranet where access is >>> restricted and IPs don't change. Our response to this issue was the >>> DevNet subscription server license. The servers that come packaged >>> with DevNet Professional are not technically limited at all, and can >>> be >>> used in any way that is consistent with the EULA, which includes >>> testing by multiple clients and demonstrations >> >> OK, just so I am clear on this. >> >> With DevNet, for $1500/year I get: >> >> --- CFMX J2EE Mac OS X (Unlimited IP, Development Only License) >> >> --- JRun Mac OS X (full featured, Development Only License) >> >> --- CFMX Standalone Enterprise Non Mac OS X (Unlimited IP, >> Development >> Only License) >> >> --- All the other good stuff. >> >> Am I reading this correctly? >> >> If so, that is reasonable! >> >> Dick >> >> > ~| 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: Update Multiple Records With One Query
Try this for your UPDATE routine (adding your remaining fields as
needed):
UPDATE attendee SET
assigneddate ='#evaluate("form.assigneddate#Indx#")#',
attended = '#evaluate("form.attended#Indx#")#'
WHERE users_id = #evaluate("form.ID#Indx#")#
Also, I don't think these will do you much good - you never actually use
FORM objects by these names do you? They should all have the INDEX
appended to the end of the variable name to make default values:
Should look more like:
That will create defaults for all of those values for each index.
Hope this helps.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 9:33 PM
To: CF-Talk
Subject: Update Multiple Records With One Query
What I'm trying to do is take a query of all my students, and update
their grades, record by record and then submit them all with one submit
button at the end. I think I'm getting close with the code I have
(thanks to some folks off the list), but it's still not working...
everything I try seems to make it worse.
Anybody able to offer some insight?
--
Jillian
Here is my code:
SELECT id, centraladmin, provadmin, trainer
FROM users
WHERE id = #client.id#
SELECT * from courses WHERE id = #url.id#
SELECT attendee.*, users.id AS users_id, users.lname,
users.fname
FROMattendee, users
WHERE attendee.assigneddate = #url.id# and users.id
=attendee.users_id
ORDER BYusers.lname, users.fname ASC
SELECT * FROM caeyear ORDER BY year DESC
SELECT * FROM payment
SELECT * FROM postassign
UPDATE attendee
SET assigneddate =
'#Trim(Form[assigneddate & Indx])#',
attended = '#Trim(Form[attended
& Indx])#',
withdrawn =
'#Trim(Form[withdrawn & Indx])#',
paymentmethod =
'#Trim(Form[paymentmethod & Indx])#',
paymentcleared =
'#Trim(Form[paymentcleared & Indx])#',
authnum = '#Trim(Form[authunum &
Indx])#',
assignrec1 =
'#Trim(Form[assignrec1 & Indx])#',
assignrec2 =
'#Trim(Form[assignrec2 & Indx])#',
assignrec3 =
'#Trim(Form[assignrec3 & Indx])#',
pretest = '#Trim(Form[pretest &
Indx])#',
writtentest1 =
'#Trim(Form[writtentest1 & Indx])#',
writtentest2 =
'#Trim(Form[writtentest2 & Indx])#',
writtentest3 =
'#Trim(Form[writtentest3 & Indx])#',
skilltest1 =
'#Trim(Form[skilltest1 & Indx])#',
skilltest2 =
'#Trim(Form[skilltest2 & Indx])#',
skilltest3 =
'#Trim(Form[skilltest3 & Indx])#',
postassign =
'#Trim(Form[postassign & Indx])#',
adminnote =
'#Trim(Form[adminnote & Indx])#'
confsent = ,
regreceived = ,
pkgsentdate = ,
RE: another pair of eyes on this CFScript, please
1. VAR your counter variable (i) - just for good measure.
2. To use variables inside a function you have to either pass them in or
create them in the function. So most likely CART and URL.REMOVE aren't
available to the function. You'll need to pass them both to the function
to use them.
3. After you change the array, you'll need to pass it back out to the
template as its been updated and its length has been changed by
ArrayDeleteAt()
Try this:
function removeItem(array,rem){
var i=1;
var removeprice = 0;
for(i=1; i lte arrayLen(myarray); i=i+1) {
if (myarray[i].ITEM_ID IS rem) {
removeprice=myarray[i].PRICE;
ArrayDeleteAt(myarray, i);
break;
}
}
return myarray;
}
Call it with something like:
cart=removeItem(cart,url.remove);
That should allow you to pass in your array and removal item, remove the
item if necessary and then pass back out the updated array.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: "Owens [mailto:"Owens]
Sent: Thursday, February 13, 2003 10:35 PM
To: CF-Talk
Subject: another pair of eyes on this CFScript, please
Here it is:
function removeItem(){
var removeprice = 0;
for(i=1; i lte arrayLen(cart); i=i+1) {
if (cart[i].ITEM_ID IS url.remove) {
removeprice=cart[i].PRICE;
ArrayDeleteAt(cart, i);
break;
}
}
}
As near as I can tell, nothing inside the "for" loop is executing.
I've tried replacing arrayLen with a hard variable, I've tried GTE ...
but if take everything out and do a writeout(), nothing appears. If I
do the writeoutput outside of the for loop, then it works. I've checked
the size of the arrayLen just prior to the loop, and it reads the
expected value.
It's the strangest thing ... this was working. I don't believe I
changed anything. Then it stopped working.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956 ~~
~|
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: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install?
Hey... Here's some follow-up on the "access" problem I've been encountering with some clients in password protected (using session variables) areas of websites, that seems to due to problems with IE 6.0... Rick ~| 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: Developer Edition IP address
You are correct. I'm sure you have already seen this, but just in case, you can see everything you get here: http://www.macromedia.com/desdev/subscriptions/levelsfeatures.html It's an extremely reasonable deal. Clearly it's not for everyone, but if you use any number of these tools, the numbers start to make sense pretty quickly. Christian On Thursday, February 13, 2003, at 10:38 PM, Dick Applebaum wrote: > On Thursday, February 13, 2003, at 07:28 AM, Christian Cantrell wrote: > >> >> Supporting 5 or 10 IPs would mean the software could easily be used in >> an internal production environment, like an intranet where access is >> restricted and IPs don't change. Our response to this issue was the >> DevNet subscription server license. The servers that come packaged >> with DevNet Professional are not technically limited at all, and can >> be >> used in any way that is consistent with the EULA, which includes >> testing by multiple clients and demonstrations > > OK, just so I am clear on this. > > With DevNet, for $1500/year I get: > > --- CFMX J2EE Mac OS X (Unlimited IP, Development Only License) > > --- JRun Mac OS X (full featured, Development Only License) > > --- CFMX Standalone Enterprise Non Mac OS X (Unlimited IP, Development > Only License) > > --- All the other good stuff. > > Am I reading this correctly? > > If so, that is reasonable! > > Dick > > ~| 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
another pair of eyes on this CFScript, please
Here it is:
function removeItem(){
var removeprice = 0;
for(i=1; i lte arrayLen(cart); i=i+1) {
if (cart[i].ITEM_ID IS url.remove) {
removeprice=cart[i].PRICE;
ArrayDeleteAt(cart, i);
break;
}
}
}
As near as I can tell, nothing inside the "for" loop is executing.
I've tried replacing arrayLen with a hard variable, I've tried GTE ... but
if take everything out and do a writeout(), nothing appears. If I do the
writeoutput outside of the for loop, then it works. I've checked the size
of the arrayLen just prior to the loop, and it reads the expected value.
It's the strangest thing ... this was working. I don't believe I changed
anything. Then it stopped working.
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
~|
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: Developer Edition IP address
On Thursday, February 13, 2003, at 07:28 AM, Christian Cantrell wrote: > > Supporting 5 or 10 IPs would mean the software could easily be used in > an internal production environment, like an intranet where access is > restricted and IPs don't change. Our response to this issue was the > DevNet subscription server license. The servers that come packaged > with DevNet Professional are not technically limited at all, and can be > used in any way that is consistent with the EULA, which includes > testing by multiple clients and demonstrations OK, just so I am clear on this. With DevNet, for $1500/year I get: --- CFMX J2EE Mac OS X (Unlimited IP, Development Only License) --- JRun Mac OS X (full featured, Development Only License) --- CFMX Standalone Enterprise Non Mac OS X (Unlimited IP, Development Only License) --- All the other good stuff. Am I reading this correctly? If so, that is reasonable! Dick ~| 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: Refresh error on CFMX...
On Thursday, Feb 13, 2003, at 13:07 US/Pacific, Barney Boisvert wrote: > Yeah, I get that a lot. Haven't been able to pin down any specific > cause. > Very annoying, although it only happens when code changes so it doesn't > affect production, thank god. > > Any macromedians out there with some insight? It appears to happen when CFMX's internal class file cache gets out of sync with what is on disk. As some folks noticed, if you refresh the page, the problem often goes away. I've had it happen to me once or twice but not recently. It seemed to be more common on Windows than Unix. Sorry I can't be more helpful than just confirming that "yes, there is an intermittent problem". For me, it's been very rare and I haven't seen it for a long time (I don't recall ever seeing it on my Mac so it could, possibly, be environment specific). >> -Original Message- >> From: Tyler Silcox [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, February 13, 2003 12:13 PM >> To: CF-Talk >> Subject: Refresh error on CFMX... >> >> >> Does anyone else get the following error everytime they change >> code and hit refresh? >> >> Index: 219, Size: 194 >> The Error Occurred in Z:\somedomain\fbx_fusebox30_cf50.cfm: >> line 159 ~| 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?
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: Developer Edition IP address
Christian That is a good answer -- nobody ever 'splained it like that. Well, another Crusade is lost :) Dick On Thursday, February 13, 2003, at 07:28 AM, Christian Cantrell wrote: > On Wednesday, February 12, 2003, at 05:25 PM, Dick Applebaum wrote: > >> I have requested >> (without success) that MM increase the number of external IP addresses >> to a more usable number (say 5). This would make multiple user tests >> and demos much more practical, and still wouldn't compromise the >> "Development" status of the system -- you still would need to restet >> after the 5th external IP, so it couldn't be used for production. > > Supporting 5 or 10 IPs would mean the software could easily be used in > an internal production environment, like an intranet where access is > restricted and IPs don't change. Our response to this issue was the > DevNet subscription server license. The servers that come packaged > with DevNet Professional are not technically limited at all, and can be > used in any way that is consistent with the EULA, which includes > testing by multiple clients and demonstrations. > > Christian > > ~| 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
Update Multiple Records With One Query
What I'm trying to do is take a query of all my students, and update their grades, record by record and then submit them all with one submit button at the end. I think I'm getting close with the code I have (thanks to some folks off the list), but it's still not working... everything I try seems to make it worse. Anybody able to offer some insight? -- Jillian Here is my code: SELECT id, centraladmin, provadmin, trainer FROM users WHERE id = #client.id# SELECT * from courses WHERE id = #url.id# SELECT attendee.*, users.id AS users_id, users.lname, users.fname FROMattendee, users WHERE attendee.assigneddate = #url.id# and users.id =attendee.users_id ORDER BYusers.lname, users.fname ASC SELECT * FROM caeyear ORDER BY year DESC SELECT * FROM payment SELECT * FROM postassign UPDATE attendee SET assigneddate = '#Trim(Form[assigneddate & Indx])#', attended = '#Trim(Form[attended & Indx])#', withdrawn = '#Trim(Form[withdrawn & Indx])#', paymentmethod = '#Trim(Form[paymentmethod & Indx])#', paymentcleared = '#Trim(Form[paymentcleared & Indx])#', authnum = '#Trim(Form[authunum & Indx])#', assignrec1 = '#Trim(Form[assignrec1 & Indx])#', assignrec2 = '#Trim(Form[assignrec2 & Indx])#', assignrec3 = '#Trim(Form[assignrec3 & Indx])#', pretest = '#Trim(Form[pretest & Indx])#', writtentest1 = '#Trim(Form[writtentest1 & Indx])#', writtentest2 = '#Trim(Form[writtentest2 & Indx])#', writtentest3 = '#Trim(Form[writtentest3 & Indx])#', skilltest1 = '#Trim(Form[skilltest1 & Indx])#', skilltest2 = '#Trim(Form[skilltest2 & Indx])#', skilltest3 = '#Trim(Form[skilltest3 & Indx])#', postassign = '#Trim(Form[postassign & Indx])#', adminnote = '#Trim(Form[adminnote & Indx])#' confsent = , regreceived = , pkgsentdate = , reqdate = , asthmacertdate = , taxdate = , assstratdate = , ceudate = , caeexamdate = , caestatusgaindate = , recertdate = , recertrecdate = WHERE users_id = #Form[ID & Indx]# #attendee.lname#, #attendee.fname# #attendee.id# #attendee.gradnum# #attendee.paymentmethod##payment.type#< /td> checked> Yes checked> No checked /> checked /> checked /> checked /> checked> Yes checked> No checked> Yes checked> No % % % checked /> checked /> checked /> #attendee.postassign##assign.status#
RE: JavaScript: using Submit()
First, I didn't mean to send this to the list, figuring I would just hit
Mike up with a private request ... sorry list.
Second, I solved this problem ... just pass an argument to the function --
duh!
H.
> -Original Message-
> From: "Owens>,Howard" <[EMAIL PROTECTED] [SMTP:"Owens>,Howard"
> <[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 6:24 PM
> To: CF-Talk
> Subject: RE: JavaScript: using Submit()
>
> Mike,
>
> Thanks for your help.
>
> Here's what I have:
>
>
>
> function removeSubmit() {
>
> document.removeForm.action = "index.cfm";
> document.removeForm.saction.value = "remove_cart";
> document.removeForm.CFID.value = "#URL.CFID#";
> document.removeForm.CFTOKEN.value = "#URL.CFTOKEN#";
> document.removeForm.remove.value = document.cartform.remove[0].value;
> document.removeForm.submit();
> }
>
>
>
>
>
>
>
>
>
>
> Works well, but I'm having a hard time picking up the right "remove"
> value.
> Can't figure that one out, since there are multiple remove checkboxes on
> the
> page.
>
> I need to make this: remove[0] dynamic.
>
> Any suggestions?
>
>
>
>
> > -Original Message-
> > From: Michael Corbridge [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 5:27 PM
> > To: CF-Talk
> > Subject:RE: JavaScript: using Submit()
> >
> > the submit() does not take any arguments
> >
> > to accomplish this, have that checkbox call a function that contains
> this
> > code:
> >
> > document.forms[0].action = "index.cfm";
> > document.forms[0].myhidden.value = "remove";
> > document.forms[0].submit();
> >
> > Make sure that your form DOES NOT have a submit button in it, and add
> the
> > new hidden field to your form.
> >
> > hth
> >
> > - mike
> >
> > > -Original Message-
> > > From: <"Owens>,Howard" [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 13, 2003 8:04 PM
> > > To: CF-Talk
> > > Subject: OT: JavaScript: using Submit()
> > >
> > >
> > > I'm trying to do something like this:
> > >
> > > > > onclick="javascript:
> > > submit('form.action=index.cfm?action=remove');">
> > >
> > > But that's not working.
> > >
> > > Basically, I have this check box in the middle of a form that
> > > sort of needs
> > > to behave like a form within a form. If the checkbox is
> > > clicked, I want
> > > that form to get submitted as that checkbox serving as a single form
> > > element.
> > >
> > > H.
> > >
> > >
> > > ~~
> > > Howard Owens
> > > Internet Operations Coordinator
> > > InsideVC.com/Ventura County Star
> > > [EMAIL PROTECTED]
> > > AIM: GoCatGo1956
> > > ~~
> > >
> > >
> >
>
~|
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: JavaScript: using Submit()
Mike,
Thanks for your help.
Here's what I have:
function removeSubmit() {
document.removeForm.action = "index.cfm";
document.removeForm.saction.value = "remove_cart";
document.removeForm.CFID.value = "#URL.CFID#";
document.removeForm.CFTOKEN.value = "#URL.CFTOKEN#";
document.removeForm.remove.value = document.cartform.remove[0].value;
document.removeForm.submit();
}
Works well, but I'm having a hard time picking up the right "remove" value.
Can't figure that one out, since there are multiple remove checkboxes on the
page.
I need to make this: remove[0] dynamic.
Any suggestions?
> -Original Message-
> From: Michael Corbridge [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 5:27 PM
> To: CF-Talk
> Subject: RE: JavaScript: using Submit()
>
> the submit() does not take any arguments
>
> to accomplish this, have that checkbox call a function that contains this
> code:
>
> document.forms[0].action = "index.cfm";
> document.forms[0].myhidden.value = "remove";
> document.forms[0].submit();
>
> Make sure that your form DOES NOT have a submit button in it, and add the
> new hidden field to your form.
>
> hth
>
> - mike
>
> > -Original Message-
> > From: <"Owens>,Howard" [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 8:04 PM
> > To: CF-Talk
> > Subject: OT: JavaScript: using Submit()
> >
> >
> > I'm trying to do something like this:
> >
> > > onclick="javascript:
> > submit('form.action=index.cfm?action=remove');">
> >
> > But that's not working.
> >
> > Basically, I have this check box in the middle of a form that
> > sort of needs
> > to behave like a form within a form. If the checkbox is
> > clicked, I want
> > that form to get submitted as that checkbox serving as a single form
> > element.
> >
> > H.
> >
> >
> > ~~
> > Howard Owens
> > Internet Operations Coordinator
> > InsideVC.com/Ventura County Star
> > [EMAIL PROTECTED]
> > AIM: GoCatGo1956
> > ~~
> >
> >
>
~|
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: JavaScript: using Submit()
the submit() does not take any arguments
to accomplish this, have that checkbox call a function that contains this code:
document.forms[0].action = "index.cfm";
document.forms[0].myhidden.value = "remove";
document.forms[0].submit();
Make sure that your form DOES NOT have a submit button in it, and add the new hidden
field to your form.
hth
- mike
> -Original Message-
> From: <"Owens>,Howard" [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 8:04 PM
> To: CF-Talk
> Subject: OT: JavaScript: using Submit()
>
>
> I'm trying to do something like this:
>
> onclick="javascript:
> submit('form.action=index.cfm?action=remove');">
>
> But that's not working.
>
> Basically, I have this check box in the middle of a form that
> sort of needs
> to behave like a form within a form. If the checkbox is
> clicked, I want
> that form to get submitted as that checkbox serving as a single form
> element.
>
> H.
>
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
>
~|
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: SQL Help Requested: Unique Same Field Sum Combinations
You can also just check the value using CFOUTPUT and then add it to the list
if it is less than six.
Peter Bagnato
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 7:37 PM
To: CF-Talk
Subject: Re: SQL Help Requested: Unique Same Field Sum Combinations
Thomas Sammons wrote:
>
> How would you do this in CF (any version 4.5 or higher): return all
> unique combinations of rows where the unique row field value
> combination has a certain summed value?
>
> For example:
> I have a SocksTable with 6 SockDrawers, and each SockDrawer has a
> number of Socks in it. I want to get the list of unique combinations
> of SockDrawers that have a combined total of, say, 6 Socks or less.
I don't think SQL is the right tool for it, although if you dbms
supports WITH RECURSIVE it might be an option. I think I would use CF to
loop over an array for this. Code below, but just by hand so you
probably need to debug it. Mind the wrap.
maximum = 6;
socksArray = ArrayNew(1);
socksArray[1]["idlist"] = 1;
socksArray[1]["socktotal"] = 5;
socksArray[2]["idlist"] = 2;
socksArray[2]["socktotal"] = 2;
socksArray[3]["idlist"] = 3;
socksArray[3]["socktotal"] = 1;
socksArray[4]["idlist"] = 4;
socksArray[4]["socktotal"] = 3;
socksArray[5]["idlist"] = 5;
socksArray[5]["socktotal"] = 4;
i = 1;
while (i lt ArrayLen(socksArray)) {
j = i + 1;
while (j lt ArrayLen(socksArray)) {
if (socksArray[i]["sockTotal"]+socksArray[j]["sockTotal"] LTE
maximum and not REFind("," & socksArray[i]["sockTotal" & "," &
socksArray[j]["sockTotal"],",([0-9]*),.*\1")) {
ArrayAppend(socksArray(StructNew());
socksArray[ArrayLen(socksArray)]["idlist"] =
socksArray[i]["idlist"] & "," socksArray[j]["idlist"];
socksArray[ArrayLen(socksArray)]["socktotal"] =
socksArray[i]["sockTotal"] + socksArray[j]["sockTotal"];
}
j = j + 1;
}
i = i + 1;
}
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: JavaScript: using Submit()
You could do something like:
onclick="this.form.action = 'index.cfm?action=remove'; submit();"
Or check out fusionScript.org or .com.
> -Original Message-
> From: "Owens [mailto:"Owens]
> Sent: Friday, 14 February 2003 2:04 p.m.
> To: CF-Talk
> Subject: OT: JavaScript: using Submit()
>
>
> I'm trying to do something like this:
>
> onclick="javascript:
> submit('form.action=index.cfm?action=remove');">
>
> But that's not working.
>
> Basically, I have this check box in the middle of a form that
> sort of needs
> to behave like a form within a form. If the checkbox is
> clicked, I want
> that form to get submitted as that checkbox serving as a single form
> element.
>
> H.
>
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
>
~|
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: JavaScript: using Submit()
You'll need to set up a separate form outside your main form, and change
your checkbox to something like this:
HTH,
barneyb
> -Original Message-
> From: "Owens [mailto:"Owens]
> Sent: Thursday, February 13, 2003 5:04 PM
> To: CF-Talk
> Subject: OT: JavaScript: using Submit()
>
>
> I'm trying to do something like this:
>
> onclick="javascript:
> submit('form.action=index.cfm?action=remove');">
>
> But that's not working.
>
> Basically, I have this check box in the middle of a form that
> sort of needs
> to behave like a form within a form. If the checkbox is clicked, I want
> that form to get submitted as that checkbox serving as a single form
> element.
>
> H.
>
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
>
~|
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
OT: JavaScript: using Submit()
I'm trying to do something like this: But that's not working. Basically, I have this check box in the middle of a form that sort of needs to behave like a form within a form. If the checkbox is clicked, I want that form to get submitted as that checkbox serving as a single form element. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| 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: load testing...please don't shoot me
e-TEST Suite from Empirix, definitely. www.empirix.com. Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:01 PM Subject: load testing...please don't shoot me > Hi All, > > I may get raked over the coals for this one but.. > > I'm looking for load testing software for an Oracle/ CF 5/IIS/Win2K/ > site.software names, URLs, opinionsthanks > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > > ~| 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: SQL Help Requested: Unique Same Field Sum Combinations
Thomas Sammons wrote:
>
> How would you do this in CF (any version 4.5 or higher): return all
> unique combinations of rows where the unique row field value combination
> has a certain summed value?
>
> For example:
> I have a SocksTable with 6 SockDrawers, and each SockDrawer has a number
> of Socks in it. I want to get the list of unique combinations of
> SockDrawers that have a combined total of, say, 6 Socks or less.
I don't think SQL is the right tool for it, although if you dbms
supports WITH RECURSIVE it might be an option. I think I would use CF to
loop over an array for this. Code below, but just by hand so you
probably need to debug it. Mind the wrap.
maximum = 6;
socksArray = ArrayNew(1);
socksArray[1]["idlist"] = 1;
socksArray[1]["socktotal"] = 5;
socksArray[2]["idlist"] = 2;
socksArray[2]["socktotal"] = 2;
socksArray[3]["idlist"] = 3;
socksArray[3]["socktotal"] = 1;
socksArray[4]["idlist"] = 4;
socksArray[4]["socktotal"] = 3;
socksArray[5]["idlist"] = 5;
socksArray[5]["socktotal"] = 4;
i = 1;
while (i lt ArrayLen(socksArray)) {
j = i + 1;
while (j lt ArrayLen(socksArray)) {
if (socksArray[i]["sockTotal"]+socksArray[j]["sockTotal"] LTE
maximum and not REFind("," & socksArray[i]["sockTotal" & "," &
socksArray[j]["sockTotal"],",([0-9]*),.*\1")) {
ArrayAppend(socksArray(StructNew());
socksArray[ArrayLen(socksArray)]["idlist"] =
socksArray[i]["idlist"] & "," socksArray[j]["idlist"];
socksArray[ArrayLen(socksArray)]["socktotal"] =
socksArray[i]["sockTotal"] + socksArray[j]["sockTotal"];
}
j = j + 1;
}
i = i + 1;
}
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
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: CFMX & Apache vhosts
Dave, you are a saviour. I knew about that issue, but ruled it out (without double checking), because I'd already changed the setting. Of course, that was before the last updater. Does it seem weird to anyone else that a software update would overwrite configuration data? A thousand thanks, barneyb > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 4:08 PM > To: CF-Talk > Subject: RE: CFMX & Apache vhosts > > > > Over the past two days I've been beating my head against > > a wall with requests to separate virtual hosts getting > > mixed up. The problem is that CF is getting told to use > > templates from the root directory of the wrong vhost. > > http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179&Method=Full > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| 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: CFMX & Apache vhosts
> Over the past two days I've been beating my head against > a wall with requests to separate virtual hosts getting > mixed up. The problem is that CF is getting told to use > templates from the root directory of the wrong vhost. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179&Method=Full Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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: Linux CF Editor
As a note, jEdit also runs on Windows, Mac, Linux, Unix, etc. - anything that supports JAVA. It also offers tag completion using the XML plugin - it will complete any XML style tags, including CF. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 4:23 PM To: CF-Talk Subject: Re: Linux CF Editor I'll enter another vote for vim. I like it because it is very fast and lightweight, and I can use it on all three platforms I develop on on a regular basis (Mac, Linux and Windows). I was glad when I saw this post because I thought I was just about the only one using vim for CF. I'd love to swap some .vimrc files with folks out there. I've been thinking of moving to emacs because it has most of the same advantages and could probably be configured to provide tag completion or code insight. A while ago, I was toying with the idea of putting together a CF DTD which would allow people essentially use any XML editor they wanted for CF development, however it seems ColdFusion has too many tags that are exceptions to well formed XML. Christian On Thursday, February 13, 2003, at 11:20 AM, Hugo Ahlenius wrote: > ...or vim. > > graphical user interface, split views, tree-view, shortcut to context > sensitive help, dictionary of valid cftags/cf functions, syntax > highlightning for cf, closes tag automatically, highlights syntax > problems, custom menus, splits, folds... (the list goes on) > > (of course, some of these needs to be set up by you yourself, I have > prepared some of these files so I can assist). > > > > > > ~| 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
CFMX & Apache vhosts
Over the past two days I've been beating my head against a wall with requests to separate virtual hosts getting mixed up. The problem is that CF is getting told to use templates from the root directory of the wrong vhost. Running CFMX (with updaters) on Apache 2.0.44. The problem started with 2.0.43, and the .43 -> .44 upgrade was an attempt to resolve the issue that didn't work. The process goes like this: 1) request '/' from vhost one 2) admire the beautiful pages from vhost one web root 3) request '/' from vhost two 4) admire the beautiful pages from vhost ONE's web root, except with broken image and stylesheet references (and .html pages, if a frameset). Set 4 is an interesting one, because it implies to me that non-CF requests are getting sent to the root directory of the correct vhost, while CF requests are getting mixed up. Here's the offending vhosts: - ServerName www.actionone.dev ServerAlias actionone.dev DocumentRoot//rbi ServerName www.weber.dev ServerAlias weber.dev DocumentRoot//wsw - And here are is a snip from the CGI variables of a request to 'www.actionone.dev/home.cfm' (note the 'wsw' in the directory path): -- CF_TEMPLATE_PATH=//wsw/home.cfm PATH_TRANSLATED=//wsw/home.cfm SERVER_NAME=www.actionone.dev -- If anyone's got any ideas, I'd love to hear them, I'm at my wit's end. TIA, barneyb --- Barney Boisvert PIER System, Inc. barneyb at piersystem.com (360) 671-8708 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.454 / Virus Database: 253 - Release Date: 2/10/2003 ~| 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?
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: load testing...please don't shoot me
Oh, also, its reporting is fantastic, you can get very detailed HTML documents or PDF's of everything and use any number of criteria in exactly *what* you're testing and what specific information you'd like back (time until first response, time between response and actual load, interstitial idle time, graphs of execution times based on x number of gradually increasing requests) - lots of goodies. - Jim -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 4:46 PM To: CF-Talk Subject: RE: load testing...please don't shoot me I don't see any mention of CFFORM, Microsoft buying Macromedia or CF hosting, so I think you're in the clear there, Bryan :) Anyway, I've used WebLoad from RadView for a couple of years and it's always been very helpful in finding kinks and bottlenecks in a very large site. You can use it from a single computer or install clients on multiple computers and have them all send requests to a server to see what happens. I don't remember the cost specifically, but the single client was reasonable, though I know my company balked on the price of the distributed version due to the high cost... FYI. http://www.radview.com - Jim -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 3:01 PM To: CF-Talk Subject: load testing...please don't shoot me Hi All, I may get raked over the coals for this one but.. I'm looking for load testing software for an Oracle/ CF 5/IIS/Win2K/ site.software names, URLs, opinionsthanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ~| 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?
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 "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 :
> > > 1
Re: load testing...please don't shoot me
Thanks Dave and Jim, yup I know the topic wasn't in the "cycling threads of death" list...but it's gotta be a contender ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Jim Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 2:45 PM Subject: RE: load testing...please don't shoot me > I don't see any mention of CFFORM, Microsoft buying Macromedia or CF > hosting, so I think you're in the clear there, Bryan :) > > Anyway, I've used WebLoad from RadView for a couple of years and it's always > been very helpful in finding kinks and bottlenecks in a very large site. > You can use it from a single computer or install clients on multiple > computers and have them all send requests to a server to see what happens. > I don't remember the cost specifically, but the single client was > reasonable, though I know my company balked on the price of the distributed > version due to the high cost... FYI. > > http://www.radview.com > > - Jim > > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 3:01 PM > To: CF-Talk > Subject: load testing...please don't shoot me > > > Hi All, > > I may get raked over the coals for this one but.. > > I'm looking for load testing software for an Oracle/ CF 5/IIS/Win2K/ > site.software names, URLs, opinionsthanks > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > > > ~| 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?
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: 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 li
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]>
> > > 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.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
~
RE: Verity and Clustered Servers
> Ah, didn't realize that about VDK. We definitely need > to use cf tags to update the collections, so that would > also rule out k2. It needn't rule out K2; you just have to use VDK for indexing and K2 for searching. You can have VDK index the collection, then use K2 to search it. A collection is essentially just a directory, so you could have one collection name you use for VDK indexing and another for K2 searching. Actually, you typically have two collections in K2 for each VDK collection, since K2 collections map to the file and custom subdirectories of the collection directory. The issue in a clustered environment, though, is that you'd need to have the directory accessible by whichever server is going to run CFINDEX. It's not an insurmountable issue, though. > We will be adding collections periodically, and the > process really needs to be automatic. We could probably > automate the editing of the k2server.ini file and the > restart of the k2 server, but that just sounds really > ugly. It's not as bad as it sounds. The CommonSpot product, for example, does this very nicely. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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
Verity and Clustered Servers: more basic view
Ok, maybe we can solve this a little bit at a time. Can anyone think of a reason why cold fusion would not be able to create a verity collection in a folder but it is able to write a file or create a directory in the same? Ryan ~| 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: load testing...please don't shoot me
I don't see any mention of CFFORM, Microsoft buying Macromedia or CF hosting, so I think you're in the clear there, Bryan :) Anyway, I've used WebLoad from RadView for a couple of years and it's always been very helpful in finding kinks and bottlenecks in a very large site. You can use it from a single computer or install clients on multiple computers and have them all send requests to a server to see what happens. I don't remember the cost specifically, but the single client was reasonable, though I know my company balked on the price of the distributed version due to the high cost... FYI. http://www.radview.com - Jim -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 3:01 PM To: CF-Talk Subject: load testing...please don't shoot me Hi All, I may get raked over the coals for this one but.. I'm looking for load testing software for an Oracle/ CF 5/IIS/Win2K/ site.software names, URLs, opinionsthanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ~| 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?
-- 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: load testing...please don't shoot me
> I may get raked over the coals for this one but.. Why? > I'm looking for load testing software for an Oracle > / CF 5/IIS/Win2K/ site.software names, URLs, > opinionsthanks Segue SilkPerformer: http://www.segue.com/ SilkPerformer is the greatest, if you can afford it. It's very expensive. It lets you load test your web interfaces, and also your Oracle databases directly. OpenSTA: http://www.opensta.org/ OpenSTA is the nicest free product I've found. While it's not nearly as sophisticated as SilkPerformer, well, it's free, and it's good enough for much testing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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 overRe: 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: Verity and Clustered Servers
Ah, didn't realize that about VDK. We definitely need to use cf tags to update the collections, so that would also rule out k2. We will be adding collections periodically, and the process really needs to be automatic. We could probably automate the editing of the k2server.ini file and the restart of the k2 server, but that just sounds really ugly. Ryan - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 4:15 PM Subject: RE: Verity and Clustered Servers > > That would work except it requires that the k2server > > process be restarted and the k2server.ini file be > > updated every time a collection is added, which is > > too large a drawback for our application. (That is > > based on whether or not I understand the k2 > > documentation correctly.) > > I think you're correct about that, but do you really need to create new > collections that often? You may be able to just create one collection, then > index everything into that. > > Even if you use K2, though, you'll still have to figure out some issues with > your cluster. For example, you have to use Verity VDK instead of K2 to use > the CFINDEX and CFCOLLECTION tags. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| 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?
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 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 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: CFMX Filters
If you're using IIS, try stopping IIS and then stop/start CF. Regards, Marcello. >Hi all, > >I was following the article about cfmx filters on CF journal (Feb 2003) >but I have no luck. > >When I add the filter part in the web.xml file and restart cf server, I >get "page can not display" error. > >Anyone knows why? > >Thanks, > >J > > > > ~| 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?
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: Verity and Clustered Servers
> That would work except it requires that the k2server > process be restarted and the k2server.ini file be > updated every time a collection is added, which is > too large a drawback for our application. (That is > based on whether or not I understand the k2 > documentation correctly.) I think you're correct about that, but do you really need to create new collections that often? You may be able to just create one collection, then index everything into that. Even if you use K2, though, you'll still have to figure out some issues with your cluster. For example, you have to use Verity VDK instead of K2 to use the CFINDEX and CFCOLLECTION tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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?
-- 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
Re: Verity and Clustered Servers
Ryan wrote: >That would work except it requires that the k2server process be restarted >and the k2server.ini file be updated every time a collection is added, which >is too large a drawback for our application. (That is based on whether or >not I understand the k2 documentation correctly.) Thanks, though. > >Ryan > > That is exactly why we use ms sql server full text search instead of verity. Which applicationneeds to restart to add a "database" or thingy whatsoever. (appart from windows of course ;) 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
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
Verity collections of a database
Can someone explain to me how to create a verity collection of data that is stored in a database. I am very interested in this but have not been able to find anything except file verity. Thanks in advance Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. ~| 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: Verity and Clustered Servers
That would work except it requires that the k2server process be restarted and the k2server.ini file be updated every time a collection is added, which is too large a drawback for our application. (That is based on whether or not I understand the k2 documentation correctly.) Thanks, though. Ryan - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 3:29 PM Subject: Re: Verity and Clustered Servers > Ryan wrote: > > > > If I have a set of clustered servers (with clustercats) and they all need to access a verity collection. Does each server need to create and index its own collection? We are trying to place the verity directory on an nfs share so that all servers would see the collections as local. Any thoughts? > > Can't you designate 1 server as the 'Verity Server' and have it run the > Verity K2 Server and have all the other servers pass requests to that > server? Verity K2 supports remote connections pretty much like a > database does. > > 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: CFMX Filters
Hi J, Can you paste the java code you wrote for the filter and your web.xml into an email and send it to the list? I'm sure we'd be able to help a bit more if we could see what you're doing... AJ Aaron Johnson http://cephas.net/blog/ [EMAIL PROTECTED] > -Original Message- > From: J L [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 2:36 PM > To: CF-Talk > Subject: CFMX Filters > > > Hi all, > > I was following the article about cfmx filters on CF journal (Feb 2003) > but I have no luck. > > When I add the filter part in the web.xml file and restart cf server, I > get "page can not display" error. > > Anyone knows why? > > Thanks, > > J > > > > ~| 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?
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: CFQUERYPARAM Grr!
"The use of is the rememedy for injection attacks. Injection attacks can only occure when you pass data directly from a FORM or URL parameter into a query, or where you are using a "dynamic" approach and building a string based on user input ( myQuery = "select * from mytalbe where & form.col & "='" & form.searchstring etc.). If you are passing integers you are particularly vulnerable because there's no "escaping" of single quotes. I have a blog on this at:" As I have heard. Even though I have been unable to recreate a injection attack this does not mean it is impossible. This is why I use them. I agree with you, I'm not telling anyone to use or not to use. I just stated I have not been able to verify a difference. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 4:25 PM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! - you wrote "Buffer overruns using a carefully constructed packet of exactly 376 bytes may be a different matter" Could you explain. - I was making a passing humorous reference to the recent "slammer" virus that affected so many SQL servers. --- you wrote -- I do use because of the bennies that is supposed to come with it. I just have not seen any differance and I have not been able to reproduce an injection. - The use of is the rememedy for injection attacks. Injection attacks can only occure when you pass data directly from a FORM or URL parameter into a query, or where you are using a "dynamic" approach and building a string based on user input ( myQuery = "select * from mytalbe where & form.col & "='" & form.searchstring etc.). If you are passing integers you are particularly vulnerable because there's no "escaping" of single quotes. I have a blog on this at: http://mxc.blogspot.com/ -mk Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 12:08 PM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! Bryan, I can tell you that in some instances it can increase speed quite significantly - especially with character data. We've had aps that we revised to use CFQUERYPARAM and we were able to see a definite improvement from baselines before and baslines after (using just the DB baselines). As for SQL injection attacks, it's definitely impervious to them from a straight, "pass this value in..." perspective. There's only one exception to this and it has to do with "date" values. I've noted some folks pasing in date values as character data because the date type is tricky to work with. Since the DB server can parse a string into a date, this "may" expose a vulnerability on the other side (because it's not correctly pre-defined for type). I'm trying to come up with a scenario where that would be a risk, but nothing comes immediately to mind - so even that is probably reasonably safe. Buffer overruns using a carefully constructed packet of exactly 376 bytes may be a different matter . -Mk -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:51 AM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! I've tried many times to verify the injections but have never been able to with SQL 2000. Don't know about some other DB. And as for speed, have not seen any proof. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: "Everett [mailto:"Everett] Sent: Thursday, February 13, 2003 11:45 AM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! No chance of a SQL insertion attack. Uses bind variables which, on the whole, are faster. Here's what Uncle Ben had to say about cfqueryparam: http://www.macromedia.com/desdev/articles/ben_forta_faster.html > -Original Message- > From: "Luce>,Greg" <[EMAIL PROTECTED] [mailto:"Luce>,Greg" > <[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 11:37 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM Grr! > > > OK, then what benefit does using cfparam have over this: > 0>'#attributes.firstname#'NULL, > > Greg > > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 11:31 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM Grr! > > > P.S. FYI "Null values can be in
Re: Verity and Clustered Servers
Ryan wrote: > > If I have a set of clustered servers (with clustercats) and they all need to access >a verity collection. Does each server need to create and index its own collection? >We are trying to place the verity directory on an nfs share so that all servers would >see the collections as local. Any thoughts? Can't you designate 1 server as the 'Verity Server' and have it run the Verity K2 Server and have all the other servers pass requests to that server? Verity K2 supports remote connections pretty much like a database does. 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 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
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
Verity and Clustered Servers
Hello, All, If I have a set of clustered servers (with clustercats) and they all need to access a verity collection. Does each server need to create and index its own collection? We are trying to place the verity directory on an nfs share so that all servers would see the collections as local. Any thoughts? Thanks, Ryan ~| 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: Linux CF Editor
I'll enter another vote for vim. I like it because it is very fast and lightweight, and I can use it on all three platforms I develop on on a regular basis (Mac, Linux and Windows). I was glad when I saw this post because I thought I was just about the only one using vim for CF. I'd love to swap some .vimrc files with folks out there. I've been thinking of moving to emacs because it has most of the same advantages and could probably be configured to provide tag completion or code insight. A while ago, I was toying with the idea of putting together a CF DTD which would allow people essentially use any XML editor they wanted for CF development, however it seems ColdFusion has too many tags that are exceptions to well formed XML. Christian On Thursday, February 13, 2003, at 11:20 AM, Hugo Ahlenius wrote: > ...or vim. > > graphical user interface, split views, tree-view, shortcut to context > sensitive help, dictionary of valid cftags/cf functions, syntax > highlightning for cf, closes tag automatically, highlights syntax > problems, custom menus, splits, folds... (the list goes on) > > (of course, some of these needs to be set up by you yourself, I have > prepared some of these files so I can assist). > > > > > > ~| 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: CFQUERYPARAM Grr!
- you wrote "Buffer overruns using a carefully constructed packet of exactly 376 bytes may be a different matter" Could you explain. - I was making a passing humorous reference to the recent "slammer" virus that affected so many SQL servers. --- you wrote -- I do use because of the bennies that is supposed to come with it. I just have not seen any differance and I have not been able to reproduce an injection. - The use of is the rememedy for injection attacks. Injection attacks can only occure when you pass data directly from a FORM or URL parameter into a query, or where you are using a "dynamic" approach and building a string based on user input ( myQuery = "select * from mytalbe where & form.col & "='" & form.searchstring etc.). If you are passing integers you are particularly vulnerable because there's no "escaping" of single quotes. I have a blog on this at: http://mxc.blogspot.com/ -mk Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 12:08 PM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! Bryan, I can tell you that in some instances it can increase speed quite significantly - especially with character data. We've had aps that we revised to use CFQUERYPARAM and we were able to see a definite improvement from baselines before and baslines after (using just the DB baselines). As for SQL injection attacks, it's definitely impervious to them from a straight, "pass this value in..." perspective. There's only one exception to this and it has to do with "date" values. I've noted some folks pasing in date values as character data because the date type is tricky to work with. Since the DB server can parse a string into a date, this "may" expose a vulnerability on the other side (because it's not correctly pre-defined for type). I'm trying to come up with a scenario where that would be a risk, but nothing comes immediately to mind - so even that is probably reasonably safe. Buffer overruns using a carefully constructed packet of exactly 376 bytes may be a different matter . -Mk -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:51 AM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! I've tried many times to verify the injections but have never been able to with SQL 2000. Don't know about some other DB. And as for speed, have not seen any proof. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: "Everett [mailto:"Everett] Sent: Thursday, February 13, 2003 11:45 AM To: CF-Talk Subject: RE: CFQUERYPARAM Grr! No chance of a SQL insertion attack. Uses bind variables which, on the whole, are faster. Here's what Uncle Ben had to say about cfqueryparam: http://www.macromedia.com/desdev/articles/ben_forta_faster.html > -Original Message- > From: "Luce>,Greg" <[EMAIL PROTECTED] [mailto:"Luce>,Greg" > <[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 11:37 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM Grr! > > > OK, then what benefit does using cfparam have over this: > 0>'#attributes.firstname#'NULL, > > Greg > > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 11:31 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM Grr! > > > P.S. FYI "Null values can be inserted into a column by > explicitly stating > NULL in an INSERT or UPDATE statement, or by leaving a column > out of an > INSERT statement, or when adding a new column to an existing > table using the > ALTER TABLE statement." (Ref. SQL Server Books Online) > > > Bryan F. Hogan > Director of Internet Development > Macromedia Certified ColdFusion MX Developer > Digital Bay Media, Inc. > 1-877-72DIGITAL > > > -Original Message- > From: "Luce [mailto:"Luce] > Sent: Thursday, February 13, 2003 11:09 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM Grr! > > > But I can't put this in the cfqueryparam: > null="YesNo" > It errors: > Attribute NULL in tag CFQUERYPARAM has an invalid value > > Cannot convert YesNo to boolean. > > I could put conditional logic around the whole cfqueryparam > tag and just put > null="Yes" or null="No" but that's kinda ugly. > > Greg > > -Original Message- > From: "Everett>,Al" <[EMAIL PROTECTED] [mailto:"Everett>,Al" > <[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 10:52 AM > To:
Re: Internationalization Theme
> Adam Churvis wrote: > > > > That is a nice _theory_, but it is only that: a theory. It isn't a simple > > matter of a change in syntax; there are completely different techniques > > available in some very popular products. To disregard these very valuable > > and popular techniques is to say, "You guys shouldn't have spent the > > millions in R&D to provide these capabilities in your product because you > > can't do the same thing with every other product." Such is to thwart > > innovation, which by its very nature must break the chains of standards in > > order to evolve and grow. > > No, it is to say: "if you want to implement an entirely new and > innovative technology, provide sufficient documentation so people can > understand how it works, because *we* are not going to document *your* > idiosyncracies". I agree. I can't stand having some new whiz-bang feature dangled like a carrot in front of me, then having to go a-hunting for the non-existent implementation guide! And if it's really new then there aren't any third-party books out on the subject yet. I usually end up lurking on every product-specific forum I can find. > > So how about three examples of each major principle involved in implementing > > i18n via XML techniques: > > > > 1) A generic, standards-only-based technique, > > > > 2) A technique that leverages MS SQL Server's unique XML handling > > capabilities, if that technique is significantly different from and/or has > > platform-specific advantages over the other two techniques, > > > > and > > > > 3) A technique that leverages the unique XML handling capabilities of Oracle > > 9iR2, if that technique is significantly different from and/or has > > platform-specific advantages over the other two techniques. > > > How does this sound to you? Workable for all? > > Very workable. But if the resources only allow for 1 example, make sure > it is number 1. I agree. Hey-- this worked out! :) Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ ~| 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: Refresh error on CFMX...
Yeah, I get that a lot. Haven't been able to pin down any specific cause. Very annoying, although it only happens when code changes so it doesn't affect production, thank god. Any macromedians out there with some insight? > -Original Message- > From: Tyler Silcox [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 12:13 PM > To: CF-Talk > Subject: Refresh error on CFMX... > > > Does anyone else get the following error everytime they change > code and hit refresh? > > Index: 219, Size: 194 > The Error Occurred in Z:\somedomain\fbx_fusebox30_cf50.cfm: line 159 > > 157 : > ~| 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
load testing...please don't shoot me
Hi All, I may get raked over the coals for this one but.. I'm looking for load testing software for an Oracle/ CF 5/IIS/Win2K/ site.software names, URLs, opinionsthanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ~| 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: Update query loop with checkboxes
Janine,
I didn't see a sql "query" in your code-example.
The problem you are having appears to be from the difference in behavior
between Checkboxes and input/text boxes.
If you have multiple text-boxes on a page and one of them is blank, that
text box still passes its value (an empty string) to coldfusion. However, a
checkbox works very differently. If you check the checkbox, it passes the
value to coldfusion that you define in your HTML. However, if the checkbox
is NOT checked, NO VALUE IS PASSED TO COLDFUSION, NOT EVEN AN EMPTY STRING.
This is kind of stupid to me, but you just have work around it. In the case
of multiple textboxes, you can name all the textboxes the same name and all
their values will get passed as a big comma-delimited list, even if one item
is missing. However, if you are using check boxes, this won't work.
Instead you will need to name each of the checkboxes something different,
then use a to give them
default values on the receiving page.
So your checkboxes could be something like this:
and on the receiving page:
If you do not want the hardcode every checkbox and every param, you can use
a query from a database to create them and then process them in a loop using
the Evaluate() function. Contact me off list for some example code.
Fregas
[EMAIL PROTECTED]
- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 2:37 PM
Subject: Update query loop with checkboxes
> I know checkboxes have been discussed many times- I searched the archives
of
> hof and cf support and haven't quite found this issue with them so please
> forgive me if it's been discussed.
> i have a display page that shows about 80 checkboxes- set in a basic table
> format. It looks like so
> English Reading Math Science History
> Visual Aides X X X
>
> Large Print Test X X
>
> Math Aids x
>
> Etc
> I need these checkboxes to update in the database. Problem is using a
loop
> causes errors with the checkboxes. So what I can do with an input box
(ie:
> y/n) using #ListGetAt(Attributes.English, x)#
> Throws an error when there's a blank checkbox. All of my fields have the
>
> So my code works as long as I'm not using a checkbox! (And of course the
> users want checkboxes and they do look better with so much on the page).
> Thanks for any help.
> j
> Below is my query- the error I get is when an empty checkbox is
encountered
>
> An error occurred while evaluating the expression:
> ListFindNoCase("#ListGetAt(Attributes.SOLWriting,x)#")
>
> Error near line 25, column 6.
>
>
~|
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
