|
|
|
|
 |
|
채영이 / 2000-11-16 / 오후 10:11:11 / 203.255.3.190
조회수 : 127
|
| [질문] 이런 에러가 ...
|
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
>
> /mytest/qa/del_ok.asp, line 16
>
>
> <%
>
> Set db = Server.CreateObject("ADODB.Connection")
> db.Open("DSN=sql;UID=sa;PWD=;")
>
> SQL = "select pwd from Board_Re where board_idx = " & request("idx")
>
> set result = db.execute(SQL)
>
>
> if request("pwd") = result("pwd") then
>
> SQL = "Delete * from Board_Re "
> SQL = SQL & " where board_idx = " & request("idx")
>
> db.execute SQL
>
> Response.Redirect "list.asp"
>
> else
> %>
>
>
> <% end if%>
>
>
-----------------------------------------------------------
DELETE에는 * 표가 오지 않습니다.
그냥 DELETE FROM ~~~ 이렇게 사용합니다...
그럼...
|
|
|
