Still no answer :-(

[Andy]

Please see post "Sorry to repost, but couldn't find the answer!" 08/04/2005

I still can't get this to work. Thanks Jules, i changed it but still get the
'too few parameters expected 1.

Help!
Andy

[RobGT]

I can't see your post but the error you mentioned can sometimes be caused by
an incorrect column name.
i.e. You request a column called "Descirption" when it should have been
"Description" - that can do it.
Referencing a column that simply doesn't exist can have the same effect.

Check and double check your database column names to make sure that what
you're asking for exists, and thenmake sure you're asking for it right :)

HTH
Rob
[url]http://robgt.com/[/url]

[Andy]

Ok thanks Rob
I'll double check and post back

Thank you!

Andy


"RobGT" <rob@lighthouseuk.removeme.net> wrote in message
news:d3g1nj$qa3$1@forums.macromedia.com...

>I can't see your post but the error you mentioned can sometimes be caused
>by an incorrect column name.
> i.e. You request a column called "Descirption" when it should have been
> "Description" - that can do it.
> Referencing a column that simply doesn't exist can have the same effect.
>
> Check and double check your database column names to make sure that what
> you're asking for exists, and thenmake sure you're asking for it right :)
>
> HTH
> Rob
> [url]http://robgt.com/[/url]
>
>
>

[Andy]

Hi again Rob
I've checked the table fields and they're all correct. I created the sql
through access so there's little room for typos.

Here is my original post and code below.

What i'm trying to do is filter the recordset on the category and the user.
The user is identified through the Request.Cookies("ckusername") from the
log in page. I'm not sure if this is the correct way to do it.

Thanks again Rob


SELECT category.CategoryID, category.Category, category.Category_Image,
category.Category_Text, products.ProductID, products.CategoryID,
products.Product_Title, products.Product_Description,
products.Product_Image, products.Product_Price, Prices.ID, Prices.UserID,
Prices.ProductID, Prices.Price, retailers.UserID, retailers.Retailer_Name,
retailers.Retailer_Logo, retailers.username, retailers.show_prices
FROM retailers INNER JOIN ((category INNER JOIN products ON
category.CategoryID = products.CategoryID) INNER JOIN Prices ON
products.ProductID = Prices.ProductID) ON retailers.UserID = Prices.UserID
WHERE category.categoryID = MMColParam1 AND retailer.Retailer_Name =
MMColParam2

MMColParam1 2 Request("CategoryID")
MMColParam2 andy Request.Cookies("ckusername")

When i test the RS i get the 'too few parameters. Expected 2




"Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
news:d3g2og$rpp$1@forums.macromedia.com...

> Ok thanks Rob
> I'll double check and post back
>
> Thank you!
>
> Andy
>
>
> "RobGT" <rob@lighthouseuk.removeme.net> wrote in message
> news:d3g1nj$qa3$1@forums.macromedia.com...

>>I can't see your post but the error you mentioned can sometimes be caused
>>by an incorrect column name.
>> i.e. You request a column called "Descirption" when it should have been
>> "Description" - that can do it.
>> Referencing a column that simply doesn't exist can have the same effect.
>>
>> Check and double check your database column names to make sure that what
>> you're asking for exists, and thenmake sure you're asking for it right :)
>>
>> HTH
>> Rob
>> [url]http://robgt.com/[/url]
>>
>>
>>

>
>
>
>

[RobGT]

The only thing I see straight away is I think you have a data type mismatch.

WHERE category.categoryID = MMColParam1 AND retailer.Retailer_Name =
MMColParam2

MMColParam2 should be "quoted" as it will contain a text value not a number.

See what you get then?

As regards using the cookie - are you using the built in authentication
server behaviours?
If so, you might be better off (maybe) using one of the Session variables
that it creates for you: Session("MM_Username")

Cheers,
Rob
[url]http://robgt.com[/url]

[Julian Roberts]

You still need to delimit parameters for text fields with a single quote.
See

[url]http://www.w3schools.com/sql/sql_where.asp[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Andy]

Hi Rob
Thank you so much for your help.

I re-built the SQL statement and used the quote around the retailer_name and
it works :-)
Yes i am using the built in authentication server behaviours.

Could you explain why it might be better to use the session variable instead
of the cookie?

Cheers again!

Andy

"RobGT" <rob@lighthouseuk.removeme.net> wrote in message
news:d3g68n$3hp$1@forums.macromedia.com...

> The only thing I see straight away is I think you have a data type
> mismatch.
>
> WHERE category.categoryID = MMColParam1 AND retailer.Retailer_Name =
> MMColParam2
>
> MMColParam2 should be "quoted" as it will contain a text value not a
> number.
>
> See what you get then?
>
> As regards using the cookie - are you using the built in authentication
> server behaviours?
> If so, you might be better off (maybe) using one of the Session variables
> that it creates for you: Session("MM_Username")
>
> Cheers,
> Rob
> [url]http://robgt.com[/url]
>
>
>

[RobGT]

Hi Andy,

>Could you explain why it might be better to use the session variable
>instead of the cookie?

Well, I suppose it doesn't really matter to be honest. In fact, if it's
working using the cookie, then that might be the better option thinking
about it as you are less likely to get session timeout issues with it not
being in a session.

If I were you, I'd leave it as is :)

Cheers,
Rob
[url]http://robgt.com/[/url]

[Andy]

Hi Jules
Yes, you're right. I did use the single quote around the text field. There
must have been something else wrong with it though.
I rebuilt it and it works fine now. Strange, but thats me :-)

Thanks again Guys very much appreciated!

Andy


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3g6mo$45c$1@forums.macromedia.com...

> You still need to delimit parameters for text fields with a single quote.
> See
>
> [url]http://www.w3schools.com/sql/sql_where.asp[/url]
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>

[Lionstone]

Session (temporary) cookies are less likely to be blocked. Session timeout
issues are extremely easy to eliminate. It's one web server setting or one
line of code. Big deal.

--
-------------------------------------------------------------------
You must SHOW YOURSELF to e-mail me. No cowards allowed!




"RobGT" <rob@lighthouseuk.removeme.net> wrote in message
news:d3ga48$97b$1@forums.macromedia.com...

> Hi Andy,
>

> >Could you explain why it might be better to use the session variable
> >instead of the cookie?

>
> Well, I suppose it doesn't really matter to be honest. In fact, if it's
> working using the cookie, then that might be the better option thinking
> about it as you are less likely to get session timeout issues with it not
> being in a session.
>
> If I were you, I'd leave it as is :)
>
> Cheers,
> Rob
> [url]http://robgt.com/[/url]
>
>

[RobGT]

>It's one web server setting or one line of code. Big deal.

LOL
Yeah, but leaving it as it is means no extra lines of code at all...

:)
Rob
[url]http://robgt.com/[/url]