Storing a JPG as a TempVar?

[RiotSloth]

Hi there all

I am trying to store a JPG as a tempVar when a user logs in, but it will not display. If I assign it to a text box it gives the images name eg 'RiotSloth.jpg'
But if I use an attachment control it remains empty.

Am I missing something? Do I need to specift 'FileData' when assigning it as a tempVar from a Dlookup?

thanks in advance!


-R

 

[pr2-eugin]

I am a bit lost, what exactly are you trying to do again? Storing a file in TempVars?

 

[RiotSloth]

Yes, jpeg data taken from an 'attachment' field in a client record table.

basically IF (login authorised)
Set tempVar(user photo) = userPhoto(attachment datatype) from user table

So then whilst they're logged in it shows their photo instead of a greyed out head (or whatever)

 

[RiotSloth]

Ok, reading up on tempVar it seems they only accept string or var, so that probably explains why I can't do it that way... any suggestions as to a nice, easy way to have access to a JPEG attachment from a user table following a logon?

 

[Galaxiom]

Before TempVars, developers used an ordinary variable and created a function in a Standard Module to return it. Then use the function in the query.

 

[RiotSloth]

Thanks Galaxiom

I'll try it that way.