anchor.diff:  										<cfset d='valid'>
   									<cfelseif therecord.status is 'unaccepted'>
   										<cfset d='invalid'>
  -									<!----
  -										we may need a cfelse here if anything falls out of the Issue
  -									---->
  +									<cfelse>
  +										<cfset d=therecord.status>
   									</cfif>
  -									<cfif len(d) gt 0>
  +									<cfif len(d) gt 0 and listfind(valuelist(CTTAXON_STATUS.TAXON_STATUS),d)>
   										<cfquery name="meta" datasource="uam_god">
   											insert into taxon_term (
   												taxon_term_id,
  
positive.code: 								----->
  
  								<!---
  
  
  								can't deal with this until relationships are resolved at github
  
  								<cfif structkeyexists(therecord,"valid_name")>
  									<cfif not (structkeyexists(therecord,"scientificname")) or (therecord.valid_name is not therecord.scientificname)>
  										<cfset t="valid_name">
  										<cfset d=therecord.valid_name>
  										<cfquery name="meta" datasource="uam_god">
  											insert into taxon_term (
  												taxon_term_id,
  												taxon_name_id,
  												term,
  												term_type,
  												source,
  												position_in_classification,
  												classification_id
  											) values (
  												sq_taxon_term_id.nextval,
  												#tid.taxon_name_id#,
  												'#d#',
  												'#t#',
  												'#thisSrcName#',
  												NULL,
  												'#thisSourceID#'
  											)
  										</cfquery>
  									</cfif>
  								</cfif>
  
  
  								<cfif structkeyexists(therecord,"valid_authority")>
  
negative.code: 
  
  <!--------------------------------------------------------------------------------------->
  	<cffunction name="getWormsChanged" access="remote">
  		<cfargument name="thedate" type="string" required="true">
  		<cfoutput>
  			<!---
  
  				<!--- blargh need a temp table to handle this; it can take a while ---->
  				drop table cf_worms_refresh_job;
  				create table cf_worms_refresh_job (
  					last_run_date date,
  					last_status varchar2(255)
  				);
  
  				insert into cf_worms_refresh_job(last_run_date,last_status) values (to_date('2018-12-20'),'new');
  
  				select last_run_date-sysdate from cf_worms_refresh_job;
  
  				for one day, loop until we get everything
  				worms date handling is a little wonky, so "start" today and "end" tomorrow??
  
  				DateAdd(datepart, number, date)
  
  			--->
  			<cfquery name="rs" datasource="uam_god">
  				select * from cf_worms_refresh_job
  			</cfquery>
  			<cfdump var=#rs#>
  			<cfif rs.last_run_date neq dateformat(now(),"YYYY-MM-DD")>
  				<br>we have not run today
  			</cfif>
  
  			<cfset lastRunDate=listgetat(Application.wrmsbkmrk,1,"|")>
  			<cfset lastRunLoop=listgetat(Application.wrmsbkmrk,2,"|")>
  
  			<br>lastRunDate:#lastRunDate#
  			<br>lastRunLoop:#lastRunLoop#
  
  				<cfset edate=DateAdd("d", 1, thedate)>
  				<cfdump var=#edate#>
  				<cfset edate=dateformat(edate,"YYYY-MM-DD")>
  				<cfdump var=#edate#>
  
  				<cfset st=thedate & "T00%3A00%3A00%2B00%3A00">
  				<cfset et=thedate & "T24%3A00%3A00%2B00%3A00">
  
  
  
  			<cfset theURL="http://www.marinespecies.org/rest/AphiaRecordsByDate?startdate=#st#&enddate=#et#&marine_only=false&offset=#o#">
  			<cfdump var=#theURL#>
  			<!----
  			<cfset theURL=urlencodedFormat(theURL)>
  			<cfdump var=#theURL#>
  ---->
  			<cfhttp result="ga" url="#theURL#" method="get"></cfhttp>
  			<cfdump var=#ga#>
  			<cfif left(ga.Statuscode,3) is "204">
  				<br>got nothing no more loopy
  			<cfelseif left(ga.Statuscode,3) is "200">
  				<br>got some stuff
  			<cfelse>
  				<br>bah bad status!
  			</cfif>
  		</cfoutput>
  	</cffunction>
  
  <!--------------------------------------------------------------------------------------->
  	<cffunction name="updateWormsArctosByAphiaID" access="remote">
  		<!---- hierarchical taxonomy editor ---->
  		<cfargument name="aphiaID" type="string" required="true">
  		<cfargument name="taxon_name_id" type="string" required="true">
  		<cfparam name="debug" default="false">
  		<cfoutput>
  		<cftry>
  			<cfquery name="cttaxon_term" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
  				select taxon_term from cttaxon_term
  			</cfquery>
  			<cfquery name="CTTAXON_STATUS" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
  				select TAXON_STATUS from CTTAXON_STATUS
  			</cfquery>
  
  			<cfhttp  result="ga" url="http://www.marinespecies.org/rest/AphiaRecordByAphiaID/#aphiaID#" method="get"></cfhttp>
  