column

Connecting/Checking a MySQL database in C#

Can someone provide with me some code to connect to a MySQL database and check the whole of one column to see if it is less than 2? I've looked online and have found nothing which can help. Thanks so much, Lawrence ...

Why JPA, Hibernate and jTDS always uses varchar(8000) for String columns?

I'm using JPA (Hibernate) and jTDS as my jdbc driver. Whenever the datatype of my entity columns are String, the created prepared statement uses varchar(8000) as its parameter. I've already tried to use @Column(length=50) in my mappings for example, but it seems to be ignored. If I set sendStringParametersAsUnicode in jTDS connection, i...

html css - how to create multiple column list?

I have an "Ordered List" which contains about 100 "List Items". This ol makes my page very long and users have to scroll too much. How can I get the UL to show like this: 1. 6. 11. 2. 7. 12. 3. 8. 13. 4. 9. 14. 5. 10. 15. ...

ALTER TABLE Sqlite: how to check if a column exists before alter the table?

Hello everyone! I need to execute in python a SQL query that adds a new column, in sqlite3. The problem is that sometimes it already exists. So previous to executing the query I need to check if the column already exists. If it does, then I won't execute the query. Is there a way in sqlite to do that? Or do I have to make it throug...

if the visibilty is hidden of a particular column of a listview will it be shown in the disc if the files are burn?

my query is about hiding a particular column in the listview..if im successful in doing that then how i will be able to hide it to the user if the files in the listview are burn with that hidden column..how can i apply the authentication...to a particular column that a user cannot see that while burning the files in the disc that are pla...

on button click the visibility of a column in listview should set to false

how can a visibility of a particular column can set to false in a listview..that is the column should exists in the client site but in hidden form... what is the option other than setting the width to 0. im working in c#.net VS2008 ...

Is it possible to have two column headers in Datagrid view using c#

I like to take a column header text and span it across to columns. How would you do this? I can't find a "Headercell.Span." Also is it possible to have two column headers? Like this | FULL NAME | DESC. | | first | last | state | age | DATA ...

select rows from dataTable - Issue with the values which have singlequote

Hi, I have a .net datatable...from which I am filtering rows using datatable' select function Assume the datatable as below Id | Name | Description | 1 | Anish| "sachin's centuary" | If I search my datatable as... datatable.select("Description = 'sachin's centuary'")...it is not returning any rows because of the "sin...

adding the value of a column into a LIKE statement?

hi there i have 3 tables for tags, tag categories and used tags. i'm wanting to get a list of all tags with a count of the used tags (the format of the tags used is comma separated values for each document id that has tags). i've been trying something like this but I can't get the value of the tags.tag field to be inserted into the LIK...

Single column, long index pages in LaTeX

Been having some trouble implementing a single-column index in LaTeX. I've been employing the idxlayout package along with multind in order to create an index that is catenated from a slew of other source idx files. First, the index is ALWAYS set to use two columns. Even though the idxlayout package is set to columns=1, and the itemla...

Select the same column multiple times

Hello, hope someone can help. I have two tables: Users -UserID -UserName UsersType -UserTypeID -UserID Possible values for UsersTypeID is 1 to 6. In that scenario Users may have multiple types and I need to retrieve a distinct row for each user with the columns described below. UserName - Type1 - Type2 - Type3 - Type4 Joe ...

Silverlight Gridcolumn Collapse Visibility in code

Hi, I'm having a small problem. I have this grid with a column: <data:DataGrid ColumnHeaderStyle="{StaticResource headerStyle}" Foreground="#234BC3" AutoGenerateColumns="False" Name="protocollenBAMDataGrid" LoadingRow="myDataGrid_LoadingRow" SelectionChanged="DataGrid_SelectionChanged"> <data:DataGrid.Columns> ...

Update Table, Where Column Name is selected dynamically - DropDown.SelectedValue, C#, VB.NET

Hi, I want to Update Column of a Table where ColumnName will be DropDown.SelectedValue. Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100...

Query a column and a calculation of columns at the same time PostgreSQL

Hi I have two tables, Products and BundleProducts that have o2o relation with BaseProducts. A BundleProduct is a collection of Products using a m2m realtion to the Products table. Products has a price column and the price of a BundleProduct is calculated as the sum of the prices of its Products. BaseProducts have columns like name and ...

Looking for an easy cms system? flexible plugins modules, blocks, themes

Hi I'm a big user of Wordpress however its not ideal for cms sites. I'm currently looking at pixie cms, however if say I want three columns, only one column can be allowed to change across pages and I can't apply specific templeates to pages. I'm also looking at impress cms which looks confusing in the admin although it has good reviews....

How to delete columns?

Hi all, I have generated the following text file below: fe120b99164f151b28bf86afa6389b22 -rw-r--r-- 1 joey joey 186 2010-03-14 19:26 Descript.txt 41705ea936cfc653f273b5454c1cdde6 -rw-r--r-- 1 joey joey 30 2010-03-14 20:29 listof.txt 0e25cca3222d32fff43563465af03340 -rw-r--r-- 1 joey joey 28 2010-03-14 23:35 sedexample.txt d41d8cd98f0...

Silverlight DataGrid: Hiding columns using VisualStateManager

Is it possible to hide a column of a datagrid, without using codebehind? E.g. by using the VisualStateManager? <UserControl xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data" x:Cl...

How do I select differing rows in two MySQL tables with the same structure?

I have two tables, A and B, that have the same structure (about 30+ fields). Is there a short, elegant way to join these tables and only select rows where one or more columns differ? I could certainly write some script that creates the query with all the column names but maybe there is an SQL-only solution. To put it another way: Is the...

how to fix the column width of a listview in c# windows form?

i have a listview i need to fix the column width of the listview so that at run time user cannot drag the columnheaders and resize it.....what is the procedure?? i have searched all the properties but none of them help me out to solve this pbm.. this is possible in gridview but how will it be possible in listview.... ...

XSL: List divided into columns.

Hello, help me please. There is a list of nodes. <list> <item>1</item> <item>2</item> <item>3</item> <item>4</item> <item>5</item> <item>6</item> <item>7</item> and so on... </list> Need to divide the list of "n" (arbitrary number) equal parts. If the number of nodes is not divided equally, then let the last set of n...