| |
| |
| |
|
Page: 1 2
Comments:
<0> i want to graph some sql data i have.... can anyone recommend how to reformat the data and what application can graph for me using that format?
<0> what i mean is "graph" in the computer science way. nodes + edges.
<1> Probably academic or statistics programs capable of that
<0> do you know one by name?
<0> you're probably right
<1> My wife uses a program called Jump for stats. I don't know if that's what you're after, I don't really do that sort of thing.
<0> i googled it and found something called Graphviz
<0> that looks like what i need
<0> but thanks for the help
<2> If you get virus - Join Antivirus Cafe FREE! Join multiplayer game club with new Doom clones - members only - Visitors read importaint news from Alex Jones and TorrentChannel! Learn more >>> http://softfuturemagazine.com/
<3> lol
<4> QUestion: I need to make a list in SQL showing what web pages have more than one link. Since I am more a web designer than a database programmer, I could use some help
<5> i'm sure you can
<4> I can what?
<6> so mean.
<4> so I guess the whole "1) Dont ask if you can ask a question, just ask it." is just a bunch of crap. Guess I'll look elsewhere for help.
<5> you haven't asked any question
<5> rule #1 applies very much so
<5> even more so to people who comment on a question they haven't ask and then whine about not asking and expect an answer
<5> do you follow?
<5> ask=asked
<4> OK, than let me rephrase...
<5> don't rephrase a comment about a question you never asked
<5> try asking an actual question which can be answered
<5> it works out better
<4> How can I write, in SQL, a statement that that will tell me web pages with more than one link?
<4> that better?
<5> that question can not be answered
<4> ok, than I got my answer
<5> because sql servers are relational
<5> how are you storing the information
<5> explain your scheme
<5> in the sql server
<5> sql does not know html if that is where you are trying to get at terminus
<5> terrapin7
<4> I have a table that stores the webpage ID#, urls and Graphic ID#, and a table that stores COursework
<5> your column `urls` stores only 1 url correct?
<4> I need to show the webpages that go to more than one item in the coursework table
<4> yes
<4> thats correct
<5> ok
<5> select id# from table group by id# having count(*) > 1
<5> you can try something like that
<5> pseudo sql code, not meant to be copy & pasted
<4> ok, I'll give it a shot. Seems familiar, but maybe I wrote it wrong
<5> tell me what it does
<4> Thanks for the clue and I will try to clearly ask a question next time
<4> ok
<5> what i gave you isn't a clue
<5> it's pseudo sql
<5> a step below spoon feeding
<5> :/
<5> the better you can phrase a question, the better answer you get
<5> i think it is simple and fair
<7> how can i combine two columns for ordering?
<7> im using mssql
<1> What do you mean "combine"?
<1> ORDER BY can be applied to multiple columns. It can also be applied to expressions.
<7> like i have a column that has display order but there is an override display order column also from another table
<7> i need to order by the first column if the second one is null
<7> otherwise order by the second column
<7> can sql do this?
<1> Use a CASE expression
<1> Or just order by column2 then column1
<7> if i did it the second way
<7> say column 2 is null, null, 1, 3 and column 1 is 1, 2, 3, 4
<7> i want 1, 2, 1, 3
<7> order by that
<7> itll do that right?
<7> will it ignore those nulls?
<8> what?
<8> just do isnull(column,0)
<9> hrm ...
<9> whose good with XML/XPath?
<9> having a bit of an 'issue' ...
<9> <nzb><file><groups><group/></groups><files><file /></files></nzb> ... is the general layout of the XML file (some are familiar with this, probably ;p)
<9> but '/nzb/file' evaluates to nothing ... 'file', 'segment', 'group', all evaluate to nothing using XmlDocument.SelectNodes() in .NET ...
<9> I also tried validating the XPath expressions with an XPath expression demo I found that uses JSP ... and it returns nothing as well ... haha
<9> what am I doing wrong with the xpath expression?
<1> Is there a default namespace?
<9> <nzb xmlns="http://www.newzbin.com/DTD/2003/nzb">;
<1> Yeah, that's probably the problem.
<9> how so ?
<9> I have to specifically identify the xmlns as well?
<9> cause it may not always be the one I just displayed ...
<1> You have to at least alert XPath to it, yes.
<9> and it may not exist at all in some cases
<1> XPath is a finicky mofo
<9> so ... //nzb[@xmlns]/file ?
<1> I think there are a number of ways to do this.
<1> The first being to specify the namespace in the xpath query, which is verbose as Hell.
<9> hrm ... I'd rather not do that, as, like I said ... it may change ...
<9> and I don't want to hardcore the namespace ...
<9> I really don't care to validate the file against it's DTD ... as long as it's well-formed, I want to use it ...
<9> hell, if it's not well-formed, I still want to parse it ... haha ... but a well-formed document I don't need to write a SAX parser for ;)
<1> I know in .NET you can use an XmlNamespaceManager to prefix the namespaces so that you don't have to specify the whole thing, but I believe that in order for XPath to work you need to know/determine the namespace.
<9> grr ...
<9> ok
<1> You could probably do that by reading the document into an XmlDocument and parsing the attributes of the first element.
<5> moz doing this for fun or work?
<1> If you find a default namespace then prefix it with something determinate.
<9> Darken|: fun, lol ...
<9> ok ...
<9> XmlNamespaceManager doesn't find "http://www.newzbin.com/DTD/2003/nzb";
<1> messing with XML sure is fun ;)
<9> XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable); Console.WriteLine(mgr.DefaultNamespace); // nothing display; Console.WriteLine(mgr.HasNamespace("http://www.newzbin.com/DTD/2003/nzb";)); // false
<9> can I somehow strip the xmlns attribute from the nzb element before processing it?
<1> I don't know of an automatic way to do that.
<9> bah ...
<9> this blows ...
<9> I'll **** with it later ...
<9> time for some food
<1> XML standards are kind of obtuse in that way.
<5> xml is like a fat lady
<5> ... i don't like it
<1> It has it's uses. It does get overplayed, though.
<10> how does a fat lady get overplayed though?
<1> Plenty of fat guys to play a fat lady.
<11> man... that makes sense...
<1> Sad, isn't it?
<12> SQL2005: Since I cannot ***ign a default schema to a group (naturally, since a user can belong to more than one), what is the correct procedure for setting up Windows Groups as users in a database? i.e. how can I ***ure that each user will have the correct default schema, in this case 'dbo', as mandated by a tool?
<11> yeah.. especially when there are many people with fat-fetish
<1> more cushin' for the pushin'
<11> man... that "cushion"ning part i like. maybe i should give it a try
<13> lol
<11> i want my hands full of meat...
<11> i don't particularly like those chicks with skinny bones
<1> Skinny bones? Do your lovers have osteoperosous?
<11> uhm, nope... just fragile
<11> anyways, back to bed.. gnite
<8> break her ****ing leg
<12> that user "deaq", what did he do? (I'm no IRC pro)...was it that he tried to spawn too many connections instead of using his existing one for different channels?
<3> probably something like that
<3> could be something more obscure like something in the name/hostmask that identifies that login as part of a botnet..
<12> ah
<12> my IRC expertise begins and ends with getting on a channel and using it :)
<14> hello everyone :)
<14> i just made a view in mysql
<14> it has a join, how can i make it updateable?
<14> anyone?
<3> check with the online docs on mysql.com foo'
<3> maybe something in the create view clause
<3> maybe its not possible at all w/ your version
<14> version 5
<15> Help, tableName=[id,fielda,fieldb,fieldc]=>(1,'a','b','c'), (2,'a','b','c'), (3,'a','b','c'); How do i updating only 'limited' to the lastest value? Will its working: "UPDATE tableName SET fieldc='d' WHERE MAX(id)"
<16> nah thats wrong for sure ;P
<17> hello
<15> upb, can you help me fix that ?
<16> UPDATE tableName SET fieldc = 'd' WHERE id = (SELECT MAX(id) FROM tableName);
<15> ah... rite
Return to
#sql
or
Go to some related
logs:
#freebsd
#sex
pink pt cruiser
#freebsd
#hardware
eccentris mask
#nhl
#nhl
#beginner
nessus-adduser hangs
|
|