close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Pre-purchase questions: Data Bridge/DataAssist abilities...

Thread began 6/03/2012 8:15 am by alnico431299 | Last modified 6/06/2012 5:58 pm by alnico431299 | 662 views | 4 replies |

alnico431299

Pre-purchase questions: Data Bridge/DataAssist abilities...

Does DataAssist support creating complex queries visually that include?

Multiple table joins
GroupBy
Aggragate functions
SubQueries
Derived tables

If not, is it possible to paste these complex queries into DataAssist or code view and yet everything work?
Are there any query limitations that DataAssist cannot handle?
FYI, I use Flyspeed Visual Query Builder to create queries, I want to know how to incorporate queries built there into DataAssist workflow.

Also, how are transactions handled in DataAssist?
How would this example of transferring $100 to another account be handled: Confirm that I have $100 in my account; Decrease my account by $100; Verify the decrease; Increase the amount of money in your account by $100; Verify that the increase worked.

Are all parts of the transaction reversible if one part fails?

Can I update/insert/delete records in multiple tables in a single transaction; if not what is the recommended process?

I have not found much for video's or doc's that explain DataAssists abilities in depth, do they exist somewhere?

Thanks,
Brent

Sign in to reply to this post

Jason ByrnesWebAssist

DataAssist creates and uses Dreamweaver Recordsets.

The DataAssist wizard will not not create the complex type of recordsets you mention, but the pages can be edited after they have been created and you can update the recordsets.

For the complex scenarios you are mentioning, I don't think you would be using the Wizards much, but would be creating your own recordsets and forms and using the individual server behaviors for inserting, updating or deleting.

There are server behaviors for single record inserts, updates and deletes as well as multiple insert updates and deletes.

There is also a manage relational table behavior for managing linking tables.

These can be put together in various ways to create complex data management applications, for example you can use 2 single record inserts on the same page to create a form that inserts to 2 tables.


The data assist behaviors do not use data transactions, they use standard inserts and updates.

Sign in to reply to this post

alnico431299

Thanks...I few more questions...

I need to create a new message thread where I create (threadID ai) in table1 and insert the actual message in table2: (messageID ai, threadID, message); where threadID is relational.
...threadID must be auto created first in table1, and then the message may be inserted into table2 with the newly generated threadID from table1.
I can imagine a number of ways of doing this, but want to hear about capabilities of DataAssist and best practices for doing this?

Also, I discovered that MySQL Dreamweaver recordsets do not support queries containing BLOB's (throws 1064 error); am I correct to assume that DataAssist does not as well?
What other limitations are there? I do not like spending hours only to discover limiting surprises ;-)

Can multiple queries be sent at once with multiple recordsets returned?
MySQL stored procedures can contain multiple Select statements. How does this work with DataAssist?
Are there other DataAssist methods that may be used instead?

Sign in to reply to this post

Jason ByrnesWebAssist

you would use 2 Insert behaviors.

the insert behavior will store the ID of the record it creates in a session variable. In the second insert behavior, you would bind the relational column to the session variable created by the first insert.


Data Assist uses dreamweaver recordsets for getting information out of the database to display on the page, so will have the same limitations including BLOB Fields.


you can add as many dreamweaver recordsets to a page as you need, dreamweaver recordsets can also use MySQL Stored Procedures.

Sign in to reply to this post

alnico431299

Thanks Jason...I will download the tools and give them a shot.
Brent

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...