SV: Newsgroup ???

2001-09-27 Thread Ann Myhre

I am not sure, but it seems like the newsgroup mailing.database.myodbc is the same as 
this mailinglist? (Sorry if I create confusion, I am not quite sure I understand what 
you ask for.)

Ann 

- Original Message - 
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Christopher Raymond [EMAIL PROTECTED]
Cc: MySQL Mailing List [EMAIL PROTECTED]
Sent: Thursday, September 27, 2001 7:31 AM
Subject: Re: Newsgroup ???


 On Tue, Sep 25, 2001 at 03:02:30PM -0500, Christopher Raymond wrote:
 
  MySQL Gurus:
 
  Is there a newsgroup server for this discussion list?
 
 I don't think so.
 
 Jeremy
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
 
 MySQL 3.23.41-max: up 21 days, processed 395,493,570 queries (217/sec. avg)
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Access as frontend with MyODBC

2001-09-26 Thread Ann Myhre

Hi group
I don't know if my problem is Microsoft or MySQL so i try here first. 
 
I have installed MySQL and MyODBC on the same machine as I have Access. I would like 
to connect to MySQL using Access as frontend, but when I have done the whole procedure 
with ODBC, I get a message, saying: Filedataname is not saved. And when it is not 
saved, I wont find it, of course.Is there some reason to why it will not save it?
 
Ann 
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Enum

2001-09-17 Thread Ann Myhre

Hi group

Access has a datatype (I don't remember the name) which is a kind of boleaen; it 
represents Yes/No, true or false. When I try to translate that creating a table in 
MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y 
then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result.
Anyone?

Ann 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




SV: Renaming Columns...

2001-09-12 Thread Ann Myhre

Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you 
privatly. Sorry about that!)

ALTER TABLE table1
CHANGE column1 coloum2 varchar(20) not null [or what ever datatype]; 

gives you what you want.

Ann 

- Original Message - 
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 12:00 AM
Subject: Renaming Columns...


 How??? ALTER TABLE table1 RENAME ???
 Tried it, dont work.
 
 - Deryck H
 - http://www.comp-u-exchange.com
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php