Hot Topic (More than 10 Replies) Image Searches (Read 2262 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Image Searches
Mar 22nd, 2005 at 7:10am
Print Post Print Post  
Hi -

I read a lot about image searches, however, I haven't found anything yet that will accomplish what I need (or perhaps I should say that I haven't been able to use what I read to come up with my own solution).

Basically I want to identify any record with an image layout element that does  not contain a path to an image.  Once identified I can print out labels for a photographer - who will know which people need to have photograph's taken.

Any suggestions for a solution?  Thanks!

  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Image Searches
Reply #1 - Mar 22nd, 2005 at 7:37am
Print Post Print Post  
No one else should up at this hour but me......

Can't do the code now, packing it in.....

Don't recall syntax right now, but something like this ?
Code
Select All
var vTemp as String
vTemp =  @Label(PictureElement)
if vTemp = "" then {
     @msgbox("Missing Image Path","","")
}
 



Suggestion for future:
Add a Yes/No box to fill in when Path is added.
On Form Exit/ImageElement Exit, can do check for condition of Yes/No and path exists for the image element.
-------------------------------------------------

Good night, and good luck!
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Image Searches
Reply #2 - Mar 22nd, 2005 at 1:59pm
Print Post Print Post  
Spencer,

On your Retrieve Spec, click in your Image Element and press Space (or double-click) to bring up the Image dialog.

The text box that says "Select an image as search criteria" can actually take any valid search string you want to type into it.

Instead of selecting an image, just type = and click Accept. Press F10, as you will get all the records where the Image is blank. Just like searching for a blank text value.

To get all the records where the image filename starts with Adam, type Adam..

And so on.  Smiley
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Image Searches
Reply #3 - Mar 22nd, 2005 at 2:45pm
Print Post Print Post  
Erika -

Now that's great news and what I was hoping for.  Bottom line is that you CAN do an image search ... just that you need to access the extra 'element.'

It already paid off for me.  I have about 200 images in the directory of people who attended this year's reunion.  The only way I thought I could be sure that I inserted the path in each form was to print a listing of all the pictures on file ... and then check the data base one-by-one to be sure I had selected each one.

Well, I just did a search using = as the criteria, so that I could see all my reccords having pictures.  I came to one that didn't have a picture and wondered if there was a flaw in the selection.  And then I realized, I'll bet there is a picture and I just didn't select it.  So, I kept scanning and sure enough I found about 5 instances where the picture was there, but I missed selecting it for my form. 

So, back to my original question ..... now I can simply retrieve a set of records for which I want to print labels.

Now what could be simpler?!!!

Thanks!
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Image Searches
Reply #4 - Mar 22nd, 2005 at 4:04pm
Print Post Print Post  
Erika -

As I said before, the information you provided gives me exactly what I need.

I have been playing with it a little more, however, and have one question regarding a specific example you gave.

Quote:
To get all the records where the image filename starts with Adam, type Adam..


I tried typing that in the search 'window' and it simply didn't work (and YES I changed it to a name I knew there were several of in the directory [lol]).

It's not really that important because when I click on the directory on the left side of the screen, it is progressively text sensitive.  In other words, if I type the letter B it will take me to the first picture beginning with that letter, If I continue by typing ar ... it will advance to the first picture starting with Bar  etc.

But since you gave the example for doing a wild-card search, I am wondering whether there is something I am overlooking.  I could not get it to work.
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Image Searches
Reply #5 - Mar 22nd, 2005 at 4:14pm
Print Post Print Post  
Quote:
But since you gave the example for doing a wild-card search, I am wondering whether there is something I am overlooking.  I could not get it to work.


It works for me. It will search based on the full filename value stored in the field. If you create a textbox element and bind it to the same underlying field as the Image Element, you will be able to see the underlying value. This may give you a clue as to format your search criteria.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Image Searches
Reply #6 - Mar 22nd, 2005 at 4:40pm
Print Post Print Post  
Erika -

I added a text box bound to the image field, as you suggested, however, I was unable to perform any search (even the = that worked in the image selection window) from there.

I thought that the fact that I had other sub-directories under the PIC directory might be a factor ... so I moved several pics directly to the PIC folder.  Still nada!
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Image Searches
Reply #7 - Mar 22nd, 2005 at 4:42pm
Print Post Print Post  
Spencer,

This is very difficult to troubleshoot blind. Why don't you send it into Support, so we can see what you are doing, what's bound to what, etc.

I know it works in general, so we'll need to see the specifics to determine what you need to adjust for your particular case.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Image Searches
Reply #8 - Mar 22nd, 2005 at 4:46pm
Print Post Print Post  
I never sent a file to support.  Can you tell me how/where to send it.  It might be helpful to them, in case there is a problem not of my 'doing.'

Fortunately, it is not a feature that I can see any personal use for, so I am not particularly concerned.

What I wanted/needed to accomplish worked just fine with the = criteria you previously suggested.
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Image Searches
Reply #9 - Mar 22nd, 2005 at 4:58pm
Print Post Print Post  
Technical Support: support@lantica.com
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Image Searches
Reply #10 - Mar 22nd, 2005 at 10:38pm
Print Post Print Post  
Quote:
On your Retrieve Spec, click in your Image Element and press Space (or double-click) to bring up the Image dialog.
ShockedWHOA!, I never saw that one before.  Thanks for bringing that to the surface, so much new stuff to pick up...... Grin
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged