|
| |
|
|
helensnow
Posts: 228
Joined: 12/18/2003
Status: offline
 |
2nd pair of eyes please - 9/11/2006 15:25:40
I've just taken over a website, and cannot check this code on any local IIS server, and the deployment server has soem funny error check that jumps you to a page insted of showing the error.
All I am trying to do is populate a listbox from a database, with a simple [while loop], it all looks correct, but I may have a syntax error. Sorry this is still old ASP code.
<% end if %>
<%
fp_sQry="SELECT theDirectoryPath FROM Results"
fp_sDefault="Key=0"
fp_sNoRecords="No records returned."
fp_sDataConn="database1"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Name=202&Address=202&Choice=2&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<font color="#000080">TEST FORM</font>
<p>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<form METHOD="POST" action="promote.asp">
<select size="1" name="Directory ">
<option value="Select Directory Deployment">Select Directory Deployment </option>
<% while NOT fp_rs.EOF%> <option value="<%=FP_FieldVal(fp_rs,"theDirectoryPath")%>" > </option>
<%fp_rs.MoveNext
wend
fp_rs.Close%> </select> <input type="submit" value="Deploy information" name="B1">
</form>
<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
</body>
_____________________________
Love is all, and all that we are is love
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: 2nd pair of eyes please - 9/11/2006 15:49:19
quote:
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<form METHOD="POST" action="promote.asp">
<select size="1" name="Directory ">
<option value="Select Directory Deployment">Select Directory Deployment </option>
<% while NOT fp_rs.EOF%> <option value="<%=FP_FieldVal(fp_rs,"theDirectoryPath")%>" > </option>
<%fp_rs.MoveNext
wend
fp_rs.Close%> </select> <input type="submit" value="Deploy information" name="B1">
</form>
<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
It has been some time since I worked regularly with the DRW but IIRC it should be something like this:
...
<form METHOD="POST" action="promote.asp">
<select size="1" name="Directory ">
<option value="Select Directory Deployment">Select Directory Deployment </option>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<option value="<%=FP_FieldVal(fp_rs,"theDirectoryPath")%>" > </option>
<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
</select> <input type="submit" value="Deploy information" name="B1">
</form>
...
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
helensnow
Posts: 228
Joined: 12/18/2003
Status: offline
|
RE: 2nd pair of eyes please - 9/11/2006 17:26:05
Hi
it was the max records set to 1
appreciate your time
hs
_____________________________
Love is all, and all that we are is love
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
