Search Result

I am writing code to search for books where some string is within the book's name

it works fine when i set the search parameter to the whole name of the book but when i use the % sign wildcard no results seem to generate

this is my code :

...

What are the top-rated films involving people (in any role) who have
received a Best Actor Oscar? For ‘top-rated’ assume a film rating of at
least 8 out of 10.



For each film, what is the average regional box office taking? Note that
the Box Office Takings only has entries for weeks where some tickets
were actually sold.

Which film failed to make any money in its first week...

HI,


I am trying to compare a series of strings like the following

rodeo rodas
carrot crate
GLX GLX 1.1
GLX glxs

the comparision need not be case sensitive
i am trying to write a sql where i am updating the first string with the second string if they match approximately. Here except the second string all the other...

Hi

I have following SQL Queries. Is there a way to to write a single query instead somehow instead?

-Get OrderID from this query
SELECT OrderID FROM Orders WHERE CustomerID='" + reader.Item("Cu stomerID")


-Using OrderID, get ProductID
"SELECT ProductID FROM OrderDetails WHERE OrderID=" + readerp.Item("O rderID")

-Using ProductID, get...

Hi,
I have an access db that I am trying to query from a vb6 program. I've the following code:
Dim sSQLQuery As String
sSQLQuery = "SELECT * FROM TblData WHERE ID = " & Chr(39) & ID & Chr(39)
ID here is equal to 1234567890

MsgBox sSQLQuery
the msgbox says: SELECT * FROM TblData WHERE ID = '1234567890 Note that the quotation is missing at the end
...