Forms in asp

Los Jardines · Apr 30, 2006

Hi

Hopefully someone can help me with couple of things.

I've created a form which,when the user fills in information it email me
with that information and also stores it on the site in a text file,
standard stuff I think. I thought it would be neat to use this information
via a DB and the DRW to first of all show a user the information we have so
far and then allow them to edit it if needed and resend the information
using the form webbot.

I figured out how to use the data to fill in the "default value" in the form
field by using the <%=FP_FieldVal(fp_rs,"data")%> expression but it would
seem the form webbot will not work with an .asp extension. I've striped the
form back to just the form it's self and in htm it works just fine, as soon
as I go .asp so I can start with the DRW it stops both sending emails or
storing the data in the text file. Is this normal as this is the first time
I've looked beyond the WYSIWYG bit.

If it is the norm, then how do I pass this variable from the found data to a
form default value on a new htm page?

thanks for your help

Paul

Stefan B Rusynko · May 1, 2006

Any use of the DBRW (or any DB w/ server side code) requires .asp pages
- which preclude use of the FP form webbots ( which require .htm pages)

That means you would need to send the Email using server side coding (asp) using CDOSYS
See http://support.microsoft.com/default.aspx?scid=kb;en-us;275251
(and http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46 or http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54)

If you are saving in a DB you don't need to save in a file (.txt or .htm)
- but if you feel you need to, you would need to use server side coding to write to the file
See http://www.w3schools.com/asp/asp_ref_filesystem.asp
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

| Hi
|
| Hopefully someone can help me with couple of things.
|
| I've created a form which,when the user fills in information it email me
| with that information and also stores it on the site in a text file,
| standard stuff I think. I thought it would be neat to use this information
| via a DB and the DRW to first of all show a user the information we have so
| far and then allow them to edit it if needed and resend the information
| using the form webbot.
|
| I figured out how to use the data to fill in the "default value" in the form
| field by using the <%=FP_FieldVal(fp_rs,"data")%> expression but it would
| seem the form webbot will not work with an .asp extension. I've striped the
| form back to just the form it's self and in htm it works just fine, as soon
| as I go .asp so I can start with the DRW it stops both sending emails or
| storing the data in the text file. Is this normal as this is the first time
| I've looked beyond the WYSIWYG bit.
|
| If it is the norm, then how do I pass this variable from the found data to a
| form default value on a new htm page?
|
| thanks for your help
|
| Paul
|
|

Los Jardines · May 1, 2006

Thank you Stefan

I think I've got the email thing sussed, thank you for your help.

What about passing data from a database to the default value of a form
field. In my case I have a database of apartment owners and we want them to
keep this information up to date. So I intend to let them query the database
using info known only to them (say email address and apartment number) DRW
does all this for me. It would be good if this data then transfers (as
initial value) to a form fields which allows the owner to fill in either
missing bits or correct stuff, then send an email to me then update a
database.

With your help I now have most of this except the population of the initial
value of the form fields with owner data from the master database.

Any clues?

Kind regards

Paul

Stefan B Rusynko said:
Any use of the DBRW (or any DB w/ server side code) requires .asp pages
- which preclude use of the FP form webbots ( which require .htm pages)

That means you would need to send the Email using server side coding (asp)
using CDOSYS
See http://support.microsoft.com/default.aspx?scid=kb;en-us;275251
(and http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46 or
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54)

If you are saving in a DB you don't need to save in a file (.txt or .htm)
- but if you feel you need to, you would need to use server side coding to
write to the file
See http://www.w3schools.com/asp/asp_ref_filesystem.asp
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

| Hi
|
| Hopefully someone can help me with couple of things.
|
| I've created a form which,when the user fills in information it email me
| with that information and also stores it on the site in a text file,
| standard stuff I think. I thought it would be neat to use this
information
| via a DB and the DRW to first of all show a user the information we have
so
| far and then allow them to edit it if needed and resend the information
| using the form webbot.
|
| I figured out how to use the data to fill in the "default value" in the
form
| field by using the <%=FP_FieldVal(fp_rs,"data")%> expression but it
would
| seem the form webbot will not work with an .asp extension. I've striped
the
| form back to just the form it's self and in htm it works just fine, as
soon
| as I go .asp so I can start with the DRW it stops both sending emails or
| storing the data in the text file. Is this normal as this is the first
time
| I've looked beyond the WYSIWYG bit.
|
| If it is the norm, then how do I pass this variable from the found data
to a
| form default value on a new htm page?
|
| thanks for your help
|
| Paul
|
|

Stefan B Rusynko · May 2, 2006

See http://home.att.net/~codelibrary/FrontPage/drw.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

| Thank you Stefan
|
| I think I've got the email thing sussed, thank you for your help.
|
| What about passing data from a database to the default value of a form
| field. In my case I have a database of apartment owners and we want them to
| keep this information up to date. So I intend to let them query the database
| using info known only to them (say email address and apartment number) DRW
| does all this for me. It would be good if this data then transfers (as
| initial value) to a form fields which allows the owner to fill in either
| missing bits or correct stuff, then send an email to me then update a
| database.
|
| With your help I now have most of this except the population of the initial
| value of the form fields with owner data from the master database.
|
| Any clues?
|
| Kind regards
|
| Paul
|
|
| | > Any use of the DBRW (or any DB w/ server side code) requires .asp pages
| > - which preclude use of the FP form webbots ( which require .htm pages)
| >
| > That means you would need to send the Email using server side coding (asp)
| > using CDOSYS
| > See http://support.microsoft.com/default.aspx?scid=kb;en-us;275251
| > (and http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46 or
| > http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54)
| >
| > If you are saving in a DB you don't need to save in a file (.txt or .htm)
| > - but if you feel you need to, you would need to use server side coding to
| > write to the file
| > See http://www.w3schools.com/asp/asp_ref_filesystem.asp
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | Hi
| > |
| > | Hopefully someone can help me with couple of things.
| > |
| > | I've created a form which,when the user fills in information it email me
| > | with that information and also stores it on the site in a text file,
| > | standard stuff I think. I thought it would be neat to use this
| > information
| > | via a DB and the DRW to first of all show a user the information we have
| > so
| > | far and then allow them to edit it if needed and resend the information
| > | using the form webbot.
| > |
| > | I figured out how to use the data to fill in the "default value" in the
| > form
| > | field by using the <%=FP_FieldVal(fp_rs,"data")%> expression but it
| > would
| > | seem the form webbot will not work with an .asp extension. I've striped
| > the
| > | form back to just the form it's self and in htm it works just fine, as
| > soon
| > | as I go .asp so I can start with the DRW it stops both sending emails or
| > | storing the data in the text file. Is this normal as this is the first
| > time
| > | I've looked beyond the WYSIWYG bit.
| > |
| > | If it is the norm, then how do I pass this variable from the found data
| > to a
| > | form default value on a new htm page?
| > |
| > | thanks for your help
| > |
| > | Paul
| > |
| > |
| >
| >
|
|

Los Jardines · May 2, 2006

Thank you

Stefan B Rusynko said:
See http://home.att.net/~codelibrary/FrontPage/drw.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

| Thank you Stefan
|
| I think I've got the email thing sussed, thank you for your help.
|
| What about passing data from a database to the default value of a form
| field. In my case I have a database of apartment owners and we want them
to
| keep this information up to date. So I intend to let them query the
database
| using info known only to them (say email address and apartment number)
DRW
| does all this for me. It would be good if this data then transfers (as
| initial value) to a form fields which allows the owner to fill in either
| missing bits or correct stuff, then send an email to me then update a
| database.
|
| With your help I now have most of this except the population of the
initial
| value of the form fields with owner data from the master database.
|
| Any clues?
|
| Kind regards
|
| Paul
|
|
| | > Any use of the DBRW (or any DB w/ server side code) requires .asp
pages
| > - which preclude use of the FP form webbots ( which require .htm
pages)
| >
| > That means you would need to send the Email using server side coding
(asp)
| > using CDOSYS
| > See http://support.microsoft.com/default.aspx?scid=kb;en-us;275251
| > (and http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46 or
| > http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54)
| >
| > If you are saving in a DB you don't need to save in a file (.txt or
.htm)
| > - but if you feel you need to, you would need to use server side
coding to
| > write to the file
| > See http://www.w3schools.com/asp/asp_ref_filesystem.asp
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
message
| > | > | Hi
| > |
| > | Hopefully someone can help me with couple of things.
| > |
| > | I've created a form which,when the user fills in information it
email me
| > | with that information and also stores it on the site in a text file,
| > | standard stuff I think. I thought it would be neat to use this
| > information
| > | via a DB and the DRW to first of all show a user the information we
have
| > so
| > | far and then allow them to edit it if needed and resend the
information
| > | using the form webbot.
| > |
| > | I figured out how to use the data to fill in the "default value" in
the
| > form
| > | field by using the <%=FP_FieldVal(fp_rs,"data")%> expression but it
| > would
| > | seem the form webbot will not work with an .asp extension. I've
striped
| > the
| > | form back to just the form it's self and in htm it works just fine,
as
| > soon
| > | as I go .asp so I can start with the DRW it stops both sending
emails or
| > | storing the data in the text file. Is this normal as this is the
first
| > time
| > | I've looked beyond the WYSIWYG bit.
| > |
| > | If it is the norm, then how do I pass this variable from the found
data
| > to a
| > | form default value on a new htm page?
| > |
| > | thanks for your help
| > |
| > | Paul
| > |
| > |
| >
| >
|
|

Forms in asp

Los Jardines

Stefan B Rusynko

Los Jardines

Stefan B Rusynko

Los Jardines