Search Results

Search found 24958 results on 999 pages for 'select region'.

Page 578/999 | < Previous Page | 574 575 576 577 578 579 580 581 582 583 584 585  | Next Page >

• 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

• 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

• background color issue in datagird

  - by martin

  How to select a row(e.g.frist row in datagrid) and set its background color to be e.g. red in C#?

  Read the article

• error with linq join

  - by Luca Romagnoli

  I have this linq query: var segreterie = from s in db.USR_Utenti join h in db.USR_Accounts on new {s.ID, settings.GruppoSegreteria} equals new {h.USR_UtentiReference,h.ID_Gruppo} select s; that has this problem: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'. how can i do to solve it?

  Read the article

• Problem with File uplolad in javascript.

  - by Nikhil

  I have used javascript to upload more than one file. when user clicks on 'add more' javascript appends new object to older div using innerHTML. Now the problem is if I select a file and then click on "add more" then new file button exist but older selected file removes and two blank file buttons display. I want this old file must be selected when user add new file button. If anybody can, Help Plz!!! tnX.

  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

• PVCS 6.0 Checkout with Folder Heirarchy

  - by ybelsare

  Hi , We are using PVCS 6.0 in our current project . I want to checkout the complete project along with the folder heirarchy into my working directory . currently if i select the project and do a checkout , it just dumps all the file into my working folder without any heirarchy . Any idea about how to go about this ? ... any help is appreciated

  Read the article

• How to enumerate returned rows in SQL?

  - by SilentGhost

  I was wondering if it would be possible to enumerate returned rows. Not according to any column content but just yielding a sequential integer index. E.g. select ?, count(*) as usercount from users group by age would return something along the lines: 1 12 2 78 3 4 4 42

  Read the article

• MySQL full text search, why am I getting Incorrect arguments to MATCH

  - by vick

  SELECT * FROM company c INNER JOIN city ci ON ci.city_id = c.city_id INNER JOIN state s ON s.state_id = c.state_id WHERE MATCH ( c.name, ci.name, c.zipcode, s.name ) AGAINST ( 'los angeles' )

  Read the article

• Creating Auto Incrementing column in Google Appengine

  - by demos

  What is the easiest and most efficient way to create an auto-increment counter for every data row in google appengine? basically I want to give every row a unique row_number so that I can overcome the issue of only being able to get the first 1000 results in a select query. I can thus add a counter lies between condition and mine all the entires in the table.

  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

• Help with query in Microsoft Access

  - by Gold

  I have 2 tables: Table A: code | name Table B: barcode | name Table B has full barcode and name, Table A has only code. I need to run update query that fill name in Table A. I tried something like: update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8)) but it doesn't work.

  Read the article

• how to change color of table view title

  - by madhavi

  hello, Can we change the color of the table view title the string which i am showing appears in gray color can we choose color for it .Is there any property of table view title i am not asking for table view header or footer i mean the title - (NSString *)tableView:(UITableView *)tableView titleForHeaderInSection:(NSInteger)section { // Keep space in the following line ........ DONT REMOVE return [NSString stringWithFormat:@"Select your service:"]; }

  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

• 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

• How can the crosshair of ginput be restricted to one plot?

  - by Lucas

  I wrote a small MATLAB program with a gui. Inside the gui I have, among other things, a plot in which the user should be able to select two points. For this I use the function ginput, which creates a crosshair for selection. Unfortunatley the crosshair extends the whole window and is not restricted to the plot, which doesn't look nice and is confusing for the user. How can the crosshair be restricted only to the area of the plot?

  Read the article

• How can I get the element wich currently has focus with jquery?

  - by eugene y

  I need to select the input element which has focus (or filter a set of input elements). How can I do this using jQuery?

  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

• Tiny MCE how to get a tag properties?

  - by Yuru

  Im using tinymce for text formating. I have html code like <span class="ps_bonus_text_wide_t" style="font-family: Michroma;">my text</span>. when i select that text and class="ps_bonus_text_wide_t" i need to change it to <div class="effect"><span class="ps_bonus_text_wide_t" style="font-family: Michroma;">my text</span></div>. How i can to verify class="ps_bonus_text_wide_t" ?

  Read the article

• Returning Null values with COUNT

  - by Randy B.

  With this query, I get a result that is two short of the table because they are not included in count, and I would like get the NULL values in the result. To do this, I am pretty sure I need to use a subquery of some kind, but I am not sure how, since the attribute in question is an aggregate. SELECT Equipment.SerialNo , Name, COUNT(Assignment.SerialNo) FROM Equipment INNER JOIN Assignment ON Assignment.SerialNo = Equipment.SerialNo GROUP BY Equipment.SerialNo, Name

  Read the article

• create procedure fails!?

  - by Mark

  Hi, when trying to create a simple procedure in mysql 5.1.47-community it fails everytime i've tried everything! even simple things like this! DELIMITER // CREATE PROCEDURE two () begin SELECT 1+1; end; //

  Read the article

• How to fetch the first 2 or 3 rows from Mysql DB using Mysql PHP function?

  - by OM The Eternity

  How to fetch the first two rows from Mysql DB using Mysql PHP function? Is there any function which can give me first 2 or 3 rows from the select query we fired?

  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

• j2me: How to use setCommandListener on a TextField?

  - by SmRndGuy

  I wanted to make it so that when I select a specific TextField in a Form, I get a specific list of Commands, for example TextField: OK, CancelTextField2: OK, Back, Help And I succeeded by using addCommand() on each of TextFields but I can't tell it what to happen when when I activate one of these commands since there is no setCommandListener method for them. It throws a NullPointerException when I click it.I also tried to get the commands from their Form but it is receiving only the commands that it contains, not the commands that TextFields have Any help how to get arround this? Thanks in advance

  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

< Previous Page | 574 575 576 577 578 579 580 581 582 583 584 585  | Next Page >