Using Drop Boxes to select data from database

Using Drop Boxes to select data from database (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

Keith Cyr -> Using Drop Boxes to select data from database (5/29/2001 20:37:00)
Good Morning Everyone!! I was wondering if anyone here has used a dropbox in FP2K to pull data from a database. I basically want to have the dropbox select the client_name data and populate the box with the complete number of records in the client_name column. After the client_name client is chosen I would like it to automatically post the data from that particuliar client's row in various fields on the page. How does one do this? If you have a link that has some instructions that would be great. I have used the ASP wizard but it's not giving me what I want.

Mojo -> RE: Using Drop Boxes to select data from database (5/29/2001 20:15:00)

If you were doing this from the DRW, it could be something like:

code:


<form><select name="folder">
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM 1"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="xmlread"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"--><OPTION VALUE="<%=FP_FieldVal(fp_rs,"ID")%>"><%=FP_FieldVal(fp_rs,"ID")%></OPTION>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</select></form>
</body>

You could format the way you want. Notice I have removed the grey code. This is the Spooky© Diet. You can find it here:
http://www.outfront.net/spooky/adv_drw_diet.htm

Joe

[This message has been edited by jbennett (edited 05-29-2001).]

Keith Cyr -> RE: Using Drop Boxes to select data from database (5/29/2001 20:02:00)
Well this is what I'm gettin. I'm following the DRW to the letter and I get this: Database Results Error The database connection named 'clientinfoupdate2' is undefined. This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root

Mojo -> RE: Using Drop Boxes to select data from database (5/29/2001 23:28:00)
Have you tried rebuilding your FrontPage database connection?

Keith Cyr -> RE: Using Drop Boxes to select data from database (5/29/2001 13:16:00)
Yes I sure have. AGHHHHHHH. I'm crawling into a cave and I'm not coming out.

Mojo -> RE: Using Drop Boxes to select data from database (5/29/2001 16:32:00)
Do your other connections work? I would try deleting the broke connection and then rebuilding it (my guess is you already did). Then I would think if I made any changes lately that could have caused the problem. Then, I would backup my global.asa file and reinstall the old one. First, though, I would confirm that each and every one of the possible errors returned by the DRW were in fact, not the problem. Also, as Spooky© would say: Learn ASP. Build your own connections. www.learnasp.com www.4guysfromrolla.com It is very easy to build you own simple database connection. We could walk you through it. Joe

Keith Cyr -> RE: Using Drop Boxes to select data from database (5/30/2001 20:44:00)
Funny that I was trying to do it on a Win98 machine at work. I come home to a Win2k system and no probs. Though I do have a question on how you can populate a drop down box with data from a column in a database. I'm still trying to find this answer.

Spooky -> RE: Using Drop Boxes to select data from database (5/30/2001 14:27:00)
For each record you need to check if the data is true, and if so, write 'selected' So for each option : <option > Record </option> Would become : <option <%If FPFieldVal(fp_rs("Value")) = "Record" then response.write "Selected"%>> Record </option> ------------------ §þððk¥ "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login!

Page: [1]

0.046875