suv
wading in the water
Posts:19
 |
| 01-30-2011 08:36 PM |
|
Hi,
I am new to DF, just trying to make a simple forum with 3 buttons
"Add as New" , "Update" and "Delete this"
For Viewing purpose I am using Data Grid View
Since I am saving the EditURL token value in one of my table column , I am able to pre fill the form for edit purpose also..
I dont want to use the default submit link or button..
Now I am facing the below explained problem
I couldnt bind SQL Query for update button.. even if I add in form submit event > for the update button> it is not working properly.. Always the Insert Query which I tried to bind for my insert button is running...
I have given execute form submition for these buttons... f i didnt give this even the Insert is not working as well...
Can any one help me.. I am sure there is some problem in my settings...
Thanks in adv
Cheers ..... ( hmmm [  ] less voltage pls help to increase)
Suv |
|
|
|
|
suv
wading in the water
Posts:19
|
| 01-30-2011 09:00 PM |
|
continuation of previous question
I will tell you how I did the setting ... ( don't laugh he he..)
Added one txtbox , & 2 html buttons..
created table (host > SQL) wth 2 columns one for the textbox other for edit link..
added 2 new events in 'form completion events' with dynamic sql option...added sql query for each button by specifying 'dynamic field' from the combo..
I tested at this stage for inserting n update button functionality... nothing happened..
Then I tried with adding question events also with this... I added two question events as well and assigned for each button accordingly.. and selected "execute form submission" option in the setting as well...
Now it stared inserting..but bit madly.. Update start giving errors also...
pls help..
ChEeRs.. |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 01-31-2011 08:17 AM |
|
Hello suv,
I would start by having your three buttons and having a hidden field.
You will use Client side events, so when the button is clicked you will assign a value to the hidden field. So if Add was clicked then "Add" will be assigned to the hidden field's value. Also have three question events, one for each button. Then have a SQL completion event that declares a variable which will be for the value of the hidden field.
Then have conditions for the value of the hidden field.
Here's some psuedocode:
IF "ADD" THEN
EXECUTE SQL for Adding Record
END
IF "UPDATE" THEN
EXECUTE SQL for Updating Record
END
ELSE "DELETE" THEN
EXECUTE SQL for Deleting Record
END
Please let me know if you have any questions.
Thanks,
Ryan
|
|
|
|
|
suv
wading in the water
Posts:19
|
| 01-31-2011 08:22 PM |
|
hi Ryan,
Thank for the Quick reply...
I tried your solution... ya i think it will work for me..
now i have a small problem too...
i use
Update {databaseOwner}[{objectQualifier}DynamicForms_CustomTable_664]
Set [CustName] = '$(CustName)',
[EditRecord]='$(EditLinkURL)'
Where UniqueCompletionID = '$(DSParam1)'
as my update query... i believe this is not working since there is some problem with where condition...
the unique completionId is inserted while creating the row using token... and for updation i used the 'edit link' to fill the fields.... will this '$(DSParam1)' give the proper Unique id when i use edit link?...
pls help me...
Cheers |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 02-01-2011 06:16 AM |
|
Hello suv,
Well what is DSParam1?? How are you setting the value to this variable? Is this a query string variable value that you collect from the URL and store into a hidden field? Or are you setting a default value to this field??
I don't see an issue with the SQL query at all, syntactically it's correct. The issue must be the DSParam1 field. It must be pulling in an incorrect value of some sort. Perhaps make DSParam1 a textbox so you can see the value associated with it.
If you have any questions please let me know.
Thanks,
Ryan
|
|
|
|
|
suv
wading in the water
Posts:19
|
| 02-01-2011 07:01 AM |
|
Hi Ryan,
DSParam1 is a hidden field , wth same name I hav a column as well in my table... I am storing the 'unique completionId' is that column...
Now my updation is working... but I found its not displaying in the DataGrid even after updating.. I mean the updated value are not showing in the Grid view (even after refresh) ... I am using selet * query to display the table for time being...
but if i try to edit again , the previously edit value is coming in the text field..
For example : First i will type "Suv" in my text box and click "add".. it will insert details to table and also will come to the display grid...
now if I try to edit .. "Suv" will be filled in the textbox .. now i will change textbox to "kkpp" and i will update.... but if i chk the grid...it is still showing "Suv" ... if u try to edit tht row.. "kkpp" will be prefilled in the textbox....
wats the silly thing i missed or messed..?
pls help me...
similar issue i hav for delete also...
thank you ..
Cheers
Suv
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 02-01-2011 07:22 AM |
|
Hello Suv,
I'm unable to determine the issue. I will need a visual representation for this to find the issue.
Can you do one of the two:
Option 1:
You can create an example on www.betasprings.com that reflects your work flow. The login info is host / dnnhost and then provide the link in this forum thread so I can take a look.
Option 2:
You can email me credentials to your site and the URL to this page,
my email is rbakerink(at)datasprings(dot)com. Please make the subject meaningful so I can easily find your message.
Please let me know if you have any questions.
Thanks,
Ryan
|
|
|
|
|
suv
wading in the water
Posts:19
|
| 02-01-2011 09:03 PM |
|
hi Ryan, Sorry dear I could not create the same instant in ur site since advanced grid view is not installed in ur site... I cannot give ma site credentials either since it requires lots of permission frm my authorities  ... can you giv me any tutorial link wch will serve my purpose... My requirement is as simple as a form with these 3 button, ppl can enter the form later they can edit their form or they can delete the same... for the edit and delete puropse i just want to show them all the form posts as a list or grid with edit & delete option... Thnx & Rgds Suv |
|
|
|
|
suv
wading in the water
Posts:19
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 02-02-2011 06:20 AM |
|
Hello suv,
For insert, edit, delete functionality Dynamic Forms can achieve this very well.
These two modules work great together:
Dynamic Forms
OpenWebStudio
I would look into OpenWebStudio to see how this module functions.
But in order to fully assist you I will need some sort of visual representation.
Can you possibly email me at rbakerink(at)datasprings(dot)com and send me several snap shots of your program in host (edit) mode.
Then I'll be able to get a general idea of your work flow.
If you have any questions please let me know.
Thanks,
Ryan
|
|
|
|
|
suv
wading in the water
Posts:19
|
| 02-03-2011 11:06 PM |
|
Hi Ryan, As per the link - http://www.datasprings.com/products...d.%3C/p%3E Am able to do my minimum requirements.... I have another doubt ... Is there any possible way to hide some of the shown form fields on page load based on query string parameter? Regards Suv |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 02-04-2011 05:28 AM |
|
Hello suv,
Your link is broken, can you please attach the link again.
Also there is no doubt in my mind that you can hide other fields based on a querystring parameter.
I do this all the time, all you'll need is a hidden field that collects the parameter value and then you can use that value in a question event to hide or show questions.
If you have any questions please let me know.
Thanks,
Ryan
|
|
|
|
|
suv
wading in the water
Posts:19
|
| 02-04-2011 09:04 AM |
|
Hi Ryan,
Ya I did the same..
I have one hidden field 'sorh' having default value 'show', In Advanced Field Options , i enabled 'Retrieve values from querystring variable for this question: ' ,
I added one question event 'Hide' , with option 'Hide question based on another questions response' , Initiation / Postback Question: 'sorh' (my hidden field), Initiation Response: 'Hide' , then i selected the field which i wanted to hide ... ... but didnt worked out based on my querystring... anything did I miss?
Regards
Suv |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 02-07-2011 08:56 AM |
|
Hello Suv, Please take a look at this example I made: Here is the page without the query string variable that shows questions.
http://Beta-Springs.com/test/tabid/...fault.aspxNow view this page with the variable I have included that a question event is awaiting the value of a hidden field to = true. http://Beta-Springs.com/test/tabid/...fault.aspx?UnitedStates=True If you'd like to see how I did this please login with the credentials Host / dnnhost If you have any questions please let me know. Thanks, Ryan |
|
|
|
|