|
|
|
|
 |
|
채영이 / 2001-11-30 / 오후 9:51:13 / 203.255.3.190
조회수 : 133
|
| [질문] 형식이 일치하지 않습니다: '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)
>
>
-----------------------------------------------------------
소스와 에러의 내용상으로 봤을때는
sql문의 결과가 제대로 나오지 않는게 아닐까..
또는 sql문이 제대로 만들어지지 않은게 아닌까 하는 생각이 들구요...
filename=filename(12)
filesize=filesize(13)
혹시나 이것 때문이지는 않을까요?
|
|
|
|