Megan
Posts: 35
|
| Posted: 08/11/2006, 12:00 PM |
|
I've posted this question a few times with no response. Guess I need to try a different product??? I've resolved quite a few other issues that I've posted about, but there's one last issue that is still not cooperating.
I've using CCS 3, ASP, with SQL Server 2000 backend. I've created a searchable grid. Everything is working great except for the multi-select listbox. When I run the search and only select one item in the listbox, it works great. I've followed the example exactly, followed all instructions, changed the SQL statement accordingly, and I'm getting the following error on the top of the screen when I select more than one:
"Error description: The value in field urls_OfficeCodeID is not valid. Use the following format: ."
What's kind of confusing about the example: when I search in the help for multiselect list boxes, two things come up: the example that can be followed and a topic called "Retrieve Values From a Multi-Select ListBox" that discusses some custom ASP code to be entered in the "Before Build Select" for the grid. However, the example does not have this code. ???
Following is my SQL string in the datasource for the grid:
"SELECT TBL_Listings.*, StateAbbreviation, Code
FROM (TBL_Listings LEFT JOIN TBL_OfficeCodes ON
TBL_Listings.OfficeCodeID = TBL_OfficeCodes.OfficeCodeID) LEFT JOIN TBL_States ON
TBL_Listings.StateID = TBL_States.StateID
WHERE (TBL_Listings.OfficeCodeID IN ({s_OfficeCodeID}) OR '{s_OfficeCodeID}'='-1')
AND (TBL_Listings.ListingNO = {s_ListingNO} OR '{s_ListingNO}'='-1')
AND (TBL_Listings.StateID = {s_StateID} OR '{s_StateID}'='-1')
AND TBL_Listings.Category LIKE '%{s_Category}%'
AND TBL_Listings.Company LIKE '%{s_Company}%'
AND (TBL_Listings.SalesPrice >= {s_MinSalesPrice} OR '{s_MinSalesPrice}'='-1')
AND (TBL_Listings.SalesPrice <= {s_MaxSalesPrice} OR '{s_MaxSalesPrice}'='-1')
ORDER BY TBL_Listings.Company"
I got the "-1" idea from another posting by Peter as I don't want certain items included in the search if the user doesn't enter anything in that search box. I need to use AND as I want the search criteria to be more narrow the more parameters the user enters.
Please, please, please help. I'm getting to the point where I'll pay money. 
Megan
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 08/11/2006, 3:36 PM |
|
Megan
Have you tried contacting support to see if they have a solution ( http://support.yessoftware.com )?? They maybe able to assist you with this issue.
|
|
|
|
expo101
Posts: 24
|
| Posted: 08/29/2006, 3:10 AM |
|
Megan,
I have the same listbox experiences as you described and working on the same config: CCS3, ASP, MSSQL2000.
The missing ASP code in the topic "Retrieve Values From a Multi-Select ListBox" can be found in the online pdf manual/tutorial CodeCharge Studio 3.0 Examples and Techniques, however with this method I was unable to get the multiselect listbox to run either.
Let me know if any possitive development on your side.
Frans
|
|
|
|
Megan
Posts: 35
|
| Posted: 08/29/2006, 7:20 AM |
|
I finally got it resolved with tech support. The manual doesn't quite spell a couple of things out, and I believe there is a mistake as well.
The main issues: When you are configuring the properties of the listbox, you set the "Data Type" to text. Secondly, when you are looking at the SQL statement for the Data Source for your search results, do you see the various "SQL Parameters"? Be sure to set the parameter for the same item you configured for the list box to text. I don't know if that makes sense. If you want, send me your e-mail address and I'll send you some examples.
Megan
megan@bluewaternets.com
|
|
|
|
|
