Thanks just the direction i needed Yes it is a read-only data and i need to expose it to drupal. Do you have links of how this is implemented or the exact link of the views documentation i would appreciate. I have checked out some <a href="http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009">here</a> and <a href="http://www.gregeisenman.info/blogs/greg/views-2-and-drupal-adding-custom-field-views-query">here</a> but most are just write ups. <br>
<br>Thanks its time i start figuring this out<br><br><div class="gmail_quote">On Mon, Aug 3, 2009 at 5:54 PM, <a href="mailto:larry@garfieldtech.com">larry@garfieldtech.com</a> <span dir="ltr"><<a href="mailto:larry@garfieldtech.com">larry@garfieldtech.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">CCK and webform won't really help you here. If this data is read-only, and you just want to expose it to Drupal, I'd recommend adding Views integration hooks for that table. Then you can build lists and queries against it using Views, including exposed filters that you can use as a search form.<br>
<br>
The Views documentation has more details. I also recommend the table wizard module, which can greatly speed up the process of writing the necessary hooks.<br>
<br>
Steve wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
Hi guys<br>
<br>
I would like to implement a function on my drupal site that will give two search option for example<br>
<br>
A Identification number<br>
A Personal File number<br>
<br>
The information to be queried will be imported from SQL server Database to my drupal database custom table.<br>
<br>
When the user visits the site he/she can serch for information about his/her file by entering the number in that field and gets back the information<br>
<br>
Can i do it with CCK or webform?<br>
<br>
Help me out how can i implement this<br>
<br>
Thanks<br>
<br>
<br></div></div>
------------------------------------------------------------------------<br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote></div><br>