Webmaster Forum / ColdFusion / Database Access / February 2008

I'm a noob so please let me know if this comment should be posted elsewhere...
I creating a form to submit data to a MS database (using Ben Forta CFMX7 web
app const. kit for reference).  What I don't understand is the whole foreign
key thing.  If I'm populating form field data ...

I'm using MS Access for my database.  My table = TempTable has a Primary Key =
ID.  I need to change the Primary Key to incorporate these fields (Weeks, UPC,
TimePeriod).  I've tried using something like this, but it isn't working:
Any thoughts on how to change this would be ...

Hey guys
I'm sure some of you have gotten in this situation before. Unfortunately I do
not have the experience in CF to know how to do this myself. Basically I'm
updating a clients webpage where the webmaster left (quit? who knows) And it is

CF7 Standard. We've created 2 similar codebases on one server under virtual
domains. We have 2 sets of tables (1 for each ) but different names and PWs. We
can see that CF connects to all tables. It appears that when 1 subdomain
connects to it's data sources, it affects how the ...

This is much more a SQL Server question than a ColdFusion question- but I'm
not using Transact SQL, so the SQL Server resources aren't really telling me
anything I need to know.
I'm using FREETEXT for full-text searching on SQL Server 2000.  (CF8 on

Hi there, can anyone give me some help with connecting to a DB in MS SQL
Server? i'm trying to connect via the cfadmin but i keep getting the following
error when verfiying the DB connection:
Connection verification failed for data source: sitedirector

I'm wonder that can I make this.
I'd like to design a form like Purchase Order sample from LifeCycle Designer.
And want to submit it like a POST method to a ColdFusion backend. Think like a
HTML form submission.

Hi, I have a query that is pulling a field called "Total" from 20 different
tables (Week1 - Week20). When I try to output the results as #Week1.Total#, for
example, I get an error saying that Total is not defined in Week1. I also tried
totalHours.Week1.Total (totalHours is the ...

Derby rejects the attached code, saying that it "Encountered '1' at line 1,
column 12".  I haven't renamed my index (and I don't really want to mess with
it at this level, as I consider it a more advanced concept), so what is the
default prefix for the number (or am I thinking ...

I'm trying to find a way to know the record count of a whole table without
querying it.
I have a legacy DBF table with roughly 1,000,000 rows and a simple query is
very time and resources intensive but I need to frequently know the number of

Ok, so I have an SQL Server 2000 database, and a table which has PDF files
stored in it in IMAGE fields. I need to be able to put a link on a CFM page
which allows a user to download the contents of the image field - those PDF
files. I've attempted a similar solution to the one ...

Actually I am upgrading my system from coldfusion 4.5 to coldfusion 8. As
database it is same for both Oracle 8.
The same insertion statement is working in cold fusion 4.5 but showing error
while working with coldfusion 8. It is showing error missing right parantheses.

Hi, I am trying to write a delete query in Access, but not sure where to start.
I have two tables, request and week1, that share a field, "id".
I want to keep all of the records in request, but delete any records in week1
that do not have an id that is also present in request.

I have 3 related tables named
NAMEINFOF
FUNCTIONSF
RESTAURANTF

I need some help with the code to import data from one table into another if it
is not a duplicate or if a record has changed.
I have 2 tables, Members and NetNews. I want to check NetNews and import
non-duplicate records from Members into NetNews and update an email address in