| |
| |
| |
|
Page: 1 2 3
Comments:
<0> yup
<0> 0-12? hmm
<0> 1-12
<1> programmers hate to waste perfectly good numbers :) 0-11
<2> yeah, noticed but didn't want to correct once more :)
<0> :)
<0> so where's the answer?
<3> 42!
<0> LVK?
<2> yes?
<0> my question......do you know a good answer? :)
<2> write a function to convert it
<0> meh meh
<4> i dont believe .NEt doesnt have any sort of formatting routines
<0> actually there is but umm i dont need it in a string form
<0> i need it in
<0> Hour, Minute, DatePart
<0> or TimePart....whatever
<0> if i used formatting functions then i'd get a string and then i'd have to parse the string which is retarded
<4> i dont believe .NEt doesnt have any sort of routines to uhm, split a date into Hour, Minute, DatePart or TimePart....whatever
<2> that's not what he's asking, he wants the 0-23 hour value into a 1-12 + AM/PM value
<2> and I'm not sure .NET has that
<4> oh well, sometimes we coders just have to face the facts
<4> and write a little bit of actual code once in a while :)
<5> i am checking out System.DateTime to see if it contains 0-23 -> 1-12am/pm format
<5> are you guys talking about .NET v1.1 or 2.0?
<6> Quant: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp
<6> ie. try "tt".
<0> damn i used that before, my memory is shot, thanx
<0> it's prolly
<0> HH for military and hh for regular
<5> Quant:: are you using .NET for SQL 2005?
<0> nah
<5> oh ok. i thought you might have needed msdn2 doc instead..
<6> (23:07:58) <4> i dont believe .NEt doesnt have any sort of formatting routines -> String.Format can format anything basically ;)
<0> i had a brain fart
<5> Quant:: have you every tried out MSH?
<5> for testing out such simple stuff like testing date time formatting, msh comes really handy
<5> MSH>$now = [DateTime]::Now; $now.tostring("hh HH")
<5> 05 17
<5> crap. sorry about that..
<0> wutz MSH
<7> sup carp
<5> Quant:: MSH is Microsoft Shell
<5> and it's tightly coupled with .NET v 2.0
<5> it's to replace "cmd.exe" i hope
<5> basically a next-gen shell for windows
<5> but still in a beta state
<6> the next big thing ;)
<5> oh yeah. i hope so.. although a lot of *NIX gurus are bashing about how MSH lacks this and that feature and blah blah blah
<5> but you can basically do everything with MSH you can do with .NET v2.0
<5> but since it's still in beta3, there are still some problems... like you can't create a new thread and cannot access clipboard instance and such
<4> hey sortii :)
<6> d2d_sm0ke: should be trivial to write some custom **** to access the clipboard
<4> maybe not
<4> clipboard requires immovable shared memory
<8> wilco`:: oh yeah, i am checking out the new feature called "snap in" to create a snapin for clipboard functionality
<6> :)
<8> man... the more i use msh, the better it gets...
<0> yo
<8> wth am i doing at work on saturday afternoon writing sql scripts.
<8> and listening to music
<0> if i am going to write to Trace, can I hook up to an event on trace in order to display that somewhere else?
<6> lookup TraceListeners
<4> any easy way to bring up msc services snapin from command prompt ?
<9> services.msc
<9> type that press enter :P
<4> thanks :)
<10> http://pastebin.com/516758 << I am trying to make 2 tables and connect them using the forign key from the first table to the other table my---sql is giving me errorno:150 can any one help me? tell me y?
<9> AnnaUk0, what database?
<10> my sql
<10> any ideas
<10> guys
<9> goto #mysql :P
<9> and check your case.
<9> and remove the type = innodb and engine=innodb
<10> mysql
<10> help
<10> PLEASE
<10> guys
<10> ill send you apicture of my tits..?
<9> people here dont support mysql. i just told you what the 150 error was from
<9> its an innodb error. are you sure that is even supported on your server?
<10> well my other table has it
<10> and that works
<9> constraint name isnt unique too
<11> http://mysqld.active-venture.com/InnoDB_foreign_key_constraints.html
<11> And go ask in #mysql if you need more help.
<12> evening all
<13> re
<14> Ok so possibly more than 1 project can belong to the same company and more than 1 company can be in charge of the same project
<14> I have a company table and a project table, company has a projectid and project has a companyid
<14> when I do an insert into a project table that belongs to 3 companies, do I have to insert it three times?
<14> or is there a better way?
<12> Pilabyte : there is
<12> have a 3rd table
<14> oooooh... that'll be the relationship table or something?
<12> yah
<14> I can have companyid and projectid only in there
<14> awesome... thank you
<12> have an id for the rows too
<14> true true... the primary key
<14> which I will include in both the company table and the project table... so they can link
<12> er?
<12> no
<12> 3rd table has three cols, id, companyid, projectid
<14> yeah so the first col gets included as a foreign key in both the company table and the project table... no?
<12> id should not appear in either of the other two tables
<14> oooooh
<12> no
<12> id is just to uniquely identify the rows
<12> just in case
<14> so then I should take out projectid from company and companyid from project
<12> yah
<14> that makes sense... I'll play with it
<14> I'll play with SQL that is
<12> do that thing
<12> evening halo
<15> hm
<15> when did I part?
<12> um
<12> damn... gotta check logs - more than 90 mins ago
<15> Yeah
<15> S'fine. I wonder if there was a power outage or sumthin.
<12> dunno - i had to reboot
<12> ah... no logs
<12> forgot to enable them last rebuild
<12> i'll let you know next time...
<16> buttless red leather pants
<16> heh
<16> ****
<13> [20:07] * +Halo_Four (halofour@oper.efnet.demon.co.uk) Quit (Ping timeout: 200 seconds)
<0> darken what's up
<13> nm
<13> doctors office keeps screwing me around
<13> they're taking their sweet old time
<13> to push papers around
<14> is there anyway to immediately acquire the id of the item I'm inserting into?
<14> i.e. insert into myTable (name, property) values ("blah","blahp"); and then somehow get the id that the database automatically ***igns this new row?
<11> What database?
<14> sqlserver 2000
<14> Sorry I'm an idiot and forget to clarify...
<17> Pilabyte:: what do you mean by "id"?
<14> well lets say myTable has a column called myTableID <--- it's primary key
<14> I need to be able to acquire that immediately after inserting an item into it... instead of executing an insert command and then immediately a select command after to get the last id
<12> Pilabyte : do you mean to say that the field is an "identity" field?
<12> "primary key" is immaterial at this point
<14> yes
<14> with seed(1,1)
<15> SCOPE_IDENTITY()
Return to
#sql
or
Go to some related
logs:
#windows
#sex
brenda
#computers
#solaris
#beginner
#wtf
#goal
#politics
#gamedev
|
|