Order By Problems

I have a select field populated by a field within the table of an access
database. I can't seem to have the results alphabetized. Any helpful
insight, anyone?
The table is called jobtitles and the field is jobtitle.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.mappath("jobpostings.mdb")

Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open ("SELECT jobtitles.jobtitle FROM jobtitles ORDER BY
jobtitles.jobtitle;"), Conn

Rs.MoveFirst

Response.Write("

Re: Order By Problems

What happens instead? Are you saying that the job titles are not coming
back alphabetized? Can you post a list of the job titles in the order that
they're coming back?

Ray at work


"Jim in Arizona" wrote in message
news:ejSrm664EHA.1292@TK2MSFTNGP10.phx.gbl...
> I have a select field populated by a field within the table of an access
> database. I can't seem to have the results alphabetized. Any helpful
> insight, anyone?
> The table is called jobtitles and the field is jobtitle.
>
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> server.mappath("jobpostings.mdb")
>
> Set RS = Server.CreateObject("ADODB.Recordset")
> RS.Open ("SELECT jobtitles.jobtitle FROM jobtitles ORDER BY
> jobtitles.jobtitle;"), Conn
>
> Rs.MoveFirst
>
> Response.Write("

Re: Order By Problems

I can't see the problem. Maybe ; at end of Sql. This access, not ADO i
suppose.

And why are you using a Recordset Object?

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.mappath("jobpostings.mdb")
Set Rs=Conn.Execute "SELECT jobtitles.jobtitle FROM jobtitles ORDER BY
jobtitles.jobtitle"

Response.Write("

Re: Order By Problems

Sorry Ray and all.

I was missaving my document! Ooops.

To my astonishment, when I saved over the proper document that I'm viewing
on my webserver, I get the proper results!

Thanks,
Jim





"Ray Costanzo [MVP]" wrote in
message news:eAafr$64EHA.2568@TK2MSFTNGP11.phx.gbl...
> What happens instead? Are you saying that the job titles are not coming
> back alphabetized? Can you post a list of the job titles in the order
> that
> they're coming back?
>
> Ray at work
>
>
> "Jim in Arizona" wrote in message
> news:ejSrm664EHA.1292@TK2MSFTNGP10.phx.gbl...
>> I have a select field populated by a field within the table of an access
>> database. I can't seem to have the results alphabetized. Any helpful
>> insight, anyone?
>> The table is called jobtitles and the field is jobtitle.
>>
>> <%
>> Set Conn = Server.CreateObject("ADODB.Connection")
>> Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
>> server.mappath("jobpostings.mdb")
>>
>> Set RS = Server.CreateObject("ADODB.Recordset")
>> RS.Open ("SELECT jobtitles.jobtitle FROM jobtitles ORDER BY
>> jobtitles.jobtitle;"), Conn
>>
>> Rs.MoveFirst
>>
>> Response.Write("

Re: Order By Problems

Thanks Gerard. My next question was going to be on how to properly destroy
the objects.

You asked me why I'm using a Recordset Object. The answer to that is pretty
simple: I'm still new to all this and don't know what I'm doing yet. :)
Makes me glad this NG exists!

Thanks,
Jim

"Gérard Leclercq" wrote in message
news:qDmwd.2262$Fe4.103526@phobos.telenet-ops.be...
>I can't see the problem. Maybe ; at end of Sql. This access, not ADO i
>suppose.
>
> And why are you using a Recordset Object?
>
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> server.mappath("jobpostings.mdb")
> Set Rs=Conn.Execute "SELECT jobtitles.jobtitle FROM jobtitles ORDER BY
> jobtitles.jobtitle"
>
> Response.Write("

Re: Order By Problems

Welcome to the club. Why not recordset? Read more on www.aspFaq.com, see
http://www.aspfaq.com/2191