table

How to display table in COBOL's SCREEN SECTION?

Hey everyone, For learning purposes I am trying the following: I am trying to display a table via COBOL ... I want to define the way it is all displayed in the SCREEN SECTION. Following happens or is supposed to happen - all without multiple screens opening: (1) User enters ENTRY-SCREEN (2) User has to type in a password (nothing hap...

How might I add and remove table rows whilst maintaining sequential element IDs?

I am developing the back end of a CMS that I have been working on. I have a HTML table that I want the user to be able to add and remove rows from. Each row will contain various user inputs (textboxes, checkboxes..). Then when the users has finished it will be saved in the database. I am wondering what the best way to approach it is. ...

Add non-nullable columns to an existing table in sql server?

I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can i do that without loosing any existing data? NOTE: The new columns are not null fields. ...

latex: how do I change the font size of a table column?

I have a LaTeX table and would like the third column to be a different font size (smaller) than the others. I've always done this with a special-purpose macro that takes a parameter for each column and executes a font change for one of the columns. Is there an easier way to do this? ...

mysql is handling one sql query at the time?

if you got 100 000 users, is mysql executing one sql query at the time? cause in my php code i check if a certain row exists. if it doesn't it creates one. if it does, it just update the row counter. it crossed my mind that perhaps 100 users are checking if the row exists at the same time, and when it doesn't they all create one row ea...

When to split up models into multiple database tables?

I'm working with Ruby on Rails, but this question I think is broader than that and applies to database design generally. When is it a good idea to split a single model up into multiple tables? For example, assume I have a User model, and the number of fields in the model is really starting to add up. For example, the User can enter hi...

Prioritizing table columns in HTML

Is there a way to prioritize one table column in HTML? The thing is, I've got 4 columns, and the content may change a lot for the content in all cells. But I want the first column to take up as much space as possible, so the 3 other columns only use as much width as they need to keep everything on one line. The table itself has a fixed ...

Multiple unique counters in a table

Hi all, I have a problem where I need to keep and increment an object number field in a table, however this number should be unique within given logical domain, not across table globally. An example would be multiple Businesses scheduling multiple Jobs; Job.Number should be unique within a business. So I basically need to make sure t...

Google fusion tables api url encoding

This example code and more specific the runUpdate(String updateQuery) function is not working with non-english characters in the updateQuery. After the execution of this query i see in my fusion tables question marks where non-english chars should be. Any ideas? Thank you ...

Are tables in HTML supposed to be bad? Why is there so much talk about tableless CSS?

Possible Duplicate: Why not use tables for layout in HTML? I have read a lot about "tableless CSS", using CSS to format a page rather than tables. Are tables considered bad? I would think them especially useful for formatting form data (labels and input fields in rows) to maintain a neat look by correctly lining up the input f...

How to backup and restore records in database (Oracle 10)

I have a table in Oracle for users. I am going to install new schema and want to backup all users with passwords and other fields. I tried exp and int utilities, but imp doesn't recover anything. I created temporary user in USERS table. Then I did backup with command: exp user_owner/password file=file.dmp table=USERS rows=yes indexes=n...

Joomla 1.5 - how to create a table in a component's view's template?

I'm trying to create a Joomla component that displays the contents of a database table as a table on-screen. In the com_<name>/views/<name>/view.html.php file, what is the best way to create an HTML table that looks like a standard Joomla table? Do I create the HTML table manually and decorate it with some CSS classes, or is there a stan...

List all tables in postgresql information_schema

What is the best way to list all of the tables within PostgreSQL's information_schema? To clarify: I am working with an empty DB (I have not added any of my own tables), but I want to see every table in the information_schema structure. ...

How do I increase the width of a column in an HTML table?

Hi, How do I increase the width of a column in an HTML table? Below is my code. I am trying to get the second <td> tag in each row to expand so that there is more space between the input text box (1st <td> tag) and the name of the cookie and it's price (3rd <td> tag). Any ideas? Thanks! <!--Order Info. table -nested table 2 --> <!--Th...

How do I set a fixed amount of space for a cell in an HTML table?

Hi, I am trying to figure out how to get my text to not wrap when the browser window is maximized to a 24 inch monitor and minimized to a more regular size. I think if I set a fixed number of space for a cell within an HTML table that this will help but I don't know how...any ideas? My monitor is 24 inches and so minimizing it to a norma...

How do I view/set the transient message status bar in Firefox and Chrome?

Hi, I added a new transient status bar message to my HTML document (specifically the 5 links listed in the table, see code below) and it worked fine in IE but when I viewed the document in Firefox or Chrome the message did not appear. All that I saw was the URL link. Can someone show me how I can get the transient status bar message to s...

Cannot find table details in mysql information_schema

Hi, I am working on an assignment where I am supposed to find all of the tables in information_schema of a "blank" database. I can do this in either MySQL or PostgreSQL. I chose MySQL. So, I have identified all of the tables: CHARACTER_SETS COLLATIONS COLLATION_CHARACTER_SET_APPLICABILITY COLUMNS COLUMN_PRIVILEGES INDEX_STATISTICS KEY...

how to remove unwanted space between rows and columns in table

how do I remove the extra space between the rows and columns in the table. I've tried changing the margin, padding, and various border properties on the table and tr and td. I want the pictures to all be right next to each other to look like one big image. how should I fix this? style.css table { border-collapse:collapse; } i...

jquery parameters

I have a little problem, here, I'm reading data from a database, adding it to a table to be displayed on a webpage. The table in which this data is added lies inside a panel. To view this table, I would then use this javascript to expand the panel: <script type="text/javascript"> $(document).ready(function(){ $(".flip").click(functio...

How to check if a table contains an element in Lua ?

Is there a method for checking if a table contains a value ? I have my own (naive) function, but I was wondering if something "official" exists for that ? Or something more efficient... function table.contains(table, element) for _, value in pairs(table) do if value == element then return true end end return false en...