Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ziggs

  1. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    My final problem is that when a user runs this ASP, the pictures can be viewed on the page, but won't print. Instead, I get the name of the picture, "image index 0", "image index 1", etc. Is there a slight modification that I need to have the image print?
  2. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    wbvda, I'll try it later today. I didn't see your post until now. TIA
  3. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    Sorry for not understanding, but since I'm viewing hundreds of jpegs at a time in this search, how long does this data stay alive? In other words, I don't want the server load up it's memory and start to slow down. With my limited skills, I used this line and just created another asp called...
  4. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    One last problem, I added a width and height to Tsuji's suggested code to reduce the picture size. Thus, giving a preview picture. In this same code that calls the blob picture, is there a way that a user can click on this preview photo and pull up the same picture in it's original size. I...
  5. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    Actually, I have it now. Thanks so much to all.
  6. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    Ooops, it's: <TD bgcolor=<%=InfoField%> align=center>img src=<%=rs("image")%>&nbsp;</TD> for last line
  7. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    Sorry, I did not double check my work. Here's the correct codes that I'm using. Something went wrong in the cut and paste process. AND FOXBOX, I was able to show a single value with the website you provided. Now, I'm trying to figure out the looping details that Tsuji provided. Tsuji, the...
  8. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    I did a bad job at cutting, pasting and trying to reduce this to a coding that's easier to work with. The corrected stated is: SQL1 = "SELECT RD.ID, RD.image from RD" "SQL1 = SQL1 & " WHERE RD.ID = '29'" Thanks
  9. ziggs

    Using IIS ASP to display a blob field in SQL Server 2005

    I'm using Windows 2000 Server IIS ASP and I'm attempting to display a picture via an vbscript/ASP of a Blob image in SQL Server 2005. Below, is part of the code (the important part) that I'm using after reading up a bit. Unfortunately, I'm not getting the Blob image in one of our Vendor's SQL...
  10. ziggs

    Office 2000 - In forms/date type field - show day of week possible?

    I can stick with the three letter abbreviation. I tried the copy and paste, but I didn't get it to work as expected. I unprotected the form. Created MM/DD/YY for one field, copied that field and pasted it to another field. After changing the properties of the 2nd field, I then protected the...
  11. ziggs

    Office 2000 - In forms/date type field - show day of week possible?

    So, MM/DD/YY DDD worked and gives me a three letter abbreviation. I would prefer a two letter day abbreviation if possible. Also, can the following be solved. The three fields on a report that I can't change is: Date Time Day 6/1/10 0641 Tue Based on your new formula, it now...
  12. ziggs

    Office 2000 - In forms/date type field - show day of week possible?

    In MS Word 2000, I've added a text form field. Then, I gave it "Date format" setting of MM/DD/YY. Now, based on the Date that the user enters, I would like to create a second field that automatically populates the day of the week based on that date (Mo, Tu, We, etc). Any ideas?
  13. ziggs

    Proper array

    I have to input hundreds of streets in the following select expert formula: {DataWarehouse.Address} like "*" & "S MAIN" & "*" or {DataWarehouse.Address} like "*" & "BELLEW" & "*" or {DataWarehouse.Address} like "*" & "JEFFERSON" & "*" Instead of coding out each "or" line is there an easier way...
  14. ziggs

    Power option settings creates slow logon time, how to fix

    When any user logs into a computer at the office, the user may wait one second to several minutes before the computer starts to log in, which is very frustrating. However, if the user logs into the same computer after someone who has their Power options set to "Never" for "turn off hard drives"...
  15. ziggs

    extracting the digits only

    Would you mind explaining how to get rid of: 123B to make it 123 only? If I see the isnumeric that would correct the digits, I would hope that I could formulate the rest.

Part and Inventory Search

Back
Top