[MOBY-guts] biomoby commit

[Mark Wilkinson]

mwilkinson
Fri Jul 29 15:28:28 EDT 2005
Update of /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi
In directory pub.open-bio.org:/tmp/cvs-serv11545/MOBY/Adaptor/moby/queryapi

Modified Files:
	mysql.pm 
Log Message:
query doesn't work on older versions of mySQL

moby-live/Perl/MOBY/Adaptor/moby/queryapi mysql.pm,1.67,1.68
===================================================================
RCS file: /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm,v
retrieving revision 1.67
retrieving revision 1.68
diff -u -r1.67 -r1.68
--- /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm	2005/07/29 17:25:35	1.67
+++ /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm	2005/07/29 19:28:27	1.68
@@ -675,7 +675,7 @@
 			description, 
 			signatureURL,
 			lsid 
-			from service_instance left join authority on authority.authority_id ";
+			from service_instance, authority where authority.authority_id = service_instance.authority_id ";
         my @bindvalues;
  	($statement, @bindvalues) =_add_condition($statement, @args);
  	my $final = do_query($dbh, $statement, @bindvalues);