Hi,
Something must be wrong with my syntax. When a user goes into his preferences they get
a list of files with check boxes which is being generated from my database.
They have the option of clicking multiple boxes which gets inserted into field
"strOmit" in the same database it got the fields "strDisplay" to display the list.
If I select additional check boxes after inserting the initial ones and update the
database it wipes the contents of field "strOmit" and inserts the new entries. I just
want it to
add (append) the new entires, not delete the field and insert.
Whats the correct SQL statements?
Here is just a snippet of my code.
application.cfm
============
<cfset auth = "#CGI.AUTH_USER#">
In this example auth = Bill
index.cfm
========
<cfquery name="ListElement" datasource="profiles" dbtype="ODBC">
SELECT *
FROM profiles
WHERE strUsername = '#auth#'
</cfquery>
<form action="add-action.cfm" method="post">
...code clipped...
<input type="checkbox" name="select" value="#i#">
...code clipped...
<input type="submit" value="Update" class="navlinks">
</form>
add-action.cfm
============
<cfquery name="GetEnv" datasource="profiles" dbtype="ODBC">
SELECT *
FROM profiles
WHERE strUsername = '#auth#'
</cfquery>
<cfquery name="UpdEnv" datasource="profiles" dbtype="ODBC">
UPDATE profiles
SET
strUsername = '#auth#',
strOmit=<cfqueryparam value="#FORM.select#"
cfsqltype="CF_SQL_LONGVARCHAR">
WHERE strUsername = '#auth#'
</cfquery>
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
