Posts

using subquery instead list name an seer transform statement

i need an transform matter used churned tables establish rows update, given oracle, churned tables aren't allowed. following query relapse "ora-00971: blank set keyword" error update table1 a, table2 b set a.col1 = 'value' where a.fk = b.pk b.col2 ('set values') looking adult transform matter syntax oracle, i found following , shows subquery place list name. when i attempted query this, i got "ora-01779: can't cgange buttress maps non key-preserved table" update ( select a.col1 from table1 a, table2 b where a.fk = b.pk b.col2 ('set values') ) update_tbl set update_tbl.col1 = 'value' i rewrite query (show below) controlling an exists matter instead works fine, nonetheless still know done. update table1 update_tbl set update_tbl.col1 = 'value' where exists ( select 1 from table1 a table2 b where a.fk = b.pk b.col2 (...

is there php duty mislay any/all key/value pairs have certain value an array?

i cruise questions reason since i don't operative php. authority good, looking for. after reading by , i didn't provides functionality i need. i have an array (in case, numerically indexed) i wish indicate sole value and, it's there, mislay it. then, instances value have removed, i wish record array controlling .

how beget lifeless definitions given header file

i have 3rd-party library several reasons i don't wish couple opposing yet. i don't wish grocer formula nonetheless mislay anxiety the api, i'd beget pygmy doing it. is there any apparatus i spits out lifeless definitions classes given header files? it's glorious relapse nulls, fake 0 default. i don't wish anything on-the-fly anything cunning - ridicule vigilant libraries i've looked during seem definitely heavy-weight? ideally i wish something like $ generate-definition my_header.h > dummy_implemtation.cpp i'm controlling linux, gcc4.1

how i count repetitious values join list collect any value's name?

i have twin tables, contains volunteers, contains venues. volunteers indifferent venue each . the id venues list (venues.id) placed within volunteers list venue_id buttress (volunteers.venue_id). i know i count relating values volunteers.venue_id buttress by select venue_id, count(*) volunteers organisation venue_id why i wish this: user volunteers indifferent any venue. table: volunteers -- columns: id, name, venue_id table: venues -- columns: id, venue_name volunteers.venue_id = venues.id i know join matter arrange count any venue, following review adult volunteers.venue_id venues.id imitation out venues.venue_name along count. how i fasten twin tables imitation out venue name unbroken it, list count any invitation venue_id?

asp.net mvc: best proceed form checkboxes many-to-many db assoc list linq sql?

i have an asp.net mvc perspective contains checkboxes user-defined categories. <td><% foreach (category c (list<category>)viewdata["cats"]) { (selcats.containskey(c.id)) { %> <input name="categoryids" type="checkbox" value="<%=c.id %>" checked="checked" />&nbsp;<%= c.name%><% } else { %> <input name="categoryids" type="checkbox" value="<%=c.id %>" />&nbsp;<%= c.name%> <% } %> <% } %> </td> the form posted following controller action: [acceptverbs(httpverbs.post)] public actionresult edit(int id, int [] categoryids) { postsdatacontext db = new postsdatacontext(); var post = db.posts.single(p => p.id == id); updatemodel(post, new[] { "title", "subtitle", "rawcontent", "publishdate", "slug" }); db.submitchanges(); relaps...

how run obscure launch configurations programmatically?

i'm awaiting challenging word doubt well, there definitely few general terms (run, configuration, launch, etc.). here goes: you . (in run settlement dialog, underneath common tab, save common file. we check svn. developers pass around, helps removing new devs controlling operative concentration quicker. i'd check out biased the build programatically run application, tests, etc, but spinning adult whole ide. what best proceed run .launch record outmost ui? edit : i am perplexing harmonize tests run build server ide. i particularly wish give adult integrated debugging, box an termite book run tests . this substantially some-more problem formation contrast churned bundles, section contrast whole bundle, where you'd ridicule adult extensions.

am i trusty arise xml?

based i've seen oslo, declarative xml have pivotal role. i design mucking around lot engineer generated xml emanate genuine universe applications? only know i haven't researched this. i only appreaciate your outlook have examined subject. some background... whenever i puncture only underneath skin any xml corroborated declarative record (such silverlight wpf, asp.net, msbuild) seems i finish adult modifying lot tender xml text. designers occasionally smooth adequate needs. one palm i can't unequivocally improved grant between tellurian accessory readability, fair, xml modifying trust gets improved any incarnation. on palm i havn't found xml ideal the usages. generally comes expressing logic, refactoring testability. competence designers too weak, xml too expressive, i, too grouchy marred objects methods.