Chuck is creating an INSERT, not select. And there is more revealed if you look at the taf in a text editor ( the raw XML ). :)
-- sent from my iPhone4 -- Beverly Voth -- On Jul 4, 2011, at 3:10 AM, Wayne Irvine <[email protected]> wrote: > Sort of. But the only place you can see it is in debug. > > If I make a simple TAF that uses a search action I don't ever have to see a > SQL query. It's only when I turn on debugging that I see the query: > > [Query] [13] SELECT > S1.accountNo,S1.siteDomain,S1.Serial,S1.metadesc,S1.metakeys,S1.siteTitle,S1.logo,S1.background > FROM Sites S1 WHERE (S1.accountNo=3 AND S1.siteDomain=?) > > And it's only since Witango 6 that I have come to see this. Before using > FileMaker direct there was no SQL query at all. > > Wayne > > On 04/07/2011, at 4:45 PM, Beverly Voth wrote: > >> Yes, but the builder creates something, correct? >> >> -- sent from my iPhone4 -- >> Beverly Voth >> -- >> >> On Jul 4, 2011, at 12:41 AM, Wayne Irvine <[email protected]> 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 <[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. >>> >> >> >> ---------------------------------------- >> >> 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.
