Posts

Showing posts from July, 2013

symfony - Type of choice field Symfony2 -

-
i try save values of 1 - 3 checkboxes in field category in database, error : notice: array string conversion in /var/www/ontheway/vendor/doctrine/dbal/lib/doctrine/dbal/statement.php line 120 the field: /** * @orm\column(type="string", length=255, nullable=true) */ private $category; get & set: /** * @return mixed */ public function getcategory() { return $this->category; } /** * @param $category */ public function setcategory($category) { $this->category[] = $category; } profile type: namespace vputi\userbundle\form\type; use symfony\component\form\abstracttype; use symfony\component\form\formbuilderinterface; use symfony\component\optionsresolver\optionsresolverinterface; class profiletype extends abstracttype { public function buildform(formbuilderinterface $builder, array $options) { $builder->add('fio'); $builder->add('birthdate', null, array('widget' => 'sing...
Post a Comment
Read more

php - AJAX loading whole page instead of part of the page to load data from database -

-
i want show image in iframe using ajax full page loading in every 5 seconds want content load if there change in status table. i think have section. may need transfer php code or need change on div. if please me ? main.php <!doctype html> <html> <head> <script src="http://code.jquery.com/jquery-1.11.1.min.js"></script> <script> $(function(){ function status(){ $.ajax({ type: "get", url: "main.php", success: function(data){ $('div.divgranite').html(data); } }); }; settimeout(status, 5000); }); </script> </head> <body> <div id="divgranite"> <?php //connect database $connection = mysqli_connect("localhost", "root", "pass"); if (!$connection) { die("error: " . mysqli_error()); ...
Post a Comment
Read more

java - Android: Programmatically Turn on WiFi hotspot -

-
i trying turn on portable wifi hotspot on, referring link: how set advanced settings of android wifihotspot this working on samsung galaxy s3 android v4.4.2.(no issues) on other devices same or lower android version, application crashes , restarts device. code follows: package com.android.startwifi; import java.lang.reflect.invocationtargetexception; import java.lang.reflect.method; import android.app.activity; import android.content.context; import android.net.wifi.wificonfiguration; import android.net.wifi.wifimanager; import android.os.bundle; import android.util.log; import android.view.menu; import android.view.menuitem; import android.widget.toast; public class main extends activity { public wifimanager wifimanager; public context context; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); log.i("hi1","hi"); createwifiaccesspoint(); } priva...
Post a Comment
Read more

scala - How do I start a server before running a test suite in SBT? -

-
problem if test in test <<= (taska, taskb) { (a, b) => dofinally b or test in test := (taskb dependson taska).value , taska forked , sbt execution doesn't continue taskb , get's stuck indefinitely. it's caused dofinally/dependson , because makes single-threaded sequential execution. can't find other way order 2 tasks, make them run sequentially. so far i've gotten far : lazy val startserver = taskkey[unit]("start pingpong server before running scala-js tests") lazy val jvm = project.in(file("jvm")) fork in (test, runmain) := true startserver := { (runmain in test).totask(" com.example.pingpong").value } ) lazy val js = project.in(file("js")) test in test <<= (startserver in project("jvm", file("jvm")), test in(test, fastoptstage)) { (startserver, test) => startserver dofinally test } ) the sbt exec...
Post a Comment
Read more

android - Can't create handler inside thread that has not called Looper.prepare() when using AsyncTask -

-
i have following code in app should update app. host apk on private server , when put new version want code run , update app. i know play store , use mechanism of our customers. there few customers refuse have background data switched on due data usage. these customer can't use play store, want graceful update method our private server. i have read posts on , general feeling i'm calling should called on ui thread. if i'm making web call, must on bg thread. any ideas why i'm getting error message? thanks in advance matt string url = "http://cfweb.yourofficeanywhere.co.uk/entryactivityv33.apk"; string[] updateparam = new string[] {url}; asyncupdateapp asua = new asyncupdateapp(); asua.execute(updateparam); . private class asyncupdateapp extends asynctask<string, string, string>{ @override protected string doinbackground(string... params) { string result = updateapp(params[0]); re...
Post a Comment
Read more

javascript - Adding a stylesheet dynamically -

-
after document.ready event fires, load stylesheet dynamically based on user's resolution. works in chrome, firefox , ie: var thefilename = '/somedirectory/somefilename.css'; if (document.createstylesheet) { //finally found ie got right document.createstylesheet(thefilename); } else { $('<style id="testcss" type="text/css"></style>').appendto('head'); $.get(thefilename , function (thecss) { $("#testcss").append(thecss); }); } the problem doesn't work in safari. don't have mac don't have console error know stylesheet doesn't added. need change make work in safari? thanks. ps: don't want use media queries. **edit:** i had function used <link> tag added. page entirely dynamically generated , problem adding stylesheet after dom rendered makes elements unstyled if use <link> tag. use settimeout check $('#testcss').length see if st...
Post a Comment
Read more

c# - Importing a multiline record with optional fields using filehelpers -

-
i'm in process of needing parse file who's records of following format: mr sean r. farrow 4 crescent eastleake loughborough leicestershire le12 6qh 01509 59213 07525945447 sean.farrow@seanfarrow.co.uk each record delimited blank line finish. 2 phone numbers , email address optional. what best way of parsing sort of record? write own parser, hoping don't have to! filehelpers expects each record end new line, you'd have pre-parse input before passing engine. that's straightforward though - like: var lines = file.readalllines(pathtoimportfile); var sb = new stringbuilder(); var separator = ","; // use comma field delimiter foreach (string line in lines) { if (string.isnullorempty(line)) sb.appendline(""); // convert empty lines line feeds else sb.appendformat("\"{0}\"{1}", line, separator); // put quotes around field avoid problems nested separators } var engine = new filehelperengine...
Post a Comment
Read more

exception - Doctrine, Zend, Entity QueryException has no field or association named -

-
i'm having orderentity. first time needed 3 properties table. need 2 more. i'm adding 2 properties entity: namespace stock\entity; use doctrine\orm\mapping orm; /** * @orm\entity * @orm\table(name="orders") */ class orderentity { /** * @orm\id * @orm\column(type="integer", name="orders_id") */ private $ordersid; /** * @orm\column(type="string", name="order_number") */ private $ordernumber; /** * @orm\column(type="integer", name="stores_id") */ private $storesid; /** * @orm\column(type="string", length=3, name="currency") */ private $currency; /** * @orm\column(type="decimal", precision=6, scale=14, name="currency_value") */ private $currencyvalue; public function getordersid() { return $this->ordersid; } public function setordersid($ordersid) { $this->ordersid = $ordersid; } public function getordernumber() { return $this...
Post a Comment
Read more

json - IP Lookup in PHP from JavaScript returning undefined -

-
i'm trying iplookup script.js through call own server, returned 'undefined'. why? iplookup.php <?php header('content-type: application/json; charset=utf-8'); $data = json_encode($_server['remote_addr']); //next line needs commented out //echo $_get['callback'] . '(' . $data . ');'; ?> script.js //get ipaddress $.ajax({ url: "http://www.example.com/iplookup.php", data: null, type: 'get', crossdomain: true, datatype: 'jsonp' }).done(function (json) { self.ip = json; }); //on next line returns `undefined` console.log('ipaddress: ' + self.ip); you need echo response out also. right doing, set header, encode $_server['remote_addr'] $data variable, neber echo out. javascript ajax request gets empty response. do so: <?php header("content-type: application/json"); print json_encode($_server['remote_addr']);...
Post a Comment
Read more

charts - highchart: How to Remove Series space (after & before) -

-
i went remove space(gape) between 2 series. check image more detail ! http://s13.postimg.org/4nklby5vb/10_sep_14_7_46_01_pm.png space between columns can control grouppadding / pointpadding
Post a Comment
Read more

c++ - boost::multiprecision cast from integer to cpp_dec_float compile error -

-
i encounter problem moving code server. a minimal working example of problem following code (filename mp2.cpp ): #include <boost/multiprecision/cpp_int.hpp> #include <boost/multiprecision/cpp_dec_float.hpp> #include <iostream> using namespace std; using namespace boost::multiprecision; int main() { uint128_t = 1; uint128_t b = 2; cpp_dec_float_50 fa = static_cast<cpp_dec_float_50>(a); cpp_dec_float_50 fb = static_cast<cpp_dec_float_50>(b); cout << fa / fb << endl; return 0; } compiles , works expected, writing 0.5 on standard output on dev machine (g++ 4.6.3, boost 1.55, 32 bits cpu). for same code, g++ fails compiling on server error: in file included /usr/local/include/boost/multiprecision/number.hpp:22:0, /usr/local/include/boost/multiprecision/cpp_int.hpp:12, mp2.cpp:1: /usr/local/include/boost/multiprecision/detail/generic_interconvert.hpp: in instantiation of '...
Post a Comment
Read more

Xwindows Intrinsics - print type String in 'C' -

-
language 'c', **not** c++ environment xwindows intrincics & athena (xt, xaw) i want use value asciitextwidget in 'c' print statement. type of value "string", typedef of 'char *'. string argname, argtask, sincewhen; xtvagetvalues(b_txt_21, xtnstring, &argtask ,null); if (strlen(argtask) > 0) { printf ("--new argtask\n"); xtvasetvalues(t_txt_21, xtnstring, argtask ,null); xtvasetvalues(b_txt_21, xtnstring, "" ,null); } printf ("++commit:gets done <%s> <%s>\n", argname,argtask); this produces: --new argtask ++commit:gets done <> <> i can not find converter string->cstring. nor documentation of structure @ end of string's pointer. solved: xtvagetvalues sets string correctly. apparently xtvasetvalues clears string content after setting widget. save copy after 'get'.
Post a Comment
Read more

ios - Facebook login reset password -

-
i have developed app needed login facebook , fine. use delegates below let user login. - (void)loginviewfetcheduserinfo:(fbloginview *)loginview user:(id<fbgraphuser>)user - (void)loginviewshowingloggedinuser:(fbloginview *)loginview - (void)loginviewshowingloggedoutuser:(fbloginview *)loginview - (void)loginview:(fbloginview *)loginview handleerror:(nserror *)error after user login firstly, app login automatically in next time. ok. if user change password, app still login automatically. think app should call handleerror stop login automatically. app didn't this. seems app save plist file in local file , read plist file information login facebook again. i hope app present login view again if user reset password. hope 1 me favor. your app uses token , not user password login. token can used app (in combination facebook app id). you app never receives user password makes more secure. this done user can remove access account on per app basis. changing pass...
Post a Comment
Read more

WPF Async Task locking UI -

-
i know i'm missing stupid, "startprocess" method making ui unresponsive , no amount of googling , tutorials has led me answer. here code: public mainwindow() { initializecomponent(); txtblock.text = "testing"; initialize(); } public void initialize() { uischeduler = taskscheduler.fromcurrentsynchronizationcontext(); startprocess(); } async void startprocess() { task<int> result = task.factory.startnew(() => { txtblock.text += ("\n starting updater"); while (true) { thread.sleep(3000); } return 0; }, cancellationtoken.none, taskcreationoptions.longrunning, uischeduler); } some background: i'm building app has poll db every 5mins , update ui to-do list user, hence while(true) loop. app has poll db continuously throughout lifetime. well, asked tpl...
Post a Comment
Read more

sorting - Sort NSArray with sortedArrayUsingComparator -

-
in objective-c can sort nsarray using statement: nsarray *sortedarray = [persons sortedarrayusingcomparator:^nscomparisonresult(person *p1, person *p2) { return [p1.name compare:p2.name]; }]; i'm unable reproduce same statement swift . found using array . you can either use swift's built in sort functions or, since swift array bridged nsarray can call sortedarrayusingcomparator swift directly. using swift's sorted function: var sortedarray = sorted(persons) { (obj1, obj2) in // downcast person needed if persons nsarray or swift array of anyobjects let p1 = obj1 person let p2 = obj2 person return p1.name < p2.name } or, using nsarray 's sortedarrayusingcomparator : var sortedarray = persons.sortedarrayusingcomparator { (obj1, obj2) -> nscomparisonresult in let p1 = obj1 person let p2 = obj2 person let result = p1.name.compare(p2.name) return result }
Post a Comment
Read more

opencv - Camera pixels to planar world points given 4 known points -

-
Image
my problem assuming easy, still haven't been able solve due experience in linear algebra while ago. have read presentations published several universities can't seem follow non-standardized notation. if has better example appreciated... problem: camera angled down facing floor. given pixel coordinate, want able respective 3d world coordinate on plane of floor. known: 4 dots on floor know pixel(x,y) coordinates , associated world(x,y,z=0) coordinates. the camera's position fixed , know displacement in x,y,z directions of camera. unknown: the camera's rotations x,y,z axis. primarily, camera rotated x axis y & z being minimal rotations think should taken account. distortion coefficients, there minimal bending of images in lines , prefer not bring in checkerboard calibration procedure. error result of not deal breaker. what i've looked into phenomenal example found here. in essence it's exact same problem, follow questions: solvepnp l...
Post a Comment
Read more

bash - What does 'echo 0 > foo' mean? -

-
i know code mean? echo 0 > foo completely new unix , bash commands. lots of stuff learn, need quick answer question. it echoes 0 file named foo . in other words, redirects output, 0, file named "foo", instead of showing on screen. from basic wikipedia example on redirection: command1 > file1 executes command1, placing output in file1, opposed displaying @ terminal, usual destination standard output.
Post a Comment
Read more

uitableview - xamarin ios formatting a TextLabel in a UITableViewCell -

-
is there reason why cant use string.format format textlabel in uitableviewcell there no errors in seems ignore or compress padding eg {0,-10} i using xamarin studio ipad development , hoping use format rather creating custom cell
Post a Comment
Read more

f# - Records satisfying implicit interface w/o re-implementing -

-
seeing record has public getter/(setter) fields, possible specify record satisfies matching interface without re-implementing it? for example: type itext = abstract text : string get,set type textrec = { mutable text : string } now seeing record implements interface implicitly, i'd put "inherit itext" or "interface itext" (with no body) on record, appears can't that. is, believe have re-implement interface adding record: interface itext member this.text get() = this.text , set(v) = this.text <- v thanks f# not support implicit interface implementations (not classes), 1 of frequently requested features , might happen in future. see why useful. i don't think there workaround - best option write additional piece of code needed implement interface. if wanted adventurous, try writing "wrapping" function creates interface implementation value provides required members. using static member co...
Post a Comment
Read more

angularjs - Redirect to an external URL -

-
i'm developing web application using angularjs authentication page doesn't use angularjs, uses html . so when user disconnected must redirect him authentication page,so made interceptor executed before request , use service application validate if user connected , if he's not must redirected authentication page . this interceptor code : $httpprovider.interceptors .push(function($q, $injector) { return { 'request' : function(request) { var $http = $injector.get('$http'); /* calls service application verify if user connected */ $http .get("sessionvalidator") .success( function(data) { ...
Post a Comment
Read more

php - Add Values to Existing Wordpress User Meta Data -

-
i using simplexml_load_file bring data wordpress , add data user_meta_data. i understand can pass array of meta key values @ time creating or updating meta data when run page again, new xml data, overwrites existing data. what want happen add value same meta key. in different instance (when script runs again). here doing. the reason 2 update_user_meta creating 1 meta key called "inbox-items" contains id's incoming email messages. second, creates new meta key id contains details of message (date, msg, from, etc...) $msg_array = array ( 'msg-date' => $msg_date, 'msg-details' => $msg_msg, 'msg-id' => $msg_msgid, 'msg-keyword' => $msg_keyword, 'msg-from' => $msg_from ); update_user_meta($keyword_...
Post a Comment
Read more

javascript - Java method call using dojo -

-
i have java class contains method, having business logic in it. need call java method directly jsp (except through servelet or struts action or scriplets) on button click. know can done using dwr (as per behavior), there possibilities call java methods directly using dojo framework? i concern dojo instead of using dwr because in application i'm using dojo framework. app contains struts2 without calling struts action, using dojo (ajax calls) need call particular java method directly in dwr. people have experience in using dojo please guide me on this. note: please let me know if require code parts of app, think above description might fine enough understand motive. thanks. zulox, what need set model-view-controller architecture web application. this, can invoke method in back-end code upon click has occured in front end. with mvc, view provides user interface element of application. it'll render data model form suitable user interface. the controller...
Post a Comment
Read more

syntax highlighting - AvalonEdit default color when no rules are matched? -

-
currently when there text no rules matched, text defaults black. i've tried change highlight color of default text, far no luck. any suggestions on how go updating default text color? you cannot change default text color in syntax highlighting. instead, set editor.foreground .
Post a Comment
Read more

windows server 2008 r2 - Set Owner of Directory and Sub Containers in C# -

-
when setting owner of preexisting folder in server 2008 r2, there way make propagate of sub containers under object? can in properties diag, not see switch this. i looking way avoid recusing through sub containers this. this code switch owner top level directory. directoryinfo mydirectoryinfo = new directoryinfo("path here"); directorysecurity mydirectorysecurity = mydirectoryinfo.getaccesscontrol(); system.security.principal.identityreference myowner = new system.security.principal.ntaccount("target owner account"); mydirectorysecurity.setowner(myowner); mydirectoryinfo.setaccesscontrol(mydirectorysecurity); there no overload provide you. but following code that: directoryinfo directoryinfo = new directoryinfo(path); var directories = directoryinfo.enumeratedirectories("*.*", searchoption.alldirectories); foreach (var directory in directories) { // set owner } note use enumeratedirectories instead of d...
Post a Comment
Read more

How do Python tell “this is called as a function”? -

-
a callable object supposed defining __call__ . class supposed object… or @ least exceptions. exception i'm failing formally clarify, question posted here. let a simple class: class a(object): def call(*args): return "in `call`" def __call__(*args): return "in `__call__`" the first function purposely named “call”, make clear purpose comparison other. let's instantiate , forget expression implies: a = a() # think of `a = magic` , forget `a()` now what's worth: print(a.call()) print(a.call()) print(a()) print(a()) result in: >>> in `call` >>> in `call` >>> <__main__.a object @ 0xnnnnnnnn> >>> in `__call__` the output (third statement not running __call__ ) not come surprise, when think every said “python class objects”… this, more explicit, run __call__ print(a.__call__()) print(a.__call__()) >>> “in `__call__`” >>> “in `__call__`” all of sh...
Post a Comment
Read more

javascript - Target a certain PHP function with $.ajax -

-
hey guys have scenario, i want use ajax $.get method target php function in separate php file. not sure syntax. the javascript function all(){ $.get({ url: "functions.php function ", success: function success(data){ paint(data) }, datatype: "html" }); }); function.php <?php function helloworld(){ echo "hello world"; }; function hellomars(){ echo "hello mars"; }; any appreciated pass variable in data attribute or url query string, , in php script, choose function based on variable. $.get({ url: "functions.php", data: { "vname": "something" }, success: function success(data){ paint(data) }, datatype: "html" }); http://api.jquery.com/jquery.get/ php: if ($_get["vname"] == "something") { helloworld(); } else { hellomars(); } http://php.net/manual/en/reserved.variables.get.php
Post a Comment
Read more

objective c - Can a method return a different return type besides the one specified? -

-
lets have deck class based on nsobject. have playingcarddeck based on deck class. how method bellow legal ? -(deck *) createdeck { return [[playingcarddeck alloc]init]; } supposing coded object inheritance correctly: yes, legal because playingcarddeck indeed deck.
Post a Comment
Read more

c# - how to execute a linq query in association table -

-
i'm new entity framework. i have 3 tables. candidats : id,cin poste : id postecandidats : candidat_id, poste_id i want candidat has (cin= 'abc15' , poste_id = 3) my models : public class candidat { public int id { set; get; } public string num_cin { set; get; } public icollection<poste> postes { get; set; } } public class poste { public int id { set; get; } public string poste_name {set;get} public list<candidat> candidats {set;get;} } that generates association table postecandidats. i tried : i tried gives me error var v = _db.candidats .where(c => c.num_cin == "abc15" && c.postes.any(pc => pc.id == 3)); var candi = v.singleordefault(); but gives me nothing (i think problem any() method ) 2 samples both work: var lcandidat = new list<candidat>(); lcandidat.add(new candidat{ id = 2, num_cin = ...
Post a Comment
Read more

java - EclipseLink doesn't include generate options on a ManyToMany relationship -

-
i'm having issues eclipselink / jpa (2.5.2), postgresql (9.3) , schema generation . spring application, love create @manytomany relationship between 2 classes, refuses create third middle table supplied 2 cascade options . both classes have proper implementations of hashcode() , equals(...) , both involved in other relationships, non @manytomany of course, support cascade options , work fine. [stream]-(0..n)--<streams_tags>--(0..n)-[tag] the following fragment of ddl script regarding manytomany relationship: create table streams_tags (tagged_streams integer not null, tags integer not null, primary key (tagged_streams, tags)) ... alter table streams_tags add constraint unq_streams_tags_0 unique (tags, tagged_streams) ... alter table streams_tags add constraint fk_streams_tags_tagged_streams foreign key (tagged_streams) references tags (tid) ... alter table streams_tags add constraint fk_streams_tags_tags foreign key (tags) references streams (sid) the foll...
Post a Comment
Read more

ruby on rails - Rake secret command not working -

-
when run rake secret in terminal, instead of getting new key, nomethoderror: undefined method 'reject' #<string: blah blah blah> c:/sites/appname/config/application.rb:10:in '<module:appname>' c:/sites/appname/config/application.rb:9:in '<top (required)>' c:/sites/appname/rakefile:4:in '<top (required)>' i've checked 3 lines identical ones of known project. i'm using ruby 2.0.0 rails 4.1.1 i'm in current project folder. when run rake secret in other projects, command works, not when run new project. the issue figaro gem. broke rails s commands, , rake commands. haven't figured out how fix yet, more come soon. edit: the error typo in application.yml file used figaro.
Post a Comment
Read more

winforms - Time Series in MS Charts with C# -

-
Image
this question has answer here: enable scrolling on microsoft chart control windows forms 2 answers i using ms charts plot points time series, this chart1.series[0].points.addxy(time, voltage); i large number of data (1 point / 100 ms), @ end of day program slow plot new data. therefore, want able scroll x-axis of chart automatically after amount of time, example 30 mins or so... want keep data plotted not directly visible user, hidden left of chart.. how can it? edit : see edit @ end along solution zooming in set you should plot visible, nothing else. either keep old values in memory or persist them disk , load them needed. here example: i have 1 000 000 points in memory , can seamlessly scroll , drawing happens instantly. using system; using system.collections.generic; using system.linq; using system.windows.forms; using system.windows.fo...
Post a Comment
Read more

ActionScript 3 (AS3) how to pick random array? -

-
i have problem, don't know how pick random array . var enemies:array; public function main() { entimer = new timer(1000); entimer.addeventlistener("timer", createenemy); entimer.start(); } private function enemy1():void { var enemy1 = new enemy1(); enemies.push(enemy1); } private function enemy2():void { var enemy2 = new enemy2(); enemies.push(enemy2); } public function createenemy():void { //here problem how pick random enemy ?? var en = enemies[math.round(math.random() * 2)]; stage.addchild(en) } after im geting error: implicit coercion of value of type array unrelated type flash.display:displayobject. you've got few problems code. for starters, you're defining 2 functions, enemy1 , enemy2 have looks 2 classes named enemy1 , enemy2 . refrain calling functions , classes same name can confusing. in addition, reason getting error: implicit coercion of value of type array unrelated type flash.display:displayobject. is be...
Post a Comment
Read more

stl - C++ iterator over certain elements in vector -

-
please forgive me if trivial question, i'm learning c++ , try wrap head around concepts. when comes iterators, i'm lost. say have custom class representing data structure, , 1 of members vector of integers. want write bidirectional iterator class, outputs numbers in vector. there easy , instructive way? i'd prefer not using libraries other stl. #include <vector> #include <iostream> class x { public: class eveniterator { public: eveniterator(std::vector<int>::iterator it, std::vector&ltint>::iterator end) : it(it), end(end) { while (true) { if (iseven(*it)) { break; } else if (it == end) { break; } it++; } } bool operator != (const eveniterator& evenit) { return evenit.it != this->it; } int operator * () { return *it; } eveniterator operator ++ () { while (true) { it++; if (iseven(*it)) { ...
Post a Comment
Read more

http request in javascript pdf api -

-
i'm trying request javascript api adobe reader. i'm using net.http object following code: get = app.trustedfunction (function(curl) { app.beginpriv(); var params = { cverb: "get", curl: "http://ip_addr/checker/comments/1", ohandler: { response: function(msg, uri, e) { if(e != undefined && e.error != 405) { app.alert("failed get: "+ e); } else app.alert("connected"); } } }; net.http.request(params); app.endpriv(); }); when call function in code, first time program opens working fine , can connect. the problem when call function again using submenu this: app.addmenuitem ({cname: "connect", cparent: "edit", cexec: "get()"}); i error, tried adding pdf file privileged locations because think it's secu...
Post a Comment
Read more

How to properly use pivot funciton to combine multiple values (or columns) into within one column in SQL Server? -

-
Image
i have table contains upc, month# , week# these 3 main columns. (screenshot below) is possible create view or display table groups week numbers 1 column each unique upc there many rows displayed. (example this) do need use pivot function group grouping sets achieve this? thanks. sql fiddle ms sql server 2008 schema setup : query 1 : declare @table table (recordid int, upc bigint, monthnumberonpromo int, weeknumberonpromo int) insert @table values (1 , 2529230005 , 1 , 1) , (2 , 2529230005 , 2 , 6), (3 , 2529230005 , 3 , 11) , (4 , 2529230005 , 4 , 15), (5 , 2529230005 , 6 , 22) , (6 , 2529230005 , 7 , 27), (7 , 2529230005 , 8 , 31) , (8 , 2529230005 , 9 , 35), (9 , 2529230007 , 1 , 1) , (10 , 2529230007 , 2 , 6), (11 , 2529230007 , 3 , 11) , (12 , 2529230007 , 4 , 15), (13 , 2529230007 , 6 , 22) , (14 , 2529230007 , 8 , 31), (15 , 2529230007 , 9 , 35) , (16 , 2529230007 , 10 , 38), (17 , 2529230007 , 12 , 51) se...
Post a Comment
Read more

mysql - How to display data from both tables -

-
mysql> desc customer_delivery_loc; +---------------+--------------+------+-----+---------+----------------+ | field | type | null | key | default | | +---------------+--------------+------+-----+---------+----------------+ | cust_loc_id | int(11) | no | pri | null | auto_increment | | customer_id | int(11) | yes | mul | null | | | locality | varchar(100) | yes | | null | | | area | varchar(100) | yes | | null | | | address | varchar(100) | yes | | null | | | city | varchar(50) | yes | | null | | | state | varchar(50) | yes | | null | | | phone_number | bigint(20) | yes | | null | | | +---------------+--------------+------+-----+---------+----------------+ mysql> desc vendor_home_delivery; +-----------+--------------+------+-----+-----...
Post a Comment
Read more