yeudoi wrote:The DW API does have some DB interaction calls using the MMDB object. However, the exposed call that can get you results from, DB MMDB.showResultset(), pops up a dialog with the results in it. The same dialog that is popped up when the user presses the Test button on the Recordset dialog. So, you don't actually get the results to be able to manipulate them.> Hi all,
> I read the DW Help and couple articles on the Macromedia site, but I could not
> make sense of what is the relationship of Dreamweaver and Database. What I
> want is to be able to connect to a database (MS SQL or ACCESS) within a command
> extension and be able to do query, and manipulate the results. Is it possible?
> Do DW API has such functions? Are there example codes?
If the DB you have to access can be connected to via a remote server (could even be localhost), you can try to use the MMHttp object and have your server side pages run code that accesses the db and provides the results either as text, or as a file.
| Extending Knowledge, Daily [url]http://CommunityMX.com/[/url]