Webmaster Forum / ColdFusion / Database Access / November 2005

If you read the detailed system support matrix for CFMX 7, it is very clear
that any flavor of Oracle is not "supported" under the Standard edition of the
product.  There is only "support" for Oracle in CFMX 7 Enterprise.
Can anyone convey the authoritative definition of what ...

results, please help me befor my boss gives me a spanking! Here are my pages
search.cfm and searchresult.cfm, please tell me where i went wrong and i'll
give you a big kiss!

HI guys, getting pretty stressed with this haha! it's probably something
simple...right I have this registration form that does multiple checks
(existing username, email address, over 18 yrs of age etc) before writing the
data into the database. now a couple of weeks ago this ...

After users change their passwords, fcqueries accept the old passwords.  Old
passwords are rejected after rebooting or timing out.  MX6 does not do this.  
This only happens in MX7.  
Is accepting old passwords a new feature in version 7?  How can I turn it off?

I just go a new computer and so far I have done the following:
- activated IIS as part of XP Prof\
- installed Studio MX as well as the developer version of ColdFusion server
that comes on the same CD

I need to update a field in an Access database.  The numbe rneeds to have four
characters and increment by one. Currently I can update all of the fields with
my code.  However, I would like to update one field with one number and then
the next field with a new number increment by ...

This is the issue at hand, I have a relational database. Two of the tables are
in a relationship, I have a query that allows a person to search by students
and display all there service hours and the where they participated. Now,
here's where I'm having the problem. I want to ...

can anyone tell me, how to find out if a table in an MS Access DB exists?
Also, I'd like to find out, if certain columns exits if a table exists. Will
CREATE TABLE overwirte an existing table?
Thanks, Liglin

This little piece of code works locally and on my old host, but will generate
an error on my new host (all running CF 6.1)
<cfquery name="getused1" datasource="JetDB">
SELECT *

Does anyone know when Macromedia will be officially supporting MS SQL Server
2005 in ColdFusion?  We have been able to get it to work with the Microsoft
JDBC Driver BETA, but Microsoft does not support the use of the driver in a
production environment.

I have a website where members set up their own personal pages.  Recently, some
member pages are displaying the following error.  It happens to the same
members all the time but the majority of member pages do not have the same
problem.  Can someone please advise me what may be ...

have a list of symptoms - I want a user to be able to click on the
first letter of their symptom. Next a list of all the symptoms with
the corresponding letters are pulled from the database. Actually have
got a drop down (distinct) working for this but on the result page i get ...

Is it my imagination or does this time out quicker?
I am building a query that would retrieve specific documents from a FoxPro 6.1
table(*.dbf) I am selecting columns (fields) from two different, but related
tables. There are two different criteria to use in retrieving the ...

Just cant seem to get to the next step
Dans advice
If your database supports substrings, do this on the first page
select distinct substr(sympton, 1, 1) firstletter