<% 'Interim page for FGSC Organism Strain Search to acquire Session SQL
   'direct passthru does not work with when record set has more than 10
	'records and the multiple page incrementation.

	If ((IsNumeric(cint(Request.querystring("No")))) AND (cint(Request.querystring("No")) > 0 ) AND (cint(Request.querystring("No")) < 46)) then
		Session("No") = cint(Request.querystring("No"))
	Else
		Session("No") = 10
	End If

	Session("MySQL") = "SELECT * from qryWebCounter WHERE Genus = '" & Trim(Request.querystring("Strain")) & "' "

	If CInt(Request.querystring("MW")) = 1 then
	'Selection criteria for Wild Types
		Session("MySQL") = Session("MySQL") & " AND ([EXCEPTIONS] = 1) "
		If len(trim(Request.querystring("WFGSC"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [StrainName] Like '%" & Trim(Request.querystring("WFGSC")) & "%' "
		End If
		If len(trim(Request.querystring("WDeposit"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [DEPOSNAME] Like '%" & Trim(Request.querystring("WDeposit")) & "%' "
		End If
		If len(trim(Request.querystring("WLocation"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND (([SITE] Like '%" & Cstr(Trim(Request.querystring("WLocation"))) & "%') OR ([COUNTRY] Like '%" & Cstr(Trim(Request.querystring("WLocation"))) & "%') OR ([ALLELE] Like '%" & Cstr(Trim(Request.querystring("WLocation"))) & "%')) "
		End If
		If len(trim(Request.querystring("WMT"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [MT] Like '%" & Trim(Request.querystring("WMT")) & "%' "
		End If
		If len(trim(Request.querystring("WOther"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND (([STOCK] Like '%" & Cstr(Trim(Request.querystring("WOther"))) & "%') OR ([GLASGOW] Like '%" & Cstr(Trim(Request.querystring("WOther"))) & "%')) "
		End If
	Else
	'Selection criteria for Mutants
		Session("MySQL") = Session("MySQL") & " AND ([EXCEPTIONS] <> 1) "
		If len(trim(Request.querystring("Gene"))) > 0 then
				  if InStr(Trim(Request.querystring("Gene"))," ") > 0 then
                  strSQLGene=Replace(Trim(Request.querystring("Gene")), " ", "%' AND [REPORTING GENES] like '%")
						strSQLGene=" AND [REPORTING GENES] like '%" & strSQLGene & "%'"
				  Else
						strSQLGene=" AND [REPORTING GENES] like '%" & Trim(Request.querystring("Gene")) & "%' "
              end if
			Session("MySQL") = Session("MySQL") & strSQLGene
		End If
		If len(trim(Request.querystring("FGSC"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [StrainName] Like '%" & Trim(Request.querystring("FGSC")) & "%' "
		End If
		If len(trim(Request.querystring("Mutagen"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [MUTAGEN] Like '%" & Trim(Request.querystring("Mutagen")) & "%' "
		End If
		If len(trim(Request.querystring("Deposit"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [DEPOSNAME] Like '%" & Trim(Request.querystring("Deposit")) & "%' "
		End If
		If len(trim(Request.querystring("Link"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [LNKGRP] Like '%" & Trim(Request.querystring("Link")) & "%' "
		End If
		If len(trim(Request.querystring("MT"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND [MT] Like '%" & Trim(Request.querystring("MT")) & "%' "
		End If
		If len(trim(Request.querystring("Other"))) > 0 then
			Session("MySQL") = Session("MySQL") & " AND (([STOCK] Like '%" & Cstr(Trim(Request.querystring("Other"))) & "%') OR ([GLASGOW] Like '%" & Cstr(Trim(Request.querystring("Other"))) & "%')) "
		End If
	End If

	'Now that the Session SQL is obtained, redirect user to interim display
	'the user can then select to view details, if desired

   Response.redirect "StrainSearchReturnPage2.asp"

%>