2. PHPRunner General questions
  3. Image substitution
This topic is locked

Image substitution

 		9/3/2006 8:15:00 PM
PHPRunner General questions
F
 farago author

Hi
Thrilled with latest build of 3.1 - thanks!
Building Book catalog database - trying to figure best way to insert a placeholder file-based image when one is unavailable.
File-based image name is created by combining unique ISBN number with "jpg":
CONCAT(isbn,'',".jpg") as image,


if the image is not found in the directory, I would like it to default to this one


Thanks!
Peter Farago
Thanks for such a terrific product -

See you product profiled 65 bit and soon by Adobe as case history - see preview here:
http://www.65bit.com/products/easycatalog/.../casestudy.shtm
Peter Farago

71 Broadway 11th Floor

New York, NY 10006

212-344-9472
J
 		Jane 9/4/2006

Peter,
thank you for sharing your idea.

We'll add this feature in one of the next PHPRunner update.
F
 		farago author 9/4/2006

Looking forward to it. Thanks -
Appreciate your timely (as always on this board) response -
Here's the script we are using in our InDesign software to do similar task - hope its helpful:
Let me know if there is some work-around in the meantime - would love to get this ready to share with Adobe press by end of September.

<field name = "isbn" key = "true" type = "alpha" stripwhitespace = "true" prefix = "" suffix = "" language = "" stylesheet = "[No character style]" cleansing = "" tagged = "true" contenthastags = "false" ingorewhitespacechanges = "false" imagepath = "H:\Web_Images\thumbnails" imageextension = ".jpg" imagesubstitute = "C:\Documents and Settings\Peter\Desktop\unavailable.jpg" imagescalepercent = "100" imagealign = "centre" imagescale = "proportionally" dbstatement = "Update <Table Name> Set &apos;isbn&apos; = {{VALUE}} where <Key Field Name> = "{{KEY}}"" dbupdate = "false"/>


Thanks
Peter