SQL Database in ASP

[Robert Cohen]

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

[Ray at]

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


"Robert Cohen" <rcohen@NOSPAM.bbhtx.org> wrote in message
news:%23nw$n29zDHA.1500@TK2MSFTNGP12.phx.gbl...
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
--