Hello,
I have a problem passing a session parameter to the SQL Server 2008 query via the Where line. This is in a nested Parent/Child Menu loop and I need the query to bring in a session variable to the query. The session item is the company the client is assigned to and they can only add or edit that companies information. Multiple company data resides in the same datatable.
My current code look like below and I know the quotes are way off, My error code is " Too many characters in character literal".
""CompanyID = ""' & Page.Session[""FieldCompany""] & ""'""
It works if I hardcode the company ID in the field but bombs when I try to pass it through.
I have tried using the Category Control field items but everytime I have a child item without a parent (top/main menu headings) I can't edit the items becaude of a glitch inb the edit scripts.
Any help would be cgreatly appreciated.
Thanks in advance.
