MaxFusion - ColdFusion for geeks
   Home  Tags  Projects  Library  FAQ
 Freebies  Links  Beta  Guestbook  Email

 Tell a Geek  ColdFusion FAQ

Search the FAQ:  

Category: Databases

Q. Are there any good books on database design?
Q. How can I remove the Access lockfile?
Q. How can I query an Excel spreadsheet as if it were a database?
Q. How do I get a list of tables contained in my Microsoft Access database?
Q. What are the differences between Access and SQL Server?
Q. How can I avoid the "ColumnName is not part of an aggregate function" error message when using COUNT and SUM in a SQL statement?
Q. Where can I find online SQL tutorials or guidance?
Q. What does the Data type mismatch in criteria expression error message mean?
Q. With two CFQUERYs on a page, how can you stop the first SQL statement from being run if the second one fails?
Q. I'm having problems with apostrophies and SQL statements.What's going on?
Q. How can I refer to columns names with spaces in a SQL statement?
Q. How can I remotely add a column to an Access database?
Q. How can I use an Excel spreadsheet as a datasource?
Q. How can I migrate an existing Access database to SQL Server?
Q. How can I remotely add a table to an Access database?
Q. How can I obtain a list of datasources on a server?
Q. there a way to alias several columns in an Excel spreadsheet and consolidate data into one column name?
Q. Where can I find a list of reserved words?
Q. Can ColdFusion connect to the Windows version of MySql?
Q. Can you store images in a database by using the BLOB datatype?
Q. How do you configure ColdFusion to access a SQL Server database?
Q. Is it possible for Cold Fusion to use an Access database on a different server?
Q. Should you index foreign keys in a database table?
Q. Is there a Personal Oracle Server that can be used for development?
Q. Is it possible for ColdFusion to query a FoxPro database?
Q. Is it true that the Access ODBC driver creates a memory leak?
Q. How do I uninstall MDAC?
Q. How do I get a list of fieldnames returned in a query?
Q. How do I get a list of tables contained in my Microsoft Access database?
Q. How can I create tables with SQL in ColdFusion?
Q. How does ColdFusion connect to databases?
Q. How do I delete the Access lockfile?
Q. How do I insert a date into my Access database?
Q. Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine?
Q. How do you upsize a FoxPro database to MS SQL or Oracle?
Q. How i could insert a file as binary code?
Q. Is there any way that CF will return a list of datasources?

<<< Back to Category Listing

©2001 MaxFusion  Updated: 04/06/04

 Powered by ColdFusion