How can i retrieve values from database in to a dynamic form using " initial sql rendering/bind" option.

 

It means ,assume my form has two text boxes first name,last name.

Firt Name : ipsita

Last Name:Mishra

 

Thn how can i get these values from database using this property if the user is logged in.

Please help m on this.

 

Regards

Ipsita

HI, if the user is logged in, then you can use their token ID and not need to use SQL binding at all. SQL binding is when you need to retrieve a record in a database table and fill / populate your entire form with some querystring parameter DSParam1 and/or DSParam2 and/or DSParam3 variables.

In your case, you don't need this. Just use the following SQL default option on the field:

select firstname from {objectQualifier}users where userid = '$(UserID)'

-- David