 |
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
August 18th, 2004, 05:25 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
"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>
|
|
August 18th, 2004, 08:26 PM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
|
|
I think, no condition is satisfied. You try response.write SQL before executing.
|
|
August 18th, 2004, 09:11 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Syntax error is due to the extra % marked in red below. You got to check that.
'%jehovah%'%'
_________________________
- Vijay G
Strive for Perfection
|
|
August 18th, 2004, 10:08 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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
|
|
August 18th, 2004, 10:32 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Not sure what you are asking about, without knowing how the UI looks/functions.
_________________________
- Vijay G
Strive for Perfection
|
|
August 18th, 2004, 11:45 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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"> <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
"spoke" 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">
</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"> <o:p>
</o:p>
</p>
</body>
|
|
August 19th, 2004, 12:00 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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
|
|
August 19th, 2004, 12:34 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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?
|
|
|
