Data retrieving using ms-access

Expand Post »

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???

Similar Threads

Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) in ASP.NET
How to assure data gets stored in MS Access in Visual Basic 4 / 5 / 6
Save data in IE6 page to Access 2003 file in Windows Software
time to time data updates,to access that data time to time in MySQL
retrive data from different tables of Ms access in ASP

virus220

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Aug 2007

Permalink

Aug 28th, 2007

Re: Data retrieving using ms-access

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

binoj_daniel

Reputation Points: 25

Solved Threads: 18

Practically a Master Poster

Offline

645 posts
since Dec 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Serial Communication in .net

Next Thread in VB.NET Forum Timeline: Determining Width of Text in a Control

DaniWeb Message

Cancel Changes

User Name
Password