#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    3
    Rep Power
    0
    Ok, I need a striaght simple answer, if there is one. HOW DO YOU LOAD GIF'S INTO A Table?
    The DB is remote on Apache/unix/MySQL-everything seems to be for MS Server) - I have OBDC connection set up, table set up...but i need to get some GIF's into the table. Can I do it with a SQL command like LOAD LOCAL INFLIE 'xxxxx.txt'????
    I want to LOAD LOCAL BLOB file......wish it were that easy - can some one answer this question for me Please.
  2. #2
  3. No Profile Picture
    The Dude Abides
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Feb 2000
    Location
    grass valley,ca
    Posts
    1,062
    Rep Power
    16
    Bad idea, put the image name or image path in the table, but not the actual image. Then insert the variable in your display and let the html display the image. Storing the images in a directory is much more efficient.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    3
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by thedude:
    Bad idea, put the image name or image path in the table, but not the actual image. Then insert the variable in your display and let the html display the image. Storing the images in a directory is much more efficient.[/quote]

    ok so I put the path into the table field: like:
    www/pixfile/pix.gif (???right???)
    Then to show that pix.gif on an .asp page when that row is queried, how?
    I've been playing with a script but can't get it right - can someone look at it and see what i've done wrong - I don't understand the scripting enough to know what's wrong-
    (assuming i get the path right in the field)
    <%@LANGUAGE="VBSCRIPT"%> <%
    set rsGIF = Server.CreateObject("ADODB.Recordset")
    rsGIF.ActiveConnection = "dsn=dsn name here"
    rsGIF.Source = "SELECT * FROM Projects"
    rsGIF.CursorType = 0
    rsGIF.CursorLocation = 2
    rsGIF.LockType = 3
    rsGIF.Open
    rsGIF_numRows = 0
    %>
    <%
    reGIF.Open "FILE NAME=www/htdocs/mypixfile/pix.gif"
    mySQL="Select image_URL from Projects"
    Set RS=rsGIF.Execute( mySQL )
    While Not RS.EOF
    %>
    <img src="<%=RS( "image_URL" )%>">
    <%
    RS.MoveNext
    Wend
    %>

    Thanks
  6. #4
  7. No Profile Picture
    The Dude Abides
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Feb 2000
    Location
    grass valley,ca
    Posts
    1,062
    Rep Power
    16
    Well, if you were doing it in php I could tell you in an instant, but I'm not terribly familiar with ASP. Try posting this to the php forum.

Similar Threads

  1. maysqladmin drop database syntax?
    By Slurm in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 06:07 AM
  2. 2-dimensial array / mysql_fetch_array database problem
    By paulx82 in forum PHP Development
    Replies: 3
    Last Post: December 27th, 2003, 02:52 AM
  3. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 06:27 PM
  4. distributing database reads among db slaves
    By JunkCookie in forum PHP Development
    Replies: 3
    Last Post: December 17th, 2003, 12:45 PM
  5. Replies: 0
    Last Post: December 10th, 2003, 12:40 PM

IMN logo majestic logo threadwatch logo seochat tools logo