sql statement error after 8.02 upgrade

imjusthere2 wrote:
> mmcolparam and sort are session variables

You don't say which server model you're using, but with the PHP/MySQL
server model, at least, both mmcolparam and sort need to have the data
type set to "Text".

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
 >> Stay informed about: sql statement error after 8.02 upgrade 

If I remember correctly, the ASP server model (and perhaps the others as
well) will only create one copy of your parameter. The problem is they used
ADO parameterization with placeholders, which is based on position. That
means you'll need to go in and attach a copy of "sort" to the command object
for every instance of "sort" in your query. This is most easily done using
code view and not spending time trying to do it in the UI.


"imjusthere2" <webforumsuser DeleteThis @macromedia.com> wrote in message
news:f61agg$ok1$1@forums.macromedia.com...
> Below is my sql statment that worked fine before I upgraded dreamweaver.
> Now
> it says I have a syntax error. Can anyone tell me what is wrong with it?
>
> SELECT *
> FROM proofs
> WHERE proof_associate = MMColParam AND (proof_formNumber LIKE %sort% OR
> proof_date LIKE %sort% OR proof_desc LIKE %sort% OR proof_AKA LIKE %sort%
> OR
> proof_keywords LIKE %sort% OR proof_tab LIKE %sort% OR proof_client LIKE
> %sort%)
> ORDER BY proof_date DESC
>
> mmcolparam and sort are session variables
>
> Thank you,
> Chris
>
 >> Stay informed about: sql statement error after 8.02 upgrade