Search Results

Search found 10424 results on 417 pages for 'persisted column'.

Page 264/417 | < Previous Page | 260 261 262 263 264 265 266 267 268 269 270 271  | Next Page >

• how to show only date?

  - by kumar

  I have a column in the data table called CurrentDate as datatype string..(12/2/1983) when I am displaying on the screen this is showing as 12/2/1983 12:00:00AM I am not sure why I am getting timestamp here? can anybody help me out? thanks

  Read the article

• How do I remove separation between rows in a HTML table?

  - by Roman

  I have a html table with 3 rows and 1 column. In the top and button row I have images and in the middle row I have div. Between my rows I see a separation (I see background of my page). I tried to set all padding and margins to zero (for tables, div and images) and I still have this separation. Can anybody, please, help me to solve this problem. The page is here:

  Read the article

• Flex AdvanceDatagrid

  - by udara

  What is the difference between normal datagrid and advance datagrid.Sorting,draging columns,resizing columns are supported even in normal datagrid. I want to add footer details like summery,average etc of each column,does AdvanceDataGrid supports these features?

  Read the article

• javascript validation: comparing 2 text box values

  - by coure06

  I have a table with 5 rows and 2 columns. Each cell contains a text box. I want to show error if one of the text boxes in each column is empty. I want both text boxes in a row shld be filled or both shld empty. How can i do this via Asp.net validation controls?

  Read the article

• Method to sort MYSQL results by an arbitriary letter (ie, show all rows starting with F first)

  - by Buzz

  I have a column of states, and, depending on the query, I want to order by results by a particular state, then by id (Asc or Desc, depending). For instance, I might want to show all rows with state "HI", sorted by ID desc, and then all the other rows, sorted by id desc. I was hoping I could do this in one query, rather than getting all my favored state results, and then getting the rest. Can I?

  Read the article

• SSRS 2008 Grouping With Header VS2008

  - by Kevin

  I have a table with the following columns and data Category Item Price Tax A I1 1.00 .01 A I2 2.22 .02 B I3 3.33 0.3 I want to group on Category and have the details below such as: Category/Item Price Tax A I1 1.00 .01 I2 2.22 .02 B I3 3.33 .03 I want the category to have its own row then the detail rows below with the item in the same column as the Category. The output that is desired is: Category - Item | Price | Tax A | | I1 | 1.00 | .01 I2 | 2.22 | .02 B | | I3 | 3.33 | .03

  Read the article

• Exceptions handling in SQL?

  - by Vineet

  Is there any way to handle exceptions in sql(ORACLE 9i)? Since I was trying to divide values of a column that contains both numbers and literals ,I need to fetch out only numbers from it ,as if it divisible by any number then its number else if contains literals it would not get divided it will generate error. how to handle those errors? Please suggest!!

  Read the article

• MySQL - generate numbers for groups of a result

  - by FreeIX

  I need a query to return this result: +---------+-----+-------+ | ref_nid | nid | delta | +---------+-----+-------+ | AA | 97 | 1 | | BB | 97 | 2 | | CC | 97 | 3 | | DD | 98 | 1 | | EE | 98 | 2 | | FF | 98 | 3 | +---------+-----+-------+ However, I do not have the delta column. I need to generate it for each nid group. In other words, I need an auto incremented number for each group of the result.

  Read the article

• how to get last weeek dates from today to last 7 days date..

  - by Ranjana

  i have a table with column: Registereddate orgid 2010-06-05 10:16:00 1 2010-06-05 10:10:00 2 2010-06-04 22:31:00 3 ... . . ..... . . . i need to get only last weeek dates and orgid from today to last 7 days date..

  Read the article

• In hibernate how do I always use db server's timestamp?

  - by Vishal

  Hi, I would like to add db server's timestamp in last_update column of my table. How can I achieve this in hibernate? Thanks

  Read the article

• Excel - linking 2 columns

  - by Andrew

  I'm trying to create a scheduling system in Excel. I have a column with employees and right beside that, their roles. How do I link each employee to a role?

  Read the article

• Selecting count(*) while checking for a value in the results

  - by Rob

  SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii FROM schedule sch JOIN schools s ON s.ID = 83 WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83) AND sch.SeasonID = 4 I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need.

  Read the article

• Sql query number of occurance

  - by phenevo

  Hi, I wanna to have query: Select cars.* from cars where cars.code in ( select carCode from articles where numberofrecords with this car (it is not a column) >1 and Accepted=1 order by date ) How to write it?

  Read the article

• Selecting two specific mysql table rows in a single query

  - by Scotta

  Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;

  Read the article

• HTML, <table> background

  - by lego69

  hello, I've got one problem... I created table(with one row and one column) for my site and then I put background for table using CSS where I defined image, after that I try to create in the first table another table with 3 rows, Dreamweaver doesn't allow me to do it, it puts new table after first, how can I solve this problem, thanks in advance...

  Read the article

• join two tables but want one matching columns instead of showing it separately sql server 2008

  - by amby

  Hi i want to display join result of two tables but don't want to show matching column separately. I want it one instead of two. so please tell me what query should i use for this. I m using sql server 2008 and my query is like: select * from Customer_Order, optRelation where Customer_Order.orderNumber = optRelation.orderNumber AND optRelation.orderNumber = 21. please reply soon

  Read the article

• CodeIgniter - numbers in sql query are masked with ``

  - by Checkson

  Hello, i'm using CodeIgniter for developing a community board. As I'm using nested sets to get a nested forum hierarchy, I have to run a lot of queries such as: SELECT `id` FROM `forums` WHERE 1 BETWEEN `lft` AND `rgt` My problem: CodeIgniter is replacing the "1" by "`1`" because the "1" is recognized as a column name. Of course, the query does not work any more. Is there a way to get it working? thx in advance

  Read the article

• Looking for a specific python gui module to perform the following task

  - by Sadaf Amouz

  I am looking for a GUI python module that is best suited for the following job: I am trying to plot a graph with many columns (perhaps hundreds), each column representing an individual. The user should be able to drag the columns around and drop them onto different columns to switch the two. Also, there are going to be additional dots drawn on the columns and by hovering over those dots, the user should see the values corresponding to those dots. What is the best way to approach this?

  Read the article

• How do I mysql select with aliases from another table?

  - by Rob

  I'm working with a CMS system where I cannot control database column names. And I've got two related tables: Table: content +------------+----------+----------+----------+----------+ | content_id | column_1 | column_2 | column_3 | column_4 | +------------+----------+----------+----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+----------+----------+----------+----------+ Table: column_names +------------+-------------+ | column_id | column_name | +------------+-------------+ | 1 | good_text | | 2 | bad_text | | 3 | blue_text | | 4 | red_text | +------------+-------------+ What I'd like to do here is select from the first table, but select the columns AS the column_name from the second table. So my result would look like: +------------+-----------+----------+-----------+----------+ | content_id | good_text | bad_text | blue_text | red_text | +------------+-----------+----------+-----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+-----------+----------+-----------+----------+

  Read the article

• Drupal - Break up content with different content (After every 12 products, show an ad?)

  - by kilrizzy

  Currently I have the homepage of a t-shirt site list a 4 column grid, each cell containing all the shirts on the website (using views). The client would like every few rows to display an ad (perhaps a random view/block item). Is this possible? I'm sure I will end up needing to set the grid display to something else but how could I program this in?

  Read the article

• Selecting favourites from DB rails 3

  - by Richlewis

  I have a small app which has Users, Recipes, Ingredients and preparation models A user has many recipes, recipes belong to user and ingredients/preparation belongs to recipes. Now a user can view all recipes but I would like the option to add the particular recipe to a favourites list. Would I need to set a new DB to hold this and then link by associations or could I add a column to the recipe model called fav for example? Im looking for the best practice here or if someone has done this before and can offer any advice that would be appreciated

  Read the article

• in PHP how do i use range() for creating timing list?

  - by I Like PHP

  i want to create a table where first column have timing in below style timing | user1 | user2 | user3 ------------------------------- 9 AM | | | 10 AM | | | . | | | . | | | . | | | 6 PM | | | 7 PM | | | is it possible to use range() for creating timing list, if yes then please tell me , or if not then suggest me better method. Thanks always

  Read the article

• Access different columns from LINQ resultset

  - by Piyush

  I have a query which returns multiple columns from the database using LINQ var donors = from d2 in db.Donors where d2.Status == "Pending" select new { donorID = d2.donorID, bloodGroup = d2.bloodGroup, contactNo = d2.contactMobile, status = d2.Status }; now I want to display the results in different Labels accessing one column value from donors resultset. ex: Label1.Text = donorID; Label2.Text = bloodGroup; ...and so on please help me achieve this.

  Read the article

• PHP Round Minute to nearest Quarter Hour

  - by Rob

  I need to round times down to the nearest quarter hour in PHP. The times are being pulled from a MySQL database from a datetime column and formatted like 2010-03-18 10:50:00. Example: 10:50 needs to be 10:45 1:12 needs to be 1:00 3:28 needs to be 3:15 etc. I'm assuming floor() is involved but not sure how to go about it. Thanks

  Read the article

• LINQ to SQL selecting fields

  - by user3686904

  I am trying to populate more columns in the query below, could someone assist me? QUERY: var query = from r in SQLresults.AsEnumerable() group r by r.Field<string>("COLUMN_ONE") into groupedTable select new { c1 = groupedTable.Key, c2 = groupedTable.Sum(s => s.Field<decimal>("COLUMN_TWO")), }; How could I get a column named COLUMN_THREE in this query ? Thanks in advance

  Read the article

< Previous Page | 260 261 262 263 264 265 266 267 268 269 270 271  | Next Page >