Not sure if I set it up correctly?
I created a session variable called productVars then tried using the set session value server behavior that can be found with the eCart extension to the trigger you left in your last post. I attempted applying the trigger manually through the set session value panel, but was having trouble. How would you go about setting the session trigger for something as complex as the line that you provided me using the eCart set session value panel? I finally resorted to copying and pasting your trigger into the field, selected my session name, and then clicked ok. Once, that was done I applied my WHERE clause to the value of the session variable, added the else statement, and then altered my recordset to reflect the session variable. Now, the page responds by throwing me a syntax error. I will attach my page code along with my sql database if you would please take a look at.