| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> is there a dateparse function in SQL or something similar to be able to return only a date or time portion of a datetime field
<1> what dbms?
<2> ken-:: ifyou are using SQL server 2000, you can use "DATEPART ()"
<3> ken- : which rdbms?
<2> ken-:: http://sql-servers.com/nopaste/?show=291
<4> Hello this a General DB question, i'm a Perl programmer and new to Web Development, i would like to implement a web client/server and i wonder which DB works best with Perl?
<2> anything but MySQL?
<5> anything you can find a module for ?
<0> MSSQL
<5> youshould be able to find modules for mysql
<5> postgres
<5> flat dbs
<0> ok i'll check out datepart() thanks
<4> Any good link to start from ?
<5> ehhh
<3> ken- : 'convert()' will do what you need
<5> most perl people
<5> should grab a black perl bible
<5> heh
<5> and i would hope you're already familiar with browsing and installing cpan perl modules
<5> etc
<4> yes
<3> Fullt : cpan.org
<3> Fullt : DBD::
<3> Fullt : plenty to choose from, just don't choose mysql and come back here asking about it.
<4> Yah i familiar with many security issues
<4> but i wonder which works best.
<4> because i created an engine that ***emble something and i want the user to have a easy to use interface to query the DB, i dont want something complex.
<4> i guess i'll use postgres
<4> now i just need to learn it :>
<6> blergh
<7> hi
<7> im using mysql and this is my propblem http://pastebin.com/569244
<7> #1120 - Cross dependency found in OUTER JOIN. Examine your ON conditions
<7> help
<6> kibibyte : no - you're problem is that you didn't read the topic or on-join rules
<6> s/you're/your
<7> I DID
<0> Is it possible to convert a value from a select? i.e. select convert(datetime,e.startdate,10) as startdate
<0> it doesnt seem to convert anything for me
<7> ****
<7> i opaste code on paste bin
<7> i said what database im using
<0> no mysql
<7> so what you want
<0> #mysql
<3> kibibyte : use the right paste site. no mysql
<7> whats the difrence??? SQL is language
<3> kibibyte : dumb****
<8> kibibyte, just restate the question and lie saying mssql and repaste at the right site
<7> its database query language you moron yuoppie
<3> bye
<3> that would be 'dbl', not 'sql'
<3> some people just don't know when to quit...
<0> any ideas why if I am converting a value with that code and the value is 3/13/2006 1:00PM why it is not stripping off the time? or if I try using a japan or euro conversion type it changes nothing
<3> 'value'? 'code'?
<0> select convert(datetime,e.startdate,10) as startdate
<0> that code :)
<0> the value of the field is that
<3> ffs... target type should not be datetime
<0> what should it be then?
<3> convert of datetime to datetime will ignore 3rd parm
<3> should be varchar
<0> ah ok so just convert it to a string
<0> gotcha lemme try that
<3> then convert back to datetime if you need
<3> depends what you're doing with the result
<0> woot works great now, thanks :)
<6> indeed
<3> quite
<6> concur
<9> I am using MSSQL 7.0. See http://sql-servers.com/nopaste/?show=316, when i run the query i get Column 'joined.prstart' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. The problem is, i dont want to group by prstart. how can i get around this?
<10> You must either group by it or use an aggregate on it.
<9> dont understand why though? its in the where clause, not select
<10> um, how is any of that statement valid?
<10> Your subselects lack a FROM clause.
<6> indeed - that's some nasty sql
<9> well it is implying FROM joined
<10> geez, I never knew that was valid.
<10> icky
<10> Well, those subselects are in the SELECT clause.
<9> i know!
<6> some interesting use of select sum()' without a from
<10> I'm scared.
<9> ah maybe that is the problem... how can i clean this up? I basically want three different sums for each project, so the sum()'s are using different where clauses
<6> alfer : i suspect you need 'case'
<6> alfer : and a much better understanding of botht the problem and sql
<5> sql 2k5 anybody ?
<5> getting a the specified @subsystem_id does not exist
<9> should i put the select statement inside the sum()?
<6> alfer : no
<6> you should read what i've already said
<6> g'night
<5> anybody know how to set the compatability level in sql 2k5 ?
<3> Arrakis : via the admin tool
<5> :-/
<3> well, ask a stupid question...
<11> hah
<11> probably through alter database now if you wanted a tsql way to do it
<3> hey phargle
<11> supsup
<3> time to crash
<3> nighty-night, y'all
<11> night
<12> I'd like to do somthing like this: RAISERROR('The Group <b>'+@param_Name+'</b> already exists.',16,1)
<12> Is that allowed?
<13> k00 : good for you
<13> k00 : yes. i'll allow you to do something like that.
<12> I get an error message....incorrect syntax near +
<13> no ****
<9> ah CASE is the answer
<13> k00 : that's because you have not read the documentation
<9> too bad gunther left now i cannot thank him
<12> Perhaps..
<13> k00 : no perhaps about it
<5> im sure he will appreciate it none the less ;)
<12> Can I get some love
<13> sure
<5> i notice there is alot of retarditity originating from MIchigan IPs
<13> k00 : letme give you a clue - put the entinre message in a string variable, then use that in the raiserror...
<13> Arrakis : really? maybe we should just ban michigan
<12> sweet
<12> works. thanks
<12> so you can't build strings in any functions in tsql?
<13> i would have done so already if i cared enough about irc to be able to craft the appropriate statement
<14> is there a better way to write this? (basically, select subscribers who have BOTH 'on' for d #10, and 'Peru' for d #4) -> SELECT DISTINCT s1.* FROM subscribers_data AS s1, subscribers_data AS s2 WHERE s1.demographic_id='10' AND s1.value = 'on' AND s2.demographic_id='4' AND s2.value = 'Peru' AND s1.subscriber_id = s2.subscriber_id; -- this is all part of a larger probel I pasted to http://pastebin.com/569268
<13> k00 : depends
<5> sql 2k5 is badly broken imho
<13> bricecube : yes - write it to the paste site, ****tard!
<14> http://pastebin.com/569268
<5> hahahahhaa
<12> Do you hit your wife when she brings you coffee in the wrong mug
<13> i don't need to any more...
<12> She learned quick?
<13> yup
<3> so what did i miss?
<15> if I setup a dependeny-relation between two tables, i cant delete a record that the other depends on, right?
<3> ioNix_ : right
<15> so... i think you can guess my followup question :)
<3> nope
<15> where i EM do i set up a relation?
<3> oh ffs
<15> easy now
<15> :)
<3> by defining an fk
<15> fk is
<15> just a hint so i can google
<3> **** google - use the ms-sql documentation
<10> Open the diagram thingy and draw a line :P
<15> neat!
<15> point-n-drag is great hehe
Return to
#sql
or
Go to some related
logs:
#politics
#solaris
mom
#stocks
#opengl
salmanila poisoning
Naruto_RPG in English
#redhat
#nhl
#3dsmax
|
|