Re: Getting Found Count When Using Limit

2002-03-21 Thread Fletcher Sandbeck
. I'm looking for a way to do it using raw MySQL statements. I think I found my answer in the list archives. It's not possible without using multiple SQL statements. [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL

Getting Found Count When Using Limit

2002-03-21 Thread Fletcher Sandbeck
one record back with the correct total. Is there any way to get both the number of records found and the first set of results using a single query? Thanks, [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED]

Re: Error Code 13 when using ALTER TABLE

2002-01-02 Thread Fletcher Sandbeck
ccessful call, then errors on subsequent calls). [fletcher] Original Message At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: >This is with MySQL 3.23.42-nt on Windows 2000. > >I am issuing the following SQL statement and getting back an error message. > >ALTER TABLE Database.

Error Code 13 when using ALTER TABLE

2002-01-02 Thread Fletcher Sandbeck
: 13) A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an error '13 when fixing table' and 'Operation Failed' as the final status. Any ideas of what is going wrong? [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Pro

Re: MySQL and encryption

2001-11-20 Thread Fletcher Sandbeck
he security of the network between machines on your LAN, the security of your backups, the security of your administration tools, etc. Also, you need to think about how you'll get to the secured data in the future if you need to. What happens if you lose the key that was used to encrypted t

Re: mysql and credit cards

2001-07-25 Thread Fletcher Sandbeck
is being transmitted between a client and the server. However, it does not prevent a determined individual from seeing the traffic. [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist

Re: Error Codes

2001-07-03 Thread Fletcher Sandbeck
but this process will take some time. I hate to duplicate work. [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.

Error Codes

2001-07-03 Thread Fletcher Sandbeck
I am looking for a concise listing of all the error codes that MySQL might return after issuing a SQL statement. The manual and other books I've checked have descriptions of the errors, but don't seem to collect them all into one reference. Thanks, [fletcher] -- Fletche