php-windows Digest 11 Dec 2003 19:21:30 -0000 Issue 2037
Topics (messages 22360 through 22367):
Re: DB Indexing
22360 by: toby z
22361 by: Svensson, B.A.T. (HKG)
22362 by: Svensson, B.A.T. (HKG)
In_array - weird behaviour
22363 by: Henrik Hornemann
"bug" report - loading non-existing extensions casue CGI-error: t ime out
22364 by: Svensson, B.A.T. (HKG)
Re: Age from birthdate?
22365 by: pete M
Return all Tables
22366 by: Gerardo Rojas
22367 by: Justin Patrin
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 ---
ofcourse it does ..... :)
toby
--- "Herhuth, Ron" <[EMAIL PROTECTED]> wrote: >
> Quick question...does MySQL offer column based indexing?
>
> I'm looking to store resume text which can be quite lengthy in a
> database
> field for searching. I have already built the app that takes a MS
> Word
> resume and extracts and stores keywords in MS SQL and the searches
> are
> lightning fast with over 500 resumes, but a new client of mine
> isn't
> running MS SQL so I have to look at the reality of trying to use
> MySQL as
> a solution.
>
> Thanks,
> ROn
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--- End Message ---
--- Begin Message ---
I am not sure, but I think mySQL just as MS SQL, has a free
text index. Check the mySQL manual for further information.
-----Original Message-----
From: Herhuth, Ron
To: [EMAIL PROTECTED]
Sent: 2003-12-10 19:05
Subject: [PHP-WIN] DB Indexing
Quick question...does MySQL offer column based indexing?
I'm looking to store resume text which can be quite lengthy in a
database
field for searching. I have already built the app that takes a MS Word
resume and extracts and stores keywords in MS SQL and the searches are
lightning fast with over 500 resumes, but a new client of mine isn't
running MS SQL so I have to look at the reality of trying to use MySQL
as
a solution.
Thanks,
ROn
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
But they still haven't implemented stored procedures(?).
-----Original Message-----
From: toby z
To: Herhuth, Ron; [EMAIL PROTECTED]
Sent: 2003-12-11 09:24
Subject: Re: [PHP-WIN] DB Indexing
ofcourse it does ..... :)
toby
--- "Herhuth, Ron" <[EMAIL PROTECTED]> wrote: >
> Quick question...does MySQL offer column based indexing?
>
> I'm looking to store resume text which can be quite lengthy in a
> database
> field for searching. I have already built the app that takes a MS
> Word
> resume and extracts and stores keywords in MS SQL and the searches
> are
> lightning fast with over 500 resumes, but a new client of mine
> isn't
> running MS SQL so I have to look at the reality of trying to use
> MySQL as
> a solution.
>
> Thanks,
> ROn
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi all,
The following snippet:
echo "<select name='inst[]' multiple>";
foreach ($kategorier as $key => $val) {
$select = (in_array($key,$institution ))? 'selected':'';
echo "<option value='$key' $select>".$val[0];
}
echo "</select></td></tr>";
Works fine on our testserver, but on our production server all the
options will be selected.
The setup of both the two servers are php 4.3.0/Windows NT 5.0/IIS 5.0.
The script was completely identical on the two servers.
In both cases the arrays $kategorier and $institution are the same (Yes
I have checked.)
Also the generated $key => $val pairs where identical.
So the problem should be in in_array. I could fix my problem by using
in_array($key,$institution,TRUE ), but does anyone of you have an
explanation for this strange behaviour?
Regards Henrik Hornemann
--- End Message ---
--- Begin Message ---
CONFIG:
* Win2003 server
* IIS 6
* PHP 4.3.4
BEHAVIOUR:
* the php instance is running in background and consumes no particular
resurces
* Page times out with CGI-error: timeout.
HOW TO REPRODUCE:
* Enable php_mssql.dll extension.
* Make sure php_mssql.dll is not accessible for php.
COMMENT:
PHP should print a message similar to"Could not locate DLL: php_mssql.dll".
This would save time for peoople in locating the fualt.
(I spent about 3 hours today looking in a dark room for for this
non-existing black, no fun.)
--- End Message ---
--- Begin Message ---
have you looked at to_days() and to_years() in the mysql manual
Dvdmandt wrote:
How would I get the age of someone if I store the birthdate in a date field?
I just realized FLOOR((UNIX_TIMESTAMP(NOW()) -
UNIX_TIMESTAMP(birthdate))/60/60/24/365.25) wont work for persons born
before 1970... :p I must get the current age in years, and I must be able to
select by age... :p Any ideas?
--- End Message ---
--- Begin Message ---
I have a connection to an MS SQL server. I am able to get a list of all available
DB's on this server by running:
"exec sp_helpdb"
the question is: How do we return all tables from a selected db for MS SQL?
i am developing a web interface to the DB. I need to be able to give my users a
choice of which Table to use.
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Gerardo Rojas wrote:
I have a connection to an MS SQL server. I am able to get a list of all available DB's on this server by running:
"exec sp_helpdb"
the question is: How do we return all tables from a selected db for MS SQL?
i am developing a web interface to the DB. I need to be able to give my users a choice of which Table to use.
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
Not sure about MS SQL, but "show tables;" works in MySql. And "show
databases;" works for databases.
--
paperCrane <Justin Patrin>
--- End Message ---
