Update/Delete/Insert in one Form?
Is it possible to create with FB a single form for insert/update/delete functions? Or do I have to create 3 pages?
Is it possible to create with FB a single form for insert/update/delete functions? Or do I have to create 3 pages?
you can add insert update and delete forms to the same page, just make sure that each form uses a unique name for the submit button.
you will need to use the submit buttons as the trigger for the insert update and delete behaviors.
yes, you need a seperate form for each action.
So the customer sees 3 forms?
By the way I try to built a form with FB and added the update server behaviour from data assist but filtering the recordset with URL-Parameter doesn't work. What do I wrong?
I have a list of recordsets with a link like form.php?ID=3 and on the edit page a form to edit its data. But filtering via value <?php echo $_GET['ID']; ?> is not working.
yes, the customer would see 3 form.
Send a copy of you page so i can see the code in order to see what may be wrong.
Thanks Jason. This drives me crazy ...
your recordset code does not use the ID querystring variable, it uses the FIRMID querystring variable:
$colname_rsFirmen = "-1";
if (isset($_GET['FIRMID'])) {
$colname_rsFirmen = (get_magic_quotes_gpc()) ? $_GET['FIRMID'] : addslashes($_GET['FIRMID']);
}
mysql_select_db($database_HPharm, $HPharm);
$query_rsFirmen = sprintf("SELECT * FROM firmen WHERE FIRMID = %s", GetSQLValueString($colname_rsFirmen, "int"));
$rsFirmen = mysql_query($query_rsFirmen, $HPharm) or die(mysql_error());
$row_rsFirmen = mysql_fetch_assoc($rsFirmen);
$totalRows_rsFirmen = mysql_num_rows($rsFirmen);
your link:
form.php?ID=3
should be:
form.php?FIRMID=3
Sorry for that, with ID I've mentioned a basic example, I DO pass FIRMID as URL-parameter from the list to the form page and filter it for the recordset (works) and update behaviour (deosn't work).
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.