Ajax DataGrid Support Product Page

Session Variable Filter Not Working

Asked 08 Jul 2011 20:37:03
1
has this question
08 Jul 2011 20:37:03 Aaron Thomas posted:
Empty grid when using Session value as filter. I can response.write my session value to screen so I know the session value is good. If I response.write the SQL from the dmx_grid1.asp file I can see that the value is NULL in the Where clause.

This code:
<%Response.write "Session Variable Territory = " & Session("sv_Territory")%>

Produces this output:
Session Variable Territory = 11

Yet dmx_grid1.asp is producing this SQL statement:
SELECT ID, Company, Address1, City, [State] FROM Distributors WHERE Territory = NULL ORDER BY Company ASC{ "page": 1, "total": 0, "rows": [ ]

Replies

Replied 11 Jul 2011 09:22:38
11 Jul 2011 09:22:38 Miroslav Zografski replied:
Hello Aaron,

Can you pass here a link to a test page?

Regards,
Replied 11 Jul 2011 16:35:53
11 Jul 2011 16:35:53 Aaron Thomas replied:
Miroslav,

Unfortunately this site is behind company firewall. Would it be useful to message you with source code files?

Reply to this topic