求ASP调用ACCESS查询代码!困扰很久了
求ASP调用ACCESS查询代码!
在ACCESS中有个查询功能,
如何在ASP页面中调用如追加查询、删除查询等呢?
在百度、GOOGLE查了很久,
但都没有得到解决?
还望高手指点!
ACCESS图片如下:
http://www.abcde.com.cn/web/admin/help_access_search.jpg
ACCESS代码如下:
UPDATE News SET Cat_ID = [@Cat_ID], News_Title = [@News_Title], News_Author = [@News_Author], News_From = [@News_From], News_KeyWord = [@News_KeyWord], News_Content = [@News_Content], News_Date = now(), News_State = [@News_State]
WHERE News_ID=[@News_ID];
******************************************************************************
DELETE *
FROM News
WHERE News_ID=[@News_ID];
******************************************************************************
INSERT INTO News ( Cat_ID, News_Title, News_Author, News_From, News_KeyWord, News_Content, News_State )
VALUES ([@Cat_ID], [@News_Title], [@News_Author], [@News_From], [@News_KeyWord], [@News_Content], [@News_State]);
******************************************************************************
SELECT [Cat_Name]
FROM News_Cat
WHERE Cat_ID=[@Cat_ID];