RE: The BETA IS OUT!!! (query a query)
> query against it shouldn't really exact addtional memory requirements. > Sounds like it could be an enormous memory hog if used as above. Buy more memory, (enormous memory if needed), your users deserve it. Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CLOB fields in Oracle databases
Hi everyone! I´m going through a bit of a problem here while trying to retrieve data from a CLOB data type field from an Oracle 8i database. I´m trying to retrieve its contents with a normal CFQUERY but i keep getting nothing! Any ideas why i´m not getting anything? What am i doing wrong? TIA Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CLOB fields in Oracle databases
> I´m going through a bit of a problem here while trying to retrieve data from a CLOB data type field from an Oracle 8i database. I´m trying to retrieve its contents with a normal CFQUERY but i keep getting nothing! if i recall, there's a CFX_J tag in the gallery that will handle oracle's BLOBs. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The BETA IS OUT!!! (query a query)
I've been following the thread (or at least trying!). I've yet to see the following use for the query a query. In my case I have 2 databases. The first one is a FoxPro system that contains the current location of a job in our shop along with any production notes from the various production departments. The second database is in SQL Server and contains detailed production information about the same jobs. I need to produce a web page that merges the 2 systems together. Currently I have to do a query against the SQL Server database, loop through each record and run a query against the FoxPro system go generate my output. With the new functionality I can query my SQL Server database and FoxPro system separately then run a query that does a "Select Fox.Data, SQL.Data from Fox, SqL where Fox.Job = SQL.Job" and then output the resulting dataset. This is somewhat simplified but is an example of something I've needed to do for quite awhile and have never been able to do directly within CF. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] WWW:www.euservices.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SPS
Does anyone have info on a scripting language called .sps? I saw it on the Manchester United webpage and was curious to find out more about it. Darren Daniel Producer -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 419 4235 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
session variables timing out
I have a site with 2 sections. The members only directory uses the application scope with session variables and the general public directories are all html files without any application.cfm. If a user goes from the member site to the public site and is active in the public site does that activity postpone the session variables timing out in the member site? My guess is no. Thanks Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Network Scenario
It sounds like this is what ColdFusion is intended for, except on a much smaller scale. I doubt you'll have any problems. You might even be able to get away with using Access if you can guarantee only 8 people are going to be using the database, although, if you don't have to, I wouldn't. You'll have to make sure that all the laptops have TCP/IP set up (<-- is that obvious?) and I don't anticipate any problems. Les Irvin wrote: > I need some advice... > I'd like to use Cold Fusion in the following way: > - 8 people with laptops networked together. > - One laptop acting as the Cold Fusion server. > - All 8 people simultaneously querying/updating/editing the database on the > server through their browsers. > > Is it possible? What restrictions would I have? What sort of problems > should I expect? > Thanks in advance for any input. > Les > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SPS
As far as I am aware it is a feature of a Sun Microsystems technology. Probably one of their out of the box products. N http://www.mcbdigital.com ---> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session variables timing out
Hi Sebastian, You are correct. If the public area is all .htm(l) files (rather, non ..cfm), the CF server is never invoked, and can't reset the sessions. You could rename all files to .cfm and put the application.cfm in root. Of course, you'll be using CF server to process html pages for no practical reason (other than maintaining state). Depending on your server's load, it probably won't be a problem. Good luck, Jeff -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 8:04 AM To: CF-Talk Subject: session variables timing out I have a site with 2 sections. The members only directory uses the application scope with session variables and the general public directories are all html files without any application.cfm. If a user goes from the member site to the public site and is active in the public site does that activity postpone the session variables timing out in the member site? My guess is no. Thanks Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Somewhat OT???Escaping Hexidecimal
Hey everone: Does anyone know a way to escape hex values, ie stuff like #FF CF throws an error when I do this The only work around I have found to date is to leave off the # from hex values it seems to work ok. but creates odd looking code. Any ideas Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Syntax for binding a query?
Hey all, Can anyone tell me what the SQL syntax is for binding a query (Oracle db)? Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Somewhat OT???Escaping Hexidecimal
> Does anyone know a way to escape hex values, ie > stuff like #FF CF throws an error when I do this > > The only work around I have found to date is to leave > off the # from hex values it seems to work ok. but creates > odd looking code. Within a CFOutput or CFSet you need to double #s, otherwise it thinks it's a variable name Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Somewhat OT???Escaping Hexidecimal
Hi Rick, You escape the hexadecimal values by adding another # sign... e.g., "##FF" Terri Original Message Follows From: "Richard L Smith" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Somewhat OT???Escaping Hexidecimal Date: Mon, 05 Feb 2001 08:31:07 -0500 Hey everone: Does anyone know a way to escape hex values, ie stuff like #FF CF throws an error when I do this The only work around I have found to date is to leave off the # from hex values it seems to work ok. but creates odd looking code. Any ideas Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Somewhat OT???Escaping Hexidecimal
or double it ##FF odd looking too:) Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Richard L Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 8:31 AM Subject: Somewhat OT???Escaping Hexidecimal > Hey everone: > > Does anyone know a way to escape hex values, ie > stuff like #FF CF throws an error when I do this > > The only work around I have found to date is to leave > off the # from hex values it seems to work ok. but creates > odd looking code. > > Any ideas > > Rick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Somewhat OT???Escaping Hexidecimal
escape it with another # ##FF this is only necessary between a set of tags At 08:31 AM 2/5/01 -0500, you wrote: >Hey everone: > >Does anyone know a way to escape hex values, ie >stuff like #FF CF throws an error when I do this > >The only work around I have found to date is to leave >off the # from hex values it seems to work ok. but creates >odd looking code. > >Any ideas > >Rick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multi-part mail
I don't think you can send multipart emails with cfmail, you'll need to use IMS or use another workaround. IMS have a free version of their post server at the moment, you can get it at www.coolfusion.com Alternatively you can use cfmail to send a html-only version that will work fine on all html-compatible email clients. Just use: type="HTML" in the cfmail tag -Original Message- From: Michael de Lucia [mailto:[EMAIL PROTECTED]] Sent: 02 February 2001 16:18 To: CF-Talk Subject: multi-part mail Hello, How can I send a mutli-part e-mail using CFMAIL in a way that I can bind an image to the mail so it can used in the e-mail signature (typically the company logo). Attachement will of course not do the trick since the image is used for in the layout of the HTML format e-mail. Thx in advance, Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Somewhat OT???Escaping Hexidecimal
Go with the "double it" idea to insure cross browser compatibility. Don't break coding conventions where you don't *have* to. -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 8:55 AM To: CF-Talk Subject: Re: Somewhat OT???Escaping Hexidecimal or double it ##FF odd looking too:) Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Richard L Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 8:31 AM Subject: Somewhat OT???Escaping Hexidecimal > Hey everone: > > Does anyone know a way to escape hex values, ie > stuff like #FF CF throws an error when I do this > > The only work around I have found to date is to leave > off the # from hex values it seems to work ok. but creates > odd looking code. > > Any ideas > > Rick > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Somewhat OT???Escaping Hexidecimal
On this subject (and I know I'm being a pest about this), has anyone got anywhere with the beginnings of the CF-FAQ? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SPS
http://www.sun.com/desktop/success/manchester_united.html;$sessionid$QFEXRMY AABQBFAMTA1FU3NQ N http://www.mcbdigital.com ---> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax for binding a query?
> Can anyone tell me what the SQL syntax is for binding a query (Oracle db)? Terri, Not sure what you mean. To me "binding a query" refers to the action of associating values with variable names when when querying a database. In SQL this is simply done by saying "WHERE columnname = value". Or are you asking about "bind variables" in Oracle PL/SQL? These are local variables in stored procedures or triggers which you declare "VARIABLE variablename datatype" and refer to by saying something like ":variablename := value" Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL spooling error message
Has anyone seen this message before when trying to use CFMAIL? Error occurred while attempting to spool mail message to file (spool directory = 'd:\CFUSION\MAIL\SPOOL\', recipient='[EMAIL PROTECTED]', subject='Action') All or part of the path is invalid. (Filename=) The code is: #username# tried to log On! The directory d:\cfusion\mail\spool\ exists on the ColdFusion server and the drive isn't full. Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL spooling error message
> Has anyone seen this message before when trying to use CFMAIL? > > > Error occurred while attempting to spool mail message to > file (spool directory = 'd:\CFUSION\MAIL\SPOOL\', > recipient='[EMAIL PROTECTED]', subject='Action') > [ snip ] I just tried removing the SERVER value and letting it use the default mail server in CF Administrator, but am still seeing the same error message. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems with IsAuthorized
Attached is a gif that hopefully explains the policy I have in place, a userobject called display, that only has me listed, and I have no execute permission for (ie, there are no Resource Rules for the policy 'Default', the only policy in the PS_Private context, which only has enable for resource types:user object ticked) I'm using a Application.cfm to do auth. against our NT domain, which works fine, but when I try to use: Auth1: #IsAuthenticated()# Auth2: YESNO I always get the result "Auth1: Yes Auth2: Yes", even if I change display to 'sadfasfaf' and execute to 'werqwrq', which is not the behaviour I expect - surly for non existant objects it should give 'NO', and anyways, I'm not authorised to execute that object, so it should be 'NO' in any case ? Its CF 4.5.1 on NT/IIS Regards, <> Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax for binding a query?
Oops. Yes, I should have been more specific :) and stipulated "bind variables". I'm talking about improving our db performance by "caching" the best execution paths for the queries. I know 4.5 uses the CFQUERYPARAM tag, but alas, we are still on 4.0. I was hoping that there would be an equivalent way in 4.0 that would be relatively painless, but from what I've found so far, it looks like our only choice would be to used stored procedures to pass the variables to Oracle and allow Oracle to do the rest... Original Message Follows From: "DeVoil, Nick" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Syntax for binding a query? Date: Mon, 05 Feb 2001 15:26:04 - > Can anyone tell me what the SQL syntax is for binding a query (Oracle db)? Terri, Not sure what you mean. To me "binding a query" refers to the action of associating values with variable names when when querying a database. In SQL this is simply done by saying "WHERE columnname = value". Or are you asking about "bind variables" in Oracle PL/SQL? These are local variables in stored procedures or triggers which you declare "VARIABLE variablename datatype" and refer to by saying something like ":variablename := value" Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL spooling error message
The Server value will have no affect on how the mail is written to the spool. Is this error happening continually? Are there any files in the spool folder? What do you have in the following reg key: HKLM\\Software\Allaire\ColdFusion\CurrentVersion\Mail\BaseDirectory Are you running CF under something other than the system account? If so, does the user have rights to the spool folder? Do you, maybe , have a file called d:\cfusion\mail\spool? Regards, Howie - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 11:14 AM Subject: RE: CFMAIL spooling error message > > Has anyone seen this message before when trying to use CFMAIL? > > > > > > Error occurred while attempting to spool mail message to > > file (spool directory = 'd:\CFUSION\MAIL\SPOOL\', > > recipient='[EMAIL PROTECTED]', subject='Action') > > [ snip ] > > I just tried removing the SERVER value and letting it use the default mail > server in CF Administrator, but am still seeing the same error message. > > > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > http://www.netshopperuk.com/ > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
Default behaviour for non existant obs/policies will be true for IsAuthorized. As for your userobject, display, try IsProtected() on it and see if it's returning true. === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 11:14 AM > To: CF-Talk > Subject: Problems with IsAuthorized > > > Attached is a gif that hopefully explains the policy I have in place, a > userobject called display, that only has me listed, and I have no execute > permission for (ie, there are no Resource Rules for the policy 'Default', > the only policy in the PS_Private context, which only has enable for > resource types:user object ticked) > > I'm using a Application.cfm to do auth. against our NT domain, which works > fine, but when I try to use: > > Auth1: #IsAuthenticated()# > Auth2: IsAuthorized("UserObject","display","execute")>YESNO > > I always get the result "Auth1: Yes Auth2: Yes", even if I change > display to > 'sadfasfaf' and execute to 'werqwrq', which is not the behaviour > I expect - > surly for non existant objects it should give 'NO', and anyways, I'm not > authorised to execute that object, so it should be 'NO' in any case ? > > Its CF 4.5.1 on NT/IIS > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: JS syntax error
This code works in IE, but not in Netscape (4.61)... Can someone help? function windowOpen() { leftPos=0; if (screen) { leftPos=screen.width-420; topPos=screen.height-470; } var myWindow= window.open('index.cfm?fuseapp=Products&fuseaction=Catalog','PopUp', 'height=screen.height,width=400,left='+leftPos+',top=30,scrollbars=yes,resizable=no, toolbar=no,menubar=no'); if (!myWindow.opener) myWindow.opener = self; } Gene Kraybill LPW & Associates - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
> Attached is a gif that hopefully explains the policy I have in place It won't be as the CF-Talk list cuts off all attachments - it's an extreme way of stopping Viruses spreading, and I'm DAMN happy it's there Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anybody know anything about Intershipper?
It appears that since Jan, 30, the Intershipper interface on one of my sites has not been working. Anybody else having a problem? Is Intershipper the problem or should I be looking at our end? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
Thomas, Unless something is defined as Protected in the Advanced Security setup then IsAuthorized("UserObject","display","execute") will always return 'true'. The IsAuthenticated is returning 'true' because you have already logged in. To get round this you can do an IsProtected("display") before you do the IsAuthorized() call. If it isn't protected then you can assume that either 1. everyone can access it 2. nobody can access it HTH, Keith -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 05 February 2001 16:14 To: CF-Talk Subject: Problems with IsAuthorized Attached is a gif that hopefully explains the policy I have in place, a userobject called display, that only has me listed, and I have no execute permission for (ie, there are no Resource Rules for the policy 'Default', the only policy in the PS_Private context, which only has enable for resource types:user object ticked) I'm using a Application.cfm to do auth. against our NT domain, which works fine, but when I try to use: Auth1: #IsAuthenticated()# Auth2: YESNO I always get the result "Auth1: Yes Auth2: Yes", even if I change display to 'sadfasfaf' and execute to 'werqwrq', which is not the behaviour I expect - surly for non existant objects it should give 'NO', and anyways, I'm not authorised to execute that object, so it should be 'NO' in any case ? Its CF 4.5.1 on NT/IIS Regards, <> Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
Oops, try http://www.compsoc.man.ac.uk/~falken/pic1.gif :-) -Original Message- From: Thomas Chiverton Sent: Monday, February 05, 2001 4:14 PM To: CF-Talk Subject: Problems with IsAuthorized Attached is a gif that hopefully explains the policy I have in place, a userobject called display, that only has me listed, and I have no execute permission for (ie, there are no Resource Rules for the policy 'Default', the only policy in the PS_Private context, which only has enable for resource types:user object ticked) I'm using a Application.cfm to do auth. against our NT domain, which works fine, but when I try to use: Auth1: #IsAuthenticated()# Auth2: YESNO I always get the result "Auth1: Yes Auth2: Yes", even if I change display to 'sadfasfaf' and execute to 'werqwrq', which is not the behaviour I expect - surly for non existant objects it should give 'NO', and anyways, I'm not authorised to execute that object, so it should be 'NO' in any case ? Its CF 4.5.1 on NT/IIS Regards, <> Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Indexing strategies
I'm probably being to lazy here, but here goes. I will state now that I have not run this code, but I am just trying to understand collections and how they work. I've created a content management system. A document entry has: document_id, title, summary. Optionally the document has a url or document_text or a file. The files are stored outside of the web root and delivered by cfcontent. I have a reindex action that does the following: 1) Destroy the collection. 2) Recreate the collection. 3) Select the set of 'approved' documents (so those that are visible to end-users) and generate the collection entries via: 4) This is where the problem starts... I then check to see if a document has an associated file and want to index the file. Documents are stored in a tree hierachy : siteidentifier/section/filename. In theory I want to index a file against a reference of its document_id. Documents have associated with them specific 'rights' so all that a verity returns is not always valid for that end user and I really need that document_id. Theoretically I can convert the document path (if available) into a list and then determine the section, the filename and from that derive the document_id. This will probably mean setting up a number of extra indexes on the database table for speeds sake. So the question is, can I index a document that is stored offline, while referencing against an document_id (not the filename or url). Please note that the collection will already be using the document_id as part of a previous index of type custom. Answers in less than a thousand words and preferably not "no". :-) Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 x5450 m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:RE: Help: WDDX deserialize problem - still get error
Hi Simon... and others who responded. Thank you for getting back to me so quickly. I actually copied my original code from Forta's Advanced ColdFusion Application Development 4.0, Page. 284: Chapter 16 16 Using WDDX to Create Distributed Applications. However, I changed my code as you suggested and I am still getting problems. I am running 4.0.1 CF SYBASE Advantage holds my database and I'm on a UNIX CF server. On the action page: Results: Error Occurred While Processing Request Error Diagnostic Information XML parsing error: not well-formed (error code 4, line 1, column 11, buffer offset 11) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (12:2) to (15:21) in the template file /albweb/inet/docs/intranet/cfapps/star/sync/tt_wddx_action.cfm The specific sequence of files included or processed is: /albweb/inet/docs/intranet/cfapps/star/sync/tt_wddx_action.cfm . Date/Time: Mon Feb 05 11:33:45 2001 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.57.92.152 HTTP Referer: http://albwebdev2/cfapps/star/sync/tt_wddx.cfm Template: /albweb/inet/docs/intranet/cfapps/star/sync/tt_wddx_action.cfm Execution Time 50 milliseconds Parameters Form Fields: SUBMIT=Continue WDDXCONTENT=#wddxPacket# FIELDNAMES=WDDXCONTENT,SUBMIT Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: Help: WDDX deserialize problem Author: [EMAIL PROTECTED] Date: 2/2/01 3:51 PM HTML Formatting the XML Packet "breaks" the XML formatting. You shouldn't need to HTMLFormat the variable before passing it. If you wanted to format it at all and still be able to use it as XML, I'd think you'd want to use the XMLFormat() function. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 3:36 PM To: CF-Talk Subject: Help: WDDX deserialize problem I'm sure this is a Friday problem and I'm just brain dead but I have no idea what is going wrong or what the message directs me to correct. Something is happening and I've no idea how to fix it or where to look. Would appreciate it if someone could point me in right direction. It is probably right under my nose but it has eluded me for longer than I care to say. Works fine: dump shows all info, no problem (fields that have NULL in them are showing up empty) #HTMLEditFormat(wddxPacket)# : also shows everything, no problem OK. Stick in a form. B! Error Diagnostic Information XML parsing error: not well-formed (error code 4, line 1, column 15, buffer offset 15) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (50:1) to (53:20) in the template file /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm The specific sequence of files included or processed is: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm . Date/Time: Fri Feb 02 15:32:13 2001 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.57.92.152 HTTP Referer: http://albwebdev2/cfapps/star/sync/sync_main_action.cfm Template: /albweb/inet/docs/intranet/cfapps/star/sync/sync_main_action2.cfm Thanks, in advance, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Basics - Help please
Hi All, I have not used Verity a whole lot, so would appreciate some advice. I have a client who has a CF site that was built by someone, somewhere and a Verity collection was created. The client has since deleted some files, and tried to re-index so that the deleted files would no longer apprear in the search results. I *THINK* the person at the controls did a "Purge". It re-indexed, but for some reason, included the sub-folder name where the .cfm search template are, and is appending it to the URL of each result. So I can search accurately, but when I click a resulting URL, I get a 404 because the URL is something like this: http://mysite/SEARCH/agreement/file.htm The path is OK *EXCEPT* the "Search" folder in the path. As stated, this is not where the indexed/searchable files are, but where the cf template uses to initiate the search is. To make matters worse, the server is half way across the country, and the IT staff there know NOTHING about CF and will not give me access, and expect me to coach them via e-mail. Couls someone also clarify the difference between "Index" "Repair" "Optimize" and "Purge"? Thanks James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Help: WDDX deserialize problem - still get error
I think this is your problem: > Parameters > Form Fields: > > SUBMIT=Continue > WDDXCONTENT=#wddxPacket# > FIELDNAMES=WDDXCONTENT,SUBMIT In the WDDXCONTENT field, you should have a WDDX packet, not a reference to one. In your form, make sure you're evaluating the variable: Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Server Feedback
Does anybody have any input for a cheap CF Server, I have a limited Budget? What kind a system would be the best(cheapest) way to suite my needs. I am a small time developer, most of my clients have low traffic at this point, my highest trafficed client is getting about 5,000 page views a day. I am pretty new to Web Servers and Networking as well. I will be hosting less then 50 accounts for know. Here's what I have been looking at: -512K DSL Connection -Linksys DSL Router Server 1 -CF Professional (Entriprise pushes me out of my budget) -Windows 2000 -O'Reilly Website -Media House Live Stats Server 2 -SQL Server -IpSwitch I-Mail -Name Server Any advice would be greatly appreciated. Jason Larson [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I figured it out - THANKS
Heath, I figured out how to verify all questions were being answered. Thanks, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax for binding a query?
Yes, that sounds like a good idea. I don't think CFQUERYPARAM would have helped you with performance anyway. It just validates the parameters you pass to the stored procedure. I'm guessing here but are you actually looking for the syntax for passing parameters to an Oracle stored procedure? In which case you want something like (CF template) (SQL for creating the stored procedure) create or replace procedure procname (variablename in varchar2) as begin select columnname from tablename where columnname = variablename; ... end procname; I think you only need to use *bind variables* if you are going to build the SQL statement dynamically within the stored procedure and execute it with EXECUTE IMMEDIATE. But that's only if you don't know which columns ar tables are going to be referenced until runtime. Nick -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 4:19 PM To: CF-Talk Subject: RE: Syntax for binding a query? Oops. Yes, I should have been more specific :) and stipulated "bind variables". I'm talking about improving our db performance by "caching" the best execution paths for the queries. I know 4.5 uses the CFQUERYPARAM tag, but alas, we are still on 4.0. I was hoping that there would be an equivalent way in 4.0 that would be relatively painless, but from what I've found so far, it looks like our only choice would be to used stored procedures to pass the variables to Oracle and allow Oracle to do the rest... Original Message Follows From: "DeVoil, Nick" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Syntax for binding a query? Date: Mon, 05 Feb 2001 15:26:04 - > Can anyone tell me what the SQL syntax is for binding a query (Oracle db)? Terri, Not sure what you mean. To me "binding a query" refers to the action of associating values with variable names when when querying a database. In SQL this is simply done by saying "WHERE columnname = value". Or are you asking about "bind variables" in Oracle PL/SQL? These are local variables in stored procedures or triggers which you declare "VARIABLE variablename datatype" and refer to by saying something like ":variablename := value" Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JS syntax error
Gene left and top are screenX and screenY in NN. Nick -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 7:35 PM To: CF-Talk Subject: OT: JS syntax error This code works in IE, but not in Netscape (4.61)... Can someone help? function windowOpen() { leftPos=0; if (screen) { leftPos=screen.width-420; topPos=screen.height-470; } var myWindow= window.open('index.cfm?fuseapp=Products&fuseaction=Catalog','PopUp', 'height=screen.height,width=400,left='+leftPos+',top=30,scrollbars=yes,resiz able=no, toolbar=no,menubar=no'); if (!myWindow.opener) myWindow.opener = self; } Gene Kraybill LPW & Associates - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anybody know anything about Intershipper?
Hi, There are a few of us with the same problem. The actual issue is to do with specifying FEDEX as a shipper. If you remove FEDEX then it should start working again. You might want to contact the kind Gent at Desert Raven that wrote the tag. He said he would look into the problem. Regards, Eron -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:36 AM To: CF-Talk Subject: Anybody know anything about Intershipper? It appears that since Jan, 30, the Intershipper interface on one of my sites has not been working. Anybody else having a problem? Is Intershipper the problem or should I be looking at our end? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
multiple queries tie up web server
I have a CF page that contains approx 7500 queries against an Oracle database via an Apache web server. Of course this page takes a while to load (3 minutes or so), but my user is ok with that because she does so only a handful of times per day. What is not ok is that, while this page is loading, all other users of any CF app on that web server cannot access any page -- they will receive Apache's "server is too busy to handle request" error message. Any ideas on how to work around this? Reducing the number of queries from 7500 isn't really an option, unfortunately. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
3-dimensional array
How do I a 3-dimensional array? Thanks, Ryan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
High Traffic graphing
I am developing a site where there will be a lot of dynamic graphing. I am expecting approximately 500 concurrent users on the site. Most of them will be doing the graphing application that I am creating. I am thinking of using Crystal Reports 8 with is web component for this. I was wondering if anyone out there had any experience with this? I am also wondering if Crystal Reports will be able to handle this amount of traffic? I am also wondering if there is something out there that can do graphed reporting that is not as expensive as the Macromedia Generator. Any comments are welcome. Alan Koenig While jumping on a train, one of Ghandis sandals fell off on the platform of the train station. He quickly proceeded to take the other side off and threw it on the platform as the train left the station. His disciple asked, Master what are you doing? Ghandis reply was One side of my sandal will be of no use to the soul who finds it, so I am giving him the other. -- In love and Friendship, Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
IsProtected("UserObject","display","execute") Returns 'No', so I guess that means there is something wrong with my policies ? (This is with my user added back into the userlist for that policy. -Original Message- From: Raymond Camden [mailssto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 4:31 PM To: CF-Talk Subject: RE: Problems with IsAuthorized Default behaviour for non existant obs/policies will be true for IsAuthorized. As for your userobject, display, try IsProtected() on it and see if it's returning true. === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 11:14 AM > To: CF-Talk > Subject: Problems with IsAuthorized > > > Attached is a gif that hopefully explains the policy I have in place, a > userobject called display, that only has me listed, and I have no execute > permission for (ie, there are no Resource Rules for the policy 'Default', > the only policy in the PS_Private context, which only has enable for > resource types:user object ticked) > > I'm using a Application.cfm to do auth. against our NT domain, which works > fine, but when I try to use: > > Auth1: #IsAuthenticated()# > Auth2: IsAuthorized("UserObject","display","execute")>YESNO > > I always get the result "Auth1: Yes Auth2: Yes", even if I change > display to > 'sadfasfaf' and execute to 'werqwrq', which is not the behaviour > I expect - > surly for non existant objects it should give 'NO', and anyways, I'm not > authorised to execute that object, so it should be 'NO' in any case ? > > Its CF 4.5.1 on NT/IIS > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Break in attempts?
We've noticed the following error in our logs recurring recently: "Error","TID=618","02/02/01","22:04:23","24.114.162.188","","Invalid Request of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM File You have requested a template with the name APPLICATION.CFM or ONREQUESTEND.CFM. These file names are reserved by the ColdFusion engine for the specification of application level settings and therefore cannot be directly requested from a web client.If you are creating a template which is intended for direct access by end users you should use a name other than APPLICATION.CFM or ONREQUESTEND.CFM." I remember reading about the above applications allowing hackers to change data sources and such. Does anybody have any more information? Or perhaps some remedies? Cheers, Jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
why use 3rd dimensional array???
how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple queries tie up web server
Why not try stored procedures so that CF isn't the one running the queries. If you do it that way, Oracle will do all the work while CF waits for the results. I think what is happening is the webserver is just getting bulked down. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Ricq Pattay [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:06 PM To: CF-Talk Subject: multiple queries tie up web server I have a CF page that contains approx 7500 queries against an Oracle database via an Apache web server. Of course this page takes a while to load (3 minutes or so), but my user is ok with that because she does so only a handful of times per day. What is not ok is that, while this page is loading, all other users of any CF app on that web server cannot access any page -- they will receive Apache's "server is too busy to handle request" error message. Any ideas on how to work around this? Reducing the number of queries from 7500 isn't really an option, unfortunately. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 3-dimensional array
-Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:24 PM To: CF-Talk Subject: 3-dimensional array How do I a 3-dimensional array? Thanks, Ryan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: multiple queries tie up web server
Is caching the query an option? If so you could set up a task that runs the query at like 6 in the morning or earlier when fewer people will be on the site and cache it for 24 hours. However if she is looking for updates throughout the day she won't see any without the 3 minute wait. Kevin - Original Message - From: "Ricq Pattay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 11:05 AM Subject: multiple queries tie up web server > I have a CF page that contains approx 7500 queries against an Oracle > database via an Apache web server. Of course this page takes a while to load > (3 minutes or so), but my user is ok with that because she does so only a > handful of times per day. > > What is not ok is that, while this page is loading, all other users of any > CF app on that web server cannot access any page -- they will receive > Apache's "server is too busy to handle request" error message. Any ideas on > how to work around this? Reducing the number of queries from 7500 isn't > really an option, unfortunately. > > > Ricq Pattay ~ [EMAIL PROTECTED] > College of Veterinary Medicine > University of Minnesota - Twin Cities > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 3-dimensional array
Kevin - Original Message - From: "Ryan Farrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 12:24 PM Subject: 3-dimensional array > How do I a 3-dimensional array? > > Thanks, > > Ryan > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IsAuthorized
I would guess so. Go into your CFAdmin and check stuff out. Tell us what you see. === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 12:11 PM > To: CF-Talk > Subject: RE: Problems with IsAuthorized > > > IsProtected("UserObject","display","execute") > Returns 'No', so I guess that means there is something wrong with my > policies ? (This is with my user added back into the userlist for that > policy. > > -Original Message- > From: Raymond Camden [mailssto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 4:31 PM > To: CF-Talk > Subject: RE: Problems with IsAuthorized > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Break in attempts?
Its probably just someone checking to see if you are running ColdFusion. I do that occasionally if I am not sure if a site is being served by ColdFusion. Duane -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To: CF-Talk Subject: Break in attempts? We've noticed the following error in our logs recurring recently: "Error","TID=618","02/02/01","22:04:23","24.114.162.188","","Invalid Request of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM File You have requested a template with the name APPLICATION.CFM or ONREQUESTEND.CFM. These file names are reserved by the ColdFusion engine for the specification of application level settings and therefore cannot be directly requested from a web client.If you are creating a template which is intended for direct access by end users you should use a name other than APPLICATION.CFM or ONREQUESTEND.CFM." I remember reading about the above applications allowing hackers to change data sources and such. Does anybody have any more information? Or perhaps some remedies? Cheers, Jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Feedback
why don't you use IIS? it's free. Website from O'Reilly costs like $1K or more. unless you already own it... and if you're only doing 5,000 pages a day, you don't need 2 servers if you're cramped for cash. -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:03 AM To: CF-Talk Subject: CF Server Feedback Does anybody have any input for a cheap CF Server, I have a limited Budget? What kind a system would be the best(cheapest) way to suite my needs. I am a small time developer, most of my clients have low traffic at this point, my highest trafficed client is getting about 5,000 page views a day. I am pretty new to Web Servers and Networking as well. I will be hosting less then 50 accounts for know. Here's what I have been looking at: -512K DSL Connection -Linksys DSL Router Server 1 -CF Professional (Entriprise pushes me out of my budget) -Windows 2000 -O'Reilly Website -Media House Live Stats Server 2 -SQL Server -IpSwitch I-Mail -Name Server Any advice would be greatly appreciated. Jason Larson [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple queries tie up web server
> I have a CF page that contains approx 7500 queries against an Oracle > database via an Apache web server. Of course this page takes a > while to load > (3 minutes or so), but my user is ok with that because she does so only a > handful of times per day. > > What is not ok is that, while this page is loading, all other users of any > CF app on that web server cannot access any page -- they will receive > Apache's "server is too busy to handle request" error message. > Any ideas on > how to work around this? Reducing the number of queries from 7500 isn't > really an option, unfortunately. I don't have Oracle experience, so I'm going from SQL Server experience... The problem is that it's speaking to the Oracle server 7,500 times on the one template, which means that it's handing the maximum queries to the server in one go, and then waiting for the next queries Can't you put the queries into Stored Procedures in blocks and get it to run those (thus returning multiple queries in one handle), which will be faster talking to the database Also, you might want to try using larger queries, and then using CF to break them up (i.e. with Joins or Unions) Is the result something that NEEDS to be done 2-3 times a day, or if it's a report, why can't it be run at slow times, and then email the result to the client... we do that with reports that take a long time to build, thus lessening the strain during the busy periods Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 3-dimensional array
> How do I a 3-dimensional array? Why not use Structures within the array? That way you get get away with a 2D array with a structure in each Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Break in attempts?
> We've noticed the following error in our logs recurring recently: > > "Error","TID=618","02/02/01","22:04:23","24.114.162.188","", > "Invalid Request of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM > File You have requested a template with the name APPLICATION.CFM > or ONREQUESTEND.CFM. These file names are reserved by the > ColdFusion engine for the specification of application level > settings and therefore cannot be directly requested from a web > client.If you are creating a template which is intended for > direct access by end users you should use a name other than > APPLICATION.CFM or ONREQUESTEND.CFM." > > I remember reading about the above applications allowing > hackers to change data sources and such. Does anybody have > any more information? Or perhaps some remedies? If your server is publicly available, you shouldn't have a CFDOCS directory, as you shouldn't have installed documentation and examples. If you do have those on there, remove them immediately. While you're at it, if you're running IIS, make sure you don't have sample code, unnecessary ISAPI extensions, etc. for that. As for people accessing application.cfm and onrequestend.cfm directly, there isn't a huge amount of harm, as CF will return the message you've noticed in your logs, rather than executing any code. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFStudio 4.5.2 issues
I will be posting this here and also to allaire forums. I have been using stinking studio forever, I updated to 4.5 because it had more features, but it seems the same bugs I had from the beginning that bugged me are still there. The bug where you are editing a file in amd it doesn't show the x next to the name to show that it has been changed. And now a new little bug where i can't turn off the design mode from telling me I could screw up the page by looking at it there. I hope allaire monitors this list to see my complaint. I usually try not to complain, but this is a $200 tool, get some programmers to fix this bugs that everyone complains about. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple queries tie up web server
7500 Queries? holly molly batman. Ok, just guessing but it sounds like your generating a report to meHere is what I would look at: 1) Apache (not familiar with Apache) must have some limit being set to the number of concurrent process's, and it it not queuing them or they are timing out, perhaps increase this setting. 2) Change the template so it calls another process (Schedule or batch) execute's the monster template in batch mode (no webserver involved), which writes the output to a static file or emails it to the user. Then the user can check the static file after a few minutes or wait for an email. There is a nice tag CF_FileWriteText that you can wrap around your code that nicely output's your html or whatever you need to output. Hope it helps... -Adrian -Original Message- From: Ricq Pattay [mailto:[EMAIL PROTECTED]] I have a CF page that contains approx 7500 queries against an Oracle database via an Apache web server. Of course this page takes a while to load (3 minutes or so), but my user is ok with that because she does so only a handful of times per day. What is not ok is that, while this page is loading, all other users of any CF app on that web server cannot access any page -- they will receive Apache's "server is too busy to handle request" error message. Any ideas on how to work around this? Reducing the number of queries from 7500 isn't really an option, unfortunately. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Break in attempts?
actually, ran into that error message when i named one of my templated MemberApplication.cfm. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To: CF-Talk Subject: Break in attempts? We've noticed the following error in our logs recurring recently: "Error","TID=618","02/02/01","22:04:23","24.114.162.188","","Invalid Request of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM File You have requested a template with the name APPLICATION.CFM or ONREQUESTEND.CFM. These file names are reserved by the ColdFusion engine for the specification of application level settings and therefore cannot be directly requested from a web client.If you are creating a template which is intended for direct access by end users you should use a name other than APPLICATION.CFM or ONREQUESTEND.CFM." I remember reading about the above applications allowing hackers to change data sources and such. Does anybody have any more information? Or perhaps some remedies? Cheers, Jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Feedback
Dylan, Do you think the DSL will be able to handle this (lets say 50 sites with 5,000 page views a day per site), or should I look at a T1 line. Thanks for your response. Jason Larson [EMAIL PROTECTED] -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:45 AM To: CF-Talk Subject: RE: CF Server Feedback why don't you use IIS? it's free. Website from O'Reilly costs like $1K or more. unless you already own it... and if you're only doing 5,000 pages a day, you don't need 2 servers if you're cramped for cash. -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:03 AM To: CF-Talk Subject: CF Server Feedback Does anybody have any input for a cheap CF Server, I have a limited Budget? What kind a system would be the best(cheapest) way to suite my needs. I am a small time developer, most of my clients have low traffic at this point, my highest trafficed client is getting about 5,000 page views a day. I am pretty new to Web Servers and Networking as well. I will be hosting less then 50 accounts for know. Here's what I have been looking at: -512K DSL Connection -Linksys DSL Router Server 1 -CF Professional (Entriprise pushes me out of my budget) -Windows 2000 -O'Reilly Website -Media House Live Stats Server 2 -SQL Server -IpSwitch I-Mail -Name Server Any advice would be greatly appreciated. Jason Larson [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: multiple queries tie up web server
We've had problems with Oracle drivers being single threaded-like. In other words, if a long running query is just waiting out there, other requests to that datasource have to wait. What version of CF and what oracle drivers are you using? Ricq Pattay wrote: > > I have a CF page that contains approx 7500 queries against an Oracle > database via an Apache web server. Of course this page takes a while to load > (3 minutes or so), but my user is ok with that because she does so only a > handful of times per day. > > What is not ok is that, while this page is loading, all other users of any > CF app on that web server cannot access any page -- they will receive > Apache's "server is too busy to handle request" error message. Any ideas on > how to work around this? Reducing the number of queries from 7500 isn't > really an option, unfortunately. > > Ricq Pattay ~ [EMAIL PROTECTED] > College of Veterinary Medicine > University of Minnesota - Twin Cities > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Feedback
Why not use Linux, Apache and PostgreSQL. You'll save nearly $10G that way. Then you can get Enterprise, and use the sandbox security. Geez, you could get 2 of them for redundancy. Is there a specific reason you need to use NT? Dylan Bromby wrote: > > why don't you use IIS? it's free. Website from O'Reilly costs like $1K or > more. unless you already own it... > > and if you're only doing 5,000 pages a day, you don't need 2 servers if > you're cramped for cash. > > -Original Message- > From: Jason Larson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 9:03 AM > To: CF-Talk > Subject: CF Server Feedback > > Does anybody have any input for a cheap CF Server, I have a limited Budget? > What kind a system would be the best(cheapest) way to suite my needs. I am a > small time developer, most of my clients have low traffic at this point, my > highest trafficed client is getting about 5,000 page views a day. I am > pretty new to Web Servers and Networking as well. I will be hosting less > then 50 accounts for know. > > Here's what I have been looking at: > > -512K DSL Connection > -Linksys DSL Router > > Server 1 > -CF Professional (Entriprise pushes me out of my budget) > -Windows 2000 > -O'Reilly Website > -Media House Live Stats > > Server 2 > -SQL Server > -IpSwitch I-Mail > -Name Server > > Any advice would be greatly appreciated. > > Jason Larson > [EMAIL PROTECTED] > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: why use 3rd dimensional array???
to hold 3 dimensional data. sorry. Simple example. some kind of cubic sample. like say air temperature in a room for each specific cubic foot. The index is h,w,l and the value corresponds to the appropriate cube in the room. I can get a better, more practival example if you like. E From: Phoeun Pha <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: why use 3rd dimensional array??? Date: Mon, 05 Feb 2001 12:35:38 -0600 how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Feedback
Dylan Bromby wrote: > why don't you use IIS? it's free. So is Apache and it doesn't come with arbitrary licence limitations that are designed to get you to buy their "server" OS. > and if you're only doing 5,000 pages a day, you don't need 2 servers if > you're cramped for cash. Or you could use mySQL and myODBC instead of SQL Server and save yourself enough money for the second server. -- Perfection has one grave defect: it is apt to be dull. Somerset Maugham email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Feedback
I have not worked with Linux, I do have some limited experience with NT though. I understand what you are saying and I am thinking of approaching this with a Linux server, though there would be a higher learning curve for me. Thanks for your response Jason Larson [EMAIL PROTECTED] -Original Message- From: Edward Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:13 PM To: CF-Talk Subject: Re: CF Server Feedback Why not use Linux, Apache and PostgreSQL. You'll save nearly $10G that way. Then you can get Enterprise, and use the sandbox security. Geez, you could get 2 of them for redundancy. Is there a specific reason you need to use NT? Dylan Bromby wrote: > > why don't you use IIS? it's free. Website from O'Reilly costs like $1K or > more. unless you already own it... > > and if you're only doing 5,000 pages a day, you don't need 2 servers if > you're cramped for cash. > > -Original Message- > From: Jason Larson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 9:03 AM > To: CF-Talk > Subject: CF Server Feedback > > Does anybody have any input for a cheap CF Server, I have a limited Budget? > What kind a system would be the best(cheapest) way to suite my needs. I am a > small time developer, most of my clients have low traffic at this point, my > highest trafficed client is getting about 5,000 page views a day. I am > pretty new to Web Servers and Networking as well. I will be hosting less > then 50 accounts for know. > > Here's what I have been looking at: > > -512K DSL Connection > -Linksys DSL Router > > Server 1 > -CF Professional (Entriprise pushes me out of my budget) > -Windows 2000 > -O'Reilly Website > -Media House Live Stats > > Server 2 > -SQL Server > -IpSwitch I-Mail > -Name Server > > Any advice would be greatly appreciated. > > Jason Larson > [EMAIL PROTECTED] > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Break in attempts?
On a related note, I once came across a server in which the cf developers had created the app in such a manner that all include code where in .inc files. You code just type www.server.com/login.inc and download the code. Not a good idea. Remember, just because you are "including" a file, other people might not . Justin >those on there, remove them immediately. While you're at it, if you're >running IIS, make sure you don't have sample code, unnecessary ISAPI >extensions, etc. for that. As for people accessing application.cfm and >onrequestend.cfm directly, there isn't a huge amount of harm, as CF will >return the message you've noticed in your logs, rather than executing any >code. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Feedback
depends. is it a personal or business DSL account according to the provider? you want to check the CIR (committed information rate) from your provider for both types of connections. -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:11 AM To: CF-Talk Subject: RE: CF Server Feedback Dylan, Do you think the DSL will be able to handle this (lets say 50 sites with 5,000 page views a day per site), or should I look at a T1 line. Thanks for your response. Jason Larson [EMAIL PROTECTED] -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:45 AM To: CF-Talk Subject: RE: CF Server Feedback why don't you use IIS? it's free. Website from O'Reilly costs like $1K or more. unless you already own it... and if you're only doing 5,000 pages a day, you don't need 2 servers if you're cramped for cash. -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:03 AM To: CF-Talk Subject: CF Server Feedback Does anybody have any input for a cheap CF Server, I have a limited Budget? What kind a system would be the best(cheapest) way to suite my needs. I am a small time developer, most of my clients have low traffic at this point, my highest trafficed client is getting about 5,000 page views a day. I am pretty new to Web Servers and Networking as well. I will be hosting less then 50 accounts for know. Here's what I have been looking at: -512K DSL Connection -Linksys DSL Router Server 1 -CF Professional (Entriprise pushes me out of my budget) -Windows 2000 -O'Reilly Website -Media House Live Stats Server 2 -SQL Server -IpSwitch I-Mail -Name Server Any advice would be greatly appreciated. Jason Larson [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: studio 4.5.2
Well, I like Studio 4.5.1, and it's works well for me. I tried 4.5.2 and hated all the ftp-connectivity bugs (winsock errors, etc.). Twice it erased a file when trying to save my work to an FTP-connected server. So I went back to 4.5.1 and it works fine. sigh Chris Norloff -- Original Message -- From: "Deanna L. Schneider" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 01 Feb 2001 13:58:23 -0600 >All right, so long ago, I upgraded to studio 4.5, hated it, and went back to >4.0. Now, all I've heard is good things about 4.5.2, so I installed 4.5 >again and upgraded to 4.5.2. > >Now, I keep getting low resource warnings (which was not happening with 4.0) >AND when I browse a directory that has sub-directories, I have to click the >folder icon of subdirectory and then click the icon of the directory before >I can see files that aren't in one of the sub-folders. > >Am I the only one that this is happening to? Or are these common bugs and I >should just resign myself to the idea that I'm never going to get past 4.0. > >-d > > > > >Deanna Schneider >Interactive Media Developer >UWEX Cooperative Extension Electronic Publishing Group >103 Extension Bldg >432 N. Lake Street >Madison, WI 53706 >(608) 265-7923 > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 3-dimensional array
Think of it as a 3 dimensional box. +-+ / /| / / | +--+ | | | | | | | | | / +--+/ Hehe Okay here is a example... not that you would but you could. If you think of a query as a two dimesonal array. Query1(z) Row1(y) Col1(x) Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 Query2 Row1 Col1 Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 As an array arrJunk[1][1] = Row one column one arrJunk[2][3] = Row two column three.. etc. etc. Now say you want this single array to represent multiple queries at once. so arrJunk[1][2][4] = Query1, Row2, Column4 or arrJunk[2][2][4] = Query2, Row2, Column4 Now for say a four dimensional array... hehehe stay with me!! Time: 8:00pm(eeek) Query1(z) Row1(y) Col1(x) Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 Query2 Row1 Col1 Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 Time: 9:00pm Query1 Row1 Col1 Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 Query2 Row1 Col1 Col2 Col3 Col4 Col5 Col6 Row2 Col1 Col2 Col3 Col4 Col5 Col6 So (this would be a bad way to represent your data... but if you wanted too... you could Okay, so say you wanted 9pm Query2 Row2 Col5 arrJunk[2][2][2][5] = 9pm, query2, row2, column5 Hehe, so yes the practical applications of this kind of thing are few and far between but there are some very valid representations such as mapping out objects in 3D space (of course you wouldnt really use an array then.. but anyways) it does have uses... but if you end up with a 3D array you most likely do not need it. Anyhow... I hope I did not hurt anyones head. Jeremy Allen elliptIQ Inc. >-Original Message- >From: Phoeun Pha [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 05, 2001 1:35 PM >To: CF-Talk >Subject: RE: 3-dimensional array > > > > > > > >-Original Message- >From: Ryan Farrell [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 05, 2001 12:24 PM >To: CF-Talk >Subject: 3-dimensional array > > >How do I a 3-dimensional array? > >Thanks, > >Ryan > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array???
well yeah i can see how it can be used for math stuff. but i mean like a real situation -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:17 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? to hold 3 dimensional data. sorry. Simple example. some kind of cubic sample. like say air temperature in a room for each specific cubic foot. The index is h,w,l and the value corresponds to the appropriate cube in the room. I can get a better, more practival example if you like. E From: Phoeun Pha <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: why use 3rd dimensional array??? Date: Mon, 05 Feb 2001 12:35:38 -0600 how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:Can you change "Browse..." on a File form element?
Hi, Bilingual app, client doesn't want to see "Browse..." on a file form element. Any way to do that short of building one from a textbox and button? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: why use 3rd dimensional array???
Since when was math stuff not a real situation - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:36 PM Subject: RE: why use 3rd dimensional array??? > well yeah i can see how it can be used for math stuff. but i mean like a > real situation > > > -Original Message- > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 1:17 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > to hold 3 dimensional data. sorry. > > Simple example. some kind of cubic sample. like say air temperature in a > room for each specific cubic foot. The index is h,w,l and the value > corresponds to the appropriate cube in the room. > > I can get a better, more practival example if you like. > > E > > From: Phoeun Pha <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: why use 3rd dimensional array??? > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > how would one use a third dimensional array? it's hard for me to > conceptualize a practical use for it! > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple queries tie up web server
Hey there, is these a query that needs to run interactive? one way that you can approach this is to create a file that will contain all the fields (data) that is been pulled in by all these queries, yes, it will be a BIG file, but if you have the space on the server sometimes that is the best approach, then you can schedule this to be run by the SQL server... Bismarck Perez -Original Message- From: Ricq Pattay [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:06 PM To: CF-Talk Subject: multiple queries tie up web server I have a CF page that contains approx 7500 queries against an Oracle database via an Apache web server. Of course this page takes a while to load (3 minutes or so), but my user is ok with that because she does so only a handful of times per day. What is not ok is that, while this page is loading, all other users of any CF app on that web server cannot access any page -- they will receive Apache's "server is too busy to handle request" error message. Any ideas on how to work around this? Reducing the number of queries from 7500 isn't really an option, unfortunately. Ricq Pattay ~ [EMAIL PROTECTED] College of Veterinary Medicine University of Minnesota - Twin Cities ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax for binding a query?
Original Message Follows From: "DeVoil, Nick" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Syntax for binding a query? Date: Mon, 05 Feb 2001 17:04:56 - Yes, that sounds like a good idea. I don't think CFQUERYPARAM would have helped you with performance anyway. It just validates the parameters you pass to the stored procedure. --I think you're thinking of CFPROCPARAM. CF*QUERY*PARAM enables the use of bind variables in a query (according to the Allaire article titled "CFQUERYPARAM and Oracle Databases" by Justin Fidler--it's actually quite a good article. Someone on another list pointed it out to me this morning.)--- I'm guessing here but are you actually looking for the syntax for passing parameters to an Oracle stored procedure? --Nope. Though I do appreciate the example. I've had my share of passing the params to Oracle, and it's not always easy :)) Extra examples are always appreciated!-- Thanks for the help! I think we're just going to push for the upgrade to 4.5 (with a subscription, of course, with 5.0 and Neo on the horizon ;) Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array???
well, I've figured another way around this problem, but I'd still like to know how to do this. Sorry I was not more specific in my question. I know how to declare the array, but how do I load data into all 3 dimensions? -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To: CF-Talk Subject: RE: why use 3rd dimensional array??? well yeah i can see how it can be used for math stuff. but i mean like a real situation -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:17 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? to hold 3 dimensional data. sorry. Simple example. some kind of cubic sample. like say air temperature in a room for each specific cubic foot. The index is h,w,l and the value corresponds to the appropriate cube in the room. I can get a better, more practival example if you like. E From: Phoeun Pha <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: why use 3rd dimensional array??? Date: Mon, 05 Feb 2001 12:35:38 -0600 how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array???
I've used 3 dimensional arrays to produce mini-mystery games where the x,y was the location and z was time. Basically the x,y defaults to a standard "room picture clip" if n[x][y][z] was empty, but you can add an "event" to any room by pointing n[x][y][z] at an animation or movie file. then you let the person wander, where north is x-1, south x+1, west y-1, and east y+1, and every move increments z by 1. Admittedly really primitive, but it worked for a simple "TESOL through gaming" demo I did back in my grad school days in VB. Mike. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To: CF-Talk Subject: RE: why use 3rd dimensional array??? well yeah i can see how it can be used for math stuff. but i mean like a real situation -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:17 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? to hold 3 dimensional data. sorry. Simple example. some kind of cubic sample. like say air temperature in a room for each specific cubic foot. The index is h,w,l and the value corresponds to the appropriate cube in the room. I can get a better, more practival example if you like. E From: Phoeun Pha <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: why use 3rd dimensional array??? Date: Mon, 05 Feb 2001 12:35:38 -0600 how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can you change "Browse..." on a File form element?
Have you tested to see if it's controlled by the language version of the user's Browser/OS? May not be an issue for speakers of other languages as long as they have a native language install of their Browser/OS. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:53 PM > To: CF-Talk > Subject: OT:Can you change "Browse..." on a File form element? > > > Hi, > Bilingual app, client doesn't want to see "Browse..." on a file form > element. Any way to do that short of building one from a textbox > and button? > > Jim > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: why use 3rd dimensional array???
LOL - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 11:36 AM Subject: RE: why use 3rd dimensional array??? > well yeah i can see how it can be used for math stuff. but i mean like a > real situation > > > -Original Message- > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 1:17 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > to hold 3 dimensional data. sorry. > > Simple example. some kind of cubic sample. like say air temperature in a > room for each specific cubic foot. The index is h,w,l and the value > corresponds to the appropriate cube in the room. > > I can get a better, more practival example if you like. > > E > > From: Phoeun Pha <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: why use 3rd dimensional array??? > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > how would one use a third dimensional array? it's hard for me to > conceptualize a practical use for it! > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array???
Math is fun "stuff" :) I think the thread should be killed now. Thanks. -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:57 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? Since when was math stuff not a real situation - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:36 PM Subject: RE: why use 3rd dimensional array??? > well yeah i can see how it can be used for math stuff. but i mean like a > real situation > > > -Original Message- > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 1:17 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > to hold 3 dimensional data. sorry. > > Simple example. some kind of cubic sample. like say air temperature in a > room for each specific cubic foot. The index is h,w,l and the value > corresponds to the appropriate cube in the room. > > I can get a better, more practival example if you like. > > E > > From: Phoeun Pha <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: why use 3rd dimensional array??? > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > how would one use a third dimensional array? it's hard for me to > conceptualize a practical use for it! > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: multiple queries tie up web server
Thanks for the responses so far. More info: We're running CF Server 4.51 Enterprise, with the Oracle 7.3 native drivers. And *all* requests to the web server are refused, not just those to the same datasource. So this sounds more like a web server problem (as Robert said). The page in question isn't a report, but a dynamic grid of enrollment counts for multiple courses held at multiple times. Each course/time combination has 4 queries associated with it, 3 of which are "select count(user_id)..." Each course/time intersection has javascript pop-up windows associated with it so my user can add/drop/move students to/from other intersections on the schedule grid. I can't really cache the query because there's 7500 of them! :-) I don't know enough yet about writing stored procedures to investigate this route. Maybe this is a good time to learn? But would using SP's even help if there are so many little queries? - Original Message - From: "Edward Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:10 PM Subject: Re: multiple queries tie up web server > We've had problems with Oracle drivers being single threaded-like. In > other words, if a long running query is just waiting out there, other > requests to that datasource have to wait. > > What version of CF and what oracle drivers are you using? > > Ricq Pattay wrote: > > > > I have a CF page that contains approx 7500 queries against an Oracle > > database via an Apache web server. Of course this page takes a while to load > > (3 minutes or so), but my user is ok with that because she does so only a > > handful of times per day. > > > > What is not ok is that, while this page is loading, all other users of any > > CF app on that web server cannot access any page -- they will receive > > Apache's "server is too busy to handle request" error message. Any ideas on > > how to work around this? Reducing the number of queries from 7500 isn't > > really an option, unfortunately. > > > > Ricq Pattay ~ [EMAIL PROTECTED] > > College of Veterinary Medicine > > University of Minnesota - Twin Cities > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Got PDFlib?
I'm considering using PDFlib to generate PDF files on the fly, and I was wondering if anyone has some experience to share. We can't use existing pdf templates because the number of fields varies, and it's my understanding that PDFlib allows you to create the PDF dynamically on the server. Originally we were using Crystal Reports and CFX_CRWTOPDF which no longer works, and I haven't been able to find anything to replace it that combination. Generating the PDF files on the server is the best alternative I've been able to come up with. Got better ones? Marianne Daye Center for Engineering and Environmental Technology Programmer/Analyst Research Triangle Institute Information Delivery Systems3040 Cornwallis Rd. http://ids.rti.org Research Triangle Park, NC 27709 Ph: (919) 541-8031, Fax: (919) 541-6936 http://www.rti.org ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can you change "Browse..." on a File form element?
Hmm...good idea. Problem is, most people here use english windows/browser, but expect fully functional on-the-fly french/english apps. Be happy that the US only has one official language... Jim -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:12 PM To: CF-Talk Subject: RE: Can you change "Browse..." on a File form element? Have you tested to see if it's controlled by the language version of the user's Browser/OS? May not be an issue for speakers of other languages as long as they have a native language install of their Browser/OS. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:53 PM > To: CF-Talk > Subject: OT:Can you change "Browse..." on a File form element? > > > Hi, > Bilingual app, client doesn't want to see "Browse..." on a file form > element. Any way to do that short of building one from a textbox > and button? > > Jim > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and Cobalt Server
Has anybody heard of anyone running CF Server on a Cobalt RAQ system. If so, is there something that I should worry about putting CF on A Cobalt RAQ system? Thanks Jason Larson [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Got PDFlib?
I've had great luck and experiences doing this with activepdf server. Check out www.activepdf.com for details about their various servers and products (you're probably interested in the activepdf server, and possibly webgrabber or the activepdf toolkit). Good Luck!! ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Daye, Marianne [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:17 PM To: CF-Talk Subject: Got PDFlib? I'm considering using PDFlib to generate PDF files on the fly, and I was wondering if anyone has some experience to share. We can't use existing pdf templates because the number of fields varies, and it's my understanding that PDFlib allows you to create the PDF dynamically on the server. Originally we were using Crystal Reports and CFX_CRWTOPDF which no longer works, and I haven't been able to find anything to replace it that combination. Generating the PDF files on the server is the best alternative I've been able to come up with. Got better ones? Marianne Daye Center for Engineering and Environmental Technology Programmer/Analyst Research Triangle Institute Information Delivery Systems3040 Cornwallis Rd. http://ids.rti.org Research Triangle Park, NC 27709 Ph: (919) 541-8031, Fax: (919) 541-6936 http://www.rti.org ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ADO and CF
Anyone had any luck using ADO with CF? I want to use it but I hear CF and ADO don't like to play nice.. any thoughts are appreciated... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Feedback
At 12:10 PM 2/5/2001 -0700, you wrote: >Dylan, > >Do you think the DSL will be able to handle this (lets say 50 sites with >5,000 page views a day per site), or should I look at a T1 line. From IIS 5.0 chapter on Capacity planning. based on 5 kb page size 640 kpbs dsl connection = almost 11 pages sent/sec. T1 - 1.536 Mbps = 26 pages sent/sec. T3 - 44.736 Mbps = 760 Your specs are calling for about 10,000 views per hour which work out to 173 views per second. To guarantee no bottle necks at full capacity you'd probably need a T3especially since most pages are over 5 kb...and that doesn't include graphics. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple queries tie up web server
> The page in question isn't a report, but a dynamic grid of > enrollment counts > for multiple courses held at multiple times. Each course/time combination > has 4 queries associated with it, 3 of which are "select > count(user_id)..." > Each course/time intersection has javascript pop-up windows > associated with > it so my user can add/drop/move students to/from other > intersections on the schedule grid. Couldn't resist this... Oh look, a prime candidate for query a query functionality in CF5 > We're running CF Server 4.51 Enterprise, with the Oracle 7.3 > native drivers. > And *all* requests to the web server are refused, not just those > to the same > datasource. So this sounds more like a web server problem (as > Robert said). Down to the real point though - can you watch the server, have a PerfMon and TaskMgr running and then run the template? That way you can see what requests are hitting the webserver, CF and database, and how much processor is tied up Another question - which webserver? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ADO and CF
i've done a few things in ADO with CF. i built an interface to manage hundreds of sites in IIS through CF using ADO/ADSI. however, the applications i worked on were eventually converted to VB and they ran MUCH faster. -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:43 PM To: CF-Talk Subject: ADO and CF Anyone had any luck using ADO with CF? I want to use it but I hear CF and ADO don't like to play nice.. any thoughts are appreciated... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Got PDFlib?
If you have $35K lying around and know a bit of FrameMaker, there is a great product called DLFormatter from http://www.datalogics.com - Original Message - From: "Daye, Marianne" <[EMAIL PROTECTED]> > Originally we were using Crystal Reports and CFX_CRWTOPDF which no longer > works, and I haven't been able to find anything to replace it that > combination. Generating the PDF files on the server is the best alternative > I've been able to come up with. Got better ones? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
why use 3rd dimensional array??? You dont understand!
BAH! This is what i mean. What are the PRACTICAL real life uses for 3rd dimensional arrays? ANALOGY if u still dont understand. In trig, we learned how to figure out volume using the shell, disc, and i forget the other one. Ok, big deal. however, the practical use of this is to measure the volume of a hill and figure out how much of it you're gonna chop off so u can biuld a house on it blah blah blah. I understand how 3 dimensional arrays work programmatically. but i wanna know the practical uses of it -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:57 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? Since when was math stuff not a real situation - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:36 PM Subject: RE: why use 3rd dimensional array??? > well yeah i can see how it can be used for math stuff. but i mean like a > real situation > > > -Original Message- > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 1:17 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > to hold 3 dimensional data. sorry. > > Simple example. some kind of cubic sample. like say air temperature in a > room for each specific cubic foot. The index is h,w,l and the value > corresponds to the appropriate cube in the room. > > I can get a better, more practival example if you like. > > E > > From: Phoeun Pha <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: why use 3rd dimensional array??? > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > how would one use a third dimensional array? it's hard for me to > conceptualize a practical use for it! > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Feedback
No, 10K per hour is 2.7 per second. 173is per minute. But most pages are a hell of a lot larger then 5k. JayB wrote: > > At 12:10 PM 2/5/2001 -0700, you wrote: > >Dylan, > > > >Do you think the DSL will be able to handle this (lets say 50 sites with > >5,000 page views a day per site), or should I look at a T1 line. > > From IIS 5.0 chapter on Capacity planning. > > based on 5 kb page size > > 640 kpbs dsl connection = almost 11 pages sent/sec. > T1 - 1.536 Mbps = 26 pages sent/sec. > > T3 - 44.736 Mbps = 760 > > Your specs are calling for about 10,000 views per hour which work out to > 173 views per second. > > To guarantee no bottle necks at full capacity you'd probably need a > T3especially since most pages are over 5 kb...and that doesn't include > graphics. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sub-query a cached query?
Can I make an enormous cached query, and then query those results? Say, for example, I wanted to query all customers and all invoices at once, then display a list of customers with unpayed invoices, linked with URL variables to a detail page that would show the invoice details. Could I do this with one big query, cached at the beginning, and never hit my database again until the cache expired? Willy Ray Web Designer Westminster College Salt Lake City, UT ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ADO and CF
That's because you have to go through an extra layer. Ado is native for ASP so it would only make sense that it would be faster in ASP. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:49 PM To: CF-Talk Subject: RE: ADO and CF i've done a few things in ADO with CF. i built an interface to manage hundreds of sites in IIS through CF using ADO/ADSI. however, the applications i worked on were eventually converted to VB and they ran MUCH faster. -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 12:43 PM To: CF-Talk Subject: ADO and CF Anyone had any luck using ADO with CF? I want to use it but I hear CF and ADO don't like to play nice.. any thoughts are appreciated... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array??? You dont understand!
I can step in here. I have used 3 dimensional arrays to store weather data for specific sites. I have several sensors across several locations on a site that I need to track over time. My array looks like: reading[SiteID][SessorFarmID][Time] This is used in a non-web language, but a similar situation could envisioned for Cold Fusion or JavaScript. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Phoeun Pha [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 14:55 > To: CF-Talk > Subject: why use 3rd dimensional array??? You dont understand! > > > BAH! This is what i mean. > > What are the PRACTICAL real life uses for 3rd dimensional arrays? > > ANALOGY if u still dont understand. > > In trig, we learned how to figure out volume using the shell, disc, and i > forget the other one. Ok, big deal. > > however, the practical use of this is to measure the volume of a hill and > figure out how much of it you're gonna chop off so u can biuld a > house on it > blah blah blah. > > I understand how 3 dimensional arrays work programmatically. but i wanna > know the practical uses of it > > > > -Original Message- > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:57 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > Since when was math stuff not a real situation > - Original Message - > From: "Phoeun Pha" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, February 05, 2001 1:36 PM > Subject: RE: why use 3rd dimensional array??? > > > > well yeah i can see how it can be used for math stuff. but i > mean like a > > real situation > > > > > > -Original Message- > > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 05, 2001 1:17 PM > > To: CF-Talk > > Subject: Re: why use 3rd dimensional array??? > > > > > > to hold 3 dimensional data. sorry. > > > > Simple example. some kind of cubic sample. like say air temperature in a > > room for each specific cubic foot. The index is h,w,l and the value > > corresponds to the appropriate cube in the room. > > > > I can get a better, more practival example if you like. > > > > E > > > > From: Phoeun Pha <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > > Subject: why use 3rd dimensional array??? > > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > > > how would one use a third dimensional array? it's hard for me to > > conceptualize a practical use for it! > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ADO and CF
I am trying to decide whether to use ADO or not becuase I could use some of its functionality that CFQUERY doesn't give me. Thanks for the replys. -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: why use 3rd dimensional array??? You dont understand!
Maybe you can remove your head from your ass using a 3 dimensional array. Let me know if it works. - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 2:55 PM Subject: why use 3rd dimensional array??? You dont understand! > BAH! This is what i mean. > > What are the PRACTICAL real life uses for 3rd dimensional arrays? > > ANALOGY if u still dont understand. > > In trig, we learned how to figure out volume using the shell, disc, and i > forget the other one. Ok, big deal. > > however, the practical use of this is to measure the volume of a hill and > figure out how much of it you're gonna chop off so u can biuld a house on it > blah blah blah. > > I understand how 3 dimensional arrays work programmatically. but i wanna > know the practical uses of it > > > > -Original Message- > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:57 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > Since when was math stuff not a real situation > - Original Message - > From: "Phoeun Pha" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, February 05, 2001 1:36 PM > Subject: RE: why use 3rd dimensional array??? > > > > well yeah i can see how it can be used for math stuff. but i mean like a > > real situation > > > > > > -Original Message- > > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 05, 2001 1:17 PM > > To: CF-Talk > > Subject: Re: why use 3rd dimensional array??? > > > > > > to hold 3 dimensional data. sorry. > > > > Simple example. some kind of cubic sample. like say air temperature in a > > room for each specific cubic foot. The index is h,w,l and the value > > corresponds to the appropriate cube in the room. > > > > I can get a better, more practival example if you like. > > > > E > > > > From: Phoeun Pha <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > > Subject: why use 3rd dimensional array??? > > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > > > how would one use a third dimensional array? it's hard for me to > > conceptualize a practical use for it! > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP requirements with exchange
I get the following error: "A required privilege is not held by the client." This happens when I attempt to get the headers only (and getall) from a user with password from my exchange server via cfpop. What does this mean? My mail administrator doesn't know how to help. Thanks Dave Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: why use 3rd dimensional array??? You dont understand!
I use three dimensional arrays as "two dimensional arrays" with bonus comment fields. Unlike C++ i don't get penalized for wasting Ram (my understanding) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sub-query a cached query?
> Can I make an enormous cached query, and then query those > results? Say, for example, I wanted to query all customers and > all invoices at once, then display a list of customers with > unpayed invoices, linked with URL variables to a detail page that > would show the invoice details. Could I do this with one big > query, cached at the beginning, and never hit my database again > until the cache expired? With CF4.x you'd have to loop through the query to display what you want (more on the CF server than the database server) In CF5 you'll be able to query a query, i.e. trim down the query results with SQL BTW, I don't think I'm breaking the CF5 NDA as Jeremy told the CFUG about it a month or so ago... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array??? You dont understand!
did u have a bad day Schmidt? eh heh -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 4:21 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? You dont understand! Maybe you can remove your head from your ass using a 3 dimensional array. Let me know if it works. - Original Message - From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 2:55 PM Subject: why use 3rd dimensional array??? You dont understand! > BAH! This is what i mean. > > What are the PRACTICAL real life uses for 3rd dimensional arrays? > > ANALOGY if u still dont understand. > > In trig, we learned how to figure out volume using the shell, disc, and i > forget the other one. Ok, big deal. > > however, the practical use of this is to measure the volume of a hill and > figure out how much of it you're gonna chop off so u can biuld a house on it > blah blah blah. > > I understand how 3 dimensional arrays work programmatically. but i wanna > know the practical uses of it > > > > -Original Message- > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:57 PM > To: CF-Talk > Subject: Re: why use 3rd dimensional array??? > > > Since when was math stuff not a real situation > - Original Message - > From: "Phoeun Pha" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, February 05, 2001 1:36 PM > Subject: RE: why use 3rd dimensional array??? > > > > well yeah i can see how it can be used for math stuff. but i mean like a > > real situation > > > > > > -Original Message- > > From: Eric Dawson [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 05, 2001 1:17 PM > > To: CF-Talk > > Subject: Re: why use 3rd dimensional array??? > > > > > > to hold 3 dimensional data. sorry. > > > > Simple example. some kind of cubic sample. like say air temperature in a > > room for each specific cubic foot. The index is h,w,l and the value > > corresponds to the appropriate cube in the room. > > > > I can get a better, more practival example if you like. > > > > E > > > > From: Phoeun Pha <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > > Subject: why use 3rd dimensional array??? > > Date: Mon, 05 Feb 2001 12:35:38 -0600 > > > > how would one use a third dimensional array? it's hard for me to > > conceptualize a practical use for it! > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists