Chris Boget wrote:
Is there a way to programatically get information about a
specific table and/or field? And also any constraints that
a field has?
thnx,
Chris
sp_help @objname='{tablename}'
This will actually return several recordsets which are probably
available individually in the other
William Stokes wrote:
Hello,
I have a system that uses certain id info. This info is stored in a session
cookie in MD5 format. At certain parts of the code I need to update or
insert to MySQL DB with that id info value in cleartext. Is this possible?
If so, how to put this to a sql query?
$sqlqu
me from users where recid = $_SESSION['userid'] and
md5(username) = $_SESSION['remember_me']
Any query optimizer worth its salt will first filter based on the record
ID and then only apply the md5 function to the remaining (1 in this
case) usernames.
--
D. Wokan
--
PHP
Matthew Weier O'Phinney wrote:
* Reynier Perez Mira <[EMAIL PROTECTED]>:
I'm using PEAR DB and Smarty. The case is that I have to pass a value =
from a query result to a Smarty var. I try to paginate results. See the =
code below:
#x27;re working with a currency, I'd say you can safely round to
about 4 or 8 decimal places to get a reasonably accurate result. I
typically use 4 since most money types I've seen only go out 4 decimal
places to begin with.
--
D. Wokan
(Sorry for the double reply, Jon. Didn't
5 matches
Mail list logo