This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C046BB.86149B60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
If I have a form and post a value - say <cfinput name=3D"domain" =
required=3D"yes" message=3D" Please enter FQDN"> to a receiving page =
with a query as:
<cfquery name=3D"get_handle" datasource=3D"testds">
select handle, domain, tld
from domains
WHERE domain=3D'#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=3D"get_handle" datasource=3D"testds">
select handle, domain, tld
from domains
WHERE domain AND tld=3D'#form.domain#'
</cfquery>
WHERE domain AND tld=3D'#form.domain#'
Anyone have a solution to the above clause.
Any ideas
Thanks
Tony
Hotchilli Internet Solutons
------=_NextPart_000_0010_01C046BB.86149B60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Hi</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>If I have a form and post a value - =
say=20
<cfinput name=3D"domain" required=3D"yes" =
message=3D"=20
Please enter FQDN"> to a receiving page with a query =
as:</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2><cfquery =
name=3D"get_handle"=20
datasource=3D"testds"><BR>select handle, domain, =
tld<BR>from=20
domains<BR>WHERE =
domain=3D'#form.domain#'<BR></cfquery></FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>This works however the domain in the =
form is=20
actually both the value in the databae "domain" and=20
"tld"</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>so if I was to search hotchilli that =
would be=20
fine - but I post the FQDN so "hotchilli.com" so I would need=20
something like this:</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV>
<DIV><FONT color=3D#000000 size=3D2><cfquery =
name=3D"get_handle"=20
datasource=3D"testds"><BR>select handle, domain, =
tld<BR>from=20
domains<BR>WHERE <STRONG>domain AND=20
tld</STRONG>=3D'#form.domain#'<BR></cfquery></FONT></DIV></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV>WHERE <STRONG>domain AND tld</STRONG>=3D'#form.domain#'</DIV>
<DIV><FONT color=3D#000000 size=3D2>Anyone have a solution to the above=20
clause.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Any ideas</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2><BR>Tony</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Hotchilli Internet=20
Solutons</FONT></DIV></BODY></HTML>
------=_NextPart_000_0010_01C046BB.86149B60--
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]