[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
[OT] Can someone fix the sql query for me please
- Subject: [OT] Can someone fix the sql query for me please
- From: "Dean Barrett" <dean@xxxxxxxxx>
- Date: Tue, 28 Mar 2006 14:27:49 +0100
Cant make this work
sql = "UPDATE Site " _
& "SET Site='"& NewSite &"' " AND "SET
Builder ='"& NewBuilder &"' " _
& "WHERE Site LIKE '"& Site &"' "
Get error :
Syntax error (missing operator) in query expression ''Between Streets,
Cobham' SET Builder ='The Homes''.
I can just about manage v.simple sql queries, but not when there's more
than
one thing :)
If i have one SET its ok - just cant get two to work...
Dean.
[Non-text portions of this message have been removed]
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|