Syntax error (missing operator) in query expression'idProperty='

[David Wapnick]

The following is the code, can someone please help me with the syntax please
in the first line please

Conn.Execute "UPDATE tblRentalProperty SET " _
& "tblPropertyType = '" & tblPropertyType & "', " _
& "tblRooms ='" & tblRooms & "', " _
& "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
& "tblImage = '" & tblImage & "', " _
& "tblBriefDescription = '" & tblBriefDescription & "', " _
& "tblDetailedDescription = '" & tblDetailedDescription & "', " _
& "tblStatus = '" & tblStatus & "', " _
& "tblAddress1 = '" & tblAddress1 & "', " _
& "tblAddress2 = '" & tblAddress2 & "', " _
& "tblAddress3 = '" & tblAddress3 & "', " _
& "tblAddress4 = '" & tblAddress4 & "', " _
& "tblPostCode = '" & tblPostCode & "', " _
& "tblCountry = '" & tblCountry & "', " _
& "idArea = '" & idArea & "', " _
& "Deleted = '" & Deleted & "' WHERE " _
& "idProperty = " & ID

[Ken Schaefer]

a) First, allocate the string to a variable, and response.write() the value,
so you can see what's being sent to the database.

eg:

<%
strSQL = "UPDATE tblRentalProperty SET " _
& "tblPropertyType = '" & tblPropertyType & "', " _
& "tblRooms ='" & tblRooms & "', " _
& "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
& "tblImage = '" & tblImage & "', " _
& "tblBriefDescription = '" & tblBriefDescription & "', " _
& "tblDetailedDescription = '" & tblDetailedDescription & "', " _
& "tblStatus = '" & tblStatus & "', " _
& "tblAddress1 = '" & tblAddress1 & "', " _
& "tblAddress2 = '" & tblAddress2 & "', " _
& "tblAddress3 = '" & tblAddress3 & "', " _
& "tblAddress4 = '" & tblAddress4 & "', " _
& "tblPostCode = '" & tblPostCode & "', " _
& "tblCountry = '" & tblCountry & "', " _
& "idArea = '" & idArea & "', " _
& "Deleted = '" & Deleted & "' WHERE " _
& "idProperty = " & ID

Response.Write(strSQL)
Response.End
%>

b) Then check here for explanations of the cause:
[url]http://www.adopenstatic.com/faq/80040e14.asp[/url]

Cheers
Ken

"David Wapnick" <david.wapnick@btinternet.com> wrote in message
news:bl675k$9li$1@sparta.btinternet.com...
: The following is the code, can someone please help me with the syntax
please
: in the first line please
:
: Conn.Execute "UPDATE tblRentalProperty SET " _
: & "tblPropertyType = '" & tblPropertyType & "', " _
: & "tblRooms ='" & tblRooms & "', " _
: & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
: & "tblImage = '" & tblImage & "', " _
: & "tblBriefDescription = '" & tblBriefDescription & "', " _
: & "tblDetailedDescription = '" & tblDetailedDescription & "', " _
: & "tblStatus = '" & tblStatus & "', " _
: & "tblAddress1 = '" & tblAddress1 & "', " _
: & "tblAddress2 = '" & tblAddress2 & "', " _
: & "tblAddress3 = '" & tblAddress3 & "', " _
: & "tblAddress4 = '" & tblAddress4 & "', " _
: & "tblPostCode = '" & tblPostCode & "', " _
: & "tblCountry = '" & tblCountry & "', " _
: & "idArea = '" & idArea & "', " _
: & "Deleted = '" & Deleted & "' WHERE " _
: & "idProperty = " & ID

[Atrax]

do this :

strSQL = "UPDATE tblRentalProperty SET " _
& "tblPropertyType = '" & tblPropertyType & "', " _
& "tblRooms ='" & tblRooms & "', " _
& "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
& "tblImage = '" & tblImage & "', " _
& "tblBriefDescription = '" & tblBriefDescription & "', " _
& "tblDetailedDescription = '" & tblDetailedDescription & "', " _
& "tblStatus = '" & tblStatus & "', " _
& "tblAddress1 = '" & tblAddress1 & "', " _
& "tblAddress2 = '" & tblAddress2 & "', " _
& "tblAddress3 = '" & tblAddress3 & "', " _
& "tblAddress4 = '" & tblAddress4 & "', " _
& "tblPostCode = '" & tblPostCode & "', " _
& "tblCountry = '" & tblCountry & "', " _
& "idArea = '" & idArea & "', " _
& "Deleted = '" & Deleted & "' WHERE " _
& "idProperty = " & ID

Response.Write strSQL
Conn.execute strSQL

that'll show you EXACTLY what's being passed to the DB - and you're more
likely to spot the error that way - a very commonly used debugging trick
and one to remember.



________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[David Wapnick]

I have to say that your response was great and I have solved the problem,
many thanks to you.

Regards,

David

"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:O30ZF3ZhDHA.3868@tk2msftngp13.phx.gbl...

> a) First, allocate the string to a variable, and response.write() the

value,

> so you can see what's being sent to the database.
>
> eg:
>
> <%
> strSQL = "UPDATE tblRentalProperty SET " _
> & "tblPropertyType = '" & tblPropertyType & "', " _
> & "tblRooms ='" & tblRooms & "', " _
> & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
> & "tblImage = '" & tblImage & "', " _
> & "tblBriefDescription = '" & tblBriefDescription & "', " _
> & "tblDetailedDescription = '" & tblDetailedDescription & "', " _
> & "tblStatus = '" & tblStatus & "', " _
> & "tblAddress1 = '" & tblAddress1 & "', " _
> & "tblAddress2 = '" & tblAddress2 & "', " _
> & "tblAddress3 = '" & tblAddress3 & "', " _
> & "tblAddress4 = '" & tblAddress4 & "', " _
> & "tblPostCode = '" & tblPostCode & "', " _
> & "tblCountry = '" & tblCountry & "', " _
> & "idArea = '" & idArea & "', " _
> & "Deleted = '" & Deleted & "' WHERE " _
> & "idProperty = " & ID
>
> Response.Write(strSQL)
> Response.End
> %>
>
> b) Then check here for explanations of the cause:
> [url]http://www.adopenstatic.com/faq/80040e14.asp[/url]
>
> Cheers
> Ken
>
> "David Wapnick" <david.wapnick@btinternet.com> wrote in message
> news:bl675k$9li$1@sparta.btinternet.com...
> : The following is the code, can someone please help me with the syntax
> please
> : in the first line please
> :
> : Conn.Execute "UPDATE tblRentalProperty SET " _
> : & "tblPropertyType = '" & tblPropertyType & "', " _
> : & "tblRooms ='" & tblRooms & "', " _
> : & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
> : & "tblImage = '" & tblImage & "', " _
> : & "tblBriefDescription = '" & tblBriefDescription & "', " _
> : & "tblDetailedDescription = '" & tblDetailedDescription & "', " _
> : & "tblStatus = '" & tblStatus & "', " _
> : & "tblAddress1 = '" & tblAddress1 & "', " _
> : & "tblAddress2 = '" & tblAddress2 & "', " _
> : & "tblAddress3 = '" & tblAddress3 & "', " _
> : & "tblAddress4 = '" & tblAddress4 & "', " _
> : & "tblPostCode = '" & tblPostCode & "', " _
> : & "tblCountry = '" & tblCountry & "', " _
> : & "idArea = '" & idArea & "', " _
> : & "Deleted = '" & Deleted & "' WHERE " _
> : & "idProperty = " & ID
>
>

[Ken Schaefer]

Glad you got the problem solved!

Cheers
Ken


"David Wapnick" <david.wapnick@btinternet.com> wrote in message
news:bl8p4i$m97$1@hercules.btinternet.com...
: I have to say that your response was great and I have solved the problem,
: many thanks to you.
:
: Regards,
:
: David
:
: "Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
: news:O30ZF3ZhDHA.3868@tk2msftngp13.phx.gbl...
: > a) First, allocate the string to a variable, and response.write() the
: value,
: > so you can see what's being sent to the database.
: >
: > eg:
: >
: > <%
: > strSQL = "UPDATE tblRentalProperty SET " _
: > & "tblPropertyType = '" & tblPropertyType & "', " _
: > & "tblRooms ='" & tblRooms & "', " _
: > & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
: > & "tblImage = '" & tblImage & "', " _
: > & "tblBriefDescription = '" & tblBriefDescription & "', " _
: > & "tblDetailedDescription = '" & tblDetailedDescription & "', " _
: > & "tblStatus = '" & tblStatus & "', " _
: > & "tblAddress1 = '" & tblAddress1 & "', " _
: > & "tblAddress2 = '" & tblAddress2 & "', " _
: > & "tblAddress3 = '" & tblAddress3 & "', " _
: > & "tblAddress4 = '" & tblAddress4 & "', " _
: > & "tblPostCode = '" & tblPostCode & "', " _
: > & "tblCountry = '" & tblCountry & "', " _
: > & "idArea = '" & idArea & "', " _
: > & "Deleted = '" & Deleted & "' WHERE " _
: > & "idProperty = " & ID
: >
: > Response.Write(strSQL)
: > Response.End
: > %>
: >
: > b) Then check here for explanations of the cause:
: > [url]http://www.adopenstatic.com/faq/80040e14.asp[/url]
: >
: > Cheers
: > Ken
: >
: > "David Wapnick" <david.wapnick@btinternet.com> wrote in message
: > news:bl675k$9li$1@sparta.btinternet.com...
: > : The following is the code, can someone please help me with the syntax
: > please
: > : in the first line please
: > :
: > : Conn.Execute "UPDATE tblRentalProperty SET " _
: > : & "tblPropertyType = '" & tblPropertyType & "', " _
: > : & "tblRooms ='" & tblRooms & "', " _
: > : & "tblWeeklyPrice = '" & tblWeeklyPrice & "', " _
: > : & "tblImage = '" & tblImage & "', " _
: > : & "tblBriefDescription = '" & tblBriefDescription & "', " _
: > : & "tblDetailedDescription = '" & tblDetailedDescription & "', " _
: > : & "tblStatus = '" & tblStatus & "', " _
: > : & "tblAddress1 = '" & tblAddress1 & "', " _
: > : & "tblAddress2 = '" & tblAddress2 & "', " _
: > : & "tblAddress3 = '" & tblAddress3 & "', " _
: > : & "tblAddress4 = '" & tblAddress4 & "', " _
: > : & "tblPostCode = '" & tblPostCode & "', " _
: > : & "tblCountry = '" & tblCountry & "', " _
: > : & "idArea = '" & idArea & "', " _
: > : & "Deleted = '" & Deleted & "' WHERE " _
: > : & "idProperty = " & ID
: >
: >
:
: