A virtual beer to the man in the corner - worked a treat. Nice touch
- a happy customer right before Christmas!!!
Thanks Rudy,
M.
Quoting r937 :
>> Basically the query is sound ...
>
> sorry, no, not quite
>
> here's what i saw...
>
>> WHERE icons.iconId = resourceTypes.resourceTypeIconId
>>
Looks great Rudy, I'll try it as soon as I can.
Happy Christmas Everyone!
M.
Quoting r937 :
>> Basically the query is sound ...
>
> sorry, no, not quite
>
> here's what i saw...
>
>> WHERE icons.iconId = resourceTypes.resourceTypeIconId
>> AND resources.resourceTypeId = resourceTypes.resourceTy
Basically the query is sound ...
sorry, no, not quite
here's what i saw...
WHERE icons.iconId = resourceTypes.resourceTypeIconId
AND resources.resourceTypeId = resourceTypes.resourceTypeId
AND categories.categoryId = resource2category.categoryId
AND resources.resourceId = resource2category.r
Quoting r937 :
> matt, did you ever get this resolved? the answer is real easy
In a manner of speaking. Basically the query is sound (although if
there's a better way of doing it, please let me know!) and there was
an issue with the PHP loops behind printing the results.
>
> sorry i did no
matt, did you ever get this resolved? the answer is real easy
sorry i did not reply sooner, but for some reason wdvltalk mail often ends
up in my spam bucket, and i only go in there once a week (or less) just to
double-check the false positives
if you ever have sql problems, please feel free
I normally work in MS SQL and not MySQL so I could be wrong, but it seems that
you should have some joins happening between the tables instead of having this
in the Where clause:
icons.iconId = resourceTypes.resourceTypeIconId
AND resources.resourceTypeId = resourceTypes.resourceTypeId
AND categ
Quoting Riva Portman :
> Can you post a list of the results?
Not the exact results, no because it's client-confidential, however
the above query effectively generates the following format:
1) Article 1 - published on 18/12/2008 by Me
This article deals with waste and the legal issues that
Can you post a list of the results?
Riva
On 12/18/2008 8:10 AM, Matthew Macdonald-Wallace wrote:
Hi All,
Can someone please explain why the following query returns a number of
search results for each article instead of a single copy of each
article that matches?
SELECT DISTINCT resources.r
Hi All,
Can someone please explain why the following query returns a number of
search results for each article instead of a single copy of each
article that matches?
SELECT DISTINCT resources.resourceId,
resourceTitle,
extract,
iconPath,
iconName,
resourceTypes.resourceTypeId,
resources.res
Slow response (just got back from holiday) but might still be relevant...
steve miller wrote:
The problem I am having is when I try to search for a user with a string
that has a ' or a " in it, because the sql throws an error.
The id inserted into the query, so I end up with something like:
s
I am working with an existing database table that holds user
information identified by strange id strings. The id strings are
created by another application, so I can not change them, but I need
to be able to query the table using them as reference. Each ID is a 3
character string like:
I shoudl really learn myself..
let me paly, and if still can;'t get it, I'll be back on Monday..
with more info...
Cheers for your help though!!!
On 20/10/06, r937 <[EMAIL PROTECTED]> wrote:
> I tried that, but it caused an error...
then you added it in the wrong place, and unfortunately my
how can I add a 'WHERE product.ethical = '1'?
by adding it after the FROM clause, just before the ORDER BY clause
I tried that, but it caused an error...
Here's my query:
SELECT distinct products.id,
try it without DISTINCT
Cause duplicated galore!
inner join categories as child
o
Finally...
How can I filter on products...
(there's a 1/0 field in the products table, that flags if the product
is ethically made.)
how can I add a 'WHERE product.ethical = '1'?
I tried just before the first inner join, but I got an error...
Here's my query:
SELECT distinct pro
Quoting r937 <[EMAIL PROTECTED]>:
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns,
productid and categoryid
the reaso
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns, productid
and categoryid
the reason? because sql like this...
W
Hi all...
I've not been here for AGES... but I hope many of you trusted clever
people are still out there... I need help! ;-p
I'm building a shop for a client.
I've got 3 tables I'm trying to talk to.
products
stock
categories
- Each product can be flagged with any numebr of cateogories using
Hi,
I am trying to get records from a database within a date range
something like 1834-1835. I have written a simple query like "Select *
from db where date between 1834 and 1835;"
But, the problem is that the date field is not consistent in the
database, the records have dates like
April 5, 18
18 matches
Mail list logo