Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: adding a row in a table


Message #1 by JonGrman21@a... on Mon, 28 Aug 2000 16:47:21 EDT
im trying to add a row into a table on the click of a button...so that when 

you click it you add a new phase or row into the table



if someone has an example of that or could steer me in the right direction 

that would be a great help

thanx

email me back at jongrman21@a...

Message #2 by "Ken Schaefer" <ken@a...> on Wed, 30 Aug 2000 14:14:28 +1000
Are you talking about adding a row to a HTML table, or a row to a database?



If the former, then ask on a client-side DHTML list



If the latter, then you need to submit the form (RDS excluded).



strSQL = "INSERT INTO table1 "

strSQL = strSQL & "(field1) "

strSQL = strSQL & "VALUES('somevalue')"



Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open Application("strDBConnectionString")



objConn.execute(strSQL)



objConn.Close

Set objConn = nothing



HTH



Cheers

Ken



----- Original Message -----

From: <JonGrman

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, August 29, 2000 6:47 AM

Subject: [asp_databases] adding a row in a table





> im trying to add a row into a table on the click of a button...so that

when

> you click it you add a new phase or row into the table

>

> if someone has an example of that or could steer me in the right direction

> that would be a great help

> thanx

> email me back at jongrman21@a...

>




  Return to Index