-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anil Gupte wrote: > OK, I figured out the problem, but not the solution. The output > is actually from a SQL query. The output looks like this (when > echoed): > > Serial_Number TLO000003 > > It is getting the field name and the field value as two lines. So > there is a newline before the TLO000003 not a space. So I tried > Serial_Number=${Serial_Number#\n} and > Serial_Number=${Serial_Number#\r} but neither seemed to work. > Any suggestions? > > In fact a better thing would be to get the result from mysql > without the field name - just the value as a string. Any ideas > how?
A stored procedure? (Does MySQL have stored procedures?) - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEl+P8S9HxQb37XmcRAiU+AJ93zdBGis1Urv4awbEALyoX+Pkf3QCg2a8I ZQRdejZBq/4bNG/ZHo9QWyE= =ioIY -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]