Search results for query: *

I'd like to put an attachment into my emails I send out using a mailing list. Can someone help me with how to attach a file using cdosys. Thanks in advance.

If you're using SQLPlus (don't know if works in other programs) then you can type the "show errors" command after trying to compile the stored procedure which will show the errors it encountered while trying to compile. I've also never tried this with Java, only with PL/SQL. Hope...

I have a Procedure with an SQL statement in it that selects rows back from a table into variables. If the statement doesn't return any rows then an exception is raised. I'd like to handle the exception by just letting the procedure terminate gracefully. Thanks for any help in advance.

Does anyone know if Windows XP Home Edition have a personal web server available. I'd like to do development at home and that's the OS I have. I've looked but can't find anything.

davesho, You may want to change the * (asterisk) to a % (percent sign) in the like portion.

I'd like to create an executable that can be run from a server and accessed by many people at the same time. Can someone point me in the right direction as far as what files need to be on the client's PC and what type of executable I need to create. Thanks in advance.

Does anyone know how I can check to see if a session variable has expired? I'm trying to check and see if the session variable has expired, if it has then I want to run an SQL statement to get the user's security level from the database and create the session variable again. I'm also looking...

Here are a few changes to make in your second page. This line -> frmSur = Request.Form("frmSur") should look like this instead -> frmSur = Request.Form("sur") The second this is that you're creating a variable named oRS which I think you were going to create a recordset...

A possible solution would be to have 2 databases. One for the network users and one for the web users. Since the web users only lock the database for short amounts of time there would be little or no contention for the database. You would have to link the 2 databases together but since you're...

I would check the permissions of the users that you're connecting to the database as. Is it changing when you go from local to remote and does the user have adminstrative rights in the database on the remote machine?

You can create a session variable on the first page and check it on the second page. I'm not sure if this is exactly what you're looking for but it will solve the problem. So, on the first page do this: Session("First_Page") = "true" Now on the second page check the...

I understand what you're trying to do. The terminolgy is what's causing the most confusion. We're still using Access 98 in my shop and I know it changed in Access2000 so here's the best I can give you. In 2000 they changed the name to Data Access Pages which are essentially the same thing...

For SQL Server the default is to commit a transaction unless you specify BEGIN TRANS. So every time you do a con.execute the server implicitly commits the transaction so you don't have the opportunity to issue a rollback later. In VB and in stored procedures you can say BEGIN TRANS to tell SQL...

I just wanted to add something. After reading your 2nd or 3rd post I think I understand what you're trying to accomplish. It looks like you're deleting the old information but then adding it right back into the database with the updated information being changed. If this is what you're doing...

Try to execute the SQL statement directly against the database (not in the ASP) with the same data and see if you get any errors on the statement.

Here are a couple of things you can check. 1. The database may not be started. - Go to the control panel, check the services, and see if the database service is started. 2. Is the listener started. - Same thing as before, check the services. 3. Last thing I would try. - There is...

I'm displaying a page with employees names and a checkbox to the left of each name. If the management checks the checkbox to the left of the employees name then that employee will be marked to be removed from the database. Every checkbox is given a unique identifier and the value property is...