I'd like to ask a previous question in a different manner as it was
suggested to me the way I originally phrased it wasn't clear.
I'd like to use a rand() in a CFQUERY but get an error each and every
time (is it even possible?). The Access database is being accessed
through OLE if it matters. I want to do something like:
select groupname, groupentry1, groupentry2, rand() as randcol
from inventory
order by randcol , groupname, groupentry1 DESC, groupentry2 DESC
or perhaps?
select rand(groupname) as randgroup, groupentry1, groupentry2
from inventory
order by randgroup, groupentry1 DESC, groupentry2 DESC
Right now I always get something like this (not random...each group
output alphabetically)
row1:Group A
row2: a-1
row3: a-2
row4: a-3
row5: Group B
row6: b-1
row7: b-2
row8: b-3
row9: Group C
row10: c-1
row11: c-2
row12: c-3
I want the CFQUERY to randomize the groups, A, B, C; B C A, etc...
so I can get:
row1: Group B
row2: b-1
row3: b-2
row4: b-3
row5: Group C
row6: c-1
row7: c-2
row8: c-3
row9:Group A
row10: a-1
row11: a-2
row12: a-3
I want it like this because this information is displayed over
multiple pages and I pass the row number between the pages with a
Next and Previous button.
I hope this is clearer.
Thank you,
Randy M. Zeitman
--
**This signature sponsored by GuitarList.com - the most powerful
musical instrument search engine on the net!**
"I've gotten so out of shape sittin' at the computer all day that I
get out of breath when I have to reach for the percent key!" -
Zeitman
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
