say i have variable DomainName is "devshed.com" I want to check if the extension ".com" is found in the DomainName. How would i do that? PHP Code:
<% If (Request.Form("DomainName") = ".com") OR (Request.Form("DomainName") = ".net") Then %>
do stuff...
<% End If %>
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?
how to loop inside a list? i nid to compare a string if it match on anyitems from my list..
View Replies View RelatedI am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date)
IF date() <= mydate THEN
response.write "first half of the year"
ELSE
response.write "second half of the year"
END IF
I am trying to put a search by product name function on the following page, i think i have everything write but for some reason the page always says product not found as if the query is not getting past Code:
View Replies View Relatedi 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
in my asp file i get the following error
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/emirate/view.asp, line 175
my database is access,i checked both data base as well as the coding,both field names are correct
my sql is only this
sql= "select * from MasterEntry"
I have run into a peculiar problem and need a little shove to solve it.
I have an ASP app that tests to see if the browser allows cookies. Complains
if cookies are off, otherwise proceeds to a login page.
Using MS-IE 5 or higher - works fine
Using IE5 or Safari on a Macintosh (OS 9 or 10) gives a page not found error
when trying to detect the cookie setting.
The ASP code use Request.Redirect. I made some htm pages to allow debugging
of the redirect and get the same failure.
I could really use some suggestions for making the Mac machines work.
i got an error saying file not found 404 when redirect to html page
and i ensure that the file is found in the same directory and in the database :
response.redirect results("Url")
where Url is the column name in the database that contain the page name
I'm getting a truly odd error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.
/admin/test/articles.asp, line 286
Code:
Why do I get 'object could not be found' or 'invalid object name'?somebody could explain and what the solution for this.
View Replies View Relatedhave a look at this code and see if they can spot the error. I've been looking for sometime but I'm blind to it - I have a feeling it might be something to do with the ID field? The connection appears fine so this is unlikely to be the cause .
View Replies View RelatedHow to find the File not found error in Javascript. My problem is When click the help image button, i want to display the help popup window to the corresponding page, if it is available.
If the help page is not available for the particular page, common 'No help' page should be displayed in popup window. How can i find the file not found error in javascript.
I know what this error is, all fieldnames have been verified and reverified. Not sure why it is happening. Here is the SQL statement
strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems LEFT
JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
<td><% = rs("Problems.TicketNumber") %></td>
I'm getting this error working on a RecordSet that is filled by a LEFT JOIN query. Everything works fine, until an attempt to access data from the child table in the RecordSet when it doesn't exist.
Which results in "Item cannot be found in the collection". Is there a check that I can perform to see if a RecordSet item exists before attempting to access it?
I have moved an asp application from one IIS server to another and now having problems with the app on the second server. All I did was to move the folder as it is.
Here is the error:
AnnuityRate-Annuity.CalcAnnuityCommonCode E:InetpubwwwrootpensionchoiceForms-Annuity.APIAnnuityCalculationASP error '800a0035'
File not found: AnnQ32.DLL
/pensionchoice/forms/include/commonRosDLL.inc, line 134
My knowledge in ASP is very low - so please suggest. I tried to do a REGSVR32 on the dll with no luck.
We have an application that uses WinInet and ASP to transfer files from an application server to a web server via an FTP component based on WinInet. An ASP page calls this component to transfer the requested file then opens the file and loads it into ADODB.Stream in order to download it to the user.
Things work fine up to the point where the Open|Save|Cancel dialog appears. If the user clicks Open or Save, a fair percentage of the time, they get a "File not found" error displaying the file name followed by a bracketed number, e.g. file[1].txt.
I have few asp pages, in each i connect to the DB, same con name in all of the pages.
one page return error, as above, I had these pages working allright before, but i had to
reinstall the IIS 5.1 because it was corrapted after installing SP2, and now rose this error, what could be the reason, do i have to change settings? of what? the wwwroot folder?
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?
I want to compare two times 1 time is in a variable and the other time is todays time.
i want to get the time in h.m.s
e.g.
12.30.00
13.00.00
this would then output
00.30.00
which i then can then split and if their are 0 i can have get 30 min out of it.
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 using MySQL as my backend
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?
View Replies View RelatedI 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 trying to compare two times(12:00 AM and 01:12 AM)...i am using access..I defined them as text in db...Some how, it doesnt work. Code:
if ( rs("sch_time_start") >= cdate(rs2("start_time")) And rs("sch_time_end") <= cdate(rs2("end_time")) ) Then
response.Write("YES")
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".
View Replies View Related[CODE]...
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 was wondering how do you compare variables that contain text strings in ASP.When I use the following If. Then statement:
If Rs("StyleNo") <> arrStyleNo(aCount) Then
I always get the following error when I try to browse the page:
Error Type:
(0x80020009)
Exception occurred.