View Single Post
  #4 (permalink)  
Old September 7th, 2003, 04:48 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Lucian,

Where was the original parameter from the QueryString used? I don't see any of that in your code, so I don't know exactly what went wrong.

The basic idea is that your WHERE clause uses at least two filters: a CustomerID from the Session object, and something from the QueryString, although I don't know what you are using the second parameter for. So use something like this:

WHERE SomeColumn = 'SomeValue' AND SomeOtherColumn = 'SomeOtherValue'

What exactly do you want to show to your visitors? What are they allowed to see and what not? On what parameters do you base this decision?


Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote