Search Results

Search found 49435 results on 1978 pages for 'query string'.

Page 456/1978 | < Previous Page | 452 453 454 455 456 457 458 459 460 461 462 463  | Next Page >

• Possible to assign a data type to an anonymous type's members in a linq query?

  - by Abe Miessler

  If I have a linq query that creates the anonymous type below: select new { lf.id, lf.name, lf.desc, plf.childId }; Is it possible to assign a specific type to one of the members? Specifically I would like to make lf.id a null-able int rather than an int...

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery?

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery?

  Read the article

• How to execute query with IN clause in spring?

  - by GK

  I have following code : try { MapSqlParameterSource parameters = new MapSqlParameterSource(); parameters.addValue("ids", year); return this.template.getJdbcOperations().query( "SELECT * FROM INCOME WHERE PROVNUM=? AND FISCALDATE IN ( :ids )", this.rowMapper, parameters); }catch (EmptyResultDataAccessException ex) { return null; } But i am not able to send the value for PROVNUM. how to do that? need help, thanks.

  Read the article

• Mysql query to get distict hotel id with minimum price and star?

  - by user1325929

  Current table hotel_id | price | star 1100 | 1999 | 3 1100 | 1565 | 3 1100 | 2000 | 3 1101 | 2010 | 4 1101 | 2050 | 4 1102 | 5599 | 5 1102 | 6599 | 5 Required result: distinct hotels with minimum price and it's star hotel_id | price | star 1100 | 1565 | 3 1101 | 2010 | 4 1102 | 5599 | 5 I wrote query as SELECT DISTINCT hotel_id, min(price),star FROM MyTable. It is giving only 1 row instead of 3

  Read the article

• Can I get the full query that a PreparedStatement is about to execute?

  - by ufk

  I'm working with PreparedStatement with MySQL server. example: String myQuery = "select id from user where name = ?"; PreparedStatement stmt = sqlConnection.prepareStatement(myQuery); stmt.setString(1, "test"); stmt.executeQUery(); ResultSet rs = stmt.getResultSet(); How can I receive the full SQL query that is about to be executed on the MySQL server? thanks!

  Read the article

• How do I modify the hundards of records based on my query result?

  - by Nano HE

  Hi, I inserted some error record to my table, I can query via the sql below and found hundards of record marked with half. SELECT * FROM `marathon` WHERE gender = 'male' && distance = 'half'; How to write a SQL then I can modify the result rows distance from 'half' to 'full'. Thank you.

  Read the article

• How do I compare a DateTime column to now() in a query filter in SqlAlchemy?

  - by Ben

  I have a table with an 'expires' datetime column. I want to find all the items that have an 'expires' date earlier than now. I've tried session.query(Item).filter(Item.expires < now()) but it doesn't return anything regardless of the dates in the table. I'm using PostgreSQL 8.4. How do I do this comparison?

  Read the article

• How to skip an empty LIKE operator in a multiple LIKE query?

  - by alex

  I notice my query doesn't behave correctly if one of the like variables is empty: SELECT name FROM employee WHERE name LIKE '%a%' AND color LIKE '%A%' AND city LIKE '%b%' AND country LIKE '%B%' AND sport LIKE '%c%' AND hobby LIKE '%C%' Now when a and A are not empty it works but when a, A and c are not empty the c part is not excuted so it seems? How can I fix this?

  Read the article

• MYSQL Insert: How to save Query in the database only one time - duplicate key doesn't work!

  - by elmaso

  hello, I want to save a query only one time in the database, this is my code: $querystat = mysql_real_escape_string($_GET['q']); $datetime = time(); if( ($querystat != $_SESSION['prev_search']) OR ( ($datetime - $_SESSION['datetime']) > 60) ) { $insertquery = "INSERT INTO `query` ( `searchquery` , `datetime`) VALUES ( '$querystat' , '$datetime') ON DUPLICATE KEY UPDATE searchquery='$querystat';"; mysql_query($insertquery, $db); } maybe something with == 0 ?

  Read the article

• What SQL query should I perform to get the result set expected?

  - by texai

  What SQL query should I perform to get the result set expected, giving the first element of the chain (2) as input data, or any of them ? table name: changes +----+---------------+---------------+ | id | new_record_id | old_record_id | +----+---------------+---------------+ | 1| 4| 2| | -- non relevant data -- | | 6| 7| 4| | -- non relevant data -- | | 11| 13| 7| | 12| 14| 13| | -- non relevant data -- | | 31| 20| 14| +----+---------------+---------------+ Result set expected: +--+ | 2| | 4| | 7| |13| |14| |20| +--+ I know I should consider change my data model, but: What if I couldn't? Thank you in advance!

  Read the article

• Can "Distinct" key Word be used twice in a single Select Query?

  - by OM The Eternity

  Can "Distinct" key Word be used twice in a single Select Query? like wise: select DISTINCT(trackid), DISTINCT(table_name) from jos_audittrail where live = 0 AND operation = UPDATE Thanks

  Read the article

• Whats query can be used to get the details of Indexes of any table?

  - by Parth

  Whats query can be used to get the details of Indexes of any table? I need this to find out primarykey/autoincremented value of any table.. Please help/Guide me...

  Read the article

• Is existed web markup languages with possibility insert sql query?

  - by MercurieVV

  Actually what I want - simple DB with simple User Interface. Like MS Access, but for web and it can be without Dragn n Drop, but described with markup language. For example if I want to create list report, then i need to write something like: <table query="SELECT * from mytable"></table> It needed for simple data applications. In that kind application no programming logic required. Just working with DB. Changing DB data and showing it.

  Read the article

• How to query by recent date and value in SQL?

  - by wsb3383

  I have a table with three columns: patient_id, obs_date, and weight_val. patient_id stores patient identification #, weight_val stores a weight value, and obs_date stores the date when the weight reading was taken. So, a patient can have many different weight readings at different dates. How do you write a query for: select all patients whose last weight reading is 120?

  Read the article

• How to check results of LINQ to SQL query?

  - by rem

  In a WPF app I'd like to check if a return of a LINQ to SQL query contains some records, but my approach doesn't work: TdbDataContext context = new TdbDataContext(); var sh = from p in context.Items where p.Selected == true select p; if (sh == null) { MessageBox.Show("There are no Selected Items"); } Where am I wrong?

  Read the article

• how to improve performance of update query in sql?

  - by angel ansari

  I want to improve the performance of this update query because when it take lots of time to execute: Qry = "update tab1 set cDate=GetDate() where right('000000000000'+in_num,12)='" & InvNo.PadLeft(12, "0") & "' and (Total-Amount)<>Balance <>Balance and cDate is null"

  Read the article

• what does positional and named parameter in a query mean?

  - by ajsie

  here we got a positional parameter: SELECT u FROM ForumUser u WHERE u.id = ?1 and here a named parameter: SELECT u FROM ForumUser u WHERE u.username = :name this is DQL (doctrine query language) but i think the concept is the same. could someone please explain what these mean and do?

  Read the article

• how to run a query from the VBA Editor window in ACCESS?

  - by every_answer_gets_a_point

  i would like to do something like this: DoCmd.OpenQuery "select * from some_table;" how would i do this? please keep in mind i don't want create a new query, save it, and run it, i just want to type the select statement in the vba code and run it.

  Read the article

• Drupal 6: set pager_query() to display last page of query?

  - by Michael D

  Hi all, Does anyone here know how to set up a pager_query() to automatically go to the last page of the query when the page is displayed? I'm using theme_pager() to format the page.

  Read the article

• Query to get the names of all tables in SQL Server 2008 Database.

  - by John H.

  Is it possible to write a query that will give me the names of all the tables in an SQL Server database? I'm working on some 'after the fact' documentation on a system I didn't create and am looking for a shortcut to get a listing of the tables in a database.

  Read the article

• methods of joining 2 tables without using JOIN or SELECT more than one distinct table in the query

  - by GB_J

  Is there a way of joining results from 2 tables without using JOIN or SELECT from more than one table? The reason being the database im working with requires queries that only contain SELECT, FROM, and WHERE clauses containing only one distinct table. I do, however, need information from other tables for the project i'm working on. More info: the querier returns the query results in a .csv format, is there something we can manipulate there?

  Read the article

• Colored Data in 1 String in a gridview in asp.net?

  - by Kovu

  Hi, I have a resultgridview from a search query. In this gridview I have a name e.g. "aaaaaaaaaabbbbbbbbbbbbcccccccc" If the user serach "bbbbbbbbbbbbbb" I will select the "bbbbbbbbbbbbbb" in the string in the gridview in red and bold. how to do it?

  Read the article

• MySQL VIEW vs. embedded query, which one is faster?

  - by Vincenzo

  I'm going to optimize a MySQL embedded query with a view, but I'm not sure whether it will give an effect: SELECT id FROM (SELECT * FROM t); I want to convert it to: CREATE VIEW v AS SELECT * FROM t; SELECT id FROM v; I've heard about "indexed views" in SQL Server, but I'm not sure about MySQL. Any help would be appreciated. Thanks!

  Read the article

• Can I use TSQL to operate on normal os files? Such as create a .bat file and write some query result

  - by Yousui

  Hi guys, Can I use TSQL to operate on normal operating system files? Such as create a .bat file at c:\test and write some query result into that batch file? Thanks.

  Read the article

• I am searching for a string like Cityname, State in mysql table where state name is 2 letter char.

  - by subson

  I am searching for a string like Cityname, State (e.g.Moline,IL) in mysql table. How can i make the query using regexp in mysql.

  Read the article

< Previous Page | 452 453 454 455 456 457 458 459 460 461 462 463  | Next Page >