RE: [KCFusion] session vars
There's no such thing as too many. It would totally depend on your application and how much RAM your server has. It would also depend on the amount of data in each variable. You just have to think ahead and try to limit session variable usage to variables that will be requested alot and would be much more efficient to be coming from memory as opposed to the database, and variables that wouldn't more aptly fit the application or server scope. I've loaded up hundreds of mbs of server memory just for fun testing on a dev box and it will work just fine, but you will definitely bring down your server if you max out the RAM. Use them sparingly when they make sense, not just out of laziness or lack of database, and you should be fine. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 18, 2003 1:08 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] session vars Just how many is TOO many session vars in an application? A.
RE: [KCFusion] session vars
Title: RE: [KCFusion] session vars you don't double quote the session variable name in structdelete, structclear, or structinsert. that's most likely your problem. I'd recommend just clicking on the word in cf studio if you have it and hitting f1 and looking at their examples. I don't know why wrox would have it listed like that. -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 18, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] session vars Thanks Ryan (and you too Bruce). I'm trained as an analyst not a computer scientist so the details of memory usage sometimes escapes me. Most of the questions I ask are generated from my trusty (albeit rather thick and thus hard to haul around) WROX CF 5 book and they will say stuff like use session variables sparingly with no real detail as to gauge sparingly. We get a blazing up 5000 visitors a month so I never really worried about my session vars till now but I'm working on a project that is likely to quantum jump the site traffic. But it looks like I still have nothing to worry about. I have not gotten struct delete or struct clear to work. I keep getting a cannot resolve to structure message. Code looks like cfscriptStructClear(session.email);/cfscript That's straight from the book and I have no clue how I could screw that up. I also used Mr. Prices suggestion and no joy there either. And while I'm in a prattling mood...did everybody know that Friends of Ed bit the dust along with some other publishers? I saw it in another list I'm on. A. - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 1:54 PM Subject: RE: [KCFusion] session vars Heck if I know, I have yet to actually build a website that had any significant loading on it :-) You might want to check your server settings (or your setup in the application.cfm) to see how long the session variables are good for before they expire. If its only 20-60 minutes, then how likely is it that you will have enough loading in 1 hour to cause a problem...Probably slim. I read a long time ago somewhere how to calculate variable ram usage, I might be wrong, but it was something like X number of bytes per letter of a string, etc. you could just as easily open up MS SQL, create a fake table with each variable name you are going to make into a session variable. Use nChar instead of Char (n tells it to use unicode, which uses twice the space as a normal character), etc. That way your estimates are worst case scenarios. If you add in a bit more space for the pointers and variable names, you might get a fair representation for variable size. For instance, if you have a string being saved as 20-40 characters, guess 40 characters of nChar, which takes 80 bytes. Add in say, 20? for the variable name and its pointer. 100B. Say you have 5 of these for a user (500). Now assume you have 15 variables with floating point values (4 bytes each I think, say, 16 for the name) 15*20=300. Add in a few integers, etc. You are probably at 1K for the user. Even if we double this to 2K for the user, that means 500 users in 1MB of ram. Say you have a server with 512mb of RAM, 170 for Windows, 40 for CFMX, 40 for SQL Server = 250. Leaving 250MB for session variables, coldfusion caching of queries, pages, source code, database queries, etc. Lets just say you have 50MB of memory for session variables, at 500 users per meg, that is 25 thousand users saving their variables in ram. I doubt seriously that most sites will get 25k+ users in 1 hour. I wouldn't worry about it. Sure, I can just hear the more anal of you questioning my very crude estimates :-), but for the average user, if they aren't saving queries, large record sets, and complex structures inside of session variables, my estimate is probably right on track. 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] CF on Netscape and IE
Title: RE: [KCFusion] CF on Netscape and IE blood, sweat, and tears. there's no easy way to go about it. if they, your bosses or whoever, for whatever reason, can't spend the time to go back and forth, back and forth, testing for both, then they won't be able to get them to work on both. sometimes, even things that have worked in the past for you, won't work when you try it again. the browsers are a whole different world when it comes to standards and how things work. -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 18, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] CF on Netscape and IE The CF apps I currently work on are written to work with Internet Explorer only. When the apps were written a few years ago and used with Netscape there were a few problems (mostly _javascript_ and cosmetic), so we decided to kick the users out of our apps if they try to access them using Netscape. We didn't have time to get them working on both browsers at the time. Now I'm looking into getting them working on Netscape. The group that maintains our CF server now, has indicated that CF can be used with Netscape or IE, but trying to apply patches for both browsers and getting the apps to work on both will not be possible. I'm just wanting to get some feedback about how others handle maintaining apps for Netscape and IE. Thanks, Beth Beth Minor Database Programmer Analyst-Principal University of Missouri System phone (573) 882-9242 [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] Printer Friendly Directory Listing
Title: Message if you say apply that to a table tag, and then have multiple tables each having that style, it will have a page break between them. of course, I'm sure it's only ie, but better than nothing. -Original Message-From: Chris Holdman [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 3:03 PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] Printer Friendly Directory Listing I have a directory listing pulling from a database and sorting by departments. Everything work great online, but some people are wanting to print it out...when they do sometimes the page break for printing occurs in the middle of a department listing and the second page does not have the department title. Is there a way to determine where a printing page break will occur and force the follwoing page to repeat the department title. Below is an example of what I mean and the code I currently use. Department Aaddressphone # - namephone # - namephone # - name Department Baddressphone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - name [page break]Department Baddressphone # - namephone # - namephone # - name DepartmentCaddressphone # - namephone # - namephone # - name cfoutput query="list" group="Department" bfont size="+1"#Department#/font/bbr #building#br hr align="left" width="300" cfoutput #Ext# - b#Name#/bbr /cfoutput p/cfoutput Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED]
RE: [KCFusion] storing files
I'm
pretty sure there's a file size limit as to how much you can store in the
database. You will obviously cause some overhead when loading these files from
the server as compared to loading natively through just iis. You will also ramp
your database file size. In general I find it a very bad idea. Other than it
being the easy solution as you put it, I'm not really seeing the rough part of
the tradeoff of just saving the path to the images. I don't see it as being a
complex algorithm to make all the files unique when cffile already has the nice
feature of makeunique for naming conflicts, unless you are wanting to save it
with a relatively similar name as the makeunique likes to make up it's own, but
then you'd just have to get cffile.serverfile and save it in the database. The
only other problem I could possibly forsee is if the whole app or file server
picks up and moves, then the paths in the database will have to be updated.
Here's the code to upload it to a unique name that's similar to the original if
that helps. Also, MX by default uses very similar logic to uniquely name
uploaded files by default so you don't even have to worry about
it.
cffile action="" filefield="someformfield"
destination="#path#"
nameconflict="MAKEUNIQUE"cfset wanted =
cffile.clientfilenamecfset ext =
cffile.clientfileextcfset attempt =
wantedcfif cffile.serverfilename is not
wantedcfset try =
1cfset saved =
cffile.serverfilecfloop
condition="fileexists('#path##attempt#.#ext#')"cfset
attempt="#wanted##try#"cfset try = try
+
1/cfloopcffile
action="" source="#path##saved#"
destination="#path##attempt#.#ext#"/cfifcfset
form.someformfield= "#attempt#.#ext#"
-Original Message-From: Adaryl Wakefield
[mailto:[EMAIL PROTECTED]Sent: Monday, March 10, 2003 10:36
AMTo: [EMAIL PROTECTED]Subject: [KCFusion] storing
files
I have a project where people can track their
progress though a training program. One of the things they need to do is view
images that they uploaded to our server and there are a couple of other files
that relate to them and them only.
The thing I'm agonizing about is rather to store
the files (gifs and pdfs) in directories and store the path to the files in a
database and comingup with some sort of elaboratealgorithm to make
sure all the files had uniquenames OR just storing the gifs and pdfs in
the database itself. I'venever actually done the latter but I have seen
it donewith images never with pdfs. The latter method seemseasier
to me but I read that actually putting the files in the DB creates a
performance hit.
Opinions? Wisdom anyone care to
share?
Win 2k Server
CF5
SQL Server 2k
A.
RE: [KCFusion] storing files
I don't necessarily disagree, but there's a difference here. We all have to admit that modern operating systemsalready basically have a database that stores files, it's just that that file system database is very native to the operating system, as compared to a database that is installed on top of that file system and storing files inside it as files that are being stored inside the other, that makes for the inefficiencies. You need to cut back on the layers when you can. Now if something comes along that removes the layer difference between two options, then the inefficiencies no longer is part of the argument. -Original Message-From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]Sent: Monday, March 10, 2003 11:21 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] storing files Actually, putting all the files in the SQL or Oracle DB is exactly where the world is headed. The next version of Windows Server (after the 2003 version that comes out in 7 weeks) will use MSSQL Server for it's file system. Oracle already has a bunch of products based on using the DB as your file system, including an explorer interface, etc... We haven't looked at this since CFMX, but storing the files in the DB in CF 4.x/5.x was a real pain. ASP/ASP.NET have a lot more finite control over this. Robin Greenhagen President GSIhttp://www.gsi-kc.com/
[KCFusion] include vs custom tag
Title: include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
RE: [KCFusion] include vs custom tag
Title: include vs custom tag I'm seeing it on one of our test servers as .5 ms avg to run an include, and 1 ms to run a custom tag. Can anyone else verify that the custom tag would take about twice the time? -Original Message-From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 10:29 AMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
RE: [KCFusion] include vs custom tag
Title: include vs custom tag I'll leave the answer currently to simply changing the basic idea of fusebox with all the action based includes, to using action based custom tag calls instead. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:02 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] include vs custom tag Curious. If you have time, can you explain what you mean exactly when you say you are going to use custom tags for the framework? A. - Original Message - From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Thursday, March 06, 2003 10:29 AM Subject: [KCFusion] include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
RE: [KCFusion] include vs custom tag
Title: include vs custom tag I'm not changing fusebox. We're creating our own framework. We're changing the overall idea behind fusebox. -Original Message-From: Matt Jones [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:08 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] include vs custom tag what version of fusebox are you changing? -Original Message-From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:11 AMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] include vs custom tag I'll leave the answer currently to simply changing the basic idea of fusebox with all the action based includes, to using action based custom tag calls instead. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:02 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] include vs custom tag Curious. If you have time, can you explain what you mean exactly when you say you are going to use custom tags for the framework? A. - Original Message - From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Thursday, March 06, 2003 10:29 AM Subject: [KCFusion] include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
RE: [KCFusion] include vs custom tag
Title: include vs custom tag well, we would probably use cfmodule instead of the custom tags if custom tags win this discussion, so I'm not really worried about that part. your viewpoints on using cfmodule instead of cfinclude however are interesting. -Original Message-From: Glenn Crocker [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:23 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] include vs custom tag I've built some substantially huge CF sites, and using cfmodule instead of cfinclude wherever you can is critical. Execution time is probably not the key issue, really, it's development time. If you can build the site more reliably, faster, and cheaper, a half millisecond per page is irrelevant. I've spent a huge amount of time converting an old side-effect-riddled cfinclude-style site to cfmodule, and it's paying dividends every time we do it. I wouldn't advise going crazy with full-on custom tag madness. In particular, hosting sites that rely on first-class custom tags (as opposed to cfmodule) can be difficult. For small enough sites, this kind of thing might not be a consideration, but if you're looking at over a hundred .cfm files, cfmodule will save your sanity. -glenn -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dunwiddie, BruceSent: Thursday, March 06, 2003 10:29 AMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] include vs custom tag We're still using cf 4.5 sp2. We're currently having a disagreement about whether to define our new framework for a site based on custom tags for each page basically, or the same thing using includes instead. I personally think the custom tags are a complete necessity, because of variable scoping, but I need to know the true benchmarking difference that people have seen when using one vs the other, or just in a per call difference in milliseconds per call, if anyone happens to know it or can point me to somewhere with the stats.
[KCFusion] http file uploads
Title: http file uploads we have the need to do some large http file uploads. I seem to remember some limitations, especially on macs. does anyone know these limitations that we would run into offhand?
RE: [KCFusion] March Meeting questionnaire - Contribute demo
Title: RE: [KCFusion] March Meeting questionnaire - Contribute demo ryan, for those of us who don't really pay any attention to news events at all of the software companies, can you explain what mm contribute is? I currently have no idea and would have to look it up and probably wouldn't get a good definition very easily. also, I was TOLD by the wife to ask you to have monthly meetings on wednesday instead of tuesday if possible, heh, so I think my official vote if you're counting is for the wednesday option. location really doesn't matter much to me, any would be fine, but I would think max 10 would be kind of limiting, so max 20 atleast to be safe. -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 27, 2003 2:08 PM To: [EMAIL PROTECTED] Subject: [KCFusion] March Meeting questionnaire - Contribute demo March Meeting - Contribute I am working on putting together our March meeting. It will be presented by Brad Miller of Accesszone Design and will be an introduction/demo on using Macromedia Contribute, including how to install/configure it from the administrator/server point of view, basic features and the benefits of using it. We are looking at 2 dates to hold this, Tuesday, March 17th or Wednesday the 18th. Likewise, we have 4 possible locations that have been volunteered in the past. Please let me know at [EMAIL PROTECTED] if you are interested and available in coming. Do you prefer the 17th or 18th? Which location works better for you? UMKC Administration building, 50th Oak, just east of the Plaza - (8 small room, 50 large) College Antioch (10 for fancy room, 20 for regular conference room) College Metcalf (unknown capacity) 130th Metcalf (max capacity 10) Thanks, Ryan [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] What Contribute is - synopsis
Title: RE: [KCFusion] What Contribute is - synopsis thanks for the info. -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 27, 2003 2:48 PM To: [EMAIL PROTECTED] Subject: [KCFusion] What Contribute is - synopsis From MM's site Macromedia Contribute is the easiest way to update content for any HTML website, including sites built in Macromedia Dreamweaver, Microsoft FrontPage, and other web tools. With Contribute, non-technical users can make changes while automatically respecting site standards for style, layout, and code in minutes-without knowing HTML Essentially, it is a dumbed down version of Dreamweaver, that facilitates minor text and graphic updating of websites by non-techies. Administrators, through Contribute or Dreamweaver can setup permissions/security for their website as well as marking which part of pages can and can't be modified by others. Then, through a simple $100 interface (Contribute), average PC users can update the text on their sites (both static and to some extent dynamic) without fear of breaking style sheets, look and feel, server side code, etc. I believe it is intended as a maintenance mechanism versus a website design/creation tool. Many organizations have a need for the whole group to be able to publish changes to their site, but don't want the complexity or risk associated with them having access to the root .cfm, .html, .php, etc. files. __ 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] Uploading file from Web form
Title: RE: [KCFusion] Uploading file from Web form ok, I have one other horribly obnoxious and rather obscure bug I know about with iis. if the file that you're uploading is like a plain text file, and has 2 blank lines with just carriage return characters on them, iis treats that as the end of request marker and will cut the file there. so, if your file begins with 2 blank lines, it's possible the file never even starts, although I would think it would still create a blank file on the server. have you had a chance to try all the cfcatch variables? you could always just take out the try and if an error happens, cf should catch it and output the message to you. if all of this doesn't help, I'd say go back and make absolutely positively sure that your html is as posted below and that there are no typos, especially in the enctype. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Uploading file from Web form I went back to the server and made sure we had permission on both the target directory and the temp directory. Then I tested my file upload again. Same as before; no result and no error message. By the way our CF server runs under a special network-level account, and I made sure that account was listed is the directory permissions. 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]]On Behalf Of Dunwiddie, Bruce Sent: Wednesday, February 26, 2003 2:37 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Uploading file from Web form It seems like this has been discussed in the group before, but the main security difference I know of when using 2k is that the security no longer allows local users to pass through as network users if the username and password are the same, so you have to either make sure they're network accounts that are logged in, or make sure to authenticate to the network before doing anything. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 2:21 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Uploading file from Web form Hmmm, interesting. We recently moved this site from NT 4 to Windows2000 and have experienced strange permission problems. For example I can no longer use the LAN to move new Web pages onto the server. I have to use FTP instead. We haven't been able to figure it out. So this CFFILE problem may be related to that. I'll also try your CFCATCH 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. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dunwiddie, Bruce Sent: Wednesday, February 26, 2003 2:09 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Uploading file from Web form sounds to me like a permissions issue with saving a file to that directory. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 2:02 PM To: KCFusion (E-mail) Subject: [KCFusion] Uploading file from Web form A function I've used many times before isn't working, and I'm not sure what the problem is. We have a Web form allowing users to upload files to our Web server. Using the standard field format ... FORM action="" method=post ENCTYPE=multipart/form-data INPUT TYPE=FILE NAME=FileName SIZE=45 ( other fields, submit button, etc. ) and at the receiving end is more standard format ... CFTRY CFFILE ACTION=""> FILEFIELD=FileName DESTINATION=C:\path_here NAMECONFLICT=OVERWRITE CFCATCH TYPE=Any CFOUTPUT#CFCATCH.message#/CFOUTPUT /CFCATCH /CFTRY This worked before but this time the file never gets to its final destination. I wasn't even getting error messages until I inserted some diagnostic code (CFFILE.AttemptedServerFile, CFFILE.ClientFile, etc). Every one of the diagnostics came up empty; no value at all. The CF server debug output sa
RE: [KCFusion] CFMX Extended Path Info Processing
I think this is the pattern in the xml file that you're missing. I've seen it listed in several different sources over the past couple of months in response to the same problem although I have not ever attempted it. servlet-mappingservlet-nameCfmServlet/servlet-nameurl-pattern*/url-pattern/servlet-mapping -Original Message-From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 7:34 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] CFMX Extended Path Info Processing On previous versions of CF, we often smoothed out the URL for search optimization purposes to something like: http://www.site.com/page.cfm/order27/user234 rather than http://www.site.com/page.cfm?order=27user=234 Well now we are moving these sites to MX and are having a hard time getting the server to process the smoothed version through the CFMX engine... We have been through this article http://www.macromedia.com/v1/Handlers/index.cfm?ID=23258Method=Full and have verified that we have: servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.cfm/*/url-pattern /servlet-mapping in our web.xml file. Any luck from anybody else? Darryl where are you man :) Win2K, IIS5, CFMX Pro with all the patches. Thanks, Robin
RE: [KCFusion] same field names
the best thing would probably be to use the aliasing in the query as opposed to renaming the column in the table like this... select parentTable.state as parent_state, childTable.state as child_state from parentTable, childTable where something = something then you can use queryname.parent_state and queryname.child_state in the page, and those names only affect that page and not that database itself. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28, 2003 4:01 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] same field names It does not happen too often but every blue moon or so I have a field that is named the same in two related tables. Usually I just rename a field and go about my day. Nobody but me here really knows what I'm up to anyway. Today I was making some tables and wound up with this: parentTable.state childTable.state In the parent table the state is stored in full. In the child table the state is stored as the two letter abbreviation for addresses. The problem that I usually go right around is the fact that to reference a result in a query you say: queryName.state but you can't specify which state you want. I preparation for the day when I may have to answer to someone and can't just rename a field, I was wondering if there was a way to actually reference a field in cfoutput querythat I was not privy to. A.
RE: [KCFusion] file property
Title: RE: [KCFusion] file property It's being sent to us from another company. It is being exported from their db which could be any db on any os. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property How is the data file being created? Is is being exported from another DBMS? Is it getting generated through a program? Dunwiddie, Bruce To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] BDunwiddie@henry cc: wurst.com Subject: RE: [KCFusion] file property Sent by: CF-List-owner@kcf usion.org 01/24/03 03:42 PM Please respond to CF-List There's got to be something else, something akin to file attributes. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 3:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property If there is no special header, then the only way Windows knows how to handle a file is by looking at the file name extension (doc, html, pdf, cfm, etc.). Of course that can vary from one machine to another. 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]]On Behalf Of Dunwiddie, Bruce Sent: Friday, January 24, 2003 1:50 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] file property In hex edit mode, the files are the exact same as far as I can see, but I still need to spend some more time comparing, but definitely no headers at the beginning of the data. That's why I'm assuming it's something more low level. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 1:12 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property Is there a section near the top that might be a header containing that kind of information? 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]]On Behalf Of Dunwiddie, Bruce Sent: Friday, January 24, 2003 12:13 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] file property I've got a problem that is currently just beyond my knowledge of file properties and encoding types and all that fun. I've got a data file that needs to be imported into sql server and sql server doesn't like it for some odd reason. After playing around with it a bit, we've found that if we open it up in a plain text editor and copy/paste the contents over to another plain text file and save that file, it works just fine. Also, if the original file is opened in UltraEdit, it's by default being opening in hex edit mode as opposed to plain text mode which is how the second file gets opened and how most plain text files get opened in UltraEdit. What is it about this file that is causing this? Is it some form of file property specifying the encoding type? Is this a property I can change using code? Any help or suggestions would be appreciated. --- [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/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] file property
Title: RE: [KCFusion] file property The byte order seems to be the same. The file ending is the same. There's no cr's in the file at all. I did however find the problem. I'm not sure what it means, but the difference between the original file and the second file is that the original file actually has 0 value bytes in the file, and the second file has these values converted to 20h or 32 dec, which is a space. I bet if I made a program that just read in bytes and converted all 0's to 20's, it'd work just fine. Thanks for the help. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003 4:12 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] file property UNIX and MSDOS used to have an issue with the order within a given byte. One would have 12 (hex) and the other 21. I haven't worked with either at the byte level in a while so I'm not sure its still an issue. -Original Message-From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003 3:56 PMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] file property It's being sent to us from another company. It is being exported from their db which could be any db on any os. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property How is the data file being created? Is is being exported from another DBMS? Is it getting generated through a program? "Dunwiddie, Bruce" To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] BDunwiddie@henry cc: wurst.com Subject: RE: [KCFusion] file property Sent by: CF-List-owner@kcf usion.org 01/24/03 03:42 PM Please respond to CF-List There's got to be something else, something akin to file attributes. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 3:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property If there is no special header, then the only way Windows knows how to handle a file is by looking at the file name extension (doc, html, pdf, cfm, etc.). Of course that can vary from one machine to another. 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]]On Behalf Of Dunwiddie, Bruce Sent: Friday, January 24, 2003 1:50 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] file propertyIn hex edit mode, the files are the exact same as far as I can see, but I still need to spend some more time comparing, but definitely no headers at the beginning of the data. That's why I'm assuming it's something more low level. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 1:12 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property Is there a section near the top that might be a header containing that kind of information? 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]]On Behalf Of Dunwiddie, Bruce Sent: Friday, January 24, 2003 12:13 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] file propertyI've got a problem that is currently just beyond my knowledge of file properties and encoding types and all that fun. I've got a data file that needs to be imported into sql server and sql server doesn't like it for some odd reason. After playing around with it a bit, we've found that if we open it up in
RE: [KCFusion] Encrypted URL and JS
Title: RE: [KCFusion] Encrypted URL and JS this would be the result using ron's advice. A HREF="" ', \', all)#') Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a _javascript_ error. Ron if I want to use your idea I'll need to use _javascript_ to escape the quote marks. Not too difficult but more complicated that I originally planned. 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]]On Behalf Of Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=""> Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function. --- [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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Encrypted URL and JS
Title: RE: [KCFusion] Encrypted URL and JS The error to me looks like it calling an escape sequence that doesn't exist, like \E or whatever. We can just keep having fun with this like this... only problem is that I know from experience that encrypt in cf puts a chr(10) at the end of the encrypted value, and I can't currently think of a way to pass that through the url, but maybe someone else can. A HREF="" \, \\, all), ', \', all)#')Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:58 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Yes, and the replace function happens on the server. I tested this; it goes to the browser at client side and malfunctions. (See attached gif screen capture of what IE is doing.) This is why I would have to use a _javascript_ replace if I were to continue down this path. Thanks 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]]On Behalf Of Dunwiddie, Bruce Sent: Thursday, January 23, 2003 10:30 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Encrypted URL and JS this would be the result using ron's advice. A HREF="" ', \', all)#')Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a _javascript_ error. Ron if I want to use your idea I'll need to use _javascript_ to escape the quote marks. Not too difficult but more complicated that I originally planned. 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]]On Behalf Of Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=""> Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function.
RE: [KCFusion] Local Java Training?
Title: RE: [KCFusion] Local Java Training? This company donates quite a bit to the local java user's group and are pretty nice people, but I've never taken any classes from them. They took over after conseva. They're at 8700 State Line. http://www.fosstraining.com/ -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 2:28 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Local Java Training? Does anyone on this list know where in KC I can get trained in Java in 1-2 weeks? I need to sign up for a course and get going fast. Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 Office 816-695-4045 Mobile -- __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion and JSP pages
I found this article very interesting on this topic and several related issues. http://www.macromedia.com/desdev/mx/coldfusion/articles/java.html -Original Message-From: Chris Holdman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 11:29 AMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] ColdFusion and JSP pages I have a situation where I am need to include a cfm page into a jsp pageI have tried the %@ include file="file.cfm"% but this does not work becuase the jsp page tries to translate the Cold Fusion code into java code. Is there a way to pass the results of a cfm page into a jsp page instead of just inserting the code into the jsp page? Christopher V. Holdman [EMAIL PROTECTED]
RE: [KCFusion] a design question (off topic)
don't use type="submit" for onclick actions. I think ns is probably the reason I've made this rule but who knows. try either making it a type="button" or using the onsubmit of the form instead of the onclick of the submit. you shouldn't have any problems with either of those. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 4:13 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] a design question (off topic) I've hit an odd issue. I have a simple submit button that calls a js function when clicked. The problem is it does not work in Netscape6 (go figure). The buttons don't even respond to mouse clicks or anything its all very odd. This is not normally part of my job (graphics, yik)and I know some of you do this full time. The tag looks like this: input type="Submit" name="email" value="Go" Anybody see anything glaringly wrong with it? A.
RE: [KCFusion] a design question (off topic)
you have this line... span img border="0" src="" align="center" width="520" height="470"/span and when I view the page in ns 4.7, that image is actually sitting on top of the text on the page, and most likely sitting on top of the form buttons also, which is noticeable with how half of the text at the top of the page is missing where that image is, so although you can see the form buttons, it's probably actually the image itself getting the onclicks. first off, try commenting out the span tag and see if the form works. my bet is yes. and if it does, then you might be able to get some help on how to get ns to respond better to z-index and absolute positioning and such, but I normally stay far far away from usage like that for just such reasons. if I'm wrong, and after commenting out that span tag, the buttons still don't respond, then I spose I can take another look at it and see if I can find some other possible conflict. -Original Message-From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 4:31 PMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] a design question (off topic) do you have a url where I could see this at? do you have javascript turned on? have you tried typing javascript: into the url to see if there was a javascript error? -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 4:27 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] a design question (off topic) They were orginally type=button but i changed it thinking that was the issue but neither worked. I just now changeditsimple submit. Nothing fancy at all just a submit button that does nothing and it just sits on the page. Youcan see it butit will not respond to users at all. A. - Original Message - From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Wednesday, December 04, 2002 4:17 PM Subject: RE: [KCFusion] a design question (off topic) don't use type="submit" for onclick actions. I think ns is probably the reason I've made this rule but who knows. try either making it a type="button" or using the onsubmit of the form instead of the onclick of the submit. you shouldn't have any problems with either of those. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 4:13 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] a design question (off topic) I've hit an odd issue. I have a simple submit button that calls a js function when clicked. The problem is it does not work in Netscape6 (go figure). The buttons don't even respond to mouse clicks or anything its all very odd. This is not normally part of my job (graphics, yik)and I know some of you do this full time. The tag looks like this: input type="Submit" name="email" value="Go" Anybody see anything glaringly wrong with it? A.
RE: [KCFusion] Server Problem
Title: RE: [KCFusion] Server Problem as for that error message, you can see what is somewhat causing it in this article http://support.microsoft.com/default.aspx?scid=KB;en-us;q226494 under the heading of Collect Timeout. I don't think that will help you resolve your problem any, but it might ring a bell with you or something. -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:21 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Server Problem One of my websites (there are about 10 on the server) runs fine for about 6-8 hours maybe longer and then the images all come up broken. I have been running down errors in the Event Viewer and CF Logs I solved most of them but the images still break. When this happens performance of the site is not affected and the other sites are fine. This box has Win2k SP3 IIS 5 CF 5 SQL2k WarFTP The only other error in the Event Viewer is The timeout waiting for the performance data collection function .NET CLR Data in the C:\WINNT\system32\netfxperf.dll Library to finish has expired. There may be a problem with this extensible counter or the service it is collecting data from or the system may have been very busy when this call was attempted. Anyone else seen this and has a fix? Rick __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] FW: sql server help please
Title: sql server help please Daryl to the rescue. Now running in 2-3 seconds. Thanks Daryl. -Original Message-From: Daryl Banttari [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 1:32 PMTo: Dunwiddie, BruceCc: LaPlante, BryanSubject: Re: sql server help please Ack! Run-on SQL statements make me cringe... I reformatted it a bit for maintainability. It sounds like SQL Server may be using a nested loop join to implement the IN clause, instead of a merge join. While this would be much faster for very large tables that are indexed, it's killing us at the bottom end of the threshold. We can force a merge join thusly: cfquery ... select distinct mr.mail_row_idinto ##bad_idsfrom t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10)) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and not exists (select 1from ##bad_idswhere mr.mail_row_id = bad_ids.mail_row_id)/cfquery By prefixing the table name with a single pound sign (the##s are escaped to single #s by CF), we are creating a connection-oriented temporary table (a temporary table that only exists for the current sql server connection)for use by the nextstatement in the query. (SQL Serverallows multiple statements in the same cfquery.) If you wanted to be extra tidy, you could run another cfquery to drop the temporary table, but if you don't, the table willget dropped when the connection is dropped, anyway. (It's self-cleaning.) Does this help? (If it does, please post the solution to the list. I've been really busy with a move lately, so I haven't had a chance to post.) --Daryl
RE: [KCFusion] messed up indexes in sql server
Title: RE: [KCFusion] messed up indexes in sql server I had looked at the reindex command, but wasn't prepared to do one for each index as the syntax appeared, but that command without any other attributes will reindex the entire db? I've also never seen the runtime index declaration syntax you suggested, so I'll play with that. I'll let you know if I get anywhere with it. -Original Message- From: Chris Stallo To: [EMAIL PROTECTED] Sent: 11/30/02 6:19 AM Subject: Re: [KCFusion] messed up indexes in sql server Have you tried doing a reindex of the entire database? DBCC REINDEX I think. I realize this takes quite a while, but we do this periodically to keep things straightened up. What we've seen in the past when dealing with SQL Server is the stored procs are using the correct indexes on the develoment server, but upon moving them to the production server they use totally different ones that make absolutely no sense. Looking at the query plan seems to indicate that may be the case. Have you tried hard coding the indexes on the production server to use? It goes something like this. select count (mr.mail_row_id) as rows from t_mail_row mr (INDEX = MY_INDEX) where mr.mail_list_id = 31 and mr.mail_row_id not in ( select distinct mr.mail_row_id from t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10)) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' We've found that we've had to do this in order for them to use the same indexes. It's pretty easy to see which indexes to use based on the query plan from the development server. Good luck and let me know how it goes. Chris --- Dunwiddie, Bruce [EMAIL PROTECTED] wrote: I'm really kind of stuck on this one and it's a bit out of my realm, but we really need to find a solution. Basically, a query that's been basically been running fine on the dev server was moved to the production server along with a few database changes, renaming of a couple tables and keys and such, and now the query doesn't even come back. The normal run time of the query should be less than 30 s, and I ran the query in production, using query analyzer, and had to stop execution at over 14 m. I then started breaking the query up into parts to see if I could find some problem with the indexes from the move to prod, and got down to one part that was running in 12 s, and like 90% of the time was being spent on a clusted index seek, which made no sense to me at all. Out of desperation, I removed the clustered index, and reran the query, and this time it took only 1 s. I then reapplied the clustered index, reran the query, and it stayed at 1 s, so I went back to the whole query, and reran it, and it still didn't return after several minutes. I then went back to breaking up the query, and this is where I get lost, and reran all the seperate parts of the query, and the slowest part runs in 3 s. I then compared execution plans between prod and dev, and they're considerably different, even though the indexes all appear to be the same. Here's the rundown of my results, and as far as I can tell, there's something that's happening in sql server's execution plan that is making it basically run into a wall. Here's the query that is never returning. The subquery is returning 0 results in this situation. select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.mail_row_id not in ( select distinct mr.mail_row_id from t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10)) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' this query runs in 3 s select distinct mr.mail_row_id from t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10) this query runs 1 s select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.mail_row_id not in ( 1 ) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' this query runs 1 s select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' I even tried added a duplicate row into t_mail row so that the subquery returned a result and it still didn't return. I've tried removing and reapplying related fk's and pk's, adding extra indexes, and still
[KCFusion] messed up indexes in sql server
Title: messed up indexes in sql server I'm really kind of stuck on this one and it's a bit out of my realm, but we really need to find a solution. Basically, a query that's been basically been running fine on the dev server was moved to the production server along with a few database changes, renaming of a couple tables and keys and such, and now the query doesn't even come back. The normal run time of the query should be less than 30 s, and I ran the query in production, using query analyzer, and had to stop execution at over 14 m. I then started breaking the query up into parts to see if I could find some problem with the indexes from the move to prod, and got down to one part that was running in 12 s, and like 90% of the time was being spent on a clusted index seek, which made no sense to me at all. Out of desperation, I removed the clustered index, and reran the query, and this time it took only 1 s. I then reapplied the clustered index, reran the query, and it stayed at 1 s, so I went back to the whole query, and reran it, and it still didn't return after several minutes. I then went back to breaking up the query, and this is where I get lost, and reran all the seperate parts of the query, and the slowest part runs in 3 s. I then compared execution plans between prod and dev, and they're considerably different, even though the indexes all appear to be the same. Here's the rundown of my results, and as far as I can tell, there's something that's happening in sql server's execution plan that is making it basically run into a wall. Here's the query that is never returning. The subquery is returning 0 results in this situation. select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.mail_row_id not in ( select distinct mr.mail_row_id from t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10)) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' this query runs in 3 s select distinct mr.mail_row_id from t_mail_row mr, t_mail_row_action mre where mr.mail_list_id = 31 and mre.Mail_List_action_ID = 1 and Left(mre.column2,10) = left(mr.column2,10) and Left(mre.column3,10) = left(mr.column3,10) and Left(mre.column4,10) = left(mr.column4,10) this query runs 1 s select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.mail_row_id not in ( 1 ) and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' this query runs 1 s select count (mr.mail_row_id) as rows from t_mail_row mr where mr.mail_list_id = 31 and mr.column7 'HI' and mr.column7 'MT' and mr.column7 'OR' and mr.column7 'VT' I even tried added a duplicate row into t_mail row so that the subquery returned a result and it still didn't return. I've tried removing and reapplying related fk's and pk's, adding extra indexes, and still nothing. It's sql server 7. Any suggestions at this point would be helpful as I'm at a COMPLETE loss. The indexes all appear fine and this just flat shouldn't be happening, so I'm assuming there's some form of repair that I need to do to the db to reset this...
RE: [KCFusion] actual space
it would depend on the datatype and the database, but I think their point was that a null value takes up the same amount of space as if it had a value, so it would take the amount of space required to hold a value, but for readability and usability, and possibly because I'm just plain lazy, I would just allow nulls in the first table unless it was a very large datatype. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]Sent: Friday, October 18, 2002 1:54 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] actual space I had designed a table by where one attribute was going to be occasionly set to null. One of the people in my work group said "No thats bad. It takes up too much space" (ie memory) and proceeded to make a whole other table to handle situations where that one attibute was going to be set to null. I looked at him funny but went along with it.My question is how much space does a nullvalue actually take up as compared to creating another table. A.
[KCFusion] max length of a query using cfquery
I seem to remember that there's a max length to a query that can be sent using cfquery. we're using cf 4.5 and ms sql. Specifically, we're having a discussion about whether or not to save a list of id's and then have a VERY large not in () outputting the saved list of id's using cf, or instead putting a query in the not in and letting sql server handle it. There are some specifics to this task which makes the list of id's much easier, but I think if the number of id's gets too large, that we will hit the max allowable length of a query, so I was wondering if anyone knew offhand what that limit would be, or if it's specific to our setup and settings, how that limit could be determined, so we can choose the better path. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Net Send Spam
it happened to me at home twice within a couple weeks. the firewall didn't catch it for some reason, but I haven't shut down that port entirely in the firewall. I just shut down the service. -Original Message-From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 6:03 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Net Send Spam That's why firewalls were born. It is a useful tool around the office. Robin Greenhagen President GSI http://www.gsi-kc.com/ -Original Message-From: cfhelp [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 5:54 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Net Send Spam Are any of you getting SPAM through your Application Popup like they sent a Net Send command? Rick
RE: [KCFusion] Measuring interest in attending a meeting
wed yes, thurs no (vacation) -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 12:04 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Measuring interest in attending a meeting TO: KC MM Tools, CF, Web Sig Subject: Measuring interest in attending a meeting Our original intention of having a meeting this past Monday with an MM speaker fell through due to travel difficulties. We are working to set up an alternate meeting this week. Due to MM scheduling problems, the free seminars in town this week and our perception that everyone will be watching TV Thursday, we would like your feedback on the following: Will you attend a Dreamweaver MX presentation WEDNESDAY EVENING in Overland Park? Will you attend a Dreamweaver MX presentation THURSDAY EVENING in Overland Park? If we have a reasonable number of people interested and willing to attend on the same day then we will continue to attempt to schedule such. If not, attend one of the MM seminars this week and we will see you next month. Your immediate feedback is requested Ryan Joe __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] KC CF employment opportunity
whenever I see requirements of vb and c++ together, let alone the cold fusion thrown in for good measure, I just figure it's a recruiter trying to fill multiple spots. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:54 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] KC CF employment opportunity It's just ridiculous!! -Original Message- From: Jim T. Pickering [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:53 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] KC CF employment opportunity Damn - I'm an Aries, guess I don't qualify. I wonder if having a pulse is required? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Daryl Banttari Sent: Wednesday, September 18, 2002 1:47 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] KC CF employment opportunity Candidate should also: - Be able to do high-level management, yet retain a current, practical knowledge of 80386 machine language and have memorized the complete Win32 API; - Have a Zodiac sign of Pisces, Virgo, or Leo. Aquarius will not be considered; - Have between 18 and 24 months' practical experience in quantum mechanics; - Have studied golf at a university in Scotland; - Served between 2 and 6 months in jail for a gross misdemeanor, but not felony, offense; And of course, - This ten year IT vet should be willing to work for under $25/hr, with the employer's option to convert to a salaried position at half that rate. Is it me, or are these job orders getting a bit ridiculous these days? --Daryl - Original Message - From: Ryan Hartwich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:24 PM Subject: [KCFusion] KC CF employment opportunity -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Subject: employment opportunity Skills Set: Candidate must have at least ten years of progressive IT software development and software management experience using structured system development methodologies as well as systems life cycle management methodology. Must have Four years of experience in designing Web sites, integrating Web and Database applications, managing and controlling system development projects using system life cycle management, system development methodologies and structured analysis and design techniques. Project experience must include client-server, web-enabled. and standalone applications. Detailed knowledge of Cold Fusion, Visual Basic and C++. Contract for hire position, must be willing to convert. Position is located in Kansas City. John Triggs Senior Technical Recruiter Technisource 9300 West 110th Street, Suite 460 Overland Park KS 66210 913-696-0808 ext. 227 local office phone 1-800-932-2372 toll free office phone 816-805-7250 mobile phone www.technisource.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] * This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] * __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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
RE: [KCFusion] help reading a text file...
we have tried this and are using it, somewhat different in how things go, but you can set up a datasource to a folder, and then your queries are something like select * from somefile.csv and if there's a header line in the csv, you will get a nice normal query to work with after that point. works out pretty well in small files that are being uploaded, and not knowing the name of the file you're going to be parsing through beforehand. we haven't really tried bringing in a very large file this way, but just to make the query, you can see that it would take a large amount of ram to hold the query object. -Original Message- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 1:50 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] help reading a text file... I haven't tried this, but there is a Microsoft ODBC text driver that supports TXT (Text files) and CSV (comma delimited files). You may be able to setup an ODBC connection to this file. Randy Ellis Senior Programmer Analyst City of Overland Park -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:56 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] help reading a text file... what's the best way to read a very large tab delimeted text file? does cf.. read the whole file into one variable... how does this get effected if you're reading a large file? Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] Johnson, Michael.vcf __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Implementing an Enterprise Single Login
we also came up with another solution that is somewhat complex to code, but the end result is pretty fair. have the authorization/main server send it's sessionid for this particular client to the other server in the first request, which could even be done with a post method. then, have the other server store that sessionid in a session and upon every request for a page on that server, have it do an http post back to the authorization server with the sessionid to make sure that session is still authenticated on the main server. I currently don't see any particular security holes or drawbacks to this solution other than the design. -Original Message-From: LaPlante, Bryan [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] Implementing an Enterprise Single Login I didn't realize this solution was across different domains,boxes. The server scope will not span multiple boxes. Here is a link to another storage method that stores more complex data and allows more drive space on the client. I have a code example of how to use an xml store. The down side is that it is IE4.x on a PC specific. I have not played with across domains but I think it is possible to do what you have to do with it. http://msdn.microsoft.com/library/default.asp?url=/workshop/author/behaviors/reference/behaviors/userdata.asp This url may wrap. Bryan -Original Message-From: Safley, Nicole [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 4:56 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Implementing an Enterprise Single Login Yes. The site will be secure, and will span multiple domains. -Original Message-From: Robert [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 4:53 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] Implementing an Enterprise Single Login Nicole, Are you worried that the cookie with be unreadable because the site will be 'secure' with a certificate? Because, if you're using session variables and cfapplication it isnt affected by having a SSL certificate. Is that your concern? Thanks, Robert - Original Message - From: Safley, Nicole To: Cold Fusion Listserv (E-mail) Sent: Wednesday, April 17, 2002 4:32 PM Subject: [KCFusion] Implementing an Enterprise Single Login We are attempting to implement a solution that will allow a user to enter our web "portal", log-on, and ,based on that log-on (verified in the LDAP directory), utilize any one of many secure applications. On the front side of things, we plan to set a cookie that will stay with the user throughout the session. My question is then how, as one of those many secure sites, can I decipher the cookie and read the authentication information to determine that the user is in fact valid. Any ideas? We've thrown around the idea of using a Java Servlet to do the decode, and then set the ColdFusion session variables accordingly. This is new territory for me, so any help that could be provided would be greatly appreciated. Nicole L. Safley Database Programmer/Analyst Administrative Systems Project University of Missouri-Columbia [EMAIL PROTECTED] (573) 882-6284
RE: [KCFusion] AddToken = Yes
the cfid and the cftoken are the same for both client and session, yes. it would do exactly the same thing as you adding it to the url yourself. -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 5:09 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] AddToken = Yes But what it adds will be compatible for both Client Session scoping correct? CF doesn't differentiate between the two for managing state on the browser side right? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dunwiddie, Bruce Sent: Monday, March 18, 2002 5:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] AddToken = Yes yes, it always adds them to the url, if that's what you're wanting to accomplish. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Retrieving alias from SQL sub-query
if I understand what you're saying, this should give you what you want in one query... select loopip, rec_num, lastvisit, count(loopip) as loop_count from tablename where loopip in (#listqualify(listofips, ')#) group by loopip -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 12:20 PM To: KCFusion (E-mail) Subject: [KCFusion] Retrieving alias from SQL sub-query Slightly off topic, but I'm having difficulty retrieving an alias from a sub-query. I start with a list of IP addresses, then loop through the list with this query: SELECT loopIP, rec_num, lastvisit, loop_count FROM TableName WHERE loopIP = '#ListElement#' AND NOT loop_count = 0 AND EXISTS (SELECT COUNT(loopIP) AS Count_IP FROM TableName WHERE loopIP = '#ListElement#' AND NOT loop_count = 0 GROUP BY loopIP) My goal is to CFOUTPUT table rows including one column that shows how many times the IP address in that record appears in the database. But when I try this I get error messages saying the server doesn't recognize Count_IP (my alias for the count). The SQL runs fine; the error occurs when CFOUTPUT is attempted. Any tips? TIA. 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. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] background
it's hard for me to follow all of your cells and make sure they're all ending right, but I'd suggest you opening it up in netscape, because it looks like you're missing some ending tags. I'm not sure that that's the problem, but definately some things you probably want to fix. In IE 5.0, the images came up fine, and the same on IE 5.5. -Original Message-From: Don Buck [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 02, 2002 4:15 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] background I didn't finish the last sentence. You can see the page out at http://www.logostech.ws/arrowtech/return_detail.cfm -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Don BuckSent: Wednesday, January 02, 2002 4:12 PMTo: CF-ListSubject: [KCFusion] background Perhaps someone can help me with this. I am using background images on my td tags to give a nice effect. The problem is, it works fine when I am running it locally, but when I put it out on the server and go to the page, only some of the backgrounds show up. If Iresize, minimize or otherwise cause the browser to re-render the page, they all show up. Is there a way to cause the browser to wait until all the images are loaded? Does anyone have any suggestions? You can see the page out at Don Buck (816) 767-9681 Chief Information Officer ShareValue Inc. http://www.sharevalue.com
RE: [KCFusion] Scheduled Datasource Updating
am I crazy, or this a rediculous solution in the age of providing worldwide services in all timezones? and I can only assume that this maintenance is necessary because you're using an access db? -Original Message- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:40 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating We have a scheduled BAT file running on our web server each night that updates a database file. The unfortunate thing is we actually down the website to perform the updates and then bring the website back up. The BAT file looks look this: net stop WORLD WIDE WEB PUBLISHING SERVICE C:\Update.exe net start WORLD WIDE WEB PUBLISHING SERVICE Randy -Original Message- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:09 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Scheduled Datasource Updating I need to schedule maintenance window each night to perform automated repairs and compaction on my main database. I know how to do that, but in order to repair and compact the database, I need to disconnect the datasource that is hitting against it for that period of time. Does anybody know if it is possible to schedule updates to a datasource (i.e.-disconnect and reconnect)? Kory Bakken IT Enterprise Release Management Tools / Process desk: 816.559.4801 pcs:816.305.5890 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Scheduled Datasource Updating
By definition in quite a few languages that I know of, sentences ending in a ? are deamed questions. your answer and the other couple back in this thread are actually what I was looking for. I'm so sorry that people in this country are allowed to ask questions instead of just answer the question you want answered. Not necessarily offbase, but it isn't anyone else's fault that you inherited a poor design for the web, and you should look in to the control issues you obviously have. -Original Message- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:01 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating Bruce: Yes. I inherited an Access DB that we are running a large intranet application against. It works fine for the 200+ users that use it, and it is actually faster than most of our counterparts that use an Oracle DB. However, it requires frequent maintenance. I know that no user will be using the application between midnight and 2am CST (since all users reside the same time zone), so no this is not a ridiculous solution, and no I am not worried about downtime. But thank you for the remarks (questions?). I hope I am not off-base when I say this, but in the future, if your reply is not helpful or positive, please refrain from making any comments at all. I just need to know if it is possible to schedule an update on a CF datasource using CF Administrator. Kory Bakken -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:19 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating am I crazy, or this a rediculous solution in the age of providing worldwide services in all timezones? and I can only assume that this maintenance is necessary because you're using an access db? -Original Message- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:40 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating We have a scheduled BAT file running on our web server each night that updates a database file. The unfortunate thing is we actually down the website to perform the updates and then bring the website back up. The BAT file looks look this: net stop WORLD WIDE WEB PUBLISHING SERVICE C:\Update.exe net start WORLD WIDE WEB PUBLISHING SERVICE Randy -Original Message- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:09 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Scheduled Datasource Updating I need to schedule maintenance window each night to perform automated repairs and compaction on my main database. I know how to do that, but in order to repair and compact the database, I need to disconnect the datasource that is hitting against it for that period of time. Does anybody know if it is possible to schedule updates to a datasource (i.e.-disconnect and reconnect)? Kory Bakken IT Enterprise Release Management Tools / Process desk: 816.559.4801 pcs:816.305.5890 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe
[KCFusion] recordset sql statement
in the debug window, under recordsets, there's a column that shows the sql that ran to generate that query. is this an exposed variable that we have access to on a page? like in the form of something like #queryname.statement# or is it restricted to only their debug window and they're grabbing it off of some connection/stack watch? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] UPSPrice.cfm
Does anyone have a page working that gets the online ups shipping cost? We looked at this a while back, and Ben Forta's tag UPSPrice.cfm was working then, but now that we're ready to put something in place, I'm getting a Connection Failure error and after looking in to it, it looks like the tag is on version 3 of ups's system, but their system is now on version 5. I just went to DevEx and got the latest version of the tag that was modified Oct 15th of this year, and it's still the version 3. Any help with what small changes I might need to make to this tag to get it to work now or any other options that would work would be greatly appreciated and would save me alot of time. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] off topic - IMail javascript box
I'm not sure that forta's page that you're referring to actually uses document.write to produce that. I think he's just including it in a way to hide it, which I do give you that your source viewer does pull it out of there, but I'm under the assumption that it's actually straight html in that .cfm file. Try pulling up cookies at hotmail.com. I get a access denied js error. -Original Message- From: Ron Hornbaker [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 6:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] off topic - IMail javascript box I just looked at the viewers you're talking about, set them to my favorites, jumped out to one of the sites where we're using a line just like you're talking about with document.write() in the middle of the page, and all it showed me in the source generated from your viewer was exactly what I would get if I viewed the source otherwise. What browser are you using? I'm using IE5.5 here, and when I go to a pure document.write() page like: http://fuselets.com/cftips/ and do a regular view source, all I see is the one-line JS reference. Using the SourceViewer bookmark while there, I see the complete HTML output of the page, the results of the document.write. also, I just tried the cookie viewer, and although somewhat interesting at first, I quickly found that most sites have permissions set on the reading of the cookies, I've never heard of permissions settings on cookies. It's just a simple JS call to read the cookies on the current domain, I've never seen it fail. What's a URL where it's failing? Here's a couple of my results: My Cookies at: www.fbi.gov ASPSESSIONIDQQGQGXSY=MLBLINIDEMALBOEKMGPDGODC My Cookies at: www.microsoft.com MC1=V=3LV=200012HASH=7CD1GUID=3126D17C3A1240D0A38F22EE0A256B57 My Cookies at: www.x10.com vr=VR000; Deal=14379904,TT14,0,0,0,979755380; info=3,13455522,../x10voucher.htm,bk_mk,216.63.20.97; GiftID=445857-979098591-31834; x10hotbody.dat=2634; x10welcomeab2.dat=2811; x10getitbtn.dat=3002; x103cambtn.dat=2864; x10hotdealbtn.dat=3004; x10prodbtn.dat=3005; x10xcambtn.dat=2809 [WHEW! And what's hotbody for?] -Ron -Original Message- From: Ron Hornbaker [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 3:42 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] off topic - IMail javascript box It's just simple DHTML. The View Source is grayed-out due to something weird in your browser; there's no way to lock that out. We do the same trick on the headers at http://killerwebmail.com/ (a better IMail webmail interface - login in with demo and blue to check it out) if you want to try to view the source there. Speaking of viewing the source, here's a cool little trick I figured out the other day. Tired of not being able to see the actual HTML output of a JS document.write() function, I created a bookmarkable JS source viewer, that also has a side benefit of cleaning up the HTML's capitalization, missing tags, etc.: http://www.humankindsystems.com/sourcelink.htm Using that tool from a bookmark, you'll be able to see the source of any page. Also have a handy CookieViewer bookmark there, to check your cookies on any site. Very helpful when debugging cookie problems, or just to see all the info various sites are collecting on you. -Ron Ron Hornbaker President/CTO . . . . . . . . . . . . http://humankindsystems.com . . . . . . . . . . . . w e c o d e. w e c a r e. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Thursday, November 15, 2001 11:18 AM To: KCFusion (E-mail) Subject: [KCFusion] off topic - IMail javascript box Though off topic, I'm posting because several members here have worked with IMail server product. The recent version has a feature where, if you are reading a message and click Header, it will generate a box containing the full email header info. What caught my eye is that although this box sits on top of the existing page content (edges of box bisect characters in text below, so it's not inserting an HTML table), it is still within the browser window, and will scroll with the page contents. I tried to look at their JavaScript but View source was grayed out. How did they do that? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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
