Try this, notice where the DSN is being used:<br><br><br>'Establish a connection with data source <br>strDSN = "FILEDSN=MyDatabase.dsn" <br> <br>Set cn = Server.CreateObject("ADODB.Connection") <br>cn.Open...
Well, the first problem is that when the sql statement is executed, you will find that there are NO spaces between your FROM and ORDER BY. basically, the sql statement looks like this when executed:<br><br>"SELECT SongTable.NameSongFROM SongTableORDER...
Mike,<br><br>You can try using <pre> tags. This will retain all of your returns and spacing. The only drawback though is the width of the text. Depending on the amount of text, the page may go wide.<br><br>Hope this helps,<br><br>G..
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.