Multiple Base Table View
how can insert data into a multiple base table view without using a stored procedure ...
table
Oracle refuses to use index
I have a partitioned table like so: create table demo ( ID NUMBER(22) not null, TS TIMESTAMP not null, KEY VARCHAR2(5) not null, ...lots more columns... ) The partition is on the TS column (one partition per year). Since I search a lot via the timestamp, I created a combined index: create index demo.x1 on demo (ts, k...
Identifying all rows within a table <tbody> element using jQuery
I am trying to retrieve all rows from within a <tbody> section of a table, but am unsure of the syntax for doing so. I've included a dummy table extract below and my latest attempt for achieving the task with jQuery! Table extract: <tbody> <tr> <th id="emergency" colspan="2">Emergency</th> </tr> <tr> <td>Emergency data</t...
Most Efficient way of Filtering an Html Table?
I have an ajax function which call a servlet to get list of products from various webservices, the number of products can go upto 100,000. i need to show this list in a html table. I am trying to provide users an interface to filter this list based on several criteria. Currently i am using a simple jquery plugin to achieve this, but i f...
jQuery Table Plugin with Group By
I need a jQuery Plugin that makes a Sortable and Groupable List of my Data. My Data is a Tasklist with a duedate, and i would like to have them grouped by date, and sortable. Is there a plugin that can handle that? I'm actually using dataTables, but it has some strange behavoir and bugs... Like: 16-10-2009 - Task 1 - Task 2 17-10-2009 ...
How to Open a CSV or XLS with Jet OLEDB and attain Table Lock?
I am trying to figure out how to read/write lock a CSV or XLS file when I read it as a Database via Jet OLEDB. The following code will open a CSV as a DB and load it into a DataTable object: private DataTable OpenCSVasDB(string fullFileName) { string file = Path.GetFileName(fullFileName); string di...
YUI Datatable Width
This may seem like a basic question, but I'm having trouble figuring out how to set the table width to 100% on a YUI datatable. I tried doing #dtContainer { width: 100%; } #dtContainer table { width: 100% } but none of these approaches work. To clarify, I am trying to set the datatable width to 100% when the table is empty ...
Prevent Duplicate Borders on Nested Table (border-collapse not working)
I have been searching the net about border-collapse. And it seems it does not really collapse the border on nested table. I wrote a sample HTML and it seems to be ignoring border collapse. I found a related question here but it seems it is not solved. link text <html> <head> </head> <body> <p>dsafhidsljfalkdsjfklsdajfkjsdakl jdsfjasd...
Incorrect table rendering
<table width="300" height=100 cellspacing="1" cellpadding="2" border="1"> <tbody> <tr> <td width="150" colspan="2" ></td> <td width="75" colspan="1" ></td> </tr> <tr> <td width="75" colspan="1"></td> <td width="150" colspan="2"></td> </tr> <tr> <td width="75" colspan="1" ></td> <td width="150" colspan="2" >...
<table> vs <div> (yet again)
I generally agree with the idea that web site layouts should be done with <div>s instead of <table>s. However, I have a situation where this does not work - or at least, I have not found any solution. I have a dynamic site where many customers share the same template (they can pick one from a set of available templates). A template defi...
Adding a row to a table dynamically
$(document).ready(function(){ var refreshId = setInterval(function() { periodicRefresh(); }, 9000); }) . function periodicRefresh() { $.ajax({ type: 'GET', url: 'include/ajaxActions.php', data: "action=displayLastEvent", success: function(msg){ var newid = $(msg).attr("id"); ...
Switching from tables to divs with CSS
I have an HTML table in my page that I'm trying to replace with divs and CSS. Basically, it's a 3x3 table with scalable content in the middle and fixed sized edges and corners with images in the background to give everything a nice drop-shadowed look. I've read many articles and entries on mixing %'s with pixels, but none of them seem ...
How to select div in table cell using jQuery
I have the following table structure; <tr> <th><label for="ctl00_bodyContent_username">username:</label></th> <td class="field"><input name="ctl00$bodyContent$username" type="text" id="ctl00_bodyContent_username" /></td> <td class="info"> <div class="message...
Using Jeditable and activating on click
I found this to be almost exactly what I'm trying to do. I'm using Jeditable I can get the default setup to work. I've also been able to get the code in the forum above to work. I believe my problem is that because I'm using a table I need to so something else to select the previous element. Here is my HTML <table> <tr> <t...
SQL Joining tables based on a list of names
Hi, I'm looking for a way to join a series of SQL tables based on a list of table names. The list of table names can change as the system grows but I need to make sure the join operates on all the tables as they grow. Each table in the list will have a common column called ActivityID which is a foreign key back to the Activity table wh...
Scrolling Cell in a 100% height TABLE
I'm sorry if this was already answered, but it's kind of difficult to search for something with "100% height". My problem is that I need 100% height table layout because of automatic cell resizing done by browser, which I don't want to script myself for obvious reasons. It differs from other "100% problems", in that I need some cells t...
Asp.net dynamic table content is removed when saved in Viewstate
Set content of table ... ViewState["Table1"] = Table1; // When remove this line, table is seen on the page. ... What should I do, urgent please. ...
Synchronizing between SQL Server and CSV file
What is the better way to synchronize a table (customers), inside SQL Server and the curtomers inside an CSV file in Microsoft Excel? Ok, here is the explanation: I am developing a software in C#.NET 2008, and I create a table named Customers in SQL Server 2005. The contents of this table comes from a csv file and the user can add more ...
SQL: deleting tables with prefix
Hello, i know how to delete my tables in MySQL, DROP TABLE but now i need to know how to delete my tables who all have the prefix myprefix_ How to? --I NEED TO DO THIS IN PHPMYADMIN, IN A BROWSER. NO TERMINAL STUFF PLEASE. BATCH STUFF IS ALWAYS APRECIATED.-- ...
How to pre-populate a summed field in an Infopath repeating table
I have an Infopath 2007 form with several views, meant to be used in a browser. I'm having trouble pre-populating a field in a repeating table, starting with a given value and then using a formula-derived default value. On the Summary view, I ask for a project's TotalCost and the current fiscal year's projected spending (CurrentFYSpend)...