|
If you want to delete values of columns, but keep the
rows, use UPDATE:
UPDATE profile SET env_var='', destination=''
WHERE profile_ID=#form.profile_ID#
Hint: your profile_ID column should be a numeric datatype, so don't
surround the value with quotes.
If you want to delete a row, use DELETE:
DELETE FROM profile WHERE profile_ID=#form.profile_ID#
Karen R. Harker, MLS
UT Southwestern Medical Library 5323 Harry Hines Blvd. Dallas, TX 75390-9049 214-648-1698 http://www.swmed.edu/library/ >>> [EMAIL PROTECTED] 2/5/02 7:05:00 AM >>> Hi, I have the following code that inserts fields into my database. <cfquery name="update_profile" datasource="profiles"> Delete into profile (profile_ID, env_var, destination) VALUES ('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#') </cfquery> I would also like to delete entries. Whats the syntax to do so? ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org |
