I have a script which checks the current page name and write out a certain class if it's true to achieve an active menu item effect.
I want to expand upon it a little and have it check for any pages beginning with business rather than list business_dir_info.asp?id=2517 where there are loads of ids. At the moment it's just set to check for business.asp which is the top level page, is there any sort of wildcard character I can use?
Var1 's content can be "errorone" o "errortwo" or "good". I need to detect if there is "errorone" or "errortwo" with the If clause. How can I do that using the wildcard?
Example that doesnt work: if var1 = *"error"* then
Dear all, if in asp. i wanna to use the command request.querystring to check the URl. For example, my item when passing to next form will be either 4 or 6 character. How do i tell asp what to do if the string pass 4 character and if it pass 6 character.
My code example for 4 character is A100, 6 character is A10001. different number of character will have to perform different task for me.
I try to use "?" as wildcard but it fail Btw if i had stored chiense character in ACCESS, but when it go thru asp n display on IE, it show "???" instead of the chinese character.
I am trying to show a series of movies on a web page. All of the movies are the same width, but have different heights. When I take out the width and height parameters, the pictures display fine, but the movies get the bottom cut off. When I put the parameters back, it stretches out the images to fit the entire box. Any way to make the height parameter a wildcard?
I have an Access database. I am using a dropdown search box. One of the options is "Search All States" and I set the value to %. In the recordset on the results page, I have the default set to %. Here is the SQL statement:
SELECT * FROM ClientInfo WHERE State = 'varState' and varState = Request.Form("State")
However, I get no results when choosing this option in the dropdown Code:.
I want to post a wildcard IP in a varchar field in my mysql table so when I call it in the script it shows up giving that entire range of IP's. I've tried doing it like. 24.129.184.* but it doesn't seem to work.
what I want to do is get read a database entry and if it doesn't start with http:// then I want to include it.
I can't figure out what to use as a wildcard in the first line though
IF rsGuestbook("VisitorHome") = "http://" THEN %> <a href="<%=rsGuestbook("VisitorHome")%>" target="_blank">Name: <% ELSE %> <a href="http://<%=rsGuestbook("VisitorHome")%>" target="_blank">Name: <% END IF
I have a little script that is supposed to check for a certain value in a db column, and then do something if that particular calue is present:Code:
...<%ElseIf rsIDK.Fields.Item("my_column").Value = "/default.asp" then ...
The problem is that my_column can contain up to 300 characters, so the code above doesn't work. What I really need is a wildcard at the end of "/default.asp" but I don't really know the correct way of doing this.
I have a form where a user can choose one or more options from drop-down menus to search the db :
service town county
The id's are all numbers in a MySql database. I have put the default param for each search as % and this only changes if the relevant search option is chosen: Code:
I created an ISAPI dll application to prevent SQL Injection attempts by intercepting the HTTP requests and sanitizing both GET and POST variables (or any combination of both) before the request reaches the intended code. This is especially useful for legacy applications not designed to deal with MS SQL Server Injection attempts. Though this application was designed with MS SQL Server in mind, it can be used with no or minimal changes with other database engines.
This ISAPI is only compatible with Internet Information Server (IIS) 6.0 which comes with Windows 2003. Windows XP uses IIS 5 engine which DOES NOT support ISAPI Wildcard.
I'm trying to pass the wildcard variable % to another page via request.querystring.
When I go to pick up the variable through request.querystring, it will never diplay the "%" if one is included. It will diplay any other characters included in the variable though.
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.
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:
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?
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..
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.
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.
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.
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?
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:
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:
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
