| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> anyhow ... personal opinion of myself ...
<0> everyone's entitled to talk how they like ...
<0> if i think you sound like a moron, thats my issue, not theirs ... and I can giggle and laugh behind their backs ...
<1> zoul: haha
<2> what is PERL
<3> I generally hate people that pronounce acronyms, period.
<2> lol
<1> Pujol: pronounced purl
<2> haah
<1> ish
<2> how about RUBY
<2> how about JAVA
<1> goddarnit :P
<4> what about OK?
<2> zoul was wrong and he can't admit it
<2> i p0wnd him
<0> YuppieScm "OK" is pronounced "O K" ...
<2> how about NORAD
<0> Pujol stop ****ing referencing words that are NOT acronyms
<0> JAVA is not a ****ing acronym ...
<4> Pujol : zoul was not wrong - he's entitled to his opinion
<2> NORAD is
<0> J A V A ... means ****ing nothing
<4> Pujol : however, his opinion is wrong
<2> how about the SAG awards
<2> hey
<4> hey zoul, that one was fair comment
<0> YuppieScm what was? the repeated attempts at trying to figure out how i pronounce different things?
<0> half of which were actually words?
<2> thanks
<4> SAG was fair
<4> screen actors guild
<0> SAG is 'S A G'
<2> what about that show JAG
<4> pronouced 'sag'
<0> I don't call the screen actors guild 'sag'
<3> How about XML? How about TCP? How about IP?
<0> Drk`Angel heh
<3> Some acronyms are acceptable pronouced as words. Some aren't.
<4> well, you're entitled... that doesn't make you right tho
<0> Pujol I call 'JAG' 'jag' because thats how the show creators call it ... they created the name of the show, they define how it's pronounced ...
<2> what about NATO
<0> my name is 'David' but it's pronounced 'Dave', it's my name, I can tell you to pronounce it however I want it pronounced
<0> Pujol did you read the kick comment?
<4> zoul : that's nothing to do with the show's creators - the military acronym has existed for about 100 years or so
<2> zoul: i'm afraid the comments weren't on my RADAR screen
<3> Pujol: Like I said. Some acronyms are acceptable pronounced as words. Some aren't. They're not all the same.
<4> hahahahahaha
<2> hey
<4> no fair
<4> that was not only valid, but also funny
<0> well, maybe his RADAR can see the bleeps now
<0> YuppieScm and my come back was just as sarcastic ;)
<0> the bans are auto-rejoin retardents only ...
<3> Yeah, but Pujol's as annoying twat, who probably shold have been kicked back when he was talking about how real databases don't need transactions. :p
<4> what? he said that?
<0> Drk`Angel exactly
<2> innocent trolling Drk`Angel
<0> if Pujol wasn't an out right idiot, I'd be taking his comments more lightly ...
<0> now THAT was funny
<2> heh
<2> bit of joking never hurt anyone
<1> :)
<4> thank you, thank you, i'll be here all week - try the veal
<0> YuppieScm did you miss the whole part where Pujol asked for help with a mysql query? then insisted that mysql was ansi compliant ... ?
<1> i love the word "twat"
<4> i did miss that
<2> come on zoul i was just playing around
<4> only arrived when i op'd myself
<3> Off with his head! :)
<0> Pujol we take our mysql beatings quite seriously ...
<4> just got in from work
<2> don't kick me again or you'll mess up my SCUBA gear
<4> hahahahaha
<0> just be lucky with isn't the middle east, or I'd of stoned you an hour ago
<1> heh
<4> hm.... stoned
<4> brb
<3> heh
<2> man have you seen what OPEC is doing with oil prices lately?
<2> allright allright, back to wokr
<5> hey all let me run a problem by ya, the guys in #asp are afk/stumped
<5> i'm pulling info from a csv file that has a field named PhoneNo. (with the period on the end). I Cannot change this as it is explorted out from some archaic mainframe system. i'm putting my data into a recordset and trying to call this field. rs("PhoneNo.") doesnt work and neither does rs("[PhoneNo.]"). any ideas what I should be using?
<6> what's your db?
<5> a csv file
<6> and did you check to see the exact field name in the db?
<6> wait...
<5> yes
<6> how are you pulling into recordset?
<5> uhm using a adodb connection
<6> did you loop through that collection by field or index to see what name it gave that field?
<6> uhh...recordset
<6> jesus I can't talk straight
<4> ken- : what is the target database?
<5> mssql, and no i have not tried that
<6> ken: I ***ume it just modified the name somehow
<5> would the recordset ignore the . or something?
<5> hm
<4> **** ado, just use bcp. bcp has a parameter to ignore the forst n lines of a file
<5> i dont want to ignore lines lol
<4> ken- : i'm gonna get angry with you again in a moment
<6> besides, he didn't even say he was importing to sql server...
<6> just ado to csv
<4> csv is not a database. csv is JUST a flat text file
<4> it doesn't have column names
<5> yes i know the first line are the headers
<4> are you treating the first row as headers?
<5> yes
<6> but if you are reading it, all fields have a "name" property...something got put there
<4> then ignore the first row, and use bcp to import the file
<5> well i'm not familiar with bcp and that sounds like a pain in the ***
<4> or even just open the file as an input stream, and parse it
<4> no need or reason to open it as if it were a database, using the Jet text-file drivers
<4> ken- : go look at bcp
<5> is there something inherently wrong with trying to use a recordset?
<4> read the doxs on bcp?
<5> uh first of all I requested you get opped lol second why is it that every time i ask a simple question you suggest i completely rewrite the code
<5> god its annoying
<7> heh
<8> ?
<8> Ken
<4> the right way to import bulk flat file data into ms-sql is to use bcp
<8> why are u making YuppieScm angry ?
<4> the wrong way is to open the file via jet text-file drivers and treat it as a database via ado
<4> actually, that's one of several wrong ways, but there you go...
<5> i'm not importing a 10,000 entry file or anything this is just a quick thing i don't really have the time to learn something new to do something simple
<4> then why are you trying to do something simple in the most complicated way?
<5> i wasn't aware a 10-line script was complicated
<4> well, it is for you, as you can't get it working
<4> bcp is a single command line
<4> instead of arguing, why not just look at the documentation for bcp
<4> ?
<5> because this was supposed to be delivered an hour ago
<4> then you'd better hurry
<6> why not just import the ****ing thing directly to your db then?
<6> don't need ado or bcp
<4> which is, after all, what bcp does
<6> although bcp is the best solution
<5> they want a script they can run to update it daily
<5> they are idiots i dont know they are paying us to write a script
<4> still no reason not to use bcp
<4> that's what it's for...
<6> hell, do it in dts and it'll write the vb code for you...but like he said, this shouldn't be done in code
<5> yuppie i understand that may be a better way i just dont have time to learn bcp lol
<6> if you are just trying to save your *** in an uncool way...do what I said and find out what it named that field
<3> ken-: Less talk. Yuo'll get done faster.
<4> ken-, you could have 'learned' bcp in the time it's taken since i first told you to use bcp
<4> which was approx 10 minutes ago
<4> instead, you've chosen to bitch and moan that we're not 'helping' you...
<4> ken- : you requested i be op'd? when was this?
<4> hey pose : hny, etc
Return to
#sql
or
Go to some related
logs:
#mirc
#stocks
#nhl
ace foot productions pass
eggdrop tcl runescape
#nhl
#dsl
rhel iso
#visualbasic
pastebin eggtcl
|
|