Shabbir Jadliwala
Posts:25
 |
| 03-24-2010 03:43 AM |
|
Respected Sir,
I am wondering does Dynamic Forms have something like Inter Module Communication? I would like the user to select certail value from a filter in one module, and based on that the form would be displayed in a different module.
Also could I use the value in the Filters on the form and submit them?
We have the Enterprise version Dynamic Forms 3 installed on our DNN install.
Thanks & Best Regards,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 03-24-2010 06:03 AM |
|
HI, well yes Inter Module Communication works fine as long as:
1) you know what SQL table and column fields the other module is storing it's data in
2) knowing that, you an simply use SQL driven options / stored procedures,etc. to access that data using Dynamic Forms
-- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-24-2010 06:10 AM |
|
Hi David,
Thnx for the reply.
I do know the SQL table and field I need to pass, but my query is how do I pass them on the Dynamic Forms.
I am using a free module, and it passes the query as [Parent_PARM:FieldName]. It works fine, but the problem is the module I am using has only a limited number of fields and data types.
I have used the Dynamic Forms fine on a few places, but never needed to use Inter Module Communication.
Thanks & Best Regards,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 03-24-2010 06:34 AM |
|
Let me get this straight. So the other module can pass values as querystring as well? Can't you send a hyperlink to your Dynamic Forms page along with the querystring variables and in Dynamic Forms, create shortname fields of those same querystring names and have it retrieve values from querystring variables? -- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-24-2010 06:42 AM |
|
Hi David,
I use the module from www.tresslework.ca (down at the moment). And they aren't submitted as Query String, but there is a setting in the module there to make one of them as the Parent and the other as Child Modules. So from child modules you can access the values passed (using dropdown list) in the Parent Module.
The site I am trying to use Dynamic forms is an intranet site, so I can't send you the link to the same. Sorry about that.
Hopefully the info above helps in understanding the same better.
Thanks & Best Regards,
Shabbir |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-26-2010 12:09 AM |
|
Hi David,
Wonder did you get a chance to look into this issue? I still have not been able to find a way to get this working.
Thanks,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 03-26-2010 06:30 AM |
|
I tried that link and it is still down so there's not much I can understand about it. -- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-29-2010 02:36 AM |
|
Hi David,
I was trying to get this working another way. I see you have a SQL Driven field.
I want to use the below:
QueryString Parameters: [QRY-PARAMETER] Ex: Select InspectorName, InspectorID from Inspectors Where InspectionType = [QRY-InspectionType]. InspectionType is the name of the control in this example, which is also a QueryString parameter.
And I pass the ID which I am looking for as a Query String on each page.
I replaced the above query as below:
select CompanyName from Company where ID = [QRY-ID], but it's not displaying anything on my text field. Wonder what I am doing above is correct or something is missing in here.
Thanks & Best Regards,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 03-29-2010 07:08 AM |
|
Hi, in a textbox field SQL driven event, the syntax is normally:
select companyname as defaultvalue from company where id = '$(UserID)'
-- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-29-2010 07:09 AM |
|
Thanks David,
Did find out from the documents and group how to get it working. |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 03-29-2010 10:53 PM |
|
Hi David,
I have another one for you, maybe you can help.
On my form I have drop down list with few option (I can get from a table or just type in manually).
What I want to know is can I set the defaultvalue of the same using maybe:
select regionname as defaultValue from company where id = '$(userid)'
Thanks & Best Regards,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 04-06-2010 01:14 PM |
|
Hi, sorry for the late response but yes, your SQL query should work. -- David |
|
|
|
|
David To
river guide
Posts:2719
|
| 04-06-2010 01:14 PM |
|
Hi, sorry for the late response but yes, your SQL query should work. -- David |
|
|
|
|
David To
river guide
Posts:2719
|
| 04-06-2010 01:15 PM |
|
Hi, sorry for the late response but yes, your SQL query should work. -- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-06-2010 10:54 PM |
|
Thanks David,
Did manage to get things working fine. Did get to submit the form to my SQL database and so on.
Thanks for your help.
Regards,
Shabbir |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-07-2010 12:19 AM |
|
Hi David, I have a List box on the Dynamic Form I use. I was wondering that when I use it to edit, most of the fields I am able to update using the DefaultValue settings from SQL. But how can I set up the Selected="yes" setting in a List box based on the data on the SQL server? The data is stored in the column as text seperated by a SEMI-COLON (  Best Regards, Shabbir |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-07-2010 01:12 AM |
|
Hi David,
Just checked the DB and when I submit the form, the List are saved as "* Opt1
* Opt2
". I wonder can I use the select option from SQL to have the options selected based on the above value in a List Box. I wouldn't mind using a CheckboxGroup if that's easier as well.
Thanks & Regards,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 04-07-2010 07:03 AM |
|
HI, I don't quite follow what you want to do. Can you explain more clearly what you want to achieve.
1) so you want to populate a combobox with SQL driven option
2) from what table / column and what's the example value of that column you are trying to extract
-- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-07-2010 07:06 AM |
|
Hi David,
I have a listbox (which could easily be a Checkbox Group) with a few values which I added manually.
What I need is how to get them selected (multiple) based on the values I have on my SQL database.
Thanks & Regards,
Shabbir |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-12-2010 01:49 AM |
|
Hi David,
Do you have a solution to the same, if not then will have to find another way to get that working.
I have the data to be displayed in the listbox saved on a table and want them to be selected based on the data for them in SQL as well.
Thanks,
Shabbir |
|
|
|
|
David To
river guide
Posts:2719
|
| 04-12-2010 07:38 AM |
|
HI, you would use SQL binding to populate the listbox on page load using querystring parameters DSParam1,DSParam2,DSParam3 depending on how many parameters are required. For example, let's say your listbox is called "list" shortname. You would have this in your SQL binding under Module configuration: select * from tablename where columname='$(DSParam1)' and your URL would be something like: http://www.yourwebsite.com/default....DSParam1=2 -- David |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-12-2010 12:34 PM |
|
Hi David,
When you save the data using a Dynamic Forms, the List are saves on the products table as:
* Value 1 < b r >* Value 2 < b r > and so on.
I have another table which has the list of values which I want to display on the list box. And based on my products table, should be selected.
Wonder can I pass the listbox.selecteditem from the value which I retreive from my sql query.
Best Regards,
Shabbir |
|
|
|
|
Shabbir Jadliwala
Posts:25
|
| 04-13-2010 12:01 AM |
|
Created another thread for the listbox issue, just in case someone else is looking for the same as it's not very descriptive from this thread title. |
|
|
|
|