Question1.
Exec ('Declare abc CURSOR GLOBAL FOR SELECT * from table1 ')
open abc
.....
游標abc是全蚼的。Question2.解決方法很多。最簡單的方法就是用動態sqlexec ('select * from table1 where fld1 in ('+@values+')')假若fld1是字符型,則需特別處理一下。
Exec ('Declare abc CURSOR GLOBAL FOR SELECT * from table1 ')
open abc
.....
游標abc是全蚼的。Question2.解決方法很多。最簡單的方法就是用動態sqlexec ('select * from table1 where fld1 in ('+@values+')')假若fld1是字符型,則需特別處理一下。
set @value='''A1'',''A2'''
為什么要這么多'呢﹖﹖
<script language=Vbscript>
dim str
</script>
<input id=H1 value = "<%= server.htmlencode(Thestring ) %>" type=hidden onload='str=split(H1.value,"%%%")'>俺可卑鄙了