table

Facebook database design?

I have always wondered how Facebook designed the friend <-> user relation. I figure the user table is something like this: user_email PK user_id PK password I figure the table with user's data (sex, age etc connected via user email I would assume). How does it connect all the friends to this user? Something like this? user_id...

Cannot insert into table because the table already exists?

I have a user table. I want to insert data into my user table. I have a statement: SELECT columna, columnb, INTO my_table FROM my_other_table WHERE (... conditions ...) I get the following error: SQL Server Error on (myserver) Error:2714 at Line:1 Message:There is already an object named 'my_table' in the database. Yes, thanks S...

HTML, CSS, Javascript - Problem with hiding/showing elements

I'm using the Blueprint CSS grid for my HTML page. I have a table which I want to show/hide - linking it to a button, using jQuery. The problem is that everytime I click on the button to show/hide the table, everything on the page shifts slightly left-right. Is this a common problem? Does anyone know what could be causing this and what ...

Table rows with two lines of text

Hi, I have two tables side by side. I need the rows to line up, but sometimes the content can be longer than the table row due to width constrictions on the page and it breaks and makes a two line table row. Is it possible to make something like double rows that can hold two lines of text so everything lines up no matter if the conte...

CSS: How to render div as 100% of parent not child

Hey all, I am trying to create a scollable panel within a table cell. What I would like is for the div to be as wide as the table cell and then render scrollbars for the content. When I try the following the div sets its width to 100% of the contained span tag not the cell <table cellpadding="3" width="90%" align="center" border="0"...

finding text in a table with jQuery

I have a table that has rows like this: <tr id="" class="objectRow"> <td class="bulkSelector"><input id="" type="checkbox" value=""/></td> <td class="favorite"></td> <td class="name"><a id="" class="" href="">Ut Urna Nisl</a></td> <td class="description"><p>Nam feugiat tincidunt massa nec venenatis. Mauris egestas consectetur ma...

Which data type to use for ordinal?

Whenever I have some records/objects that I want to be in a certain order, I usually create a field called Ordinal. I often wonder if it would be better to use an integer or a decimal value for the ordinal field. This is a consideration when moving an object to a different position in the order: If you use consecutive integers, you h...

CSS: How to set table column width for dynamic drop down list

Hey, I have a table with a dynamic drop down list. The width of the drop down will change depending on its content. I would like the table column to be the same as the width of the drop down. If I set a width less than the size of the dropdown IE seems make the column bigger than the drop down whilst wrapping the column title it inse...

Make TBODY scrollable in Webkit browsers

I'm aware of this question, but none of the answers work in Safari, Chrome, etc. The accepted strategy (as demonstrated here) is to set the tbody height and overflow properties like so: <table> <thead> <tr><th>This is the header and doesn't scroll</th></tr> </thead> <tbody style="height:100px; overflow:auto;"> ...

jquery tablerow click function question

Hi, I have a function that allows users to edit a row in a table by opening the data in a modal. Right now the whole row will fire the modal. What I want is to isolate the last td that contains a link that fires a function that readies the data for processing. What happens is that when that last td is clicked the modal opens AND the r...

what is wrong with my create table SQL?

Hello everyone, I am using SQL Server 2008 management studio to execute the following SQL statements, and here is the related error message from SQL Server management studio. Any ideas what is wrong? SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create TABLE [dbo].[BatchStatus]( [BatchID] [uniqueidentifier] NOT NULL CONSTRAINT...

Stop table from going longer in HTML

I have the following tables. I wanted it so when I make more boxes table. If there is no more room on in the table go below the other ones and to keep making the table long. <table width="417" border="1" cellspacing="0" cellpadding="0"> <tr> <td width="413" height="179"> <table width="141" border="1" align="left" cellpadding...

How to get store type of an entity set

Hello, I'm trying to filter entities based on their store types (either table or view). I have 2 entities in my test project, one's source is a table and the other's source is a view. <EntitySet Name="Test" EntityType="TestModel.Store.Test" store:Type="Tables" Schema="dbo" /> <EntitySet Name="TestView" EntityType="TestModel.Store.Test...

What's The Best Way To Sync 2 Data Structures in PHP?

So I am trying to Sync a bunch of Videos I've retrieved from a particular user from Youtube to a database table of Video Ids. This is because YouTube does not allow the adding of meta information to a video. Hence I've created a video table on my server and would like to sync up videoids. i.e. php/mysql app <-> youtube The datastructu...

HTML table headers always visible at top of window when viewing a large table

I would like to be able to "tweak" an HTML table's presentation to add a single feature: when scrolling down through the page so that the table is on the screen but the header rows are off-screen, I would like the headers to remain visible at the top of the viewing area. This would be conceptually like the "freeze panes" feature in Exce...

Issues with pagination and sorting

Hi, I'm looking into situations in database-oriented web applications when one should rely on client side sorting of tables over sorting on the server side. One particular situation that is bugging me is pagination. When trying to paginate a large table (say 10000 rows), as well as sort it by a particular column, what would be the best...

Should one steer clear of adding yet another field to a larger MySQL table?

I have a MySQL-InnoDB table with 350,000+ rows, containing a couple of things like id, otherId, shortTitle and so on. Now I'm in need of a Bool/ Bit field for perhaps a couple of hundreds or thousands of those rows. Should I just add that bool field into the table, or should I best create a new table referencing the IDs of the old table ...

How to suppress the display of repeating values in html tables which can be sorted?

I have a table in HTML which I am generating from XML/XSL and I want it to suppress repeating values. However, I also want to sort it on the fly by clicking the titles. Without a round trip to the server I need to suppress different values after each sort. Is there a good javascript/css solution. For example Data Date Person Score ...

HTML Layout, ASP.Net, Browser Difference.....there had to be a better way

OK first of all let me say i'm not much of a design guy. Most of the work i do is usually on the backend/infrastructure (WCF,DB,Buisness Objects). We don't have a formal web designer unless you consider someone with a communication major who uses frontpage type programs to design web pages a web designer. I know basic HTML of course but ...

How to align button centered below table?

Hi, I put form elements in a table so that column names and inputs are aligned to 2-columns. And I put submit button and cancel button below the table. The table width is not fixed. I want to put the buttons center-aligned of the table width. One simple way is to put the buttons in the table. But I want to separate them from the table....