Search Results

Search found 21942 results on 878 pages for 'named query'.

Page 600/878 | < Previous Page | 596 597 598 599 600 601 602 603 604 605 606 607  | Next Page >

• Do views only perform the joins that they need to, or all joins always?

  - by Nate

  I am on an oracle DB. Lets say I have one view that joins to three tables. The view has two fields each. Each field only needs data from two of the three tables. If I query the view and return only one field, does the view still join to three tables or just to the two tables that it needs to calculate the field?

  Read the article

• Unknown Column In Where Clause

  - by Corpo

  I have a simple query: SELECT u_name AS user_name FROM users WHERE user_name = "john"; I get "Unknown Column 'user_name' in where clause". Can I not refer to 'user_name' in other parts of the statement even after select 'u_name as user_name'?

  Read the article

• Real World Application of XPath & XSLT

  - by Knowledge Craving

  Can any professional please specify some real world application, where he / she has used this XPath & XSLT for any logic / view? It creates a great query among some of the people I've communicated with, and so I myself also wants to know about this. I wish that this question will create a starting point from where new developers will take home some practical experience. Any help is greatly appreciated.

  Read the article

• How to save Excel date time cell into MySQL using VBA?

  - by mysqlizor

  The mysql table has a DATETIME field. I want to INSERT a new row into this field using the cell data from the Excel worksheet. But I cannot use the datetime formatted cell value in a INSERT INTO query. How can I implement this?

  Read the article

• How can I preform operations on rows in a Tabular form in MS access?

  - by Justin Tanner

  I have a Tabular type Form based upon a SELECT * FROM table type of query in MS access. I would like to: check / select rows in this form iterate through the checked / selected rows

  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 to distinguish between the first and rest for duplicate records using sql ?

  - by Biswanath

  Hi, These are the input table and required output table. Input table ID Name ------------- 1 aaa 1 ababaa 2 bbbbbb 2 bcbcbccbc 2 bcdbcdbbbbb 3 ccccc Output table ID Name Ord ----------------------------- 1 aaa first 1 ababaa rest 2 bbbbbb first 2 bcbcbccbc rest 2 bcdbcdbbbbb rest 3 ccccc first First and Rest is based on the occurrence of an ID field. Is there a way to write a SQL query to achieve this ? P.S. - This question is somewhat similar to what I am looking for.

  Read the article

• Updated Timestamp field in MySQL through PHP

  - by Vincent

  All, I have a database table in mysql with a field that is of "TIMESTAMP" type. I need help writing the SQL query to update the field with the current timestamp. UPDATE tb_Test set dt_modified = ????? Thanks,

  Read the article

• Create table with PHP and populate from MySQL

  - by typoknig

  Hi all, I am creating a table to display on a web page and that table is populated from data in a MySQL database. I am trying to do a couple of things that are making it difficult for me. First I am trying to have call the PHP code that exists in a separate file in HTML via JavaScript. I think I have that working right but I am not 100% sure (because the table will not display). I think it is working right because some of the code for the table (which is in the PHP file) displays in FireBug. Second I am trying to make it so the rows alternate colors for easy viewing too. My PHP code so far is below. The table does not display at all in any browser. $query = "SELECT * FROM employees"; $result = mysql_query($query); $num = mysql_num_rows($result); echo '<table>'; for ($i = 0; $i < $num; $i++){ $row = mysql_fetch_array($result); $id = $row['id']; $l_name = $row['l_name']; $f_name = $row['f_name']; $ssn = $row['ssn']; $class = (($i % 2) == 0) ? "table_odd_row" : "table_even_row"; echo "<tr>"; echo "<td class=" . $class . ">$wrap_id</td>"; echo "<td class=" . $class . ">$wrap_l_name</td>"; echo "<td class=" . $class . ">$wrap_f_name</td>"; echo "<td class=" . $class . ">$wrap_ssn</td>"; echo "</tr>"; } echo '</table>'; mysql_close($link); }

  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

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• nhibernate, Retrieve the latest row in a table

  - by Blankman

  A user can have many addresses, but I want to retrieve the latest entry for the user. In sql I would do: SELECT TOP 1 * FROM UserAddress WHERE userID = @userID How can I create a criteria query with the same logic? Is there a TOP functionality?

  Read the article

• MySQL INSERT IGNORE not working

  - by gAMBOOKa

  Here's my table with some sample data a_id | b_id ------------ 1 225 2 494 3 589 When I run this query INSERT IGNORE INTO table_name (a_id, b_id) VALUES ('4', '230') ('2', '494') It inserts both those rows when it's supposed to ignore the second value pair (2, 494) No indexes defined, neither of those columns are primary. What don't I know?

  Read the article

• How to: compare array with string and create hastags before tweeting

  - by krike

  Let's say I have the following array (which is the returned value of a database query): Array ( [0] => PHP [1] => Webdesign [2] => Wordpress [3] => Drupal [4]) And the following string: Working With Wordpress Shortcodes How can I compare the array with the string to see if the string contains any word stored in the array? (hopefully that made sense to you :d ) When he finds a match (eg: Wordpress) it should create a hashtag like so: Working With #Wordpress Shortcodes

  Read the article

• WHERE condition accross multiple rows

  - by Chris G

  I have this table... -------------------------------------- | user_id | status | status_date | -------------------------------------- | 1 | Current | 2012-08-01 | | 1 | Referral | 2012-03-14 | | 2 | Referral | 2012-04-23 | | | | | -------------------------------------- How would I query to find a distinct user_id who has a referral date before 2012-06-30 AND either a current date of after 2012-06-30 or no current status record at all? Database is MySQL.

  Read the article

• Google App Engine - Dealing with concurrency issues in storing an object

  - by Spines

  My User object that I want to create and store in the datastore has an email, and a username. How do I make sure when creating my User object that another User object doesn't also have either the same email or the same username? If I just do a query to see if any other users have already used the username or the email, then there could be a race condition.

  Read the article

• Create SQL 'LIKE' Statment that looks for specific Patterns of numbers and letters

  - by tyguy840

  Is it possible to use LIKE in a SQL query to look for patterns of numbers and letters. I need to locate all records where the specific field data has the pattern (2 Numbers,1 hyphen, 3 Letters) ## - AAA I am using SSMS with SQL Server 2008. Any help would be appreciated. THANKS.

  Read the article

• Mysql filling in missing dates

  - by bsandrabr

  I have the following query SELECT * FROM attend RIGHT OUTER JOIN noattend ON attend.date = noattend.date2 WHERE attend.date BETWEEN '2010-02-01' AND '2010-04-01' AND attend.customerid =1 ORDER BY date DESC LIMIT 0 , 30 Attend is the table with customerid noattend is the table with a row for each date (date2) I followed the advice in other questions to right outer join it to create values where there is no record in attend but it still isn't filling in the empties any help much appreciated

  Read the article

• Is there a better alternative to the Mongo shell?

  - by afvasd

  Dear Everyone, Is there a better shell than the native mongo shell? When I press UP I am seeing ^[[A . Does the shell not support last query? Tabbing in the shell does not autocomplete either. Of course, if there's a shell with syntax highlighting that would be great Is there an alternative that has the following features? (Or at least has some of them).

  Read the article

• self join table

  - by San82moon

  HI, i have a table, new_id----old_id----created_on 1234------5678------20100912 5678------3456------20100808 etc. i wrote this query, $q = "select event1.new_id, event1.old_id, event1.created_on,event2.new_id, event2.old_id, event2.created_on FROM replaced_isbns event1 JOIN replaced_isbns event2 ON event2.new_id = event1.old_id WHERE event1.new_id='$id'"; but i get result as 5678 - 1234, ie only one row, i want all rows... plz help me. Thanks, SLC

  Read the article

• WTF why does this SQL work in VS but not in CODE?

  - by acidzombie24

  The line cmd.ExecuteNonQuery(); cmd.CommandText CREATE TRIGGER subscription_trig_0 ON subscription AFTER INSERT AS UPDATE user_data SET msg_count=msg_count+1 FROM user_data JOIN INSERTED ON user_data.id = INSERTED.recipient; The exception: Incorrect syntax near the keyword 'TRIGGER'. Then using VS 2010, connected to the very same file (a mdf file) i run the query above and i get a success message. WTF!

  Read the article

• MSSQL. Compare columns in two tables.

  - by maxt3r

  Hi, i've recently done a migration from a really old version of some application to the current version and i faced some problems while migrating databases. I need a query that could help me to compare columns in two tables. I mean not the data in rows, i need to compare the columns itself to figure out, what changes in table structure i've missed.

  Read the article

• Recommendation for a HTTP parsing library in C/C++

  - by michael

  Hi, I am looking for HTTP parsing library for C/C++. I have looked curl library, but it seems it is a http client library. I am looking for a library which parses HTTP header (e.g. a way to get the query string, get cookie, get request url, get Post Data)? Thank you.

  Read the article

• Efficiently store last X items in an MySQL Database

  - by Saif Bechan

  I want to store the last 3 items in an MySQL database in an efficient way. So when the 4th item is stored the first should be deleted. The way I do this not is first run a query getting the items. Than check what I should do then insert/delete. There has to be a better way to do this. Any suggestions?

  Read the article

• Is it possible to get the Identity value in the ItemInserted event in a listView?

  - by Abe Miessler

  I'd rather not make a call to the database to query @@IDENTITY. Is there some way to get the identity value for what was just inserted?

  Read the article

< Previous Page | 596 597 598 599 600 601 602 603 604 605 606 607  | Next Page >