deleting data from database

krills · #1 (**permalink**) 09-25-04, 18:57

Ive just started learning ASP and i am using MySQL databases. So far ive managed to make a newsposting thing that allows me to insert news and read them. Now i want to have the option of deleting data from the database directly from the site, but whatever i try to write in the sql command it doesn't want to work. I don't know where i should ask this question but ill start here =)
ive read several guides but some of them are PHP guides or ASP but msaccess databases.
this is how my stuff looks at the moment:

(page name: newsremove.asp)

Code:

<%
if request("delid") <> "" then
 delid=request("delid")
 sql="DELETE * FROM news WHERE ID=" & delid
 conn.execute(sql)
end if
%>
<form action="newsremove.asp" method="post">
Type in the ID of the post you wish to remove: <input type="text" name="delid" size=20><br>
<input type="submit" value="remove this post!">
</form>

I also have this little part where i show all the news but i don't think it has anything to do with the errors i get.

Code:

do until rs.eof
 response.write "<hr align=left width=300 size=2 color=black noshading>"
 response.write rs("time") & " by " & rs("poster") & ". ID: " & rs("id")
 rs.moveNext
loop

The errors i get when i try to remove a entry is
"ADODB.Connection.1 (0x80004005)
SQLState: 42000 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM news WHERE ID=9' at line 1
/newsremove.asp, line 25"

ANY HELP AT ALL IS VERY THX!

r937 · #2 (**permalink**) 09-26-04, 13:37

the error message points to exactly where the problem is

remove the asterisk

DELETE FROM news WHERE ID=937

krills · #3 (**permalink**) 09-26-04, 14:38

:O what!? i dont need the *? im gona try and see =)

krills · #4 (**permalink**) 09-26-04, 14:44

well, now i get my old friend "expected 'end' "

"Expected 'End'
/newsremove.asp, line 31, column 40"

Line 31 is the empty line between "if request("delid") = "" then" and "delid=request("delid")"

Code:

<form action="newsremove.asp" method="post">
		Type in the ID of the post you wish to remove: <input type="text" name="delid" size=20><br>
		<b>Make sure its the right one! Once you delete a post it can't be recovered!!</b><br>
		<input type="submit" value="Im sure, remove this post!">
		</form>
		<%
		
		if request("delid") = "" then
		
			delid=request("delid")
			sql="DELETE FROM news WHERE ID="& delid""
			set rs=conn.execute(sql)
		
		end if

		
		sql="SELECT * FROM news ORDER BY tid DESC"
		set rs=conn.execute(sql)
		
		do until rs.eof
			response.write "<hr align=left width=300 size=2 color=black noshading>"
			response.write rs("TID") & " by " & rs("POSTER") & ". ID: " & rs("ID")
			rs.moveNext
		loop
		%>

I get this friggin error all the time!! i know the answer is that i am missing a "end if" statement but i aint!! Please fast help is appreciated!

r937 · #5 (**permalink**) 09-26-04, 15:30

i don't code in that particular scripting language, but it sure looks like you are trying to delete based on an id that isn't there

if request("delid") = ""
then
delid=request("delid")
sql="DELETE FROM news WHERE ID="& delid""

krills · #6 (**permalink**) 09-26-04, 16:29

hmm sounds very reasonable now that you mention it=) ill try it tomorrow now i gotta go to bed

Internet Services

Web Development

Digital Marketing

Consumer Tech