having problems with this code:

[AlexUK]

having problems with this code:


<CFQUERY DATASOURCE=&quot;#Application.dsn#&quot; NAME=&quot;EmpQuery&quot;>
SELECT RepID,Email,Name FROM WimpReps WHERE Name='#Form.Recipient#'
</CFQUERY>

query returns an access ODBC error - data mismatch

we have checked the fields - all text fields except RepID (number)

what is going wrong?

p.s. code works fine with postgres but not access

 

[Ekrami]

I think that the problem in &quot;#Application.dsn#&quot;. Try to make an ODBC from Windows control-panel, so your code may look like this:
-----------------------------------------------------
- <CFQUERY DATASOURCE=&quot;MyDSN&quot; NAME=&quot;EmpQuery&quot;> -
- Select RepID, Email, Name From WimpReps -
- Where Name='#Form.Recipient#' -
- </CFQUERY> -
-----------------------------------------------------

Or the version of your Access ODBC is old.

That all I have right now ... Bye.