Code. Collaborate. Organize.
No Limits. Try it Today.
select distinct top 20 s.title,s.Short_Description,s.primary_keyword,p.cat_id,s.art_id from tbl_summary s inner join tbl_publishinfo as p on p.art_id =s.art_id where s.art_id in(select pi.art_id from tbl_publishinfo pi group by pi.art_id having(count(pi.art_id)=1)) and s.title like'%" & txttext & "%' order by s.art_id desc"
dim str as string
str= select * from tablename where column name='"&textboxName&"'
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)