<html>
<font size=3>A field of type char(30) will return a 30 character long
string padded with spaces on the right.<br>
Use varchar instead.<br>
<br>
<br>
At 07:37 AM 8/14/00 -0700, Planet CF wrote:<br>
<blockquote type=cite cite>Hi All,<br>
A 'Select' on a Sybase Database results in extra<br>
spaces being added to the data being selected (mostly<br>
spaces on the right). I really don't know as to why<br>
this is happenning.<br>
<br>
So what we do is use the TRIM function to get rid of<br>
those spaces. Now this has become some kind of a<br>
"xtra" in the application. Like... if somehow you<br>
forget to TRIM, you end up in errors which are not<br>
traceable to a specific code for a long time....<br>
kindof time consuming... and frustratiing too. <br>
<br>
There could be two solutions to this problem:<br>
1. Find out the reason for the 'spaces' that are being<br>
added and fix the problem at the root.<br>
<br>
2. Assuming that the problem cannot be fixed and one<br>
has to deal with TRIM, a better way of doing it (that<br>
comes to my mind) would be to write a custom tag that<br>
TRIM's all query data before sending it to the calling<br>
page. Is there a custom tag on the gallery, that<br>
already does this?<br>
<br>
Any suggestions or comments are welcome.<br>
<br>
Thanks<br>
Kedar Desai<br>
Differential Technologies<br>
Fairfax, VA<br>
<br>
<br>
__________________________________________________<br>
Do You Yahoo!?<br>
Yahoo! Mail Free email you can access from anywhere!<br>
<a href="http://mail.yahoo.com/" eudora="autourl">http://mail.yahoo.com/</a><br>
------------------------------------------------------------------------------<br>
Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
</font></blockquote><br>
<br>
-<font
size=3>--------------------------------------------------------------------------<br>
Peter Theobald, Chief Technology Officer<br>
LiquidStreaming <a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
[EMAIL PROTECTED]<br>
Phone 1.212.545.1232 Fax 1.212.679.8032<br>
</font></html>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
