Hi All,
I have a large database (5000+ records) and want to associate an image with each record. Inserting the images into the database itself as binary blobs was not the solution as it led to a huge database file and very slow reaction times. Instead the images are in a directory accessible via a webserver. I can store the URLs of each image as a text field in each record.
What I want to do is create a subform in a general record form, passing to it the URL field for the image from the Main form, and get the subform to query the webserver via a HTML GET, and then display the image as an ImageControl object. I assume from the fill-in fields on the `General' tab of the properties of the subform that this should be possible, but just can't work out how to pass the URL field, and make it do the web query. Has anyone done something like this?
As it happens, it seems that separating out images in this way must be a common solution to incorporating large images into the database. Is there a better way to do it, other than to add them into the hsqldb database directly?
Thanks in advance,
Cam
Embedding image in form from subform using HTML GET
Creating and using forms
-
- Posts: 1
- Joined: Thu Aug 21, 2008 3:53 am
Jump to
- Getting started
- ↳ Survival guide
- ↳ Beginners
- ↳ Getting Started Guide for 4.x
- ↳ Getting Started Guide for 3.x
- ↳ Install, Setup and Troubleshooting
- ↳ Admin Guide
- ↳ MS Windows
- ↳ Linux
- ↳ Mac OSX
- ↳ LibreOffice
- ↳ Tablets
- ↳ Tutorials
- ↳ Writer
- ↳ Calc
- ↳ Base
- Applications
- ↳ Writer
- ↳ Writer Guide for 4.x
- ↳ Writer Guide for 3.x
- ↳ Writer Tutorials
- ↳ Templates
- ↳ Advanced Uses
- ↳ Calc
- ↳ Calc Guide for 4.x
- ↳ Calc Guide for 3.x
- ↳ Calc Functions
- ↳ Calc Tutorials
- ↳ Impress
- ↳ Impress Guide for 4.x
- ↳ Impress Guide for 3.x
- ↳ Draw
- ↳ Draw Guide for 4.x
- ↳ Draw Guide for 3.x
- ↳ Math
- ↳ Math Guide for 4.x
- ↳ Math Guide for 3.x
- ↳ Math Guide for 3.x
- ↳ Base
- ↳ Base Guide for 4.x
- ↳ Wiki
- ↳ Base Tutorials
- ↳ Tables & Queries
- ↳ Forms
- ↳ External Data Sources
- ↳ Reporting
- ↳ Database Examples
- Customizing and Extending
- ↳ Macros and UNO API
- ↳ Basic Guide
- ↳ Code Snippets
- ↳ Extension Repository
- ↳ Macro Repository
- ↳ External Programs
- ↳ Extensions
- ↳ Extensions page
- Community
- ↳ General Discussion
- ↳ Site Feedback
- ↳ Forum Governance
- ↳ User Experience (UX)
- ↳ Announcements
- Business
- ↳ Institutions & Educational
- ↳ Paid support
- ↳ Consultants Directory