|
| |
|
|
wertz
Posts: 2
Joined: 6/23/2004
Status: offline
 |
RE: using drop down to update MS Access - 6/23/2004 6:05:15
below is the sample
i need the "SekolahDiTerima" to come from the "NamaSekolah" field.
pls help....
<td><font face="Verdana" size="1"><input NAME="SekolahDiTerima" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"SekolahDiTerima")%>"></font>
<p>
<nobr><!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="NamaSekolah,ThnPendaftaran,ICAnak,NamaPenjaga,ICPenjaga,AlamatRumah,Bandar,Poskod,Daerah,PekerjaanPenjaga,Telefon,Email,NamaAnak,Bangsa,Agama,Jantina,TarikhLahir,TempatLahir,TarikhDaftar,Umur1Jan,StatusPemohonan,Alasan,SekolahDiTerima,TarikhLaporDiri"
s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,135,202,202,203,202,202"
s-dataconnection="SchoolProfileDatabase" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="NamaSekolah" s-menuvalue="NamaSekolah"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0" b-makeform="TRUE"
s-recordsource="Standard1AppTab" s-displaycolumns="NamaSekolah"
s-criteria="[Poskod] EQ {Poskod} +" s-order
s-sql="SELECT * FROM Standard1AppTab WHERE (Poskod = '::Poskod::')"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Poskod="
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="2" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc"
local_preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> "
preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM Standard1AppTab WHERE (Poskod = '::Poskod::')"
fp_sDefault="Poskod="
fp_sNoRecords="No records returned."
fp_sDataConn="SchoolProfileDatabase"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="NamaSekolah"
fp_sMenuValue="NamaSekolah"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="40265" endspan -->
<select NAME="SekolahDiTerima" SIZE="1">
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="_fpclass/fpdbrgn1.inc" --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="62210" endspan -->
<option><%=FP_FieldHTML(fp_rs,"NamaSekolah")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="_fpclass/fpdbrgn2.inc" --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="62218" endspan -->
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: using drop down to update MS Access - 6/23/2004 8:55:36
Welcome to OutFront. Unfortunately, no, you cannot have one database results region within another. One solution is to have your dropdown be the first or last item in the form and have it sit within the <form> and </form> tags but outside the first database results region.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 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 
