Webmaster Forum / ColdFusion / Database Access / April 2007

Hi, my name is Andy and I know just enough about web design & server-side,
client-side stuff to get very frustraited.
I don't need anything too fancy (at least at first). I dont need the client to
write to the database and I don't need the data base to change.

I'm getting the following message when I try to insert data into a single table
using the <cfinsert> tag
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native
Client][SQL Server]Cannot insert explicit value for identity column in table

In order to track page hits, we use a component that writes a line to a
database. It is simple - it just records the time, the page name, the ip
address, and the user id if they are logged in.
If I want to record clicks on a mailto link, is there any way to do this

This is probably a stupid question...  A client of mine is going to upgrade
from MS Access to sql server.  If he decides to use sql server 2005, can I
still work with it even though I only have sql server 2000?  Are there any
major differences between the two applications that ...

I'm using the latest version of ColdFusionMX7 and MS SQL 2000 version 8.0.  I
have set it up on one computer just fine.  I want another instalation to work
on so I installed the same software again.  Everything looks OK but when I try
to make a connection to any SQL database I ...

I am trying to figure out how i can get the number of records that are updated
in mysql. The query_name.recordcount apparently doesn't work with mysql. This
is what i tried:
<cfquery name="UpdateData" datasource="Source">

We are evaluating switching for MySQL4.0.x (native support via CF) to
MySQL5.0.x (support via JDBC ConnectorJ) and we are having some character set
issues with on our evaluation server. When we had it configured with MySQL4.0.x
using the built in MySQL driver we always used the ...

If I would like to encrypt the data passing between SQL Server database server and CF application server what are the ways to achieve that?
Thanks
Rk

Unable to update the NT registry.
Variable DRIVERPATH is undefined.
It see's the Database & I still get the Error message above....Can anyone help???

I'm trying to run a query that looks something like this
<cfquery name="test" datasource = "ds1">
SELECT *
FROM tblTest

Please pardon my lack of good terminology as I am still very novice at this
whole SQL/ CF thing.
Dumb question #1: Now that I have upgraded my db from access.mdb to SQL 2007,
do I still edit/ build my db with Access 2007 (.accdb) or do I use SQL which

Hello~
   I am having trouble with a join query pulling out specific information from
two other queries. I have the three queries involved and then the <cfoutput>
area that shows up on the web page. The point it, I have two tables in my

Looks like the marketing vs. technical papers disagree on this, or at least
muddy the waters.  Is there a driver to connect to MS Access on a Solaris
Enterprise instance of CF mx 7?
We have a legacy Access DB that we'd like to query and run reports from in CF.

ok in my application.cfc I have
<cffunction name="onApplicationStart">
<cfset Application.Max_Number_Attempts =3>
cffunction name="onSessionStart">

I have a form that users enter about 30 pieces of data into.  That data is then
inserted to or updated in the database.  This action is followed by a number of
cfmodule templates that pull specific datapoints from the ones just
inserted/updated, run a calculation (either in CF or ...