column

Output a single column from a datatable

So this doesn't seem like it should be that difficult, but apparently I'm overlooking something..? I have a datatable that has 4 columns. I want to output only the second column from the datatable. Here's what I've got so far: Dim dt As New DataTable ** Datatable is set here ** Dim row As DataRow Dim col As DataColumn For Each row In d...

Python: Inconsistent behaviour using sqlite3.Row to index into results by name

Hi all. In my Python application I have been using sqlite3.Row as the row factory to index results by name for a while with no issues. Recently I moved my application to a new server (no code changes), and I discovered this method of indexing is now unexpectedly failing on the new server given quite a specific condition. I cannot see ...

Is it possible to globally configure all char/varchar/text columns in a mysql database to use utf8?

I have a database that I had imported and accidentally created some tables as using latin1 by default. I've altered the tables and the database, but the columns are still latin1. I don't really have any reason to use latin1, so is there any way to just change all columns to use utf8? This is a development database, so it doesn't neces...

MySQL: Select multiple rows containing values from one column

Dear all, I'd like to find the car_id's of the cars that have 'FORD' AND 'SILVER' AND the user input value of '200' in the value column: table_cars +----+--------+----------+-----------+ | id | car_id | name | value | +----+--------+----------+-----------+ | 1 | 1 | MAKE | FORD | | 2 | 1 ...

using for each loop in visual basic for developers in excel to copy on visible values

Hey all, I would like to use a for each loop in excel to copy only all visible values in my excel spreadsheet in order to remove the link from the auto filtering so that when I export or copy these values, the hidden values from the auto filter don't come back. Here's macro: Sub sortify() Application.ScreenUpdating = False Range("A...

Two Separate Navigations on a Single Rails Page

I'm creating a rails app with two columns. On one side is a journal log and the other is a set of various links and resources to internal pages. I'd like to be able to navigate to different pages of the journal log on the left side without changing the content on the right. I'd also like to navigate through pages on the right without cha...

How to Insert row into SQL database with IDENTITY_INSERT set to OFF using WCF services?

An SQL table has auto increment property set for the primary key AnnotationID of INT type. The Silverlight application WCF service code: public void InsertImageAnnotation(int imageId, string imagePath) { DataClassDataContext db = new DataClassDataContext(); ImageAnnotation row = new ImageAnnotation(); r...

WPF MvvM DataGrid variable Columns through a IList of columns

Hi all, I am searching about how to create variable number of columns in a DataGrid from the Ilist in MVVM way. The requirement I am working on is very big and also the number of rows and columns are not known But I did not find satisfactory answers Is there some one that had to do the samething ? If there is no way of generating suc...

C# resolving Excel table column names of which some are dates.

I am trying to return the list of columns names from a DataSet in C# based on an Excel Query I have performed. I am ok doing this (well I think), see code below. However, three of my column headings are Dates and the column name is displayed as F4, F5, F6. I have looked further and found that the Type (.getType) report System.Double but ...

get data from datetime's column

lets say I have a "Datetime" column in DB. It has a data like "2010-10-01 09:12:00". Beside that, i want to make a searching page which have: <select id="month" name="month"> <option value="01">01</option> <option value="02">02</option> ... </select> <input type="text" id="year" name="year"> How do i do to get dat...

WPF Datagrid Template column edit event and alternating column color

I have been using WPF for quiet sometime. I know DataGrid in WPF does not have a Column collection as dependency property so columns cannot be added dynamically. The application I am developing is highly dynamic so the number of columns are not known. So I am creating DataGridTemplate columns from code behind. Problem 1 : I want alter...

Display column values from database

Hi. I'm trying to display all the values from a specific column created by my Wordpress plugin (specifically, the ID's). Here is the code I have managed to use to display the column names, but I cannot get it to just display all the ID's. Here is the code: function test() { global $wpdb; global $table_name; $testing = $wpdb-...

LaTeX top row on a stem and leaf plot table

Hi I am trying to represent a stem and leaf plot in a tabular environment in LaTeX using the following: \begin{table}[htbp] \centering \caption{Stem Plot of sit ups, Key: $1 | 1= 1.1$} \begin{tabular}{r|l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hspace{4 pt}}l@{\hsp...

[R] Extract Column from data.frame as a Vector

I'm new to R. I have a a Data.frame with a column called "Symbol". Symbol 1 "IDEA" 2 "PFC" 3 "RPL" 4 "SOBHA" I need to store its values as a vector(x = c("IDEA","PFC","RPL","SOBHA")). Which is the most concise way of doing this? Thanks in Advance ...

Update columns with Null values

Hi I want to update a table as followings update userloginstats set logouttime= sysdate where logouttime= null; But it did not update the columns with null values. what is wrong ...

SQL:Find First Row First Column in Sql Table

Hello excerpts, I have a Database table UserTable CREATE TABLE [UserTable]( [ID] [int] NULL, [Name] [nvarchar](50) NULL, [City] [nvarchar](50) NULL ) ON [PRIMARY] this table have following data ID Name City ----------- -------------------------------- 1 Vijendra ...

rails Column cannot be null:

I noticed that my application was automatically setting all my processes to having been completed as soon as they were created. I looked through it, couldn't find why the date was being updated without being told to, but I found that one of my views was looking for a field that didn't exist. I created the 'complete' field, set it as a no...

how to add new column on elixir

i use elixir as orm for mysql database,now i want to add new column to my schema,how could i keep orginal data in the mysql and update the schema automatically,the concept called migrate on ruby on rails,it seems i didn't found relevent infomation & code in sqlalchemy & elixir,any advice is welcome. ...

Problem select specific column name using sql statement

I found problem when trying to retrieve specific name column that using syntax/statement/command using sql. Example I have table 'dcparam' with name some column 'SELECT', 'INSERT', 'UPDATE' in database sqlserver. Then I trying to select using query: SELECT SELECT,INSERT,UPDATE FROM dcparam Well it could be solve using "*" in select, ...

How to programmatically convert column type in DataGridView C#?

I have dynamically created DataGridView control on form, with DataSource specified as: ((DataGridView)createdControl).DataSource = (IList)(p.GetValue(editedClient, null)); where IList is defined as generic collection for following class: public class CDocumentOperation { [DisplayName(@"Time")] public Da...