coldfusion with paradox

[psteja2000]

I raised this q in corelaradox form, but was suggested to raise it here too..

I have a paradox table which has some images stored as a long binary field.

I used coldfusion and microsoft paradox driver to access the table. I am able to retrieve all the fields except for the long binary field. Looks like it is not recognizing the field at all.

I get the error like " too few parameters, expected n ".

Googling told me, you get that when you are typing the field names wrong. But I am not. Basically whenever I use the field name pertaining to the long binary field, I get this. So it is not recognizing that field.

What do I do???

regards,
Teja

 

[ecobb]

I would suggest trying to use cfqueryparam, although I don't think sqltype for binary.



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[psteja2000]

but how do I use it??
All I want to do is retrive the binary data. like..

select jpgimgae from tblimages where id=#id#


but the driver wouldn't even recognize a field named jpgimage.

 

[ecobb]

Sorry, I don't know what I was thinking! cfqueryparam wouldn't have anything to do with this. Oops! I've been sitting in front of the computer too long. I guess I was thinking about a Stored Procedure (cfprocparam) instead.

I really don't know what to try, I've never worked with paradox before. Sorry.




Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher