Cfimpersonate, Cfdirectory, MX
Back in the days of CF4 and 5 I used to use a cfdirectory wrapped in a cfimpersonate to have users supply passwords then have cf read network shares that they had access to on a file server. I know that I could have logged the CF service in as a user with permission (in fact I did that on another application) but this worked the best for shares that theoretically were supposed to only be accessed by their owner. I am at a loss as to how to do this (if possible) with the array of new security features in MX and 7. I am currently using jrun.security.NTAuth to authenticate my users, but still am not sure if I can or how to use user supplied credentials to access network resources. Any help that you could give or point me to would be greatly appreciated. Thanks Patrick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Uploading multiple files - not necessarily CF
Aren't there Flash solutions now? I used to use a JAVA applet at a previous position and remember the head ache of client computers having the wrong java version. This looked good at first glance http://72.14.203.104/search?q=cache:SF1om3zwEeYJ:labs.oinam.com/flash8/f ileuploaddownload/+flash+multiple+file+upload&hl=en&gl=us&ct=clnk&cd=1 I downloaded that for later reference. But if anyone else has some insight on a flash solution, I know I will be keeping an eye on this thread to see. -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 4:21 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF I'll dig into that. Gotta get Java installed though. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 4:14 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF The java app I mentioned will fit directly into your html, and will accept images, docs, etc, fully configurable. Also has CF examples. Thanks, Mark -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 4:09 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF I've been told that whatever solution we go with has to work in the current application "flow." In other words, we need to be able to seamlessly slot the solution into our current web application. Sending the users to a separate application is a non-starter. I need something that, ideally, can fit into an existing HTML form. I'm not optimistic. -Original Message- From: Everett, Al (NIH/NIGMS) [C] Sent: Tuesday, April 25, 2006 2:06 PM To: CF-Talk Subject: Uploading multiple files - not necessarily CF I'm looking for a solution to this problem: For an intranet site, the end user should be able to select multiple files (or even a directory) located on his/her local machine, and press a single button to upload them to the server. We're a CF shop and I don't see a CF solution for this piece, but it needs to work with CF. Perhaps a Java applet? Maybe Flash? We'll certainly be using CF for the back-end processing of the files, but what is not desired is having the multiple html file form fields. This is for an intranet application with VERY tightly controlled browser and OS environments. Downloading a separate application is pretty much a non-starter; it needs to work in the browser window. Any pointers you can offer would be appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise Manager or Query Analyzer like tool for Oracle
Aquadata studio (http://aquafold.com/) is a pretty nice little tool that allows you to have connection to several different types of DBs. Doesn't have quite as much as TOAD, but is handy if you have several projects spread over several DBS and are like me and need to swap between them at a moments notice. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 4:59 PM To: CF-Talk Subject: Enterpise Manager or Query Analyzer like tool for Oracle Does anyone know if Oracle or some 3rd party has tools like Enterprise Manager or SQL Query Analyzer? We are trying to port some of our tools to Oracle from MS SQL and are currently using SQL*Plus (command line thingy) and some built in web interface, both of which are horrible. jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: checkbox validation problem
JavaScript treat multiple checkboxes as an array, but a single checkbox is not an array. A quick goggle didn't turn me a up with an example but there should be plenty of examples out there of checking for this with JS. You can also take what I consider to be an easier way out, using CF to push down a different script depending on how many boxes you are going to have. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Thursday, July 21, 2005 4:08 PM To: CF-Talk Subject: SOT: checkbox validation problem I'm having a problem with a javascript validation for a form with multiple checkboxes with the same name. The validation works just fine when there is more than one checkbox (as with a results set with more than one item) however, if there is only one checkbox, it always validates to false and craps out. Any suggestions would be most appreciated. thx, larry ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job
I know I have gotten that error message before, either on 4.5 or 5. I found this after searching a little while - paraming a variable with a scope but without a variable name will cause "CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321 " when doing this in Coldfusion 5 or lower. - But if my memory serves me I seem to remember in our case it had to do with having multiple cfapplication tags execute on the same request. In that instance it was application.cfm including the application.cfm in the parent directory. This will cause, long page loads, terminated page loads, server crashes, weird error messages. Not sure if that is it, if that situation went with that error message. But I thought it might be worth mentioning. Patrick -Original Message- From: Peter Lakanen [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 2:50 PM To: CF-Talk Subject: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job We're getting a variety of errors including CFLOCK's timing out and references to CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crazy Error
I can't say off hand if we have gotten the exact same error here, but it sure sounds similar to the one we have gotten when are db server runs out of hard disk space or RAM. How does your db server look? Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 10:49 AM To: CF-Talk Subject: Crazy Error This morning we had a crazy Error where we got the following error on a page request (came up when you asked for a page on a site): "Not enough server storage is available to process this command" Anyone have any ideas? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Alternating Row Colour - Sorta
It looks like you are already using a group by in the query to group by month, just use a second group by, this one on the day. In the second group by set the bg color. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 4:44 PM To: CF-Talk Subject: Alternating Row Colour - Sorta Here's the page in question: http://www.stpaulscolumbia.com/calendar.cfm Client is asking for alternating colors for DAYS - not rows. At first, I figured, OK, Odd Dates one colour, Even Dates another. Nope, don't work because there may be something on the 5th and 7th, both odd dates - but not the 6th ... and then you'd get two groups of events - those on the 5th and 7th, the same colour. I'm looking at various convoluted ideas for this, but bet the list can comeup with something a little more compact than I... Ideas? -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQLSurveyor with NEW DAO Generator Beta site ready for a good , solid thrashing...
Looks pretty neat but it was slow going since I had to log in for every page request I made (tried IE and Netscape). Yesterday I couldn't log in at all. Once you get that fixed up it would be a nice little product. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, February 26, 2005 7:46 AM To: CF-Talk Subject: RE: SQLSurveyor with NEW DAO Generator Beta site ready for a good , solid thrashing... Hey, that's actually pretty cool. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: John Dowdell Wants to Know What's Wrong with Macromedia
Speaking of SSL and RDS, is there anyway to present a certificate with RDS? We have found no way tell studio to present a cert to https server. Patrick McGeehan CFMX Advanced Certified Applications Developer DIT #mcg# -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 12:47 PM To: CF-Talk Subject: RE: John Dowdell Wants to Know What's Wrong with Macromedia > RDS would be a lot more useful if it was thrown away and > replaced with something that used open standards (WebDAV for > instance). RDS is far to insecure to leave running on anything > like a production system. How exactly is WebDAV any more or less secure than RDS? Both can be protected with SSL. Both let you manipulate the filesystem through HTTP requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF tags work inside of CSS
You could also use some logic in application.cfm and use cfhtmlhead to inject a set into the head of the htm doc, rather than using a linked style sheet. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:29 AM To: CF-Talk Subject: Re: CF tags work inside of CSS Ok, damn! Oh well, looks like a few files instead then. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search for a string across columns
Concatobate = Concatenate And don't for get your wildcards on the like '%#search#%' Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Patrick McGeehan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:11 PM To: CF-Talk Subject: RE: search for a string across columns Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' You would just have to worry about the spaces because in your example line_1 and line_2 would concat to "I need togo to the bathroom", so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1="I need to" line_2="go to the bathroom" and I searched "need to go", it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search for a string across columns
Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' You would just have to worry about the spaces because in your example line_1 and line_2 would concat to "I need togo to the bathroom", so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1="I need to" line_2="go to the bathroom" and I searched "need to go", it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Includes, paths, templates, directory path problems...and a philosophical Question
Jeff, You may want to use mappings in the cf administrator. Or if you put the include in the application.cfm and onrequestend.cfm files the includes will be done relative to the application.cfm file not the file that is called. I would say one of the 2 of those is the easiest. Though I suppose using the cgi variable you could detect where you were in the root and build you the include statement that way. p Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 12:16 PM To: CF-Talk Subject: Includes, paths, templates, directory path problems...and a philosophical Question ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coding question ?
Maybe a bit more complex a solution then you are looking for. But you can simulate a forked thread by putting the query in a separate page that runs the query and stores it as wddx packet, then call the page using cfhttp from another ColdFusion page. The calling page can wait a give amount of time to see if the cfhttp.filecontent returns I could go into more detail if you really wanted to try something like that. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 10:51 AM To: CF-Talk Subject: Re: Coding question ? On Monday 20 Sep 2004 14:53 pm, applemicro wrote: > I have a page that will display infromation from a remote database. > What i want to do is display the information from the remote database > but if the query to the remote database takes long then 5 sec I want > to abort the current query and query my local database which contains > a versions of the data but is 24 hours old [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hide/Show page sections and internal anchors
_javascript_? give a small form element focus should move you to that part of the page... I think Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 4:52 PM To: CF-Talk Subject: Re: Hide/Show page sections and internal anchors *chirp chirp* where is everybody today?? Anywaysperhaps this will simplify my problem... Does anybody know of ANY other method to jump down a page than using: www.mydomain.com/index.cfm?#internalLink1 ?? TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Thursday, September 16, 2004 10:18 AM Subject: SOT: Hide/Show page sections and internal anchors Hey All, I think I have an idea why this is happening, but can't dream up a solution right now.. THE SETUP: -User Account page with 4 sections -Each section is hidden by default and only shows a section header -Each section header has a link to show/hide that section (via DHTML...kinda like panels in the Flash IDE) -EACH section has sub-sections where the user can add/edit/delete records THE DESIRED FUNCTIONALITY: -user chooses to add a record to a sub-section (thus it's section is not hidden) -user leaves the page to add the record -on the record adding confirmation page there is a "finished" button that links back to their account page (the one with the 4 sections) -I want the user to go back to the same sub-section they just added a record to THE PROBLEM: I can get the correct section to show upon the user's return (calling the function onLoad to open that section). The issue that I think is cropping up is that the browser is attempting to jump down to the correct internal page anchor () BEFORE or WHILE the function is running (onLoad) to show the correct section. So sometimes it jumps to the right sub-section...sometimes not (well most times not), but the correct section is always shown. So does anybody have any ideas? perhaps an alternative to using internal page anchors? TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFTRANSACTION
You could do something manually using a try and catch block, then put delete query (essentially undoing the first query) in the catch block... Definitely not a true rollback but would probably suit most cases. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 9:09 AM To: CF-Talk Subject: RE: CFTRANSACTION > thks for your response,i think its possible in java > is it not possible to have implement tow phase commit in Coldfusion To perform distributed transactions with two-phase commits, you need some specific piece of software, a distributed transaction coordinator, that can do this for you. For example, Oracle provides a DTC. If you had something like that, you may be able to address it from within CF, although I don't have any experience with it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Read directory
Asim,
Yes the upper in the order by should work fine.
Patrick
Patrick McGeehan
Applications Developer
DIT
#mcg#
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 1:02 AM
To: CF-Talk
Subject: Re: Read directory
I think I resolved it.
select UPPER(name) as fsort, * from eng1
where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#')
ORDER by fsort ASC
is that right?
> one more thing I have to resove in this issue is I need those filename
> sorted alphabetically.
>
> I try to use the ORDER BY eng1.name ASC
>
> but in the middle of the page somewhere its finished on 'Z' and then
> start again from 'A' (that start is unique, i.e. not repeating).
>
> I don't know where I am doing wrong, also could you please mentioned
> that which query should I output to get the filenames which are in
> both directory?
>
>
>
>
>
>
> sort="name">
>
> sort="name">
>
>
> select * from eng1, fre1
> where fre1.name = eng1.name
>
>
> select * from eng1
> where eng1.name in ('#replace(valuelist(fre1.name), ",", "','",
> "all")#')
> ORDER by eng1.name ASC
>
>
>
> select * from fre1
> where fre1.name in ('#replace(valuelist(eng1.name), ",", "','",
> "all")#')
> ORDER by fre1.name ASC
>
>
> and then I output the query "f_notin_e" ( I've dump both and it looks
> both are generating the same output i.e. "f_notin_e" & "e_notin_f"
>
> please advise that which query should I output and the filenames are
> not sorted.
>
> thanks
>
>
>
>
> > Thank alot for help.
> > it was a map drive and I was trying to access that directory from my
>
> > local machine, in that case the structure was empty.
> > When I put the codes on server(then it becomes a local drive) and it
>
> > gave me the required output.
> >
> > thanks once again.
> > -
Asim
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Read directory
Are both eng1 and fre1 local? Is ColdFusion's service running as a user? If so does the user have permission to the those directories? Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 3:58 PM To: CF-Talk Subject: Re: Read directory #french1# and #english1# contains the path value. my directory should be in #Eng1# and #Fre1# and both are returned empty structure. >output your directories.. >#french1# and #english1# >make sure you're searching in the right places.. > > > >On Mon, 13 Sep 2004 15:49:06 -0400, Asim Manzur ><[EMAIL PROTECTED]> wrote: >> _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Read directory
Sorry the first time I just pounded that out in email, didn't code it on
a server. I just made a small change to the where clauses of the second
2 queries and it ran on my IIS dev box. couldn't see exactly where the
error was on the code, it said line 0?
The first query should give you all the common files.
Patrick
select * from eng e, fre f
where f.name = e.name
select * from eng e
where e.name not in ('#replace(valuelist(fre.name), ",", "','","all")#')
select * from fre f
where f.name not in ('#replace(valuelist(eng.name), ",", "','","all")#')
Patrick McGeehan
Applications Developer
DIT
#mcg#
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 3:30 PM
To: CF-Talk
Subject: Re: Read directory
And I need those filenames which are common on both directories.
>Thanks for your reply.
>
>I am actually getting and error
>
>Query Of Queries syntax error.
>Encountered "e" at line 0, column 0.
>
>The error occurred in C:\Inetpub\wwwroot\first\petro.cfm: line 9
>
>7 :
>8 :
>9 :
>10 : select * from eng e, fre f
>11 : where f.name = e.name
>
>
>These are the current codes.
>--
>
>
>
>
>
>select * from eng e, fre f
>where f.name = e.name
>
>
>
>select * from eng e
>where e.name not in ('#replace(valuelist(fre.name, ","),
"','","all")#')
>
>
>
>select * from fre f
>where f.name not in ('#replace(valuelist(eng.name, ","),
"','","all")#')
>
>
>
>
>
>
>
>
>
>
>> _
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Read directory
Assuming ColdFusion 5 or better you can indeed use the cfdirectory
action list then a query of queries to compare the 2 result sets. Not
sure exactly what comparison you are trying to do, but the below code
will give you files common to both, files in fre that aren't in eng and
files in eng that aren't in fre.
select * from eng e, fre f
where f.name = e.name
select * from eng e
where e.name not in ('#replace(valuelist(fre.name, ",", "','","all")#')
select * from fre f
where f.name not in ('#replace(valuelist(eng.name, ",", "','","all")#')
Patrick McGeehan
Applications Developer
DIT
#mcg#
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 2:39 PM
To: CF-Talk
Subject: Read directory
I have two directories.
C:\Eng
C:\Fre
The filenames are same on both dir. what I need to do is, Have to read
the files on both directories, check if the file exist on both folder,
then sort it ASC
and display it with tag.
how can I acheive this. I think I have to use the
action="" something like that but got no idea that how do I compare
and then stack for sorting and then display.
appriciate your help
thanks
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: doubling E-mail
Is the email field a standard data type? I know MS access has a hyperlink data type, which some times causes some weirdness when outputting using coldfusion. Doubt that is the issue since you are using mysql, but who knows. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 4:43 PM To: CF-Talk Subject: Re: doubling E-mail are you looping the query and cfoutput-ing the query?? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Folder Permission
That was my next suggestion after my initial disappointment of the loss of cfimpersonate... If you are windows try CACLS http://windows.about.com/library/tips/bltip164.htm Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 1:27 PM To: CF-Talk Subject: Re: Folder Permission Couldn't you use cfexecute lo execute a batch or shell command HTH Dick On Sep 9, 2004, at 7:22 AM, Tangorre, Michael wrote: > Is there anyway using ColdFusion to check if a person has access to a > specific folder on the webserver. > Our security model is strucutred around ActiveDirectory so the users > network ID, email, alias, etc is all available, and I am wondering if > there is a way to say... > > > if user has permissions to folder x, allow, else, throw error. > > > Thanks! > > > Mike > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Folder Permission
Mike, I think the easiest way to do would be to do cfdirectory (action = ""> that is enclosed in a cfimpersonate tag. If the record count is 0 then the user doesn't have permissions. if it is 2 or more (entries for '.' and '..') then they have at least read permissions. Remember, if you haven't used cfimperosnate before, that the user will have to have rights to log on as a batch job and act as OS. Patrick Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 10:23 AM To: CF-Talk Subject: Folder Permission Is there anyway using ColdFusion to check if a person has access to a specific folder on the webserver. Our security model is strucutred around ActiveDirectory so the users network ID, email, alias, etc is all available, and I am wondering if there is a way to say... if user has permissions to folder x, allow, else, throw error. Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
Dick, I think the technology is pretty nifty and I didn't mean to suggest that it couldn't work. For many of the reasons Dave gave and my personal experience with access I thought that doing something "quick and dirty" even using access wizards would be an easier solution. Dave, Thanks for defending my position so eloquently. I had gone home for the evening. Greg, good luck with your project. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 12:23 AM To: CF-Talk Subject: RE: (I guess) Local App Just to throw HTA back into the mix - you might want to check it out. One of the features is that an HTA runs with application privileges, not web-page privileges (even tho' the HTA is just a web page). This means that you can use _javascript_ to access any com object on the system. In your case that means you can create an HTML based form that would use the Excel com object to automatically create and fill out the Excel sheet (or create an XML file or whatever). Jim Davis _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:06 PM To: CF-Talk Subject: Re: (I guess) Local App I posted to a CF list to get ideas, the admin section will be entirely CF and Oracle. I posted to get ideas on how to gather their input while not connected to the internet or intranet and then upload it to Oracle once they get back and can upload their input. This wasnt posted to start a forum war or anything heh.. I appreciate all your inputs and it gives me a good idea of where to start. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
The cfanywhere stuff looks cool but seems like a bit of work to get that rolling and the template may be to much for an easily importable spreadsheet. I would personally go with a simple Access db with some user forms. Again, minimize reinventing the wheel... Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 4:23 PM To: CF-Talk Subject: Re: (I guess) Local App On Sep 8, 2004, at 12:43 PM, Greg Morphis wrote: > No it's a laptop. > I'm actually considering that option Patrick.. > They want to be able to create custom templates.. I suppose an admin > can do this with CF and then output the data to a csv file.. > The only problem will be taking that data and knowing how to transfer > it to Oracle. > > Why not CFAnywhere? How many users will you have? You write the app in CF, providing a customized, application-specific GUI, using a browser -- just as you do now for any web app. Your users can run it on the desktop & store the data in a local db (with no connection to the Internet) Using, for example; BDJ2ee, Apache, Jetty, Cloudscape * You can make the entire app double-clickable (all of the above) just like any desktop app -- no necessity to type commands or run scripts from the command line. It doesn't cost anything for any of the software* It takes a very small footprint & runs quite efficiently (prolly smaller than Excel) When the Internet is available, the user clicks a button & the CF template (you write) xfers the data from the desktop db to Oracle, You have all the CF programming capabilities, you use for any other CF app (it's CFML, baby!) You have a single, familiar, language with which to write and maintain the programs, You have the reliability, ease of use, etc. to which you are accustomed. It is easy to deploy via download or CD. * Everything except CFMX/BD is free, open-source, proven & redistributable. You will need to get permission of the mfgr to redistro CFMX or BD -- lacking that you must dl & install a free trial version on each user's system, Dick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
How complex is the data being collected? If not too complex, why reinvent the wheel, have them collect the data in excel, and read the sheets in when they get back. Create a template and give it to them and you are done. No programming and no training (most people can work excel). Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:27 PM To: CF-Talk Subject: Re: (I guess) Local App I know nada about Flash heh On Wed, 8 Sep 2004 14:07:32 -0500, Deanna Schneider <[EMAIL PROTECTED]> wrote: > You could do it in Flash - and store the data locally and upload when > connected. We did that back with Flash 3, and I'm sure it's a lot cleaner > now. > > - Original Message - > From: "Greg Morphis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 08, 2004 1:54 PM > Subject: OT: (I guess) Local App > > > I've been tasked with building an app for engineers on the road to > > report how cell phones function. Unfortunately they wont be connected > > to the internet while on the road. So I'm guessing my only option > > would be to build something in Java, VB, ASP or something to record > > the data in an Access DB to upload at a later time to an Oracle DB. > > The Admin section would be in CF tieing to the Oracle DB. > > > > Does anyone have any other options, ideas or comments.. Anything is > appreciated. > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Selling Tags and Apps (WAS: Free for non-commercial usage? Donationware?)
The talk yesterday about donation-ware and some posts by Claude Schneegans with links to cf tag store have prompted me to attempt to start my first thread. Over a year ago now I made a New Years resolution that I would start posting tags on either Macromedia exchange or sites like cftagstore. My thought was I could do some basic tags, apps for free, and others for a fairly cheap price. I could at worst have something else to put on a resume or in a portfolio and at best make some side money. I had/have a few tags and apps lying around in various stages of done-ness. I never seem to find the time to get any to the point that they are documented and ready for upload. Now over a year later, I am pretty happy with my job, not leaving in the foreseeable future, and am less worried about a portfolio builder but would still be interested in posting some side projects if there was at least a minimal return. I already have a second job and get paid an hourly rate for that, so even though some of my tags and apps are more fun to work on than the second job I have trouble justifying the time and effort. What have some of you experienced with trying to sell pre-packed tags and apps, aimed at other developers (so as not to get too, too far into support issues). I am sure some of my ideas are out there somewhere but I do have a few that I think are kind of unique. For example A project management app that asks for a location of a dev site or app (ftp, local, or unc) and a prod site or app (ftp, local or unc). It shows (prod files side by side with dev) mod date / times, highlights which is more recent, shows if a file is unique to just dev or just prod. It can push files forward, roll files back, and logs it all. A web app that is a scaled down version of studio for use when you aren't near a computer that has your dev tools. It lets you edit code online with line numbering, upload/download code, manipulate the directory structure, explore datasources, etc. A custom tag that takes a table name, and database type and draws a cf grid like html table that allows you to sort, update, add, delete info. And there are a few others. So I guess my question is two fold, what have any of you found in trying to sell on the side, specifically tags and apps aimed at other developers. And I know it is tough with out seeing any of them, but I guess the 3 offerings I mentioned above are what I would consider my "coolest" and most unique tags. I use all 3 almost every day for something or the other and so they are priceless to me. Do they sound like something other developers might want or need? Or should I stick with my day (and primary night job). Thanks for any and all feedback. Patrick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looking for a ping utility
try this, assuming a windows server outputfile="c:\ping.txt"/> contents of ping.txt follows Pinging 10.0.1.5 with 32 bytes of data: Reply from 10.0.1.5: bytes=32 time<10ms TTL=128 Reply from 10.0.1.5: bytes=32 time<10ms TTL=128 Reply from 10.0.1.5: bytes=32 time<10ms TTL=128 Reply from 10.0.1.5: bytes=32 time<10ms TTL=128 Ping statistics for 10.0.1.5: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 4:18 PM To: CF-Talk Subject: RE: Looking for a ping utility CFEXECUTE will work...however, I don't think you can just cfexecute a ping. I had to make a batch file that had the ping in it and just make it accept arguments. There might be a way to call cmd.exe and then pass in the ping command, but I'm not sure. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looking for a ping utility
Can't you just do a cfececute? Haven't tried but I would think you could and then parse the results as needed? Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Jim Rathmann [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 3:57 PM To: CF-Talk Subject: Looking for a ping utility Does anyone know of a custom ping utility that can be used with CFMX? I am having a problem with the custom CFX_Ping tag that I found, but I am open to other suggestions if anyone has some. Thanks again, Jim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Security gurus out there?
Using your log files you might even be able to see who downloaded the mdb. Besides me of course. Might get lucky and be able to track it to someone. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:18 PM To: CF-Talk Subject: Security gurus out there? We got an email from a guy that has a security problem, and I am just not confident enough in my skills to be able to help him out. I am also swamped with so much work that even if I was able, we cannot take this on. I told him that I might have a resource to get him the answers he needs... Here is the email. Pls contact me if you feel you are the right man (or woman) for the job. This job is in no way associated with CrystalVision (my company), so I have no other information other than what you see below. Contact me offlist, and I will forward your name to him. Thanks! Ray ([EMAIL PROTECTED]) - Our website is www.dcyoungpro.com. >> >>Yesterday, somebody emailed our customers after they purchased tickets >>through our website. >> >>The email mentioned the customer's transaction number, and requested the >>customer send them their credit card PIN or their order would be voided. >> >>The email address claimed to be us, but was not, of course. >> >>We think that the cause of this may be a hold in our cfm scripts, perhaps >>something that would allow unauthorized access or that is not properly >>secured to prevent break-ins. >> >>What would you charge to review our cfm scripts for this, and how long >>would this take you? Do you have any other suggestions for addressing this? >> >>We have already notified the FBI and the offender's ISP. = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Security gurus out there?
With my first guess I am pretty sure I downloaded a database file based on the datasource name seen in the error message. If I am right move it out of the webable root immediately. The "hacker" could have spoofed an email and used info from the db to get the address and make it look legit. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:47 PM To: CF-Talk Subject: RE: Security gurus out there? Yes, but the fact that the email had the order number in it would lead one to believe that the hacker somehow has access into the system. John Burns -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:43 PM To: CF-Talk Subject: RE: Security gurus out there? We don't know that the box has been compromised. We need to see the email to know if it was from the site or not. We also need to know if the information came from a hack, a hijack or a fishing scheme. Shutting the box down is an extreme and reactionary measure, especially with the limited information we have. Remember that most spam you recieve that claims to be from X is really from Y. This may well be the case here. _ From: jonese [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:33 PM To: CF-Talk Subject: Re: Security gurus out there? what you need to do is as follows 1. shut the site down 2. alert the host that your box has been compromised and ask them to remove the network cable and shut the box down. DO NOT let them start poking around looking for evidence 3. contact your local PD and report a cyber crime. your local PD will make the call to the FBI office (and it'll get a better response coming from them) You shut the site / server down to prevent futher attacks but also to preserve the chain of evidence. and that data. More than likely your local PD will take the HD of the system in order to check it out and begin working the case with the FBI. Hope you have backups. - Original Message - From: Michael Dinowitz <[EMAIL PROTECTED]> Date: Wed, 1 Sep 2004 13:25:13 -0400 Subject: RE: Security gurus out there? To: CF-Talk <[EMAIL PROTECTED]> Looks like there's a hole in their site that'll allow a user to grab the account of another. This should provide enough information to send an email and get the CC info. I expect that the email that was sent can be examined to show that it did not originate at the original site. 1. forge an account id to get access to anothers account 2. use this to get information such as account number, order number and email. 3. send email to hacked user and ask for the CC info. 4. make money Fix: 1. check the original email for source 2. Contact the FBI with the information 3. Get someone to look through the site for holes. 4. Fix the holes _ From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:18 PM To: CF-Talk Subject: Security gurus out there? We got an email from a guy that has a security problem, and I am just not confident enough in my skills to be able to help him out. I am also swamped with so much work that even if I was able, we cannot take this on. I told him that I might have a resource to get him the answers he needs... Here is the email. Pls contact me if you feel you are the right man (or woman) for the job. This job is in no way associated with CrystalVision (my company), so I have no other information other than what you see below. Contact me offlist, and I will forward your name to him. Thanks! Ray ([EMAIL PROTECTED]) - Our website is www.dcyoungpro.com. >> >>Yesterday, somebody emailed our customers after they purchased tickets >>through our website. >> >>The email mentioned the customer's transaction number, and requested the >>customer send them their credit card PIN or their order would be voided. >> >>The email address claimed to be us, but was not, of course. >> >>We think that the cause of this may be a hold in our cfm scripts, perhaps >>something that would allow unauthorized access or that is not properly >>secured to prevent break-ins. >> >>What would you charge to review our cfm scripts for this, and how long >>would this take you? Do you have any other suggestions for addressing this? >> >>We have already notified the FBI and the offender's ISP. = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmiss
RE: Seaching for the coolest dhtml meu
Rob Don't know exactly what you are looking for, but I always liked this one. Simple, but cool. http://brainjar.com/ Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 4:04 PM To: CF-Talk Subject: Seaching for the coolest dhtml meu I am trying to find a cool dhtml navigation menu - something really original - but I can't seem to find anything that is blowing my socks off. I've looked on dynamic drive and they have some pretty good ones, but not quite what I am looking for. I'll get to writing my own if I can't find anything cool, but this list has always provided amazing links to stuff. I already tied googles first couple pages of "dhtml menus" I don't want a dhtml menu "builder" program, and it has to be free (cost and license) - (no flash or java menus either (_javascript_ ok and encouraged)). any suggestions? Thanks for any help. Rob -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: from web server get file on file server
Subject: From: Kristen Winsor <[EMAIL PROTECTED]> Date: Wed, 28 Jul 2004 12:20:13 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid =34202&forumid=4#172317 Kristen, I have done my home work on this one before, here is the best I have found. Patrick McGeehan Applications Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
