RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
I have read all the crud where people say CFC's are like OOP but it just isn't true. The middle letter in OOP stands for Oriented. When I think of that word I think of becoming familiar with and somewhat following the general idea of whatever subject is at hand. When I apply that to Object Oriented Programming, I simply think of orienting my code around self contained entities that hide their details and inner workings behind methods - car.drive(). The part that I think is most important is deciding what becomes an object and then how the objects work together, not the syntax and extended features that make it easier to work with objects like inheritance and all the rest. There should be a term to describe this very simple, high-level concept, and it seems like using the term Oriented is right on. Maybe we just need a new acronym to more accurately describe the specific syntax of OOP when it was a concept that was exclusive to lower level language circles, because it sounds kind of silly to say you're not orienting yourself correctly when people are just trying to benefit from organizing their code around objects but might be veering a little from tradition. I hereby submit this new acronym, I hope it's not already taken: SJOCSOCPSAYBNVFTSMFOWHYSADALYAHTMLC, which you probably already guessed stands for Strict Java or C Style Object Conforming Programming Syntax and You Better Not Veer From This Sh*t Mother Fu*er or We'll Hunt Your Stupid As$ Down and Label You a Hyper Text Markup Language Coder. Not only would replacing the term Oriented with Conforming clear up a lot of confusion for people, but that acronym would just look so sweet on a resume. :) Adam. -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:44 AM To: CF-Talk Subject: RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea Just curious, OOP doesn't really apply to CF so why the OOP stuff? I have read all the crud where people say CFC's are like OOP but it just isn't true. Now OOP concepts may have been a better choice of words because that would imply the ability to understand the reasons why but not necessarily the implementation of such concepts. I suppose people could say that CFC's make you think about reuse but to be honest when I programmed in C (well before C++ caught on) I was using code reuse and nobody called it OOP. I had libraries built for all kinds of off the wall crud. But what do I knownot meant to diss the post just a thought I had as I glanced over it. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:18 AM To: CF-Talk Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer with exceptional Programming and Application Development experience. As a Developer, you will take part in the design, programming, testing and implementation of highly innovative, new publishing concepts. Qualified individuals will have 3+ years experience developing ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus. Excellent organizational, communication, and interpersonal skills. Must be team player, able to work independently (manage own work effectively, show initiative, able to focus and prioritize) but seek assistance readily when needed. A strong record of delivering projects on schedule is key. We offer competitive compensation and benefits including 401(k) with matching and a culture that fosters business and professional growth. We work in a modern, high-technology office environment, and offer generous opportunities for continuing work-related education and career advancement. EOE Qualified individuals please email resume to [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
If god didn't intend for us to eat meat, then why would he have called it meat? :) Ok, so then we should call CFC's MOP then? Modular Oriented Programming? I can deal with that. Module/Object - ok I guess I'm just not that anal. My beef is with the 'oriented', you're description isn't 'oriented', it's 'conform to this definition or you're wrong, stop thinking of what the high-level purpose of this is'. I'll call it whatever people like though. It's like getting upset over developer or programmer. I call myself glorified secretary now so not to offend anyone. Adam. -Original Message- From: Tim Hanbey [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:06 PM To: CF-Talk Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A rea The extended features of OOP like inheritance and polymorphism is what makes OOP--OOP. If we were to say ok well since we putting this code into a file and makingthe code in the file is a function that can be called is really not Object Oriented Programming. It sounds like you are trying to describe Reusing Code by modularizing it, which yes, is an aspect of OOP but isn't the full thing. You can''t write object oriented code without an object oriented language. the makes sense doesnt it? you can try and you can call your module, function or code an object, but it really isn't an object because it doesn't behave like one. If I were an OOP programmer using Java and C++ and someone told me that other people could callthemselves OOP programmers simply because they can create objects with HTML. I'd be kinda mad. OOP is a fundamental concept of programming, but you can't program using OOP if you aren't using an OOP language. nuff said -Tim Cantrell, Adam wrote: I have read all the crud where people say CFC's are like OOP but it just isn't true. The middle letter in OOP stands for Oriented. When I think of that word I think of becoming familiar with and somewhat following the general idea of whatever subject is at hand. When I apply that to Object Oriented Programming, I simply think of orienting my code around self contained entities that hide their details and inner workings behind methods - car.drive(). The part that I think is most important is deciding what becomes an object and then how the objects work together, not the syntax and extended features that make it easier to work with objects like inheritance and all the rest. There should be a term to describe this very simple, high-level concept, and it seems like using the term Oriented is right on. Maybe we just need a new acronym to more accurately describe the specific syntax of OOP when it was a concept that was exclusive to lower level language circles, because it sounds kind of silly to say you're not orienting yourself correctly when people are just trying to benefit from organizing their code around objects but might be veering a little from tradition. I hereby submit this new acronym, I hope it's not already taken: SJOCSOCPSAYBNVFTSMFOWHYSADALYAHTMLC, which you probably already guessed stands for Strict Java or C Style Object Conforming Programming Syntax and You Better Not Veer From This Sh*t Mother Fu*er or We'll Hunt Your Stupid As$ Down and Label You a Hyper Text Markup Language Coder. Not only would replacing the term Oriented with Conforming clear up a lot of confusion for people, but that acronym would just look so sweet on a resume. :) Adam. -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:44 AM To: CF-Talk Subject: RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea Just curious, OOP doesn't really apply to CF so why the OOP stuff? I have read all the crud where people say CFC's are like OOP but it just isn't true. Now OOP concepts may have been a better choice of words because that would imply the ability to understand the reasons why but not necessarily the implementation of such concepts. I suppose people could say that CFC's make you think about reuse but to be honest when I programmed in C (well before C++ caught on) I was using code reuse and nobody called it OOP. I had libraries built for all kinds of off the wall crud. But what do I knownot meant to diss the post just a thought I had as I glanced over it. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:18 AM To: CF-Talk Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area Cold Fusion Web Developer/Programmer Position - Kansas City Area Uhlig Communications, Inc., is an advanced-technology publishing company specializing in variable-data printing. We are offering an outstanding career opportunity for a Web Developer/Programmer
RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
Thath whath I callth nailingth ith hometh ;) -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:26 PM To: CF-Talk Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A rea It sounds like you are trying to describe Reusing Code by modularizing it, which yes, is an aspect of OOP but isn't the full thing. You can''t write object oriented code without an object oriented language. the makes sense doesnt it? Actually, no it doesn't make sense. Many people believe that C++ was the language that brought OO to the masses. Is C++ any OO language? Yes, but it wasn't in the beginning. When C++ was first introduced it was simply a preprocessor for C. The same OO way of building applications could have been done in C and in fact, some people actually use C in a way that is best described as OO. Remember folks, OOP is simply a way to structure your application. Some languages make it easy to structure your application in an OO manner by providing language constructs that map well, but that doesn't mean the language constructs are required. If I were an OOP programmer using Java and C++ and someone told me that other people could callthemselves OOP programmers simply because they can create objects with HTML. I'd be kinda mad. I don't know what you mean by objects in HTML, but ECMAScript can certainly be used for OOP and the DOM is a perfect example of an object. OOP is a fundamental concept of programming, but you can't program using OOP if you aren't using an OOP language. Simply not true. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea
If I were an OOP programmer using Java and C++ and someone told me that other people could callthemselves OOP programmers simply because they can create objects with HTML. I'd be kinda MAD. btw im not getting upset I see we now have to have an argument over the difference between mad and upset :) -Original Message- From: Tim Hanbey [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:53 PM To: CF-Talk Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A rea Right but it appears you are trying to divide and conquer and that just isn't going to work. Object Oriented programming is what it is... to go and take oriented out of it and try and attack it from that angle you are taking yourself away from the concept. its like takingJava Developer.and turning into someone who develops coffee. object oriented programming is what it is.there isn't any conforming needed. because they aren't objects. btw im not getting upset,i just have an opinion and am just expressing it and just because someone programs in Cold Fusion as oppose toC++ doesnt make them any less of a programmer/developer. As my experience atschool, C/C++ programmers are continuingto try and distinguish themselves from web developers, which is a whole new topic in itself and NOT what I am trying to do here. And the growing trend of web programming isn't real programming is,frankly,retarded. -tim Cantrell, Adam wrote: If god didn't intend for us to eat meat, then why would he have called it meat? :) Ok, so then we should call CFC's MOP then? Modular Oriented Programming? I can deal with that. Module/Object - ok I guess I'm just not that anal. My beef is with the 'oriented', you're description isn't 'oriented', it's 'conform to this definition or you're wrong, stop thinking of what the high-level purpose of this is'. I'll call it whatever people like though. It's like getting upset over developer or programmer. I call myself glorified secretary now so not to offend anyone. Adam. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OOP Definition - can we kill this thread please
No, you are wrong. This is not a continuous loop. In order to have a continuous loop you have to be using a language that supports loops. This is an email list, there are no loops here. -Original Message- From: Kevin Marino [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 3:54 PM To: CF-Talk Subject: RE: OOP Definition - can we kill this thread please Moderator, help we are in a continous loop with no end in site. :) Kevin PS. I declare everyone a winner, so unless you are competing for someones job on this list then it really doesn't matter what you think OOP is or is not. If your belief works for you, great. FIN [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Try parameterizing your form.issuenumber variable:
Update IssueRegister
SET IssueStatus = '#form.IssueStatus#',
Response = '#form.Response#',
ResponseUserId = '#session.activeuser.USER_NAME#',
DateofResponse = #CreateODBCdate(now())#
Where IssueNumber = cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#form.issuenumber#
If that wasn't the issue, you should use it anyway :)
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 10:54 AM
To: CF-Talk
Subject: SQL Help
Hello All,
I am having problems with an update statement that used to work fine in
Access with CFMX.I have an issue tracking app that used to have the issue
numbers stored as TEXT, I converted the column to Number a little while ago
and it worked fine.Recently users have been having problems updating the
records.
My update statement is pretty simple
Update IssueRegister
SET IssueStatus = '#form.IssueStatus#',
Response = '#form.Response#',
ResponseUserId = '#session.activeuser.USER_NAME#',
DateofResponse = #CreateODBCdate(now())#
Where IssueNumber = #form.issuenumber#
The error that I get from CF is
The search key was not found in any record.
But if I look in the error window it show my statment as follows
Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed',
ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where
IssueNumber = 1110
This look correct to me.So I tried running it in access's query window and
I get the same error, yet when I try to search the column for issuenumber
1110 Access finds it through its own search utility.
This has me stumped.Any ideas anyone.
Thanks
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: updating with a sub query
Would this work? UPDATE products SET products.dprice = dealerprice.price WHERE products.code = dealerprice.code -Original Message- From: Jim T [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 2:56 PM To: CF-Talk Subject: updating with a sub query cfquery name=getcodes datasource=giftovationmdb Select Distinct(code) from dealerprice /cfquery cfloop query=getcodes cfquery name=updatepricing datasource=giftovationmdb update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') where code = '#getcodes.code#' /cfquery ok/cfloop the above code gets this error not sure why any help would be appreciated. Operation must use an updateable query. The Error Occurred in C:\Inetpub\wwwroot\tools\pricingupdate.cfm: line 10 8 : update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') 9 : where code = '#getcodes.code#' 10 : /cfquery 11 :ok/cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isXMLDOC
You probably need the XML declaration: ?xml version=1.0 encoding=UTF-8? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:14 AM To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Question
UPDATE TopStudents SET studentdetails = left(studentdetails, length(studentdetails) - 12) WHERE 0 = 0 change the left and length functions according to your DB semantics. -Original Message- From: Srimanta B [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:54 PM To: CF-Talk Subject: SQL Question Hello, Can someone please help me. I wish to delete part of a text in student field keeping part of the text in the same field intact. Database: Access. Table name is: TopStudents The field names are: studentid, studentdetails, percentage, grade. The contents of the rows in the studentdetails field are similar to this: Student Name1 - Year 1950 Student Name2 - Year 1953 Student Name3 - Year 1953 Student Name4 - Year 1953 Student Name5 - Year 1954 I have about 500 rows of data in the table. What I wish to do is to keep the student names in the rows intact and delete everything on the righthand side from the -. Any help would be much appreciated. Regards SB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to add attribute to element in xml object?
I honestly don't know whether this will work in CF or not, but have you tried: xmlPeople.xmlRoot.xmlChildren[1].xmlAttributes.personid = 34442 that's the way they be doin it over in actionscript. -Original Message- From: Avi Flax [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 2:09 PM To: CF-Talk Subject: How to add attribute to element in xml object? Quick question: once I've parsed an xml document, I know I can add elements to any other element using the function xmlElemNew() - but I can't find a way to do that programatically. Example: someone passes to my code: people person name=Avi Flax heightfeet=6 heightinches=5 haircolor=brown/ /people and I want to return: people person name=Avi Flax heightfeet=6 heightinches=5 haircolor=brown personid=34442/ /people so that the calling app/module can match up the id returned to the record that was sent. I figure it'd be easier if I could just add my attribute in and pass the xml packet back, without having to rebuild the whole xml doc. I tried structInsert() but that didn't seem to work: StructInsert(xmlPeople.xmlRoot.xmlChildren[1].xmlAttributes, personid, 34442); no dice. Any ideas? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Question
Looking at this as it comes back to me I realized this will only work if all the students in your table graduated in the 11th century or later. Watch out for that one ;) Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Question UPDATE TopStudents SET studentdetails = left(studentdetails, length(studentdetails) - 12) WHERE 0 = 0 change the left and length functions according to your DB semantics. -Original Message- From: Srimanta B [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:54 PM To: CF-Talk Subject: SQL Question Hello, Can someone please help me. I wish to delete part of a text in student field keeping part of the text in the same field intact. Database: Access. Table name is: TopStudents The field names are: studentid, studentdetails, percentage, grade. The contents of the rows in the studentdetails field are similar to this: Student Name1 - Year 1950 Student Name2 - Year 1953 Student Name3 - Year 1953 Student Name4 - Year 1953 Student Name5 - Year 1954 I have about 500 rows of data in the table. What I wish to do is to keep the student names in the rows intact and delete everything on the righthand side from the -. Any help would be much appreciated. Regards SB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
posting XML to CF - escape characters?
I'm generating an XML document in Flash and using xml.send() to pass it to ColdFusion to be saved to the server's file system. In flash I have a form that the user fills out, and that information is used to populate the XML object. When I trace the finished XML object in Flash it shows that apostrophes are being escaped properly with apos;So if a user enters into one of the fields: Adam's Input Text - it traces as Adamapos;s Input Text (I hope the escaped characters stay escaped in this email). In coldfusion I use GetHttpRequestData().content to access the XML in the POST data. This works fine if all of the attributes in the XML have only one escaped apostrophe in them. It breaks when there are two or more apostrophes though. So if I had Adamapos;s and Jenapos;s Input Text as one of the attributes in an XML element, ColdFusion returns this error - this is just from trying to output GetHttpRequestData().content with nothing else on the page: java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseQueryString(FormScope.java:267) at coldfusion.filter.FormScope.parsePostData(FormScope.java:239) at coldfusion.filter.FormScope.fillForm(FormScope.java:190) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:345 ) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Does anyone know what I should look for? I'm having a hard time telling if this is a flash or a CF thing. Adam. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HTML a title help
Ditto on what Bryan said :) I don't have the exact script you could use, but I wouldn't doubt that irt.org has what you're looking for. The CF section is pretty weak (they still link to allaire for documentation), but take a look at the DHTML, _javascript_, and HTML FAQ's - it's a nice resource to bookmark. Adam. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 2:43 PM To: CF-Talk Subject: Re: HTML a title help Do some _javascript_ searches for things like Link Tips Link Descriptions. You're looking at a _javascript_/DHTML solution.You can make super nice looking link descriptionsbasically a mini web page to display whatever you want about a link. I've used this approach in many business reporting apps where screen real estate is at a premium and a little heads up on what's behind a link saves the user a tonne of time ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dwayne Cole To: CF-Talk Sent: Monday, November 17, 2003 12:38 PM Subject: HTML a title help Currently I'm using the title attribute to show a message that suggest what's behind a link. Some times the message contains as many as 100 words. The problem i'm having is that the text is only visible for about 5 seconds. I need for it to remain visible until the mouse roles away. Any suggestions? Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Simple question...
How about listDeleteAt? listDeleteAt(ipAddress, 4 , .) -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:30 AM To: CF-Talk Subject: Simple question... Regardless of an IP address's size (i.e. 10.1.2.3 or 204.225.123.234), what would be the easiest wat to get the first three banks of numbers? I'm trying to avoid a bunch of ListGetAt statements and then building a variable from them on the fly. Would SpanExcluding/SpanIncluding do the trick? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137512 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Linux Shells for Rent?
What do you need it for? here's a free one - http://freeshell.org/ then there's cygwin, which you can run on windows - http://www.cygwin.com/ Adam. -Original Message- From: Oliver Cookson [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 5:02 AM To: CF-Talk Subject: OT: Linux Shells for Rent? Hi, I was wondering if anyone could recommend any sites which offer Linux shells for rent? Access would be prefered as SSH and root isn't required. Thanks in advance. Oliver. :) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Somewhat OT: ER diagramming tools?
I asked this question on the community list a couple weeks ago - I bookmarked the thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=923 8forumid=5 Since then I've been using XTG's data modeller: http://www.xtgsystems.com/ Adam. -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 9:47 AM To: CF-Talk Subject: Somewhat OT: ER diagramming tools? What do youse guys use to do ER diagrams? I'm in need of some diagramming tools, as we're working with more and more people in our process now and feel the need to put down our diagrams and relationships in more concrete form. I'm looking for shareware or freeware diagramming tools that can do very basic things. I'm not looking for anything fancy...yet. I just need to be able to visually display tables and relationships and maybe just output it as a bmp or jpeg file for group consumption. Does anything jump out at anyone? I appreciate the help. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Braindead stripping question
right(myVar, len(myVar) - 2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 10:59 AM To: CF-Talk Subject: Braindead stripping question Mustgetmorecoffee... I have a variable passed, ie SG101 or SG 1004 I have to strip the first two characters as those are always constant. So I can't use right() since the numerical portions after the reliable two characters may fluctuate in terms of number of characters...what is best function to accomplish? TIA. Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF or .DotNet what do you think?
Yes and no... maybe. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 3:19 PM To: CF-Talk Subject: CF or .DotNet what do you think? A while back I had posed a question about CF vs .DotNet. Well the discussion here is picking up again and want to go to the mat for CF. I know, like it, and have built several apps and sites. I have 4 VB developers on staff with limited ASP and web development. They of course will probably lean towards .DotNET. One who has more ASP experience had to let me know that a real developer would use ASP and that CF is for non-developers. Another basically said CF can not provide the robustness needed for a full blown App. Well I am asking for this boards feedback on the matter. Your pros and cons would be much appreciated for my presentation. Eric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Interface Design
http://oswd.org/ Open Source Web Design. I've never used one of the layouts from this site, but it might be good for one of those I want a website for $50 clients. Adam. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 6:41 AM To: CF-Talk Subject: Interface Design Would anyone know of any websites where I can get some ideas for interface designs? I've been designing many of my interfaces so that they're quick to load, and very simple...although I'd like to improve upon this w/ some more graphical approaches that sort of stuff...although, I really don't know where to go w/ it. So, any samples, ideas, etc. would be appreciated. Thanks! Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ / http://scott.sllboces.org/ http://scott.sllboces.org (digital desktop) [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: local/ftp sync
Shouldn't be hard to write. Use cfftp to list the contents of your remote directory. Use cfdirectory to list the contents of your local directory. Convert the local directory results to a list. Loop through the remote directory listing, checking to see if listfindnocase returns false on your local list of filenames - if it does then cfftp GETFILE on that one and continue onto the next one. Adam. -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 2:14 PM To: CF-Talk Subject: local/ftp sync I need to keep a local directory in sync with a directory on an ftp server. As the files are rather large I don't want to download the whole thing every night, just the new ones, and delete old files on the local directory that are not on the ftp. Just wondering if anyone has written anything similar Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Think you are a SQL GURU? Try figuring this one out.
If every record follows the convention you described, this could work: cfquery name=getNames datasource=oldDatasource SELECT ID, NAME FROM oldTable WHERE 0 = 0 /cfquery cfloop query=getNames cfquery name=insertNewRecord datasource=newDatasource UPDATE newTable SET firstName = '#listgetat(getNames.name, listlen(basky.name) - 1, )#', lastName = '#listgetat(getNames.name, listlen(basky.name) - 2, )#' WHERE ID = #basky.ID# /cfquery /cfloop And you could probably do all of that in one SQL statement, but since it's only ran once :| Adam. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 3:13 PM To: CF-Talk Subject: OT: Think you are a SQL GURU? Try figuring this one out. Here is the challenge. Have a table with a column called NAME and the column contains both names of businesses and individuals. Business names are stored as is , example ABC Company. Individuals are stored as last name first name middle initial, example Public John Q. I need to get this information into another table where the biz name can be stored in the first name field no problem but I need to parse and individuals name so I can put the individual's first name in the first name column and their last name in the last name column. Figure it out and I will send you a prize. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Think you are a SQL GURU? Try figuring this one out.
ooops - replace 'basky' with 'getNames' basky is my personal 'foo' and it slips out in public here and there. surry. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 3:34 PM To: CF-Talk Subject: RE: Think you are a SQL GURU? Try figuring this one out. If every record follows the convention you described, this could work: cfquery name=getNames datasource=oldDatasource SELECT ID, NAME FROM oldTable WHERE 0 = 0 /cfquery cfloop query=getNames cfquery name=insertNewRecord datasource=newDatasource UPDATE newTable SET firstName = '#listgetat(getNames.name, listlen(basky.name) - 1, )#', lastName = '#listgetat(getNames.name, listlen(basky.name) - 2, )#' WHERE ID = #basky.ID# /cfquery /cfloop And you could probably do all of that in one SQL statement, but since it's only ran once :| Adam. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 3:13 PM To: CF-Talk Subject: OT: Think you are a SQL GURU? Try figuring this one out. Here is the challenge. Have a table with a column called NAME and the column contains both names of businesses and individuals. Business names are stored as is , example ABC Company. Individuals are stored as last name first name middle initial, example Public John Q. I need to get this information into another table where the biz name can be stored in the first name field no problem but I need to parse and individuals name so I can put the individual's first name in the first name column and their last name in the last name column. Figure it out and I will send you a prize. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password Validating
cfif (REFind([[:alpha:]],myString)) AND (len(myString) GTE 8) Adam. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:37 PM To: CF-Talk Subject: Password Validating I need to validate a password field, to ensure that it contains at least 8 characters and at least 1 non-alphabet character. Does anybody have something handy that will help me with this? Should I use CF/RegEx or Javascript? Thanks! -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password Validating
Sorry about that - you need a caret for at least one NON alpha - cfif (REFind([^[:alpha:]],myString)) AND (len(myString) GTE 8) Adam. -Original Message- From: Cantrell, Adam Sent: Tuesday, July 08, 2003 3:48 PM To: '[EMAIL PROTECTED]' Subject: RE: Password Validating cfif (REFind([[:alpha:]],myString)) AND (len(myString) GTE 8) Adam. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:37 PM To: CF-Talk Subject: Password Validating I need to validate a password field, to ensure that it contains at least 8 characters and at least 1 non-alphabet character. Does anybody have something handy that will help me with this? Should I use CF/RegEx or Javascript? Thanks! -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Beta Testing RedSky
Good thing you have plenty of non-paid volunteers that for some reason enjoy enforcing legal contracts for you - makes your job easy. Adam. -Original Message- From: Mike Chambers [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:46 AM To: CF-Talk Subject: Re: Beta Testing RedSky The NDA prohibits any discussion of the beta. mike chambers [EMAIL PROTECTED] - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 07, 2003 11:42 AM Subject: RE: Beta Testing RedSky I don't recall the NDA prohibiting the mentioning of the phase of the beta. I'll have to go back and re-read it ;) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 8:28 AM To: CF-Talk Subject: RE: Beta Testing RedSky This information should not be posted here (I know RedSky is common knowledge but the status of the Beta should not be openly discussed). ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Management System
I'd put forth that content management consists not only of those three elements as MS, but also the integration of a pecking order of people in control of publishing rights and strict rules enforcing what is and is not published based on the input of all necessary parties. I've also heard this referred to as a Workflow Management System - the process by which content is drafted, edited, revised, and published by different parties. Adam. -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 2:45 PM To: CF-Talk Subject: Re: Content Management System I'd put forth that content management consists not only of those three elements as MS, but also the integration of a pecking order of people in control of publishing rights and strict rules enforcing what is and is not published based on the input of all necessary parties. Other than that, as long as you take that function and wrap it in the definition of Publishing that MS attributes in their definition, it sounds about right. - Jim Chunshen (Don) Li wrote: I hope this is not OT. I'd like to get a better understanding of the definition of CMS. According to Microsoft, it seems that the core functions of CMS should over Content Creation, Publishing and Storage. Is there a general agreement on this? Or am I missing something big here? Secondly, personally I think the publishing part is a very tough task considering the fact that most design seem to change a lot over some time span for Intranet, Extranet or Internet, so, the integration of publishing and (future) design would be a huge challenge. Li, Chunshen (Don) http://68.32.61.40/datadata/dataman.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Management System
Make any sense? Nope. Adam. -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 3:43 PM To: CF-Talk Subject: Content Management System How interesting! This guy is sometime called Don Li, some other time called Li, and yet some other time called Li, Chunshen, and yet, they all refer to the same guy. I guess, the core is some unique(take the word as it is pls) attributes (I hope the word is neutral) that differentiates this guy from another one. Same may be said for CMS, WMS, at the core is Data Management, the difference(s) may lie in the different perspective and focus. Make any sense? Li, Chunshen (Don) http://68.32.61.40/datadata/dataman.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Management System
Coherence to start, but maybe we shall move this offlist where we can philosophically analyze the analogies between people's names and the components that make up CMS's without disturbing others :) Adam. -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 4:05 PM To: CF-Talk Subject: Content Management System So, what makes sense to you? LOL. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Fairly Difficult SQL problem
What I need to retreive is all the drives for a given month (June for example) plus the number of days it has been since any previous drive for a given Sponsor. Does it need to be in the same query - I might treat that as two separate queries - one to retrieve all drives for the given month. - one to retrieve the most recent drive (drives less than today's date) for each individual sponsor. Convert the second query into something you can reference by sponsorID - like an array whose keys are sponsorID's. Then as you're looping through your first query you can just reference the array to output the number of days since the last drive for that given sponsor. Something like - cfloop query=qryDrives datediff(d,now(),arrayRecentDrive[qryDrives.sponsorID]) /cfloop Adam. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 9:53 AM To: CF-Talk Subject: Fairly Difficult SQL problem Trying this on the more active CF-Talk list. ... I have tables something like the following data structures. Sponsor ID Sponsor ... 1 Foo 2 Bar 3 Clyde 4 New Sponsor Drives ID SponsorID Date ... 1 1 4/15/03 2 2 4/18/03 3 3 4/24/03 4 2 5/9/03 5 1 5/16/03 6 3 6/3/03 7 2 6/11/03 8 1 6/15/03 9 4 6/18/03 What I need to retreive is all the drives for a given month (June for example) plus the number of days it has been since any previous drive for a given Sponsor. RecordSet Sponsor.ID Sponsor Drives.ID SponsorID Date DaysSinceLastDrive ... 3 Clyde 6 3 6/3/03 40 2 Bar 7 2 6/11/03 33 1 Foo 8 1 6/15/03 30 4 New Sponsor 9 4 6/18/03 N/A Any suggestions on how I could do this in SQL so I don't have to something unpleasant like looping over one query result, running another query each iteration. If it matters this is ColdFusion MX, no updates querying a Oracle 9i database. Thank You -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Flash (crazy idea?)
When you subscribed to this list did you see a sign on the front of it that said stupid ***%% jokes email list? You know why you didn't see that sign? Cause it ain't there, cause stupid **%%# jokes ain't this lists %$#%$% business, that's why. ;) Adam. -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:39 AM To: CF-Talk Subject: Re: CF Flash (crazy idea?) Vincent: You know what they call a programming methodology at Macromedia? Jules: They don't call it a programming methodology? Vincent: No, they got a marketing department, they don't know what the @$! a programming methodology is. Jules: Then what do they call it? Vincent: A Royale Initiative Jules: Royale Initiative! What do they call Flash Remoting? Vincent: Flash Remoting's Flash Remoting, but they call it Le Flash Remoting. Jules: Le Flash Remoting... hahaha. What do they call VML? Vincent: Dunno, they don't use it. Ok, ok, sorry - it's almost a holiday and I'm not focusing really well :) - Jim Benoit Hediard wrote: It shoud be possible to do that with FlashMX/FlashRemotingMX/ColdFusionMX. You have all the required features in FlashMX : dragdrop, pixel coordinates, remoting to generate the HTML form with ColdFusionMX... But you'll need a really good ActionScript developer to do the Flash UI... It might be better to wait for Royale, http://www.macromedia.com/special/royale/ (even if it seems to be designed for the contrary : to easily generate Flash forms from XML files, and not HTML forms from Flash UI...). I agree with Bryan, why not using a flash Form instead of an HTML form? Benoit Hediard www.benorama.com -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Envoye : jeudi 3 juillet 2003 17:04 A : CF-Talk Objet : RE: CF Flash (crazy idea?) Dude, I have thought of the same and if you or anycan come up with an idea solution...please post it. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 15:59 To: CF-Talk Subject: CF Flash (crazy idea?) Hi everyone. I have an idea and need to know if it is within the capabilities of Flash and CF. What I would like to do is provide an interface for users to come to, where they can create forms and position the form elements and element labels wherever they wish (within a maximum area). How I envision this working would be to provide within the interface an area that contained a list of possible form elements to choose from (text input, text area, radio, check). When a user dragged one of these into the form area they could give it a label and fill in the attributes of that element as well as position the element and its label wherever they wanted (within the bounds of course). Now for the crazy part... Would it be possible to take that Flash movie that the user interacted with to create the initial form and process it into an HTML form where the layout was almost identical if not exactly identical to how it was created via the Flash interface (from a positioning and layout standpoint)? I was thinking maybe there are some functions in flash to get element coordinates, etc... The idea would be that this form could be used within an HTML email or website to gather user feedback. The second part would be to build some kind of container on the backend whereas those results/responses could be stored. Obviously this is a complex idea, one in which is beyond the scope of my abilities at this time. Anyone have thoughts, ideas, technologies to look at, etc... ? Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
treating queries as structures/array
Instead of me pasting code and trying to explain problem - could somebody give me the breakdown on treating query objects as structures/arrays one more time - like referring to records and columns using array notation, etc. There has to be an online resource that goes over this. I'll write it down on my forehead this time. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: treating queries as structures/array
Nevermind - the last few paragraphs of this helped me out - http://www.sys-con.com/cfdocs/Developing_ColdFusion_MX_Applications_with_CFM L/Variables4.html (I know that's from the docs, but it took a search for me to find it - hence the domain) Adam. -Original Message- From: Cantrell, Adam Sent: Thursday, June 26, 2003 3:11 PM To: '[EMAIL PROTECTED]' Subject: treating queries as structures/array Instead of me pasting code and trying to explain problem - could somebody give me the breakdown on treating query objects as structures/arrays one more time - like referring to records and columns using array notation, etc. There has to be an online resource that goes over this. I'll write it down on my forehead this time. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: treating queries as structures/array
hmmm - but it still strikes me as odd that: isArray(queryName[columnName]) returns: NO Yet: arraytolist(queryName[columnName]) returns the list of values from that query column. You'd think if it was returning false on the array check, that it would error out on the conversion to a list. What am I missing? Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:11 PM To: CF-Talk Subject: treating queries as structures/array Instead of me pasting code and trying to explain problem - could somebody give me the breakdown on treating query objects as structures/arrays one more time - like referring to records and columns using array notation, etc. There has to be an online resource that goes over this. I'll write it down on my forehead this time. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFTP Question
Yep - cfftp action=open connection=myConnection ... cfloop ... cfftp action=putfile connection=myConnection ... /cfloop cfftp action=close connection=myConnection Adam. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 1:29 PM To: CF-Talk Subject: CFFTP Question I need to FTP 100 images and hate the idea of sending them individually. Is it possible to send multiple files using CFFTP per session? Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Drop User in SQL Server
You will probably want to change the object owner for each table to the dbo user. You do this using the sp_changeobjectowner stored procedure on each table - either in query analyzer, or a script you've written. I've pasted the books online entry for this - I have it book marked :) Adam. sp_changeobjectowner Changes the owner of an object in the current database. Syntax sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner' Arguments [EMAIL PROTECTED] =] 'object' Is the name of an existing table, view, or stored procedure in the current database. object is nvarchar(517), with no default. object can be qualified with the existing object owner, in the form existing_owner.object. [EMAIL PROTECTED] =] 'owner' Is the name of the security account that will be the new owner of the object. owner is sysname, with no default. owner must be a valid MicrosoftR SQL ServerT user or role, or Microsoft Windows NTR user or group in the current database. When specifying Windows NT users or groups, specify the name the Windows NT user or group is known by in the database (added using sp_grantdbaccess). Return Code Values 0 (success) or 1 (failure) Remarks The owner of an object (or the members of the group or role owning the object) has special permissions for the object. Object owners can execute any of the Transact-SQL statements related to the object (for example, INSERT, UPDATE, DELETE, SELECT, or EXECUTE) and can also manage the permissions for the object. Use sp_changeobjectowner to change the owner of an object if the security account that owns the object has to be dropped but the object must be retained. This procedure removes all existing permissions from the object. You will need to reapply any permissions you want to keep after running sp_changeobjectowner. For this reason, it is recommended that you script out existing permissions before running sp_changeobjectowner. Once ownership of the object has been changed, you may use the script to reapply permissions. You will need to modify the object owner in the permissions script before running. For more information about database scripting, see Documenting and Scripting Databases. Use sp_changedbowner to change the owner of a database. Permissions Only members of sysadmin fixed server role, the db_owner fixed database role, or a member of both the db_ddladmin and db_securityadmin fixed database roles can execute sp_changeobjectowner. Examples This example changes the owner of the authors table to Corporate\GeorgeW. EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW' -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:40 AM To: CF-Talk Subject: Drop User in SQL Server This may be better posted on a SQL board, but I know there are a lot of SQL Server gurus out there and I need your help! A client's web host just had to reinstall SQL Server 2000, and I am having a hard time getting a former user name to work properly, or setup a new user name. If I setup a new user name, the datasource appears to work fine in CF 5 admin. Then when I try a page I get a message: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'grpdes'. When I log into RDS in CF Studio the old user name shows up in the datasource; for example: BandD.grpdes (BandD is the old user name.) I've tried to delete the user name, but it will not remove itself from the Public role. If I try and recreate the user name I get the message: Error 15023: User or role 'BandD' already exists in the current database. I've tried to detach the database, create the user (temporally attaching the user name to another database), re-attach the database and assign the user name to the database, but I get the Error 15023 ... Any ideas would be greatly appreciated! Thank you, Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Homesite+ VSS working folder
Does anyone know how I can change the working directory in Homesite+ When I go to Map Project to Source Control I select the VSS database, and then it asks to set a working directory and select the VSS project. I can see the working directory but it's grayed out and I can't change it. I'd like to set it to check files out to my personal development webroot like how I have it set up using the VSS client. Is there a registry entry or anything? Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Homesite+ VSS working folder
Nevermind - I recreated the Homesite Project using my personal development webroot as the project folder, then mapped to source control - it now checks files out where I want them. Working great now. Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 3:25 PM To: CF-Talk Subject: OT: Homesite+ VSS working folder Does anyone know how I can change the working directory in Homesite+ When I go to Map Project to Source Control I select the VSS database, and then it asks to set a working directory and select the VSS project. I can see the working directory but it's grayed out and I can't change it. I'd like to set it to check files out to my personal development webroot like how I have it set up using the VSS client. Is there a registry entry or anything? Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Red Sky beta 2 released
It seems that some people confuse private beta's with some type of elitist recognition, and then feel the need to let everyone know about it. I used to get a bit irked when 'neo' was under development, and people that didn't even work at mm would gnash their teeth at others for even bringing up the word 'neo', but then realized all they want is to let everyone know they're part of the beta. Knowing this, I don't get as confused - I just wish there was another way they could be recognized without having to call people idiots. Maybe mm could make a private beta testers web page, and then the NDA police could link to it in their sig or something - Private RedSky Beta Tester - Gold Status www.macromedia.com/elitiny If they really cared about keeping the beta private, they would email the person directly and then tattle to MM. I doubt any of them do this - better to go for the personal recognition ;P Adam. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:28 PM To: CF-Talk Subject: Re: Red Sky beta 2 released OK...why doesn't everybody call the mothers of the folks that said Red Sky on this list and get it over withmabye they'll get their mouths washed out with soap. ;-) We all bloody well know what NDAs are...it's up to MM to enforce them...not the members of this list. Far more than enough said...come on list police...swing that billy club!! Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 11:14 AM Subject: RE: Red Sky beta 2 released Also, Just because MM talks about it, that doesn't mean you are still not under NDA. The NDA is there to protect MM, the products, and the consumers. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:58 PM To: CF-Talk Subject: RE: Red Sky beta 2 released nicely put thanks for not calling people idiots. Anyone who agrees to a NDA, then violates it without a second thought is just wishing for problems They put the NDA there for a reason - because the information is for NON DISCLOSURE! Admittedly using the word idiot is a little strong, but if Macromedia ban people from future Betas when they flagrantly broke the NDA, then they deserve all they get, and no amount of moaning will help them... I have strong feelings about NDAs, and if you break them, then you deserve all you get - I have been on MANY Betas where I had to sign an NDA, and have never broken one - if you feel the need to break NDAs, then you shouldn't agree to them, simple as that That's my $0.02 anyways ;) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity Indexing and Searching
Rick, here's what I run on my search input before submitting it to cfsearch. There may be an attribute in cfsearch that does this automatically, but I wasn't sure of what it was. cfif NOT (findnocase( AND ,attributes.criteria) OR findnocase( OR ,attributes.criteria)) cfset variables.searchCriteria = ListChangeDelims(attributes.searchCriteria, AND , ) /cfif cfsearch name = searchResults collection = dbContent,fileContent criteria = #lcase(variables.searchCriteria)# Adam. -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 8:20 AM To: CF-Talk Subject: Verity Indexing and Searching I have created a Verity (SQL Data) that I index once a day separate from the search. Then on the website I run the CFSEARCH tag against it but it doesn't search out all keywords. If I search for Blue I get back anything with Blue in it. If I search for Blue Ear I get back anything with Blue Ear but not My ear is blue I thought Verity was supposed to return results in that matter by relevance? This is the search tag on the search page. cfsearch collection=BE_SearchAll criteria=#criteria# name=SearchResults type=EXPLICIT I also tried Simple. !--- The file that runs daily is: --- cfquery datasource=BlueNew name=QryGetNewPost SELECT ListMessages.MessageGUID, ListMessages.EntryDate, ListMessages.Subject, ListMessages.Body, ListMessages.MemberID FROM ListMessages WHERE (Blocked = 0 AND Hold = 0) /cfquery cfindex query=QryGetNewPost action=UPDATE key=MessageGUID collection=BE_SearchAll title=Subject type=CUSTOM body=Subject,Body custom1=EntryDate custom2=MemberID Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLXML
John, cool stuff indeed. Do you have the SOAP toolkit 2.0 or 3.0 installed on the server? Does it matter? Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 7:38 PM To: CF-Talk Subject: SQLXML Just a quick note for anyone who hasn't gotten a chance to play with MSSQL SQLXML yet, here is snippet showing how to get SQL Server to return XML to CF. The MS SOAP Toolkit and SQLXML both need to be installed on the server before this will work. cfquery datasource=northwind name=xml SELECT Customers.CustomerID, Orders.OrderID, Customers.ContactName FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID FOR XML AUTO /cfquery cfset column = xml.columnList cfset xmlStr = '' cfloop from=1 to=#xml.recordCount# index=i cfset xmlStr = xmlStr xml[column][i] /cfloop root cfoutput#xmlStr#/cfoutput /root That's it...piece of cake. The only weird things are the name of the column that is returned by default is a bit odd, so I had to work around that, and multiple records are returned representing one xml document so they need to be concatenated. If anyone has any info on how to change that or why that is, I'm all ears. -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Program spec
Whatever you do, make sure you specify the color depth requirement ;P Adam. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 12:05 PM To: CF-Talk Subject: Program spec I need to make up a program spec, does anyone have one that they have made and would like to share so I can see how to make one. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLXML
Ahhh, I was going off of this page, which lists the SOAP toolkit as a requirement.: http://www.microsoft.com/downloads/details.aspx?FamilyId=4023DEEA-F179-45DE- B41D-84E4FF655A3Bdisplaylang=en I knew SQL2K came with some XML capabilities, but didn't know it was as extensive as this page makes it out to be: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn ol/sql/evaluate/featfunc/xmlsql.asp The comparison table to Oracle is interesting as well. Adam. -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:19 PM To: CF-Talk Subject: Re: SQLXML msSql2k does have built in XML capabilities. Just search from XML in the BOL. Eric - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:59 PM Subject: RE: SQLXML As far as I know you don't even need Soap, At least with MS SQL2000. I believe it has a built in function that returns XML Shawn Regan -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:35 AM To: CF-Talk Subject: Re: SQLXML Shouldn't matter, the stuff I was reading was based off 2.0, but I installed 3.0 and it worked fine. -- jon mailto:[EMAIL PROTECTED] Monday, June 9, 2003, 2:06:27 PM, you wrote: CA John, cool stuff indeed. Do you have the SOAP toolkit 2.0 or 3.0 installed CA on the server? Does it matter? CA Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 7:38 PM To: CF-Talk Subject: SQLXML Just a quick note for anyone who hasn't gotten a chance to play with MSSQL SQLXML yet, here is snippet showing how to get SQL Server to return XML to CF. The MS SOAP Toolkit and SQLXML both need to be installed on the server before this will work. cfquery datasource=northwind name=xml SELECT Customers.CustomerID, Orders.OrderID, Customers.ContactName FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID FOR XML AUTO /cfquery cfset column = xml.columnList cfset xmlStr = '' cfloop from=1 to=#xml.recordCount# index=i cfset xmlStr = xmlStr xml[column][i] /cfloop root cfoutput#xmlStr#/cfoutput /root That's it...piece of cake. The only weird things are the name of the column that is returned by default is a bit odd, so I had to work around that, and multiple records are returned representing one xml document so they need to be concatenated. If anyone has any info on how to change that or why that is, I'm all ears. -- mailto:[EMAIL PROTECTED] CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL concat
I believe that's the ansi SQL-92 standard, but in MSSQL it's +. My problem was that the datatype was ntext, which it appears MSSQL doesn't allow you to concatenate. This is just based on my experience from yesterday, I wasn't able to verify in the documentation. I changed to varchar and it works fine. That particular field didn't need to be ntext, so for the sake of clarity I didn't go with casting to a different datatype. Thanks for the replies. Adam. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 4:19 AM To: CF-Talk Subject: Re: SQL concat On Wednesday 04 Jun 2003 18:13 pm, Cantrell, Adam wrote: What's the operator for string concatenation in SQL server - I'm trying: || isn't it ? -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: active edit alternaitves
Bow down to the wizzywig master list ;) http://www.bris.ac.uk/is/projects/cms/ttw/ttw.html ActiveEdit is cool though - well worth the money. Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 12:19 AM To: CF-Talk Subject: active edit alternaitves anyone have any recommendations for alternatives to active edit from cfdev.com? Thanks. Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: i will sell domain cftop.com
heh, cfmop.com would be a cool domain. You could offer services cleaning up other people's crappy CF code :) Adam. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:50 PM To: CF-Talk Subject: RE: i will sell domain cftop.com I could not help but I had to reply this one. $100,000. That's huge. I will sell cftopsucks.com for a fraction of cftop.com's price for $10 just for General Purposes! -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:32 PM To: CF-Talk Subject: i will sell domain cftop.com I dont know if this is allowed in cftalk, but it is related to coldfusion =) I had the domain cftop.com since 99... i guess, I bought it when i start coding many projects in cf. It was used mainly for e-mail proposes. Maybe some of you guys can make a better use of it. Domain name expires in june 14 (in 8 days) and i dont want to renew it. I'm asking usd 100,00 for it but i will sell for less if i do not get a good offer. If anyone is interested, drop me an e-mail [EMAIL PROTECTED] or ICQ: 198810. Thanks BP. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Very unsatisfied with Macromedia's support attention ...
Have you looked into colocation? That usually means you're in charge of the box and they don't care what you do with it - they log your bandwidth and bill you accordingly. You can then get management options where they'll bounce the server for you or whatever. Sounds like your headache isn't mm's fault, rather a lack of access to your server. Adam. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:53 PM To: CF-Talk Subject: RE: Very unsatisfied with Macromedia's support attention ... Thanks for the business advice Ken. Trust me there are issues to be resolved with the hosting company. No, I was not only interested in the price. Naturally price is a factor that goes into every business decision, including this one, but it wasn't the only one. Very few hosting companies will work with companies like mine where we have all the control over the clients, and where we can set up our own sites, and decide what the quotas are going to be and how many domains will go into each server etc. The vast majority of hosting companies want to deal direct with the site owners and only give people at my level a discount off their normal list prices. That means I have no control over the prices. Not interested in that. Anyway that's all water under the bridge. I went down that road at length. And this issue is NOT NOT NOT due to shortcuts on the hosting company's part. Updater 3 wouldn't install. I could have paid them a hundred times more per month and it still wouldn't have installed. It's easy to snicker away and say see, he tried to save money and now look at the pickle he's got himself into. But the install issues I have are nothing whatever to do with funding and everything to do with the temperamental nature of CFMX install routines. That's why they are bragging so much about fixing them in the Red Sky product. It seems to me that the released version of CFMX works rock solid if everything goes well. But if anything - even minor things - don't go well, the whole installation is a nightmare. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED] Sent: Saturday, 7 June 2003 6:43 AM To: CF-Talk Subject: RE: Very unsatisfied with Macromedia's support attention ... I had to find a hosting company with a business deal that worked with my business Does that, perchance, equate to being a cheap hosting company? And, if so, are you now getting exactly what you've paid for? MM has no control whatsoever over the installation conditions or technical competence of those who claim to be hosting providers. Perhaps your public anger is better directed at the hosting company rather than the one who sells a product that has proven itself (at least in other hands) to be quite capable. Ken ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL concat
What's the operator for string concatenation in SQL server - I'm trying: SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#' And that's throwing me an Invalid operator for data type error. Anyone help me out right quick? Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL concat
They're the same type of data - the column data type is ntext. I've even
tried this and still get Invalid operator for data type. Operator equals
add, type equals ntext:
SET txtColumnName1 = Cast(txtColumnName1 AS ntext) +
Cast('#form.txtFieldName1#' AS ntext)
Adam.
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 12:26 PM
To: CF-Talk
Subject: RE: SQL concat
Hi,
In a simple select query where the datatypes are the same you
can use this:
SELECT (au_lname + ', ' + au_fname) AS Name
FROM authors
ORDER BY au_lname ASC, au_fname ASC
If the datatypes are different you need to use cast:
SELECT 'The order date is ' + CAST(ord_date AS varchar(30))
as display_date
FROM sales
WHERE ord_num = 'A2976'
ORDER BY ord_num
You can also use Convert() instead of Cast()
Hope it helps,
Mario
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 18:14
To: CF-Talk
Subject: SQL concat
What's the operator for string concatenation in SQL server -
I'm trying:
SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#'
And that's throwing me an Invalid operator for data type error.
Anyone help me out right quick? Adam.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL concat
I've also tried:
txt_description = {fn CONCAT(txtColumnName1, '#form.txtFieldName1#')}
it gives a similar error. I guess you just can't concatenate to this data
type?
Adam.
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:09 PM
To: CF-Talk
Subject: RE: SQL concat
They're the same type of data - the column data type is
ntext. I've even
tried this and still get Invalid operator for data type.
Operator equals
add, type equals ntext:
SET txtColumnName1 = Cast(txtColumnName1 AS ntext) +
Cast('#form.txtFieldName1#' AS ntext)
Adam.
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 12:26 PM
To: CF-Talk
Subject: RE: SQL concat
Hi,
In a simple select query where the datatypes are the same you
can use this:
SELECT (au_lname + ', ' + au_fname) AS Name
FROM authors
ORDER BY au_lname ASC, au_fname ASC
If the datatypes are different you need to use cast:
SELECT 'The order date is ' + CAST(ord_date AS varchar(30))
as display_date
FROM sales
WHERE ord_num = 'A2976'
ORDER BY ord_num
You can also use Convert() instead of Cast()
Hope it helps,
Mario
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 18:14
To: CF-Talk
Subject: SQL concat
What's the operator for string concatenation in SQL server -
I'm trying:
SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#'
And that's throwing me an Invalid operator for data type error.
Anyone help me out right quick? Adam.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL concat
Yeh, that was it - I changed the datatype and now works fine. Thanks.
Adam.
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:24 PM
To: CF-Talk
Subject: RE: SQL concat
Adam,
Here is a piece of the SQL 7.0 Books Online documentation
about concatenation:
+ (String Concatenation) (T-SQL)
An operator in a string expression that concatenates two or
more character or binary strings, columns, or a combination
of strings and column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any valid Microsoft(r) SQL Server(tm) expression of any of
the data types in the character and binary data type
category, except the image, ntext, or text data types. Both
expressions must be of the same data type, or one expression
must be able to be implicitly converted to the data type of
the other expression.
It seems as though you cannot do it with a image, ntext or
text data type.
Mario
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 19:15
To: CF-Talk
Subject: RE: SQL concat
I've also tried:
txt_description = {fn CONCAT(txtColumnName1, '#form.txtFieldName1#')}
it gives a similar error. I guess you just can't concatenate
to this data
type?
Adam.
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:09 PM
To: CF-Talk
Subject: RE: SQL concat
They're the same type of data - the column data type is
ntext. I've even
tried this and still get Invalid operator for data type.
Operator equals
add, type equals ntext:
SET txtColumnName1 = Cast(txtColumnName1 AS ntext) +
Cast('#form.txtFieldName1#' AS ntext)
Adam.
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 12:26 PM
To: CF-Talk
Subject: RE: SQL concat
Hi,
In a simple select query where the datatypes are the same you
can use this:
SELECT (au_lname + ', ' + au_fname) AS Name
FROM authors
ORDER BY au_lname ASC, au_fname ASC
If the datatypes are different you need to use cast:
SELECT 'The order date is ' + CAST(ord_date AS varchar(30))
as display_date
FROM sales
WHERE ord_num = 'A2976'
ORDER BY ord_num
You can also use Convert() instead of Cast()
Hope it helps,
Mario
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 18:14
To: CF-Talk
Subject: SQL concat
What's the operator for string concatenation in SQL server -
I'm trying:
SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#'
And that's throwing me an Invalid operator for data type error.
Anyone help me out right quick? Adam.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Recommend a good, free web tracking software
Web tracking or raw log analyzer? If log analyzer: http://awstats.sourceforge.net/ Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: OT - Recommend a good, free web tracking software Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DevCon 2003
There's a war? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:07 PM To: CF-Talk Subject: Re: DevCon 2003 Yes on the UG Manager list someone asked today if a location had been nailed down yet. Well no answer yet and MM just cancelled a new event (due to the illegal war) they had been playing up bigtime the past 2 weeksso who knows what'll happen to DevCon :-| Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:51 AM Subject: RE: DevCon 2003 Goodness, this may change a lot. If it's still going to be in Sept., we only have 6 months to go (and one week to budget for it) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] I'm not 100% sure, but on the user group manager list I think it was mentioned that DevCon may be on the east coast (not a central loaction that would make sensebut that's a whole different rant). ;-) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Q_Range of dates
In SQL, look at the BETWEEN operator: SELECT * FROM dbo.PaP WHERE test_date BETWEEN #CreateODBCDate(startDate)# AND #CreateODBCdate(endDate)# ORDER BY #sort# ASC Adam. -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:17 AM To: CF-Talk Subject: Q_Range of dates I think I've got a handle on queries for output forms where they are passed a single month/year. However, what would a query for a range (such as JAN 2003 to MAR 2003 or JAN 2003 to DEC 2003) look like? Here's where I am. cfset startDate=CreateDate(Form.startYear, Form.startMonth, 1) cfset endDate=DateAdd (Form.endYear, Form.endMonth,1) cfquery name=qDateRange datasource=ds SELECT * FROM dbo.PaP WHERE test_date = #CreateODBCDate (startDate)# AND test_date #CreateODBCdate (endDate)# ORDER BY #sort# ASC /cfquery Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TSQL Script to replicate a db?
When exporting to the other database, instead of using: Copy tables and views from the source database try using: Copy objects and data between SQL Server databases Adam. -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 8:47 AM To: CF-Talk Subject: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go back and set up the autonumber fields on every single table which takes a long time. Does anyone know of a way to take my existing db and use a wizard to create either a stored procedure or a bunch of sql statements that will recreate all of the tables and relationships of my db? Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dreamweaver changing code on me
I've been gradually moving to DreamweaverMX as my web IDE... just because.
Today I was writing (hand coding) a form in code-view. I saved it to my web
server and tried running it - didn't work correctly. Looked at the HTML
source... WTF - what's all this garbage in here?
I opened the file up in CFstudio and it appears that dreamweaver took the
liberty of putting it's own tags in there. This is really bad for me... how
do I set dreamweaver to save ONLY the code I've written in code view. I need
to turn off its proprietary mark-up. Here's what it converted a simple xfa
variable into:
MM:BeginLock translatorClass=MM_COLDFUSION type=DynData depFiles=
orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT
SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION HILITECOLOR=Dyn
Untranslated
Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTENTMM:EndLock
Help!! Adam.
ps... the buttons in my toolbars are all greyed out... CFMLBasic, CFMLflow,
CFMLAdvanced, etc. Is there a reason for this?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver changing code on me
I was experiencing a known bug in the original version of DreamweaverMX. I
installed the latest updater - so-far-so-good.
My buttons in the toolbars are still all grayed out. Any idea on that one?
Adam.
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 12:29 PM
To: CF-Talk
Subject: Dreamweaver changing code on me
I've been gradually moving to DreamweaverMX as my web IDE...
just because.
Today I was writing (hand coding) a form in code-view. I
saved it to my web
server and tried running it - didn't work correctly. Looked
at the HTML
source... WTF - what's all this garbage in here?
I opened the file up in CFstudio and it appears that
dreamweaver took the
liberty of putting it's own tags in there. This is really bad
for me... how
do I set dreamweaver to save ONLY the code I've written in
code view. I need
to turn off its proprietary mark-up. Here's what it converted
a simple xfa
variable into:
MM:BeginLock translatorClass=MM_COLDFUSION type=DynData
depFiles=
orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT
SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION
HILITECOLOR=Dyn
Untranslated
Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTE
NTMM:EndLock
Help!! Adam.
ps... the buttons in my toolbars are all greyed out...
CFMLBasic, CFMLflow,
CFMLAdvanced, etc. Is there a reason for this?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver changing code on me
are you guys using anything like windowblinds? No, not here. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver changing code on me
Massimo, thanks for the reply. I have the updater now, and it seems to have fixed the overwriting code problem. Still have grayed out toolbar buttons (but it has forced me to start using the CFML code comment hotkey instead of the toolbar button - which I admit was a really wasteful habit. So this has been a temporary good thing.) I recognize your name from a few of the Dreamweaver articles I've read, glad to know we have a dreamweaver authority on the list :) Adam. -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:54 PM To: CF-Talk Subject: Re: Dreamweaver changing code on me I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? There are a few cases were DW can turn your code into garbage, only a limited amount of them are documented: http://www.macromedia.com/support/dreamweaver/ts/documents/tra nslator_code.h tm More in general DW still pretend to figure out the structure of an HTML file and it can go crazy whenever fundamental tags like body or head are totally dynamically created (as part of includes and the like) I also *strongly* suggest to update DW to 6.1, the updater actually solved a good amount of nasty bugs like the one above. After the update I am able to reproduce only a small subset of the bugs I knew, all of them are related to cfimport Massimo Foti Team Macromedia Volunteer for Dreamweaver Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.macromedia.com/go/team ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver changing code on me
Dave, I'll certainly let you know if I find a fix for the grayed out buttons - they're still gray. I agree that it's frustrating, but after reading some of the threads about Dreamweaver, I promised myself before going into this that I wouldn't get frustrated, and that I would try my hardest to avoid falling into the dreamweaver fscking sux attitude that seems prevalent with most people upgrading from CF Studio. It has taken a lot of self discussion, Adam, calm down, this is new software, it's going to behave differently... let's patiently work through this and things will make sense, but I've found out how easy it is to become frustrated quickly. I'm not quitting, I want to believe that Dreamweaver can make a good text editor!! One thing that's really frustrating is that it takes roughly 2 - 3 seconds for DW to load when using alt-tab to switch between a web browser. I would imagine that after adding this time up by day, then week, then year - it equates to a significant amount of time lost. Is there anything that can be done about this? My system specs are pretty high. Adam. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:54 PM To: CF-Talk Subject: RE: Dreamweaver changing code on me My buttons in the toolbars are still all grayed out. Any idea on that one? I posted a question on Friday concerning the same issue, but got no answer. The Dreamweaver forum has the question posted numerous times as well -- all with no answer. If you do find an answer, can you post it here or to me off-list? I'll do the same. It's very frustrating!! Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Auto-populating form item
Prepopulate a javascript structure with all of the possible initials you'll need from the database. Use that javascript structure as a pseudo database - call to it when your criteria is fulfilled from the other form fields. You could also build a flash widget (Rich Internet Application) to give the user the impression that there was no communication with the server. Although depending on how many initials you have in your database, you'd still probably want to store them in a local structure to give a snappy response. You don't want the user clicking on things, and not know why nothing is happening, or guessing around at what they have to do to continue on. Adam. -Original Message- From: Lincoln Milner [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 9:31 AM To: CF-Talk Subject: Auto-populating form item Folks, We've got this data entry form that allows entry, query, record deletion, and a host of other functionality. One thing it needs to do is after the first three form items are completed (it's a subject id.t number), the fourth auto-populates with the subject initials. This should be seamless to the user, i.e., no refresh of the page or submitting of data, so my question is how can we take form items 1, 2, and 3 and use them to dynamically call a query to retrieve the initials from a database? Or is this beyond the scope of CF? Cheers! Lincoln T. Milner Senior Application Programmer/Analyst Department of Health Evaluation Sciences Pennsylvania State University 600 Centerview Drive Suite 2200, A210 Hershey, PA 17033-0855 Ph: 717.531.7178 Fax: 717.531.5779 [EMAIL PROTECTED] *E-Mail Confidentiality Notice* This message (including any attachments) contains information intended for a specific individual(s) and purpose that may be privileged, confidential or otherwise protected from disclosure pursuant to applicable law. Any inappropriate use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalty. If you have received this transmission in error, please reply to the sender indicating this error and delete the transmission from your system immediately. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
running CF as different user/or use FTP
What are some of the known implications with starting CF as another user, if any? I need access to a file on another server for one very small component, and am trying to weigh the pros/cons of using either a network share, or going through FTP. If I understand correctly, in order to use a network share you have to start CF with an account that has the proper permissions on that share. This will be a file that needs to be updated fairly frequently: 10 - 50 times per day. What would you do? Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: running CF as different user/or use FTP
Dave, thanks for the article, and your help is always appreciated. I think I'll go with FTP on this one, but I'll look into running CF as a different user anyway for the mentioned security benefit. ps. the reason we need to update this file, and why it's on another server: We run a few mailing lists that we need to make private by turning off subscribe requests sent to them. The only way for registered users to subscribe/unsubscribe will then be through the 'account preferences' section after they're registered, approved, and logged into the site. Our mailing list software, on another server, reads a file when it needs to know its subscribed user base. This is the file I'll be overwriting through FTP. This also makes backing up the mailing list software's configuration easy, as I will be storing users' subscription information in the database as well. There's the concern that constantly overwriting this file may conflict with the mailing list software trying to constantly read from it, but our user base is relatively low, and the traffic on these mailing lists is even lower. Given that the two servers are on the same network, and that this file will never reach much more than a few k - the risk of this happening will be pretty low. Also, my figure of 10 - 50 updates to the file per day is highly inflated, it will realistically be around 0 - 5 times per day given how many new subscribe requests we can expect (the audience these lists serve is a finite number of people). Thanks again. Adam. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:00 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: running CF as different user/or use FTP What are some of the known implications with starting CF as another user, if any? I need access to a file on another server for one very small component, and am trying to weigh the pros/cons of using either a network share, or going through FTP. If I understand correctly, in order to use a network share you have to start CF with an account that has the proper permissions on that share. This will be a file that needs to be updated fairly frequently: 10 - 50 times per day. What would you do? Yes, to use a Windows Networking share, you'll need CF to run as a user which can see the share. To run CF as a different user, you'll need to make sure that the user account has permissions on all the right files and registry keys. There's a good writeup of this for CF 5 here: http://www.defusion.com/articles/index.cfm?ArticleID=89 It's actually quite a bit easier with CFMX, since there's no significant registry data - just ensure that the CFMX user account has rights to the \CFusionMX directory and your .cfm files, more or less. However, granting this user account rights to your network might be a security issue. That's really up to you to decide. I would probably go with FTP, if you just want to fetch a file from one server to another, as long as the server already had FTP on it. You could limit FTP access to only allow connections from the web/CF server, and you wouldn't have to grant any Windows networking rights to do this. You might want to reconsider the whole thing, though. Why does the file need to be on the second server in the first place? Why not move it to your web server, and fetch it from there when you need it via FTP or HTTP? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT Domain registration
gandi.net. -Original Message- From: samcfug [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:32 AM To: CF-Talk Subject: Re: OT Domain registration Does anyone have a recommendation for a domain registrar, other than Network Solutions any verisign affiliate or register.com? I need one that provides free DNS as well. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfloop/index question
I'm sure there's a creative way to avoid the evaluate() in this, somebody
else can share with us what way that might be, but here's one way of doing
it:
cfloop from=100 to=800 step=100 index=i
cfif (isDefined(form.service i)) AND (evaluate(form.service
i) IS on)
!--- do yo thang ---
/cfif
/cfloop
Adam.
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 11:14 AM
To: CF-Talk
Subject: cfloop/index question
I've got a form with a large list of services that a client
can click to get
more info. Depending on where they come from, the checkboxes
will auto-check
a particular service they're interested in, and then they can
check a few
more if they wish information on other services.
JAVASCRIPT CHECKBOX FUNCTION
function makeCheckboxes(){
STUFF.servicecfoutput#rq_SerID#/cfoutput.checked=true
}
On the form itself, each checkbox for each service is name like:
service100
service200
service300
This works together with the Javascript to check the
appropriate box based
on a passed URL variable. This part works great.
I'm having a bit of trouble on the processing side to get a
CFLOOP properly
set up to go through all the checkboxes and list the values
of the ones
checked.
Had this working in ASP:
I would like information on the following products. vbCrlf
REM ADD THE CHECKBOXES TO THE CDO EMAIL BODY
For i=10 to 720
if Request.Form(service i) THEN
vBody = vBody cStr(Request(service i)) vbCrLf
END IF
next
...but having some trouble translating this over to Cold Fusion...
Advice please...
Thanks
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need Help With Query
cfquery name=TheSearch datasource=TheDatabase SELECT * FROMTheTable WHERE TheTextField LIKE '%#SearchString#%' /cfquery And yes, you will want to 'encode' the variable inside a cfqueryparam tag, otherwise you'll wake up one morning with hacked by the chinese on your home page. Adam. -Original Message- From: Eric Homa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:50 PM To: CF-Talk Subject: Need Help With Query Hi, I have a query that I need to use to search a text field in a table. The text strings that are in the table in this field sometimes include a pound sign (#). Whenever I the query is run using a variable that includes a pound sign it returns no records. Here is an abbreviated example of my code. There are two templates. The first is a form: cfform action=Search.cfm method=Post cfinput type=text name=SearchString input type=submit /cfform The second page: cfquery name=TheSearch datasource=TheDatabase SELECT * FROMTheTable WHERE TheTextField = '#SearchString#' /cfquery Do I need to encode the variable somehow? Thanks, Eric Homa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT Hyper links without a
Could it be a DOM element with an onClick event wrapped around it? That could then change the document.href.location. Not sure if that's it or even possible - why don't you send the page in question? Adam. -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 4:14 PM To: CF-Talk Subject: OT Hyper links without a We have found hyper links in different web pages pointing to different external web sites. There is no a href around the link, but it's is there. There is a yellow line under the word or words and with a TOOL tip. For example on one of our bio's page of a board member the words (human resources) has a yellow line under the words that point to secure.monster.com just for example. David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SQL Question
Are you talking about a one time query to change the values stored in the DB? UPDATE tableName SET tableName.B = tableName.C, tableName.C = tableName.B WHERE tableName.A = tableName.A Adam. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:36 AM To: CF-Talk Subject: OT SQL Question Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
verity and PDF's
Has anyone ever had a PDF with 'selectable text' that verity will show as being indexed, but won't return in the results when searched for? When I say selectable text, I mean that I can open it up in acrobat reader, click on the text cursor button 'T', and then swipe blocks of text - there may be an official term for this. When I dump the results of a blank search, it's showing up but the summary field is blank. I'm assuming this has something to do with it? Is there anything special I should look for in the PDF that would prevent its text from being exposed to verity - I've got about 300 others that are working just fine. Any help would be appreciated. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Multiple Reference Tables Question
This may work, you'll want to look into using cfqueryparam around your passed variables to avoid SQL injection attacks. You will also want to play with the WHERE contraint to fit your needs - you may want records that match all criteria (AND) or you may want records that match any of them (OR) Use LEFT OUTER JOIN, if you want to pull records that don't necessarily have a reference. CFQUERY name=thinglist datasource=mydata SELECT tblThing.ThingKey, tblThing.ThingName, tblColor.ColorDescription, tblCategory.CatDescription, tblMaker.MakerName FROM tblThing LEFT JOIN tblColor ON tblThing.ColorKey = tblColor.ColorKey LEFT JOIN tblCategory ON tblThing.CatKey = tblCategory.CatKey LEFT JOIN tblMaker ON tblThing.MakerKey = tblMaker.MakerKey WHERE tblColor.ColorKey = #url.colorKey# AND tblCategory.CatKey = #url.catKey# AND tblMaker.MakerKey = #url.MakerKey# /CFQUERY Adam. -Original Message- From: James Brown [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:28 PM To: CF-Talk Subject: SQL Multiple Reference Tables Question This is probably basic, since I am new at this, but I want to know what is best. I have simplified the tables for illustration. I have one main table tblTHING ThingKey NameColorKeyCatKey MakerKey -- --- -- --- --- - 001 WinterSap 1 2 6 002 HorsePlay 1 4 5 003 HouseBarn 3 1 4 and three reference tables. The purpose of each is to supply a lookup value to the tblThing, the main table. The foreign keys in the reference tables have the same field name as the corresponding fields in the main table. tblCOLOR ColorKey ColorDescription -- -- 1 Blue 2 Yellow 3 Purple 4 Red tblCATEGORY CatKey CatDescription - 1 Animal 2 Activity 3 Human 4 Dwelling 5 Season 6 Biological Substance tblMAKER MakerKey MakerName 1 Mary 2 Joe 3 Willy 4 Mike 5 Roman 6 Jameson 7 Amanda I want a query that produces the following result: ThingKey Name ColorCategory Maker -- --- -- --- --- - 001 WinterSapBlue Activity Jameson 002 HorsePlay Blue Dwelling Roman 003 HouseBarn Purple Animal Mike The values in the Color, Category and Maker columns have, of course, been supplied from the reference tables. Which I CAN do with the following Query: CFQUERY name=thinglist datasource=mydata SELECT tblThing.ThingKey, tblThing.ThingName, tblColor.ColorDescription, tblCategory.CatDescription, tblMaker.MakerName FROM tblThing, tblColor, tblCategory, tblMaker WHERE tblColor.ColorKey = tblThing.ColorKey AND tblCategory.CatKey = tblThing.CatKey AND tblMaker.MakerKey = tblThing.MakerKey /CFQUERY = It seems like there should be a better way to structure the query, particularly if I want to supply a variable that will display ONLY the records where the maker, category, and Color (one, all or none) meet certain conditions. (i.e. list all the Red things made by Amanda) I have tried using a JOIN, which works very well if I Join only one reference table, but does not seem to work for more than one. Is there a way to relate the reference tables in the SELECT part of the query? Thanks for any help James Brown ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP versus CF Development Speed?
Dick. (Adam, sitting in dry, flat Chicgo) -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:50 PM To: CF-Talk Subject: RE: PHP versus CF Development Speed? let your mind run free my friend...outta here till Monday boys, snowboardin here I come!!! later ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:51 PM To: CF-Talk Subject: Re: PHP versus CF Development Speed? You mean up like awake or up like happy? And regardless I'm going to blame it on snorting ants, yes. :) is that why u guys are up all the time? Dave - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:31 PM Subject: RE: PHP versus CF Development Speed? Always plenty to go around. :) Who was it Ozzy who said he snorted a line of ants once? if you are, you better be sharing ;) ...tony -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:59 PM To: CF-Talk Subject: Re: PHP versus CF Development Speed? On Friday, February 28, 2003, at 06:21 AM, Will Swain wrote: It was a very very long line. :) w Well, then I can do it in a half a line, using APL ;^) Are we snorting lines of code now? :) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=2181 6 ~~~ ~~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Multiple Reference Tables Question
Because there are a number of ways of relating the information when dealing with it - having that flexibility is necessary. If you want cleaner CF code, create stored procedures or views that will offer exactly what you need. The reason you specify the relationships in the database are for a number of reasons, a couple are: - Enforcement of referential integrity. When I delete this color from the color table, I also want to make sure all references to that color ID are deleted. When you don't enforce referential integrity and you just leave empty references all over the place, you'll end up with what they call Delete/Update Anomalies - mess your application up big time. - Speed - the pri/foreign keys play a heavy role in the RDBMS's indexing and internal performance optimization. I'm sure there's more that are currently escaping me. Pick up Celko's 'SQL for Smarties' - improve your SQL by 100%. Adam. -Original Message- From: James Brown [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:15 PM To: CF-Talk Subject: Re: SQL Multiple Reference Tables Question Doesn't work, get the message: the correlation name NATURAL is specified multiple times in a FROM clause What I don't understand is - if the tables are structured in SQL Server as being related by those fields, why SQL server doesn't just know what the relationships are without my having to specify it. Much of my prior experience was with xBase and once tables were related to each other, all one had to do was specify the field name in the child table and the correct related record was selected. James Brown CFQUERY name=thinglist datasource=mydata SELECT tblThing.ThingKey, tblThing.ThingName, tblColor.ColorDescription, tblCategory.CatDescription, tblMaker.MakerName FROM tblThing NATURAL JOIN tblColor NATURAL JOIN tblCategory NATURAL JOIN tblMaker WHERE table.field = value /CFQUERY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anybody ever done: every n day of the month for a year ...
There may be more efficient means, but if you can supply the initial seed date - this would work: DateAdd(ww, 4, seedDate) You would want to put that in a while loop, (while the year remains the same as your seed date, add this date to my list). Adam. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 5:22 PM To: CF-Talk Subject: anybody ever done: every n day of the month for a year ... Just to save me spending too much time trying to figure this out ... Anybody already have a code snippet for calculating every N day of the Month, for a year ... Such as, Every 3rd Tuesday of the month? That's where I'm at on building my little recurrance engine. I'll spit the whole code back out the list when it's done, if anybody wants it. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jeremy Allaire leaving MM [OT - Blue Dragon]
Personally I see their release of a free CFML parser as a much more positive form of action than sitting around complaining about how and where Macromedia might take the language. Go Blue Dragon! :) Adam. -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:52 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM Yes, if you are not interested in cfcs, they do not support them at this point. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 8:19 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM I guess we can fall back on BlueDragon :| Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:01 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM exactly. *blows dust of C# books* -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:57 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM Man. I'm happy for Jeremy. Hopefully he can spend more time at home with his family now. But I must say that I'm extremely skeptical about the future of CF developers. Up until about a year ago, MM only catered to developers. I always felt that it was Jeremy who was watching out for our interests. I really hope a lot of his principals have rubbed off on MM. But if Jeremy really thinks this is such an exciting time for the internet and blah blah blah, and macromedia is so great blah blah blah, then why pursue outside opportunities? Why not be a technologist/entrepreneur for macromedia? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:40 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM Will he have another golden parachute in case he falls? -Original Message- From: Lee Surma [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:33 AM To: CF-Talk Subject: RE: Jeremy Allaire leaving MM I'm not really surprised. J.J. (Jeremy's brother) was intergel to the company at first and lest a few years ago to pursue other oppurtunities During the stock bubble I was watching the insider trading on Allaire stock. J.J. sold over 100 million dollars worth of Allaire stock. He probably has 30 sherpas hauling his gear up a mountain in Tibet right now. Lee Surma 763-494-8301 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DateCompare Question
Why not wrap a dateFormat() around the two compared values?
Adam.
-Original Message-
From: Double Down, Inc. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 4:25 PM
To: CF-Talk
Subject: DateCompare Question
I have two dates. Once is an ODBC date only that is based on
the now() function. The other is an ODBC date only that comes
from an SQL datefield. The values come out to be {d
'2003-02-06'} when I output them. The problem is the value
for the DateCompare is 1 instead of 0. Anyone have any
suggestions on how to get this to work?
TIA
DDINC
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on FreeBSD
Could you please update me on your findings if you find it through an alternate source - I'm interested in this combination as well. Adam. -Original Message- From: Ben Arledge [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 11:12 AM To: CF-Talk Subject: CFMX on FreeBSD Has anyone been able to get CFMX and FreeBSD working together? If so, have you experienced problems with this setup? Solutions? And for the folks at Macromedia, is there a possibility that you will support CF on this (superior) platform? Thanks :) Ben Arledge www.arledge.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application.cfm
In addition to the other replies, another useful file to know about is OnRequestEnd.cfm - same thing as Application.cfm, only it runs AFTER the request, not before. I had been developing CF apps for at least 6 months before I knew about this. I think it's more well known now though. Adam. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:42 AM To: CF-Talk Subject: Application.cfm Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application.cfm
Ahh yes, poor choice of words. I hope he also didn't think Application.cfm would actually run before the http request; an app server that could tell the future might be a nice tool to have :) Hi, this is amazon.com, we would just like to thank you for the purchase you're about to make. :) -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:21 PM To: CF-Talk Subject: RE: Application.cfm not to get too technical, but the file OnRequestEnd does not run after the request; but rather at the end of the request... it is the last thing processed by the server in terms of CFM pages. I know this is picky, but for a newbie, might as well start em out on the right track :-) -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 1:16 PM To: CF-Talk Subject: RE: Application.cfm In addition to the other replies, another useful file to know about is OnRequestEnd.cfm - same thing as Application.cfm, only it runs AFTER the request, not before. I had been developing CF apps for at least 6 months before I knew about this. I think it's more well known now though. Adam. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:42 AM To: CF-Talk Subject: Application.cfm Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC's and people management
I wouldn't create separate CFC's for each group of people. I would create one people CFC and then one permissions CFC. On the permissions CFC I would have methods that looked like: listPeoplePermissions(peopleID) - maybe use this on login to set a session variable addPermission(peopleID, permissionID) removePermission(peopleID, permissionID) listPermissionTypes() CFCs have built in permissions which I'm sure you're aware of. Hal also has some good thoughts down on paper for a proposed security model in fusebox applciations. The fusebox stuff can be filtered out if that's not your thing, it's a good read regardless: http://halhelms.com/writings/ProposedSecurityModel.pdf As for your database, I always use cross-reference tables to store permissions between two dynamic entities (ie, people and organizations). I always use a convention when naming my permission cross-reference tables - perms_peopleOrganizations - so that they are all together in a list of tables, and to make it a little easier on the next developer. I would imagine your permissions CFC would be in charge of managing these bad boys. Adam. -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 3:57 PM To: CF-Talk Subject: CFC's and people management Hi all, I'm planning an MX revamp to our bespoke CMS, and I'm wondering about restructuring the way people are handled, using CFC's. In my current system there are users who can login to the admin functions. This works fine, most of the time. Only, when you get clients who have login accounts to access a client-only area, I've often found myself having to create client accounts for users, so they can login to the client-only area as well to see the content they're managing. (BTW, this is all based on having a frontend and a backend, two separate CF applications. Obviously this issue would be ironed out if there's one site that can be administered from within - something I'm planning on trying.) It gets more complex when it comes to having company contacts - some of whom will be users - and maybe a more general category of people (one site I've built associated content items with one or more people, if there's an article about a specific person, or if the item is a review of an album, it links to the people table to specify the artists). I'm wondering whether I should just have one top-level people table / person.cfc that models and manages absolutely any types of people in the site. Then you'd maybe have subset tables / subtype CFC's like administrators, users, contacts, etc. In some cases there might be another level, e.g. person administrator developer, depending on whether developers would need much extra information about them storing. I'm only starting out with CFC's, so I'm just wondering whether this is a valid, effective way to start thinking about remodelling my CMS. Would I just end up with too many table joins accessing all those subset tables? Or would the fact that this will be done in CFC's reduce this problem by only having any less-than-easy SQL joins in one central place? Any comments/thoughts welcome, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: we all need to drop our tools and go get this
wonder what that guy did to his editor to deserve that story assignment :) Yeah... I'm gonna have to ask you to come in on Sunday to review the latest version of Front Page yeah. -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 3:17 PM To: CF-Talk Subject: we all need to drop our tools and go get this I thought it was interesting how they have now added snippets http://www.eweek.com/article2/0,3959,834713,00.asp Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS CF?
Why would you sell it? I'm no Wall St. slickster, but wouldn't you make out well if you were suddenly in possession of $54 MS stock in exchange for your $11 MM shares? -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 11:32 AM To: CF-Talk Subject: RE: MS CF? Ha, from the Robertson-Ravo news source :) Guess now I *don't* have to sell my Macromedia stock, whew! Rob -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:04 AM To: CF-Talk Subject: RE: MS CF? its not -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: 23 December 2002 17:07 To: CF-Talk Subject: RE: MS CF? Please tell me this isn't true. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:07 AM To: CF-Talk Subject: MS CF? http://theregister.co.uk/content/4/28667.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MS CF?
nah - no pitying required :) So how would selling your MS shares after MM was acquired not be reinforcing your opinion below? You would both be voicing your disapproval to MS and be profiting from it. Seems silly as an investor to voice your opinion before hand based on internet speculation from the Register. Adam. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 11:58 AM To: CF-Talk Subject: RE: MS CF? Well, welcome to America where you vote means nothing unless there is an amount of money tied to it. I buy stocks in companies where I like their business practices, think they have good products, and approve of how they treat their staff. Sometimes I loose money, often I make money. Because in the end how you run your business is how you wind up being treated - in this world or the next. I disapprove of a lot of Microsoft's business practices, and I think they are an ethically bad company. They make money - yes - but that is all they do. Plus I sleep *really* well. ALL IMHO as it is my funny green pieces of paper that we have put value on. (If you think it's all about the money - I pity you) Rob -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:39 AM To: CF-Talk Subject: RE: MS CF? Why would you sell it? I'm no Wall St. slickster, but wouldn't you make out well if you were suddenly in possession of $54 MS stock in exchange for your $11 MM shares? -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 11:32 AM To: CF-Talk Subject: RE: MS CF? Ha, from the Robertson-Ravo news source :) Guess now I *don't* have to sell my Macromedia stock, whew! Rob -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:04 AM To: CF-Talk Subject: RE: MS CF? its not -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: 23 December 2002 17:07 To: CF-Talk Subject: RE: MS CF? Please tell me this isn't true. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:07 AM To: CF-Talk Subject: MS CF? http://theregister.co.uk/content/4/28667.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MS CF? (OT for cf-talk)
Way OT, but the world would be a better place if people spent their money this way period. Stock market is nice, but it's the revenue from customers that makes a company. If no customers are spending, then no investors are investing, and that company goes bye bye. I was just wondering why he would sell his stock based on this speculation. Maybe if it was one of those companies that makes its keep through litigation (Sun, Adobe, etc.), it would be a different story, as we all know what happens to a company when they start spending more time in court than making their products better. But you can almost assume that MM wouldn't sell to MS at a loss, which goes back to my question of why somebody would sell before the acquisition, and not after. Selling before would actually be supporting MS, which he stated he didn't want to do for ethical reasons. Adam. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 12:21 PM To: CF-Talk Subject: RE: MS CF? At 01:14 PM 12/23/02 -0500, Luce, Greg wrote: The Stock Market is all about money. That's the first rule of investing. Buying or selling stocks based on any other ideas is just silly. Good luck with that. Actually, given the number of ethical funds out there, a lot of people think the way Rob does. I'd say the world would be a better place if more people bought stocks this way. A way to great wealth? Probably not. But money isn't everything. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute
Problem is pulling in either word or other text documents or older html documents from the database. There's no way a text-editor would know how to properly transform that format into our own custom XML. I'm afraid that will still have to be a manual process. XHTML seems like a better step, as from what I believe it's just an 'XML standard that happens to have the syntax of html'. Adam. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 7:56 AM To: CF-Talk Subject: RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute Wouldn't that be XML? -Kevin .. So thanks for improving the product, we did choose yours for a reason. I'd just like to see a solid format for storing content long-term and still being able to change its presentation 10 years down the road if needed. ... Adam. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 3:21 PM To: CF-Talk Subject: RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute Adam, in ActivEdit 3.0 we added a bunch of regular expressions, and parsers to clean up Word content pasted into the control, it's not perfect but it does get rid of lots of extraneous markup when you paste from Word. Are you using Version 3? As for the HTML that ActivEdit generates (actually it's the ActiveX control that generates the HTML in most cases), it is valid HTML 3.2. Many people prefer XHTML output these days, and we do have a CFX tag that will convert HTML 3.2 or 4 into XHTML or vise versa, if your interested let me know. The next version of ActivEdit will address these issues further. You can also set a stylesheet for use within activedit via the stylesheet attribute. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 1:33 PM To: CF-Talk Subject: RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute I'd like to see an editor that only defines classes in a div or a span, and which provides a default style sheet. The extent of the html would be very simple a, br /, hr / and XHTML compliant. One problem I see with this is pulling in word documents, or old HTML with tables and invalid markup. We're currently using ActiveEdit, and even though it's working well, I have this really uneasy feeling about the HTML it's producing. It just completely goes against the concept of separating content from style, but I just can't think of a suitable alternative to doing it this way until we can: a. Go through all of our old content stripping out all of the markup, and then restylizing it using the new editor's classes. b. Make the decision to never paste word documents, or old html into the editor without first cleansing it in notepad, and then restylizing it within the editor. That would be a complete administrative nightmare. Is anyone else feeling the same concerns, and has anyone taken measures to address this? I'd be interested in hearing what you did. Adam. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:00 AM To: CF-Talk Subject: MM Rich Text Editor - WAS: RE: Macromedia Contribute I would think that given those abilities that integrating it into an intranet security context would provide functionality for permissions. Personally, I'd rather have something that lets me control file/edit permissions and simply sticks to editing capabilities. I want a super-form-control more than a content manager - I'll handle the content management as it applies to my specific application. Is there a version of the DRK2 Rich Text Editor online anywhere that I could try before I buy? I'd like to be able to make an informed decision before jumping into something. Although from the looks of ActivEdit it's going to be hard to beat. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination
RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute
I'd like to see an editor that only defines classes in a div or a span, and which provides a default style sheet. The extent of the html would be very simple a, br /, hr / and XHTML compliant. One problem I see with this is pulling in word documents, or old HTML with tables and invalid markup. We're currently using ActiveEdit, and even though it's working well, I have this really uneasy feeling about the HTML it's producing. It just completely goes against the concept of separating content from style, but I just can't think of a suitable alternative to doing it this way until we can: a. Go through all of our old content stripping out all of the markup, and then restylizing it using the new editor's classes. b. Make the decision to never paste word documents, or old html into the editor without first cleansing it in notepad, and then restylizing it within the editor. That would be a complete administrative nightmare. Is anyone else feeling the same concerns, and has anyone taken measures to address this? I'd be interested in hearing what you did. Adam. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:00 AM To: CF-Talk Subject: MM Rich Text Editor - WAS: RE: Macromedia Contribute I would think that given those abilities that integrating it into an intranet security context would provide functionality for permissions. Personally, I'd rather have something that lets me control file/edit permissions and simply sticks to editing capabilities. I want a super-form-control more than a content manager - I'll handle the content management as it applies to my specific application. Is there a version of the DRK2 Rich Text Editor online anywhere that I could try before I buy? I'd like to be able to make an informed decision before jumping into something. Although from the looks of ActivEdit it's going to be hard to beat. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ** ** * -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:32 AM To: CF-Talk Subject: RE: Macromedia Contribute There are built-in controls to limit users to a particular directory; disallow editing of scripts/includes/forms/ or even anything but text; allow or disallow the ability to assign css styles, and disable the font tag and even inline css styles. You can limit users to only edit pages, create pages based on templates, , create pages by copying any existing page, or make anything from scratch. And you can define a file size limit to how large of a graphic can be used on a page (in KB, not dimensions.) That's pretty much what you can control. You can create groups of users with different permissions. Other than that, it's not really extensible for permissions from what I can see. -Kevin -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:30 AM To: CF-Talk Subject: Re: Macromedia Contribute Samuel R. Neff wrote: If that's what you want you can take a look at MM's DRK2 which has a Rich Text Editor component for Flash. It can easily be wrapped into a stand-alone widget for embedding in HTML and an also be extended. Does anyone have this, who would like to comment on how extendable it is? For example. if I wanted to limit the html editing controls my users had (no fonts or colours, for example, or only stylesheet classes) could I do this? Or say I wanted to change the colour of the component to match my app... Thanks, Kay. -- Kay Smoljak http://kay.smoljak.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.
RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute
Hey thanks Pete, you guys make a good product. We're now using version 3 with stylesheets and custom classes - huge improvement. We've taken out the style toolbars that would allow you to change size/color/font, and have replaced them with a set of standard classes. The problem now though is pulling in all of the content that was created with 2.5. There is still a great deal of font and other static styles which don't really give our content a consistent feel (at least looking at the source it doesn't). Word documents are much better, but still heavily garbled with unsightly markup - even after filtering. I understand that this may be a limitation of the MS provided word filter. So thanks for improving the product, we did choose yours for a reason. I'd just like to see a solid format for storing content long-term and still being able to change its presentation 10 years down the road if needed. The goal is to have our content people focusing on their substantive areas of expertise, and not the technical aspects of why do I have to paste this into notepad and then redo all of the styles again?. That has been a huge process for them - converting a bunch of old dreamweaver code into ActiveEdit, and you can imagine the looks I got when I told them we were upgrading to version 3. All I could say was that it was for their own good :| Hopefully my original msg wasn't taken as being overly critical of your guys' product, was more of a general complaint towards the common markup woes that we still all have to deal with for some reason :) Adam. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 3:21 PM To: CF-Talk Subject: RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute Adam, in ActivEdit 3.0 we added a bunch of regular expressions, and parsers to clean up Word content pasted into the control, it's not perfect but it does get rid of lots of extraneous markup when you paste from Word. Are you using Version 3? As for the HTML that ActivEdit generates (actually it's the ActiveX control that generates the HTML in most cases), it is valid HTML 3.2. Many people prefer XHTML output these days, and we do have a CFX tag that will convert HTML 3.2 or 4 into XHTML or vise versa, if your interested let me know. The next version of ActivEdit will address these issues further. You can also set a stylesheet for use within activedit via the stylesheet attribute. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 1:33 PM To: CF-Talk Subject: RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute I'd like to see an editor that only defines classes in a div or a span, and which provides a default style sheet. The extent of the html would be very simple a, br /, hr / and XHTML compliant. One problem I see with this is pulling in word documents, or old HTML with tables and invalid markup. We're currently using ActiveEdit, and even though it's working well, I have this really uneasy feeling about the HTML it's producing. It just completely goes against the concept of separating content from style, but I just can't think of a suitable alternative to doing it this way until we can: a. Go through all of our old content stripping out all of the markup, and then restylizing it using the new editor's classes. b. Make the decision to never paste word documents, or old html into the editor without first cleansing it in notepad, and then restylizing it within the editor. That would be a complete administrative nightmare. Is anyone else feeling the same concerns, and has anyone taken measures to address this? I'd be interested in hearing what you did. Adam. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:00 AM To: CF-Talk Subject: MM Rich Text Editor - WAS: RE: Macromedia Contribute I would think that given those abilities that integrating it into an intranet security context would provide functionality for permissions. Personally, I'd rather have something that lets me control file/edit permissions and simply sticks to editing capabilities. I want a super-form-control more than a content manager - I'll handle the content management as it applies to my specific application. Is there a version of the DRK2 Rich Text Editor online anywhere that I could try before I buy? I'd like to be able to make an informed decision before jumping into something. Although from the looks of ActivEdit it's going to be hard to beat. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254
RE: Query Trouble
You need to do a left outer join - cfquery datasource=myfictionalstore name=qGetData SELECT vendors.vendorid, vendors.vendor_name,products.product_name FROM vendors LEFT OUTER JOIN products ON vendors.id = products.vendorid ORDER BY vendorid /cfquery Give that a shot. Adam. -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 4:50 PM To: CF-Talk Subject: SOT: Query Trouble Ok, say I have a table of vendors and a table of products, and I want to list out all the vendors and their products: cfquery datasource=myfictionalstore name=qGetData SELECT vendors.vendor_name,products.product_name FROM vendors, products WHERE vendors.id = products.vendorid ORDER BY vendorid /cfquery Then: cfoutput query=qGetData group=vendorid #qGetData.vendor_name#: cfoutput #qGetData.product_name#, /cfoutput br /cfoutput This gives me a good list of all my vendors, with a somewhat sloppy comma delimited list of their products after. But what if I have vendors who don't currently have products in the product table, and I want to list them anyway? It's like a, where-are-the-vendors and BTW, here-are-their-products kind of deal. Another way to put it. I have three vendors and the second one has no products, I need my list to look like this: Vendor A: mouse traps, cat food, Vendor B: Vendor C: applesauce, condensed milk, But the above query doesn't do that. Any help? Willy - Willy Ray Web Applications Developer Certified Advanced ColdFusion Developer Westminster College ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: One dynamic site for multiple indepentdent businesses
Don't forget cf_objectDump http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA34776D-2830-11D4 -AA9700508B94F380method=Full Excellent dumping tag for pre CF5, especially if you're working with XML or nested structures of arrays of structures of arrays, etc. Adam. -Original Message- From: Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:57 AM To: CF-Talk Subject: One dynamic site for multiple indepentdent businesses If you're with a pre cf5 version, there is a custom tag on the exchange, called cf_dump, I think. It gives same as the dump tag (and maybe more). Great to see what is being generated with a query, structure, etc, as well as a visual rendering which can help understanding. Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Newsgroup
Hugo, I may be wrong, but I don't think cf-talk is mirrored on an nntp group. I do know that it's mirrored in the archives at houseoffusion.com. I think you can also post to the list from the archives as well, although I haven't used it yet. You also used to be able to view it at fusetalk.com within a message forum format, but I think they might have taken that down - not sure why. Did you know about the alt.comp.lang.coldfusion newsgroup? I believe that mirrors with the official Macromedia forum at http://webforums.macromedia.com/coldfusion/ Somebody else might be able to correct me on that though. Hope that helps. Adam. -Original Message- From: Hugo Ahlenius [mailto:Ahlenius;grida.no] Sent: Thursday, November 14, 2002 2:39 AM To: CF-Talk Subject: Newsgroup Dear all (especially the admin crew) I might have missed something, but is CF-talk mirrored on a nntp-server? If not, would it be possible to consider that? I am only reading a few mails here and there from the daily (actually mostly nightly) crop, and I get the feeling that a newsgroup would suit me better (and would fill up our mail server less...) :) Cheers, Hugo ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: supposedly simple query
The cfoutput in your cflocation is causing unwanted spacing in your URL. Try: cfoutput cflocation url=messages.cfm?thread=#formthread# /cfoutput instead of: cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput Adam. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like cfquery name=getmessages datasource=mydns select * from message where thread = #threadnumber# /cfquery where #threadnumber# is set by cfset threadnumber=#trim(URL.thread)# coming from a cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: supposedly simple query
As someone else pointed out, no cfoutput needed. And as others have pointed out - cfqueryparam cfqueryparam cfqueryparam. This will also prevent certain types of URL/'SQL injection' hacking. (I myself am going through an existing application using cfqueryparam where I should have from the beginning - thanks Jochem! ;) ) Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:33 PM To: CF-Talk Subject: RE: supposedly simple query The cfoutput in your cflocation is causing unwanted spacing in your URL. Try: cfoutput cflocation url=messages.cfm?thread=#formthread# /cfoutput instead of: cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput Adam. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like cfquery name=getmessages datasource=mydns select * from message where thread = #threadnumber# /cfquery where #threadnumber# is set by cfset threadnumber=#trim(URL.thread)# coming from a cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: supposedly simple query
Sure, but don't pass off what everyone else said about cfqueryparam, you'll be pretty salty the day some kid writes: messages.cfm?thread=271; DROP CUSTOMERS; and have your database blown away. There are tools in your web server software that might have addressed this, but this is only one reason why it's good for you to validate the type of data your query is expecting. Ben Forta lays it out for you: http://www.macromedia.com/desdev/articles/ben_forta_faster.html Adam. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:59 PM To: CF-Talk Subject: RE: supposedly simple query That is exactly what it was, first I took the cfoutput/cfoutput out of the cflocation and wrapped them around the cflocation instead and it worked. Then after reading Craig's post I took them out all together and it is working fine now. Thanks. Jeremy -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:33 PM To: CF-Talk Subject: RE: supposedly simple query The cfoutput in your cflocation is causing unwanted spacing in your URL. Try: cfoutput cflocation url=messages.cfm?thread=#formthread# /cfoutput instead of: cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput Adam. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like cfquery name=getmessages datasource=mydns select * from message where thread = #threadnumber# /cfquery where #threadnumber# is set by cfset threadnumber=#trim(URL.thread)# coming from a cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Mass Database update
You'll probably not want to tackle this with ColdFusion. Use a transformation tool native to your DB if it's truly 'massive'. This will give you the most integrity/performance. If you want to automate the process using ColdFusion, that would be fine. Have them upload the Excel spreadsheet via CFFILE, and then have CF fire a StoredProcedure on your DB to import the information properly from Excel. You could pass the Stored Procedure the excel file name and make it truly dynamic/automated. Adam. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 9:37 AM To: CF-Talk Subject: Mass Database update We have a client that wants to drop a database table and replace it with a new one every once and a while. Is there any dummy proof ways of doing this? Have them upload a CSV, use CFFILE to loop over the information and import it? The data will start as an Excel table. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: input tag
http://developer.irt.org/script/frame.htm -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 9:28 AM To: CF-Talk Subject: input tag I'm using 3 column frames on my site with the following names. | left | middle | right | I have this input line on a page in the right frame. When I click on the Refresh button I want the middle frame refreshed. The below only refreshes the right frame when clicked. Whats wrong with my syntax or JS? input type=button value=Refresh class=navlinks onClick=javascript:history.go(0); target=middle --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
please do my work for me
I want to extract a value from a URL variable which can show up anywhere in the URL. Here are some examples, I would want the pCode value which will always be an integer of varying length: index.htm?var1=23pCode=100othervar=hello return 100 index.htm?pCode=1 --- return 1 index.htm?someVariabl=hiTheresomeothervariable=45pCode=00343223234322 - return 00343223234322 If somebody can tell me the right regular expression (or if a regular expression isn't even needed, but just some combination of CF functions) that would be GREAT! Adam. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regular expressions (was: please do my work for me)
I'm so sorry about the title - it was originally addressed to a friend but then decided to send it to cf-talk halfway through the email. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:38 PM To: CF-Talk Subject: please do my work for me I want to extract a value from a URL variable which can show up anywhere in the URL. Here are some examples, I would want the pCode value which will always be an integer of varying length: index.htm?var1=23pCode=100othervar=hello return 100 index.htm?pCode=1 --- return 1 index.htm?someVariabl=hiTheresomeothervariable=45pCode=00343 223234322 - return 00343223234322 If somebody can tell me the right regular expression (or if a regular expression isn't even needed, but just some combination of CF functions) that would be GREAT! Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regular expressions (was: please do my work for me)
Ooops I'm sorry, I'm actually trying to extract this value from the cgi.HTTP_REFERER variable. Here's what I'm currently using: cfif (isDefined(cgi.HTTP_REFERER)) AND (FindNoCase(pCode=, CGI.HTTP_REFERER)) cfset variables.pCode = mid(cgi.HTTP_REFERER,FindNoCase(pCode=, CGI.HTTP_REFERER)+6,2) /cfif My only problem is when the pCode starts to vary in length - they're not going to be two digits forever. Thanks for any help you can provide. Adam. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:44 PM To: CF-Talk Subject: RE: please do my work for me Why not just return URL.pCode ? Ade -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: 25 September 2002 22:38 To: CF-Talk Subject: please do my work for me I want to extract a value from a URL variable which can show up anywhere in the URL. Here are some examples, I would want the pCode value which will always be an integer of varying length: index.htm?var1=23pCode=100othervar=hello return 100 index.htm?pCode=1 --- return 1 index.htm?someVariabl=hiTheresomeothervariable=45pCode=00343 223234322 - return 00343223234322 If somebody can tell me the right regular expression (or if a regular expression isn't even needed, but just some combination of CF functions) that would be GREAT! Adam. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: please do my work for me
SORRY EVERYONE - my original question was phrased horribly. Yes, I was trying to parse the value out of a string and not a URL variable as I had originally asked. Sorry for the title and sorry for the unclear choice of wording. Thanks for all your help - and also confirming how to output a URL variable!!! Sometimes we need affirmation on the simple things ;o) Ben, yours worked - thanks dewd. Adam. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:54 PM To: CF-Talk Subject: RE: please do my work for me I'm assuming this is a link somewhere in some content you're cfhttp-ing, or you'd just use url.pCode. Anyhow, pcode = rereplacenocase(url, .*pcode=([^]+).*, \1) Happy regexing. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, September 25, 2002 5:38 PM : To: CF-Talk : Subject: please do my work for me : : : I want to extract a value from a URL variable which can show up : anywhere in : the URL. Here are some examples, I would want the pCode value which will : always be an integer of varying length: : : index.htm?var1=23pCode=100othervar=hello return 100 : : index.htm?pCode=1 --- return 1 : : index.htm?someVariabl=hiTheresomeothervariable=45pCode=00343 223234322 : - return 00343223234322 : : If somebody can tell me the right regular expression (or if a regular : expression isn't even needed, but just some combination of CF functions) : that would be GREAT! : : Adam. : : __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Good CFX Tag to do bulk mailing
Jochem has a nice custom tag to replace cfmail - not cfx though. http://jochem.vandieten.net/coldfusion/customtags/advancedemail/ And then from the makers of Active Edit - java CFX. http://www.cfdev.com/activmail/ Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:43 AM To: CF-Talk Subject: Good CFX Tag to do bulk mailing Anyone have a good CFX tag to do bulk mailing that will also allow it to be sent out to a specific server. CFMAIL is too slow but I want to see if anyone has any good CFX tags to do it before I start to write my own. Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL replacements?
(Copied from other thread.) Jochem has a nice custom tag to replace cfmail. http://jochem.vandieten.net/coldfusion/customtags/advancedemail/ And then from the makers of Active Edit http://www.cfdev.com/activmail/ Adam. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:13 AM To: CF-Talk Subject: CFMAIL replacements? Does anyone know of a decent replacement for CFMAIL. I have a problem where CFMAIL just sends and sends emails repetitavely. I confirmed it isn't a coding issue. I added a CFLOG to the page with the CFMAIL tag and its only ran once but the emailsent.log shows it sending numerous times. Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Database practices
Depends on a few factors - your rdbms, indexing, how well you know SQL, whether you're using stored procedures, the complexity of your products/options/values, and how often they will be updated. Just as you said, there's no cut and dry answer really - some people like heavy normalization, some people like a little. There's whole books on it I'm sure. One of my favorite SQL books is Joe Celcko's 'SQL for Smarties'. Adam. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 3:16 PM To: CF-Talk Subject: RE: Best Database practices Is there a point of diminishing returns? How far can you go with this concept before you create a huge headache? Price, and Image could be broken down in a similar fashion as options. Are the series of joins to 5 tables going to be faster or slower then 3 joins? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 2:54 PM To: CF-Talk Subject: Re: Best Database practices There are a great many books ... I would layout a product table that has the basics for all the products productTable productId, Title, image, sku, price optionTable optionId, optionTitle optionValues optionValueId, optionId, optionValue, additionalPrice That is just for your product and options ... not departments and such. Basically you have a table for your products, a table for your options, and a table for your option values. Hope this helps Paul Giesehagen QuillDesign Quick question. Are there any books or articles out there that describe best practices for laying out product in a database? Say you have product like a t-shirt. You could layout a relational database like this, but is this the best method? Should sizes, and colors have their own table? Category T-shirts SubCategory Long Sleeve T-Shirts Short Sleeve T-Shirts Product Sears T-Shirt Lands End T-Shirt ProductOptions Blue Lands End T-Shirt L Blue Lands End T-Shirt XL Green Lands End T-Shirt XL I suppose this is a pretty tough question that may not have a cut and dry answer seeing how all product seem to have all kinds of different options and structure __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
