🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: ee.arvutid.microsoft
Article #276

Asp: Kuidas saada andmebaasist pilt veebilehele

#276
From: Arvi Laanemets
Date: Thu, 31 Jan 2008 10:16
31 lines
2052 bytes
Tere!

Accessi andmebaasi p�hjal on vaja genereerida veebileht, kus on kuvatud 
jooksva p�eva k�lalised, ja nt. vastava riigi lipu kujutis. Asp-koodi 
l�htetabeliks on Acessi p�ring qGuestsToday, milline v�ljastab iga k�lastaja 
kohta v�lja Guest tekstilise infoga (firma ja k�lastaja nimi), ning v�lja 
FlagPath pildifaili suhtelise aadressiga (formaadis "./Path/FileName")


Meil ei �nnestu asp'is vastavaid pildifaile �ieti sisse lugeda. Kui 
kirjutame koodi �he konkreetse pildifaili (nt. eesti lipu kujutis) sisse, 
siis kood t��tab. Aga kuidas teha, et "./Flags/Est.gif">>FlagPath ?

.....
strSQL = "SELECT Guest, FlagPath FROM qGuestsToday;"
rsGuestbook.Open strSQL, adocon
.....
Do While Not rsGuestbook.EOF

    Response.Write (rsGuestbook("Guest"))
    Response.Write ("  &nbsp)
    Response.Write "<IMG SRC = ""./Flags/Est.gif"" Width = ""45"" Height =
""30"" >"
    Response.Write   ("<br>")
Loop
.....


Abi eest juba ette t�nades:
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )
Technical Details
Message-ID: <47a1a015$1_2@news.estpak.ee>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!multikabel.net!feed20.multikabel.net!surfnet.nl!surfnet.nl!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.estpak.ee!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 101f2d,84dffc72695377,start
X-Google-Attributes: gid101f2d,public,usenet
X-Google-Language: ESTONIAN,CP1257
From: "Arvi Laanemets" <garbage@hot.ee>
Newsgroups: ee.arvutid.microsoft
Subject: Asp: Kuidas saada andmebaasist pilt veebilehele
Date: Thu, 31 Jan 2008 12:16:54 +0200
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.50.208.117
Message-ID: <47a1a015$1_2@news.estpak.ee>
X-Trace: news.estpak.ee 1201774613 195.50.208.117 (31 Jan 2008 12:16:53 +0200)
Distribution: Estonia
X-Complaints-To: usenet@estpak.ee
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!multikabel.net!feed20.multikabel.net!surfnet.nl!surfnet.nl!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.estpak.ee!not-for-mail