Where og order i samme
Kan I sortere denne efter 'beskrivelse' ?strresult ="select id, billedformat, thumbnail, dias, bestillingsnr, fotograf, beskrivelse, dansk_navn, videnskabeligt_navn, geografisk_lokalitet, land, teknisk_info from diasliste where "
strresult = strresult&" (( bestillingsnr LIKE '%" & strquery & "%')"
strresult = strresult&" or ( fotograf LIKE '%" & strquery & "%')"
strresult = strresult&" or ( billedformat LIKE '%" & strquery & "%')"
strresult = strresult&" or ( pictureformat LIKE '%" & strquery & "%')"
strresult = strresult&" or ( beskrivelse LIKE '%" & strquery & "%')"
strresult = strresult&" or ( description LIKE '%" & strquery & "%')"
strresult = strresult&" or ( emneord LIKE '%" & strquery & "%')"
strresult = strresult&" or ( captions LIKE '%" & strquery & "%')"
strresult = strresult&" or ( dansk_navn LIKE '%" & strquery & "%')"
strresult = strresult&" or ( roedliste_status LIKE '%" & strquery & "%')"
strresult = strresult&" or ( videnskabeligt_navn LIKE '%" & strquery & "%')"
strresult = strresult&" or ( engelsk_navn LIKE '%" & strquery & "%')"
strresult = strresult&" or ( familie_latin LIKE '%" & strquery & "%')"
strresult = strresult&" or ( familie_dansk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( familie_engelsk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( orden_latin LIKE '%" & strquery & "%')"
strresult = strresult&" or ( orden_dansk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( orden_engelsk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( geografisk_lokalitet LIKE '%" & strquery & "%')"
strresult = strresult&" or ( naturtype LIKE '%" & strquery & "%')"
strresult = strresult&" or ( naturetype LIKE '%" & strquery & "%')"
strresult = strresult&" or ( amt LIKE '%" & strquery & "%')"
strresult = strresult&" or ( land LIKE '%" & strquery & "%')"
strresult = strresult&" or ( country LIKE '%" & strquery & "%')"
strresult = strresult&" or ( aarstid LIKE '%" & strquery & "%')"
strresult = strresult&" or ( season LIKE '%" & strquery & "%')"
strresult = strresult&" or ( kategori_dansk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( kategori_engelsk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( underkat_dansk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( underkat_engelsk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( kommentar_dansk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( kommentar_engelsk LIKE '%" & strquery & "%')"
strresult = strresult&" or ( teknisk_info LIKE '%" & strquery & "%')"
strresult = strresult&" or ( teknisk_info_eng LIKE '%" & strquery & "%'))"
