ASP Classic - adding a record to an SQL Server database

Muslim Sattarov 1 Reputation point
2022-10-29T18:09:22.36+00:00

I am trying to add a record to an SQL Server database using ASP classic. The standard Select query, in order to show info from this table, works well, but when I send a query to the database to insert a record it shows this error:

"An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error."

Here's the link: https://smus.link/links/

lname = (Request("lname"))
url = (Request("url"))

SQLStatement = "SELECT * FROM links"
sco.Open SQLStatement, adoCon, 3, 3
sco.AddNew "name", lname
sco.Update
sco.Fields("url").value=url
sco.Update
sco.Close

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,318 questions
{count} votes