Geny
|
| Posted: 10/12/2005, 8:57 PM |
|
HI!
I have 2 little problems. The first one are about multiples selections. I have a list box in a search form that are filled with 'listofvalues'. I want to allow the user to select more than one value to do the search. I click on 'multiple' in the property window. I can select more than one value but i have nothing for result and i can see in the adress bar for example this : Province=BC&s_Province=QC , so i can understand that the operation done are AND not OR. (that's why i get not result from the search when selecting more than one value, I need the OR condition) I search in the asp code without luck to change that. Can someone help me with this ?
My other problem are a validation problem. I need to validate a format for a postal code (in Canada). Ex.: J7G 1W1,
So: character, digit, character, space, digit, character, digit
I tried a couple of things (input validation, event on validate...) and i don't find a thing that work.
Thanks in advance, i hope i can get some help... 
|
|
|
 |
donb
Posts: 52
|
| Posted: 10/13/2005, 5:50 PM |
|
The ampersand is not a logical operator, it is 'punctuation' for the URL's query string. I'm not sure what the page/form that receives the query string will do with multiple values. I suspect that you will have to construct the Data Source 'where' clause in Before Execute Select event code, because the query parameters will be an array (because there's more than one value for the single name). Can't say that I've ever gotten into that situation.
For the postal codes, look into regular expressions, at http://regexlib.com. You'll find several good examples there that let you do a good job of validating this or other patterns.
_________________
http://www.gotodon.com/ccbth |
 |
|
Edd
Posts: 547
|
| Posted: 10/13/2005, 11:23 PM |
|
Re Post Codes - Type the following in Google:
"Regular Expression Canadian Post Code" - 1.6 million pages.
Regards
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
GreggB
Posts: 3
|
| Posted: 11/19/2005, 12:47 PM |
|
I'm having similar problem when using the multiple select and text for the search. What I have found so far is:
The numeric searches work fine as they seem not need single quotes around them. The text strings do need the single quotes around them. I tested this by inserting in the SQL statement after the IN several valid searches i.e.: IN ({'Test1','Test2'}). The correct results were displayed. I displayed the multiple search variable in the header of my grid which displayed the correct text data but without any single quotes around text strings but were separated by commas.
Any help would be appreciated on how to fix this problem.
ASP
CCS3 on XP SP2
ODBC for AS400 DB2
GreggB
_________________
Regards,
GreggB |
|
|
|
GreggB
Posts: 3
|
| Posted: 11/19/2005, 6:35 PM |
|
Never mind my entry... just an oversite while earning CCS3.
GreggB
_________________
Regards,
GreggB |
|
|
|
|
