• Is there any performance hit if DB connection string is specified in an include file?
• Is it better to hard code the DB connection string in each page and close in same?
• What is the best method to use for adding new records to a database? Should I use an SQL statement or an ADO?
• How do I insert an AUTONUMBER into a database?
• What is the correct syntax for summing a field returned in a recordset?
• How can I set up the SQL statement to allow apostrophes in the WHERE clause, without causing a syntax error?
• How do I search about 100 tables in the same database AT ONCE looking for a certain record?
• How can I request the unique id key that SQL Server generates as it adds the new record?
• Is it possible to call a stored procedure in Access to insert records from ASP?
• How can I import data from a text file into an Access database?
• What is the exact syntax of the SQL 'ORDER BY' CLAUSE if I want the order to be in descending order?
• Has anyone done any tests into the speeds of DSNless connections vs. connections routed through ODBC?
• What is the procedure to deploy an SQL database on a remote web server?
• In my SQL statements, how can I get the "next value" generated by an autonumber field in my Access database ?
• Why does 'rsname.RecordCount' always return -1 even when looping through all records?
• How can I search the database by more than one field and value at the same time?
• How do I do a 2 table field comparison in a RS Do loop and return data from the second table?
• Using UDL Connection String Examples

Unanswered Questions

• How do I create a function that will save the HTML page to a database?
• How to insert client files (say doc/rtf/htm) into SQL server database?
• Getting a product id (instead of the name) and inserting it into a table. Getting error
• Getting a product id (instead of the name) and inserting it into a table. Getting ODBC Drivers error '80040e07'
• Getting a product id (instead of the name) and inserting it into a table. Getting ODBC Drivers error '80040e07' .
• Web form w/combo box w/ names of countries (from a table "country"). User selects a name and the country ID must be inserted into another table. How ?
• In my SQL statements, how can I get the "next value" generated by an autonumber field in my Access database ?
• When I write a sql in my ASP page I would like the datatype to be double with 2 dec or currency -
• How to get the values into list box placed in a grid at runtime(from database)
• In ASP how can i know if a stored procedure have or not input parameter(s)
• I want to fill in input boxes from a record in a table selected by a combo box. Must be server side
• can i perform something similar to the oracle function trunc()? if so, how?
• How do I display databases with different number of columns(fields) using one ASP page?
• What are the best <table> layouting methods of for huge database?
• how can i add field dynamically to an existing database table in access using vb
• how do i use the contents of an array stored in a session variable as the criteria in a SQL statemen
• how to add an item selected from a combox to access thru asp?
• How can I add 2 SQL Decimal fields in ASp becuse it returns Type mismatch
• How to insert records in a text file into corresponding fields in table
• Importing from a text to sql with autonumber. i am trying to import from a text file to sql
• Some Sql in the past. How can I write in vbscript an Sql to go to a Specific Day.
• Some Sql in the past. How can I write in vbscript an Sql to go to a Specific Day.
• Some Sql in the past. How can I write in vbscript an Sql to go to a Specific Day.