Search Results

Search found 90467 results on 3619 pages for 'new rows'.

Page 44/3619 | < Previous Page | 40 41 42 43 44 45 46 47 48 49 50 51  | Next Page >

• Firebird: How to assign id to existing rows from newly added generator

  - by Aldo

  I have a table which already contains some rows and does not have a primary key. I want to add a primary key now, but for that I need to set unique values for the primary key field of the existing rows. How can this be done, using the newly added generator?

  Read the article

• winforms: datagridview: height (autosize) depending on number of rows

  - by ibmkahm

  in one of my forms a datagridview displays data from a database (of course the number of data (so number of rows) can change). The database connection is in the form load event. I just cant figure out how the height of the whole datagridview is autosized, depending on the number of rows it displays.

  Read the article

• IM brand-spanking new, i've used HTML randomly, where next?

  - by colton kolbeck

  as I said,i've loosely applied HTML in some instances, but i'm looking for a more techy, but easy to learn language.Can anyone help?

  Read the article

• Adding rows to an array in PHP

  - by ChuckO

  I have loaded an associative array of records from a MySQL database table. The array consists of 1 to 7 rows representing one week of entries, which might not have been entered for each day. How can I insert blank rows into the array for the missing days so that I can easily display the data in a table? I don't need to update the database with the blanks.

  Read the article

• How to delete multiple rows in a DataTable?

  - by burak ozdogan

  Hi, How can I delete specific DataRows within a loop of a DataTable rows which meet a custom condition -lets say the rows having an index of even number-? (Without using LINQ) Thanks

  Read the article

• MySQL More Tables or More Rows

  - by Pez Cuckow

  I am working on a game that I am going to open to the public to have on their game. The game stores lots of information (about 300 rows) per website and spends a lot of time updating values within this MySQL database. Is it better (faster/efficient) to add a new table for every website or to just have 1000's of rows in one table and add a column "website_id" or similar?

  Read the article

• sql server - select top and bottom rows

  - by Adrian Faciu

  Hi, I'm using Sql Server 2005 and i'm trying to achieve something like: In the same select statement i want to get the first x rows and the last x rows. SELECT TOP(5) BOTTOM(5) Of course 'bottom' does not exist so i need other solution. I believe there is an easy and elegant solution that i'm not getting. Doing the select again with Group By Desc is not an option. Thanks.

  Read the article

• avoid textarea rows/cols error?

  - by acidzombie24

  I am using a few page validation tools one problem i have is they tell me textarea must have rows and cols attribute. If i am setting this in CSS or using display:none (and using it to hold raw text data) can i do something to skip? it seems like the only answer is rows="0" cols="0" each time i use it. But i have a feeling that is not a good solution.

  Read the article

• I need to insert multiple rows at once in sql server ..based on an iterative value

  - by sajad

  Hi friends, I want to insert 3 rows at a time in a table based on select statement.. consider the query insert into tblTemp ( a,b ) select a, b from tblTemp2 This lets me insert one row in tblTemp.. my requirement is to add 3 rows with iterative values a,a+1,a+2 for each b inserted.

  Read the article

• Rows and Column of Excel File

  - by Mark

  It is possible to write a code that specifying the rows and column of spread sheet in terms of NUMBERS and NOT LIKE (B2:D6) Example: excelSheet.Range("B2:D6").Interior.Color = RGB(100, 100, 255) instead of B2 and D6 I want to write 5 rows and 3 column.. It is posible to write in vb.net 2003 code?

  Read the article

• Firebird: assign id to existing rows from newly added generator

  - by Aldo

  hello everyone, i have a table whixh contains some rows and dows not have a primary key. I want to add one now, but, is it possible for the existing rows to get an id from the newly added primary key? Dbms: firebird

  Read the article

• New Comer to JS Looking for Guidance

  - by New Coder

  I'm fairly new to JavaScript. Can anyone share some good advice on getting started? I have a little experience in ActionScript 3 and have taken a few Java classes toward my CS degree but my background is of a designer transitioning into development. My goal is to become a well rounded front-end developer and I'd like to move beyond the simple slideshow animations and rollover effects. Any guidance/wisdom will be much appreciated!

  Read the article

• Compare two tables rows and remove if match

  - by Istvan

  Could anyone help me please in JQuery? I have two tables on my site leftTable and rightTable with same column names. The leftTable I fill up from a DB, but the rightTable it just contains some rows. What I would like to do is to not show (or remove) in the leftTable those rows which are exist in the rightTable! I Tryed this: $("#tableLeft tr").each(function () {if ($(this).find("td")[0].innerHTML == $("#tableRight tr").find("td")[0].innerHTML) {$(this).remove;}});

  Read the article

• Windows 7 - add item to 'New' context menu

  - by Tingholm

  I've installed Access 2010 but have some software that can only handle the old .mdb files. When I right click an empty space in a folder and select 'New', I would like to create an .mdb file instead of .accdb. I've managed to remove the "New Access Database" that created a new .accdb file, but I can't find how to create a context menu item to make a new .mdb file. I've tried: Windows 7 - Add an item to 'new' context menu http://www.sevenforums.com/tutorials/22001-new-context-menu-edit-desktop.html However I've had no luck, nothing appears in the 'New' menu. Any ideas?

  Read the article

• MySQL : Insert Exactly Same Data Multiple Rows Without PHP Loop

  - by Robert Hanson

  I need to insert same data to my MySQL table without having PHP loop. The reason why I'm doing this is that because I have a column with Auto_Increment feature and that column associates with other table. So, I just need to insert some exactly same data and it's multiple rows (dynamic) but by using single INSERT syntax below : INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage') how to have this single INSERT syntax, but produce n number of rows?

  Read the article

• Ever increasing number of rows returned for SQL Server database

  - by Maestro1024

  I have a SQL Server Express database that has a query that should return about 230 thousand rows. Problem is the query returns about 5 more rows each time you run the query. What would cause something like this? I ran 'DBCC CHECKDB' but that did not change the behavior. Any ideas. thanks

  Read the article

• Efficient SQL to count an occurrence in the latest X rows

  - by pulegium

  For example I have: create table a (i int); Assume there are 10k rows. I want to count 0's in the last 20 rows. Something like: select count(*) from (select i from a limit 20) where i = 0; Is that possible to make it more efficient? Like a single SQL statement or something? PS. DB is SQLite3 if that matters at all...

  Read the article

• Django - Add rows to MySQL database

  - by yeenow123

  So I already have a database setup with a few columns and a few rows already inserted in. I'm trying to create a view that you would just input information into a form and press Submit, then a row would be added to the MySQL database with the information you just typed in. I believe you can do this with admin, but I would like to try without admin and I'm not sure if this is possible? I've been using the MySQL commandline to add rows as of now..

  Read the article

• SQL: how to get all the distinct characters in a column, across all rows

  - by frankadelic

  Is there an elegant way in SQL Server to find all the distinct characters in a single varchar(50) column, across all rows? Bonus points if it can be done without cursors :) For example, say my data contains 3 rows: productname ----------- product1 widget2 nicknack3 The distinct inventory of characters would be "productwigenka123"

  Read the article

• restrict users from changing rows inserted 3 hours ago in mysql

  - by htaikthegreat

  Hi, I inserted a number of rows 3 hours ago and I don't want these rows from changing. How can I write sql statement that compare current time with the timstamp in the row and restrict users from changing it if abouve creteria is met. Thanks

  Read the article

• query mysql table and fetch rows posted in 3 days

  - by Mac Taylor

  Hey guys how can i query my mysql database and fetch rows which are posted in earlier 3 days i know how to fetch todays's rows but not 3 days ago time will save in my table like this : 2010-01-20 19:17:49 and this is what i know : SELECT id FROM pages WHERE date=now() but i need to show posts in 3days and im looking for a simple and straight solution ,because i know how to do so in long php codes

  Read the article

• What's the equivalent of new/delete of C++ in C?

  - by httpinterpret

  Or it's the same in c/c++?

  Read the article

• SQL Oracle Combining Multiple Results Rows

  - by Stuav

  I have the below query Select case upper(device_model) when 'IPHONE' then 'iOS - iPhone' when 'IPAD' then 'iOS - iPad' when 'IPOD TOUCH' then 'iOS - iPod Touch' Else 'Android' End As Device_Model, count(create_dtime) as Installs_Oct17_Oct30 From Player Where Create_Dtime >= To_Date('2012-Oct-17','yyyy-mon-dd') And Create_Dtime <= To_Date('2012-Oct-30','yyyy-mon-dd') Group By Device_Model Order By Device_Model This spits out multiple rows of results that read "Android"....I would like there to be only 4 results rows, one for each case....so it comes out like this: Device_Model Installs_Oct17_Oct30 Android 987 iOS - iPad 12003 iOS - iPhone 8563 iOS- iPod Touch 3482

  Read the article

• Would Lisp be extremely difficult for a new(ish) programmer to learn?

  - by Rubber Duchy

  I've got a little experience with Python (enough to where I can do if/else/elif and some random number generation), but I've always had a weird fascination with the Lisp languages. I downloaded some scheme source code to look at the syntax but it was pretty much gibberish to me. For a programmer with only a little programming experience like myself, given some good books, websites, and some time, would it be particularly difficult to learn either Common Lisp or Scheme? Which of the two would be easier? How do they compare with Python and C, as far as ease of learning? Thanks

  Read the article

• Update query not effecting all rows in database

  - by Webnet

  I have the following query.... UPDATE vehicle_catalog SET parent_id = 0 WHERE parent_id = SUBSTR(id, 0, 5) I need to set all parent_ids to 0 where the first 5 characters of id is the same as the parent_id. This is effecting 0 rows when I'm looking at the data and it should be effecting over 10,000. Any ideas on why this wouldn't be effecting all rows?

  Read the article

< Previous Page | 40 41 42 43 44 45 46 47 48 49 50 51  | Next Page >