Does Not Equal
the operator for the following bit in the bold?
[vbs]
If variable1 Does Not Equal variable2 Then
'Do something
End If
[/vbs]
ADVERTISEMENT
SQL: Less Than Equal To Statement
I am having trouble with this SQL statement:
SQLString = "SELECT * FROM WebVacanciesUpload WHERE (Category='"& Cat &"') AND SalaryForWeb = < 13000 ORDER BY SalaryForWeb ASC"
It produces this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Category='IT') AND SalaryForWeb = < 13000'.
/temp/outsearch2.asp, line 86
Two Variables With Same Value Not Equal?
I've got two variables:
currentPage = the current page number being viewed
nPages = the total number of pages
After navigating my site to the last page, these two numbers are the same, yet when I compare them with
if currentPage=nPages then
(execute true statement) else (execute false statement)
end if
the true statement never happens. I have printed the values of each variable just prior to the conditional and verified that they are the same. The only thing I can think of is maybe they are somehow different variable types or one has a decimal value I'm not seeing. Any ideas?
Variable To Equal Name Plus Number
im trying to set a variable to = a name plus anumber next to it for incriminents soo
name = response.write "vac" & + inc 1 or something im not sure
vac1
vac2
vac3
vac4
and so on
Equal Width Of Button
I m using front page.I have used some button and value of all button is different so its width show different.I want to equal width of all buttons.I dont want to use link button.
View Replies View RelatedText Field Equal To Entered Value
I need to make a text field equal to the entered value. Example: First time to the page nothing will show up in the field because nothing was entered. I enter a value and submit the form. The redirect is to the same page to add new inforation but this time the value entered in that one text field will be there. I tried <%=Request.Form("box")%as the value of the text field but to
no success.
Problem In Equal Width Of Button
I m using front page. I have used some button and value of all
button is different so its width show different. I want to equal width
of all buttons. I dont want to use link button.
Check Box Equal To A Variable (moved From Html)
I Have a form, and in that form I have a check box, I wish to say " If Checkbox is checked Then variable = true Else Variable = false". Here is what I have as far as code goes...
Thus far the variable is always false, leading me to believe that my syntax is wrong. All the SQL part of this is tested as working (Included to give a perspective on what I am trying to do) so you can for the most part ignore it. It is the form part that has a problem. Code:
Equal Width Of Button In Front Page
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedSetting Result Of Sql Statement Equal To A Variable For Further Use
I'm trying to calculate the total time using values from database I run a select statement to find the timein column in my database.
Now how do i assign the result to a variable so that it can be used? There is only going to be one result because i'm checking it against an autonumber field. that is used as time 1. Code:
Problem In Equal Width Of Button In Front Page
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedVariable Equal To The "size"
I have an SQL database that tracks workorders for my company. Each workorder is ID'ed by a number, i.e.: 1234. The next would be 1235, 1236, etc. I need a loop to go through EVERY workorder in the database.
How do I set a variable = to the largest WorkorderID in the database? i.e.: That would be 1500 if there were 1500 workorders in the database. Don't worry, there are other checks in place so that it won't always loop through every single workorder (I thought about that already).