Dear Mat, Your mail is not very clear. But I have a feeling that using '%' wildcard in the like operand should help you....
Regards, Ravi. On 11/14/07, Matthew Stuart <[EMAIL PROTECTED]> wrote: > > Hi, I have built a site with Dreamweaver and I have a problem with a > query. > > I am trying to pass a parameter from one page to another to drill > down. Basically, I have one product entry that is in multiple > categories on my website. So, say it's a dress, it is therefore > related to category 1 which is 'Girls', but it is also more > specifically related to category 2 which is 'Girls Dresses'. > > The way I have set this up is to have a column called MultiCategoryID > that holds both the number 1 and 2 like this: /1/2/ > > When a user clicks a link to look at dresses, the parameter 2 is > passed, but my query on the result page is wrong in some way because > no records are displaying even though there is content to display. > This is what I have so far: > > SELECT * > FROM Products > WHERE MultiCategoryID LIKE '/catdrill/' > ORDER BY ProductID DESC > > The parameter settings are: > Name: catdrill > Type: Numeric > Value: Request("MCID") MCID is the url parameter being passed > Default value: 2 > > Only when I test the Default value with an exact match of /1/2/ does > any product display. What have I done wrong here? Is there a way to > get it to recognise that I want it to pick specific numbers between > the slashes rather than the whole lot? I have tried to change the > slashes to full stops just in case they are causing problems, but > it's still giving the same problem. > > Thanks. > > Mat > >