I have a macro to select a range of cells on the same row and then merge & left justify that selection. I would like to enhance it to allow me to select a range or block of rows and perform the same action on each row in the range. Does anyone have some sample code to do something like that? Thanks! Craig ...
I have a table of 5 rows and 3 columns. The first column has a hyperlink in it with a target=_new. I want things such that when I click any column in the same row, it fires that hyperlink and a new window opens up via the target=_new. Is this possible in Javascript or jQuery? I found I was able to access the href, at least, by doing this...
Hello! How can I make on a html page, 2 jqgrids, on same row, 1x left and 1x right ? on default came one on top, one bottom. Thanks ...
This code does following: Click on "Delete" in item row -> deletes item row Click on "Delete" in category row -> deletes category row and all item rows (in all table) Need it to do following: Click on "Delete" in item row -> delete item row (WORKS PERFECTLY) Click on "Delete" in category row -> delete category row and all items ins...
Hey guys, As the title says - I want my datagrid to only allow one single row as selected at the same time. I guess I can do this by adding code to the datagridviews selectionChanged-event, but is there a better solution? I would prefer to just have a property to set, I.E. : mydatagridview.maximumNrOfRowsSelected = 1; or something sim...
Hi all, I am working on PHP & mySQL based website. I am trying to setup the 'Settings' page in administration panel where I can enter different settings to manage the site. The settings can range upto 100 (or even more) depending upon the requirements. So instead of making 100 columns (and increase if I have to add more columns in future...
I'd like to change the appearance of a cell when the user tap the drag handle. I searched in the documentation, the forums and google, but I can't find a method or an event that say when the drag icon is pressed. Any help will be appreciated! Thanks ...
i am creating a stock portfolio. each row is a stock and it's data including profit/loss. each row has a groupid that the user can specify. the idea is i want to: 1) physically group the rows based on the groupid 2) after step #1 i want to dynamically add a row below that group with the subtotal of the profit/losses for that group on...
hi all, i'm creating a simple project to try gwt, but i'm a real noob :) i've a table in my db, each row in this table has a unique id. i want my application to read this table and display it's contents in a flextable, omitting the column containing the unique id in the db, 'cause the user is not interested in that id. after that, i want...
I am trying to implement a rating system where I keep the following two fields in my db table: rating (the current rating) num_rates (the number of ratings submitted so far) UPDATE mytable SET rating=((rating*num_rates)+$theRating)/num_rates, num_rates=num_rates+1 WHERE uniqueCol='$uniqueCol' the variables are from my PHP code. So, b...
I’m creating revision control for data in our database. It will have the ability to store revisions, rollback, and rollback rollbacks. The database tables I’m using that needs to be revisioned is below: objects object_chunks object_attributes Objects is the main object, chunks are grouped up sections of the object, and attributes are a...
I am creating a new query from an old query and I'm getting duplicate rows in my result. I have absolutely no idea why this is happening? Here is the old SQL codes which does not produce duplicates: XtraViwStock SELECT TOP 100 PERCENT dbo.qexp_detail.in_date AS inDate, RTRIM(dbo.qexp_detail.stock_locn) AS stockLocn, { fn LCASE(RTR...
I have two tables in a SQL Reporting Services report (table + matrix) that I would like to display side by side to give the illusion of one complete table. The problem is that there may be more data in the row of one table vs the other and therefore the rows could be different heights. Is there any way to match/link the heights of the...
How to Add a new row to a DATAGRIDVIEW in ASP.NET....using c# Code ??? ...
I have a Mysql table with a single primary key (called pkey) that auto increments, and I would like to clone one row, keeping all the data the same, except for the primary key which should become the next available value as defined by auto increment. My first question is, is the following query possible? UPDATE `table` SET pkey='next_a...
I've created a UITableViewController which calculates the height for each row depending on the amount of text it contains. The code to calculate the row height looks like this: - (CGFloat)tableView:(UITableView*)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath { CGSize constraint = CGSizeMake(CELL_CONTENT_WIDTH - (CELL_CON...
Is it possible to fix the height of a row (tr) on a table? The problem appears when I shrink the window of the browser, some rows start playing arround, and I can not fix the height of the row. I tried several ways: tr width="20" / tr style="height:20px" / td height="20" / td style="height:20px" I am using IE7 Thanks in advance. S...
I've been using grids to hold my controls for a new app. Such as; <Grid Margin="5"> <Grid.RowDefinitions> <RowDefinition Height="Auto" /> <RowDefinition Height="Auto" /> </Grid.RowDefinitions> <Grid.ColumnDefinitions> <ColumnDefinition Width="150" /> <ColumnDefinit...
i know there are many tangential posts on this topic (I've read them all) but i can't seem to put it all together. I would like to highlight all rows whose 2nd column contains the '-' character. in case its relevant: 1) the second column's header (th) is "Due In" 2) the values in the second column are strings 3) there isn't a specific...
Hi all, I'm working on a spreadsheet to act as a master copy for some important information that will be kept track of for a project. On the main sheet I have a table for notes and a table for contacts set up seperated by several columns and some VB code to insert new notes or new contacts. However, when I insert a new note I want it to...