CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Sort by two fields

Print topic Send  topic

Author Message
Brian Gubb
Posted: 05/30/2002, 7:58 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0070_01C2084F.ECB94A80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm brand new at this but a fat learner.

Can someone show me what SQL code I need to be about to sort by two =
fields?

Your help is much appreciated.

Brian

------=_NextPart_000_0070_01C2084F.ECB94A80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I'm brand new at this but a fat =
learner.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Can someone show me what SQL code I need to be about =
to sort=20
by two fields?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Your help is much appreciated.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>

------=_NextPart_000_0070_01C2084F.ECB94A80--
Brian Gubb
Posted: 05/30/2002, 7:59 AM

This is a multi-part message in MIME format.

------=_NextPart_000_007C_01C20850.1318E640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

OPPS typo, fast learner :-)
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad5en6$qgk$1@news.codecharge.com...
I'm brand new at this but a fat learner.

Can someone show me what SQL code I need to be about to sort by two =
fields?

Your help is much appreciated.

Brian

------=_NextPart_000_007C_01C20850.1318E640
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>OPPS typo, fast learner :-)</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ad5en6$qgk$1@news.codecharge.com">news:ad5en6$qgk$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>I'm brand new at this but a fat =
learner.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Can someone show me what SQL code I need to be =
about to sort=20
by two fields?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Your help is much appreciated.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_007C_01C20850.1318E640--
Sixto Luis Santos
Posted: 05/30/2002, 12:58 PM


select * from table ORDER BY FIELD1, FIELD2

"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:ad5en6$qgk$1@news.codecharge.com...
I'm brand new at this but a fat learner.

Can someone show me what SQL code I need to be about to sort by two fields?

Your help is much appreciated.

Brian


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.