|
| |
|
|
Keith Cyr
Posts: 28
From: Atlanta, GA
Status: offline
 |
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
Posts: 2431
From: Chicago
Status: offline
|
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
Posts: 28
From: Atlanta, GA
Status: offline
|
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
Posts: 2431
From: Chicago
Status: offline
|
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
Posts: 28
From: Atlanta, GA
Status: offline
|
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
Posts: 2431
From: Chicago
Status: offline
|
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
Posts: 28
From: Atlanta, GA
Status: offline
|
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
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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!
| |
|
 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 
