I have a query that I run:
<cfquery name="getshoworder" datasource="intranet">
select * from showorder
</cfquery>
and
<cfquery name="getshoworder" datasource="intranet">
select * from showorder_#form.show# order by id
</cfquery>
Knowing that the "order by id" is in the order that the data exists in
the table, why does the first query mix things up?
- Matt Small
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
