You might want a sample of getUSer.cfm - here ya go
<cfsilent>
<cfsetting enablecfoutputonly="No" showdebugoutput="No">
<!--- form.w is the value being sent from the ajax call --->
<!--- form.sf is the name of the select box being re-populated/
recreated --->
<cfquery name="getusr" datasource="#request.dsn#" >
select full_name, deptid, employeenumber
from people
where upper(full_name) like <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#ucase(form.w)#%">
order by upper(full_name)
</cfquery>
</cfsilent>
<cfif getusr.recordcount gt 0>
<cfoutput><select name="#lcase(form.sf)#"
id="#lcase(form.sf)#"></
cfoutput>
<cfoutput query="getusr">
<cfif getusr.recordcount eq 1>
<option value="#employeenumber#"
selected>#full_name#
(#deptid#)</option>
<cfelse>
<option
value="#employeenumber#">#full_name# (#deptid#)</
option>
</cfif>
</cfoutput>
</select>
<cfelse>
<cfoutput><select name="#lcase(form.sf)#"
id="#lcase(form.sf)#"></
cfoutput>
<option value="">No Records Found</option>
</select>
</cfif>
On Jul 10, 2:59 pm, Eddie Pequeno <[EMAIL PROTECTED]> wrote:
> Does anybody know any sites with good refrences to AJAX?
>
> There is some built in Ajax functionallity with CF8 but I don't know if it's
> enough to do what I need. The cfajaxproxy looks quite promising though.
>
> Here's what I'm trying to do:
>
> I'm putting a lot of Company names in a drop down. The list will be enormous
> so instead of having all the names, I will put only the letters A - Z . When
> a user selects the B for example, a box with the list of companies will pop
> open and be filterd to show only the companies that begin with the letter
> "B". Then the user can select form the filterd list.
>
> I think I recall that Ken showed us something like this at one of our
> BeerFUGs a while back.
>
> -Eddie
>
>
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "Houston ColdFusion
Users' Group" discussion list.
To unsubscribe, send email to [EMAIL PROTECTED]
For more options, visit http://groups.google.com/group/houcfug?hl=en
-~----------~----~----~----~------~----~------~--~---
