Well, if you've determined that the query runs fine, then the problem is with the
output. I would double check your theory by running the query directly in the
database. Use iSQL/w on SQL or an Access query, or whatever just to make sure the
results are coming out correctly.
If the query is in fact good, check your output statements, clear your browser's
cache, and try accessing it from another computer.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Jill Cooney [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 29, 2000 11:14 AM
> To: '[EMAIL PROTECTED]'
> Subject: SQL: order by question
>
>
> I have a library database which I order by Book Title in order to
> present an alphabetical list. However, when a new book is added which has
> the same first word as another title (for example, "Managing
> Databases" and
> "Managing Offices"), only "Managing Databases" will appear in the
> list. If I
> turn on debugging, I know the second Managing title is being
> selected, just
> not "outputted".
> Does anyone know of a workaround? Thanks.
>
> Jill Cooney
> Webmaster
> Dataware Technologies
> http://www.dataware.com
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.