Yes, but the builder creates something, correct? -- sent from my iPhone4 -- Beverly Voth --
On Jul 4, 2011, at 12:41 AM, Wayne Irvine <wa...@byteserve.com.au> wrote: > 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 <ch...@leavens.net> 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 lists...@witango.com >>> with "unsubscribe witango-talk" in the body. >>> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to lists...@witango.com >> with "unsubscribe witango-talk" in the body. >> > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.