[thelist] Coldfusion & MS Access SQL Resource Wanted

[rudy]

> I am after a comprehensive resource that covers what SQL is valid in
> MS Access and how it's syntax works with Coldfusion.

hi michael

try the Help file -- seriously, it's often a huge pain in the ass when
you're after some specific sql syntax and you keep getting these ridiculous
VB coding examples, but the Help file is often extremely, um, helpful and
has some really nice pages, e.g. the ones that describe functions

you might also try http://www.mvps.org/access/ which is for access
programmers (so there's a lot of stuff about modules and forms and so on
that you have to skip over)

as for how access syntax works with coldfusion, well, it fits into the
<cfquery>...</cfquery> tags just like any other database's sql

;o)


rudy