Sorry... I was having a brain fart. (I use entries in the web.xml file
to generate a dropdown list of cuisines). The field cuisine is part of
the restaurant table. And it does not accept a null value. It should
be split out into it's own table.
I do need to get a SUM of all the values retu
Given the following query, how can it be modified to return 'Cuisine'(s)
that have no rows as having a count of zero and also return a SUM of
COUNT(*)?
SELECT w.WebsiteName, r.Cuisine, COUNT(*)
FROM Restaurant r
JOIN RestaurantWebsites w
ON r.RestaurantID = w.RestaurantID
WHERE w.WebsiteName =
I have the following query which display every Cuisine in the database
sorted by the WebsiteName.
How can I modify this to get a COUNT of the number of records in each
Cuisine in each WebsiteName?
SELECT DISTINCT Restaurant.Cuisine, RestaurantWebsites.WebsiteName
FROM Restaurant
INNER JOIN R
A couple of months ago these was a discussion about ZIP code plotting on
this list. Does anyone know how to calculate LONG/LAT coordinates from
ZIP+4?
Thanks,
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
My thanks to all that responded. I used Mathias's suggestion to solve
the problem. You can see the results here.
http://www.tasteofwhatcom.com/restaurants-tow/filter.jsp?field=city&value=Blaine
Thanks again for your help.
Jack
Mathias wrote:
Selon Jack Lauman <[EMAIL PROTECT
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change this so that if the 'Name' field begins with "The " that
the sort begins on the second word? In other words I'd like to be able
to return the word "The" but have it
I want to run a nightly cron job where you iterate throught each row of
a single table and reset a field depending on the conditions specified.
In this case I want to take a date field (RenewalDate) and compare it
to the current date less a 30 day grace period and if true reset the
(Subscripti
I have a table containing information about different businesses. I
want to randomly select a single row from the table using a prepared
statement in a java bean.
What is the most eficient way to do this?
TIA
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and account_id
contact has a PK of contact_id
I to select all the columns in contact where account_id=13
I tried:
SELECT * FROM (contacts INNER JOIN account on contact.contact_id =
account.account_i
I have a table with a column "date" that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns all of the desired
Camera ready means the a commercial printer cn go direct from the
provided document(s) to negatives/plates or direct to plate without
having to modify the originals in any way.
Save a lot of money in make up and AA charges.
Jack
Andrew Gould wrote:
>
> Please forgive my ignorance; but what is
Under the laws of the State of Washington spamming is illegal.
RCW 19.190.040
Violations -- Damages.
(1) Damages to the recipient of a commercial electronic mail message
sent in violation of this chapter are five hundred dollars, or actual
damages, whichever is greater.
(2) Damages to an intera
I'm getting the following error when I try to install the 3.23.36 RPM's
on a P3-450 RedHat 7.0 box.
I'd appreciate any suggestions.
Starting mysql daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 258: 8692 Segmentation fault (core dumped)
$NOHUP_NICENESS $ledir/$MYSQLD $defau
13 matches
Mail list logo
