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 herehttp://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009and herehttp://www.gregeisenman.info/blogs/greg/views-2-and-drupal-adding-custom-field-views-querybut most are just write ups.

Thanks its time i start figuring this out

On Mon, Aug 3, 2009 at 5:54 PM, larry@garfieldtech.com < larry@garfieldtech.com> wrote:

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.

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.

Steve wrote:

...

Hi guys

I would like to implement a function on my drupal site that will give two search option for example

A Identification number A Personal File number

The information to be queried will be imported from SQL server Database to my drupal database custom table.

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

Can i do it with CCK or webform?

Help me out how can i implement this

Thanks

---

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]