[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: [OT] Can someone fix the sql query for me please
AND "SET
isn't that an extra quote?
ie shouldn't it be:
AND Set Builder="blah"
Andy
*********** REPLY SEPARATOR ***********
On 28/03/2006 at 14:27 Dean Barrett wrote:
>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]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.385 / Virus Database: 268.3.1/291 - Release Date:
24/03/2006
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|