Search Results

Search found 52589 results on 2104 pages for 'read table'.

Page 133/2104 | < Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >

• Does table columns increase select statement execution time

  - by paokg4

  I have 2 tables, same structure, same rows, same data but the first has more columns (fields). For example: I select the same 3 fields from both of them (SELECT a,b,c FROM mytable1 and then SELECT a,b,c FROM mytable2) I've tried to run those queries on 100,000 records (for each table) but at the end I got the same execution time (0.0006 sec) Do you know if the number of the columns (and in the end the size of the one table is bigger than the other) has to do something with the query execution time?

  Read the article

• In @Table(name = "tableName") - make "tableName" a veriable in JPA

  - by zengr

  I am using JPA and I need to make the "tableName" a variable. In a database, I have many tables, and my code needs to access the table where I specify it to read. @Entity @Table(name = "tableName") public class Database implements Serializable {...............} Any ideas?

  Read the article

• Read a file form web-app

  - by Steve Brewer

  Inside a grails application, I need to upload a file under web-app/js, add a prefix, and put it in S3. I'm having trouble figuring out how to read the js file in a way that will work in development (/web-app/js) and production (/js). I'm doing this from inside a domain object.

  Read the article

• file write or read in javascript

  - by zahir hussain

  how to write and read file in javascript.... is there any possible? i am waiting... thanks

  Read the article

• How to read in space-delimited information from a file in c++

  - by Phenom

  In a text file I will have a line containing a series of numbers, with each number separated by a space. How would I read each of these numbers and store all of them in an array?

  Read the article

• SQL how to avoid duplicate insert in a table

  - by user1624531

  how to avoid duplicate insert in a table? I use below query to insert in to table: insert into RefundDetails(ID,StatusModified,RefundAmount,OrderNumber) select O.id,O.StatusModified,OI.RefundAmount,O.OrderNumber from Monsoon.dbo.[Order] as O WITH (NOLOCK) JOIN Monsoon.dbo.OrderItem as OI WITH (NOLOCK)on O.Id = OI.OrderId WHERE o.ID in (SELECT OrderID FROM Mon2QB.dbo.monQB_OrderActivityView WHERE ACTIVITYTYPE = 4 AND at BETWEEN '10/30/2012' AND '11/3/2012') AND (O.StatusModified < '11/3/2012')

  Read the article

• incrementing a table column's data by one || mySql

  - by Praveen Prasad

  iam having a table with columns like id || counter if i do something (some event) i want the counter's value(at a particular id) to increase by one , currently iam doing this : //get current value current_value = select counter from myTable where id='someValue' // increase value current_value++ //update table with current value update myTable set counter=current_value where id='someValue'; currently iam running 2 queries for this, please suggest me some way do it in one step.

  Read the article

• access Elf section header table

  - by idealistikz

  Assume I have the following: Elf_FIle_Header *fileHeader //struct pointer, points to start of the Elf file header fileHeader->offset //byte offset from start of file to section headers Elf_Section_Header *sectionHeader = (Elf_Section_Header *)(char *)fileHeader + fileHeader->offset Why doesn't the above line point me to the start of the section header table? How do I point to the start of the section header table?

  Read the article

• MySQL select one field from table WHERE condition is in multiple rows

  - by Alex

  Tried to find the answer, but still couldn't.. The table is as follows: id, keyword, value 1 display 15.6 1 harddrive 320 1 ram 3 So what i need is something like this.. Select an id from this table where (keyword="display" and value="15.6") AND (keyword="harddrive" and value="320") There's also a possibility that there will be 3 or 4 such keyword conditions which should result into returning one id (one row) It seems there's something to deal with UNION but i didn't use it before so i can't figure it out Thanks in advance

  Read the article

• reading half part of a table

  - by eastafri

  When i have a table; 1 0 0 1 0 0 1 0 1 0 0 0 1 0 1 1 1 1 1 0 0 0 0 0 1 Say i want to only read and keep the values along the upper diagonal of this table, how can i easily accomplish this in pure ruby? Such that the final structure looks like 1 0 0 1 0 1 0 1 1 1 0 1 1 0 1 Thanks

  Read the article

• How to read the screen pixels?

  - by Newbie

  I want to read a rectangular area, or just one pixel from my screen. As if screenshot button was pressed, but it wouldnt copy the whole screen necessary. So im not talking just about my own program window pixels. How i do this?

  Read the article

• Microsoft Surface: "Read" the tag value of an IdentityTag

  - by sofri

  Hi, is it possible to read the value of an IdentityTag if you place it on the TagVisualizer, without having initalized it before? I would like to use the tags for registering a new object on the Surface but having all the "free" IdentityTags in a Collection for initalizing them all... There must be a better way to do in I think. But the TagVisualizer doesn't seem to do anything when you put a tag on it that it doesn't know.

  Read the article

• read email Using Pop3 client on asp.net web page

  - by leton

  Hello I want to read Emails through pop3. On my asp.net web page how to do let me know, which control i should use for showing email Thanks You

  Read the article

• How to read input until the user enters ^X

  - by Koning Baard

  I am creating an interpreter for my esolang, and I need the user to enter some text which then will be interpreted as an INTERCAL program. I want the user to enter text, which may contain any character including newlines, until the user presses ^X (Ctrl-X), like this: Enter your code followed by ^X: Bla Blablabla Bla^X Thank you for entering your code (line 2, 3 and 4 were entered by the user) can anyone explain me how I can read input including newlines till the user enters ^X? Thanks

  Read the article

• computed column calculate a value based on different table

  - by adnan

  i've a table c_const code | nvalue -------------- 1 | 10000 2 | 20000 and i've another table t_anytable rec_id | s_id | n_code --------------------- 2 | x | 1 now i want to calculate the x value with computed column, based on rec_id*(select nvalue from c_const where code=ncode) but i get error "Subqueries are not allowed in this context. Only scalar expressions are allowed." how can i calculate the value in this computed column ? thanks.

  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

• How to display a mysql table data in another language properly in php

  - by Shinigami

  i have a mySQL table which the data in one of its columns is in a language other than English.(Persian) when i input data in the table , it is shown properly but when i want to show the data in a php file it displays like this:???? well,what should i do in order to show the data in its correct form?

  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

• how can i get the total from the four different table in single query

  - by karthikeyan1211

  In each table have many number of rows with amount. Like this i have different numbers of amount in each table. Each tables field name is different. How can i get the total of all values in the four tables in a single query? Any way is there?

  Read the article

• How, with javascript, can i read Childnode content on an XML file that contains html tags

  - by Joe

  to read a child node content i use : MYDATA = xhr.responseXML.getElementsByTagName("MenuItem") [INDEX].getElementsByTagName("PageContent")[0].childNodes[0].nodeValue; sometimes when the childnode data contains an HTML tag (eg b or br tags, because they have the <), i have problems since they are counted like xml tags (like childnodes). my question is how to get the entire data from a child node even if it contains other html tags exp : MenuItem MenuText menu b text b MenuText MenuItem would return "menu" !!! but i want it to return :"menu text" thank you guys, and happy new year

  Read the article

• read files in linux from .net program?

  - by Rev

  I need to Read files form Linux , copy them into the another computer(Windows operation) and even delete file in Linux. but I want do this with .net program.!!! these file have a specific location. I need code sample or article for doing that.

  Read the article

• how to read the datas from text file stored in the database

  - by Ranjana

  i have a txt file stored in my sql DB, in that .txt file i have certain numbers like 99435 87889 33455 33555 34556 how to get the count of these numbers from the txtfile stored in the database and also to read the file and fetch the number one bye one in a string. using asp.net (C#)

  Read the article

• Make a table row's text editable immediately

  - by Ricky

  I have an NSTableView in my user interface, where new rows are added when the user presses a button or keyboard shortcut. Each row consists of two text cells (the table is comprised of two columns). Is there a way to immediately select the first text cell of a new row which is added? So, basically, I would like the user to be able to press the button, adding a new row to the table and then having it editable straight away.

  Read the article

• Delphi, read data from 3rd party data field

  - by donaldadams1951

  I am writing an application that needs to read a data field on another Delphi program and I do not have access to the source code of the 3rd party program. The data field contains the "foreign key" to a record I need to retrieve or create in my application. I would appreciate any links to knowledge or components that will help me with my program.

  Read the article

• How to structure a table for additional data if a particular value of an enum/lookup table is chosen

  - by Soliah

  I'd like to store additional data if a particular value is chosen in the enumerated or looked-up column in a table. The obvious option is to have an extra column in the table, but this will lead to a mostly empty column and seems to be like bad approach. Is there another option/method of doing this?

  Read the article

< Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >