[MOBY-guts] biomoby commit

[Dirk Haase]

d.haase
Wed Feb  7 10:19:00 EST 2007
Update of /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi
In directory dev.open-bio.org:/tmp/cvs-serv22598

Modified Files:
	mysql.pm 
Log Message:
changed 'collection_input_id' to 'collection_${inout}_id' in query
of &find_by_simple to prevent 'unknown column' error for output case

moby-live/Perl/MOBY/Adaptor/moby/queryapi mysql.pm,1.82,1.83
===================================================================
RCS file: /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm,v
retrieving revision 1.82
retrieving revision 1.83
diff -u -r1.82 -r1.83
--- /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm	2007/01/30 15:08:33	1.82
+++ /home/repository/moby/moby-live/Perl/MOBY/Adaptor/moby/queryapi/mysql.pm	2007/02/07 15:19:00	1.83
@@ -1209,7 +1209,7 @@
 	my $ancestor_string = $args{'ancestor_string'};
 	my $namespaceURIs = $args{'namespaceURIs'};
 	
-	my $query ="select service_instance_id, namespace_type_uris from simple_$inout where object_type_uri in ($ancestor_string) and collection_input_id IS NULL "
+	my $query ="select service_instance_id, namespace_type_uris from simple_$inout where object_type_uri in ($ancestor_string) and collection_${inout}_id IS NULL "
 	  ;    # if service_instance_id is null then it must be a collection input.
 	my $nsquery;
 	foreach my $ns ( @{$namespaceURIs} ) {    # namespaces are already URI's