close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

 
› WebAssist Forums › Data Bridge › DataAssist › Started all over, still can't get it to work
Sign in to rate this thread
rating

Started all over, still can't get it to work

Thread began 11/03/2009 11:17 am by brobert123392308 | Last modified 11/03/2009 1:53 pm by Jason Byrnes | 3082 views | 8 replies |

11/03/2009 11:17 am  |  #1 brobert123392308

Started all over, still can't get it to work

using D/W cs4, php, mysql, D/A, DFD,
I got the insert record page to work great. Created these separately. Tried using the search wizard many times, exactly how the documentation said, no luck.

Tried the D/A wizard to create search, results, and detail page couple times, following exactly the documentation, it ain't working, I get no results from a search.

I will attach the code from the three pages.

Could use some help please

Sign in to reply to this post

11/03/2009 11:20 am  |  #2 brobert123392308

search

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Search Report</title>
<link href="mystyles.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Modular_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Verdana.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div class="WADASearchContainer">
<form action="HBCCResults.php" method="get" name="WADASearchForm" id="WADASearchForm">
<div class="WADAHeader">Search</div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">Case Number:</th>
<td class="WADADataTableCell"><input type="text" name="S_id" id="S_id" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Date Submitted:</th>
<td class="WADADataTableCell"><input type="text" name="S_submittedDate" id="S_submittedDate" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event date:</th>
<td class="WADADataTableCell"><input type="text" name="S_event_date" id="S_event_date" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event country:</th>
<td class="WADADataTableCell"><input type="text" name="S_event_country" id="S_event_country" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event state:</th>
<td class="WADADataTableCell"><input type="text" name="S_event_state_us" id="S_event_state_us" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event province:</th>
<td class="WADADataTableCell"><input type="text" name="S_event_province_ca" id="S_event_province_ca" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Short description:</th>
<td class="WADADataTableCell"><input type="text" name="S_short_description" id="S_short_description" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Long description:</th>
<td class="WADADataTableCell"><input type="text" name="S_long_description" id="S_long_description" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload1:</th>
<td class="WADADataTableCell"><input type="text" name="S_upload1" id="S_upload1" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload2:</th>
<td class="WADADataTableCell"><input type="text" name="S_upload2" id="S_upload2" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload3:</th>
<td class="WADADataTableCell"><input type="text" name="S_upload3" id="S_upload3" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Within 500 ft of ground:</th>
<td class="WADADataTableCell"><input type="text" name="S__fivehundfeet" id="S__fivehundfeet" value="" size="32" /></td>
</tr>
</table>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><input type="Submit" name="Search" id="Search" value="Search" /></td>
</tr>
</table>
</div>
</form>
</div>
</body>
</html>

Sign in to reply to this post

11/03/2009 11:27 am  |  #3 brobert123392308

part1 of results

<?php require_once('Connections/connNids.php'); ?>
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAReport;
//Searchpage: HBCCSearch.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations

//comparison list additions
$WADbSearch1->addComparisonFromEdit("id","S_id","AND","=",1);
$WADbSearch1->addComparisonFromEdit("submittedDate","S_submittedDate","AND","=",2);
$WADbSearch1->addComparisonFromEdit("event_date","S_event_date","AND","=",2);
$WADbSearch1->addComparisonFromEdit("event_country","S_event_country","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("event_state_us","S_event_state_us","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("event_province_ca","S_event_province_ca","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("short_description","S_short_description","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("long_description","S_long_description","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload1","S_upload1","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload2","S_upload2","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload3","S_upload3","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("_fivehundfeet","S__fivehundfeet","AND","Includes",0);

//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_HBCCResults"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch1_HBCCResults"]) && $_SESSION["WADbSearch1_HBCCResults"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_HBCCResults"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
<?php
//WA Database Search Include
require_once("WADbSearch/HelperPHP.php");
?>
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAReport;
//Searchpage: HBCCSearch.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations

//comparison list additions
$WADbSearch1->addComparisonFromEdit("id","S_id","AND","=",1);
$WADbSearch1->addComparisonFromEdit("submittedDate","S_submittedDate","AND","=",2);
$WADbSearch1->addComparisonFromEdit("event_date","S_event_date","AND","=",2);
$WADbSearch1->addComparisonFromEdit("event_country","S_event_country","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("event_state_us","S_event_state_us","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("event_province_ca","S_event_province_ca","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("short_description","S_short_description","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("long_description","S_long_description","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload1","S_upload1","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload2","S_upload2","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("upload3","S_upload3","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("_fivehundfeet","S__fivehundfeet","AND","Includes",0);

//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_HBCCResults"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch1_HBCCResults"]) && $_SESSION["WADbSearch1_HBCCResults"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_HBCCResults"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
?>
<?php
$maxRows_WADAReport = 1000;
$pageNum_WADAReport = 0;
if (isset($_GET['pageNum_WADAReport'])) {
$pageNum_WADAReport = $_GET['pageNum_WADAReport'];
}
$startRow_WADAReport = $pageNum_WADAReport * $maxRows_WADAReport;

mysql_select_db($database_connNids, $connNids);
$query_WADAReport = "SELECT id, submittedDate, event_date, event_country, event_state_us, event_province_ca, short_description, upload1, upload2, upload3, _fivehundfeet FROM Report ORDER BY id ASC";
setQueryBuilderSource($query_WADAReport,$WADbSearch1,false);
$query_limit_WADAReport = sprintf("%s LIMIT %d, %d", $query_WADAReport, $startRow_WADAReport, $maxRows_WADAReport);
$WADAReport = mysql_query($query_limit_WADAReport, $connNids) or die(mysql_error());
$row_WADAReport = mysql_fetch_assoc($WADAReport);

if (isset($_GET['totalRows_WADAReport'])) {
$totalRows_WADAReport = $_GET['totalRows_WADAReport'];
} else {
$all_WADAReport = mysql_query($query_WADAReport);
$totalRows_WADAReport = mysql_num_rows($all_WADAReport);
}
$totalPages_WADAReport = ceil($totalRows_WADAReport/$maxRows_WADAReport)-1;
?>
<?php
$maxRows_WADAReport = 1000;
$pageNum_WADAReport = 0;
if (isset($_GET['pageNum_WADAReport'])) {
$pageNum_WADAReport = $_GET['pageNum_WADAReport'];
}
$startRow_WADAReport = $pageNum_WADAReport * $maxRows_WADAReport;

mysql_select_db($database_connNids, $connNids);
$query_WADAReport = "SELECT id, submittedDate, event_date, event_country, event_state_us, event_province_ca, short_description, upload1, upload2, upload3, _fivehundfeet FROM Report ORDER BY id ASC";
setQueryBuilderSource($query_WADAReport,$WADbSearch1,false);
$query_limit_WADAReport = sprintf("%s LIMIT %d, %d", $query_WADAReport, $startRow_WADAReport, $maxRows_WADAReport);
$WADAReport = mysql_query($query_limit_WADAReport, $connNids) or die(mysql_error());
$row_WADAReport = mysql_fetch_assoc($WADAReport);

if (isset($_GET['totalRows_WADAReport'])) {
$totalRows_WADAReport = $_GET['totalRows_WADAReport'];
} else {
$all_WADAReport = mysql_query($query_WADAReport);
$totalRows_WADAReport = mysql_num_rows($all_WADAReport);
}
$totalPages_WADAReport = ceil($totalRows_WADAReport/$maxRows_WADAReport)-1;
?>
<?php
$queryString_WADAReport = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WADAReport") == false &&
stristr($param, "totalRows_WADAReport") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WADAReport = "&" . htmlentities(implode("&", $newParams));
}
}

Sign in to reply to this post

11/03/2009 11:28 am  |  #4 brobert123392308

part2 of results

$queryString_WADAReport = sprintf("&totalRows_WADAReport=%d%s", $totalRows_WADAReport, $queryString_WADAReport);
?>
<?php
//WA AltClass Iterator
class WA_AltClassIterator {
var $DisplayIndex;
var $DisplayArray;

function WA_AltClassIterator($theDisplayArray = array(1)) {
$this->ClassCounter = 0;
$this->ClassArray = $theDisplayArray;
}

function getClass($incrementClass) {
if (sizeof($this->ClassArray) == 0) return "";
if ($incrementClass) {
if ($this->ClassCounter >= sizeof($this->ClassArray)) $this->ClassCounter = 0;
$this->ClassCounter++;
}
if ($this->ClassCounter > 0)
return $this->ClassArray[$this->ClassCounter-1];
else
return $this->ClassArray[0];
}
}
?><?php
//WA Alternating Class
$WARRT_AltClass1 = new WA_AltClassIterator(explode("|", "WADAResultsRowDark|"));
?><?php
//WA AltClass Iterator
class WA_AltClassIterator {
var $DisplayIndex;
var $DisplayArray;

function WA_AltClassIterator($theDisplayArray = array(1)) {
$this->ClassCounter = 0;
$this->ClassArray = $theDisplayArray;
}

function getClass($incrementClass) {
if (sizeof($this->ClassArray) == 0) return "";
if ($incrementClass) {
if ($this->ClassCounter >= sizeof($this->ClassArray)) $this->ClassCounter = 0;
$this->ClassCounter++;
}
if ($this->ClassCounter > 0)
return $this->ClassArray[$this->ClassCounter-1];
else
return $this->ClassArray[0];
}
}
?><?php
//WA Alternating Class
$WARRT_AltClass1 = new WA_AltClassIterator(explode("|", "WADAResultsRowDark|"));
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Results Report</title>
<link href="mystyles.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Modular_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Verdana.css" rel="stylesheet" type="text/css" />
<style type="text/css">
/* Title Section */
#WADAPageTitleArea {
width: 555px;
}
#WADAPageTitleArea div, #WADAPageTitleArea p {
font-size: 11px;
padding-bottom: 5px;
}
#WADAPageTitleArea div#WADAPageTitle, #WADAPageTitle {
font-size: 14px;
font-weight: bold;
}

.WADAResults, .WADANoResults {
border-top: 1px solid #BABDC2;
}
.WADAResultsNavigation {
padding-top: 5px;
padding-bottom: 10px;
}
.WADAResultsCount {
font-size: 11px;
}
.WADAResultsNavTop, .WADAResultsInsertButton {
clear: none;
}
.WADAResultsNavTop {
width: 60%;
float: left;
}
.WADAResultsInsertButton {
width: 30%;
float: right;
text-align: right;
}
.WADAResultsNavButtonCell, .WADAResultsInsertButton {
padding: 2px;
}
.WADAResultsTable {
font-size: 11px;
clear: both;
padding-top: 1px;
padding-bottom: 1px;
}

.WADAResultsTableHeader, .WADAResultsTableCell {
padding-right: 5px;
padding-left: 5px;
text-align: left;
}

.WADAResultsTableHeader {
padding-left: 13px;
padding-right: 13px;
}

.WADAResultsTableCell {
padding-left: 14px;
padding-right: 14px;
}

.WADAResultsTableCell {
padding-left: 15px;
padding-right: 15px;
}

.WADAResultsTableCell {
border-left: 1px solid #BABDC2;
}

.WADAResultsEditButtons {
border-left: 1px solid #BABDC2;
border-right: 1px solid #BABDC2;
}

.WADAResultsRowDark {
background-color: #DFE4E9;
}
</style>
<link href="WA_DataAssist/styles/Modular_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Verdana.css" rel="stylesheet" type="text/css" />
<style type="text/css">
/* Title Section */
#WADAPageTitleArea {
width: 555px;
}
#WADAPageTitleArea div, #WADAPageTitleArea p {
font-size: 11px;
padding-bottom: 5px;
}
#WADAPageTitleArea div#WADAPageTitle, #WADAPageTitle {
font-size: 14px;
font-weight: bold;
}

.WADAResults, .WADANoResults {
border-top: 1px solid #BABDC2;
}
.WADAResultsNavigation {
padding-top: 5px;
padding-bottom: 10px;
}
.WADAResultsCount {
font-size: 11px;
}
.WADAResultsNavTop, .WADAResultsInsertButton {
clear: none;
}
.WADAResultsNavTop {
width: 60%;
float: left;
}
.WADAResultsInsertButton {
width: 30%;
float: right;
text-align: right;
}
.WADAResultsNavButtonCell, .WADAResultsInsertButton {
padding: 2px;
}
.WADAResultsTable {
font-size: 11px;
clear: both;
padding-top: 1px;
padding-bottom: 1px;
}

.WADAResultsTableHeader, .WADAResultsTableCell {
padding-right: 5px;
padding-left: 5px;
text-align: left;
}

.WADAResultsTableHeader {
padding-left: 13px;
padding-right: 13px;
}

.WADAResultsTableCell {
padding-left: 14px;
padding-right: 14px;
}

.WADAResultsTableCell {
padding-left: 15px;
padding-right: 15px;
}

.WADAResultsTableCell {
border-left: 1px solid #BABDC2;
}

.WADAResultsEditButtons {
border-left: 1px solid #BABDC2;
border-right: 1px solid #BABDC2;
}

.WADAResultsRowDark {
background-color: #DFE4E9;
}
</style>
</head>

<body>

Sign in to reply to this post

11/03/2009 11:29 am  |  #5 brobert123392308

part3 of results

<div class="WADAResultsContainer"> <a name="top"></a>
<div id="WADAPageTitleArea">
<div id="WADAPageTitle">Page Title</div>
<div><a href="HBCCSearch.php">New Search</a></div>
</div>
<?php if ($totalRows_WADAReport > 0) { // Show if recordset not empty ?>
<div class="WADAResults">
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAReport + 1) ?>
to
<?php echo min($startRow_WADAReport + $maxRows_WADAReport, $totalRows_WADAReport) ?>
of
<?php echo $totalRows_WADAReport ?>
</div>
<div class="WADAResultsNavTop">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="First" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, 0, $queryString_WADAReport); ?>">First</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="Previous" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, max(0, $pageNum_WADAReport - 1), $queryString_WADAReport); ?>">Previous</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Next" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, min($totalPages_WADAReport, $pageNum_WADAReport + 1), $queryString_WADAReport); ?>">Next</a>
</span><?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Last" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, $totalPages_WADAReport, $queryString_WADAReport); ?>">Last</a>
</span><?php } // Show if not last page ?></td>
</tr>
</table>
</div>
<div class="WADAResultsInsertButton"></div>
</div>
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
<tr>
<th class="WADAResultsTableHeader">Case Number:</th>
<th class="WADAResultsTableHeader">Date submitted:</th>
<th class="WADAResultsTableHeader">Event date:</th>
<th class="WADAResultsTableHeader">Event country:</th>
<th class="WADAResultsTableHeader">Event state_us:</th>
<th class="WADAResultsTableHeader">Event province_ca:</th>
<th class="WADAResultsTableHeader">Short description:</th>
<th class="WADAResultsTableHeader">upload1:</th>
<th class="WADAResultsTableHeader">upload2:</th>
<th class="WADAResultsTableHeader">upload3:</th>
<th class="WADAResultsTableHeader">Within 500 ft of ground:</th>
<th>&nbsp;</th>
</tr>
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="WADAResultsTableCell"><a href="HBCCDetails.php?id=<?php echo(rawurlencode($row_WADAReport['id'])); ?>" ><?php echo($row_WADAReport['id']); ?></a></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['submittedDate']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_date']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_country']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_state_us']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_province_ca']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['short_description']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload1']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload2']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload3']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['_fivehundfeet']); ?></td>
<td class="WADAResultsEditButtons" nowrap="nowrap"><table class="WADAEditButton_Table">
<tr>
<td><span id="View<?php echo(rawurlencode($row_WADAReport['id'])); ?>" class="WADATextButton"><a href="HBCCDetails.php?id=<?php echo(rawurlencode($row_WADAReport['id'])); ?>">View</a></span></td>
</tr>
</table></td>
</tr>
<?php } while ($row_WADAReport = mysql_fetch_assoc($WADAReport)); ?>
</table>
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAReport + 1) ?>
to
<?php echo min($startRow_WADAReport + $maxRows_WADAReport, $totalRows_WADAReport) ?>
of
<?php echo $totalRows_WADAReport ?>
</div>
<div class="WADAResultsNavBottom">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="First1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, 0, $queryString_WADAReport); ?>">First</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="Previous1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, max(0, $pageNum_WADAReport - 1), $queryString_WADAReport); ?>">Previous</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Next1" class="WADATextButton">

Sign in to reply to this post

11/03/2009 11:30 am  |  #6 brobert123392308

part 4 of results

<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, min($totalPages_WADAReport, $pageNum_WADAReport + 1), $queryString_WADAReport); ?>">Next</a>
</span><?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Last1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, $totalPages_WADAReport, $queryString_WADAReport); ?>">Last</a>
</span><?php } // Show if not last page ?></td>
</tr>
</table>
</div>
</div>
</div>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_WADAReport == 0) { // Show if recordset empty ?>
<div class="WADANoResults">
<div class="WADANoResultsMessage">No results for your search</div>
<div></div>
</div>
<?php } // Show if recordset empty ?>
</div>


<div class="WADAResultsContainer"> <a name="top"></a>
<div id="WADAPageTitleArea">
<div id="WADAPageTitle">Page Title</div>
<div><a href="HBCCSearch.php">New Search</a></div>
</div>
<?php if ($totalRows_WADAReport > 0) { // Show if recordset not empty ?>
<div class="WADAResults">
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAReport + 1) ?>
to
<?php echo min($startRow_WADAReport + $maxRows_WADAReport, $totalRows_WADAReport) ?>
of
<?php echo $totalRows_WADAReport ?>
</div>
<div class="WADAResultsNavTop">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="First" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, 0, $queryString_WADAReport); ?>">First</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="Previous" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, max(0, $pageNum_WADAReport - 1), $queryString_WADAReport); ?>">Previous</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Next" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, min($totalPages_WADAReport, $pageNum_WADAReport + 1), $queryString_WADAReport); ?>">Next</a>
</span><?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Last" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, $totalPages_WADAReport, $queryString_WADAReport); ?>">Last</a>
</span><?php } // Show if not last page ?></td>
</tr>
</table>
</div>
<div class="WADAResultsInsertButton"></div> </div>
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
<tr>
<th class="WADAResultsTableHeader">Case Number:</th>
<th class="WADAResultsTableHeader">Date Submitted:</th>
<th class="WADAResultsTableHeader">Event date:</th>
<th class="WADAResultsTableHeader">Event country:</th>
<th class="WADAResultsTableHeader">Event state:</th>
<th class="WADAResultsTableHeader">Event province:</th>
<th class="WADAResultsTableHeader">Short description:</th>
<th class="WADAResultsTableHeader">upload1:</th>
<th class="WADAResultsTableHeader">upload2:</th>
<th class="WADAResultsTableHeader">upload3:</th>
<th class="WADAResultsTableHeader">Within 500 ft of ground:</th>
<th>&nbsp;</th>
</tr>
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="WADAResultsTableCell"><a href="HBCCDetails.php?id=<?php echo(rawurlencode($row_WADAReport['id'])); ?>" ><?php echo($row_WADAReport['id']); ?></a></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['submittedDate']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_date']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_country']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_state_us']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['event_province_ca']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['short_description']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload1']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload2']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['upload3']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAReport['_fivehundfeet']); ?></td>
<td class="WADAResultsEditButtons" nowrap="nowrap"><table class="WADAEditButton_Table">
<tr>
<td><span id="View<?php echo(rawurlencode($row_WADAReport['id'])); ?>" class="WADATextButton"><a href="HBCCDetails.php?id=<?php echo(rawurlencode($row_WADAReport['id'])); ?>">View</a></span></td>
</tr>
</table></td>
</tr>
<?php } while ($row_WADAReport = mysql_fetch_assoc($WADAReport)); ?>
</table>
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAReport + 1) ?>
to
<?php echo min($startRow_WADAReport + $maxRows_WADAReport, $totalRows_WADAReport) ?>
of
<?php echo $totalRows_WADAReport ?>
</div>
<div class="WADAResultsNavBottom">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="First1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, 0, $queryString_WADAReport); ?>">First</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport > 0) { // Show if not first page ?><span id="Previous1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, max(0, $pageNum_WADAReport - 1), $queryString_WADAReport); ?>">Previous</a>
</span><?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Next1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, min($totalPages_WADAReport, $pageNum_WADAReport + 1), $queryString_WADAReport); ?>">Next</a>
</span><?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAReport < $totalPages_WADAReport) { // Show if not last page ?><span id="Last1" class="WADATextButton">
<a href="<?php printf("%s?pageNum_WADAReport=%d%s", $currentPage, $totalPages_WADAReport, $queryString_WADAReport); ?>">Last</a>
</span><?php } // Show if not last page ?></td>
</tr>
</table>
</div>
</div>
</div>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_WADAReport == 0) { // Show if recordset empty ?>
<div class="WADANoResults">
<div class="WADANoResultsMessage">No results for your search</div>
<div></div>
</div>
<?php } // Show if recordset empty ?>
</div>
</body>
</html>
<?php
mysql_free_result($WADAReport);
?>

Sign in to reply to this post

11/03/2009 11:31 am  |  #7 brobert123392308

detail part 1

<?php require_once('Connections/connNids.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
if (!session_id()) session_start();
?>
<?php
$Paramid_WADAReport = "-1";
if (isset($_GET['id'])) {
$Paramid_WADAReport = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
$ParamSessionid_WADAReport = "-1";
if (isset($_SESSION['WADA_Insert_Report'])) {
$ParamSessionid_WADAReport = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_Report'] : addslashes($_SESSION['WADA_Insert_Report']);
}
$Paramid2_WADAReport = "-1";
if (isset($_GET['id'])) {
$Paramid2_WADAReport = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_connNids, $connNids);
$query_WADAReport = sprintf("SELECT id, submittedDate, last_name, first_name, primary_email, secondary_email, street_address, city, county, state_us, province_ca, zip_code, country, pri_phone, sec_phone, event_date, event_time, event_country, event_state_us, event_province_ca, event_city, event_county, num_witnesses, number_objects, short_description, long_description, upload1, upload2, upload3, _shape, _fivehundfeet FROM Report WHERE id = %s OR ( -1= %s AND id= %s)", GetSQLValueString($Paramid_WADAReport, "int"),GetSQLValueString($Paramid2_WADAReport, "int"),GetSQLValueString($ParamSessionid_WADAReport, "int"));
$WADAReport = mysql_query($query_WADAReport, $connNids) or die(mysql_error());
$row_WADAReport = mysql_fetch_assoc($WADAReport);
$totalRows_WADAReport = mysql_num_rows($WADAReport);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Details Report</title>
<link href="mystyles.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Modular_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Verdana.css" rel="stylesheet" type="text/css" />
<style type="text/css">
/* Title Section */
#WADAPageTitleArea {
width: 555px;
}
#WADAPageTitleArea div, #WADAPageTitleArea p {
font-size: 11px;
padding-bottom: 5px;
}
#WADAPageTitleArea div#WADAPageTitle, #WADAPageTitle {
font-size: 14px;
font-weight: bold;
}

/* Details page CSS */
.WADADetailsContainer {
font-size: 11px;
}
#WADADetails, .WADANoResults {
border-top: 1px solid #BABDC2;
padding-top: 5px;
}
</style>
</head>

<body>


<div class="WADADetailsContainer"> <a name="top"></a>
<div id="WADAPageTitleArea">
<div id="WADAPageTitle">Page Title</div>
<div><a href="HBCCSearch.php">New Search</a></div>
</div>
<?php if ($totalRows_WADAReport > 0) { // Show if recordset not empty ?>
<div id="WADADetails">
<div class="WADAHeader">Details</div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">Case Number:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['id']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Date Submitted:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['submittedDate']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Last name:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['last_name']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">First name:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['first_name']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Primary email:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['primary_email']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Secondary email:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['secondary_email']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Street address:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['street_address']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">City:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['city']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">County:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['county']); ?></td>

Sign in to reply to this post

11/03/2009 11:32 am  |  #8 brobert123392308

detail part 2

</tr>
<tr>
<th class="WADADataTableHeader">State:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['state_us']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Province:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['province_ca']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Zip code:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['zip_code']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Country:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['country']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Primary phone:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['pri_phone']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Secondary phone:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['sec_phone']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event date:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_date']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event time:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_time']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event country:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_country']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event state:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_state_us']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event province:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_province_ca']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event city:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_city']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Event county:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['event_county']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Number of witnesses:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['num_witnesses']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Number of objects:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['number_objects']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Short description:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['short_description']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Long description:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['long_description']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload1:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['upload1']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload2:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['upload2']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">upload3:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['upload3']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Shape:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['_shape']); ?></td>
</tr>
<tr>
<th class="WADADataTableHeader">Within 500 ft of ground:</th>
<td class="WADADataTableCell"><?php echo($row_WADAReport['_fivehundfeet']); ?></td>
</tr>
</table>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><span id="Results" class="WADATextButton"><a href="HBCCResults.php">Results</a></span></td>
</tr>
</table>
</div>
</div>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_WADAReport == 0) { // Show if recordset empty ?>
<div class="WADANoResults">
<div class="WADANoResultsMessage">No record found.</div>
</div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADADetailsLinkArea">
<div class="WADADataNavButtonCell"><span id="Results1" class="WADATextButton"><a href="HBCCResults.php">Results</a></span></div>
</div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<?php } // Show if recordset empty ?>
</div>
</body>
</html>
<?php
mysql_free_result($WADAReport);
?>

Sign in to reply to this post

11/03/2009 1:53 pm  |  #9 Jason ByrnesWebAssist

You have also submitted this issue in another thread for which I opens a support ticket.

Please reply to your support ticket by logging into your support history:
supporthistory.php

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?

Everything else!

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.

go to page top
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...