i have sql code along the lines of this on all pages
Expand|Select|Wrap|Line Numbers
- Set yaketyConnection=Server.CreateObject("ADODB.Connection")
- DatabaseDetails="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../../private/yaketynew.mdb") & ";"
- yaketyConnection.Open DatabaseDetails
- yaketyQuery="SELECT * FROM celebs WHERE voicetypea like '%"&voiceid&"%' and sex like 'm' or voicetypeb like '%"&voiceid&"%' and sex like 'm' or voicetypec like '%"&voiceid&"%' and sex like 'm' or voicetyped like '%"&voiceid&"%' and sex like 'm' or voicetypee like '%"&voiceid&"%' and sex like 'm' or voicetypef like '%"&voiceid&"%' and sex like 'm' or voicetypeg like '%"&voiceid&"%' and sex like 'm' or voicetypeh like '%"&voiceid&"%' and sex like 'm' or voicetypei like '%"&voiceid&"%' and sex like 'm' or voicetypej like '%"&voiceid&"%' and sex like 'm' or voicetypek like '%"&voiceid&"%' and sex like 'm' or voicetypel like '%"&voiceid&"%' and sex like 'm' or voicetypem like '%"&voiceid&"%' and sex like 'm' or voicetypen like '%"&voiceid&"%' and sex like 'm' or voicetypem like '%"&voiceid&"%' and sex like 'm' or voicetypeo like '%"&voiceid&"%' and sex like 'm' or voicetypep like '%"&voiceid&"%' and sex like 'm' or voicetypeq like '%"&voiceid&"%' and sex like 'm' or voicetyper like '%"&voiceid&"%' and sex like 'm' or voicetypes like '%"&voiceid&"%' and sex like 'm' or voicetypet like '%"&voiceid&"%' and sex like 'm' or voicetypeu like '%"&voiceid&"%' and sex like 'm' or voicetypev like '%"&voiceid&"%' and sex like 'm' or voicetypew like '%"&voiceid&"%' and sex like 'm' order by surname,firstname"
- Set yaketyRecordset=yaketyConnection.execute(yaketyQuery)
I hope someone can assist i would like to speed up our website and im sure the code and database is messy