close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Creating coherent and coordinated links between Results and Details pages

Thread began 10/02/2022 5:06 pm by yogastudents362523 | Last modified 10/05/2022 11:24 am by yogastudents362523 | 91 views | 5 replies

yogastudents362523

possible webassist query rewriting bug when using LIMIT and trying to ORDER BY with more than a single field?

Hello,

I have just disocvered that webassist is automatically rewriting my queries, which is now why I believe (but possibly wrongly) that I have been unable to put together my pages and queries.

If I try to use variables to set up the following query with LIMITs in place and so I can control the paging:

<?php $starthighlight = 1;
$numberofhighlights = 4; ?>
<?php
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,$numberofhighlights,$starthighlight);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data WHERE ID >= 1 ORDER BY `Last`,`First` ASC ");
$rsPresenterHighlights->execute();
?>

then when I run the script, webassist eventually overwrites my original query to:

<?php
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,0);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data ");
$rsPresenterHighlights->execute();
?>

meaning it ignores my requests. And since the query is of course at the head, it never previously occurred to me to go back and check what was happening.

I have also found that QueryBuilder is failing. It either hangs; or else it tells me that it cannot recognize any of the table or columns, and that these will be deleted. I therefore used some third-party software to build the queries I wanted; which I am now finding webassist will not accept.

I am hopeful that some kind of workaround exists that will allow me to achieve the objectives I have in mind?

I still accept that I am somehow applying a flawed logic, and that that is why the queries are not "sticking", and not allowing me to use the variables I need.

Thank you for your kindness.
KAB

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...