formatting

Need help using sql join to convert rows to columns (Oracle 9i)

Hi, I have a table, with abt 22 columns and 6-7 thousand rows in the following format Seq_num unique_id name ... ------------------------------------ 1 1 abc 1 1 cde 2 1 lmn 2 1 opq 3 1 pqr ...

Good way to format data in a large DataTable

I have a large data.DataTable and some formatting rules to apply. I'm sure this is not a unique problem. For example, the LASTNAME column has a value of "Jones" but my formatting rule requires it be 10 characters padded with spaces on the right and uppercase only. Like: "JONES " My initial thought is to loop through each row and...

Maintaining formatting of multiline text when retrieved via Sharepoint web service

I'm writing a C# app that retrieves data from a SharePoint list via a web service proxy object (created with wsdl.exe). Several of the fields within the lists are multilined plain text. When these fields are displayed using the standard SharePoint web portal the text is formatted correctly (has newlines) but when I get this data using th...

Preventing Zend Studio from splitting HTML tag arguments on multiple lines

I am trying Zend Studio before I buy it. I have noticed that a line like this: <input type="hidden" name="id" value="<?php echo $this->album ['id']; ?>" /> will be changed to this: <input type="hidden" name="id" value="album ['id']; ?>" /> during the Format operation. Is there anyway to prevent this? It is very messy in my opinio...

Auto-Format in TextBox Only

I am using Microsoft Visual Studio Professional 2010. (Also SQL Management Studio for my database but this information may not be needed, just trying to give enough to make sure what i am doing is understood) I am making a website in ASP.NET with Visual Basic.net code behind. The site is basically a contact list site. 3 Text Box F...

Format Telephone Number in GridView

I see another thread somewhat like my question at: http://stackoverflow.com/questions/1180403/asp-net-gridview-column-formatting-telephone-number but i do not know if it answers my question as he is using code-behind to make the colum. All I did was insert the GridView control in visual studio. BTW, the data is being populated in the G...

Enable Django format localization by default

This is about the Format Localization feature that was implemented in Django 1.2. In order to use this feature, you must add a localize=True parameter to all your form fields. I am trying to implement this localization in my app but the problem is that I am creating my forms dynamically by using the inlineformset_factory method that Dja...

Build up formatted text programmatically to display in a RichTextBox?

What I'd like to do is build up a string with specific formatting to be displayed in a RichTextBox control. Something like this (this doesn't completely work): Dim testText as String = "" testText = "Test text" & vbTab & "with a tab." & vbCrLf testText = testText & "<b>This just prints out verbatim. How do I make it print bold?</b>" ...

XLS formatting with basic table?

Hi, I'm trying to create a simple report on an intranet site. Based on this answer, I think I want to just go with a simple HTML table syntax. In that post, Joel Coehoorn says that there are some limited formatting options you can perform. Is it possible to add borders to the cells, and if so, how? My google-fu has failed to provide any...

Is there a way to format a variety of currencies on Python?

I've got a Python web server (mod_python, if that makes any difference) that I want to start formatting some currency. I've got two pieces of information when I format the currency - the value (as a number) and the currency (as the three-letter ISO 4217 code). I can also retrieve the country (or even city) that the currency is being fo...

Drupal Gallery Formatter and Colorbox

Can anyone tell me how to make Gallery Formatter open a Colorbox modal when the slide is clicked? I have both modules installed as well as CCK, etc... Also, I have made sure that the colorbox library is properly installed, too! I know it is probably something simple, but it has eluded me up to this point! I am using the Drupal Colorbox m...

How to display a formatted DateTime in Spring MVC 3.0?

Hi, I have a Joda-DateTime field in my model and want to display it formatted in a JSP view. I have annotated it with the new @DateTimeFormat annotation: public class Customer { private DateTime dateOfBirth; @DateTimeFormat(style="M-") public DateTime getDateOfBirth() { return dateOfBirth; } } Now I want to display ...

How much column formatting should be used in a native SQL query?

Ever since I started using an ORM for my day to day data access. I've started to think about how much I should rely formatting functions for my columns. By formatting functions, I mean such things as Oracle's decode(), instr() and initcap(). Example Say I'm selecting this column using formatting in Oracle. (to_number(to_char(to_date...

mysql date to php

I have a date field in mysql that contains numbers like 2455419. Any idea what format this is and how to convert to php/human eadable form? ...

How to make Eclipse to format JSP code properly?

I use code formatting command (Ctrl + Shift + F) a lot in Eclipse IDE. While this works pretty well for Java / CSS source codes, the JSP formatting is just sucks. Is there any plug-in available to make the JSP formatting better in Eclipse IDE? By formatting I mean proper indenting of JSP/HTML tags. ...

format datetime from linq query into selectlist for dropdown

No coffee. Brain. Not. Functioning. I have this linq query here: Public Function ListAllVisitDates() As List(Of SelectListItem) Dim visitdates = db.SchoolVisitDates.Select(Function(t) New SelectListItem() With {.Text = t.VisitDate, .Value = t.VisitDateID}).ToList() Return visitdates End Function It returns a long date of MM d...

Laying ot components in Java Swing

Oh hay there, didn't see you. I was wondering if there is a better, more efficient way of formatting the labels, panels, and buttons in java then what I have done below. Here is my code, I want to make Welcome, the date, and the button to all be on separate lines. And the only logical way of doing so is creating blank labels, right? pri...

T-SQL: exporting table to XML using stored proc - how to format?

I'm using SELECT ... FOR XML to generate XML and it creates exactly what I want to see - in SSMS. But... The problem I have is, the exported XML file has the entire XML body on a single line. It's valid XML, but how can I format the output? (one element per line, terminated with \r\n and preferably indented) The file should be human ...

Format() not working in Visual Basic (Visual Studio 2005/ Win 7)

Hey everyone, I am having a problem with Format not working. I have tried several standard formats but it doesn't effect the output at all. Dim tempstring As String = Format(Now(), "M, m") and Dim date As Date = Format(Now(), "M, m") both have a final value of "8/16/2010 10:52:21 AM" Thanks for the help. Update I am still having pr...

Printf with Double Formatting Question

I've got the following printf statement: printf("val=%-4.2lf", val); However, val is never padded with spaces so the space taken up by val is different if there are 3 or 4 digits before the decimal. Shouldn't the 4 in the format specifier guarantee that there are at least 4 spaces? Sorry for the newb question but it's been frustratin...