fr.comp.lang.perl
  Home FAQ Contact Sign in
fr.comp.lang.perl only
 
Advanced search
March 2008
motuwethfrsasuw
     12 9
3456789 10
10111213141516 11
17181920212223 12
24252627282930 13
31       14
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
fr.comp.lang.perl Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  VTD-XML 2.3 released         


Author: jimmy Zhang
Date: Mar 4, 2008 16:43

Version 2.3 of VTD-XML (http://vtd-xml.sf.net), the next generation,
document centric XML processing model, is now released. To download the
latest version please visit
http://sourceforge.net/project/showfiles.php?group_id=110612&package_id=120172.

Below is a list of new features and enhancements in this version.

* VTDException is now introduced as the root class for all other VTD-XML's
exception classes (per suggestion of Max Rahder).
* Transcoding capability is now added for inter-document cut and paste. You
can cut a chuck of bytes in a UTF-8 encoded document and paste it into a
UTF-16 encoded document and the output document is still well-formed.
* ISO-8859-10, ISO-8859-11, ISO-8859-12, ISO-8859-13, ISO-8859-14 and
ISO-8859-15 support has now been added
* Zero length Text node is now possible.
* Ability to dump in-memory copy of text is added.
* Various code cleanup, enhancement and bug fixes.

Below are some new articles related to VTD-XML

*Index XML documents with VTD-XML http://xml.sys-con.com/read/453082.htm

*Manipulate XML content the Ximple Way http://www.devx.com/xml/Article/36379
Show full article (1.72Kb)
no comments
  Perl DBI et SELECT .. IN() ?         


Author: ctobini
Date: Mar 3, 2008 08:26

Bonjour,

J'utilise le module PgPP et cherche à requêter une base PostgreSQL
8.1.

J'ai une liste d'argements dans un tableau contenant plusieurs chaînes
de caractères et je voudrais effectuer une requête à l'aide de IN().

J'ai essayé plusieurs méthodes :

$sth = $dbh->prepare(sprintf "SELECT a FROM b WHERE b IN(%%s)", $dbh-
>quote(join ',', @tab))

$sth = $dbh->prepare(sprintf "SELECT a FROM b WHERE b IN(?, ?)
$sth->bind_param(1, $tab[0]);
$sth->bind_param(2, $tab[1])
Cette méthode est censée ne pas fonctionner mais au point où j'en
suis...

Sauriez-vous comment passer un tableau ou hash avec IN() ou une
méthode faisant le travail équivalent ?

En vous remerciant,

C. Tobini
2 Comments