Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

accessÖеÄÀàÐÍת»»º¯Êý

ÿ¸öº¯Êý¶¼¿ÉÒÔ½«±í´ïʽ £¨±í´ïʽ£ºËãÊõ»òÂß¼­ÔËËã·û¡¢³£Êý¡¢º¯ÊýºÍ×Ö¶ÎÃû³Æ¡¢¿Ø¼þºÍÊôÐÔµÄÈÎÒâ×éºÏ£¬¼ÆËã½á¹ûΪµ¥¸öÖµ¡£±í´ïʽ¿ÉÖ´ÐмÆËã¡¢²Ù×÷×Ö·û»ò²âÊÔÊý¾Ý¡££©Ç¿ÖÆ×ª»»ÎªÌض¨µÄÊý¾ÝÀàÐÍ £¨Êý¾ÝÀàÐÍ£º¾ö¶¨×ֶοÉÓµÓеÄÊý¾ÝÀàÐ͵Ä×Ö¶ÎÌØÕ÷¡£Êý¾ÝÀàÐͰüÀ¨ Boolean¡¢Integer¡¢Long¡¢Currency¡¢Single¡¢Double¡¢Date¡¢String ºÍ Variant£¨Ä¬ÈÏ£©¡££©¡£
Óï·¨
CBool(expression)
CByte(expression)
CCur(expression)
CDate(expression)
CDbl(expression)
CDec(expression)
CInt(expression)
CLng(expression)
CSng(expression)
CStr(expression)
CVar(expression)
±ØÑ¡µÄ expression ²ÎÊý £¨²ÎÊý£ºÎª²Ù×÷¡¢Ê¼þ¡¢·½·¨¡¢ÊôÐÔ¡¢º¯Êý»ò¹ý³ÌÌṩÐÅÏ¢µÄÖµ¡££©ÊÇÈκÎ×Ö·û´®±í´ïʽ £¨×Ö·û´®±í´ïʽ£ºÈÎÒ»ÇóֵΪһÁÐÁ¬Ðø×Ö·ûµÄ±í´ïʽ¡£±í´ïʽµÄÔªËØ¿ÉÒÔÊÇ£º·µ»Ø×Ö·û´®»ò×Ö·û´® Variant (VarType 8) µÄº¯Êý£»×Ö·û´®×ÖÃæÖµ¡¢³£Á¿¡¢±äÁ¿»ò Variant¡££©»òÊýÖµ±í´ïʽ £¨ÊýÖµ±í´ïʽ£º¼ÆËã½á¹ûΪÊý×ÖµÄÈκαí´ïʽ¡£±í´ïʽ¿ÉÒÔÊDZäÁ¿¡¢³£Êý¡¢º¯ÊýºÍÔËËã·ûµÄÈÎÒâ×éºÏ¡££©¡£
·µ»ØÀàÐÍ
º¯ÊýÃû³Æ¾ö¶¨·µ»ØÀàÐÍ£¬ÈçÏÂËùʾ£º
º¯Êý·µ»ØÀàÐÍexpression ²ÎÊýµÄ·¶Î§
CBool
Boolean
ÈκÎÓÐЧµÄ×Ö·û´®»òÊýÖµ±í´ïʽ¡£
CByte
Byte
0 µ½ 255¡£
CCur
Currency
-922,337,203,685,477.5808 µ½ 922,337,203,685,477.5807¡£
CDate
Date
ÈκÎÓÐЧµÄÈÕÆÚ±í´ïʽ¡£
CDbl
Double
¶ÔÓÚ¸ºÖµ£¬-1.79769313486231E308 µ½
-4.94065645841247E-324£»¶ÔÓÚÕýÖµ£¬4.94065645841247E-324 µ½ 1.79769313486232E308¡£
CDec
Decimal
¶ÔÓÚÕûÊý£¨¼´Ã»ÓÐСÊýµÄÊý×Ö£©£¬+/-79,228,162,514,264,337,593,543,950,335¡£¶ÔÓÚ¾ßÓÐ 28 λСÊýµÄÊý×Ö£¬ÖµÓò·¶Î§ÊÇ
+/-7.9228162514264337593543950335¡£¿ÉÄܵÄ×îС·ÇÁãÊý×ÖΪ 0.0000000000000000000000000001¡£
CInt
Integer
-32,768 µ½ 32,767£»Ð¡Êý²¿·Ö±»ËÄÉáÎåÈë¡£
CLng
Long
-2,147,483,648 µ½ 2,147,483,647£»Ð¡Êý²¿·Ö±»ËÄÉáÎåÈë¡£
CSng
Single
¶ÔÓÚ¸ºÖµ£¬-3.402823E38 µ½ -1.401298E-45£»¶ÔÓÚÕýÖµ£¬1.401298E-45 µ½ 3.402823E38¡£
CStr
String
CStr µÄ·µ»ØÖµÈ¡¾öÓÚ expression ²ÎÊý¡£
CVar
Variant
¶ÔÓÚÊý×Ö£¬ÓëË«¾«¶ÈÐ͵ÄÖµÓò·¶Î§Ïàͬ¡£¶ÔÓÚ·ÇÊý×ÖÖµ£¬Óë String µÄÖµÓò·¶Î§Ïàͬ¡£
×¢½â
Èç¹û´«µÝ¸ø¸Ãº¯ÊýµÄ expression λÓÚҪת»»ÎªµÄÄ¿±êÊý¾ÝÀàÐ͵ÄÖµÓò·¶Î§Ö®Í⣬Ôò½«·¢Éú´


Ïà¹ØÎĵµ£º

²É·Ã·Ö²¼Ê½Êý¾Ý·ÃÎʲã(Data Access Layer)

·Ö²¼Ê½(Distributed)Êý¾Ý·ÃÎʲã(Data Access Layer)(ÒÔϼò³ÆDAL)ÊÇ×ÛºÏMySQL Proxy¡¢Memcached¡¢¼¯ÈºµÈµÈ¼¼ÊõÓÅµã¶ø¹¹½¨µÄÒ»¸öÈí¼þϵͳ¡£Ä¿µÄÊÇΪÁ˽â¾öÔÚ¹¹½¨´óÖÐÐÍÍøÕ¾Ê±Óöµ½µÄºÍÊý¾Ý·ÃÎÊÓйصÄÖî¶àÎÊÌ⣬ÈçÔõôʹµÃÇпâ·Ö±í͸Ã÷»¯£¬ÈçºÎʹµÃ»º´æ´æÈ¡Çå³ý×Ô¶¯»¯£¬ÔõÑù²ÅÄܸüºÃµØ·ÀÖ¹·þÎñµ¥µã¹ÊÕÏµÈµÈ ......

Web Server Access on a VirtualBox Guest


Web Server Access on a VirtualBox Guest
In: Computing ÊýÂë±à³Ì
7
Oct
2008
I been using VirtualBox to deploy virtual machines on my Windows
machine since a significant memory upgrade. VirtualBox is suprisingly
easy to used if compared to VMWare and it just fit to my basic needs.
Access the ......

using OPENDATASOURCE Select Access Data Base data

ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
'Jet OLEDB:Database Password=; /*Access ÃÜÂë*/
Data Source=C:\temp\Test.mdb; /*Access Êý¾Ý¿â·¾¶*/
Password=;/*Access¹¤×÷×éÃÜÂë*/
1. ²éѯAccess ±íÄÚËùÓÐÊý¾Ý
SELECT *
from OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0',
'Jet OLEDB:Database ......

½â¾öasp utf 8 accessÖÐÎÄÂÒÂëÒ»Àý

 ÎļþÍ·ÓÃÁË
<%@Language="VBScript" CodePage="65001"%>
Îļþ±¾ÉíÒѾ­ÊÇUtf-8µÄ±àÂëÁË
Ìá½»¹ýµ½Access¿âÖÐÔõô¶¼ÊÇ “&#20135;&#21697;&#20171;&#32461 ”ÕâÑùµÄ±àÂë
Ò»²½²½·ÖÎö£¬²»´æ¿âÖ±½ÓÊä³ö£¬Ò²ÊÇÕâÑùµÄ±àÂë¡£ÏëÀ´¸úAccessÎÞ¹ØÁË¡£
ÏàÓÚÃԻ󣬺óÀ´ÖØÐ½¨Ò»¸ö±íµ¥Ôª£¬Ìá½» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ