| ★ wanayoo — archive 1999 http://msdn.microsoft.com/voices/webmen.asp | Nouvelle recherche | Portail wanayoo |
|
|
All Products | Support | Search | microsoft.com Home |
|
| ||
| HOME | VOICES | LIBRARIES | COMMUNITY | DOWNLOADS | SITE GUIDE | SEARCH MSDN | ||
 Voices Archive |
|||
|
by Tom Moran and Rafael M. Muñoz
Posted November 1, 1999 To be archived December 6, 1999
Contents
Tabs from the past --
DHTML and behaviors replace the HTML Layout Control
Skip, skip, skip to my Lou -- How to simulate a SKIP command in
SQL Server 7.0
The Web Men and MSDN Online are always trying to improve. So,
with the intent of making our column even better, we've come up with a short
survey. Tell us what you think, and what you would prefer to see (or not see)
in the future. It should take you just a few minutes. Simply take our survey 
,
and, when you are done, you'll be returned to Web Men Talking to catch up on
this month’s issues. Next month, we'll share the results, as well as any plans
for the new year.
Thanks for your time,
-- Rafael and Tom
Dear Web Men:
What's the latest on the tabs control in Visual InterDev® 6? I saw your example from an April 1997 column, but couldn't even view it unless my browser's Internet security settings were as low as they could go.
I haven't found much good material on this control anywhere on the Web. What gives?
Annette Receveur
The Web Men reply:
Wow, a blast from our past. In April 1997, we were just young boys venturing out on our own, creating a new Q & A column. Then, the HTML Layout Control was the in thing -- providing two-dimensional layout of content. But, alas, when you reference the article The HTML Layout Control and Internet Explorer 4.0 you will see this control has since faded out.
Browsers became more advanced, and what was once displayed with
the HTML Layout Control can now be done slicker with DHTML. Take, for instance, the Microsoft.com Search page 
.
It is created by using a couple of background GIFs for the tabs and placing
them just above a colored <DIV>
element. By adding a few controls in the <DIV>
area, playing with the display
attribute,
and using events such as the onclick
event,
you can hide and display the different <DIV> areas by selecting their
associated tabs. You now have the same type of control the HTML Layout Control
provided.
Want to be even slicker? With the emergence of Internet Explorer 5
came DHTML behaviors
-- lightweight, reusable components that you create with something as simple as
a scripting language. Now, these components are compatible only with Internet
Explorer 5 -- but once you play with them, you'll be hooked. Read Using DHTML Behaviors
for more information.
There is even a behavior called mpc Behavior, a multi-page control that uses tabs and looks identical to our sample of yesteryear. For a great sample to download and play with, check out the Mpc Behavior sample found in the Samples area.
Dear Web Men:
Is there a way in SQL Server 7.0 to specify the number of records to SKIP, for example SELECT TOP 50 * FROM pubs ORDER BY 1 SKIP 100?
Rahul Mathur
The Web Men reply:
There is no SKIP command
in SQL Server 7.0 . However, you can do this with a very short
and simple series of commands, which we'll show below. The assumption is that
you want the 101st through 150th record. To achieve those results, do the
following:
Move your 150 records into a temporary table.
Delete the top 100 records.
What are you left with? The 101st through 150th record.
Here are the SQL statements to do this. You can use Query Analyzer to test this:
SELECT TOP 150 into #temptable from <your table name>
SET ROWCOUNT 100
DELETE #temptable
SET ROWCOUNT 0
SELECT * from #temptable
Simple enough? You can use this technique to do a variety of related tasks.
Q: Henry Su wants to target two frames at once, after he clicks on an item.
A: See Frame frenzy gone mad.
Q: Tanya Postnaya is having problems adding a new option to a select box within a frame using Internet Explorer 5.
A: See KB article Q237831, PRB: Problem Adding New
Option to Select Box in Another Frame in Internet Explorer 5 .
Q: A reader is having problems using the z-index in DHTML on a page containing a list box.
A: See Where there’s a will, there’s a display.
Q: Ruben Vazquez wants to know whether the Microsoft Agent has a speech engine available for Spanish.
A: See Other Speech Engine Support.
Q: Chamikara Gunaratna wants to prevent his applet from throwing the com.ms.security.SecurityExcecptionEx[Host] exception.
A: See KB article Q175622, PRB: SecurityExceptionEx
Exception Running a Java Applet .
Q: Tony Edwards asks what is causing the "Unspecified Error 80004005" message occurring intermittently in his ASP code.
A: See A First Aid kit to Cure the ‘80004005’ Database-Related
Errors
and Q183060, INFO:
Troubleshooting Guide for 80004005 & Other Error Messages .
Q: Dan Hidlebaugh is having problems viewing the hover button in the preview page.
A: See KB article Q229597, FP2000: On Hover Image with Button Does Not Work in
Preview .
Q: Ronald Boykin receives the error message "The query cannot be executed because some files are missing or not registered," when using the database tools in Visual InterDev 1.0.
A: See KB article Q175802, PRB: Query Error: Class Not
Registered .
Did you find this article useful? Gripes? Compliments? Suggestions for other articles? Write us!
© 1999 Microsoft Corporation. All rights reserved. Terms of use.
Back to top