October 23rd, 2000, 05:20 PM
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.
October 23rd, 2000, 10:09 PM
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.
October 23rd, 2000, 11:00 PM
<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:
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)
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_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" )%>">
October 24th, 2000, 05:49 PM
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.