Help with simple ASP + SQL?
Hi guys, I'm playing around with ASP a bit more and now I'm trying to figure out some basic SQL connections and such. I've made a very simple database in Access, which only has one table. It has the following 3 columns:
NumericTest (int)
DateTest (datetime)
StringTest (text)
For each column, I have 3 records of example data.
Although this database is extremely simple, I have a fairly good knowledge of many advanced Access concepts; I'm just using this very simple example to try to learn to use it with ASP.
Anyways, I'm just trying to do some really basic stuff. What I want to do it to display the database records in an HTML table (I know I have to use Response.Write to do this, but how do I create the connection to the database? Do I do it using CreateObject? Can someone provide me with an example or tell me how it's done?)
Next, I'd like to be able to include a simple search filter on the page...for example, if a user wanted to find a record containing the string "boo" they could type it into a textbox, and have the table only display records that contain that string.
Lastly, I'd like to be able to have the user to select a sort option...in other words, allowing them to sort via ascending or descending on one column.
Can anyone help me out with this? I would greatly appreciate it! Thanks! :D
Re : Help with simple ASP+SQL
If you write your code like
Response.Write objRst("NumericTest").Value & "<br/>"
Response.Write objRst("DateTest").Value & "<br/>"
Response.Write objRst("StringTest").Value & "<br/>"
So, its possible after loop statement.