Hopefully this will be easy.
I'm looking to do the following three tasks :
1. Loop through the alphabet, like this
<cfloop INDEX=X FROM='A' TO='Z'>
(but of course index doesn't do this)
2. Parse a letter/string as a parameter e.g.
<a href=filename.cfm?Initial='A'>link</a>
3. Parse an initial into an SQL statement
e.g.
<CFQUERY NAME="GetInit" DATASOURCE="CIS">
SELECT DISTINCT Sur
FROM Customer
WHERE Left(Sur,1) = '#Init#'
ORDER BY Sur
</CFQUERY>
... where Init is a single letter.
I'm puzzled that this query works in Access but not in CF.
Briefly, what I am trying to achieve is the following........
Generate a full alphabetic list, with links, leading to ...........
List of customer surnames starting with each letter, with links, leading
to .......
List of customers all of the same surname.
If anyone thinks I'm wildly offtrack, can you suggest a better approach ?
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
