ctaylor

I'm not sure the best way to ask this question so I am going to give an example. I have about 50 users that belong to about 5 groups. I do field by field access by testing for the client's username in CDML. Is there any way I could add a field to the web security database that contains what group they belong to and test for that instead of thier user name? This would save me a ton of time setting up the in code security. Thanks in advance. Chris

We have just run into a major problem. Currently when adding or editing a record if the string sent to the server is over a certain length (not sure the exact length) an error is returned. I have taken a look at another database that doesn't have this problem, so I know there is a way around this. I am currently having my form display the results page to show the user the added record or the changes made. This isn't how the other one is done, but I don't see why this would make a difference. Any help would be great. Thanks in advance. Regards, Chris

The first option I had was completely blank with which I hoped to accomplish the same thing as you with the "Choose sort order". I tried adding that just in case there was a diffrence, but I got the same result. Only the first sort option "bug number" works. If I comment out that option and have "severity" as my first then that is the one that works perfectly. There just seems to be a problem with having multiple search options. Thanks in advance. Chris

Every time I post a question I think it is the last thing I am needing to know to finish this project. I was asked to have multiple sort options on the form I currently have. I need to be able to sort by record number and two other fields, but not restrict the user to have to use these sorts. This is the way I tried it, but only the first one works. <b>Sort By Bug Number:</b> <input type="hidden" NAME='-SortField' value="Number" size=2> <SELECT NAME="-sortorder"> <OPTION selected> <OPTION>ascending <OPTION>descending </select> <b>Sort By Severity:</b> <input type="hidden" NAME='-SortField' value="Severity" size=2> <SELECT NAME="-sortorder"> <OPTION selected> <OPTION>ascending <OPTION>descending </select> <b>Sort By Frequency:</b> <input type="hidden" NAME='-SortField' value="custom=Frequenecy List" size=2> <SELECT NAME="-sortorder"> <OPTION selected> <OPTION>ascending <OPTION>descending </select> Thanks in advance. Regards, Chris

Got it and thank you all again. Chris

I ment to reply earlier, but things got busy. To display relational records do you have to have them in a portal? The database I am working with does not have them in a portal. I didn't design the database, just working with it. Thanks in advance. Chris

I have yet another question. In the project I am working on I am displaying values from the main database and need to display fields that get their values from a second database. I have tried all I could think of to display them with no luck. Are you able to get these values from the main database or do you have to get them from the second one? And if so how do you change which database you are getting the values from? Also, totally different subject. Are you able to access zip files in container fields from the web? Clueless on this one. Thanks in advance. Chris

Thank you all very much. Chris

Is there anyway to test a field in a database for contents before displaying some HTML code? Example: I am trying to test to see if there is an image in one of my fields before I put a link to that image. Some of my records will have images and others won't and I don't want some of my records to have bad links. I tried doing a boolean test on the field hoping that filemaker would return a true if an image was there and a false if not. That didn't work. I would appreciate any idea. Thanks in advance. Chris Taylor

Thanks to you both, help me out. Chris

I have experiance with web development and filemaker, but have never used them togeather. We lost the book when my department moved locations, so I have little to nothing to refer to. Is there anywhere to refer to to get a list of syntax, commands, or anything else along those lines? Thanks in advance. Regards, Chris [This message has been edited by ctaylor (edited November 24, 2000).]