Need a custom trigger or schedule a stored procedure to run

Public Clarification Board

Sharing of contact details is prohibited by the Terms of Service.

Post Message

• 

  japanguy

  I need the data that is inputted into the multi-line text box to have fields like this.
  
  Name: Height: Weight: Size: City: Country: State: Activity: Amount:
  
  It will be a blob of data just like this, but I need it to be recognized with those field names.
  
  Name
  Height
  Weight
  Size
  City
  Country
  State
  Activity
  Amount
  
  Then whatever value is to the right of the field (:) then that value needs to go into its own row on the database.
  
  I am using Ventrian Property Agent, which is used through Dotnetnuke.
  
  www.ventrian.com
  
  I need it to be stored into the Ventrian database, and pulled in order for me to re-use that data.
  
  I will create hidden fields, with the exact names of that data, but those fields will be hidden on the input form. After the blob of data is copy/pasted into the multi-line text box (1) box, and when the user goes to submit, it will use the stored procedure to sort all that data from the blob of data into its appropriate fields into the database.
  
  All those 9 fields will store different data into the database. It will all not just go into 1 table, but into multiple ones, based on whatever is the name to the left of the :
  
  Does that make sense?
  
  We are trying to make it a 1 step process instead of them inputting each field on the input form.

  over 1 year ago

Show more messages