hello,
this question is more towards george or Waldo (whoever wrote the SBB expansion pack)

I made a server behavior, and when I try to use it I get some javascript error in the connectionsmenu.js file ... then i try to apply it again, and it comes up with the menu, but it wont show the tables (from the tablesmenu control)

this happens every time, I even tried to uninstall the extension, and reinstall it

thanks in advance,
Joel Martinez

----------
Is this thing on?....

Hi Joel,

we are aware of some bugs in the Connections Menu. However it is very difficult to solve your specific problem when you don't tell me what the javascript errors are that you get. You can also send me the extension and I'll try to solve the problem for you.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

thanks for helping,
here's the code that I put into the SB builder... it's set to be inserted before the selection... when applied, it'll hit the database, and store the string of a dropdown into an application, or session variable, then any subsequent hits to the page is just loaded from the variable, and no database activity goes on...
here's a run down of the parameters:

<b>name</b>- text = name of the application/session var

<b>scope</b>- text = Session or Application... (i'm making it a text box for now, but I'l put a drop down or something later)

<b>conn</b>- db connections = what connections are available

<b>table</b>-db tables = what table it comes from

<b>value</b>-db columns = for the "value" parameter of the dropdown

<b>text</b>-db columns = the label for the options

<pre id=code><font face=courier size=2 id=code>
&lt;% if trim(@@scope@@("@@name@@") = "" then
dim @@name@@CacheListrs, @@name@@SQL, @@name@@
@@name@@SQL = "SELECT @@value@@, @@text@@ FROM @@table@@ order by @@text@@"

set @@name@@CacheListrs = server.createobject("adodb.recordset"
@@name@@CacheListrs.activeconnection = MM_@@Conn@@_STRING
@@name@@CacheListrs.source =@@name@@sql
@@name@@CacheListrs.open

@@name@@ = "&lt;select Name=""@@name@@""&gt;&lt;option value=""" & @@name@@CacheListrs.GetString( , , """&gt;", "&lt;option value=""", "-Null-" & """&gt;&lt;/select&gt;"

@@name@@CacheListrs.close
set @@name@@CacheListrs = nothing

@@scope@@("@@name@@" = @@name@@ & "&lt;/select&gt;"

end if
response.write @@scope@@("@@name@@"%</font id=code></pre id=code>

here's a screen shot of the error as I apply it:
<img src="www.awbhealthchoice.com/dbdaddy/images/jserror.jpg" border=0>

again, thanks in advance,
Joel Martinez

----------
Is this thing on?....

That's a strange bug. Could you please send the xml and htm files that make the extension to me? Also send me the controls you are using. I can't replicate it over here. Please sent them to me in a zip, so not in an mxp file.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

I emailed you the zip waldo...

----------
Is this thing on?....

I've sent you a working version of your extension. Feel free to ask any questions when you don't understand the explanation I gave you.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

SWEEEETTTTTT

thanks a million... keep up the good work...

----------
Is this thing on?....

Haha, feel free to submit it to UDzone when you think it is usefull <img src=icon_smile_wink.gif border=0 align=middle>

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------