Wayne,

Thank you for the response....

I have both the webserver and the server sitting next to my feet.

So what you are saying, if I give the com object access to the server, then I should be able to write any vfp sql statements?

Would you happen to know of any books or articles I can read to look into this? I'm concerned with security, network rights etc...

Robert

>The problem is really only if you have control over the web server or not. If you can install the com object on the machine, you can do what you want.
>
>
>>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