Hi! I'm trying to convert a varchar(50) column to a uniqueidentifier, but this error keeps popping up all the time, and i don't know why: "Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier." The data in the column is currently a valid uniqueidentifier. What's the proper...
As the title says, is there an easy way to output two columns to the console in Java? I'm aware of /t, but I haven't found a way to space based on a specific column when using printf. ...
In my schema there are a few redundant columns used to speed up report queries. For example, the purchase total of a sale is saved in the "purchase_total" column of the "sale" table, yet in the model, it is calculated dynamically by adding up the sold price of each item purchase in the sale. This value can be retrieved by calling the "g...
Hi friends, I have an UITableView with "2 columns" showing the content of 2 different "unlinked" arrays. The second array is dinamically updated. My question is: How can I sort the 1st array (actually a dictionary of arrays) using the content of the second array? ...
Hi, I have a web application that I am working on(ASP.NET 2.0 C#). In it I have a GridView whose data source is an Oracle database. I get the data into the gridview in my codebehind, and don't set the datasource directly. I wanted to create a hyperlink field (NAME) that takes me to a details page about a specific record. What ends up...
I have a table called tblAssetsInUse with the following structure: intPK intAssetID datCheckedOut datCheckedIn 1 450 1/5/2009 10/5/2009 2 300 2/5/2009 <NULL> 3 200 2/5/2009 <NULL> 4 450 12/5/2009 5/7/2009 ...
I've got a class with a bunch of [ColumnName("foo")] NHibernate attributes. Is there an easy way to ask NHibernate to list all of the ColumnNames for a given class? It sounds like it should be really easy but I'm just not seeing any kind of inspection in the NHibernate docs (or maybe I'm just blind today). ...
Hello everyone. I am having a bit of trouble with ADO. I have deployed a database application, which uses Access. With the release of different versions database tables have different fields, some added others deleted etc. What I can't get to work is how to add a BOOLEAN field in the database. For upgrade purposes I use the standart sq...
I had created a multi choice column called "technology" on our shreapoint portal. Recently, by mistake I clicked on delete button while making changes to the column value and now I want to restore the system in the orignal form. I have recreated the column with all the options, the problem is that all the documents had the technology val...
There was a similar question asked but it wasn't exactly what I am trying to do. Here is a link to the question: http://stackoverflow.com/questions/607291/auto-number-column-in-sharepoint-list-with-link-to-item/799866#799866 Two solutons were offered to that question. Could either of these solutions work for an imported list I have wh...
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...
i have a table (SQL Sever, in this case) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And - I need to change the same string to the new one, in every record. How can i do this with a simple...
I have a datagridview that is populated with 4 columns and multiple rows of data. I want to iterate through the datagridview and get the cell value from A SPECIFIC COLUMN ONLY, since i need this data to pass into a method. Here is my code: foreach (DataGridViewRow row in this.dataGridView2.Rows) { foreac...
in a table two of columns are billable(bit),billabledate(datetime).i want billable date to be not null if billable is not null. ...
Are there in general any known performance issues in WPF related to grid column resizing? I have an application where I need to do some particular things in a column, but for all the different solutions I find the column resizing gets slow. This applies when I have typically more than 1000 elements in my list, but I assume this isn't t...
Is there a simple formula for determining the maximum and minimum values for an Oracle NUMBER column with (p, s)? ...
Is there a way (using jquery, yui or some other js library) to display a grid that has the headers in the first column? That is, I would have something like: Name Geoffrey EMail GMan67@.. Username GJFM Instead of: Name EMail Username Geoffrey GMan67@.. GJFM G-Man ...
We are binding an unknown result set to a WPF DataGrid at run time. Some of our columns are going to contain DateTime values and we need to properly format these date time fields. Without knowing which columns are going to be DateTime fields at design time, how are we able to format the columns at runtime? We are using a DataTable's D...
Hello, Let's say a have a stored procedure SetCustomerName which has an input parameter Name, and I have a table customers with column Name. So inside my stored procedure I want to set customer's name. If I write UPDATE customers SET Name = Name; this is incorrect and I see 2 other ways: UPDATE customers SET Name = `Name`; UPDATE cu...
Example: <style type="text/css"> table { border: 1px solid red; border-collapse: collapse; text-align: left; } #col-1 { padding-left: 20px; background-color: tan; } #specific-cell { padding-left: 20px; } </style> <table> <col id="col-1"> <col id="col-2"> ...