|
|
|
|
 |
|
복이 / 2001-02-01 / 오후 5:49:02 / 211.194.105.97
조회수 : 147
|
| [질문] 채영님 부탁드립니다 꼭....< |
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
부탁드립니다..
|
|
|
|