How do I post db results into form fields in Frontpage 2003.

Everything works ok. I can query the db ok, I get the results ok. I can
create a form ok. I can save the form to the db when needed....I just can't
find the syntax to transfer the db result to the form field.

db query
SELECT v_seller_id,v_seller_fname,v_seller_lname
FROM [v_sellers_full]
where v_sellers_full.v_seller_uname=::v_seller_uname::
and v_sellers_full.v_seller_pword=::v_seller_pword::

results come back ok...I just want to get v_seller_id into a form field...

In general, you have to program this by hand in ASP or
ASP.NET.

For a more specific answer, please describe what you want
to do in greater detail.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


>-----Original Message-----
>Everything works ok. I can query the db ok, I get the
results ok. I can
>create a form ok. I can save the form to the db when
needed....I just can't
>find the syntax to transfer the db result to the form
field.
>
>db query
>SELECT v_seller_id,v_seller_fname,v_seller_lname
>FROM [v_sellers_full]
>where v_sellers_full.v_seller_uname=::v_seller_uname::
>and v_sellers_full.v_seller_pword=::v_seller_pword::
>
>results come back ok...I just want to get v_seller_id
into a form field...
>
>.
>

What do you mean by "find the syntax to transfer the db result to the form
field."?

eg Do you mean to load a record into an html form to edit that record? If you
want editing and deleting capability, use the database interface wizard in
frontpage (which also includes the form for entering records).



"Jim Buyens" <news@interlacken.com> wrote in message
news:ab4801c48894$d236ca80$a501280a@phx.gbl...
> In general, you have to program this by hand in ASP or
> ASP.NET.
>
> For a more specific answer, please describe what you want
> to do in greater detail.
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *----------------------------------------------------
> |\---------------------------------------------------
> || Microsoft Office FrontPage 2003 Inside Out
> ||---------------------------------------------------
> || Web Database Development Step by Step .NET Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/---------------------------------------------------
> *----------------------------------------------------
>
>
> >-----Original Message-----
> >Everything works ok. I can query the db ok, I get the
> results ok. I can
> >create a form ok. I can save the form to the db when
> needed....I just can't
> >find the syntax to transfer the db result to the form
> field.
> >
> >db query
> >SELECT v_seller_id,v_seller_fname,v_seller_lname
> >FROM [v_sellers_full]
> >where v_sellers_full.v_seller_uname=::v_seller_uname::
> >and v_sellers_full.v_seller_pword=::v_seller_pword::
> >
> >results come back ok...I just want to get v_seller_id
> into a form field...
> >
> >.
> >

I still don't get it.

Are you trying to produce a single DRW "report" using fields from both
the Sellers and Items tables?

Or are you trying to set up a data entry form where one the fields is
a seller_id that must match a record in the Sellers table?

And in this second case, does the seller_id come from a previous page,
or from a dropdown box, or what?

And what's the v_seller_pword field?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



"fpsys" <fpsys@discussions.microsoft.com> wrote in message news:<03EFF00C-649F-4236-9A23-67B336E12772@microsoft.com>...
> Yes, exactly. To transfer the db result to the form field. I'm using SQL
> Server and dealing with two tables. "Sellers" and "Items". I need to pull the
> seller_id from Sellers and use it as a foreign key in the item table.
> Thanks.
>
> "Andrew Murray" wrote:
>
> > What do you mean by "find the syntax to transfer the db result to the form
> > field."?
> >
> > eg Do you mean to load a record into an html form to edit that record? If you
> > want editing and deleting capability, use the database interface wizard in
> > frontpage (which also includes the form for entering records).
> >
> >
> >
> > "Jim Buyens" <news@interlacken.com> wrote in message
> > news:ab4801c48894$d236ca80$a501280a@phx.gbl...
> > > In general, you have to program this by hand in ASP or
> > > ASP.NET.
> > >
> > > For a more specific answer, please describe what you want
> > > to do in greater detail.
> > >
> > > Jim Buyens
> > > Microsoft FrontPage MVP
> > > http://www.interlacken.com
> > > Author of:
> > > *----------------------------------------------------
> > > |\---------------------------------------------------
> > > || Microsoft Office FrontPage 2003 Inside Out
> > > ||---------------------------------------------------
> > > || Web Database Development Step by Step .NET Edition
> > > || Microsoft FrontPage Version 2002 Inside Out
> > > || Faster Smarter Beginning Programming
> > > || (All from Microsoft Press)
> > > |/---------------------------------------------------
> > > *----------------------------------------------------
> > >
> > >
> > > >-----Original Message-----
> > > >Everything works ok. I can query the db ok, I get the
> results ok. I can
> > > >create a form ok. I can save the form to the db when
> needed....I just can't
> > > >find the syntax to transfer the db result to the form
> field.
> > > >
> > > >db query
> > > >SELECT v_seller_id,v_seller_fname,v_seller_lname
> > > >FROM [v_sellers_full]
> > > >where v_sellers_full.v_seller_uname=::v_seller_uname::
> > > >and v_sellers_full.v_seller_pword=::v_seller_pword::
> > > >
> > > >results come back ok...I just want to get v_seller_id
> into a form field...
> > > >
> > > >.
> > > >
> >
> >
> >

FrontPage can't do this directly. You'll have to write your own
program code in something like ASP or ASP.NET.

Now, if that's not a show-stopper, do you visualize this as:

o Two forms, where:
+ The visitor types the username/password on the first form.
+ The vistor clicks Submit.
+ The seller_id shows up on the second form.
+ The visitor fills out the rest of the fields on the second form.
+ The vistor again clicks Submit?

or

o One form, where:
+ The visitor fills out the username, password, and other
information all on one form
+ The vistor clicks Submit only once?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

"fpsys" <fpsys@discussions.microsoft.com> wrote in message news:<C58E550D-AE4C-4569-A65D-674AED2D4F71@microsoft.com>...
> the latter. I'm setting up a data entry form where one of the fields is the
> seller id.
>
> The user enters username/password and the seller_id is returned. I want THAT
> seller_id to go into the form along with other user entered info. THe form
> will populate the item table.
>
> "Jim Buyens" wrote:
>
> > I still don't get it.
> >
> > Are you trying to produce a single DRW "report" using fields from both
> > the Sellers and Items tables?
> >
> > Or are you trying to set up a data entry form where one the fields is
> > a seller_id that must match a record in the Sellers table?
> >
> > And in this second case, does the seller_id come from a previous page,
> > or from a dropdown box, or what?
> >
> > And what's the v_seller_pword field?
> >
> > Jim Buyens
> > Microsoft FrontPage MVP
> > http://www.interlacken.com
> > Author of:
> > *----------------------------------------------------
> > |\---------------------------------------------------
> > || Microsoft Office FrontPage 2003 Inside Out
> > ||---------------------------------------------------
> > || Web Database Development Step by Step .NET Edition
> > || Microsoft FrontPage Version 2002 Inside Out
> > || Faster Smarter Beginning Programming
> > || (All from Microsoft Press)
> > |/---------------------------------------------------
> > *----------------------------------------------------
> >
> >
> >
> > "fpsys" <fpsys@discussions.microsoft.com> wrote in message news:<03EFF00C-649F-4236-9A23-67B336E12772@microsoft.com>...
> > > Yes, exactly. To transfer the db result to the form field. I'm using SQL
> > > Server and dealing with two tables. "Sellers" and "Items". I need to pull the
> > > seller_id from Sellers and use it as a foreign key in the item table.
> > > Thanks.
> > >
> > > "Andrew Murray" wrote:
> > >
> > > > What do you mean by "find the syntax to transfer the db result to the form
> > > > field."?
> > > >
> > > > eg Do you mean to load a record into an html form to edit that record? If you
> > > > want editing and deleting capability, use the database interface wizard in
> > > > frontpage (which also includes the form for entering records).
> > > >
> > > >
> > > >
> > > > "Jim Buyens" <news@interlacken.com> wrote in message
> > > > news:ab4801c48894$d236ca80$a501280a@phx.gbl...
> > > > > In general, you have to program this by hand in ASP or
> > > > > ASP.NET.
> > > > >
> > > > > For a more specific answer, please describe what you want
> > > > > to do in greater detail.
> > > > >
> > > > > Jim Buyens
> > > > > Microsoft FrontPage MVP
> > > > > http://www.interlacken.com
> > > > > Author of:
> > > > > *----------------------------------------------------
> > > > > |\---------------------------------------------------
> > > > > || Microsoft Office FrontPage 2003 Inside Out
> > > > > ||---------------------------------------------------
> > > > > || Web Database Development Step by Step .NET Edition
> > > > > || Microsoft FrontPage Version 2002 Inside Out
> > > > > || Faster Smarter Beginning Programming
> > > > > || (All from Microsoft Press)
> > > > > |/---------------------------------------------------
> > > > > *----------------------------------------------------
> > > > >
> > > > >
> > > > > >-----Original Message-----
> > > > > >Everything works ok. I can query the db ok, I get the
> results ok. I can
> > > > > >create a form ok. I can save the form to the db when
> needed....I just can't
> > > > > >find the syntax to transfer the db result to the form
> field.
> > > > > >
> > > > > >db query
> > > > > >SELECT v_seller_id,v_seller_fname,v_seller_lname
> > > > > >FROM [v_sellers_full]
> > > > > >where v_sellers_full.v_seller_uname=::v_seller_uname::
> > > > > >and v_sellers_full.v_seller_pword=::v_seller_pword::
> > > > > >
> > > > > >results come back ok...I just want to get v_seller_id
> into a form field...
> > > > > >
> > > > > >.
> > > > > >
> > > >
> > > >
> > > >
> >