Search Results

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

Page 584/999 | < Previous Page | 580 581 582 583 584 585 586 587 588 589 590 591  | Next Page >

• Convert bit to boolean string in HyperLinkField.DataNavigateUrlFormatString

  - by abatishchev

  I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1} Select command of appropriate SqlDataSource returns columns of type INT and BIT (from SQL Server 2008). So displayed string becomes something like View.aspx?id=1&isTechnical=1. But I want to display isTechnical=true|False, i.e. Convert.ToBoolean(row["isTechnical"]).ToString().ToLowerInvariant(). How to implement such conversion in page markup?

  Read the article

• MySQL skip first 10 results

  - by Brian

  Is there a way in MySQL to have the first 10 result from a SELECT query skipped? I'd like it to work something like LIMIT.

  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

• [PHP] converting mysql data into array?

  - by Mahmoud

  i have an ajax script that check if the user name is available or not, but it keeps taking the newest user name and the rest are out $result = mysql_query("Select username from customer"); while ($row = mysql_fetch_array($result)){ $existing_users=array(''.$row['username'].','); } i know i am doing something worng

  Read the article

• mysql query results sorting

  - by user329094

  I am calling the results form a query to a list on my site based on if the item is "downtown_hosted". This works fine but I would now like to sort that list DESC, but can't seem to get the syntax correct. Below is what I have: $result_events = mysql_query("SELECT * FROM events WHERE downtown='downtown_hosted' ORDER BY date DESC LIMIT 5 ");

  Read the article

• Howto get Autocomplete for the Propertys in Eclipse

  - by mobbek_hobbeb

  Is it possible to get Autocomplete or Something when i work with the eclipse form editor? I write a color in the strings.xml and then i want to select it by the propertys for the text color, but there is no autocomplete or something equal

  Read the article

• PHP mysql_fetch does not return values

  - by Petr

  Hi, Being quite new with PHP, I cannot find any solution why this does not work. The query is OK and the resource is returned. But I dunno why fetch_assoc does not print values. Thanks $query=sprintf("SELECT ID,NAME FROM USERS WHERE PASS='%s' AND NAME='%s'",mysql_real_escape_string($p),mysql_real_escape_string($n)); $result=mysql_query($query); if ($result) { while ($row = mysql_fetch_assoc($result)) { echo $row['ID']; echo $row['NAME']; } } }

  Read the article

• Php function within SQL statement syntax

  - by Vafello

  I have the following code. I would like username to take the value of the getUserName function however I am fighting with syntax. Can anybody tell me what should be the correct one? $query = "SELECT user FROM users_entity WHERE username = getUserName()";

  Read the article

• Java SQL (h2): What's the best way to retrieve the unique ID of the single item I just inserted into

  - by Daddy Warbox

  My current method is this: SELECT TOP 1 ID FROM DATAENTRY ORDER BY ID DESC This assumes the latest inserted item always has the highest unique ID (primary key, autoincrementing). Something smells wrong here. Alternatives?

  Read the article

• loading of data using jquery

  - by pradeep

  hi, i have a proj where on change of select box i am loading data from server. how do i make sure that until the data is loaded user cant do anything else on the page ..

  Read the article

• Can IF be used to start a MySQL query?

  - by Littledot

  Hi there, I have a query that looks like this: mysql_query("IF EXISTS(SELECT * FROM predict WHERE uid=$i AND bid=$j) THEN UPDATE predict SET predict_tfidf=$predict_tfidf WHERE uid=$i AND bid=$j ELSE INSERT INTO predict (uid, bid, predict_tfidf) VALUES('$i','$j','$predict_tfidf') END IF")or die(mysql_error()); But it dies and mysql tells me to check the syntax near IF EXISTS(....) Can we not use an IF statement to start a mysql query? Thank you in advance.

  Read the article

• jQuery .eq(x) returns different element in IE than in FF/Chrome

  - by bt

  I am using the .eq() method to select a specific child element of a known element. It appears that the element indices are different in IE and in Chrome/FF, as .eq(2) returns different values depending on browser. (The element I'm looking for shows up as .eq(2) in FF/Chrome, but .eq(3) in IE) For example, alert($(this).parent().children().eq(2).text()); shows different results depending on the browser. Is there a better way of doing this?

  Read the article

• WPF inherited UserControl lost VS designer support

  - by PaN1C_Showt1Me

  Hi ! I' written this UserControl: <my:MyUserControl x:Class="MyClass" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:my="clr-namespace:MyNameSpace.MyControls;assembly=MyAssembly"> </my:MyUserControl> public partial class Editor : MyNameSpace.MyControls.MyUserControl {} Everything works, the control is shown in the VS 2008 Designer, but I cannot click directly in the elements and select them as it was with UserControl. Any idea how to solve it?

  Read the article

• android : SQL Exception while querying

  - by Ram

  Team, Can you please help me to understand why I m getting the following exception. 05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1 Thanks in advance,

  Read the article

• SQL - Add up all row-values of one column in a singletable

  - by ThE_-_BliZZarD

  Hello Everybody, I've got a question regarding a SQL-select-query: The table contains several columns, one of which is an Integer-column called "size" - the task I'm trying to perform is query the table for the sum of all rows (their values), or to be more exact get a artifical column in my ResultSet called "overallSize" which contains the sum of all "size"-values in the table. Preferable it would be possible to use a WHERE-clause to add only certain values ("WHERE bla = 5" or something similar). The DB-engine is HSQLDB (HyperSQL), which is compliant to SQL2008. Thank you in advance :)

  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

• Getting the first row of the mysql resource string?

  - by mrNepal

  Here is my problem. I need more than one row from the database, and i need the first row for certain task and then go through all the list again to create a record set. $query = "SELECT * FROM mytable"; $result = mysql_query($query); $firstrow = //extract first row from database //add display some field from it while($row = mysql_fetch_assoc($result)) { //display all of them } Now, how to extract just the first row?

  Read the article

• What's wrong with my using pdo this way?

  - by user198729

  $sql = "SELECT * FROM table ORDER BY :sort :dir LIMIT :start, :results"; $stmt = $dbh->prepare($sql); $stmt->execute(array( 'sort' => $_GET['sort'], 'dir' => $_GET['dir'], 'start' => $_GET['start'], 'results' => $_GET['results'], ) ); I tried to use prepare to do the job,but $stmt->fetchAll(PDO::FETCH_ASSOC); returns nothing.

  Read the article

• SQL - sub count

  - by Andy Clarke

  Hi I've got some SQL ... SELECT AdviceNo, Registration FROM tblSalesDetail that produces something like ... ADV00001, ABC123 ADV00001, CDE564 ADV00002, FGE432 ADV00003, HUY789 ADV00003, MJS532 ADV00003, JFY428 Can anyone tell me how I'd adjust it to see the following please? ADV00001, ABC123, 1 ADV00001, CDE564, 2 ADV00002, FGE432, 1 ADV00003, HUY789, 1 ADV00003, MJS532, 2 ADV00003, JFY428, 3

  Read the article

• Get records from a specific month using SQLite

  - by soren121

  How would I write a SQLite query to select all records from a specific month? My dates are stored as Unix timestamps. PHP code is allowed in your solution if it's required. SQLite2-compatible queries only, please. :)

  Read the article

• How to distribute an iPhone app BEFORE the sale date without getting UDIDs or jailbreaking?

  - by IceMonkey

  I've got an app that's approved by Apple and ready-for-sale, but we're holding off for a few days for press reasons. Anyone know of a way to distribute this thing to beta testers without dealing with UDIDs or jailbreaking phones? Does it matter that it's approved, can I just give select users a file without the provisional stuff?

  Read the article

• how to declare variable in POSTGRE

  - by user307880

  I try to declare a variable in a code like this, but it's doesn't work. Can you tell me what's the problem? ERROR: syntax error at or near "VARCHAR" LINE 2: p_country VARCHAR; DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country;

  Read the article

• Sql string adding problem

  - by Woland

  SELECT a.one + ' test ' +b.two from table1 a right join table1 on a.id =b.id The problem is that when one is null then it the whole string is null, is there some kind of trick to bypass this problem msSQL 2005

  Read the article

• Selecting a random result from Simple Database (SDB) on AWS

  - by benr

  Anyone know how to do this - just what would be the equivalent to this: "select * from YOUR_TABLE order by rand() limit 1" in mysql?? Maybe not possible in SDB?

  Read the article

• Java-Hibernate-Newbie: How do I acces the values from this list?

  - by Mes

  I have this class mapped @Entity @Table(name = "USERS") public class User { private long id; private String userName; } and I make a query: Query query = session.createQuery("select id, userName, count(userName) from User order by count(userName) desc"); return query.list(); How can I acces the value returned by the query?

  Read the article

< Previous Page | 580 581 582 583 584 585 586 587 588 589 590 591  | Next Page >