if a declare a variale say
Dim Flag
and assing it to true a boolean value
Flag = True
and if i try to concatinate it with another string like
mystr="<my-str>" & Flag & "</my-str>"
and if the machine is non english the mystr will contain something like
<my-str>that language characters</my-str>
what should i do to get True in mystr what ever the Language of windows is.
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
i'm building a sql statement, and i want to concatinate a string right next to a form variable. well it wont let me, so i think. here's the syntax i'm using and the error. well actually the syntax is in the error.
Code: Microsoft VBScript compilation error '800a0401' Expected end of statement /editdetail.asp, line 10
makechanges="update sheetlog set datein = '"&request.form("datein")&" 12:00:00 PM', keyedinby = "&request.form("inby")&happy&" where logid = "&request.querystring("edid")
I've written some code that creates an sql statement in a string to update a boolean value in an access database, however, I dont know what value to give the field to update the boolean value in the access database. I'll paste some of the code so it makes more sense..... (note: the 'Booked' Field is the Boolean)
strSql = strSql & " UPDATE HolliesBookTbl SET Booked = '-1' WHERE "
'loop through the checkboxes which were ticked for i = 0 to ubound(arrVals) if i = 0 then strSql = strSql & " DateID = '"& arrVals(i) &"'" else 'only add the " AND " if this is not the first value strSql = strSql & " AND DateID = '"& arrVals(i) &"'" end if
I have a boolean field in an access database. I want to write an SQL statement which pulls out all records from the table MemberInfo where the field Online = true.
This is my code
sql = "Select * From MemberInfo Where online=true"
I'm trying to add a search facility to a page that looks for matches in one, other or both memo fields of a database. The code below works fine if the visitor types in one word, or the term just happens to exist in one of the queried fields.
What I'd really like is for a visitor to type in an expression, or query in the same format as you would use in a search engine and it would find appropriate matches. Any ideas how I can modify the code below to do this?
I have a simple JS function that I want to return a true or false value based on the parameter passed in. At this point of time I receive the error "'True' is undefined". Here is my code:
I have some code that checks security permissions in a DB, and before my conditional statement that checks these permissions, I am writing out both values to see what the statement looks likebefore it is evaluated.
The problem is, it seems to disregard the condition and always returns True, even if the condition should be false...any ideas? I also did some testing to assure that the length of the two values I am comparing is 1, just in case they were possibly holding spaces, and I verified they are numeric as well. I am just stumped here...
Let me also preface this code snippet by saying, I am using this asp script to generate javascript menu choices...and I did include some commented debug statements so I can see what the javascript rendered.. Code:
I trying to search a text file using a boolean AND search. What i want to happen is when a user types in type values to search e.g. Name Department (Taylor marketing) i want it to only read out the lines which contain both values.
At present it reads out all lines with Taylor in and all lines with marketing. The code i have so far is: Code:
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?
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:
I 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...
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?
i 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.
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:
I 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:
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?
I've got a form in my website where the users has to type a message. Is any code in ASP where I can get the last word of the message? Ex If I user types "Active Server Pages" is any code to get the word Pages and put it in a variable?