Search Results

Search found 23613 results on 945 pages for 'query parameters'.

Page 623/945 | < Previous Page | 619 620 621 622 623 624 625 626 627 628 629 630  | Next Page >

• 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

• 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

• linq subquery child collection to string

  - by bill

  Hi All, i am trying to figure out how to write a linq query that will return a child collections "name" property as a string. I have a BO that has a "options" property where the options are the "name" property of each option in an "order" object. I would like the result to look something like order.id = 12312 order.date = 12/03/10 order.options = "Option 1 Name, Option 2 Name, Option 3 Name" I hope this makes sense. thanks for any and all help!

  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

• 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 does IIS persist a user's identity from page to page?

  - by Rising Star

  Web pages are, by nature, state-less objects. When you click from page to page in an ASP.net application, each request for a page is treated as a brand-new request. We use things like cookies, session-variables, and query strings to maintain state from page to page. When you log in to an ASP.net web application using Windows Authentication, how does IIS persist your identity between pages?

  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

• How to add a folder to java build path as library, having multiple jars or entries in it ?

  - by yuvraj

  First I want to say lots of thanks to "Rich seller" to solving my query for changing the entry order in eclipse java build path programatically. I want to add my Library folder to java build path which has several jars in it. It should behave like a classpath container. I tried with IClasspathContainer but failed to implement. Please help me.... Thanks in advance. YUVRAJ.

  Read the article

• Erlang: How do you reload an application env configuration?

  - by mwt

  How do you reload an application's configuration? Or, what are good strategies for managing dynamic application configuration? For example, let's say I had log levels and I wanted to change them at runtime. Also, let's assume this is one of many such options. Does it make sense to have a "configuration server" that holds configuration state for other parts of the application to query? Do people do that or did I just make it up?

  Read the article

• what is the optimal database connection strategy

  - by ooo

  i have a asp.net mvc website which runs a number of queries for each page. Should i open up a single connection or open and close a connection on each query?

  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

• 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

• 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

• Best index(es) to use for an OR Statement in SQL Server

  - by Chuck Haines

  I have a table which has a bunch of columns but the two relevant ones are: Due_Amount MONEY Bounced_Due_Amount MONEY I have a SQL query like the following SELECT * FROM table WHERE (Due_Amount 0 OR Bounced_Due_Amount 0) Would the best index to put on this table for SQL Server 2008 be an index which includes both columns in the index, or should I put an separate index on each column?

  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

• 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

• 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

• Is it possible to debug an ad-hoc version of an iPhone app on iPhone using XCode?

  - by user262325

  I have an app that reads and writes data from sqlite3. I tested it on the simulator it looks like everything is OK. But if the ad-hoc version does a 'delete' or 'insert' query in the sqlite3 file on iPhone, it crashes. Is it possible to debug ad hoc versions of iPhone apps with XCode?

  Read the article

• Mysql - NOW() function calling

  - by Ockonal

  Hello, I'm using php for making queries for mysql. Here is one: UPDATE `subscribers` SET `curDate` = NOW() WHERE `e_mail` = "$resEmail" curDate - DateTime type. The problem is that after this query curDate of given email is 0000-00-00 00:00:00 What's wrong?

  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

• MySQL: SUM in WHERE clause

  - by checcco

  Hi guys, I've got this table CREATE TABLE `subevents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(150) DEFAULT NULL, `content` text, `class` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM Each row can have a different value in the 'class' field. I'd like to select any number of rows, ordered randomly, as long as the sum of the values in the 'class' field is equal to 100. How could I accomplish it directly in the MySQL query without doing it later in PHP? Thanks everybody!

  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

• Equivalent of Oracle’s RowID in MySQL

  - by echo

  is there an equivalent of oracle's rowid in mysql? delete from my_table where rowid not in (select max(rowid) from my_table group by field1,field2) I want to make a mysql equivalent of this query!!! What i'm trying to do is, : The my_table has no primary key.. i'm trying to delete the duplicate values and impose a primary key (composite of field1, field2)..!!

  Read the article

• screen shots on how to modify queries in postgresql table created?

  - by pallav

  my tomcat server is showing error 500 exception. actually i am not able to get connected to the table created in the pg admin3 postgresql database to the project deployed in the server. can u please tell me the method to modify query in the table created?

  Read the article

• emacs local version control

  - by aaa

  hello. I am wondering if there is local version control/snapshots for emacs independent of VC? let me clarify: every time I save buffer, I would like to be able to keep track of changes of each save in session. I know I can do something similar with backup files, but they are not automated like VC and a somewhat cumbersome. I have searched Google, but did not find the solution. Perhaps my query string was not good. Thanks

  Read the article

< Previous Page | 619 620 621 622 623 624 625 626 627 628 629 630  | Next Page >