how when I try to add a registry to the access database that already exists, I can advise the user that the registry already exists and no duplicates are allowed (the field is in No duplicates, so an 500 error appeard, but I'd like to customize it).
View RepliesI need to select through a query, every record with the date that is from the past 30 days from now. Any hint?
View Replies View RelatedThe default drop-down value is populated by a value already selected using Recordset.
The problem is on the Edit page, the user should have the ability to change the drop-down value, but because the default value is one that has previosuly been selected, it appears twice in the list.
Because I already have an "If, Else" statement to disable some fields, it is causing confusion when I try to enter further If/Else statements to narrow down the drop-down list. Code:
i have many records that are duplicates....i would like to remove the duplicates......can asp help me with that?For example,
i have four fields, A-D
I would like to compare all the for fields with the rest of the records.....to make sure if there are any records that are the same, if yes, delete them
i m getting this following error:
Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
Following is my code: ...
I am getting the following mail error message why?
Error Type:
CDO.Message.1 (0x80040220)
The "SendUsing" configuration value is invalid.
/cbn/mail.asp, line 8
I am using the following code....
I would like to create a ASP Error Message (like they use in Windows) to use in mywebsite so when the user types in a wrong Username and Password the eror message appears.
View Replies View RelatedSometimes (not always) I get the following error message if I want to see my site on the net:
Microsoft VBScript runtime error '800a01f5'
Illegal assignment: 'QU'
globalsub.asp, line 15
Here is line 15 from globalsub.asp
QU = Chr(34)
Can someone tell me what that means and if the mistake can be corrected by myself or is it an ISP problem?
I am trying to debug some code and I keep getting this error message :
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Please try the following:
Click the Refresh button, or try again later.
Open the g6493pc002 home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near 'MA_DAILY_ACTUAL'.
/temp/asp pages/PROSUMMARYTABLE.asp, line 39
Code:
Recently upgraded to an XP pro machine. Moving from CDONTS to CDO. CDO
generates an error message when I try to send a message: Code:
how to avoid giving physical path & line number in the error messages of web applications. Instead i would like to replace it with general error message to the user.
View Replies View Relatedwhile i still have a couple of hairs left on my head i decided to crawl in here on my begging knees and ask all you clevar programming sharks for advice before my needs for a wig becomes a reality.
okay here it goes. I made a function in asp that is suppose to send mails. First i had no clue why the email didn't reach it's destination so i tried every possible variation of the code i could think of, but nothing worked. In my frustration i tried adding and removing text inside the body of the email if i add e: to the end of the text in the body - the email gets delivered every single time... but as soon as i remove it from the text body the email doesn't arrive. I get no error (i disabled friendly error messages) the page loads as nothing is wrong. The event viewer has no errors. there's no mails inside badmail or queue.
The server is a windows 2003 with exchange 2003 installed on it as well.
if there's anything i forgot please do not hesitate to ask.
the email i try to send to is a hotmail account. If i send to an email address located on the exchange server the email gets delivered successfully no matter what's inside of the body.
here's the function i use:
function sendmail(strToEmail, strFromEmail, strSubject, strBody)
Set myMail=CreateObject("CDO.Message")
myMail.BodyPart.CharSet="iso-8859-1"
myMail.From=strFromEmail
myMail.To=strToEmail
myMail.Subject=strSubject
myMail.HTMLBody=strBody
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing")=2
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") _
="localhost"
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") _
=25
myMail.Configuration.Fields.Update
myMail.Send
set myMail=nothing
end function
I get the following error message from an ASP page that we have:
METHOD: POST
ERROR DESCRIPTION: 007~ASP 0100~Out of memory~Unable to allocate required
memory.
ERROR NUMBER: -2147024882
ERROR SOURCE: Response object
Does anyone out there have any ideas? Please let me know if you need any
more information ... I am not sure why this message has suddenly started to
pop up.
I checked the system logs and cannot see any particular memory loss related
message so I don't know.
I have uploaded a working script to a remote shared web host. Now all I get
is the below error. Is there a way to get detailed error message that
describes the error and where it occurs? Code:
I am sending an email using CDO via my ASP page. All of a sudden i am getting this error:
CDO.Message.1 error '80070005'
Access is denied.
/do_add_support.asp, line 128
this line relates to the .createmhtmlbody line of the code. I have navigated seperately to the page that it includes on this line and it works fine. Is this a permission issue?
I just re-uploaded my .asp site to a new host.
But one of my pages now bugs, I get this error message in a Windows alert box:
Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked.
All other pages work fine.
Some time ago I installed IIS via an original Win-XP Pro CD-ROM and with help from instructions that I got from the web.
Basically (as per the instructions) I have a folder called MyWeb within the folder wwwroot, which in turn is in the folder called Inetpub. However when I try and run an ASP script that is in MyWeb, I get the following error message:
'The connection was refused when attempting to contact localhost'
The 'command' that I am entering via the address bar of my browser (mozilla) is the usual way of doing it, according to a friend of mine anyway; which is 'http://localhost/MyWeb/filename.htm'
I need to know why I'm getting this error message because at the moment I am unable to test ASP scripts which is the whole point of having IIS installed.
I am doing a database driven website using ASP/VBScript and Access. I use a
A server timeout has occured. Here are the possible reasons
1.Please make sure the web server is up and running.
2. Please verify that the ODBC DSN exists on the testing server
I use the connection string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("Inventory.mdb") and when I test the database connection , it is successful. But when I try to open a recordset in Binding section in Dreamweaver MX, the error message was displayed. COuld anyone tell me what is it? I am using IIS as a testing server. Do I need to do any settings for this problem?
i am trying to update an existing record with new value, note, and time but i'm still getting syntax error message:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
here is the sql query
sql_update = "UPDATE Expenses SET Value = '" & val & "', Detail = '" & modifiednote & "', Time = #" & Time() & "# WHERE myDate = #" & Date() & "#;"
Ok, so it may only be perplexing because I'm ignorant in the ways of ASP, but still...
When I try to go to a page called "default.asp", I'm getting the following error message:
Code:
Microsoft VBScript runtime error '800a01a8'
Object required: 'Session(...)'
/promark/default.asp, line 34
Does anyone have an idea what is wrong or what I'm missing?
The code on default.asp (line 34) looks like this:
set objInventory = Session("Inventory")
CDO.Message.1error '80070005'Access is denied. When I run the following codes at local machine this codes work clear. but when I run this from the server ( win2k ) I got error. Code:
View Replies View RelatedI recently switch from CDONTS to CDOSYS because of the e-mail delivery delay I am encountering. Now, when I send e-mail using CDOSYS it gives me the error message below:
CDO.Message.1 error '8007000e'
Not enough storage is available to complete this operation.
/development/Administrator_email.asp, line 101
There are about 2000 recipients in the e-mail list. I tried just sending to about 20 of them and I did not have any problem. Code:
When I want to debug my web site written with ASP.NET using C# I get this error message:
unable to start debugging on the web server. unable to connect to web server. verify that the web server is running and that HTTP request is not block by firewall.
I have problem with my page, but IIS only show "The page cannot be displayed". How to display complete error message ? I think I've read this sometimes ago here, but I can't find it.
View Replies View Relatedhow to get a error message when the textbox value should be a number but the user enter a char inside? how do i detect that it's a char and pop up a error message for the user to change? and where should i put it?
View Replies View RelatedI have tried time and time again to figure out what is going on but here is the error message I get: Code:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ')'.
/mhoagland/stdOrderOverviewResults.asp, line 55
Here are all the relevant lines concerning line 55: Code:
I have a table with "title" field set to unique In PHP I can do this following code to check whether the same input already exist or not:
$query = "insert into table (title) values ('".$title."')";
if (mysql_query($query)) {
echo "Title already exist!!"
} else {
echo "New Title saved!!"
}
My question, is there some similar method to do above operation in ASP? Code:
There is a way to make appear the message error (alert) always in front of all the others window, and not behind?
View Replies View RelatedCurrently, I have a form that a user can enter the subject line content and the email body content. They can then send the email which I have set up to use CDONTS. This works fine.
Now I want to add in the ability to attach a file (it will most likely be a MS Word document) to the email being sent out.
I would like to use CDONTS's AttachFile but it's not working for me. I've read up on it and it seems fairly simple except that I'm getting the following error message. Code:
How can I display my own message instead of the error message which may appear in the explorer? , and can I use ASP code in this message?
Iam looking to display a custom page when somebody type a URL for a page in my site, and this page is no longer available
like: http://www.site.com/me.asp
and me.asp is not available
Getting a false error message listed below. The error occurs only when using an ALIAS instead of actual computername i.e. the server name is INTRANET01 but the alias is HELPDESK.
error 'ASP 0113'
Script timed out
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeOut or by changing the value in the IIS administration tools.
I have encountered a serious prob this morning while connecting to my site which is driven by MySQL.
The error mssg that I am receiving is:
Provider error '8000ffff'
Catastrophic failure
/awebsite/includes/connection.asp, line 4
Which is pointing to my connection string. Now I know the values haven't changed in the script or on the server.
I can connect from MySQLYog with the same values so I'm thinking that the server people have upgraded something and forgot to tell myself. I have already tried to contact them but as of yet no reply.
Just incase anyone asks here's my connection string with the username and password changed (obviously):
set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySQL ODBC 3.51 Driver};server=219.141.123.197;user=auser;password =apassword;DATABASE=adatabase;"
I have a completely dynamic website with front end designed in asp/asp.net where as the backend is MS SQL 2000. Frequently on my website I get the following error message on the home page:
Microsoft Cursor Engine error '8007000e'
Out of memory.
/LM/W3SVC/6/ROOT/global.asa, line 86
Can any body help me in resolving this error message?