©_ª°ªÀ°Ï½×¾Â
¦b³o­Ó­¶­±Åã¥Ü¥»¥DÃD¥þ³¡ªº 6 ­Ó¤å³¹

©_ª°ªÀ°Ï½×¾Â (http://www.chiefox.com.tw/bbs/index.php)
- °ÝÃD¥æ¬y (http://www.chiefox.com.tw/bbs/forumdisplay.php?forumid=28)
-- ¦b¥D¹Ï°Ï (http://www.chiefox.com.tw/bbs/showthread.php?threadid=17313)


¥Ñ N122562663 ¦b 2012-12-05 06:30 µoªí:

¦b¥D¹Ï°Ï

Á`ª©¥D±z¦n¡G
Åã¥Ü¸Ñ½L¤å¦r(1,'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(,0)+'¤å¦r');
¦b¤W¦C¤è¦¡¡B¦b¥D¹Ï°Ï¡B¬O§_¤]¥i¨Ï¥Î¡B¨Ò¤U¦C¡B¤TºØ¡B¥i§_¥þ¥Î¸Ñ½L°Ï¤§¤è¨Óªí¹F¡B¦p¥i¥H½Ð¤ä´©¡C¥t½Ð±ÐÁ`ª©¥D¡B¦p§ï¤U¦C¤T©Î¥|¦X¤@¨Óªí¹F¡B·|¼W¥[©Î´î¤Ö¹q¸£ªº­t¾á¡BÁÂÁ±z¡C

1.¤å¦r¡B¼Æ­È¡B¤å¦r
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;

2.µe¬W½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r
µe¬W½u(,,,7,0),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;

3.µe¤À¬q½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r
µe¤À¬q½u(,),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;


¥Ñ cgjj ¦b 2012-12-05 10:46 µoªí:

¦^ÂÐ: ¦b¥D¹Ï°Ï

¤Þ¥Î:
³Ìªì¥Ñ N122562663 µoªí
Á`ª©¥D±z¦n¡G
Åã¥Ü¸Ñ½L¤å¦r(1,'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(,0)+'¤å¦r');
¦b¤W¦C¤è¦¡¡B¦b¥D¹Ï°Ï¡B¬O§_¤]¥i¨Ï¥Î¡B¨Ò¤U¦C¡B¤TºØ¡B¥i§_¥þ¥Î¸Ñ½L°Ï¤§¤è¨Óªí¹F¡B¦p¥i¥H½Ð¤ä´©¡C¥t½Ð±ÐÁ`ª©¥D¡B¦p§ï¤U¦C¤T©Î¥|¦X¤@¨Óªí¹F¡B·|¼W¥[©Î´î¤Ö¹q¸£ªº­t¾á¡BÁÂÁ±z¡C

1.¤å¦r¡B¼Æ­È¡B¤å¦r
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;

2.µe¬W½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r
µe¬W½u(,,,7,0),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;

3.µe¤À¬q½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r
µe¤À¬q½u(,),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á ,,,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á ,,'¤å¦r'),;



'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(,0)+'¤å¦r'
³o­Ó²Õ¦Xªºµ²ªG¤´¬O¤å¦r

¥u­nµ²ªG¬O¤å¦r
³£¥i¥h¹B¥Î DRAWTEXT ©M EXPLAIN ¨ç¼Æ


¥Ñ N122562663 ¦b 2012-12-05 11:32 µoªí:

¤å¦r¡B¼Æ­È¡B¤å¦r

Á`ª©¥D±z¦n¡G§Æ±æ¡BÅã¥Üªº¬O¡B¤U¦C¤TºØ¼Ò¦¡¡B½Ð¤½¦¡¤ä´©¡B·P®¦¦³±z

1.¤å¦r¡B¼Æ­È¡B¤å¦r

2.µe¬W½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r

3.µe¤À¬q½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r


¥Ñ cgjj ¦b 2012-12-05 17:03 µoªí:

¦^ÂÐ: ¤å¦r¡B¼Æ­È¡B¤å¦r

¤Þ¥Î:
³Ìªì¥Ñ N122562663 µoªí
Á`ª©¥D±z¦n¡G§Æ±æ¡BÅã¥Üªº¬O¡B¤U¦C¤TºØ¼Ò¦¡¡B½Ð¤½¦¡¤ä´©¡B·P®¦¦³±z

1.¤å¦r¡B¼Æ­È¡B¤å¦r

2.µe¬W½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r

3.µe¤À¬q½u¡B¤å¦r¡B¼Æ­È¡B¤å¦r



¤å¦r¡B¼Æ­È¡B¤å¦r

±N¨ä¥Î¥H¤U¤è¦¡³B²z«á
'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(,0)+'¤å¦r'

¾ã­Óµ²ªG´N¬O¤å¦r, ª½±µ±a¤J´N¥i, ¨Ò¦p:
EXPLAIN(1, '¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(,0)+'¤å¦r');

µe¬W½u, µe¤À¬q½u
»P¤å¦rµL¥ô¦óÃö«Y, ±zµ¹¥¦¤°»ò¼Æ, ¥¦´Nµe¤°»ò

­Y¤£¼ô±x¨ç¼Æ, ½Ð¥ý¥J²Ó¬Ý»¡©ú:
¥i¥H¥ý¥t¼g­Ó¤p¤½¦¡, ¥h´ú¸Õ¨ç¼Æ¥Îªk
·|¤F¤§«á¦A¥h²Õ¦X¥[¤J­ì¤½¦¡¤§¤¤


¥Ñ N122562663 ¦b 2012-12-05 21:10 µoªí:

(µe¬W½u¡B¤å¦r'¡B¼Æ¦r¡B¤å¦r'),;

Á`ª©¥D±z¦n¡G¸g¤G¤p®É®M¥Î¯àµLªk¸Ñ¨M¡B¬A©·µLªk°t¹ï¡B
µe¬W½u(À£¤O1,'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(À£¤O1,7,0)+'¤å¦r');
°ÝÃD¥¼¸ÑƒK«e¡B§Ú¬O¥Î¤U¦C¥|­ÓÅã¥Ü¤è¦¡¡B
µe¬W½u(À£¤O1,À£¤O1,À£¤O1,7,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,À£¤O1,0),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,'¤å¦r'),;
«÷´ê¦¨¡B(µe¬W½u¡B¤å¦r'¡B¼Æ¦r¡B¤å¦r'),;
ÁÙ¬O·Ð½ÐÁ`ª©¥D¡B¤½¦¡¤ä´©§a¡B·PÁ±z¡C


¥Ñ cgjj ¦b 2012-12-06 10:04 µoªí:

¦^ÂÐ: (µe¬W½u¡B¤å¦r'¡B¼Æ¦r¡B¤å¦r'),;

¤Þ¥Î:
³Ìªì¥Ñ N122562663 µoªí
Á`ª©¥D±z¦n¡G¸g¤G¤p®É®M¥Î¯àµLªk¸Ñ¨M¡B¬A©·µLªk°t¹ï¡B
µe¬W½u(À£¤O1,'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(À£¤O1,7,0)+'¤å¦r');
°ÝÃD¥¼¸ÑƒK«e¡B§Ú¬O¥Î¤U¦C¥|­ÓÅã¥Ü¤è¦¡¡B
µe¬W½u(À£¤O1,À£¤O1,À£¤O1,7,0);
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,'¤å¦r'),;
Åã¥Ü¼Æ¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,À£¤O1,0),;
Åã¥Ü¤å¦r(¬O§_³Ì«á¶g´Á AND À£¤O1,À£¤O1,'¤å¦r'),;
«÷´ê¦¨¡B(µe¬W½u¡B¤å¦r'¡B¼Æ¦r¡B¤å¦r'),;
ÁÙ¬O·Ð½ÐÁ`ª©¥D¡B¤½¦¡¤ä´©§a¡B·PÁ±z¡C



°ÝÃD·íµMµLªk¸Ñ¨M

µe¬W½u ¨ç¼Æ¬O STICKLINE ¨ä¦@¦³¤­­Ó°Ñ¼Æ
STICKLINE(COND,PRICE1,PRICE2,WIDTH,EMPTY)

±z¼gªº¦¡¤l:
µe¬W½u(À£¤O1,'¤å¦r '+¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(À£¤O1,7,0)+'¤å¦r');
¥uµ¹¥¦¨â­Ó°Ñ¼Æ
¥B²Ä¤G­Ó°Ñ¼Æ¨Ã«D¼Æ­È, ¨t²Î·íµM¬OµLªk±µ¨ü

¼Æ¦rÂà¤Æ¬°¦r²Å¦ê ¨ç¼Æ¬O NUMTOSTR ¨ä¶È¦³¨â­Ó°Ñ¼Æ
NUMTOSTR(N,M)

±z¼gªº¦¡¤l:
¼Æ¦rÂà¤Æ¬°¦r²Å¦ê(À£¤O1,7,0)
¦@µ¹¤F¤T­Ó°Ñ¼Æ, ¦h¥X¤F¤@­Ó, ¨t²Î·íµM¬OµLªk±µ¨ü

µe¬W½u¬O¥Î¨Ó "µe¬W½u" ¥¦¨ÃµLÅã¥Ü¤å¦rªº¥\¯à

±z­nµe¬W½u¤S­nÅã¥Ü¤å¦r, »Ý­n¦U¥Î¤@²Õ¨ç¼Æ¨Ó³B²z

¨ç¼Æ¦p¦ó¥Î, ¤º«Øªº»¡©ú°È¥²­n¬Ý
­Y¤£¤F¸Ñ¥i¥H¶]¶]»¡©ú¤¤ªº½d¨Ò

³o°ÝÃD§Ú¤£·|ª½±µµ¹±zµª®× ... ¦]¬°¹ï±z¾Ç²ß¨S¦³¯q³B
¦ý·|§i¶D±z°ÝÃD¦b¨º¸Ì, ¥Ñ±z¦Û¦æ¨Ó¸Ñ¨M


¥þ³¡®É¶¡§¡¬°¥xÆW®É¶¡, ²{¦b®É¶¡¬°03:22
¦b³o­Ó­¶­±Åã¥Ü¥»¥DÃD¥þ³¡ªº 6 ­Ó¤å³¹


Powered by: vBulletin Version 2.3.0 - Copyright©2000-, Jelsoft Enterprises Limited.

²·R¬v¦æ »s§@ Copyright 2003-. All Rights Reserved.