Search results for query: *

Oh shoot, I really mangled the subject. Sorry.

Hello! This is a totally newbie DTD question. Let's say that I have the following XML: <?xml version="1.0" encoding="utf-16"?> <root> <person> <name>John Doe</name> <pets> <pet> <name>Fluffy</name> <type>cat</type>...

r937, You had it correct! I didn't copy your query properly. Great job!

FANTASTIC!! Your solution worked perfectly, except that some of the columns were duplicated in my results. It was pretty easy to solve though. Here's the final query. Thanks for teaching me about CROSS JOIN! SELECT domains.domain,weeks.week, visitors FROM ( SELECT DISTINCT domain...

r937, thank you so much for the detailed response! I don't actually have a domains table or a weeks table. All I have is a domain_report table which has the fields: week, domain, and visitors. So I'm most interested in your second solution. Just to reiterate your solution with some minor...

Hello, I'm building a report for a client who wants to know how many visitors are reaching his site based on the domain name entered by the visitors. For instance, some visitors may type in "foo.domain.com","domain.com", or "mobile.domain.com". The report needs to be broken down by week and...

Hello! Thank you for the responses. I have some follow up question. First, though, I wanted to clarify that fluffy is a cat, not a dog. :-) Quite honestly, I can't make heads or tails of the ANSI compliant version. What's bi_stg_8.ti? Well, anyhow, I've been focused on this proposed...

Hello! Say I have the following tables: Pets ===== id - integer (pk) name - varchar type - varchar notes ===== id - integer (pk) pet_id - integer (fk) note_text - text date - date/time I'd like to query for pets of type "dog", and I'd like the query to also return the most recent note...

Fantastic! I never knew that existed!

Hello! I'm having some trouble getting my syntax right. Here's my original query: SELECT name, longitude, latitude, address, id, created, image,(((acos(sin(($latitude*pi()/180)) * sin((latitude*pi()/180)) + cos(($latitude*pi()/180)) * cos((latitude*pi()/180)) * cos((($longitude -...

Thanks mrdenny, I was using outer joins because I wanted visitor rows to show up regardless if they were associated with a campaign. I'll see what happens if I count(ctokens.ctoken) instead. I must admit, although I can handle simple queries, these big ones are a mystery. Are there any good...

Hello! I have a follow up question. The query above seemed to work fine and I'm trying to extend on it. I'm trying to list out the number of visitors coming in to the site with a specific uuid. The list should also contain the campaign name if it exists, or NULL otherwise. In my previous...

I'll have to follow up tomorrow to be certain, but I think that's it! I'll have to read up on my inner joins to understand exactly what's going on. Thanks! - Bret

Hello! I keep running into situations where I use the "in" operator which results in really _slow_ queries. I need to find a graceful way to work around it. Here's my example.. We have a table called "campaigns" (for marketing campaigns) and another table called "tokens" (representing uuids...

Excellent! It works great! Thanks!

Hello! I've got a large database (500,000+ rows) of website visitor data. Most of my queries have gone smoothly so far, but this one eludes me. I've figured out how to display all the unique visitors who've visited the site more than 2 times. The query looks like this: SELECT visitor_id...

Hello! I'm trying to position a javascript tool-tip based on the position of a button. I found this code online for finding the y-offset of the button: function findPosY(obj) { var curtop = 0; if (obj.offsetParent) { while (obj.offsetParent) {...

Execellent! Thanks for all of the feedback. I've learned a lot on the subject! - Bret

theniteowl, Thanks a ton for all of your help! I checked out Jemminger's form validation. Normally I'd totally use it, but at the moment I'm coding in coldfusion and his library and the cfform (coldfusion's form tag) don't play well together. I was intrigued by his technique of using the...

I take it back.. actually, I think this code is working only for IE. I can't get it to work for either Opera or Mozilla Firefox. :-( Any suggestions?