Unable to populate form with DRW info

[Augie Dawg]

I'm trying to put a value that has been generated by the DRW into a form
field as the initial value. I've put the following value into the "initial
value" box of the Text Box Properties dialog box:

<%=FP_FieldHTML(fp_rs,"Dues")%>

"Dues" is defined in a DRW custom query found before the form as follows:

FORMAT (IIf(DatePart('m',Now()) Between 7 AND 10), ([MemberDues]/2),
[MemberDues]) ,'$#,##0.00') AS Dues

The DRW runs with no problem, but the form field that follows it with my
default value is left blank.

The form is using the "Save to Database" option...I'm thinking that the
Webbot that handles this option and does field validation is dropping this
value somehow. Any other ideas?

Thanks,
A.D.

 

[Jon Spivey]

Hi,
I'd go to HTML view and type the value in yourself, eg
<input type="text" value="<%=FP_FieldHTML(fp_rs,"Dues")%>" name="something">

 

[Augie Dawg]

The value is correctly set in the HTML; it appears as follows:

<input name="PaymentAmount" size="5" value="<%=FP_FieldVal(fp_rs,"Dues")%>"
tabindex="2">

I've tried to further isolate the problem by not using the "Save to
Database" option and instead creating a simple form that then invokes a page
with a custom query with INSERT INTO logic. To my surprise, that didn't
work. So then I tried to simply write out the value...I inserted the
following after the DRW but before the form:

<%response.write(FP_FieldHTML(fp_rs,"Dues"))%>

Once again, nothing was written!! So now I'm really confused, as I know FP
uses this type of code to generate parameters for hyperlinks, so the scope
of fp_rs should be active. I've tried printing other fields from the same
query, with no results being printed.

Can anyone shed any light on this problem?

Thanks,
A.D.

------------------------------------------------------

Hi,
I'd go to HTML view and type the value in yourself, eg
<input type="text" value="<%=FP_FieldHTML(fp_rs,"Dues")%>" name="something">

--
Cheers,
Jon
Microsoft MVP - FP

I'm trying to put a value that has been generated by the DRW into a form
field as the initial value. I've put the following value into the "initial
value" box of the Text Box Properties dialog box:

<%=FP_FieldHTML(fp_rs,"Dues")%>

"Dues" is defined in a DRW custom query found before the form as follows:

FORMAT (IIf(DatePart('m',Now()) Between 7 AND 10), ([MemberDues]/2),
[MemberDues]) ,'$#,##0.00') AS Dues

The DRW runs with no problem, but the form field that follows it with my
default value is left blank.

The form is using the "Save to Database" option...I'm thinking that the
Webbot that handles this option and does field validation is dropping this
value somehow. Any other ideas?

Thanks,
A.D.

 

[Augie Dawg]

I'm afraid there was a bit of fuzzy thinking on my part, as I was trying to
use FP_FieldVal outside the scope of the DRW region. Saving off the value I
needed inside the DRW with some VBScript worked, though. Thanks for your
suggestion nonetheless.

A.D.

The value is correctly set in the HTML; it appears as follows:

<input name="PaymentAmount" size="5"

tabindex="2">

I've tried to further isolate the problem by not using the "Save to
Database" option and instead creating a simple form that then invokes a page
with a custom query with INSERT INTO logic. To my surprise, that didn't
work. So then I tried to simply write out the value...I inserted the
following after the DRW but before the form:

<%response.write(FP_FieldHTML(fp_rs,"Dues"))%>

Once again, nothing was written!! So now I'm really confused, as I know FP
uses this type of code to generate parameters for hyperlinks, so the scope
of fp_rs should be active. I've tried printing other fields from the same
query, with no results being printed.

Can anyone shed any light on this problem?

Thanks,
A.D.

------------------------------------------------------

Hi,
I'd go to HTML view and type the value in yourself, eg
<input type="text" value="<%=FP_FieldHTML(fp_rs,"Dues")%>" name="something">

--
Cheers,
Jon
Microsoft MVP - FP

I'm trying to put a value that has been generated by the DRW into a form
field as the initial value. I've put the following value into the "initial
value" box of the Text Box Properties dialog box:

<%=FP_FieldHTML(fp_rs,"Dues")%>

"Dues" is defined in a DRW custom query found before the form as follows:

FORMAT (IIf(DatePart('m',Now()) Between 7 AND 10), ([MemberDues]/2),
[MemberDues]) ,'$#,##0.00') AS Dues

The DRW runs with no problem, but the form field that follows it with my
default value is left blank.

The form is using the "Save to Database" option...I'm thinking that the
Webbot that handles this option and does field validation is dropping this
value somehow. Any other ideas?

Thanks,
A.D.