Re: [PHP-DB] Stored Procedures ?

2004-01-19 Thread Alban Médici (NetCentrex)
yep

just call the name of your function as :
SELECT MyFunction();
Ricardo Lopes wrote:

Is possible to call database stored procedures from php with oracle or
any other db?
 

--
Alban Médici
RD software engineer
--
you can contact me @ :
IPPhone : +33 (0)2 31 46 37 68
[EMAIL PROTECTED]
http://www.netcentrex.net
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Windows 2003 Server

2004-01-19 Thread Alban Médici (NetCentrex)
yep

c'est quand même la foire de l'europe ici !!!  - little of french

It's like an european bazaar here :-)

Please post in english it's the universal language (even if like me your 
english is poor :)

Ricardo Lopes wrote:

Please post this message in english or spanish or portuguese, those are the
only languages i understand.
Por favory enviari mensagi in español, ingles o portugues. Io no parlare
italiano.
- Original Message -
From: Andrea Fenilxxx [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:08 AM
Subject: Re: [PHP-DB] Windows 2003 Server
 

Sto realizzando una pagina di invio mail per una mailing list.
La mail parte regolarmente.
Sul mio pc (Win Xp si vede bene, così come su molti altri pc)
Qualcuno sa spiegarmi perchè, su alcuni windows ('98), invece dell'html mi
genera una mail NON html (quindi si vede solo il codice... una
schifezza!!!).
Forse sbaglio charset=iso-8859???
Sono stressato!
$messaggio è una concatenazioni di header.$corpo.footer
Il corpo è generato da una textarea
---
?php

$oggetto=Newsletter 4winds - OFFERTE di VIAGGIO;
$messaggio= '
html
head
 titleTitolo/title
/head
body
   Corpo header
/body
/html
'
 .$corpo.
'
html
head
/head
body
Corpo footer
/body
/html
';
// l'intestazione Content-type per inviare email in formato HTML
$intestazioni  = MIME-Version: 1.0\r\n;
$intestazioni .= Content-type: text/html; charset=iso-8859-1\r\n;
// intestazioni addizionali - From
$intestazioni .= gestore mailing list ;
//destinatari
$to =  - destinatari - ;
mail($to, $oggetto, $messaggio, $intestazioni);

?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
   

 

--
Alban Médici
RD software engineer
--
you can contact me @ :
[EMAIL PROTECTED]
http://www.netcentrex.net
--


[PHP-DB] ldap api synchronous but no timeout

2004-01-16 Thread Alban Médici (NetCentrex)
Hi all,

I got a matter:
I'm developping daemon in php stand alone mode.
My application is designed to send same object on both ldap server (sort 
of replication)
But once connected and bind on both server, I treat some ldap commands and
IF one of the servers crash (simulating a network failure by stoping 
network service)
My script BLOCK on the current ldap action.
AND there is NO timeout 

How this API can return (LDAP_SERVER_DOWN:0x51) 

Have you got any solution,  or even saw that behavior before ?

regards Alban

--
Alban Médici
RD software engineer
--
you can contact me @ :
IPPhone : +33 (0)2 31 46 37 68
[EMAIL PROTECTED]
http://www.netcentrex.net
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] MySQL general Question...

2004-01-16 Thread Alban Médici (NetCentrex)
with the like command you could made search such as :

SELECT  FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'

and you could have several answer.

= is for scrict equality





[EMAIL PROTECTED] wrote:

What's teh diffence between 'LIKE'  '='
EG: SELECT  FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
I've just purchased an E-mail marketing piece of software, and was
peakign 
in the code...
Found that... Never seen it before (Have I been living in a box?)

Cheers,
Tris...
*
The information contained in this e-mail message is intended only for 
the personal and confidential use of the recipient(s) named above.  
If the reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby 
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is 
strictly prohibited. If you have received this communication in error, 
please notify us immediately by e-mail, and delete the original message.
***

 

--
Alban Médici
RD software engineer
--
[EMAIL PROTECTED]
http://www.netcentrex.net
--


--
Alban Médici
RD software engineer
--
you can contact me @ :
IPPhone : +33 (0)2 31 46 37 68
[EMAIL PROTECTED]
http://www.netcentrex.net
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Alban Médici (NetCentrex)
try this

SELECT DISTINCT id-script FROM YOURTABLE where id_language = 'SELECTED 
LANGUAGE' ;
no ?

Justin Patrin wrote:

Christine Clerc wrote:

Hi,

I have a Mysql table of texts in different languages :
id_readme
id_script (the object that the text describes)
id_language (the language the text is written in)
etc.
So two texts may have the same id_script but with different id_language.

I need to retrieve the list (without duplicate) of id-script that are 
described in one language and NOT in another.

Is there hope ?
Any help would be welcome.
Chris


Maybe give us a sample of the SQL you wish to use? You can probably 
get it done without a sub-select.

That being said, the newest versions of MySQL support sub-selects, but 
you'd have to use an unstable version.

--
Alban Médici
RD software engineer
--
you can contact me @ :
[EMAIL PROTECTED]
http://www.netcentrex.net
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php