Record Set Variables used in PHP and MYSQL model

[DanielBoone]

:Q

PHP MYSQL server model.

I'e been using dreamweaver for ages and have allways admired how well they
have kept compatibility between versions. The recent 8.02 release was a little
bit of a shock when I had to start rewriting all my PHP MYSQL recordset queries!

In the bulk of my SQL queries I detect on of two states for a query parameter
and in some queries the parameters are used more then once. By creating a
single variable in for the recordset I've allways been able to check and
recheck the single variable in the query using the standard recordset. Now in
version 8.02 I am getting the error: Missing type for variable:colname
So where:

<font color=white style="background-color: 3E3E3E;">SELECT *
FROM links
WHERE LinkID = colname or colname=-1
ORDER BY `Level` DESC</font ft>

used to work it does not work any more!

I'm being forced to rewrite the query:

<font color=white style="background-color: 3E3E3E;">
SELECT *
FROM links
WHERE colname in (-1,LinkID)
ORDER BY `Level` DESC</font ft>

Simple enough but where the queries get more complex the more variables I have
to define!

This is not Cool! Can we get a bug fix for this so that I dont have to rewrite
all my queries!

P.S. Since when did anyone say that the Dreamweaver was SQL injection safe!
This issue should have been resolved back in the Ultradev days! I guess Kudos
goes to Adobe for finally trying to address one of the biggest glaring issues
dreamweaver has had since it's inception. I was allways kinda upset that I was
forced to pass variables as text when I knew they where numbers!
If I Look at the resultant code now I'm sure the result sprint will still be
using %s instead of %n when I indicate a variable is numeric.

[DanielBoone]

:confused;
Start by saying bump.
I've still no word from Adobe if they are doing anything with this problem.
Any one had any replys from Adobe on it? Any one found a work around with
recoding queries?