vage78
asked on
I have made a next/previous Record Browsing but the columns
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How about doing a Trim on the strings to remove trailing and leading spaces.
hongjun
hongjun
ASKER
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?
Select * from Table
In my database the fields are separately
hongjun
What do you mean about Trim. How can I do it?
ASKER
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
my fields are
AA TRADE model year drc
and for example
PEUGEOT 406 and PEUGEOT 106 are in the MARK field
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.
https://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20123680
https://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20060221
https://www.experts-exchange.com/jsp/qShow.jsp?ta=linux&qid=20192169
https://www.experts-exchange.com/jsp/qShow.jsp?ta=dbgen&qid=20235302
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20192814
https://www.experts-exchange.com/jsp/qShow.jsp?ta=progsoftgen&qid=20083093
https://www.experts-exchange.com/jsp/qShow.jsp?ta=perl&qid=20074813
https://www.experts-exchange.com/jsp/qShow.jsp?ta=apache&qid=20123865
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250081
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250008
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247154
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247145
https://www.experts-exchange.com/jsp/qShow.jsp?ta=networkgen&qid=20224746
https://www.experts-exchange.com/jsp/qShow.jsp?ta=unixnet&qid=20131621
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win95net&qid=20175849
https://www.experts-exchange.com/jsp/qShow.jsp?ta=linuxsetup&qid=20246030
https://www.experts-exchange.com/jsp/qShow.jsp?ta=winntsetup&qid=20193164
Thanks,
Netminder
Community Support Moderator
Experts Exchange
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.
https://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20123680
https://www.experts-exchange.com/jsp/qShow.jsp?ta=solaris&qid=20060221
https://www.experts-exchange.com/jsp/qShow.jsp?ta=linux&qid=20192169
https://www.experts-exchange.com/jsp/qShow.jsp?ta=dbgen&qid=20235302
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20192814
https://www.experts-exchange.com/jsp/qShow.jsp?ta=progsoftgen&qid=20083093
https://www.experts-exchange.com/jsp/qShow.jsp?ta=perl&qid=20074813
https://www.experts-exchange.com/jsp/qShow.jsp?ta=apache&qid=20123865
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250081
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20250008
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247154
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20247145
https://www.experts-exchange.com/jsp/qShow.jsp?ta=networkgen&qid=20224746
https://www.experts-exchange.com/jsp/qShow.jsp?ta=unixnet&qid=20131621
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win95net&qid=20175849
https://www.experts-exchange.com/jsp/qShow.jsp?ta=linuxsetup&qid=20246030
https://www.experts-exchange.com/jsp/qShow.jsp?ta=winntsetup&qid=20193164
Thanks,
Netminder
Community Support Moderator
Experts Exchange
hongjun