close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

controlling post-insert behavior

Thread began 5/19/2014 4:33 pm by david428573 | Last modified 5/27/2014 7:56 am by Jason Byrnes | 1992 views | 8 replies |

david428573

controlling post-insert behavior

I'm working on my first databridge app, so I do apologize if this is covered somewhere in the docs. I need to control the URL that's opened after an insert. I'm feeding some query params to x_insert.php, and they show up properly the first time that page comes up. But after completing an insert, the insert page is reopened without my added params. This same question applies to update. I know I can dig through the generated code and figure this out - just wondering if there is an API setting for it already. Thanks!

Sign in to reply to this post

david428573

Oh - answering my own question, pretty simple to set a session variable if the query string contains my value; set the query string from the session variable if not. Works like a champ!

Sign in to reply to this post

Jason ByrnesWebAssist

another option is to use the following code for the forms action:

action="<?php echo $_SERVER["PHP_SELF"]; ?><?php echo (isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] != "")?"?".$_SERVER["QUERY_STRING"]:""; ?>"



this will ensure that any URL variables passed in are submited with the form, then in the insert / update server behaviors, make sure the "Pass Original Querystring" option is checked.

Sign in to reply to this post

david428573

Thanks, I'll give that a try -- but I cannot find a "Pass Original Query String" checkbox anywhere, where is that?

Sign in to reply to this post

Jason ByrnesWebAssist

It's a setting in the Data Assist insert record and Update record server behaviors.

Sign in to reply to this post

david428573

Hmmm - I cannot read that tiny little image, and enlarging it just blurs it.
Here's what I'm doing:
Webassist - Database - Data Assist Pages
This opens up a window with the title "DataAssist: Create Pages"
There are 3 tabs - Page Settings,Manage Pages, and Server Settings.
There is no checkbox on any of these pages labeled anything like "pass original query string".

Sign in to reply to this post

Jason ByrnesWebAssist

If you double click the thumbnail photo, it will download the full size image.

The "Pass Original Query String" checkbox is not a part of the Data Assist wizard.

After the pages have been created by the wizard, open the insert page. Go to the server behaviors panel (Window -> Server Behaviors).

In the Server Behaviors list, double click the Insert Record Server behavior.

The "Pass Original Query String" checkbox is a part of the Insert record server behavior, it is also available in the Update Record Server behavior.

Sign in to reply to this post

david428573

ok, I open the insert page, and then I open the server behaviors window. There is no "insert record" listed. I click on the plus sign, select "insert record", and the fields are"submit values from', 'connection','insert table','columns','value','submit as',and 'after inserting go to'. No "pass original query string'.

Sign in to reply to this post

Jason ByrnesWebAssist

Send a copy of the insert page please. Did you use Data Bridge to create it? the WebAssist insert record server behvavior will only show in the server behaviors list if you used Data Brridge to create the page and you have Data Bridge installed in Dreamweaver.

The Access point you are using is the Standard DW Insert record behavior. To access the WebAssist insert behavior, click the plus button and select:
WebAssist -> Data Assist -> Insert -> Insert Single record

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...