Forums
This topic is locked
Advanced Recordset Problem
12 May 2006 10:54:40 Nick Cox posted:
Hi all,I am having a problem with the recordset functionality in Dreamweaver 8. I am using MYSQL and PHP.
I have setup a query in SIMPLE mode. When I test this, it brings back the results as required.
When I change to ADVANCED mode and test it the result comes back 'no data'. Why does this not work in advanced mode, when I have not changed anything?
I want to use advanced mode such that I can use SQL to calculate some averages.
Thanks for helping.
Nick
Edited by - cityguy on 12 May 2006 11:02:00
Replies
Replied 20 Dec 2006 06:34:51
20 Dec 2006 06:34:51 David Nicholls replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi all,
I am having a problem with the recordset functionality in Dreamweaver 8. I am using MYSQL and PHP.
I have setup a query in SIMPLE mode. When I test this, it brings back the results as required.
When I change to ADVANCED mode and test it the result comes back 'no data'. Why does this not work in advanced mode, when I have not changed anything?
I want to use advanced mode such that I can use SQL to calculate some averages.
Thanks for helping.
Nick
Edited by - cityguy on 12 May 2006 11:02:00
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hi all,
I am having a problem with the recordset functionality in Dreamweaver 8. I am using MYSQL and PHP.
I have setup a query in SIMPLE mode. When I test this, it brings back the results as required.
When I change to ADVANCED mode and test it the result comes back 'no data'. Why does this not work in advanced mode, when I have not changed anything?
I want to use advanced mode such that I can use SQL to calculate some averages.
Thanks for helping.
Nick
Edited by - cityguy on 12 May 2006 11:02:00
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>