作者查詢 / PsMonkey
作者 PsMonkey 在 PTT [ Google ] 看板的留言(推文), 共738則
限定看板:Google
看板排序:
全部Chiayi4207car3792java2594Angels2168Hiking1877Aviation1354Google738cookclub703Singapore624DSLR581SYSOP563Moto_GP562ForeignEX524ShuangHe429Shu-Lin405SongShan405Warfare387CodeJob383historia376MLB371Suckcomic363Database347Road335NY-Yankees332outdoorgear288Key_Mou_Pad242Asian-MLB234Volleyball230Steam220TigerBlue218Yunlin199PHP196BoardGame190Web_Design188sanguosha184BabyMother173ComGame-Plan168Tainan165cookcomic162MartialArts156Programming132Headphone124motor_detail124Hong_Kong111Bus101StarWars98biker88Ajax81Little-Games81DC80Hotel74BBSmovie73HomeTeach71Pharmacy66CSSE62NSwitch59NewYork56Translate-CS54XiangSheng54GO49Network45Ruby45PLT42EMS40japanavgirls39piano38Eclipse35StarTrek35Stephen34Gossiping33Prob_Solve31SLG31sttmountain31EatToDie30Ind-travel30MACAU30MountainClub30OOAD30W-Philosophy29ArakawaCow25StarCraft24Sub_CS22About_Life20Python20L_TaiwanPlaz19Malaysia18sex18C_and_CPP16RegExp15Visual_Basic15ASM14C_Sharp14Crowd14kotaro14clmusic13IPv612LinuxDev12Soft_Job12BBSview11CAR-TUNING11CompBook10MacDev10Mongolia10joke9museum9WarCraft9NCHU-Mount8NY-Mets8Perl8TheMatrix8Lifeismoney7NTU7SFFamily7Hunter6LaTeX6SuckcomicBM6creditcard5L_LifeInfo5L_Traveling5Network_Sim5NYUST_MTCLUB5SuperBike5AndroidDev4C_WorkBoard4CourtBasketB4Fortran4Ichiro4jazz4MATLAB4NCUMTClub4NTUEE_SI4puzzle4Railway4SP2_Basket4TTU-I90B4ASHS-93-li3Athletics3Flash3HLHS_10thU3Hsinchu3L_GlobalView3SCU_CIS-92A3Sucknovels3travel3Arti53-2t2ASIA-uni2Baseball2clPianist2digitalk2DNF2DragonNest2EuropeTravel2fashion2HatePolitics2HSNU_10082HSNU_10982HSNU_8822ID_Multi2InitialD2KMU_CIA2KS94-3132L_BoyMeetsGi2Ladies_Digi2Militarylife2Nationals2NCCU_Climb2NCCU_SEED2NCU92Physics2NDHU-His1002NeedFood2NTPU-JLAW942NTUDormM62NTUFVOLLEYBL2NTUT_en489b2Old-Games2ONE_PIECE2PC_Shopping2PttSuggest2Sub_DigiTech2Tai-travel2Taitung2Test2Violation2YF6th-4072AirForce1Alluvial1APH1Aries1ASIA_ISA1Astros1Audiophile1Beatles1BigPeitou1BIME-VOLLEY1Blog1Blue_Jays1blues1BoardCourt1book1Boy-Girl1C_Chat1cabala1CCUfinGrad921CCUfinGrad931Chan_Mou1chicken1CHSH-3191CHSH-93-3041CHU_CS96b1CHUSHAN89-331civil941ck49th3181ck55th3291ck57th3041ck57th3281ck57th3301ck58th3021cksh76th101cksh79th3101cksh80th3171cksh83rd3071CLHS-50-141CLHS-53-131CMCRX421Comic1CompilerDev1Cross_talk1CSMU-MED911CSMU-MED921CSMU-MED931CSMU-MT921CSMU-OSH1CSMU-OT941CSMU-Talk1CSMU-V-CLUB1CTSH91-3021CTSH923011CTSH923021CTV1cute1CYCU_Chem92b1CYCU_Talk1Darvish1DET_Tigers1Deutsch1DJ_Ken1DJonline1dlsh-7th-3031Dodgers1dog1DragonBall1DYU1ElsieYeh1Emulator1EZsoft1F_Naohito1Fantasy1FiremanLife1FJU-ACC90a1FJU-ACCR941FJU-BAvolley1FJU-EE-2001a1FJU-Laws991FJU-PH14th1FJU-STAT95B1FJU_AD-041FJU_CHESS1FJU_Chiayun1FJU_CPSY1FJU_Fashion1FJU_Psy951Food1FSHS-92-3141Gackt_et_Job1GIEE_951Gintama1GL1Goddess1GReeeeN1GreenCity1hc3141HC5th-3121HCSH1HSNU_10021HSNU_10101HSNU_10371HSNU_10581HSNU_10951HSNU_11131HSNU_11151HSNU_11681HSNU_8541HSNU_9481HSNU_9491HSNU_9751HSNU_9891HSNU_FuBoard1HSNU_j1021HW903201ILSH-953131Indians1Indie-Film1ISUEE93A1IVERSON1JapanIdol1JingXingBoys1JOJO1Judo1katncandix21kawaii1KCFC1KHCHS-93-3061KinKi-Kids1KMCJ-88-3111KOF1KS92-3041KS93-3141KS93-3151KS93-3201KS94-3031KS94-3101KS94-3111KS94-3121KS94-3161KS94-3201KS95-3141KS95-3161KS95-3181KS96-3031KSU1KUAS1Kuroyume1Lakers1LGS1Mariners1Marlins1Master_D1Mathematica1medache1media-chaos1MiYaMay1MMA1movie1MUSTMIS1na-chuanmom1Nantou1NAOE-861nb-shopping1NCCU04_TUR1NCCU05_PSYGR1NCCU07_MAT1NCCU08_MAENG1NCCU_KungFu1NCCU_Leader1NCCUbike1NCCUGO1NCHU-AGR001NCHU-AGR071NCHU-FS991NCHU-FT-1011NCHUCHESS1NCKU-Stat-961NCUT1NDHU-dc1001NDHU-DSLS081NDHU-ENG-WV1NDHU-His1011NDHU-MBA941NDHU-MBA951NDHU-MSE911NDHU-MSE921NDHU-PA971NDHU-phy951NDHU_MSE941NDMC-Volley1NFL1NFU1NHLUE-EED9511NIUECE911NKUTEE1NTNU-SLM951NTNUMasCom961NTPU-ACC871NTPU-ACC971NTPU-COECO881NTSU-SM951NTU-HTvolley1NTU-K71NTU_MED_VOL1NTUA_MPD1NTUAC941NtuBaChi1NTUBIME-1021NTUBSE-B-941NTUBST951NTUE-Art951NTUE-ArtVB1NTUEE_LAB5261NTUEE_NDFSL1NTUEOE_R306A1NTUHistory941NTUMEB94-HW1NTUmed911NTUMSE-941NTUST-EE-B951NTUST-ET-A961NTUST_Mt1NTUST_Talk1NUK_AC981NUK_EE100A1NUU-ME-1001NUU-ME-981ONLINE1Orioles1P2PSoftWare1pccu_physics1Perfume1pet1Philippines1PhotoLink1Picks1pighead1Po-pingpong1Povolleyball1PSWO3rd1PttLifeLaw1PttNewhand1PublicIssue1PushDoll1Rangers1Rays1RedSox1Rockies1RSSH91_3031RSSH92_3021RSSH94_3011Sammi1Sassy-babe1ScenicPhoto1SCU_ACCM951SCU_CIS-90B1SFHS1share1ShiauLiang1SHIN1Siam-Star1Sodagreen1soho1SportComic1SSSH-12th3041SSSH-13th3051STDM-93-3031studyteacher1Sub_GConsole1SWORD1TA_AN1Taipei1tale1Taoyuan1TCSH1TCTP56th671Teacher1TennisTeam1TFSHS64th3091TFSHS65th3221Therapist1THU_PH901THU_Talk1TKU-GITS941TKU_CE94C1TKUME-92A1TMU9431TOKIO1transgender1TS2ndChong1TSU_talk1TTU-talk1TTU-TE911TTV1TunHua05t3111TUT1TuTsau1TYJH_92_ENG1TYSH48-3011UKN1V61VET_941VET_971VibWang1visualband1Vocaloid1Whales1WuGu-BaLi1WuLing46-3171WuLing50-3031X-Japan1YangZhao1YH33rd3191YOLO1YP87-3061YP90-3051YP92-3071YP96-3141YUGIOH1Yup99-061YUYUHAKUSHO1YZU-EE95A1<< 收起看板(507)
1F推: 滑鼠 drag&drop 可以用、shift+左鍵選範圍也可以用03/03 21:46
2F→: 搭配搜尋功能就... 還有什麼不滿嘛 XD03/03 21:47
2F→: 除非有線跟wifi有做不同的網路設定,不然這還真的很謎03/02 08:48
6F→: 比較有趣的是... ETF 幾乎都還是出得來 XD02/03 20:33
1F→: 結果是你朋友沒有設定好?01/18 08:51
1F推: 沒實測純目測(aka 不負責任 XD),你 QUERY() 的第二個12/19 15:55
2F→: 參數(逗號以後的東西)最終必須能讓電腦認為是一個字串12/19 15:56
3F→: 「'分頁B'!J2」電腦會幫你換成實際的值再跟前面兜起來12/19 15:57
4F→: 但是「Q=3」在第二個式子當中並不是字串,電腦也沒法進12/19 15:58
5F→: 行運算,所以就死翹翹了。12/19 15:59
6F→: 試試看 "select * where Q=" & '分頁B'!J2' & "Q=3"12/19 16:00
7F→: 然後去理解一下為什麼要有 & 這個字12/19 16:00
8F→: 阿等等,我少寫了... 應該是「" or R=3" 」12/19 17:07
9F→: 建議你先用純字串寫死第二個參數,然後再一段一段換成12/19 17:08
10F→: 變數 or 關鍵字... 這樣會比較清楚 [遠目]12/19 17:08
11F→: 你第一個應該是錯的吧... Q1 後面多了一個 "12/19 20:05
12F→: 建議你:「&」前後都留空格,結果沒變,只是幫助你理解12/19 20:06
13F→: 然後另外弄個測試用的格子,式子直接給12/19 20:07
14F→: 「="select * where Q =" & A1 & "OR R = " & B1」12/19 20:07
15F→: 來開始理解起,不然隔兩天你大概又上來問了...12/19 20:08
2F→: 自己有三四個,開起來都沒啥問題啊12/15 09:09
3F→: 先猜你的 blogger 有掛上外部的 resource?12/15 09:10
11F→: 沒有到不可思議,搞網頁的已經為這件事情奮鬥好多年12/16 01:42
6F→: 你確定網址正確 or 沒被弄到什麼怪東西....12/10 22:48
5F噓: 跟這篇文章比起來,國五設計者簡直天才12/10 13:43
1F→: 遊戲那邊的客服一定無法幫你的,他們最多只能知道你12/04 22:59
2F→: 正常登入 google 了沒12/04 22:59
1F推: 顯示單張照片的時候往上滑...12/04 22:58