|
|
|
|
 |
|
food / 2000-12-14 / 오후 3:05:40 / 210.219.185.189
조회수 : 122
|
| [질문] 에러구문인데 어떻게 처리해야 될지6 |
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'like'.
/members/search_result.asp, line 16
<%
search = request("search")
SearchString =request("SearchString")
Set db = Server.CreateObject("ADODB.Connection")
db.Open ("DSN=sql;UID=sa;PWD=")
if search = "fallname" then
SQL = "SELECT * FROM home where fallname like '%" & SearchString & "%' "
SQL = SQL & " ORDER BY num DESC"
elseif search = "id" then
SQL = "SELECT * FROM home where id like '%" & SearchString & "%' "
SQL = SQL & " ORDER BY id DESC"
end if
SQL = "SELECT * FROM home where " & search & " like '%" & SearchString & "%' "
SQL = SQL & " ORDER BY id DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQL,db,3
%>
|
|
|
