RE: price of aspx vs cfm
I think this is the URL you are referring to: http://www.macromedia.com/devnet/mx/coldfusion/articles/cf_aspnet.html jb -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: 04 May 2004 19:44 To: CF-Talk Subject: Re: price of aspx vs cfm Ben Forta did a great article on this a while back.I Hopefully he'll chime in with a URL. From my perspective, there are 2 major areas where CF saves money. First, development time.CF development is, IME, faster; less development time = saved money.Second, what you don't have to buy.My ASP experience goes back to ASP 3.0, so things might have changed with .net, but with ASP, if you wanted to do file uploads, or send emails, or do any of that special stuff, you had to go find a third-party solution which would usually cost $$$. So, take the argument from this perspective.Come up with an application that involves database access, file uploading, writing your own logs, robust error handling, and sending emails.Agree on the requirements, then have 2 developers of roughly equal skill levels develop the app in both CF and ASP.See who's headed for happy hour and who's headed for the bottle of excedrin. Pete John Ho wrote: hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form button
This has been around much longer. If I recall correctly it was introduced in CF 4.0.1 -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: dinsdag 4 mei 2004 22:52 To: CF-Talk Subject: Re: Form button Original Message: From: Dave Francis Date: Tue, 4 May 2004 15:44:20 -0400 Even when form.c1 isn't defined, the second test (after the and) is still evaluated. This is only true in pre-MX versions of CF.In CFMX, if the left side of an AND check returns false, it stops evaluating the rest of the if code. (Similarly, I believe that if the left hand side of an OR check returns true, it also stops evaluating) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF to SWF ??
Does anyone know of any tools that I can use from within ColdFusion to convert a PDF to a SWF for use in an Flash application?Any related conversion utilities would be welcome, I just need to get some non-flash documents into an RIA. Any Java libraries that do this? Thanks. Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: One slow server...
Richard Crawford wrote: Webserver running Cold Fusion MX on JRun4 on Solaris9, talking to MS SQL Server database on a different machine. About two weeks ago, we started experiencing serious slow-downs on our site. You mean at about the same time you patched your Windows for MS04-011, MS04-012, MS04-013 and MS04-014? Jochm -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WDDX
Hi, I'm running CF 5.0 and using WDDX to get data back from another site.What's weird is sometimes the WDDX code is accepted on my server, sometimes it isn't and throws an error.Exact same code is returned in both cases.Has anybody seen this happen before? Regards, Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WDDX
I'm running CF 5.0 and using WDDX to get data back from another site.What's weird is sometimes the WDDX code is accepted on my server, sometimes it isn't and throws an error.Exact same code is returned in both cases.Has anybody seen this happen before? Could you be a bit more specific? What does your code look like, what does the wddx look like, etc.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Confused by Verity in CFMX
Hi, I am using CFMX standard at a Host, so I have no access to CFAdmin. I am dealing with large amounts of data for a hockey stats database. Problem I have used CFCOLLECTION to index a few database tables and some PDFs. I appear to have reached the permissible limit which is 125,000 records. But I am confused by exactly how the value is determined. For example, I have the following collections: - collection of players with appx. 25,000 records - collection of about 50 PDFs - collection of teams with appx. 4000 records - collection of player notes with appx. 15,000 records So in total, there are no more than about 45,000 records that need to be indexed. I listed the total collections on the box with a script and there are only two others (than mine) for what appear to be small sites, but obviously I cannot be sure of how large those collections are. Problem == - When I index the player notes collection, it only indexes the first few thousand records and then quits, with no errors. I am certain that it is not indexing all of the records as some of the values I know to be present do not get returned. Furthermore, this is te exact behaviour I experience on my laptop which uses CFMX Dev. edition which has a max Verity size of 10,000 docs. The only way I knew that I had reached the limit was bylooking in the CF logs, so I suspect that the same thing is happening at the host. Confusing == Despite thinking that I may have reached the max record limit, when I re-index the player collection after I add 200 new players and re-index the collection, they are present. If I were in fact at the limit, would the player collection not grow either? Questions == - Is there a function to determine the number of records indexed? (Host is not using K2...I tried those functions) - I understand that each row returned in the indexed query is considered a document, but does it somehow consider joins in the equation? - Should I resort to database searching and just use Verity for PDFs? Any info appreciated. James [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion Developer Edition
Ok I know there is a ColdFusion Developer edition, but here is my question. >From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. Bob Everland [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
The Developer edition is free, and it does have IP restrictions. There are no other free versions, and shared servers (whether used for development, staging, or production) are paid for servers. --- Ben _ From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:23 AM To: CF-Talk Subject: ColdFusion Developer Edition Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. Bob Everland _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
And, if you have a multiple developer invironment where you may need a CF capable server without IP restrictions, there is still BlueDragon from NewAtlanta. (Sorry Ben, had to throw it out there...) Cutter Ben Forta wrote: The Developer edition is free, and it does have IP restrictions. There are no other free versions, and shared servers (whether used for development, staging, or production) are paid for servers. --- Ben _ From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:23 AM To: CF-Talk Subject: ColdFusion Developer Edition Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. Bob Everland _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
That's like saying that I can use PostgreSQL instead of SQL. yeah they pretty much do the same thing, but I need it to be 100% duplicate of my live box. Bob Everland And, if you have a multiple developer invironment where you may need a CF capable server without IP restrictions, there is still BlueDragon from NewAtlanta. (Sorry Ben, had to throw it out there...) Cutter Ben Forta wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: mappings in cfide/administrator
On Tuesday 04 May 2004 19:47 pm, Tony Weeg wrote: how in the fizzuck do I install rds??it's a new cfmx install... (well, a repair job, we lost our www server last week) You could just type the path in the box. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Graphs with CFMX
On Monday 03 May 2004 10:59 am, Spectrum WebDesign wrote: JFreeChart is a free Java class library for generating charts, including: JFreeChart contain a jsp library to run with J2EE server. How to run that script with CF script? It's possible? CFMX will let you use the Java classes stright from CF, and you can look in their jsp and docs to see how to use it. Should be easy enough. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Problem w/IIS SSL installing new SSL cert
Sorry, I was wrong about IIS4--it's IIS 5, on WIN2K. OK. You should still be able to create a new certificate request without uninstalling the previous certificate. Are you renewing a certificate, or replacing it altogether? [Hey, even more OT, you probably don't remember the class, but I was in one of the classes you taught at Boeing, in Downey CA, many years ago...] Oh, I remember that class alright. It was the very first class I taught, and after class ended I went skydiving, and saw a naked woman posing for a photoshoot in front of an LA bookstore. So, yeah, I remember that class. How's everyone doing out there? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: One slow server...
I've also checked the SQL in the SP's that CF calls, and there seems to be nothing wrong there; when I run them in the command line they only take a few seconds to run.However, it takes several minutes for the login to process on the web. I'm at a loss. Anyone got any ideas as to what I could check next? As Jochem suggested, you should check the patch history of the Windows machine. You might also try connecting from other clients on other machines, to see if you can narrow down the cause of the slowdown. You might use ViennaSQL and the MS SQL Server JDBC driver to test. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
Barney, I'd love that error handling code.I'll give you a plug on my blog. -mark -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:48 PM To: CF-Talk Subject: RE: Database error messages Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: price of aspx vs cfm
Think of ASP.net as a whole different language and paradigm than straight ASP. In fact, as a framwork, ASP.net looks and feels quite a bit like Flex. Good ASP programming with use a combination of code-behinds in vb script, C# classes that are inheareted into the ASP.net page and stored proceedures for accessing data, and custom componet tags. With that out of the way here are some of the more compelling reasons to use CF. 1) Cold Fusion is not tied down to the Windows platform. ASP.net is definatly tied to the whims of microsoft. In fact you can run Cold Fusion in a Linux/Apache/Tomcat environment. The last time I checked, these systems were free. Windows as the operating system can cost anywhere from a few hundred to a few thousand dollars depending on the version selected. Linux/Apache/Tomcat can be downloaded for free. In fact, if cost were the only issue, take a look at Jarkarta Struts -- a Java framework containing many of the same features as ASP.net. Since your team is not considering Struts --this tells me that cost is not the only issue here, rather your team wants to use the Microsoft platform. 2) ASP.net is tied to the current version of the IIS webserver. I do not believe you can use the Apache webserver with ASP.net. In fact Microsoft considers IIS an application server for ASP.net. hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Yes - but all the developers must have a subscription - right? -mk -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:21 AM To: CF-Talk Subject: RE: ColdFusion Developer Edition Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Yes - but all the developers must have a subscription - right? Yes, I think so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF to SWF ??
Flashpaper, available in MM Contribute can do something akin to this - though I don't think it can be done programmatically.(would be a nice addition to future CF versions - embedded report write with flashpaper/PDF functionality) -Nate -Original Message- From: Tony Pimm [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 3:44 AM To: CF-Talk Subject: PDF to SWF ?? Does anyone know of any tools that I can use from within ColdFusion to convert a PDF to a SWF for use in an Flash application?Any related conversion utilities would be welcome, I just need to get some non-flash documents into an RIA. Any Java libraries that do this? Thanks. Tony _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PDF to SWF ??
On Wednesday 05 May 2004 14:44 pm, Nathan C. Smith wrote: nice addition to future CF versions - embedded report write with flashpaper/PDF functionality) cough Have you applied for any of the MM beta/alpha programs to see what may or may not appear ? cough There is always the wish list too, but I can't remember the URL for it. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
URL Path ?
Hey guys... I am trying to find a better way to grab the landing page URLTo be more specific I have a bot/spider tracker I built a long time ago and I want to update the way it tracks the pages it hits. Currently I use this: http://#CGI.server_name##CGI.script_name#/#cleanpathinfo# I am also using the SEO safe urls app fromwww.fusium.com I need to be able to log the entire url with variable strings and all. It works for the most part but sometimes it shows likes like www.mysite.com/index.cfm/index.cfm and things like this. Is there an easer better way to grab the url path shown in the browser at the time the bot/spider hits the page. Thanks. Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
Yeah they do, BUT it's only $49.95 now for sql server. http://www.microsoft.com/sql/howtobuy/development.asp Yes - but all the developers must have a subscription - right? Yes, I think so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
The single user version is good if I am the only person to hit the box, but if I'm limited by ip address I could run into an issue if it decides to bind on 127.0.0.1 instead of an outside IP address. Can you make ColdFusion bind to another ip on purpose? Bob Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Syntax error on Where statement?
Anyone know why my syntax is wrong in my Where statement please? Cold Fusion Server logged the following error information: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '='. SQL = Update maintenance_report SET maint_report_impact_search = 'NO' Where maint_report_date = '06/10/2004 ' and id = 9 This is my code: cfquery name=search datasource=wweb_status_internal_test Update maintenance_report SET maint_report_impact_search = '#form.maint_report_impact_search#' Where maint_report_date = '#form.maint_report_date#' and id = #id# /cfquery I think I may have to trim the maint_report_date field. Is that it? Thanks as always. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
The single user version is good if I am the only person to hit the box, but if I'm limited by ip address I could run into an issue if it decides to bind on 127.0.0.1 instead of an outside IP address. Can you make ColdFusion bind to another ip on purpose? You can ensure that the first request to that CF server is made through that IP address. Offhand, I don't remember whether CFMX accepts requests from one IP address, or localhost and one external IP address. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
URL Path ?
Rather than using #cleanpathinfo# (which is generated by SESconverter for its internal use) you would be better off using the cgi variables directly, on IIS a combination of cgi.PATH_INFO and cgi.query_string. The cleanpathinfo is used internally by SESconverter, and in hindsight it should be destroyed by SESconvert.cfm once it has served its purpose. I've just had a quick look and it seems that when there are no SES type parameters then cleanpathinfo is set to the current template path, which isn't a problem, unlees you are relying on it, which you shouldn't be... HTH Bert From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 15:31 To: CF-Talk Subject: URL Path ? Hey guys... I am trying to find a better way to grab the landing page URLTo be more specific I have a bot/spider tracker I built a long time ago and I want to update the way it tracks the pages it hits. Currently I use this: http://#CGI.server_name##CGI.script_name#/#cleanpathinfo# I am also using the SEO safe urls app fromwww.fusium.com I need to be able to log the entire url with variable strings and all. It works for the most part but sometimes it shows likes like www.mysite.com/index.cfm/index.cfm and things like this. Is there an easer better way to grab the url path shown in the browser at the time the bot/spider hits the page. Thanks. Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
determine number of records deleted
I was wondering what people use to determine the number of records a query has deleted.Basically, how would you make the following code different in order to increase performance? cfquery datasource=#mydsn2# name=dsn1 select count(*) frommytable /cfquery cfquery datasource=#mydsn# delete from mytable wheremycity = 'Boston' /cfquery cfquery datasource=#mydsn2# name=dsn2 select count(*) frommytable /cfquery cfset variables.recordsdeleted = dsn1.recordcount - dsn2.recordcount [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
disable back button when using div's
Hello everybody, I've read a lot about disabling the browser back button when a user submits a form where the action page is different from the submitting page. It is absolutely important that the user is stopped from going back a page because This is an application where authorised users can add new users Ok, here it goes. The super user fills in the new user form and submits the page. On form submission I'm displaying a confimation message. This is displayed inside a div tag. Here, this might help. cfif isDefined(form.hid_adduser) and form.hid_adduser neq !--- code to add the user in the database starts here --- !--- code to add the user in the database ends here --- CFLOCATION URL=""> addtoken=no /cfif cfif isDefined(url.callAdded) body div id=confirmdiv style=z-index:2; position:absolute; left:35px; top:90px; width:650px; display:block cfoutput table border=0 align=center width=355 height=205 tr td valign=bottom div style=position:relative; left:15px; top:1px; class=label Thank you for adding a new user. An email has been sent to the customer to advise. /div /td /tr /table /cfoutput /div /body cfelse body form name=addUserFrm method=post action=""> cfoutputinput type=hidden name=returnto value=#cgi.script_name#?#cgi.query_string#/cfoutput table border=0 cellpadding=0px cellspacing=3px tr tdinput name=newuser type=text/td /tr tr tdinput type=submit name=addUser value=Add User/td /tr /table input type=hidden name=hid_adduser value= /form /body /cfif I want to disable the 'back' button when the user sees the confimation message. Is this possible, if yes can somebody please show me. Best regards, cfcoder __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
It is localhost plus 1 external IP address per restart. The first encountered external IP is stored in license properties -- you can clear this and restart CFMX to allow a different IP address. HTH Dick On May 5, 2004, at 8:11 AM, Dave Watts wrote: The single user version is good if I am the only person to hit the box, but if I'm limited by ip address I could run into an issue if it decides to bind on 127.0.0.1 instead of an outside IP address. Can you make ColdFusion bind to another ip on purpose? You can ensure that the first request to that CF server is made through that IP address. Offhand, I don't remember whether CFMX accepts requests from one IP address, or localhost and one external IP address. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
The single user version is good if I am the only person to hit the box, but if I'm limited by ip address I could run into an issue if it decides to bind on 127.0.0.1 instead of an outside IP address. Can you make ColdFusion bind to another ip on purpose? You can ensure that the first request to that CF server is made through that IP address. Offhand, I don't remember whether CFMX accepts requests from one IP address, or localhost and one external IP address. I think it is localhost+1 external. Although too busy to confirm. ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: disable back button when using div's
cf coder said: I want to disable the 'back' button when the user sees the confimation message. Is this possible, if yes can somebody please show me. You can kludge some workarounds that will fool most browsers, but you can't reliably disable the back button. In *my* browser *I* decide whether *my* back button will work. You can do whatever you want on the server, like ignoring the second/third etc. submission of the form, because you control the server, but the client controls the browser. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Syntax error on Where statement?
instead of asking 'is that it?' (in relation to trimming the report_date value), why not simply try it? other than that i'd suggest that if your maint_report_date column is a date/time datatype, you use a createODBCDate() function around the value (and drop the single quotes).I'd futher suggest using a cfqueryparam for both of those dynamic values (maint_report_date and id). WHERE maint_report_date = cfqueryparam value=#createODBCDate(form.maint_report_date)# cfsqltype=cf_sql_date AND id = cfqueryparam value=#id# cfsqltype=cf_sql_integer - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 7:56 AM Subject: Syntax error on Where statement? Anyone know why my syntax is wrong in my Where statement please? Cold Fusion Server logged the following error information: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '='. SQL = Update maintenance_report SET maint_report_impact_search = 'NO' Where maint_report_date = '06/10/2004 ' and id = 9 This is my code: cfquery name=search datasource=wweb_status_internal_test Update maintenance_report SET maint_report_impact_search = '#form.maint_report_impact_search#' Where maint_report_date = '#form.maint_report_date#' and id = #id# /cfquery I think I may have to trim the maint_report_date field. Is that it? Thanks as always. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
you can clear this and restart CFMX to allow a different IP address. Does clearing it still mean editing an xml file? Or have they enabled that via CF Admin? Ken [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
6.0 needed the xml file to be edited, 6.1 is just a restart of CFMX service. -Original Message- From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 16:19 To: CF-Talk Subject: RE: ColdFusion Developer Edition you can clear this and restart CFMX to allow a different IP address. Does clearing it still mean editing an xml file? Or have they enabled that via CF Admin? Ken [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: determine number of records deleted
cfquery datasource=#mydsn# name=dsn1 select count(*) from mytable where mycity = 'Boston' /cfquery cfquery datasource=#mydsn# delete from mytable where mycity = 'Boston' /cfquery HTH Dick On May 5, 2004, at 8:09 AM, Michael Hodgdon wrote: I was wondering what people use to determine the number of records a query has deleted. Basically, how would you make the following code different in order to increase performance? cfquery datasource=#mydsn2# name=dsn1 select count(*) from mytable /cfquery cfquery datasource=#mydsn# delete from mytable where mycity = 'Boston' /cfquery cfquery datasource=#mydsn2# name=dsn2 select count(*) from mytable /cfquery cfset variables.recordsdeleted = dsn1.recordcount - dsn2.recordcount [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax error on Where statement?
Thanks Charlie. I tried the trim function and it did not help. The maint_report_date column is a char field. Should it be a date/time datatype in order for this to work properly? The code you sent still gives the syntax error. Robert O. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:19 AM To: CF-Talk Subject: Re: Syntax error on Where statement? instead of asking 'is that it?' (in relation to trimming the report_date value), why not simply try it? other than that i'd suggest that if your maint_report_date column is a date/time datatype, you use a createODBCDate() function around the value (and drop the single quotes).I'd futher suggest using a cfqueryparam for both of those dynamic values (maint_report_date and id). WHERE maint_report_date = cfqueryparam value=#createODBCDate(form.maint_report_date)# cfsqltype=cf_sql_date AND id = cfqueryparam value=#id# cfsqltype=cf_sql_integer - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 7:56 AM Subject: Syntax error on Where statement? Anyone know why my syntax is wrong in my Where statement please? Cold Fusion Server logged the following error information: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '='. SQL = Update maintenance_report SET maint_report_impact_search = 'NO' Where maint_report_date = '06/10/2004 ' and id = 9 This is my code: cfquery name=search datasource=wweb_status_internal_test Update maintenance_report SET maint_report_impact_search = '#form.maint_report_impact_search#' Where maint_report_date = '#form.maint_report_date#' and id = #id# /cfquery I think I may have to trim the maint_report_date field. Is that it? Thanks as always. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax error on Where statement?
SQL = Update maintenance_report SET maint_report_impact_search = 'NO' Where maint_report_date = '06/10/2004 ' and id = 9 One dumb question I might ask - what is the field type for the maint_report_impact_search and id fields? As far as the date field, you'll need to trim that data unless the database itself is holding the trailing space.Conversion to a date type field would be a good suggestion. Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 4/23/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: price of aspx vs cfm
I thin it's this one: http://www.sys-con.com/coldfusion/article.cfm?id=541 -nathan strutz http://www.dopefly.com/ John Beynon wrote: I think this is the URL you are referring to: http://www.macromedia.com/devnet/mx/coldfusion/articles/cf_aspnet.html jb -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: 04 May 2004 19:44 To: CF-Talk Subject: Re: price of aspx vs cfm Ben Forta did a great article on this a while back.I Hopefully he'll chime in with a URL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Syntax error on Where statement?
As Hatton said, changing maint_report_date to a date/time datatype would probably be preferrable.Doing that, the code I gave you should work (assuming that id is an integer). Otherwise, if you're going to leave it as a char field, change the cfsqltype in the first cfqueryparam to cf_sql_char. opt for the former if possible. Charlie - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:23 AM Subject: RE: Syntax error on Where statement? Thanks Charlie. I tried the trim function and it did not help. The maint_report_date column is a char field. Should it be a date/time datatype in order for this to work properly? The code you sent still gives the syntax error. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax error on Where statement?
All are CHAR fields except ID which is a primary key INT type. Should maint_report_date be other than CHAR? I know date/time would be good, but...I'm kinda new to this SQL biz. Robert O. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:39 AM To: CF-Talk Subject: RE: Syntax error on Where statement? SQL = Update maintenance_report SET maint_report_impact_search = 'NO' Where maint_report_date = '06/10/2004 ' and id = 9 One dumb question I might ask - what is the field type for the maint_report_impact_search and id fields? As far as the date field, you'll need to trim that data unless the database itself is holding the trailing space.Conversion to a date type field would be a good suggestion. Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 4/23/2004 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: price of aspx vs cfm
Thank you for the information Is this true ASP.net can not run in Linux or Unix machine?. If it is I will have good advantage to win this because there area a lot of computers running Linux and Unix in my area Think of ASP.net as a whole different language and paradigm than straight ASP. In fact, as a framwork, ASP.net looks and feels quite a bit like Flex. Good ASP programming with use a combination of code-behinds in vb script, C# classes that are inheareted into the ASP. net page and stored proceedures for accessing data, and custom componet tags. With that out of the way here are some of the more compelling reasons to use CF. 1) Cold Fusion is not tied down to the Windows platform. ASP.net is definatly tied to the whims of microsoft. In fact you can run Cold Fusion in a Linux/Apache/Tomcat environment. The last time I checked, these systems were free. Windows as the operating system can cost anywhere from a few hundred to a few thousand dollars depending on the version selected. Linux/Apache/Tomcat can be downloaded for free. In fact, if cost were the only issue, take a look at Jarkarta Struts -- a Java framework containing many of the same features as ASP.net. Since your team is not considering Struts --this tells me that cost is not the only issue here, rather your team wants to use the Microsoft platform. 2) ASP.net is tied to the current version of the IIS webserver. I do not believe you can use the Apache webserver with ASP.net. In fact Microsoft considers IIS an application server for ASP.net. hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo. com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: price of aspx vs cfm
Microsoft haven't produced (YET) and ASP.NET version for Linux. Linux/Unix computers can access sites written using .aspx files though. -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 16:49 To: CF-Talk Subject: Re: price of aspx vs cfm Thank you for the information Is this true ASP.net can not run in Linux or Unix machine?. If it is I will have good advantage to win this because there area a lot of computers running Linux and Unix in my area Think of ASP.net as a whole different language and paradigm than straight ASP. In fact, as a framwork, ASP.net looks and feels quite a bit like Flex. Good ASP programming with use a combination of code-behinds in vb script, C# classes that are inheareted into the ASP. net page and stored proceedures for accessing data, and custom componet tags. With that out of the way here are some of the more compelling reasons to use CF. 1) Cold Fusion is not tied down to the Windows platform. ASP.net is definatly tied to the whims of microsoft. In fact you can run Cold Fusion in a Linux/Apache/Tomcat environment. The last time I checked, these systems were free. Windows as the operating system can cost anywhere from a few hundred to a few thousand dollars depending on the version selected. Linux/Apache/Tomcat can be downloaded for free. In fact, if cost were the only issue, take a look at Jarkarta Struts -- a Java framework containing many of the same features as ASP.net. Since your team is not considering Struts --this tells me that cost is not the only issue here, rather your team wants to use the Microsoft platform. 2) ASP.net is tied to the current version of the IIS webserver. I do not believe you can use the Apache webserver with ASP.net. In fact Microsoft considers IIS an application server for ASP.net. hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo. com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Yes there's the MM Devnet subscription, but it's rather expensive. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
downloading .exe from website
hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: price of aspx vs cfm
Is this true ASP.net can not run in Linux or Unix machine?. If it is I will have good advantage to win this because there area a lot of computers running Linux and Unix in my area Well, not exactly. The Mono project supports ASP.NET (http://www.go-mono.com/asp-net.html). However, in real life, you aren't going to run into too many people trying to use ASP.NET on Unix. Most .NET developers are Windows-centric, and almost all .NET applications are written specifically for Windows. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: downloading .exe from website
Tony Weeg said: whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? It should work by default, but can be disabled by the IIS Lockdown tool. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax error on Where statement?
Sounds good. I converted it to date/time. My dates now display as 2004-03-08. How do I make it display as 03/08/2004 in my forms? I tried #convert(datetime,convert(char(10),search.maint_report_date,101))#, but it does not recognize datetime. Robert O. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:46 AM To: CF-Talk Subject: Re: Syntax error on Where statement? As Hatton said, changing maint_report_date to a date/time datatype would probably be preferrable.Doing that, the code I gave you should work (assuming that id is an integer). Otherwise, if you're going to leave it as a char field, change the cfsqltype in the first cfqueryparam to cf_sql_char. opt for the former if possible. Charlie - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:23 AM Subject: RE: Syntax error on Where statement? Thanks Charlie. I tried the trim function and it did not help. The maint_report_date column is a char field. Should it be a date/time datatype in order for this to work properly? The code you sent still gives the syntax error. Robert O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: price of aspx vs cfm
http://tinyurl.com/2ddpx http://slashdot.org/articles/04/05/05/0443213.shtml?tid=106tid=185tid=190 http://slashdot.org/articles/04/05/05/0443213.shtml?tid=106tid=185tid=190 tid=201 Theres a Beta of Mono out that should allow .Net to run on linux -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 5, 2004 16:49 To: CF-Talk Subject: Re: price of aspx vs cfm Thank you for the information Is this true ASP.net can not run in Linux or Unix machine?. If it is I will have good advantage to win this because there area a lot of computers running Linux and Unix in my area Think of ASP.net as a whole different language and paradigm than straight ASP. In fact, as a framwork, ASP.net looks and feels quite a bit like Flex. Good ASP programming with use a combination of code-behinds in vb script, C# classes that are inheareted into the ASP. net page and stored proceedures for accessing data, and custom componet tags. With that out of the way here are some of the more compelling reasons to use CF. 1) Cold Fusion is not tied down to the Windows platform. ASP.net is definatly tied to the whims of microsoft. In fact you can run Cold Fusion in a Linux/Apache/Tomcat environment. The last time I checked, these systems were free. Windows as the operating system can cost anywhere from a few hundred to a few thousand dollars depending on the version selected. Linux/Apache/Tomcat can be downloaded for free. In fact, if cost were the only issue, take a look at Jarkarta Struts -- a Java framework containing many of the same features as ASP.net. Since your team is not considering Struts --this tells me that cost is not the only issue here, rather your team wants to use the Microsoft platform. 2) ASP.net is tied to the current version of the IIS webserver. I do not believe you can use the Apache webserver with ASP.net. In fact Microsoft considers IIS an application server for ASP.net. hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo. com/careermakeover _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
whats the thing I have to do to make it so that .exe files are downloadable from my server? You simply have to ensure that the directory in which you place these exe files doesn't allow execution of them. You can do this within the IIS management console - for that directory, make sure that you don't have Scripts and Executables allowed within the Execution field (you can have Scripts only or None chosen). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
Just don't put the EXE files in an executable folder (which folders containing .CFM files likely are) as IIS may try to execute them files instead of serving them. --- Ben _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Syntax error on Where statement?
use dateFormat() on the presentation side. #dateFormat(maint_report_date, 'mm/dd/')# - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:51 AM Subject: RE: Syntax error on Where statement? Sounds good. I converted it to date/time. My dates now display as 2004-03-08. How do I make it display as 03/08/2004 in my forms? I tried #convert(datetime,convert(char(10),search.maint_report_date,101))#, but it does not recognize datetime. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
we ran iis lockdown, which probably has prevented this? maybe, ill look @ that dir and see whats up. thanks! tony -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:00 PM To: CF-Talk Subject: RE: downloading .exe from website Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
On May 5, 2004, at 8:54 AM, Kevin Graeme wrote: You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Yes there's the MM Devnet subscription, but it's rather expensive. We've had threads on this before --- Macromedia may want to rethink the Developer Version IP limit in light of what others are doing: New Atlanta Sybase_ASE Microsoft et al Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
I have scripts only on that dir. and what im getting is a 404 error.however pdf's from the same dir, are downloading fine. hm? its only .exe's and .pdfs in that dir, no cfm templates. tw -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:02 PM To: CF-Talk Subject: RE: downloading .exe from website we ran iis lockdown, which probably has prevented this? maybe, ill look @ that dir and see whats up. thanks! tony -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:00 PM To: CF-Talk Subject: RE: downloading .exe from website Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Isn't that what the 30-day Trial Version is for? Or am I missing something? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
[repost from yesterday, with download link] As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line with wrapping. http://www.barneyb.com/go/cf_exception Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it.If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:35 PM To: CF-Talk Subject: RE: Database error messages Hey Barney can you put them on a web server and give us the URL? This will save you on all the sending stuff. TK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
Tony Weeg said: and what im getting is a 404 error.however pdf's from the same dir, are downloading fine. Undo the changes the IIS Lockdown tool made. IIRC that means removing the mapping from .exe to some 404.dll. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
I have scripts only on that dir. and what im getting is a 404 error. however pdf's from the same dir, are downloading fine. hm? its only .exe's and .pdfs in that dir, no cfm templates. That sounds like the work of IIS Lockdown. Look in your ISAPI extensions for that site and see if there's one mapping .exe to a 404 error page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
its actually not even in the list? what should I map it to? asp.dll? jrun.dll? thanks! tony -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:09 PM To: CF-Talk Subject: RE: downloading .exe from website Tony Weeg said: and what im getting is a 404 error.however pdf's from the same dir, are downloading fine. Undo the changes the IIS Lockdown tool made. IIRC that means removing the mapping from .exe to some 404.dll. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
http compression
Hi, I might have asked this question earlier... But I really, really want to be using gzip/http1.1 compression on all text output from the server (Apache, Solaris, CFMX). It seems like I am unable to use mod_deflate, since jrun kicks in and Apache does not have any control over it. I have seen a few references on the net about using servlet filters for this purpose... Are anyone using that? I guess the only other option is to use a compression proxy (not a very attractive solution). -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
Tony Weeg said: its actually not even in the list? what should I map it to? It shouldn't be mapped at all. Are you sure it is not somewhere in an ISAPI filter? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
under isapi filters, there is only 1, Jrun Connector Filter, and its set to high. that's it. tw -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:17 PM To: CF-Talk Subject: RE: downloading .exe from website Tony Weeg said: its actually not even in the list? what should I map it to? It shouldn't be mapped at all. Are you sure it is not somewhere in an ISAPI filter? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
its actually not even in the list? I'm sure it is somewhere. Within the IIS management console, check the ISAPI extensions for the virtual directory, if there is one, then check for the specific site, then check for the Global Web Site. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
On May 5, 2004, at 9:14 AM, Dave Watts wrote: I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Isn't that what the 30-day Trial Version is for? Or am I missing something? I think he means evaluating CF apps on an ongoing basis -- not evaluating CFMX HTH Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
- Original Message - From: Dave Watts I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Isn't that what the 30-day Trial Version is for? Or am I missing something? That's fine if you're testing everything within that 30-day period. But most of the things I have don't all come up in the same month. And wiping the box and reinstalling everything every 30 days isn't practical. And at least around here, nothing can be really tested in 30 days AND people still work on all the other things we get paid to do. It's usually: install, make sure it runs, send out an email for people to look at it, a couple weeks later enough people have gotten around to looking at it that we can talk about it and decide what to look at more. A real project with a high priority comes up and requires attention and puts off testing for weeks. Repeat for at least 3 months. Heck, just getting a followup meeting for some committees around here doesn't happen within 30 days. Maybe smaller shops that don't have a lot of work to do can get stuff fully evaluated within 30 days, but we sure don't. Lest I come off as whining, I'm not meaning to. I'm just stating the facts of our situation and why it would be nice to have a $50 developer workgroup license or something. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: determine number of records deleted
That will work also, minimizes the query and the math involved in the original solution.Thank you for taking a look cfquery datasource=#mydsn# name=dsn1 select count(*) from mytable where mycity = 'Boston' /cfquery cfquery datasource=#mydsn# delete from mytable where mycity = 'Boston' /cfquery HTH Dick On May 5, 2004, at 8:09 AM, Michael Hodgdon wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
If we're talking about IIS 6.0 then you need to explicitly add a MIME entry for the file extension. This is a new security feature of IIS 6.0. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:28 PM To: CF-Talk Subject: RE: downloading .exe from website its actually not even in the list? I'm sure it is somewhere. Within the IIS management console, check the ISAPI extensions for the virtual directory, if there is one, then check for the specific site, then check for the Global Web Site. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Yes, $50-$100 for a Dev work group version that serves only the current subnet would be really nice.(Not that my office needs it. We got involved in a dot bomb and now we have plenty of extra CF server licenses for Dev servers.) Not that I am trying to defeat MM's single IP dev version, but could you not take a basic home router and plug it in backwards (wan port to the single IP CF server) and thus the router uses only 1 IP address to access the CF server?Then whole network can access the CF server through the router via NAT?I doubt I will ever try this config. Just thinking out loud. I am 100% sure this violates the Dev server licensing or at least the sprit of it. :-) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:25 AM To: CF-Talk Subject: Re: ColdFusion Developer Edition - Original Message - From: Dave Watts I don't know what Bob's needs are, but we regularly want to evaluate a piece of software before even putting it on our test server. Our test server is a mirror of the production server and shouldn't have random evaluation stuff or beta testing software put on it. But the personal Developer license doesn't give our department the ability to actually look at the product being tested without everyone standing over someone's shoulder. Isn't that what the 30-day Trial Version is for? Or am I missing something? That's fine if you're testing everything within that 30-day period. But most of the things I have don't all come up in the same month. And wiping the box and reinstalling everything every 30 days isn't practical. And at least around here, nothing can be really tested in 30 days AND people still work on all the other things we get paid to do. It's usually: install, make sure it runs, send out an email for people to look at it, a couple weeks later enough people have gotten around to looking at it that we can talk about it and decide what to look at more. A real project with a high priority comes up and requires attention and puts off testing for weeks. Repeat for at least 3 months. Heck, just getting a followup meeting for some committees around here doesn't happen within 30 days. Maybe smaller shops that don't have a lot of work to do can get stuff fully evaluated within 30 days, but we sure don't. Lest I come off as whining, I'm not meaning to. I'm just stating the facts of our situation and why it would be nice to have a $50 developer workgroup license or something. -Kevin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax error on Where statement?
Everything works wellnow. Thanks all. Need to date/time any date fields in the future. Sounds elementary, but there's just too much to learn at times. Robert O. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:46 AM To: CF-Talk Subject: Re: Syntax error on Where statement? As Hatton said, changing maint_report_date to a date/time datatype would probably be preferrable.Doing that, the code I gave you should work (assuming that id is an integer). Otherwise, if you're going to leave it as a char field, change the cfsqltype in the first cfqueryparam to cf_sql_char. opt for the former if possible. Charlie - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:23 AM Subject: RE: Syntax error on Where statement? Thanks Charlie. I tried the trim function and it did not help. The maint_report_date column is a char field. Should it be a date/time datatype in order for this to work properly? The code you sent still gives the syntax error. Robert O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
its iis 5.0 and for the life of me I cant figure out why this focker isnt working??? hmmm... let me know if you all think of anything else. thanks! tony -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:45 PM To: CF-Talk Subject: RE: downloading .exe from website If we're talking about IIS 6.0 then you need to explicitly add a MIME entry for the file extension. This is a new security feature of IIS 6.0. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:28 PM To: CF-Talk Subject: RE: downloading .exe from website its actually not even in the list? I'm sure it is somewhere. Within the IIS management console, check the ISAPI extensions for the virtual directory, if there is one, then check for the specific site, then check for the Global Web Site. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Developer Edition
I would love to see the IP restriction increased to say 10 IP's like the dev edition of SQL Server!!! My sons are coming home from college soon and they will be working for me this summer, but it is such a pain to have CF installed on all their systems, when I would rather have them access one dev server. I am actually setting a server with BD 6 hoping it will help, realizing their are differences between BD 6 CFMX. It won't be perfect, but it may be better than multiple installs of CF on their local systems. I may install CFMX on the server too if they absolutely need to test on CFMX, but obviously we will have to restart CFMX for them to take turns accessing CFMX. We've had threads on this before --- Macromedia may want to rethink the Developer Version IP limit in light of what others are doing: New Atlanta Sybase_ASE Microsoft [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Couldn't you put the users behind some kind of firewall/router type of appliance so that when they made requests to the CF server, they would all come from the same IP (the firewall/router)Then you'd only need to enable that one IP address.Any other network gurus feel free to chime in.Or if this is somehow in violation of the license, feel free to chime as well. John -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 1:37 PM To: CF-Talk Subject: Re: ColdFusion Developer Edition I would love to see the IP restriction increased to say 10 IP's like the dev edition of SQL Server!!! My sons are coming home from college soon and they will be working for me this summer, but it is such a pain to have CF installed on all their systems, when I would rather have them access one dev server. I am actually setting a server with BD 6 hoping it will help, realizing their are differences between BD 6 CFMX. It won't be perfect, but it may be better than multiple installs of CF on their local systems. I may install CFMX on the server too if they absolutely need to test on CFMX, but obviously we will have to restart CFMX for them to take turns accessing CFMX. We've had threads on this before --- Macromedia may want to rethink the Developer Version IP limit in light of what others are doing: New Atlanta Sybase_ASE Microsoft [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Or if this is somehow in violation of the license, feel free to chime as well. This would certainly be in violation of the license. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Ok, then I retract my statement.Don't do it.Thanks Dave :-) John -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 1:55 PM To: CF-Talk Subject: RE: ColdFusion Developer Edition Or if this is somehow in violation of the license, feel free to chime as well. This would certainly be in violation of the license. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: File upload max size
has anyone gotten to a max size for this before? I'm having exactly the same problem. Apparently the limit is around 20Meg. The problem seems not to be with CF, nor Internet Explorer : it occurs the same with Netscape. It looks like it's an IIS issue: the server refuses the upload and returns a 404 error. Cannot find the setting of this limit however, if ever there is one. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with ReReplace
I can't seem to get this to work, any ideas? cfset other=\|(|)|{|}|[|] cfset tmp = REReplaceNoCase(tmp,other,,ALL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
add a column in oracle
I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with ReReplace
What do you think this will do? Are you trying to remove all the brackets? Are the | meant to be ORs? If so, this might do it. We build a class out of the puncuation you want to remove. The [] need to be handled seperately since they are special and can't be placed in a class. cfset other=[\(){}] cfset tmp = REReplaceNoCase(tmp,other,,ALL) cfset tmp = ReplaceNoCase(tmp,[,,ALL) cfset tmp = ReplaceNoCase(tmp,],,ALL) I am sure someone smarter will show you a better way. Mr. Doom? Jerry Johnson [EMAIL PROTECTED] 05/05/04 02:07PM I can't seem to get this to work, any ideas? cfset other=\|(|)|{|}|[|] cfset tmp = REReplaceNoCase(tmp,other,,ALL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problem with ReReplace
What are you trying to do? If you're trying to remove all the slashes, parens, brackets and braces, then you'll need to escape those characters, as they have special meaning in regular expressions.Try this one: cfset other = \\|\(|\)|\{|\}|\[|\] / You can also make this a easier by using a character class: cfset other = [\\[\]{}()] / Finally, you don't need the NoCase version, since you're not using letters. Cheers, barneyb -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:07 AM To: CF-Talk Subject: Problem with ReReplace I can't seem to get this to work, any ideas? cfset other=\|(|)|{|}|[|] cfset tmp = REReplaceNoCase(tmp,other,,ALL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: disable back button when using div's
There have been a few forums on this list on diabiling back buttons. For better or worse there is always a way to activiate the back button that you did not know in a specic browser. Ditto the same for the browser's history. Take Joachim's advice on this one (never a bad idea to begin with) and assume that someone will use the back button and trap the error! Here are a few ideas you can consider on the server side: 1) Create a session variable if the person has added a record. When you have finished the process delete the session variable. If someone uses the back button, having the session variable in hand, you can now handle the situation. 2) When inserting data into the database, check to see if the information has been entered correctly into the database. If it has, then stop the database transaction. 3) Surround the transaction with cftry/cfcatch to check if someone is entering the form with the wrong information. If this is the case then someone is accessing the information through the browser's history. Jeremy Hello everybody, I've read a lot about disabling the browser back button when a user submits a form where the action page is different from the submitting page. It is absolutely important that the user is stopped from going back a page because This is an application where authorised users can add new users Ok, here it goes. The super user fills in the new user form and submits the page. On form submission I'm displaying a confimation message. This is displayed inside a div tag. Here, this might help. cfif isDefined(form.hid_adduser) and form.hid_adduser neq !--- code to add the user in the database starts here --- !--- code to add the user in the database ends here --- CFLOCATION URL=""> addtoken=no /cfif cfif isDefined(url.callAdded) body div id=confirmdiv style=z-index:2; position:absolute; left:35px; top:90px; width:650px; display:block cfoutput table border=0 align=center width=355 height=205 tr td valign=bottom div style=position:relative; left:15px; top:1px; class=label Thank you for adding a new user. An email has been sent to the customer to advise. /div /td /tr /table /cfoutput /div /body cfelse body form name=addUserFrm method=post action=""> cfoutputinput type=hidden name=returnto value=#cgi.script_name#?#cgi.query_string#/cfoutput table border=0 cellpadding=0px cellspacing=3px tr tdinput name=newuser type=text/td /tr tr tdinput type=submit name=addUser value=Add User/td /tr /table input type=hidden name=hid_adduser value= /form /body /cfif I want to disable the 'back' button when the user sees the confimation message. Is this possible, if yes can somebody please show me. Best regards, cfcoder __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: downloading .exe from website
URLScan, the ISAPI filter denies extensions of .exe by default. It comes with IIS lockdown == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, May 05, 2004 11:01 AM Subject: RE: downloading .exe from website we ran iis lockdown, which probably has prevented this? maybe, ill look @ that dir and see whats up. thanks! tony -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:00 PM To: CF-Talk Subject: RE: downloading .exe from website Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with ReReplace
What do you think this will do? Are you trying to remove all the brackets? Are the | meant to be ORs? Many thanks, I was trying to remove the brackets and I thought they had to be seperated by |. Your solution works great! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with ReReplace
Glad to hear it.If you are using CFMX, the second response was much better. But I don't think it will work correctly on CF5 or earlier. Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: add a column in oracle
I don't have my big red book handy, but isn't there a restriction in Oracle where you can add columns but not drop them (or vice versa)? -- Howard Fore, [EMAIL PROTECTED] On May 5, 2004, at 2:16 PM, Daniel Kessler wrote: I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: add a column in oracle
As for your other question: SELECT TOP 3 FROM FOO -- Howard Fore, [EMAIL PROTECTED] On May 5, 2004, at 2:16 PM, Daniel Kessler wrote: I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: add a column in oracle
Try putting quotes around the table and column names At 11:16 AM 5/5/04, you wrote: I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:162338This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: add a column in oracle
Sorry, wrong database... SELECT * FROM foo WHERE rownum 4 -- Howard Fore, [EMAIL PROTECTED] On May 5, 2004, at 3:00 PM, Howard Fore wrote: As for your other question: SELECT TOP 3 FROM FOO -- Howard Fore, [EMAIL PROTECTED] On May 5, 2004, at 2:16 PM, Daniel Kessler wrote: I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: add a column in oracle
I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the error about line 4 of the cfm.This is a reference to the text field from the form that contains the above line (alter table...): The error occurred in hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4 2 : BODY 3 : CFQUERY NAME=SQLEXE DATASOURCE=dpch 4 :#sql_statement# 5 : /CFQUERY 6 : BSQL Statement Executed/B 1) Make sure the dpch datasource has ALTER permissions in the MX Administrator (which it does by default, but it may have been changed). 2) Remove the semi-colon after the statment. MX (and I'm assuming JDBC) doesn't like semi-colons in SQL statements in MX. Also, can anyone tell me how to query for just 3 records in Oracle? I know how to do it in mySQL, but... SELECT myColumn FROM ( SELECT myColumn FROM myTable WHERE myCondition = 'foo' ORDER BY myColumn ) WHERE rownum = 3 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
ok.. how to revert back, with that option ok? thanks. tony -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 2:35 PM To: CF-Talk Subject: Re: downloading .exe from website URLScan, the ISAPI filter denies extensions of .exe by default. It comes with IIS lockdown == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, May 05, 2004 11:01 AM Subject: RE: downloading .exe from website we ran iis lockdown, which probably has prevented this? maybe, ill look @ that dir and see whats up. thanks! tony -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:00 PM To: CF-Talk Subject: RE: downloading .exe from website Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading .exe from website
check urlscan.ini usually found somewhere like c:\winnt\system32\inetsvr\urlscan\ it will probably have .exe files as not allowed -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 5, 2004 18:04 To: CF-Talk Subject: RE: downloading .exe from website its iis 5.0 and for the life of me I cant figure out why this focker isnt working??? hmmm... let me know if you all think of anything else. thanks! tony -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:45 PM To: CF-Talk Subject: RE: downloading .exe from website If we're talking about IIS 6.0 then you need to explicitly add a MIME entry for the file extension. This is a new security feature of IIS 6.0. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:28 PM To: CF-Talk Subject: RE: downloading .exe from website its actually not even in the list? I'm sure it is somewhere. Within the IIS management console, check the ISAPI extensions for the virtual directory, if there is one, then check for the specific site, then check for the Global Web Site. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
He3
Hey everyone, Some of you have been working with Matt Liotta's Eclipse plugin for ColdFusion so we thought you'd find this of interest. Gestaltech (my company) and R337 Consulting (Matt's company) have formed a partnership (http://www.richpalette.com) for the construction of a new product, He3, a ColdFusion IDE based upon Eclipse.We're going to be making a beta release of the product at CFUN-04, the big east coast CF conference (http://www.cfconf.org/cfun-04/index.cfm). Sorry for the spam-ish update. rish Guy Rish [EMAIL PROTECTED] Gestaltech, Inc. be more... http://www.gestaltech.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: add a column in oracle
Sorry, wrong database... SELECT * FROM foo WHERE rownum 4 Note that this will not work if you have any sort of ORDER BY clause because Oracle uses the rownum clause before the ORDER BY. This is why I posted the other way of doing SQL Server's version of TOP. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: downloading .exe from website
You would have to modify your URLScan.ini file to allow the .exe extension, but then you open up your server to much nastiness. Better to make it a zip file and instruct the user to rename it before executing. == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, May 05, 2004 2:09 PM Subject: RE: downloading .exe from website ok.. how to revert back, with that option ok? thanks. tony -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 2:35 PM To: CF-Talk Subject: Re: downloading .exe from website URLScan, the ISAPI filter denies extensions of .exe by default. It comes with IIS lockdown == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, May 05, 2004 11:01 AM Subject: RE: downloading .exe from website we ran iis lockdown, which probably has prevented this? maybe, ill look @ that dir and see whats up. thanks! tony -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:00 PM To: CF-Talk Subject: RE: downloading .exe from website Hey Tony, If I recall correctly the Ezest was is to put the .exe in a folder then in IIS turn off all execute permissions for that folder via the IIS admin tab directory MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:52 AM To: CF-Talk Subject: downloading .exe from website hi there. its been a while since I had to rebuild an iis/cfmx server... whats the thing I have to do to make it so that .exe files are downloadable from my server? or is there nothing, and I just need to work on some other problem here? thanks.x ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: One slow server...
Dave Watts wrote: I've also checked the SQL in the SP's that CF calls, and there seems to be nothing wrong there; when I run them in the command line they only take a few seconds to run.However, it takes several minutes for the login to process on the web. I'm at a loss. Anyone got any ideas as to what I could check next? As Jochem suggested, you should check the patch history of the Windows machine. You might also try connecting from other clients on other machines, to see if you can narrow down the cause of the slowdown. You might use ViennaSQL and the MS SQL Server JDBC driver to test. I don't maintain the server myself.I hate working with Windows servers, so I'm quite happy that I don't have to maintain this one.;-) As far as I know, our NT babysitter keeps it up to date. I've tracked the problem down, actually, to a single table in the database which appears to be corrupted.It may have happened during a recent attempt to replicate the table from another database.At any rate, it's moved beyond a CF question to a SQL Server question. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: He3
closed or open beta? -adam -Original Message- From: Guy Rish [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 5, 2004 07:24 PM To: 'CF-Talk' Subject: He3 Hey everyone, Some of you have been working with Matt Liotta's Eclipse plugin for ColdFusion so we thought you'd find this of interest. Gestaltech (my company) and R337 Consulting (Matt's company) have formed a partnership (http://www.richpalette.com) for the construction of a new product, He3, a ColdFusion IDE based upon Eclipse.We're going to be making a beta release of the product at CFUN-04, the big east coast CF conference (http://www.cfconf.org/cfun-04/index.cfm). Sorry for the spam-ish update. rish Guy Rish [EMAIL PROTECTED] Gestaltech, Inc. be more... http://www.gestaltech.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: He3
Adam, We are current intending an open beta. rish -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 3:03 PM To: CF-Talk Subject: Re: He3 closed or open beta? -adam -Original Message- From: Guy Rish [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 5, 2004 07:24 PM To: 'CF-Talk' Subject: He3 Hey everyone, Some of you have been working with Matt Liotta's Eclipse plugin for ColdFusion so we thought you'd find this of interest. Gestaltech (my company) and R337 Consulting (Matt's company) have formed a partnership (http://www.richpalette.com) for the construction of a new product, He3, a ColdFusion IDE based upon Eclipse.We're going to be making a beta release of the product at CFUN-04, the big east coast CF conference (http://www.cfconf.org/cfun-04/index.cfm). Sorry for the spam-ish update. rish Guy Rish [EMAIL PROTECTED] Gestaltech, Inc. be more... http://www.gestaltech.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RESOLVED - FYI : Oracle 9i and cfqueryparam problems
Wow, folks using CF for reporting w/ Oracle DBs should re-evaluate the use of using bind variables. For transactions and the like they are fine but in the case of reporting, bind vars can wreak havoc. The over simplified explanation is that bind variables can inhibit the work of Oracles optimizer in a couple ways. The optimizer ends up using heuristics to generate the best explain plan rather than using information about data distribution. (from stat tables etc) The problems may have been exaggerated in our case considering the sheer volume of data (and DB links) we have...but nonetheless we've seen dramatic improvements in response time after removing all bind variables! (couple minutes down to seconds!) See Oracle technet for additional info! Cheers, Stace From: Stacy Young Sent: Tuesday, May 04, 2004 3:48 PM To: CF-Talk Subject: Oracle 9i and cfqueryparam problems Has anyone had any issue using TIMESTAMP as the datatype for bind variables when using cfmx 6.1 with Oracle 9i? It seems we're getting queries that run for very long periods of time...if we take out the bind variables...query only takes a few seconds! -Stace [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]