🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #17178

Re: database help

#17178
From: Waldo Smets
Date: Fri, 04 Feb 2000 00:00
94 lines
4668 bytes
--------------406D51E1101B02D6CBB2897C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Take MS Access
Make a new table "Properties". Put desired fields in column one and pick
type of field in column two.
E.g.
Property ID: Autonumber
Address: Text
Zip: Text
etc.

Take OLE field type for the pictures column....
Make sure you look at the properties of each field at the bottom of the
table design .... You take a field size of 50 for example for the
address field (meaning max. 50 chars -> also determines the HD space the
database will absorb).
You need a lookup table for city / state (there are databases out there
with all zip codes that you can include in your db).

Also have a property_type lookup table, probable a suburb_type one and
price_ranges.....

Set the index property of all fields you want to sort on to Yes.

If you're in a hurry and can't handle it yourself.... we are mainly
developping Access / VB and can handle such a simple thing in a single
day.... If interested mail me - otherwise good luck !!

Waldo Smets
Software Solutions

Dorothy wrote:

> Hi there I am a web designer using Dreamweaver. I'm about to start
> work on a new project which will need some sort of database set-up.
> The job is for a Real Estate Agent who will be offering rental
> properties on-line. The database will need to hold about 1000 photos
> of properties and their respective info. The database will need to be
> searchable by state, suburb, type of property, and price range. I do
> not have any experience with databases or programming, and I don't
> have the time to learn if it's time consuming - anyone know where I
> should start?   All advice
> appreciated. ThanksDorothywww.webandprint.com

--------------406D51E1101B02D6CBB2897C
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
Take MS Access
<br>Make a new table "Properties". Put desired fields in column one and
pick type of field in column two.
<br>E.g.
<br>Property ID: Autonumber
<br>Address: Text
<br>Zip: Text
<br>etc.
<p>Take OLE field type for the pictures column....
<br>Make sure you look at the properties of each field at the bottom of
the table design .... You take a field size of 50 for example for the address
field (meaning max. 50 chars -> also determines the HD space the database
will absorb).
<br>You need a lookup table for city / state (there are databases out there
with all zip codes that you can include in your db).
<p>Also have a property_type lookup table, probable a suburb_type one and
price_ranges.....
<p>Set the index property of all fields you want to sort on to Yes.
<p>If you're in a hurry and can't handle it yourself.... we are mainly
developping Access / VB and can handle such a simple thing in a single
day.... If interested mail me - otherwise good luck !!
<p>Waldo Smets
<br>Software Solutions
<p>Dorothy wrote:
<blockquote TYPE=CITE><style></style>
<font size=-1>Hi there</font>&nbsp;<font size=-1>I
am a web designer using Dreamweaver. I'm about to start work on a new project
which will need some sort of database set-up.&nbsp; The job is for a Real
Estate Agent who will be offering rental properties on-line. The database
will need to hold about 1000 photos of properties and their respective
info. The database will need to be searchable by state, suburb, type of
property, and price range.</font>&nbsp;<font size=-1>I do not have any
experience with databases or programming, and I don't have the time to
learn if it's time consuming - anyone know where I should start?&nbsp;&nbsp;
All advice appreciated.</font>&nbsp;<font size=-1>Thanks</font><font size=-1>Dorothy</font><font size=-1><a href="http://www.webandprint.com">www.webandprint.com</a></font></blockquote>

</body>
</html>

--------------406D51E1101B02D6CBB2897C--
Technical Details
Message-ID: <389A9796.5A4BB13B@tvd.be>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <87dsab$l51$1@news1.mpx.com.au>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcea4,c407e6c586e24581
X-Google-Attributes: gidfcea4,public
From: Waldo Smets <waldo.smets@tvd.be>
Subject: Re: database help
Date: 2000/02/04
Message-ID: <389A9796.5A4BB13B@tvd.be>
X-Deja-AN: 581449582
References: <87dsab$l51$1@news1.mpx.com.au>
X-Accept-Language: en
Content-Type: multipart/alternative; boundary="------------406D51E1101B02D6CBB2897C"
X-Complaints-To: abuse@chello.be
X-Trace: news.chello.be 949655371 195.162.216.140 (Fri, 04 Feb 2000 10:09:31 MET)
Organization: Chello Usenet Service
MIME-Version: 1.0
NNTP-Posting-Date: Fri, 04 Feb 2000 10:09:31 MET
Newsgroups: be.comp.programming