All Forums >> [Scripting] >> ASP >> inserting data in MS access 2000 Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
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:
quote: I walked the dog
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#`=296 [/Code]
Is there a way to insert the fieldname:?? of every single record ( one shot ) by using ASP into the database?
Dear gilgalbiblewheel, I don't think i had understanded u, but take my advice and don't asign numbers for each letter, cause when it gets bigger might find some problems and some Difficulties, so use this template code:
so in this way the H=E e=b l=i o=l and so on...
then when u want to put them back to reall senence, simply change the + into -
All Forums >> [Scripting] >> ASP >> inserting data in MS access 2000 
Printable Version
inserting data in MS access 2000 - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread