Assign value to database while using DBW

[Dave Lagergren]

I am working on a FP databse. To save time I have used DBW to construct
everything and then I have modified the layout to look half way decent.

I have one problem. One of the values that needs to be saved to the
database is ont input by the user but is calculated by the system. How can I
set a varaible so that the DBW BOT will process it? Here is the code:

<td align="right"><font face="Arial"><b>Company Number: </b>
</font></td>
<td><font face="Arial">
<% ' This next text writes the variable iRecordCount to the screen and
then needs to assign the value of iRecordCount to the variable OrderNumber
used by DBW
response.write iRecordCount
OrderNumber=iRecordCount%>
</font></td>
<td align="right"><font face="Arial"><b>Rep: </b></font>
</td>
<td><font face="Arial"> <!--webbot bot="Validation"
s-display-name="OrderNumber" s-data-type="String" b-value-required="True"
i-maximum-length="50" -->

If I have to I will hand code everything but I prefer not to because of time
constraints.

 

[Dave Lagergren]

Never mind - I hand coded it and got it working just fine.

Dave

 

[Kathleen Anderson]

Dave:
Can you tell us how you did it? I have a project coming up where I need to
do the same thing.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Dave Lagergren]

Kathleen - I hand coded the page getting rid of all the DBW stuff.
Fortunately I only needed 14 fields to be input. I use the input page>write
to database page>custom confirmation page approach. I am tired of wasting my
time with the DBW unless it is some simple application without any
customization. I still use the FP BOTS to check input validation in most
cases.

I wish there was a way to insert variables into the DBW but since FP is
going away...