[Koha-cvs] koha/C4 Members.pm [rel_3_0]
Bruno Toumi
btoumi at ouestprovence.fr
Mon Sep 25 16:40:49 CEST 2006
CVSROOT: /sources/koha
Module name: koha
Branch: rel_3_0
Changes by: Bruno Toumi <btoumi> 06/09/25 14:40:49
Modified files:
C4 : Members.pm
Log message:
code cleaning : modify sql syntax in two added function today by me;=)
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Members.pm?cvsroot=koha&only_with_tag=rel_3_0&r1=1.32.2.2&r2=1.32.2.3
Patches:
Index: Members.pm
===================================================================
RCS file: /sources/koha/koha/C4/Members.pm,v
retrieving revision 1.32.2.2
retrieving revision 1.32.2.3
diff -u -b -r1.32.2.2 -r1.32.2.3
--- Members.pm 25 Sep 2006 13:43:06 -0000 1.32.2.2
+++ Members.pm 25 Sep 2006 14:40:49 -0000 1.32.2.3
@@ -19,7 +19,7 @@
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA 02111-1307 USA
-# $Id: Members.pm,v 1.32.2.2 2006/09/25 13:43:06 btoumi Exp $
+# $Id: Members.pm,v 1.32.2.3 2006/09/25 14:40:49 btoumi Exp $
use strict;
require Exporter;
@@ -31,7 +31,7 @@
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK);
-$VERSION = do { my @v = '$Revision: 1.32.2.2 $' =~ /\d+/g; shift(@v) . "." . join( "_", map { sprintf "%03d", $_ } @v ); };
+$VERSION = do { my @v = '$Revision: 1.32.2.3 $' =~ /\d+/g; shift(@v) . "." . join( "_", map { sprintf "%03d", $_ } @v ); };
=head1 NAME
@@ -1392,7 +1392,10 @@
sub GetCities {
#my ($type_city) = @_;
my $dbh = C4::Context->dbh;
- my $sth=$dbh->prepare("Select cityid,city_name from cities order by cityid ");
+ my $query=qq|Select cityid,city_name
+ from cities
+ order by cityid|;
+ my $sth=$dbh->prepare($query);
#$sth->execute($type_city);
$sth->execute();
my %city;
@@ -1431,7 +1434,10 @@
=cut
sub GetRoadTypes {
my $dbh = C4::Context->dbh;
- my $sth=$dbh->prepare("Select roadtypeid,road_type from roadtype order by road_type ");
+ my $query=qq|Select roadtypeid,road_type
+ from roadtype
+ order by road_type|;
+ my $sth=$dbh->prepare($query);
$sth->execute();
my %roadtype;
my @id;
More information about the Koha-cvs
mailing list