因为我用asp.net的DataList控件实现,所以需要这7个as出来的字段与DataList分别绑定
如下:
<%# DataBinder.Eval(Container.DataItem,"b.Type") %>
<%# DataBinder.Eval(Container.DataItem,"b.ImageUrl") %>
<%# DataBinder.Eval(Container.DataItem,"a.title1") %>
<%# DataBinder.Eval(Container.DataItem,"a.Content1") %>
<%# DataBinder.Eval(Container.DataItem,"a.title2") %>
<%# DataBinder.Eval(Container.DataItem,"a.title3") %>
<%# DataBinder.Eval(Container.DataItem,"a.title4") %>页面像这样:
--------------------------------------------------
table2.Type
--------------------------------------------------
| table1.Title1
|-----------------------------
| table1.Content1
table2.ImageUrl |
|
|
---------------------------------------------------
table1.Title2
---------------------------------------------------
table1.Title3
---------------------------------------------------
table1.Title4
---------------------------------------------------但怎么实现先不管,我现在只要用一SQL语句取出以上所说的7个元素
如下:
<%# DataBinder.Eval(Container.DataItem,"b.Type") %>
<%# DataBinder.Eval(Container.DataItem,"b.ImageUrl") %>
<%# DataBinder.Eval(Container.DataItem,"a.title1") %>
<%# DataBinder.Eval(Container.DataItem,"a.Content1") %>
<%# DataBinder.Eval(Container.DataItem,"a.title2") %>
<%# DataBinder.Eval(Container.DataItem,"a.title3") %>
<%# DataBinder.Eval(Container.DataItem,"a.title4") %>页面像这样:
--------------------------------------------------
table2.Type
--------------------------------------------------
| table1.Title1
|-----------------------------
| table1.Content1
table2.ImageUrl |
|
|
---------------------------------------------------
table1.Title2
---------------------------------------------------
table1.Title3
---------------------------------------------------
table1.Title4
---------------------------------------------------但怎么实现先不管,我现在只要用一SQL语句取出以上所说的7个元素
table2 就是b
-----------------------你知道在程序里调用oracle数据库函数怎么调么?或者提供关于这方面的资料我自己去看也行呀~~~
假如你是返回的游标,用recordset可以接受。暂时,我手头上没有资料。rank是oracle本身的一个函数。
我的另一个贴子说的详细点,如果你有时间的话,帮忙看看吧~~~~
SQL语句如下:假设newb是类型表,newa是新闻表
SELECT a.type,
a.imageurl,
f_gettitle(a.type,1) title1,
f_getlong(a.type,1) content1,
f_gettitle(a.type,2) title2,
f_gettitle(a.type,3) title3,
f_gettitle(a.type,4) title4
FROM newb a 写个函数来求取
create or replace function f_gettitle(stype in varchar2, sno in NUMBER) return VARCHAR2 is
Result varchar2(200);
BEGIN SELECT title
INTO RESULT
FROM
(
SELECT rownum sid,a.title
FROM newa a
WHERE a.type = stype
AND rownum <= sno
)
WHERE sid = sno;
return(Result);
end f_gettitle;//求取LONG字段值
create or replace function f_gettitle(stype in varchar2, sno in NUMBER) return VARCHAR2 is
Result long;
BEGIN SELECT title
INTO RESULT
FROM
(
SELECT rownum sid,a.content
FROM newa a
WHERE a.type = stype
AND rownum <= sno
)
WHERE sid = sno;
return(Result);
end f_gettitle;