Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › mysqli will not let me advance throught the record set

mysqli will not let me advance throught the record set

Thread began 8/08/2014 5:55 am by rpratt89080 | Last modified 8/08/2014 12:52 pm by Jason Byrnes | 2529 views | 14 replies |

8/08/2014 5:55 am | #1 rpratt89080

mysqli will not let me advance throught the record set

i have a record set and have it in a repeat and all is well. but when i place the paging behavior so i can advance throught the records i get an sql error that is non specific. if i remove the paging and just keep the repeat it works fine but i need to show all my records? any idea why this will not work? I really need the first last next and last behaviors.

8/08/2014 8:48 am | #2 Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

8/08/2014 9:12 am | #3 rpratt89080

thanks

Originally Said By: Jason Byrnes

I'll need to troubleshoot directly, see the private message section.

8/08/2014 9:14 am | #4 Jason ByrnesWebAssist

ok, send a copy of the php file and a dump of the database so I can recreate the problem on my system.

8/08/2014 10:55 am | #5 rpratt89080

for you

8/08/2014 11:02 am | #6 Jason ByrnesWebAssist

I am not able to use this sql file to recreate the table.

I'll need an export of the table using phpMyAdmin, not sure what GUI Tool you used for the export, but it is not compatible with Sequel Pro

if all else fails, I will need you to upload the page to a server so I can troubleshoot.

8/08/2014 11:05 am | #7 rpratt89080

try this

8/08/2014 11:21 am | #8 Jason ByrnesWebAssist

change the following code:

$seeds_aor_id->setQuery("SELECT seed.seed_id, seed.seed_full, seed.seed_promo, seed.seed_f_name, seed.seed_l_name, seed.seed_city, seed.seed_state, seed.seed_boat_year, seed.seed_boat_length, seed.seed_date, seed.seed_homeport, seed.seed_homeport_type, seed.seed_member_number, seed.seed_member_exp, co.co_name, co.co_aor_id, boat_make.boat_make FROM seed INNER JOIN co ON seed.seed_co_id = co.co_id INNER JOIN boat_make ON seed.seed_boat_make_id = boat_make.boat_make_id WHERE co.co_aor_id = %s ORDER BY seed.seed_date DESC");
$seeds_aor_id->bindParam("int", "".$_GET['aor_id']  ."", "-1"); //WAQB_Param1

to:

$seeds_aor_id->setQuery("SELECT seed.seed_id, seed.seed_full, seed.seed_promo, seed.seed_f_name, seed.seed_l_name, seed.seed_city, seed.seed_state, seed.seed_boat_year, seed.seed_boat_length, seed.seed_date, seed.seed_homeport, seed.seed_homeport_type, seed.seed_member_number, seed.seed_member_exp, co.co_name, co.co_aor_id, boat_make.boat_make FROM seed INNER JOIN co ON seed.seed_co_id = co.co_id INNER JOIN boat_make ON seed.seed_boat_make_id = boat_make.boat_make_id WHERE co.co_aor_id = ? ORDER BY seed.seed_date DESC");
$seeds_aor_id->bindParam("i", "".$_GET['aor_id']  ."", "-1"); //WAQB_Param1

make sure you have the latest MySQLi version installed, 1.0.2, if you have a previous version, uninstall it from the extension manager before installing the new one.

8/08/2014 11:46 am | #9 rpratt89080

still no love?

Attached Files

index.php

8/08/2014 12:15 pm | #10 rpratt89080

got it.

I had to rebuild all server behaviors to get it to work, not just the one you helped me with.

Thanks!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.