Hi all, just wanted to pose a very General question about an application I have created. Namely: How can I improve it and have I missed obvious coding techniques etc. Basically I will run down how I have written the code at a very rough level, detailing any issues I have had. Hopefully some of you will know of the best ways to accomplish the tasks I have attempted, so that I may remove some workarounds and generally improve my application. I don't want anyone to go to a lot of trouble for me though 
. Even the mention of a keyword or useful function will help, I can research it and learn to use it without bothering to ask to many questions I hope. Without further ado this is what I have been trying to accomplish:
1. receive an input string. This string is broken up into words and checked for validity
2. search a table for each word. And assign each word attributes according to the table (wordtype etc.)
3. search a separate table for a construct of these words. By separating each word according to its wordtype I search for a match in the next table under each column associated with that wordtype (hope that makes sense). This is one of the bits that I cant decide on. I have solved the problem a number of ways and am wondering what is most efficient/maintainable etc. (such as manually structuring sql queries, and using complicated WHERE clauses with passed parameters - almost always including passed null values )
4. structure the results as xml file. Havent considered this bit yet but cant see to many other ways to do it other than text manipulation and a bit of boredome working out permutations.
5. sending the file to a predefined location. ?? not an issue atm.
I have lots more questions like how to make an install file etc that I can find out for myself with just an arrow in the right direction etc but are not to pressing on me. I would just be stoked if anyone is interested in helping me to optimize and fortify my code and processes.
Thanks in advance to anyone that has had the time to read all this and thanks more if you feel like lending a brain.
. Even the mention of a keyword or useful function will help, I can research it and learn to use it without bothering to ask to many questions I hope. Without further ado this is what I have been trying to accomplish:1. receive an input string. This string is broken up into words and checked for validity
2. search a table for each word. And assign each word attributes according to the table (wordtype etc.)
3. search a separate table for a construct of these words. By separating each word according to its wordtype I search for a match in the next table under each column associated with that wordtype (hope that makes sense). This is one of the bits that I cant decide on. I have solved the problem a number of ways and am wondering what is most efficient/maintainable etc. (such as manually structuring sql queries, and using complicated WHERE clauses with passed parameters - almost always including passed null values
)4. structure the results as xml file. Havent considered this bit yet but cant see to many other ways to do it other than text manipulation and a bit of boredome working out permutations.
5. sending the file to a predefined location. ??
not an issue atm.I have lots more questions like how to make an install file etc that I can find out for myself with just an arrow in the right direction etc but are not to pressing on me. I would just be stoked if anyone is interested in helping me to optimize and fortify my code and processes.
Thanks in advance to anyone that has had the time to read all this and thanks more if you feel like lending a brain
.
