Well, I successfully got it working to a degree. But, now there's another issue. I successfully added 1 item to the database. When I went to add another item, I got an error telling me that this update was not allowed because it would create a duplicate record. I thought this was strange, because I had added an item already. I printed out the database to screen and noticed that the new item had ID# "0". Instead of the highest number + 1. I think that each time I go to make an update to the DB, it tries to add another 0 to listnum column and it sees it as a duplicate.

Do you know of an easy way around this problem?

In Access set the column seed to 1

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Hello,

I'm getting an error that reads something like syntax error in "insert into" statement. I don't see anything glaringly wrong, do you??? : )

here is the code snippet in question:

    <%
    dim newtext
    newtext = request.Form("textspot")
    dim strSQL2

    strSQL2 = "INSERT INTO texteditor (text)" &_
             "VALUES ('" & newtext & "')"

    objconn.Execute strSQL2

    if objconn.Errors.Count = 0 then
        Response.Redirect "success.asp"
    else
        Response.Redirect "fail.asp"
    end if


    objconn.Close
    set objconn = nothing
%>

I'm also getting intermittent errors that state "Unspecified error"
dbconn.INC, line 7

which is my database connection include file. It's strange because sometimes the code is functional and works...but other times I get the unspecified error.

Any help would be greatly appreciated.

thank you,
brian

The syntax error is probably be caused by the app trying to insert a string like this:

dim newtext
newtext = "Hello! It's very warm outside"

In this case, your insert fails because of the '' in the newtext string because it causes termination of the SQL string when its executed. Replace ' with '' and that will solve your problem.

The unspecified error I can not help you with.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========