'==================================================================返回字段类型列表
Function fieldtypelist(n)
dim strlist,str1,str2
strlist = "<select name=""field_type"">"
if session("dbtype") = "access" then
strlist = strlist & "<option value=""VarChar"">文本</option>"
strlist = strlist & "<option value=""Text"">备注</option>"
strlist = strlist & "<option value=""Bit"">(是/否)</option>"
strlist = strlist & "<option value=""TinyInt"">数字(字节)</option>"
strlist = strlist & "<option value=""SmallInt"">数字(整型)</option>"
strlist = strlist & "<option value=""Integer"">数字(长整型)</option>"
strlist = strlist & "<option value=""Single"">数字(单精度)</option>"
strlist = strlist & "<option value=""Double"">数字(双精度)</option>"
strlist = strlist & "<option value=""Numeric"">数字(小数)</option>"
strlist = strlist & "<option value=""GUID"">数字(同步ID)</option>"
strlist = strlist & "<option value=""DateTime"">时间/日期</option>"
strlist = strlist & "<option value=""Money"">货币</option>"
strlist = strlist & "<option value=""Binary"">二进制</option>"
strlist = strlist & "<option value=""LongBinary"">长二进制</option>"
strlist = strlist & "<option value=""LongBinary"">OLE 对象</option>"
else
strlist = strlist & "<option value="""">选择类型</option>"
strlist = strlist & "<option value=""BigInt"">bigint</option>"
strlist = strlist & "<option value=""Binary"">binary(二进制数据类型)</option>"
strlist = strlist & "<option value=""Bit"">bit(整型)</option>"
strlist = strlist & "<option value=""Char"">char(字符型)</option>"
strlist = strlist & "<option value=""DateTime"">datetime(日期时间型)</option>"
strlist = strlist & "<option value=""Decimal"">decimal(精确数值型)</option>"
strlist = strlist & "<option value=""Float"">float(近似数值型)</option>"
strlist = strlist & "<option value=""Image"">image(二进制数据类型)</option>"
strlist = strlist & "<option value=""Int"">int(整型)</option>"
strlist = strlist & "<option value=""Money"">money(货币型)</option>"
strlist = strlist & "<option value=""nchar"">nchar(统一编码字符型)</option>"
strlist = strlist & "<option value=""ntext"">ntext(统一编码字符型)</option>"
strlist = strlist & "<option value=""numeric"">numeric(精确数值型)</option>"
strlist = strlist & "<option value=""nvarchar"">nvarchar(统一编码字符型)</option>"
strlist = strlist & "<option value=""real"">real(近似数值型)</option>"
strlist = strlist & "<option value=""smalldatetime"">Smalldatetime(日期时间型)</option>"
strlist = strlist & "<option value=""smallint"">smallint(整型)</option>"
strlist = strlist & "<option value=""smallmoney"">smallmoney(货币型)</option>"
strlist = strlist & "<option value=""sql_variant"">sql_variant()</option>"
strlist = strlist & "<option value=""text"">text(字符型)</option>"
strlist = strlist & "<option value=""timestamp"">timestamp(特殊数据型)</option>"
strlist = strlist & "<option value=""tinyint"">tinyint(整型)</option>"
strlist = strlist & "<option value=""uniqueidentifier"">Uniqueidentifier(特殊数据型)</option>"
strlist = strlist & "<option value=""varbinary"">varbinary(二进制数据类型)</option>"
strlist = strlist & "<option value=""varchar"">varchar(字符型)</option>"
end if
str1 = """" & n & """"
str2 = """" & n & """" & " selected"
strlist = replace(strlist,str1,str2)
strlist = strlist & "</select>"
echo strlist
End Function
