Server Behavior Doesn't Show Up....

6/04/2011 2:47 pm | #1 Jim E D

When I open the attached file the Multiple Records insert section on lines 72-106 no longer show up in the Server Behaviors panel.

It worked for two days and now does not update the ID field in the second file. Anyone deal with anything like this?

Attached Files

mkr_InsertMulRec.zip

6/06/2011 7:40 am | #2 Jason ByrnesWebAssist

the server is not showing because of the line you commented.

because you changed the code for the server behavior, it is no longer recognized as the code footprint for the multiple record insert behavior.
change line 60:

php:

//JED Removed per session start error on .com site     if (!session_id()) session_start();

back to the original:

php:

if (!session_id()) session_start();

the true cause of the error that you received that prompted you to comment that code is the comment at lines 1- 4:

<!--Originally mkr_Insert with Blank2Col template
added hidden update UserID and Dates from Cate3  
added CSS formatting for categories 
Prior step to MRT Server Behavior-->

this is going to cause the headers already sent error to occur due to html output to the page before the session_start() or headers() function.

6/24/2011 7:05 am | #5 Nico

Same error

I am getting the same error. DW CS5.5 cant recognize the Server Behavior and I am getting a "Headers already sent" error.

Thank you.

Attached Files

headersAlreadySent.zip

6/24/2011 7:41 am | #6 Jason ByrnesWebAssist

all of the code in your page has become double spaced.

this is causing thr translator to not recognize the server behavior, an also causing the headers already sent error due to spaces between the php tags.

see this post for details on the headers already sent error:
showthread.php?t=19285

6/24/2011 8:44 am | #7 Nico

OK

It worked.
I did delete the gaps between the ?><?php tags but didn't try to delete the gaps inside the php code before contacting you.
Removing all the gaps made the code work.

Thank you very much.

3/09/2012 6:37 am | #9 Nico

cant find what is wrong

Can you please help me find out why dreamweaver not recognising the Update Server Behavior in this file? Been trying for hours to fix the problem but can' t find what is wrong.
Could it possibly be that this page was created with Dataassit 2.0.9?
Now using Dataassist 2.1.0 on Dreamweaver CS5.5 (windows 7)

Thank you in advance

Attached Files

news_Update.zip

3/09/2012 7:30 am | #10 Jason ByrnesWebAssist

the update code needs a couple of line breaks to break it up into the expected sections:

php:

<?php 

// WA Application Builder Update

if (isset($_POST["Update_x"])) // Trigger

{

$WA_connection = $analogiaCon;

$WA_table = "news";

$WA_redirectURL = "news_Detail.php?newsid=".((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"")  ."";

if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";

$WA_keepQueryString = false;

$WA_indexField = "newsid";

$WA_fieldNamesStr = "newstitle|newstitleuk|newsdescription|newsdescriptionuk|newsthumb|newsactive";

$WA_fieldValuesStr = "".((isset($_POST["newstitle"]))?$_POST["newstitle"]:"")  ."" . "|" . "".((isset($_POST["newstitleuk"]))?$_POST["newstitleuk"]:"")  ."" . "|" . "".((isset($_POST["newsdescription"]))?$_POST["newsdescription"]:"")  ."" . "|" . "".((isset($_POST["newsdescriptionuk"]))?$_POST["newsdescriptionuk"]:"")  ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"]  ."" . "|" . "".((isset($_POST["newsactive"]))?$_POST["newsactive"]:"")  ."";

$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL";

$WA_comparisonStr = "=|=|=|=|=|=";

$WA_fieldNames = explode("|", $WA_fieldNamesStr);

$WA_fieldValues = explode("|", $WA_fieldValuesStr);

$WA_columns = explode("|", $WA_columnTypesStr);



$WA_where_fieldValuesStr = "".((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"")  ."";

$WA_where_columnTypesStr = "none,none,NULL";

$WA_where_comparisonStr = "=";

$WA_where_fieldNames = explode("|", $WA_indexField);

$WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);

$WA_where_columns = explode("|", $WA_where_columnTypesStr);

$WA_where_comparisons = explode("|", $WA_where_comparisonStr);



$WA_connectionDB = $database_analogiaCon;

mysql_select_db($WA_connectionDB, $WA_connection);

if (!session_id()) session_start();

$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);

$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues,  $WA_where_comparisons );

$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

if ($WA_redirectURL != "")  {

if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {

$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];

}

header("Location: ".$WA_redirectURL);

}

}

?>

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Server Behavior Doesn't Show Up....

6/04/2011 2:47 pm | #1 Jim E D