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:
How can we get the <param> value for <object> in ASP
View Replies View RelatedIn asp page how can I do this, can't seem to get it right
iInvNum = 123456
Response.Redirect "mypage.asp?invnum=iInvNum"
^ wrong here
I need to redirect based on a param and here is what I am using:Code:
If Request("catid") = "9" Then Response.Redirect "ClassCatRealEstateSales.asp"
my guess is that there is a syntax problem, I am not getting an error because I have other lines that will catch blank ids and the like and redirect to a main page and that is working.
I try to accomplish something like this:
<!--#include file="menu_<%response.write (strproduct)%>.html"-->
But unfortunally, I quess there is something with my syntax... any idea ?
I am trying to run the following t-sql stored proc from my VBScript page
Create Procedure getUserInfo
(
@login nvarchar(8)
)
AS
USE proj_dashboard
SELECT f_forename, f_surname, f_profile_id
FROM t_users
WHERE f_login = @login
basically I wasnt to pull in the login of the user pass it to the proc and pull out the info for that user. I use the following sql statement Code:
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?
<<%=whattouse%> src="Upload/<%=(RS1.Fields.Item("xmedia_asset").Value)%>"
width="320" height="300" align="left" loop="false" controller="true"
autoplay="false"></<%=whattouse%>>
I have the following SQL statement that returns a result set based on the exact input stored in a session variable
If reqname <> "" Then
strSQL = strSQL & "AND(ABR_REQUESTOR='" & reqname & "')"
The variable “reqname” is set to a session variable.
I amended the SQL to do a wildcard search instead of searching for the exact string stored in the Session variable:
I altered the SQL as follows:
strSQL = strSQL & "AND(ABR_REQUESTOR LIKE '" & reqname & "%')"
The problem is the field ABR_REQUESTOR stores the first and last name separated by a space...i.e. John Smith
Using the above SQL will return John Smith if I use J, Jo, Joh.
But, if I want to search for Smith by using S, or Sm, etc. it won't work.
I need to alter the statement to look for anything after a space?
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:.
In an ecommerce situation, when a category link is clicked, my results page shows the category name at the top of the page
This is working great apart from when a search is done without specifying category eg from the search page
So for example Results.asp?Category=%25&Keyword=&Submit=Search
This gives all products in the results page but just gives the last category name in the table as the heading
I would like to write a condition that just presents a static message eg �Results� when the search wildcard % is passed 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.
Not sure if this is possible but, is there any way to search a variable like,
var = "I like to play jazz"
If "jazz" * = var then ( If the word jazz is included in the variable then)
response.write "Found Match"
end if
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'm trying to compare a form field from the previous page & write a response in the html on the current page. e.g
if (form field value) is like "Custom" then write Correct or else write Incorrect. Here's the code I have curently Code:
<%If (Request("RangeColour")) = ("Custom*") Then Response.Write("Correct") : Response.Write("")else Response.Write("Incorrect")%>
I've tried *, &, ? but they don't appear to work. I've also tried like "Custom*" but I receive an error about a sub or function not being declared.
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 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.
Code from page 1:
<%response.write "<a href='Page_2.asp?Severity=" & varCombo_Severity &
"&Owner=" & varCombo_Owner & "'>" & "<i> Go to Page 2 </i>" & "</a>"
%>
Code from page 2:
<%varCombo_Severity = Request.Querystring ("Severity")%>
<%varCombo_Owner = Request.Querystring ("Owner")%>
Result: No % wildcards are passed though to page 2
Any ideas?