How Can I Compare These Values Properly?
I have a number value in database and same number value from form. For some reason these are not equal. How can I compare these properly? Code:
View RepliesI have a number value in database and same number value from form. For some reason these are not equal. How can I compare these properly? Code:
View RepliesI created an RSS script for my readers to use, but I have been having some minor issues with it.
Actuallyit works fine and I have tested it in 3 feed readers without a problem. Still it does not output as perfect XML if you go here you will see what I mean. Code:
The basic gist of this is that it makes downloading of podcast's available (currently) all the time. However I need it to make them available if and only if the date is the day after the podcast is recorded.
Currently the site is making them available the day before they're actually ready. How can I code this so that the asp page knows that the podcast should be available only on the day it is actually ready? Code:
All i want to do is have a form with 17 checkboxes that writes a value to the database. At this point I don't even care, true/false this/that 1/0 whatever! Setting the Access Database fields to yes/no was not working even 1 bit in the least. They would all be set to off no matter what.
Changed it to text and inserting "That" for off and "This" for on, it comes up, but does it all funky, not in order, all "That"'s at the top, all "This"'s at the bottom, and not even in their respective fields. Code:
Pretty simple task ... page1.asp calls page2.asp and I want page2.asp to show the HTTP_REFERER (which I expect to be page1.asp).
It's blank when I try from my local machine and from other machines. HTTP_HOST, URL and various other server variables work fine so there is a work around, but I'd like to know why HTTP_REFERER doesn't seem to work
I am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies View RelatedI am using what seems to be a fairly simple calendar program that is ASP. I have been successful in adding fields to this App, but for some reason, I must be missing something because when I go into the program to edit an entry, one of the value's (Location) doesn't populate properly.
It pulls up the LAST option (Other) within that dropdown field, instead of the one that had previously been selected. I'm not sure what I've missed, but could someone help? Here is a portion of the code: (let me know if you need additional info). Code:
I've got a mailing list script which loops through up to 20,000 database records, and fires a customised email out to each via the bulk mail queing function of JMail Pro (email component).
Never having tested this with anything other than 100 records, I'm very wary about executing the script in case it times out or starts to misfire.Is there anything anyone can recommend to make sure this process goes smoothly, perhaps even giving the user feedback whilst it's executing e.g. "sending messages 1-1000", "1001-2000" etc?
When I try to open an aspx file located on my computer it doesn't load properly (i.e not all objects are visible like text fields and such) and it gives me a syntax error stating that it expected a semi-colon (;) on one of the lines.
My page language is VB and so no semi-colon is required and when I load the file through my web server by typing
http://myIPaddress/myfile.apsx
the page loads correctly and functions normally.
Several hard drive formats ago I was able to open aspx files with internet explorer without going through my web server. I am pretty sure I have everything installed like IIS 5.1 and the .NET framework.
I have a process that creates a whole bunch of files in a specified directory. The names of the files are the employee IDs with an .txt extension, so they are like
EMP001.txt
EMP002.txt
EMP003.txt
The background is a bit more complicated so I won't bore you with it, but I hope that I can add a button on the asp page that would
1) go to that specified directory, which is database-driven by the department id, such as
D:DepartmentDEPT001
and I'll be able to figure the directory path from the existing code
2) then loop through each employee id and append the employee name, so the above will become
EMP001JohnDoe.txt
EMP002MaryJane.txt
EMP003PeterKay.txt
The employee names are also database driven and my asp page will be able to provide the information.
What I would like is to have a button that would open the cmd.exe and make the appropriate changes, and then do the rename, and then close the cmd window.
I know that you can have something like: Code:
Ok, I've been hung up on this issue for quite some time now and I would
like some help in getting it to work. I think this may be a setup issue
but I'd like to ask your eminences first.
Here's some backstory: I need to create a VB.NET classlibrary (or another
structure) to use objects for our business logic. However, as our upgrade
is an ongoing process, I must enable this structure to be run in both ASPX
and ASP pages.
Here's what goes wrong: I create a new solution. Create two projects, one
a ASP.NET web app, the other a classLibrary. I put a basic hello world
object into the classlibrary then get a return string from it in both an
ASP and ASPX page. Yes, the classlibrary has the build option checked to
"register for COM interop."
Now, the ASPX page runs fine - but the ASP page gives me the following
cryptic error:
Error Type:
(0x80070002)
/webApplication1/test1.asp, line 3
Line 3 is the Server.CreateObject command for the object in question.
No error string. The error code, when googled, reveals that it's "file not
found." That's about as useful as a kick in the ass. What am I doing
wrong? Why can't my ASP page use this object? If I can only get this
functional then I will have no further issues - we can start moving our
business logic and data logic from the legacy ASP pages to an object-based
back end.
How to do if I have 2 cutoff date for online registration. There are 2 set of fee when user regiser. Early registration and after registration example
below code won't work
today = date
if today < 8/10/2007 then
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/10/2007#
order by id asc"
else
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/11/2007#
order by id asc"
end if
I have a textbox which I need to display the data stored in a variable called "fname".
So, what I've written is:
Response.write("<input type=""text"" name=""fname"" size=""20"" value=" & fname & ">")
assume that fname="jason smith"
and, the textbox only ends up displaying "jason". So, anything after a space isn't displayed.What could be wrong? I know the <%=fname%> thing works, but that doesn't work within a Response.write.
The following code is not working properly in IE6 but it does work for mozilla firefox. I am trying to open a new popup window without affecting the frame from "where" it came. But what happens when I click on the link is that the popup window is displayed correctly but the frame then changes to my default.htm. It is supposed to stay the same
here is my code
Response.Write "<td><a href=" & """" & """" & " onclick=" & """" &
"javascript:window.open('desc.asp?msg=" & tempdesc & "','" & rownum &
"','toolbar=no,location=no,directories=no,status=no ,menubar=no,scrollbars=yes,resizable=no,width=600, height=600,left=300,top=300')"
& """" & ">" & left(tempdesc,50) & "....</a></td>"
I used onMouseOver and onMouseOut to switch the image when mouse over the image. But for some images, this event doesn't work and some yes while i'm using the same method to call the event. Code:
View Replies View RelatedI am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:
<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>
The FirstName, MiddleName, LastName vars are supposed to take the array values later.
I'm having a problem with a couple of things. The first is that I am using a loop to populate my table with the proper variables. When it comes across one that is empty it is leaving the cell blank.
The problem isn't that it is leaving it totally blank but that it isn't even putting an outline for the cell. This leaves huge chunks of white space here and there and looks bad. Code:
I am attempting to send an HTML email which a hyperlink that will change based on the user's session ID. I need the hyperlink to display as:
http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id=
WHERE the id = Session("MM_UserID")
However I cannot seem to code this into the html string in the correct syntax, to where id=1 or id=2, etc. Does anyone know the anwser to this problem?The basic code I am using can be found below.
html = html & "<a href=""http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id="">"
html = html & Session("MM_UserID")
html = html & "<IMG SRC=""myImage2.gif""></A><BR><BR>"
html = html & "</br>"
Am facing a problem when trying to display a carriage return in firefox in a title attribute,i ve tried using VbCr and chr(13) ,in either cases a strange character appears instead of the carriage return. does anyone know about this error. The code looks like this:
titles(iday) = titles(iday) & chr(13) & objRS("event_title")
<a href="javascript:showevent('0<%=links(i)%>')" title=" <%=titles(i)%>"><%=i%></a>
Am not having this strange character when running it on explorer.
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 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