Re: Complex Logic Help needed...
Dave Phillips wrote: > > I am now trying to JOIN these two queries using a Query of Queries to > join the SCORES of the original search results to the 'expanded' data > found in the database. My ideal result would be a query with all > expanded data (everything is related as it should be) and the score > from the original process, task, or detail that was found in the > search result related to the right records. So, for example, if the > search criteria was found in a detail, and the score on that was say > 78%, and if that search criteria was used in 4 different tasks that > were each used on two different processes, then I should end up having > 8 rows in my database with the same 78% score. I think you can do better on that. For instance, you can weigh the results by multiplying hits in the process by 3, hits in the tasks with 2 and hits in the details with 1, then dividing by the total number of tasks and details. > I explained as much as possible just in case someone might think of > another completely different approach to what I'm trying to do. Why not use the full text searching of your database? > Again, > I am trying to avoid storing all 4,000+ records in the index, so, at > this point, that is not an option. Why not? Is the speed difference even significant? Typically searching an index scales with the natural logarithm of the cardinality so 4000 composite records should only be 1.5 times slower then 900 individual records. You will easily loose that much on running a second query and joining that to the cfsearch result. Jochem ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Complex Logic Help needed...
Hi folks. I have a kind of complex situation and have tried several things but haven't gotten the exact results I need. Any suggestions you might have are welcome. Here's the scenario. (Keep in mind I'm on MX 6.1) I have some information stored in a database in three tables: processes, tasks, and details. There are a total of about 900 rows of data. This data is inter-related to one another in the following ways: I have a list of 'processes' like this: 1. Repair an Ice Cream Maker 2. Repair a Toaster 3. etc. There are about 20 of these that I store in the collection. The only data stored is the name of the process itself as shown above. I also have a list of 'tasks'. These tasks are related to processes. For example, tasks in Process #1 above might be: 1. Disassemble unit. 2. Find broken part. 3. Replace broken part. 4. Reassemble unit. Now, keep in mind, that I have only ONE record in the task table that says 'Dissable unit.' but that particular record is related to more than one process records. through a relation table called 'process_task_relation'. I have the same situation with details of each task being related to tasks. One detail record could be related to multiple task records. Okay, now that you have an understanding of the database set up, here's my issue. I am trying to index this data into a collection for fast text searching. Basically, if I index everything as it is related to each other, I end up with about 4,000+ rows in the collection. Of course, this means that information is in the collection more than once (an occurrence of each task relation to a process means the task is in there that many times, and so on for details as well). CFSEARCHes run faster on a smaller collection, so I'm trying to figure out how to index only the individual rows and then expand them out on the search results page. So, what I am doing on my search results is that I run my CFSEARCH to get my matching individual records. Then, I use those 'keys' to pull the 'expanded' records from the database (e.g. Process only, Process + Task or Process + Task + Detail). So I end up with two query result sets: 1. result set from CFSEARCH which has the original search results with the scores based on the search criteria. 2. result set from database which has more than one record that relates back to each of the records in the search results. I am now trying to JOIN these two queries using a Query of Queries to join the SCORES of the original search results to the 'expanded' data found in the database. My ideal result would be a query with all expanded data (everything is related as it should be) and the score from the original process, task, or detail that was found in the search result related to the right records. So, for example, if the search criteria was found in a detail, and the score on that was say 78%, and if that search criteria was used in 4 different tasks that were each used on two different processes, then I should end up having 8 rows in my database with the same 78% score. I explained as much as possible just in case someone might think of another completely different approach to what I'm trying to do. Again, I am trying to avoid storing all 4,000+ records in the index, so, at this point, that is not an option. Thanks in advance for your suggestions or comments. Dave ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: "Richest" ColdFusion E-Commerce Site
>The largest selling point to me is "product options" if you have 400 similar >products I shouldn't need to setup options for every one of these products, >unless you really need this because of product SKU. Ability to duplicate a >product with options is a key selling point. I do think that having clear requirements does help greatly when it comes to selecting an ecommerce product. You want to have a list of requirements and level of importance when you go shopping for one. While I think I have a pretty good product, I also know there are people out there for whom something else is a better fit. Products like mine that try to be really comprehensive on features can be a little more challenging for the merchant, no matter how user-friendly I make it. In some cases, they may be better off with something really simple and with basic features. Options is one particular area where carts differ greatly. Some are very basic while others offer so much complexity, their options system is sold as a separate software add-on. I've tried to have a pretty flexible system, and mine does allow for either standard options that you can use for multiple products or custom ones you design for a single product, as well as a system for doing things like free-entry textboxes, quantity text fields, checkboxes, etc. And you can certainly dup a product as well and carry all of that over to a new one. >Building the product from the same "options" set >would be great but in this scenario we don't want the customer to select >size. if product options also have a check box for "Allow Customer to >Change" or something would be great. Not really sure I follow what you are doing here, but I think my addons would possibly cover it. >Now batch upload of products and POS integration would be Sexy! My next version will also have the batch upload (export as well) as well as an orders export and import function to update your stock amounts. Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cfdocument and cfloop
Figured you already had your answer, but didn't see any other posts to your question. How about just surrounding the pagebreak with a check for even-numbered records? > Is there a way to force the cfloop to loop (2) records per page, then insert > the pagebreak, then loop two more records on the next page, and so on? ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RFC: CFMX Runtime Server
Snake wrote: > So do u still get a cfadmin if u do this ? Depends. If the ISV includes it in his distribution and makes it accessible you get it, otherwise you don't. Our preferred scenario is to include a cfadmin but only make it accessible through the built-in webserver. Jochem ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: RFC: CFMX Runtime Server
So do u still get a cfadmin if u do this ? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 06 January 2007 11:20 To: CF-Talk Subject: Re: RFC: CFMX Runtime Server AJ Mercer wrote: > If the EAR contains the CF engine, wouldn't this require a license too > (for each server it is deployed on)? That is what the ISV does. He delivers a complete application that can be deployed on any standard J2EE server with a license for X CPUs. The hosting party does not have to know anything about CF, they don't have a have any licenses for CF, they just deploy the EAR/WAR. Jochem ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: "Richest" ColdFusion E-Commerce Site
On 1/5/07, Clark Valberg <[EMAIL PROTECTED]> wrote: > > Casey, > > Talk about "love thy enemy". Not being afraid to promote the local > competition - that takes heart... bravo Casey... > > -- Clark Our main focus is not e-commerce websites, it's marketing. Sure we have a few sites that are commerce but most tend to fall into other categories so it's an easy sell for us to push Mountain Media on particular sites that need a lot of commerce capabilities and do so from time to time, plus, I doubt any of our clients care about coldfusion enough to read this thread anyway. Like you, we'd love to find a good solid cart for use on some of our sites but we haven't found one that's "quick" enough to hack up for those specialized shops. As an example, a project I'm finishing up now uses a cart that looked good on paper and has lots of features, ends up costing more to implement than the project is worth. I spent so much time fixing holes in CFShopKart its not even worth mentioning the name here except to say it's not worth $2.50. Something for the shop builders our there: The largest selling point to me is "product options" if you have 400 similar products I shouldn't need to setup options for every one of these products, unless you really need this because of product SKU. Ability to duplicate a product with options is a key selling point. Product options are also an issue with "InStock" items where the color, size, etc are pre-set. Building the product from the same "options" set would be great but in this scenario we don't want the customer to select size. if product options also have a check box for "Allow Customer to Change" or something would be great. Now batch upload of products and POS integration would be Sexy! Casey ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with column output
P.S Here is the query. Not sure if there is a better way to write it to get the desired effect. I removed the InitCount query since is will not help my cause and cannot nest it within my other query driven output. The whole problem lies in not being able to get the currentrow and recordcount of just the categories (27) and do not think this will work with all the records being pulled from this one query. SELECT sc.scategoryID, sc.categoryID, sc.subCategoryName, c.categoryName, c.catstatus, c.categoryImage FROM dbo.CLSFD_CategoriesSub_1 sc INNER JOIN dbo.CLSFD_Categories c ON sc.categoryID = c.categoryID WHERE c.catstatus = ORDER BY c.categoryID ASC Doug B. - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, January 05, 2007 9:53 PM Subject: Help with column output > I am trying to output the following into 3 columns, the query returns a list of categories and their corresponding sub-categories. There is 27 categories in the list and like 400 subs. I cannot seem to get it. I appreciate the help!! > > > > > component="totallyclassified.components.commonQrys" > method="InitAllMainSubCats" > returnvariable="AllMainSubCatsRet"> > > > > > > component="totallyclassified.components.commonQrys" > method="InitCount" > returnvariable="records"> > > > > > > > > > > > > #Trim(CategoryName)# > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Doug B. > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
AW: Getting parameter to CF
Hello, I found the solution #cgi.REDIRECT_URL# #cgi.REDIRECT_QUERY_STRING# Is my friend. I got all parameter I want !! Thanks to you Daniel -Ursprüngliche Nachricht- Von: Jon Clausen [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 6. Januar 2007 04:19 An: CF-Talk Betreff: Re: Getting parameter to CF Daniel, Do you have any rewrite rules configured? If so, the method of accessing your path variable depends on the Rewrite Rule. For example, I have this rewrite rule in one of my apps: RewriteRule ^www/go/(.*) /go.cfm?path=/go/$1&$2 [L,PT] When that rule was in effect, any path information after the /go/ would be accessed with the CGI.QUERY_STRING variable. If you don't have a rewrite rule in effect, you can simply access that through the CGI.SCRIPT_NAME variable by using the "/" as a list delimiter. In your case with your url (www.testesttest.com/[PARAMETER1]/? testvar1=daniel&testvar2=peter): Your CGI.SCRIPT_NAME would be "/[PARAMETER1]/index.cfm" You could get Parameter1 with: HTH, Jon On Jan 5, 2007, at 7:55 PM, Daniel Hikel wrote: > Hello, > > I searched the internet and some documentation about getting a > parameter direct to coldfusion, but till know it does not working. > > I am opening my internetpage: > www.testesttest.com/[PARAMETER1]/?testvar1=daniel&testvar2=peter > > The url bevause of different parameter1 does not existing that while > im using an .htaccess file with modrewrite > > # .HTACCESS FILE FOR MODREWRITE > RewriteEngine on > > # REDIRECTION > ErrorDocument 404 /channel/index.cfm > # END > > Till now I used the rewrite and javascript to get PARAMETER1 but the > other url-parameter got lost. > > JS-Script today: > > > text = self.location.href; > text= text.replace(/http:\/\//,""); > text= text.replace(/#cgi.http_host#\//,""); > location.href = > 'http://#cgi.http_host#/channel/index.cfm?channel='+text; > > > > So is there a better way to get the parameter1 and all the other > parameters? > I thought to get the parameter from an cgi. Variable but I found no > suitable one. > > Any ideas? > > Thanks in advance. > > > Daniel > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RFC: CFMX Runtime Server
AJ Mercer wrote: > If the EAR contains the CF engine, wouldn't this require a license too (for > each server it is deployed on)? That is what the ISV does. He delivers a complete application that can be deployed on any standard J2EE server with a license for X CPUs. The hosting party does not have to know anything about CF, they don't have a have any licenses for CF, they just deploy the EAR/WAR. Jochem ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question on CFC's
You could use hierarchal SQL to get it all at once from the single table too: http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf On 1/6/07, Snake <[EMAIL PROTECTED]> wrote: > You can do that with a single table. > > [categories] > categoryID int primary key > CategoryName varchar > parentCat int default (0) > > If parentCat is 0, then it is a parent Category, if it has a value, then it > is a subCategory of the specified parent. > > Then your query would be for example > > > SELECT categoryID, CategoryName, parentCat > FROM categories > Order by parentCat > > > Then to display it you just do a nested loop to get all subcategories for > each parent category. > This will only work if you have nested 1 level. > Otherwise your better off to write a UDF or custom tag to output the list > and then you can infinitely nest by calling itself. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Basic Level CMS Solution?
I've done very small sites using BlogCFC as a CMS. With a little customisation (layout etc), the page and textblock functionality combine well with the file and image management features to provide a CMS that allows the whole site to be managed from within the BlogCFC admin (and you even get a good blog to go with it :-) On 1/6/07, Paul Henderson <[EMAIL PROTECTED]> wrote: > I'm trying to find a very basic level CMS solution for small businesses that > would allow the user to edit images and text on a page, any recommendations? > I've spent today figuring out Farcry and it seems to be a little more > complex of a solution than I need. Or maybe there is an easy way to apply > Farry to a CF site that is already built and I am missing it? > > > > I also tried out activsoftware's ActiveEdit but I wasn't impressed. > > > > Thanks in advance. > > -Paul > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
