ekendricks
Posts: 34
|
| Posted: 08/13/2005, 5:49 PM |
|
Using Access 2k - CCS - ASP
I have a database with: Table "ezEvent" , Field "Misc", Field Type "Memo". This table was done by someone else, and the misc field is used to hold data for 15 different variables. What I need to do is, build record grids, reports, etc, that returns records that match info in -say- position #11, some other position or a combination of positions.
I have tried "Select * from ezEvent WHERE Misc like '*|*|*|*|*|*|*|*|*|*|<PatientID>|*'"
Can someone shed some light on if and how this can be done. If you're kind enough to assist, please be specific and detailed, as I'm totally lost here.
Thanks
Ernest
|
 |
 |
peterr
Posts: 5971
|
| Posted: 08/15/2005, 12:04 AM |
|
You may need to extract some SQL samples from the other application that this database was used with. Or at least create and test some SQL statement directly against the database, without using CCS.
Once you know that you have a working SQL then you can apply it within CCS.
Assuming that your above SQL is working against the database (outside of CCS) then I suspect that in CCS it would need to be adjusted like this:
"Select * from ezEvent WHERE Misc like '%|%|%|%|%|%|%|%|%|%|{PatientID}|%'"
Then you'd need to create a parameter called "PatientID" and specify if its value should be taken from an URL/search parameter, session, etc.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
