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

[Guest]

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

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Andrew Murray]

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

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

.

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------

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.

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

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

.

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------

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.

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)
|/---------------------------------------------------
*----------------------------------------------------

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.

:

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



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

.