[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Scripting question



-----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-----



Reply to: