Database Discussion - help on ASP

Print Page | Close Window

help on ASP - database connection

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1356
Printed Date: 28 March 2026 at 8:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: help on ASP - database connection

Posted By: madbug
Subject: help on ASP - database connection
Date Posted: 26 March 2003 at 2:13am

hi, i'm new on ASP. I'm using connection string to connect my database from a web server. I can attract the data I want from the database, but I can't write data or edit the database.

Any idea why? below is the delete coding.

Set conn = server.createobject("adodb.connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("Mydata.mdb"))
SQL = "Delete * From " & which & " Where ID =" & uid
conn.Execute(SQL)
Conn.Close

-------------
Jackson the madbug

Replies:

Posted By: michael
Date Posted: 26 March 2003 at 7:24am

Invalid SQL Syntax, kill the asteriks. You don't need to specify fieldnames as you always delete the whole record so it would be something like
DELETE FROM tablename where Field = value