Hi,
Is there a way to do the following with a query. I'm running CF and MySQL. I want to
display from the field "strSelect" when I get a match on "d:\test" only even though
the
field could contain "d:\mywork" and "d:\documents" Presently I'm displaying
*everything* from the strSelect field.
Here is my query:
<cfquery name="ListElement" datasource="database" dbtype="ODBC">
SELECT *
FROM profiles
WHERE strUsername = '#auth#'
</cfquery>
Can I do something like:
<cfquery name="ListElement" datasource="database" dbtype="ODBC">
SELECT *
FROM profiles
WHERE strUsername = '#auth#'
AND
WHERE strSelect = 'D:\test'
</cfquery>
The idea here is to match/list only the occurences with "d:\test" in the field?
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
