harsh

i have following code seems long winded - i'm doing same thing each file figured there must method simplify alludes me @ present! appreciated always: .lvb.sf.1.1 <- read.csv("lvb_sf_1-1.csv", header=t, sep=","); .lvb.sf.1.6 <- read.csv("lvb_sf_1-6.csv", header=t, sep=",") .lvb.sf.1.2 <- read.csv("lvb_sf_1-2.csv", header=t, sep=","); .lvb.sf.1.7 <- read.csv("lvb_sf_1-7.csv", header=t, sep=",") .lvb.sf.1.3 <- read.csv("lvb_sf_1-3.csv", header=t, sep=","); .lvb.sf.1.8 <- read.csv("lvb_sf_1-8.csv", header=t, sep=",") .lvb.sf.1.4 <- read.csv("lvb_sf_1-4.csv", header=t, sep=","); .lvb.sf.1.9 <- read.csv("lvb_sf_1-9.csv", header=t, sep=",") .lvb.sf.1.5 <- read.csv("lvb_sf_1-5.csv", header=t, sep=","); .lvb.sf.2.0 <- read.csv("lvb_sf_2.csv", header=t, sep=",...

i not sure how happened, have primary key constraint on 1 of tables , name null. discovered because had drop/recreate table, , when tried add primary key, system responded constraint existed. i executed following: select i.object_id, i.name, i.type_desc sys.indexes inner join sys.tables t on i.object_id = t.object_id , t.name = n'organization' and result is: object_id name type_desc 1570377655 null heap 1570377655 ix_organization_ownedbyorganizationid nonclustered i tried dropping , recreating table several times , each time index there. how can drop constraint? you can try find index trying add using following query: select [table] = t.[name] , [index] = i.[name] , i.* sys.indexes inner join sys.tables t on t.[object_id] = i.[object_id] martin has right answer index find null name.

edit: issue not having comma after timestamp suggested in comment. timestamp not variable , postgres keyword convert time , date timestamp data type before inserting it. similar cast. i have following sql query in postgres , works no errors: insert sms (from_number, to_number, message, reply_time, sent_at) values ('10000000000', '0000000000', 'ffffffff', now(), timestamp '2015-05-27 18:45:31') i have function in php equivalent query: function insertwithsenttime($from, $to, $text, $senttime) { $con = pg_connect("host=$this->host dbname=$this->db user=$this->user password=$this->pass") or die ("could not connect server\n"); $query = "insert sms (from_number, to_number, message, reply_time, sent_at) values ($1, $2, $3, now(), timestamp $4)"; pg_prepare($con, "prepare1", $query) or die ("cannot prepare statement\n"); pg_execute($con, "prepare1", ar...

i using local gradle of version 2.4 , intellij idea 14.1.3 when run project intellij runs fine when execute gradle clean build command command line gives flowing exception , build fails. failure: build failed exception. * went wrong: execution failed task ':app:mockableandroidjar'. > java.util.zip.zipexception: invalid entry compressed size (expected 2051 got 2050 bytes)

ember makes use of router.js load resource , corresponding template application template. happens when particular route accessed? i.e how ember know accessing route not resource? google question, you'll find lots of answers. or, read source code. basically, resource resets directory path ember looks relevant assets @ top level of project. if have "authenticated" route checks authentication, , under have "users" route, you'll want make resource can keep "user" related assets such controller, route , template in user directory @ top level instead of under "authenticated" directory.

i standard library in delphi xe8 if assigned(jsonvalue) case jsonvalue.valuetype of jsarray : processarrayresponse(jsonvalue tjsonarray); jsobject : processobjectresponse(jsonvalue tjsonobject); end; end; (this sample come https://github.com/deltics/delphi.libs/wiki/json using deltics.json library). does know how standard library ? thank you you use is operator: if assigned(jsonvalue) begin if jsonvalue tjsonarray processarrayresponse(tjsonarray(jsonvalue)) else if jsonvalue tjsonobject processobjectresponse(tjsonobject(jsonvalue)); end; if want use case statement have create own lookup: type jsonvaluetype = (jsarray, jsobject, ...); function getjsonvaluetype(jsonvalue: tjsonvalue): jsonvaluetype; begin if jsonvalue tjsonarray exit(jsarray); if jsonvalue tjsonobjct exit(jsobject); ... end; ... if assigned(jsonvalue) begin case getjsonvaluetype(jsonvalue) of jsarray : processarrayresponse(tjsonarray(jsonval...

i'm using apache camel route receive incoming http traffic using servlet component. route simple: <camel:route id="peoplesoftservletservice" errorhandlerref="errorhandler"> <camel:from uri="servlet:///peoplesoftservice" /> <camel:setheader headername="origin"> <camel:simple>peoplesoft server: ${in.header.x-forwarded-for}</camel:simple> </camel:setheader> <camel:inonly uri="activemq:peoplesoft" /> </camel:route> i'm encountering problems stream caching. i'm not explicitly using stream caching, seems using servlet component, camel httpconsumer implicitly created behind scenes , registered servlet via camelservlet.connect(httpconsumer consumer). want disable stream caching (which turned on default) on http endpoint of consumer, typically done using uri parameter ("disablestreamcache"). since i'm not explicitly creating endpoint in case, don...