CodingForums.com - View Single Post

Old Pedant · 10-21-2012, 02:46 AM

I *TOLD* you that using a delimited list in a single field WILL NOT WORK.

If this line of code:

Code:

NMGroups = Replace(UploadFormRequest("txtGroup"), " ", "")

results in the variable NMGroups having the value of "1,2,3,4" then the *ONLY* records that will match in your query are those where the field in the database is *EXACTLY* 1,2,3,4 !!!

It WILL NOT MATCH "1,2,3". It WILL NOT MATCH "1,2,3,4,5". It WILL NOT MATCH "1".

One more time: Your lack of understanding of correct database design has led you into a corner. You can't get out of this one.

10-21-2012, 02:46 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,210 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	I TOLD you that using a delimited list in a single field WILL NOT WORK. If this line of code: Code: NMGroups = Replace(UploadFormRequest("txtGroup"), " ", "") results in the variable NMGroups having the value of "1,2,3,4" then the ONLY records that will match in your query are those where the field in the database is EXACTLY 1,2,3,4 !!! It WILL NOT MATCH "1,2,3". It WILL NOT MATCH "1,2,3,4,5". It WILL NOT MATCH "1". One more time: Your lack of understanding of correct database design has led you into a corner. You can't get out of this one. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.