RE: [KCFusion] Error Executing Database Query
Title: Message I can't see anything codewise that would cause that. I would think it'd be something in your setup for the otg datasource. Maybe you have it pointing to the wrong database or server? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Chris HoldmanSent: Wednesday, October 15, 2003 3:59 PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] Error Executing Database Query Another error after migrating to MX From the following code I get an error: Invalid object name 'ae_dt1'. cfquery name="toplist" datasource="otg" maxrows="1"select Distinct(field2) from ae_dt1where field8='PUBLIC'order by field2 desc/cfquery If I so the same query in SQL Query analizer it works. Is there some atiquated CF4.0 code I am using that is not valid with CFMX? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681
RE: [KCFusion] cfmail validation in MX
Title: Message your best choice would be to validate the emails without trying to send them out, but if you must go that route, you could try something like cftry!--- cfmail stuff goes here --- cfcatch type="Application"cfif not cfcatch.name is "to"!--- do whatever failure stuff you wanted to do ---/cfif/cfcatch/cftry -Original Message-From: Chris Holdman [mailto:[EMAIL PROTECTED]Sent: Monday, October 13, 2003 1:28 PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] cfmail validation in MX I have a database full of emails, unfortunately some of them are bad emails (ex: [EMAIL PROTECTED] no.com). I have a script that is mailling out to the entire database, when I was using CF4.0 it would just throw the bad emails into the undeliverable folder. However when I run the script now with MX it gives me a cfmail error because it appears that CFMX is doing email validation and gives an error for bad emails...is there a way to force CF to just throw those bad emails in the undeliverable forlder so I can loop through me entire db? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681
RE: [KCFusion] cfmail validation in MX
Why don't you wrap your cfmail tag inside of a cfcatch/try block. Have it rethrow the error when it hits one and put the bad email address into a 2nd table for manual intervention. I think the rethrow tag allows the script to continue where it crashed. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Client variables
yes, it is a SCOPE! what version of cf did you upgrade from? -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Client variables Well I am not sure if this is a problem or not but one of my field names is 'request'and everything works weel on most of the pages of the application except for when I am querying the 'request' field. Is 'request' and reserved word in SQL or ColdFusion? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Client variables The requested scope CLIENT has not been enabled. Before CLIENT variables can be used, the CLIENT state management system must be enabled using the CFAPPLICATION tag. Do I need to adjust my script because of MX...I am not using any cfapplication tags. Yes, you will need to change/use the cfapplication tag in your application.cfm file. By default session and client management is supported and turned on in the CF Administrator. However, I am pretty sure that you must still turn on the session management in your application file (and hence every CF page that runs). Take a look at the cfapplication tag in your documentation, you will probably need to have clientmanagement=yes and sessionmanagement or something similar set to yes, all in 1 tag. It is pretty easy to setup. If you just upgraded to MX/6.1 from an older version, nothing should have changed and I don't know why you are getting an error now and not before. Are you sure there wasn't an Application.cfm page already running? By design, CF looks in the directory of the file being run, and if it doesn't find the application.cfm file it moves up the directory tree. It continues moving up as far as it can towards the root until it either finds the file or hits the highest level of the directory/web server accessible path. If your application was nested inside of someone else's directory path before, you may have been running the file without knowing it and it may have had client/session variables and management turned on. Good luck Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Client variables
I upgraded from 4.0. I found that if I change my variable from #request# to #form.request# it works. Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681 -Original Message- From: Matt Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:27 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Client variables yes, it is a SCOPE! what version of cf did you upgrade from? -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Client variables Well I am not sure if this is a problem or not but one of my field names is 'request'and everything works weel on most of the pages of the application except for when I am querying the 'request' field. Is 'request' and reserved word in SQL or ColdFusion? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Client variables The requested scope CLIENT has not been enabled. Before CLIENT variables can be used, the CLIENT state management system must be enabled using the CFAPPLICATION tag. Do I need to adjust my script because of MX...I am not using any cfapplication tags. Yes, you will need to change/use the cfapplication tag in your application.cfm file. By default session and client management is supported and turned on in the CF Administrator. However, I am pretty sure that you must still turn on the session management in your application file (and hence every CF page that runs). Take a look at the cfapplication tag in your documentation, you will probably need to have clientmanagement=yes and sessionmanagement or something similar set to yes, all in 1 tag. It is pretty easy to setup. If you just upgraded to MX/6.1 from an older version, nothing should have changed and I don't know why you are getting an error now and not before. Are you sure there wasn't an Application.cfm page already running? By design, CF looks in the directory of the file being run, and if it doesn't find the application.cfm file it moves up the directory tree. It continues moving up as far as it can towards the root until it either finds the file or hits the highest level of the directory/web server accessible path. If your application was nested inside of someone else's directory path before, you may have been running the file without knowing it and it may have had client/session variables and management turned on. Good luck Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] JRun issue when filling Verity on MX
I would GREATLY suggest that you attempt to find a way to just run the required sql against the database directly in the first recordset and not have to build your own query at all. I know in a lot of companies, pushing through sql changes can sometimes be a really big pain, but I think it would remarkably improve your performance. The query functions just aren't made to handle the number of rows that you're talking about, and you're basically taking something from a nice cursor driven data stream coming from the database and slamming it directly into ram, with a lot of CPU overhead, and slowing down the read time of the large data stream from the database, and it just might be the database's connection timeout settings that you're running into while you're attempting to process the data. Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Benjamin Price Sent: Thursday, October 09, 2003 10:47 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] JRun issue when filling Verity on MX I create another Query using the QueryNew, QueryAddRow and QuerySetCell functions. As I loop over the first recordset, I compact several rows at a time into one new row. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Dunwiddie Sent: Thursday, October 09, 2003 12:29 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] JRun issue when filling Verity on MX What do you mean exactly by saying that you're creating another query object from the first recordset? Are you using query of query to create another recordset, or are you looping over the first recordset to dynamically generate the sql for the second query? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Benjamin Price Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: [KCFusion] JRun issue when filling Verity on MX Interesting issue involving several ColdFusion topics here. We have upgraded to MX 6.1 and have been having numerous issues. The current issue happens when I try to refresh a Verity collection. The code to fill the collection takes quite a while to complete because I have to loop over 40,000+ rows of data. I create another query object from that recordset which ends up about 11,500 rows. I then put that into the Verity collection. The problem is that the page which does all this is returning an error which gives no clues as to where in the code the issue happens. The error is this: Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. The jrun log isn't helpful either as this is the only entry when the above error happens: 2003-10-09 07:05:57 jrISAPI[2816:1228] command error: Connection reset by peer - [8192] 2003-10-09 07:05:57 jrISAPI[2816:1228] returning error page for Connection reset by peer Prior to the timing out and error listing, the jrun.exe process has been running from 50 to 100% of the processor, yet it never even get close to the alotted memory (set in CF Admin to 1512K), maxing out at about 512K. We are running this on a Dell server(PowerEdge 6600), dual 1.6 Gig Xeon processors, Win2K server, IIS 5.0, CFMX 6.1. One other question we did have is that the build listed for the JRun server is 63961, from July. The last we can find on this site is from June (something just over 62000). Could this be the problem? Any ideas here would help. Find out why more Distributors are using DistributorCentral than ASI or SAGE! Ben Price Web Developer DistributorCentral 913-856-4130 [EMAIL PROTECTED] attachment: winmail.dat
RE: [KCFusion] CF MX and ODBC datasource with decode stmt
We use decode on ORACLE quite often and haven't had any problems since moving to MX. Can you post an example query? What version of ORACLE? Jeff -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CF MX and ODBC datasource with decode stmt
Jeff, The Web server Oracle client is 9.2.0.1.0 The CF MX connection is an ODBC socket to a system DSN set up with Microsoft's ODBC for Oracle running Windows 2003 server. The Unix Database server is running 8.1.7.3.0 The Code. SELECT decode(type_add,'WAG',monetary_amount,0) as wage_amount, decode(type_add,'BEN',monetary_amount,0) as benefit_amount FROM sysadm.Table_name WHERE emplid = 'kjfdlk' and distrib_line_num = '001' Works on the server via SQL Plus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:05 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt We use decode on ORACLE quite often and haven't had any problems since moving to MX. Can you post an example query? What version of ORACLE? Jeff -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CF MX and ODBC datasource with decode stmt
THanks for the suggestions - When we first started developing in CF, we used native drivers and had a lot of problems with response time and server busy messages. The decision was made by a consultant to use ODBC datasources - so we converted all the applications to use them. It did seem to help some at the time. Beth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:30 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt Beth, You might try using the Oracle driver in the cf admin instead of the odbc socket to see if that solves it. That's what we use for ours. Otherwise, our setup looks pretty much the same. Slight version differences but nothing major. Is there a specific reason you are using ODBC? -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:20 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt Jeff, The Web server Oracle client is 9.2.0.1.0 The CF MX connection is an ODBC socket to a system DSN set up with Microsoft's ODBC for Oracle running Windows 2003 server. The Unix Database server is running 8.1.7.3.0 The Code. SELECT decode(type_add,'WAG',monetary_amount,0) as wage_amount, decode(type_add,'BEN',monetary_amount,0) as benefit_amount FROM sysadm.Table_name WHERE emplid = 'kjfdlk' and distrib_line_num = '001' Works on the server via SQL Plus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:05 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt We use decode on ORACLE quite often and haven't had any problems since moving to MX. Can you post an example query? What version of ORACLE? Jeff -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe
RE: [KCFusion] CFDirectory MUCH slower in CFMX, any way to speed it up?
Title: Message I'd be willing to bet OS considerations and disk drive speed can affect that call as well. Also, as a programmer who has used the APIs, a multiprocessor system doesn't always help. It can sometimes hinder. Especially Intel's HyperThreading. You could get a caching RAID card in that system, That might help. Jeff -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason NokesSent: Monday, September 29, 2003 1:53 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] CFDirectory MUCH slower in CFMX, any way to speed it up? I did a test of CFDIRECTORY between CFMX (on a 4-1.6Ghz Xeon processors, 4GB RAM box) and CF5 (desktop box 1-1Ghz processor, 512 mb RAM) .This code:CFDIRECTORY DIRECTORY="d:\folder" NAME="locList"CFOUTPUT#locList.RecordCount#/CFOUTPUTThis result (13,000 files and folders in the main folder):CFMX:6469 ms TOTAL EXECUTION TIME CF5:Execution Time 218 millisecondsObviously, this is horrible. The CFMX box is many, many, many times more powerful. I also ran this code on our beta CFMX box to be sure and got similar results, so it is definitely CFMX.Besides going back to CF5, are there any suggestion on how to speed the file access up using CFMX? Jason Nokes, Director of Internet DevelopmentDistributorCentral, LLCUPIC: DC888-516-7401http://www.distributorcentral.com[EMAIL PROTECTED]Find out why more Distributors are using DistributorCentral than ASI or SAGE!
Re: [KCFusion] CFLOOP Issue
Umm..maybe im not quite getting something in your questionbut..your cfoutput is outside the loop tags. Since that is the case then headlinePerSection keeps getting reassigned a new value each loop 4 then 5 then 6. Why not put an array in the loop so you could store the value each interation? A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 6:48 PM Subject: [KCFusion] CFLOOP Issue I have a list (valuelist) that I get from a query. Looks like this: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4-1s, 5-2s, and 6-3s. I understand that ListValueCount(list, value) does that. It is supposed to report how many instances of a value there are in a list. So I am trying to loop through it. But I dont think my loop is looping. When I cfoutput the index value for the loop, I get 4. Its like it skips over 1,2, and outputs only 3. Heres the code which if you copy and paste into Dreamweaver or whatever you use to code, you can run. I hard coded the variables: cfset maxSection = 3 cfset countSections = "1,1,1,1,2,2,2,2,2,3,3,3,3,3,3" cfloop index="i" from="1" to="3" cfset headlinePerSection = ListValueCount(countSections, i) cfset columnOneCount = Int(headlinePerSection/2) cfset columnTwoCount = Ceiling(headlinePerSection - columnOneCount) /cfloop cfoutput i: #i#br / maxSection: #maxSection#br / countSections: #countSections#br / headlinePerSection:#headlinePerSection#br / columnOneCount: #columnOneCount#br / columnTwoCount: #columnTwoCount#br /br / /cfoutput The test output looks like this: i: 4maxSection: 3countSections: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3headlinePerSection:6columnOneCount: 3columnTwoCount: 3 Again, I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4 -1s, 5-2s, and 6-3s. Got any ideas? Jim T. Pickering 913/269-3339
RE: [KCFusion] CFLOOP Issue
Uh, I just moved the /cfloop tag below the cfoutput block, and it worked like a charm. This probably seemed fairly elementary and simple but you know when you work on a getting over a series of hurdles for three days and you start missing the obvious as you near the last hurdle? Thats where I am. Happy to get to move on now. My curiosity has me wondering what you mean by: Why not put an array in the loop so you could store the value each interation? I never considered that and dont really know what you mean. If you think that is a better solution, Id like to hear about how that works. Thanks Adaryl From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Thursday, September 25, 2003 8:27 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] CFLOOP Issue Umm..maybe im not quite getting something in your questionbut..your cfoutput is outside the loop tags. Since that is the case then headlinePerSection keeps getting reassigned a new value each loop 4 then 5 then 6. Why not put an array in the loop so you could store the value each interation? A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 6:48 PM Subject: [KCFusion] CFLOOP Issue I have a list (valuelist) that I get from a query. Looks like this: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4-1s, 5-2s, and 6-3s. I understand that ListValueCount(list, value) does that. It is supposed to report how many instances of a value there are in a list. So I am trying to loop through it. But I dont think my loop is looping. When I cfoutput the index value for the loop, I get 4. Its like it skips over 1,2, and outputs only 3. Heres the code which if you copy and paste into Dreamweaver or whatever you use to code, you can run. I hard coded the variables: cfset maxSection = 3 cfset countSections = 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 cfloop index=i from=1 to=3 cfset headlinePerSection = ListValueCount(countSections, i) cfset columnOneCount = Int(headlinePerSection/2) cfset columnTwoCount = Ceiling(headlinePerSection - columnOneCount) /cfloop cfoutput i: #i#br / maxSection: #maxSection#br / countSections: #countSections#br / headlinePerSection:#headlinePerSection#br / columnOneCount: #columnOneCount#br / columnTwoCount: #columnTwoCount#br /br / /cfoutput The test output looks like this: i: 4 maxSection: 3 countSections: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 headlinePerSection:6 columnOneCount: 3 columnTwoCount: 3 Again, I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4 -1s, 5-2s, and 6-3s. Got any ideas? Jim T. Pickering 913/269-3339
RE: [KCFusion] CFLOOP Issue
No actually I appreciate you helping me out. Ive been trying to cross that threshold into thinking advanced CF, but like you said its a different thought process. Whats difficult is putting the advanced theory into practice in one own app. Examples in books are always so generic. I really get caught up with is there a better way to do it, and youve identified one. Im going to try that out. Thanks, again Adaryl. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Thursday, September 25, 2003 9:27 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] CFLOOP Issue The array idea is just a diffence in thought process. When I started learning CF I was taught to separate logic and presentation as much a possible so i would have tossed everything in the loop above theopening html tag and I would have stored the count of instances in an array like cfset headlinePerSection = ArrayNew(1) cfloop index=i from=1 to=3 cfset headlinePerSection[i] = ListValueCount(countSections, i) /cfloop Then futher down in the presentation layer of things I would have had another loop tag that spit out the (in this case) three values. Like I said..just a differnt(and probaly longer) way of doing it. A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 9:09 PM Subject: RE: [KCFusion] CFLOOP Issue Uh, I just moved the /cfloop tag below the cfoutput block, and it worked like a charm. This probably seemed fairly elementary and simple but you know when you work on a getting over a series of hurdles for three days and you start missing the obvious as you near the last hurdle? Thats where I am. Happy to get to move on now. My curiosity has me wondering what you mean by: Why not put an array in the loop so you could store the value each interation? I never considered that and dont really know what you mean. If you think that is a better solution, Id like to hear about how that works. Thanks Adaryl From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Thursday, September 25, 2003 8:27 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] CFLOOP Issue Umm..maybe im not quite getting something in your questionbut..your cfoutput is outside the loop tags. Since that is the case then headlinePerSection keeps getting reassigned a new value each loop 4 then 5 then 6. Why not put an array in the loop so you could store the value each interation? A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 6:48 PM Subject: [KCFusion] CFLOOP Issue I have a list (valuelist) that I get from a query. Looks like this: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4-1s, 5-2s, and 6-3s. I understand that ListValueCount(list, value) does that. It is supposed to report how many instances of a value there are in a list. So I am trying to loop through it. But I dont think my loop is looping. When I cfoutput the index value for the loop, I get 4. Its like it skips over 1,2, and outputs only 3. Heres the code which if you copy and paste into Dreamweaver or whatever you use to code, you can run. I hard coded the variables: cfset maxSection = 3 cfset countSections = 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 cfloop index=i from=1 to=3 cfset headlinePerSection = ListValueCount(countSections, i) cfset columnOneCount = Int(headlinePerSection/2) cfset columnTwoCount = Ceiling(headlinePerSection - columnOneCount) /cfloop cfoutput i: #i#br / maxSection: #maxSection#br / countSections: #countSections#br / headlinePerSection:#headlinePerSection#br / columnOneCount: #columnOneCount#br / columnTwoCount: #columnTwoCount#br /br / /cfoutput The test output looks like this: i: 4 maxSection: 3 countSections: 1,1,1,1,2,2,2,2,2,3,3,3,3,3,3 headlinePerSection:6 columnOneCount: 3 columnTwoCount: 3 Again, I need an integer for how many 1s, 2s, 3s, etc there are in the list. 4 -1s, 5-2s, and 6-3s. Got any ideas? Jim T. Pickering 913/269-3339
Re: [KCFusion] Meeting Announcement - Hal Helms - Wednesday the 24th
At 12:57 AM 9/18/2003, you wrote: Coming next Wednesday, September 24th at 6pm... Hal Helms (www.halhelms.com)! Can you better describe the audience that would most benefit? Would a absolute newbie or someone who was thinking of using CF really benefit? Would hard core CF programmers benefit? Brown Holdings LLC Group Giving Vision to Your Business Http://www.BusinessSights.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Target audience - next CF meeting
At 10:53 AM 9/18/2003, you wrote: For those of you new to the list and new to ColdFusion, I can put on an intro to CF meeting for either this user group, or more likely the MMUG sometime in the next few months if there is a demand. I'm just beyond here is a web server and here is how you install it. I'm currently working through CFWACK and just reached Chapter 15 where I'm going to start building my own application to see how much I remember of Chapters 1-14! Peggie Brown Brown Holdings LLC Group Giving Vision to Your Business Http://www.BusinessSights.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Potential meeting, Wed, Sept 24
This might possibly be a silly question, but who is Hal Helms? What would the topic be? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, September 15, 2003 2:22 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Potential meeting, Wed, Sept 24 There is a good chance that Hal Helms will be in town and available to speak on the evening of Wednesday, September 24 (next week). I am trying to coordinate a meeting location that will work for him and the group, but the large rooms at UMKC are booked until 7:15pm. If you are interested and able to come on Wednesday, please let me know today or early Tuesday so that I can have an idea on participation. 1) Smaller room at UMKC with max 15 or so occupancy, but earlier meeting time (6 or 6:30 probably) 2) Large room, but meeting at 7:30ish 3) Overland Park/Centriq - may not be available, or too far for Hal to drive 4) Other locations if someone volunteers meeting space in mid-town in the next 24 hours. Capacity of 15+, projector, internet access desired but not required. Please let me know ASAP if this interests you. If only a few people are interested we will probably go with option #1 above. Ryan [EMAIL PROTECTED] Meeting/presentation topics Not yet finalized, but Hal Helms has been a primary figure in the writing of Fusebox and Mach-II coding methodologies for ColdFusion, has written a number of books on Fusebox and CFCs, and trains in Fusebox, ColdFusion, Java, and Object Oriented coding. www.halhelms.com for more information __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Job Opportunity
Ryan asked me to repost as text only ... There is a position or two open in my office. Please do not contact me directly regarding this position. If you are interested, please follow company protocol and fax in your resume. Thank you, Justin Hansen -- Cold Fusion Web Developer/Programmer Uhlig Communications, Inc. is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusion applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of Java and JDO a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please fax resume to (913) 754-4219. No agency inquiries accepted. Nwopryqzz~rzNrz~ N[¬è® b²w²+^Èh²o!äwRÊË^Â'p¸¬´ +m§ÿðà V«r¯yÊýÇåËdqû¬è®.zËb¢{¢iÛ(¬ihÂ)ජ±[h+-«-z¹~ë¢z+:¹»®¨¥¶+-²æìr¸zGºàN '²æìr¸zf¢Ú~X¬¶é®Çî²*'¢¸
RE: [KCFusion] Job Opportunity
Ryan asked me to repost as text only ... There is a position or two open in my office. Please do not contact me directly regarding this position. If you are interested, please follow company protocol and fax in your resume. Thank you, Justin Hansen -- Cold Fusion Web Developer/Programmer Uhlig Communications, Inc. is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusion applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of Java and JDO a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please fax resume to (913) 754-4219. No agency inquiries accepted. âë¢z+X¬µ©ÝÁæì²,µç[È{¦jy²°Ü.+-·!÷¬Ûiÿü0Âf¢ª+Þr¿qùb²Ù~ë¢z+²À¨g§¶Ê+Z0x¨¬zf¢Ú%ËfjË^®GºàN®nÇ+·¦j)m¡ÇåËl¹»®Çî²*'¢¸¡I®¨¥¶+-º{.nÇ+·¤qû¬è®
Re: [KCFusion] web server trouble shooting (OT)
Did you by chance ping your server or do a tracert to it? Yes that is usually the first thing I do when faced with a page that does not load. Its really silly but I think the packets get lost and need to be reminded where to go. Thats how I think of it anyway and in this case no such luck. What did you do to "coax" the KState's site into loading? We hit refresh about a million times over the course of an hour. Despite engaging in what could be defined as insane behavior (doing the same thing over and over expecting different results) it seemed to do the trick after a while. Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? Actually no. We were under a time crunch and had no need to have all the laptops going to the site. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like a DNS problem or a localized internet routing problem. Did you by chance ping your server or do a tracert to it? What did you do to "coax" the KState's site into loading? Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? If so, how did that go? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, September 16, 2003 1:04 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] web server trouble shooting (OT) I had a bizarre experience over the weekend. We hosted a conference out in BFE (Valley Falls) and took 10 laptops, networked them and connected them to the buildings internet connection which was an ISDN line. While there was noticible slow down in people surfing the web, what was really fustrating was you could not go to our organizations website. It flat refused to load. It would say web site found and the progress bar would get started but then it would just sit there. We could go pretty much everywhere else (KStates was not loading for a while but we coaxed that one into action with much waiting) but our site. One of the presentations focused on how to use our site so I finally got around it by remote desktoping into our server and looking at the site from there but once i had done that the site would load fast as anything looking at it just on the laptop (as opposed to looking at the laptop looking at the server). But it only worked on THATlaptop. All the others were still refusing to load. I had no clue what that was all about and all three of us were scratching our head. Anybody have any ideas on how I could have gone about "fixing" that? A.
Re: [KCFusion] web server trouble shooting (OT)
Cont'd (a little too fast on the send) We actually run a pretty uncomplicated site. We were loading crappily designed sites (www.bvmjets.com) and really good ones (www.accenture.com and www.msnbc.com) to see if it was something we had done wrong. In all three cases the pages came up without a problem. Adaryl WakefieldAviator by passionProgrammer by sheer force of will - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like a DNS problem or a localized internet routing problem. Did you by chance ping your server or do a tracert to it? What did you do to "coax" the KState's site into loading? Did you try following the same Remote Desktop steps that you took on the one laptop on one of the others? If so, how did that go? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, September 16, 2003 1:04 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] web server trouble shooting (OT) I had a bizarre experience over the weekend. We hosted a conference out in BFE (Valley Falls) and took 10 laptops, networked them and connected them to the buildings internet connection which was an ISDN line. While there was noticible slow down in people surfing the web, what was really fustrating was you could not go to our organizations website. It flat refused to load. It would say web site found and the progress bar would get started but then it would just sit there. We could go pretty much everywhere else (KStates was not loading for a while but we coaxed that one into action with much waiting) but our site. One of the presentations focused on how to use our site so I finally got around it by remote desktoping into our server and looking at the site from there but once i had done that the site would load fast as anything looking at it just on the laptop (as opposed to looking at the laptop looking at the server). But it only worked on THATlaptop. All the others were still refusing to load. I had no clue what that was all about and all three of us were scratching our head. Anybody have any ideas on how I could have gone about "fixing" that? A.
RE: [KCFusion] web server trouble shooting (OT)
ipconfig /flushdns This could happen If your LapTop was on a local network that also hosted the site and used an internal DNS server. When you moved the laptop to another network it still has the old Resolver Cache. After so many attempts the Resolver Cache checks for a new version of the site (That's what happened on KStates). Rick -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 16, 2003 2:04 PM To: [EMAIL PROTECTED] Subject: [KCFusion] web server trouble shooting (OT) I had a bizarre experience over the weekend. We hosted a conference out in BFE (Valley Falls) and took 10 laptops, networked them and connected them to the buildings internet connection which was an ISDN line. While there was noticible slow down in people surfing the web, what was really fustrating was you could not go to our organizations website. It flat refused to load. It would say web site found and the progress bar would get started but then it would just sit there. We could go pretty much everywhere else (KStates was not loading for a while but we coaxed that one into action with much waiting) but our site. One of the presentations focused on how to use our site so I finally got around it by remote desktoping into our server and looking at the site from there but once i had done that the site would load fast as anything looking at it just on the laptop (as opposed to looking at the laptop looking at the server). But it only worked on THATlaptop. All the others were still refusing to load. I had no clue what that was all about and all three of us were scratching our head. Anybody have any ideas on how I could have gone about fixing that? A.
RE: [KCFusion] Potential meeting, Wed, Sept 24
Did you contact Mike Faulkner to see about Centriq? I bet you'd get a bigger turnout if you had the meeting in OP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:22 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Potential meeting, Wed, Sept 24 There is a good chance that Hal Helms will be in town and available to speak on the evening of Wednesday, September 24 (next week). I am trying to coordinate a meeting location that will work for him and the group, but the large rooms at UMKC are booked until 7:15pm. If you are interested and able to come on Wednesday, please let me know today or early Tuesday so that I can have an idea on participation. 1) Smaller room at UMKC with max 15 or so occupancy, but earlier meeting time (6 or 6:30 probably) 2) Large room, but meeting at 7:30ish 3) Overland Park/Centriq - may not be available, or too far for Hal to drive 4) Other locations if someone volunteers meeting space in mid-town in the next 24 hours. Capacity of 15+, projector, internet access desired but not required. Please let me know ASAP if this interests you. If only a few people are interested we will probably go with option #1 above. Ryan [EMAIL PROTECTED] Meeting/presentation topics Not yet finalized, but Hal Helms has been a primary figure in the writing of Fusebox and Mach-II coding methodologies for ColdFusion, has written a number of books on Fusebox and CFCs, and trains in Fusebox, ColdFusion, Java, and Object Oriented coding. www.halhelms.com for more information __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFFILE on MAC
For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried putting in an additional blank mime type into the accept? Also, on the server, to view the registered mime types on the machine, you open windows explorer, go to tools-folder options-file types- and maybe try playing around with the registered mime types that it knows? There are some that by default are listed without a file extension, but it doesn't appear that you can edit these, and adding a new one you may have to play with. Also, in IIS, if that's what you're using, you can go to the properties of your web site, on the HTTP Headers tab, and click on the File Types button at the bottom, atleast in my version, and maybe try playing around with adding a blank mime type there? Only wacky ideas which probably won't help much... Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFFILE on MAC So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFFILE on MAC
I am specifying allowed MIMI types in the CFFILE tag but do not have a blank one. The error says that / Mimi Type is not allowed so I am thinking that will solve the problem. But will it create another is the question now? Wouldn't you be able to upload any file if you remove the ext? Thanks Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried putting in an additional blank mime type into the accept? Also, on the server, to view the registered mime types on the machine, you open windows explorer, go to tools-folder options-file types- and maybe try playing around with the registered mime types that it knows? There are some that by default are listed without a file extension, but it doesn't appear that you can edit these, and adding a new one you may have to play with. Also, in IIS, if that's what you're using, you can go to the properties of your web site, on the HTTP Headers tab, and click on the File Types button at the bottom, atleast in my version, and maybe try playing around with adding a blank mime type there? Only wacky ideas which probably won't help much... Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFFILE on MAC So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFFILE on MAC
I have 2 situations. 1 is just a way for a member to upload a picture to there profile. I need to know if it is a gif or a jpg. 2 is a document/File management and sharing system. I need to know everything and prevent certain files from being uploaded. Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Yes, you would be able to upload any file in that case, but the question then comes down to, what is it that you're trying to block out and why? Obviously uploading a .cfm or a .asp to a folder under wwwroot could be a problem, and conceivably an executable extension like .exe to any folder on the server could conceivably be a problem, but offhand, unless your server understands mac or linux file types based off of file headers and knows that there's an executable file that just doesn't have the extension, I don't see it as really being a problem. If you still want to push farther and make sure that before one of your mac artsy types grabs the file from your server and then just clicks on it over on their mac machine that it's been checked, the only way would be to either go out and study the mac file headers, however that works, or to try to find a program someone else has written that can run in a windows environment or whatever and can report back on what the headers say. Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 9:26 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFFILE on MAC I am specifying allowed MIMI types in the CFFILE tag but do not have a blank one. The error says that / Mimi Type is not allowed so I am thinking that will solve the problem. But will it create another is the question now? Wouldn't you be able to upload any file if you remove the ext? Thanks Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried putting in an additional blank mime type into the accept? Also, on the server, to view the registered mime types on the machine, you open windows explorer, go to tools-folder options-file types- and maybe try playing around with the registered mime types that it knows? There are some that by default are listed without a file extension, but it doesn't appear that you can edit these, and adding a new one you may have to play with. Also, in IIS, if that's what you're using, you can go to the properties of your web site, on the HTTP Headers tab, and click on the File Types button at the bottom, atleast in my version, and maybe try playing around with adding a blank mime type there? Only wacky ideas which probably won't help much... Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFFILE on MAC So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted
RE: [KCFusion] CFFILE on MAC
Been reading the e-mail traffic on this. The easiest way to make it work is to require the user to rename the file they want to upload, with a three letter extension after it. Sure it's inconvenient for Mac users, but Mac users understand that the web world is dominated by PC's. I've worked in several Ad Agencies and I've always instructed Mac users to add the three letter file extension. And Mac users know this, because they design web sites with Dreamweaver, and they have to have a .htm, .html, etc. to work. Code in some data validation that won't accept files without the three letter extension; and then allow only the three letter file extensions that you approve - .gif, .jpg, etc. That's my two cents. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of cfhelp Sent: Friday, September 12, 2003 10:43 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFFILE on MAC I have 2 situations. 1 is just a way for a member to upload a picture to there profile. I need to know if it is a gif or a jpg. 2 is a document/File management and sharing system. I need to know everything and prevent certain files from being uploaded. Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Yes, you would be able to upload any file in that case, but the question then comes down to, what is it that you're trying to block out and why? Obviously uploading a .cfm or a .asp to a folder under wwwroot could be a problem, and conceivably an executable extension like .exe to any folder on the server could conceivably be a problem, but offhand, unless your server understands mac or linux file types based off of file headers and knows that there's an executable file that just doesn't have the extension, I don't see it as really being a problem. If you still want to push farther and make sure that before one of your mac artsy types grabs the file from your server and then just clicks on it over on their mac machine that it's been checked, the only way would be to either go out and study the mac file headers, however that works, or to try to find a program someone else has written that can run in a windows environment or whatever and can report back on what the headers say. Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 9:26 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFFILE on MAC I am specifying allowed MIMI types in the CFFILE tag but do not have a blank one. The error says that / Mimi Type is not allowed so I am thinking that will solve the problem. But will it create another is the question now? Wouldn't you be able to upload any file if you remove the ext? Thanks Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried putting in an additional blank mime type into the accept? Also, on the server, to view the registered mime types on the machine, you open windows explorer, go to tools-folder options-file types- and maybe try playing around with the registered mime types that it knows? There are some that by default are listed without a file extension, but it doesn't appear that you can edit these, and adding a new one you may have to play with. Also, in IIS, if that's what you're using, you can go to the properties of your web site, on the HTTP Headers tab, and click on the File Types button at the bottom, atleast in my version, and maybe try playing around with adding a blank mime type there? Only wacky ideas which probably won't help much... Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFFILE on MAC So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED
RE: [KCFusion] CFFILE on MAC
And that is what I do now I just was hoping for an idiot proof solution. In the case of the updating profiles these people have no clue. With the document management system most my users are designers and know this. But I want to use that system in other environments that could have any level of users. Thanks for all the input. Oh, I am trimming the field. Rick -Original Message- From: Jim T Pickering [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:23 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Been reading the e-mail traffic on this. The easiest way to make it work is to require the user to rename the file they want to upload, with a three letter extension after it. Sure it's inconvenient for Mac users, but Mac users understand that the web world is dominated by PC's. I've worked in several Ad Agencies and I've always instructed Mac users to add the three letter file extension. And Mac users know this, because they design web sites with Dreamweaver, and they have to have a .htm, .html, etc. to work. Code in some data validation that won't accept files without the three letter extension; and then allow only the three letter file extensions that you approve - .gif, .jpg, etc. That's my two cents. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of cfhelp Sent: Friday, September 12, 2003 10:43 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFFILE on MAC I have 2 situations. 1 is just a way for a member to upload a picture to there profile. I need to know if it is a gif or a jpg. 2 is a document/File management and sharing system. I need to know everything and prevent certain files from being uploaded. Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Yes, you would be able to upload any file in that case, but the question then comes down to, what is it that you're trying to block out and why? Obviously uploading a .cfm or a .asp to a folder under wwwroot could be a problem, and conceivably an executable extension like .exe to any folder on the server could conceivably be a problem, but offhand, unless your server understands mac or linux file types based off of file headers and knows that there's an executable file that just doesn't have the extension, I don't see it as really being a problem. If you still want to push farther and make sure that before one of your mac artsy types grabs the file from your server and then just clicks on it over on their mac machine that it's been checked, the only way would be to either go out and study the mac file headers, however that works, or to try to find a program someone else has written that can run in a windows environment or whatever and can report back on what the headers say. Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 9:26 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFFILE on MAC I am specifying allowed MIMI types in the CFFILE tag but do not have a blank one. The error says that / Mimi Type is not allowed so I am thinking that will solve the problem. But will it create another is the question now? Wouldn't you be able to upload any file if you remove the ext? Thanks Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried putting in an additional blank mime type into the accept? Also, on the server, to view the registered mime types on the machine, you open windows explorer, go to tools-folder options-file types- and maybe try playing around with the registered mime types that it knows? There are some that by default are listed without a file extension, but it doesn't appear that you can edit these, and adding a new one you may have to play with. Also, in IIS, if that's what you're using, you can go to the properties of your web site, on the HTTP Headers tab, and click on the File Types button at the bottom, atleast in my version, and maybe try playing around with adding a blank mime type there? Only wacky ideas which probably won't help much... Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of cfhelp Sent: Friday, September 12, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFFILE on MAC So what do you guys
RE: [KCFusion] Need CF Studio 4.5 - help!
A kind soul helped me already - problem solved! :) -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron Hornbaker Sent: Friday, September 05, 2003 2:28 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Need CF Studio 4.5 - help! Hi Everyone, Minor crisis here - need to reinstall CF Studio 4.5 and can't find my CD. Would someone be so kind to put their's up on an ftp server somewhere, and send me the URL off-list to [EMAIL PROTECTED] I've got a serial number, just need the installer files. Thanks! Ron Ron Hornbaker Humankind Systems, Inc. don't be shelfish with your books - http://www.bookcrossing.com/ __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OP is AT capacity
Hi Ryan, If it will help I can attend the UMKC location. Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] OP is AT capacity Be forwarned, the OP location for tonight's meeting is at 49 or so people and is at capacity we think. It will very possibly be standing room only for people who show up late or haven't rsvp'd for the OP location. If you haven't decided where to go, we still have PLENTY of room and lots of pizza at UMKC. Don't forget, we will be awarding a full licensed copy of Studio MX 2004 at EACH location! There are a number of smaller giveaways also. To review: presentation starts at 6 as far as we know. Pizza arrives around 6:15. Presentation is 90 minutes long with QA to follow. This is being broadcast to roughly 80 groups during our time frame and 170 or so world wide today. Guests are welcome to come (preferably to UMKC) and rsvp is not required but helpful. If anyone has problems finding the location (and you don't have the map from www.kcfusion.org to help you), you can call Ryan at 913-579-5260. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OP is AT capacity
At 03:32 PM 9/3/2003 -0500, you wrote: Hi Ryan, If it will help I can attend the UMKC location. Johnny Then how am I to meet you? (-: Peggie Brown ((( ¸.-···- ^~~ ^ ( {ªYª} \ )_ `~-~/´ \,,/,,/ \,,,Í,,Í Brown Holdings LLC Group http://www.BusinessSights.com Vision for your Business http://www.RealGems.biz at Real Low Prices 913.727.1794 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OP is AT capacity
Hi Peggie, Well foot, I did not realize you were going to be at Corporate Woods! Oh well, I was just trying to help out. Let me know if you are going to be out in the Overland Park area and I will arrange with another user group member to have his conference room available to show you some stuff that we have been working on. His office is in an office complex at about 132nd and Old Metcalf. Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Katsuey Sent: Wednesday, September 03, 2003 4:05 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OP is AT capacity At 03:32 PM 9/3/2003 -0500, you wrote: Hi Ryan, If it will help I can attend the UMKC location. Johnny Then how am I to meet you? (-: Peggie Brown ((( ¸.-···- ^~~ ^ ( {ªYª} \ )_ `~-~/´ \,,/,,/ \,,,Í,,Í Brown Holdings LLC Group http://www.BusinessSights.com Vision for your Business http://www.RealGems.biz at Real Low Prices 913.727.1794 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OP is AT capacity
At 09:32 PM 9/3/2003 -0500, you wrote: Hi Peggie, Well foot, I did not realize you were going to be at Corporate Woods! Oh well, I was just trying to help out. Me too. I'd offered to go to UMKC but Ryan said they still had room at OP. We did have a couple of empty chairs - but not many. Let me know if you are going to be out in the Overland Park area and I will arrange with another user group member to have his conference room available to show you some stuff that we have been working on. His office is in an office complex at about 132nd and Old Metcalf. I will, but the truth is that I rarely go there any more. Funny in the last week now I've been there twice (other trip to take a very sick cat to the vet - she died). I wore a rut in the road for so many years that I have little wish to go except for evenings since they do have some good restaurants. There is S much road construction on I435 now. What a hassle! Sure were a lot of unanswered questions tonight. Sounds like NOTHING new in CF I'm plugging away with my CF self learning program - chapter 11 of CFWACK. It's fun but I wonder what if any thing I'm retaining! Peggie ((( ¸.-···- ^~~ ^ ( {ªYª} \ )_ `~-~/´ \,,/,,/ \,,,Í,,Í Brown Holdings LLC Group http://www.BusinessSights.com Vision for your Business http://www.RealGems.biz at Real Low Prices 913.727.1794 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park!
I'll attend at the Overland Park location. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park! Due to popular demand, we are making a 2nd location available for Wednesday's meeting. Centriq Solutions (centriq.com) and Thinq Digital (www.thinqdigital, an MM Authorized Trainer) will be hosting the Overland Park meeting at 7950 College Boulevard. Our first location at UMKC will still be used (5150 Oak). You should plan on arriving between 5:30 and 5:45. The big presentation starts at 6pm and is scheduled for 90 minutes with QA to follow (then the raffle for a copy of Studio MX 2004!). Pizza coke will be available at both locations. Please RSVP (even if you have done so already) and let us know which location you plan on attending. We have capacity for a little about 45 in OP and 55 at UMKC. We have close to 50 reservations so far. RSVP to [EMAIL PROTECTED] or [EMAIL PROTECTED] Please check www.kcfusion.com on Saturday and AGAIN on Wednesday for directions and additional information. The site will be updated tonight to reflect the 2nd location. We are in need of the following: 2 projectors as backups (1 per location) large speakers or sound system for OP volunteers to man the registration tables at both locations corporate sponsors are always welcome speakers for future meetings for each user group Please let me know if you can assist. Thanks, Ryan, [EMAIL PROTECTED] -- This meeting is being sponsored and brought to you by: KC ColdFusion User Group Ryan Hartwich KC Macromedia Multimedia User Group Charmaine Keller-Hodges Ron Ramphal with UMKC Centriq Solutions Michael Faulkner with Thinq Digital Printing by Russell Walker @ StudioXS Software Donations by Macromedia Prior assistance hosting by DistributorCentral Greensoft Solutions Humankind Systems Sprint __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park!
Ryan, I will be attending the Overland Park location. Thanks, Girish
RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!
SECOND THAT -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:26 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Okay, the RSVP emails have officially gotten annoying. Can this list be reconfigured so responses go to the sender instead of the whole list? -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Schappaugh, Cheri Sent: Friday, August 29, 2003 12:37 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Cheri Schappaugh attending Overland Park location..rsvp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park! Due to popular demand, we are making a 2nd location available for Wednesday's meeting. Centriq Solutions (centriq.com) and Thinq Digital (www.thinqdigital, an MM Authorized Trainer) will be hosting the Overland Park meeting at 7950 College Boulevard. Our first location at UMKC will still be used (5150 Oak). You should plan on arriving between 5:30 and 5:45. The big presentation starts at 6pm and is scheduled for 90 minutes with QA to follow (then the raffle for a copy of Studio MX 2004!). Pizza coke will be available at both locations. Please RSVP (even if you have done so already) and let us know which location you plan on attending. We have capacity for a little about 45 in OP and 55 at UMKC. We have close to 50 reservations so far. RSVP to [EMAIL PROTECTED] or [EMAIL PROTECTED] Please check www.kcfusion.com on Saturday and AGAIN on Wednesday for directions and additional information. The site will be updated tonight to reflect the 2nd location. We are in need of the following: 2 projectors as backups (1 per location) large speakers or sound system for OP volunteers to man the registration tables at both locations corporate sponsors are always welcome speakers for future meetings for each user group Please let me know if you can assist. Thanks, Ryan, [EMAIL PROTECTED] -- This meeting is being sponsored and brought to you by: KC ColdFusion User Group Ryan Hartwich KC Macromedia Multimedia User Group Charmaine Keller-Hodges Ron Ramphal with UMKC Centriq Solutions Michael Faulkner with Thinq Digital Printing by Russell Walker @ StudioXS Software Donations by Macromedia Prior assistance hosting by DistributorCentral Greensoft Solutions Humankind Systems Sprint __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] This message and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient you may not copy, forward, disclose or use any part of this message or its attachments. If you received in error please notify the sender immediately by e-mail or contact The Innovation Group, US, at 800-669-9689 and then delete this message from your system. Neither the sender nor any office or company in The Innovation Group plc group will be liable for any viruses. Any opinions contained in this message are those of the author and are not given or endorsed by any company in The Innovation Group plc group through which this message was sent unless otherwise expressly stated in this message and the authority of the author in so stating is verified. The Innovation Group, US, at 7800 College Boulevard, 2nd Floor, Overland Park, Kansas, 66210, USA. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] áx ºà+-jwpy»µ-yÖòH§u,¬µé¬[EMAIL PROTECTED] 0¨¥j·!÷¢oÜ~X¬¶GºàB*'°*éí
RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!
I don't. I personally like how the replies go. People just need to read. Ryan asked for RSVP's to go to his email, not as a reply. Either people aren't reading, or they're being too lazy to follow the directions, but even at that, what's the big deal with having to delete a few emails guys? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fatino, Henry K [ITS] Sent: Friday, August 29, 2003 1:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! SECOND THAT -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:26 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Okay, the RSVP emails have officially gotten annoying. Can this list be reconfigured so responses go to the sender instead of the whole list? -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Schappaugh, Cheri Sent: Friday, August 29, 2003 12:37 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Cheri Schappaugh attending Overland Park location..rsvp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park! Due to popular demand, we are making a 2nd location available for Wednesday's meeting. Centriq Solutions (centriq.com) and Thinq Digital (www.thinqdigital, an MM Authorized Trainer) will be hosting the Overland Park meeting at 7950 College Boulevard. Our first location at UMKC will still be used (5150 Oak). You should plan on arriving between 5:30 and 5:45. The big presentation starts at 6pm and is scheduled for 90 minutes with QA to follow (then the raffle for a copy of Studio MX 2004!). Pizza coke will be available at both locations. Please RSVP (even if you have done so already) and let us know which location you plan on attending. We have capacity for a little about 45 in OP and 55 at UMKC. We have close to 50 reservations so far. RSVP to [EMAIL PROTECTED] or [EMAIL PROTECTED] Please check www.kcfusion.com on Saturday and AGAIN on Wednesday for directions and additional information. The site will be updated tonight to reflect the 2nd location. We are in need of the following: 2 projectors as backups (1 per location) large speakers or sound system for OP volunteers to man the registration tables at both locations corporate sponsors are always welcome speakers for future meetings for each user group Please let me know if you can assist. Thanks, Ryan, [EMAIL PROTECTED] -- This meeting is being sponsored and brought to you by: KC ColdFusion User Group Ryan Hartwich KC Macromedia Multimedia User Group Charmaine Keller-Hodges Ron Ramphal with UMKC Centriq Solutions Michael Faulkner with Thinq Digital Printing by Russell Walker @ StudioXS Software Donations by Macromedia Prior assistance hosting by DistributorCentral Greensoft Solutions Humankind Systems Sprint __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] This message and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient you may not copy, forward, disclose or use any part of this message or its attachments. If you received in error please notify the sender immediately by e-mail or contact The Innovation Group, US, at 800-669-9689 and then delete this message from your system. Neither the sender nor any office or company in The Innovation Group plc group will be liable for any viruses. Any opinions contained in this message are those of the author and are not given or endorsed by any company in The Innovation Group plc group through which this message was sent unless otherwise expressly stated in this message and the authority of the author in so stating is verified. The Innovation Group, US, at 7800 College Boulevard, 2nd Floor, Overland Park, Kansas, 66210, USA. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments
RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!
As annoying as the RSVPs are (people should know how to reply directly to the sender), I do not believe it would not be a good idea to reply only to the original sender. Everybody on here has learned a few things from reading the responses to other people's issues. That is why we subscribe to this list. If you really don't want all the emails, you can go to the web log of this list. -Original Message- From: Fatino, Henry K [ITS] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! SECOND THAT -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:26 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Okay, the RSVP emails have officially gotten annoying. Can this list be reconfigured so responses go to the sender instead of the whole list? -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Schappaugh, Cheri Sent: Friday, August 29, 2003 12:37 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Cheri Schappaugh attending Overland Park location..rsvp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park! Due to popular demand, we are making a 2nd location available for Wednesday's meeting. Centriq Solutions (centriq.com) and Thinq Digital (www.thinqdigital, an MM Authorized Trainer) will be hosting the Overland Park meeting at 7950 College Boulevard. Our first location at UMKC will still be used (5150 Oak). You should plan on arriving between 5:30 and 5:45. The big presentation starts at 6pm and is scheduled for 90 minutes with QA to follow (then the raffle for a copy of Studio MX 2004!). Pizza coke will be available at both locations. Please RSVP (even if you have done so already) and let us know which location you plan on attending. We have capacity for a little about 45 in OP and 55 at UMKC. We have close to 50 reservations so far. RSVP to [EMAIL PROTECTED] or [EMAIL PROTECTED] Please check www.kcfusion.com on Saturday and AGAIN on Wednesday for directions and additional information. The site will be updated tonight to reflect the 2nd location. We are in need of the following: 2 projectors as backups (1 per location) large speakers or sound system for OP volunteers to man the registration tables at both locations corporate sponsors are always welcome speakers for future meetings for each user group Please let me know if you can assist. Thanks, Ryan, [EMAIL PROTECTED] -- This meeting is being sponsored and brought to you by: KC ColdFusion User Group Ryan Hartwich KC Macromedia Multimedia User Group Charmaine Keller-Hodges Ron Ramphal with UMKC Centriq Solutions Michael Faulkner with Thinq Digital Printing by Russell Walker @ StudioXS Software Donations by Macromedia Prior assistance hosting by DistributorCentral Greensoft Solutions Humankind Systems Sprint __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] This message and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient you may not copy, forward, disclose or use any part of this message or its attachments. If you received in error please notify the sender immediately by e-mail or contact The Innovation Group, US, at 800-669-9689 and then delete this message from your system. Neither the sender nor any office or company in The Innovation Group plc group will be liable for any viruses. Any opinions contained in this message are those of the author and are not given or endorsed by any company in The Innovation Group plc group through which this message was sent unless otherwise expressly stated in this message and the authority of the author in so stating is verified. The Innovation Group, US, at 7800 College Boulevard, 2nd Floor, Overland Park, Kansas, 66210, USA. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise
RE: [KCFusion] OT: Desktop automation text transfer
Try using VBA in Excel, Word, or possibly Outlook. Excel Macro example: Sub GetEmails() Dim myApp As New Outlook.Application Dim myNS As NameSpace Dim myFolder As MAPIFolder Dim myItems As Items Dim intLoopCounter As Integer, Idx As Integer Set myNS = myApp.GetNamespace(MAPI) Set myFolder = myNS.GetDefaultFolder(olFolderInbox) Set myItems = myFolder.Items Range(a1).Value = Subject Range(b1).Value = Body Idx = 2 For intLoopCounter = 1 To myItems.Count Range(a Idx).Value = myItems(intLoopCounter).Subject Range(b Idx).Value = myItems(intLoopCounter).Body Idx = Idx + 1 Next intLoopCounter Set myNS = Nothing Set myFolder = Nothing Set myItems = Nothing End Sub This will grab every email in your default email inbox and place the subject and body into separate rows within an excel spreadsheet. You could add some logic to search thru the body text and grab what you want. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 4:09 PM To: KCFusion (E-mail) Subject: [KCFusion] OT: Desktop automation text transfer Off topic, but I'm looking to see if a certain tool exists. I have a weekly task where I have to sort through Outlook email messages, then copy and paste the content from them into a plain text file. I want to speed this up with some desktop automation. Ideally, I'd like to click on a function key (or key combination) and have Windows automatically copy the Outlook text to the target document, where it would be appended. Is there such an animal? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OT: Desktop automation text transfer
This may be like giving a box of matches to a three-year-old, but I thank you anyway. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ellis, Randy Sent: Wednesday, August 27, 2003 8:19 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] OT: Desktop automation text transfer Try using VBA in Excel, Word, or possibly Outlook. Excel Macro example: Sub GetEmails() Dim myApp As New Outlook.Application Dim myNS As NameSpace Dim myFolder As MAPIFolder Dim myItems As Items Dim intLoopCounter As Integer, Idx As Integer Set myNS = myApp.GetNamespace(MAPI) Set myFolder = myNS.GetDefaultFolder(olFolderInbox) Set myItems = myFolder.Items Range(a1).Value = Subject Range(b1).Value = Body Idx = 2 For intLoopCounter = 1 To myItems.Count Range(a Idx).Value = myItems(intLoopCounter).Subject Range(b Idx).Value = myItems(intLoopCounter).Body Idx = Idx + 1 Next intLoopCounter Set myNS = Nothing Set myFolder = Nothing Set myItems = Nothing End Sub This will grab every email in your default email inbox and place the subject and body into separate rows within an excel spreadsheet. You could add some logic to search thru the body text and grab what you want. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 4:09 PM To: KCFusion (E-mail) Subject: [KCFusion] OT: Desktop automation text transfer Off topic, but I'm looking to see if a certain tool exists. I have a weekly task where I have to sort through Outlook email messages, then copy and paste the content from them into a plain text file. I want to speed this up with some desktop automation. Ideally, I'd like to click on a function key (or key combination) and have Windows automatically copy the Outlook text to the target document, where it would be appended. Is there such an animal? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Please RSVP for the Wednesday, Sept 3 meeting
I am planning to attend, Girish
RE: [KCFusion] Studio MX 2004 See It - Win It!
I haven't attended any of the meetings yet but I will try to may this one if you don't mind. Frederick Hale R.O.A.M. Support *Phone: 816-391-7745 * Fax: 816-391-5027 *E-Mail: [EMAIL PROTECTED] -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 12:08 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [KCFusion] Studio MX 2004 See It - Win It! Today Macromedia announced a new generation of MX. It's called MX 2004. New versions of Dreamweaver, Flash, Fireworks, and Studio. Come see the first public demonstrations of these products and possibly win your own copy of Studio MX 2004! We are hosting Macromedia Product Managers who will demo the products live utilizing Breeze Live. Our User Group is participating at: WHEN: Wednesday, September 3, 2003 6:00 PM, please arrive between 5:45 and 6. We will meet in the Administration Building of UMKC (southeast of the Plaza) at 5115 Oak St, KCMO 64112-2715. Maps are available on our website at www.kcfusion.org Join Macromedia for the first public demonstrations of Dreamweaver MX 2004, Fireworks MX 2004, Flash MX 2004, Flash Professional MX 2004 and Studio MX 2004. Over 130 User Groups are participating in our first ever worldwide User Group event, broadcast around the world using Breeze Live. We will be raffling off a copy of Studio MX 2004! Macromedia presenters are: Jennifer Taylor, Dreamweaver MX 2004 Product Manager Matt Lerner, Fireworks MX 2004 Product Manager Lucian Beebe; Flash Professional MX 2004 Product Manager Eliza Laffin, Studio MX 2004, Product Manager We look forward to seeing you at the meeting! Ryan Charmaine __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] XML error handling
This should work for you or atleast give you the general idea of how to handle the error. cfhttp url=http://someurl.com; method=Get resolveurl=YES/cfhttp cftry cfset resultcontent = XmlParse(cfhttp.fileContent) cfcatch type=Any !--- Do something else--- cfset resultcontent = The XML is HOSED!!! /cfcatch /cftry Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott McWilliams Sent: Tuesday, August 26, 2003 12:54 PM To: [EMAIL PROTECTED] Subject: [KCFusion] XML error handling I'm pretty new to error handling, so any help is very much appreciated. Is it possible to check a file before XmlParse to ensure it is a properly formatted XML file? The issue I'm having is that I pull in XML formatted data from a remote application using the following code: cfhttp url=http://someurl.com; method=Get resolveurl=YES/cfhttp cfset resultcontent = XmlParse(cfhttp.fileContent) This works fine when cfhttp.filecontent is properly formatted XML text. Unfortunately, the remote application that I'm pulling from will spit out improperly formatted XML text about 2% of the time. The remote application will fault unpredictably in the middle of the data leaving unclosed nodes. This causes an error with XmlParse. Fixing the remote application is not an option. I've tried using IsXmlDoc(cfhttp.FileContent), but since the document is merely formatted text prior to XmlParse, this always returns False. Is there a way to check the file before XmlParse or to catch the error so that my application can continue? Thanks in advance. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bradley Miller Sent: Monday, August 25, 2003 2:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [KCFusion] CSV Driver in MX ? Ah -- another wrinkle in the swap to a new server . . . . where's my CSV drivers in ColdFusion MX? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Help please
Title: Message We figured it out. The issue was with the flash services and using 2 host names for the same server. It seems to be working better now. Thanks, Jeff Brown -Original Message-From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 11:35 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Help please can you be more specific? where on the serverdid you store the CFCs? if you used a cf mapped directory make sure you add the mapping to the testing server. justin -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 10:56 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] Help please We have just moved our first CFC application to the test server and for some reason, the application doesn't seem to be able to get to the CFCs, does anyone know what we might be living out here? Thanks Betty N. Nwabuonwu Business Systems Design/ImplementationState Street - Kansas City This message and any attached documents are confidential and ** intended solely for the use of the individual or entity to whom ** they are addressed. If this message and any attached documents ** were received in error, notify [EMAIL PROTECTED] and ** erase all copies of this message and any attached documents.
RE: [KCFusion] Help please
can you be more specific? where on the serverdid you store the CFCs? if you used a cf mapped directory make sure you add the mapping to the testing server. justin -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 10:56 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] Help please We have just moved our first CFC application to the test server and for some reason, the application doesn't seem to be able to get to the CFCs, does anyone know what we might be living out here? Thanks Betty N. Nwabuonwu Business Systems Design/ImplementationState Street - Kansas City This message and any attached documents are confidential and ** intended solely for the use of the individual or entity to whom ** they are addressed. If this message and any attached documents ** were received in error, notify [EMAIL PROTECTED] and ** erase all copies of this message and any attached documents.
Re: [KCFusion] Weird problem
Actually -- just asked this question on the DevMX list and got a fast response: To: [EMAIL PROTECTED] From: Todd [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: multipart/alternative; boundary==_61532312==.ALT Subject: Re: [mxdev] Coldfusion MX question Yup, you have a multi-homing issue. Do you have CFMX 6.1 yet? If not, you'll have to dig into an XML file (http://blog.web-rat.com/archives/20.cfm) - If you do have CFMX 6.1, goto Caching in the CFAdmin and make sure that Cache Web Server Path is unchecked. ~Todd __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] security question
Ok wait. I have not thought this all the way though I think. The kind of attack was thinking of was where a hostile user taped the stream mid flow. Somehow between the end user and the server. Since the pages are encrypted with https then they (the hostile) should not be able to do anything yes? An if the bandit has the users authentication information then there really is not much you can do no? You know for a meeting idea I'd really like to hear what the big boys are doing security wise. All the books I have the security is pretty lame and basic. A. - Original Message - From: Luke Templin To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:05 AM Subject: RE: [KCFusion] security question You may want to do everything through a stored procedure(s). As part of that stored procedure you could create multiple sql queries one of which can be an audit trail. Another way is to present the material to be deleted as a table with a checkbox for each row.Then have the user select each individual record. Pass the information to a cftag that does the delete. this reduces the opportunity for a user to randomly type anything in and allows you to implement a validation routine. Another item to explore is to use the https if security is a concern. Can't say I have experience with it but given your description that might be a method to investigate. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:54 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
RE: [KCFusion] security question
Are you asking how this can be done, or just whether this can be done?Are you trying to alter your data, or just assure a customer that their data is safe? -Original Message-From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 11:34 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
RE: [KCFusion] security question
Well the checking in the database to make sure that the user is allowed to delete that record is a good step to leave in. As for the rest, I'd probably recommend passing an encrypted value of the record to delete along with the record id itself, so you can verify that they haven't just changed the id, and it won't matter if they can get access to the hidden encrypted value because they won't be able to submit the proper encrypted version to pass the validation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kory Bakken Sent: Tuesday, August 12, 2003 9:54 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] security question Adaryl: Yes, if a person has IEBoster (http:// www.paessler.com/IEB http://www.paessler.com/IEB ) running on their machine, hidden form fields are just a right-click away. You'd be better off putting a ACTIVE field in any table that you are going to allow users to delete from. That could inactivate the record, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted in a hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]On Behalf Of Adaryl Wakefield Sent: Monday, August 11, 2003 1:44 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A. attachment: winmail.dat
RE: [KCFusion] security question
I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
RE: [KCFusion] security question
You may want to do everything through a stored procedure(s). As part of that stored procedure you could create multiple sql queries one of which can be an audit trail. Another way is to present the material to be deleted as a table with a checkbox for each row.Then have the user select each individual record. Pass the information to a cftag that does the delete. this reduces the opportunity for a user to randomly type anything in and allows you to implement a validation routine. Another item to explore is to use the https if security is a concern. Can't say I have experience with it but given your description that might be a method to investigate. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:54 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
RE: [KCFusion] security question
Adaryl: Yes,if a person has IEBoster (http://www.paessler.com/IEB)running on their machine, hidden form fields are just a right-click away. You'd be better off putting a "ACTIVE" field in any table that you are going to allow users to delete from. That could inactivate the record, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:48 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
RE: [KCFusion] security question
Yes, https will basically eliminate the possibility of someone in the middle doing a malicious attack, but the best thing is to secure all the layers seperately, so if someone does get past what you might think would be the https secure layer, there's still other measures in place to catch them. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, August 12, 2003 10:24 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Ok wait. I have not thought this all the way though I think. The kind of attack was thinking of was where a hostile user taped the stream mid flow. Somehow between the end user and the server. Since the pages are encrypted with https then they (the hostile) should not be able to do anything yes? An if the bandit has the users authentication information then there really is not much you can do no? You know for a meeting idea I'd really like to hear what the big boys are doing security wise. All the books I have the security is pretty lame and basic. A. - Original Message - From: Luke Templin To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:05 AM Subject: RE: [KCFusion] security question You may want to do everything through a stored procedure(s). As part of that stored procedure you could create multiple sql queries one of which can be an audit trail. Another way is to present the material to be deleted as a table with a checkbox for each row.Then have the user select each individual record. Pass the information to a cftag that does the delete. this reduces the opportunity for a user to randomly type anything in and allows you to implement a validation routine. Another item to explore is to use the https if security is a concern. Can't say I have experience with it but given your description that might be a method to investigate. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:54 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Thats what I thought. Manually deleteing them does not exactly bring a smile to my face but it is feasable for us. But what about larger companies with like a gazillion records. Unless your telling me that they just have tons of minimum wage people that all they do all day is delete records. A. - Original Message - From: Kory Bakken To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:54 AM Subject: RE: [KCFusion] security question Adaryl: Yes,if a person has IEBoster (http://www.paessler.com/IEB)running on their machine, hidden form fields are just a right-click away. You'd be better off putting a "ACTIVE" field in any table that you are going to allow users to delete from. That could inactivate the record, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:48 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted ina hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A.
Re: [KCFusion] security question
Thats where I started. I was doing it via java script so I could ask the user if they really wanted to delete. But when I passed the function the encrypted value it did not like it for some reason. It was rendered all funny. The function looks like this script language=JavaScript function check(entry){ if (confirm(This will delete this entry. Proceed?)){ document.location = foo.cfm?entry= + entry; } else{} } /script Then I would call it with a href=javascript:check(#Encrypt(primaryKey, 'notTheRealKey')#Delete/a Which in turn comes out as a href=javascript:check((%WEDelete/a Totally breaks my code. A. - Original Message - From: Bruce Dunwiddie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:57 AM Subject: RE: [KCFusion] security question Well the checking in the database to make sure that the user is allowed to delete that record is a good step to leave in. As for the rest, I'd probably recommend passing an encrypted value of the record to delete along with the record id itself, so you can verify that they haven't just changed the id, and it won't matter if they can get access to the hidden encrypted value because they won't be able to submit the proper encrypted version to pass the validation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kory Bakken Sent: Tuesday, August 12, 2003 9:54 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] security question Adaryl: Yes, if a person has IEBoster (http:// www.paessler.com/IEB http://www.paessler.com/IEB ) running on their machine, hidden form fields are just a right-click away. You'd be better off putting a ACTIVE field in any table that you are going to allow users to delete from. That could inactivate the record, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] security question Im sorry I was in a hurry and should have explained this better. For the first time I am faced with allowing users to delete info from a database. I am trying to come up with a save method for doing that. In other words I don't want people to just type random numbers in a query string and start erasing stuff. Most of the measures I have come up with so far are easily defeated. I had considered putting the primary key of the tuple to be deleted in a hidden form field but if you can alter the info sent in a post request (and I think I read somewhere that you could) then that measure is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]On Behalf Of Adaryl Wakefield Sent: Monday, August 11, 2003 1:44 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject: [KCFusion] security question Is is possible to alter the information that is sent in the headers of a POST request? A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Worldwide User Group Meeting - September 3
Unfortunately, I can't tell you any more at this time...other than it will be big, and user groups world wide will be tuning in. Oh, and only those AT the meetings will be able to participate. Sorry, more info in a few weeks... :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Johnny Sewell Sent: Friday, August 08, 2003 6:32 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Worldwide User Group Meeting - September 3 Ryan, Since I don't see anything about it on the User Group page of Devnet I wondered about what they are going to discuss. Will it be Breeze or the 6.1 release of CF or something else? Johnny __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Worldwide User Group Meeting - September 3
Ryan, Since I don't see anything about it on the User Group page of Devnet I wondered about what they are going to discuss. Will it be Breeze or the 6.1 release of CF or something else? Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Hartwich Sent: Friday, August 08, 2003 5:52 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Worldwide User Group Meeting - September 3 Hi- I have some very exciting news. For the very first time in Macromedia history, the company has decided to do a worldwide user group meeting and our group is going to participate. Using Macromedia's latest communication solution, Breeze Live, our User Group will participate in the meeting in real-time over the web. In addition to seeing the presentation online, we will be able to ask questions and interact with other User Groups and Macromedia. We also plan a really great giveaway that night to be raffled off to those that attend. So please mark your calendars for Wednesday, September 3 at 6:00 PM. I will be sending out another email with the complete agenda closer to the event. We will be meeting in a conference room at UMKC (near the Plaza). Thanks! Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion File Security
Bruce: I am just guessing, but is it maybe that the files that you need to protect are the *.class files that MX produces and not the *.cfm files? Kory Bakken -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:11 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [KCFusion] ColdFusion File Security All: I hope you can provide me some guidance on the following issue and especially if my web host tech support is incorrect. I've run into an interesting security problem with ColdFusion. I am the web master for STFM.org We have protected various directories using our web hosts file permission interface on the control panel for our web site. For several directories we have set the user Everyone access to none for that directory and any files/sub directories in the directory. However, after moving to our new CF MX server, I noticed that the CF files in our protected directories are being served up even though the directory is protected (I checked to ensure it was still protected after the move). If you try to load a non-CF file (for example test.htm) that is located in the same protected directory, the server requests you provide a user name and password before it returns the file to your computer. The server does not do this with the CF file, it just returns the file. According to a phone conversation I had with one of our web host's tech support personnel late on 1 August, CF files are not protected by the file permissions settings on the Windows server since the CF MX server bypasses the web server to return the files to the browser. However, after consulting another very experienced ColdFusion Developer and checking the ColdFusion MX documentation (see http://download.macromedia.com/pub/coldfusion/documentation/cfmx_dev_cf_apps.pdf page 353) I've learned that basic HTTP authentication should protect CF files. I believe that the information I was given by the support technician to be incorrect. Removing the user Everyone's access in some of our sub-directories should also protect the CF files in those sub directories. Any information on your experience in using basic http authentication to protect CF files in a directory from being served up with the user entering a password and username would be appreciated. I really think the tech support is incorrect and there is some other problem on the web server. I don't want to use CFLOGIN or some other application login script if I don't have to. Thank You, Bruce Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] DateDiff in SQL Query
You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE CustomerRefer = #Affiliate_ID#AND CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and '#DateAdd('d',7,createODBCDate(now()))#' -Original Message-From: Robert [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff in SQL Query I am running into a problem and I can't figure out why. I know i've had this problem before with using CF functions inside of SQL queries, but I can never remember what it was the last time that fixed it, so I wanted to post this query: CFQUERY name="getcustomers" DATASOURCE="x"SELECT CustomerName, CustomerPin, CustomerRefer,CustomerEnrollmentDateFROM CustomersWHERE CustomerRefer = #Affiliate_ID#AND #DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')# = 0/CFQUERY I'm needing to run stats for affiliate programs and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't seem to be able to do anything other than generic day, month, etc. Anyhow, I get the following error: Error resolving parameter CUSTOMERENROLLMENTDATE Obviously I have the right name, but it bombs right there...if I change around my quotes and my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected 2. Anyone easily point out what i've got in the wrong place or what I am messing up because i'm at a loss. BTW, Affiliate_ID is from another CFOUTPUT from a query that this is all running inside of. Thanks, Robert
Re: [KCFusion] DateDiff in SQL Query
Kory, Thanks for the reply. I was able to figure out my mistake. It was my own fault of syntax and not having the quotes and such in the right place. I've abandoned that query, but I will say thanks to all who helped. Thanks, Robert - Original Message - From: Kory Bakken To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 8:10 AM Subject: RE: [KCFusion] DateDiff in SQL Query You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE CustomerRefer = #Affiliate_ID#AND CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and '#DateAdd('d',7,createODBCDate(now()))#' -Original Message-From: Robert [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff in SQL Query I am running into a problem and I can't figure out why. I know i've had this problem before with using CF functions inside of SQL queries, but I can never remember what it was the last time that fixed it, so I wanted to post this query: CFQUERY name="getcustomers" DATASOURCE="x"SELECT CustomerName, CustomerPin, CustomerRefer,CustomerEnrollmentDateFROM CustomersWHERE CustomerRefer = #Affiliate_ID#AND #DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')# = 0/CFQUERY I'm needing to run stats for affiliate programs and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't seem to be able to do anything other than generic day, month, etc. Anyhow, I get the following error: Error resolving parameter CUSTOMERENROLLMENTDATE Obviously I have the right name, but it bombs right there...if I change around my quotes and my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected 2. Anyone easily point out what i've got in the wrong place or what I am messing up because i'm at a loss. BTW, Affiliate_ID is from another CFOUTPUT from a query that this is all running inside of. Thanks, Robert
Re: [KCFusion] DateDiff in SQL Query
Well all my reference books are at work and as it is firday night and im on my way out the door to go party just taking a quick glance at it but (and I may just be missing a piece of the puzzle here) but since you are selecting out CustomerEnrollementDate in the query don't you have to assign it a value before you use it in the DateDiff function, or did you already do that and it does not show up in your snippet?A. - Original Message - From: Robert To: [EMAIL PROTECTED] Sent: Friday, August 01, 2003 11:02 PM Subject: [KCFusion] DateDiff in SQL Query I am running into a problem and I can't figure out why. I know i've had this problem before with using CF functions inside of SQL queries, but I can never remember what it was the last time that fixed it, so I wanted to post this query: CFQUERY name="getcustomers" DATASOURCE="x"SELECT CustomerName, CustomerPin, CustomerRefer,CustomerEnrollmentDateFROM CustomersWHERE CustomerRefer = #Affiliate_ID#AND #DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')# = 0/CFQUERY I'm needing to run stats for affiliate programs and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't seem to be able to do anything other than generic day, month, etc. Anyhow, I get the following error: Error resolving parameter CUSTOMERENROLLMENTDATE Obviously I have the right name, but it bombs right there...if I change around my quotes and my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected 2. Anyone easily point out what i've got in the wrong place or what I am messing up because i'm at a loss. BTW, Affiliate_ID is from another CFOUTPUT from a query that this is all running inside of. Thanks, Robert
RE: [KCFusion]
cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR" null="Yes" -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] I have need to update a table and set a value to NULL like UPDATE blah SET thisAttribute = nullValueHere WHERE someStuff = someOtherStuff so far I've tried cfset var = "" and cfset var = "NULL" and some other things but so far nothing. Anybody know right off the bat where I'm going wrong? A.
RE: [KCFusion]
If you do not use stored procedures, you could do this: UPDATE blah SET thisAttribute =cfif isdefined('var')#var#cfelseNULL/cfif WHERE someStuff = someOtherStuff The problem you had is that it reads: cfset var = "" as and empty string and cfset var = "NULL" as the actual string "NULL" -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] I have need to update a table and set a value to NULL like UPDATE blah SET thisAttribute = nullValueHere WHERE someStuff = someOtherStuff so far I've tried cfset var = "" and cfset var = "NULL" and some other things but so far nothing. Anybody know right off the bat where I'm going wrong? A.
Re: [KCFusion]
Yeah I actually tried cfset var = NULL first with no quotes cause I figured it would read it as the string NULL but it choked on that too. I was trying to make things as elegant as possible. My next attempt was to just write an if with two separate SQL statements like cfif var is "" run this statement cfelse run this statement /cfif but i had no clue you could embed ifs in query tags. Which is better from a speed standpoint? Choose a statement or embed the if?A. - Original Message - From: Kory Bakken To: [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:49 AM Subject: RE: [KCFusion] If you do not use stored procedures, you could do this: UPDATE blah SET thisAttribute =cfif isdefined('var')#var#cfelseNULL/cfif WHERE someStuff = someOtherStuff The problem you had is that it reads: cfset var = "" as and empty string and cfset var = "NULL" as the actual string "NULL" -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] I have need to update a table and set a value to NULL like UPDATE blah SET thisAttribute = nullValueHere WHERE someStuff = someOtherStuff so far I've tried cfset var = "" and cfset var = "NULL" and some other things but so far nothing. Anybody know right off the bat where I'm going wrong? A.
Re: [KCFusion] No CFUG meeting for July
At 05:04 PM 7/25/2003 -0500, you wrote: I am always looking for someone to present at a meeting. I am more than willing to assist you in preparing the content (technically as well as presentation skills). This is not rocket science, anyone can do it! Please, volunteer. Presenting helps you improve your technical and presentation skills while helping and impressing others. Well, tell use what you need. If you are looking for CF experts, I'm not your person! But if you are looking for other things - give me a list. I'd LOVE to come and show you some jewelry g Peggie Brown ((( ¸.-···- ^~~ ^ ( {ªYª} \ )_ `~-~/´ \,,/,,/ \,,,Í,,Í Brown Holdings LLC Group http://www.businesssights.com/BusinessSights.comhttp://www.businesssights.com/, Vision for your Business http://www.realgems.biz/RealGemshttp://www.realgems.biz/.biz, Real Gems at Real Low Prices 913.727.1794 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] ColdFusion Query Times Out
Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
Re: [KCFusion] ColdFusion Query Times Out
Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. cfquery datasource="#dsn#" name="GetSubmissions" timeout="260"select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#url.confid#"AND submissions.cancelled= cfqueryparam cfsqltype="CF_SQL_BIT" value="0"AND submissions.rejected= cfqueryparam cfsqltype="CF_SQL_BIT" value="0"order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname/cfquery Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 07/23/03 12:01PM Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion Query Times Out
You do realize the timeout attribute is in milliseconds? You are telling it to timeout after 260 milliseconds. -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:59 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. cfquery datasource=#dsn# name=GetSubmissions timeout=260 select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenter from submissions JOIN conferences on submissions.confid = conferences.confid JOIN categories on submissions.catid = categories.catid JOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionid JOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#url.confid# AND submissions.cancelled= cfqueryparam cfsqltype=CF_SQL_BIT value=0 AND submissions.rejected= cfqueryparam cfsqltype=CF_SQL_BIT value=0 order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname /cfquery Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] [EMAIL PROTECTED] 07/23/03 12:01PM Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* ***
RE: [KCFusion] Updater 3
Thanks. Its not looking like a problem with the Oracle setup. The same thing is occurring in Java. Jeff -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Updater 3 Jeff, I was unsuccessful at installing Updater 3 on one machine, but I think it was a windows problem. I had no problems on 2 other machines, but these were running MS SQL 2000 and not Oracle. I have not heard of any significant problems with U3 and Oracle, though I haven't been watching for them either. If you can survive this problem, Redsky (free upgrade) may fix it when it is available shortly. If not, see if you can uninstall U3 and move back to U2. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion Query Times Out
Title: Message Not an actual solution but you might try trimming down the query until you can get it to run, i.e. remove the order by and maybe some joins. Once its running add things back and see what seems to cause the timeout. Also, have you ran the query outside of CF to get an estimate of the time needed? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:13 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] ColdFusion Query Times Out TIMEOUT attribute in MX is now in seconds and not milliseconds as in CF 5. Also applies to each part of query, not the whole operation. Please refer to http://livedocs.macromedia.com/cf6docs/CFML_Reference/Tags-pt218.jsp Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 07/23/03 01:12PM The timeout parameter of the cfquery tag is in milliseconds in the help docs, so you've set it to timeout in 0.26 seconds. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bruce PhillipsSent: Wednesday, July 23, 2003 10:59 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. cfquery datasource="#dsn#" name="GetSubmissions" timeout="260"select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#url.confid#"AND submissions.cancelled= cfqueryparam cfsqltype="CF_SQL_BIT" value="0"AND submissions.rejected= cfqueryparam cfsqltype="CF_SQL_BIT" value="0"order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname/cfquery Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 07/23/03 12:01PM Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* ***
RE: [KCFusion] Updater 3
Jeff, I was unsuccessful at installing Updater 3 on one machine, but I think it was a windows problem. I had no problems on 2 other machines, but these were running MS SQL 2000 and not Oracle. I have not heard of any significant problems with U3 and Oracle, though I haven't been watching for them either. If you can survive this problem, Redsky (free upgrade) may fix it when it is available shortly. If not, see if you can uninstall U3 and move back to U2. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Web Based Forums
If you don't mind php, I think phpBB is one of the best things since sliced bread. Lee LangmackArt Director, Cerner Careers Cerner Corporation 2800 Rockcreek Parkway Kansas City, MO 64117 Direct Phone: 816.201.2698Fax: 816.571.2698 "Man is free at the moment he decides to be."~ Voltaire -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 1:24 PMTo: Subject: [KCFusion] Web Based Forums All: Anyone have a good recommendation for a Web Based Forum done in ColdFusion MX? I need to get one and install it for our web site. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. --
RE: [KCFusion] CF5 online docs
Sounds like a projectfun, fun were do I sign up!
Re: [KCFusion] CF5 online docs
Thanks Matt. Ryan also emailed me the link to the pdf version of the docs. http://www.macromedia.com/support/coldfusion/documentation.html - Original Message - From: Matt Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 07, 2003 8:59 AM Subject: RE: [KCFusion] CF5 online docs http://livedocs.macromedia.com/cf50docs/ -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:02 AM To: KCFusion Subject: [KCFusion] CF5 online docs If someone has CF5 installed on a dev machine would you be so kind as to pull up the docs and tell me what the url to the live docs on MM's website is. I have to present a comparison of CF5 charting features versus a third party tool and I currently have MX installed. Thanks for your help. Bryan LaPlante __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] CF5 online docs
Bryan, Which charting products are you working with? Tom Huff In a message dated 7/7/03 9:01:45 AM Central Daylight Time, [EMAIL PROTECTED] writes: http://livedocs.macromedia.com/cf50docs/ -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:02 AM To: KCFusion Subject: [KCFusion] CF5 online docs If someone has CF5 installed on a dev machine would you be so kind as to pull up the docs and tell me what the url to the live docs on MM's website is. I have to present a comparison of CF5 charting features versus a third party tool and I currently have MX installed. Thanks for your help.
Re: [KCFusion] CF5 online docs
http://www.jfree.org/jfreechart/index.html After learning that the charts are produced by sending a PNG or PDF doc back to the client I think that using flash to accomplish this task speaks a great deal more to the future than a static document type. I think it is kind of like when html first got started and the only thing you could do was send dynamic content to the client. I recommended to my client that they look at flash charting. I have looked on a few of the blogs and lightly searched the net for specialty charts written in flash but I am not finding a great deal of development in this area. I still think if someone can draw it, I can script it and we get a whole lot closer to dynamic charts using flash verses dynamic images. My thoughts. Bryan LaPlante - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 07, 2003 4:38 PM Subject: Re: [KCFusion] CF5 online docs Bryan,Which charting products are you working with?Tom HuffIn a message dated 7/7/03 9:01:45 AM Central Daylight Time, [EMAIL PROTECTED] writes: http://livedocs.macromedia.com/cf50docs/-Original Message-From: Bryan LaPlante [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 1:02 AMTo: KCFusionSubject: [KCFusion] CF5 online docsIf someone has CF5 installed on a dev machine would you be so kind as topull up the docs and tell me what the url to the live docs on MM's websiteis. I have to present a comparison of CF5 charting features versus a thirdparty tool and I currently have MX installed.Thanks for your help.
RE: [KCFusion] CF5 online docs
http://livedocs.macromedia.com/cf50docs/ -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:02 AM To: KCFusion Subject: [KCFusion] CF5 online docs If someone has CF5 installed on a dev machine would you be so kind as to pull up the docs and tell me what the url to the live docs on MM's website is. I have to present a comparison of CF5 charting features versus a third party tool and I currently have MX installed. Thanks for your help. Bryan LaPlante __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] OT: changing IP address in IIS4
I think the only reason to use the script is if you have so many virtual sites running on the existing IP that making the changes in the administrative interface would take too long. Ramsey At 02:03 PM 6/25/2003, you wrote: Off topic: We're planning to put a more powerful firewall between a Web server and the Internet. This will involve changing the IP address on the server (running IIS on NT4). My preliminary research suggests changing the IP with VB scripts (http://www.iisfaq.com/default.aspx?View=A292P=109). Any reason I can just do it with existing Windows tools like the administrative interface and system tools? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
Actually distinct applies to the whole select clause. Both "Select distinct table1.studentID, table2.goalID" and "Select table1.studentID, distinct table2.goalID" should return the same recordset. -Original Message-From: Boles, Mark E [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 24, 2003 12:18 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] an easy one also... SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID the distinct behavior... I believe this should pull back a distinct studentID meaningwhich ever goalID it come to first is the one you see unless ordered. You should only get 1 studentID per student on this distinct select. so your group by would look like: SELECT table1.studentID, table2.goalID (no need for distinct in a group by - in fact it should give you an error) FROM table1, table2 WHERE table1.studentID = table2.studentID HAVING(if desired)(doesNOT have to be part of the select) GROUP BY table1.studentID, table2.goalID ORDER BY table1.studentID, table2.goalID (If Desired) NOTE:The fields in the group by must match the selected. so if you say trim(field) in the select you must say trim(field) in the group by. else you will get an error like... _expression_ not a grouped _expression_ or something real helpful like that.. (sarcasm) Enjoy, -MEB -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 5:46 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy one Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP BY Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/23/2003 05:06 PM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject: RE: [KCFusion] an easy oneThe results should have 1 of each student in a group, ex: stu1/grpA stu1/grpB stu2/grpA stu2/grpCI believe the only way to get only 1 record for each student would be: SELECT DISTINCT table1.studentID FROM table1Keep in mind that I'm no SQL guru...Tyson-Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 4:14 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy oneYes- Original Message -From: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: Monday, June 23, 2003 3:56 PMSubject: RE: [KCFusion] an easy one Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy oneIts been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mai
RE: [KCFusion] an easy one
Adaryl, Mark has given you pretty good clarification (although DISTINCT in conjunction with GROUP BY can be used and won't give you error - but is not necessary as pointed out by Mark - it was an oversight on my part). The values within [ ] are the field names or table names (the key is to make sure that the SELECT clause must be carefully weaved in with the GROUP BY clause to meet ANSI standards - some rules for SELECT when using GROUP BY are a) only column names and/or b) aggregate functions and/or c) constants are permitted. Also, all column names within the SELECT statement must be reused within the GROUP BY clause. Keeping these simple rules in mind would eliminate lot of frustration. Real Life Examples --- Tthe following SQLs will work on a Windows plateform and you may need to tweak for specific database that you are using, Here is a complex GROUP BY query, SELECT [JobNumber] - [CostType] - [CostCode1] [CostCode23] [CostCode45] [CostCode67] AS [Job Cost Number], Sum(Hours.HoursWorked) AS [Sum Of HoursWorked], Submitted.WeekEndingDate FROM (Employee INNER JOIN Submitted ON Employee.EmployeeID = Submitted.EmployeeID) INNER JOIN Hours ON (Employee.EmployeeID = Hours.EmployeeID) AND (Submitted.EmployeeID = Hours.EmployeeID) GROUP BY [JobNumber] - [CostType] - [CostCode1] [CostCode23] [CostCode45] [CostCode67], Submitted.WeekEndingDate, Hours.EmployeeID, Hours.WeekEndingDate, Hours.TimeType, Hours.PayType, Hours.JobNumber, Hours.CostType, Hours.CostCode1, Hours.CostCode23, Hours.CostCode45, Hours.CostCode67, Submitted.EmployeeID, Employee.EmployeeID, Employee.FirstName, Employee.LastName, Employee.UserID, Submitted.WeekEndingDate HAVING (((Hours.EmployeeID) In (Select EmployeeID From Submitted Where WeekEndingDate Between #6/27/99# And #7/4/99#)) AND ((Hours.WeekEndingDate) Between #6/27/1999# And #7/4/1999#)); Here is a simpler example, SELECT Hours.PayType, [JobNumber] . [CostType] . [CostCode1] [CostCode23] [CostCode45] [CostCode67] AS [Job Cost Number], Sum(Hours.HoursWorked) AS [Total Hours] FROM Hours, Submitted WHERE (((Hours.EmployeeID)=[Submitted].[employeeID]) AND ((Hours.WeekEndingDate)=[Submitted].[WeekEndingDate] And (Hours.WeekEndingDate) Between #9/30/2001# And #9/30/2001#) AND ((Submitted.WeekEndingDate) Between #9/30/2001# And #9/30/2001#)) GROUP BY Hours.PayType, [JobNumber] . [CostType] . [CostCode1] [CostCode23] [CostCode45] [CostCode67]; Here is an example that makes use of DISTINCT SELECT LastName, FirstName FROM Employee WHERE EmployeeID In (Select DISTINCT(EmployeeID) From Hours Where WeekEndingDate = # weeksEndingDate #) AND ActiveStatus = True ORDER BY LastName, FirstName; Hope that helps, Girish Boles, Mark E [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 12:17 AM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one also... SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID the distinct behavior... I believe this should pull back a distinct studentID meaning which ever goalID it come to first is the one you see unless ordered. You should only get 1 studentID per student on this distinct select. so your group by would look like: SELECT table1.studentID, table2.goalID (no need for distinct in a group by - in fact it should give you an error) FROM table1, table2 WHERE table1.studentID = table2.studentID HAVING (if desired)(does NOT have to be part of the select) GROUP BY table1.studentID, table2.goalID ORDER BY table1.studentID, table2.goalID (If Desired) NOTE: The fields in the group by must match the selected. so if you say trim(field) in the select you must say trim(field) in the group by. else you will get an error like... _expression_ not a grouped _expression_ or something real helpful like that.. (sarcasm) Enjoy, -MEB -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP BY Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/23/2003 05:06 PM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one The results should have 1 of each student in a group, ex: stu1/grpA stu1/grpB stu2/grpA stu2/grpC I believe the only way to get only 1 record for each student would be: SELECT DISTINCT table1.studentID FROM table1 Keep in mind that I'm no SQL guru... Tyson
RE: [KCFusion] an easy one
Folks, One more rule that you should keep in mind when using GROUP BY is that although each column name in SELECT must appear in GROUP BY clause, the reverse is not required i.e. you can include column names in GROUP BY clause which are NOT in SELECT clause. Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 09:00 AM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one Adaryl, Mark has given you pretty good clarification (although DISTINCT in conjunction with GROUP BY can be used and won't give you error - but is not necessary as pointed out by Mark - it was an oversight on my part). The values within [ ] are the field names or table names (the key is to make sure that the SELECT clause must be carefully weaved in with the GROUP BY clause to meet ANSI standards - some rules for SELECT when using GROUP BY are a) only column names and/or b) aggregate functions and/or c) constants are permitted. Also, all column names within the SELECT statement must be reused within the GROUP BY clause. Keeping these simple rules in mind would eliminate lot of frustration. Real Life Examples --- Tthe following SQLs will work on a Windows plateform and you may need to tweak for specific database that you are using, Here is a complex GROUP BY query, SELECT [JobNumber] - [CostType] - [CostCode1] [CostCode23] [CostCode45] [CostCode67] AS [Job Cost Number], Sum(Hours.HoursWorked) AS [Sum Of HoursWorked], Submitted.WeekEndingDate FROM (Employee INNER JOIN Submitted ON Employee.EmployeeID = Submitted.EmployeeID) INNER JOIN Hours ON (Employee.EmployeeID = Hours.EmployeeID) AND (Submitted.EmployeeID = Hours.EmployeeID) GROUP BY [JobNumber] - [CostType] - [CostCode1] [CostCode23] [CostCode45] [CostCode67], Submitted.WeekEndingDate, Hours.EmployeeID, Hours.WeekEndingDate, Hours.TimeType, Hours.PayType, Hours.JobNumber, Hours.CostType, Hours.CostCode1, Hours.CostCode23, Hours.CostCode45, Hours.CostCode67, Submitted.EmployeeID, Employee.EmployeeID, Employee.FirstName, Employee.LastName, Employee.UserID, Submitted.WeekEndingDate HAVING (((Hours.EmployeeID) In (Select EmployeeID From Submitted Where WeekEndingDate Between #6/27/99# And #7/4/99#)) AND ((Hours.WeekEndingDate) Between #6/27/1999# And #7/4/1999#)); Here is a simpler example, SELECT Hours.PayType, [JobNumber] . [CostType] . [CostCode1] [CostCode23] [CostCode45] [CostCode67] AS [Job Cost Number], Sum(Hours.HoursWorked) AS [Total Hours] FROM Hours, Submitted WHERE (((Hours.EmployeeID)=[Submitted].[employeeID]) AND ((Hours.WeekEndingDate)=[Submitted].[WeekEndingDate] And (Hours.WeekEndingDate) Between #9/30/2001# And #9/30/2001#) AND ((Submitted.WeekEndingDate) Between #9/30/2001# And #9/30/2001#)) GROUP BY Hours.PayType, [JobNumber] . [CostType] . [CostCode1] [CostCode23] [CostCode45] [CostCode67]; Here is an example that makes use of DISTINCT SELECT LastName, FirstName FROM Employee WHERE EmployeeID In (Select DISTINCT(EmployeeID) From Hours Where WeekEndingDate = # weeksEndingDate #) AND ActiveStatus = True ORDER BY LastName, FirstName; Hope that helps, Girish Boles, Mark E [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 12:17 AM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one also... SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID the distinct behavior... I believe this should pull back a distinct studentID meaning which ever goalID it come to first is the one you see unless ordered. You should only get 1 studentID per student on this distinct select. so your group by would look like: SELECT table1.studentID, table2.goalID (no need for distinct in a group by - in fact it should give you an error) FROM table1, table2 WHERE table1.studentID = table2.studentID HAVING (if desired)(does NOT have to be part of the select) GROUP BY table1.studentID, table2.goalID ORDER BY table1.studentID, table2.goalID (If Desired) NOTE: The fields in the group by must match the selected. so if you say trim(field) in the select you must say trim(field) in the group by. else you will get an error like... _expression_ not a grouped _expression_ or something real helpful like that.. (sarcasm) Enjoy, -MEB -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP
Re: [KCFusion] Quotation Marks in Form Field Value
Hi Bruce, I would try (not sure if it will work, but it's an easy change to make) is to use the URLEncodedValue function on the field that potentially contains quotes. It should replace the quotes with the hex sequence: value=#URLEncodedValue(form.CATPurpose)# Hope that helps, Ramsey At 02:28 PM 6/24/2003, you wrote: I need to have quotation marksinserted into fields in our SQL Server 2000 tables when the user types them into the form field. However, what now happens is SQL Server 2000 cuts off the the text the user typed into the form field when it reaches the first quotation mark. My code for the insert is below. I believe this has something to do with quotation marks normally being used to surround the text that should be inserted. How do I make SQL Server 2000 include the quotation marks users type into the text box? Thanks for the help. Bruce cfquery datasource=#dsn# name=insertcat update categories set catname_internal = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATNAME_Internal#, catname_display = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATNAME_Display#, CATRequireProposal=cfif isdefined(form.CATRequireProposal) cfqueryparam cfsqltype=CF_SQL_BIT value=1 cfelse cfqueryparam cfsqltype=CF_SQL_BIT value=0 /cfif, CATPurpose = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATPurpose#, CATTime = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATTime#, CATAttendance = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATAttendance#, CATSubmission = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.CATSubmission#, CATUploadPapers=cfif isdefined(form.CATUploadPapers) cfqueryparam cfsqltype=CF_SQL_BIT value=1 cfelse cfqueryparam cfsqltype=CF_SQL_BIT value=0 /cfif cfif len(form.callforpaperfile) ,CatAcceptEmail=cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#file.serverfile# /cfif where catid = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#form.catid# /cfquery Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
Try DISTINCT instead of Unique Frederick Hale R.O.A.M. Support *Phone: 816-391-7745 * Fax: 816-391-5027 *E-Mail: [EMAIL PROTECTED] -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] an easy one
Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
maybe try. SELECT StudentID FROM Students WHERE StudentID IN ( SELECT StudentID FROM Class ) To find all the Students currently enrolled in Classes Justin Hansen ~~ Uhlig Communications Systems Engineer ~~ [EMAIL PROTECTED] 913-754-4273 Office 913-568-7961 Mobile ~~ -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] an easy one
Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP BY Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/23/2003 05:06 PM Please respond to CF-List To: [EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy oneThe results should have 1 of each student in a group, ex: stu1/grpA stu1/grpB stu2/grpA stu2/grpCI believe the only way to get only 1 record for each student would be: SELECT DISTINCT table1.studentID FROM table1Keep in mind that I'm no SQL guru...Tyson-Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 4:14 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy oneYes- Original Message -From: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: Monday, June 23, 2003 3:56 PMSubject: RE: [KCFusion] an easy one Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy oneIts been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]__The KCFusion.org list and website is hosted by Humankind Systems, Inc.List Archives http://www.mail-archive.com/[EMAIL PROTECTED]Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]To Subscribe mailto:[EMAIL PROTECTED]To Unsubscribe mailto:[EMAIL PROTECTED]__The KCFusion.org list and website is hosted by Humankind Systems, Inc.List Archives http://www.mail-archive.com/[EMAIL PROTECTED]Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]To Subscribe mailto:[EMAIL PROTECTED]To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] an easy one
also... SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID the distinct behavior... I believe this should pull back a distinct studentID meaningwhich ever goalID it come to first is the one you see unless ordered. You should only get 1 studentID per student on this distinct select. so your group by would look like: SELECT table1.studentID, table2.goalID (no need for distinct in a group by - in fact it should give you an error) FROM table1, table2 WHERE table1.studentID = table2.studentID HAVING(if desired)(doesNOT have to be part of the select) GROUP BY table1.studentID, table2.goalID ORDER BY table1.studentID, table2.goalID (If Desired) NOTE:The fields in the group by must match the selected. so if you say trim(field) in the select you must say trim(field) in the group by. else you will get an error like... _expression_ not a grouped _expression_ or something real helpful like that.. (sarcasm) Enjoy, -MEB -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 5:46 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy one Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one Looks like what he needs is SELECT DISTINCT... FROM table name WHERE GROUP BY Girish [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/23/2003 05:06 PM Please respond to CF-List To: [EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy oneThe results should have 1 of each student in a group, ex: stu1/grpA stu1/grpB stu2/grpA stu2/grpCI believe the only way to get only 1 record for each student would be:SELECT DISTINCT table1.studentID FROM table1Keep in mind that I'm no SQL guru...Tyson-Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 4:14 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy oneYes- Original Message -From: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: Monday, June 23, 2003 3:56 PMSubject: RE: [KCFusion] an easy one Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction of the statement SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID I still keep getting multiple tuples for one studentID A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy oneIts been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I tried SELECT Unique (id) as id but that did not work. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http
RE: [KCFusion] OT: CSS problem with A HREF
Well it didn't solve the problem, but it did cause some changes in the text alignment. Interesting... Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luke Templin Sent: Thursday, June 19, 2003 10:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF Here's a longshot experiment. Make sure the doctype has the full reference as in !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; instead of the commonly seen !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN Leaving out the http reference will leave IE and most browsers in Quirks mode. I found that text size changed when including http: making it easier to have a single css file for netscape and IE. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 8:24 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF That suggests there is something about my PC which kills the CSS. What a pain in the neck. I've been experimenting with various methods of fooling the bug, but no workaround yet. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan LaPlante Sent: Wednesday, June 18, 2003 5:15 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] OT: CSS problem with A HREF I have IE 6.0.26 and they both worked fine for me except for the visited thing which you mentioned you purposely left out of the example. Bryan - Original Message - From: Matt Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 5:07 PM Subject: RE: [KCFusion] OT: CSS problem with A HREF that is the same version I have, and they both looked and acted the same -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith Purtell Sent: Wednesday, June 18, 2003 5:04 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my version of IE6 (6.0.2800.1106), the one on the left starts out as a plain hyperlink (wrong) and only changes to white text inside a colored box during mouse over. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luke Templin Sent: Wednesday, June 18, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my version of IE6 they look fine. Both are words on a gray background that turns to dark red when hovering. What should they be doing? Luke Templin Computer Access -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:44 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my real version it includes visited. I just wanted to trim the sample for your viewing. Chad, thanks for checking it in other browsers. I very much appreciate that. I will create a workaround, since I have many users on IE6. Possibly use JavaScript to redirect. Thanks again! Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential
RE: [KCFusion] Version Control Evaluation
Title: RE: [KCFusion] Version Control Evaluation I am not sure what you mean by integrate with CFStudio. I am not sure if CFStudio has plugins to in effect have CSV a part of or extended feature for use in CFStudio. I do know there was such integration for other development tools. As for locked files... you could check out a file for read only when it was currently checked out. What I would typically do is check out for read only and then after the file was checked back in and I checked it out and lock it then I did a line comparison between the file I had checked out for read only and changed and the file I checked out for lock that had been checked back in. -MEB -Original Message-From: Bryan LaPlante [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 10:45 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Version Control Evaluation Does CVS integrate with CFStudio? Also CVS is version control but there does not seem to be the concept of check out where the file is locked by the current owner. - Original Message - From: Boles, Mark E To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:35 AM Subject: RE: [KCFusion] Version Control Evaluation I have also been very pleased with CVS. -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 18, 2003 10:44 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Version Control Evaluation I use CVS and like it. Works well for distributed projects where team members aren't on a LAN. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kory Bakken Sent: Wednesday, June 18, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Version Control EvaluationHas anybody out there ever done a formal evaluation of version control products for use with Coldfusion? If so would you care to share your results? Kory Bakken Nations Technical Services Prairie Village, KS [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Version Control Evaluation
Title: RE: [KCFusion] Version Control Evaluation It doesn't seamlessly integrate with CF Studio (or with DW MX, to my knowledge). It just manages the files externally using a separate check-in/check-out application. CVS doesn't use a file locking model. Instead, it does a very very good job of merging changes made in parallel. If folks check their changes in regularly, CVS does very well. (If people go for months without committing their changes, their checkin process will take a while and they may have to manually handle merge conflicts.) Visual SourceSafe may be a better option for what you want. -glenn -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bryan LaPlanteSent: Wednesday, June 18, 2003 10:45 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Version Control Evaluation Does CVS integrate with CFStudio? Also CVS is version control but there does not seem to be the concept of check out where the file is locked by the current owner. - Original Message - From: Boles, Mark E To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:35 AM Subject: RE: [KCFusion] Version Control Evaluation I have also been very pleased with CVS. -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 18, 2003 10:44 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Version Control Evaluation I use CVS and like it. Works well for distributed projects where team members aren't on a LAN. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kory Bakken Sent: Wednesday, June 18, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Version Control EvaluationHas anybody out there ever done a formal evaluation of version control products for use with Coldfusion? If so would you care to share your results? Kory Bakken Nations Technical Services Prairie Village, KS [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Version Control Evaluation
Title: RE: [KCFusion] Version Control Evaluation From what I understood from the CVS documentation, each developer would check out a version of their site before development began. I assume this would mean that each developer would have to havea web server,CF server, andaccess to each of his datasources on his client. Additionally, like Glenn stated, a developer could have a document checked out for long periods of time before checking it back in, causing problems with parallel development. I am correct in these assumptions? -Kory -Original Message-From: Glenn Crocker [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 1:27 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Version Control Evaluation It doesn't seamlessly integrate with CF Studio (or with DW MX, to my knowledge). It just manages the files externally using a separate check-in/check-out application. CVS doesn't use a file locking model. Instead, it does a very very good job of merging changes made in parallel. If folks check their changes in regularly, CVS does very well. (If people go for months without committing their changes, their checkin process will take a while and they may have to manually handle merge conflicts.) Visual SourceSafe may be a better option for what you want. -glenn -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bryan LaPlanteSent: Wednesday, June 18, 2003 10:45 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Version Control Evaluation Does CVS integrate with CFStudio? Also CVS is version control but there does not seem to be the concept of check out where the file is locked by the current owner. - Original Message - From: Boles, Mark E To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:35 AM Subject: RE: [KCFusion] Version Control Evaluation I have also been very pleased with CVS. -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 18, 2003 10:44 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Version Control Evaluation I use CVS and like it. Works well for distributed projects where team members aren't on a LAN. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kory Bakken Sent: Wednesday, June 18, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Version Control EvaluationHas anybody out there ever done a formal evaluation of version control products for use with Coldfusion? If so would you care to share your results? Kory Bakken Nations Technical Services Prairie Village, KS [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Version Control Evaluation
Title: RE: [KCFusion] Version Control Evaluation I always check in at least once a week, usually daily. For long-term development (like converting a site from access to sql server), CVS supports "branching" so I can check in without impacting the main trunk (until the "big merge" when the branch is ready to merge with the trunk). I usually have each developer set up with their own server and data instance, yeah. -glenn -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Kory BakkenSent: Wednesday, June 18, 2003 1:30 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Version Control Evaluation From what I understood from the CVS documentation, each developer would check out a version of their site before development began. I assume this would mean that each developer would have to havea web server,CF server, andaccess to each of his datasources on his client. Additionally, like Glenn stated, a developer could have a document checked out for long periods of time before checking it back in, causing problems with parallel development. I am correct in these assumptions? -Kory -Original Message-From: Glenn Crocker [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 1:27 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Version Control Evaluation It doesn't seamlessly integrate with CF Studio (or with DW MX, to my knowledge). It just manages the files externally using a separate check-in/check-out application. CVS doesn't use a file locking model. Instead, it does a very very good job of merging changes made in parallel. If folks check their changes in regularly, CVS does very well. (If people go for months without committing their changes, their checkin process will take a while and they may have to manually handle merge conflicts.) Visual SourceSafe may be a better option for what you want. -glenn -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bryan LaPlanteSent: Wednesday, June 18, 2003 10:45 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Version Control Evaluation Does CVS integrate with CFStudio? Also CVS is version control but there does not seem to be the concept of check out where the file is locked by the current owner. - Original Message - From: Boles, Mark E To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:35 AM Subject: RE: [KCFusion] Version Control Evaluation I have also been very pleased with CVS. -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 18, 2003 10:44 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Version Control Evaluation I use CVS and like it. Works well for distributed projects where team members aren't on a LAN. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kory Bakken Sent: Wednesday, June 18, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Version Control EvaluationHas anybody out there ever done a formal evaluation of version control products for use with Coldfusion? If so would you care to share your results? Kory Bakken Nations Technical Services Prairie Village, KS [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OT: CSS problem with A HREF
I'd say that's an IE6 bug only, IE5.5 works fine as well as Opera 6 and 7. I also tested it on Navigator 6 and it worked great. My advise for everyone would be to stay away from IE6 as long as you can. Like Windows Media Player 9, you either can not back up, or its a pain in the ass to do so. IE6 is yet another example of Microsoft taking java and changing it into c# (sharp? who's in charge of naming this?). __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] OT: CSS problem with A HREF
you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion] OT: CSS problem with A HREF I've encountered an odd CSS bug that doesn't show up in online CSS bug references. In the attachedfile, when I view with IE6, the right hand link is fine. But the left hand link doesn't look normal(inside a colored box) until I mouse over. I can correct this if I change the value of HREF to besomething other than a link to a Web site. Very strange. Any tips?Keith Purtell, Web/Network AdministratorVantageMed Operations (Kansas City)Email: [EMAIL PROTECTED]CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of theintended recipient(s) and may contain confidential and privileged information. Any unauthorizedreview, use, disclosure or distribution is prohibited. If you are not the intended recipient, pleasecontact the sender by reply email and destroy all copies of the original message.
RE: [KCFusion] OT: CSS problem with A HREF
In my real version it includes visited. I just wanted to trim the sample for your viewing. Chad, thanks for checking it in other browsers. I very much appreciate that. I will create a workaround, since I have many users on IE6. Possibly use JavaScript to redirect. Thanks again! Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan LaPlante Sent: Wednesday, June 18, 2003 4:36 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] OT: CSS problem with A HREF you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion] OT: CSS problem with A HREF I've encountered an odd CSS bug that doesn't show up in online CSS bug references. In the attached file, when I view with IE6, the right hand link is fine. But the left hand link doesn't look normal (inside a colored box) until I mouse over. I can correct this if I change the value of HREF to be something other than a link to a Web site. Very strange. Any tips? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OT: CSS problem with A HREF
In my version of IE6 they look fine. Both are words on a gray background that turns to dark red when hovering. What should they be doing? Luke Templin Computer Access -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:44 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my real version it includes visited. I just wanted to trim the sample for your viewing. Chad, thanks for checking it in other browsers. I very much appreciate that. I will create a workaround, since I have many users on IE6. Possibly use JavaScript to redirect. Thanks again! Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan LaPlante Sent: Wednesday, June 18, 2003 4:36 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] OT: CSS problem with A HREF you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion] OT: CSS problem with A HREF I've encountered an odd CSS bug that doesn't show up in online CSS bug references. In the attached file, when I view with IE6, the right hand link is fine. But the left hand link doesn't look normal (inside a colored box) until I mouse over. I can correct this if I change the value of HREF to be something other than a link to a Web site. Very strange. Any tips? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OT: CSS problem with A HREF
In my version of IE6 (6.0.2800.1106), the one on the left starts out as a plain hyperlink (wrong) and only changes to white text inside a colored box during mouse over. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luke Templin Sent: Wednesday, June 18, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my version of IE6 they look fine. Both are words on a gray background that turns to dark red when hovering. What should they be doing? Luke Templin Computer Access -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:44 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my real version it includes visited. I just wanted to trim the sample for your viewing. Chad, thanks for checking it in other browsers. I very much appreciate that. I will create a workaround, since I have many users on IE6. Possibly use JavaScript to redirect. Thanks again! Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan LaPlante Sent: Wednesday, June 18, 2003 4:36 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] OT: CSS problem with A HREF you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion] OT: CSS problem with A HREF I've encountered an odd CSS bug that doesn't show up in online CSS bug references. In the attached file, when I view with IE6, the right hand link is fine. But the left hand link doesn't look normal (inside a colored box) until I mouse over. I can correct this if I change the value of HREF to be something other than a link to a Web site. Very strange. Any tips? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. attachment: winmail.dat