| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> so you want to select the customers along with the max phase for a customer out of the phases table?
<1> via customer_id customer has 5 phases
<1> yes
<0> simple
<0> one sec
<2> heres another stupid question: a blob datatype is basicly raw binary data, correct ? so how do i put data into it using a text based command language like SQL ? using an escaped string ?
<1> the query you see works... however i now need the date also... so the max(phase) as phaze probably isnt the best approach
<1> phase.date
<0> huh?
<0> the date of what?
<1> of the phase
<0> ok, that's a bit more complex, one sec
<0> what sort of values are in phases.phase?
<1> int
<0> http://rafb.net/paste/results/5GR1cx71.html
<0> something like that
<2> nobody knows ?
<0> [twisti]: knows what?
<2> <2> heres another stupid question: a blob datatype is basicly raw binary data, correct ? so how do i put data into it using a text based command language like SQL ? using an escaped string ?
<1> rmah: tyvm ... just curious is JOIN keyword optional and just used to make the query easier to read?
<1> nevermind
<1> disregard that
<0> thun: yes
<0> [twisti]: yes
<2> to all of it ?
<0> yes
<2> alright, thank you
<3> I'm getting what appears to be an infinite loop in some code, but I can't seem to figure out why. I don't even have any loops coded. Can someone take a look?
<4> where
<3> ill paste it online hang on
<3> ok
<3> http://sql-servers.com/nopaste/?show=504
<3> Quant, you there?
<4> yeh
<4> is this mysql or something?
<3> oracle
<4> no clue about oracle
<4> sorry
<5> how i can create a column in sql server express that will increment by 1 automatically?
<6> identity?
<5> you are asking me?
<6> that was one of those things that is asked rrhetoricaly and u r to go look up that word or phrase that you are given
<4> identity(1,1)
<6> or if you are a publisher
<6> or a printing press
<6> you go identity (150000000,1)
<6> lol
<5> Arrakis: what data type i need to use so identity will be enabled?
<6> anything numeric based
<4> hehe
<6> uusallyint or bigint
<4> fake it out a ltitle :)
<6> i hate faking that crap
<6> cause then everywhere you reference the order number
<6> you have to subt5act by some number
<6> and god forbid theyshould want to change that before the app goes live
<6> if their seed overfills their datatype they can hire me and pay me again to redesign the system huhu
<5> thanks
<4> hehe
<5> in what field the salary is higher: asp.net or sql?
<7> I have 3 tables called supplier, item and sale. the supplier supplies goods to the itemtable so to speak, and some of the items gets sold. Ive managed to list the the names of the suppliers whos goods have been sold but I also wants to list those suppliers that have supplied goods to item but it havent got sold yet, anyone have some clues?
<8> http://pastebot.nd.edu/321 <-- could someone look at that and give me some advice ? thanks
<8> anyone ?
<9> I have a question. I am using Oracle 9i. I am trying to renaume a datafile and am having difficulty. I have tried looking up for help on the internet and in reference books and the code that I have is not working. I keep getting the error "ORA-02236: invalid file name" I can't figure out what is wrong with the code. I know that the path is correct. I posted my code on sql-servers.com/nopaste, any help would be greatly
<5> very good question
<10> brokenrec, you useing '/foo/bar.dbf' he single quotes?
<9> yeah, it is in single quotes
<11> I'm using Access (don't ask): http://www.sql-servers.com/nopaste/?show=507
<11> I'm trying to get the lowest year in the table tbl_documents where Page_ID is a value p***ed in by SQL... but I'm always getting the largest year in the db.
<10> broken when you ls -l the file does it exist? whats in your dba_data_file?
<11> Any idea? tbl_bridge_pages_documents contains the document_id as a foreign key, and tbl_documents has the date field as fld_date
<11> Or ah... does anyone have any idea where I can test manually typed queries in MS Access?
<9> the file is shown in the dba_data_files view... I am just trying to put it into a different directory...and physically speaking I did put a copy of the file into the new directory.. I am just having trouble renaming it
<9> any ideas?
<12> this one is kinda tough i guess
<12> oracle question
<12> i need to get all rows of a row that is a substring of another row ... all being the same field
<12> for instance
<13> good thing you are using a relational database like oracle
<12> oracle.9.111 oracle.9.11 oracle 9.1 oracle.9
<12> based on no particular value
<12> anybody have any ideas?
<13> your question does not make sense
<13> so far all you are asking can be done with a substring function
<13> but i dont think thats what you are asking
<12> ur right its not ... let me try to rephrase it
<12> something like --> select version from applications where version is like 'version.%'
<14> INSTR() function
<15> this is an easy question but, is there a way to flip a result? ie: i select * from blah order by column DESC, but i want to display the result in reverse order
<15> im limiting to 10 results, so i want to sort by desc to get the "last" 10 (ordered by a timestamp)
<15> i was thinking of loading the result into an array and resorting it but i'm sure thers an sql way im just not thinking of off the top of my head
<15> im using mysql btw, w/php
<12> fif you are ordering by a timestamp DEC would give you the newest date
<12> *DESC
<12> Halo_Four, the problem is i dont want 'version%' to be compared as a string literal. aka "verson.1.2.3"
<12> really i'm trying to do something more like --> select version from applications where version is like version%
<12> would i use a subselect maybe?
<13> eidolon`: select * from (select * from blah order by column desc) a order by column asc
<16> 0: you want to select all rows whose version field matches what exactly?
<16> from your select there, it sounds like you want to select all rows whose version field matches itself
<16> in which case it will just return everything
<12> _Optikal_, whoes versions filed is part of another rows version field
<15> hmm
<15> ("SELECT * FROM `IM` WHERE `event_type` = 'messageTo' AND `userid_to` = '".$_COOKIE['v5userid']."' AND `userid_from` = '".$remote_userid."' OR `event_type` = 'messageTo' AND `userid_to` = '".$remote_userid."' AND `userid_from` = '".$_COOKIE['v5userid']."' ORDER BY `timestamp` DESC LIMIT 10;");
<13> eidolon`: huh?
<15> i want that result, reversed
<13> and what i told you doesnt work?
<15> the results right but i just want the order reversed so i can print it properly
<15> i havent tried yet
<13> and i told you how to do it
<13> so y dont u try it?
<15> i just posed m statement for _Optikal_
<15> mi eating a burger
<15> gimmie a sec:)
<13> optikal didnt ask you for hte query
<15> oh
<15> I failed to see the 0: ...
<15> :)
<13> 0: so you are basically saying that you have a field which is a string of different version numbers
<13> how are they deliminated?
<12> ok well u knwo how --> select * from application where version = version will give you all rows
<15> thanks sic
<15> worked great
<13> np
<13> 0: so the delimeter?
<12> i want to do that but version like version% so i dont have to give it any particular startgin point
<12> delimeters could be <space> or - or . but i fail to see why that would help
<13> well dont you want to break the strings up?
<12> no i just want to view them
<15> sic: probably stupid, but whats the 'a' for
<13> eidolon`: you gotta give it a name
<13> 0: you are not explaining your selecting cretira
<13> eidolon`: alias
<12> i want to run through the whole table and look for rows which have similar versions
<15> is that like select count(*) as count from blah
<13> eidolon`: look up derived tables
<15> thanks
<13> 0: so you want to compare the version column with other version columns
<13> so you would have to break them up
<13> otherwise you cant compare
<15> i've pretty much just kept to simple select/insert/delete/updates
<13> 0: ur not asking the question properly or maybe u just dont know what you want... but i dont want to figure it out
<12> SicWork yes i suppose u could look at it that way
<13> gl
<12> SicWork you just hit the nail on the head
<12> "so you want to compare the version column with other version columns"
<17> How can i select the last row of a table
<18> select top 1 .... order by .... in reverse order
<18> "last" implies an ordering
<17> thans
<17> thanks
Return to
#sql
or
Go to some related
logs:
#stocks
toocanx
#windowsxp
#solaris
dalnet gigglz
PlexTools BlueScreen
#computers
#freebsd
babyblue tinio
nike asulikeit
|
|