Re: How can I redirect a user?
cflocation Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Scott Wilhelm [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 13 Jan 2003 11:52:04 -0500 I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another Indirect Reference question
Hello all, I have another indirect reference question... I am inside an instantiated CFC. The CFC has a variable called THIS.subMenuVisibility which is an array to hold 1 of 2 words, either Visible or Invisible. I amtrying to set elements of this array by indirect reference. The code to do this is: cfdump var=#ArrayLen(THIS.Inputs)# cfdump var=#THIS.Inputs# cfloop index=InputTypeIndex from=1 to=#ArrayLen(THIS.Inputs)# cfset MenuName = THIS.subMenuVisibility.ulInputType THIS.Inputs [InputTypeIndex][1] Menu cfdump var=#MenuName# cfif NOT isDefined(#MenuName#) cfdump var=Inside #MenuName# cfset #MenuName# = Invisible cfdump var=#evaluate(MenuName) # /cfif /cfloop The results are: THIS.subMenuVisibility.ulInputTypeInputCheckBoxMenu Inside THIS.subMenuVisibility.ulInputTypeInputCheckBoxMenu Invisible THIS.subMenuVisibility.ulInputTypeInputRadioMenu Inside THIS.subMenuVisibility.ulInputTypeInputRadioMenu Invisible THIS.subMenuVisibility.ulInputTypeInputSelectMenu Inside THIS.subMenuVisibility.ulInputTypeInputSelectMenu Invisible THIS.subMenuVisibility.ulInputTypeInputTextMenu Inside THIS.subMenuVisibility.ulInputTypeInputTextMenu Invisible THIS.subMenuVisibility.ulInputTypeInputTextAreaMenu Inside THIS.subMenuVisibility.ulInputTypeInputTextAreaMenu Invisible (The cfdump of the array) struct ULAUTHORMENU Invisible ULCONTENTMENU Invisible ULFORMMENU Invisible ULINPUTMENU Invisible ULPROCESSMENU Invisible ULSTEPMENU Invisible It appears to me that I am setting a variable that is titled what I want; it just isn't an element of the array like I want. If anybody has any ideas, I would be most appreciative. Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Instantiated component reference
Hello all, I am trying to set a local variable in an instantiated component from outside the component. It has a reference ID that is assigned by the server using CreateUUID(). However, when I try to reference it, I get the below error. Does anybody have any suggestions? The string SERVER.stObjects.7FCC2AC7-ABAA-1582- E7F8A4739E33862B.subMenuVisibility.ulAuthorMenu is not a valid ColdFusion variable name. Valid variable names must start with a letter, and can only contain letter, numbers, and underscores. Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: UDF or CFC
Cedric, Although I am still fairly new to working with CFCs, (as evidenced by some of my recent posts), I think I understand their purpose. CFCs are the CFMX implementation of Object Oriented Programming (OOP). OOP is a way of tieing data and functions together. For instance, you define a CFC of Vehicle which has data properties of things like RunsOn (water, land, air), self-propelled (boolean), weight, color, MaxSpeed. It might also have functions that work with the data properties such as AdjustMaxSpeed(adjustmentValue) or ChangeColor(newColor). Then you might have a CFC that is Auto which extends Vehicle and adds data properties like NoWheels, NoCylinders, NoPassengers, MaxLoad. It might also have functions such as AdjustMaxLoad(adjustmentValue). It would also be able to call ChangeColor() even though it is not explicitly declared but inherits it from Vehicle. Then you might instantiate the CFC to MyCar = CreateObject(Car). Now MyCar represents a specific case of Car with particular values for the data properties. If you are just building a few web pages and just need a function that CF doesn't have, then a UDF will probably work fine. But if you are building an integrated application, you might want to consider CFCs. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Cedric Villat [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 2 Jan 2003 09:06:38 -0800 I'm wondering what the difference between a UDF and a CFC really are. Can't I create UDF's which function just the same as a CFC with maybe a few differences? Just pass the parameters in the function instead of using the tag notation. Are there reasons why one would use a UDF instead of a CFC? Or are CFC's just MX's way of dealing with functions? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
indirect reference
Hello all, Happy New Year. I hope everyone had a safe and enjoyable holiday. I am trying to set a variable indirectly, i.e., I have a variable that contains the name of the variable I want to set. How do you accomplish this? Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: innerHTML
All, Thank you for your indulgence. I am trying to dynamically set the options of a select based on the option selected in a previous select. The javascript code for a particular case is thus: for (i=1; iProcess.length; i++) case 8: { for (i=1; iProcess.length; i++) { document.getElementById(selectDoIndex).innerHTML = document.getElementById(selectDoIndex).innerHTML + option id='optionProcess + Process[i]['Index'] + ' title='Option + Process[i]['ID'] + , + Process[i]['Description'] + ' value=' + Process[i]['Index'] + ' + Process[i]['Name'] + /option; } break; } The select element it is referencing is: select id=selectDoIndex name=DoIndex title=The specific Thing to Do size=1 option id='optionSelectDoIndexDefault' title='Default for Select Do Index' value=''Select.../option /select The problem is that on the first iteration through the loop it chops off the opening option tag of the pre-existing entry leaving only Select.../option plus the full entry of that iteration. I have tried setting a variable to the existing innerHTML plus the new and it contains what I want before I set the select.innerHTML to it. Afterwards it contains everything but the initial opening option tag. Does somebody know a way around this annoying undocumented feature? Again thank you. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFC Instance Identification
Paul, Thank you very much. I will certainly try your suggestion. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Paul Kenney [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Dec 2002 02:54:30 -0800 Robert, You can create a struct in the Server (or Application) scope that holds a reference to each instantiated object. Lets call this this Server.stObjects. Each object needs a unique ID, so a UUID will be perfect. Add a property called ObjectID in each component that you want to put inside this global reference struct. When an object is instantiated, simply set the ObjectID property to a newly generated UUID. Next, create a key in the global struct with its name set to the object's ObjectID and its value set to a reference to the new object. You can put all this in the constructor code. Here is the code: in Application.cfm: cfparam name=Server.stObjects type=struct default=#StructNew ()#/ in component file: cfcomponent cfproperty name=ObjectID type=UUID/ ... cfif NOT Len(this.ObjectID) cfset this.ObjectID = CreateUUID() cfset Server.stObjects[this.ObjectID] = this /cfif /cfcomponent To get the object back, simply use its ObjectID to access the key in the global struct. You might want to put this code into a base class so that you don't have to copy it all over the place. In that class you could add the private methods addRef, removeRef and getRef, placing the constructor code above in the addRef method. removeRef would simply remove the object's key from the global struct. getRef would return a reference to the object with the specified ObjectID value. I hope this sheds some light on the possible solutions to your problem. Paul Kenney [EMAIL PROTECTED] -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:35 PM To: CF-Talk Subject: CFC Instance Identification All, Thank you in advance for you patience with my CFC tribulations. I am trying to find a string identifier for an instance of a CFC. The situation is this: I am outputting a list of instantiated objects to which a user has access. In this list, I want to put anchors that will call a specific method of an instantiated object. I have a function in a non-instantiated CFC that can do this as long as I can pass a string identifier for the instance. cffunction name=DisplayCompMeth access=remote output=true displayname=Display Component Method hint=Display a specific method of a specific componentinstance !-- This function displays the specified method of the specified component instance -- cfargument name=Comp type=string required=true default=#URL.Comp# displayname=Component hint=The component or instance thereof cfargument name=Meth type=string required=true default=#URL.Meth# displayname=Method hint=The method to be invoked cfinvoke component=#evaluate(#Comp#)# method=#Meth# returnvariable=DisplayPage/cfinvoke cfoutput #DisplayPage# /cfoutput /cffunction This works fine when I know the name of the instance such as SESSION.User. But I am actually creating the menu by calling methods from within the instantiated objects. So I am looking for a system level string identifier, like CFID, that is accessible from within the instantiated object. Does anyone know if there is such a thing and if so, how to get it? Again, thank you for your patience, assistance and support. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFC Instance Identification
All, Thank you in advance for you patience with my CFC tribulations. I am trying to find a string identifier for an instance of a CFC. The situation is this: I am outputting a list of instantiated objects to which a user has access. In this list, I want to put anchors that will call a specific method of an instantiated object. I have a function in a non-instantiated CFC that can do this as long as I can pass a string identifier for the instance. cffunction name=DisplayCompMeth access=remote output=true displayname=Display Component Method hint=Display a specific method of a specific componentinstance !-- This function displays the specified method of the specified component instance -- cfargument name=Comp type=string required=true default=#URL.Comp# displayname=Component hint=The component or instance thereof cfargument name=Meth type=string required=true default=#URL.Meth# displayname=Method hint=The method to be invoked cfinvoke component=#evaluate(#Comp#)# method=#Meth# returnvariable=DisplayPage/cfinvoke cfoutput #DisplayPage# /cfoutput /cffunction This works fine when I know the name of the instance such as SESSION.User. But I am actually creating the menu by calling methods from within the instantiated objects. So I am looking for a system level string identifier, like CFID, that is accessible from within the instantiated object. Does anyone know if there is such a thing and if so, how to get it? Again, thank you for your patience, assistance and support. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Component Conceptual Conundrum
All, Thank you for your patience with my current component problems. I will admit, my primary background is in compiled programming environments. I have been able to work in a pure HTML/CGI environment for web apps using ASP with few conceptual issues. But the mixed environment of web-based applications that have some OOP capabilities is giving me some fits. I did some tests originally that showed I could access scoped variables (APPLICATION, CLIENT and SESSION) from within a component. My further work, I think has determined that you can only access the scoped variables when the method calls are to the cfc file directly as opposed to an instance of the object. REQUEST scope variables only exist for the duration of a single client-server request. My question is, how do you get access to persistent variables, i.e. those that would normally be in APPLICATION, CLIENT or SESSION, from within instantiated components? I have resolved the issue for static variables by creating a base object that all other objects extend containing the static data. But this does not work for variable data; at least I can't think how to make it work. Any help would be greatly appreciated. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Component Conceptual Conundrum - Continued
All, Sorry to bug you all again. Does anyone know how to reference a method of an instantiated component from an HTML tag such as an anchor or a form? Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 11 Dec 2002 07:59:29 -0500 All, Thank you for your patience with my current component problems. I will admit, my primary background is in compiled programming environments. I have been able to work in a pure HTML/CGI environment for web apps using ASP with few conceptual issues. But the mixed environment of web-based applications that have some OOP capabilities is giving me some fits. I did some tests originally that showed I could access scoped variables (APPLICATION, CLIENT and SESSION) from within a component. My further work, I think has determined that you can only access the scoped variables when the method calls are to the cfc file directly as opposed to an instance of the object. REQUEST scope variables only exist for the duration of a single client-server request. My question is, how do you get access to persistent variables, i.e. those that would normally be in APPLICATION, CLIENT or SESSION, from within instantiated components? I have resolved the issue for static variables by creating a base object that all other objects extend containing the static data. But this does not work for variable data; at least I can't think how to make it work. Any help would be greatly appreciated. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFC output
Cutter, Here is something that I wrote... cffunction name=GetUserData access=public output=true displayname=Get User Data hint=display the form the user will fill out to provide data about a User !-- This function displays the form to be used to provide data for a User (primarily for editing) -- !-- This function is not complete. Access restriction code has not been added yet. -- cfargument name=Customer type=numeric required=true default=THIS.CustomerIndex displayname=Customer hint=The Index of the Customer to which the USer will be addaed (key into the Company table). cfquery datasource=#REQUEST.dbSource# username=#REQUEST.dbUserName# password=#REQUEST.dbPassword# name=GetCompanyInfo SELECT * FROM Company ORDER BY CompanyName /cfquery cfoutput script language=JavaScript type=text/javascript function validateForm(form) { //This function goes through each of the form fields and determines if an entry has been made. //If an entry has not been made, it asks the user to confirm that the lack of entry was intentional. //If the user fails to confirm, the function returns a false. //Further modifications may include for the requirement of certain fields. //loop through each of the input fields and make sure a response has been given for each. for (var i = 0; i (form.elements.length - 1); i++) { if (form.elements [i].value == ) { //if the field is blank form.elements[i].focus(); //set the focus to the field if (! window.confirm(form.elements[i].name + does not have a value. Is this what you want?)) { //ask for confirmation of intentionally leaving it out return false; //if confirmation fails (the user hit cancel) then return false (preventing the submission) } } //end if (form.elements[i].value == ) } //end for loop } //end function validateForm function setEmployeeLogin() { formUserDataEntry.EmployeeLogin.value = formUserDataEntry.EmployeeFirstName.substring(0,0) + formUserDataEntry.EmployeeLastName; } function setEmployeePassword() { if (formUserDataEntry.EmployeePassword1.value == formUserDataEntry.EmployeePassword2.value) { formUserDataEntry.EmployeePassword.value = formUserDataEntry.EmployeePassword1.value } else { window.alert(Set and Confirm entries of Password do not match. Please re-enter.); formUserDataEntry.EmployeePassword1.value = ; formUserDataEntry.EmployeePassword2.value = ; formUserDataEntry.EmployeePassword1.focus(); } } /script form id=formUserDataEntry name=formUserDataEntry title=User Data Entry Form action=Customer.cfc?method=AddUser method=post onSubmit=validateForm(this) input id=inputUserIndex name=EmployeeIndex title=Employee Index type=hidden value=cfif isDefined(THIS.UserIndex) #THIS.UserIndex#/cfif / label id=labelInputFirstName title=Label for First Name Input for=EmployeeFirstNameFirst Name: input id=inputFirstName name=EmployeeFirstName
NonSense Errors
All, I am getting very confused and very frustrated. Can somebody explain this error to me? Error Occurred While Processing Request Element APP is undefined in REQUEST. The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\BuildACourse\User.cfc: line 342 340 : cffunction name=DisplayUserHome access=remote output=true displayname=Display User Home hint=Displays the USer's home Page 341 : !-- This function Displays the User's home page -- 342 : cfinvoke component=#APPLICATION.App# method=DisplayHTMLPage 343 : cfinvokeargument name=SideMenuComponent value=#THIS# 344 : cfinvokeargument name=SideMenuMethod value=DisplayUserSideMenu There is no call to the REQUEST collection. Also, I have a cfm file with the following: cfif isDefined(SESSION.User) cfinvoke component=#SESSION.User# method=DisplayUserHome/cfinvoke cfelse cfinvoke component=#APPLICATION.App# method=DisplayWelcome/cfinvoke /cfif If I only have the second cfinvoke, it works fine. When both cfinvokes are there and the first is done, I get squirrelliness. Sometimes it tells me elements of the CLIENT collection are not defined. Sometimes it tells me CLIENT itself is undefined. Am I just not understanding scope issues? Help, Please!! Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: NonSense Errors
All, As part of the debugging of this, I added to the cfm file so it is now: cfdump var=#APPLICATION# cfdump var=#CLIENT# cfdump var=#SESSION# cfif isDefined(SESSION.User) cfinvoke component=#SESSION.User# method=DisplayUserHome/cfinvoke cfelse cfinvoke component=#APPLICATION.App# method=DisplayWelcome/cfinvoke /cfif The result can be found at http://www.BuildACourse.com/NonSenseError.htm . The actual files are not there but on my test server. But the dumps clearly show that app is defined in APPLICATION and yet the error persists. I know it is probably a scope issue of some sort, but how do I go about debugging? Again, thank you in advance for your help. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Dec 2002 10:22:34 -0500 All, I am getting very confused and very frustrated. Can somebody explain this error to me? Error Occurred While Processing Request Element APP is undefined in REQUEST. The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\BuildACourse\User.cfc: line 342 340 : cffunction name=DisplayUserHome access=remote output=true displayname=Display User Home hint=Displays the USer's home Page 341 : !-- This function Displays the User's home page -- 342 : cfinvoke component=#APPLICATION.App# method=DisplayHTMLPage 343 : cfinvokeargument name=SideMenuComponent value=#THIS# 344 : cfinvokeargument name=SideMenuMethod value=DisplayUserSideMenu There is no call to the REQUEST collection. Also, I have a cfm file with the following: cfif isDefined(SESSION.User) cfinvoke component=#SESSION.User# method=DisplayUserHome/cfinvoke cfelse cfinvoke component=#APPLICATION.App# method=DisplayWelcome/cfinvoke /cfif If I only have the second cfinvoke, it works fine. When both cfinvokes are there and the first is done, I get squirrelliness. Sometimes it tells me elements of the CLIENT collection are not defined. Sometimes it tells me CLIENT itself is undefined. Am I just not understanding scope issues? Help, Please!! Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: NonSense Errors
Marlon, By identifying #APPLICATION.App#, which is an Object as opposed to a structure, as the component in the cfinvoke, I was not trying to just get to a method in the cfc but a method for a specific instance of the cfc. According to the documentation, that is how you do it. If I am mistaken, please tell me how to access a method of a specific instance of the cfc. Thank you. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Marlon Moyer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Dec 2002 10:15:34 -0600 #application.app# is a structure and not a path to your cfc. You need to have something like home.cfcdirectory.cfcname in you componenet invoke call. Robert Polickoski wrote: All, As part of the debugging of this, I added to the cfm file so it is now: cfdump var=#APPLICATION# cfdump var=#CLIENT# cfdump var=#SESSION# cfif isDefined(SESSION.User) cfinvoke component=#SESSION.User# method=DisplayUserHome/cfinvoke cfelse cfinvoke component=#APPLICATION.App# method=DisplayWelcome/cfinvoke /cfif The result can be found at http://www.BuildACourse.com/NonSenseError.htm . The actual files are not there but on my test server. But the dumps clearly show that app is defined in APPLICATION and yet the error persists. I know it is probably a scope issue of some sort, but how do I go about debugging? Again, thank you in advance for your help. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Dec 2002 10:22:34 -0500 All, I am getting very confused and very frustrated. Can somebody explain this error to me? Error Occurred While Processing Request Element APP is undefined in REQUEST. The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\BuildACourse\User.cfc: line 342 340 :cffunction name=DisplayUserHome access=remote output=true displayname=Display User Home hint=Displays the USer's home Page 341 :!-- This function Displays the User's home page -- 342 :cfinvoke component=#APPLICATION.App# method=DisplayHTMLPage 343 :cfinvokeargument name=SideMenuComponent value=#THIS# 344 :cfinvokeargument name=SideMenuMethod value=DisplayUserSideMenu There is no call to the REQUEST collection. Also, I have a cfm file with the following: cfif isDefined(SESSION.User) cfinvoke component=#SESSION.User# method=DisplayUserHome/cfinvoke cfelse cfinvoke component=#APPLICATION.App# method=DisplayWelcome/cfinvoke /cfif If I only have the second cfinvoke, it works fine. When both cfinvokes are there and the first is done, I get squirrelliness. Sometimes it tells me elements of the CLIENT collection are not defined. Sometimes it tells me CLIENT itself is undefined. Am I just not understanding scope issues? Help, Please!! Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: NonSense Errors
I wonder... Could the problem be that because I have a component named Application that the server cannot distinguish between the component and the APPLICATION scope variables even though I never refer to the component except when creating an instance of it ass APPLICATION.app? Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Marlon Moyer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Dec 2002 11:07:26 -0600 I would guess that since you've already defined it as an object and via the debug information, it has methods, you would need to call it via cfobject. BTW, if that's a real db password in your debug info, you might want to change it now. Marlon Robert Polickoski wrote: Marlon, By identifying #APPLICATION.App#, which is an Object as opposed to a structure, as the component in the cfinvoke, I was not trying to just get to a method in the cfc but a method for a specific instance of the cfc. According to the documentation, that is how you do it. If I am mistaken, please tell me how to access a method of a specific instance of the cfc. Thank you. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Page cannot be displayed .. what specifically does this mean?
Mike, Based on what you say, and assuming that .htm pages load fine, I would say that you are correct in your assumption that the CF server is not running. I would try to stop and start it from the Services menu under Control Panel/Administrative Tools (or something like that). Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Michael Kear [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 21 Nov 2002 00:44:41 +1100 In my ongoing adventures with my rogue server, I'm getting a new problem now, as I try to solve the permissions thing that was going on over the last few days . Now any .cfm page gives the result The page cannot be displayed and the title of the page is cannot find server. What, specifically does this mean? Does it mean that the CF Server is no longer found by the web server?And what needs to be done to fix that? (Environment: NT4sp6) (It's now nearly 1am or I'd call the support dept for help here, so I have to rely on you guys. I hope you don't mind) Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Generating 'What's Related'
Jillian, It depends on how the data is tructured in the database, i.e. how do you identify whether or not a tool is used in the removal of an alternator in a 1997 Ford Taurus. This is what relational databases were designed for. But the table structure needs to be set up, or normalized, for relational operations. Select queries using JOINs and subqueries are the typical mechanism for incorporating data from multiple tables or multiple instances of the same table into one result set. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Jillian Carroll [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 11 Nov 2002 11:06:31 -0600 I'm having a hard time visualizing what I need to do to make this an elegant solution... so I'm hoping somebody out there has done this and can give me some insight. What I want to do is this: I have a database of tools, and any 1 tool may be associated with a group of tools (also in the database) that are related. For instance: As a technician, you pull up the wrench used for removing alternators from a 1997 Ford Taurus. When you pull up this wrench, you also see a list of 'related tools' that are also used/required for removing alternators from a 1997 Ford Taurus. My problem is that there are thousands of tools in the database and there could be any number of 'what's related' tools for a single tool. How can I create a dialogue for easily adding 'what's related' tools? Any help would be greatly appreciated. THANKS! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Contribute and Studio Observation
Not that I am trying to be exclusive or pompous, but when you start allowing people who know nothing about web page design or development to design or develop web pages, you get web pages designed or developed by people who know nothing about the process. I think it is a dangerous trend to try to make all technology available to everyone. As a case and point: The professional secreatry is all but dead. Because the word processor is now available to everyone, everyone is expected to use it. Therefore, you now have middle executive types spending twice as long to develop documents at 3 times the cost with 1/2 the effectiveness because they really don't know how to write. Specialization is not always a bad thing. Is it so horrible to expect that if someone wants to use a technology, they actually learn how to use it. Just my $0.02. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 11 Nov 2002 12:19:57 -0500 At the risk of being a trouble maker, I just have to make this observation. Now that we are allowed to talk about Contribute, I have to say the following: We have been told that MM is doing away with Studio/Homesite because they do not want to have more than one editing application in their application portfolio. I accepted this despite Dreamweaver's obvious issues that have already been covered to death. So what is the next application that MM releases? Another web editing application. I might be the only one that is irked by this, or maybe not, but it seems very odd to me. I wouldn't say that this new tool is in any way a replacement for CF Studio .. It's a web-based tool to allow non-technical ( or less- technical ) users to edit web content... So... it really in no way compares to Studio. What they're after is the wider audience of general, non-programmer business users, which is an entirely different market than Studio targeted. So I don't think it really relates (at least not directly) to their saying they didn't want to support more than one _traditional_ editing application. You wouldn't buy Contribute for the folks in your office currently using either CF Studio or Dreamweaver -- you'd buy Contribute for the folks in your office currently sending email to the folks using CF Studio or Dreamweaver to ask them to make changes. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Contribute and Studio Observation
Well, then shouldn't that be a function of the overall design of the site. If you want user editable content, provide the means within the site for them to do this and store the changeable content in a database or some other mechanism rather than inventing some application that allows users to change the actual pages. Whether it is a reality or not, if the user thinks he is editing or creating web page content because you give him a tool to change the content of one specific div, your superflouessness will certainly cross his/her mind. Not to beat a dead horse, but why is it that Powerpoint 101 is a critical course for engineering students? Because graphic presentation departments went the way of the buggy whip when powerpoint was put on everybody's desktop. And I will be the first to say that I lament the trend because I am terrible at producing presentations but am forced to do it because the support organization no longer exists. To quote the C in C from The Undiscovered Country, just because we cand do a thing doesn't mean that we must do a thing, or even should. I guess I'm up to $0.04 now. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: David Notik [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 11 Nov 2002 11:54:09 -0800 I don't think that should be a concern. Contribute seems to allow you to lock down everything, including fonts and styles, and just allow actual text content editing. So unless you make a living cutting and pasting text changes a client sends you, I wouldn't be too worried. The site, the code, and the initial content creation are all done by you, the developer/designer. Contribute comes into play when you start getting client phone calls (each call lasting 10 minutes at least) asking you to make a few text changes, or to use the new paragraph they're about to send you, or to hypothesize what text might be better that what is currently there. I do this too often, and it is *not* worth my time, and I'm sure I am losing money as a result. You could just have them buy Contribute and make the text changes they want. That keeps you coding (and happy) and the client happy. If you're worried about the fact that the client will no longer call you to change foxtrot to fox trot, you probably have way too much time on your hands, and I can only strongly suggest that you could probably make better use of creatively inclined mind. Besides, from my experience, even the tiniest modification takes 15 minutes (between the phone call, the popping open the site, locating the page, making the edit, e-mailing the client about the change, winding down). If I charge $125/hour, I can justify charging over $30 for fox trot to myself, but does that really make sense? I don't think so. Better to open up the content to the client, and focus on design and development. Plus, I'd bet that the fact that the client can edit the pages will excite him, and keep him occupied with the site, and keep them coming back to you for additions/modifications/answers. Personally, I welcome Macromedia Contribute with open arms. Go MM! -D ### David Notik Digital202, LLC Imagination gone digital. Web: www.digital202.com E-mail: [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### -Original Message- From: Paul Hastings [mailto:paul;tei.or.th] Sent: Monday, November 11, 2002 11:47 AM To: CF-Talk Subject: Re: Contribute and Studio Observation wouldn't buy Contribute for the folks in your office currently using either CF Studio or Dreamweaver -- you'd buy Contribute for the folks in your office currently sending email to the folks using CF Studio or Dreamweaver to ask them to make changes. and how long before the contribute users think they no longer need the studio/dw folks defenestrate them? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: Section 508 Compliancy
Maybe this is too obvious to be stated, but the definitive site for information regarding 508 compliance is http://www.section508.gov . Additionally, Macromedia has an extension (actually provided by a third party) that you can download for evaluating and fixing pages regarding accessibility and 508. I would provide the URL but the query string is long and would probably create confusion. Just search 508 at Macromedia.com and you can find it. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Trusz, Andrew [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Nov 2002 08:58:28 -0500 Your examples suggest that the problem isn't with Lynx but with screen readers. Lynx cleanly separates form and content (the goal of css standards). Readers don't seem able to perform such separation. So either developers have to go to extraordinary lengths to accommodate proprietary screen reader idiosyncrasies or we need a standards based screen reader, and of course standards based sites. On balance, Jochem seems right. Lynx delivers content. So, Jaws over Lynx? Speech ready Lynx? drew -Original Message- From: Sandy Clark [mailto:slLists;shayna.com] Sent: Thursday, November 07, 2002 2:52 PM To: CF-Talk Subject: RE: OT: Section 508 Compliancy Not necessarily the specific portions. It might even comply legally, but that doesn't meant that it would be easily readable in a screen reader such as JAWS or Simply Web. To give an example, use three programs. Lynx - http://lynx.browser.org Text Only Web Site. Any regular internet browser - IE, Netscape Simply Web 2000 http://www.econointl.com/sw/ A free text and speech web browser. Then, just for giggles, look at www.whitehouse.gov in each. This is supposed to be a 508 compliant site but doesn't validate in Bobby. Reads really well in Lynx, but notice what happens in the screen reader. This site http://www.ehdp.com/vitalnet/ did validate in Bobby. But again, look it in the screen reader. This is a good example of sites that follow the letter of the law, but not the spirit. A great book is published by Glasshaus, Accessible Web Sites, Jim Thatcher. Delves into a lot of trying to make a site truly compliant, not just verifiable by BOBBY. Another option (which is what I am starting to work towards) is using separating my content totally from presentation using XHTML and CSS2. By doing this, 508 becomes incredibly easy and truly useful. Glasshaus - Cascading Style Sheets: Separating Content from Presentation - Briggs Some sites if you are interested. http://www.glish.com http://www.webstandards.org http://www.alistapart.com -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: Thursday, November 07, 2002 11:11 AM To: CF-Talk Subject: Re: OT: Section 508 Compliancy Kevin Graeme wrote: Sorry Jochem, but that just means it works in Lynx not that it meets all the 508 criteria. Which parts of 1194.22 wouldn't it comply with then? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Studio MX
I am fairly new to CFML (3 months). You mentioned the rookie use of pound signs. How else do you identify variables? Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Mark A. Kruger - CFG [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Nov 2002 09:35:02 -0600 Rick, Yeah - the file explorer drives me crazy - all the files and folders together... If you have a complex directory structure it means constantly scrolling over to the right to find the right file. Something else - DWMX has a bunch of wizards to write CF code. One I saw one demonstrated that was the data-entry wizard. It built a form for entering records into a database. You provide the DB and select the form elements etc. It was based on a recordset that you create. You go through the wizard and it creates code for you - including validation code. But the CF code very poor. It actuallly did this on the validation: cfif #Form.Formname# NEQ validate blah /cfif Notice the rookie use of the pound signs. It made me wonder if CF server folks were involved in the creation of the CF wizards at all. -mk P.S. - Studio 5 rocks. -Original Message- From: Rick Root [mailto:rroot;wakeinternet.com] Sent: Friday, November 08, 2002 9:00 AM To: CF-Talk Subject: Re: Studio MX David Adams wrote: Everyone I know is still using studio and if in a pinch Homesite MX. In our lives we need more simplicity not complexity. I guess I missed the rest of this thread but I thought I'd chime in with my opinion. I don't like Dreamweaver MX. We have a Site License for it here at Duke, but I simply don't like it. I don't like the new explorer layout that they use.. I much prefer the directories on top and the files down below. I'm still using Studio 4.5 and will probably continue to use it after we upgrade to CFMX in the next few weeks. - Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: Using Javascript to disable backspace key with exception
event.fromElement wiil give you the object which generated the event. Test for that being the input you want to allow backspace in and block it in all other cases. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: James Taavon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Nov 2002 09:52:27 -0500 I am using Javascript to disable backspace key. It works fine. The only problem is that I need to have the backspace key functional for only one field on my form. Here is the current script I am using: - script function checkShortcut() { if(event.keyCode==8 || event.keyCode==13) { return false; } } /script - How can I modify this script to include backspace for my one textbox? Thanks in advance!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT: CSS2 and NetScape
All, Thank you for your suggestions and input. Taking it all into account, I have been able to develop a CSS sheet that works in both browsers. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 6 Nov 2002 16:51:30 -0500 Isaac, Yes, I am idealistic and trying to truly separate content from format (maybe I should just use XML LOL). The reason that I suggest that NS isn't implementing position is that it is treating everything as an in-line element. Thank you for the reference and your response. maybe I just haven't worked with it enough ... I remember being able to use absolute positioning with NS -- though I've had some difficulty with relative positioning ... which I figured was just me not really understanding the standard well enough yet. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: Javascript across windows
Ben, window.opener is an object reference in the child to the parent. You can use widow.opener.document.all.elementid or window.opener.formname.fieldname to reference objects in the parent. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Ben Doom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Nov 2002 10:11:12 -0500 Does anyone know how to pass information between browser windows using Javascript (or anything else for that matter). Specifically, I'm using javascript to open a second browser window for a user to fill out a small form which needs to return the results to the creating browser window. The second browser window needs (unless someone has a better idea) to either be able to trigger a function or access form elements in the DOM to write the information. I'd happily post code if people want to see it, but since it doesn't seem to work at all, I didn't think it necessary. :-) All help is appreciated. --Ben Doom Programmer General Lackey Moonbow Software ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: CSS2 and NetScape
Cutter, Thank you for checking up on me. It helps to have others keep me honest. I will admit that I did not test it on NS4. I tested it on Mozilla 1.2 and NS7 on which it looks fine except for the HRs not showing up in color. I also tested it on Opera on which it looks a little funky but is functional. As far as I know, NS4 is not CSS2 compliant. I am not necessarily trying for full backward compatability but current standards compliance. Again, thank you. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Cutter - \(CFTalk List\) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 07 Nov 2002 10:48:58 -0500 Robert, The style you set, was that for a different site than the one you posted earlier? I just looked at it in NS 4 and it is off kilter quite a bit... Cutter Falcon Knives Robert Polickoski writes: All, Thank you for your suggestions and input. Taking it all into account, I have been able to develop a CSS sheet that works in both browsers. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 6 Nov 2002 16:51:30 -0500 Isaac, Yes, I am idealistic and trying to truly separate content from format (maybe I should just use XML LOL). The reason that I suggest that NS isn't implementing position is that it is treating everything as an in-line element. Thank you for the reference and your response. maybe I just haven't worked with it enough ... I remember being able to use absolute positioning with NS -- though I've had some difficulty with relative positioning ... which I figured was just me not really understanding the standard well enough yet. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: CSS2 and NetScape
All, I apologize for t he off-topic post but I am having a terrible time finding another resource. I have a site on which I am using a CSS2 style sheet (validated) to format the content. IE6 displays it beautifully. NS messes it up copmpletely. I think it is because NS hasn't implemented the position attribute. Does anyone know of a good source of information or support, preferably free? If curious, the site is http://www.buildacourse.com . Thank you, Robert Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT: CSS2 and NetScape
Isaac, Yes, I am idealistic and trying to truly separate content from format (maybe I should just use XML LOL). The reason that I suggest that NS isn't implementing position is that it is treating everything as an in-line element. Thank you for the reference and your response. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 6 Nov 2002 15:23:36 -0500 Are you trying to implement a table-less site layout? AFAIK Netscape supports position... There's some issues ( not necessarily Netscape issues ) with position: relative vs. position: fixed, and using position:relative in a class rather than on an element with #elementname. I'm not really an authority here... Here's a decent article(s) on it: http://glish.com/css/ The new layout on my own site doesn't display properly in NS and I haven't had / made the time to fix it as of yet. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 All, I apologize for t he off-topic post but I am having a terrible time finding another resource. I have a site on which I am using a CSS2 style sheet (validated) to format the content. IE6 displays it beautifully. NS messes it up copmpletely. I think it is because NS hasn't implemented the position attribute. Does anyone know of a good source of information or support, preferably free? If curious, the site is http://www.buildacourse.com . Thank you, Robert Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: outputting all client vars
Another way to just see the values for debugging is cfdump var=#CLIENT# the output isn't pretty, but it's there. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Mark Johnson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 5 Nov 2002 09:37:29 -0800 cfoutput cfloop list=#GetClientVariablesList()# index=i delimiters=, #i# = #client[i]#BR /cfloop /cfoutput -Original Message- From: Will Swain [mailto:will;hothorse.com] Sent: Tuesday, November 05, 2002 9:23 AM To: CF-Talk Subject: RE: outputting all client vars thats the one Adrian!! How would I dislay the value of the variables too, as that just gives me the variable names? Thanks a bunch will -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: 05 November 2002 17:09 To: CF-Talk Subject: RE: outputting all client vars I don't think you can view them like that. Try cfoutput cfloop list=#GetClientVariablesList()# index=i delimiters=, #i#br /cfloop /cfoutput See if that works. Ade -Original Message- From: Will Swain [mailto:will;hothorse.com] Sent: 05 November 2002 16:57 To: CF-Talk Subject: outputting all client vars Hi all, I've written some basic debug code to output all url, form, and session variables on a page: URL VARS: brbr CFLOOP collection=#URL# ITEM=URLVar cfoutput#URLVar# - #URL[URLVar]# br/cfoutput /cfloop brbr FORM VARS: brbr CFLOOP collection=#FORM# ITEM=FORMVar cfoutput#FORMVar# - #FORM[FORMVar]# br/cfoutput /cfloop brbr CGI VARS: brbr CFLOOP collection=#CGI# ITEM=CGIVar cfoutput#CGIVar# - #CGI[CGIVar]# br/cfoutput /cfloop brbr SESSION VARS: brbr CFLOOP collection=#SESSION# ITEM=SESSIONVar cfoutput#SESSIONVar# - #SESSION[SESSIONVar]# br/cfoutput /cfloop nice and straight forward. BUT, I want the same thing for client variables. However, trying CLIENT VARS: brbr CFLOOP collection=#CLIENT# ITEM=CLIENTVar cfoutput#CLIENTVar# - #CLIENT[CLIENTVar]# br/cfoutput /cfloop brbr just throws up the error: Error Diagnostic Information An error occurred while evaluating the expression: #CLIENT# Error near line 37, column 22. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT js question (child window passing back to parent)
Tim, window.opener is the parent object. You can set any form element from the child window using the Javascript statement window.opener.formname.inputelementname.value = document.formname.fieldname.value; I hope this helps. -- Original Message -- From: Tim Do [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 18 Oct 2002 08:28:09 -0700 Could anybody show me how I would pass values from a child window back to the parent window? I have a form with a link that spawns a window, and from the new page, the user selects some checkboxes. I wanted to pass the values back into a form field in the parent window. I'm getting an error message that says the parent window's form field is null or not an object. Here is what I have: Parent Window: FORM NAME=newCaseInfo ACTION=index.cfm?action=caseAnalysissubaction=createNewCase METHOD=POST onSubmit=return validateUnits(); Form that I'm trying to populate with Child window data: INPUT TYPE=text NAME=actionReason VALUE= SIZE=5 A HREF=javascript:openFrameless2() CLASS=text9ptBlackCodes/A Child Window: SCRIPT LANGUAGE=JavaScript function passToParent() { window.opener.document.newCaseInfo.actionReason.value = document.actionReason.actionReasonCode.value; return false; window.close(); } /SCRIPT FORM NAME=actionCode ACTION=index.cfm?action=caseAnalysissubaction=createNewCase METHOD=POST onSubmit=return passToParent(); INPUT TYPE=checkbox NAME=actionReasonCode VALUE=#actionReasonCode# Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: apologies...query display balled up
Tim, Use the keyword DISTINCT. I am guessing that because record #128 passes both tests, it is getting two result rows. I am not certain, but I think it will do the trick. Take care, -- Original Message -- From: Tim Laureska [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 18 Oct 2002 11:02:36 -0400 Man.. I apologize for how the first message came across formatted weird.please let me try again: I have an event calendar access database with two tables (one called category with two fields: cat_no and descr.. the other table is called events with many fields including two called category and category2) . Events can have one or two categories and each event should be reflected on one row of the table with description, location etc. The event_no is unique for each event The Table displays as shown below, but for example event# 128 should only come up on one row with Fine Food Beverage; Arts, Theatre Concerts shown under Category Description what's wrong with my code below ?? Event no. Category Description LOCATION CATEGORY CATEGORY2 128Fine Food Beverage; St Michaels; 1 5 126Sports - Youth; St Michaels; 1 2 128Arts, Theatre Concerts; St Michaels; 1 5 126Arts, Theatre Concerts; St Michaels; 1 2 cfquery datasource=cal_endar_2 name=findcal SELECT * FROM events e, category c where e.category=c.cat_no or e.category2=c.cat_no /cfquery table cfoutput query=findcal group=event_no tr td valign=top#event_no#/td tdcfoutput#descr#;/cfoutput/td td#town#/td td#category#/td td#category2#/td /tr /cfoutput /table Thanks in Advance Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: QUestion about Input File and CFFILE
Brian, Here is the code I am using: script language=JavaScript function parseFileName(theFile) { var start = -1; while (theFile.value.indexOf(\\, start + 1) != -1) { start = theFile.value.indexOf(\\, start + 1); } FileUpload.action = FileUpload.action + theFile.value.substring(start+1, theFile.value.length); } /script /head body form id=FileUpload name=FileUpload title=Form to upload a file from the user to the server action=FileUpload.cfm?FileName= method=post enctype=multipart/form-data onsubmit=validateForm(this) label id=UploadFileLabel title=Lebel for UploadFile Input for=UploadFile Select your file /label input id=UploadFile name=UploadFile title=File to be uploaded type=file onchange=parseFileName(this) br button id=UploadButton name=UploadButton title=Button to start the Upload type=submit Upload /button /form Then in fileupload.cfm I have: cfset uploadPath = Left(PATH_TRANSLATED, Find(FileUpload.cfm, PATH_TRANSLATED)-1) UploadFiles\ cffile action=upload destination=#uploadPath# filefield=UploadFile nameconflict=makeunique attributes=readonly It is working for me. I hope this helps. Take care, Robert -- Original Message -- From: Yager, Brian T Contractor/Sverdrup [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 8 Oct 2002 15:11:09 -0500 I am trying to upload a file using CFFILE. I can get it to wrok just fine. But what I can't do is get the name of the file BEFORE I use CFFILE. When I try to output the name of the file input box, I get some weird name with an extension of .tmp. Can anyone help me with what I need please? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Web services question from a beginner
John, I used DreamWeaverMX's automatic configure capability to get the following code: cfinvoke webservice=http://www.ejseinc.com/WeatherService/Service.asmx?WSDL; method=getDayForcastInfo returnvariable=aDayForcastInfo cfinvokeargument name=day value=enter_value_here/ cfinvokeargument name=zipCode value=enter_value_here/ /cfinvoke cfinvoke webservice=http://www.ejseinc.com/WeatherService/Service.asmx?WSDL; method=getExtendedWeatherInfo returnvariable=aExtendedWeatherInfo cfinvokeargument name=zipCode value=enter_value_here/ /cfinvoke cfinvoke webservice=http://www.ejseinc.com/WeatherService/Service.asmx?WSDL; method=getWeatherInfo returnvariable=aWeatherInfo cfinvokeargument name=zipCode value=enter_value_here/ /cfinvoke The structs are as follows: cfset aDayForcastInfo=StructNew() aDayForcastInfo.date aDayForcastInfo.day aDayForcastInfo.forecast aDayForcastInfo.high aDayForcastInfo.low aDayForcastInfo.precipChance aDayForcastInfo.typeDesc aDayForcastInfo.iconIndex cfset aExtendedWeatherInfo=StructNew() aExtendedWeatherInfo.day1 aExtendedWeatherInfo.day2 aExtendedWeatherInfo.day3 aExtendedWeatherInfo.day4 aExtendedWeatherInfo.day5 aExtendedWeatherInfo.day6 aExtendedWeatherInfo.day7 aExtendedWeatherInfo.day8 aExtendedWeatherInfo.day9 aExtendedWeatherInfo.typeDesc aExtendedWeatherInfo.info cfset aWeatherInfo=StructNew() aWeatherInfo.UVIndex aWeatherInfo.dewPoint aWeatherInfo.feelsLike aWeatherInfo.forecast aWeatherInfo.humidity aWeatherInfo.lastUpdated aWeatherInfo.location aWeatherInfo.pressure aWeatherInfo.reportedAt aWeatherInfo.temprature aWeatherInfo.visibility aWeatherInfo.wind aWeatherInfo.typeDesc aWeatherInfo.iconIndex I hope this helps. Take care, Robert -- Original Message -- From: John Munyan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 8 Oct 2002 13:18:40 -0700 Let me start by saying that I am a beginner with programming in general. I am trying to configure consume a weather web service but am unsure what is going wrong. I have spent about 8 hours trying to get figure this out and have thus far failed. The problem I believe is that the webservice has struct's and I am not dealing with them appropriately. I have reviewed what information there is (I believe) on consuming complex web services and not found an example complete enough that I can understand how different methods of consumption might apply to my situation. The web service I am attempting to use is: http://www.xmethods.net/ve2/ViewListing.po;jsessionid=6kLVZKkGRqLBTCjYjr Mspppz(QhxieSRM)?serviceid=147576 The WSDL is: http://www.ejseinc.com/WeatherService/Service.asmx?WSDL The code I am using is: html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body cfinvoke webservice=http://www.ejseinc.com/WeatherService/Service.asmx?WSDL; method=getWeatherInfo returnvariable=aWeatherInfo cfinvokeargument name=zipCode value=98102/ /cfinvoke cfdump var = #aWeatherInfo# /body /html The page itself can be viewed at. It takes a couple seconds to load. http://www.attrition.ws/win1.cfm I would appreciate any pointers about how to make this work, either conceptual or practical. Like I said I am new to Coldfusion and programming in general and specifically am unsure what the implication of consuming a web service providing a (stuct (I think)is). I am by no means averse to reading information about how to get this working so if you have the time to point me to any resources which might assist me directly or indirectly I would value that very much. Sincerely, John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: MX, IE6 and Client Vars
No, but I am having the problem that I can't get CLIENT variables to persist beyond the page where I set them. And yes, clientmanagement=yes. Is there some undocumented feature/requirement to using CLIENT vars? Thank you. -- Original Message -- From: Andy Ewings [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 25 Sep 2002 17:10:14 +0100 Has anyone had the problem where the standard code you stick in your application.cfm to kill sessions (when using client vars) does not work for users on IE6 when your site is being delivered by CFMX? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfupdate conundrum
All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTYPE,NEWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cfm: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DATE TAG
I think you are going to have to write A UDF that uses some cfswitch tags to piece together the output that you would like. cfswitch exprtession=theDay cfcase value=1 cfset dayString = First /cfcase cfcase value=2 cfset dayString = Second /cfcase ... /cfswitch I know it is tedious, but I think it is the simplest way. -- Original Message -- From: Steven A. del Sol [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 13:34:08 -0700 Has anyone seen a tag or know of a way to get CF to produce the date in the following format: 09/22/2002 would read..The Twenty Second day of September, in the year Two Thousand and Two. Steve __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfupdate conundrum
Thank you. It worked. Funny, INSERT queries bombed on me so I used cfinsert instead. I guess the transitive theory doesn't necessarily hold for database management tags. Thank you again. -- Original Message -- From: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 16:03:59 -0500 It has been my experience as well as the experience of other developers on this list that cfupdate is flaky at best unless your table only has a couple of fields. I have since stopped using cfupdate even with very small tables. Try putting it in a cfquery tag instead and see what happens. -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:27 AM To: CF-Talk Subject: cfupdate conundrum All, I am running CFMX on WindowsXP Pro with MySQL database. The structure of Document Table: Field,Type,Null,Key,Default,Extra, DocumentIndex,int(11),,PRI,,auto_increment, DocumentID,smallint(6),YES DocumentName,text,YES DocumentFileName,text,YES Author,smallint(4),YES DocumentType,smallint(4),YES The results of cfdump var=#Form# AUTHOR 27 DOCUMENTENTRYFORMSUBMITBUTTON Submit Entry DOCUMENTFILENAME EmployeeEntryForm.cfm DOCUMENTID 1 DOCUMENTINDEX 12 DOCUMENTNAME Employee Entry Form DOCUMENTTYPE 1 FIELDNAMES DOCUMENTINDEX,DOCUMENTID,DOCUMENTNAME,DOCUMENTFILENAME,AUTHOR,DOCUMENTTY PE,NEWDOCUMENTTYPEBUTTON,DOCUMENTENTRYFORMSUBMITBUTTON NEWDOCUMENTTYPEBUTTON New Document Type Error from cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType Error Occurred While Processing Request Error Executing Database Query. Cannot convert class java.lang.Integer to SQL type requested The Error Occurred in C:\Program Files\Macromedia\CFusionMX\wwwroot\ISRD\application\DocumentDataEntry.cf m: line 38 36 : cfelseif IsDefined(Form.DocumentIndex) 37 :cfdump var=#Form# 38 :cfupdate datasource=#dbSource# username=#dbUserName# password=#dbPassword# tablename=Document formfields=DocumentIndex, DocumentID, DocumentName, DocumentFileName, Author, DocumentType 39 : cfelse 40 :cfset Form.DocumentIndex = CheckExistingDocumentEntry.DocumentIndex __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Auto Submit Select Boxes
Rick. I am pretty sure it is the onchange event that will alow you to take an action when someone selects an option. Then you need to programmaticall do a form.submit(). -- Original Message -- From: Adrian Lynch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 20 Sep 2002 13:19:29 +0100 onselect I think, I hate JS :O| -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: 20 September 2002 13:25 To: CF-Talk Subject: Auto Submit Select Boxes What's the piece of code that makes a Select box submit on selection without using a button? Rick __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT? HTML4.0 Reference
All, For those who need a good HTML reference, this site http://www.htmlhelp.com/distribution/ Has downloadable .hlp files that are great references. -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Recursion
All, Thank you again for all of your suggestions. As time allows, I will probably play with all of them just to learn how. It is wonderful to have such support. Take care, Robert -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 13 Sep 2002 08:56:59 -0400 S. Isaac Dealey wrote: Before you give up... There's a couple of things you can do for the recursion in the db... One is to create a cross-reference table which shows the parent-child relationship between all records in the table... Alternatively, you could try this: cfset rs = QueryNew(ID) cfset temp = QueryAddRow(rs) cfset rs.id[1] = 0 cfset rs2 = QueryNew(ID) cfloop condition=rs.recordcount cfquery name=rs datasource=... SELECT * FROM mytable WHERE parentid IN (#valuelist(rs.id)#) /cfquerycfquery name=rs3 dbtype=query SELECT * FROM rs UNION SELECT * FROM rs2 /cfquerycfset rs2 = rs3 /cfloop This or something like it ought to give you a single query containing all of the children of the parent... It will be much slower than a cross-reference table in the db, however, it should be similar in performance to the current solution... Once you have this query, however, you can then use the recursive UDF in CF 5 and either pass the query to the UDF along with the current parent id for the tree, or you can place the query in the request scope and reference it from there... never do to much work in cf when your database can do it faster Well, that's why I recommended that a cross-reference table would be faster... :) All my recursion is done using the NTM model described by that guy who wrote the book SQL for Smarties ... don't remember his name -- never actually read the book -- discovered the method was documented after I had figured out how to do it on my own... But if the page in question doesn't see huge amounts of traffic, or if the tree structure isn't tremendously deep ( width isn't much of a problem ) then it's not wholly unreasonable in terms of performance to do it in cf as above... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recursion
Hello all, I wrote this really neat recursive function using the cffunction tag on my development system which is running CFMX on WindowsXP Pro. When I ported to the operational host (third party), I discovered that they were running a previous version of CF (I do not know which) which does not support the new tag. Does anybody know how to do recursion without the cffunction tag? Thank you! -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursion
All, Thank you for your responses to my inquiry. As it turns out, the CFSCRIPT option is not viable because the point of the recursion was querying a database for records that represented subordinate records which might have subordinate records of their own. The cfmodule seems to take forever and therefore is not practical. In the end, I will have to change the design of the application. However, that is not necessarily a bad thing. However, it does make me appreciate the changes in CFMX. Again, thank you all for your responses. -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 15:45:57 -0400 Or, you could rewrite the function without recursion. Just thought I'd mention it as another alternative. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:23 PM To: CF-Talk Subject: RE: Recursion I wrote this really neat recursive function using the cffunction tag on my development system which is running CFMX on WindowsXP Pro. When I ported to the operational host (third party), I discovered that they were running a previous version of CF (I do not know which) which does not support the new tag. Does anybody know how to do recursion without the cffunction tag? If your recursive function is relatively simple, you can probably write it as a CF 5-compliant user-defined function, using CFSCRIPT. CFSCRIPT is a tag in which you can write CF commands using a JavaScript-like language, which uses the same syntax and control flow structures as JavaScript, but uses CFML operators and expressions. You can't use CFML tags within a CFSCRIPT tag, though, and CFSCRIPT doesn't support all the things you can do with CFML tags, such as querying a database. Keep in mind that the host would have to be using CF 5 or higher for this to work. Alternatively, you could write a recursive custom tag. However, this is the least desirable alternative, as custom tags don't provide any built-in ability to return values (you can write that ability into your code, though) and they tend to negatively affect performance. Nevertheless, if you need recursion and you're using a version of CF prior to 5, that's the only way you can do it within CFML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfchart labelformat=date
Collin, Have you found anything? Thank you! Robert -- Original Message -- From: Collin Tobin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 6 Sep 2002 11:12:13 -0400 Robert- I'll take a look at your issue and get back to you... Collin Tobin QA Engineer macromedia.com 617 219 2000 [EMAIL PROTECTED] -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 07, 2002 2:14 AM To: CF-Talk Subject: Re: cfchart labelformat=date Hello all, I am curious. I have seen numerous responses on just about every post but mine, which I have posted twice. Did I violate a protocol? Or is this just an unsolvable issue? I have been beating my head against the wall on this issue for 2 weeks. Should I abandon ship and look for another way of doing this? OR have I found a bug? Some feedback would be helpful. Thank you, Robert -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 5 Sep 2002 12:28:26 +0600 Hello all, I am running CFMX on WindowsXP Pro using the CF built in web server. I have a problem with label formatting in a chart. I am trying to produce a Gantt Chart. I want my Y axis labels to be dates within a specified range. I have set them to the range and the labelformat attribute to date, but all the labels show up as 12/31/69. I have tried adding an offset thinking it was an epoch date issue without any difference in result. When I switch the labelformat to number, the values are valid date serial values. How do I get dates to show up as Y Axis labels? The pertinent portion of the code follows. Any help would be greatly appreciated. cfset StartDate = CreateDate(2002, 1, 1) cfset EndDate = CreateDate(2002, 12, 31) cfset NoWeeks = DateDiff(w, StartDate, EndDate) cfchart format=flash scalefrom=#StartDate# scaleto=#EndDate# gridlines=#NoWeeks + 1# seriesplacement=stacked showxgridlines=no showygridlines=yes showborder=yes fontbold=no fontitalic=no labelformat=number yaxistitle=Duration show3d=no rotated=yes sortxaxis=no showlegend=no showmarkers=yes chartheight=400 chartwidth=1400 url=javascript:showMilestoneChart('$ITEMLABEL$') -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfchart labelformat=date
Hello all, I am curious. I have seen numerous responses on just about every post but mine, which I have posted twice. Did I violate a protocol? Or is this just an unsolvable issue? I have been beating my head against the wall on this issue for 2 weeks. Should I abandon ship and look for another way of doing this? OR have I found a bug? Some feedback would be helpful. Thank you, Robert -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 5 Sep 2002 12:28:26 +0600 Hello all, I am running CFMX on WindowsXP Pro using the CF built in web server. I have a problem with label formatting in a chart. I am trying to produce a Gantt Chart. I want my Y axis labels to be dates within a specified range. I have set them to the range and the labelformat attribute to date, but all the labels show up as 12/31/69. I have tried adding an offset thinking it was an epoch date issue without any difference in result. When I switch the labelformat to number, the values are valid date serial values. How do I get dates to show up as Y Axis labels? The pertinent portion of the code follows. Any help would be greatly appreciated. cfset StartDate = CreateDate(2002, 1, 1) cfset EndDate = CreateDate(2002, 12, 31) cfset NoWeeks = DateDiff(w, StartDate, EndDate) cfchart format=flash scalefrom=#StartDate# scaleto=#EndDate# gridlines=#NoWeeks + 1# seriesplacement=stacked showxgridlines=no showygridlines=yes showborder=yes fontbold=no fontitalic=no labelformat=number yaxistitle=Duration show3d=no rotated=yes sortxaxis=no showlegend=no showmarkers=yes chartheight=400 chartwidth=1400 url=javascript:showMilestoneChart('$ITEMLABEL$') -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfchart labelformat=date
Thank you! -- Original Message -- From: Collin Tobin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 6 Sep 2002 11:12:13 -0400 Robert- I'll take a look at your issue and get back to you... Collin Tobin QA Engineer macromedia.com 617 219 2000 [EMAIL PROTECTED] -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 07, 2002 2:14 AM To: CF-Talk Subject: Re: cfchart labelformat=date Hello all, I am curious. I have seen numerous responses on just about every post but mine, which I have posted twice. Did I violate a protocol? Or is this just an unsolvable issue? I have been beating my head against the wall on this issue for 2 weeks. Should I abandon ship and look for another way of doing this? OR have I found a bug? Some feedback would be helpful. Thank you, Robert -- Original Message -- From: Robert Polickoski [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 5 Sep 2002 12:28:26 +0600 Hello all, I am running CFMX on WindowsXP Pro using the CF built in web server. I have a problem with label formatting in a chart. I am trying to produce a Gantt Chart. I want my Y axis labels to be dates within a specified range. I have set them to the range and the labelformat attribute to date, but all the labels show up as 12/31/69. I have tried adding an offset thinking it was an epoch date issue without any difference in result. When I switch the labelformat to number, the values are valid date serial values. How do I get dates to show up as Y Axis labels? The pertinent portion of the code follows. Any help would be greatly appreciated. cfset StartDate = CreateDate(2002, 1, 1) cfset EndDate = CreateDate(2002, 12, 31) cfset NoWeeks = DateDiff(w, StartDate, EndDate) cfchart format=flash scalefrom=#StartDate# scaleto=#EndDate# gridlines=#NoWeeks + 1# seriesplacement=stacked showxgridlines=no showygridlines=yes showborder=yes fontbold=no fontitalic=no labelformat=number yaxistitle=Duration show3d=no rotated=yes sortxaxis=no showlegend=no showmarkers=yes chartheight=400 chartwidth=1400 url=javascript:showMilestoneChart('$ITEMLABEL$') -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfchart labelformat=date
Hello all, I am running CFMX on WindowsXP Pro using the CF built in web server. I have a problem with label formatting in a chart. I am trying to produce a Gantt Chart. I want my Y axis labels to be dates within a specified range. I have set them to the range and the labelformat attribute to date, but all the labels show up as 12/31/69. I have tried adding an offset thinking it was an epoch date issue without any difference in result. When I switch the labelformat to number, the values are valid date serial values. How do I get dates to show up as Y Axis labels? The pertinent portion of the code follows. Any help would be greatly appreciated. cfset StartDate = CreateDate(2002, 1, 1) cfset EndDate = CreateDate(2002, 12, 31) cfset NoWeeks = DateDiff(w, StartDate, EndDate) cfchart format=flash scalefrom=#StartDate# scaleto=#EndDate# gridlines=#NoWeeks + 1# seriesplacement=stacked showxgridlines=no showygridlines=yes showborder=yes fontbold=no fontitalic=no labelformat=number yaxistitle=Duration show3d=no rotated=yes sortxaxis=no showlegend=no showmarkers=yes chartheight=400 chartwidth=1400 url=javascript:showMilestoneChart('$ITEMLABEL$') -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfchart labelformat=date
Hello all, I am using ColdFusionMX with the built in web server on a WindowsXP Pro system for development. I am trying to produce a Gantt Chart. cfset StartDate = CreateDate(2002, 1, 1) cfset EndDate = CreateDate(2002, 12, 31) cfset NoWeeks = DateDiff(w, StartDate, EndDate) cfchart format=flash scalefrom=#StartDate# scaleto=#EndDate# gridlines=#NoWeeks + 1# seriesplacement=stacked showxgridlines=no showygridlines=yes showborder=yes fontbold=no fontitalic=no labelformat=date yaxistitle=Dates show3d=no rotated=yes sortxaxis=no showlegend=no showmarkers=yes chartheight=400 chartwidth=1400 The problem is that the labels on the y-axis all show up as 12/31/69. When I set labelformat=number I get the appropriate date serial values. I have tried adding the datevalue of 12/31/69 thinking it might be an epoch offset issue without success. My question is, what type of data is it looking for to actually print dates (different ones) as labels? I cannot find any information on this in the documentation or on the Macromedia site. Any help would be greatly appreciated. -- Respectfully, Robert J. Polickoski, CNA Lead Programmer (540) 842-6339 [EMAIL PROTECTED] AIM: RobertJFP Windows Messenger: RPolickoski -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists