Search Results

Search found 23955 results on 959 pages for 'insert query'.

Page 619/959 | < Previous Page | 615 616 617 618 619 620 621 622 623 624 625 626  | Next Page >

• How to make a report with count of type of cases in each month in Acess 2010

  - by amir shadaab

  I have a database is access with each record having a date and yes/no type columns for each record which shows which category the record comes under. I want to create a report which shows the types of cases in each month by taking a date range as a parameter through prompts. I have done the prompt part but I'm not sure how the query should be to show values for each month in that date range. Can someone please help me with this?

  Read the article

• How do sites look up addresses from UK postcodes?

  - by ctford

  U.K. that require addresses often ask the user to provide a postcode. The site then offers the user a choice between the addresses that match that postcode. Where do these sites get the data to do this? Are there webservices that match postcodes to addresses? Do sites buy a database of addresses that they then query locally?

  Read the article

• Oracle SQL - How to Retrieve highest 5 values of a column

  - by Trevor

  How do you write a query where only a select number of rows are returned with either the highest or lowest column value. i.e. A report with the 5 highest salaried employees?

  Read the article

• Mysql syntax using IN help!

  - by Axel

  Hi, i have a pictures table : pictures(articleid,pictureurl) And an articles table : articles(id,title,category) So, briefly, every article has a picture, and i link pictures with article using articleid column. now i want to select 5 pictures of articles in politic category. i think that can be done using IN but i can't figure out how to do it. Note: Please only one query, because i can do it by selecting articles firstly then getting the pictures. Thanks

  Read the article

• Access 2007 can I capture the "clicked" field using an OnClick event on a report?

  - by Aaron Quince

  In Access 2007 I want to be able to click on a name field in a report and call a separate report with personal information about the person who's name was clicked to start the event. This would be as an alternative to creating a subreport or including the subreport fields in the main report in the interest of saving space. How do I reference the value of the clicked field for use in a query called with the OnClick event? Thanks for your help.

  Read the article

• Recalculate Counter Cache of 120k Records [Rails / ActiveRecord]

  - by Sebastian

  The following situation: I have a poi model, which has many pictures (1:n). I want to recalculate the counter_cache column, because the values are inconsistent. I've tried to iterate within ruby over each record, but this takes much too long and quits sometimes with some "segmentation fault" bugs. So i wonder, if its possible to do this with a raw sql query?

  Read the article

• How do I format a date column in MySQL?

  - by Ayyappan.Anbalagan

  My query returns the row value as "2/27/2010 12:00:00 AM" but I need to get "2/27/2010". What do I use to get the format as I need it for MySQL?

  Read the article

• Linq to Object -Object update

  - by nettguy

  In LINQ to Object context ,can i update an object in memory. I mean i can create new type like var query =from e in empList select new {id=e.id,salary=e.salary * (10/100) }; can i update an object?

  Read the article

• PHP - Retrieve Data From mySQL Server

  - by Kevin

  Hello, Does anyone know how to retrieve a piece of data and display the results in php file? A similar query that I would enter is something like this: SELECT 'email' FROM 'users' WHERE 'username' = 'bob' Thus, the result would be just the email. Thanks, Kevin

  Read the article

• mysql select column from view problem

  - by haim evgi

  i create a view table like : CREATE VIEW ViewManager AS SELECT us.UserId AS 'Account Manager', ......... after that, when i run a query to select data from this view like : SELECT 'Account Manager' , .. from ViewManager then the data i get in this column is the text 'Account Manager' and not the value of the this columns. Is there a way to solve this ? Of course I can change the field name , but i want to know if there is another solution, thanks.

  Read the article

• Better way to do SELECT with GROUP BY

  - by Luca Romagnoli

  Hi i've wrote a query that works: SELECT `comments`.* FROM `comments` RIGHT JOIN (SELECT MAX( id ) AS id, core_id, topic_id FROM comments GROUP BY core_id, topic_id order by id desc) comm ON comm.id = comments.id LIMIT 10 I want know if it is possible (and how) to rewrite it to get better performance. Thanks

  Read the article

• Access 2nd MySQL db in PHP without mysql_select_db()

  - by Brian

  If I select a db db1 with mysql_select_db() is it possible to access another db db2 in a query? I am looking for something like SELECT * FROMdb2.sometableWHERE 1

  Read the article

• Android Content Provider database leak issue

  - by MattC

  I am writing a content provider for this application and in my content provider I am opening a database connection, running a query and returning the cursor of results to the calling program. If I close this database connection in the provider, the cursor has no results. If I leave it open, I get "leak found" errors in my DDMS log. What am I missing here? What's the clean, proper way to return a cursor of database results?

  Read the article

• jQuery Color **Swatch** Picker

  - by Alan Storm

  Has anyone coded up a jQuery query color picker that lets you pick colors from a predetermined list of colors? Something like a product color picker on an Ecommerce site. Most of the searching I've done reveals a lot of general purpose, pick-any-color-in-the-rgb-spectrum, but few options for picking specific colors.

  Read the article

• Zend_Db_Table - Update don't work

  - by poru

  The code seems not working. // $counter is an instance of Zend_Db_Table_Abstract $counter->update(array('hits' => 'hits+1'), '"id" = 1'); I took a look into the DB profiler and find the following query: UPDATE `downloads` SET `hits` = ? WHERE ("id" = 1)

  Read the article

• How does contains() in PL-SQL work?

  - by Artic

  Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something else. It is hardcoded and couldn't be changed.

  Read the article

• Detecting changes between rows with same ID

  - by Noah

  I have a table containing some names and their associated ID, along with a snapshot: snapshot, id, name I need to identify when a name has changed for an id between snapshots. For example, in the following data: 1, 0, 'MOUSE_SPEED' 1, 1, 'MOUSE_POS' 1, 2, 'KEYBOARD_STATE' 2, 0, 'MOUSE_BUTTONS' 2, 1, 'MOUSE_POS' 2, 2, 'KEYBOARD_STATE' ...the meaning of id 0 changed with snapshot 2, but the others remained the same. I'd like to construct a query that (ideally) returns: 1, 0, 'MOUSE_SPEED' 2, 0, 'MOUSE_BUTTONS' I am using PostgreSQL v8.4.2.

  Read the article

• mysql statement with inner SELECT - how to improve performance

  - by ernie

  This statement appears inefficient because only one one out of 10 records are selected and only a of 100 entries contain comments. What can I do to improve it ? $query = "SELECT A,B,C, (SELECT COUNT(*) FROM comments WHERE comments.nid = header_file.nid) as my_comment_count FROM header_file Where A = 'admin' "

  Read the article

• How can you remove a criterion from criteria?

  - by ChuckM

  Hello, For instance if I do something like: Criteria c = session.createCriteria(Book.class) .add(Expression.ge("release",reDate); .add(Expression.ge("price",price); .addOrder( Order.asc("date") ) .setFirstResult(0) .setMaxResults(10); c.list(); How can I use the same criteria instance, but remove (for example) the second criterion? I'm trying to build a dynamic query in which I'd like to let the user remove a filter, without the backend having to reconstruct the criteria from scratch. Thank you

  Read the article

• MySQL ORDER BY offset

  - by monk.e.boy

  In a MySQL query how would I select: all rows ordered by column 'name' where name 'f' so I'd get Gs, Hs ... Xs, Ys, Zs, As, Bs, Cs ... Fs.

  Read the article

• Can one suppress the conversation propagation with an `<h:link>`?

  - by Brian Leathem

  I'm using the new JSF2 <h:link> tag, with a nested <f:param> to link to a page using a get request. However, the conversation id (cid) is propagated via the query parambeters of the link to the new page. Can one suppress the conversation propagation with an <h:link>? ie. no cid=# in the url...?

  Read the article

• PHP PDO - Num Rows

  - by Ian

  PDO apparently has no means to count the number of rows returned from a select query (mysqli has the num_rows variable). Is there a way to do this, short of using count($results->fetchAll()) ?

  Read the article

• Request for comments: Ruby script that counts the length of a MySQL table name

  - by bakerjr

  Hi, I'm new at ruby and I would like to ask you guys if there's something that could improve my Ruby code. Here's my script: #!/usr/bin/ruby -w require 'mysql' dbh = Mysql.real_connect('localhost', 'db_user', 'password', 'db_table') tables = dbh.query('show tables') tables.each do |table| puts "#{table}" + " (" + "#{table}".length.to_s + ")" end I'd love to hear your comments. Thanks in advance

  Read the article

• how can i loop through all of the columns of the OracleDataReader

  - by ooo

  I have the following code and i want to loop through all the fields in the result of this query and populate the dictionary called field. Given a datareader is this possible? OracleCommand command = connection.CreateCommand(); string sql = "Select * from MYTABLE where ID = " + id; command.CommandText = sql; Dictionary<string, string> fields = new Dictionary<string, string>(); OracleDataReader reader = command.ExecuteReader();

  Read the article

• EXTRACT for TIMESTAMP types in SQLite3

  - by umuthorax

  Hi, It seems extract function is not supported by SQLite3 for timestamp types (ref). For example; select extract(year from l_shipdate) as l_year from ... gives the following error; Error: near "from": syntax error I wonder whether there is an alternative way to do this in SQLite3 (or through rewriting the SQL query). Thanks in advance,

  Read the article

< Previous Page | 615 616 617 618 619 620 621 622 623 624 625 626  | Next Page >