cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Connecting Nintex form with DB

Jump to solution

Hello,

I connected my Nintex form to the SQL database, for some reason, the data is encapsulated by a question mark or it has a trailing question mark? Any ideas why?

Thank you.

Labels: (1)
0 Kudos
Reply
4 Replies
Workflow Hero

Re: Connecting Nintex form with DB

Jump to solution

I copied the build string text from the workflow to notepad, apparently, all the question marks show up in notepad.  When I copied the same text to sublime, it didn't show the question marks.  So now the only thing to do is delete all the unnecessary question marks, save,  copy and paste to the build string.  Problem solved.

0 Kudos
Reply
Workflow Hero

Re: Connecting Nintex form with DB

Jump to solution

Hi Lily,

Could outline how you connected the NF to the database? And using which SharePoint and Nintex version?

0 Kudos
Reply
Workflow Hero

Re: Connecting Nintex form with DB

Jump to solution

Nintex 2012

In your workflow, Build string

INSERT INTO sqlTable
(xxx
,xxx
,xxx )

Values
('{ItemProperty:xxx}',
'{ItemProperty:xxx}',
'{ItemProperty:xxx}');


Drag Execute Sql

Data Source=xxxxx;Initial Catalog=your DB;User Id=userId;Password=password;

Uncheck Escape reference
Check stor default result

Hope this helps.  

Reply
Workflow Hero

Re: Connecting Nintex form with DB

Jump to solution

Thank you Lily,

I completely overlooked the Execute SQL action...... Priceless in combination with your Build String example.

0 Kudos
Reply