Search Results

Search found 89638 results on 3586 pages for 'file table'.

Page 254/3586 | < Previous Page | 250 251 252 253 254 255 256 257 258 259 260 261  | Next Page >

• MSSQL - select date field in table

  - by thegunner

  Hi, In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370" How can just get the date value of this field in a select statement. e.g. select id from risks, where creation_date = getdate()

  Read the article

• Copy row to another row in same table and vise versa Sql Server

  - by AmRoSH

  I have Table and i want to copy data from row to another and vise versa and i have the rows IDs. is there any query to do that because i don't want make it by .net code i think sql query is easier than that. thanks

  Read the article

• Displaying a table on the Android platform.

  - by Tarmon

  Any suggestions on the best way to display this table on an Android platform? The formatting is not necessary but I am looking for a flexible way to do this because there are numerous tables with different numbers of rows and columns.

  Read the article

• How do I design this link table?

  - by Soo

  Ok SO, I have a user table and want to define groups of users together. The best solution I have for this is to create three database tables as follows: UserTable user_id user_name UserGroupLink group_id member_id GroupInfo group_id group_name This method keeps the member and group information separate. This is just my way of thinking. Is there a better way to do this? Also, what is a good naming convention for tables that link two other tables?

  Read the article

• Accessing html table rows in python django

  - by apoorva

  Hi I am very new to both django and python... I have a html table with person information in each row...How do i get a particular row entry/id of the one i need to edit/delete to accordingly update/delete the row in database??

  Read the article

• how to add unique to a table column in ruby on rails

  - by ohana

  hi, I have a table with some columns, now i need to modify one column to make it unique(no duplicate values), how can i do that in ruby on rails?

  Read the article

• How to Enable Full-Text Index on Sql Server 2008 Table

  - by michaeldelorenzo

  Not sure what's happening with this, but here's my question. I have a Sql Server 2008 database that I need to be able to do full-text indexing/searching but when I try to setup my indices on the table, I get the following: I've tried running this stored procedure on my database and it's successful: EXEC sp_fulltext_database @action = 'enable' But I still get the above window and my full-text searches don't return any results when they should. What am I missing?

  Read the article

• batch update mysql table

  - by Yang

  I have a table with a column called time, "HH:MM:SS". How can I do a batch update so that the value increment by 1 hour? Is it something like: update <table_name> set <time_column> = <time_column> + 3600 where ...

  Read the article

• How to update table with ON DELETE CASCADE without dropping and recreating

  - by pukipuki

  During development of a PostgreSQL database, I made foreign keys in every table. The problem is that I forgot to select ON DELETE CASCADE option. I need to set that options on all tables. It seems I can only drop and recreate every constraint manually. Does anybody know any shortcuts?

  Read the article

• Help making Fluent NHibernate create an oracle sequence for each table

  - by Rafael E. Belliard

  I am using Fluent NHibernate's (1.0 RTM) automapping feature to create my oracle database schema. My issue is that all the tables are using a single "hibernate-sequence", whereas I would prefer (and my boss would demand) a sequence generator for each table. Any ideas?

  Read the article

• VB>NET database connectivity with a table having checkboxes

  - by Muhammed Yoosuf

  Can any1 help me hw 2 insert d code to move 2 d next record of the database in a table that has one CHECKBOX? i tried using the regular method of checkbox1=.Item("BookingStatus").ToString bt it gives a runtime error

  Read the article

• Check if table exists

  - by Dmitry

  I have a desktop application with a database embedded in it. When I execute my program I need to check that specific table exists, or create it if not. Given a Connection object named conn for my database, how could I check this?

  Read the article

• year as a Column Name in a MySQL Table

  - by Laxmidi

  Hi, I've got an easy question. Is it okay to name a column in a mysql table 'year'? Any reason not to? Thanks, -Laxmidi

  Read the article

• Create table on linked server?

  - by vatsalit

  Is it possible to create table on linked server? If yes then how? I really appreciate your help. Thank You.

  Read the article

• How to access table cells from jquery

  - by Sayem Ahmed

  Ok, I have a table which contains multiple rows. Each row contains some data and a hyperlink. When this link is clicked, I need to open up jquery's dialog form and let the user able to edit the data of the corresponding rows. So when the link is clicked, I need to access the values of the corresponding row cells from jquery. How can I do that ?

  Read the article

• Not able to get siblings value from table row

  - by Sullan

  Hi All, I am trying to get values from adjacent columns, when a radio button is clicked for that row. I'm able to do so, but the problem I'm facing, when there are more elements in the radio button column, then i am getting null values(i.e 2nd row is not working). Please help...Code is all follows <table id="dist_list" class="data"> <tbody> <tr> <td> <input type="radio" value="636406" name="distRG" id="radio_7" /></td> <td class="selected">Company 1</td> <td class="siteId">1234</td> <td class="siteName">First Company Name</td> </tr> <!-- Not able to get values from this row, since there are more elements in it --> <tr> <td> <span class="jqTransformRadioWrapper"><a rel="distRG" class="jqTransformRadio" href="#"></a> <input type="radio" value="636406" name="distRG" id="radio_2" /> </span></td> <td class="selected">Company 2</td> <td class="siteId">2345</td> <td class="siteName">Second Company Name</td> </tr> <tr> <td><input type="radio" value="636406" name="distRG" id="radio_3" /></td> <td class="selected">Company 3</td> <td class="siteId">3456</td> <td class="siteName">Third Company Name</td> </tr> <tr> <td><input type="radio" value="213584" name="distRG" id="radio_4" /></td> <td class="selected">Company 4</td> <td class="siteId">4567</td> <td class="siteName">Fourth Company Name</td> </tr></tbody></table> jQuery script $("input[name=distRG]").click(function() { var owner = $(this).parent().siblings('td.selected').text(); var siteId = $(this).parent().siblings('td.siteId').text(); var siteName = $(this).parent().siblings('td.siteName').text(); alert(owner); alert(siteId); alert(siteName); });

  Read the article

• Adding roles from a DB Table

  - by Sunil Ramu

  Can anyone expalin me how to dynamically ger the Role from a DB table instead of hard coding it in the code. ClaimsIdentity outputIdentity = new ClaimsIdentity(); outputIdentity.Claims.Add(new Claim(System.IdentityModel.Claims.ClaimTypes.Name, principal.Identity.Name)); outputIdentity.Claims.Add(new Claim(ClaimTypes.Role, "Manager")); outputIdentity.Claims.Add(new Claim(ClaimTypes.Country, HttpUtilities.GetProgramIdentifierFromUrl())); return outputIdentity;

  Read the article

• Table format for Click stats

  - by Francesc

  Hello. I'm currently developing an URL shortening service. I want to allow users to see the stats for their URLs. How has to be the table. First, it has to be the url ID, but then, how I can sort the clicks per day?

  Read the article

• Truncating table does not make the mysql file smaller

  - by ming yeow

  I truncated several huge tables, but the mysql file and database appears to remain at the same size. Does truncate table delete the data from mysql as well?

  Read the article

• Create a new table and import data from csv file into SQL Server 2005

  - by Madhu Kiran

  Hi, I have several files about 15k each of CSV data I need to import into SQL Server 2005. What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.

  Read the article

• please don't ask me to redesign my table and help me with sql query

  - by saurav

  i have a table as given with name and 10 cities in which he lived during his lifetime. name , c1 , c2 ... ,c10. For a particular name i want to fetch other people who have lived in three or more cities lived by this person.

  Read the article

• MySQL DELETE in a single table

  - by Hossein

  Hi, I have a database with only one table as below: userurltag(id,userID(string),Url(String),tag(String)) I want to delete users that have less than 3 urls associated with them. How can I do that?

  Read the article

• I cant able to remove a row from a table while running through a loop

  - by Vibin Jith

  I am iterating through the table rows . if the row row is null I just want to remove the row. it shows an error Public Sub RemoveBlankRow(ByVal MyDataTable As DataTable) Try Dim MyRowStr As String = String.Empty For Each MyRow As DataRow In MyDataTable.Rows MyRowStr = "" For Each MyCellText As Object In MyRow.ItemArray MyRowStr = MyRowStr + MyCellText.ToString Next MyRowStr = Replace(MyRowStr, "0", " ") MyRowStr = Replace(MyRowStr, ".", " ") If MyRowStr.Trim = String.Empty Then MyDataTable.Rows.Remove(MyRow) End If Next Catch ex As Exception End Try End Sub How to overcome this issue?

  Read the article

• How to constrain a table linking two tables in many-to-many relationship

  - by Gromul

  Say I have the following tables and columns: comp: id, model dvd: id, model comp2dvd: id, id_comp, id_dvd A computer can have multiple dvd drives, even of the same model, and a dvd drive can appear in multiple computers. How do I make it so that comp2dvd table can have only existing comp and dvd ids? Thanks

  Read the article

• More efficient left join of big table

  - by Zeus

  Hello, I have the following (simplified) query select P.peopleID, P.peopleName, ED.DataNumber from peopleTable P left outer join ( select PE.peopleID, PE.DataNumber from formElements FE inner join peopleExtra PE on PE.ElementID = FE.FormElementID where FE.FormComponentID = 42 ) ED on ED.peopleID = P.peopleID Without the sub-query this procedure takes ~7 seconds, but with it, it takes about 3minutes. Given that table peopleExtra is rather large, is there a more efficient way to do that join (short of restructuring the DB) ?

  Read the article

< Previous Page | 250 251 252 253 254 255 256 257 258 259 260 261  | Next Page >