I did end up doing it in CF..I know its dirty..but there are a number of
factors preventing me from redoing the database structure and all the
data forms at this time.
But hey!
We learned how to convert numerics to String succesfully in Access SQL!
^_^
-Gel
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Gel,
No amount of casting will turn them into the same values. For example
"7" will never be "IN" ("7,8,9,10"). The comma-delimted value that
you're storing will never be seen as a list, because it's just a
string.
You'd have to manually loop over the values in the comma delimited
list and do a comparison on each one - which would have to be done in
a stored procedure - which access doesn't really support. So, to do
this in the database, you're going to have to change your database.
Your only other option would be to do it in CF. But, that's just ugly
ugly ugly. Bite the bullet and change the DB.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
