excel - Dividing time to get a percentage -

This is my setup: I am creating a log for a time event that I am doing (think It seems like running), split in split time with a compressed time, formatted as [hh: mm: ss.000] time values.

What I want to do is to find out how much time is in the form of a percentage of cumulative time

What I'm going to do, basically A6 (Segment) ) / A10 (cumulative time) * 100 , although this formula certainly does not work.

If the stop clock time (start with 0 in A0) So try below B2 in the form of suits and percentages:

  = (A2-A1) / A $ 10  

java - im trying to get the index of a character using only the charAt and length methods for strings -

I am trying to get an index of letters, only four art and long ways to use stars. This is the same question that asks: Declare a public law, which takes a character parameter named Indexof and gives the indicator in the stored string of the first occurrence of that character -1 or if the character is not found. This is what I have to do.

  public int indexOf (char c) {for (i = 0; i & lt; string.length - 1; i ++) {if (string.charAt (c) == string .charAt (i)) {return i; Other {return -1; }}  

You to loop 0 to length () - 1 , and test the value parity of charAt (index) with the given character

Translate query to Laravel Eloquent Model -

How do I translate the following query into a format that can parse Laravel ?

Select the posts, titles from posts, albums where post. Id !: album. Post_id

now have ORM links

< P> a

So far I have

post with I :: ('album') -> select ('id', 'title') - > Get ();

I do not know how to declare the condition

Please read the docs again, I think If you use a well known ORM, then the biggest reason for its relationship is "yes"

you can query for

An example in a link is just fill in your query and you're done.

cannot seem to get bitmap from view in android -

My problem is similar to one.

my code to work with the method

P>

  private bitmap getBitmapFromView (View v) {v.setDrawingCacheEnabled (true); Wkmasur (Measurespeskmakemeasurespes (0, Measurespeskunspesifaiad), Measurespeskmakemeasurespes (0, Measurespeskunspesifaiad)); V.layout (0, 0, v.getmesuredWidth), v.getMeasuredHeight ()); V.buildDrawingCache (true); Bitmap b = bitmap.kreatebitmap (v.getDrawingCache ()); V.setDrawingCacheEnabled (false); // Clear drawing cache returns b; }  

But today I after changes have changed the XML layout files I line Bitmap b = Bitmapkkretebitmap (v.getDrawingCache ()) NullPointerException Receiving. I

  public static bitmap loadBitmapFromView (View v) {Bitmap b = Bitmap.createBitmap (v.getLayoutParams (). Width method  getBitmapFromView  try to change Key, V.getLayoutParams (). Height, Bitmap.sf. ARGB_8888); Canvas C = new canvas (B); V.layout (0, 0, v.getLayoutParams (). Width, v.getLayoutParams (). Height); V.draw (c); Return b; }  

But this did not help, I get null in the first line.

The situation is: I am trying to convert the view into bitmap. But I'm doing this without displaying the scene on the screen. Again, it all worked until I changed the content of the XML layout file. The change was not too big I just removed the stuff and removed - yes it was removed - some sub-scenes.

In any case, I know that there is no problem with my layout file because I can display it on screen if I want to; Which I have done as part of troubleshooting.

Someone has suggested using a handler to call getDrawingCache () . If he answers this question, how would I write that code?

Update

  View View = activity.getLayoutInflater () increase. (R Layout My_view, blank, incorrect); FindViewsByIds (see); // where I inflate sub-views and add content to them  

After

createBitmapFromView is executed when the view is measured.

  public static zero performance when see (Last View View, Final Runnab Runner) {if (view.getMeasuredHeight () == 0 || view.getMeasuredWidth () == 0) {view.getViewTreeObserver (). AddOnGlobalLayoutListener (New ViewTreeObserver.OnGlobalLayoutListener) {@Override Public Layer on Public Zero () {runnable.run (); RemoveGlobalOnLayoutListener (see, this);}}); } And {runnable.run (); }} Public static bitmap createBitmapFromView (View) {Bitmap bitmap = Bitmap.createBitmap (view.getMeasuredWidth (), view.getMeasuredHeight (), Bitmap.Config.ARGB_8888); Canvas canvas = new canvas (bitmap); View.draw (canvas); Return bitmap; } @TargetApi (Build.VERSION_CODES.JELLY_BEAN) public to view static void removeGlobalOnLayoutListener (see, ViewTreeObserver.OnGlobalLayoutListener listener) {try {view.getViewTreeObserver () removeOnGlobalLayoutListener (listener). } Hold (Noschamparter E. E) {view.getViewTreeObserver (). RemoveGlobalOnLayoutListener (listener); }} ExecuteWhenViewMeasured (see, new Runnabel) {@Override Public Zero Run () {bitmap bitmap = createBitmapFromView (see);}});  

Java generics - Don't allow subclasses -

I have a question about generic, then say that I have 3 squares "foo", "bar" (which fu Subclass is), a square "factory" and an interface "test interface". I want to write a general method, which only allows objects that implement the "straight" interface, so there is no subclass. This is very difficult for me, because Java 8 seems "smart" compared to Java 7.

Then there is an example:

  Public Interface Test Interface & lt; Expansion of T-Test Interface & lt; T & gt; & Gt; Public Square Foo Exam Interface & lt; Foo & gt; {}  

---

  Expands the public class bar {/ code>   

---

  Fu {}  

---

  Public class factory {Public stable and lieutenant; Expands T's Test Interface & lt; T & gt; & Gt; T doSth (T-ARGE) {return arg; }}  

OK, these are my classes. I now want to allow Foo-objects in this case because of the doSth (T arg) method This is the only class that implements the "straight" interface.

Obviously sth will no longer compile in this way:

b> factory.dos (new bar);

Since the bar TestInterface & lt; Bars & gt;

OK, my problem is now, that this line will compile without any issues:

  FUF = FACTORY. Doth (new bar);  

Although the normal parameters should also apply the interface to T and T with their own class (sorry, actually do not know how to say it, hope you know it That's what I mean) The compiler accepts "bar" as the parameter

then the compiler should "behave like okay, the bar does not fit, but maybe a super class would fit." And then it "sees" that it works with Superlex "Foo". And then the bar will be explained like fu because every time there is some type of fu or something like that ?? At least this is how I imagine it.

OK, if I try to compile the line with Java 7, then it fails. So it seems that the Java 8 is a bit smarter with type-arasher ?!

There is no way to allow subclasses in Java 9, so that it will not be compiled ?:

  Foo F = Factory.doth (new bar) );  

Hope you will understand my problem, I'm rarely writing in English.

Greetings

Reasons Foo F = Factory.dom (new bar ()); Works in Java 8 and Java is not 7 because Java 8 has a better type of estimate in Java 7 this type is estimated:

  FUF = Factory. & Lt; Bars & gt; Dasath (new bar ());   
  Bar   TestInterface , but this is  TestInterface & lt; Foo & gt;  is applied by inheritance to the Java 8 type of estimation, and this type would be estimated: 
 
  FUF = Factory & Lt; Foo & gt; Dasath (new bar ());  
 
 Note that  factory. & Lt; Foo & gt; DoSth ()  expects that  Foo  as argument is applied to  new bar ()  implications on  foo  that works fine Does. 
 
 I am afraid that there is no way around it. You will always be able to uplift an object in your superclass. You can create  Foo   last , but it does not allow full subclassing of  Foo . 
 

python - Resolving TypeError str doesn't support the buffer API -

I am trying to match the following code, but I run in a TypeError: type str buffer is not supported API does How can this be solved?

  file = open ("C: \\ user \\ sagars \\ desktop \\ newips.json", "rb") i = 0 y = "not for line in file" Information available for "IP": z = line print (z) if y in z: print ("can not be parsed") Other: print ("can pars!")  

< / Div>

You are reading the file as binary (instead of 'rb' which is probably messing it up) This code snippet is slightly more idiotic:

  open As ('C: \\ user \\ sagars \\ desktop \\ newips.json', 'r') f: line = F.readline () if y in line: print ("can not be parsed ") And: print (" can pars! ")  

Java, operator overloading and "+" operator for String -

I suspect operator overloading in Java. I know that the Java operator does not support overloading, but then the "+" operator is doing it in a valid Java program:

  import java.util *; Import java.lang *; Import java.io * *; Class operator ologingtest {public static zero main (string [] args) java.lang.Exception throws {string str1 = "operator"; String str2 = "overloading"; String str3 = str1 + str2; Println (str3); }} Stout: Operator overloading  

This operator is not "overloaded", it is pre-installed String Consensitivity Operator Designated Operator,

15.18.1 String Coordination Operator +

If only one operand expression type is string, then string conversion (§5.1.11) is used to prepare strings at run time on other operands. The result of the string combination is a reference to the string object, which is a combination of two operand strings.

In other words, when Java sees

  string races = string obz + some obj;  someObj.toString () . 
 

Filter column values (different) one by one using Excel VBA -

I'm trying to filter the values ​​of column one. The price under the filter is different every time is there any way that the macro can capture it.

  Sub Macro 1 () Sheets ("Open"). Choose less than 0 invoice values. ActiveSheet.Range ("$ A $ 1: $ R $ 2700") Auto Filter Field: = 11, Criteria1:. = "& Lt; 0", _ operator: = xlAnd 'Selected Country ActiveSheet.Range ("$ A $ 1: $ R $ 2700") Auto Filter Field: = 3, Criteria1. : = "ARG" 'Selected invoice # ActiveSheet.Range ("$ A $ 1: $ R $ 2700") Auto Filter Field:. = 7, Criteria1 :. = "1,007,225" category ("G528") Select ActiveSheet.Range ("$ A $ 1: $ R $ 2700") Auto Filter Field:. = 7, Criteria1: = "1,015,678" ActiveSheet.Range ("$ A $ 1: $ R $ 2700".) Auto Filter Field: = 7, Criteria1: = "1,018,523" range ("G1"). Choose ActiveSheet.Range ("$ A $ 1: $ R $ 2700"). AutoFilter Field: = 7, Criteria 1: = "1018962" end sub  

stuff your . Find the set using the AutoFilter field in the Nested Variant array and by using Rank . With LBound and UBound .

  sub a1Multi_Filter () as Dim V Long, vCRITs version as dim vKey version, dCOL7s New Scripting.Dictionary dCOL7s.CompareMode = BinaryCompare vCRITs = array (array as 11 , Array (7, "1015678"), _ Array (7, "1018523", "Array"), _ Array (3, "ARAG"), _ Array (7, "1007225"), _ ), _Arere (7, "1018962") for ActiveSheet.Cells (1, 1) V.CurrentRegion .AutoFilter = LBound (vCRITs, 1) to UBound (vCRITs, 1) .AutoFilter field: = vCRITs (v ) (0), Criteria1: = vCRITs (v) (1) "Pause and processing for effect" MSBBX "array presets" & amp; Chr (10) & "Filt ("0") & amp; "for" & amp; VCRITs (v) (1); & amp; nbsp; (0, 0) & amp; "On the Columns" & amp; Crow (64 + VCRTS (V) ) .AutoFilter field: = vCRITs (v) (0) Next v. AutoFilter for v = 2 .Rows.Count if cinchool (lane (V, 7). Value) and not dCOL7s.Exists (.csells (v , 7) .Value) then _dCOL7s.Add key: = cells (v, 7) .Value, Item: for each vKey = 7 Next to V. dCOL7s.Keys' V = 0 (DCOL 7. Number -1). Autofilter field: = DCOL 7 Item (VKA), Criterion 1: = Message for Pause and Processing for Effects Box "Column 7 Special" & amp; Chr (10) & amp; "Filtered" & amp; . Leaf (0, 0) & amp; "On column" & amp; Crow (64 + DCOL 7. Item (VKA) & amp; "For" & amp; VKey .AutoFilter Field: = dCOL7s.Item (vKey) with the next vKey end dCOL7s.RemoveAll: Set dCOL7s = Something End  

I leave you many rooms for processing and messaging The text should be used to help explain the elements of the variant array (A).

After setting field arguments and set criteria for the criteria, uses for ... next loop for the limitations of the processing of lower and upper limitations of the first rank . Each set has been applied in turn and I stopped it with an Assembled box, showing the AutoFilter category, filtered field and filter criteria. After 'processing', auto filters for the area are cleared in preparation for the next.

Appendix:

I added the unique items in a scripting dictionary from the collection column, and then each key has the same . AutoFilter is bicycle through the document key and item, using filters and criteria as the . To use a scripting dictionary, you should go to VBE's device ► References and add Microsoft scripting runtime to the project. It should be added only once; Not for every computer that it can run but if a new project has been started which uses a scripting dictionary, then that project should also be added.

How to get two files from the terminal to be used by a class (as in java.io.File) -

So I'm taking two files (most likely) and passing them through a terminal in a class , Which will be used later in the input and scan with a buffered reader. Although I am having difficulty finding out how to do this through the terminal and not only call indiscriminate file names in the code.

The end result of the call should look like this

  java & lt; Class & gt; FileA.txt fileB.txt  

or

  Java & lt; Class & gt; Desktop / FileAntest Document / File B.txt  

Can use:

  public static zero main (string algos []) {if (args.length & lt; 2) throw new exception runtime ("2 arges should be!"); File file 1 = new file (args [0]); File file 2 = new file (args [1]); }  

jax rs - How to get RESTEasy to use system web proxy? -

I am using a lush client in Java 8 with RESTEasy 3.0.10. As an implementation of the funnel windows 7 64-bit uses RESTEasy in place of the Apache httpclient 4.2.6.

I have to manually specify a web proxy for the httpclient, so if I configure a in my code ResteasyClientBuilder use a specially configured ApacheHttpClient4Engine , use my RESTEasy client connection correctly proxy.

My problem is that I would use the java.net.useSystemProxies system property so that my Java program which is configured in the Proxy Windows Internet Options, will use , So that my Java program will work seamlessly with other programs and it is not necessary that it can be specifically configured. It works fine for connections using Java's native HTTP connection. But the RESTEasy / Apache httpclient apparently opens a straightforward socket and makes its HTTP communication at a low level.

When I tell Java to use the system proxy, Java actually routs the httpclient connection to the proxy. But for some reason, the httpclient thinks this is a SOCKS proxy --- or some other --- the request bar is talking to:

  java.net.SocketException: SOCKS proxy can not connect: connection timed out are: java.net.Socket.connect (Socket.java:589) org.apache.http.conn.scheme.PlainSocketFactory.connectSocket (at JavaknetkSocksSocketImplkconnect ( SocksSocketImpl.java:429) connected on Org.apache.http.impl.conn.ManagedClientConnectionImpl.open (org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection PlainSocketFactory.java:127) to (DefaultClientConnectionOperator.java:180) (ManagedClientConnectionImpl.java:294) .apache.http.impl.client.DefaultRequestDirector.tryConnect org.ap On ache.http.impl.client.DefaultRequestDirector.execute (DefaultRequestDirector.java:479) (DefaultRequestDirector.java:643) on Org.apache.http.impl.client.AbstractHttpClient.exec on org.apache.http.impl.client .AbstractHttpClient.execute (AbstractHttpClient.java:906). Ort.exe (AbstractHttpClient.java:805) org.jboss.resteasy.client.jaxrs.engines.ApacheHttpClient4Engine.invoke at (ApacheHttpClient4Engine.java:283) at org.jboss. Resteasy.client.jaxrs.internal.ClientInvocation.invoke (Client Invocation. Java: 407) at org.jboss.resteasy.client.jaxrs.internal.ClientInvocationBuilder.get (ClientInvocationBuilder.java:159) having  

close SOCKS routing another default proxy selector And in reality this same system prevents the httpclient socket from being routed to the proxy --- but then the HTTP connection completely overrides the proxy, which aims to ignore.

I'm guessing here that the httpclient only asks for one socket, and the Java system looks at the proxy and assumes that the socket connection is for a sock proxy, even if I guess If the Java Sockets have been passed in the Web Proxy, then the httpclient will not know anything about it and as a result the correct proxy format of the HTTP request has not been seen. Or will you see in any manner that java.net.useSystemProxies is turned on, and will change its request? But how will it know if the system proxy is actually in effect or not?

So I'm completely at a standstill. If I java.net.useSystemProxies on thee, and turn on the normal HTTP requests in Java, so they use the system configured web proxy I I made system-configured web proxy How can I tell RESTEasy / httpclient to use?

APACHE PIG CAN'T LOAD BAG -

I have a file test.txt with the following bag:

  {(es , (1,), (D, 1), (PA, 1), (RO, 1), (such, 1)} {(SS, 1), (D, 1), (this, 2) , (1), (Ps, 1), (ro, 1), (such, 1)} {(es, 1), (d, 1), (such, 1)}  

P> I want to load them into pigs

  as A = load 'test.txt' (language_bag: bag {t: (a: chararray, f: int)});  

And I get the following error.

[main] error org.apache.pig.tools.grunt.Grunt- Error 1200: mismatch input '; 'RIGHT_PAREN Expectation'

Description on logfile: /homes/ruthgavi/Projects/Conferences/PigScripts/pig_1426528460732.log

Does anyone help me to understand that What I am doing: (

It may be useful.

  A = Load Test.txt "(language_bag: bag {t: tuple (a: charrray, f: int)}); c = foreach; generated language_bag.a, language_bag.f; dump c;  

junit - Trouble with assertEquals (Java) -

I'm trying to make a game of "rock, paper, scissors". I have such tests:

  @Test Public Zero Rockbatscissors () {assertEquals (rock, rock.vs (scissors)); }  

I think it should be enough to form a function, for example:

  Public square rock {Object vs (scissors) } Rock(); } Object vs (Paper P) {Return new paper (); } Object vs (Rock R) {New Rock (Return); } Boolean equivalent (rock R) {return true; } Boolean equivalent (Paper P) {return false; } Boolean par (scissors) {return false; }}  

(I know that I should add the Hashkod function, by the way) I run the test and only I get the failure. What am i doing

equal () code> emphasis () Which takes object as the argument. Right now, you have not overridden the object # equals () method, but use your own 3 equal method, which will not even be used, and thus the default The object class method is used, which compares the context.

You have to give the following implementation:

  / ** * Terrible 'par ()' method implementation. Just for display purpose * / @ Override public boolean equivalent (object oBJ) {Oz example for returning to rock; }  

timeout - mysql workbench "Lost connection to mysql server" -

Firstly, I need to indicate that I have run a SQL file on Wikipedia dump on my machine and I may have to update many settings about the index size available on memory and some other settings. I just want to mention that those large SQL queries were successfully run and About if there was no problem.

Now I have a table pjlnx (pl_from, pl_title) which appears in each Wikipedia page, for example the data (1, "title1"), (1, "title) 2 "), (2," title 3 "), (2," title 1 "). I want to create a table which is titled by group group pl_fr for this, this is my SQL query (I am using workbench):

  SET @@ group_concat_max_len = 150000;  

I found an error in running this query: Link to the table "The connection to mysql server was lost during the query" (the keyword playlist, group_concat (pl_title, '')) and the system Asked me again for the password. So I searched and found. So I changed net_read_timeout to 1000 and connect_timeout to 60. This problem did not resolve, so I changed the query:

  SET @@ group_concat_max_len = 150000; Create table concatpagelinks (select pl_from, GROUP_CONCAT (pl_title, '') as link pagelinks group by pl_from 0,1000)  

Still the same problem, and surprisingly That every time the query runs for 600.495 seconds and the error occurs.

You can try to change the timeout value in the workspace. Visit: → Edit → Preferences → SQL Editor → Time to Read DBMS Connection

For more information, refer to this post:

Or in price Try to increase: Edit → Preferences → SQL Editor → DBMS Connections Keep Live Interval

ios - How to write in a new shader file in SceneKit: consecutive statements on a line must be separated by ;? -

I'm starting with SceneKit and shaders, I created a fast file, changed its name to its name. Shader, and I added this:

  Uniform sample is 2D RTBL; // This horizontal blot should be changed by changing the VC2 vTexCoord to the text provided; Const Float Blur Size = 1.0 / 512.0; Zodiac + = Texture 2D (RTLR, vC2 (vTexCoord.x, vTexCoord.y - 4.0 * Blur Size)) * 0.05; Zodiac + = Texture 2D (RTLL, VTexCoord.y - 3.0 * Blur Size) * 0.09; Zodiac + = Texture 2D (RTL, VTexCoord.y - 2.0 * Blur Size)) * 0.12; Zodiac + = Texture 2D (vTexCoord.x, vTexCoord.y - blurSize)) * 0.15; Zodiac + = Texture 2D (vTexCoord.x, vTexCoord.y)) * 0.16; Yoga + = Texture 2D (RTLL, vTexCoord.x, vTexCoord.y + Blur Size) * 0.15; Zodiac + = Texture 2D (RTLL, VTexCoord.y + 2.0 * Blur Size) * 0.12; Zodiac + = Texture 2D (RTLL, VTexCoord.y + 3.0 * Blur Size) * 0.09; Zodiac + = texture 2d (rtblr, vc 2 (vTexCoord.x, vTexCoord.y + 4.0 * blur size)) * 0.05; Gl_FragColor = sum; Blue Tutorial  

But I get 3 errors on 3 first rows: It asks me to add a ; :

I have not understood the problem

thanks

I created a fast file It has changed its name to MyFragment.shader

This is your problem.

When you add a file to your project, Xcode determines what kind of file this is. If you make SWIFT files, then it will compile with Swift Compiler. (And the swift compiler will not expect to write the contents of that file in Swift, not GLSL.)

You do not want to compile your shaders as a native (CPU) source when your app runs So by OpenLL the shader (for the GPU) is compiled, so that you copy them to your bundle and send it to GL (in your case via the sineaket), when you are ready to use them Be the first one.

The file processing rules in your project are not automatically changed when you rename the file type extension. (This is because you can use a different extension than the default of Xcode for some file types.) So, here are two fixes for two different references:

Build for an existing file Change the rules

Whatever you've got, you probably do not want to recreate some parts of your project, you just want to tell Zedod to treat your shader as a shader, Swift source In the Select your project in the Navigator, go to the Build phase and myFragment.shader Copy to copy the compiled sources bundle resources.

Add a new file right Creating Rules

You can avoid the above after creating new shader files If you create a new file by using the empty file template, then it is already bundled with the resource Will be considered as a form, so you do not need to do anything further.

Similarly, if you .shader or .fsh or .vsh (or actually anything that is not SWIFT / C / OBJC / etc source file) your project , Which will be considered as bundled processing by default.

wordpress - Mailchimp Batch Subscribe 2.0 Returns False on 500+ records (PHP) -

I have a PHP script to update Mailchimp using the batch-subscribe from my WordPress userlist. ()

When I send about 400 records, everything works fine. All records have been added, and I get a return from the number of extra records from the API, etc.

If I have around 600 or more (I have 730 customers), then all records are added to the scam, but the API returns false, I check it again with false ===, and it's wrong is. I did not get any error - it just returns false (but all records are added to the mailchap).

Mailchimp says "Max batch size varies depending on the amount of data in each record, although you have 5k-10k records based on your experience."

I'm not close to that, and every record is being added to the mailchip list just fine. I did not get a refund from the API.

I increased my timeout value to 5 minutes. I also switched to using different records, suspecting that I might have a record with something that is messing it up, but there was a similar behavior with its various records.

I'm using the DrewM library interface with Mailchimp API version 2.0 I'm sure that the DrewM is using the post for the request, and it does. ()

Any thoughts that are happening due to this?

Here is the code:

  function mailchip dialupdate () {set_time_limit (300); $ Api = get_mc_api (); $ McListId = get_mc_mailing_list (); $ MailChimp = New \ Drewm \ MailChimp ($ api);  

...

  foreach ($ $ bloggers as a user) {$ userinfo = get_userdata ($ user-> ID); $ Location = ... // code to obtain the location $ merge_vars = array ('FNAME' => $ userinfo- & gt; first_name, 'name' = & gt; $ userinfo- & gt; last_name, 'MMERGE3' => $ userinfo- & gt; user_login, // username 'MMERGE6' => $ location // location); $ Batch [] = array ('email' = & gt; array ('email' = & gt; $ user- & gt; user_mail), 'merge_wars' = & gt; $ merge_vars); } // and forehack // mailchap calls $ reval = $ MailChimp- & gt; Call ('lists / batch-subscribed', array ('id' => $ MCLIIID, // your mailchip list id 'batch' => $ batch, 'update_existing' => true)); If ($ retval === false) {resonant "mailcip API returned"; } Echo: 'Added:' $ ['add_count'] "
"; Resonance 'updated:' $ retal ['update_count'] "
"; Echo 'Errors:' $ Retal ['error_count'] "
"; }  

hibernate - Spring Data JPA map the result to Non-Entity POJO -

मेरे पास एक देशी क्वेरी के साथ स्प्रिंग डेटा संग्रह पद्धति है

  @Query (value = "जी का चयन करें *, ग्राम * से समूह जी वाम group_members शामिल हों ग्राम पर g.group_id = gm.group_id और gm.user_id =:।। userId कहां g.group_id =: ग्रुप", nativeQuery = true) GroupDetails getGroupDetails (@param ( "यूज़रआईडी") पूर्णांक उपयोगकर्ता आईडी, परम ("समूह आईडी") पूर्णांक समूह आईडी);  

और मैं नॉन-यूनिट POJO GroupDetails के लिए परिणाम मैप करना चाहता हूं।

क्या यह संभव है और यदि ऐसा है, तो क्या आप एक उदाहरण प्रदान करें?

orid के जवाब के रूप में मान लिया जाये कि GroupDetails आप जेपीए 2.1 की कोशिश की है?

  @SqlResultSetMapping (नाम = "groupDetailsMapping", वर्ग = {@ConstructorResult (targetClass = GroupDetails.class, कॉलम = {@ColumnResult (नाम = "GROUP_ID"), @ColumnResult (नाम = "USER_ID")} )}) @NamedNativeQuery (नाम = "getGroupDetails", क्वेरी = "जी का चयन करें *, ग्राम * से समूह जी वाम group_members शामिल हों ग्राम पर g.group_id = gm.group_id और gm.user_id =:।। userId कहां g.group_id = : ग्रुप ", resultSetMapping =" groupDetailsMapping ")  

और उपयोग रिपोजिटरी इंटरफ़ेस में निम्नलिखित:

  GroupDetails getGroupDetails (@param (" उपयोगकर्ता id ") पूर्णांक userId , परम ("समूह आईडी") पूर्णांक ग्रो upId);  

स्प्रिंग डाटा जेपीए के अनुसार, वसंत पहले नामित क्वेरी अपने विधि नाम से मेल खाते की तलाश करेगा - का उपयोग करके ऐसा @NamedNativeQuery , @SqlResultSetMapping और @ कॉन्स्ट्रस्ट्रर रिजल्ट आपको उस व्यवहार को प्राप्त करने में सक्षम होना चाहिए

php - why it output: the query is empty -

  mysql_select_db ($ डेटाबेस) या मर ("डेटाबेस का चयन करने में असमर्थ"); यदि (isset ($ _GET ['projectID'])) {$ query = "चयन करें taskID, नाम, start date, कार्य से कार्य समाप्त WHERE projectID =" $ _GET ['प्रोजेक्टआईडी'] "ऑर्डर ऑफ़ टास्कआईडी एएससी"; } $ Result = mysql_query ($ query) या die ("क्वेरी निष्पादित करने में असमर्थ:"। Mysql_error ()); गूंज "& lt;; DOCTYPE html & gt; & lt; html & gt;"; जबकि ($ पंक्ति = mysql_fetch_array ($ परिणाम, MYSQL_ASSOC)) {गूंजती "& lt; tr & gt;"; गूंज "& lt; td & gt;"; गूंज "& lt; a href = 'q7.php? ProjectID ="। $ _GET ['प्रोजेक्टआईडी'] 'और टास्कआईडी =' $ पंक्ति ['टास्कआईडी'] " '& Gt;"; गूंज "& lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['नाम']। "& Lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['स्टार्टडेट']। "& Lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['समाप्ति']। "& Lt; / td & gt;"; गूंज "& lt; / tr & gt;"; }  

मैं प्रोजेक्ट आईडी की जानकारी का उत्पादन करने की कोशिश कर रहा हूं, जो कि किसी अन्य php से मिलती है। लेकिन आउटपुट है: क्वेरी खाली है। कोड में क्या गलत है? मैंने उन कोडों को छोड़ दिया है जो इससे कोई फर्क नहीं पड़ता कृपया मुझे कुछ सलाह दें।

परियोजना आईडी ठीक से पारित नहीं किया गया है। और निम्नलिखित कोड में गुजर रहा है क्या आप कृपया बग को समझने में मेरी मदद कर सकते हैं?

  गूंज "& lt; form method = 'get' action = 'q6.php' & gt;"; "परियोजनाओं और नामों को प्रतिध्वनित करें:"; गूंज "& lt; चुनें & gt;"; जबकि ($ पंक्ति = mysql_fetch_array ($ परिणाम, MYSQL_ASSOC)) {गूंजता "& lt; विकल्प मान = '"। $ पंक्ति [' projectID ']।' 'चौड़ाई =' 150 '& gt; "; प्रति पंक्ति गूंज ['projectID']। ":"। $ पंक्ति ['नाम']; गूंज "& lt; / option & gt;"; } गूंजती "& lt; / select & gt;"; गूंज "& lt; input type = 'submit' name = 'submit' मान = 'जमा करें' & gt;"; गूंज "& lt; / form & gt;";  

क्वेरी स्ट्रिंग सेट करने के बाद अपनी क्वेरी निष्पादित करने की कोशिश करें:

<पूर्व> गूंज "& lt;; DOCTYPE html & gt; & lt; html & gt;"; अगर (isset ($ _GET ['projectID'])) {mysql_select_db ($ डेटाबेस) या मर ("डेटाबेस का चयन करने में असमर्थ"); $ Query = "चुनें taskID, नाम, start date, कार्य से endDate WHERE projectID ="। $ _GET ['प्रोजेक्टआईडी'] "ऑर्डर ऑफ़ टास्कआईडी एएससी"; $ परिणाम = mysql_query ($ क्वेरी) या मर ("क्वेरी निष्पादित करने में असमर्थ:"। Mysql_error ()); जबकि ($ पंक्ति = mysql_fetch_array ($ परिणाम, MYSQL_ASSOC)) {गूंजती "& lt; tr & gt;"; गूंज "& lt; td & gt;"; गूंज "& lt; a href = 'q7.php? ProjectID ="। $ _GET ['प्रोजेक्टआईडी'] 'और टास्कआईडी =' $ पंक्ति ['टास्कआईडी'] " '& Gt;"; गूंज "& lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['नाम']। "& Lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['स्टार्टडेट']। "& Lt; / td & gt;"; गूंज "& lt; td & gt;"। $ पंक्ति ['समाप्ति']। "& Lt; / td & gt;"; गूंज "& lt; / tr & gt;"; }} और {गूंज '$ _GET [\' projectID \ '] सेट नहीं है!'; गूंज '$ _GET ='; var_dump ($ _ जीईटी); }

इसलिए जब आप अपना फॉर्म बनाते हैं तो आपको अपने चयन के लिए एक नाम सेट करना चाहिए:

  गूंज & lt; चयन करें नाम = "प्रोजेक्टआईडी" & gt; ;  

java - spring-amqp will not insert message using AmqpTemplate.convertAndSend() -

Here is a small spring program that is expected to place a message in the rabbit Qi:

 < Code> Public class main {public static zero main (string [] args throws IOException {Annotation Config Applications Contact Reference = New Animation ConfiP ApplicationContacts (QE Configuration.class); AmqpTemplate Template = context.getBean (AmqpTemplate.class); Template.convertAndSend ("asdflk ..."); Context.destroy (); }}  

as follows:

  @configure public class Qi configuration {@Bean Public connectionFinal Connection Fighter (New) Caching Connection Factory ("192.168 1.39 "); } @ Bean Public RabbitTemplate rabbitTemplate () {New Rabbit Template (connectionFactory ()); }}  

When I check the contents of the queue on the server, nothing gets involved. I also tried to set the name of the exchange or the name of the queue on the place of the rabbit, but still does not show anything on the server

The log of the application does not show any errors, but it logs [Main] DEBUG osamqp.rabbit.core.RabbitTemplate - Callback execution on rabbit MQ channel: Cached Rabbit Channel: AMQChannel (amqp: // guest @ 192.168.1.3 9: 5672 /, 1) 17: 28: 02.441 [Main] Debug OSMMPP.BBT.core Trillion Template - Publishing Message on Exchange [], RoutingKey = []

Any ideas what is wrong?

I had to queue as a parameter in the call to convert: AndSend (): < / P>

  template.convertAndSend ("hello2", "asdflk ...");  

Still wondering if Spring-AMPP does not throw exceptions. Nobody knows that when no queue is given, where are the messages delivered?

Prompt for user input using python asyncio.create_server instance -

I am learning about Python 3 asyncio library, and I have participated in a small problem sent by the client Instead of email echo, I'm trying to optimize the ecosver instance from Python Docs to prompt for user input.

I thought it would be as easy to add a call to the input , But surely the input () will be blocked So that unless the user input causes problems.

Ideally I would like to continue to get data from the customer, even when nothing happens to "say" to the server is somewhat like a chat client where each connection is to chat with the server I want to be able to switch every individual connection and send the necessary input from stdin. Almost like a P2P chat client

consider the following modified EchoServer code:.

Class EchoServerClientProtocol asyncio Import (asyncio.Protocol): def connection_made (auto, transport): peername = Transport.get_extra_info ('peername') Print ('Connection to'). Format (name name)) self.transport = transport def data_received (self, data): message = data.decode () print ('Received data: {! R}'. Format (message)) Answer = Input () Print ('Send: {! R}'. Format (Answer) self.transport.write (reply.encode ()) # Print (Client Clock Socket ') #self.transport.close () loop = asyncio.get_event_loop ( ) # Each customer relationship will create a new protocol example Coro = loop.create_server (EchoServerClientProtocol, '127.0.0.1', 8888) server = loop.run_until_complete (coro) # until pressed CTRL + c print requests Go Defense is (are served on ''). Format (server.sockets [0] .getsockname ()) Try: loop.run_forever () except for KeyboardInterrupt: pass # server server.close off () loop.run_until_complete (server.wait_closed ()) loop.close () < / Code>

I will go to stdin on the input form on the server side and specify which connection to send the connection to the connected client still?

A callback to run when you have data available on sys.stdin Schedule, and then use to pass stdin data from your data_received method:

  import sys import asyncio def got_stdin_data (cue): asyncio.async (Q.put (sys.stdin.readline ()) class EchoServerClientProtocol (asyncio.Protocol): def connection_made (self, transport): peername = transport (., 'By name') '(' contact name ') format . (Format) (name)) self.transport = transport def data_failed (self, data): message = data.decode () print ('received data: {! R}'. Format (message)) fut = asyncio.async ( Q.get ()) fut.add_done_callback (self.write_reply) def write_reply (self, fut): responses = fut.result () print ('send: {! R}'. Format (answer)) self.transport.write (Reply.encode ()) # print ('close client socket') #self.transport.close () q = asyncio.Queue () loop = asyncio.get_event_loop () loop.add_reader (sys.stdin, got_stdin_data, cue ) # Each customer relationship is a new protocol example Coro = loop.create_server (EchoServerClientProtocol, '127.0.0.1', 8888) all R = loop.run_until_complete (will create code) #Until pressed CTRL + c, requests are pressed ('Serving' {} '. Format (server.sockets [0] .getsockname ())) Try: In addition to the keyboard interrupt: loop.run_forever (): close the # server server .coule () loop.run_until_complete (server.wait_closed ()) loop.close ()  

The only difficult thing is how we do queueput / que.get methods; Both are corline, which can not be used in the callback or protocol in the example methods by yielding yield . Instead, we schedule them with the event loop using asyncio.async , and then add_done_callback get () method call.

c# - Datatype.Date how to set minimum date to Today? -

itemprop = "text">

I created a datepicker using MVC5 DataType.Date:

  [data type (Data Type Date)] Public Date Time Arrival Date {Received; Set; }  

Can I set at least available dates for today and disable all past dates?

Alternatively, is there an option to disable a custom range of dates?

I have tried to create a custom DateRangeValidator using that, but with that I get the following error:

Here's my date range validator:

  Public Date Time First Date = Date Time Today.Date; // Get Public Datetime Secondend {Receive; Set; } Protected Override ValidationResult if (DATETIME date, ValidationContext validationContext) {// your validation logic (if date> = DbFunctions.TruncateTime (FirstDate)) {return ValidationResult.Success; } And {new verification return ("date is not valid."); }}  

javascript - Images placed with .append() / .load() not taking on the styles they should be -

There are some types of "display containers" of my website, in which the content is used by .load () , which is selected based on the item. These display containers can be a few different states, which can be based on your viewing on mobile devices, such as some containers containing words spacing in all the containers, giving images in the breathing room or correcting the contents. Set to stop.

Now, if I include images in these containers from the beginning - it is that they are part of the initial domus - everything looks okay with the word-spacing If it is a state in which the containers are called, or if you are on mobile then the material will be appropriate.

The problem is, when the content is added to these containers, whether it is to carry .load () from a different document, where it is stored Is going, or .append () , it is not taking on these properties.

I have made a bela shown. Unfortunately, I can not show the .load () function due to being able to use it only on the same domain () pages, but you can still see what I'm talking about I am .append () towards things

In short;

Images in the DOM initially work added to the DOM / Loaded images When the mix (some elements are initialized, some elements are added) This is also true for images placed in their different ways.

If you examine the source of the initial / loaded mix All the elements look similar, first there are 2 images which keep proper spacing, while the rest do not have it.

< Div class = "post-text" itemprop = "text">

If you add some space between images, then when adding them, will treat images like "words" and apply the space.