Search Results

Search found 27396 results on 1096 pages for 'mysql query'.

Page 383/1096 | < Previous Page | 379 380 381 382 383 384 385 386 387 388 389 390  | Next Page >

• T-SQL query and group by reporting help

  - by Dayton Brown

  So I have some data that looks like this. `USERID1 USERID2` 1 10 2 20 2 30 3 40 3 50 1 10 2 20 2 30 3 50 I want a query that produces the following `USERID1 COUNT` 2 2 3 2 It's a group by query that shows me the count of unique USERID2 for each USERID1 that has more than 1 USERID2 associated with it. God I hope you aren't as confused as I am by that last statement.

  Read the article

• SQL: Update a column with multiple values with single query

  - by Sandeep Jindal

  Hi, I have an update query like following: update table TABLE1 set COL1 = 'X' where COL2 = 'Y' ---1 Support the values 'X' and 'Y' are fetched from database now TABLE2. E.g. select COL1, COL2 from TABLE2. ----2 I want to update table TABLE1 with values from TABLE2. Just to make it more clear, assume that TABLE2 has following values: Can you please help me in doing this in a single query!

  Read the article

• SQL column length query

  - by Mike

  i've been using the following query: select LEN(columnname) as columnmame from dbo.amu_datastaging This works, but is there a way to only return the greatest value instead of all the values? So if i return 1million records and the longest length is 400, the query would just return the value of 400?

  Read the article

• can't query from dbpedia with a sparql

  - by austin powers

  I want to query from dbpedia using their sparql interface (http://dbpedia.org/sparql) I want to get the abstract of http://dbpedia.org/page/Herbie_Mann I know that I have to call abstract ontology http://dbpedia.org/ontology/abstract and my final sparsql query is like following : SELECT ?abstract WHERE { { <http://dbpedia.org/page/Herbie_Mann> <http://dbpedia.org/ontology/abstract> ?abstract} } but yet I'm not able to see anything. please help me as I am beginner in semantic web!

  Read the article

• Get individual query parameters from Uri

  - by Ghostrider

  I have a uri string like: http://example.com/file?a=1&b=2&c=string%20param Is there an existing function that would convert query parameter string into a dictionary same way as ASP.NET Context.Request does it. I'm writing a console app and not a web-service so there is no Context.Request to parse the URL for me. I know that it's pretty easy to crack the query string myself but I'd rather use a FCL function is if exists.

  Read the article

• Oracle join query

  - by Jasim

  There are three tables in my db ITEM_MASTER, PRICE_MASTER, COMP_MASTER ITEM_MASTER STORE_CODE ITEM_CODE ITEM_DESC 011 914004 desccc PRICE_MASTER STORE_CODE ITEM_CODE COMP_CODE 011 914004 01 011 914004 02 011 914004 03 011 914004 04 COMP_MASTER COMP_CODE COMP_DESC STORE_CODE 01 comp1 011 02 comp2 011 03 comp3 011 04 comp4 011 I want to get all these for an ITEM_CODE in single query STORE_CODE ITEM_CODE ITEM_DESC COMP_DESC1 COMP_DESC2 COMP_DESC3 COMP_DESC4 011 914004 desccc comp1 comp2 comp3 comp4 How can i write a oracle SQL query for this??

  Read the article

• have we limitation in submit some query in c# to oracle

  - by rima

  Can I send this query from my C# connection to my oracle connection? "Select Object_name,status from object_name where object_type='function';" or "Select Object_name,status from object_name where object_type='Procedure';" or because as I remember, I have this problem when I write a program to connect to Access with java,those days I try to submit some query to get all table name. regard.

  Read the article

• Run sql script from console and not from query analyzer in SQL server

  - by Spyros

  Hello , i have written an sql script for updating a database that runs in SQL server 2005 and I want to make that changes to the production DB server but I dont want to run the query from the query analyzer , is there a way to run the sql script from console?

  Read the article

• Is there a way in Powershell to query the object Property Page Details

  - by Gary Mitchell

  Is there a way in Powershell to query the object Property Page Details to verify if the Copyright, Product name and File version are not empty. I want to be able to query this info when I'm looking for viruses

  Read the article

• How to Ignore query string in a URL?

  - by jartaud

  Hello I have something like this: if(isset($_POST['btnProm'])){ $idads = mysql_real_escape_string($_POST['idAds']); require_once("adPromFrm.php"); } When a button is pressed, a form will appear.... When i refresh the page, the form doesn't disappear, but when i click a link with a query string (thisPage.php?lang=fr...), the form disappears. I know i m asking the form only if the button is pressed, but how can i ignore the query string.

  Read the article

• url Query and Security

  - by jasmine

  In url query with id I use is_numeric($_GET['id']) for security issues. But in query with for example category name, is urlencode() a right way for security? Thanks in advance.

  Read the article

• MongoDB query against geospatial index with maxDistance fails from node.js client

  - by user1735497

  I want to query against a geospatial index in mongo-db (designed after this tutorial http://www.mongodb.org/display/DOCS/Geospatial+Indexing). So when I execute this from the shell everything works fine: db.sellingpoints.find(( { location : { $near: [48.190120, 16.270895], $maxDistance: 7 / 111.2 } } ); but the same query from my nodejs application (using mongoskin or mongoose), won't return any results until i set the distance-value to a very high number (5690) db.collection('sellingpoints') .find({ location: { $near: [lat,lng], $maxDistance: distance / 111.2} }) .limit(limit) .toArray(callback); Has someone any idea how to fix that?

  Read the article

• Sql query builder c#

  - by pdiddy

  I'm building a windows mobile app. And using SqlCe. I'm looking for a good sql query builder. So instead of writing "SELECT COLUMNS FROM TABLE WHERE etc... Is there a good free library that can build this sort of query?

  Read the article

• need help on wordpress feeds query parameters

  - by goh

  Hi guys, may i know how do i set the number of feeds displayed on a word press blog? for instance, i used http://beautifulreminisciencezz.wordpress.com/?feed=atom&year=2009 But it returns me only ten results. For blogger, I know the query parameter is 'max-results' However,t here's nowhere in wordpress where they mentioned the query parameters for this. Anyone have any idea?

  Read the article

• How to convert this SQL query to Linq to Entity query?

  - by George

  Hi, could you help me please convert this SQL query to Linq to Entity query? Thank you select distinct item, count(item) as count from TableName where ColumnName = @parameter and (ColumnName2 = @parameter2 OR ColumnName3 = @parameter3) group by item order by item asc

  Read the article

• Can I query inside a SQLite Transaction?

  - by CSharperWithJava

  I'm using the SQLite3 database system in the Android library. I need to execute a query during a transaction to see if there is a similar entry already there. If there is, I have to perform some other logic and adjustments before I add a new row. Can I execute a query within a transaction and get the result back immediately?

  Read the article

• can this simple SQL query be optimized?

  - by ibiza

  Hi, I have the following query : SELECT COUNT(*) FROM Address adr INNER JOIN Auditable a on adr.UniqueId = a.UniqueId on a big DB (1.3M adresses, 4M+ auditables) both UniqueId columns are clustered primary keys the query is taking quite long to complete...I feel dumb, but is there any way to optimize it? I want to count all the address entries that have an underlying auditable... thanks!

  Read the article

• Pass a query in URL using jquery

  - by Jean

  Hello, I want to pass a $_GET[''] to a php file, when a button is clicked it must display data from the db. It displays the data without the query. The process.php contains SQL statement to query the db and display values. Thanks Jean

  Read the article

• hql query formation

  - by sarah

  Hi I want to construt a hql query like select PLAN_ID from "GPIL_DB"."ROUTE_PLAN" where ASSIGNED_TO in ('prav','sheet') and END_DATE > todays date I am doing in this way but getting an error in setting parameters s=('a','b'); Query q = getSession().createQuery("select planId from RoutePlan where assignedTo in REG "); if(selUsers != null) { q.setParameter("REG", s); } where i am doing wrong?

  Read the article

• Help with HQL Query (find duplicates)

  - by BRhodes

  I am trying to convert this native sql into an HQL query. Basically it returns all the contacts that are duplicates (by company, firstname, and lastname). The query below works great, but performing a joined subselect seems impossible in HQL is it not?! Select c.* from contact c join ( Select c2.* from contact c2 group by c2.company, c2.firstname, c2.lastname, c2.teamId having count(c2.contactId)1 and teamId=1 ) dupes on c.company=dupes.company and c.teamId=1 and c.firstname=dupes.firstname and c.lastname=dupes.lastname order by c.company, c.firstname, c.lastname

  Read the article

• An article and comments SQL query - efficient

  - by joe khan

  Hi there, What'd be the most effective and efficient sql query to grab an article and the comments? It'd be two tables (articles, comments.) Would it be best to have it in one SQL query or two SQL querys? Speed is the main concern. Thanks in advance

  Read the article

• running query and putting result into a variable ACCESS

  - by every_answer_gets_a_point

  i am running a query from vba editor access: "select max(somerow) from sometable" i want to put the result of this query into a variable. how do i do it?

  Read the article

• sql query to replace a blank cell with any text in access 2007 column

  - by silverkid

  I have an access table which has some cells as blank ( no data ) in a particular column. how i write an sql query to replace a blank cell with any text in access 2007 column any help appreciated. i have already tried the sql query update tableA set colA = 'abc' where ISNULL(colA); It updates 0 rows.

  Read the article

• trying to run a named query

  - by dora

  hi, I’m doing the following: @Entity @SqlResultSetMapping(name="getxxxx", entities=@EntityResult(xxxx.class, fields = { @FieldResult(name="x1", column = "x1"), @FieldResult(name="x2", column = "x2")})) @NamedNativeQuery(name=" getxxxx ", query="select x1, x2 from yyyy", resultSetMapping=" getxxxx ") } )public class xxxx{ . . . public xxxx() { } i get an error: "Table "xxxx" cannot be resolved", the class xxxx is not a table mapped into my source, I’m trying to query the DB and return the results into my class is it possible?

  Read the article

• customizing rowsource query in combobox ACCESS

  - by every_answer_gets_a_point

  i have 4 comboboxes and each of them need to have the same query in the rowsource, except there is a slight variation on each query if rowsource = somequery i need it to be select * from somequery where something like 'something1'; the next one needs to be select * from somequery where something like 'something2'; is there a way to customize the rowsource property in this way?

  Read the article

< Previous Page | 379 380 381 382 383 384 385 386 387 388 389 390  | Next Page >