Very Computer

I am trying to place 3 values into a sql statement.  I receive the
following error.  How do I place this value using my form?

<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
size=2>error '80040e07'</font>
<p>
<font face="Arial" size=2>[Microsoft][ODBC SQL Server Driver][SQL
Server]Syntax error converting the varchar value '19,30,31' to a column
of data type int.</font>
<p>

My SQL which is running on 7.0 looks like this.  I am inserting the data
from a form into the <% status %>

        thesql = "SELECT DISTINCT Website.url, Website.pagetitle,
sciLINKS.scilink, Codes.code,  Website.nasa_owner, Website.nasa_content,
WebsiteLevel.levelid "
       thesql = thesql & "FROM (((TextbookLinks "
       thesql = thesql & "INNER JOIN ((Website INNER JOIN WebsiteLevel
ON Website.siteID = WebsiteLevel.siteid) "
       thesql = thesql & "INNER JOIN SiteCoordinate ON Website.siteID =
SiteCoordinate.siteid) ON TextbookLinks.coordinateid =
SiteCoordinate.coordinateid) "
       thesql = thesql & "INNER JOIN sciLINKS ON
TextbookLinks.txtbklinkid = sciLINKS.txtbklinkid) INNER JOIN Textbook ON
TextbookLinks.textbookid = Textbook.textbookid) "
       thesql = thesql & "INNER JOIN Codes ON Website.nasa_owner =
Codes.codeid "
       thesql = thesql & "WHERE Website.status = '" & status & "'"
       thesql = thesql & "and " & nasa & "= '" & code & "'"
       thesql = thesql & "and WebsiteLevel.levelid = '" & levelid & "'"

--
David Anderson
Project sciLINKS
http://www.scilinks.org
1840 Wilson Blvd
Arlington, VA 22201
(703) 312-9297
(703) 526-9754 FAX

D. Anderson

Try this

        thesql = "SELECT DISTINCT Website.url, Website.pagetitle, sciLINKS.scilink, Codes.code,  Website.nasa_owner, Website.nasa_content, WebsiteLevel.levelid "
       thesql = thesql & "FROM (((TextbookLinks "
       thesql = thesql & "INNER JOIN ((Website INNER JOIN WebsiteLevel ON Website.siteID = WebsiteLevel.siteid) "
       thesql = thesql & "INNER JOIN SiteCoordinate ON Website.siteID = SiteCoordinate.siteid) ON TextbookLinks.coordinateid = SiteCoordinate.coordinateid) "
       thesql = thesql & "INNER JOIN sciLINKS ON TextbookLinks.txtbklinkid = sciLINKS.txtbklinkid) INNER JOIN Textbook ON TextbookLinks.textbookid = Textbook.textbookid) "
       thesql = thesql & "INNER JOIN Codes ON Website.nasa_owner = Codes.codeid "
       thesql = thesql & "WHERE Website.status in (" & status & ")"
       thesql = thesql & "and " & nasa & "= '" & code & "'"
       thesql = thesql & "and WebsiteLevel.levelid = '" & levelid & "'"

regards

Greg O

  I am trying to place 3 values into a sql statement.  I receive the following error.  How do I place this value using my form?
  <p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>error '80040e07'</font>
  <p>
  <font face="Arial" size=2>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '19,30,31' to a column of data type int.</font>
  <p>

  My SQL which is running on 7.0 looks like this.  I am inserting the data from a form into the <% status %>

          thesql = "SELECT DISTINCT Website.url, Website.pagetitle, sciLINKS.scilink, Codes.code,  Website.nasa_owner, Website.nasa_content, WebsiteLevel.levelid "
         thesql = thesql & "FROM (((TextbookLinks "
         thesql = thesql & "INNER JOIN ((Website INNER JOIN WebsiteLevel ON Website.siteID = WebsiteLevel.siteid) "
         thesql = thesql & "INNER JOIN SiteCoordinate ON Website.siteID = SiteCoordinate.siteid) ON TextbookLinks.coordinateid = SiteCoordinate.coordinateid) "
         thesql = thesql & "INNER JOIN sciLINKS ON TextbookLinks.txtbklinkid = sciLINKS.txtbklinkid) INNER JOIN Textbook ON TextbookLinks.textbookid = Textbook.textbookid) "
         thesql = thesql & "INNER JOIN Codes ON Website.nasa_owner = Codes.codeid "
         thesql = thesql & "WHERE Website.status = '" & status & "'"
         thesql = thesql & "and " & nasa & "= '" & code & "'"
         thesql = thesql & "and WebsiteLevel.levelid = '" & levelid & "'"

  --
  David Anderson
  Project sciLINKS
  http://www.scilinks.org
  1840 Wilson Blvd
  Arlington, VA 22201
  (703) 312-9297
  (703) 526-9754 FAX