CWP-problems

[machaut]

Hi there!

I´m beginning to explore xslt stylesheets. I´ve ran into two separate problems at the moment.

1) When I enter foreign signs, e g "å" (I´m swedish) in a field in a search page no records are found in spite of the fact that there are several records that contain this value in the specific field. Something about coding?

2) When trying to edit a record via a detailed record page everything seems to work, the right confirmation page is returned. However, no edit-action is performed in the database.

I have this tag on the detailed page:

but obviosly no record-id is passed to the database.

Some help would be appreciated!

[Martin Brändle]

1. Is the indexing language of the field set to swedish?

2. Can you you post both the pages (search and detailed record) here? Then we can better find out where the problem lies, which is nearly impossible to guess just from one line of code given.

[machaut]

tidbokningresult.xsl

Tidbokning

Välj lärarsignatur:

selected

[Martin Brändle]

1) In all pages, change

<?xml version="1.0" encoding="ISO-8859-1"?> to <?xml version="1.0" encoding="UTF-8"?>

and

to

and save the stylesheets in UTF-8 encoding format (if you have Mac OS X, you can do that e.g. with TextWrangler, Save as, Options)

2)

I assume that you want to show only one record in the details page.

In the details page, there is no definition for the currently selected record, that's why @record-id is empty in the form.

After add the following line:

Change the line

to

If only one record is shown, you can also eliminate the xsl:for-each loops, and use $default-record

[machaut]

Tidbokningen är uppdaterad.

http://130.241.61.216/fmi/xsl/tidbokningsok.xsl?-db=tidbokning&-lay=web&-viewTillbaka

[Martin Brändle]

In the details page, as you requested. But I don't see a -edit there. The problem is, that you can not mix forms and links (well, you can, but don't expect that form will be submitted when one clicks on the link).

Remove the link and add a button with

[machaut]

Tidbokning för 

tidbokningsvar.xsl

Vecka:

Datum: Dag:

9.30-10.30

10.30-11.30

11.30-12.30

13.00-14.00

14.00-15.00

[Martin Brändle]

Hmm. Not sure. Could it be that there is an error in tidbokningsvar.xsl ?

You may add the following after for debugging:

[machaut]

Tidbokningen är uppdaterad.

[Martin Brändle]

Error code 6 according to Appendix B of the Custom Web Publishing Guide means "File is read-only".

Check two things: Does the privilege set used with extended privilege fmxslt allow writes?

Are the permissions of the database set to -rw-rw----?

[machaut]

The database privileges were set correctly, but oddly enough MacOSX had changed the privileges for the file during transfer to the server. With that changed I now get the error code 102 which is "Field is missing". That is very strange since the accurate field content is displayed as it should on all pages.

[Martin Brändle]

Not only the fields that are displayed but also those where finds and edits are done must be on the web layout.

[machaut]

Sure, all fields in the database are on the web-layout.

[machaut]

At last!

The problem was the hidden input which didn´t work. It should look like this:

Uppdatera post

Then everything works just fine.

Martin - danke für deine Hilfe und deine schnelle Antworten!

[Martin Brändle]

Sorry, now I see the mistake that I have made (I just entered it from mind, no tests or comparison with other forms).

This should work as well:

The trick here is that the user just can hit the return key for submission