MarkLogic 8 - Node.js Client API - Can I do a SPARQL Query?

The MarkLogic node.js client API can evaluate SPARQL queries. See the jsdoc here: http://docs.marklogic.com/jsdoc/graphs.html#sparql Update: here's a full example: var marklogic = require('marklogic') var config = { /* ... */ } var db = marklogic.createDatabaseClient(config) db.graphs.sparql( 'application/sparql-results+json', 'select ?s ?p ?o\n' + 'where { ?s ?p ?o }\n' + 'limit...

How to get the block height with zero-height blocks with margins inside

jquery,html,css

When inspecting the HTML in a browser (here Chrome), the wrapper div has a height of 200 and the divs three and four have zero height, although their margin is indicated below the wrapper div. As soon as the divs have content, their height is different from 0 and adds...

Allow console application to access Windows Authenticated web app

c#,asp.net,asp.net-mvc,iis,asp.net-web-api

Use UseDefaultCredentials: var client = new WebClient { UseDefaultCredentials = true }; client.DownloadString(address); this will use whatever the console app is running as (which can be specified on the Scheduled Task settings)....

Disabling tkinter ttk scale widget

python,user-interface,tkinter,ttk

For ttk widgets you use the state method. The state method for buttons and entry widgets are just a convenience function to mimic the standard button and entry widgets. You can rewrite your function like this: def disable_widgets(parent): for child in parent.winfo_children(): child.state(["disabled"]) ttk states are mentioned in the ttk...

Function dup2(int oldfd, int newfd) fails in for() loop

file,strace

It's the spurious terminating ; in line2 - remove it! Your loop will run until 10 while doing nothing (the final semicolon means an empty statement), and then the command in braces executed once.

Using factory to expose a simple API

javascript,angularjs,factory

I don't see anything wrong with your factory. If I understand correctly you want to add functionality. A few small changes would make this possible. Here's what I'd do (note that calling getAllUsers wipes out any changes): app.factory('usersFactory', ['$http', function ($http) { var users = []; return { getAllUsers: function()...

Is there a way to display different content on mobile vs. desktop in Rails?

ruby-on-rails

Yes. Mobile Fu is a rails gem that allows you to do this. You just need to check if the request is from a mobile device and subsequently render whatever you want to based on that. If you're on Rails 4 this might be helpful too....

Are there drawbacks to leaving a SqlConnection open long-term?

windows,service,ado.net,sqlconnection

Database connections are considered an "expensive" resource, and as such should be opened only when needed, and closed immediately thereafter. As a result, opening a connection early and persisting it would go against that philosophy. Additionally, doing so prevents your underlying framework from making best use of whatever variety of...

Color Spectrum Optimization

javascript

Try picking random colors function colorSpectrum(N) { var colorMap = []; for (i = 0; i < N; i+=1) { var color = getRndColor() colorMap.push("#"+color); } return colorMap; } function getRndColor() { var n = Math.floor(Math.random()*255*255*255); var hex = Number(n).toString(16); while(hex.length < 6) { hex = "0"+hex; } return hex;...

Ruby, update twitter avatar and background

ruby-on-rails,ruby,image,twitter,avatar

have you followed the api docs? i can't see you encoding anything base64. The avatar image for the profile, base64-encoded. Must be a valid GIF, JPG, or PNG image of less than 700 kilobytes in size. Images with width larger than 400 pixels will be scaled down. Animated GIFs will...

using array_push to add key/value element to array

php,arrays

You could put them into the array like this. I think it would create the output you desire. if(array_key_exists($key, $output)) { $output[$key]['volume']=$temp[1]; //array_push($output[$key], array( 'volume' => $temp[1] )); } else { $output[$key]['score']=$temp[1]; //$output[$key] = array( 'score' => $temp[1]); } ...

MySQL: sum session times via students, via program

mysql

In your inner SQL Statement: SELECT students.program_id AS stu_id, TIME_TO_SEC(TIMEDIFF(time_out, time_in)) AS session_sum FROM students INNER JOIN sessions ON students.id = sessions.student_id GROUP BY students.program_id You GROUP BY students.program_id but you don't give any aggregate function for your session_sum and this case MY SQL's default behaviour is that you only...

Cornice schema validation with colanderalchemy

python,validation,sqlalchemy,pyramid,colanderalchemy

This appears to be due to the issue of colander having both a typ property and a schema_type property. They're both supposed to tell you the schema's type, but they can actually be different values. I filed an issue with colander, but if there's a fix it'll likely not make...

Building QtWebEngine for Raspberry Pi2 using Yocto Poky - vcos_platform_types.h: No such file or directory

chromium,raspberry-pi2,yocto,qt5.4,qtwebengine

Add the dependencies in your own .bbappend as such: [email protected]:~/yocto/poky$ more meta-embarcados/meta-rpi/recipes-qt/qt5/qtwebengine_%.bbappend CXXFLAGS +=" -I${STAGING_DIR_TARGET}/usr/include/interface/vcos/pthreads \ -I${STAGING_DIR_TARGET}/usr/include/interface/vmcs_host/linux \ " # Do not get out of memory LDFLAGS += "-Wl,--no-keep-memory" The issue is discussed in length here Tutorial to create Yocto distro for RPi2 that contains QT5.4...

Match first word then remove it from string with PHP

php,regex

Preg_match can capture, preg_replace can replace. I'd use the preg_replace_callback, http://php.net/manual/en/function.preg-replace-callback.php, to store your value and replace the original. I also modified your regex a bit you can swap it back to the \w if you find that is better. That will allow the line to start with - and...

Adding image to GridView created in CodeBehind

c#,asp.net,gridview,datatable

You can make use of <asp:ImageField/> within the the Gridview to achieve this. So your markup will look like <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false"> <Columns> <asp:ImageField DataImageUrlField="Value" ControlStyle-Width="100" ControlStyle-Height="100" HeaderText="My Image" /> </Columns> </asp:GridView> In your C# code you can use List to add the images. So something as simple as...

I want to compare 2000 data cells with 3000 other data cells in excel, but this takes very long

c#,excel

You are paying a huge overhead by doing the comparison inside Excel. What you should do is extract the data and compare it directly in your application. The easiest way to do this is to convert Excel ranges to arrays: var rowAArray = objsheet.Range["A1","A2000"].Value; //object[,] typed array var rowBArray =...

Temporarily declare a word as wrong in vim spellchecker

vim,spell-checking

Vim spell cheat sheet: ]s / [s - next / previous misspelled word ]S / [S - next / previous bad word (i.e. as above, but ignore rare words and the like) zg - add good word to the first dictionary in spellfile; remove it with zug zG - add...

Spring Boot Actuator Health Returning DOWN

spring-boot

In your Spring properties, set endpoints.health.sensitive = false. The /health endpoint will then return the list of various health indicators and you can debug from there. For a production environment you should enable security around the /health endpoint....

Calling a variable in Matlab without using the full name? [closed]

matlab,variables,filenames

Sure, you can use fieldnames to get a list of names, do your matching, then grab the field you want: f = fieldnames(Data01); match = regexp(f, '^SubData.*'); fieldnum = find(~cellfun(@isempty, match)); subdata = Data01.(f{fieldnum}); If the confusion is at the top level rather than at the substruct level, you can...

Polymer core-localstoreage TypeError: Cannot read property 'save' of undefined

polymer,material-design

You are looping the creation of a static ID tag, and because you shouldn't have duplicates of an ID, it is throwing an error. Lines causing the issue: <template repeat="{{data}}" > <core-localstorage id="storage" name="codelab-app-storage" value="{{data}}"></core-localstorage> </template> ...

admin registered staff user can't login django admin, form registered staff user can't

python,django,django-forms,django-admin,django-authentication

phew, I had to add something like this: AUTHENTICATION_BACKENDS = ( 'django.contrib.auth.backends.ModelBackend', ) ...

Why is this floating point addition result not correct?

c,floating-point,printf,addition

According to IEEE 754 encoding, many numbers will have small changes to allow them to be stored.Also, the number of significant digits can change slightly since it is a binary representation, not a decimal one. Single precision (float) gives you 23 bits of significand, 8 bits of exponent, and 1...

How to add an Option label on ListBoxFor HTML Helper in ASP.Net MVC

asp.net-mvc,asp.net-mvc-4,html-helper

The reason that Html.DropDownListFor() has an "option" parameter is that dropdown lists, when they don't have a selected value, are blank and you can't see their contents without expanding them. Listboxes, typically do display their contents, and thus an option is not necessary. An unselected listbox doesn't need something to...

Rails + Heroku + Cloudflare - Eliminate www as a subdomain

ruby-on-rails,heroku,cloudflare

I had to remove the A name record in CloudFlare and replace it with a CNAME record. I also added 2 additional CNAME records: one wildcard and one for www.

write a javascript function that displays html

javascript,function

Avoid using document.write for this (and probably for anything else). The right approach here is to add child elements to their containers. So, for the first part, assuming that the table is the direct child of the body, you can do something like document.body.appendChild(generatedTableElementHere);. Then, for the next part, the...

How to format % and in 2 decimal points?

sql,sql-server,sql-server-2008

You can convert to a decimal your original value: CONVERT(VARCHAR(20), CONVERT(DECIMAL(18,2), SUM(qa.scripting1+qa.conduct1+qa.conduct2+qa.conduct3)*100.0/46) ) + '%' as 'C%' The first number in the decimal represents the number of digits in the number including decimal places, and the second number represents the number of decimal places....

Represent string as an integer in python

python,string,encoding

Here's how to turn a string into a single number. As you suspected, the number will get very large, but Python can handle integers of any arbitrary size. The usual way of working with encryption is to do individual bytes all at once, but I'm assuming this is only for...

Defining an object property value based on other property

javascript,jquery

I agree - it's not entirely a duplicate, since you're asking why - not how. The reason you can't do this is given in the error - the object you're referring to isn't yet defined. Whilst you've assigned an empty object to Example, you're then immediately trying to set it...

Eclipse + Wildfly + Maven EAR project, is it possible to have files update without redeploy?

eclipse,jsf,jsf-2.2,wildfly-8

Don't wan't to disagree with BlagusC (the one and only here ;-) ) but for normal changes "hotdeployment" should work fine. Only if you change backing beans structure (e.g.: add methods, add classes) restart is needed. Important thing is that you start the server in debug mode - here are...

Don't produce report if there is no data - PDF

reporting-services,report,suppress

If you are distributing your report using subscriptions and you have Enterprise Edition, then you can look at using Data Driven Subscriptions which will give you control over how and when reports are distributed based on whatever logic you need. Otherwise, there is no way to do what you are...

Class atributes not updating [node.js - express ]

javascript,node.js,class,express,neo4j

.save is asynchronous, so you can't use the value returned by it outside its callback, hence moving the rest of your code inside the callback will fix it: var t = this; this.db.save(vals, function (err, node) { if (err) throw err; vals = node; console.log("2:"); // output print console.log(vals); //...

Passing array of arguments to Quartz Scheduler

java,command-line-arguments,quartz-scheduler

Problem solved. I had to map the command-line arguments to JobDataMap in the scheduler class. Then use getJobDataMap() in the .execute method to retrieve the arguments and putting them back into a String[]....

UITableViewAutomaticDimension + AFNetworking

ios,iphone,uitableview,cocoa-touch,afnetworking

First you need to add height constraint to you imageView and create reference to it from you UITableViewCell subclass. class TableViewCell: UITableViewCell { @IBOutlet weak var imageView: UIImageView! @IBOutlet weak var imageViewHeightConst: NSLayoutConstraint! } Then make use of UIImageView+AFNetworking.h method: - (void)setImageWithURLRequest:(NSURLRequest *)urlRequest placeholderImage:(UIImage *)placeholderImage success:(void (^)(NSURLRequest *request, NSHTTPURLResponse *response,...

Latitude/Longitude RegEx in N-S and E-W format

c#,regex

My suggestion is String patternLatitude = @"^(90\-00\.00)|([0-8]\d\-[0-5]\d\.\d\d) (N|S)$"; String patternLongitude = @"^(180\-00\.00)|((1[0-7]\d)|(0\d\d)\-[0-5]\d\.\d\d) (W|E)$"; providing that the given example 015.00.00 E valid should be actually invalid. More testing examples (all invalid) 090-00.01 N 180-00.01 E 190-00.00 E 200-00.00 E Explanation: Latitude: 90-00.00 is a special case (the only possible value with...

WinPhone 8.1 | Force xaml layout change

c#,xaml,windows-phone-8.1,win-universal-app

You need to yield control to the UI thread to give it a chance to display the progress indicator. One convenient way to do that is to use the async/await keywords: protected override async void OnKeyDown(KeyRoutedEventArgs e) { if (e.Key == Windows.System.VirtualKey.Enter && (xaml_search_box.FocusState == Windows.UI.Xaml.FocusState.Pointer || xaml_search_box.FocusState == Windows.UI.Xaml.FocusState.Keyboard))...

How can I get the index of a type in a variadic class template?

c++,c++11,variadic-templates

So you want to find the index of Component in Components...? template <typename... > struct index; // found it template <typename T, typename... R> struct index<T, T, R...> : std::integral_constant<size_t, 0> { }; // still looking template <typename T, typename F, typename... R> struct index<T, F, R...> : std::integral_constant<size_t, 1...

Ajax calls to a web api method

c#,jquery,ajax,asp.net-mvc,asp.net-web-api

The first one is called from your Ajax.BeginForm. The second one is called from you manually wiring up the button here: $("button").click(function (e) The third one will be because you are not preventing the default submit in your above click function. $("button").click(function (e) e.preventDefault(); The quickes solution will probably be...

Why does adding files to the app directory make the server slow?

ruby-on-rails,ruby

If you add a dir directly under app/, all files in this dir are eager loaded in production and lazy loaded in development by default. Try adding this in config/initializer.rb: path = Rails.root + "app/data" ActiveSupport::Dependencies.autoload_paths -= [path.to_s] This is to remove add/data from autoload path. ...

How in vb.net can I insert a value on a read only property?

vb.net,rgb,readonly

You'll have to use the shared method FromArgb. Dim red As Color = Color.FromArgb(255, 0, 0) Or in your case Dim newcolor As Color = Color.FromArgb(vermelho, verde, azul) ...

PostgreSQL migration and restore

postgresql,database-migration

pg_dump is the normal answer for a single database, pg_upgrade does an entire cluster on the same machine, but only works with >=8.3. Failing all of that, pg_dumpall will pg_dump all the databases on a server into a single output stream.

Extract string after complex string

regex

Simply check for the first : following your exception name: .*?:\s (or [^:]*:\s). (?<=AddlExc=\")(?P<exception_type>\b\S*Exception\b).*?:\s(?P<exceptionmessage>.*) ...

Crash EXC_CRASH (SIGABRT) unity + vuforia + ios

ios,unity3d,vuforia,ios8.3

Okay, from your Question, it looks like you've checked on Multithreadingin your Build Settings? Disable that, I really doubt you'll have the need to use it. From the picture in your comment, you seem to have used Architecture - Universal. Instead, change that to ARMv7 and as per your question...

Packaging large folders NSIS

nsis

Thank you for the help guys. The problem was with the directory structure. It had few soft links which linked to other computer and was trying to package everything there(infinite loop). I got it fixed. The problem was not with NSIS

Self join through junction table?

sql

For get that information you should join twice to user table using friendship like pivot SELECT friend_1.name,friend_2.name FROM friendships AS relation_friend JOIN users AS friend_1 ON friend_1.id=relation_friend.user1_id JOIN users AS friend_2 ON friend_1.id=relation_friend.user1_id; Regards....

Generating wrong Uri for PubSub Service

google-api-php-client,google-cloud-pubsub

It's definitely a bug in google-api-php-client and there is an issue about this: https://github.com/google/google-api-php-client/issues/567

Efficient retrieval of last and second to last element of ArrayStack in Scala?

scala,stack

stack(4) // returns 5th element stack.last // returns last element Those operations are constant time....

how to display the output in plist format. Is it possible or not? and also the Data in textarea should be able to download?

javascript,html5

You can add header and footer as string syntax as follows. You can call the function saveTextAsFile to download. Tested on chrome function processArea() { var area = document.getElementById('area'); var arr = area.value.split(/\n/); var header = '<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE plist SYSTEM "file://localhost/System/Library/DTDs/PropertyList.dtd">\n<plist version="1.0">\n<dict>\n<array>'; var footer = '\n</array>\n</plist>'; for (var i...

Symfony form dropdown for entries

php,forms,validation,symfony2

What I would do is simply this : public function buildForm(FormBuilderInterface $builder, array $options) { $builder->add('name', 'text') ->add('client', 'entity', array( 'class'=>'AppBundle\Entity\Client', 'property'=>'name' )); } Hope this helps....

Rails: NoMethodError in RailsAdmin::MainController#dashboard

ruby-on-rails

Are you using Warden? On the same page I've found some custom authorization. Have you tried that?

Microsoft Access 2013 sql return which table information came from

sql,ms-access

Put the table name into the individual queries: select 'foo' as tablename from foo union all select 'bar' as tablename from bar union all etc... ...

Angular: How to edit $scope from the console? [duplicate]

angularjs

Any scope variable updated from outside angular context will won't update it binding, You need to run digest cycle after updating values of scope using scope.$apply() that will call $digest method and all the bindings will update on HTML. angular.element($("#container")).scope().text angular.element($("#container")).scope().$apply() Note:- You should add jQuery file in order to...

PyQt 3.3.6: How to align text in a table?

python,pyqt

I understand that the characters used for the thousands separator and the decimal mark may differ between locales, but surely no locale could sensibly interpret 5.5.5 as a number? Given that, it's hardly surprising that Qt wants to treat it as ordinary text. But anyway, the docs for QTableItem suggest...

Find the parent node of a node in binary search tree

c++,binary-search-tree,nodes

It appears that 45 does not have a left node, it is NULL, so checking pRoot->pleft->value == value is undefined behavior. 30 / \ 15 45 / \ \ 7 17 69 \ 80 So you need to do a check, something like: Node* BST::searchforparentnode(Node* pRoot, int value) { if(pRoot->pleft...

ESS produces “Variable binding depth exceeds max-specpdl-size”

r,emacs,ess

Solution: change the order of certain settings. My .emacs.el has settings for smooth-scrolling (A) (require 'smooth-scrolling) (setq smooth-scroll-margin 5) and for the initial file (B) (find-file "~/init.org") (A) should be loaded before (B). (B) was loaded before (A) in my previous .emacs.el and this causes the problem. (I do not...

Rxjs swallows errors

javascript,rxjs,reactive-extensions-js

Your subscribe function should never throw an exception. RxJs models asynchronous streams of information, where the observer code often runs asynchronously from the producer code (e.g. not on the same callstack). You cannot depend upon errors propagating back up to the producer. Rx.Observable .fromArray([1,2,3,4,5,6]) // if commented from here .windowWithCount(2,...

Retain loop in a block

ios,objective-c,sprite-kit,objective-c-blocks,retain-cycle

You should definitely not ignore the warning, but use __weak instead to define a weak reference and eliminate retain cycles as described in the documentation: __weak SelfType *weakSelf = self; void (^aBlock)() = ^(){ SelfType *strongSelf = weakSelf; //User strongSelf }; Alternatively you can use libextobjc (https://github.com/jspahrsummers/libextobjc) with its convenient...

sqoop-export is failing when I have \N as data

hive,sqoop

Try adding these arguments to the export statement --input-null-string "\\\\N" --input-null-non-string "\\\\N" From the documentation: If --input-null-string is not specified, then the string "null" will be interpreted as null for string-type columns. If --input-null-non-string is not specified, then both the string "null" and the empty string will be interpreted as...

angular how to pass an object in an ajax post

php,angularjs,codeigniter

Try this, use params instead of data & remove ' in params $http({ url: 'http://localhost:8888/employees/login', method: "POST", params: {"AccessKey":"[email protected]","Password":"candoa21"} }) ...

onActivityResult called twice

android,facebook-android-sdk

Both problems are solved and they are related. What happens and i failed to understand was that the facebook button has an underlying event that triggers the login process. I set another event on MainActivity to act upon click. So, internally, what was happening was that, the facebookactivity was being...

HTML image not working

html

The second image is missing the http:// part. That means, the browser doesn't know it should look at a different server, but tries to access it at the same server, where the HTML file is hosted.

Android support-v4:22.0.0 Not downloading to correct location?

android,libraries,android-sdk-manager

The "Android Support Library" entry in the SDK Manager is primarily for Eclipse users. You are using Android Studio, so what matters is the "Android Support Repository", which you have not updated in the SDK Manager.

Directory sandboxed access for Google Drive / Dropbox API / RemoteStorage apps?

html5,google-drive-sdk,dropbox-api

The Dropbox Apps API provides the ability to restrict any app using your API key to a single directory of your Dropbox account. So users could create an API key with access to a specific directory and then plug that into your app. However, that's not a user-friendly workflow. I...

Determine longest date range, from two date ranges - Excel

excel,excel-formula

Using your provided example, this should work for you: =MAX($D2:$D3)-MIN($C2:$C3) ...

Executing SQL Command in C# (Sql Exception Was Unhandled)

c#,sql-server

You can't use Table as the name for your table without qualifying it, since it's a SQL reserved word. Use [Table] instead if that is really your table name. INSERT INTO [Table] (Barcode, Item, Quantity)... Better yet, change the name of your table. Unless this is a copy/paste fail....

How to reload tableview after reordering a row? Rows have variable height

ios,uitableview,heightforrowatindexpath,reorderlist

I found here the answer: http://stackoverflow.com/a/4692563/239219 [tableView beginUpdates]; [tableView endUpdates]; This code forces UITableView to reload cell sizes only, but not cell contents....

How to correctly setup 2-node ElasticSearch cluster

elasticsearch

This is an interesting set-up you're trying to achieve but not one that I would recommend in the long run as you're putting your production node under stress very often. First off, the term "development" in this case makes little sense because as far as ES is concerned, you're adding...

Sorting unique elements column-wise in a text-file

regex,linux,awk,sed,grep

I would use the following awk command: awk '$5 !~ /^(\+,)*\+$/ && $5 !~ /^(-,)*\-$/' file It checks whether $5 (column 5) contains a sequence of +,..,+ or a sequence of -,..,-. If not, the line gets printed. Output: chr1 5069018 5071285 Atp6v1h,Rgs20,Rgs20 +,-,- ...

How to Edit files using web application

design,web,jython

A simple solution to the concurrency issue you talk about is to save a datetime stamp each time the file is edited from anywhere. Now, if a user tries to save his changes to a file, check the datetime stamp and make sure that the current edit's datetime stamp is...

django CreateView demands pk

django,django-views

If you look at the full traceback, you should be able to see that it is not the LampCreateView that is raising the exception. It sounds like you have another url pattern above the lamp_create which matches /shotmaker/camera/create/ first. For example: url(r'^camera/(?P<pk>[-\w]+)/$', views.OtherView.as_view(), name='other_view') url(r'^camera/create/(?P<pk>[-\w]+)$', views.LampCreateView.as_view(), name='lamp_create'), To solve the...

Data exchange - Python and Fortran

python-2.7,fortran

The standard way of wrapping Fortran code in Python is with f2py (included in the numpy module). For the output of intermediary results, a number of formats could work, it really depends on your requirements. For simple datasets, from python, just use numpy.save. If your datasets become large, HDF5 with,...

Python: How to store for loop result in a list?

python,arrays,list,loops,for-loop

Well the loop seems to be this one (at the end of the code): for i,j in itertools.combinations([a,b,c],2): all_diffs=alldiffs(i,j) total=count_total(i,j) zero=count_zero(all_diffs) total=np.array(total) union=map(sub,total,zero) zero=np.array(zero).tolist() union=np.array(union).tolist() union=[list(x) for x in union] sim=[[float(aaa) / bbb for (aaa, bbb) in itertools.izip(aa, bb)] \ for (aa, bb) in itertools.izip(zero, union)] sim_comb=sum(sim,[]) sum_of_sim=sum(sim_comb) number_sum=len(sim_comb) ave=sum_of_sim/number_sum...

SQLite database query returns only one row

java,android,database,sqlite,cursor

Thanks to all who answered. I have found a function that works for perfectly. public Cursor getAllRows(String TABLE_NAME, String sql){ String selectQuery = "SELECT * FROM " + TABLE_NAME + " " + sql; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); if(cursor != null){ cursor.moveToFirst(); } return cursor;...

SQL find and replace error

mysql

You use both Hyperlink and 'Hyperlink'. If you make those consistent and correct does it work out better? Correct in this case being to omit the quote in the update statement. At least that what works for me in a sqlfiddle...

How to collapse rows in excel using python?

python,excel

I've used the modules xlrd and xlutils for this purpose. There's also xlwt if you need more advanced control over writing your Excel cells. To write to an existing file, it would look something like this: import xlrd from xlutils.copy import copy as xlcopy read_book = xlrd.open_workbook('filepath/to/file.xlsx') read_sheet = read_book.sheet_by_index(0)...

T SQL wildcard searching for a zip code

sql,search,wildcard

If what you said is true, that @MailFiveDigitZip is a char and not a varchar, then you're running into character padding issues. "44" in a varchar(5) is "44" "44" in a char(5) is "44 " (note in case it doesn't translate well... this is 44 plus 3 spaces) like "44...

ios Can I use MPMoviePlayerController to play .mp3 url

ios,mpmovieplayercontroller

For playing audio from a file or memory, AVAudioPlayer is your best option but unfortunately it doesn't support a network stream while MPMoviePlayerController can From documentation : An instance of the AVAudioPlayer class, called an audio player, provides playback of audio data from a file or memory. Apple recommends that...

regular expression: match everything but single forward- and double backslashes

python,regex,python-3.x

The easiest way is to use negative lookahead to exclude the two patterns. re.match(r'(?!.*/|.*\\\\)', string) ...

Copy pre-configured OS image to slave local drive with PXE

linux,provisioning,pxe

Is it possible to tell PXE to copy the contents of the NFS-mounted directory to a local disk partition and then make it boot/run linux from there? PXE is just a mechanism for booting a system over the network. Since you have complete control over what you feed your...

How to filter data from flat file with multiply lines pattern using awk or sed tool?

regex,awk,sed

This awk will do most of it, but will leave space before the [\Close] awk '/Start/{ORS=FS} /End/{ORS=RS} sub(/Start/,"Open") sub(/End/,"Close") 1' file It's easy to trim that in another pass (pipe previous output to this script) awk 'sub(/ \[/,"\[") 1' ...

make an image sit at the bottom of a section scroll site

html,css,twitter-bootstrap,bootstrap

Harry Robinsob, Here is a Fiddle of your code. As you had it in the fiddle the logo was stuck to the bottom, it was not centered. With a little change it is now center. .logo { position: absolute; bottom: 0; left: 0; right: 0; } Here is a link...

To check if sublist exists in another list

list,python-3.x,sublist

I think the most readable way to do that is to create a Counter instance for each of your sublists, and them check with the list "count" method if it matches the requirement for each argument of the sublist: from itertools import Counter def checksub(main, sublist): c = Counter(sublist) for...

Return what was replaced in SQL

sql,sql-server,regex,tsql,replace

You could try the output keyword, that won't tell you exactly what was taken out but it will tell you the state of the record before you changed it. And yes, it would work better for you if the information was properly normalized. UPDATE table SET a = replace..... OUTPUT...

How can I assign the NULL to a float/double variable?

c,jni

You cannot (and should not) assign a pointer to a normal variable. I really don't know why it allowed for some other normal data types, as you have mentioned. Compiler should have produced same warning equally for all assignment from pointer to other non-pointer data type NULL is a void...

Countdown timer goes into negative number (00:00:00)

c#,timer

You code is doing exactly what you are telling it to do, the problem is that you are not dealing with the edge case of starting at 0:0:0. I assume this would be considered an invalid input, so probably the easiest way to deal with this would be to check...

How to force use of indices in MongoDB?

mongodb,indexing

The notablescan ( http://docs.mongodb.org/manual/reference/parameters/#param.notablescan ) option for the MongoDB binary (mongod.exe or mongod depending on your OS) allows you to stop any query, with an emitted log error, which does not use an index at all. This option will not stop inefficient queries though so that part will still need...

Why Eclipse Debugger does not stop on scoped exception breakpoint (how to stop on handled exception)

java,eclipse,debugging,exception

After debugging Eclipse I understood that "scope" filters should match throwing location (in this case java.math.BigDecimal) and not the catch location. This is the original JVM debugger filtering on "scope", however JVM limits filter to one item (class or package), while Eclipse can process multiple items. The code that does...

Python 3.4 : LXML web scraping

python,lxml

Browsers add in missing HTML elements that the HTML specification states are part of the model. lxml does not add those in. The most common such element is the <tbody> element. Your document has no such element, but Chrome does and they put it in your XPath. Another such an...

SAS proc sql - how to read in log of variable but retain the variable's label

sql,sas,label

As far as I know, there is not a way of persisting the variable label automatically in proc sql. Unfortunately, you don't have access to the vlabel etc. functions, and even if you did the timing would be wrong to use them. In addition to defining the label manually as...

Tablesorter stickyheaders inside jQuery UI tabs

tablesorter

It looks like the issue is that the #mywrapper element is missing a position:relative; definition. The sticky header is using position:absolute, so it ends up getting its positioned calculated based on the #tabs element, which is the only parent element with a position:relative assigned (by the jQuery tabs widget) (updated...

Builder pattern with a Java 8 Stream

java,java-8,builder,java-stream

There's unfortunately no foldLeft method in the stream API. The reason for this is explained by Stuart Marks in this answer: [...] Finally, Java doesn't provide foldLeft and foldRight operations because they imply a particular ordering of operations that is inherently sequential. This clashes with the design principle stated above...

Click events for each object in List View - Android

android

You can set an OnItemClickListener on your ListView and then define operations for every element in your adapter like that: listView.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> adapterView, View view, int position, long l) { Room item = livarray.get(position); switch(position){ case item ... } } }); ...

How do you populate a Combobox based on the selection of another Combobox?

python-3.x,combobox,tkinter

Don't use global variables. Use class variables instead. Use dictionaries instead of multiple variables. Use ComboboxSelected event Result: from tkinter import * import tkinter.ttk category = {'home': ['utilities','rent','cable'], 'car': ['gas','oil','repairs'], 'rv':['parks','maintenance','payment']} class Application(Frame): def __init__(self, master=None, Frame=None): Frame.__init__(self, master) super(Application,self).__init__() self.grid(column = 5,row = 20,padx = 50,pady = 50)...

Using auto layout to arrange views in sequence with one taking whatever space is available

ios,swift,autolayout

Oftentimes, when I run into situations like this, I find it is most useful to put related items into their own views. In this case, I think you can put the switch and its labels into their own view. That way it can handle its own layout separately. I tried...

Identifying the caller method and arguments without reflection

java

Is that possible without reflection? No. (I don't even think it's possible with reflection.) Are there any design pattern that needs to be followed? The pattern here would be to pass the relevant information as argument to the method. :-) You could also pass the instance of the Child...

How to set default value for association with simple_form?

ruby-on-rails,forms,default,simple-form

Set the value in your controller for the form object eg controller def show @product = Product.new(); @product.product_group = ProductGroup.find(1) // set default end view simple_form_for @product do |f| f.association :product_group ...

Best way to debug OSGI bundles in Karaf

eclipse,apache-karaf,osgi-bundle,karaf

The best way for me is to use the debug option when launching Karaf. This allows you to perform remote debugging ( I have done it from Eclipse and Intelli J with no problems). Just make sure your source is up to date with the karaf instance you are running....

Validation within Get/Set Methods Java

java,oop,boolean,encapsulation

A boolean value is a primitive data type and is thus passed by value only. Only objects are passed by reference. So there are two options for you. Either make your primitive boolean value a Boolean object (as this will be passed by reference). Or have the method return a...

Ajax request not printing html response

jquery,html,ajax

After digging deep into this I managed to figure out the problem. It all came down to the fact that PHP is loaded before JavaScript. In my PHP loop I was printing out each item in a database table. For each item I was calling the ajax function getRating(work_id, selectorToWriteTo)...

CSV export only heading Arrays not Data

php,mysql,csv,while-loop

what about writing out the same way while in the loop? header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename=DepReport_'.$from.'_'.$to.'.csv'); $output = fopen('php://output', 'w'); fputcsv($output, array('Reference', 'Depart Date / Time', 'Depart Terminal', 'Depart Flight' ) ); $i = 2; while($rows = mysql_fetch_array($result)) { //change to $output so it writes lines to same handler...

How to Build Software

Getting started tutorials how to be a good programmer, develop software with:

qqmlapplicationengine , diaspora , g++4.9 , charactercount , lock-free , page-init , stereoscopy , clj-time , git-bash , neovim , invariants , ta-lib , fclose , bulk-email , jasperserver , rethinkdb-python , parquet , awesome-wm , magento-1.9 , mpmovieplayercontroller , xcode6.1 , fileobserver , binary-matrix , slice , fluentvalidation , ssas-tabular , struct.pack , nginfinitescroll , prettify , jsobject , blame , hidden-field , wxhaskell , dc.leaflet.js , sprockets , sql-in , iife , codelens , malformed , azureservicebus , finite-element-analysis , array-walk , disabled-input , aix , datapersistance , explicit-constructor , editorconfig , stylecop , spritebuilder , jviewport , mvcsitemap , custom-event , go-gin , android-notifications , horizontalscrollview , uipi , imgur , google-geocoding-api , checkboxfor , dhtmlx-scheduler , named-ranges , image-scaling , console-input , rewriting , ngcloak , doctrine-query , slidingmenu , contains , apns-php , relational-division , roku , gldrawpixels , photosphere , kprobe , uiapplication , bnf , ovp , ng-idle , dist-zilla , carrierwave , symbol , pytables , passthrough-attributes , n-layer , owl-carousel-2 , kmalloc , symfony-http-foundation , listobject , lyx , uglifyjs2 , vispy , shutdown , rating , https , capifony , drone , searchly , ultragrid , instamojo , hclust , natural-join , zipmap , setup-deployment , marshalling , magnolia , arc-diagram , jopendocument , fragment-backstack , pyhdf , php-gettext , acrofields , bin-packing , angularjs-ng-model , sts-springsourcetoolsuite , screen-lock , probability-theory , opendaylight , wordpress-plugin , session-state-provider , mongoengine , tess4j , androiddesignsupport , custom-events , shared-data , artifacts , 3d-model , androidviewclient , armcc , describe , biginsights , swift2 , dataflowtask , load-path , context-free-grammar , sql-server-authentication , email-address , dynamic-pivot , redirect , iboutlet , rails-geocoder , cloud-platform , laravel-collection , multikey , kentico-mvc , picasso , amazon-payments , jprofiler , query-builder , automator , singularitygs , dynamics-ax-2012-r3 , createfile , spotify , sbcl , machine-config , bytecode-manipulation , framerjs , adb , dockerhub , konsole , systemcolors , morton-number , custom-fields , vertex , sucker-punch , srp-protocol , .net-core , fuzzy-c-means , leadtools , jboss6.x , haxm , delphi-xe8 , restlet-2.0 , xmlbeans-maven-plugin , java-3d , innodb , database-migration , utf8mb4 , universal-image-loader , dojo-1.7 , lob , mod-dav-svn , miniconda , oracle8i , software-engineering , load-testing , tuples , android-cursoradapter , aggregator , springmockito , csplit , python-social-auth , voting-system , auto-populate , console2 , proj4 , localization , documentfilter , newtons-method , blackfire , domparser , dsl , payment , exception-handling , ifft , hwndhost , dynamic-columns , database-backups , result , mongojs , transpiler , sim-card , last.fm , jquery-textext , strikethrough , which , curlpp , jgroups , h2reg , miniport , portrait , this , cfile , file-conversion , smoke , treelistview , cross-domain-policy , django-apps , micro-optimization , spring-hateoas , spring-jpa , dynamic-script-loading , racing , grails-3.0 , stripos , cocoalumberjack , client-side-scripting , osx-lion , plivo , ceil , bspline , wechat , malformedurlexception , excel-udf , django-models , enterprise-integration , itunes , ansi-sql , node-commander , tinydb , java-2d , firebase-tools , protocol-buffers , excel-indirect , android-intent , lucene.net , pebble-js , activerecord , quicktype , rolify , utc , border-color , jsonschema , firemonkey , home-button , ibm-jazz , perlmagick , bnfc , morse-code , ruby-c-extension , boxing , skype , shellcode , spring-security-oauth2 , cprofile , aspnet-compiler , baseline , http-status-code-200 , locust , mousepress , maximize , icefaces , language-interoperability , 4store , metastore , hiveql , object-persistence , macros , content-management , gameboy , eclipse-scout , qgraphicswidget , persistence.xml , pfobject , setstate , draper , third-party , aero , artifactory , django-crispy-forms , mailmerge , depth-testing , lemoon , masm32 , google-maps-timezone , pry , postgresql-8.4 , android-contextmenu , fpdf , dart-unittest , parameterized-query , query-extender , panel-data , s3cmd , libav , kleisli , android-jsinterface , as.date , input-filtering , navigationview , backlog , dart-pub , sql-date-functions , librarian , deap , preg-match-all , hsc2hs , packagemaker , pythoncom , vs-unit-testing-framework , iprincipal , google-php-sdk , system.componentmodel , preg-replace-callback , drag-and-drop , class-hierarchy , pentaho-ctools , application-loader , printstream , clientip , steganography , wireless , libs , fullpage.js , viola-jones , machine-learning , visual-studio-designer , readme , script-debugging , stackexchange.redis , dojox.grid.datagrid , cen-xfs , javascript-framework , voiceover , dotcover , nanotime , woothemes , verifone , msvc11 , eventtrigger , easyrtc , web-client , ember-cli-mirage , growl , clr-integration , sata , facebook-test-users , trigram , end-of-line , dice , multi-tenancy , uipickerviewcontroller , javascriptmvc , tizen-emulator , referential-transparency , angular-kendo , openni , json.net , html-encode , slicknav , preconditions , wal-e , servicecontroller , node-walk , application-restart , jcuda , missing-symbols , dynamics-nav , rbac , selenium-fitnesse-bridge , shadow-dom , richdatatable , sequential-number , peripherals , ewsjavaapi , brackets , mkmaprect , paypal-sdk , infopath2010 , openwrt , listview , sbt-assembly , pyjade , android-optionsmenu , ends , android-viewpager , linkedin-api , distributed-algorithm , sigfpe , android-launcher , function-overloading , cd-rom , gadfly , rabbitmq-shovel , submit-button , windows-7 , ejb-3.0 , python-plyplus , clearnlp , mosaic , drawimage , devstack , mvcgrid , movement , apache-samza , unauthorizedaccessexcepti , onchange , private-inheritance , android-wifi , afoauth2client , gwt-celltable , .net-4.5.2 , cakephp-bootstrap-ui , mod-rewrite , uiactivityindicatorview , monomac , document-root , calibration , video-codecs , gvnix , jekejeke , email-integration , excel-formula , modality , tournament , rpm , rtl , array-multisort , peoplesoft , bmp , saving-data , martini , array-difference , data-cleaning , translucency , reactjs , generate-series , photoshop-cs5 , sbt-proguard , server-error , notserializableexception , httpclient , dstream , test-explorer , sctp , mbstring , waitforsingleobject , prolog-coroutining , continuous , windows-update , dropbox-php , watchmaker , nsexpressiondescription , jdk1.6 , beatbox , google-api-python-client , openshift-cartridge , create.js , openafs , poset , graph-databases , selectall , nested-sets , delete-keyword , python-tesseract , mod-perl2 , field-accessors , hoisting , multi-monitor , oop , reply , becomefirstresponder , ini4j , nsnotificationcenter , nscolor , bytesio , icinga , jbpm , reviver-function , boost-variant , extract-method , telnet , geometry-instancing , opengl-extensions , elmah.mvc , apache-commons-fileupload , adserver , mongodb-query , octobercms , page-flow , nsfilemanager , compiler-flags , fipy , fatal-error , checkboxpreference , collectioneditor , jsqmessagesviewcontroller , iis-6 , amortization , topendialog , apptentive , form-processing , textpad , ajaxmin , qtquick3d , superuser , zos , type-safety , tcxgrid , unsigned-long-long-int , hyperlink , cross-build , html2pdf , qbuttongroup , functional-interface , detailview , android-scrollview , compound-assignment , sdist , pe , contextpath , propel , jaspic , apache-jena , data-kinds , cmis , distutils , e4x , kony , friend-class , android-selector , gl-triangle-strip , uglifier , cart , multiple-domains , right-align , xmlslurper , nservicebus5 , bifunctor , preferenceactivity , draw2d-js , quad , flextable , php4 , tofixed , nsis , git-tf , identifier , structuremap3 , racsequence , algebraic-data-types , error-list , labeling , xbase , yahoo-finance , buttongroup , specflow , babylonjs , cognos-bi , ec2-container-service , unique-values , richfaces , measurement-protocol , pre-commit , selector-drawable , 3-tier , history , object-type , polygon , ndis , nsinvocationoperation , max-flow , makemaker , libsass , extensible , bonecp , operand , bizagi , nls-comp , alignment , jgrowl , assistive-technology , camel-ftp , pydev , jtextarea , lockout , cordic , jnlp , trailing-character , angular-digest , xmpphp , jquery-events , blackberry-eclipse-plugin , virtuemart , stringwithformat , unreachable-statement , workflow-manager-1.x , eclipse-plugin , http-status-code-400 , git-plumbing , cyclic-dependency , contain , minimum , graphlab , criteria , google-refine , fortify-source , ember-testing , xsl-grouping , emacs23 , nio , bitwise-and , diophantine , appx , aidl , kif , tform , run-script , foolproof-validation , rhodecode , outlook-2013 , video-editing , ash , gpx , initwithframe , http-compression , information-hiding , titanium-android , attr-protected , iif-function , boost-python , wisper , excel-template , localhost , blobstorage , ellcc , cffile , extjs4.2 , git-checkout , phplucidframe , windows-mobile , coda , pyudev , computercraft , xpathquery , ecmascript-6 , kendo-datetimepicker , osticket , trellis , avr , setattr , chrome-gcm , quicksort , mysql-error-1452 , web-api-testing , re-engineering , tarfile , asciidoc , declare , alive , onclick , sunspot-solr , key-pair , gnu-cobol , objectanimator , repeatingalarm , django-middleware , link-to-remote , morelinq , commit , schema , cffunction , path-dependent-type , actionview , litespeed , tablednd , dtd , return , skyfield , moose-technology , ubuntu-10.04 , lazy-loading , database-indexes , create-function , oxwall , edt , accessoryview , spring-aspects , cocos2d-swift , mpns , lbph-algorithm , reportingservices-2005 , groups , bem , postdata , boo , sentiment-analysis , selectmanylistbox , form-authentication , qsub , flowlayoutpanel , data-files , self-referencing-table , python-keyring , nuspec , uicollectionreusableview , accessible , openerp , embedded-sql , imagedownload , pbkdf2 , jooq , adaptor , beaker , live-connect-sdk , amazon-kinesis , nextuntil , leksah , nivo-slider , z3c.form , xslt-grouping , data-conversion , sendinput , proxy , digits , apache2.2 , hover , sqliteopenhelper , rational , postal , smoothing , bounded-contexts , phone-state-listener , dnx , heartbeat , bootcompleted , routerjs , resin , fraud-prevention , express , computation , az-application-insights , livelock , devops , hipaa , language-features , mdx , android-listfragment , cabasicanimation , manifest-merging , e-commerce , 3g-network , packagist , http-status-code-403 , python-memcached , gitorious , xen , mvcsitemapprovider , azure-scheduler , ubuntu-15.04 , tf-idf , mknetworkkit , gitbook , listpicker , symmetricds , rad-controls , binlog , dotq , shouldstartload , valarray , iphone-standalone-web-app , deployment-descriptor , chroot , tracelistener , svn-checkout , dojox.charting , exists , cereal , pycparser , wikitext , opencv3.0 , certificate-revocation , meta-key , ctrl , canjs , jai , boolean-logic , jmockit , wsdl2java , exp , cartalyst-sentry , spock , utility-method , addthis , bayesian , record , pry-rails , multiple-models , google-spreadsheet , svc , clean-urls , hdr , xlib , natural-logarithm , garmin , internals , doctype , funq , chromium , tabular , birt-deapi , adomd.net , swingutilities , tachyon , plotly , hex-editors , non-recursive , towers-of-hanoi , plsqldeveloper , mura , git-track , man-in-the-middle , windbg , async.js , tcp , urlhelper , pingfederate , sslexception , iis-8.5 , calloc , mbaas , selectionchanging , sharepoint-2007 , performance-testing , pyd , gs-conditional-formatting , android-applicationinfo , imap , function , psi , datadirectory , retina-display , game-center , audit-logging , jericho-html-parser , trial , doxygen-addtogroup , mathprog , syntaxhighlighter , threadpool , didreceivememorywarning , sthttprequest , maven-failsafe-plugin , twisted.internet , revmob , user-permissions , boost-any , dotliquid , moonapns , twiml , kademlia , tic-tac-toe , np-complete , compiler-theory , custom-transition , folder-structure , sharpbox , rollapply , email-bounces , cohesion , variable-expansion , sender , aptana3 , toupper , azure-virtual-network , commandbinding , web-ide , secret-key , concat-ws , qsa , document-body , grib , angular-ng-else , packed , ubuntu-14.10 , sybase-asa , actionpack , ejb-passivation , unidac , hunspell , separator , bc , minesweeper , ndc , uisegmentedcontrol , singlepage , mailer , lookbackapi , fastboot , sequence-generators , mpmusicplayercontroller , cplex , apple-vpp , graphene2 , mediaextractor , directoryservices , toolchain , unit-of-work , storyboard , picklist , drush , moto-360 , ios-keyboard-extension , intermediate-language , html4 , vim-syntax-highlighting , urllib3 , wireshark , cdo.message , hana-xs , rms , text-formatting , docking , html-lists , yaml-front-matter , inlining , localnotification , splat , defaultifempty , customplaces , handshake , region , asp.net-caching , excanvas , android-searchmanager , ekeventkit , a-star , gitlab-ci-runner , static-ip-address , klocwork , pathogen , pdfptable , slowmotion , subscriber , hittest , directive , ejdb , mouselistener , inventory , gemfile , ecore , scorm , uploader , django-oscar , tomcat-jdbc , abstract , rdd , html5-fullscreen , pixi.js , cudafy.net , easypie , eigenvector , d , yaml , testbed , purchase-order , multi-term , gkmatchmaker , angularfire , seektotime , collisions , amazon-dynamodb , subtract , optionmenu , tomcat5.5 , gmaps.js , scikit-image , smooth-streaming-player , varray , deobfuscation ,