Neil's Note

Dim objFSO,oInStream,sRows,arrRows Dim sFileName sFileName = "檔案路徑/test.csv" '*** Create Object ***' Set objFSO = CreateObject("Scripting.FileSystemObject") '*** 確認檔案是否存在 ***' If Not objFSO.FileExists(Server.MapPath(sFileName)) Then Response.write("File not found.") Else '*** 讀取檔案 ***' Set oInStream = objFSO.OpenTextFile(Server.MapPath(sFileName),1,False) Do Until oInStream.AtEndOfStream '重設Email_Item,Email_Item為所要出貨之商品名稱' Email_Item = "" sRows = oInStream.readLine arrRows = Split(sRows,",") '個別寫入配送紀錄表' delivery_num=arrRows(1);Shipped_type=arrRows(4);Shipped_Date=arrRows(2) Response.write "Oid 在開頭="&arrRows(0)&"<br/>" Response.write "Shipped_Date 在開頭="&arrRows(2)&"<br/>" Response.write "Shipped_type 在開頭="&arrRows(4)&"<br/...

要抓取資料一定需要Access token Facebook每個App都會有自己的Access token可用 可用Graph API或是在 Access Token Tool 中查詢自己App的Access token 要抓取粉絲頁所上傳的API為https://graph.facebook/粉絲頁ID/photos/uploaded

安裝Apache $ sudo apt-get install apache2 安裝MySQL $ sudo apt-get install mysql-server 安裝PHP $ sudo apt-get install php5 安裝MySQL for Apache HTTP Server $ sudo apt-get install libapache2-mod-auth-mysql $ sudo apt-get install php5-mysql 安裝phpmyadmin $ sudo apt-get install phpmyadmin 安裝後於網址列輸入http://你的IP/phpmyadmin 若出現Not found，可以先使用whereis phpmyadmin找出phpmyadmin位置 一般是會有/usr/share/phpmyadmin 接著進到/var/www(/html)內輸入ln -s /usr/share/phpmyadmin 應該就可以了 用ssh登入Ubuntu總是會等個幾秒 vi /etc/ssh/sshd_config 在最底下加入 UseDNS no 裝完vsftp後無法在/var/www內新增檔案 sudo chgrp www-data /var/www sudo chmod 775 /var/www sudo chmod g+s /var/www sudo useradd -G www-data 使用者帳號 --------------------------或是---------------------------------- There you will find the following line : # Uncomment this to enable any form of FTP write command. #write_enable=YES Uncomment this .. it will look like this. # Uncomment this to enable any form of FTP write command. write_enable=YES 裝完vsftpd...

Don't call setOnClickListener for an AdapterView . You probably want setOnItemClickListener instead http://stackoverflow.com/questions/3402255/setonclicklistener-of-a-listview-not-working Because the Android API is designed that way if it's assigned to an adapterView, it will throw an exception. Clicking on a listView would mean a click on the entire view, which is usually not very useful anyway, since you mostly want to know in your app which exact child view item (list item) has been clicked, not that the entire listview has been clicked.  

最近工作一直常碰到 結果因為大學怠惰都沒學,出來工作才後悔,狂幹譙以前的自己XD 來做個筆記 針對html 的 input 取得其輸入的值可以用                $(' #element id ').val(); 若是要針對某個包文字的element如span取值可用  $(' #element id ').text();                                                                   設值可用  $(' #element id ').text(' 要設定的值 ') //針對id = BigRng這個element內的多個select element,將他們被selected的option value透過each()的方式做相加 $(' #BigRng select > option:selected ').each( function () { var value = Number($( this ).val()); if (!isNaN(value)) { sum += value; } }); //針對所有的input type為checkbox的element,選出checkbox的id,並將table row id為row_XXXX給刪除 $('input[type=checkbox]').each( function (){ if ( this .checked){ var id = $( this ).attr('id'); $(' #row_ '+id).remove(); } }); // 針對id = act_btn的elem...

這次稍微寫一點Facebook Api的東西 其實一開始看覺得看不懂只是因為英文或是都是片段片段的東西 要自己完整組合起來才會比較了解! 關於申請App Id的部分就不贅述了

今天在工作時遇到一個問題，因為之前從沒遇過只好筆記一下! 案例是這樣的，相信大家只要有做過關於會員系統時，多少會因為地址的關係頭痛 比較多人關於縣市及哪一區都會用下拉式選單，但也不可能自己打