Database Checkpoint

[amilar]

Hi All,

I have a problem in database checkpoint. I know how to do a database checkpoint. But I don’t know how it integrates or put it with a web application.

As an example, when I want to check search value with database value, how can I do it?. How do I connect database checkpoint with my search result window or grid.

If any one knows about any idea, please let me know. Thanks

regards,
Amila

[Jackomcnabb]

[amilar]

Thanks,

I wrote a function for database connection and select query, but i can't retrieve data from the function. if u know the way please let me know... thanks.


my function

Code:

Function ConnectDatabase() dim Cnxn,strCnxn dim rsCus,strSQL set Cnxn = CreateObject("ADODB.Connection") set rsCus = CreateObject("ADODB.RecordSet") strCnxn ="DRIVER={Microsoft ODBC for Oracle};UID=amilar12;PWD=mypass;SERVER=TEST_DB_DOMAIN.ORG" Cnxn.Open strCnxn msgbox "connect" strSQL ="select * FROM aa_mgr.jms_messages " rsCus.Open strSQL,Cnxn end function

Regards,
Amila

[Jackomcnabb]

when you call the function you need to what variable that you are going to retrieve:

Code:

<VariableName>=<FunctionName>

my code is like this:

Code:

RecordNumbers = get_record_counts (PartialName, PartialNameCounty, PartialNameCity, IncludeAbbrev,Search_Level, Show_Full, Search_Method)