Query input must contain at least one table or que

Results 1 to 2 of 2

Thread: Query input must contain at least one table or que

  1. #1
    william Guest

    Default Query input must contain at least one table or que

    Below is my code which produces the above error message...my form consists of 5 textarea boxes and one hidden input. Anyone know why this error is produced?<BR><BR>strSQL = "INSERT INTO Table1 " & _<BR> "(q1,q2,q3,q4,q5,date_sent)" & _<BR> " SELECT &#039" & Request.Form("textarea1") & "&#039 AS q1, &#039" _<BR> & Request.Form("textarea2") & "&#039 AS q2, &#039" _<BR> & Request.Form("textarea3") & "&#039 AS q3, &#039" _<BR> & Request.Form("textarea4") & "&#039 AS q4, &#039" _<BR> & Request.Form("textarea5") & "&#039 AS q5, &#039" _<BR> & Request.Form("WhenSent") & "&#039 AS date_sent &#039"

  2. #2
    Sathiya Guest

    Default RE: Query input must contain at least one table or

    I think when you use a SELECT statement you should tell from what table you are going to select.

Posting Permissions

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