table

Obfuscate database table names

We're about to undergo a project where we'll be handling highly sensitive data. Apart from encrypting the data I was thinking about obfuscating the table names. So tEmployees would become t58633B7A for example. Would this be a useful to add? after all it's about building layers of security/prevention. P.S. We'll map the obfuscated tabl...

css not working in table "td" , but it works for "th"....what's going on?

I've been coding a webapp for some time now and all the layout, css was working fine. Some time in the last week or so I made some kind of a change that I absolutely have no idea what I changed that is causing this problem and I've tried reversing the code with no luck. I have figured out however that the problem goes away if I use a <...

Why doesn't CSS hover work on table rows when the cells inside the rows have class names?

Hi, i am kind of stuck with this problem so any help would be appreciated. I have a table with several rows. each cell within the row belongs to a certain class. I use these class names to colour the cells. Here is one example row from my table: <tr> <td class = "summarypage-odd-column">Theme</td> <td class = "summarypage-odd-c...

HOW TO SERACH for string IN two mysql TABLES WITHOUT fulltext indexes

hi i have this query to searching for some string in two tables(download , news) and return column called title from that record. but there is something wrong with the code . its just showing result from second table in the code . and if i change tables place in the code again i'm getting result from second table ! $sql="SELECT downl...

can we implement a php extract function in php with out using zend api

Extract function of php adds variables to the local scope of the calling function. How can we write our own php function extract which does the same? ...

HTML Tables - Cell Spanning

If I have a table whose column count cannot be determined during the creation of the table, and whose rows may sometimes not contain enough data to fill each column, is there a way to have the last cell in each row auto-size? I would prefer to not have to use colspan on the last cell in each row, because again, the max number of columns...

Persistence of checkbox data from 5-page html table display

I'm a PHP learner. I am pulling rows from a db and displaying them in a very simple HTML table. Each row begins with a checkbox. There are 20 records on each page, and there are 5 pages. Every time I go to the "next page", the values in the $cVarString below are vacated. No page-to-page persistence. If I choose 10 rows on one page ...

help with normalization of mysql database

on my website a user can post comments and group these into categories. eg. category: good quotes links: "some quote 1", "some quote 2", and so on. so the nr of categories and comments are determined by the users. im thinking how i should organize this in the mysql database. i cant have one table for each category because there wo...

Decimal points in sqlite table?

I'm trying to get a float to show up with the decimal point in my sqlite table. I've included the code below for how it shoes up in the game which is all fine. As well as for what happens at the end of a level. And how it gets updated to the sqlite table. It shoes up fine as a decimal during the game, but it gets recorded to the tabl...

Table Overflowing Outside of Div

I'm trying to stop a table that has width explicatly declared not to overflow outside of it's parent div. I presume I can do this in some way using ‘max-width‘, but I can't seem to get this working. The following code (with a very small window) will cause this: <style type="text/css"> #middlecol { width: 45%; border-right:2p...

MAke New Table in SQL with same Schema

I have a table called W_US and i want to create W_UK in oracle with same schema as for W_US. ...

Java Problem implementing clone, generic class.

I have a class that implements a 2Dtable. The elements in the table is generic. And the table is stored like this: public Object[][] list; The problem is that calling clone on this apparently doesn't work. Note that my testcase initializes the table to store normal Integers. Tabell2D<Integer> en = new Tabell2D<Integer>(5,5); ...

Getting a JTable with a custom table model to show up in JScrollPane

Hello. I am attempting to create my own custom TableModel for my JTable (because I would like to incorporate a row of JCheckBox's into my table.) I have the JTable in a JScrollPane as well. Before I attempted to incorporate the JCheckBox and custom AbstractTableModel, the JTable would show up fine if I used the default (Object[][], Ob...

how to find out my result table in multiple table search?

hi i'm searching in two tables for a string . $sql="SELECT download.title FROM download WHERE download.title LIKE '%$search%' UNION SELECT news.title FROM news WHERE news.title LIKE '%$search%' OR news.text LIKE '%$search%' "; how can i find out what table the records I have found are from? ...

How do I remove the space between table data in a table row in HTML?

Hi, I am trying to figure out how to remove the extra space between table data(s) in a table row in HTML. For example in the code below there is extra space between 'First Name' table data and the 'input name' table data when the code is viewed in my web browser IE. Here's the example: <tr> <td>First Name:</td> <td><input name="fnam...

NSTableView Drop Focus Color

Hi, I have a table view and when I drop something on it, I get a blue focus inside it. Now, iTunes has the same behavior but in iTunes the color of the line is a lighter blue and the line is thicker. I have added a picture to explain it better. I want to achieve the same thing but I don't know why. The Image: http://img502.imageshack.u...

how do i plus one in a table column?

i've got a mysql table column that acts as a counter (int). each time i update that column i want the field value to get plussed with 1. so if it was 45 i want it to be 46. how could i do that with sql? ...

get the latest inserted id in a trigger?

i use a trigger to insert a row and want to use the last created id for using in the subsequent query. how could i do this? the code looks like: BEGIN IF (NEW.counter >= 100) THEN INSERT INTO tagCategories (name, counter) VALUES ('unnamed', NEW.counter); // here i want to have access to the above inserted id UPDATE tagCategories2tagPa...

how to check if a table row exist with a trigger?

i want to check if a table row exist with a trigger. if it does then it does nothing, but if it doesnt exist it inserts a row. here is my current code i want to modify. BEGIN IF (NEW.counter >= 100) THEN // check if a certain row exists in another table, if not, execute the beneath code INSERT INTO tagCategories (name, counter) VALUES ...

Optimizing A Small Table Of Data For The Best Search (Querry) Speed

I have a table with 4 colums and N rows. At the beginning N will be around 1000 and will have tendency to grow up to 3000. 1st: string unique 2nd: int with N/5 unique values 3rd: int with 5 unique values 4th: data value The objective is to get to the value of the 4th column with different queries, ex: "get the value, where the 1st co...