• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 17:17
CEST 23:17
KST 06:17
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Serral wins EWC 202540Tournament Spotlight: FEL Cracow 202510Power Rank - Esports World Cup 202580RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15
Community News
Weekly Cups (Jul 28-Aug 3): herO doubles up5LiuLi Cup - August 2025 Tournaments3[BSL 2025] H2 - Team Wars, Weeklies & SB Ladder10EWC 2025 - Replay Pack4Google Play ASL (Season 20) Announced55
StarCraft 2
General
TL Team Map Contest #5: Presented by Monster Energy Cow Gallstones for sale Whastapp:+44 7944332320 Clem Interview: "PvT is a bit insane right now" Serral wins EWC 2025 Would you prefer the game to be balanced around top-tier pro level or average pro level?
Tourneys
WardiTV Mondays $5,000 WardiTV Summer Championship 2025 Sparkling Tuna Cup - Weekly Open Tournament LiuLi Cup - August 2025 Tournaments Sea Duckling Open (Global, Bronze-Diamond)
Strategy
Custom Maps
External Content
Mutation # 485 Death from Below Mutation # 484 Magnetic Pull Mutation #239 Bad Weather Mutation # 483 Kill Bot Wars
Brood War
General
How do you go up to people? How do the new Battle.net ranks translate? Nobody gona talk about this year crazy qualifiers? Help, I can't log into staredit.net BGH Auto Balance -> http://bghmmr.eu/
Tourneys
[Megathread] Daily Proleagues [ASL20] Online Qualifiers Day 2 Cosmonarchy Pro Showmatches [ASL20] Online Qualifiers Day 1
Strategy
Simple Questions, Simple Answers [G] Mineral Boosting Muta micro map competition Does 1 second matter in StarCraft?
Other Games
General Games
Stormgate/Frost Giant Megathread Total Annihilation Server - TAForever Nintendo Switch Thread Beyond All Reason [MMORPG] Tree of Savior (Successor of Ragnarok)
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
Things Aren’t Peaceful in Palestine European Politico-economics QA Mega-thread US Politics Mega-thread 9/11 Anniversary Possible Al Qaeda Attack on 9/11
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread [\m/] Heavy Metal Thread Korean Music Discussion
Sports
2024 - 2025 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Gtx660 graphics card replacement Installation of Windows 10 suck at "just a moment" Computer Build, Upgrade & Buying Resource Thread
TL Community
TeamLiquid Team Shirt On Sale The Automated Ban List
Blogs
[Girl blog} My fema…
artosisisthebest
Sharpening the Filtration…
frozenclaw
ASL S20 English Commentary…
namkraft
The Link Between Fitness and…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
Customize Sidebar...

Website Feedback

Closed Threads



Active: 637 users

Off-Topic General Discussion - Page 1877

Forum Index > The Shopkeeper′s Inn
Post a Reply
Prev 1 1875 1876 1877 1878 1879 5162 Next
Slayer91
Profile Joined February 2006
Ireland23335 Posts
Last Edited: 2014-05-06 17:51:07
May 06 2014 17:48 GMT
#37521
On May 07 2014 02:41 Scip wrote:
Show nested quote +
On May 07 2014 02:36 Slayer91 wrote:
my reaction to roffles perm ban
+ Show Spoiler +



As a reaction you became a goat


like that taylor swift song "I knew you were a goat"
in a somewhat unrelated note a guy got shot 8 times like 15 mins up the road from where I live lol
its 15 minutes toward the bad side of town sure. Apparently a senior drug gang member. In my mind though, he was the roffles of the drug gang.
he was shot a bit before roffles got banned though I think
Kyrie
Profile Joined June 2013
1594 Posts
May 06 2014 17:48 GMT
#37522
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago
mordek
Profile Blog Joined December 2010
United States12704 Posts
May 06 2014 17:50 GMT
#37523
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
Gahlo
Profile Joined February 2010
United States35150 Posts
May 06 2014 17:50 GMT
#37524
On May 07 2014 02:48 Kyrie wrote:
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago

Curse of the fall.
mordek
Profile Blog Joined December 2010
United States12704 Posts
May 06 2014 17:51 GMT
#37525
On May 07 2014 02:48 Kyrie wrote:
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago

He giveth and he taketh away.
Ho 1:21
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 17:52:40
May 06 2014 17:52 GMT
#37526
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
mordek
Profile Blog Joined December 2010
United States12704 Posts
Last Edited: 2014-05-06 17:55:43
May 06 2014 17:53 GMT
#37527
On May 07 2014 02:52 jcarlsoniv wrote:
Show nested quote +
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)

I believe it's so it knows I'm specifying a date. I use this once a month and MIS class was like 5 years ago :O
I'm just moving everything to Excel where things make sense
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
wei2coolman
Profile Joined November 2010
United States60033 Posts
May 06 2014 17:54 GMT
#37528
Anyone watch the new 24? I feel so lost since I only watched season 1, and never bother watching the other season. Also, hollywood plz stop the "I got caught on purpose!" trope.
liftlift > tsm
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 17:54 GMT
#37529
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ
Artillery spawned from the forges of Hell
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 17:58:04
May 06 2014 17:55 GMT
#37530
On May 07 2014 02:53 mordek wrote:
Show nested quote +
On May 07 2014 02:52 jcarlsoniv wrote:
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)

I believe it's so it knows I'm specifying a date. I use this once a month and MIS class was like 5 years ago :O


what happens if you remove the octothorpes?

edit: also, if Create Date is a datetime, is your query only looking for Date data? Do you have to do something to make it look for datetime? This has sometimes caused issues in BusinessObjects queries
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
Zess
Profile Joined July 2012
Adun Toridas!9144 Posts
May 06 2014 17:58 GMT
#37531
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query
Administrator@TL_Zess
| (• ◡•)|八 (❍ᴥ❍ʋ)
Tooplark
Profile Joined October 2008
United States3977 Posts
May 06 2014 17:59 GMT
#37532
On May 07 2014 02:54 arb wrote:
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ

need more Con
What's your main character like at this point? Also, which planet are you on?
WHAT POW'R ART THOU WHO FROM BELOW HAST MADE ME RISE UNWILLINGLY AND SLOW
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 18:00 GMT
#37533
On May 07 2014 02:59 Tooplark wrote:
Show nested quote +
On May 07 2014 02:54 arb wrote:
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ

need more Con
What's your main character like at this point? Also, which planet are you on?

I picked a soldier, he's lvl 5ish or something. I've killed all the enemies ive came across, fixed all the robots etc, and i'm on Taris atm.

I'm stuck with that Twi'lek and the Wookie atm
Artillery spawned from the forges of Hell
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 18:01:38
May 06 2014 18:01 GMT
#37534
On May 07 2014 02:58 xes wrote:
Show nested quote +
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query


I assumed this was just a copy/paste issue :3

Would be nice if that's the fix though lol
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
Dandel Ion
Profile Joined November 2010
Austria17960 Posts
May 06 2014 18:07 GMT
#37535
you mean the hidden bek guy right?

I can't remember anything beyond focussing down the bitch first and then killing the black guy after.

Should be doable IIRC


Man it's been too long, too bad kotor always crashes on my PC now ;_;
A backwards poet writes inverse.
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 18:09 GMT
#37536
On May 07 2014 03:07 Dandel Ion wrote:
you mean the hidden bek guy right?

I can't remember anything beyond focussing down the bitch first and then killing the black guy after.

Should be doable IIRC


Man it's been too long, too bad kotor always crashes on my PC now ;_;

Ya the hidden bek guy, i got her low spamming grenades but he jumps from member to member fucking them in the ass and its real gay
Artillery spawned from the forges of Hell
TheYango
Profile Joined September 2008
United States47024 Posts
Last Edited: 2014-05-06 18:11:41
May 06 2014 18:11 GMT
#37537
What's your party, at that point in the game you should just be able to yolo everything.

+ Show Spoiler +
Though the Sith Governor is kind of annoying if you deliberately choose to hold level-ups for when you become a Jedi.
Moderator
Dandel Ion
Profile Joined November 2010
Austria17960 Posts
May 06 2014 18:11 GMT
#37538
Sorry I can't remember exactly but I'm pretty sure that he's never went around one-shotting my team.
maybe your levels/equip is really bad I dunno
A backwards poet writes inverse.
mordek
Profile Blog Joined December 2010
United States12704 Posts
May 06 2014 18:11 GMT
#37539
On May 07 2014 03:01 jcarlsoniv wrote:
Show nested quote +
On May 07 2014 02:58 xes wrote:
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query


I assumed this was just a copy/paste issue :3

Would be nice if that's the fix though lol

Yes 100% copy+paste error there. Access actually adds the # back in if you remove it (recognizing MM/DD/YYYY as a date)
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
gtrsrs
Profile Joined June 2010
United States9109 Posts
May 06 2014 18:18 GMT
#37540
at level 5, you are potentially too low-leveled to face the hidden bek guy. even level 6 might make the difference though. just level up by doing some contract killings with zax or farming rakghouls

i've been playing it with my g/f, we're just a little bit further than you. love this game
i play ... hearthstone =\^.^/= Winterfox
Prev 1 1875 1876 1877 1878 1879 5162 Next
Please log in or register to reply.
Live Events Refresh
RotterdaM Event
16:00
Rotti's All Random #2
RotterdaM1270
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 1270
IndyStarCraft 161
UpATreeSC 127
Nathanias 90
StarCraft: Brood War
Mini 473
ggaemo 321
Larva 313
BeSt 234
firebathero 155
Barracks 137
Mong 54
IntoTheRainbow 10
Dota 2
capcasts336
Pyrionflax105
Counter-Strike
fl0m2318
Stewie2K1123
byalli386
Foxcn272
Super Smash Bros
PPMD60
Mew2King44
Liquid`Ken13
Heroes of the Storm
Liquid`Hasu642
Other Games
Grubby6143
Beastyqt837
shahzam404
KnowMe189
Sick47
ZombieGrub38
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 19 non-featured ]
StarCraft 2
• StrangeGG 52
• davetesta40
• musti20045 30
• Kozan
• AfreecaTV YouTube
• sooper7s
• intothetv
• IndyKCrew
• LaughNgamezSOOP
• Migwel
StarCraft: Brood War
• FirePhoenix11
• Pr0nogo 1
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• masondota22342
League of Legends
• Doublelift3747
• TFBlade1113
Other Games
• imaqtpie2004
Upcoming Events
OSC
2h 43m
WardiTV Summer Champion…
13h 43m
WardiTV Summer Champion…
17h 43m
PiGosaur Monday
1d 2h
WardiTV Summer Champion…
1d 13h
Stormgate Nexus
1d 16h
uThermal 2v2 Circuit
1d 18h
The PondCast
2 days
WardiTV Summer Champion…
2 days
Replay Cast
3 days
[ Show More ]
LiuLi Cup
3 days
uThermal 2v2 Circuit
3 days
RSL Revival
4 days
RSL Revival
4 days
uThermal 2v2 Circuit
4 days
Sparkling Tuna Cup
5 days
uThermal 2v2 Circuit
5 days
Wardi Open
6 days
RotterdaM Event
6 days
Liquipedia Results

Completed

ASL Season 20: Qualifier #2
FEL Cracow 2025
CC Div. A S7

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Qualifiers
HCC Europe
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025

Upcoming

ASL Season 20
CSLPRO Chat StarLAN 3
BSL Season 21
BSL 21 Team A
RSL Revival: Season 2
Maestros of the Game
SEL Season 2 Championship
WardiTV Summer 2025
uThermal 2v2 Main Event
Thunderpick World Champ.
MESA Nomadic Masters Fall
CS Asia Championships 2025
Roobet Cup 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.