strsql="select * from life_pds where big='%"&search&"%' or big_category='%"&searchstring&"%' or mid_category='%"&searchstring&"%' or filename='%"&searchstring&"%' or content like '%"&searchstring&"%' order by pk_id desc"
select 구문을 이렇게 처리했는데..
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Informix][Informix ODBC Driver][Informix]Wildcard matching may not be used with non-character types.
/sm_pds_search.asp, line 69
이런 오류가 나네요.. 위의 select는 mssql문을 그대로.인포믹스서버에...
올린 예입니다..
빠른 답변부탁합니다.
|