php-windows Digest 10 Mar 2004 20:56:47 -0000 Issue 2158
Topics (messages 23089 through 23097):
Help with authenication against exchange 5.5 through LDAP
23089 by: Rabih
23090 by: Firman Wandayandi
Re: sybase versus odbc
23091 by: Robert Twitty
Paging using PHP and sql server
23092 by: Harpreet
23093 by: David Felton
23094 by: Harpreet
23095 by: David Felton
23096 by: Svensson, B.A.T. (HKG)
23097 by: Harpreet
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hello,
I am trying to authenticate my users to the LDAP directory on exchange 5.5.
Anyone has an idea on how to do it plz ??
I am using PHP discussion forum, MYSQL, and IIS as the web server. Any Help
would be highly appreciated.
Thanks a lot..
--- End Message ---
--- Begin Message ---
Hi Rabih!
Try PEAR::Auth package. http://pear.php.net/package/Auth
Regards,
Firman
----- Original Message -----
From: "Rabih" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 6:36 PM
Subject: [PHP-WIN] Help with authenication against exchange 5.5 through LDAP
> Hello,
>
> I am trying to authenticate my users to the LDAP directory on exchange
5.5.
> Anyone has an idea on how to do it plz ??
> I am using PHP discussion forum, MYSQL, and IIS as the web server. Any
Help
> would be highly appreciated.
>
> Thanks a lot..
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
The sybase extension is probably more efficient than the odbc ext. You
can also try the odbtp extension at http://odbtp.sourceforge.net. I use
it to connect to Sybase, and it is considerably faster than the odbc
extension, and it provides more capabilities.
-- bob
On Wed, 10 Mar 2004 [EMAIL PROTECTED] wrote:
> we have sybase db, and using odbc for queries in our
> web based application.
> i want to learn : in php, are sybase functions more
> efficient than odbc functions?
> Thanks...
> emrah
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Search - Find what you’re looking for faster
> http://search.yahoo.com
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
I have created a few reports using sql server and PHP. The reports work just
fine except that we have like 19000 records per report. I would like to do
some paging within the reports 1 | 2 | 3 | 4 so that a user can view may be
1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--- End Message ---
--- Begin Message ---
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work just
fine except that we have like 19000 records per report. I would like to do
some paging within the reports 1 | 2 | 3 | 4 so that a user can view may be
1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************
--- End Message ---
--- Begin Message ---
I am using sql server and it does not support limit funtion
-----Original Message-----
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:27 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work just
fine except that we have like 19000 records per report. I would like to do
some paging within the reports 1 | 2 | 3 | 4 so that a user can view may be
1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************
--- End Message ---
--- Begin Message ---
With SQL server you have to do something like
select top $number id from tablename
...
where id not in (select top $offset id from tablename)
where $number is the number of results you want and $offset is the offset
(surprisingly) The subselect needs to be the same as your main query in
everything but the number of rows you are selecting.
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:35
To: [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
I am using sql server and it does not support limit funtion
-----Original Message-----
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:27 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work just
fine except that we have like 19000 records per report. I would like to do
some paging within the reports 1 | 2 | 3 | 4 so that a user can view may be
1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
First, as you might know, you can use "SELECT TOP <n> ... FROM ...", but
that will probably not help you that very much.
But are you able to alter the tables, or do you have a numeric values in
some of the attributes with witch you can do "WHERE ... and <some attribute>
BETWEEN @min AND @max". Unless <some attribute> is in strict order you will
only get aproximatly 1000 records this way.
Another way to do this is (if you are not able to, or don't want to alter
the first table(s)) is to dump the SELECT into another table
like "INSERT INTO <temptable> .. SELECT ...". The <temptable> should then
contain one extra atrtribute. That is an auto incremental key. This will
ensure that you get a full complet ordered set. Aftr this its simple to do a
".. AND <auto key> BETWEEN @FROM AND (@[EMAIL PROTECTED])"
An alternative would be - which will be much slower - to define a cursor
that irrerates 1000 times depending on some fragmentation index or FROM_TO
you feed the sp with.
Yet another alternative (just to relate to the PHP list ;) is to read up
everything in an array in PHP and do the same kind of itteration, but with
php - possible using ob_flush() to speed up the output to the browser.
There is more ways, but with this I am sure you spin off and find the
solution that fits you the best.
-----Original Message-----
From: Harpreet
To: [PHP-WIN]
Sent: 10-3-2004 17:35
Subject: RE: [PHP-WIN] Paging using PHP and sql server
I am using sql server and it does not support limit funtion
-----Original Message-----
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:27 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work
just fine except that we have like 19000 records per report. I would like to
do some paging within the reports 1 | 2 | 3 | 4 so that a user can view may
be 1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
This seems to work preety nice but the only problme i am having is I want to
allow the user to sort by field names .
My sql works just fine without the order by clause.The order by clause keeps
returning the same values.
How can i use an order by clause
my sql is as follows
select top 50 matid,title,comment from table where matid not in (select top
100 matid from table) order by matid desc
Thanks
I am almost there i think.
Thanks for all the help
-----Original Message-----
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:39 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
With SQL server you have to do something like
select top $number id from tablename
...
where id not in (select top $offset id from tablename)
where $number is the number of results you want and $offset is the offset
(surprisingly) The subselect needs to be the same as your main query in
everything but the number of rows you are selecting.
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:35
To: [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
I am using sql server and it does not support limit funtion
-----Original Message-----
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:27 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work just
fine except that we have like 19000 records per report. I would like to do
some paging within the reports 1 | 2 | 3 | 4 so that a user can view may be
1000 records per page and can navigate to other pages if needed.
Help is appreciated
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**********************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
