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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: order by question - DOH!
In pasting the code into my reply, I realized I'd had a "group=" in my cfoutput -- once I took this out, the list displays fine. Thanks for the push! -- Jill -Original Message- From: Dana Larose [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 12:30 PM To: [EMAIL PROTECTED] Subject: Re: order by question Could we see a the code for your query and/or cfoutput? What you are describing should work fine, so it is probably a little typo or something. -Original Message----- From: Jill Cooney [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, June 29, 2000 2:18 PM 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=listsbody=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?sidebar=listsbody=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?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help With CFMAIL using 4.5.1
I ran into the same problem after upgrading to 4.5 and was able to
fix it after looking at the following Knowledge Base article:
http://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full. It turned
out to be a permissions problem so I didn't need to install the patch.
Hope this helps.
Jill Cooney
Webmaster
Dataware Technologies
http://www.dataware.com
-Original Message-
From: Double Down, Inc [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 10:24 AM
To: [EMAIL PROTECTED]
Subject: Help With CFMAIL using 4.5.1
This is a multi-part message in MIME format.
--=_NextPart_000__01BFC17C.486D6EA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
I am trying to run a mail script that has worked in 4.0.1 When I try to run
it in 4.5.1 I get the following error
unknown exception condition
TagCFMail::sendMessage
The error occurred while processing an element with a general identifier of
(CFMAIL), occupying document position (9:1) to (9:97).
Any ideas how I can get this to work?
TIA
DDINC
--=_NextPart_000__01BFC17C.486D6EA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
p
{margin-right:0in;
mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3DArialspan =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'I am trying to run a mail script that has worked in 4.0.1 When I =
try to
run it in 4.5.1 I get the following =
erroro:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3DArialspan =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
pfont size=3D3 color=3Dblack face=3D"Times New Roman"span =
style=3D'font-size:12.0pt;
color:black'unknown exception condition /span/fontfont =
color=3Dblackspan
style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
/p
pfont size=3D3 color=3Dblack face=3D"Times New Roman"span =
style=3D'font-size:12.0pt;
color:black'TagCFMail::sendMessage /span/fontfont =
color=3Dblackspan
style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
/p
pfont size=3D3 color=3Dblack face=3D"Times New Roman"span =
style=3D'font-size:12.0pt;
color:black'The error occurred while processing an element with a =
general
identifier of (CFMAIL), occupying document position (9:1) to =
(9:97)./span/fontfont
color=3Dblackspan =
style=3D'color:black;mso-color-alt:windowtext'o:p/o:p/span/font=
