Search results for query: *

I had a very similar problem to this. If there is any html in the page that is displaying the picture it will try to save the whole page. If you want to save an image you will need to make sure that no HTML is being sent to the browser. I was getting caught up because a line of HTML was being...

Although, I am sure there is a way that you could trap the error between the page using the Catch block. The easiest way may be to increase (or remove) the file size in the machine.config file and then check the size of the file after the request page loads. As it will be hard to trap the...

I am having problems taking a binary file such as an image and inserting it into a SQL Table. I have used a statement to convert the image into an array of bytes like this: Dim buffer(objStream.Length) As Byte objStream.Read(buffer, 0, objStream.Length) This works fine and...

Try the DoEvents command. It should give VB enough time to refresh your screen.

Thanks, that was a huge help. I haven't used the API viewer, but I guess I should start using it. I think that the word API just scares me a bit. ctau

I know this should be an easy one but I cant find it anywhere. I need to get my network machine name in my VB program. Thanks, ctau

Is it possible to execute a stored procedure in the declaration of a view? Thanks, Ctau

...exec master..xp_regread 'HKEY_CURRENT_USER', 'SOFTWARE\VB AND VBA PROGRAM SETTINGS\SYSTEM\COMMUNICATIONS', 'BUILD',@build output select * from customer where rep_id = @build But when using the merge wizard it only allows you to enter the where part for the selection. Any ideas on how I...

I still seem to be having a problem. I have gotten a file dsn to work with Sybase but not with SQL Server. I changed my script to use a system named CDS. It works fine in both Access and VB but not in my ASP. I tried the statement below but received the same error message as above. I have...

I am getting an error message when I try to connect my asp to SQL Server. I am connecting to the same database fine with visaul basic but I get the following error when I try to do it from an ASP. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. I am using the...

It is still giving me two errors. I get Error 156 Incorrect Syntax near the keyword 'IF'. And an Error on line 7 near '.'. Line 7 is my first Set statement and if I comment out the Set statement it gives me the same error on my next Set statement.

I am trying to write a trigger between an inventory table and a returns table. When a return comes in I want it to check the condition field to see if the return is to be destroyed or returned to stock. If it is to be returned to stock it should add the value to Qty_on_hand and to Qty_returned...

I am pulling one line from a text file that is delimited by |. After I pull it in I want to divide it up into variables. I am using the split function but I can only refrence the first element in the array. Input #ITEM_FILE, strLINE STRING_ARRAY = Split(strLINE, "|") if I say...

I am using a string field to allow the user to type in a description of their problem, but if they try to include a single quote in this field they receive an error. Is there anyway to fix this problem without removing the ' from the field?

I finally go this working. Here is what I did incase it helps someone. SQL_Statement = "SELECT * FROM return_header RH, return_line RL where RH.return_number = RL.return_number"

I need help with the syntax to join to tables together using a Select statement. Here is what I have been trying so far SQL_Statement = "SELECT * FROM return_header Inner JOIN return_line ON return_header.return_number = return_line.return_number"

I am having problems connecting to an ODBC database. I am using the following code Set MyConnection = Server.CreateObject("ADODB.Connection") MyConnection.Open SQL, "dsn = wacs" I get the following error when I run this. Line 31 is the DSN line...

Thanks that fixed the problem. CTAU

I am having problems changing my code from Access 97 to Access 2000. I am unable to connect to the database when I switch from one database to the other. Any help would be greatly appreciated. I am new to ASP and can't seem to get over this small hump. The code that I have been using for the...

My computer has recently started frequently rebooting and freezing. It seems to happen at least once an hour if not more. I am on the internet when it happens, but I am not using the computer for much of anything else. I have changed ISPs due to the problem but I am still experiencing it with...