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
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>"
I have created a page, which records the date the form is submitted. It used the Date() as the default value in the database.
However it stores it in american so displays as american on my website. This would be fine, however there is also a filed which the user can input the date also, so they will input the date in british format, so when i pull both dates out on the admin page it is really confusing.
How can i force the page or database to store/show the dates in british format.
I've got listings of showtimes for a theatre. There are two fields in the sql datebase EventStartDate and EventEndDate.
I have a "I'm in town between" search box that lets you enter 2 dates (startdate and enddate)... anyone know the Query to search the Database for these dates? at the moment I have...
WHERE startdate >= EventStartDate AND enddate <= EventEndDate
With the above, if I enter an enddate that is > the EventEndDate, the listing will not show.
Also I have a what's on this month button, again I need to check the 2 dates to see what shows are on this month.
I want to call a recordset based on whether the 'expiration_start' date and 'expiration_end' date are within the current date.
I've tried a few things but can't get it to work?
Here's my non-working SQL statement:
Code:
sSQL = "SELECT * FROM poll WHERE #" & date & "# BETWEEN expiration_start AND expiration_end"
I'm simply using 'date' to call the current date. I'm not sure if that's correct but it seems to work ok when I use it in an "if" statement like this example:
i have a working members registration script where members register and it emails confirmation of their registration details to the email address they enter. what i would then like it to do is add them to the users database. I have the code but it chucks up this error when it tries to add the user:
Microsoft OLE DB Provider for ODBC Drivers- Error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I have been running IIS on Windows 2000 for several years with no problem.
Today, when I clicked on the system tray icon and clicked start service, nothing happened - no error messages. IIS just ignored me completely and would not start.
I am about to try a computer restart - but has anyone else run into this problem?
Seems that my XP Pro IIS is being a jackass. When I run my ASP scripts it seems to give me this wierd error. Big_Al told me that it was because my script is inside a read-only folder and that something along the lines is really messing it all up.
Now this had brought a new problem. I changed the IIS Console features to Read, Write etc. but its not changing the wwwroot nor the sub folders. Whenever I un select read-only it simply reactivates itself ! What do I do to make the damned thing change!?!?!
We just upgraded our web servers to ms2003 and iis 6.0. we are also running coldfusion MX7. I get a 404 error when ever I trry to bring up an asp page. On the old server we' re we have both cf and asp pages running w/o issue. Any ideas why I'm getting 404's form my asp pages.
i have made a script and it worls no the local host on my pc but does not work on the server.all of my other asp scripts on the server work any ideas y this would work on the local server and not on the internet?
I created my .asp page in Microsoft Visual Studio .NET 2003 and when I right-click my page in there it displays perfectly. But when I try to view it in internet explorer I only get the html part to display.
I've tried regestering iis in the cmd, it didnt solve it. Here is the code if it could be to any interest:
Ive build an asp website which works on my local machine and also works when i upload it to other web spaces, but when i upload to one web hosting space - it doesnt (which also happens to be where the client wants it to be).
There are other asp sites running from that location too - which just puzzles me. Would it be something to do with that i use dsn less connections and the other ones use dsn?
I have been working with ASP classic on this current project im involved in. Well the problem im facing now is there is a page where a flash movie should play in a particular section on the page but it wont play on the secure pages, on the unsecure pages it plays fine. I had added an Active X work in accordance with the Lawsuit issue but it still wont play. Has any body faced this problem.
I am trying to have multiple layers on a page that toggle on and off, it works on a htm file but when I use it as an asp file it doesnt show anything. Code:
I 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:
Having trouble getting Session to persist. Have checked properties of the Virtual Directory in IIS4 manager and "Enable Session State" is checked, with time out set to 20 Mins. Have also checked the Project Properties in Interdev 6.0 and confirmed that "Sensionless ASP Pages" is NOT checked.
When moving from one page to another within the application it starts a new session for each page : I've confirmed this both by Writing the SessionID and by adding a Variable into the On_Start of the Global.asa. Only trying to store a single digit in a Session variable.
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:
I 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?
I have a couple fields in an Access DB that have parenthesis in the name:
EST(Minutes), EST(Seconds)
When I try and populate the dataset and then bind the datagrid it claims there is no field having that name. Can parenthesis be used in fieldnames. If so, can you please tell me the correct syntax please.
I have been working with ASP classic on this current project im involved in. Well the problem im facing now is there is a page where a flash movie should play in a particular section on the page but it wont play on the secure pages, on the unsecure pages it plays fine. I had added an Active X work in accordance with the Lawsuit issue but it still wont play.
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
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.
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.
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
