소스를 아래와 같이 했는데...column값이 잘 안 찍히네요...
===================================================================
dbcmd (dbproc, (char *)"select top 1");
dbcmd (dbproc, (char *)" b.cc_si_isn,");
dbcmd (dbproc, (char *)" b.cc_si_title, b.cc_si_iymd, ");
dbcmd (dbproc, (char *)" b.cc_si_writer, b.cc_si_keyword, a.catecode");
dbcmd (dbproc, (char *)", b.cc_si_contnt");
dbcmd (dbproc, (char *)" from cr_kinds_siga_v b, siga.dyano_pfresult a");
dbsqlexec (dbproc);
if (dbresults(dbproc) == SUCCEED)
{
dbbind (dbproc, 1, INTBIND, 0, (BYTE *)&isn);
dbbind (dbproc, 2, NTBSTRINGBIND, 0, (char *)title);
dbbind (dbproc, 3, NTBSTRINGBIND, 0, (char *)iymd);
dbbind (dbproc, 4, NTBSTRINGBIND, 0, (char *)writer);
dbbind (dbproc, 5, NTBSTRINGBIND, 0, (char *)keyword);
dbbind (dbproc, 6, NTBSTRINGBIND, 0, (char *)catecode);
dbbind (dbproc, 7, NTBSTRINGBIND, 0, (char *)contnt);
while (dbnextrow(dbproc) != NO_MORE_ROWS)
{
printf("isn : %d\n", isn);
printf("title : %s\n", title);
printf("iymd : %s\n", iymd);
}
}
================================================================
첫번째 column만 bind해서 찍으면 그 값이 잘 나오는데
여러 column을 같이 bind하니까 값이 제대로 안 나오는군요...
도움 부탁드립니다.
|