Search results for query: *

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...

I am trying to pluck out text found within the outermost brackets %[ and ] (the first bracket preceded by a % sign). I want to be able to next %[...] within each other, if necessary. I thought that the following would do the job, but alas my regex shortcomings have been exposed. if...

Ah. A new complication. This isn't a result of Tony's fine code above, but some strange problem relating to GROUP BY. Ordering the below SELECT with "ORDER BY date DESC" and "date ASC", the result is the same. It's a single row that is neither the oldest nor the most recent. Without "GROUP BY...

Okay, CSS isn't a programming language, but you get the idea... Today I was getting acquainted with the universal selector (*) in CSS, and was wondering what is approrpiate use/good programming style with this all powerful selector? For instance, most of my sites use the same font-family for...

Thanks, Tony! I tried in the ORDER BY clause using "MAX(msg.date) DESC" and it always yelled at me. But your way worked perfectly! Thanks again - Jim

Hi folks - I have a forum that uses two tables to maintain the threads and messages and I want to list all the threads in descending order of the most recent post. Below is the query I have been using. I think the naming makes it obvious what's what, but basically there is a table called...