How can I return the rows from a SELECT statement in random order?
[Answer]
How can I create a stored procedure to select the top N records? For example, I'd like to be able to do:
sp_GetTopRecords 25 and select the top 25 records.
[Answer]
This might be simple for you, but I just can't figure it out. I have built a large database with several
categories of products. What code do I write to make a list selection in one box (main categories) bring up
another list box with items only associated with the intial category selected (I hope that made sense.)?
[Answer]
I get errors when inserting a text string that contains an apostrophe... why is this?
[Answer]
[Answer @ ASPFAQs.com]
How can I display database image files through an ASP page?
[Answer]
I need to get the value of an Autonumber field (in MS Access) upon a record insert. How do I do this!?
[Answer]
In my Access database I have table names with spaces. In ASP, when I try to write my SQL statements,
having spaces in the table names throws things off. Help!
[Answer]
When I use the .RecordCount property to count the number of records in my recordset,
it returns -1. Why?
[Answer]
Should I use a System DSN or a DSN-less connection to connect to my database?
[Answer]
I need a SQL query that will check to see whether a table exists. How do I do this?
[Answer]
How do I read data from a database and store the information into variables?
[Answer]
How do I sort a recordset based on the Autonumber field (or any field, for that matter)?
[Answer]
How do I list the tables in an Access database?
[Answer]
How do I check what ADO version I have? Specifically, I want to see if I'm using ADO 2.1.
[Answer]
[Answer @ ASPFAQs.com]
So far I've only worked with access when codin my asp pages. I want to move up to MSSQL server
though, how much different is it from Access? Is it quick to pick up? Does my ASP code need to
be change in any way?
[Answer]
