IRC Logs

Network: freenode Channel: #csharp

	Enter your search terms Submit search form
	Web www.irclog.org

[01:24]<pzw>well 150px feels good
[01:24]<pzw>150x150 would be enough
[01:25]<pzw>is it possible to check an image size of an image that is not on my server? Let's say that i let my users host their own Avatas and just give me an url, can i then check if the size is bigger than 150x150 and if so, resize it? :O
[01:26]<faccau>you would have to download it...
[01:27]<pzw>true..
[01:27]<pzw>Is image uploading easy from asp.net?
[01:28]<pzw>or file uploading in general
[01:28]<zgzzcydjvgev>uhh, isnt there a FileUpload asp.net control?
[01:28]<wyfaj>yes
[01:29]<pzw>cool
[01:29]<pzw>i have to take a look at that later :)
[01:29]<pzw>Kunnis: using stored procs now :)
[01:29]<pzw>gnite all
[01:39]<prsvfd>i have a DataSet containing two DataTables - would it be possible to perform an update statement of the sort "update tablex x, tabley y set x.foo = y.foo where x.bar = y.bar"?
[01:39]<prsvfd>creating loops and testing stuff seems so inefficient... any ideas please?
[01:40]<vynvyv>fastly: no
[01:40]<prsvfd>can't be done...
[01:40]<vynvyv>which row gets updated?
[01:40]<vynvyv>both?
[01:41]<vynvyv>that doesn't make sense
[01:41]<vynvyv>does x.foo become y.foo or the other way around?
[01:41]<vynvyv>ah that does make sense
[01:41]<prsvfd>x.foo becomes y.foo
[01:41]<vynvyv>forgot my sql for a second
[01:41]<vynvyv>i still don't think you can do that
[01:42]<prsvfd>so would need to loop and test each DataRow individually?
[01:42]<txnjzd>you tested?
[01:42]<vynvyv>i'm testing
[01:42]<txnjzd>I think you'll find you can :-)
[01:43]<prsvfd>Theory, can't find a way of executing a query against a DataSet.
[01:43]<prsvfd>i can't...
[01:44]<txnjzd>I've never touched the dataset stuff I have to admit
[01:44]<vynvyv>oracle can't do that
[01:44]<txnjzd>always used the database either directly, or through an OOP abstraction layer
[01:44]<sdnffdxdlld>aye
[01:44]<sdnffdxdlld>I tend to use datasets for holding data and do the changes on the db where its fast
[01:45]<txnjzd>tieTYT: oracle is clearly no match for powers of mysql ;-)
[01:45]<vynvyv>your statement is just wrong, use subqueries instead of 2 tables in one update
[01:45]<vynvyv>Theory: clearly
[01:45]<vynvyv>is that possible in mysql?
[01:45]<prsvfd>i have an xml file containing a list of countries
[01:45]<txnjzd>tieTYT: so I'm told
[01:45]<vynvyv>well i consider that gay
[01:46]<vynvyv>i don't think that follows standard sql practicies
[01:46]<kjr>>= 4.1 has subqueries
[01:46]<vynvyv>if mysql can do that
[01:46]<txnjzd>yes, you can
[01:46]<prsvfd>the point of this exercise is to count the number of locations in my database from each country and write this to the xml document..
[01:46]<txnjzd>update foo, bar set foo.foo = bar.foo where foo.bar = bar.bar;
[01:46]<txnjzd>this query works fine in mysql
[01:47]<vynvyv>Theory: ok well according to w3schools, that's not ansi sql
[01:47]<txnjzd>probably not :-)
[01:47]<vynvyv>and according to oracle too
[01:47]<kjr>how is that not ANSI?
[01:47]<vynvyv>Kog: update statement only has one table in it
[01:47]<kjr>one second, SQL92 finding
[01:48]<kjr>blast, EOL diff
[01:48]<vynvyv>but it's not like oracle follows ansi sql in anything else it does
[01:49]<vynvyv>the one thing they should make into ansi sql are analytical functions. Those are the winnar
[01:50]<vynvyv>update foo set foo.num = 5 where num in (select num from bar)
[01:50]<vynvyv>that's how you do the same thing in oracle
[01:51]<kjr>let's see... SQL92 provides: <update statement: searched> ::= UPDATE <table name> SET <set clause list> [ WHERE <search condition> ]
[01:51]<kjr>I guess <table name> provides singular
[01:51]<kjr>hm, I guess it does violate ANSI92
[01:51]<vynvyv>yeah
[01:51]<kjr>lemme know if you want a copy of SQL92... it's only ~1.3mb of txt
[01:52]<kjr>it can be a pain in the ass to find, so I just downloaded a copy and threw it on my keyfob
[01:52]<vynvyv>wouldn't do me any good since oracle probably doesn't obey it very well
[01:52]<vynvyv>i think i could say the same about every database
[01:52]<vynvyv>you find that useful?
[01:52]<kjr>oh yes
[01:53]<kjr>tieTYT: I'd tell you about the time I got in a 3 hour long argument with my boss about filtering cartesian joins via WHERE clauses violating SQL92 (in his opinion)
[01:53]<kjr>he was convinced that you must explicitly join and only reference one table in a WHERE clause
[01:54]<vynvyv>i use the SQL69 standard
[01:54]<vynvyv>or whatever the one before 92 is
[01:54]<kjr>I'll give you a hint, it's not 69 ;)
[01:54]<vynvyv>cause if you get oracle certified, they don't teach you the 92 stuff
[01:54]<vynvyv>so I don't get that INNER JOIN keyword or use it in my sql
[01:54]<vynvyv>but i'll admit it's better
[01:55]<kjr>I explicitly used it, instead of filtering in where clauses, yesterday
[01:55]<vynvyv>with sexy results?
[01:55]<kjr>well, they do equivocable things
[01:55]<vynvyv>yeah but you can do more with it
[01:55]<kjr>not necessarily
[01:56]<vynvyv>for example, a full outer join that actually makes sense
[01:56]<vynvyv>you have to do crazy shit to do that with SQL69
[01:56]<kjr>huh? a full outter join isn't an inner join
[01:56]<vynvyv>at least with oracle
[01:56]<azyfm>MSSQL2005 won't even let you do the old-style outer joins without setting a compatibility switch
[01:56]<vynvyv>i know
[01:56]<vynvyv>i was using INNER JOIN as an example of the SQL92 stuff
[01:56]<kjr>Arild: wow... how shitty
[01:56]<kjr>Arild: so they just want multiple FROM identifiers, and a large WHERE clause?
[01:56]<azyfm>old inner joins work, though
[01:57]<kjr>oh... I misread outer as inner
[01:57]<kjr>haha
[01:57]<vynvyv>ah
[01:57]<vynvyv>also, i think with the sql92 you can do an outer join on an in list
[01:57]<vynvyv>you can't do that with sql69
[01:57]<vynvyv>at least in oracle

Back to #csharp
Or go to some related logs:
#php
#gentoo
#gentoo
#azureus
#php