Skip to main content
Nintex Community Menu Bar

Connecting Nintex form with DB

  • October 25, 2017
  • 4 replies
  • 42 views

Forum|alt.badge.img+4

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.

4 replies

Forum|alt.badge.img+4
  • Author
  • Nintex Partner
  • October 27, 2017

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.


Forum|alt.badge.img+11
  • Nintex Partner
  • April 5, 2018

Hi Lily,

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


Forum|alt.badge.img+4
  • Author
  • Nintex Partner
  • April 5, 2018

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.  


Forum|alt.badge.img+11
  • Nintex Partner
  • April 5, 2018

Thank you Lily,

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