|
|
|
|
¿ì¿¬ / 2001-11-30 / ¿ÀÈÄ 7:50:55 / 211.245.244.179
Á¶È¸¼ö : 138
|
[Áú¹®] Çü½ÄÀÌ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù: 'rsman'6 |
if sort1="111" then
sqlman="Select couplet_num1, couplet_num2, content_num, record_date, couplet_title, hname,
place, summary, center, conclusion, announcement, issue, filename, filesize, writeday, branch"
sqlman=sqlman&" From test where sort1='"&sort1&"' and sort2='"&sort2&"' and
couplet_num1='"&couplet_num1&"'"
Set rsman=server.createobject("adodb.recordset")
rsman.open sqlman,dbcon,1
elseif sort1="222" then
sqlman="Select couplet_num1, couplet_num2, content_num, record_date, couplet_title, hname,
place, summary, center, conclusion, announcement, issue, filename, filesize, writeday, branch"
sqlman=sqlman&" From test where sort1='"&sort1&"' and sort2='"&sort2&"' and
couplet_num2='"&couplet_num2&"'"
Set rsman=server.createobject("adodb.recordset")
rsman.open sqlman,dbcon,1
end if
couplet_num1=rsman(0) <=== ¿¡·¯¶óÀÎ
couplet_num2=rsman(1)
content_num=rsman(2)
record_date=rsman(3)
couplet_title=rsman(4)
hname=rsman(5)
place=rsman(6)
summary=rsman(7)
center=rsman(8)
conclusion=rsman(9)
announcement=rsman(10)
issue=rsman(11)
filename=filename(12)
filesize=filesize(13)
writeday=rsman(14)
branch=rsman(15)
|
|
|
|