473,385 Members | 1,606 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

error '80020009' Exception occurred

Getting an exception occurred error with the following code:
Dim rgstcustConnect 'as Connection

set rgstcustConnect=server.createobject("adodb.connect ion")
rgstcustConnect.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="c:\devweb\_private\cust.mdb"

DeleteExistingEmailSql = "DELETE *" & _
" FROM telecoms" & _
" WHERE (((telecoms.NumberType)='') AND (telecoms.Number) Like
'%@%') AND ((telecoms.CustomerNumber)=" & customernumber & ")) OR
(((telecoms.NumberType)='Email') AND ((telecoms.CustomerNumber)=" &
customernumber & "))"

set intelecoms=server.createobject("adodb.recordset")
intelecoms.open DeleteExistingEmailSql, rgstcustConnect,
adopenstatic, adlockoptimistic

AddEmailSql = "INSERT INTO telecoms (CustomerNumber, [Number],
NumberType, PrimaryEmail)" & _ ' Error occurs on this line
" VALUES (" & customernumber & ", '" &
request.form("email") & "', 'Email', True)"

set intelecoms=server.createobject("adodb.recordset")
intelecoms.open AddEmailSql, rgstcustConnect, adopenstatic,
adlockoptimistic

Either query executed on its own works fine, but as soon I try to
delete any existing emails for the current customernumber and then add
the new email supplied I get the exception error.

Any help is appreciated.
Jul 19 '05 #1
0 2288

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mike | last post by:
Hi, I'm psoting a file to my webserver IIS 5, win 2k. This is the lines of code it errors on the last line Set streamFile = Server.CreateObject("ADODB.Stream") streamFile.Type = 1...
5
by: Moshe | last post by:
Scenario - IIS 5.0 WIN2K latest SP Application ASP. An ASP Page has a text area. When submitted calls SQL server 2K Stored Procedure to update a record. The field in the data base is of type...
0
by: psaban | last post by:
Getting an exception occurred error with the following code: Dim rgstcustConnect 'as Connection set rgstcustConnect=server.createobject("adodb.connection") rgstcustConnect.open...
2
by: dmiller23462 | last post by:
Hey guys, I'm back again....I've got the results displaying that I wanted but instead of having a "next" or "previous" link displayed I am getting the error msg below (I actually get the data that...
6
by: Séverine Donnay | last post by:
Hello, I try to use the replace function with a very long text and I have this error : error '80020009' Exception occurred. Do you have any idee to resolve this problem ? Thanks
1
by: timVerizon | last post by:
Hoping someone can help here.. Our application (C#.Net) was receiving IBM.Data.DB2.DB2Exceptions ERROR SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: '', type...
1
by: active | last post by:
ANYONE HAVE ANY IDEA WHAT IS CAUSING THESE ERRORS. HAPPENS ONLY IF I "START' NOT IF I "START WITHOUT DEBUG" I HAVE NO IDEA WHERE TO LOOK FOR THE BUG An unhandled exception of type...
8
by: jcrouse | last post by:
I am using the following code to trap errors in a sub routine: Try Executable code Catch ex As Exception Dim strInputE As String = Application.StartupPath & "\Error.txt" Dim srE As...
7
by: Alan Pretre | last post by:
I have an application installed at a customer site that has been getting a general network error for a couple of years. I was hoping that .NET 2.0 would clear it up, but unfortunately it didn't. ...
0
by: poojamangal | last post by:
I want to upload images or pdf files. but i m unable to do so. i got error. please help me to sort it out.. my code is: <% 'on error resume next Class FreeASPUpload Public UploadedFiles...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.