| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> yupz
<1> okay
<1> you should NOT need ODBC for that
<1> just make sure that mysql is listening on the proper port
<1> make sure that the port is not being firewalled
<1> and then simply make sure that whatever you are using aka not java
<1> but something like php or C has inherrent support for mysql
<1> if you are using something like java or something that odes not have inherent support for mysql
<0> problem is i'm just starting out
<2> make sure the port is open to teh internetz
<1> then YES you need it
<0> using the ado components
<1> XenReborn what langauge are youusing ?
<1> php on your linux server?
<0> no delphi on my windows boxes
<1> what is going onthe unix server
<1> *linux
<3> haha
<3> open to the internetez
<2> ;)
<3> arrakis is the best
<1> open to my internutz
<1> i am not
<0> anywaayyss
<0> imm go to bed
<2> Does your version support SELECT?
<3> gnite
<0> before my head slames into my keyboard
<0> goodnight all :)
<2> night
<1> nini
<3> arrakis: are you gay by any chance?
<1> I have been questioned numerous times about my ***uality
<1> and all i can say is that women turn me on
<1> and i like madonna
<1> the prince
<3> what about meh
<1> micheal jackson
<1> other 80's music
<3> men
<1> along with other stuff
<4> <3> what about meh
<1> no men do nothing for me
<1> sorry
<4> haha was that a slip?
<1> lol tenfour
<1> NO
<3> hahaha
<3> meh
<3> haha
<1> HE
<1> haS A CRUSH ON ME :(
<3> no man, the two letters are close
<2> wtf
<3> <+Arrakis> nini
<2> ah
<2> check this hilarious diversion: http://www.craigslist.org/about/best/sfo/27499971.html
<3> arrakis is the best
<1> lolz
<1> i've seen that a few times
<1> but it never gets hold
<2> heh
<2> I love it
<2> "shaking down bums in the Loin for a sliderule"
<1> lol
<1> i didnt quite get all that one but it was funnyu never the less
<2> this pretty much tells the sordid tale: http://www.tenderloin.net/
<3> i guess iam too tired
<3> i dont get it ;(
<2> It's a San Fran neighborhood full of bums
<1> hahahaha
<1> i wouldnt want to shake one of those guys up
<1> they might decide to take a piss on me
<3> and rightfully so
<2> heh
<2> and no slide rule out of the deal, either
<1> i doubt manyof them inw what a slide rule is
<1> huhu
<2> indeed
<2> public static functions give me the warm and fuzzies
<5> I can install both SQL Server 2000 & SQL Server Express2005 on the same machine, right ?
<6> giving a table a numeric primary key is a good idea even ifit sometimes is referenced by a key which is a string?
<7> depends on the actions you do on the table, but yes, and convert the string to an int (in code) before comparing
<7> by actions I mean: if you do 99,9% inserts, and one compare a day, then no primary key will be faster
<7> damn my usb key is falling apart, where's that ducktape...
<6> good call onthe int.
<8> If I'm creating a web application, would it be considered inefficient to keep loading the same data from the database everytime the user changes pages? Or do most databases cache the request so it is efficient enough?
<8> e.g. data from a shopping cart... if the shopping cart items are supposed to be shown on every page, how would I go about loading the names of the items? should I keep re-requesting them from the database everytime the user goes to another page?
<6> non0: hot databases like oracle run best when its m***ivly queried
<9> can I return a @table from MsSQL SP?
<10> Hey I need to copy fields from a dynamic table for one record into another... Without knowing how many of the dynamic columns there are, how might one do that?
<10> any ideas?
<11> Kranfer: what rdbms
<10> well
<10> we use MSSQL
<10> and oracle
<11> any way we can just start banning people who dont state that?
<10> heh
<12> for mssql:
<12> look at syscolumns
<12> sysobjects
<12> search for dynamic sql and you will be using execute and/or sp_executesql
<12> oracle... go figure
<10> heh
<10> I've never used syscolumns
<12> great time to learn
<12> :)
<10> does it work as like select * from syscolumns where name='tablename'?
<12> why dont you do some research on it?
<12> look it up on google
<12> look it up on bol
<10> I've gotten it
<12> and see how it works
<10> Interesting
<10> Wonder if there is anything like this for oracle
<12> im sure there is
<12> although i wouldnt know
<12> did you look at the documentation?
<10> looking at pl/sql's stuff now
<10> select * from all_tab_columns where table_name = 'TABLENAME' works for Oracle
<10> little better than joining sysobjects and syscolumns in mssql
<12> dba_objects,dba_views,dba_tables...
<10> could use those too I suppose
<12> well if you do more research you will find a function called Object_id in mssql
<10> object_id?
<10> hmm
<10> that could possibly be different from client to client for each table I would think though
<12> what are you talking about?
<12> do you know what object_id gives you?
<10> I have no idea... I would think that object_id it the id of the table?
<10> err it = is
<12> why dont you stop guessing and look it up?
<12> figure it out?
<10> :P
<12> dont expect to be spoonfed here
<12> if you dont wnat to take the effort to help yourself why should i waste my time helping you?
<10> I'm looking for it geeze
<12> no you are already telling me how it might not work without actually figureing out what it actually does and you are only looking because i told you to. I shouldnt have to tell you
<6> whoa, people talking
<12> lol
<10> Interesting
<6> These people kill with spoons.
<13> insert into table select * from othertable
<6> no feeding done.
<10> works better than joining I suppose between sysobjects and syscolumns
<10> Nice :)
<5> SQL Server:I have encoding problem while BULK INSERTing, how to solve it ? .. german language chars are not inserted correctly.
<14> is there any way to dump what i get with select to a file with just sql(oracle) or do i have to use pl/sql?
<15> How are you running the sql?
<14> its just a theoretical question right now. im looking or possible ways to solve it
<16> Solve what? Did I miss something?
Return to
#sql
or
Go to some related
logs:
full of another mans
#unixhelp
transparant proxy centos
#stocks
#politics
#unixhelp
#gamedev
#worldcup
#slackware
#winxp
|
|