RE: Multiple CFLOOPs
well, that loop will display the first value of query_a.field_a for every row of query_b. then the second value of queryy_a.field_a, and so on. somehow i don't think that's what you want. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 2:46 AM To: [EMAIL PROTECTED] Subject: Multiple CFLOOPs I have 2 queries which require to loop through for certain execution. However I discovered something cfloop query="query_a" cfoutput#query_a.field_a#cfoutput cfloop query="query_b" cfoutput#query_a.field_a#cfoutput /cfloop /cfloop I realised that both #query_a.field_a# are different values, for the first one, it is able to list out all the different values. However for the second one, it only output the first value throughout. Is it something to do with multiple cfloops ? Can somebody enlighten me on this ? Thanks, Roger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
why not use a verity collection? Chris Olive, DOEHRS Website Administrator -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
one problem. think about what you just asked. "if CF server is down, can the CF server handle this error?" if the service isn't on, how could the application.cfm file get included and processed? Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:53 PM To: Cold Fusion Group Subject: if CF server down... Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REGEX for a space
why don't you treat each line as a space delimited list? loop over it and stick the appropriate variables in. Chris Olive, DOEHRS Website Administrator -Original Message- From: Andrea Wasik(CancerSource) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 3:46 PM To: [EMAIL PROTECTED] Subject: REGEX for a space I am looping over a list that contains the names of mailing lists. The delimiter in the loop is the carriage return. I am trying to identify the position of the first space in the index. I thought the regex for a space was /s, but that is not working here as the REFind always returns a zero. This is what one line of the list looks like: BREASTCANCER 1999-12-30 0 0 0 0 0 0 0 0 and here is my code: cfloop list="#logfile#" delimiters="#Chr(13)##Chr(10)#" index="line" cfset linelength = Len(line) cfset CurrentlistwordSTART = REFind('([A-Za-z]+)', line, "TRUE") cfset SpacePositionAfterFirstWord = REFind('\s+', line) SpacePositionAfterFirstWord: cfoutput#SpacePositionAfterFirstWord#/cfoutputbr cfset daypositionstart = SpacePositionAfterFirstWord + 1 cfset daypositionend = daypositionstart + 10 cfset CurrentListList = Left(line, linelength) cfset CurrentList = Left(line, SpacePositionAfterFirstWord -1) cfset currentday = Mid(line, daypositionstart, daypositionend) CurrentDay: cfoutput#currentday#/cfoutputbr /cfloop I don't really need the currentlistwordStart variable since the word is always the first thing on each new line. My problem is the 2nd REFind: REFind('\s+', line), which always gives me a zero. The files I am parsing are the ListServ log files, in case anyone is curious. They don't have any type of log analysis available so I am trying to create my own. Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
um...you do understand that client and session variables rely on cookies, right? specifically, CFID and CFTOKEN. Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 4:43 PM To: '[EMAIL PROTECTED]' Subject: RE: Well I am gonna say this before everyone else does. DON'T USE COOKIES. They are unreliable and they don't have a good rep. Either use session variables or client variables. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Powers, Bonnie [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 2:45 PM To: '[EMAIL PROTECTED]' Subject: I have a question about Cookies and SSL on Netscape. I have almost finished my shopping cart, but when my users were testing, there was a problem. It seems that Netscape won't allow pages on the SSL part of the server to use the Cookies generated by the non-SSL section of the server. Everything works OK in IE. Directory structure webroot racbp(beginning of shopping cart) 1.cfm 2.cfm 3.cfm ... application.cfm(writes two cookies Customer_ID and Order_ID) secure racbp(secure section of shoppingcart) 4.cfm 5.cfm 6.cfm 1. I thouhgt that I could just move the application.cfm to the webroot directory, but then what do i do when I need to write another application that would have the same problem 2. I could put the entire shopping cart app in the SSL folder 3. I could pass the Cookies as variables from page 3.cfm to page 4.cfm anf have page 4 write cookies from the SSl server. Then I will have to identical sets of cookie and I will have to delete them twice. 4. Every CF developer must have the same problem and there must be an industry standard fix... but I don't know what it is which is why I am contacting you. Any help would be much appreciated, Bonnie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access Field Names with Blanks in them
you also need to alias the table name to use with CF SELECT [6 AM] as toodamnearly ... and you would ref it in CFOUTPUT as #toodamnearly# -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:03 PM To: [EMAIL PROTECTED] Subject: Re: Access Field Names with Blanks in them Use "[ ]" around the table names ~JustinMacCarthy - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 08, 2000 4:46 PM Subject: Access Field Names with Blanks in them I am re-writing a scheduling program that was written in ASP/VB to work in Cold Fusion. The scheduling program uses an Access Database as its backend. This is just a small program and we are trying to keep the backend the same and just re-write the front end. However, the person that wrote this access database made the field names contain spaces. For example, one field name is 6 AM I didn't think you could have spaces in a field name. But even so, how do you tell Cold Fusion the field name? I didn't think you could use #6 AM#. I have just started re-writing it and I am going to try referencing the field name as #6 AM#, but I wanted to get feedback. Is this the right way to do it? I would like not to have to re-write the back end just yet. Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
additionally, the CF service does not have to be run as an administrator. Chris Olive, DOEHRS Website Administrator -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 5:08 AM To: [EMAIL PROTECTED] Subject: Re: Is CF a "high risk application"? Actually they have published them. Look for the document entitled "running CF under a different user account" or something similar??on Allaires site. It describes how to run cf under a different account and what directories / regkeys need permissions set etc... ~Justin MacCarthy ColdFusion is a security risk because Allaire has not published the actual rights required for ColdFusion to run under NT. For this reason, the only choice when running ColdFusion is to allow the ColdFusion application full administrative rights. This is a security risk both -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFDIRECTORY Filtering?
i don't believe you can do it with the filter property. however, you could just drop that logic into the display code. if the file name is Main_Table.xls, don't show it there. Chris Olive, DOEHRS Website Administrator -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 10:27 AM To: '[EMAIL PROTECTED]' Subject: CFDIRECTORY Filtering? I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFTP Question
yes, but is the CF service running as someone that has administrative rights or rights to that directory? Chris Olive, DOEHRS Website Administrator -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 5:26 PM To: [EMAIL PROTECTED] Subject: CFFTP Question This is a multi-part message in MIME format. --=_NextPart_000_000D_01C01756.0459E380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to remove a directory with CFFTP and am getting a 550 Access = Denied error. I am trying to remove the directory from outside of it. = I am 100% sure that I have the permission to remove it as I am logged in = as Administrator on WIN2K. Any ideas??? Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_000D_01C01756.0459E380 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am trying to remove a directory with = CFFTP and am=20 getting a 550 Access Denied error.nbsp; I am trying to remove the = directory=20 from outside of it.nbsp; I am 100% sure that I have the permission to = remove it=20 as I am logged in as Administrator on WIN2K.nbsp; Any = ideas???/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_000D_01C01756.0459E380-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: newbie:Structure problem
you need to assign the struct key name to the id, and the value you wish to assign to it as its value. the way you have it now, you're assigning each id to the key "Service_Scope_ID", which just overwrites the valuse iteratively. your code snippet is a bit cryptic, but this is what i THINK you're trying to do replace cfloop query="select" cfset stcTempSS1["Service_Scope_ID"] = "#Service_Scope_ID#" /cfloop with cfloop query="select" cfset stcTempSS1["#Service_Scope_ID#"] = "#whatever the field name is that's associated with ID#" /cfloop Chris Olive, DOEHRS Website Administrator -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:06 AM To: '[EMAIL PROTECTED]' Subject: newbie:Structure problem cfset stcTempSS1 = StructNew() cfset stcSS1 = StructNew() cfset stcActiveListSS1 = StructNew() CFQUERY NAME="Select" DATASOURCE="ProdCenter" USERNAME="sa" PASSWORD="" SELECT * FROM Service_Scope /CFQUERY cfloop query="select" cfset stcTempSS1["Service_Scope_ID"] = "#Service_Scope_ID#" /cfloop cfloop index="key" list="#StructKeyList(stcTempSS1)#" cfoutput#stcTempSS1["#key#"]#/cfoutput /cfloop *** I want to dynamically create a structure, but this only writes the last CurrentRow value into my structure. How do I fill a structure up with many custom key names and values? Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic Dropdowns From Queries?
look into nate weiss' fabulous TwoSelectsRelated tag on allaire's developer's exchange. Chris Olive, DOEHRS Website Administrator -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:44 PM To: '[EMAIL PROTECTED]' Subject: Dynamic Dropdowns From Queries? I want to create dynamic dropdown boxes where the second box changes based on the selection of the first box, but using CFQUERY to fill the contents of both boxes... for example, the first select box contains the results of QUERY1, and based on what they select from that box, I want to fill the second box with a query using a where clause that uses the selection from the first box. Example: The first dropdown is filled with the results of a query like "SELECT ClientName FROM Clients". Then if user chooses Client A from the first dropdown, I want to run a query like "SELECT Offices FROM Clients WHERE ClientName = 'Client A'" and use the results of that query to fill the second dropdown. All of the JavaScript dynamic dropdown things I've found have the values hardcoded into them. Is there a way to do this, with or without JavaScript? Also, I am using the Fusebox methodology on this site. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle Concatenation???
you use ||. as in... SELECT image_title, 'http://www.hello.com/empower/global/' || filename AS image_location FROM images ORDER BY image_title Chris Olive, DOEHRS Website Administrator -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:58 PM To: CFTalk Subject: Oracle Concatenation??? Hi All, The following SQL string concatenation in Oracle is producing an error SELECT image_title, 'http://www.hello.com/empower/global/' + filename AS image_location FROM images ORDER BY image_title Error Occurred While Processing Request Error Diagnostic Information Oracle Error Code = 1722 ORA-01722: invalid number What is the correct method of concatenating strings in Oracle? TIA, Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query with a Query problem!
by default, if you don't specify a QUERY attribute in the CFOUTPUT, and just scope the variable with the query name, you'll get the first record. if you wrap the second CFQUERY in a CFOUTPUT, you'll be good. eg. CFOUTPUT QUERY="Query1" CFQUERY NAME="Query2" DATASOURCE="#Search#" SELECT name,address,email FROMSearchDetails, UserDetails WHERE CFIF #Query1.name# NEQ "" SearchDetails.name = '#Query1.name#' /CFIF CFIF #Query1.address# NEQ "" AND SearchDetails.address = '#Query1.address#' /CFIF CFIF #Query1.email# NEQ "" AND SearchDetails.email = '#Query1.email#' /CFIF /CFQUERY CFIF Query2.recordcount NEQ 0 #name#br #address#br #email#br /CFIF /CFOUTPUT Chris Olive, DOEHRS Website Administrator -Original Message- From: Adam Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 10:06 AM To: [EMAIL PROTECTED] Subject: Query with a Query problem! Hi people, I'm new to ColdFusion and I'm already stuck with a query problem! Basically I have 2 tables, Table 1 contains fields name, address, email address. Table 2 has the same fields. I want to query all the records in Table 2 in one go with the values from Table 1. Then I want to output all the records in Table 2 which match the values from each of the records in Table 1. Can anyone help please. Below is what I have at the moment but it only compares record 1 from Table 1 with the records in Table2, it doesn't go on and compare the other records in Table1 with the records in Table 2 according to the CFOUTPUT display. cfquery name="Query1" datasource="#Search#" SELECT * FROM UserDetails /cfquery CFQUERY NAME="Query2" DATASOURCE="#Search#" SELECT name,address,email FROMSearchDetails, UserDetails WHERE CFIF #Query1.name# NEQ "" SearchDetails.name = '#Query1.name#' /CFIF CFIF #Query1.address# NEQ "" AND SearchDetails.address = '#Query1.address#' /CFIF CFIF #Query1.email# NEQ "" AND SearchDetails.email = '#Query1.email#' /CFIF /CFQUERY CFOUTPUT QUERY="Query2" #name#br #address#br #email#br /CFOUTPUT --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: OT: Securing Code ( was Download Code)
actually, that's incorrect. if there is no IP verbiage in the contract, and the work is not "for hire" (W2 employees), the IP remains with the contractor that created the software, not the company for which the software was contractually created. Chris Olive, DOEHRS Website Administrator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 10:23 AM To: [EMAIL PROTECTED] Subject: Re:RE: OT: Securing Code ( was "Download Code") I'm no expert in matters of intellectual property, but I have worked in a parallel field. You can check with a lawyer, but in general, the person/company/organization that has asked and paid for software development owns the code (and can do with it what they might without consulting/including any developer) unless there is specific language in your contract to the contrary. Anyone who is contracting programming/development services is wise if they have their contract reviewed to cover them in cases where there might be future financial gain. Do a web search on "intellectual property rights" and I think you will find it very interesting. Also note, some employers will not sign a contract that covers you - so be aware. Employers like contracts that protect them and say something to the effect that you/developers can't develop a similar application for x number of years. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: OT: Securing Code ( was "Download Code") Author: [EMAIL PROTECTED] Date: 8/30/00 7:14 AM You can actually un-encrypt CF code after it has been encrypted. I'm not sure if Allaire has rectified this issue yet. Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 30 August 2000 7:24 To: [EMAIL PROTECTED] Subject: Re: OT: Securing Code ( was "Download Code") Why not just cfcrypt it. Even if they do find a backdoor into the server the code will be useless to them. The program is located normally in C:\CFUSION\BIN At 02:00 PM 8/29/00 -0400, you wrote: Here is my situation in more detail, and I know I'm not alone. I saw a thread similar to this topic dealing from a legal stand point. early this year. I was sub-contracted by a consulting company to write a test web app for one specific client of theirs. The program is custom written for that specific client and parts would have to be rewritten to work into a general setting. Over the course of development they have really begun to see potential in the project and are seeing dollar signs. It was mentioned in the consulting firms big meeting that they were thinking of downloading the CF code and even the databases, repackage/rewrite it into a marketable fashion and resell it. My concern is, how secure is the ColdFusion code and database structure from downloading? I would like any information on the legal rights of the different parties -- programmer, consultant, client, someone who downloads it. I realise you all aren't lawyers, but any info or opinions would help. Kelly Olson --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: OT: Securing Code ( was Download Code)
it's probably in your best interest to consult a lawyer if this is of any importance more than curiosity. if that's it, however, search for "intellectual property" and read read read. Chris Olive, DOEHRS Website Administrator -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 1:42 PM To: [EMAIL PROTECTED] Subject: RE: RE: OT: Securing Code ( was "Download Code") Do you have links or other references for this? I'm interested in learning more. Thanks, Steve -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 12:03 PM To: '[EMAIL PROTECTED]' Subject: RE: RE: OT: Securing Code ( was "Download Code") actually, that's incorrect. if there is no IP verbiage in the contract, and the work is not "for hire" (W2 employees), the IP remains with the contractor that created the software, not the company for which the software was contractually created. Chris Olive, DOEHRS Website Administrator -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Session
yes, you'll get different sessions. think about that. you just answered the question when you said "cookies for sure". CF tracks sessions through the CFID and CFTOKEN cookies. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 7:05 AM To: [EMAIL PROTECTED] Subject: Re: Session I think you'll find that even though you open another browser window, the Server (and thus the Session Management in CF) still handles both as the same session. This is because you are coming from the same IP address. Your browser (regardless of how many windows you open) shares the same memory space and temporary interent directories on your PC. So, your application cannot tell one browser window from the other. Try opening one window in IE and another in Netscape and see if you get different results (you will with cookies for sure - I'm not positive about Session management). Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: "Phim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 28, 2000 10:14 PM Subject: Session Hi Everyone, I have problem with session, I develop 2 page with different login ,There are if login as admin , then Session.Logon_Mode= Admin , and if Login as member , Then Session.Login_Mode= Member If I login as an ADmin on one screen of IE Browser , and open Another IE Browser to login as Member but it already Keep session as Admin already but new IE browser I did not log in yet. Can anyone help me on this ? Any suggestion are highly appreciated. Best regards, Phim, Chiraporn Bualert --- Software Developer GFS Research Ltd., Bangkok Thailand 655-5440 Ext. 119 [EMAIL PROTECTED] --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IE and frames
you have to right-click on a link and select "open in new window". i like NS' way better. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 10:22 AM To: '[EMAIL PROTECTED]' Subject: OT: IE and frames Sorry for the OT, but this has been getting to me for a while - Do any of you know a shortcut key (or anything!) for breaking out of or opening frames in a different instance of the browser in IE? In Netscape you can right-click somewhere in the frame and choose "open frame in new window" It's got to be available, but thusfar I've not found anything Robyn -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfparam question
actually, you only need #s in the default value field. if you use # in the name field, it defines a variable named whatever's in client.CustomerCompany instead of the variable names "client.CustomerCompany." Chris Olive, DOEHRS Website Administrator -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 1:29 PM To: '[EMAIL PROTECTED]' Subject: RE: cfparam question Pound signs! cfparam name="#client.CustomerCompany#" default="#qGetCorpInfo.CorporateName#", -Original Message- From: Stas Newdel To: CFTalk Sent: 28/08/00 1:23 PM Subject: cfparam question Hello, I'm trying to do this: cfparam name="client.CustomerCompany" default="qGetCorpInfo.CorporateName", and the variable doesn't get set a value, it is initialized as blank. qGetCorpInfo is a query and it does return a record. Basically, I just want to use a shorthand for: cfif not IsDefined("client.CustomerCompany") cfset client.CustomerCompany = qGetCorpInfo.CorporateName /cfif which works fine but is more typing :) Thanks for any tips. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Parsing Email
look into the CFPOP tag. (of course, this is assuming that the destination address is in a POP3 copatible mail system. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Jacob McKee [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 1:46 PM To: '[EMAIL PROTECTED]' Subject: Parsing Email Does anyone know how to take an email that is sent to someone and have CF parse it/check for string and then perform some action? Thanks! jake J a c o bM c K e e Senior Development Manager - Mobile Solutions Group Vectrix Tel: 214.890.1801 8800 N. Central Expressway Suite 800 Dallas, Texas 75231 USA E: [EMAIL PROTECTED] W: http://www.vectrix.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
warm fuzzies all around. before the Net.Cops show up, i appreciate that. and my confidence is restored in the world, etc etc. (i'm a bit shaken because i'm leaving the cushy DOD job and going independent. the silent treatment at work is a bit unbearable. but soon i shall rise from the ashes as...) christopher olive, cio cresc technologies http://www.crescotech.com -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 10:15 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question Sorry I did not acknowledge you yesterday, but I do love you also. The reason I didn't, is that I was receiving serious lag times in the posting/delivery of messages. I actually saw responses to things I posted BEFORE my posting. Anyway, hugs and kisses to you and your Army buddies... JM -Original Message- From: Olive, Christopher M Mr NMR To: '[EMAIL PROTECTED]' Sent: 25/08/00 9:20 AM Subject: RE: Yet another filesize question that makes me feel better. it's gonna be a good weekend. :) (actually, its a DOD project. but i'm a contractor, so who cares about *my* sexual orientation? sides, they didn't ask) :) Chris Olive, DOEHRS Website Administrator -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 4:54 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question i feel so unloved. :) Chris, we love you. (do they say things like that in the US army?) ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Referring to variables
that is correct. i usually do that, as the only variable i don't scope are VARIABLES variables (:)) however, there are some purists that scope everthing. i'm just lazy is all. Chris Olive, DOEHRS Website Administrator -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:05 AM To: [EMAIL PROTECTED] Subject: RE: Referring to variables Thanks, Chris! You could refer to it without the scope, though, right? Ter Original Message Follows From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: Referring to variables Date: Thu, 24 Aug 2000 09:43:51 -0400 VARIABLES is a scope, similar to FORM and URL. it refers to variable created within the page. Chris Olive, DOEHRS Website Administrator -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:27 AM To: [EMAIL PROTECTED] Subject: Referring to variables Okay, another "best practice" question, I guess... I have inherited an application from someone. In going through the code, I notice that this person refers to several variables by using "Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I can't find any documentation on this in my reference books. Why would one choose to reference variables by preceding it this way? For example: CFDIRECTORY ACTION="List" DIRECTORY="mypath" NAME="CurrentDir" cfoutput CFIF #CurrentDir.Name# IS "" CFSET PRODUCTION="TRUE" CFELSE CFSET PRODUCTION="FALSE" /CFIF /cfoutput CFIF #Variables.PRODUCTION# IS "TRUE" ... etc. I would write the IF statement as: CFIF PRODUCTION IS "TRUE"... etc. Why did this other person refer to "Variables.PRODUCTION"? They've done this throughout the code... Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
i feel so unloved. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 11:02 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question Thanks Dave. JM -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 24/08/00 10:52 AM Subject: RE: Yet another filesize question I know there has been a lot of talk about this subject lately, but none of the threads directly answered my question. I know that I can determine a file's size AFTER it has been uploaded, but I would like to prevent someone from uploading a 100MB file, and then have to delete it after it has bogged down the server. Once I have selected a file to upload with a FILE input, can I determine the value of the path to the selected file in order to do a CFDIRECTORY on the path and determine the size, thus preventing the upload all together? Maybe with Perl or JavaScript? You can't determine the size of the file before it has been uploaded, unless you're going to install some special software on the client (ActiveX or Java components, perhaps) which would do this for you. If you're using a regular file upload form, though, there's no way to do this. CFDIRECTORY, like other CFML tags, executes on the server, allowing you to manipulate the filesystem on the server, not the client. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: splitting strings
since "word1,word2,word3" is a comma delimited list, use list functions. ex, CFSET listowords = "word1,word2,word3" CFSET firstword = ListGetAt(listowords, 1) CFSET secondword = ListGetAt(listowords, 2) ... Chris Olive, DOEHRS Website Administrator -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 11:54 AM To: '[EMAIL PROTECTED]' Subject: splitting strings if I have a string like word1,word2,word3 How could I split it in Cold Fusion into ? word1 word2 word3 Thanks, Pete -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access 97 and 2000
well, i ain't sayin' it's not flaky. it's just that it's no flakier than any other given set of MS products. :) (one would think that if a company provides almost ALL of the desktop applications any user will use, they would try to get them to coexist peacefully.) Chris Olive, DOEHRS Website Administrator -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 6:36 AM To: [EMAIL PROTECTED] Subject: Re: Access 97 and 2000 I will have to try that again, I have had 4.3pro and 97 together, but never managed to get 2000 to coexist with 97 without introducing some major instabilities. - Original Message - From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 22, 2000 4:47 PM Subject: RE: Access 97 and 2000 that's actually incorrect. i am currently running both office versions. (at one point, i had 4.3 on there, too!) the key with microsoft is to install their products in DATE ORDER, oldest first. if you install 97, then 2000, selecting "do not remove old applications" in the 2000 install, they'll play together nicely. Chris Olive, DOEHRS Website Administrator -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 11:30 AM To: [EMAIL PROTECTED] Subject: Re: Access 97 and 2000 oops, Microsoft strike again :-) As far as I know there is NO way to get both versions running on the same machine (thanks Microsoft). The error you are getting is a cracker, and you will have fun getting rid of it! The problem is caused by the fact that Office 2000 does not completely remove it's self when you uninstall it and your machine is now convinced you are trying to run the wrong version of the software with the wrong licence. The only way to solve it is to uninstall both versions of office, then run a utility provided by Microsoft (see the URL's at the end of the email) to finish the uninstall for you, then reinstall the version of office you want to run. The best way to avoid this problem is not to have ANY version of office on the server, just install the latest copy of the MDAC (2.5 I think) which will provide read/write access to all versions of Access databases (but ONLY if they are not replicable) and do all your modifications on other machines. Knowledge base articles --- Q219423 - OFF2000: How to Completely Remove Microsoft Office CD1 http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP?LN=EN-USSD=g nFR=0 Q247684 - OFF2000: How to Completely Remove Microsoft Office CD2 http://support.microsoft.com/support/kb/articles/Q247/6/84.ASP?LN=EN-USSD=g nFR=0 Q239938 - OFF2000: Utility to Completely Remove Remaining Office CD1 Files and Registry Entries http://support.microsoft.com/support/kb/articles/q239/9/38.asp?LN=EN-USSD=g nFR=0 Q247674 - OFF2000: Utility to Completely Remove Remaining Office CD2 Files http://support.microsoft.com/support/kb/articles/q247/6/74.asp?LN=EN-USSD=g nFR=0 Hope this little lot helps :) -- James Smith [EMAIL PROTECTED] When God created France he found it so perfect that to comfort those who couldn't live there, he created the French. - Original Message - From: "Gene Kraybill" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 22, 2000 6:54 PM Subject: OT: Access 97 and 2000 What does it take to run both Access 97 and Access 2000 on the same machine? We have some small CF db's in Access 97. We have a development machine with Office 2000 and tried to install only the Access portion of Office 97 on the same machine. When we try to start either version of Access, we now get this message: "Microsoft Access can't start because there is no license for it on this machine." Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --
RE: Newbie Cold Fusion Studio Question
what is your test file's extension? if it isn't .cfm, CF server won't pick it up and do anything with it. Chris Olive, DOEHRS Website Administrator -Original Message- From: Kim Woodbridge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 2:44 PM To: [EMAIL PROTECTED] Subject: Newbie Cold Fusion Studio Question Hello, I am trying to set up Cold Fusion Studio in order to view and alter .cfm files created by our main IS department. I have set up the Developmental Mappings properly and have created a very simple file from an example in the Studio documentation. HTML HEAD TITLECall Department/TITLE /HEAD BODY STRONGCall Department/STRONG !--- Set all variables --- CFSET Department="Sales" CFSET City="Boston" CFSET Salary="11" !--- Display results --- CFOUTPUT I'd like to talk to someone in #Department# in #city# who earns at least #Salary#. /CFOUTPUT /BODY /HTML When I view this in my browser it shows #Department# etc. rather than filling in the variables. Does anyone know what I may have not configured properly or what I am missing here. I am not running Cold Fusion Server but am using the Microsoft Personal Server for Windows 95. Thanks in advance. Kim A. Woodbridge Web Developer Children's Hospital of Philadelphia 215-590-1197 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Division in Cold Fusion?
#DecimalFormat(variable)# this will automatically use two decimal places. search for it in the help if you want another format. Chris Olive, DOEHRS Website Administrator -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 3:06 PM To: '[EMAIL PROTECTED]' Subject: RE: Division in Cold Fusion? Thanks for all the help with this one. One final question would be, is there a way to round the results of this to say 2 decimal places? It's hard to find what you're looking for when you don't know what you're looking for! :) Thanks again, Pete * -Original Message- * From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, August 23, 2000 2:50 PM * To: [EMAIL PROTECTED] * Subject: RE: Division in Cold Fusion? * * * Just like you did but you're using the wrong slash it should be. * * CFSET MYVAL = thisval / thatval * * BTW you also don't need #'s in set's unless the variable * name is in ""'s. * * HTH, * --K * * -Original Message- * From: Peter Benoit [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, August 23, 2000 11:33 AM * To: '[EMAIL PROTECTED]' * Subject: Division in Cold Fusion? * * * I must be looking at all the wrong stuff... but I want to * take 2 values and * divide them. * * like: * * cfset myval = #thisval# \ #thatval# * * Is there a correct way to do this? * * Thanks, * Pete * * - * --- * -- * Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ * To Unsubscribe visit * http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis ts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Newbie Cold Fusion Studio Question
sorry, the other folks actually READ the remainder of the message. you need to be running CFServer on your machine to interpret the CFM files. Chris Olive, DOEHRS Website Administrator -Original Message- From: Kim Woodbridge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 3:14 PM To: [EMAIL PROTECTED] Subject: Re: RE: Newbie Cold Fusion Studio Question Chris, Yes, it's .cfm. I named the file exactly as it said to in the documentation. Thanks, Kim "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] 08/23 2:48 PM what is your test file's extension? if it isn't .cfm, CF server won't pick it up and do anything with it. Chris Olive, DOEHRS Website Administrator -Original Message- From: Kim Woodbridge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 2:44 PM To: [EMAIL PROTECTED] Subject: Newbie Cold Fusion Studio Question Hello, I am trying to set up Cold Fusion Studio in order to view and alter .cfm files created by our main IS department. I have set up the Developmental Mappings properly and have created a very simple file from an example in the Studio documentation. HTML HEAD TITLECall Department/TITLE /HEAD BODY STRONGCall Department/STRONG !--- Set all variables --- CFSET Department="Sales" CFSET City="Boston" CFSET Salary="11" !--- Display results --- CFOUTPUT I'd like to talk to someone in #Department# in #city# who earns at least #Salary#. /CFOUTPUT /BODY /HTML When I view this in my browser it shows #Department# etc. rather than filling in the variables. Does anyone know what I may have not configured properly or what I am missing here. I am not running Cold Fusion Server but am using the Microsoft Personal Server for Windows 95. Thanks in advance. Kim A. Woodbridge Web Developer Children's Hospital of Philadelphia 215-590-1197 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Advanced Security set-up
you do, but Advanced Security only comes with Enterprise (AFAIK.) do you have Professional? Chris Olive, DOEHRS Website Administrator -Original Message- From: Ashley Hart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 10:35 AM To: [EMAIL PROTECTED] Subject: Advanced Security set-up Does anyone know where I have to go to install the Advanced Security in the Administrator? Do I have to re-install Cold Fusion Studio or the Server? I went into the Server to re-install, but it only gives me an option for selecting on the server Microsoft IIS, Peer Web Server, or Personal Web Server? I thought this is where I was to go to select Advanced Security? Thanks. -ashley -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access 97 and 2000
that's actually incorrect. i am currently running both office versions. (at one point, i had 4.3 on there, too!) the key with microsoft is to install their products in DATE ORDER, oldest first. if you install 97, then 2000, selecting "do not remove old applications" in the 2000 install, they'll play together nicely. Chris Olive, DOEHRS Website Administrator -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 11:30 AM To: [EMAIL PROTECTED] Subject: Re: Access 97 and 2000 oops, Microsoft strike again :-) As far as I know there is NO way to get both versions running on the same machine (thanks Microsoft). The error you are getting is a cracker, and you will have fun getting rid of it! The problem is caused by the fact that Office 2000 does not completely remove it's self when you uninstall it and your machine is now convinced you are trying to run the wrong version of the software with the wrong licence. The only way to solve it is to uninstall both versions of office, then run a utility provided by Microsoft (see the URL's at the end of the email) to finish the uninstall for you, then reinstall the version of office you want to run. The best way to avoid this problem is not to have ANY version of office on the server, just install the latest copy of the MDAC (2.5 I think) which will provide read/write access to all versions of Access databases (but ONLY if they are not replicable) and do all your modifications on other machines. Knowledge base articles --- Q219423 - OFF2000: How to Completely Remove Microsoft Office CD1 http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP?LN=EN-USSD=g nFR=0 Q247684 - OFF2000: How to Completely Remove Microsoft Office CD2 http://support.microsoft.com/support/kb/articles/Q247/6/84.ASP?LN=EN-USSD=g nFR=0 Q239938 - OFF2000: Utility to Completely Remove Remaining Office CD1 Files and Registry Entries http://support.microsoft.com/support/kb/articles/q239/9/38.asp?LN=EN-USSD=g nFR=0 Q247674 - OFF2000: Utility to Completely Remove Remaining Office CD2 Files http://support.microsoft.com/support/kb/articles/q247/6/74.asp?LN=EN-USSD=g nFR=0 Hope this little lot helps :) -- James Smith [EMAIL PROTECTED] When God created France he found it so perfect that to comfort those who couldn't live there, he created the French. - Original Message - From: "Gene Kraybill" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 22, 2000 6:54 PM Subject: OT: Access 97 and 2000 What does it take to run both Access 97 and Access 2000 on the same machine? We have some small CF db's in Access 97. We have a development machine with Office 2000 and tried to install only the Access portion of Office 97 on the same machine. When we try to start either version of Access, we now get this message: "Microsoft Access can't start because there is no license for it on this machine." Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: getting UserID in WinNT
does it have something to do with their "zone settings", perhaps? i don't know if your users are savvy enough to much around with them, (or even if it's possible), but it might be a setting to "not remember" my login or something. Chris Olive, DOEHRS Website Administrator -Original Message- From: Aidan Dixon [mailto:[EMAIL PROTECTED]] Sent: Monday, August 21, 2000 7:03 AM To: '[EMAIL PROTECTED]' Subject: Re: getting UserID in WinNT Ah, back to work on Monday morning, and the problem's still here... IE is standard here in 4.01, 5.0 and 5.5 versions. Your question prompted me to check if the version had something to do with it, but apparently not. I'm on 5.5 and don't get it; a colleague in the same office, also on 5.5 does get it, while a third, on 5.0 doesn't get it. If there were a pattern showing up anywhere, I might have an idea. I hadn't even thought about NS. Anybody using a non-standard browser on an IE-optimised intranet will just have to take their chances, I guess. I'm not going to the clear text option even on an intranet. Thanks for the thoughts, Aidan. -Original Message- Date: Fri, 18 Aug 2000 09:20:40 -0400 From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: getting UserID in WinNT Message-ID: [EMAIL PROTECTED] :) isn't that always the way? :) what browsers are getting the login box? if it's NS, that's not avoidable. NS won't pass the userid information along to a microsoft server. NTCR is only for IE. and clear text (the only way a netscape person can pass his information to the server) will ALWAYS pop up a box the first time the user goes to a controlled page. Chris Olive, DOEHRS Website Administrator -Original Message- From: Aidan Dixon [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 7:08 AM To: '[EMAIL PROTECTED]' Subject: Re: getting UserID in WinNT CGI.REMOTE_USER this will only be available if anonymous access for the page/directory is off. Heh heh, this message came through the day after our Computer Services guys figured out the bit about unchecking the anonymous access option. It's now working--but... Some users get a dialog box prompt for username and password (and in some case for domain as well) popping up when they access the index page of the directory where the anonymous access option was unchecked. Is this meant to happen (after all, this is CGI.REMOTE_USER not CGI.AUTH_USER), and if so, why doesn't it happen with everybody? We're running NT4 with Option Pack 4, and we're partway through an upgrade to option pack 6 as part of a rollout of Outlook 2000 and MS Exchange Server. The thing is, I can't find any correlation between who's been upgraded and who hasn't, and who gets the prompt and who doesn't, so it doesn't seem as if that's the answer. It's not something I can't live with if I have to, but I'd like to avoid scaring the users if I can. If anybody's got any idea what's going on here, I'd be grateful for suggestions. - Aidan Dixon Web Developer, Electronic Media Unit The Royal Veterinary College, Royal College St., London NW1 0TU. Tel: +44 (0)20 7468 5173 Fax: +44 (0)20 7383 0615 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Replicate DB Functions on CD?
it's good to know i'm good for SOMETHING on monday morning. :) why not run your CF app as normal, save the result HTML pages, and stick them on the CD? it'll be the "look and feel" but not the functions. of course, you'd have to limit the navigation path through your site, as well as the queries that can be run. Chris Olive, DOEHRS Website Administrator -Original Message- From: Preston Chesser [mailto:[EMAIL PROTECTED]] Sent: Monday, August 21, 2000 11:37 AM To: [EMAIL PROTECTED] Subject: RE: Replicate DB Functions on CD? Chris, We want to replicate the functioning rather than the functions so you've hit the problem precisely on the head. Is there some other interface software (infobase, folio, etc) that would be accessible off a CD with a reasonable install - ColdFusion Server, a web server, et al being unreasonable for this purpose. Thanks for the response, Preston Chesser http://www.ehistory.com At 10:11 AM 08/21/2000 -0400, you wrote: so you plan on replicating CF on a CD with no browser? how do you plan to call the .cfm template? you'll need a web server and CF server running to execute the CF as well. Chris Olive, DOEHRS Website Administrator -Original Message- From: Preston Chesser [mailto:[EMAIL PROTECTED]] Sent: Monday, August 21, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: Replicate DB Functions on CD? Has anyone here ever attempted to duplicate a portion of their ColdFusion data query/output functions on a CD? I'm not looking to reuse any of our ColdFusion code but to find a CD based interface to our data. We want to produce working CD's of our data for the purposes of demo or as a separate product. The main criteria would be to have the ability to query and search a database and then output the results. We use SQL Server but one way or the other we plan to export to an Access file. We don't plan on utilizing a web browser interface unless someone knows a good way to do that. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How To Create A Live Session Counter
you could use an application level array/structure. you wouldn't have a "true" live counter, because people that don't "log out" would only be tracked by timeouts. close enough for gov't work, though. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 22, 1999 4:21 PM To: [EMAIL PROTECTED] Subject: How To Create A Live Session Counter I am wanting to create a live session counter so that at any time I can determine how many users are logged onto my website. Rather than being a counter that counts new sessions it also needs to detect closed sessions that have closed / timeout so that the value of the counter is a true representation of those sessions that are active at any time I look forward to your input in this matter and thank you in advance Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: getting UserID in WinNT
:) isn't that always the way? :) what browsers are getting the login box? if it's NS, that's not avoidable. NS won't pass the userid information along to a microsoft server. NTCR is only for IE. and clear text (the only way a netscape person can pass his information to the server) will ALWAYS pop up a box the first time the user goes to a controlled page. Chris Olive, DOEHRS Website Administrator -Original Message- From: Aidan Dixon [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 7:08 AM To: '[EMAIL PROTECTED]' Subject: Re: getting UserID in WinNT CGI.REMOTE_USER this will only be available if anonymous access for the page/directory is off. Heh heh, this message came through the day after our Computer Services guys figured out the bit about unchecking the anonymous access option. It's now working--but... Some users get a dialog box prompt for username and password (and in some case for domain as well) popping up when they access the index page of the directory where the anonymous access option was unchecked. Is this meant to happen (after all, this is CGI.REMOTE_USER not CGI.AUTH_USER), and if so, why doesn't it happen with everybody? We're running NT4 with Option Pack 4, and we're partway through an upgrade to option pack 6 as part of a rollout of Outlook 2000 and MS Exchange Server. The thing is, I can't find any correlation between who's been upgraded and who hasn't, and who gets the prompt and who doesn't, so it doesn't seem as if that's the answer. It's not something I can't live with if I have to, but I'd like to avoid scaring the users if I can. If anybody's got any idea what's going on here, I'd be grateful for suggestions. TIA, Aidan. - Aidan Dixon Web Developer, Electronic Media Unit The Royal Veterinary College, Royal College St., London NW1 0TU. Tel: +44 (0)20 7468 5173 Fax: +44 (0)20 7383 0615 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cold Fusion and mapped drives
mapped drives are only visible to the account that mapped them. ergo, if you log in, map a drive, and then CF tries to see it, the user under whose context CF runs will NOT be able to see the drive. AFA UNCs, CF has always complained when i tried to use them. has this been fixed in 4.5.x? Chris Olive, DOEHRS Website Administrator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 8:31 AM To: [EMAIL PROTECTED] Subject: RE: Cold Fusion and mapped drives I would not advise using mapped drives; use an UNC path to the database as advised in other recent postings. Whenever you're trying to diagnose server to server connectivity, setting up NT (assuming NT) to audit logins and file access is helpful. -Original Message- From: Christopher S Martin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 5:36 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Cold Fusion and mapped drives Hello everyone. We are trying to map a datasource on a different server to cold fusion. When we go to view the server though (click on browse server in Administrator) the server does not see the mapped drive. Does anyone know why this would be? I know this is related to the network mapped drive thread, but it is kind of different. Chris Martin [EMAIL PROTECTED] www.fsenablers.com www.fslink.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cold Fusion and mapped drives
i am aware of the permissions issues with the CF account. i remember trying the UNC with CFFILE, and it told me to piss off. i'll have to go RTFM (again.) Chris Olive, DOEHRS Website Administrator -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 9:06 AM To: [EMAIL PROTECTED] Subject: Re: Cold Fusion and mapped drives AFA UNCs, CF has always complained when i tried to use them. has this been fixed in 4.5.x? CF can use UNC for cffile , Cfdirectory operations however the is an issue with cfcontent. To use UnC you must run CFSERVER under an account with permissions to access the share. Check out the KB article at allaire. ~justin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: getting UserID in WinNT
CGI.REMOTE_USER this will only be available if anonymous access for the page/directory is off. Chris Olive, DOEHRS Website Administrator -Original Message- From: Johnson, Dana [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 9:58 AM To: '[EMAIL PROTECTED]' Subject: getting UserID in WinNT hello all: Does anybody know how to get the user name/logon name from WinNT system for use in CF/asp thanks Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Select Distinct not so distinct
when you select distinct(name), foo, bar, baz ... it returns all the distinct combinations of the selected fields. Chris Olive, DOEHRS Website Administrator -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 1:48 PM To: [EMAIL PROTECTED] Subject: Select Distinct not so distinct Hi all, I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field, names from table where type = foo" -this returns every field where type is a match. SQL="select distinct(name) from table where type = foo" -this works but does not retrieve additional field info. Am I to understand that select distinct cannot be utilized in this fashion? It works if I select the name field only, but if I want more than the name field it returns all matches. I cannot ask that the database be restructured. Is that just the way it is? -Andy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query Delete?
why can't you handle that logic at display time? check to see to what the user has permissions, and display accordingly? Chris Olive, DOEHRS Website Administrator -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 4:46 PM To: [EMAIL PROTECTED] Subject: RE: Query Delete? The need for a QueryDeleteColumn or QueryDeleteRow arises in situations where one wants to manipulate the query due to various reasons. One of them could something like applying security on the query. This means that the user does not priviledges to view all the rows/columns of the query (which is a join). In such a case you would want to delete data which is secure. One can say that incorporate that in the 'select' itself. However this cannot be done bcoz some users have override security priviledges, meaning that security does not apply for such users. The bottomline is that, if there is a QueryAddColumn then why not a QueryDeleteColumn and also QueryDeleteRow. Kedar Desai Differential Technologies Fairfax, VA -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: Query Delete? This is a multi-part message in MIME format. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Query Delete?You could relatively easily do it using the QueryNew() = function and looping over. But what would be the point? Just don't = selec the column in the first place. DC - Original Message -=20 From: Planet CF=20 To: [EMAIL PROTECTED]=20 Sent: Tuesday, August 08, 2000 14:34 Subject: Query Delete? Hi,=20 Is there a custom tag somewhere out there, that=20 deletes a column from a query?=20 Thanks=20 Kedar Desai=20 Differential Technologies=20 Fairfax, VA=20 __=20 Do You Yahoo!?=20 Kick off your party with Yahoo! Invites.=20 http://invites.yahoo.com/=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEQuery Delete?/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2You could relatively easily do it using = the=20 QueryNew() function and looping over. But what would be the point?nbsp; = Just=20 don't selec the column in the first place./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Planet CF/A=20 /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Tuesday, August 08, 2000=20 14:34/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Query Delete?/DIV DIVBR/DIV PFONT size=3D2Hi,/FONT /P PFONT size=3D2Is there a custom tag somewhere out there, = that/FONT=20 BRFONT size=3D2deletes a column fromnbsp; a query?/FONT /P PFONT size=3D2Thanks/FONT BRFONT size=3D2Kedar Desai/FONT = BRFONT=20 size=3D2Differential Technologies/FONT BRFONT size=3D2Fairfax, = VA/FONT=20 /PBR PFONT = size=3D2__/FONT=20 BRFONT size=3D2Do You Yahoo!?/FONT BRFONT size=3D2Kick off = your party=20 with Yahoo! Invites./FONT BRFONT size=3D2A=20 href=3D"http://invites.yahoo.com/"=20 target=3D_blankhttp://invites.yahoo.com//A/FONT BRFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam= p;body=3Dlists/cf_talk/A=20 or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 the
RE: Printing with Javascript function
well, the confirm box will ask for a Yes/No answer, then when you try to print, the browser generates its own print window. there is no way to avoid the browser print window. Chris Olive, DOEHRS Website Administrator -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:05 PM To: [EMAIL PROTECTED] Subject: Printing with Javascript function I can't remember who I talked with before, but I got assistance on launching a new window with my data and prompting the user whether they wanted to print the screen. What I am using works, but it double prompts me for printing and I am not sure why. Here is my code. SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- var doit = confirm("Send summary data to a new screen to print?") if (doit) { print() } else { self.close() } //-- /SCRIPT Any ideas? Thanks in advance. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Studio
are you out of disk space? that was happening to me when my HD was full. Chris Olive, DOEHRS Website Administrator -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 1:49 AM To: 02 cf-talk Subject: CF Studio anyone has experienced this - after saving a document in studio, close it, then open, the entire file is empty? this has happened many times, and is very, very costly. -ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: The FORM structure
why not copy the form structure to some local struct, modify that, and send THAT to the custom tag? Chris Olive, DOEHRS Website Administrator -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 10:54 AM To: [EMAIL PROTECTED] Subject: The FORM structure Hi, FORM is a structure in Cold Fusion. All structure operations can be performed in the FORM structure, except for StructCopy. The following code: cfset LocalStruct = StructNew() cfset LocalStruct.Name = "Joe" cfset LocalStruct.Company = "Allaire" CFSET FORM = StructCopy(LocalStruct) does not work The exact error message is: "Cannot assign result to symbol FORM" Why does it behave like this? One application of changing the FORM structure would be to use it directly in CFUPDATE, CFINSERT after modifying it. Though there are other solutions to this, I would prefer to change the FORM structure and then send it to mycustom tag. Thanks and regards, Kedar Desai Differential Technologies Fairfax, VA __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple Select List
or you could use the IN keyword. WHERE EmployeeID IN (#FORM.EmployeeID#) Chris Olive, DOEHRS Website Administrator -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 5:28 PM To: [EMAIL PROTECTED] Subject: Re: Multiple Select List On 8/2/00, Olson, Kelly penned: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = query expression 'EmployeeID=3D107,24'. I'm not sure if that 3D is part of the value you inputted from the form or mime output from your e-mail. But, if your EmployeeID field is an integer, you'll get that error if any non numeric characters are in there, including the comma. Not that that matters, you can't query with a list like that anyway. You'll need to loop through it. WHERE cfloop index="mylist" list="#form.EmployeeID#"EmployeeID = #mylist# or /cfloop 0=1 Which would basically write: WHERE EmployeeID = 107 or EmployeeID = 24 or 0=1 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Finding an element in an array
wel, it's not really allaire's fault. from an implementation standpoint, you shouldn't "need" to search for something within an array. an array should be indexed by some contiguous set of indices, and is usually used for storing information related to those indices. it allows random access to those elements, but you most likely want to do something to "all" those elements (even if it is to just examine its value). lists are a non-random access version of arrays. when you say "give me list element 5", CF has to look at elements 1-4 ("traverse" them) to get to element 5. not optimal, but useful in its own context. since you have to "look" at each one, a search makes more sense. structures are a truly random access way to organize data. you CANNOT simply traverse a structure, as there is (generally) no way to go from struct[1] to struct[n] in an ordered manner. that is also why there is a "search". this is only from a programming theory standpoint. Chris Olive, DOEHRS Website Administrator -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 10:58 AM To: '[EMAIL PROTECTED]' Subject: RE: Finding an element in an array Yeh thought so..thanks for confirming. Bit naff don;t you think?why haven't allaire supported this for arrays but have for Structs and Lists? -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 03 August 2000 15:43 To: [EMAIL PROTECTED] Subject: RE: Finding an element in an array Can anyone tell me if it is at all possible to get CF to find an element in an array? I know you use ListFind and StructFind for lists and structures respectively but don;t know how to do it with an array. I have a 2-dimensional array so can't use the ArrayToList function and then do a ListFind...is this correct? what happens if you try to convert a multidimensional array into a list? You're gonna have to do it the hard way - loop through the array and check each line Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire security problem - anyone know solution?
it is an MS issue. MS has a hotfix out on it, and Allaire has just included this issue in their latest security bulletin. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: Allaire security problem - anyone know solution? Hi all, One of my hosting clients has just made me aware of this major security problem and I'm wondering if anyone knows how to eliminate it? Try calling the application.cfm template on any CF site with +.htr appended to the end of the url. You'll first see a blank page. Now hit refresh/reload and you'll see the full code of said application.cfm e.g. http://www.support.alllaire.com/application.cfm+.htr Can someone please tell me there is a patch for this. It seems to happen on all CFserver versions 4.x + running IS4.0 with Service pack 5 Dave Dave Wilson Internet Technology Manager, BizNet Solutions Allaire Premier Partner Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
that's not technically correct. if you SELECT DISTINCT Column1, Column2 you will get the distinct combinations of Column1, Column2. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:10 AM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You can only select ONE distinct column. SELECT DISTINCT Column1, Column2, etc Will give the distinct Column1 values. Dave - Original Message - From: "aslam bajaria" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) select distinct(*) gives an error. Also select distinct(column1, column2,...,LastColumn) gives an error. Can someone tell me how to avoid this error. Appreciate. A.B. --- Johan Coens [EMAIL PROTECTED] wrote: Maybe: Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords Step 2: DELETE FROM yourtable, now you're table is empty Step 3: LOOP over qryAllRecords and insert them into the database. Make sure you have a backup and use CFTRANSACTION! Best Regards, Johan Coens -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: woensdag 2 augustus 2000 6:30 To: [EMAIL PROTECTED] Subject: Help! Hello All, There is a very seriuous problem I am facing. Please help. The problem is as follows: Somehow I have created duplicate records in SQL Server 7.0 table. I have to remove the duplicate the records. It all happened because there is no primary key when the record was created. If it were a few records, I could have manually deleted them. Now the records are in thousands. Can someone suggest me a code that would check for duplicate values in a table and delete them. Please help. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
is the CF server running? is IIS? Chris Olive, DOEHRS Website Administrator -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 12:42 PM To: '[EMAIL PROTECTED]' Subject: HTTP Error 500 I'm getting error's trying to get CF pages to run on my local machine. I get this error, The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Every page I attempt to access has this problem. Even the docs and cfide. Anyone have any ideas? TIA, --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
left my CF_MINDREADER on my other server. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 2:42 PM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You'll get all of the column 2's that are associated with each distinct column 1. What's wrong? Can't you read my mind? Dave - Original Message - From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 11:28 AM Subject: RE: Help! (2) that's not technically correct. if you SELECT DISTINCT Column1, Column2 you will get the distinct combinations of Column1, Column2. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:10 AM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You can only select ONE distinct column. SELECT DISTINCT Column1, Column2, etc Will give the distinct Column1 values. Dave - Original Message - From: "aslam bajaria" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) select distinct(*) gives an error. Also select distinct(column1, column2,...,LastColumn) gives an error. Can someone tell me how to avoid this error. Appreciate. A.B. --- Johan Coens [EMAIL PROTECTED] wrote: Maybe: Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords Step 2: DELETE FROM yourtable, now you're table is empty Step 3: LOOP over qryAllRecords and insert them into the database. Make sure you have a backup and use CFTRANSACTION! Best Regards, Johan Coens -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: woensdag 2 augustus 2000 6:30 To: [EMAIL PROTECTED] Subject: Help! Hello All, There is a very seriuous problem I am facing. Please help. The problem is as follows: Somehow I have created duplicate records in SQL Server 7.0 table. I have to remove the duplicate the records. It all happened because there is no primary key when the record was created. If it were a few records, I could have manually deleted them. Now the records are in thousands. Can someone suggest me a code that would check for duplicate values in a table and delete them. Please help. A.B. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help with OUTPUT of some Querys
why not just do a joined query? SELECT c.SI_Category_name, i.si_item_name FROM SI_categories c, si_items i WHERE c.category_id = i.category_id ORDER BY c.si_category_name, i.si_item_name then, when you output, do a TABLE CFOUTPUT QUERY="qname" GROUP="si_category_name" TR TD#si_category_name#/TD /TR CFOUTPUT ... Chris Olive, DOEHRS Website Administrator -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 10:56 AM To: '[EMAIL PROTECTED]' Subject: Help with OUTPUT of some Querys Ok I have 2 tables One called SI_Categories it has SI_Category_ID and SI_Category_Name The other called SI_Items it has SI_Item_ID SI_Item_NAme SI_Category_ID So basically SI_Items has the category ID for each item to show what category it belongs to. All Good... I want the output however to look like so. Category1: Item1 Item2 Item 3 Category2: Item4 Item5 Item6 Category3: Item7 Item8 Item9 I seem to be having trouble. Obviously something has to loop and maybe even group (ooo a rhyme) because once I pull all items I have the Category ID for each but need to go back to the category table to find out what that category actually is. Also need the categories displayed BY NAME (from category table) with the items for each category (item table) listed under the appropriate Category. i am srue I am missing something little. Any suggestions??? Should I do 2 separate queries or a join? I have tried quite a few things and can't get it to work. Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Insert date and time into database
the syntax is UPDATE hitclear SET cleardate = '#now()#' WHERE table_id = 'reeldemand' you have the set and where clauses reversed. Chris Olive, DOEHRS Website Administrator -Original Message- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 2:34 PM To: [EMAIL PROTECTED] Subject: Insert date and time into database I want to insert the date and time into a sql database. Here is want I am trying to do: cfset now=createodbcdatetime(now()) cfquery name="resettime" datasource="hits" update hitclear where table_id = 'reeldemand' set cleardate = '#now#' /cfquery But, I get the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'where'. SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts '2000-07-31 11:12:22'}'" Data Source = "hits" SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts '2000-07-31 11:12:22'}'" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (7:1) to (7:44) in the template file D:\html\counter.htm The specific sequence of files included or processed is: D:\HTML\COUNTER.HTM . Date/Time: 07/31/00 11:12:22 I did have it working, but it was almost 8 lines of coding to set the date and time. I Would like to shorten the code to speed up the template. Any suggestions? Thanks Jacob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Custom Tag for Date and Time
why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris Olive, DOEHRS Website Administrator -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:22 AM To: [EMAIL PROTECTED] Subject: Custom Tag for Date and Time Any one have a custom tag that retrieves both the DateFormat (Now()) and TimeFormat (Now()) as one function that can be inserted into a database? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Job Titles
i lean toward "Web Tyrant" for myself. Chris Olive, CIO, Web Tyrant cresco technologies http://www.crescotech.com -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 27, 2000 1:53 PM To: [EMAIL PROTECTED] Subject: OT: Job Titles Hey! Its time for us to get new business cards, and I was trying to think up a really cool sounding job title. I develop web applications using CF, Visual Basic, do some Access Development. Do website design, as well as some 3D artwork where necessary. I also administer the Web Application NT server here at work.. What the heck can my new job title be? It was Senior Information Services Developer before.. ;-P I know a few of you out there must have seen/heard about some interesting job titles. My next choice is Senior Development Engineer. -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.