mortemar

Yes, perfect, now I know exactly which solution to use, thank you very much Jerry

Hi, yes, the Terminal Server is an option I've just been offered by the system administrator. I work for a University so we have a broadband connection, and the users that would need to access the data through FileMaker will be on the same broadband connection, I've tested the solution already and it was fast enough for my users needs The only problem with the Terminal Server is that for a same account, I've been told it only allowed 2 connections, which could actually fit my needs. So, to make things clear just one last time, the final answer would be that FM Server is optional ? I could use only FileMaker unlimited ? As I work for a research group, their budget is a bit limited, so they'll be interested in the "less expansive" solution...though I still think that 800$ is not really too much asking ! Thank you very much for your answers, it's helping me a lot ! Jerry

Hi ! Woah yes, you're right, big mistake I made here. In fact, I forgot parts of my question while writing my first post : The problem I have is the following : I got about 50 persons that can use the inline version to access my FMP databases. But I also got 6 "superusers" 4 of them will have to use the Internet version, but 2 of them want to keep using the FMPro version. I was wondering if it was possible for these special 2 users to access the databases on FMU through FMPro "remote access" ? I know that using only a fmpro version and opening a database remotely with another FMPro version causes the database to change while the remote user uses it. I was then wondering if I "HAD" to go with a FMS and a FMU version for my needs ? Hope I'm clear enough, and thx a lot for your answer, Jerry

Hi, I need informations concerning FileMaker Pro and FileMaker Unlimited. Is it possible to connect to FMU5.0 using FileMakerPro v5.5 ? Or do I need to upgrade my FMU version ? Thx for your answers Jerry

Hi, don't know if that's what you're looking for, but to access a password protected DB using PHP (ODBC), just use the following : $odbcFMP = odbc_connect("FileMaker", $user, $password) or die("CAN'T CONNECT"); $result = odbc_exec($odbcFMP, $Query); Jerry P.S : $user is probably optional for FileMaker

Hi there ! I found something very disturbing while trying to access my data through an SQL request. The request was built the following ways : Select * FROM Formation WHERE (status = 'student' and university = 'Oxford' and grade = 'first') or Select * FROM Formation WHERE ((status = 'student') and (university = 'Oxford') and (grade = 'first')) even Select * FROM Formation WHERE (status = 'student') and (university = 'Oxford') and grade = ('first') Everytime, FileMaker just did a search based on the last part of the where request (for instance here : grade = 'first'), the results did come right, based on the status and university field also, but everytime I took a look in FMP the search always happened on the last field. This is quite a problem to me, as when retrieving over 500 records, the ODBC driver takes a long time to bring back the result set. Most of the time, the SQL request shouldn't generate more than 50 records found in FMP, but I always have numbers according to the search on only one of my select field. Anyone ever had this problem before ? Is my SQL request bad ? Thx in advance, Jerry

forget that, I found the answer, it was quite stupid actually, just used a calc field with the state of the actual record. I suck, deeply :S Jerry

just a precision note, I need to know if I can retrieve the record ID through odbc, not if I can query using the rec id (though they probably are related problems) thx

Hi there, I don't quite know where to write this post, so I hope here will be ok I was wondering if it was possible to have the equivalent of [FMP-CurrentRecID] using odbc. I'll explain myself : using [FMP-CurrentRecID], I'm able to easily edit, delete or display details of a particular record. The problem is, I also want to retrieve all data from my FMP, using odbc, and still access the data throught the file ID. Is that possible ? Is there a way to ask for the record ID using odbc ? Thx for your answers, Jerry

Thx Jeff, I actually found out how to make things work, for example, if I need to do a search on a student supervisor and say the year of the obtention of the diploma, I just build my results.htm file like this : [FMP-If: (Field:direction.cn.name).and.(Field:direction.cn.surname).and.(Field:Depot_final_ann.cn.1992)] and it works great. So thx for your suggestion, it was the good one Jerry

Thx a lot for the suggestion, I didn't know that the "Field:" was optionnal But actually my problem was of a different nature, I didn't think about the latin accented characters, I tried to substitue an "

Hi there, I got a little problem bothering me for a while now, I've tried everything to fix it, but I'm still stuck, need help please ! Here goes, in my result file I need to simply check if the value in a field is equal to a certain value, an example will be easier : [FMP-If: Field: etablissement.cn.Centrale des Syndicats (CDS)] As you can see, my value is composed of multiple words, so I tried to fix everything using this form [FMP-If: (Field: etablissement.cn.Centrale) .and.(Field: etablissement.cn.Syndicats).and.(Field: etablissement.cn.(CDS))] Problem is, even if the value in the field and my literal value match, my If rejects the value. Am I doing something wrong ? Funny thing is that for a 2 word literal value, it does work ! Hope someone's going to be able to help me. Thx a lot, Jerry

That's what I did, using two global variables, and it worked. The solution was given to me in a previous message, but I didn't find it before writing my post. Thx a lot for your suggestion

Forget that, I found my answer by reading a recent post... global variables, that's all I needed. Thx

Hi there, I got a little problem trying to run a script. Using two databases, I need to update one of my database using the values contained in the other base. So here goes I loop through the records in my first database, let's call it base1, for every record in the base, I have to see if it exists in the other base "base2". So far no problems. So I call an external script from base1 located in base2. Basically, what the second script does, is just looping through every record in base2 to see if I've got a match. My problem is this, when the second script is running, I have to check if two fields, one in each databases, are equal. But, it seems that when I try to access data from my first base, it only gives me access to my first record. As my explanation is unclear, even to me, I'll give an example. Here goes my first script (base1): Go to Record/Request/Page [First] loop Perform Script [sub-scripts; External: "base2"] Omit Record Go to Record/Request/Page [Exit after last, Next] end loop my second script is something like that : loop if [(field1 = base1::field1) and (field2 = base1::field2)] //some treatment end loop if ("1") //I just want to get off my loop...and script else Go to Record/Request/Page [Exit after last, Next] end if end loop it works fine, except it only compares the first record in base1 when running the script in base2. How do I get the script in base2 to actually check value in the other records in base1. Still not clear, just tell me, I'll do my best to explain it better (lack of english words is not helping ) Thanks to all who'll try to help me solve my problem, Jerry

thx all for your answers. I think that I have a very good idea on how to proceed now. Thx a lot, Jerry

ok, but then, what's the use of the web connector ? If the requests have to be done on 591, isn't that like using a webserver on port 80 and sending requests on companion port ? I have trouble understanding what the webserver connector actually does. I've been trying to find some documentation, but I haven't been lucky so far. thx for your help, Jerry

I'm thinking about getting FileMaker Unlimited, but I wonder if it offers the functionnality I need. I've been trying to get information on WSC, but didn't find enough to be satisfied. My question : with WSC, is it possible to "integrate" CDML within a PHP page ? I want to be able to do some treatment like : /* <?php $someArray[0] = [FMP-Field: someField]; ?> */ Can someone tell me if this is possible using wsc ? I've only been able to find info about wsc and ssl thx, Jerry

Pretty much ! What I need is for the user to be able to select fields to be exported, and then format the output into a file such as : data1;data2;data3 data1;data2;data3 I've read that script and CDML wasn't a good option when multiple users can access the database simultaneously. Using php I was able to create an export file, but I had to use an apache server and go with sql queries. What I'm trying to find out actually is if I could do the same using the FM webserver and CDML+javascript(eventually) Thanx for the suggestion anyway ! Jerry

Hi there, is there a way to export records using CDML ? I need to enable "exporting" as offered within FileMaker ( a .tab file). Any idea ? I've been developing a solution using odbc and sql requests, but I was wondering if there existed a faster/easier solution with CDML. Thx, Jerry