To access database table

[g***@cybercomgroup.com]

Hi,

I would like to get the product id of one particular product from the db. I have partNumber in my hand and nothing else. Is it possible for me to get it. If so pls lead me with directions pls. This is an urgent request..

regds,
Geetha

[Robert Brown]

select catentry_id, partnumber, member_id from catentry where partnumber
= '<your partnumber>'

This will probably only return one row - although multiple rows could
exist if owned by multiple member IDs.

R

Post by g***@cybercomgroup.com
Hi,
I would like to get the product id of one particular product from the db. I have partNumber in my hand and nothing else. Is it possible for me to get it. If so pls lead me with directions pls. This is an urgent request..
regds,
Geetha