Search results for query: *

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

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

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

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

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

Hello! I'm writing a form validation script that's supposed to iterate through each of the fields in a form and look for tags that contain a custom attribute called validation_style. A sample tag looks something like: <input name="population" type="text" validation_style="numeric"> My...