Hi Guys

I have this SQL statement on a page which contains a list of printers:
SELECT *
FROM Products
WHERE (BOSSFCode = 43150 OR BOSSFCode = 43170) AND Description LIKE '%MMColParam%'

MMColParam is set to Hewlett, which is the printer in question i am working with on the list.

There are two kinds of printers - laser (43170 in the bossfcode list) and Inkjet (43150) and so this statement is asking for all of printers from Hewlett, in both kinds.
When i hit Test, the correct results show, but when I go through to the details page (my go to details page behaviour passes on URL Paramater bossfcode) ALL printers show. I do not have a table column with the brand names in it, so i am using the LIKE to pull the word Hewlett from ther description field.
Does anyone know why the correct results arn't showing? What do i need to Go To Details page with? Or is the problem the recordset on my details page? It is set to this:
Simple:
Filter BOSSFCode
=
URL Parameter
BPSSFCode

Thanks.

Try this on your detail page:
go to: Server Behaviours, then select "Recorset Paging" and the option "Move to Specific Record" apply this to the recordset you are using to display the results.

Do the same on the page where your link to go to detail page is.

Javier

I tried that, thank you, but still no luck.....

Hi

I think your problem is with the 'OR' statement. When I've used the 'OR' i've had similiar problems, so i used multipal LIKE and = statements with appropriate MMColParam variables.

Or

You could try replacing 'Hewlett' with '%' as a default value.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi Guys

I have this SQL statement on a page which contains a list of printers:
SELECT *
FROM Products
WHERE (BOSSFCode = 43150 OR BOSSFCode = 43170) AND Description LIKE '%MMColParam%'

MMColParam is set to Hewlett, which is the printer in question i am working with on the list.

There are two kinds of printers - laser (43170 in the bossfcode list) and Inkjet (43150) and so this statement is asking for all of printers from Hewlett, in both kinds.
When i hit Test, the correct results show, but when I go through to the details page (my go to details page behaviour passes on URL Paramater bossfcode) ALL printers show. I do not have a table column with the brand names in it, so i am using the LIKE to pull the word Hewlett from ther description field.
Does anyone know why the correct results arn't showing? What do i need to Go To Details page with? Or is the problem the recordset on my details page? It is set to this:
Simple:
Filter BOSSFCode
=
URL Parameter
BPSSFCode

Thanks.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks guys, got this one sorted, meant to post back and say. my bad.