RE: lists in cfcase

2002-11-03 Thread Tony Weeg
it really helps if the expression parameter of the cfswitch tag has a variable that will parse to be something, #'s are great little inventions... good night...two party fouls, im out. tw -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Monday, November 04, 2002 1:13

lists in cfcase

2002-11-03 Thread Tony Weeg
doesnt jive? meaning, it wont do the stuff in the case, if there is a match from the list if i know the list, and its not dynamic, and i want to loop over the values, shouldnt a list be allowed? thanks. ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn

RE: last day of month

2002-11-03 Thread Tony Weeg
thanks all ye kind gents. tw -Original Message- From: Bob Haroche [mailto:spambait@;onpointsolutions.com] Sent: Monday, November 04, 2002 1:04 AM To: CF-Talk Subject: Re: last day of month > is there an easy way to generate a lastDayofMonth > kinda number, knowing the month/year? Take

RE: last day of month

2002-11-03 Thread Douglas.Knudsen
should be able to use a combo of the date functions for this. Check this out though http://www.cflib.org/library.cfm?ID=13 Doug >-Original Message- >From: Tony Weeg [mailto:tony@;navtrak.net] >Sent: Monday, November 04, 2002 12:56 AM >To: CF-Talk >Subject: last day of month > > >is there

Re: last day of month

2002-11-03 Thread Bob Haroche
> is there an easy way to generate a lastDayofMonth > kinda number, knowing the month/year? Take a look at this custom tag: http://makeashorterlink.com/?V29531552 It creates a set of dynamic month|day|year drop down boxes, handles months of 28, 29 (leap yr), 30 and 31 days automatically. And yo

RE: last day of month

2002-11-03 Thread Tony Weeg
duh...thanks man :) sleepy has started to code, tony is now gone z.. tw -Original Message- From: Charlie Griefer [mailto:charlie@;griefer.com] Sent: Monday, November 04, 2002 12:56 AM To: CF-Talk Subject: Re: last day of month daysInMonth() - Original Message - From: "

RE: last day of month

2002-11-03 Thread Ruslan Sivak
Hmm... how about adding a month and subtracting a day to the first day of the month? #DateAdd("d",-1,DateAdd("m",1,CreateDate(Year(Now()),Month(now()),1)))# Russ -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Monday, November 04, 2002 12:56 AM To: CF-Talk Subject:

Re: last day of month

2002-11-03 Thread Howie Hamlin
Try this: http://www.cflib.org/library.cfm?ID=13 HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http

Re: last day of month

2002-11-03 Thread Charlie Griefer
daysInMonth() - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 03, 2002 10:55 PM Subject: last day of month > is there an easy way to generate a lastDayofMonth > kinda number, knowing the month/year? > > want to give the

RE: permission Issue

2002-11-03 Thread Ruslan Sivak
I think the problem might be that Bobby doesn't have permission to read files in the directory above the protected one. And since Bobby is not IUSER, he doesn't have access to the directory above the protected one. ColdFusion is probably trying to read some file in that directory (like application

last day of month

2002-11-03 Thread Tony Weeg
is there an easy way to generate a lastDayofMonth kinda number, knowing the month/year? want to give the user the ability to click a checkbox that will autopopulate two date fields, with the first day and last day of month based on the month that Now() will give me. ive got it all down, i can glo

Speed of Duplicate

2002-11-03 Thread Christopher P. Maher
I have three different computers which are exhibiting drastically different speeds executing the Duplicate function. All computers are running CF5. The function is copying a large structure from the application scope to the request scope. Computer 1: remote webserver, dual processor, raid 5, Win 2

RE: Words

2002-11-03 Thread Tony Weeg
cool. thats what i was lookin fer :) back to xml and cfmx...this is cool schtuff! tw -Original Message- From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com] Sent: Sunday, November 03, 2002 11:57 PM To: CF-Talk Subject: Re: Words It's all logic. Lets look at it below: This will

RE: Words

2002-11-03 Thread John Wilker
I didn't see that preso but have heard that also. If you have anything more than 3 (I think, maybe just 2) Ifs then a case will process faster. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wr

Re: Words

2002-11-03 Thread Michael Dinowitz
It's all logic. Lets look at it below: This will evaluate the variable name and compare it to the text michael. Lets expand it: We're doing one evaluation of the variable name for the first CFIF and then another for the CFELSEIF. That's 2 evaluations of the same variable. With more CFELSEIFs of

RE: Words

2002-11-03 Thread Douglas.Knudsen
yes. Someone at DevCon did a presentation on this stuff. He showed some pretty graphs that were convincing enough proof that cas statements proceesed faster than a block of if statements. Doug >-Original Message- >From: Tony Weeg [mailto:tony@;navtrak.net] >Sent: Sunday, November 03, 2

RE: Words

2002-11-03 Thread Tony Weeg
hello list can u tell me that programmatically, and processingly (new word!!) cfcase/cfswitch sets of code are better/faster than series of cfif's/cfelse's ive never messed with the cfcase/cfswitch family of flow control, cause way back when i first started, i learned the cfif way, and now, and j

Re: STFU about Ebonics already WAS: OT RAGE

2002-11-03 Thread S . Isaac Dealey
> Or maybe CF-OT, one of the new lists you can see on the > mailing lists page: > http://www.houseoffusion.com/cf_lists/ > Please use that list or CF-Community for continuation of > this topic. It is > not relevant to the CF-Talk list. Thanks Sorry Mike, that was my bad. Isaac Certified Advanced

RE: Words

2002-11-03 Thread S . Isaac Dealey
> refind(key, '/archivedocs/'); > > The slashes prevent it from returning true if it finds > 'archivedocsearch' > and similar mismatches. > > --Ben Doom > Programmer & General Lackey > Moonbow Software You and the regular expressions. ;P I think he's probably looking for something like L

permission Issue

2002-11-03 Thread brook
This sounds like the same problem Lee was having. I have a website which allows anonymous connections. The cfm file's are served up properly here. The folder has read/read&execute permissions for the IUSER. Then there is Virtual Directory inside of this website which restricts access using win

RE: Words

2002-11-03 Thread Ben Doom
refind(key, '/archivedocs/'); The slashes prevent it from returning true if it finds 'archivedocsearch' and similar mismatches. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Parker, Kevin [mailto:KParker@;workcover.com] : Sent: Sunday, N

RE: Words

2002-11-03 Thread Matthew Walker
Matthew Walker http://www.matthewwalker.net.nz/ > -Original Message- > From: Parker, Kevin [mailto:KParker@;workcover.com] > Sent: Monday, 4 November 2002 4:51 p.m. > To: CF-Talk > Subject: Words > > > Can anyone recommend the best approach to finding a word > inside a string. > REF

Words

2002-11-03 Thread Parker, Kevin
Can anyone recommend the best approach to finding a word inside a string. REFind seems a bit complex (or overkill) for this task. I am trying to check if a path contains a particular sub-directory name so that I can put additional info on the screen for the user. The path is returned in the value

RE: OT RAGE

2002-11-03 Thread Rick Faircloth
http://www.phaelos.com/ebonics.htm -Original Message- From: S. Isaac Dealey [mailto:info@;turnkey.to] Sent: Thursday, October 31, 2002 7:41 PM To: CF-Talk Subject: Re: OT RAGE http://www.linguistlist.org/topics/ebonics/ > Yes, > And to add to a ridiculously off-topic thread: there is a

Re: cfexecute and restarting CF-Service remotely

2002-11-03 Thread Carl
Servers Alive is another tool that can be used... http://www.woodstone.nu/salive/ Carl - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 03, 2002 5:46 PM Subject: Fwd: cfexecute and restarting CF-Service remotely > Thanks everybody w

Re: STFU about Ebonics already WAS: OT RAGE

2002-11-03 Thread Michael Dinowitz
Or maybe CF-OT, one of the new lists you can see on the mailing lists page: http://www.houseoffusion.com/cf_lists/ Please use that list or CF-Community for continuation of this topic. It is not relevant to the CF-Talk list. Thanks > CF-Ebonics! Good idea! For those who can't code real CF, > we

RE: STFU about Ebonics already WAS: OT RAGE

2002-11-03 Thread Rick Faircloth
CF-Ebonics! Good idea! For those who can't code real CF, we can create an alternate CF Language! ;o) -Original Message- From: Andrew Tyrone [mailto:atyrone@;optonline.net] Sent: Thursday, October 31, 2002 5:43 PM To: CF-Talk Subject: STFU about Ebonics already WAS: OT RAGE I vote to

RE: cycle services

2002-11-03 Thread Dave Watts
> How can I cycle the cf services? I found this in the > macromedia forums, but it doesn't work on my server: > > c:\winnt\system32\net.exe stop "Cold Fusion Application Server" > c:\winnt\system32\net.exe stop "Cold Fusion Executive" > c:\winnt\system32\net.exe stop "Cold Fusion RDS" > c:\winn

Fwd: cfexecute and restarting CF-Service remotely

2002-11-03 Thread cf-talk
Thanks everybody who answered my question. I ended up using psservice from sysinternals http://www.sysinternals.com/ntw2k/freeware/psservice.shtml On a sitenote: We use CF 5 Pro on Win2000 Uwe This is a forwarded message From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]>

Re: CFMX and Custom Tags

2002-11-03 Thread Sean A Corfield
On Tuesday, Oct 29, 2002, at 18:05 US/Pacific, Brian Simmons wrote: > In the C:\CFusionMX\wwwroot directory I have: > test.cfm -> simply has call in it. > mytag.cfm -> has the text: current directory > > In the C:\CFusionMX\CustomTags directory I have: > mytag.cfm -> has the text: CustomTags direc

RE: Server Error-Urgent

2002-11-03 Thread Mark A. Kruger - CFG
Janine, The trick is to get the "calculation" to happen on the DB platform and returned as a part of the query. Perhaps the stored proc would be the best place to do this. Grouping requries some practic - trial and error, but it really is the best way to accomplish what you are trying to do here

RE: OT: Flash Com Server

2002-11-03 Thread Mike Chambers
yes, there is a developer's version, but it is different that the CF developers version. The main difference being that it is not free ($500). i apologize for the confusion. mike chambers [EMAIL PROTECTED] > -Original Message- > From: Frank Mamone [mailto:fmamone@;videotron.ca] > Sent:

Re: cycle services

2002-11-03 Thread brook
Search the archives (or look in your inbox) for a post from Lee Fuller Yesterday which includes a BAT script and a really good way to cycle the services.I'm at a different computer and don't have it handy.. At 01:04 PM 11/3/02 -0600, you wrote: >How can I cycle the cf services? I found this in

Re: Question About Macromedia Docs & Naming Conventions

2002-11-03 Thread Sean A Corfield
On Sunday, Nov 3, 2002, at 09:55 US/Pacific, Dave Watts wrote: > Well, I don't know that what's used in the courses is as bad as all > that. > It's primarily used to differentiate between complex data types - no > prefixes are used to differentiate strings from numbers, for example. OK, then mayb

cycle services

2002-11-03 Thread Matthew P. Smith
How can I cycle the cf services? I found this in the macromedia forums, but it doesn't work on my server: c:\winnt\system32\net.exe stop "Cold Fusion Application Server" c:\winnt\system32\net.exe stop "Cold Fusion Executive" c:\winnt\system32\net.exe stop "Cold Fusion RDS" c:\winnt\system32\net.

Re: OT: Flash Com Server

2002-11-03 Thread Frank Mamone
The Development version was mentioned in one of the sessions at Devcon. Thought it was available. - Original Message - From: "Mike Chambers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 03, 2002 11:52 AM Subject: RE: OT: Flash Com Server > it does not rev

RE: Question About Macromedia Docs & Naming Conventions

2002-11-03 Thread Dave Watts
> > I can't speak to the contents of the actual > > documentation, but I can affirm that this is > > described and used pretty consistently in the > > Macromedia CF courses. > > Something I'm starting to work on getting changed... > Hungarian Prefix Notation is very, very bad :| Well, I don't

RE: Getting Username/Password Challenge (CF5)

2002-11-03 Thread Dave Watts
> I'm not 100% sure, but I think the Internet Guest Account > needs access to the C:\cfusion\ directory for Read/Read > & Execute. Oh no! The IIS anonymous user account does not need to be able to read and execute all the stuff in \CFusion or \CFusionMX! Yikes! There's only one file that needs t

RE: Getting Username/Password Challenge (CF5)

2002-11-03 Thread Dave Watts
> Yeah.. It will simply not access CFM files at all, without > requiring a login. You may need to allow Authenticated Users: Read/Execute on the jrun.dll used by IIS to interface with CF. By default, that's in \CFusionMX\runtime\lib\wsconfig\1. Dave Watts, CTO, Fig Leaf Software http://www.figle

Re: Compiled pages still exists...

2002-11-03 Thread Jochem van Dieten
Chad wrote: > I think I found it. > > C:\CFusionMX\wwwroot\WEB-INF\cfclasses > > Just want to make sure before I delete all the files and reboot the > server. Don't reboot the server, just the service. > This is definitely a bug. You know where to find the feature request/bugform. Jochem

RE: Compiled pages still exists...

2002-11-03 Thread Chad
I think I found it. C:\CFusionMX\wwwroot\WEB-INF\cfclasses Just want to make sure before I delete all the files and reboot the server. This is definitely a bug. I have not noticed this until today! > -Original Message- > From: Jim Davis [mailto:jim@;depressedpress.com] > Sent: Sunday

Re: Compiled pages still exists...

2002-11-03 Thread Doug
There well may be a copy in your browser cache, and if "Persistent caching" is enabled on the server, then a copy is cached there as well. This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dw

Re: Compiled pages still exists...

2002-11-03 Thread Jochem van Dieten
Chad wrote: > Is the page compiled somewhere in the ColdFusionMX directory and I > need to purge the compiled pages? Not only that, you also need to restart CF MX to clear the in-memory cache of compiled pages. BTW, the directory is wwwroot/WEB-INF/cfclasses Jochem ~~~

RE: Compiled pages still exists...

2002-11-03 Thread Jim Davis
> I have deleted a CFM page. > > I had the page bookmarked in IE and I clicked on the book > mark on accident. > > The page is still running even though the CFM file does not > exists on the server! > > Is the page compiled somewhere in the ColdFusionMX directory > and I need to purge the com

Compiled pages still exists...

2002-11-03 Thread Chad
I have deleted a CFM page. I had the page bookmarked in IE and I clicked on the book mark on accident. The page is still running even though the CFM file does not exists on the server! Is the page compiled somewhere in the ColdFusionMX directory and I need to purge the compiled pages? ~~~

RE: OT: Flash Com Server

2002-11-03 Thread Mike Chambers
it does not revert to a Development version after 30 days. If you think this type of functionality would be useful (which i think that most developers would) then please request it at: http://www.macromedia.com/support/email/wishform/ btw, the server side language used for the Flash Communication

Re: OT: Flash Com Server

2002-11-03 Thread Jochem van Dieten
Frank Mamone wrote: > Is the trial version of Flash Communication Server the Developer > version -- similar to CF trials? The trial version is fully functional for 30 days, with 500 concurrent user licenses and a 10 Mbit bandwidth cap. I don't know if it reverts to a Development version after

RE: Debugging a Runaway CF5 Server?

2002-11-03 Thread Mike Brunt
Ben, our experience is that we always found solutions to server performance by looking closely at the Application and Server CF error logs. Looking at the detail you give here you appear to already be doing that. Unknown exception and PCode errors are almost always related to memory corruption is

RE: Query help

2002-11-03 Thread Jim Davis
I'm not a SQL person but something like this would seem to do it: SELECT Image1, Description, Rating FROM cars WHERE Rating = (SELECT MAX(RATING) FROM cars WHERE approved = 1) In other words (working from inner to outer) get the highest rated car, then select all the data that matches that Rating

RE: Query help

2002-11-03 Thread Chad
Thanks guys... These queries did the trick! > -Original Message- > From: Jeff [mailto:jeff@;hawkandheron.com] > Sent: Sunday, November 03, 2002 11:01 AM > To: CF-Talk > Subject: RE: Query help > > Try this... > > SELECT Image1, Description > FROM cars > WHERE rating = (SELECT MAX(ra

OT: Flash Com Server

2002-11-03 Thread Frank Mamone
Is the trial version of Flash Communication Server the Developer version -- similar to CF trials? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists

RE: Query help

2002-11-03 Thread Jeff
Try this... SELECT Image1, Description FROM cars WHERE rating = (SELECT MAX(rating) FROM cars) HTH, Jeff Garza -Original Message- From: Chad [mailto:cgray@;careyweb.com] Sent: Sunday, November 03, 2002 8:54 AM To: CF-Talk Subject: Query help I know I have done this in the past, but I

RE: Query help

2002-11-03 Thread Andy Clary
You need a GROUP BY clause: SELECT MAX(RATING), Image1, Description FROM cars WHERE approved = 1 GROUP BY Image1, Description Any column that is returned, but not part of an aggregate function, must be in a GROUP BY clause. Andy -Original Message- From: Chad [mailto:cgray@;careyweb.com

Query help

2002-11-03 Thread Chad
I know I have done this in the past, but I cannot figure it out for some reason. I want to grab out of a database the record with the highest value for the field RATING (it is an INT). I also want to grab all the data for the record like Image1, Description etc SELECT MAX(RATING), Image1,

Re: Debugging a Runaway CF5 Server?

2002-11-03 Thread cf-talk
Hi Ben, two things I can mention we had on a similar problem: 1) After hours or searching, we found out, that a certain domain caused the problems. And on this web-site were 6 Dben connected. All MS-Access. At the end it turned out, that the developer of the web-site has made an sql-fault. In a "L

Re: Is there a CFMX server installation that is optimized for large ISPs?

2002-11-03 Thread Jochem van Dieten
Dave Wilson wrote: > I would suggest that CFMX Pro would be your best bet in this > situation. This is because, typically an ISP hosting 2000 CF driven > sites would most likely be using virtual hosts on shared servers. The > number of virtual hosts per server would vary depending on several >

Re: Return of the sql wierdness ERROR message

2002-11-03 Thread Richard Meredith-Hardy
Sometimes I have found you can get this sort of error if the value in the query is not immediately apparent as a simple value - I know it shouldn't matter, but easy to try: (I had this exact problem the other day; Access - memo) instead of INSERT into authorBio (authorBio_authorId,authorBioDeta

RE: Return of the sql wierdness ERROR message

2002-11-03 Thread Erika L. Walker-Arnold
>>| From: jason kufner [mailto:jasonkufner@;rio.com] >>| >>| >>| >>| >>| >| datasource="#application.dsn#"> >>| INSERT into authorBio (authorBio_authorId, >>| authorBioDetail) >>| VALUES >>| (#session.authorPkey#,'#preserveSingleQuotes(AuthorBio)#') >>| Should be: Single apostrophe for

Re: HELP!! sql wierdness ERROR message

2002-11-03 Thread Jochem van Dieten
jason kufner wrote: > > INSERT into authorBio (authorBio_authorId, authorBioDetail) > VALUES (#session.authorPkey#, '#bookArray[43]#') > INSERT into authorBio (authorBio_authorId, authorBioDetail) VALUES ( , ) I don't know what datatype a memo field is in SQL terms, so you could

Re: Return of the sql wierdness ERROR message

2002-11-03 Thread Jochem van Dieten
jason kufner wrote: > -the actual value is bookArray is: > > H. Charles was born August 6, 1855 in Cookstown, Co. Tyrone. He was > educated at Belfast Academy, Queen's College Belfast (Classics, > 1874-80), and Trinity College Dublin (Classics and Theology). Charles > was ordained a deacon in 1

Re: HELP!! sql wierdness and the clients coming tomorrow!!!

2002-11-03 Thread Jochem van Dieten
jason kufner wrote: > I'm at zero hour with a project and I just discovered an "issue" with > SQL (the language, not the database): Considering that SQL has been around for almost as long as I live I find it hard to believe it is an issue with the language. More likely it is a user error. > I