| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> some dude didn't pay me for an ebay auction. i'm scared to leave negative feedback though because he'll probably turn around & give me negative
<1> yup
<1> won't ebay chrage you % from sale?
<0> yea i had to pay the listing fee
<0> which is only like $0.60 or something but still
<0> i gave this guy a lot of leeway and his only response was "I was outbid on this! So I bought another.You sent me this AFTER the auction!"
<0> hehe which doesnt even make any sense
<0> ebay is pretty clear who the winner is, i have a hard time believing he somehow mistakenly though he was outbid
<2> for debugging purposes, i'm trying to figure out how to call this stored procedure in another package. It returns a REF CURSOR. How do I correctly say x := functionName()? I don't know how to define x. Thanks
<2> this is oracle
<3> this is eric, *pats mike*
<2> doing this works but I don't know if i'm doing it right: TYPE REFCURSOR IS REF CURSOR;
<2> c REFCURSOR;
<2> that's the same line that's in the package in my anonymous block
<4> haven't looked at oracle since 8i and even then it was just a back end for a cold fusion ap
<4> there is an #oracle channel, but there hasn't been much activity there the last few days
<2> haha
<2> i'm not gonna try there
<2> i know there are a lot of smart oracle people in here
<2> i'll just wait
<2> and google more
<4> hehe, why they'd tar and feather ya
<3> Halo_Four : thanks for all the help, after all that BS, someone wrote a sproc that returned success in an unconvetional manner, that was it
<1> tenfour: oh well 60 cents
<1> what kind of **** do you sell by the way
<0> i was just selling random stuff
<0> cleaning out my closet of random computer parts
<5> so your computer is out of the closet now?
<3> I sold one of my organs on ebay
<3> true story
<6> ????
<6> how
<3> I just put it up there and someone bought it
<6> and
<6> u cut it out?
<3> I meant the musical instrument
<6> I could sell my feces on ebay. Keywords: excrements, ****, crap
<6> oh haha organs :)
<3> funny joke eh?
<6> yes indeed :)
<7> google for "vomit" --- you'll get eBay ads lol
<3> or what about used panties, always a crowd pleaser, if you have a fake photo with some girl wearing the same ones, people are stupid enough to but that for 50 bucks
<3> buy*
<7> hehe hilarious
<6> sorry
<6> TOS of ebay says
<6> no human parts/excrements/liquids
<6> you can sell dog **** there i think though
<8> hows it going folks
<8> i've got a table full of entries with both a date and ID
<7> alrighty
<8> i'm trying to setup a page where it staggers the amount of entries shown by date ranges... like, show only 3 months at a time, while getting the number of 3 month intervals to show and be able to select with accordingly
<8> not completely sure where to start.. i was originally thinking about getting the time span from the most recent entire to the oldest, and going from there
<8> but dont think that's going to help
<7> you'll need two procedures; one to fetch the intervals (likely so you can construct a Prev-1-2-3-4-Next hyperlink system, and another to fetch data based on the period
<8> yeah, that's what i was thinking, a pagination sort of system
<8> i guess the only real obstacle for me is how to query for the intervals
<8> i suppose the actual interval for each query isn't a big deal
<7> what dbms?
<8> what am i using to query the DB or what DB type?
<5> i wonder if scatter's given up on the rpg yet
<7> what DB type?
<8> one you folks hate... mysql.. but the idea is the same, so i don't care if it's not mysql specific
<8> i can adapt it accordingly
<9> livingeac, goto #mysql and ask
<7> group the data by quarters, then, should be simple; have the boundaries of the quarter then used for the range limits
<8> jarett, what i'm looking for is more of a concept, less execution
<10> In oracle, is it possible to fetch actual sql statments? or do they need to be cursors
<9> i would do it in 1 simple statement in oracle
<9> but in mysql you are screwed
<9> sivic, depends ont he language
<10> pl/sql
<8> TheGamble, wouldnt you generally have to do a check for the total length of time between the newest entry and oldest before you quarter it up?
<9> execue immediate "sql"
<9> execute
<10> where do the results go?
<9> you tell the command where to put them
<10> or are you saying to put that in the fetch statement
<9> google it
<7> no, just find out what quarters exist in your set, and build based on that
<8> ahh, i see
<8> i'll give that a shot, thanks for the help
<7> good luck
<10> jarett, does that increase server load any more than normal statements?
<9> sivic, no... but horrible plsql code and sql can hurt performance
<7> Jarett_, why is he screwed because of mysql?
<9> TheGamble, yes
<10> yes. my company does execution plans on everything i make, so if its not to their satisfaction its trash
<7> It was not a yes or no question, thx
<9> sivic, that means nothing. unless they are using outlines and profiles to force the plans to stay the same after every run
<9> even database load at different times, or different stats on objects will make a execution path change
<7> or different parameters
<10> im not sure. dont really know what the dba's really do but they email me execution plans for my code
<9> it isnt the DBAs job to tune your horrible code
<10> what makes you ***ume my code is horrible?
<7> Jarett_, you're just full of answers this evening, aren't you? How adorable.
<9> sivic, im thinking since you dont know about basics like execute immediate or how to run your own explain plans, you dont know sql either :P
<9> but most peoples sql is horrible
<9> just part of life
<10> well actually i do know sql. i dont know specifics about oracle. really never used it till they threw it in my lap.
<7> I'd still like for you to qualify for all of us exactly why livingeac is *screwed* because of mysql in his particular case.
<10> thank you though jarett, i believe this is what i want to use. just need to figure out if i can them multiple times nested in if statements so i can have only one execute.
<9> why not just use a sql that is a CASE statement?
<11> yar
<10> hmm.
<1> meh
<11> what's so funny?
<10> im not so sure if that would work, although it might
<11> so try it
<9> its the best option im thinking
<10> yeah i cant try anything now cause i gotta wait to be at work tomorrow to test
<9> oracle can 'tune' case better than plsql if
<1> i doubt it
<9> Quant, who was that directed to?
<1> that it optimizes case
<1> heh
<9> you would be wrong if you doubted me
<1> y
<12> hey guys
<9> but thats not a first
<1> prove it
<1> :)
<12> I'm looking for suggestions on synchronizing two databases, one belongs to a traveling agent, and the other is the home office. I can think of a couple ways, but I'm looking for something slick in postgresql. Suggestions?
<11> have you googled for "postgres replication"?
<12> Yeah, and but isn't replication two databases in constant communication?
<1> R e p l i c a t i o n
<11> yes
<12> Right, so the traveling agent's database is offline for long periods, and then comes back on to synchronize.
<1> depends what type of replication though
<11> Gambit-: then sync
<12> I didn't think this would fit under the general idea of replication
<11> I fail to see what's complex about this problem
<9> Gambit-, make a tiny 5 line script and cron it.. to check if its online.. if it is, do a simple export and import or remote sql
<10> man oracles case statements look freaking ugly
<11> it's just a matter of being methodical
<9> sivic, its very very very ver very basic
<12> Jarett_, It's not an overwrite, it's a merge
<9> Gambit-, and?
<9> fine.. 6 line
<11> Gamit: what is the actual problem?
<1> decode()
<12> Well I don't really see it being 6 lines :)
<11> Gambit-: me either
<11> but so what?
<1> replication is merge
<10> i dunno if i can use case statements, all these co-ops wont be able to figure it out
<9> co-ops?
<11> Gambit-: will rows in the master db be deleted?
<10> interns
<9> please tell me you arent the smartest one on the development team
Return to
#sql
or
Go to some related
logs:
#computers
#politics
movei woul
#stocks
#sex
#politics
#politics
#qmail
#dsl
beachvolleyball\games
|
|