gilgalbiblewhee
New member
- Local time
- Today, 03:27
- Joined
- Mar 19, 2005
- Messages
- 9
So far I have added a column in my table by ASP and vbscript which breaks down the sentences of the previous column and analyzes each letter ( that I've previously assigned a number to each letter a=1,b=2...). SO this extra column takes each word in the sentence of the previous column and shows the sum of the letters.
Example:
walked=100 ( a phony number )
the=50 ( a phony number )
dog=80 ( a phony number )
My question is how can I search a specific ( like 134 ) number and let the computer find every word in the fieldname I search and bring up the combination of letter or the different words that sum up to the value of the number ( like 134 )?
I think one important step is to somehow enter the values in an extra field in my MS Access 2000 database table, right? If that's the easiest way, does the Access have special functions for me to quickly go through this?
For example I have this result in ASP/vbscript:
Is there a way to insert the fieldname:?? of every single record ( one shot ) by using ASP into the database?
Example:
I=9
walked=100 ( a phony number )
the=50 ( a phony number )
dog=80 ( a phony number )
My question is how can I search a specific ( like 134 ) number and let the computer find every word in the fieldname I search and bring up the combination of letter or the different words that sum up to the value of the number ( like 134 )?
I think one important step is to somehow enter the values in an extra field in my MS Access 2000 database table, right? If that's the easiest way, does the Access have special functions for me to quickly go through this?
For example I have this result in ASP/vbscript:
Code:
fieldname: text_data
bravyt bra alhy~ at hvmy~ wat har#`
fieldname:??
Number of words: 7
Total=2701
bravyt=913
bra=203
alhy~=86
at=401
hvmy~=395
wat=407
har#`=296Is there a way to insert the fieldname:?? of every single record ( one shot ) by using ASP into the database?
Ken