发布于 2010-11-25 12:07:40
1楼
全部C脚本如下,供各位参考,望就该问题给予回复,不胜感激!
extern __object *sqlrec1,*sqllist1;
char *text;
text = GetTagChar("danhao");
sqlrec1=__object_create("ADODB.Connection");
sqlrec1->Open("DSN=youku");
if (sqlrec1->State==0)
{
printf("Connection failed.\r\n");
sqlrec1->Open("DSN=sqlinterface;uid=sa;pwd=sa;");
sqlrec1->Open("DSN=youku");
}
sqllist1=__object_create("ADODB.RecordSet");
sqllist1->CursorLocation=3;
//cheng gong//sqllist1->Open("SELECT * FROM TYD WHERE [YKFYDBH] = 234567 ",sqlrec1,1,3);
sqllist1->Open("SELECT * FROM TYD WHERE [YKFYDBH] = text ",sqlrec1,1,3);
SetTagChar("danweidaima",sqllist1->Fields("HWMC")->Value);
//sqllist1->Open("SELECT * FROM HWFYD ",sqlrec1,1,3);
__object_delete(sqllist1);
在奋斗中崛起,在拼搏中享乐,我要做一个自强不息的人!