Recent content by JGH

Hold it... I got too excited too quickly. You are still definitely the [Wo]Man, because you've been so patient and persistent. But I realized as I used the JS in the pages I needed it, that it doesn't reload the parent page. And when I added the...

You ARE the Man! Unless you're a girl, in which case you ARE the Woman! Thanks! Jim

Thanks again. Alas, unfortunately, it didn't work. I tried increasing the delay, but to no avail. Jim

Thanks. That is basically what I did with openerform, saving the whole form object, sendmessage. In any event, I tried your code and it yielded the same results as mine. Thanks - Jim

I have a similar issue with child and parent windows: I want to - via the child - reload the parent that has form fields, and preserve the values entered into the fields. The code below does simliar to that except (for testing purposes) prepends "hi" to the text field's data. As intended, it...

Are you saying the way to do it is as a many-to-many, or that spices in a rack are a many-to-many? Spices was an arbitrary example that turned out surprisingly controversial.

Guys guys guys... Settle this outside in the back alley. Has the Expert SQL Council reached a consensus on which table should store the default value for a one-to-many table relationship (if it is, indeed, a relationship)? Is it the SpiceRack table, the Spice table (for which there are no...

Try this. I havent tested it though. The ^ inside the brackets should be the negation you seek... $line[$x] = preg_replace('/([^a-zA-Z]+)/i', '', $line[$x]);

Okay, I think we're overanalyzing the spices (and getting off topic, but at least it's educational :). My question was about where to declare the default value. It doesn't have to be spices in a spice rack. It could be people in a family household, where it is a one-to-many relationship. (We...

But I take it there is no single query that will do this for lists of variable size? Thanks - Jim

Thanks sleipnir. I think I haven't asked the best question... The Spice table, as noted, would have a rackID column, so we know to which racks each spice belongs. So if a spice is set to isDefault, it would be the default to whichever rack its rackID points to. I probably wasn't clear enough...

Glad this topic came up.... Is there a single query that be done for a table designed like a linked list, where ordering is dictated only by the parent: id | name | parent | ------------------------- 1 | First | 0 | 2 | Second | 1 | 3 | Fourth | 5 | 4 | Fifth...

Thanks again, Rudy. You're on fire! I just have to wait for my server admin folks to upgrade my MySQL above 3.23 so that I can use subqueries. In the meantime, I could relent and just do two separate queries. :) Thanks - Jim

I just wondering what proper (My)SQL style would be for the following situation (which I made up for the sake of this)... You have a SpiceRack table and a Spice table. Each rack has many spices, in typical one-to-many fashion. So the Spice table would have rackID column. Easy. But let's say...

Thanks Rudy, The query was simplified for the sake of not getting distracted with the rest of my query, as I tried to identify where exactly things were going wrong. But I guess I should show all my cards... What I wanted to do was get all the rows with the earliest date per threadid and...