Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Insert New Record for each new line in textbox

Insert New Record for each new line in textbox

Thread began 11/02/2011 9:35 am by dave315749 | Last modified 11/07/2011 10:15 am by Jason Byrnes | 1010 views | 3 replies |

11/02/2011 9:35 am | #1 dave315749

Insert New Record for each new line in textbox

Looking for information on how to have a list of items in a text area box like

option1
option2
option3
option4

And then once i click "insert" it will make 4 separate rows in the database.

How would i accomplish this with dataassist?

11/03/2011 9:30 am | #2 Jason ByrnesWebAssist

this is not possible to do with one text area.

create 4 text boxes, and use the Data Assist Insert Multple behavior to insert a record for each one.

11/04/2011 7:34 pm | #3 dave315749

more than 4

Well i need to put in like 45 to 100 lines or records, not just 4, that was for an example only.

So is there a way to do it in one text box via javascript and an array?

11/07/2011 10:15 am | #4 Jason ByrnesWebAssist

this would take hand coding to accomplish and is not supported by our extensions.

you would need to hand code logic to create an SQL insert statement each time it found a return in the text box POST.

If you need assistance with this, we could probably help you in a premiere support ticket.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.