dhotchin — Mon, 22 Aug 2005 16:48:38 +0000

Cheers for that.

For future notes, what would you say be the best langauge to learn? I find ASP and Access easy to understand the basics so i thought i would stick to it.

bja888 — Mon, 22 Aug 2005 16:43:51 +0000

I'm not going to write the whole code for you but I can point you in the right direction...
- Your first proublem is letting macromedia write the code for you.
- Second your writeing in VB the only real purpose is VB is for asp classic.
- 3rd, your writeing in ASP classic useing a access db. There are better technologies out there.

But if you still wish to stick with what u have now....
See this...

  MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"

'
"MM_editQuery" is a SQL string. The "insert into" keywords in a SQL string tell the database to add a new row.

  If (Not MM_abortEdit) Then
    ' execute the insert
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

'
The row really isnt added untill this section is ran. Write the page so it runs the SQL sting for each row you want to add.

dhotchin — Mon, 22 Aug 2005 16:23:39 +0000

Sorry.

Yes. The code above is what i have so far. I can add just a single row at a time, or all the rows in the table in to a single row in a access database. But what i would like is to add each row on the table in to its own row in the access database.

I hope this helps.

bja888 — Mon, 22 Aug 2005 16:05:45 +0000

That was some what confuseing but here is what I got... you want a online form that you can fill out and it will add a few rows in a access db?