I have some code that will take a .MDB file from the client upload it to
a directory and create a data source within ColdFusion.
My problem is I have to find the first table within that database. I
have tried the below query but keep getting a database error.
<cfquery datasource="myDatasource" name="GetTables">
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Flags = 0
AND MSysObjects.Type = 1
ORDER BY MSysObjects.Name
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324042
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
