Native code:1054

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
realkzeal
Forum Newbie
Posts: 3
Joined: Mon Oct 26, 2009 5:50 am

Native code:1054

Post by realkzeal »

Notice: _doQuery: [Error message: Could not execute statement] [Last executed query: CALL Insert_CompanyProfile(dk, kdkd, ganme, dkdkd, kddkkd, kddkdk, 2000, 1999, dkddk, wwwww, email, oooooooooo, 7, 11, 0, 0)] [Native code: 1054] [Native message: Unknown column 'dk' in 'field list']

private function QuoteParameter($quoteString, $dataType)
{
$toQuote = $this->db->quote($quoteString, $dataType);
if (PEAR::isError($toQuote))
trigger_error($toQuote->getUserinfo());
return $quoteString;
}

public function InsertStoredProc($procedureName, $quoteParams, $dataType)
{
$dataToQuote = array("text", "text", "text", "text", "text", "text", "date", "date", "text", "text", "text", "text", "text", "integer", "integer", "integer", "integer");
$quoted = "";
foreach($quoteParams as $key =>$value)
{
for($i =0; $i <= $dataType[$i]; $i++)
{
$k++;
$quoted[$k] = $this->QuoteParameter($value, $dataToQuote[$k]);
echo $dataToQuote[$k]." #### ".$this->QuoteParameter($value, $dataToQuote[$k])." <br /> ";
}
}
print_r($quoted);
$result = $this->db->executeStoredProc($procedureName, $quoted);
if (PEAR::isError($result))
trigger_error($result->getUserinfo());
}
$test = new SubmitManager();
$test->addCompany();
Post Reply