fp_sQry="SELECT * FROM RealProperties WHERE PropertyID =
:
ropertyID::"
fp_sDefault="PropertyID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="database"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PropertyID=3&AssociateID=3&ListingDate=135&Address=202&City=202&State=129&Zip=3&InternalType=202&PropertyType=202&Zoned=202&MLSID=2&AskingPrice=6&SalePrice=6&LeasePrice=202&Status=202&WebActive=11&LotArea=202&MainBldgArea=202&Bedrooms=17&Baths=4&SwimPool=11&Fireplace=202&Garage=202&Features=201&PropertyDescription=201&PrimaryPhoto=202&Photo2=202&Photo3=202&Photo4=202&Photo5=202&Photo6=202&Deposit=202&"
fp_iDisplayCols=32
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="11355" -->
<form
METHOD="POST" action="update.asp" onsubmit="return
FrontPage_Form1_Validator(this)" language="JavaScript"
name="FrontPage_Form1">
<table BORDER=0>
<tr>
<td><b><font size="2">AssociateID:</font></b></td>
<td>
<!--webbot bot="Validation" s-display-name="Must Select A Sales
Associate"
b-value-required="TRUE" --><select size="1" name="AssociateID"
value="<%=FP_FieldLink(fp_rs,"AssociateID")%>">
<option value=1>Steve Reeves</option>
<option value=2>Kathy Anderson</option>
<option value=3>Courtney Anderson</option>
<option value=4>Mitzi Keck</option>
<option value=5>Scott Bryant</option>
</select>
</td>
:
Post your SQL please.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
I know what's going on (I think) but not sure how to fix it ...
I have drop-down boxes on the EDIT page. They are defined and would
work
if
the user went back in and "re-made" the selection for all the
drop-down
fields ...
When the EDIT page opens, it's setting the value for all the fields
to
equal
the appropriate value in the record ... that's desired ... but the
coding
to
populate the drop-down fields is not correct in that when the record
comes
up
in the EDIT page, the drop-down boxes have nothing "pre-selected"
(they
look
like they might look if they were on an ADD page) Here is the field
reference
from the EDIT page ..
------
<!--webbot bot="Validation" s-display-name="Must Select A Sales
Associate"
b-value-required="TRUE" --><select size="1" name="AssociateID"
value="<%=FP_FieldVal(fp_rs,"AssociateID")%>">
<option value=1>Steve Reeves</option>
<option value=2>Kathy Anderson</option>
<option value=3>Courtney Anderson</option>
<option value=4>Mitzi Keck</option>
<option value=5>Scott Bryant</option>
</select>
------
I don't want to set a default value for the drop-down box, I want it
to
display the value from the record and hence the correct name in the
drop-down
box ... remember, this is the EDIT page, not an ADD page.
Thanks
:
Kathleen: You've been a big help to me lately ... the debug helped
but
I'm
not sure what the error is saying ... the sql server database has
only
about
4 required data entry fields and this were provided by the ADD form
because
the insert succeeded, but opening the EDIT form to the SAME record,
making no
actual edit, then clicking submit and I get ...
[Database Results Wizard Error
Description: [Microsoft][ODBC SQL Server Driver]Invalid use of
default
parameter
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers]
I'll figure it out eventually but I wish the error was a bit more
specific
(there are 23 fields) The only fields that require data entry are
set
as
drop-down box that seem to be ....... I think I might know what's
going
on
Thanks again
One or more form fields were empty. You should provide default
values
for
all form fields that are used in the query.
:
The FP2003 code has changed slightly. To see the true error, open
the
hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Another Results Error but ...
I used the the interface waizard to build a complete set of
admin
pages.
The wizard runs fine and I accept all defaults (connection to a
remote sql
server)
I open the add page, insert a record, no problem
I open that same newly created record in the edit form ... make
absolutely
no edits, click the submit button, then get the error.
I've dug around into both add and edit forms to see if I could
see
something
obvious ... made some changed to some option field properties,
but
still
the
same result .... "Database Results Wizard Error
The operation failed. If this continues, please contact your
server
administrator."
Any ideas where to begin ... if it is a sql message refusing
the
update,
why
doesn't the sql message get returned to me so I can see it ...
if
it's not
a
sql server message, why is the wizard (or webbot) not providing
more
information?
Is there a log being created somewhere I can view?
Thanks
:
I'm getting this error on the Database Results table.
I'm using Access 2002 and FrontPage 2002 and using the
Database Interface Wizard to create the asp pages. If I
publish the global.asa with both the dev and prod webs
open, the results will show up today, but the same error
comes back tomorrow. Any help or suggestions would be
appreciated.
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN
for process 0x1e3c Thread 0x1830 DBC 0x22b0064 Jet'.
~Christine
eposit::' WHERE (PropertyID = :
"