Hello All,
I don't know if this is the right group or not to discuss this issue =
with, but I am hoping so. I have an SQL database and am trying to use =
frontpage as my interface. I am able to query the database fine and =
present the data on a webpage; however, I want a way to modify- add =
entries and such from the website. The question is, how do I do this =
within Frontpage on an interrelational database.

For a simple example. I have these three tables tblstaff, tblposition, =
tblstaffposition

tblstaff is just an sequence number for each staff, the staff's first =
and last name
tblposition is just a sequence number and the positions
tblstaffposition is just sequence number for staff and sequence number =
for position

If I use the following, I get results and with modifying which fields =
get shown, I can have the results of just the staffs' names and position

SELECT tblstaff.iseq, tblstaff.clname, tblstaff.cfname, =
tblposition.iseq, tblposition.cposition, tblstaffposition.iseqStaff, =
tblstaffposition.iseqPosition
FROM tblstaff, tblposition, tblstaffposition
WHERE tblstaffposition.iseqstaff =3D tblstaff.iseq=20
AND tblstaffposition.iseqposition =3D tblposition.iseq

However, I want to be able to add new staff and assign them positions =
within the webpage. THat is where I am stuck at. I can create a =
submittal page for tblstaffposition and be able to enter the sequence =
number for staff and position. But what I want to do is add a staff =
name and from a drop down list, click on position and for the webpage to =
add the staff member into tblstaff with a new sequence number and to add =
the staff name sequence number and position name sequence number into =
tblstaffposition

Can someone point me in the right direction.

--=20
Robert Cohen
A legend in his own mind

Instead of executing a SELECt, you execute an INSERT like so:

<%
sName = Request.Form("txtName")
sSQL = "INSERT INTO TheTable (PersonName) VALUES ('" & Replace(sName, "'",
"''") & "')"
Set oADO = Server.CreateObject("ADODB.Connection")
oADO.Open YourConnectionString
oADO.Execute sSQL
oADO.Close : Set oADO = Nothing
Response.Write sName & " was inserted."
%>

How you do this in Frontpage? I don't know. If at all possible, do not use
Frontpage to generate code. Hand-coding your ASP code will save you lots of
headaches...

Ray at work


[quoted text, click to view]
Hello All,
I don't know if this is the right group or not to discuss this issue
with, but I am hoping so. I have an SQL database and am trying to use
frontpage as my interface. I am able to query the database fine and present
the data on a webpage; however, I want a way to modify- add entries and such
from the website. The question is, how do I do this within Frontpage on an
interrelational database.

For a simple example. I have these three tables tblstaff, tblposition,
tblstaffposition

tblstaff is just an sequence number for each staff, the staff's first and
last name
tblposition is just a sequence number and the positions
tblstaffposition is just sequence number for staff and sequence number for
position

If I use the following, I get results and with modifying which fields get
shown, I can have the results of just the staffs' names and position

SELECT tblstaff.iseq, tblstaff.clname, tblstaff.cfname, tblposition.iseq,
tblposition.cposition, tblstaffposition.iseqStaff,
tblstaffposition.iseqPosition
FROM tblstaff, tblposition, tblstaffposition
WHERE tblstaffposition.iseqstaff = tblstaff.iseq
AND tblstaffposition.iseqposition = tblposition.iseq

However, I want to be able to add new staff and assign them positions within
the webpage. THat is where I am stuck at. I can create a submittal page
for tblstaffposition and be able to enter the sequence number for staff and
position. But what I want to do is add a staff name and from a drop down
list, click on position and for the webpage to add the staff member into
tblstaff with a new sequence number and to add the staff name sequence
number and position name sequence number into tblstaffposition

Can someone point me in the right direction.

--
Robert Cohen
A legend in his own mind
--