473,394 Members | 2,002 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

how to adjust the column width for a result set?

Hi all,
I am retriving two columns and the result set is not fitting on the screen due to a wider column width..how can get rid of the extra spaces in between the two columns...
Mar 11 '08 #1
2 14230
docdiesel
297 Expert 100+
Hi,

if I understand you right you're displaying two columns with usually a couple of chars and lots of white space in between? You could cut them into place with substr() :

Expand|Select|Wrap|Line Numbers
  1. SELECT
  2.   substr(name,1,20)    as name,
  3.   substr(comment,1,60) as comment
  4. FROM
  5.   ...
Regards,

Bernd
Mar 11 '08 #2
Hi,

if I understand you right you're displaying two columns with usually a couple of chars and lots of white space in between? You could cut them into place with substr() :

Expand|Select|Wrap|Line Numbers
  1. SELECT
  2.   substr(name,1,20)    as name,
  3.   substr(comment,1,60) as comment
  4. FROM
  5.   ...
Regards,

Bernd
thats exactly what I was looking for..
thank you very much,

Sunny
Mar 11 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Michael Hill | last post by:
I am having a problem formatting the third column. It should be 70px wide, but it is extending well beyond 70. The 2nd and 3rd column should be the same width. The content of the 3rd column...
3
by: Steve | last post by:
Visual Studio 2003 / C# Is it possible to change the width of the columns in a datagrid at runtime? I am generating and populating a dataset at runtime, then binding a datagrid to this dataset. ...
7
by: lauren quantrell | last post by:
A while back I got a requirement for the client to be able to adjust the relative heights of two subforms by click-dragging the mouse and I came up with a kludge solution using a border control...
2
by: ricky | last post by:
Hello, If anyone could help me with this I would highly appreciate it. I've tried everything and nothing works. What I am trying to do is so damn basic and it's just frustrating that it seems...
1
by: msch-prv | last post by:
I have difficulties adjusting the column width of a gridview control. The column width changes appear in the design grid, but at run-time the width changes back to what I presume are the grid's...
8
by: hussain123 | last post by:
Hi List, I am having two table one after the another.Even after setting the column width of both the tables the column takes the width of the data in that column. Ideally I want both the table's...
6
by: Christopher Glenn | last post by:
I have very basic html skills. My friend who has a wide screen monitor and is using IE7 sent me a jpg screen shot of my home page. I have attached this jpg, but I recall a while back that...
2
by: Appu2008 | last post by:
Hi, Iam making a report based on some database values. The fields are displayed in different columns of a table(Iam using php+mysql). My problem is that how can I make the width of a column...
3
by: Gord | last post by:
If possible, how can the user be prevented from adjusting the column width and/or the row height in datasheet view (in VB code if necessary)? (I still want them to be able edit the contents of the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.