ddhull

Thanks Martin. Got it! Doug

I have my smtp correct now. I tried this but still get false when trying to send mail through .xsl biz. Thanks again, Doug

In the fmsa web publishing admin console in publishing engine, xslt publishing both "requests and output pages" and "email messages" are set to utf-8. Any other suggestions. The other day I never did get them links to work either. Thanks, Doug

I was trying to use code I found from this forum to send_mail after adding a record. This is my calling page to send the mail. My data gets added the the database but the "email_status" is never true(). Any idea what the problem is, I tried 2 ways of doing this. The 1st way . <xsl:variable name="record" select="/fmrs:fmresultset/fmrs:resultset/fmrs:record[1]"/> <xsl:variable name="subject" select="$record/fmrs:field[@name = 'title']/fmrs:data[1]"/> <xsl:variable name="description" select="$record/fmrs:field[@name = 'description']/fmrs:data[1]"/> . . <td><xsl:value-of select="$subject"/></td> <td><xsl:value-of select="$description"/></td> . . <xsl:variable name="email_status" select="fmxslt:send_email(concat('wangdang4@hotmail.com?from=ddhull@ku.edu&amp;subject=',$subject),concat('The following e-mail is for you: ',$description))"/> The 2nd way . <xsl:variable name="bz" select="fmrs:resultset/fmrs:record[1]"/> <xsl:variable name="email_status" select="fmxslt:send_email('ddhull@ku.edu?from=wangdang4@hotmail.com&amp;subject=Music Connection has received your BOM',concat('Title:',$bz/fmrs:field[@name='title']/fmrs:data[1],'&#xD;','Description:',$bz/fmrs:field[@name='description']/fmrs:data[1]))"/> Then to test if email was sent I do the following: <!-- this checks if e-mail was sent --> <xsl:choose> <xsl:when test="$email_status = true()"> <p>E-mail has been sent.</p> </xsl:when> <xsl:otherwise> <p>E-mail error.</p> </xsl:otherwise> </xsl:choose> Thanks for any help, Doug

Thanks kuma and martin, It seems I am getting nowhere with this. I do have the fields on my layout. I can't get the link to show before my for-each and I can't get my email link inside of the for-each to work either. Would either of you have an example to share. Thanks for the note kuma. I now have what was selected on my index.xsl page showing in an href above my for-each but when I go to select it I get the following instead of the value institutionurl, which is a variable in my database: http://xxx.xxx.xxx.xx/fmi/xsl/$record/fmrs:field[@name="institutionurl"]/fmrs:data[1]" in a new window Here is the code I am using to show the institutionurl: <xsl:variable name="ins" select="/fmrs:fmresultset/fmrs:resultset/fmrs:record[1]"/> <h1 class="bluebold">ECHO Partners at <a href="$ins/fmrs:field[@name='institutionurl']/fmrs:data[1]" target="_blank"> <xsl:attribute name="alt">Link to the <xsl:value-of select="$ins/fmrs:field[@name='institutionurl']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute> <xsl:value-of select="$ins/fmrs:field[@name='institution']/fmrs:data[1]"/></a></h1> Doug

This will show the institution selected in index.xsl as a hyperlink. But it does not show the value of institutionurl, which holds the value of a link brought in from my database, when I get ready to select it. <xsl:for-each select="/fmrs:fmresultset/fmrs:resultset/fmrs:record"> <table width="98%" border="0" cellspacing="4" cellpadding="0" align="center" bgcolor="#FFFFCC"> <xsl:variable name="record" select="current()"/> <xsl:variable name="recordnumber" select="position()"/> . . . <h1 class="bluebold">ECHO Partners at <a href="$record/fmrs:field[@name='institution']/fmrs:data[1]" target="_blank"> <xsl:attribute name="alt">Link to the <xsl:value-of select="$record/fmrs:field[@name='institutionurl']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute> <xsl:value-of select="$record/fmrs:field[@name='institution']/fmrs:data[1]"/></a></h1> Instead when I place my mouse on the link it shows: http://xxx.xxx.xxx.xx/fmi/xsl/$record/fmrs:field[@name="institutionurl"]/fmrs:data[1]" in a new window The other problem is if I take my href out of my <xsl:for-each etc., I get nothing. And I am wanting it above the <xsl:for-each part of my code. Thanks, Doug

For the email href I also tried: <xsl:variable name="thisrec" select="fmrs:resultset/fmrs:record[1]"></xsl:variable> xEmail: <a href="fmxslt:send_email($thisrec/fmrs:field[@name = 'email']/fmrs:data[1])"></a> But still no results. Any help would be appreciated, Doug

Here is the file I am working on. Which is called from index.xsl after an institution is selected. Thanks, Doug peoplefound.xsl.zip

After making a selection on my index.xsl page, in my case an "Institution", I bring up the people found for that institution and display name, phone, email etc from my database. At the top of my page I am wanting to display "Our friends from (and whatever institution was selected being in a href). I am wanting the institutionurl, which is a field in my database, in the actual value in my href. For example, say North Carolina was selected on my index.xsl page, I want the top of my page to show: Our friends at North Carolina. And if selected it goes to www.unc.edu or whatever the link happens to be in the institutionurl field in my database. Here is what I tried, which is the cdml conversion, but nothing shows up after "Our friends at ": <h1 class="bluebold">Our friends at <a href="{$default-record/fmrs:field[@name = 'InstitutionURL']/fmrs:data[1]}" target="_blank"><xsl:attribute name="alt">Link to the <xsl:value-of select="$default-record/fmrs:field[@name = 'Institution']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute><xsl:value-of select="$default-record/fmrs:field[@name = 'Institution']/fmrs:data[1]"/></a></h1> Then I display each individuals info below that. I can display the info below fine in my "xsl:for-each select" section but I can't seem to figure out the needed code for showing the institutionurl field in the href beforehand. ============ Also, when I show each persons email address, which is inside of my xsl:for-each, I am wanting a person to be able to select it and it open up the email client and place this email address in the "To:" line. When I display my data on my web site I use: Email: <xsl:value-of select="$record/fmrs:field[@name = 'email']/fmrs:data[1]"/> Thanks for any assistance, Doug

I think I am there. I will let you know for sure later. Thank you so much for all of your time and help and for all the help you give others on this forum, Doug

Yes, that screen shot is what I am after. No change in database. Thanks for looking. Doug

Hmmm! After enabling database sessions I selected "restart publishing engine" and I also restarted filemaker server admin. Then I even tried shutting everything down, even my computer and I started all back up and still have the same problem. If you have anymore suggestetions please let me know. Thanks again for your help, Doug

Thanks Martin for all your help, I now have database sessions in the fmsa web pub admin console set to enable. As far as biphones, after entering my text and selecting "Calc your entry", I definitely can see that it does what I am after by looking in the xml result tree. The "Output" variable in my database contains the correct results. But I am not able to place the database value of "Output" back on my web page. As far as the echo site, it does do the find and display the info. If you have any more ideas, I would appreciate your assistance, Doug

Hi Martin, thanks once again, Sorry about that, I am wanting to use the link you gave me in a simple index.xsl page to call calc.xsl. Inside of calc.xsl are the forms with the submit button. But instead of submit it is called "Calc your entry". The "Calc your entry" button is what I am wanting to execute in order to bring the text entered on the web site to my database and run a script and then push one value back to my web page. The text I bring into my database is placed in a global text field called "AllWords" and the ending result after my script is ran is also placed in global text field "Output" in my database. It is that ending result in the field "output" I want to bring back to the web page. I attached index.xsl, calc.xsl and the database biphones.fp7 I placed the href in the index.xsl page as you suggested and I get this error: The entity name must immediately follow the & in the entity reference. (XML-0067) File index.xsl Line 36 Column 78 Which is right after fmresultset& Any suggestions? Where would I find these 2 files? cdml2xsl_includes.xsl and cmdl2xsl_utilities.xsl ----------- On a separate note I am trying a similar link. I am wanting a person to select a link that already contains the search criteria. I want it to find the criteria and display the results of Contact, Institution and Email address on the next page which is peoplefound.xsl. So I tried the following: It gives me the same error as my link above. On this page I have 7 links just as above but each one searching for a different institution. Actually, I am trying to use a narrow downed version your multiple.xsl and multiple2.xsl files which demonstrated searching and adding a record. You had posted these files for an individual earlier this year. Instead of multiple.xsl and multiple2.xsl my files are called: index.xsl (which will have about 7 links if I can get 1 figured out) and peoplefound.xsl (to display the found names) respectively. But as I said I get the same error but right after "echo&" So it probably is the same silly error but not sure. I can not figure this out. I have also attached this index.xsl, peoplefound.xsl and the echo.fo7 database. I also attached the multiple.xsl, multiple2.xsl and the database that goes with it. I seem to have trouble attaching these files. I am trying to attach a xxxxxx.sit file. The file size is only 36 KB. If the file does not get attached you are more than welcome to email me directly at: ddhull@ku.edu If you would have the time and wouldn't mind looking at them I woud appreciate it very much. Thanks for all your assistance, Doug Hull

Thanks Martin, here is what I get after placing that piece of cody after the body: This comes up when starting from my index.xsl page which is listed below: &lt:fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"&gt &lt:error code="958"/&gt Which is Missing Parameter (*) &lt:product build="08/12/2004" name="FileMaker Web Publishing Engine" version="7.0v3"/&gt &lt:datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="0"/&gt &lt:metadata/&gt &lt:resultset count="0" fetch-size="0"/&gt &lt:/fmresultset&gt This comes up if I start at calc.xsl instead of index.xsl: &lt:fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"&gt &lt:error code="101"/&gt Which is Record is Missing &lt:product build="08/12/2004" name="FileMaker Web Publishing Engine" version="7.0v3"/&gt &lt:datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="0"/&gt &lt:metadata/&gt &lt:resultset count="0" fetch-size="0"/&gt &lt:/fmresultset&gt Here is my index.xsl page that could initially call calc.xsl: &lt:?xml version="1.0" encoding="ISO-8859-1"?&gt &lt:?xslt-cwp-query param="-grammar=fmresultset"?&gt &lt:xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset" exclude-result-prefixes="xsl fmrs"&gt &lt:xsl:output method="html" encoding="ISO-8859-1"/&gt &lt:xsl:template match="/fmrs:fmresultset"&gt &lt:html&gt &lt:head&gt &lt:meta http-equiv="content-type" content="text/htm;charset=iso-8859-1"/&gt &lt:title&gtPhonotactic Probability Home Page&lt:/title&gt &lt:link rel="stylesheet" href="biphones.css" type="text/css"/&gt &lt:/head&gt &lt:body&gt &lt:center&gt &lt:h1&gtPHONOTACTIC PROBABILITY&lt:/h1&gt &lt:hr width="640" color="#0000FF" noshade="noshade"/&gt &lt:p&gt&lt:xsl:text disable-output-escaping="yes"&gt