Have a report generated from the DB, want to add an export button so they can get the same report in a excel readable sheet of some type. The key here is ease of implementation so a CSV is fine over XLS if it's easier. ...
Is it a good idea to convert complex views in "db1" into tables in "db2" using SSIS. the purpose of converting views to tables is to make the reports faster. Is there any disadvantages or risks? ...
I have a constant data flux. All data must be stored into the database with a timestamp. The data comes in a 5 minutes interval, and a select of the latest data is made in the same interval, in pseudo SQL code: SELECT * FROM TB_TABLE WHERE TIMESTAMP = MAX(TIMESTAMP) As this table grows really big (gigabytes), I did a premature optimiz...
Hi I am creating a report in LaTeX which invole a few tables. I'm stuck on that as my cell data in the table is exceeding the width of the page. Can I some how wrap the text so that it falls in to the next line in the same cell of the table? Is it some how related to the table's width but as its over shooting the page's width it won't...
I had created a multi choice column called "technology" on our shreapoint portal. Recently, by mistake I clicked on delete button while making changes to the column value and now I want to restore the system in the orignal form. I have recreated the column with all the options, the problem is that all the documents had the technology val...
I have an old compiled Access Application mde file. This appication has linked tables to network shared folder. I tried to upgrade main database using upsizing wizard on main database and everything went well. Then when the aplication starts it gives error message that 'microsoft jet database engine cannot find the input table or query ...
Is it possible to make a none table based layout that allows #bottom element to fill 100% of the remaining space left in the parent element without the use of JavaScript? Here is what works when using tables: <html> <head> <style> table{ height: 100%; width: 100%; } ...
I am developing a "modern" website, and I'm having a lot of trouble getting the CSS to make everything line up properly. I feel like they layout would be a lot easier if I just used a table, but I've been avoiding <table> tags, because I've been told that they are "old-fashioned" and not the right way to do things. Is it okay to use ta...
Hi Everyone, I currently have a table with three drop down lists above it. As the user selects a value from each drop down to filter the results I'd like the table to hide the rows that do not fit ALL of the criteria selected so far. The closest I have gotten is this: $("#ReportControls #InventoryReports select").change(function(){...
I'd like to have tables that can dynamically collapse some rows in a web page, such as: | Title | Foo | Bar | --------------------------------- | + My First Section | --------------------------------- | + My Second Section | --------------------------------- can dynamically exp...
I can't really think of the best way to phrase this question, so I'll just give an example. Suppose I have a table that is created like this: CREATE VIEW People AS SELECT id, --int name, --varchar(20) birthdate --datetime FROM SomeTable If I wanted to change this from a view to a physical table, is the...
Hello, I have a problem with javascript. I have a list of table cells stored at TabList. I want to find the maximum width, and then set this width to all of them. A sample code is here, but the setting of the width is not working. var MaxTabWidth = 0; for (var i = 0; i < TabList.length-1; i++) { if (TabList[i].offsetWidth>MaxTabWidt...
I have a table on an MS SQL 2005 server that was about 4gb in size. (about 17 million records) I changed one of the fields from datatype char(30) to char(60). (there are in total 25 fields most of which are char(10) so the amount of char space adds up to about 300) This caused the table to double in size (over 9gb) I then changed t...
Hi, I am using asp.net and i would like to define the elements of a dataset in my html code. The problem is when i attempt to use: <%@Using namespace="System.Data" %> this is giving me an error also I am using foreach (DataRow row in ds.Tables[0].Rows) {.....} DataSet ds is obtained from an sql query. I don't believe...
Hi Guys, first post... I have several pages to do with several table on each page. I've got the JQUERY to do zebra stripes on even lines and change colour on hover. but, here it comes, it changes colour on THEAD and TFOOT and i can't apply css to TFOOT to change colour. Thanks very much in advance.... here's the code <script type="te...
I'm building an intranet web app with an Oracle back end. The Oracle DB will be replicated on another server for reasons that aren't important to this discussion. I'm reasonably certain we'll be using Oracle Basic Replication, not Advanced. Can someone explain to me why most discussions around Primary Keys go something like: Use of ...
For a long time in the Java/JSP world I used to use the Display Tag library to generate a table that would allow you to sort a table, and export the table as a CSV file. Is there anything like this in a PHP library that I could use? ...
I have an AJAX application that downloads a JSON object and uses the data to add rows to an HTML <table> using Javascript DOM functions. It works perfectly... except in Internet Explorer. IE doesn't give any sort of error, and I've verified as best as I can that the code is being executed by the browser, but it simply has no effect. I cr...
Hi, I am using asp.net and i would like to create a table which allows the user to enter multiple rows. some of the rows are to be dropdownlists. I dont know how to do this :S can someone help me please? Thank you ...
I'm really concerned about the aesthetic aspect of my web app and that's why I'm asking this sort of a silly question. Forgive me in advance if you think it's not that much a big deal. I'm building a desktop like web app and using jqGrid awesome plugin to show some tabular data. In desktop applications like iTunes, the table has enough...