T
Tim
Hi All,
I have a small issue that I can't seem to figure out. I have a SQL
statement that is dependant on the results of a drop down to chose
which table to select from. Unfortunately it does not seem to work.
Could anyone point me in the right direction? Unfortunately the
datebase cannot be changed.
I guess my question is this. Is it possible to use a variable in a SQl
select statement to choose the table? If so, where is my syntax bad.
If not, how can i get around this without changing the database
Thanks in advance!
*** here's some of the code!!
<form method="POST" name="Form1" action="test1.asp">
<p><nobr><!--#include file="../_fpclass/fpdblib.inc"--> <%
fp_sQry="SELECT * FROM eqtable ORDER BY category"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Inventory"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Category"
fp_sMenuValue="Category"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<select NAME="Category" SIZE="1" ONCHANGE=Form1.submit()> <option
selected><%=Request.Form("Category")%></option>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<option><%=FP_FieldHTML(fp_rs,"Category")%></option>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</select>
</nobr></p>
</form>
<form method="POST" name="Form2" action="YourPage2.asp">
<p><nobr><!--#include file="../_fpclass/fpdblib.inc"--> <%
fp_sQry="SELECT Name FROM " & Category & " ORDER BY Name"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Inventory"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Sub_Category"
fp_sMenuValue="Sub_Category"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<%
IF Request.Form("Category") = "" Then
Else
%>
<select NAME="Sub_Category" SIZE="1" ONCHANGE=Form2.submit()> <option
selected><%=Request.Form("Sub_Category")%></option>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<option><%=FP_FieldHTML(fp_rs,"Sub_Category")%></option>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</select>
</nobr></p>
<input type="hidden" name="Category" value="<% =
Request.Form("Category") %>">
</form>
<%End IF%>
I have a small issue that I can't seem to figure out. I have a SQL
statement that is dependant on the results of a drop down to chose
which table to select from. Unfortunately it does not seem to work.
Could anyone point me in the right direction? Unfortunately the
datebase cannot be changed.
I guess my question is this. Is it possible to use a variable in a SQl
select statement to choose the table? If so, where is my syntax bad.
If not, how can i get around this without changing the database
Thanks in advance!
*** here's some of the code!!
<form method="POST" name="Form1" action="test1.asp">
<p><nobr><!--#include file="../_fpclass/fpdblib.inc"--> <%
fp_sQry="SELECT * FROM eqtable ORDER BY category"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Inventory"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Category"
fp_sMenuValue="Category"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<select NAME="Category" SIZE="1" ONCHANGE=Form1.submit()> <option
selected><%=Request.Form("Category")%></option>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<option><%=FP_FieldHTML(fp_rs,"Category")%></option>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</select>
</nobr></p>
</form>
<form method="POST" name="Form2" action="YourPage2.asp">
<p><nobr><!--#include file="../_fpclass/fpdblib.inc"--> <%
fp_sQry="SELECT Name FROM " & Category & " ORDER BY Name"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Inventory"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Sub_Category"
fp_sMenuValue="Sub_Category"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<%
IF Request.Form("Category") = "" Then
Else
%>
<select NAME="Sub_Category" SIZE="1" ONCHANGE=Form2.submit()> <option
selected><%=Request.Form("Sub_Category")%></option>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<option><%=FP_FieldHTML(fp_rs,"Sub_Category")%></option>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</select>
</nobr></p>
<input type="hidden" name="Category" value="<% =
Request.Form("Category") %>">
</form>
<%End IF%>