Bug or error in SQL syntax - Specifying and using a user variable inside a single select query

2002-05-06 Thread Gregg Graubins
) == Does anyone have any insights or clues as to what the problem could be? Thanks in advance! === Gregg Graubins [EMAIL PROTECTED] (PGP key available) - Before posting, please check: http://www.mysql.com

Re: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query

2002-05-06 Thread Gregg Graubins
Gregg, Monday, May 06, 2002, 6:57:55 PM, you wrote: GG Upon reading into the user variables section of the mysql manual, I decided GG to make my life easier inside several of my queries by specifying some user GG variables. Note that I'm trying to have everything inside the select GG

Re: Password error

2001-09-06 Thread Gregg Baker
Someone the other day said this worked: started safe_mysqld with --skip-grant-tables and then did: mysql -u root mysql mysql UPDATE user SET password=PASSWORD('abc') WHERE User='root' - AND Host='whichever host you want to match' - Original Message - From: Mike Ryerse [EMAIL

Thanks [root password]

2001-08-30 Thread Gregg
Snitz Forum 2000 is working great now! I don't know exactly what I did though. It never did run the setup.asp exactly as it should. A combination of MySQL root password privileges, GRANTS, UPDATES, just the right chmods and trying setup.asp, setup.asp?RC=5, setup_login.asp got it done. I want to

Re: Problems getting into MySQL.com

2001-08-29 Thread Gregg Baker
yes, i just tried and failed - Original Message - From: Philip Daggett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 9:50 AM Subject: Problems getting into MySQL.com Is anybody else not able to get onto mysql.com???

USE UPDATE and root password

2001-08-29 Thread Gregg Baker
) ) === ... and many more 3704 errors Now if I enter root and leave password blank, it says Installation Complete and has a test database link, I take the link and it's back to the need to logon error page. I am posting this at the Snitz forum and the mysql list. Thank you very much, eeehaah/Gregg Baker

Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) I believe I found the answer in the archives, but they all aren't the same answer. So is the

Re: Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I got a No Database Chosen. What's the syntax for adding the database? I tried *.*, mysql, and test between UPDATE and user but all returned syntax error. Thanks much, Gregg UPDATE user SET Password=PASSWORD(desiredpasswordhere) WHERE User=root

Re: format masks for a Masked edit control

2001-02-21 Thread Gregg Housh
I would also like to add to this, that I think it would be a good addition to the documentation. Gregg - Original Message - From: Gregg Housh [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 4:08 PM Subject: format masks for a Masked edit

format masks for a Masked edit control

2001-02-20 Thread Gregg Housh
. I just dont seem to be good at getting them right. Gregg

Re: Embedded MySQL: Opinion Please

2001-02-15 Thread Gregg Housh
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message

Re: Boolean Datatype

2001-02-06 Thread Gregg Housh
http://www.mysql.com/doc/A/d/Adding_functions.html Could this help him out? Creating a User Defined Function? Gregg - Original Message - From: Russ Davies [EMAIL PROTECTED] To: Matt Friedman [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 3:42 PM

Re: Boolean Datatype

2001-02-06 Thread Gregg Housh
Let me add to this. I meant to say: He could create a function that would do it, and use it in his queries? Gregg - Original Message - From: Gregg Housh [EMAIL PROTECTED] To: Russ Davies [EMAIL PROTECTED]; Matt Friedman [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday

Re: 'USE_RAID' in mysql-3.22.32?

2001-01-29 Thread Gregg Housh
In the create table documenttation, it explains the USE_RAID, and a few other options pertaining to it. Gregg - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 4:22 PM Subject: 'USE_RAID' in mysql-3.22.32? In pawing though