Search Results

Search found 7127 results on 286 pages for 'calculated columns'.

Page 146/286 | < Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >

• Ordering sql query results

  - by user343409

  My sql query gives the columns: product_id (which is an integer) pnl (which is float - can be negative) I get more than 100 rows. I want to filter out the top 40 rows based on abs(pnl). But the results should be ordered by pnl column only and not by abs(pnl). I want to do this for MSSQL 2005. Is there a way to do this?

  Read the article

• How to copy a text array to a series of cells in Excel

  - by aSystemOverload

  I am dynamically creating a report, where I create a worksheet, bring in the records afresh. How can I easily type the field names and copy them to the cells. Without doing one cell per line, there are ~20 columns. I tried: dim fieldNames as variant fieldNames = ("'DS Date', 'A', 'B', 'A','S ASD', 'S','D S','D S', 'S','D S', 'SD', 'S','D'") Sheets("DATA").Range("C14:W14").Value = Application.WorksheetFunction.Transpose(fieldNames) But it just posts the whole thing in each cell? Any ideas?

  Read the article

• changing a table to array

  - by LIX

  I have a temp table which I fill and clear it in a loop in my code. becouse of using database, it takes musch time. I want to change it to an array to run my app quicker. here is my table columns: ID ( int) , Type (string ), Amount (int) may anyone help me?

  Read the article

• Help with SQL query in C#

  - by DanSogaard

  I'm trying to rename the columns. The syntax should be the column name between double quotes incase of two words, like this: SELECT p_Name "Product Name" from items So I'm trying to do it in C# code like this: string sqlqry1 = "SELECT p_Name \"Prodcut Name\" from items"; But I get an error: Syntax error (missing operator) in query expression 'p_Name "Prodcut Name"'. It seems am having somthing wrong with the quotes, but I can't figure out.

  Read the article

• How to get the dimensions of the scroll bars ?

  - by misha-moroshko

  I have an HTML table that contains lots of rows and columns. Therefore, it has vertical and horizontal scroll bars. How can I get the dimensions in pixels of these scroll bars in Javascript/jQuerys ?

  Read the article

• 398 row datalist slowing down modal open????

  - by Jreeter

  Hey guys I got a weird issue.. I have a datalist that's only loaded on pageload it contains 2 columns a name and date and has 398 rows.. In IE 7 and above(and prob previous version) when I open a modal via a button click it takes almost 5 seconds to open. HOWEVER, if I do not bind this datalist it's MUCH faster.. Also this is only happening in IE, Chrome, Firefox and opera both open the modal instantly with the datalist binded... Josh

  Read the article

• Binding a collection in silverlight

  - by Titan

  For example, I have a collection of integers 1 - 10. I want to dynamically display 4 (can be 5, 6, 7) columns in the datagrid in silverlight. How can I bind the collection to the datagrid to achieve the following? C1 C2 C3 C4 R1 1 2 3 4 R2 5 6 7 8 R3 9 10 Cheers

  Read the article

• Showing fields as readonly in Edit Form of List Item in SharePoint

  - by Graeme

  I have a list which has 5 columns in it. Some of these fields help the user fill in the data but I don't want the user to modify these fields. I have tried changing the field to readonly but that ends up hiding the field completely from the form. Is there a way to get the field to render out to the form as just text? Maybe I need to use javascript to disable the fields programmatically - would prefer not to go down that route though..

  Read the article

• How to show Image Thumb in Flex DataGrid linked to FileReferenceList

  - by John V

  Hello I have a Flex datagrid linked to an array collection that gets filled from a FileReferenceList for uploading images to a server. I want to show a thumbnail of the image in one of the grid columns as a preview. I have seen a lot of examples of doing this with an Item Render but those examples where using images on the server. These images are on the client pc waiting to be uploaded?

  Read the article

• How to calculate "holes" in timetable

  - by genesiss

  I've got a 2-dimensional array like this (it represents a timetable): http://www.shrani.si/f/28/L6/37YvFye/timetable.png Orange cells are lectures and whites are free time. How could I calculate number of free hours between lectures in the same day? (columns are days and rows are hours) For example, in this table the result should be: 2 for first column 0 for second colum -- The function returns 2 (because 2+0=2)

  Read the article

• How to display data from gridview

  - by peter

  I simply added grid view and added columns and gave headertext But when i run the application i am not able to see any grid,,atleast i should see grid column names Do i need to do any thing more

  Read the article

• merging and manupulating files in matlab

  - by Paul

  Is there a way to run a loop through a folder and process like 30 files for a month and give the average,max of each columns and write in one excel sheet or so?? I have 30 files of size [43200 x 30] I ran a different matlab scrip to generate them so the names are easy File_2010_04_01.xls , File_2010_04_02.xls ..... and so on I cannot merge them as each are 20mbs and matlab would crash. Any ideas? Thanks

  Read the article

• Generate table schema inspecting Excel(CSV) and import data

  - by Frank Malina

  How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task? Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table. I have an Excel file of ~200 columns that I want to start normalizing.

  Read the article

• DB2 timestamp PHP DateTime

  - by Dolfa

  After upgrade to PHP 5.3 my application is returning DB2 columns with Timestamp type as "2010-12-15-10.23.22.716000". This is causing problem for PHP DateTime function, as it fails with Failed to parse time string (2010-12-15-10.23.22.716000) at position 25 (0): Unexpected character It seems its having a problem with too much accuracy in DB2 timestamp. Can I somehow force connection to change timestamp format with it is fetching data into?

  Read the article

• How can I drop table if Entity Mode in Hibernate properties is Dynamic-Map?

  - by divi

  Hi all, My application is creating tables dynamically using entity mode as dynamic-map in hibernate properties. Tables are generally network devices having their attributes as columns of table. Requirement is if device is deleted from database, its table will be deleted. Can i drop table using hibernate tools dynamically?

  Read the article

• Blackberry web application wrapping floating divs on top of each other

  - by Jan de Jager

  Our site http://m.sa2010.gov.za has a simple menu structure that relies on floating divs to stack 2 columns of menu elements. Unfortunately it seems to wrap all elements on top of each other when viewed from most Blackberry phones? Any suggestions. works beautifully on most mobile devices including iPhone. Check it out.

  Read the article

• MS Access query for time

  - by nisha

  following data and using MS Access with VB6 UserID UserName LogTime LogDate 1 S 9:00 21/5/2010 1 S 10:00 21/5/2010 1 S 11:00 21/5/2010 1 S 12:00 21/5/2010 1 S 14:00 21/5/2010 1 S 17:00 21/5/2010 Need Output as in below 6 columns:- 1 S 21/5/2010 9:00 21/5/2010 10:00 1 S 21/5/2010 11:00 21/5/2010 12:00 1 S 21/5/2010 14:00 21/5/2010 17:00

  Read the article

• Read a file into an array in c++

  - by user320950

  How would I write a program that reads 3 columns and each column has 100 numbers of type int one at a time in c++ ? I'm lost after this: int file1[100]; int file2[100]; int file3[100];

  Read the article

• SQLAlchemy introspection

  - by Shaman

  What I am trying to do is to get from SqlAlchemy entity definition all it's Column()'s, determine their types and constraints, to be able to pre-validate, convert data and display custom forms to user. How can I introspect it? Example: class Person(Base): ''' Represents Person ''' __tablename__ = 'person' # Columns id = Column(String(8), primary_key=True, default=uid_gen) title = Column(String(512), nullable=False) birth_date = Column(DateTime, nullable=False) I want to get this id, title, birth date, determine their restrictions (such as title is string and max length is 512 or birth_date is datetime etc) Thank you

  Read the article

• sql error validating the default for column

  - by RealityDysfunction

  I am trying to set the default value for a new column I just added. In properties I am trying to set 'Default Value or Binding' to a simple XML along the lines of: <root><title>Welcome</title><body>Thank you for your time.</body></root> However, when I click away, I get "sql error validating the default for column," I set this value in other numerical columns and it worked fine. What gives?

  Read the article

• Is it OK to manage associations manually?

  - by sosborn

  Here are the relevant models: User Product Order A User can sell or buy products An order has a buyer, a seller and one product I know that I can do this with a HABTM relationship between orders and user, but is seems to me like it would be simpler to put in the Order table the following columns: :seller_id :buyer_id and manage those relationships manually as orders are only created once and never edited. However, this doesn't seem very Rails-like and I am wondering if I am missing something conceptually at the HABTM relationship.

  Read the article

• What programming shortcuts do you end up regretting or backing out?

  - by bryanjonker

  I saw this question and it reminded me of AutoGenerateColumns in the old DataGrid. The few times I've used them, I ended up backing it out because I needed data formatting past the standard "spit out the Data Source columns." Likewise, with toggle, it sounds like it would save time, but then you end up needing to keep track of state or something else, and you rewrite the code accordingly. Are there things that you end up using thinking it will save you time, but end up backing out because it doesn't do what you need?

  Read the article

• Group by query design help

  - by Midhat

  Consider this data PK field1 field2 1 a b 2 a (null) 3 x y 4 x z 5 q w I need to get this data select all columns from all rows where field1 has count 1 i tried and finally settled for select * from mytable where field1 in (select field1 from mytable group by field1 having count(field1)>1 ) order by field1 but there has to be a better way than this

  Read the article

• Ensuring the contacts in a Distribution List are displayed with both name and email address

  - by hawbsl

  How can I ensure the contacts I add to an Outlook distribution list are displayed with both name and email address? These contacts may not exist in any other address book, just the distribution list. Currently they show up just as an email address (in both columns). Here's roughly the VBA we're using: Do Until RS.EOF //here's where we want to inject RS!FirstName, RS!Surname etc objRecipients.Add RS!Email objRecipients.Resolve RS.MoveNext Loop Set objDistList = contactsFolder.Items.Add("IPM.DistList") objDistList.DLName = "Whatever" objDistList.AddMembers objRecipients objDistList.Save etc

  Read the article

• Linq 2 SQL Grouping Question

  - by Jack Marchetti

  var groups = from p in dc.Pool join pm in dc.PoolMembers on p.ID equals pm.PoolID group p by p.Group into grp select new { grp.ID }; This isn't working. Basically I want to do the grouping, and then select certain columns, but when I do select new { grp. } I get no intellisense, so I'm obviously doing something wrong. Any ideas?

  Read the article

< Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >