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 this

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 platform

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 Lasso

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 f

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 peop

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 ser

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 PROTECTED]]

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. H

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 yesterday

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 ca

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 catI

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 foll

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 a

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..

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: 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 Doc??

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] Su

RE: MySQL PHP Development IDE

2002-02-21 Thread Todd Williamsen
There is three options I use: 1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension 2. PHPEdit, its free I forget the website. It’s a good IDE, but kinda annoying editor. 3. Notepad -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22

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 Sir/Ma

double outer joins in mysql?

2002-02-18 Thread Todd Goldenbaum
s even possible? thanks, todd - 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]> T

sql: Copying the structure of DBs

2002-02-18 Thread Todd Ellner
em to. Any suggestions? Is there a quick way to do this in MySQL? Or will I have to do something kludgy like parsing the output of a mysql "DESCRIBE" statement and making a create statement out of it? Todd - Before p

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: 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 f

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: Fw:

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: 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 To:

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: 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: [EMA

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 administering

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 inst

RE: Duplicate Records

2002-02-10 Thread Todd Williamsen
First off, You would need to add an "id" field, then set it to a primary key, then set it to "auto_increment" This will order them correctly -Original Message- From: Rich [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 10:31 AM To: MySql Subject: Duplicate Records How does

RE: Load_File issue

2002-02-06 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 inst

replicate-ignore-table

2002-02-06 Thread Todd Newbold
Hi everyone, When using replicate-ignore-table in mysql, does filtering happen before or after transmission from the master to the slave? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manu

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 Busi

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? Tha

Error in accept: Bad file descriptor

2002-01-22 Thread Todd Ratson
en I query the db: SQL-query : SHOW TABLE STATUS FROM `sample` MySQL said: Can't read dir of './sample/' (Errcode: 9) The console is reporting the following error: 020122 10:50:35 Error in accept: Bad file descriptor mysql then crashes and I need to restart it. I am runnin

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, Januar

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. T

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 database

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. The

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 receive

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 w

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

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

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: Imple

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

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? -

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

RE: Table Exists

2001-12-14 Thread Todd Williamsen
Mysql>show 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 is

RE: new user basic questions

2001-12-10 Thread Todd Williamsen
end than VB or any other 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

replicate-do-table

2001-12-07 Thread Todd Newbold
Hello everyone, How does mysql replication handle the replicate-do-table config option? Does the binlog get filtered before transmission, or once data is received by the slave? Thanks Todd - Before posting, please

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:

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: 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: 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: 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
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 archive) To request this

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
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

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,

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
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: 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: 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

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

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 --

RE: web-based interface for manipulating MySQL tables?

2001-10-30 Thread Todd Williamsen
No PHPadmin has two versions PHP3 and PHP Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 2:39 PM To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett

RE: SELECT Query in PHP

2001-10-26 Thread Todd Williamsen
Just 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

SELECT Query in PHP

2001-10-26 Thread Todd Williamsen
ks 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 manua

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 :<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.86

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

Comma delimited files (CSV files) automatically inseted into database?

2001-10-24 Thread Todd Williamsen
Is this possible? I tried it, and the format is all garbled... I have an application that outputs data into a CSV file and was wondering of a way to have it automatically inserted into a database with it formatted for the query of those results. Thank you, Todd Williamsen, MCSE home

MS Access to MySQL conversion? How?

2001-10-22 Thread Todd Williamsen
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

No combination of basedir and datadir seems to work

2001-10-01 Thread Todd Merriman
(errno: 13) >How-To-Repeat: Problem can easily be repeated using above steps. >Fix: Have found no work arounds. Tried linking /var/lib/mysql/var to /var/lib/mysql, but that did not work. >Submitter-Id: >Originator:Todd Merriman >Organization: So

RE: Select dates from Table 1 not in Table 2

2001-09-23 Thread Adam Todd
> At 11:55 23/09/01 +1000, you wrote: > Thanks Will for the suggestion, however as per my private email to you, it > didn't work successfully to any degree. Actually it knocked out ONE date > from the "same" group and that was one of the Available dates. I'll take my foot out of my mouth now

RE: Select dates from Table 1 not in Table 2

2001-09-22 Thread Adam Todd
ably, the fact that it takes 4 steps may not be as simple as you >would like... but with only a max of 200 output records, it should be plenty >fast. > > > -Original Message- > > From: Adam Todd [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 21, 2001 12:29 AM

Select dates from Table 1 not in Table 2

2001-09-20 Thread Adam Todd
Hi all, just subscribed. Normally I work these out for myself, but time and frustration are winning. I have two tables: SCHEDULE which contains a column called "date" and in that are DATETIME entries from 2001-09-14 to who cares. NONAVAIALBLE which contains users and dates they aren't availa

cross-updates with replication

2001-08-31 Thread Todd Goldenbaum
he replicate-wild-do-table line AND replicate-do-db=test just to see, and then with replicate-do-db=test all by itself, and they all work, but none of the three are working with cross-database queries! anyone know what am i doing wrong

Re: Install help for x86 Solaris 8

2001-06-14 Thread Todd Merritt
at I built on a solaris sparc box, trying to compile many different programs. It turns out that the problem was having /usr/ucblib in my load path when I compiled gcc. Recompiling it without that in the path seemed to make the error go away. Todd

error reading communication packets

2001-06-13 Thread Todd Merritt
no solutions (excpet one for replication, which we are not using). Any help would be appreciated. Here is the variable list from the server. Thanks, Todd +-+-+ | Variab

use DBI

2001-05-17 Thread Todd Marks
I'm trying to get the perl script below to write to my database. It didn't work and the error log showed that it got hung up at line 8 (use DBI). any ideas why? #!/usr/bin/perl -w my $name = 'mel'; my $email = '[E

Re: simple perl script

2001-05-17 Thread Todd Marks
ll it keep dumping the data into new rows, or will the old data be written over? -t > On Thu, May 17, 2001 at 12:58:17PM -0500, Todd Marks spake thusly: > *] #!/usr/bin/perl -w > *] > *] use strict; > *] use CGI qw(:standard); > *] use DBI; > *] > *] # change undef(s

simple perl script

2001-05-17 Thread Todd Marks
hello, just want to start off saying that I am a complete newbie to mysql-sorry. I have a perl script that I am simply trying to dump three variables(name CHAR(30), email(50), and score INT) to a database table that has already been established. having some difficulty and wanted to post t

Dynamic Custom Sort Orders

2001-03-22 Thread Michael Todd Glazier
r than RAND()), so I'm wondering if a cleaner solution lies there. Any thoughts would be appreciated Peace, Michael Todd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Creating bitmask for SELECT against type SET

2001-03-18 Thread Todd Markle
Recently, I'm having to match against SET columns quite a bit. Is there a fast way to create a bitmask of set data? For example: A user table has interests as set ('ABX','BX','CXX'...) I want to select users where interests include ('CXX','NNX'...) Method 1: select them one at a time SEL

Problems with MySQLGUI 1.7 and ssh

2001-02-28 Thread Todd A. Jacobs
ould the client require X services from the database host? If it's something else, how can I fix it? Why can't I connect? I'm really frustrated. -- Todd A. Jacobs CodeGnome Consulting, LTD - Before posting, please c

RE: Help, Server error.

2001-02-18 Thread Mike Todd
Well, could it be that this network is a wierd set-up. Ip-masq? so mabye it is having troubles with hostnames or something. hmm... As far as the physical network, yes I can rule it out. A sledge hammer might work (I've been looking for a new server anyway ) -Mike --

RE: Help, Server error.

2001-02-18 Thread Mike Todd
, 2001 5:00 AM To: Mike Todd Cc: [EMAIL PROTECTED] Subject: Re: Help, Server error. On Sun, Feb 18, 2001 at 04:35:29AM -0500, Mike Todd wrote: ? >I am getting an error that I do not know how to resolve. I have looked > though all the .docs, this is my last resort (it's 4:30AM). Th

Help, Server error.

2001-02-18 Thread Mike Todd
orted connection 17 to db: 'mysql' user: 'root' host: `localhost' (Got an error writing communication packets) any ideas? Thanks, Mike Todd - Before posting, please check: http://www.mysql.com/man

Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length

2001-01-29 Thread Todd Grigsby
, A-Z, slashes, dots, dashes, etc., for a total of 64 different characters. You could squeeze 341 characters into the 256. Or you could slam your thumb in the door. The pain is similar albeit more localized... Good luck. Todd Grigsby --

<    1   2   3