| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> some crap about extreme programming
<1> oh **** that
<1> i take it back
<2> yeah that sounds like ALOT more than 45 min work
<2> **** that
<3> wth...
<0> cmon 100 dollars :)
<1> i thought it was some "write a C# web service that says hello professer merkin" or some such
<0> and just think of all the experience you will gain
<0> :)
<3> eXtreme programming? take that NUnit, JUnit crap outta here
<2> $100 = 45min of my time if you're a close friend or non-profit group
<0> o if it was coding id do it myself
<1> SicWork you are going to university. you should be prepared for how much professional devs make
<4> read the topic
<0> tenfour: heh funny
<2> although since I wouldn't have to declare it, I guess I could count that as 45min of commerical work... heh
<2> but either way that sounds like it would be a solid couple hours
<0> Darken: relax... it was a joke... i help too many people out in here
<0> i want my return damnit
<4> no return
<3> btw, it looks like really a fun project
<3> s/project/cl***
<5> if i have a column that defaults to NULL, am i able to select * from table where column = NULL?
<0> d2d_anIme: do it and ill take u out drinking
<4> your refund is delivered in a sewage truck
<2> column is null
<2> not =, is
<3> SicWork:: sorry dood. i am on a diet
<3> i mean...
<3> i am already drinking
<0> ill buy you that lite beer crap :)
<0> cmon man all the times i helped u out in college...
<3> ah.. gosh, peer pressure... hmmm let me see
<0> all the times i still help u out...
<5> what if my param is NULL...and i want to use that to select the NULL columns?
<3> woww.. i don't understand 2/3 of the stuff written
<5> e.g. SELECT * FROM table WHERE [id] = @param
<3> s/written/described
<1> null and non-null are very different. you'd have to switch & do 2 separate queries
<0> k00: where id = coalesce(@param, @param)
<0> that might do it for ya
<0> i believe rsults from coalesce are treated differently
<5> let me try
<5> hrm no luck.
<3> "pair programming"? wow.. i heard that MS is enforcing their developers but not sure how that will work out in other companies
<5> i guess if and else is my only option
<1> you can also use ANSI_NULLS to rig it
<1> iirc
<3> well for "pair programming", just write stuff like "it didn't work, since my partner was a ignorant, booze drinking, narc"
<1> i have heard lots of good things about pair programming
<1> but i don't thikn it would work well for small companies
<0> k00: you can use case
<0> ya it works well for big projects
<0> riht now hte porject im on its like 20+ people...
<0> works well every now and then.. especially for debugging
<1> sic dude you are at a university how much exp can you possibly have
<0> tenfour: i more than likely make more money than you
<1> who mentioned money
<0> since u were talkinga bout how "real world rates" work
<0> o im just refering back to what you said
<0> just cause im taking a cl*** right now does not mean that thats all i do
<0> i just decided to take a couple of cl***es on teh side
<3> well being in college doesn't necessarily mean, you don't have experiences...
<1> true
<1> i have just been bombarded lately with these recent CS grads that think they know everything
<3> well ignorance is bliss
<0> heh
<0> tenfour: ask d2d_anIme what i think of college
<3> well jack****?
<0> i rarely went because i think college teaches you nothing
<0> anything you wnat to learn... you learn on your own
<3> roger.
<6> The mindset which lends itself to programming and other computer related tasks develops long before university.
<7> I have a list with IP numbers and timestaps (datetime). How do i retreive the amount of the total amount of uniqe ip numbers, one ip counted once a day? Using MySQL.
<3> ack. curse word
<3> Mufflon:: http://www.sql-servers.com/nopaste/?show=291
<7> ehm, spank you!
<7> very much
<8> always pleasure, to be an ***hole....
<7> yes you really are... not much help here.. why even bohter having a channel? loooooooooooosers!!!
<1> lol.
<8> well... what's so bad about being an ***hat?
<9> Can someone tell me why can't I combine two fields in Acces ie: SELECT UserID, FirstName+' '+Lastname AS theName, Address, Zip FROM Addressbook WHERE theName LIKE '%Bob%';
<9> When I run that query all i get is prompted for thename
<8> welli am not sure how ***Access*** takes parameters but i am guessing that it has something to do with %Bob%
<1> WHERE theName... try WHERE FirstName LIKE '%Bob%'
<6> yes, can't use aliases in the WHERE clause
<9> Halo_Four: Is there any way that I could do that? I mean combine the two fields and find something close
<6> WHERE FirstName+' '+Lastname LIKE '%Bob%';
<1> WHERE FirstName+' '+Lastname LIKE '%Bob%'
<9> Let me try that one sec?
<9> hmmm Well I don't get prompted for the alias name anymore but it doesn't find any records.
<6> Oh, use * wildcard
<0> new: do this: select * from table where firstname + lastname like '%bob%'
<0> see if you get anything at all
<6> Or flip Access to ANSI mode.
<9> Halo_Four: Could I msg you to show you my full statement.
<6> There is a paste site in the topic
<9> oh ok
<9> uggg that just returns a blank row
<6> Try '*Bob*'
<9> SELECT * FROM Address WHERE FristName + LastName LIKE '%Bob%'
<9> k
<9> that did it
<9> :)
<9> what the heck I have used the percend sign before and it worked.
<9> I wonder why I needed that.
<6> % is ANSI, Access isn't exactly a compliant database although it has an ANSI mode that you can enable in Options
<9> Hey thank you soooo much for your help. I spent hours on that. I think My biggest stumbleing block was the fact that I was using an alias in my where clause.
<9> that really through me off
<9> thanks again
<10> yar
<11> SicWork
<11> what program are you on?
<11> rmah: yowler
<10> yo
<0> Quant: what program???
<11> sicwork
<11> at columbia
<10> columbia university? you got accepted?
<11> no
<11> Sic goes there for CS
<10> oh
<11> i think
<10> we should all get together for drinks sometime
<11> i doubt they'll take me
<11> i got bum grades
<12> can i get help with mysql
<13> Try #mysql.
<12> ok
<14> halo, you around?
<14> hey yup
<14> urgh...
<14> restoring a replicated database tonight, for the first time.
<14> looks like ive no choice but to re-establish my replication after the fact...
<14> you guys are worthless...
<14> i solved all my own problems. pffft.
<14> :p
<15> what problems
<16> why does Sage look like it was built in vba using an access back end?
<17> why is the sky blue?
<16> because of the defraction of light reflected agains the ozone
<16> s/agains/against/
<17> Sage does look kind of cheezy
<17> unfortunately, it appears those who are not programmers seem to like that look. *sigh*
<16> hmm. I suppose basic layout means faster response times/
<16> ?
<16> it really does look like an over complicated school kids project though
<17> agreed.
Return to
#sql
or
Go to some related
logs:
#delphi
#photoshop
#nhl
#nintendo
#computers
#politics
#computers
flash onmouseup geturl
minimallism
#flash
|
|