Hi everybody!
I need to store the contents of an SQL "in clause" in an MS Access
2000 table.
I use MS Access version 9.0.8960 (SP3)
This is my statement (and it works fine with the explicit "in clause"
parenthesis):
SELECT Permutation FROM PermutationsOne WHERE
Permutation in ('B01','B02','B06');
Now, I want to store different strings similar to 'B01','B02','B06' in
table beentogether. Both fields beentogetherwith and member of table
beentogether are TEXT type.
My statement will now look like this (***):
SELECT Permutation FROM PermutationsOne WHERE
Permutation in (select beentogetherwith from beentogether where member
= 'B05');
Statement "select beentogetherwith from beentogether where member =
'B05'"
when executed alone returns:
'B01','B02','B06'
My problem is, HOW DO I STORE 'B01','B02','B06' in table
beentogetherwith? (Field beentogetherwith = TEXT)
I have succeeded only with one trivial case. If I store only one
value:
B06
just like this with no apostrophes or quotes then statement (***)
works fine. The field is TEXT type. Though, I need to store more
values in each string, just like in the first example:
'B01','B02','B06'.
These are the strings I have stored. NONE OF THEM work:
B02 B06 (no quotes no comma)
'B02 B06' (outer quotes no comma)
B02, B06 (no quotes comma)
'B02, B06' (outer quotes comma)
'B06' (single quotes)
\'B06\' (back slash escaped single quotes)
\\'B06\\' (twice back slash escaped single quotes)
''B06'' (double single quotes)
\''B06\'' (back slash escaped double single quotes)
\\''B06\\'' (twice back slash escaped double single quotes)
"B06" (double quotes)
\\"B06\\" (twice back slash escaped single double quotes)
""B06"" (double double quotes )
\"B06\" (back slash escaped double quotes)
\""B06\"" (back slash escaped double double quotes)
\\""B06\\"" (twice back slash escaped double double quotes)
Storing B06 alone with no quotes or apostrophes statement (***) WORKS
FINE!!
I need to store a number of strings that will be returned by the
select statement to conform the contents of the "in clause" 's
parenthesis. ideas, anyone?
Thank you for your advise!
[EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"mysql" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/mysql
-~----------~----~----~----~------~----~------~--~---
