Problem DB->fetchall()

chris_hird · #1 (**permalink**) 02-19-2007, 08:03 PM

Hi

I am having problems with the above call. Here are the code segments which important plus a clip from the joblog created by the call.

Quote:

30 02/19/07 14:51:21.518832 QSQRUN1 QSYS *STMT QSQRUN1
From user . . . . . . . . . : QTMHHTTP
From module . . . . . . . . : QSQPREP
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 11025
To module . . . . . . . . . : QSQPREP
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 11025
Message . . . . : Column CHRISH not in specified tables.
Cause . . . . . : CHRISH is not a column of table *N in *N. If the table
*N, CHRISH is not a column of any table or view that can be referenced.
Recovery . . . : Do one of the following and try the request again: --

Here is the code for the call.

Quote:

$params = array(
'host' => 'localhost',
'username' => '',
'password' => '',
'dbname' => 'S1062EBB'
);

try {
$DB = Zend_Db::factory('Db2' , $params);
}
catch (Exception $e) {
die("Failed in factory " . $e->getMessage());
}

$select = $DB->select();
$select->from('SHIELDCRM.USERS', '*');
$select->where('USRNAME = ?', $_POST['username']);
$select->where('PASSWD = ?', $_POST['password']);
$sql = $select->__toString();
echo $sql;

try {
$rowsFound = $DB->fetchAll($select);
}
catch (ErrorException $e){
die("Failed fetchall" . $e->getMessage());
}

if (isset($rowsFound[0]["username"])) {
echo "found row";
$this->_redirect('/');
}

else {
echo "Login information incorrect. Please <a href='/user/login'>try again</a>.";
}

The echo of the statement shows the following..

Quote:

SELECT * FROM SHIELDCRM.USERS WHERE USRNAME = chrish AND PASSWD = password
Warning: db2_prepare() [function.db2-prepare]: Statement Prepare Failed in /www/shieldcrm/library/Zend/Db/Statement/Db2.php on line 258

Warning: db2_stmt_errormsg() expects parameter 1 to be resource, boolean given in /www/shieldcrm/library/Zend/Db/Statement/Db2.php on line 261

Warning: db2_stmt_error() expects parameter 1 to be resource, boolean given in /www/shieldcrm/library/Zend/Db/Statement/Db2.php on line 261

I using a normal login page and the above print shows the POST variables are correctly sent to the SELECT object...

Why is it being converted to show the CHRISH as a column not an entry in the column

here is the DB it should be reading.

Quote:

Display Physical File Member
File . . . . . . : USERS Library . . . . : SHIELDCRM
Member . . . . . : USERS Record . . . . . : 1
Control . . . . . Column . . . . . : 1
Find . . . . . . .
*...+....1....+....2....+....3....+....4....+....5 ....+....6....+....7..
Chris Hird chrish@shield.on.ca
Alison Hird alison@shield.on.ca
.8....+....9....+....0....+....1....+....2....+... .3....+....4....+....5....+.
chrish nopass
alison passwo

These appear to be right and I can update using the DB->insert OK?

Chris..

Cristian · #2 (**permalink**) 02-19-2007, 10:11 PM

Mmmmm...

Won't be easy to reply since got no DB2 server for testing...

Added later: only Mysql and Mssql i tested before....

chris_hird · #3 (**permalink**) 02-19-2007, 11:13 PM

OK So I can help but I dont know where to start looking, I am new to the Framework so I need to know where to start fishing around and see if I cant understand myself and then try to fix. After that I can send a suggested fix to the developers.

Chris...

chris_hird · #4 (**permalink**) 02-20-2007, 01:00 AM

Here is where I think its going wrong?

Quote:

// split into text and params
$this->_sqlSplit = preg_split(
"/(\?|\:[a-z]+)/",
$sql,
-1,
PREG_SPLIT_DELIM_CAPTURE|PREG_SPLIT_NO_EMPTY
);

// map params
$this->_sqlParam = array();
foreach ($this->_sqlSplit as $key => $val) {
if ($val[0] == ':' || $val[0] == '?') {
$this->_sqlParam[] = $val; // key *2 +1 is the parsed position
}
}

// set up for binding
$this->_bindParam = array();

Somehow the Db2 Parms get read in the wrong order? I was wondering if I should just change the order and see what happens?

What do you think?

Chris...

chris_hird · #5 (**permalink**) 02-20-2007, 02:21 AM

Nope dont think this is the issue! Let me kow what tests you need to do and I will set them up. If you have scripts etc I will happily load them and let you have the output.

Chris...

chris_hird · #6 (**permalink**) 02-24-2007, 02:38 PM

OK looks like this is not something I can move forward.

Thanks for the help..

Cristian · #7 (**permalink**) 02-24-2007, 03:02 PM

Sorry, can't figure the error, no DB2 here too...

Question: did u tried with 0.8.0 ? Maybe was a bug or something...

chris_hird · #8 (**permalink**) 02-24-2007, 03:09 PM

I will try but I think I will try to add to the bug tracker to see if anyone else can help? I have the tools just dont have the knowledge of the Framework to be able to debug correctly..

If it does get sorted I will post here as well.

Chris..

Cristian · #9 (**permalink**) 02-24-2007, 03:17 PM

Please do so...

Were waiting u back here

chris_hird · #10 (**permalink**) 02-27-2007, 09:27 PM

I installed 8.0 and the same problem exists. I dont know why its flipping the Column to content around so if anyone who has intimate knowledge of the Framework can push me to the right section of code where the data is added to the variables or arrays I can start to do some debug of my own. Happy to share what I find of course, I just need to get this resolved so I can move forward on the project.

Chris...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode