Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Possible Bug? Multiple dropdown menus created by DA leave <?php opening in place.

Possible Bug? Multiple dropdown menus created by DA leave <?php opening in place.

Thread began 7/25/2012 12:58 pm by Andrew Read | Last modified 8/05/2012 7:08 pm by Andrew Read | 2617 views | 10 replies |

7/25/2012 12:58 pm | #1 Andrew Read

Possible Bug? Multiple dropdown menus created by DA leave <?php opening in place.

First off, let me say that I truly appreciate the quick and timely support from all of the folks at WebAssist and for the quick fixes and updates.

That said, let's move on to this new issue:

Using WADA to create a List and form with two dropdown menus (not dependent!) I receive the following error on the Insert and Update pages:

Parse error: syntax error, unexpected '<' in ...

Upon further investigation into the insert page at the specified line I find the following code:

php:

<?php
mysql_free_result($WADAseason);
<?php
mysql_free_result($WADAday);
?>?>l>

In the Update page I find the following code:

php:

<?php
mysql_free_result($WADAws_hours);
<?php
mysql_free_result($WADAseason);
<?php
mysql_free_result($WADAday);
?>?>?>l>

Anyway, that should be easy enough to figure out a solution to, just a few extranious parser open and closes left over.

7/25/2012 1:07 pm | #2 Andrew Read

Another bug, noticed before but not reported

I noticed this before but forgot to report it:

php:

<option value="<?php echo $row_WADAseason['SCRUBID']?>"<?php if (!(strcmp($row_WADAseason['SCRUBID'], (isset($_GET["invalid"])?ValidatedField("hourUpd","SCRUB"):"".$row_WADAws_SCRUB2["SCRUB"]."")))) {"selected=\"selected\"";} ?>><?php echo $row_WADAseason['SCRUB3']?></option>

This is missing the echo before the {"selected=\"selected\"";}

php:

<option value="<?php echo $row_WADAseason['SCRUBID']?>"<?php  if (!(strcmp($row_WADAseason['SCRUBID'],  (isset($_GET["invalid"])?ValidatedField("hourUpd","SCRUB"):"".$row_WADAws_SCRUB2["SCRUB"].""))))  {echo "selected=\"selected\"";} ?>><?php echo  $row_WADAseason['SCRUB3']?></option>

It has happened every time I have created a dropdown menu via WADA.

7/26/2012 8:56 am | #3 Andrew Read

More impact than noticed initally

**NOTE: The code in question is actually being inserted in the middle of the closing html tag:

php:

</script></body>
</h>
<?php
mysql_free_result($WADAws_equip_fs);<?php
mysql_free_result($WADAefsStatus);<?php
mysql_free_result($WADAefsClass);<?php
mysql_free_result($WADAefsEtype);<?php
mysql_free_result($WADAefsBrand);
?>
?>
?>
?>
?>tml>

7/26/2012 8:58 am | #4 Jason ByrnesWebAssist

I am not able to reproduce this issue, I will start an incident so ray can look into it with you.

7/26/2012 11:47 am | #5 Andrew Read

Also...

I will also add in this bit of info:

I am noticing a #1 in all of my dropdown menu code and I'm not sure what is does or where it is coming from, it is just before the "</select>":

php:

<select class="formMenufield_XLarge" name="fieldLabel" id="fieldLabel" onChange="hideServerError('fieldLabel_ServerError');">
<option value="">Choose one...</option>
<?php
do {  
?>
        <option value="<?php echo $row_WADAtableName['fieldID']?>"<?php if (!(strcmp($row_WADAtableName['fieldID'], (isset($_GET["invalid"])?ValidatedField("equipUpd","fieldLabel"):"".$row_WADAtableName["fieldLabel"]."")))) {echo "selected=\"selected\"";} ?>><?php echo $row_WADAtableName['fieldDesc']?></option>
        <?php
} while ($row_WADAtableName= mysql_fetch_assoc($WADAtableName));
  $rows = mysql_num_rows($WADAtableName);
  if($rows > 0) {
      mysql_data_seek($WADAtableName, 0);
      $row_WADAtableName= mysql_fetch_assoc($WADAtableName);
  }
?>
#1</select>
<label for="fieldLabel" class="sublabel" >Brand<span class="requiredIndicator">&nbsp;*</span></label>

7/26/2012 12:19 pm | #6 Jason ByrnesWebAssist

please add this to the support incident so that ray can investigate.

7/31/2012 11:45 am | #7 Andrew Read

OK, so the update is that the issue has been figured out, and the users can implement the fixes that I used above fairly easily... but it will be fixed in the next release. :)

Hope this helps someone else as well.

L8r.

8/05/2012 7:25 am | #8 david390068Beta Tester

Cure

I am experiencing the same thing. If you wouldn't mind, can you share what was done to resolve this?

8/05/2012 6:54 pm | #9 Andrew Read

It is explained above, to make it more clear:

You will see something like this:

php:

</script></body>
</h>
<?php
mysql_free_result($WADArecordset1);<?php
mysql_free_result($WADArecordset2);<?php
mysql_free_result($WADArecordset3);<?php
mysql_free_result($WADArecordset4);<?php
mysql_free_result($WADArecordset5);
?>
?>
?>
?>
?>tml>

Simply fix the closing HTML tag, remove all of the extra PHP parser open commands and everything after the last php parser close tag.

php:

</script></body>
</html>
<?php
mysql_free_result($WADArecordset1);

mysql_free_result($WADArecordset2);

mysql_free_result($WADArecordset3);

mysql_free_result($WADArecordset4);

mysql_free_result($WADArecordset5);
?>

And remove all of the #1 from any of the option select menu lists:

php:

#1</select>

php:

</select>

8/05/2012 6:58 pm | #10 david390068Beta Tester

Thanks. I knew that part. But I don't want to have to do that on every page for the site I am building. I was hoping a solution was found in the databridge files to fix it from happening in the future.

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.