Group, I have a report that has row groups for customer MembershipLength (1 year account, 2 year account, etc.) then a sub group of rows for customer Status (active, inactive, etc.) Then I have columns for customer types. Ultimately I want to add a column that will calcualate the percentage of the subtoatl for the corresponding custome...
Hi all, I'm using (have to) a badly designed Oracle(10) DB, for which I don't have admin rights (although I can create tables, triggers, etc in my scheme). Now I had run into a problem: this DB connected with several users/programs. I must find out who updates a certain row, when, and if possible: with what kind of statement. Is it pos...
I want to use data caching on my .net C# application. So far I added data caching and added sql cache dependencies on specific tables. But thats not good enough. These tables will be updated too frequently but not relevant to a lot of the cached objects. This will make the data caching almost useless because it will be flushed to frequen...
Is there any way to do it? ...
Hello Can anyone tell me which is he better appraoch in MySQL whin it comes to finding the row count of a table: is it better to do SELECT COUNT(*) FROM TABLE_NAME or to look up the row count in the table TABLE in the INFORMATION_SCHEMA? This would be a frequent operation for calculating pagination counts for pages? I should add t...
HTML.. <div class="row"> <div> <b>Title A</b> <a href="#">Link 1</a> <a href="#">Link 2</a> </div> Content A </div> <div class="row"> <div> <b>Title B</b> <a href="#">Link 1</a> <a href="#">Link 2</a> </div> Content B </div> <div class="row"> <div> <b>Title C</b> <a href="#">Link 1</a> <a href="#">...
Hello, I am creating my rows dynamically when the user clicks on "Ajouter". <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <scri...
I want to implement asp.net ajax animation (row color fades/changes from red back to white when a linkbutton is clicked) on a gridview row, and I want to do it in the code behind in c# (in the linkbutton_click event). Is this possible? ...
Hi y'all, Using SQLite I need to copy nearly all of an existing row from a table, make a change to a single column, and insert the new row into the table. Something roughly like INSERT INTO $tablename (c1, c2, ... , cn) SELECT (c1, c2, ... , cn) FROM $tablenam I tried substituting a some value ci into the the list of SELECT colu...
Hello! I have a datagridview made up of multiple rows and columns. I want to iterate through each row and check the contents of a specific column. If that column contains the word "NO", I want to change the forecolor of the entire row to Red. Here is an attempt at some code so far but It's certainly not working, starting to wonder If I ...
Hi, I am trying to implement the following : 1> First column of datagrid has a checkbox. 2> Select checkboxes, and then delete the datagrid column. 3> Dynamically, add checkbox when row is added dynamically. 4> Do not show check box if now data in row. Can someone give some guidance ? ...
Hi, I have a datagrid. I add a row to the datagrid using an ADD button. Once I add, I sort the datagrid based on a column. I also provide the serial numbers i.e. row numbers as first column to the datagrid. But, the serial number function does not apply after sorting. Hence, a new row added for e.g. row 5, based on sorting should be row...
Hi All My PHP script generates a table with rows which can optionaly be edited or deleted. There is also a possibilety to create a new Row. I am having a hard time to figure out how to update the HTML rows which are generated through PHP and inserted via jQuery. After the update it must be still editable. The HTML is generated into a d...
i have a table with thousands of rows. there are no ids and so on. within the tds of the rows i have a link calling a fucntion and passing "this" to get the link object. using jquery it is easy to get the the closest tr and table (and so the tables.rows.length) i want to know as easy in wich row i'am?! ok i could do a loop but does e...
How do I count the number of tr elements within a table using jquery. Sorry, I sense this might be basic but i've been banging my head against it. I know there is a similar thread, but I just want the total rows. http://stackoverflow.com/questions/613024/count-number-of-table-rows-between-two-specific-rows-with-jquery ...
Hi, I'm having trouble with a table cell not spanning correctly. I'm using jQuery to show/hide a row of a table which contains a form, however, when I toggle the display of it, it isn't working correctly. You can see what I mean here - http://development.dekken.co.uk/bni/training/ If you click on 'confirm', the form is toggled. Howev...
Hello, In a database table with a structure like this : Table 1 Name | Id A 1 B 2 Table 2 Table1's ID | IntValue 1 11 2 66 now, there is a query which joins the 2 tables and outputs something like A | 11 B | 66 but the problem is that when, let's say row (A,1) gets deleted from table1 the...
Hey guys, I have written some jQuery code to use the "slideUp" animation when deleting rows from a table. In order for the animation to appear smooth, I wrapped the contents of each TD in the row with DIV tags, and called the slideUp function on the DIVs, removing the actual TDs upon completion of the animation. The code for that is as f...
I'm showing an ABPeoplePickerNavigationController as a tab in my app. The user clicks a name, then email address, then I do something with the email address. Afterwards, I'd like for the person and property that they selected to fade out (not be highlighted). In a normal table, I'd call deselectRowAtIndexPath. But with the ABPeoplePi...
Hi All. These are my tables:User,Product,DiscountGroup,DiscountUser,DiscountProduct. DiscountProduct: id discountGroupId productId discount --- -------------- --------- ------- 1 2 8 2000 2 3 8 1000 3 2 4 4500 Dis...