table

How to re-seed a table identity in SQL Server 2008 and undo it all safely?

I need to do this for testing only, but then undo it when the test is done. I have seen some tutorials online on how to re-seed a table, but not so much on how to undo it. Let's say the table definition is the following: create table beer ( beer_id numeric(10) not null, mnemonic nvarchar(8) ); go Let's say that I want the ...

jQuery/css/html: scrollable table with fixed header

hi all, i know this question has been asked several times but i couldn't find a satisfying, x-browser solution yet :( i thought the easiest way to acomplish a scrollable table with fixed header should be using 2 tables: (1 for header, 1 for the content) and kinda sync them. i've tried that but there's always slight glitches in the layo...

Extract data from nested tables in pdf (c#)

I have a few pdf files that were created from word or excel files. I need to get the information thats in the tables. The text in the document is not an image so I'm able to extract the text using tools such as pdfbox. When I have the text I have no way of knowing what cells in the table it belongs to because I don't know where the tab...

Hibernate - link table with additional columns - saving in one transaction

Hi, I am learning Hibernate and just read the chapter "7.2.3 Adding columns to join tables" of the "Java Persistance with Hibernate" book. My goal is to save Item, Category and CategorizedItem in one transaction. There is a constructor there (page 305): public CategorizedItem(String username, Category category, Item item) { // Set...

Jquery + Dynamically filter table data

Hi, I have a table developed using jtemplates. The table has 5 columns. Lets say C1....C5. I need to have a filter below each header which can filter the table data. There are a lot of plugins to do this and currently I am using PicNet table filter : http://www.picnet.com.au/picnet_table_filter.html The trouble is, that whenever the u...

Outlook 2010 displaying inconsistent spacing between table cells

Hi guys, I'm designing an HTML Newsletter and I've run into this problem: As you can see, the cellspacing is completely out of whack: there shouldn't (and CAN'T) be a space between the rows on the left and right column. I don't really know what the culprit could be, any ideas would be appreciated! Here's the relevant source code: <t...

Latex column alignment

I have a latex document that is part of an automated system. So I cannot use fixed widths for the table as the inputs are uncertain. \begin{tabular}[t]{|l|@{\hfill}r@{ }|c|@{ }l|} \textbf{\langComponent} & \multicolumn{3}{c}{ \textbf{\shortstack{\leftresultsheader}} } \DTLforeach{resultstableA}{\colA=componentA,\colB=amountfracA,\colC=...

How to let text adapt to a set table width instead of stretching the table?

Hi, I thought that this would make a table with a set width, and that text would automatically try to fit in by starting on a new line. However, the table still gets stretched by long lines of text. <HTML><center><table width="300" border="1"><tr><td> <?php If (file_exists("file.txt")){ Echo nl2br(file_get_contents("file.txt")); }E...

UNIQUE Constraint in SQLite

Hi, Can some one please help me with this problem.To save the values in my iphone app, I am using SQLite3. I have many duplicate values in my database. So, to eliminate that I am planning to write some unique constraint on the table. My constraint should be such a way that a contact whose firstname,lastname and email are same, I want to ...

Formatting UITableView Cells in iphone

Hi All, I am developing an iphone app. In the image below I want the first name to be in plain font and the last name to be bold.. How can I do that?? please suggest me..Please check this image Another ques..Now I think the reverse way but the problem here is the first line and second line you see are part of the same string. I want th...

why do some tables in Lua display differently when print(sometable) is called on them?

I'm confused by behavior I'm seeing when I use luaxml to parse an xml string. The lua doc states that calling print() on a table variable as such: print(type(t)) print(t) will result in output like this: t2: table t2: table: 0095CB98 However, when I use luaxml as such: require "luaxml" s = "<a> <first> 1st </fi...

asp.net mvc c# - methods to create a navigation for table with many entries

Hello all, I have follow problem: in my table into View i have more than 50 entries(rows). I want to show just a 8 entries pro time, and above the table make some kind of navigation (like 1 2 3 4 5 ..) and if i need to see next 8 entries I#m clicking on the number 2, i see them. I dont know how can i do all this. has somebody any idea? ...

HTML - Enable Scrolling within a Tables Cell

lets say i have a table cell with fixed width and height.... and i have data that exceeds the cell's fixed dimensions... <td width="500" height="300">lots of data that exceeds the dimensions</td> can i enable scrolling of this data within a cell.... if not than what is the solution.. i only have that 500 x 300 space ...

Table too big in MySQL database

Hi. I am making an online game and one table in my database. The most important one maybe. It's starting to become very large. I am creating a function where you can go together with multiple users and for that I have a table that look like this so far: CREATE TABLE `oc` ( `id` int(11) NOT NULL auto_increment, `leader` varchar(40) N...

How to update table1 with content from table2 with php and mysql

I have two tables in my database, table1 and table2. They are identical. But sometimes i change the data in table1. How do i copy the data from table1 and update table2 to look the same? I tried "REPLACE INTO table2 SELECT * FROM table1" but it works like INSERT and just make new rows instead of updating the existing ones. ...

Use of NSDate to get dates

I have attempted this is many ways but failed consistently, hopefully you guys can help me achieve the what i want to do. I am making an iPad app, I will have five tables in a single view and each table will have a date as a header/title in this format, e.g. Monday 20 These five tables will be monday to friday. This is the bit I cant d...

SQLAlchemy duplicate table, rename table?

All, This is a snippet from internet repersent the database table will be used: >>> from sqlalchemy import Table,Column,Integer,String,MetaData,ForeignKey >>> metadata=MetaData() >>> users_table=Table('users',metadata, Column('id',Integer,primary_key=True), Column('name',String), Column('fullname',String),...

Very slow function, is there a faster way? (using jQuery 1.4.2)

The following function needs at least 3 seconds to run (on 500 table rows). Is it possible to make this function faster? function prepareTable() { var groupIndex = 0; $("#row tbody tr").each(function(index) { // each row gets a unique id // remove default css styles for table rows // read out hidden value, that store...

how to insert same data into two tables in mysql

dear all. is this possible if i want to insert some data into two tables simultanously? but at table2 i'm just insert selected item, not like table1 which insert all data. This the separate query: $sql = "INSERT INTO table1(model, serial, date, time, qty) VALUES ('star', '0001', '2010-08-23', '13:49:02', '10')"; $sql2 = "INSERT INTO...

Get header/caption centered above 2-column table.

Hi there. I've temporarily inherited the responsibility to look after the website front end to our project as our web guy has just left and there isn't a replacement yet (and I'm a summer student anyway, so I'm off soon too...). I'm not very experienced with HTML/CSS/etc, and I'm having some problems getting a table formatted the way the...