Any good resources for learning how to work with data?

C

CJ

I'm planning to incorporate some database results pages into a website, and
have read through the online help and done some testing. However I find that
it only goes so far - I have some unanswered questions, like how it works
with images, how to format the output (for example auto-thumbnailing images
dragged from the database) etc

Can anyone recommend any online or published work that will provide some
further help?

Many thanks.

CJ
 
T

Thomas A. Rowe

You really don't want to store actual images or other objects in the
database, just create a text field and insert the name or the full path and
name to the images or objects location within your web site.

Then in your display/output page call the path or filename from the
database.

Example:

Name only
<img src="../images/<%=recordsetname("IMAGE")%>" border="0" width="150">

Full Path:
<img src="<%=recordsetname("IMAGE_PATH")%>" border="0" width="150">

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
K

Kevin Spencer

The FrontPage Database tools can do the most common database operations, and
can be tweaked to a fair extent. However, as you've discovered, there are
many things you can't do with these tools. When you reach the limits of the
tools, you have to write your own server-side application, or modify one
created by FrontPage. FrontPage 2003 can use 3 Microsoft technologies for
connecting with data sources: ASP, ASP.Net, and SharePoint. Prior versions
of FrontPage use ASP only (actually, the first Microsoft version of
FrontPage used IDC, which was a precursor for ASP).

Of the technologies that FrontPage can work with, if you are not an
experienced developer, you will probably find ASP the easiest to learn and
get started with. There are many books published on the topic. The Microsoft
web site has quite a few materials to help you learn ASP, if that is your
desire. In addition, there are quite a few web sites that offer articles,
tutorials, etc. Mine is one of them: http://www.takempis.com.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
C

CJ

Of the technologies that FrontPage can work with, if you are not an
experienced developer, you will probably find ASP the easiest to learn and
get started with. There are many books published on the topic. The Microsoft
web site has quite a few materials to help you learn ASP, if that is your
desire. In addition, there are quite a few web sites that offer articles,
tutorials, etc. Mine is one of them: http://www.takempis.com.

--

Thanks both.

CJ
 
J

Jimmy

Thanks both.

CJ

A word of warning. There are about a dozen different ways to access
data via the ASP mechanism and related objects. Don't be surprised
if you find that one book uses one method and another uses code that
looks quite a bit different.

Start with something like "Teach Yourself ASP in 24 hours" by Sams.
That will guide you through the whole HTML/HTTP/Forms/ASP jungle
and you can work from there. I forget if Peachpitt has a "Visual
Quickstart" for ASP but that might be a good start up kit too.
After that you can get another 3" thick book with some depth. I would
avoid the 3" thick books until you are very comfortable with the
technology and want a reference book.

In addition to the takempis.com site, 4guysfromrolla.com is a good
site too. Start with the books, use the sites when you can't figure
the specifics.
 
Top