About Ms Accesss

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Aug 2008
Posts: 1
Reputation: Nikunjpatel is an unknown quantity at this point 
Solved Threads: 0
Nikunjpatel Nikunjpatel is offline Offline
Newbie Poster

About Ms Accesss

 
0
  #1
Aug 28th, 2008
I have following query...

sql Syntax (Toggle Plain Text) 
  1. SELECT * FROM tblAccount
  2. WHERE  intRegionId  IN ([@intRegionid]);


if i put hardcoded values like

SQL Syntax (Toggle Plain Text) 
  1. SELECT * FROM tblAccount
  2. WHERE  intRegionId  IN (2,3);

It returns value but if i try to do it with parameterized query such as SELECT * FROM tblAccount WHERE intRegionId in ([@intRegionid]);

& pass values there then no records selected.?

can you please help me what to do in this problem?
Last edited by peter_budo; Aug 31st, 2008 at 1:58 pm. Reason: Keep It Organized - please use [code] tags
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2008
Posts: 3
Reputation: sandeepbhutani is an unknown quantity at this point 
Solved Threads: 1
sandeepbhutani sandeepbhutani is offline Offline
Newbie Poster

Re: About Ms Accesss

 
0
  #2
Sep 3rd, 2008
Hi
try to use [intRegionalId] insted of using @.
I think @ does not work in access

http://www.net4techies.somee.com/Blogs.aspx?BlogID=16

http://msdn.microsoft.com/en-us/library/aa217680.aspx
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum


Views: 617 | Replies: 1
Thread Tools Search this Thread



Tag cloud for ASP.NET
.net 2.0 3.5 ajax appliances application asp asp.net beginner box browser businesslogiclayer button c# cac checkbox child class compatible complex content contenttype control countryselector courier database datagrid datagridview datalist deployment development dgv dialog dropdown dropdownmenu dynamic dynamically edit editing embeddingactivexcontrol feedback fileuploader fill findcontrol flash flv folder form gridview gudi identity iis image javascript languages list maps menu mobile mssql nameisnotdeclared novell opera order problem profile ratings redirect refer registration relationaldatabases response.redirect rows search security select serializesmo.table sessionvariables silverlight smoobjects software sql ssl tracking treeview typeof validatedate validation vb vb.net vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment wizard xsl
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC