We recently upgraded from Dreamweaver 8 to CS3. For some reason because of the upgrade, I can't view the multiple selections on my local testing machine. I get a page but no records displaying on the asp page. In DM8, the following SQL statement was written in the advance recordset to allow me to select and input multiple entries and the syntax worked:
WHERE designtype IN (MMColParam)
In the upgrade to CS3, the following SQL statement was shown in the code:
WHERE designtype IN (?)
In the above CS3 SQL statement, I can only select one entry. What does the question mark mean? Why is there a difference? Also, I have a asp page in production that is working using the above DM8 syntax so I'm safe. But I need to know the difference and the correct syntax used for CS3 for this particular form request.
Please advise. Thanks Experts.