Avatar billede guzzie Nybegynder
31. januar 2001 - 13:12 Der er 3 kommentarer og
1 løsning

Next link :(

Hey there people
I made a HUGE big mistake with my last database and after recieving great help from some of the experts here, I realised I had created a database that is NOT user friendly ;(
Sooooo here I go again
I am try to insert a next link, and for the results to be displayed in 2 columes
I tried before but still stuffed it up,
so any ideas from anyone would be welcome
heres the script

<body>
<link rel=\"stylesheet\" style=\"text/css\" href=\"../styles.css\">

<%

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"popup.mdb\")
strSQL = \"SELECT * FROM abc WHERE alpha=\'\" & request(\"alpha\") & \"\';\" 

Conn.Execute (strSQL)

Set rs = conn.Execute(strSQL)
if not (rs.BOF Or rs.EOF) Then
%>
<table class=\"border\" width=\"300\" align=\"center\" valign=\"top\" cellpadding=\"5\" cellspacing=\"0\" border=\"0\">
<tr>
    <td class=\"one\"><table>
<% Do While Not rs.EOF %>
<tr>
    <td><a href=java script:reqWin(\'popup.asp?id=<%= RS(\"ID\")%>\')><%=rs(\"word\")%></a></td>
</tr>
<%
RS.MoveNext
Loop
%>
</table>
</td>
</tr>
</table>
<%
conn.Close
Set conn = nothing
%>
<% else %>
<%
response.redirect (\"default.asp\")
%>
</body>

you can also check this link to see what I mean
http://www.guzzie.dk/dictonary_popup/default.asp

Avatar billede hope Nybegynder
31. januar 2001 - 13:21 #1
where are you from...joking us or really not speaking danish?
Avatar billede guzzie Nybegynder
31. januar 2001 - 13:23 #2
I am english but live in denmark :)
so I do read danish but If I write in danish :(
then I think I am a little to hard to understand with all my spelling mistakes :(
Avatar billede guzzie Nybegynder
31. januar 2001 - 19:09 #3
Problem is solved

Guzzie
Avatar billede guzzie Nybegynder
31. januar 2001 - 19:10 #4
thanks eagleeye
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester