473,325 Members | 2,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Selecting part of an image and storing it in an ODBC data source

Hello!

What I need to do is this:

"On the fly"....

1. Select part of an image provided by the user (i.e. define a
thumbnail)
2. Store this 'thumbnail' in an OLE field in an ODBC database (created
in Access 2000)
3. Be able to retrieve this thumbnail from the OLE field at a later
date and display it.

I realise that this is quite an involved problem but I would be very
grateful for any parts of the solution, if not all, as I am currently
new at php...

Thanks very much!

Al
Jul 17 '05 #1
3 1782
On 20 Sep 2004 07:12:22 -0700, al**************@gmail.com (Al Findlay)
wrote:
What I need to do is this:

"On the fly"....

1. Select part of an image provided by the user (i.e. define a
thumbnail)
2. Store this 'thumbnail' in an OLE field in an ODBC database (created
in Access 2000)
3. Be able to retrieve this thumbnail from the OLE field at a later
date and display it.

I realise that this is quite an involved problem but I would be very
grateful for any parts of the solution, if not all, as I am currently
new at php...


I fear you may find you're not going to get very far asking for
solutions like this. Most people have spent a great deal of time
*learning* PHP for themselves, and get a bit annoyed when people turn
up and say "I want to do XYZ... how do I do it?"

The PHP website is very good for finding your way around the language,
and the O'Reilly PHP books are very good to get you started.

Jonathan Beckett (jo********@pluggedout.com)
working on : http://www.pluggedout.com/penpals
Jul 17 '05 #2
Jon Beckett <jo**********@yahoo.co.uk> wrote in message news:<35********************************@4ax.com>. ..
On 20 Sep 2004 07:12:22 -0700, al**************@gmail.com (Al Findlay)
wrote:
I fear you may find you're not going to get very far asking for
solutions like this. Most people have spent a great deal of time
*learning* PHP for themselves, and get a bit annoyed when people turn
up and say "I want to do XYZ... how do I do it?"


True - this is why I said part of the solution would also be
appreciated. I've always found learning by an example that gets
striaght to the point a lot easier than trawling through books and
tutorials.

Maybe I'm just lazy ;)

Al
Jul 17 '05 #3
I noticed that Message-ID:
<ee*************************@posting.google.com> from Al Findlay
contained the following:
1. Select part of an image provided by the user (i.e. define a
thumbnail)
Where will it be defined? Will it be the same for each one? Simple
resizing is quite easy.
2. Store this 'thumbnail' in an OLE field in an ODBC database (created
in Access 2000)
No need. Save it as a file and simply put the file name in the
database.

Also...you'll find that the lack of a LIMIT command can make the SQL
more complicated. Consider MySql and phpMyadmin.
3. Be able to retrieve this thumbnail from the OLE field at a later
date and display it.


Simply retrieve the filename as a variable, stick it into an <img> tag
and Robert is your mother's brother.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
1
by: Bj?rn Terje Svennes | last post by:
I'm using ODBC to interface a Microsoft SQL Server 2000. One of the operations involves placing files within BLOBs. I'm using the image data type for this purpose. Most of the time this works okey,...
5
by: Alec | last post by:
Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network...
10
by: John Smith | last post by:
I know that uploading an image to a database has been covered, oh, about 3 trillion times. However, I haven't found anything covering uploading to a MySQL database with .net. Please don't...
13
by: Neo Geshel | last post by:
I have examined about 80+ different upload scripts on the 'net, both in VB and C#, and none seem to do what I need them to do. Perhaps someone here can point me somewhere that Google hasn't...
4
by: serge | last post by:
I was working on figuring out where a certain application was storing the multiple selection choices I was doing through the app. I finally figured out that they were being store in an IMAGE data...
2
by: somersbar | last post by:
im trying to get a basic ASP.NET application running. im trying to display data from a microsoft access database on my web form. im trying to bind the data to a data-grid. but i get the following...
2
by: amritranjan | last post by:
This is my Jsp code for image upload in database: -----------Upload.jsp---------------- <html> <head> <title>Account Details </title> </head> <body bgproperties="fixed" bgcolor="#CCFFFF">...
1
Curtis Rutland
by: Curtis Rutland | last post by:
How To Use A Database In Your Program Part II This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.