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 <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. > ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
