RE: CF IDE for *nix Mac etc ...was RE: Allaire on a Mac?
To be honest, all I want from an IDE to write code on is the tag/function completion. If someone wants to build this into jedit (or is it already there?) then I would use it. What would be even more useful would be the ability to add in my own tags/functions etc for future use. That way you can make the editor do completion for any language coding you want in the world. Whatever language, the editor helps. Anyone? Paul PS As long as you can turn on and off certain completion schemes, then it would work fantastically well! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 7:14 PM To: CF-Talk Subject: CF IDE for *nix Mac etc ...was RE: Allaire on a Mac? Anyone wants a nice cfstudio like IDE for *nix , Mac Windows Sun ?? Check out http://jedit.sourceforge.net don't dismiss it because is java - it's very fast. Make sure you install the plugins (tabs, cmd and project, ftp...) is you want a real cfstudio type interface .. You can customise it (eg add close buffer to right click) I'm working on a DB plugin for it... Justin -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:53 PM To: CF-Talk Subject: Re: Allaire on a Mac? I don't know if I'd like CFserver on a Mac or not, but I'd like to see the IDE's (Studio/HomeSite) ported over (to Linux as well, though I know there are some code issues there) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Randy Zeitman wrote: Anyone have any insight as to whether Allaire's apps will soon run on Macintosh as a result of the merger with Macromedia? -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman 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: Securing Applications
-Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 20, 2001 5:34 AM To: CF-Talk Subject: Re: Securing Applications On 1/19/01, Guy J. McDowell penned: I have tried both the GlobalCorp and CFHub examples for securing an application to no avail. I keep getting sent back to the login page. I have verified that I am using the correct user id and password. I bet there is something small I am overlooking. I've been at it for 2 days off and on. I hate to admit defeat. Is the code below the cfapplication tag in application.cfm or login.cfm? By your e-mail it looks like you have it in application.cfm in which case the login form will always load if form.UserName is not defined. The code looks like it should be the code for login.cfm. In which case you should check to see if session.auth is defined and if not, cflocation them to login.cfm. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: case sensitivity in stored procedures
Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_ar_da_ 10.htm Nick -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 4:01 AM To: CF-Talk Subject: Re: case sensitivity in stored procedures can you give me a hint? Sebastian on 1/23/01 11:34 AM, DeVoil, Nick at [EMAIL PROTECTED] wrote: Can you do a case sensitivity comparison within a SQL Server stored procedure? Yes. ** 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
CF Studio Projects
I have a project set up that contains a whole website to go onto a shared server. However, I cannot create a script to upload that project to the correct directory, because I do not have FTP access, only RDS access to the server. What I am confused about, is how it knows where to put the uploaded files. Is it in the webroot or does it give you some options? So in reality the question is, how do you create a script to upload a project to a specific directory with only rds access? pAUL ~~ 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
cfauthenticate and NT users
I'm tryin to use cfauth. to log users onto my site, but it wont work, and I see lots of other ppl on here strugerling, so hopefully some one has cracked it and can suggest something to try I havent thought of. Below is my Application.cfm, the user and password exisit in the NT domain, which is setup as the user directory in the UserObject context (as in 'Mastering ColdFusion', p753. Unfortunetly, I get the error: Are we: NO Error Occurred While Processing Request Error Diagnostic Information CFAuthenticate Tag Error. Invalid User 'tchiverton' for Security Context 'UserObject'. The error occurred while processing an element with a general identifier of (CFAUTHENTICATE), occupying document position (2:1) to (4:18). --- cfoutputAre we: #IsAuthenticated()#/cfoutput cfauthenticate securitycontext="UserObject" username="tchiven" password="jam" Regards, Thomas C. Office: 01565 757 909 Happy New Year ! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ms down
Hey maybe Macromedia is buying them also, and there in the process of changing the sites early : ) "Jennifer Larkin" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Somebody "accidentally" sent out some bad DNS entries and Microsoft.com started pointing to their servers. It's been fixed. DNS is updating. It'll be over soon. There was a report on Hackernews.com but I the site just got integrated into @stake and now I can't find the report. Some blah blah blah about the delicacy of the web. Joseph Thompson wrote: Work great from the west coast of Canada :) I am in Minnesota and I cannot get to them either. I am in orlando and I cant get to them Hotmail and MSN are OK - micrsoft.com brings up alpdev.com ??? Strange... Hotmail, Microsoft, and MSN are all down. ~~ 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 Site: Deerfield.com
I just noticed that deerfield use CF. This is quite an important site imho. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. ~~ 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: Need Help with SQL!!
cfquery... CREATE TABLE Country ( CountryID Integer Identity Primary Key, Country VarChar(50), Code_2 VarChar(2), Code_3 VarChar(3), Code_NumericVarChar(3) ) /cfquery Don't forget if you want a field to include nulls, state it just in case Country varchar(50) null 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: CFFTP is adding extra white space in .txt file
I examined the file that was being written to the server by cffile *before* it was sent via FTP and realized the extra white space was happening right there. Throwing in the attribute addnewline="no" fixed the problem. -Original Message- From: Tim Fields [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 11:16 PM To: CF-Talk Subject: CFFTP is adding extra white space in .txt file I'm having a problem with updating files using CFFTP . With cffile, first I "read" the file and use the variable to populate a text area field so the user can edit it. When they submit the edited file, the action page writes (overwrites) the old file and then FTP's it to the Unix server as a plain text file. The problem is, each time it gets edited and FTP'ed, I'm getting extraneous paragraphs/white (when I show hidden I can see them). As I typed this it has occurred to me that I should try forcing ASCII mode instead of using auto. If that solves it, I'll post a follow up in case anyone cares. Otherwise, I'll look forward to hearing your thoughts. Thanks! ~~ 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: case sensitivity in stored procedures
Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_ar_da_ 10.htm Nick ~~ 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: case sensitivity in stored procedures
It can be done! You can bypass the case-insensitivity, although it's a bit long winded (but it works). What you need to do is use the ASCII character number to make a string case sensitive (ie convert it into ASCII characters and test against those!). there are two functions, ASCII and CHAR. Here's an example (from the Transact-SQL Help) and note that D and d have different numbers: SET TEXTSIZE 0 SET NOCOUNT ON -- Create the variables for the current position of the character string -- and for the character string. DECLARE @position int, @string char(15) -- Initialize the variables. SET @position = 1 SET @string = 'Du monde entier' WHILE @position = DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET @position = @position + 1 END SET NOCOUNT OFF GO Here is the result set: --- - 68 D --- - 117 u --- - 32 --- - 109 m --- - 111 o --- - 110 n --- - 100 d --- - 101 e --- - 32 --- - 101 e --- - 110 n --- - 116 t --- - 105 i --- - 101 e --- - 114 r Enjoy! Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:55 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/ sql/8_ar_da_ 10.htm Nick ~~ 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: Need Help with SQL!!
Dominic, you go to www.factorxsoftware.com/download.cfm and download my WebSQL SQL Server Tool. This is a web based SQL Server Manager. It is still in beta but you can add tables, view data, add/modify stored procedures. I am still in the process of finishing the app but it can help you as it sits right now. -- 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: cfauthenticate and NT users
Is the user directory setup properly in the CF adminstrator? Also, check to see if the user directory been associated with the security context. Security can be tricky as there are a number of things that need to be setup. Can you describe the settings you have under the advanced security page in cfadmin? Matt Matthew I. Fusfield [EMAIL PROTECTED] Senior Web Systems Developer, InterActive Network Systems, Inc. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 5:49 AM To: CF-Talk Subject: cfauthenticate and NT users I'm tryin to use cfauth. to log users onto my site, but it wont work, and I see lots of other ppl on here strugerling, so hopefully some one has cracked it and can suggest something to try I havent thought of. Below is my Application.cfm, the user and password exisit in the NT domain, which is setup as the user directory in the UserObject context (as in 'Mastering ColdFusion', p753. Unfortunetly, I get the error: Are we: NO Error Occurred While Processing Request Error Diagnostic Information CFAuthenticate Tag Error. Invalid User 'tchiverton' for Security Context 'UserObject'. The error occurred while processing an element with a general identifier of (CFAUTHENTICATE), occupying document position (2:1) to (4:18). --- cfoutputAre we: #IsAuthenticated()#/cfoutput cfauthenticate securitycontext="UserObject" username="tchiven" password="jam" Regards, Thomas C. Office: 01565 757 909 Happy New Year ! 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: case sensitivity in stored procedures
There's another reason you don't want case-sensitivity turned on for the whole server... the Merant database drivers have a bug in them: they have internal calls to a stored procedure named sp_SeRvEr_InFo when the actual stored procedure is named sp_server_info. With case sensitivity turned on every SQL query will infrequently crash with an error about not finding sp_SeRvEr_InFo. If you *do* need all comparisons to be case-sensitive, make sure you make a copy of that stored procedure under the crazy capitalization. At 07:54 AM 1/24/01 -0500, [EMAIL PROTECTED] wrote: Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_ar_da_ 10.htm Nick ~~ 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: Triggering the Find Dialog
I have no knowledge, but speaking out of my a** I'd say maybe via an ActiveX control? VBScript maybe? Of course limitations apply, even if I am right... |-Original Message- |From: Jon Hall [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, January 24, 2001 12:05 AM |To: CF-Talk |Subject: Re: Triggering the Find Dialog | | |It's not part of the DOM, so I dont believe so. | |jon |- Original Message - |From: "Duane Boudreau" [EMAIL PROTECTED] |To: "CF-Talk" [EMAIL PROTECTED] |Sent: Tuesday, January 23, 2001 11:33 PM |Subject: Triggering the Find Dialog | | | Does anyone know if there is a way to trigger the browser's |find button |for | searching the text on the current page? | | TIA, | Duane Boudreau, CTO | CFExperts | 603.620.8797 | | | | ~~ 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 Lotus Domino
Are there any CF people out there that know much about Notes/Domino? We have a few clients that want us to integrate our CF based app with some of their internal Notes/Domino apps and a few other clients that want us to rebuild our entire app in Notes/Domino so they can run it within their own datacenter and integrate it with the rest of their internal systems. Can we do all the stuff that CF does for us (quite nicely i should say) in Notes/Domino? Thanks, Kirk Boecker ~~ 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) Advertising
Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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: case sensitivity in stored procedures
If you're talking about passwords, you may consider using CFX_HASH to create the passwords. Its hashes are case sensitive so "A" is not the same as "a" and it would probably end up being more secure. HTH Stephen -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:03 AM To: CF-Talk Subject: RE: case sensitivity in stored procedures It can be done! You can bypass the case-insensitivity, although it's a bit long winded (but it works). What you need to do is use the ASCII character number to make a string case sensitive (ie convert it into ASCII characters and test against those!). there are two functions, ASCII and CHAR. Here's an example (from the Transact-SQL Help) and note that D and d have different numbers: SET TEXTSIZE 0 SET NOCOUNT ON -- Create the variables for the current position of the character string -- and for the character string. DECLARE @position int, @string char(15) -- Initialize the variables. SET @position = 1 SET @string = 'Du monde entier' WHILE @position = DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET @position = @position + 1 END SET NOCOUNT OFF GO Here is the result set: --- - 68 D --- - 117 u --- - 32 --- - 109 m --- - 111 o --- - 110 n --- - 100 d --- - 101 e --- - 32 --- - 101 e --- - 110 n --- - 116 t --- - 105 i --- - 101 e --- - 114 r Enjoy! Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:55 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/ sql/8_ar_da_ 10.htm Nick ~~ 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
BEST Reccomendations for CF Hosting
Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: Triggering the Find Dialog
Thanks! Duane -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 9:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Triggering the Find Dialog Duane, this might help: http://www.dynamicdrive.com/dynamicindex11/findpage.htm - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 11:33 PM Subject: Triggering the Find Dialog Does anyone know if there is a way to trigger the browser's find button for searching the text on the current page? TIA, Duane Boudreau, CTO CFExperts 603.620.8797 ~~ 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 id max length
We have a client that wants to import some of the website data into some other software. The problem is that this other software has _only_ fixed-width fields and they need to conserve space. There is a column in our data that contains a session id and an incremental suffix. We can predict the max length of the suffix but the length of the session id clearly varies. Does anyone know either what the max length of the session id is, or how the session id is constructed so we can try to predict a max length? We can always pad with a couple of characters beyond what we think the max is, but we can't pad with say, 5 characters. Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ 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 Studio Projects
I have never used Cold Fusion's RDS to promote a project. I used MacroMedia's Dreamweaver to promote my projects. Lately, I have been using VSS to promote the projects by defining shadow folders for the VSS projects. Sorry I couldn't help more, but you might want to consider either of these solutions, if you have them available. 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 03:46 To: CF-Talk Subject: CF Studio Projects I have a project set up that contains a whole website to go onto a shared server. However, I cannot create a script to upload that project to the correct directory, because I do not have FTP access, only RDS access to the server. What I am confused about, is how it knows where to put the uploaded files. Is it in the webroot or does it give you some options? So in reality the question is, how do you create a script to upload a project to a specific directory with only rds access? pAUL ~~ 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: cfauthenticate and NT users
You need to have the Cold Fusion Enterprise edition to have the Advanced Security that the CFAuthenticate tag requires. Once you have that set up, you need to define a security context named UserObject. Inside that context, you need to defined users and groups, protected resources and then associate them. The entire process was confusing when I set it up. Instead of using that, I wrote my own security interface using an ODBC database. You could write a CFX tag to authenticate the users against an NT Domain. There was an article in the latest Dr. Dobb's Journal (dead tree version, not on the website) that discussed using Windows DLLs for this from Java. It didn't look like it would be a major jump to write a CFX_J tag as a wrapper the functions published. I haven't tried it because I have no need for it right now. 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: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 04:49 To: CF-Talk Subject: cfauthenticate and NT users I'm tryin to use cfauth. to log users onto my site, but it wont work, and I see lots of other ppl on here strugerling, so hopefully some one has cracked it and can suggest something to try I havent thought of. Below is my Application.cfm, the user and password exisit in the NT domain, which is setup as the user directory in the UserObject context (as in 'Mastering ColdFusion', p753. Unfortunetly, I get the error: Are we: NO Error Occurred While Processing Request Error Diagnostic Information CFAuthenticate Tag Error. Invalid User 'tchiverton' for Security Context 'UserObject'. The error occurred while processing an element with a general identifier of (CFAUTHENTICATE), occupying document position (2:1) to (4:18). --- cfoutputAre we: #IsAuthenticated()#/cfoutput cfauthenticate securitycontext="UserObject" username="tchiven" password="jam" Regards, Thomas C. Office: 01565 757 909 Happy New Year ! 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: Triggering the Find Dialog
You may be able to do this using WSH or an ActiveX Object (IE only...) Don't know of any way to do this in Netscape. There is a page on the Find function on MSDN. It's one of Windows' common controls. http://msdn.microsoft.com/library/psdk/winui/commdlg3_91is.htm Good Luck. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 9:33 PM To: CF-Talk Subject: Triggering the Find Dialog Does anyone know if there is a way to trigger the browser's find button for searching the text on the current page? TIA, Duane Boudreau, CTO CFExperts 603.620.8797 ~~ 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: Triggering the Find Dialog
Duane, this might help: http://www.dynamicdrive.com/dynamicindex11/findpage.htm - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 11:33 PM Subject: Triggering the Find Dialog Does anyone know if there is a way to trigger the browser's find button for searching the text on the current page? TIA, Duane Boudreau, CTO CFExperts 603.620.8797 ~~ 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: Triggering the Find Dialog
According to the JavaScript Bible (3rd Edition) the windowObject has a find() method that allows you to access the Find Control panel. However, it is only available in Navigator 4 (and possible IE 4+). The syntax for it is find(["searchString" [, matchCaseBoolean, searchUpBoolean]]) 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: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 22:33 To: CF-Talk Subject: Triggering the Find Dialog Does anyone know if there is a way to trigger the browser's find button for searching the text on the current page? TIA, Duane Boudreau, CTO CFExperts 603.620.8797 ~~ 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
Allaire wish list
What's the e-mail address to send CFAS enhancement requests to? 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: case sensitivity in stored procedures
Hi I'm not sure if you got this yesterday so I'm sending again Select * from MyTbl where convert(varbinary, column1) = convert(varbinary, 'ABCD') Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:55 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql /8_ar_da_ 10.htm Nick ~~ 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: cfm file in htm template
Yes Josh, I just did something of the sort. I set up a CF template that would display my logo. It incremented a database to count page loads. It could have been used with Jukka Manner's CFX_Image tag to generate a hit count image and then use the CFCONTENT tag to server the image. I included the template as the source of an IMG tag and could pass it URL variables if necessary. I can help you out off the list if you want (I'd hate to waste the bandwidth for anyone not interested in this). 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: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 21:54 To: CF-Talk Subject: cfm file in htm template How do you include a cfm file into an html template. I want to include a cfm hitcounter that i created into my home page but I do not want to make the start page cfm. Josh ~~ 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: (ot) Advertising
Build you own ad server. We wrote one in CF in about a week (fully robust) for our sites. --=@ greg @=-- - Original Message - From: "Eric Dawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:24 AM Subject: (ot) Advertising Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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: BEST Reccomendations for CF Hosting
www.atswebnet.com deserves a look, Robert - Original Message - From: "Michael" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:24 AM Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: BEST Reccomendations for CF Hosting
Check out www.atswebnet.com. They have a basic hosting plan that is $.95 a month and they have fast servers and great service. -- 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: Slightly OT: SSL information
CF-Talk is his HOME :-) All in luv brutha Dave . Steve - Original Message - From: "Peter J. MacDonald" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 5:42 PM Subject: RE: Slightly OT: SSL information Thanks Dave, You have been very helpful to me with all of my little questions. Do you ever go home? Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 20:37 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Slightly OT: SSL information I understand it what it does by reading the technical specs for it. I was looking for the steps to implement it. I'm not even sure where to start. I am use IIS, is it different for different web servers. I am likely to need to do UNIX as well. The way you set up SSL is different from one web server to the next. They generally follow the same basic path, though: 1. Generate a certificate request. IIS provides the Key Manager utility, which does this. 2. Submit the request to a certificate authority: Verisign, Thawte, etc. 3. Install the certificate on the server. Again, in IIS you'd do this with Key Manager. 4. Configure the web server to accept secure HTTP requests. For IIS, you can find all this stuff out in the IIS Resource Kit, available from Microsoft Press (http://mspress.microsoft.com/). 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: (ot) Advertising
We use Double Click, and from what I've seen it works well (although it does take some time to understand the system, and implement it). I think that we still use our previous ad serving software that we developed internally with CF as well, although I'm not sure as to what extent. If you're interested in saving money, I'd pick option 2. Double Click wasn't cheap to setup. Michael Buffington [EMAIL PROTECTED] (714) 556-3890 x222 http://www.price.com -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:25 AM To: CF-Talk Subject: (ot) Advertising Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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: (ot) Advertising
While I can't tell you which solution would be better for your specific needs, as the former Director of Technology for a traditional Advertising firm (TV/Print/Radio) I can give you some things to think about when considering either option. We discussed issues surrounding online advertising at length internally. Seriously consider who is going to handle managing the accounts for your advertisers. Even a totally automated system needs someone to call and pitch ad sales. Someone will have to design the ads. Even if the advertiser does this, and upload the ads themselves, you will have to deal with helping those individuals who can't figure out how to do it on their own. This may not seem like a big deal, but without a steady stream of ads, your ad management system is irrelevant. IMHO, ad based revenue models are very very tricky. Clickthrough rates are getting lower and lower, and the price advertisers can charge it getting lower. Advertisers are getting scarce. Consider this list as an example... MD set it up to be sponsored to offset some of the costs of running it, but I don't think he's gotten a landslide of offers for sponsorship. The days of "if you build it they will come" are over. If it fits the situation, sometimes it can be worth it to pass this responsibility off to a third party who has the resources to manage the accounts and make sure you have a steady stream of paying advertisers. Just something to chew on... -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 11:25 AM To: CF-Talk Subject: (ot) Advertising Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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
cffile permissions
I am using cffile to copy a read-only file from server A to the cf server. I am trying to display the copied file using cfcontent and delete it using the 'deletefile="YES"'. The cffile does not appear to change the permissions on the move and thus I am not able to delete the file. cffile action="copy" source="#URL.ServerFilePath#" destination="c:\temp\test\temp\" attribute="Normal" Help? Ross ~~ 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: BEST Reccomendations for CF Hosting
VirtualScape.com are pretty good. I have used them. Their support team get a bit confused on occasion but they always work hard. SLA is ok and stability is fine. The prices are good too. I'd say give them a go :) Martin. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: 24 January 2001 16:24 To: CF-Talk Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: cfauthenticate and NT users
Cheers for helping... Is the user directory setup properly in the CF adminstrator? As far as I can tell, the documentation is a bit ropy. Namespace = WinNT Location = Windows name of machine (not DNS) Also, check to see if the user directory been associated with the security context. The UserList item is in the Current Dirctory half. Can you describe the settings you have under the advanced security page in cfadmin? See attached gif's (hope this isnt against list policy) Pic 1 is the advanced security page Pic 2 is the user directory page ~~ 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: BEST Reccomendations for CF Hosting
www.cfdynamics.com We've been hosting CF for a long time. Now we are dedicating resources just for CF. -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 9:24 AM To: CF-Talk Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: (ot) Advertising
Id personally like to keep it in house if it were me. There is a great ASP program out there called AdMentor at http://www.aspcode.net/ its got some pretty cool features and best of all its free and open source. You can modify it however you want too. Good luck Misty -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 10:25 AM To: cf-talk Cc: cftalk Subject: (ot) Advertising Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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 Lotus Domino
Hello, I have worked with Notes 4.5 through 5.0 as a Notes Administrator and Developer. You are better off redoing the application in Notes. Notes/Domino 5 has a RDBMS connector for SQL Server so your backend shouldn't need any changes. Domino and CF will not mix. Domino uses JavaScript and stores everything in a .nsf database file. The reason they are using Notes/Domino is for the security which is very extensive and will save time in development hours. Hope you are good JavaScript developers because you will be using it a lot. Good Luck John On Wed, 24 January 2001, "Kirk Boecker" wrote: Are there any CF people out there that know much about Notes/Domino? We have a few clients that want us to integrate our CF based app with some of their internal Notes/Domino apps and a few other clients that want us to rebuild our entire app in Notes/Domino so they can run it within their own datacenter and integrate it with the rest of their internal systems. Can we do all the stuff that CF does for us (quite nicely i should say) in Notes/Domino? Thanks, Kirk Boecker ~~ 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: BEST Reccomendations for CF Hosting
Crystaltech.com is great for $19.95 per month. Get access databases as well with it and can host a few domains on one account. Misty -Original Message- From: ptbarnum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 10:24 AM To: cf-talk Cc: ptbarnum Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: BEST Reccomendations for CF Hosting
If you go to the cfdj list you will find some very interesting information. Seems like a lot of people like CrystalTech. John On Wed, 24 January 2001, "Michael" wrote: Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: BEST Reccomendations for CF Hosting
If you want free try www.cfm-resources.com -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:24 AM To: CF-Talk Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: BEST Reccomendations for CF Hosting
Look through the ads in Cold Fusion Developers Journal, there are various levels of packages. Give consideration to tags allowed, administrator access, etc. Most peoples gripes are related to lack of control over the application environment. Good luck! -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:24 AM To: CF-Talk Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: (ot) Advertising
Eric, 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Have a look at the free, open source Admentor product at http://aspcode.com. -ron ~~ 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
list delay (again)
If I don't understand it correctly, delays may be caused by mail routers and such. But if I am using an SMPT server running on my box (the one that comes with Win2K/IIS5), I shouldn't be seeing a 4hour delay for my own posts, right? ~~ 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: CFLOCK for 4.0.1 AND 4.5.1
On 1/23/01, Zachary Bedell penned: It just seems to me that a more sensible solution could have been developed. Especially since this wasn't even a full version upgrade. If I go from version x.0 of a product to version y.0 of a product, then I'd expect some various little ugly things that would require fixing. But to go from x.0 to x.5 and have show-stopping code incompatibilities is kinda lame IM(NS)HO... Well, after alot of wrangling and brainbusting, I've come up with a scheme that works for me, using cfinclude, which stops 4.01 from throwing an error when using the scope variable in a FALSE condition. I've tested it on 4.51 and 4.01 and a simple variable change is all that's needed. cfset whichversion = "4.0" or cfset whichversion = "4.5" Here is my application setting: CFPARAM NAME="application_name" DEFAULT="something_unique" cfapplication name="#application_name#" setclientcookies="yes" sessionmanagement="yes" sessiontimeout="#createtimespan(0,0,20,0)#" cfset whichversion = "4.5" Here is my code block: This uses a template named setmyname.cfm which is where I put the code which uses session or application variables. This one is set to use an exclusive lock with the session scope in 4.5 which is set in the cflock_45.cfm template or the lock name "something_unique_myname", which is set in the cflock_40.cfm template. cfset satemplate = "setmyname" cfset lockname="myname" cfset scopetype = "session" cfset locktype = "exclusive" cfset locktimeout = 20 cfinclude template="cflock.cfm" This is the code within cflock.cfm CFIF whichversion IS "4.0" cfinclude template="cflock_40.cfm" cfelseif whichversion is "4.5" cfinclude template="cflock_45.cfm" cfelseif whichversion is "5.0" cfinclude template="cflock_50.cfm" cfelseif whichversion is "5.5" cfinclude template="cflock_55.cfm" /cfif Notice, I'm ready for 2 more versions. LOL Even if they don't happen to be 5.0 and 5.5, I can still use those numbers. Just set the template name, use a single lock name for all sets of code using the same session or application variables set to the scope type, and whether it's exclusive or readonly and the timeout. Here is the code in cflock_40.cfm and cflock_45.cfm: 4.0: cflock timeout="#locktimeout#" name="#application_name#_#lockname#" type="#locktype#" cfinclude template="#scopetype#variables/#satemplate#.cfm" /cflock 4.5: cflock timeout="#locktimeout#" scope="#scopetype#" type="#locktype#" cfinclude template="#scopetype#variables/#satemplate#.cfm" /cflock You can change the include template path of course, but I just made a folder called sessionvariables and one called applicationvariables to keep them separated. Then I have templates that I pop into one of the variables directories, such as setmyname.cfm with the actual code. To see the exact same block of code, with just whichversion changed. On Virtualscape running 4.51 and forced locking: http://216.150.28.116/cflocktest/ On my server with 4.01 http://www.twcreations.com/cflocktest/ To download the templates and have a look: http://www.twcreations.com/cflocktest/ftp/cflocktest.zip If anyone has an easier way to do this or if you see something glaringly wrong with this, I'm open for suggestion. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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 MSSQL 2000
Well I've never used any of them, so I'm a bit befuddeled as where to start. Was hoping to find some documentation, but no luck yet, which is why I'm asking for help here. -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 12:42 PM To: CF-Talk Subject: RE: CF MSSQL 2000 Sure, it works pretty much the same as far as CF is concerned as SQL 6.5 and 7.0 did. Are you running into a specific problem? Matt Matthew I. Fusfield Senior Web Systems Developer InterActive Network Systems, Inc. -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 11:30 AM To: CF-Talk Subject: CF MSSQL 2000 Having a bit of trouble here, and was looking for some advice on getting MSSQL 2k to work with CF. Anyone had any experience with this that they can share with me? -Pete ~~ 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: cfauthenticate and NT users
There's also the Intranet/Hosting Toolkit http://www.intrafoundation.com/intranethostingtoolkit.html From the Web Site: The Intranet/Hosting Toolkit currently includes several CFX tags (DLL files) including CFX_Users for NT users, CFX_Groups for local and domain groups, CFX_Shares for handling network shares, CFX_Permissions for managing network file permissions, CFX_Services, CFX_IIS for creating/managing IIS4/5 ftp and web sites and the ever-useful CFX_NetworkTopology for figuring out what's in your network. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Russel Madere" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:49 AM Subject: RE: cfauthenticate and NT users You need to have the Cold Fusion Enterprise edition to have the Advanced Security that the CFAuthenticate tag requires. Once you have that set up, you need to define a security context named UserObject. Inside that context, you need to defined users and groups, protected resources and then associate them. The entire process was confusing when I set it up. Instead of using that, I wrote my own security interface using an ODBC database. You could write a CFX tag to authenticate the users against an NT Domain. There was an article in the latest Dr. Dobb's Journal (dead tree version, not on the website) that discussed using Windows DLLs for this from Java. It didn't look like it would be a major jump to write a CFX_J tag as a wrapper the functions published. I haven't tried it because I have no need for it right now. 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. ~~ 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: Allaire wish list
[EMAIL PROTECTED] (or possibly even [EMAIL PROTECTED] g ) -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 24 January 2001 16:56 To: CF-Talk Subject: Allaire wish list What's the e-mail address to send CFAS enhancement requests to? 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: Allaire wish list
The ColdFusion forums (forums.allaire.com) has a board dedicated to this. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:55 AM Subject: Allaire wish list What's the e-mail address to send CFAS enhancement requests to? 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: BEST Reccomendations for CF Hosting
www.aaawebhosting.com -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:24 AM To: CF-Talk Subject: BEST Reccomendations for CF Hosting Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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
Photo gallery custom tag?
Has anyone seen, or written, a tag to provide a "photo gallery" type interface that allows visitors to browse pages of thumbnails, then go to a detail page to view the full-size photo? This seems very basic, but I can't find one in the developer's exchange. I can probably write this pretty quickly, but I'm hoping I can save the effort, since it must have been done many times before. Thanks - Eric ~~ 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: (ot) Advertising
The actual adserver is the easy part. The hard part is the management system, the forecasting, inventory tracking, campaign management, reporting, etc. Not to mention verification and auditing, if you get picky customers. But be careful with the adserving part, too, because a lot of that is patented. Greg Wolfinger wrote: Build you own ad server. We wrote one in CF in about a week (fully robust) for our sites. --=@ greg @=-- - Original Message - From: "Eric Dawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:24 AM Subject: (ot) Advertising Sorry for the OT post, but I do have the right audience. I need to determine which of the following approaches is best, and am curious for some feedback from this list. 1.) Outsource Ad Serving: we sell ads, but may have a network of sales agents (site users). Double Click Dart. 2.) Build an Ad Management system, preferably in ASP (current site in ASP). Need to be able to manage a site network, all sites on the same server farm. Interested in Open Source packages, or otherwise. Thanks Eric ~~ 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
CFUPDATE giving me problems, please help...
I have an admin form to add/edit records in an Access 2000 database. I try to edit a user's record and I get this error: Error Diagnostic Information SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (30:1) to (30:50). The problem only comes up when I try to change the username field "username". As far as I can tell, even though I have an id field that is the key for the database, it thinks "username" is my key and CFUPDATE will give me this error. All other uses of the database work fine (other updates, query, delete, etc.) and I double checked to make sure "id" is the key and it is. Is "username" a reserved word somewhere where this would be such a problem? Is the problem with Access 2000 or CFUPDATE? Any help would be great. The code to update is very simple: cfupdate datasource="mydatasource" tablename="mytablename" Joby Bednar Director of Internet Design iNEOgroup.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
Can anyone shed some light on this?
I am running CFStudio 4.0 on Windows 98 and SQL Server 7.0. Is there an issue with the cfprocparam tag not passing the value of the database variable to SQL Server? I get 0 records returned. However, when I use cfquery with the same SQL query I get the right result. I've made sure that I have got the right sql type, which is varchar, and doubled check the settings in the stored procedure. I even reinstalled CF Server thinking it was some kind of corruption. Did not help. It must be some bug. Can anyone shed some light on this? 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: case sensitivity in stored procedures
I missed the beginning of this thread but by looking at the last mail I
assume that you want to check the cases sensitivity of a string in Transact
SQL? Here is some code I worte to log a user into a site ensuring each
character of the submitted password is the correct case:
SELECT @endstring = ''
SELECT @passlen = LEN(@password)
SELECT @loop = 1
SELECT @startstring = "SELECT * FROM Login WHERE Username = '" + @username +
"' AND Password = '" + @password + "'"
WHILE @loop = @passlen
BEGIN
SELECT @endstring = @endstring + " AND ascii(Substring(Password," +
CONVERT(char,@loop) + ",1)) = ascii(Substring('" + @Password + "'," +
CONVERT(char,@loop) + ",1))"
SELECT @loop = @loop + 1
END
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +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)207 387 8890.
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2001 13:03
To: CF-Talk
Subject: RE: case sensitivity in stored procedures
It can be done! You can bypass the case-insensitivity, although it's a bit
long winded (but it works).
What you need to do is use the ASCII character number to make a string case
sensitive (ie convert it into ASCII characters and test against those!).
there are two functions, ASCII and CHAR. Here's an example (from the
Transact-SQL Help) and note that D and d have different numbers:
SET TEXTSIZE 0
SET NOCOUNT ON
-- Create the variables for the current position of the character string
-- and for the character string.
DECLARE @position int, @string char(15)
-- Initialize the variables.
SET @position = 1
SET @string = 'Du monde entier'
WHILE @position = DATALENGTH(@string)
BEGIN
SELECT ASCII(SUBSTRING(@string, @position, 1)),
CHAR(ASCII(SUBSTRING(@string, @position, 1)))
SET @position = @position + 1
END
SET NOCOUNT OFF
GO
Here is the result set:
--- -
68 D
--- -
117 u
--- -
32
--- -
109 m
--- -
111 o
--- -
110 n
--- -
100 d
--- -
101 e
--- -
32
--- -
101 e
--- -
110 n
--- -
116 t
--- -
105 i
--- -
101 e
--- -
114 r
Enjoy!
Paul
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 12:55 PM
To: CF-Talk
Subject: RE: case sensitivity in stored procedures
Nick, this was helpful, thanks - I didn't realize it was an installation
option, and I've never seen it installed except with the
default setting. I
looked it up in BOL and it gives pretty good details. I'm sure
I've been
lazy enough with object names, etc. that I wouldn't want
case-sensitivity
ON - half my queries or code might fail. Well maybe not half, but some.
I had been trying out some code with tests of exact
(case-sensitive) words,
such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems
that the case-sensitivity setting relates to this too. As a
result, SEcret,
seCRET, SeCrEt, etc. all come up as LIKE the above expression.
So it might be better to say that SQL Server is case-insensitive by
default, period.
Mark
[EMAIL PROTECTED]
Sebastian
Apologies, not a very helpful answer.
What I meant was SQL Server is case-sensitive, period.
But actually that's not always true, only if SQL Server is
installed with a case sensitive sort order.
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/
sql/8_ar_da_
10.htm
Nick
~~
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
wddx limitations?
Hi all, I'm considering using wddx for an application and want to get some advice on whether any of you have hit limits when uploading serialized wddx strings into database fields and when submitting long wddx strings across pages using form fields. I've heard story's of people running into these restrictions and was hoping to hear whether it's as common as it sounds and if there are any solutions. I would also like to confirm what the limiting factor is. Is it the database, webserver, client or something else? Anyone have information on this? Thanks, 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: CF Site: Deerfield.com
Also QXL's fairly new "Live" auction site: http://www.qxllive.com Will -- [EMAIL PROTECTED] -=- www.lukrative.com Classifieds -=- SixthSense on DVD for Free @ www.localbounty.com/sixthsense/ - Original Message - From: ""stas"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Wednesday, January 24, 2001 5:31 PM Subject: Re: CF Site: Deerfield.com Also: http://www.palmgear.com/ http://www.logitech.com - Original Message - From: "Martin Sutton" [EMAIL PROTECTED] I just noticed that deerfield use CF. This is quite an important site imho. ~~ 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 MSSQL 2000
-Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 11:30 AM To: CF-Talk Subject: CF MSSQL 2000 Having a bit of trouble here, and was looking for some advice on getting MSSQL 2k to work with CF. Anyone had any experience with this that they can share with me? Well as a matter of fact I upgraded one of our SQL 7 servers to SQL 2000 just today, and which contains several databases which CF points at from another server over ODBC. The upgrade was totally seamless and with no issues at all here. Without knowing the specifics of your problem, it is difficult to comment further. Adrian Cooper. ~~ 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: list delay (again)
Delays come from either a problem with the machine running the list OR a problem with the connection between the list machine and the recieving server. The list might be going great guns, but your posts may be delayed because of line trouble, routing, etc. To see what posts have gotten to the list and when, go to http://www.houseoffusion.com/archive. This is an 'up to the minute' archive of all the lists hosted at House of Fusion. By looking at the latest posts, you can see if yours have gotten to the list or not. If it has and you havn't seen it in your email box yet, then you've got a delay. If you don't see it there, then the list has a delay. I'll have a 'traffic light' up there and on the main site page showing the list status at all times. This should put peoples minds a little at ease when it comes to the list (hopefully). If I don't understand it correctly, delays may be caused by mail routers and such. But if I am using an SMPT server running on my box (the one that comes with Win2K/IIS5), I shouldn't be seeing a 4hour delay for my own posts, right? ~~ 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: BEST Reccomendations for CF Hosting
Crystaltech's shared hosting is attrocious for security though. Your web root is the same as your base dir, and the NT everyone user is given read to all accounts (on most of their server). This means you if you have any sensitive data stored, you're sharing it w/ the other 200+ users on the same server as you (along w/ all your code). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: January 24, 2001 12:33 To: CF-Talk Subject: Re: BEST Reccomendations for CF Hosting If you go to the cfdj list you will find some very interesting information. Seems like a lot of people like CrystalTech. John On Wed, 24 January 2001, "Michael" wrote: Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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
Javascript/Netscape Problem
I thought the neat tag CF_AEBrowser.cfm would solve my Javascript
problem. But my hopes were mis-placed. The tag works fine, but Netscape
is not playing nice.
I'm using the following to create a popup window:
script language="JavaScript"
!--
function openWindow(url, name) {
popupWin = window.open(url, name,
"resizable,location,scrollbars,width=500,height=500,left=75,top=75");
}
//--
/script
except when the user has Javascript turned off.
So I use:
CFMODULE TEMPLATE="CF_AEBrowser.cfm"
CFIF BROWSER.supportJavascript
CFSET Request.JS_ON_OFF = "Yes"
/CFIF
in application.cfm to determine if the user has Javascript ON or OFF.
The problem is that Netscape opens the window FULL SCREEN size with the
above JS function, just as it does with the TARGET="_BLANK" attribute of a
HREF.
With or without the aid of Javascript, IE opens a partial window.
Is there a work-around? I'd like a partial window to open because a new
full screen window will confuse users.
best, paul
~~
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: Page execution time too long?
On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. -Matt Matthew- I don't agree with your statement that CF doesn't scale. It will scale as well as the code which is run on it. Possibly these people working for busy CF sites are not experienced in writing scalable code? - jason. - Original Message - From: "Matthew Taylor" [EMAIL PROTECTED] To: "CF-Server" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 3:48 PM Subject: RE: Page execution time too long? 150 millisecs under no load would cause some alarm for me personally. We tested our pages under no load and they ran in under 100 millisecs, under simulated load (silk performer), they jumped to well over 1,000. As I'm sure anyone working for a busy CF site will tell you, Cold Fusion does NOT scale well at all. If you're concerned about page times under ideal conditions...it's all down hill from there. Matthew Taylor Web Developer 617.868.0009 ext.216 [EMAIL PROTECTED] http://www.uClick.com http://www.uComics.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:38 PM To: CF-Server Subject: RE: Page execution time too long? IMHO 150 millisecs is not too much. As far as a general guideline on the maximum execution of pages i would have to say that depends on application you're building. I have had routines that took several seconds to process but that was still acceptable since it was performing some relatively big calculations. Allan Pichler -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:29 AM To: CF-Server Subject: Page execution time too long? I wondered if there are any guidelines for a maximum amount of miliseconds a page should take to process. I have a page which takes 150milliseconds to execute is this acceptable? What do others recommend should be the maximum execution time of a page?? ~~ 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: Javascript/Netscape Problem
Paul,
Try:
popupWin = window.open(url, name,
"resizable,location,scrollbars,width=500,height=500,innerWidth=500,innerHeig
ht=500,left=75,top=75");
That should produce a 500x500 window in IE and Netscape.
Best,
Seva Petrov
Senior Developer
TheSquare.com
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 3:53 PM
To: CF-Talk
Subject: Javascript/Netscape Problem
I thought the neat tag CF_AEBrowser.cfm would solve my Javascript
problem. But my hopes were mis-placed. The tag works fine,
but Netscape
is not playing nice.
I'm using the following to create a popup window:
script language="JavaScript"
!--
function openWindow(url, name) {
popupWin = window.open(url, name,
"resizable,location,scrollbars,width=500,height=500,left=75,top=75");
}
//--
/script
except when the user has Javascript turned off.
So I use:
CFMODULE TEMPLATE="CF_AEBrowser.cfm"
CFIF BROWSER.supportJavascript
CFSET Request.JS_ON_OFF = "Yes"
/CFIF
in application.cfm to determine if the user has Javascript ON or OFF.
The problem is that Netscape opens the window FULL SCREEN
size with the
above JS function, just as it does with the TARGET="_BLANK"
attribute of a
HREF.
With or without the aid of Javascript, IE opens a partial window.
Is there a work-around? I'd like a partial window to open
because a new
full screen window will confuse users.
best, paul
~~
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: BEST Reccomendations for CF Hosting
This is a very good thing to know. We are looking a Hosting Service and this is the stuff we need to know. Thanks. John On Wed, 24 January 2001, "Raymond B." wrote: Crystaltech's shared hosting is attrocious for security though. Your web root is the same as your base dir, and the NT everyone user is given read to all accounts (on most of their server). This means you if you have any sensitive data stored, you're sharing it w/ the other 200+ users on the same server as you (along w/ all your code). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: January 24, 2001 12:33 To: CF-Talk Subject: Re: BEST Reccomendations for CF Hosting If you go to the cfdj list you will find some very interesting information. Seems like a lot of people like CrystalTech. John On Wed, 24 January 2001, "Michael" wrote: Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: Allaire on a Mac?
I think this would explain some problems I am having with flash and the mac.
On a pc loading variables into a flash movie is a simple process. However
for Netscape on a mac I seem to have to set a cookie and read it instead of
loading directly from a CF template and I have yet to find a way to get IE
on a mac to load variables. Anyone know if I am just doing this wrong?
FRAME 1
ACTIONSCRIPT:
eof = "0";
loadVariablesNum ("act_cftoken.cfm", 0, "POST");
gotoAndPlay ("Scene 1", "check");
FRAME 2 ("check")
if (eof=1) {
ifFrameLoaded (6) {
gotoAndStop ("Scene 1", 6);
}
} else if (eof=2) {
gotoAndStop ("Scene 1", "doh");
} else {
gotoAndPlay ("check");
}
So basically what I am doing here is in the first frame I am loading the
variables from act_cftoken.cfm below which is basically just cfid and
cftoken. I use the variable eof just to tell me that everything else in the
string was read. Originally act_cftoken.cfm looked like this:
cfinclude template="app_globals.cfm"
cfsetting showdebugoutput="no"
cfsetting enablecfoutputonly="yes"
cfcontent type="text/plain"
cfoutputcfid=#trim(cfid)#/cfoutputcfoutputcftoken=#trim(cftoken)#/cf
outputcfoutputeof=1/cfoutput
but for some reason the same code that worked on a PC wouldn't work on a
mac, so I added setclientcookies to my cfapplication tag in app_gobals.cfm
and added a check for the cookie's variables of cfid and cftoken in my
act_cftoken.cfm
---act_cftoken.cfm---
cfinclude template="app_globals.cfm"
cfsetting showdebugoutput="no"
cfsetting enablecfoutputonly="yes"
cfcontent type="text/plain"
cfif isdefined("cookie.cfid")
cfoutputcfid=#trim(cookie.cfid)#/cfoutputcfoutputcftoken=#trim(cookie
..cftoken)#/cfoutputcfoutputeof=1/cfoutput
cfelseif isdefined("client.cfid")
cfoutputcfid=#trim(client.cfid)#/cfoutputcfoutputcftoken=#trim(client
..cftoken)#/cfoutputcfoutputeof=1/cfoutput
cfelse
cfoutputeof=2/cfoutput
/cfif
I decided to first look for a cookie since the MAC browsers didn't seem to
appreciate my client variables much. So now on the PC (both browsers) and
MAC Netscape (cookies enabled) flash loads the variables. And if cookies
were not enabled then I would check for client variables at least for PC
browsers where cookies were not enabled. This works fine on PC (both
browsers) and MAC Netscape as if the cookies are not enabled on MAC Netscape
I send them to FRAME 3 ("doh") which basically tells them they need to have
their cookies enabled. That is if both of the checks for cfid fail I load
eof set to 2 which in the action script above sends them to FRAME 3. At the
end of the day, this works fine for everything except MAC IE. I finally
gave up and decided to browser check for MAC IE and send them to an DHTML
version if that is what they were using.
Anyone else run into this problem? Are flash's native binaries creating the
problem or am I just doing this ass backwards?
- Original Message -
From: "Dave Watts" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 12:58 PM
Subject: RE: Allaire on a Mac?
You can't run generator on a mac? isn't that built on JRUN?
What happened to "write once run anywhere"?
Generator 2 uses JRun 2 for online generation, but uses native binaries
for
other things such as offline generation, if I recall correctly.
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: Bug/Defect Tracking Apps
We've used Test Track Pro on a project and it worked pretty well. has plenty of useful features enough so that it doesn't pay to roll your own. Tobe At 02:26 PM 1/23/2001 , you wrote: We use Test Track Pro bu Seapine, Inc. Http://www.seapinr.com Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 12:29 To: CF-Talk Subject: Bug/Defect Tracking Apps Can anyone suggest a good bug/defect tracking solution? Thx, Duane Boudreau, Applications Manager AllVertical Exeter, NH 603.xxx. ~~ 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: Anyone else had this problem before?
Thanks everyone. turns out that you all were right I simpy had to change datatypes in my database (duh). thanks again, nelson Original Message Follows From: "t nelson" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Anyone else had this problem before? Date: Tue, 23 Jan 2001 21:45:56 - Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBC374795006CD820F3B8CF1F7A8CB43456; Tue Jan 23 14:00:36 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Tue, 23 Jan 2001 16:58:22 -0500 From [EMAIL PROTECTED] Tue Jan 23 14:01:24 2001 Message-id: [EMAIL PROTECTED] Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ 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
restarting cf server
anyone know how to make a scheduled task to restart cfserver on a win 2000 box? we have one that keep puking on us and are about to replace the box (new ones came in today) but are looking for a duct tape type fix for the short term until we can switch it out. kirk ~~ 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: Page execution time too long?
Merry Meet Matthew, If CF doesn't scale then how do you explain the best example of an extremely large, heavily trafficed site out there, Autobytel? Perhaps the problem isn't software but hardware. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Matthew Taylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 9:28 PM To: CF-Talk Subject: RE: Page execution time too long? On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. -Matt Matthew- I don't agree with your statement that CF doesn't scale. It will scale as well as the code which is run on it. Possibly these people working for busy CF sites are not experienced in writing scalable code? - jason. - Original Message - From: "Matthew Taylor" [EMAIL PROTECTED] To: "CF-Server" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 3:48 PM Subject: RE: Page execution time too long? 150 millisecs under no load would cause some alarm for me personally. We tested our pages under no load and they ran in under 100 millisecs, under simulated load (silk performer), they jumped to well over 1,000. As I'm sure anyone working for a busy CF site will tell you, Cold Fusion does NOT scale well at all. If you're concerned about page times under ideal conditions...it's all down hill from there. Matthew Taylor Web Developer 617.868.0009 ext.216 [EMAIL PROTECTED] http://www.uClick.com http://www.uComics.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:38 PM To: CF-Server Subject: RE: Page execution time too long? IMHO 150 millisecs is not too much. As far as a general guideline on the maximum execution of pages i would have to say that depends on application you're building. I have had routines that took several seconds to process but that was still acceptable since it was performing some relatively big calculations. Allan Pichler -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:29 AM To: CF-Server Subject: Page execution time too long? I wondered if there are any guidelines for a maximum amount of miliseconds a page should take to process. I have a page which takes 150milliseconds to execute is this acceptable? What do others recommend should be the maximum execution time of a page?? ~~ 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: Netscape error whilst IE is fine
there are a couple problems. first you need ending tags for you table and
tr's and td's, then you need to urlencode that link.
that is:
cfoutput
Please a
href="http://www.accommodationnewzealand.com/nzl/mkt/creditcardform.cfm?busi
nessname=#urlencodedformat('Shalimares')#address1=#urlencodedformat('9
Shalimar
Crescent')#suburb=#urlencodedformat('Khandallah')#island=#urlencodedformat
('North Island')#postcode=telephonenumber=#urlencodedformat('64 4 479
1776')#faxnumber=#urlencodedformat('64 4 479
1786')#[EMAIL PROTECTED]mop=cc" target='_new'Click
Here/a
/cfoutput
of course it would be much easier for you to make a tag that does this for
stuff coming out of your queries, form fields being submitted etc, rather
than doing what I just did to that link. That way variables going into your
link would already be urlencoded.
~~
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: restarting cf server
At the command prompt type "at /?". There's some GUI way to do it as well, I think that would either be in the control panel or in the management console. CF also has a cycle.bat for win32 systems (located somewhere under the CF Server root); all this batch file does is setup a bunch of NET STOP "service name" and NET START "service name" commands w/ using the "at" command mentioned above to run at ~ 2:00 every day. --- anyone know how to make a scheduled task to restart cfserver on a win 2000 box? we have one that keep puking on us and are about to replace the box (new ones came in today) but are looking for a duct tape type fix for the short term until we can switch it out. kirk ~~ 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: OT SQL STORED PROCEDURES
What do you mean by OT? I know that on MS SQL Server, it does not allow you to break up a sql statement like that. Making the assumption that the rule applies and is the same on other db's. you would have to do it like this: create proc test1 @groupid int if @groupid = 0 begin select * from groups end ELSE begin select * from groups where groupid = @groupid end GOOD LUCK --- William J Wheatley [EMAIL PROTECTED] wrote: WITH THE IF/ELSE/ on Stored Procedures is there a way to write a storedproc so it was like this SELECT * from member where membernumber 0 IF @name is "0" and name='blah' end if @this eq "that" and that='test' end to make it only run certain things if certain values are set Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to 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 Site: Deerfield.com
well the most inportant site of all seems to be using cf. http://www2.victoriassecret.com/catalogue/view/dsp_spread.cfm?window=BDpage =p2p3 - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 12:04 PM Subject: Re: CF Site: Deerfield.com Also QXL's fairly new "Live" auction site: http://www.qxllive.com Will -- [EMAIL PROTECTED] -=- www.lukrative.com Classifieds -=- SixthSense on DVD for Free @ www.localbounty.com/sixthsense/ - Original Message - From: ""stas"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Wednesday, January 24, 2001 5:31 PM Subject: Re: CF Site: Deerfield.com Also: http://www.palmgear.com/ http://www.logitech.com - Original Message - From: "Martin Sutton" [EMAIL PROTECTED] I just noticed that deerfield use CF. This is quite an important site imho. ~~ 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: Page execution time too long?
On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. Do you have better success with ASP, Perl, or Java, doing the exact same tasks as CF? That's really the important question. No server-side CGI program is going to perform as well as a web server simply returning a static page. In some cases, under high load, your best approach may be to perform "offline" generation, as you're doing. If you don't need to execute code at runtime, you'll always get better performance by executing it earlier, then returning static results as needed. The key to building scalable CF sites - or scalable sites with other server-side CGI tools, in my opinion - is to eliminate unnecessary runtime execution. Certainly, with comics sites like yours, I'd guess that there's plenty of room for offline code generation. I've only done informal comparisons between CF and ASP, using SilkPerformer for load tests, but in those comparisons, I didn't see much difference between analogous CF and ASP code. Where I did see some difference was that with ASP, you're more likely to migrate program logic out of ASP itself, and put it in COM/MTS/COM+, and potentially get better performance that way. I'm certainly willing to accept the possibility that CF doesn't perform exactly as well as some other specific CGI environment (or vice-versa), but if you were building doonesbury.com with ASP or whatever, I'd still recommend doing as little work at runtime as possible. 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: restarting cf server
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Write a batch file with the following contents: net stop "Cold Fusion Application Server" net start "Cold Fusion Application Server" Schedule a job (in the Control Panel). Just for assurance's sake, use a login that has the privileges to stop and start services on the machine. :) Joe Joseph Cruz Wharton Computing and Information Technology Programmer/Analyst 3620 Locust Walk Suite 400 SH-DH Philadelphia, PA 19104-6302 [EMAIL PROTECTED] 215-898-1220(w) 215-573-2798(f) 215-308-0657(p) 215-768-2071(m) -Original Message- From: Kirk Boecker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 4:49 PM To: CF-Talk Subject: restarting cf server anyone know how to make a scheduled task to restart cfserver on a win 2000 box? we have one that keep puking on us and are about to replace the box (new ones came in today) but are looking for a duct tape type fix for the short term until we can switch it out. kirk ~~ 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: Page execution time too long?
Often times these kind of slowdowns come from database or other outside connection CF has to make. Look at the execution time of your queries. Look at CFX tags and COM objects. At 01:59 PM 1/24/2001 +, you wrote: Merry Meet Matthew, If CF doesn't scale then how do you explain the best example of an extremely large, heavily trafficed site out there, Autobytel? Perhaps the problem isn't software but hardware. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Matthew Taylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 9:28 PM To: CF-Talk Subject: RE: Page execution time too long? On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. -Matt Matthew- I don't agree with your statement that CF doesn't scale. It will scale as well as the code which is run on it. Possibly these people working for busy CF sites are not experienced in writing scalable code? - jason. - Original Message - From: "Matthew Taylor" [EMAIL PROTECTED] To: "CF-Server" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 3:48 PM Subject: RE: Page execution time too long? 150 millisecs under no load would cause some alarm for me personally. We tested our pages under no load and they ran in under 100 millisecs, under simulated load (silk performer), they jumped to well over 1,000. As I'm sure anyone working for a busy CF site will tell you, Cold Fusion does NOT scale well at all. If you're concerned about page times under ideal conditions...it's all down hill from there. Matthew Taylor Web Developer 617.868.0009 ext.216 [EMAIL PROTECTED] http://www.uClick.com http://www.uComics.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:38 PM To: CF-Server Subject: RE: Page execution time too long? IMHO 150 millisecs is not too much. As far as a general guideline on the maximum execution of pages i would have to say that depends on application you're building. I have had routines that took several seconds to process but that was still acceptable since it was performing some relatively big calculations. Allan Pichler -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:29 AM To: CF-Server Subject: Page execution time too long? I wondered if there are any guidelines for a maximum amount of miliseconds a page should take to process. I have a page which takes 150milliseconds to execute is this acceptable? What do others recommend should be the maximum execution time of a page?? ~~ 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: Allaire on a Mac?
I think this would explain some problems I am having with flash and the mac. On a pc loading variables into a flash movie is a simple process. However for Netscape on a mac I seem to have to set a cookie and read it instead of loading directly from a CF template and I have yet to find a way to get IE on a mac to load variables. Anyone know if I am just doing this wrong? I'm no Flash guru - I can spell it, that's about it - but there are known problems with some plugins in some browsers. I can tell you where you can get this answered, though. There's a Flash list run by Branden Hall, a Fig Leaf guy, which covers ActionScript issues quite a bit. It has a moderate amount of traffic, and is generally on-topic. For more info: http://chattyfig.figleaf.com/ 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: Page execution time too long?
How do you explain ToysRus Katrina? With 500,000 hits a day I'm sure he has the hardware to deal with anything. CF as it is does not lend itself to high volume sites. Perhaps with user definable functions and some tightening and integration of cfscript sites will be able to scale better. I personally think cf's scaling problems come mostly from having to do so much parsing, and make allowances for easily debuggable errors. We already know most of this will be done away with in Neo, since there will be no parsing of html to be done by CF... jon - Original Message - From: "Katrina Chapman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 8:59 AM Subject: RE: Page execution time too long? Merry Meet Matthew, If CF doesn't scale then how do you explain the best example of an extremely large, heavily trafficed site out there, Autobytel? Perhaps the problem isn't software but hardware. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Matthew Taylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 9:28 PM To: CF-Talk Subject: RE: Page execution time too long? On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. -Matt Matthew- I don't agree with your statement that CF doesn't scale. It will scale as well as the code which is run on it. Possibly these people working for busy CF sites are not experienced in writing scalable code? - jason. - Original Message - From: "Matthew Taylor" [EMAIL PROTECTED] To: "CF-Server" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 3:48 PM Subject: RE: Page execution time too long? 150 millisecs under no load would cause some alarm for me personally. We tested our pages under no load and they ran in under 100 millisecs, under simulated load (silk performer), they jumped to well over 1,000. As I'm sure anyone working for a busy CF site will tell you, Cold Fusion does NOT scale well at all. If you're concerned about page times under ideal conditions...it's all down hill from there. Matthew Taylor Web Developer 617.868.0009 ext.216 [EMAIL PROTECTED] http://www.uClick.com http://www.uComics.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:38 PM To: CF-Server Subject: RE: Page execution time too long? IMHO 150 millisecs is not too much. As far as a general guideline on the maximum execution of pages i would have to say that depends on application you're building. I have had routines that took several seconds to process but that was still acceptable since it was performing some relatively big calculations. Allan Pichler -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:29 AM To: CF-Server Subject: Page execution time too long? I wondered if there are any guidelines for a maximum amount of miliseconds a page should take to process. I have a page which takes 150milliseconds to execute is this acceptable? What do others recommend should be the maximum execution time of a page?? ~~ 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: Page execution time too long?
I hear stories like this, and I have to wonder what your definition of "scale" is. Obviously, we don't have the full story, but this snippet makes it sound like you define "scale" to mean "can sustain unlimited amounts of traffic without slowing down". I'm sure you don't mean that, but it sounds like it. What you are probably saying, is that as load increases, page response time does not grow linearly. It instead grows asymptotically, rising faster then the increase in load, to an infinite page response time. In my experience, this is true. We also have this problem with Netgravity (ad serving software). Our experience shows that CF scales linearly with load, up to a point, then falls apart. CF Solaris seems to do a better job at this, perhaps suggesting that the problem is partly associated with the OS, or at least Allaire's interaction with the OS. We've observed that examiniation of this linear-asymptotic can lead to a correct setting for the number of threads, more or less preventing this problem. It helps if you are running a single or a few applications on a box, not in a shared server environment. By setting the number of threads to the proper level, the machine won't go all wonky, and requests will sit in a queue all nice and happy until they can get processed. We've also observed that CF scales pretty much linearly by processor speed. We've observed that CF does not scale very well (vertically?) with additional processors. This could be an NT problem, but CF doesn't even scale evenly with the graphs and stats I've seen of NT's scalability. CF scales (assuming you've written your application well) very well (horizontally) by adding machines. Course, this isn't that hard, and depends on your database server or other shared resources don't become bottlenecks. Of course, all this depends on having coded the application well, and locked everything properly, etc. This also all depends on realizing that if your application takes 200ms per page (on average), the best you EVER will get out of that box is 5 requests per second. If you expect to serve more, there's nothing you can do - you have to add new boxes or faster boxes, or make the code faster somehow. This isn't scalability, this is just performance. Dynamic page serving will always be and order of magnitude or two slower then static. Even serving HTML file thru CF server (no CFML at all) is an order of magnitude slower then just serving them up from the webserver - this is due to all the application overhead. So, Matthew, if you divided your expected/actual peak traffic for an hour by 3600 second/hour, how may ms per page did you have to have the pages serve in? You are doing 500K per day, lets say 50K peak in one hour. This is 13.9 (lets say 14) pages per second, or about 71ms per page - under load. Yikes. I would have spread this between about 4-6 servers (600+ PII x2, 512MB RAM, Mirrored 9GB drives - say Dell 2450's). Matthew Taylor wrote: On the contrary we all have been writing code, not just CF, but ASP, C, Perl, and Java for quite a few years. We even had a consultant from Allaire come out and do a code review. We passed with flying colors, under heavy load, CF bogs down big time. I'm not sure what you consider "heavy" but we get over 500,000 page views per day, between ucomics, doonesbury and garfield. The problem became so bad that we wrote our own scripts that generate static htm's nightly. Our site is now 75% static and runs about 75% faster. I'm not knocking CF at all it's great for what it does do, but it does not scale. I'm sure there are some others out there that agree. -Matt Matthew- I don't agree with your statement that CF doesn't scale. It will scale as well as the code which is run on it. Possibly these people working for busy CF sites are not experienced in writing scalable code? - jason. - Original Message - From: "Matthew Taylor" [EMAIL PROTECTED] To: "CF-Server" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 3:48 PM Subject: RE: Page execution time too long? 150 millisecs under no load would cause some alarm for me personally. We tested our pages under no load and they ran in under 100 millisecs, under simulated load (silk performer), they jumped to well over 1,000. As I'm sure anyone working for a busy CF site will tell you, Cold Fusion does NOT scale well at all. If you're concerned about page times under ideal conditions...it's all down hill from there. Matthew Taylor Web Developer 617.868.0009 ext.216 [EMAIL PROTECTED] http://www.uClick.com http://www.uComics.com -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:38 PM To: CF-Server Subject: RE: Page execution time too long? IMHO 150 millisecs is not too much. As far as a general guideline on the maximum execution of pages i would have to say that depends on application
RE: Page execution time too long?
Right. Check out Doug's comments on scaling at http://doug.nottage.com/cf/ Doug is the CF-master at Autobytel.com best, paul At 01:59 PM 1/24/01 +, you wrote: If CF doesn't scale then how do you explain the best example of an extremely large, heavily trafficed site out there, Autobytel? Perhaps the problem isn't software but hardware. ~~ 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
Question re: creating documents on the disk.
Well, I've been off the list since before the holidays and thought now would be a good time to sign back... because I have a question/request/problem. I've built an application to handle some aspects of our customer relations. I've completed every part but one... and I'm hitting my head on wall over it! In a nutshell, a person enters some information from which a contract is displayed to the person on the screen. They click agree and the database is updated fine and emails are sent, etc etc. My problem is this: how to take that information and lob it into a document which will saved on the web server. I've search high and low for a tutorial on this and the books all seem vague (or I'm looking in the wrong place!) Could someone lend me a hand? Thanks! Greg Creedon ~~ 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: cftry/cfcatch and cfswitch issues?
No issues. And a catch type is not needed. When the catch type is left out, then the default is "any". I think the issue here is that there is a difference between exceptions and errors. Errors occur at first pass compilation before the code on the page is actually run. Exceptions occur at run time. Try and Catch blocks only catch exceptions. What is probably happening is that the code is causing an error and not an exception, therefore the try is not catching the error. The cfswitch is not preventing the cfcatch from catching the exceptions. So all I might have done for you is to clarify what can be caught by try blocks and what cannot as well as clarify that the problem is not due to the cfswitch. The following code proves that an exception thrown by code inside a case statement can be caught. cfset myvar = 1 CFTRY CFSWITCH EXPRESSION="#myvar#" CFCASE VALUE="1" !-- throws a missing include -- CFINCLUDE template="bla.cfm" /CFCASE CFCASE VALUE="2" !--- this causes an expression exception because it accesses a variable that is not defined --- CFOUTPUT#thisvar#/CFOUTPUTBR /CFCASE CFDEFAULTCASE default case BR /CFDEFAULTCASE /CFSWITCH CFCATCH CFOUTPUT #cfcatch.type#BR /CFOUTPUT /CFCATCH /CFTRY --- Mike Townend [EMAIL PROTECTED] wrote: You will need to put a catch type in... try CFTRY CFSWITCH etc etc (all the stuff) /CFSWITCH CFCATCH TYPE="Any" arhhh!! /CFCATCH /CFTRY -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 18:00 To: CF-Talk Subject: cftry/cfcatch and cfswitch issues? Hey gang, A fellow co-worker is working on adding some CFTRY/CFCATCH goodies to a site we're working on. It's a semi-FuseBox site - not 100% Fusebox but close enough for gub'mint work. So what we're trying: CFTRY CFSWITCH etc etc (all the stuff) /CFSWITCH CFCATCH blah blah /CFCATCH /CFTRY and it doesn't seem to be catching any errors. Are there issues wrapping the switch(s) inside the try? Do we need to, in each of the includes that are fired up within the cases within the switches, do try/catch? Thanks in advance, --Scott ~~ 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 Site: Deerfield.com
Darn, the dsp_spread template wasn't at all what I was hoping for. ;) -ron -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 4:20 PM To: CF-Talk Subject: Re: CF Site: Deerfield.com well the most inportant site of all seems to be using cf. http://www2.victoriassecret.com/catalogue/view/dsp_spread.cfm?window=BDpage =p2p3 ~~ 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
SQL Create Table
I'm trying to run a SQL query to create a table ... locally, I'm creating in access, but when I'm ready to move to the production server, it needs to work in Oracle. At any rate, the following works, but it's not what I need: CREATE TABLE Test ( TestID Counter NOT NULL CONSTRAINT PrimConstraint PRIMARY KEY, TestName varchar(100) NULL, Background varchar(250) NULL, DetailLink varchar(25) NULL, Votes varchar(4) NULL ) What I need is for Votes to be a number, an integer, a num or an int (all of which I've tried as keywords and none of them work). How do I create a column name that is a number in access? And how would that differ in oracle, if at all. And what a about a boolean (yes/no) column in access/oracle? Thanks. H. ~~ 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
Spaces in query column names
I have a table that is out of my control and some of the column names have spaces or dashes in them and one is a number. Querying the table works fine, but when I go to output the results of the query CF chokes on these various column names. I've tried different formatting functions to present a proper variable name to CF, but so far have not had any luck. Does somebody know how to format improper column names to that CF will output them? I appreciate any help! ~~ 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: restarting cf server
You can use the AT scheduler and just schedule the following: net stop "cold fusion application server" net start "cold fusion application server" Note that all sessions will be lost when you do this... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Kirk Boecker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 4:48 PM Subject: restarting cf server anyone know how to make a scheduled task to restart cfserver on a win 2000 box? we have one that keep puking on us and are about to replace the box (new ones came in today) but are looking for a duct tape type fix for the short term until we can switch it out. kirk ~~ 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: Javascript/Netscape Problem
Thanks! Works like a charm. best, paul At 04:37 PM 1/24/01 -0500, you wrote: Paul, Try: popupWin = window.open(url, name, "resizable,location,scrollbars,width=500,height=500,innerWidth=500,innerHeig ht=500,left=75,top=75"); That should produce a 500x500 window in IE and Netscape. Best, Seva Petrov Senior Developer TheSquare.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: restarting cf server
On 1/24/01, Cruz, Joseph penned: Hi! Write a batch file with the following contents: net stop "Cold Fusion Application Server" net start "Cold Fusion Application Server" Schedule a job (in the Control Panel). Just for assurance's sake, use a login that has the privileges to stop and start services on the machine. There is a batch file right in CFusion/Bin, cycle.bat, that when you click it will set a a daily schedule to stop and restart all 3 services at 2 AM. My server is EST, so I changed it to 4AM before I ran it. You can open it directly from WordPad and edit the times at the bottom if you like then run it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: BEST Reccomendations for CF Hosting
Thanks to all of you, for the response, am going to look into CFM-resources, and www.atswebnet.com but I am also trying to figure out this bandwidth ratio they talk about or transfer rate, (sorry but what does that mean to me? ) I dont have a clue "Michael" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: Spaces in query column names
Why don't you use column aliases in the query: SELECT 'First Name' AS FirstName, 'Last-Name'AS LastName, PhoneExtension FROM Employees ORDER BY 'Last-Name', 'First Name' (example from Ben Forta's CF Web Application Construction Kit book) Eric -Original Message- From: Williams, Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 2:56 PM To: CF-Talk Subject: Spaces in query column names I have a table that is out of my control and some of the column names have spaces or dashes in them and one is a number. Querying the table works fine, but when I go to output the results of the query CF chokes on these various column names. I've tried different formatting functions to present a proper variable name to CF, but so far have not had any luck. Does somebody know how to format improper column names to that CF will output them? I appreciate any help! ~~ 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: Spaces in query column names
I have a table that is out of my control and some of the column names have spaces or dashes in them and one is a number. Querying the table works fine, but when I go to output the results of the query CF chokes on these various column names. I've tried different formatting functions to present a proper variable name to CF, but so far have not had any luck. Does somebody know how to format improper column names to that CF will output them? You can alias a column name in your query: SELECT "Column With Spaces" AS ok_column, ... 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: SQL Create Table
It should be "Votes int NULL" instead of Votes varchar(4) NULL -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 2:49 PM To: CF-Talk Subject: SQL Create Table I'm trying to run a SQL query to create a table ... locally, I'm creating in access, but when I'm ready to move to the production server, it needs to work in Oracle. At any rate, the following works, but it's not what I need: CREATE TABLE Test ( TestID Counter NOT NULL CONSTRAINT PrimConstraint PRIMARY KEY, TestName varchar(100) NULL, Background varchar(250) NULL, DetailLink varchar(25) NULL, Votes varchar(4) NULL ) What I need is for Votes to be a number, an integer, a num or an int (all of which I've tried as keywords and none of them work). How do I create a column name that is a number in access? And how would that differ in oracle, if at all. And what a about a boolean (yes/no) column in access/oracle? Thanks. H. ~~ 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: CFUPDATE giving me problems, please help...
I've had this happen using CFGRIDUPDATE before. In that case it required that I use the keyonly="Yes" option. What happens if you just create a cfquery and use sql to do the update? I recently gave up on CFUPDATE because I can't get it to save a date/time field with the time. I always forget until I'm testing the app and I can't match up the date/time field with something or other. I've also had other problems that I can't quite remember now. (My brain only has about 4K of RAM. I'm in serious need of an upgrade!) It's a shame the tag doesn't work for me because it would save me a lot of time to use CFUPDATE. Especially when I later add a field to the database. If you can update the record with SQL, it might help to figure out why CFUPDATE isn't working. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Joby Bednar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:27 PM To: CF-Talk Subject: CFUPDATE giving me problems, please help... I have an admin form to add/edit records in an Access 2000 database. I try to edit a user's record and I get this error: Error Diagnostic Information SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (30:1) to (30:50). The problem only comes up when I try to change the username field "username". As far as I can tell, even though I have an id field that is the key for the database, it thinks "username" is my key and CFUPDATE will give me this error. All other uses of the database work fine (other updates, query, delete, etc.) and I double checked to make sure "id" is the key and it is. Is "username" a reserved word somewhere where this would be such a problem? Is the problem with Access 2000 or CFUPDATE? Any help would be great. The code to update is very simple: cfupdate datasource="mydatasource" tablename="mytablename" Joby Bednar Director of Internet Design iNEOgroup.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: Page execution time too long?
At 17:25 1/24/01 -0500, you wrote: How do you explain ToysRus Katrina? I thought ToysRus problems' were related to order fullfillment, things like that? Not enough Tickle Me Elmos and stuff, they couldn't ship fast enough, etc. I didn't think it had anything to do with CF. Am I wrong? Ryan (hoping this post will show up before everyone forgets this thread...) ~~ 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: BEST Reccomendations for CF Hosting
For small sites it does not mean much, but it is a restriction to your service. They will only allow you to transfer so much data per month. Then there is a surcharge. The amount of data you transfer is dependent on graphics, and so forth. Look for one that does not restrict your data transfer. Thanks, Robert - Original Message - From: "Michael" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 9:08 PM Subject: Re: BEST Reccomendations for CF Hosting Thanks to all of you, for the response, am going to look into CFM-resources, and www.atswebnet.com but I am also trying to figure out this bandwidth ratio they talk about or transfer rate, (sorry but what does that mean to me? ) I dont have a clue "Michael" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Any opinions on Hosting firms for CF 4.5 not alot of HD space just something simple. ~~ 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: SQL Create Table
Great, got that. Thanks, Richard. I think I figured that out right about the time you were posting this. But I'm still hung up on how to create a boolean column. Any suggestions? -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 3:30 PM To: CF-Talk Subject: RE: SQL Create Table It should be "Votes int NULL" instead of Votes varchar(4) NULL -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 2:49 PM To: CF-Talk Subject: SQL Create Table ~~ 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: Page execution time too long?
That's the impression I got. The CF-based site ran like a champ - their fulfillment process was what was lacking. - Original Message - From: "Ryan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 4:33 PM Subject: Re: Page execution time too long? At 17:25 1/24/01 -0500, you wrote: How do you explain ToysRus Katrina? I thought ToysRus problems' were related to order fullfillment, things like that? Not enough Tickle Me Elmos and stuff, they couldn't ship fast enough, etc. I didn't think it had anything to do with CF. Am I wrong? ~~ 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
