I'm trying to add a request variable "VARbrand" to my SQL query like so

SELECT *
FROM [tblBrands Query]
WHERE tblBrands_BrandId = "VARbrand"
ORDER BY BrandName

but I keep getting a "too few parameters" error when testing the query.

Can anyone help.

Am I actually going about this the right way. I have a column of brands on the left hand side & I'm trying to have them dynamically bring back only records with that brand name. So I'm setting up a request variable in the query that only brings back the selected brands in my recordset...

is that the correct way of doing this.

Thanks

Edited by - webstar on 15 Jun 2003 14:49:58

If the brand id is numberic dont put quotes around your variable, and if it is text, use single quotes.



Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Excellent, thanks but now another prob has appeared...

The Query now tests ok but when I create a repeating table from this new dynamic record set the page does not display at all. does this mean that there is no value being passed into the query.

Sorry but I'm very new to MX and asp, SQL

Thanks for your reply

Is it totally blank or your data just isn't being displayed?

The page doesn't load at all & I get an error message. I'm at work right now so I can't give you a note of what the error message is.

I'll post the error message in 2 hours when I get home.

Thanks again for the reply

here's the error which I get on a "page cannot be displayed"

Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
products.asp, line 7, column 12
If (Request('varBRAND') <> "" Then
-----------^

HA Ha no it's ok I've got it - I was still leaving an "" in the variable

Thanks for all your time taken to reply.

Many Thanks

Edited by - webstar on 16 Jun 2003 19:10:02

Edited by - webstar on 16 Jun 2003 21:58:31