Search Results

Search found 25852 results on 1035 pages for 'linq query syntax'.

Page 768/1035 | < Previous Page | 764 765 766 767 768 769 770 771 772 773 774 775  | Next Page >

  • Load huge sql dump to mySql

    - by jonathan
    Hi I have a huge mysql dump file generated from phpmyAdmin (150 000 lines of create table, inserts....) The mySql query tool fails to open such a big file. As a result i can't insert all the records. Is there a way to do this ? Thanks John

    Read the article

  • Lucene Search for documents that have a particular field?

    - by RP
    Lucene.Net - Is there a way to query for documents that contain a particular field. Lets say some of my documents have a field 'foo' and some do not. I want to find all documents that have the field 'foo' - regardless of what the value of foo is. How do I do this? Is it some sort of TermQuery?

    Read the article

  • Getting all rows from a Table where the column contains only 0

    - by Auro
    I got a little problem i need a sql query that gives all rows back that only contains 0 in it. the column is defined as varchar2(6) the values in the column looks like this: 0 00 00 100 bc00 000000 00000 my first solution would be like this: Oracle: substr('000000' || COLUMN_NAME, -6) = '000000' SQL Server: right('000000' + COLUMN_NAME, 6) = '000000' is there an other way? (it needs to work on both systems)

    Read the article

  • Can you define values in a SQL statement that you can join/union, but are not stored in a table outs

    - by Mervyn
    I'm trying to create a query and need to join against something that I can define values in without creating a table. I'll attempt to describe what I'm trying to do: table1 is joined on field a with table2 (titles for FK in table 1) - Table1 has values outside of what exists in table2 - I want to add an additional 'table' to be unioned with table2 and then joined with table 1 Thanks

    Read the article

  • How can I add a column to this union result?

    - by MrXexxed
    I have this query (which I removed some keys from for brevity's sake): SELECT id as in_id, out_id, recipient, sender, read_flag FROM received WHERE recipient=1 UNION ALL SELECT in_id, id AS out_id, recipient, sender, read_flag FROM sent WHERE sender=1 Which combines the results from two tables showing messages sent and received by a given user. What I'd like to do is add a column/flag to the result to distinguish which table the row belongs to so when I display them I can show a relevant icon for sent or received messages. How would I add this?

    Read the article

  • Camping: Return user to recent entries, but keep errors

    - by echoback
    Users can view a specific entry in my webapp with a URL. /entry/8, for example. If an entry doesn't exist, "Entry not found" gets appended to @messages and I render an error page. I'd like to redirect the user to /recent, but I can't figure out a good way to keep the error message around to be displayed. There are other actions that need to take place in the Recent controller, so I can't just duplicate the query and render :posts.

    Read the article

  • update XML file

    - by Pila
    I want to replace an XML node that is not a child of the root element. How can I do it - not in .NET 3.5? I don't know the exact path to the node I want to replace, I get the node by XPath query like: XmlElement root = doc.DocumentElement; oldItem = root.SelectSingleNode("//Node1[@name='aaa']//Node2[Item='bbb']/Value"); How can I replace this old item?

    Read the article

  • Compare two table and find matching columns

    - by Karthick
    Hi, I have two tables table1 and table2, i need to write a select query which will list me the columns that exist in both the tables.(mysql) I need to do for different tables (2 at a time) Is this possible? I tried using INFORMATION_SCHEMA.COLUMNS but am not able to get it right.

    Read the article

  • The big last_insert_id() problem, again.

    - by wretrOvian
    Note - this follows my question here: http://stackoverflow.com/questions/2983685/jdbc-does-the-connection-break-if-i-lose-reference-to-the-connection-object Now i have a created a class so i can deal with JDBC easily for the rest of my code - public class Functions { private String DB_SERVER = ""; private String DB_NAME = "test"; private String DB_USERNAME = "root"; private String DB_PASSWORD = "password"; public Connection con; public PreparedStatement ps; public ResultSet rs; public ResultSetMetaData rsmd; public void connect() throws java.io.FileNotFoundException, java.io.IOException, SQLException, Exception { String[] dbParms = Parameters.load(); DB_SERVER = dbParms[0]; DB_NAME = dbParms[1]; DB_USERNAME = dbParms[2]; DB_PASSWORD = dbParms[3]; // Connect. Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://" + DB_SERVER + "/" + DB_NAME, DB_USERNAME, DB_PASSWORD); } public void disconnect() throws SQLException { // Close. con.close(); } } As seen Parameters.load() refreshes the connection parameters from a file every-time, so that any changes to the same may be applied on the next immediate connection. An example of this class in action - public static void add(String NAME) throws java.io.FileNotFoundException, java.io.IOException, SQLException, Exception { Functions dbf = new Functions(); dbf.connect(); String query = "INSERT INTO " + TABLE_NAME + "(" + "NAME" + ") VALUES(?)"; PreparedStatement ps = dbf.con.prepareStatement(query); ps.setString(1, NAME); ps.executeUpdate(); dbf.disconnect(); } Now here is the problem - for adding a record to the table above, the add() method will open a connection, add the record - and then call disconnect() . What if i want to get the ID of the inserted record after i call add() -like this : Department.add("new dept"); int ID = getlastID(); Isn't it possible that another add() was called between those two statements?

    Read the article

  • .NET DataSource Clarification

    - by Steven
    I'm fairly new to database programming in .NET. If I want to call several existing queries from the same database for different tasks, should I have one DataSource per database, per database connection, or per query?

    Read the article

  • Listing most commented news

    - by zurna
    I have two tables in my database. Comments CommentsID MembersID CommentsBy CommentsBy CommentsDesc CommentsActive CommentsDateEntered NewsI News NewsID MembersID CategoriesID ImagesID ImagesID NewsTitle NewsTitle NewsShortDesc NewsDesc NewsActive I need to take top 5 commented news (active comments and active news) and list their titles using one query. I hope I made sense. But I am really confused here. Any suggestion appreciated.

    Read the article

  • summing the sum in mysql

    - by JPro
    Hi, Say If I get a resultset in mysql as : ID count(posts) 101 2344 102 3245 103 232 104 23 Is there any way to get the tota count of count(posts) in the query itself, like this? ID count(posts) 101 2344 102 3245 103 232 104 23 ------ 5844

    Read the article

  • How to list all installed ActiveX controls?

    - by sep
    I need to display a list of ActiveX controls for the user to choose. It needs to show the control name and description. How do I query Windows on the installed controls? Is there a way to differentiate controls from COM automation servers?

    Read the article

  • iPhone to host server to mySQL and back?

    - by ronbowalker
    Can someone please direct me to process for doing this? I have already done the Login verification exercise using mySQL for the dbase on my host server (thanks to kiksy). Now I am trying to move forward and "Query" from the iPhone a list of "users" that currently occupy the table (iphoneusers) in MySQL. And of course get it back to the iPhone via the php connection. Any help would be very much appreciated. ronbowalker

    Read the article

  • Email Accounts Issue

    - by AliDeo
    Is there any way that i can access the email accounts that are saved in the default email client of android. Basically i want to access the inbox and display their mails without asking for username and password. Does AccountManager class thats available in android version 2 answer my query? and if yes then is there any alternative for v1.5 or v1.6.

    Read the article

  • sql clarification

    - by JPro
    Can anyone please clarify what this query will return ? SELECT TestCase FROM MyTable WHERE Verdict = 'PASS' AND StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTH)

    Read the article

< Previous Page | 764 765 766 767 768 769 770 771 772 773 774 775  | Next Page >