need help : error in asp - ASP / Active Server Pages

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

regards,
yuval

Jul 22 '05 #1

1440

Well, what was the "error" you got?
Show code. There is an error object, but how you use it will depend
what language you're using.

Tim.

"moshe" <yu******@gmail.com> wrote in message
news:f4**************************@posting.google.c om...

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

regards,
yuval

Jul 22 '05 #2

Brian Staff

My guess is that objConn is not an object and that tells me that your
connection string is incorrect and you did not make a connection to your
database.

Did you do any error checking after trying to connect?

As Tim says..."show us your code"

Brian
"moshe" <yu******@gmail.com> wrote in message
news:f4**************************@posting.google.c om...

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

regards,
yuval

Jul 22 '05 #3

Phill. W

"moshe" <yu******@gmail.com> wrote in message
news:f4**************************@posting.google.c om...

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

On Error Resume Next
objConn.execute(sql)
If Err.Number <> 0 Then
Response.Write "Error #" & Err.Number _
& " : " & Err.Decription
Response.End
End If

HTH,
Phill W.

Jul 22 '05 #4

Roland Hall

"Phill. W" wrote in message news:d0**********@yarrow.open.ac.uk...
: "moshe" <yu******@gmail.com> wrote in message
: news:f4**************************@posting.google.c om...
: > after "objConn.execute(sql)" the page got error
: > how can i show the error? there is an Object error ?
:
: On Error Resume Next
: objConn.execute(sql)
: If Err.Number <> 0 Then
: Response.Write "Error #" & Err.Number _
: & " : " & Err.Decription
: Response.End
: End If

and then...
On Error Goto 0
?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Jul 22 '05 #5

Similar topics

Need some help with validating

by: mike | last post by:

Hello, After trying to validate this page for a couple of days now I was wondering if someone might be able to help me out. Below is a list of snippets where I am having the errors. 1. Line 334,...

HTML / CSS

need help with this code (heh im a beginner so should be a simple fix)

by: Bshealey786 | last post by:

Okay im doing my final project for my first computer science class(its my major, so it will be my first of many), but anyway im a beginner so im not to great with C++ yet. Anyway this is the error...

C / C++

Need Help with programming

by: Drewdog | last post by:

I am getting some error messages which I can't figure out their meaning. I have the code setup, I think it's correct but it doesn't work. My goal is to get this program to read from a data file and...

C / C++

I need your help. I'm confused with the files ...

by: Peggy Go | last post by:

Hi! I've downloaded postgreqsql-base-7.2.4.tar.gz but it says in the readme file that "This distribution also contains several language bindings, including C, Perl, Python, and Tcl, as well as a...

PostgreSQL Database

Need help desperately, Problem Generating Errors for currentdb.execute

by: frank | last post by:

Below is some code for doing and insert into one of my tables. The inserts do not work because a duplicate key exists, which I want to happen. The problem is, I cannot get access to return an error...

Microsoft Access / VBA

Need Assistance with Error Handling

by: CSDunn | last post by:

Hello, I need some assistance with error handling in an Access 2003 Project form. The project is has a data source connection to a SQL Server 2000 database. The main form is named...

Microsoft Access / VBA

106

do i need to set objects to nothing

by: xtra | last post by:

Hi Folk I have about 1000 procedures in my project. Many, many of them are along the lines of function myfuntion () as boolean on error goto er '- Dim Dbs as dao.database Dim Rst as...

Microsoft Access / VBA

Need to add assembly reference to an ASP.NET page with XML/XSL transform

by: Greg Collins [MVP] | last post by:

I have an ASP.NET page that uses a tag: <asp:Xml id="foo" runat="server" DocumentSource="rss.xml" TransformSource="rss20.xsl" /> This creates a Web page from an XML file that was generated by...

ASP.NET

Need help on passing custom objects (classes) to web service

by: Noel | last post by:

Hello, I'm currently developing a web service that retrieves data from an employee table. I would like to send and retrieve a custom employee class to/from the webservice. I have currently coded...

.NET Framework

openssl extension not loading (need to open https stream)

by: Chuck Anderson | last post by:

I run Apache 2.0.55, and Php (both 4.4.1 and 5.2.5) on my home PC (Windows XP). One of the scripts that I run daily needs to access a secure URL (https://..............). When I am running Php4,...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

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...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing