cancel
Showing results for 
Search instead for 
Did you mean: 
sojanm
Nintex Newbie

How to set value to a SQL request contorl

Hi All,

Is it possible to set value (default value ) to SQL Request Control?

Thanks

Sojan

Tags (1)
0 Kudos
Reply
7 Replies
craighton
Nintex Newbie

Re: How to set value to a SQL request contorl

I am also looking for a solution to this same problem.  I can get the value with

alert(NWF$('#' + javaPlayerName).val())

I cant set the value or get the value for the second item in the list/drop down

alert(NWF$('#' + javaPlayerName).val(2))

0 Kudos
Reply
sojanm
Nintex Newbie

Re: How to set value to a SQL request contorl

What is the version of your form

0 Kudos
Reply
craighton
Nintex Newbie

Re: How to set value to a SQL request contorl

I am using version nintex forms 2013 version 2.9.0.0

0 Kudos
Reply
Highlighted
sojanm
Nintex Newbie

Re: How to set value to a SQL request contorl

Try this code

var yourControl = NWF$("#"+ jvarCtl);
var value = yourControl.find("option[title='" + CtlValue + "']").attr("value");
yourControl.val(value);
yourControl.parent().find("input").val(value);
NWF.FormFiller.Functions.ProcessOnChange(yourControl);

0 Kudos
Reply
craighton
Nintex Newbie

Re: How to set value to a SQL request contorl

what is CtlValue ?

0 Kudos
Reply
sojanm
Nintex Newbie

Re: How to set value to a SQL request contorl

The value you want set

0 Kudos
Reply
priya_r_rathi
Nintex Newbie

Re: How to set value to a SQL request contorl

Did the solution suggested work for you to set default value to SQL Request control on Nintex Form?

0 Kudos
Reply