Live Data Settings

[digitaldramzus]

Does anyone know how to set up live data settings? If you want my html file and
my access database file I will be happy to email them. I have apache setup on
this computer as a web server. I have a database that I did in Access and I
pulled them into dreamweaver in a new recordset but everytime I click on Live
Data button then hit F12 to view it, it keeps popping up a window asking if i
want to download or open the musicdownloads.asp page that is a page that I
titled that has a list of music on it once i get the database to working so i
can view it on my computer before i upload to ftp server. If any other q's you
can also reach me at [email]webmaster@vineyard.atthecenter.com[/email].


Thanks,
Mark

[Nancy Gill]

Once you have the query on the page, clicking the Show Live Data button
should show your page with the data on it. There is an option to Set Live
Data Settings .. that is where you would put in the variable name and a
valid value for testing purposes. Not doing so will pull in the first
record (the default) or all of them if there is a repeat region on the page.

> everytime I click on Live
> Data button then hit F12 to view it, it keeps popping up a window asking

if i

> want to download

What server model are you using? Is it PHP? PHP in DMX is not set up to
run Access .. you need MySql. There is an addon called PHAkt that will
allow PHP to work with ADODB (and thus Access) available at
[url]http://www.interaktonline.com[/url]

If you're trying to run ASP, you can't do that on Apache without ChiliSoft
installed (and from what I hear, it's a nightmare).


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

[digitaldramzus]

Well what is the value and the value that i need to put in? I have 1 table
(tblArtist) that has artistID, artistName, artistDesc fields in it and anothe
table (tblDownloads) that has trackID, trackName, trackPrice, trackPayloadz in
it that all are selected in the query with one extra field in tblDownloads
called artisID and artistID are the the relationship between the two tables. I
do have info in the tblArtist that when i create a query it doesnt show the
info in the query when it pops up. I also am using
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path to database.mdb.

As for dreamweaver all i am running is Apache on a laptop. I am not using any
PHP or MySQL or anything like that plus I wouldn't know how to set it up. With
apach I just have all the websites tht i dop in the htdocs folder within the
apache group program file folder. I downloaded the PHAkt extension but what do
i do from there when i ad it to the extensions folder. If you want I can send
you a link to the ftp folder where you can download all the files and and
necessary images i am using and the access database and look at all of it to
get a better understanding of how it is set up. Also i am using ASP/VBScript as
the document type when i go to window then click on databases.

Thanks for the info so far though Nancy.


Mark