PC Review


Reply
Thread Tools Rate Thread

displaying the results from a query

 
 
=?Utf-8?B?Smlt?=
Guest
Posts: n/a
 
      5th Jun 2004
Hello, I am trying to display the results from my database query. I have 5 columns in my query and I want to be able to display the results from each one seperately on the page. I am not sure how to connent to a query as I have never done it I am assuming it uses something like "Select * FROM pollresults" but I do not know how to go beyond selecting the table because I really have very little knowledge of asp, only what I have learned by manipulating others codes. each column would have a name like sumofStaci, sumofMelissa. Since these results are from one of my polls. Thanks for any help, Jim
 
Reply With Quote
 
 
 
 
Jim Buyens
Guest
Posts: n/a
 
      5th Jun 2004
Get the query working in Access, then save it using some
name in Access.

Then, add the .mdb file to a fpdb folder in your
FrontPage Web site, open a new page, and choose Insert,
Database, Results.

In the first page of the wizard, specify your .mdb file.

In the second page, specify your saved query name.

From there, set any options you want.

Be sure to save the page with an .asp filename extension
and to test it by browsing with an http:// URL.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


>-----Original Message-----
>Hello, I am trying to display the results from my

database query. I have 5 columns in my query and I want
to be able to display the results from each one
seperately on the page. I am not sure how to connent to a
query as I have never done it I am assuming it uses
something like "Select * FROM pollresults" but I do not
know how to go beyond selecting the table because I
really have very little knowledge of asp, only what I
have learned by manipulating others codes. each column
would have a name like sumofStaci, sumofMelissa. Since
these results are from one of my polls. Thanks for any
help, Jim
>.
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying two query results together =?Utf-8?B?SGFycnk=?= Microsoft Access Queries 10 15th Sep 2006 09:38 PM
Displaying SQL Query Results Brad Baker Microsoft ASP .NET 5 12th Apr 2006 11:57 AM
displaying query results Nick Microsoft Access VBA Modules 0 29th Jul 2004 09:11 AM
displaying query results =?Utf-8?B?TWF0dGhldw==?= Microsoft Access 0 5th Jun 2004 02:36 AM
Displaying query results Craig Microsoft Access Queries 1 6th Aug 2003 04:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:51 PM.