php-windows Digest 7 Feb 2004 13:49:49 -0000 Issue 2111
Topics (messages 22753 through 22760):
PHP with Apache to use SSI
22753 by: Mike Jamba
Re: SQL to select a set of records
22754 by: Svensson, B.A.T. (HKG)
22755 by: Svensson, B.A.T. (HKG)
22756 by: Svensson, B.A.T. (HKG)
PHP how to connect Access
22757 by: Alex
22758 by: Svensson, B.A.T. (HKG)
22759 by: Svensson, B.A.T. (HKG)
Re: URGENT - Enabling mcrypt() in PHP 4.3.3 on Windows XP (windows installer
22760 by: Svensson, B.A.T. (HKG)
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,
Hello I got SSI working with Apache 2.0.47 and PHP
4.3.4 using .shtml files
I got it working by adding:
AddType text/html .shtml
AddHandler server-parsed .shtml
But the problem with this is - the .php script that
was included in a .shtml file would NOT get the
HTTP_GET_VARS varibles that the .php file needed.
(basically the same page was loaded again)
Is there a fix for this? BTW I am using XP
Thanks for any help!
Cheers,
Mike.
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--- End Message ---
--- Begin Message ---
You can't posssible have run /my/ script and not get it working,
unless you done a copy error. The query you list below is fualty
and wont work as specified.
-----Original Message-----
From: Herhuth, Ron
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 2004-02-06 15:12
Subject: RE: [PHP-WIN] SQL to select a set of records
Okay I tried this and while it doesn't error out I still only get the
first 10 records, if I change the first number I get the number of
records that I changed the number to. If I change the second number nothing
happens.
SELECT TOP 10 dbo.individual.id, last_name, first_name
FROM dbo.individual
WHERE dbo.individual.id NOT IN
(SELECT TOP 30 individual.id
FROM dbo.individual)
Thanks for the help,
Ron
>From: Svensson, B.A.T. (HKG)
>To: '[EMAIL PROTECTED]'
>Sent: 02/06/2004 8:42 AM
>set nocount on
>create table test (a int , b char(1))
>create table test_tmp (a int , b char(1))
>
>
>insert into test values (1, 'a')
>insert into test values (2, 'a')
>insert into test values (3, 'b')
>insert into test values (4, 'b')
>insert into test values (5, 'c')
>insert into test values (6, 'c')
>insert into test values (7, 'd')
>insert into test values (8, 'd')
>insert into test values (9, 'e')
>insert into test values (10, 'e')
>insert into test values (11, 'e')
>insert into test values (12, 'e')
>insert into test values (13, 'e')
>insert into test values (14, 'e')
>insert into test values (15, 'e')
>insert into test values (16, 'e')
>insert into test values (17, 'e')
>insert into test values (18, 'e')
>insert into test values (19, 'e')
>insert into test values (20, 'e')
>insert into test values (21, 'e')
>insert into test values (22, 'e')
>insert into test values (23, 'e')
>insert into test values (24, 'e')
>insert into test values (25, 'e')
>insert into test values (26, 'e')
>insert into test values (27, 'e')
>insert into test values (28, 'e')
>insert into test values (29, 'e')
>insert into test values (30, 'e')
>
>insert into test_tmp
>select top 25 *
>from test
>order by a asc
>
>select *
>from test_tmp
>where a in(
> select top 15 a
> from test_tmp
> order by a desc
>)
>order by a asc
>
>drop table test_tmp
>drop table test
>
>
>
>
>-----Original Message-----
>From: Stuart
>To: David Felton
>Cc: Nadim Attari; [EMAIL PROTECTED]; Herhuth, Ron
>Sent: 2004-02-06 13:44
>Subject: Re: [PHP-WIN] SQL to select a set of records
>
>David Felton wrote:
>> SELECT TOP 10 dbo.Table_MIS_Files.File_ID
>> FROM dbo.Table_MIS_Files
>> WHERE dbo.Table_MIS_Files.File_ID NOT IN
>> (SELECT TOP 25 dbo.Table_MIS_Files.File_ID
>> FROM dbo.Table_MIS_Files)
>
>Shouldn't this be...
>
>SELECT TOP 25 dbo.Table_MIS_Files.File_ID
>FROM dbo.Table_MIS_Files
>WHERE dbo.Table_MIS_Files.File_ID NOT IN
>(SELECT TOP 10 dbo.Table_MIS_Files.File_ID
>FROM dbo.Table_MIS_Files)
>
>That will get rows 11-25.
>--
>Stuart
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
That's why I added the "drop table ..." in the end, smart ass. ;) =)
-----Original Message-----
From: Frank M. Kromann
To: Svensson, B.A.T. (HKG)
Cc: '[EMAIL PROTECTED]'
Sent: 2004-02-06 17:15
Subject: RE: [PHP-WIN] SQL to select a set of records
create table #test (a int , b char(1))
create table #test_tmp (a int , b char(1))
Would make these tables real temp tables. These will be deleted wehn the
connection is closed.
--- End Message ---
--- Begin Message ---
Why don't you just use a position cursor?
Do you get a performance hit if you do it?
-----Original Message-----
From: Herhuth, Ron
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Herhuth, Ron
Sent: 2004-02-06 18:05
Subject: RE: [PHP-WIN] SQL to select a set of records
It doesn't matter neither one works...they only bring back the first x
number of records.
Ron
>From: David Felton
>To: Stuart
>Sent: 02/06/2004 11:24 AM
>No. What I said was correct, as Ron wanted rows 25-35.
>
>-----Original Message-----
>From: Stuart [mailto:[EMAIL PROTECTED]
>Sent: 06 February 2004 12:45
>To: David Felton
>Cc: Nadim Attari; [EMAIL PROTECTED]; Herhuth, Ron
>Subject: Re: [PHP-WIN] SQL to select a set of records
>
>
--- End Message ---
--- Begin Message ---
thanks
--
truely yours
Alex
--- End Message ---
--- Begin Message ---
>From: Alex
>Subject: [PHP-WIN] PHP how to connect Access
>thanks
If you state your problem in more detials, you might
actyally get some help...
--
P.S.
Please also notice, that we want to help out, but our
mind reading capabilities are low during this period
due to intensive solar activities.
D.S.
--- End Message ---
--- Begin Message ---
-----Original Message-----
From: Svensson, B.A.T. (HKG)
>actyally get some help...
Actually, actyally actually.
--- End Message ---
--- Begin Message ---
You suffer from a seriouse attitude problem - do you think I,
or anybody else, get paid answer your "urgent" matters with
a "simple step-by-step guide with full explanations as soon
as possible"?
First make sure you done your homework properly before asking
for a "simple step-by-step guide with full explanations".
You figured out how to send a mail to the php-windows list,
then figure this out to:
1) Read The Fine (Fucking) Manual (http://www.php.net/manual)
2) Read the FAQ's (same base URL as above)
3) Search old mailing list (same base URL as above)
4) If still not able to solve the problem, post masseage for help
Kind regards,
//Anders
P.S.
Telling a matter is urgent (for you) and require an answer
"as soon as possible" is neither polite or nor does it shows
any, what so ever, respect towards the people you ask for
help, espacilay since your way of expression your self show
clear sign of that you are not interrested to learn anything
your self.
The last thing you should ever ask for (read: never ask for)
is a "simple step-by-step guide with full explanations" if
you want to get an answer at all.
Be happy that you got an answer.
D.S.
P.S.S. Jesus, why do I even waste my fucking time on this... ??? D.P.S.
-----Original Message-----
From: Robin
To: Svensson, B.A.T. (HKG)
Sent: 2004-02-07 02:23
Subject: RE: [PHP-WIN] URGENT - Enabling mcrypt() in PHP 4.3.3 on Windows XP
(windows installer
Hold it! What do you mean by RTFM? Please provide a simple step-by-step
guide, with full explanations. ASAP.
Robin Chang
[EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Monday, 2 February 2004 12:49 a.m.
To: '[EMAIL PROTECTED] '
Subject: RE: [PHP-WIN] URGENT - Enabling mcrypt() in PHP 4.3.3 on
Windows XP (windows installer
> Please reply ASAP, with a step-by-step guide
1) RTFM.
2) done.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
