I was wondering if there is an easier way of doing this?
Sure there is - by doing it natively in SQL and PHP, which means you must hand-craft code (or at least modify an existing example). That's way beyond what DW can provide with its standard recordset stuff and if you have no clue, then leave it be and hire someone who really understands PHP/ SQL before making a mess...
Thank you for the input. I concluded that DW4 wasn’t capable of providing that degree of sorting, but, I wanted to be sure, so I posed the question.
I’m familiar with SQL and I am currently learning Java, so, somewhere in the future I will be able to do it myself. However, I will have to hire someone to get this functionality operational now because I have a timeline to meet.
Thanks for your help. This issue is resolved.
Anyhow, you can pretty easily do what you want in just server-scripting and SQL.
When you click on a letter, you can pass that letter to the script as a url variable. Then the script can select all records that are LIKE the letter plus a wildcard, e.g.,
SELECT * FROM whatever WHERE record LIKE 'A%' (assuming 'A' is the letter you clicked).
Would that work?
that would work, however, based on future projections, the ultimate goal will be
to have a database search capability that independently search the database
based on 3 criteria, bizz name, state and city. By submitting one or all
criteria, the table will display the results. This will narrow the window down
to an acceptable number such that the table will not require many "next" clicks
to see all the listings based on the search criteria.
I will have to either learn myself or pay someone. Time is my factor. The
response that you provided will last 6 months at best.
My intentions is to learn Java and Java Script, eventually.
Be Successful Every Day
BATISTE TECHNICAL SERVICES LLC
P.O. Box 1418
Jacksonville N.C. 28540-1418