[thelist] Search Engine recommendations
Biddy Hughes
biddy at s4i.com
Thu Mar 1 19:04:04 CST 2001
Good afternoon all
I'm trying to source an out of the box search engine solution for a client
of mine.
The client's functionality/requirements are that it provide:
a. Simple keyword search function
b. Advanced search function (boolean search)
c. Category-specific search (Categories specified in meta-data)
d. Cross-site search (To search documents housed on a different different
site on a different server)
Infoseek has been recommended but I'm looking for any other recommendations
that meet all 4 needs.
thanks so much in advance,
Biddy :)
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]
Sent: Thursday, March 01, 2001 2:05 PM
To: thelist at lists.evolt.org
Subject: thelist digest, Vol 1 #1153 - 37 msgs
Send thelist mailing list submissions to
thelist at lists.evolt.org
To subscribe or unsubscribe via the web, visit
http://lists.evolt.org/mailman/listinfo/thelist
or, via email, send a message with subject or body 'help' to
thelist-request at lists.evolt.org
You can reach the person managing the list at
thelist-admin at lists.evolt.org
When replying, please edit your Subject line so it is more specific than
"Re: Contents of thelist digest..."
Today's Topics:
1. RE: Included files (Tab Alleman)
2. Re: <strong> and <em> - thanks! (Mike DeHart)
3. Notepad Replacement (revived) (Joshua OIson)
4. OT: Test message (Alan Mccoy)
5. RE: Fixed parts on a page (previously Re: [thelist] menus without
frames) (Aylard JA (James))
6. I Need Help Detecting Flash With ASP (Andre Gaulin)
7. RE: I Need Help Detecting Flash With ASP (Fortune Elkins)
8. RE: Fixed parts on a page (previously Re: [thelist] menus without
frames) (Fortune Elkins)
9. RE: Included files (Scott Dexter)
10. legal documents (Ryan Finley)
11. Re: <strong> and <em> (was: Re: [thelist] customizing homesite) (John
Starkey)
12. RE: You need to read me. Really. (A. Erickson)
13. Headlines from evolt.org for March 1, 2001 (thesite at lists.evolt.org)
14. RE: I Need Help Detecting Flash With ASP (Donald Patenaude)
15. RE: Fixed parts on a page (previously Re: [thelist] menus without
frames) (Luther, Ron)
16. Re: <strong> and <em> (was: Re: [thelist] customizing homesite) (Erika
Meyer)
17. RE: Accessibility and Validation at War (Ben Dyer)
18. RE: Accessibility and Validation at War (Jake Stetser)
19. ASP, SQL, Recordsets, Best Practices (Michele Foster)
20. RE: Accessibility and Validation at War (Ben Dyer)
21. RE: ASP, SQL, Recordsets, Best Practices (Scott Dexter)
22. Re: cheap webhosting / domain name (arch)
23. Re: Non-Deprecated HTML Presentational Elements (was,
C SS Font Sizes) (martin.p.burns at uk.pwcglobal.com)
24. Re: ASP, SQL, Recordsets, Best Practices (rudy)
25. [offlist] Re: [***list] ASP, SQL, Recordsets, Best Practices (Michele
Foster)
26. Apologies .. was .. Re: [thelist] [offlist] Re: [***list] ASP, SQL,
Recordsets, Best Practices (Michele Foster)
27. Re: ASP, SQL, Recordsets, Best Practices (Michele Foster)
28. Re: ASP, SQL, Recordsets, Best Practices (Michele Foster)
29. Need a free newsgroup package for a non-profit (Pearson, John)
30. RE: ASP, SQL, Recordsets, Best Practices (Scott Dexter)
31. Re: ASP, SQL, Recordsets, Best Practices (Warden, Matt)
32. IE6 "compatible mode" / PNG support (Filip Salomonsson)
33. DB question (Michael Barrett)
--__--__--
Message: 1
From: "Tab Alleman" <talleman at autobex.com>
To: <thelist at lists.evolt.org>
Subject: RE: [thelist] Included files
Date: Thu, 1 Mar 2001 09:47:30 -0500
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
I do this with my connection strings.. it hadn't occurred to me to do it
with SQL strings, but if I used the same ones on a lot of different pages,
sure I'd do it. I wouldn't put in a string that I use on less than 50% of
my pages though.
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Asif Suria
Sent: Wednesday, February 28, 2001 8:15 PM
To: thelist at lists.evolt.org
Subject: [thelist] Included files
I had a question about included files as well. Almost
all my ASP files have SQL statements and some of them
use the same SQL statements. Would it be a good idea
to put all the SQL statements into a single file and
then include this file in all the ASP files? Would
this cause a lot of overhead?
Asif
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
--__--__--
Message: 2
Date: Thu, 01 Mar 2001 10:35:21 -0500
To: thelist at lists.evolt.org
From: Mike DeHart <mike at dehart.net>
Subject: [thelist] Re: <strong> and <em> - thanks!
Reply-To: thelist at lists.evolt.org
Thanks so much for the clarifications. I'd used them for years & finally
(and erroneously) concluded "surely any new auditory device must now
recognize <b> & <i> ... they're so prevalent."
Not! Amazing for infrequently they're used.
Peace... m
At 08:15 AM 3/1/01, iris wrote:
>--- Mike DeHart <mike at dehart.net> wrote:
> > Another question... are strong & em still nec. for
> > universal access in 4.x+
> > browsers?
> >
> > m
>
>screenreaders, as used by blind/visually impaired ppl,
>audibly emphasize words in <strong> and <em> tags.
>
>iris
>
>
>__________________________________________________
>Do You Yahoo!?
>Get email at your own domain with Yahoo! Mail.
>http://personal.mail.yahoo.com/
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
--__--__--
Message: 3
From: "Joshua OIson" <joshua at alphashop.net>
To: <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 11:08:58 -0800
charset="iso-8859-1"
Subject: [thelist] Notepad Replacement (revived)
Reply-To: thelist at lists.evolt.org
I don't know if this ever found a simple solution, but I figured something
out today.
<tip type="windows NT" name="Replacing Notepad">
If you have replaced notepad.exe with your favorite text editor, but are
still dismayed that right-click->vie source still brings up the old notepad
(?), try also replacing the notepad.exe in the WintNT/System32 folder.
</tip>
-joshua
--__--__--
Message: 4
From: Alan Mccoy <amccoy at altairtek.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 11:06:24 -0500
charset="iso-8859-1"
Subject: [thelist] OT: Test message
Reply-To: thelist at lists.evolt.org
This is a test message. Hope it works!
Alan
--__--__--
Message: 5
From: "Aylard JA (James)" <jaylard at equilon.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: Fixed parts on a page (previously Re: [thelist] menus without
frames)
Date: Thu, 1 Mar 2001 10:00:04 -0600
charset="windows-1252"
Reply-To: thelist at lists.evolt.org
Naju,
> I told him, without really knowing how, that there is a way to do that
with
> html, css, javascript and/or combinations of these. Now I'm curious, how
do
> you do that?, have a part of the page fixed in the same position.
The level of CSS supported by most browsers today does not do this
very well -- you have to use scripting to reposition an absolutely
positioned element as the page scrolls, which is often distracting (it
results in hopping and jittering). msnbc.com used to do this with
advertising on its pages, but seems to have dropped the practice.
The CSS that is designed to make your suggestion work -- without
scripting -- is "position: fixed". Currently, apart from its use with
background images ("background-position: fixed"), it is only supported by
Netscape 6.x. Hopefully the release version of IE 6 will also support it,
but Peter-Paul Koch found that the early beta currently floating around the
web does not.
Right now, unfortunately, frames are about the only practical way to
fix content in a particular part of the window for most browsers.
James Aylard
--__--__--
Message: 6
From: "Andre Gaulin" <gaulin at mac.com>
To: <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 11:23:09 -0500
charset="iso-8859-1"
Subject: [thelist] I Need Help Detecting Flash With ASP
Reply-To: thelist at lists.evolt.org
Hi everyone...
does anyone have a good, solid flash detection script? i want to test for
flash on one page and then set a session variable in my global ASA. that
way if the variablei n the global ASA is true i don;t have to worry about
testing for flash, and if it is false i can just replace flash with an image
or something else...
any help is greatly appreciated
andre
PS - browser hawk is not an option at this time...
--__--__--
Message: 7
From: Fortune Elkins <fortune_elkins at summithq.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Cc: "'Andre Gaulin'" <gaulin at mac.com>
Subject: RE: [thelist] I Need Help Detecting Flash With ASP
Date: Thu, 1 Mar 2001 11:49:20 -0500
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
hiya a!
>does anyone have a good, solid flash detection script?
yeah, rush over to the macromedia exchange, where they have a set of nice
flash detection scripts as extensions for DW/UD.
or go to moock.org and use his.
hth,
fortune
----------------------------------------------------------------------------
--------------------
The views and opinions expressed in this email message are the sender's
own, and do not necessarily represent the views and opinions of Summit
Systems Inc.
--__--__--
Message: 8
From: Fortune Elkins <fortune_elkins at summithq.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: Fixed parts on a page (previously Re: [thelist] menus without
frames)
Date: Thu, 1 Mar 2001 11:53:04 -0500
charset="windows-1252"
Reply-To: thelist at lists.evolt.org
hiya j!
>frames are about the only practical way to
>fix content in a particular part of the window for most browsers.
check out http://www.derailer.org/temp/stayput.html
view the source, try it out in Netscape & IE, see what you think. i didn't
write it...weavah did. <g>
hth,
fortune
----------------------------------------------------------------------------
--------------------
The views and opinions expressed in this email message are the sender's
own, and do not necessarily represent the views and opinions of Summit
Systems Inc.
--__--__--
Message: 9
From: Scott Dexter <sgd at ti3.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: [thelist] Included files
Date: Thu, 1 Mar 2001 10:54:58 -0600
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
>
> I had a question about included files as well. Almost
> all my ASP files have SQL statements and some of them
> use the same SQL statements. Would it be a good idea
> to put all the SQL statements into a single file and
> then include this file in all the ASP files? Would
> this cause a lot of overhead?
put common ones into functions and have a separate functions.asp page that
you include. A good trick is to have your ASP include file have *zero* HTML
in them --that way the ASP engine can cache the parsed code.
The MS way is to have the SQL statements in Application variables and
replace tokens with actual values when you use it. Example:
(MSCSQueryMap is an Application scope dictionary, AddQuery() is just a
wrapper function to include recordset settings with the statement)
Set MSCSQueryMap.dept_by_id = AddQuery("SELECT dept_id, dept_name,
dept_description FROM mall_dept WHERE dept_id = :1")
I'm not so sure I subscribe to that method, but it does keep things in one
place (the global.asa). I guess I don't like messing with the global.asa
more than I have to, because everytime you save it, the site has to restart,
and I don't like doing that to my users....
sgd
--__--__--
Message: 10
From: Ryan Finley <RyanF at SonicFoundry.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: [thelist] legal documents
Date: Thu, 1 Mar 2001 11:19:56 -0600
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
Someone at a university has expressed interest in using my website
internally. Since it is in ASP and "open-source", I want to make sure that
I have a legal agreement that prohibits them from reselling the code, etc.
In addition, I need to draw up a contract for a yearly license.
Can anyone give some good pointers? I remember a NYTimes article about a
good law site, but I can't remember the name...
Thanks,
Ryan Finley
President - SurveyMonkey.com
--__--__--
Message: 11
Date: Thu, 01 Mar 2001 10:38:03 -0700
From: John Starkey <jstarkey at advancecreations.com>
Reply-To: jstarkey at advancecreations.com
Organization: Advance Creations
To: thelist at lists.evolt.org
Subject: Re: <strong> and <em> (was: Re: [thelist] customizing homesite)
Reply-To: thelist at lists.evolt.org
Do they do it for <.b> and <.i> tags also? Why did they turn things over
to <.strong> and <.em>? Anyone know?
iris wrote:
> --- Mike DeHart <mike at dehart.net> wrote:
> > Another question... are strong & em still nec. for
> > universal access in 4.x+
> > browsers?
> >
> > m
>
> screenreaders, as used by blind/visually impaired ppl,
> audibly emphasize words in <strong> and <em> tags.
>
> iris
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
--__--__--
Message: 12
From: "A. Erickson" <amanda at gawow.com>
To: <thelist at lists.evolt.org>
Subject: RE: [thelist] You need to read me. Really.
Date: Thu, 1 Mar 2001 09:43:44 -0800
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
With permission from Dan, I wanted to add this one little thing that I think
makes mailing lists of this size work so much better.
Descriptive subject lines.
Please be descriptive. Please don't ever send a "no subject" or blank
subject line to the list. Please don't send things like "aiiiiii!" or "help
me!" or "I'm going crazy" in your subject line -- that does not much help
others to help you.
Please, if you're on the digest -- never put the digest subject in the
subject line. Copy and paste the subject line from the email within the
digest to which you're replying. This will help everyone to figure out what
you're talking about.
Oh, and this goes without saying, never quote the entire digest. Quote only
the part to which you are replying.
Thanks!!
- amanda
> Hi,
>
> I'm Dan. You may know me as djc, Daniel, 'The guy buying another pitcher
> of beer', or even 'uhh.. who?'. I happen to be the guy that runs
> thelist, and its come to my attention lately that my laxidazical ways of
> list administration and over easy-goingness(is that even a word?
> *shrug*) on my part have led to what I've come to know as 'TALKS' or
> "Thelisters Abiding in Lengthy offtopiK emailS" Yes, thats topik with a
> 'K'. w3rd.
>
> At any rate, 'TALKS', when left unchecked and untreated, has been known
> to cause general unhappiness and bitching on thelist about people not
> respecting their fellow evolters. To make sure you don't contribute to
> "TALKS" follow these important guidelines:
>
> - Read http://lists.evolt.org/index.cfm/a/listinfo
>
> - Trim those footers!! At the bottom of each an every email is a footer
> that has links to helpful thelist pages. Sometimes, those footers get
> left on by people when they respond to a post, which can cause
> crankiness, irritability, and general non-smurfyness in those evolters
> who recieve the digest list, or our european/south american/etc brethren
> who have to pay for their Internet Service. In my own independant
> studies, I've proven that the cost of 'unsnipped footers' to an average
> digest mode evolter from France is well over US $1,121,992.09 per year!
> In other words, TRIM those posts!!! Thats a boatload of wine!
>
> - If you post off-topic messages to thelist you must pay with a <tip>.
> If you have no clue what a <tip> is, read the URL above.
>
> - Snip off unrelevant or uncommented parts of the email you're replying
> to. This will also cut down on the average oversea digest readers phone
> bill.
>
> - Have fun.
>
> Remember, fighting together to battle "TALKS" is the only way to win! So
> do your part! :)
>
> In all seriousness, please trim those posts and read the guidelines. We
> have a cool list here for a reason.. Thanks for doing your part and
> letting me not have to post bitchy emails like many other lists ;)
>
> If anyone has questions or comments they'd like to put to me directly,
> as always, feel free to drop me an email offlist and we'll chat..
>
> Also, if anyone has imports or imported vodka they'd like to put *in* me
> directly, as always, feel free to drop me a case at home and we'll be
> friends.. ;)
>
> .djc.
--__--__--
Message: 13
From: thesite at lists.evolt.org
Date: Thu, 01 Mar 2001 12:02:00 +0000
To: thelist at lists.evolt.org
Subject: [thelist] Headlines from evolt.org for March 1, 2001
Reply-To: thelist at lists.evolt.org
evolt.org headlines for March 1, 2001
Third Column Slickness - Screen Size Customization by: andyed
http://evolt.org/article/headlines/17/5776/index.html
To Hell With Bad Editors by: aardvark
http://evolt.org/article/headlines/25/6096/index.html
Evoltageddon 2 by: bobdavis
http://evolt.org/article/headlines/1/6160/index.html
Happy reading...
the evolt.org admin team
--__--__--
Message: 14
Date: Thu, 01 Mar 2001 13:48:09 -0500
To: thelist at lists.evolt.org
From: Donald Patenaude <donald_patenaude at hms.harvard.edu>
Subject: RE: [thelist] I Need Help Detecting Flash With ASP
ithq.com>
Reply-To: thelist at lists.evolt.org
I use this
<SCRIPT LANGUAGE="JavaScript">
<!--
function detectflash(){
//********Set the names of your web pages here:*****
flashpage = "movie2.htm"
upgradepage = "plugin2.htm"
nonflashpage = "plugin2.htm"
cantdetectpage = "plugin2.htm"
//**************************************************
noautoinstall = ""
if(navigator.appName == "Microsoft Internet Explorer" &&
(navigator.appVersion.indexOf("Mac") != -1 ||
navigator.appVersion.indexOf("3.1") != -1)){
noautoinstall = "true";
}
if (navigator.appName == "Microsoft Internet Explorer" &&
noautoinstall != "true"){
window.location=flashpage;
}
else if(navigator.plugins){
if(navigator.plugins["Shockwave Flash"]){
window.location=flashpage;
}
else if(navigator.plugins["Shockwave Flash 2.0"]){
window.location=upgradepage;
}
else{
window.location=nonflashpage;
}
}
else {
window.location=cantdetectpage;
}
}
// -->
</SCRIPT>
At 11:49 AM 3/1/01 -0500, you wrote:
>hiya a!
>
> >does anyone have a good, solid flash detection script?
>
>yeah, rush over to the macromedia exchange, where they have a set of nice
>flash detection scripts as extensions for DW/UD.
>
>or go to moock.org and use his.
>
>hth,
>
>fortune
>
>---------------------------------------------------------------------------
-
>--------------------
>The views and opinions expressed in this email message are the sender's
>own, and do not necessarily represent the views and opinions of Summit
>Systems Inc.
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
--__--__--
Message: 15
From: "Luther, Ron" <Ron.Luther at COMPAQ.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: Fixed parts on a page (previously Re: [thelist] menus without
frames)
Date: Thu, 1 Mar 2001 12:37:53 -0600
charset="windows-1252"
Reply-To: thelist at lists.evolt.org
Hi Fortune,
I think it doesn't work. .... at least not for me.
I tried it in win2k ... IE5.0(sorta) ... Hmmmm ... could be this funky
version of IE ... <shrug>.
Ron L.
-----Original Message-----
From: Fortune Elkins
check out http://www.derailer.org/temp/stayput.html
view the source, try it out in Netscape & IE, see what you think. i didn't
write it...weavah did. <g>
--__--__--
Message: 16
Date: Thu, 01 Mar 2001 11:12:13 -0800
To: thelist at lists.evolt.org
From: Erika Meyer <meyer at up.edu>
Subject: Re: <strong> and <em> (was: Re: [thelist] customizing homesite)
Reply-To: thelist at lists.evolt.org
At 10:38 AM 3/1/01 -0700, you wrote:
>Do they do it for <.b> and <.i> tags also? Why did they turn things over
>to <.strong> and <.em>? Anyone know?
<b> and <i> describe the way text looks... visual presentation... while
visual presentation can convey meaning, the idea is that meaning is
separated from visual presentation.
So instead of speaking "with italics" one speaks "with emphasis."
Erika
--__--__--
Message: 17
Date: Thu, 01 Mar 2001 13:32:26 -0600
To: thelist at lists.evolt.org
From: Ben Dyer <ben_dyer at imaginuity.com>
Subject: RE: [thelist] Accessibility and Validation at War
om>
Reply-To: thelist at lists.evolt.org
Because then, the code is like this:
<tr><td> <fieldset> <legend>Whatever</legend> </td><td> Radio 1<br />Radio
2 </fieldset> </td></tr>
The fieldset and td don't nest properly: poorly-formed.
At 05:41 PM 2/28/01, you wrote:
>Ben,
>
> > I'm not sure what to do, moving the fieldset anywhere else (like within
>the
> > <td>) would make the file not well-formed. I really don't want to remove
> > the table if I can help it, but I'm hoping there might be an easier
> > solution (short of abandoning accessibility or validation).
>
> Why would placing the fieldset within the td make the file "not
>well-formed"? This shouldn't be a problem.
>
>James Aylard
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
--__--__--
Message: 18
From: Jake Stetser <jake.stetser at headhunter.net>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: [thelist] Accessibility and Validation at War
Date: Thu, 1 Mar 2001 15:20:41 -0500
Reply-To: thelist at lists.evolt.org
<tr><td>
<fieldset>
<table><tr><td>
<legend>Whatever</legend>
</td><td>Radio 1<br />Radio 2
</td></tr></table>
</fieldset>
</td></tr>?
-----Original Message-----
From: Ben Dyer [mailto:ben_dyer at imaginuity.com]
Sent: Thursday, March 01, 2001 2:32 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Accessibility and Validation at War
Because then, the code is like this:
<tr><td> <fieldset> <legend>Whatever</legend> </td><td> Radio 1<br />Radio
2 </fieldset> </td></tr>
The fieldset and td don't nest properly: poorly-formed.
At 05:41 PM 2/28/01, you wrote:
>Ben,
>
> > I'm not sure what to do, moving the fieldset anywhere else (like within
>the
> > <td>) would make the file not well-formed. I really don't want to remove
> > the table if I can help it, but I'm hoping there might be an easier
> > solution (short of abandoning accessibility or validation).
>
> Why would placing the fieldset within the td make the file "not
>well-formed"? This shouldn't be a problem.
>
>James Aylard
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
--__--__--
Message: 19
From: "Michele Foster" <michele at wordpro.on.ca>
To: <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 15:25:05 -0500
Organization: WordPro Services
charset="iso-8859-1"
Subject: [thelist] ASP, SQL, Recordsets, Best Practices
Reply-To: thelist at lists.evolt.org
Ok, how's that for a subject line .. <grin>
A couple questions I have come across while updating some code on an
existing site. Sure, it works as it exists now, but I'm trying to optimize
the code, and am wondering a few things in the process ...
(1)
When querying a unique field in a database, and the answer is either "yes a
record exists" or "no record exists", is it necessary to still loop through
the recordset? IOW, do I need to loop through the recordset with a "do
until rs.eof" blah, blah, "rs.movenext, loop" .. when there can only be one
unique record (field doesn't allow duplicates) or no record at all.
(2)
"Should" all the fields that you need to display on the page be declared
prior to using them?
i.e. Dim size
size=rs("sizefromdb")
response.write " & size & "
Or, is declaring the fields an unnecessary step, IF the field is only being
written/used once?
i.e. response.write rs("sizefromdb")
TIA,
Michele
--__--__--
Message: 20
Date: Thu, 01 Mar 2001 14:26:05 -0600
To: thelist at lists.evolt.org
From: Ben Dyer <ben_dyer at imaginuity.com>
Subject: RE: [thelist] Accessibility and Validation at War
Reply-To: thelist at lists.evolt.org
Dang. If it was a snake, it woulda bit me.
Thanks!
<tip type="editors" author="Ben Dyer">
If you are a Mac user and like BBEdit Lite, but are stuck on a PC, check
out Programmer's File Editor (PFE) at download.com, a little-known text
editor for the PC:
(Mind the wrap)
http://download.cnet.com/downloads/0-4003619-100-904159.html?tag=st.dl.10001
-103-1.lst-7-1.904159
It's about as close to BBEdit as I've found in terms of simplicity.
</tip>
At 02:20 PM 3/1/01, you wrote:
><tr><td>
><fieldset>
><table><tr><td>
> <legend>Whatever</legend>
></td><td>Radio 1<br />Radio 2
></td></tr></table>
></fieldset>
></td></tr>?
-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
--__--__--
Message: 21
From: Scott Dexter <sgd at ti3.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 14:36:39 -0600
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
> When querying a unique field in a database, and the answer is
> either "yes a
> record exists" or "no record exists", is it necessary to
> still loop through
Rudy, you take this one =)
>
> Or, is declaring the fields an unnecessary step, IF the field
> is only being
> written/used once?
>
> i.e. response.write rs("sizefromdb")
*ONLY* once?
yeah, that would be better, but you're holding the recordset open too long.
Inside your loop (I presume the loop in (1) above) when you get the value,
assign it to a variable, then close the recordset. Basically, you want to
get the value and get out of the db as fast as you can, so:
<%
Set oRS=oDBCON.Execute ("Select blah blah rudy is tha man")
if oRS.BOF and oRS.EOF then
sizefromdb=Empty
else
sizefromtb=oRS(0) ' the first column, this is faster than by name
oRS.Close
end if
Set oRS = Nothing
Set oDBCON = Nothing
...
%>
make sense?
sgd
--__--__--
Message: 22
Date: Thu, 01 Mar 2001 15:41:26 -0500
Subject: Re: [thelist] cheap webhosting / domain name
From: "arch" <mayday1999 at zdnetonebox.com>
To: thelist at lists.evolt.org
Reply-To: thelist at lists.evolt.org
Yes... http://www.your-site.com/... Great people, $60/year, 50 MB, more.
Arthur
___________________________________________________________________
To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax,
all in one place - sign up today at http://www.zdnetonebox.com
--__--__--
Message: 23
From: <martin.p.burns at uk.pwcglobal.com>
Date: Thu, 01 Mar 2001 19:05:58 +0000
Subject: Re: [thelist] Non-Deprecated HTML Presentational Elements (was,
C SS Font Sizes)
To: thelist at lists.evolt.org
Reply-To: thelist at lists.evolt.org
Memo from Martin P Burns of PricewaterhouseCoopers
-------------------- Start of message text --------------------
Still don't see what's wrong with <em>, as the intent of italicising it in
this context is to show emphasis. And <em> renders as italic by default
in most UAs anyway.
It shows a lot more structure than <i>.
Cheers
Martin
Please respond to thelist at lists.evolt.org
To: thelist at lists.evolt.org
cc:
Subject: Re: [thelist] Non-Deprecated HTML Presentational Elements (was, C
SS
Font Sizes)
martin:
> "the plural of <em>ox</em> is <em>oxen</em>"
>
> Shurely.
I'm a little unsure about that.
Yes, <em> should probably make sense to a reader, and it may be the most
pragmatic solution today; but I don't think that it gets the _intent_ across
as we'd like.
We could argue a need for <TELEPHONE>, <SURNAME>, <BRAND> and <PRICE
currency=GBP>. No-one here seems to be arguing for such a pointy-bracket
heaven (at least not in the last couple of weeks), so HTML remains a method
for conveying only simple structure and klunky metadata. Still, for that
purpose it's quite adequate.
I don't see any great problem with "the plural of ox is oxen", so the
fallback path from "the plural of <SPAN class=singular>ox</SPAN> is <SPAN
class=plural>oxen</SPAN>" is quite clean. If we define ".singular,.plural:
{ font-style: italic; }" then everyone might be happy? (As if...)
--------------------- End of message text --------------------
The principal place of business of PricewaterhouseCoopers and its associate
partnerships is 1 Embankment Place, London WC2N 6NN where lists of the
partners' names are available for inspection. All partners in the associate
partnerships are authorised to conduct business as agents of, and all
contracts for services to clients are with, PricewaterhouseCoopers. The UK
firm of PricewaterhouseCoopers is authorised by the Institute of Chartered
Accountants in England and Wales to carry on investment business.
PricewaterhouseCoopers is a member of the world-wide
PricewaterhouseCoopers organisation.
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which
it is addressed and may contain confidential and/or privileged material.
Any
review, retransmission, dissemination or other use of, or taking of any
action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
--__--__--
Message: 24
From: "rudy" <r937 at interlog.com>
To: "evolt thelist" <thelist at lists.evolt.org>
Subject: Re: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 15:48:21 -0500
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
> When querying a unique field in a database, and the answer is
> either "yes a record exists" or "no record exists", is it necessary
> to still loop through the recordset?
hi michele
well, DUH (no offence to you personally)
the idea that you might need to "loop" indicates a programming (action
oriented) approach to the problem
which is good, as you're dealing with ASP <dons flame-retardant suit />
how about this --
IF "yes a record exists"
[ do something ]
ELSE
[ do something else, perhaps nothing ]
>... when there can only be one
> unique record (field doesn't allow duplicates) or no record at all.
presumably you want to do something with the fields for this particular
row? if you don't need to use any of the fields, i.e. if you only need to
know *whether* a row exists, then you should be using
select count(*) from [table] where [uniqueness]
you'll get back a 0 or some positive number, and you can build the IF
ELSE condition just by testing on zero
count(*) is a lot quicker for the database, too -- no rows to access
rudy.ca
--__--__--
Message: 25
From: "Michele Foster" <michele at wordpro.on.ca>
To: <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 15:51:29 -0500
Organization: WordPro Services
charset="iso-8859-1"
Subject: [thelist] [offlist] Re: [***list] ASP, SQL, Recordsets, Best
Practices
Reply-To: thelist at lists.evolt.org
LMAO
Ok.. I have to reply to ya off list ....
First I wrote the email to you directly, then thought, naw I should ask the
group instead of bugging you... hehehehe
Anyway, you answered my second question exactly.. thanks. Now I remember
WHY I declared all the damn variables first .. but of course it would have
been smart to close the damn recordset instead of waiting to the end of the
page. Bad habit .. trying to break it.
This is *another* page that was hacked out a year ago between me and the ex,
so, now that I know a lot more than I did then, I'm going back and fixing
stuff up, optimizing the code, and re-learning everything.
Learning, learning. :)
Michele
P.S. Related onlist stuff replied onlist. :)
----- Original Message -----
From: "Scott Dexter" <sgd at ti3.com>
To: <thelist at lists.evolt.org>
Sent: Thursday, March 01, 2001 3:36 PM
Subject: RE: [thelist] ASP, SQL, Recordsets, Best Practices
> > When querying a unique field in a database, and the answer is
> > either "yes a
> > record exists" or "no record exists", is it necessary to
> > still loop through
>
> Rudy, you take this one =)
>
> >
> > Or, is declaring the fields an unnecessary step, IF the field
> > is only being
> > written/used once?
> >
> > i.e. response.write rs("sizefromdb")
>
> *ONLY* once?
>
> yeah, that would be better, but you're holding the recordset open too
long.
> Inside your loop (I presume the loop in (1) above) when you get the value,
> assign it to a variable, then close the recordset. Basically, you want to
> get the value and get out of the db as fast as you can, so:
>
> <%
>
> Set oRS=oDBCON.Execute ("Select blah blah rudy is tha man")
> if oRS.BOF and oRS.EOF then
> sizefromdb=Empty
> else
> sizefromtb=oRS(0) ' the first column, this is faster than by name
> oRS.Close
> end if
> Set oRS = Nothing
> Set oDBCON = Nothing
>
> ...
>
> %>
>
> make sense?
>
> sgd
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
--__--__--
Message: 26
From: "Michele Foster" <michele at wordpro.on.ca>
To: <thelist at lists.evolt.org>
Subject: Apologies .. was .. Re: [thelist] [offlist] Re: [***list] ASP, SQL,
Recordsets, Best Practices
Date: Thu, 1 Mar 2001 16:02:21 -0500
Organization: WordPro Services
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
Ooops..
Sorry, obviously [offlist] should go offlist .. damn, I need a break.
and I owe a tip ...
<tip>
Having computer-related problems, operating systems, servers, hardware ..
check out this site .. http://computing.net/forums/
</tip>
--__--__--
Message: 27
From: "Michele Foster" <michele at wordpro.on.ca>
To: <thelist at lists.evolt.org>
Subject: Re: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 16:14:01 -0500
Organization: WordPro Services
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
Thanks Rudy ...
Just wanted to confirm .. old code .. hacked out from the "first days of
learning ASP/database connections, etc.". It worked .. but wasn't
necessary, as I thought. I'll proudly wear the *dunce* cap tho. :)
From: "rudy" <r937 at interlog.com>
> IF "yes a record exists"
> [ do something ]
> ELSE
> [ do something else, perhaps nothing ]
Yes, that's what I want.
> >... when there can only be one
> > unique record (field doesn't allow duplicates) or no record at all.
>
> presumably you want to do something with the fields for this particular
> row? if you don't need to use any of the fields, i.e. if you only need to
> know *whether* a row exists, then you should be using
Yes, I need the one record to be displayed, but thanks for the tip below,
that'll come in handy for something else no doubt. :) [Actually, I already
have a use for it .. thanks.]
> select count(*) from [table] where [uniqueness]
>
> you'll get back a 0 or some positive number, and you can build the IF
> ELSE condition just by testing on zero
>
> count(*) is a lot quicker for the database, too -- no rows to access
--__--__--
Message: 28
From: "Michele Foster" <michele at wordpro.on.ca>
To: <thelist at lists.evolt.org>
Subject: Re: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 16:18:26 -0500
Organization: WordPro Services
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
Scott,
From: "Scott Dexter" <sgd at ti3.com>
> <%
>
> Set oRS=oDBCON.Execute ("Select blah blah rudy is tha man")
> if oRS.BOF and oRS.EOF then
> sizefromdb=Empty
What does BOF mean? and/or how does it differ from EOF? Should they both
be used *always* together?
> else
> sizefromtb=oRS(0) ' the first column, this is faster than by name
Thanks for the tip, I presume that field names start at (0), instead of 1.
Anything special depending on whether the field is an auto-incremented
field?
Thanks for all your help. :)
Michele
--__--__--
Message: 29
From: "Pearson, John" <JOHN.PEARSON at eia.doe.gov>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 16:22:06 -0500
Subject: [thelist] Need a free newsgroup package for a non-profit
Reply-To: thelist at lists.evolt.org
Im looking for a cheap or free newsgroup package that will let me run a
series of
newsgroups on a non-profit site. It has to run on an NT box so asp would be
preferred. Any suggestions or leads? I know about ZpayBBS, and FP2000!
--__--__--
Message: 30
From: Scott Dexter <sgd at ti3.com>
To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
Subject: RE: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 15:27:43 -0600
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
> > if oRS.BOF and oRS.EOF then
> > sizefromdb=Empty
>
> What does BOF mean? and/or how does it differ from EOF?
> Should they both
> be used *always* together?
BOF = Beginning Of File (EOF = End Of File)
ADO Recordsets will set both to true if the recordset is empty. Yes, should
be used together to test for an empty Recordset. (There are situations
depending on the locktype and cursor used that will set BOF or EOF when
there is actual data; testing both like this is the only guaranteed way
regardless of the type of recordset you've opened)
> > sizefromtb=oRS(0) ' the first column, this is faster than by name
>
> Thanks for the tip, I presume that field names start at (0),
> instead of 1.
> Anything special depending on whether the field is an auto-incremented
> field?
Yes, all arrays, collections, etc in VB(Script) are zero-indexed. No, it has
nothing to do with the actual value in the column....
sgd
--__--__--
Message: 31
From: "Warden, Matt" <mwarden at odyssey-design.com>
To: <thelist at lists.evolt.org>
Subject: Re: [thelist] ASP, SQL, Recordsets, Best Practices
Date: Thu, 1 Mar 2001 16:48:31 -0500
charset="iso-8859-1"
Reply-To: thelist at lists.evolt.org
> >... when there can only be one
> > unique record (field doesn't allow duplicates) or no record at all.
>
> presumably you want to do something with the fields for this particular
> row? if you don't need to use any of the fields, i.e. if you only need to
> know *whether* a row exists, then you should be using
>
> select count(*) from [table] where [uniqueness]
>
> you'll get back a 0 or some positive number, and you can build the IF
> ELSE condition just by testing on zero
>
> count(*) is a lot quicker for the database, too -- no rows to access
Wouldn't this be quicker:
select 1 from [table] where [uniqueness]
No functions... just a literal.
If I recall, I learned this from you...
And she doesn't have to test for a value at all, just test if there are
records in the recordset:
if objRS.eof and objRS.bof then
bSuccess = Dexter.stopUsingFrontPage()
else
bSuccess = Rudeman.learnRealSQL()
end if
And, of course, bSuccess will always be false in both cases...
Michele, sgd is being slow, so I'll let you know what .bof means: Beginning
of File. BOF is the "space" before the first record and EOF is the "space"
after the last record. So, if both are true, then there are no records. Most
people use EOF only because ADO defaults to setting the... umm... pointer
before the first record in the recordset (so, BOF *should* always be true
for an untouched recordset).
Yes, the fields collection starts at zero and oRS(0) is the same as
oRS.fields(0). And, since all it does is access a value, then it doesn't
matter what the fieldtype is (number, text, autonumber, date, etc.) at this
point, anyway.
--
mattwarden
mattwarden.com
--__--__--
Message: 32
From: "Filip Salomonsson" <filip at netdesign.se>
To: <thelist at lists.evolt.org>
Date: Thu, 1 Mar 2001 23:04:11 +0100
charset="iso-8859-1"
Subject: [thelist] IE6 "compatible mode" / PNG support
Reply-To: thelist at lists.evolt.org
In spirit of the recent thread on running multiple browser versions.. Does
the IE6 installer offer any backwards compatibility? Can I keep my IE5 _and_
the "compatible mode" IE4?
Also, could someone running IE6 help me verify its native PNG support by
sending me screenshots of these two resources offlist? That would be great.
<http://www.w3.org/Graphics/PNG/inline-alpha>
<http://www.w3.org/Graphics/PNG/inline-alpha-table>
Thanks
--
filip(salomonsson)@netdesign.se
--__--__--
Message: 33
Date: Thu, 01 Mar 2001 17:04:35 -0500
From: Michael Barrett <mbarrett at triad.rr.com>
To: <thelist at lists.evolt.org>
Subject: [thelist] DB question
Reply-To: thelist at lists.evolt.org
I'm doing some pre-planning for project, and I'm thinking about the
database that will be needed. Being a data-newbie I got to wondering...
Is it generally more efficient to have fewer tables in a database?
I'm thinking of a db that relates images to data.
The images need certain information, size, description, blah blah.
The images are also pictures of product. I will need a product table of
course, with the classic sku#, description, blah blah.
Each image depicts one *or* more individual items, i.e. 1 vase vs a set of 6
plates.
Is it advisable to have one big fat image table that holds all the image
data, plus many columns for sku#s with one product table?
Or
A reasonably trim image table with just image data, a separate image/sku
table, which relates image#s to sku#s, and a third product data table?
My gut reaction is that dividing the data up into logical groups, and
separating into tables might be less efficient, but will be easier to code
for, and maintenance later.
<tip type="MYSQL data entry">
Trying to enter data into a MYSQL db, but don't have a handy GUI app, or
can't stand all that typing.?
Build your tables in Excel, or your favorite spreadsheet app. In a duplicate
file (backups save lives), insert columns to hold SQL statements (insert
into table blah blah), any separators or syntax you may need (commas, single
quotes, parentheses, yadda, etc.)
Export the whole mess as a csv file (comma delimited) or a space delimited
text file. Find/Replace any junk in your favorite text editor (ahem BB
edit), save the file as something like "table_dump.txt". Upload the file to
your server. Telnet to your host, from the command line type "mysqldump
databasename < table_dump.txt" and all the data will be dropped into your
db. If there's a goober in your SQL, the command line will give you a
friendly error message, and a line number to point out the problem.
</tip>
-- Michael
-O^O-
-
--__--__--
_______________________________________________
Help: http://lists.evolt.org/mailman/listinfo/thelist
Archives: http://lists.evolt.org
End of thelist Digest
More information about the thelist
mailing list