Display Image (.jpg, .bmp, .png, .gif) From Table

[EricN]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

Well Pat I ended up taking your route.

My upload page saves the file to my vlogos directory and saves pertinent information in my vlogos table.

The user can then modify the size of the logo. (I do have min and max limits for this). This is via a grid linked to the vlogos table (see pic).
=============================================================================================================
I then have a page called emlogoshow.a5w with just the following:
dim gName as c = alltrim(lookup("[pathalias.adb_path]\logos","ssn="+quote(session.ssn),"coname"))
dim gHeight as c = lookupc("F",alltrim(session.ssn),alltrim("height"),"[pathalias.adb_path]\logos","ssn")
dim gWidth as c = lookupc("F",alltrim(session.ssn),"width","[pathalias.adb_path]\logos","ssn")
dim gLogo as c = lookupc("F",alltrim(session.ssn),"name","[pathalias.adb_path]\logos","ssn")

? "<center><img border=0 src=http://socialservicenetwork.com/logos/"+urlencode(gLogo)+" height="+quote(gHeight)+"width="+quote(gWidth)+"alt="+quote(gName)+"></center>"
==============================================================================================================

I have this a5w_include("emlogoshow.a5w") in pages I wish to display the logo.

If the user deletes the logo I have the following:
If uDelete="Yes"
dim dellogo as c = lookupc("F",alltrim(session.__protected__userid),alltrim("name"),"[pathalias.adb_path]\vlogos","userid")
If file.exists("[PathAlias.ADB_vlogos]\\"+dellogo) ' vlogo directory containing companies logo
file_remove("[PathAlias.ADB_vlogos]\\"+dellogo)
end if
' ===== Users table =====
dim tbl as P
dim qry as P
tbl = table.open("[pathalias.adb_path]\vlogos")
query.filter = "Userid =" + quote(session.__protected__userid)
query.order = "Recno()"
qry = tbl.query_create()
tbl.delete_range()
tbl.close()
response.redirect("emlogoupload.a5w")
end if

[EricN]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

Jeff,
Thanks for the suggestion. Still no go. Get blank box and no pic.

Steve,
SSN does NOT represent Social Security Number but Social Service Network (my company name). I need to remember there could be confusion when posting here and maybe use something else for my examples.

Pat,
Your suggestion is exactly the direction I thought of using width, height and alt fields in the table. I would allow clients to adjust the size of their logo with max and min sizes pre-established. BUT I had hoped to also upload the logo into the table not a directory as daily maint is already set up for the table.

[Pat Bremkamp]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

Eric,

You might want to rethink the design and put the jpg in a directory (I call mine, creatively, "logos"). Then, make an Image File Reference Field in the customer table to hold the path and image filename. One good trick is to rename the logo to the customer Id. That prevents duplication and makes it easy to find.

In my table, I create fields named "logoname" "logohigh" "logowide" and "logoalt" Then in the header, put

<img src="<%a5 ?logoname %>" height="<%a5 ?logohigh %>" width="<%a5 ?logowide %>" alt="<%a5 ?logoalt %>" >

Pat

[Steve Wood]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

And unrelated, somewhere in the app associate the SSN with a GUID and use the GUID as the lookup value to ensure the privacy of the SSN.

[marvinbase]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

Try:

? "<img border=0 src=\""+lookup("[pathalias.adb_path]\logos.dbf","ssn="+quote(ssn),"Imagesmall")+"\" width=150 height=26>"

[EricN]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

Hello Stan,
Thank you! Below pic is my result so far using:
? "<img border=0 src="+lookup("[pathalias.adb_path]\logos.dbf","ssn="+quote(ssn),"Imagesmall")+" width=150 height=26>"

[Stan Mathews]

Re: Display Image (.jpg, .bmp, .png, .gif) From Table

"<img border=0 src="+lookup("[pathalias.adb_path]\logos","ssn="+quote(ssn),"Imagesmall")+" width=150 height=26>"

or

"<img border=0 src="+lookup("[pathalias.adb_path]\logos.dbf","ssn="+quote(ssn),"Imagesmall")+" width=150 height=26>"

Not my area of competency.

[EricN]

I currently display my client's logos by allowing them to upload the logo to a table (see pic) and then using a grid (see pic) to display the logo. This works fine, however the grid consumes a lot of real estate.

I hope there is a way to display the image stored in the table to the web page and eliminate the grid!

Ive tried: ? "<img border=0 src="+lookup("[pathalias.adb_path]\logos","ssn="+ssn,"Imagesmall")+" width=150 height=26>"
and tried other possibilities...

Read up on blobs but can't seem to figure this out.

Any help appreciated!