Page 1 of 1

database fields....can this be done?

PostPosted: Fri Jul 26, 2002 3:49 pm
by Andrew Greaves
I inherited a site using v4.1. Does anyone know the field names SS uses in
products.db and pages.db so that i might access them through an ADO or ODBC
connection string and construct my own product pages? Does anyone know if
this is access, MySQL, SQL 2000? or what?

Thanks all

Andrew

Re: database fields....can this be done?

PostPosted: Fri Jul 26, 2002 4:17 pm
by loren_d_c
It is none of those, it is a proprietary database file format and can only be
accessed via the ShopSite cgi's.

-Loren


Andrew Greaves wrote:

I inherited a site using v4.1. Does anyone know the field names SS uses in
products.db and pages.db so that i might access them through an ADO or ODBC
connection string and construct my own product pages? Does anyone know if
this is access, MySQL, SQL 2000? or what?

Thanks all

Andrew

Re: database fields....can this be done?

PostPosted: Fri Jul 26, 2002 4:23 pm
by Andrew Greaves
(#$*@&%(&^#$@%(&^#$%(*&#$%(*!!!!!!!


thanks.


"Loren" <loren_d_c@yahoo.com> wrote in message
news:3D41D876.C83533A1@yahoo.com...
It is none of those, it is a proprietary database file format and can only
be
accessed via the ShopSite cgi's.

-Loren


Andrew Greaves wrote:

I inherited a site using v4.1. Does anyone know the field names SS uses
in
products.db and pages.db so that i might access them through an ADO or
ODBC
connection string and construct my own product pages? Does anyone know
if
this is access, MySQL, SQL 2000? or what?

Thanks all

Andrew

Re: database fields....can this be done?

PostPosted: Sun Jul 28, 2002 4:59 am
by Barney Stone
Andrew -

You might want to check out the Stone Edge ECom Assembler at
http://www.stoneedge.com/ecomassembler.htm

With the ECom Assembler, you have all of your ShopSite page and product
data, plus a variety of custom data, on your on PC or LAN, and you can use
the program's powerful template system to automatically construct pages to
your specifications.

Feel free to give us a call during the week if you have any questions.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com


"Andrew Greaves" <webmaster@electroline4u.com> wrote in message
news:ahsln9$dok$1@support.shopsite.com...
(#$*@&%(&^#$@%(&^#$%(*&#$%(*!!!!!!!


thanks.


"Loren" <loren_d_c@yahoo.com> wrote in message
news:3D41D876.C83533A1@yahoo.com...
It is none of those, it is a proprietary database file format and can
only
be
accessed via the ShopSite cgi's.

-Loren


Andrew Greaves wrote:

I inherited a site using v4.1. Does anyone know the field names SS
uses
in
products.db and pages.db so that i might access them through an ADO or
ODBC
connection string and construct my own product pages? Does anyone know
if
this is access, MySQL, SQL 2000? or what?

Thanks all

Andrew