Need a simple data retrieval "system" through FrontPage 2003

[Guest]

What I would like to do is create a simple, comma delimited "database" using
MS Excel (.csv) that will have one colum as a "product ID" and another column
containing a USD formatted number (ie: $1,999.99). Then, I want to insert a
code snippet or FrontPage "tag" (ie: <!-- webbot bot ---> or something like
it) that will use the "product ID" tag to call up the contents of the next
field that has the USD price (stated earlier). This way, I can make changes
in the original Excel file (such as price changes or added/removed products),
export it as a .csv file, then upload it to the server through FrontPage. I
want to be able to also enclose the tag in some kind of text formatting HTML
tags so that I can control how the text is displayed (such as style,
formatting, alignment, etc.)

Does FrontPage have a built-in function or wizard that will accomplish this
or at least the ability to create a "tag" to call the data upon demand? The
server I use has the FrontPage Server Extensions/IIS on it (I use FrontPage's
form wizard for form handling all the time), but I don't have "direct" access
to the server (I can't install apps, CGI/Perl scripts, make "special server
subdirectories", etc.)

The only tools I have to use are FrontPage 2003 and Microsoft Office XP/2002
- Small Business Edition (therefore, I don't have any programming languages,
MS Access or MySQL)

Is what I want to do possible? I want to mimic in a more simplified form
the way Yahoo! Shopping works - with you being able to upload a .csv file,
and add tags (<!--- tag name -->) to display the contents of the
corresponding cell/field within your HTML pages.

 

[Andrew Murray]

Yes, the Database Results Wizard & Interface Wizard - requires a Windows
Server.

 

[Stefan B Rusynko]

See http://support.microsoft.com/kb/268948/en-us

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| What I would like to do is create a simple, comma delimited "database" using
| MS Excel (.csv) that will have one colum as a "product ID" and another column
| containing a USD formatted number (ie: $1,999.99). Then, I want to insert a
| code snippet or FrontPage "tag" (ie: <!-- webbot bot ---> or something like
| it) that will use the "product ID" tag to call up the contents of the next
| field that has the USD price (stated earlier). This way, I can make changes
| in the original Excel file (such as price changes or added/removed products),
| export it as a .csv file, then upload it to the server through FrontPage. I
| want to be able to also enclose the tag in some kind of text formatting HTML
| tags so that I can control how the text is displayed (such as style,
| formatting, alignment, etc.)
|
| Does FrontPage have a built-in function or wizard that will accomplish this
| or at least the ability to create a "tag" to call the data upon demand? The
| server I use has the FrontPage Server Extensions/IIS on it (I use FrontPage's
| form wizard for form handling all the time), but I don't have "direct" access
| to the server (I can't install apps, CGI/Perl scripts, make "special server
| subdirectories", etc.)
|
| The only tools I have to use are FrontPage 2003 and Microsoft Office XP/2002
| - Small Business Edition (therefore, I don't have any programming languages,
| MS Access or MySQL)
|
| Is what I want to do possible? I want to mimic in a more simplified form
| the way Yahoo! Shopping works - with you being able to upload a .csv file,
| and add tags (<!--- tag name -->) to display the contents of the
| corresponding cell/field within your HTML pages.

 

[Guest]

Thank you, but the article only shows how to display the ENTIRE database, not
individual cell/record information. Here is an example of what I want to do:
--------------------------------------------------------------------------
Database:

product_id price
2844-00 $250.00
wb105nl $75.95
...........
-------------------------------------------------------------------------
HTML in FrontPage:

<table>
<tr>
<td>
<p>Oak Endtable</p></td>
<td>
<p><!--- [tag to point to "$250.00" of the product_id "2844-00"]
---></p>
</td>
</tr>
</table

 

[Thomas A. Rowe]

Have you considered look for a shopping cart application?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Thank you, but the article only shows how to display the ENTIRE database, not
individual cell/record information. Here is an example of what I want to do:
--------------------------------------------------------------------------
Database:

product_id price
2844-00 $250.00
wb105nl $75.95
..........
-------------------------------------------------------------------------
HTML in FrontPage:

<table>
<tr>
<td>
<p>Oak Endtable</p></td>
<td>
<p><!--- [tag to point to "$250.00" of the product_id "2844-00"]
---></p>
</td>
</tr>
</table>
---------------------------------------------------------------------------------------
Display in webpage when viewed in a browser:

Oak Endtable $250.00

--------------------------------------------------------------------------------------

That's what I was looking to do. Any suggestions?

See http://support.microsoft.com/kb/268948/en-us

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

 

[Stefan B Rusynko]

If I recall correctly the op doesn't have Access and wanted to do it w/ Excel (and not spend any money)
- so he very limited in what he can do

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Have you considered look for a shopping cart application?
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| ==============================================
| If you feel your current issue is a results of installing
| a Service Pack or security update, please contact
| Microsoft Product Support Services:
| http://support.microsoft.com
| If the problem can be shown to have been caused by a
| security update, then there is usually no charge for the call.
| ==============================================
|
| | > Thank you, but the article only shows how to display the ENTIRE database, not
| > individual cell/record information. Here is an example of what I want to do:
| > --------------------------------------------------------------------------
| > Database:
| >
| > product_id price
| > 2844-00 $250.00
| > wb105nl $75.95
| > ..........
| > -------------------------------------------------------------------------
| > HTML in FrontPage:
| >
| > <table>
| > <tr>
| > <td>
| > <p>Oak Endtable</p></td>
| > <td>
| > <p><!--- [tag to point to "$250.00" of the product_id "2844-00"]
| > ---></p>
| > </td>
| > </tr>
| > </table>
| > ---------------------------------------------------------------------------------------
| > Display in webpage when viewed in a browser:
| >
| > Oak Endtable $250.00
| >
| > --------------------------------------------------------------------------------------
| >
| > That's what I was looking to do. Any suggestions?
| >
| > "Stefan B Rusynko" wrote:
| >
| >> See http://support.microsoft.com/kb/268948/en-us
| >>
| >> --
| >>
| >> _____________________________________________
| >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> "Warning - Using the F1 Key will not break anything!" (-;
| >> To find the best Newsgroup for FrontPage support see:
| >> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| >> _____________________________________________
|
|

 

[Thomas A. Rowe]

But a Access based shopping cart would come with the Access database, and there are some free ones
available if the op chooses to look.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

If I recall correctly the op doesn't have Access and wanted to do it w/ Excel (and not spend any
money)
- so he very limited in what he can do

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Have you considered look for a shopping cart application?
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| ==============================================
| If you feel your current issue is a results of installing
| a Service Pack or security update, please contact
| Microsoft Product Support Services:
| http://support.microsoft.com
| If the problem can be shown to have been caused by a
| security update, then there is usually no charge for the call.
| ==============================================
|
| | > Thank you, but the article only shows how to display the ENTIRE database, not
| > individual cell/record information. Here is an example of what I want to do:
| > --------------------------------------------------------------------------
| > Database:
| >
| > product_id price
| > 2844-00 $250.00
| > wb105nl $75.95
| > ..........
| > -------------------------------------------------------------------------
| > HTML in FrontPage:
| >
| > <table>
| > <tr>
| > <td>
| > <p>Oak Endtable</p></td>
| > <td>
| > <p><!--- [tag to point to "$250.00" of the product_id "2844-00"]
| > ---></p>
| > </td>
| > </tr>
| > </table>
| > ---------------------------------------------------------------------------------------
| > Display in webpage when viewed in a browser:
| >
| > Oak Endtable $250.00
| >
| > --------------------------------------------------------------------------------------
| >
| > That's what I was looking to do. Any suggestions?
| >
| > "Stefan B Rusynko" wrote:
| >
| >> See http://support.microsoft.com/kb/268948/en-us
| >>
| >> --
| >>
| >> _____________________________________________
| >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> "Warning - Using the F1 Key will not break anything!" (-;
| >> To find the best Newsgroup for FrontPage support see:
| >> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| >> _____________________________________________
|
|