|
|
|
|
 |
|
채영이 / 2001-02-01 / 오후 7:16:01 / 203.255.3.190
조회수 : 138
|
| [질문] 채영님 부탁드립니다 꼭....< |
>
>
> sql = " Select a.title2 FROM adver as a "
> sql = sql & " WHERE a.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select b.title2 FROM dongho as b "
> sql = sql & " WHERE b.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select c.title2 FROM dongho2 as c "
> sql = sql & " WHERE c.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select d.title2 FROM dongho3 as d "
> sql = sql & " WHERE d.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select e.title2 FROM dongho4 as e "
> sql = sql & " WHERE e.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select f.title2 FROM event as f "
> sql = sql & " WHERE f.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select g.title2 FROM fashion as g "
> sql = sql & " WHERE g.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select h.title2 FROM food as h "
> sql = sql & " WHERE h.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select i.title2 FROM life as i "
> sql = sql & " WHERE i.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select j.title2 FROM news as j "
> sql = sql & " WHERE j.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select k.title2 FROM piccounseling as k "
> sql = sql & " WHERE k.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select l.title2 FROM picculture as l "
> sql = sql & " WHERE l.title2 like '%" & keyword & "%' "
> sql = sql & "Union all"
>
> sql = sql & "Select m.title2 FROM 공지사항 as m "
> sql = sql & " WHERE m.title2 like '%" & keyword & "%' "
>
> Set rs1 = DbCon.Execute(sql) ==>에러라인...
>
> 이렇게 했는데요... 에러가 나서요...
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'allSelect'.
>
> /search1.asp, line 65
>
> 부탁드립니다..
>
>
-----------------------------------------------------------
all 하고 Select 사이에 공백이 없어서 그런것 같은데요...
|
|
|
|