I'm trying to see if a certain string matches a predefined string so I've tried:
--------------
If txtCondition3 = "NO THEFT COVER unless client claim free and occupied
prems for 3 yrs" Then
response.write "1st condition"
Else
response.write "2nd condition"
End If
--------------
i want to keep the lower number between my two numbers (nbelem(querystring) is user defined and nbElemTbl is number of elements in the table) in my test nbElemTbl return 6 and nbElem(querystring) return 10 but it will always enter the if statement and my resulting number is alway 10.
SQLQry = "SELECT COUNT(echBassinNo) as nbElemTbl FROM tblEchantillon HAVING echBassinNo = '" & Bassin & "';" set rs = con1.Execute(SQLQry) dim nbElem if cint(Request.QueryString("nbElem")) > cint(rs.fields("nbElemTbl")) then nbElem = rs.fields("nbElemTbl") else nbElem = Request.QueryString("nbElem") end if
i am retrieving a record from the database, I am trying to place the value of the FULLNAME field in a textbox on a Form, the Problem is that it only displays half of the name leaving out the stuff that comes after a SPACE.
Example:
adors("fullname").value <--- Actual Value is John Smith but it only displays John Code:
I store e-mail addresses in a database that are to be used for notification purposes. When the clients add e-mail addresses I want to check and make sure they have not entered an e-mail addresss in twice. Here is what I've got:
I have two arrays that hold the email addresses from the database and the email addresses from the form. I want to loop through the form's array and check it against the database array. If it finds a match then add it to an error message. If it does not find a match add it to the database. Sounds simple.
Here is the function that does the comparison: Code:
I have created a class registration application with DWMX. The first page shows a listing of all classes (names, date, instructor, etc) dynamically from the database. I would like for the page to only show current and future classes, and need some type of date compare code. Any ideas? Also how does this site make the pop window initiate when a user mouseovers a thread? I know how to do standard popups but haven;t yet figured out dynamic ones.
I need compare the recordset from a database and check if the file exists in a directory. If exists, I show a picture, case not, I dont show....
Sample: The result from a recordset was "hawai.jpg" Then I need to check if the file exists in a directory located in /images/countries/... IF exists I show the image IF NOT I show the message "Sorry, this country doesnt have a picture in the directory."
I have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever.
What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same.
So how can I get the SQL structure of a table that already exists in my database into an ASP page?
If record is getting submitted between morning 6 am to night 12 pm the value of sdate should be current date or if the time is between night 12 to morning 6 the value of sdate should be the previous date but this comparison is not working please help me.
if (time()>"06:00:00 AM") and (time()<"07:00:00 AM") then sdate = Year(Date()) & "-" & Month(Date()) & "-" & Day(Date()) Response.Write(sdate) End IF
I am trying to check if the variable size already exists in my shoppingCart array. However even though it does exist, the code below still returns false instead of setting itemp to true.
' 'Check if an item is already in the customers shopping cart ' Dim iLoop, itemp itemp = false For iLoop = 0 to UBound(Cart, 2) If (Cart(6,iLoop)=thesize) then itemp = true end if next
I have this login that i created. On the sign in process i need to make sure that no one has already signed up using that certain email or that unique cnumber.
Ive tried this line: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'") or ("', cnumber= '" & cnumber & "';")
than this: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'", "' & or & '", "' cnumber= '" & cnumber & "';")
Can I have one recordset execute a Select and then have another recordset execute a different Select, and then check if a field from the first recordset is different from the field in the 2nd recordset and if so write out that row on my displaying table?
I have 2 recordsets. One contains all customer info data, the other recordset contains 1 field of customer id's.
How do I create a recordset that contains all customer information (from the 1st recordset)for only the customers in the customer id recordset (2nd recordset)?
I need to check whether the curtime is greater then or equal to 12:00 am or less then or equal to 12:30am.i tried to use timeSerial to check the time but it comes out an error. Wrong number of arguments or invalid property assignment: 'TimeSerial' Code:
if (weekday(curdate) = 1) then if (TimeSerial(curtime) >= "12:00:00 AM" and TimeSerial(curtime) <= "12:30:00 AM") then curdate = date - 1 response.Write "cur_date = " &curdate& "<br>" end if end if
I am doing a project for Insurance Company. Here I have a field where the administrator enters the date he wants to close a particular verification process. I want to compare the closed date with the server date and if the date matches Update the database column as "DeActivated" or else the database column must show "Active".
using this i try to compare date in the ms acess DTm field and Tdate textbox date but when i type the same date in the text box as in the database in the DTm field i don't get any output of the matched dates details ...
I have two fields [InstallationDate & InstallComplete] created by using Date() to input a DateTime type in my database. InstallationDate is the first date which then gets compared with InstallComplete.
What I would really like is to calculate when InstallComplete is greater than InstallationDate by two days [or even better still 48 hours]. Once this has happened then a text warning must show. I was thinking along the following lines. I know it is wrong but you can hopefully see how I'm thinking.....
<td align="center"> <% if Trim(rsDisplayAll.Fields.Item("InstallComplete").Value) > 2 then Response.Write("you are delayed by two days") else %>
I have two date variable, namely, effective_date and expiry_date. I want to compare the two date variable to ensure the expiry date is always later than the effective date. I need to write this in javascript.
I get all the employees and the hiredates. But I want to restrict the display of only those employees where the hiredates is greater than or equal to the the 1st of the current month. Should I do this in SQL query or in VBScript? Which should be more effective?
I'm a novice to ASP programming. I have an Microsoft Access DB that has a date field (e.g. 8/9/2005) for each record. I want to write an SQL statement that only returns records for the past 7 days. I am accustom to written statements for DB2 access, such as:
select * from mytable where date(mydate) > date(current timestamp - 7 days)
I am trying to compare two strings and get the differenc in vbscript. Example:
Str1="This is a test text" Str2="This is a fine test text but a little long" I like to compare str1 with str2 and get the difference. Above example the difference will be "fine" and "but a little long" How do I do that?
i m trying to compare to dates which are in a db. the start date in the db is written MM/DD/YYYY and the middle date is writen DD/MM/YYYY. i m trying to figure out how many days months nd years thier are between them.
SELECT * FROM NK_editie " & MM_whereConst & " " & whereClause & " ORDER BY editie desc
And
SELECT * FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID ORDER BY editie desc
Now I want to combine those 2 to one string.
I have problems to set it up in working order. My tryout: SELECT * FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID & " & MM_whereConst & " " & whereClause & " ORDER BY editie desc
It shows al the records which are joined, only the second string " & MM_whereConst & " " & whereClause & " is not working.
I found out a really nice way to keep things on the same page is for any processing page to add on a "?<something>=<something>"
and then just check to see what the something is equal to, and the number represents what you want the front page to show.
However, this <something> shows up on the url listing in a browser. Is there anyway to .. encode it so no one can see it? Like a encode/decode function?
I'm building a forum, and right now i'm creating the ability to edit posts. As part of this i want to add the usual "Edited by UserName on Date" line at the bottom, but am having problems doing so.
The problems seems to do with formatting the text in the variable with <span>s using stylesheets, or if there are " and ' markes in the post proper (which I can't seemt to remove with Replace). Here's my code:
I am developing a website and it's going fine, but i've heard that you shouldn't have your database in the wwwroot, it should be outside/above that.
I've done this (i'm using Dreamweaver MX) so I moved the db, fixed my odbc/dsn, connection string etc, but when I upload now I get this error.
Microsoft JET Database Engineerror '80004005'
'C:Program FilesEnsimSiteDatawebpplianceconfdomainsInet pubwwwrootTesting_SiteDatabasesTesting_Website _DataSource.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. /Testing_Site/default.asp, line 8
This is line 8: Recordset1.ActiveConnection = MM_TestingConnection_STRING
Is there something that I have missed. It was ok when it was in the wwwroot.
i am having a problem with comparing two strings. I am taking in the parameter rs("Company") and if this is empty i want to put some text in there. I am testing it with an empty Company field and comparing it like so:
temp1=rs("Company") temp2=StrComp(temp1,NULL)
I have also tried it with temp2=StrComp(temp1,"")
but each time i get nothing returned. Is there some rule about comparing a string with an empty string?
I am using ASP to connect to a simple database to retreive information and also to imput information.What I need is a simple dns connection string syntax to connect and query data.
I have a search function on my site, and what happens at them moment is the user fills in a text box with their search string, and clicks submit. The search page takes their string, and splits it up where it sees " ".
All fairly simple, what I'd like is to allow the user to enter text in speechmarks, so the script would search for a couple of words together, as well as being able to search for every individual word...
Everyone confused yet?!
e.g If the user enters Dev Shed Forums , then the search would look for every occurance of the strings "Dev", "Shed" and "Forums"
What I want is for the user to be able to enter "Dev Shed" Forums, and the search will look for "Dev Shed" and "Forums"...