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.