Multiple Image files

L

lothos12345

Well-known member
Joined
May 2, 2002
Messages
294
Location
Texas
I have an Access Database with 3 fields and one of these fields contains the filenames of images. Now assume all the image filenames are going to be the same in character length. An example is below:

--Fields
Name Age Image

--Data
Joe Test 22 00010


The problem occurs in the fact that one record can contain mulitple images. An example is below:

--Fields
Name Age Image

--Data
Joe Test 22 00010000110001200013

Now assume that every new file will start with the number 0. I need to be able to move the data from Access to SQL Server and move the images to a seperate fileserver renamed using GUID removing any "-", and the correct indexing information for the newly named images must be in the SQL Server for the record they are associated with. How can I account for the possibility of mulitple images in one record. A programming example of how to accomplish this would be greatly appreciated.

Just as a note the images are .tifs
 
Suggestion

It has been suggested to me that I parse out the string that the image filenames has been assigned to and load it into an array. I not quite sure how to accomplish this any help would be greatly appreciated.
 
The proper way to do this is to create a new table to hold the image names, then join this new table with the original table.

this would be your structure:

User_table: (Original table)
ID | Name | Age
1 | Joe Jones| 22
2 | Tom Smith | 25

Images_table: (new table)
User_Table_ID | Image
1 | 00010
1 | 00011
1 | 00012
2 | 00010
2 | 00018

This allows you to re-use an image for many users.

Your select would look something like this...

SELECT User_table.ID, User_table.Name, User_table.Age, Images_table.Image
FROM Images_table INNER JOIN User_table ON Images_table.User_table_ID = User_table.ID


Lets say you wanted all images for Joe Jones you would do this...

SELECT Image
FROM Images_table INNER JOIN User_table ON Images_table.User_table_ID = User_table.ID
WHERE User_table.Name="Joe Jones"
 
Okay

I understand but how to I parse out the file names in the orginal table. For example make:

Image
0010100102

into two seperate entries in the new table like so:

Image
00101
00102

How would I accomplish this programmatically.
 
You cant really do it with any accuracy, if you had a comma or another charachter between the numbers then it would be easy using the Split method. As it is now you can look for 2 consecutive zeros but it is certainly not full-proof.
 
Assuming the length of the names is equal you could use the regular expression class to solve the problem.

First of all you have to import System.Text.RegularExpressions
Code: 
Dim mRegEx As Regex
Dim myMatches As MatchCollection
Dim M As Match

mRegEx = New Regex("\\w{4}") assuming the names length is 4
myMatches = mRegEx.Matches([I]Imagefield[/I] )
For Each M In myMatches
	assign M.ToString to the array holding the names of the current record
Next
Hope this helps.
 
Back
Top