I would like to know if there is anyway I can compare two columns in SQL Server. The two columns are located in two different tables. When the column 1's value is smaller than the column 2's value: I want to replace the value of the column 1 with the value of the column 2. ...
I have a table of data that I need to dynamically add a column to. Lets say I have this basic table to start with: <table> <tr><td>cell 1</td><td>cell 2</td><td>cell 3</td></tr> <tr><td>cell 1</td><td>cell 2</td><td>cell 3</td></tr> <tr><td>cell 1</td><td>cell 2</td><td>cell 3</td></tr> </table> I would like to insert a column betw...
I have an ordered list of movies. Each movie has a name and a description. The description length varies. I list the movies one by one in two columns, roughly like this: 1. Blues Brothers | 4. Lord of the Rings Cheesy movie about two guys. | A hobbit and his buddies go ...
Is it possible through SQL in oracle to compare two tables and list the columns that exist in one but not the other. I have two tables, one (table A) that receives the data from an authoritative source with a specific code and the second is the rest of the data from that import without that specific code (Table B). I was hoping there w...
I have a table with three columns in which I'm trying to get some long paragraphs to flow dynamically from the first column into the second and then into the third. Currently, the table will continue on a next page when the first column overflows instead of moving into the second column and so I get several pages filled with only a singl...
I need to store some diffs of other tables' columns in the database. I want to use a single table. Option A Table with 4 columns: id content_type (VARCHAR 255, will be: datetime, integer, varchar, text/clob ...) old_content (CLOB / TEXT, software serialized data for content-type) new_content (CLOB / TEXT, software serialized data for...
I know this might be a bit awkward but I am trying to modify the order of certain columns in a MS Access database in C# with OLE DB. How can I commit a certain change in the order of the columns of a datatable in a dataset? If that is not possible, how can I reorder columns of database table by using a dataset? Here is a sample of what ...
This is what I'm trying to do: (Larger image.) When the <nav> element is present in the design, I want it to look like the example below. Is it possible to do this while the #content div has got a percentage value set? I'm just curious to see whether this is possible without using two different styles for the #content (both with diffe...
Hi, I'm having a major problem with writing values into a new CSV file. I receive a csv file from which I parse all of the values. This works fine, I've brought this up and put it into a datagridview. The first thing that we want to do with this file is to re-arrange it. As it stands, there are two sets of headers: one along the top, a...
I need to group three columns header to one column in jqGrid, Is it possible? Thank ...
how can i split elements of a model into two equally sized pieces so that i can show them in two columns? i have this: element 1 element 2 element 3 element 4 element 5 and i want this: element 1 element 4 element 2 element 5 element 3 split() unfortunately removes the middle element. ...
Hi there, Sorry for my Noobness with Excel/Vba... coming from a unix world...I need help! I am trying to build a TreeView in an Excel Form from an excel Sheet with 3 columns. The sheet references a list of cinemas, already organized in a "tree view", where the A Column refers to a cinema group name, the B and C columns refer to the par...
I have 3 columns in my db table, I need to multiply column, itm_count & itm_price and output the total for a given id(itm_id). SELECT sum(itm_price * itm_count) as total FROM ods_temporder WHERE itm_id='11' I tried to do this using the above sql query, but the result was null. What seems to be the issue here? ...
I've worked with CSS enough that I can get columns to work alongside content if I have a set number of columns: I simply define the sidebar(s) in the HTML prior to the content, and specify that they float to the left or right, while giving the content a margin-left or -right such that it doesn't flow into the space below the end of the s...
I want to update some lookup field of a list when some feature is activated. To deal with this I made a SPFeatureReceiver for the feature. I debug my code and every thing was perfect until I do this: sourceField.SchemaXml = sourceField.SchemaXml.Replace("List=\"\"", string.Format("List=\"{0}\"", targetGuid)); I dont understan...
Various incarnations of this question have been asked here before, but I thought I'd give it another shot. I had a terrible database layout. A single entity (widget) was split into two tables: CREATE TABLE widgets (widget_id int(10) NOT NULL auto_increment) CREATE TABLE widget_data ( widget_id int(10), field ENUM('name','size','color...
HI I am new to Flex and was wondering, when we use an advanced data grid, only when we click on the parent element the children details get populated in the corresponding columns, right?..SO now i have made the empty columns invisible(at design) now how do i make them visible at run time when the parent element is expanded..similarly onc...
How could I implement this? I think my solution is very dirty, and I would like to do it better. I think there is an easy way to do this in Ruby, but I can't remember. I want to use it with Rails, so if Rails provides something similar that's ok, too. usage should be like this: fruits = ['banana', 'strawberry', 'kiwi', 'orange', 'grapef...
For example, my csv has columns as below: ID, ID2, Date, Job No, Code I need to write the columns back in the same order. The dict jumbles the order immediately, so I believe it's more of a problem with the reader. ...
Good morning!! I have a dynamic datatable and I'm using Columns of Richfaces, but when I assign the value to FilterBy, it does not work. Can anyone help me? Woe is my code .. <rich:dataTable id="dtAtendimento" value="#{CadastroAtendimentoTecnico.listaAtendimento}" var="atendimento"> <rich:columns index="index" value="#{CadastroAte...