[Koha-cvs] koha/C4 Members.pm [rel_3_0]

[Bruno Toumi]

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;