All your code is doing is reading all the records from a table called
HelloWorld. You need an insert statement to write to it.
Rather than trying to hand code it, I would look at upgradings to DMX, as
all this functionality is built in.
Valleybiz Internet Design
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
"Mithrandir" <webforumsusermacromedia.com> wrote in message
news:bf2hbv$5qr$1forums.macromedia.com...add records to my database.> Hi,
> I'm just learning how to use ASP and I've been trying to figure out how toexcept IT DOESNT WORK!!!!>
> I'm learning it out of a book and have been following the code in the book>
> I have no idea why. It's maddening!
> My update code is attached for your kindly inspection.
> Thanks for whatever help you can provide. I'll need it.
> <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <% Option Explicit %>
> Dim Connect, msgRS, Query
> Set Connect = Server.CreateObject("ADODB.Connection")
> Connect.Open "appData1"
> Set msgRS = Server.CreateObject("ADODB.Recordset")
> Query = "SELECT * FROM helloWorld"
> msgRS.Open Query, Connect, adOpenStatic, _
> msgRS("name") = "John Doe"
> msgRS("Message") = "Ya did a great jeaoaearb there!"
> All that is gold does not glitter
> Not all who wander are lost . . .
> -- J. R. R. Tolkien