Data retrieving using ms-access

Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Aug 2007
Posts: 14
Reputation: virus220 is an unknown quantity at this point 
Solved Threads: 0
virus220 virus220 is offline Offline
Newbie Poster

Data retrieving using ms-access

 
0
  #1
Aug 28th, 2007
i am retrieving data from access using following command
"select * from sheet1 where [question number] like " & list(0) & " and [category] like " & list(1) & "and [sub-category] like " & list(2) & ""
now problem is if list(0)..... contains integer it works but if it is a string containing a,b then it donot work
plz help???
Reply With Quote Quick reply to this message  
Join Date: Dec 2006
Posts: 645
Reputation: binoj_daniel is an unknown quantity at this point 
Solved Threads: 17
binoj_daniel's Avatar
binoj_daniel binoj_daniel is offline Offline
DaniWeb Expert

Re: Data retrieving using ms-access

 
0
  #2
Aug 28th, 2007
it wont work for string as you missed the single quotes around the parameters.
So it should be like this: [question number] like '" & list(0) & "'

Let me know.. You can read more dev articles on coderewind.com
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:




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



Tag cloud for VB.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC