Friday, February 10, 2012
  Search
Support Forum
Can I use part of querystring as SQL query parameter?
Last Post 13 May 2008 12:22 AM by Vladimir. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Vladimir
New Member
New Member
Send Private Message
Posts:1


--
13 May 2008 12:22 AM  
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!
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.