problem with a simple cfquery insert

[gtbikerider]

I'm using the following code to insert into an Access db...

<cfquery datasource="dsn" name="subscribe">
INSERT INTO email_addresses
(listID,
emailaddress)
VALUES
('1',
'#Form.emailaddress#')
</cfquery>

But I get the error...

"Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed"

(ListID is a field of type "number" and emailaddress is type "text")

I get the same error on a local machine and a live server.

Any ideas what's wrong?

--
John

 

[r937]

if ListID is a numeric column, why are you trying to insert a string? try removing the single quotes

r937.com | rudy.ca