Hi
I have created a DNN Text Suggest field that is working fine. I want to submit the selection to a custom table in my db. I am presented with the option to submit the text from the field but I really want the Row ID only. How can I get the row id of the selected option from the selection to submit to db. My SQL insert script is something like this;
INSERT INTO [UsersInEntities](
[VendorId],
[UserID]
)
VALUES (
'$(ID)',
'$(ID)'
)
This generated an error
Conversion failed when converting the varchar value '$(ID)' to data type int.
Any suggestions?
Paul