Solved

Irish girl in need of help!

Posted on 2002-03-22
6
211 Views
Last Modified: 2010-04-02
I've got a web based application where students submit which subjects they want to take for the next semester and Administrators submit what subjects are available and what grade is required for each. All this info is then stored in an Access Database then after a date specified by the administrator which is also stored in database, I want a procedure to run which will allocate modules to the students according to there Grade.

Any ideas, help or links?
Bearing in mind that my knowledge in this area is limited.

Thanks
0
Comment
Question by:dessie
6 Comments
 
LVL 6

Expert Comment

by:Triskelion
ID: 6890128
Is this to be done in C++?
Is it a CGI?

What do you mean by 'module'?
If the stuff is in a database, you can issue SQL to the database to update the records by grade (in the 'where' clause) and allocate modules.

Can you shed som more light on what you're trying to do?
0
 
LVL 30

Expert Comment

by:Axter
ID: 6890132
You should try posting this question on the Access topic link.

http://www.experts-exchange.com/jsp/qList.jsp?ta=msaccess


I don't see a C++ requirement.
0
 
LVL 30

Expert Comment

by:Axter
ID: 6890135
FYI:

You could do this in C++, but IMHO, you would be making it harder on yourself.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 14

Expert Comment

by:AlexVirochovsky
ID: 6890699
May be ypu want work from C++ with Access DB. In such case see:
Other way see
http://www.1cplusplusstreet.com/xq/ASP/txtCodeId.1371/lngWId.3/qx/vb/scripts/ShowCode.htm
....
//**************************************
//    
// Name: Access MDB
// Description:To open MS Access or Ms S
//     QL server database using C/C++ or VC++
// By: Mokarrabin A Rahman
//
// Returns:Shows some recordsets
//
// Assumes:Change the name of the databa
//     se to any database and place it in the s
//     ame directory as the .exe. You shoul als
//     o change the SQL to your particular data
//     base. You may change the connect string
//     to connect to MS SQL Server.
//
// Side Effects:Great
//
//This code is copyrighted and has// limited warranties.Please see http://
//     www.1CPlusPlusStreet.com/xq/ASP/txtCodeI
//     d.1371/lngWId.3/qx/vb/scripts/ShowCode.h
//     tm//for details.//**************************************
//    

#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
// This code comes from : www.geocities.
//     com/mokarrabin
#include <stdio.h>
#include <iostream.h>
void main(void)


 {
 CoInitialize(NULL);
 try


     {
     _RecordsetPtr pRst("ADODB.Recordset");
     // Connection String
     _bstr_t strCnn("DRIVER={Microsoft Access Driver (*.mdb)};UID=admin;DBQ=GBOOK.mdb");
           // Open table
          pRst->Open("SELECT * FROM ProductService where ProductService like '%samir%';", strCnn,

adOpenStatic, adLockReadOnly, adCmdText);
           
           pRst->MoveFirst();


               while (!pRst->EndOfFile) {
                    cout<<(char*) ((_bstr_t) pRst->GetFields()->GetItem("ProductService")->GetValue())<<endl;
                    pRst->MoveNext();
               }
               pRst->Close();
               
     }
     catch (_com_error &e)


         {
         cout<<(char*) e.Description();
     }
     ::CoUninitialize();
 }
....
0
 
LVL 11

Expert Comment

by:griessh
ID: 6956050
Dear dessie

I think you forgot this question. I will ask Community Support to close it unless you finalize it within 7 days. You can always request to keep this question open. But remember, experts can only help you if you provide feedback to their questions.
Unless there is objection or further activity,  I will suggest to

     "PAQ at zero points"

since you never gave more feedback.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
======
Werner
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 6979136
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing generic code, using template meta-programming techniques, it is sometimes useful to know if a type is convertible to another type. A good example of when this might be is if you are writing diagnostic instrumentation for code to generat…
In days of old, returning something by value from a function in C++ was necessarily avoided because it would, invariably, involve one or even two copies of the object being created and potentially costly calls to a copy-constructor and destructor. A…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now