Re: Coldfusion?

2002-01-11 Thread Bryan Capitano
. I'm not sure if there's a place to get MySQL drivers for ColdFusion? I haven't tried. The My-ODBC drivers might work. I don't know. Bryan Capitano MSL wrote: > Quick Newbie question: > > Can I use MySQL with Coldfusion server? If yes, are there any limitations or &

Re: setting root psswd on Win2K ??

2002-01-10 Thread Bryan Capitano
assword for 'anonymous' login or dissabled it > therefore any login can alter anything > be sure to fully read the section on security and you'll find an answer to > your securityleak > > btw after dopping table 'user' I think you might have to reinstall My

setting root psswd on Win2K ??

2002-01-09 Thread Bryan Capitano
Having some problems setting root password on MySQL. Can anybody help me? I've just installed MySQL 3.23.38 on a Windows 2000 server. I'm following the directions in the documenation for setting the root password: >mysql -u root mysql mysql>UPDATE user mysql>SET password=password('mynewpass') my

Re: Need A book for dynamic website

2001-11-14 Thread Bryan Capitano
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: 847.265.4692 > Cell: 847.867.9427 > > -Original Message- > From: Bryan Capita

Re: Need A book for dynamic website

2001-11-14 Thread Bryan Capitano
My experience with DuBois's book is that it's GREAT for MySQL, especially when you want to interface with MySQL at the server level -- with C or C++ for example. But for PHP/MySQL or using MySQL at any level of web interfacing, this book just doesn't do it. Erik Price wrote: > When I was just s

Re: Need A book for dynamic website

2001-11-14 Thread Bryan Capitano
books make a SLAMMING dynamic duo. You just can't fail with them. Bryan -- CAPITANO WEB CONSULTING http://www.capitanoweb.com Webmaster wrote: > Hi, > I need a book to teach me how to make a database driven website, I think php > mySql is the way to go and have seen some on amaz

Consequtive, Sequential auto-increment?

2001-11-14 Thread Bryan Capitano
When I delete items from a table where I've got an auto-incremented primary key/index, call it table_id, I'd like to keep this column consequtive and sequential. In other words, when I delete items from the middle, then the column is no longer "sequential" because there is a number missing. Is the

Need help with mysqldump

2001-11-14 Thread Bryan Capitano
I'm running MySQL ver 3.23.38 on Win98 platform and am trying to learn to do backups. I'm trying the mysqldump command but I'm getting the error: Access denied for user '@localhost' How do I specify a user for mysqldump? Thanks, Bryan ---

subqueries?

2001-07-27 Thread Bryan Capitano
Do any of the newer versions of MySQL support sub-queries yet? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: can't connect through socket using PHP script

2001-07-27 Thread Bryan Capitano
Usually this means your MySQL daemon, mysqld, is not started. Which OS are you using? Under RedHat Linux, you can get your mysqld running on init runlevels 3 and 5 (network services with and without X-windows) this way: % chkconfig --level 35 mysqld on % /etc/init.d/mysqld start check to make su

CREATE SEQUENCE

2001-07-26 Thread Bryan Capitano
Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - Before posting, please check: http://www.mysql.com