Search Results

Search found 22756 results on 911 pages for 'power query'.

Page 630/911 | < Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >

• Google app engine: empty property in datastore

  - by Pete

  Dear All, Let say I have a model: class A(db.Model): B = db.StringProperty() C = db.StringProperty() How do I query if I wanted to search all empty property (not None, just empty) in C using python?

  Read the article

• ASP.NET How to save and use persistent information depending on user type login

  - by pee2002

  Hi there! I´m building a website and i need to store somehow some informations that i will use in the whole site depending of the user type logged in. Example: 1) User XPTO logs in 2) Query DataBase to see where he belongs 3) Store those 2 or 3 fields that i will get in Database in a persistent way to use it in the whole site. My question is: Whats the best practices to do this? Best Regards

  Read the article

• Can I cache a ManyToOne hibernate object without it being lazy loaded?

  - by Andrew

  @ManyToOne @JoinColumn(name = "play_template_id", table = "team_play_mapping" ) public Play getPlay() { return play; } public void setPlay( Play play ) { this.play = play; } By default, this is eager loading. Can I get it so that it will read the play object from a cache without making it lazy loading? Am I correct that eager loading will force it to do a join query and hence no caching?

  Read the article

• How can I LIMIT rows updates in MySQL if more than one table is involved?

  - by Taz

  I am trying to run an UPDATE query UPDATE ner.nerdataset, ner.shortabstracts SET ner.nerdataset.ShortAbstract=ner.shortabstracts.ShortAbstract WHERE ner.shortabstracts.Resource=ner.nerdataset.ResourceURI LIMIT 10; As MySQL does not allow the use of LIMIT when more than one table is involved in UPDATE what else can be done to limit this?

  Read the article

• Is JSON array parsable?

  - by Alex

  I have a YQL query that extracts data from a page and returns it to my script as JSON. The JSON is huge, and as such, here's my question: Is JSON array parsable? So that I can iterate over the entire JSON structure?

  Read the article

• How to count how many items for distinct items in mysql?

  - by Vincent Duprez

  Imagine a have a table with a column named status: status ------ A A A B C C D D D How can I count how many rows have A, how many rows have B etc? this kind of output: A |B |C |D |E ------------------ 3 |1 |2 |3 |0 As for E = O , this will always be A,B,C,D and E Output should be one row (thus 1 query). When doing a distinct count (most returning answer on my searches, it does return how many different elements there are, 4 in this case...)

  Read the article

• Prevent access to files outside a certain directory in PHP

  - by James L

  I've found out the hard way that my website can be hacked by passing a query string parameter that has many ../s to access files outside of the website directory, and then screw with the website. Is there a way, perhaps through the php.ini, to not allow file includes outside of a certain root directory?

  Read the article

• Most suitable collection for multithreading requests?

  - by Raj Aththanayake

  I have ~10,000 records would like to keep in a collection in memory and execute LINQ queries against it. This collection should be available for all the users in the application domain and can access concurrently. I’m looking for a .NET collection that supports multithreading can query asynchronously and efficiently without any threading issues. Any suggestions on deciding a collection for this?

  Read the article

• Java JTextArea Bold

  - by ikurtz

  This is an exploratory query. I am wondering if the following is possible with JTextArea? Can I alter the text to bold (append text) and then back to normal and will it only display the bold text in bold and the rest as normal? Also can the contents of JTextArea be saved as a RTF document? Thank you.

  Read the article

• Get row where date column = today - SQL server noob

  - by Chin

  In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanks

  Read the article

• Online Database

  - by Narancha

  Hello! I want to write an application that reads blogpost from the internet and then present in my own way. The blogposts are stored in databases, so I figured that the only thing I had to do was to query an online database for the posts that I want to show.. But I can´t find a way to opoen a connecion to an online database... anyone out there with a solution to my problem? //Narancha

  Read the article

• Stateless NHibernate for querying

  - by JontyMC

  We have a database that is updated via a background process. We are using NHibernate to query the data for display on the web UI, so we don't need change tracking or lazy-loading. If we mark all the mappings as mutable="false", is this the same as using a stateless session?

  Read the article

• Python what's the data structure for triple data

  - by Paul

  I've got a set of data that has three attributes, say A, B, and C, where A is kind of the index (i.e., A is used to look up the other two attributes.) What would be the best data structure for such data? I used two dictionaries, with A as the index of each. However, there's key errors when the query to the data doesn't match any instance of A.

  Read the article

• Quering computed fields in GORM

  - by Tihom

  I am trying to query the following HQL using GORM: MailMessage.executeQuery("toId, count(toId) from (SELECT toId, threadId FROM MailMessage as m WHERE receiveStatus = '$u' GROUP BY threadId, toId) as x group by x.toId") The problem is that count(toId) is a computed field doesn't exist in MailMessage and that I am using a subquery. I get the following error: java.lang.IllegalArgumentException: node to traverse cannot be null! Ideally, I would like to use a generic executeQuery which will return data of anytype. Is there such a thing?

  Read the article

• Why would restarting MySQL make my site faster?

  - by beagleguy

  hey all, my site started dragging lately, the queries taking exceptionally longer than I would expect with properly tuned indexes. I just restarted the mysql server after 31 days uptime and every query is now substantially faster and the whole site renders 3-4 times faster. Would there be anything that jumps out at you as to why this may have been? Improper settings on my.cnf perhaps? Any ideas as to what I can start looking at to try and pinpoint why? thanks

  Read the article

• Ways to Actively Update Java from MySQL

  - by 8EM

  What is the best way to update a Java or GWT program from MySQL. For example, a MySQL database which holds Weather information... updating whenever the weather changes a degree. How would I update a Java / GWT field with each update. Would I use a thread to query every few seconds??

  Read the article

• Passing a complex object to a page while navigating in a WP7 Silverlight application

  - by Andreas Grech

  I have been using the NavigationService's Navigate method to navigate to other pages in my WP7 Silverlight app: NavigationService.Navigate(new Uri("/Somepage.xaml?val=dreas", UriKind.Relative)); From Somepage.xaml, I then retrieve the query string parameters as follows: string val; NavigationContext.QueryString.TryGetValue("val", out val); I now need a way to pass a complex object using a similar manner. How can I do this without having to serialize the object every time I need to pass it to a new page?

  Read the article

• displaying the map highlighting the provinces and some additional info

  - by Sachindra

  I am using PHP open source and I need the map of a country highlighting all the states in different colors. Once a particular state is hovered over, some info about the state needs to appear. Please suggest me how to do this. Is it possible to do this using some basic stuff ... I mean nothing like what goes beyond my knowledge... Not sure if the tags that i have posted this query in is right...

  Read the article

• SQL: How to order values inside group by

  - by Denis Yaremov

  Consider the following MS SQL Server table: ID | X | Y ------+-------+------- 1 | 1 | 1 2 | 1 | 2 3 | 1 | 3 4 | 2 | 40 5 | 2 | 500 6 | 3 | 1 7 | 3 | 100 8 | 3 | 10 I need to select the ID of the row that has the maximum value of Y grouped by x, i.e: ID | X | Y ------+-------+------- 3 | 1 | 3 5 | 2 | 500 7 | 3 | 100 The query will be nested several times so an optimal performance solution is required... Thank you!

  Read the article

• How do I prevent SQL injection with ColdFusion

  - by Daniel A. White

  How do I prevent SQL injection when it comes to ColdFusion? I'm quite new to the language/framework. Here is my example query. <cfquery name="rsRecord" datasource="DataSource"> SELECT * FROM Table WHERE id = #url.id# </cfquery> I see passing in url.id as a risk.

  Read the article

• how to add a dynamic param

  - by user569846

  the jquery plugin that im using is this http://code.google.com/p/jquery-in-place-editor/ if i have a table like this <table> <thead> <tr> <th>id</th> <th>first name </th> <th>last name </th> </tr> </thead> <tbody> <tr> <td class="id">1</td> <td class="fname">sarmen</td> <td class="lname">mikey</td> </tr> <tr> <td class="id">2</td> <td class="fname">john</td> <td class="lname">angelo</td> </tr> <tr> <td class="id">3</td> <td class="fname">sarmen</td> <td class="lname">grande</td> </tr> </tbody> </table> and my js looked something like this $("td.fname").editInPlace({ url: 'ajax.php', params: '', show_buttons: true }); then lets say i click on the first record to edit it which is fname of sarmen. how can i pass a param that only accociates id 1 ? because if i do a query of lets say "update tbl_users set fname = '$_POST['update_value']' where fname = '$_POST['original_html']'" (note: im just showing an example so no need to clean posts if that was bothering you :) ) if i run this query the fname of sarmen will update in two records rather than one. How can i only update to id of 1 being to update only one record.

  Read the article

• Drupal: set active class on primary links menu depending on path or content type

  - by benmango

  Hi there, I have some styling based on the primary links active class. I would like to set the class of a link in the primary links to active (<a class="active"...>) based on either the content type or the path. I have already done some research on this but haven't yet seen anything that seems to match my query. Would be grateful for any help. Ben

  Read the article

• time calculation within LINQ

  - by d daly

  Hi I want a linq query to return a calculated timespan, i have used the timespan function before, but im not sure how to incorporate it into linq. Basically the linq is returning a datetime field which i want to subtract from the current datetime to get days and hours. Any help appreciated! Thanks

  Read the article

• import data from another table with same id

  - by Luca Romagnoli

  Hi, i have 2 table User (id, name, surname,cod) UserNew (uid, uname, usurname, ucod) The first table has data the second no. I have to copy the data of the User table in the UserNew table. I've tried with a insert query but uid (primary key) value changes. How can i do to mantaince the same values? thanks

  Read the article

• MySQL JOIN with IF conditions.

  - by user333187

  Hi, I want to get some results via query simillar to: SELECT * FROM users LEFT JOIN IF (users.type = '1', 'private','company') AS details ON users.id = details.user_id WHERE users.id = 1 Any ideas?

  Read the article

< Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >