What Jeff means (and it's a great idea) is to create a temp table with one row for every value. So it would be a multi-row temp table
So something like: create temp table tmpzip (zipcode text 10) insert into tmpzip select zipcode from <your table> where <whatever your criteria is> Then use Jeff's syntax Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Sep 2, 2016 9:34 am Subject: [RBASE-L] - RE: select in problem 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 [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 [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.
