Help with sorting Access table using ASP

[John]

Hi all
I have been trying to sort an Access table "calendar" by the field
"Date" into ascending order.
I've tried a straight SQL query, but I don't believe my server
supports SQL although they do support ASP.
I've tried using a stored query in Access "Gigdatesort" with no luck.

Is anyone out there who is able to help?
It would be appreciated.

TIA.

 

[Ronx]

If your server does not support SQL you cannot use any databases. SQL
is the "language" used to manipulate databases, no matter what server
or scripting language is being used.
It is more likely that either the server does not support any
database, or the syntax you are using is wrong.

A typical(?) database query should look (something) like this:


myConnString = Application("Database1_ConnectionString")
Set myConnection = Server.CreateObject("ADODB.Connection")
myConnection.Open myConnString

mySQL="SELECT * FROM WebFaqs WHERE (WebFaqs.File = """ & sFilenm &
""")"
set rsTemp1 = myConnection.execute(mySQL)


Notice that the SQL statement is contained in a string, and cannot be
interpreted as an incomplete VBscript statement.