Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Child window updating parent window
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...- JGH
- Post #15
- Forum: Javascript
-
Child window updating parent window
You ARE the Man! Unless you're a girl, in which case you ARE the Woman! Thanks! Jim- JGH
- Post #14
- Forum: Javascript
-
Child window updating parent window
Thanks again. Alas, unfortunately, it didn't work. I tried increasing the delay, but to no avail. Jim- JGH
- Post #12
- Forum: Javascript
-
Child window updating parent window
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- JGH
- Post #10
- Forum: Javascript
-
Child window updating parent window
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...- JGH
- Post #8
- Forum: Javascript
-
MySQL table design style with foreign keys
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. -
MySQL table design style with foreign keys
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... -
Regular expression for preg_match problem
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]); -
MySQL table design style with foreign keys
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... -
Interesting query
But I take it there is no single query that will do this for lists of variable size? Thanks - Jim -
MySQL table design style with foreign keys
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... -
Interesting query
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... -
MySQL Query sorting problem, using JOINs and GROUP
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 -
MySQL table design style with foreign keys
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... -
MySQL Query sorting problem, using JOINs and GROUP
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... -
Regular expression for preg_match problem
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... -
MySQL Query sorting problem, using JOINs and GROUP
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... -
CSS programming style - universal selector
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...- JGH
- Thread
- Replies: 2
- Forum: HTML, XHTML & CSS
-
MySQL Query sorting problem, using JOINs and GROUP
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 -
MySQL Query sorting problem, using JOINs and GROUP
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...
