October 15th, 2003, 10:53 AM
|
|
Registered User
|
|
Join Date: Apr 2002
Posts: 5
Time spent in forums: 17 m 31 sec
Reputation Power: 0
|
|
|
MS Access gives "BOF or EOF is true when SELECTING last entry
Hello
when I try to run a "SELECT * FROM Contracet WHERE phone='phone'" or any call that would pick the las row in the DB givs me the error
Warning: find1(): PropGet() failed: Exception occurred. Source: ADODB.Field Description: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. in H:\Documents and Settings\Don\Desktop\projects\form.php on line 179
and the line number iseny where i call
rs_NAME->value
name changing for each veriable
any i deas on how to prevent this
Thanks
Don
here is the code
PHP Code:
<?
function find1 ($form) {
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("./ssatellite.mdb") . " ;DefaultDir=" . realpath("./");
$db_connection->open($db_connstr);
$sql = "";
foreach ($form as $k => $v) {
if ($v != ""){
if ($k == "Customer_Name" || $k == "Phone") {
$sql .= "$k='$v'";
}
}
}
$rs = $db_connection->execute("SELECT * FROM Contracts WHERE $sql");
$rs_ID = $rs->Fields(ID);
$rs_Date_1 = $rs->Fields(Date_1);
$rs_Date_2 = $rs->Fields(Date_2);
$rs_Date_3 = $rs->Fields(Date_3);
$rs_Agent = $rs->Fields(Agent);
$rs_Source = $rs->Fields(Source);
$rs_in_Date_1 = $rs->Fields(in_Date_1);
$rs_in_Date_2 = $rs->Fields(in_Date_2);
$rs_in_Date_3 = $rs->Fields(in_Date_3);
$rs_Day = $rs->Fields(Day);
$rs_DAY_AM_PM = $rs->Fields(DAY_AM_PM);
$rs_Customer_Name = $rs->Fields(Customer_Name);
$rs_Address = $rs->Fields(Address);
$rs_City = $rs->Fields(City);
$rs_State = $rs->Fields(State);
$rs_Zip = $rs->Fields(Zip);
$rs_Bill_to = $rs->Fields(Bill_to);
$rs_Phone = $rs->Fields(Phone);
$rs_Cell = $rs->Fields(Cell);
$rs_Work = $rs->Fields(Work);
$rs_Billing = $rs->Fields(Billing);
$rs_CC_Number = $rs->Fields(CC_Number);
$rs_SS_Number = $rs->Fields(SS_Number);
$rs_Receiver_Serial_1 = $rs->Fields(Receiver_Serial_1);
$rs_Smart_Card_1 = $rs->Fields(Smart_Card_1);
$rs_Receiver_Serial_2 = $rs->Fields(Receiver_Serial_2);
$rs_Smart_Card_2 = $rs->Fields(Smart_Card_2);
$rs_Num_Receiver = $rs->Fields(Num_Receiver);
$rs_Promotion = $rs->Fields(Promotion);
$rs_Equipment = $rs->Fields(Equipment);
$rs_Equipment_1 = $rs->Fields(Equipment_1);
$rs_Equipment_2 = $rs->Fields(Equipment_2);
$rs_Accessories = $rs->Fields(Accessories);
$rs_Accessories_1 = $rs->Fields(Accessories_1);
$rs_Accessories_2 = $rs->Fields(Accessories_2);
$rs_Installation_Notes = $rs->Fields(Installation_Notes);
$rs_Installation_Notes_1 = $rs->Fields(Installation_Notes_1);
$rs_Installation_Notes_2 = $rs->Fields(Installation_Notes_2);
$rs_tax = $rs->Fields(tax);
$rs_total = $rs->Fields(total);
?>
<html>
<body>
<form name="Main" method="post" action="<?= $_SERVER['PHP_SELF']; ?>">
<table width="750" border="0" align="center">
<tr>
<td colspan="6" align="center"> <h1>System Satellite</h1></td>
</tr>
<tr>
<td colspan="6" align="center"> <h2>1-888-634-8327</h2></td>
</tr>
<tr>
<td width="284">Date:
<input value="<?= $rs_Date_1->Value; ?>" name="Date_1" type="text" size="1">
/ <input value="<?= $rs_Date_1->Value; ?>" name="Date_2" type="text" size="1">
/ <input value="<?= $rs_Date_1->Value; ?>" name="Date_3" type="text" size="1"></td>
<td colspan="2">Agent: <input value="<?= $rs_Agent->Value; ?>" type="text" name="Agent"></td>
....................
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
