| From: | edbrown@go-britain.com (Ed Brown) |
| Newsgroups: | macromedia.ultradev |
| Subject: | Is there a FAQ on Numeric wildcards with Coldfusion adn Ultradev |
| Date: | Thu, 21 Jun 2001 23:27:21 GMT |
| Organization: | Go Britain Ltd |
| Lines: | 35 |
| Distribution: | macromedia |
| Message-ID: | <3b328074.55521546@forums.macromedia.com> |
| Reply-To: | edbrown@go-britain.com |
| NNTP-Posting-Host: | modem-195.ekto.dialup.pol.co.uk |
| X-Trace: | forums.macromedia.com 993165665 1916 62.137.160.195 (21 Jun 2001 23:21:05 GMT) |
| X-Complaints-To: | support@macromedia.com |
| NNTP-Posting-Date: | Thu, 21 Jun 2001 23:21:05 +0000 (UTC) |
| X-Newsreader: | Forte Free Agent 1.21/32.243 |
| Path: | news2.ip-mobilphone.net ! news.planetc.com ! newsfeed2.skycache.com ! Cidera ! newsfeed1.cidera.com ! newsfeed.cwix.com ! mvb.saic.com ! misc.macromedia.com ! not-for-mail |
| Xref: | news2.ip-mobilphone.net macromedia.ultradev:30185 |
All,
I've searched the Ultradev web pages and the Coldfusion web ages and
come up with an answer to the basic query about numeric wildcards in
searches which seems to be to omit the quotes around the % sign for
numeric searches. However I can't discover how to do this in UltraDev.
In the record set I have an SQL statement of:
SELECT ActivityID, ActDelMethID1, ActDelMethID2, ActAddGeninfo,
ActAddSpecInfo, LocAuthAreaID
FROM CourseTypes
WHERE LocAuthAreaID like Localarea
ORDER BY ActDelMethID1 ASC
Variable of Localarea has a default value of 1 and run time value of
#GeogOpt# which is the value passed from the form.
On the form I have a drop down box defined as follows:
<select name="GeogOpt" size="1">
<option value="%">All</option>
<cfloop query="ILEGeog">
<option
value="<cfoutput>#ILEGeog.LocAuthAreaID#</cfoutput>"><cfoutput>#ILEGeog.LocaAuthArea#</cfoutput></option>
</cfloop>
</select>
The form is populated from a table and if I select any value except
"All" it works as expected.
Any pointers to a resolution would be apprecaited.
Ed Brown
www.go-britain.com
All about Britain