I think what Beverley is asking for the is SQL query sent to FileMaker. I have no experience in SQL because I have just used the Add/Search builders and the prewritten database actions in Witango to get stuff to and from a database. I expect Chuck is in exactly the same boat.
Wayne On 04/07/2011, at 11:12 AM, Beverly Voth wrote: > Ok. You are FORM posting... > > This returns to the same taf? The query is the part that processes the form > values after submit. > > -- sent from my iPhone4 -- > Beverly Voth > -- > > On Jul 3, 2011, at 8:06 PM, Chuck Leavens <[email protected]> wrote: > >> First let me say I so dearly appreciate the help. I feel like something is >> right in front of me and I can't see it. >> >>> Two things come to mind: >>> 1. Are there required fields which are NOT getting data (NULL is somewhat >>> difficult to pass TO FMP even if it's allowed). And/or are the field types >>> getting the correct data (timestamps, for example, need date and time). >>> >>> 2. Are you binding table occurrence or table to the field/column in the >>> query: >>> >>> Table.fieldName >>> TOname.fieldName >> >> >> In this case once I got the Dev Studio to see the DB properly I simply used >> the New Record Builder and put fields over to make the quick and dirty test. >> SImplest use of the Dev Studio. I figured it was safest for the test. >> >> I tried using required fields on one test and even if the fields were filled >> I got required fields errors. >> >> So I built a new one with NO required fields just to get past that and make >> a DB work and that is where I am with now. >> >>> Any chance you can post the actual query? (change the data, but try to >>> maintain the same structure of the query) >>> >> >> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" >> "http://www.w3.org/TR/REC-html40/strict.dtd";> >> <html> >> <head> >> <meta name="security" content="public" /> >> <meta name="generator" content="Witango Dev Studio" /> >> <meta name="author" content="Witango New Record Builder" /> >> <meta name="robots" content="index,follow" /> >> >> <meta name="abstract" content="" /> >> <meta name="description" content="" /> >> <meta name="keywords" content="" /> >> >> <title>New Record Form</title> >> <style type="text/css"> >> table { border: 0px solid; >> margin: 0px; >> padding: 0px; >> empty-cells: show; } >> table th { border: 0px solid; } >> table td { border: 0px solid; } >> </style> >> </head> >> <body> >> <form method="post" >> action="<@cgi><@appfile>?_function=insert&<@UserReferenceArgument>"> >> <table> >> <tr> >> <td>First Name:</td> >> <td><input name="pubradiopledge_First Name" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Last Name:</td> >> <td><input name="pubradiopledge_Last Name" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Email:</td> >> <td><input name="pubradiopledge_Email" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Partner/ Spouse First Name:</td> >> <td><input name="pubradiopledge_Partner/Spouse First Name" type="text" >> size="40" maxLength="0"></td> >> </tr> >> <tr> >> <td>Partner Spouse Last Name:</td> >> <td><input name="pubradiopledge_Partner Spouse Last Name" type="text" >> size="40" maxLength="0"></td> >> </tr> >> <tr> >> <td>Type of Membership:</td> >> <td><select name="pubradiopledge_Type of Membership" size="1"> >> <option value="New Member" selected="selected">New Member</option> >> <option value="Renewing Member">Renewing Member</option> >> <option value="Additional Gift">Additional Gift</option> >> </select></td> >> </tr> >> <tr> >> <td>Amount of Pledge:</td> >> <td><input name="pubradiopledge_Amount of Pledge" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>One Time Charge?:</td> >> <td> >> <input name="pubradiopledge_One Time Charge?" type="radio" value="One >> Time">Charge this amount one time >> <input name="pubradiopledge_One Time Charge?" type="radio" >> value="Installments">Break this amount into 10 installments >> <input name="pubradiopledge_One Time Charge?" type="radio" >> value="Sustaining">Charge each month (create a sustaining plan)</td> >> </tr> >> <tr> >> <td>Type of Payment:</td> >> <td><select name="pubradiopledge_Type of Payment" size="1"> >> <option value="" selected="selected">Select type...</option> >> <option value="Visa">Visa</option> >> <option value="Mastercard">Mastercard</option> >> <option value="Discover">Discover</option> >> <option value="American Express">American Express</option> >> <option value="Please Bill ">Please Bill Me</option> >> </select></td> >> </tr> >> <tr> >> <td>Credit Card Number:</td> >> <td><input name="pubradiopledge_Credit Card Number" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Expiration Month:</td> >> <td><select name="pubradiopledge_Expiration Month" size="1"> >> <option value="">Select Month</option> >> <option value="1">1</option> >> </select></td> >> </tr> >> <tr> >> <td>Expiration Year:</td> >> <td><select name="pubradiopledge_Expiration Year" size="1"> >> <option value="" selected="selected">Select Year</option> >> <option value="2011">2011</option> >> <option value="2012">2012</option> >> <option value="2013">2013</option> >> <option value="2014">2014</option> >> <option value="2015">2015</option> >> <option value="2016">2016</option> >> <option value="2017">2017</option> >> <option value="2018">2018</option> >> <option value="2019">2019</option> >> <option value="2020">2020</option> >> </select></td> >> </tr> >> <tr> >> <td>Cardholders Name:</td> >> <td><input name="pubradiopledge_Cardholders Name" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Street Address:</td> >> <td><input name="pubradiopledge_Street Address" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Street Address 2:</td> >> <td><input name="pubradiopledge_Street Address 2" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>City:</td> >> <td><input name="pubradiopledge_City" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>State:</td> >> <td><input name="pubradiopledge_State" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Zip:</td> >> <td><input name="pubradiopledge_Zip" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Daytime Phone:</td> >> <td><input name="pubradiopledge_Daytime Phone" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>Comments:</td> >> <td><input name="pubradiopledge_Comments" type="text" size="40" >> maxLength="0"></td> >> </tr> >> <tr> >> <td>May We Thank You On Air?:</td> >> <td><select name="pubradiopledge_May We Thank You On Air?" size="1"> >> <option value="Yes" selected="selected">Yes</option> >> <option value="No">No</option> >> </select></td> >> </tr> >> </table> >> <input type="submit" value="Save"> <input type="reset" value="Reset Values"> >> >> </form> >> >> </body> >> </html> >> >> >> Chuck Leavens >> Leavens Media Associates LLC >> 1919 Riggs Rd >> Pittsburgh PA 15129 >> >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. >> > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
