Forums

PHP

This topic is locked

Recordsets don't display in Server Behaviors or DB

Posted 08 Jan 2002 04:32:37
1
has voted
08 Jan 2002 04:32:37 todd mr posted:
Using:
Windows 2000
UltraDev 4.0
phakt 1.1.0
MySQL database
MySQL ODBC

When I create a Recordset in either Data Bindings or Server Behaviors, it
tests OK and displays the records stored in the database -- so I know the
Connection works and I can create a page that displays a record from the
database using the 'hidden' Recordset. However, the Recordset does not
appear in the Server Behaviors window - thus I cannot create any of
the 'nice to have' behaviors like Repeat Region, Insert Record, Update
Record, etc because I get the error: "Before using this Server Behavior,
please create a recordset."

Any clues on how to fix this would be appreciated.

Todd.


Replies

Replied 08 Jan 2002 08:41:58
08 Jan 2002 08:41:58 Tim Green replied:
Please do not post the same question to multiple forums.

www.udzone.com/forum/topic.asp?TOPIC_ID=13902&FORUM_ID=79&CAT_ID=29&NewsId=1201&Forum_Title=Bugs&Topic_Title=Recordsets+don%27t+display+in+Server+Behaviors

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 16 Jan 2002 11:58:03
16 Jan 2002 11:58:03 Jack McNeely replied:
I saw this syndrome with the first recordset that I created after installing the PHAkt extension. I think the cause was that the /adobc directory was not copied to my Web server space until the first recordset was created. The syndrome went away after I exited and restarted Dreamweaver.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
When I create a Recordset in either Data Bindings or Server Behaviors, it
tests OK and displays the records stored in the database -- so I know the
Connection works and I can create a page that displays a record from the
database using the 'hidden' Recordset. However, the Recordset does not
appear in the Server Behaviors window - thus I cannot create any of
the 'nice to have' behaviors like Repeat Region, Insert Record, Update
Record, etc because I get the error: "Before using this Server Behavior,
please create a recordset."

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Replied 16 Jan 2002 22:39:27
16 Jan 2002 22:39:27 Tim Green replied:
I recentl came across this problem myself. It has nothing to do with the adodb folder really, though I did discover that not only did the recordset appear in the Server Behaviours floater, it also did not appear in the Data Bindings floater.

This said, I reported the issue to Interakt, and in the meantime uninstalled PHAkT, reinstalled it, and everything was fine!

Hope this helps

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Reply to this topic