Search results for query: *

Sunil, My mistake, it was a syntax error. The query statement worked well now. Thanks so much!

Thanks so much Sunil! It worked very well in QA. However I am using this SQL statement in an ASP application. ADO componet doesn't recognize this query and generates an error message when it is processed. How can I get away from this?

In the statement below: select * from Books where (isbn IN (5, 1, 9)) The numbers in the IN clause are in random order, but that's the order I hope the resultsets return: 5,1,9, instead of 1,5,9. But how should I phrase the Order By clause? Thanks.

chidi, Mighty is right. The error message indicates the field you are retrieving does not exist. There is nothing wrong by using Upper in your SQL statement. To test it: just delete the Upper function and retrieve the same field, you will get the same error. My suggestion is go back and check...

Try this: UCase(YourString)

Thanks so much Tarwn! Your information is very helpful. [thumbsup2]

Hi, We would like to get a quote from another website and insert it into one of my ASP pages. I was told I can accomplish this by using XMLHTTP to get the page and then parsing it. I have little basic XML knowledge, therefore wonder if someone could point out a direction for me or share...

Hi, We would like to get a quote from another website and insert it inot our ASP page. I was told that by using XMLHTTP to get the page and then parsing it can accomplish this task. I have little basic XML knowledge, therefore wonder if someone could point out a direction for me or share...

Hi Gorkem, I have barely little experience with XML, maybe it's a perfect time to learn it:-) Could you explain it a little bit in detail? thanks! Redapple

Hi all, I am not sure whether ASP can accomplish this or not. But here is the situation: we have setted up a page, in which a specific industry index is needed from the NASDAQ's website. We hope to get the real-time index and display it on our page. Does anyone know how to code this? Any help...

Hi, I was assigned to develop a site which is basically comprised of numerous articles. Each articles is very long and has multi-sections, and each subsection has its own subsection... so we decided to split each articles into small parts to accomdate easy reading and maintenence. So some of...

I will give it a shot since nobody answers it. Does it need a "by" behind the word "order"? BCP db.dbo.tablename OUT H:\table.txt -c -h "order by column_name asc" -U user -P pwd

Hello, I am new to SQL server. We are going to create a website which is basically for articles searching . Since most of them are very long, over 30 pages at least, probably only data type "text" is capable of storing them (please correct me if I am wrong). As far as I know there are...

Hi, We have a search engine for all the html file on our website. Can we make this search engine to be able to search for database query results as well? thank you redapple

Thank you for your reply Chandler. Maybe I didn't make the question clear. Our problem is that the files we want to be listed at the top is listed at the bottom of the search result. While some unrelated pages are listed at the top. We'd like to find out what criteria did Verity use to score...

Hello, We have a verity search engine on our website. The problem is that the files we are searching for are not listed at the top, but some other old files(maybe?) Anyway, my questions are: what critiria does Verity use to score the search result? How can I make the most up-to-date pages...