I doubt very much that you can do it in Access, at least not the same way.
I've never tried doing this fancy stuff in Access, so perhaps it is
possible.
Sorry,
Bob
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 7:05 PM
To: CF-Talk
Subject: Re: Query join problem
Bob,
> The second method is a really neat trick that you can use to sort of
emulate
> the behaviour of a cursor. You can use it to loop through the records in
a
> table, just using standard SQL select statements.
>
> This example works in SQL Server, I'm not sure how it would need to be
> changed to work with other RDBMS's. Here's the code:
<snip>
Thanks very much for the code - I've been going over and over it, but am not
fully understanding it. I'm using Access you see - if you have the time, or
if someone else does reading this, could you outline what is being done so
that I can interpret what I need to do for Access?
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
