MySQL - How to create a category tree in a store

I built a store application that has a simple product category schema. Right now, the user can select one or more categories to associate to a given product. I have a linking table in between those two tables that resolves the many-to-many. Now, I need the ability to let the user create

Re: Dreamweaver CS3 Mac issues with opening files/changing code

On Sat, Feb 9, 2008 at 8:40 AM, Scott Weikert cf-t...@alphageek.com wrote: Hey gang - I've googled around a fair bit, poked in the prefs, but no love yet. Hence, this post. I recently picked up a new Mac tower (sweet!) and I've got Dreamweaver CS3 loaded up. All works fine except for one

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

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

Re: MySQL - How to create a category tree in a store

This might be useful: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Cheers, Dave I built a store application that has a simple product category schema. Right now, the user can select one or more categories to associate to a given product. I have a linking table in

Re: MySQL - How to create a category tree in a store

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

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.

Re: MySQL - How to create a category tree in a store

@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

Re: Checking for Existence of RSS.CHANNEL.ITEM

structKeyExists should work. Can you show me how you are using it? I don't see it below. I see you check the length: cfset Item_Length = arraylen(objRSS.rss.channel.item) / did you first check to see if rss exists in objRss, and channel exists in objRss.rss? On Tue, May 19, 2009 at 1:11 PM,

Variable naming and reserved scope names.

In the Live Docs - ColdFusion Developer's Guide, under the subject Using scopes, you will find the following quote: Because ColdFusion must search for variables when you do not specify the scope, you can improve performance by specifying the scope for all variables. I have always taken this

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

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

Re: Variable naming and reserved scope names.

On Fri, May 22, 2009 at 12:00 PM, John Morgan gamec...@gameczar.net wrote: 1. Does the same thing happen in CF7 and CF8? Since you didn't say what happens in CF7, I don't know. 2. Why doesn't ColdFusion stop searching after checking the session scope, as implied by the Live Docs statement.

redirect page

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

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

RE: redirect page

You hav eto go up one directory,try: cfif name ='David' cflocation url=../index.cfm /cfif -- Marius -Original Message- From: Pranathi Reddy [mailto:rk.prana...@gmail.com] Sent: May 22, 2009 12:48 PM To: cf-talk Subject: redirect page Hi , I am trying to move back one directory and

Re: Variable naming and reserved scope names.

Ok here is the output in CF7 session.type = I live in the form scope. session.cftoken = 72624939 [form scope - struct ] [SESSION][form scope - struct ] [TOKEN ][bogus token ] [TYPE ][I live in

Re: redirect page

Thanks alot... Marius.. It worked You hav eto go up one directory,try: cfif name ='David' cflocation url=../index.cfm /cfif -- Marius 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

Perhaps I shouldn't have done this???

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

Re: redirect page

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.comwrote: Hi , I am trying to move back one directory and redirect the page to another page. eg: I am at page

Re: Variable naming and reserved scope names.

On Fri, May 22, 2009 at 12:56 PM, John Morgan gamec...@gameczar.net wrote: Ok here is the output in CF7 It's the same in CF8. For the record, I completely agree with you. But still it is disterbing that ColdFusion doesn't stop searching for type beyond the session scope. It would be a

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:

Re: Perhaps I shouldn't have done this???

Don't know about what sandboxing did to your server as I have never had to use sandbox security on a ColdFusion server. I suspect you somehow sandboxed your server in such a way that it no longer has permissions to be a ColdFusion server. But I use cfftp... all the time, so that should

Re: Perhaps I shouldn't have done this???

I had never used it before, either, but the docs said it *had* to be enabled, so like an idiot, I just believed what it said and sandboxed the server. Now the server is offline and I can't get it restarted... Other suggestions, anyone? Rick On Fri, May 22, 2009 at 1:15 PM, Ian Skinner

Re: Perhaps I shouldn't have done this???

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

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

Re: Perhaps I shouldn't have done this???

Thanks for the tip, Jochem. I did manage to get the server back up. Rebooted and it came back up. Sandbox is *unchecked* again! (This is a dev box) I'll store your advice away for future reference, however! Thanks, Rick On Fri, May 22, 2009 at 1:31 PM, Jochem van Dieten

Re: Perhaps I shouldn't have done this???

Thanks for the tip, Ryan...a reboot seemed to clear things up and let me back in to CF Admin... On Fri, May 22, 2009 at 1:33 PM, Ryan LeTulle bayous...@gmail.com wrote: Try replacing 127.0.0.1 with the external ip Ryan P LeTulle On May 22, 2009, at 11:37 AM, Rick Faircloth

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/

Re: Perhaps I shouldn't have done this???

Rick Faircloth wrote: Thanks for the tip, Ryan...a reboot seemed to clear things up and let me back in to CF Admin... So now that you are back into your CF Admin... what documentation said you had to have sandbox security to do cfftp?

Re: redirect page

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

Re: Variable naming and reserved scope names.

For reference, ColdFusion checks the scopes in the following order when it can't find a variable. 1. Function local (UDFs and CFCs only) 2. Arguments 3. Variables (local scope) 4. CGI 5. Cffile 6. URL 7. Form 8. Cookie 9. Client (from:

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

Re: Variable naming and reserved scope names.

(from: http://livedocs.adobe. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=0914.htm ) I just reread the quote Because ColdFusion must search for variables when you do not specify the scope, you can improve performance by

Re: redirect page

/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.comwrote:

Re: Dreamweaver CS3 Mac issues with opening files/changing code

Oh I've been through this. What the issue is is, DW *hates* p tags without closing /p tags. And opening a file with p tags, it will sometimes rejigger perfectly valid tags. Lost count of how many times I would start with /cfcase /cfswitch in my code and then save my changes, to find that

Re: Dreamweaver CS3 Mac issues with opening files/changing code

Casey Dougall wrote: In preferences, code Rewriting make sure fix invalidly nested and unclosed tags is UnChecked. Also, never rewrite code: .cfm should be listed in the filetypes. Does that work for you? Because on my copy of DW CS3, I've had that option unchecked for months... but

Weird query behavior

Ok, here's a really odd one. Today one of our ColdFusion servers started getting really slow responses from queries that include a particular table from the database. Any query that doesn't query that table runs fine. First thought is that something with that table is screwy. However, running

Re: Weird query behavior

On Fri, May 22, 2009 at 9:42 PM, Justin Scott wrote: First thought is that something with that table is screwy.  However, running the same query against the same database from a different ColdFusion server (same version, jvm, configuration, etc.) returns the result normally. Exactly the same

RE: Weird query behavior

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,

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

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

Re: Perhaps I shouldn't have done this???

Here you go...straight from the docs at the link below... Performing file operations with cfftp The cfftp tag lets you perform tasks on remote servers using File Transfer Protocol (FTP). You can use cfftp to cache connections for batch file transfers when uploading or downloading files. Note:

Re: Perhaps I shouldn't have done this???

Rick Faircloth wrote: Here you go...straight from the docs at the link below... Performing file operations with cfftp The cfftp tag lets you perform tasks on remote servers using File Transfer Protocol (FTP). You can use cfftp to cache connections for batch file transfers when uploading or

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

Re: Nested loop problems

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

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

Re: Perhaps I shouldn't have done this???

I've used cfftp in the past and never used sandboxing...and I've disabled it now and the cfftp is working perfectly. Perhaps that's just a precaution for someone hosting sites using CF and allows users to use functionality that uses cfftp? On Fri, May 22, 2009 at 5:13 PM, Ian Skinner

Re: redirect page

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

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

Re: redirect page

I figured it out .. i was deleting the sessions at the index.cfm so sessions are cleared Sorry I wasted your time Pranathi... show me ur application.cfc -- Ryan ~| Want to reach the ColdFusion community