DW CS4 with PHP/MySQL

[kal-hadi]

Hi,

I have come across some buggy stuff today in CS4 that I have never seen before. Anytime I would filter a recordset  using "URL Parameter" ,Dreamweaver would totaly mess up the recorset. When I go to "Advanced" I see that there is an additional SQL Variable named "totalRows" in addition to another one named "colname". Everytime I cleaned up the SQL statement only to revert it back.

Has anyone seen that?

Any help would be appreciated

Kal

[Guest]

If u wanna use URL Parameter, make sure u are using the correct passing parameter

[David_Powers]

kal-hadi wrote:

Anytime I would filter a recordset  using "URL Parameter" ,Dreamweaver would totaly mess up the recorset. When I go to "Advanced" I see that there is an additional SQL Variable named "totalRows" in addition to another one named "colname". Everytime I cleaned up the SQL statement only to revert it back.

I just done some testing with a PHP/MySQL recordset, opening and closing the Recordset dialog box in both Simple and Advanced mode several times. I cannot reproduce the problem you report.

[Timbo9799]

I have been experiencing a similar problem. When I open a recordset from the Bindings panel and attempt to addURL parameters and then save the recordset, the resulting code added to the MySQL is both syntactically and logically incorrect. The code that checks for the presence of a passed parameter (ISET function) has the wrong bracket syntax,and as you pointed out, an entirely invalid TOTALROWS statement is inserted in the wrong place in the SQL statement.Furthermore, I find that the Adobe documentation on the use and manipulation of URL parameters via the CS4 interface is woefully lacking. I'm basically reduced to hard-coding the logic at this point.

Message was edited by: Timbo9799

[MurraySummers]

You will need to give us an explicit set of instructions for how to reproduce your symptoms.  I must say, I've never seen such a thing happen in my usage though.

[Timbo9799]

Thanks for the timely post. I will try to gather code and maybe a screen shot to illustrate my dilemma. Upon further investigation, I'm finding that the correct default value to be entered for a parm is supposed to be -1. Why, I don't know. That may have been part of my problem.  I will report back soon.

I wonder why my profile pic isn't showing up. Certainly not a big deal.

[Timbo9799]

OK...my bad. My problem basically amounted to "user error", which as we all know is more often than not the case. I have discovered that when you manipulate a MySQL recordset and associated variables via the Bindings panel, you must be VERY CAREFUL making additions or changes. I guess I have become complacent in that DW CS4 has proven to be very intuitive in 'cleaning up' old code in favor of subsequent modifications. Not really the case, in this particular instance. The interface basically inserts your changes via the Bindings edits ON TOP OF the existing code. It will often duplicate the recordset, code-wise. And if you modify a variable, thinking that DW will go in and clean up your old statements, beware - it will not! You are better off manually changing the code in the program itself. I am pressed for time here, but will be more than happy to provide specific examples if asked to, at a later date. Thanks much, Murray!