RobinBronsteede
Posts: 4
|
| Posted: 12/20/2007, 7:15 AM |
|
Hi,
We try to do the following:
After login put a list of ID's in a cookie, like HttpContext.Current.Session["ListID"] = (1,2,3);
In a usercontrole (ascx) use this list of ID's in a retrieve profile.
This last step is done with the query builder and we set "WHERE field in (in) ListID"
where listID comes from "session"
Runnig this gives me an error "Invalid parameter"
Has anyone any idea ????
|
 |
 |
lue
Posts: 20
|
| Posted: 12/20/2007, 9:29 AM |
|
the correct format in vb.net is: ... Session("ListID") = ('1','2','3'). Write '1' instead 1!
In MSSQL the statement includes: ... WHERE RecordID IN('1','2','3')
regards
chris
|
|
|
|
RobinBronsteede
Posts: 4
|
| Posted: 12/21/2007, 12:44 AM |
|
Chris,
Thanks for your thinking, but it doesn't work.
Ik looks like a CodeCharge problem. Hardcoded lists work fine and whatever list I put in
the cookie nothing works.
Robin
p.s.: By the way we have a SQL2005 database and code in C#
|
|
|
|
Oper
Posts: 1195
|
| Posted: 12/21/2007, 3:45 AM |
|
test the cookie and check if the value are there first.
Second display the where generated after the execute.
This 2 will give you a hint what is happening.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
