Need help with image titling

[baldaggie webforumsuser@macromedia.com]

I am using web photo album 2.1 to generate thumbnail and photo viewer. In the template I am using for the photo viewer, I would like to display the file name associated with the photo. For some reason they didn't put that in as an option. They do allow for inputing a description, but I want to automatically generate the filename to display. What I have found is that "photo-image /" will return the filename in the form of "images/filename.ext". I just want to display the filename with no ext and without the images/ in front of the filename.

How now brown cow ?

Thanks...

mjp

[Elliott]

I dont no how the photo album works but you can trim a string by using a
combination of Len, Left and Right commands in SQL
You could use this SQL statement in a recordset or database:

Right(Left([Field],(Len([Field])-4)),(Len([Field])-11)) AS NewField

(there is probably a more simple way, but this is the one I have used
before)
this will also take into account the varying lentgh of the filename

Tom
[url]www.telliott.co.uk[/url]


"baldaggie" <webforumsuser@macromedia.com> wrote in message
news:bfdpp0$elr$1@forums.macromedia.com...

> I am using web photo album 2.1 to generate thumbnail and photo viewer. In

the template I am using for the photo viewer, I would like to display the
file name associated with the photo. For some reason they didn't put that in
as an option. They do allow for inputing a description, but I want to
automatically generate the filename to display. What I have found is that
"photo-image /" will return the filename in the form of
"images/filename.ext". I just want to display the filename with no ext and
without the images/ in front of the filename.

>
> How now brown cow ?
>
> Thanks...
>
> mjp
>
>