pdbe

Hello Hopefully someone can help with this record level security problem which is basic stuff but I haven’t found much to help on the internet. I use ‘Require Exact Match when Searching records’ all the time and it has caused no problems however I seem to have got stuck trying to use the ‘when Updating records’ option with a FileMaker 9 database. I have simple input and response pages to test the feature, the relevant code from each is shown below. To simplify things I’m only requiring that the Username field has an exact match when updating. input.lasso ((4 field inputs...)) update.lasso [inline: (Action_Params), -Update, -Database=’mydatabasename’, -Table='User_Info'][/inline] [Action_Params] in the above inline returns this: array: (pair: (-update)=()), (pair: (-database)=(mydatabasename)), (pair: (-table)=(User_Info)), (pair: (-keyfield)=(ID)), (pair: (-keyvalue)=(282)), (pair: (-operatorlogical)=(and)), (pair: (-maxrecords)=(50)), (pair: (-skiprecords)=(0)), (pair: (-op)=(bw)), (pair: (Username)=(SCH073)), (pair: (-op)=(bw)), (pair: (Entrymessage_viewed)=(No)), (pair: (-op)=(bw)), (pair: (Copy_links)=(Yes)), (pair: (-op)=(bw)), (pair: (Gov_allow)=(Yes)), (pair: (-op)=(bw)), (pair: (Gov_pdf)=(No)) It is passing ‘SCH073’ which is the exact username to the Update inline. The update works if I uncheck the ‘Require exact match when updating records box’ and when I check it I get “-9960:The field "Username" has been marked as "exact update" and the restriction was not met.” Thanks in advance for your help.

I want to add a field validation which says that only one record in the database is allowed to have the value 'YES' in the field (or no record has the value 'YES') and all the others must be 'NO'. Can this be done using a calculation to validate the field? Thanks in anticipation.

I hope this is just a syntax error, but I am using Lasso's File_Stream tag to deliver PDF files and have a problem with the -Name part: Text before a field works: [File_Stream: -File=( Field: 'filestream' ), -Name=( 'randomtext ' + Field: 'Title' ), -Type='application/pdf'] and gives eg. "randomtext documentone" as the filename But what I want is some text after the field: [File_Stream: -File=( Field: 'filestream' ), -Name=( Field: 'Title' + '.pdf' ), -Type='application/pdf'] This returns an error rather than giving eg 'documentone.pdf' as the filename. This is the error returned: Error Message: No tag, type or constant was defined under the name null->replace with arguments: array: ("), (") Error Code: -9948 Thanks for your help!

Thanks that's it

I am using FM6 with Server 5.5

I have a calculated field which I want to be the field 'Title' with all occurrences of some characters (spaces, apostrophes, commas etc.) removed. This has worked fine when only substituting one character but I cannot make it work when I want to remove more than one character. I have tried: Lower ( Substitute ( LeftWords( Title ; 3 ) ; [" ";"_"] ; ["'";""] )) >ERROR: 'Field cannot be found' and nesting: Lower( Substitute ( Substitute( LeftWords( Title , 3 ) , "_" , "" ) ) , "'" , "" ) > ERROR 'Too few seperators' Neither works. What am I doing wrong? Thanks for your help

I have a search form which I want to return records with any (OR) of the selected sections AND the specified unit Where and how can I enter the -OpBegin and -OpEnd tags? I've used the {brackets} to give an idea of what it needs to do: [inline: Action_Params, -Database='dioexp', -Table='Web', -KeyField='', -Show] {BEGIN AND} {BEGIN OR} [Value_List: 'section'] [if: (Action_Param: 'section text') >> Value_ListItem] [Value_ListItem] [Else] [Value_ListItem] [/if] [/Value_List] {END OR} {END AND} [/inline] [/form] Thanks for your help!

This should be easy but I'm not sure of the function to use: I want to define a calculation field to return one value if there exists one or more records with a specified string of text in a specified field value, and another value if no records have that specified string in that field. For example: " There are no records with 'John Smith' in the field 'Customer Name' " or: " There are one or more records with 'John Smith' in the field 'Customer Name' " i.e. something like this calculation but to search the field 'CustomerName' of EVERY record: If(CustomerName="John Smith", There are..., There are no...)

If, in FileMaker, I have two valuelists, eg Section and Subsection, I then make a valuelist with the values of Section and another with the related values of Subsection (Using a relationship Section=Section), then I can enter Find mode, choose a section from the dropdown valuelist then choose in the subsection field from only the subsections that are in that section. How do I do this on the web with a Lasso search page? I presume some processing needs to happen in between the Section being entered in order for the subsections values to be updated? Thanks for your help

I'd like to include an image file stored in a FileMaker container field, 'schoolimage', in a FileMaker database, 'Schools' on the record detail page. So, following the description in Omnipilot's language guide, I have created a file, 'schoolimage.lasso': ********** [inline: -Database="Schools", -Table="Schools_online", -FindAll][Records][Var: 'Bytes' = (Database_FMContainer: 'schoolimage')]...[/Records][/inline] [inline: -Database="Schools", -Table="Schools_online", -KeyValue=(Action_Param: 'ID'), -Search][File_Serve: (Database_FMContainer: 'schoolimage'), -File='schoolphoto.jpg', -Type='image/jpeg'][/inline] ********** and then put an image link on the record detail page: ********** <img src="schoolimage.lasso?ID=[KeyField_Value]" /> ********** But schoolimage.lasso always returns the error: Error Message: Error: Field not found or enabled. Error Code: -1 The field 'schoolimage' was added to the database after the snapshot was created but it was refreshed to include it. Can anyone suggest the problem? Thanks for your help.

I am very new to using Lasso and am in the process of moving our site over from CDML. I hope someone can help with this query which I also hope is a basic one: Two databases, one where each record is an Event; another where Client creates a New Record as a Booking for one of the Events in the first database. Scenario: Client browses Events database, then has link to an "Add New Record" page in the Booking database, with two of the fields from the record they were looking at Events database having been entered into two of the fields in the Booking database. I could possibly call a script in FileMaker (set Global Values to two other fields etc.?) but how do I do it with LDML? Global Values? A Session?? Tokens??? This is probably a very basic query but I am new this week to LDML and currently trying to wade through Omnipilot's manuals, if anyone could post the required code that would be great, if not point me in the right direction? Presumably once I know how to copy the contents of fields between databases in LDML that is a little way towards creating a DB of registered users, but one step at a time! Thanks for your help

Thanks, but I think this is what was suggested last time. It makes the page "default" to the 'Find All' button - it's selected when the page loads - rather than the 'Search' button which does solve the problem of a 'Page cannot be found error' *BUT DOESN'T* solve the problem of a person who types in a search criteria then hits enter - this justs performs a Find All again - they still have to actually click on the button. The only way I managed to get it to search by hitting enter was to first type in my search, then click outside the text box so it wasn't selected (i.e. cursor wasn't flashing in it!)then hit enter! Why should it only work if this is done??? There must be a solution?? http://216.168.37.92/peterb/Schools/search.htm if you want to check it out - it has the additional line. Thanks again

This is an annoying problem I've never fixed: When searching, after entering their search criteria, if a visitor hits the enter key instead of clicking on the Find button it doesn't work but comes up with 'Page Cannot be Found' I seem to remember looking at this a while back and was advised then to add a piece of code which made hitting the enter key work but stopped clicking on the 'Find All' button (which I want to keep) from working. Is there a method of making the Enter key submit the request whilst still allowing a visior to click 'Find All' instead? or if not, is there a method of suppressing hitting Enter from submitting the request? For an example of a page in question: www.peterborough-education.org/Schools and click on 'Schools Database' Many thanks for your help.

Another problem with the events booking system: I created two fields, 'password' and 'passwordconfirm' I set both fields to require a value and I set the validation of 'passwordconfirm' in FileMaker with a calculation: passwordconfirm = password but that doesn't seem to work, the system allows different passwords to be entered - do I need to select 'Validate only if field has been modified' in the calculation if FileMaker or have a validation calculation on both fields??? Thanks

I am making a system using CDML for booking places on events. I have a page at http://216.168.37.92/peterb/eventbooker/client_search.htm which allows the visitor to enter their booking reference and password to view the status of their booking but there are two problems with it: 1. The search needs to only return the record if the visitor enters the booking reference AND the password correctly. I've put <INPUT TYPE="hidden" NAME="-lop" VALUE=AND> in the file but if they leave the password field blank (or the reference!) How can I force this behavior?? I've tried a couple of scripts to combine the two fields into one and then search with that with no success yet and setting the "-lop" value to "==" doesn't do it either As a temporary measure I've had to ask clients to combine the two themselves into a field which isn't satisfactory 2. When the file is returned I want to include a "field within a field" - So in the dropdown valuelist (itself a field) our staff will use to choose the status of the booking each value includes the name of the event. I have tried using the ,format and ,raw commands with no success, it just returns, for example 'Booking Reserved for [FMP-Field: Event]' To see the raw search results file go to: http://216.168.37.92/peterb/eventbooker/client_search_results.htm The example booking that's on there made has this reference number: 802469128500 and this password: test Many thanks for your help

I've used the mailto- tag to email our office with the details of the booking each client makes, which works great but I want it to also send an email to the client themselves as well, using the email address they've just entered in a field. If possible the version of the email sent to the client needs to be different to the version we get - is it also possible to have two text files with the email content - or even html files with links??? I see that I can either use a metarefresh (tried this and didn't seem to work, it displays a conf of the details OK but doesn't send any mail) or an inline action... here is what I have written: [FMP-InlineAction: -db=eventbooker.htm, -mailto=x@y.org.uk, -mailBCC=[FMP-Field: Client Email], -mailfrom=x@y.org, -mailsub=Booking Confirmation, -mailhost=mail.xy.org, -mailformat=mail.txt, -view] [/FMP-InlineAction] but whereabouts do I place it? I haven't used an inline tag before. I put it in the body of the file but the second half of it just appears as text when I navaigate to the page. Finally can the confirmation screen the client sees confirm the details he has just entered? This isn't too important if it's tricky. Thanks for your help it's really appreciated

So I need to open our local database in FileMaker and change the font etc. in the layout then upload that version to our webhoster to should reflect the changes? There's no way of setting what the fomat will be in the HT / CD ML ?

As a newcomer to (the soon to be defunct it seems) CDML these questions are probably obvious, but: 1. When using the format tag ( as in [FMP-Field: Adress, format] for example ), how do I set what that format is? It works fine in that the carriage returns the visitor enters appear when we view the record but the text seems to come out in differenct sizes with different pages/databases. 2. Could you point me towards any help with sending mail when a visitor creates a record, ideally to send them a confirmation with the details they entered and to send us a slightly different version with that information - I know it's just a CDML action but if there's a site or a post with details on how it is done it would be helpful to read before I start Many thanks