God morgon!

mm..jag har sovit gott, trots att jag somnade p=E5 soffan..men den e ju 
ganska go=B4att sova p=E5 . Gott att somna till Tv;n ibland,, Sj=E4lv 
d=E5? Sovit gott? Vart ute och sprungit ett par kilometer i morse,,? 
M=E5ste ju fr=E5ga, det finns ju s=E5nna som b=F6rjar morgonen s=E5!
Skulle kunna t=E4nka mig att cykla till jobbet men cykla 5 mil/dag =E4r 
inget som tilltalar mig direkt... Jag f=E5r b=F6rja p=E5 Coop konsum.. 
d=E5 =E4r det inte s=E5 l=E5ngt!

Kram//M





-----Ursprungligt meddelande-----
Fr=E5n: AJAX=AE [mailto:ajax@t...]
Skickat: den 29 augusti 2002 06:30
Till: ASP Databases
=C4mne: [asp_databases] Re: Newbie Here - ASP Page Won't Display


hi pat,

not an exact solution but a trick that u must use very often

after u generate the Query in the sqlText variable use this line

response.write(sqltext)
cut and paste the query displayed in ur database and look for errors

also might help if u used the same technique to verify if the value is 
passed properly from the previous page
response.write(AlbumID)


hth,
ajax

----- Original Message -----
From: "Pat Wong" <vinyl-junkie@n...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, August 29, 2002 8:16 AM
Subject: [asp_databases] Newbie Here - ASP Page Won't Display


> I'm *really* new to ASP databases, with only one working page using it 

> to my credit. I'm trying to do a second page which has data passed to
> it from my first page, and I'm  and having a heck of a time getting it 

> to work. I can't see a thing wrong with my code. Spelling is correct
> on all variables, because I just double-checked that. The page is
> blowing up on the Open statement. Here's a portion of my code. Can you 

> help before I go bald from tearing my hair out over this? Thanks!
>
> <%
> Dim varAlbumID
> Dim oRStrks
> varAlbumID =3D Request.QueryString("AlbumID")
>
> Set oRStrks=3DServer.CreateObject("ADODB.recordset")
>
> sqltext =3D "SELECT tblAlbums.AlbumID AS albumid,tblAlbums.Title AS
> albumtitle," sqltext =3D sqltext & "tblAlbums.ArtistID AS
> artistid,tblAlbums.Total_Playing_Time AS totaltime,"
> sqltext =3D sqltext & "tblTracks.TrackID AS trackid,tblTracks.Title AS
> tracktitle,"
> sqltext =3D sqltext & "tblTracks.Duration AS 
tracktime,tblTracks.Composer
> AS composer,"
> sqltext =3D sqltext & "tblArtists.Artist AS artist,tblArtist.The FROM
> tblTracks "
> sqltext =3D sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID =3D
> tblArtists.ArtistID "
> sqltext =3D sqltext & "INNER JOIN tblAlbums ON tblTracks.AlbumID =3D
> tblAlbums.AlbumID "
> sqltext =3D sqltext & "WHERE albumid=3DvarAlbumID ORDER BY trackid;"
> oRStrks.open sqltext, "DSN=3DCDTrust"
>
>
> ~8^) Pat Wong (ICQ #61070813)
> http://www.napathon.com/
> -------------------------------------------------------------------
> "You can't talk to a man with a shotgun in his hand." Smackwater Jack
> by Carole King
> -------------------------------------------------------------------
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>