Preparing to upgrade from CF5 to CFMX6.1
I have a client who's about to decide to make the leap to the 21st century andupgrade to CFMX6.1 It's a while since I did it, and I've forgotten all the things that broke and/or had to be redone in a better way. is there a preparation checklist anywhere for upgradeing?to check we've upgraded our code to the right standard before we move?That we've taken account of all the gotchas? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: gobbledegook returned from MySQL TEXT fields
Jochem I have sent this very same question to a couple of MySQL.com lists but without response so far.I was slightly hoping that someone might have come across this problem here seeing as it is CF5 which I am trying to get to work with it.I don't know whether it is a configuration issue or a bug or what. At the very least it would be nice to know which is the most recent version of MySQL / MyODBC which works correctly with CF5 on Win2k MySQL claim that a -gamma version is virtually 'production' 'only a matter of weeks from being the GA version' and it would be nice to be able to use 4.1 as it supports features like UNION statements subqueries which are both endemic to my app as it is written ( working) with Access at the moment. Somewhat in desperation I have started a separate thread on this list: 'Now I'm in a fix.Which DB?' Jochem van Dieten wrote: Richard Meredith-Hardy wrote: If I make a simple query on a VARCHAR(less than 255) column then the text is returned. If I do the same on a TEXT, MEDIUMTEXT or LONGTEXT field I get back something like 484954434F554E43D31234C4153 This is on Win2k Server SP4 / MySQL 4.1.4-gamma / MyODBC 3.51.090 The only way I can see the proper contents is in the field viewer in MySQL query browser, everything else returns the above; I am interested to get it to work in CF5. Wouldn't a MySQL list be better suited for questions about a beta product from MySQL? Especially if all clients except MySQL query browser have this problem (which suggests that actually MySQL query browser hase the problem). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Now I'm in a fix. Which DB?
Dear all I should have asked this question before I got to this stage: Intranet; Win2k / CF5 Which DB should I use? Background: I've an intranet which has been working on Win2k / CF5 / Access just fine for the last couple of years.About 6 months ago I warned the big chiefs that the DB was beginning to get rather large and it was a good idea to consider moving to a proper DB for all the good reasons discussed here and elsewhere many times. M$ SQL server was the obvious choice but when they looked into it they got a big fright on the licensing costs; something around 15 - 20,000 GBP apparently.(some 200 clients use this intranet). I did a brief test of MySQL on my dev server - all too brief as it turns out -and it looked OK so Why not use MySQL? says I, commercial licence is 500 Euros, unlimited clients, and the new version supports all the 'advanced' features you need. Last week at a meeting with all the bigwigs it was agreed. So what happens?I've got a really intractible problem where text fields longer than 255 aren't being returned properly.Whether it's an ODBC problem, a DB problem or a simple configuration problem I don't know, I'm trying to find out, but at the moment my conversion has fallen over at the first hurdle as client vars in CDATA.DATA aren't being returned properly. This is MySQL 4.1I expect I could go to an earlier version, but this new version supports transactions, subqueries and UNION statements, and this intranet app is stuffed full of all of them.It would be a hell of a job to undo all that -- Regards; Richard Meredith-Hardy - r.mh[at]flymicro.com Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
Get this one: http://www.microsoft.com/sql/msde/downloads/download.asp Basicly mssql without the licensing cost (and without some management tools) You can use access as the frontend with this one and upgrading your access db to sql is mostly painless - Original Message - From: Richard Meredith-Hardy To: CF-Talk Sent: Monday, September 13, 2004 10:16 AM Subject: Now I'm in a fix. Which DB? Dear all I should have asked this question before I got to this stage: Intranet; Win2k / CF5 Which DB should I use? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
don't forget you can use the normal SQL admin console to admin MSDE jb. On Mon, 13 Sep 2004 10:24:38 +0200, Dirk De Bock - Listclient [EMAIL PROTECTED] wrote: Get this one: http://www.microsoft.com/sql/msde/downloads/download.asp Basicly mssql without the licensing cost (and without some management tools) You can use access as the frontend with this one and upgrading your access db to sql is mostly painless - Original Message - From: Richard Meredith-Hardy To: CF-Talk Sent: Monday, September 13, 2004 10:16 AM Subject: Now I'm in a fix. Which DB? Dear all I should have asked this question before I got to this stage: Intranet; Win2k / CF5 Which DB should I use? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Preparing to upgrade from CF5 to CFMX6.1
Hi i had prepared a migration guidlines doucment andchecklist document if u want send me a mail offlist to [EMAIL PROTECTED] regards vishnu Prasad I have a client who's about to decide to make the leap to the 21st century andupgrade to CFMX6.1 It's a while since I did it, and I've forgotten all the things that broke and/or had to be redone in a better way. is there a preparation checklist anywhere for upgradeing?to check we've upgraded our code to the right standard before we move?That we've taken account of all the gotchas? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
OK... interesting.A couple of questions: I had a look and about the only significant limitation seems to be the 2Gb max size.Whilst I don't expect the current DB will be even a 100th of this I will have to give my clients some sort of idea of longevity. Is there any correlation between a compacted .mdb file size and when the same data is put in MSDE? I have ordinary SQL server enterprise edition running on my dev server for other apps I look after.Will MSDE run alongside it on the same box happily enough?For dev purposes can I get to either thru Enterprise manager? John Beynon wrote: don't forget you can use the normal SQL admin console to admin MSDE jb. On Mon, 13 Sep 2004 10:24:38 +0200, Dirk De Bock - Listclient [EMAIL PROTECTED] wrote: Get this one: http://www.microsoft.com/sql/msde/downloads/download.asp Basicly mssql without the licensing cost (and without some management tools) You can use access as the frontend with this one and upgrading your access db to sql is mostly painless - Original Message - From: Richard Meredith-Hardy To: CF-Talk Sent: Monday, September 13, 2004 10:16 AM Subject: Now I'm in a fix. Which DB? Dear all I should have asked this question before I got to this stage: Intranet; Win2k / CF5 Which DB should I use? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF J2SE 1.5.0 Release Candidate
Has anyone tried to run CFMX on the new J2SE 1.5.0 RC java server, to replace the 1.4.2 Java VM that comes with CFMX? http://java.sun.com/j2se/1.5.0/docs/relnotes/features.html I'm running a server install rather than a Jrun install, so I'd be interested to know if there are any performance improvements. Ta. Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
I had a look and about the only significant limitation seems to be the 2Gb max size.Whilst I don't expect the current DB will be even a 100th the amount of concurrent users are also throttled. of this I will have to give my clients some sort of idea of longevity. if the db grows bigger than swap to real sql server. same db will work w/it, just install new engine. Is there any correlation between a compacted .mdb file size and when the same data is put in MSDE? absolutely not. happily enough?For dev purposes can I get to either thru Enterprise manager? you can certainly use em w/msde though i'm not sure of licensing issues, though if you already own enterprise i guess it might not matter. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Now I'm in a fix. Which DB?
So is there any reason to use Access anymore? Ade -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 11:09 To: CF-Talk Subject: Re: Now I'm in a fix. Which DB? I had a look and about the only significant limitation seems to be the 2Gb max size.Whilst I don't expect the current DB will be even a 100th the amount of concurrent users are also throttled. of this I will have to give my clients some sort of idea of longevity. if the db grows bigger than swap to real sql server. same db will work w/it, just install new engine. Is there any correlation between a compacted .mdb file size and when the same data is put in MSDE? absolutely not. happily enough?For dev purposes can I get to either thru Enterprise manager? you can certainly use em w/msde though i'm not sure of licensing issues, though if you already own enterprise i guess it might not matter. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
So is there any reason to use Access anymore? to my mind, there never was a reason to use it in the first place. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF J2SE 1.5.0 Release Candidate
I'm running a server install rather than a Jrun install, so I'd be interested to know if there are any performance improvements. not that we noticed. we did get that warm fuzzy feeling you get at the bleeding edge though ;-) it did add a class or two we've found some use for. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
Paul the amount of concurrent users are also throttled. Max 25 it says.With 200 - 300 intranet users I don't think this would be an issue, would it? I haven't got any stats but it's not exactly as if they're hitting it all day long, its primary use is calendar timesheets (client is a publishing house and has half macs half PC's which is why they need it at all). Paul Hastings wrote: I had a look and about the only significant limitation seems to be the 2Gb max size.Whilst I don't expect the current DB will be even a 100th the amount of concurrent users are also throttled. of this I will have to give my clients some sort of idea of longevity. if the db grows bigger than swap to real sql server. same db will work w/it, just install new engine. Is there any correlation between a compacted .mdb file size and when the same data is put in MSDE? absolutely not. happily enough?For dev purposes can I get to either thru Enterprise manager? you can certainly use em w/msde though i'm not sure of licensing issues, though if you already own enterprise i guess it might not matter. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
Richard Meredith-Hardy wrote: Max 25 it says.With 200 - 300 intranet users I don't think this would be an issue, would it? If ColdFusion is the only client connecting to it, there won't be more concurrent users as there are concurrent requests in the CF administrator. IIRC that defaults to 6, so you could connect 4 CF servers to it and still have one left for Enterprise Manager :) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: gobbledegook returned from MySQL TEXT fields
Interesting to hear about your date problem too.Sounds like I could have a bit of a nightmare converting this app to MySQL- there are a whole lot of rather complicated calendar queries in it... You might be ok SELECT DateField, AnotherField FROMSomeTable Worked fine with no problems at all. SELECTDateField, count(AnotherField) FROMSomeTable GROUP BY DateField This was where it started going wrong and needed casting to a char type instead of a date.So long as you don't group on the date field you should be ok. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: gobbledegook returned from MySQL TEXT fields
This was where it started going wrong and needed casting to a char type instead of a date.So long as you don't group on the date field you should be ok. This seems to be an issue with MySQL - it also appears sometimes when you use the MySQL date functions.For some reason the query returns binary info instead of the usual text.You can just use toString(myQuery.binField) to get the proper value. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Now I'm in a fix. Which DB?
More so now? -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 11:21 To: CF-Talk Subject: Re: Now I'm in a fix. Which DB? So is there any reason to use Access anymore? to my mind, there never was a reason to use it in the first place. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfexecute mysqldump sh
hi im trying to dump a database on the fly w/ cfexecute on redhat cfexecute name='mysqldump' arguments='mydatabase /path/to/save/dump' outputfile='/path/to/save/results' /cfexecute but this only returns -- MySQL dump 9.11 -- -- Host: localhost Database: unrivaled -- -- Server version 4.0.20-standard there should be all of the create table junk. if i run the script from the command line #mysqldump mydatabase /path/to/save/dump it does what i want. any suggestions?? i also thought about creating a shell script .. but this returned the same results. should i do something to the script? i even tried adding su root - joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Help with Custom Error Messages
I would like to display a custom error when a user's session expires? Any suggestions? Cancferrorbe used for this? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with Custom Error Messages
maybe cfabort [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with Custom Error Messages
To display a custom error message? -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 8:10 AM To: CF-Talk Subject: Re: Help with Custom Error Messages maybe cfabort _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: gobbledegook returned from MySQL TEXT fields
Do you suppose this is a MyODBC issue or something deeper? CFMX uses the Java connect thingy doesn't it?Do you know if the same thing happens with that? Tim Blair wrote: This was where it started going wrong and needed casting to a char type instead of a date.So long as you don't group on the date field you should be ok. This seems to be an issue with MySQL - it also appears sometimes when you use the MySQL date functions.For some reason the query returns binary info instead of the usual text.You can just use toString(myQuery.binField) to get the proper value. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with Custom Error Messages
your best bet is to to test for something like session.isloggedin (or some variable you've set when a user logs in) in your application.cfm and then redirect if it doesn't exist, ie it's timed out, jb. On Mon, 13 Sep 2004 08:10:48 -0400, Monique Boea [EMAIL PROTECTED] wrote: To display a custom error message? -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 8:10 AM To: CF-Talk Subject: Re: Help with Custom Error Messages maybe cfabort _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
As I said earlier - I should have consulted this list first MSDE would probably do the job for the forseeable future, and that's for free (M$ 'free' ...? can't quite believe it...) with the option of a $4,600 upgrade if MSDE runs into problems.This probably wouldn't have been too difficult if it wasn't for the fact that in my ignorance I've already sung the praises of MySQL and pursuaded the big cheeses they can get the job done for 500 Euros under MySQL commercial licence. I have now got some info on workarounds for my problems with MySQL but when people tell you in that condition -sometimes- this happens it all seems a bit flaky - Somehow I feel I am shortly going to have to do some super-diplomatic back-paddling Adam Churvis wrote: M$ SQL server was the obvious choice but when they looked into it they got a big fright on the licensing costs; something around 15 - 20,000 GBP apparently.(some 200 clients use this intranet). You can pick up a 1 CPU license to the Standard Edition for under $4,600 from Buy.com. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Now I'm in a fix. Which DB?
Wait...wait... wait when MS/SQL Server Team say 25 concurrent clients and we're running only CF to access that stored data in MSDE DB will have only 1 client connection(CF ODBC/JDBC connection)? Mistake? Cheers Richard Meredith-Hardy wrote: Max 25 it says.With 200 - 300 intranet users I don't think this would be an issue, would it? If ColdFusion is the only client connecting to it, there won't be more concurrent users as there are concurrent requests in the CF administrator. IIRC that defaults to 6, so you could connect 4 CF servers to it and still have one left for Enterprise Manager :) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Bad Radio Button
Turns out my problem stemmed from using deprecated values for checked. I used checked = yes, when it's supposed to be just checked or nothing at all. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee.Any other person is strictly prohibited from disclosing, distributing or reproducing it.If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies.Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Flash
I am now developing a flash client.Anyone know of a good list to post Flash questions? Thanks, -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
disallowing usage of DSNs
All, The CF web server that I run has various users who also have their own individual web spaces on it. How do I disable or disallow usage of the CF DSNs by these users? Is this even possible? If not, any semantic separation that I can/could have enforced? Thanks, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF-Talk: Digest every hour
Could you please send me the migration document also. I have a client and am in the same position. Please send it off list to [EMAIL PROTECTED] Thank you. Matt -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 7:01 AM To: CF-Talk Subject: CF-Talk: Digest every hour CF-Talk 13-Sep-04 Issue:12714 In this issue: Preparing to upgrade from CF5 to CFMX6.1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with Custom Error Messages
Yes, you should beable to use cfthrow type=myExeptionType (with a custom exception type) and then use cferror type=exception exception=myExeptionType template=myErrorTemplate.cfm Pascal -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 14:02 To: CF-Talk Subject: [Spam?] Help with Custom Error Messages I would like to display a custom error when a user's session expires? Any suggestions? Cancferrorbe used for this? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Flash
Hey Troy, Head on over to http://chattyfig.figleaf.com and sign up for FlashCoders. Cheers, Joe - Original Message - From: Troy Simpson [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 09:23:46 -0400 Subject: Flash To: CF-Talk [EMAIL PROTECTED] I am now developing a flash client.Anyone know of a good list to post Flash questions? Thanks, -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: disallowing usage of DSNs
George, One way would be to have the DSNs run under DSN-specific users on the DB server, with the user for the given DSN only having access to certain databases. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the procedure definition by entering the DESC command at the SQL*Plus prompt.For example;DESC schema_name.package_name; The DESC will not show you the code inside the package but it will show you what each procedure expects for parameters. HTH. Janet. At 05:01 PM 9/10/2004 -0400, you wrote: I do not have the package unfortunately. -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 12:49 PM To: CF-Talk Subject: Re: Oracle Stored Procedures What does the package specification for TESTPCKG look like? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dreamweaver MX 2004 / MacOSX site type selector bug?
As mentioned before, Dreamweaver lets you keep settings for a test server for working with a development server and a live server.Neat idea, the only problem is that it doesn't work for me on OSX.At least 95% of the time when I change between the live and test servers it gives me an error saying An FTP error occurred - cannot get remote folder information.However, if I leave that server type selected, go to the site configuration window and then back to the server pane, it works every time.This suggests to me that it is Dreamweaver acting up rather than my server or configuration. Has anyone else seen this? Personally I wish that the selector didn't have four options (local, remote, test, map) but there was a single option to switch between development and production. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: disallowing usage of DSNs
The CF web server that I run has various users who also have their own individual web spaces on it. How do I disable or disallow usage of the CF DSNs by these users? Is this even possible? If not, any semantic separation that I can/could have enforced? Yes, what you want to do is possible, although we'd need more specifics about your system to tell you the best approach. If you're using IIS or Apache, for example, you could disallow usage of CF for these web spaces entirely. Alternatively, if you're using CFMX Enterprise, you could use sandbox security. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
missing values in attributes scope
I am getting an error when linking to a page with the following query cfquery name=get_itemtitle datasource=#request.dsn# maxrows=1 SELECT * FROM items WHERE itemid = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#attributes.itemid# /cfquery the url I use to link to this page is /index.cfm?fuseaction=nonsitepage.displayitemid=1577preview=true the error occurs sometimes when the page firsts loads with the following error Invalid data '' for CFSQLTYPE 'CF_SQL_INTEGER'. whereas when you refresh again and again it always works any thoughts on why this might be? thanks in advance [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Update a field
I'm trying to manually update an entry in a database (ORACLE) so that I can insert a number into it'd ID field. update whats_new set id = 2 where header = 'Dr. Catherine Ennis Wins McKenzie Award' I'm getting SQL Command Not Properly Ended.This works fine if I remove the WHERE line, but the reason that I'm giving it an id is that the header is too inexact an identifier. So any thoughts on how to get this working?I tried adding some semi-colons, but it didn't work. -- 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] [Donations and Support]
RE: Now I'm in a fix. Which DB?
I have ordinary SQL server enterprise edition running on my dev server for other apps I look after. Will MSDE run alongside it on the same box happily enough? I'm a bit confused. If you already have SQL Server Enterprise Edition installed on a machine, why would you want to install MSDE on that same machine? Why not just use the (presumably licensed) copy of SQL Server instead? You will probably have some issues getting MSDE to coexist with an existing SQL Server installation, actually, as they're both essentially the same thing. If you installed SQL Server using named instances, MSDE will probably install ok, although I can't guarantee it since I've never tried it myself. If you installed SQL Server using a default instance, I doubt you can easily install MSDE unless you can install it as a named instance. I don't know enough about MSDE installation to know whether it can be customized enough to make that work. Even if you could get them both running, I'm not sure what that buys you, though. For dev purposes can I get to either thru Enterprise manager? Yes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Updater Installation error
Restarting with the services on manual did the trick.I installed before starting them and it is now upgraded.I didn't see Dirk's comments before trying Dave's suggestion so that may have worked also. Thanks for your help. On Sat, 11 Sep 2004 10:08:43 -0400, Dave Watts [EMAIL PROTECTED] wrote: I do stop all 3 services when instructed to do so.Once I even stopped them before I started any part of the installation.Is that what you mean? Yes, that's what I meant, but since that didn't solve your problem I'd recommend that you set the CF service not to automatically start, reboot your computer, and try again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: missing values in attributes scope
I am getting an error when linking to a page with the following query /index.cfm?fuseaction=nonsitepage.displayitemid=1577preview=true Invalid data '' for CFSQLTYPE 'CF_SQL_INTEGER'. I would do a couple things: 1.) cfparam all your variables so you know they exist. Only use them if their values are of the type expected. Handle the flipside accordingly. 2.) trim your variables. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: gobbledegook returned from MySQL TEXT fields
Do you suppose this is a MyODBC issue or something deeper? No, we develop/host on Linux and have the same issue. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DISTINCT alternative
I have seprate table to stats. When any dealer create the Ad, a field inserted in table for reporting. that table have id, created, dealerid, name, template I need to create a bar graph and show the report. I don't wanna run the query too many times. is there any way that I just run the query once and it tell me which dealer have how many enteries in table? thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DISTINCT alternative
I have seprate table to stats. When any dealer create the Ad, a field inserted in table for reporting. that table have id, created, dealerid, name, template I need to create a bar graph and show the report. I don't wanna run the query too many times. is there any way that I just run the query once and it tell me which dealer have how many enteries in table? thanks select dealderid, count(id) as adcount from mytable group by dealerid Of course, you'll probably want to join that to the table containing your dealer information, but that's the direction you want to head s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DISTINCT alternative
table layout, and a little better explanation? On Mon, 13 Sep 2004 11:03:57 -0400, Asim Manzur [EMAIL PROTECTED] wrote: I have seprate table to stats. When any dealer create the Ad, a field inserted in table for reporting. that table have id, created, dealerid, name, template I need to create a bar graph and show the report. I don't wanna run the query too many times. is there any way that I just run the query once and it tell me which dealer have how many enteries in table? thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: disallowing usage of DSNs
Joe, I do run the various DSNs under db-specific usernames. So they have only access to the databases that they need access to. But this does not stop users from using other DSNs. Dave, I am running CFMX Standard on a Win2K IIS server. I cannot disallow usage of CF from these webspaces, since they do want to use some DSNs specifically created for them. George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: pulling header response variables
All, I am being forced to develop a small module application on my site outside of my normal environment, meaning that I cannot use ColdFusion.(shudder) I am interacting with a plug-in on this other server that includes certain information that I need in the header variables.If I use ColdFusion (which I can only use in development and will not work on the staging and production areas--again, shudder), I can see the variables I need very clearly listed when I do a dump of the CGI variables (CFDUMP var=#CGI#). As I understand it, these are variables that the HTTP server sends back in the header of the page along with the rest of the data in the page.My thinking, perhaps naive, is that this data should be available to the client browser. So, since I can't use CF, I have to use something else.I am getting the sinking feeling that client-side _javascript_ is not an option, although I am still confused as to why this data would not be available to client-side _javascript_. Bottom line: I am looking for another technology to use, but I don't know which way to go.I don't know CGI/Perl, ASP, or client-side _javascript_, so I'll have to study to get this set up.Before I go doing such a thing, I'd like to know that I am at least in the right ballpark. Does anyone have any suggestions for how to deal with this cold, heartless, non-ColdFusion world? Thanks, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Janet, Thanks for the tip! PROCEDURE TESTPCKG Argument NameTypeIN/OUT Default? CURRETURNSETREF CURSOROUT -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 9:23 AM To: CF-Talk Subject: RE: Oracle Stored Procedures In SQL*Plus, you can see the package specification and hence the procedure definition by entering the DESC command at the SQL*Plus prompt.For example;DESC schema_name.package_name; The DESC will not show you the code inside the package but it will show you what each procedure expects for parameters. HTH. Janet. At 05:01 PM 9/10/2004 -0400, you wrote: I do not have the package unfortunately. -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 12:49 PM To: CF-Talk Subject: Re: Oracle Stored Procedures What does the package specification for TESTPCKG look like? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DISTINCT alternative
If I understand correctly the following should do it. SELECTdealerid, count(dealerid) AS Instances FROMyourtable GROUP BY dealerid If you don't want to run the query to often use cachewithin in the query parameters like cfquery name=somequery datasource=mydsn cachewithin=0.25 0.25 is 6 hours but you can change that value to anything you like or use a createtimespan() if you prefer. -- Jay -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 16:04 To: CF-Talk Subject: DISTINCT alternative I have seprate table to stats. When any dealer create the Ad, a field inserted in table for reporting. that table have id, created, dealerid, name, template I need to create a bar graph and show the report. I don't wanna run the query too many times. is there any way that I just run the query once and it tell me which dealer have how many enteries in table? thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DISTINCT alternative
Thanks works great, the below is the code, Now I can join query topull data in more detail. cfquery name=stats datasource=#DSN# select dealer, count(id) as adcount from dealerAds group by dealer /cfquery cfdump var=#stats# cfchart format=Flash title=Stats Report xaxistitle=Dealers yaxistitle=Ads created chartheight=500 chartwidth=600 showlegend=yes labelformat=number cfchartseries type=bar query=stats itemcolumn=dealer valuecolumn=adcount/cfchartseries /cfchart table layout, and a little better explanation? On Mon, 13 Sep 2004 11:03:57 -0400, Asim Manzur [EMAIL PROTECTED] wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT. -Adam - Original Message - From: Scott Mulholland [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 11:12:19 -0400 Subject: RE: Oracle Stored Procedures To: CF-Talk [EMAIL PROTECTED] Janet, Thanks for the tip! PROCEDURE TESTPCKG Argument NameTypeIN/OUT Default? CURRETURNSETREF CURSOROUT -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 9:23 AM To: CF-Talk Subject: RE: Oracle Stored Procedures In SQL*Plus, you can see the package specification and hence the procedure definition by entering the DESC command at the SQL*Plus prompt.For example;DESC schema_name.package_name; The DESC will not show you the code inside the package but it will show you what each procedure expects for parameters. HTH. Janet. At 05:01 PM 9/10/2004 -0400, you wrote: I do not have the package unfortunately. -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 12:49 PM To: CF-Talk Subject: Re: Oracle Stored Procedures What does the package specification for TESTPCKG look like? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cldap modifying
I'm trying to use CFLDAP to modify and change the AD. I've used action="" and also action="" but I've run into a problem trying to change a field to be empty. The specific field I'm trying to change at the moment is Description, but it does this with any field. The error message I get is below. An error has occured while trying to execute modify :[LDAP: error code 19 - 2081: AtrErr: DSID-031D0809, #1: 0: 2081: DSID-031D0809, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att d (description) ]. My cfldap query is below, based off form values entered. The DN and everything is based off a previous form. cfldap server=serverIP port=389 username=adminUser password=password action=""> !---what it is now--- dn=#form.DN# !---what it should be changed to--- attributes=description=#form.description#;scriptPath=#form.scriptPath# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: disallowing usage of DSNs
I do run the various DSNs under db-specific usernames. So they have only access to the databases that they need access to. But this does not stop users from using other DSNs. You could perhaps use the USERNAME and PASSWORD attributes for those DSNs, rather than entering the values within the CF Administrator. I am running CFMX Standard on a Win2K IIS server. I cannot disallow usage of CF from these webspaces, since they do want to use some DSNs specifically created for them. Well, one of the reasons that you pay more for CFMX Enterprise is so that you can use security sandboxes. That would probably be the best solution in this case, except for having to pay to upgrade. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Form Filling w/ activePDF Toolkit
Robert, I am in the midst of doing this same thing for EPA.Could you also send me the sample code using Coldfusion? Thanks much, Chris - Original Message - From: Yexley Robert D Contr AFRL/PROE [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 15:09:52 -0400 Subject: RE: Form Filling w/ activePDF Toolkit To: CF-Talk [EMAIL PROTECTED] I have some samples of some code that I've used successfully with it. I don't think I can include attachments to messages to the list, so I'll send it to you directly. .YEX. -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 2:53 PM To: CF-Talk Subject: Form Filling w/ activePDF Toolkit Does anybody have some sample code on how to do form filling using cf sql? I tried to email them but they said the only had asp samples. Thanks, Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Form Filling w/ activePDF Toolkit
I was able to get this to work.. cfset vendor=ABC cfset address1=123 Main cfset address2=Suite A cfset phone=(949)862-6231 cfset email=[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfset web=www.asdf.com http://www.asdf.com CFOBJECT ACTION=""> TYPE=COM CLASS=APToolkit.Object NAME=TK CFSET pdfpath = ExpandPath(test2.pdf) CFSET r = TK.OpenOutputFile(#pdfpath#) CFSET r = TK.OpenInputFile(ExpandPath(test.pdf)) CFSET TK.SetFormFieldData(vendor,#vendor#,-998) CFSET TK.SetFormFieldData(address1,#address1#,-998) CFSET TK.SetFormFieldData(address2,#address2#,-998) CFSET TK.SetFormFieldData(phone,#phone#,-998) CFSET TK.SetFormFieldData(email,#email#,-998) CFSET TK.SetFormFieldData(web,#web#,-998) CFSET r = TK.CopyForm(0,0) CFSET TK.CloseOutputFile() CFOUTPUT HTML BODY TOPMARGIN=0 LEFTMARGIN=0 SCROLL=no iframe height=550 width=100% src=""> http://indev/CFExamples/test2.pdf align=top/iframe /BODY /HTML /CFOUTPUT -Original Message- From: Chris Tilley [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 8:50 AM To: CF-Talk Subject: Re: Form Filling w/ activePDF Toolkit Robert, I am in the midst of doing this same thing for EPA.Could you also send me the sample code using Coldfusion? Thanks much, Chris - Original Message - From: Yexley Robert D Contr AFRL/PROE [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 15:09:52 -0400 Subject: RE: Form Filling w/ activePDF Toolkit To: CF-Talk [EMAIL PROTECTED] I have some samples of some code that I've used successfully with it. I don't think I can include attachments to messages to the list, so I'll send it to you directly. .YEX. -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 2:53 PM To: CF-Talk Subject: Form Filling w/ activePDF Toolkit Does anybody have some sample code on how to do form filling using cf sql? I tried to email them but they said the only had asp samples. Thanks, Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
FW: Job in UK
Sent on behalf of the employer - Do not reply to me pls Required, full-time junior ColdFusion developer local to Hillsea/Portsmouth in the UK. This is a fairly junior position, so you don't need to be a coldfusion guru. Main requires are are ColdFusion5 with Transact SQL(ability to write complex inner/outer joins for SQL server), DHTML/_javascript_, with the ability to work on existing projects and understand/adapt other developers code. The job will be primarily remote working from home for one of our clients in portsmouth with some onsite work when required. Occasional requirements to visit head office in Berkshire. for more details Contact : Russ Michaels (russ.michaels @ satachi.com) Tel: 0870 747 3709 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cldap modifying
Not sure if this is exactly related to your problem, but it's close. http://support.microsoft.com/default.aspx?scid=kb;en-us;286760 http://support.microsoft.com/default.aspx?scid=kb;en-us;286760Product=win2 000 Product=win2000 -Original Message- From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 9:44 AM To: CF-Talk Subject: cldap modifying I'm trying to use CFLDAP to modify and change the AD. I've used action="" and also action="" but I've run into a problem trying to change a field to be empty. The specific field I'm trying to change at the moment is Description, but it does this with any field. The error message I get is below. An error has occured while trying to execute modify :[LDAP: error code 19 - 2081: AtrErr: DSID-031D0809, #1: 0: 2081: DSID-031D0809, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att d (description) ]. My cfldap query is below, based off form values entered. The DN and everything is based off a previous form. cfldap server=serverIP port=389 username=adminUser password=password action=""> !---what it is now--- dn=#form.DN# !---what it should be changed to--- attributes=description=#form.description#;scriptPath=#form.scriptPath# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Form Filling w/ activePDF Toolkit
I've had a number of requests for this sample code, and haven't been able to keep up with the responses to all of the requests (sorry to anyone who I've missed so far), so to make it easier for anyone that would like to see this sample code, I've made it available at the link below for anyone interested in looking at it. I figured this would be the easiest way to handle it. Feel free to discuss it further here, I'd be happy to answer any questions anyone might have about it. I'm also open to any constructive criticism about my code too (I'm a fairly noob CF'er, so I'm sure there are things I could be doing better). http://yexley.net/bob/code/cdrlreport.txt http://yexley.net/bob/code/cdrlreport.txt .YEX. -Original Message- From: Chris Tilley [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 11:50 AM To: CF-Talk Subject: Re: Form Filling w/ activePDF Toolkit Robert, I am in the midst of doing this same thing for EPA.Could you also send me the sample code using Coldfusion? Thanks much, Chris - Original Message - From: Yexley Robert D Contr AFRL/PROE [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 15:09:52 -0400 Subject: RE: Form Filling w/ activePDF Toolkit To: CF-Talk [EMAIL PROTECTED] I have some samples of some code that I've used successfully with it. I don't think I can include attachments to messages to the list, so I'll send it to you directly. .YEX. -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 2:53 PM To: CF-Talk Subject: Form Filling w/ activePDF Toolkit Does anybody have some sample code on how to do form filling using cf sql? I tried to email them but they said the only had asp samples. Thanks, Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFLDAP (used for AD permissions?)
hello everyone, hope ur monday is/did go well...mine is ok...for a monday... anyway, can someone just verify for me that cfldap will work with win2k3 active directory usernames/password authentication for a dir on my cfmx server? if not, and ive dreamed this one up, please pass the dutchy...and put me back to sleep... thanks. -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cldap modifying
Brian, My CFLDAP wiz tells me that you need to identify your separator. I'm not sure that is the problem, but give it a shot. See the example below: cfldap action="" DN=#ListName# attributes=member=#memberID# separator=$ modifytype=REPLACE server=your.server.nameOrIP port=389 username=adminUser password=xx Bob I'm trying to use CFLDAP to modify and change the AD. I've used action="" and also action="" but I've run into a problem trying to change a field to be empty. The specific field I'm trying to change at the moment is Description, but it does this with any field. The error message I get is below. An error has occured while trying to execute modify :[LDAP: error code 19 - 2081: AtrErr: DSID-031D0809, #1: 0: 2081: DSID-031D0809, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att d (description) ]. My cfldap query is below, based off form values entered. The DN and everything is based off a previous form. cfldap server=serverIP port=389 username=adminUser password=password action=""> !---what it is now--- dn=#form.DN# !---what it should be changed to--- attributes=description=#form.description#;scriptPath=#form.scriptPath# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Incorporating Javascript to confirm into a document...
I've been working on this all morning and I am missing something. I have a delete button on a page and I want a _javascript_ Confirm box to pop up. I am trying to assign a variable in the _javascript_ and then Test that script in my CFIF. This works fine until I add the confirmation box. I declare the variable CFPARAM NAME=confirm_delete_presentation Default=false Here is my _javascript_ function delete_presentation() { confirm_delete_presentation= confirm(Do you really want to delete this presentation??); } Here is my CFIF CFIF IsDefined(form.delete.x) and badFlags EQ and confirm_delete_presentation EQ true -- Script to do the deleting /CFIF and finally my button INPUT TYPE=image NAME=delete SRC="" ALT=Delete Presentation > Any hints? Thanks! Brett [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
HTTPS post
Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs? Does this make sense? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Installing CFMX 6.1 w/IIS6 Win2003
Are there any specific CFMX 6.1 issues related to IIS6.0? When I try to view any cfm pages I get the following error msg: HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource. Internet Information Services (IIS) I'm not very familiar with using a IIS6/win2003 setup. Thanks, Dave HTC Disclaimer:The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Looks to me like you're trying to mix _javascript_ and server side coding. Can't do that. You could make the delete button a form submit button, using _javascript_, then on the form handler page, test your cfif block, delete whatever, then cflocation yourself back to the original page... Ray I've been working on this all morning and I am missing something. I have a delete button on a page and I want a _javascript_ Confirm box to pop up. I am trying to assign a variable in the _javascript_ and then Test that script in my CFIF. This works fine until I add the confirmation box. I declare the variable CFPARAM NAME=confirm_delete_presentation Default=false Here is my _javascript_ function delete_presentation() { confirm_delete_presentation= confirm(Do you really want to delete this presentation??); } Here is my CFIF CFIF IsDefined(form.delete.x) and badFlags EQ and confirm_delete_presentation EQ true -- Script to do the deleting /CFIF and finally my button INPUT TYPE=image NAME=delete SRC="" ALT=Delete Presentation > Any hints? Thanks! Brett [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Now I'm in a fix. Which DB?
Ditto _ From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 11:21 To: CF-Talk Subject: Re: Now I'm in a fix. Which DB? So is there any reason to use Access anymore? to my mind, there never was a reason to use it in the first place. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Now I'm in a fix. Which DB?
Yes, this is correct, you can easily use MSDE to host an up BUT there are some limitations (well at least there used to be...) MSDE will -- 1. Support up to 2Gb RAM. 2. 2GB database size limit - this can restrictive if you have a text datatype heavy DB 3. Supports up to 2 CPU on Windows NT or Windows 2000 box. 4. Has No publishing for transaction replication. 5. No Database Server Failover Support. 6. No Full-text search. 7. No OLAP. 8. No English Query. 9.No SQL Books Online. Some of these may not be true now but they certainly used to be... From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 13:34 To: CF-Talk Subject: Now I'm in a fix. Which DB? Wait...wait... wait when MS/SQL Server Team say 25 concurrent clients and we're running only CF to access that stored data in MSDE DB will have only 1 client connection(CF ODBC/JDBC connection)? Mistake? Cheers Richard Meredith-Hardy wrote: Max 25 it says. With 200 - 300 intranet users I don't think this would be an issue, would it? If ColdFusion is the only client connecting to it, there won't be more concurrent users as there are concurrent requests in the CF administrator. IIRC that defaults to 6, so you could connect 4 CF servers to it and still have one left for Enterprise Manager :) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: missing values in attributes scope
I am getting an error when linking to a page with the following query /index.cfm?fuseaction=nonsitepage.displayitemid=1577preview=true Invalid data '' for CFSQLTYPE 'CF_SQL_INTEGER'. I would do a couple things: 1.) cfparam all your variables so you know they exist. Only use them if their values are of the type expected. Handle the flipside accordingly. 2.) trim your variables. Mike yes, but how do I get around the problem that the variable is there in the url but is not being traced through to attributes.itemid [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: missing values in attributes scope
Does it exist in both the form and url scopes? What do you have the FB core files set to in terms of form or URL precendence? Michael T. Tangorre yes, but how do I get around the problem that the variable is there in the url but is not being traced through to attributes.itemid [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
experts-exchange.com
[sorry for you cf-comm people this is a cross post from cf-comm :)] http://www.experts-exchange.com/ is the most linked upon site on google, i think, EVERY time i search for something technical, i inadvertently end up with a link to that site, and it usually appears that its the BEST answer, the answer i was looking for, but ive never gone past the sign up here to view the solution... anyone? good/bad/scam? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Variable evaluation LEFT of the assignment operator
I'm looking for an alternative method in CFML to do something, because BlueDragon doesn't like the way I'm doing it... so I figured this list is as good as any for alternate solutions... Here is the code that works in CF 6.1: cfset Caller.#Attributes.OutputVar# = TempOutput BlueDragon 6.1 doesn't like it though, and gives this error: Invalid _expression_ : Caller.Attributes.OutputVar So I'm wondering if there are any alternate ways to set the output variable... - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFFTP: use it on an entire tree?
I'm going to be building a web site uploader.The site is created locally on an intranet and published locally (i.e. written to .html and .cfm files).The written files are then to be uploaded to a live CF web server.I won't know the folder structure in advance other than where the root is. My question is: Is there a way to tell cfftp to just upload the contents of a folder tree?Doesn't look like you can put a 'file' if its a folder. I can use cfdirectory to loop over the folder structure on the local box and cfftp individual file lists.Was hoping I wouldn't have to and some magical easy solution exists. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Variable evaluation LEFT of the assignment operator
Try: cfset Caller[attributes.outputVar] = TempOutput Scott - Original Message - From: Rick Root Date: Mon, 13 Sep 2004 12:49:46 -0400 cfset Caller.#Attributes.OutputVar# = TempOutput -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Variable evaluation LEFT of the assignment operator
Try this: cfset caller[attributes.outputvar] = tempoutput / Not sure if it'll work w/ BD, but it should. cheers, barneyb On Mon, 13 Sep 2004 12:49:46 -0400, Rick Root [EMAIL PROTECTED] wrote: I'm looking for an alternative method in CFML to do something, because BlueDragon doesn't like the way I'm doing it... so I figured this list is as good as any for alternate solutions... Here is the code that works in CF 6.1: cfset Caller.#Attributes.OutputVar# = TempOutput BlueDragon 6.1 doesn't like it though, and gives this error: Invalid _expression_ : Caller.Attributes.OutputVar So I'm wondering if there are any alternate ways to set the output variable... - Rick -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HTTPS post
form method=post action=""> that wont work? tw On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote: Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs? Does this make sense? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: experts-exchange.com
From: Tony Weeg [mailto:[EMAIL PROTECTED] anyone? good/bad/scam? It's a good site. I find many answers to questions there! I get all my CF questions answered here, but for other things like C# that site comes in very handy. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Crashing Problem
Hi all. We have serious crashing problem going on. The JRun CPU usage goes up to 99% and then crashes. This is on internal applications with about 20 users. Details CF MX 6.1 SQL Server 2000 with latest server pack Windows 2000 box with 2 gig RAM. I have done some research and installed one patch http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_hotfix.htm We reboot CF and watch the logs and it can go down within seconds. Any ideas? Lee Surma [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFLDAP (used for AD permissions?)
Can you explain what you are wanting to do? CFLDAP does work with W2k3 AD, but I'm not sure what you mean about a dir on my cfmx server. Do you mean Windows authentication to your directory or do you just want to pass an domain username and password to the CFLDAP tag? M!ke From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 11:05 AM To: CF-Talk Subject: CFLDAP (used for AD permissions?) hello everyone, hope ur monday is/did go well...mine is ok...for a monday... anyway, can someone just verify for me that cfldap will work with win2k3 active directory usernames/password authentication for a dir on my cfmx server? if not, and ive dreamed this one up, please pass the dutchy...and put me back to sleep... thanks. -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cldap modifying
Also, please note that Bob added the MODIFYTYPE attribute.You probably needed that as well.You should be fine with the default separator as long as you don't have any commas in your description.I usually do put an uncommon separator such as $ or | in my CFLDAP tags, just to be safe. From: Bob Flynn [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 11:16 AM To: CF-Talk Subject: Re: cldap modifying Brian, My CFLDAP wiz tells me that you need to identify your separator. I'm not sure that is the problem, but give it a shot. See the example below: cfldap action="" DN=#ListName# attributes=member=#memberID# separator=$ modifytype=REPLACE server=your.server.nameOrIP port=389 username=adminUser password=xx Bob I'm trying to use CFLDAP to modify and change the AD. I've used action="" and also action="" but I've run into a problem trying to change a field to be empty. The specific field I'm trying to change at the moment is Description, but it does this with any field. The error message I get is below. An error has occured while trying to execute modify :[LDAP: error code 19 - 2081: AtrErr: DSID-031D0809, #1: 0: 2081: DSID-031D0809, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att d (description) ]. My cfldap query is below, based off form values entered. The DN and everything is based off a previous form. cfldap server=serverIP port=389 username=adminUser password=password action=""> !---what it is now--- dn=#form.DN# !---what it should be changed to--- attributes=description=#form.description#;scriptPath=#form.scriptPath# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: experts-exchange.com
I've gotten a few handy nuggets from there myself.Cheap membership. --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFLDAP (used for AD permissions?)
just want to auth. against ad and if ok, go through to dir on my cfmx server. sorry, its monday tw On Mon, 13 Sep 2004 12:02:32 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: Can you explain what you are wanting to do? CFLDAP does work with W2k3 AD, but I'm not sure what you mean about a dir on my cfmx server. Do you mean Windows authentication to your directory or do you just want to pass an domain username and password to the CFLDAP tag? M!ke From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 11:05 AM To: CF-Talk Subject: CFLDAP (used for AD permissions?) hello everyone, hope ur monday is/did go well...mine is ok...for a monday... anyway, can someone just verify for me that cfldap will work with win2k3 active directory usernames/password authentication for a dir on my cfmx server? if not, and ive dreamed this one up, please pass the dutchy...and put me back to sleep... thanks. -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: experts-exchange.com
What are you guys paying for? Everytime I click on a link from google to experts exchange, I just scroll way down and see the answers... They must get a lot of suckers who click the sign-up button in the middle of the screen above the answers. The only time you have to pay is to ask a question... So I thought. Michael T. Tangorre From: Matt Robertson [mailto:[EMAIL PROTECTED] I've gotten a few handy nuggets from there myself.Cheap membership. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFLDAP (used for AD permissions?)
Check the CFC I just emailed you. Michael T. Tangorre From: Tony Weeg [mailto:[EMAIL PROTECTED] just want to auth. against ad and if ok, go through to dir on my cfmx server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: experts-exchange.com
I've found that before too.It depends on what I'm searching though. Sometimes I see the answers and other times I see the sign-up thing.I think sometimes the google link has a session id on the url or something.Who knows though. John -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 1:16 PM To: CF-Talk Subject: RE: experts-exchange.com What are you guys paying for? Everytime I click on a link from google to experts exchange, I just scroll way down and see the answers... They must get a lot of suckers who click the sign-up button in the middle of the screen above the answers. The only time you have to pay is to ask a question... So I thought. Michael T. Tangorre From: Matt Robertson [mailto:[EMAIL PROTECTED] I've gotten a few handy nuggets from there myself.Cheap membership. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: experts-exchange.com
but ive never gone past the sign up here to view the solution... Yeah, and I would rather pay to find the way to exclude this site from my search. Really frustrating. ;-) -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
RE: experts-exchange.com
Tony, I gave in and signed up. Yes, there is lots of helpful solutions in there. It's good to know that there are other people experiencing the same issues I see (daily), and that there are solutions and work-arounds out there. Good Luck Nick Call _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 10:47 AM To: CF-Talk Subject: experts-exchange.com [sorry for you cf-comm people this is a cross post from cf-comm :)] http://www.experts-exchange.com/ is the most linked upon site on google, i think, EVERY time i search for something technical, i inadvertently end up with a link to that site, and it usually appears that its the BEST answer, the answer i was looking for, but ive never gone past the sign up here to view the solution... anyone? good/bad/scam? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: experts-exchange.com
some stuff is free and some isn't. I wound up having to join as I needed an answer that was hidden, and have left it as-is since.One of those things where the one question per month (or less) that they answer is worth the 4 bucks membership (or whatever it is).If it saves me an hour the 4 bucks is worth it. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Crashing Problem
On Mon, 13 Sep 2004 11:59:51 -0500, Lee [EMAIL PROTECTED] wrote: Hi all. We have serious crashing problem going on. The JRun CPU usage goes up to 99% and then crashes. This is on internal applications with about 20 users. Details CF MX 6.1 SQL Server 2000 with latest server pack Windows 2000 box with 2 gig RAM. I have done some research and installed one patch http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_hotfix.htm We reboot CF and watch the logs and it can go down within seconds. Any ideas? Have you applied the new CFMX rollup Updater? That contains several fixes specifically with regard to CPU spikes when using SQL Server. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Crashing Problem
Hi all. We have serious crashing problem going on. The JRun CPU usage goes up to 99% and then crashes. This is on internal applications with about 20 users. Details CF MX 6.1 SQL Server 2000 with latest server pack Windows 2000 box with 2 gig RAM. I have done some research and installed one patch http://www.macromedia.com/support/coldfusion/ts/documents/clie nt_purge_hotfix.htm We reboot CF and watch the logs and it can go down within seconds. Any ideas? Have you installed either the latest MM database drivers or the CFMX 6.1 Updater (which contains said drivers)? The vast majority of stability problems I've encountered with CFMX against SQL Server can be directly traced to the buggy drivers shipped with CFMX 6.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: experts-exchange.com
Yes, there is lots of helpful solutions in there. It's good to know that there are other people experiencing the same issues I wonder why people are paying to ask their questions there when they could ask them here and get the answers for free? -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
RE: Installing CFMX 6.1 w/IIS6 Win2003
Are there any specific CFMX 6.1 issues related to IIS6.0? When I try to view any cfm pages I get the following error msg: HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource. Internet Information Services (IIS) I'm not very familiar with using a IIS6/win2003 setup. You're more likely to run into permissions issues with IIS 6 than with previous versions, I think. Check the ACLs on the .cfm files in question, and on the ISAPI DLLs and related files. If you want to allow anonymous access, you'll need to grant Authenticated Users or the anonymous login account read/execute access to the DLLs, and execute access to the .cfm files. The ISAPI stuff is typically located in the wsconfig directory, the location of which will vary depending on whether you've installed the J2EE or standalone version of CFMX. On my (J2EE) machine, it's \jrun4\lib\wsconfig. On a standalone machine, it's somewhere within \cfusionmx. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: experts-exchange.com
Yeah, and I would rather pay to find the way to exclude this site from my search. Really frustrating. ;-) If you're talking about excluding sites from Google: search terms here -site:expert-exchange.com http://www.seorank.com/google-advanced-search-tips.htm Feel free to send payment to the address in the URL below. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: experts-exchange.com
Speed. Searching through the CF-Talk archives or asking a question can sometimes (based on time of day) be slower than hitting a site dedicated to having QA. As is usual, I've been wanting to build a better QA section for the site, but time and energy. Let me finish gathering specs for the new community section for distributed work and I'll get to the QA section. Anyone with ideas, let me have them (off list). Thanks _ From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 1:32 PM To: CF-Talk Subject: Re: experts-exchange.com Yes, there is lots of helpful solutions in there. It's good to know that there are other people experiencing the same issues I wonder why people are paying to ask their questions there when they could ask them here and get the answers for free? -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
Re: Crashing Problem
Dave, Whats your overall opinion on the stability of the 6.1 Updater? I'm running test right now (focusing mainly on Oracle), is there anything I should keep an eye out for? -Adam - Original Message - From: Dave Watts [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 13:31:56 -0400 Subject: RE: Crashing Problem To: CF-Talk [EMAIL PROTECTED] Hi all. We have serious crashing problem going on. The JRun CPU usage goes up to 99% and then crashes. This is on internal applications with about 20 users. Details CF MX 6.1 SQL Server 2000 with latest server pack Windows 2000 box with 2 gig RAM. I have done some research and installed one patch http://www.macromedia.com/support/coldfusion/ts/documents/clie nt_purge_hotfix.htm We reboot CF and watch the logs and it can go down within seconds. Any ideas? Have you installed either the latest MM database drivers or the CFMX 6.1 Updater (which contains said drivers)? The vast majority of stability problems I've encountered with CFMX against SQL Server can be directly traced to the buggy drivers shipped with CFMX 6.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: disallowing usage of DSNs
Dave, Good idea! I can then specify read (SELECT) permissions in the DB for the default username values of the DSNs in CF Admin. Then when I want to do INSERTs or UPDATEs, I specify a different username than the one in the DSN definition. This different username will have write (INSERT and UPDATE) permissions in the DB. Beautiful! Except I have to go back and modify a bunch of code. George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
User tracking and breadcrumbs
Dear Friends, I need to track user breadcrumbs starting from their login and stored in db. Any tag suggestions? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Crashing Problem
Whats your overall opinion on the stability of the 6.1 Updater? I'm running test right now (focusing mainly on Oracle), is there anything I should keep an eye out for? So far, so good. Of course, the big thing is the database drivers, so if those work for you it's a good upgrade. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Crashing Problem
Updater is going in right now. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Installing CFMX 6.1 w/IIS6 Win2003
What's really strange is that html pages would display correctly before installing CFMX 6.1 but after installing CFMX 6.1 we get the same error on all pages (html, cfm). HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource. What would the CFMX installation do to IIS 6 to prevent it from displaying html pages? Thanks Again, Dave _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 1:39 PM To: CF-Talk Subject: RE: Installing CFMX 6.1 w/IIS6 Win2003 Are there any specific CFMX 6.1 issues related to IIS6.0? When I try to view any cfm pages I get the following error msg: HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource. Internet Information Services (IIS) I'm not very familiar with using a IIS6/win2003 setup. You're more likely to run into permissions issues with IIS 6 than with previous versions, I think. Check the ACLs on the .cfm files in question, and on the ISAPI DLLs and related files. If you want to allow anonymous access, you'll need to grant Authenticated Users or the anonymous login account read/execute access to the DLLs, and execute access to the .cfm files. The ISAPI stuff is typically located in the wsconfig directory, the location of which will vary depending on whether you've installed the J2EE or standalone version of CFMX. On my (J2EE) machine, it's \jrun4\lib\wsconfig. On a standalone machine, it's somewhere within \cfusionmx. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Ah, I see... my approach is all wrong... OK.. I'll go down this avenue! Thanks! Looks to me like you're trying to mix _javascript_ and server side coding. Can't do that. You could make the delete button a form submit button, using _javascript_, then on the form handler page, test your cfif block, delete whatever, then cflocation yourself back to the original page... Ray [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Pinging servers from within Coldfusion?
Hi all, I'm sending SMS messages to a provider using CFHTTP. They have supplied me with two gateway addresses, so I've built in a bit of logic to send to another gateway if the first one is not reachable, which works fine. I was thinking though would it possible to ping each server before performing the actual HTTP POST to determine which one responds the fastest and save the extra time would be incurred as CFHTTP timeouts one attempted POST. I know there is a timeout setting in CFHTTP, but thought it would be more efficient to determine which host is more responsive without having to timeout a connection... Many thanks, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Now I'm in a fix. Which DB?
Max 25 it says.With 200 - 300 intranet users I don't think this would be an issue, would it? i used to be *5*. it used to be an issue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]