How about
select close_date, symbol, name
from TD
where symbol in (list of
characters) limit 1
ORDER BY close_date desc
Jeff Mathis [EMAIL PROTECTED] wrote:
hello query gurus.
we have a table TD with the following columns:
close_date
symbol
name
close_date is just a date field
there
+-++-+
| max(close_date) | symbol | name|
+-++-+
| 2004-10-05 | aa | cmptrhw |
| 2004-10-05 | bb | biotech |
| 2004-10-05 | cc | biotech |
it back, it will
negate all changes (inserts, updates, deletes) that occurred within the transaction.
Hope that helps, not sure I'm understanding your question.
Regards,
Joe Audette
Stuart Felenstein [EMAIL PROTECTED] wrote:
This maybe somewhat of a silly question.
Scenario - I am pretty
string encrypted in a config file for your app
then decrypt it before you connect. You'd have to use an encryption that can be
decrypted with a key.
Checkout the System.Security.Cryptography.DESCryptoServiceProvider class
Hope that helps,
Joe Audette
Thomas Trutt [EMAIL PROTECTED] wrote
database on your network
that is lower version than 4 then how do the other apps connect to it securely? Or is
your app the only one that needs this level of security and other app can transmit to
the db in clear text?
Joe Audette
Thomas Trutt [EMAIL PROTECTED] wrote:
Thanks,
Actually
and other app can transmit to the db in clear text?
Joe Audette
Thomas Trutt wrote:
Thanks,
Actually it is the transmission connection string he is worried
about. I might have to go with an SSL connection and go from there.. The
problems being that I'm not sure what software i have available
InnoDb doesn't support full text indexes on text columns so if you need to search text
fields you may want ot use MyISAM. It is perfectly ok to have a mixture of InnoDB and
MyISAM in a single database so you can make your decision on a table by table basis.
Joe
Stuart Felenstein [EMAIL
MySqlAdministrator is installed and
it fixed it. I found it in a folder related to MS Outlook. Hope that
helps, if you don't find it let me know and I'll send you mine.
Best Regards,
Joe Audette