RE: Netscape ignores %20 with $sort="id DESC"

On 02-Dec-2001 Paul Markov wrote: > Hi, > some users of my web are having problems with sorting a MySQL table > because older > versions of Netscape do not recognize a blank space and do not convert > it into a %20. > > Here's my situation: > $sort = "id DESC" > if ($page_num != $total_num_page)

SHOW TABLES; show nothing

mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic VARCHAR(7)); Query OK, 0 rows affected (0.09 sec) mysql> SHOW TABLES; Empty set (0.00 sec) mysql> DESCRIBE faxblast -> ; +-+--

mysql@lists.mysql.com

RE message below, does anyone have a recommendation for me ? Does mysql_install_db write to a log file that can help ? Thanks Mike --- Mike Williams <[EMAIL PROTECTED]> wrote: > Help ??? > > This command executes and immediately ends: > > safe_mysqld --log & > [2] 855 > root@linux:/var/lib/my

How to use Mytool-DLL with Visual Basic?

Hi, How to use MyTool-DLL with Visual Basic? Can any one give me some pointers? Thanks, Damar database,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Avery Labels with MySQL

Far less complicated than that. I will assume that MyODBC is installed and a data source has been created that points to the mysql data of interest. Load MS Access. On the table tab, select "new/link table" (or import if you prefer). In the "files of type" selection, choose ODBC, then pick

problem of storing binary data in mysql

I use MySQL rpm to install in RedHat 7.2 in one of my pc. Then I store binary data such as image in MySQL and it works normally. However, I install source MySQL in RedHat 7.2 in another pc. But it cannot store binary data. Does anybody know the reason? Is that it need some special configure opti

RE: Avery Labels with MySQL

I guess I would run a query to pull the data out into a CSV file, then import it into Excel, then convert it to a Word document. Or run a query where MS Access pulls the data and syncs it with a database in Access, then export the table into Excel or Word or Outlook PST file Thank you, Todd Wi

Avery Labels with MySQL

Hi, I am creating a PHP/MySQL web based app that takes contact information in. I would like to be able to make Avery Address Labels with the data that I get. Any ideas on how to do this? I'm guessing MS Access might be able to help with this (if it handles MySQL) cause I know the Office prod

Re: (errno: 144)

[localhost:~/tmp] kundan% perror 144 Error code 144: Unknown error: 144 144 = Table is crashed and last repair failed Regards, Kundan On 11/29/01 2:17 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'm getting an error when i query a table i created. I have about 7 or 8 > records, whi

Re: Beginner question

Assuming that you have a table called 'test' where there are three columns 'a', 'b' and 'c'. Now you have 'a'+'b' as unique but neither only 'a' nor 'b'. To specify that, define a and b both combined as primary key for the table, as in the following statement: CREATE TABLE `test` ( `a` TINYINT

Re: [PHP] RE: SQL state S1090: Almost connected to mysql via PHP/odbc

On Sunday 02 December 2001 23:18, Venu wrote: > > in themysql monitor. It *shows* when I run isql -v m97. > > I have modified /etc/odbc.ini and /etc/odbcinst.ini and /etc/odbc.ini as > The problem is that, unixODBC is not able to find your MyODBC > DSN entry. This is probably due to the fact th

RE: SQL state S1090: Almost connected to mysql via PHP/odbc

Hi, > -Original Message- > From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 02, 2001 2:03 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: SQL state S1090: Almost connected to mysql via PHP/odbc > > > Hello, > > thanks to the precious suggestio

SQL state S1090: Almost connected to mysql via PHP/odbc

Hello, thanks to the precious suggestions I had on this list some day ago, I have made some progresses, or at least have something new to report. I would like to ask now above the error mentioned in the subject, because I have not found it inside www.,mysql.com I have a database called m97. It

multi-table update

I'm wondering what is the best way to update one table based on another. Can joins be performed for an update? update table1 set table1.field2 = table2.field2 where table1.field1 = table2.field1; The alternative seams to be: select table2.field2 from table2; update table2 set table2.field2 = $

RE: MyODBC Problem with SQL2000 -> MySQL Data Transformation

Hi, > -Original Message- > From: Jack A. Fobel [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 01, 2001 3:22 PM > To: MySQL List > Subject: MyODBC Problem with SQL2000 -> MySQL Data Transformation > > > Hi Folks, > > I'm having a problem when I try to populate a MySQL database u

Help please :)

Hi, I'm trying to run mysql 3.23 on suse linux. I tried to upgrade using an rpm, but that didn't work. I've moved what files I can find from the old 3.22 install to an 'old' directory ( with no execute permissions ) I've reinstalled from a binary in a user dir, and followed the install instruc

Re: [MySQL] can you have a no-default column; error if unspecified?

At 09:36 PM 12/1/2001 -0700, Ashley M. Kirchner wrote: >Bennett Haselton wrote: > > > Is it possible to set a column to have no possible default value, so if > you > > try to create a record that doesn't specify a value for that column, > you'll > > get an error? > > Set it to NOT NULL NOT