it doesn't work... maybe problem lies in W2k where mySQL server is
installed?
Mariusz Muszalski
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 21 August 2001 11:39
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: mySQL a
ULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table 'results'
#
INSERT INTO results VALUES (1,22);
INSERT INTO results VALUES (1,22);
INSERT INTO results VALUES (1,23);
INSERT INTO results VALUES (1,24);
INSERT INT
my question was not about subqueries
Mariusz Muszalski
> -Original Message-
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: 15 August 2001 16:29
> To: Mariusz Muszalski; [EMAIL PROTECTED]
> Subject: RE: MySQL + VB problem
>
>
> Hi !
>
> MySQL doesn
n one query in one time... should I use
above instead ???
strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order
by Date ASC LIMIT 1;"
Set RS = Conn.GetRS(strSQL)
strSQL = "SELECT @BL:= Date From Results Where GameID=" & GameID &
following:
If ( @n >0 )
{
INSERT INTO Results
(
GameID,
Date,
Number
)
VALUES
(
1,
@Date,
@Number
)
}
Cheers,
Mariusz Muszal
syntax
Questions: is there only TEMPORARY TABLE way for make it? What is wrong with
this UPDATE?
Cheers,
Mariusz Muszalski
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
