Justman
|
| Posted: 12/16/2004, 4:05 AM |
|
Hi ,
I am wondering if anyone could tell me how to set the default directory for picture columns. Just a bit confused if it has to be setup in the design properties or before_show event.
Cheers,
Justman
|
|
|
 |
DonB
|
| Posted: 12/16/2004, 4:34 AM |
|
You can change the control source type from "database column" to "database
expression". Then you will be able to enter a concatenation, of whatever
path you need and the column name. Whatever you type in there goes straight
into the SQL for the query.
--
DonB
http://www.gotodon.com/ccbth
|
|
|
|
Justman
|
| Posted: 12/16/2004, 4:42 AM |
|
Good DonB. Do you have any sample for me to follow please?
Justman
Quote DonB:
You can change the control source type from "database column" to "database
expression". Then you will be able to enter a concatenation, of whatever
path you need and the column name. Whatever you type in there goes straight
into the SQL for the query.
--
DonB
http://www.gotodon.com/ccbth[/quote]
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/16/2004, 12:06 PM |
|
Justman,
I suspect that Don meant to reply to a different post.
You can use both methods to specify an image path, either in design properties or via events. It should be simpler to do this in design properties, for example by changing the "src" property from "{picture}" to "images/{picture}".
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Justman
|
| Posted: 12/17/2004, 10:28 PM |
|
Thanks Peterr.
I have got it working. I actually put the code in before_insert event so that the login name of the user will be concatenated with the path of the image directory to make a complete path for the user picture.
Cheers,
Justice
Quote peterr:
Justman,
I suspect that Don meant to reply to a different post.
You can use both methods to specify an image path, either in design properties or via events. It should be simpler to do this in design properties, for example by changing the "src" property from "{picture}" to "images/{picture}".
|
|
|
|
|
