Hi!
DNN is 4.8.0. Database SQL 2005. Module is 1.6.3, and I don't have source code.
I'm trying to use this form in combination with another module (PropertyAgent).
So, I've wrote a stored procedure and would like to write some more of them, so they can return some values in dropdown lists depending on querystring value.
Question is: Can I, and it would great if I can, use querystring parameter value as SQL query parameter?
So, we have querystring parameter PropertyID = 12 ... And I call stored procedure in field query like: exec dbo.SomeStoredProcedure #PROPERTYID# Instead of ?, I could use some token, but I don't see any token suggested or can't see in documentation. I also tried to use form field which reads querystring parameter and displays it, and then use that fields token as token in sql query, but no use of that...
Can you help me, please?
Thanks!
|