I have the sqlview v4.04 installed on DNN5.1.1 and it works fine except when you utilize the querystring but don't have any querystring in your url. I know that shouldn't happen but it does and you get a messy error:

A critical error has occurred.
Invalid column name 'QUERYSTRING:wo'.

When this happens, the module does not even display so you cannot go into the settings of the module (without going through the backdoor url or putting in the querystring).

I have used both of these statements (below) and both provide the same issue. I do not want to use like % as this is an integer ID and like %1% would return 1, 10, 11 etc when I only want record ID 1.


select * from dis_workorders where workorderid = [QUERYSTRING:wo]

select * from dis_workorders where workorderid like [QUERYSTRING:wo]

When I have a valid URL like http://mydomainnamehere.com/Default.aspx?tabid=555&wo=1 it works like a charm.

Kevin
kevin_at_matice.com

Hi Kevin,

I've been able to recreate the error you mentioned. I'm taking a little vacation this week but if I have a moment I'll try and fix that and post a new release for you.

Kevin,

I just posted an update which should fix this and a few other things. Please let me know how you make out.