Re: [fw-general] Zend Auth: Advanced Usage By Example

2008-11-30 Thread Bruno Friedmann
Sorry Jason in Postgresql something refer to a db, schema, table, column name so a 0=0 - column doesn't exist but yes a select false = '0' is true. But here what I've use as code which work in similar conditions $db = Zend_Db_Table_Abstract::getDefaultAdapter(); $dbAdapter = new

Re: [fw-general] Zend Auth: Advanced Usage By Example

2008-11-30 Thread dele454
Thanks for your response. Doesnt work either. Access is stillo granted :( Bruno Friedmann-2 wrote: Hi Just a word : be carefull with 0/1 TRUE/FALSE and the type of your column and the database used. I suspect if you write you $authAdapter = new Zend_Auth_Adapter_DbTable($db,

Re: [fw-general] Zend Auth: Advanced Usage By Example

2008-11-30 Thread dele454
AWESOME WORKS PERFECTLY :) Thank you so so much Bruno. I wonder why the password placeholder is needed there. Anyway thanks a mil :) Bruno Friedmann-2 wrote: Sorry Jason in Postgresql something refer to a db, schema, table, column name so a 0=0 - column doesn't exist but yes a

Re: [fw-general] Zend Auth: Advanced Usage By Example

2008-11-29 Thread Bruno Friedmann
Hi Just a word : be carefull with 0/1 TRUE/FALSE and the type of your column and the database used. I suspect if you write you $authAdapter = new Zend_Auth_Adapter_DbTable($db, 'Members', 'Email', 'Password', 'AND IsActive != 0'); AND IsActive != 0 this would work ... :-) As another advice

Re: [fw-general] Zend Auth: Advanced Usage By Example

2008-11-29 Thread Jason Webster
Not really... SELECT 0 = 0 // true SELECT FALSE = 0 // true SELECT FALSE = 0 // true Bruno Friedmann wrote: Hi Just a word : be carefull with 0/1 TRUE/FALSE and the type of your column and the database used. I suspect if you write you $authAdapter = new Zend_Auth_Adapter_DbTable($db,

[fw-general] Zend Auth: Advanced Usage By Example

2008-11-28 Thread dele454
Am trying to implement a similar scenario where if the column IsActive is set to '0' the authentication should fail. A typical scenario is when a user just signed up and still needs to active acct before allowed to gain access. I followed the instruction in the Ref Guide but it isnt working. If