Not sure, I'm not able to reproduce the issue.Open the results page and go to the server behaviors panel, in the server behaviors list, double click the Repeat Region server behavior to edit it. set the records to show to 5.
Hi Jason, thanks again. All sorted now, I didn't realise I needed to remove all columns I didn't want in the wizard.
On another note, is there an easy way to format the date into UK format? I have been looking at the code created by DA, but not sure where exactly I need to try and change the format. MySQL table is yyyy-mm-dd but I need dd-mm-yyyy, am I able to change this in the queries created on each page in the header section?
I did find some code to achieve this but it fails when I add to the DA created insert pages? I added the below to the header section along with the DA created code & change 'column' to my column name which is ContactDOB.
<?php
function mysql2uk($date) {
return date('d-m-Y H:i:s',strtotime($date));
}
$sql ="select * from tblContacts";
$result = mysql_query($sql) or die();
$values = mysql_fetch_row($result);
echo mysql2uk($values['Column']);
?>
Thanks again Jason.
