RE: transaction support

2004-01-19 Thread Bryan Koschmann - GKT
Hi Chris, My apologies, I didn't correctly explain what I was looking for. I mean more of a solution to creating a client program. I'm thinking of php-gtk but not sure how well this works under windows, especially for printing reports. Thanks, Bryan On Sat, 17 Jan 2004, Chris Nolan wrot

RE: transaction support

2004-01-16 Thread Bryan Koschmann - GKT
I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he

ISP and users

2004-01-16 Thread Bryan Koschmann - GKT
Hello, I run an ISP where our web customers have access to the MySQL server. When they want a database, they request it through me and I add it. I was just curious if this is the common way it is done, or if there is a safe way they can add their own? Thanks, Bryan -- MySQL General Ma

RE: transaction support

2004-01-05 Thread Bryan Koschmann - GKT
On Mon, 5 Jan 2004, Craig Vincent wrote: > Although this doesn't answer your initial request...why are you wanting to > 'argue' with this guy over the database to use. If he won't code for the > application to use MySQL (which isn't all that hard in VB regardless of what > he says) then get

transaction support

2004-01-05 Thread Bryan Koschmann - GKT
Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still bug

Invoicing (paper)

2003-02-27 Thread Bryan Koschmann - GKT
Hello, I think this is fairly on-topic, but does anyone know of or use a [free] invoice program that uses MySQL? I need to setup something for my Dad that is quick and easy to use. Doesn't need to have all that much, just simple things, as I would probably modify it down to what it needs to be. T

Re: decimal type

2003-02-21 Thread Bryan Koschmann - GKT
c) I read the docs on the decimal type, but I dont quite understand it. Thanks, Bryan On Fri, 21 Feb 2003, gerald_clark wrote: |Show us. |We have no idea how you defined your tables, |loaded your data, or structured your query. | |Brya

Re: decimal type

2003-02-21 Thread Bryan Koschmann - GKT
Hello, I'm creating a table where one column will be prices. How is this type supposed to work? I tried it, loaded the data, and it cuts it off at the decimal when I run a query. How can I get this to store correctly? Thanks, Bryan -

Re: What is needed for ODBC?

2003-02-21 Thread Bryan Koschmann - GKT
Thank you! I suppose I should have tried it first, I was just assuming there was something more to be done. Works great! Thanks, Bryan On Fri, 21 Feb 2003, KH Chiu wrote: |All you need to do is set up a MySQL user that allow the Windows box to |access the MySQL database. | |Regards, |

What is needed for ODBC?

2003-02-20 Thread Bryan Koschmann - GKT
Hello, I hope it is okay to ask this here. I have a MySQL server running on Slackware 8, and I would like to access it from a Windows box using Excel (for now). I'm downloading the ODBC driver for windows, but is there anything I need to do on the MySQL server side? I'm a bit confused about that.

hints for converting to mysql

2002-10-13 Thread Bryan Koschmann - GKT
Hello, Does anyone have any pointers or links to "how-tos" for converting from a microsoft sql server to mysql? I know it's much more complicated than simply "converting", but I was just looking for pointers. Basically we have an accounting system that was written for us by an employee. Hes a Mic

padding field with zeros

2002-10-12 Thread Bryan Koschmann - GKT
Hi, Does MySQL provide for any way to "pad" a field? I have accounts numbers that vary from 3-5 digits, and would like them 8 digits padded by zeros (479 becomes 0479, 17234 becomes 00017234, etc). I know I could probably write a script to fix that before entering the data into the database,

Re: Creating new users

2002-09-18 Thread Bryan Koschmann - GKT
On Wed, 18 Sep 2002, Shravan Durvasula wrote: |Hi all, |I have MySQL server installed in Solaris 2.8. |1. How can i change the existing password for a user? |2. How can i delete an existing user? |3. How can i create a new user and associate a |password for that new user? I believe the documenta

OT? mysql_init error w/ perl

2002-09-18 Thread Bryan Koschmann - GKT
Hello, I'm sorry for posting this here. I tried the msql-mysql-modules list but mine was the only message posted within the past few days, so I doubt I'll be getting any help :) I am getting the following error while trying to run a perl script to access some information. DBD::mysql seems to hav

ODBC ADO and microsoft

2002-09-16 Thread Bryan Koschmann - GKT
Hi, We have an accounting program that was writting in visual basic and runs on microsoft sql. I was told it uses ADO by the programmer (please note, I'm not all up on this subject as I should be). I'm wondering if it would be possible to connect to it somehow from a mysql client and do some simp

Looking for opinion

2002-09-05 Thread Bryan Koschmann - GKT
Hello, I'm new to this list, and actually rather new to MySQL. I am still in the process of learning, but I wanted an opinion on something... I was curious what you would all think of creating a rather simple checkbook register using mysql? From my (rather limited) knowledge, it would seem fairl