I need to access a VFP 8.0 database and table from Coldfusion.
I want to do this through com automation.

1) IS THE FOLLOWING POSSIBLE?
2) IF the answer to 1 is yes, then can anyone recommend a good book on this?

DEFINE CLASS test AS CUSTOM OLEPUBLIC
function init
open database \\my_network\my_share\mydbc.dbc
endfunc

PROCEDURE getCity( tcID as Integer )
local lcCity as String
lcCity=''

select 0
use myDBC!address order id
if seek(tcID)
lcCity=alltrim(address.address
endif
use in address
return (lcCity)
ENDPROC
ENDDEFINE