an Systems Corporation
301-925-3222 x375
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:42 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Error in SELECT
Please note...the values that don't have ' ' are int type.
Please note...the values that don't have ' ' are int type.
Here is the error bellow:
SELECT * From LearnerDetails WHERE Title='Mr' AND FName='Natasha' AND
LName='Burkenshaw' AND Add1='17 Cromer Road' AND Town='Hornchurch' AND County='Essex'
AND PostCode='RM11 1EY' AND CurrentlyEmployed= AND Tel
See Notes
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 14:01
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Error in SELECT
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "
SELECT *
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "SELECT * From LearnerDetails WHERE Title='" & sTitle & "' AND FName='"
& sFName & "' AND LName='" & sLName & "' AND Add1='" & sAdd1 & "' AND Add2='" & sAdd2
& "' AND Town='" & sTown & "' AND County='" & sCounty &"
On 26.02.2001 14:19:40 TisSoft s.c. wrote:
> PRIMARY KEY (SYMBOL),
> UNIQUE SYMBOL (SYMBOL)
What's the sense of this? PRIMARY is already UNIQUE, so you don't need to
UNIQUE symbol again.
-
Before posting, please check:
are
returning different interpretations of the stored data.
> -Original Message-
> From: TisSoft s.c. [SMTP:[EMAIL PROTECTED]]
> Sent: 26 February 2001 13:20
> To: [EMAIL PROTECTED]
> Subject: Error in "select from where..." with BDB
>
> &
>Description:
I made a table:
CREATE TABLE parametry (
SYMBOL varchar(30) DEFAULT '' NOT NULL,
WART blob DEFAULT '' NOT NULL,
PRIMARY KEY (SYMBOL),
UNIQUE SYMBOL (SYMBOL)
) type=BerkeleyDB;
then I put some values in it:
INSERT INTO parametry (SYMBOL, WART) VALUES
('D