(http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv
<http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv> ) about passing
csv strings to stored procs in SQL to then process, but as you'll see it
starts to get a little messy.
I guess you're processing the results from a load of checkboxes and trying
to remove and add the ones the user has unticked/ticked. I would stick to
using CF to do the list processing - I'm sure someone will correct me if I;m
way off!
Just do one delete statement to remove all the existing references (for the
particular user or whatever), then loop through the list in CF and add all
the references from the new list.
HTH
Alex
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 26 September 2003 14:14
To: CF-Talk
Subject: OT : SQL List Comparison
Anyone know if and how you can compare two lists in SQL?
real world examples could be
List 1 : 1,54,36,98,32,67
List 2 : 54,98,67
Which obviously means 1,36,32 have been removed
and indeed this could also be possible :
List 1 : 1,54,36,98,32,67
List 2 : 54,98,67,36,100,12
Which obvioulsy means that 1 & 32 have been removed and 100 & 12 have been
added....
its a puzzler...it must be able to be be done.......?
_____
[Todays
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
