Jump to content
Sign in to follow this  
oleung

Using GetAs to retrieve container field

Recommended Posts

Hi,

I am seeking help on the proper way on using the GetAs function in FQL.

Recently, I am checking the possibility to retrieve container field content and put in on web page via the JDBC connection to filemaker server. From my observation and testing carried out so far, the result is not too promising.

It would be helpful if someone can give me a hand on this.

Thanks,

Oliver

Share this post


Link to post
Share on other sites

Not entirely sure why you want to turn to FQL (internal FileMaker SQL) for displaying something externally to FM...

You may want to look at the XML API to retrieve pictures and display them.

Share this post


Link to post
Share on other sites

The main reason here is because we are using Coldfusion application server here and JDBC connection is the mean to get data from Filemaker.

We are looking at the way to retrieve content from Filemaker using FQL (internal FileMaker SQL), it sounds like it is supported from the FileMaker documentation but not working as expected in testing.

Oliver

Share this post


Link to post
Share on other sites

Hi, everybody.

I am still looking for the proper way on using the GetAs() function in Filemaker. As I need to retrieve content from container field such as JPEG and PDF etc.

For similar case, using MySQL database's BLOB field type is pretty straight forward under the same situation but in FileMaker, this is quite a challenge. I am querying if GetAs() is the right function to retrieve binary data in FileMaker.

So far, I am trying Filemaker 11's JDBC and ODBC without success. Any clue here?

Oliver

Share this post


Link to post
Share on other sites

Oliver are the images & pdf stored in FM or referenced by FM? I always had these stored where the Web server could find them and just used normal links to them. I work in ColdFusion.

Beverly

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.