Loose RS in the Applications Bindings with Complex SQL
my rs disappearing bindings table. sql lookes this:
mysql_select_db($database_qa, $qa);
$query_rslisttestcase = sprintf("select testcase.*, author.*, module.*, productrelease.*, products.*, status.*, mfr.*, section.* testcase inner join author on author.author_id = testcase.author_id inner join module on module.module_id = testcase.module_id inner join productrelease on productrelease.release_id = release_id inner join products on products.product_id = testcase.product_id inner join status on status.status_id = testcase.status_id inner join mfr on mfr.mfr_id = testcase.mfr_id inner join section on section.section_id = testcase.section_id bug_number = %s", getsqlvaluestring($colname_rslisttestcase, "int"));
when try , save, rs removed bindings panel still in code.
thoughts?
mysql_select_db($database_qa, $qa);
$query_rslisttestcase = sprintf("select testcase.*, author.*, module.*, productrelease.*, products.*, status.*, mfr.*, section.* testcase inner join author on author.author_id = testcase.author_id inner join module on module.module_id = testcase.module_id inner join productrelease on productrelease.release_id = release_id inner join products on products.product_id = testcase.product_id inner join status on status.status_id = testcase.status_id inner join mfr on mfr.mfr_id = testcase.mfr_id inner join section on section.section_id = testcase.section_id bug_number = %s", getsqlvaluestring($colname_rslisttestcase, "int"));
when try , save, rs removed bindings panel still in code.
thoughts?
i used lot mysql pre cs3. way rs quit dw , restart again.
More discussions in Develop server-side applications in Dreamweaver
adobe
Comments
Post a Comment