I have the following problem: I need to check some numbers on a webpage. First I pass an identifier and then I have to check the results. Problem is, that there are not only different results but also a different amount of them.
So I searched the Forum and found that one part of my solution would be using an sql-server / database.
Actually I have one Table with the identifier and an unique ID to that
Table: dbo.DUS
Fields:
DU_ID - the unique ID
DU_TEXT - the identifier
which gives "the main loop" for the test.
And then a second one with the data to check, which creates the "sub-loop" beneath each "main loop"
Table: dbo.Timecodes
Fields:
DU_ID - Linked to the unique ID above
Feldname
Timecode } these three fields have to get verified
Bildname
I also created a stored procedure named dbo.usp_TimeCodesPerDU which accepts one parameter called @DU_IDPara. This basically does this:
Code: Select all
SELECT * from dbo.Timecodes where DU_ID = @DU_IDPara
Now I need to somehow use this data in my module. Actually I have successfully made an module which checks the data coming from that connection using the default-value for @DU_IDPara but I am somewhat stuck how to integrate the changing of the connection-string into my module.
I found some postings from @krstcs but was not able to follow him, I think because of him using some classes(?) or other elements in his codes that I don't have or know.
If anyone has a not too fancy code-snippet ideally with some explanations, that would be great!
Thanks in advance!
Best regards,
Frank
PS: If you need any informations to understand better what I want to do please let me know!