RE: CFStoredProc bug?
Hmmm, I know I still pass in @varname in dbvarname as it doesn't fail so at least it is backward supported!! -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 21 December 2004 19:41 To: CF-Talk Subject: Re: CFStoredProc bug? The dbvarname attribute is no longer used in CFMX: it is now ignored for all drivers ColdFusion MX does not support named parameters. Why does this strike me as MM saying It's not a bug, it's a feature! ??? I wonder what convinced MM to do away with that little tidbit... did they think that people would always pass all of the parameters to all of their stored procedures? Makes me wish I could write my own version of CFStoredProc and have it override the one MM has in there. What's that called again? Okay, well I know the easy way to fix it so I'll just work that into the code... and double check the order of my procparam's in the rest of the cfstoredproc's I've gotten in there. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Setup datasource thru code?
Yeah, there is a factory method you can use : http://www.petefreitag.com/item/152.cfm I don't see how or why this isn't supported as isn't this what CF is using to create DSN's itself? -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: 21 December 2004 23:32 To: CF-Talk Subject: Re: Setup datasource thru code? On Tue, 21 Dec 2004 15:59:08 -0600, Donna French [EMAIL PROTECTED] wrote: Is there a way to setup a datasource thru code instead of using the CF Admin? Not in any supported way on CFMX (there is an unsupported way). Ben Forta has talked about a CF Admin API in Blackstone so maybe you should join the beta... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 4 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
Hmm, I find this hard to swallow and I would question your 'DBA' without seeing the facts. We run daily extensive tests on speed etc and we have found that SP's are as fast if not faster than CFQUERY in most cases. We use SP's not necessarily for the speed increase - mainly for abstraction, security and the way we can pass back multiple SQL blocks and we can allow the SQL Server to perform data manipulation over using CF/Inline SQL - which is not as efficient. For a simple SELECT name from TABLE, I think you are probably going to see no different and indeed a CFQUERY may even be faster (head on block). Based on the comments - I ran a quick test with an SP which basically ran the following (where iLanguageID and iEventID were @ variables passed in via dbvarname): Inline Call: SELECT tblExAdminTextContent.vcContentName, tblExAdminTextContentAlias.tContent FROM tblExAdminTextContentAlias INNER JOIN tblExAdminTextContent ON tblExAdminTextContentAlias.iContentID = tblExAdminTextContent.iContentID WHERE iEventID = 100306 AND iLanguageID = 1 AND iLinkID IS NULL Stored Procedure: risp_ExAdminSiteLanguageDefaults 100306,1 The results were the duration were as following: Inline SQL: CPU: 16 Reads: 500 (fluctuates between 422-500) Writes: 0 Duration: 13ms Stored Procedure: CPU: 0 Reads: 422 (fluctuates between 422-500) Writes: 0 Duration: 0ms Now, this is by no means a solid call as it can fluctuate between them both taking 0 duration but never the SP taking any more than that and shows its more efficient. Obviously this is a test on a fairly simple proc but there is no way your DBA can say that it's a performance killer and to be honest with you if he is an MSCDBA then it's a shocking call to make. Client vars do perform updates internally using SP's for EVERY CALL if you do not switch that method off via the Client Vars section - maybe this is what your DBA was seeing? This does indeed cause 3 SP's to run for every .CFM thread; turn the updates off if you don't need last visit and hit count updated constantly. HTH Neil -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: 21 December 2004 20:32 To: CF-Talk Subject: Re: CFStoredProc bug? Michael Dinowitz wrote: Thank you for pointing that out. It looks like I missed that. So basically, the order of cfprocparams being passed is all that matters and no parameter can be missed when writing cfprocparam tags. Is there any performance (i.e. binding) savings to using the CFSTOREDPROC tag vs. a CFQUERY with CFQUERYPARAMs? Is the CFSTOREDPROC call as efficient? Better? What's the advantage? Anyone from MM want to comment? Thanks I've seen some strange behavior with cfstoredproc, and our DBA has requested that we don't use it. If you trace your database (tested on sql2k), you will see cfstoredproc creates and compiles a procedure, calls that procedure a number of times (depending on how many recordsets you are expecting), then destroys the temp proc. For this reason, you will have degraded performance on cfstoredproc than you will calling a stored procedure from a cfquery block. We've seen the same behavior with client variables, so we don't use them. It's also my understanding that cfquery with cfqueryparam values can be as fast as stored procedures. The benefit, of course, comes when the SQL statements you are running are large enough to effect bandwidth between the web and database servers. You'll get some delay when you have to write 200 lines of SQL to your DB, vs 3 or 4 using a stored procedure. -nathan strutz http://www.dopefly.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
I've seen some strange behavior with cfstoredproc, and our DBA has requested that we don't use it. If you trace your database (tested on sql2k), you will see cfstoredproc creates and compiles a procedure, Hmm, I find this hard to swallow and I would question your 'DBA' without seeing the facts. We run daily extensive tests on speed etc and we have found that SP's are as fast if not faster than CFQUERY in most cases. We use SP's not necessarily for the speed increase - mainly for abstraction, security and the way we can pass back multiple SQL blocks and we can allow the SQL Server to perform data manipulation over using CF/Inline SQL - which is not as efficient. For a simple SELECT name from TABLE, I think you are probably going to see no different and indeed a CFQUERY may even be faster (head on block). Based on the comments - I ran a quick test with an SP which basically ran the following (where iLanguageID and iEventID were @ variables passed in via dbvarname): Inline Call: SELECT tblExAdminTextContent.vcContentName, tblExAdminTextContentAlias.tContent FROM tblExAdminTextContentAlias INNER JOIN tblExAdminTextContent ON tblExAdminTextContentAlias.iContentID = tblExAdminTextContent.iContentID WHERE iEventID = 100306 AND iLanguageID = 1 AND iLinkID IS NULL Stored Procedure: risp_ExAdminSiteLanguageDefaults 100306,1 The results were the duration were as following: Inline SQL: CPU: 16 Reads: 500 (fluctuates between 422-500) Writes: 0 Duration: 13ms Stored Procedure: CPU: 0 Reads: 422 (fluctuates between 422-500) Writes: 0 Duration: 0ms Now, this is by no means a solid call as it can fluctuate between them both taking 0 duration but never the SP taking any more than that and shows its more efficient. Obviously this is a test on a fairly simple proc but there is no way your DBA can say that it's a performance killer and to be honest with you if he is an MSCDBA then it's a shocking call to make. Client vars do perform updates internally using SP's for EVERY CALL if you do not switch that method off via the Client Vars section - maybe this is what your DBA was seeing? This does indeed cause 3 SP's to run for every .CFM thread; turn the updates off if you don't need last visit and hit count updated constantly. HTH Neil This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Includes, paths, templates, directory path problems...and a philosophical Question
I just was wondering how you all are managing this kind of development thing where you want to create includes and minimize coding, but have to make paths in those includes work properly, no matter where they are in your site... I wrote a UDF for similar tasks: http://www.cflib.org/udf.cfm?ID=841 Then I put this in Application.cfm: cfset appRoot=GetDirectoryFromPath(GetCurrentTemplatePath()) !--- Figure out relative path from the current template to the app's root --- cfset pathToRoot=relativeFilePath(GetTemplatePath(), appRoot) Hope it will help Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion built-in tags and permission-based security framework
Ian Vaughan wrote: How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? Ian, Are you saying that you have a separate category table for each department? Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion built-in tags and permission-based security framework
Yes, each department about 6 in total -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 10:25 To: CF-Talk Subject: Re: ColdFusion built-in tags and permission-based security framework Ian Vaughan wrote: How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? Ian, Are you saying that you have a separate category table for each department? Stephen ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Searching for Spock
Hi, I'm just about to embark on adding a search facility to my website. I have about 40 articles which are stored in a database with fields for the content (articleMain), metaDescription (which i use to pull for dynamically filling out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All these records are growing daily with more additions. I have my site hosted with HostMySite and they say i can use Verity searches. HOWEVER, is Verity just for searching for documents (pdf, word etc)? I would like to return to the user something like Google results, should i use just a simple SQL search? I am thinking that might be a bit heavy to keep on doing. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: breaking a line of code to two lines
Well, you could break on commas, and always trim(). I do break on commas. I didn't trim though. I thought that was just for spaces. There none. I'll try it. Ah, it must have been the wrap monster, then. Trim() removes all whitespace from the beginning and end of the string. That's it; it's working now. It seems odd to trim something that's not user entered, but here I am. If you are turning the list into an array, then using listappend() and appending each line to the list will require as many lines of code as the array declaration. I thought listAppend() would take another list of several entries and then I could do 5 appends for 5 lines each line with several entries, but it doesn't appear to work that way. thanks for the help. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion built-in tags and permission-based security framework
Stephen Moretti (cfmaster) wrote: Ian Vaughan wrote: How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? Ian, Are you saying that you have a separate category table for each department? Yes, each department about 6 in total Ok - you definately need to abstract the design of your database. At the minute, if you need to add a new department or remove a department you have to get your hands dirty, create a new table or remove a table from the database and make changes to the code to allow for this. What you need to do is have one category table, one user/member of staff table and a department table. The departments table maintains the complete list of departments along with a unique ID for each department. The same is true for the users and categories tables. You then need to relate these tables to one another, ie. have tables that tell you which users belong in which department and which departments have access to which categories. Take a look at the ER diagram I've run up for you here http://snipurl.com/bilm It fairly simplified, but hopefully it should help to make sense of what I'm describing above. With a database structure like this you can add and remove departments extremely easily, add new users to departments and change the categories available to any given department as well as allow multiple departments access to one category. How does this work? Your user logs in, so you get a unique identifier for them by querying the users table during the login process. SELECT UserID FROM Users WHERE UserName='#form.loginname#' AND Password = '#hash(form.loginpassword)#' With that UserID you can identify the department(s) that that user is a member of, by querying the link table between user and department. SELECT Department.DepartmentID, Department.DepartmentName FROM Department INNER JOIN DeptMembers AS DM ON Department.DepartmentID = DM.DepartmentID WHERE DM.UserID = #qryUser.UserID# If you want to know what categories they can access you can get this information by JOINing DepartmentMembers to Categories through DepartmentCategories. SELECT Categories.CategoryID, Categories.CategoryName FROM Categories INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID = DC.CategoryID INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID = DM.DeparmentID WHERE DM.UserID = #qryUser.UserID# This doesn't take in to account handling your tree of categories, but as you've more than likely got the code to manage this, it shouldn't be too hard to integrate what is here with what you've got for the category tree. BTW : You should have a look at John Celko's nested set model (http://snipurl.com/JoeCelko_NestedSets - you will need to register on the site, but its free and I've not had any spam from them) Hope this helps Regards Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Searching for Spock
You can use verity to search data bases quite easily by passing a query to it and indexing that (with the ID as they key) Check the documentation. MD On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I'm just about to embark on adding a search facility to my website. I have about 40 articles which are stored in a database with fields for the content (articleMain), metaDescription (which i use to pull for dynamically filling out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All these records are growing daily with more additions. I have my site hosted with HostMySite and they say i can use Verity searches. HOWEVER, is Verity just for searching for documents (pdf, word etc)? I would like to return to the user something like Google results, should i use just a simple SQL search? I am thinking that might be a bit heavy to keep on doing. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Searching for Spock
Thanks Mark, i'll give that a go, i'll look into the doco. I can't believe i have just ordered CF6.1 for my work and soon Blackstone will be here (but i got them to get the 2 years upgrade option! - but that doesn't mean the documentation!) Saturday -- Original Message -- From: Mark Drew [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Wed, 22 Dec 2004 13:21:34 +0100 You can use verity to search data bases quite easily by passing a query to it and indexing that (with the ID as they key) Check the documentation. MD On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I'm just about to embark on adding a search facility to my website. I have about 40 articles which are stored in a database with fields for the content (articleMain), metaDescription (which i use to pull for dynamically filling out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All these records are growing daily with more additions. I have my site hosted with HostMySite and they say i can use Verity searches. HOWEVER, is Verity just for searching for documents (pdf, word etc)? I would like to return to the user something like Google results, should i use just a simple SQL search? I am thinking that might be a bit heavy to keep on doing. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Searching for Spock
I am sure you can upgrade for a nominal fee when it comes out.. not sure at the moment.. On Wed, 22 Dec 2004 07:24:55 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks Mark, i'll give that a go, i'll look into the doco. I can't believe i have just ordered CF6.1 for my work and soon Blackstone will be here (but i got them to get the 2 years upgrade option! - but that doesn't mean the documentation!) Saturday -- Original Message -- From: Mark Drew [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Wed, 22 Dec 2004 13:21:34 +0100 You can use verity to search data bases quite easily by passing a query to it and indexing that (with the ID as they key) Check the documentation. MD On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I'm just about to embark on adding a search facility to my website. I have about 40 articles which are stored in a database with fields for the content (articleMain), metaDescription (which i use to pull for dynamically filling out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All these records are growing daily with more additions. I have my site hosted with HostMySite and they say i can use Verity searches. HOWEVER, is Verity just for searching for documents (pdf, word etc)? I would like to return to the user something like Google results, should i use just a simple SQL search? I am thinking that might be a bit heavy to keep on doing. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
test pls ignore
Sorry, I seem to be having trouble sending mail to the list pleaseignore this (you probably won't get it!) - rick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
regex question
(I posted this once, and it didn't bounce but I didn't see it come through to the list...) Question about regex (this never happens here, does it!) I want to match FOO:XXX where XXX could be any length of characters (but most likely a uuid) And I want to know the matched string when I'm done... Ie, some variable set to XXX, whatever XXX is. How do it do that? Ultimately, I'd like to pass the matched result to a function and do a replace... ie, something like this: REReplaceNoCase(CONTENT,FOO:.*?,getSnippet(XXX),ALL) - rIck ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
I remembered somebody'd already solved this particular problem before: http://www.redmelon.net/tstme/3cols2/ http://www.redmelon.net/tstme/3cols2/ Keith: That example conveniently sums up why I'm abandoning CSS positioning after a couple years of work in that area. CSS-P is so incredibly fragile that any unpredictable event can mangle it and render the page unusable. For example, I dropped a large photo into that layout, and instead of stretching the center column to accommodate it, Firefox let the image overlap the right column. IE fared even worse, effectively blowing up in my face... the content in the left and right columns jumped into the center column and joined the flow. But it gets worse. Just as a goof, I removed the image, leaving an empty p/p element to the center column. Firefox didn't even blink, but IE suddenly allowed the left column's content to leap into the center column and actually overlap it. A single empty paragraph was all it took to break the layout. If you're designing for controlled content, CSS-P can be effective. But if you're designing for content generated by mere mortals, it's a disaster waiting to happen in every browser I've ever seen. -- Roger Benningfield work: http://journurl.com/ blog: http://admin.support.journurl.com/ http://admin.support.journurl.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Temporary Cache
Here's a quick and dirty way to do this, and it should work without too much extra coding in CF, and relies on java garbage collection. Lets' say you have an instance of your object called SINGLEOBJ. Assuming originally you probably have cfset application.SINGLEOBJ=#someInstanceOfCFC# Then throughout your code you use various invocations of application.SINGLEOBJ's methods. Now we want to kill it off when no sessions are needing it. Here's what I'd do... (this is untested, uncompiled pseudocode to describe the idea). Make a java.lang.ref.WeakRerence and store that in global application scope, so it Doesn't count as something keeping the cfc around. Use Strong references in sessions, since they get cleaned up eventually. 1) instead of Application.SINGLEOBJ being the CFC do this kind of thing: !--- singleton instantiation and insertion to global scope --- Cfif not isdefined(application.SINGLEOBJ) or application.singeobj.get() IS NULL CFLOCK on application scope, exclusive. Cfinvoke YourComponent Construction here, name=MySingletonCFC cfobject type=Java action=Create name=weak class=java.lang.ref.WeakReference Cfset weak.init(MySingletonCFC) Cfset Application.SINGLEOBJ=weak /CFLOCK /cfif 2) For each session needing this object, at login time, or session creation time, retreive it and store a (Strong) Reference in the session. Cfset session.SINGLEOBJREF=application.singleobj.get() Now you have a copy of this in each session. When there are sessions, the CFC will stick around, since the garbage collector sees references to it. When the sessions get cleaned up, the only reference to the CFC is a java WeakReference, which isn't cause for keeping it around, so the garbage collector can mark it, queue it, and clean it up automatically. You know when this happens when the weakreference (a variable you store in the application) Returns null for get()... Make sense? -dov If the idea works correctly (attack it if you disagree) your CFC will get disposed of during regular natural garbage collection -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 8:40 PM To: CF-Talk Subject: Temporary Cache Hi, I need to cache a singleton type of component in the application scope so that multiple sessions can make use of it. However the component would be used rarely, and may take up significant resources, so I'd like to remove it whenever it's not in use (ie when the last session thats using it is destroyed). ie, The seuqence of events would be something like this: Two users come along, the user1 does something that uses my singleton component, so I create it, and cache it in application scope. User2 also starts using it while user1 is also using it. User1 closes their browser, but user2 continues using the compionent for a while. Then user2 closes their browser, so noone is now using the component, so remove it from the application scope. I could write some Java classes to do this, but I'm guessing someone else has needed this before, so has it been written already? Chris -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex question
It all depends what you want to do with the XXX. If you want to use it
as is, you can use backreferencing:
REReplaceNoCase(CONTENT,FOO:(.*?),'a
href=lookup.cfm?word=\1\1/a',ALL)
Where \1 will match XXX.
If you need to transform it, you will need a loop:
cfscript
start = 1;
while(true){
stTmp = REFindNoCase(FOO:(.*?),content,start,true);
if(stTmp.pos[1] IS 0) break;
value = Mid(content,stTmp.pos[2],stTmp.len[2]);
content = RemoveChars(content,stTmp.pos[1],stTmp.len[1]);
newvalue = getSnippet(value);
content = Insert(newvalue,content,stTmp.pos[1] - 1);
start = stTmp.pos[1] + Len(newvalue);
}
/cfscript
I just wrote this code without testing, so it may need some tweaking.
Pascal
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 22 December 2004 13:52
To: CF-Talk
Subject: regex question
(I posted this once, and it didn't bounce but I didn't see it come
through to the list...)
Question about regex (this never happens here, does it!)
I want to match FOO:XXX
where XXX could be any length of characters (but most likely a uuid)
And I want to know the matched string when I'm done...
Ie, some variable set to XXX, whatever XXX is.
How do it do that?
Ultimately, I'd like to pass the matched result to a function and do a
replace... ie, something like this:
REReplaceNoCase(CONTENT,FOO:.*?,getSnippet(XXX),ALL)
- rIck
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188522
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity 'caching' old docs
Our indexing routine runs every night. It performs a purge first then performs the indexing the then the last thing is to optimize. It has been running this way for a couple of months now and seems to be effective. Just my $0.02. Doug James Webmaster / IT Developer MUSC - Hollings Cancer Center http://hcc.musc.edu Duncan I Loxton wrote: Hi all, I have a verity collection of company policies that are divided up into folders. IE - is a folder and any policies that start with 0 would be placed into that folder - 1000 folder would contain any policies that began with 1 etc My problem is - I delete a policy from lets say folder 4000 then re-index this Policy folder - which contains all the subfolders of , 1000 etc (I have subdirectories selected). I go to our web site and do a search for the specific policy number - 4526.1E1 and no files are found. GREAT - well then I try doing a search for 4526.1 and poof its still there and showing up as page can't be displayed. (That would be because its not there.) What am I doing wrong in my indexing? I though maybe it was just cached - but I cleared that and even checked on a couple other systems - same thing. Thanks Duncan ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Includes, paths, templates, directory path problems...and a philosophical Question
Fusebox. There's a lot of reasons to use Fusebox, but in this specific case, having everything go through a single index.cfm will solve your problem directly. Mach-II has the same characteristic. Your app is entirely behind that single template, so you never run into any relative pathing issues. Very nice little side benefit to the way the framework is set up. cheers, barneyb On Tue, 21 Dec 2004 12:16:10 -0500, Jeff Small [EMAIL PROTECTED] wrote: You've got a site. You've got content in the root. (index.cfm, let's say) and you've got content in directories lower than the root (foo/content.cfm). Let's say that you want index.cfm and foo/content.cfm to share the same navigation as an include, naturally, because you only want to change one copy of include/navigation.cfm and it will be updated in every page of the site. But how do you resolve directory path problems? In index.cfm, the navigation include (this code is in include/navigation.cfm remember) refers to images/image.jpg which works in the root index.cfm file...however, when you refer to this include in foo/content.cfm it needs to instead refer to ../images/image.jpg. How to resolve this? How do you work on this locally, with includes, and set it up to mirror your development site, so all you need to do is push it over and it's live and working? Our development server is just a smallish, in-house box that we use like this, testing.mydomain.com/client1/ and testing.mydomain.com/another_client/ and we're using relative paths in development. It wasn't such a big problem until recently when we've just sort of grown out of a mom and pop solution to development and have begun to try and implement firmer coding methods and procedures. So we're stumbling trying to figure out a solution besides make a second copy of navigation.cfm so that the paths work when it's one directory lower etc... We're trying to figure out if Dreamweaver Templates can figure into the mix somehow, giving us locked regions that can change depending on where you save the file, then just edit the template to apply global changes to a navigation, etc...but that doesn't *seem* to be working out very well...Although one of the guys in the office just shouted that he thinks Nesting templates might work... I just was wondering how you all are managing this kind of development thing where you want to create includes and minimize coding, but have to make paths in those includes work properly, no matter where they are in your site... Does this make sense what I'm asking? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ Got Gmail? I have 10 invites. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Seeing double?
I have a dev machine (www.4simchas.com) which has quad 2.4 ghz processors, running the latest 6.1 release I have an app (replica of my prod env) which is running there, and most of my layout elements consist of custom tags (CF_page argscontent/cf_page) What I'm finding is that the headers and footers respectively are appearing twice... this seems to happen only with content being brought into pages via CFMODULE. Any advice (check it out, it's very wierd). -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Seeing double?
If you've closed the tag or used a / at the end, it will get called twice. You need to checkout the value of thisTag.executionMode, read more here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote: I have a dev machine (www.4simchas.com) which has quad 2.4 ghz processors, running the latest 6.1 release I have an app (replica of my prod env) which is running there, and most of my layout elements consist of custom tags (CF_page argscontent/cf_page) What I'm finding is that the headers and footers respectively are appearing twice... this seems to happen only with content being brought into pages via CFMODULE. Any advice (check it out, it's very wierd). -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setup datasource thru code?
Robertson-Ravo, Neil (RX) wrote: Yeah, there is a factory method you can use : http://www.petefreitag.com/item/152.cfm I don't see how or why this isn't supported as isn't this what CF is using to create DSN's itself? Because it provides way to much rope to hang yourself. Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Seeing double?
Right. This much I know... The code switches on executionmode which is why it makes a good single cfmodule call for start-end use. It works perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it looks strange. I'm wondering if it has to do with race conditions, and compiling on 4 processors, etc... The code has worked for 2 years flawlessly on the previous server. Thanks in advance for any further insight. -dov -Original Message- From: Anthony Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 8:48 AM To: CF-Talk Subject: Re: Seeing double? If you've closed the tag or used a / at the end, it will get called twice. You need to checkout the value of thisTag.executionMode, read more here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote: I have a dev machine (www.4simchas.com) which has quad 2.4 ghz processors, running the latest 6.1 release I have an app (replica of my prod env) which is running there, and most of my layout elements consist of custom tags (CF_page argscontent/cf_page) What I'm finding is that the headers and footers respectively are appearing twice... this seems to happen only with content being brought into pages via CFMODULE. Any advice (check it out, it's very wierd). -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion built-in tags and permission-based security framework
Thanks -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 11:57 To: CF-Talk Subject: Re: ColdFusion built-in tags and permission-based security framework Stephen Moretti (cfmaster) wrote: Ian Vaughan wrote: How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? Ian, Are you saying that you have a separate category table for each department? Yes, each department about 6 in total Ok - you definately need to abstract the design of your database. At the minute, if you need to add a new department or remove a department you have to get your hands dirty, create a new table or remove a table from the database and make changes to the code to allow for this. What you need to do is have one category table, one user/member of staff table and a department table. The departments table maintains the complete list of departments along with a unique ID for each department. The same is true for the users and categories tables. You then need to relate these tables to one another, ie. have tables that tell you which users belong in which department and which departments have access to which categories. Take a look at the ER diagram I've run up for you here http://snipurl.com/bilm It fairly simplified, but hopefully it should help to make sense of what I'm describing above. With a database structure like this you can add and remove departments extremely easily, add new users to departments and change the categories available to any given department as well as allow multiple departments access to one category. How does this work? Your user logs in, so you get a unique identifier for them by querying the users table during the login process. SELECT UserID FROM Users WHERE UserName='#form.loginname#' AND Password = '#hash(form.loginpassword)#' With that UserID you can identify the department(s) that that user is a member of, by querying the link table between user and department. SELECT Department.DepartmentID, Department.DepartmentName FROM Department INNER JOIN DeptMembers AS DM ON Department.DepartmentID = DM.DepartmentID WHERE DM.UserID = #qryUser.UserID# If you want to know what categories they can access you can get this information by JOINing DepartmentMembers to Categories through DepartmentCategories. SELECT Categories.CategoryID, Categories.CategoryName FROM Categories INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID = DC.CategoryID INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID = DM.DeparmentID WHERE DM.UserID = #qryUser.UserID# This doesn't take in to account handling your tree of categories, but as you've more than likely got the code to manage this, it shouldn't be too hard to integrate what is here with what you've got for the category tree. BTW : You should have a look at John Celko's nested set model (http://snipurl.com/JoeCelko_NestedSets - you will need to register on the site, but its free and I've not had any spam from them) Hope this helps Regards Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Strange cfmail error
Hello, I just happened to look at my mail.log file in the CF Admin and there are a lot (5-6 every minute) of this error: Error,scheduler-1,12/22/04,05:23:35,,550 Body From: of '@107' is banned Anyone seen this before, or have an idea of what it might be? Our domain is 1079thelink.com, which is where the @107 could come from, but why is it banned, who's banning it and why it it in the log so much? Thanks, Jonathan _ Jonathan Mauney Web Application Developer/Manager, Digital Media Properties News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 704.374.3862 voice 704.374.3543 fax ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Includes, paths, templates, directory path problems...and a philosophical Question
Or you could also simply use the base href tag (base href=www.yourdomain.com) and then have all your images/style sheets/javascript references do something like this: img src=/images/image.jpg / And it will automatically resolves. G On Wed, 22 Dec 2004 05:38:44 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: Fusebox. There's a lot of reasons to use Fusebox, but in this specific case, having everything go through a single index.cfm will solve your problem directly. Mach-II has the same characteristic. Your app is entirely behind that single template, so you never run into any relative pathing issues. Very nice little side benefit to the way the framework is set up. cheers, barneyb On Tue, 21 Dec 2004 12:16:10 -0500, Jeff Small [EMAIL PROTECTED] wrote: You've got a site. You've got content in the root. (index.cfm, let's say) and you've got content in directories lower than the root (foo/content.cfm). Let's say that you want index.cfm and foo/content.cfm to share the same navigation as an include, naturally, because you only want to change one copy of include/navigation.cfm and it will be updated in every page of the site. But how do you resolve directory path problems? In index.cfm, the navigation include (this code is in include/navigation.cfm remember) refers to images/image.jpg which works in the root index.cfm file...however, when you refer to this include in foo/content.cfm it needs to instead refer to ../images/image.jpg. How to resolve this? How do you work on this locally, with includes, and set it up to mirror your development site, so all you need to do is push it over and it's live and working? Our development server is just a smallish, in-house box that we use like this, testing.mydomain.com/client1/ and testing.mydomain.com/another_client/ and we're using relative paths in development. It wasn't such a big problem until recently when we've just sort of grown out of a mom and pop solution to development and have begun to try and implement firmer coding methods and procedures. So we're stumbling trying to figure out a solution besides make a second copy of navigation.cfm so that the paths work when it's one directory lower etc... We're trying to figure out if Dreamweaver Templates can figure into the mix somehow, giving us locked regions that can change depending on where you save the file, then just edit the template to apply global changes to a navigation, etc...but that doesn't *seem* to be working out very well...Although one of the guys in the office just shouted that he thinks Nesting templates might work... I just was wondering how you all are managing this kind of development thing where you want to create includes and minimize coding, but have to make paths in those includes work properly, no matter where they are in your site... Does this make sense what I'm asking? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ Got Gmail? I have 10 invites. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188531 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Strange cfmail error
It looks like the mail server that you are using is banning that domain. I know for sure that some systems incorrectly reject mail from domains that begin with a number. At any rate, you should check with the email administrator. They may just be able to add the IP address of your ColdFusion server to a whitelist. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm --- On Wednesday, December 22, 2004 9:01 AM, [EMAIL PROTECTED] scribed: --- Hello, I just happened to look at my mail.log file in the CF Admin and there are a lot (5-6 every minute) of this error: Error,scheduler-1,12/22/04,05:23:35,,550 Body From: of '@107' is banned Anyone seen this before, or have an idea of what it might be? Our domain is 1079thelink.com, which is where the @107 could come from, but why is it banned, who's banning it and why it it in the log so much? Thanks, Jonathan _ Jonathan Mauney Web Application Developer/Manager, Digital Media Properties News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 704.374.3862 voice 704.374.3543 fax ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Advancement in programming efficiency previews today
You guys might need a little individual time to yourselves. Dan On Tue, 21 Dec 2004 15:30:23 -0500, Adam Churvis [EMAIL PROTECTED] wrote: If you guys think Plum was cool, wait until you see what we've come up with *this* time. This will without a doubt be the single biggest boost to programming efficiency in the history of computer technology: http://www.productivityenhancement.com/news.cfm?id=uxp Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Advancement in programming efficiency previews today
You can call it... COBOL - Original Message - From: Adam Churvis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 21, 2004 3:30 PM Subject: Advancement in programming efficiency previews today If you guys think Plum was cool, wait until you see what we've come up with *this* time. This will without a doubt be the single biggest boost to programming efficiency in the history of computer technology: http://www.productivityenhancement.com/news.cfm?id=uxp Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd CF/network problem
Have you checked that Jumbo Frames are disabled for the NIC? This can cause problems when an intermediate switch can handle the larger frames, though you won't see a problem on an xover connection. HTH -Ryan On Tue, 21 Dec 2004 15:24:18 -0500, Matthew Fusfield [EMAIL PROTECTED] wrote: I've just run into a rather strange network issue with CFMX and am hoping someone here might have an idea. We are preparing to deploy an application on two web/CF servers and a separate MS SQL box. Each machine has two NICs. Until now, on the two CF servers, we've used one NIC to connect out to the network and the second NIC was connected via crossover cable to the other web server. (there is a decent amount of web services and other traffic between the two to warrant this) This has worked well, until today when we installed a pretty basic network switch, replacing the crossover cable, to allow the database server to connect to this private network. Both CF servers can see and use the SQL box, and can ping each other. However, when I try to send HTTP traffic from web server 1 to web server 2, I get the HTTP headers and nothing else - it simply times out. Even stranger is that this only seems to apply to ColdFusion pages - if I request a static html file from one server, it transfers just fine. I replaced the switch with the crossover cable, and everything started working again. I tried restarting services, reinstalling connectors, etc, etc to no avail. Anyone run into anything like this before? Thanks, Matt ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Advancement in programming efficiency previews today
father / son? you two look like brothers... how old is the dad here? david or adam? which is which? tw On Wed, 22 Dec 2004 09:48:23 -0500, Dave Francis [EMAIL PROTECTED] wrote: You can call it... COBOL - Original Message - From: Adam Churvis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 21, 2004 3:30 PM Subject: Advancement in programming efficiency previews today If you guys think Plum was cool, wait until you see what we've come up with *this* time. This will without a doubt be the single biggest boost to programming efficiency in the history of computer technology: http://www.productivityenhancement.com/news.cfm?id=uxp Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Searching for Spock
If you're saying that you don't have documentation, remember that ALL current MM documentation (with user comments) is available at livedocs.macromedia.com. Insanely useful. Jim Davis -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 7:25 AM To: CF-Talk Subject: Re: Searching for Spock Thanks Mark, i'll give that a go, i'll look into the doco. I can't believe i have just ordered CF6.1 for my work and soon Blackstone will be here (but i got them to get the 2 years upgrade option! - but that doesn't mean the documentation!) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188536 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
I read that, and I know that issue, but I can't fathom myself where you'd take the extra height from if this rule wasn't there: the parent's parent, and if so, how much would you take, and what would the extra height be calculated relative to. The easiest answer to that question is another question: where does the space come from in HTML? As I understand it, the browser traverses up the tree until it finds an element whose height it knows. As a result, it's more complicated to render HTML than CSS. It's my understanding that this is the reason why the spec doesn't allow for it: to keep rendering simple. At a fundamental level, I think the folks who made the CSS spec made a bad decision: I think you should make things easier on the people who use a computer. The computer is there to serve the people after all. On a practical level, the time it takes to render even a complex layout of nested tables is trivial (well, it is in anything other than Netscape 4). Even if this wasn't the case, Moore's law would have long since made it so. Went up to my retreat deep in the Ox Mountains and meditated on a solution. Then, just as it came to me in a flash of blinding light, I remembered somebody'd already solved this particular problem before: http://www.redmelon.net/tstme/3cols2/ That's a great example. That's far better than any I found (I must of looked at 50 different examples before sending my last message). Nevertheless, it still suffers from some of the issues we've been talking about. Specifically, the widths of the left and right columns are specified in several locations. They are specified as the border for the outer class (similar to how margin was used in the example I posted). They are also specified in negative margin values for the left and right columns themselves. The latter doesn't bother me so much because the left column already needs to know its size. So, specifying the size as a width and negative margin value isn't too bad. However, having to make other elements cognoscente of the column's size is a more serious violation of the principle of orthogonality. Nevertheless, it goes a long way towards mitigating those issues. There are also a few extra divs and classes in there (most notably the separation between inner and outer). That's not a big deal since the tr's and td's in the table example even that out. The style sheet code makes their example at least 3 times as long as the one I posted (I actually rewrote their example with as little code as possible before posting just so I would better understand it), but it goes a long way towards separating presentation from content. All in all, that's a pretty good example. I still think CSS is screwy in this regard, but at least there are workarounds. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188538 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Advancement in programming efficiency previews today
father / son? you two look like brothers... how old is the dad here? david or adam? which is which? You just made my day! :) I'm father -- the one with the white shirt -- and I'm 43. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188539 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Searching for Spock
Thanks Jim. Actually, it just arrived an hour ago in a tattered box from Bytes. So i have loads of blue books now. :) I've often come across the livedocs on Google. I've worked out the Verity search thingy now and it's pretty good. Saturday -- Original Message -- From: Jim Davis [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Wed, 22 Dec 2004 10:24:56 -0500 If you're saying that you don't have documentation, remember that ALL current MM documentation (with user comments) is available at livedocs.macromedia.com. Insanely useful. Jim Davis -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 7:25 AM To: CF-Talk Subject: Re: Searching for Spock Thanks Mark, i'll give that a go, i'll look into the doco. I can't believe i have just ordered CF6.1 for my work and soon Blackstone will be here (but i got them to get the 2 years upgrade option! - but that doesn't mean the documentation!) ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
IsDefined with dynamic variable
Cfif IsDefined('form[Desc_ID#x#]')
This is giving me the following error
Parameter 1 of function IsDefined, which is now quot;form[Desc_ID1]quot;,
must be a syntactically valid variable name.
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188541
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsDefined with dynamic variable
try
cfif structkeyexists( form, 'desc_id' x )
On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur [EMAIL PROTECTED] wrote:
Cfif IsDefined('form[Desc_ID#x#]')
This is giving me the following error
Parameter 1 of function IsDefined, which is now quot;form[Desc_ID1]quot;,
must be a syntactically valid variable name.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188542
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsDefined with dynamic variable
Change it to one of these two things:
cfif structKeyExists(form,desc_id#x#)
or
cfif isDefined(form.desc_id#x#)
On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur [EMAIL PROTECTED] wrote:
Cfif IsDefined('form[Desc_ID#x#]')
This is giving me the following error
Parameter 1 of function IsDefined, which is now quot;form[Desc_ID1]quot;,
must be a syntactically valid variable name.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188543
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Okay, stupid question time...
cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Okay, stupid question time...
Hey Jeff, It'll work like any query created in your page with CFQuery...ie, if getNews() returns a query... cfset qNews = myObject.getNews() cfoutput query=qNews !--- Do Stuff -- /cfoutput -joe On Wed, 22 Dec 2004 11:18:26 -0500, Jeff Small [EMAIL PROTECTED] wrote: cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Okay, stupid question time...
cfset qNews = myObject.getNews() cfoutput query=qNews... -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 17:18 To: CF-Talk Subject: Okay, stupid question time... cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Okay, stupid question time...
Jeff Small wrote: cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput cfset news = myObject.getNews() cfoutput query=news#headlinebr //cfoutput -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Okay, stupid question time...
From: Pascal Peters [EMAIL PROTECTED] cfset qNews = myObject.getNews() cfoutput query=qNews... Ha...as soon as I posted this, I realized what I had left out...man, it's WAY too close to the holidays... You should've seen me cussing and grumbling at my desk... Thanks Joe and Pascal... ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Total Sales Menu
The following code is from a menu on a site that shows the monthly/quarterly/yearly goal and sales the goal part is working fine but since switching from access to mysql the currently month/quarter/year sales isn't being calulated. !--- RIGHT MENU --- td table class=rightMenu tr td class=rightMenu style=text-align: left;brbr cfset theMonth = datePart(m, now()) cfset theYear = datePart(, now()) cfset theDay = datePart(d, now()) cfquery name=getMonthlyPurchase datasource=#DS# cachedwithin=#CreateTimeSpan(0,4,35,0)# SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate = '#theMonth#/#1#/#theYear#' /cfquery cfset theGoal = 175000 cfif getMonthlyPurchase.recordCount neq 0 and getMonthlyPurchase.recordCount neq and getMonthlyPurchase.totalMonthlyPurchase neq cfset amountLeft = theGoal - getMonthlyPurchase.totalMonthlyPurchase cfelse cfset amountLeft = theGoal /cfif ptable width=100%trtd bgcolor=#CC style=font-size: 18px; font-weight: bold; text-align: center; padding: 2 3 2 3; border-right: black 1px solid; border-bottom:black 1px solid;GOALS/td/tr/table table style=width:100%; trtd style=border: dashed gray 1px; padding: 2 3 2 3; font-size: 12px; width:100%; strongTHIS MONTH:/strong table bgcolor=#B9E1F4 width=100% tr td style=width:100%; span class=voTitleGOAL:cfoutput#DollarFormat(theGoal)#/cfoutput./spanspan style=font-size: 2px;brbr/span span style=font-size: 10px; font-weight: bold;strongSO FAR:cfoutput#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)#/cfoutput/strong/spanspan style=font-size: 2px;brbr/span span class=adminTitleTO GO:cfoutput#DollarFormat(amountLeft)#/cfoutput/span /td /tr /table /td /tr tr td style=font-size: 2px;nbsp;/td /tr /table cfset theMonth = datePart(m, now()) cfset theYear = datePart(, now()) cfswitch expression=#theMonth# cfcase value=1,2,3 cfset startMonth = 1 cfset endMonth = 3 cfset endDay = 31 /cfcase cfcase value=4,5,6 cfset startMonth = 4 cfset endMonth = 6 cfset endDay = 30
OT: Best CF Blog 2004
Which CF blog provides the best content in your opinion? I have a thread over at http://www.webdevref.com/blog/ for voting purposes. Nothing too scientific but I wanted to see if there are any essential CF blogs I should be reading. I'm looking for unique content vs the prolific linker. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFStoredProc bug?
Robertson-Ravo, Neil (RX) wrote: Based on the comments - I ran a quick test with an SP which basically ran the following (where iLanguageID and iEventID were @ variables passed in via dbvarname): How did you call the procedure, with cfquery or with cfstoredproc? Did you use cfqueryparam's? That's actually what this part of the thread is about. I suggest you try ALL the possibilities. Now, this is by no means a solid call as it can fluctuate between them both taking 0 duration but never the SP taking any more than that and shows its more efficient. That's not the point at all. We all know stored procedures are faster than plain vanilla sql statements. That's not in question, it's common sense. Client vars do perform updates internally using SP's for EVERY CALL if you do not switch that method off via the Client Vars section - maybe this is what your DBA was seeing? This does indeed cause 3 SP's to run for every .CFM thread; turn the updates off if you don't need last visit and hit count updated constantly. Yes, I know that, problem is the app was relying on these variables. After disabling these updates, there was still overhead and inefficency on the DB storage for client vars. Run SQL Profiler on your database and you'll see it compiling and removing procedures all the time, not very good practice. -nathan strutz http://www.dopefly.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
search for a string across columns
I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1=I need to line_2=go to the bathroom and I searched need to go, it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' /cfquery thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Okay, stupid question time...
Try CFSET qryNews=myObject.getNews() / cfoutput query=qryNewsaryNews.headline/cfoutput -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:18 AM To: CF-Talk Subject: Okay, stupid question time... cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search for a string across columns
I would do a sub-query where you union the same query on each column, and then query that. |I have a db that contains 6 similar columns: line_1, line_2 , |line_3 , line_4 , line_5 , line_6 I want to have a search that |searches across columns. While I can search them |individually, it would be better if they were combined before |the LIKE was done so that if I had: |line_1=I need to |line_2=go to the bathroom |and I searched need to go, it would return a hit. | |I'm not sure how to approach this but while I have a |beginning, I know that it is incorrect because it's the first |type of search, searching each line individually. | |cfquery name=getSearchItem datasource=dpch | SELECT |recipients_lname,recipients_fname,recipients_mi,leaf_number | FROM giving_leaves | WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' |/cfquery | |thanks for the help. | |-- |Daniel Kessler | |Department of Public and Community Health University of |Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 |301-405-2545 Phone |www.phi.umd.edu | | ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
1st, 2nd, 3rd, 4th
Does anyone have a function that takes numbers and converts them to 1st, 2nd, 3rd, ... 15th, .. 21st, etc? - Rick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 1st, 2nd, 3rd, 4th
I can't vouch for it, but this seems to be what you need. http://www.cflib.org/udf.cfm?ID=805 -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:36 AM To: CF-Talk Subject: 1st, 2nd, 3rd, 4th Does anyone have a function that takes numbers and converts them to 1st, 2nd, 3rd, ... 15th, .. 21st, etc? - Rick ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 1st, 2nd, 3rd, 4th
Does anyone have a function that takes numbers and converts them to 1st, 2nd, 3rd, ... 15th, .. 21st, etc? http://www.cflib.org/udf.cfm?ID=349 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 1st, 2nd, 3rd, 4th
This reminds me of one of my favorite programming glitches. http://www.google.com/search?q=11st http://www.google.com/search?q=12nd http://www.google.com/search?q=13rd Seriously, though, I made a little number namer a while ago, and it's all tags and not cfscript, but here it is for ya. !--- 3/4/2003, ns returns numbers followed by a discriptive string. 1st, 2nd, 3rd, 245th --- cffunction name=NumberName output=no returntype=string cfargument name=num required=Yes type=numeric cfset var returnName = cfswitch expression=#Right(NumberFormat(arguments.num,09),2)# cfcase value=11,12,13 cfset returnName = th /cfcase cfdefaultcase cfswitch expression=#Right(arguments.num,1)# cfcase value=1 cfset returnName = st /cfcase cfcase value=2 cfset returnName = nd /cfcase cfcase value=3 cfset returnName = rd /cfcase cfcase value=4,5,6,7,8,9,0 cfset returnName = th /cfcase /cfswitch /cfdefaultcase /cfswitch cfreturn num returnName /cffunction Rick Root wrote: Does anyone have a function that takes numbers and converts them to 1st, 2nd, 3rd, ... 15th, .. 21st, etc? - Rick ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search for a string across columns
Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' /cfquery You would just have to worry about the spaces because in your example line_1 and line_2 would concat to I need togo to the bathroom, so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1=I need to line_2=go to the bathroom and I searched need to go, it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' /cfquery thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search for a string across columns
ok, great. I understand conceptually. I've not done it beore but I'll give it a college try :-) thanks for the guidance. I would do a sub-query where you union the same query on each column, and then query that. |I have a db that contains 6 similar columns: line_1, line_2 , |line_3 , line_4 , line_5 , line_6 I want to have a search that |searches across columns. While I can search them |individually, it would be better if they were combined before |the LIKE was done so that if I had: |line_1=I need to |line_2=go to the bathroom |and I searched need to go, it would return a hit. | |I'm not sure how to approach this but while I have a |beginning, I know that it is incorrect because it's the first |type of search, searching each line individually. | |cfquery name=getSearchItem datasource=dpch | SELECT |recipients_lname,recipients_fname,recipients_mi,leaf_number | FROM giving_leaves | WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' |/cfquery | |thanks for the help. | |-- |Daniel Kessler | |Department of Public and Community Health University of |Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 |301-405-2545 Phone |www.phi.umd.edu | | ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search for a string across columns
Concatobate = Concatenate And don't for get your wildcards on the like '%#search#%' Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Patrick McGeehan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:11 PM To: CF-Talk Subject: RE: search for a string across columns Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' /cfquery You would just have to worry about the spaces because in your example line_1 and line_2 would concat to I need togo to the bathroom, so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1=I need to line_2=go to the bathroom and I searched need to go, it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' /cfquery thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Total Sales Menu
try creating date objects first using cfset yourdate = createdate(year,month,day) then supply dates to your queries using cfqueryparam cfsqltype=CF_SQL_DATE value=#createODBCdate(your_date)# This should make the sql db independant (probably!) HTH On Wed, 22 Dec 2004 09:41:54 -0700, Jason Smith [EMAIL PROTECTED] wrote: The following code is from a menu on a site that shows the monthly/quarterly/yearly goal and sales the goal part is working fine but since switching from access to mysql the currently month/quarter/year sales isn't being calulated. !--- RIGHT MENU --- td table class=rightMenu tr td class=rightMenu style=text-align: left;brbr cfset theMonth = datePart(m, now()) cfset theYear = datePart(, now()) cfset theDay = datePart(d, now()) cfquery name=getMonthlyPurchase datasource=#DS# cachedwithin=#CreateTimeSpan(0,4,35,0)# SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate = '#theMonth#/#1#/#theYear#' /cfquery cfset theGoal = 175000 cfif getMonthlyPurchase.recordCount neq 0 and getMonthlyPurchase.recordCount neq and getMonthlyPurchase.totalMonthlyPurchase neq cfset amountLeft = theGoal - getMonthlyPurchase.totalMonthlyPurchase cfelse cfset amountLeft = theGoal /cfif ptable width=100%trtd bgcolor=#CC style=font-size: 18px; font-weight: bold; text-align: center; padding: 2 3 2 3; border-right: black 1px solid; border-bottom:black 1px solid;GOALS/td/tr/table table style=width:100%; trtd style=border: dashed gray 1px; padding: 2 3 2 3; font-size: 12px; width:100%; strongTHIS MONTH:/strong table bgcolor=#B9E1F4 width=100% tr td style=width:100%; span class=voTitleGOAL:cfoutput#DollarFormat(theGoal)#/cfoutput./spanspan style=font-size: 2px;brbr/span span style=font-size: 10px; font-weight: bold;strongSO FAR:cfoutput#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)#/cfoutput/strong/spanspan style=font-size: 2px;brbr/span span class=adminTitleTO GO:cfoutput#DollarFormat(amountLeft)#/cfoutput/span /td /tr /table /td /tr tr td style=font-size: 2px;nbsp;/td /tr /table cfset theMonth = datePart(m, now()) cfset theYear = datePart(, now()) cfswitch expression=#theMonth# cfcase value=1,2,3 cfset startMonth = 1 cfset endMonth = 3 cfset endDay = 31 /cfcase cfcase value=4,5,6 cfset startMonth = 4
OT: SQL Server Disaster Recovery
For those who work as a DBA or has to manage a SQL Server, sql-server-performance has a great link to an article from Brian Knight that discusses Disaster recovery and is A Survival Toolkit for the DBA. It even comes with a bunch of scripts already written. Here is the link to the article http://www.lumigent.com/go/sd19/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Seeing double?
On Wed, 22 Dec 2004 08:53:47 -0500, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: Right. This much I know... The code switches on executionmode which is why it makes a good single cfmodule call for start-end use. It works perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it looks strange. First off, looks like you have different versions of CFMX 6.1 on each server yes? That hotfix dates from December 2003. I'm guessing the 83762 build number is the 6.1 Updater. It's possible that your code is relying on a bug that got fixed by the updater... Second, you are outputting a base tag *before* the page content which means the DOCTYPE will not be read correctly by browsers (and your page will not validate). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 4 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: breaking a line of code to two lines
You could try: cfset fund_ar = listToArray( The Dean's Fund, Health and Society, Visiting Professorship, Jerry Wrenn Scholarship, Kinesiology Gift Fund, ,) / -- Carlos Balacuit Macromedia Certified ColdFusion MX Advanced Developer ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Seeing double?
The base is an artifact of the CF_FormURL2Attributes tag, which runs before any content is output. It's harmless, but yes, it does break some standards. That being said, no browser I've ever seen failed to load a page with that base tag there My code is straight out cfmodule'd ... CF_Page /CF_Page The only other change is that I have j2ee sessions enabled on the bad machine -- 6,1,..83762 -Dov -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:28 PM To: CF-Talk Subject: Re: Seeing double? On Wed, 22 Dec 2004 08:53:47 -0500, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: Right. This much I know... The code switches on executionmode which is why it makes a good single cfmodule call for start-end use. It works perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it looks strange. First off, looks like you have different versions of CFMX 6.1 on each server yes? That hotfix dates from December 2003. I'm guessing the 83762 build number is the 6.1 Updater. It's possible that your code is relying on a bug that got fixed by the updater... Second, you are outputting a base tag *before* the page content which means the DOCTYPE will not be read correctly by browsers (and your page will not validate). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 4 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188566 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fusebox 3 Layouts
Hi there as you might now I am trying to make a plugin for fusebox 3. what I was wondering was how do people make their fbx_Layouts.cfm file? The reson I ask is that I have seen the demo and default but I wanted to implement best practice. Personally I do something like: cfparam name=defaultLayout default=homepage cfset fusebox.layoutDir = layouts\ cfswitch expression=#defaultLayout# cfcase value=homepage cfset fusebox.layoutFile = homepage_layout.cfm /cfcase cfcase value=content cfset fusebox.layoutFile = content_layout.cfm /cfcase cfcase value=login cfset fusebox.layoutFile = login_layout.cfm /cfcase cfcase value=blank cfset fusebox.layoutFile = lay_blank.cfm /cfcase cfdefaultcase cfset fusebox.layoutFile = blank_layout.cfm /cfdefaultcase /cfswitch -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188567 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox 3 Layouts
I suspect you'll find that not many people are developing with Fusebox 3 any more. There are definitely a lot of sites out there that are running it and will probably never be upgraded (I have several, along with some FB2 ones as well), but my impressions is that most Fuseboxers are pretty much using Fusebox 4 for new development. That being said, i do something quite similar to that for my fbx_Layouts file. I don't use a subdirectory, use a lay prefix for my fuse names, and hold the layout selection variable in the request scope rather than variables, but the idea is identical. I also use a second variable 'attributes.suppressLayouts' which, if set to true', will cause layouts to be skipped. cheers, barneyb On Wed, 22 Dec 2004 19:53:30 +0100, Mark Drew [EMAIL PROTECTED] wrote: Hi there as you might now I am trying to make a plugin for fusebox 3. what I was wondering was how do people make their fbx_Layouts.cfm file? The reson I ask is that I have seen the demo and default but I wanted to implement best practice. Personally I do something like: cfparam name=defaultLayout default=homepage cfset fusebox.layoutDir = layouts\ cfswitch expression=#defaultLayout# cfcase value=homepage cfset fusebox.layoutFile = homepage_layout.cfm /cfcase cfcase value=content cfset fusebox.layoutFile = content_layout.cfm /cfcase cfcase value=login cfset fusebox.layoutFile = login_layout.cfm /cfcase cfcase value=blank cfset fusebox.layoutFile = lay_blank.cfm /cfcase cfdefaultcase cfset fusebox.layoutFile = blank_layout.cfm /cfdefaultcase /cfswitch -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ \ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ Got Gmail? I have 10 invites. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188568 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: forms as arrays
nothing wrong with it, but does it gain you anything? What if you want to add a length or onclick attributes to some but not all fields? If you want to shorten the code you could do your form the standard way but drop it in a separate file and cfinclude it. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188569 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox 3 Layouts
That will be my next plugin after this one if no one else is developing it but I have a vested interest as my sites are fb3 :D On Wed, 22 Dec 2004 11:01:54 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: I suspect you'll find that not many people are developing with Fusebox 3 any more. There are definitely a lot of sites out there that are running it and will probably never be upgraded (I have several, along with some FB2 ones as well), but my impressions is that most Fuseboxers are pretty much using Fusebox 4 for new development. That being said, i do something quite similar to that for my fbx_Layouts file. I don't use a subdirectory, use a lay prefix for my fuse names, and hold the layout selection variable in the request scope rather than variables, but the idea is identical. I also use a second variable 'attributes.suppressLayouts' which, if set to true', will cause layouts to be skipped. cheers, barneyb On Wed, 22 Dec 2004 19:53:30 +0100, Mark Drew [EMAIL PROTECTED] wrote: Hi there as you might now I am trying to make a plugin for fusebox 3. what I was wondering was how do people make their fbx_Layouts.cfm file? The reson I ask is that I have seen the demo and default but I wanted to implement best practice. Personally I do something like: cfparam name=defaultLayout default=homepage cfset fusebox.layoutDir = layouts\ cfswitch expression=#defaultLayout# cfcase value=homepage cfset fusebox.layoutFile = homepage_layout.cfm /cfcase cfcase value=content cfset fusebox.layoutFile = content_layout.cfm /cfcase cfcase value=login cfset fusebox.layoutFile = login_layout.cfm /cfcase cfcase value=blank cfset fusebox.layoutFile = lay_blank.cfm /cfcase cfdefaultcase cfset fusebox.layoutFile = blank_layout.cfm /cfdefaultcase /cfswitch -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ \ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ Got Gmail? I have 10 invites. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsDefined with dynamic variable
Both options works,
Thanks Qasim and Raymond
Change it to one of these two things:
cfif structKeyExists(form,desc_id#x#)
or
cfif isDefined(form.desc_id#x#)
On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur [EMAIL PROTECTED]
wrote:
Cfif IsDefined('form[Desc_ID#x#]')
This is giving me the following error
Parameter 1 of function IsDefined, which is now
form[Desc_ID1], must be a syntactically valid variable
name.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188571
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search for a string across columns
Concatobate = Concatenate ya I got that, but it's the kind of date that seemed like I wouldn't. And don't for get your wildcards on the like '%#search#%' I did and just corrected it. thanks. I haven't been able to get this to search across multiple columns yet. I haven't checked it out for the space issue you mentioned though. Right now my line 1 is in memory of and line_2 is 'donald duck'. I'll think about it. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Patrick McGeehan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:11 PM To: CF-Talk Subject: RE: search for a string across columns Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' /cfquery You would just have to worry about the spaces because in your example line_1 and line_2 would concat to I need togo to the bathroom, so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1=I need to line_2=go to the bathroom and I searched need to go, it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' /cfquery thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
Tony, I am having the exact same problem on an application that we have just upgraded to MX. We have never seen this problem in CF5. On Sat, 18 Dec 2004 10:44:03 -0500, Tony Weeg [EMAIL PROTECTED] wrote: twas what i thought, but the same code, with an insert that has no ' in the value thats coming from the form, doesnt bomb, so i can single that out. its the strangest effin thing ive seen :( -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Deleting Image
Can anyone help with this error? I know the file exists in that location
however I'm not able to thumbnail pics that are uploaded nor am I able to
delete the images, This is the error when trying to remove an image.
The destination
C:\Inetpub\voremarketing\zimages\uploadedItemImages\wyb.gif specified in
the CFFILE tag is invalid.
The destination either does not exist or is not accessible by this tag.
The error occurred in
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
line 76
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
line 57
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
line 1
!--- 2 START ---
cfif isDefined('FORM.chkDelete_#itemImageID#')
cffile
action=delete
file=#Request.RootSystemPath#zimages\uploadedItemImages\#itemImageURL#
cfquery name=deleteImageURL datasource=#DS#
DELETE FROM tblItemImages
WHERE itemImageID = #itemImageID#
/cfquery
/cfif
!--- 2 FINISH ---
Web Your Business Inc., - located in Loveland, Colorado; serving the World!
http://www.webyourbusiness.com/ - - http://www.aaabusinesshosting.com/
Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188574
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Best CF Blog 2004
scroogeI know this off-topic, but sometimes I feel like I'm the only person in the world who doesnt like blogs. Infact, what I specifically dont like about blogs is that eveyone has one./scrooge -Adam On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt [EMAIL PROTECTED] wrote: Which CF blog provides the best content in your opinion? I have a thread over at http://www.webdevref.com/blog/ for voting purposes. Nothing too scientific but I wanted to see if there are any essential CF blogs I should be reading. I'm looking for unique content vs the prolific linker. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Deleting Image
Check the permissions on the folder. Whatever account CF is running
under needs to have access to that directory.
John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer
-Original Message-
From: Jason Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 2:51 PM
To: CF-Talk
Subject: Deleting Image
Can anyone help with this error? I know the file exists in that location
however I'm not able to thumbnail pics that are uploaded nor am I able
to delete the images, This is the error when trying to remove an image.
The destination
C:\Inetpub\voremarketing\zimages\uploadedItemImages\wyb.gif specified
in the CFFILE tag is invalid.
The destination either does not exist or is not accessible by this tag.
The error occurred in
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm:
line 76
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm:
line 57
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm:
line 1
!--- 2 START ---
cfif isDefined('FORM.chkDelete_#itemImageID#')
cffile
action=delete
file=#Request.RootSystemPath#zimages\uploadedItemImages\#itemImageURL#
cfquery name=deleteImageURL
datasource=#DS#
DELETE FROM tblItemImages
WHERE itemImageID = #itemImageID#
/cfquery
/cfif
!--- 2 FINISH ---
Web Your Business Inc., - located in Loveland, Colorado; serving the
World!
http://www.webyourbusiness.com/ - - http://www.aaabusinesshosting.com/
Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188576
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Best CF Blog 2004
Adam, At MAX, weren't you talking about setting up a blog? :-) John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 3:00 PM To: CF-Talk Subject: Re: OT: Best CF Blog 2004 scroogeI know this off-topic, but sometimes I feel like I'm the only person in the world who doesnt like blogs. Infact, what I specifically dont like about blogs is that eveyone has one./scrooge -Adam On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt [EMAIL PROTECTED] wrote: Which CF blog provides the best content in your opinion? I have a thread over at http://www.webdevref.com/blog/ for voting purposes. Nothing too scientific but I wanted to see if there are any essential CF blogs I should be reading. I'm looking for unique content vs the prolific linker. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188577 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Best CF Blog 2004
It's okay, I feel the same way about Wikis. Adrocknaphobia wrote: scroogeI know this off-topic, but sometimes I feel like I'm the only person in the world who doesnt like blogs. Infact, what I specifically dont like about blogs is that eveyone has one./scrooge -Adam On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188578 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setup datasource thru code?
On Wed, 22 Dec 2004 08:11:37 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Yeah, there is a factory method you can use : http://www.petefreitag.com/item/152.cfm I don't see how or why this isn't supported as isn't this what CF is using to create DSN's itself? They are undocumented, unsupported and subject to change in every release. In other words, you can't rely on them even if they happen to work today. Why are they not supported? Because the product team reserve the right to re-implement their admin code without having to provide backward-compatibility for undocumented features I guess. That's pretty standard in every product. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 4 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
This is absolutely the build version you are using. We rebuilt our dev and stage servers recently which meant our production server was on an older build. It took me some time to realize that the duplicated apostrophe/single quote thing was due to the cfquery, cfqueryparam. Here is the technote on the issue: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108 Brian Meloche wrote: Tony, I am having the exact same problem on an application that we have just upgraded to MX. We have never seen this problem in CF5. On Sat, 18 Dec 2004 10:44:03 -0500, Tony Weeg [EMAIL PROTECTED] wrote: twas what i thought, but the same code, with an insert that has no ' in the value thats coming from the form, doesnt bomb, so i can single that out. its the strangest effin thing ive seen :( -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search for a string across columns
I might be wrong but I would have thought that the DBMS will simply expand the cancat syntax to the full version with the ORs in that you started with. In other words it may be useful shorthand but it will not change/improve the actual query. On Wed, 22 Dec 2004 14:43:09 -0400, daniel kessler [EMAIL PROTECTED] wrote: Concatobate = Concatenate ya I got that, but it's the kind of date that seemed like I wouldn't. And don't for get your wildcards on the like '%#search#%' I did and just corrected it. thanks. I haven't been able to get this to search across multiple columns yet. I haven't checked it out for the space issue you mentioned though. Right now my line 1 is in memory of and line_2 is 'donald duck'. I'll think about it. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Patrick McGeehan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:11 PM To: CF-Talk Subject: RE: search for a string across columns Concatobate. What type of db you are using says what the concat operator is. The below is for oracle. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE '#s#' /cfquery You would just have to worry about the spaces because in your example line_1 and line_2 would concat to I need togo to the bathroom, so depending on how it is set up over all maybe concat with a space between, like this WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || ' ' || line_5 || ' ' || line_6 LIKE '#s#' Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:11 PM To: CF-Talk Subject: search for a string across columns I have a db that contains 6 similar columns: line_1, line_2 , line_3 , line_4 , line_5 , line_6 I want to have a search that searches across columns. While I can search them individually, it would be better if they were combined before the LIKE was done so that if I had: line_1=I need to line_2=go to the bathroom and I searched need to go, it would return a hit. I'm not sure how to approach this but while I have a beginning, I know that it is incorrect because it's the first type of search, searching each line individually. cfquery name=getSearchItem datasource=dpch SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number FROM giving_leaves WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' /cfquery thanks for the help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF_HappyHolidays
Hi all,
cfif isdefined('R')
cfif R = 'C'Merry Christmas!
cfelseif R = 'J'Happy Hanukkah!
cfelseif R = 'A'Happy Kwanzaa!
cfelseif R = 'B'Happy Bodhi Day (belated, sorry)!
cfelseif R = 'P'Yuletide Greetings!
/cfif
cfelse
Happy Holidays!
/cfif
Dave
--
David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
866-CIRCA3K (247-2235)
Outside U.S: +1.775-832-2445
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188582
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion built-in tags and permission-based security framework
I have put up the total diagram of the product I am working on and contains the security layer I mentioned. http://www.mschopman.demon.nl/diagram.gif And a screenshot of the permission set screen in my cms app.. http://www.mschopman.demon.nl/set.gif If you need any help figuring out what the heck it is .. (the diagram looks a bit abstract yes.. :P ) feel free to drop me an email or ask me through msn messenger. Micha From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wed 12/22/2004 3:07 PM To: CF-Talk Subject: RE: ColdFusion built-in tags and permission-based security framework Thanks -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 11:57 To: CF-Talk Subject: Re: ColdFusion built-in tags and permission-based security framework Stephen Moretti (cfmaster) wrote: Ian Vaughan wrote: How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? Ian, Are you saying that you have a separate category table for each department? Yes, each department about 6 in total Ok - you definately need to abstract the design of your database. At the minute, if you need to add a new department or remove a department you have to get your hands dirty, create a new table or remove a table from the database and make changes to the code to allow for this. What you need to do is have one category table, one user/member of staff table and a department table. The departments table maintains the complete list of departments along with a unique ID for each department. The same is true for the users and categories tables. You then need to relate these tables to one another, ie. have tables that tell you which users belong in which department and which departments have access to which categories. Take a look at the ER diagram I've run up for you here http://snipurl.com/bilm It fairly simplified, but hopefully it should help to make sense of what I'm describing above. With a database structure like this you can add and remove departments extremely easily, add new users to departments and change the categories available to any given department as well as allow multiple departments access to one category. How does this work? Your user logs in, so you get a unique identifier for them by querying the users table during the login process. SELECT UserID FROM Users WHERE UserName='#form.loginname#' AND Password = '#hash(form.loginpassword)#' With that UserID you can identify the department(s) that that user is a member of, by querying the link table between user and department. SELECT Department.DepartmentID, Department.DepartmentName FROM Department INNER JOIN DeptMembers AS DM ON Department.DepartmentID = DM.DepartmentID WHERE DM.UserID = #qryUser.UserID# If you want to know what categories they can access you can get this information by JOINing DepartmentMembers to Categories through DepartmentCategories. SELECT Categories.CategoryID, Categories.CategoryName FROM Categories INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID = DC.CategoryID INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID = DM.DeparmentID WHERE DM.UserID = #qryUser.UserID# This doesn't take in to account handling your tree of categories, but as you've more than likely got the code to manage this, it shouldn't be too hard to integrate what is here with what you've got for the category tree. BTW : You should have a look at John Celko's nested set model (http://snipurl.com/JoeCelko_NestedSets - you will need to register on the site, but its free and I've not had any spam from them) Hope this helps Regards Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
And to you too
http://www.spike.org.uk/funny/12days.cfm
:)
Spike
David Delbridge wrote:
Hi all,
cfif isdefined('R')
cfif R = 'C'Merry Christmas!
cfelseif R = 'J'Happy Hanukkah!
cfelseif R = 'A'Happy Kwanzaa!
cfelseif R = 'B'Happy Bodhi Day (belated, sorry)!
cfelseif R = 'P'Yuletide Greetings!
/cfif
cfelse
Happy Holidays!
/cfif
Dave
--
Stephen Milligan
Code poet for hire
http://www.spike.org.uk
Do you cfeclipse? http://cfeclipse.tigris.org
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188584
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
Invalid CFML construct found on line 2 at column 15. ColdFusion was looking at the following text: = Dang operators get me all the time, too. Happy holidays. -Joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188585 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
Need to edit that. The 25th is the first day of Christmas, and the 12th day is the 5th of January of the next year (the day before Epiphany, which is the 6th). But funny none the less. cheers, barneyb On Wed, 22 Dec 2004 13:20:19 -0800, Spike [EMAIL PROTECTED] wrote: And to you too http://www.spike.org.uk/funny/12days.cfm :) Spike -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ Got Gmail? I have 10 invites. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
Hate to chime in with not much help, but I've had the same problem. One application was fine, but another handgrenaded with single quote passing thru the insert. Weird! I think I ended up doing a replace(yourvariable, ', #8217;, 'ALL) to make it work. Would that help? Will ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
Barney Boisvert wrote: Need to edit that. The 25th is the first day of Christmas, and the 12th day is the 5th of January of the next year (the day before Epiphany, which is the 6th). But funny none the less. I always thought that Epiphany *was* the twelfth day of Christmas. I guess I just never counted. ;-) cheers, barneyb On Wed, 22 Dec 2004 13:20:19 -0800, Spike [EMAIL PROTECTED] wrote: And to you too http://www.spike.org.uk/funny/12days.cfm :) Spike -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
done Barney Boisvert wrote: Need to edit that. The 25th is the first day of Christmas, and the 12th day is the 5th of January of the next year (the day before Epiphany, which is the 6th). But funny none the less. cheers, barneyb On Wed, 22 Dec 2004 13:20:19 -0800, Spike [EMAIL PROTECTED] wrote: And to you too http://www.spike.org.uk/funny/12days.cfm :) Spike -- Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188589 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Best CF Blog 2004
Infact, what I specifically dont like about blogs is that eveyone has one. Adam: Sadly, everyone *doesn't* have one... but we're getting there. Thanks to network effects, every new blog just broadens the base of my knowledge, enriches the online experience, and generally makes the world a better place. -- Roger Benningfield work: http://journurl.com/ blog: http://admin.support.journurl.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188590 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
David Delbridge wrote:
Hi all,
cfif isdefined('R')
cfif R = 'C'Merry Christmas!
cfelseif R = 'J'Happy Hanukkah!
cfelseif R = 'A'Happy Kwanzaa!
cfelseif R = 'B'Happy Bodhi Day (belated, sorry)!
cfelseif R = 'P'Yuletide Greetings!
/cfif
cfelse
Happy Holidays!
/cfif
Or even:
cfparam name=religion type=string default=
cfswitch expression=#religion#
cfcase value=Christian
Merry Christmas!
/cfcase
cfcase value=Jewish
Happy Hanukkah!
/cfcase
cfcase value=Huh?
Happy Kwanzaa!
/cfcase
cfcase value=Buddist
Happy Bodhi Day (belated, sorry)!
/cfcase
cfdefaultcase
Happy Holidays!
/cfdefaultcase
/cfswitch
K.
--
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188591
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
Spike wrote: And to you too http://www.spike.org.uk/funny/12days.cfm Hmmm... a little derivative. Frank Kelly (you might know him as Fr. Jack Hackett from Father Ted), during the '70s, was one of the comedians on an Irish satirical show called Hall's Pictorial Weekly. On that, he performed the following piece: http://www.msgr.ca/msgr-2/christmas_countdown.htm aside Confusingly, Gobnait in the song is supposedly male, but Gobnait is the feminine of the name Gob(h)án, meaning smith, from the Celtic god Goibniu, who was a smith and brewer. Hmmm... /aside K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
oh well! It displayed as a friggin single quote on this post. lol. Guess I should've removed some of it. Anyway, I replaced the single quote with a html equivalent. #8217 That worked! Is it friggin christmas yet??? Will ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
oh well! It displayed as a friggin single quote on this post. lol. Guess I should've removed some of it. Anyway, I replaced the single quote with a html equivalent. #8217 That worked! Is it friggin christmas yet??? Will ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
Speaking of single quotes, Mike D needs to add a single quote in the title of this site. It says CF-Talk Todays Thread. :) Will ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Singleton Design Pattern
I am just playing with the singleton design pattern, and this is how I
imagine it implemented in ColdFusion, I am just looking after some feedback
on this, and most likely improvements. And maybe I am just way off!!?
If needed I can provide some more info on what's going on.
* Object.cfc
cfcomponent
displayname=Object
hint=
output=false
author=Taco Fleur ([EMAIL PROTECTED])
!---
Define: Is A
Define: Has A
---
!--- Declare properties for this Object ---
!--- Create instance variables ---
cfscript
//
/cfscript
cffunction
name=init
access=public
returntype=Object
cfscript
// Return the instance of the Object
return getInstance();
/cfscript
/cffunction
cffunction
access=private
name=isSingleton
output=false
returntype=boolean
displayname=Is Singleton
hint=Returns whether this object is a singleton
cfreturn false /
/cffunction
cffunction
access=private
name=setSingleton
output=false
returntype=void
displayname=set Singleton
hint=
cfscript
evaluate( getSingletonScope() [ getMetaData( this
).name ] = this );
/cfscript
/cffunction
cffunction
access=private
name=getSingleton
output=false
returntype=struct
displayname=Get Singleton
hint=
cfscript
return evaluate( getSingletonScope() [
getMetaData( this ).name ] );
/cfscript
/cffunction
cffunction
access=private
name=getInstance
output=false
returntype=struct
displayname=Get Instance
hint=
cfscript
// Check if this object is a singleton
if ( isSingleton() )
{
// Check if the singleton is
instantiated
if ( isInstantiatedSingleton() )
{
// Get the singleton
this = getSingleton();
}
// Otherwise instantiate the singleton
else
{
setSingleton();
}
}
return this;
/cfscript
/cffunction
cffunction
access=private
name=getSingletonScope
output=false
returntype=string
displayname=Get Singleton Scope
hint=Returns the scope this singleton should be
placed in
cfreturn variables /
/cffunction
cffunction
access=private
name=isInstantiatedSingleton
output=false
returntype=boolean
displayname=Is Instantiated Singleton
hint=
cfscript
return structKeyExists( evaluate(
getSingletonScope() ), getMetaData( this ).name );
/cfscript
/cffunction
/cfcomponent
* Child.cfc
cfcomponent
extends=Object
displayname=Child
hint=
output=false
author=Taco Fleur ([EMAIL PROTECTED])
!---
Define: Is A
Define: Has A
---
!--- Declare properties for this Object ---
!--- Create instance variables ---
Re: single quotes???
I was able to get it to work by using a CFQUERYPARAM with PreserveSingleQuotes around the string, as mentioned in a previous thread. On Wed, 22 Dec 2004 17:31:09 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: Speaking of single quotes, Mike D needs to add a single quote in the title of this site. It says CF-Talk Todays Thread. :) Will ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: single quotes???
That approach will get around it but the issue is that you are defeating a mechanism designed to protect against SQL injection attacks. I say update your CFMX per the hotfix: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108 Brian Meloche wrote: I was able to get it to work by using a CFQUERYPARAM with PreserveSingleQuotes around the string, as mentioned in a previous thread. On Wed, 22 Dec 2004 17:31:09 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: Speaking of single quotes, Mike D needs to add a single quote in the title of this site. It says CF-Talk Todays Thread. :) Will ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188598 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Mac/Flash Video assistance requested
Hi, I first have to confess my ignorance when it comes to the issues of Mac web browsers and throw myself on the stake of the OS gods as supplication for my shame! Having said that, I am hoping that I could gain some assistance from a MAC user who might spare some time to determine where we have gone wrong with a particular Flash Video applet we created and why it won't run in a MAC browser. The flash video applet can be found at http://www.halomaps.org/index.cfm?pg=15sid=17 select any from the list. We pull the *.flv video file name from a database then append it to the URL line to tell the flash applet to run it. Mac users are reporting that they can't see it. I suspect it has to do with the Flash plug-in version mismatch but I no longer have a MAC to test it with. It appears to work fine in Windows browsers with the Flash 7.x plug-in but MAC users are complaining. Any insight you can give to this lowly Windows programmer would be greatly appreciated. Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfobject and abcpdf
This product looks pretty cool. Anyone use it a coldfusion solution yet ? Dave Eric McCormick wrote: i've never registered a com object on my cf server and i don't know how to call it from the cfobject tag. You register COM DLLs using regsvr32.exe, which you can call from the command line like so: regsvr32 mydll.dll As for the rest, the specifics will depend on the COM object in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 Thanks Dave - The COM object in question is ABCPDF (an HTML-PDF converter) from websupergoo.com I've had so many problems with htmldoc.exe (which can't handle CSS) that I need to try something new only we can't afford expensive solutions like activePDF. If anyone has ever used ABCPDF and can lend any advice on calling it from coldfusion, your advise would be greatly appreciated. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
I DID IT!! Shameless Self-promotion
cf_owntrumpet action=blow I finally did it - I sat my Macromedia ColdFusion Developer exam today and not only passed, I bloody CREAMED it !!! In all four areas of the test, I scored 80% - Application Development, Database Concepts, Client state management and Data exchange. Which means Mike Kear is now an Advanced Certified Coldfusion Developer!!! /cf_owntrumpet As a work colleague said when I got back to the RTA today - So you got 20% of them wrong huh? -- Cheers Mike Kear Advanced Certified ColdFusion Developer Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: I DID IT!! Shameless Self-promotion
Congrats mate! And as soon as the Blackstone test comes out ... :-) -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:17 PM To: CF-Talk Subject: I DID IT!! Shameless Self-promotion cf_owntrumpet action=blow I finally did it - I sat my Macromedia ColdFusion Developer exam today and not only passed, I bloody CREAMED it !!! In all four areas of the test, I scored 80% - Application Development, Database Concepts, Client state management and Data exchange. Which means Mike Kear is now an Advanced Certified Coldfusion Developer!!! /cf_owntrumpet As a work colleague said when I got back to the RTA today - So you got 20% of them wrong huh? -- Cheers Mike Kear Advanced Certified ColdFusion Developer Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188602 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: I DID IT!! Shameless Self-promotion
Well done Mike -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:17 PM To: CF-Talk Subject: I DID IT!! Shameless Self-promotion cf_owntrumpet action=blow I finally did it - I sat my Macromedia ColdFusion Developer exam today and not only passed, I bloody CREAMED it !!! In all four areas of the test, I scored 80% - Application Development, Database Concepts, Client state management and Data exchange. Which means Mike Kear is now an Advanced Certified Coldfusion Developer!!! /cf_owntrumpet As a work colleague said when I got back to the RTA today - So you got 20% of them wrong huh? -- Cheers Mike Kear Advanced Certified ColdFusion Developer Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188603 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: I DID IT!! Shameless Self-promotion
Mike Kear wrote: cf_owntrumpet action=blow I finally did it - I sat my Macromedia ColdFusion Developer exam today and not only passed, I bloody CREAMED it !!! So how much of a raise are you going to ask for now? -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188604 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
