URL Rewriting
I saw the topic of url rewriting come up here recently which peeked my interest so here I go with my first newb issue: Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is behaving nicely. I have a site with all pages physically located inside a subfolder (ie /pages) directly off the root. I was asked to remove the pages folder from the location that shows in the web browser (ie change http://www.mydomain.com/pages/events/ to http://www.mydomain.com/events). I just want to hide the pages folder from view. Is this possible? -- Ryan LeTulle ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
Thanks Dave. Unfortunately, everything is not in that folder. I toyed with Virtual Directories earlier. I am thinking of creating multiple virtual directories like: /about , /about/staff ... , /visitors , /visitors/attractions Does this make sense to you? The client just doesn't want the pages folder to ever show in the path. Was told by SEO experts this is bad for Google and looks ugly. Maybe it is bad but the pages they are referencing are their highest ranking pages in Google so go figure. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:32 PM, Dave Watts dwa...@figleaf.com wrote: I saw the topic of url rewriting come up here recently which peeked my interest so here I go with my first newb issue: Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is behaving nicely. I have a site with all pages physically located inside a subfolder (ie /pages) directly off the root. I was asked to remove the pages folder from the location that shows in the web browser (ie change http://www.mydomain.com/pages/events/ to http://www.mydomain.com/events). I just want to hide the pages folder from view. Is this possible? If all your pages are in fact in that one folder, you can just configure IIS to use that as the root folder. If you then want to serve other files, like images, from a parallel folder, just create a virtual directory pointing to that folder. There's no need to do URL rewriting for this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
This is what I'm gonna do: 1. Create Virtual Directories in IIS: (ie /public/about will be /about) 2. Incoming links such as http://www.mydomain.com/public/about will be redirected to http://www.mydomain.com/about as such with IIRF RedirectRule ^/public/about /about [R=301] Am I missing anything that anyone can see? Eventually Google should start pointing to the virtual directories and I won't lose anything now or then. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:48 PM, Dave Watts dwa...@figleaf.com wrote: Unfortunately, everything is not in that folder. I toyed with Virtual Directories earlier. I am thinking of creating multiple virtual directories like: /about , /about/staff ... , /visitors , /visitors/attractions Does this make sense to you? Sure, assuming that these folders are parallel to the pages folder. The client just doesn't want the pages folder to ever show in the path. Was told by SEO experts this is bad for Google and looks ugly. Maybe it is bad but the pages they are referencing are their highest ranking pages in Google so go figure. Well, I wouldn't want /pages in the path either, since it doesn't add any meaningful value. Here's how I like my URLs: http://www.w3.org/Provider/Style/URI That said, if their current pages rank highly with /pages in the URL, they will be throwing that away (at least temporarily) if they discard those URLs in favor of, well, anything else. And as far as SEO goes, it doesn't make any difference. But nowadays, anybody can claim to be an SEO expert; it doesn't count for much. Here's a decent SEO presentation by my coworker, Steve Drucker (who isn't an SEO expert, but doesn't claim to be - and who has as good or better a working knowledge of SEO as many of these so-called experts): http://figleaf.mmalliance.acrobat.com/seo/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
haha I love you guys. -- Ryan LeTulle On Tue, Jun 16, 2009 at 3:11 PM, Barney Boisvert bboisv...@gmail.comwrote: The MD5 gamut is 2^128 or 16^32 or 340,282,366,920,938,463,463,374,607,431,768,211,456. Your database will run out of integer keys long before it's an issue with almost complete certainty. But yes, it is a potential problem. Easy to make fail-fast with a constraint on your DB though. cheers, barneyb On Tue, Jun 16, 2009 at 1:03 PM, Alan Rotheralan.rot...@gmail.com wrote: One catch with a hash, it is possible, however highly unlikely, that two different email addresses will produce the same hash. Just be aware of it. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: google style paging navigation
NP NathanI was impressed when I was turned on to it last week. Nice work. -- Ryan LeTulle On Mon, Jun 15, 2009 at 11:03 AM, Nathan Strutz str...@gmail.com wrote: Thanks, Ryan. I would have replied earlier if I had seen it. Mike P, check out my Pagination.cfc project: http://paginationcfc.riaforge.org/ I have an example of how to emulate the google paging here: http://www.dopefly.com/projects/pagination/examples/index.cfm?style=google The examples app, including images and css, are included in the download from riaforge. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Sun, Jun 14, 2009 at 3:34 PM, Ryan Letulle bayous...@gmail.com wrote: Nathan Strutz at http://www.dopefly.com/projects/pagination/examples/ -- Ryan LeTulle On Sun, Jun 14, 2009 at 5:25 PM, mike pop mikepoplaw...@gmail.com wrote: does anybody have snippets for creating google style like paging navigation. First Rec - Previous Rec 31 32 33 34 35 36 37 38 39 40 Next Rec - Last Rec The current page should not display a link The Next Rec will increment the page link by one (e.g. if the user in this case clicks Next Rec, the links displayed will be 32..41) google is a bit different but I want to display the page numbers sequentially and only 10 items or whatever cfparam is set to. I've found the most basic tutorials on navigation but nothing like google style navigation. I can't find code snippets from a previous project. Please help me Thank you for your help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: google style paging navigation
Nathan Strutz at http://www.dopefly.com/projects/pagination/examples/ -- Ryan LeTulle On Sun, Jun 14, 2009 at 5:25 PM, mike pop mikepoplaw...@gmail.com wrote: does anybody have snippets for creating google style like paging navigation. First Rec - Previous Rec 31 32 33 34 35 36 37 38 39 40 Next Rec - Last Rec The current page should not display a link The Next Rec will increment the page link by one (e.g. if the user in this case clicks Next Rec, the links displayed will be 32..41) google is a bit different but I want to display the page numbers sequentially and only 10 items or whatever cfparam is set to. I've found the most basic tutorials on navigation but nothing like google style navigation. I can't find code snippets from a previous project. Please help me Thank you for your help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. BTW I am not talking about guarding Fort Knox here. -- Ryan LeTulle On Fri, Jun 12, 2009 at 4:21 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Friday 12 Jun 2009, Ryan Letulle wrote: An example would be for an emailed order confirmation with a link back to their order details. ... By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. But surely your getOrderFromOrderId() method checks that the id number it is given belongs to the currently logged in user... oh... ummm ?:-) -- Helping to paradigmatically seize B2B professional dot-com convergence as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
Doesn't require a UUID as the PK, just something unique and unpredictable for that piece of functionality, which could be derived/hashed from any static column(s). Peter, Are you saying that a uuid is inherently insecure? I thought part of the uuid was created randomly and for the purposes where I was using it felt comfortable. Maybe that sense was false. Are you saying to hash something else like the person's name and use that and it would be more secure? or Are you saying don't do anything like this at all? -- Ryan LeTulle On Fri, Jun 12, 2009 at 6:33 AM, Ryan Letulle bayous...@gmail.com wrote: Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. BTW I am not talking about guarding Fort Knox here. -- Ryan LeTulle On Fri, Jun 12, 2009 at 4:21 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Friday 12 Jun 2009, Ryan Letulle wrote: An example would be for an emailed order confirmation with a link back to their order details. ... By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. But surely your getOrderFromOrderId() method checks that the id number it is given belongs to the currently logged in user... oh... ummm ?:-) -- Helping to paradigmatically seize B2B professional dot-com convergence as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
OK, I guess. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:01 AM, Jochem van Dieten joch...@gmail.comwrote: On Fri, Jun 12, 2009 at 1:38 PM, Ryan Letulle wrote: Are you saying that a uuid is inherently insecure? Depends on how you use them. I thought part of the uuid was created randomly and for the purposes where I was using it felt comfortable. Some UUIDs are random, some are completely predictable. The ones created with the CreateUUID() function are predictable. Maybe that sense was false. Are you saying to hash something else like the person's name and use that and it would be more secure? A primary key is just a primary key, it does not have any security semantics. Even when people know a primary key of a record your code should check whether the user is allowed to see that record. Every user has a username and password to authenticate the user, and you have some sort of permissions system to check whether the user has permissions to access a record. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
Thank you all. A long habit of not thinking a thing wrong gives it a superficial appearance of being right. Thomas Painehttp://www.brainyquote.com/quotes/quotes/t/thomaspain161749.html * *-- Ryan LeTulle On Fri, Jun 12, 2009 at 7:12 AM, Peter Boughton bought...@gmail.com wrote: Are you saying that a uuid is inherently insecure? UUIDs are guaranteed to be unique, but not (afaik) to be unpredictable. I don't know *how* predictable they might be, but for any secure string I wouldn't want to rely entirely on something with potentially knowable/guessable sources - I would want something derived from both secret information and data that is related to the original record. So, I would most likely use some form of double salted hash that incorporates data that relates to that person - but not necessarily name, since that might be changable. Make sense? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
One note I don't use the uuid as the primary key in these instances. I know that's how this post started. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 9:07 AM, Mary Jo Sminkey mary...@cfwebstore.comwrote: Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. If they want to view order history, yes, that's the easiest way to ensure security for viewing the information. If you want to allow users to check out without creating an account, then they either cannot view order information online, or you need to create some kind of random access code for them to use to view the order. Or you can use something else to validate the user, such as entering their Order ID and the email associated with the order. There's a variety of ways you can do it, that don't have anything to do with how you assign the primary key. --- Mary Jo ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Proper returntype of a cfc
Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. -- Ryan LeTulle ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Proper returntype of a cfc
That's what I thought but I've been wrong before. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:30 PM, Rob Parkhill robert.parkh...@gmail.comwrote: You would need to return it as a struct. then just reference any parts of the struct that contain the data you want. I have one cfc that returns a struct of arrays... Rob On Fri, Jun 12, 2009 at 8:25 PM, Ryan Letulle bayous...@gmail.com wrote: Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. -- Ryan LeTulle ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
Understand, I guess the proper terminology should be multiple values ? -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:35 PM, Dave Watts dwa...@figleaf.com wrote: Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. You can't return multiple variables from a function call. You can only return one variable. Of course, that variable can contain other variables, multiple values, recordsets, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:43 PM, Dave Watts dwa...@figleaf.com wrote: Understand, I guess the proper terminology should be multiple values ? Well then, it seems an odd question to ask. Return whatever data type reflects the best possible output for your function. If that's a query, return a query. If it's an array, return an array. If it's a structure, return a structure. There's nothing wrong with returning any of these, if that's what you want to get back. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Proper returntype of a cfc
BTW I always appreciate the guidance. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:45 PM, Ryan Letulle bayous...@gmail.com wrote: Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:43 PM, Dave Watts dwa...@figleaf.com wrote: Understand, I guess the proper terminology should be multiple values ? Well then, it seems an odd question to ask. Return whatever data type reflects the best possible output for your function. If that's a query, return a query. If it's an array, return an array. If it's a structure, return a structure. There's nothing wrong with returning any of these, if that's what you want to get back. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
@dave I started using cfcs after reading a Ben Forta article a couple of years ago where he said at least use cfcs for querys and you should never output to the screen from cfcs. For the most part that is what I have used them for. Unfortunately, I never really advanced further than that with cfcs. Otherwise, I get it done without 'em. I want to do better. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:57 PM, Dave Watts dwa...@figleaf.com wrote: Only odd to you because you are all knowing. I wish! But calling functions in CF is basically the same as calling functions in other languages. You provide a list of inputs, and get a single return value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
The tradeoff will be between a user not being able to play around with the querystring (i.e change id=1 to id=2) and performance. How much performance I can't say. A million a day I would think you would start to see it. I personally haven't hit the performance issue with uuid but I also haven't created nearly 1 million a day. -- Ryan LeTulle On Thu, Jun 11, 2009 at 7:03 AM, Fawzi Amadu abd...@gmail.com wrote: I am wondering the best way to create an ID for an online advertising site that I anticipate could have about a million products uploaded a day. I had considered using create UUID I read the following from Christian Cantrell If you want the convenience of generating your own primary key without the performance degradation of selecting from a table with a 35 character primary key, you can let your database create a normal auto-incrementing ID field as you normally would to use as your primary key, and insert a UUID at the same time. Then, just select the ID of the row that has the UUID that you just generated, and you are guaranteed (statistically) to have selected the right ID without having to use vendor specific SQL Now I am wondering if I should add the auto-incrementing ID or just use and auto- generated number concatenated with the a string representing the day, month and year of the transaction. I'll appreciate any insight on this. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
Nothing to do with security measures for me. Many times I simply don't want anyone accessing another record in the database. I am sure that you can imagine that type of scenario, in case not An example would be for an emailed order confirmation with a link back to their order details.(in this case the client does not want someone to fill out user details and create an account for their own reasons) By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. Sometimes you just have to use your imagination Peter. :) -- Ryan LeTulle On Thu, Jun 11, 2009 at 3:55 PM, Peter Boughton bought...@gmail.com wrote: The tradeoff will be between a user not being able to play around with the querystring (i.e change id=1 to id=2) Huh!? Please tell me you don't use UUIDs as an alternative to having proper security/permissions in place? Because if you do have proper security there is no playing around that can happen with incremental ints, and if you don't have security, regardless of method, all it takes is an uneducated/sloppy user to [accidentily] reveal a URL/ID in public... :/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
Something like Mike's printer solution sounds promising to me. You might need to look into some special formatting/pl for the output so the printer can understand it natively though. I did some work in labs with Zebra printers that required that to print out barcodes. -- Ryan LeTulle On Wed, Jun 10, 2009 at 9:44 AM, Dawson, Michael m...@evansville.eduwrote: In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
@gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
I tend to agree if that syntax works in all situations for dynamic form variables and I'm not doing something that works sometimes and I'm not sure exactly when. -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:14 PM, Gabriel coldfus...@evolution7.com wrote: Repost/Edit: apparently msoft forefront exchange server thinks I was being profane. You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
thx for the form info, on a side note: became very aware of the value of cfqueryparam last year during the chinese et al sql injection attacks -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:17 PM, Gabriel coldfus...@evolution7.com wrote: Ryan, You can use #form['string'var]# anywhere, including form['string'var] = x. CfQueryParam is a separate issue relating purely to Will's SQL and it's vulnerability to SQL injection attack. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
After seeing how malicious and how effective hackers were with automated sql injection last year I vowed to never leave an integer field unturned without using cfqueryparameters it's just too easy to use it and the benefit is unquestionable especially for integer fields. I am also seeing some addtl benefits with other field types now as well but integers are required. -- Ryan LeTulle On Tue, Jun 9, 2009 at 9:51 PM, Gabriel coldfus...@evolution7.com wrote: Will, Justin is right, just because your form is behind a username/password it by no means guarantees that the people accessing that form aren't malicious. As for whether there are scenarios where you shouldn't use queryparam? That's probably open for debate (it's certainly been debated before), however I've not come across a situation (except the caching issue as mentioned) where it's been of any benefit to NOT use queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
In my experience it has. -- Ryan LeTulle On Mon, Jun 8, 2009 at 4:33 PM, Eric Roberts ow...@threeravensconsulting.com wrote: We have ample use of Iframes on our site (something I cannot change) and we would like to use the sitewide error handler to manage errors. If an error is thrown in an iframe, the error is only going to be shown in that Iframe and the rest of the page will display as normal...right? I just wanted to verify this before we spend any more time spinning out wheels here. Thanks! Eric ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOA Coldfusion best practices
ha ha -- Ryan LeTulle On Mon, Jun 8, 2009 at 5:27 PM, David McGuigan davidmcgui...@gmail.comwrote: Who are you kidding, you loved doing that. On Mon, Jun 8, 2009 at 4:14 PM, Nathan Strutz str...@gmail.com wrote: I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Mon, Jun 8, 2009 at 2:49 PM, Tim Oommen toom...@playboy.com wrote: Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Moving from CF to Java - redirecting old pages to new ones
I know someone knows a better way but I have done it in the application.cfm using cfheader statuscode=301, statustext=Moved Permanently then another cfheader name=Location value=new url. First detecting whether it's the page in question of course. -- Ryan LeTulle On Fri, Jun 5, 2009 at 12:22 PM, coldfusion.develo...@att.net wrote: All, We have over 100 cfm pages that we'll need to redirect to a reduced number of new, few jsp pages. Is the best way to do this at the server, IIS level or through the webpage level. I'm thinking, detect all requests globally and if they have a .cfm extension, look up that page in a db and serve up the replacment page. Thoughts? Thanks D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating appopriate transaction IDs
I've been using createuuid() for a little while now and I haven't encountered any issues. I like it because you don't have as many smart asses trying to go in and change the id in the querystring. :) -- Ryan On Thu, Jun 4, 2009 at 6:28 AM, Peter Boughton bought...@gmail.com wrote: getTickcount() or createUuid() ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reducing a query result
All I can say is wow! -- Ryan On Thu, Jun 4, 2009 at 10:24 AM, Alan Rother alan.rot...@gmail.com wrote: Coolio... If you ever need my good friend Nathan Strutz wrote a great tool for pagination http://www.dopefly.com/projects/pagination/ Sure saves a lot of time... http://www.dopefly.com/projects/pagination/=] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery question
Shouldn't be hard at all to have a hidden div prepared. After the text area is changed put the script in the div (getelementbyid) and show the div. I don't think you need ajax for that. You could certainly write it in jQuery syntax but any old javascript should do that. I've never tested it but I think it should work unless there is some issue with the script you are pasting. -- Ryan On Wed, Jun 3, 2009 at 5:42 PM, Mike Little m...@nzsolutions.co.nz wrote: sorry, could not think of a better subject! i have a form which an admin enters a embed script such as a youtube video. what i would like to achieve is to have a preview button which takes the contents of the textarea (ultimately filters the content with my clever param filter) and displays the output in a popup similar to... http://yensdesign.com/tutorials/popupjquery/ (or alternatively the output displays in a div below the textarea?) i am very new to jquery/ajax and really would like to get into it. unfortunately we have issues with using cf8's ajax features on my hosts shared server and would like to use native jquery/ajax. any help/pointers in the right direction would be really appreciated. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323136 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery question
I usually choose Thickbox for a lightbox feature. Not the best looking out of the box but very functional and you can always style it. -- Ryan On Wed, Jun 3, 2009 at 5:54 PM, Charlie Griefer charlie.grie...@gmail.comwrote: check out one of the many jquery lightbox clones. http://www.no-margin-for-errors.com/projects/prettyPhoto-jquery-lightbox-clone/ http://www.stickmanlabs.com/lightwindow/ On Wed, Jun 3, 2009 at 3:42 PM, Mike Little m...@nzsolutions.co.nz wrote: sorry, could not think of a better subject! i have a form which an admin enters a embed script such as a youtube video. what i would like to achieve is to have a preview button which takes the contents of the textarea (ultimately filters the content with my clever param filter) and displays the output in a popup similar to... http://yensdesign.com/tutorials/popupjquery/ (or alternatively the output displays in a div below the textarea?) i am very new to jquery/ajax and really would like to get into it. unfortunately we have issues with using cf8's ajax features on my hosts shared server and would like to use native jquery/ajax. any help/pointers in the right direction would be really appreciated. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dreaded cfform issue
Working with a cfform here in CF7 and I'm getting a javascript error and none of the validation is happening. Wondering if anyone has seen this one lately? Firefox Javascript Console Error Message: obj.value is undefined http://mydomainhere.com/js/cfform.js Points to this line in the cfform.js: function _CF_hasValue(obj, obj_type, obj_trim) { if (obj_type == TEXT || obj_type == FILE ||obj_type == PASSWORD || obj_type == CFTEXTAREA || obj_type == TEXTAREA || obj_type == CFTEXTINPUT) { if (obj.value.length == 0) return false; else if( obj_trim ) { //trim whitespace - for backward compatability this is optional str = obj.value.replace(/^\s+/,'').replace(/\s+$/,''); if (str.length == 0) { return false; } } return true; Scratching my head. Think it's time to go home. Been a long day. -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreaded cfform issue
Stripped it down to nothing, still didn't work. Needed something real quick and burned again by cfform. Sigh, I'll do it in jQuery tomorrow. thx -- Ryan On Wed, Jun 3, 2009 at 6:44 PM, Gerald Guido gerald.gu...@gmail.com wrote: My bad skimmed the original post. Most often it due to js files not getting loaded or hand rolled js conflicting with CF form. G! On Wed, Jun 3, 2009 at 7:38 PM, Gerald Guido gerald.gu...@gmail.com wrote: It looks like cfform.js is not being loaded. Make sure that the cfform JS files are being included. The fastest way to fix this (in case of an emergency) is to copy the /CFIDE/scripts/ directory to the root of your site or create that dir and copy over cfform.js and other related js files. It is a mapping issue IIRC. HTH G! On Wed, Jun 3, 2009 at 7:22 PM, Ryan Letulle bayous...@gmail.com wrote: Working with a cfform here in CF7 and I'm getting a javascript error and none of the validation is happening. Wondering if anyone has seen this one lately? Firefox Javascript Console Error Message: obj.value is undefined http://mydomainhere.com/js/cfform.js Points to this line in the cfform.js: function _CF_hasValue(obj, obj_type, obj_trim) { if (obj_type == TEXT || obj_type == FILE ||obj_type == PASSWORD || obj_type == CFTEXTAREA || obj_type == TEXTAREA || obj_type == CFTEXTINPUT) { if (obj.value.length == 0) return false; else if( obj_trim ) { //trim whitespace - for backward compatability this is optional str = obj.value.replace(/^\s+/,'').replace(/\s+$/,''); if (str.length == 0) { return false; } } return true; Scratching my head. Think it's time to go home. Been a long day. -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery question
Sorry Mike. I guess I'm not fully understanding where your problem is if you are going to submit form data. Do you want the lightbox to appear automatically after the form is submitted? Why can't you process the submission normally? or are you looking to just submit the script through jquery (i.e load or ajax) to another page and make something happen on your page after it is tweeked? I was not aware that jQuery could communicate directly with a cfc but I am sure someone hear could get that going. I have always communicated with a cfm page which might invoke a cfc. -- Ryan On Wed, Jun 3, 2009 at 7:03 PM, Mike Little m...@nzsolutions.co.nz wrote: thanks guys, my question is though - how to pass formatted content from my textarea to the div upon form submission (or another button submit). ultimately i would like to pass the content to a cfc first to check and amend data as required so this is why i thought jquery would be the way to go. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Looks nice. I'll try it to. :) -- Ryan On Tue, Jun 2, 2009 at 8:51 AM, Scott Weikert li...@alphageek.com wrote: Rob Parkhill wrote: Awesome form protection http://cfformprotect.riaforge.org/ I second that. I've been using CFFormProtect for a while now with good results. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IUM Re: IUM Re: Google Map API
This what I do. Hope it helps: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; xmlns:v=urn:schemas-microsoft-com:vml head meta http-equiv=content-type content=text/html; charset=UTF-8/ script src=http://maps.google.com/maps?file=apiamp;v=2.xamp;key=cfoutput#request.gmapkey#/cfoutput type=text/javascript/script script type=text/javascript var map = null; var geocoder = null; function initialize() { if (GBrowserIsCompatible()) { map = new GMap2(document.getElementById(map_canvas)); map.setCenter(new GLatLng(40.78704, -73.965797), 13); map.setUIToDefault() geocoder = new GClientGeocoder(); } } function showAddress(address) { if (geocoder) { geocoder.getLatLng( address, function(point) { if (!point) { alert(address + not found); } else { map.setCenter(point, 13); var marker = new GMarker(point); map.addOverlay(marker); marker.openInfoWindowHtml(address); } } ); } } /script /head body onload=initialize();showAddress(document.getElementById('geo').address.value); return false onunload=GUnload() cftry form id=geo action=# onsubmit=showAddress(this.address.value); return false p cfparam name=url.address default=414 East 88th Street, New York input type=hidden size=50 name=address value=cfoutput#listfirst(url.address)#, New York/cfoutput / !--- input type=submit value=Show Map / --- /p div id=map_canvas style=width: 400px; height: 500px/div /form cfcatch/cfcatch /cftry /body /html -- Ryan On Sat, May 30, 2009 at 7:50 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi Ryan, I looked at the page again in firefox using the Javascript error console script src= http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey # type=text/javascript/script script type=text/javascript //![CDATA[ function load() { if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById(map)); map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14); map.addControl(new GLargeMapControl()); map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3); var point = new GPoint(#dLatitude#, #dLongitude#); var marker = new GMarker(point); map.addOverlay(marker); } } //]] /script The line: map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3); gives the error: map.centerAndZoom is not a function I removed this line assuming if it was bad the script would stop processing at this point, but still no marker. Jenny -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: 28 May 2009 14:06 To: cf-talk Subject: SPAM-MEDIUM Re: IUM Re: Google Map API I assume you are not getting any javascript errors? -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help with dynamic form fields
Not sure of what you are trying to do, but I usually use getelementbyid when I need to work with form fields. Very straightforward and lots of examples, just Google. w3schools etc -- Ryan On Sat, May 30, 2009 at 8:02 PM, Torrent Girl torrentg...@gmail.com wrote: hello I have an issue that I am stuck on. I need to check the value of dynamic form fields with javascript and don't know how. Here is what the form fields look like: compensationType_userID (this is the field name) The userID will be the dynamic part. How do I check for the value in javascript on the form submission? If compensation type = salary, then do this... Thank you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
That might be a setting in the autocomplete js. There are some default settings in the middle of the js. You are using the one from bassistance right? -- Ryan On Fri, May 29, 2009 at 7:11 AM, Torrent Girl torrentg...@gmail.com wrote: Is there anyway for me change this? possibly in CFIDE somewhere? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
Sorry, no experience there. I use the one you started with. -- Ryan On Fri, May 29, 2009 at 7:50 AM, Torrent Girl torrentg...@gmail.com wrote: Now I am using the coldfusion autosuggest. I nver got that other one to work. That might be a setting in the autocomplete js. There are some default settings in the middle of the js. You are using the one from bassistance right? -- Ryan Is there anyway for me change this? possibly in CFIDE somewhere? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray cg...@careyweb.com wrote: I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to only get one record from TABLE2 when I join? SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID WHERE TABLE1.AlbumID = 1 This query returns 2 records because there are two matches in TABLE2. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query question
add LIMIT 0,1 add the end of the query to only grab the first match -- Ryan On Fri, May 29, 2009 at 9:50 AM, Chad Gray cg...@careyweb.com wrote: Sorry should have mentioned that MySQL -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Friday, May 29, 2009 10:48 AM To: cf-talk Subject: Re: query question what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray cg...@careyweb.com wrote: I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to only get one record from TABLE2 when I join? SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID WHERE TABLE1.AlbumID = 1 This query returns 2 records because there are two matches in TABLE2. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 Unzip an encrypted, password protected .zip
Can anyone point me to a resource to unzip a 256 AES .zip with a password in CF 7? -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IUM Re: Google Map API
I assume you are not getting any javascript errors? -- Ryan On Thu, May 28, 2009 at 7:54 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Umm .. no .. it's in there .. -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: 15 May 2009 13:55 To: cf-talk Subject: SPAM-MEDIUM Re: Google Map API map.addOverlay(marker); missing ; maybe On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: (message bumped with corrected subject ... help !!!) hi all .. trying to get a marker to show on the google map api ... extract of code below .. anyone have any ideas as to why my marker isn't visible, please? tia, jenny cfoutput script src= http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey # type=text/javascript/script script type=text/javascript //![CDATA[ function load() { if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById(map)); map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14); map.addControl(new GSmallMapControl()); map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3); var point = new GPoint(#dLatitude#, #dLongitude#); var marker = new GMarker(point); map.addOverlay(marker) } } //]] /script /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Hacked by Fatal Error
How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Nice Stephane. I did one like this: (Way too much code obviously but it works) cfparam name=city_list default= cfloop query=getCities cfif getcities.recordcount NEQ getcities.currentrow cfset city_list = city_list '' getcities.city ',' cfelse cfset city_list = city_list '' getcities.city '' /cfif /cfloop $(document).ready(function(){ // City dropdowns $(#city).autocompleteArray([cfoutput#city_list#/cfoutput]); }); /script -- Ryan On Thu, May 28, 2009 at 9:08 AM, Stephane Vantroyen s...@emakina.com wrote: I would suggest doing this way : cfquery name=myQueryyour query here/cfquery cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So you have a list in the same format as your example here below; Then you just replace the list (with [ and ]) by cfoutput#myList#/cfoutput in the script Theer are other ways of doing this I'm sure, but that's the one I would use to go faster Stéphane I am trying to use jquery code provided by one of the online samples. The code is below. As you can see the city list is hard coded. I am wondering if I can create my own searchable list from query results and replace the list below with my new list. Thanks for any suggestions. script type=text/javascript $(document).ready(function() { $(#country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(#city).autocompleteArray( [1,2,3,Brighton and Hove,Bristol, Cambridge,Canterbury,Carlisle,Chester,Chichester, Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford, Kingston upon Hull,Lancaster,Leeds,Leicester,Lichfield, Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne, Norwich,Nottingham,Oxford,Peterborough,Plymouth, Portsmouth, Preston,Ripon,Salford,Salisbury,Sheffield,Southampton, St Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield, Wells, Westminster,Winchester,Wolverhampton,Worcester,York], { minChars:1, delay:10, autoFill:true, matchSubset:1, matchContains:1, selectOnly:1 } ); }); /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
How does your source look? -- Ryan On Thu, May 28, 2009 at 9:25 AM, Torrent Girl torrentg...@gmail.com wrote: Thanks The list creation does exactly what I need it to but the cfoutput... does work. It's not giving an error but the autocomplete does nothing. I would suggest doing this way : cfquery name=myQueryyour query here/cfquery cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',', ','all') ] So you have a list in the same format as your example here below; Then you just replace the list (with [ and ]) by cfoutput#myList#/cfoutput in the script Theer are other ways of doing this I'm sure, but that's the one I would use to go faster Stéphane I am trying to use jquery code provided by one of the online samples. The code is below. As you can see the city list is hard coded. I am wondering if I can create my own searchable list from query results and replace the list below with my new list. Thanks for any suggestions. script type=text/javascript $(document).ready(function() { $(#country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(#city).autocompleteArray( [1,2,3,Brighton and Hove,Bristol, Cambridge,Canterbury,Carlisle,Chester,Chichester, Coventry,Derby,Durham,Ely,Exeter,Gloucester, Hereford, Kingston upon Hull,Lancaster,Leeds,Leicester,Lichfield, Lincoln,Liverpool,London,Manchester, Newcastle-upon-Tyne, Norwich,Nottingham,Oxford,Peterborough,Plymouth, Portsmouth, Preston,Ripon,Salford,Salisbury,Sheffield, Southampton, St Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield, Wells, Westminster,Winchester,Wolverhampton,Worcester,York], { minChars:1, delay:10, autoFill:true, matchSubset:1, matchContains:1, selectOnly:1 } ); }); /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Hacked by Fatal Error
Any chance they were an old employee etc that knew the password? -- Ryan On Thu, May 28, 2009 at 9:34 AM, Scott Mulholland smulholl...@aimg.comwrote: I would have considered it strong - 9 chars, letters/numbers/other chars mixed case. The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Thursday, May 28, 2009 10:12 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
So everything works until you change the list? Something must be wrong with the list format. Extra or missing comma. -- Ryan On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote: Would it look like this? cfoutput script type=text/javascript var scriptList = '#myList#'; $(document).ready(function() { $(##country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(##city).autocompleteArray( scriptList, { minChars:1, delay:10, autoFill:false, matchSubset:10, matchContains:10, selectOnly:10 } ); }); /script /cfoutput Have you tried to dump the value of the list to see if it matches the format of the list in the jquery script? You also may wanna try to put the list in a script var and use it : script type=text/javascript var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput; $(document).ready(function() { $(#country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(#city).autocompleteArray(scriptList), { minChars:1, delay:10, autoFill:true, matchSubset:1, matchContains:1, selectOnly:1 } ); }); /script Thanks The list creation does exactly what I need it to but the cfoutput... does work. It's not giving an error but the autocomplete does nothing. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
After you open the page in your browser look at the source for the list. Make sure it doesn't say something like #mylist# :). There must be something off there. -- Ryan On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote: Yes, this is how I am formatting the list cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So everything works until you change the list? Something must be wrong with the list format. Extra or missing comma. -- Ryan On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the best way to handle returning two queries from a component for looping?
Don't feel bad. I never used it either. So at least there's 2 of us. -- Ryan On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth r...@whitestonemedia.comwrote: Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great! Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher ja...@wanax.com wrote: It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Always lookin to save keystrokes. :) -- Ryan On Thu, May 28, 2009 at 11:50 AM, Jason Fisher ja...@wanax.com wrote: LOL, don't you just love finding something new that makes life (or at least coding) easier? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
I second Google Apps. You don't want the spam traffic headache. I am slowly moving everyone off of a mail server that I manage because of spam. -- Ryan On Thu, May 28, 2009 at 7:20 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? Or SmarterMail http://www.smartertools.com/ SmarterMail Professional Edition 5.x - 50 Domains - 250 Users $299.00 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email via cfmail tag goes to junk folder
Can you get the email users to put your from address in their contact list? -- Ryan On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese vvargh...@pace.eduwrote: I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could this be related to the fact that I can't delete or rename files that have been uploaded?
Someone reported the exact same problem either here or on the Railo Group yesterday. Apparently it's a new window's feature. :) -- Ryan On Thu, May 28, 2009 at 9:36 PM, Rick Faircloth r...@whitestonemedia.comwrote: I've run into this curious problem recently, since switching to Windows 7 RC, concerning deleting or renaming uploaded files. I was trying to sort out this problem through a development site when I decided to delete all the files that I had uploaded to my local system and couldn't delete through the browser. Various errors during deleting or renaming keep occuring, such as e:\images\blah.jpg can't be deleted for some unknown reason...and yes, CF says, for some unknown reason. However, after an error was thrown in the browser, I did decide to just delete all the files building up through Windows Explorer. I deleted all but one successfully, and that one I couldn't delete was the last one I uploaded. Windows Explorer threw an error stating, The action can't be completed because the file is open in jrun.exe ??? What does that mean? Is CF ( meaning jrun.exe?) hanging onto the file somehow, which would explain why I can't delete it or rename it as I normally can with CF? Is there a way to force jrun.exe to not keep the file open? Incidentally, after waiting a couple of minutes, I can delete the file normally. Anyone have any ideas or suggestions? If I can't solve this, I've got to rewrite a ton of code and develop workarounds. Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I not use the name variable in cfftp getFile action?
Can't comment on using name but I do use localfile and remotefile for my variable names. I cfset them with the entire path before using the cfftp tag. (i.e cfftp localfile=#localfile# ... I was just doing this about 10 minutes ago. -- Ryan On Wed, May 27, 2009 at 8:34 PM, Rick Faircloth r...@whitestonemedia.comwrote: Why do I get the error, the system cannot find the file specified when I used this line: localFile = f:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\#name# as part of this code: cfftp connection = lskdjf action = getFile passive= yes remoteFile = #name# localFile = f:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\#name# failIfExists= yes timeout= 60 stopOnError = yes It seems, based on the documentation, that localFile ought to be a file that exists already on the local system. However, that doesn't make a lot of sense. There no way to know what the file name will be. And other uses of cfftp getFile have allowed a variable...just name the same name as the remoteFile. I gave it a different name. Can the localFile filename not be #name# ? Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Manipulation Problems with CF8/Win7
Rick, Out of curiosity: you were running production cf on xp and now you are trying to do the same on win 7? -- Ryan On Tue, May 26, 2009 at 6:37 PM, Rick Faircloth r...@whitestonemedia.comwrote: Just let me start with saying that I'm loving using Windows 7...stable, slick, *all* my software runs so much better than in XP (never did used Vista...skipped that party)...however... One issue is really getting on my nerds...whenever I try to run the same code that I've used for years and just recently before switching over to Windows 7 for uploading a new image, creating the various version I need, then deleting the original image, I get errors that CF can't delete the image for some unknown reason. Someone using Win 7 came up with a workaround...putting the image name in a database then running a scheduled task to delete later. It works, but that is a lot of extra coding, processing, etc. I was willing to go that route, if necessary, but... Now, I run into the fact that I can't immediately rename a file I just uploaded. I'm thinking this is the same basic issue as with deleting...Windows 7, perhaps with CF 8, is somehow locking down the file for a period of time (it usually with release control after a little time passes...seconds to minutes) until it allows the file to be deleted or changed. Saving an original, *unused* file's name to a db for scheduled deletion would work...a lot of trouble, but it would work. Preventing me from renaming a file immediately is a no-go. (Perhaps I can copy the file and then rename the copy) Is there anyone testing or working on Windows 7 that has run into these issues (basically one issue) and figured out what's going on and if there is a solution? It's not a problem with the code code...it's the same exact code I was previously running on XP and CF 8...only the OS has changed. I couldn't find anything on Google or other search engines, etc., that addresses this. Anyone have any ideas? Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Manipulation Problems with CF8/Win7
cool, i also have a win 2003 vps but cf7 also a centos railo setup. -- Ryan On Tue, May 26, 2009 at 8:45 PM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, Ryan... No my production server is a VPS with Win 2003 Server and CF 8. In my previous post, I'm referring to my dev setup. On Tue, May 26, 2009 at 7:41 PM, Ryan Letulle bayous...@gmail.com wrote: Rick, Out of curiosity: you were running production cf on xp and now you are trying to do the same on win 7? -- Ryan On Tue, May 26, 2009 at 6:37 PM, Rick Faircloth r...@whitestonemedia.com wrote: Just let me start with saying that I'm loving using Windows 7...stable, slick, *all* my software runs so much better than in XP (never did used Vista...skipped that party)...however... One issue is really getting on my nerds...whenever I try to run the same code that I've used for years and just recently before switching over to Windows 7 for uploading a new image, creating the various version I need, then deleting the original image, I get errors that CF can't delete the image for some unknown reason. Someone using Win 7 came up with a workaround...putting the image name in a database then running a scheduled task to delete later. It works, but that is a lot of extra coding, processing, etc. I was willing to go that route, if necessary, but... Now, I run into the fact that I can't immediately rename a file I just uploaded. I'm thinking this is the same basic issue as with deleting...Windows 7, perhaps with CF 8, is somehow locking down the file for a period of time (it usually with release control after a little time passes...seconds to minutes) until it allows the file to be deleted or changed. Saving an original, *unused* file's name to a db for scheduled deletion would work...a lot of trouble, but it would work. Preventing me from renaming a file immediately is a no-go. (Perhaps I can copy the file and then rename the copy) Is there anyone testing or working on Windows 7 that has run into these issues (basically one issue) and figured out what's going on and if there is a solution? It's not a problem with the code code...it's the same exact code I was previously running on XP and CF 8...only the OS has changed. I couldn't find anything on Google or other search engines, etc., that addresses this. Anyone have any ideas? Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
@will Good deal. Haven't used below but it seems the author has written a nice book about it on his site. Good luck. -- Ryan On Sat, May 23, 2009 at 2:27 AM, Will Tomlinson w...@wtomlinson.com wrote: I think I'm going to use this tool: http://nstree.riaforge.org/ I've been playing around with it. Seems fairly straightforward and does everything I need. I'm just working on what the admin interface would look like to display the entire tree so you could select multiple categories for a given product. Thanks for everyone's input. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
You'd have to escape them or change the outer quotes to single quotes of course. :) -- Ryan On Sat, May 23, 2009 at 7:03 PM, Ryan Letulle bayous...@gmail.com wrote: You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
I know for vb scripts you have to run cscript.exe and pass the path to the vbs in the arguments. -- Ryan On Sat, May 23, 2009 at 8:43 PM, Jason Fisher ja...@wanax.com wrote: Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. So just run this: cfexecute name=f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat / Execute the batch file directly, rather than trying to go via cmd.exe ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Custom Tag
I've got sample code Ryan P LeTulle On May 21, 2009, at 8:09 PM, Torrent Girl torrentg...@gmail.com wrote: That's ok thanks :) I looked and they never posted anything. Sorry about that. Slowly walks away tail tucked. G! On Thu, May 21, 2009 at 8:51 PM, Gerald Guido gerald.gu...@gmail.comwrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Custom Tag
@torrent girlDo you still need it? -- Ryan On Fri, May 22, 2009 at 8:00 AM, Ryan LeTulle bayous...@gmail.com wrote: I've got sample code Ryan P LeTulle On May 21, 2009, at 8:09 PM, Torrent Girl torrentg...@gmail.com wrote: That's ok thanks :) I looked and they never posted anything. Sorry about that. Slowly walks away tail tucked. G! On Thu, May 21, 2009 at 8:51 PM, Gerald Guido gerald.gu...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL - How to create a category tree in a store
@willr u ok with setting a maximum number of levels? -- Ryan On Fri, May 22, 2009 at 10:14 AM, Will Tomlinson w...@wtomlinson.comwrote: This might be useful: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Cheers, Dave Yes, there's a lot of great info there. But it looks like a nightmare if I want to add a node under the parent. Products -baseball --gloves --bats --shin guards -golf --gloves --bags ---nike ---titleist ---ping --shoes If I want to add lacrosse between baseball and golf, that'd be a pain. Wish I could find something easier for this. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
I am assuming you at least have product_id and category_id in your linking table. I think if you added a parent_id accounting for the root level you could build out your tree. Not sure of how you want to go about it but thinking out loud: 1. Query all categories at root level 2. Loop through root level and pull children (all those with a parent as that category) 3. Repeat this for the max levels 4. Pull products at each level (1,2,3,4) Basically you are only assigning one sub/category but you have the hierarchical relationship stored in the db. You would have to account for that when searching on the front end. Front end I would suggest jQuery for an accordion like effect(slidedown/up and/or fadein/out) and pull the products using the ajax or load method. -- Ryan On Fri, May 22, 2009 at 10:41 AM, Will Tomlinson w...@wtomlinson.comwrote: @willr u ok with setting a maximum number of levels? -- Ryan Yep. I could max it out at 4 levels. I had thought about building related tables, 4 of them. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
Also depending on your traffic versus how often the products will get updated versus your hosting plan etc you may want to output the entire tree at the time of it being maintained on the back end rather than every time someone visits the site. Don't know your situation, just an idea if you need to limit hits on the database. -- Ryan On Fri, May 22, 2009 at 11:11 AM, Ryan Letulle bayous...@gmail.com wrote: I am assuming you at least have product_id and category_id in your linking table. I think if you added a parent_id accounting for the root level you could build out your tree. Not sure of how you want to go about it but thinking out loud: 1. Query all categories at root level 2. Loop through root level and pull children (all those with a parent as that category) 3. Repeat this for the max levels 4. Pull products at each level (1,2,3,4) Basically you are only assigning one sub/category but you have the hierarchical relationship stored in the db. You would have to account for that when searching on the front end. Front end I would suggest jQuery for an accordion like effect(slidedown/up and/or fadein/out) and pull the products using the ajax or load method. -- Ryan On Fri, May 22, 2009 at 10:41 AM, Will Tomlinson w...@wtomlinson.comwrote: @willr u ok with setting a maximum number of levels? -- Ryan Yep. I could max it out at 4 levels. I had thought about building related tables, 4 of them. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
I always start my path(s) from the webroot. (i.e. /) In your case it appears that would be /index.cfm FYI Depending on your situation you might want to create a way to set the root path in your app in case you ever install it in a folder other than a webroot.. -- Ryan On Fri, May 22, 2009 at 11:48 AM, Pranathi Reddy rk.prana...@gmail.comwrote: Hi , I am trying to move back one directory and redirect the page to another page. eg: I am at page http:/localhost/Extradirectory/newfile.cfm and I want to redirect to the index.cfm at http:/localhost/newfile.cfm if condition satisfies. I am using cflocation to direct to another page but I am at path /inetpub/project1/Extradirectory/newfile.cfm and my .cfm file is in path /inetpub/project1/index.cfm cfif name ='David' cflocation url=index.cfm /cfif -- it throws an error says file not found. Can any one have any suggestions fro me. Thanks in Advance, Pranathi. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
r u sure this will work the same in all doctypes? -- Ryan On Fri, May 22, 2009 at 12:10 PM, Gonzo Rock gonzor...@gmail.com wrote: back up one directory using ../ or ../../ takes you back two directories etc. On Fri, May 22, 2009 at 9:48 AM, Pranathi Reddy rk.prana...@gmail.com wrote: Hi , I am trying to move back one directory and redirect the page to another page. eg: I am at page http:/localhost/Extradirectory/newfile.cfm and I want to redirect to the index.cfm at http:/localhost/newfile.cfm if condition satisfies. I am using cflocation to direct to another page but I am at path /inetpub/project1/Extradirectory/newfile.cfm and my .cfm file is in path /inetpub/project1/index.cfm cfif name ='David' cflocation url=index.cfm /cfif -- it throws an error says file not found. Can any one have any suggestions fro me. Thanks in Advance, Pranathi. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Perhaps I shouldn't have done this???
Try replacing 127.0.0.1 with the external ip Ryan P LeTulle On May 22, 2009, at 11:37 AM, Rick Faircloth r...@whitestonemedia.com wrote: I was trying to set up CF for FTP operations and, following the instructions in the CFDocs, I went to Security and checked the box to enable Sandbox. (Or whatever it said...I can't get in to read it now!) And there's the problem. Since I enabled the Sandbox setting, I can't even get the CF Administator login page to show up. Going to http://127.0.0.1/cfide/administrator/index.cfm just gets me a blank page. Is that due to the Sandbox setting? And do I need to Enable Sandboxing to use CFFtp? What to do? Thanks, Rick --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Perhaps I shouldn't have done this???
@jochem Nice to know -- Ryan On Fri, May 22, 2009 at 12:31 PM, Jochem van Dieten joch...@gmail.comwrote: Set the sandbox security entry in neo-security.xml to false and restart cf. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect page
where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.comwrote: I can redirect it but have a new problem now ... I am unable to access the session variables.. I have to access the session varaibles declared in newfile.cfm. If I browse separately then I can but if I redirect and work on it it doesnt. Any ideas.. r u sure this will work the same in all doctypes? -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird query behavior
I know this doesn't solve ur issue but ... I have had a few really bad problems similar to this with text fields in the past. I almost rather store a file on my own than use a text data type. Similar to storing an image link. -- Ryan On Fri, May 22, 2009 at 3:00 PM, Justin Scott jscott-li...@gravityfree.comwrote: Exactly the same configuration? With the same settings for Unicode for query parameters and CLOB buffer? Yes, the data source configuration has all of the same settings. The really strange part is that everything has been working fine for weeks since the last code updates that we deployed, and this morning this one server just started having issues. I'll be restarting the entire server later tonight to see if that clears it up (you know, Windows...) or not. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
Hmmm, try cfheader instead of cflocation. Did you say which version of cf u r using? -- Ryan On Fri, May 22, 2009 at 1:17 PM, Pranathi Reddy rk.prana...@gmail.comwrote: /inetpub/project1/application.cfc /inetpub/project1/index.cfm /inetpub/project1/Extradirectory/newfile.cfm Moving from newfile.cfm to index.cfm where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Nested loop problems
Has anyone else seen problems with nested loops in CF7? Outer cfloop query=blah ---Inner cfloop query =blahblah Try to use a variable from the outer query here and it is empty. I have to cfset it to another variable before entering this cfloop and then it is good 2 go. ---Inner /cfloop Outer /cfloop -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Nested loop problems
thx, nice post -- Ryan On Fri, May 22, 2009 at 4:44 PM, Ben Nadel b...@bennadel.com wrote: Ryan, To do that, you have to refer to the outer loop's explicit row: http://www.bennadel.com/blog/546-Referring-To-The-Proper-Row-Of-The-Outer-CFLoop-With-Nested-CFLoops-.htm This has been fixed in ColdFusion 8. -Ben -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect page
show me ur application.cfc -- Ryan On Fri, May 22, 2009 at 8:35 PM, Priya Koya priya23...@gmail.com wrote: I tried but it dont know ... wats wrong .. I am sing coldfusion8. On Fri, May 22, 2009 at 4:37 PM, Ryan Letulle bayous...@gmail.com wrote: Hmmm, try cfheader instead of cflocation. Did you say which version of cf u r using? -- Ryan On Fri, May 22, 2009 at 1:17 PM, Pranathi Reddy rk.prana...@gmail.com wrote: /inetpub/project1/application.cfc /inetpub/project1/index.cfm /inetpub/project1/Extradirectory/newfile.cfm Moving from newfile.cfm to index.cfm where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4