Sorry about the last message-it was formated
Hi
If I have a form and post a value - say <cfinput name="domain"
required="yes" message=" Please enter FQDN"> to a receiving page with a
query as:
<cfquery name="get_handle" datasource="testds">
select handle, domain, tld
from domains
WHERE domain='#form.domain#'
</cfquery>
This works however the domain in the form is actually both the value in the
databae "domain" and "tld"
so if I was to search hotchilli that would be fine - but I post the FQDN so
"hotchilli.com" so I would need something like this:
<cfquery name="get_handle" datasource="testds">
select handle, domain, tld
from domains
WHERE domain AND tld='#form.domain#'
</cfquery>
WHERE domain AND tld='#form.domain#'
Anyone have a solution to the above clause.
Any ideas
Thanks
Tony
Hotchilli Internet Solutons
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
