VBscript in PHP page

[erickia]

I have a routine that I wrote in VB6 that creates a complex SQL string for
searching my database. I would like to convert this routine to VBscript and
use it to create the string and then pass the string to PHP to perform the
query. Can I do this?

The routine consist of combo boxes for choosing the database fields and
operators, and text fields for typing info to test against. Would this VB6
code differ much from the VBscript code?

[Chris In Madison]

I don't think you'll be able to do it on the same page. The page can only
be parsed by one script engine at a time, and that's governed by the
extension of the file being used (.asp/.php). You might be able to do some
preprocessing on an ASP page, then forward the results to a PHP page for
further action, presuming, of course, that your server supports both server
models.

Best regards,
Chris

[erickia]

That wouldn't be a problem. One page for inputing the request and another for
displaying the results, would be fine. I phrased the question wrong. I should
have said on the same "site" and rather than the same "page."

[Chris In Madison]

If that's the case, then I don't see a problem with it, technically. The
only problem now is getting Dreamweaver to deal with it.

When you create a site definition, it pretty much sets up all the menus and
what not for that particular server model. So, if your site defiinition is
for ASP, then I don't think your PHP server behaviors will be available. I
might be wrong on that, though. MX2004 adds a little more flexibility in
that regard than previous versions. At one point you had to maintain two
site definitions, one for PHP, one for ASP, both pointing to the same
directory. Not sure if that's still the case. Might be worth checking :-)

Best regards,
Chris