Loading ...
Sorry, an error occurred while loading the content.

Looking for Resources

Expand Messages
  • LaurieK
    I m in the HTML group for Notepad because its well. web page/site related info that I m seeking. I have a website where I maintain a database http://ladyck.com
    Message 1 of 30 , Aug 2, 2008
    • 0 Attachment
      I'm in the HTML group for Notepad because its well. web page/site related
      info that I'm seeking.



      I have a website where I maintain a database http://ladyck.com The database
      has 18607 records all articles, recipes and patterns from the Workbasket
      magazine, launched October 1935 and last issue 1996. These pages are
      written in ASP (the index and frames are html).



      I am NOT a programmer, I do not understand (can't wrap my head around syntax
      and do not have the tools to know how to speak the language and I get toooo
      frustrated trying to figure out what is what). A coworker helped me with a
      work database and I have been able to migrate the information over to my
      personal database. The problem is, he does not know yet. how to create a
      Boolean type search...



      If you try the website, you will see that you can search for one word only,
      so if I search for "doily" I get all patterns whether knit, tatting,
      crochet.. But if I want to find all of the tatted doily patterns I can't.
      We had it set up with a category drop down, so you pick a category from a
      drop down menu and THEN type in your one word search criteria but I don't
      want to have to use that. AND 'we' have gained knowledge as we've each
      worked on databases/asp to the point that my original drop down menu page
      has changed drastically enough it warranted a new page.. And I don't know
      how to incorporate the drop down menu in the new one. (the dim information
      and what not that has to be added).



      SO.. Does anyone know how to program or where I can look for a 101 tutorial
      on how to do this?



      I see folks in the clip form talk about RegEx but I don't understand that.
      Jody and Jim Hall (may they both rest in peace, danged cancer) tried to hold
      my hand.. I'm hopeless but I WANT TO KNOW THIS.



      I can't even find some sort of online generator for this stuff, nor do I
      know what to search for.. Do I look for "how do I create" or "how do I
      write" or whatever. a BOOLEAN search? Or is there some sort of javascript
      that can do this?





      Seriously, any ideas? Does Google offer some sort of free search tool and
      if so, is it a site search or can you have it look for key words in a
      database?



      Confused and frustrated.



      Laurie



      THANKS! (BTW, we have been working from home, me and my coworker as our
      offices are under construction so we have not seen each other in a couple of
      weeks and won't be for a couple more I suspect.. And he said he didn't know
      how to do this and would have to research and we'd get together on it when
      we got back in the office. I don't even know what I need to search for to
      get the help... and I'm antsy as all get out because I just recently (2
      days ago) completed the data entry on my database and its up and running. I
      WANT TO ENHANCE in the worst way.



      HELP!!





      __



      [Non-text portions of this message have been removed]
    • jmgledhill
      What software are you using for your database? I m not the one to help with a database in a website but before you get much help from Notetab, you will have
      Message 2 of 30 , Aug 2, 2008
      • 0 Attachment
        What software are you using for your database? I'm not the one to help with
        a database in a website but before you get much help from Notetab, you will
        have to define what your database is, etc. Is it in MS Access, or Fox Pro,
        etc. It's an issue of sorting the records and much more information will be
        required. IMHO

        CYA, Joe


        [Non-text portions of this message have been removed]
      • fw7oaks
        ... When I tried doily tatted I got one hit, the other way round tatted doily I got 30, if I used tatted % doily where % = word (Pansy, Snowflake, Ruffle
        Message 3 of 30 , Aug 2, 2008
        • 0 Attachment
          --- On Sat, 8/2/08, LaurieK <ladyck3@...> wrote:

          > If you try the website, you will see that you can search for one word
          > only, so if I search for "doily" I get all patterns whether knit,
          > tatting, crochet.. But if I want to find all of the tatted doily
          > patterns I can't.

          When I tried 'doily tatted' I got one hit, the other way round 'tatted doily' I got 30, if I used 'tatted % doily' where % = word (Pansy, Snowflake, Ruffle . . ) I got ten hits

          I'm not sure I understand your problem :-(

          fw
        • LaurieK
          MS Access is the database, the pages are ASP and the data is sorted by Volume and then my Issue Number.. There primary key is autonumber, of couse.. Not sure
          Message 4 of 30 , Aug 2, 2008
          • 0 Attachment
            MS Access is the database, the pages are ASP and the data is sorted by
            Volume and then my Issue Number.. There primary key is autonumber, of
            couse..



            Not sure if Notetab is the answer but pointing me in the right direction
            would be appreciated J



            Laurie



            From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
            Of jmgledhill
            Sent: Saturday, August 02, 2008 5:21 PM
            To: ntb-html@yahoogroups.com
            Subject: RE: [NH] Looking for Resources



            What software are you using for your database? I'm not the one to help with
            a database in a website but before you get much help from Notetab, you will
            have to define what your database is, etc. Is it in MS Access, or Fox Pro,
            etc. It's an issue of sorting the records and much more information will be
            required. IMHO

            CYA, Joe

            [Non-text portions of this message have been removed]





            [Non-text portions of this message have been removed]
          • LaurieK
            LMAO.is my problem. Me? hehehe From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf Of fw7oaks Sent: Saturday, August 02, 2008 6:25 PM
            Message 5 of 30 , Aug 2, 2008
            • 0 Attachment
              LMAO.is my problem. Me? hehehe



              From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
              Of fw7oaks
              Sent: Saturday, August 02, 2008 6:25 PM
              To: ntb-html@yahoogroups.com
              Subject: Re: [NH] Looking for Resources




              --- On Sat, 8/2/08, LaurieK <ladyck3@... <mailto:ladyck3%40tx.rr.com>
              > wrote:

              > If you try the website, you will see that you can search for one word
              > only, so if I search for "doily" I get all patterns whether knit,
              > tatting, crochet.. But if I want to find all of the tatted doily
              > patterns I can't.

              When I tried 'doily tatted' I got one hit, the other way round 'tatted
              doily' I got 30, if I used 'tatted % doily' where % = word (Pansy,
              Snowflake, Ruffle . . ) I got ten hits

              I'm not sure I understand your problem :-(

              fw





              [Non-text portions of this message have been removed]
            • LaurieK
              The search will pull anything with the criteria, supposedly but if you enter tat (which is the topic) and doily you get nothing.. I tried tat % doily w/o
              Message 6 of 30 , Aug 2, 2008
              • 0 Attachment
                The search will pull anything with the criteria, supposedly but if you enter
                tat (which is the topic) and doily you get nothing.. I tried "tat % doily"
                w/o the " and got one "Tat a Doily" but its not pulling from both is only
                pulling what it sees together.. That makes sense in my head, I hope I
                expressed it properly.



                If I try something like Kansas quilt, I get nothing, if I search for State
                Quilt Kansas I get nothing.. the Pattern_Recipe field shows State Quilt
                Patterns Kansas; North Dakota I



                Its not pulling Quilt from Topic and Kansas from Pattern.. Maybe I'm asking
                for too much? Maybe I don't know what I want...



                From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                Of fw7oaks
                Sent: Saturday, August 02, 2008 6:25 PM
                To: ntb-html@yahoogroups.com
                Subject: Re: [NH] Looking for Resources




                --- On Sat, 8/2/08, LaurieK <ladyck3@... <mailto:ladyck3%40tx.rr.com>
                > wrote:

                > If you try the website, you will see that you can search for one word
                > only, so if I search for "doily" I get all patterns whether knit,
                > tatting, crochet.. But if I want to find all of the tatted doily
                > patterns I can't.

                When I tried 'doily tatted' I got one hit, the other way round 'tatted
                doily' I got 30, if I used 'tatted % doily' where % = word (Pansy,
                Snowflake, Ruffle . . ) I got ten hits

                I'm not sure I understand your problem :-(

                fw





                [Non-text portions of this message have been removed]
              • fw7oaks
                ... [snip] ... Yes you are. I have trouble with databases too, if I can t imagine it, I m stuck, but I can imagine your problem. You ve got a pile of 18607
                Message 7 of 30 , Aug 3, 2008
                • 0 Attachment
                  --- On Sun, 8/3/08, LaurieK <ladyck3@...> wrote:

                  [snip]

                  > Its not pulling Quilt from Topic and Kansas from Pattern.. Maybe I'm
                  > asking for too much?

                  Yes you are.

                  I have trouble with databases too, if I can't imagine it, I'm stuck, but I can imagine your problem. You've got a pile of 18607 cards, imagine the cards have three columns, first column contains everything we are not interested in, the second column contains everything written in 'Topic' and the last everything written in 'Pattern_Receipt'.

                  So far so good ?

                  When you type something (say ******) into the search box it's like saying to your faithful but not very bright helper "Find ******" in the Topic column. Hours later after shuffling through the 18607 cards he comes back with say 30 cards, you look at the cards, and say but there's no pattern or receipts with ******.

                  He says "You didn't tell me to look there"

                  All I know about MS Access is that I don't want to learn more, but I suspect you have a query that says something like
                  'Query Topic for ******'
                  and it should say something like
                  'Query Topic AND/OR Pattern_Receipt for ******'
                  You'll have to find somebody else to help you there, you might even need a second input box on the form.

                  > Maybe I don't know what I want...

                  Always possible, but at least I've got a faint clue even if I can't do the detail for you.

                  fw
                • LaurieK
                  Well you head is in the right zone.. with me. and all I can do is pray for you LOL.. Its such a scary place! hehehe Thanks much for entertaining the idea..
                  Message 8 of 30 , Aug 3, 2008
                  • 0 Attachment
                    Well you head is in the right zone.. with me. and all I can do is pray for
                    you LOL.. Its such a scary place! hehehe

                    Thanks much for entertaining the idea.. Its truly appreciated.



                    Laurie



                    From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                    Of fw7oaks
                    Sent: Sunday, August 03, 2008 3:57 AM
                    To: ntb-html@yahoogroups.com
                    Subject: RE: [NH] Looking for Resources



                    --- On Sun, 8/3/08, LaurieK <ladyck3@... <mailto:ladyck3%40tx.rr.com>
                    > wrote:

                    [snip]

                    > Its not pulling Quilt from Topic and Kansas from Pattern.. Maybe I'm
                    > asking for too much?

                    Yes you are.

                    I have trouble with databases too, if I can't imagine it, I'm stuck, but I
                    can imagine your problem. You've got a pile of 18607 cards, imagine the
                    cards have three columns, first column contains everything we are not
                    interested in, the second column contains everything written in 'Topic' and
                    the last everything written in 'Pattern_Receipt'.

                    So far so good ?

                    When you type something (say ******) into the search box it's like saying to
                    your faithful but not very bright helper "Find ******" in the Topic column.
                    Hours later after shuffling through the 18607 cards he comes back with say
                    30 cards, you look at the cards, and say but there's no pattern or receipts
                    with ******.

                    He says "You didn't tell me to look there"

                    All I know about MS Access is that I don't want to learn more, but I suspect
                    you have a query that says something like
                    'Query Topic for ******'
                    and it should say something like
                    'Query Topic AND/OR Pattern_Receipt for ******'
                    You'll have to find somebody else to help you there, you might even need a
                    second input box on the form.

                    > Maybe I don't know what I want...

                    Always possible, but at least I've got a faint clue even if I can't do the
                    detail for you.

                    fw





                    [Non-text portions of this message have been removed]
                  • Don - HtmlFixIt.com
                    ... What you are asking is not html at all. You submit a form to this page: /data/new_wb_lookup.asp That is undoubtedly a script that processes inquiry. You
                    Message 9 of 30 , Aug 3, 2008
                    • 0 Attachment
                      LaurieK wrote:
                      > Well you head is in the right zone.. with me. and all I can do is pray for
                      > you LOL.. Its such a scary place! hehehe
                      >
                      > Thanks much for entertaining the idea.. Its truly appreciated.
                      >
                      >
                      >
                      > Laurie
                      What you are asking is not html at all.

                      You submit a form to this page: /data/new_wb_lookup.asp

                      That is undoubtedly a script that processes inquiry.

                      You will get a lot further at clips, scripting or even off topic than on
                      this list.

                      If you search with google for something like this:
                      asp database query

                      You will get lots of hits.

                      Without seeing your database and your query, I couldn't possibly be too
                      helpful.
                    • LaurieK
                      Thanks Don, for guiding me to another group, its not HTML, not sure what caused me to post here. Appreciate it! From: ntb-html@yahoogroups.com
                      Message 10 of 30 , Aug 3, 2008
                      • 0 Attachment
                        Thanks Don, for guiding me to another group, its not HTML, not sure what
                        caused me to post here.



                        Appreciate it!



                        From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                        Of Don - HtmlFixIt.com
                        Sent: Sunday, August 03, 2008 10:21 AM
                        To: ntb-html@yahoogroups.com
                        Subject: Re: [NH] Looking for Resources



                        LaurieK wrote:
                        > Well you head is in the right zone.. with me. and all I can do is pray for
                        > you LOL.. Its such a scary place! hehehe
                        >
                        > Thanks much for entertaining the idea.. Its truly appreciated.
                        >
                        >
                        >
                        > Laurie
                        What you are asking is not html at all.

                        You submit a form to this page: /data/new_wb_lookup.asp

                        That is undoubtedly a script that processes inquiry.

                        You will get a lot further at clips, scripting or even off topic than on
                        this list.

                        If you search with google for something like this:
                        asp database query

                        You will get lots of hits.

                        Without seeing your database and your query, I couldn't possibly be too
                        helpful.





                        [Non-text portions of this message have been removed]
                      • Alan C
                        (sounds like ultimately you want to make use of your own) but, FWIW you can use the google, have google search only just your site (seamless? ie does so from a
                        Message 11 of 30 , Aug 3, 2008
                        • 0 Attachment
                          (sounds like ultimately you want to make use of your own) but, FWIW
                          you can use the google, have google search only just your site
                          (seamless? ie does so from a form field that you put/have on a page or
                          whatever pages of your site).

                          http://www.stonehenge.com/index.html

                          See it in use at there (scroll down, you'll see it) has done so for a long time.

                          I don't know if you need any sort of (likely free) identifier or etc.
                          from google or not to do so. (there's an AWFID [I don't know what it
                          is] in the next code copied from the above listed site.

                          <!-- Search Google -->
                          <div align="center">
                          <FORM method="GET" action="http://www.google.com/custom">
                          <A class="google" HREF="http://www.google.com/search">
                          <IMG cclass="google" SRC=http://www.google.com/logos/Logo_40wht.gif
                          border=0 ALT=Google align=middle></A><br />

                          <INPUT TYPE=text name=q size=15 maxlength=255 value=""><br />
                          <INPUT type=submit name=sa VALUE="Search mysite">
                          <INPUT type=hidden name=cof
                          VALUE="S:http://www.mysite.com;AH:center;AWFID:c32c3e920bca5918;">
                          <input type=hidden name=domains value="mysite.com"><input type=hidden
                          name=sitesearch value="mysite.com">
                          </FORM>
                          </div>
                          <!-- Search Google -->



                          On Sat, Aug 2, 2008 at 2:24 PM, LaurieK <ladyck3@...> wrote:

                          > I'm in the HTML group for Notepad because its well. web page/site related
                          >
                          [ . . ]

                          >
                          >
                          >
                          > Seriously, any ideas? Does Google offer some sort of free search tool and
                          > if so, is it a site search or can you have it look for key words in a
                          > database?


                          [Non-text portions of this message have been removed]
                        • sisterscape
                          Will Google search a database? I thought it only searched html.
                          Message 12 of 30 , Aug 3, 2008
                          • 0 Attachment
                            Will Google search a database? I thought it only searched html.


                            --- On Sun, 8/3/08, Alan C <acummingsus@...> wrote:

                            > From: Alan C <acummingsus@...>
                            > Subject: Re: [NH] Looking for Resources
                            > To: ntb-html@yahoogroups.com
                            > Date: Sunday, August 3, 2008, 12:25 PM
                            > (sounds like ultimately you want to make use of your own)
                            > but, FWIW
                            > you can use the google, have google search only just your
                            > site
                            > (seamless? ie does so from a form field that you put/have
                            > on a page or
                            > whatever pages of your site).
                            >
                            > http://www.stonehenge.com/index.html
                            >
                            > See it in use at there (scroll down, you'll see it) has
                            > done so for a long time.
                            >
                            > I don't know if you need any sort of (likely free)
                            > identifier or etc.
                            > from google or not to do so. (there's an AWFID [I
                            > don't know what it
                            > is] in the next code copied from the above listed site.
                            >
                            > <!-- Search Google -->
                            > <div align="center">
                            > <FORM method="GET"
                            > action="http://www.google.com/custom">
                            > <A class="google"
                            > HREF="http://www.google.com/search">
                            > <IMG cclass="google"
                            > SRC=http://www.google.com/logos/Logo_40wht.gif
                            > border=0 ALT=Google align=middle></A><br />
                            >
                            > <INPUT TYPE=text name=q size=15 maxlength=255
                            > value=""><br />
                            > <INPUT type=submit name=sa VALUE="Search
                            > mysite">
                            > <INPUT type=hidden name=cof
                            > VALUE="S:http://www.mysite.com;AH:center;AWFID:c32c3e920bca5918;">
                            > <input type=hidden name=domains
                            > value="mysite.com"><input type=hidden
                            > name=sitesearch value="mysite.com">
                            > </FORM>
                            > </div>
                            > <!-- Search Google -->
                            >
                            >
                            >
                            > On Sat, Aug 2, 2008 at 2:24 PM, LaurieK
                            > <ladyck3@...> wrote:
                            >
                            > > I'm in the HTML group for Notepad because its
                            > well. web page/site related
                            > >
                            > [ . . ]
                            >
                            > >
                            > >
                            > >
                            > > Seriously, any ideas? Does Google offer some sort of
                            > free search tool and
                            > > if so, is it a site search or can you have it look for
                            > key words in a
                            > > database?
                            >
                            >
                            > [Non-text portions of this message have been removed]
                            >
                            >
                            > ------------------------------------
                            >
                            > Fookes Software: http://www.fookes.com/
                            > NoteTab website: http://www.notetab.com/
                            > NoteTab Discussion Lists: http://www.notetab.com/groups.php
                            >
                            > ***
                            > Yahoo! Groups Links
                            >
                            >
                            >
                          • LaurieK
                            That s what I was afraid of even bothering with is that I don t think Google will search within a database, its more of a site search where ou have keywords
                            Message 13 of 30 , Aug 3, 2008
                            • 0 Attachment
                              That's what I was afraid of even bothering with is that I don't think Google
                              will search within a database, its more of a "site search" where ou have
                              keywords embedded in the page and it does its thing.



                              I do appreciate everyone's assistance though J



                              Laurie



                              From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                              Of sisterscape
                              Sent: Sunday, August 03, 2008 1:01 PM
                              To: ntb-html@yahoogroups.com
                              Subject: Re: [NH] Looking for Resources



                              Will Google search a database? I thought it only searched html.

                              --- On Sun, 8/3/08, Alan C <acummingsus@...
                              <mailto:acummingsus%40gmail.com> > wrote:

                              > From: Alan C <acummingsus@... <mailto:acummingsus%40gmail.com> >
                              > Subject: Re: [NH] Looking for Resources
                              > To: ntb-html@yahoogroups.com <mailto:ntb-html%40yahoogroups.com>
                              > Date: Sunday, August 3, 2008, 12:25 PM
                              > (sounds like ultimately you want to make use of your own)
                              > but, FWIW
                              > you can use the google, have google search only just your
                              > site
                              > (seamless? ie does so from a form field that you put/have
                              > on a page or
                              > whatever pages of your site).
                              >
                              > http://www.stonehenge.com/index.html
                              >
                              > See it in use at there (scroll down, you'll see it) has
                              > done so for a long time.
                              >
                              > I don't know if you need any sort of (likely free)
                              > identifier or etc.
                              > from google or not to do so. (there's an AWFID [I
                              > don't know what it
                              > is] in the next code copied from the above listed site.
                              >
                              > <!-- Search Google -->
                              > <div align="center">
                              > <FORM method="GET"
                              > action="http://www.google.com/custom">
                              > <A class="google"
                              > HREF="http://www.google.com/search">
                              > <IMG cclass="google"
                              > SRC=http://www.google.com/logos/Logo_40wht.gif
                              > border=0 ALT=Google align=middle></A><br />
                              >
                              > <INPUT TYPE=text name=q size=15 maxlength=255
                              > value=""><br />
                              > <INPUT type=submit name=sa VALUE="Search
                              > mysite">
                              > <INPUT type=hidden name=cof
                              > VALUE="S:http://www.mysite.com;AH:center;AWFID:c32c3e920bca5918;">
                              > <input type=hidden name=domains
                              > value="mysite.com"><input type=hidden
                              > name=sitesearch value="mysite.com">
                              > </FORM>
                              > </div>
                              > <!-- Search Google -->
                              >
                              >
                              >
                              > On Sat, Aug 2, 2008 at 2:24 PM, LaurieK
                              > <ladyck3@... <mailto:ladyck3%40tx.rr.com> > wrote:
                              >
                              > > I'm in the HTML group for Notepad because its
                              > well. web page/site related
                              > >
                              > [ . . ]
                              >
                              > >
                              > >
                              > >
                              > > Seriously, any ideas? Does Google offer some sort of
                              > free search tool and
                              > > if so, is it a site search or can you have it look for
                              > key words in a
                              > > database?
                              >
                              >
                              > [Non-text portions of this message have been removed]
                              >
                              >
                              > ------------------------------------
                              >
                              > Fookes Software: http://www.fookes.com/
                              > NoteTab website: http://www.notetab.com/
                              > NoteTab Discussion Lists: http://www.notetab.com/groups.php
                              >
                              > ***
                              > Yahoo! Groups Links
                              >
                              >
                              >





                              [Non-text portions of this message have been removed]
                            • jmgledhill
                              Try doing a search in Google for html database and you will find converters that should let you do searches on multiple fields. [Non-text portions of this
                              Message 14 of 30 , Aug 3, 2008
                              • 0 Attachment
                                Try doing a search in Google for "html database" and you will find
                                converters that should let you do searches on multiple fields.


                                [Non-text portions of this message have been removed]
                              • LaurieK
                                Oh cool.. thanks for the tip. off to google J From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf Of jmgledhill Sent: Sunday, August 03,
                                Message 15 of 30 , Aug 3, 2008
                                • 0 Attachment
                                  Oh cool.. thanks for the tip. off to google J



                                  From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                                  Of jmgledhill
                                  Sent: Sunday, August 03, 2008 1:40 PM
                                  To: ntb-html@yahoogroups.com
                                  Subject: RE: [NH] Looking for Resources



                                  Try doing a search in Google for "html database" and you will find
                                  converters that should let you do searches on multiple fields.

                                  [Non-text portions of this message have been removed]





                                  [Non-text portions of this message have been removed]
                                • loro
                                  I m not all that sure about what you want to do, really, but maybe one of these scipts does what you want.
                                  Message 16 of 30 , Aug 3, 2008
                                  • 0 Attachment
                                    I'm not all that sure about what you want to do, really, but maybe
                                    one of these scipts does what you want.
                                    <http://www.hotscripts.com/ASP/Scripts_and_Components/Searching/Database_Search/>

                                    Lotta
                                  • Alan C
                                    re google, I had used the word site I think Don had it a while back ie form etc. Perl can do this (mute since this is already known). -- I assume that when
                                    Message 17 of 30 , Aug 3, 2008
                                    • 0 Attachment
                                      re google, I had used the word "site"

                                      I think Don had it a while back ie "form" etc.

                                      Perl can do this (mute since this is already known).
                                      --

                                      I assume that when using web browser to search said database that it is a
                                      "form" (where the user interactivity is) where user's query is entered --
                                      and that it would then be one of the "methods" ie for example cgi, perl_cgi,
                                      perl_dbi, cold fusion markup language, python_+_whatever, asp,
                                      yet_another_different_backend_method_of_your_choice_goes_here.

                                      Didn't Laurie say it's asp?

                                      But it's not to matter for what Laurie seeks here, really, (as to whatever
                                      the "back end" (A.K.A method(s)) is.

                                      The action (that's needed here) is in getting the form filled with the
                                      search query ? I guess?

                                      Or ?? does Laurie need to come up with a backend (and/or entire) method so
                                      as with which to accomplish the searching of a database as in right now
                                      currently there is no (via www) searching of the data base.

                                      --
                                      Alan.


                                      [Non-text portions of this message have been removed]
                                    • Alan C
                                      (it s not hidden) (doesn t need to be hidden) IOW anyone viewing source in web browser: http://www.ladyck.com/data/new_wb_lookup.asp works for when entering
                                      Message 18 of 30 , Aug 4, 2008
                                      • 0 Attachment
                                        (it's not hidden) (doesn't need to be hidden) IOW anyone viewing source in
                                        web browser:

                                        http://www.ladyck.com/data/new_wb_lookup.asp

                                        works for when entering one search word (I entered "yarn").

                                        Uses the "get" (I forget if this get is an http, cgi, whatever--method). A
                                        back end of some sort exists due to the output results (are found and then)
                                        are (outputted as) dynamically written html.

                                        Laurie wants to implement boolean.

                                        Laurie, how is the actual searching IOW what brand is the database

                                        IOW different types/brand of databases likely have need to accept certain
                                        type of query

                                        IOW does the database itself support boolean (if not then something need
                                        detect when two words and divvy it up into two separate queries, assembling
                                        all of the output results together.

                                        Likely your database supports boolean but that you seek how to query it in
                                        boolean.

                                        HTH. Alan.


                                        [Non-text portions of this message have been removed]
                                      • Hugo Paulissen
                                        Hi, That is a good source, but maybe not for beginners? I went through this a couple of years ago (ASP - Queries - MS Access...), and found out that the main
                                        Message 19 of 30 , Aug 4, 2008
                                        • 0 Attachment
                                          Hi,
                                          That is a good source, but maybe not for beginners? I went through this a couple of years ago (ASP - Queries - MS Access...), and found out that the main thing to master is the querystring. There are ways to have the querystring that is sent to the db displayed to the user (don't ask me now, I'm no longer active in that field); if you enable this you can actually see what the exact searchstring contains. That helped me a lot; it gave me insight in the inner workings of the whole process.
                                          The form that handles the user input results in a string that must be passed to the database. And this needs to be (fine-)tuned. You'll need to do some learning (lots of websites available), otherwise you have to look for alternatives, but do not give up to soon...
                                          It may help to change the string within the asp-page itself (append wildchards for instance) - in order to get better results. If you know exactly what the string should be (you can use trial and error) you have to find a way to have this string generated by means of the interaction with the user. Without actually seeing the asp code, and not knowing what the connection is, it is hard to help you out.
                                          I found the 4guysfromrolla-website very helpful. Another tool that I used to master the database techniques was from Roman Koch (http://www.romankoch.ch/capslock/editor.htm%c2%a0or%c2%a0http://www.4guysfromrolla.com/webtech/110999-1.shtml). Play with it and try to see how you can benefit from the example-code. It may be old, but I reckon that will not be a big problem.
                                          Frontpage is the MS tool that may help you further: it may be used to generate db-connections and instructions in asp directly. I've followed some tutorials about the Frontpage database wizard and learnt a lot from that (see a.o. http://www.frontpagehowto.com/examples.asp). I must acknowledge that I used a tool to have all superfluous code stripped automatically (Notetab was very helpful in that respect). So: I built some code with fronpage, had that stripped in order to look at the resulting querystring, and most of the time I edited the resulting asp-page (but you have to know what you are doing, if you do it that way...).
                                          Hope this helps.
                                          Hugo



                                          ----- Original Message ----
                                          From: loro <loro-spam01-@...>
                                          To: ntb-html@yahoogroups.com
                                          Sent: Monday, August 4, 2008 3:04:40 AM
                                          Subject: RE: [NH] Looking for Resources


                                          I'm not all that sure about what you want to do, really, but maybe
                                          one of these scipts does what you want.
                                          <http://www.hotscrip ts.com/ASP/ Scripts_and_ Components/ Searching/ Database_ Search/>

                                          Lotta






                                          [Non-text portions of this message have been removed]
                                        • Hugo Paulissen
                                          Hi LaurieK, Oh yes, this may be of help as well... Also from Roman Koch: http://www.romankoch.ch/capslock/query.htm Query.ASP - a general-purpose database
                                          Message 20 of 30 , Aug 4, 2008
                                          • 0 Attachment
                                            Hi LaurieK,
                                            Oh yes, this may be of help as well... Also from Roman Koch: http://www.romankoch.ch/capslock/query.htm
                                            Query.ASP - a general-purpose database query manager for Microsoft Access tables
                                            Hugo




                                            [Non-text portions of this message have been removed]
                                          • LaurieK
                                            Loro, Thanks for the resource, I got it LATE last night and will check it out today.. Alan, MS Access is the what I m using for the DB construction. I know
                                            Message 21 of 30 , Aug 4, 2008
                                            • 0 Attachment
                                              Loro,



                                              Thanks for the resource, I got it LATE last night and will check it out
                                              today..



                                              Alan,

                                              MS Access is the what I'm using for the DB construction. I know NOTHING
                                              about SQL or MySQL. or any other methods.. I know enough about Access to be
                                              DANGEROUS.. I'm using Office 2007 but my server doesn't support that version
                                              so the DB is in 2003 version.



                                              Yes I am using a "form" within my "asp" page for the search..



                                              Hugo.

                                              I'm using Dreamweaver. I have FrontPage but for work purposes/support I'm
                                              using Dreamweaver as my webpage editor.. The tip you gave me about the query
                                              string. we did something once about using a "+" for the end of the search
                                              string but that was when we had a drop down menu I believe. but I will go
                                              back and check into my other resources, thank for the memory Jog! J



                                              I'll also check out the other resources and tips that you offered, I
                                              appreciate it..



                                              Jmgledhill, sisterscape, Don, Alan, fw7oaks...

                                              I'm getting all of these search suggestions and I'm like.. OH YEAH. I said
                                              early on, I even have a mental block on what to or how to properly search
                                              not quite knowing what I should use to google with.. And have obtained an
                                              education from these searches as well..



                                              Thank you everyone for all of your help, recommendations and suggestions..
                                              I'll keep you posted as I learn (if I can teach this old dog new tricks
                                              hehehe) J



                                              Laurie





                                              From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                                              Of loro
                                              Sent: Sunday, August 03, 2008 8:05 PM
                                              To: ntb-html@yahoogroups.com
                                              Subject: RE: [NH] Looking for Resources



                                              I'm not all that sure about what you want to do, really, but maybe
                                              one of these scipts does what you want.
                                              <http://www.hotscripts.com/ASP/Scripts_and_Components/Searching/Database_Sea
                                              rch/>

                                              Lotta





                                              [Non-text portions of this message have been removed]
                                            • loro
                                              ... You can t mean that rolling your own would be easier for beginners? Not all of your links worked, but the page I could reach seemed to deal with that.
                                              Message 22 of 30 , Aug 4, 2008
                                              • 0 Attachment
                                                Hugo wrote:
                                                >That is a good source, but maybe not for beginners?

                                                You can't mean that rolling your own would be easier for beginners?
                                                Not all of your links worked, but the page I could reach seemed to
                                                deal with that.

                                                Myself, I'm quite prolific installing scripts and can modify them
                                                with a light hand. Not as successful writing them. ;-o)

                                                Lotta
                                              • Hugo Paulissen
                                                Hi Lotta, ... No, but my experience was that most of those scripts needed some tweaking (they do not always do what you really need), or are meant for specific
                                                Message 23 of 30 , Aug 4, 2008
                                                • 0 Attachment
                                                  Hi Lotta,
                                                  > You can't mean that rolling your own would be easier for beginners?

                                                  No, but my experience was that most of those scripts needed some tweaking (they do not always do what you really need), or are meant for specific server-configurations...
                                                  > Not all of your links worked, but the page I could reach seemed to
                                                  deal with that.

                                                  I clicked the links in my mail, on my end it seems to be ok.
                                                  Regards,
                                                  Hugo




                                                  [Non-text portions of this message have been removed]
                                                • Alan C
                                                  ... [ . . ] Alan, ... http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=XIF&q=boolean+asp+microsoft+access&btnG=Search
                                                  Message 24 of 30 , Aug 4, 2008
                                                  • 0 Attachment
                                                    On Mon, Aug 4, 2008 at 5:39 AM, LaurieK <ladyck3@...> wrote:

                                                    > Loro,

                                                    [ . . ]

                                                    Alan,
                                                    >
                                                    > MS Access is the what I'm using for the DB construction. [ . . ]
                                                    >
                                                    > Yes I am using a "form" within my "asp" page for the search..


                                                    http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=XIF&q=boolean+asp+microsoft+access&btnG=Search

                                                    At Google, I entered the next 4 words: boolean asp microsoft access

                                                    http://databases.aspfaq.com/database/how-do-i-handle-bit/boolean-columns.html

                                                    at there if you scroll slightly down can seen (asp) form (boolean search)
                                                    but it uses "post" instead of (alternative, maybe) "get", evidently uses 3
                                                    asp pages to achieve the query AND it has at least slight bit of SQL in it
                                                    too.

                                                    Isn't this fun? (don't ask me, I know nothing about it the asp, access).

                                                    I did do once, some time ago, I wrote a Perl--cgi interface to a

                                                    http://www.mysql.com/

                                                    database

                                                    which is not Microsoft Access. not asp.

                                                    on an irrelevant note: but I don't know if Mysql supports boolean or not.
                                                    --

                                                    Perl abstracts (keeps details of the SQL away from the Perl programmer)
                                                    which my point is here that a Perl programmer not need to know SQL (Perl
                                                    generates the SQL) for what I was doing the aforementioned Perl--cgi--mysql.

                                                    There's got to be perhaps some GUI app that abstracts (make it easier, more
                                                    user friendly) as opposed to geeky, machine_y like when need to do (what are
                                                    we doing here?)

                                                    I guess (the goal) it is to construct an (boolean) asp query to query an
                                                    access database

                                                    http://forums.aspfree.com/code-bank-54/advanced-boolean-search-indexing-43470.html

                                                    turned up when I now just added abstract onto the google search, a new
                                                    google search, thus:

                                                    abstract boolean asp microsoft access

                                                    (methinks google getting confused on that one [no abstract for/as a word
                                                    returned]

                                                    But it did turn up a code bank forum "advanced boolean search" at aspfree
                                                    (oh, it appears that it may be a forum about the link Hugo posted about the
                                                    Query.asp) where can ask questions.

                                                    Alan.


                                                    [Non-text portions of this message have been removed]
                                                  • Don - HtmlFixIt.com
                                                    ... An ASP page, much like a perl cgi page or a PHP page in fact may contain many pages and coding to have it do something. If you just hit the page with no
                                                    Message 25 of 30 , Aug 5, 2008
                                                    • 0 Attachment
                                                      Alan C wrote:
                                                      > On Mon, Aug 4, 2008 at 5:39 AM, LaurieK <ladyck3@...> wrote:
                                                      >
                                                      >> Loro,
                                                      >
                                                      > [ . . ]
                                                      >
                                                      > Alan,
                                                      >> MS Access is the what I'm using for the DB construction. [ . . ]
                                                      >>
                                                      >> Yes I am using a "form" within my "asp" page for the search..
                                                      >

                                                      An ASP page, much like a perl cgi page or a PHP page in fact may contain
                                                      many pages and coding to have it do something.

                                                      If you just hit the page with no post or get information provided, then
                                                      it displays a page. You can use view source to see the content
                                                      generated by the ASP page, but contrary to what someone is suggesting,
                                                      you cannot see what is in the ASP pages code. To repeat you see only
                                                      the generated html -- and what is generated is controlled by what input
                                                      (or no input) is given by the user.

                                                      If you look at the ASP page, you will see a series of "choices" or
                                                      branches in the coding. It will say something like:

                                                      if there is information provided by our form then process that, create a
                                                      result and display the result

                                                      or

                                                      if there is not information provided by our form then just display the
                                                      basic page with the search form

                                                      There may be many other branches. We have written entire sites in one
                                                      script so the page address is the same for every page. The only way to
                                                      see this coding is to look in the raw coding of the ASP page. First
                                                      MAKE A BACKUP, and then using notetab, open your ASP page. Start
                                                      looking around. You will find a part that ultimately generates the
                                                      query. That is the part we are looking for. We can then tweak what is
                                                      being asked for.

                                                      Your function (part of the ASP program) that builds results isn't very
                                                      well developed, because it does not tell me no results found. It still
                                                      outputs the table heading, but the table is empty of results.

                                                      I believe something like this in your ASP is where you are headed.
                                                      http://www.asp101.com/samples/viewasp.asp?file=db_search_multi.asp

                                                      Again there are more coders in the clips or in the scripts lists than
                                                      there probably are here (no offense intended, but I think you'll find
                                                      the heavy coders in one of those two lists) and/or in off topic.
                                                    • LaurieK
                                                      OH MY GOODNESS. I sure did strike up the conversation didn t I? Man I sure appreciate it.. I ve got LOTS to research here... my mind is going swish swish
                                                      Message 26 of 30 , Aug 5, 2008
                                                      • 0 Attachment
                                                        OH MY GOODNESS. I sure did strike up the conversation didn't I?

                                                        Man I sure appreciate it.. I've got LOTS to research here... my mind is
                                                        going swish swish swish.

                                                        Thanks!!!! J



                                                        Laurie





                                                        From: ntb-html@yahoogroups.com [mailto:ntb-html@yahoogroups.com] On Behalf
                                                        Of Alan C
                                                        Sent: Tuesday, August 05, 2008 1:18 AM
                                                        To: ntb-html@yahoogroups.com
                                                        Subject: Re: [NH] Looking for Resources



                                                        On Mon, Aug 4, 2008 at 5:39 AM, LaurieK <ladyck3@...
                                                        <mailto:ladyck3%40tx.rr.com> > wrote:

                                                        > Loro,

                                                        [ . . ]

                                                        Alan,
                                                        >
                                                        > MS Access is the what I'm using for the DB construction. [ . . ]
                                                        >
                                                        > Yes I am using a "form" within my "asp" page for the search..

                                                        http://www.google.com/search?hl=en
                                                        <http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US
                                                        %3Aofficial&hs=XIF&q=boolean+asp+microsoft+access&btnG=Search>
                                                        &client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=XIF&q=boolean+asp+mi
                                                        crosoft+access&btnG=Search

                                                        At Google, I entered the next 4 words: boolean asp microsoft access

                                                        http://databases.aspfaq.com/database/how-do-i-handle-bit/boolean-columns.htm
                                                        l

                                                        at there if you scroll slightly down can seen (asp) form (boolean search)
                                                        but it uses "post" instead of (alternative, maybe) "get", evidently uses 3
                                                        asp pages to achieve the query AND it has at least slight bit of SQL in it
                                                        too.

                                                        Isn't this fun? (don't ask me, I know nothing about it the asp, access).

                                                        I did do once, some time ago, I wrote a Perl--cgi interface to a

                                                        http://www.mysql.com/

                                                        database

                                                        which is not Microsoft Access. not asp.

                                                        on an irrelevant note: but I don't know if Mysql supports boolean or not.
                                                        --

                                                        Perl abstracts (keeps details of the SQL away from the Perl programmer)
                                                        which my point is here that a Perl programmer not need to know SQL (Perl
                                                        generates the SQL) for what I was doing the aforementioned Perl--cgi--mysql.

                                                        There's got to be perhaps some GUI app that abstracts (make it easier, more
                                                        user friendly) as opposed to geeky, machine_y like when need to do (what are
                                                        we doing here?)

                                                        I guess (the goal) it is to construct an (boolean) asp query to query an
                                                        access database

                                                        http://forums.aspfree.com/code-bank-54/advanced-boolean-search-indexing-4347
                                                        0.html

                                                        turned up when I now just added abstract onto the google search, a new
                                                        google search, thus:

                                                        abstract boolean asp microsoft access

                                                        (methinks google getting confused on that one [no abstract for/as a word
                                                        returned]

                                                        But it did turn up a code bank forum "advanced boolean search" at aspfree
                                                        (oh, it appears that it may be a forum about the link Hugo posted about the
                                                        Query.asp) where can ask questions.

                                                        Alan.

                                                        [Non-text portions of this message have been removed]





                                                        [Non-text portions of this message have been removed]
                                                      Your message has been successfully submitted and would be delivered to recipients shortly.