--
Hector Virgen
Sent from my Droid X
On Sep 20, 2010 10:35 PM, "sina miandashti" <miandashti@gmail.com> wrote:
> hi all zend developers
>
> im using zend_auth for auth stuff of my application
>
> i wanna disable the case sensitive check for usernames in zend_auth
>
> for ex. USERNAME = username = UserName = useRnAme
>
> ?
>
> --
> ________________
> Sincerely
> Sina Miandashti
> MuSicBasE.ir & InvisionPower.ir Admin
im using zend_auth for auth stuff of my application
i wanna disable the case sensitive check for usernames in zend_auth
for ex. USERNAME = username = UserName = useRnAme
?
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
I don't have fast-cgi installed and this is an out of the box install of
Zend Server CE 5.0.3
Thanks
Lionel
emulating LIMIT and OFFSET for SQL Server is quite tricky.
ZF generates the following SQL for SQL Server for limit=10 and offset=20:
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 30 "foobar".* FROM "foobar"
ORDER BY "foobar" ASC) AS inner_tbl ORDER BY "foobar" DESC) AS outer_tbl
ORDER BY "foobar" asc
Though this will not work for the last result set ...
This could be fixed in Sqlsrv Adapter by using MSSQL's ROW_NUMBER(), but
there are two big problems with that solution:
- ROW_NUMBER() was introduced with SQL Server 2005, so SQL Server 2000
would no longer be supported by ZF.
- ROW_NUMBER()'s performance is quite weak.
Plus, the code in Zend_Db_Adapter_Sqlsrv::limit would get even weirder ...
Perhaps you could create a new Paginator Adapter and write some ugly hacks
to get this working, but I don't think it's worthwhile.
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Db-Table-Select-Pagination-and-Sqlsrv-tp2544029p2545610.html
Sent from the Zend DB mailing list archive at Nabble.com.
I have previously used a Zend_Db_Table_Select object for pagination with
MySQL and Postgresql with great success. And now that I am forced to work
on this project in SQL Server 2008, using the Microsoft-provided Sqlsrv
drivers for PHP on Windows, I am coming across an interesting issue. The
pagination is "working", as I see the appropriate links where I should, the
proper number of items are displayed per page, etc. However, on the last
page, I am seeing the maximum number of items, even though some of them
appeared on the next-to-last page. For example: I have a table with 22
rows, and I have it set to display 10 rows per page. The first two pages
will show 1-10, then 11-20, but then the 3rd page shows 10 records (numbered
21-30), even though there are only 22 records. The last two items on the
last page are the only ones that should be showing up, as the first 8 were
already displayed on the previous page. This has caused a great amount of
confusion to my users. They are asking why there are 30 records shown, when
there's only 22 in the database. I have been forced to change my pagination
method to use an Array, thereby losing all of the benefits that I really
need.
To confirm this only happens with SQL Server, I created an identical table
in MySQL and copied all the data over. I changed my config.ini to point to
the MySQL server, and everything displays as it should.
Is this because of the fact that SQL Server doesn't support LIMIT the same
way as MySQL and Postgresql? I was under the impression that the Zend_Db
adapter would mimic this functionality for SQL Server.
Thanks in advance,
Joey
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Db-Table-Select-Pagination-and-Sqlsrv-tp2544029p2544029.html
Sent from the Zend DB mailing list archive at Nabble.com.
-- Hector Virgen <djvirgen@gmail.com> wrote
(on Thursday, 16 September 2010, 02:00 PM -0700):
> Can someone please unsubscribe Bank of America? Thanks :)
>
> --
> Hector Virgen
> Sent from my Droid X
>
> ---------- Forwarded message ----------
> From: "online" <online@bankofamerica.com>
> Date: Sep 16, 2010 1:37 PM
> Subject: Re: [fw-mvc] Deploying Zend Application (KMM116055210I91L0KM)
> To: "Hector Virgen" <djvirgen@gmail.com>
>
> Dear Hector Virgen,
>
> Thank you for your inquiry dated 09/16/2010 regarding webserver. We are
> committed to providing you with the best banking experience possible and
> we will be happy to assist you.
>
> While we make every effort to assist our customers who contact us by
> e-mail, there are certain situations which require a conversation with
> an account specialist. To provide you with the most accurate and
> efficient service, we ask that you contact Customer Service department
> at 1.800.432.1000 from 7 a.m. to 10 p.m. Monday to Friday and 8 a.m. to
> 5 p.m. Saturdays and Sundays.
>
> Please be assured that we know your time is valuable and would not
> direct you to contact us by telephone unless absolutely necessary like
> it is in this case.
>
> We apologize for any inconvenience this may have caused. We value you as
> a customer and appreciate your business. If we may be of further
> assistance, please contact us again by e-mail. Thank you for choosing
> Bank of America.
>
>
> Sincerely,
>
> Rene Hermosillo
> Bank of America
>
>
> This message is in response to your recent request. If you are not the
> addressee please contact us. Any reply to this e-mail will not be
> secure; please do not respond with personal or confidential information.
>
--
Matthew Weier O'Phinney
Project Lead | matthew@zend.com
Zend Framework | http://framework.zend.com/
PGP key: http://framework.zend.com/zf-matthew-pgp-key.asc
Not sure, but sometimes when I reply to ZF messages I get this auto-responder from BofA's CS dept.
--
Hector VirgenSr. Web DeveloperWalt Disney Parks and Resorts Online
On Thu, Sep 16, 2010 at 6:10 PM, Abraham Block <atblock@gmail.com> wrote:how did you manage this exactly?On Thu, Sep 16, 2010 at 5:00 PM, Hector Virgen <djvirgen@gmail.com> wrote:
Can someone please unsubscribe Bank of America? Thanks :)
--
Hector Virgen
Sent from my Droid X---------- Forwarded message ----------
From: "online" <online@bankofamerica.com>
Date: Sep 16, 2010 1:37 PM
Subject: Re: [fw-mvc] Deploying Zend Application (KMM116055210I91L0KM)
To: "Hector Virgen" <djvirgen@gmail.com>
Dear Hector Virgen,
Thank you for your inquiry dated 09/16/2010 regarding webserver. We are
committed to providing you with the best banking experience possible and
we will be happy to assist you.
While we make every effort to assist our customers who contact us by
e-mail, there are certain situations which require a conversation with
an account specialist. To provide you with the most accurate and
efficient service, we ask that you contact Customer Service department
at 1.800.432.1000 from 7 a.m. to 10 p.m. Monday to Friday and 8 a.m. to
5 p.m. Saturdays and Sundays.
Please be assured that we know your time is valuable and would not
direct you to contact us by telephone unless absolutely necessary like
it is in this case.
We apologize for any inconvenience this may have caused. We value you as
a customer and appreciate your business. If we may be of further
assistance, please contact us again by e-mail. Thank you for choosing
Bank of America.
Sincerely,
Rene Hermosillo
Bank of America
This message is in response to your recent request. If you are not the
addressee please contact us. Any reply to this e-mail will not be
secure; please do not respond with personal or confidential information.
