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...
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...
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 ...
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...
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"...
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...
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...
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...
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;">
...
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...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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 ...
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....