[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: [OT] Can someone fix the sql query for me please
Use the SET operator once with a comma between ie
sql = "UPDATE Site " _
& "SET Site='"& NewSite &"' ," Builder
='"& NewBuilder &"' " _
& "WHERE Site LIKE '"& Site &"' "
On 28/03/06, Dean Barrett <dean@xxxxxxx> 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
>
>
>
>
>
>
>
>
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|