Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › next page link generation

next page link generation

Thread began 1/26/2016 8:35 pm by localidiot | Last modified 2/28/2018 6:37 pm by Ray Borduin | 757 views | 2 replies |

1/26/2016 8:35 pm | #1 localidiot

next page link generation

When I generate a pagination link, and it inserts the code, the sql statement is broken. and the php page throws an error, mysql syntax error. However changing the %s back to a ? doesnt return the data the recordset did before trying to insert the next page link.

I notice the querystring is modified and ? is turned into %s

1/26/2016 10:43 pm | #2 Ray BorduinWebAssist

That looks like a bug.... I'll have to fix it. For now replace any %s with ? when this happens. %s was used in mysql and ? is used in MySQLi, so there must be code left behind messing it up. Also the "int" reference should just be "i", that too seems to be reverting to the old MySQL syntax and would have to be corrected.

Did this help? Tips are appreciated...

1/27/2016 5:02 am | #3 localidiot

That got it working. Thanks Ray :)

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.