Webmaster Forum / ColdFusion / Database Access / September 2004

I have a very very weird situation here that I am unable to find a resolution
to.
I am running CFMX 6.1 with a MySQL server.  I have an application that needs
to allow spanish name and address information to be stored.  The data entry

I am trying to do a loop of UPDATEs (to an Access database), and I'm getting
the very unhelpful ColdFusion error of "Syntax error in UPDATE statement" at
the line where my query is.  Can you tell me what's wrong with this bit of code?
If I replace the <cfquery> tags with ...

can anyone tell me what's wrong with my code?
---------------------------------------------------------------
Data type mismatch in criteria expression.
---------------------------------------------------------------

Time to time I see that   ColdFusion MX ODBC Service hangs and couldn't be
just simply stopped -  I have to kill swsoc.exe process.  Does anybody  have
any idea on how to debug such a situation ?
PS.

I have a table named Products, and a column in it named
ExperEmailList.
For example,
productID expertemaillist

This simple query works in local but on the server it return an error "required
2 parameters".
<cfquery name="qGetUserName" datasource="#db#">
   SELECT Company,

Any one know how to get the last inserted record number in access 2000.
In database table I have a column called UN number which is automatically
generated by access.
My statement is as follow:

     I have a column which is datatime datatype in SQL Server. I am inserting
the articles with the time of adding the article into the database.
In the database the data is storing in this format  9/30/2004 1:30:00 PM
I am interested to find the articles added in the last 2 hrs ...

I am trying to create a query:
<cfquery name="Recordset1" datasource="HRCITest">
SELECT firstname, lastname, procode, id-047exam
FROM aotcbexam

Does anyone know if it is possible to get user information from Active
Directory to be used by coldfusion? I want to have real-time information as the
site is going to list all staff in the company with their relavent details.
Thank You

I just bought this manual so that I could begin learning coldfusion mx.
However im running into some struggles with getting everything set up to
begin the tutorials since im using a Mac running OSX 10.1.5, ColdFusion MX
6.1 / Jrun.

I created a data source with CFMX running on my local machine, while the
database (MySQL) and web servers run on machines elsewhere (for dev.
purposes I could use the local web server). It has been verified as "ok".
But then I don¹t have nay of the tables from that source showing in ...

ok...here goes....
made a cfquery to pull info out of an mdb.
going to display that info on a page, but I want to put that info into a
dropdown box with other info from a table.

I want to generate a report that takes the DISTINCT values from one tables and
use those values to loop through another query to get the sum of all the
records.
Example:

I have a column named 'language' with lists of languages names like this :
Egyptian,Niger-Kordofanian,Amharic,Tigrinya,Sinhalese,Afrikaans,Temen
<cfset myvar = "amharic">
<cfquery name="qGetRates" datasource="#db#">