Potential Bug

I have a query and when I use the search wizard it seems to delete part of the query thus causing an error. I finally figured out what it was doing.

Before using the wizard the query is:

$query_reservation_RS = sprintf("SELECT * FROM reservations INNER JOIN reservation_items ON (reservations.reservationID = reservation_items.reservationID) WHERE ID = %s GROUP BY reservations.reservationID ORDER BY reservationDate ASC", GetSQLValueString($colname_reservation_RS, "int"));

After using the wizard the query is missing:

, "int")

from the end.

It was doing it using DataAssist 2.0.7 and now in 2.0.8

Not a huge deal now that I've tracked down what was happening, but wanted to make you aware of it.

Thanks,
Twitch

I am not able to reproduce the issue.

What version of Dreamweaver are you using?

What is your OS?

Perhaps the issue is related to using an underscore in the recordset name, try using a recordset that does not include an underscore in the name.