Search Results

Search found 23568 results on 943 pages for 'select'.

Page 532/943 | < Previous Page | 528 529 530 531 532 533 534 535 536 537 538 539  | Next Page >

• Php + MySQL banner rotator by order

  - by ilnur777

  I have table with advertisement in MySQL. I would like to rotate banners by order (NOT RANDOM). What function or mechanism I need to SELECT advertisement from MySQL table to show it in order, like 1, then 2, then 3 ... then again 1,2,3... ?

  Read the article

• HQL query to join 2 tables with the same key

  - by kawtousse

  Hi everyone Iam trying to this in HQL: select A.a A.a1, B.b,B.b1 from A,B where A.x=B.x; It is simple to realize the join with sql but when returninig in HQL I find a problem. would you please give me the HQL syntax for the join Thanks for help.

  Read the article

• Modifying MySQL Where Statement Based on Array

  - by Ryan

  Using an array like this: $data = array ( 'host' => 1, 'country' => 'fr', ) I would like to create a MySQL query that uses the values of the array to form its WHERE clause like: SELECT * FROM table WHERE host = 1 and country = 'fr' How can I generate this query string to use with MySQL?

  Read the article

• How to create a temporary table in Oracle

  - by GigaPr

  Hi I would like to create a temporary table in a Oracle database something like Declare table @table (int id) In SQL server And than populate it with a select statement Is it possible? Thanks

  Read the article

• NHibernate (or other worth recommendation ORM), real life example?

  - by migajek

  I'd like to learn database applications in C# and I'm about to select some framework. I heard many recommendations of NHibernate, however I haven't decided yet. Anyway, I'd like to know if there's any real-life example (with sources) of NHibernate in C#, to learn best practices etc.? I know all of them are probably covered in the docs, but working example helps a lot understanding the proper development pattern.

  Read the article

• mysql query if else statemnet?

  - by user253530

  I have this sql query: SELECT S.SEARCH, S.STATUS, C.TITLE AS CategoryName, E.SEARCH_ENGINES AS Engine, S.RESULTS, S.DATE, S.TOTAL_RESULTS AS Total, S.ID FROM PLD_SEARCHES AS S Join PLD_CATEGORY AS C ON C.ID = S.CATEGORY_ID Join PLD_SEARCH_ENGINES AS E ON S.SEARCH_ENGINES_ID = E.ID ORDER BY S.DATE ASC I want to identify if S.STATUS is either 1 or 0 and according to those values to return COMPLETE or PENDING in the query results

  Read the article

• Where am I going wrong with the count in Hql

  - by Bipul

  So I only want the count of the results not the results themselves therefore I am using count in hql. So, below is the query (int) Session.CreateQuery("select count(*) from TableName where Lhs=Rhs").UniqueResult(); But it is giving me the error Specified cast is not valid.. So, can any body tell me how to cast the count to int. Any help is very much appreciated.

  Read the article

• problem while place the radio buttons inside the liview in android?

  - by Niladri Prasad Padhy

  Dear Everyone, I have a listview with radio button. when i click any option and scroll that list view the previous select will cleared.How to do this. The actual problem is when scroll the view on every scorll the view is refreshed, that's why every time the view is refreshed. How to do this I can't get any solution, Plz. Help. Thanks & Regards Niladri Padhy

  Read the article

• How to deploy to Tomcat from NetBeans?

  - by deamon

  I've added Tomcat in the "Tools Servers" menu and as you can see it appears in the list of servers: But when I try to run my project, I cannot select Tomcat! The drop-down with servers is empty. I tried it with NetBeans 6.8 and 6.9 Beta. Any idea?

  Read the article

• How do I confirm a given page was displayed after calling ISelenium.open()?

  - by Randy Eppinger

  Using .NET (though I don't think it is relevant), I have opened a page, but I want to confirm that the page was actually opened. I have a few ideas like using .Select(), but I want to do what is considered the best practice by others in the Selenium community.

  Read the article

• How to find out if a Java ResultSet obtained is empty?

  - by Bruce

  Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from table WHERE is_query_processed = 0;"); How can I find out if rs is empty?

  Read the article

• type casting in mysql

  - by muralikalpana

  i have passportno(varchar) in database. i am entering values like this 001,002,003. and i want to display like sorting order. now i wrote query like this "select * from passport_registration where status=1 ORDER BY passportno" then displaying output like this......077,088,099,100,1000,1001,1009,101,1010 i want to diplay sort order. how to do?

  Read the article

• Scanning a mysql table from the bottom

  - by ming yeow

  When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top?

  Read the article

• Xcode: iPhone screenshots no longer work

  - by Chris Newman

  I can't be sure when this stopped working because I haven't used it for a while, but it was possibly since I upgraded to the 3.2 SDK. In Organizer, when I select the "Screenshots" tab and press "Capture", nothing happens. I've tried this with three different devices and I've restarted my Mac. What's happened, and how can I fix it?

  Read the article

• What VS 2010 Template to Chose?

  - by Dr Hydralisk

  I am just getting started with C++ and wanted to know does it really matter what template you chose in Visual Studio 2010 (for creating executables)? Like if I was creating a console application there is CLR Console Application, Win32 Console Application, and Win32 Project (description says it can be an application or a dll), what would I chose (or could i select Empty Project)?

  Read the article

• Django: GROUP BY two values

  - by AP257

  I would basically like to do the same as this question, but grouping by combinations of two values, rather than just one: SELECT player_type, team, COUNT(*) FROM players GROUP BY player_type, team; Does anyone know whether, and how, this is possible in Django? I'm using 1.2.

  Read the article

• Determining an Oracle SQL MERGE statement result

  - by petejamd

  Follow up to this question This (similar version from old link) works in SQL Server 2008, however, Oracle is giving me trouble: MERGE INTO wdm_test USING ( select '10000000000000000000000000000000' Guid from DUAL ) val ON ( wdm_test.Guid = val.Guid ) WHEN MATCHED THEN UPDATE SET test_column = null WHEN NOT MATCHED THEN INSERT (Guid, test_column) VALUES ('10000000000000000000000000000000', null) OUTPUT $action; SQL Error: ORA-00933: SQL command not properly ended Does Oracle not support OUTPUT $action;? If not, is there an alternative?

  Read the article

• pgSQL query error

  - by running4surival

  i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?

  Read the article

• Difference between dates when grouping in SQL

  - by CeejeeB

  I have a table of purchases containing a user_id and a date_of_purchase. I need to be able to select all the users who have made 2 purchases within 12 months of each other. The dates can be any point in time as long as they are less than 12 months apart. e.g. user_id date_of_purchase 123 01/Jan/2010 124 01/Aug/2010 123 01/Feb/2010 124 05/Aug/2008 In this example i want user_id 123

  Read the article

• Any way to make this PostgreSQL count query any faster?

  - by Ben Dauphinee

  I'm running a case-insensitive search on a table with 7.2 million rows, and I was wondering if there was any way to make this query any faster? Currently, it takes approx 11.6 seconds to execute, with just one search parameter, and I'm worried that as soon as I add more than one, this query will become massively slow. SELECT count(*) FROM "exif_parse" WHERE (description ~* 'canon')

  Read the article

• sql - getting the id from a row based on a group by

  - by user85116

  Table A tableAID tableBID grade Table B tableBID name description Table A links to Table b from the tableBID found in both tables. If I want to find the row in Table A, which has the highest grade, for each row in Table B, I would write my query like this: select max(grade) from TableA group by tableBID However, I don't just want the grade, I want the grade plus id of that row.

  Read the article

• IEnumerable<string[]> => unique string's

  - by Maxim

  Hello! I have IEnumerable - that i recieved(converted) from dattabase. i need to select from this collection only unique strings. i suppose that i need to use linq group by string... please help.

  Read the article

• Ruby on Rails collection_select display attribute

  - by New2rails

  I'm new to Rails and am working with the collection_select method. I have two fields I'd like to display in my select box: first_name and last_name So far, I can only display one or the other, not both. Here's the code I'm working with: collection_select(:hour,:shopper_id,@shoppers,:id,"last_name") Thank you.

  Read the article

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• PHP Code Problem...

  - by aamir Fayyaz

  function check_login($array_val) { $strQury = "Select * from tblsignup where usr_email ='".$array_val[0]."' and usr_password = '".$array_val[1]."'" ; $result = mysql_query($strQury); $row_user = mysql_fetch_array($result); if(mysql_num_rows($result)>0) { $msg = "true"; } else { $msg = "false"; } return $msg ; } The return value is Object id #1true???? what is object id#1?

  Read the article

< Previous Page | 528 529 530 531 532 533 534 535 536 537 538 539  | Next Page >