Re: FLASH: database to Flash

[RedStar]

Cheri,


First of all I'll start out with some considerations, then I'll try to

address your problem.

Data in Excel can be accessed from external apps, of course.

The data contained in the spreadsheet must conform to some basic req's

but these are quite simple. A named list that contains all the data with

column labels will suffice for example.

Setting up the DSN is also quite simple and should offer no problem.

You can always test if the DSN is set up properly by using MSQuery. If

you can get results from the excel file then all is OK up to this point.

Now before going ahead a word of warning... Data contained in Excel

files is not the best idea if you are designing for the internet.

If you are building anything that will have more than a few hits you

will quickly see that this path brings some problems.

OK continuing...

Now that the excel DSN is set up and working how do we access the data.

Whatever the server setup we will be dealing with ODBC.

In your case ASP is a good choice because you are using the Personal

Server solution. Not trying to judge your decision I would anyhow

recommend you test the windows Apache solution. Unless your work is all

based on MS products you'll find that sooner or later you will be

working with Apache or at least having to deal with it. In this case I

would recommend PHP.


Now for your particular problem.

The partial code listing you have is correct. You start out by creating

a connection object and a recordset object then you open the connection.

This opens a path to the data but does not yet retrieve any data. You

now have to do a query on the data, only then will you have some

results. If you're not getting any errors with what you have now then it

is going OK. So try and create a query that will return some data from

your file.


.redstar.




flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Streaming Media WEST '99 Conference & Exhibition

  "The Worlds largest Internet Audio & Video Event"

 December 7 - 9, San Jose Convention Center, California


Reserve your space today at http://www.streamingmedia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com