What Is The Asp Code Variable For System Date And System Time?
What is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
View Replies
ADVERTISEMENT
Adding E-mail System (for Web Based Tracking System)
I am currently developing a final year project which is a web based
tracking system tracking exam questions. I am using IIS as the
server, MS access for the database, and ASP with VBScript for the
scripting side of things.
One of the things I want to do would be to e-mail a user/moderator
whenever a exam question is edited/completed/updated. does anyone have
any previous expierence in this? i don't even know where to start.
System Time
I have this simple problem and I have no idea why I havent got this to work. How can I change the system time with asp --> 08/28/2005 to a format like this --> 28.08.2005?
View Replies View RelatedColumn Name System Defined Variable
if I have some system defined variable in my table column, say I am using a column called Default which is bit type. Its enclosed in square braces like this [Default]. Whenever I try to modify a record, it returns the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Default'.
/performaindia/maint/logtype.asp, line 170
in line 170 its
rs.Update
Any hints where to make the changes.
Multiple Order System Code
my project is an ordering system, which allows users to order multiple products by entering in the product quantities in a text box. The technologies I am using are Macromedia Dreamweaver MX, ASP VBscripting, and a MS Access database to hold all the products.
Could anyone please tell me how do I create and order list that allows me to specify multiple products at the one time and also to allow me to enter in the quantity of each product? The next page should then show a list of the products ordered. After this is confirmed the product numbers and quantities need to be stored in an order details Table within the database.
Oracle System Date
I am trying to enter date into oracle databalse & using oraoledb since im taking system date but the value inserted is this "20-JUL-18".
I used date()
How to format the date as to include the year in date.
System Date Format Is Dd.MM.yyyy
I have next problem
System date format is dd.MM.yyyy
But ASP returns MM/dd/yyyy
How to avoid next problem;
Users always enter dates on form like dd.MM.yyyy How to convert it to system date?? Or why ASP returns MM/dd/yyyy like system date is?
File System Object - List Files By Date
I'm using server.mappath to list a directory's contents. The code works fine, but the owner wants to know if there's a way to display the list by the date the file was posted, instead of the alpha order that it is presented by? I haven't been able to find an answer.
Here's what I'm using:
File System Object - Sort By Date Created
I've gotten a subroutine to almost work as I want it to, but it's refusing to show the newest file. It seems to choke on files created near midnight, just never showing them at all, and the date compare is showing an equal number for two different dates, though it surely shouldn't.
The code is running here: http://www.devedia.com/wiki/
The object is to show most recent file first, oldest file last. I have some leftover code in here to organize files by month created, but I removed the folders for debugging. The program moves any files created the previous month into a folder on the first of the month.
The folder name passed in is an X for recent files, a folder name (like 2005_04) when the files were sorted by folders.
What I'm hoping for from the intelligent people in the forum is either an eyeball on the subroutine to help me find where it's losing the midnight/most recent files, or a better idea on sorting by created date using the file system object and asp only. (NO recordset objects.)
And here is the subroutine. (sorry about the indenting... copy and paste it to read it better?)
Code: ...
System DSN
I've created a system DSN called 'accessDSN' for a MS Access DB.
I get an error when running the following.
Code :
<%
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "accessDSN"
sqlString = "INSERT INTO Products(product_name,product_price) values('Gift Basket',34.54)"
Con.Execute sqlString
Con.Close
%>
Error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/asp/l52.asp, line 5
System DSN
Since details like database server, login, database etc is stored inside the
DSN do I really need to specify the login while using DSN
My VB programs works without login id but not my ASP programs..
POS System
I want to stick with VB on this project. The only problem I have with this is that I might have a problem with printing. The POS system is designed on a small 10-15 computer networked system. They are all good systems so nonone say that it may be a little to intensive for the systems.
Now once the system runs through basic checks: change exchange, enough money to pay, and other smaller features then it has to print the invoice. Now we have a small Epson Thermol (prints like Lazer) printer. How would my VB application send that information to the printer?
System DSN
Microsoft, in one of its "Help & Support" pages on ADO, says that a System DSN is three times faster than a File DSN. I find that a bit odd for the simple reason that won't it be faster for a script to access a file to get info about the database source than access the same info from the registry which will be the case if a System DSN is used
instead of a File DSN?
Email System
I wanna build an email/messaging system whereby all members of a portal can send messsages to each other (internally). An example of this application would be the system available in www.friendster.com whereby all friendster members can message each other. Each member has his/her own inbox, trash, sent messages and so on. Can anyone help me with this? I would be eternally grateful
Secondly, i need help with building a forum as well. So far i'm having difficulties getting one that is easily customisable.
ELeave System
I have been working on a simple eLeave System. I would like to get more advice of my db design. Basically, I have 2 tables here: user and leave_application. I will just put the relevant field needed for leave calculation.
user: date_employment, type, t_annual_entitled, t_annual_actual_taken, t_annual_balance
leave_application: date_leave_from, date_leave_to
There are 2 values under type, E - Executive and NE - Non-Executive.
Example
- If type = E, t_annual = 22
- If date_employment = 7 July 2005, t_workingdays = 187
- So, my formula for t_annual_entitled = (22 * 187) / 365
So, is my db design and my formula okay for this system? Any other better ways?
Newsletter System
Created a basic ASP/ADO/Access 2000 Newsletter system using JMail.
Basically client has 300+ subscribers and wants to send 1 newsletter email
to them all every 1 - 2 months.
Missed my client's call to say it wasn't working, but having checked with my
ISP (FastHosts), they have some kind of embargo on the amount of emails that
can be sent every 10 seconds.
ASP Rating System
how to create a simple rating system just like the ones on Amazon.com? I found a link which i tried and i think it is flawed. No attemp was made to provide the source files
View Replies View RelatedSystem Down Message
At the beginning of the month,the whole DB server is down because of the change and upload of tables. So naturally the ASP pages would show errors.
I have 1 dbconnect.asp page which gives the db connection information.
How can I display a status.html based on the DB's down period?
System.Diagnostics
I am spawning a process on the web using ProcessInfo and Process classes.
Running on my dev. XP Pro machine all is fine. Running the same thing on w2k3
server I get "Access Denied" on the page. It seems like a security problem
though I don't know how to resolve it. I have tried all sorts of combinations
on directories, vdirs, etc.
Alert System
Am implementing an alert system that will notify users by mail of activity on a pre-defined date. What function or event can I use to achieve auto-execution of this alert on a specified date without human intervention.
View Replies View RelatedSystem COlors In ASP
I need to get in classical ASP page color of < Button Face object of
MS Windows. Is there any standard function in vbscript?
Email System
I wanna build a mail/messaging system whereby all registered members of a portal can send messages to one another (internally). An example of such an application would be the mail/messaging system at www.friendster.com whereby users can send messages to other friendster users. Can someone help me with this?
View Replies View RelatedAsp Rating System
i need a rating system on my website were people would be able to vote out of to topics and once say 10 votes have been made it adds up the totals and inputs the result of the topic which won
View Replies View RelatedASP Login System
I am currently working on a site that's hosted on IIS. I need to implement a user login system for multiple members. Basically I need to secure mulitple pages and each member would be directed to a different page once they log in.
For example:
client1 logs in and is directed to /client1/reports.html
client2 logs in and is directed to /client2/reports.html
Also, it would be good to be able to display error message below the form if the username or password is incorrect.
I am new to asp and IIS and am having problems finding something that works easily. Can anyone refer me to a script that I can use? It can even be something retail, I have a small budget to pay for something that works.
Securing System
I recently developed my first website and I hosted it on my pc.But when I try to access it from other computers, I am able to do that only when I turned the firewall off.Is there any possibility to access my website in internet on providing security to my system?
And one more problem is when ever I access any control on my webpage in internet, I am getting a dailogue box indicating that "connecting to mysite.dnsalias.com" and it is asking for userid and password.If any one knows please tell me why I'm getting the dailogue box and how to avoid getting it.
Booking System
I am trying to create an online class booking system for a project, how can I sort out the classes so that when a user selects one it gives them the date of the next class, which would be the week afterfor example if I book a class for Thursday then I will be told that the next available class will be Thursday next week. Also if it was Thursday and I wanted to book a class on Monday then I would want it to book the next coming Monday.
The classes are changed every four months, therefore having to put these in a calendar would be extremely time consuming. Is there a calculation I can use in ASP to automate this on the basis of the above example?
File System
This piece of code brings down my entire webserver (XP pro) :
Code:
dim fs
set fs = CreateObject("Scripting.FileSystemObject")
fs.DeleteFile ("c:/inetpub/wwwroot/images/dsc00001.jpg")
Whats wrong with it ? The file and path is correct.
System Commands
What is the syntax for running say. a batch file (.bat) from within ASP?
For example... in MS Access you can say something like this...
----------------------------------------------------------
CurrentDBDir = "c:"
ShellWait CurrentDBDir & "runthis.bat", vbNormalFocus
----------------------------------------------------------
This would run the "runthis.bat" file located in the c: directory. How would one accomplish this same thing in ASP?
System.__ComObject?
I am trying to pull all of the rows out of a DB table called "Thread Topic", and display all of the data for the table column "ThreadTitle" on the ASP page. But when I pull the data and put it into a variable, it prints out this:
"System._ComObject"
...I have a loop to display every record in the "ThreadTitle" column, so it prints this System._ComObject thing for every record I am trying to print.
Here is the portion of my code that this is dealing with...(keep in mind this is just a portion of the code, the relevant code only, variables that look like they are not declared are declated earlier in the page ...
Login System
I want to start a login system for certain pages on my script. 1) What's the best free script you would recommend? When the user logs in, I want information is the page which relates specifically to them, i.e. "Hello (Their user name). I also want a unique hyperlink to them, i.e. http://scripts.website.com/AAClick.asp?ID1=332&ID2=112&programmeID3=111&ID4=0&tracking=(I_this_to_be_their_email_address)&url= .
View Replies View RelatedISP Billing System
I am in the process of trying to find a Web Hosting/Isp Billing system that is reasonable in price and uses Access or SQL Server for a backend DB. I have found a couple that seem to do what I want, but are using FILEMAKER for their DB.
Looking for something that will handle reoccuring billing as well as per project billing. Keeping up with client info, etc. Also needs to have the ability to modify letters, forms, invoices, statements, etc.
System Error 127
just started a couple of days ago and the only thing I have done with this computer is I installed some software for the AT&T Web Meeting Service. After that when I try to access any of my web applications written with asp when they try to connect to a database threw odbc using this connect string:
Connect.Open Session("Link"), Session("UName"), Session("PWord")
I get this error message "Specified driver could not be loaded due to system error 127 ".
The System Cannot Locate
Hi iam using proxy in my system and when i tried to access the remote url thorugh xml object in asp iam getting the following error. the error is: the system cannot locate the resource specified. the same code is working when i remove the proxy.
View Replies View Related