ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý·j´M¸ê®Æ®w©Ò¦³Äæ¦ì¦³²Å¦X±ø¥óªº¸ê®Æ

[µo°Ý] ½Ð°Ý·j´M¸ê®Æ®w©Ò¦³Äæ¦ì¦³²Å¦X±ø¥óªº¸ê®Æ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-20 16:57 ½s¿è

Dim ±ø¥ó As String
Dim MYCON As ADODB.Connection
Dim MYRS As ADODB.Recordset
Set MYCON = New ADODB.Connection
MYCON.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ¸ê®Æ®w
Set MYRS = New ADODB.Recordset

    With MYRS
        .Source = "SELECT ½s¸¹,¦WºÙ,¹q¸Ü,¶Ç¯u FROM «È¤á¸ê®Æ WHERE ¹q¸Ü LIKE '%123%'"
        .ActiveConnection = MYCON          '«ü©w©Ò¨Ï¥ÎªºConnectionª«¥ó
        .Open
    End With

¥H¤Wµ{¦¡¥u¯à§ä¥X«È¤á¸ê®Æ¤º¹q¸ÜÄæ¦ì¤º¦³123ªº¸ê®Æ

¦Ó§Ú·Q(½s¸¹,¦WºÙ,¹q¸Ü,¶Ç¯u)³£­n·j´M§t¦³123ªº¸ê®Æ
½Ð°Ý­n¤À4¦¸·j´M¶Ü?
ÁÙ¬O¥i¥H¤@¦¸·j´M?

½Ð°Ý¤À4¦¸·j´M¤ñ¸û§ÖÁÙ¬O¤@¦¸·j´M
ÁÂÁÂ:)

«õ¾a... ³o¶WÃøºâªº...
§Ú«Øijª½±µ¶] ­pºâ®É¶¡¤ñ¸û§Ö... ¤£µMºâ¨ì°²¦º(¾ÇÃÀ¤£ºëªº»¡ªk)
WHERE ½s¸¹ LIKE '%123%' or ¦WºÙ LIKE '%123%' or ¹q¸Ü LIKE '%123%' or ¶Ç¯u LIKE '%123%'

¯uªº­nºâªº¸Ü ¥²¶·¥ýºâ¥X©¹ªðDBªº®É¶¡
¨Ì¾ÚTable ªºkeyºâ...
¹ê»Ú¤W §Ú¤]¥uºâ¹L¤@¨â¦¸ ¬O¦b¾Ç®Õºâªº...
¦b¤½¥q¤W§Úªº¨Ï¥ÎBD¤u¨ã­n¥Lºâµ¹§Ú>"<
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

·PÁ Min ª©¥D
³o¥¿¬O§Ú»Ý­nªº
·j´M³t«×¤]«Ü§Ö
·P®¦

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD