|
|
|
|
 |
|
채영이 / 2000-12-14 / 오후 4:20:46 / 203.255.3.190
조회수 : 128
|
| [질문] 에러구문인데 어떻게 처리해야 될지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
> %>
>
>
-----------------------------------------------------------
search나 SearchString에 올바른 값이 넘어오는지 체크해 보세요~~ ^^
그럼...
|
|
|
|