Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 18th, 2004, 05:25 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default "where" clause problem

Why is it that whenever I press "search" it's saying:

Quote:
quote:
SELECT * FROM bible WHERE verse_spoke LIKE '%jehovah%'%' AND ( spokes = '004') AND ( recordType = 'gn' OR recordType = 'is' OR recordType = 'ro')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'verse_spoke LIKE '%jehovah%'%' AND ( spokes = '004') AND ( recordType = 'gn' OR recordType = 'is' OR recordType = 'ro')'.

/amos.asp, line 161
Here is the code:


Code:
<%@ LANGUAGE="VBSCRIPT" %>
<html>
<head>
<TITLE>amos.asp</TITLE>
</head>

<body>
<%
Const DB_NAME    = "kjv.mdb"  ' Name of our database file

GetConnectionString =   "Driver={Microsoft Access Driver (*.mdb)};" & _
        "DBQ=" & Server.MapPath(DB_NAME) & ";" & _
        "UID=;PWD=;"

SQL = "SELECT * FROM bible WHERE "

Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")
dbGlobalWeb.Open(GetConnectionString)

dim Keyword
dim iCounter
dim iLoopCount
dim aRecTypes

Keyword = Request.QueryString("Keyword")
iCounter = 0

If   request.QueryString("book")="book" then

  SQL = SQL & "book LIKE '%" & Keyword & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("book_spoke")="book_spoke" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "book_spoke LIKE '%" & Keyword & "%'" & spoke & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("book_title")="book_title" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "book_title LIKE '%" & Keyword & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("chapter")="chapter" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "chapter LIKE '%" & Keyword & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("chapter_spoke")="chapter_spoke" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "chapter_spoke LIKE '%" & Keyword & "%'" & spoke & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("verse")="verse" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "verse LIKE '%" & Keyword & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("verse_spoke")="verse_spoke" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "verse_spoke LIKE '%" & Keyword & "%'"  & spoke & "%'"

  iCounter = iCounter + 1

end if

If   request.QueryString("text_data")="text_data" then

  If iCounter > 0 Then
    SQL = SQL & " OR "
  End If

  SQL = SQL & "text_data LIKE '%" & Keyword & "%'"

  iCounter = iCounter + 1

end if

If Trim(Request.QueryString("spokes")) <> "" Then


  aRecTypes = Split(Request.QueryString("spokes"), ",")

  If IsArray(aRecTypes) Then 'This is a bit redundant, but it can't hurt
    SQL = SQL & " AND ("

    For iLoopCount = 0 To UBound(aRecTypes)
      If iLoopCount <> 0 Then
        SQL = SQL & " OR "
      End If

      SQL = SQL & " spokes = '" & trim(aRecTypes(iLoopCount)) & "'"
    Next
  End If
  SQL = SQL & ")"
End If

If Trim(Request.QueryString("recordType")) <> "" Then


  aRecTypes = Split(Request.QueryString("recordType"), ",")

  If IsArray(aRecTypes) Then 'This is a bit redundant, but it can't hurt
    SQL = SQL & " AND ("

    For iLoopCount = 0 To UBound(aRecTypes)
      If iLoopCount <> 0 Then
        SQL = SQL & " OR "
      End If

      SQL = SQL & " recordType = '" & trim(aRecTypes(iLoopCount)) & "'"
    Next
  End If
  SQL = SQL & ")"
End If

Response.Write SQL

Set rsGlobalWeb = Server.CreateObject("ADODB.Recordset")
rsGlobalWeb.Open SQL, dbGlobalWeb, 3%>

<%
If rsGlobalWeb.BOF and rsGlobalWeb.EOF Then%>

<h2 align="center">We did not find a match!</h2>
<%Else%>


<%If Not rsGlobalWeb.BOF Then%>

<h2>These are the results:</h2>

<table BORDER="0" width="100%" cellpadding="3">
  <tr>
    <th bgcolor="#800000">Book </th>
    <th bgcolor="#800000">Book Spoke</th>
    <th bgcolor="#800000">Book Title </th>
    <th bgcolor="#800000">Chapter </th>
    <th bgcolor="#800000">Chapter Spoke </th>
    <th bgcolor="#800000">Verse </th>
    <th bgcolor="#800000">Verse Spoke </th>
    <th bgcolor="#800000">Text </th>
  </tr>

    <%Do While Not rsGlobalWeb.EOF%>
  <tr>
        <td><%=rsGlobalWeb("book")%>#32
</td>
    <td><%=rsGlobalWeb("book_spoke")%>
</td>
        <td><%=rsGlobalWeb("book_title")%>
</td>
        <td><%=rsGlobalWeb("chapter")%>
</td>
        <td><%=rsGlobalWeb("chapter_spoke")%>
</td>
        <td><%=rsGlobalWeb("verse")%>
</td>
        <td><%=rsGlobalWeb("verse_spoke")%>
</td>
        <td><%=rsGlobalWeb("text_data")%>
</td>
  </tr>
<% rsGlobalWeb.MoveNext
    Loop
    %>
</table>
<%End If%>
<%End If%>
<%
rsGlobalWeb.Close
dbGlobalWeb.Close
%>
</body>
</html>
Reply With Quote
  #2 (permalink)  
Old August 18th, 2004, 08:26 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Mentiri, Muara, Brunei.
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
Default


I think, no condition is satisfied. You try response.write SQL before executing.



Reply With Quote
  #3 (permalink)  
Old August 18th, 2004, 09:11 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Syntax error is due to the extra % marked in red below. You got to check that.

'%jehovah%'%'

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #4 (permalink)  
Old August 18th, 2004, 10:08 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

It must've been those lines where I have joined "keyword" and "spoke" in one line. What I did is copy and paste the trim part of "recordType" and called it "spokes" since the recordType was an array.

Question: Is the dropdown an array as well? because it's (actually 3) fields according to 3 checkboxes.

Question 2: how will the 3 checkboxes plus the dropdown work?

Code:
If Trim(Request.QueryString("spokes")) <> "" Then


  aRecTypes = Split(Request.QueryString("spokes"), ",")

  If IsArray(aRecTypes) Then 'This is a bit redundant, but it can't hurt
    SQL = SQL & " AND ("

    For iLoopCount = 0 To UBound(aRecTypes)
      If iLoopCount <> 0 Then
        SQL = SQL & " OR "
      End If

      SQL = SQL & " spokes = '" & trim(aRecTypes(iLoopCount)) & "'"
    Next
  End If
  SQL = SQL & ")"
End If
If Trim(Request.QueryString("recordType")) <> "" Then


  aRecTypes = Split(Request.QueryString("recordType"), ",")

  If IsArray(aRecTypes) Then 'This is a bit redundant, but it can't hurt
    SQL = SQL & " AND ("

    For iLoopCount = 0 To UBound(aRecTypes)
      If iLoopCount <> 0 Then
        SQL = SQL & " OR "
      End If

      SQL = SQL & " recordType = '" & trim(aRecTypes(iLoopCount)) & "'"
    Next
  End If
  SQL = SQL & ")"
End If
Reply With Quote
  #5 (permalink)  
Old August 18th, 2004, 10:32 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Not sure what you are asking about, without knowing how the UI looks/functions.

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #6 (permalink)  
Old August 18th, 2004, 11:45 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

I have:
Code:
dim iLoopCount
dim aRecTypes
for "recordType". Can these variables apply for "spokes" as well or do I have to make two other variables?

recordType is used to identify the 66 books and is 2 or 3 letters. But three "Spokes" are numbered by myself for the purpose of doing research. I divided the 66 books into 1-22,1-22,1-22. Likewise the chapters and verses.

So unlike the recordTypes the "spokes" are 3 columns and they are checkboxes.

Here is the HTML

Code:
<html>
<head>
<title>Search for the Bible</title>
<script language="javascript">

a=0; 
function changer(b){ 
a+=((b.checked)?1:-1) 
document.getElementById("spoke").disabled=(a<1); 
}

function EnableDisable()
{
    if(document.kjbible.optAction[0].checked){

        for(i=0;i<document.kjbible.recordType.length;i++)
            document.kjbible.recordType[i].disabled=false;

        for(i=0;i<document.kjbible.book.length;i++)
            document.kjbible.book[i].disabled=true;

        for(i=0;i<document.kjbible.book_spoke.length;i++)
            document.kjbible.book_spoke[i].disabled=true;

    document.kjbible.book.disabled = true;
    document.kjbible.book_spoke.disabled = true;
    document.kjbible.book_title.disabled = true;
  }


    if(document.kjbible.optAction[1].checked){

        for(i=0;i<document.kjbible.recordType.length;i++)
            document.kjbible.recordType[i].disabled=true;

        for(i=0;i<document.kjbible.book.length;i++)
            document.kjbible.book[i].disabled=false;

        for(i=0;i<document.kjbible.book_spoke.length;i++)
            document.kjbible.book_spoke[i].disabled=false;

    document.kjbible.book.disabled = false;
    document.kjbible.book_spoke.disabled = false;
    document.kjbible.book_title.disabled = false;

  }

}
function Reset() 
{ 
   for(i=0;i<document.kjbible.recordType.length;i++) 
      document.kjbible.recordType[i].disabled=false; 
 
   for(i=0;i<document.kjbible.book.length;i++) 
      document.kjbible.book[i].disabled=true; 
 
   for(i=0;i<document.kjbible.book_spoke.length;i++) 
      document.kjbible.book_spoke[i].disabled=true; 

   document.kjbible.book.disabled = true; 
   document.kjbible.book_spoke.disabled = true; 
   document.kjbible.book_title.disabled = true; 
}

</script>
</head>
<body Onload="Javascript:EnableDisable();">
<table border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; border-style: none; border-width: medium" width="509">
  <tr style="height:123.25pt">
    <td width="363" valign="top" style="height: 123.25pt; border: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal">
      <form name="kjbible" action="amos.asp" method="get">
      Look for: <input TYPE="text" NAME="Keyword" size="20"><input TYPE="submit" VALUE=" Search "><input TYPE="reset">&nbsp;<o:p>
      </o:p>
      <p class="MsoNormal">If you search number write 001 instead of 1 and 022
      instead of 22<br>
      <input TYPE="radio" CHECKED NAME="optAction" onclick="Javascript:EnableDisable();">
      The entire King James Bible <br>
      <input TYPE="radio" NAME="optAction" onclick="javascript:EnableDisable();">
      Your selection of books<br>
      <br>
      <input TYPE="CheckBox" NAME="book" VALUE="book">Book<br>
      <input TYPE="CheckBox" NAME="book_title" VALUE="Book_Title">Book Title<br>
      <input TYPE="CheckBox" NAME="chapter" VALUE="Chapter">Chapter<br>
      <input TYPE="CheckBox" NAME="verse" VALUE="Verse">Verse<br>
      <input TYPE="CheckBox" CHECKED NAME="text_data" VALUE="Text">Text<o:p>
      </o:p>
    </td>
              <td align="left" width="189"> 
      <select name="spokes" size="1" id="spoke" disabled> 
        <option SELECTED VALUE="none">None</option> 
        <option VALUE="001">spoke 1</option> 
        <option VALUE="002">spoke 2</option> 
        <option VALUE="003">spoke 3</option> 
        <option VALUE="004">spoke 4</option> 
        <option VALUE="005">spoke 5</option> 
        <option VALUE="006">spoke 6</option> 
        <option VALUE="007">spoke 7</option> 
        <option VALUE="008">spoke 8</option> 
        <option VALUE="009">spoke 9</option> 
        <option VALUE="010">spoke 10</option> 
        <option VALUE="011">spoke 11</option> 
        <option VALUE="012">spoke 12</option> 
        <option VALUE="013">spoke 13</option> 
        <option VALUE="014">spoke 14</option> 
        <option VALUE="015">spoke 15</option> 
        <option VALUE="016">spoke 16</option> 
        <option VALUE="017">spoke 17</option> 
        <option VALUE="018">spoke 18</option> 
        <option VALUE="019">spoke 19</option> 
        <option VALUE="020">spoke 20</option> 
        <option VALUE="021">spoke 21</option> 
        <option VALUE="022">spoke 22</option> 
      </select><br> 
      You may choose from the 22 spokes (for a definition of what a
      &quot;spoke&quot; is go to <a href="http://www.biblewheel.com"></a><a href="http://www.biblewheel.com" target="_blank">www.biblewheel.com</a> 
      ) 
      <p class="MsoNormal"><o<img src="images/smilies/tongue.gif" border="0" alt=""><input TYPE="CheckBox" NAME="book_spoke" VALUE="Book_Spoke" onclick="changer(this)">Book 
      Spoke<br> 
      <input TYPE="CheckBox" NAME="chapter_spoke" VALUE="chapter_spoke" onclick="changer(this)">Chapter 
      Spoke<br> 
      <input TYPE="CheckBox" NAME="verse_spoke" VALUE="verse_spoke" onclick="changer(this)">Verse Spoke<o<img src="images/smilies/tongue.gif" border="0" alt=""> 
      </p> 
      <p class="MsoNormal"> &nbsp; 
      </p> 
      <p class="MsoNormal"><br> 
      </o<img src="images/smilies/tongue.gif" border="0" alt=""> 
      </p> 
    </td> 

  </tr>
  <tr style="height:216.4pt">
    <td width="493" colspan="2" valign="top" style="mso-border-top-alt: solid windowtext .5pt; height: 216.4pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal">Search: <o:p>
      </o:p>
      </p>
      <p>Where do you want to search?<o:p>
      </o:p>
      </p>
      <table border="1" cellpadding="0" width="100%" style="width:100.0%;mso-cellspacing:
  1.5pt" height="500">
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" CHECKED NAME="recordType" VALUE="gn">Genesis<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" CHECKED NAME="recordType" VALUE="is">Isaiah<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" CHECKED NAME="recordType" VALUE="ro">Romans<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ex">Exodus<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="je">Jeremiah<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="co">1
            Corinthians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="lv">Leviticus<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="la">Lamentations<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ci">2
            Corinthians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="nu">Numbers<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ez">Ezekiel<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ga">Galatians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="de">Deuteronomy<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="da">Daniel<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ep">Ephesians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="js">Joshua<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ho">Hosea<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ph">Philippians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jg">Judges<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jl">Joel<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="cl">Colossians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ru">Ruth<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="am">Amos<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="th">1
            Thessalonians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="sa">1
            Samuel<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ob">Obadiah
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="te">2
            Thessalonians<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="sm">2
            Samuel<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jh">Jonah
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ti">1
            Timothy<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ki">1
            Kings<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="mi">Micah
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="tm">2
            Timothy<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="kn">2
            Kings<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="na">Nahum
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="tt">Titus<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ch">1
            Chronicles<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="hb">Habakkuk
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="pl">Philemon<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="cr">2
            Chronicles<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ze">Zepheniah
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="he">Hebrews<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ea">Ezra<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ha">Haggai
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ja">James<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ne">Nehemiah<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="zc">Zechariah
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="pe">1
            Peter<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="es">Esther<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ml">Malachi
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="pt">2
            Peter<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jb">Job<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="mt">Matthew
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jn">1
            John<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ps">Psalms<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="mk">Mark
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jnn">2
            John<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="pr">Proverbs<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="lk">Luke
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jhn">3
            John<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ec">Ecclesiastes<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="jo">John
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ju">Jude<o:p>
            </o:p>
            </p>
          </td>
        </tr>
        <tr style="height:14.25pt">
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="so">Song
            of Solomon<o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="ac">Acts
            <o:p>
            </o:p>
            </p>
          </td>
          <td width="33%" style="width:33.0%;padding:.75pt .75pt .75pt .75pt;
   height:14.25pt">
            <p class="MsoNormal"><input TYPE="checkbox" NAME="recordType" VALUE="re">Revelation<o:p>
            </o:p>
            </p>
          </td>
        </tr>
      </table>
      <p class="MsoNormal"><o:p>
      </o:p>
      </p>
    </td>
  </tr>
  </form>
</table>
<p class="MsoNormal">&nbsp;<o:p>
</o:p>
</p>
</body>
Reply With Quote
  #7 (permalink)  
Old August 19th, 2004, 12:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Question: Is the dropdown an array as well? because it's (actually 3) fields according to 3 checkboxes.
Does this mean the value returned from the dropdown on submission of form? If so, it is not an array, unless the dropdown is a list box that lets you select multiple values.
Quote:
quote:Question 2: how will the 3 checkboxes plus the dropdown work?
How do you want that work?

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #8 (permalink)  
Old August 19th, 2004, 12:34 AM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

Ok. I put the HTML before. I know it's long but it gives you an idea of what's going on.

No the dropdown is not a multiple selection, so, I guess it's not an array. They are numbered 1-22 and should search the checkboxes checked right under it.

I had a model of a dropdown code but their dropdown selection were the fields. My selection of 1-22 are the records. The checkboxes are the fields. So I think it's not the same. What do you think?

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with clause Top in store procedure Javierera SQL Server 2005 3 October 24th, 2008 10:17 AM
Order by clause mateenmohd SQL Server 2000 4 April 6th, 2004 06:48 AM
More than 1 WHERE clause? onlyu2 MySQL 1 March 26th, 2004 01:48 PM
HAVING clause Adam H-W SQL Server ASP 2 February 11th, 2004 01:37 PM
Problem using WHERE clause in opening Recordset johnman Classic ASP Databases 2 October 23rd, 2003 01:30 PM



All times are GMT -4. The time now is 01:01 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.