Set Condition Using Variable
what s the correct syntax of setting a condition with a variable that is retrieved from database like in the example below:
dim x
x = 9
if rsTypes("one") = x then
response.write ("error")
what s the correct syntax of setting a condition with a variable that is retrieved from database like in the example below:
dim x
x = 9
if rsTypes("one") = x then
response.write ("error")
i am creating a kind of search using dropdown boxes to search the database. I have got two dropdown boxes one called location and one called cuisine i have sorted out some if statement.
so that it works if they select either one or the other and if they select any location or any cuisine but the problem comes when i need them to be able to select a cuisine in a particular location ie on bothe boxes.
i need it if both are selected at the same time then search the database via location and cuisine. can anybody help here is the code for the two files.
if Line = "" OR NOT IsNumeric(Line) Then
error_list.add"589344","desired line must be specified"
b_error = true
End If
how i can display an error msg saying that the user must only key in number but not character
i have got one field in sql server 2000 database. field1 char 50 in one record, i m storing value -1 but it doesnt satisfy following condition
if (rs("field1")) = cstr("-1") Then
response.write ("true")
end if
i already checked its value by response.write and
print -1 only..
then y its above condition is false?
I WAS having problems. Solved it myself. I'll edit to show the working query for those who could use an example...
I'm having a multiple condition problem in my query statement. I know the what the result should be, but I have something wrong...
Here's the query:
set GetNADs = server.CreateObject("ADODB.Recordset")
set GetNADs.ActiveConnection = adoConnection ......
I'm trying to make a very simple condition about some variable if it is empty do something but my problem is that it always cannot see it is empty
i mean i have a field in a table called title and this field is some times empty
so i need to type "empty" if it is
i tried this code ....
I want to check a another field and if its got info in it i want it to do the then bit, if the field thats checked has no info then its off to else
can some one give me a quick hand on what it should look like?
<%If Your_Condition_Here Then
Response.Write("<form ACTION=""=MM_editAction"" METHOD=""POST'""name=""form1"">")
Response.Write("<input type=""text"" name=""textfield"" value=""(tpwimportrs.Fields.Item(""comments"").Value)"">")
Response.Write("<input type=""hidden"" name=""MM_update"" value=""form1""><input type=""hidden"" name=""MM_recordId"" value=""tpwimportrs.Fields.Item(""ID"").Value "">")
Repsonse.Write("</form>")
Else
' Do Nothing
End If%>
I want to search through different strings and replace the ‘0’ with empty value. My problem is I want to search and replace the ‘0’ with empty values until there is a value other then ‘0’.
Examples
Ex 1: 000010000 - > my desired output -> 10000
Ex 2: 000170000 - > my desired output -> 170000
Ex 3: 004001000 - > my desired output -> 4001000
I've got the following code that sets a session object.
set obj = server.createobject("Scripting.Dictionary")
set session("testobj") = obj
If I want to remove the session object, do each of the following does
the same job? Which one is the best?
1 --> set session("testobj") = null
2 --> set session("testobj") = nothing
3 --> Session.Contents.Remove("testobj")
If I want to check if the session object is not exist, which is the
best option?
1 --> if (session("testobj") = null) then ...
2 --> if (session("testobj") = nothing) then ...
3 --> if (isobject(session("testobj"))) then ...
I have set up a table of Ticket Types. Most of these only have a ticket number but one type also has a reference number.
I am trying to display the info in a table and show the ticket number for every type and only show the Ref number when it is applicable.
I'm guessing its a FOR ELSE statement but I can't get it working. Code:
I want to change the font colour to red if a recordset value is 'high' but i dont know where to put the font tags, Heres what i got so far:
<td width="13%" align="center"><% if rs("priority") = "High" then response.write rs("priority")
else response.write rs("priority") %></td>
But where would i put the font tag and the colour, so it coloured the priorities marked as high red?
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
I'm turning my application into a "DLL". Everything worked fine untill I try to do a "While" in my asp code. Then I recieve an error like this:
"Object variable or With block variable not set"
My vb code look like this.....
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
How do I convert an ASP variable to a Javascript variable?
View Replies View Relatedsql = "SELECT * FROM & console &'news'"
I got that right now but i want the variable, console to be placed along with news so when it selects from the db it selects from gcnnews or whatever variable it's on. How do I do that?
im trying to subtart one quantity from another then stick the answer in to an update statment, but all i get is an error in syntax message
variable math bit=
qty=request.form("oqty")-Request.form("qty")
sql =
sSQL="Update spares SET spares.location='"&request("location")&_
"',spares.machine='"&request("machine")&_
"',spares.part_desc='"&request("part_desc")&_
"',spares.part_number='"&request("part_number")&_
"',spares.qty='(" & qty & ") "&_
"',spares.min_qty='"&request("min_qty")&_
"',spares.updated_by='"&session("name")&"' WHERE(spares.id)=" & form_id
I need to assign a value to a variable, but this variable name is dependant upon another variable!! I am including the code below so you can see it, cos if not I am sure you are thinking whattt?? Code:
View Replies View RelatedI have many buttons that mapping many textbox, when I click button, I
want to show a string that contains button number( and the mapping
string ), but it failed.
Here is the code:
/////////////////////////////////////////////////////////////////////
<%response.write"<input type='button' name="'btUS95resone"&" a &"'
value='Save' onclick='resone("&a&")'>"%>
function resone(cnt)
{
alert("document.all.txt_note"+cnt)
}
////////////////////////////////////////////////
It seems that the component I called is not there...
Can anybody tell me what is the asp equivalent of the php-phrase:
if (!$Variable) {}
?
Another question: is there a special syntaxis for asp conditions in condition?
I tried this code it doesn t work:
If Condition Then
If 2nd condition Then
ElseIf Then
End If
End If
And it works only when I remove the 2nd condition's End If and the ElseIf. Seems strange, no?
I have a text file that looks like this:
Artist Name: Kiss
Song Title: Rock and Roll All Night
Running Time: 04:38
And I need to be able to get the artist name and song title in asp and display it on a website. The thing is, the text file changes with the song being played on the radio. How can I do this?
I've been given an ASP app written with server side javascript. This app needs to get the username of the person currently logged in to windows (Request.ServerVariables("AUTH_USER") in vbscript). I found a way to get this variable in javascript, but then it wouldn't let me split it (server kept saying method not supported). So I've gave up on getting the username with javascript, and have set variables in VBscript at the top of my page. How do I access those variables within the javascript portion?
View Replies View Relatedi have a textbix name "building" inside my system where the user might input one or several building name in it seperated by a comma. How can i extract each of the value in it? For example, "PG2, PG7, PG6", i want to extract each of them.
View Replies View RelatedI have this url that loads, but in the url is the date, so I need a variable i can use so as the date changes the url is automatically updated,
View Replies View Relatedusing access db and asp
i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3
now i want to include that 3 in sql, but it is part of a field name which
is round3_report
cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" & var5 &
"' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute
this isn't working. i keep getting parameter error. i know there is a way to
join a word with a variable in order to make a field name in asp/sql
I am having difficulty in displaying Response.Write rsVacancies("Title") variable more than once. If I remove it from the page title it displays within the description tag but does not display in both. Code:
View Replies View RelatedI am tring to search a database with an SQL statement via a web page. I am using Dreamweaver to build my page. The search works great when I hard code the table field into the Recordset. However, I would like to implement a variable on the field in the table to do the search on.
For Instance, a user can make a selection in a drop down box and then enter the text in a text field. I am having trouble implementing the drop down box variable into the code. I suspect I need the WHERE to be a variable just as the LIKE parameter but I keep getting errors. Code:
I have one condition for getting the image in an included file. If the file which is including the included file is from parent folder if should pull the image directly from Image folder, otherwise it should change the path like Code:
View Replies View RelatedI have created the pages for a website in HTML. I need a script in ASP that displayes the HTML pages when requested (EG: script.asp?page=HTMLpage1).
<html>
<head>
<title>Test site 1</title>
</head>
<body>
<% page = request("page")
select case page
case main: <!--#include file = "index.html"-->
case "services": <!--#include file = "services.html"-->
case "case_studies": <!--#include file = "case_studies.html"-->
end select
%>
</body>
</html>
Any ideas on how to make this work?
for example, if i have Code:
do while not c.eof
if c.fields("id")=request.cookies("id") then
response.write "This is you"
else
response.write "This is " & c.fields("name")
end if
c.movenext
loop
the request.cookies("id") does not work! no variable will work in its position, either. the 'if...then' statement above will only work with c.fields("id")="something", not a variable, like i want. how can i get around this?
I have a HTML-only file, and asp file that do a databasequery.How can I do a query in the html file, like this: DBLookup("2").The asp file execute the query and respond with the result. Send it back to the htmlfile and put it were the "DBLookup("2")" is.
I can not have any asp code in the html page.I have a php file that works like this, but how can I do the same with asp?
how can I name a variablewith the value of another variable to make the first more dynamic.Code:
<%
sql = "SELECT * FROM table"
set rs = cnn.execute(sql)
submodule = rs("ID_submodule")
counter_"submodule" = 0
%>
The idea is where it says "submodule" is the value of the submodule, because this part of the code is a loop that checks all the table registries. Then the 0 would be 1, 2, 3.. depending of the quantity of registries associated with the ID_submodule related.
I have a variable in an app called GenericTitle which contains text, a persons job title funnily enough. I want to check whether this variable contains the word "director" and if it does, then redirect to another page for example. Can somebody post some code that would let me check this?
View Replies View Related