php-windows Digest 7 Apr 2010 05:42:48 -0000 Issue 3781
Topics (messages 29973 through 29975):
Re: Windows binaries
29973 by: Ferenc Kovacs
29974 by: Pierre Joye
Changing a column to proper case
29975 by: Bill Mudry
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
On Tue, Apr 6, 2010 at 10:49 AM, Richard Quadling
<rquadl...@googlemail.com>wrote:
> On 5 April 2010 18:51, Venkat Raman Don <don.ra...@microsoft.com> wrote:
> > Most of the extension can be downloaded from
> http://downloads.php.net/pierre/.
>
> That's great. But are there any plans or timescales on getting
> pecl.php.net and the win32 snapshots back up?
>
> If so, has anything been made public regarding this?
>
> The funny thing, that I remembered that somebody asked the same, and I
tried to find that conversation.
Surprisingly, it was you a year ago:
http://old.nabble.com/Win32-PECL-pre-built-binaries.-td23293468.html
I also would like to know what is the current status for pecl4windows and
how can we help.
Tyrael
--
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
On Tue, Apr 6, 2010 at 12:06 PM, Ferenc Kovacs <tyr...@gmail.com> wrote:
> On Tue, Apr 6, 2010 at 10:49 AM, Richard Quadling
> <rquadl...@googlemail.com>wrote:
>
>> On 5 April 2010 18:51, Venkat Raman Don <don.ra...@microsoft.com> wrote:
>> > Most of the extension can be downloaded from
>> http://downloads.php.net/pierre/.
>>
>> That's great. But are there any plans or timescales on getting
>> pecl.php.net and the win32 snapshots back up?
>>
>> If so, has anything been made public regarding this?
>>
>> The funny thing, that I remembered that somebody asked the same, and I
> tried to find that conversation.
> Surprisingly, it was you a year ago:
> http://old.nabble.com/Win32-PECL-pre-built-binaries.-td23293468.html
> I also would like to know what is the current status for pecl4windows and
> how can we help.
You can get most of the extensions here: http://downloads.php.net/pierre/
About helping, well, if you have time (really have time) then let me
know. Some help is always welcome, especially for the web frontends
part.
Cheers,
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
--- Begin Message ---
I have a MySQL file that is filled with information on the different
woods of the world.
In one column for the botanical species names, some of the first
characters in each
record are not capitalized when they should all be while many are
properly capitalized.
I need to correct this. The database is "TAXA". The column is "species_name".
I have been using SQL statements through both phpMyAdmin and
MySQL-front as front ends to the database. I get part way ok but need
others help to understand why the final
step does not work as follows:
..........................................................................................................................
This statement faithfully reports the first character in the
species_name field:
SELECT UCASE(LEFT(species_name, 1)) from species;
This statement faithfully produces all other characters after the first
one in the specie_name field:
SELECT RIGHT(species_name, LENGTH(species_name)-1) FROM species;
When I run both together, there is no error:
SELECT UCASE(LEFT(species_name, 1)) FROM species;
SELECT RIGHT(species_name, LENGTH(species_name)-1) FROM species;
When I finally try to concatenate the first character back together
with the rest of the species name, it does not work:
SELECT CONCAT(
UCASE(LEFT(species_name, 1)) FROM species,
RIGHT(species_name, LENGTH(species_name)) FROM species
);
Instead, I get an error near FROM species, RIGHT(species_name,
LENGTH(species_name)) FROM species
I know I must be close but cannot find out why this is not just working.
Also, when it finally reports the full species names correctly, does
it matter if I add in a SET statement to finally
replace the old entries or should I use an UPDATE command instead of
SELECT? Does it matter?
I look forward to your suggestions.
Bill Mudry
--- End Message ---
