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
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications

RE: Assign value to database while using DBW by DaveLagergren

DaveLagergren
Wed Oct 31 17:04:02 PDT 2007

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

Dave
--
Dave Lagergren
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications


"Dave Lagergren" wrote:

> 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
> Manager - Data Applications
> Wireless Management, Inc
> Specializing in cellular wireless applications

Re: Assign value to database while using DBW by Kathleen

Kathleen
Thu Nov 01 04:36:13 PDT 2007

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" <DaveLagergren@discussions.microsoft.com> wrote in message
news:B5267309-0C1C-49F6-8792-6D8C2AB6A1EC@microsoft.com...
> Never mind - I hand coded it and got it working just fine.
>
> Dave
> --
> Dave Lagergren
> Manager - Data Applications
> Wireless Management, Inc
> Specializing in cellular wireless applications
>
>
> "Dave Lagergren" wrote:
>
>> 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
>> Manager - Data Applications
>> Wireless Management, Inc
>> Specializing in cellular wireless applications



Re: Assign value to database while using DBW by DaveLagergren

DaveLagergren
Thu Nov 01 09:55:02 PDT 2007

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...

--
Dave Lagergren
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications


"Kathleen Anderson" wrote:

> 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" <DaveLagergren@discussions.microsoft.com> wrote in message
> news:B5267309-0C1C-49F6-8792-6D8C2AB6A1EC@microsoft.com...
> > Never mind - I hand coded it and got it working just fine.
> >
> > Dave
> > --
> > Dave Lagergren
> > Manager - Data Applications
> > Wireless Management, Inc
> > Specializing in cellular wireless applications
> >
> >
> > "Dave Lagergren" wrote:
> >
> >> 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
> >> Manager - Data Applications
> >> Wireless Management, Inc
> >> Specializing in cellular wireless applications
>
>
>