Bleppe

Hi You can use the -Max tag to define maximum number of records to display pr. page (in your case 10). Each 10 records is called a set of records. Now you can use the [FMP-LinkNext] and [FMP-LinkPrevious] CDML tags to navigate through the different pages (sets) of records. To create a link to the next set of records use this code in the HTML file containing the CDML for displaying the search result: [FMP-LinkNext] Click here to display the next 10 records [/FMP-LinkNext] THe same goes for previous set. Good luck! BLeppe

Hi Thomas In the HTML page, you have defined by your -Format tag (in your case the "Thank You" page), you just ad [FMP-Field: UserNumber], "UserNumber" being the field, wherein you store the user number in your DB. I also think you need to define the layout using the -Lay tag, to make this work. - Suddenly I'm in doubt wheter this advice is correct. Well, you can try it out anyway (I can't test the advice myself, because my db-server is down at moment). Hope it works - otherwise, I'm sorry! Bleppe

Thank you both - I'll dive in to a HTTP code list to decode the log! Thanks again Bleppe

The great thing about FMPro (<= 6.0 anyway) is that it's for people with a balanced use of both the left and the right side of the brain. You don't have to be a programmer to make it work - even as a webserver when using CDML. It's easy to understand how it works. And you don't have to be a super-creative designer to make solutions and GUI's that works for average users. That's why I fell for FMPro. PHP? ASP? - No way. I've been forced to use limited PHP/Java scripting to make my solutions work on the web, but writing a full PHP solution? I think I would hate as much as I hated trying to learn BASIC back in the old days... That's just not how my brain works. Why couldn't they have made a plug-in/checkbox/setting/drop-to-convert that allows us to use good old CDML (with the limitations it has) and then keep the "amatuers" as a market? FMPro is the only db alternative for a company with limited manpower and ressources, as far as I am concerned. Just my input.... Bleppe

During development of my FMP5 db to be published on the web (using CDML) I checked the selection to log all access to the db. 2 questions: 1) What does the last two numbers (200 2568) in the example below refer to? xxx.xx.xxx.xx - [29/Mar/2004:14:18:40 -4114] "GET /pix/logo.gif HTTP/1.1" 200 2568 2) The db is open to external access - but passwordprotected until the solution is deployed. No one but me knows where to find the entry-point. When I read the access log I can recognize the ip's I've used to test the solution, but sometimes I see an entry like this: xxx.xx.x.xx - - [27/Mar/2004:18:25:37 +0100] "GET / HTTP/1.1" 302 0 - from ip's I've never heard of. Only one line pr. ip, and always the same action: "GET / HTTP/1.1" 302 0. Sometimes maybe 30-40 entries from 30-40 different ip's. Is this some sort of innocent nameserver ping'ing me, or is someone trying to get access to my data by scanning ip's for FMPro access?? Thank you Bleppe FileMaker Version: 5 Platform: Mac OS 9

So it is only the reading of the cookie by FM that is unreliable? Not the SetCookie? If that is true, then I'm happy with my solution... Thx Bleppe

Thank you Koen! That thread actually describes the idea, I'm working on right now..! Happy to see, that others had the same idea! I must be going in the right direction.... Bleppe

I've read several threads about setting cookies with FM / CDML. It seems that nobody trusts FM to do that task and always suggests using javascript to do it. Whats is the problem with using [FMP-SetCookie]? I've made some code that sets the cookie from FM using [FMP-SetCookie] and it seems to be working fine. I wanted to use javascript, but my problem with javascript is that when I set the cookie with a value from CDML [FMP-Field: blabla] inside the javascript, FileMaker doesn't replace the value, using the value from the field "blabla" - javascript simply sets the cookie value to: [FMP-FIeld: blabla]! What am I doing wrong? And why shouldn't I use [FMP-SetCookie]? Thanx Bleppe FileMaker Version: 5 Platform: Mac OS 9

Maybe your "flag"-field could be an automaticly created creation date and time? Perform a find based on some field that is uniqe for the two records (original and dup) and specify a sorting that will show the newest first on the html page containing the CDML? Depends of course on wether it is possible for you to run a -Find after the duplication... Bleppe

I've been developing FM db's on and off for the last ten years - the last two years a lot. So I've done my share of sophisticated scripting, relations etc. I feel like I know a lot about FM, but here's my problem: I am developing a solution for an image-agent company (cumstomers are supposed to search and buy images on his website). Searching, sorting, ordering, log-in etc. is supposed to be performed by the FM (5.0 on MacOS9) via CDML. Links to downloads of the images/files bought on the website (placed on another server with a different ip) are delivered by the DB - including a Javascriptet cookie read by PHP on the download-server. This is because the files take up >20GB in all, and I don't want to slow my FM solution down or limit the bandwith for the FM server with several 10-20 MB download sessions each hour. So far so good... The cumtomers will be provided with an account, in which they will be able to review, say, the last 10 ordered items (with links to the downloadserver) for 7 days. This requires some sort of log-in feature. I don't want to use FM's build in access priv. because I need to have both a username and a password (hopefully 100's of users). How do I do this, without leaving the usernames/passwords exposed for everybody, who knows how to "sniff" informations from a FM db? I've read some threads about creating two fields - one with username - one with the password. Perform a search based on user-input - if the record exist, set a cookie with JS and log them in. But what is keeping other FM-geeks from writing three lines of html to sniff out all the records of that db? I know, I could, anyway... I have some other ideas on how to solve this problem, but I would like to hear your input before writting half a book here. Thanx! Bleppe Version: v5.x Platform: Mac OS 9