SQL another query trouble

Results 1 to 3 of 3

Thread: SQL another query trouble

  1. #1
    Join Date
    Dec 1969

    Default SQL another query trouble

    This is the query I&#039;m running, to change room prices.RT is a field name.<BR>Keep getting error message:<BR>"Missing semicolon (;) at end of SQL statement."<BR>When i hit submit on previous page<BR><BR>SQL = " INSERT INTO Rooms (RoomPrice) "<BR>SQL = SQL & " VALUES (&#039;" & RoomPrice & "&#039;) "<BR>SQL = SQL & " WHERE RT = &#039;" & RoomType & "&#039; "<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL another query trouble

    Well, what do you think &#039;Missing semicolon (;) at end of SQL statement&#039;. Have you tried putting one there??<BR><BR>For your other question, check the docs for DISTINCT and GROUP BY

  3. #3
    Join Date
    Dec 1969

    Default Not in this case

    A ; at the end will not help to solve this problem.<BR><BR>You have mixed the syntax for update and insert.<BR><BR>update t set v = &#039;new value&#039; where k = &#039;some value&#039;<BR><BR>vs<BR><BR>insert into t(k,v) values(&#039;key&#039;,none key&#039;)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts