platform independant tools in the onTap framework. They're not on the
public site yet, but they're in the download. Unfortunately there's
nothing (at least yet) to handle the fact that function names vary
between databases, but it lets you do outer-joins without worrying
whether it's MS or Oracle, and I _think_ I managed to do something
similar with Concatenate -- iirc it replaces || with + in the select
list if you're not using Oracle. You can't go the other way with that
one, because + is also used for math, so could end up trying to
concatenate numbers using Oracle that way. It's also got better
replacements for cfinsert and cfupdate.
In any event, I've managed to add support for MySQL and finally for
Oracle. No support for PostgreSQL yet... I don't have a *nix machine
to work with.
s. isaac dealey 214-823-9345
team macromedia volunteer http://www.macromedia.com/go/team
chief architect, tapestry cms http://products.turnkey.to
onTap is open source http://www.turnkey.to/ontap
> Is there a syntax that you can pass to a MS Access Db to
> get a list of column names for a particular table?
> Thanks
> Paul Giesenhagen
> QuillDesign
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
