아래는 설문자 정보이고요
select seq, job, info1,info2~~ from
tablename_info where
job='1'
아래는 설문자가 답변한 정보입니다.
select qno,ano1,ano2,ano3,amemo from tablename_qna where fk_job='1' and
fk_seq='seq' order
by qno
설문자정보 옆에 답변한정보가 있어야하거든요..tablename_qna 을 seq값있는것에 for문을 돌려
디비를 산출해야하는데욤....
_________________________________________
설문자정보 | 문제번호1 | 문제번호2 | 문제번호3 | ~~ | 문제번호25
| 기타의견
-----------------------------------------
seq | qno=>ano1,ano2,ano3 |~~~~
|amemo
1215 | 01=>5,2,3 |
02=>2,3,4
1216 | 01=>5,4,3 |
02=>1,2,3
이런식으로 나와야하거든요...
asp프로시져만 봐서 infomix 디비는 어찌해야하는지...
######################################################
CREATE PROCEDURE evnet_ans (src CHAR(2))
@jobcode
//
select seq,job from event_answer_info where job=@jobcode
@seq = seq
select count(seq) as temp from tablename_info where job=@jobcode
@temp = temp
for($i=0; $i<$temp; $i++) {
select qno,ano1,ano2,ano3,amemo from tablename_qna where fk_job=@jobcode and
fk_seq='@seq'
order by qno
$rows=ifx_fetch_row($result,"NEXT")
}
RETURN
END PROCEDURE;
######################################################
많은 조언부탁드립니다.
|