Article View: ee.arvutid.microsoft
Article #276Asp: Kuidas saada andmebaasist pilt veebilehele
From: Arvi Laanemets
Date: Thu, 31 Jan 2008 10:16
Date: Thu, 31 Jan 2008 10:16
31 lines
2052 bytes
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 ("  )
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-mailShow 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