RE: problem when try to insert into mysql db using ASP

2002-07-15 Thread Nick Middleweek
Can you send me the asp page as an attachment? Nick :> -Original Message- :> From: Ivan Paul [mailto:[EMAIL PROTECTED]] :> Sent: 16 July 2002 04:53 :> To: MySQL :> Subject: problem when try to insert into mysql db using ASP :> :> :> hi all, :> :> i have problem when try to insert into m

RE: pulling information from 2 tables based on information from first select

2002-07-15 Thread Nick Middleweek
SELECT sd.month, sd.day, names.who, names.uid, sd.type FROM specialdays as sd INNER JOIN names ON names.uid = specialdays.uid WHERE sd.month=6 AND sd.day=5 Give that a whirl to start with. I've assumed the field on the specialdays table that links to the names table is also called uid. Or are

Setting a user to only see certain databases?

2002-07-15 Thread Nick Middleweek
Hello, Here's what I'd like to do... * Create a new user in mysql. * Let them login and create a new database. * I want this database to be only viewable by the user that created it and also the mysql administrator. * I would like that user to be able to create users as well but they can

RE: Interesting

2002-07-15 Thread Nick Middleweek
I'm using version 3.23.53 on Win 2k. The same things happens to me. I've also noticed that if you don't specify a WHERE clause and you have a Auto-incrementing ID field, it is reset to zero and the next record you create starts at 1 again. Surely this is wrong as well? In Other RDBMS's after DE