Adobe Groups

Nephar

Nephar's Profile

Name:

Wes Byrd

Website:

www.dynapp.com

Company:

Dynapp Inc

Position:

CIO

Company Site:

Dynapp Inc

My Products:

ColdFusion, Flash, Flex, Master Collection, Photoshop, Spry, Web Design, Web Development

Adobe Expertise:

I know a lot

Recent Code:

<!--- Example useage of the DADAO.cfc --->
<cfset membersDAO = createObject("component","com.dadao").init("members")>
<cfset rsvpDAO = createObject("component","com.dadao").init("rsvp")>
<cfset eventDAO = createObject("component","com.dadao").init("event")>
<cfset memberEventsDAO = createObject("component","com.dadao").init("vmemberevents")>

<cfset membersTableData = memberEventsDAO.read()> 

<!--- Uncomment this area to see example of READ and output of query as a result of that... READ returns all rows of the table. ---
<cfscript>
    memberEventsDAO = createObject("component","com.dadao").init("vmemberevents");
    membersTableData = memberEventsDAO.read(fields="member_id,member_fname");
</cfscript>
<cfoutput>#memberEventsDAO.read()#</cfoutput> 
--->
<!--- This shows an example of filtering a query result ---
<cfset qSomeMembers = membersDAO.filter(membersDAO.read(),"member_lname LIKE 'Abb%'")> 
--->

<!--- An example of passing a field filter the READ method to return a single row ---
<cfset filter = structNew()>
<cfset filter.member_lname = "Abbott">
<cfset filter.goof = "ball">
<cfset qAllMembers = membersDAO.read(filter)> 
--->
<!--- 
<cfset qSomeMembers = membersDAO.filter(qAllMembers,"members_lname LIKE 'Abb%'")> 
--->

<!--- Create a struct with database field names and pass that to the CREATE method to insert a new record.  One great way to do this is with a FORM that has the data field names as the form field names... then just pass in the FORM struct into the CREATE method.
<cfset insert = structNew()>
<cfset insert.member_id = "AAB6AFF6-18DE-386F-E7D41A60D0899E61">
<cfset insert.event_id = 1>

<cfset bla = rsvpDAO.create(insert)> 
--->

<!--- Setup a struct and pass it into the UPDATE method ---
<cfset update = structNew()>
<cfset update.member_id = "AAB6AFF6-18DE-386F-E7D41A60D0899E61">
<cfset update.event_id = 1>
<cfset update.rsvp_date = "2009-09-11 18:59:59">

<cfset bla = rsvpDAO.update(update)> 
--->
<!--- 
<cfoutput>
    <br/>#membersDAO.fieldList#
    <br/>#membersDAO.fieldTypeList#
</cfoutput> 
--->

Recent Code File:

dadao.cfc (7KB)

Stats

Last online Nov 04
Joined May 18

Groups

Nephar is a member of the following Groups:

Adobe User Group Tour 2009
public, Event Group, 209 Members
CF9 / FX4 User Group Tours Worldwide

Privacy
|
powered by HiveLive