---

Hej

Hvordan for jeg asp til at udvælge den rigtige by i en post tabel, når jeg
har post nr. i en elev tabel ?

Jeg ved at det er i SQL sætningen, men jeg kan ikke lige over syntaksen

Jeg bruger en Access DB

--
Hilsen AHJ

---

"Anders Holm Jensen" <ahjmw@mail1.stofanet.dk> wrote in message
news:3bb4f369$0$4787$ba624c82@nntp01.dk.telia.net...
> Hej
>
> Hvordan for jeg asp til at udvælge den rigtige by i en post tabel, når jeg
> har post nr. i en elev tabel ?
>
> Jeg ved at det er i SQL sætningen, men jeg kan ikke lige over syntaksen


Nu kender jeg jo ikke opbygningen af dine tabeller, men det du skal læse op
på er join.
Den benyttes når du vil "sammenkører" 2 tabeller og det er vist netop det du
vil her
Mvh
Janus

---

Ja det er det jeg vil.

Har du et kode eksempel ?

Hilsen AHJ
Tak for svaret !!

"Janus Klok Lauritsen" <janus@mcb.dk> skrev i en meddelelse
news:3bb4f599$0$4790$ba624c82@nntp01.dk.telia.net...
> "Anders Holm Jensen" <ahjmw@mail1.stofanet.dk> wrote in message
> news:3bb4f369$0$4787$ba624c82@nntp01.dk.telia.net...
> > Hej
> >
> > Hvordan for jeg asp til at udvælge den rigtige by i en post tabel, når
jeg
> > har post nr. i en elev tabel ?
> >
> > Jeg ved at det er i SQL sætningen, men jeg kan ikke lige over syntaksen
>
>
> Nu kender jeg jo ikke opbygningen af dine tabeller, men det du skal læse
op
> på er join.
> Den benyttes når du vil "sammenkører" 2 tabeller og det er vist netop det
du
> vil her
> Mvh
> Janus
>
>

---

Det kunne f.eks. se nogenlunge således ud med en tabel ved navn elev og en
ved navn postnr:

SELECT elev.navn, postnr.bynavn FROM elev
INNER JOIN postnr ON postnr.postnummer = elev.postnummer
WHERE elev.id = 1

Tony
--
Tony Lorentzen
Freelance webudvikler
tony@lorentzen.com

---

Jeg takker, det virker efter planen

Hilsen AHJ

"Tony Lorentzen" <tony@lorentzen.com> skrev i en meddelelse
news:9p303u$amj$1@news.cybercity.dk...
> Det kunne f.eks. se nogenlunge således ud med en tabel ved navn elev og en
> ved navn postnr:
>
> SELECT elev.navn, postnr.bynavn FROM elev
> INNER JOIN postnr ON postnr.postnummer = elev.postnummer
> WHERE elev.id = 1
>
> Tony
> --
> Tony Lorentzen
> Freelance webudvikler
> tony@lorentzen.com
>
>

---

Hvis man bruge property i asp lige som i visual basic er det her måske noget
i kan bruge

Meget hurtiger end databaser

Roser/Ris sendes til til@infojens.dk

Public Property Get By(ByVal nr As Long) As String

Select Case nr
Case 1050 To 1550
By = "København K"
Case 1550 To 1800
By = "København V"
Case 1800 To 2100
By = "Frederiksberg C"
Case 2100
By = "København Ø"
Case 2200
By = "København N"
Case 2300
By = "København S"
Case 2400
By = "København NV"
Case 2450
By = "København SV"
Case 2500
By = "Valby"
Case 2600
By = "Glostrup"
Case 2605
By = "Brøndby"
Case 2610
By = "Rødovre"
Case 2620
By = "Albertslund"
Case 2625
By = "Vallensbæk"
Case 2630
By = "Taastrup"
Case 2635
By = "Ishøj"
Case 2640
By = "Hedehusene"
Case 2650
By = "Hvidovre"
Case 2660
By = "Brøndby Strand"
Case 2665
By = "Vallensbæk Strand"
Case 2670
By = "Greve"
Case 2680
By = "Solrød Strand"
Case 2690
By = "Karlslunde"
Case 2700
By = "Brønshøj"
Case 2720
By = "Vanløse"
Case 2730
By = "Herlev"
Case 2740
By = "Skovlunde"
Case 2750
By = "Ballerup"
Case 2760
By = "Måløv"
Case 2765
By = "Smørum"
Case 2770
By = "Kastrup"
Case 2791
By = "Dragør"
Case 2800
By = "Lyngby"
Case 2820
By = "Gentofte"
Case 2830
By = "Virum"
Case 2840
By = "Holte"
Case 2850
By = "Nærum"
Case 2860
By = "Søborg"
Case 2880
By = "Bagsværd"
Case 2900
By = "Hellerup"
Case 2920
By = "Charlottenlund"
Case 2930
By = "Klampenborg"
Case 2942
By = "Skodsborg"
Case 2950
By = "Vedbæk"
Case 2960
By = "Rungsted Kyst"
Case 2970
By = "Hørsholm"
Case 2980
By = "Kokkedal"
Case 2990
By = "Nivå"
Case 3000
By = "Helsingør"
Case 3050
By = "Humlebæk"
Case 3060
By = "Espergærde"
Case 3070
By = "Snekkersten"
Case 3080
By = "Tikøb"
Case 3100
By = "Hornbæk"
Case 3120
By = "Dronningmølle"
Case 3140
By = "Ålsgårde"
Case 3150
By = "Hellebæk"
Case 3200
By = "Helsinge"
Case 3210
By = "Vejby"
Case 3220
By = "Tisvildeleje"
Case 3230
By = "Græsted"
Case 3250
By = "Gilleleje"
Case 3300
By = "Frederiksværk"
Case 3310
By = "Ølsted"
Case 3320
By = "Skævinge"
Case 3330
By = "Gørløse"
Case 3360
By = "Liseleje"
Case 3370
By = "Melby"
Case 3390
By = "Hundested"
Case 3400
By = "Hillerød"
Case 3450
By = "Allerød"
Case 3460
By = "Birkerød"
Case 3480
By = "Fredensborg"
Case 3490
By = "Kvistgård"
Case 3500
By = "Værløse"
Case 3520
By = "Farum"
Case 3540
By = "Lynge"
Case 3550
By = "Slangerup"
Case 3600
By = "Frederikssund"
Case 3630
By = "Jægerspris"
Case 3650
By = "Ølstykke"
Case 3660
By = "Stenløse"
Case 3670
By = "Veksø Sjælland"
Case 3700
By = "Rønne"
Case 3720
By = "Aakirkeby"
Case 3730
By = "Nexø"
Case 3740
By = "Svaneke"
Case 3751
By = "Østermarie"
Case 3760
By = "Gudhjem"
Case 3770
By = "Allinge"
Case 3782
By = "Klemensker"
Case 3790
By = "Hasle"
Case 3900
By = "Nuuk"
Case 3905
By = "Nuussuaq"
Case 3910
By = "Kangerlussuaq"
Case 3911
By = "Sisimiut"
Case 3912
By = "Maniitsoq"
Case 3913
By = "Tasiilaq"
Case 3915
By = "Kulusuk"
Case 3920
By = "Qaqortoq"
Case 3921
By = "Narsaq"
Case 3922
By = "Nanortalik"
Case 3923
By = "Narsarsuaq"
Case 3924
By = "Ikerasassuaq"
Case 3930
By = "Kangilinnguit"
Case 3932
By = "Arsuk"
Case 3940
By = "Paamiut"
Case 3950
By = "Aasiaat"
Case 3951
By = "Qasigiannguit"
Case 3952
By = "Ilulissat"
Case 3953
By = "Qeqertarsuaq"
Case 3955
By = "Kangaatsiaq"
Case 3961
By = "Uummannaq"
Case 3962
By = "Upernavik"
Case 3970
By = "Pituffik"
Case 3971
By = "Qaanaaq"
Case 3980
By = "Ittoqqortoormiit"
Case 3984
By = "Danmarkshavn"
Case 3985
By = "Constable Pynt"
Case 4000
By = "Roskilde"
Case 4040
By = "Jyllinge"
Case 4050
By = "Skibby"
Case 4060
By = "Kirke Såby"
Case 4070
By = "Kirke Hyllinge"
Case 4100
By = "Ringsted"
Case 4130
By = "Viby Sjælland"
Case 4140
By = "Borup"
Case 4160
By = "Herlufmagle"
Case 4171
By = "Glumsø"
Case 4173
By = "Fjenneslev"
Case 4174
By = "Jystrup Midtsj"
Case 4180
By = "Sorø"
Case 4190
By = "Munke Bjergby"
Case 4200
By = "Slagelse"
Case 4220
By = "Korsør"
Case 4230
By = "Skælskør"
Case 4241
By = "Vemmelev"
Case 4242
By = "Boeslunde"
Case 4243
By = "Rude"
Case 4250
By = "Fuglebjerg"
Case 4261
By = "Dalmose"
Case 4262
By = "Sandved"
Case 4270
By = "Høng"
Case 4281
By = "Gørlev"
Case 4291
By = "Ruds Vedby"
Case 4293
By = "Dianalund"
Case 4295
By = "Stenlille"
Case 4296
By = "Nyrup"
Case 4300
By = "Holbæk"
Case 4320
By = "Lejre"
Case 4330
By = "Hvalsø"
Case 4340
By = "Tølløse"
Case 4350
By = "Ugerløse"
Case 4360
By = "Kirke Eskilstrup"
Case 4370
By = "Store Merløse"
Case 4390
By = "Vipperød"
Case 4400
By = "Kalundborg"
Case 4420
By = "Regstrup"
Case 4440
By = "Mørkøv"
Case 4450
By = "Jyderup"
Case 4460
By = "Snertinge"
Case 4470
By = "Svebølle"
Case 4480
By = "Store Fuglede"
Case 4490
By = "Jerslev Sjælland"
Case 4500
By = "Nykøbing Sj"
Case 4520
By = "Svinninge"
Case 4532
By = "Gislinge"
Case 4534
By = "Hørve"
Case 4540
By = "Fårevejle"
Case 4550
By = "Asnæs"
Case 4560
By = "Vig"
Case 4571
By = "Grevinge"
Case 4572
By = "Nørre Asmindrup"
Case 4573
By = "Højby"
Case 4581
By = "Rørvig"
Case 4583
By = "Sjællands Odde"
Case 4591
By = "Føllenslev"
Case 4592
By = "Sejerø"
Case 4593
By = "Eskebjerg"
Case 4600
By = "Køge"
Case 4621
By = "Gadstrup"
Case 4622
By = "Havdrup"
Case 4623
By = "Lille Skensved"
Case 4632
By = "Bjæverskov"
Case 4640
By = "Fakse"
Case 4652
By = "Hårlev"
Case 4653
By = "Karise"
Case 4654
By = "Fakse Ladeplads"
Case 4660
By = "Store Heddinge"
Case 4671
By = "Strøby"
Case 4672
By = "Klippinge"
Case 4673
By = "Rødvig Stevns"
Case 4681
By = "Herfølge"
Case 4682
By = "Tureby"
Case 4683
By = "Rønnede"
Case 4684
By = "Holme-Olstrup"
Case 4690
By = "Haslev"
Case 4700
By = "Næstved"
Case 4720
By = "Præstø"
Case 4733
By = "Tappernøje"
Case 4735
By = "Mern"
Case 4736
By = "Karrebæksminde"
Case 4750
By = "Lundby"
Case 4760
By = "Vordingborg"
Case 4771
By = "Kalvehave"
Case 4772
By = "Langebæk"
Case 4773
By = "Stensved"
Case 4780
By = "Stege"
Case 4791
By = "Borre"
Case 4792
By = "Askeby"
Case 4793
By = "Bogø By"
Case 4800
By = "Nykøbing F"
Case 4840
By = "Nørre Alslev"
Case 4850
By = "Stubbekøbing"
Case 4862
By = "Guldborg"
Case 4863
By = "Eskilstrup"
Case 4871
By = "Horbelev"
Case 4872
By = "Idestrup"
Case 4873
By = "Væggerløse"
Case 4874
By = "Gedser"
Case 4880
By = "Nysted"
Case 4891
By = "Toreby L"
Case 4892
By = "Kettinge"
Case 4894
By = "Øster Ulslev"
Case 4895
By = "Errindlev"
Case 4900
By = "Nakskov"
Case 4912
By = "Harpelunde"
Case 4913
By = "Horslunde"
Case 4920
By = "Søllested"
Case 4930
By = "Maribo"
Case 4941
By = "Bandholm"
Case 4943
By = "Torrig L"
Case 4944
By = "Fejø"
Case 4951
By = "Nørreballe"
Case 4952
By = "Stokkemarke"
Case 4953
By = "Vesterborg"
Case 4960
By = "Holeby"
Case 4970
By = "Rødby"
Case 4983
By = "Dannemare"
Case 4990
By = "Sakskøbing"
Case 5100
By = "Odense C"
Case 5200
By = "Odense V"
Case 5210
By = "Odense NV"
Case 5220
By = "Odense SØ"
Case 5230
By = "Odense M"
Case 5240
By = "Odense NØ"
Case 5250
By = "Odense SV"
Case 5260
By = "Odense S"
Case 5270
By = "Odense N"
Case 5290
By = "Marslev"
Case 5300
By = "Kerteminde"
Case 5320
By = "Agedrup"
Case 5330
By = "Munkebo"
Case 5350
By = "Rynkeby"
Case 5370
By = "Mesinge"
Case 5380
By = "Dalby"
Case 5390
By = "Martofte"
Case 5400
By = "Bogense"
Case 5450
By = "Otterup"
Case 5462
By = "Morud"
Case 5463
By = "Harndrup"
Case 5464
By = "Brenderup Fyn"
Case 5466
By = "Asperup"
Case 5471
By = "Søndersø"
Case 5474
By = "Veflinge"
Case 5485
By = "Skamby"
Case 5491
By = "Blommenslyst"
Case 5492
By = "Vissenbjerg"
Case 5500
By = "Middelfart"
Case 5540
By = "Ullerslev"
Case 5550
By = "Langeskov"
Case 5560
By = "Aarup"
Case 5580
By = "Nørre Aaby"
Case 5591
By = "Gelsted"
Case 5592
By = "Ejby"
Case 5600
By = "Faaborg"
Case 5610
By = "Assens"
Case 5620
By = "Glamsbjerg"
Case 5631
By = "Ebberup"
Case 5642
By = "Millinge"
Case 5672
By = "Broby"
Case 5683
By = "Haarby"
Case 5690
By = "Tommerup"
Case 5700
By = "Svendborg"
Case 5750
By = "Ringe"
Case 5762
By = "Vester Skerninge"
Case 5771
By = "Stenstrup"
Case 5772
By = "Kværndrup"
Case 5792
By = "Årslev"
Case 5800
By = "Nyborg"
Case 5853
By = "Ørbæk"
Case 5854
By = "Gislev"
Case 5856
By = "Ryslinge"
Case 5863
By = "Ferritslev Fyn"
Case 5871
By = "Frørup"
Case 5874
By = "Hesselager"
Case 5881
By = "Skårup Fyn"
Case 5882
By = "Vejstrup"
Case 5883
By = "Oure"
Case 5884
By = "Gudme"
Case 5892
By = "Gudbjerg Sydfyn"
Case 5900
By = "Rudkøbing"
Case 5932
By = "Humble"
Case 5935
By = "Bagenkop"
Case 5953
By = "Tranekær"
Case 5960
By = "Marstal"
Case 5970
By = "Ærøskøbing"
Case 5985
By = "Søby Ærø"
Case 6000
By = "Kolding"
Case 6040
By = "Egtved"
Case 6051
By = "Almind"
Case 6052
By = "Viuf"
Case 6064
By = "Jordrup"
Case 6070
By = "Christiansfeld"
Case 6091
By = "Bjert"
Case 6092
By = "Sønder Stenderup"
Case 6093
By = "Sjølund"
Case 6094
By = "Hejls"
Case 6100
By = "Haderslev"
Case 6200
By = "Aabenraa"
Case 6230
By = "Rødekro"
Case 6240
By = "Løgumkloster"
Case 6261
By = "Bredebro"
Case 6270
By = "Tønder"
Case 6280
By = "Højer"
Case 6300
By = "Gråsten"
Case 6310
By = "Broager"
Case 6320
By = "Egernsund"
Case 6330
By = "Padborg"
Case 6340
By = "Kruså"
Case 6360
By = "Tinglev"
Case 6372
By = "Bylderup-Bov"
Case 6392
By = "Bolderslev"
Case 6400
By = "Sønderborg"
Case 6430
By = "Nordborg"
Case 6440
By = "Augustenborg"
Case 6470
By = "Sydals"
Case 6500
By = "Vojens"
Case 6510
By = "Gram"
Case 6520
By = "Toftlund"
Case 6534
By = "Agerskov"
Case 6535
By = "Branderup J"
Case 6541
By = "Bevtoft"
Case 6560
By = "Sommersted"
Case 6580
By = "Vamdrup"
Case 6600
By = "Vejen"
Case 6621
By = "Gesten"
Case 6622
By = "Bække"
Case 6623
By = "Vorbasse"
Case 6630
By = "Rødding"
Case 6640
By = "Lunderskov"
Case 6650
By = "Brørup"
Case 6660
By = "Lintrup"
Case 6670
By = "Holsted"
Case 6682
By = "Hovborg"
Case 6683
By = "Føvling"
Case 6690
By = "Gørding"
Case 6700
By = "Esbjerg"
Case 6701
By = "Esbjerg (postboks)"
Case 6705
By = "Esbjerg Ø"
Case 6710
By = "Esbjerg V"
Case 6715
By = "Esbjerg N"
Case 6720
By = "Fanø"
Case 6731
By = "Tjæreborg"
Case 6740
By = "Bramming"
Case 6752
By = "Glejbjerg"
Case 6753
By = "Agerbæk"
Case 6760
By = "Ribe"
Case 6771
By = "Gredstedbro"
Case 6780
By = "Skærbæk"
Case 6792
By = "Rømø"
Case 6800
By = "Varde"
Case 6818
By = "Årre"
Case 6823
By = "Ansager"
Case 6830
By = "Nørre Nebel"
Case 6840
By = "Oksbøl"
Case 6851
By = "Janderup Vestj"
Case 6852
By = "Billum"
Case 6853
By = "Vejers Strand"
Case 6854
By = "Henne"
Case 6855
By = "Ovtrup"
Case 6857
By = "Blåvand"
Case 6862
By = "Tistrup"
Case 6870
By = "Ølgod"
Case 6880
By = "Tarm"
Case 6893
By = "Hemmet"
Case 6900
By = "Skjern"
Case 6920
By = "Videbæk"
Case 6933
By = "Kibæk"
Case 6940
By = "Lem St"
Case 6950
By = "Ringkøbing"
Case 6960
By = "Hvide Sande"
Case 6971
By = "Spjald"
Case 6973
By = "Ørnhøj"
Case 6980
By = "Tim"
Case 6990
By = "Ulfborg"
Case 7000
By = "Fredericia"
Case 7080
By = "Børkop"
Case 7100
By = "Vejle"
Case 7120
By = "Vejle Øst"
Case 7130
By = "Juelsminde"
Case 7140
By = "Stouby"
Case 7150
By = "Barrit"
Case 7160
By = "Tørring"
Case 7171
By = "Uldum"
Case 7173
By = "Vonge"
Case 7182
By = "Bredsten"
Case 7183
By = "Randbøl"
Case 7184
By = "Vandel"
Case 7190
By = "Billund"
Case 7200
By = "Grindsted"
Case 7250
By = "Hejnsvig"
Case 7260
By = "Sønder Omme"
Case 7270
By = "Stakroge"
Case 7280
By = "Sønder Felding"
Case 7300
By = "Jelling"
Case 7321
By = "Gadbjerg"
Case 7323
By = "Give"
Case 7330
By = "Brande"
Case 7361
By = "Ejstrupholm"
Case 7362
By = "Hampen"
Case 7400
By = "Herning"
Case 7430
By = "Ikast"
Case 7441
By = "Bording"
Case 7442
By = "Engesvang"
Case 7451
By = "Sunds"
Case 7470
By = "Karup J"
Case 7480
By = "Vildbjerg"
Case 7490
By = "Aulum"
Case 7500
By = "Holstebro"
Case 7540
By = "Haderup"
Case 7550
By = "Sørvad"
Case 7560
By = "Hjerm"
Case 7570
By = "Vemb"
Case 7600
By = "Struer"
Case 7620
By = "Lemvig"
Case 7650
By = "Bøvlingbjerg"
Case 7660
By = "Bækmarksbro"
Case 7673
By = "Harboøre"
Case 7680
By = "Thyborøn"
Case 7700
By = "Thisted"
Case 7730
By = "Hanstholm"
Case 7741
By = "Frøstrup"
Case 7742
By = "Vesløs"
Case 7752
By = "Snedsted"
Case 7755
By = "Bedsted Thy"
Case 7760
By = "Hurup Thy"
Case 7770
By = "Vestervig"
Case 7790
By = "Thyholm"
Case 7800
By = "Skive"
Case 7830
By = "Vinderup"
Case 7840
By = "Højslev"
Case 7850
By = "Stoholm Jyll"
Case 7860
By = "Spøttrup"
Case 7870
By = "Roslev"
Case 7884
By = "Fur"
Case 7900
By = "Nykøbing M"
Case 7950
By = "Erslev"
Case 7960
By = "Karby"
Case 7970
By = "Redsted M"
Case 7980
By = "Vils"
Case 7990
By = "Øster Assels"
Case 8000
By = "Århus"
Case 8100
By = "Århus C (postboks)"
Case 8200
By = "Århus N"
Case 8210
By = "Århus V"
Case 8220
By = "Brabrand"
Case 8230
By = "Åbyhøj"
Case 8240
By = "Risskov"
Case 8250
By = "Egå"
Case 8260
By = "Viby J"
Case 8270
By = "Højbjerg"
Case 8300
By = "Odder"
Case 8305
By = "Samsø"
Case 8310
By = "Tranbjerg J"
Case 8320
By = "Mårslet"
Case 8330
By = "Beder"
Case 8340
By = "Malling"
Case 8350
By = "Hundslund"
Case 8355
By = "Solbjerg"
Case 8361
By = "Hasselager"
Case 8362
By = "Hørning"
Case 8370
By = "Hadsten"
Case 8380
By = "Trige"
Case 8381
By = "Mundelstrup"
Case 8382
By = "Hinnerup"
Case 8400
By = "Ebeltoft"
Case 8410
By = "Rønde"
Case 8420
By = "Knebel"
Case 8444
By = "Balle"
Case 8450
By = "Hammel"
Case 8462
By = "Harlev J"
Case 8464
By = "Galten"
Case 8471
By = "Sabro"
Case 8472
By = "Sporup"
Case 8500
By = "Grenaa"
Case 8520
By = "Lystrup"
Case 8530
By = "Hjortshøj"
Case 8541
By = "Skødstrup"
Case 8543
By = "Hornslet"
Case 8544
By = "Mørke"
Case 8550
By = "Ryomgård"
Case 8560
By = "Kolind"
Case 8570
By = "Trustrup"
Case 8581
By = "Nimtofte"
Case 8585
By = "Glesborg"
Case 8586
By = "Ørum Djurs"
Case 8592
By = "Anholt"
Case 8600
By = "Silkeborg"
Case 8620
By = "Kjellerup"
Case 8632
By = "Lemming"
Case 8641
By = "Sorring"
Case 8643
By = "Ans By"
Case 8653
By = "Them"
Case 8654
By = "Bryrup"
Case 8660
By = "Skanderborg"
Case 8670
By = "Låsby"
Case 8680
By = "Ry"
Case 8700
By = "Horsens"
Case 8721
By = "Daugård"
Case 8722
By = "Hedensted"
Case 8723
By = "Løsning"
Case 8732
By = "Hovedgård"
Case 8740
By = "Brædstrup"
Case 8751
By = "Gedved"
Case 8752
By = "Østbirk"
Case 8762
By = "Flemming"
Case 8763
By = "Rask Mølle"
Case 8765
By = "Klovborg"
Case 8766
By = "Nørre Snede"
Case 8781
By = "Stenderup"
Case 8783
By = "Hornsyld"
Case 8800
By = "Viborg"
Case 8830
By = "Tjele"
Case 8831
By = "Løgstrup"
Case 8832
By = "Skals"
Case 8840
By = "Rødkærsbro"
Case 8850
By = "Bjerringbro"
Case 8860
By = "Ulstrup"
Case 8870
By = "Langå"
Case 8881
By = "Thorsø"
Case 8882
By = "Fårvang"
Case 8883
By = "Gjern"
Case 8900
By = "Randers"
Case 8950
By = "Ørsted"
Case 8961
By = "Allingåbro"
Case 8963
By = "Auning"
Case 8970
By = "Havndal"
Case 8981
By = "Spentrup"
Case 8983
By = "Gjerlev J"
Case 8990
By = "Fårup"
Case 9000
By = "Aalborg"
Case 9100
By = "Aalborg (postboks)"
Case 9200
By = "Aalborg SV"
Case 9210
By = "Aalborg SØ"
Case 9220
By = "Aalborg Øst"
Case 9230
By = "Svenstrup J"
Case 9240
By = "Nibe"
Case 9260
By = "Gistrup"
Case 9270
By = "Klarup"
Case 9280
By = "Storvorde"
Case 9293
By = "Kongerslev"
Case 9300
By = "Sæby"
Case 9310
By = "Vodskov"
Case 9320
By = "Hjallerup"
Case 9330
By = "Dronninglund"
Case 9340
By = "Asaa"
Case 9352
By = "Dybvad"
Case 9362
By = "Gandrup"
Case 9370
By = "Hals"
Case 9380
By = "Vestbjerg"
Case 9381
By = "Sulsted"
Case 9382
By = "Tylstrup"
Case 9400
By = "Nørresundby"
Case 9430
By = "Vadum"
Case 9440
By = "Aabybro"
Case 9460
By = "Brovst"
Case 9480
By = "Løkken"
Case 9490
By = "Pandrup"
Case 9492
By = "Blokhus"
Case 9493
By = "Saltum"
Case 9500
By = "Hobro"
Case 9510
By = "Arden"
Case 9520
By = "Skørping"
Case 9530
By = "Støvring"
Case 9541
By = "Suldrup"
Case 9550
By = "Mariager"
Case 9560
By = "Hadsund"
Case 9574
By = "Bælum"
Case 9575
By = "Terndrup"
Case 9600
By = "Aars"
Case 9610
By = "Nørager"
Case 9620
By = "Aalestrup"
Case 9631
By = "Gedsted"
Case 9632
By = "Møldrup"
Case 9640
By = "Farsø"
Case 9670
By = "Løgstør"
Case 9681
By = "Ranum"
Case 9690
By = "Fjerritslev"
Case 9700
By = "Brønderslev"
Case 9740
By = "Jerslev J"
Case 9750
By = "Øster Vrå"
Case 9760
By = "Vrå"
Case 9800
By = "Hjørring"
Case 9830
By = "Tårs"
Case 9850
By = "Hirtshals"
Case 9870
By = "Sindal"
Case 9881
By = "Bindslev"
Case 9900
By = "Frederikshavn"
Case 9940
By = "Læsø"
Case 9970
By = "Strandby"
Case 9981
By = "Jerup"
Case 9982
By = "Ålbæk"
Case 9990
By = "Skagen"
Case Else
By = ""
End Select

End Property

---

> Hvis man bruge property i asp lige som i visual basic er det her måske
noget
> i kan bruge
>
> Meget hurtiger end databaser

Det er nok ikke den beste måde at gøre det på, da man så skulle
paste/include indholdet på hver side man har brug for postnummer/by.

Jeg tror såmænd heller ikke det er hurtigere end databaser, da ASP kører
hele Select sætningen igennem, hvilket godt kan tage noget tid, når den er
så stor.

Jeg mener personligt, at din metod er spild af resourcer, især hvis man
benytter en ordentlig database (f.eks. MS SQL Server).

/jesper/

---

Det jeg køre fra databasen køre rimeligt tjept !

Og databasen kommer ikke til at indeholde så mange records, så det er fint
med join.

Hilsen AHJ

"Jesper Nielsen" <jn@nielsenit.dk> skrev i en meddelelse
news:Ymat7.1455$Ay.180779@news010.worldonline.dk...
> > Hvis man bruge property i asp lige som i visual basic er det her måske
> noget
> > i kan bruge
> >
> > Meget hurtiger end databaser
>
> Det er nok ikke den beste måde at gøre det på, da man så skulle
> paste/include indholdet på hver side man har brug for postnummer/by.
>
> Jeg tror såmænd heller ikke det er hurtigere end databaser, da ASP kører
> hele Select sætningen igennem, hvilket godt kan tage noget tid, når den er
> så stor.
>
> Jeg mener personligt, at din metod er spild af resourcer, især hvis man
> benytter en ordentlig database (f.eks. MS SQL Server).
>
> /jesper/
>
>