List asp statussql = "select symbol from noxious Where status='" & StatusName & "'" plantsql = "select symbol, sciname,comname From Plants Where Symbol in



Download 23.42 Kb.
Date31.05.2016
Size23.42 Kb.
#74300
NOTES:

rmstevens

12-30-2005
Below are all the SQL statements for developing the ASP pages for the SWEMP site.

Pages are built using the SQL statement below and inputting the variables into the html code.



list.asp
statusSQL = "SELECT Symbol FROM Noxious Where status='" & StatusName & "'"

plantSQL = "SELECT symbol, sciname,comname From Plants Where Symbol IN (" & statusSQL & ") Order by Sciname"

statusSQL = "Select * From Lists Where status='" & StatusName & "'"
Required Tables:

Noxious


Plants

list
cllbrtstate.asp


cllSQL = "SELECT state FROM tblcollaborators Where state='" & StateName & "'"

stateSQL = "SELECT area, agency, type, state FROM tblcollaborators Where state IN (" & cllSQL & ") Order by sort"


Required Tables:

tblcollaborators


collaborators.asp
cllSQL = "SELECT * FROM tblcollaborators Order by sort"
Required Tables:

tblcollaborators


interest.asp
intSQL = "SELECT * FROM tblsites Order by number"
Required Tables:

tblsites
species.asp


sciSQL = "SELECT symbol, sciname, comname From Plants Order by Sciname"

comSQL = "SELECT symbol, sciname, comname From Plants Order by comname"


Required Tables:

Plants
SWVMAspecies.asp


sciSQL = "SELECT symbol, sciname, comname From Plants Where caleppcSWVMAlink=caleppcSWVMAlink Order by Sciname"

comSQL = "SELECT symbol, sciname, comname From Plants Where caleppcSWVMAlink=caleppcSWVMAlink Order by comname"


Required Tables:

Plants
sciname.asp


sortSQL = "SELECT symbol, sciname, comname, caleppcSWVMAlink From Plants Where Symbol IN (" & letterSQL & ") Order by Sciname"

plantSQL = "SELECT symbol, sciname, comname From Plants Order by Sciname"




comname.asp
sortSQL = "SELECT symbol, sciname, comname From Plants Where Symbol IN (" & letterSQL & ") Order by comname"

plantSQL = "SELECT symbol, sciname, comname From Plants Order by Comname"


Required Tables:

Plants
scisort.asp


letterSQL = "SELECT Symbol FROM tblsort Where sciletter='" & letter & "'"

sortSQL = "SELECT symbol, sciname,comname From Plants Where Symbol IN (" & letterSQL & ") Order by Sciname"


Required Tables:

Plants
SWVMAscisort.asp


letterSQL = "SELECT Symbol FROM qrysort Where sciletter='" & letter & "' and caleppcSWVMAlink='" & SWVMAlink &"'"

comSQL = "SELECT symbol, sciname, comname From Plants Where caleppcSWVMAlink=caleppcSWVMAlink Order by comname"


Required Tables: (note this also has a query)

Plants


qrysort
comsort.asp
letterSQL = "SELECT Symbol FROM tblsort Where comletter='" & letter & "'"

sortSQL = "SELECT symbol, sciname, comname From Plants Where Symbol IN (" & letterSQL & ") Order by comname"


Required Tables:

Plants


tblsort
SWVMAComsort.asp
letterSQL = "SELECT Symbol FROM qrysort Where comletter='" & letter & "' and caleppcSWVMAlink='" & SWVMAlink &"'"

sortSQL = "SELECT symbol, sciname,comname From Plants Where Symbol IN (" & letterSQL & ") Order by Sciname"


Required Tables: (note this also has a query)

Plants


qrysort
question.asp
strSQL = "SELECT * FROM responses Where location='" & location & "' AND Symbol='" & symbol & "'"

locSQL = "SELECT name FROM location where location='" & location & "'"

questSQL = "SELECT * from answers where QNum='" & i & "' and ALet='" & respRec.Fields("A" & i).Value & "'"
Required Tables:

responses

location

answers
unified.asp



Note: The x must be place in the appropriate column of the Plants table for sql statements to call the other tables required to build the page.
aprsSQL = "SELECT responses.symbol, responses.location, location.location, location.name FROM responses INNER JOIN location ON responses.location = location.location Where symbol='" & symbol & "' Order by name"

bioSQL = "Select * From Biological where symbol='" & symbol & "'"

calSQL = "Select * From CALEPPC where symbol='" & symbol & "'"

comSQL = "SELECT symbol, sciname, comname From Plants Order by comname"

comSQL = "SELECT symbol, sciname, comname From Plants Order by comname"

comSQL = "SELECT symbol, sciname, comname From Plants Where caleppcSWVMAlink=caleppcSWVMAlink Order by comname"

facSQL = "Select * From Fact_Sheet where symbol='" & symbol & "'"

legSQL = "Select status From noxious where symbol='" & symbol & "'"

nameSQL = "SELECT symbol, sciname, comname From Plants Where Symbol = '" & symbol & "'"

sciSQL = "SELECT symbol, sciname, comname From Plants Order by Sciname"

sciSQL = "SELECT symbol, sciname, comname From Plants Order by Sciname"

SWVMASQL = "Select * From SWVMAlink where symbol='" & symbol & "'"


Required Tables:

Plants


Biological

calleppc


Fact_Sheet

Noxious


Lists

SWVMAlink

Download 23.42 Kb.

Share with your friends:




The database is protected by copyright ©essaydocs.org 2022
send message

    Main page