I'm trying to change the logic the ASP applies to each row. For example, the ASP output now is:
while not EOF...
3 rows joined on ID 1
4 rows joined on ID 2
3 rows joined on ID 3
5 rows joined on ID 4
.. and son on..
I just want to display the first row for each unique ID.
I want to output a standard joined table recordset and group rows on a unique id field (specified 1st in Order By). Just like a query for a forum thread with responses would return multple rows. (SELECT TOP or DISTINCT doesn't work).
I'm new to ASP, but in CF it's as simple as:
<cfoutput...
Thanks. I do want to show future dates, but time is not important. So I use the standard order by date to get the output shown below, but I have empty/null value fields, so it looks like this
FIELD NAME
| |
| |
| |
| |
| |
|11/16/2004|...
I was able to convert the field to datetime, but the order by duedate brings future dates to the top - is there a way to alter the clause so that it brings dates closest to now() to the top? I now this may be tricky this there are past and furture date records.
I need resulkts to Order by date, now() DESC. Just like if you sorted by date in a windows explorer GUI. Simply Order by date doesn't do this - anyone know how?
Thanks
I have dynamically created courses and their schedule on a form page which I verified submit fine to an action page. My only problem is I can't get the action page to detect a time match (schedule conflict). Any ideas?
<!---form page--->
<INPUT TYPE="Checkbox"...
Thanks - the reason I want to do create the additional auto-incremeted field to generate random integer or varchar fields which will serve as passwords. This may sound somewhat clugy, but seems to be the quickest/easiest way to assign simple passwords to 100+ records. So I can't really use the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.