Search Parser
I'm looking for a solution that would allow me to take an advanced search string from an HTML form such as:
"ASP Functions" AND (M@rco OR CrowDozer)
and parse it into a nice SQL query. I started to write a function where I could pass the search string and the field I wanted to search and it would return the WHERE clause, but after a few minutes my head started to spin and I began to feel ill.
I'd need a parser that properly handles: parenthesis, phrases delimited by double quotes, AND keywords, OR keywords, NOT keywords, and uses the AND as the default joiner. Has anyone seen any premade functions that would do this? I'm an IS major, not CS, so I am being trained to plug cables together.
View Replies
ADVERTISEMENT
Who wants to me all about xmlHttp and how to use it with asp. Here is what I have so far and what I need to do. Something similar to the following.
Code:
set xmlhttp=createObject("Microsoft.XMLHTTP")
xmlhttp.Open "GET", "https://secure.somesite.com/PayMeEx/example.asmx?op=Process", False
xmlhttp.Send("UserName=someguy&Password=123456&Card=12345678910")
This doesn't seem to work. I just get an error. How can I make it work and then parse the returned xml
View Replies
View Related
Did anybody creating ASP application using the traditional method like calling the COM object from the ASP?I have a friend, he told me he actually did it differently. He used COM as a parser and it read the HTML pages and serve it to the client machine. I don't understand what the idea it is.
View Replies
View Related
I have a legacy ASP application, which is full of memory leaks. The source
of the leaks are ADO objects that were not closed.
For exapmle "Open" recordset without "Close" and so on.
As the application is rather big, manually parsing asp code is rather
painfully.
Are there any asp code parsing tools, to analyze the source code?
View Replies
View Related
I have a contact form, that needs to be sent as email. However, I would like that email to be received with elements of the contact form in order and not as code in between.
Personally I would put it into a DB. But My client uses mac, and a server that supports ASP but not access db. Go figure. and the current form made in PHP does not work for some reason.
Is there a way to parse the email in ASP so it is organized.
View Replies
View Related
I am trying to port PRAX (PHP Record-oriented API for XML) to ASP and have run into a problem. With Microsoft's XML Parser, to get child nodes, the only way I have seen is by calling on obj.childNodes(1). I need to get a child node by name, not by number, since it could be in any order. Is there a way?
If not, I will have to write that part of the code differently by using an array. I don't want to do this because it would make the code more memory intensive and not as powerful as the PRAX implementation.
View Replies
View Related
I'm trying create an MSXML object so I can load an XML file into it and start to retrieve values from it. The msxml.dll is there and registered. When I try and run the code below either the object doesn't get created or it cannot load the XML file. And I just can't see why. Does anyone have any ideas.
<%
'Create an instance of MSXML to retrieve values from the XML file
set objXML = Server.CreateObject("microsoft.xmldom")
strPath = server.MapPath("books.xml")
'load the XML document that we want to add to the database
objXML.load(strPath)
'see if the object loaded OK
if objXML.parseError.errorCode <> 0 then
Response.Write "object could not open"
else
Response.Write "object opened fine"
end if
set objXML = nothing
%>
View Replies
View Related
I want to be able to post data from a form on one server to another server at regular intervals. I know the XML parser is built around this kind of technology and can post information to a server.
Is there a way of either posting form data to a seperate server without user interaction either using the XML parser or by generating a form and using some JavaScript to autosubmit a form once the page has loaded.
View Replies
View Related
I'm looking for a solution that would enable me to specify a remote URL and parse the HTML (doing various things like replacing links or image refs) and then deliver the revised page to the browser.
I know it's possible, because site search engines and W3C Validator do that sort of thing, but I can't find anything suitable on the web.
Basically I need the plain ASP source code - I don't want anything that would require me to install new components.
View Replies
View Related
I have a windows app that uses vb.net WebClient upload function to upload a file to the website for processing. My website uses ASP. I know how to parse a uploaded file from a webpage using <input type=file...> inputfile control. But I just wondered how I can receive or parse a file from a winapp.Does anyone have some sample code for upload file? both in winapp and server side.
View Replies
View Related
This New Company I'm with Sets their Default WebSite to a local Directory on "D" Yea I've been down the whole route reinstalling XP Pro,,, IIS 5.1 The .NET framework everything. Now I'm just frustrated.
What the Heck !! Theres a web project (C# ASP.net) in the solution containing many many some odd 19 or so projects. MSVSS is additionally in the picture to make things a little more complex. (I.E. the non web projects go elsewhere on the D drive) All I'm asking for here are the BASIC Settings to get my DEV environment and my IE to "SEE" this D:Web folder as Localhost. It worked for a sec. A very brief second. Then it was Gone. Specific ERROR:
Could not load type 'appname.web.Global'. Parser Error Server Error in '/' Application.
View Replies
View Related
i get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.
View Replies
View Related
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.
The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
View Replies
View Related
I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
View Replies
View Related
i have a database with 5 tables,
on my web site i have a search bar..
i wana link that search bar to my tables so..
when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
View Replies
View Related
I was wondering if there was a way to search pages using ASP or ASP.NET.
I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?
View Replies
View Related
how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.
View Replies
View Related
I have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
View Replies
View Related
Need help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah
How to write my code so that even if its not End of record, it will still search my db?
In short : I want the db to be able to search under 2 circumstances : EOF and not EOF
View Replies
View Related
How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
View Replies
View Related
Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.
View Replies
View Related
I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?
View Replies
View Related
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
View Replies
View Related
I'm make a search and I want to limt the results to 10 and have a next button.
View Replies
View Related
With Index Server I can search web pages stored on our servers. Is there any
way to programmatically search web pages on the web ?
View Replies
View Related
I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.
This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code:
View Replies
View Related
I am relatively new to asp so still need help on it.
On my site I have a search that allows users to search for a specific job skill ie.cobol, asp etc
The problem is that at the moment the search can only search for what is exactly typed in the box eg.
"ASP" this search works fine,
"ASP, HTML" this doesnt because It searches for what is typed in.
I have been told It is something to do with parsing and that this will allow me to search for multiple job skills using commas to split what is typed in. If any body has any ideas I will be very greatfull
View Replies
View Related
Does anyone have or know of some ASP programming that will allow me to do a text search of a folder full of PDF files?
I want a user to be able to enter some text and then the programming to do a full text search across all the PDF documents and return the results.
View Replies
View Related
I want to search the content of some database tables,do asp has some function or tool do this?
View Replies
View Related
I have a column in my database where emails are copied to, and i need to be able to search through each entry for certain keywords and display the results if the column contains any of the keywords. i can't figure out how to do this though, because if i use the select statement like this:
select * from maintable where column LIKE ('keyword')
or
select * from maintable where column IN ('keyword')
it will only display the results when the keyword is the only word in the field.
View Replies
View Related
I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title" .
View Replies
View Related
It may be a really stupid question, but if you dont ask, you dont know. Is it possible to search an an xml file, which is used for an RSS feed, with asp at all? So for example, i want to have a search box on my site, which will then search the xml file for the search term, and then return the result to the person searcing?
View Replies
View Related
I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title"
View Replies
View Related
