Hi Guys,
Can someone tell me if this is correct? Using a simple query that I
Have to update an address record, I'd like to see if I'm understanding
how to create, modify, and delete the Lucene search correctly.
I've included the INSERT query to create the initial record.. Since
the update and delete queries would be self explanatory, I'll leave
them out. Quick question, when you are updating the catalog, do you
need to re-include everything that is put in there? Like if you were
to update it, and leave the body blank, does that blank out the entire
record for that key?
<CFQUERY NAME="create_address" DATASOURCE="members">
INSERT INTO tbl_member_contacts
(member_id,
full_name,
address_a,
address_b,
city,
state,
country,
postal,
phone_number,
phone_number_type,
show_phone_number,
call_time
)
VALUES
('#myid#',
'#FORM.fullname#',
'#FORM.address_a#',
'#FORM.address_b#',
'#FORM.city#',
'#FORM.state#',
'#FORM.country#',
'#FORM.postal#',
'#FORM.phone_number#',
'#FORM.phone_number_type#',
'#FORM.show_phone_number#',
'#FORM.call_time#'
)
;
</CFQUERY>
<cfindex action="create" collection="member_addresses"
key="#new_key#"
body="#FORM.fullname#,#FORM.address_a#,#FORM.address_b#,#FORM.city#,#FORM.state#,#FORM.country#,#FORM.postal#,#FORM.phone_number#,
#FORM.phone_number_type#',#FORM.show_phone_number#,#FORM.call_time#'">
<cfindex action="update" collection="member_addresses"
key="#update_key#"
body="#FORM.fullname#,#FORM.address_a#,#FORM.address_b#,#FORM.city#,#FORM.state#,#FORM.country#,#FORM.postal#,#FORM.phone_number#,
#FORM.phone_number_type#',#FORM.show_phone_number#,#FORM.call_time#'">
<cfindex action="delete" collection="member_addresses"
key="#delete_key#">
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
