| |
| |
| |
|
Page: 1 2 3
Comments:
<0> This has nothing to do with SQL
<0> It's about how Access quotes identifiers
<0> other DB's do it differently
<0> Access probably uses []'s
<0> but that's just a guess
<1> ok
<1> yea i think it does use [] 's
<1> is it ok to past 3 lines of code to learn with your help a sec?
<0> 1 line is the limit for pasting to the channel
<0> for > 1, use the pastebot site
<0> in the /topic
<1> ok 1 line is good
<1> WHERE Table1.[Ball 1] > '10';
<1> that is supposed to make the query return only items which are greater than 10 in column Ball 1
<0> You do realize that '2' is > than '10', right?
<1> how ??
<0> strings of digits are not numbers
<0> learn about types
<1> so i have to do it w/o ''s
<0> depends on the type of [Ball 1]
<1> sorry i dont follow the type thing
<0> This is not CompSci 101
<1> do u mean if ball 1 column type is a string/date/number/text
<1> etc?
<0> there is no "string" type in SQL
<0> perhaps you meant CHAR or VARCHAR
<0> lugisbitc: you probably think I'm being anal and pedantic
<1> <0> depends on the type of [Ball 1]
<0> I am, but you *need* to be anal and pedantic in order to write code
<1> i understand
<1> thats the bit i didnt understand what do u mean by type
<0> When writing software, you need to be more anal than you ever thought was humanly possible.
<2> lugisbitc type, like: int, num, char, varchar, blob
<0> was I too harsh?
<1> uchuff i see
<1> no not at all
<1> teachers have to be ***holes sometimes ;)
<2> just out of interest, why no MySQL?
<1> SELECT Customers.* FROM Customers WHERE (((Customers.Country)="USA"));
<2> easy on the brackets
<3> i thinki you need more ()
<2> lol
<0> uchuff: because 99% of people that come here with MySQL questions are flaming morons
<1> just learning simple stuff in access
<2> ah ok
<0> and the 1% that aren't can ask the question in ANSI-SQL
<2> ya it is pretty nonstandard
<2> i learn ansi sql and oracle at uni, but i use mysql most atm
<2> * learnt
<0> lugisbitc: what book are you learning SQL from?
<0> uchuff: I have one word for you: PostgreSQL
<2> ya
<0> Pg 8.1 is *way* better
<2> its on the todo list
<3> oracle has a small free version thats nice and good
<2> ya im not ready for production yet, using pg a bit tho
<4> Oracle Express is still beta, yes?
<0> Heh, "small" for Oracle is definately a relative term :-)
<3> oracle express will always be considered beta. just like most of the oracle 64bit linux and mac reoleases
<0> uchuff: Pg has some really cool features. Like being able to define your own aggregate functions
<4> I see.
<3> that just means you cant buy it and they wont do sev 2 or 1 support on it
<4> Could just specify that in the license agreement instead.
<3> people are more afraid of beta code then licenses
<3> look at all the people who use EE and SE from OTN and think its free
<4> Yes, they are.
<4> Funny that they picked that name, tho.
<3> to piss off MS
<3> release a db with the same name and more features 1 week before MS renamed msde :P
<4> MS renamed MSDE over a year prior.
<0> who was the celtic god of smiths and craftsmen?
<3> to express?
<4> Yes
<4> Oracle appears a year behind.
<0> a year behind what?
<4> In terms of releasing an "Express" prodct.
<3> everything i have with their versions still showed msde even patches and upgrades until the 'express' named db a few months ago
<0> Oracle Express is an oxymoron
<4> SQL Server 2005 Express betas have been public for over a year.
<4> There never was an MSDE 2005.
<3> and?
<4> And MS had an express beta in the publics hands a year before Oracle did.
<3> thats ok. it still ****s
<4> Ah, so that's where you have to hide.
<5> http://i.euniverse.com/funpages/cms_content/6489/a-maze-ing_new_cursor3.swf <-- wake up
<1> ****
<1> why did he leave
<6> found something better to do than stare at an idle IRC channel?
<1> hah
<1> no he was kinda teaching me some sql..
<3> go geocaching
<1> yea i might have to :\
<1> was planning on buying a sql and php book actually
<7> get sql for smarties
<7> good intermediate book
<8> In general, if you are search for "close" entries, (e.g. user enters a name and I want to be able to find names that are close to what they entered), is that usually done as part of the SQL or via application code?
<8> Also - what is the term for that? I tried googling for it and must not be using the right terms.
<7> depends on the sql server
<7> and you want pattern matching
<7> what patterns you choose to apply depends on you
<1> any particular books you recommend ppl ?
<8> I'm using MySQL... so I guess I can search for what pattern matching capabilities it has and determine if I need to do it in my app server.
<7> you can take mysql and throw it in the trash
<7> lugisbitc sql for smarties is one i recommend
<7> review it and see if it fits your needs
<8> I wish I could switch - unfortunately the environment is already configured.
<8> Darken|: I understand the use of LIKE and REGEXP; but I was wondering what is considered good pattern matcing approaches for let say someone mistyping the name of a restauarant in a db of restaurant names.
<1> what about sql for dummies
<3> too advanced
<2> lol
<9> sup Quant
<9> you off skiing today?
<9> I got some wicked boarding in yesturday, finally starting to connect my noob turns
<10> no skiing
<10> ****ing rain
<11> can somebody tell me, how to access dbase 3+ files?
<10> drakh
<9> sup
<10> got a map of your moutnain?
<9> i live in bc man, there are mountains everywhere
<9> it isn't just one!
<9> :)
<10> umm hmm
<11> i always get error 8961
<9> BC canada is where it's at if you wanna board / ski
<10> the one you went to
<9> last night? hold on
<11> dbase 3 works just fine, but the 3+ files arent accessible, damnit
<9> http://www.mountseymour.com/
<9> man it was so nice out yesturday
<9> I'm going to whistler next weekend, I'm lookin forward to it
<10> does it show maps?
<10> cant find map
<9> click skiing and snowboarding
<9> and click trail map
<12> can someone help me out with something I can't figure this out
<12> http://sql-servers.com/nopaste/?show=173
<12> err
<12> sorry wrong chan
Return to
#sql
or
Go to some related
logs:
devon dubnyk
#computers
#computers
#solaris
#nhl
DriverLock Password
#firebird
jeroenqui
#beginner
#gamedev
|
|