andywt
Forum Replies Created
-
Forum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeSorry Michael,
I used the wrong shortcode. When I fixed it it did work as expected! Thanks muchForum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeI downloaded and activated v2.9.16RC1. Doesn’t seem to populate the value.
Here is my shortcode:
[cfdb-export-link form="Flag Database" orderby="Route,Neighborhood" show="Submitted,First Name,Last Name,Phone,Route" filter="Route=$_GET(status)"]Here is the URL is used to call the shortcode:
http://www.pros.org/flags/export-test/?Route=8/Here is the link that Export has:
http://www.prosperrotary.org/flags/wp-admin/admin-ajax.php?action=cfdb-export&form=Flag+Database&orderby=Route%2CNeighborhood&show=Submitted%2CFirst+Name%2CLast+Name%2CPhone%2CRoute&filter=Route%3DForum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeThat was my experience. It processed the command with an undefined variable for the Route. Is this something that can be fixed to work like it does in the cfdb-database or just not possible?
Forum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeis this implemented with the cfdb-export-link function?
Forum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeduh. Thanks that did the trick!!
Forum: Plugins
In reply to: [Contact Form DB] using a variable from url in shortcodeMike,
This is exactly what I am looking for but maybe I’m, missing something as it is not working.
Here is my url:
http://www.prosperrotary.org/flags/missing-flags-test/?routex=1, I also tried using the shortlink: /flags/?p=1086&routex=1 but the url gets rewritten to the permalinked version above.Here is my shortcode:
[cfdb-datatable form="2015 Flag Database" edit="true" orderby="Neighborhood,Route,Street,House #" show="Submitted,First Name,Last Name,Phone,Email,Neighborhood,House #,Street,Route,Method of Payment,Flag Lease Quantity,Were you a customer last year?,payment_status" filter="Route=$GET(routex)"]If replace the filter with:
filter="Route=1"]
I get the expected list.I updated my contact-form db to v2.9.14, contact-form-db-editor v1.4.1, but no change. Any ideas?
Forum: Plugins
In reply to: CFDB Custom ShortcodeAny suggestions?
Forum: Plugins
In reply to: [Contact Form DB] Creating a Custom Shortcodeoops typo. sorry
Forum: Plugins
In reply to: [Contact Form DB] Show ALL and Default QueryThe All dropdown does not work unless you change the Options to show all.
Forum: Plugins
In reply to: [Contact Form DB] mySQL Query issuesAddressed the issue by direct access to the $wpdb.
Forum: Plugins
In reply to: Nested Query with get->resultsSolved this by accessing the $wpdb directly.
Forum: Plugins
In reply to: $wpdb->update not updating databaseSolved this by accessing the $wpdb directly.
Forum: Plugins
In reply to: [Contact Form DB] CFDB Editor Not saving Data added to empty fieldsI have found the issue. I had added the fields to an existing database. When CFDB attempted to update the field, there was no entry in the _submits table, and therefore no where to save the data. What I did to get around this issue was to export the entire database to a CSV file. Open the CSV in Excel and add a ” ” to the new field in every record in the database. Then I deleted the old database and re-imported it and all is good.
Forum: Plugins
In reply to: [Contact Form DB] mySQL Query issuesMichael,
Thanks for the advice. Any advice on updating the contact form data from PHP?Forum: Plugins
In reply to: [Contact Form DB] mySQL Query issuesI believe my issue is that I am using the $wpdb->get_results to perform the sql query so it can not handle nested selects. So I made this change:
$dbarray = $wpdb->get_results("Select... this is the generated query) $query = $wpdb->get_results ("Select * FROM $dbarray WHERE <code>UniqueDB</code> = $uniqueID");The $dbarray contains the entire DB but $query is null. I do know that there is a record that matches the WHERE condition. I have also tried other fields in the database but nothing is ever retrieved.