A database has been developed to allow IT to track fault requests. However when you list the faults in question it doesn't display the issuedate.I have checked the code in relation to the other ASP requests, apart from the field name everything else is identical.
View RepliesI'm having hard time retrieving oracle date with the follwing sql statement using VBScript. MayDate Column is Date Type Code:
View Replies View RelatedI get the following error message when I search for some fields stored in oracle database.
Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01861: literal does not match format string
/documenttracking_v3/ReportMain.asp
The script functions correctly using MSAccess and MS sql, when I moved to Oracle I keep getting Date format error messages eventhough The script includes a function that forces the date format I need. Code:
This command below would have in accordance with to catch information of bd the current date, or either... I inserted notice day 05 today, then the user has access and this command alone shows information of day 05 today, sees the command that I tried to use Code:
View Replies View RelatedI am retrivig data from MS Access and displaying data in the form of table. First time it sidplays properly, but if user goes back and agin tries to access same page. It gives following
Error Type:
Provider (0x80004005)
Unspecified error
/DevWebInfo/Leave_status.asp, line 20
line 20 is as below
con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("database/Leave/Members_Leave.mdb")
I have an asp page in which i have a combo,in change of selected index of combo i am putting the combo value to a hidden variable then submitting the form like this
form.hid.value=1
form.target;
form.submit
and again while loading the form i am checking for the value like this .request.form("hid") but i am not getting the value .what could be the problem.the method of my form is post only.
How do i retrieve images[.gif/.jpg] from database and displaying it on a webpage?
View Replies View RelatedI am writing WYSIWYG editior using javascript and asp.. i need a good solution for image placement, right now i am having one.. but is there is any way to retrive the attributes of the images (height, width) of the image while uploading itself.
I am using Binary read for saving the image. Or is there is any way i can place the images in a better way with out asking our end users to do much work.. Using ASP.
Does anyone have a script ASP 3.0 that will return the email address and display name for the current user in Active Directory.
Not be using Anonymous access and will be using Integrated Windows Authentication.
I want to retrieve row from a stored procedure that uses temp table.
Stored procedure works well in SQL Query Analyzer, but if run it from ASP thru Command object, i am getting an error stating that,
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
code used: .....
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
I have a database page with a table. I am using ASP and MSSQL on a Windows 2003 machine.
When I get the database information displayed in the table, I have something like the following:
<table>
<tr><td>row1</td><td>row1</td><td>row1</td<td>row1</td>
</tr>
</table>
The table has a total of 167 row that would be divided into five categories.
How can i get the above table to show:
<tr><td>row1</td><td>row2</td><td>row3</td><td>row4</td></tr>
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
View Replies View RelatedI would like to email detailed error information from my website when an
error occurs.
I tried to use "On Error Resume Next" and if an error occurs check the Err
object and the AspError object returned by Server.GetLastError(), but I
didn't get the same amount of details as I can see on the browser's window
if I don't set "On Error Resume Next".
Is there a way to get detailed information from IIS ?
I'm have a page which requires considerable database processing before writing the results to the page. I therefore wish to have a "Please wait message" up on the screen whilst the main page is processed.
I've tried Response.redirect hoping that the previous page will stay until all processing on th main page is complete and id drawn but this is not the case.
When I submit information i post it to a page and when it’s reloaded it runs as code accordingly if I refresh it re runs the asp because the information is still posted. How do I clear the posted information? Or possibly after it runs the asp code alter a value in the posted information.
View Replies View RelatedI would like to have my application send a 'request' to an ASP page on my server. something like:-
http://www.mydomain.com/registration.asp?name="Fred"&age="25"
The browser then displays the full URL including the
parameters: name="Fred" and age="25"
Is there any way I can send the parameters without them appearing in the URL.
how can i retrieve information on a form page that once previously submitted by the user so that when the user goes back to that form page it will remember what they inputted instead of having them to retype it again? do i have to use session? can somebody please help me... what would be the easiest and most efficient for a newbie to tackle this problem?
View Replies View RelatedI have an update page, when user changes their info. Click update button then go to the update.asp:Code:
LastName= Request.Form("LastName")
Conn.Execute "Update UserInfo SET UserID='" & UserID & "'
'Send an email to confirm…
'Thanks for updating your information
If I refresh the page, it keep sending email. How can we prevent sending email if he/she keep refreshing the page (do not want to disable the refresh button).
I've an ASP page in wich the customer write his card number for the payment. How can I make this information secure when it's sent to the server?
View Replies View RelatedI have a login page, which is not in SSL. However, the script that processes this information is. While that information passes to the login page to the page that processes this information, is this information encrypted?
View Replies View RelatedI'm trying to make a web site that get user hardware information (processor's id and motherboard's id, one of them at least).there's been already one week and nothing yet.I have 2 servers:
windows 2003 server
windows XP professional
both have wmi and iis
I am looking for tutorial and/or help on regards to accessing information using SOAP using ASP. I'm proficient in ASP, but know ver little about SOAP and XML.
View Replies View Relatedhow do i insert two bits of information (email and emailend) into the one database field "email"?
Code:
SQL = "Insert INTO users (uid,pwd,firstname,lastname,email) Values ('" & uid & "','" & pwd & "','" & firstname & "','" &
lastname & "','" & email & "')"
how can you do that?
I use ASP to check users data they submit. In particular, I'm checking for credit cards and I also use a server component DynuCreditCard. It basically affirms that the number "could be" a real credit card number.
Anyway, I cannot get through the website without having a legit CC#. None of the handful of testers that help cannot get through without a legit CC#. About once a month some user gets through with a blank credit card field. How do you troubleshoot something like that? I can't replicate the problem. Do you just say... "oh well... there was a computer glitch"...? How can I approach this problem?
If i have a combo box, automatically when the user changes the item, i want to display information from the database within a textbox, without having to go to the next page.
Currently i only know how to do this by going onto another page.
In VB it was a simple case of calling a procedure, how does it work in ASP? If i need to call a procedure, how would i do this in ASP. The example in w3schools passes the variables, can i do it without it?
How do i search for user based on specific fields? I have a checkbox beside each field of Name, User ID, Email. There's a textbox beside each field for the user to fill up. How it suppose to work is the user would fill up the textboxes and check the appropriate fields to search on.
It can have a combination of searches like he can search on the name and the user ID or all 3 fields. I was thinking is it possible to store the textbox information into the checkbox of that field and retireve the information?
I have a table that contains information that I need to export to a .csv file without manually saving the file, e.g click a button, information is passed and saved. I have no problem geting the information from the table, just exporting it into a .csv and then saving.
View Replies View RelatedI am working on a project involving pulling information from Active Directory (Name, email address, contact no.) and sticking this information in some SQL tables. Using ASP, How do I enable windows authentication (username and password from active directory) ?.
In other words, when the incharge user wants to login to the tables on the web, he must use his/her windows username and password ? On the same project, I want to assign different groups with different security levels. (something similar to the Active Directory security groups), and let the admin asign rights to each group in order to control access and privilege of each user within a group.
how to store information after the ? in the url in form fields. i.e. http://url/test.asp?User=Rob in Form Field UserName .
View Replies View Relatedhow the information boxes pop up when you mouse over a link? For instance in this forum, when you mouse over the Title of the thread, an information box pops up with the entire message. I assume that is Javascript, but does anyone know where I can find more information on this?
View Replies View RelatedThere is a web page (asp.net) that shows some information on a table, we need to collect these information from this web page every 6 hours and save it to a SQL data base and prepare it for further analyzes.
how can I collect the data from this web page automatically.
i'm starting at ASP now and I'm searching some information about it. For example, I need to know all about Application object. Some oficial documentation where I can find it?
View Replies View Related