4GuysFromRolla.com : ASPFAQs : Databases, General

The Databases, General category contains the following FAQs:

Question: How can I output the records from my recordset in columns in a table? That is, instead of just one record per row in a table, how can I have multiple records per row?
[View the Answer!]	Posted by Bill Wilkinson at 1/7/2002 7:16:35 PM. (71,539 views...)

Question: How can I display images that reside in my database through an ASP page?
[View the Answer!]	Posted by Scott Mitchell at 11/12/2001 12:49:12 PM. (110,298 views...)

Question: How can I get all Field Names or Column Names from a recordset or database table ? ..or.. How can I write a general "table dump" for all records and fields in a recordset or table?
[View the Answer!]	Posted by Bill Wilkinson at 10/2/2001 3:52:01 PM. (61,000 views...)

Question: How can I secure an Access database that I use on my Web site? That is, I don't want users to be able to guess the URL of my Access .mdb file and download my database!
[View the Answer!]	Posted by Scott Mitchell at 8/24/2001 10:12:26 AM. (81,254 views...)

Question: I have a database with a table of categories and a table of subcategories. How can I easily make a display that will show each category with its related subcategories grouped under it?
[View the Answer!]	Posted by Bill Wilkinson at 4/20/2001 10:29:26 PM. (64,205 views...)

Question: What are some issues that may arise when using dates and working with databases?
[View the Answer!]	Posted by Scott Mitchell at 4/9/2001 5:22:38 PM. (47,730 views...)

Question: What databases can ASP work with? How do technologies like ADO, OLE-DB, and ODBC fit in?
[View the Answer!]	Posted by Scott Mitchell at 4/5/2001 11:49:47 PM. (88,900 views...)

Question: How can I effectively use a checkbox to update data in a database? (A typical example might be changing the status of members in a roster from active to inactive or vice versa.)
[View the Answer!]	Posted by Bill Wilkinson at 3/4/2001 10:17:10 PM. (83,811 views...)

Question: How can I show a table of records from a recordset and let my users choose which field (column) to sort on?
[View the Answer!]	Posted by Bill Wilkinson at 3/4/2001 1:03:44 AM. (66,963 views...)

Question: What is adovbs.inc? Why should I use it? What benefits does it have?
[View the Answer!]	Posted by Scott Mitchell at 1/28/2001 5:10:19 AM. (87,088 views...)

Question: How can I use RecordSet.GetString to create a drop down list? How about other more complex output using GetString?
[View the Answer!]	Posted by Bill Wilkinson at 1/16/2001 7:56:41 PM. (59,771 views...)

Question: Is there a way I can automate the retrieval of a recordset from a database (so I don't have to type the same code over and over)?
[View the Answer!]	Posted by Richard Lowe at 11/21/2000 10:50:02 PM. (52,238 views...)

Question: My memo fields show up as blank! OR When I test my memo field for a value and then try to show it only if it is not blank [or only if it contains some string or or or], then when I display it I get nothing!
[View the Answer!]	Posted by Bill Wilkinson at 11/7/2000 9:12:07 PM. (58,032 views...)

Question: **UPDATED 1 April 2002** How do I get the record number of a just added record?
[View the Answer!]	Posted by Bill Wilkinson at 11/3/2000 9:07:09 PM. (97,514 views...)

Question: How can I run a stored procedure from ASP using only the ADO connection object?
[View the Answer!]	Posted by Richard Lowe at 10/31/2000 1:16:22 AM. (63,507 views...)

Question: How big can my Access Database be?
[View the Answer!]	Posted by Scott Mitchell at 10/24/2000 6:09:30 PM. (55,031 views...)

Question: How can I display Recordset data in an HTML TABLE? How can I get the names of all the fields in a table?
[View the Answer!]	Posted by Scott Mitchell at 10/6/2000 3:44:19 PM. (64,285 views...)

Question: How can I page database results N records at a time?
[View the Answer!]	Posted by Scott Mitchell at 9/30/2000 6:04:13 AM. (56,067 views...)

Question: How can I tell what version of ADO I am using?
[View the Answer!]	Posted by Scott Mitchell at 9/24/2000 12:40:01 AM. (43,809 views...)

Question: How do you create a database table through a SQL statement (via an ASP page, perhaps)?
[View the Answer!]	Posted by Scott Mitchell at 9/24/2000 12:27:52 AM. (74,803 views...)

Do you have a FAQ you'd like to suggest? Suggestions? Comments? If so, send it in! Also, if you'd like to be a FAQ Admin (creating/editing FAQs), let me know! If you are looking for other FAQs, be sure to check out the 4Guys FAQ and Commonly Asked Messageboard Questions!

Most Viewed FAQs: 1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. (761643 views) 2.) I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem? (207777 views) 3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? (202549 views) 4.) How can I quickly sort a VBScript array? (196039 views) 5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. (156019 views) 6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... (152331 views) 7.) When I get a list of all files in a directory via the FileSystemObject, they aren't ordered in any reasonable way. How can I sort the files by name? Or by size? Or by date created? Or... (140381 views) 8.) For session variables to work, must the Web visitor have cookies enabled? (110162 views) 9.) Can I send emails without using CDONTS? (107083 views) 10.) How can I take the result of a SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? (106308 views) Last computed at 9/17/2007 3:22:00 AM

Windows Internet Technology | ASP.NET [1.x] [2.0] | ASPMessageboard.com | ASPFAQs.com | Advertise | Feedback | Author an Article