Generate list A-z and contents

Tamamlanmış İlan edilme: Feb 21, 2003 Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

* * *I require code written in ASP/VBScript that will generate a index list then list all the records found.

The index list will be A-Z excluding those letters where there is no word starting with the letter in the list.

eg. If there are no words starting with B then there will be no letter B listed.

The letters at the top of the page (index list) will be hyper-links to the start of the list starting with that letter.

Each list of records is to be seperated into 3 columns with a space between each list. See attached example. The records are to be sorted A to Z. The records are to be distinct.

There are two recordsets where the records come from. Each recordset is distinct, but there may be records the same, one in each recordset. The list displayed is to be distinct.

The SQL for obtaining the records is:

*"SELECT Distinct ListTown FROM (Contact_ParkClient INNER JOIN Contact_Details ON [url removed, login to view] = [url removed, login to view]) INNER JOIN Park_Details ON ([url removed, login to view] = [url removed, login to view]) AND ([url removed, login to view] = [url removed, login to view]) WHERE AddressState = '" & [url removed, login to view]("State") & "' and Type = '" & "Park" & "'"*

and

*query2 = "SELECT Distinct Address3 FROM (Contact_ParkClient INNER JOIN Contact_Details ON [url removed, login to view] = [url removed, login to view]) INNER JOIN Park_Details ON ([url removed, login to view] = [url removed, login to view]) AND ([url removed, login to view] = [url removed, login to view]) WHERE AddressState = '" & [url removed, login to view]("State") & "' and Type = '" & "Park" & "'"*

I am open to suggestions if the SQL can be done more effeciently.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.

**NOTE:**

Due to commercial-in-confidence issues I cannot release the database that this data is coming from.

If you require more information please let me know. **I require this code as soon as possible.** As such, please post the time frame within which you can deliver, this along with the price will be the deciding factors in choosing a coder.

## Platform

Windows server 2000

ASP Mühendislik Microsoft Access MySQL PHP Yazılım Mimarisi Yazılım Test Etme Visual Basic

Proje NO: #2909379

Proje hakkında

4 teklif Uzak proje Aktif Feb 21, 2003

Seçilen:

peterjl

See private message.

%selectedBids___i_period_sub_7% gün içinde 19.55%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(75 Değerlendirme)
5.3

Bu iş için 4 freelancer ortalamada $22 teklif veriyor

ActazenCorp

See private message.

$21.25 USD in 14 gün içinde
(38 Değerlendirme)
5.5
gudipudisrikanth

See private message.

$25.5 USD in 14 gün içinde
(3 Değerlendirme)
2.6
warrenimisides

See private message.

$21.25 USD in 14 gün içinde
(2 Değerlendirme)
1.7