[Resolved] Question

MantrA

heres my question. How do I make it so that when my page lists the database info, it lists 1 at the top and the last number at the bottom...

DeltaRho2K

Add "ORDER BY Scroll_Number ASC" to your query. Change this to the appropriate field name. The only trick is that I believe the field should be an integer type field (INT, TINYINT, etc...) I have seen some problems when using VARCHAR type fields... (but it may have been my coding😉)

MantrA

ok that sounds good, but im not sure Im entering it right. heres the query:

sqlQuery = "SELECT FROM " & strMyTable & " WHERE " & strMyKey & " ORDER BY " & mykey & " ASC " & "=" & lngRecord

thats what I tried. But it didn't work. Could you tell me where/how exactly to put it? =P

DeltaRho2K

Dang, I'm sorry, it didn't even dawn on me you were using ASP and not php... I believe the syntax is the same, but the ORDER BY clause would go at the end... Porbably something like this:

You will have to double check it, but the basic would be:

SELECT * FROM table_name WHERE field = value ORDER BY field

sqlQuery = "SELECT FROM " & strMyTable & " WHERE " & strMyKey & "=" & lngRecord " ORDER BY " & mykey & " ASC "

drag0n

What kind of DB are you using? Access?

MantrA

I put in exactly that and its the same =/

MantrA

yes, Im using Access

Im on a free account in Brinkster if it helps any =P

MantrA

heres the whole code if it helps:

http://www.4guysfromrolla.com/webtech/code/editor.asp.html

DeltaRho2K

Do yourself a favor, and generate a query within ACCESS, and then pull the query up in SQL view. This will help you to set up the query. (Sorry, I am on vacation and my parent's computer doesn't have ACCESS, so I can't test this out for you.)

Does your ASP editor have some sort of point and click in it whereby you can assign a SORT order? (Oh, wait, I think the command is "SORT BY" in ASP and not "ORDER BY"... now that I think about it)

MantrA

I dont use an editor, just notepad, maybe thats why im having so much trouble =P

planetsim

Heh.. one thats turned from the dark side to the good side for assitance...

May i suggest using EditPlus 2. It has syntax highlighting, not sure if its any good for ASP. Never really went full on with it.

scoppc

ASP huh?! Are we discussing ASP? Wow... great! haha... 🙂

Originally posted by DeltaRho2K

ORDER BY " & mykey & " ASC "

what's that for, I mean, right after the word ORDER. Anybody?

DeltaRho2K

Sorry, my bad. I was trying to rearrange the query Mantra had... OK, I double checked an old ASP script I wrote, and here is the basic syntax (just like php actually)

SELECT FROM table_name WHERE Field = Value ORDER BY Field

sqlQuery = "SELECT * FROM " _
                  & strMyTable _
                  & " WHERE " _
                  & strMyKey _
                  & "=" _
                  & lngRecord _
                  & " ORDER BY " _
                  & mykey _
                  & " ASC "

For example, here is how one of mine went:

$rsLOC = "SELECT * FROM location WHERE LocationID = " _
                & Request("LocationID") _
                & " ORDER BY LocationName ASC"

I hope something here is helpful to you.

MantrA

cool, it works now, thanks =)

DeltaRho2K

No problem, glad to have been able to help... (whew, cleared out some of the old ASP cobwebs... 😉)