how to use recordType in htm/asp

gilgalbiblewheel · August 10th, 2004, 02:01 PM

What I have is a table which one of the 10 fields is called "recordType".

I have in my htm two radio buttons for enabling/disabling 66 checkboxes. So far that works.

But the 66 checkboxes all have "value="recordType"" and name=recordType names. The names are listed:

Code:

<SCRIPT LANGUAGE=Javascript>

  function disable(OnOff) {
  var f = kjbible;
 
    f.gn.disabled=OnOff;
    f.is.disabled=OnOff;
    f.ro.disabled=OnOff;

    f.ex.disabled=OnOff;
    f.je.disabled=OnOff;
    f.co.disabled=OnOff;

    f.lv.disabled=OnOff;
    f.la.disabled=OnOff;
    f.ci.disabled=OnOff;

    f.nu.disabled=OnOff;
    f.ez.disabled=OnOff;
    f.ga.disabled=OnOff;

    f.de.disabled=OnOff;
    f.da.disabled=OnOff;
    f.ep.disabled=OnOff;


    f.js.disabled=OnOff;
    f.ho.disabled=OnOff;
    f.ph.disabled=OnOff;


    f.jg.disabled=OnOff;
    f.jl.disabled=OnOff;
    f.cl.disabled=OnOff;


    f.ru.disabled=OnOff;
    f.am.disabled=OnOff;
    f.th.disabled=OnOff;


    f.sa.disabled=OnOff;
    f.ob.disabled=OnOff;
    f.te.disabled=OnOff;

    f.sm.disabled=OnOff;
    f.jh.disabled=OnOff;
    f.ti.disabled=OnOff;

    f.ki.disabled=OnOff;
    f.mi.disabled=OnOff;
    f.tm.disabled=OnOff;


    f.kn.disabled=OnOff;
    f.na.disabled=OnOff;
    f.tt.disabled=OnOff;


    f.ch.disabled=OnOff;
    f.hb.disabled=OnOff;
    f.pl.disabled=OnOff;

    f.cr.disabled=OnOff;
    f.ze.disabled=OnOff;
    f.he.disabled=OnOff;

    f.ea.disabled=OnOff;
    f.ha.disabled=OnOff;
    f.ja.disabled=OnOff;

    f.ne.disabled=OnOff;
    f.zc.disabled=OnOff;
    f.pe.disabled=OnOff;    

    f.es.disabled=OnOff;
    f.ml.disabled=OnOff;
    f.pt.disabled=OnOff;

    f.jb.disabled=OnOff;
    f.mt.disabled=OnOff;
    f.jn.disabled=OnOff;    

    f.ps.disabled=OnOff;
    f.mk.disabled=OnOff;
    f.jnn.disabled=OnOff;

    f.pr.disabled=OnOff;
    f.lk.disabled=OnOff;
    f.jhn.disabled=OnOff;


    f.ec.disabled=OnOff;
    f.jo.disabled=OnOff;
    f.ju.disabled=OnOff;


    f.so.disabled=OnOff;
    f.ac.disabled=OnOff;
    f.re.disabled=OnOff;

}
</SCRIPT>

Example:

Code:

   <td width="33%" height="19">  
<input TYPE="checkbox" NAME="gn" CHECKED VALUE="recordType">Genesis</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="is" CHECKED VALUE="recordType">Isaiah</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="ro" CHECKED VALUE="recordType">Romans</td>
  </tr>

My goal is to check some of the checkboxes (after enabling the checkbox table through the radio buttons) and search a keyword in that range(s) only. Example. Above are three names gn, is, ro. If I select "gn" only I want the keyword to be searched in the "gn" records ONLY. Or if I select "gn" and "is" only I want the keyword to be searched in the "gn" and "is" records ONLY.

Is there a way to attach my htm and asp pages with a small portion of my database so that you may verify?

rajanikrishna · August 10th, 2004, 08:29 PM

Hi,

Instead of checking names, you can have value of checkbox as "gn", "is", "ro". What is the need(use) of having same value for all checkboxes? Instead...

<input type="checkbox" name="chkGN" value="gn">Genesis
<input type="checkbox" name="chkIS" value="is">Isaiah

When you submit this form the checkbox values are retrieved. Whatever you check the checkbox those values only be retrieved.

gilgalbiblewheel · August 10th, 2004, 09:21 PM

Ok so I changed the name with the value:

Example:

Code:

    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="gn" CHECKED >Genesis</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="is" CHECKED >Isaiah</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ro" CHECKED >Romans</td>
  </tr>

But when I click the radio button to enable/disable the checkboxes it says:

Quote:

quote:line: 61

Quote:

Error: 'gn' is null or not an object

happygv · August 10th, 2004, 10:51 PM

gilgalbiblewheel,

Why do you have to write such long code and complicate things.

It is so easy as this. Try this. Copy/paste this code and paste in a new html/asp file, open that in a browser to see how it behaves and use this functionality in your code.

Code:

<html>
<head>
<script language="javascript">
function EnableDisable()
{
    if(document.frm.optAction[0].checked)
        for(i=0;i<document.frm.chk.length;i++)
            document.frm.chk[i].disabled=false;

    if(document.frm.optAction[1].checked)
        for(i=0;i<document.frm.chk.length;i++)
            document.frm.chk[i].disabled=true;
}

</script>
</head>
<body>
<form name="frm" action="" method="post">
    <input type="radio" name="optAction" CHECKED onclick="Javascript:EnableDisable();">Enable
    <input type="radio" name="optAction" onclick="javascript:EnableDisable();">Disable
    <br>
    <input type="checkbox" name="chk" value="1">1<br>
    <input type="checkbox" name="chk" value="2">2<br>
    <input type="checkbox" name="chk" value="3">3<br>
    <input type="checkbox" name="chk" value="4">4
</form>
</body>

</html>

Cheers!

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · August 10th, 2004, 11:15 PM

OK thanks. Will it be possible to use the radio button to enable one checkbox while disabling another checkbox? If possible it would be necessary because in one area I have 3 different types of checkboxes, like search: book#, book Name , and another type of book #. But if I select the books (from 66 books in records in one table)I have to disable the first 3 checkboxes.

happygv · August 10th, 2004, 11:35 PM

Yes it is possible. Name those three checkboxes alone with same name and use the same logic I posted in my previous post. Or If you want to use different name for those three check boxes, then use

document.<formname>.<checkboxname>.disabled = true (for disable)
document.<formname>.<checkboxname>.disabled = false (for enable)

where you should use the formname and checkboxname as you defined in your code.

Cheers!

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · August 11th, 2004, 12:04 AM

Ok. This is how I did it. But is there a way to get a set of checkboxes disable as I open the page or refresh it?

Code:

<html>
<head>
<script language="javascript">
function EnableDisable()
{
    if(document.frm.optAction[0].checked)
        for(i=0;i<document.frm.chk.length;i++)
            document.frm.chk[i].disabled=false;
    if(document.frm.optAction[0].checked)
        for(i=0;i<document.frm.nochk.length;i++)
            document.frm.nochk[i].disabled=true;


    if(document.frm.optAction[1].checked)
        for(i=0;i<document.frm.chk.length;i++)
            document.frm.chk[i].disabled=true;
    if(document.frm.optAction[1].checked)
        for(i=0;i<document.frm.nochk.length;i++)
            document.frm.nochk[i].disabled=false;

}

</script>
</head>
<body>
<form name="frm" action="" method="post">
    <input type="radio" name="optAction" CHECKED onclick="Javascript:EnableDisable();">Enable
    <input type="radio" name="optAction" onclick="javascript:EnableDisable();">Disable
    <br>
    <input type="checkbox" name="chk" value="1">1<br>
    <input type="checkbox" name="chk" value="2">2<br>
    <input type="checkbox" name="chk" value="3">3<br>
    <input type="checkbox" name="chk" value="4">4<br><br>
    <input type="checkbox" name="nochk" value="5">5<br>
    <input type="checkbox" name="nochk" value="6">6<br>
    <input type="checkbox" name="nochk" value="7">7<br>
    <input type="checkbox" name="nochk" value="8">8
</form>
</body>

</html>

happygv · August 11th, 2004, 12:26 AM

Write a function that disables the set of checkboxes and call it in Body Onload. This will execute the function everytime the page is refreshed/loaded.

<body Onload="Javascript:YourfunctiontoDisableCheckBoxes ();">

Cheers!

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · August 11th, 2004, 12:02 PM

For some reason this doesn't work entirely:
See note at the end.

Code:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<title>Search for the Bible</title>
<script language="javascript">
function EnableDisable()
{
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.recordType.length;i++)
            document.kjbible.recordType[i].disabled=true;
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book.length;i++)
            document.kjbible.book[i].disabled=false;
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book_spoke.length;i++)
            document.kjbible.book_spoke[i].disabled=false;
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book_title.length;i++)
            document.kjbible.book_title[i].disabled=false;

    if(document.kjbible.optAction[1].checked)
        for(i=0;i<document.kjbible.recordType.length;i++)
            document.kjbible.recordType[i].disabled=false;
   if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book.length;i++)
            document.kjbible.book[i].disabled=true;
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book_spoke.length;i++)
            document.kjbible.book_spoke[i].disabled=true;
    if(document.kjbible.optAction[0].checked)
        for(i=0;i<document.kjbible.book_title.length;i++)
            document.kjbible.book_title[i].disabled=true;
}

</script>
</head>
<body Onload="Javascript:EnableDisable();">
<fieldset>
<legend>
Biblewheel:
</legend>
<tr>
<form name="kjbible" action="amos.asp" method="get">
Search for:
<input type="text" name="Keyword">
<input type="submit" value="Submit"><input type="reset">
</td>
    <br>
    <input type="radio" name="optAction" CHECKED onclick="Javascript:EnableDisable();">Enable The entire King James Bible 
    <input type="radio" name="optAction" onclick="javascript:EnableDisable();">Disable Your selection of books
    <br>

<br>
<input type="checkbox" name="book" VALUE="yes">
Book
<br>
<input type="checkbox" name="book_spoke" VALUE="yes">
Book Spoke
<br>
<input type="checkbox" name="book_title" VALUE="yes">
Book Title
<br>
<input type="checkbox" name="chapter" VALUE="yes">
Chapter
<br>
<input type="checkbox" name="chapter_spoke" VALUE="yes">
Chapter Spoke
<br>
<input type="checkbox" name="verse" VALUE="yes">
Verse
<br>
<input type="checkbox" name="verse_spoke" VALUE="yes">
Verse Spoke
<br>
<input type="checkbox" name="text_data" VALUE="yes">
Text
 </tr>
 <fieldset>
<legend>
Search:
</legend>

     <p>Where do you want to search?</p> 
    <table border="1" width="100%" height="500">
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="gn" CHECKED >Genesis</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="is" CHECKED >Isaiah</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ro" CHECKED >Romans</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ex" >Exodus</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="je" >Jeremiah</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="co" >1 Corinthians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="lv" >Leviticus</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="la" >Lamentations</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ci" >2 Corinthians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="nu" >Numbers</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ez" >Ezekiel</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ga" >Galatians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="de" >Deuteronomy</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="da" >Daniel</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ep" >Ephesians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="js" >Joshua</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ho" >Hosea</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ph" >Philippians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="jg" >Judges</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jl" >Joel</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="cl" >Colossians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ru" >Ruth</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="am" >Amos</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="th" >1 Thessalonians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="sa" >1 Samuel</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ob" >Obadiah
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="te" >2 Thessalonians</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="sm" >2 Samuel</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jh" >Jonah
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ti" >1 Timothy</td>
  </tr>
  <tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ki" >1 Kings</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="mi" >Micah
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="tm" >2 Timothy</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="kn" >2 Kings</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="na" >Nahum
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="tt" >Titus</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ch" >1 Chronicles</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="hb" >Habakkuk
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="pl" >Philemon</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="cr" >2 Chronicles</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ze" >Zepheniah
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="he" >Hebrews</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ea" >Ezra</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ha" >Haggai
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ja" >James</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ne" >Nehemiah</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="zc" >Zechariah
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="pe" >1 Peter</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="es" >Esther</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ml" >Malachi
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="pt" >2 Peter</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="jb" >Job</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="mt" >Matthew
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jn" >1 John</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ps" >Psalms</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="mk" >Mark
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jnn" >2 John</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="pr" >Proverbs</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="lk" >Luke
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jhn" >3 John</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="ec" >Ecclesiastes</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="jo" >John
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ju" >Jude</td>
  </tr>
    <td width="33%" height="19">  
<input TYPE="checkbox" NAME="recordType" VALUE="so" >Song of Solomon</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="ac" >Acts
</td>
<td width="33%" height="19">
<input TYPE="checkbox" NAME="recordType" VALUE="re">Revelation</td>
  </tr>
</table>
</fieldset>
</form>
</fieldset>
</body>
</html>

I don't think I can change those three names into one name because each represents a field in database table.

gilgalbiblewheel · August 11th, 2004, 04:31 PM

1.

Code:

SELECT * FROM bible WHERE text_data LIKE '%adam%' OR ( recordType = 'gn' AND recordType = ' is' AND recordType = ' ro')

Searches the entire table of the database

2.

Code:

SELECT * FROM bible WHERE text_data LIKE '%adam%' AND ( recordType = 'gn' AND recordType = ' is' AND recordType = ' ro')

"We did not find a match!"

3.

Code:

SELECT * FROM bible WHERE text_data LIKE '%adam%' AND ( recordType = 'gn' OR recordType = ' is' OR recordType = ' ro')

Searches the first recordType only

4.

Code:

SELECT * FROM bible WHERE text_data LIKE '%adam%' OR ( recordType = 'gn' OR recordType = ' is' OR recordType = ' ro')

Displays every record found in the 1st recordType, then searches for the keyword in the rest of the table.

I don't understand why.

How can I eliminate the spaces between ' and is in ' is' and ' ro' ?

Code:

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

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

  SQL = SQL & ")"
End If

Response.Write SQL