Re: Fusebox 3 Layouts
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. I reckon you'd be surprised at the number of people who are... I've got a stack of circuits, someone wants a new site, it's too easy to whack em together and Bob's your uncle :) -- Kay Smoljak http://kay.smoljak.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:188606 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
QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.
Hi All. I have a problem with a Query of a Query. The error I'm getting is: Query Of Queries runtime error. Sorting on columns of type java.sql.Types.NULL is not supported. The code is: cfquery name=qry_accommodationData dbtype=query SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice /cfquery Most of the time this works fine, but every now and again it gets a dataset that it has this problem with. I have compared the first row of a good dataset with the first row of bad dataset and they appear to be pretty much same, apart from slightly different values. As far as I'm aware CF uses the first row of the dataset to set the data types and in both the good and bad datasets none of the columns in the first have null values. Anyone got any ideas? Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188607 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?
Hey Nathan, This was with cfstoredproc and cfprocparam, with this I have seen no lapse or delay in SP's. My point was merely that it was wrong of a DBA to assume and state that the use of SP's was wrong. 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. Not true in all cases, we have had cases where an SP coded in SQL with complex concepts is way slower than a SELECT and then all the logic performed in CF - it's annoying when you have to do that but since CF does not adhere to the timeout concept in CF sometimes it has to be done! I still don't see any performance lag and we run SQL Profiler constantly! Sure it is creating and using internal SP's but they are literally mini footprints - certainly smaller footprints (in time) that it would be for CF to startup, parse, shutdown and perform SQL passing... No big deal, just what we have noticed and what we measure - its been a good thread so far ;-) -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 16:59 To: CF-Talk Subject: 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 - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188608 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: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.
Hi Andrew QofQ can be a bit of an arse some times (but bloody useful!) I would suggest in your instance that you begin by narrowing down the fields until you actually find the one(s) which are causing the NULL error. Once you have done that, in the original query you could try CASTing or CONVERTing to a supported data type - that way QofQ would have a better guess at what each column is. Give it a try. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 08:54 To: CF-Talk Subject: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported. Hi All. I have a problem with a Query of a Query. The error I'm getting is: Query Of Queries runtime error. Sorting on columns of type java.sql.Types.NULL is not supported. The code is: cfquery name=qry_accommodationData dbtype=query SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice /cfquery Most of the time this works fine, but every now and again it gets a dataset that it has this problem with. I have compared the first row of a good dataset with the first row of bad dataset and they appear to be pretty much same, apart from slightly different values. As far as I'm aware CF uses the first row of the dataset to set the data types and in both the good and bad datasets none of the columns in the first have null values. Anyone got any ideas? Andrew. ~| 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:188609 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
What would be really useful at this point is if people that have FBX3 applications send me their layout files so that I can test the layout viewer. Currently I am not sure how to implement this in a view in cfeclipse. My thoughts were of a tree something like /Application /circuit [root] /XFA.fuseaction /XFA.fuseaction2 /layouts /layoutname : layout file /layoutname1: layout file 1 /default layout: layout file /Fuseaction : layout /fuse /fuse /Fuseaction : layout /fuse /fuse /circuit2 Clicking on the /layouts node would take to the layout file Clicking on the /layoutname : layout file would take you to that layout file or Clicking on the layout name you could also set the variable (if you are in a fuseaction) to something like cfset homelayout = layoutname Let me know what you think The project homepage is : http://cfopen.org/projects/fusebox3cfe/ Regards Mark Drew On Thu, 23 Dec 2004 16:03:34 +0800, Kay Smoljak [EMAIL PROTECTED] wrote: 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. I reckon you'd be surprised at the number of people who are... I've got a stack of circuits, someone wants a new site, it's too easy to whack em together and Bob's your uncle :) -- Kay Smoljak http://kay.smoljak.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:188610 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
In One?
Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? (given that the depth of the category in the structure is unknown). Ian ~| 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:188611 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: In One?
No that is not possible. When you have a specific amount of depth you can, using multiple JOINS and separating the result with the IsNull. An example SPOC in MSSQL which returns a ColdFusion list with id's seperated with || and a list with labels separated with ||: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE dbo.upu_Instance_SitePath @PageID int, @SitePath varchar (1000) OUTPUT, @PageIDsvarchar (1000) OUTPUT AS -- Variables DECLARE @lParentID int DECLARE @lSitePath varchar (1000) DECLARE @lPageIDs varchar (1000) -- Find Parent and Label SELECT @lParentID = I.ParentID, @lSitePath = I.Label, @lPageIDs = I.InstanceID FROMdbo.Instance I WHERE (I.InstanceID = @PageID) -- Resolve sitepath recursive -- Subpages IF (@lParentID 0) BEGIN EXECdbo.upu_Instance_SitePath @PageID = @lParentID, @SitePath = @SitePath OUTPUT, @PageIDs = @PageIDs OUTPUT -- Add label of current page to the full sitepath SELECT @SitePath = @SitePath + '|| ' + @lSitePath, @PageIDs = @PageIDs + '|| ' + @lPageIDs END -- Homepage ELSE BEGIN SELECT @SitePath = @lSitePath, @PageIDs = @lPageIDs END -- The End RETURN (0) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| 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:188612 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: In One?
I think Oracle OO or object relational was supposed to do this natively, but as far as i know, it is not possible to do an arbitrary number of dynamic self-joins in native SQL. You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) Aaron - Original Message - From: Ian Buzer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 8:03 PM Subject: In One? Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? (given that the depth of the category in the structure is unknown). Ian ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188613 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: In One?
You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) *cough* I think I misunderstood this suggestion ;) Even then, varchar would be a better choice :P Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| 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:188614 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: In One?
You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. See examples in this article: http://www.sitepoint.com/article/hierarchical-data-database or google for modified preorder The query for you would be simple in this instance, assuming you're at node X with rgt value R and L Select n1.* From nodes n1, nodes n2 Where n2.nodeID=YOUR_ID And n1.rgt=n2.rgt and n1.lft=n2.lft Order by n1.rgt Those are your nodes from the root until your desired node. HTH, dov -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 5:25 AM To: CF-Talk Subject: RE: In One? You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) *cough* I think I misunderstood this suggestion ;) Even then, varchar would be a better choice :P Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188615 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: In One?
Ian Buzer wrote: This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? In SQL this is possible using the WITH (RECURSIVE) construct. DB2 implements this currently and the next version of MS SQL Server will implement this. In Oracle and custom PostgreSQL builds you can achieve the same using the CONNECT BY statement which has slightly different semantics. Jochem ~| 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:188616 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! I passed in November and I notice today that my name now appears on the macromedia site! Should see yours there at the end of Jan. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188617 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: Mac/Flash Video assistance requested
Tested on Safari, I can confirm that it doesn't work :( Here's a guess, try adding the ?url... bit onto the src attribute in the embed tag also. How are you loading the variables in from within flash? On 23 Dec 2004, at 0:06, Dennis Powers wrote: 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:188618 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
SOT: linux/unix+ samba+IIS
2 Questions: 1) Does anyone serve out CF via IIS but upload/maniupulate files on Linux/Unix via Samba+mapped drive, etc? I'm wondering how reliable a solution like this is, for very few writes to a given file, and lots of reads (which would be done via apache on the linux box directly) 2) is it easy to set up a pair of linux servers which synchronize a certain portion of their filesystem (so changes are always mirrored to the other one, regardless of which server it originated on). Thanks, and Happy Holidays, -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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188619 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
DateAdd problems.
Hi, I'm having an annoying problem with DateAdd. I'm hosted in the States and I'm in the UK so to fix that in my Applicatin.cfm I've put: cfset UKtodayDate = #DateAdd(h, 5, Now())# That is fine and i've used it forever. To find the current edition (month) of my magazine I use: cfset thisEdition = lcase(MonthAsString(month(UKtodayDate))) I want to have an image on my page which displays the next month's advert and I'm trying to get the next month's name. I've tried: cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# This doesn't seem to work so I have broken it down into two lines which is: cfset nextEditionA = #DateAdd(m, 1, Now())# cfset nextEdition = lcase(MonthAsString(month(nextEditiona))) This works BUT only when i use 'Now', but i'd really like to use 'UKtodayDate' (otherwise it's five hours behind) but for some bizarre reason it doesn't work. Is it because when i do my initial DateAdd (cfset UKtodayDate = #DateAdd(h, 5, Now())#) i'm doing it incorrectly? Is there a way I can get all of this on 1 line instead of two? Thanks for your help, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188620 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: DateAdd problems.
UKTodayDate is not a function, but a variable: nextEdition = lcase(DateFormat(DateAdd(m, 1, UKTodayDate),)) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 13:39 To: CF-Talk Subject: DateAdd problems. Hi, I'm having an annoying problem with DateAdd. I'm hosted in the States and I'm in the UK so to fix that in my Applicatin.cfm I've put: cfset UKtodayDate = #DateAdd(h, 5, Now())# That is fine and i've used it forever. To find the current edition (month) of my magazine I use: cfset thisEdition = lcase(MonthAsString(month(UKtodayDate))) I want to have an image on my page which displays the next month's advert and I'm trying to get the next month's name. I've tried: cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# This doesn't seem to work so I have broken it down into two lines which is: cfset nextEditionA = #DateAdd(m, 1, Now())# cfset nextEdition = lcase(MonthAsString(month(nextEditiona))) This works BUT only when i use 'Now', but i'd really like to use 'UKtodayDate' (otherwise it's five hours behind) but for some bizarre reason it doesn't work. Is it because when i do my initial DateAdd (cfset UKtodayDate = #DateAdd(h, 5, Now())#) i'm doing it incorrectly? Is there a way I can get all of this on 1 line instead of two? Thanks for your help, 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:188621 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: DateAdd problems.
cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# Hi Saturday, Noticed you've got an extra set of arguments after UKtodayDate which could be your problem, try: cfset nextEdition = DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate Also in the UK and always on the look out for a good host, have you found a US Host that's easy to deal with from here? Reply off list if you like. Thanks, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188622 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: DateAdd problems.
That is perfect, thanks Pascal! Saturday. -- Original Message -- From: Pascal Peters [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 23 Dec 2004 13:48:45 +0100 UKTodayDate is not a function, but a variable: nextEdition = lcase(DateFormat(DateAdd(m, 1, UKTodayDate),)) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 13:39 To: CF-Talk Subject: DateAdd problems. Hi, I'm having an annoying problem with DateAdd. I'm hosted in the States and I'm in the UK so to fix that in my Applicatin.cfm I've put: cfset UKtodayDate = #DateAdd(h, 5, Now())# That is fine and i've used it forever. To find the current edition (month) of my magazine I use: cfset thisEdition = lcase(MonthAsString(month(UKtodayDate))) I want to have an image on my page which displays the next month's advert and I'm trying to get the next month's name. I've tried: cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# This doesn't seem to work so I have broken it down into two lines which is: cfset nextEditionA = #DateAdd(m, 1, Now())# cfset nextEdition = lcase(MonthAsString(month(nextEditiona))) This works BUT only when i use 'Now', but i'd really like to use 'UKtodayDate' (otherwise it's five hours behind) but for some bizarre reason it doesn't work. Is it because when i do my initial DateAdd (cfset UKtodayDate = #DateAdd(h, 5, Now())#) i'm doing it incorrectly? Is there a way I can get all of this on 1 line instead of two? Thanks for your help, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188623 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?
You're all going to love this one... I was batch downloading a replica of the site using the SmartFTP client and it's global queue Apparently theres a known issue whereby on file-exists-on-client it appends instead of overwrites. How frustrating! I didn't actually expect cf to be at fault (I couldn't figure out how it would behave differently on that pc), but was out of things to look for. Thanks to all for your time. -Original Message- From: Katz, Dov B (IT) Sent: Wednesday, December 22, 2004 8:54 AM To: CF-Talk Subject: 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 - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188624 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: In One?
Is varchar fixed in size? If so the field would not satisfy an arbitrary depth of hierarchy. By dynamically-sized text field I mean any field type that allows an unlimited dynamic length of text, like the memo field in MS Access or DBISAM and is a generic description of what I meant. Apply as you see fit to your db of choice! Varchar in MySQL (255 chars max) is very different to Varchar in MS SQL Server (4000 chars max). I guess more than anything I'm struggling with someone saying that they dont understand what I'm suggesting then telling me here's how to make it better. Ah well. Hope your cough clears up, and Merry Christmas :-) Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 9:24 PM Subject: RE: In One? You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) *cough* I think I misunderstood this suggestion ;) Even then, varchar would be a better choice :P Micha Schopman Software Engineer ~| 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:188625 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: DateAdd problems.
Hi Ant, I just got the solution from Pascal, thanks anyhow. I use www.hostmysite.com, i find them really good actually - i've been with them about 3 or 4 years. I've tried other US firms in the past like Interland but their customer support was really bad. I often get replies to my emails within 10 minutes which are well thought out responses which are very helpful. I've never had them try to fob me off with short replies. I've never had to bother to call them though(i hate waiting on the end of a phone). I have a CF MX 6.1, 500MB, MS-SQL 50mb/25mg log (i think). Hope that helps. Saturday -- Original Message -- From: Anthony Cooper [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 23 Dec 2004 12:51:41 + cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# Hi Saturday, Noticed you've got an extra set of arguments after UKtodayDate which could be your problem, try: cfset nextEdition = DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate Also in the UK and always on the look out for a good host, have you found a US Host that's easy to deal with from here? Reply off list if you like. Thanks, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188626 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: In One?
I urge you to avoid doing that. Lets say you have a 3000 node tree, evenly distributed looking something like this: A B C DE FG ... Thousands/hundreds of nodes under here If you , say want to insert B2, between A and B, you have to update the varchar/text path column for several thousand nodes, (all of B's ancestry) which by its datatype (varchar/text), and number of updates can be very costly. (text, linear, at worst) Alternatively if you do it using modified preorder tree traversal, you would be making numeric updates in order to do the same. (numeric, linear, at worst) Granted, both of these are the costs of precomputing helper data to avoid recursing every time you need to find out the structure and paths of arbitrary nodes, but if you are going to do either, I suggest the latter. -Dov -Original Message- From: Aaron DC [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 7:59 AM To: CF-Talk Subject: Re: In One? Is varchar fixed in size? If so the field would not satisfy an arbitrary depth of hierarchy. By dynamically-sized text field I mean any field type that allows an unlimited dynamic length of text, like the memo field in MS Access or DBISAM and is a generic description of what I meant. Apply as you see fit to your db of choice! Varchar in MySQL (255 chars max) is very different to Varchar in MS SQL Server (4000 chars max). I guess more than anything I'm struggling with someone saying that they dont understand what I'm suggesting then telling me here's how to make it better. Ah well. Hope your cough clears up, and Merry Christmas :-) Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 9:24 PM Subject: RE: In One? You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) *cough* I think I misunderstood this suggestion ;) Even then, varchar would be a better choice :P Micha Schopman Software Engineer ~| 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:188627 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: DateAdd problems.
DateAdd takes a date as 3rd argument, not the name of the month Pascal cfset nextEdition = DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate ~| 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:188628 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: In One?
I thought you were making a joke.. :) One of the principles of a good database design is not to use lists of id's. You could better if you really want to do such thing, create a seperate table to store the path. The disadvantage of using lists is, you cannot use constraints to force existing relationships and you cannot index the data in a optimal form. You'd be better off with two tables like: Table 1: Path ID = Identity ObjectID = Int (object for which the path is stored, so this could also be ArticleID for example) Table 2: PathData ID = Identity PathID = Int (Contains ID from the Path table) Priority = TinyInt (Contains an order) Target = Int (contains the result of a path, can be ID, anything you want to) So with this data Path table: ID = 1 ObjectID = 138475384047 PathData ID = 1 PathID = 1 Priority = 1 Target = 3567242 ID = 1 PathID = 1 Priority = 2 Target = 3453456 ID = 1 PathID = 1 Priority = 3 Target = 75637 So you'll get the path for ObjectID = 138475384047 Path = 3567242,3453456,75637 And this data can easily be extended with constraints, indexes etc. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188629 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: In One?
H I was not too serious - hence my use of the word cheat. You did understand my suggestion, but wanted to make it better, by using VarChar. I still fail to see how using varchar would make it better. Having developed a number of databases in my time I am well aware of the improperness of storing lists of id's. The customer wanted to: [store an arbitrary length hierarchy in one table] and [retrieve the path to the root parent] [in one query]. I believe my solution works based on these requirements/deliverables. Heck, I'm going to suggest storing both the ID and the Category name for display purposes :p Didn't say it was elegant, valid, correct or the right shade of blue. No mention was made by the customer of modifying the hierarchy nodes or anything. I can come up with solutions for that too, but it'll cost them extra :) The customer wanted a solution and that's all I was offering. And it's definitely cheating. :-) I've seen many properly designed database projects fail to complete and many home grown syntactically incorrect nightmare RDBMS (MS Access!) designs survive for years in both large and small organisations. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 12:18 AM Subject: RE: In One? I thought you were making a joke.. :) One of the principles of a good database design is not to use lists of id's. You could better if you really want to do such thing, create a seperate table to store the path. The disadvantage of using lists is, you cannot use constraints to force existing relationships and you cannot index the data in a optimal form. You'd be better off with two tables like: Table 1: Path ID = Identity ObjectID = Int (object for which the path is stored, so this could also be ArticleID for example) Table 2: PathData ID = Identity PathID = Int (Contains ID from the Path table) Priority = TinyInt (Contains an order) Target = Int (contains the result of a path, can be ID, anything you want to) So with this data Path table: ID = 1 ObjectID = 138475384047 PathData ID = 1 PathID = 1 Priority = 1 Target = 3567242 ID = 1 PathID = 1 Priority = 2 Target = 3453456 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188630 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: In One?
Columns of the type text are stored in a different way than varchar columns. Varchar columns have a much lesser effect on performance, and the amount of characters is more than enough to store paths from new york to tokio. Text columns are stored with pointers in another place, because it is a variable length column. They aren't stored along with the row, but the row only contains a pointer to the place where the text column is stored, and this slows a table down. SQL Server features functionality to combine the performance power of varchar with the flexibility power of text by using text in row. This allows you to say to SQL Server store the first XXX characters with the row, and the rest in another spot and create pointer to it. The will dramatically increase performance, and I could recommend everyone using text columns to use this feature. It is truly awesome. I did some extensive testing and noticed improvements over 1000% speed on large tables. The feature is called text in row. You first must enable the feature and then update each row to follow the new rules of storage. EXEC sp_tableoption 'Content', 'text in row', 'ON' GO UPDATE Content SET Data = C.Data, FROM Content C Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188631 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
404 headaches - Windows O/S
I have been working to get custom 404 error handlers with auto email and it appears I am incapable (or plain irritated) of getting it done. We migrated all htm to cfm and want to verify all is well. I set the CF Admin (CF MX 6.1, W2K3 Server) to handle 404 errors for CF pages and it is fine. The problem I am having is when I set IIS 6 to go to the same page (404.cfm) I get mixed results? Such as I received over 500 + emails in minutes (No way I have that many 404’s ( (I setup auto email to notify of course)) and I think the page has issues. My concerns are these two: 1. I am unable to capture the requested page, I tried #CGI.SCRIPT_NAME#, #CGI.PATH_INFO# and I get the 404.cfm page as the requested page every time? (The CF admin page gets the right one when I tested it) 2. I was bombarded with emails to the point I had to comment out the cfmail tag, when I checked the referral page (#CGI.HTTP_ REFERER#) and there were no broken links? It would help to know what page was requested! If anyone has any insight I would appreciate it, I am at my wits end and I have searched for weeks and cannot locate any threads anywhere that can shed some light on this,only other confused individuals. This is the following sendmail code: cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=404 Error/File Missing type=html A 404 Error Occuredbrbr Time Stamp: #DateFormat(NOW(),'MM/DD/')# at #TimeFormat(NOW(),'hh:mm:ss tt')#brbr Details:br Request Method:nbsp;#CGI.HTTP_REQUEST_METHOD#br IP Address:nbsp;#CGI.REMOTE_ADDR#br Browser/Details:nbsp;#CGI.HTTP_USER_AGENT#br Refferal Page:nbsp;a href=#CGI.HTTP_REFERER##CGI.HTTP_REFERER#/abr br Please review links of the following page:br Request Info:nbsp; #CGI.PATH_INFO#br /cfmail All apologies for the length, just want to be clear as possible, Thanks! John ~| 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:188632 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: In One?
We don't know (and I won't assume) that the customer is using SQL Server. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 1:07 AM Subject: RE: In One? Columns of the type text are stored in a different way than varchar columns. Varchar columns have a much lesser effect on performance, and the amount of characters is more than enough to store paths from new york to tokio. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188633 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: In One?
Performance often comes at the sake of good design. Good design should always come first though. :) Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 8:19 AM To: CF-Talk Subject: RE: In One? I thought you were making a joke.. :) One of the principles of a good database design is not to use lists of id's. You could better if you really want to do such thing, create a seperate table to store the path. The disadvantage of using lists is, you cannot use constraints to force existing relationships and you cannot index the data in a optimal form. You'd be better off with two tables like: Table 1: Path ID = Identity ObjectID = Int (object for which the path is stored, so this could also be ArticleID for example) Table 2: PathData ID = Identity PathID = Int (Contains ID from the Path table) Priority = TinyInt (Contains an order) Target = Int (contains the result of a path, can be ID, anything you want to) So with this data Path table: ID = 1 ObjectID = 138475384047 PathData ID = 1 PathID = 1 Priority = 1 Target = 3567242 ID = 1 PathID = 1 Priority = 2 Target = 3453456 ID = 1 PathID = 1 Priority = 3 Target = 75637 So you'll get the path for ObjectID = 138475384047 Path = 3567242,3453456,75637 And this data can easily be extended with constraints, indexes etc. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| 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:188634 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
SOT: Flash list
Hi folks, I'm searching an active Flash developers list like CF-Talk. Does anyone know an active flash list? Murat. ~| 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:188635 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: In One?
And that is why I suggested the table approach instead of a list approach. Constraints are a important part of good design, and cannot be achieved with lists. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188636 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: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.
Question is how do you want to treat Null. Since NULL has no value, you will have to use IsNULLL() or your db equivalent to set a value that is either the highest or lowest, depending on how you wish to sort. If you need to keep the value as NULL, then create a sort field that contains the converted value(s). Andy -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 2:54 AM To: CF-Talk Subject: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported. Hi All. I have a problem with a Query of a Query. The error I'm getting is: Query Of Queries runtime error. Sorting on columns of type java.sql.Types.NULL is not supported. The code is: cfquery name=qry_accommodationData dbtype=query SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice /cfquery Most of the time this works fine, but every now and again it gets a dataset that it has this problem with. I have compared the first row of a good dataset with the first row of bad dataset and they appear to be pretty much same, apart from slightly different values. As far as I'm aware CF uses the first row of the dataset to set the data types and in both the good and bad datasets none of the columns in the first have null values. Anyone got any ideas? Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188637 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: In One?
I meant relations Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| 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:188638 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: SOT: Flash list
Flashcoders http://chattyfig.figleaf.com/ On Thu, 23 Dec 2004 16:33:25 +0200, Murat Demirci [EMAIL PROTECTED] wrote: Hi folks, I'm searching an active Flash developers list like CF-Talk. Does anyone know an active flash list? Murat. -- // Jaye Morris | Multimedia - Web Applications Developer // www.jayezero.com // [EMAIL PROTECTED] // [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188639 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: In One?
You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. Hey, thanks Dov, that's lovely. As far as I understand it so far, it does have the snag that if you make a change near the top of the hierachy, a whole lot of data below has to be updated. Also, in this particular instance, I'm importing the category heirachy from another app on a daily basis which uses the other schema, so I'm probably looking at a long process to convert it from one schema to another during the import. Ian ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188640 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
How to make mx run all .php extensions
Hey all, Trying to make mx handle all .php extensions. On iis 6 we remapped to the extension but no get at message: Server Error Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Im guessing in some xml file jrun is told what extensions to handle? Anyone done this before and have any insight? gabe ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188641 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: In One?
With none of the previous message in your post I have no idea what you are replying to here. Please include some of the previous post to which you are replying, to maintain context. Thanks Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 1:40 AM Subject: RE: In One? And that is why I suggested the table approach instead of a list approach. Constraints are a important part of good design, and cannot be achieved with lists. Micha Schopman Project Manager ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188642 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: How to make mx run all .php extensions
cfmxroot/wwwroot/WEB-INF/web.xml Though I'm sure you're aware you can't actually process PHP code via CFMX Andy On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman [EMAIL PROTECTED] wrote: Hey all, Trying to make mx handle all .php extensions. On iis 6 we remapped to the extension but no get at message: Server Error Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Im guessing in some xml file jrun is told what extensions to handle? Anyone done this before and have any insight? gabe ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188643 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
CFLock , CF_Accelerate(like) help
So, a while back, I wrote a CF_Accelerate-like tag (before I knew of that one) and this one cached to file, memory, or cached query objects. I think my locking is too aggressive, and is hurting performance. I stripped down the tag below for readability... Can you please advise me whether I can change this around in any way to help performance? (Downgrade any cflocks from exclusive to readonly? Maybe eliminate some locking?) Also, which of CFFILE+Read vs. getPageContext.include() is more costly for outputting the cached file content? For file-basedc caching, I write to [filename]_tmp, and then move it to [filename] on the first read. I was worried about clashes... Any tips would be helpful... Thanks! --- Cfparam name=attributes.mode default=File|Memory|Query Cfparam name=attributes.key Cfparam name=attributes.expires Cfparam name=attributes.clearcache default=false cfparam name=application.contentcache default=#Structnew()# cfparam name=application.memorycachetagoutput default=#Structnew()# cfparam name=application.mainquerycache default=#Structnew()# cfif thistag.executionmode is Start cfif NOT attributes.clearcache AND structkeyexists(application.contentcache,attributes.key) AND abs(datediff('n',structfind(Application.contentcache,attributes.key),now ())) LT attributes.expires !--- CACHE HIT! --- cflock timeout=15 type=exclusive name=CacheTagOutput_#attributes.key# Cfif attributes.mode is File cfif fileexists(filename _tmp) Cfif fileexists(filename)cffile action=delete file=#filename# /cfif cffile action=rename source=#filename#_tmp destination=#filename# /cfif !--- used to be CFFILE reading --- Cfset getPageContext().include(#attributes.pagepath#partial_tag_cache/#attrib utes.key#.cache) cfelseif attributes.mode is memory Cfoutput#structfind(Application.memorycachetagoutput,attributes.key)# /cfoutput cfelseif attributes.mode is query CfoutputCfset caller.#attributes.queryname#=#structfind(Application.mainquerycache,a ttributes.key)#/cfoutput /cfif cfexit /cflock /cfif cfelseif thistag.executionmode is End !--- CACHE MISS (wouldn't have made it this far if a hit) --- !--- Insert Content --- cflock timeout=10 type=exclusive name=CacheTagOutput_#attributes.key# Cfif attributes.mode is file cffile action=WRITE file=#filename#_tmp output=#thistag.generatedcontent# addnewline=No cfelseif attributes.mode is memory cfset structinsert(Application.memorycachetagoutput,attributes.key,#thistag.g eneratedcontent#,true) cfelseif attributes.mode is query Cfquery dbtype=query name=cachedQueryselect * From caller.#attributes.queryname# /cfquery cfset structinsert(Application.mainquerycache,attributes.key,cachedQuery,true) /cfif !--- UPDATE TIMESTAMP OF KEY --- cfset structinsert(Application.cachetagoutput,attributes.key,now(),true) /cflock /cfif /cfif 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:188644 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 tags work inside of CSS
Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| 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:188645 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: In One?
True, but no matter what your choice of optimization, you will have a snag. You will be doing more reads than writes, and you will be doing an in-table mathematic transformation (set LFT=LFT+1 or RGT=RGT+2 for all rows whose left exceeds the newly inserted one...) That's linear, but IMHO well worth it... Check http://www.intelligententerprise.com/001020/celko1_1.jhtml, someone already wrote an import query from adjacency list (which is what everyone's used to -- row points to parent row) into this app. Disclaimer message=this might not make senseI've never done this, but I'm sure you can avoid re-balancing your tree if you assign LFT,RGT values in increments of 100 (remember good old' prodos BASIC from my early apple childhood). This way a single insert won't force a rebalance. (you'd insert parent.LFT+1, and have for your children, all numbers between parent.LFT+2 until your sibling's LFT, or your parent's RGT (if you are an only child)... It would complicate things, but slow down your update rate.../Disclaimer -Dov -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 8:51 AM To: CF-Talk Subject: Re: In One? You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. Hey, thanks Dov, that's lovely. As far as I understand it so far, it does have the snag that if you make a change near the top of the hierachy, a whole lot of data below has to be updated. Also, in this particular instance, I'm importing the category heirachy from another app on a daily basis which uses the other schema, so I'm probably looking at a long process to convert it from one schema to another during the import. Ian ~| 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:188646 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: In One?
My suggestion... Cache the data (application-scope variable) then use local UDFs or a CFC to manage processing. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 4:04 AM To: CF-Talk Subject: In One? Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? (given that the depth of the category in the structure is unknown). Ian ~| 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:188647 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 tags work inside of CSS
CF won't fire unless the page is a .cfm or .cfml extension. A .css extension won't trigger CF to render the page. On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188648 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 tags work inside of CSS
I've never tried this, do CF tags work in CSS? I am not sure if I understood your question, but I will give it a try. In case you would like to embed CFML code inside an external CSS file a solution could be to give the CSS file a .cfm extension, then add this at the top of it: cfcontent type=text/css; charset=ISO-8859-1 (use the charset you see fit) This way the file will be processed by CF server but served with a text/css mime-type so browsers will recognize it as CSS 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 Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188649 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 tags work inside of CSS
Ok, damn! Oh well, looks like a few files instead then. -- Original Message -- From: Charlie Griefer [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 23 Dec 2004 08:27:01 -0700 CF won't fire unless the page is a .cfm or .cfml extension. A .css extension won't trigger CF to render the page. On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188650 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 tags work inside of CSS
Yes, just give your css file a cfm extension and use cfcontent to have the correct mime-type (although it will work without) Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 16:16 To: CF-Talk Subject: CF tags work inside of CSS Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| 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:188651 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 tags work inside of CSS
This topic came up a several days ago. Read the archives for more details than what I can remember right now. 1. Create multiple CSS files. One file will contain only layout and formatting. Then, create individual CSS files that contain only color information. You would have an individual CSS file for each color theme, however, you only need a single CSS file for layout. In your CF template, just use a CF construct to determine which CSS color file to use. This is nice because the browser can cache the CSS files. 2. Use CF to generate the CSS dynamically and use CFCONTENT to pass the correct CSS document type. (More information in these archives.) This is not as good because CF must process the CSS page, then then send it to the browser. The browser won't cache the CSS. M!ke -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:16 AM To: CF-Talk Subject: CF tags work inside of CSS Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188652 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 tags work inside of CSS
I've never tried this, do CF tags work in CSS? Might try it using the style block on a CFM page... as Charlie mentioned the CF engine is not going to parse the CSS page. Hatton ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188653 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: How to make mx run all .php extensions
What a cheap server! j/k servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.php/url-pattern /servlet-mapping Worth mentioning, had to alter iis as well to allow scripts and executables then it started working like a charm. gabe -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:10 AM To: CF-Talk Subject: Re: How to make mx run all .php extensions cfmxroot/wwwroot/WEB-INF/web.xml Though I'm sure you're aware you can't actually process PHP code via CFMX Andy On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman [EMAIL PROTECTED] wrote: Hey all, Trying to make mx handle all .php extensions. On iis 6 we remapped to the extension but no get at message: Server Error Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Im guessing in some xml file jrun is told what extensions to handle? Anyone done this before and have any insight? gabe ~| 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:188655 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 tags work inside of CSS
Charlie Griefer wrote: CF won't fire unless the page is a .cfm or .cfml extension. A .css extension won't trigger CF to render the page. However, nothing says your stylesheets have to have a .css extension. link href=/styles.cfm rel=stylesheet type=text/css That works fine and dandy. - 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:188656 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: In One?
Ian Buzer wrote: You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. Hey, thanks Dov, that's lovely. As far as I understand it so far, it does have the snag that if you make a change near the top of the hierachy, a whole lot of data below has to be updated. Depends on what type of change. If you don't use sequential nubers for left and right but increment by a thousand initially you can easily insert items without changing the rest. I don't know which term to Google for, but last year Joe Celko indicated this would be covered by his new book Trees and Hierarchies in SQL for Smarties. Jochem ~| 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:188654 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 tags work inside of CSS
But Stuart could set .css to be rendered by CF in IIS and make his code executable, right? Or he could just append .cfm to his stylesheet and have it processed by CF, then include that as his stylesheet. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:27 AM To: CF-Talk Subject: Re: CF tags work inside of CSS CF won't fire unless the page is a .cfm or .cfml extension. A .css extension won't trigger CF to render the page. On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| 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:188659 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 tags work inside of CSS
Yes, just give your css file a cfm extension and use cfcontent to have the correct mime-type (although it will work without) As far as I know works without the mime-type in IE, not in Mozilla/fireFox. Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188660 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 tags work inside of CSS
That'll do nicely thanks Massimo. Grazie e buon natale (mangi un panatone)! Saturday -- Original Message -- From: Massimo Foti [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 23 Dec 2004 16:22:50 +0100 I've never tried this, do CF tags work in CSS? I am not sure if I understood your question, but I will give it a try. In case you would like to embed CFML code inside an external CSS file a solution could be to give the CSS file a .cfm extension, then add this at the top of it: cfcontent type=text/css; charset=ISO-8859-1 (use the charset you see fit) This way the file will be processed by CF server but served with a text/css mime-type so browsers will recognize it as CSS 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:188661 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 tags work inside of CSS
Thanks Mike and everyone else. :) Saturday -- Original Message -- From: Dawson, Michael [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 23 Dec 2004 09:29:17 -0600 This topic came up a several days ago. Read the archives for more details than what I can remember right now. 1. Create multiple CSS files. One file will contain only layout and formatting. Then, create individual CSS files that contain only color information. You would have an individual CSS file for each color theme, however, you only need a single CSS file for layout. In your CF template, just use a CF construct to determine which CSS color file to use. This is nice because the browser can cache the CSS files. 2. Use CF to generate the CSS dynamically and use CFCONTENT to pass the correct CSS document type. (More information in these archives.) This is not as good because CF must process the CSS page, then then send it to the browser. The browser won't cache the CSS. M!ke -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:16 AM To: CF-Talk Subject: CF tags work inside of CSS Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188662 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 tags work inside of CSS
If you are only changing a small quantity of of the style sheet you could move that one or two style definitions from your style sheet into your cfm pages either in the header of the html or inline if there is very little of it. -- Jay -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 23 December 2004 15:27 To: CF-Talk Subject: Re: CF tags work inside of CSS CF won't fire unless the page is a .cfm or .cfml extension. A .css extension won't trigger CF to render the page. On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi, I have a colour theme which changes each month. Instead of having 12 different stylesheets to cover for the year i wanted to have some CF code at top of my CSS page, something like: cfswitch expression=#thisMonth# cfcase value=january cfset myColour = #08BF83 /cfcase cfcase value=february cfset myColour = #085F83 /cfcase cfcase value=march cfset myColour = #08B383 /cfcase /cfswitch So when I get down to the part in the stylesheet which says: a.preferences:hover { color: #FF; background-color: #8DC63F; padding-top: 0px; padding-right: 6px; padding-bottom: 0px; padding-left: 6px; border: 1px solid cfoutput#myColour#/cfoutput; margin: 5px 4px; text-decoration: none; font-size: 10px; } I've never tried this, do CF tags work in CSS? Thanks for you time, Saturday ps: for those North Americans... cfset myColour = myColor ;) (it's actually looks weird seeing it written as 'colour' nowadays). ~| 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:188657 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: SOT: Flash list
Thank you! Murat. -Original Message- From: Jaye Morris [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 4:44 PM To: CF-Talk Subject: Re: SOT: Flash list Flashcoders http://chattyfig.figleaf.com/ On Thu, 23 Dec 2004 16:33:25 +0200, Murat Demirci [EMAIL PROTECTED] wrote: Hi folks, I'm searching an active Flash developers list like CF-Talk. Does anyone know an active flash list? Murat. -- // Jaye Morris | Multimedia - Web Applications Developer // www.jayezero.com // [EMAIL PROTECTED] // [EMAIL PROTECTED] ~| 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:188658 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
This should do it... I wrote it for a list of Top 10 Scores in a game but changed it a little to work with larger numbers. Hope it helps cfscript function nth(num) { if (right(num, 1) is 1 and right(num, 2) NEQ 11) { num = num st; } else if (right(num, 1) is 2 and right(num, 2) NEQ 12) { num = num nd; } else if (right(num, 1) is 3 and right(num, 2) NEQ 13) { num = num rd; } else { num = num th; } return num; } /cfscript -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 12:36 PM 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 - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188664 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 tags work inside of CSS
You could also use some logic in application.cfm and use cfhtmlhead to inject a style /style set into the head of the htm doc, rather than using a linked style sheet. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:29 AM To: CF-Talk Subject: Re: CF tags work inside of CSS Ok, damn! Oh well, looks like a few files instead then. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188663 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
where to put the java class?
Hi, Is there a specific location where I should put my java class? I have a java class, and currently I put it in the same directory with my calling page. When I call it, it says it could not find the class. I registered it in the Adminstrator under Java and JVM, but it still doesn't work. Please help! Johnny ~| 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:188665 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
On Wed, 22 Dec 2004 20:30:23 +, Michael Traher [EMAIL PROTECTED] wrote: 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. No, it will do the concatenate first, then the comparison. Otherwise you don't get the same results. -- 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:188666 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: where to put the java class?
On Thu, 23 Dec 2004 10:42:01 -0400, Johnny Le [EMAIL PROTECTED] wrote: Hi, Is there a specific location where I should put my java class? I have a java class, and currently I put it in the same directory with my calling page. When I call it, it says it could not find the class. I registered it in the Adminstrator under Java and JVM, but it still doesn't work. Please help! You can put it in your WEB-INF/classes directory, restart the instance, and CF will pick the class up. Regards, Dave. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188667 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
Two Selects
Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188668 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: Two Selects
Correction to code below... CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=SearchSTATE NAME2=SearchCity DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX Thanks! Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:57 AM To: CF-Talk Subject: Two Selects Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188669 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: Two Selects
Rick where did you get this tag? I am interested in using for a couple of projects...never knew it existed. Ray At 10:57 AM 12/23/2004, you wrote: Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188670 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: Two Selects
It's in the Cold Fusion Exchange at Macromedia, there is also a 3 selects related tag. Rick -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:05 AM To: CF-Talk Subject: Re: Two Selects Rick where did you get this tag? I am interested in using for a couple of projects...never knew it existed. Ray At 10:57 AM 12/23/2004, you wrote: Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188671 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: Two Selects
CF_TwoSelectsRelated tag should work on CFMX no problem. You should enable JavaScript debugging and see if you get any js errors on the page. Marius Milosav www.scorpiosoft.com It's not about Technology, it's about people Virtual Company (VICO) Application demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Rick [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 11:00 AM Subject: RE: Two Selects Correction to code below... CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=SearchSTATE NAME2=SearchCity DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX Thanks! Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:57 AM To: CF-Talk Subject: Two Selects Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188672 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: Two Selects
Sweet. thx! Ray At 11:07 AM 12/23/2004, you wrote: It's in the Cold Fusion Exchange at Macromedia, there is also a 3 selects related tag. Rick -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:05 AM To: CF-Talk Subject: Re: Two Selects Rick where did you get this tag? I am interested in using for a couple of projects...never knew it existed. Ray At 10:57 AM 12/23/2004, you wrote: Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188673 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: Two Selects
Error: missing ; before statement Source File: http://burrows.arcriver.com/i/index.cfm Line: 179, Column: 211 Source Code: NewOpt[86] = new Option(Oak Park);NewOpt[86].value = 'Oak Park'; NewOpt[87] = new Option(Oakbrook Terrace);NewOpt[87].value = 'Oakbrook Terrace'; NewOpt[88] = new Option(O'Fallon); NewOpt[88].value = 'O'Fallon'; NewOpt[89] = new Option(Orland Par Well this looks like that maybe the ' in the city o'Fallon could be the issue. Rick -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:10 AM To: CF-Talk Subject: Re: Two Selects CF_TwoSelectsRelated tag should work on CFMX no problem. You should enable JavaScript debugging and see if you get any js errors on the page. Marius Milosav www.scorpiosoft.com It's not about Technology, it's about people Virtual Company (VICO) Application demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Rick [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 11:00 AM Subject: RE: Two Selects Correction to code below... CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=SearchSTATE NAME2=SearchCity DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX Thanks! Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:57 AM To: CF-Talk Subject: Two Selects Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188674 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: Two Selects
In the TwoSelectsRelated.cfm file on about line 100 I changed the ' to NewOpt[#Counter2#].value = '#Evaluate(Attributes.Value2)#'; To NewOpt[#Counter2#].value = #Evaluate(Attributes.Value2)#; Does anyone see any reason why I shouldn't? Rick -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:18 AM To: CF-Talk Subject: RE: Two Selects Error: missing ; before statement Source File: http://burrows.arcriver.com/i/index.cfm Line: 179, Column: 211 Source Code: NewOpt[86] = new Option(Oak Park);NewOpt[86].value = 'Oak Park'; NewOpt[87] = new Option(Oakbrook Terrace);NewOpt[87].value = 'Oakbrook Terrace'; NewOpt[88] = new Option(O'Fallon); NewOpt[88].value = 'O'Fallon'; NewOpt[89] = new Option(Orland Par Well this looks like that maybe the ' in the city o'Fallon could be the issue. Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188675 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: Two Selects
use JSStringFormat and not evaluate Marius Milosav www.scorpiosoft.com It's not about Technology, it's about people Virtual Company (VICO) Application demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Rick [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 11:23 AM Subject: RE: Two Selects In the TwoSelectsRelated.cfm file on about line 100 I changed the ' to NewOpt[#Counter2#].value = '#Evaluate(Attributes.Value2)#'; To NewOpt[#Counter2#].value = #Evaluate(Attributes.Value2)#; Does anyone see any reason why I shouldn't? Rick -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:18 AM To: CF-Talk Subject: RE: Two Selects Error: missing ; before statement Source File: http://burrows.arcriver.com/i/index.cfm Line: 179, Column: 211 Source Code: NewOpt[86] = new Option(Oak Park); NewOpt[86].value = 'Oak Park'; NewOpt[87] = new Option(Oakbrook Terrace); NewOpt[87].value = 'Oakbrook Terrace'; NewOpt[88] = new Option(O'Fallon); NewOpt[88].value = 'O'Fallon'; NewOpt[89] = new Option(Orland Par Well this looks like that maybe the ' in the city o'Fallon could be the issue. Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188676 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: In One?
Cache the data (application-scope variable) then use local UDFs or a CFC to manage processing. Yes, I'm beginning to think this may be the best compromise. Particularly as, although there's about 18k categories, probably 10% of those are queried 90% of the time. So, following on from this ... does anyone know if there is a way of programmatically 'sizing' a variable (or CFC) to see how much memory it's consuming? Ian ~| 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:188677 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: where to put the java class?
In addition to the suggestion that Dave made earlier, you can also load Java classes remotely. Here is a link to a blog post by Christian Cantrell on this technique. http://www.markme.com/cantrell/archives/005295.cfm On Thu, 23 Dec 2004 10:48:44 -0500, Dave Carabetta [EMAIL PROTECTED] wrote: On Thu, 23 Dec 2004 10:42:01 -0400, Johnny Le [EMAIL PROTECTED] wrote: Hi, Is there a specific location where I should put my java class? I have a java class, and currently I put it in the same directory with my calling page. When I call it, it says it could not find the class. I registered it in the Adminstrator under Java and JVM, but it still doesn't work. Please help! You can put it in your WEB-INF/classes directory, restart the instance, and CF will pick the class up. Regards, Dave. ~| 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:188678 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
mailing label custom tag?
Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:188679 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: Two Selects
Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188680 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: Two Selects
I don't have a need for it now but I did a while back. Can't you upload it to the Exchange? Rick -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:24 AM To: CF-Talk Subject: RE: Two Selects Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188681 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: Two Selects
Andy... I'd sure be interested Tim -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 12:24 PM To: CF-Talk Subject: RE: Two Selects Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188682 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: Two Selects
You also might want to look at the qForms implementation of this concept. Its pretty easilly implemented. http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm Tim Laureska wrote: Andy... I'd sure be interested Tim -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 12:24 PM To: CF-Talk Subject: RE: Two Selects Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188683 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: Two Selects
Ray, I have had better luck FWIW with the QForms JSAPI and their n-related select boxes. They work with any browser and are rock solid. http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm No problems with 2 and 3 selects related though I tried once to get a 5 selects related going and couldn't make it work :)! Rick Mason On Thu, 23 Dec 2004 11:05:15 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Rick where did you get this tag? I am interested in using for a couple of projects...never knew it existed. Ray At 10:57 AM 12/23/2004, you wrote: Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~| 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:188684 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: Two Selects
I will do just that, thank for the advice! Ray At 01:07 PM 12/23/2004, you wrote: Ray, I have had better luck FWIW with the QForms JSAPI and their n-related select boxes. They work with any browser and are rock solid. http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm No problems with 2 and 3 selects related though I tried once to get a 5 selects related going and couldn't make it work :)! Rick Mason On Thu, 23 Dec 2004 11:05:15 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Rick where did you get this tag? I am interested in using for a couple of projects...never knew it existed. Ray At 10:57 AM 12/23/2004, you wrote: Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188685 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
Development Tools
Hello everyone, I'm looking for some good CVS software (free preferably) that works under Cold Fusion. I've seen a few good ones in PHP, but I'd much rather have it in CF. I'd rather not have a client application, nor do I want to install any applications on the server. Also, what coding standards do you use? Have any links to share? Thanks a lot. Let me know if I'm not being clear enough. -Blaine ~| 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:188686 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: Two Selects
I've always used this one; it has an example going 6 deep, and I don't think there is a limit... http://www.mattkruse.com/javascript/dynamicoptionlist/ -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:24 AM To: CF-Talk Subject: RE: Two Selects Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188687 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
Scheduling/Appointment application
Happy Holidays everyone! A few months ago there was a pretty in depth discussion regarding the database model and programming techniques of a scheduling/appointment application, but I can't seem to find it in the archives anywhere. If anyone could point me to this discussion or to any articles related to this, I would appreciate it. Right now, I am looking at mimicking the SQL sysjobschedules methodology. The only drawback is their use of bitmasks for frequency intervals could make for an unnecessarily complex calendar query. I'm sure someone has come across a better method. If anyone has any advise or resources to share, I'm all ears. Thanks in advance, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| 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:188688 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: mailing label custom tag?
I had one somewhere around here...I can dig up after xmas to see if I didn't lose it. Its at the office. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:16 AM To: CF-Talk Subject: mailing label custom tag? Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:188689 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: mailing label custom tag?
Thanks! I actually found one on the dev exchange a few minutes ago. it was written for CF5, but I am playing with it now, and don't see why it is going to make a difference which version I am running it under. cf-averyrtf it is called...and it is pretty damn cool! Ray At 02:21 PM 12/23/2004, you wrote: I had one somewhere around here...I can dig up after xmas to see if I didn't lose it. Its at the office. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:16 AM To: CF-Talk Subject: mailing label custom tag? Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:188690 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: mailing label custom tag?
That's the one I had. Enjoy. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 1:25 PM To: CF-Talk Subject: RE: mailing label custom tag? Thanks! I actually found one on the dev exchange a few minutes ago. it was written for CF5, but I am playing with it now, and don't see why it is going to make a difference which version I am running it under. cf-averyrtf it is called...and it is pretty damn cool! Ray At 02:21 PM 12/23/2004, you wrote: I had one somewhere around here...I can dig up after xmas to see if I didn't lose it. Its at the office. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:16 AM To: CF-Talk Subject: mailing label custom tag? Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188691 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: mailing label custom tag?
Where did you find it at? Thanks! Russell - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 1:25 PM Subject: RE: mailing label custom tag? Thanks! I actually found one on the dev exchange a few minutes ago. it was written for CF5, but I am playing with it now, and don't see why it is going to make a difference which version I am running it under. cf-averyrtf it is called...and it is pretty damn cool! Ray At 02:21 PM 12/23/2004, you wrote: I had one somewhere around here...I can dig up after xmas to see if I didn't lose it. Its at the office. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:16 AM To: CF-Talk Subject: mailing label custom tag? Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188692 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: mailing label custom tag?
Ask and ye shall receive! (For those that might read this in the future, I found it on the MM exchange, search for 'Avery' under coldfusion exchange) http://makeashorterlink.com/?T2972481Ahttp://makeashorterlink.com/?T2972481A Ray At 02:42 PM 12/23/2004, you wrote: Where did you find it at? Thanks! Russell - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 1:25 PM Subject: RE: mailing label custom tag? Thanks! I actually found one on the dev exchange a few minutes ago. it was written for CF5, but I am playing with it now, and don't see why it is going to make a difference which version I am running it under. cf-averyrtf it is called...and it is pretty damn cool! Ray At 02:21 PM 12/23/2004, you wrote: I had one somewhere around here...I can dig up after xmas to see if I didn't lose it. Its at the office. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:16 AM To: CF-Talk Subject: mailing label custom tag? Does anyone know of a custom tag that has the ability to create mailing labels? If it had the ability to create them in various Avery formats, that would be even cooler! Google didn't seem to help too much Thanks, and have a merry merry! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:188693 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
Prefixing local variables
I've started to use a dollar sign as a prefix for variables which are local to a function or CFC. i.e. those variables created when using the var keyword. CFSET var $Localvar= I could have also used an underscore like so: CFSET var _Localvar= I plan to give out the new CFCs and functions I'm writing (the logger is in use and is being tweaked as we speak) and was wondering which you, the ColdFusion using world, would prefer. I like the dollar sign, but I'm willing to listen to what people have to say. As an aside, can someone using Blue Dragon please test to see if the dollar sign and underscore are legal for variables on that platform? Thanks ~| 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:188694 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: Two Selects
Rick, Be sure you escape or remove any single or double quotes or any JavaScript unfriendly characters from the data before feeding the tag. 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 -Original Message- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:57 AM To: CF-Talk Subject: Two Selects Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. form action=index.cfm?t=results method=post name=FormX cfquery datasource=#App_DataSource# name=QryGetCityStates username=#App_DataBaseUser# password=#App_DataBasePass# SELECT DISTINCT STATE, City FROM TblMain WHERE State '' ORDER BY State /cfquery CF_TwoSelectsRelated QUERY=QryGetCityStates NAME1=form.STATE NAME2=form.City DISPLAY1=STATE DISPLAY2=City VALUE1=STATE VALUE2=City FORCEWIDTH1=70 FORCEWIDTH2=70 AUTOSELECTFIRST=No HTMLBETWEEN=BR FORMNAME=FormX .. /form Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/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:188695 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
AW: In One?
Hi Ian and everybody else, Check out the book trees and hierarchies in SQL for smarties by Joe Celko. ISBN: 1-55860-920-2 It gives a very good overview about how to treat trees in a SQL database. It's really good, and it refers to the nested set tree model very deeply. I use SQL-Server and i wrote a couple of triggers that keep my lft, rgt and lvl values up to date. If you need them, just email me at [EMAIL PROTECTED] Btw. The trick about not having to update so many records in a nested set tree model if you insert a node near to the top is that you do not use gaps with the size of 1 between the bottom leafs. You can use steps of eg. 10. So if you have to insert a node to the left of the topmost treenode with the left value of 1 and the left value of the first subordinate of 11 you can just insert the new record with the lft and rgt values of 2 and 3 without any further update. (check out Chapter 5 in the mentioned book called frequent insertion trees) cfgreetings from=[EMAIL PROTECTED] to=reader location=bern country=switzerland function=railo core developer message=merry xmas -Ursprüngliche Nachricht- Von: Ian Buzer [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 23. Dezember 2004 14:51 An: CF-Talk Betreff: Re: In One? You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. Hey, thanks Dov, that's lovely. As far as I understand it so far, it does have the snag that if you make a change near the top of the hierachy, a whole lot of data below has to be updated. Also, in this particular instance, I'm importing the category heirachy from another app on a daily basis which uses the other schema, so I'm probably looking at a long process to convert it from one schema to another during the import. Ian ~| 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:188696 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: Prefixing local variables
On Thu, 23 Dec 2004 14:54:34 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I've started to use a dollar sign as a prefix for variables which are local to a function or CFC. i.e. those variables created when using the var keyword. CFSET var $Localvar= I could have also used an underscore like so: CFSET var _Localvar= I don't like either and I'm puzzled as to why you do it. After all, everthing that is not a local variable will be prefixed by variables. or arguments. right? -- 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:188697 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: Prefixing local variables
I just wanted something to force recognition that a variable is local to the function without having to prefix every argument that is passed in. As the arguments prefix is optional, this helps in recognition and self documentation of the code. On Thu, 23 Dec 2004 14:54:34 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I've started to use a dollar sign as a prefix for variables which are local to a function or CFC. i.e. those variables created when using the var keyword. CFSET var $Localvar= I could have also used an underscore like so: CFSET var _Localvar= I don't like either and I'm puzzled as to why you do it. After all, everthing that is not a local variable will be prefixed by variables. or arguments. right? ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188698 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: Two Selects
qForms is what I have used for this as well. I like being able to control the layout of my form more so than what could be done with the two or three selects tags. I put up some examples a long time ago doing n-selects with qForms, actually before pengoworks had any up. Maybe I should go through mine and make sure they are done correctly :) On Thu, 23 Dec 2004 12:59:16 -0500, Chris Stoner [EMAIL PROTECTED] wrote: You also might want to look at the qForms implementation of this concept. Its pretty easilly implemented. http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm Tim Laureska wrote: Andy... I'd sure be interested Tim -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 12:24 PM To: CF-Talk Subject: RE: Two Selects Slightly OT but I managed to alter the 3 selects and create a 4 selects related tag if that is of any help to anyone? It was a nightmare to do and I can't actually remember how I did it but it works great, I had to alter it to enable a user to select a region, country, division club, I am sure it could be useful for other things with a few more changes? ~| 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:188699 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: How to make mx run all .php extensions
It didn't work for me, I tried to use another extension than php. but it shows the same error. What a cheap server! j/k servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.php/url-pattern /servlet-mapping Worth mentioning, had to alter iis as well to allow scripts and executables then it started working like a charm. gabe -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:10 AM To: CF-Talk Subject: Re: How to make mx run all .php extensions cfmxroot/wwwroot/WEB-INF/web.xml Though I'm sure you're aware you can't actually process PHP code via CFMX Andy On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman [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:188700 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: Prefixing local variables
On Thu, 23 Dec 2004 15:43:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I just wanted something to force recognition that a variable is local to the function without having to prefix every argument that is passed in. As the arguments prefix is optional, this helps in recognition and self documentation of the code. I prefer to see code explicitly using arguments scope (and variables scope) so it is crystal clear where data is coming from. If you omit arguments. then you can't tell whether it's an argument or a variables scope item (assuming that someone who might omit arguments. might also omit variables.). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 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:188701 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: Prefixing local variables
On Thu, 23 Dec 2004 13:00:08 -0800, Sean Corfield [EMAIL PROTECTED] wrote: I prefer to see code explicitly using arguments scope (and variables scope) so it is crystal clear where data is coming from. And it also makes the code faster since CF doesn't have to search multiple scopes for an unqualified variable that is really not a local variable! -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 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:188702 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
Beating a .net horse! Job interview confirms suspicions...
Kick me off the list if you want. I doubt I could piss anyone off any worse than I already have, so I'm going to post this anyway. And I'm not posting in CF-Community! 1. I don't want to sign up for it 2. I think five people probably frequent the place! I just had a job interview with a local, high profile web design company here in the Triad (NC). They're probably the biggest outfit around this area. So the lady asked me the usual questions. Dreamweaver? Handcode? Flash? .NET? CF wasn't a big concern of hers when I told her I was a CF developer. She asked me if *I* had any questions. So I thought this is the PERFECT opportunity to find out the truth about what REAL WORLD design firms are using to build their apps. I asked her, Are most of your apps CF or .NET?. It took her 1/2 second to answer, .NET. DOT friggin NET! She went on about how they don't do much CF. It's a trend fellas! And I'll guarantdamnteeya it's indicitave of the market! I rest my case, Thank you! Will ~| 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:188703 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: Beating a .net horse! Job interview confirms suspicions...
cf_sarcasm Well Will...I guess you had better learn .NET as apparently CF is dead...LMAO!! /cf_sarcasm Merry Ho Homabye Santa will bring you some new tools to play with Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.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:188704 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: Beating a .net horse! Job interview confirms suspicions...
I just had a job interview with a local, high profile web design company here in the Triad (NC). They're probably the biggest outfit around this area. So the lady asked me the usual questions. Dreamweaver? Handcode? Flash? .NET? CF wasn't a big concern of hers when I told her I was a CF developer. She asked me if *I* had any questions. So I thought this is the PERFECT opportunity to find out the truth about what REAL WORLD design firms are using to build their apps. I asked her, Are most of your apps CF or .NET?. It took her 1/2 second to answer, .NET. DOT friggin NET! She went on about how they don't do much CF. It's a trend fellas! And I'll guarantdamnteeya it's indicitave of the market! I rest my case, Thank you! If that's your case, it's a good thing you're not a lawyer. I've been doing consulting at a large company in the DC area that uses CF 5 and Notes (an IBM product), and I asked them what they plan to use for future applications, and they said CFMX on WebSphere (another IBM product). What's more, I asked them whether they were planning to switch to Exchange, and they said no! Based on this one incident, I strongly recommend you sell your Microsoft stock and buy IBM's, because MS is obviously doomed. 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 Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188705 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