<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dsn %>


<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dsn %> <%SQLQuery = "SELECT Title,FileName,path FROM All_Women WHERE SubTopic like'%AG%' AND type like'Programs/Projects' order by title" Set GetTitle= Conn.Execute(SQLQuery) %> <%IF GetTitle.eof then%> <% Else While not GetTitle.eof %>

  • <% if not isnull(GetTitle("authors")) then%><%=GetTitle("authors")%>, <% End If %> <% if not isnull(GetTitle("Pubyear")) then%><%=GetTitle("Pubyear")%>, <% End If %> <% If isnull(GetTitle("FileName")) then%> <%=GetTitle("title")%>,  <% Else %> <%=GetTitle("FileName")%>"><%=GetTitle("title")%>,  <% End If %> <% if not isnull(GetTitle("CorpAuthors")) then%><%=GetTitle("CorpAuthors")%>, <% End If %> <% if not isnull(GetTitle("ISBN")) then%>ISBN "<%=GetTitle("ISBN")%>", <% End If %> <% if not isnull(GetTitle("JobNum")) then%>JobNum: <%=GetTitle("JobNum")%><% End If %> <%GetTitle.MoveNext Wend end if%>

            

    Subcategories 
     

    farm and household management

    land tenure and land management

    sustainable livelihoods

    animal health, animal production, conservation and sustainable use of animal genetic resources

    conservation and sustainable use of plant genetic resources

    agricultural engineering