Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › how to update recordset

how to update recordset

Thread began 5/12/2011 11:23 am by Sn0man | Last modified 5/12/2011 12:34 pm by Jason Byrnes | 1576 views | 5 replies |

5/12/2011 11:23 am | #1 Sn0man

how to update recordset

Hi there,

Just wondering how I would go about updating the recordset once i've made changes to the database table. I wanted to include some additional information in the users table, and had to manually update each affected page to reflect the changes. I was just wondering if there was a way to do it with any of the dynamic suite server behaviours. The changes to the table don't seem to appear in the recordset.

Thanks

5/12/2011 11:27 am | #2 Jason ByrnesWebAssist

Double click the recordset in the server behaviors panel to edit it.

5/12/2011 11:39 am | #3 Sn0man

Thanks Jason - I think I know what you mean.

So do I just add the names of the new columns to the list in the box at the top of the recordset window - is that all I need to do?

5/12/2011 11:45 am | #4 Jason ByrnesWebAssist

If all you are trying to do is add these new columns to the select statement, then yes, that should be all you need to do..

5/12/2011 12:25 pm | #5 Sn0man

Thanks Jason!

5/12/2011 12:34 pm | #6 Jason ByrnesWebAssist

you're welcome.

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.