| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> anyone here good with photoshop?
<1> i can photoshop your mother !
<0> heh
<0> that must be nice...
<2> he's asked that in 3 channels.
<3> ./join #photoshop
<4> I have a table with 3 fields (int). now I want to get the total of all 3 fields together. how should my query looks like? (I am using Interbase 6.5)
<5> select col1 + col2 + col3 from yourtable
<4> thanks
<2> Anyone know why a really long XML string from a stored procedure using XML FOR PATH would be truncated?
<6> what's the difference between primary, index, and unique keys--also, what is a good sql/mysql reference book
<6> ok i guess this channel is pretty worthless
<6> bye
<7> anyone in nyc?
<7> who wants to play poker?
<8> hi2all
<9> hi2u
<8> omgteheheh
<8> SELECT EMP_NAME, PROJECT_ID FROM EMPLOYEE_T, PROJECT_T WHERE PROJECT_ID IN (SELECT PROJECT_ID FROM PROJECT_T WHERE PROJECT_ID = 1002)
<8> this returns all of the employee but has "1002" in the id column for each employee...
<8> when, not all employees have 1002
<5> what dbms
<10> Slightly forgot to join there
<8> this is oracle
<8> erm
<5> WHERE PROJECT_ID IN (SELECT PROJECT_ID FROM PROJECT_T WHERE PROJECT_ID = 1002)
<5> that is a really useless clause
<8> but its right isnt it?
<5> how about expanding that a few levels deeper just for cool effect :P
<5> how about where project_id = 1002
<10> No, a subquery does not take the place of a join.
<11> Is there anyway to retrieve the values of a column in upper case?
<5> upper(col)
<10> You do not have a relationship established between employees and products so the result will contain all employees with all products that match the subquery.
<11> thank you
<12> ok so the employees will ahve a relationship with the products
<12> and they will have hot ***
<12> WHERE THE EMPLOYEES ARE DRUNK AND THE PROGRAMMERSHAVE AN OBSSESSION WITH (ALL UPPERACASE SQL ) ROCKS
<13> and they love the wham
<13> http://tinyurl.com/cl7kx
<12> lol
<12> that pic is ++gay
<12> notice how i used ++gay, to avoid the extra copy
<12> :P
<5> hehe u C++ hax0r
<13> heh
<12> ok so what are we up to today
<12> clustering mysql ?
<5> access programming :((
<5> i am actually using VBA for some stuff in access... it's driving me crazy
<5> "on error goto 0" lol
<12> nah thats not right
<12> ON ERROR RESUME NEXT
<12> is the powwarhjhhhhah
<5> yea
<5> gotta love the IIF() function too
<12> ok nite im out of beer
<12> hahahahaha
<5> later
<8> so
<8> by no homework
<8> do you mean like
<8> nobody will do my homework?
<10> It also means that people generally won't answer pure BS theory questions which have no relevance and are often constrained to the technology/techniques described during cl*** that day.
<8> QUESITON
<8> oops
<8> if i have COUNT(*) AS EMPLOYEES_***IGNED , and i wants a WHERE EMPLOYEES_***IGNED > 1 , how would i do that? :\
<8> -s
<14> having count(*) > 1
<8> i put that in place of the EMPLOYEES_***IGNED > 1 ?
<12> no
<8> oh
<8> i forgot to take out the where
<8> :D
<8> thanks
<15> yar
<15> I said "YAR"!
<14> YAR!
<15> greetings
<16> arr
<15> hi Darken-
<15> I have a question
<17> xml schema talk, anyone?
<15> should I get a low-profile tactical hopper for my tippman A5?
<15> well?
<15> some help you guys are
<17> hehe
<17> how many does it hold?
<17> and what would it be replacing?
<15> the low-profile tac hopper holds 40 to 50 rounds
<15> the standard hopper holds 200 to 250
<17> how many rounds do ya generally go through?
<15> about 50
<15> sometimes more but not always
<15> hence my hesitation
<17> wonder if you could have like a quickly added supplement of like 20 via the filler
<15> I've never had to reload during a game
<17> somethin that you could easily open the filler, pop this in/open, etc
<17> yea but you've been carryin 200
<15> because I've always used standard size hoppers
<15> exactly
<15> have you ever reloaded during a game?
<15> was it a PITA?
<17> i don't play ;)
<15> oh
<17> well.. haven't... nothin against it
<17> my thought was somethin like a tuna can, but easier to open... that you could just pop over the filler in an emergency
<15> I wish they were like rifle magazines... pre-fill them and then swap them out
<17> yea
<17> wonder how hard it'd be to make a quick release mechanism between the hopper and the gun
<15> not hard if you had a machine shop or a factory :-)
<15> sadly, I have neither
<17> hehe
<17> ditto
<17> it'd be uber sweet if the hopper mechanism had a spiral sliding door which opened as it was being slid into the gun-side mechanism
<15> yeah
<15> the more I play the more I think about manufacturing this ****
<17> actually
<17> that shouldn't be too difficult to make outta stuff from a hobby shop and home depot/lowes
<15> I think civil war style muzzle-loading paintball guns would sell well to re-enactors
<15> the range is about right
<17> hehe
<17> for battle field re-enactments?
<15> all we'd need to add is a puff of smoke (which would be easy with the right gas feeds)
<15> yeah
<17> dude... blood red paint... keep the theme of the bloody battlefield!
<15> lots of people do civil war style re-enactments
<15> exactly
<17> don't those load from the bottom?
<17> oh those are one shots
<17> duh
<15> most rifles used in the civil war were muzzle loaders
<15> so the paintball guns would need to simulate the entire process (with rammer, etc.)
<17> dude i got it
<17> ok so loading might be 100x easier than true muzzle loaders
<15> you should play man, it's too damn fun
<17> but i suppose today's re-enactors aren't putting as much training into quickly loading for times of war... so perhaps it's a wash
<17> but so you use the excess air to blast ash or somethin out the exhaust
<17> sorta like toothpaste outta the tube... throw in the ash as the air's blasting out
<15> heh
<17> just gotta figure out a control mechanism that would last and is fairly easy to "reload"
<15> idle thoughts ***ide... should I get that low-profile tactical hopper?
<17> what is this an auction or somethin? :P
<15> no, it's cheap.. $10 :-)
<17> oh then hell... go for it
<17> you always have your original :P
<17> hell...
<15> it's just a plastic can open on one end and a flip lid on the other
<15> sure, but should I *use* it!
<15> that's the real question
Return to
#sql
or
Go to some related
logs:
#stocks
keeptrack 6.2 omen
#freebsd
#gentoo
#computers
#beginner
ago logistik
#politics
#stocks
#beginner
|
|