Webmaster Forum / ColdFusion / Database Access / December 2005

Hello, I am again having trouble getting an "INSERT INTO" cfquery working. It
says "syntax error, but I can't see what I've done wrong. First, I'm starting
out with a simple query that is used by a land surveying company to file and
retrieve maps. The datasource is a simple ...

Hi there,
 I'm trying to connect to an Access database through Dreamweaver.  My hosting
is on a shared server and so they won't give me access to the RDS.  I set up
the DSN through the ISP and they even registered it for me in cfadmin. Now how

I have a value sent from paypal that I am trying to insert into an existing
database.
I am trying to call up the data, from the existing database, by the email
address that is sent  from Paypal,  then update the table with a subscr_id.

I want to setup free envornment within microsoft access in permission and
security, because I can retrive data for display but I have error when I try to
insert/update/.
 Error Executing Database Query.

I have two text files that I am using a cfhttp tag to query. I then need to
combined the two queries to one query subtracting the "CHANGE" field from the
second query from the "CHANGE" field in the first query. I will then use the
combined  query to create a new file. I can make ...

I am looking to get the ID of the last inserted record in an msaccess db.  I
know in sql server you can select @identity or @@identity - but this doesnt
work in msaccess.
any help would be greatly apprecitated.

I've deployed CFMX 7.01 on WebSphere ND 5.1.1.8 running on a Windows 2000
server and on The admin data source configuration the JNDI driver option is not
in the drop-down.  Is there something I have to do to make this option
available.

I'm trying to do the following in one single cfquery call.  However, I'm having
trouble referencing "memberCount" in the Insert part of the statement.  It
keeps saying invalid column name "memberCount".
How would I reference it correctly?  Thanks.

I have an application that needs to query a number of tables that reside on two
different servers so I'm using Q of Q but the problem is I need to do a LEFT
OUTER JOIN in the Q of Q to get the results I need.  The is for a scheduler
which displays 12 time slots where appointments ...

I have a search page that searches a database table of technical articles on a
computer support site.  In the table, there are bit columns for HotTopic and
ET.  When adding an article, the technician sets ET=1 and/or Hottopic=1.  
Currently the search outputs the all of the ...

I have been trying to use CF Administrator to  connect to an SQL Server 2000
DB.  I keep recieveing the message below.  I have read on other posts that I
need to create a user in SQL for the CF Adminstrator however I don't  know how
to create that user.  Can anyone give me some ...

When I write a SQL call in TOAD, it takes lapprox 4 seconds to run.. but when I put it in my CF page, it takes over 20 minutes.  
That shouldn't be, should it?

I have populated a dependent two select drop down menu without any trouble
Im not at all sure on the Sql for the next step however.
the drop down menu is Area  (group) which populates Language (subgroup)
<cfquery name="get_Main_Group" datasource="dependent">

I have 2 tables in MS acess for my web application tdldecedent and
tblcircumstances with common field name Case number.
When the user will log into my web application it will go to my front page of
my application.It will carry information of tbldecedent table.I have created

how to set the referential integrity between 2 tables using enterprise manager (microsoft SQL SERVER)..  i tried and the tab doesn't allow me to choose. pls.help.
thanks
sree