select  * from syscolumns where autoval is not null

will list the columns, but you need to know what you are doing if you want to add tablenames, etc

If you are looking for a single date, you can also use

datediff(d,'08/04/2004',myfield) = 0.

This also allows you to select current  (todays) records by

   datediff(d,myfield,getdate()) = 0

or even those in...

There are a couple of things that could be going on.  My thought is that the versions of the Oracle drivers on your workstation and on the server are different.

When...

Why don't you create a temp table to hold the rows you extract with the cursor.  Once you have the rows you need, do your select from the temp table. ...

If you are using Query Analyzer to run the tests this will probably work because QA keeps the connection open and it will continue to see the temporary table.

As far...

Which version of Crystal are you using??  If you can get version 9 Crystal added a repository that allows you to drag and drop images into a special database that...

When the procedure updates the record correctly, most of the time it returns a 0. My ASP page reports this as an invalid original password and tells the user...

That was the intent. I want to tell the user that the record was successfully updated, but it does not seem to happen that way.

Try

Where datediff(d,RETUDATE,getdate()) = 0