Haven't had the coffee yet, but could a quick and dirty solution be
forged out of:
0. On the inference that the user receives no error when selecting zip
codes into the list;
1. Keep the code which produces the comma separated list;
2. Use the ITEMCNT function to count the number of list items into
variable e.g. 'vListMAX';
3. Use the SSUB function recursively to pull each value up to the
vListMAX count into the temp table
4. Go to town as suggested earlier.
Stay cool up there in the Mojave.
Bruce
------ Original Message ------
Sent: 9/2/2016 7:33:58 AM
Subject: [RBASE-L] - RE: select in problem
From: "Dan Goldberg" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
I tried saving it into a table but not sure on how to write the select
command
The data that it saves looks like:
93535,35121,90015,10111,20685,36695,….
I tried using:
select * from inquiry where InquiryDate bet 1/1/2014 and 12/31/2014 and
cust_zip in (sel yourvalue from temptable)
but it does not work.
Dan Goldberg
From:[email protected] [mailto:[email protected]] On
Behalf Of Richardson, Jeff
Sent: Friday, September 2, 2016 6:53 AM
To:[email protected]
Subject: [RBASE-L] - RE: select in problem
Could you draw your values for vlist into a temporary table, and then
select * from inquiry where InquiryDate bet 1/1/2014 and 12/31/2014 and
cust_zip in (sel yourvalue from temptable)
?
Jeff Richardson | Project Manager, Asset Verification Services (AVS)
DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street
Suite 650, Fort Wayne, IN 46802
Cell: 724-366-1724
Connect: [email protected] | Website | LinkedIn | Twitter |
Facebook
___________________________________________________________
ATTENTION: This message and all attachments are PRIVATE, and may contain
information that is CONFIDENTIAL and PRIVILEGED. If you have received
this message in error, please notify the sender by reply e-mail and
delete the message immediately.
From:[email protected] [mailto:[email protected]] On
Behalf Of Dan Goldberg
Sent: Friday, September 2, 2016 9:48 AM
To:[email protected]
Subject: [RBASE-L] - select in problem
I have a selection form that selects zip codes on a map. Then I set it
to view the inquiries in the selected zip codes.
select * from inquiry where InquiryDate bet 1/1/2014 and 12/31/2014 and
cust_zip in (.vlist)
If the user selects too many zipcodes I get the error.
ERROR- Syntax is incorrect for the command -ERROR- More than 10000
characters or 400 items on input line ( 14) (2045)
I have been thinking of a way around this but I am drawing a blank.
Does anybody have any ideas on how to get it to run?
TIA
Dan Goldberg
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
ATTENTION: This message and all attachments are PRIVATE, and may contain
information that is CONFIDENTIAL and PRIVILEGED. If you have received
this message in error, please notify the sender by reply e-mail and
delete the message immediately.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
