I am having a tough time with this design problem and would appreciate any insight. i have a doctors office that is provided certain privileges currently there are only 5 privileges but more could be added. Each of these privileges has a status of Yes or No, but there could be a finer grained status in the future and each of these privi...
Suppose I have a table and an index on it original simple table A ------------------------ rowid | id name 123 | 1 A 124 | 4 G 125 | 2 R 126 | 3 P index on A.id ------------- id rowid 1 123 2 125 3 126 4 124 At this point, I execute this DML statement UPDATE A SET id = 5 WHERE id = 4 What e...
Using only an XPath expression (and not in XSLT or DOM - just pure XPath), I'm trying to create a relative path from the current node (in a td) to an associated td in the same column of the same HTML table. For example, suppose I have this type of data: <table> <tr> <td><a>Blue Jeans</a></td> <td><a>Shirt</a></td> </tr> <tr> <td><s...
I would like to be able to use the ASP.Net Repeater control to create an HTML Table that has three columns and as many rows as necc. For example if the Data were to look like this "Phil Hughes" "Andy Petite" "CC Sabathia" "AJ Burnett" "Javier Vazquez" I would like the resulting table to be like <table> <tr> <td>Phil Hughes</td...
I have a Repeater and also a Button. If I click on my button a new rows need to be created to the repeater in client side (javascript). I am able to do this with server side, but want to avoid a postback. I am not using an Ajax Updatepanel control. Moreover I am using a table structure in my Repeater. ...
Hi, I am trying to import data from a CSV file to a SQL Server 2008 table. Data upload is working, but I want to import only selected columns, not all, and add them to a a new table, of same no. of columns, using the wizard, but its not happening, the wizard is selecting all the columns. So is it possible using wizard that I only impor...
Is anybody knows how doesnt schemaupdate work with many-to-many e.g.: i have category and product entities with many-to-many on each one: how can i know when schemaupdate creates table: categoriesToProducts and when productsToCategories ps. i dont want to specify tableName in my mapping ...
Hey, I'm using the code: function insertV($deptx, $coursex, $secx, $isbnx,$titlex, $authorx,$usedpx,$newpx) { $sql = "INSERT INTO `$deptx` (`course`, `sec`, `isbn`, `title`, `author`, `usedp`, `newp`) VALUES ('$coursex','$secx','$isbnx','$titlex','$authorx','$usedpx','$newpx')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysq...
Hi, I have a table on my ASP.net page something like this: <table runat="server" id="resultsTable"></table> I dynamically add content to the table, and it works just fine. However, I want to get the HTML of the table once I've added the dynamic content, i.e. something like this (formatting isn't important, I've just added it) <table...
Can anyone tell me why the logo on this page is not centering in IE? http://www.cateringvisions.com Thanks! ...
Where can I find an implementation for a text/ascii table/grid generator? e.g. Given a CSV file such as this: Header1,Header2,Header3 Pizza,Artichoke dip,Bob's Special of the Day BLT,Ham on rye with the works, It would generate a nice looking text table such as this: Header1 Header2 Header3 --------------------------...
I need to re-sort a table when the input elements in cells change in value. I've already created custom sorters for my data, which works wonderfully, but now I need to re-sort when data changes. $('#id').tablesorter(...) almost does what I need, but it seems to apply ANOTHER set of sorting on a given table, which leads to really weird b...
Hi, I don't really know how to title my question, but I have a JSP page with a table displaying elements from a database, and I want to have a button for each row to either delete or edit that particular row. Here is the part of my JSP page where I generate the table (the table and buttons are generated fine) <style type="text/css"> ...
Hi, Following problem: I'm having a table with 3 columns and I'm using jQuery to set the column widths by code, like: var tr = $("tr",myTable).eq(0); var cells = $("td",tr); cells.eq(0).width(100); cells.eq(1).width(150); cells.eq(2).width(300); Works nice under Firefox, but IE8 acts very strange: The 2nd column shows up on screen w...
I have a table that I'm creating in iTextSharp and populating with data at runtime. The number of columns are variable and the text in them could be any size. When I create the table at the moment, the columns are the same size. However, some columns have wasted space and others have cramped content. I want the columns to automatically ...
This Oracle documentation page mentions ... columns of type LONG are created last but doesn't say why. What can the reason be to store them at the end of a row? ...
Hey Any Ideas how I can build the following query with the zend_db_table class? SELECT SUM(x) FROM traffic thanks ...
Is there some way to get a list of all the indexes on a particular table using SQL*Plus? I created a table CREATE TABLE temp( id NUMBER PRIMARY KEY, name VARCHAR2(20)); There should be an implicit index created on the primary key (id). How can I see that index? SELECT * FROM all_indexes WHERE table_name = 'temp'; gives no rows se...
i am trying to insert a row to a table with an identity column and three "normal" columns using entity framework in wpf. however i got this error message: Cannot insert explicit value for identity column in table 'MyTable' when IDENTITY_INSERT is set to OFF here is my code snippet, trying to add to the user table who has name, surname, a...
I have the following HTML. <body> <div class="header"></div> <div class="navdiv"></div> <div class="mainarea"> <p></p> <table> <tr> <th scope="row">Name</th> <th scope="row">Description</th> <th scope="row">Created</th> <th scope="row">Created By</th> <th scope="row">Modified</th> <th scope="row">Modified B...