Article View: be.comp.programming
Article #17178Re: database help
From: Waldo Smets
Date: Fri, 04 Feb 2000 00:00
Date: Fri, 04 Feb 2000 00:00
94 lines
4668 bytes
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> <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. 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> <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? All advice appreciated.</font> <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-mailReferences:
<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