win32 batch scripts

2002-10-08 Thread Todd Williamsen
i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: mysql

2002-04-08 Thread Todd Williamsen
SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02

RE: Do any of your applications work?

2002-04-06 Thread Todd Williamsen
I agree with everyone that has responded. A vague answer that does nothing but moan about something that is more or less incompentence from your developmental team. Not only that, but you have a support contract, so why you asking a question here? Shouldn't you be calling your support for this

RE: MySQL Book

2002-04-05 Thread Todd Williamsen
I agree with Chris... Writing a book on features that do not exist yet is asking for trouble. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Book On Friday 05

RE: Help. I have truly blundered.

2002-04-04 Thread Todd Williamsen
Wow John... Sounds like you are in deep chit... Just kidding... Linux 6 doesn't say which distro it is, same with mysql 3, there are a bunch of mysql version3s out there. Your problem... Log into as root then restart it. -Original Message- From: john [mailto:[EMAIL PROTECTED]]

RE: mysql forum

2002-04-02 Thread Todd Williamsen
How about newsgroups for php? They have a couple on php/mysql I believe and they respond quite quickly... Look at php.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE:

RE: Password function still doesn't working

2002-04-02 Thread Todd Williamsen
Im going to take a shot in the dark since I have not messed with ASP in years Have you just tried to verify the data is there with a simpler script? Just do the connection script then the user_check then see if it is still there. If it was PHP I would be able to find it. -Original

RE: Beginners Question

2002-04-01 Thread Todd Williamsen
Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find

RE: Why does my delete not work :(

2002-03-29 Thread Todd Williamsen
Here: ? $sql = DELETE [columumname] FROM [tablename] WHERE id = '$id'; That's your basic delete statement in PHP. -Original Message- From: sunny [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:18 PM To: Rodney Broom; [EMAIL PROTECTED] Subject: Re: Why does my delete not

RE: Why does my delete not work :(

2002-03-29 Thread Todd Williamsen
Sunny... Pay close attention.. You are trying to execute a query that is a bit complex for someone new to mySQL and PHP. $sql = SELECT messages.topicid FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid = 'NULL' $result =

RE: Why does my delete not work :(

2002-03-29 Thread Todd Williamsen
($result)) { $sql2 = DELETE FROM messages WHERE topicid = $row =[0] ; } -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:47 PM To: 'sunny'; 'Rodney Broom'; [EMAIL PROTECTED] Subject: RE: Why does my delete not work :( Sunny

RE: pb while querying in strange db name

2002-03-28 Thread Todd Williamsen
You need to use the use command Mysql \u [databasename] Now you may run the query Mysql select * FROM dbname.table; -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 4:25 PM Cc: [EMAIL PROTECTED] Subject: pb while querying in strange db

RE: MYSQL on a Cobalt RaQ4

2002-03-27 Thread Todd Williamsen
Yes, my hosting providers use raq servers and I have mysql databases on all of my domains -Original Message- From: Denis Croombs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:30 AM To: Mysql (E-mail) Subject: MYSQL on a Cobalt RaQ4 Hi Will MySQL run on a Cobalt RaQ4

RE: phpMyAdmin issue + looking for php/mysql websites

2002-03-26 Thread Todd Williamsen
Is there a reason why you are using IIS? I would disable IIS and run apache. That's what I did, IIS is way to difficult and unstable to install PHP as CGI or ISAPI Apache is easy to set up with PHP. Download Apache and run PHP from there. Make sure you disable ALL the IIS services

RE: phpMyAdmin issue + looking for php/mysql websites

2002-03-26 Thread Todd Williamsen
Read the documentation. Where is the mySQL database located? Is it on the web server or on another machine? If its on another machine then you put in the IP address. If its on the same machine as the Web Server, then put in localhost Get it? -Original Message- From: catriona

RE: phpMyAdmin issue

2002-03-26 Thread Todd Williamsen
The problem is PHP and IIS... IIS takes a lot to get it to work... I think you should ask sourceforge about it, not the mysql mailing list. This is a PHP issue not a mysql. -Original Message- From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 6:24 PM

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
I have found Win2k completely stable with Apache/PHP/mySQL. Not one issue! If you are talking IIS combo, then yes issues will arise. I don't see any performance hit on this setup as a CGI. I think you are being a bit bias towards Windoze. Windows 2k is quite stable. The thing about win2k is

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
Properties and select Disable in the drop down box -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:34 PM To: 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 Hi, if you think that IIS and Apache are going to have problems

RE: mysql/php on linux

2002-03-23 Thread Todd Williamsen
browser, I got Format error. Did I not do it right? Should I put it in my cgi-bin? Could some one send me a working php script and instruct me how to test it? Thanks From: Todd Williamsen [EMAIL PROTECTED] To: 'Andrew Hazen' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Todd Williamsen
Your client won't drop Access in favor of a faster, more secure database like mySQL? Why is your client stuck on Access? The data can be dumped and make the GUI web based to look just like the Access one... Stick in on a Intranet server, and lock it down... I would rather have that than a slow,

RE: NT service problem

2002-03-18 Thread Todd Williamsen
I ran the .exe file and WHAMMO! It installed itself as a service. I just needed to edit the service to have it automatically start at boot -Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 6:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]

RE: mysql/php on linux

2002-03-18 Thread Todd Williamsen
PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will

RE: IS THIS BETTER?

2002-03-17 Thread Todd Williamsen
Try turning the CAPs off first... Makes it easier to read... Second... You are using ADOB to connect to mySQL? Is that what you are doing? Using ASP? Try using PHP, easier to learn and is much more compatible with mySQL. ASP/mySQL can be used, but it’s a pain, plus ASP has its limitation

RE: problem in telent to mysql server

2002-03-14 Thread Todd Williamsen
Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL

RE: problem in telent to mysql server

2002-03-14 Thread Todd Williamsen
I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL

RE: mySQL connection problem!!!

2002-03-13 Thread Todd Williamsen
I think I read somewhere about this issue. I think it had to do with multiple mySQL servers running concurrently. See if there is multiple servers running using the ps command. If so, then kill one of them. Also, when adding a user, do you select a database first before adding a user?

RE: creating a password field..

2002-03-12 Thread Todd Williamsen
Peter, I have no idea what your front end is, and this is what will do the actual encryption, all mysql does is holds the data. So whatever your front end programming language is, it will have to do the encryption. Below is the link for php encryption

RE: Dropdown lists

2002-03-08 Thread Todd Williamsen
Josiah.. I think you are asking the wrong mailing list for this... I am assuming you are using PHP correct? Your explanation isn't all that clear, but I can guess what you are trying to do. You want to have a drop down list, but don't know what data type.. You can use VarChar or text for

RE: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Todd Williamsen
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am

RE: login and logout

2002-03-08 Thread Todd Williamsen
Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low.

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL

RE: Running MySQL as Service on 2000 Server

2002-03-07 Thread Todd Williamsen
I have no problem running mySQL as a service on Win2k Server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Running MySQL as Service on 2000 Server Hi, Anybody running MySQL on Win 2000

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
Hmm Isn't price one of the the factors in doing a comparision? No matter what project size it is, cost plays a major role. If I can save a client $3000 by using PHP versus using Lasso, I would. It doesn't seem Lasso has a $3000(or more) advantage over PHP/mySQL combo. The thing is that

RE: MS-DOS Window

2002-03-07 Thread Todd Williamsen
I don't have a problem and I am using 3.23.47 -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 PM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: RE: MS-DOS Window I tried using 'tee' in MySql but it's not working. mysql tee

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Todd Williamsen
Quite hilarious... Interesting.. Trying to compete versus PHP and they use php... Wild Whats next PHP website using ASP? -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 7:25 PM To: MySQL Subject: Re: Re: [ANN] Blue World Announces

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Todd Williamsen
Here is a blurb from the report of the white paper Lasso operates identically across platforms whereas with PHP, significant functionality is lost migrating from one platform to another. This makes it very difficult to develop on one platform and deploy on another when using PHP. Lasso's

RE: Query help please!

2002-03-05 Thread Todd Williamsen
Do you have another table with all the birthdates in it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Query help please! I need help writing query that would give me parent categories of

RE: Query help please!

2002-03-05 Thread Todd Williamsen
One more thing... What are you using to pull the data? PHP? Perl? Etc? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Query help please! I need help writing query that would give me parent

RE: connecting to all databases using one odbc connection..PLEASE HELP

2002-03-05 Thread Todd Williamsen
It won't let you since Windows ODBC only lets you create ONE DSN per DATABASE -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:11 PM To: MySql Subject: connecting to all databases using one odbc connection..PLEASE HELP I asked

RE: Commands...

2002-03-03 Thread Todd Williamsen
Stephane... What is the process you are trying to do? In order to do commands in dos Go to a command prompt: C:\ Type this: Cd \mysql\bin Now type this: Mysql Now you should see this Mysql Type this: \u name of your database; Now type in the command: Show tables; Make sure you

RE: After php udate, php pages no longer update MySQL database

2002-02-28 Thread Todd Williamsen
Which PHP version did you update to? I have noticed in PHP 4.1.1 is more anal about syntax -Original Message- From: Vernon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:30 PM To: php-list; MySQL-list Subject: After php udate, php pages no longer update MySQL database

RE: Dumping a MySQL DB Out to Access

2002-02-25 Thread Todd Williamsen
The problem is that the DB resides on a Unix box and he access it through a cgi program -Original Message- From: Luis Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: Dumping a MySQL DB Out to Access Hi, First of all, I'm not

RE: migrate Microsoft Access Data into MySQL

2002-02-24 Thread Todd Williamsen
Try myodbc? -Original Message- From: Admin [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 11:21 AM To: [EMAIL PROTECTED] Subject: migrate Microsoft Access Data into MySQL How to migrate Microsoft .mdb Database into MySQL under Unix environment?? Who can tell me?? Any

RE: database structure script

2002-02-24 Thread Todd Williamsen
Yes.. Use the DUMP command -Original Message- From: Pax [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 9:25 PM To: 'MySQL' Subject: database structure script Is there an easy way to create SQL script from existing database and use it to create a new database? Tks Pax

RE: database structure script

2002-02-24 Thread Todd Williamsen
I should have been more clear... http://www.mysql.com/doc/m/y/mysqldump.html -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 10:03 PM To: 'Pax'; 'MySQL' Subject: RE: database structure script Yes.. Use the DUMP command

RE: Comments in Documentation

2002-02-23 Thread Todd Williamsen
I don't think the manual is very amateur like. I find it very large, somewhat imformative. I find it like hell to understand if you are a novice -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:29 AM To: savaidis; [EMAIL PROTECTED]

RE: Inventory management system based on mysql

2002-02-20 Thread Todd Williamsen
No reason, you have the right idea especially if you are dealing with multiple platforms -Original Message- From: Cip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 8:54 AM To: [EMAIL PROTECTED] Subject: Inventory management system based on mysql Hi all, I am trying to

RE: About Regular Backup on MySQL

2002-02-19 Thread Todd Williamsen
If you are on a Windows box, you can create a batch job for it. If you are on Linux/Unix run a cron job -Original Message- From: Che WaiSam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: Re: About Regular Backup on MySQL Dear

RE: WIN/Linux Compatibility

2002-02-17 Thread Todd Williamsen
Alex, What I do is a DUMP on the table, either the schema or data or both. This will create a .sql file you can run again against whatever platform you are on -Original Message- From: Alex Charlton [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 3:55 AM To: mySQL Subject:

RE: How to save the table content into file

2002-02-17 Thread Todd Williamsen
Do you mean run a query that pulls all content in a table? OR Something that’s saves all content of a table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 8:52 AM To: [EMAIL PROTECTED] Subject: How to save the table content into

RE: How to save the table content into file?

2002-02-17 Thread Todd Williamsen
In phpmyadmin Choose the table from the list... Scroll down the main screen and you will see this: View Dump(schema) of table: You will have options like Structure only, Structure and data, CSV for MS Excel... Structure dumps the column names and all the field types... Structure AND data

RE: insert picture file in MySQL (+php)

2002-02-14 Thread Todd Williamsen
Reuben, You can store the images into a database, but no one recommends it. What I do, is actually store the location of the file in the database then have PHP open it. -Original Message- From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:08 AM

RE: insert picture file in MySQL (+php)

2002-02-14 Thread Todd Williamsen
The two biggest reasons why 1. Bloats the database 2. Slow at retrieving the images -Original Message- From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:30 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: Re: insert picture file in MySQL (+php

RE: forms?

2002-02-13 Thread Todd Williamsen
I personally use PHP which it would use your familiar web browser. You can also use PERL, and I believe ASP as well. PHP is easy for a front end and doesn't take much to develop! There is also a web based GUI for mySQL called phpmyadmin which is awesome if you know nothing about

RE: simple question on joining tables

2002-02-13 Thread Todd Williamsen
Yaniv, Set the field of user_id to INT then make the size 10 or larger, which will produce an ID size of up to 99. Now set it to auto increment then set the user_id field to Primary key, this should solve your problem, if I understand you correctly -Original Message- From:

RE: forms?

2002-02-13 Thread Todd Williamsen
Jim, I am still pretty wet behind my ears and I have always had problems with picking up the logic behind programming languages, but PHP is awesome! I had problems with the wacky structure of Visual Basic, and I hard a hard time just reading the code of C++ and Java. What helped me was a book

RE: How to access MySql using Perl. Help

2002-02-12 Thread Todd Williamsen
http://www.hotscripts.com Or http://www.scriptsearch.com Both sites show examples on how to contect to a database with perl or PHP. They also show how to connect to other databases! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002

RE: Load_File issue

2002-02-11 Thread Todd Williamsen
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I

RE: Bandwidth Throttling - a followup

2002-02-03 Thread Todd Williamsen
Yes, the other option is to move it to a server with more bandwidth :) Most People that are running it from home either don't know how or don't know that they are running a firewall or have an ISP that won't let them touch the configuration of the modem/router. So you are one of the lucky ones.

RE: Urgent Business Assistance.

2002-01-29 Thread Todd Williamsen
If its so urgent and private then why are you spamming a mail list? I smell scam, or is that Spam? -Original Message- From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 2:28 AM To: [EMAIL PROTECTED] Subject: Urgent Business Assistance. Urgent

RE: MySQL Checkbox table field

2002-01-25 Thread Todd Williamsen
VarChar Usually -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Checkbox table field Alright then! database,sql,query,table Which field type do I use for a simply checkbox Y,N?

RE: How does one put images into a MySql database

2002-01-22 Thread Todd Williamsen
If it’s a web based DB, then put the URL path in the text field of the DB. Otherwise if you put the images into the database, the database will become overwhelmed, plus a bunch of wasted disk space -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: Porting from MS SQL to MySQL

2002-01-18 Thread Todd Williamsen
I agree. I have more experience with MS SQL than mySQL, but there are some MS SQL specifics that can cause hiccups. But these hiccups can be avoided with a bullet proof project plan and excellent documentation. You may not be able to automate all the project procedures and a lot of the

RE: Porting from MS SQL to MySQL

2002-01-18 Thread Todd Williamsen
I would say it would take a month at least to complete the job correctly. I have seen some top OLAP developers take 3 months to complete a 30gb DB2 to an Essbase migration including all documentation and politics involved. Two hours? You should be fired for just thinking that! Just kidding.

RE: setting root psswd on Win2K ??

2002-01-10 Thread Todd Williamsen
Gerald... He isn't on a Unix box, he is on a Win2k box -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 8:46 AM To: Bryan Capitano Cc: [EMAIL PROTECTED] Subject: Re: setting root psswd on Win2K ?? You can't login as plain old nobody.

RE: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!!

2002-01-09 Thread Todd Williamsen
I deleted it too! Guess what, I don't miss it either! -Original Message- From: Reports [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:12 AM To: [EMAIL PROTECTED] Subject: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!! Dear Friend: The first time I

RE: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

2002-01-08 Thread Todd Williamsen
Just take the shortcut out of the startup menu -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my

Re: MySQL and COM+

2002-01-04 Thread Todd Williamsen
I think I read something about COM+. The statement I read said it is compatible, but I don't know about MSTDC, I would think that MSTDC would be a Microsoft propriotary interface. - Original Message - From: Patryk Choro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 04,

Re: Implement a menu structure using an relative database

2002-01-02 Thread Todd Williamsen
non data driven menus not an option? I have buit java-script menus that are pretty cool - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: 'Victor Spång Arthursson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 11:02 AM Subject: RE: Implement a

Re: Could you look at this PHP/MySQL Code?

2002-01-02 Thread Todd Williamsen
You could just do this: $result = ($sql3); echo $result; - Original Message - From: Michael Brunson [EMAIL PROTECTED] To: Matt Rudderham [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 1:35 PM Subject: Re: Could you look at this PHP/MySQL Code? On Wed, 2 Jan

Select statement with decimals as a record...

2001-12-29 Thread Todd Williamsen
I have a record that keeps track of averages, now when I say SELECT * FROM tblname ORDERBY 'average' DESC; It returns the one with the largest amount of intergers... I.E. It will say that 52.50 is a larger number than 358, why is that? Is that a table column setting of a datatype?

Re: Select statement with decimals as a record...

2001-12-29 Thread Todd Williamsen
I found an easier way... switch the datatype to decimal, WHAMMO!! works beautifully! - Original Message - From: Steve Rapaport [EMAIL PROTECTED] To: Todd Williamsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 7:03 PM Subject: Re: Select statement

UPDATE command, adding to exisiting record

2001-12-28 Thread Todd Williamsen
I am looking to update a record in a table, but take the exsisting value and adding the new value to it... I.e. Exsisting record = 150, new record being inputed = 250 for a total of 400 to be entered into the database. I have looked at the man pages on this but all it gives is static numbers,

Re: Location of text file for loading data in to table

2001-12-16 Thread Todd Williamsen
LOAD DATA LOCAL INFILE location of text file INTO TABLE [tablename] - Original Message - From: Inderpal Singh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 16, 2001 8:12 AM Subject: Location of text file for loading data in to table Hi, When using the command: LOAD

RE: Table Exists

2001-12-14 Thread Todd Williamsen
Mysqlshow tables; Would be the easy way Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:34 AM To: [EMAIL PROTECTED] Subject: Table Exists What

RE: new user basic questions

2001-12-10 Thread Todd Williamsen
programming language! Good Luck! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:28 PM To: [EMAIL PROTECTED] Subject: Re: new user basic questions From: [EMAIL PROTECTED

RE: Viewing table data in a webpage using ASP

2001-12-03 Thread Todd Williamsen
Here is your problem: MM_TrackoftheWolf_STRING = dsn=DSN Name;uid=User Id;pwd=Password; No space between Id;pwd Unless that is what happened when you copied and paste it Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Nick Boldt

RE: Avery Labels with MySQL

2001-12-02 Thread Todd Williamsen
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

RE: MySQL v.s. Oracle

2001-12-01 Thread Todd Williamsen
into several web servers/database servers and making it into a server farm? One server will get the snot knocked out of it with that kind of load. Just my $.02 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Philip Mak [mailto:[EMAIL

RE: How To Install Under MacOS X?

2001-11-29 Thread Todd Williamsen
I am going to take a stab at this... Since MacOS X is actually an open sourced kernel, I would assume you could use the Linux or Unix version to install it. I have not worked with MacOS X, but if I remember correctly it had a command prompt. Let me know if it works Thank you, Todd

RE: PHP / MySQL username and password creation

2001-11-29 Thread Todd Williamsen
What do you mean accept new users? Via adding new people to the MySQL user list or to a web application? Please specify.. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Anthony Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday

RE: synchronising mysql and access2k data

2001-11-21 Thread Todd Williamsen
Use myODBC to use an ODBC connection. If you are using a hosting provider on a Unix box, more than likely this will not work Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: dean browett [mailto:[EMAIL PROTECTED]] Sent: Wednesday

Dumb Question: Listing tables in telnet

2001-11-18 Thread Todd Williamsen
, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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

RE: How to Access MySql Database?

2001-11-15 Thread Todd Williamsen
Sounds like you have a TCP socket problem. Is the database on a local machine or a hosting provider? What platform is it on wintel or *nix? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Georgina Fang [mailto:[EMAIL PROTECTED]] Sent

RE: Need A book for dynamic website

2001-11-14 Thread Todd Williamsen
I bought PHP: Fast and Easy Web Development. Its pretty through and nice walk-throughs for a beginner. You may end up buying several books... This book helps you get your feet wet with PHP and MySQL, but it is no reference on everything. Thank you, Todd Williamsen, MCSE home: 847.265.4692

RE: Need A book for dynamic website

2001-11-14 Thread Todd Williamsen
Brian... You can SLAM yourself into a wall of confusion if you do not pick the right books that doesn't explain things to you like a two year old. I like books that explain things that way when I learn a new technology. It keeps the frustration away Thank you, Todd Williamsen, MCSE home

RE: lost in the Land of Oz Parking Lot (I hope this message makes it through!)

2001-11-08 Thread Todd Williamsen
Is this your email address? I can send you all the files you need. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 6:27 PM To: [EMAIL PROTECTED] Subject

RE: MySQL to MS' Access '97

2001-11-03 Thread Todd Williamsen
I have done Access to mySQL, but not the other way around... I guess you would need to export the table to a CSV file then import it into Access. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: MySQL to MS' Access '97

2001-11-03 Thread Todd Williamsen
You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import it into Access Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original

RE: Web Hosting

2001-11-01 Thread Todd Williamsen
I use www.ccwebhost.com for about two years... $13/mo for 200mb of space and their tech support is beyond excellent! mySQL support, CGI-BIN, FTP, PHP4, SSI, SSL, etc... Anything and practically everything! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original

Running Query

2001-10-31 Thread Todd Williamsen
default NULL, Modified By text ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'By text ) TYPE=MyISAM' at line 19 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before

RE: Running Query

2001-10-31 Thread Todd Williamsen
No, The column name should have been Modified By data type should have been text Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:20 AM To: 'Todd Williamsen

Connecting to a remote mySQL DB via telnet

2001-10-26 Thread Todd Williamsen
I am using Windows 2000 and MS decided to toss the GUI environment for it. Plus, I tried connecting like this: Connect host ip address:3306 How can I connect to my remote database that is on my hosting provider? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427

SELECT Query in PHP

2001-10-26 Thread Todd Williamsen
on this stuff, but they won't be here till at least Monday. HELP! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: SELECT Query in PHP

2001-10-26 Thread Todd Williamsen
my luck! Granted I am so new to PHP I think I just eclipsed the 48 hour mark... So am I still a rookie? Lol!! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:33 PM

MySQL for Dummies (newbies)?

2001-10-24 Thread Todd Williamsen
I come from a microsoft environment and never really had to deal with a command line based database before. All the documentation for MySQL doesn't make sense to a rookie and is frustrating... Anywhere to go where I can feel like I can learn something? Thank you, Todd Williamsen, MCSE home

MS Access to MySQL conversion? How?

2001-10-22 Thread Todd Williamsen
that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list