Re: Error occurred on line -1 ???
Are you using fusebox? I've seen similar messages when trying to debug a large fusebox app before. It never tells me the *actual* line number, usually its line number 1:8899. The line number stays the same it's the column number that changes, and it's always an impossibly huge number. -Patti Joshua Miller wrote: Anyone else seen this error? All of the error output is null and the error message says: Error occurred on line -1 This happens when accessing a large amount of data in a query (88,878 records) ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Template Numbering in fusebox errors WAS Re: Error occurred on line -1 ???
Interesting... That explains why you were seeing -1 then, doesn't it. I'm curious, however, to hear if anyone else has noticed the 1:8899 thing in their fusebox error messages. I've always assumed that this was part and parcel of using fusebox. But, if there's a way for me to get back normal template numbering in the error messages I'd be quite happy to hear. It sucks when the cause behind the error is something innocouous like a missing ; or a out of place, and the line numbers do absolutely nothing to narrow down the area where things went wrong. Joshua Miller wrote: Actually, I found this was a memory issue. The server ran out of RAM on a long conversion process. I was converting an old COBOL database to SQL Server but had to use CF to pull data out of a long string based on character position. There were over a half-million records and it just died. We added 1.5GB more ram to the machine and a second processor and haven't seen the error since. Now we just have to figure out how to allocate more RAM to the JVM without it blowing up our Server Monitor with CFMX Service Not Started errors. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:31 AM To: CF-Talk Subject: Re: Error occurred on line -1 ??? Are you using fusebox? I've seen similar messages when trying to debug a large fusebox app before. It never tells me the *actual* line number, usually its line number 1:8899. The line number stays the same it's the column number that changes, and it's always an impossibly huge number. -Patti Joshua Miller wrote: Anyone else seen this error? All of the error output is null and the error message says: Error occurred on line -1 This happens when accessing a large amount of data in a query (88,878 records) ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Try this code: WDDX problem recreated
I figured the answer would be similar. In my actual use I need to loop over a query without knowing what the columns are, so I use the recordset.columnlist in my list loop. That's why I created the structure with testquery[i], so I could approximate query[foo]. So if I say testquery[1], don't I still need to supply the columnname somehow to get at the values? Would that be testquery[1].foo? If it is, how would I approximate that without knowing what foo actually is at runtime? -Patti Raymond Camden wrote: Patti, it has been my experience that whenever you use bracket notation with a query, you must specify the row number as well. If you changed testquery[i] to testquery[1] the code should work as you want. I don't believe this is really a bug per se, just a usage case. (Although you could say that if query.foo always equals run one, then query[foo] should as well. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 12:06 AM To: CF-Talk Subject: Try this code: WDDX problem recreated Regarding my previous message, I managed to recreate the wddx serialization problem I was experiencing. Run this code. It should show you what I was talking about. I'll be reporting this using the wishlist form, of course. Just wanted to post it in case anyone else was interested. [cfscript] // Fabricate a query testQuery = querynew('age,gender,race'); queryaddrow(testQuery); querysetcell(testquery, 'age', 12,1); querysetcell(testquery, 'gender', 'Male',1); querysetcell(testquery, 'race', 'Black',1); maindata = structnew(); [/cfscript] [cfdump var=#testQuery#] [!--- Turn query into structure---] [cfloop index=i list=age,gender,race] [cfset structinsert(mainData, i, testquery[i])] [/cfloop] [cfdump var=#maindata#] [cfwddx action=cfml2wddx input=#maindata# output=wddxdata] [cfdump var=#wddxdata#] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Try this code: WDDX problem recreated
Raymond Camden wrote: Ah. Clarity. Thanks Ray. I figured the answer would be similar. In my actual use I need to loop over a query without knowing what the columns are, so I use the recordset.columnlist in my list loop. That's why I created the structure with testquery[i], so I could approximate query[foo]. Right, so all you would do is either hard code [1], or, if you are also looping over the rows, add [i] (where i is the current row), or if you are actually looping over the query w/ cfloop or cfoutput, yo ucan use [currentRow] So if I say testquery[1], don't I still need to supply the columnname somehow to get at the values? Would that be Eh? I never said [1] by itself, I said to _add_ [1], so if col = the name of the column, it owuld be testquery[col][1] === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Try this code: WDDX problem recreated
Thanks for the thought. Todd wrote: Don't forget you have access to testquery.columnlist which is a comma delimited list of all the columns in the current query object. testquery[columnname][row] ~Todd At 10:29 AM 1/15/2003 -0500, you wrote: I figured the answer would be similar. In my actual use I need to loop over a query without knowing what the columns are, so I use the recordset.columnlist in my list loop. That's why I created the structure with testquery[i], so I could approximate query[foo]. So if I say testquery[1], don't I still need to supply the columnname somehow to get at the values? Would that be testquery[1].foo? If it is, how would I approximate that without knowing what foo actually is at runtime? -Patti -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WDDX bug?: structure keys into arrays unintentionally
Has anybody else seen this? I've got a large structure with a bunch of single key values like: Doprotocol | 1 Eventdate | 2002-01-09 Gender | male When I wddx it and look at the results, a lot of these keys are turned into arrays. Not only that, but some of the arrays have 4 indices (all with the same values: Doprotocol | 1 Eventdate | -- array -- 1: 2002-01-09 2: 2002-01-09 3: 2002-01-09 4: 2002-01-09 Gender | -- array -- 1: male Why? Is this a bug that I need to log? I'm running CFMX with both updates and a security patch. Here is the wddx code. It's in a component. [cffunction name=saveWddxReport output=false returntype=void access=public] [cfargument name=saeid required=true type=numeric] [cfargument name=report required=true type=struct] [cfargument name=saveType required=true type=string default=initial] [cfset var wddxReport=] [cfwddx input=#arguments.report# action=cfml2wddx output=wddxReport] [cfif arguments.saveType eq 'initial'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_initial (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [cfelseif arguments.saveType eq 'final'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_final (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [/cfif] [cfreturn] [/cffunction] ~| 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
Re: WDDX bug?: structure keys into arrays unintentionally
Yes I'm sure. Before I postsed to the list I ran an independent test, where I grabbed the structure, printed it out with dump, wddxed it, printed it out with dump and there it is. Arrays where there are supposed to be keys. In fact, just because I'm someone who is always willing to think it could be my fault, let me try it again... [time passes] Yep. Same result. Here is the code I used. [cfinvoke component=#request.components_path#.cmpCaerReport method=getReport returnvariable=realReport] [cfinvokeargument name=saeid value=1071] [cfinvokeargument name=resolveJoins value=1] [/cfinvoke] [cfdump var=#realReport# label=real report expand=no] [cfwddx input=#realReport# output=wddxReport action=cfml2wddx] [cfdump var=#wddxReport# label=wddx report expand=no] When Ilook at real report I see a nice structure that is mostly made up of single keys. There are a couple of arrys in the structure to begin with, but I know about thos. When I look at wddx report I see a structure with a lot of extra arrays where all those single keys used to be. Might be nice if I intended them to be there, but I don't. Anybody else got any ideas? -patti [EMAIL PROTECTED] wrote: Yup, works in CFMX. Patti, are you sure that's the data you have in your structure? - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Date: Tuesday, January 14, 2003 8:54 am Subject: RE: WDDX bug?: structure keys into arrays unintentionally I am not sure about CFMX, but the following works in CF5 : cfscript foo = structnew(); temp = StructInsert(foo,Doprotocol, 1,yes); temp = StructInsert(foo,eventdate, 2002-01-09,yes); temp = StructInsert(foo,gender, male,yes); /cfscript cfwddx action=CFML2WDDX input=#foo# output=myfoo cfdump var=#foo# ? -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 15:48 To: CF-Talk Subject: WDDX bug?: structure keys into arrays unintentionally Has anybody else seen this? I've got a large structure with a bunch of single key values like: Doprotocol | 1 Eventdate | 2002-01-09 Gender | male When I wddx it and look at the results, a lot of these keys are turned into arrays. Not only that, but some of the arrays have 4 indices (all with the same values: Doprotocol | 1 Eventdate | -- array -- 1: 2002-01-09 2: 2002-01-09 3: 2002-01-09 4: 2002-01-09 Gender | -- array -- 1: male Why? Is this a bug that I need to log? I'm running CFMX with both updates and a security patch. Here is the wddx code. It's in a component. [cffunction name=saveWddxReport output=false returntype=void access=public] [cfargument name=saeid required=true type=numeric] [cfargument name=report required=true type=struct] [cfargument name=saveType required=true type=string default=initial] [cfset var wddxReport=] [cfwddx input=#arguments.report# action=cfml2wddx output=wddxReport] [cfif arguments.saveType eq 'initial'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_initial (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [cfelseif arguments.saveType eq 'final'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_final (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [/cfif] [cfreturn] [/cffunction] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WDDX bug?: structure keys into arrays unintentionally
The only other thing I have to add is that it seems like the keys that are becoming arrays are those keys that are themselves nested into another structure. Main Struct | key 1 | simple value like it should be key 2 | [structure] key 1 | [structure] should be simple value, not a structure at all -- array that isn't supposed to be there -- 1: used to be a simple value Robertson-Ravo, Neil (RX) wrote: I am not sure about CFMX, but the following works in CF5 : cfscript foo = structnew(); temp = StructInsert(foo,Doprotocol, 1,yes); temp = StructInsert(foo,eventdate, 2002-01-09,yes); temp = StructInsert(foo,gender, male,yes); /cfscript cfwddx action=CFML2WDDX input=#foo# output=myfoo cfdump var=#foo# ? -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 15:48 To: CF-Talk Subject: WDDX bug?: structure keys into arrays unintentionally Has anybody else seen this? I've got a large structure with a bunch of single key values like: Doprotocol | 1 Eventdate | 2002-01-09 Gender | male When I wddx it and look at the results, a lot of these keys are turned into arrays. Not only that, but some of the arrays have 4 indices (all with the same values: Doprotocol | 1 Eventdate | -- array -- 1: 2002-01-09 2: 2002-01-09 3: 2002-01-09 4: 2002-01-09 Gender | -- array -- 1: male Why? Is this a bug that I need to log? I'm running CFMX with both updates and a security patch. Here is the wddx code. It's in a component. [cffunction name=saveWddxReport output=false returntype=void access=public] [cfargument name=saeid required=true type=numeric] [cfargument name=report required=true type=struct] [cfargument name=saveType required=true type=string default=initial] [cfset var wddxReport=] [cfwddx input=#arguments.report# action=cfml2wddx output=wddxReport] [cfif arguments.saveType eq 'initial'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_initial (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [cfelseif arguments.saveType eq 'final'] [cfquery name=saveReport datasource=#request.dsn#] Insert into saeReport_final (saeid, report) Values (#arguments.saeid#, '#wddxReport#') [/cfquery] [/cfif] [cfreturn] [/cffunction] ~| 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
Re: WDDX bug?: structure keys into arrays unintentionally
I tried my own version of this test... A very simple structure with a nested structure and a simple key. No problem. It wddxed just fine. So great. I'm running into one of those, 'so difficult to reproduce it must be user error, go read the manual' things. Great. The code I used to try to reproduce the problem (that didn't create the behavior at all) [cfscript] teststruct = structnew(); teststruct.foo = 'bar'; teststruct.foofoo = structnew(); teststruct.foofoo.bar = 'foo'; [/cfscript] [cfdump var=#teststruct#] [cfwddx input=#teststruct# output=wddxteststruct action=cfml2wddx [cfdump var=#wddxteststruct#] Robertson-Ravo, Neil (RX) wrote: cfscript foo = structnew(); temp = StructInsert(foo,Doprotocol, 1,yes); temp = StructInsert(foo,eventdate, 2002-01-09,yes); temp = StructInsert(foo,gender, male,yes); /cfscript cfwddx action=CFML2WDDX input=#foo# output=myfoo cfdump var=#foo# ~| 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
Re: WDDX bug?: structure keys into arrays unintentionally
It would help if you could see the problem for yourself. Follow the link and take a look at the dump... Look at the maindata structure key. https://irbtest.georgetown.edu/test1.cfm You'll have to log in user: gumcdPass: D2002irb If I tried to explain further I'd just confuse you. My frustration is beginning to affect my lucidity. -Patti Robertson-Ravo, Neil (RX) wrote: I am not clear on what you want/are experiencing.? Are you saying your nested structures are not supposed to be structures? Why all this talk about structures, surely the only struct you want is the one to WDDX, and the rest should be simple key value pairs? -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 16:49 To: CF-Talk Subject: Re: WDDX bug?: structure keys into arrays unintentionally I tried my own version of this test... A very simple structure with a nested structure and a simple key. No problem. It wddxed just fine. So great. I'm running into one of those, 'so difficult to reproduce it must be user error, go read the manual' things. Great. The code I used to try to reproduce the problem (that didn't create the behavior at all) [cfscript] teststruct = structnew(); teststruct.foo = 'bar'; teststruct.foofoo = structnew(); teststruct.foofoo.bar = 'foo'; [/cfscript] [cfdump var=#teststruct#] [cfwddx input=#teststruct# output=wddxteststruct action=cfml2wddx [cfdump var=#wddxteststruct#] Robertson-Ravo, Neil (RX) wrote: cfscript foo = structnew(); temp = StructInsert(foo,Doprotocol, 1,yes); temp = StructInsert(foo,eventdate, 2002-01-09,yes); temp = StructInsert(foo,gender, male,yes); /cfscript cfwddx action=CFML2WDDX input=#foo# output=myfoo cfdump var=#foo# ~| 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
Try this code: WDDX problem recreated
Regarding my previous message, I managed to recreate the wddx serialization problem I was experiencing. Run this code. It should show you what I was talking about. I'll be reporting this using the wishlist form, of course. Just wanted to post it in case anyone else was interested. [cfscript] // Fabricate a query testQuery = querynew('age,gender,race'); queryaddrow(testQuery); querysetcell(testquery, 'age', 12,1); querysetcell(testquery, 'gender', 'Male',1); querysetcell(testquery, 'race', 'Black',1); maindata = structnew(); [/cfscript] [cfdump var=#testQuery#] [!--- Turn query into structure---] [cfloop index=i list=age,gender,race] [cfset structinsert(mainData, i, testquery[i])] [/cfloop] [cfdump var=#maindata#] [cfwddx action=cfml2wddx input=#maindata# output=wddxdata] [cfdump var=#wddxdata#] ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOGIN, Web Server Auth, Timeout and unwanted caching
I am using web server authentication to authenticate users entering my site. I am then using cflogin and queries to authorize their access. I am seeing problems. If I allow a cflogout tag to process it gets rid of the users roles just fine... But it does not trigger the cflogin tag to run the authorization queries again. This seems to be related to the cflogin tag's idletimeout attribute and maybe a caching behavior that I can see evidence of, but have no idea exactly how its happening. I want to match the cflogin idletimeout to my session timeout. I am setting some session variables inside the cflogin tag, for site personalization uses mainly. If I expire the session variables early then I am finding that the cflogin tag is never re-activating, thus resetting the session variables... Even if the user closes their browser and goes through the web server authentication process again. Lets say that I decide never to allow the session variables to be cleared and they only expire naturally ... And lets also assume that I don't use a cflogout tag and let the login timeout expire naturally. Then I am still seeing a problem when the user closes the browser and re-authenticates through the web browser popup. Using a *different* username and password, the cflogin tag still does not run and the session variables remain set to the last entered. Not good. For shits and giggles, I set the cflogin timeout value to 1 second. This works. The cflogin tag *always* runs the code between its cflogin and /cflogin tags (pretty much, you've got to be a fast clicker for it not to) and as such always pickes up the newest and best info. Great. But I shouldn't have to run the cflogin tag every time, should I? This is why it seems to me that the cflogin tag is caching the info somehow. I have known about the problem with using application authentication and naming your formfields j_username and j_password. I ran into that problem months ago. Yet, since I'm using web auth, that ain't my problem. One thing to note: In my code I have a condition that fires when the user's does NOT pass authorization. I display a particular template. This template always seems to display when it should, regardless of the cflogin timeout, cflogout tag or what have you. So, the cflogin tag itself works... I just can't get the crap in the middle to run when I think it should unless I set the timeout to 1 second. Here is a simplified version of my code (original cflogin timeout included). !--- Process the login--- cflogin idletimeout=86400 cfif IsDefined( cflogin ) !--- Check for user in database. Find roles of the authenticated user. --- cfquery name=authorize datasource=#request.dsn# ... Stuff ... /cfquery cfdump var=#authorize# label=Authorization cfif authorize.recordcount neq 0 and authorize.deptCount neq 0 h3This is where the session variables should be set/h3 !--- Initialize session variables for personalization and app security --- cfset structclear(session) cfparam name=session.cuserid default=#authorize.cuserid# cfparam name=session.userfullname default=#trim(authorize.userfullname)# cfparam name=session.useremail default=#authorize.email# cfparam name=session.rolename default=#authorize.rolename# h3Set User roles/h3 cfloginuser name=#cflogin.name# password=#cflogin.password# roles=#authorize.roleName# cfelse !--- user not found, deny access to site --- cfinclude template=accessdenied.cfm cfabort /cfif cfelse !--- this should never happen --- h4Authentication data is missing./h4 Try to reload the page or contact the site administrator. cfabort /cfif /cflogin ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TEST - will this post make it?
I posted a question an hour ago. It made it to the archives, but it didn't make it to the list. Will this one get through? -Patti ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Repost: CFLOGIN, Web Server Auth, Timeout and unwanted caching
I am using web server authentication to authenticate users entering my site. I am then using cflogin and queries to authorize their access. I am seeing problems. If I allow a cflogout tag to process it gets rid of the users roles just fine... But it does not trigger the cflogin tag to run the authorization queries again. This seems to be related to the cflogin tag's idletimeout attribute and maybe a caching behavior that I can see evidence of, but have no idea exactly how its happening. I want to match the cflogin idletimeout to my session timeout. I am setting some session variables inside the cflogin tag, for site personalization uses mainly. If I expire the session variables early then I am finding that the cflogin tag is never re-activating, thus resetting the session variables... Even if the user closes their browser and goes through the web server authentication process again. Lets say that I decide never to allow the session variables to be cleared and they only expire naturally ... And lets also assume that I don't use a cflogout tag and let the login timeout expire naturally. Then I am still seeing a problem when the user closes the browser and re-authenticates through the web browser popup. Using a *different* username and password, the cflogin tag still does not run and the session variables remain set to the last entered. Not good. For sh**s and giggles, I set the cflogin timeout value to 1 second. This works. The cflogin tag *always* runs the code between its [cflogin] and [/cflogin] tags (pretty much, you've got to be a fast clicker for it not to) and as such always pickes up the newest and best info. Great. But I shouldn't have to run the cflogin tag every time, should I? This is why it seems to me that the cflogin tag is caching the info somehow. I have known about the problem with using application authentication and naming your formfields j_username and j_password. I ran into that problem months ago. Yet, since I'm using web auth, that ain't my problem. One thing to note: In my code I have a condition that fires when the user's does NOT pass authorization. I display a particular template. This template always seems to display when it should, regardless of the cflogin timeout, cflogout tag or what have you. So, the cflogin tag itself works... I just can't get the crap in the middle to run when I think it should unless I set the timeout to 1 second. Here is a simplified version of my code (original cflogin timeout included). [!--- Process the login---] [cflogin idletimeout=86400] [cfif IsDefined( cflogin )] [!--- Check for user in database. Find roles of the authenticated user. ---] [cfquery name=authorize datasource=#request.dsn#] ... Stuff ... [/cfquery] [cfdump var=#authorize# label=Authorization] [cfif authorize.recordcount neq 0 and authorize.deptCount neq 0] [h3]This is where the session variables should be set[/h3] [!--- Initialize session variables for personalization and app security ---] [cfset structclear(session)] [cfparam name=session.cuserid default=#authorize.cuserid#] [cfparam name=session.userfullname default=#trim(authorize.userfullname)#] [cfparam name=session.useremail default=#authorize.email#] [cfparam name=session.rolename default=#authorize.rolename#] [h3]Set User roles[/h3] [cfloginuser name=#cflogin.name# password=#cflogin.password# roles=#authorize.roleName#] [cfelse] [!--- user not found, deny access to site ---] [cfinclude template=accessdenied.cfm] [cfabort] [/cfif] [cfelse] [!--- this should never happen ---] [h4]Authentication data is missing.[/h4] [cfabort] [/cfif] [/cflogin] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Trouble with DWMX, RDS, SSL
I had been using RDS to access my files when the system administrators installed a SSL certificate and put the entire site behind SSL. Since then I have not been able to get to my files through DWMX. I tried changing the port in the RDS settings from 80 to 443 (although I'm not actually sure about that) and I tried changing the url prefix to https://mydomainname.com;. Is there something else I'm missing? Some combination of things or preference someplace? I've searched the MM support docs, but the highest match I can find is only 52%, and seems to say nothing about SSL (even though I searched for DWMX, RDS, SSL). I also searched through the archives with similar results. I'm primarily using Mac DWMX, though I also have access to Win DWMX if that makes a difference. Thanks - Patti ~| 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
Re: MVC tool for CF
Do you have any information on pricing? There's none on the site... They want you to call their sales offices. That usually means too expensive to consider unless you've got a corporate pocketbook in my experience. -Patti Stephen Moretti wrote: Has anyone came across any Model View Controller design tool for CF? I'm trying to use one for CFMX, Flash Remoting and Flash design. http://www.synthis.com/ Have a look at adalon. Regards Stephen ~| 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: Recommend a good intro book to Objective C
Nope. Not a one. shrug Bill Brown wrote: Did you get any responses to this query? I too am looking for a good Objective-C book and found Learning Cocoa deficient in that regard. Bill ~| 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
OT: Recommend a good intro book to Objective C
Can anyone recommend a good intro book to Objective C. The target of this book is not myself, but a person with knowledge of C, Java... Who has gone through some of a computer science degree and generally knows what he's talking about. He has the O'Reilley book on learning Cocoa, but doesn't like it. The book assumes that the user has more Objective C knowledge than he does... So hence the request about the intro to Objective C book... Thanks - Patti ~| 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: Application Framework problem
No, It's not. Though you may be keeping your code in includes, you're still using Application.cfm and onrequestend.cfm to call the includes. You might as well be writing the code directly to application.cfm and onrequestend.cfm, because coldfusion processes the contents of an include AS IF THEY BELONG IN THE PAGE THAT CALLS THEM (sorry for the shouting, it was for emphasis only). So, after the server has done its work, calling the includes from these pages amounts to the same thing. What you need to do, in order to be consistent with how application.cfm and onrequestend.cfm are supposed to be used, is to write a custom tag that contains your header and your footer and call the tag specifically around all of your display templates. For example: Mylookandfeel_customtag.cfm cfswitch expression=#thistag.executionmode# cfcase value=start htmlheadtitle/title/headbody tabletrtd /cfcase !---nothing goes here --- cfcase value=end /td/tr/table /body/html /cfcase /cfswitch Myactualpage.cfm cfmodule template=mylookandfeel_customtag.cfm This is the actual code on my page. Yay, aren't I all pretty and formatted! /cfmodule Obviously this is just a toy example, but it illustrates the point. You store the formatting in mylookandfeel_customtaglcfm. You split the look in feel in half, determining where the body of the page will lie and everything above that point is in the fist case statement while everything below that point lies in the second case statement. On the page where your acutual content lies, you use a cfmodule tag to call the wrapper. Make sure the path you use in the template attribute is correct. In my little toy example I assume that I've saved the custom tag in the same directory as the page that will call it. This may not be the best site design, of course. If you store your tags in a separate central location, use a coldfusion mapping to create a path to the folder where it's located and call the mapping in the template attribute. Now you may ask, why is it such a bad, horrible thing to use application.cfm and onrequestend.cfm like you are? After all, it's so much easier to put the header and footer includes there ONCE rather than having to specifically call that pesky custom tag everything you want to put a table and some buttons around things. Well, the thing is if you put that kind of code in application.cfm, you'll be calling it EVERY time youc all ANY template. For example, lets say that in your page you are calling a couple of includes... Maybe one has a udf library. Maybe another has a whole bunch of queries. Maybe another has a calendar or something reusable like that. In that case you will be calling application.cfm 4 times... Not just once, because every time one of those includes gets called, the application.cfm file is run first. All The Time. You can imagine how horrible the resulting page would look if you ended up with four headers all nested inside one another. This is kind of an exaggeration, but I hope it illustrated the point as to why you never put anything other that application *logic* in an application.cfm or onrequestend.cfm. It's a gross abuse of the system and before long, as soon as your sites get any kind of complexity to them, it will cause many more headaches that it seems to solve. Not a sermon... Just a ... Well... Ok, maybe it was a sermon. -Patti Rick H Kennerly wrote: |o| your development in due course. You might not want to put your |o| header and |o| footer on application.cfm and onrequestend.cfm respectively. Though it |o| works, its not meant to put templates or any visual display |o| items. It's not |o| a standard practice either. |o| Guess I didn't make it clear, or atleast don't understand. the files header.cfm and footer.cfm are actually called by CFINCLUDE in the Application.cfm and OnRequestEnd.cfm. The graphic elements are not actually in the Application file. Is still not a good idea? I'd gotten the idea to that from a guide I was reading. Rick ~| 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 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
Re: Long form and variable names?
I saw this in your code: input type=button name=submit value=Submit Order It should be input type=submit name=submit value=Submit Order Type=button will not submit the form. Only tpe=submit will do so. -Patti Keith Taylor wrote: Hi all, This is probably a CF101 question, but I am missing it. I'm making an order form where each item is laid out in a table row with:itemNO,desc,price,quantity (input/text box). This is not a shopping cart. Just an order form for people who have an account. The items ordered will be sent to my client as an email, then also posted on the action page for the site visitor (you ordered x,y,z). Each row pulls the item number, desc, and price for display, then has an input/text box for the quantity to be entered. I'm passing along the description and ID data as hidden variables which will help to identify each ordered item and also to display for the visitor on the action page. When I test this, and try to hit the submit button, nothing happens. I suspect the problem is that each row has a formfield named 'quantity'. But how would this be handled alternately? I had originally had the input name for quantity to be input name=prod#ItemID#, but how then would I call this up on the resulting action page? And the email? The page in question is http://216.197.109.132/order.cfm . Thank you in advance for any help you can provide! Regards, Keith [EMAIL PROTECTED] ~| 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
SQL: Returning columns with null values when specific columns are unknown at runtime
Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Ok, I'm willing to give this a try... but I still have a question. My real table has 27 columns. I never know which columns will be null. Does that mean I want a case statement for each column that could possibly be null then? It seems like the select statment here is directly tailored to the example I used below... I will never know that much detail beforehand. I only put the example to give a visual of what I may need to return. If I send in primary key 1 then I want to return columns 3 and 4, but only if they acutally are null. The next time I run the query I'd be sendign in primary key 2 and in that case I'm returning columns 1, 3 and 4. So, I just wanted to check ... Can you explain how this is actually working? Is it relying on my explictly stating which columns I'm returning at any one time? If it is, then it's still not what I'm looking for. And perhaps what I'm looking for isn't possible. Thanks - Patti - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:26 AM Subject: RE: Returning columns with null values when specific columns are unknown at runtime SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1, CASE WHEN pk = 1 THEN col4 END AS newcol2, CASE WHEN pk = 2 THEN col1 END AS newcol1, CASE WHEN pk = 2 THEN col2 END AS newcol2 FROM mytable -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 AM To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Sorry, but you made the same mistake that simon did. I don't want to return select * I want to return select (only columns that are null and I don't know what they are up front) where primarykey = some number I didin't actually have any questions regarding the where statement at all. I'm aware that I'll probably have to use the whole IS NULL dealie... but where I'm stuck is how do I selectively return columns when I don't know which columns fit my criteria (containing null values only). Thanks - Patti - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:23 AM Subject: Re: Returning columns with null values when specific columns are unknown at runtime How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Why wouldn'g restricting by the primary key force the query to look at only the row I've specified? - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:09 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime Patti, One thing you've got to keep in mind is that if your query finds NULLs in 100 rows and amongst those 100 rows there is at least one instance of a NULL value in each of your 26 columns, you WILL get back all columns for all rows. Just want to make sure you're clear on that. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:58 To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Sorry, but you made the same mistake that simon did. I don't want to return select * I want to return select (only columns that are null and I don't know what they are up front) where primarykey = some number I didin't actually have any questions regarding the where statement at all. I'm aware that I'll probably have to use the whole IS NULL dealie... but where I'm stuck is how do I selectively return columns when I don't know which columns fit my criteria (containing null values only). Thanks - Patti - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:23 AM Subject: Re: Returning columns with null values when specific columns are unknown at runtime How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
yes - Original Message - From: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:10 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime Always for a single record at a time? -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:58 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Sorry, but you made the same mistake that simon did. I don't want to return select * I want to return select (only columns that are null and I don't know what they are up front) where primarykey = some number I didin't actually have any questions regarding the where statement at all. I'm aware that I'll probably have to use the whole IS NULL dealie... but where I'm stuck is how do I selectively return columns when I don't know which columns fit my criteria (containing null values only). Thanks - Patti - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:23 AM Subject: Re: Returning columns with null values when specific columns are unknown at runtime How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
no I don't. That's the problem. At any time it could be any random number of fields that come up empty. I know how to parse out the empty fieldnames in CF, I wanted to find a SQL solution cause I'm going to have to do this same thing for a lot of tables one right after the other and I wanted to shove off the processing to SQL server if I could. - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:14 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime Do you know the fieldnames? Or is this something that has to be figured out also? Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4 Irvine, CA 92618 949.830.1623 w w w . p t s 1 . c o m -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:56 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Ok, I'm willing to give this a try... but I still have a question. My real table has 27 columns. I never know which columns will be null. Does that mean I want a case statement for each column that could possibly be null then? It seems like the select statment here is directly tailored to the example I used below... I will never know that much detail beforehand. I only put the example to give a visual of what I may need to return. If I send in primary key 1 then I want to return columns 3 and 4, but only if they acutally are null. The next time I run the query I'd be sendign in primary key 2 and in that case I'm returning columns 1, 3 and 4. So, I just wanted to check ... Can you explain how this is actually working? Is it relying on my explictly stating which columns I'm returning at any one time? If it is, then it's still not what I'm looking for. And perhaps what I'm looking for isn't possible. Thanks - Patti - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:26 AM Subject: RE: Returning columns with null values when specific columns are unknown at runtime SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1, CASE WHEN pk = 1 THEN col4 END AS newcol2, CASE WHEN pk = 2 THEN col1 END AS newcol1, CASE WHEN pk = 2 THEN col2 END AS newcol2 FROM mytable -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 AM To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Thanks but I knew about this method. I wanted to find a SQL solution if there was one. I'm beginning to think, though, that my wish was in vain. -Patti - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:22 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime You could get the fieldnames of the table. Then check every record for a null value for every field. lets say table1 has these fields: key | col1 | col2 | col3 | col4 But I don't know the fieldnames of this table. In CF you can get the fieldnames of a table with this queryname.ColumnList then hand each of those to a select statement checking to see if any records have that field's value as NULL cfloop query=fieldname cfquery select * from table1 where fieldname IS NULL or select key,fieldname from table1 where fieldname IS NULL /cfquery /cfloop Not sure if this is still even close to the results your trying to get. Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4 Irvine, CA 92618 949.830.1623 w w w . p t s 1 . c o m -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:56 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Ok, I'm willing to give this a try... but I still have a question. My real table has 27 columns. I never know which columns will be null. Does that mean I want a case statement for each column that could possibly be null then? It seems like the select statment here is directly tailored to the example I used below... I will never know that much detail beforehand. I only put the example to give a visual of what I may need to return. If I send in primary key 1 then I want to return columns 3 and 4, but only if they acutally are null. The next time I run the query I'd be sendign in primary key 2 and in that case I'm returning columns 1, 3 and 4. So, I just wanted to check ... Can you explain how this is actually working? Is it relying on my explictly stating which columns I'm returning at any one time? If it is, then it's still not what I'm looking for. And perhaps what I'm looking for isn't possible. Thanks - Patti - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:26 AM Subject: RE: Returning columns with null values when specific columns are unknown at runtime SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1, CASE WHEN pk = 1 THEN col4 END AS newcol2, CASE WHEN pk = 2 THEN col1 END AS newcol1, CASE WHEN pk = 2 THEN col2 END AS newcol2 FROM mytable -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 AM To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
*ahem* he? Damn, who told me about the sex change? I really wish people would keep me up to date on this stuff. - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:07 PM Subject: Re: Returning columns with null values when specific columns are unknown at runtime Candace Cottrell wrote: How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL I think he wants the names of the colums that have null values as a result. Though I have no idea how to do that, or what he would like to use it for Jesse __ 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: Returning columns with null values when specific columns are unknown at runtime
interesting. -Patti - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:15 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime You can try this, I'm not sure wif this will work if col1 is null for record 1, and has a value for record 2 but you can give it a try: SELECT CASE WHEN col1 is Null THEN col1 END, CASE WHEN col2 is Null THEN col2 END, CASE WHEN col3 is Null THEN col3 END, CASE WHEN col4 is Null THEN col4 END, FROM mytable - j -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:56 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Ok, I'm willing to give this a try... but I still have a question. My real table has 27 columns. I never know which columns will be null. Does that mean I want a case statement for each column that could possibly be null then? It seems like the select statment here is directly tailored to the example I used below... I will never know that much detail beforehand. I only put the example to give a visual of what I may need to return. If I send in primary key 1 then I want to return columns 3 and 4, but only if they acutally are null. The next time I run the query I'd be sendign in primary key 2 and in that case I'm returning columns 1, 3 and 4. So, I just wanted to check ... Can you explain how this is actually working? Is it relying on my explictly stating which columns I'm returning at any one time? If it is, then it's still not what I'm looking for. And perhaps what I'm looking for isn't possible. Thanks - Patti - Original Message - From: Jim Curran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:26 AM Subject: RE: Returning columns with null values when specific columns are unknown at runtime SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1, CASE WHEN pk = 1 THEN col4 END AS newcol2, CASE WHEN pk = 2 THEN col1 END AS newcol1, CASE WHEN pk = 2 THEN col2 END AS newcol2 FROM mytable -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 AM To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
interesting... Unfortnately I don't know how to write a cursor, and there's no way I'm gonna ask for help on that! But this, and the last offering from Jim, look like they're somewhat along the lines of what i need. Thanks - Patti - Original Message - From: Joe Eugene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:22 PM Subject: Re: Returning columns with null values when specific columns are unknown at runtime You might want to try something like declare @fields varchar(200) set @fields=''; select @fields=@fields+ CASE WHEN FieldName1 IS NULL THEN 'FieldName1,' END, @fields=@fields+ CASE WHEN FieldName2 IS NULL THEN 'FieldName2,' END from TableName select @fields as ColumnName You can loop around this with a cursor and dynamically build the CASE statements. Joe - Original Message - From: Patti G. L. Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:54 AM Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
nodding Yeah, sounds like it. Ok, that cinches it. I'm gonna have to bite the bullet and do it the CF way, I think. Thanks for the help, though! Appreciate the time.. -Patti - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:19 PM Subject: RE: Returning columns with null values when specific columns are unknown at runtime If you're talking about returning the names of the columns that are null, you might be able to accomplish this with a creative stored procedure... You would have to draw a query from the syscolumns table to get the names of the columns in that table ( unless you knew all the column names ahead of time ), then use a combination of a cursor(s) and exec sp_executesql to determine which columns are null and place the resultant column names in a temp table, then return all rows from the temp table. It's an awfully complicated process ... S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 I think you would need to right some type of union statement that would have to look at each field in your table separately. it would then return a record set with only the fields that were blank, actually it would only return the key of the record to cold fusion but in query ann it would show the fieldnames also. Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4 Irvine, CA 92618 949.830.1623 w w w . p t s 1 . c o m -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:58 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Sorry, but you made the same mistake that simon did. I don't want to return select * I want to return select (only columns that are null and I don't know what they are up front) where primarykey = some number I didin't actually have any questions regarding the where statement at all. I'm aware that I'll probably have to use the whole IS NULL dealie... but where I'm stuck is how do I selectively return columns when I don't know which columns fit my criteria (containing null values only). Thanks - Patti - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:23 AM Subject: Re: Returning columns with null values when specific columns are unknown at runtime How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ 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: Returning columns with null values when specific columns are unknown at runtime
Gee thanks! Ok, I will. I'll have to wait a couple of days, though. While I'm offsite I don't have access to the SQL server due to the client's rather anal security. I've read it through a couple of times and I'm pretty sure I see what's going on. The only question I have, though it may be obvious, is to check if I'm to pass in the @tablename, @pk, @uid values to the procedure like I think I am. And what is the difference between the @pk and @uid variables? @pk is primary key, yes? Is @uid the same value? -Patti - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 2:17 PM Subject: Re: Returning columns with null values when specific columns are unknown at runtime Hey Patti, Try this stored procedure: alter procedure sp_fetchNullColumnNames @tablename sysname, @pk sysname, @uid int, @schema sysname = 'dbo' AS declare @colname sysname; declare @strSQL nvarchar(1000); create table #c ( column_name sysname); insert into #c select column_name from information_schema.columns where table_schema = @schema and table_name = @tablename; declare curColumn cursor local fast_forward for select column_name from #c; open curColumn; fetch next from curColumn into @colname; while (@@fetch_status = 0) begin set @strSQL = ('if ((select ' + @colname + ' from ' + @schema + '.' + @tablename + ' where ' + @pk + ' = ' + convert(nvarchar,@uid) + ') IS NULL) ' + ' delete from #c where column_name = ''' + @colname + ); print @strSQL; exec sp_executesql @strSQL; fetch next from curColumn into @colname; end close curColumn; deallocate curColumn; select * from #c; drop table #c; go Ok, I'm willing to give this a try... but I still have a question. My real table has 27 columns. I never know which columns will be null. Does that mean I want a case statement for each column that could possibly be null then? It seems like the select statment here is directly tailored to the example I used below... I will never know that much detail beforehand. I only put the example to give a visual of what I may need to return. If I send in primary key 1 then I want to return columns 3 and 4, but only if they acutally are null. The next time I run the query I'd be sendign in primary key 2 and in that case I'm returning columns 1, 3 and 4. So, I just wanted to check ... Can you explain how this is actually working? Is it relying on my explictly stating which columns I'm returning at any one time? If it is, then it's still not what I'm looking for. And perhaps what I'm looking for isn't possible. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: Returning columns with null values when specific columns are unknown at runtime
I've been playing with this method for a while and it's not doing it. It always returns all of the columns in the case statment (even without the else). Seemed like a good solution at first, but nope. Ah well. It was a fighting try it were. -Patti - Original Message - You'd also need an AS after the END for each column ... and I'm not sure what happens when the column is not null, but I suspect it would return NULL unless there's an ELSE clause in which case you'd be saying CASE WHEN col1 is null THEN col1 ELSE col1 END which ends up being the same thing as SELECT * FROM mytable... S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 - Original Message - interesting. -Patti - Original Message - You can try this, I'm not sure wif this will work if col1 is null for record 1, and has a value for record 2 but you can give it a try: SELECT CASE WHEN col1 is Null THEN col1 END, CASE WHEN col2 is Null THEN col2 END, CASE WHEN col3 is Null THEN col3 END, CASE WHEN col4 is Null THEN col4 END, FROM mytable - j __ 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: Returning columns with null values when specific columns are unknown at runtime
Funny thing is, this happens to me perpetually ... not sure why, maybe I was a woman in my last life or something. :) p.s. So what else has changed about your life since the sex change? :) Laughing quite joyously at thoughts of your past life as the bearded lady mock seriousness Thanks for asking, but I'm afraid it didn't take. morosely These damn breasts keep coming back! Dastardly things... - That's all folks (sorry, couldn't resist... will behave better in the future) -Patti __ 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: CFMX and Flash MX - books
Good choice. Although do the author a favor and buy it from his website. :) www.wheelmaker.org Eventually there will be code downloads and errata on this site as well. Right now it's a little spare, but it'll be up to speed soon. -Patti - Original Message - From: Stacy Young [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 13, 2002 5:27 PM Subject: RE: CFMX and Flash MX - books I found that to be the case as well except there are few books that have very OO orientated AS which can throw off a CF'er a little... Planning to pick this one up: http://www.amazon.com/exec/obidos/ASIN/0735711836/103-3353215-8119850 Stace -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 3:58 PM To: CF-Talk Subject: Re: CFMX and Flash MX - books On Friday, September 13, 2002, at 12:00 , Stephenie Hamilton wrote: I picked it up, and the action script in it was over my head...i can basic things in flash only...so I just picked up a couple of other Flash MX books to get me up to speed. The CF stuff in this Reality I understood (so far), but not the flash Hmm, I guess a lot depends on how much you use cfscript. Anyone who is familiar with cfscript should have no problem with the Reality book (I'm reading it at the moment). If you don't use cfscript much, then it will be a bit daunting. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Nice
Wow. Try looking at that in Mozilla. The serialize link only shows the background, not the swf. The validate link is simply scary. Not that it matters, of course. Just as a point of interest. -Patti - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 1:39 PM Subject: Re: Nice On Tuesday, September 10, 2002, at 09:35 , Howie Hamlin wrote: Or, you can cheat (once you log in to administrator): http://localhost:8500/cfide/administrator/settings/_licensedata.cfm?serializ e Ah, I wondered where that swf was going to show up (after seeing it on the internal Neo site for a while). Cute! BTW, it wouldn't work with serialize for me - I had to say validate. BTW2, to stop Dick whining, the following URL *does* work on a Mac: http://localhost:8500/cfide/administrator/settings/_licensedata.cfm?validate Happy now, Dick? ;) Sean A Corfield -- http://www.corfield.org/blog/ __ 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: Dreamweaver MX opinions
I live in Rome. However, I would really like to see an open file management system for dwmx-mac that is more like the Win version for the Mac. I can deal with the non-dockable nature of the panels... the one thing I really miss is the tabbed windows for all the different files you have open. it really annoys me how difficult it can be to navigate between any of the 5-10 windows I might need to have open at any time... not to mention the how each successive window has less and less real-estae for me to work with. - Original Message - From: Jesse Noller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 12:51 PM Subject: RE: Dreamweaver MX opinions Yes, it CAN be done, but that is not the way the Apple User interface was designed. When in rome, do as the romans, so to speak. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Ever seen Jedit? www.jedit.org ... Apparently it can be done. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] On Thursday, September 5, 2002, at 08:54 , Joshua Miller wrote: Yeah, and unless I'm missing something, the Mac OSX version doesn't even include a dockable file browser like the Windows version does. Because the Mac windowing idiom is different - Mac apps typically do not behave like that. __ 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: Women programmers
Great, now I feel nice and suitably objectified. My day just isn't complete until *that* has happened. I was beginning to worry... Now I'm sure you'll escuse me while I go and get dressed in pink while I make something look pretty. -Patti X not to mention, the eye candy factor increase ;) __ 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: programmer vs. developer
CFML... The people I know often use developer as a step up from programmer to indicate someone who designs and plans instead of just codes... That's funny. I tend to prefer to call myself a developer because I think it signifies a step down from programmer. I don't want to come off as putting on airs, but I also feel that at his point, producer or something suitably humble doesn't describe my skill level either. __ 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
Test
This is a test. __ 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: CFMX CurrentRow?
None of your examples used the syntax: cfoutput query=getEmloyee #currentrow# /cfoutput That one does work, which is I believe what Sean and Watts were saying. CFLOOP is a completely different animal. - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 12:15 PM Subject: RE: CFMX CurrentRow? Sean, My reply was orientated more at the original post. The reason I post the question is I was wondering if maybe an unscoped currentRow variable was available to pre-CFMX versions that contained the last value of currentRow in a loop. However, I just tested this in CF4.51, CF5 and CFMX and an unscoped currentRow variable does not exist. For that matter, the all the different behaviors I tested acted the same: !-- example 1 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset currentRow = getEmployee.currentRow /cfloop cfoutput#currentRow# :: #getEmployee.currentRow#/cfoutput !-- example 2 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #getEmployee.currentRow#/cfoutput !-- example 3 (causes an error) -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #currentRow#/cfoutput In all cases the first variable contained the total number of records and the second value either was undefined or 1. -Dan -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:53 AM To: CF-Talk Subject: Re: CFMX CurrentRow? On Thursday, August 22, 2002, at 07:27 , Dan G. Switzer, II wrote: Out of curiosity, which syntax are you using: #currentRow# or #queryName.currentRow# I know that #queryName.currentRow# works. The latter. I wouldn't have expected the former to work - does it work in pre-MX releases? The reason I think like that is that, to me, currentRow is a pseudo-column so you shouldn't expect it to be available 'unadorned', only as part of a query-qualified reference. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: isDefined question
And multiple select lists / listboxes with nothing selected ... and submit buttons that have not been pressed. - Original Message - isDefined(variableName) and Len(variableName) are used in different contexts. All form values are defined except checkboxes without any data. And radio buttons, don't forget those. :) Isaac Certified Advanced ColdFusion 5 Developer __ 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: CFMX CurrentRow?
Ah, of course. I somehow missed the point in the midst of the example code. My bad. - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 9:19 AM Subject: RE: CFMX CurrentRow? Patti, My point was the same as Sean's and that the currentRow is only available while iterating over some type of CF query object (via cfoutput or cfloop.) You can't expect currentRow to equal the last row accessed after looping through a collection, unless you're actually declaring a variable called currentRow in the variables scope. -Dan -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 8:08 AM To: CF-Talk Subject: Re: CFMX CurrentRow? None of your examples used the syntax: cfoutput query=getEmloyee #currentrow# /cfoutput That one does work, which is I believe what Sean and Watts were saying. CFLOOP is a completely different animal. - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 12:15 PM Subject: RE: CFMX CurrentRow? Sean, My reply was orientated more at the original post. The reason I post the question is I was wondering if maybe an unscoped currentRow variable was available to pre-CFMX versions that contained the last value of currentRow in a loop. However, I just tested this in CF4.51, CF5 and CFMX and an unscoped currentRow variable does not exist. For that matter, the all the different behaviors I tested acted the same: !-- example 1 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset currentRow = getEmployee.currentRow /cfloop cfoutput#currentRow# :: #getEmployee.currentRow#/cfoutput !-- example 2 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #getEmployee.currentRow#/cfoutput !-- example 3 (causes an error) -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #currentRow#/cfoutput In all cases the first variable contained the total number of records and the second value either was undefined or 1. -Dan -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:53 AM To: CF-Talk Subject: Re: CFMX CurrentRow? On Thursday, August 22, 2002, at 07:27 , Dan G. Switzer, II wrote: Out of curiosity, which syntax are you using: #currentRow# or #queryName.currentRow# I know that #queryName.currentRow# works. The latter. I wouldn't have expected the former to work - does it work in pre-MX releases? The reason I think like that is that, to me, currentRow is a pseudo-column so you shouldn't expect it to be available 'unadorned', only as part of a query-qualified reference. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: OT Question about Flash and GIS
I can't answer your question, but you might try asking the FlashCoders list. Warning, thought it's extremely high traffic. Sort of like this list. Sometimes much worse. http://chattyfig.figleaf.com I know this is off-topic, but does anyone know if I can feed GIS info into flash and create images in flash from the GIS coordinates? Does anyone know where I could ask this question? __ 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
Need to report a DWMX bug and include the template
The only url I have to report bugs is the MM Wish form and Bug report here: http://www.macromedia.com/support/email/wishform/ I have created a template that crashes my DWMX on Mac OS when I take certain steps. On Win XP it doesn't crash, but I do get a nice little error message. So, I thought somebody would want to hear about it and have my template on hand as well. I just thought I'd check and see if I should report it through any other means, where I could upload the actual file, before I do a big old cut and paste of my code in the link I do have. -Patti __ 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: CFMX best practices and Imaging Lib
Comment on the font: I can deal with the tiny size, but when I print it out it is just a shade darker than the page. Not all that readable onscreen... definitely unreadable in print. Otherwise, looks interesting. -Patti - Original Message - From: Benoit Hediard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 9:30 AM Subject: CFMX best practices and Imaging Lib Hi, I've put online : - an Imaging UDF library (based on ImageJ), - some CFMX Best Practices (not bulletproof best practices, just some dev techniques I am using). http://www.benorama.com/coldfusion Next week, I'll add a Pagelet and I18N custom tags. Any feedbacks are welcome. Ben PS : I didn't want to start another CF blog, so I have done this small MX resource center, where I am going to share some of my MX work. __ 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: quotation marks and their rules...
In that case len(status_code) will always return 1, cause status_code=0 has a length of 1. The condition I you may be trying for is: Isdefined(status_code) and status_code This will trigger the false you were looking for since when status_code evaluates to 0, coldfusion will recognize that as the boolean for false. -Patti Tony Weeg wrote: yes, status_code was set to 0 prior to the beginning of the loop ;) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 10:50 PM To: CF-Talk Subject: RE: quotation marks and their rules... cfloop condition=isDefined(status_code) and Len(#status_code#) why doesnt this make sense? How would CF ever exit from that loop? Are you setting status_code equal to an empty string within the loop? In any case, try this: cfloop condition=IsDefined('status_code') and Len(status_code) ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CFLOGIN Problems
Guys read this thread; it may help you out. I have a feeling that the issue you were having would have been answered if certain jedi masters weren't away this week. I have been having a problem with cflogin myself. I believe it is close to what Frank noted and this post provides a solution to my problem. I haven't yet implemented the fix (don't name your form fields j_username or j_password, no matter what the docs say), but I think it is going to work. Be careful of the wrapping. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 375144highlight_key=ykeyword1=cflogin -Patti Barry Moore wrote: Frank, You are not imagining things. I had some cflogin code that I had written during Beta test that worked just fine. I went to use it again last night on a release version of CFMX and it does not work anymore. CF does not seem to remember the login info from one page to the next. It logs the user in just fine, but when they go to a new page all the login variables are gone. If you find an answer let me know, I will do the same. Barry -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 24 July 2002 3:48 AM To: CF-Talk Subject: CFLOGIN Problems I am trying out the functionality of the CFLOGIN tsg snf it doesn't seem to work as advertised. According to the docs Code in thr cflogin tag only executes if there is no user is logged in. The system authenticates and displays the protected page but when accessing another page in the same dir the same code re-executes and doesn't see the form login vars and boots me to the login page. Am I missing something? Here is part of the code in Application.cfm: Thank you all. cfset AllowedRoles = Domain Users cflogin cfif isdefined(form.password) and isdefined(form.username) !--- WE NEED TO PROVIDE THIS SOMEHOW. SIMILAR TO NT LOGIN WOULD DO. --- CFSET Request.myDomain = STS1 !--- TRY TO AUTHENTICATE USER --- cfinvoke component = NTSecurity method = authenticateUser domain = #Request.myDomain# userid = #form.username# passwd = #form.password# returnVariable = Auth cfif #Auth# IS True !--- SUCCESS --- cfset failed = no !---NOW LET'S CHECK WHAT GROUPS(roles) I HAVE --- cfinvoke component = NTSecurity method = getUserGroups domain = #Request.myDomain# userid = #form.username# passwd = #form.password# returnVariable = MyGroups cfoutput CFSET TheRoles =#Replace('#MyGroups#',', ',',','All')# /cfoutput cfloginuser name=#form.username# password=#form.password# roles=#TheRoles# CFELSE !Did not pass authentication so redirect with message--- cfset message = There was a problem with your login. cflocation url=../../#LOGINPATH#?url=#cgi.script_name##cgi.query_string#message=#mes sage# addtoken=no /CFIF CFELSE !---No FORM login vars so redirect to login page --- cfset message = cflocation url=../../#LOGINPATH#?url=#cgi.script_name##cgi.query_string#message=#mes sage# addtoken=no /CFIF cflogin __ 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: Client Database question
Bud wrote: LOL This has certainly strayed off of my original question which has nothing do do with Stored procedures or Fusebox. I'll re-post the question, which is concerning client database access: Nice Try. __ 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: cfmx and SQL Server Data Source Configuration
Are you authenticating using Windows trusted or by specifically passing in a sql server username and login? I had a similar problem and this was my savior. I believe the reason was that the JDBC drivers that the datasources are based on do not allow the trusted windows authentication option. On 7/22/02 4:06 PM, Brian Scandale [EMAIL PROTECTED] wrote: I just upgraded from CF5 to CFMX by Uninstalling CF5 and then Installing CFMX. For the last three hours I have been trying to re-establish datasource connections to SQL server which is running on the same box without any luck. This is the error: --- Connection verification failed for data source: cfusion_clientreg []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Any hints from anyone who has already done this? Thanks, Brian __ 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
Question: Var when writing components
Now, I know that when you are writing a UDF you use var to scope all local udf variables, keeping them from existing in the variables scope of the calling page. I have physically seen this behavior in my tests. But... What I'm not understanding is if var is necessary in the same way or for the same reasons when writing components. I know Raymond says it is so... And I'm not suggesting he's wrong, I'd just like to know why. When I write a component and do not use var the local variables in my component stay local to the component... I can't examine them when I'm viewing the variables scope on the calling page. Is there a reason (other than good form) to use var when building a component? I believe that in flash var-ing variables actually saves memory space in that the variables are destroyed when the function ends... -Patti __ 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: Question: Var when writing components
Raymond, Simon... Thanks to both. *That* is the explanation I was looking for. -Patti P.s. Simon, notice the i :) __ 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: Using THIS scope in CFCs
That being said - you can use a 'pseudo' private scope in CFCs by not using var or This. In ways, it acts like a local Variables scope for Wait... I just got confused. Why is it more private if you don't var the variable? I get the This aspect just fine. But if by not var-ing, you run the risk of variable overwriting when calling cfcs from other cfcs, then why is it more local or private not to var? CFCs (although you can't dump it). This can be useful for CFC data that you want to store - but keep private. Or, did I just completely misunderstand? -Patti __ 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: Using THIS scope in CFCs
All right. I can see the difference from your example. Now, just to be like the proverbial toddler that doesn't know when to stop asking why... Now explain cfproperty. In the example below, for example, what would be different if you made ID a property of the human object rather than a non-var local variable? In that case would ID be something that *is* viewable/changeable by the user (which would be a bad idea for an ID, of course). If I wanted info that the user could see or change, why would I decide to do this.name rather than cfproperty name=name? I'd love to promise that I'll stop after this one. -Patti On 7/17/02 4:49 PM, Raymond Camden [EMAIL PROTECTED] wrote: Wait... I just got confused. Why is it more private if you don't var the variable? I get the This aspect just fine. But if by not var-ing, you run the risk of variable overwriting when calling cfcs from other cfcs, then why is it more local or private not to var? Sorry, let me back up a bit. Imagine a CFC that looks like so: cfcomponent displayName=human cfset this.name = Nameless cfset this.age = 0 !--- various methods --- /cfcomponent What I have here is the bare skeleton of a human CFC. I also define to variables, name and age, in the this scope. These values are public. If I make an instance of human called Ray, I can output ray.name. So - it's not that much of a stretch to imagine needing data that is NOT public. For example, maybe ID: cfset this.name = Nameless cfset this.age = 0 cfset ID = createUUID() The ID value will persist along with name and age, but will not be viewable/changeble by the user. So - how would you use this data in methods? You would treat it as any other global variable. That means if you have methods that also use the variable ID, but you mean it to be a temp var, you would need to var scope them. The basic idea is - if you use data that is NOT This scoped or var scoped, you can consider it as a private variable. As long as you are anal about var scoping everything else, these values will be safe. Make sense? Before certain people jump on me - I am NOT saying this is 100% like the private scope in Java. I'm just saying it acts like a set of data that is private to the CFC. Enjoy. Use it or not - it's up to you. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ 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: Using THIS scope in CFCs
nodding vigorously Cool stuff and good to know. My inner toddler has found her pacifier. Thanks, Ray. -Patti On 7/17/02 5:08 PM, Raymond Camden [EMAIL PROTECTED] wrote: Now explain cfproperty. In the example below, for example, what would be different if you made ID a property of the human object rather than a non-var local variable? When using CFCs, cfproperty does absolutely nothing. It can be used to help describe web services, but strictly speaking for CFCs, they don't do anything... except... You can use cfproperty to define metadata for the CFC. For example, I may do this in my CFC: cfproperty name=age type=numeric cfset this.age = 0 Now if I call getMetaData on the CFC, I will see age as a property. What's cool is that I can write a validation routine that says: Since Age is defined as Numeric, look at this.age. Is it numeric? If not, throw an error. I have a general purpose UDF that allows you to use cfproperty in your CFC and then perform validation on the object data. (It even recurses up the inheritance.) Does that help? By the way, you can even do stuff like: cfproperty name=age type=numeric range=1,90 ray=1 Both range and ray will show up in the metadata and you can use them as you see fit. In that case would ID be something that *is* viewable/changeable by the user (which would be a bad idea No. CFPROPERTY will not change how the value ID is visible. It shows up in the metadata as a property, but the VALUE doesn't. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ 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
Component Calls: What would you do?
I have written a component called Department that contains functions for inserting, editing, deleting department information. I have begun to write a component called Audit Trail that will be used to log all of the user's actions. Which would you do to implement the audit? Lets assume that I am editing a department... 1) In the calling page first call the department.edit() method of the department component directly followed by the auditTrail.log() method of the audit trail. 2) In the calling page call the department.edit() method of the department component. In the department component, in the edit method call the auditTrail.log() method. Of course keep in mind that I'm going to have to call the auditTrail component every time an insert, edit or delete action is made... Is it better / more oop (not that I know exactly when I'm respecting/violating the rules of OOP as it is) to do number 1, 2 or is there some other option I should be considering? -Patti __ 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: Component Calls: What would you do?
Either one is functional. It depends on what you are trying to do. Do you want to log every single time you use the edit (Insert / Delete) functions? If so, then write the code directly into the department component. Does AuditTrail have any function other than logging actions in department? If not, there is probably no need for it to be a separate component. Perhaps it could be a private method inside the department component? AuditTrail doesn't do anything other than log events, BUT it will be used all over the place, not just in conjunction with departments. Since I'll be using this all over the place I wrote it as its own component and will plan to call it everytime a logging action needs to happen. If you truly want to apply OO concepts to your design, you may want to look into picking up an Object Oriented design book. If you can find one that is language independent, it would probably be more beneficial than a language-driven book. Of course. Picking up books is always useful. In this case, though I don't have the time that I personally need to absorb book larnin' to the point where I can directly apply it. So I'm proceeding as best as I can with the knowledge that I have... And the human resources I have available to me when absolutely necessary. I saw Ray mentioned the possibility of inheriting the auditTrail CFC in the department CFC. That is probably not an OO solution, since a department is not an auditTrail. This would be an is-a relationship, and is usually implemented using inheritance. Makes sense. A department has an audit trail, though. This is a has-a relationship, which is usually implemented using properties. You could make a property with the type being auditTrail. However, I am unclear as to how you would access methods of auditTrail via the property of department. ( if that makes sense). Hmm. Sounds like a possibility, but since I've not run across any articles pertaining to the use of component properties (or if I have I haven't read them through well enough) I've been staying away from properties. So far I've just worked with my departments component which contains doer-type functions... I haven't built components that make instances of anything real. Since properties make me thing of instantiatable objects, I haven't considered using them... Mostly because I can't fathom how I should use them based on how I've structured the component(s) I've built so far. Mom always said I had to learn the hard way. Unfortunately in this case (only!) she may be right. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ 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: Component Calls: What would you do?
That sounds somewhat familiar (I've been listening to this kind of talk RE: Flash Actionscript for quite a while). It's one of those concepts where I don't get lost when listening to someone explain it, but when trying to figure out how to implement I get headaches. Luckily you've already said that it isn't really possible in CFMX, which neatly takes the weight off of my somewhat taxed shoulders. Well since you asked... the way to do this more OO isn't really possible in CFMX. However, if you interested in how it would be done in Java, then here you go. You would create a Department class just as you described above. Instead of creating an audit trail class you would create a Audit interface. You would want to create an implementation of the Audit interface with a class callded AuditTrail. Then create a new class, AuditedDepartment that extends the Department class and implements the Audit interface. The AuditedDeparment class would override the methods of the Department class, but call the super class's methods and the AuditTrail's methods. For example, the edit method might look like this. public void edit() { super.edit(); auditTrail.log(); } -Matt __ 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: Fiscal Year UDF
Have you considered submitting your udf to cflib.org? -Patti __ 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: DWMX + CFMX as standalone server
Yeah, That's my problem. I'm still running an older Beta. I never upgraded to the Preview release. Thanks. -Patti - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 10:02 AM Subject: RE: DWMX + CFMX as standalone server Are you sure it is port 8100? That was the default in early betas, but the final version (and the preview release of a few weeks ago) default to 8500. Might want to check that. --- Ben -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:27 PM To: CF-Talk Subject: DWMX + CFMX as standalone server I'm doubting that I'll get the answer I'm looking for, but thought I'd try. I've had this problem for a while, but I've been ignoring it. Now, I'd like to try and resolve the issure if I can. I am using CFMX as a standalone server. On the same machine I have CF5 installed. I want to access my CFMX datasources with DWMX I can successfully define a CF5 DWMX site so that in the Application Panel Server Behaviors Window all of the steps, 1-5 have been checked off as completed and I'm able to access all of my CF5 datasources. However, when I try to use a CFMX site, in the Application Panel Server Behaviors window, only steps1-3 work. Step 4, which is Specify the RDS login for your ColdFusion server does not ever validate. When I click on its link, I get an error: The server name or address could not be resolved. Possible reasons: 1. The URL specified for this site's testing server may be incorrect: http://localhost:8100/calories. 2. The testing server may be incorrectly configured (for example, ColdFusion may not be running. Now, the URL is not incorrect. In fact, when I Preview in Browser, the url displays perfectly well. Substituting my specific IP address for localhost does nothing. I do not believe my server is incorrectly configured either. If it were, then the url would never pull up the page in question, and it DOES work. In the site configuration Testing Server windowI have as my server model, ColdFusion. This Site contains Dreamweaver MX Pages Only. Access, RDS In the site configuration Remote Info, my access is RDS and my settings are Host Name, localhost, Port 8100, Full Host Directory D:\CFusionMX\wwwroot\calories my username is blank and my password is entered. These SAME entries, work when I use a CF5 site, except that obiously the Port is 80 and the Host Directory would be D:\inetpub\wwwroot\calories. Can anyone give me an idea why I'm having this problem? __ 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: ColdFusion Server 5.0 trial download?
Copied from a post on another list I'm on: If you go to the CF pages (like http://www.macromedia.com/software/coldfusion/), the link offered for downloads on the right nav bar will take you to http://www.macromedia.com/software/coldfusion/downloads/, where the only links seem to be to MX. But in the bottom right of that page is a link to the innocuous looking ColdFusion Support Center Downloads. You can find downloads for CF Server 5 on this page. However if you're also looking for CF Studio 5, nobody I know has found a link to it on MMs site since DWMX -Original Message- From: UXB Internet [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 1:31 PM To: CF-Talk Subject: RE: ColdFusion Server 5.0 trial download? Todd, We are a small firm and place a high value on functional stability. We are purposely not on the bleeding edge of the technological curve. For our market this wait and see attitude has served us very well. We waited for 4.5 to see heavy use and it never seemed to be as stable as 4.0. So we were waiting for masses to test 5.0 for us and now CF5.0 seems to be a stable product. Due to unexpected external circumstances we did not purchase the CF5.0 upgrade before the MX release. The introduction of MX looks interesting but hasn't seen mass use yet so we'll wait a while. Besides, MX does not support our web server Deerfield Website (formerly O'Reilly website pro). We can't use it right now without switching web servers, and I cannot afford the time such a task would entail, to say nothing of the cost. And No we will never use IIS, I would go out of business before switching to IIS, as irrational a statement as that may sound. I have queried Macromedia via email on acquiring a CF5.0 upgrade and I awaiting their response. If I don't hear from them by Monday I guess I'll have to start calling Software supply houses to see if someone has a copy or two on the shelf I can purchase. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 12:43 PM To: CF-Talk Subject: Re: ColdFusion Server 5.0 trial download? Dennis, Sounds like you'll have to go straight from 4 to MX. Should have bought 5.0 after 5.0 was released. :/ ~Todd On Fri, 31 May 2002, UXB Internet wrote: Vernon Viehe [mailto:[EMAIL PROTECTED]] said: Since CFStudio is no longer a product for sale, there's no trial of it. How about CF Server 5.0 is the upgrade from 4.0.1 still available for us slow to adopt and you aren't supporting my web server with MX people? Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ __ 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: [style] usernames
What do you do, then, if by chance the old email address that the user signed up with is no longer in service? Then, even if they could remember the right email they couldn't retrieve the password? This has happened to me before and I've been SOL. -Patti As for username/password retrieval All we ask for is an email address. Easy enough ... Unless of course you forget your email address that you used and we've never had that problem yet (knock on wood). Even someone like myself, who has 1/2 dozen or more email addresses can always keep poking away until they've found the email address that's on file. I've done it, so I know it's not that big of a deal. The password reminder feature that I implement always emails both the username and password to the forgetful user. __ 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
DWMX + CFMX as standalone server
I'm doubting that I'll get the answer I'm looking for, but thought I'd try. I've had this problem for a while, but I've been ignoring it. Now, I'd like to try and resolve the issure if I can. I am using CFMX as a standalone server. On the same machine I have CF5 installed. I want to access my CFMX datasources with DWMX I can successfully define a CF5 DWMX site so that in the Application Panel Server Behaviors Window all of the steps, 1-5 have been checked off as completed and I'm able to access all of my CF5 datasources. However, when I try to use a CFMX site, in the Application Panel Server Behaviors window, only steps1-3 work. Step 4, which is Specify the RDS login for your ColdFusion server does not ever validate. When I click on its link, I get an error: The server name or address could not be resolved. Possible reasons: 1. The URL specified for this site's testing server may be incorrect: http://localhost:8100/calories. 2. The testing server may be incorrectly configured (for example, ColdFusion may not be running. Now, the URL is not incorrect. In fact, when I Preview in Browser, the url displays perfectly well. Substituting my specific IP address for localhost does nothing. I do not believe my server is incorrectly configured either. If it were, then the url would never pull up the page in question, and it DOES work. In the site configuration Testing Server windowI have as my server model, ColdFusion. This Site contains Dreamweaver MX Pages Only. Access, RDS In the site configuration Remote Info, my access is RDS and my settings are Host Name, localhost, Port 8100, Full Host Directory D:\CFusionMX\wwwroot\calories my username is blank and my password is entered. These SAME entries, work when I use a CF5 site, except that obiously the Port is 80 and the Host Directory would be D:\inetpub\wwwroot\calories. Can anyone give me an idea why I'm having this problem? __ 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