Dreamweaver - Hello and noobie first few questions

Author

Hello and noobie first few questions

2Drunk2Funk

2004-08-13, 12:15 pm

Hello
Been using dreamweaver for a week now, love the product and slowly getting to
grips with the basics :)
Couple of questions if I may which I am sure you can answer easily.

1. When I use the database tab to open/look at my Access DB for an ASP page,
it Locks the database exclusively and consequently when I got to test I get an
error. Looked at options in and around the database tab but cannot see anything
to ensure it only opens with shared access. I am currently having to close DW
down and restart it to remove lock :( . Is there something I can set to stop
this ?

2. I found the Live data settings to pass info to my first ASP page, which
works in the design view live data fine. However when I press F12 for browser
check the parameters do not seem to get passed to the ASP file, nothing in the
address bar. How do I pass these to emulate the ASP being called?

3. Doing a form, some fields added. However some of the text boxes are filled
in yellow and some are not, cannot see what is doing this, any ideas?

Thanks for any responses, I will try not to ask to many novice questions. :D

Murray *TMM*

2004-08-13, 12:16 pm

> 1. When I use the database tab to open/look at my Access DB for an ASP
page,
> it Locks the database exclusively and consequently when I got to test I
get an
> error. Looked at options in and around the database tab but cannot see
anything
> to ensure it only opens with shared access. I am currently having to close
DW
> down and restart it to remove lock :( . Is there something I can set to
stop
> this ?

I'm not exactly sure what you are asking here because I don't know what you
mean when you refer to the database tab. But when you preview a dynamic
page (or edit the recordset) using DW, the database will indeed be locked.
You can break this lock by previewing (or editing the recordset) on ANOTHER
page that references a non-existent DSN. I usually keep a page in all my
dynamic sites called "release.asp" for just this purpose. To unlock the
database, I just open that page and edit the recordset. I am also told that
you can avoid the problem altogether by moving the database to a location
outside the site's root, but I have not tried that.

> 2. I found the Live data settings to pass info to my first ASP page,
which
> works in the design view live data fine. However when I press F12 for
browser
> check the parameters do not seem to get passed to the ASP file, nothing in
the
> address bar. How do I pass these to emulate the ASP being called?

Sorry - I'm not sure.

> 3. Doing a form, some fields added. However some of the text boxes are
filled
> in yellow and some are not, cannot see what is doing this, any ideas?

You have installed the Google toolbar in IE.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"2Drunk2Funk" <webforumsuser@macromedia.com> wrote in message
news:cfi8go$mfk$1@forums.macromedia.com...
> Hello
> Been using dreamweaver for a week now, love the product and slowly
getting to
> grips with the basics :)
> Couple of questions if I may which I am sure you can answer easily.
>
> 1. When I use the database tab to open/look at my Access DB for an ASP
page,
> it Locks the database exclusively and consequently when I got to test I
get an
> error. Looked at options in and around the database tab but cannot see
anything
> to ensure it only opens with shared access. I am currently having to close
DW
> down and restart it to remove lock :( . Is there something I can set to
stop
> this ?
>
> 2. I found the Live data settings to pass info to my first ASP page,
which
> works in the design view live data fine. However when I press F12 for
browser
> check the parameters do not seem to get passed to the ASP file, nothing in
the
> address bar. How do I pass these to emulate the ASP being called?
>
> 3. Doing a form, some fields added. However some of the text boxes are
filled
> in yellow and some are not, cannot see what is doing this, any ideas?
>
> Thanks for any responses, I will try not to ask to many novice questions.
:D
>
>

2Drunk2Funk

2004-08-13, 12:16 pm

1. My db is outside of the web setup, i have the database directory one higher
then the root of the local web start.
Also not completely sure what you mean when talking about a release.ASP, what
detail does it contain?

2. I want my defaut.asp to start with some variables, like
&caller=xxxxxxx&port=1234 etc
In the view menu you can set these up under Live data settings, which works in
the development environment, however they do not get appended to the url when
calling the page using F12 to get the "real" browser view.

3. I do have the google bar, I guess it is to do with known names then, thx

Murray *TMM*

2004-08-13, 12:16 pm

Here is my release.asp file -

<%@LANGUAGE="VBSCRIPT"%>

<%
Dim rsRelease
Dim rsRelease_numRows

Set rsRelease = Server.CreateObject("ADODB.Recordset")
rsRelease.ActiveConnection = MM_connRelease_STRING
rsRelease.Source = "SELECT * FROM subscribers"
rsRelease.CursorType = 0
rsRelease.CursorLocation = 2
rsRelease.LockType = 1
rsRelease.Open()

rsRelease_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

</body>
</html>
<%
rsRelease.Close()
Set rsRelease = Nothing
%>

And I told you incorrectly. The "connections" include refers to a DSN on
another site with another database.

> 2. I want my defaut.asp to start with some variables, like
> &caller=xxxxxxx&port=1234 etc
> In the view menu you can set these up under Live data settings, which
works in
> the development environment, however they do not get appended to the url
when
> calling the page using F12 to get the "real" browser view.

Sorry, I don't know the answer to this one.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"2Drunk2Funk" <webforumsuser@macromedia.com> wrote in message
news:cfieoq$t3a$1@forums.macromedia.com...
> 1. My db is outside of the web setup, i have the database directory one
higher
> then the root of the local web start.
> Also not completely sure what you mean when talking about a release.ASP,
what
> detail does it contain?
>
> 2. I want my defaut.asp to start with some variables, like
> &caller=xxxxxxx&port=1234 etc
> In the view menu you can set these up under Live data settings, which
works in
> the development environment, however they do not get appended to the url
when
> calling the page using F12 to get the "real" browser view.
>
> 3. I do have the google bar, I guess it is to do with known names then,
thx
>
>
>

2Drunk2Funk

2004-08-13, 7:16 pm

Thanks for release idea, I created one from your pasted example (removed include and just did dummy DSN string) and it appears to work :)

Murray *TMM*

2004-08-13, 7:16 pm

You're welcome!

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"2Drunk2Funk" <webforumsuser@macromedia.com> wrote in message
news:cfio6f$a3o$1@forums.macromedia.com...
> Thanks for release idea, I created one from your pasted example (removed
include and just did dummy DSN string) and it appears to work :)
>
>