re: Querying a query getting an error?

2003-11-28 Thread Bushy
Hi, I'm trying to get the proper order of the directories. Bascially don't list the directories/files as case sensitive. I'm running the following query: SELECT IsDirectory, Name FROM RootFiles ORDER BY IsDirectrory DESC, Name #name# The code above will run but when I add this line I g

RE: Querying a Query

2000-10-25 Thread Hayes, David
How about some code? I'm curious about both the PN and SN fields being used to link tables 1 and 3. -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 12:30 PM To: CF-Talk Subject: Querying a Query I have a very strange situation that me