Search Results

Search found 37260 results on 1491 pages for 'command query responsibil'.

Page 548/1491 | < Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >

• Alternatives of Datatable

  - by mavera

  In my web application, I have a dynamic query that returns huge data to datatable, and this query is often recalled with different parameters. So database is exhausted. I want to get all record with no parameters to an object, and perform queries (may be with linq) on this object. So database will not be exthausted. Which objects can be used instead of datatable?

  Read the article

• Getting duplicate count when executing INSERT IGNORE via JDBC

  - by Nickolay Komar

  Is it possible to get the duplicate count when executing MySQL "INSERT IGNORE" statement via JDBC? For example, when I execute an INSERT IGNORE statement on the mysql command line, and there are duplicates I get something like Query OK, 0 rows affected (0.02 sec) Records: 1 Duplicates: 1 Warnings: 0 Note where it says "Duplicates: 1", indicating that there were duplicates that were ignored. Is it possible to get the same information when executing the query via JDBC? Thanks.

  Read the article

• I want to manually insert an ASCII stream into a column of type BLOB in oracle

  - by Scott Turley

  Is there a command that will convert ASCII into blob? I have the following table: sample_table: ------------- id : NUMBER type : NUMBER version : NUMBER data : BLOB When doing the following command: insert into sample_table values (1, 0, 1, ''); I'm getting the following error: ORA-01465: invalid hex number.

  Read the article

• How to use CPAN as a non-root user?

  - by juannavarroperez

  I want to install perl modules on a shared server on which I do not have root access. How can I do this? They also seem to have an older version of CPAN (it complains about that when running the command), is it possible to update the CPAN command being used from my account without requiring root access?

  Read the article

• NullDisplayText in markup or ISNULL(field, 0) in SQL?

  - by abatishchev

  Which approach is better to use: BoundField.NullDisplayText isn't set. NULL-case is foreseen in SQL query, i.e. SELECT ISNULL(amount, 0) FROM table or BoundField.NullDisplayText is set, e.g. "0.00 %". NULL-case isn't foreseen in SQL query, i.e. SELECT amount FROM table What do you think?

  Read the article

• How to present a plot and then return to cmd prompt

  - by ldigas

  I have a data file, and a gnu file, in which my plotting commands are. How can I produce a plot in gnuplot, in a way that I call gnuplot giving it a name of the gnu file ... it gives me the window with a plot ... and after I close it, it returns me not to gnuplot command prompt, but to cmd (windows cmd.exe) command prompt ?

  Read the article

• How to achieve an eagerly loaded, filtered child collection with the NHibernate criteria API

  - by vakman

  Is it possible to use the criteria api to load a set of parent objects along with a filtered, eagerly loaded set of child objects? I'm trying to query a list of categories and at the same time load the categories products that start with the letter M. The query below gives me the results I want but the Products are not eagerly loaded, that is NHibernate performs additional queries when I enumerate the Product collection: var categoriesWithProducts = session.CreateCriteria<Category>() .SetFetchMode("Products", FetchMode.Eager) .CreateCriteria("Products") .Add(Expression.Like("Name", "M%")) .List<Category>(); What am I missing here?

  Read the article

• How do you select the columns displayed in Pending Changes?

  - by MADCookie

  Open up TFS Pending Changes. Can you add / remove columns to that display? I thought it was tied to the selected query, but change the columns in that query did nothing for the results displayed in Pending Changes.

  Read the article

• Is there a better way to write this URL Manipulation in Python?

  - by dnolen

  I'm curious if there's a simpler way to remove a particular parameter from a url. What I came up with is the following. This seems a bit verbose. Libraries to use or a more pythonic version appreciated. parsed = urlparse(url) if parsed.query != "": params = dict([s.split("=") for s in parsed.query.split("&")]) if params.get("page"): del params["page"] url = urlunparse((parsed.scheme, None, parsed.path, None, urlencode(params.items()), parsed.fragment,)) parsed = urlparse(url)

  Read the article

• how to import the attributes from one table to another in mysql

  - by user225269

  Is it possible to import the attributes of one table, then I put it into another table using a query in mysql? For example I have table1 with attributes lname, fname, mname And I want to put those attributes into table2. Is there any query that could do that? I'm imagining that the table2 has one attribute that could later be dropped so that it will be the same as table1.

  Read the article

• Bash:Redirection Halts

  - by user365828

  I have a command e.g. ls-l file.txt When there is insufficient space on my drive, the above command just stalls waiting for something to happen. Does anyone know about a code that I could write enabling me to display a message about the lack of space on my drive? E.g. could I use IPC or do you have any other ideas? Thanks in advance.

  Read the article

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• ReSharper show warning with SqlDataReader

  - by Belousov Pavel

  When I write something like this: using (var connection = new SqlConnection("ConnectionString")) { using(var cmd= new SqlCommand("Command")) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { } } } } ReSharper shows warning on reader.Read(), and tells that reader can be null. But in what cases can it be null? As I know if command returns nothing reader is not null, it only have nothing.

  Read the article

• Restoring and passing data to an already running instance of a .NET application

  - by mtranda

  The goal is to have an application that runs in the system tray and can either accept user input from its actual GUI (which isn't the actual issue) OR accept command line parameters (that would actually be done via a context menu in windows explorer). Now, while I'm aware that the command line parameters are not exactly possible once the application has started, I need a way to pass data to the already running application instance via some form of handler. I'm thinking maybe define and raise some sort of event? Thanks in advance.

  Read the article

• SQL Alter Table to Add a Column, does it do anything "scary"?

  - by Pselus

  I need to add a column to an existing table in my live sql database. I know how to use the ALTER command, but what I want to know is the effect this has on the table. For example,, if using SQL Management Studio, it claims that adding a column will "drop and recreate" the table. Will the ALTER table command do that as well? This table is CONSTANTLY accessed and VERY important so I want to make VERY sure of this before going forward.

  Read the article

• Can't read AppletViewer properties file - Applet

  - by White rose

  I have create a java applet program and compiled, it generates a class file. while running the applet viewer in command prompt it shows a following warning message. D:\Applets\Appletsappletviewer FirstApplet.java Warning: Can't read AppletViewer properties file: C:eswaran_s.VMSPL.hotjava\properties Using defaults. After I have run this command once again, it does not shows a warning messsage but the applet viewer is not running. How can I solve this issue?

  Read the article

• Dynamically assembling SQL queries in Java

  - by kd

  What is the best way to assemble an SQL query with join conditions dynamically? I don't want to hard code the query for each different condition on a webpage or a set of webpages. Is it even feasible? I got as far as being able to assemble simple queries but i got stumped when i needed to insert join conditions, i.e. how to figure out dependencies for joins etc.

  Read the article

• how to ensure comparison is case sensitive?

  - by newguy

  Hi there, im trying to do a comparison in MYSQL but wish for it to be case sensitive ex: $userID="test" $q = db_query("select * from users where user_id = '" . $userID . "'"); In DB: userid = "TEST" Ho do i go about making sure the mysql query does not return TRUE for this query as the userid varialbe doesnt match the case of the userid in the database thanks

  Read the article

• save Date Number in PHP variable.

  - by Denoteone

  This question goes along with another one of my post that I already accepted How do I get the "date number" in php 2010-08-24 20:00:00.000 I want to assign the current date number to a variable $current_date_num so I can use it in my query to compare what is already in the database. $query ="SELECT * FROM Reservations WHERE [Room_ID] = '$field' AND [Meeting Start] > '$current_date_num' ORDER BY [Meeting Start] asc ";

  Read the article

• Delete record in MySQL with php targeting auto_incremented int?

  - by Chris_45

  Why doesnt this delete work to delete the whole record: $query = 'DELETE FROM tblEvents WHERE index = $_GET["id"]'; $result = mysql_query($query, $db) or die(mysql_error($db)); Where index is variable of type int, auto_incremented in MySQL?

  Read the article

• How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

  - by Wayne M

  I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables. how do I fix this so I can run the query?

  Read the article

• BtsTask to import policy

  - by Sean

  Hello, I am looking for a way to import BRE generated policy with its' vocabularies into BizTalk application from a command line (in order to script it) leveraging BtsTask command line tool. I've searched around, and couldn't find a firm answer. Thank you.

  Read the article

• retrieving the record which has only one value

  - by ashwani66476

  Hello All, Please suggest me a query, which retrieves only those record which has the single row in table. For Example table1. name age aaa 20 bbb 10 ccc 20 ddd 30 If I run "select distinct age from table1. result will be age 20 10 30 But I need a query, which give the result like name age bbb 10 ddd 30 Thanks....

  Read the article

• MySql insert data in multiple table at a time

  - by Sanjay

  hi, i have a query regarding to insert data in multiple table.. i have a two tables. one is item table and second is field table. i want to insert data in both table with one query at a time. any idea about it.

  Read the article

• How to find what service running on background on Android?

  - by XC

  How to find what service running on background on Android? like input method service, .... Using adb or terminal on android device ? Could I use "top" or "ps" command? Maybe I have to ask in another way? Does the service be presented as one "process", then we can use "ps" or "top" command to find it?

  Read the article

< Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >