Subtotal: $28,158.00
Can live form using URL parameters from an DNN site (f.e. mywebseite.com/itemshow?urlid=123456) in a SQL statement to get data and display from the database (SELECT * from items WHERE id = [urlid]).
Kind Regards Daniel
Interesting question. I use the Reports module to do this. I suspect there are many functions LiveForms might perform if it is able to grab the @UserID, @PortalID parameter.
Interested in know this. Thanks for asking.
I found somethins in the knowledgebase: https://www.mandeeps.com/support/knowledgebase/live-forms-tokens-tokens
URL Query Parameters are possible and DNN STandard Tokens:
URL Query Parameters
Many fields allow you to specify a default value. You can easily use a URL Token to map a value from the URL to the field. Example: www.yoursite.com/live-forms.aspx?StoreID=1324 You could have a textbox field in the forms that automatically maps to the StoreID in the URL by simply using a token such as [Url:storeid] as the default value. Case Sensitive Syntax: [Url:lowercase_parameter_name]
I will try it to load a specific data from the database.
Daniel
The url Tokens can not be used direct in the SQL Statements.
But you can use the URL Tokens as default value for a field. the field you can hide. And then you can bind other fields with SQL Statements using that field-data.
Your browser doesn't have Flash, Silverlight or HTML5 support.