fmwebschool.com
Top Experts [learn more]Top 4-10
webko

9743 K
bandmandq

2458 K
Genx

1525 K
4. tcmeyers
5. kbata
6. Martie
7. Hammerton
8. rrenfrow
9. bneeman
10. plegler
Welcome, Guest. Please login or register.
September 02, 2014, 06:55:47 AM

Login with username, password and session length
Search:     Advanced search
Welcome to the FileMaker Web Masters Exchange.  If you have any questions about how to use this forum, please watch the getting started movie at:
http://www.fmwebschool.com/movies/forum1/forum1.html
27787 Posts in 6147 Topics by 1525 Members
Latest Member: alkyred
* Home Help Search Calendar Login Register
+  fmwebschool.com
|-+  Recent Posts
Pages: 1 [2] 3 4 ... 10

 11 
 on: July 20, 2014, 11:04:22 AM 
Started by cooldude - Last post by cooldude
Hi all,

I'm having some trouble trying to connect to FileMaker 13 server.

I have done this ok with FMS 11 but 13 is giving me issues.

I tried the simple demo file FMServer_Sample - created a user and pass with basically full permissions and fmphp privileges etc.

created a simple layout with some fields including 'Status'

then created a fmstudio (non pro version for now) connection - said OK

but when I try a simple record set - sometimes it says NO TABLE FOUND - or in this case it finds the tables and layouts but says NO FIELDS FOUND  

-------

As a test I put the same demo but v11 file on a fms11 server and no problems....


Is there something odd with FM 13 and server and web php publishing or fmstudio?


I have an older version - is this cured in an fmstudio update?


Also - I did not set up this v13 server - is there anything I ask ask the owner to check?

 12 
 on: July 04, 2014, 08:46:39 AM 
Started by louflis - Last post by louflis
Forum,
I solved the issue. I deleted my redirect, then created the email, then did the redirect and placed it after the email.
Thanks

 13 
 on: July 03, 2014, 05:56:06 AM 
Started by louflis - Last post by louflis
Another note - I have other other forms setup the same way and they work fine. So I don't think it's a set up issue. I also tried running the email module without the redirect and it still did not work.  Any thoughts!!!

As always! Thanks to the forum!!

 14 
 on: July 02, 2014, 08:49:45 AM 
Started by thebugnut - Last post by thebugnut
Hi Everyone

I am gong crazy trying to fix an issue that I never had in previous project. I was wondering is anyone could help.

I have created an admin dashboard where my client can login to and edit product details (in this car info). You can view all items and select the single item to edit. From the edit page the user should be able to update the descriptions by copy and pasting content from a Word Document. This is an exact copy of a pervious website. Unfortunately I get the following error every time.

The following error has occured: Parameter missing in query (958)

I have narrowed it down to the use of either curly brackets and smart quotes that are used in the source material.

As a test I tried using the same source material on the previous site I built and everything worked fine (Both sites are on the site server). So there is something different between the two websites that I can't find. Is this a possible bug in the latest version of FMStudio?

The working site was made with an older version of FMStudio but I have since updated the extension

I really need some help. This is killing me and I need to make my client happy.


 15 
 on: July 01, 2014, 12:34:29 PM 
Started by louflis - Last post by louflis
Forgot to add that I also want to redirect to another page
Thanks

 16 
 on: July 01, 2014, 12:32:17 PM 
Started by louflis - Last post by louflis
Forum,

I am trying to send a confirmation email upon submitting a form. The form submits fine, but I am not receiving the email confirmation.  The code is below. Could someone either correct the code or tell me what I am doing incorrectly.

Thanks


<?php require_once('Connections/kb_projects.php'); ?>
<?php include('Email_Module/emailer.php'); ?>
<?php
$trivia_add = $kb_projects->newAddCommand('trivia');
$trivia_fields = array('name_first'=>$_REQUEST['name_first'],'name_last'=>$_REQUEST['name_last'],'address'=>$_REQUEST['address'],'address_PO Box'=>$_REQUEST['address_PO_Box'],'address_city'=>$_REQUEST['address_city'],'address_state'=>$_REQUEST['address_state'],'address_zip'=>$_REQUEST['address_zip'],'email'=>$_REQUEST['email'],'phone'=>$_REQUEST['phone'],'trivia_id'=>$_REQUEST['trivia_id'],'date'=>$_REQUEST['date'],'email_opt_out'=>$_REQUEST['email_opt_out'],'week_9_Question'=>$_REQUEST['week_9_Question'],'week_9_Response'=>$_REQUEST['week_9_Response'],'week_9_Answer'=>$_REQUEST['week_9_Answer'],'week_10_Question'=>$_REQUEST['week_10_Question'],'week_10_Response'=>$_REQUEST['week_10_Response'],'week_10_Answer'=>$_REQUEST['week_10_Answer'],'week_11_Question'=>$_REQUEST['week_11_Question'],'week_11_Response'=>$_REQUEST['week_11_Response'],'week_11_Answer'=>$_REQUEST['week_11_Answer'],'week_12_Answer'=>$_REQUEST['week_12_Answer'],'week_12_Question'=>$_REQUEST['week_12_Question'],'week_12_Response'=>$_REQUEST['week_12_Response'],'week_13_Question'=>$_REQUEST['week_13_Question'],'week_13_Response'=>$_REQUEST['week_13_Response'],'week_13_Answer'=>$_REQUEST['week_13_Answer'],'week_14_Question'=>$_REQUEST['week_14_Question'],'week_14_Response'=>$_REQUEST['week_14_Response'],'week_14_Answer'=>$_REQUEST['week_14_Answer'],'week_16_Question'=>$_REQUEST['week_16_Question'],'week_16_Response'=>$_REQUEST['week_16_Response'],'week_16_Answer'=>$_REQUEST['week_16_Answer'],'week_15_Question'=>$_REQUEST['week_15_Question'],'week_15_Response'=>$_REQUEST['week_15_Response'],'week_15_Answer'=>$_REQUEST['week_15_Answer'],'week_17_Question'=>$_REQUEST['week_17_Question'],'week_17_Response'=>$_REQUEST['week_17_Response'],'week_17_Answer'=>$_REQUEST['week_17_Answer'],'week_18_Question'=>$_REQUEST['week_18_Question'],'week_18_Response'=>$_REQUEST['week_18_Response'],'week_18_Answer'=>$_REQUEST['week_18_Answer'],'week_19_Question'=>$_REQUEST['week_19_Question'],'week_19_Response'=>$_REQUEST['week_19_Response'],'week_19_Answer'=>$_REQUEST['week_19_Answer'],'week_20_Answer'=>$_REQUEST['week_20_Answer'],'week_20_Question'=>$_REQUEST['week_20_Question'],'week_20_Response'=>$_REQUEST['week_20_Response'],'week_21_Question'=>$_REQUEST['week_21_Question'],'week_21_Response'=>$_REQUEST['week_21_Response'],'week_21_Answer'=>$_REQUEST['week_21_Answer'],'week_22_Question'=>$_REQUEST['week_22_Question'],'week_22_Response'=>$_REQUEST['week_22_Response'],'week_22_Answer'=>$_REQUEST['week_22_Answer'],'week_23_Question'=>$_REQUEST['week_23_Question'],'week_23_Response'=>$_REQUEST['week_23_Response'],'week_23_Answer'=>$_REQUEST['week_23_Answer'],'week_24_Question'=>$_REQUEST['week_24_Question'],'week_24_Response'=>$_REQUEST['week_24_Response'],'week_24_Answer'=>$_REQUEST['week_24_Answer'],'week_25_Question'=>$_REQUEST['week_25_Question'],'week_25_Response'=>$_REQUEST['week_25_Response'],'week_25_Answer'=>$_REQUEST['week_25_Answer'],'tue_noon'=>$_REQUEST['tue_noon'],'wed_noon'=>$_REQUEST['wed_noon'],'tue_3pm'=>$_REQUEST['tue_3pm'],'wed_3pm'=>$_REQUEST['wed_3pm'],);
foreach($trivia_fields as $key=>$value) {
    $trivia_add->setField($key,$value);
}

$trivia_add = $kb_projects->newAddCommand('trivia');
$trivia_fields = array('name_first'=>$_REQUEST['name_first'],'name_last'=>$_REQUEST['name_last'],'address'=>$_REQUEST['address'],'address_PO Box'=>$_REQUEST['address_PO_Box'],'address_city'=>$_REQUEST['address_city'],'address_state'=>$_REQUEST['address_state'],'address_zip'=>$_REQUEST['address_zip'],'email'=>$_REQUEST['email'],'phone'=>$_REQUEST['phone'],'email_opt_out'=>$_REQUEST['email_opt_out'],
   'tue_noon'=>$_REQUEST['tue_noon'],      
   'wed_noon'=>$_REQUEST['wed_noon'],   
   'tue_3pm'=>$_REQUEST['tue_3pm'],   
   'wed_3pm'=>$_REQUEST['wed_3pm'],   );
foreach($trivia_fields as $key=>$value) {
    $trivia_add->setField($key,$value);
}

$trivia_result = $trivia_add->execute();

if(FileMaker::isError($trivia_result)) fmsTrapError($trivia_result,"error.php");

$trivia_row = current($trivia_result->getRecords());

 
$FMStudio_Emailer_body = "Dear <<name_first>> <<name_last>>\nThank you for registering for Tony Goodwin’s Art and Soul Work Shop. This is your Art and Soul Workshop Confirmation. <<AE_day_calc>>\nPlease be reminded that participants under 16 years of age must be accompanied by an adult.\n";
FMStudio_Emailer(
   'trivia',
   $trivia_row->getField('email'),
   "donnaroo@kingdombound.org",
   "",
   "",
   "",
   'mail:',
   '',
   "Art and Soul Confirmation",
   $FMStudio_Emailer_body
);

fmsRedirect('https://kbmssl.c7.ixsecure.com/fm9web/kb_projects/AE_signUp_fee.php');

// FMStudio Pro - do not remove comment, needed for DreamWeaver support ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Art and Soul</title>
<style type="text/css">
<!--
.s24 {
   font-size: 24px;
}
-->
</style>
</head>

<body class="s24">

<div align="center">
  <p><img src="Paint_Master3.fw.png" width="199" height="200" longdesc="Paint_Master3.fw.png"></p>
  <p>Thank You for signing up for the Art and Soul - Painting is Easy</p>
</div>
</body>
</html>

 17 
 on: June 11, 2014, 08:10:27 AM 
Started by crmon1 - Last post by crmon1
Thank you

 18 
 on: June 11, 2014, 08:06:17 AM 
Started by crmon1 - Last post by crmon1
OK. Thanks for all who viewed my topic. I solved the issue. I don't know why it wasn't working for me before. Must have been a typo. Adding the code to the function in FMStudio_tools.php did the trick.
Code:
case "password":
echo "<input name=\"$field\" type=\"password\" id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList\"";
}
if($current_value !== null) echo " value=\"".htmlspecialchars($current_value)."\"";
echo ">";
break;

 19 
 on: June 11, 2014, 07:09:43 AM 
Started by crmon1 - Last post by crmon1
Hi There! This is the code that is generated using FMStudio Pro. You'll notice the code "text".
Code:
<?php fmsLiveInputField($reader,'users','pword',null,$newuser_row->getRecordId(),"text",$newuser_row->getFieldUnencoded('pword'),null,null,"passwordboxer","w"); ?>

This attribute is delivered to the include FMStudio_Tools.php file and then rendered as:
Code:
<input id="__FMS19" class="__FMS_LiveValueList passwordboxer" value="" name="pword" has_focus="false"></input>

FMStudio_Tools.php uses this function to switch the input type:
Code:
switch($type) {
case "static_text":
echo "<span id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList __FMS_LiveValueList_StaticText {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList __FMS_LiveValueList_StaticText\"";
}
echo ">";
if($current_value !== null) echo htmlspecialchars($current_value);
echo "</span>";
break;
case "text":
echo "<input name=\"$field\" id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList\"";
}
if($current_value !== null) echo " value=\"".htmlspecialchars($current_value)."\"";
echo ">";
break;
case "textarea":
echo "<textarea name=\"$field\" id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList\"";
}
echo ">";
if($current_value !== null) echo htmlspecialchars($current_value);
echo "</textarea>";
break;
case "dropdown":
$items = fmsValueListItems2($conn,$layout,$list,$recid,$empty_label,$current_value);
echo "<select name=\"$field\" id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList\"";
}
echo ">";
foreach($items  as $list_item) {
if(html_entity_decode($list_item[0]) == $current_value) {
echo "<option value=\"{$list_item[0]}\" selected=\"selected\">{$list_item[1]}</option>";
} else {
echo "<option value=\"{$list_item[0]}\">{$list_item[1]}</option>";
}
}
if($other_label !== null) {
if(!count($items)) {
echo "<option value=\"\"></option>";
}
echo '<option value="__FMWS__CUSTOM__">'.htmlspecialchars($other_label).'</option>';
}
echo "</select>";
break;
case "checkbox":
$items = fmsValueListItems2($conn,$layout,$list,$recid,null,null);
$name = $field.'[]';
if($cssClass !== null) {
echo "<span id=\"{$field_id}\" class=\"__FMS_LiveValueList $cssClass\">";
}else{
echo "<span id=\"{$field_id}\" class=\"__FMS_LiveValueList\">";
}
foreach($items  as $index => $list_item) {
$id = $FMStudioV2->uniqueid();
echo "<input type=\"checkbox\" name=\"$name\" id=\"{$id}\"";
echo " value=\"{$list_item[0]}\"";

if(fmsCompareSet(html_entity_decode($list_item[0]),$current_value)) {
echo " checked=\"checked\"";
}
echo "> ";
echo "<label for=\"{$id}\">".$list_item[1]."</label>";
if($index+1 != count($items) && $separator !== null) {
echo $separator;
}
}
echo "</span>";
break;
case "radio":
$items = fmsValueListItems2($conn,$layout,$list,$recid,null,null);
$name = $field;
if($cssClass !== null) {
echo "<span id=\"{$field_id}\" class=\"__FMS_LiveValueList $cssClass\">";
}else{
echo "<span id=\"{$field_id}\" class=\"__FMS_LiveValueList\">";
}
foreach($items  as $index => $list_item) {
$id = $FMStudioV2->uniqueid();
echo "<input type=\"radio\" name=\"$name\" id=\"{$id}\"";
echo " value=\"{$list_item[0]}\"";

if(fmsCompareSet(html_entity_decode($list_item[0]),$current_value)) {
echo " checked=\"checked\"";
}
echo "> ";
echo "<label for=\"{$id}\">".$list_item[1]."</label>";
if($index+1 != count($items) && $separator !== null) {
echo $separator;
}
}
echo "</span>";
break;
}

}

I've tried adding to the this function, so it would recognize  "password", but there must be something else I am missing because it hasn't been working. This is what I tried adding to the function:
Code:
case "password":
echo "<input name=\"$field\" type=\"password\" id=\"{$field_id}\"";
if($cssClass !== null) {
echo " class=\"__FMS_LiveValueList {$cssClass}\"";
}else{
echo " class=\"__FMS_LiveValueList\"";
}
if($current_value !== null) echo " value=\"".htmlspecialchars($current_value)."\"";
echo ">";
break;

I'm missing something, just don't know what.

 20 
 on: June 10, 2014, 03:42:49 PM 
Started by PhanMan - Last post by PhanMan
Using the email module to send out emails when a new record is added.  However when there is an apostrophe (') or quotation marks (") in the text, the email that is sent out pulling the text from that field for the record displays in the mail as ’ and &quot;

-the value in fillemaker field shows the correct (') and (")
-the field echos/displays correctly on the php pages

Any suggestions?

Pages: 1 [2] 3 4 ... 10
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!