Digital Workshop

Hello, I am struggling a bit with an access database.

I have created a database in access with two tables, Match and Scoreboard.

The datasourcename I have specified exists. How would I make the DSN path always refer to the publication root directory?

I have this code in a script file which is called when the page opens.

[code]English01.Show()




var dataSourcePath = "FILEDSN=C:\Documents and Settings\Administrator\My Documents\Dunix\Projects\Zai\MatchingGame\Opus Project\Database\MatchingGameDataSource.dsn;"

var matchDatabase = new Database(dataSourcePath)


if (matchDatabase.Connect())
{


English03.Show()


var results = matchDatabase.ExecuteSQL("SELECT * Match")


English04.Show()

English04.SetText("Test")

}[/code]


The connection fails and none of the other text boxes get shown (English0x.Show()).

Am I doing the connection correctly?

Also, how do I change the text value of a text box?

And finally, how do I read the data I pulled back data from the database? I have gone through all the manual and I cannot see how.

I would prefer to code everything myself in script objects.

Anyone?

Look at the last five tutorials on this page.

viewforum.php?f=13

Paul

So you cant do it through scripting entirely then? My aim is to pull back the data, loop through it and put it into an array. Then randomly select records from the array.

Anyone?

Yes you can script the whole thing.

Use the instructions in the database section (functions) of the manual. It explains how to connect, create a loop (GetNumberOfRecords()) and then you read these into an array.

Use the random number function (max records) to pick a random record. There is also lots of example already posted on the forum for scripted DBs.

Mack

zes,

Try reworking this part a bit.


Some general observations.

1- most times I see that paths in Opus require \\ to represent the usual \ when in a string.
2- var dataSourcePath --- I've had trouble with putting expressions in strings. Sometimes I've had to break them down and then use the eval() command... which is a great tool, but I found tricky to master.
3- isn't the var 'matchDatabase' an object? Then, does the if statement operate correctly? Testing for an object? Maybe make it more explicit, e.g. == true, or verify it exists?

If you're following the manual and a good sample script on databases in Opus, then my comments may not apply.

p.s. Are you using Vista?
The path shown about would indicate you are running on WinXP or such.

maybe little mistake: ExecuteSQL("SELECT * FROM Match")


zesmail, write about your successes, I have similar problems:)

Yes, I did forget the FROM statement. I had actually fixed that bit a while ago. The issue was actually using "\" instead of "\\". Once I used "\\" instead it all started working nicely!

Thanks for everyones help.