We help IT Professionals succeed at work.

I have made a next/previous Record Browsing but the columns

vage78
vage78 asked
on
I have made a next/previous Record Browsing but the retutned columns has not the same length. It seems very strange.
Why this happens and how can I resolve it?

ÁÁ mark model year drc
5 OPEL ASCONA 1978 1900000
ÁÁ mark model year drc
6 OPEL ASTRA 1981 1200000
ÁÁ mark model year drc
7 PEUGEOT 106 ZEN 1999 1300000 (here there is the problem)
ÁÁ mark model year drc
8 PEUGEOT 406 LUX 1998 4000000  (and here)
it seems that coldfusion put some extra white spaces in that places
Comment
Watch Question

CERTIFIED EXPERT

Commented:
What language are you using? English?

hongjun
Commented:
looks like you have 5 columns: index, mark, model, year and drc

on your problem rows, the model is composed of 2 words (106 and ZEN - 406 LUX)

cf will not insert blank spaces, they are probably like this in your db.

do a "select model from my table" and take a quick look at the values you get
CERTIFIED EXPERT

Commented:
How about doing a Trim on the strings to remove trailing and leading spaces.

hongjun

Author

Commented:
I only do
Select * from Table

In my database the fields are separately
hongjun
What do you mean about Trim. How can I do it?

Author

Commented:
The funny is that
my fields are
AA  TRADE model year drc
and for example
PEUGEOT 406 and PEUGEOT 106 are in the MARK field

Commented:
best to use tables
There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of davidola.

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.

vage78,

Some of these questions have been open for some time, and records indicate you logged in as recently as this week. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20123680
http://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20060221
http://www.experts-exchange.com/jsp/qShow.jsp?ta=linux&qid=20192169
http://www.experts-exchange.com/jsp/qShow.jsp?ta=dbgen&qid=20235302
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20192814
http://www.experts-exchange.com/jsp/qShow.jsp?ta=progsoftgen&qid=20083093
http://www.experts-exchange.com/jsp/qShow.jsp?ta=perl&qid=20074813
http://www.experts-exchange.com/jsp/qShow.jsp?ta=apache&qid=20123865
http://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250081
http://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250008
http://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247154
http://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247145
http://www.experts-exchange.com/jsp/qShow.jsp?ta=networkgen&qid=20224746
http://www.experts-exchange.com/jsp/qShow.jsp?ta=unixnet&qid=20131621
http://www.experts-exchange.com/jsp/qShow.jsp?ta=win95net&qid=20175849
http://www.experts-exchange.com/jsp/qShow.jsp?ta=linuxsetup&qid=20246030
http://www.experts-exchange.com/jsp/qShow.jsp?ta=winntsetup&qid=20193164

Thanks,

Netminder
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.