Re: Shopping Cart
See oscommerce.com for what they are working on - it is really good. There's also OFBiz (Open for Business Project) http://www.ofbiz.org - It's a friggin' beast, but looks rather cool. Personally, I love their PARTY entity model - at the very least, their db schema alone is worth looking at. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Beer is living proof that God loves us and wants us to be happy. - Benjamin Franklin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221799 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: Shopping Cart
Damien McKenna wrote: Sounds like there must be an MLM or two involved. Que? I don't quite get the MLM association (you mean Multi-Level Marketing?) OfBiz is a sourceforge project all under MIT Open Source licensing... Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221826 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: Shopping Cart
Damien McKenna wrote: My comment was regarding the party customer type which relates to sales parties that are typically held in private houses amongst friends. It's a common MLM sales technique. Oh! Gotchya - Naw the Party Entity Model works like this: (as per ofBiz Site) A Party can be either a Person, or a group of Parties. A Party Group could be a company, an organization within the company, a supplier, a customer, and so forth. Information that describes Parties or is directly related to Parties is contained in these entities. In short - this level of abstraction is something I've seen even commercial products missing. Something to consider in an O.S. shopping cart scenario. I mean, how many devlopers JUST stop at the front end of e-commerce. There are alot of other systems that (in the end) it will have to work with. Take fulfillment and warehousing for instance. And having a good entity model right up front can help you from getting blasted down the road when you have to say: integrate a shopping cart with an order fulfillment system. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221843 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: data structure for unlimited nested items
Careful with that technique - it can get ugly really fast... Yeah, as previously mentioned theres the Celko Nested Set: http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=235427 http://www.codebits.com/ntm/ Not bad, though its rather volatile on update (if something goes awry during a record update - you're seriously screwed) , and indexing it is pretty much next to impossible because of the joins. But on the upside you can have pretty much infinite relationships based on two integer fields. In fact - Celko has an entire book on this and other hierachy techniques: http://www.codebits.com/ntm/ Theres also some interesting work being done on materialized paths and nested sets using some wacked out fractional calcs: http://www.dbazine.com/oracle/or-articles/tropashko4 http://arxiv.org/html/cs.DB/0401014 Upside here is that indexes can be build a bit easier, and the insert update functionality is lightning fast.. downside - large trees get kinda scary. Hope all that helps. Cheers, Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Bobby Hartsfield wrote: Thanks for the response. I guess I should have mentioned that it's MySQL. I'm thinking that I could do something like... itemID ItemTitle ItemURL ItemParentID And parent ID would just point to another record in the same table if the item was indeed a sub item of another item. That items 'parent' could then also point to another item as its parent, etc... And maybe just a 0 for parentID when the item is 'top level'. I've used this before but I've always known exactly how deep the nests would go which in turn let me know exactly how many nested loops I would need to build everything ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221878 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: When will Dave Watts finally blog?
Fred Urban wrote: Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I thought MAX was a professional conference. Sure, everyone has a few beers, lets their hair down, but to pass out drunk in a hotel lobby bar is in extremely poor taste and shows a lack of professionalism. Who else had to be drug up to their room and put to bed? He's lost any respect I might have had for him. Wow... all I can say is: wow. Well, the 'lurker' will say (to save the good Mike D. some trouble)- let's move this and other 'personal' conflicts off to Community as this conversation has clearly degraded. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221770 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: godaddy.com now has CFMX7 hosting!
FYI ...we recently had a client leave godaddy... transfer was an absolute nightmare...let me emphasize ABSOLUTE Word to the wise: You get what you pay for. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Andy Matthews wrote: Forwarded from my local CFUG mailing list... Looking for cheap MX 7 hosting? well Godaddy now has it as an add on for $1.95 to their already ridiculously low $3.95 a month hosting. http://www.godaddy.com !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221075 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
org.w3c.dom.Document to human readable format
Anyone know (off-hand) a quick and dirty way to reduce a xerces dom document to raw text (In CFMX7)? I have a java class returning of type org.w3c.dom.Document and essentially I want to just spit it out to screen, without having to jump through massive hoops. Thought toString() would get me there... nope... tried replacing the native cf xml parser with xerces... nope. Which by the way, is that even really necessary? What is 7 using for xml parsing these days anyways, still Crimson? Ah well... I hate these so close, but so far situations... Cheers, Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220976 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: MD5 Hmac - What am I missing here?
I need to create an MD5 HMAC Digest for authentication - alas, CF6.1 doesn't do this - it only creates a one way MD5 hash. Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Figy, Kam wrote: Unless you must use java, CF6.1's hash() function does MD5. -Original Message- From: Short Fuse Media [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 2:54 PM To: CF-Talk Subject: Re: MD5 Hmac - What am I missing here? Hmm, didn't seem to affect it... question, would even Bin2Hex be apropriate in this instance? Or would it be better to loop through the byte array itself and make the hex string per byte? Which leads me to my next question - how would one accomodate this byte to hex conversion in cf w/out the byte datatype? -Erik Howie Hamlin wrote: Try this: messageDigest = createObject(java,java.security.MessageDigest); messageDigest = messageDigest.getInstance(MD5); messageDigest.reset(); messageDigest.update(keyString.getBytes()); ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220278 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
MD5 Hmac - What am I missing here?
For some odd reason I took it upon myself to write an HMAC generator in cfml/java on MX 6.1 (don't ask, I'm masochistic like that) - and so far I believe I've gotten to this point: cfscript keyString = myKey; dataString = HelloWorld; messageDigest = createObject(java,java.security.MessageDigest); messageDigest = messageDigest.getInstance(MD5); messageDigest.update(keyString.getBytes()); outputDigest = messageDigest.digest(dataString.getBytes(UTF-16LE)); /cfscript Now, the var outputDigest gives me a byteArray, which I hit with the CF-Lib Bin2Hex UDF. my result is as such: b2aec7d67de6f0b74cd965a5aa87af58 Now when I compare this to the old CF_HMAC tag (which works peachy, its just that I think I could do the same in 6-12 lines as opposed to a massive custom tag) I get the digest of: 78BD9886C78FA6D8F0C70CD943883010 Clearly I'm a bit off here - anyone have any ideas? Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220160 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: MD5 Hmac - What am I missing here?
Hmm, didn't seem to affect it... question, would even Bin2Hex be apropriate in this instance? Or would it be better to loop through the byte array itself and make the hex string per byte? Which leads me to my next question - how would one accomodate this byte to hex conversion in cf w/out the byte datatype? -Erik Howie Hamlin wrote: Try this: messageDigest = createObject(java,java.security.MessageDigest); messageDigest = messageDigest.getInstance(MD5); messageDigest.reset(); messageDigest.update(keyString.getBytes()); ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220169 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: State/Country listings
Check the uber-cool UN/LOCODE database: http://www.unece.org/cefact/codesfortrade/codes_index.htm Erik Yowell Short Fuse Media, Inc. [EMAIL PROTECTED] Burns, John D wrote: Anyone know of a good and free table/database of official state/province/territory names and abbreviations as well as official country names and abbreviations? I've been looking at USPS but haven't had a whole lot of luck and Google hasn't revealed much with the searches I've put in. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219021 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: Gateway Pages and IIS
Rewrite is your friend! Love it, breathe it, pet it For instance, I believe with something like ISAPI rewrite: http://www.isapirewrite.com/ the configuration file is loaded dynamically, so all you'd have to do is programatically add rewrite strings to the config file for each url you'd map to, or a servlet would probably work. Either way - it sounds like you need something that'll sit above your application that'll process the urls correctly and pass them off to your log files (for statistical tracking purposes). Erik Yowell Beer is living proof that God loves us and wants us to be happy. - Benjamin Franklin Mickael wrote: Hi All, I am hoping that someone on this list has worked through this before I reinvent the wheel. We have a small content management system that we have written that allows users to make changes to their site. We would like to add a new feature where users can create gateway for marketing. When our users create a new page on our system the URL ends up being www.ourdomain.com/index.cfm?pageid=111 (or what ever number). Our issue now is that we would like to make pages that easier to read and print on advertising. So for example if they create a page that is connect to Marketing they would like to be able to access that page via www.domain.com/marketing The only way that I can see this working is to create an interface in my CMS that would create a new folder in the webroot of thier choosing and insert an index.cfm file in at folder with a cflocation tag point ing to index.cfm?pageid=111 or whatever the url. This solution would work, but would create a ton of folders in our webroot, and we also have our own folders for the app there as well. My question is there a more elegant way of handling this problem? We have played with the idea of adding an Intelligent 404 page but part of the goal is to have their stats package also track the accesses to these pages. I was just wondering what other people are doing? We are Using IIS as a web server. Thanks Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214791 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: squares in QoQ
Haven't tested it, but does the Sqr function work in this case? http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=0870.htm Erik Yowell Short Fuse Media, Inc. Matthew Walker wrote: I notice the power operator doesn't seem to work inside query-of-queries. For example: WHERE (#params.x# - x)^2 + (#params.y# - y)^2 #params.range^2# The third one actually does work as CF evaluates it before processing the query code. The first and second don't work as they are part of the SQL. I can of course just use a multiplication operator. But I was wondering if there's any info about on what operators are supported in QoQ (this is CF7). ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214184 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
