8.0.2 update problems

The Dreamweaver 8.0.2 updater introduced bugs with parameters in all server
models. If the live page works, continue to work with it in code view and
don't update using the dialog boxes any more.

Tom Muck

"Paul Scullion" <webforumsuser@macromedia.com> wrote in message
news:eutq04$o6f$1@forums.macromedia.com...
> Have updated to DW 8.0.2 and all original scripts in "advanced" record
> setup
> fail. Have managed to fix all text and numeric searches by deleting ' and
> setting as text/numeric but dates declarations will only show the
> recordset
> when set to numeric with surroundng #'s.
> SQL:
> SELECT *
> FROM Qry_EnquiryList
> WHERE EnquiryID like varID AND Project like %varProject% AND Address like
> %varAddress% AND Company1 like %Company% AND Status like varStatus AND
> Estimator like varEstimator AND Received > #varReceived#
>
> When the page is put to the website it fails with:
>
> Application uses a value of the wrong type for the current operation.
>
> Anyone else had thsi problems? My original scripts have been live for over
> a
> year without problems.
>

There are flaws in the ASP code that DW generates for communicating with a
SQL server. I've had to go in and manually correct it so that it works many
times. You might try looking at it carefully.

Other than that, I don't know why it's not working for you.

Good luck.

"Paul Scullion" <webforumsuser@macromedia.com> wrote in message
news:ev0o15$ish$1@forums.macromedia.com...
> Thanks again for responding.
>
> With the variable set as a Date and using '%varReceived%'
> generates "Syntax error in query expression"
>
> If I use:
> ................ AND Received > varReceived
>
> with Declaration:
> varReceived
> Date
> Request("Received")
> 01/01/1901
>
> On "Test"
> Error Report:
> [Microsoft][ODBC Microsoft Access Driver Data type] mismatch in criteria
> expression
> but works fine when published
>
> It beats me I cannot afford to rely on testing complex scripts "live" when
> the
> Test should be doing it for me, so may have to return to DW v8.0.0
>
> Any other ideas would be helpful
>

Thanks again for responding.

With the variable set as a Date and using '%varReceived%'
generates "Syntax error in query expression"

If I use:
................ AND Received > varReceived

with Declaration:
varReceived
Date
Request("Received")
01/01/1901

On "Test"
Error Report:
[Microsoft][ODBC Microsoft Access Driver Data type] mismatch in criteria expression
but works fine when published

It beats me I cannot afford to rely on testing complex scripts "live" when the Test should be doing it for me, so may have to return to DW v8.0.0

Any other ideas would be helpful

Try #%varReceived%#

"Paul Scullion" <webforumsuser@macromedia.com> wrote in message
news:eutq04$o6f$1@forums.macromedia.com...
> Have updated to DW 8.0.2 and all original scripts in "advanced" record
> setup
> fail. Have managed to fix all text and numeric searches by deleting ' and
> setting as text/numeric but dates declarations will only show the
> recordset
> when set to numeric with surroundng #'s.
> SQL:
> SELECT *
> FROM Qry_EnquiryList
> WHERE EnquiryID like varID AND Project like %varProject% AND Address like
> %varAddress% AND Company1 like %Company% AND Status like varStatus AND
> Estimator like varEstimator AND Received > #varReceived#
>
> When the page is put to the website it fails with:
>
> Application uses a value of the wrong type for the current operation.
>
> Anyone else had thsi problems? My original scripts have been live for over
> a
> year without problems.
>