Logon Sample for Authorware
Contents
1. l im GoldenGate Database Connector First Steps For Macromedia Authorware Version 1 0 integration new media 2001 2002 Integration New Media Inc 2002 02 18 Table of Contents Table of Contents Introduction Before you Start Firewall considerations Explore the landscape Initializing GoldenGate Searching Data SetCriteria Select The Is nickname unique calc icon Retrieving Data GetField Retrieving the user s last name Adding a New Record AddRecord SetField UpdateRecord The Create new account calc icon Appendix Database Structure GoldenGate Database Connector First Steps for Authorware Introduction Thank you for using GoldenGate Database Connector This First Steps manual is a quick overview of GoldenGate s most common features It uses the Logon sample Authorware piece provided at http www GGdbc com getting started aw to illustrate e How an Authorware piece opens a connection to a GoldenGate server e How to search data e How to retrieve data e How to modify data In these First Steps you will use your own Authorware piece and connect to Integration New Media s GoldenGate and MS SQL Servers through the Internet Most of all you will realize that all of this requires very little scripting in Authorware and no scripting at all on the server side GoldenGate Database Connector First Steps for Authorware 3 Before you Start Before you start make sure that y2. EnteredFavoritecolor callobject Gers SetField Mission EnteredMissionInLi fe Initialize the fields that do not depend on user interface The current date and time is formatted as a property list and assigned to DTlist in the Get Current DateTime calc icon Callobject Gers SetField LastLogon DTlist callobject GGrs SetField NumberofLogons 1 Save the record to the database Ccallobject GGrs UpdateRecord GoldenGate Database Connector First Steps for Authorware 9 Appendix Database Structure The MS SQL database used by the Logon Sample is hosted at Integration GoldenGate Database Connector also New Media supports Oracle MySQL and other ODBC compliant databases See http www GGdbe com for details Its structure is ti 2 Design Table Users in FirstSteps __ FirstName varchar 50 Last ame varchar 50 Nickname varchar 50 Password varchar 50 KKK FavoriteColor varchar 50 LastLogon datetime 8 __ NumberOfLogons int 4 _ Mission varchar 200 Columns Description Default Yalue Precision 10 Scale 0 Identity Yes Identity Seed 1 Identity Increment 1 Is RowGuid No Formula Collation GoldenGate Database Connector First Steps for Authorware
3. ds selected with Selectcount browse through the selected records with GoNext GoPrevious GoFirst GoLast and Go retrieve data with GetFie1d etc The Is nickname unique calc icon This is the logic behind the Is nickname unique calc icon in the map Create a new account 1 Tell GoldenGate to search for all records who s Nickname field equals the user s entry callobject GGrs Setcriteria Nickname EnteredNickName 2 Trigger the search callobject GeGrs Select 3 Ask GoldenGate how many records were found n Callobject GGrs SelectCount 4 Ifone or more records were found i e the nickname already exists tell the user to pick another nickname if n gt 0 then ErrorMessage This nickname already exists in the database Please choose another one GoTo IconID Show Message and Retry end if GoldenGate Database Connector First Steps for Authorware 7 Retrieving Data In the Logon a p file data is retrieved from the remote database for a few different reasons such as e matching a nickname s password against the one supplied by the user or e retrieving the user s first name last logon date and number of logon s to display on the Welcome screen In this section you will learn how to retrieve the user s last name from the database and display it on the Welcome screen GetField Data retrieval is primarily performed by the GetField method as in this thendaratremeva
4. ltmethocdeiare excerpt from the Logon calc icon in map Logon using my nickname and GetSelection and GetMedia password See the GoldenGate Developers fName Callobject GGrs GetField FirstName Mora es ue This statement retrieves the content of the field FirstName of the current record in table GGrs which refers to table Users as shown in Initializing GoldenGate 3c Retrieving the user s last name 1 To modify the Logon calc icon and make it display the user s last name As shown inAppendix Database as well as the first name and logon information first add this statement Structure the user s last name is stored shown in bold ina field named LastName which is Name Callobject GGrs GetField lastName the parameter passed to GetField fName Callobject GGrs GetField FirstName NumberOfLogons CallObject GGrs GetField NumberOfLogons LastLogon Callobject GGrs GetField LastLogon d MMMM yyyy hh mm ss 2 Then modify the assignment to successMessage to include in bold SuccessMessage welcome back A fName A 1Name Return A You successfully logged into the system AReturn Run the project e e meo perati on NOME 4 Log on with the nickname and account you created earlier in Explore the involved server side script modification query encoding result landscape parsing and or character set translation The Welcome screen will now display both your first and last name in tech
5. nologies other the GoldenGate GoldenGate Database Connector First Steps for Authorware 8 It is always a good practice to initialize all the fields of a new record In this case it is not necessary to initialize the ID field because it is defined to automatically increment in the database See database structure in Appendix Database Structure Adding a New Record In Logon a p a new record is added to the remote database every time a new account is created This is performed by the create new account calc icon This section will show you how it is implemented AddRecord SetField UpdateRecord To add anew record with GoldenGate 1 First call AddRecord to create a blank record The new record is not saved to the database yet Then call setField as many times as needed to populate the fields of the new record Finally call updateRecord to save the new record to the database The Create new account calc icon This is the logic behind the create new account calc icon in map Create a new account 4 Tell GoldenGate to add a blank record callobject GGrs AddRecord Assign user s entry to the fields of the new record callobject Gers SetField FirstName EnteredFirstName callobject Gers SetField LastName EnteredLastName Ccallobject Gers SetField NickName EnteredNickName callobject Gers SetField Password EnteredPassword Ccallobject GGrs SetField Favoritecolor
6. of the movie will only use the gT global variable to search retrieve and store data gps and gcx will not be directly used GoldenGate Database Connector First Steps for Authorware 6 GoldenGate is also able to perform searches on other types of data fields numerals dates etc with a wide range of comparison operators greater smaller within range full text etc See the GoldenGate Developer s Manual for details Searching Data Although GoldenGate accepts SQL statements for advanced data searching knowledge of SQL is not required in most projects thanks to GoldenGate s simplified API In Logon a p data is searched in two different situations e When granting access to a nickname password combination to identify a nickname s record and make sure the user supplied password matches the one stored in that record This is done in the Logon using my nickname and password map in the Logon calc icon e When creating a new account to make sure a nickname is unique before adding it to the database This is done in the create a new account map inthe Is nickname unique calc icon SetCriteria Select Searching data is performed in two steps in GoldenGate e Call setcriteria with one or more search criteria as in callobject GGrs Setcriteria Nickname nick e Call select to actually trigger the search process on the server as in callobject Gers Select Then you are ready to check the number of recor
7. ou have e Authorware 4 or later for MacOS or Windows e The Logon sample Authorware piece available from http www GGdbc com getting started aw e The GoldenGate Client Xtra for Auhtorware available from http www GGdbce com and that it is located in Auhtorware s Xtras folder e An Internet connection Firewall considerations If you are using these First Steps with a GoldenGate Server installed on your own computer or local area network you don t need to worry about firewall issues It you want to connect to the GoldenGate Server located at Integration New Media and if you are behind a firewall and if your firewall is configured to disallow outbound queries ask your system administrator to allow outbound queries from your computer so your GoldenGate client can contact the GoldenGate Server located at Integration New Media You don t need to worry about firewall issues in all other situations GoldenGate Database Connector First Steps for Authorware 4 Explore the landscape First run the Logon piece and make sure it works properly on your computer and make sure it works properly on your computer e Create anew account e Try to logon using your newly created nickname and password e Keep your nickname and password on hand as you will need them in the next few steps GoldenGate Database Connector First Steps for Authorware Logon a p stands for Logon a4p Logon a5p or Logon a6p depending on you
8. r version of Authorware version 4 5 or 6 If both the server and the client are running on your own computer use localhost as the Server name instead of GG IntegrationNewMedia com Initializing GoldenGate 1 Open the Logon a p file 2 Open the Initialize GoldenGate calc icon in red 3 Opening a connection to the remote database is a three step process a Open a connection to the GoldenGate Server GGcx NewObject GGConnection GG IntegrationNewMedia com 1729 AnyUser top secret where GGConnection is the GoldenGate connection Xtra s name GG IntegrationNewMedia com is the GoldenGate Server s name hosted at Integration New Media 1729 is the GoldenGate Server s TCP IP port Anyuser is the name under which your project will identify itself when connecting to the GoldenGate Server top secret is AnyUser s password b Open a database instance GGdb NewObject GGdbe GGcx FirstSteps where GGDBE is the GoldenGate database Xtra s name gcx is the connection instance created above FirstSteps is the GoldenGate database connector s name It resides on the GG IntegrationNewMedia com server c Open a table instance GGrs NewObject GGRecordSet GGdb Users where GGRecordSet is the GoldenGate recordset Xtra s name gbB is the database instance created above users is the name of the table required by this project It resides in the database identified as FirstSteps The rest
Download Pdf Manuals
Related Search